php weight calculation

desmond_ckl

Hi there, i follow a tutorial from www.phpwebcommerce.com and i'm trying to customize the shipping cost based on product weight instead of flat rate. This tutorial original setting for shipping cost is in checkout-function.php , which i just set a value to define the flat rate shipping. And the miniCart.php file is showing all the calculation. I'm trying to customize the code by doing this:
In my database, table product...i add a new field call pd_weight and insert weight for the product then
common.php i add a new function "CalculateShippingCost()" . In checkout-function.php i modified "function getOrderAmount($orderId)" & i guess in miniCart.php i need to remove "$shopConfig" and replace some coding but im really confuse. I'm not sure all the coding i customize is it correct. Please help me....any help will very appreciate! thanks a million.

dalecosp

I would prototype your CalculateShippingCost function like this:

function CalculateShippingCost($weight,$destination) {

// all your conditions here

if($weightTotal ==2 & country == "EastMalysia") {
                        $conclusion = 14;//your shipping Price
}

// return your $conclusion variable

return $conclusion;

} 

// then, assuming you have a variable for "shipping location", you can put this in minicart.php:

<tr><td align="right"  class="black_txt_2">Shipping</td>
  <td width="27&#37;" align="right" class="black_txt_2"><?php echo displayAmount(CalculateShippingCost($pd_weight,$location_variable)); ?></td>
 </tr>

HTH,

desmond_ckl

Hi dalecosp....Thank you so much for helping 🙂

so in my common.php i follow what u said:

common.php

function CalculateShippingCost($weight,$destination) 
{
// all your conditions here......
// get current configuration
	$sql = "SELECT pd_weight
			FROM tbl_product
		   ";

$result = dbQuery($sql);
$row    = dbFetchAssoc($result);

if ($row) {
    extract($row);



$weightTotal = $pd_weight * $od_qty;


 if($weightTotal == 0.5 & country == "WestMalysia") ///500gram or 0.5kg
                {
                        $conclusion = 6;//your shipping Price
                }

			 else if($weightTotal == 1 & country == "WestMalysia")
            {
                    $conclusion = 8;//your shipping Price
            }

			else if($weightTotal == 1.5 & country == "WestMalysia")
            {
                    $conclusion = 11;//your shipping Price
            } 

			 else if($weightTotal == 2 & country == "WestMalysia")
            {
                    $conclusion = 13;//your shipping Price
            }

			/////////////////////EAST Malaysia ///////////////////////////////

			else if($weightTotal == 0.5 & country == "EastMalysia")
            {
                    $conclusion = 9;//your shipping Price
            }

			else if($weightTotal == 1 & country == "EastMalysia")
            {
                    $conclusion = 14;//your shipping Price
            }

			else if($weightTotal == 1.5 & country == "EastMalysia")
            {
                    $conclusion = 19;//your shipping Price
            }

			else if($weightTotal ==2 & country == "EastMalysia")
            {
                    $conclusion = 14;//your shipping Price
            }


			return $weightTotal;


}

Then in minicart.php


<?php
if (!defined('WEB_ROOT')) {
	exit;
}

$cartContent = getCartContent();

$numItem = count($cartContent);	
?>
<table width="180" border="0" cellspacing="0" cellpadding="4" id="minicart" >

 <?php
if ($numItem > 0) {
?>
 <tr>
  <td colspan="2" class="black_txt_2">Cart Content</td>
 </tr>
<?php
	$subTotal = 0;
	for ($i = 0; $i < $numItem; $i++) {
		extract($cartContent[$i]);
		$pd_name = "$ct_qty x $pd_name";
		$url = "index.php?c=$cat_id&p=$pd_id";

	$subTotal += $pd_price * $ct_qty;  /// $weightTotal ??
?>
 <tr>
   <td width="73%" ><a href="<?php echo $url; ?>"><span class="green_txt_2"><?php echo $pd_name; ?></span></a></td>

  <td width="27%" align="right" class="black_txt_2"><?php echo displayAmount($ct_qty * $pd_price); ?></td>
 </tr>
<?php
	} // end while
?>
  <tr><td align="right" class="black_txt_2">Sub-total</td>
  <td width="27%" align="right" class="black_txt_2"><?php echo displayAmount($subTotal); ?></td>
 </tr>
  <tr><td align="right"  class="black_txt_2">Shipping</td>
  <td width="27%" align="right" class="black_txt_2"><?php echo displayAmount(CalculateShippingCost($pd_weight,$location_variable)); ?></td>
 </tr>
  <tr><td align="right" class="black_txt_2"><strong>Total</strong></td>
  <td width="27%" align="right" class="black_txt_2"><strong><?php echo displayAmount($subTotal + $shopConfig['shippingCost']); ?></strong></td>
 </tr>
  <tr><td colspan="2">&nbsp;</td></tr>
  <tr>
  <td colspan="2" align="center" class="black_txt_2"><a href="cart.php?action=view"> <img src="images/btn_proceedtocheckout.gif" ></a></td>
 </tr>  

<?php	
} else {
?>
  <tr><td colspan="2" align="center" valign="middle" class="black_txt_2">Shopping Cart Is Empty</td></tr>
<?php
}
?> 
</table>
<!------------------->

after i upload the comon.php to server and run, it show:
Parse error: syntax error, unexpected $end
but if i remove "function CalculateShippingCost" in comon.php... it loads the page but minicart show error 😕

Derokorian

In the definition of the function you have:

    if ($row) { 
        extract($row);

However you never close this brace (or you do close it, but you never close the function brace... however you want to look at it)

Derokorian

Also on a side note, why do you have a second argument in the function called destination but you never use that variable within the function?

desmond_ckl

:p i make stupid mistake....you are right 😃 i never close the function brace.
The common.php is working now.

im sorry..im really noob and stupid in this.
now in my minicart.php: it show
Undefined variable: pd_weight &
Undefined variable: location_variable

so i need to declare a pd_weight & location variable in minicart.php or common.php by doing this ? :

<?php
$sql = "SELECT pd_weight
			FROM tbl_product
		   ";
?>

desmond_ckl

now in my minicart.php: it show
Undefined variable: pd_weight &
Undefined variable: weightTotal

so i need to declare a pd_weight & location variable in minicart.php or common.php by doing this ? :

<?php
$weight ="pd_weight";  

$sql = "SELECT pd_weight, od_qty
			FROM tbl_product, tbl_order_item
			WHERE pd_qty = od_qty ";

?>

[/QUOTE]

Emma

No, it means somewhere in minicart.php you have $pd_weight and $weightTotal but you haven't defined what they are. Before you use them set a value, an empty string for example, which can then be over-written.