|
Some processes, such as property matching, can result in a lot of emails being sent at once. To cater for this we queue emails and send them out in batches at regular intervals.
Using this screen you can see which emails have been sent, which have failed, and how many are queued to be sent.
Run Now
get_var("
SELECT COUNT(*)
FROM " . $wpdb->prefix . "ph_email_log
WHERE
method = 'email'
");
?>
- >All () |
get_var("
SELECT COUNT(*)
FROM " . $wpdb->prefix . "ph_email_log
WHERE
method = 'email'
AND
status = ''
");
?>
- >Queued () |
get_var("
SELECT COUNT(*)
FROM " . $wpdb->prefix . "ph_email_log
WHERE
method = 'email'
AND
status IN ('fail1', 'fail2')
");
?>
- >Failed () |
get_var("
SELECT COUNT(*)
FROM " . $wpdb->prefix . "ph_email_log
WHERE
method = 'email'
AND
status = 'sent'
");
?>
- >Sent ()
|
|
|
|
|
prefix . "ph_email_log
WHERE
method = 'email' ";
if ( isset($_GET['status']) )
{
switch ( $_GET['status'] )
{
case "queued": { $query .= " AND status = '' "; break; }
case "failed": { $query .= " AND status IN ('fail1', 'fail2') "; break; }
case "sent": { $query .= " AND status = 'sent' "; break; }
}
}
$query .= " ORDER BY send_at DESC
LIMIT 250
";
$emails = $wpdb->get_results( $query );
foreach ( $emails as $email )
{
?>
| send_at)); ?> |
contact_id) . '">' . get_the_title($email->contact_id) . '
' . $email->to_email_address; ?> |
subject; ?> |
status)
{
case "fail1": { echo 'First attempt failed. Will retry'; break; }
case "fail2": { echo 'Failed after 2 attempts'; break; }
case "sent": { echo 'Sent'; break; }
default: { echo 'Queued'; }
}
?> |
View Email
|
|
get_email_queue_settings(); $hide_save_button = true; break; }
default: { die("Unknown setting section"); }
}
}
else
{
$settings = $this->get_settings();
}
PH_Admin_Settings::output_fields( $settings );
}
/**
* Save settings.
*/
public function save() {
PH_Admin_Settings::save_fields( $this->get_settings() );
if ( isset($_POST['propertyhive_auto_property_match']) && $_POST['propertyhive_auto_property_match'] == '1' )
{
update_option( 'propertyhive_auto_property_match_enabled_date', date("Y-m-d H:i:s"), FALSE);
wp_schedule_event( time(), 'hourly', 'propertyhive_auto_email_match' ); // Skew it by 30 minutes to reduce conflict with email log processing
}
else
{
wp_clear_scheduled_hook( 'propertyhive_auto_email_match' );
}
}
}
endif;
return new PH_Settings_Emails();