PHP WC_Cache_Helper::get_cache_prefix方法代码示例

 /**
  * Find a matching zone for a given package.
  * @since  2.6.0
  * @uses   wc_make_numeric_postcode()
  * @param  object $package
  * @return WC_Shipping_Zone
  */
 public static function get_zone_matching_package($package)
 {
     global $wpdb;
     $country = strtoupper(wc_clean($package['destination']['country']));
     $state = strtoupper(wc_clean($package['destination']['state']));
     $continent = strtoupper(wc_clean(WC()->countries->get_continent_code_for_country($country)));
     $postcode = wc_normalize_postcode(wc_clean($package['destination']['postcode']));
     $cache_key = WC_Cache_Helper::get_cache_prefix('shipping_zones') . 'wc_shipping_zone_' . md5(sprintf('%s+%s+%s', $country, $state, $postcode));
     $matching_zone_id = wp_cache_get($cache_key, 'shipping_zones');
     if (false === $matching_zone_id) {
         // Work out criteria for our zone search
         $criteria = array();
         $criteria[] = $wpdb->prepare("( ( location_type = 'country' AND location_code = %s )", $country);
         $criteria[] = $wpdb->prepare("OR ( location_type = 'state' AND location_code = %s )", $country . ':' . $state);
         $criteria[] = $wpdb->prepare("OR ( location_type = 'continent' AND location_code = %s ) )", $continent);
         // Postcode range and wildcard matching
         $postcode_locations = $wpdb->get_results("SELECT zone_id, location_code FROM {$wpdb->prefix}woocommerce_shipping_zone_locations WHERE location_type = 'postcode';");
         if ($postcode_locations) {
             $zone_ids_with_postcode_rules = array_map('absint', wp_list_pluck($postcode_locations, 'zone_id'));
             $matches = wc_postcode_location_matcher($postcode, $postcode_locations, 'zone_id', 'location_code');
             $do_not_match = array_unique(array_diff($zone_ids_with_postcode_rules, array_keys($matches)));
             if (!empty($do_not_match)) {
                 $criteria[] = "AND zones.zone_id NOT IN (" . implode(',', $do_not_match) . ")";
             }
         }
         // Get matching zones
         $matching_zone_id = $wpdb->get_var("\n\t\t\t\tSELECT zones.zone_id FROM {$wpdb->prefix}woocommerce_shipping_zones as zones\n\t\t\t\tLEFT OUTER JOIN {$wpdb->prefix}woocommerce_shipping_zone_locations as locations ON zones.zone_id = locations.zone_id\n\t\t\t\tWHERE " . implode(' ', $criteria) . "\n\t\t\t\tORDER BY zone_order ASC LIMIT 1\n\t\t\t");
         wp_cache_set($cache_key, $matching_zone_id, 'shipping_zones');
     }
     return new WC_Shipping_Zone($matching_zone_id ? $matching_zone_id : 0);
 }

 /**
  * Get all item meta data in array format in the order it was saved. Does not group meta by key like get_item_meta().
  *
  * @param mixed $order_item_id
  * @return array of objects
  */
 public function get_item_meta_array($order_item_id)
 {
     global $wpdb;
     // Get cache key - uses get_cache_prefix to invalidate when needed
     $cache_key = WC_Cache_Helper::get_cache_prefix('orders') . 'item_meta_array_' . $order_item_id;
     $item_meta_array = wp_cache_get($cache_key, 'orders');
     if (false === $item_meta_array) {
         $item_meta_array = array();
         $metadata = $wpdb->get_results($wpdb->prepare("SELECT meta_key, meta_value, meta_id FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE order_item_id = %d ORDER BY meta_id", absint($order_item_id)));
         foreach ($metadata as $metadata_row) {
             $item_meta_array[$metadata_row->meta_id] = (object) array('key' => $metadata_row->meta_key, 'value' => $metadata_row->meta_value);
         }
         wp_cache_set($cache_key, $item_meta_array, 'orders');
     }
     return $item_meta_array;
 }

 /**
  * This function updates the database for the delivery details and adds delivery fields on the Order Received page,
  * WooCommerce->Orders when an order is placed for WooCommerce version greater than 2.0.
  */
 function prdd_lite_order_item_meta($item_meta, $cart_item)
 {
     if (version_compare(WOOCOMMERCE_VERSION, "2.0.0") < 0) {
         return;
     }
     // Add the fields
     global $wpdb, $woocommerce;
     foreach ($woocommerce->cart->get_cart() as $cart_item_key => $values) {
         $_product = $values['data'];
         if (isset($values['prdd_lite_delivery'])) {
             $delivery = $values['prdd_lite_delivery'];
         }
         $quantity = $values['quantity'];
         $post_id = $this->prdd_lite_get_product_id($values['product_id']);
         $post_title = $_product->get_title();
         $query = "SELECT order_item_id,order_id FROM `" . $wpdb->prefix . "woocommerce_order_items`\n\t\t\t\t\t\tWHERE order_id = %s AND order_item_name = %s";
         $results = $wpdb->get_results($wpdb->prepare($query, $item_meta, $post_title));
         $order_item_ids[] = $results[0]->order_item_id;
         $order_id = $results[0]->order_id;
         $order_obj = new WC_order($order_id);
         $details = $product_ids = array();
         $order_items = $order_obj->get_items();
         if (isset($values['prdd_lite_delivery'])) {
             $prdd_settings = get_post_meta($post_id, '_woo_prdd_lite_enable_delivery_date', true);
             $details = array();
             if (isset($delivery[0]['delivery_date']) && $delivery[0]['delivery_date'] != "") {
                 $name = "Delivery Date";
                 $date_select = $delivery[0]['delivery_date'];
                 wc_add_order_item_meta($results[0]->order_item_id, $name, sanitize_text_field($date_select, true));
             }
             if (array_key_exists('delivery_hidden_date', $delivery[0]) && $delivery[0]['delivery_hidden_date'] != "") {
                 $date_booking = date('Y-m-d', strtotime($delivery[0]['delivery_hidden_date']));
                 wc_add_order_item_meta($results[0]->order_item_id, '_prdd_lite_date', sanitize_text_field($date_booking, true));
             }
         }
         if (version_compare(WOOCOMMERCE_VERSION, "2.5") < 0) {
             continue;
         } else {
             // Code where the Delivery dates are not displayed in the customer new order email from WooCommerce version 2.5
             $cache_key = WC_Cache_Helper::get_cache_prefix('orders') . 'item_meta_array_' . $results[0]->order_item_id;
             $item_meta_array = wp_cache_get($cache_key, 'orders');
             if (false !== $item_meta_array) {
                 $metadata = $wpdb->get_results($wpdb->prepare("SELECT meta_key, meta_value, meta_id FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE order_item_id = %d AND meta_key IN (%s,%s) ORDER BY meta_id", absint($results[0]->order_item_id), "Delivery Date", '_prdd_lite_date'));
                 foreach ($metadata as $metadata_row) {
                     $item_meta_array[$metadata_row->meta_id] = (object) array('key' => $metadata_row->meta_key, 'value' => $metadata_row->meta_value);
                 }
                 wp_cache_set($cache_key, $item_meta_array, 'orders');
             }
         }
     }
 }

