' . "Customer Cash Report" . '
';
$msg .= '
' . TABLE_VIEW_BY . ': '."Cash Report Summary".'';
$excelContent .= "CustomerCash Report"."\n";
$excelContent .= TABLE_VIEW_BY.": Cash Report Summary\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_CUSTOMER_NAME."\t".TABLE_PRODUCT_NAME."\t".TABLE_QTY."\t".TABLE_UOM."\t".GENERAL_AMOUNT;
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
= DATE_FORMAT(orders.order_date, "%Y-%m-%d")';
}
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'orders.status BETWEEN 2 AND 5';
if ($col[3] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= '(SELECT rt.id FROM room_types AS rt WHERE id IN (SELECT room_type_id FROM rooms WHERE id = orders.room_id AND room_type_id ='.$col[3].'))';
}
if ($col[4] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'orders.company_id=' . $col[4];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'orders.company_id IN (SELECT company_id FROM user_companies WHERE user_id = '.$user['User']['id'].')';
}
if ($col[5] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'orders.branch_id=' . $col[5];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'orders.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$user['User']['id'].')';
}
if ($col[6] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'created_by=' . $col[6];
}
if ($col[7] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'orders.customer_id=' . $col[7];
}
// declare
$grandTotalAmount=0;
$excelContent .= "\n".'Product'; ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
";
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|