Care2007/modules/weberp/DiscountMatrix.php

   1 <?php
   2 /* $Revision: 1.5 $ */
   3
   4 $PageSecurity = 11;
   5 include('includes/session.inc');
   6 $title = _('Discount Matrix Maintenance');
   7 include('includes/header.inc');
   8
   9 if (isset($_POST['submit'])) {
  10
  11         //initialise no input errors assumed initially before we test
  12         $InputError = 0;
  13
  14         if (!is_numeric($_POST['QuantityBreak'])){
  15                 prnMsg( _('The quantity break must be entered as a positive number'),'error');
  16                 $InputError =1;
  17         }
  18
  19         if ($_POST['QuantityBreak']<=0){
  20                 prnMsg( _('The quantity of all items on an order in the discount category') . ' ' . $_POST['DiscountCategory'] . ' ' . _('at which the discount will apply is 0 or less than 0') . '. ' . _('Positive numbers are expected for this entry'),'warn');
  21                 $InputError =1;
  22         }
  23         if (!is_numeric($_POST['DiscountRate'])){
  24                 prnMsg( _('The discount rate must be entered as a positive number'),'warn');
  25                 $InputError =1;
  26         }
  27         if ($_POST['DiscountRate']<=0 OR $_POST['DiscountRate']>=70){
  28                 prnMsg( _('The discount rate applicable for this record is either less than 0% or greater than 70%') . '. ' . _('Numbers between 1 and 69 are expected'),'warn');
  29                 $InputError =1;
  30         }
  31
  32         /* actions to take once the user has clicked the submit button
  33         ie the page has called itself with some user input */
  34
  35         if ($InputError !=1) {
  36
  37                 $sql = "INSERT INTO discountmatrix (salestype,
  38                                                         discountcategory,
  39                                                         quantitybreak,
  40                                                         discountrate)
  41                                         VALUES('" . $_POST['SalesType'] . "',
  42                                                 '" . $_POST['DiscountCategory'] . "',
  43                                                 " . $_POST['QuantityBreak'] . ",
  44                                                 " . ($_POST['DiscountRate']/100) . ')';
  45
  46                 $result = DB_query($sql,$db);
  47                 prnMsg( _('The discount matrix record has been added'),'success');
  48                 unset($_POST['DiscountCategory']);
  49                 unset($_POST['SalesType']);
  50                 unset($_POST['QuantityBreak']);
  51                 unset($_POST['DiscountRate']);
  52         }
  53 } elseif ($_GET['Delete']=='yes') {
  54 /*the link to delete a selected record was clicked instead of the submit button */
  55
  56         $sql="DELETE FROM discountmatrix
  57                 WHERE discountcategory='" .$_GET['DiscountCategory'] . "'
  58                 AND salestype='" . $_GET['SalesType'] . "'
  59                 AND quantitybreak=" . $_GET['QuantityBreak'];
  60
  61         $result = DB_query($sql,$db);
  62         prnMsg( _('The discount matrix record has been deleted'),'success');
  63 }
  64
  65 $sql = 'SELECT sales_type,
  66                 salestype,
  67                 discountcategory,
  68                 quantitybreak,
  69                 discountrate
  70         FROM discountmatrix INNER JOIN salestypes
  71                 ON discountmatrix.salestype=salestypes.typeabbrev
  72         ORDER BY salestype,
  73                 discountcategory,
  74                 quantitybreak';
  75
  76 $result = DB_query($sql,$db);
  77
  78 echo '<CENTER><table>';
  79 echo "<tr><td class='tableheader'>" . _('Sales Type') . "</td>
  80         <td class='tableheader'>" . _('Discount Category') . "</td>
  81         <td class='tableheader'>" . _('Quantity Break') . "</td>
  82         <td class='tableheader'>" . _('Discount Rate') . ' %' . "</td></TR>";
  83
  84 $k=0; //row colour counter
  85
  86 while ($myrow = DB_fetch_array($result)) {
  87         if ($k==1){
  88                 echo "<tr bgcolor='#CCCCCC'>";
  89                 $k=0;
  90         } else {
  91                 echo "<tr bgcolor='#EEEEEE'>";
  92                 $k=1;
  93         }
  94         $DeleteURL = $_SERVER['PHP_SELF'] . '?' . SID . '&Delete=yes&SalesType=' . $myrow['salestype'] . '&DiscountCategory=' . $myrow['discountcategory'] . '&QuantityBreak=' . $myrow['quantitybreak'];
  95
  96         printf("<td>%s</td>
  97                 <td>%s</td>
  98                 <td>%s</td>
  99                 <td>%s</td>
 100                 <td><a href='%s'>" . _('Delete') . '</td>
 101                 </tr>',
 102                 $myrow['sales_type'],
 103                 $myrow['discountcategory'],
 104                 $myrow['quantitybreak'],
 105                 number_format($myrow['discountrate']*100,2) ,
 106                 $DeleteURL);
 107
 108 }
 109
 110 echo '</TABLE><HR>';
 111
 112 echo "<FORM METHOD='post' action=" . $_SERVER['PHP_SELF'] . '?' . SID . '>';
 113
 114
 115 echo '<TABLE>';
 116
 117 $sql = 'SELECT typeabbrev,
 118                 sales_type
 119         FROM salestypes';
 120
 121 $result = DB_query($sql, $db);
 122
 123 echo '<TR><TD>' . _('Customer Price List') . ' (' . _('Sales Type') . '):</TD><TD>';
 124
 125 echo "<SELECT NAME='SalesType'>";
 126
 127 while ($myrow = DB_fetch_array($result)){
 128         if ($myrow['typeabbrev']==$_POST['SalesType']){
 129                 echo "<OPTION SELECTED VALUE='" . $myrow['typeabbrev'] . "'>" . $myrow['sales_type'];
 130         } else {
 131                 echo "<OPTION VALUE='" . $myrow['typeabbrev'] . "'>" . $myrow['sales_type'];
 132         }
 133 }
 134
 135 echo '</SELECT>';
 136
 137
 138 echo '<TR><TD>' . _('Discount Category Code') . ':</TD><TD>';
 139
 140 echo "<INPUT TYPE='Text' NAME='DiscountCategory' MAXLENGTH=2 SIZE=2 VALUE='" . $_POST['DiscCat'] . "'></TD></TR>";
 141
 142 echo '<TR><TD>' . _('Quantity Break') . ":</TD><TD><input type='Text' name='QuantityBreak' SIZE=10 MAXLENGTH=10></TD></TR>";
 143
 144 echo '<TR><TD>' . _('Discount Rate') . " (%):</TD><TD><input type='Text' name='DiscountRate' SIZE=4 MAXLENGTH=4></TD></TR>";
 145 echo '</TABLE>';
 146
 147 echo "<CENTER><input type='Submit' name='submit' value='" . _('Enter Information') . "'></CENTER>";
 148
 149 echo '</FORM>';
 150
 151 include('includes/footer.inc');
 152 ?>