本文整理汇总了PHP中getPotentialName函数的典型用法代码示例。如果您正苦于以下问题:PHP getPotentialName函数的具体用法?PHP getPotentialName怎么用?PHP getPotentialName使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getPotentialName函数的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getValue
function getValue($uitype, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, $mode, $popuptype, $returnset = '', $viewid = '')
{
global $log;
global $app_strings;
//changed by dingjianting on 2007-11-05 for php5.2.x
$log->debug("Entering getValue() method ...");
global $adb, $current_user;
if ($uitype == 10) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if ($temp_val != "") {
$value = "";
$module_entityname = "";
$modulename_lower = substr($fieldname, 0, -2);
$modulename = ucfirst($modulename_lower);
$modulesid = $modulename_lower . "id";
$tablename = "ec_" . $modulename_lower;
$entityname = substr($fieldname, 0, -3) . "name";
$query = "SELECT {$entityname} FROM {$tablename} WHERE {$modulesid}='" . $temp_val . "' and deleted=0";
$fldmod_result = $adb->query($query);
$rownum = $adb->num_rows($fldmod_result);
if ($rownum > 0) {
$value = $adb->query_result($fldmod_result, 0, $entityname);
}
} else {
$value = '';
}
} elseif ($uitype == 52 || $uitype == 53 || $uitype == 77) {
$value = $adb->query_result($list_result, $list_result_count, 'user_name');
} elseif ($uitype == 5 || $uitype == 6 || $uitype == 23 || $uitype == 70) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if (isValidDate($temp_val)) {
$value = getDisplayDate($temp_val);
} else {
$value = '';
}
} elseif ($uitype == 33) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
$value = str_ireplace(' |##| ', ', ', $temp_val);
} elseif ($uitype == 17) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
$value = '<a href="http://' . $temp_val . '" target="_blank">' . $temp_val . '</a>';
} elseif ($uitype == 13 || $uitype == 104) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
$value = '<a href="' . getComposeMailUrl($temp_val) . '" target="_blank">' . $temp_val . '</a>';
} elseif ($uitype == 56) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if ($temp_val == 1) {
$value = 'yes';
} else {
$value = 'no';
}
//changed by dingjianting on 2006-10-15 for simplized chinese
if (isset($app_strings[$value])) {
$value = $app_strings[$value];
}
} elseif ($uitype == 51 || $uitype == 73 || $uitype == 50) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if ($temp_val != '') {
$value = getAccountName($temp_val);
} else {
$value = '';
}
} elseif ($uitype == 59) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if ($temp_val != '') {
$value = getProductName($temp_val);
} else {
$value = '';
}
} elseif ($uitype == 76) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if ($temp_val != '') {
$value = getPotentialName($temp_val);
} else {
$value = '';
}
} elseif ($uitype == 80) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if ($temp_val != '') {
$value = getSoName($temp_val);
} else {
$value = '';
}
} elseif ($uitype == 1004) {
$value = $adb->query_result($list_result, $list_result_count, 'smcreatorid');
$value = getUserName($value);
} elseif ($uitype == 1007) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
$value = getApproveStatusById($temp_val);
} elseif ($uitype == 1008) {
$value = $adb->query_result($list_result, $list_result_count, 'approvedby');
$value = getUserName($value);
} elseif ($uitype == 1004) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
$value = getUserName($temp_val);
} elseif ($uitype == 1007) {
$temp_val = $adb->query_result($list_result, $list_result_count, $fieldname);
if ($temp_val == '1') {
$value = $app_strings["already_approved"];
} elseif ($temp_val == '-1') {
//.........这里部分代码省略.........
示例2: x10
private function x10($x92, $x93, $x94 = false, $x95 = false)
{
global $x15d, $x15e, $x15f, $x160, $x161, $x162, $x163, $x164, $x165, $x166, $x167, $x168, $x169, $x16a, $x16b, $x16c, $x16d, $x16e, $x16f, $x170, $x171, $x172, $x173, $x174, $x175, $x176, $x177, $x178;
$x96 = Users_Record_Model::getCurrentUserModel();
$x97 = array("related_to", "relatedto", "parent_id", "parentid", "product_id", "productid", "service_id", "serviceid", "vendor_id", "product", "account", "invoiceid", "linktoaccountscontacts", "projectid", "sc_related_to");
if ($x95 !== false) {
$x98 = array();
}
$x51 = getTabid($x92);
$x99 = $x92;
if ($x94 === false) {
$x9a = "";
} else {
$x9a = "R_";
if ($x94 !== true) {
$x99 = $x94;
}
}
$x9b = array();
$x9c = array();
$x9d = array();
$x9e = array();
$x9f = array();
$xa0 = array();
$xa1 = array();
if ($x51 == '9') {
$x3d = "SELECT fieldname, uitype FROM vtiger_field WHERE tabid IN (9,16)";
} else {
$x3d = "SELECT fieldname, uitype FROM vtiger_field WHERE tabid = '" . $x51 . "'";
}
$x3e = self::$x0f->query($x3d);
while ($x42 = self::$x0f->fetchByAssoc($x3e)) {
switch ($x42['uitype']) {
case '19':
case '20':
case '21':
case '24':
$x9d[] = $x42['fieldname'];
break;
case '5':
case '6':
case '23':
case '70':
$x9e[] = $x42['fieldname'];
break;
case '15':
$x9c[] = $x42['fieldname'];
break;
case '56':
$x9b[] = $x42['fieldname'];
break;
case '33':
$x9f[] = $x42['fieldname'];
break;
case '71':
$xa0[] = $x42['fieldname'];
break;
case '9':
$xa1[] = $x42['fieldname'];
break;
}
if ($x42["fieldname"] == "salutationtype") {
$x9c[] = $x42["fieldname"];
}
}
foreach ($x93->column_fields as $xa2 => $x83) {
if ($xa2 == "assigned_user_id") {
$x83 = $this->x1e($x83);
} elseif ($xa2 == "account_id") {
$x83 = getAccountName($x83);
} elseif ($xa2 == "potential_id") {
$x83 = getPotentialName($x83);
} elseif ($xa2 == "contact_id") {
$x83 = getContactName($x83);
} elseif ($xa2 == "quote_id") {
$x83 = getQuoteName($x83);
} elseif ($xa2 == "salesorder_id") {
$x83 = getSoName($x83);
} elseif ($xa2 == "campaignid") {
$x83 = getCampaignName($x83);
} elseif ($xa2 == "terms_conditions") {
$x83 = $this->x25($x83);
} elseif ($xa2 == "comments") {
$x83 = $this->x26($x93);
} elseif ($xa2 == "folderid") {
$x83 = $this->x27($x83);
} elseif ($xa2 == "time_start" || $xa2 == "time_end") {
$xa3 = DateTimeField::convertToUserTimeZone($x83);
$x83 = $xa3->format('H:i');
} elseif ($x168($xa2, $x97)) {
if ($x83 != "") {
$xa4 = getSalesEntityType($x83);
$xa5 = getEntityName($xa4, $x83);
if (!empty($xa5)) {
foreach ($xa5 as $xa6) {
$x83 = $xa6;
}
}
if ($xa2 == "invoiceid" && $x83 == "0") {
$x83 = "";
//.........这里部分代码省略.........
示例3: getListViewEntries
//.........这里部分代码省略.........
$account_id = $adb->query_result($list_result, $i - 1, "crmid");
//$account_name = getAccountName($account_id);
$account_name = textlength_check($adb->query_result($list_result, $i - 1, "accountname"));
// Fredy Klammsteiner, 4.8.2005: changes from 4.0.1 migrated to 4.2
$value = '<a href="index.php?module=Accounts&action=DetailView&record=' . $account_id . '&parenttab=' . $tabname . '" style="' . $P_FONT_COLOR . '">' . $account_name . '</a>';
// Armando Lüscher 05.07.2005 -> §priority -> Desc: inserted style="$P_FONT_COLOR"
} elseif ($module == 'Potentials' || $module == 'Contacts' || $module == 'Invoice' || $module == 'SalesOrder' || $module == 'Quotes') {
//Potential,Contacts,Invoice,SalesOrder & Quotes records sort by Account Name
$accountname = textlength_check($adb->query_result($list_result, $i - 1, "accountname"));
$accountid = $adb->query_result($list_result, $i - 1, "accountid");
$value = '<a href="index.php?module=Accounts&action=DetailView&record=' . $accountid . '&parenttab=' . $tabname . '" style="' . $P_FONT_COLOR . '">' . $accountname . '</a>';
} else {
$account_id = $adb->query_result($list_result, $i - 1, "accountid");
$account_name = getAccountName($account_id);
$acc_name = textlength_check($account_name);
// Fredy Klammsteiner, 4.8.2005: changes from 4.0.1 migrated to 4.2
$value = '<a href="index.php?module=Accounts&action=DetailView&record=' . $account_id . '&parenttab=' . $tabname . '" style="' . $P_FONT_COLOR . '">' . $acc_name . '</a>';
// Armando Lüscher 05.07.2005 -> §priority -> Desc: inserted style="$P_FONT_COLOR"
}
} elseif (($module == 'HelpDesk' || $module == 'PriceBook' || $module == 'Quotes' || $module == 'PurchaseOrder' || $module == 'Faq') && $name == 'Product Name') {
if ($module == 'HelpDesk' || $module == 'Faq') {
$product_id = $adb->query_result($list_result, $i - 1, "product_id");
} else {
$product_id = $adb->query_result($list_result, $i - 1, "productid");
}
if ($product_id != '') {
$product_name = getProductName($product_id);
} else {
$product_name = '';
}
$value = '<a href="index.php?module=Products&action=DetailView&parenttab=' . $tabname . '&record=' . $product_id . '">' . textlength_check($product_name) . '</a>';
} elseif ($module == 'Quotes' && $name == 'Potential Name' || $module == 'SalesOrder' && $name == 'Potential Name') {
$potential_id = $adb->query_result($list_result, $i - 1, "potentialid");
$potential_name = getPotentialName($potential_id);
$value = '<a href="index.php?module=Potentials&action=DetailView&parenttab=' . $tabname . '&record=' . $potential_id . '">' . textlength_check($potential_name) . '</a>';
} elseif ($module == 'Emails' && $relatedlist != '' && ($name == 'Subject' || $name == 'Date Sent' || $name == 'To')) {
$list_result_count = $i - 1;
$tmp_value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
$value = '<a href="javascript:;" onClick="ShowEmail(\'' . $entity_id . '\');">' . textlength_check($tmp_value) . '</a>';
if ($name == 'Date Sent') {
$sql = "select email_flag from vtiger_emaildetails where emailid=?";
$result = $adb->pquery($sql, array($entity_id));
$email_flag = $adb->query_result($result, 0, "email_flag");
if ($email_flag != 'SAVED') {
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
} else {
$value = '';
}
}
} elseif ($module == 'Calendar' && ($fieldname != 'taskstatus' && $fieldname != 'eventstatus')) {
if ($activitytype == 'Task') {
if (getFieldVisibilityPermission('Calendar', $current_user->id, $fieldname) == '0') {
$list_result_count = $i - 1;
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
} else {
$value = '';
}
} else {
if (getFieldVisibilityPermission('Events', $current_user->id, $fieldname) == '0') {
$list_result_count = $i - 1;
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
} else {
$value = '';
}
}
} else {
示例4: getOutputHtml
//.........这里部分代码省略.........
$chk_val = '';
}
$options[] = array($pickListValue => $chk_val);
}
$fieldvalue[] = $options;
} elseif ($uitype == 59) {
if ($value != '') {
$product_name = getProductName($value);
}
$editview_label[] = $mod_strings[$fieldlabel];
$fieldvalue[] = $product_name;
$fieldvalue[] = $value;
} elseif ($uitype == 64) {
$editview_label[] = $mod_strings[$fieldlabel];
$date_format = parse_calendardate($app_strings['NTC_DATE_FORMAT']);
$fieldvalue[] = $value;
} elseif ($uitype == 56) {
$editview_label[] = $mod_strings[$fieldlabel];
$fieldvalue[] = $value;
} elseif ($uitype == 57) {
$accountid = $col_fields['account_id'];
if (empty($accountid)) {
$convertmode = "";
if (isset($_REQUEST['convertmode'])) {
$convertmode = $_REQUEST['convertmode'];
}
if ($convertmode != 'update_quote_val' && $convertmode != 'update_so_val') {
if (isset($_REQUEST['account_id']) && $_REQUEST['account_id'] != '') {
$accountid = $_REQUEST['account_id'];
}
}
}
$contact_name = '';
// if(trim($value) != '')
// {
// $contact_name = getContactName($value);
// }
// elseif(isset($_REQUEST['contact_id']) && $_REQUEST['contact_id'] != '')
// {
// if(isset($_REQUEST['module']) && $_REQUEST['module'] == 'Contacts' && $fieldname = 'contact_id')
// {
// $contact_name = '';
// }
// else
// {
// $value = $_REQUEST['contact_id'];
// $contact_name = getContactName($value);
// }
//
// }
if (trim($value) == '') {
if (isset($_REQUEST['module']) && $_REQUEST['module'] == 'Contacts' && ($fieldname = 'contact_id')) {
} else {
$value = $_REQUEST['contact_id'];
}
}
$contactopts = getContactOptions($accountid, $value);
//Checking for contacts duplicate
$editview_label[] = $mod_strings[$fieldlabel];
// $fieldvalue[] = $contact_name;
$fieldvalue[] = $contactopts;
$fieldvalue[] = $value;
} elseif ($uitype == 76) {
if ($value != '') {
$potential_name = getPotentialName($value);
} elseif (isset($_REQUEST['potential_id']) && $_REQUEST['potential_id'] != '') {
$value = $_REQUEST['potental_id'];
$potential_name = getPotentialName($value);
} elseif (isset($_REQUEST['potentialid']) && $_REQUEST['potentialid'] != '') {
$value = $_REQUEST['potentalid'];
$potential_name = getPotentialName($value);
}
$editview_label[] = $mod_strings[$fieldlabel];
$fieldvalue[] = $potential_name;
$fieldvalue[] = $value;
} elseif ($uitype == 80) {
if ($value != '') {
$salesorder_name = getSoName($value);
} elseif (isset($_REQUEST['salesorder_id']) && $_REQUEST['salesorder_id'] != '') {
$value = $_REQUEST['salesorder_id'];
$salesorder_name = getSoName($value);
}
$editview_label[] = $mod_strings[$fieldlabel];
$fieldvalue[] = $salesorder_name;
$fieldvalue[] = $value;
} elseif ($uitype == 101) {
$editview_label[] = $mod_strings[$fieldlabel];
$fieldvalue[] = getUserName($value);
$fieldvalue[] = $value;
} else {
$editview_label[] = $mod_strings[$fieldlabel];
$fieldvalue[] = $value;
}
$final_arr[] = $ui_type;
$final_arr[] = $editview_label;
$final_arr[] = $editview_fldname;
$final_arr[] = $fieldvalue;
$log->debug("Exiting getOutputHtml method ...");
return $final_arr;
}
示例5: getSearchingListViewEntries
//.........这里部分代码省略.........
} elseif ($name == 'Account Name') {
//modified for vtiger_customview 27/5
if ($module == 'Accounts') {
$account_id = $adb->query_result($list_result, $i - 1, "crmid");
//$account_name = getAccountName($account_id);
$account_name = textlength_check($adb->query_result($list_result, $i - 1, "accountname"));
$value = $account_name;
} elseif ($module == 'Potentials' || $module == 'Contacts' || $module == 'Invoice' || $module == 'SalesOrder' || $module == 'Quotes') {
//Potential,Contacts,Invoice,SalesOrder & Quotes records sort by Account Name
//$accountname = textlength_check($adb->query_result($list_result,$i-1,"accountname"));
$accountid = $adb->query_result($list_result, $i - 1, "accountid");
$accountname = textlength_check(getAccountName($accountid));
$value = $accountname;
} else {
$account_id = $adb->query_result($list_result, $i - 1, "accountid");
$account_name = getAccountName($account_id);
$acc_name = textlength_check($account_name);
$value = $acc_name;
}
} elseif (($module == 'HelpDesk' || $module == 'PriceBook' || $module == 'Quotes' || $module == 'PurchaseOrder' || $module == 'Faq') && $name == 'Product Name') {
if ($module == 'HelpDesk' || $module == 'Faq') {
$product_id = $adb->query_result($list_result, $i - 1, "product_id");
} else {
$product_id = $adb->query_result($list_result, $i - 1, "productid");
}
if ($product_id != '') {
$product_name = getProductName($product_id);
} else {
$product_name = '';
}
$value = textlength_check($product_name);
} elseif ($module == 'Quotes' && $name == 'Potential Name' || $module == 'SalesOrder' && $name == 'Potential Name') {
$potential_id = $adb->query_result($list_result, $i - 1, "potentialid");
$potential_name = getPotentialName($potential_id);
$value = textlength_check($potential_name);
} elseif ($module == 'Emails' && $relatedlist != '' && ($name == 'Subject' || $name == 'Date Sent' || $name == 'To')) {
$list_result_count = $i - 1;
$tmp_value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid, false);
$tmp_value = evvt_strip_html_links($tmp_value);
$value = textlength_check($tmp_value);
if ($name == 'Date Sent') {
$sql = "select email_flag from vtiger_emaildetails where emailid=?";
$result = $adb->pquery($sql, array($entity_id));
$email_flag = $adb->query_result($result, 0, "email_flag");
if ($email_flag != 'SAVED') {
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid, false);
$value = evvt_strip_html_links($value);
} else {
$value = '';
}
}
} elseif ($module == 'Calendar' && ($fieldname != 'taskstatus' && $fieldname != 'eventstatus')) {
if ($activitytype == 'Task') {
if (getFieldVisibilityPermission('Calendar', $current_user->id, $fieldname) == '0') {
$list_result_count = $i - 1;
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid, false);
$value = evvt_strip_html_links($value);
} else {
$value = '';
}
} else {
if (getFieldVisibilityPermission('Events', $current_user->id, $fieldname) == '0') {
$list_result_count = $i - 1;
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid, false);
$value = evvt_strip_html_links($value);
} else {
示例6: getOutputHtml
//.........这里部分代码省略.........
if ($col_fields['record_id'] != '' && $uitype == 72) {
if ($fieldname == 'unit_price') {
$rate_symbol = getCurrencySymbolandCRate(getProductBaseCurrency($col_fields['record_id'], $module_name));
$currencySymbol = $rate_symbol['symbol'];
} else {
$currency_info = getInventoryCurrencyInfo($module, $col_fields['record_id']);
$currencySymbol = $currency_info['currency_symbol'];
}
$fieldvalue[] = $currencyField->getDisplayValue(null, true);
} else {
$decimals = CurrencyField::getDecimalsFromTypeOfData($typeofdata);
$currencyField->initialize($current_user);
$currencyField->setNumberofDecimals(min($decimals, $currencyField->getCurrencyDecimalPlaces()));
$fieldvalue[] = $currencyField->getDisplayValue(null, false, true);
$currencySymbol = $currencyField->getCurrencySymbol();
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name) . ': (' . $currencySymbol . ')';
} elseif ($uitype == 75 || $uitype == 81) {
if ($value != '') {
$vendor_name = getVendorName($value);
} elseif (isset($_REQUEST['vendor_id']) && $_REQUEST['vendor_id'] != '') {
$value = $_REQUEST['vendor_id'];
$vendor_name = getVendorName($value);
}
$pop_type = 'specific';
if ($uitype == 81) {
$pop_type = 'specific_vendor_address';
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $vendor_name;
$fieldvalue[] = $value;
} elseif ($uitype == 76) {
if ($value != '') {
$potential_name = getPotentialName($value);
} elseif (isset($_REQUEST['potential_id']) && $_REQUEST['potential_id'] != '') {
$value = $_REQUEST['potental_id'];
$potential_name = getPotentialName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $potential_name;
$fieldvalue[] = $value;
} elseif ($uitype == 78) {
if ($value != '') {
$quote_name = getQuoteName($value);
} elseif (isset($_REQUEST['quote_id']) && $_REQUEST['quote_id'] != '') {
$value = $_REQUEST['quote_id'];
$potential_name = getQuoteName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $quote_name;
$fieldvalue[] = $value;
} elseif ($uitype == 79) {
if ($value != '') {
$purchaseorder_name = getPoName($value);
} elseif (isset($_REQUEST['purchaseorder_id']) && $_REQUEST['purchaseorder_id'] != '') {
$value = $_REQUEST['purchaseorder_id'];
$purchaseorder_name = getPoName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $purchaseorder_name;
$fieldvalue[] = $value;
} elseif ($uitype == 80) {
if ($value != '') {
$salesorder_name = getSoName($value);
} elseif (isset($_REQUEST['salesorder_id']) && $_REQUEST['salesorder_id'] != '') {
$value = $_REQUEST['salesorder_id'];
示例7: x0e
private function x0e($emodule, $efocus, $is_related = false, $is_inventory = false)
{
global $x0b, $x0c, $x0d, $x0e, $x0f, $x10, $x11, $x12, $x13, $x14, $x15, $x16, $x17, $x18, $x19, $x1a, $x1b, $x1c, $x1d, $x1e, $x1f, $x20, $x21, $x22, $x23, $x24, $x25, $x26;
$related_fieldnames = array("related_to", "relatedto", "parent_id", "parentid", "product_id", "productid", "service_id", "serviceid", "vendor_id", "product", "account", "invoiceid", "linktoaccountscontacts", "projectid", "sc_related_to");
if ($is_inventory) {
$inventory_content = array();
}
$tabid = getTabid($emodule);
if ($is_related) {
$related = "R_";
} else {
$related = "";
}
$Checkboxes = array();
$Picklists = array();
$Textareas = array();
$Datefields = array();
$Multipicklists = array();
$NumbersField = array();
$sql = "SELECT fieldname, uitype FROM vtiger_field WHERE tabid = '" . $tabid . "'";
$result = $this->db->query($sql);
while ($row = $this->db->fetchByAssoc($result)) {
if ($row["uitype"] == "19" || $row["uitype"] == "20" || $row["uitype"] == "21" || $row["uitype"] == "24") {
$Textareas[] = $row["fieldname"];
} elseif ($row["uitype"] == "5" || $row["uitype"] == "23" || $row["uitype"] == "70") {
$Datefields[] = $row["fieldname"];
} elseif ($row["uitype"] == "15" || $row["fieldname"] == "salutationtype") {
$Picklists[] = $row["fieldname"];
} elseif ($row["uitype"] == "56") {
$Checkboxes[] = $row["fieldname"];
} elseif ($row["uitype"] == "33") {
$Multipicklists[] = $row["fieldname"];
} elseif ($row["uitype"] == "71") {
$NumbersField[] = $row["fieldname"];
}
}
foreach ($efocus->column_fields as $fieldname => $value) {
if ($fieldname == "assigned_user_id") {
$value = $this->x19($value);
} elseif ($fieldname == "account_id") {
$value = getAccountName($value);
} elseif ($fieldname == "potential_id") {
$value = getPotentialName($value);
} elseif ($fieldname == "contact_id") {
$value = getContactName($value);
} elseif ($fieldname == "quote_id") {
$value = getQuoteName($value);
} elseif ($fieldname == "salesorder_id") {
$value = getSoName($value);
} elseif ($fieldname == "campaignid") {
$value = getCampaignName($value);
} elseif ($fieldname == "terms_conditions") {
$value = $this->x20($value);
} elseif ($fieldname == "comments") {
$value = $this->x21($efocus);
} elseif ($fieldname == "folderid") {
$value = $this->x22($value);
} elseif ($x16($fieldname, $related_fieldnames)) {
if ($value != "") {
$parent_module = getSalesEntityType($value);
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $p_value) {
$value = $p_value;
}
}
if ($fieldname == "invoiceid" && $value == "0") {
$value = "";
}
}
}
if ($x16($fieldname, $Datefields)) {
$value = getValidDisplayDate($value);
} elseif ($x16($fieldname, $Picklists)) {
if (!$x16($x26($value), $this->ignored_picklist_values)) {
$value = $this->x1b($value, $emodule);
} else {
$value = "";
}
} elseif ($x16($fieldname, $Checkboxes)) {
$pdf_app_strings = return_application_language($this->language);
if ($value == 1) {
$value = $pdf_app_strings["yes"];
} else {
$value = $pdf_app_strings["no"];
}
} elseif ($x16($fieldname, $Textareas)) {
$value = $x1a($value);
} elseif ($x16($fieldname, $Multipicklists)) {
$value = $x1f(' |##| ', ', ', $value);
} elseif ($x16($fieldname, $NumbersField)) {
$value = $this->x1e($value);
}
if ($is_inventory) {
$inventory_content[$x22($emodule . "_" . $fieldname)] = $value;
} else {
$this->replacements["\$" . $related . $x22($emodule . "_" . $fieldname) . "\$"] = $value;
}
}
if ($is_inventory) {
//.........这里部分代码省略.........
示例8: getListViewEntries
//.........这里部分代码省略.........
$product_id = textlength_check($adb->query_result($list_result, $i - 1, "productname"));
$value = $product_id;
} elseif ($name == 'Account Name') {
if ($module == 'Accounts') {
$account_id = $adb->query_result($list_result, $i - 1, "crmid");
$account_name = $adb->query_result($list_result, $i - 1, 'accountname');
} elseif ($module == 'Potentials' || $module == 'Contacts' || $module == 'Invoice' || $module == 'SalesOrder' || $module == 'Quotes') {
//Potential,Contacts,Invoice,SalesOrder & Quotes records sort by Account Name
$account_name = $adb->query_result($list_result, $i - 1, 'accountname');
$account_id = $adb->query_result($list_result, $i - 1, "accountid");
} else {
$account_id = $adb->query_result($list_result, $i - 1, "accountid");
$account_name = getAccountName($account_id);
}
if (empty($account_name)) {
$account_name = getAccountName($account_id);
}
$acc_name = textlength_check($account_name);
$value = '<a href="index.php?module=Accounts&action=DetailView&record=' . $account_id . '&parenttab=' . $tabname . '">' . htmlspecialchars($acc_name, ENT_QUOTES, $default_charset) . '</a>';
} elseif (($module == 'HelpDesk' || $module == 'PriceBook' || $module == 'Quotes' || $module == 'PurchaseOrder' || $module == 'Faq') && $name == 'Product Name') {
if ($module == 'HelpDesk' || $module == 'Faq') {
$product_id = $adb->query_result($list_result, $i - 1, "product_id");
} else {
$product_id = $adb->query_result($list_result, $i - 1, "productid");
}
if ($product_id != '') {
$product_name = getProductName($product_id);
} else {
$product_name = '';
}
$value = '<a href="index.php?module=Products&action=DetailView&parenttab=' . $tabname . '&record=' . $product_id . '">' . textlength_check($product_name) . '</a>';
} elseif ($module == 'Quotes' && $name == 'Potential Name' || $module == 'SalesOrder' && $name == 'Potential Name') {
$potential_id = $adb->query_result($list_result, $i - 1, "potentialid");
$potential_name = getPotentialName($potential_id);
$value = '<a href="index.php?module=Potentials&action=DetailView&parenttab=' . $tabname . '&record=' . $potential_id . '">' . textlength_check($potential_name) . '</a>';
} elseif ($module == 'Emails' && $relatedlist != '' && ($name == 'Subject' || $name == 'Date Sent' || $name == 'To')) {
$list_result_count = $i - 1;
$tmp_value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
$attrs = $adb->pquery('select count(*) from vtiger_seattachmentsrel where crmid=?', array($entity_id));
$atts = $adb->query_result($attrs, 0, 0);
if ($atts > 0) {
$value = '<img src="themes/images/attachments.gif"> ';
} else {
$value = '';
}
$value .= '<a href="javascript:;" onClick="ShowEmail(\'' . $entity_id . '\');">' . textlength_check($tmp_value) . '</a>';
if ($name == 'Date Sent') {
if (Emails::EmailHasBeenSent($entity_id)) {
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
} else {
$value = '';
}
}
} elseif ($module == 'Calendar' && ($fieldname != 'taskstatus' && $fieldname != 'eventstatus')) {
if ($activitytype == 'Task') {
if (getFieldVisibilityPermission('Calendar', $current_user->id, $fieldname) == '0') {
$list_result_count = $i - 1;
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
} else {
$value = '';
}
} else {
if (getFieldVisibilityPermission('Events', $current_user->id, $fieldname) == '0') {
$list_result_count = $i - 1;
$value = getValue($ui_col_array, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, "list", "", $returnset, $oCv->setdefaultviewid);
} else {
示例9: getDetailViewOutputHtml
//.........这里部分代码省略.........
$label_fld[] = $mod_strings[$fieldlabel];
$label_fld[] = $account_name;
$label_fld["secid"] = $account_id;
$label_fld["link"] = "index.php?module=Accounts&action=DetailView&record=" . $account_id;
} elseif ($uitype == 52 || $uitype == 77 || $uitype == 101) {
$label_fld[] = $mod_strings[$fieldlabel];
$user_id = $col_fields[$fieldname];
$user_name = getUserName($user_id);
$label_fld[] = $user_name;
} elseif ($uitype == 53) {
$user_id = $col_fields[$fieldname];
$user_name = getUserName($user_id);
$label_fld[] = $mod_strings[$fieldlabel];
$label_fld[] = $user_name;
} elseif ($uitype == 1004) {
if (isset($mod_strings[$fieldlabel])) {
$label_fld[] = $mod_strings[$fieldlabel];
} else {
$label_fld[] = $fieldlabel;
}
$value = $col_fields[$fieldname];
$label_fld[] = getUserName($value);
} elseif ($uitype == 56) {
$label_fld[] = $mod_strings[$fieldlabel];
$value = $col_fields[$fieldname];
if ($value == 1) {
//Since "yes" is not been translated it is given as app strings here..
$display_val = $app_strings['yes'];
} else {
$display_val = '';
}
$label_fld[] = $display_val;
} elseif ($uitype == 57) {
$label_fld[] = $mod_strings[$fieldlabel];
$contact_id = $col_fields[$fieldname];
$contact_name = "";
if (trim($contact_id) != '') {
$contact_name = getContactName($contact_id);
}
$label_fld[] = $contact_name;
$label_fld["secid"] = $contact_id;
$label_fld["link"] = "index.php?module=Contacts&action=DetailView&record=" . $contact_id;
} elseif ($uitype == 59) {
$label_fld[] = $mod_strings[$fieldlabel];
$product_id = $col_fields[$fieldname];
if ($product_id != '') {
$product_name = getProductName($product_id);
}
//Account Name View
$label_fld[] = $product_name;
$label_fld["secid"] = $product_id;
$label_fld["link"] = "index.php?module=Products&action=DetailView&record=" . $product_id;
} elseif ($uitype == 71 || $uitype == 72) {
$label_fld[] = $mod_strings[$fieldlabel];
$display_val = $col_fields[$fieldname];
$label_fld[] = $display_val;
} elseif ($uitype == 76) {
$label_fld[] = $mod_strings[$fieldlabel];
$potential_id = $col_fields[$fieldname];
if ($potential_id != '') {
$potential_name = getPotentialName($potential_id);
}
$label_fld[] = $potential_name;
$label_fld["secid"] = $potential_id;
$label_fld["link"] = "index.php?module=Potentials&action=DetailView&record=" . $potential_id;
} elseif ($uitype == 80) {
$label_fld[] = $mod_strings[$fieldlabel];
$salesorder_id = $col_fields[$fieldname];
if ($salesorder_id != '') {
$salesorder_name = getSoName($salesorder_id);
}
$label_fld[] = $salesorder_name;
$label_fld["secid"] = $salesorder_id;
$label_fld["link"] = "index.php?module=SalesOrder&action=DetailView&record=" . $salesorder_id;
} elseif ($uitype == 85) {
$label_fld[] = $mod_strings[$fieldlabel];
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 86) {
$label_fld[] = $mod_strings[$fieldlabel];
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 87) {
$label_fld[] = $mod_strings[$fieldlabel];
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 88) {
$label_fld[] = $mod_strings[$fieldlabel];
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 89) {
$label_fld[] = $mod_strings[$fieldlabel];
$label_fld[] = $col_fields[$fieldname];
} else {
$label_fld[] = $mod_strings[$fieldlabel];
if ($col_fields[$fieldname] == '0') {
$col_fields[$fieldname] = '';
}
$label_fld[] = $col_fields[$fieldname];
}
$label_fld[] = $uitype;
$log->debug("Exiting getDetailViewOutputHtml method ...");
return $label_fld;
}
示例10: getDetailViewOutputHtml
//.........这里部分代码省略.........
}
$label_fld[] = $display_val . ' ' . $end_time;
} elseif ($uitype == 1007) {
$label_fld[] = isset($mod_strings[$fieldlabel]) ? $mod_strings[$fieldlabel] : $fieldlabel;
$cur_approve_val = $col_fields[$fieldname];
$label_fld[] = getApproveStatusById($cur_approve_val);
} elseif ($uitype == 1008) {
if (isset($mod_strings[$fieldlabel])) {
$label_fld[] = $mod_strings[$fieldlabel];
} else {
$label_fld[] = $fieldlabel;
}
$value = $col_fields[$fieldname];
$label_fld[] = getUserName($value);
} elseif ($uitype == 71 || $uitype == 72) {
$label_fld[] = $mod_strings[$fieldlabel];
$display_val = $col_fields[$fieldname];
$label_fld[] = $display_val;
} elseif ($uitype == 75 || $uitype == 81) {
$vendor_name = "";
$label_fld[] = $mod_strings[$fieldlabel];
$vendor_id = $col_fields[$fieldname];
if ($vendor_id != '') {
$vendor_name = getVendorName($vendor_id);
}
$label_fld[] = $vendor_name;
$label_fld["secid"] = $vendor_id;
$label_fld["link"] = "index.php?module=Vendors&action=DetailView&record=" . $vendor_id;
//$label_fld[] = '<a href="index.php?module=Products&action=VendorDetailView&record='.$vendor_id.'">'.$vendor_name.'</a>';
} elseif ($uitype == 76) {
$label_fld[] = $mod_strings[$fieldlabel];
$potential_id = $col_fields[$fieldname];
if ($potential_id != '') {
$potential_name = getPotentialName($potential_id);
}
$label_fld[] = $potential_name;
$label_fld["secid"] = $potential_id;
$label_fld["link"] = "index.php?module=Potentials&action=DetailView&record=" . $potential_id;
} elseif ($uitype == 78) {
$label_fld[] = $mod_strings[$fieldlabel];
$quote_id = $col_fields[$fieldname];
if ($quote_id != '') {
$quote_name = getQuoteName($quote_id);
}
$label_fld[] = $quote_name;
$label_fld["secid"] = $quote_id;
$label_fld["link"] = "index.php?module=Quotes&action=DetailView&record=" . $quote_id;
} elseif ($uitype == 79) {
$label_fld[] = $mod_strings[$fieldlabel];
$purchaseorder_id = $col_fields[$fieldname];
if ($purchaseorder_id != '') {
$purchaseorder_name = getPoName($purchaseorder_id);
}
$label_fld[] = $purchaseorder_name;
$label_fld["secid"] = $purchaseorder_id;
$label_fld["link"] = "index.php?module=PurchaseOrder&action=DetailView&record=" . $purchaseorder_id;
} elseif ($uitype == 80) {
$label_fld[] = $mod_strings[$fieldlabel];
$salesorder_id = $col_fields[$fieldname];
if ($salesorder_id != '') {
$salesorder_name = getSoName($salesorder_id);
}
$label_fld[] = $salesorder_name;
$label_fld["secid"] = $salesorder_id;
$label_fld["link"] = "index.php?module=SalesOrder&action=DetailView&record=" . $salesorder_id;
} elseif ($uitype == 1010) {
示例11: getDetailViewOutputHtml
//.........这里部分代码省略.........
}
$label_fld[] = $displayValue;
} elseif ($uitype == 71 || $uitype == 72) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$currencyField = new CurrencyField($col_fields[$fieldname]);
if ($uitype == 72) {
// Some of the currency fields like Unit Price, Total, Sub-total etc of Inventory modules, do not need currency conversion
if ($fieldname == 'unit_price') {
$rate_symbol = getCurrencySymbolandCRate(getProductBaseCurrency($col_fields['record_id'], $module));
$label_fld[] = $currencyField->getDisplayValue(null, true);
$label_fld["cursymb"] = $rate_symbol['symbol'];
} else {
$currency_info = getInventoryCurrencyInfo($module, $col_fields['record_id']);
$label_fld[] = $currencyField->getDisplayValue(null, true);
$label_fld["cursymb"] = $currency_info['currency_symbol'];
}
} else {
$label_fld[] = $currencyField->getDisplayValue();
$label_fld["cursymb"] = $currencyField->getCurrencySymbol();
}
} elseif ($uitype == 75 || $uitype == 81) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$vendor_id = $col_fields[$fieldname];
if ($vendor_id != '') {
$vendor_name = getVendorName($vendor_id);
}
$label_fld[] = $vendor_name;
$label_fld["secid"] = $vendor_id;
$label_fld["link"] = "index.php?module=Vendors&action=DetailView&record=" . $vendor_id;
} elseif ($uitype == 76) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$potential_id = $col_fields[$fieldname];
if ($potential_id != '') {
$potential_name = getPotentialName($potential_id);
}
$label_fld[] = $potential_name;
$label_fld["secid"] = $potential_id;
$label_fld["link"] = "index.php?module=Potentials&action=DetailView&record=" . $potential_id;
} elseif ($uitype == 78) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$quote_id = $col_fields[$fieldname];
if ($quote_id != '') {
$quote_name = getQuoteName($quote_id);
}
$label_fld[] = $quote_name;
$label_fld["secid"] = $quote_id;
$label_fld["link"] = "index.php?module=Quotes&action=DetailView&record=" . $quote_id;
} elseif ($uitype == 79) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$purchaseorder_id = $col_fields[$fieldname];
if ($purchaseorder_id != '') {
$purchaseorder_name = getPoName($purchaseorder_id);
}
$label_fld[] = $purchaseorder_name;
$label_fld["secid"] = $purchaseorder_id;
$label_fld["link"] = "index.php?module=PurchaseOrder&action=DetailView&record=" . $purchaseorder_id;
} elseif ($uitype == 80) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$salesorder_id = $col_fields[$fieldname];
if ($salesorder_id != '') {
$salesorder_name = getSoName($salesorder_id);
}
$label_fld[] = $salesorder_name;
$label_fld["secid"] = $salesorder_id;
$label_fld["link"] = "index.php?module=SalesOrder&action=DetailView&record=" . $salesorder_id;
} elseif ($uitype == 30) {