manufacturing/view/wo_issue_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_MANUFTRANSVIEW';
  13 $path_to_root = "../..";
  14 include_once($path_to_root . "/includes/session.inc");
  15
  16 $js = "";
  17 if ($SysPrefs->use_popup_windows)
  18         $js .= get_js_open_window(900, 500);
  19 page(_($help_context = "View Work Order Issue"), true, false, "", $js);
  20
  21 include_once($path_to_root . "/includes/date_functions.inc");
  22 include_once($path_to_root . "/includes/data_checks.inc");
  23
  24 include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
  25 include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc");
  26
  27 //-------------------------------------------------------------------------------------------------
  28
  29 if ($_GET['trans_no'] != "")
  30 {
  31         $wo_issue_no = $_GET['trans_no'];
  32 }
  33
  34 //-------------------------------------------------------------------------------------------------
  35
  36 function display_wo_issue($issue_no)
  37 {
  38     $myrow = get_work_order_issue($issue_no);
  39
  40         br(1);
  41     start_table(TABLESTYLE);
  42     $th = array(_("Issue #"), _("Reference"), _("For Work Order #"),
  43         _("Item"), _("From Location"), _("To Work Centre"), _("Date of Issue"));
  44     table_header($th);
  45
  46         start_row();
  47         label_cell($myrow["issue_no"]);
  48         label_cell($myrow["reference"]);
  49         label_cell(get_trans_view_str(ST_WORKORDER,$myrow["workorder_id"]));
  50         label_cell($myrow["stock_id"] . " - " . $myrow["description"]);
  51         label_cell($myrow["location_name"]);
  52         label_cell($myrow["WorkCentreName"]);
  53         label_cell(sql2date($myrow["issue_date"]));
  54         end_row();
  55
  56     comments_display_row(28, $issue_no);
  57
  58         end_table(1);
  59
  60         is_voided_display(28, $issue_no, _("This issue has been voided."));
  61 }
  62
  63 //-------------------------------------------------------------------------------------------------
  64
  65 function display_wo_issue_details($issue_no)
  66 {
  67     $result = get_work_order_issue_details($issue_no);
  68
  69     if (db_num_rows($result) == 0)
  70     {
  71         display_note(_("There are no items for this issue."));
  72     }
  73     else
  74     {
  75         start_table(TABLESTYLE);
  76         $th = array(_("Component"), _("Quantity"), _("Units"));
  77
  78         table_header($th);
  79
  80         $j = 1;
  81         $k = 0; //row colour counter
  82
  83         $total_cost = 0;
  84
  85         while ($myrow = db_fetch($result))
  86         {
  87
  88                         alt_table_row_color($k);
  89
  90                 label_cell($myrow["stock_id"]  . " - " . $myrow["description"]);
  91             qty_cell($myrow["qty_issued"], false, get_qty_dec($myrow["stock_id"]));
  92                         label_cell($myrow["units"]);
  93                         end_row();;
  94
  95                 $j++;
  96                 If ($j == 12)
  97                 {
  98                         $j = 1;
  99                         table_header($th);
 100                 }//end of page full new headings if
 101                 }//end of while
 102
 103                 end_table();
 104     }
 105 }
 106
 107 //-------------------------------------------------------------------------------------------------
 108
 109 display_heading($systypes_array[ST_MANUISSUE] . " # " . $wo_issue_no);
 110
 111 display_wo_issue($wo_issue_no);
 112
 113 display_heading2(_("Items for this Issue"));
 114
 115 display_wo_issue_details($wo_issue_no);
 116
 117 //-------------------------------------------------------------------------------------------------
 118
 119 echo "<br>";
 120
 121 end_page(true, false, false, ST_MANUISSUE, $wo_issue_no);
 122