// ===============================
// Agenda CPT
// ===============================

// Voeg ACF-velden toe aan archief en single via the_content filter
add_filter(’the_content’, function($content){
if( (is_post_type_archive(‘agenda’)
|| is_singular(‘agenda’)
|| is_tax()
|| is_home()
|| is_category()
|| is_tag())
&& get_post_type() === ‘agenda’
&& in_the_loop()
&& is_main_query()
){
$extra = ‘<div class=”agenda-info-loop”>’;
if($d = get_field(‘datum’)) $extra .= ‘<p><strong>Datum:</strong> ‘.esc_html($d).'</p>’;
$s = get_field(‘starttijd’); $e = get_field(‘eindtijd’);
if($s && $e) $extra .= ‘<p><strong>Tijd:</strong> ‘.esc_html($s).’ – ‘.esc_html($e).'</p>’;
elseif($s) $extra .= ‘<p><strong>Tijd:</strong> ‘.esc_html($s).'</p>’;
if($b = get_field(‘beschrijving’)) $extra .= ‘<div class=”agenda-beschrijving-loop”>’.wp_kses_post($b).'</div>’;
if($t = get_field(’ticket’)) $extra .= ‘<p><a href=”‘.esc_url($t).'” target=”_blank” class=”agenda-ticket”>Tickets</a></p>’;
if($a = get_field(‘afbeelding’)) $extra .= ‘<div class=”agenda-afbeelding”>’.wp_get_attachment_image($a, ‘medium’).'</div>’;
$extra .= ‘</div>’;
return $content.$extra;
}
return $content;
});

// Maandlijst shortcode
add_shortcode(‘agenda_maandlijst’, function() {
global $wpdb;
$base_url = is_post_type_archive(‘agenda’) ? get_post_type_archive_link(‘agenda’) : esc_url(add_query_arg([], home_url(add_query_arg([], $_SERVER[‘REQUEST_URI’]))));

$results = $wpdb->get_results(“
SELECT DISTINCT DATE_FORMAT(meta_value,’%Y-%m’) AS maand
FROM $wpdb->postmeta
INNER JOIN $wpdb->posts ON $wpdb->posts.ID=$wpdb->postmeta.post_id
WHERE $wpdb->postmeta.meta_key=’datum’
AND $wpdb->posts.post_type=’agenda’
AND $wpdb->posts.post_status=’publish’
ORDER BY maand ASC
“);

if ($results) {
echo ‘<div class=”agenda-maandlijst”><ul>’;
foreach ($results as $r) {
$ts = strtotime($r->maand . ‘-01’);
$label = ucfirst(date_i18n(‘F Y’, $ts));
$link = add_query_arg(‘agenda_maand’, $r->maand, $base_url);
echo ‘<li><a href=”‘ . esc_url($link) . ‘”>’ . esc_html($label) . ‘</a></li>’;
}
echo ‘</ul></div>’;
}
});

// Shortcode agenda items met maandfilter
add_shortcode(‘agenda_blocksy’, function($atts){
$atts = shortcode_atts([‘posts’=>10], $atts, ‘agenda_blocksy’);

$meta_query = [];
if(isset($_GET[‘agenda_maand’])) {
$m = sanitize_text_field($_GET[‘agenda_maand’]);
$meta_query[] = [
‘key’ => ‘datum’,
‘value’ => [$m.’-01′, date(‘Y-m-t’, strtotime($m.’-01′))],
‘compare’ => ‘BETWEEN’,
’type’ => ‘DATE’
];
}

$q = new WP_Query([
‘post_type’ => ‘agenda’,
‘posts_per_page’ => intval($atts[‘posts’]),
‘post_status’ => ‘publish’,
‘meta_query’ => $meta_query
]);

$out = ‘<div class=”agenda-archive-wrapper”>’;
if($q->have_posts()){
while($q->have_posts()){
$q->the_post();
$d = get_field(‘datum’); $s = get_field(‘starttijd’); $e = get_field(‘eindtijd’);
$b = get_field(‘beschrijving’); $t = get_field(’ticket’); $a = get_field(‘afbeelding’);

$out .= ‘<div class=”agenda-info-loop”><h3><a href=”‘.get_permalink().'”>’.get_the_title().'</a></h3><div class=”agenda-item-flex”>’;
$out .= ‘<div class=”agenda-afbeelding-col”>’;
$f = get_the_post_thumbnail(get_the_ID(),’medium’); if($f) $out .= $f;
if($a) $out .= wp_get_attachment_image($a,’medium’);
$out .= ‘</div><div class=”agenda-content-col”>’;
if($d) $out .= ‘<p><strong>Datum:</strong> ‘.esc_html($d).'</p>’;
if($s) $out .= ‘<p><strong>Tijd:</strong> ‘.esc_html($s).($e?’ – ‘.esc_html($e):”).'</p>’;
if($b) $out .= ‘<div class=”agenda-beschrijving-loop”>’.wp_kses_post($b).'</div>’;
if($t) $out .= ‘<p><a href=”‘.esc_url($t).'” target=”_blank” class=”agenda-ticket”>Tickets</a></p>’;
$out .= ‘</div></div></div>’;
}
wp_reset_postdata();
} else $out .= ‘<p>Geen agenda-items gevonden.</p>’;
$out .= ‘</div>’;

return $out;
});

// Filter maand voor CPT-archief
add_action(‘pre_get_posts’, function($query){
if(!is_admin() && $query->is_main_query() && is_post_type_archive(‘agenda’) && isset($_GET[‘agenda_maand’])){
$m = sanitize_text_field($_GET[‘agenda_maand’]);
$query->set(‘meta_query’, [[
‘key’ => ‘datum’,
‘value’ => [$m.’-01′, date(‘Y-m-t’, strtotime($m.’-01′))],
‘compare’ => ‘BETWEEN’,
’type’ => ‘DATE’
]]);
}
});