public function indexAction() { $this->accessRights(13); //Accept Parent Module, Return Main Menu Lists with Active Menu Indicator $this->childModuleAccessRights(40, 'view'); //Accept Child Module ID & it's Actions: add, edit, view, disable $this->adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $result = $this->getMarketHighlightTable()->fetchMarketHighlight($this->adapter); $request = $this->getRequest(); $marketform = new MarketHighlightForm(); if ($request->isPost()) { $from = $_POST['search_from']; $to = $_POST['search_to']; $marketform->get('search_from')->setValue($from); $marketform->get('search_to')->setValue($to); $result = $this->getMarketHighlightTable()->fetchMarketHighlight($this->adapter, $from, $to); } return array('markethighlight' => $result, 'form_markethighlight' => $marketform, 'access_rights' => $this->getSubModuleAccessRights(40)); }
public function reportMarketHighlightExcelAction() { $this->accessRights(20); //Accept Parent Module, Return Main Menu Lists with Active Menu Indicator $this->adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $marketform = new MarketHighlightForm(); //Get Post Data & Redirect to Filter Function $request = $this->getRequest(); //Get form object if ($request->isPost()) { $from = $_POST['market_highlight_from_excel']; $to = $_POST['market_highlight_to_excel']; $marketform->get('search_from')->setValue($from); $marketform->get('search_to')->setValue($to); $result = $this->getMarketHighlightTable()->fetchMarketHighlight($this->adapter, $from, $to); } //error_reporting(0); $objPHPExcel = new \PHPExcel(); ############################### Set properties ################################## $objPHPExcel->getProperties()->setCreator($this->currentUserFullName()); $objPHPExcel->getProperties()->setTitle("Market Highlight Report"); $objPHPExcel->getActiveSheet()->setTitle('Market Highlight Report'); ############################### /Set properties ################################# $objPHPExcel->setActiveSheetIndex(0); ################################## HEADER TABLE ################################# $this->setCompanyLogo($objPHPExcel); //Set Company Logo $objPHPExcel->getActiveSheet()->setCellValue('B3', "Market Highlight Report"); $objPHPExcel->getActiveSheet()->getStyle('B3')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('B3')->getFont()->setSize(16); ################################## /HEADER TABLE ################################ ################################## Table ##################################### $objPHPExcel->getActiveSheet()->SetCellValue('B5', 'DATE')->SetCellValue('C5', 'FOREX')->SetCellValue('D5', 'AEV')->SetCellValue('E5', 'AP')->SetCellValue('F5', 'UBP'); $objPHPExcel->getActiveSheet()->getStyle("A35:E35")->getFont()->setBold(true); //Make Label Bold $cell_number = 5; foreach ($result as $market_highlight_value) { $cell_number++; $objPHPExcel->getActiveSheet()->SetCellValue('B' . $cell_number, $market_highlight_value['mh_date'])->SetCellValue('C' . $cell_number, $market_highlight_value['forex'])->SetCellValue('D' . $cell_number, $market_highlight_value['aev'])->SetCellValue('E' . $cell_number, $market_highlight_value['ap'])->SetCellValue('F' . $cell_number, $market_highlight_value['ubp']); } ################################## Table #################################### ################################## Save Excel ################################# $this->authResizeColumn($objPHPExcel); //Auto Resize Column $this->downloadFile('export-market-highlight.xlsx'); //Download File $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save("php://output"); //Download File die; ################################## /Save Excel ################################# }