<?php
/**
 * @package shippingMethod
 * @copyright Copyright 2003-2009 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: zones3.php 14498 2009-10-01 20:16:16Z ajeh $
 */
/*

  USAGE
  By default, the module comes with support for 3 zones3.  This can be
  easily changed by editing the line below in the zones3 constructor
  that defines $this->num_zones3.

  Next, you will want to activate the module by going to the Admin screen,
  clicking on Modules, then clicking on Shipping.  A list of all shipping
  modules should appear.  Click on the green dot next to the one labeled
  zones3.php.  A list of settings will appear to the right.  Click on the
  Edit button.

  PLEASE NOTE THAT YOU WILL LOSE YOUR CURRENT SHIPPING RATES AND OTHER
  SETTINGS IF YOU TURN OFF THIS SHIPPING METHOD.  Make sure you keep a
  backup of your shipping settings somewhere at all times.

  If you want an additional handling charge applied to orders that use this
  method, set the Handling Fee field.

  Next, you will need to define which countries are in each zone.  Determining
  this might take some time and effort.  You should group a set of countries
  that has similar shipping charges for the same weight.  For instance, when
  shipping from the US, the countries of Japan, Australia, New Zealand, and
  Singapore have similar shipping rates.  As an example, one of my customers
  is using this set of zones3:
    1: USA
    2: Canada
    3: Austria, Belgium, Great Britain, France, Germany, Greenland, Iceland,
       Ireland, Italy, Norway, Holland/Netherlands, Denmark, Poland, Spain,
       Sweden, Switzerland, Finland, Portugal, Israel, Greece
    4: Japan, Australia, New Zealand, Singapore
    5: Taiwan, China, Hong Kong

  When you enter these country lists, enter them into the Zone X Countries
  fields, where "X" is the number of the zone.  They should be entered as
  two character ISO country codes in all capital letters.  They should be
  separated by commas with no spaces or other punctuation. For example:
    1: US
    2: CA
    3: AT,BE,GB,FR,DE,GL,IS,IE,IT,NO,NL,DK,PL,ES,SE,CH,FI,PT,IL,GR
    4: JP,AU,NZ,SG
    5: TW,CN,HK

  Now you need to set up the shipping rate tables for each zone.  Again,
  some time and effort will go into setting the appropriate rates.  You
  will define a set of weight ranges and the shipping price for each
  range.  For instance, you might want an order than weighs more than 0
  and less than or equal to 3 to cost 5.50 to ship to a certain zone.
  This would be defined by this:  3:5.5

  You should combine a bunch of these rates together in a comma delimited
  list and enter them into the "Zone X Shipping Table" fields where "X"
  is the zone number.  For example, this might be used for Zone 1:
    1:3.5,2:3.95,3:5.2,4:6.45,5:7.7,6:10.4,7:11.85, 8:13.3,9:14.75,10:16.2,11:17.65,
    12:19.1,13:20.55,14:22,15:23.45

  The above example includes weights over 0 and up to 15.  Note that
  units are not specified in this explanation since they should be
  specific to your locale.

  CAVEATS
  At this time, it does not deal with weights that are above the highest amount
  defined.  This will probably be the next area to be improved with the
  module.  For now, you could have one last very high range with a very
  high shipping rate to discourage orders of that magnitude.  For
  instance:  999:1000

  If you want to be able to ship to any country in the world, you will
  need to enter every country code into the Country fields. For most
  shops, you will not want to enter every country.  This is often
  because of too much fraud from certain places. If a country is not
  listed, then the module will add a $0.00 shipping charge and will
  indicate that shipping is not available to that destination.
  PLEASE NOTE THAT THE ORDER CAN STILL BE COMPLETED AND PROCESSED!

  It appears that the osC shipping system automatically rounds the
  shipping weight up to the nearest whole unit.  This makes it more
  difficult to design precise shipping tables.  If you want to, you
  can hack the shipping.php file to get rid of the rounding.

  Lastly, there is a limit of 255 characters on each of the Zone
  Shipping Tables and Zone Countries.

*/

  class zones3 {
    var $code, $title, $description, $enabled, $num_zones3;

// class constructor
    function zones3() {
      $this->code = 'zones3';
      $this->title = MODULE_SHIPPING_ZONES3_TEXT_TITLE;
      $this->description = MODULE_SHIPPING_ZONES3_TEXT_DESCRIPTION;
      $this->sort_order = MODULE_SHIPPING_ZONES3_SORT_ORDER;
      $this->icon = '';
      $this->tax_class = MODULE_SHIPPING_ZONES3_TAX_CLASS;
      $this->tax_basis = MODULE_SHIPPING_ZONES3_TAX_BASIS;

      // disable only when entire cart is free shipping
      if (zen_get_shipping_enabled($this->code)) {
        $this->enabled = ((MODULE_SHIPPING_ZONES3_STATUS == 'True') ? true : false);
      }

      // CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES3 NEEDED
      $this->num_zones3 = 6;

      if (IS_ADMIN_FLAG === true) {
  		// build in admin only additional zones3 if missing in the configuration table due to customization of default $this->num_zones3 = 3
	  	  global $db;
  	  	for ($i = 1; $i <= $this->num_zones3; $i++) {
  		  	$check = $db->Execute("select * from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES3_COUNTRIES_" . $i . "'");
	  		  if ($this->enabled && $check->EOF) {
          $default_countries = '';
          $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Zone " . $i ." Countries', 'MODULE_SHIPPING_ZONES3_COUNTRIES_" . $i ."', '" . $default_countries . "', 'Comma separated list of two character ISO country codes that are part of Zone " . $i . ".<br />Set as 00 to indicate all two character ISO country codes that are not specifically defined.', '6', '0', 'zen_cfg_textarea(', now())");
          $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Zone " . $i ." Shipping Table', 'MODULE_SHIPPING_ZONES3_COST_" . $i ."', '3:8.50,7:10.50,99:20.00', 'Shipping rates to Zone " . $i . " destinations based on a group of maximum order weights/prices. Example: 3:8.50,7:10.50,... Weight/Price less than or equal to 3 would cost 8.50 for Zone " . $i . " destinations.<br />You can end the last amount as 10000:7% to charge 7% of the Order Total', '6', '0', 'zen_cfg_textarea(', now())");
          $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Zone " . $i ." Handling Fee', 'MODULE_SHIPPING_ZONES3_HANDLING_" . $i."', '0', 'Handling Fee for this shipping zone', '6', '0', now())");
          $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Handling Per Order or Per Box Zone " . $i . "  (when by weight)' , 'MODULE_SHIPPING_ZONES3_HANDLING_METHOD_" . $i."', 'Order', 'Do you want to charge Handling Fee Per Order or Per Box?', '6', '0', 'zen_cfg_select_option(array(\'Order\', \'Box\'), ', now())");
  		  	}
    		}
  	  } // build in admin only

      if ($this->enabled) {
        global $db;
  	  	for ($i = 1; $i <= $this->num_zones3; $i++) {
          // check MODULE_SHIPPING_TABLE_HANDLING_METHOD is in
          $check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES3_HANDLING_METHOD_" . $i . "'");
          if ($check_query->EOF) {
            $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Handling Per Order or Per Box Zone " . $i . "  (when by weight)' , 'MODULE_SHIPPING_ZONES3_HANDLING_METHOD_" . $i."', 'Order', 'Do you want to charge Handling Fee Per Order or Per Box?', '6', '0', 'zen_cfg_select_option(array(\'Order\', \'Box\'), ', now())");
          }
        }
      }
    }

// class methods
    function quote($method = '') {
      global $order, $shipping_weight, $shipping_num_boxes, $total_count;
      $dest_country = $order->delivery['country']['iso_code_2'];
      $dest_zone = 0;
      $error = false;

    $order_total_amount = $_SESSION['cart']->show_total() - $_SESSION['cart']->free_shipping_prices() ;

      for ($i=1; $i<=$this->num_zones3; $i++) {
        $countries_table = constant('MODULE_SHIPPING_ZONES3_COUNTRIES_' . $i);
        $countries_table = strtoupper(str_replace(' ', '', $countries_table));
        $country_zones3 = preg_split("/[,]/", $countries_table);
        if (in_array($dest_country, $country_zones3)) {
          $dest_zone = $i;
          break;
        }
        if (in_array('00', $country_zones3)) {
          $dest_zone = $i;
          break;
        }
      }

      if ($dest_zone == 0) {
        $error = true;
      } else {
        $shipping = -1;
        $zones3_cost = constant('MODULE_SHIPPING_ZONES3_COST_' . $dest_zone);

        $zones3_table = preg_split("/[:,]/" , $zones3_cost);
        $size = sizeof($zones3_table);
        $done = false;
        for ($i=0; $i<$size; $i+=2) {
          switch (MODULE_SHIPPING_ZONES3_METHOD) {
        	  case (MODULE_SHIPPING_ZONES3_METHOD == 'Weight'):
              if (round($shipping_weight,9) <= $zones3_table[$i]) {
                $shipping = $zones3_table[$i+1];

                switch (SHIPPING_BOX_WEIGHT_DISPLAY) {
                case (0):
                  $show_box_weight = '';
                  break;
                case (1):
                  $show_box_weight = ' (' . $shipping_num_boxes . ' ' . TEXT_SHIPPING_BOXES . ')';
                  break;
                case (2):
                  $show_box_weight = ' (' . number_format($shipping_weight * $shipping_num_boxes,2) . MODULE_SHIPPING_ZONES3_TEXT_UNITS . ')';
                  break;
                default:
                  $show_box_weight = ' (' . $shipping_num_boxes . ' x ' . number_format($shipping_weight,2) . MODULE_SHIPPING_ZONES3_TEXT_UNITS . ')';
                  break;
                }

//                $shipping_method = MODULE_SHIPPING_ZONES3_TEXT_WAY . ' ' . $dest_country . (SHIPPING_BOX_WEIGHT_DISPLAY >= 2 ? ' : ' . $shipping_weight . ' ' . MODULE_SHIPPING_ZONES3_TEXT_UNITS : '');
                $shipping_method = MODULE_SHIPPING_ZONES3_TEXT_WAY . ' ' . $dest_country . $show_box_weight;
                $done = true;
        if (strstr($zones3_table[$i+1], '%')) {
          $shipping = ($zones3_table[$i+1]/100) * $order_total_amount;
        } else {
          $shipping = $zones3_table[$i+1];
        }
                break;
        	    }
      	    break;
        	  case (MODULE_SHIPPING_ZONES3_METHOD == 'Price'):
// shipping adjustment
              if (($_SESSION['cart']->show_total() - $_SESSION['cart']->free_shipping_prices()) <= $zones3_table[$i]) {
                $shipping = $zones3_table[$i+1];
                $shipping_method = MODULE_SHIPPING_ZONES3_TEXT_WAY . ' ' . $dest_country;
        if (strstr($zones3_table[$i+1], '%')) {
          $shipping = ($zones3_table[$i+1]/100) * $order_total_amount;
        } else {
          $shipping = $zones3_table[$i+1];
        }
                $done = true;
                break;
	            }
	          break;
        	  case (MODULE_SHIPPING_ZONES3_METHOD == 'Item'):
// shipping adjustment
              if (($total_count - $_SESSION['cart']->free_shipping_items()) <= $zones3_table[$i]) {
                $shipping = $zones3_table[$i+1];
                $shipping_method = MODULE_SHIPPING_ZONES3_TEXT_WAY . ' ' . $dest_country;
                $done = true;
        if (strstr($zones3_table[$i+1], '%')) {
          $shipping = ($zones3_table[$i+1]/100) * $order_total_amount;
        } else {
          $shipping = $zones3_table[$i+1];
        }
                break;
  	          }
	          break;
          }
          if ($done == true) {
            break;
          }
        }

        if ($shipping == -1) {
          $shipping_cost = 0;
          $shipping_method = MODULE_SHIPPING_ZONES3_UNDEFINED_RATE;
        } else {
          switch (MODULE_SHIPPING_ZONES3_METHOD) {
        	  case (MODULE_SHIPPING_ZONES3_METHOD == 'Weight'):
              // charge per box when done by Weight
              // Handling fee per box or order
              if (constant('MODULE_SHIPPING_ZONES3_HANDLING_METHOD_' . $dest_zone) == 'Box') {
                $shipping_cost = ($shipping * $shipping_num_boxes) + constant('MODULE_SHIPPING_ZONES3_HANDLING_' . $dest_zone) * $shipping_num_boxes;
              } else {
                $shipping_cost = ($shipping * $shipping_num_boxes) + constant('MODULE_SHIPPING_ZONES3_HANDLING_' . $dest_zone);
              }
              break;
        	  case (MODULE_SHIPPING_ZONES3_METHOD == 'Price'):
              // don't charge per box when done by Price
              $shipping_cost = ($shipping) + constant('MODULE_SHIPPING_ZONES3_HANDLING_' . $dest_zone);
            break;
        	  case (MODULE_SHIPPING_ZONES3_METHOD == 'Item'):
              // don't charge per box when done by Item
              $shipping_cost = ($shipping) + constant('MODULE_SHIPPING_ZONES3_HANDLING_' . $dest_zone);
            break;
          }
        }
      }
      $this->quotes = array('id' => $this->code,
                            'module' => MODULE_SHIPPING_ZONES3_TEXT_TITLE,
                            'methods' => array(array('id' => $this->code,
                                                     'title' => $shipping_method,
                                                     'cost' => $shipping_cost)));

      if ($this->tax_class > 0) {
        $this->quotes['tax'] = zen_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
      }

      if (zen_not_null($this->icon)) $this->quotes['icon'] = zen_image($this->icon, $this->title);

      if (strstr(MODULE_SHIPPING_ZONES3_SKIPPED, $dest_country)) {
        // don't show anything for this country
        $this->quotes = array();
      } else {
        if ($error == true) $this->quotes['error'] = MODULE_SHIPPING_ZONES3_INVALID_ZONE;
      }

      return $this->quotes;
    }

    function check() {
      global $db;
      if (!isset($this->_check)) {
        $check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES3_STATUS'");
        $this->_check = $check_query->RecordCount();
      }
      return $this->_check;
    }

    function install() {
      global $db;
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Status modulu', 'MODULE_SHIPPING_ZONES3_STATUS', 'True', 'True = Aktywny<br />False = Nieaktywny', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Sposob naliczania oplaty', 'MODULE_SHIPPING_ZONES3_METHOD', 'Weight', 'Weight = wedlug wagi przesylki<br />Price = wedlug wartosci zamowienia<br />Item = wedlug ilosci sztuk towaru w przesylce', '6', '0', 'zen_cfg_select_option(array(\'Weight\', \'Price\', \'Item\'), ', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Stawka podatku', 'MODULE_SHIPPING_ZONES3_TAX_CLASS', '0', 'Wybierz stawke podatku od oplaty za przesylki.', '6', '0', 'zen_get_tax_class_title', 'zen_cfg_pull_down_tax_classes(', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Metoda naliczania podatku', 'MODULE_SHIPPING_ZONES3_TAX_BASIS', 'Shipping', 'Shipping = jak w kraju do ktorego wysylasz<br />Billing = jak w kraju w ktorym mieszka zamawiajacy<br />Store = jak w kraju w ktorym dziala sklep', '6', '0', 'zen_cfg_select_option(array(\'Shipping\', \'Billing\', \'Store\'), ', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Kolejnosc', 'MODULE_SHIPPING_ZONES3_SORT_ORDER', '0', 'Ustaw kolejnosc, pamietaj ze dwa moduly nie moga miec takiej samej kolejnosci bo zaden z nich nie bedzie dzialal poprawnie.', '6', '0', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Kraje do ktorych NIE WYSYLASZ PRZESYLEK - dwuliterowe kody ISO rozdzielone przecinkiem', 'MODULE_SHIPPING_ZONES3_SKIPPED', '', 'Lista krajow:', '6', '0', 'zen_cfg_textarea(', now())");

      for ($i = 1; $i <= $this->num_zones3; $i++) {
        $default_countries = '';
        if ($i == 1) {
          $default_countries = 'US,CA';
        }
        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Strefa " . $i ." - lista krajow', 'MODULE_SHIPPING_ZONES3_COUNTRIES_" . $i ."', '" . $default_countries . "', 'Wpisz rozdzielone przecinkiem dwuliterowe kody ISO krajow w Strefie " . $i . ".', '6', '0', 'zen_cfg_textarea(', now())");
        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Strefa " . $i ." - Cennik', 'MODULE_SHIPPING_ZONES3_COST_" . $i ."', '3:8.50,7:10.50,99:20.00', 'Koszt dostawy w Strefie " . $i . " Wpisz wartosci graniczne dla roznych cen dostawy w formacie: 1:5.00,2:6.50,5:12.00 itd (paczka do 1 kg wysylka 5.00 zl, paczka 2 kg wysylka 6.50 zl, paczka 5 kg wysylka 12.00 zl)<br />Przy wyborze metody naliczania od wartosci zamowienia mozesz skorzystac z 2 sposobow - albo kwotowego np. 300:5.00,500:8.50,1000:12.00 lub procentowego, np. 100:7%,500:5%,1000:3% itd.<br />Dla oplat za sztuke format wpisu jest nastepujacy:1:6.00,5:8.50,10:12.00 (1 sztuka wysylka 6.00 zl, 5 sztuk wysylka 8 zl 50 gr itd.', '6', '0', 'zen_cfg_textarea(', now())");
        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Strefa " . $i ." - jednorazowa stala doplata do przesylki', 'MODULE_SHIPPING_ZONES3_HANDLING_" . $i."', '0', 'Mozesz zdefiniowac stala doplate do przesylki np. za opakowanie itp.', '6', '0', now())");

        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Sposob naliczania oplaty manipulacyjnej w strefie " . $i . " (dla stawek wagowych)' , 'MODULE_SHIPPING_ZONES3_HANDLING_METHOD_" . $i."', 'Order', 'Dla calego zamowienia jednorazowo(Order) czy dla kazdej paczki osobno jezeli waga przesylki przekroczy dopuszczalna wage jednej paczki? (Box)', '6', '0', 'zen_cfg_select_option(array(\'Order\', \'Box\'), ', now())");

      }
    }

    function remove() {
      global $db;
      $db->Execute("delete from " . TABLE_CONFIGURATION . " where configuration_key like 'MODULE\_SHIPPING\_ZONES3\_%'");
    }

    function keys() {
      $keys = array('MODULE_SHIPPING_ZONES3_STATUS', 'MODULE_SHIPPING_ZONES3_METHOD', 'MODULE_SHIPPING_ZONES3_TAX_CLASS', 'MODULE_SHIPPING_ZONES3_TAX_BASIS', 'MODULE_SHIPPING_ZONES3_SORT_ORDER', 'MODULE_SHIPPING_ZONES3_SKIPPED');

      for ($i=1; $i<=$this->num_zones3; $i++) {
        $keys[] = 'MODULE_SHIPPING_ZONES3_COUNTRIES_' . $i;
        $keys[] = 'MODULE_SHIPPING_ZONES3_COST_' . $i;
        $keys[] = 'MODULE_SHIPPING_ZONES3_HANDLING_' . $i;
        $keys[] = 'MODULE_SHIPPING_ZONES3_HANDLING_METHOD_' . $i;
      }

      return $keys;
    }
  }
?>