Shipping rate table

[alby]

Hello everyone! I will appreciate any help in regards this form I am working on.

Basically, I need to change the current shipping option to a multiple rate option such as

if customer subtotal sub_tot_amt = 1-50 dollars and choosed regular shipping then charge 6 dollars.
if customer subtotal = 51-100 and and chossed next day then charge 20

I included a copy of the files

Thank you again for all your comments and suggestions in this manner.

[bpat1434]

Your logic answers your question. Just write it out:

IF customer subtotal (sub_tot_amt) between 1 and 50 dollars {

[.....] IF customer chose regular shipping: $6
[.....] IF customer chose next day shipping: $15

}

IF customer subtotal is between 51 and 100 dollars {

[.....] IF customer chose regular shipping: $8
[.....] IF customer chose next day shipping: $20

}

If you write it like that, then all you have to do is translate it to PHP language:

<?php

if( ($sub_tot_amt >= 1) && ($sub_tot_amt <=50) )
{
    switch($shipping)
    {
        case 'standard':
            $ship_amt = '6';
            break;
        case 'one_day':
            $ship_amt = '15';
            break;
    }
}
if( ($sub_tot_amt >= 51) && ($sub_tot_amt <=100) )
{
    switch($shipping)
    {
        case 'standard':
            $ship_amt = '8';
            break;
        case 'one_day':
            $ship_amt = '20';
            break;
    }
}

?>

~Brett

[alby]

thank you bpat1434 for helping me out with this one.

However I have tried a couple things but for some reason I don't still quite know what I am doing.

---include.php
As you notice I am using function doTotals(form) to add all the values but the function still thinks there only 1 value assign to $ship_options = array.

So I modify it and type all the values for the rates I need to have as:

$ship_options = array (
  array ("UPS Ground", 6,10,14,17,19,21,23,27),
  array ("2 Day", 9,14,18,21,23,25,27,31),
  array ("Next Day", 12,20,28,34,38,42,46,54)
);

So how can I incorporate the values of this array later on function doTotals(form)
I currently did the following changes

function doTotals(form) { 

var sub_tot_amt=0, tax_amt=0, g_tot_amt=0, admin_amt=0, tax_amt2=0, ship_amt=0;
	for (var i=0; i < <?php echo $num_products ?>; i++) {
		var cur_field = form[ products[i] + "_qty" ]; 
		if ( !isPosInt(form, cur_field, cur_field.value) ) return; 
		else sub_tot_amt += parseFloat(cur_field.value) * parseFloat( form[ products[i] + "_price" ].value );
}
	form.sub_tot.value = formatDecimal(sub_tot_amt, 2);
	if ( form.sales_tax && form.sales_tax.checked ) {
		tax_amt = <?php echo isset($cur_sales_tax)? $cur_sales_tax: 0 ?> * form.grand_tot.value;
		form.tax_amt.value = formatDecimal(tax_amt);
}
    form.sub_tot.value = formatDecimal(sub_tot_amt, 2);
	if ( form.sales_tax2 && form.sales_tax2.checked ) {
		tax_amt2 = <?php echo isset($cur_sales_tax2)? $cur_sales_tax2: 0 ?> * form.grand_tot.value;
		form.tax_amt2.value = formatDecimal(tax_amt2);
}

	if( ($sub_tot_amt >= 1) && ($sub_tot_amt <=50) ) 
		{ 
	switch($shipping) 
		{ 
    case 'Ups Ground': 
        $ship_amt = '6'; 
        break; 
    case '2 Day': 
        $ship_amt = '15'; 
        break; 
    case 'Next Day': 
        $ship_amt = '20'; 
        break; 
		} 
} 

	if( ($sub_tot_amt >= 51) && ($sub_tot_amt <=100) ) 
		{ 
	switch($shipping) 
		{ 
    case 'Ups Ground': 
        $ship_amt = '8'; 
        break; 
    case '2 Day': 
        $ship_amt = '20'; 
        break; 
	case 'Next Day': 
        $ship_amt = '15'; 
        break; 

		} 
} 

	if (sub_tot_amt==0) g_tot_amt=0;
	else g_tot_amt = sub_tot_amt + admin_amt +
  <?php echo ( isset($ship_options) && !empty($ship_options) )? 'parseFloat(form.ship_amt.value)': 0 ?>;
	form.grand_tot.value = formatDecimal(g_tot_amt);

	if (sub_tot_amt==0) g_tot_amt=0;
	else g_tot_amt = tax_amt + g_tot_amt +
  <?php echo ( isset($admin_options) && !empty($admin_options) )? 'parseFloat(form.admin_amt.value)': 0 ?>;
	form.grand_tot.value = formatDecimal(g_tot_amt);

	if (sub_tot_amt==0) g_tot_amt=0;
	else g_tot_amt = admin_amt + g_tot_amt + 
  <?php echo ( isset($corp_options) && !empty($corp_options) )? 'parseFloat(form.corp_amt.value)': 0 ?>;
	form.grand_tot.value = formatDecimal(g_tot_amt);

}

