sales/inquiry/sales_deliveries_view.php

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 $page_security = 'SA_SALESINVOICE';
  13 $path_to_root = "../..";
  14 include($path_to_root . "/includes/db_pager.inc");
  15 include($path_to_root . "/includes/session.inc");
  16
  17 include($path_to_root . "/sales/includes/sales_ui.inc");
  18 include_once($path_to_root . "/reporting/includes/reporting.inc");
  19
  20 $js = "";
  21 if ($SysPrefs->use_popup_windows)
  22         $js .= get_js_open_window(900, 600);
  23 if (user_use_date_picker())
  24         $js .= get_js_date_picker();
  25
  26 if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true))
  27 {
  28         $_POST['OutstandingOnly'] = true;
  29         page(_($help_context = "Search Not Invoiced Deliveries"), false, false, "", $js);
  30 }
  31 else
  32 {
  33         $_POST['OutstandingOnly'] = false;
  34         page(_($help_context = "Search All Deliveries"), false, false, "", $js);
  35 }
  36
  37 if (isset($_GET['selected_customer']))
  38 {
  39         $_POST['customer_id'] = $_GET['selected_customer'];
  40 }
  41 elseif (isset($_POST['selected_customer']))
  42 {
  43         $_POST['customer_id'] = $_POST['selected_customer'];
  44 }
  45
  46 if (isset($_POST['BatchInvoice']))
  47 {
  48         // checking batch integrity
  49     $del_count = 0;
  50     foreach($_POST['Sel_'] as $delivery => $branch) {
  51                 $checkbox = 'Sel_'.$delivery;
  52                 if (check_value($checkbox))     {
  53                 if (!$del_count) {
  54                                 $del_branch = $branch;
  55                 }
  56                 else {
  57                                 if ($del_branch != $branch)     {
  58                                 $del_count=0;
  59                                 break;
  60                                 }
  61                 }
  62                 $selected[] = $delivery;
  63                 $del_count++;
  64                 }
  65     }
  66
  67     if (!$del_count) {
  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     } else {
  72                 $_SESSION['DeliveryBatch'] = $selected;
  73                 meta_forward($path_to_root . '/sales/customer_invoice.php','BatchInvoice=Yes');
  74     }
  75 }
  76
  77 //-----------------------------------------------------------------------------------
  78 if (get_post('_DeliveryNumber_changed'))
  79 {
  80         $disable = get_post('DeliveryNumber') !== '';
  81
  82         $Ajax->addDisable(true, 'DeliveryAfterDate', $disable);
  83         $Ajax->addDisable(true, 'DeliveryToDate', $disable);
  84         $Ajax->addDisable(true, 'StockLocation', $disable);
  85         $Ajax->addDisable(true, '_SelectStockFromList_edit', $disable);
  86         $Ajax->addDisable(true, 'SelectStockFromList', $disable);
  87         // if search is not empty rewrite table
  88         if ($disable) {
  89                 $Ajax->addFocus(true, 'DeliveryNumber');
  90         } else
  91                 $Ajax->addFocus(true, 'DeliveryAfterDate');
  92         $Ajax->activate('deliveries_tbl');
  93 }
  94
  95 //-----------------------------------------------------------------------------------
  96
  97 start_form(false, false, $_SERVER['PHP_SELF'] ."?OutstandingOnly=".$_POST['OutstandingOnly']);
  98
  99 start_table(TABLESTYLE_NOBORDER);
 100 start_row();
 101 ref_cells(_("#:"), 'DeliveryNumber', '',null, '', true);
 102 date_cells(_("from:"), 'DeliveryAfterDate', '', null, -user_transaction_days());
 103 date_cells(_("to:"), 'DeliveryToDate', '', null, 1);
 104
 105 locations_list_cells(_("Location:"), 'StockLocation', null, true);
 106 end_row();
 107
 108 end_table();
 109 start_table(TABLESTYLE_NOBORDER);
 110 start_row();
 111
 112 stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
 113
 114 customer_list_cells(_("Select a customer: "), 'customer_id', null, true, true);
 115
 116 submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default');
 117
 118 hidden('OutstandingOnly', $_POST['OutstandingOnly']);
 119
 120 end_row();
 121
 122 end_table(1);
 123 //---------------------------------------------------------------------------------------------
 124
 125 function trans_view($trans, $trans_no)
 126 {
 127         return get_customer_trans_view_str(ST_CUSTDELIVERY, $trans['trans_no']);
 128 }
 129
 130 function batch_checkbox($row)
 131 {
 132         $name = "Sel_" .$row['trans_no'];
 133         return $row['Done'] ? '' :
 134                 "<input type='checkbox' name='$name' value='1' >"
 135 // add also trans_no => branch code for checking after 'Batch' submit
 136          ."<input name='Sel_[".$row['trans_no']."]' type='hidden' value='"
 137          .$row['branch_code']."'>\n";
 138 }
 139
 140 function edit_link($row)
 141 {
 142         return $row["Outstanding"]==0 ? '' :
 143                 trans_editor_link(ST_CUSTDELIVERY, $row['trans_no']);
 144 }
 145
 146 function prt_link($row)
 147 {
 148         return print_document_link($row['trans_no'], _("Print"), true, ST_CUSTDELIVERY, ICON_PRINT);
 149 }
 150
 151 function invoice_link($row)
 152 {
 153         return $row["Outstanding"]==0 ? '' :
 154                 pager_link(_('Invoice'), "/sales/customer_invoice.php?DeliveryNumber="
 155                         .$row['trans_no'], ICON_DOC);
 156 }
 157
 158 function check_overdue($row)
 159 {
 160         return date1_greater_date2(Today(), sql2date($row["due_date"])) &&
 161                         $row["Outstanding"]!=0;
 162 }
 163 //------------------------------------------------------------------------------------------------
 164 $sql = get_sql_for_sales_deliveries_view(get_post('DeliveryAfterDate'), get_post('DeliveryToDate'), get_post('customer_id'),
 165         get_post('SelectStockFromList'), get_post('StockLocation'), get_post('DeliveryNumber'), get_post('OutstandingOnly'));
 166
 167 $cols = array(
 168                 _("Delivery #") => array('fun'=>'trans_view'),
 169                 _("Customer"),
 170                 'branch_code' => 'skip',
 171                 _("Branch") => array('ord'=>''),
 172                 _("Contact"),
 173                 _("Reference"),
 174                 _("Cust Ref"),
 175                 _("Delivery Date") => array('type'=>'date', 'ord'=>''),
 176                 _("Due By") => 'date',
 177                 _("Delivery Total") => array('type'=>'amount', 'ord'=>''),
 178                 _("Currency") => array('align'=>'center'),
 179                 submit('BatchInvoice',_("Batch"), false, _("Batch Invoicing"))
 180                         => array('insert'=>true, 'fun'=>'batch_checkbox', 'align'=>'center'),
 181                 array('insert'=>true, 'fun'=>'edit_link'),
 182                 array('insert'=>true, 'fun'=>'invoice_link'),
 183                 array('insert'=>true, 'fun'=>'prt_link')
 184 );
 185
 186 //-----------------------------------------------------------------------------------
 187 if (isset($_SESSION['Batch']))
 188 {
 189     foreach($_SESSION['Batch'] as $trans=>$del)
 190         unset($_SESSION['Batch'][$trans]);
 191     unset($_SESSION['Batch']);
 192 }
 193
 194 $table =& new_db_pager('deliveries_tbl', $sql, $cols);
 195 $table->set_marker('check_overdue', _("Marked items are overdue."));
 196
 197 //$table->width = "92%";
 198
 199 display_db_pager($table);
 200
 201 end_form();
 202 end_page();
 203