/**
* 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();
}
/**
* 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');
}
}
