' . MENU_REPORT_PAY_BILLS . '
';
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/vendor_pay_bill_" . $user['User']['id'] . ".csv";
$fp=fopen($filename,"wb");
$excelContent = MENU_REPORT_PAY_BILLS . "\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_PURCHASE_BILL_CODE."\t".TABLE_ACCOUNT."\t".TABLE_MEMO."\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['vendor_id'] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'gld.vendor_id=' . $_POST['vendor_id'];
}
$sqlPaybill = mysql_query("SELECT
gl.id,
gl.date,
rp.reference,
purchase_orders.po_code AS bill_code,
vendors.id AS vendor_id,
CONCAT_WS(' ',vendors.vendor_code,vendors.name) AS vendor_name,
(SELECT CONCAT(account_codes,' - ',account_description) FROM chart_accounts WHERE id=gld.chart_account_id) AS account,
IF(gld.debit>0,gld.debit,gld.credit*-1) AS amount,
rp.note,
users.username
FROM general_ledgers gl
INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id
INNER JOIN vendors ON vendors.id = gld.vendor_id
INNER JOIN pay_bills AS rp ON rp.id = gl.pv_id
LEFT JOIN purchase_orders ON purchase_orders.id = gl.purchase_order_id
LEFT JOIN users ON users.id = gl.created_by
WHERE gl.is_approve=1 AND gl.is_active=1 AND gl.pv_id IS NOT NULL AND gld.chart_account_id IN (SELECT id FROM chart_accounts WHERE chart_account_type_id = 6)
".$condition);
$index = 1;
$tmpId = "";
$tmpName = "";
$amount = 0;
$amountTotal = 0;
while($rowPaybill = mysql_fetch_array($sqlPaybill)){
if ($rowPaybill['vendor_id'] != $tmpId) {
if($tmpName != ""){
$excelContent .= "\n".'Total '.$tmpName."\t\t\t\t\t\t\t".number_format($amount, 2);
?>
| Total |
|
| ' . $rowPaybill['vendor_name'] . ''; ?> |
| ' . $index++ . ''; ?> |
|
|
|
|
|
|
|
| Total |
|
| |
| Total Amount |
|