X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=order_lines_view.php;h=2c28ba401cf7d82e89da86e48cfea99bbec7bea5;hb=de576b1ca7e1032b17a43034dc187e8a3f9c6390;hp=4129e15f1bad5ee681caed18e54d87a0c4c32b54;hpb=a13270c348c41972ac58d852d4dfded3aa8ef441;p=order_line_extra.git
diff --git a/order_lines_view.php b/order_lines_view.php
index 4129e15..2c28ba4 100644
--- a/order_lines_view.php
+++ b/order_lines_view.php
@@ -17,12 +17,19 @@ include_once($path_to_root . "/sales/includes/sales_ui.inc");
include_once($path_to_root . "/reporting/includes/reporting.inc");
include_once("includes/order_lines.inc");
+include_once("includes/splitter.inc");
$page_security = 'SA_ORDERLINEX_EDIT';
add_access_extensions();
$_SESSION['page_title'] = _($help_context = "Edit lines extra parameters");
+// Process POST
+filter_data($_POST);
+update_extra_order_details();
+split_order_details();
+
+
$js = "";
if ($use_popup_windows)
$js .= get_js_open_window(900, 600);
@@ -37,7 +44,32 @@ start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
-customer_list_cells(_("Select a customer: "), 'customer_id', false, false, true);
+
+if(!isset($_POST['customer_id'])) {
+ if(isset($_GET['customer_id'])) {
+ $customer_id = $_GET['customer_id'];
+ $_POST['customer_id'] = $customer_id;
+ }
+else $customer_id = null;
+
+}
+else {
+ $customer_id = $_POST['customer_id'];
+}
+customer_list_cells(_("Select a customer: "), 'customer_id', $customer_id, true, true);
+
+if($customer_id != null) {
+ if(!isset($_POST['item_like'])) {
+ if(isset($_GET['item_like'])) {
+ $item_like = $_GET['item_like'];
+ $_POST['item_like'] = $item_like;
+ }
+ else $item_like = null;
+ }
+ else $item_like = $_POST['item_like'];
+ text_cells_ex('Filter Item', 'item_like', 50, null, $item_like,
+ null, null, null, true );
+}
@@ -52,21 +84,38 @@ end_table(1);
//---------------------------------------------------------------------------------------------
// Orders inquiry table
//
-$customer_id = $_POST['customer_id'];
-if(isset($customer_id)) {
- $sql = get_order_details_extra($customer_id);
-
-
+if($customer_id) {
+ $sql = get_order_details_extra($customer_id, 'DEF', $item_like);
$cols = array(
'detail_id' => 'skip'
- , _("Order #") => array('fun'=>'view_link', 'ord' => '')
- ,_("Item Code") => array('ord' => '')
- ,_("Quantity") => array('type' => 'qty')
-,_("Required Date") => array('fun' => 'input_date_details')
-,_("Comment") => array('fun' => 'input_comment_details')
+ , _("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' => '')
+ ,_("Before") => 'skip'
+ ,_("Priority") => array('type' => 'time', 'ord' => '')
+ ,_("Hold Until") => array('fun' => 'input_hold_until_date_details', 'ord' => '')
+ ,_("Require By") => array('fun' => 'input_required_date_details', 'ord' => '')
+ ,_("Expiry Date") => array('fun' => 'input_expiry_date_details', 'ord' => '')
+ ,_("Comment") => array('fun' => 'input_comment_details', 'ord' => '')
+ ,'' => array('fun' => 'input_check_details')
);
}
else {
+ $sql = get_order_summary('DEF');
+ $cols = array(
+ 'customer id' => 'skip',
+_("Customer") => array('ord' => '', 'fun' => 'customer_link'),
+_("Branch") => array('ord' => ''),
+_("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'
+ );
}
@@ -76,10 +125,80 @@ $table->width = "80%";
display_db_pager($table);
+function display_split_area() {
+start_table(TABLESTYLE_NOBORDER);
+qty_cells('Before', 'start_offset', -5);
+date_cells('Start', 'start_date');
+date_cells('End', 'end_date');
+qty_cells('After', 'end_offset', 2);
+qty_cells('Max', 'max_quantity', 6);
+submit_cells('Split', 'Split');
+end_table();
+
+}
+display_split_area();
+
+
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();
?>
+
+
+