/** * Get shipping zones from the database * @since 2.6.0 * @return array of arrays */ public static function get_zones() { global $wpdb; $raw_zones = $wpdb->get_results("SELECT zone_id, zone_name, zone_order FROM {$wpdb->prefix}woocommerce_shipping_zones order by zone_order ASC;"); $zones = array(); foreach ($raw_zones as $raw_zone) { $zone = new WC_Shipping_Zone($raw_zone); $zones[$zone->get_zone_id()] = $zone->get_data(); $zones[$zone->get_zone_id()]['formatted_zone_location'] = $zone->get_formatted_location(); $zones[$zone->get_zone_id()]['shipping_methods'] = $zone->get_shipping_methods(); } return $zones; }
/** * Get the shipping methods for all shipping zones. * * Note: WooCommerce 2.6 intoduces the concept of Shipping Zones * * @return array (Array of) all shipping methods instances */ public function getZonesShippingMethods() { $zones = array(); // Rest of the World zone $zone = new \WC_Shipping_Zone(); $zones[$zone->get_zone_id()] = $zone->get_data(); $zones[$zone->get_zone_id()]['formatted_zone_location'] = $zone->get_formatted_location(); $zones[$zone->get_zone_id()]['shipping_methods'] = $zone->get_shipping_methods(); // Add user configured zones $zones = array_merge($zones, \WC_Shipping_Zones::get_zones()); $shipping_methods = array(); // Format: $shipping_methods[zone_name_method_id] => shipping_method_object // where zone_name is e.g. domestic, europe, rest_of_the_world, and // methods_id is e.g. flat_rate, free_shiping, local_pickup, etc foreach ($zones as $zone) { foreach ($zone['shipping_methods'] as $instance_id => $shipping_method) { // Zone names are converted to all lower-case and spaces replaced with $shipping_methods[$shipping_method->id . '_' . $instance_id] = $shipping_method; } } return $shipping_methods; }
/** * Handle submissions from assets/js/wc-shipping-zone-methods.js Backbone model. */ public static function shipping_zone_methods_save_changes() { if (!isset($_POST['wc_shipping_zones_nonce'], $_POST['zone_id'], $_POST['changes'])) { wp_send_json_error('missing_fields'); exit; } if (!wp_verify_nonce($_POST['wc_shipping_zones_nonce'], 'wc_shipping_zones_nonce')) { wp_send_json_error('bad_nonce'); exit; } if (!current_user_can('manage_woocommerce')) { wp_send_json_error('missing_capabilities'); exit; } global $wpdb; $zone_id = wc_clean($_POST['zone_id']); $zone = new WC_Shipping_Zone($zone_id); $changes = $_POST['changes']; if (isset($changes['zone_name'])) { $zone->set_zone_name(wc_clean($changes['zone_name'])); } if (isset($changes['zone_locations'])) { $zone->clear_locations(array('state', 'country', 'continent')); $locations = array_filter(array_map('wc_clean', (array) $changes['zone_locations'])); foreach ($locations as $location) { // Each posted location will be in the format type:code $location_parts = explode(':', $location); switch ($location_parts[0]) { case 'state': $zone->add_location($location_parts[1] . ':' . $location_parts[2], 'state'); break; case 'country': $zone->add_location($location_parts[1], 'country'); break; case 'continent': $zone->add_location($location_parts[1], 'continent'); break; } } } if (isset($changes['zone_postcodes'])) { $zone->clear_locations('postcode'); $postcodes = array_filter(array_map('strtoupper', array_map('wc_clean', explode("\n", $changes['zone_postcodes'])))); foreach ($postcodes as $postcode) { $zone->add_location($postcode, 'postcode'); } } if (isset($changes['methods'])) { foreach ($changes['methods'] as $instance_id => $data) { $method_id = $wpdb->get_var($wpdb->prepare("SELECT method_id FROM {$wpdb->prefix}woocommerce_shipping_zone_methods WHERE instance_id = %d", $instance_id)); if (isset($data['deleted'])) { $shipping_method = WC_Shipping_Zones::get_shipping_method($instance_id); $option_key = $shipping_method->get_instance_option_key(); if ($wpdb->delete("{$wpdb->prefix}woocommerce_shipping_zone_methods", array('instance_id' => $instance_id))) { delete_option($option_key); do_action('woocommerce_shipping_zone_method_deleted', $instance_id, $method_id, $zone_id); } continue; } $method_data = array_intersect_key($data, array('method_order' => 1, 'enabled' => 1)); if (isset($method_data['method_order'])) { $wpdb->update("{$wpdb->prefix}woocommerce_shipping_zone_methods", array('method_order' => absint($method_data['method_order'])), array('instance_id' => absint($instance_id))); } if (isset($method_data['enabled'])) { $is_enabled = absint('yes' === $method_data['enabled']); if ($wpdb->update("{$wpdb->prefix}woocommerce_shipping_zone_methods", array('is_enabled' => $is_enabled), array('instance_id' => absint($instance_id)))) { do_action('woocommerce_shipping_zone_method_status_toggled', $instance_id, $method_id, $zone_id, $is_enabled); } } } } $zone->save(); wp_send_json_success(array('zone_id' => $zone->get_zone_id(), 'zone_name' => $zone->get_zone_name(), 'methods' => $zone->get_shipping_methods())); }