is_action( 'feed_enable' ) ) { delete_option( 'newsletter_feed_demo_disable' ); $controls->messages = 'Feed by Mail demo panels enabled. On next page reload it will show up.'; } if ( $controls->is_action( 'feed_disable' ) ) { update_option( 'newsletter_feed_demo_disable', 1 ); $controls->messages = 'Feed by Mail demo panel disabled. On next page reload it will disappear.'; } $emails_module = NewsletterEmails::instance(); $emails = $wpdb->get_results( "select * from " . NEWSLETTER_EMAILS_TABLE . " where type='message' order by id desc limit 5" ); $users_module = NewsletterUsers::instance(); $query = "select * from " . NEWSLETTER_USERS_TABLE . " order by id desc"; $query .= " limit 10"; $subscribers = $wpdb->get_results( $query ); // Retrieves the last standard newsletter $last_email = $wpdb->get_row( $wpdb->prepare( "select * from " . NEWSLETTER_EMAILS_TABLE . " where type='message' and status in ('sent', 'sending') and send_on<%d order by id desc limit 1", time() ) ); if ( $last_email ) { $last_email_sent = $last_email->sent; $last_email_opened = NewsletterStatistics::instance()->get_open_count( $last_email->id ); $last_email_notopened = $last_email_sent - $last_email_opened; $last_email_clicked = NewsletterStatistics::instance()->get_click_count( $last_email->id ); $last_email_opened -= $last_email_clicked; $overall_sent = $wpdb->get_var( "select sum(sent) from " . NEWSLETTER_EMAILS_TABLE . " where type='message' and status in ('sent', 'sending')" ); $overall_opened = $wpdb->get_var( "select count(distinct user_id,email_id) from " . NEWSLETTER_STATS_TABLE ); $overall_notopened = $overall_sent - $overall_opened; $overall_clicked = $wpdb->get_var( "select count(distinct user_id,email_id) from " . NEWSLETTER_STATS_TABLE . " where url<>''" ); $overall_opened -= $overall_clicked; } else { $last_email_opened = 500; $last_email_notopened = 400; $last_email_clicked = 200; $overall_opened = 500; $overall_notopened = 400; $overall_clicked = 200; } $months = $wpdb->get_results( "select count(*) as c, concat(year(created), '-', date_format(created, '%m')) as d " . "from " . NEWSLETTER_USERS_TABLE . " where status='C' " . "group by concat(year(created), '-', date_format(created, '%m')) order by d desc limit 12" ); $values = array(); $labels = array(); foreach ( $months as $month ) { $values[] = (int) $month->c; $labels[] = date( "M y", date_create_from_format( "Y-m", $month->d )->getTimestamp() ); } $values = array_reverse( $values ); $labels = array_reverse( $labels ); ?>

create and send your first newsletter to have real statistics!', 'newsletter' ) ?>

subject ) { echo htmlspecialchars( $email->subject ); } else { echo "Newsletter #" . $email->id; } ?> show_email_status_label( $email ) ?> show_email_progress_bar( $email, array( 'scheduled' => true ) ) ?> get_edit_button($email) ?>
options['contract_key'] ) ) { ?>

email ) ?>
name ) ?> surname ) ?> 		get_user_status_label( $s ) ?>