PHP getEntityFieldNames函数代码示例

 static function getFullNameFromArray($module, $fieldValues)
 {
     $entityInfo = getEntityFieldNames($module);
     $fieldsName = $entityInfo['fieldname'];
     $displayName = self::getCurrentUserEntityFieldNameDisplay($module, $fieldsName, $fieldValues);
     return $displayName;
 }

    $models = $_REQUEST['models'];
    global $log, $current_user;
    $log->debug('klm2 ' . $val_cond);
    $model_values = array();
    $model_values = json_decode($models);
    $nr = count($model_values);
    $mv = $model_values[$nr - 1];
    $focus = CRMEntity::getInstance("{$pointing_module}");
    $focus->retrieve_entity_info($mv->id, $pointing_module);
    $focus->id = $mv->id;
    $focus->mode = 'edit';
    for ($j = 0; $j < sizeof($col); $j++) {
        $focus->column_fields["{$col[$j]}"] = $mv->{$col}[$j];
        // all chosen columns
    }
    $entity_field_arr = getEntityFieldNames($pointing_module);
    $entity_field = $entity_field_arr["fieldname"];
    if (is_array($entity_field)) {
        $entityname = $entity_field[0];
    } else {
        $entityname = $entity_field;
    }
    $log->debug('albana2 ' . $entityname);
    $focus->column_fields["{$entityname}"] = $mv->{$col}[0] . ' ' . $mv->{$col}[1];
    //  the entityname field
    $log->debug('klm3 ' . $pointing_field_name . ' ' . $id);
    $focus->column_fields["assigned_user_id"] = $focus->column_fields["assigned_user_id"];
    $focus->save("{$pointing_module}");
} elseif ($kaction == 'delete') {
    require_once 'modules/' . $pointing_module . '/' . $pointing_module . '.php';
    $models = $_REQUEST['models'];

 function getReferenceFieldColumnList($moduleName, $fieldInfo)
 {
     $adb = PearDatabase::getInstance();
     $columnsSqlList = array();
     $fieldInstance = WebserviceField::fromArray($adb, $fieldInfo);
     $referenceModuleList = $fieldInstance->getReferenceList();
     $reportSecondaryModules = explode(':', $this->secondarymodule);
     if ($moduleName != $this->primarymodule && in_array($this->primarymodule, $referenceModuleList)) {
         $entityTableFieldNames = getEntityFieldNames($this->primarymodule);
         $entityTableName = $entityTableFieldNames['tablename'];
         $entityFieldNames = $entityTableFieldNames['fieldname'];
         $columnList = array();
         if (is_array($entityFieldNames)) {
             foreach ($entityFieldNames as $entityColumnName) {
                 $columnList["{$entityColumnName}"] = "{$entityTableName}.{$entityColumnName}";
             }
         } else {
             $columnList[] = "{$entityTableName}.{$entityFieldNames}";
         }
         if (count($columnList) > 1) {
             $columnSql = getSqlForNameInDisplayFormat($columnList, $this->primarymodule);
         } else {
             $columnSql = implode('', $columnList);
         }
         $columnsSqlList[] = $columnSql;
     } else {
         foreach ($referenceModuleList as $referenceModule) {
             $entityTableFieldNames = getEntityFieldNames($referenceModule);
             $entityTableName = $entityTableFieldNames['tablename'];
             $entityFieldNames = $entityTableFieldNames['fieldname'];
             $referenceTableName = '';
             $dependentTableName = '';
             if ($moduleName == 'HelpDesk' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountRelHelpDesk';
             } elseif ($moduleName == 'HelpDesk' && $referenceModule == 'Contacts') {
                 $referenceTableName = 'vtiger_contactdetailsRelHelpDesk';
             } elseif ($moduleName == 'HelpDesk' && $referenceModule == 'Products') {
                 $referenceTableName = 'vtiger_productsRel';
             } elseif ($moduleName == 'HelpDesk' && $referenceModule == 'Project') {
                 $referenceTableName = 'vtiger_projectRelHelpDesk';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'Contacts') {
                 $referenceTableName = 'vtiger_contactdetailsCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'Leads') {
                 $referenceTableName = 'vtiger_leaddetailsRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'Potentials') {
                 $referenceTableName = 'vtiger_potentialRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'Invoice') {
                 $referenceTableName = 'vtiger_invoiceRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'Quotes') {
                 $referenceTableName = 'vtiger_quotesRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'PurchaseOrder') {
                 $referenceTableName = 'vtiger_purchaseorderRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'SalesOrder') {
                 $referenceTableName = 'vtiger_salesorderRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'HelpDesk') {
                 $referenceTableName = 'vtiger_troubleticketsRelCalendar';
             } elseif ($moduleName == 'Calendar' && $referenceModule == 'Campaigns') {
                 $referenceTableName = 'vtiger_campaignRelCalendar';
             } elseif ($moduleName == 'Contacts' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountContacts';
             } elseif ($moduleName == 'Contacts' && $referenceModule == 'Contacts') {
                 $referenceTableName = 'vtiger_contactdetailsContacts';
             } elseif ($moduleName == 'Accounts' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountAccounts';
             } elseif ($moduleName == 'Campaigns' && $referenceModule == 'Products') {
                 $referenceTableName = 'vtiger_productsCampaigns';
             } elseif ($moduleName == 'Faq' && $referenceModule == 'Products') {
                 $referenceTableName = 'vtiger_productsFaq';
             } elseif ($moduleName == 'Invoice' && $referenceModule == 'SalesOrder') {
                 $referenceTableName = 'vtiger_salesorderInvoice';
             } elseif ($moduleName == 'Invoice' && $referenceModule == 'Contacts') {
                 $referenceTableName = 'vtiger_contactdetailsInvoice';
             } elseif ($moduleName == 'Invoice' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountInvoice';
             } elseif ($moduleName == 'Potentials' && $referenceModule == 'Campaigns') {
                 $referenceTableName = 'vtiger_campaignPotentials';
             } elseif ($moduleName == 'Products' && $referenceModule == 'Vendors') {
                 $referenceTableName = 'vtiger_vendorRelProducts';
             } elseif ($moduleName == 'PurchaseOrder' && $referenceModule == 'Contacts') {
                 $referenceTableName = 'vtiger_contactdetailsPurchaseOrder';
             } elseif ($moduleName == 'PurchaseOrder' && $referenceModule == 'Vendors') {
                 $referenceTableName = 'vtiger_vendorRelPurchaseOrder';
             } elseif ($moduleName == 'Quotes' && $referenceModule == 'Potentials') {
                 $referenceTableName = 'vtiger_potentialRelQuotes';
             } elseif ($moduleName == 'Quotes' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountQuotes';
             } elseif ($moduleName == 'SalesOrder' && $referenceModule == 'Potentials') {
                 $referenceTableName = 'vtiger_potentialRelSalesOrder';
             } elseif ($moduleName == 'SalesOrder' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountSalesOrder';
             } elseif ($moduleName == 'SalesOrder' && $referenceModule == 'Contacts') {
                 $referenceTableName = 'vtiger_contactdetailsSalesOrder';
             } elseif ($moduleName == 'SalesOrder' && $referenceModule == 'Quotes') {
                 $referenceTableName = 'vtiger_quotesSalesOrder';
             } elseif ($moduleName == 'Potentials' && $referenceModule == 'Contacts') {
                 $referenceTableName = 'vtiger_contactdetailsPotentials';
             } elseif ($moduleName == 'Potentials' && $referenceModule == 'Accounts') {
                 $referenceTableName = 'vtiger_accountPotentials';
//.........这里部分代码省略.........

 public static function getEntityTypeFromName($entityName, $modules = false)
 {
     global $adb;
     if ($modules == false) {
         $modules = array();
         $result = $adb->pquery('SELECT modulename FROM vtiger_entityname', array());
         $noOfModules = $adb->num_rows($result);
         for ($i = 0; $i < $noOfModules; ++$i) {
             $modules[] = $adb->query_result($result, $i, 'modulename');
         }
     }
     foreach ($modules as $referenceModule) {
         $entityFieldInfo = getEntityFieldNames($referenceModule);
         $tableName = $entityFieldInfo['tablename'];
         $fieldsName = $entityFieldInfo['fieldname'];
         if (is_array($fieldsName)) {
             $concatSql = 'CONCAT(' . implode(",' ',", $fieldsName) . ')';
         } else {
             $concatSql = $fieldsName;
         }
         $entityQuery = "SELECT 1 FROM {$tableName} WHERE {$concatSql} = ?";
         $entityResult = $adb->pquery($entityQuery, array($entityName));
         $num_rows = $adb->num_rows($entityResult);
         if ($num_rows > 0) {
             return $referenceModule;
         }
     }
 }

 public function createEntityRecord($moduleName, $entityLabel)
 {
     $moduleHandler = vtws_getModuleHandlerFromName($moduleName, $this->user);
     $moduleMeta = $moduleHandler->getMeta();
     $moduleFields = $moduleMeta->getModuleFields();
     $mandatoryFields = $moduleMeta->getMandatoryFields();
     $entityNameFieldsString = $moduleMeta->getNameFields();
     $entityNameFields = explode(',', $entityNameFieldsString);
     $fieldData = array();
     foreach ($entityNameFields as $entityNameField) {
         $entityNameField = trim($entityNameField);
         if (in_array($entityNameField, $mandatoryFields)) {
             $fieldData[$entityNameField] = $entityLabel;
         }
     }
     foreach ($mandatoryFields as $mandatoryField) {
         if (empty($fieldData[$mandatoryField])) {
             $fieldInstance = $moduleFields[$mandatoryField];
             if ($fieldInstance->getFieldDataType() == 'owner') {
                 $fieldData[$mandatoryField] = $this->user->id;
             } else {
                 if (!in_array($mandatoryField, $entityNameFields) && $fieldInstance->getFieldDataType() != 'reference') {
                     $fieldData[$mandatoryField] = '????';
                 }
             }
         }
     }
     $fieldData = DataTransform::sanitizeData($fieldData, $moduleMeta);
     $entityIdInfo = vtws_create($moduleName, $fieldData, $this->user);
     $adb = PearDatabase::getInstance();
     $entityIdComponents = vtws_getIdComponents($entityIdInfo['id']);
     $recordId = $entityIdComponents[1];
     $entityfields = getEntityFieldNames($moduleName);
     switch ($moduleName) {
         case 'HelpDesk':
             $entityfields['fieldname'] = array('ticket_title');
             break;
         case 'Documents':
             $entityfields['fieldname'] = array('notes_title');
             break;
         case 'Documents':
             $entityfields['fieldname'] = array('notes_title');
             break;
     }
     $label = '';
     if (is_array($entityfields['fieldname'])) {
         foreach ($entityfields['fieldname'] as $field) {
             $label .= $fieldData[$field] . " ";
         }
     } else {
         $label = $fieldData[$entityfields['fieldname']];
     }
     $label = trim($label);
     $adb->pquery('UPDATE vtiger_crmentity SET label=? WHERE crmid=?', array($label, $recordId));
     $recordModel = Vtiger_Record_Model::getCleanInstance($moduleName);
     $focus = $recordModel->getEntity();
     $focus->id = $recordId;
     $focus->column_fields = $fieldData;
     $this->entityData[] = VTEntityData::fromCRMEntity($focus);
     $focus->updateMissingSeqNumber($moduleName);
     return $entityIdInfo;
 }

//.........这里部分代码省略.........
                 }
                 $query = $queryGenerator->getQuery();
                 $duplicatesResult = $adb->query($query);
                 $noOfDuplicates = $adb->num_rows($duplicatesResult);
                 if ($noOfDuplicates > 0) {
                     if ($mergeType == Import_Utils_Helper::$AUTO_MERGE_IGNORE) {
                         $entityInfo['status'] = self::$IMPORT_RECORD_SKIPPED;
                     } elseif ($mergeType == Import_Utils_Helper::$AUTO_MERGE_OVERWRITE || $mergeType == Import_Utils_Helper::$AUTO_MERGE_MERGEFIELDS) {
                         for ($index = 0; $index < $noOfDuplicates - 1; ++$index) {
                             $duplicateRecordId = $adb->query_result($duplicatesResult, $index, $fieldColumnMapping['id']);
                             $entityId = vtws_getId($moduleObjectId, $duplicateRecordId);
                             vtws_delete($entityId, $this->user);
                         }
                         $baseRecordId = $adb->query_result($duplicatesResult, $noOfDuplicates - 1, $fieldColumnMapping['id']);
                         $baseEntityId = vtws_getId($moduleObjectId, $baseRecordId);
                         if ($mergeType == Import_Utils_Helper::$AUTO_MERGE_OVERWRITE) {
                             $fieldData = $this->transformForImport($fieldData, $moduleMeta);
                             $fieldData['id'] = $baseEntityId;
                             $entityInfo = vtws_update($fieldData, $this->user);
                             $entityInfo['status'] = self::$IMPORT_RECORD_UPDATED;
                         }
                         if ($mergeType == Import_Utils_Helper::$AUTO_MERGE_MERGEFIELDS) {
                             $filteredFieldData = array();
                             foreach ($fieldData as $fieldName => $fieldValue) {
                                 if (!empty($fieldValue)) {
                                     $filteredFieldData[$fieldName] = $fieldValue;
                                 }
                             }
                             // Custom handling for default values & mandatory fields
                             // need to be taken care than normal import as we merge
                             // existing record values with newer values.
                             $fillDefault = false;
                             $mandatoryValueChecks = false;
                             $existingFieldValues = vtws_retrieve($baseEntityId, $this->user);
                             $defaultFieldValues = $this->getDefaultFieldValues($moduleMeta);
                             foreach ($existingFieldValues as $fieldName => $fieldValue) {
                                 if (empty($fieldValue) && empty($filteredFieldData[$fieldName]) && !empty($defaultFieldValues[$fieldName])) {
                                     $filteredFieldData[$fieldName] = $defaultFieldValues[$fieldName];
                                 }
                             }
                             $filteredFieldData = $this->transformForImport($filteredFieldData, $moduleMeta, $fillDefault, $mandatoryValueChecks);
                             $filteredFieldData['id'] = $baseEntityId;
                             $entityInfo = vtws_revise($filteredFieldData, $this->user);
                             $entityInfo['status'] = self::$IMPORT_RECORD_MERGED;
                         }
                     } else {
                         $createRecord = true;
                     }
                 } else {
                     $createRecord = true;
                 }
             } else {
                 $createRecord = true;
             }
             if ($createRecord) {
                 $fieldData = $this->transformForImport($fieldData, $moduleMeta);
                 if ($fieldData == null) {
                     $entityInfo = null;
                 } else {
                     try {
                         $entityInfo = vtws_create($moduleName, $fieldData, $this->user);
                     } catch (Exception $e) {
                     }
                 }
             }
         }
         if ($entityInfo == null) {
             $entityInfo = array('id' => null, 'status' => self::$IMPORT_RECORD_FAILED);
         } else {
             if ($createRecord) {
                 $entityInfo['status'] = self::$IMPORT_RECORD_CREATED;
                 $entityIdComponents = vtws_getIdComponents($entityInfo['id']);
                 $recordId = $entityIdComponents[1];
                 $entityfields = getEntityFieldNames($this->module);
                 switch ($this->module) {
                     case 'HelpDesk':
                         $entityfields['fieldname'] = array('ticket_title');
                         break;
                     case 'Documents':
                         $entityfields['fieldname'] = array('notes_title');
                         break;
                 }
                 $label = '';
                 if (is_array($entityfields['fieldname'])) {
                     foreach ($entityfields['fieldname'] as $field) {
                         $label .= $fieldData[$field] . " ";
                     }
                 } else {
                     $label = $fieldData[$entityfields['fieldname']];
                 }
                 $label = trim($label);
                 $adb->pquery('UPDATE vtiger_crmentity SET label=? WHERE crmid=?', array($label, $recordId));
             }
         }
         $this->importedRecordInfo[$rowId] = $entityInfo;
         $this->updateImportStatus($rowId, $entityInfo);
     }
     unset($result);
     return true;
 }

