6 include($path_to_root . "/sales/includes/sales_ui.inc");
7 include($path_to_root . "/includes/db_pager.inc");
8 include_once($path_to_root . "/reporting/includes/reporting.inc");
9 include($path_to_root . "/includes/session.inc");
12 if ($use_popup_windows)
13 $js .= get_js_open_window(900, 600);
15 $js .= get_js_date_picker();
17 if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true))
19 $_POST['order_view_mode'] = 'OutstandingOnly';
20 $_SESSION['page_title'] = _("Search Outstanding Sales Orders");
22 elseif (isset($_GET['InvoiceTemplates']) && ($_GET['InvoiceTemplates'] == true))
24 $_POST['order_view_mode'] = 'InvoiceTemplates';
25 $_SESSION['page_title'] = _("Search Template for Invoicing");
27 elseif (isset($_GET['DeliveryTemplates']) && ($_GET['DeliveryTemplates'] == true))
29 $_POST['order_view_mode'] = 'DeliveryTemplates';
30 $_SESSION['page_title'] = _("Select Template for Delivery");
32 elseif (!isset($_POST['order_view_mode']))
34 $_POST['order_view_mode'] = false;
35 $_SESSION['page_title'] = _("Search All Sales Orders");
38 page($_SESSION['page_title'], false, false, "", $js);
40 if (isset($_GET['selected_customer']))
42 $selected_customer = $_GET['selected_customer'];
44 elseif (isset($_POST['selected_customer']))
46 $selected_customer = $_POST['selected_customer'];
49 $selected_customer = -1;
51 //---------------------------------------------------------------------------------------------
53 if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "") &&
54 ($_POST['SelectStockFromList'] != reserved_words::get_all()))
56 $selected_stock_item = $_POST['SelectStockFromList'];
60 unset($selected_stock_item);
62 //---------------------------------------------------------------------------------------------
63 // Query format functions
65 function check_overdue($row)
67 return ($row['type'] == 0
68 && date1_greater_date2(Today(), sql2date($row['ord_date']))
69 && ($row['TotDelivered'] < $row['TotQuantity']));
72 function view_link($dummy, $order_no)
74 return get_customer_trans_view_str(systypes::sales_order(), $order_no);
77 function prt_link($row)
79 return print_document_link($row['order_no'], _("Print"), true, 30);
82 function edit_link($row)
84 return pager_link( _("Edit"),
85 "/sales/sales_order_entry.php?" . SID . "ModifyOrderNumber=" . $row['order_no']);
88 function dispatch_link($row)
90 return pager_link( _("Dispatch"),
91 "/sales/customer_delivery.php?" . SID . "OrderNumber=" .$row['order_no']);
94 function invoice_link($row)
96 return pager_link( _("Invoice"),
97 "/sales/sales_order_entry.php?" . SID . "NewInvoice=" .$row["order_no"]);
100 function delivery_link($row)
102 return pager_link( _("Delivery"),
103 "/sales/sales_order_entry.php?" . SID . "NewDelivery=" .$row['order_no']);
106 function tmpl_checkbox($row)
108 $name = "chgtpl" .$row['order_no'];
109 $value = $row['type'] ? ' checked' : '';
111 return "<input $value type='checkbox' name='$name' value='1'"
112 ." onclick='JsHttpRequest.request(\"_{$name}_update\", this.form);'"
113 ." title='"._('Set this order as a template for direct deliveries/invoices')
115 // add also old checkbox name+value for check after 'Update'
116 ."<input name='last[".$row['order_no']."]' type='hidden' value='"
117 .($row['type'] ? 1 : 0)."'>\n";
119 //---------------------------------------------------------------------------------------------
120 // Update db record if respective checkbox value has changed.
122 function change_tpl_flag($id)
126 $sql = "UPDATE ".TB_PREF."sales_orders SET type = !type WHERE order_no=$id";
128 db_query($sql, "Can't change sales order type");
129 $Ajax->activate('orders_tbl');
132 $id = find_submit('_chgtpl');
134 change_tpl_flag($id);
136 if (isset($_POST['Update'])) {
137 foreach($_POST['last'] as $id => $value)
138 if ($value != check_value('chgtpl'.$id))
139 change_tpl_flag($id);
142 //---------------------------------------------------------------------------------------------
145 if (get_post('_OrderNumber_changed')) // enable/disable selection controls
147 $disable = get_post('OrderNumber') !== '';
149 if ($_POST['order_view_mode']!='DeliveryTemplates'
150 && $_POST['order_view_mode']!='InvoiceTemplates') {
151 $Ajax->addDisable(true, 'OrdersAfterDate', $disable);
152 $Ajax->addDisable(true, 'OrdersToDate', $disable);
154 $Ajax->addDisable(true, 'StockLocation', $disable);
155 $Ajax->addDisable(true, '_SelectStockFromList_edit', $disable);
156 $Ajax->addDisable(true, 'SelectStockFromList', $disable);
159 $Ajax->addFocus(true, 'OrderNumber');
161 $Ajax->addFocus(true, 'OrdersAfterDate');
163 $Ajax->activate('orders_tbl');
166 start_form(false, false, $_SERVER['PHP_SELF'] .SID);
168 start_table("class='tablestyle_noborder'");
170 ref_cells(_("#:"), 'OrderNumber', '',null, '', true);
171 if ($_POST['order_view_mode'] != 'DeliveryTemplates' && $_POST['order_view_mode'] != 'InvoiceTemplates')
173 date_cells(_("from:"), 'OrdersAfterDate', '', null, -30);
174 date_cells(_("to:"), 'OrdersToDate', '', null, 1);
176 locations_list_cells(_("Location:"), 'StockLocation', null, true);
178 stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
180 submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true);
182 hidden('order_view_mode', $_POST['order_view_mode']);
189 //---------------------------------------------------------------------------------------------
190 // Orders inquiry table
196 .($_POST['order_view_mode']=='InvoiceTemplates'
197 || $_POST['order_view_mode']=='DeliveryTemplates' ?
198 "sorder.comments, " : "sorder.customer_ref, ")
200 sorder.delivery_date,
202 Sum(line.unit_price*line.quantity*(1-line.discount_percent)) AS OrderValue,
205 Sum(line.qty_sent) AS TotDelivered,
206 Sum(line.quantity) AS TotQuantity
207 FROM ".TB_PREF."sales_orders as sorder, "
208 .TB_PREF."sales_order_details as line, "
209 .TB_PREF."debtors_master as debtor, "
210 .TB_PREF."cust_branch as branch
211 WHERE sorder.order_no = line.order_no
212 AND sorder.debtor_no = debtor.debtor_no
213 AND sorder.branch_code = branch.branch_code
214 AND debtor.debtor_no = branch.debtor_no";
216 if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
218 // search orders with number like ...
219 $sql .= " AND sorder.order_no LIKE '%". $_POST['OrderNumber'] ."'"
220 ." GROUP BY sorder.order_no";
222 else // ... or select inquiry constraints
224 if ($_POST['order_view_mode']!='DeliveryTemplates' && $_POST['order_view_mode']!='InvoiceTemplates')
226 $date_after = date2sql($_POST['OrdersAfterDate']);
227 $date_before = date2sql($_POST['OrdersToDate']);
229 $sql .= " AND sorder.ord_date >= '$date_after'"
230 ." AND sorder.ord_date <= '$date_before'";
232 if ($selected_customer != -1)
233 $sql .= " AND sorder.debtor_no='" . $selected_customer . "'";
235 if (isset($selected_stock_item))
236 $sql .= " AND line.stk_code='". $selected_stock_item ."'";
238 if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
239 $sql .= " AND sorder.from_stk_loc = '". $_POST['StockLocation'] . "' ";
241 if ($_POST['order_view_mode']=='OutstandingOnly')
242 $sql .= " AND line.qty_sent < line.quantity";
243 elseif ($_POST['order_view_mode']=='InvoiceTemplates' || $_POST['order_view_mode']=='DeliveryTemplates')
244 $sql .= " AND sorder.type=1";
246 $sql .= " GROUP BY sorder.order_no,
255 _("Order #") => array('type'=>'spec', 'fun'=>'view_link'),
259 _("Order Date") => 'date',
260 _("Required By") =>array('type'=>'date', 'ord'=>''),
262 _("Order Total") => array('type'=>'amount', 'ord'=>''),
267 if ($_POST['order_view_mode'] == 'OutstandingOnly') {
268 array_replace($cols, 3, 1, _("Cust Order Ref"));
269 array_append($cols, array(array('type'=>'insert', 'fun'=>'dispatch_link')));
271 } elseif ($_POST['order_view_mode'] == 'InvoiceTemplates') {
272 array_replace($cols, 3, 1, _("Description"));
273 array_append($cols, array( array('type'=>'insert', 'fun'=>'invoice_link')));
275 } else if ($_POST['order_view_mode'] == 'DeliveryTemplates') {
276 array_replace($cols, 3, 1, _("Description"));
277 array_append($cols, array(
278 array('type'=>'insert', 'fun'=>'delivery_link'))
282 array_append($cols,array(
283 _("Tmpl") => array('type'=>'insert', 'fun'=>'tmpl_checkbox'),
284 array('type'=>'insert', 'fun'=>'edit_link'),
285 array('type'=>'insert', 'fun'=>'prt_link')));
289 $table =& new_db_pager('orders_tbl', $sql, $cols);
290 $table->set_marker('check_overdue', _("Marked items are overdue."));
293 if (get_post('SearchOrders'))
295 $table->set_sql($sql);
296 $Ajax->activate('orders_tbl');
299 display_db_pager($table);
301 submit_center('Update', _("Update"), true, '', null);