Alert: This function’s access is marked private. This means it is not intended for use by plugin or theme developers, only in other core functions. It is listed here for completeness.
WC_Tax::update_tax_rate_locations( int $tax_rate_id, array $values, string $type )
Updates locations (postcode and city).
Description Description
Internal use only.
Parameters Parameters
- $tax_rate_id
-
(Required) Tax rate ID to update.
- $values
-
(Required) Values to set.
- $type
-
(Required) Location type.
Source Source
File: includes/class-wc-tax.php
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;" ); // @codingStandardsIgnoreLine.
}
WC_Cache_Helper::invalidate_cache_group( 'taxes' );
}
Changelog Changelog
| Version | Description |
|---|---|
| 2.3.0 | Introduced. |