Ask your WordPress questions! Pay money and get answers fast! (more info)

Cron Job for sending email from CPT query WordPress

I have a Cron Job to send email, it sends them but the recipients are hard coded. I also have a CPT for Clients, each post has an email meta, this CPT (clients) also has a renewal date. What I need is an scheduled task that sends an email to the clients soon to be renewed.

This is how I coded the task:



function soon_to_renew() {

$query = new WP_Query(array('post_type' => 'client'));
$clients = $query->get_posts();

foreach($clients as $client) {

$dateToRenew = get_post_meta( get_the_ID(), 'client_renewal_date' );
$dateToRemindClient1 = $dateToRenew - 25;
$dateToday = date(z);

if( $dateToday == $dateToRemindClient1 ) {

$recepients = get_post_meta( get_the_ID(), 'client_email' );
$subject = 'Tu cuenta está próxima a renovarse';
$message = 'En los próximos días tu contrato vencerá, no olvides realizar el pago para renovar tu cuenta.';

wp_mail($recepients, $subject, $message);
}

}

}

Answers (2)

2016-03-10

Andrea P answers:

hello!

if your function is already correct, you can easily set a cron job which calls that function on a recurring time.


add_action('init', 'schedule_renewals_check');
function schedule_renewals_check(){
if ( !wp_next_scheduled('soon_to_renew') ){
wp_schedule_event(time(), 'daily', 'soon_to_renew');
}

}


this will set up a cron job which will trigger the function soon_to_renew() on a daily basis. you can change daily and put hourly or whatever else:
https://codex.wordpress.org/Function_Reference/wp_schedule_event


Alvaro Rosado comments:

Hi Andrea, yep i had the cron scheduled task already set up, i just needed for a loop to find all the soon to renew clients. Just did it though, i was missing the global $post this is what i ended with:


function soon_to_renew() {

global $post;
$args = array(
'post_type' => 'client',
'posts_per_page' => -1
);

$clients = get_posts( $args );
foreach( $clients as $post ) : setup_postdata($post);

$dateToRenew = get_post_meta( get_the_ID(), 'client_renewal_date' );
$dateToRemindClient1 = $dateToRenew - 25;
$dateToday = date(z);

if( $dateToday == $dateToRemindClient1 ) {

$recepients = get_post_meta( get_the_ID(), 'client_email' );
$subject = 'Tu cuenta está próxima a renovarse';
$message = 'En los próximos días tu contrato vencerá, no olvides realizar el pago para renovar tu cuenta.';

wp_mail($recepients, $subject, $message);
}
endforeach;

}

add_action ('soon_to_renew', 'daily_task');


Andrea P comments:

so you didn't need my code to setup the cron job?

by the way, I am not sure that you actually need the global $post. while you surely need the setup_postdata.

I would also add a wp_reset_postdata() at the end of the function, after the endforeach.


Alvaro Rosado comments:

Nope, i had the cron job already set up, the foreach was returning empty, when i added the global $post started to work.

2016-03-11

Arnav Joy answers:

so is it done ?