public function indexAction() { $mainLayout = $this->initializeFrontendWebsite(); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $page = $this->params()->fromRoute('page'); $perPage = $this->params()->fromRoute('perpage'); $sessionContainer = new SessionContainer(); $sessionSearch = $sessionContainer->offsetGet(StatoCivileSearchController::sessionIdentifier); try { $helper = new StatoCivileControllerHelper(); $sezioniRecords = $helper->recoverWrapperRecords(new StatoCivileSezioniGetterWrapper(new StatoCivileSezioniGetter($em)), array()); $helper->checkRecords($sezioniRecords, 'Nessuna sezione stato civile in archivio'); $sezioniRecordsForDropdown = $helper->formatForDropwdown($sezioniRecords, 'id', 'nome'); $wrapper = $helper->recoverWrapperRecordsPaginator(new StatoCivileGetterWrapper(new StatoCivileGetter($em)), array_merge(array('textSearch' => isset($sessionSearch['testo']) ? $sessionSearch['testo'] : null, 'mese' => isset($sessionSearch['mese']) ? $sessionSearch['mese'] : null, 'anno' => isset($sessionSearch['anno']) ? $sessionSearch['anno'] : null, 'sezione' => isset($sessionSearch['sezine']) ? $sessionSearch['sezine'] : null), array('attivo' => 1, 'noScaduti' => 1, 'orderBy' => 'sca.data DESC')), $page, $perPage); $wrapper->setEntityManager($em); $wrapper->addAttachmentsToPaginatorRecords($wrapper->setupRecords(), array('moduleId' => ModulesContainer::stato_civile_id, 'noScaduti' => 1, 'orderBy' => 'a.position')); $paginator = $wrapper->getPaginator(); $form = new StatoCivileFormSearch(); $form->addTesto(); $form->addSezioni($sezioniRecordsForDropdown); $form->addMese(); $form->addAnni(); $form->addCheckExpired(); $form->addSubmitButton(); $form->setData(array('testo' => isset($sessionSearch['testo']) ? $sessionSearch['testo'] : null, 'mese' => isset($sessionSearch['mese']) ? $sessionSearch['mese'] : null, 'anno' => isset($sessionSearch['anno']) ? $sessionSearch['anno'] : null, 'sezione' => isset($sessionSearch['sezione']) ? $sessionSearch['sezione'] : null)); } catch (\Exception $e) { $paginator = null; } $this->layout()->setVariables(array('sessionSearch' => $sessionSearch, 'paginator' => !empty($paginator) ? $paginator : null, 'emptyRecords' => count($paginator), 'records' => !empty($paginator) ? $paginator : null, 'form' => !empty($form) ? $form : null, 'templatePartial' => 'stato-civile/stato-civile.phtml')); $this->layout()->setTemplate($mainLayout); }
public function indexAction() { $mainLayout = $this->initializeAdminArea(); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $page = $this->params()->fromRoute('page'); $perPage = $this->params()->fromRoute('perpage'); $userDetails = $this->layout()->getVariable('userDetails'); $sessionContainer = new SessionContainer(); try { $formPostedValues = $sessionContainer->offsetGet('statoCivileFormSearch'); $request = $this->getRequest(); if ($request->isPost()) { $post = array_merge_recursive($request->getPost()->toArray(), $request->getFiles()->toArray()); } else { $post = $formPostedValues; } $statoCivileArticoliInput = array('numero' => isset($post['numero']) ? $post['numero'] : null, 'anno' => isset($post['anno']) ? $post['anno'] : null, 'sezioneId' => isset($post['sezione']) ? $post['sezione'] : null, 'noScaduti' => isset($post['expired']) ? $post['expired'] : null, 'textSearch' => isset($post['testo']) ? $post['testo'] : null, 'orderBy' => 'sca.id DESC'); $helper = new StatoCivileControllerHelper(); $yearsList = $helper->setupYears(new StatoCivileGetterWrapper(new StatoCivileGetter($em)), array_merge($statoCivileArticoliInput, array('fields' => 'DISTINCT(sca.anno) AS anno'))); $sezioniRecords = $helper->recoverWrapperRecords(new StatoCivileSezioniGetterWrapper(new StatoCivileSezioniGetter($em)), array()); $helper->checkRecords($sezioniRecords, "Nessuna sezione in archivio"); $sezioniRecordsForDropDown = $helper->formatForDropwdown($sezioniRecords, 'id', 'nome'); $formSearch = new StatoCivileFormSearch(); $formSearch->addTesto(); $formSearch->addProgressivo(); $formSearch->addNumeroAtto(); $formSearch->addMese(); $formSearch->addSezioni($sezioniRecordsForDropDown); $formSearch->addSubmitButton(); $formSearch->addCheckExpired(); $formSearch->addAnni($yearsList); if ($this->getRequest()->isPost()) { $formSearch->setBindOnValidate(false); $formSearch->setData($post); $sessionContainer->offsetSet('statoCivileFormSearch', $post); } elseif (!empty($formPostedValues)) { $formSearch->setData($formPostedValues); } $wrapper = $helper->recoverWrapperRecordsPaginator(new StatoCivileGetterWrapper(new StatoCivileGetter($em)), $statoCivileArticoliInput, $page, $perPage); $wrapper->setEntityManager($em); $attiRecords = $wrapper->addAttachmentsFromRecords($wrapper->setupRecords()); $paginator = $wrapper->getPaginator(); $paginatorCount = $paginator->getTotalItemCount(); $this->layout()->setVariables(array('tableTitle' => 'Stato civile', 'tableDescription' => $paginatorCount . ' atti stato civile in archivio', 'columns' => array("Titolo", "Numero / Anno", "Sezione", "Inserito il", "Scadenza", "Inserito da", " ", " ", " ", " ", " ", " "), 'formSearch' => $formSearch, 'records' => $this->formatRecords($attiRecords), 'paginator' => $paginator, 'templatePartial' => 'datatable/datatable_statocivile.phtml')); } catch (\Exception $e) { $this->layout()->setVariables(array('messageType' => 'warning', 'messageTitle' => 'Errore verificato', 'messageText' => $e->getMessage(), 'templatePartial' => 'message.phtml')); } $this->layout()->setTemplate($mainLayout); }
/** * Set search session * * @return \Zend\Http\Response */ public function indexAction() { if ($this->getRequest()->isPost()) { $request = $this->getRequest(); $post = array_merge_recursive($request->getPost()->toArray(), $request->getFiles()->toArray()); $inputFilter = new StatoCivileFormSearchInputFilter(); $formSearch = new StatoCivileFormSearch(); $formSearch->setBindOnValidate(false); $formSearch->addTesto(); $formSearch->addMese(); $formSearch->addAnni(); /* $formSearch->addSezioni(); */ $formSearch->setInputFilter($inputFilter->getInputFilter()); $formSearch->setData($post); if ($formSearch->isValid()) { $inputFilter->exchangeArray($formSearch->getData()); $formSearch->setData($post); $sessioContainer = new SessionContainer(); $sessioContainer->offsetSet(self::sessionIdentifier, array('testo' => $inputFilter->testo, 'mese' => $inputFilter->mese, 'anno' => $inputFilter->anno, 'sezione' => $inputFilter->sezione)); $referer = $this->getRequest()->getHeader('Referer'); if (is_object($referer)) { return $this->redirect()->toUrl($referer->getUri()); } } $mainLayout = $this->initializeFrontendWebsite(); $referer = $this->getRequest()->getHeader('Referer'); $alboUrl = $this->url()->fromRoute('stato-civile'); $refererUrl = is_object($referer) ? $referer->getUri() : $alboUrl; $this->layout()->setVariables(array('formMessages' => $formSearch->getMessages(), 'refererUrl' => $refererUrl, 'moduleUrl' => $alboUrl, 'moduleLabel' => "Stato civile", 'templatePartial' => 'form-message.phtml')); $this->layout()->setTemplate($mainLayout); } else { $referer = $this->getRequest()->getHeader('Referer'); if (is_object($referer)) { return $this->redirect()->toUrl($referer->getUri()); } return $this->redirect()->toRoute('main'); } }