From 502c2fc8bb683df7737e6700c984d7584405355a Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Tue, 12 Jan 2010 15:12:07 +0000 Subject: [PATCH] Added sorting branches by branch_ref. --- sales/includes/db/branches_db.inc | 3 +++ sales/includes/db/cust_trans_db.inc | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) diff --git a/sales/includes/db/branches_db.inc b/sales/includes/db/branches_db.inc index dc0cdbd2..3728dbbc 100644 --- a/sales/includes/db/branches_db.inc +++ b/sales/includes/db/branches_db.inc @@ -139,6 +139,7 @@ function get_default_info_for_branch($customer_id) $result = db_query($sql,"check failed"); return db_fetch($result); } + function get_sql_for_customer_branches() { $sql = "SELECT " @@ -165,6 +166,8 @@ function get_sql_for_customer_branches() AND b.debtor_no = ".db_escape($_POST['customer_id']); if (!get_post('show_inactive')) $sql .= " AND !b.inactive"; + $sql .= " ORDER BY branch_ref"; + return $sql; } ?> \ No newline at end of file diff --git a/sales/includes/db/cust_trans_db.inc b/sales/includes/db/cust_trans_db.inc index 363a8f4c..f9b77aa5 100644 --- a/sales/includes/db/cust_trans_db.inc +++ b/sales/includes/db/cust_trans_db.inc @@ -380,7 +380,7 @@ function get_sql_for_customer_inquiry() return $sql; } -function get_sql_for_sales_deliveries_view($selected_customer, $selected_stock_id) +function get_sql_for_sales_deliveries_view($selected_customer, $selected_stock_item) { $sql = "SELECT trans.trans_no, debtor.name, -- 2.30.2