public static function convertUserReportArray($data)
{
foreach ($data as $k => $val) {
$userInfo = Utility::getUserInfo($val['userId']);
$data[$k]['userId'] = $userInfo->getUserName();
$data[$k]['id'] = $k;
}
return $data;
}
public function convertSingleToArray($data)
{
$tableInfo = Utility::getTableInfo($data->getTableid());
$config = Utility::getConfig();
$code = '';
$value = '';
$desc = '';
if ($data->getCouponId() != -1) {
$coupon = Utility::getCouponInfo($data->getCouponId());
// echo '<pre>';
// print_r($coupon);
// echo '</pre>';
$code = $coupon->getCode();
if ($coupon->getReuse() == 1) {
$code = $coupon->getDescription();
}
$type = $coupon->getType();
if ($type == 0) {
$value = 'Reduce :' . number_format($coupon->getValue()) . ' ' . $config['currency'];
} else {
$value = 'Reduce :' . $coupon->getValue() . '%';
}
$desc = $coupon->getDescription();
}
$userInfo = Utility::getUserInfo($data->getUserId());
$surtax = Utility::getSurTaxInfo($data->getSurtaxId());
if ($surtax) {
$surtaxType = $surtax->getType();
$surtaxValue = $surtax->getValue();
} else {
$surtaxType = 'Cash';
$surtaxValue = 0;
}
$taxType = Utility::convertSurtaxType($surtaxType);
//print_r($coupon);
$array = array();
$array['id'] = $data->getId();
$array['tableId'] = $tableInfo->getName();
$array['createDate'] = date('d/m/Y h:i:s', $data->getCreateDate());
$array['totalCost'] = number_format($data->getTotalCost());
$array['totalRealCost'] = number_format($data->getTotalRealCost());
$array['coupon'] = $code;
$array['couponValue'] = $value;
$array['couponDesc'] = $desc;
$array['surtax'] = number_format($surtaxValue) . ' ' . $taxType;
$array['userid'] = $userInfo->getUserName();
$array['status'] = $data->getStatus();
$array['customer_id'] = $data->getCustomerId();
$array['newDate'] = $data->getNewDate();
return $array;
}
public function convertToArray($datas)
{
$return = array();
foreach ($datas as $data) {
$userInfo = Utility::getUserInfo($data->getUserId());
$array = array();
$array['id'] = $data->getId();
$array['userId'] = $userInfo->getFullName();
$array['action'] = $data->getAction();
$array['time'] = date("d-m-y H:i:s", $data->getTime());
$return[] = $array;
}
return $return;
}
public function indexAction()
{
if ($this->getRequest()->isPost()) {
$str = '';
$strOrder = '';
$fromDate = '';
$toDate = '';
$strUser = '';
$strMenu = '';
$strMenuForAllMenu = '';
$params = $this->params()->fromPost();
$fromDate = $params['formDate'];
$toDate = $params['toDate'];
$user = $params['user'];
$strUserOrder = '';
$userText = '';
$fromText = '';
$toText = '';
$menuText = '';
if ($fromDate) {
$fromDateTime = strtotime($fromDate . ' 00:00:00');
$str .= ' AND table.createDate >= ' . $fromDateTime;
$strOrder .= ' AND o.createDate >= ' . $fromDateTime;
$fromText = $this->translator->translate('from ') . date('d-m-Y', $fromDateTime);
}
if ($toDate) {
$toDateTime = strtotime($toDate . ' 23:59:00');
$str .= ' AND table.createDate <= ' . $toDateTime;
$strOrder .= ' AND o.createDate <= ' . $toDateTime;
$toText = $this->translator->translate(' to ') . date('d-m-Y', $toDateTime);
}
if (isset($params['user']) && $params['user'] != 0) {
$strUserOrder .= ' AND table.userId = ' . $user;
$strUser .= ' AND table.userId = ' . $user;
$userInfo = Utility::getUserInfo($user);
$userText = $this->translator->translate(' by ') . $userInfo->getUserName();
}
if (isset($params['menu']) && $params['menu'] != 0) {
$strMenu .= ' AND mn.catId =' . $params['menu'];
$strMenuForAllMenu .= ' AND table.id = od.orderId AND od.menuId = mn.id ' . $strMenu;
$menuInfo = Utility::getCatInfo($params['menu']);
$menuText = $this->translator->translate(' in ') . $menuInfo->getName();
}
// fetch data
$orderBy = " ";
$reportMenu = $this->modelOrderDetail->createQueryMenu('table.isdelete = 0 ' . $strOrder . $strMenu);
$reportMenu = reportModel::convertMenuReportArray($reportMenu);
$reporAllOrder = $this->modelOrder->createQueryAllMenu('table.isdelete = 0 ' . $str . $strUser);
/* report order and count cost by menu id */
if (isset($params['menu']) && $params['menu'] != 0) {
$reporAllOrder = $this->modelOrder->createQueryByMenu('table.isdelete = 0 ' . $str . $strUser . $strMenuForAllMenu);
}
// echo '<pre>';
// print_r($reportMenu);
// echo '<hr/>';
// print_r($reporAllOrder);
// die;
// remove all report file
Utility::deleteAllFileInFolder('public/export/');
$link = renderExcel::renderMenuOrder($reportMenu);
$reportText = $this->translator->translate('Report ') . $fromText . $toText . $userText . $menuText;
$dataMenu = array('tableTitle' => $this->translator->translate('Report menu'), 'link' => 'admin/order', 'data' => $reportMenu, 'heading' => array('orderDetailId' => $this->translator->translate('Order Detail Id'), 'OrderId' => $this->translator->translate('Order Id'), 'menuId' => $this->translator->translate('Name'), 'menuName' => $this->translator->translate('Menu'), 'count_menu' => $this->translator->translate('Count number'), 'realCost' => $this->translator->translate('Real cost'), 'time' => $this->translator->translate('Time')), 'hideEditButton' => 1, 'hideDeleteButton' => 1, 'hideDetailButton' => 1);
return new ViewModel(array('totalTable' => $reporAllOrder[0]['count_table'], 'tCost' => $reporAllOrder[0]['tCost'], 'tRCost' => $reporAllOrder[0]['tRCost'], 'excelLink' => $link, 'reportText' => $reportText, 'reportMenu' => $dataMenu, 'title' => $this->translator->translate('Report')));
}
return new ViewModel(array('title' => $this->translator->translate('Report')));
}