lot kob
0
Q:

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;
}
0

New to Communities?

Join the community