sales/inquiry/sales_orders_view.php

   1 <?php
   2
   3 $page_security = 2;
   4 $path_to_root="../..";
   5
   6 include($path_to_root . "/includes/db_pager.inc");
   7 include($path_to_root . "/includes/session.inc");
   8 include($path_to_root . "/sales/includes/sales_ui.inc");
   9 include_once($path_to_root . "/reporting/includes/reporting.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($dummy, $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 //      Orders inquiry table
 190 //
 191 $sql = "SELECT
 192                 sorder.order_no,
 193                 debtor.name,
 194                 branch.br_name,"
 195                 .($_POST['order_view_mode']=='InvoiceTemplates'
 196                         || $_POST['order_view_mode']=='DeliveryTemplates' ?
 197                  "sorder.comments, " : "sorder.customer_ref, ")
 198                 ."sorder.ord_date,
 199                 sorder.delivery_date,
 200                 sorder.deliver_to,
 201                 Sum(line.unit_price*line.quantity*(1-line.discount_percent)) AS OrderValue,
 202                 sorder.type,
 203                 debtor.curr_code,
 204                 Sum(line.qty_sent) AS TotDelivered,
 205                 Sum(line.quantity) AS TotQuantity
 206         FROM ".TB_PREF."sales_orders as sorder, "
 207                 .TB_PREF."sales_order_details as line, "
 208                 .TB_PREF."debtors_master as debtor, "
 209                 .TB_PREF."cust_branch as branch
 210                 WHERE sorder.order_no = line.order_no
 211                 AND sorder.debtor_no = debtor.debtor_no
 212                 AND sorder.branch_code = branch.branch_code
 213                 AND debtor.debtor_no = branch.debtor_no";
 214
 215 if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
 216 {
 217         // search orders with number like ...
 218         $sql .= " AND sorder.order_no LIKE '%". $_POST['OrderNumber'] ."'"
 219                         ." GROUP BY sorder.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 sorder.ord_date >= '$date_after'"
 229                                 ." AND sorder.ord_date <= '$date_before'";
 230         }
 231         if ($selected_customer != -1)
 232                 $sql .= " AND sorder.debtor_no='" . $selected_customer . "'";
 233
 234         if (isset($selected_stock_item))
 235                 $sql .= " AND line.stk_code='". $selected_stock_item ."'";
 236
 237         if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
 238                 $sql .= " AND sorder.from_stk_loc = '". $_POST['StockLocation'] . "' ";
 239
 240         if ($_POST['order_view_mode']=='OutstandingOnly')
 241                 $sql .= " AND line.qty_sent < line.quantity";
 242         elseif ($_POST['order_view_mode']=='InvoiceTemplates' || $_POST['order_view_mode']=='DeliveryTemplates')
 243                 $sql .= " AND sorder.type=1";
 244
 245         $sql .= " GROUP BY sorder.order_no,
 246                                 sorder.debtor_no,
 247                                 sorder.branch_code,
 248                                 sorder.customer_ref,
 249                                 sorder.ord_date,
 250                                 sorder.deliver_to";
 251 }
 252
 253 $cols = array(
 254         _("Order #") => array('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") => array('align'=>'center')
 264 );
 265
 266 if ($_POST['order_view_mode'] == 'OutstandingOnly') {
 267         array_replace($cols, 3, 1, _("Cust Order Ref"));
 268         array_append($cols, array(array('insert'=>true, 'fun'=>'dispatch_link')));
 269
 270 } elseif ($_POST['order_view_mode'] == 'InvoiceTemplates') {
 271         array_replace($cols, 3, 1, _("Description"));
 272         array_append($cols, array( array('insert'=>true, 'fun'=>'invoice_link')));
 273
 274 } else if ($_POST['order_view_mode'] == 'DeliveryTemplates') {
 275         array_replace($cols, 3, 1, _("Description"));
 276         array_append($cols, array(
 277                         array('insert'=>true, 'fun'=>'delivery_link'))
 278         );
 279
 280 } else {
 281          array_append($cols,array(
 282                         _("Tmpl") => array('insert'=>true, 'fun'=>'tmpl_checkbox'),
 283                                         array('insert'=>true, 'fun'=>'edit_link'),
 284                                         array('insert'=>true, 'fun'=>'prt_link')));
 285 };
 286
 287
 288 $table =& new_db_pager('orders_tbl', $sql, $cols);
 289 $table->set_marker('check_overdue', _("Marked items are overdue."));
 290
 291 if (get_post('SearchOrders')) {
 292         $table->set_sql($sql);
 293         $table->set_columns($cols);
 294 }
 295 start_form();
 296
 297 display_db_pager($table);
 298 submit_center('Update', _("Update"), true, '', null);
 299
 300 end_form();
 301 end_page();
 302 ?>