//.........这里部分代码省略.........
        $module_icon = '<img src="themes/images/' . $parent_module . '.gif" alt="' . $app_strings[$parent_module] . '" title="' . $app_strings[$parent_module] . '" border=0 align=center> ';
    }
    $action = "DetailView";
    if ($parent_module == 'Accounts') {
        $parent_query = "SELECT accountname FROM vtiger_account WHERE accountid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = textlength_check($adb->query_result($parent_result, 0, "accountname"));
    }
    if ($parent_module == 'Leads') {
        $parent_query = "SELECT firstname,lastname FROM vtiger_leaddetails WHERE leadid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = getFullNameFromQResult($parent_result, 0, "Leads");
    }
    if ($parent_module == 'Potentials') {
        $parent_query = "SELECT potentialname FROM vtiger_potential WHERE potentialid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = textlength_check($adb->query_result($parent_result, 0, "potentialname"));
    }
    if ($parent_module == 'Products') {
        $parent_query = "SELECT productname FROM vtiger_products WHERE productid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "productname");
    }
    if ($parent_module == 'Quotes') {
        $parent_query = "SELECT subject FROM vtiger_quotes WHERE quoteid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "subject");
    }
    if ($parent_module == 'PurchaseOrder') {
        $parent_query = "SELECT subject FROM vtiger_purchaseorder WHERE purchaseorderid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "subject");
    }
    if ($parent_module == 'Invoice') {
        $parent_query = "SELECT subject FROM vtiger_invoice WHERE invoiceid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "subject");
    }
    if ($parent_module == 'SalesOrder') {
        $parent_query = "SELECT subject FROM vtiger_salesorder WHERE salesorderid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "subject");
    }
    if ($parent_module == 'Contacts' && ($module == 'Emails' || $module == 'HelpDesk')) {
        $parent_query = "SELECT firstname,lastname FROM vtiger_contactdetails WHERE contactid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = getFullNameFromQResult($parent_result, 0, "Contacts");
    }
    if ($parent_module == 'Vendors' && ($module == 'Emails' || $module == 'Calendar')) {
        //MSL
        $parent_query = "SELECT vendorname FROM vtiger_vendor WHERE vendorid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "vendorname");
    }
    if ($parent_module == 'Project' && $module == 'Emails') {
        $parent_query = "SELECT projectid,projectname FROM vtiger_project WHERE projectid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "projectname");
    }
    if ($parent_module == 'ProjectTask' && $module == 'Emails') {
        $parent_query = "SELECT projecttaskid,projecttaskname FROM vtiger_projecttask WHERE projecttaskid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "projecttaskname");
    }
    if ($parent_module == 'Potentials' && $module == 'Emails') {
        $parent_query = "SELECT potentialid,potentialname FROM vtiger_potential WHERE potentialid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "potentialname");
    }
    if ($parent_module == 'HelpDesk') {
        $parent_query = "SELECT title FROM vtiger_troubletickets WHERE ticketid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "title");
        //if(strlen($parent_name) > 25)
        //{
        $parent_name = textlength_check($parent_name);
        //}
    }
    if ($parent_module == 'Campaigns') {
        $parent_query = "SELECT campaignname FROM vtiger_campaign WHERE campaignid=?";
        $parent_result = $adb->pquery($parent_query, array($parent_id));
        $parent_name = $adb->query_result($parent_result, 0, "campaignname");
        //if(strlen($parent_name) > 25)
        //{
        $parent_name = textlength_check($parent_name);
        //}
    }
    //added by rdhital for better emails - Raju
    if ($parent_module == 'Multiple') {
        $parent_value = $parent_name;
    } else {
        $parent_value = $module_icon . "<a href='index.php?module=" . $parent_module . "&action=" . $action . "&record=" . $parent_id . "&parenttab=" . $tabname . "'>" . textlength_check($parent_name) . "</a>";
        $modMetaInfo = getEntityFieldNames($parent_module);
        $modEName = is_array($modMetaInfo['fieldname']) ? $modMetaInfo['fieldname'][0] : $modMetaInfo['fieldname'];
        $parent_value .= "<span type='vtlib_metainfo' vtrecordid='{$parent_id}' vtfieldname='{$modEName}' vtmodule='{$parent_module}' style='display:none;'></span>";
    }
    //code added by raju ends
    $log->debug("Exiting getRelatedTo method ...");
    return $parent_value;
}

