public function exportExcelAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$export_array = array();
$stock_master = new Model_StockMaster();
$stock_master->form_values['searchby'] = $this->_request->searchby;
$stock_master->form_values['number'] = $this->_request->number;
$stock_master->form_values['warehouses'] = $this->_request->warehouses;
$stock_master->form_values['product'] = $this->_request->product;
$stock_master->form_values['date_from'] = $this->_request->date_from;
$stock_master->form_values['date_to'] = $this->_request->date_to;
$data = $stock_master->getTempStockIssue();
array_push($export_array, array("Item Name", "Transaction Date", "Transaction Number", "Transaction Reference", "Warehouse Name", "Batch no.", "Expiry date", "Quantity", "Item Unit", "Doses per vial", "Total doses", "VVM Stage"));
foreach ($data as $row) {
array_push($export_array, array($row['itemName'], $row['transactionDate'], $row['transactionNumber'], $row['transactionReference'], $row['warehouseName'], $row['number'], $row['expiryDate'], $row['quantity'], $row['itemUnitName'], $row['description'], $row['quantity'] * $row['description'], $row['vvmStageValue']));
}
// generate file (constructor parameters are optional)
$xls = new App_PhpExcel('UTF-8', false, 'Issue List');
$xls->addArray($export_array);
$xls->generateXML('issue-list');
}
