[Resolved] Sorting and styling dates from a repeating custom field

[Author]

Posts

[toolset-dave]

Hi,

can you show me how to sort multiple dates from the oldest to the most future ones and if the date is in previous date than now it will be decoraded with line-through?

[types field='my-date' style='text' format='j. F Y %o%d G:i' separator='<br>'][/types]

[Christian Cox]

Is the my-date field set up to allow multiple values, or is it a single value field on multiple posts? If it's a single field on multiple posts, then you can create a View of posts, sorted by your custom date field, in ascending order. Then in your Loop Output you can use a conditional that tests the value of the my-date field, and applies a line-through style using CSS:

<span [wpv-conditional if='( $(wpcf-my-date) lt "TODAY()" )']style="text-decoration:line-through"[/wpv-conditional]>[types field='my-date' style='text' format='j. F Y %o%d G:i'][/types]</span>

Let me know if I've misunderstood your request, and I'll take another look.
- edit - updated date format to match your original post.

[toolset-dave]

Hi, my-date field is allowed to have multiple values in single post. Sorry for not mentioning it before. Btw I will use this code for multiple posts too, thanks.

[Christian Cox]

Types does not offer a method for sorting those fields within a single post, unfortunately. You can use the wpv-for-each shortcode to loop over each field and apply the line-through styles like I was describing earlier, but sorting the display of those field values would require custom code. More information about displaying repeating fields here:
https://toolset.com/documentation/user-guides/repeating-fields/

[toolset-dave]

I tried to combine the codes, but the result not work for me:

[wpv-for-each field="wpcf-my-date"]
<span [wpv-conditional if='( $(wpcf-my-date) lt "TODAY()" )']style="text-decoration:line-through"[/wpv-conditional]>[types field='my-date' style='text' format='j. m Y %o%d G:i'][/types]</span><br>
[/wpv-for-each]

Each date is decorated with the style even if it is in future.

Can you help me to create custom shortcode with sorting?

[Christian Cox]

Add this to functions.php:

add_shortcode( 'sort_and_format_post_date_fields', 'sort_and_format_post_date_fields_func');
function sort_and_format_post_date_fields_func($atts = [])
{
  $atts = shortcode_atts([
    'postid' => '',
    'field' => '',
    'format' => 'l F jS Y',
  ], $atts);
  $values = get_post_meta($atts['postid'], 'wpcf-my-date');
  usort($values, 'numbersort');
  $string = '';
  foreach($values as $value) {
    $date = date($atts['format'], $value);
    $prefix = $value < strtotime('0:00:00') ? '<span style="text-decoration:line-through;">' : '';
    $suffix = $value < strtotime('0:00:00') ? '</span>' : '';
    $string .= ($string == '' ? '' : ', ') . $prefix . $date . $suffix;
  }

  return $string;
}

function numbersort($a, $b)
{
  $res = 0;
  if ( $a > $b) {
     $res = 1;
  }
  return $res;
}

Then use it by placing this in the content of the post that includes the date field:

[sort_and_format_post_date_fields postid="[wpv-post-id]" field="my-date" format="l F jS Y"]

[toolset-dave]

Hi Christian,

thank you so much for the code, it´s great! I have made some cosmetic edits. But there is one think I can´t solve. The formating of date is the same as I use on the web, but the month ("F") is displaying in English instead of my Czech language, which is set as default in WordPress.

[Christian Cox]

Okay I see, try updating the code at line 13 to use the date_i18n function instead of the date function:

$date = date_i18n($atts['format'], $value);

[toolset-dave]

Works perfectly. Thank you, Christian.