Care2007/modules/weberp/WorkOrderStatus.php

   1 <?php
   2 /* $Revision: 1.1 $ */
   3
   4 $PageSecurity = 11;
   5
   6 include('includes/session.inc');
   7 $title = _('Work Order Status Inquiry');
   8 include('includes/header.inc');
   9
  10         $ErrMsg = _('Could not retrieve the details of the selected work order item');
  11         $WOResult = DB_query("SELECT workorders.loccode,
  12                          locations.locationname,
  13                          workorders.requiredby,
  14                          workorders.startdate,
  15                          workorders.closed,
  16                          stockmaster.description,
  17                          stockmaster.decimalplaces,
  18                          stockmaster.units,
  19                          woitems.qtyreqd,
  20                          woitems.qtyrecd
  21                         FROM workorders INNER JOIN locations
  22                         ON workorders.loccode=locations.loccode
  23                         INNER JOIN woitems
  24                         ON workorders.wo=woitems.wo
  25                         INNER JOIN stockmaster
  26                         ON woitems.stockid=stockmaster.stockid
  27                         WHERE woitems.stockid='" . DB_escape_string($_REQUEST['StockID']) . "'
  28                         AND woitems.wo =" . $_REQUEST['WO'],
  29                         $db,
  30                         $ErrMsg);
  31
  32         if (DB_num_rows($WOResult)==0){
  33                 prnMsg(_('The selected work order item cannot be retrieved from the database'),'info');
  34                 include('includes/footer.inc');
  35                 exit;
  36         }
  37         $WORow = DB_fetch_array($WOResult);
  38
  39         echo '<A HREF="'. $rootpath . '/SelectWorkOrder.php?' . SID . '">' . _('Back to Work Orders'). '</A><BR>';
  40
  41         echo '<center><table cellpadding=2 border=1>
  42                 <tr><td class="label">' . _('Issue to work order') . ':</td><td>' . $_REQUEST['WO'] .'</td><td class="label">' . _('Item') . ':</td><td>' . $_REQUEST['StockID'] . ' - ' . $WORow['description'] . '</td></tr>
  43                 <tr><td class="label">' . _('Manufactured at') . ':</td><td>' . $WORow['locationname'] . '</td><td class="label">' . _('Required By') . ':</td><td>' . ConvertSQLDate($WORow['requiredby']) . '</td></tr>
  44                 <tr><td class="label">' . _('Quantity Ordered') . ':</td><td align=right>' . number_format($WORow['qtyreqd'],$WORow['decimalplaces']) . '</td><td colspan=2>' . $WORow['units'] . '</td></tr>
  45                 <tr><td class="label">' . _('Already Received') . ':</td><td align=right>' . number_format($WORow['qtyrecd'],$WORow['decimalplaces']) . '</td><td colspan=2>' . $WORow['units'] . '</td></tr>
  46                 <tr><td class="label">' . _('Date Material Issued') . ':</td><td>' . Date($_SESSION['DefaultDateFormat']) . '</td>
  47                 <td class="label">' . _('Issued From') . ':</td><td>';
  48
  49                 if (!isset($_POST['FromLocation'])){
  50                         $_POST['FromLocation']=$WORow['loccode'];
  51                 }
  52                 $LocResult = DB_query("SELECT loccode, locationname
  53                                 FROM locations
  54                                 WHERE loccode='" . $_POST['FromLocation'] . "'",
  55                                 $db);
  56                 $LocRow = DB_fetch_array($LocResult);
  57                 echo $LocRow['locationname'];
  58                 echo '<tr><td colspan=4><hr></td></tr>';
  59                 echo '</td></tr></table>';
  60
  61                 //set up options for selection of the item to be issued to the WO
  62                 echo '<table border=1><tr><td colspan=5 class="tableheader">' . _('Material Requirements For this Work Order') . '</td></tr>';
  63                 echo '<tr><td colspan=2 class="tableheader">' . _('Item') . '</td>
  64                         <td class="tableheader">' . _('Qty Required') . '</td>
  65                         <td class="tableheader">' . _('Qty Issued') . '</td></tr>';
  66
  67                 $RequirmentsResult = DB_query("SELECT worequirements.stockid,
  68                                                 stockmaster.description,
  69                                                 stockmaster.decimalplaces,
  70                                                 autoissue,
  71                                                 qtypu
  72                                         FROM worequirements INNER JOIN stockmaster
  73                                         ON worequirements.stockid=stockmaster.stockid
  74                                         WHERE wo=" . $_REQUEST['WO'],
  75                                         $db);
  76
  77                 while ($RequirementsRow = DB_fetch_array($RequirmentsResult)){
  78                         if ($RequirementsRow['autoissue']==0){
  79                                 echo '<tr><td>' . _('Manual Issue') . '
  80                                 <td>' . $RequirementsRow['stockid'] . ' - ' . $RequirementsRow['description'] . '</td>';
  81                         } else {
  82                                 echo '<tr><td class="notavailable">' . _('Auto Issue') . '<td class="notavailable">' .$RequirementsRow['stockid'] . ' - ' . $RequirementsRow['description'] .'</td>';
  83                         }
  84                         $IssuedAlreadyResult = DB_query("SELECT SUM(-qty) FROM stockmoves
  85                                                         WHERE stockmoves.type=28
  86                                                         AND stockid='" . $RequirementsRow['stockid'] . "'
  87                                                         AND reference='" . DB_escape_string($_REQUEST['WO']) . "'",
  88                                                 $db);
  89                         $IssuedAlreadyRow = DB_fetch_row($IssuedAlreadyResult);
  90
  91                         echo '<td align="right">' . number_format($WORow['qtyreqd']*$RequirementsRow['qtypu'],$RequirementsRow['decimalplaces']) . '</td>
  92                                 <td align="right">' . number_format($IssuedAlreadyRow[0],$RequirementsRow['decimalplaces']) . '</td></tr>';
  93                 }
  94
  95                 echo '</table>';
  96
  97
  98 include('includes/footer.inc');
  99
 100 ?>