send mail in every on minute in wordpress through cron
/**
* @snippet Schedule Email to WooCommerce Admin Every 3 Hours
* @how-to Get CustomizeWoo.com FREE
* @sourcecode https://businessbloomer.com/?p=106360
* @author Rodolfo Melogli
* @compatible WooCommerce 3.5.4
* @donate $9 https://businessbloomer.com/bloomer-armada/
*/
// ---- ---- ----
// A. Define a cron job interval if it doesn't exist
add_filter( 'cron_schedules', 'bbloomer_check_every_3_hours' );
function bbloomer_check_every_3_hours( $schedules ) {
$schedules['every_three_hours'] = array(
'interval' => 10800,
'display' => __( 'Every 3 hours' ),
);
return $schedules;
}
// ---- ---- ----
// B. Schedule an event unless already scheduled
add_action( 'wp', 'bbloomer_custom_cron_job' );
function bbloomer_custom_cron_job() {
if ( ! wp_next_scheduled( 'bbloomer_woocommerce_send_email_digest' ) ) {
wp_schedule_event( time(), 'every_three_hours', 'bbloomer_woocommerce_send_email_digest' );
}
}
// ---- ---- ----
// C. Trigger email when hook runs
add_action( 'bbloomer_woocommerce_send_email_digest', 'bbloomer_generate_email_digest' );
// ---- ---- ----
// D. Generate email content and send email if there are completed orders
function bbloomer_generate_email_digest() {
$range = 180; // 3 hours in minutes
$completed_orders = bbloomer_get_completed_orders_before_after( strtotime( '-' . absint( $end ) . ' MINUTES', current_time( 'timestamp' ) ), current_time( 'timestamp' ) );
if ( $completed_orders ) {
$email_subject = "Completed Orders Email Digest";
$email_content = "Completed Order IDs: " . implode( "|", $completed_orders );
wp_mail( '[email protected]', $email_subject, $email_content );
}
}
// ---- ---- ----
// E. Query WooCommerce database for completed orders between two timestamps
function bbloomer_get_completed_orders_before_after( $date_one, $date_two ) {
global $wpdb;
$completed_orders = $wpdb->get_col(
$wpdb->prepare(
"SELECT posts.ID
FROM {$wpdb->prefix}posts AS posts
WHERE posts.post_type = 'shop_order'
AND posts.post_status = 'wc-completed'
AND posts.post_modified >= '%s'
AND posts.post_modified <= '%s'",
date( 'Y/m/d H:i:s', absint( $date_one ) ),
date( 'Y/m/d H:i:s', absint( $date_two ) )
)
);
return $completed_orders;
}