manufacturing/view/wo_issue_view.php

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