' . MENU_ACCOUNT_RECEIVABLE . '
';
$excelContent .= MENU_ACCOUNT_RECEIVABLE."\n\n";
$msg .= TABLE_DATE . ': ' . $_POST['date'] . '
';
$excelContent .= TABLE_DATE.": " . $_POST['date'] . "\n\n";
echo $this->element('/print/header-report',array('msg'=>$msg));
$excelContent .= TABLE_EMPLOYEE."\t".TABLE_CLASS."\tCurrent";
?>
|
|
Current |
- |
".$_POST['through'];
$excelContent .= "\t".TABLE_TOTAL;
?>
> |
|
|
|
0
AND credit_memo_receipt_id IS NULL");
$data1=mysql_fetch_array($query1);
$query2=mysql_query(" SELECT SUM(credit) AS amount,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND date<='" . dateConvert($_POST['date']) . "'
AND credit>0
AND (
sales_order_id IN (" . ($data1['arr_sales_order_id']!=""?$data1['arr_sales_order_id']:-1) . ")
OR
main_gl_id IN (" . ($data1['arr_main_gl_id']!=""?$data1['arr_main_gl_id']:-1) . ")
)");
$data2=mysql_fetch_array($query2);
$query3=mysql_query(" SELECT SUM(credit) AS amount,GROUP_CONCAT(credit_memo_id) AS arr_credit_memo_id,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND date='" . dateConvert($_POST['date']) . "'
AND date<='" . dateConvert($_POST['date']) . "'
AND credit>0
AND sales_order_id IS NULL
AND main_gl_id IS NULL");
$data3=mysql_fetch_array($query3);
$query4=mysql_query(" SELECT SUM(debit) AS amount,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND date<='" . dateConvert($_POST['date']) . "'
AND debit>0
AND (
credit_memo_id IN (" . ($data3['arr_credit_memo_id']!=""?$data3['arr_credit_memo_id']:-1) . ")
)");
$data4=mysql_fetch_array($query4);
$amount=$data1['amount']+$data4['amount']-$data2['amount']-$data3['amount'];
$amount=number_format($amount,2,".","");
$total_row+=$amount;
$total_col[$colIndex]+=$amount;
$excelContent .= "\t".($amount!=0 && $amount!=''?$amount:'-');
$glIdList=explode(",", ($data1['arr_gl_id']!=''?$data1['arr_gl_id'].',':'').($data2['arr_gl_id']!=''?$data2['arr_gl_id'].',':'').($data3['arr_gl_id']!=''?$data3['arr_gl_id'].',':'').($data4['arr_gl_id']!=''?$data4['arr_gl_id'].',':''));
$glIdListAll[$colIndex].=implode("-", $glIdList);
?>
"> |
0
AND credit_memo_receipt_id IS NULL");
$data1=mysql_fetch_array($query1);
$query2=mysql_query(" SELECT SUM(credit) AS amount,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND date<='" . dateConvert($_POST['date']) . "'
AND credit>0
AND (
sales_order_id IN (" . ($data1['arr_sales_order_id']!=""?$data1['arr_sales_order_id']:-1) . ")
OR
main_gl_id IN (" . ($data1['arr_main_gl_id']!=""?$data1['arr_main_gl_id']:-1) . ")
)");
$data2=mysql_fetch_array($query2);
$query3=mysql_query(" SELECT SUM(credit) AS amount,GROUP_CONCAT(credit_memo_id) AS arr_credit_memo_id,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND DATEDIFF('" . dateConvert($_POST['date']) . "',date) BETWEEN " . $from . " AND " . $to . "
AND date<='" . dateConvert($_POST['date']) . "'
AND credit>0
AND sales_order_id IS NULL
AND main_gl_id IS NULL");
$data3=mysql_fetch_array($query3);
$query4=mysql_query(" SELECT SUM(debit) AS amount,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND date<='" . dateConvert($_POST['date']) . "'
AND debit>0
AND (
credit_memo_id IN (" . ($data3['arr_credit_memo_id']!=""?$data3['arr_credit_memo_id']:-1) . ")
)");
$data4=mysql_fetch_array($query4);
$amount=$data1['amount']+$data4['amount']-$data2['amount']-$data3['amount'];
$amount=number_format($amount,2,".","");
$total_row+=$amount;
$total_col[++$colIndex]+=$amount;
$excelContent .= "\t".($amount!=0 && $amount!=''?$amount:'-');
$glIdList=explode(",", ($data1['arr_gl_id']!=''?$data1['arr_gl_id'].',':'').($data2['arr_gl_id']!=''?$data2['arr_gl_id'].',':'').($data3['arr_gl_id']!=''?$data3['arr_gl_id'].',':'').($data4['arr_gl_id']!=''?$data4['arr_gl_id'].',':''));
$glIdListAll[$colIndex].=implode("-", $glIdList);
?>
"> |
" . $_POST['through'] . "
AND date<='" . dateConvert($_POST['date']) . "'
AND debit>0
AND credit_memo_receipt_id IS NULL");
$data1=mysql_fetch_array($query1);
$query2=mysql_query(" SELECT SUM(credit) AS amount,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND date<='" . dateConvert($_POST['date']) . "'
AND credit>0
AND (
sales_order_id IN (" . ($data1['arr_sales_order_id']!=""?$data1['arr_sales_order_id']:-1) . ")
OR
main_gl_id IN (" . ($data1['arr_main_gl_id']!=""?$data1['arr_main_gl_id']:-1) . ")
)");
$data2=mysql_fetch_array($query2);
$query3=mysql_query(" SELECT SUM(credit) AS amount,GROUP_CONCAT(credit_memo_id) AS arr_credit_memo_id,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND DATEDIFF('" . dateConvert($_POST['date']) . "',date) > " . $_POST['through'] . "
AND date<='" . dateConvert($_POST['date']) . "'
AND credit>0
AND sales_order_id IS NULL
AND main_gl_id IS NULL");
$data3=mysql_fetch_array($query3);
$query4=mysql_query(" SELECT SUM(debit) AS amount,
GROUP_CONCAT(gl.id) AS arr_gl_id
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
WHERE is_active=1
AND chart_account_id IN (" . implode(",", $arrCoAIdList) . ")
".$accCon."
AND employee_id=" . $dataEmployee['id'] . $conClass . "
AND date<='" . dateConvert($_POST['date']) . "'
AND debit>0
AND (
credit_memo_id IN (" . ($data3['arr_credit_memo_id']!=""?$data3['arr_credit_memo_id']:-1) . ")
)");
$data4=mysql_fetch_array($query4);
$amount=$data1['amount']+$data4['amount']-$data2['amount']-$data3['amount'];
$amount=number_format($amount,2,".","");
$total_row+=$amount;
$total_col[++$colIndex]+=$amount;
$excelContent .= "\t".($amount!=0 && $amount!=''?$amount:'-');
$glIdList=explode(",", ($data1['arr_gl_id']!=''?$data1['arr_gl_id'].',':'').($data2['arr_gl_id']!=''?$data2['arr_gl_id'].',':'').($data3['arr_gl_id']!=''?$data3['arr_gl_id'].',':'').($data4['arr_gl_id']!=''?$data4['arr_gl_id'].',':''));
$glIdListAll[$colIndex].=implode("-", $glIdList);
?>
"> |
|
| Total |
|
|
|
|