>
>
>
> '; // Begin the link the_title(); // Display the title echo ''; // Close the link echo $params['after']; // Output the title after markup } /** * generate_after_entry_title hook. * * @since 0.1 * * @hooked generate_post_meta - 10 */ do_action( 'generate_after_entry_title' ); $campaign_tracking_id = get_field('campaign_tracking_id', $post_id); ?>
> prefix . 'rl_mailwarmer_messages'; $conversations_table = $wpdb->prefix . 'rl_mailwarmer_conversations'; // Total stats $total_messages = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM $messages_table WHERE campaign_id = %d", $post_id )); $sent_messages = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM $messages_table WHERE campaign_id = %d AND status = 'sent'", $post_id )); $failed_messages = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM $messages_table WHERE campaign_id = %d AND status = 'failed'", $post_id )); $pending_messages = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM $messages_table WHERE campaign_id = %d AND status = 'new'", $post_id )); $total_conversations = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM $conversations_table WHERE campaign_id = %d", $post_id )); // Email accounts used in this campaign $email_accounts = $wpdb->get_results($wpdb->prepare( "SELECT DISTINCT email_account_id FROM $conversations_table WHERE campaign_id = %d", $post_id )); // Upcoming messages (next 7 days) $today = current_time('Y-m-d'); $next_week = date('Y-m-d', strtotime('+7 days')); $upcoming_messages = $wpdb->get_results($wpdb->prepare( // "SELECT COUNT(*) "SELECT id, scheduled_for_timestamp, from_email, to_email, subject FROM $messages_table WHERE campaign_id = %d AND (status = 'new' OR status = 'scheduled') AND scheduled_for_timestamp BETWEEN %s AND %s ORDER BY scheduled_for_timestamp ASC LIMIT 20", $post_id, $today, $next_week )); // Recently sent messages $sent_message_list = $wpdb->get_results($wpdb->prepare( "SELECT id, scheduled_for_timestamp, from_email, to_email, subject, status FROM $messages_table WHERE campaign_id = %d AND (status = 'sent' OR status = 'failed') ORDER BY scheduled_for_timestamp DESC LIMIT 20", $post_id )); ?>

Campaign Stats

Total Messages
Sent Messages
Failed Messages
Pending Messages
Total Conversations

Email Accounts

No email accounts associated with this campaign.

    email_account_id); if (!empty($email)) : ?>

Upcoming Messages (Next 7 Days)

No upcoming messages scheduled for the next 7 days.

Scheduled For From To Subject
scheduled_for_timestamp ? esc_html(date('Y-m-d H:i', strtotime($message->scheduled_for_timestamp))) : ''; ?> from_email ? esc_html($message->from_email) : '[Not Set Yet]'; ?> to_email ? esc_html($message->to_email) : '[Not Set Yet]'; ?> subject ? esc_html($message->subject) : '[Not Set Yet]'; ?>

Recent Messages

No messages have been sent yet.

Sent At From To Subject Status
scheduled_for_timestamp))); ?> from_email); ?> to_email); ?> subject); ?> status)); ?>
'
' . __( 'Pages:', 'generatepress' ), 'after' => '
', ) ); ?>