<?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();