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