public function indexAction()
{
$type = $this->dispatcher->getParam('type', 'string');
$typeModel = Type::getCachedBySlug($type);
if (!$typeModel) {
throw new Exception("Publication hasn't type = '{$type}''");
}
$typeLimit = $typeModel->getLimit() ? $typeModel->getLimit() : 10;
$limit = $this->request->getQuery('limit', 'string', $typeLimit);
if ($limit != 'all') {
$paginatorLimit = (int) $limit;
} else {
$paginatorLimit = 9999;
}
$page = $this->request->getQuery('page', 'int', 1);
/*$publications = Publication::find(array(
"type_id = {$typeModel->getId()}",
"order" => "date DESC",
));*/
$publicationHelper = new PublicationHelper();
$fields = $publicationHelper->translateFieldsSubQuery();
$columns = ['p.*', 't_slug' => 't.slug'];
$columns = array_merge($columns, $fields);
$qb = $this->modelsManager->createBuilder()->columns($columns)->addFrom('Publication\\Model\\Publication', 'p')->leftJoin('Publication\\Model\\Type', null, 't')->andWhere('t.slug = :type:', ['type' => $type])->andWhere('p.date <= NOW()')->orderBy('p.date DESC');
$paginator = new \Phalcon\Paginator\Adapter\QueryBuilder(["builder" => $qb, "limit" => $paginatorLimit, "page" => $page]);
$this->view->paginate = $paginator->getPaginate();
$this->helper->title()->append($typeModel->getHeadTitle());
if ($page > 1) {
$this->helper->title()->append($this->helper->translate('Страница №') . ' ' . $page);
}
$this->view->title = $typeModel->getTitle();
$this->view->format = $typeModel->getFormat();
$this->view->type = $type;
$this->helper->menu->setActive($type);
}
public function lastNews($limit = 5)
{
$publicationHelper = new PublicationHelper();
$fields = $publicationHelper->translateFieldsSubQuery();
$columns = ['p.*', 't_slug' => 't.slug'];
$columns = array_merge($columns, $fields);
$qb = $this->modelsManager->createBuilder()->columns($columns)->addFrom('Publication\\Model\\Publication', 'p')->leftJoin('Publication\\Model\\Type', null, 't')->andWhere('t.slug = :type:', ['type' => 'news'])->andWhere('p.date <= NOW()')->orderBy('p.date DESC')->limit($limit);
$entries = $qb->getQuery()->execute();
$this->widgetPartial('widget/last-news', ['entries' => $entries]);
}
