/** * Fill the response array with the suggest values * * @param String value * Note: value is preceeded with "_" * @param String searchFor * @param &Array response * @param &Array row */ function suggestValue($value, $searchFor, &$response, &$row) { if (!GetGlobalData("handleSearchSuggestInLookup", true) || $this->lookupType == LT_LISTOFVALUES || $this->isSearchByDispalyedFieldAllowed()) { parent::suggestValue($value, $searchFor, $response, $row); return; } // "_" is added to convert number type to string in lookupsuggest.php ($value) $lookupSQL = $this->getLookupSQL("", substr($value, 1), false, true, false, true, true); $this->fillLookupFieldsIndexes(); $qResult = $this->lookupConnection->query($lookupSQL); if ($data = $qResult->fetchNumeric()) { // "_" is added to convert number type to string if ($this->isDisplayFieldEncrypted) { $displayFieldName = $this->lookupType == LT_QUERY ? $this->displayFieldName : $this->field; $lookup_value = $this->ciphererDisplay->DecryptField($displayFieldName, "_" . $data[$this->displayFieldIndex]); } else { $lookup_value = "_" . $data[$this->displayFieldIndex]; } parent::suggestValue($lookup_value, $searchFor, $response, $row); } }
function suggestValue($value, $searchFor, &$response, &$row) { if (!GetGlobalData("handleSearchSuggestInLookup", true)) { parent::suggestValue($value, $searchFor, $response, $row); return; } global $conn; $lookupSQL = buildLookupSQL($this->lookupPageType, $this->field, $this->pageObject->tName, "", $value, false, true, false, true, true, true); $this->fillLookupFieldsIndexes(); $rs_lookup = db_query($lookupSQL, $conn); if ($data = db_fetch_numarray($rs_lookup)) { if ($this->isDisplayFieldEncrypted) { $lookup_value = $this->ciphererDisplay->DecryptField($this->lookupType == LT_QUERY ? $this->displayFieldName : $this->field, $data[$this->displayFieldIndex]); } else { $lookup_value = $data[$this->displayFieldIndex]; } parent::suggestValue($lookup_value, $searchFor, $response, $row); } }