[Resolved] Date comparisons in conditional shortcodes

[Author]

Posts

[donaldM-2]

I have a custom field called last paid. I would like to compare that date to the current date and if the difference is greater than a year, I would like to show a red circle. If it is less than a year, green dot. I can take care of the dots and styling but the code to show them I am having issues with.

Link here:

hidden link

I would like to show the dot on the single page for the profile maybe next to their name and on this page: hidden link as well. I am thinking next to their name as well to the right.

[Nigel]

Hi Donald

I was testing the solution before proposing it to you, but it doesn't seem to be working as expected.

I'm just waiting for feedback from colleagues and then I'll update you again.

[Nigel]

Hi Donald

So testing this has uncovered what looks like a bug with calculations in conditional shortcodes (we need to calculate today minus one year).

Rather than have you wait on a fix I have written a quick code snippet.

Add the following code to your theme's functions.php file or using a plugin such as Code Snippets:

function tssupp_within_year( $user_id ){

	if ( !isset( $user_id ) ) {
		$user_id = get_current_user_id();
	}

	$user_date_field = 'wpcf-last-paid'; // edit if required

	$user_date_value = get_user_meta( $user_id, $user_date_field, true );

	$one_year_ago = time() - 60*60*24*365;

	return ( $user_date_value > $one_year_ago );
}

You need to register this function to be able to use it inside conditional shortcodes at Toolset > Settings > Front-end Content

Now, I'm not sure how you have set up the member account page.

The function needs to know the ID of the user it will get the last-paid field from. By default if you don't specify a user ID it will assume the current logged-in user.

Then when you want to conditionally display some content you can do so like so:

          [wpv-conditional if="( 'tssupp_within_year( )' )"]
          <p>Green</p>
          [/wpv-conditional]
          [wpv-conditional if="( 'tssupp_within_year( )' )" evaluate="false"]
          <p>Red</p>
          [/wpv-conditional]

Note I haven't specified a user ID as an argument in the function.

Depending on how you have set up the member page you may need to use the wpv-user shortcode to output the ID of the required user, for example: https://toolset.com/documentation/user-guides/views-shortcodes/#wpv-user

[donaldM-2]

So that is great. Yes it won't be grabbing the user logged in than just associate the time check with the post it is on or associated to. I guess the user ID

[Nigel]

The last-paid field is a user field not a post field.

How does the page in question know which user it is displaying data for? How do you have this set up?

[donaldM-2]

The last-paid is a custom field assigned to the post type members. When editing the post "member", the admin enters the last paid date for that member. See screenshot.

Then I show it in the content template for the single member. See screenshot.

I just need to compare it to the current date. Whether anyone is logged in or not.

[Nigel]

Hi Donald

Sorry, I misunderstood. Because you were displaying a member profile I took it to me this was based on users, but you have a custom post type for it.

In which case we have the same problem with the bug in conditional shortcodes, and the code I suggested needs to be modified.

Try this instead:

function tssupp_within_year(){

	global $post;

	$date_field = 'wpcf-last-paid'; // edit if required

	$date_value = get_post_meta( $post->ID, $date_field, true );

	$one_year_ago = time() - 60*60*24*365;

	return ( $date_value > $one_year_ago );
}

You use it the same way as I described before, first registering the function for use inside conditional statements, and then adding something like the following wherever you want the red or green to appear in your content template for members.

[wpv-conditional if="( 'tssupp_within_year( )' )"]
<p>Green</p>
[/wpv-conditional]
[wpv-conditional if="( 'tssupp_within_year( )' )" evaluate="false"]
<p>Red</p>
[/wpv-conditional]

[donaldM-2]

That worked like a charm! Thank you. Is there any way to make it work on the members list page too? hidden link

McGuinn,Donald should be green as well as Lehnen, Travis.

[donaldM-2]

Sorry. My caching plugin wasn't showing it right! Everything works now! Thank you so much.