Delivery cost depending on categories

<?php $session =& JFactory::getSession(); $session_id=$session->getID(); ?> <?php $link = mysql_connect("localhost", "user", "pass") or die("Could not connect : " . mysql_error()); mysql_query ("SET CHARACTER SET 'utf8'", $link); mysql_select_db("db_name") or die("Could not select database"); $query = 'SELECT DISTINCT hje52_hikashop_category.category_name, hje52_hikashop_category.min_sum, hje52_hikashop_category.price_delivery FROM hje52_hikashop_product, ((hje52_hikashop_cart INNER JOIN hje52_hikashop_cart_product ON hje52_hikashop_cart.cart_id = hje52_hikashop_cart_product.cart_id) INNER JOIN hje52_hikashop_product_category ON hje52_hikashop_cart_product.product_id = hje52_hikashop_product_category.product_id) INNER JOIN hje52_hikashop_category ON hje52_hikashop_product_category.category_id = hje52_hikashop_category.category_id WHERE (((hje52_hikashop_cart.session_id)="'.$session_id.'"));'; $query2 = 'SELECT Sum(hje52_hikashop_cart_product.cart_product_quantity*hje52_hikashop_price.price_value) AS PRZ, hje52_hikashop_category.min_sum FROM hje52_hikashop_cart INNER JOIN (((hje52_hikashop_cart_product INNER JOIN hje52_hikashop_price ON hje52_hikashop_cart_product.product_id = hje52_hikashop_price.price_product_id) INNER JOIN hje52_hikashop_product_category ON hje52_hikashop_cart_product.product_id = hje52_hikashop_product_category.product_id) INNER JOIN hje52_hikashop_category ON hje52_hikashop_product_category.category_id = hje52_hikashop_category.category_id) ON hje52_hikashop_cart.cart_id = hje52_hikashop_cart_product.cart_id WHERE (((hje52_hikashop_cart.session_id)="'.$session_id.'")) GROUP BY hje52_hikashop_category.category_id, hje52_hikashop_category.min_sum; '; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $result2 = mysql_query($query2) or die("Query failed : " . mysql_error()); ?> <?php while ($row = mysql_fetch_array($result2, MYSQL_ASSOC)) { if ($row['min_sum'] > $row['PRZ']) { echo "<div class=\"error_sum\">The total of your order is too low for all the possible shipping methods.</div>"; } } ?> <?php $col2_sum = 0; print "<table class=\"chekout_price_table_th\">\n"; print "<tr><th></th><th>Minimum amount</th><th>Delivery cost</th></tr>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { $col2_sum += $line['price_delivery']; print "\t<tr>\n"; foreach ($line as $col_value) { print "\t\t<td class=\"chekout_price_table\">$col_value</td>\n"; } print "\t</tr>\n"; } print "</table>\n"; mysql_free_result($result); mysql_free_result($result2); mysql_close($link); ?>

<td class="hikashop_cart_total_value"> <span class="hikashop_checkout_cart_final_total"> <?php echo $this->currencyHelper->format($this->full_total->prices[0]->price_value_with_tax+$col2_sum,$this->full_total->prices[0]->price_currency_id); ?> </span> </td>

foreach($dbrates as $k => $rate){ if($rate->shipping_type=='manual' && !empty($rate->shipping_published)){ $rates[]=$rate;

$rates[0]->shipping_price=$col2_sum;

foreach($dbrates as $k => $rate){ if($rate->shipping_type=='manual' && !empty($rate->shipping_published)){ $rates[]=$rate; $rates[0]->shipping_price=$col2_sum; } }

function onShippingDisplay(&$order, &$dbrates, &$usable_rates, &$messages) { /* START Harry Delivery*/ $session =& JFactory::getSession(); $session_id=$session->getID(); $link = mysql_connect("localhost", "*user*", "*pass*") or die("Could not connect : " . mysql_error()); mysql_query ("SET CHARACTER SET 'utf8'", $link); mysql_select_db("*BD*") or die("Could not select database"); $query = 'SELECT DISTINCT jqp92_hikashop_category.category_name, jqp92_hikashop_category.min_sum, jqp92_hikashop_category.price_delivery FROM jqp92_hikashop_product, ((jqp92_hikashop_cart INNER JOIN jqp92_hikashop_cart_product ON jqp92_hikashop_cart.cart_id = jqp92_hikashop_cart_product.cart_id) INNER JOIN jqp92_hikashop_product_category ON jqp92_hikashop_cart_product.product_id = jqp92_hikashop_product_category.product_id) INNER JOIN jqp92_hikashop_category ON jqp92_hikashop_product_category.category_id = jqp92_hikashop_category.category_id WHERE (((jqp92_hikashop_cart.session_id)="'.$session_id.'"));'; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $col2_sum = 0; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {$col2_sum += $line['price_delivery'];} mysql_free_result($result); mysql_close($link); /* END Harry Delivery*/ $config =& hikashop_config();

foreach($dbrates as $k => $rate) { if($rate->shipping_type == $this->name && !empty($rate->shipping_published)) { $rates[] = $rate; $rates[0]->shipping_price=$col2_sum; } }

$rate->shipping_price=$col2_sum;

$rate->shipping_price+=$col2_sum;

stdClass Object ( [shipping_id] => 1 [shipping_type] => manual [shipping_zone_namekey] => [shipping_tax_id] => 0 [shipping_price] => 0.00000 [shipping_currency_id] => 81 [shipping_name] => Курьерская доставка [shipping_description] => [shipping_published] => 1 [shipping_ordering] => 3 [shipping_params] => stdClass Object ( [shipping_percentage] => 0 [shipping_per_product] => 0 [shipping_price_per_product] => [shipping_min_price] => [shipping_max_price] => [shipping_price_use_tax] => 1 [shipping_virtual_included] => 1 [shipping_override_address] => 0 [shipping_override_address_text] => [shipping_min_weight] => [shipping_max_weight] => [shipping_weight_unit] => kg [shipping_zip_prefix] => [shipping_min_zip] => [shipping_max_zip] => [shipping_zip_suffix] => [shipping_min_volume] => [shipping_max_volume] => [shipping_size_unit] => m ) [shipping_images] => [shipping_access] => all [shippingkey] => 0,1 [shipping_warehouse_id] => 0 [shipping_price_with_tax] => 0.00000 [shipping_price_orig_with_tax] => )