public function indexAction() { $mainLayout = $this->initializeAdminArea(); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $page = $this->params()->fromRoute('page'); $perPage = $this->params()->fromRoute('perPage'); $configurations = $this->layout()->getVariable('configurations'); $userDetails = $this->layout()->getVariable('userDetails'); $userRole = isset($userDetails->role) ? $userDetails->role : ''; $userId = isset($userDetails->id) ? $userDetails->id : 1; $languageSelection = $this->params()->fromRoute('languageSelection'); $modulename = $this->params()->fromRoute('modulename'); $isAmmTrasparente = $modulename != 'contenuti' ? 1 : 0; $sessionContainer = new SessionContainer(); $sessionSearch = $sessionContainer->offsetGet(ContenutiSearchController::sessionIdentifier); $helper = new ContenutiControllerHelper(); /* Detect form switch language */ if (!empty($configurations['isMultiLanguage']) == 1 and $modulename == 'contenuti') { $helper->setLanguagesGetterWrapper(new LanguagesGetterWrapper(new LanguagesGetter($em))); $formLanguage = $helper->setupLanguageFormSearch(new LanguagesFormSearch(), array('status' => 1), $languageSelection); } try { $wrapper = $helper->recoverWrapperRecordsPaginator(new ContenutiGetterWrapper(new ContenutiGetter($em)), array_merge(array('showToAll' => $userRole == 'WebMaster' ? null : 1, 'utente' => $userRole == 'WebMaster' ? null : $userId, 'languageAbbreviation' => $languageSelection, 'isAmmTrasparente' => $isAmmTrasparente, 'inhome' => isset($sessionSearch['inhome']) ? $sessionSearch['inhome'] : null, 'sottosezione' => isset($sessionSearch['sottosezioni']) ? $sessionSearch['sottosezioni'] : null, 'freeSearch' => isset($sessionSearch['testo']) ? $sessionSearch['testo'] : null, 'orderBy' => 'contenuti.id DESC'), !empty($sessionSearch) ? $sessionSearch : array()), $page, $perPage); $sottoSezioniRecords = $helper->recoverWrapperRecords(new SottoSezioniGetterWrapper(new SottoSezioniGetter($em)), array('isAmmTrasparente' => $isAmmTrasparente, 'showToAll' => $userRole == 'WebMaster' ? null : 1, 'languageAbbreviation' => $languageSelection)); $helper->checkRecords($sottoSezioniRecords, 'Nessuna sottosezione presente, verificare i parametri di ricerca e se sono presenti i dati'); $sottoSezioniRecordsForDropDown = $helper->formatSottoSezioniGetterWrapperRecordsForDropdown($sottoSezioniRecords); $wrapper->setEntityManager($em); $paginatorRecords = $wrapper->addAttachmentsToPaginatorRecords($wrapper->setupRecords(), array('moduleId' => $modulename == 'contenuti' ? ModulesContainer::contenuti_id : ModulesContainer::amministrazione_trasparente_id, 'orderBy' => 'a.position')); $formSearch = new ContenutiFormSearch(); $formSearch->addSottosezioni($sottoSezioniRecordsForDropDown); $formSearch->addInHome(); $formSearch->addSubmitButton(); $formSearch->setData(array_merge(array('languageSelection' => $languageSelection), !empty($sessionSearch) ? $sessionSearch : array())); $paginator = $wrapper->getPaginator(); $paginatorRecordsCount = $paginator->getTotalItemCount(); } catch (\Exception $e) { $this->layout()->setVariables(array('showMessage' => 1, 'messageType' => 'danger', 'messageTitle' => 'Si è verificato un problema', 'messageText' => $e->getMessage(), 'templatePartial' => 'message.phtml')); } $this->layout()->setVariables(array('tableTitle' => $modulename == 'contenuti' ? 'Contenuti' : 'Amministrazione trasparente', 'tableDescription' => !empty($paginatorRecordsCount) ? $paginatorRecordsCount . ' articoli in archivio' : null, 'paginator' => !empty($paginator) ? $paginator : null, 'records' => !empty($paginatorRecords) ? $this->formatRecordsToShowOnTable($paginatorRecords) : null, 'templatePartial' => 'datatable/datatable_contenuti.phtml', 'formSearch' => !empty($formSearch) ? $formSearch : null, 'formLanguage' => isset($formLanguage) ? $formLanguage : null, 'sessionSearch' => isset($sessionSearch) ? $sessionSearch : null, 'columns' => array("Sezione", "Sotto sezione", "Titolo", 'Date', 'Inserito da', " ", $userDetails->acl->hasResource("contenuti_update") ? " " : null, $userDetails->acl->hasResource("contenuti_delete") ? " " : null, $userDetails->acl->hasResource("contenuti_homepage") ? " " : null, $userDetails->acl->hasResource("contenuti_attachments") ? " " : null, ($isAmmTrasparente == 1 and $userDetails->acl->hasResource("amministrazione_trsparente_tabelle")) ? " " : null))); $this->layout()->setTemplate($mainLayout); }