public function overview($tpl = null, $pagination = 0, CustomDataFilter $filter = null)
{
if ($filter === null) {
$filter = new CustomDataFilter($this->position);
foreach ($this->mainFields as $field) {
$filter->field($field);
}
$filter->orderBy(reset($this->mainFields));
}
$pages = '';
if ($pagination > 0) {
$pg = new Pagination($pagination, $filter->getAmount());
$pg->setUri($this->baseUri);
$pg->parsePage();
$filter->limit($pg->getPerPage(), $pg->getOffset());
$pages = $pg->build();
}
$tpl = Response::getObject()->appendTemplate($tpl ? $tpl : "/Cms/fields/data_categories");
$tpl->assign('pages', $pages, false);
$tpl->assign('list', $filter->retrieveList(), false);
$tpl->assign('baseUri', $this->baseUri);
$tpl->output();
}
protected function members()
{
$db = Database::getObject();
$db->query("SELECT COUNT(*) FROM <p>user");
$pp = Config::get('pagination.admin');
$pg = new Pagination($pp, $db->fetchOne());
$pg->parsePage();
$pg->setUri(Uri::build('/Cms/admin/members'));
$offset = $pg->getOffset();
$db->query("SELECT * FROM <p>user ORDER BY surname, forename LIMIT <offset:int>, <pp:int>", compact("offset", "pp"));
$data = array();
while ($row = $db->fetchAssoc()) {
$row['group'] = UserUtils::getGroupName($row['group_id']);
$data[] = $row;
}
$tpl = Response::getObject()->appendTemplate("Cms/admin/members");
$tpl->assign("pages", $pg->build(), false);
$tpl->assign("data", $data);
$tpl->output();
}
