Cleanup: various random sql queries found in UI files moved to database interface...

[fa-stable.git] / sales / customer_invoice.php

diff --git a/sales/customer_invoice.php b/sales/customer_invoice.php
index 945ce9f1f8326d0a9806f75b8334e55705cd7f68..09d405eb415493cff7b6c09e33ada35ae7538f97 100644 (file)
--- a/sales/customer_invoice.php
+++ b/sales/customer_invoice.php
@@ -66,12 +66,7 @@ if (isset($_GET['AddedID'])) {
 
        hyperlink_params("$path_to_root/sales/inquiry/sales_deliveries_view.php", _("Select Another &Delivery For Invoicing"), "OutstandingOnly=1");
 
-       $sql = "SELECT trans_type_from, trans_no_from FROM ".TB_PREF."cust_allocations
-                       WHERE trans_type_to=".ST_SALESINVOICE." AND trans_no_to=".db_escape($invoice_no);
-       $result = db_query($sql, "could not retrieve customer allocation");
-       $row = db_fetch($result);
-
-       if ($row === false)
+       if (!db_num_rows(get_allocatable_from_cust_transactions(null, $invoice_no, $trans_type)))
                hyperlink_params("$path_to_root/sales/customer_payments.php", _("Entry &customer payment for this invoice"),
                "SInvoice=".$invoice_no);