repeater dates arranged by months title

• felix007

• February 14, 2016 at 7:28 am

Hi, I have repeater with many dates on a page.
i would like to display the dates separated by MONTH title. – each month with its dates. and hide past dates and their month title from the page.
sample:

March
23/3/2016
27/3/2016

April
12/4/2016
17/4/2016

etc

couldn’t find an answer…

• James

• February 15, 2016 at 5:42 pm

Hi @felix007

You can always sort the returned repeater data. This page should give you more idea about it: http://www.advancedcustomfields.com/resources/how-to-sorting-a-repeater-field/.

After that, you can use PHP datetime to check if the dates are after the current date or not.

I hope this helps.

• felix007

• February 15, 2016 at 9:31 pm

Thank you James
I have done the repeater sort. it sorts by date. and also hide the past dates…
but i need to separate the dates into months and hide past months –
this is the problem i couldn’t figure.

the code i used so far.

<?php
// get repeater field data
$repeater = get_field('vacation_repeater1');
// vars
$order = array();

if( $repeater ):
// populate order
foreach( $repeater as $i => $row ) {
	$order[ $i ] = $row['start_date'];
}
array_multisort( $order, SORT_ASC, $repeater );
?>
	<?php foreach( $repeater as $i => $row ): ?>
<?php
	$end_date = get_sub_field('end_date');
			$today = date('Ymd');
	$get_startdate = $row['start_date'];
	$start_date = (strtotime($get_startdate));
//use $get_startdate to order, and $start_date_pretty to output your date
	$start_date_pretty = date_i18n( 'l, F j, Y', $start_date );
 ?>

<?php if($today <= $get_startdate ) { ?>

<ul>
<li class="flight_date_time">
	<?php echo $start_date_pretty; ?>
</li>
<li class="flight_date_time">
	<?php echo $row['end_date']; ?>
</li>
</ul>
<div class="clear"></div>

<?php } ?>

	<?php endforeach; ?>
<?php endif; ?>

• James

• February 16, 2016 at 5:21 pm

Hi @felix007

If you want to sort the dates based on month and hide the past months, you can use this code:

$repeater = get_field('repeater_field_name');

$order = array();

// populate order
foreach( $repeater as $i => $row ) {
	
	$order[ $i ] = (int) substr($row['date_field_name'],3 ,2);
    
}

array_multisort( $order, SORT_DESC, $repeater );

foreach( $repeater as $row ) {
	
    if((int) substr($row['date_field_name'],3 ,2) >= (int) date('m')){
        echo $row['tr1_date1'];
    }
    
}

I hope this helps.

• felix007

• February 16, 2016 at 8:31 pm

Thank you James for your replay.
sorry but i need a different kind of sort.
separate dates into months – so each month show its dates + month title.
sample:

March
23/3/2016
27/3/2016

April
12/4/2016
17/4/2016

also can you explain – echo $row['tr1_date1']; do i need to change it? cause i don’t get any results.

Thank You.

• James

• February 17, 2016 at 3:13 pm

Hi @felix007

tr1_date1 is my date field name. I’m sorry I forgot to change it. Here is another way to achieve what you want:

$repeater = get_field('repeater_field_name');
$order = array();
$now = strtotime("now");
$sortedDate = array();

foreach( $repeater as $i => $row ) {
    $order[ $i ] = $row['date_field_name'];
}
array_multisort( $order, SORT_ASC, $repeater );

foreach($repeater as $row){
    $theDate = strtotime(str_replace('/', '-', $row['date_field_name']));
    if($theDate > $now){
        $theMonth = substr($row['date_field_name'],3 ,2);
        if (!isset($sortedDate[$theMonth])){
            $sortedDate[$theMonth] = array();
        }
        array_push($sortedDate[$theMonth], $row);
    }
}

foreach($sortedDate as $theMonth => $theDates){
    echo $theMonth;
    foreach($theDates as $theDate){
        echo $theDate['date_field_name'];
    }
}

If you don’t understand it, please hire a developer to help you out with it.

I hope this helps.

• felix007

• February 17, 2016 at 6:40 pm

Thank you James!
It works as i needed!
This will help a lot of ACF users.

the only thing i changed is 3,2 into 4,2 at line $theMonth = substr($row['date_field_name'],4 ,2); cause my dates appear as 20160412.

to finalize the code a question, how to echo the dates and title months to show as “pretty”?
i used before $start_date_pretty = date_i18n( 'l, F j, Y', $start_date ); but i don’t see how i can use that in this working code.

Thank you again

• felix007

• February 19, 2016 at 8:30 am

OK. figured it out.
managed to change the dates to “pretty” and add the rest of the fields that i needed.
the months name titles working… but i made them in a stupid way.
maybe somebody can add a nice fix to it.
hope it will help somebody as it helped me.

<?php

$repeater = get_field('vacation_repeater1');
$order = array();
$now = strtotime("now");
$sortedDate = array();

foreach( $repeater as $i => $row ) {
    $order[ $i ] = $row['start_date'];
}

array_multisort( $order, SORT_ASC, $repeater );

foreach($repeater as $row){

    $theDate = strtotime(str_replace('/', '-', $row['start_date']));

    if($theDate > $now){
        $theMonth = substr($row['start_date'],4 ,2);
        if (!isset($sortedDate[$theMonth])){
            $sortedDate[$theMonth] = array();
        }
        array_push($sortedDate[$theMonth], $row);
    }
}

foreach($sortedDate as $theMonth => $theDates){
	 //echo $theMonth . '<br/>';
if($theMonth == 01) {
	echo 'Jan <br/>';
} elseif($theMonth == 02) {
	echo 'February <br/>';
} elseif($theMonth == 03) {
	echo 'March <br/>';
} elseif($theMonth == 04) {
	echo 'April <br/>';
} elseif($theMonth == 05) {
	echo 'May <br/>';
} elseif($theMonth == 06) {
	echo 'June <br/>';
} elseif($theMonth == 07) {
	echo 'July <br/>';
} elseif($theMonth == 08) {
	echo 'August <br/>';
} elseif($theMonth == 09) {
	echo 'September <br/>';
} elseif($theMonth == 10) {
	echo 'October <br/>';
} elseif($theMonth == 11) {
	echo 'November <br/>';
} elseif($theMonth == 12) {
	echo 'December <br/>';
}

foreach($theDates as $theDate){
	//echo $theDate['start_date']. '<br/>';
	$date = $theDate['start_date'];
	$date_tour = date_i18n("l, F j, Y", strtotime($date));
	echo $date_tour. '<br/>';

	echo $theDate['flight_to_time']. '<br/>';
	echo $theDate['flight_back_time']. '<br/>';
	echo $theDate['price_standart']. '<br/>';
	echo $theDate['price_standart_plus']. '<br/>';
	echo $theDate['air_company']. '<br/>';
	echo '<br/><br/>';
}//$theDate

}//$theMonth

 ?>

• James

• February 19, 2016 at 2:54 pm

Hi @felix007

That’s good enough I think. But if you don’t want it to looks ugly, you can use this code:

$monthName = date("F", mktime(0, 0, 0, $theMonth, 10));
echo $monthName;

But I’m not sure if it uses extra resource or not.

Hope this helps!