I’ve create a post type “events”. With ACF plugin and a repeater fucntion my post have a calendar.
Now, i want to make a calendar page with my events show per month.
ex :
July :
event 1 + all date
event 2 + all date
August :
event 3 + all date
event 1 + all date
How to browse all the months of the year with a planned event?
my actuatly code :
<?php
/**
* Template Name: Calendrier
*/
?>
<?php get_header();
$mois_annee = array(
'juillet',
'septembre',
);
setlocale (LC_TIME, 'fr_FR');
$mois_calendar = strftime('%B');
$query_calendrier = new WP_Query( array(
'post_type' => 'spectacle' ,
'tax_query' => array(
'relation' => 'OR',
array(
'cat' => '23',
)
)
));
$has_thumb = has_post_thumbnail();
?>
<?php if ( $has_thumb ) : ?>
<div class="image-une" data-parallax="scroll" data-image-src="<?php the_post_thumbnail_url(); ?>" data-speed="0.4"></div>
<?php endif ?>
<div class="global-content">
<h1 class="title-page <?php if ( !$has_thumb ) { ?>no-thumb<?php } ?>">
<?php the_title(); ?>
</h1>
<?php foreach ($mois_annee as $mois): ?>
<div class="panel-group" id="accordion-calendrier" role="tablist" aria-multiselectable="true">
<div class="panel-heading container" role="tab" id="head-<?php echo $mois; ?>">
<a role="button" data-toggle="collapse" data-parent="#accordion-calendrier" href="#collapse-<?php echo $mois; ?>" aria-expanded="true" aria-controls="collapse-<?php echo $mois; ?>">
<h1><?php echo $mois; ?></h1>
</a>
</div>
<?php $previous = null ?>
<div id="collapse-<?php echo $mois; ?>" class="collapse in clearfix collapse-content" role="tabpanel" aria-labelledby="heading-<?php echo $mois; ?>">
<?php
if ( $query_calendrier->have_posts() ) : while ( $query_calendrier->have_posts() ) : $query_calendrier->the_post(); ?>
<?php if( have_rows('calendrier') ) : ?>
<?php while ( have_rows('calendrier') ) : the_row();
$date_debut = get_sub_field('jour_debut');
$date_fin = get_sub_field('jour_fin');
$lien_map = get_sub_field('lien_map');
$descr_spect = get_sub_field('description-date');
$mois_spectacle = explode(" ", $date_debut)[1];
$jour1_periode = explode(" ", $date_debut)[0];
$jour2_periode = explode(" ", $date_fin)[0];
if($mois_spectacle == $mois){ ?>
<div class="col-xs-12 col-sm-6">
<?php if (get_the_title() != $previous) : ?>
<a href="<?php the_permalink(); ?>" title="<?php the_title(); ?>"><h2><?php the_title(); ?></h2></a>
<?php endif; ?>
<?php $previous = get_the_title(); ?>
<div class="infos-date-spectacle">
<div class="date-spectacle">
<?php if( !empty($date_fin) ) : ?>
Du <span><?php echo $jour1_periode; ?></span> au <span><?php echo $jour2_periode; ?></span> -
<?php else : ?>
Le <span><?php echo $jour1_periode; ?></span> -
<?php endif; ?>
</div>
<div class="lieu-spectacle">
<?php if( !empty($lien_map) ): ?>
<a href="<?php echo $lien_map; ?>" targuet="_blank" title="Spectacle de la compagnie Virvolt à <?php the_sub_field('lieu'); ?>">
<?php the_sub_field('lieu'); ?>
</a>
<?php
else :
the_sub_field('lieu');
endif;
?>
</div>
<?php if( !empty($descr_spect) ) : ?>
<div class="description-date-spectacle">
<?php echo $descr_spect; ?>
</div>
<?php endif; ?>
</div>
<!-- <div class="lien-voir-spectacle">
<a href="<?php the_permalink(); ?>" title="title">Découvrir ce spectacle</a>
</div> -->
</div>
<?php }?>
<?php endwhile; ?>
<?php endif; ?>
<?php endwhile; endif; ?>
</div>
</div>
<?php endforeach; ?>
</div>
<?php get_footer(); ?>
Hi @trainsrenton
I’m afraid you need to use the wpdb class instead. This page should give you more idea about it: https://www.advancedcustomfields.com/resources/querying-the-database-for-repeater-sub-field-values/. To learn more about wpdb, please check this page: https://codex.wordpress.org/Class_Reference/wpdb.
I hope this helps 🙂
wouaou !!!!
it becomes too complex for me 🙁
with this request I got it . I do not know what to do.
there all my time and all my post
array(5) {
[0]=>
object(stdClass)#6665 (4) {
[“meta_id”]=>
string(4) “1956”
[“post_id”]=>
string(3) “408”
[“meta_key”]=>
string(23) “calendrier_0_jour_debut”
[“meta_value”]=>
string(8) “20160704”
}
[1]=>
object(stdClass)#6683 (4) {
[“meta_id”]=>
string(4) “2183”
[“post_id”]=>
string(3) “441”
[“meta_key”]=>
string(23) “calendrier_0_jour_debut”
[“meta_value”]=>
string(8) “20160910”
}
[2]=>
object(stdClass)#6724 (4) {
[“meta_id”]=>
string(4) “2204”
[“post_id”]=>
string(3) “442”
[“meta_key”]=>
string(23) “calendrier_0_jour_debut”
[“meta_value”]=>
string(8) “20160927”
}
[3]=>
object(stdClass)#6723 (4) {
[“meta_id”]=>
string(4) “1972”
[“post_id”]=>
string(3) “408”
[“meta_key”]=>
string(23) “calendrier_1_jour_debut”
[“meta_value”]=>
string(8) “20160924”
}
[4]=>
object(stdClass)#6722 (4) {
[“meta_id”]=>
string(4) “1990”
[“post_id”]=>
string(3) “408”
[“meta_key”]=>
string(23) “calendrier_2_jour_debut”
[“meta_value”]=>
string(8) “20160709”
}
Hi @trainsrenton
After that, you can sort the data by using the array_multisort() function. This page should give you more idea about it: https://www.advancedcustomfields.com/resources/how-to-sorting-a-repeater-field/. Here’s an example how to do it:
$rows = ''; // The variable that holds the repeater result
// vars
$order = array();
// populate order
foreach( $rows as $i => $row ) {
$order[ $i ] = $row['meta_value'];
}
// multisort
array_multisort( $order, SORT_ASC, $rows );
$current_month = null;
foreach( $rows as $row){
$date = DateTime::createFromFormat('Ymd', $row['meta_value']);
$month = $date->format('F');
if( $current_month != $month ){
echo $month . "\r\n";
$current_month = $month;
}
echo $row['meta_value'] . "\r\n";
}
You can also get the post object by using the get_post() function like this:
echo $row['meta_value'] . "\r\n";
$thepost = get_post($row['post_id']);
print_r($thepost);
I hope this helps 🙂
hi james,
Thank you for your help.
here is my current code
<?php
/**
* Template Name: Calendrier
*/
?>
<?php get_header(); ?>
<?php
$rows = $wpdb->get_results($wpdb->prepare(
"
SELECT *
FROM {$wpdb->prefix}postmeta
WHERE meta_key LIKE %s
",
'calendrier_%_jour_debut'
));
/// var_dump($rows);
/*
array(5) {
[0]=>
object(stdClass)#6662 (4) {
["meta_id"]=>
string(4) "1956"
["post_id"]=>
string(3) "408"
["meta_key"]=>
string(23) "calendrier_0_jour_debut"
["meta_value"]=>
string(8) "20160704"
}
[1]=>
object(stdClass)#6676 (4) {
["meta_id"]=>
string(4) "2183"
["post_id"]=>
string(3) "441"
["meta_key"]=>
string(23) "calendrier_0_jour_debut"
["meta_value"]=>
string(8) "20160910"
}
[2]=>
object(stdClass)#6717 (4) {
["meta_id"]=>
string(4) "2204"
["post_id"]=>
string(3) "442"
["meta_key"]=>
string(23) "calendrier_0_jour_debut"
["meta_value"]=>
string(8) "20160927"
}
[3]=>
object(stdClass)#6716 (4) {
["meta_id"]=>
string(4) "1972"
["post_id"]=>
string(3) "408"
["meta_key"]=>
string(23) "calendrier_1_jour_debut"
["meta_value"]=>
string(8) "20160924"
}
[4]=>
object(stdClass)#6715 (4) {
["meta_id"]=>
string(4) "1990"
["post_id"]=>
string(3) "408"
["meta_key"]=>
string(23) "calendrier_2_jour_debut"
["meta_value"]=>
string(8) "20160709"
}
} */
$rows = get_field ('calendrier');
// var_dump($rows); = NULL
// vars
$order = array();
// populate order
foreach( $repeater as $i => $row ) {
$order[ $i ] = $row['id'];
}
//var_dump($order);
/*
array(0) {
}
*/
?>
<?php get_footer(); ?>
:s
Hi @trainsrenton
You need to use the $rows variable that holds the wpdb result. Something like this:
$rows = $wpdb->get_results($wpdb->prepare(
"
SELECT *
FROM {$wpdb->prefix}postmeta
WHERE meta_key LIKE %s
",
'calendrier_%_jour_debut'
));
// vars
$order = array();
// populate order
foreach( $rows as $i => $row ) {
$order[ $i ] = $row['meta_value'];
}
// multisort
array_multisort( $order, SORT_ASC, $rows );
// Temporary month variable
$current_month = null;
// Loop through the returned rows
foreach( $rows as $row){
// Convert the date string to PHP datetime
$date = DateTime::createFromFormat('Ymd', $row['meta_value']);
// Get the month
$month = $date->format('F');
// Echo the months only once
if( $current_month != $month ){
echo $month . "\r\n";
$current_month = $month;
}
// Show the date string
echo $row['meta_value'] . "\r\n";
// Get the related post
$thepost = get_post($row['post_id']);
// Show it if you want
print_r($thepost);
// Get the event repeater for the related post
$calendrier = get_field('calendrier', $thepost->ID);
// Show it if you want
print_r($calendrier);
}
Hope this helps 🙂
Hello James
Thank you very mutch for your help. I decided to change method.
I have created one page “calendar” with my repeater and i use relationship for the relation with my event.
my current code is :
<?php
/**
* Template Name: Test Calendrier
*/
?>
<?php get_header(); ?>
<div class="title-page no-thumb">
<?php
if( have_rows('calendrier') ) :
while ( have_rows('calendrier') ) :
the_row();
$date_debut = get_sub_field('jour_debut');
$mois_spectacle = explode(" ", $date_debut)[1];
echo '<h1>'.$mois_spectacle.'</h1>';
?>
<?php
$posts = get_sub_field('spectacle');
?>
<?php
foreach( $posts as $post):
?>
<?php setup_postdata($post); ?>
<div>
<a href="<?php the_permalink(); ?>"><?php the_title(); ?></a>
<span>Date début : <?php echo $date_debut ?></span>
</div>
<?php
endforeach;
?>
<?php wp_reset_postdata();?>
<?php
endwhile;endif;
?>
</div>
<?php
get_footer(); ?>
now i must merge the month and event similar.
but I do not know how…
Hi @trainsrenton
I’m afraid I don’t understand the new setup.
Could you please share some screenshots of how the fields are used on the backend and give me an example how you want it to be on the front end?
Thanks 🙂
hi james
The screenshot
Back end Page “calendrier” :
Current Front :
Result : (the html / Css / JS are OK)
thanks
Hi @trainsrenton
In this case, you need to sort the repeater first. Please check this page to learn more about it: https://www.advancedcustomfields.com/resources/how-to-sorting-a-repeater-field/. Please keep in mind that you need to change the order based on the date like this:
$order[ $i ] = $row['jour_debut'];
To show the month only once, you need to store the month in a variable and check it in the loop like this:
$current_date = null;
<?php foreach( $repeater as $i => $row ): ?>
if( $current_date != $row['jour_debut'] ){
echo '<h1>'.$row['jour_debut'].'</h1>';
$current_month = $row['jour_debut'];
}
<?php endforeach; ?>
I hope this helps 🙂
