2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
12 $path_to_root = "../..";
14 include_once($path_to_root . "/includes/db_pager.inc");
15 include_once($path_to_root . "/includes/session.inc");
16 include_once($path_to_root . "/sales/includes/sales_ui.inc");
17 include_once($path_to_root . "/reporting/includes/reporting.inc");
19 include_once("includes/order_lines.inc");
20 include_once("includes/splitter.inc");
22 $page_security = 'SA_ORDERLINEX_EDIT';
23 add_access_extensions();
25 $_SESSION['page_title'] = _($help_context = "Edit lines extra parameters");
28 update_extra_order_details();
29 split_order_details();
33 if ($use_popup_windows)
34 $js .= get_js_open_window(900, 600);
36 $js .= get_js_date_picker();
37 page($_SESSION['page_title'], false, false, "", $js);
39 //---------------------------------------------------------------------------------------------
43 start_table(TABLESTYLE_NOBORDER);
47 if(!isset($_POST['customer_id'])) {
48 if(isset($_GET['customer_id'])) {
49 $customer_id = $_GET['customer_id'];
50 $_POST['customer_id'] = $customer_id;
52 else $customer_id = null;
56 $customer_id = $_POST['customer_id'];
58 customer_list_cells(_("Select a customer: "), 'customer_id', $customer_id, true, true);
60 if($customer_id !== null) {
61 if(!isset($_POST['item_like'])) {
62 if(isset($_GET['item_like'])) {
63 $item_like = $_GET['item_like'];
64 $_POST['item_like'] = $item_like;
66 else $item_like = null;
68 else $item_like = $_POST['item_like'];
69 text_cells_ex('Filter Item', 'item_like', 50, null, $item_like,
70 null, null, null, true );
77 //submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default');
83 //---------------------------------------------------------------------------------------------
84 // Orders inquiry table
87 $sql = get_order_details_extra($customer_id, 'DEF', $item_like);
90 , _("Order #") => array('fun'=>'view_link', 'ord' => '')
91 ,_("Item Code") => array('ord' => '', 'fun' => 'item_link')
92 ,_("Quantity") => array('type' => 'qty', 'dec' => 0)
93 ,_("Available") => array('fun' => 'available_quantity', 'dec' => 0, 'ord' => '')
94 ,_("Before") => 'skip'
95 ,_("Priority") => array('type' => 'time', 'ord' => '')
96 ,_("Hold Until") => array('fun' => 'input_hold_until_date_details', 'ord' => '')
97 ,_("Require By") => array('fun' => 'input_required_date_details', 'ord' => '')
98 ,_("Expiry Date") => array('fun' => 'input_expiry_date_details', 'ord' => '')
99 ,_("Comment") => array('fun' => 'input_comment_details', 'ord' => '')
103 $sql = get_order_summary('DEF');
105 'customer id' => 'skip',
106 _("Customer") => array('ord' => '', 'fun' => 'customer_link'),
107 _("Branch") => array('ord' => ''),
108 _("Delivery Date") => array('ord' => '', 'type' => 'date'),
109 _("Quantity") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
110 _("Amount") => array('ord' => '', 'type' => 'amount'),
111 _("Avail. Q") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
112 _("Avail. A") => array('ord' => '', 'type' => 'amount', 'dec' => 0),
113 _("required date") => array('ord' => '', 'type' => 'date'),
114 _("Comments") => array('ord' => '', 'fun' => 'aggregate_comment'),
115 _("comment 2 ") => 'skip'
120 $table =& new_db_pager('orders_tbl', $sql, $cols);
122 $table->width = "80%";
124 display_db_pager($table);
126 function display_split_area() {
127 start_table(TABLESTYLE_NOBORDER);
128 qty_cells('Before', 'start_offset', -5);
129 date_cells('Start', 'start_date');
130 date_cells('End', 'end_date');
131 qty_cells('After', 'end_offset', 2);
132 qty_cells('Max', 'max_quantity', 6);
133 submit_cells('Split', 'Split');
137 display_split_area();
141 submit_center_first('Update', _("Update"), '', 'default', false);
142 submit_center_last('Cancel', _("Cancel"), '', 'cancel', false);
148 span.tooltip{ display:none;}
154 color: rgb(113, 157, 171);
155 background: rgb(255, 255, 255);
156 border: 1px solid rgb(113, 157, 171);
159 :hover > span.tooltip, span.tooltip:hover {
162 span.before-tooltip {