Care2007/modules/weberp/FreightCosts.php

   1 <?php
   2 /* $Revision: 1.10 $ */
   3
   4 $PageSecurity = 11;
   5 include('includes/session.inc');
   6 $title = _('Freight Costs Set Up');
   7 include('includes/header.inc');
   8
   9 ?>
  10
  11 <?php
  12
  13 if (isset($_GET['LocationFrom'])){
  14         $LocationFrom = $_GET['LocationFrom'];
  15 } elseif (isset($_POST['LocationFrom'])){
  16         $LocationFrom = $_POST['LocationFrom'];
  17 }
  18 if (isset($_GET['ShipperID'])){
  19         $ShipperID = $_GET['ShipperID'];
  20 } elseif (isset($_POST['ShipperID'])){
  21         $ShipperID = $_POST['ShipperID'];
  22 }
  23 if (isset($_GET['SelectedFreightCost'])){
  24         $SelectedFreightCost = $_GET['SelectedFreightCost'];
  25 } elseif (isset($_POST['SelectedFreightCost'])){
  26         $SelectedFreightCost = $_POST['SelectedFreightCost'];
  27 }
  28
  29
  30
  31 if (!isset($LocationFrom) OR !isset($ShipperID)) {
  32
  33         echo "<FORM METHOD='post' action='" . $_SERVER['PHP_SELF'] . '?' . SID . "'>";
  34         $sql = 'SELECT shippername, shipper_id FROM shippers';
  35         $ShipperResults = DB_query($sql,$db);
  36
  37         echo '<CENTER><TABLE BORDER=1>
  38                 <TR>
  39                         <TD>' . _('Select A Freight Company to set up costs for') . "</TD>
  40                         <TD><SELECT name='ShipperID'>";
  41
  42         while ($myrow = DB_fetch_array($ShipperResults)){
  43                 echo '<OPTION VALUE=' . $myrow['shipper_id'] . '>' . $myrow['shippername'];
  44         }
  45         echo '</SELECT></TD></TR>
  46                         <TR>
  47                                 <TD>' . _('Select the warehouse') . ' (' . _('ship from location') . ")</TD>
  48                                 <TD><SELECT name='LocationFrom'>";
  49
  50         $sql = 'SELECT loccode, locationname FROM locations';
  51         $LocationResults = DB_query($sql,$db);
  52
  53         while ($myrow = DB_fetch_array($LocationResults)){
  54                 echo '<OPTION VALUE=' . $myrow['loccode'] . '>' . $myrow['locationname'];
  55         }
  56
  57         echo "</SELECT></TD></TR></TABLE><INPUT TYPE=SUBMIT VALUE='" . _('Accept') . "' NAME='Accept'></FORM>";
  58
  59 } else {
  60
  61         $sql = "SELECT shippername FROM shippers WHERE shipper_id = $ShipperID";
  62         $ShipperResults = DB_query($sql,$db);
  63         $myrow = DB_fetch_row($ShipperResults);
  64         $ShipperName = $myrow[0];
  65         $sql = "SELECT locationname FROM locations WHERE loccode = '$LocationFrom'";
  66         $LocationResults = DB_query($sql,$db);
  67         $myrow = DB_fetch_row($LocationResults);
  68         $LocationName = $myrow[0];
  69         echo '<FONT SIZE=4 COLOR=BLUE>' . _('For Deliveries From') . ' ' . $LocationName . ' ' . _('using') . ' ' . $ShipperName . '</FONT><BR>';
  70
  71 }
  72
  73
  74 if (isset($_POST['submit'])) {
  75
  76         //initialise no input errors assumed initially before we test
  77         $InputError = 0;
  78
  79         //first off validate inputs sensible
  80         if (strlen($_POST['Destination'])<2){
  81                 $InputError=1;
  82                 prnMsg(_('The entry for the destination must be at least two characters long') . '. ' . _('These entries are matched against the town names entered for customer delivery addresses'),'warn');
  83         }
  84
  85
  86         if (trim($_POST['CubRate']) == '' ) {
  87                 $_POST['CubRate'] = 0;
  88         }
  89         if (trim($_POST['KGRate']) == '' ) {
  90                 $_POST['KGRate'] = 0;
  91         }
  92         if (trim($_POST['MAXKGs']) == '' ) {
  93                 $_POST['MAXKGs'] = 0;
  94         }
  95         if (trim($_POST['MAXCub']) == '' ) {
  96                 $_POST['MAXCub'] = 0;
  97         }
  98         if (trim($_POST['FixedPrice']) == '' ){
  99                 $_POST['FixedPrice'] = 0;
 100         }
 101         if (trim($_POST['MinimumChg']) == '' ) {
 102                 $_POST['MinimumChg'] = 0;
 103         }
 104
 105         if (!is_double((double) $_POST['CubRate']) OR !is_double((double) $_POST['KGRate']) OR !is_double((double) $_POST['MAXKGs']) OR !is_double((double) $_POST['MAXCub']) OR !is_double((double) $_POST['FixedPrice']) OR !is_double((double) $_POST['MinimumChg'])) {
 106                 $InputError=1;
 107                 prnMsg(_('The entries for Cubic Rate, KG Rate, Maxmimum Weight, Maximum Volume, Fixed Price and Minimum charge must be numeric'),'warn');
 108         }
 109
 110
 111
 112         if (isset($SelectedFreightCost) AND $InputError !=1) {
 113
 114                 $sql = "UPDATE freightcosts
 115                                 SET
 116                                         locationfrom='$LocationFrom',
 117                                         destination='" . $_POST['Destination'] . "',
 118                                         shipperid=$ShipperID,
 119                                         cubrate=" . $_POST['CubRate'] . ",
 120                                         kgrate = " . $_POST['KGRate'] . ",
 121                                         maxkgs = " . $_POST['MAXKGs'] . ",
 122                                         maxcub= " . $_POST['MAXCub'] . ",
 123                                         fixedprice = " . $_POST['FixedPrice'] . ",
 124                                         minimumchg= " . $_POST['MinimumChg'] . "
 125                         WHERE shipcostfromid=" . $SelectedFreightCost;
 126
 127                 $msg = _('Freight cost record updated');
 128
 129         } elseif ($InputError !=1) {
 130
 131         /*Selected freight cost is null cos no item selected on first time round so must be adding a record must be submitting new entries */
 132
 133                 $sql = "INSERT INTO freightcosts (
 134                                 locationfrom,
 135                                 destination,
 136                                 shipperid,
 137                                 cubrate,
 138                                 kgrate,
 139                                 maxkgs,
 140                                 maxcub,
 141                                 fixedprice,
 142                                 minimumchg)
 143                         VALUES (
 144                                 '$LocationFrom',
 145                                 '" . $_POST['Destination'] . "',
 146                                 $ShipperID,
 147                                 " . $_POST['CubRate'] . ",
 148                                 " . $_POST['KGRate'] . ",
 149                                 " . $_POST['MAXKGs'] . ",
 150                                 " . $_POST['MAXCub'] . ",
 151                                 " . $_POST['FixedPrice'] .",
 152                                 " . $_POST['MinimumChg'] . "
 153                         )";
 154
 155                 $msg = _('Freight cost record inserted');
 156
 157         }
 158         //run the SQL from either of the above possibilites
 159
 160
 161         $ErrMsg = _('The freight cost record could not be updated because');
 162         $result = DB_query($sql,$db,$ErrMsg);
 163
 164         prnMsg($msg,'success');
 165
 166         unset($SelectedFreightCost);
 167         unset($_POST['CubRate']);
 168         unset($_POST['KGRate']);
 169         unset($_POST['MAXKGs']);
 170         unset($_POST['MAXCub']);
 171         unset($_POST['FixedPrice']);
 172         unset($_POST['MinimumChg']);
 173
 174 } elseif (isset($_GET['delete'])) {
 175
 176         $sql = 'DELETE FROM freightcosts WHERE shipcostfromid=' . $SelectedFreightCost;
 177         $result = DB_query($sql,$db);
 178         prnMsg( _('Freight cost record deleted'),'success');
 179         unset ($SelectedFreightCost);
 180         unset($_GET['delete']);
 181 }
 182
 183 if (!isset($SelectedFreightCost) AND isset($LocationFrom) AND isset($ShipperID)){
 184
 185
 186         $sql = "SELECT shipcostfromid,
 187                         destination,
 188                         cubrate,
 189                         kgrate,
 190                         maxkgs,
 191                         maxcub,
 192                         fixedprice,
 193                         minimumchg
 194                 FROM freightcosts
 195                 WHERE freightcosts.locationfrom = '$LocationFrom'
 196                 AND freightcosts.shipperid = $ShipperID
 197                 ORDER BY destination";
 198
 199         $result = DB_query($sql,$db);
 200
 201         echo '<table border=1>';
 202         $TableHeader = "<tr>
 203                                 <td class='tableheader'>" . _('Destination') . "</td>
 204                                 <td class='tableheader'>" . _('Cubic Rate') . "</td>
 205                                 <td class='tableheader'>" . _('KG Rate') . "</td>
 206                                 <td class='tableheader'>" . _('MAX KGs') . "</td>
 207                                 <td class='tableheader'>" . _('MAX Volume') . "</td>
 208                                 <td class='tableheader'>" . _('Fixed Price') . "</td>
 209                                 <td class='tableheader'>" . _('Minimum Charge') . "</td>
 210                         </tr>";
 211
 212         echo $TableHeader;
 213
 214         $k = 0; //row counter to determine background colour
 215         $PageFullCounter=0;
 216
 217         while ($myrow = DB_fetch_row($result)) {
 218                 $PageFullCounter++;
 219                 if ($PageFullCounter==15){
 220                                 $PageFullCounter=0;
 221                                 echo $TableHeader;
 222
 223                 }
 224                 if ($k==1){
 225                         echo "<tr bgcolor='#CCCCCC'>";
 226                         $k=0;
 227                 } else {
 228                         echo "<tr bgcolor='#EEEEEE'>";
 229                         $k++;
 230                 }
 231
 232
 233                 printf("<td>%s</td>
 234                         <td ALIGN=RIGHT>%s</td>
 235                         <td ALIGN=RIGHT>%s</td>
 236                         <td ALIGN=RIGHT>%s</td>
 237                         <td ALIGN=RIGHT>%s</td>
 238                         <td ALIGN=RIGHT>%s</td>
 239                         <td ALIGN=RIGHT>%s</td>
 240                         <td><a href=\"%s&SelectedFreightCost=%s&LocationFrom=%s&ShipperID=%s\">" . _('Edit') . "</td>
 241                         <td><a href=\"%s&SelectedFreightCost=%s&LocationFrom=%s&ShipperID=%s&delete=yes\">" . _('Delete') . "</td></tr>",
 242                         $myrow[1],
 243                         $myrow[2],
 244                         $myrow[3],
 245                         $myrow[4],
 246                         $myrow[5],
 247                         $myrow[6],
 248                         $myrow[7],
 249                         $_SERVER['PHP_SELF'] . '?' . SID,
 250                         $myrow[0],
 251                         $LocationFrom,
 252                         $ShipperID,
 253                         $_SERVER['PHP_SELF'] . '?' . SID,
 254                         $myrow[0],
 255                         $LocationFrom,
 256                         $ShipperID);
 257
 258         }
 259
 260         //END WHILE LIST LOOP
 261         echo '</table>';
 262 }
 263
 264 //end of ifs and buts!
 265
 266 if (isset($SelectedFreightCost)) {
 267         echo "<Center><a href='" . $_SERVER['PHP_SELF'] . "?" . SID . '&LocationFrom=' . $LocationFrom . '&ShipperID=' . $ShipperID . "'>" . _('Show all freight costs for') . ' ' . $ShipperName  . ' ' . _('from') . ' ' . $LocationName . '</a></Center>';
 268 }
 269
 270 if (isset($LocationFrom) AND isset($ShipperID)) {
 271
 272         echo "<FORM METHOD='post' action='" . $_SERVER['PHP_SELF'] . '?' . SID . "'>";
 273
 274         if ($SelectedFreightCost) {
 275                 //editing an existing freight cost item
 276
 277                 $sql = "SELECT locationfrom,
 278                                 destination,
 279                                 shipperid,
 280                                 cubrate,
 281                                 kgrate,
 282                                 maxkgs,
 283                                 maxcub,
 284                                 fixedprice,
 285                                 minimumchg
 286                         FROM freightcosts
 287                         WHERE shipcostfromid=$SelectedFreightCost";
 288
 289                 $result = DB_query($sql, $db);
 290                 $myrow = DB_fetch_array($result);
 291
 292                 $LocationFrom  = $myrow['locationfrom'];
 293                 $_POST['Destination']   = $myrow['destination'];
 294                 $ShipperID  = $myrow['shipperid'];
 295                 $_POST['CubRate']  = $myrow['cubrate'];
 296                 $_POST['KGRate'] = $myrow['kgrate'];
 297                 $_POST['MAXKGs'] = $myrow['maxkgs'];
 298                 $_POST['MAXCub'] = $myrow['maxcub'];
 299                 $_POST['FixedPrice'] = $myrow['fixedprice'];
 300                 $_POST['MinimumChg'] = $myrow['minimumchg'];
 301
 302                 echo "<INPUT TYPE=HIDDEN NAME='SelectedFreightCost' VALUE=$SelectedFreightCost>";
 303
 304         } else {
 305                 $_POST['FixedPrice'] = 0;
 306                 $_POST['MinimumChg'] = 0;
 307
 308         }
 309         echo "<input type=HIDDEN name='LocationFrom' value='$LocationFrom'>";
 310         echo "<input type=HIDDEN name='ShipperID' value=$ShipperID>";
 311
 312
 313         echo '<TABLE>
 314                 <TR><TD>' . _('Destination') . ":</TD>
 315                 <TD><input type='text' maxlength=20 size=20 name='Destination' VALUE='" . $_POST['Destination'] . "'></TD></TR>";
 316         echo '<TR><TD>' . _('Rate per Cubic Metre') . ":</TD>
 317                 <TD><input type='Text' name='CubRate' SIZE=6 MAXLENGTH=5 value=" . $_POST['CubRate'] . "></TD></TR>";
 318         echo '<TR><TD>' . _('Rate Per KG') . ":</TD>
 319                 <TD><input type='Text' name='KGRate' SIZE=6 MAXLENGTH=5 value=" . $_POST['KGRate'] . "></TD></TR>";
 320         echo '<TR><TD>' . _('Maximum Weight Per Package (KGs)') . ":</a></TD>
 321                 <TD><input type='Text' name='MAXKGs' SIZE=8 MAXLENGTH=7 value=" . $_POST['MAXKGs'] . "></TD></TR>";
 322         echo '<TR><TD>' . _('Maximum Volume Per Package (cubic metres)') . ":</a></TD>
 323                 <TD><input type='Text' name='MAXCub' SIZE=8 MAXLENGTH=7 value=" . $_POST['MAXCub'] . "></TD></TR>";
 324         echo '<TR><TD>' . _('Fixed Price (zero if rate per KG or Cubic)') . ":</a></TD>
 325                 <TD><input type='Text' name='FixedPrice' SIZE=6 MAXLENGTH=5 value=" . $_POST['FixedPrice'] . "></TD></TR>";
 326         echo '<TR><TD>' . _('Minimum Charge (0 is N/A)') . ":</a></TD>
 327                 <TD><input type='Text' name='MinimumChg' SIZE=6 MAXLENGTH=5 value=" . $_POST['MinimumChg'] . "></TD></TR>";
 328
 329         echo '</TABLE>';
 330
 331         echo "<CENTER><input type='Submit' name='submit' value='" . _('Enter Information') . "'>";
 332
 333         echo '</FORM>';
 334
 335 } //end if record deleted no point displaying form to add record
 336
 337 include('includes/footer.inc');
 338 ?>