Versandkosten wie richtig?

[KiteFuchs]

Guten Tag,

welches Modul funktioniert für folgende Versandkosten?

Europa (bis 20 EUR):     3,99 EUR EUR
Europa (über 20 EUR):    portofrei EUR
Welt (bis 49 EUR):    6,99 EUR EUR
Welt (über 49 EUR):    portofrei EUR

Leider funktioniert das DP nur mit Gewicht

Danke für jede Hilfe



Linkback: https://www.modified-shop.org/forum/index.php?topic=6815.0

[hendrik]

Im Prinzip ist table (Tabellarische Versandkosten) dafür das richtige.

Allerdings teilt es sich bei dir in zwei Zonen. Europa+Welt. Durch die Angabe von Zonen kannst du das Modul auf einzelne Länder oder Ländergruppen (Zonen) beschränken.

Da kannst du folgendes machen. Du duplizierst das table-Modul.
Anleitung hier: Tutorial:_Kopieren_eines_Versandmoduls

Im ersten table-konfigurierst du die Länder deiner Europazone,
Im anderen die Welt-Zone.

Gruß
Hen

[KiteFuchs]

Hab ich gemacht aber da steht nichts das man eine neue DB Tabelle braucht!?!

Code: [Auswählen]

1146 - Table 'mu_shop.TABLE2_CONFIGURATION' doesn't exist

select configuration_value from TABLE2_CONFIGURATION where configuration_key = 'MODULE_SHIPPING_TABLE2_STATUS'

[XT SQL Error]
wie kommt das?

[hendrik]

Du hast das Manual nicht richtig gelesen.

"TABLE_CONFIGURATION" ist 'ne SQL-Anweisung. Die wird nicht geändert.

[KiteFuchs]

was ist den noch falsch?

