public function applet($conf, &$opts) { $recordset = "quick_search"; $theme = $this->init_module('Base/Theme'); $form = $this->init_module('Libs/QuickForm'); $txtQuery = 'query_text'; $txtLabel = 'query_label'; $btnQuery = 'query_button'; $id = $conf['criteria']; $searchPrompt = Applets_QuickSearchCommon::getSearchPromptById($id); $conf['a_title'] = $conf['a_title'] == "Quick Search" ? Applets_QuickSearchCommon::getPresetNameById($id) : $conf['a_title']; $placeholder = $searchPrompt == "" ? "" : $searchPrompt; $opts['title'] = $conf['a_title']; $opts['go'] = false; load_css('modules/Applets/QuickSearch/theme/quick_form.css'); load_js('modules/Applets/QuickSearch/js/quicksearch.js'); //$js ='setDelayOnSearch()'; //eval_js($js); $txt = $form->addElement('text', $txtQuery, __('Search')); $txt->setAttribute('id', $txtQuery . "_" . $id); $txt->setAttribute('class', 'QuickSearch_text'); $txt->setAttribute('onkeypress', 'setDelayOnSearch(\'' . $id . '\')'); $txt->setAttribute('placeholder', _V($placeholder)); $theme->assign($txtLabel, __('Search')); $theme->assign($txtQuery, $txt->toHtml()); $theme->assign('search_id', $conf['criteria']); $theme->display('quick_form'); return true; }
if (!Base_AclCommon::is_user()) { return; } if (isset($_GET['crit']) && $_GET['crit'] != "" && isset($_GET['q']) && $_GET['q'] != "") { $arrResult = array(); $id = $_GET['crit']; $txt = trim(urldecode($_GET['q'])); $arrTxt = explode(" ", $txt); $arrayQuick = Applets_QuickSearchCommon::getRecordsetAndFields($id); $format = Applets_QuickSearchCommon::getResultFormat(); $formatString = Applets_QuickSearchCommon::parseFormatString($format); $arrayKey = array(); $array_keys = array_keys($arrayQuick); foreach ($array_keys as $key) { $fieldsArray = Applets_QuickSearchCommon::parse_array($arrayQuick[$key]); $sql = substr("select * from " . $key . "_data_1 where " . Applets_QuickSearchCommon::constructLikeSQL($arrTxt, $fieldsArray), 0, -3); $qry = DB::SelectLimit($sql, 20, 0); if ($qry) { $arrRow = array(); $result = ""; while ($rowValue = $qry->FetchRow()) { $rowValue["RECORD_SET"] = $key; $arrayKey[] = $rowValue; } } } if (is_array($arrayKey) && !empty($arrayKey)) { foreach ($arrayKey as $rows) { $result = ""; $keyRecordset = $rows["RECORD_SET"]; foreach ($formatString[$keyRecordset] as $keyIdx) {
public static function getRecordsetAndFields($id) { $qry = Utils_RecordBrowserCommon::get_record("quick_search", $id, false); if ($qry) { self::$resultFormat = $qry["result_format"]; return self::parse_recordset($qry["recordsets"], $qry["select_field_to_search"]); } else { return false; } }