X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sales%2Finquiry%2Fcustomer_inquiry.php;h=d6851aa027d473dad652b79910306dc0f12106b3;hb=9988555dbed61bdf6a11a19eb6a4ec52dc0d586c;hp=b90eacec5b5a41b3e637717ba31c3796a38f29a4;hpb=8ffddf50ffbe93672c769e2cf0501d0f9125e2a0;p=fa-stable.git diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php index b90eacec..d6851aa0 100644 --- a/sales/inquiry/customer_inquiry.php +++ b/sales/inquiry/customer_inquiry.php @@ -41,7 +41,7 @@ start_table(TABLESTYLE_NOBORDER); start_row(); if (!$page_nested) - customer_list_cells(_("Select a customer: "), 'customer_id', null, true, false, false, !@$_GET['popup']); + customer_list_cells(_("Select a customer: "), 'customer_id', null, true, false, false, true); date_cells(_("From:"), 'TransAfterDate', '', null, -user_transaction_days()); date_cells(_("To:"), 'TransToDate', '', null); @@ -135,24 +135,14 @@ function gl_view($row) return get_gl_view_str($row["type"], $row["trans_no"]); } -function fmt_debit($row) +function fmt_amount($row) { $value = $row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT || $row['type']==ST_JOURNAL ? -$row["TotalAmount"] : $row["TotalAmount"]; - return $value>=0 ? price_format($value) : ''; - + return price_format($value); } -function fmt_credit($row) -{ - $value = - !($row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT || $row['type']==ST_JOURNAL) ? - -$row["TotalAmount"] : $row["TotalAmount"]; - return $value>0 ? price_format($value) : ''; -} - - function credit_link($row) { global $page_nested; @@ -196,7 +186,7 @@ $sql = get_sql_for_customer_inquiry(get_post('TransAfterDate'), get_post('TransT get_post('customer_id'), get_post('filterType')); //------------------------------------------------------------------------------------------------ -db_query("set @bal:=0"); +//db_query("set @bal:=0"); $cols = array( _("Type") => array('fun'=>'systype_name', 'ord'=>''), @@ -208,9 +198,8 @@ $cols = array( _("Customer") => array('ord'=>''), _("Branch") => array('ord'=>''), _("Currency") => array('align'=>'center'), - _("Debit") => array('align'=>'right', 'fun'=>'fmt_debit'), - _("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'), - _("RB") => array('align'=>'right', 'type'=>'amount'), + _("Amount") => array('align'=>'right', 'fun'=>'fmt_amount'), +// _("RB") => array('align'=>'right', 'type'=>'amount'), array('insert'=>true, 'fun'=>'gl_view'), array('insert'=>true, 'fun'=>'credit_link'), array('insert'=>true, 'fun'=>'edit_link'),