public function indexAction() { $mainLayout = $this->initializeAdminArea(); $entityManager = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $configurations = $this->layout()->getVariable('configurations'); $lang = $this->params()->fromRoute('lang'); $languageSelection = $this->params()->fromRoute('languageSelection'); $page = $this->params()->fromRoute('page'); $perPage = $this->params()->fromRoute('perpage'); $sessionContainer = new SessionContainer(); $sessionSearch = $sessionContainer->offsetGet(BlogsSearchController::sessionIdentifier); try { $helper = new PostsControllerHelper(); $categoriesRecords = $helper->recoverWrapperRecords(new PostsCategoriesGetterWrapper(new PostsCategoriesGetter($entityManager)), array('fields' => 'category.id, category.name', 'orderBy' => 'category.name', 'languageAbbreviation' => $languageSelection ? $languageSelection : 'it', 'moduleCode' => 'blogs')); $helper->checkRecords($categoriesRecords, 'Nessuna categoria presente'); $wrapperBlogPosts = $helper->recoverWrapperRecordsPaginator(new PostsGetterWrapper(new PostsGetter($entityManager)), array('moduleCode' => 'blogs', 'userId' => null, 'orderBy' => 'p.id DESC', 'languageAbbr' => $languageSelection ? $languageSelection : 'it', 'freeSearch' => isset($sessionSearch['testo']) ? $sessionSearch['testo'] : null, 'categoryId' => isset($sessionSearch['category']) ? $sessionSearch['category'] : null, 'fields' => 'DISTINCT(p.id) AS id, p.lastUpdate, p.createDate, p.expireDate, p.hasAttachments, p.image, p.title, p.subtitle, p.description, p.slug, p.seoTitle, p.seoDescription, p.seoKeywords, users.name AS userName, users.surname AS userSurname'), $page, $perPage); /* Add categories to the recordset */ $postsRecords = $wrapperBlogPosts->setupRecords(); $helper->checkRecords($postsRecords, 'Nessun blog post in archivio'); /* Add attachments files to the recordset */ $wrapperBlogPosts->setEntityManager($entityManager); $postsRecords = $wrapperBlogPosts->addAttachmentsFromRecords($postsRecords, array('moduleId' => ModulesContainer::blogs)); foreach ($postsRecords as &$postsRecord) { $wrapper = new PostsGetterWrapper(new PostsGetter($entityManager)); $wrapper->setInput(array('fields' => 'c.id, c.name', 'id' => $postsRecord['id'], 'orderBy' => 'c.name')); $wrapper->setupQueryBuilder(); $postsRecord['categories'] = $wrapper->getRecords(); } $paginator = $wrapperBlogPosts->getPaginator(); $isMultiLanguage = !empty($configurations['isMultiLanguage']); if ($isMultiLanguage == 1) { $helper->setLanguagesGetterWrapper(new LanguagesGetterWrapper(new LanguagesGetter($entityManager))); $formLanguage = $helper->setupLanguageFormSearch(new LanguagesFormSearch(), array('status' => 1), $languageSelection); } $form = new PostsFormSearch(); $form->addCategories($helper->formatForDropwdown($categoriesRecords, 'id', 'name')); $form->addSubmitButton(); $form->setData(isset($sessionSearch) ? $sessionSearch : array()); $this->layout()->setVariables(array('tableTitle' => 'Blogs', 'tableDescription' => $paginator->getTotalItemCount() . ' posts in archivio', 'columns' => array("Immagine", "Titolo", "Categorie", "Inserita da", "Date", " ", " ", " "), 'paginator' => $paginator, 'records' => $this->formatColumnRecords($postsRecords), 'formSearch' => $form, 'formLanguage' => !empty($formLanguage) ? $formLanguage : null, 'sessionSearch' => $sessionSearch, 'formLanguageAction' => $this->url()->fromRoute('admin/blogs-operations', array('action' => 'switchlanguage', 'lang' => $lang, 'languageSelection' => $languageSelection)), 'templatePartial' => 'datatable/datatable_blogs.phtml')); } catch (\Exception $e) { $this->layout()->setVariables(array('messageText' => $e->getMessage(), 'templatePartial' => 'message-exception.phtml')); } $this->layout()->setTemplate($mainLayout); }