List recurring events in chronological order WordPress

Christoph comments:

I'm not trying to just sort the dates of one post (event). I need to create a page (custom page template) that lists ALL posts (events) sorted according to the date that's in the date/time/location array. I think i need to create another custom array, pior to listing.

Peter Michael comments:

You want to sort the posts (and events) according to the dates in the 'termin_date' field?

Christoph comments:

Yes, the final list would (simplified) look something like this:
<strong>POST 1</strong> on Feb 3
<strong>POST 2</strong> on Feb 4
<strong>POST 2</strong> on Feb 8
<strong>POST 1</strong> on Feb 13

Peter Michael comments:

Why not set the post date to the earliest event date and sort the event locations like I mentioned before?

Christoph comments:

<strong>(1)</strong> The user should not have to touch the post date.
<strong>(2)</strong> This would give me a list like:
<strong>POST 1</strong> on Feb 3
<strong>POST 1</strong> on Feb 13
<strong>POST 2</strong> on Feb 4
<strong>POST 2</strong> on Feb 8

Peter Michael comments:

You should tell WPAlchemy to store data in [[LINK href="http://farinspace.com/wpalchemy-metabox-data-storage-modes/"]]Extract Mode[[/LINK]].

Also, you need to combine the 'termin_date' and 'termin_time' value and create timestamps. With the post_id/timestamp combination, you can create loops to first order the posts and then the event locations.

Christoph comments:

WPAlchemy 'Extract Mode' does not work with WPAlchemy's have_fields() function, which i use to [[LINK href="http://i.imgur.com/h5zCd.png"]]duplicate the field group[[/LINK]] (date/time/location)

Peter Michael comments:

Use 'have_fields_and_multi($name)' ?

Christoph comments:

Yes, possibility to duplicate the input fields is a requirement.

Peter Michael comments:

You use 'have_fields()' or 'have_fields_and_multi()' ? You should use the latter I think.

Christoph comments:

I use have_fields_and_multi()

Christoph comments:

It is a playing schedule for a theatre. Ideally all future posts from custom post type 'event' should be listed, starting with the current month. The date is not the post time stamp but the date from the custom meta box field. That means also one post can occur several times.

Sébastien | French WordpressDesigner comments:

use a query post like this :
$args = array(
'meta_query' => array(
'key' => 'termine_date'
),
'orderby' => 'meta_value_num'
)
query_posts( $args );

Sébastien | French WordpressDesigner comments:

example to display all the posts :

<?php



$args = array(
'meta_query' => array(
'key' => 'termine_date'
),
'orderby' => 'meta_value_num'
)
query_posts( $args );
if (have_posts()) :
while (have_posts()) : the_post();

$termindate = get_post_meta($post->ID, "termine_date", TRUE);

$daytermindate = mysql2date('D', $termin['termin_date'], true);
$datetermindate = mysql2date('j F Y', $termin['termin_date'], true);

$termintime = get_post_meta($post->ID, "termine_time", TRUE);
$terminlocation = get_post_meta($post->ID, "termine_location", TRUE);


if ($daytermindate) {echo $daytermindate;} //if dayterminate exist, echo dayterminedate
if ($datetermindate) {echo $datetermindate;} //if datedayterminate exist, echo datedayterminedate
if ($termintime) {echo $termintime;} //if termintime exist, echo termintime
if ($terminlocation) {echo $terminlocation;} //if $terminlocation exist, echo $terminlocation






<?php
endwhile;
else :
endif;
?>


Christoph comments:

'termin_date' is not stored as individual meta-value. It is in an array with meta_key _events_termine

Sébastien | French WordpressDesigner comments:

a little error above
use this

<?php
$args = array(
'meta_query' => array(
'key' => 'termine_date'
),
'orderby' => 'meta_value_num'
)
query_posts( $args );
if (have_posts()) :
while (have_posts()) : the_post();

$termindate = get_post_meta($post->ID, "termine_date", TRUE);

$daytermindate = mysql2date('D', $termin['termin_date'], true);
$datetermindate = mysql2date('j F Y', $termin['termin_date'], true);

$termintime = get_post_meta($post->ID, "termine_time", TRUE);
$terminlocation = get_post_meta($post->ID, "termine_location", TRUE);


if ($daytermindate) {echo $daytermindate;} //if dayterminate exist, echo dayterminedate
if ($datetermindate) {echo $datetermindate;} //if datedayterminate exist, echo datedayterminedate
if ($termintime) {echo $termintime;} //if termintime exist, echo termintime
if ($terminlocation) {echo $terminlocation;} //if $terminlocation exist, echo $terminlocation

endwhile;
else :
endif;
?>


Christoph comments:

Thank you Sébastien, but as i see it, your query would only work if the dates were stored as individual custom fields with the same meta_key. In fact they are stored as array (see question).

Sébastien | French WordpressDesigner comments:

could i test it ? i need login to your wp-admin
you can send me it at maildeseb @ gmail .com

Sébastien | French WordpressDesigner comments:

It's ok if you create your custom meta bow with 'mode' => WPALCHEMY_MODE_EXTRACT,

There is no problem

Christoph comments:

WPAlchemy 'Extract Mode' does not work with WPAlchemy's have_fields() functions, which i use to [[LINK href="http://i.imgur.com/h5zCd.png"]]duplicate the field group[[/LINK]] (date/time/location)