From 076aabe0c83753d9384e53d071b34ee51b8c43b8 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 17 Jan 2011 17:57:56 +0000 Subject: [PATCH] Fixed slow sql for po related invoices/credits. --- purchasing/includes/db/invoice_db.inc | 1 + 1 file changed, 1 insertion(+) diff --git a/purchasing/includes/db/invoice_db.inc b/purchasing/includes/db/invoice_db.inc index 06d27cde..7128a7bc 100644 --- a/purchasing/includes/db/invoice_db.inc +++ b/purchasing/includes/db/invoice_db.inc @@ -381,6 +381,7 @@ function get_po_invoices_credits($po_number) WHERE ".TB_PREF."supp_invoice_items.supp_trans_no = ".TB_PREF."supp_trans.trans_no AND ".TB_PREF."supp_invoice_items.po_detail_item_id = ".TB_PREF."purch_order_details.po_detail_item AND ".TB_PREF."purch_orders.supplier_id = ".TB_PREF."supp_trans.supplier_id + AND ".TB_PREF."purch_order_details.order_no = ".db_escape($po_number)." AND ".TB_PREF."purch_order_details.order_no = ".db_escape($po_number); return db_query($sql, "The invoices/credits for the po $po_number could not be retreived"); -- 2.30.2