/**
 * Get coupon code by ID.
 *
 * @since 2.7.0
 * @param string $code
 * @param int $exclude Used to exclude an ID from the check if you're checking existance.
 * @return int
 */
function wc_get_coupon_id_by_code($code, $exclude = 0)
{
    global $wpdb;
    $ids = wp_cache_get(WC_Cache_Helper::get_cache_prefix('coupons') . 'coupon_id_from_code_' . $code, 'coupons');
    if (false === $ids) {
        $sql = $wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_title = %s AND post_type = 'shop_coupon' AND post_status = 'publish' ORDER BY post_date DESC;", $code);
        $ids = $wpdb->get_col($sql);
        if ($ids) {
            wp_cache_set(WC_Cache_Helper::get_cache_prefix('coupons') . 'coupon_id_from_code_' . $code, $ids, 'coupons');
        }
    }
    $ids = array_diff(array_filter(array_map('absint', (array) $ids)), array($exclude));
    return apply_filters('woocommerce_get_coupon_id_from_code', absint(current($ids)), $code, $exclude);
}

/**
 * Return the orders count of a specific order status.
 *
 * @param string $status
 * @return int
 */
function wc_orders_count($status)
{
    $count = 0;
    $status = 'wc-' . $status;
    $order_statuses = array_keys(wc_get_order_statuses());
    if (!in_array($status, $order_statuses)) {
        return 0;
    }
    $cache_key = WC_Cache_Helper::get_cache_prefix('orders') . $status;
    $cached_count = wp_cache_get($cache_key, 'counts');
    if (false !== $cached_count) {
        return $cached_count;
    }
    foreach (wc_get_order_types('order-count') as $type) {
        $data_store = WC_Data_Store::load('shop_order' === $type ? 'order' : $type);
        if ($data_store) {
            $count += $data_store->get_order_count($status);
        }
    }
    wp_cache_set($cache_key, $count, 'counts');
    return $count;
}

 /**
  * Searches for all matching country/state/postcode tax rates.
  *
  * @param array $args
  * @return array
  */
 public static function find_rates($args = array())
 {
     $args = wp_parse_args($args, array('country' => '', 'state' => '', 'city' => '', 'postcode' => '', 'tax_class' => ''));
     extract($args, EXTR_SKIP);
     if (!$country) {
         return array();
     }
     $postcode = wc_normalize_postcode(wc_clean($postcode));
     $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);
 }

