/** * @throws \ModelModule\Model\NullException */ public function indexAction() { $mainLayout = $this->initializeAdminArea(); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $page = $this->params()->fromRoute('page'); $perPage = $this->params()->fromRoute('perpage'); try { $helper = new PostsControllerHelper(); $categoriesRecords = $helper->recoverWrapperRecords(new PostsCategoriesGetterWrapper(new PostsCategoriesGetter($em)), array('fields' => 'category.id, category.name', 'orderBy' => 'category.name', 'moduleCode' => 'photo')); $helper->checkRecords($categoriesRecords, 'Nessuna categoria foto presente. Aggiungere almeno una categoria'); $wrapperPosts = $helper->recoverWrapperRecordsPaginator(new PostsGetterWrapper(new PostsGetter($em)), array('moduleCode' => 'photo', 'userId' => null, 'orderBy' => 'p.id DESC', '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 = $wrapperPosts->setupRecords(); $helper->checkRecords($postsRecords, 'Nessuna foto in archivio'); foreach ($postsRecords as &$postsRecord) { $wrapper = new PostsGetterWrapper(new PostsGetter($em)); $wrapper->setInput(array('fields' => 'c.id, c.name', 'id' => $postsRecord['id'], 'orderBy' => 'c.name')); $wrapper->setupQueryBuilder(); $postsRecord['categories'] = $wrapper->getRecords(); } $form = new PostsFormSearch(); $form->addCategories($helper->formatForDropwdown($categoriesRecords, 'id', 'name')); $form->addSubmitButton(); $paginator = $wrapperPosts->getPaginator(); $postsRecords = $wrapperPosts->setupRecords(); $this->layout()->setVariables(array('tableTitle' => 'Foto', 'tableDescription' => $paginator->getTotalItemCount() . ' foto in archivio.', 'paginator' => $paginator, 'records' => $this->formatColumnRecords($postsRecords), 'columns' => array('Foto', "Titolo", "Categorie", "Inserito da", "Date", " ", " "), 'formSearch' => $form, 'templatePartial' => 'datatable/datatable_photo.phtml')); } catch (\Exception $e) { $this->layout()->setVariables(array('messageType' => 'warning', 'messageTitle' => 'Errore verificato', 'messageText' => $e->getMessage(), 'templatePartial' => 'message.phtml')); } $this->layout()->setTemplate($mainLayout); }
/** * @param array $input * @return array */ public function getResourceRecords(array $input) { $wrapper = new PostsGetterWrapper(new PostsGetter($this->getEntityManager())); $wrapper->setInput($input); $wrapper->setupQueryBuilder(); $wrapper->setupPaginator($wrapper->setupQuery($this->getEntityManager())); $wrapper->setupPaginatorCurrentPage($this->getPage()); $wrapper->setupPaginatorItemsPerPage($this->getPerPage()); $paginator = $wrapper->getPaginator(); $arrayToReturn = array(); foreach ($paginator as $row) { $arrayToReturn[] = $row; } return $arrayToReturn; }
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); }
/** * Blog post details * * @throws \ModelModule\Model\NullException */ public function detailsAction() { $mainLayout = $this->initializeFrontendWebsite(); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $configurations = $this->layout()->getVariable('configurations'); $category = $this->params()->fromRoute('category'); $languageSelection = $this->params()->fromRoute('languageSelection'); $title = $this->params()->fromRoute('title'); $wrapper = new PostsGetterWrapper(new PostsGetter($em)); $wrapper->setInput(array('moduleCode' => 'blogs', 'categorySlug' => $category, 'slug' => $title, 'languageAbbr' => $languageSelection, 'limit' => 1)); $wrapper->setupQueryBuilder(); $records = $wrapper->getRecords(); if (!empty($records)) { $singleRecord = $records[0]; $categoryName = $this->params()->fromRoute('category'); $title = $singleRecord['title']; } $this->layout()->setVariables(array('categorySlug' => $category, 'titleSlug' => $title, 'categoryName' => !empty($categoryName) ? $categoryName : null, 'title' => !empty($title) ? $title : null, 'record' => !empty($singleRecord) ? $singleRecord : null, 'mediaDir' => isset($configurations['media_dir']) ? $configurations['media_dir'] : null, 'mediaProject' => isset($configurations['media_project']) ? $configurations['media_project'] : null, 'templatePartial' => 'posts/blogs/details.phtml')); $this->layout()->setTemplate($mainLayout); }
public function recoverHomePageElements() { $this->assertEntityManager(); $this->assertModuleRelatedRecords(); $em = $this->getEntityManager(); $value = $this->getModuleRelatedRecords(); /** * @var PostsGetterWrapper $wrapper */ $wrapper = $this->recoverWrapper(new PostsGetterWrapper(new PostsGetter($em)), array('id' => $value['referenceIds'], 'fields' => 'DISTINCT(p.id) AS id, p.image, p.title, p.description '), $this->currentPaginatorPage, $this->maxPaginatorItemsPerPage); $recordsWithAttachments = $wrapper->getRecords(); if (!empty($recordsWithAttachments)) { foreach ($recordsWithAttachments as &$postsRecord) { $wrapper = new PostsGetterWrapper(new PostsGetter($em)); $wrapper->setInput(array('fields' => 'c.id, c.name', 'id' => $postsRecord['id'], 'orderBy' => 'c.name')); $wrapper->setupQueryBuilder(); $postsRecord['categories'] = $wrapper->getRecords(); } } return $recordsWithAttachments; }
public function testSetupQueryBuilder() { $this->assertNull($this->objectWrapper->setupQueryBuilder()); }