Save in database.
[order_line_extra.git] / order_lines_view.php
1 <?php
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 = "../..";
13
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");
18
19 include_once("includes/order_lines.inc");
20
21 $page_security = 'SA_ORDERLINEX_EDIT';
22 add_access_extensions();
23
24 $_SESSION['page_title'] = _($help_context = "Edit lines extra parameters");
25
26 update_extra_order_details();
27
28 $js = "";
29 if ($use_popup_windows)
30         $js .= get_js_open_window(900, 600);
31 if ($use_date_picker)
32         $js .= get_js_date_picker();
33 page($_SESSION['page_title'], false, false, "", $js);
34
35 //---------------------------------------------------------------------------------------------
36
37 start_form();
38
39 start_table(TABLESTYLE_NOBORDER);
40 start_row();
41
42 customer_list_cells(_("Select a customer: "), 'customer_id', false, false, true);
43
44
45
46
47
48 //submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default');
49
50 end_row();
51
52 end_table(1);
53
54 //---------------------------------------------------------------------------------------------
55 //      Orders inquiry table
56 //
57 $customer_id = $_POST['customer_id'];
58 if(isset($customer_id)) {
59         $sql = get_order_details_extra($customer_id);
60
61
62         $cols = array(
63                 'detail_id' => 'skip'
64                 ,       _("Order #") => array('fun'=>'view_link', 'ord' => '')
65                 ,_("Item Code") => array('ord' => '')
66                 ,_("Quantity") => array('type' => 'qty')
67         ,_("Required Date") => array('fun' => 'input_date_details', 'ord' => '')
68         ,_("Comment") => array('fun' => 'input_comment_details', 'ord' => '')
69         );
70 }
71 else {
72 }
73
74
75 $table =& new_db_pager('orders_tbl', $sql, $cols);
76
77 $table->width = "80%";
78
79 display_db_pager($table);
80
81 br(1);
82 submit_center_first('Update', _("Update"), true, '', 'default', true);
83 submit_center_last('Cancel', _("Cancel"), true, '', 'cancel', true);
84
85         end_form();
86         end_page();
87 ?>