How to display upcoming events by dat with Modern Events Calendar Lite

Question

How to display upcoming events by dat with Modern Events Calendar Lite

Gregory

2022年2月9日 08:57

I'm using the plugin Modern Events Calendar Lite.

This is a recent plugin, so actually no doc exist.

So i'm looking a way to display my upcoming events on homepage. But i can not make it to work, because start is stored in a second table.

So i have a wpquery that list custom posts "mec-events", this is ok. But i'm not able to JOIN info to second table to get start_date to order posts on its value.

I add you a capture of the second table wp-mec-dates events are store in wp-mec-events

Based on this tuto : Filtering the JOIN tables in WP_Query exemple code :

add_filter( 'posts_join', 'add_other_table', 10, 2 );

/**
 * Joining another table and relating the column post_id with the Post's ID
 *
 * @param string $join String containing joins.
 * @param WP_Query $wp_query Object.
 * @return string
 */
function add_other_table( $join, $wp_query ) {
 global $wpdb;
 $join .= " JOIN {$wpdb-prefix}my_table as mytable on mytable.post_id = {$wpdb-posts}.ID ";
 return $join;
}

i figure to do like this :

?php
    $args = array(
        'post_type'= 'mec-events',
        'orderby' = 'dstart',
        'order'    = 'ASC',
    );              

    add_filter( 'posts_join', 'add_other_table', 10, 2 );
    function add_other_table( $join, $upcoming_events_query ) {
        global $wpdb;
        $join .= " JOIN {$wpdb-prefix}mec_dates as wp_mec_dates on wp_mec_dates.post_id = {$wpdb-posts}.ID ";
        return $join;
    }   

    $upcoming_events_query = new WP_Query( $args );
    if($upcoming_events_query-have_posts() ) {
        while ( $upcoming_events_query-have_posts() ) {
            $upcoming_events_query-the_post();

            $image_url = get_the_post_thumbnail_url('','liste-etablissements'); 
            $event_cities = get_field('contact_city',$post-ID);
            $start_date = get_field('dstart');
            var_dump($start_date);
?
    div class="presta-img-home-events"
        ?php if($image_url[0]) { ?
            img src="?php echo esc_url( $image_url ); ?" alt="?php the_title_attribute(); ?"
        ?php } else { ?
            img src="?php echo get_template_directory_uri() . '/images/placeholder-blog.jpg'; ?" alt="?php the_title_attribute(); ?"
        ?php } ?
        div class="presta-img-home-events-overlay"?php //echo $start_date; ? - ?php if($event_cities) { $cities = 0; $max_cities = 1; foreach($event_cities as $event_city) { $cities++; if($cities  $max_cities) { break; } echo ''. get_the_title( $event_city-ID ) .''; } } ?/div
    /div
    div class="featured-content-wrapper"
        h3 class="featured-title" a title="?php the_title_attribute(); ?" href="?php the_permalink(); ?"?php the_title(); ?/a/h3
        !--a href="?php the_permalink(); ?" class="single_add_to_wishlist" ?php esc_html_e('Découvrir','BeProvence'); ?i class="fa fa-heart"/i/a--
    /div!-- featured content wrapper --
                    ?php
                    }
                }
                    ?

But my var_dump() return "null". So i probably do something wrong. Any help will be apreciate !

Topic join-tables date wp-query events Wordpress

Category Web

Darko Mitrovic · Accepted Answer · 2022年2月9日 08:57

$args = array( 
    'posts_per_page' => 5, 
    'post_type' => 'mec-events', 
    'orderby' => 'mec_start_date', 
    'order' => 'ASC',
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key'     => 'mec_start_date',
            'value'   => date('Ymd'),
            'compare' => '>=',
            'type' => 'DATE'
        ),
    ),
);

Gregory · Accepted Answer · 2019年6月3日 11:04

i have found a solution, making a custom SQL query

here is the code ( using WPML )

        $startday = date("Y-m-d");
        if ( defined( 'ICL_LANGUAGE_CODE' ) ) {
          $lang = ICL_LANGUAGE_CODE;
        }           
        //echo $startday;
        global $wpdb,$post;
        $results = $wpdb->get_results( "SELECT * FROM wp_posts, `wp_mec_dates` AS mecd, wp_icl_translations WHERE wp_posts.ID = mecd.post_id and post_status='publish' AND wp_icl_translations.language_code='$lang' AND dstart>'$startday' and  wp_posts.ID = wp_icl_translations.element_id ORDER BY dstart" );
        foreach ($results as $post) {
            setup_postdata($post);
            $event_permalink = get_the_permalink();
            $event_date = $post->dstart; 
            $new_event_date = date("d/m", strtotime($event_date));
            $event_title = get_the_title();
            echo $new_event_date . ' - <a href="'.$event_permalink.'" title="'.$event_title.'">' . substr($event_title,0,38) .'</a><br />';
        }
        wp_reset_postdata();

How to display upcoming events by dat with Modern Events Calendar Lite

About