/**
 * Get coupon code by ID.
 *
 * @since 2.7.0
 * @param string $code
 * @param int $exclude Used to exclude an ID from the check if you're checking existance.
 * @return int
 */
function wc_get_coupon_id_by_code($code, $exclude = 0)
{
    $data_store = WC_Data_Store::load('coupon');
    $ids = wp_cache_get(WC_Cache_Helper::get_cache_prefix('coupons') . 'coupon_id_from_code_' . $code, 'coupons');
    if (false === $ids) {
        $ids = $data_store->get_ids_by_code($code);
        if ($ids) {
            wp_cache_set(WC_Cache_Helper::get_cache_prefix('coupons') . 'coupon_id_from_code_' . $code, $ids, 'coupons');
        }
    }
    $ids = array_diff(array_filter(array_map('absint', (array) $ids)), array($exclude));
    return apply_filters('woocommerce_get_coupon_id_from_code', absint(current($ids)), $code, $exclude);
}

/**
 * WooCommerce Order Item Meta API - Delete term meta.
 *
 * @access public
 * @param mixed $item_id
 * @param mixed $meta_key
 * @param string $meta_value (default: '')
 * @param bool $delete_all (default: false)
 * @return bool
 */
function wc_delete_order_item_meta($item_id, $meta_key, $meta_value = '', $delete_all = false)
{
    if (delete_metadata('order_item', $item_id, $meta_key, $meta_value, $delete_all)) {
        $cache_key = WC_Cache_Helper::get_cache_prefix('orders') . 'item_meta_array_' . $item_id;
        wp_cache_delete($cache_key, 'orders');
        return true;
    }
    return false;
}

/**
 * Return the orders count of a specific order status.
 *
 * @access public
 * @param string $status
 * @return int
 */
