Ejemplo n.º 1
0
 }
 if ($LookupType == LT_QUERY) {
     $lookupPSet = new ProjectSettings($lookupTable, $pageType);
     $lookupCipherer = new RunnerCipherer($lookupTable);
     $lookupQueryObj = $lookupPSet->getSQLQuery();
     if ($gSettings->getCustomDisplay($f)) {
         $lookupQueryObj->AddCustomExpression($displayFieldName, $lookupPSet, $strTableName, $f);
     }
     $lookupQueryObj->ReplaceFieldsWithDummies($lookupPSet->getBinaryFieldsIndices());
 } else {
     $LookupSQLTable = "SELECT ";
     $lwLinkField = $lookupConnection->addFieldWrappers($gSettings->getLinkField($f));
     if ($gSettings->isLookupUnique($f)) {
         $LookupSQLTable .= "DISTINCT ";
     }
     $LookupSQLTable .= $cipherer->GetLookupFieldName($lwLinkField, $f, null, true);
     if ($lookupConnection->dbType == nDATABASE_MSSQLServer) {
         if ($strUniqueOrderBy && $gSettings->isLookupUnique($f)) {
             $LookupSQLTable .= "," . $lookupConnection->addFieldWrappers($strUniqueOrderBy);
         }
     }
     if (!$linkAndDisplaySame) {
         $LookupSQLTable .= "," . ($lwDisplayField == $lwLinkField ? $cipherer->GetFieldName($lwDisplayField, $f, true) : $lwDisplayField);
     }
     $LookupSQLTable .= " FROM " . $lookupConnection->addTableWrappers($lookupTable) . " ";
 }
 $strLookupWhere = GetLWWhere($f, $pageType, $strTableName);
 if ($strLookupWhere) {
     $strLookupWhere = " (" . $strLookupWhere . ")  AND ";
 }
 if ($LookupType == LT_QUERY) {