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