All-in-One Event Calendar: Custom Query – Getting each event Instance [closed]

Finally have a chance to post my solution. Note that the events show All Day events first if there are any. Unfortunately I don’t know a way around this as it is coded this way in a SQL query within one of the plugin files (and it is even commented in the file that All Day events are first).

I am also using the event information collected into image data attributes as it is for a carousel using Cycle2. But you can just change that part to echo out the information or however you want to format it.

I hope this helps someone else if they come across the need to get events from the AI1EC plugin!

<?php

    // Gets localized time
    $time = $ai1ec_events_helper->gmt_to_local( Ai1ec_Time_Utility::current_time() );
    $bits = $ai1ec_events_helper->gmgetdate( $time );

    // Sets start time to today
    $start = gmmktime(0,0,0,$bits['mon'],$bits['mday'],$bits['year']);

    // Sets end time to a year from today i.e. $bits['year']+1
    $end = gmmktime(0,0,0,$bits['mon'],$bits['mday'],$bits['year']+1);

    // Look in class-ai1ec-calendar-helper.php for details
    $get_events = $ai1ec_calendar_helper->get_events_between($start, $end, $filter, $spanning = false);

    date_default_timezone_set('America/Toronto'); // Match timezone settings in WP

    // For each event
    foreach($get_events as $event) {

        // Event ID
        $eventID = $event->post->ID;

        // Event Title
        $eventTitle = $event->post->post_title;

        // Event URL
        $eventURL = $event->post->guid . $event->instance_id;

        // Event Date
        $eventMonth = date( 'M', $event->start );
        $eventDay = date( 'd', $event->start );

        // Event Image
        $imgID = get_post_thumbnail_id( $eventID );

        // Event Time
        if( $event->allday == 1 ) {
            $timeSpan = 'All Day';
        } else {
            $startTime = date( 'g:ia', $event->start );
            $endTime = date( 'g:ia', $event->end );
            $timeSpan = $startTime . ' - ' . $endTime;
        }

        $attr = array(
            'alt' => get_post_meta( $imgID , '_wp_attachment_image_alt', true ), 
            'data-name' => $eventTitle, 
            'data-month' => $eventMonth,
            'data-day' => $eventDay,
            'data-time' => $timeSpan,
            'data-url' => $eventURL
        );
        echo get_the_post_thumbnail( $eventID, 'full', $attr );
    }
?>

Related Posts:

  1. Nested meta_query with multiple relation keys
  2. numberposts? showposts? posts_per_page?
  3. How can I save an array from a random post sequence for later use?
  4. Is there an action/filter called when WP_Query->query is finished and assigns posts
  5. Limit search results to exact match
  6. Highlighting Sub topic in a post?
  7. Pagination Not working on Home Page with 2 Query
  8. Multiple keyword search
  9. Get number of comments after modifying comment query
  10. Show default content if custom WP_Query has no posts
  11. Include Sticky Posts with Custom Query
  12. $wpdb->insert inserting two rows in database
  13. Create unique page without header.php for json feed
  14. How to select events within current week using wp_query
  15. Sub-loop / nested loops Best Practices
  16. How to loop for every result found in the_content() when using the search query?
  17. How to display upcoming events by dat with Modern Events Calendar Lite
  18. Is there any advantage of using default WordPress Search instead of creating a custom one?
  19. Order By table field comment_status in WordPress > 4.0
  20. Clean up WordPress code that repeats
  21. How to optimize multiple WP_Query() calls on one page?
  22. Use post object from first query in second query
  23. Query to get siblings and parent page
  24. How to list custom fields as headers and list all pages sharing that custom field under it?
  25. Cutom wp_query for geolocation search, pagination not working
  26. Include data from custom table in WP_Query
  27. echo a specific meta_key queried through a custom post
  28. WP Group posts by year(desc) > month(desc) > date(asc)
  29. sort and display posts by custom field (wp-query and the loop))
  30. How to order posts on each different category?
  31. Get specific ACF key and value from all posts – no access to DB
  32. Orderby two meta fields not working
  33. Custom wp_query – I’m getting ‘all’ post, not the specific post in the query
  34. meta_query with array as value with multiple arrays
  35. Adding pagination to sub-wp_query within a singular post page
  36. Magazine style frontpage with multiple categories/loops and no duplicate posts
  37. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  38. How to make a query returning pages from multiple parents
  39. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  40. Where is this query?
  41. The Events Calendar, wp_query returning event date not published date
  42. How to use wp query in my custom page without including header and footer in wordpress
  43. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  44. WP Query for all events prior to current date
  45. How to extend WP_query to a specific table?
  46. Display the search results like the original pages
  47. Multi line of $wpdb->query just run 1 time and end the loop right after
  48. Add to search posts query array with post IDS which will appear first
  49. Woocomerce – Order products by float attribute in archive pages
  50. Multiple values in WP_Query : category__and
  51. How to set up pagination for a custom loop on a global template (author.php, tag.php, archive.php?)
  52. Custom query using WP_Query is not working
  53. Limit the number of posts from a specific category on index.php
  54. Get the type of an advanced custom field (ACF) in a WP_Query loop [closed]
  55. Switched from query_posts to wp_query, pagination no longer working
  56. WP_Query breaks pagination
  57. Pagination problem with multiple loops on the same page
  58. shortcode with $atts with strange results
  59. I need to get all categories from a WP_Query
  60. Order by DESC, ASC in custom WP_Query
  61. Exclude or Include category ids in WP_Query
  62. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  63. Query Posts in a Predefined Order
  64. Get only 1 Most Recently Modified Child Post from Parent
  65. Should close $wpdb via $wpdb->close()
  66. Does meta_query need numeric values to be cast to integers?
  67. WordPress documentation – WP_Query arguments
  68. WP_Query with multiple meta fields filter?
  69. Using apply_filters(‘the_content’, $custom_query->post_content) alters output
  70. WP_Query Date Query After Minus Hour AND minus minutes
  71. wp query template tags not working
  72. Display posts from only one post form in custom query and exclude in main query
  73. How to get all product attributes for filters in WooCommerce?
  74. Fetch Record based on meta key dates
  75. How can I display list of all posts from a specific author, with publish dates in the future, on an author archive page (author.php)?
  76. Custom posts visible in admin, but truncate in public
  77. Why does get_posts only show results for Admins or logged-out users?
  78. Add filter post_where and passing post_type argument
  79. WP_Query infinite Loop
  80. Limiting number of related posts
  81. Pagination works in custom query loop but it doesn’t work in shortcode
  82. How to avoid filling up an array each time I run a WP_query?
  83. How to SQL query posts IDs by categories AND authors?
  84. Admin: Custom Query Returning Permissions Error
  85. wp query remove posts from query then update max pages and posts found
  86. Custom Form / Search with Custom Post Type Data
  87. WP_Query Orderby meta_key and hide some meta_key
  88. Combine relationship posts with existing wp_query
  89. Slick slider for post doesn’t display anything
  90. What is the equivalent WP_Query of a SQL Query?
  91. create custom shortcode wp and put php code in
  92. How to get only present and past posts with post_date
  93. Query WP Posts, then list the taxonomies from those posts
  94. Query post with content only
  95. Fetch only categorized posts
  96. Wrote a WP Cron Plugin and it triggers a fatal error upon activation
  97. Getting Year & Date inside wpdb [duplicate]
  98. Get posts by meta value except one post [closed]
  99. I want to place a post before all others from an ACF boleen field
  100. How to put posts with some taxonomy on top of others in `pre_get_posts`

Leave a Comment

error code: 523