Monthly Archive in sidemenu

Got it! This is how you show a monthly archive on the sidebar using Event Organiser.

I used this post for a template: post

<?php $args = array(
"post_type"   	 => array("event"),
"post_status"    => "publish",
"showpastevents" => true,
'event_start_before'=>'today',
"orderby"	=> "eo_get_the_start( 'Y/m')",
'order'		=> "ASC"
);

	$month_query = new Wp_Query( $args );
	?>

    <?php // Variables $month, $prevmonth, $year and $prevyear are used to section the archive display ?>
	<?php $month = '';
		  $prevmonth = '';
		  $year = '';
		  $prevyear = ''; ?>
    <?php $current_month = date('js F Y'); ?>
    <?php $event_month = eo_get_the_start( 'js F Y'); ?>
	<?php if ($event_month <= $current_month){?>
	<?php // Cycle through all the posts to display the archive ?>

	<?php if( $month_query->have_posts() ) : ?>
    <?php while( $month_query->have_posts() ) : $month_query->the_post(); ?>

	<?php // Find the month/year of the current post ?>
	<?php $year = eo_get_the_start( 'Y'); ?>
	<?php $month = eo_get_the_start( 'F'); ?>

	<?php // Compare the current month with the $prevmonth ?>
	<?php if ($month != $prevmonth) { ?>
	<?php // If it is different, display the new month and reset $prevmonth ?>
	<?php echo '<ul><li><a href="'. site_url() .'/events/on/'.eo_get_the_start( 'Y/m').'"/>'. $month . ' ' . $year .'</a></li></ul>';?>

	<?php $prevmonth = $month; ?>

	<?php // In case the previous post was a year ago in the same month ?>
	<?php } elseif ($year != $prevyear) { ?>

	<?php $prevmonth = $month; ?>
	<?php $prevyear = $year; ?>
	<?php } ?>

	<?php endwhile; endif; ?>
   	<?php } ?>

All I need to do now is remove the months from the previous year and make a list for each previous year. Not sure how to do that yet.

To only show a list of months for this year I have added:

<?php $startyear = date('Y-m-d', strtotime('first day of January this year')); ?>

Before the $args array and added
'event_start_after'=>$startyear, to the array.

Now I have a list of previous months in this year 1.e.

May
April
March
Feb

What I want to do now is have a list of previous years containing posts i.e.

2014
2013

This echos the years, but I can’t remove the current year from the list.

<?php
$years = $wpdb->get_col("SELECT DISTINCT YEAR(StartDate) FROM wptr_eo_events ORDER BY StartDate");
foreach($years as $year) : ?>
<?php echo '<ul><li><a href="'. site_url() .'/events/on/'.$year.'"/> ' . $year .'</a></li></ul>';?>
<?php   endforeach; ?>

That last SQL query will return all years from the table. Try adding a WHERE YEAR(StartDate) < YEAR(CURDATE()) condition.

Perfect, thank you

I just wanted to add a little note for anyone who stumbles across my code here. I have scrapped the first monthly filter and I am now using this which seems to work better.

<?php $months = $wpdb->get_col("SELECT DISTINCT MONTHNAME(StartDate) FROM wptr_eo_events WHERE MONTH(StartDate) < MONTH(CURDATE()) ORDER BY StartDate DESC ");?>
<?php 	$test= strtotime("+1 month")?>

<?php foreach($months as $month) : ?>
<?php echo '<ul><li class"list-unstyled"><a href="'. site_url() .'/events/on/'.$year .'/'.date('m', strtotime($month)).'"/> ' . $month .'</a></li></ul>';?>
<?php endforeach; ?>