解决WooCommerce产品自定义排序导致WordPress后台页面崩溃的问题

add_filter('posts_clauses', 'posts_clauses_with_tax', 10, 2);
function posts_clauses_with_tax( $clauses, $wp_query ) {
    global $wpdb;
    $taxonomies = array('pwb-brand');
    $orderBy['field'] = "pwb-brand";
    $orderBy['direction'] = "ASC";

    if( in_array($orderBy['field'], $taxonomies) ) {
        $clauses['join'] .= "
            LEFT OUTER JOIN {$wpdb->term_relationships} AS rel2 ON {$wpdb->posts}.ID = rel2.object_id
            LEFT OUTER JOIN {$wpdb->term_taxonomy} AS tax2 ON rel2.term_taxonomy_id = tax2.term_taxonomy_id
            LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
        ";

        $clauses['where'] .= " AND (taxonomy = '".$orderBy['field']."' OR taxonomy IS NULL)";
        $clauses['groupby'] = "rel2.object_id";
        $clauses['orderby']  = "GROUP_CONCAT({$wpdb->terms}.slug ORDER BY slug ASC) ";

        $clauses['orderby'] .= ", {$wpdb->posts}.post_title ASC"; 
        return $clauses;
    }
    else {
        return $clauses;
    }  
}

add_filter('posts_clauses', 'posts_clauses_with_tax', 10, 2);
function posts_clauses_with_tax( $clauses, $wp_query ) {
    // 1. 确保只在后台执行
    if ( ! is_admin() ) {
        return $clauses;
    }

    global $pagenow;
    // 2. 确保只在编辑列表页执行 (edit.php 是所有文章类型的列表页)
    if ( $pagenow !== 'edit.php' ) {
        return $clauses;
    }

    global $typenow;
    // 3. 确保只对 'product' 类型执行
    if ( $typenow !== 'product' ) {
        return $clauses;
    }

    // 如果以上条件都满足，则执行WooCommerce产品的自定义排序逻辑
    global $wpdb;
    $taxonomies = array('pwb-brand'); // 定义需要排序的分类法
    $orderBy['field'] = "pwb-brand";
    $orderBy['direction'] = "ASC"; // 排序方向，此处未使用，但保留

    if( in_array($orderBy['field'], $taxonomies) ) {
        // 添加 JOIN 语句以连接分类法相关表
        $clauses['join'] .= "
            LEFT OUTER JOIN {$wpdb->term_relationships} AS rel2 ON {$wpdb->posts}.ID = rel2.object_id
            LEFT OUTER JOIN {$wpdb->term_taxonomy} AS tax2 ON rel2.term_taxonomy_id = tax2.term_taxonomy_id
            LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
        ";

        // 添加 WHERE 条件以筛选特定分类法
        $clauses['where'] .= " AND (tax2.taxonomy = '".$orderBy['field']."' OR tax2.taxonomy IS NULL)";

        // 分组，确保每个产品只被处理一次
        $clauses['groupby'] = "{$wpdb->posts}.ID"; // 修正groupby为posts.ID，避免多余连接导致问题

        // 定义 ORDER BY 语句，首先按品牌slug排序，然后按产品标题排序
        $clauses['orderby']  = "GROUP_CONCAT({$wpdb->terms}.slug ORDER BY slug ASC) ";
        $clauses['orderby'] .= ", {$wpdb->posts}.post_title ASC"; 

        return $clauses;
    } else {
        // 如果没有匹配的分类法，则不修改查询
        return $clauses;
    }  
}