Jump to content



Photo
- - - - -

recycle table.php in dhl.php


  • Please log in to reply
No replies to this topic

#1   luigicosta

luigicosta
  • Members
  • 97 posts
  • Real Name:luigi costa

Posted 17 July 2012 - 15:12

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;
    }
  }
?>