Shipping mod

ALTER TABLE `xcart_shipping` ADD `mintotal` DECIMAL( 12, 2 ) NOT NULL DEFAULT '0.00' ;
ALTER TABLE `xcart_shipping` ADD `maxtotal` DECIMAL( 12, 2 ) NOT NULL DEFAULT '0.00' ;


admin/shipping.php

Before :

			func_array2update("shipping", $arr, "shippingid = '$id'");

Add:

			// shipping method price ranges - EJC
			$arr['mintotal'] = func_convert_number($arr['mintotal']);
			$arr['maxtotal'] = func_convert_number($arr['maxtotal']);
			// / shipping method price ranges - EJC

Before:

		func_array2insert("shipping", $add);

Add:

		// shipping method price ranges - EJC
		$arr['mintotal'] = func_convert_number($arr['mintotal']);
		$arr['maxtotal'] = func_convert_number($arr['maxtotal']);
		// / shipping method price ranges - EJC


in skin1/admin/main/shipping.tpl

After:

	<td nowrap="nowrap">{$lng.lbl_weight_limit} ({$config.General.weight_symbol})</td>

Add:

  {* shipping method price ranges - EJC *}
	<td nowrap="nowrap">{$lng.lbl_subtotal_range} ({$config.General.currency_symbol})</td>
	{* / shipping method price ranges - EJC *}

After:

	<td align="center"><input type="text" size="8" name="data[{$s.shippingid}][weight_min]" value="{$s.weight_min|formatprice}" /> - <input type="text" size="8" name="data[{$s.shippingid}][weight_limit]" value="{$s.weight_limit|formatprice}" /></td>

Add:

  {* shipping method price ranges - EJC *}
	<td align="center"><input type="text" size="8" name="data[{$s.shippingid}][mintotal]" value="{$s.mintotal|formatprice}" /> - <input type="text" size="8" name="data[{$s.shippingid}][maxtotal]" value="{$s.maxtotal|formatprice}" /></td>
	{* / shipping method price ranges - EJC *}

After:

	<td nowrap="nowrap">{$lng.lbl_weight_limit} ({$config.General.weight_symbol})</td>

Add:

  {* shipping method price ranges - EJC *}
	<td nowrap="nowrap">{$lng.lbl_subtotal_range} ({$config.General.currency_symbol})</td>
	{* / shipping method price ranges - EJC *}

After:

	<td align="center" nowrap="nowrap"><input type="text" size="8" name="data[{$s.shippingid}][weight_min]" value="{$s.weight_min|default:0|formatprice}" /> - <input type="text" size="8" name="data[{$s.shippingid}][weight_limit]" value="{$s.weight_limit|formatprice}" /></td>

Add:

  {* shipping method price ranges - EJC *}
	<td align="center" nowrap="nowrap"><input type="text" size="8" name="data[{$s.shippingid}][mintotal]" value="{$s.mintotal|formatprice}" /> - <input type="text" size="8" name="data[{$s.shippingid}][maxtotal]" value="{$s.maxtotal|formatprice}" /></td>
	{* / shipping method price ranges - EJC *}

After:

	<td>{$lng.lbl_weight_limit} ({$config.General.weight_symbol})</td>

Add:

  {* shipping method price ranges - EJC *}
	<td>{$lng.lbl_subtotal_range} ({$config.General.currency_symbol})</td>
	{* / shipping method price ranges - EJC *}

After:

	<td align="center"><input type="text" size="8" name="data[{$s.shippingid}][weight_min]" value="{$s.weight_min|default:0|formatprice}" /> - <input type="text" size="8" name="data[{$s.shippingid}][weight_limit]" value="{$s.weight_limit|formatprice}" /></td>

Add:

  {* shipping method price ranges - EJC *}
	<td align="center"><input type="text" size="8" name="data[{$s.shippingid}][mintotal]" value="{$s.mintotal|default:0|formatprice}" /> - <input type="text" size="8" name="data[{$s.shippingid}][maxtotal]" value="{$s.maxtotal|formatprice}" /></td>
	{* / shipping method price ranges - EJC *}

After:

	<td align="center" nowrap="nowrap"><input type="text" name="add[weight_min]" size="8" value="{0|formatprice}" /> - <input type="text" name="add[weight_limit]" size="8" value="{0|formatprice}" /></td>

Add:

  {* shipping method price ranges - EJC *}
	<td align="center" nowrap="nowrap"><input type="text" size="8" name="add[mintotal]" value="{0|formatprice}" /> - <input type="text" size="8" name="add[maxtotal]" value="{0|formatprice}" /></td>
	{* / shipping method price ranges - EJC *}


in shipping/intershipper.php:

Replace:

	$allowed_shipping_methods = func_query ("SELECT * FROM $sql_tbl[shipping] WHERE active='Y'");

	$carriers = func_query_column("SELECT DISTINCT(code) FROM $sql_tbl[shipping] WHERE code<>'' AND intershipper_code!='' AND active='Y'");

With:

  // shipping method price ranges - EJC
	$total_condition = " AND mintotal <= '".$cart["subtotal"]."' AND (maxtotal = '0' OR maxtotal >= '".$cart["subtotal"]."')";

	$allowed_shipping_methods = func_query ("SELECT * FROM $sql_tbl[shipping] WHERE active='Y' $total_condition");
	
	$carriers = func_query_column("SELECT DISTINCT(code) FROM $sql_tbl[shipping] WHERE code<>'' AND intershipper_code!='' AND active='Y' $total_condition");	
  // / shipping method price ranges - EJC
  
in shipping/myshipper.php

Replace:

	$allowed_shipping_methods = func_query("SELECT * FROM $sql_tbl[shipping] WHERE active = 'Y'");

With:

  // shipping method price ranges - EJC
	$total_condition = " AND mintotal <= '".$cart["subtotal"]."' AND (maxtotal = '0' OR maxtotal >= '".$cart["subtotal"]."')";

	$allowed_shipping_methods = func_query ("SELECT * FROM $sql_tbl[shipping] WHERE active='Y' $total_condition");
  // / shipping method price ranges - EJC


in shipping/shipping.php

After:

	$weight_condition = " AND weight_min<='$total_weight_shipping' AND (weight_limit='0' OR weight_limit>='$total_weight_shipping')";

Add:

  // shipping method price ranges - EJC
	$weight_condition .= " AND mintotal <= '".$cart["subtotal"]."' AND (maxtotal = '0' OR maxtotal >= '".$cart["subtotal"]."')";
  // / shipping method price ranges - EJC