/**
* CSV export
*
* @return \Zend\Http\Response|\Zend\Stdlib\ResponseInterface
* @throws \ModelModule\Model\NullException
*/
public function csvAction()
{
if ($this->getRequest()->isPost()) {
$request = $this->getRequest();
$post = array_merge_recursive($request->getPost()->toArray(), $request->getFiles()->toArray());
$form = new StatoCivileFormSearch();
$form->setBindOnValidate(false);
$form->setData($post);
if ($form->isValid()) {
$sessionContainer = new SessionContainer();
$sessionContainer->offsetSet('statoCivileFormSearch', $post);
$em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default');
$wrapper = new StatoCivileGetterWrapper(new StatoCivileGetter($em));
$wrapper->setInput(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', 'limit' => 1500));
$wrapper->setupQueryBuilder();
$records = $wrapper->getRecords();
if (!empty($records)) {
$arrayContent = array();
$arrayContent[] = array('Titolo', 'Numero \\ Anno', 'Inserito il', 'Scadenza');
foreach ($records as $record) {
$arrayContent[] = array($record['titolo'], $record['progressivo'] . ' / ' . $record['anno'], $record['data']->format("d-m-Y"), $record['scadenza']->format("d-m-Y"));
}
$csvExportHelper = new CsvExportHelper();
$content = $csvExportHelper->makeCsvLine($arrayContent);
$response = $this->getResponse();
$response->getHeaders()->addHeaderLine('Content-Type', 'text/csv')->addHeaderLine('Content-Disposition', 'attachment; filename="stato_civile_' . date("dmYHis") . '.csv"')->addHeaderLine('Accept-Ranges', 'bytes')->addHeaderLine('Content-Length', strlen($content));
$response->setContent($content);
return $response;
}
}
}
return $this->redirectForUnvalidAccess();
}
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');
}
}
