douji6667 2019-04-01 10:45
浏览 95
已采纳

wordpress Wp_query和元查询问题与日期字段

I have Projects inserted as posts in my WordPress database. currently on my home, the last 3 published project is displayed. now my purpose is that I want first display the project which is expiring today than the last published project.

for example, there are 2 projects are expiring today than on the home page it will display 2 projects which are expiring today and 1 project which published last. it means a total of 3 projects will display.

please check below WP_query which returns last published project only

$args = array('post_type' => 'ignition_product', 'posts_per_page' => $project_count, 'paged' => $paged);

$newargs = apply_filters('project_query', $args);
$wp_query = new WP_Query($newargs);

the below query I try using meta key & value but no luck. "ign_fund_end" is stored a date as a string so I think that's why not comparing date. my final goal is I described as above total 3 projects should display. first should be today expiring then after last published.

$args = array(
        'post_type' => 'ignition_product',
        'posts_per_page' => $project_count,
        'paged' => $paged,        
        'meta_query' => array(// WordPress has all the results, now, return only the events after today's date
            array(
                'key' => 'ign_fund_end', // Check the start date field
                'value' => date('m/d/Y'), // Set today's date (note the similar format)
                'compare' => '>=', // Return the ones greater than today's date
                'type' => 'DATE' // Let WordPress know we're working with date
            )
    ));

please check the below image for reference. enter image description here

any solution appreciated.

  • 写回答

2条回答 默认 最新

  • duanjiao6711 2019-04-01 12:28
    关注

    Since your custom field ign_fund_end is not in MySQL date compatible format so that is the main reason for your WP_Query to not work in the expected way. My recommendation is to save a timestamp of end date in a custom field using save_post and then change the $args for WP_Query to work on that field.

    Here is complete solution for your issue:

    1: Save Timestampe in a Custom field

    add_action( 'save_post', function( $post_id ) {
        if ( defined( 'DOING_AUTOSAVE' ) && DOING_AUTOSAVE ) return;
        if ( $parent_id = wp_is_post_revision( $post_id ) ) {
            $post_id = $parent_id;
        }
    
        if( isset( $_POST['ign_fund_end'] ) && !empty($_POST['ign_fund_end']) ) {
            $end_date = $_POST['ign_fund_end'];
            $end_date = strtotime($end_date);
            update_post_meta( $post_id, '__end_date', $end_date );
        }
    } );
    

    2: Modify the $args

    $args = array(
        'post_type' => 'ignition_product',
        'posts_per_page' => $project_count,
        'orderby'   => 'meta_value_num',
        'order'     => 'ASC',
        'meta_key'  => '__end_date',
        'paged' => $paged,        
        'meta_query' => array(// WordPress has all the results, now, return only the events after today's date
        array(
            'key' => '__end_date', // Check the start date field
            'value' => strtotime('today'), // Set today's timestamp
            'compare' => '>=', // Return the ones greater than today's date
            'type' => 'NUMERIC'
        )
    ));
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!
  • ¥15 vmtools环境不正常
  • ¥15 请问如何在Ubuntu系统中安装使用microsoft R open?
  • ¥15 jupyter notebook
  • ¥30 informer时间序列预测
  • ¥20 SSR引物多态性分析
  • ¥15 大漠插件在Win11易语言注册调用和免注册灵异事件,VS上注册调用完全没问题
  • ¥15 Addressable缓存机制做热更新的问题
  • ¥15 微信开发者工具vant组件