manufacturing/work_order_add_finished.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 = 10;
  13 $path_to_root="..";
  14 include_once($path_to_root . "/includes/session.inc");
  15
  16 include_once($path_to_root . "/includes/date_functions.inc");
  17 include_once($path_to_root . "/gl/includes/db/gl_db_bank_trans.inc");
  18 include_once($path_to_root . "/includes/db/inventory_db.inc");
  19 include_once($path_to_root . "/includes/manufacturing.inc");
  20
  21 include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
  22 include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc");
  23
  24 $js = "";
  25 if ($use_popup_windows)
  26         $js .= get_js_open_window(900, 500);
  27 if ($use_date_picker)
  28         $js .= get_js_date_picker();
  29 page(_("Produce or Unassemble Finished Items From Work Order"), false, false, "", $js);
  30
  31 if (isset($_GET['trans_no']) && $_GET['trans_no'] != "")
  32 {
  33         $_POST['selected_id'] = $_GET['trans_no'];
  34 }
  35
  36 //--------------------------------------------------------------------------------------------------
  37
  38 if (isset($_GET['AddedID']))
  39 {
  40
  41         display_notification(_("The manufacturing process has been entered."));
  42
  43         hyperlink_no_params("search_work_orders.php", _("Select another &Work Order to Process"));
  44
  45         end_page();
  46         exit;
  47 }
  48
  49 //--------------------------------------------------------------------------------------------------
  50
  51 $wo_details = get_work_order($_POST['selected_id']);
  52
  53 if (strlen($wo_details[0]) == 0)
  54 {
  55         display_error(_("The order number sent is not valid."));
  56         exit;
  57 }
  58
  59 //--------------------------------------------------------------------------------------------------
  60
  61 function can_process()
  62 {
  63         global $wo_details;
  64
  65         if (!references::is_valid($_POST['ref']))
  66         {
  67                 display_error(_("You must enter a reference."));
  68                 set_focus('ref');
  69                 return false;
  70         }
  71
  72         if (!is_new_reference($_POST['ref'], 29))
  73         {
  74                 display_error(_("The entered reference is already in use."));
  75                 set_focus('ref');
  76                 return false;
  77         }
  78
  79         if (!check_num('quantity', 0))
  80         {
  81                 display_error(_("The quantity entered is not a valid number or less then zero."));
  82                 set_focus('quantity');
  83                 return false;
  84         }
  85
  86         if (!is_date($_POST['date_']))
  87         {
  88                 display_error(_("The entered date is invalid."));
  89                 set_focus('date_');
  90                 return false;
  91         }
  92         elseif (!is_date_in_fiscalyear($_POST['date_']))
  93         {
  94                 display_error(_("The entered date is not in fiscal year."));
  95                 set_focus('date_');
  96                 return false;
  97         }
  98         if (date_diff(sql2date($wo_details["released_date"]), $_POST['date_'], "d") > 0)
  99         {
 100                 display_error(_("The production date cannot be before the release date of the work order."));
 101                 set_focus('date_');
 102                 return false;
 103         }
 104
 105         // if unassembling we need to check the qoh
 106         if (($_POST['ProductionType'] == 0) && !sys_prefs::allow_negative_stock())
 107         {
 108                 $wo_details = get_work_order($_POST['selected_id']);
 109
 110                 $qoh = get_qoh_on_date($wo_details["stock_id"], $wo_details["loc_code"], $_POST['date_']);
 111                 if (-$_POST['quantity'] + $qoh < 0)
 112                 {
 113                         display_error(_("The unassembling cannot be processed because there is insufficient stock."));
 114                         set_focus('quantity');
 115                         return false;
 116                 }
 117         }
 118
 119         // if production we need to check the qoh of the wo requirements
 120         if (($_POST['ProductionType'] == 1) && !sys_prefs::allow_negative_stock())
 121         {
 122         $err = false;
 123         $result = get_wo_requirements($_POST['selected_id']);
 124                 while ($row = db_fetch($result))
 125                 {
 126                         if ($row['mb_flag'] == 'D') // service, non stock
 127                                 continue;
 128                         $qoh = get_qoh_on_date($row["stock_id"], $row["loc_code"], $_POST['date_']);
 129                         if ($qoh - $row['units_req'] * $_POST['quantity'] < 0)
 130                         {
 131                         display_error( _("The production cannot be processed because a required item would cause a negative inventory balance :") .
 132                                 " " . $row['stock_id'] . " - " .  $row['description']);
 133                         $err = true;
 134                         }
 135                 }
 136                 if ($err)
 137                 {
 138                         set_focus('quantity');
 139                         return false;
 140                 }
 141         }
 142         return true;
 143 }
 144
 145 //--------------------------------------------------------------------------------------------------
 146
 147 if ((isset($_POST['Process']) || isset($_POST['ProcessAndClose'])) && can_process() == true)
 148 {
 149
 150         $close_wo = 0;
 151         if (isset($_POST['ProcessAndClose']) && ($_POST['ProcessAndClose']!=""))
 152                 $close_wo = 1;
 153
 154         // if unassembling, negate quantity
 155         if ($_POST['ProductionType'] == 0)
 156                 $_POST['quantity'] = -$_POST['quantity'];
 157
 158          $id = work_order_produce($_POST['selected_id'], $_POST['ref'], $_POST['quantity'],
 159                         $_POST['date_'], $_POST['memo_'], $close_wo);
 160
 161         meta_forward($_SERVER['PHP_SELF'], "AddedID=$id");
 162 }
 163
 164 //-------------------------------------------------------------------------------------
 165
 166 display_wo_details($_POST['selected_id']);
 167
 168 //-------------------------------------------------------------------------------------
 169
 170 start_form();
 171
 172 hidden('selected_id', $_POST['selected_id']);
 173 //hidden('WOReqQuantity', $_POST['WOReqQuantity']);
 174
 175 if (!isset($_POST['quantity']) || $_POST['quantity'] == '')
 176 {
 177         $_POST['quantity'] = max($wo_details["units_reqd"] - $wo_details["units_issued"], 0);
 178 }
 179
 180 start_table();
 181
 182 ref_row(_("Reference:"), 'ref', '', references::get_next(29));
 183
 184 if (!isset($_POST['ProductionType']))
 185         $_POST['ProductionType'] = 1;
 186
 187 yesno_list_row(_("Type:"), 'ProductionType', $_POST['ProductionType'],
 188         _("Produce Finished Items"), _("Return Items to Work Order"));
 189
 190 small_qty_row(_("Quantity:"), 'quantity', null, null, null, get_qty_dec($wo_details["stock_id"]));
 191
 192 date_row(_("Date:"), 'date_');
 193
 194 textarea_row(_("Memo:"), 'memo_', null, 40, 3);
 195
 196 end_table(1);
 197
 198 submit_center_first('Process', _("Process"), '', 'default');
 199 submit_center_last('ProcessAndClose', _("Process And Close Order"), '', true);
 200
 201 end_form();
 202
 203 end_page();
 204
 205 ?>