get_categories为了通过邮局用自定义字段

Question

我有一些研究，发现这get_categories order by last post

这是我想几乎什么，但我想通过自定义字段（由插件高级自定义字段创建）的职务序列，让说帖按日期排序（自定义字段），那么具有最大自定义字段值发布的类别将首先显示，是否可用？

Answer 1

试试下面的代码：

function get_sorted_categories($custom_field, $args = array()){ 
    global $wpdb; 

    $category = get_categories($args); 

    $custom_field = esc_sql($custom_field); 

    $q = $wpdb->get_results("SELECT tax.term_id FROM `{$wpdb->prefix}term_taxonomy` tax 
    INNER JOIN `{$wpdb->prefix}term_relationships` rel ON rel.term_taxonomy_id = tax.term_id 
    INNER JOIN `{$wpdb->prefix}posts` post ON rel.object_id = post.ID 
    INNER JOIN `{$wpdb->prefix}postmeta` meta ON meta.post_id = post.ID AND meta.meta_key = '{$custom_field}' 
    WHERE tax.taxonomy = 'category' AND post.post_type = 'post' AND post.post_status = 'publish' AND ORDER BY meta.meta_value DESC"); 

    $sort = array_flip(array_unique(wp_list_pluck($q, 'term_id'))); 

    usort($category, function($a, $b) use ($sort, $category) { 
     if(isset($sort[ $a->term_id ], $sort[ $b->term_id ]) && $sort[ $a->term_id ] != $sort[ $b->term_id ]) 
      $res = ($sort[ $a->term_id ] > $sort[ $b->term_id ]) ? 1 : -1; 
     else if(!isset($sort[ $a->term_id ]) && isset($sort[ $b->term_id ])) 
      $res = 1; 
     else if(isset($sort[ $a->term_id ]) && !isset($sort[ $b->term_id ])) 
      $res = -1; 
     else 
      $res = 0; 

     return $res; 
    }); 

    return $category; 
} 

print_r(get_sorted_categories('CUSTOM_FIELD_KEY')); 

只是通过自定义字段关键作用。