' . MENU_REPORT_SALES_ORDER_BY_ITEM . '
';
$msg .= '
' . TABLE_VIEW_BY . ': '.TABLE_ITEM_DETAIL.'';
$excelContent .= MENU_REPORT_SALES_ORDER_BY_ITEM."\n";
$excelContent .= TABLE_VIEW_BY.": ".TABLE_ITEM_DETAIL."\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";
}
if($_POST['company_id']!='') {
$sqlCom = mysql_query("SELECT name FROM companies WHERE id = ".$_POST['company_id']);
$rowCom = mysql_fetch_array($sqlCom);
$msg .= '
'.MENU_COMPANY_MANAGEMENT.': '.$rowCom['name'];
$excelContent .= "\n".MENU_COMPANY_MANAGEMENT.': '.$rowCom['name'];
}
if($_POST['branch_id']!='') {
$sqlBrn = mysql_query("SELECT name FROM branches WHERE id = ".$_POST['branch_id']);
$rowBrn = mysql_fetch_array($sqlBrn);
$msg .= '
'.MENU_BRANCH.': '.$rowBrn['name'];
$excelContent .= "\n".MENU_BRANCH.': '.$rowBrn['name'];
}
if($_POST['customer_id']!='') {
$sqlCus = mysql_query("SELECT CONCAT_WS(' - ',customer_code,name) FROM customers WHERE id = ".$_POST['customer_id']);
$rowCus = mysql_fetch_array($sqlCus);
$msg .= '
'.MENU_CUSTOMER.': '.$rowCus[0];
$excelContent .= "\n".MENU_CUSTOMER.': '.$rowCus[0];
}
echo $this->element('/print/header-report',array('msg'=>$msg));
$excelContent .= TABLE_NO."\t".TABLE_TYPE."\t".TABLE_DATE."\t".TABLE_PRODUCT_NAME."\t".TABLE_INVOICE_CODE."\t".TABLE_CUSTOMER."\t".TABLE_LOCATION_GROUP."\t".TABLE_QTY."\t".TABLE_UOM."\t".TABLE_PRICE."\t".TABLE_SUB_TOTAL."\t".TABLE_TOTAL_COST."\t".GENERAL_DISCOUNT."\t".GENERAL_AMOUNT."\t".TABLE_GROSS_PROFIT;
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
= DATE(sales.order_date)';
}
$condition != '' ? $condition .= ' AND ' : '';
if ($col[3] == '') {
$condition .= 'sales.status>-1';
} else {
$condition .= 'sales.status=' . $col[3];
}
if ($col[4] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.company_id=' . $col[4];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.company_id IN (SELECT company_id FROM user_companies WHERE user_id = '.$user['User']['id'].')';
}
if ($col[5] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.branch_id=' . $col[5];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$user['User']['id'].')';
}
if ($col[6] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.location_group_id=' . $col[6];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.location_group_id IN (SELECT location_group_id FROM user_location_groups WHERE user_id = '.$user['User']['id'].')';
}
if ($col[10] != '') {
$condition != '' ? $condition .= ' AND ' : '';
if($col[10] == 1){
$condition .= 'qty > 0';
} else {
$condition .= 'qty_free > 0';
}
}
if ($col[11] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.created_by=' . $col[11];
}
if ($col[13] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'sales.customer_id=' . $col[13];
}
// declare
$grandSubTotalAmount = 0;
$grandTotalCost = 0;
$grandTotalDiscount = 0;
$grandTotalAmount = 0;
$grandTotalProfit = 0;
$excelContent .= "\n".'Product'; ?>
| Product |
| Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total |
|
|
|
|
|
|
|
|
| Total Product |
|
|
|
|
|
| |
| Service |
| Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total |
|
|
|
|
|
|
|
| Total Service |
|
|
|
|
|
|
|
| |
| Grand Total Amount |
|
|
|
|
|
|
|
|
|