/* ============================================================ * SHORTCODE OPTIMISÉ HOME : [tyre_list per_page="12"] * Objectif : affichage très rapide via cache HTML * ============================================================ */ if (!defined('ABSPATH')) exit; if (!function_exists('oxxo_tyre_starts_with')) { function oxxo_tyre_starts_with($value, $prefix) { return substr((string) $value, 0, strlen($prefix)) === $prefix; } } if (!function_exists('oxxo_tyre_clear_home_cache')) { function oxxo_tyre_clear_home_cache() { global $wpdb; $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_oxxo_tyre_list_%' OR option_name LIKE '_transient_timeout_oxxo_tyre_list_%'" ); } } add_action('save_post_product', 'oxxo_tyre_clear_home_cache'); add_action('woocommerce_update_product', 'oxxo_tyre_clear_home_cache'); add_action('deleted_post', 'oxxo_tyre_clear_home_cache'); add_action('woocommerce_product_set_stock', 'oxxo_tyre_clear_home_cache'); add_action('woocommerce_product_set_stock_status', 'oxxo_tyre_clear_home_cache'); add_shortcode('tyre_list', function ($atts) { if (!class_exists('WooCommerce')) { return ''; } $a = shortcode_atts([ 'per_page' => 12, 'orderby' => 'date', 'order' => 'DESC', 'brand' => '', ], $atts, 'tyre_list'); $per_page = max(1, min(24, (int) $a['per_page'])); $orderby = sanitize_key($a['orderby']); $order = strtoupper($a['order']) === 'ASC' ? 'ASC' : 'DESC'; $brand = sanitize_text_field($a['brand']); $cache_key = 'oxxo_tyre_list_' . md5(serialize([ 'per_page' => $per_page, 'orderby' => $orderby, 'order' => $order, 'brand' => $brand, 'v' => '4.0' ])); $cached = get_transient($cache_key); if ($cached !== false) { return $cached; } $ICONS_BASE = 'https://oxxotyre.com/wp-content/uploads/2024/10/'; $DETAILS_BASE = site_url('/wp-content/uploads/details-icons/'); $SEASON_BASE = 'https://oxxotyre.com/wp-content/uploads/2024/10/'; $BRANDS_BASE = site_url('/wp-content/uploads/brands/manufacturer/'); $FALLBACK_IMG = 'https://oxxotyre.com/wp-content/uploads/2026/01/LOGO-OXXOTYRE-1.png'; /* * IMPORTANT : * On évite meta_query _sku NOT LIKE itw2. * C’est l’une des parties les plus lentes. * On récupère un petit pool d’IDs puis on filtre les jantes en PHP. */ $pool = min(120, max(40, $per_page * 6)); $query_args = [ 'post_type' => 'product', 'post_status' => 'publish', 'posts_per_page' => $pool, 'fields' => 'ids', 'no_found_rows' => true, 'ignore_sticky_posts' => true, 'update_post_meta_cache' => false, 'update_post_term_cache' => false, 'orderby' => 'date', 'order' => $order, ]; if ($orderby === 'price') { $query_args['meta_key'] = '_price'; $query_args['orderby'] = 'meta_value_num'; } elseif ($orderby === 'popularity') { $query_args['meta_key'] = 'total_sales'; $query_args['orderby'] = 'meta_value_num'; } elseif ($orderby === 'rating') { $query_args['meta_key'] = '_wc_average_rating'; $query_args['orderby'] = 'meta_value_num'; } $ids = get_posts($query_args); if (empty($ids)) { return '

Aucun produit.

'; } // Précharge toutes les métas en une seule fois. update_meta_cache('post', $ids); $selected_ids = []; foreach ($ids as $pid) { $sku = get_post_meta($pid, '_sku', true); // Exclure les jantes : SKU commence par itw2. if ($sku && oxxo_tyre_starts_with(strtolower($sku), 'itw2')) { continue; } if ($brand !== '') { $product_brand = get_post_meta($pid, 'brand', true); if (strtolower($product_brand) !== strtolower($brand)) { continue; } } $selected_ids[] = $pid; if (count($selected_ids) >= $per_page) { break; } } if (empty($selected_ids)) { return '

Aucun produit.

'; } ob_start(); ?>