function wc_orders_count($status)
{
    global $wpdb;
    $count = 0;
    $status = 'wc-' . $status;
    $order_statuses = array_keys(wc_get_order_statuses());
    if (!in_array($status, $order_statuses)) {
        return 0;
    }
    $cache_key = WC_Cache_Helper::get_cache_prefix('orders') . $status;
    $cached_count = wp_cache_get($cache_key, 'counts');
    if (false !== $cached_count) {
        return $cached_count;
    }
    foreach (wc_get_order_types('order-count') as $type) {
        $query = "SELECT COUNT( * ) FROM {$wpdb->posts} WHERE post_type = %s AND post_status = %s";
        $count += $wpdb->get_var($wpdb->prepare($query, $type, $status));
    }
    wp_cache_set($cache_key, $count, 'counts');
    return $count;
}

 /**
  * Find a matching zone for a given package.
  * @since  2.6.0
  * @uses   wc_make_numeric_postcode()
  * @param  object $package
  * @return WC_Shipping_Zone
  */
 public static function get_zone_matching_package($package)
 {
     global $wpdb;
     $country = strtoupper(wc_clean($package['destination']['country']));
     $state = strtoupper(wc_clean($package['destination']['state']));
     $continent = strtoupper(wc_clean(WC()->countries->get_continent_code_for_country($country)));
     $postcode = strtoupper(wc_clean($package['destination']['postcode']));
     $valid_postcodes = array_map('wc_clean', self::_get_wildcard_postcodes($postcode));
     $cache_key = WC_Cache_Helper::get_cache_prefix('shipping_zones') . 'wc_shipping_zone_' . md5(sprintf('%s+%s+%s', $country, $state, $postcode));
     $matching_zone_id = wp_cache_get($cache_key, 'shipping_zones');
     if (false === $matching_zone_id) {
         // Work out criteria for our zone search
         $criteria = array();
         $criteria[] = $wpdb->prepare("( ( location_type = 'country' AND location_code = %s )", $country);
         $criteria[] = $wpdb->prepare("OR ( location_type = 'state' AND location_code = %s )", $country . ':' . $state);
         $criteria[] = $wpdb->prepare("OR ( location_type = 'continent' AND location_code = %s ) )", $continent);
         // Postcode range and wildcard matching
         $postcode_locations = $wpdb->get_results("SELECT zone_id, location_code FROM {$wpdb->prefix}woocommerce_shipping_zone_locations WHERE location_type = 'postcode';");
         if ($postcode_locations) {
             $zone_ids_with_postcode_rules = array_map('absint', wp_list_pluck($postcode_locations, 'zone_id'));
             $zone_id_matches = array();
             foreach ($postcode_locations as $postcode_location) {
                 $postcode_to_match = trim(strtoupper($postcode_location->location_code));
                 // Ranges
                 if (strstr('-', $postcode_to_match)) {
                     $range = array_map('trim', explode('-', $postcode_to_match));
                     if (sizeof($range) != 2) {
                         continue;
                     }
                     if (is_numeric($range[0]) && is_numeric($range[1])) {
                         $encoded_postcode = $postcode;
                         $min = $range[0];
                         $max = $range[1];
                     } else {
                         $min = wc_make_numeric_postcode($range[0]);
                         $max = wc_make_numeric_postcode($range[1]);
                         $min = str_pad($min, $encoded_postcode_len, '0');
                         $max = str_pad($max, $encoded_postcode_len, '9');
                     }
                     if ($encoded_postcode >= $min && $encoded_postcode <= $max) {
                         $zone_id_matches[] = absint($postcode_location->zone_id);
                     }
                     // Wildcard/standard
                 } elseif (in_array($postcode_to_match, $valid_postcodes)) {
                     $zone_id_matches[] = absint($postcode_location->zone_id);
                 }
             }
             $do_not_match = array_unique(array_diff($zone_ids_with_postcode_rules, $zone_id_matches));
             if ($do_not_match) {
                 $criteria[] = "AND zones.zone_id NOT IN (" . implode(',', $do_not_match) . ")";
             }
         }
         // Get matching zones
         $matching_zone_id = $wpdb->get_var("\n\t\t\t\tSELECT zones.zone_id FROM {$wpdb->prefix}woocommerce_shipping_zones as zones\n\t\t\t\tLEFT OUTER JOIN {$wpdb->prefix}woocommerce_shipping_zone_locations as locations ON zones.zone_id = locations.zone_id\n\t\t\t\tWHERE " . implode(' ', $criteria) . "\n\t\t\t\tORDER BY zone_order ASC LIMIT 1\n\t\t\t");
         wp_cache_set($cache_key, $matching_zone_id, 'shipping_zones');
     }
     return new WC_Shipping_Zone($matching_zone_id ? $matching_zone_id : 0);
 }

 public function clear_wc_tax_cache($to_country, $to_state, $source_city, $source_zip)
 {
     global $woocommerce;
     if (version_compare($woocommerce->version, '2.5.0', '>=')) {
         $cache_key = WC_Cache_Helper::get_cache_prefix('taxes') . 'wc_tax_rates_' . md5(sprintf('%s+%s+%s+%s+%s', $to_country, $to_state, $source_city, wc_clean($source_zip), ''));
         wp_cache_delete($cache_key, 'taxes');
     } else {
         $valid_postcodes = $this->_get_wildcard_postcodes(wc_clean($source_zip));
         $rates_transient_key = 'wc_tax_rates_' . md5(sprintf('%s+%s+%s+%s+%s', $to_country, $to_state, $source_city, implode(',', $valid_postcodes), ''));
         delete_transient($rates_transient_key);
     }
 }

 /**
  * Read Meta Data from the database. Ignore any internal properties.
  * Uses it's own caches because get_metadata does not provide meta_ids.
  *
  * @since 2.6.0
  * @param bool $force_read True to force a new DB read (and update cache).
  */
 public function read_meta_data($force_read = false)
 {
     $this->meta_data = array();
     $cache_loaded = false;
     if (!$this->get_id()) {
         return;
     }
     if (!$this->data_store) {
         return;
     }
     if (!empty($this->cache_group)) {
         $cache_key = WC_Cache_Helper::get_cache_prefix($this->cache_group) . 'object_meta_' . $this->get_id();
     }
     if (!$force_read) {
         if (!empty($this->cache_group)) {
             $cached_meta = wp_cache_get($cache_key, $this->cache_group);
             if (false !== $cached_meta) {
                 $this->meta_data = $cached_meta;
                 $cache_loaded = true;
             }
         }
     }
     if (!$cache_loaded) {
         $raw_meta_data = $this->data_store->read_meta($this);
         if ($raw_meta_data) {
             foreach ($raw_meta_data as $meta) {
                 $this->meta_data[] = (object) array('id' => (int) $meta->meta_id, 'key' => $meta->meta_key, 'value' => maybe_unserialize($meta->meta_value));
             }
             if (!empty($this->cache_group)) {
                 wp_cache_set($cache_key, $this->meta_data, $this->cache_group);
             }
         }
     }
 }

