X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Finquiry%2Fsupplier_allocation_inquiry.php;h=2dba05e495a40394cd2c880d5574d3ce11b5e2f5;hb=9f832e8ab3c679ab67e5d086a99774dac58e004a;hp=84fb2e12a9d3b2ca1d50ad6f8433dfc5b4e36792;hpb=17b390efcf904072b02ec866b2a427490471a260;p=fa-stable.git diff --git a/purchasing/inquiry/supplier_allocation_inquiry.php b/purchasing/inquiry/supplier_allocation_inquiry.php index 84fb2e12..2dba05e4 100644 --- a/purchasing/inquiry/supplier_allocation_inquiry.php +++ b/purchasing/inquiry/supplier_allocation_inquiry.php @@ -87,23 +87,32 @@ function due_date($row) function fmt_balance($row) { - $value = ($row["type"] == ST_BANKPAYMENT || $row["type"] == ST_SUPPCREDIT || $row["type"] == ST_SUPPAYMENT) - ? -$row["TotalAmount"] - $row["Allocated"] - : $row["TotalAmount"] - $row["Allocated"]; + $value = ($row["type"] == ST_BANKPAYMENT || $row["type"] == ST_SUPPCREDIT || $row["type"] == ST_SUPPAYMENT) ? -$row["TotalAmount"] - $row["Allocated"] + : ($row["type"] == ST_JOURNAL ? abs($row["TotalAmount"]) - $row["Allocated"] : + $row["TotalAmount"] - $row["Allocated"]); return $value; } function alloc_link($row) { - if (($row["type"] == ST_BANKPAYMENT || $row["type"] == ST_SUPPCREDIT || $row["type"] == ST_SUPPAYMENT) - && (-$row["TotalAmount"] - $row["Allocated"]) >= 0) - return pager_link(_("Allocations"), "/purchasing/allocations/supplier_allocate.php?trans_no=" . - $row["trans_no"]. "&trans_type=" . $row["type"]. "&supplier_id=" . $row["supplier_id"], ICON_ALLOC); - elseif ($row["type"] == ST_SUPPINVOICE && ($row["TotalAmount"] - $row["Allocated"]) > 0) - return pager_link(_("Pay"), "/purchasing/supplier_payment.php?supplier_id=".$row["supplier_id"] - ."&PInvoice=".$row["trans_no"], ICON_MONEY ); - else - return ''; + $link = + pager_link(_("Allocations"), + "/purchasing/allocations/supplier_allocate.php?trans_no=" . + $row["trans_no"]. "&trans_type=" . $row["type"]. "&supplier_id=" . $row["supplier_id"], ICON_ALLOC ); + + if ($row["type"] == ST_BANKPAYMENT || $row["type"] == ST_SUPPAYMENT || + (($row["type"] == ST_SUPPCREDIT || $row["type"] == ST_JOURNAL) && $row["TotalAmount"] < 0)) + return floatcmp(-$row["TotalAmount"], $row["Allocated"]) ? $link : ''; + + $link = + pager_link(_("Payment"), + "/purchasing/supplier_payment.php?supplier_id=".$row["supplier_id"]."&PInvoice=" + . $row["trans_no"]."&trans_type=" . $row["type"], ICON_MONEY); + + if ($row["type"] == ST_SUPPINVOICE || (($row["type"] == ST_SUPPCREDIT || $row["type"] == ST_JOURNAL) && $row["TotalAmount"] > 0)) + return floatcmp($row["TotalAmount"], $row["Allocated"]) ? $link : ''; + + } function fmt_debit($row) @@ -125,7 +134,7 @@ $sql = get_sql_for_supplier_allocation_inquiry(get_post('TransAfterDate'),get_po $cols = array( _("Type") => array('fun'=>'systype_name'), - _("#") => array('fun'=>'view_link', 'ord'=>''), + _("#") => array('fun'=>'view_link', 'ord'=>'', 'align'=>'right'), _("Reference"), _("Supplier") => array('ord'=>''), _("Supp Reference"),