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