public function reportExpenseAction()
{
$allCategory = Utility::getPaymentCate();
$result = array();
$link = false;
$reportTitle = '';
if ($this->getRequest()->isPost()) {
$data = $this->params()->fromPost();
$categoryId = $data['expense_category'];
$strTime = ' ';
$strCategory = '';
if ($categoryId != 0) {
$strCategory .= ' table.categoryId = ' . $categoryId;
} else {
$strCategory .= ' table.categoryId != -1 ';
}
if ($data['start'] != '' || $data['end'] != '') {
$strTime .= ' AND table.time >= ' . strtotime($data['start']);
$strTime .= ' AND table.time <= ' . strtotime($data['end']);
}
$result = $this->modelPayment->createQueryToArray($strCategory . $strTime);
$category = Utility::getPaymentCateInfo($categoryId);
$reportTitle = 'Report Expense in ' . $data['start'] . ' to ' . $data['end'] . ' by Category ' . $category->getName();
if (isset($data['excel']) && $data['excel'] == true) {
// $reportTitle = 'Report Expense in ' . $data['start'] . ' to ' . $data['end'] .' by Category '.$category->getName() ;
// $dataExcel = $this->modelPayment->convertToArray($result);
$column = array('id' => ' id', 'title' => 'Name', 'value' => 'Quantity', 'reason' => 'Reason', 'time' => 'Time', 'categoryId' => 'Category');
$link = renderExcel::renderExcelBasic($result, $column, $reportTitle);
return self::forceDownloadAction($link);
}
}
return new ViewModel(array('title' => $reportTitle, 'result' => $result, 'categories' => $allCategory, 'linkDownload' => $link));
}
public function exportMenuAction()
{
$str = '';
$strOrder = '';
$fromDate = '';
$toDate = '';
if ($this->getRequest()->isPost()) {
$params = $this->params()->fromPost();
$fromDate = $params['formDate'];
$toDate = $params['toDate'];
if ($fromDate) {
$fromDateTime = strtotime($fromDate . ' 00:00:00');
$strOrder .= ' AND o.createDate >= ' . $fromDateTime;
}
if ($toDate) {
$toDateTime = strtotime($toDate . ' 23:59:00');
$strOrder .= ' AND o.createDate <= ' . $toDateTime;
}
}
$str .= 'o.isdelete = 0';
$reportMenus = $this->modelOrderDetail->createQueryMenu($str . $strOrder);
$link = renderExcel::renderMenuOrder($reportMenus);
echo '<a href="/' . $link . '">Download</a>';
die;
}
