manufacturing/includes/db/work_order_requirements_db.inc

   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 function get_wo_requirements($woid)
  13 {
  14         $sql = "SELECT ".TB_PREF."wo_requirements.*, ".TB_PREF."stock_master.description,
  15                 ".TB_PREF."stock_master.mb_flag,
  16                 ".TB_PREF."locations.location_name,
  17                 ".TB_PREF."workcentres.name AS WorkCentreDescription FROM
  18                 (".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres) INNER JOIN ".TB_PREF."stock_master ON
  19                 ".TB_PREF."wo_requirements.stock_id = ".TB_PREF."stock_master.stock_id
  20                 WHERE workorder_id=$woid
  21                 AND ".TB_PREF."locations.loc_code = ".TB_PREF."wo_requirements.loc_code
  22                 AND ".TB_PREF."workcentres.id=workcentre";
  23
  24         return db_query($sql, "The work order requirements could not be retrieved");
  25 }
  26
  27 //--------------------------------------------------------------------------------------
  28
  29 function create_wo_requirements($woid, $stock_id)
  30 {
  31         // create Work Order Requirements based on the bom
  32         $result = get_bom($stock_id);
  33
  34         while ($myrow = db_fetch($result))
  35         {
  36
  37                 $sql = "INSERT INTO ".TB_PREF."wo_requirements (workorder_id, stock_id, workcentre, units_req, loc_code)
  38                         VALUES ($woid, '" .
  39                         $myrow["component"] . "', '"    .
  40                         $myrow["workcentre_added"] . "', '"     .
  41                         $myrow["quantity"] . "', '"     .
  42                         $myrow["loc_code"] . "')";
  43
  44         db_query($sql, "The work order requirements could not be added");
  45         }
  46 }
  47
  48 //--------------------------------------------------------------------------------------
  49
  50 function delete_wo_requirements($woid)
  51 {
  52         $sql="DELETE FROM ".TB_PREF."wo_requirements WHERE workorder_id=$woid";
  53         db_query($sql,"The work order requirements could not be deleted");
  54 }
  55
  56
  57 //--------------------------------------------------------------------------------------
  58
  59 function update_wo_requirement_issued($woReqID, $quantity)
  60 {
  61         $sql = "UPDATE ".TB_PREF."wo_requirements SET units_issued = units_issued + $quantity
  62                 WHERE id = '$woReqID'";
  63
  64         db_query($sql, "The work requirements issued quantity couldn't be updated");
  65 }
  66
  67 //--------------------------------------------------------------------------------------
  68
  69 function void_wo_requirements($woid)
  70 {
  71         $sql = "UPDATE ".TB_PREF."wo_requirements SET units_issued = 0 WHERE workorder_id = $woid";
  72
  73         db_query($sql, "The work requirements issued quantity couldn't be voided");
  74 }
  75
  76 //--------------------------------------------------------------------------------------
  77
  78 ?>