+end_table(1);
+//---------------------------------------------------------------------------------------------
+// Orders inquiry table
+//
+$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'), check_value('show_voided'));
+
+if ($trans_type == ST_SALESORDER)
+ $cols = array(
+ _("Order #") => array('fun'=>'view_link', 'align'=>'right', 'ord' =>''),
+ _("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', 'align'=>'right', 'ord' => ''),
+ _("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')
+ );
+if ($_POST['order_view_mode'] == 'OutstandingOnly') {
+ array_append($cols, array(
+ array('insert'=>true, 'fun'=>'edit_link'),
+ array('insert'=>true, 'fun'=>'dispatch_link'),
+ array('insert'=>true, 'fun'=>'prt_link')));
+
+} elseif ($_POST['order_view_mode'] == 'InvoiceTemplates') {
+ array_substitute($cols, 4, 1, _("Description"));
+ array_append($cols, array( array('insert'=>true, 'fun'=>'invoice_link')));
+
+} else if ($_POST['order_view_mode'] == 'DeliveryTemplates') {
+ array_substitute($cols, 4, 1, _("Description"));
+ array_append($cols, array(
+ array('insert'=>true, 'fun'=>'delivery_link'))
+ );
+} else if ($_POST['order_view_mode'] == 'PrepaidOrders') {
+ array_append($cols, array(
+ _("New Payments") => array('insert'=>true, 'fun'=>'unallocated_prepayments'),
+ array('insert'=>true, 'fun'=>'invoice_prep_link'))
+ );
+
+} elseif ($trans_type == ST_SALESQUOTE) {
+ array_append($cols,array(
+ array('insert'=>true, 'fun'=>'edit_link'),
+ array('insert'=>true, 'fun'=>'order_link'),
+ array('insert'=>true, 'fun'=>'prt_link')));
+} elseif ($trans_type == ST_SALESORDER) {
+ array_append($cols,array(
+ _("Tmpl") => array('insert'=>true, 'fun'=>'tmpl_checkbox'),
+ array('insert'=>true, 'fun'=>'edit_link'),
+ array('insert'=>true, 'fun'=>'dispatch_link'),
+ array('insert'=>true, 'fun'=>'prt_link')));
+};
+
+
+$table =& new_db_pager('orders_tbl', $sql, $cols);
+$table->set_marker('check_overdue', _("Marked items are overdue."));
+
+$table->width = "80%";
+
+display_db_pager($table);
+submit_center('Update', _("Update"), true, '', null);
+
+end_form();