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 = 'SA_MANUFRECEIVE';
  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(_($help_context = "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         include_once($path_to_root . "/reporting/includes/reporting.inc");
  41         $id = $_GET['AddedID'];
  42         $stype = ST_WORKORDER;
  43
  44         display_notification(_("The manufacturing process has been entered."));
  45
  46     display_note(get_trans_view_str($stype, $id, _("View this Work Order")));
  47
  48         display_note(get_gl_view_str($stype, $id, _("View the GL Journal Entries for this Work Order")), 1);
  49         $ar = array('PARAM_0' => $_GET['date'], 'PARAM_1' => $_GET['date'], 'PARAM_2' => $stype);
  50         display_note(print_link(_("Print the GL Journal Entries for this Work Order"), 702, $ar), 1);
  51
  52         hyperlink_no_params("search_work_orders.php", _("Select another &Work Order to Process"));
  53         br();
  54
  55         end_page();
  56         exit;
  57 }
  58
  59 //--------------------------------------------------------------------------------------------------
  60
  61 $wo_details = get_work_order($_POST['selected_id']);
  62
  63 if (strlen($wo_details[0]) == 0)
  64 {
  65         display_error(_("The order number sent is not valid."));
  66         exit;
  67 }
  68
  69 //--------------------------------------------------------------------------------------------------
  70
  71 function can_process()
  72 {
  73         global $wo_details, $SysPrefs, $Refs;
  74
  75         if (!$Refs->is_valid($_POST['ref']))
  76         {
  77                 display_error(_("You must enter a reference."));
  78                 set_focus('ref');
  79                 return false;
  80         }
  81
  82         if (!is_new_reference($_POST['ref'], 29))
  83         {
  84                 display_error(_("The entered reference is already in use."));
  85                 set_focus('ref');
  86                 return false;
  87         }
  88
  89         if (!check_num('quantity', 0))
  90         {
  91                 display_error(_("The quantity entered is not a valid number or less then zero."));
  92                 set_focus('quantity');
  93                 return false;
  94         }
  95
  96         if (!is_date($_POST['date_']))
  97         {
  98                 display_error(_("The entered date is invalid."));
  99                 set_focus('date_');
 100                 return false;
 101         }
 102         elseif (!is_date_in_fiscalyear($_POST['date_']))
 103         {
 104                 display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
 105                 set_focus('date_');
 106                 return false;
 107         }
 108         if (date_diff2(sql2date($wo_details["released_date"]), $_POST['date_'], "d") > 0)
 109         {
 110                 display_error(_("The production date cannot be before the release date of the work order."));
 111                 set_focus('date_');
 112                 return false;
 113         }
 114         // don't produce more that required. Otherwise change the Work Order.
 115         if (input_num('quantity') > ($wo_details["units_reqd"] - $wo_details["units_issued"]))
 116         {
 117                 display_error(_("The production exceeds the quantity needed. Please change the Work Order."));
 118                 set_focus('quantity');
 119                 return false;
 120         }
 121         // if unassembling we need to check the qoh
 122         if (($_POST['ProductionType'] == 0) && !$SysPrefs->allow_negative_stock())
 123         {
 124                 $wo_details = get_work_order($_POST['selected_id']);
 125
 126                 $qoh = get_qoh_on_date($wo_details["stock_id"], $wo_details["loc_code"], $_POST['date_']);
 127                 if (-input_num('quantity') + $qoh < 0)
 128                 {
 129                         display_error(_("The unassembling cannot be processed because there is insufficient stock."));
 130                         set_focus('quantity');
 131                         return false;
 132                 }
 133         }
 134
 135         // if production we need to check the qoh of the wo requirements
 136         if (($_POST['ProductionType'] == 1) && !$SysPrefs->allow_negative_stock())
 137         {
 138         $err = false;
 139         $result = get_wo_requirements($_POST['selected_id']);
 140                 while ($row = db_fetch($result))
 141                 {
 142                         if ($row['mb_flag'] == 'D') // service, non stock
 143                                 continue;
 144                         $qoh = get_qoh_on_date($row["stock_id"], $row["loc_code"], $_POST['date_']);
 145                         if ($qoh - $row['units_req'] * input_num('quantity') < 0)
 146                         {
 147                         display_error( _("The production cannot be processed because a required item would cause a negative inventory balance :") .
 148                                 " " . $row['stock_id'] . " - " .  $row['description']);
 149                         $err = true;
 150                         }
 151                 }
 152                 if ($err)
 153                 {
 154                         set_focus('quantity');
 155                         return false;
 156                 }
 157         }
 158         return true;
 159 }
 160
 161 //--------------------------------------------------------------------------------------------------
 162
 163 if ((isset($_POST['Process']) || isset($_POST['ProcessAndClose'])) && can_process() == true)
 164 {
 165
 166         $close_wo = 0;
 167         if (isset($_POST['ProcessAndClose']) && ($_POST['ProcessAndClose']!=""))
 168                 $close_wo = 1;
 169
 170         // if unassembling, negate quantity
 171         if ($_POST['ProductionType'] == 0)
 172                 $_POST['quantity'] = -$_POST['quantity'];
 173
 174          $id = work_order_produce($_POST['selected_id'], $_POST['ref'], input_num('quantity'),
 175                         $_POST['date_'], $_POST['memo_'], $close_wo);
 176
 177         meta_forward($_SERVER['PHP_SELF'], "AddedID=".$_POST['selected_id']."&date=".$_POST['date_']);
 178 }
 179
 180 //-------------------------------------------------------------------------------------
 181
 182 display_wo_details($_POST['selected_id']);
 183
 184 //-------------------------------------------------------------------------------------
 185
 186 start_form();
 187
 188 hidden('selected_id', $_POST['selected_id']);
 189 //hidden('WOReqQuantity', $_POST['WOReqQuantity']);
 190
 191 $dec = get_qty_dec($wo_details["stock_id"]);
 192 if (!isset($_POST['quantity']) || $_POST['quantity'] == '')
 193         $_POST['quantity'] = qty_format(max($wo_details["units_reqd"] - $wo_details["units_issued"], 0), $wo_details["stock_id"], $dec);
 194
 195 start_table(TABLESTYLE2);
 196 br();
 197
 198 ref_row(_("Reference:"), 'ref', '', $Refs->get_next(29));
 199
 200 if (!isset($_POST['ProductionType']))
 201         $_POST['ProductionType'] = 1;
 202
 203 yesno_list_row(_("Type:"), 'ProductionType', $_POST['ProductionType'],
 204         _("Produce Finished Items"), _("Return Items to Work Order"));
 205
 206 small_qty_row(_("Quantity:"), 'quantity', null, null, null, $dec);
 207
 208 date_row(_("Date:"), 'date_');
 209
 210 textarea_row(_("Memo:"), 'memo_', null, 40, 3);
 211
 212 end_table(1);
 213
 214 submit_center_first('Process', _("Process"), '', 'default');
 215 submit_center_last('ProcessAndClose', _("Process And Close Order"), '', true);
 216
 217 end_form();
 218
 219 end_page();
 220
 221 ?>