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

UptoLike

ВУЗ: 

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

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

Рубрика: 

77
$year_field = $aGridField["alias"]."_year";
$year = $_SESSION[$param_name][$year_field];
if ((!empty($year))&&($year!='999')) {
$aSQL .= " and
".$aMasterTable.".".$aGridField["al
ias"]." like '".$year."-__-__'";
}
break;
}
}
}
// Сначала считаем, сколько всего записей в результате запроса
$count = sizeof($this->db->query ($aSQL,0));
// Определяем количество групп
$count_group = (int)($count / $count_res);
if ($count % $count_res<>0) $count_group++;
$offset_group = (int)($offset / $count_page)*$count_page;
if ($count_group-$offset_group>$count_page) $cur_group = $count_page;
else $cur_group = $count_group % $count_page;
// Определяем нужны ли ссылки prev и next
if ($offset>$count_page-1) $prev = true;
if ($count_group-$offset_group>$count_page) $next = true;
// режим сортировки
$aSQL .= " order by $sort $r_sort limit
".($offset*$count_res).",".$count_res;
$members = $this->db->query($aSQL,1);
$i = 0;
foreach ($members as $member)
{
$temp = $member;
$members[$i] = array();
foreach ($temp as $k => $v)
{
$members[$i][$k] = $temp->$k;
}
$i++;
}
$template = new Smarty();
$template->assign('self', $_SERVER['PHP_SELF']);
$template->assign('action', $action);
$template->assign('members', $members);
$template->assign('grid_fields', $aGridFields);
$template->assign('size_grid_fields', sizeof($aGridFields));
$template->assign('filtr_fields', $_SESSION[$param_name]);
$template->assign('errMsg', $errMsg);
$template->assign('months', $months);
$template->assign('days', $days);

Страницы