Care2007/modules/weberp/StockReorderLevel.php

   1 <?php
   2
   3 /* $Revision: 1.8 $ */
   4
   5
   6 $PageSecurity = 4;
   7
   8 include('includes/session.inc');
   9 $title = _('Stock Re-Order Level Maintenance');
  10 include('includes/header.inc');
  11
  12 if (isset($_GET['StockID'])){
  13         $StockID = trim(strtoupper($_GET['StockID']));
  14 } elseif (isset($_POST['StockID'])){
  15         $StockID = trim(strtoupper($_POST['StockID']));
  16 }
  17
  18
  19 echo "<A HREF='" . $rootpath . '/SelectProduct.php?' . SID . "'>" . _('Back to Items') . '</A><BR>';
  20
  21 $result = DB_query("SELECT description, units FROM stockmaster WHERE stockid='$StockID'", $db);
  22 $myrow = DB_fetch_row($result);
  23
  24 echo '<BR><FONT COLOR=BLUE SIZE=3><B>' . $StockID . ' - ' . $myrow[0] . '</B>  (' . _('In Units of') . ' ' . $myrow[1] . ')</FONT>';
  25 echo "<FORM ACTION='" . $_SERVER['PHP_SELF'] . "?" . SID . "' METHOD=POST>";
  26 echo _('Stock Code') . ":<INPUT TYPE=TEXT NAME='StockID' SIZE=21 VALUE='$StockID' MAXLENGTH=20>";
  27 echo "     <INPUT TYPE=SUBMIT NAME='Show' VALUE='" . _('Show Re-Order Levels') . "'><HR>";
  28
  29 $sql = "SELECT locstock.loccode,
  30                 locations.locationname,
  31                 locstock.quantity,
  32                 locstock.reorderlevel
  33         FROM locstock,
  34                 locations
  35         WHERE locstock.loccode=locations.loccode
  36         AND locstock.stockid = '" . $StockID . "'
  37         ORDER BY locstock.loccode";
  38
  39 $ErrMsg = _('The stock held at each location cannot be retrieved because');
  40 $DbgMsg = _('The SQL that failed was');
  41
  42 $LocStockResult = DB_query($sql, $db, $ErrMsg, $DbgMsg);
  43
  44 echo "<CENTER><TABLE CELLPADDING=2 BORDER=2>";
  45
  46 $TableHeader = "<TR>
  47                 <TD CLASS='tableheader'>" . _('Location') . "</TD>
  48                 <TD CLASS='tableheader'>" . _('Quantity On Hand') . "</TD>
  49                 <TD CLASS='tableheader'>" . _('Re-Order Level') . "</TD>
  50                 </TR>";
  51
  52 echo $TableHeader;
  53 $j = 1;
  54 $k=0; //row colour counter
  55
  56 while ($myrow=DB_fetch_array($LocStockResult)) {
  57
  58         if ($k==1){
  59                 echo "<TR BGCOLOR='#CCCCCC'>";
  60                 $k=0;
  61         } else {
  62                 echo "<TR BGCOLOR='#EEEEEE'>";
  63                 $k=1;
  64         }
  65
  66         if (isset($_POST['UpdateData']) AND is_numeric($_POST[$myrow['loccode']]) AND $_POST[$myrow['loccode']]>0){
  67
  68            $myrow['reorderlevel'] = $_POST[$myrow['loccode']];
  69            $sql = 'UPDATE locstock SET reorderlevel = ' . $_POST[$myrow['loccode']] . "
  70                         WHERE stockid = '" . $StockID . "'
  71                         AND loccode = '"  . $myrow['loccode'] ."'";
  72            $UpdateReorderLevel = DB_query($sql, $db);
  73
  74         }
  75
  76         printf("<TD>%s</TD>
  77                 <TD ALIGN=RIGHT>%s</TD>
  78                 <TD><INPUT TYPE=TEXT NAME=%s MAXLENGTH=10 SIZE=10 VALUE=%s></TD>",
  79                 $myrow['locationname'],
  80                 number_format($myrow['quantity']),
  81                 $myrow['loccode'],
  82                 $myrow['reorderlevel']);
  83         $j++;
  84         If ($j == 12){
  85                 $j=1;
  86                 echo $TableHeader;
  87         }
  88 //end of page full new headings if
  89 }
  90 //end of while loop
  91
  92 echo "</TABLE><INPUT TYPE=SUBMIT NAME='UpdateData' VALUE='" . _('Update') . "'><HR>";
  93 echo "<A HREF='$rootpath/StockMovements.php?" . SID . "&StockID=$StockID'>" . _('Show Stock Movements') . '</A>';
  94 echo "<BR><A HREF='$rootpath/StockUsage.php?" . SID . "&StockID=$StockID'>" . _('Show Stock Usage') . '</A>';
  95 echo "<BR><A HREF='$rootpath/SelectSalesOrder.php?" . SID . "&SelectedStockItem=$StockID'>" . _('Search Outstanding Sales Orders') . '</A>';
  96 echo "<BR><A HREF='$rootpath/SelectCompletedOrder.php?" . SID . "&SelectedStockItem=$StockID'>" . _('Search Completed Sales Orders') . '</A>';
  97
  98 echo '</FORM>';
  99 include('includes/footer.inc');
 100 ?>