Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

recycle table.php in dhl.php


luigicosta

Recommended Posts

Hello everyone, I'm trying to create me a very simple contribution for shipping through DHL using an existing module that is called table.php

But I can not make it work.

any ideas or comments are always welcome

thanks

 

<?php
/*
 $Id$
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
 Copyright (c) 2008 osCommerce
 Released under the GNU General Public License
*/
 class dhl {
   var $code, $title, $description, $icon, $enabled;
// class constructor
   function dhl() {
  global $order;
  $this->code = 'dhl';
  $this->title = MODULE_SHIPPING_DHL_TEXT_TITLE;
  $this->description = MODULE_SHIPPING_DHL_TEXT_DESCRIPTION;
  $this->sort_order = MODULE_SHIPPING_DHL_SORT_ORDER;
  $this->icon = '';
  $this->tax_class = MODULE_SHIPPING_DHL_TAX_CLASS;
  $this->enabled = ((MODULE_SHIPPING_DHL_STATUS == 'True') ? true : false);
  if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_DHL_ZONE > 0) ) {
    $check_flag = false;
    $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_DHL_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id");
    while ($check = tep_db_fetch_array($check_query)) {
	  if ($check['zone_id'] < 1) {
	    $check_flag = true;
	    break;
	  } elseif ($check['zone_id'] == $order->delivery['zone_id']) {
	    $check_flag = true;
	    break;
	  }
    }
    if ($check_flag == false) {
	  $this->enabled = false;
    }
  }
   }
// class methods
   function quote($method = '') {
  global $order, $shipping_weight, $shipping_num_boxes;
  if (MODULE_SHIPPING_DHL_MODE == 'price') {
    $order_total = $this->getShippableTotal();
  } else {
    $order_total = $shipping_weight;
  }
  $dhl_cost = preg_split("/[:,]/" , MODULE_SHIPPING_DHL_COST);
  $size = sizeof($dhl_cost);
  for ($i=0, $n=$size; $i<$n; $i+=2) {
    if ($order_total <= $dhl_cost[$i]) {
	  $shipping = $dhl_cost[$i+1];
	  break;
    }
  }
  if (MODULE_SHIPPING_DHL_MODE == 'weight') {
    $shipping = $shipping * $shipping_num_boxes;
  }
  $this->quotes = array('id' => $this->code,
					    'module' => MODULE_SHIPPING_DHL_TEXT_TITLE,
					    'methods' => array(array('id' => $this->code,
												 'title' => MODULE_SHIPPING_DHL_TEXT_WAY,
												 'cost' => $shipping + MODULE_SHIPPING_DHL_HANDLING)));
  if ($this->tax_class > 0) {
    $this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
  }
  if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title);
  return $this->quotes;
   }
   function check() {
  if (!isset($this->_check)) {
    $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_DHL_STATUS'");
    $this->_check = tep_db_num_rows($check_query);
  }
  return $this->_check;
   }
   function install() {
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Table Method', 'MODULE_SHIPPING_DHL_STATUS', 'True', 'Do you want to offer dhl rate shipping?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Shipping Table', 'MODULE_SHIPPING_DHL_COST', '25:8.50,50:5.50,10000:0.00', 'The shipping cost is based on the total cost or weight of items. Example: 25:8.50,50:5.50,etc.. Up to 25 charge 8.50, from there to 50 charge 5.50, etc', '6', '0', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Table Method', 'MODULE_SHIPPING_DHL_MODE', 'weight', 'The shipping cost is based on the order total or the total weight of the items ordered.', '6', '0', 'tep_cfg_select_option(array(\'weight\', \'price\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee', 'MODULE_SHIPPING_DHL_HANDLING', '0', 'Handling fee for this shipping method.', '6', '0', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_DHL_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Shipping Zone', 'MODULE_SHIPPING_DHL_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_DHL_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())");
   }
   function remove() {
  tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
   }
   function keys() {
  return array('MODULE_SHIPPING_DHL_STATUS', 'MODULE_SHIPPING_DHL_COST', 'MODULE_SHIPPING_DHL_MODE', 'MODULE_SHIPPING_DHL_HANDLING', 'MODULE_SHIPPING_DHL_TAX_CLASS', 'MODULE_SHIPPING_DHL_ZONE', 'MODULE_SHIPPING_DHL_SORT_ORDER');
   }
   function getShippableTotal() {
  global $order, $cart, $currencies;
  $order_total = $cart->show_total();
  if ($order->content_type == 'mixed') {
    $order_total = 0;
    for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
	  $order_total += $currencies->calculate_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']);
	  if (isset($order->products[$i]['attributes'])) {
	    reset($order->products[$i]['attributes']);
	    while (list($option, $value) = each($order->products[$i]['attributes'])) {
		  $virtual_check_query = tep_db_query("select count(*) as total from " . DHL_TABLE_PRODUCTS_ATTRIBUTES . " pa, " . DHL_TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad where pa.products_id = '" . (int)$order->products[$i]['id'] . "' and pa.options_values_id = '" . (int)$value['value_id'] . "' and pa.products_attributes_id = pad.products_attributes_id");
		  $virtual_check = tep_db_fetch_array($virtual_check_query);
		  if ($virtual_check['total'] > 0) {
		    $order_total -= $currencies->calculate_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']);
		  }
	    }
	  }
    }
  }
  return $order_total;
   }
 }
?>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...