' . MENU_REPORT_RECEIVE_PAYMENTS . '
';
if($_POST['date_from']!='') {
$msg .= REPORT_FROM.': '.$_POST['date_from'];
}
if($_POST['date_to']!='') {
$msg .= ' '.REPORT_TO.': '.$_POST['date_to'];
}
echo $this->element('/print/header-report',array('msg'=>$msg));
/**
* export to excel
*/
$filename="public/report/customer_receive_payment_" . $user['User']['id'] . ".csv";
$fp=fopen($filename,"wb");
$excelContent = MENU_REPORT_RECEIVE_PAYMENTS . "\n\n";
if($_POST['date_from']!='') {
$excelContent .= REPORT_FROM . ': ' . $_POST['date_from'];
}
if($_POST['date_to']!='') {
$excelContent .= ' '.REPORT_TO . ': ' . $_POST['date_to'];
}
$excelContent .= "\n\n".TABLE_NO."\t".TABLE_DATE."\t".TABLE_CODE."\t".TABLE_INVOICE_DATE."\t".TABLE_INVOICE_CODE."\t".TABLE_ACCOUNT."\t".TABLE_CREATED_BY."\t".GENERAL_AMOUNT."(".$rowCur[0].")";
?>
|
|
|
|
|
|
|
() |
= gl.date';
}
if ($_POST['branch_id'] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'gld.branch_id=' . $_POST['branch_id'];
}else{
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'gld.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$user['User']['id'].')';
}
if ($_POST['cgroup_id'] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'gld.customer_id IN (SELECT customer_id FROM customer_cgroups WHERE cgroup_id=' . $_POST['cgroup_id'] . ')';
}
if ($_POST['customer_id'] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'gld.customer_id=' . $_POST['customer_id'];
}
$sqlPayment = mysql_query("
SELECT
gl.id,
customers.id AS customer_id,
customers.name AS customer_name,
gl.date,
rp.reference,
sales_orders.order_date AS invoice_date,
sales_orders.so_code AS invoice_code,
(SELECT CONCAT(account_codes,' - ',account_description) FROM chart_accounts WHERE id=gld.chart_account_id) AS account,
IF(gld.debit>0,gld.debit*-1,gld.credit) AS amount,
users.username
FROM general_ledgers gl
INNER JOIN receive_payments AS rp ON rp.id = gl.receive_payment_id
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
INNER JOIN customers ON customers.id = gld.customer_id
LEFT JOIN sales_orders ON sales_orders.id = gl.sales_order_id
LEFT JOIN users ON users.id = gl.created_by
WHERE gl.is_approve=1 AND gl.is_active=1 AND gl.receive_payment_id IS NOT NULL AND gld.chart_account_id IN (SELECT id FROM chart_accounts WHERE chart_account_type_id=2)
".$condition);
$index = 1;
$tmpId = "";
$tmpName = "";
$amount = 0;
$amountTotal = 0;
while($rowPayment = mysql_fetch_array($sqlPayment)){
if ($rowPayment['customer_id'] != $tmpId) {
if($tmpName != ""){
$excelContent .= "\n".'Total '.$tmpName."\t\t\t\t\t\t\t".number_format($amount, 2);
?>
| Total |
|
| ' . $rowPayment['customer_name'] . ''; ?> |
| ' . $index++ . ''; ?> |
|
|
|
|
|
|
|
| Total |
|
| |
| Total Amount |
|