/**
 * WooCommerce Order Item Meta API - Delete term meta.
 *
 * @access public
 * @param mixed $item_id
 * @param mixed $meta_key
 * @param string $meta_value (default: '')
 * @param bool $delete_all (default: false)
 * @return bool
 */
function wc_delete_order_item_meta($item_id, $meta_key, $meta_value = '', $delete_all = false)
{
    $data_store = WC_Data_Store::load('order-item');
    if ($data_store->delete_metadata($item_id, $meta_key, $meta_value, $delete_all)) {
        $cache_key = WC_Cache_Helper::get_cache_prefix('orders') . 'item_meta_array_' . $item_id;
        wp_cache_delete($cache_key, 'orders');
        return true;
    }
    return false;
}

 /**
  * Get a coupon ID from it's code.
  * @since 2.5.0 woocommerce_coupon_code_query was removed in favour of woocommerce_get_coupon_id_from_code filter on the return. wp_cache was also implemented.
  * @param  string $code
  * @return int
  */
 private function get_coupon_id_from_code($code)
 {
     global $wpdb;
     $coupon_id = wp_cache_get(WC_Cache_Helper::get_cache_prefix('coupons') . 'coupon_id_from_code_' . $code, 'coupons');
     if (false === $coupon_id) {
         $sql = $wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_title = %s AND post_type = 'shop_coupon' AND post_status = 'publish'", $this->code);
         $coupon_id = apply_filters('woocommerce_get_coupon_id_from_code', $wpdb->get_var($sql), $this->code);
         wp_cache_set(WC_Cache_Helper::get_cache_prefix('coupons') . 'coupon_id_from_code_' . $code, $coupon_id, 'coupons');
     }
     return absint($coupon_id);
 }

 /**
  * Read Meta Data from the database. Ignore any internal properties.
  * @since 2.6.0
  */
 protected function read_meta_data()
 {
     $this->_meta_data = array();
     $cache_loaded = false;
     if (!$this->get_id()) {
         return;
     }
     if (!empty($this->_cache_group)) {
         $cache_key = WC_Cache_Helper::get_cache_prefix($this->_cache_group) . $this->get_id();
         $cached_meta = wp_cache_get($cache_key, $this->_cache_group);
         if (false !== $cached_meta) {
             $this->_meta_data = $cached_meta;
             $cache_loaded = true;
         }
     }
     if (!$cache_loaded) {
         global $wpdb;
         $db_info = $this->_get_db_info();
         $raw_meta_data = $wpdb->get_results($wpdb->prepare("\n\t\t\t\tSELECT " . $db_info['meta_id_field'] . ", meta_key, meta_value\n\t\t\t\tFROM " . $db_info['table'] . "\n\t\t\t\tWHERE " . $db_info['object_id_field'] . "=%d AND meta_key NOT LIKE 'wp\\_%%' ORDER BY " . $db_info['meta_id_field'] . "\n\t\t\t", $this->get_id()));
         if ($raw_meta_data) {
             foreach ($raw_meta_data as $meta) {
                 if (in_array($meta->meta_key, $this->get_internal_meta_keys())) {
                     continue;
                 }
                 $this->_meta_data[] = (object) array('id' => (int) $meta->{$db_info['meta_id_field']}, 'key' => $meta->meta_key, 'value' => maybe_unserialize($meta->meta_value));
             }
         }
         if (!empty($this->_cache_group)) {
             wp_cache_set($cache_key, $this->_meta_data, $this->_cache_group);
         }
     }
 }