public function indexAction() { $mainLayout = $this->initializeAdminArea(); $id = $this->params()->fromRoute('id'); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); try { $helper = new StatoCivileControllerHelper(); $sezioniRecords = $helper->recoverWrapperRecords(new StatoCivileSezioniGetterWrapper(new StatoCivileSezioniGetter($em)), array('orderBy' => '')); $helper->checkRecords($sezioniRecords, 'Nessuna sezione presente'); $sezioniForDropDown = $helper->formatForDropwdown($sezioniRecords, 'id', 'nome'); $records = $helper->recoverWrapperRecordsById(new StatoCivileGetterWrapper(new StatoCivileGetter($em)), array('id' => $id, 'limit' => 1), $id); $form = new StatoCivileForm(); $form->addSezioni($sezioniForDropDown); $form->addDates(); if (empty($records)) { $form->setData(array('data' => date('Y-m-d H:i:s', strtotime(date("Y-m-d H:i:s") . ' + 8 days')), 'scadenza' => date('Y-m-d H:i:s', strtotime(date("Y-m-d H:i:s") . ' + 8 days')), 'numero_progressivo' => '')); $formAction = $this->url()->fromRoute('admin/stato-civile-insert', array('lang' => $this->params()->fromRoute('lang'))); $formTitle = 'Nuovo atto stato civile'; } else { $form->setData($records[0]); $formAction = $this->url()->fromRoute('admin/stato-civile-update', array('lang' => $this->params()->fromRoute('lang'))); $formTitle = 'Modifica atto'; } $this->layout()->setVariables(array('form' => $form, 'formTitle' => $formTitle, 'formDescription' => 'È consigliabile inserire <strong>testi brevi sul tema trattato</strong>, possibilmente in minuscolo e con solo la prima iniziale maiuscola', 'formAction' => $formAction, 'formBreadCrumbCategory' => 'Stato civile', 'formBreadCrumbCategoryLink' => $this->url()->fromRoute('admin/stato-civile-summary', array('lang' => $this->params()->fromRoute('lang'))), 'templatePartial' => self::formTemplate)); } catch (\Exception $e) { $this->layout()->setVariables(array('messageType' => 'danger', 'messageTitle' => 'Errore verificato', 'messageText' => $e->getMessage(), 'templatePartial' => 'message.phtml')); } $this->layout()->setTemplate($mainLayout); }
/** * Stato civile details */ public function detailsAction() { $mainLayout = $this->initializeFrontendWebsite(); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $id = $this->params()->fromRoute('id'); $helper = new StatoCivileControllerHelper(); $wrapper = $helper->recoverWrapperById(new StatoCivileGetterWrapper(new StatoCivileGetter($em)), array('id' => $id, 'limit' => 1), $id); $wrapper->setEntityManager($em); $articoloRecord = $wrapper->addAttachmentsToPaginatorRecords($wrapper->getRecords(), array('moduleId' => ModulesContainer::stato_civile_id)); $this->layout()->setVariables(array('records' => !empty($articoloRecord) ? $articoloRecord[0] : null, 'notfound' => empty($articoloRecord), 'templatePartial' => 'stato-civile/stato-civile-details.phtml')); $this->layout()->setTemplate($mainLayout); }
public function indexAction() { $mainLayout = $this->initializeAdminArea(); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $id = $this->params()->fromRoute('id'); $lang = $this->params()->fromRoute('lang'); $helper = new StatoCivileControllerHelper(); $records = $helper->recoverWrapperRecordsById(new StatoCivileSezioniGetterWrapper(new StatoCivileSezioniGetter($em)), array('id' => $id, 'limit' => 1), $id); $form = new StatoCivileSezioniForm(); if (!empty($records)) { $form->setData($records[0]); $formAction = $this->url()->fromRoute('admin/stato-civile-sezioni-update', array('lang' => $lang)); $formTitle = 'Modifica sezione'; $formBreadCrumbTitle = 'Modifica'; } else { $formAction = $this->url()->fromRoute('admin/stato-civile-sezioni-insert', array('lang' => $lang)); $formTitle = 'Nuova'; $formBreadCrumbTitle = 'Nuova sezione'; } $this->layout()->setVariables(array('form' => $form, 'formAction' => $formAction, 'formTitle' => $formTitle, 'formDescription' => 'Compila il form e premi il pulsante per confermare', 'formBreadCrumbCategory' => array(array('label' => 'Stato civile', 'href' => $this->url()->fromRoute('admin/stato-civile-summary', array('lang' => $lang)), 'title' => "Elenco atti stato civile"), array('label' => 'Sezioni', 'href' => $this->url()->fromRoute('admin/stato-civile-sezioni-summary', array('lang' => $lang)), 'title' => "Elenco sezioni stato civile")), 'formBreadCrumbTitle' => $formBreadCrumbTitle, 'templatePartial' => self::formTemplate)); $this->layout()->setTemplate($mainLayout); }
public function indexAction() { /** * @var \Doctrine\ORM\EntityManager $em */ $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); /** * @var \Doctrine\DBAL\Connection $connection */ $connection = $em->getConnection(); $request = $this->getRequest(); $post = array_merge_recursive($request->getPost()->toArray(), $request->getFiles()->toArray()); if (!($request->isXmlHttpRequest() or $request->isPost())) { return $this->redirect()->toRoute('main'); } $inputFilter = new StatoCivileFormInputFilter(); $form = new StatoCivileForm(); $form->setBindOnValidate(false); $form->setInputFilter($inputFilter->getInputFilter()); $form->setData($post); $this->initializeAdminArea(); $userDetails = $this->recoverUserDetails(); $helper = new StatoCivileControllerHelper(); $helper->setConnection($connection); $helper->getConnection()->beginTransaction(); try { if (!$form->isValid()) { throw new NullException("The form is not valid"); } $inputFilter->exchangeArray($form->getData()); $helper->setLoggedUser($userDetails); $inputFilter->progressivo = $helper->recoverNumeroProgressivo(new StatoCivileGetterWrapper(new StatoCivileGetter($em))); $lastInsertId = $helper->insert($inputFilter); $helper->getConnection()->commit(); $logWriter = new LogWriter($connection); $logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::stato_civile_id, 'message' => "Inserito nuovo atto stato civile " . $inputFilter->titolo, 'type' => 'info', 'reference_id' => $lastInsertId, 'backend' => 1)); $this->layout()->setVariables(array('messageType' => 'success', 'messageTitle' => 'Atto stato civile inserito correttamente', 'messageText' => 'I dati sono stati processati correttamente dal sistema', 'showLinkResetFormAndShowIt' => 1, 'backToSummaryLink' => $this->url()->fromRoute('admin/stato-civile-summary', array('lang' => $this->params()->fromRoute('lang'))), 'backToSummaryText' => "Elenco atti", 'insertAgainLabel' => "Inserisci un altro atto", 'attachmentsLink' => $this->url()->fromRoute('admin/attachments-summary', array('lang' => $this->params()->fromRoute('lang'), 'module' => 'stato-civile', 'referenceId' => $lastInsertId)))); } catch (\Exception $e) { try { $helper->getConnection()->rollBack(); } catch (\Doctrine\DBAL\ConnectionException $dbEx) { } $logWriter = new LogWriter($connection); $logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::stato_civile_id, 'message' => "Errore inserimento nuovo atto stato civile: " . $inputFilter->titolo, 'type' => 'error', 'description' => $e->getMessage(), 'reference_id' => $inputFilter->id, 'backend' => 1)); $this->layout()->setVariables(array('messageType' => 'danger', 'messageTitle' => 'Errore inserimento nuovo atto stato civile', 'messageText' => 'Messaggio generato: ' . $e->getMessage(), 'form' => $form, 'formInputFilter' => $inputFilter->getInputFilter(), 'messageShowFormLink' => 1, 'messageShowForm' => 'Torna al form')); } $this->layout()->setTemplate($this->layout()->getVariable('templateDir') . 'message.phtml'); }
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); }
/** * @return \Zend\Http\Response|JsonModel */ public function jsonAction() { $this->initializeFrontendWebsite(); $id = $this->params()->fromRoute('id'); $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $helper = new StatoCivileControllerHelper(); $wrapper = $helper->recoverWrapperById(new StatoCivileGetterWrapper(new StatoCivileGetter($em)), array('id' => $id, 'limit' => 1), $id); $wrapper->setEntityManager($em); $records = $wrapper->addAttachmentsFromRecords($wrapper->getRecords(), array()); if (empty($records)) { return $this->redirectForUnvalidAccess(); } $record = $records[0]; return new JsonModel(array('Titolo' => $record['titolo'], 'Numero \\ Anno' => $record['progressivo'] . ' \\ ' . $record['anno'], 'Scadenza' => $record['scadenza']->format("d-m-Y"), 'Sezione' => $record['nomeSezione'])); }
public function testRecoverNumeroProgressivo() { $progressivo = $this->helper->recoverNumeroProgressivo(new StatoCivileGetterWrapper(new StatoCivileGetter($this->getEntityManagerMock()))); $this->assertEquals($progressivo, 1); }