-$sql = "SELECT ".TB_PREF."sales_orders.order_no, "
- .TB_PREF."debtors_master.name, "
- .TB_PREF."cust_branch.br_name, "
- .($_POST['order_view_mode']=='InvoiceTemplates'
- || $_POST['order_view_mode']=='DeliveryTemplates' ?
- TB_PREF."sales_orders.comments, " : TB_PREF."sales_orders.customer_ref, ")
- .TB_PREF."sales_orders.ord_date, "
- .TB_PREF."sales_orders.delivery_date, "
- .TB_PREF."sales_orders.deliver_to, "
- ." Sum(".TB_PREF."sales_order_details.unit_price*"
- .TB_PREF."sales_order_details.quantity*(1-"
- .TB_PREF."sales_order_details.discount_percent)) AS OrderValue, "
- .TB_PREF."sales_orders.type, "
- .TB_PREF."debtors_master.curr_code, "
- ." Sum(".TB_PREF."sales_order_details.qty_sent) AS TotDelivered, "
- ." Sum(".TB_PREF."sales_order_details.quantity) AS TotQuantity "
-
- ." FROM ".TB_PREF."sales_orders, ".TB_PREF."sales_order_details, ".TB_PREF."debtors_master, ".TB_PREF."cust_branch
- WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no
- AND ".TB_PREF."sales_orders.debtor_no = ".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."sales_orders.branch_code = ".TB_PREF."cust_branch.branch_code
- AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."cust_branch.debtor_no ";
-
-if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
-{
- // search orders with number like ...
- $sql .= " AND ".TB_PREF."sales_orders.order_no LIKE '%". $_POST['OrderNumber'] ."'"
- ." GROUP BY ".TB_PREF."sales_orders.order_no";
-}
-else // ... or select inquiry constraints
-{
- if ($_POST['order_view_mode']!='DeliveryTemplates' && $_POST['order_view_mode']!='InvoiceTemplates')
- {
- $date_after = date2sql($_POST['OrdersAfterDate']);
- $date_before = date2sql($_POST['OrdersToDate']);
-
- $sql .= " AND ".TB_PREF."sales_orders.ord_date >= '$date_after'"
- ." AND ".TB_PREF."sales_orders.ord_date <= '$date_before'";
- }
- if ($selected_customer != -1)
- $sql .= " AND ".TB_PREF."sales_orders.debtor_no='" . $selected_customer . "'";
-
- if (isset($selected_stock_item))
- $sql .= " AND ".TB_PREF."sales_order_details.stk_code='". $selected_stock_item ."'";
-
- if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
- $sql .= " AND ".TB_PREF."sales_orders.from_stk_loc = '". $_POST['StockLocation'] . "' ";
-
- if ($_POST['order_view_mode']=='OutstandingOnly')
- $sql .= " AND ".TB_PREF."sales_order_details.qty_sent < ".TB_PREF."sales_order_details.quantity";
- elseif ($_POST['order_view_mode']=='InvoiceTemplates' || $_POST['order_view_mode']=='DeliveryTemplates')
- $sql .= " AND ".TB_PREF."sales_orders.type=1";
-
- $sql .= " GROUP BY ".TB_PREF."sales_orders.order_no, "
- .TB_PREF."sales_orders.debtor_no, "
- .TB_PREF."sales_orders.branch_code, "
- .TB_PREF."sales_orders.customer_ref, "
- .TB_PREF."sales_orders.ord_date, "
- .TB_PREF."sales_orders.deliver_to";
-}
-
-$cols = array(
- _("Order #") => array('type'=>'spec', 'fun'=>'view_link'),
- _("Customer"),
- _("Branch"),
- _("Comments"),
- _("Order Date") => 'date',
- _("Required By") =>array('type'=>'date', 'ord'=>''),
- _("Delivery To"),
- _("Order Total") => array('type'=>'amount', 'ord'=>''),
- 'Type' => 'skip',
- _("Currency")
-);
-
+$sql = get_sql_for_sales_orders_view($trans_type, get_post('OrderNumber'), get_post('order_view_mode'),
+ get_post('SelectStockFromList'), get_post('OrdersAfterDate'), get_post('OrdersToDate'), get_post('OrderReference'), get_post('StockLocation'),
+ get_post('customer_id'));
+
+if ($trans_type == ST_SALESORDER)
+ $cols = array(
+ _("Order #") => array('fun'=>'view_link'),
+ _("Ref") => array('type' => 'sorder.reference', 'ord' => '') ,
+ _("Customer") => array('type' => 'debtor.name' , 'ord' => '') ,
+ _("Branch"),
+ _("Cust Order Ref"),
+ _("Order Date") => array('type' => 'date', 'ord' => ''),
+ _("Required By") =>array('type'=>'date', 'ord'=>''),
+ _("Delivery To"),
+ _("Order Total") => array('type'=>'amount', 'ord'=>''),
+ 'Type' => 'skip',
+ _("Currency") => array('align'=>'center')
+ );
+else
+ $cols = array(
+ _("Quote #") => array('fun'=>'view_link'),
+ _("Ref"),
+ _("Customer"),
+ _("Branch"),
+ _("Cust Order Ref"),
+ _("Quote Date") => 'date',
+ _("Valid until") =>array('type'=>'date', 'ord'=>''),
+ _("Delivery To"),
+ _("Quote Total") => array('type'=>'amount', 'ord'=>''),
+ 'Type' => 'skip',
+ _("Currency") => array('align'=>'center')
+ );