返信先: 商品名順もしくは商品コード順で表示させたい

[folon]

`function sort_by_itemcode( $query ) {
if ( is_admin() || ! $query->is_main_query() ) {
return;
}

if ( $query->is_category ) {
$cat_id = get_cat_ID( get_query_var( ‘category_name’ ) );
$cat_id2 = get_query_var( ‘cat’ );
if ( usces_is_cat_of_item( $cat_id ) || usces_is_cat_of_item( $cat_id2 ) ) {
add_filter( ‘posts_join’, ‘my_join’ );
add_filter( ‘posts_orderby’, ‘my_orderby’);
}
}
}
add_action( ‘pre_get_posts’, ‘sort_by_itemcode’ );

function my_join( $join ) {
global $wpdb;
$item_table = usces_get_tablename( ‘usces_item’ );
$join .= ” INNER JOIN {$item_table} AS welitem ON {$wpdb->posts}.ID = welitem.post_id”;
return $join;
}