sales/inquiry/sales_deliveries_view.php

   1 <?php
   2
   3 $page_security = 2;
   4 $path_to_root="../..";
   5 include($path_to_root . "/includes/session.inc");
   6
   7 include($path_to_root . "/sales/includes/sales_ui.inc");
   8 include_once($path_to_root . "/reporting/includes/reporting.inc");
   9
  10 $js = "";
  11 if ($use_popup_windows)
  12         $js .= get_js_open_window(900, 600);
  13 if ($use_date_picker)
  14         $js .= get_js_date_picker();
  15
  16 if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true))
  17 {
  18         $_POST['OutstandingOnly'] = true;
  19         page(_("Search Not Invoiced Deliveries"), false, false, "", $js);
  20 }
  21 else
  22 {
  23         $_POST['OutstandingOnly'] = false;
  24         page(_("Search All Deliveries"), false, false, "", $js);
  25 }
  26
  27 if (isset($_GET['selected_customer']))
  28 {
  29         $selected_customer = $_GET['selected_customer'];
  30 }
  31 elseif (isset($_POST['selected_customer']))
  32 {
  33         $selected_customer = $_POST['selected_customer'];
  34 }
  35 else
  36         $selected_customer = -1;
  37
  38 if (isset($_POST['BatchInvoice']))
  39 {
  40
  41         // checking batch integrity
  42     $del_count = 0;
  43     foreach($_SESSION['Batch'] as $delivery)
  44     {
  45                 $checkbox = 'Sel_'.$delivery['trans'];
  46                 if (check_value($checkbox))
  47                 {
  48                 if (!$del_count)
  49                 {
  50                                 $del_customer = $delivery['cust'];
  51                                 $del_branch = $delivery['branch'];
  52                 }
  53                 else
  54                 {
  55                                 if ($del_customer!=$delivery['cust'] || $del_branch != $delivery['branch'])
  56                                 {
  57                                 $del_count=0;
  58                                 break;
  59                                 }
  60                 }
  61                 $selected[] = $delivery['trans'];
  62                 $del_count++;
  63                 }
  64     }
  65
  66     if (!$del_count)
  67     {
  68                 display_error(_('For batch invoicing you should
  69                     select at least one delivery. All items must be dispatched to
  70                     the same customer branch.'));
  71     }
  72     else
  73     {
  74                 $_SESSION['DeliveryBatch'] = $selected;
  75                 meta_forward($path_to_root . '/sales/customer_invoice.php','BatchInvoice=Yes');
  76     }
  77 }
  78
  79 //-----------------------------------------------------------------------------------
  80 if (get_post('SearchOrders'))
  81 {
  82         $Ajax->activate('deliveries_tbl');
  83 } elseif (get_post('_DeliveryNumber_changed'))
  84 {
  85         $disable = get_post('DeliveryNumber') !== '';
  86
  87         $Ajax->addDisable(true, 'DeliveryAfterDate', $disable);
  88         $Ajax->addDisable(true, 'DeliveryToDate', $disable);
  89         $Ajax->addDisable(true, 'StockLocation', $disable);
  90         $Ajax->addDisable(true, '_SelectStockFromList_edit', $disable);
  91         $Ajax->addDisable(true, 'SelectStockFromList', $disable);
  92         // if search is not empty rewrite table
  93         if ($disable) {
  94                 $Ajax->addFocus(true, 'DeliveryNumber');
  95         } else
  96                 $Ajax->addFocus(true, 'DeliveryAfterDate');
  97         $Ajax->activate('deliveries_tbl');
  98 }
  99
 100 //-----------------------------------------------------------------------------------
 101 print_hidden_script(13);
 102
 103 start_form(false, false, $_SERVER['PHP_SELF'] ."?OutstandingOnly=" . $_POST['OutstandingOnly'] .SID);
 104
 105 start_table("class='tablestyle_noborder'");
 106 start_row();
 107 ref_cells(_("#:"), 'DeliveryNumber', '',null, '', true);
 108 date_cells(_("from:"), 'DeliveryAfterDate', '', null, -30);
 109 date_cells(_("to:"), 'DeliveryToDate', '', null, 1);
 110
 111 locations_list_cells(_("Location:"), 'StockLocation', null, true);
 112
 113 stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
 114
 115 submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true);
 116
 117 hidden('OutstandingOnly', $_POST['OutstandingOnly']);
 118
 119 end_row();
 120
 121 end_table();
 122
 123 //---------------------------------------------------------------------------------------------
 124
 125 if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "") &&
 126         ($_POST['SelectStockFromList'] != reserved_words::get_all()))
 127 {
 128         $selected_stock_item = $_POST['SelectStockFromList'];
 129 }
 130 else
 131 {
 132         unset($selected_stock_item);
 133 }
 134
 135 //---------------------------------------------------------------------------------------------
 136 $sql = "SELECT ".TB_PREF."debtor_trans.trans_no, "
 137         .TB_PREF."debtors_master.curr_code, "
 138         .TB_PREF."debtors_master.name, "
 139         .TB_PREF."cust_branch.br_name, "
 140         .TB_PREF."debtor_trans.reference, "
 141         .TB_PREF."debtor_trans.tran_date, "
 142         .TB_PREF."debtor_trans.due_date, "
 143         .TB_PREF."sales_orders.customer_ref, "
 144         .TB_PREF."sales_orders.deliver_to, ";
 145
 146 $sql .= " Sum(".TB_PREF."debtor_trans_details.quantity-"
 147                  .TB_PREF."debtor_trans_details.qty_done) AS Outstanding, ";
 148
 149 $sql .= " Sum(".TB_PREF."debtor_trans_details.qty_done) AS Done, ";
 150
 151 $sql .= "(ov_amount+ov_gst+ov_freight+ov_freight_tax) AS DeliveryValue";
 152 $sql .=" FROM "
 153          .TB_PREF."sales_orders, "
 154          .TB_PREF."debtor_trans, "
 155          .TB_PREF."debtor_trans_details, "
 156          .TB_PREF."debtors_master, "
 157          .TB_PREF."cust_branch
 158                 WHERE "
 159                 .TB_PREF."sales_orders.order_no = ".TB_PREF."debtor_trans.order_ AND "
 160                 .TB_PREF."debtor_trans.debtor_no = ".TB_PREF."debtors_master.debtor_no
 161                         AND ".TB_PREF."debtor_trans.type = 13
 162                         AND ".TB_PREF."debtor_trans_details.debtor_trans_no = ".TB_PREF."debtor_trans.trans_no
 163                         AND ".TB_PREF."debtor_trans_details.debtor_trans_type = ".TB_PREF."debtor_trans.type
 164                         AND ".TB_PREF."debtor_trans.branch_code = ".TB_PREF."cust_branch.branch_code
 165                         AND ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."cust_branch.debtor_no ";
 166
 167         if ($_POST['OutstandingOnly'] == true) {
 168          $sql .= " AND ".TB_PREF."debtor_trans_details.qty_done < ".TB_PREF."debtor_trans_details.quantity ";
 169         }
 170
 171 //figure out the sql required from the inputs available
 172 if (isset($_POST['DeliveryNumber']) && $_POST['DeliveryNumber'] != "")
 173 {
 174 // if ($_POST['DeliveryNumber'] != '*') // TODO paged table
 175         $sql .= " AND ".TB_PREF."debtor_trans.trans_no LIKE '%". $_POST['DeliveryNumber'] ."'";
 176  $sql .= " GROUP BY ".TB_PREF."debtor_trans.trans_no";
 177 }
 178 else
 179 {
 180
 181         $date_after = date2sql($_POST['DeliveryAfterDate']);
 182         $date_before = date2sql($_POST['DeliveryToDate']);
 183
 184         $sql .= " AND ".TB_PREF."debtor_trans.tran_date >= '$date_after'";
 185         $sql .= " AND ".TB_PREF."debtor_trans.tran_date <= '$date_before'";
 186
 187         if ($selected_customer != -1)
 188                 $sql .= " AND ".TB_PREF."debtor_trans.debtor_no='" . $selected_customer . "' ";
 189
 190         if (isset($selected_stock_item))
 191                 $sql .= " AND ".TB_PREF."debtor_trans_details.stock_id='". $selected_stock_item ."' ";
 192
 193         if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
 194                 $sql .= " AND ".TB_PREF."sales_orders.from_stk_loc = '". $_POST['StockLocation'] . "' ";
 195
 196         $sql .= " GROUP BY ".TB_PREF."debtor_trans.trans_no ";
 197
 198 } //end no delivery number selected
 199
 200 $result = db_query($sql,"No deliveries were returned");
 201
 202 //-----------------------------------------------------------------------------------
 203 if (isset($_SESSION['Batch']))
 204 {
 205     foreach($_SESSION['Batch'] as $trans=>$del)
 206         unset($_SESSION['Batch'][$trans]);
 207     unset($_SESSION['Batch']);
 208 }
 209 if ($result)
 210 {
 211         /*show a table of the deliveries returned by the sql */
 212
 213         div_start('deliveries_tbl');
 214
 215         start_table("$table_style colspan=7 width=95%");
 216         $th = array(_("Delivery #"), _("Customer"), _("Branch"), _("Reference"), _("Delivery Date"),
 217                 _("Due By"), _("Delivery Total"), _("Currency"), submit('BatchInvoice','Batch Inv', false),
 218                  "", "", "");
 219         table_header($th);
 220
 221         $j = 1;
 222         $k = 0; //row colour counter
 223         $overdue_items = false;
 224         while ($myrow = db_fetch($result))
 225         {
 226             $_SESSION['Batch'][] = array('trans'=>$myrow["trans_no"],
 227             'cust'=>$myrow["name"],'branch'=>$myrow["br_name"] );
 228
 229             $view_page = get_customer_trans_view_str(13, $myrow["trans_no"]);
 230             $formated_del_date = sql2date($myrow["tran_date"]);
 231             $formated_due_date = sql2date($myrow["due_date"]);
 232             $not_closed =  $myrow["Outstanding"]!=0;
 233
 234         // if overdue orders, then highlight as so
 235
 236         if (date1_greater_date2(Today(), $formated_due_date) && $not_closed )
 237         {
 238                  start_row("class='overduebg'");
 239                  $overdue_items = true;
 240         }
 241         else
 242         {
 243                         alt_table_row_color($k);
 244         }
 245
 246                 label_cell($view_page);
 247                 label_cell($myrow["name"]);
 248                 label_cell($myrow["br_name"]);
 249                 label_cell($myrow["reference"]);
 250                 label_cell($formated_del_date);
 251                 label_cell($formated_due_date);
 252                 amount_cell($myrow["DeliveryValue"]);
 253                 label_cell($myrow["curr_code"]);
 254                 if (!$myrow['Done'])
 255                     check_cells(null,'Sel_'. $myrow['trans_no'],0,false);
 256                 else
 257                     label_cell("");
 258                 if ($_POST['OutstandingOnly'] == true || $not_closed)
 259                 {
 260                 $modify_page = $path_to_root . "/sales/customer_delivery.php?" . SID . "ModifyDelivery=" . $myrow["trans_no"];
 261                 $invoice_page = $path_to_root . "/sales/customer_invoice.php?" . SID . "DeliveryNumber=" .$myrow["trans_no"];
 262                 label_cell("<a href='$modify_page'>" . _("Edit") . "</a>");
 263                         label_cell(print_document_link($myrow['trans_no'], _("Print")));
 264
 265                 label_cell($not_closed ? "<a href='$invoice_page'>" . _("Invoice") . "</a>" : '');
 266
 267                 }
 268                 else
 269                 {
 270                 label_cell("");
 271                 label_cell("");
 272                 label_cell("");
 273                 }
 274                 end_row();;
 275
 276                 $j++;
 277                 If ($j == 12)
 278                 {
 279                         $j = 1;
 280                         table_header($th);
 281                 }
 282                 //end of page full new headings if
 283         }
 284         //end of while loop
 285
 286         end_table();
 287
 288    if ($overdue_items)
 289                 display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'");
 290 div_end();
 291 }
 292
 293 echo "<br>";
 294 end_form();
 295
 296 end_page();
 297 ?>
 298