// Orders inquiry table
//
if($customer_id) {
- $sql = get_order_details_extra($customer_id);
+ $sql = get_order_details_extra($customer_id, 'DEF');
$cols = array(
'detail_id' => 'skip'
, _("Order #") => array('fun'=>'view_link', 'ord' => '')
,_("Item Code") => array('ord' => '', 'fun' => 'item_link')
,_("Quantity") => array('type' => 'qty', 'dec' => 0)
+ ,_("Available") => array('fun' => 'available_quantity', 'dec' => 0, 'ord' => '')
,_("Required Date") => array('fun' => 'input_date_details', 'ord' => '')
,_("Comment") => array('fun' => 'input_comment_details', 'ord' => '')
);
}
else {
- $sql = get_order_summary();
+ $sql = get_order_summary('DEF');
$cols = array(
'customer id' => 'skip',
_("Customer") => array('ord' => '', 'fun' => 'customer_link'),
_("Delivery Date") => array('ord' => '', 'type' => 'date'),
_("Quantity") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
_("Amount") => array('ord' => '', 'type' => 'amount'),
+_("Avail. Q") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
+_("Avail. A") => array('ord' => '', 'type' => 'amount', 'dec' => 0),
_("required date") => array('ord' => '', 'type' => 'date'),
_("Comments") => array('ord' => '', 'fun' => 'aggregate_comment'),
_("comment 2 ") => 'skip'
display_db_pager($table);
br(1);
-submit_center_first('Update', _("Update"), true, '', 'default', true);
-submit_center_last('Cancel', _("Cancel"), true, '', 'cancel', true);
+submit_center_first('Update', _("Update"), '', 'default', false);
+submit_center_last('Cancel', _("Cancel"), '', 'cancel', false);
end_form();
end_page();