Tiny File Manager

Back Back Up Advanced Editor

<?php

use Automattic\WooCommerce\Utilities\NumberUtil;
defined('ABSPATH') || exit;
class WC_Tax
{
    public static $precision;
    public static $round_at_subtotal = false;
    public static function init()
    {
        self::$precision = wc_get_rounding_precision();
        self::$round_at_subtotal = 'yes' === get_option('woocommerce_tax_round_at_subtotal');
    }
    public static function maybe_remove_tax_class_rates($old_value, $value)
    {
        wc_deprecated_function('WC_Tax::maybe_remove_tax_class_rates', '3.7', 'WC_Tax::delete_tax_class_by');
        $tax_classes = array_filter(array_map('trim', explode("\n", $value)));
        $existing_tax_classes = self::get_tax_classes();
        $removed = array_diff($existing_tax_classes, $tax_classes);
        foreach ($removed as $name) {
            self::delete_tax_class_by('name', $name);
        }
    }
    public static function calc_tax($price, $rates, $price_includes_tax = false, $deprecated = false)
    {
        if ($price_includes_tax) {
            $taxes = self::calc_inclusive_tax($price, $rates);
        } else {
            $taxes = self::calc_exclusive_tax($price, $rates);
        }
        return apply_filters('woocommerce_calc_tax', $taxes, $price, $rates, $price_includes_tax, $deprecated);
    }
    public static function calc_shipping_tax($price, $rates)
    {
        $taxes = self::calc_exclusive_tax($price, $rates);
        return apply_filters('woocommerce_calc_shipping_tax', $taxes, $price, $rates);
    }
    public static function round($in)
    {
        return apply_filters('woocommerce_tax_round', NumberUtil::round($in, wc_get_rounding_precision()), $in);
    }
    public static function calc_inclusive_tax($price, $rates)
    {
        $taxes = array();
        $compound_rates = array();
        $regular_rates = array();
        foreach ($rates as $key => $rate) {
            $taxes[$key] = 0;
            if ('yes' === $rate['compound']) {
                $compound_rates[$key] = $rate['rate'];
            } else {
                $regular_rates[$key] = $rate['rate'];
            }
        }
        $compound_rates = array_reverse($compound_rates, true);
        $non_compound_price = $price;
        foreach ($compound_rates as $key => $compound_rate) {
            $tax_amount = apply_filters('woocommerce_price_inc_tax_amount', $non_compound_price - $non_compound_price / (1 + $compound_rate / 100), $key, $rates[$key], $price);
            $taxes[$key] += $tax_amount;
            $non_compound_price = $non_compound_price - $tax_amount;
        }
        $regular_tax_rate = 1 + array_sum($regular_rates) / 100;
        foreach ($regular_rates as $key => $regular_rate) {
            $the_rate = $regular_rate / 100 / $regular_tax_rate;
            $net_price = $price - $the_rate * $non_compound_price;
            $tax_amount = apply_filters('woocommerce_price_inc_tax_amount', $price - $net_price, $key, $rates[$key], $price);
            $taxes[$key] += $tax_amount;
        }
        $taxes = array_map(array(__CLASS__, 'round'), $taxes);
        return $taxes;
    }
    public static function calc_exclusive_tax($price, $rates)
    {
        $taxes = array();
        if (!empty($rates)) {
            foreach ($rates as $key => $rate) {
                if ('yes' === $rate['compound']) {
                    continue;
                }
                $tax_amount = $price * ($rate['rate'] / 100);
                $tax_amount = apply_filters('woocommerce_price_ex_tax_amount', $tax_amount, $key, $rate, $price);
                if (!isset($taxes[$key])) {
                    $taxes[$key] = $tax_amount;
                } else {
                    $taxes[$key] += $tax_amount;
                }
            }
            $pre_compound_total = array_sum($taxes);
            foreach ($rates as $key => $rate) {
                if ('no' === $rate['compound']) {
                    continue;
                }
                $the_price_inc_tax = $price + $pre_compound_total;
                $tax_amount = $the_price_inc_tax * ($rate['rate'] / 100);
                $tax_amount = apply_filters('woocommerce_price_ex_tax_amount', $tax_amount, $key, $rate, $price, $the_price_inc_tax, $pre_compound_total);
                if (!isset($taxes[$key])) {
                    $taxes[$key] = $tax_amount;
                } else {
                    $taxes[$key] += $tax_amount;
                }
                $pre_compound_total = array_sum($taxes);
            }
        }
        $taxes = array_map(array(__CLASS__, 'round'), $taxes);
        return $taxes;
    }
    public static function find_rates($args = array())
    {
        $args = wp_parse_args($args, array('country' => '', 'state' => '', 'city' => '', 'postcode' => '', 'tax_class' => ''));
        $country = $args['country'];
        $state = $args['state'];
        $city = $args['city'];
        $postcode = wc_normalize_postcode(wc_clean($args['postcode']));
        $tax_class = $args['tax_class'];
        if (!$country) {
            return array();
        }
        $cache_key = WC_Cache_Helper::get_cache_prefix('taxes') . 'wc_tax_rates_' . md5(sprintf('%s+%s+%s+%s+%s', $country, $state, $city, $postcode, $tax_class));
        $matched_tax_rates = wp_cache_get($cache_key, 'taxes');
        if (false === $matched_tax_rates) {
            $matched_tax_rates = self::get_matched_tax_rates($country, $state, $postcode, $city, $tax_class);
            wp_cache_set($cache_key, $matched_tax_rates, 'taxes');
        }
        return apply_filters('woocommerce_find_rates', $matched_tax_rates, $args);
    }
    public static function find_shipping_rates($args = array())
    {
        $rates = self::find_rates($args);
        $shipping_rates = array();
        if (is_array($rates)) {
            foreach ($rates as $key => $rate) {
                if ('yes' === $rate['shipping']) {
                    $shipping_rates[$key] = $rate;
                }
            }
        }
        return $shipping_rates;
    }
    private static function sort_rates_callback($rate1, $rate2)
    {
        if ($rate1->tax_rate_priority !== $rate2->tax_rate_priority) {
            return $rate1->tax_rate_priority < $rate2->tax_rate_priority ? -1 : 1;
        }
        if ($rate1->tax_rate_country !== $rate2->tax_rate_country) {
            if ('' === $rate1->tax_rate_country) {
                return 1;
            }
            if ('' === $rate2->tax_rate_country) {
                return -1;
            }
            return strcmp($rate1->tax_rate_country, $rate2->tax_rate_country) > 0 ? 1 : -1;
        }
        if ($rate1->tax_rate_state !== $rate2->tax_rate_state) {
            if ('' === $rate1->tax_rate_state) {
                return 1;
            }
            if ('' === $rate2->tax_rate_state) {
                return -1;
            }
            return strcmp($rate1->tax_rate_state, $rate2->tax_rate_state) > 0 ? 1 : -1;
        }
        if (isset($rate1->postcode_count, $rate2->postcode_count) && $rate1->postcode_count !== $rate2->postcode_count) {
            return $rate1->postcode_count < $rate2->postcode_count ? 1 : -1;
        }
        if (isset($rate1->city_count, $rate2->city_count) && $rate1->city_count !== $rate2->city_count) {
            return $rate1->city_count < $rate2->city_count ? 1 : -1;
        }
        return $rate1->tax_rate_id < $rate2->tax_rate_id ? -1 : 1;
    }
    private static function sort_rates($rates)
    {
        uasort($rates, __CLASS__ . '::sort_rates_callback');
        $i = 0;
        foreach ($rates as $key => $rate) {
            $rates[$key]->tax_rate_order = $i++;
        }
        return $rates;
    }
    private static function get_matched_tax_rates($country, $state, $postcode, $city, $tax_class)
    {
        global $wpdb;
        $criteria = array();
        $criteria[] = $wpdb->prepare("tax_rate_country IN ( %s, '' )", strtoupper($country));
        $criteria[] = $wpdb->prepare("tax_rate_state IN ( %s, '' )", strtoupper($state));
        $criteria[] = $wpdb->prepare('tax_rate_class = %s', sanitize_title($tax_class));
        $postcode_search = wc_get_wildcard_postcodes($postcode, $country);
        $postcode_ranges = $wpdb->get_results("SELECT tax_rate_id, location_code FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE location_type = 'postcode' AND location_code LIKE '%...%';");
        if ($postcode_ranges) {
            $matches = wc_postcode_location_matcher($postcode, $postcode_ranges, 'tax_rate_id', 'location_code', $country);
            if (!empty($matches)) {
                foreach ($matches as $matched_postcodes) {
                    $postcode_search = array_merge($postcode_search, $matched_postcodes);
                }
            }
        }
        $postcode_search = array_unique($postcode_search);
        $locations_criteria = array();
        $locations_criteria[] = 'locations.location_type IS NULL';
        $locations_criteria[] = "\n\t\t\tlocations.location_type = 'postcode' AND locations.location_code IN ('" . implode("','", array_map('esc_sql', $postcode_search)) . "')\n\t\t\tAND (\n\t\t\t\t( locations2.location_type = 'city' AND locations2.location_code = '" . esc_sql(strtoupper($city)) . "' )\n\t\t\t\tOR NOT EXISTS (\n\t\t\t\t\tSELECT sub.tax_rate_id FROM {$wpdb->prefix}woocommerce_tax_rate_locations as sub\n\t\t\t\t\tWHERE sub.location_type = 'city'\n\t\t\t\t\tAND sub.tax_rate_id = tax_rates.tax_rate_id\n\t\t\t\t)\n\t\t\t)\n\t\t";
        $locations_criteria[] = "\n\t\t\tlocations.location_type = 'city' AND locations.location_code = '" . esc_sql(strtoupper($city)) . "'\n\t\t\tAND NOT EXISTS (\n\t\t\t\tSELECT sub.tax_rate_id FROM {$wpdb->prefix}woocommerce_tax_rate_locations as sub\n\t\t\t\tWHERE sub.location_type = 'postcode'\n\t\t\t\tAND sub.tax_rate_id = tax_rates.tax_rate_id\n\t\t\t)\n\t\t";
        $criteria[] = '( ( ' . implode(' ) OR ( ', $locations_criteria) . ' ) )';
        $criteria_string = implode(' AND ', $criteria);
        $found_rates = $wpdb->get_results("\n\t\t\tSELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count\n\t\t\tFROM {$wpdb->prefix}woocommerce_tax_rates as tax_rates\n\t\t\tLEFT OUTER JOIN {$wpdb->prefix}woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id\n\t\t\tLEFT OUTER JOIN {$wpdb->prefix}woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id\n\t\t\tWHERE 1=1 AND {$criteria_string}\n\t\t\tGROUP BY tax_rates.tax_rate_id\n\t\t\tORDER BY tax_rates.tax_rate_priority\n\t\t\t");
        $found_rates = self::sort_rates($found_rates);
        $matched_tax_rates = array();
        $found_priority = array();
        foreach ($found_rates as $found_rate) {
            if (in_array($found_rate->tax_rate_priority, $found_priority, true)) {
                continue;
            }
            $matched_tax_rates[$found_rate->tax_rate_id] = array('rate' => (float) $found_rate->tax_rate, 'label' => $found_rate->tax_rate_name, 'shipping' => $found_rate->tax_rate_shipping ? 'yes' : 'no', 'compound' => $found_rate->tax_rate_compound ? 'yes' : 'no');
            $found_priority[] = $found_rate->tax_rate_priority;
        }
        return apply_filters('woocommerce_matched_tax_rates', $matched_tax_rates, $country, $state, $postcode, $city, $tax_class);
    }
    public static function get_tax_location($tax_class = '', $customer = null)
    {
        $location = array();
        if (is_null($customer) && WC()->customer) {
            $customer = WC()->customer;
        }
        if (!empty($customer)) {
            $location = $customer->get_taxable_address();
        } elseif (wc_prices_include_tax() || 'base' === get_option('woocommerce_default_customer_address') || 'base' === get_option('woocommerce_tax_based_on')) {
            $location = array(WC()->countries->get_base_country(), WC()->countries->get_base_state(), WC()->countries->get_base_postcode(), WC()->countries->get_base_city());
        }
        return apply_filters('woocommerce_get_tax_location', $location, $tax_class, $customer);
    }
    public static function get_rates($tax_class = '', $customer = null)
    {
        $tax_class = sanitize_title($tax_class);
        $location = self::get_tax_location($tax_class, $customer);
        return self::get_rates_from_location($tax_class, $location, $customer);
    }
    public static function get_rates_from_location($tax_class, $location, $customer = null)
    {
        $tax_class = sanitize_title($tax_class);
        $matched_tax_rates = array();
        if (count($location) === 4) {
            list($country, $state, $postcode, $city) = $location;
            $matched_tax_rates = self::find_rates(array('country' => $country, 'state' => $state, 'postcode' => $postcode, 'city' => $city, 'tax_class' => $tax_class));
        }
        return apply_filters('woocommerce_matched_rates', $matched_tax_rates, $tax_class, $customer);
    }
    public static function get_base_tax_rates($tax_class = '')
    {
        return apply_filters('woocommerce_base_tax_rates', self::find_rates(array('country' => WC()->countries->get_base_country(), 'state' => WC()->countries->get_base_state(), 'postcode' => WC()->countries->get_base_postcode(), 'city' => WC()->countries->get_base_city(), 'tax_class' => $tax_class)), $tax_class);
    }
    public static function get_shop_base_rate($tax_class = '')
    {
        return self::get_base_tax_rates($tax_class);
    }
    public static function get_shipping_tax_rates($tax_class = null, $customer = null)
    {
        $shipping_tax_class = get_option('woocommerce_shipping_tax_class');
        if ('inherit' !== $shipping_tax_class) {
            $tax_class = $shipping_tax_class;
        }
        $location = self::get_tax_location($tax_class, $customer);
        $matched_tax_rates = array();
        if (4 === count($location)) {
            list($country, $state, $postcode, $city) = $location;
            if (!is_null($tax_class)) {
                $matched_tax_rates = self::find_shipping_rates(array('country' => $country, 'state' => $state, 'postcode' => $postcode, 'city' => $city, 'tax_class' => $tax_class));
            } elseif (WC()->cart->get_cart()) {
                $cart_tax_classes = WC()->cart->get_cart_item_tax_classes_for_shipping();
                if (empty($cart_tax_classes)) {
                    return array();
                }
                if (count($cart_tax_classes) > 1 && !in_array('', $cart_tax_classes, true)) {
                    $tax_classes = self::get_tax_class_slugs();
                    foreach ($tax_classes as $tax_class) {
                        if (in_array($tax_class, $cart_tax_classes, true)) {
                            $matched_tax_rates = self::find_shipping_rates(array('country' => $country, 'state' => $state, 'postcode' => $postcode, 'city' => $city, 'tax_class' => $tax_class));
                            break;
                        }
                    }
                } elseif (1 === count($cart_tax_classes)) {
                    $matched_tax_rates = self::find_shipping_rates(array('country' => $country, 'state' => $state, 'postcode' => $postcode, 'city' => $city, 'tax_class' => $cart_tax_classes[0]));
                }
            }
            if (!count($matched_tax_rates)) {
                $matched_tax_rates = self::find_shipping_rates(array('country' => $country, 'state' => $state, 'postcode' => $postcode, 'city' => $city));
            }
        }
        return $matched_tax_rates;
    }
    public static function is_compound($key_or_rate)
    {
        global $wpdb;
        if (is_object($key_or_rate)) {
            $key = $key_or_rate->tax_rate_id;
            $compound = $key_or_rate->tax_rate_compound;
        } else {
            $key = $key_or_rate;
            $compound = (bool) $wpdb->get_var($wpdb->prepare("SELECT tax_rate_compound FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %s", $key));
        }
        return (bool) apply_filters('woocommerce_rate_compound', $compound, $key);
    }
    public static function get_rate_label($key_or_rate)
    {
        global $wpdb;
        if (is_object($key_or_rate)) {
            $key = $key_or_rate->tax_rate_id;
            $rate_name = $key_or_rate->tax_rate_name;
        } else {
            $key = $key_or_rate;
            $rate_name = $wpdb->get_var($wpdb->prepare("SELECT tax_rate_name FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %s", $key));
        }
        if (!$rate_name) {
            $rate_name = WC()->countries->tax_or_vat();
        }
        return apply_filters('woocommerce_rate_label', $rate_name, $key);
    }
    public static function get_rate_percent($key_or_rate)
    {
        $rate_percent_value = self::get_rate_percent_value($key_or_rate);
        $tax_rate_id = is_object($key_or_rate) ? $key_or_rate->tax_rate_id : $key_or_rate;
        return apply_filters('woocommerce_rate_percent', $rate_percent_value . '%', $tax_rate_id);
    }
    public static function get_rate_percent_value($key_or_rate)
    {
        global $wpdb;
        if (is_object($key_or_rate)) {
            $tax_rate = $key_or_rate->tax_rate;
        } else {
            $key = $key_or_rate;
            $tax_rate = $wpdb->get_var($wpdb->prepare("SELECT tax_rate FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %s", $key));
        }
        return floatval($tax_rate);
    }
    public static function get_rate_code($key_or_rate)
    {
        global $wpdb;
        if (is_object($key_or_rate)) {
            $key = $key_or_rate->tax_rate_id;
            $rate = $key_or_rate;
        } else {
            $key = $key_or_rate;
            $rate = $wpdb->get_row($wpdb->prepare("SELECT tax_rate_country, tax_rate_state, tax_rate_name, tax_rate_priority FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %s", $key));
        }
        $code_string = '';
        if (null !== $rate) {
            $code = array();
            $code[] = $rate->tax_rate_country;
            $code[] = $rate->tax_rate_state;
            $code[] = $rate->tax_rate_name ? $rate->tax_rate_name : 'TAX';
            $code[] = absint($rate->tax_rate_priority);
            $code_string = strtoupper(implode('-', array_filter($code)));
        }
        return apply_filters('woocommerce_rate_code', $code_string, $key);
    }
    public static function get_tax_total($taxes)
    {
        return array_sum($taxes);
    }
    public static function get_tax_rate_classes()
    {
        global $wpdb;
        $cache_key = 'tax-rate-classes';
        $tax_rate_classes = wp_cache_get($cache_key, 'taxes');
        if (!is_array($tax_rate_classes)) {
            $tax_rate_classes = $wpdb->get_results("\n\t\t\t\tSELECT * FROM {$wpdb->wc_tax_rate_classes} ORDER BY name;\n\t\t\t\t");
            wp_cache_set($cache_key, $tax_rate_classes, 'taxes');
        }
        return $tax_rate_classes;
    }
    public static function get_tax_classes()
    {
        return wp_list_pluck(self::get_tax_rate_classes(), 'name');
    }
    public static function get_tax_class_slugs()
    {
        return wp_list_pluck(self::get_tax_rate_classes(), 'slug');
    }
    public static function create_tax_class($name, $slug = '')
    {
        global $wpdb;
        if (empty($name)) {
            return new WP_Error('tax_class_invalid_name', __('Tax class requires a valid name', 'woocommerce'));
        }
        $existing = self::get_tax_classes();
        $existing_slugs = self::get_tax_class_slugs();
        $name = wc_clean($name);
        if (in_array($name, $existing, true)) {
            return new WP_Error('tax_class_exists', __('Tax class already exists', 'woocommerce'));
        }
        if (!$slug) {
            $slug = sanitize_title($name);
        }
        if (!$slug) {
            return new WP_Error('tax_class_slug_invalid', __('Tax class slug is invalid', 'woocommerce'));
        }
        if (in_array($slug, $existing_slugs, true)) {
            return new WP_Error('tax_class_slug_exists', __('Tax class slug already exists', 'woocommerce'));
        }
        $insert = $wpdb->insert($wpdb->wc_tax_rate_classes, array('name' => $name, 'slug' => $slug));
        if (is_wp_error($insert)) {
            return new WP_Error('tax_class_insert_error', $insert->get_error_message());
        }
        wp_cache_delete('tax-rate-classes', 'taxes');
        return array('name' => $name, 'slug' => $slug);
    }
    public static function get_tax_class_by($field, $item)
    {
        if (!in_array($field, array('id', 'name', 'slug'), true)) {
            return new WP_Error('invalid_field', __('Invalid field', 'woocommerce'));
        }
        if ('id' === $field) {
            $field = 'tax_rate_class_id';
        }
        $matches = wp_list_filter(self::get_tax_rate_classes(), array($field => $item));
        if (!$matches) {
            return false;
        }
        $tax_class = current($matches);
        return array('name' => $tax_class->name, 'slug' => $tax_class->slug);
    }
    public static function delete_tax_class_by($field, $item)
    {
        global $wpdb;
        if (!in_array($field, array('id', 'name', 'slug'), true)) {
            return new WP_Error('invalid_field', __('Invalid field', 'woocommerce'));
        }
        $tax_class = self::get_tax_class_by($field, $item);
        if (!$tax_class) {
            return new WP_Error('invalid_tax_class', __('Invalid tax class', 'woocommerce'));
        }
        if ('id' === $field) {
            $field = 'tax_rate_class_id';
        }
        $delete = $wpdb->delete($wpdb->wc_tax_rate_classes, array($field => $item));
        if ($delete) {
            $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_class = %s;", $tax_class['slug']));
            $wpdb->query("DELETE locations FROM {$wpdb->prefix}woocommerce_tax_rate_locations locations LEFT JOIN {$wpdb->prefix}woocommerce_tax_rates rates ON rates.tax_rate_id = locations.tax_rate_id WHERE rates.tax_rate_id IS NULL;");
        }
        wp_cache_delete('tax-rate-classes', 'taxes');
        WC_Cache_Helper::invalidate_cache_group('taxes');
        return (bool) $delete;
    }
    private static function format_tax_rate_city($city)
    {
        return strtoupper(trim($city));
    }
    private static function format_tax_rate_state($state)
    {
        $state = strtoupper($state);
        return '*' === $state ? '' : $state;
    }
    private static function format_tax_rate_country($country)
    {
        $country = strtoupper($country);
        return '*' === $country ? '' : $country;
    }
    private static function format_tax_rate_name($name)
    {
        return $name ? $name : __('Tax', 'woocommerce');
    }
    private static function format_tax_rate($rate)
    {
        return number_format((float) $rate, 4, '.', '');
    }
    private static function format_tax_rate_priority($priority)
    {
        return absint($priority);
    }
    public static function format_tax_rate_class($class)
    {
        $class = sanitize_title($class);
        $classes = self::get_tax_class_slugs();
        if (!in_array($class, $classes, true)) {
            $class = '';
        }
        return 'standard' === $class ? '' : $class;
    }
    private static function prepare_tax_rate($tax_rate)
    {
        foreach ($tax_rate as $key => $value) {
            if (method_exists(__CLASS__, 'format_' . $key)) {
                if ('tax_rate_state' === $key) {
                    $tax_rate[$key] = call_user_func(array(__CLASS__, 'format_' . $key), sanitize_key($value));
                } else {
                    $tax_rate[$key] = call_user_func(array(__CLASS__, 'format_' . $key), $value);
                }
            }
        }
        return $tax_rate;
    }
    public static function _insert_tax_rate($tax_rate)
    {
        global $wpdb;
        $wpdb->insert($wpdb->prefix . 'woocommerce_tax_rates', self::prepare_tax_rate($tax_rate));
        $tax_rate_id = $wpdb->insert_id;
        WC_Cache_Helper::invalidate_cache_group('taxes');
        do_action('woocommerce_tax_rate_added', $tax_rate_id, $tax_rate);
        return $tax_rate_id;
    }
    public static function _get_tax_rate($tax_rate_id, $output_type = ARRAY_A)
    {
        global $wpdb;
        return $wpdb->get_row($wpdb->prepare("\n\t\t\t\t\tSELECT *\n\t\t\t\t\tFROM {$wpdb->prefix}woocommerce_tax_rates\n\t\t\t\t\tWHERE tax_rate_id = %d\n\t\t\t\t", $tax_rate_id), $output_type);
    }
    public static function _update_tax_rate($tax_rate_id, $tax_rate)
    {
        global $wpdb;
        $tax_rate_id = absint($tax_rate_id);
        $wpdb->update($wpdb->prefix . 'woocommerce_tax_rates', self::prepare_tax_rate($tax_rate), array('tax_rate_id' => $tax_rate_id));
        WC_Cache_Helper::invalidate_cache_group('taxes');
        do_action('woocommerce_tax_rate_updated', $tax_rate_id, $tax_rate);
    }
    public static function _delete_tax_rate($tax_rate_id)
    {
        global $wpdb;
        $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE tax_rate_id = %d;", $tax_rate_id));
        $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %d;", $tax_rate_id));
        WC_Cache_Helper::invalidate_cache_group('taxes');
        do_action('woocommerce_tax_rate_deleted', $tax_rate_id);
    }
    public static function _update_tax_rate_postcodes($tax_rate_id, $postcodes)
    {
        if (!is_array($postcodes)) {
            $postcodes = explode(';', $postcodes);
        }
        foreach ($postcodes as $key => $postcode) {
            $postcodes[$key] = strtoupper(trim(str_replace(chr(226) . chr(128) . chr(166), '...', $postcode)));
        }
        self::update_tax_rate_locations($tax_rate_id, array_diff(array_filter($postcodes), array('*')), 'postcode');
    }
    public static function _update_tax_rate_cities($tax_rate_id, $cities)
    {
        if (!is_array($cities)) {
            $cities = explode(';', $cities);
        }
        $cities = array_filter(array_diff(array_map(array(__CLASS__, 'format_tax_rate_city'), $cities), array('*')));
        self::update_tax_rate_locations($tax_rate_id, $cities, 'city');
    }
    private static function update_tax_rate_locations($tax_rate_id, $values, $type)
    {
        global $wpdb;
        $tax_rate_id = absint($tax_rate_id);
        $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE tax_rate_id = %d AND location_type = %s;", $tax_rate_id, $type));
        if (count($values) > 0) {
            $sql = "( '" . implode("', {$tax_rate_id}, '" . esc_sql($type) . "' ),( '", array_map('esc_sql', $values)) . "', {$tax_rate_id}, '" . esc_sql($type) . "' )";
            $wpdb->query("INSERT INTO {$wpdb->prefix}woocommerce_tax_rate_locations ( location_code, tax_rate_id, location_type ) VALUES {$sql};");
        }
        WC_Cache_Helper::invalidate_cache_group('taxes');
    }
    public static function get_rates_for_tax_class($tax_class)
    {
        global $wpdb;
        $tax_class = self::format_tax_rate_class($tax_class);
        $rates = $wpdb->get_results($wpdb->prepare("SELECT * FROM `{$wpdb->prefix}woocommerce_tax_rates` WHERE `tax_rate_class` = %s;", $tax_class));
        $locations = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}woocommerce_tax_rate_locations`");
        if (!empty($rates)) {
            $rates = array_combine(wp_list_pluck($rates, 'tax_rate_id'), $rates);
        }
        foreach ($locations as $location) {
            if (!isset($rates[$location->tax_rate_id])) {
                continue;
            }
            if (!isset($rates[$location->tax_rate_id]->{$location->location_type})) {
                $rates[$location->tax_rate_id]->{$location->location_type} = array();
            }
            $rates[$location->tax_rate_id]->{$location->location_type}[] = $location->location_code;
        }
        foreach ($rates as $rate_id => $rate) {
            $rates[$rate_id]->postcode_count = isset($rates[$rate_id]->postcode) ? count($rates[$rate_id]->postcode) : 0;
            $rates[$rate_id]->city_count = isset($rates[$rate_id]->city) ? count($rates[$rate_id]->city) : 0;
        }
        $rates = self::sort_rates($rates);
        return $rates;
    }
}
WC_Tax::init();