' . MENU_REPORT_SALES_ORDER_BY_REP . '
';
$excelContent .= MENU_REPORT_SALES_ORDER_BY_REP."\n\n";
if($_POST['date_from']!='') {
$msg .= REPORT_FROM.': '.$_POST['date_from'];
$excelContent .= REPORT_FROM.': '.$_POST['date_from'];
}
if($_POST['date_to']!='') {
$msg .= ' '.REPORT_TO.': '.$_POST['date_to'];
$excelContent .= ' '.REPORT_TO.': '.$_POST['date_to']."\n\n";
}
echo $this->element('/print/header-report',array('msg'=>$msg));
$excelContent .= TABLE_NO."\t".TABLE_NAME."\t".TABLE_INVOICE_CODE."\t".TABLE_PRODUCT_NAME."\t".TABLE_CUSTOMER."\t".TABLE_LOCATION."\t".GENERAL_AMOUNT;
?>
|
|
|
|
|
|
|
= DATE(order_date)';
}
$condition != '' ? $condition .= ' AND ' : '';
if ($col[3] == '') {
$condition .= 'status!=0';
} else {
$condition .= 'status=' . $col[3];
}
if ($col[4] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'company_id=' . $col[4];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'company_id IN (SELECT company_id FROM user_companies WHERE user_id = '.$user['User']['id'].')';
}
if ($col[5] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'branch_id=' . $col[5];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$user['User']['id'].')';
}
if ($col[6] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'location_group_id=' . $col[6];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'location_group_id IN (SELECT location_group_id FROM user_location_groups WHERE user_id = '.$user['User']['id'].')';
}
if ($col[11] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'created_by=' . $col[11];
}
if ($_POST['cgroup_id'] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= $_POST['cgroup_id'] . ' IN (SELECT cgroup_id FROM customer_cgroups WHERE customer_cgroups.customer_id=tbl.customer_id)';
}
if ($_POST['customer_id'] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'tbl.customer_id=' . $_POST['customer_id'];
}
// declare
$grandTotalAmount=0;
$excelContent .= "\n".'Product'; ?>
| Product |
|
|
|
|
|
|
| Total Product |
|
| |
| Service |
|
|
|
|
|
|
| Total Service |
|
| |
| Miscellaneous |
|
|
|
|
|
|
| Total Miscellaneous |
|
| |
| Grand Total Amount |
|
|
|
|
|