Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help with duplicating the table rate module


Guest

Recommended Posts

I modified the table rates successfully. I am trying to duplicate the entire module to show a different set of rates at a different time of the year. I want the ability to turn it off manually when the season changes. I copied table.php and saved it as table2.php. I changed all references to 'table' to 'table2' in the table2.php and uploaded it to my server.

 

It shows correctly in the admin panel but the tircky thing is whatever I do to one of the two mentioned shipping methods affects the other one. eg. when I set one to false it does the same to the other one. They both appear to be reading from the same source. How files do I have to modify to solve the problem?

 

I have posted the code I duplicated below....I need help badly!

 

Thanks ;)

 

<?php

/*

$Id: table.php,v 1.27 2003/02/05 22:41:52 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

class table {

var $code, $title, $description, $icon, $enabled;

 

// class constructor

function table() {

global $order;

 

$this->code = 'table';

$this->title = MODULE_SHIPPING_TABLE_TEXT_TITLE;

$this->description = MODULE_SHIPPING_TABLE_TEXT_DESCRIPTION;

$this->sort_order = MODULE_SHIPPING_TABLE_SORT_ORDER;

$this->icon = DIR_WS_ICONS . 'shipping_ups.gif';

//$this->icon = '';

$this->tax_class = MODULE_SHIPPING_TABLE_TAX_CLASS;

$this->enabled = ((MODULE_SHIPPING_TABLE_STATUS == 'True') ? true : false);

 

if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_TABLE_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_TABLE_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, $cart, $shipping_weight, $shipping_num_boxes;

 

if (MODULE_SHIPPING_TABLE_MODE == 'price') {

$order_total = $cart->show_total();

} else {

$order_total = $shipping_weight;

}

 

// jgp - when processing the shipping option, check the method and use the appropriate cost table

if ($method) {

 

// jgp - shipping is free if the order total is 0 (optional)

if ($order_total != 0)

$table_cost = split("[:,]" , MODULE_SHIPPING_TABLE_COST);

else

$table_cost=0;

 

$table_cost_2day = split("[:,]" , MODULE_SHIPPING_TABLE_COST_2DAY);

$table_cost_nextday = split("[:,]" , MODULE_SHIPPING_TABLE_COST_NEXTDAY);

 

if ($method == 'table2day'){

 

$size = sizeof($table_cost_2day);

for ($i=0, $n=$size; $i<$n; $i+=2) {

if ($order_total <= $table_cost_2day[$i]) {

$shipping = $table_cost_2day[$i+1];

break;

}

}

 

if (MODULE_SHIPPING_TABLE_MODE == 'weight') {

$shipping = $shipping * $shipping_num_boxes;

}

 

$this->quotes = array('id' => $this->code,

'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE,

'methods' => array(array('id' => 'table2day',

'title' => MODULE_SHIPPING_TABLE_TEXT_WAY_2DAY,

'cost' => $shipping + MODULE_SHIPPING_TABLE_HANDLING)));

}

 

elseif ($method == 'tablenextday'){

 

$size = sizeof($table_cost_nextday);

for ($i=0, $n=$size; $i<$n; $i+=2) {

if ($order_total <= $table_cost_nextday[$i]) {

$shipping = $table_cost_nextday[$i+1];

break;

}

}

 

if (MODULE_SHIPPING_TABLE_MODE == 'weight') {

$shipping = $shipping * $shipping_num_boxes;

}

 

$this->quotes = array('id' => $this->code,

'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE,

'methods' => array(array('id' => 'tablenextday',

'title' => MODULE_SHIPPING_TABLE_TEXT_WAY_NEXTDAY,

'cost' => $shipping + MODULE_SHIPPING_TABLE_HANDLING)));

}

else

{

 

$size = sizeof($table_cost);

for ($i=0, $n=$size; $i<$n; $i+=2) {

if ($order_total <= $table_cost[$i]) {

$shipping = $table_cost[$i+1];

break;

}

}

 

if (MODULE_SHIPPING_TABLE_MODE == 'weight') {

$shipping = $shipping * $shipping_num_boxes;

}

 

$this->quotes = array('id' => $this->code,

'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE,

'methods' => array(array('id' => $this->code,

'title' => MODULE_SHIPPING_TABLE_TEXT_WAY,

'cost' => $shipping + MODULE_SHIPPING_TABLE_HANDLING)));

}

} else {

 

// jgp - added 2-day shipping cost

 

if ($order_total != 0)

$table_cost = split("[:,]" , MODULE_SHIPPING_TABLE_COST);

else

$table_cost=0;

 

// jgp - added 2-day shipping cost

 

$table_cost_2day = split("[:,]" , MODULE_SHIPPING_TABLE_COST_2DAY);

$table_cost_nextday = split("[:,]" , MODULE_SHIPPING_TABLE_COST_NEXTDAY);

 

 

$size = sizeof($table_cost);

for ($i=0, $n=$size; $i<$n; $i+=2) {

if ($order_total <= $table_cost[$i]) {

$shipping = $table_cost[$i+1];

break;

}

}

 

if (MODULE_SHIPPING_TABLE_MODE == 'weight') {

$shipping = $shipping * $shipping_num_boxes;

}

 

 

// jgp - duplicated the shipping cost application for 2-day shipping

 

$size = sizeof($table_cost_2day);

for ($j=0, $n=$size; $j<$n; $j+=2) {

if ($order_total <= $table_cost_2day[$j]) {

$shipping_2day = $table_cost_2day[$j+1];

break;

}

}

 

 

$size = sizeof($table_cost_nextday);

for ($l=0, $n=$size; $l<$n; $l+=2) {

if ($order_total <= $table_cost_nextday[$l]) {

$shipping_nextday = $table_cost_nextday[$l+1];

break;

}

}

 

if (MODULE_SHIPPING_TABLE_MODE == 'weight') {

$shipping_2day = $shipping_2day * $shipping_num_boxes;

 

$shipping_nextday = $shipping_nextday * $shipping_num_boxes;

 

 

}

 

// jgp - added 2day shipping to methods array

 

$this->quotes = array('id' => $this->code,

'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE,

'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_TABLE_TEXT_WAY, 'cost' => $shipping + MODULE_SHIPPING_TABLE_HANDLING),

 

array('id' => 'table2day', 'title' => MODULE_SHIPPING_TABLE_TEXT_WAY_2DAY, 'cost' => $shipping_2day + MODULE_SHIPPING_TABLE_HANDLING),

array('id' => 'tablenextday', 'title' => MODULE_SHIPPING_TABLE_TEXT_WAY_NEXTDAY, 'cost' => $shipping_nextday + MODULE_SHIPPING_TABLE_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_TABLE_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_TABLE_STATUS', 'True', 'Do you want to offer table 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_TABLE_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())");

// jgp - added additional (2day) shipping type

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 2-Day', 'MODULE_SHIPPING_TABLE_COST_2DAY', '25:8.50,50:5.50,10000:0.00', '', '6', '0', 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 3-Day', 'MODULE_SHIPPING_TABLE_COST_3DAY', '25:8.50,50:5.50,10000:0.00', '', '6', '0', 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 Next-Day', 'MODULE_SHIPPING_TABLE_COST_NEXTDAY', '25:8.50,50:5.50,10000:0.00', '', '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_TABLE_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_TABLE_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_TABLE_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_TABLE_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_TABLE_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() {

// jgp - added 2day shipping key

return array('MODULE_SHIPPING_TABLE_STATUS', 'MODULE_SHIPPING_TABLE_COST', 'MODULE_SHIPPING_TABLE_COST_2DAY', 'MODULE_SHIPPING_TABLE_COST_3DAY', 'MODULE_SHIPPING_TABLE_COST_NEXTDAY', 'MODULE_SHIPPING_TABLE_MODE', 'MODULE_SHIPPING_TABLE_HANDLING', 'MODULE_SHIPPING_TABLE_TAX_CLASS', 'MODULE_SHIPPING_TABLE_ZONE', 'MODULE_SHIPPING_TABLE_SORT_ORDER');

}

}

?>

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...