在页面上按日期排序的列表中显示自定义文章类型的自定义字段

Question

我正在努力解决这个问题。我添加了多个自定义字段值：在这种情况下，事件日期及其标题和位置到我的所有项目中(自定义帖子类型(，并希望将它们一起显示在名为日历的页面上的表中。我试图查询帖子，但随后自定义字段将一起显示为组，而不是按日期排序的列表。

在这种情况下，事件标题与帖子标题匹配。

我的问题是：什么是最好的解决方案？将所有事件日期创建为帖子中的自定义字段，然后将它们一起显示在一个名为日历的页面上，还是将它们全部创建在一个日历页面中，然后按标题筛选，以仅显示单个帖子中与页面标题匹配的相关日期？

事件名称取自post对象，这似乎是在同一页面上创建所有事件的场景的最佳解决方案，但从其他方面来看，我可能只使用post标题。

希望有人能帮忙！

我的日历代码(包含即将到来的日期的部分(：

<div class="Rtable upcoming  Rtable--collapse">

<?php $outs = array(); if( have_rows('events') ):  ?>


<?php while ( have_rows('events') ) : the_row();  ob_start();
// Get sub field values.
$date = get_sub_field('date');    
$location = get_sub_field('location');
$website = get_sub_field('website');
$title = get_sub_field('title');
$premiere = get_sub_field('premiere');
$event = get_sub_field('date', false, false);
$today = strtotime(date('Ymd'));
$upcoming = strtotime($event);
$datefin = new DateTime($event); ?>

<?php if ($upcoming >=$today): ?>




<div class="Rtable-cell Rtable-cell--head <?php if( get_sub_field('premiere') == 'yes' ): ?>premiere <?php endif; ?>">
<?php if( get_sub_field('date') ): ?><?php the_sub_field('date'); ?><?php endif; ?>
</div>

<div class="Rtable-cell table-project-title"><?php if( get_sub_field('premiere') == 'yes' ): ?><span style="color: var(--magenta);">premiere:</span> <?php endif; ?>

<?php if( $title ): ?><?php foreach( $title as $post ): 
// Setup this post for WP functions (variable must be named $post).
setup_postdata($post); ?><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a> <?php endforeach; ?> <?php 
// Reset the global post object so that the rest of the page works correctly.
wp_reset_postdata(); ?> <?php endif; ?>


</div>


<div class="Rtable-cell"><?php if( get_sub_field('location') ): ?><?php the_sub_field('location'); ?><?php endif; ?></div>
<div class="Rtable-cell Rtable-cell--foot"><?php if( get_sub_field('website') ): ?><a class="button" href="<?php echo esc_url( $website ); ?>" target="_blank">Tickets</a> <?php endif; ?></div>


<?php endif; ?>
<?php $outs[] = ob_get_clean(); endwhile; ?>

<?php
else :
endif;
$outs = array_reverse($outs);
echo implode($outs);
?>
</div><!-- UPCOMING END -->

Answer 1

我找到了解决方案，按自定义字段日期查询。此处的结果：

<?php
/**
* Template Name: Calendar
*/
get_header();
?>
<?php get_header();
?>
<div class="content-header yellow">
<h1><?php the_title();
?></h1>
</div>
<!-- Kalender -->
<div class="yellow content">
<div class="Rtable upcoming  Rtable--collapse">
<?php
// Create an empty array for storage
$post_data = array();
// Set arguments for your query
$args = array(
'post_type'         => 'projects',
'posts_per_page'    => -1
);
// Do our query with any arguments from above
$query = new WP_Query( $args );
if ( $query->have_posts() ) {
while ( $query->have_posts() ) {
$query->the_post();
// Setup our repeater
if ( have_rows( 'events' ) ):
while ( have_rows( 'events' ) ) : the_row();
// Optional - Only get posts that match a true false within our repeater
$event = get_sub_field( 'date', false, false );
$today = strtotime( date( 'Ymd' ) );
$upcoming = strtotime( $event );
$datefin = new DateTime( $event );


if ( $upcoming >= $today ) {
// Build our array with the data we need using key => value
$post_data[] = array(
'url' => get_the_permalink(),
'title' => get_the_title(),
'date'  => get_sub_field( 'date' ),
'location'  => get_sub_field( 'location' ),
'website'  => get_sub_field( 'website' ),
);
}
endwhile;
endif;
}
} ?>

<?php // Custom function to use in our sort to list the items by date
function subval_sort( $a, $b ) {
if ( $a['date'] == $b['date'] )
return 0;
return $a['date'] < $b['date'] ? -1 : 1;
}
// Sort our multidimensional array by sub array value
usort( $post_data, 'subval_sort' );
// We can now work our data normally through easy to access methods
foreach ( $post_data as $post ) {
?>
<div class="Rtable-cell Rtable-cell--head <?php if( get_sub_field('premiere') == 'yes' ): ?>premiere <?php endif; ?>">
<?php   $format_in = 'm/d/Y';
// the format your value is saved in ( set in the field options )
$format_out = 'd/m/Y';
// the format you want to end up with
$date = DateTime::createFromFormat( $format_in, $post['date'] );
echo $date->format( $format_out ) . '&nbsp; ' ;
?>
</div>
<div class="Rtable-cell table-project-title"><?php if ( get_sub_field( 'premiere' ) == 'yes' ): ?><span style="color: var(--magenta);">premiere:</span> <?php endif;
?>
<a href="<?php echo $post['url']; ?> ">
<?php
echo $post['title'] . '&nbsp; ' ;
?>
</a>
</div>
<div class="Rtable-cell">
<?php echo $post['location'] . '&nbsp; ' ;

?>
</div>
<div class="Rtable-cell Rtable-cell--foot">
<a class="button" href="<?php
echo $post['website']; ?> ">
tickets
</a>
</div>
<?php }
?>

</div>

</div>
<?php get_footer();
?>