X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fcustomer_allocation_inquiry.php;h=7dd21b43b7d7a4109dc1d27f9a6946f44f034381;hb=fe2e057d97e8a8bc2429025b861f9229c5b9fe05;hp=ab75d23767f914807f353a57303c75d92ae72469;hpb=c640dae024fb9554d476bd863a68ef82ada8822d;p=fa-stable.git diff --git a/sales/inquiry/customer_allocation_inquiry.php b/sales/inquiry/customer_allocation_inquiry.php index ab75d237..7dd21b43 100644 --- a/sales/inquiry/customer_allocation_inquiry.php +++ b/sales/inquiry/customer_allocation_inquiry.php @@ -82,12 +82,12 @@ function view_link($trans) function due_date($row) { - return $row["type"] == 10 ? $row["due_date"] : ''; + return $row["type"] == ST_SALESINVOICE ? $row["due_date"] : ''; } function fmt_balance($row) { - return $row["TotalAmount"] - $row["Allocated"]; + return ($row["type"] == ST_JOURNAL && $row["TotalAmount"] < 0 ? -$row["TotalAmount"] : $row["TotalAmount"]) - $row["Allocated"]; } function alloc_link($row) @@ -114,9 +114,10 @@ function alloc_link($row) { /*its a negative receipt */ return ''; - } elseif (($row["type"] == ST_SALESINVOICE && ($row['TotalAmount'] - $row['Allocated']) > 0) || $row["type"] == ST_BANKPAYMENT) + } elseif (($row["type"] == ST_SALESINVOICE && ($row['TotalAmount'] - $row['Allocated']) > 0) || + ($row["type"] == ST_JOURNAL && (ABS($row['TotalAmount']) - $row['Allocated']) > 0) || $row["type"] == ST_BANKPAYMENT) return pager_link(_("Payment"), - "/sales/customer_payments.php?customer_id=".$row["debtor_no"]."&SInvoice=" . $row["trans_no"], ICON_MONEY); + "/sales/customer_payments.php?customer_id=".$row["debtor_no"]."&SInvoice=" . $row["trans_no"]."&Type=".$row["type"], ICON_MONEY); } @@ -144,9 +145,9 @@ $sql = get_sql_for_customer_allocation_inquiry(get_post('TransAfterDate'), get_p //------------------------------------------------------------------------------------------------ $cols = array( _("Type") => array('fun'=>'systype_name'), - _("#") => array('fun'=>'view_link'), + _("#") => array('fun'=>'view_link', 'align'=>'right'), _("Reference"), - _("Order") => array('fun'=>'order_link', 'ord'=>''), + _("Order") => array('fun'=>'order_link', 'ord'=>'', 'align'=>'right'), _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'asc'), _("Due Date") => array('type'=>'date', 'fun'=>'due_date'), _("Customer") => array('name' =>'name', 'ord'=>'asc'),