Added customer filter in sales order inquiries.

[fa-stable.git] / sales / includes / db / sales_order_db.inc

diff --git a/sales/includes/db/sales_order_db.inc b/sales/includes/db/sales_order_db.inc
index 34da078bed63acc19394682bd50cf50d15747151..f8afbc7683ebcbedada5bbfa4d31e4d3dcea7054 100644 (file)
--- a/sales/includes/db/sales_order_db.inc
+++ b/sales/includes/db/sales_order_db.inc
@@ -489,7 +489,7 @@ function get_branch_to_order($customer_id, $branch_id) {
 }
 
 function get_sql_for_sales_orders_view($selected_customer, $trans_type, $trans_no, $filter, 
-       $stock_item=null, $from='', $to='', $ref='', $location='')
+       $stock_item=null, $from='', $to='', $ref='', $location='', $customer_id=ALL_TEXT)
 {
 
        $sql = "SELECT 
@@ -561,6 +561,10 @@ function get_sql_for_sales_orders_view($selected_customer, $trans_type, $trans_n
 
                elseif ($filter=='InvoiceTemplates' || $filter=='DeliveryTemplates')
                        $sql .= " AND sorder.type=1";
+                       \r
+               //Chaiatanya : New Filter\r
+               if ($customer_id != ALL_TEXT)\r
+                       $sql .= " AND sorder.debtor_no = ".db_escape($customer_id);             \r
 
                $sql .= " GROUP BY sorder.order_no,
                                        sorder.debtor_no,