/** * @return \Zend\Stdlib\ResponseInterface */ public function exportAction() { $export = new SundewExporting($this->contactTable()->fetchAll(false)); $response = $this->getResponse(); $filename = 'attachment; filename="Contact-' . date('YmdHis') . 'xlsx"'; $headers = $response->getHeaders(); $headers->addHeaderLine('Content-Type', 'application/ms-excel; charset=UTF-8'); $headers->addHeaderLine('Content-Disposition', $filename); $response->setContent($export->getExcel()); return $response; }
/** * @return \Zend\Stdlib\ResponseInterface */ public function exportAction() { $year = $this->params()->fromRoute('year', date('Y')); $month = $this->params()->fromRoute('month', date('m')); $fromDate = $year . '-' . $month . '-01'; $toDate = date('Y-m-t', strtotime($fromDate)); $vouchers = $this->voucherTable()->getVouchersByDate($fromDate, $toDate, 0, $this->getSkipTypes(), false); $response = $this->getResponse(); $filename = 'attachment; filename="Vouchers(' . $year . '-' . $month . ')-' . date('YmdHis') . '.xlsx"'; $export = new SundewExporting($vouchers); $excel = $export->getExcel(); $headers = $response->getHeaders(); $headers->addHeaderLine('Content-Type', 'application/ms-excel; charset=UTF-8'); $headers->addHeaderLine('Content-Disposition', $filename); $response->setContent($excel); return $response; }