function getSqlForNameInDisplayFormat($input, $module, $glue = ' ')
{
    $entity_field_info = getEntityFieldNames($module);
    $tableName = $entity_field_info['tablename'];
    $fieldsName = $entity_field_info['fieldname'];
    if (is_array($fieldsName)) {
        foreach ($fieldsName as $key => $value) {
            $formattedNameList[] = $input[$value];
        }
        $formattedNameListString = implode(",'" . $glue . "',", $formattedNameList);
    } else {
        $formattedNameListString = $input[$fieldsName];
    }
    $sqlString = concatNamesSql($formattedNameListString);
    return $sqlString;
}

 public function getNameFields()
 {
     global $adb;
     $data = getEntityFieldNames(getTabModuleName($this->getEffectiveTabId()));
     $fieldNames = '';
     if ($data) {
         $fieldNames = $data['fieldname'];
         if (is_array($fieldNames)) {
             $fieldNames = implode(',', $fieldNames);
         }
     }
     return $fieldNames;
 }

//.........这里部分代码省略.........
                        $arr_evo_actions = explode(' |##| ', $value);
                        for ($fvalues = 0; $fvalues < sizeof($arr_evo_actions); $fvalues++) {
                            $roleid = $arr_evo_actions[$fvalues];
                            $rolename = getRoleName($roleid);
                            $content[$fvalues] = $rolename;
                        }
                    }
                    $value = textlength_check(implode(', ', $content));
                } elseif ($field->getFieldDataType() == 'skype') {
                    $value = $value != "" ? "<a href='skype:{$value}?call'>" . textlength_check($value) . "</a>" : "";
                } elseif ($field->getFieldDataType() == 'phone') {
                    if ($useAsterisk == 'true') {
                        $value = "<a href='javascript:;' onclick='startCall(&quot;{$value}&quot;, " . "&quot;{$recordId}&quot;)'>" . textlength_check($value) . "</a>";
                    } else {
                        $value = textlength_check($value);
                    }
                } elseif ($field->getFieldDataType() == 'reference') {
                    $referenceFieldInfoList = $this->queryGenerator->getReferenceFieldInfoList();
                    if (getTabid($currentModule) != $field->getTabId()) {
                        $modrel = getTabModuleName($field->getTabId());
                        $fieldName = str_replace($modrel . '.', "", $fieldName);
                    }
                    $moduleList = $referenceFieldInfoList[$fieldName];
                    if (count($moduleList) == 1) {
                        $parentModule = $moduleList[0];
                    } else {
                        $parentModule = $this->typeList[$value];
                    }
                    if (!empty($value) && !empty($this->nameList[$fieldName]) && !empty($parentModule)) {
                        $parentMeta = $this->queryGenerator->getMeta($parentModule);
                        $value = textlength_check($this->nameList[$fieldName][$value]);
                        if ($parentMeta->isModuleEntity() && $parentModule != "Users") {
                            $value = "<a href='index.php?module={$parentModule}&action=DetailView&" . "record={$rawValue}' title='" . getTranslatedString($parentModule, $parentModule) . "'>{$value}</a>";
                            $modMetaInfo = getEntityFieldNames($parentModule);
                            $fieldName = is_array($modMetaInfo['fieldname']) ? $modMetaInfo['fieldname'][0] : $modMetaInfo['fieldname'];
                            // vtlib customization: For listview javascript triggers
                            $value = "{$value} <span type='vtlib_metainfo' vtrecordid='{$rawValue}' vtfieldname=" . "'{$fieldName}' vtmodule='{$parentModule}' style='display:none;'></span>";
                        }
                    } else {
                        $value = '--';
                    }
                } elseif ($field->getFieldDataType() == 'owner') {
                    if ($fieldName != 'assigned_user_id' && strstr($fieldName, ".assigned_user_id")) {
                        $value = textlength_check($this->ownerNameListrel[$fieldName][$value]);
                    } else {
                        $value = textlength_check($this->ownerNameList[$fieldName][$value]);
                    }
                } elseif ($field->getUIType() == 25) {
                    //TODO clean request object reference.
                    $contactId = $_REQUEST['record'];
                    $emailId = $this->db->query_result($result, $i, "activityid");
                    $result1 = $this->db->pquery("SELECT access_count FROM vtiger_email_track WHERE " . "crmid=? AND mailid=?", array($contactId, $emailId));
                    $value = $this->db->query_result($result1, 0, "access_count");
                    if (!$value) {
                        $value = 0;
                    }
                } elseif ($field->getUIType() == 8) {
                    if (!empty($value)) {
                        $temp_val = html_entity_decode($value, ENT_QUOTES, $default_charset);
                        $json = new Zend_Json();
                        $value = vt_suppressHTMLTags(implode(',', $json->decode($temp_val)));
                    }
                } elseif (in_array($uitype, array(7, 9, 90))) {
                    $value = "<span align='right'>" . textlength_check($value) . "</div>";
                } elseif ($field->getUIType() == 55) {
                    $value = getTranslatedString($value, $currentModule);

 function search_query($result)
 {
     global $log;
     require_once 'include/utils/CommonUtils.php';
     $search_module = $result['Search']['module'][0]['modulename'];
     //$search_table=$result['Search'][0]['tablename'];
     $search_module_info = getEntityFieldNames($search_module);
     $select = "SELECT * from " . $search_module_info['tablename'] . " join vtiger_crmentity on \n        crmid=" . $search_module_info['tablename'] . "." . $search_module_info['entityidfield'] . " where deleted=0 and ";
     $rules = $result['Search']['rules'];
     for ($r = 0; $r < sizeof($rules); $r++) {
         $expected_values = '';
         $where = '';
         for ($rr = 0; $rr < sizeof($rules[$r]); $rr++) {
             $rule_field = trim($rules[$r][$rr]['field']);
             $rule_operator = $rules[$r][$rr]['operator'];
             $rule_alter_rule = $rules[$r][$rr]['alter_expectedvalue'];
             for ($f = 0; $f < sizeof($result['Search']['fields']); $f++) {
                 $fieldname = trim($result['Search']['fields'][$f]['fieldname']);
                 if ($rule_field === $fieldname) {
                     if ($where != '') {
                         $where .= " " . $rule_operator . " ";
                         $expected_values .= ',';
                     }
                     if ($rule_alter_rule['alter_operator'] != '') {
                         $expected_values .= $rule_alter_rule['alter_value'];
                     } else {
                         $expected_values .= $result['Search']['fields'][$f]['expectedvalue'];
                     }
                     $where .= " " . $fieldname . $result['Search']['fields'][$f]['operator'] . "? ";
                     $f = sizeof($result['Search']['fields']) + 1;
                 }
             }
         }
         $sql_array[] = array('select' => $select, 'where' => $where, 'expectedvalues' => $expected_values, 'update' => $result['Update']);
     }
     return $sql_array;
 }

 public function getDisplaySQL($module, &$join_array, &$columns_array)
 {
     $entity_field_info = getEntityFieldNames($module);
     if (in_array($this->params["field_uitype"], array("52", "53", "77"))) {
         $join_tablename_alias = $this->params["join_tablename_alias"];
     } else {
         $join_tablename_alias = $this->params["join_tablename_alias"];
     }
     $fieldid_alias = "";
     if ($this->params["fieldid"] != "") {
         $fieldid_alias = "_" . $this->params["fieldid"];
     }
     $fld_cond = "";
     if (in_array($this->params["field_uitype"], array("52", "53", "77"))) {
         // User Names Start
         // first name | last name -> syntax
         $fld_cond .= "CASE WHEN vtiger_users{$fieldid_alias}.id IS NOT NULL THEN CONCAT(vtiger_users{$fieldid_alias}.first_name,IF(vtiger_users{$fieldid_alias}.first_name != '' AND vtiger_users{$fieldid_alias}.first_name IS NOT NULL,' ',''),vtiger_users{$fieldid_alias}.last_name) WHEN vtiger_groups{$fieldid_alias}.groupid IS NOT NULL THEN vtiger_groups{$fieldid_alias}.groupname END ";
         // last name | first name -> syntax
         // $fld_cond .= "CASE WHEN vtiger_users$fieldid_alias.id IS NOT NULL THEN CONCAT(vtiger_users$fieldid_alias.last_name,IF(vtiger_users$fieldid_alias.first_name != '' AND vtiger_users$fieldid_alias.first_name IS NOT NULL,' ',''),vtiger_users$fieldid_alias.first_name) WHEN vtiger_groups$fieldid_alias.groupid IS NOT NULL THEN vtiger_groups$fieldid_alias.groupname END ";
         // User Names End
         $display = $fld_cond . " AS " . $this->params["columnname"] . $fieldid_alias;
         $fld_string_h = "";
     } else {
         if (is_array($entity_field_info["fieldname"])) {
             $fld_cond .= "CONCAT(";
             $wi = 0;
             foreach ($entity_field_info["fieldname"] as $fieldvalue) {
                 $fld_cond .= $join_tablename_alias . "." . $fieldvalue;
                 if ($wi == 0) {
                     $fld_cond .= ",' ',";
                 }
                 $wi++;
             }
             $fld_cond .= ") ";
             $display = $fld_cond . " AS " . $this->params["columnname"] . $fieldid_alias;
         } else {
             $fld_cond .= $join_tablename_alias . "." . $entity_field_info["fieldname"];
             $display = $fld_cond . " AS " . $this->params["columnname"] . $fieldid_alias;
         }
         // $fld_string_h = $join_tablename_alias.".";
         $fld_string_h = "";
     }
     $display_arr["display"] = $display;
     $display_arr["fld_string"] = $fld_string_h . $this->params["columnname"] . $fieldid_alias;
     $hrefid = $join_tablename_alias . "." . $entity_field_info["entityidfield"] . " AS " . $this->params["columnname"] . $fieldid_alias . "_hid";
     $display_arr["hrefid"] = $hrefid;
     $display_arr["fld_cond"] = $fld_cond;
     return $display_arr;
 }

/** This function returns the detail view form vtiger_field and and its properties in array format.
 * Param $uitype - UI type of the vtiger_field
 * Param $fieldname - Form vtiger_field name
 * Param $fieldlabel - Form vtiger_field label name
 * Param $col_fields - array contains the vtiger_fieldname and values
 * Param $generatedtype - Field generated type (default is 1)
 * Param $tabid - vtiger_tab id to which the Field belongs to (default is "")
 * Return type is an array
 */
function getDetailViewOutputHtml($uitype, $fieldname, $fieldlabel, $col_fields, $generatedtype, $tabid = '', $module = '')
{
    global $log;
    $log->debug("Entering getDetailViewOutputHtml(" . $uitype . "," . $fieldname . "," . $fieldlabel . "," . $col_fields . "," . $generatedtype . "," . $tabid . ") method ...");
    global $adb;
    global $mod_strings;
    global $app_strings;
    global $current_user;
    global $theme;
    $theme_path = "themes/" . $theme . "/";
    $image_path = $theme_path . "images/";
    $fieldlabel = from_html($fieldlabel);
    $custfld = '';
    $value = '';
    $arr_data = array();
    $label_fld = array();
    $data_fld = array();
    require 'user_privileges/user_privileges_' . $current_user->id . '.php';
    require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
    // vtlib customization: New uitype to handle relation between modules
    if ($uitype == '10') {
        $fieldlabel = getTranslatedString($fieldlabel, $module);
        $parent_id = $col_fields[$fieldname];
        if (!empty($parent_id)) {
            $parent_module = getSalesEntityType($parent_id);
            $valueTitle = getTranslatedString($parent_module, $parent_module);
            $displayValueArray = getEntityName($parent_module, $parent_id);
            if (!empty($displayValueArray)) {
                foreach ($displayValueArray as $key => $value) {
                    $displayValue = $value;
                }
            }
            // vtlib customization: For listview javascript triggers
            $modMetaInfo = getEntityFieldNames($parent_module);
            $modEName = is_array($modMetaInfo['fieldname']) ? $modMetaInfo['fieldname'][0] : $modMetaInfo['fieldname'];
            $vtlib_metainfo = "<span type='vtlib_metainfo' vtrecordid='{$parent_id}' vtfieldname=" . "'{$modEName}' vtmodule='{$parent_module}' style='display:none;'></span>";
            // END
            $label_fld = array($fieldlabel, "<a href='index.php?module={$parent_module}&action=DetailView&record={$parent_id}' title='{$valueTitle}'>{$displayValue}</a>{$vtlib_metainfo}");
        } else {
            $moduleSpecificMessage = 'MODULE_NOT_SELECTED';
            if ($mod_strings[$moduleSpecificMessage] != "") {
                $moduleSpecificMessage = $mod_strings[$moduleSpecificMessage];
            }
            $label_fld = array($fieldlabel, '');
        }
    } else {
        if ($uitype == 99) {
            $label_fld[] = getTranslatedString($fieldlabel, $module);
            $label_fld[] = $col_fields[$fieldname];
            if ($fieldname == 'confirm_password') {
                return null;
            }
        } elseif ($uitype == 116 || $uitype == 117) {
            $label_fld[] = getTranslatedString($fieldlabel, $module);
            $label_fld[] = getCurrencyName($col_fields[$fieldname]);
            $pick_query = "select * from vtiger_currency_info where currency_status = 'Active' and deleted=0";
            $pickListResult = $adb->pquery($pick_query, array());
            $noofpickrows = $adb->num_rows($pickListResult);
            //Mikecrowe fix to correctly default for custom pick lists
            $options = array();
            $found = false;
            for ($j = 0; $j < $noofpickrows; $j++) {
                $pickListValue = $adb->query_result($pickListResult, $j, 'currency_name');
                $currency_id = $adb->query_result($pickListResult, $j, 'id');
                if ($col_fields[$fieldname] == $currency_id) {
                    $chk_val = "selected";
                    $found = true;
                } else {
                    $chk_val = '';
                }
                $options[$currency_id] = array($pickListValue => $chk_val);
            }
            $label_fld["options"] = $options;
        } elseif ($uitype == 13 || $uitype == 104) {
            $label_fld[] = getTranslatedString($fieldlabel, $module);
            $label_fld[] = $col_fields[$fieldname];
        } elseif ($uitype == 16) {
            $label_fld[] = getTranslatedString($fieldlabel, $module);
            $label_fld[] = getTranslatedString($col_fields[$fieldname], $module);
            $fieldname = $adb->sql_escape_string($fieldname);
            $pick_query = "select {$fieldname} from vtiger_{$fieldname} order by sortorderid";
            $params = array();
            $pickListResult = $adb->pquery($pick_query, $params);
            $noofpickrows = $adb->num_rows($pickListResult);
            $options = array();
            $count = 0;
            $found = false;
            for ($j = 0; $j < $noofpickrows; $j++) {
                $pickListValue = decode_html($adb->query_result($pickListResult, $j, strtolower($fieldname)));
                $col_fields[$fieldname] = decode_html($col_fields[$fieldname]);
                if ($col_fields[$fieldname] == $pickListValue) {
//.........这里部分代码省略.........