Code: PHP  [Auswählen]

  class table2 {
    var $code, $title, $description, $icon, $enabled;

    function table2() {
      global $order;

      $this->code = 'table2';
      $this->title = MODULE_SHIPPING_TABLE2_TEXT_TITLE;
      $this->description = MODULE_SHIPPING_TABLE2_TEXT_DESCRIPTION;
      $this->sort_order = MODULE_SHIPPING_TABLE2_SORT_ORDER;
      $this->icon = '';
      $this->tax_class = MODULE_SHIPPING_TABLE2_TAX_CLASS;
      $this->enabled = ((MODULE_SHIPPING_TABLE2_STATUS == 'True') ? true : false);

      if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_TABLE2_ZONE> 0) ) {
        $check_flag = false;
        $check_query = xtc_db_query("select zone_id from " . TABLE2_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_TABLE2_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id");
        while ($check = xtc_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;
        }

      }
    }

    function quote($method = '') {
      global $order, $shipping_weight, $shipping_num_boxes,$xtPrice;

      if (MODULE_SHIPPING_TABLE2_MODE == 'price') {
        $order_total = $xtPrice->xtcRemoveCurr($_SESSION['cart']->show_total());
      } else {
        $order_total = $shipping_weight;
      }

      $table_cost = preg_split("/[:,]/" , MODULE_SHIPPING_TABLE2_COST); // Hetfield - 2009-08-18 - replaced deprecated function split with preg_split to be ready for PHP>= 5.3
      $size = sizeof($table2_cost);
      for ($i=0, $n=$size; $i<$n; $i+=2) {
        if ($order_total <= $table2_cost[$i]) {
          $shipping = $table2_cost[$i+1];
          break;
        }
      }

      if (MODULE_SHIPPING_TABLE2_MODE == 'weight') {
        $shipping = $shipping * $shipping_num_boxes;
      }

      $this->quotes = array('id' => $this->code,
                            'module' => MODULE_SHIPPING_TABLE2_TEXT_TITLE,
                            'methods' => array(array('id' => $this->code,
                                                     'title' => MODULE_SHIPPING_TABLE2_TEXT_WAY,
                                                     'cost' => $shipping + MODULE_SHIPPING_TABLE2_HANDLING)));

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

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

      return $this->quotes;
    }

    function check() {
      if (!isset($this->_check)) {
        $check_query = xtc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_TABLE_STATUS'");
        $this->_check = xtc_db_num_rows($check_query);
      }
      return $this->_check;
    }

    function install() {
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) VALUES ('MODULE_SHIPPING_TABLE_STATUS', 'True', '6', '0', 'xtc_cfg_select_option(array(\'True\', \'False\'), ', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE_ALLOWED', '', '6', '0', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE_COST', '25:8.50,50:5.50,10000:0.00', '6', '0', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_SHIPPING_TABLE_MODE', 'weight', '6', '0', 'xtc_cfg_select_option(array(\'weight\', \'price\'), ', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE_HANDLING', '0', '6', '0', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_SHIPPING_TABLE_TAX_CLASS', '0', '6', '0', 'xtc_get_tax_class_title', 'xtc_cfg_pull_down_tax_classes(', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_SHIPPING_TABLE_ZONE', '0', '6', '0', 'xtc_get_zone_class_title', 'xtc_cfg_pull_down_zone_classes(', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE_SORT_ORDER', '0', '6', '0', now())");
    }

    function remove() {
      xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }

    function keys() {
      return array('MODULE_SHIPPING_TABLE2_STATUS', 'MODULE_SHIPPING_TABLE2_COST', 'MODULE_SHIPPING_TABLE2_MODE', 'MODULE_SHIPPING_TABLE2_HANDLING','MODULE_SHIPPING_TABLE2_ALLOWED', 'MODULE_SHIPPING_TABLE2_TAX_CLASS', 'MODULE_SHIPPING_TABLE2_ZONE', 'MODULE_SHIPPING_TABLE2_SORT_ORDER');
    }
  }
?>

[GTB]

In der function install() stehen die  SQL Anweisungen und du hast dort auch den Tabellennamen umbenannt in "TABLE2_CONFIGURATION".

dieser muss aber auf "TABLE_CONFIGURATION" bleiben!

[KiteFuchs]

aber diese hatte ich doch laut code siehe oben geändert?

[GTB]

Code: PHP  [Auswählen]

    function check() {
      if (!isset($this->_check)) {
        $check_query = xtc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_TABLE_STATUS'");
        $this->_check = xtc_db_num_rows($check_query);
      }
      return $this->_check;
    }
 

mit dem ersetzen:

Code: PHP  [Auswählen]

    function check() {
      if (!isset($this->_check)) {
        $check_query = xtc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_TABLE2_STATUS'");
        $this->_check = xtc_db_num_rows($check_query);
      }
      return $this->_check;
    }
 

das gleiche machst auch mit der install...

[GTB]

hier noch die function install:

Code: PHP  [Auswählen]

    function install() {
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) VALUES ('MODULE_SHIPPING_TABLE2_STATUS', 'True', '6', '0', 'xtc_cfg_select_option(array(\'True\', \'False\'), ', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_ALLOWED', '', '6', '0', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_COST', '25:8.50,50:5.50,10000:0.00', '6', '0', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_SHIPPING_TABLE2_MODE', 'weight', '6', '0', 'xtc_cfg_select_option(array(\'weight\', \'price\'), ', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_HANDLING', '0', '6', '0', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_SHIPPING_TABLE2_TAX_CLASS', '0', '6', '0', 'xtc_get_tax_class_title', 'xtc_cfg_pull_down_tax_classes(', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_SHIPPING_TABLE2_ZONE', '0', '6', '0', 'xtc_get_zone_class_title', 'xtc_cfg_pull_down_zone_classes(', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_SORT_ORDER', '0', '6', '0', now())");
    }
 

[KiteFuchs]

Ahh danke ist heut irgendwie nicht mein Tag

[KiteFuchs]

Wie kann ich die Begrenzung aufheben? er schneidet immer Länder ab, ich komme bei weltweit nur bis HR.

[hendrik]

Du musst Zonen, Steuerzonen, angeben anstatt hundertundschlagmichtot einzelne Länder. Das Dropdown in der table-Konfig ganz unten. Zonen findest du in der Administration unter Land/Steuer.

Die Länder Nicht-EU Ausland sind bereits vorkonfiguriert. Du kannst ggf. eine neue (Steuer-)Zone anlegen und dann im table-Konfig auswählen.

modified eCommerce Shopsoftware Anwenderhandbuch

Gruß
Hen