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) . " секунд");