wordpress-可排序的自定义字段列 [英] wordpress - Sortable custom fields columns

问题描述

我在管理列中添加了一些自定义字段(日期).我试图使它们可排序，但是为了做到这一点，我需要将它们从字符串转换为日期.我幼稚而简单的代码显然行不通...有人可以指出我的错误吗?

I added some custom fields (dates) in my admin columns. I try to make them sortable but in order to do that I need to convert them from string to date. My naive and simple code obviously doesn't work... Can someone point out my error(s) ?

add_action( 'pre_get_posts', 'orderby_date' );

function orderby_date( $query ) {
 $orderby = $query->get( 'orderby');
  if( 'start' == $orderby ) {
    $query->set('meta_key','class_start');
    $query->set('orderby',"STR_TO_DATE(meta_value,'%m/%d/%Y')");
  }
}

推荐答案

这是您要寻找的:

add_filter( 'posts_clauses', 'manage_wp_posts_be_qe_posts_clauses', 1, 2 );
function manage_wp_posts_be_qe_posts_clauses( $pieces, $query ) {
   global $wpdb;

   if ( $query->is_main_query() && ( $orderby = $query->get( 'orderby' ) ) ) {
      $order = strtoupper( $query->get( 'order' ) );

      if ( ! in_array( $order, array( 'ASC', 'DESC' ) ) )
         $order = 'ASC';

      switch( $orderby ) {

         case 'class_start':

            $pieces[ 'join' ] .= " LEFT JOIN $wpdb->postmeta wp_rd ON wp_rd.post_id = {$wpdb->posts}.ID AND wp_rd.meta_key = 'class_start'";

            $pieces[ 'orderby' ] = "STR_TO_DATE( wp_rd.meta_value,'%m/%d/%Y' ) $order, " . $pieces[ 'orderby' ];

         break;
      }
   }
   return $pieces;
}

您可以在此处了解更多信息: http://wpdreamer.com/2014/04/how-to-make-your-wordpress-admin-columns-sortable/

You can read more about it here: http://wpdreamer.com/2014/04/how-to-make-your-wordpress-admin-columns-sortable/

这篇关于wordpress-可排序的自定义字段列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！