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($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
192 $sql = "SELECT ".TB_PREF."sales_orders.order_no, "
193 .TB_PREF."debtors_master.name, "
194 .TB_PREF."cust_branch.br_name, "
195 .($_POST['order_view_mode']=='InvoiceTemplates'
196 || $_POST['order_view_mode']=='DeliveryTemplates' ?
197 TB_PREF."sales_orders.comments, " : TB_PREF."sales_orders.customer_ref, ")
198 .TB_PREF."sales_orders.ord_date, "
199 .TB_PREF."sales_orders.delivery_date, "
200 .TB_PREF."sales_orders.deliver_to, "
201 ." Sum(".TB_PREF."sales_order_details.unit_price*"
202 .TB_PREF."sales_order_details.quantity*(1-"
203 .TB_PREF."sales_order_details.discount_percent)) AS OrderValue, "
204 .TB_PREF."sales_orders.type, "
205 .TB_PREF."debtors_master.curr_code, "
206 ." Sum(".TB_PREF."sales_order_details.qty_sent) AS TotDelivered, "
207 ." Sum(".TB_PREF."sales_order_details.quantity) AS TotQuantity "
209 ." FROM ".TB_PREF."sales_orders, ".TB_PREF."sales_order_details, ".TB_PREF."debtors_master, ".TB_PREF."cust_branch
210 WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no
211 AND ".TB_PREF."sales_orders.debtor_no = ".TB_PREF."debtors_master.debtor_no
212 AND ".TB_PREF."sales_orders.branch_code = ".TB_PREF."cust_branch.branch_code
213 AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."cust_branch.debtor_no ";
215 if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
217 // search orders with number like ...
218 $sql .= " AND ".TB_PREF."sales_orders.order_no LIKE '%". $_POST['OrderNumber'] ."'"
219 ." GROUP BY ".TB_PREF."sales_orders.order_no";
221 else // ... or select inquiry constraints
223 if ($_POST['order_view_mode']!='DeliveryTemplates' && $_POST['order_view_mode']!='InvoiceTemplates')
225 $date_after = date2sql($_POST['OrdersAfterDate']);
226 $date_before = date2sql($_POST['OrdersToDate']);
228 $sql .= " AND ".TB_PREF."sales_orders.ord_date >= '$date_after'"
229 ." AND ".TB_PREF."sales_orders.ord_date <= '$date_before'";
231 if ($selected_customer != -1)
232 $sql .= " AND ".TB_PREF."sales_orders.debtor_no='" . $selected_customer . "'";
234 if (isset($selected_stock_item))
235 $sql .= " AND ".TB_PREF."sales_order_details.stk_code='". $selected_stock_item ."'";
237 if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
238 $sql .= " AND ".TB_PREF."sales_orders.from_stk_loc = '". $_POST['StockLocation'] . "' ";
240 if ($_POST['order_view_mode']=='OutstandingOnly')
241 $sql .= " AND ".TB_PREF."sales_order_details.qty_sent < ".TB_PREF."sales_order_details.quantity";
242 elseif ($_POST['order_view_mode']=='InvoiceTemplates' || $_POST['order_view_mode']=='DeliveryTemplates')
243 $sql .= " AND ".TB_PREF."sales_orders.type=1";
245 $sql .= " GROUP BY ".TB_PREF."sales_orders.order_no, "
246 .TB_PREF."sales_orders.debtor_no, "
247 .TB_PREF."sales_orders.branch_code, "
248 .TB_PREF."sales_orders.customer_ref, "
249 .TB_PREF."sales_orders.ord_date, "
250 .TB_PREF."sales_orders.deliver_to";
254 _("Order #") => array('type'=>'spec', 'fun'=>'view_link'),
258 _("Order Date") => 'date',
259 _("Required By") =>array('type'=>'date', 'ord'=>''),
261 _("Order Total") => array('type'=>'amount', 'ord'=>''),
266 if ($_POST['order_view_mode'] == 'OutstandingOnly') {
267 array_remove($cols, 4);
268 array_insert($cols, 4, _("Cust Order Ref"));
269 $cols += array('' => array('type'=>'insert', 'fun'=>'dispatch_link'));
271 } elseif ($_POST['order_view_mode'] == 'InvoiceTemplates') {
272 array_remove($cols, 4);
273 array_insert($cols, 4, _("Description"));
274 $cols += array('' => array('type'=>'insert', 'fun'=>'invoice_link'));
276 } else if ($_POST['order_view_mode'] == 'DeliveryTemplates') {
277 array_remove($cols, 4);
278 array_insert($cols, 4, _("Description"));
279 $cols += array('' => array('type'=>'insert', 'fun'=>'delivery_link'));
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);