function GetQuery() { $queryString = GetQueryString(); $queryTerms = preg_split('/\\s+/', preg_quote($queryString, '/'), -1, PREG_SPLIT_NO_EMPTY); // split query string into terms at any kind of whitespace and do not keep empty ones foreach ($queryTerms as $key => $queryTerm) { $queryTerms[$key] = '(?=.*' . $queryTerm . ')'; // add "AND" operator to each query term } $preQuery = implode($queryTerms); // merge query terms back together into a single regular expression if ($preQuery !== '') { return "/{$preQuery}/i"; // output full regular expression to search for } else { return null; // disable search later } }
$period = 86400; } try { $req = new SOURCERequest(); } catch (ADEIException $e) { $req = new REQUEST(); $nodata = 1; } $list = $req->GetSources(REQUEST::LIST_ALL); ?><div class="header"><? foreach ($list as $sreq) { ?><a href="download.php?<?echo GetQueryString($sreq);?>"><?echo $sreq->props['db_server'];?>.<?echo $sreq->props['db_name'];?></a> <? } ?><a href="csvmerge.php">Merge Groups</a></div><? if ($nodata) exit; ?><h3>Server: <?echo $req->props['db_server'];?>, DataBase: <?echo $req->props['db_name'];?></h3><? //$props = array("db_server"=>"katrin", "db_name"=>"HS"); $reader = $req->CreateReader(); $groups = $reader->GetGroupList(REQUEST::NEED_INFO); $list = $req->GetGroups(); foreach ($list as $gid => $greq) { $group = $groups[$gid];
function GetSpecificQueryString($input) { $result = ''; if (!isset($input) || trim($input) == '') { $result = ''; //redundance } else { //get array of query string $arr_query_string = GetQueryString(); //check if array is null or not if (is_array($arr_query_string) && !empty($arr_query_string)) { foreach ($arr_query_string as $key => $value) { $query_key = strtolower(stripslashes($key)); $input = strtolower($input); if ($query_key == $input) { $result = "?" . $key . "=" . $value; break; } } } } return $result; }
$page["onload"] .= "CKEDITOR.config.toolbarCanCollapse = true;"; foreach ($items->HtmlFields as $key) { $page["onload"] .= "CKEDITOR.replace('" . $items->DbFields[$key]['field'] . "');"; } } // If Set fields exist select all set items if ($items->SetFields) { foreach ($items->SetFields as $key) { $setValues[$items->DbFields[$key]['field']] = $items->GetSetItems($key, isset($item) ? $item[$items->DbKey] : false); } $smarty->assign("setValues", $setValues); } $smarty->assign("item", $item); } else { $smarty->assign("items", $items->GetItems($portion, $quantity, $sort, $order, $search, $where, true, $select)); $pagination["total"] = $items->GetItemsCount($search, $where); $pagination["all"] = $search ? $items->GetItemsCount(false, $where) : false; $pagination["quantity"] = $quantity; $pagination["portion"] = $portion; $pagination["from"] = $portion * $quantity - $quantity + 1; $pagination["to"] = $portion * $quantity > $pagination["total"] ? $pagination["total"] : $portion * $quantity; $pagination["pages"] = ceil($pagination["total"] / $quantity); $pagination["url"] = $items->ItemConfig["adminScript"] . "?" . GetQueryString('portion') . "&portion="; $smarty->assign("pagination", $pagination); $page["where"] = $where; // Where Sql string for js MoveItem() function } $page["meta"] .= '<script src="/' . INC_JQUERY . 'jquery.min.js" type="text/javascript"></script>' . "\n\t\t" . '<script src="/' . INC_JQUERY_UI . 'jquery-ui.min.js" type="text/javascript"></script>' . "\n\t\t" . '<script src="/' . INC_JQUERY_UI . 'jquery.ui.datepicker-ru.js" type="text/javascript"></script>' . "\n\t\t" . '<link href="/' . INC_JQUERY_UI . 'jquery-ui.min.css" type="text/css" rel="stylesheet" />' . "\n\t\t" . '<script src="/' . INC_JQUERY_PLUGINS . 'jquery.string.1.0-min.js" type="text/javascript"></script>' . "\n\t\t" . '<script src="/' . INC_CKEDITOR . 'ckeditor.js" type="text/javascript"></script>' . "\n\t\t" . '<script src="/' . ADMIN_DIR . 'js/base.js" type="text/javascript"></script>'; $page["onload"] .= "InitializeForm('form_item');"; $end = (double) array_sum(explode(' ', microtime())); $smarty->assign("processingTime", "Время работы скрипта: " . sprintf("%.4f", $end - $start) . " секунд");