thank you again for any guidance you can provide on this manner

[bpat1434]

So what do the values correspond to? What is "USPS Ground 6, 10, 14, ..." referring to? Number of miles, amount? Assuming you are doing something like this:

Shipment Method |  1 - 50  |  51 - 100  |  101 - 150  |  etc....
USPS Ground        |     6      |      10       |       14
Second Day          |     9      |       14      |        18
Next Day              |     12    |       20       |       28

Then this is probably how you should structure your arrays:

<?php
$multiarray = array("USPS Ground" => array('6', '10', '14', '17', '19', '21', '23', '27'),
					"Second Day" => array('9', '14', '18', '21', '23', '25', '27', '31'),
					"Next Day" => array('12', '20', '28', '34', '38', '42', '46', '54'));

Then, once you've done that, and they're sending the "shipping method" via a POST variable (I assume) you can do the following:

$meth = $_POST['method'];
$tot = ; // Do whatever totaling stuff you need here

function get_rate($tot)
{
   	switch($tot)
	{
		case $tot>=1 && $tot<=50:
			$rate = 0;
			break;

	case $tot>=51 && $tot<=100:
		$rate = 1;
		break;

	case $tot>=101 && $tot<=151;
		$rate = 2;
		break;

	case $tot>=151 && $tot<=200;
		$rate = 2;
		break;

	case $tot>=201 && $tot<=250:
		$rate = 3;
		break;

	case $tot>=251 && $tot<=300:
		$rate = 4;
		break;

	case $tot>=301 && $tot<=350:
		$rate = 5;
		break;

	case $tot>=351 && $tot<=400:
		$rate = 6;
		break;

	case $tot>=401 && $tot<=450:
		$rate = 7;
		break;
}
return $rate;
}

$shipping = $multiarray[$meth][get_rate($tot)];
?>

I hope that helps. For a working example, here is what I used to test:

<?php

$multiarray = array("USPS Ground" => array('6', '10', '14', '17', '19', '21', '23', '27'),
					"Second Day" => array('9', '14', '18', '21', '23', '25', '27', '31'),
					"Next Day" => array('12', '20', '28', '34', '38', '42', '46', '54'));

function get_rate($tot)
{
   	switch($tot)
	{
		case $tot>=1 && $tot<=50:
			$rate = 0;
			break;

	case $tot>=51 && $tot<=100:
		$rate = 1;
		break;

	case $tot>=101 && $tot<=151;
		$rate = 2;
		break;

	case $tot>=151 && $tot<=200;
		$rate = 2;
		break;

	case $tot>=201 && $tot<=250:
		$rate = 3;
		break;

	case $tot>=251 && $tot<=300:
		$rate = 4;
		break;

	case $tot>=301 && $tot<=350:
		$rate = 5;
		break;

	case $tot>=351 && $tot<=400:
		$rate = 6;
		break;

	case $tot>=401 && $tot<=450:
		$rate = 7;
		break;
}
return $rate;
}

$tot = '75';
$method = 'Second Day';

echo 'Rate for $'.$tot.'.00 is:<br>
USPS Ground: $'.$multiarray['USPS Ground'][get_rate($tot)].'<br>
Second Day: $'.$multiarray['Second Day'][get_rate($tot)].'<br>
Next Day: $'.$multiarray['Next Day'][get_rate($tot)];

?>

I hope this helps you.

~Brett