Технология построения интерактивных Web-ресурсов. Мартынов А.И - 76 стр.

UptoLike

ВУЗ: 

УлГТУ | Ульяновск

Составители: 

Рубрика: 

76
// Здесь разбираем параметры
$r_sort = $_SESSION[$param_name]['_r_sort'];
$count_res = $_SESSION[$param_name]['_count_res'];
$count_page = $_SESSION[$param_name]['_count_page'];
$sort = $_SESSION[$param_name]['_sort'];
$offset = $_SESSION[$param_name]['offset'];
$panel_visible = $_SESSION[$param_name]['panel_visible'];
// Настройка фильтров
if ($slaveFlag) $aSQL .= " and 1 "; else $aSQL .= " 1 ";
foreach ($aGridFields as $aGridField)
{
if ($aGridField["find"] == "Y") {
switch ($aGridField["type"])
{
case "text":
if
((!empty($_SESSION[$param_name][$aGridField["alias"]]))&&($_SESSI
ON[$param_name][$aGridField["alias"]]!='999'))
$aSQL .= " and
".$aGridField["table"].".".$aGridField["field"]." like
'".$_SESSION[$param_name][$aGridField["field"]]."%'";
break;
case "select":
if
((!empty($_SESSION[$param_name][$aGridField["alias"]]))&&($_SESSI
ON[$param_name][$aGridField["alias"]]!='999'))
$aSQL .= " and
".$aMasterTable.".".$aGridField["alias"]." =
'".$_SESSION[$param_name][$aGridField["alias"]]."'"; break;
case "list":
if
((!empty($_SESSION[$param_name][$aGridField["alias"]]))&&($_SESSI
ON[$param_name][$aGridField["alias"]]!='999'))
$aSQL .= " and
".$aMasterTable.".".$aGridField["alias"]." =
'".$_SESSION[$param_name][$aGridField["alias"]]."'"; break;
case "data":
$day_field = $aGridField["alias"]."_day";
$day = $_SESSION[$param_name][$day_field];
if ((!empty($day))&&($day!='999')) {
if (strlen($day)==1) $day =
"0".$day;
$aSQL .= " and
".$aMasterTable.".".$aGridField["al
ias"]." like '____-__-".$day."'";
}
$month_field = $aGridField["alias"]."_month";
$month = $_SESSION[$param_name][$month_field];
if ((!empty($month))&&($month!='999')) {
if (strlen($month)==1) $month =
"0".$month;
$aSQL .= " and
".$aMasterTable.".".$aGridField["al
ias"]." like '____-".$month."-__'";
}

Страницы