Shipping insurance with collection

[Peper]

Anyone can help with following?

 

My store gives like 5 shipping options to customers, 2 of them may have insurance option when sending through post service

How can I have the shop automatically disable the insurance option once a customer selected eg. store pickup or use own courier when getting to checkout_confirmation.php - only totaling products and so on

 

Any suggestions please

[satish]

If your insurance module is an order total module.

It will have a disable enable code part in its code.

 

 

Here you can check which shipping has been selected.

Depending on shipping selected you can apply an additional if condition and disable this module.

 

Satish

[Peper]

Thanks Satish

 

I went through some of the shipping codes, order totals and modules, but found none

 

Addon used was Shipping insurance 1.0 http://addons.oscommerce.com/info/1069/v,22

This addon is used with Store pickup and Customer collect - must be disabled once these two when selected.

 

Seems we have to put in something for the following?

ot_insurance.php code

<?php
/*
 Shipping Insurance Module
 ot_insurance.php, v 1.0 2003/12/03
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
*/

 class ot_insurance {
   var $title, $output;

   function ot_insurance() {
     $this->code = 'ot_insurance';
     $this->title = MODULE_ORDER_TOTAL_INSURANCE_TITLE;
     $this->description = MODULE_ORDER_TOTAL_INSURANCE_DESCRIPTION;
     $this->enabled = MODULE_ORDER_TOTAL_INSURANCE_STATUS;
     $this->sort_order = MODULE_ORDER_TOTAL_INSURANCE_SORT_ORDER;

     $this->output = array();
   }

   function process() {
     global $order, $currencies;

		$choose_insurance = $_SESSION['choose_insurance'];

 	  if (MODULE_ORDER_TOTAL_INSURANCE_STATUS == 'true') {
 	    switch (MODULE_ORDER_TOTAL_INSURANCE_DESTINATION) {
 	      case 'national':
 	        if ($order->delivery['country_id'] == STORE_COUNTRY) $pass = true; break;
 	      case 'international':
 	        if ($order->delivery['country_id'] != STORE_COUNTRY) $pass = true; break;
 	      case 'both':
 	        $pass = true; break;
 	      default:
 	        $pass = false; break;
 	    }
 	  }
		if(($choose_insurance != '1') && (MODULE_ORDER_TOTAL_INSURANCE_USE == 'true')){
			$pass = false;
     }
		// Added in by Juan Velez to stop any negative amount
		// Changed so insurance would ba calulated off of subtotal + shipping cost since total could have discounts applied and we still want the hhighest insurance charge possible.
		//original - if ($order->info['total'] < MODULE_ORDER_TOTAL_INSURANCE_OVER) {
		if (($order->info['subtotal'] + $order->info['shipping_cost']) < MODULE_ORDER_TOTAL_INSURANCE_OVER) {
			$pass = false;
		}
		// End of add by Juan Velez
       if ($pass == true) {
         $tax = tep_get_tax_rate(MODULE_ORDER_TOTAL_INSURANCE_TAX_CLASS);
// Changed so insurance would ba calulated off of subtotal + shipping cost since total could have discounts applied and we still want the highest insurance charge possible.
				// original - $how_often = ceil(($order->info['total']- $order->info['tax'] - MODULE_ORDER_TOTAL_INSURANCE_OVER)/MODULE_ORDER_TOTAL_INSURANCE_INCREMENT);
				$how_often = ceil((($order->info['subtotal'] + $order->info['shipping_cost'])- $order->info['tax'] - MODULE_ORDER_TOTAL_INSURANCE_OVER)/MODULE_ORDER_TOTAL_INSURANCE_INCREMENT);

         $order->info['tax'] += tep_calculate_tax((MODULE_ORDER_TOTAL_INSURANCE_FEE * $how_often), $tax);
         $order->info['tax_groups']["{$tax}"] += tep_calculate_tax((MODULE_ORDER_TOTAL_INSURANCE_FEE * $how_often), $tax);

				$this_amount = MODULE_ORDER_TOTAL_INSURANCE_FEE * $how_often;
  				if ($this_amount < MODULE_ORDER_TOTAL_INSURANCE_MIN_CHARGE ) {
  					$this_amount = MODULE_ORDER_TOTAL_INSURANCE_MIN_CHARGE;
  				}

         $order->info['total'] += $this_amount + tep_calculate_tax(MODULE_ORDER_TOTAL_INSURANCE_FEE, $tax);

         $this->output[] = array('title' => $this->title . ':',
                                 'text' => $currencies->format(tep_add_tax(($this_amount), $tax), true, $order->info['currency'], $order->info['currency_value']),
                                 'value' => tep_add_tax(($this_amount), $tax));
       }
     }

   function check() {
     if (!isset($this->check)) {
       $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_ORDER_TOTAL_INSURANCE_STATUS'");
       $this->check = tep_db_num_rows($check_query);
     }

     return $this->check;
   }

   function keys() {
     return array('MODULE_ORDER_TOTAL_INSURANCE_STATUS', 'MODULE_ORDER_TOTAL_INSURANCE_SORT_ORDER', 'MODULE_ORDER_TOTAL_INSURANCE_USE', 'MODULE_ORDER_TOTAL_INSURANCE_OVER', 'MODULE_ORDER_TOTAL_INSURANCE_INCREMENT', 'MODULE_ORDER_TOTAL_INSURANCE_FEE', 'MODULE_ORDER_TOTAL_INSURANCE_MIN_CHARGE', 'MODULE_ORDER_TOTAL_INSURANCE_DESTINATION', 'MODULE_ORDER_TOTAL_INSURANCE_TAX_CLASS');
   }

   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 ('Display Shipping Insurance', 'MODULE_ORDER_TOTAL_INSURANCE_STATUS', 'true', 'Do you want to offer Shipping Insurance?', '6', '1','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 ('Sort Order', 'MODULE_ORDER_TOTAL_INSURANCE_SORT_ORDER', '4', 'Sort order of display.', '6', '2', 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 ('Customer Chooses?', 'MODULE_ORDER_TOTAL_INSURANCE_USE', 'false', 'Do you want the customer to have the choice?', '6', '3', '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, use_function, date_added) values ('Amount Exempt From Fee', 'MODULE_ORDER_TOTAL_INSURANCE_OVER', '100', 'At what total amount do you start charging insurance?  For example, UPS insures amounts up to $100, so that is what you would put here.', '6', '4', 'currencies->format', now())");
     tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) values ('Increment Amount', 'MODULE_ORDER_TOTAL_INSURANCE_INCREMENT', '100', 'For each <b>how many dollars,</b> ie. the increment amount,  of the total (e.g. 100 here and .40 for the rate below would mean 40 cents fee for every $100 of the amount to be insured).', '6', '5', 'currencies->format', now())");
     tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) values ('Insurance Rate', 'MODULE_ORDER_TOTAL_INSURANCE_FEE', '.40', 'The amount charged per Increment Amount above.', '6', '6', 'currencies->format', now())");
     tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) values ('Minimum Charge', 'MODULE_ORDER_TOTAL_INSURANCE_MIN_CHARGE', '1.20', 'The minimum amount to be charged if order is over minimum total.', '6', '7', 'currencies->format', 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 ('Apply Insurance Fee To Which Orders', 'MODULE_ORDER_TOTAL_INSURANCE_DESTINATION', 'both', 'Apply insurance fee for orders sent to the set destination.', '6', '8', 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'), ', 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_ORDER_TOTAL_INSURANCE_TAX_CLASS', '0', 'Use the following tax class on the insurance fee.', '6', '9', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())");
   }

   function remove() {
     $keys = '';
     $keys_array = $this->keys();
     for ($i=0; $i<sizeof($keys_array); $i++) {
       $keys .= "'" . $keys_array[$i] . "',";
     }
     $keys = substr($keys, 0, -1);

     tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in (" . $keys . ")");
   }
 }
?>