sales/inquiry/sales_orders_view.php

   1 <?php
   2
   3 $page_security = 2;
   4 $path_to_root="../..";
   5
   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");
  10
  11 $js = "";
  12 if ($use_popup_windows)
  13         $js .= get_js_open_window(900, 600);
  14 if ($use_date_picker)
  15         $js .= get_js_date_picker();
  16
  17 if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true))
  18 {
  19         $_POST['order_view_mode'] = 'OutstandingOnly';
  20         $_SESSION['page_title'] = _("Search Outstanding Sales Orders");
  21 }
  22 elseif (isset($_GET['InvoiceTemplates']) && ($_GET['InvoiceTemplates'] == true))
  23 {
  24         $_POST['order_view_mode'] = 'InvoiceTemplates';
  25         $_SESSION['page_title'] = _("Search Template for Invoicing");
  26 }
  27 elseif (isset($_GET['DeliveryTemplates']) && ($_GET['DeliveryTemplates'] == true))
  28 {
  29         $_POST['order_view_mode'] = 'DeliveryTemplates';
  30         $_SESSION['page_title'] = _("Select Template for Delivery");
  31 }
  32 elseif (!isset($_POST['order_view_mode']))
  33 {
  34         $_POST['order_view_mode'] = false;
  35         $_SESSION['page_title'] = _("Search All Sales Orders");
  36 }
  37
  38 page($_SESSION['page_title'], false, false, "", $js);
  39
  40 if (isset($_GET['selected_customer']))
  41 {
  42         $selected_customer = $_GET['selected_customer'];
  43 }
  44 elseif (isset($_POST['selected_customer']))
  45 {
  46         $selected_customer = $_POST['selected_customer'];
  47 }
  48 else
  49         $selected_customer = -1;
  50
  51 //---------------------------------------------------------------------------------------------
  52
  53 if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "") &&
  54         ($_POST['SelectStockFromList'] != reserved_words::get_all()))
  55 {
  56         $selected_stock_item = $_POST['SelectStockFromList'];
  57 }
  58 else
  59 {
  60         unset($selected_stock_item);
  61 }
  62 //---------------------------------------------------------------------------------------------
  63 //      Query format functions
  64 //
  65 function check_overdue($row)
  66 {
  67         return ($row['type'] == 0
  68                 && date1_greater_date2(Today(), sql2date($row['ord_date']))
  69                 && ($row['TotDelivered'] < $row['TotQuantity']));
  70 }
  71
  72 function view_link($order_no)
  73 {
  74         return  get_customer_trans_view_str(systypes::sales_order(), $order_no);
  75 }
  76
  77 function prt_link($row)
  78 {
  79         return print_document_link($row['order_no'], _("Print"), true, 30);
  80 }
  81
  82 function edit_link($row)
  83 {
  84   return pager_link( _("Edit"),
  85     "/sales/sales_order_entry.php?" . SID . "ModifyOrderNumber=" . $row['order_no']);
  86 }
  87
  88 function dispatch_link($row)
  89 {
  90   return pager_link( _("Dispatch"),
  91         "/sales/customer_delivery.php?" . SID . "OrderNumber=" .$row['order_no']);
  92 }
  93
  94 function invoice_link($row)
  95 {
  96   return pager_link( _("Invoice"),
  97         "/sales/sales_order_entry.php?" . SID . "NewInvoice=" .$row["order_no"]);
  98 }
  99
 100 function delivery_link($row)
 101 {
 102   return pager_link( _("Delivery"),
 103         "/sales/sales_order_entry.php?" . SID . "NewDelivery=" .$row['order_no']);
 104 }
 105
 106 function tmpl_checkbox($row)
 107 {
 108         $name = "chgtpl" .$row['order_no'];
 109         $value = $row['type'] ? ' checked' : '';
 110
 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')
 114      ."' >"
 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";
 118 }
 119 //---------------------------------------------------------------------------------------------
 120 // Update db record if respective checkbox value has changed.
 121 //
 122 function change_tpl_flag($id)
 123 {
 124         global  $Ajax;
 125
 126         $sql = "UPDATE ".TB_PREF."sales_orders SET type = !type WHERE order_no=$id";
 127
 128         db_query($sql, "Can't change sales order type");
 129         $Ajax->activate('orders_tbl');
 130 }
 131
 132 $id = find_submit('_chgtpl');
 133 if ($id != -1)
 134         change_tpl_flag($id);
 135
 136 if (isset($_POST['Update'])) {
 137         foreach($_POST['last'] as $id => $value)
 138                 if ($value != check_value('chgtpl'.$id))
 139                         change_tpl_flag($id);
 140 }
 141
 142 //---------------------------------------------------------------------------------------------
 143 //      Order range form
 144 //
 145 if (get_post('_OrderNumber_changed')) // enable/disable selection controls
 146 {
 147         $disable = get_post('OrderNumber') !== '';
 148
 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);
 153         }
 154         $Ajax->addDisable(true, 'StockLocation', $disable);
 155         $Ajax->addDisable(true, '_SelectStockFromList_edit', $disable);
 156         $Ajax->addDisable(true, 'SelectStockFromList', $disable);
 157
 158         if ($disable) {
 159                 $Ajax->addFocus(true, 'OrderNumber');
 160         } else
 161                 $Ajax->addFocus(true, 'OrdersAfterDate');
 162
 163         $Ajax->activate('orders_tbl');
 164 }
 165
 166 start_form(false, false, $_SERVER['PHP_SELF'] .SID);
 167
 168 start_table("class='tablestyle_noborder'");
 169 start_row();
 170 ref_cells(_("#:"), 'OrderNumber', '',null, '', true);
 171 if ($_POST['order_view_mode'] != 'DeliveryTemplates' && $_POST['order_view_mode'] != 'InvoiceTemplates')
 172 {
 173         date_cells(_("from:"), 'OrdersAfterDate', '', null, -30);
 174         date_cells(_("to:"), 'OrdersToDate', '', null, 1);
 175 }
 176 locations_list_cells(_("Location:"), 'StockLocation', null, true);
 177
 178 stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
 179
 180 submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true);
 181
 182 hidden('order_view_mode', $_POST['order_view_mode']);
 183
 184 end_row();
 185
 186 end_table(1);
 187 end_form();
 188
 189 //---------------------------------------------------------------------------------------------
 190 //      Orders inquiry table
 191 //
 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 "
 208
 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 ";
 214
 215 if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
 216 {
 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";
 220 }
 221 else    // ... or select inquiry constraints
 222 {
 223         if ($_POST['order_view_mode']!='DeliveryTemplates' && $_POST['order_view_mode']!='InvoiceTemplates')
 224         {
 225                 $date_after = date2sql($_POST['OrdersAfterDate']);
 226                 $date_before = date2sql($_POST['OrdersToDate']);
 227
 228                 $sql .=  " AND ".TB_PREF."sales_orders.ord_date >= '$date_after'"
 229                                 ." AND ".TB_PREF."sales_orders.ord_date <= '$date_before'";
 230         }
 231         if ($selected_customer != -1)
 232                 $sql .= " AND ".TB_PREF."sales_orders.debtor_no='" . $selected_customer . "'";
 233
 234         if (isset($selected_stock_item))
 235                 $sql .= " AND ".TB_PREF."sales_order_details.stk_code='". $selected_stock_item ."'";
 236
 237         if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
 238                 $sql .= " AND ".TB_PREF."sales_orders.from_stk_loc = '". $_POST['StockLocation'] . "' ";
 239
 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";
 244
 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";
 251 }
 252
 253 $cols = array(
 254         _("Order #") => array('type'=>'spec', 'fun'=>'view_link'),
 255         _("Customer"),
 256         _("Branch"),
 257         _("Comments"),
 258         _("Order Date") => 'date',
 259         _("Required By") =>array('type'=>'date', 'ord'=>''),
 260         _("Delivery To"),
 261         _("Order Total") => array('type'=>'amount', 'ord'=>''),
 262         'Type' => 'skip',
 263         _("Currency")
 264 );
 265
 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'));
 270
 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'));
 275
 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'));
 280
 281 } else {
 282         $cols += array(
 283                         _("Tmpl") => array('type'=>'insert', 'fun'=>'tmpl_checkbox'),
 284                         array('type'=>'insert', 'fun'=>'edit_link'),
 285                         array('type'=>'insert', 'fun'=>'prt_link'));
 286 };
 287
 288
 289 $table =& new_db_pager('orders_tbl', $sql, $cols);
 290 $table->set_marker('check_overdue', _("Marked items are overdue."));
 291
 292
 293 if (get_post('SearchOrders'))
 294 {
 295         $table->set_sql($sql);
 296         $Ajax->activate('orders_tbl');
 297 }
 298         start_form();
 299         display_db_pager($table);
 300
 301         submit_center('Update', _("Update"), true, '', null);
 302         end_form();
 303 end_page();
 304 ?>