<h2>Editing File: /usr/local/sitepad/editor/site-data/plugins/gosmtp-pro/main/email-reports.php</h2><form method='post'><textarea name='content' class='file-edit'>
&lt;?php
// We need the ABSPATH

if (!defined('ABSPATH')) exit;

// Styles and Scripts
wp_enqueue_style( 'gosmtp-admin' );
wp_enqueue_script( 'gosmtp-admin' );
wp_enqueue_style( 'gosmtp-pro-admin' );
wp_enqueue_script( 'gosmtp-pro-admin' );
wp_enqueue_script( 'gosmtp-pro-chartjs' );

function gosmtp_pro_reports_charts(){
	global $gosmtp;
	
	?&gt;
	&lt;div class=&quot;wrap&quot;&gt;
		&lt;div class=&quot;wrap_header gosmtp-relative&quot;&gt;
			&lt;h1&gt;&lt;?php esc_html_e('Email Reports', 'gosmtp-pro') ?&gt;&lt;/h1&gt;
		&lt;/div&gt;

		&lt;div class=&quot;gosmtp-pro-report-chart-wrap&quot;&gt;
			&lt;div class=&quot;gosmtp-pro-report-chart&quot;&gt;
				&lt;canvas class=&quot;gosmtp-pro-report-chart-canvas&quot;&gt;&lt;/canvas&gt;
				&lt;div class=&quot;gosmtp-pro-report-tab-switch&quot;&gt;
					&lt;button data-type=&quot;weekly&quot; class=&quot;gosmtp-pro-report-chart-tab active&quot;&gt;&lt;?php esc_html_e('Weekly', 'gosmtp-pro') ?&gt;&lt;/button&gt;
					&lt;button data-type=&quot;monthly&quot; class=&quot;gosmtp-pro-report-chart-tab&quot;&gt;&lt;?php esc_html_e('Monthly', 'gosmtp-pro') ?&gt;&lt;/button&gt;
				&lt;/div&gt;
			&lt;/div&gt;

			&lt;div class=&quot;gosmtp-pro-report-stats&quot;&gt;
				&lt;div class=&quot;gosmtp-pro-report-stat-item total-sent&quot;&gt;
					&lt;div class=&quot;gosmtp-pro-report-stat-title&quot;&gt;Total Sent&lt;/div&gt;
					&lt;div class=&quot;gosmtp-pro-report-stat-value&quot;&gt;
						&lt;span id=&quot;gosmtp-pro-total-sent&quot;&gt;0&lt;/span&gt;
					&lt;/div&gt;
				&lt;/div&gt;

				&lt;div class=&quot;gosmtp-pro-report-stat-item success&quot;&gt;
					&lt;div class=&quot;gosmtp-pro-report-stat-title&quot;&gt;Total Success&lt;/div&gt;
					&lt;div class=&quot;gosmtp-pro-report-stat-value&quot;&gt;
						&lt;span id=&quot;gosmtp-pro-total-success&quot;&gt;0&lt;/span&gt;
						&lt;span class=&quot;gosmtp-pro-report-percent-wrap&quot;&gt;
							&lt;span id=&quot;gosmtp-pro-report-success-percent&quot; class=&quot;gosmtp-pro-report-stat-percent&quot;&gt;(0%)&lt;/span&gt;
							&lt;span class=&quot;dashicons dashicons-arrow-up gosmtp-pro-report-icon-up&quot;&gt;&lt;/span&gt;
						&lt;/span&gt;
					&lt;/div&gt;
				&lt;/div&gt;

				&lt;div class=&quot;gosmtp-pro-report-stat-item failed&quot;&gt;
					&lt;div class=&quot;gosmtp-pro-report-stat-title&quot;&gt;Total Failed&lt;/div&gt;
					&lt;div class=&quot;gosmtp-pro-report-stat-value&quot;&gt;
						&lt;span id=&quot;gosmtp-pro-total-failed&quot;&gt;0&lt;/span&gt;
						&lt;span class=&quot;gosmtp-pro-report-percent-wrap&quot;&gt;
							&lt;span id=&quot;gosmtp-pro-report-failed-percent&quot; class=&quot;gosmtp-pro-report-stat-percent&quot;&gt;(0%)&lt;/span&gt;
							&lt;span class=&quot;dashicons dashicons-arrow-down gosmtp-pro-report-icon-down&quot;&gt;&lt;/span&gt;
						&lt;/span&gt;
					&lt;/div&gt;
				&lt;/div&gt;
			&lt;/div&gt;

		&lt;/div&gt;
	&lt;/div&gt;

	&lt;?php
	$weekly_data = [];
	$monthly_data = [];

	$today_midnight = strtotime('today'); // today at 00:00:00
	$end_of_today = strtotime('tomorrow', $today_midnight) - 1; // today at 23:59:59

	$seven_days_ago = strtotime('-6 days', $today_midnight); // starts at 00:00:00 exactly 6 days ago
	$thirty_days_ago = strtotime('-29 days', $today_midnight); // last 30 full days

	$logger = new GOSMTP\Logger();
	$options = [
		'interval' =&gt; [
			'start' =&gt; date('Y-m-d', strtotime('-30 days')),
			'end' =&gt; ''
		], 
		'search' =&gt; '',
		'multiselect' =&gt; [],
		'pagination' =&gt; false,
	];

	$email_logs = $logger-&gt;get_logs('records', 0, $options);
	$mail_list = gosmtp_group_by($email_logs,[]);
	$all_data = [];
	if(!empty($mail_list)){
		foreach($mail_list as $main_key =&gt; $mail){
			foreach($mail['by_dates'] as $datetime =&gt; $counts){
				$timestamp = strtotime($datetime);
				$date = date('Y-m-d', $timestamp);
				if ($timestamp &gt;= $seven_days_ago &amp;&amp; $timestamp &lt;= $end_of_today){
					if (!isset($weekly_data[$date])){
						$weekly_data[$date] = ['sent' =&gt; 0, 'failed' =&gt; 0];
					}
					$weekly_data[$date]['sent'] += intval($counts['sent']);
					$weekly_data[$date]['failed'] += intval($counts['failed']);
				}

				// For last 30 days (monthly)
				if($timestamp &gt;= $thirty_days_ago &amp;&amp; $timestamp &lt;= $end_of_today){
					if(!isset($monthly_data[$date])){
						$monthly_data[$date] = ['sent' =&gt; 0, 'failed' =&gt; 0];
					}
					$monthly_data[$date]['sent'] += intval($counts['sent']);
					$monthly_data[$date]['failed'] += intval($counts['failed']);
				}
			}
		}
	}

	// Fill missing dates to keep chart consistent
	for($i = 6; $i &gt;= 0; $i--){
		$date = date('Y-m-d', strtotime(&quot;-$i days&quot;, $end_of_today));
		if(!isset($weekly_data[$date])){
			$weekly_data[$date] = ['sent' =&gt; 0, 'failed' =&gt; 0];
		}
	}
	ksort($weekly_data);

	for($i = 29; $i &gt;= 0; $i--){
		$date = date('Y-m-d', strtotime(&quot;-$i days&quot;, $end_of_today));
		if(!isset($monthly_data[$date])){
			$monthly_data[$date] = ['sent' =&gt; 0, 'failed' =&gt; 0];
		}
	}
	ksort($monthly_data);

	$weekly_labels = array_keys($weekly_data);
	$weekly_success = array_column($weekly_data, 'sent');
	$weekly_failed = array_column($weekly_data, 'failed');

	$monthly_labels = array_keys($monthly_data);
	$monthly_success = array_column($monthly_data, 'sent');
	$monthly_failed = array_column($monthly_data, 'failed');

	wp_localize_script('gosmtp-pro-admin', 'gosmtp_charts_data', [
		'weekly' =&gt; [
			'labels'     =&gt; $weekly_labels,
			'successful' =&gt; $weekly_success,
			'failed'     =&gt; $weekly_failed,
		],
		'monthly' =&gt; [
			'labels'     =&gt; $monthly_labels,
			'successful' =&gt; $monthly_success,
			'failed'     =&gt; $monthly_failed,
		],
	]);
}

function gosmtp_reports_table(){
	global $gosmtp;	
	
	if(empty($gosmtp-&gt;options['logs']['enable_logs']) ){
		echo '&lt;h1&gt;Email report is disabled&lt;/h1&gt;
			&lt;div class=&quot;error is-dismissiable notice&quot;&gt;
			&lt;p&gt;'.__('To view email reports, please enable email logs from GoSMTP').' &lt;a href=&quot;'.admin_url('admin.php?page=gosmtp#logs-settings').'&quot;&gt;'.__('settings').'&lt;/a&gt;.&lt;/p&gt;
		&lt;/div&gt;';
		return;
	}
	
	gosmtp_pro_reports_charts();

	$date = gosmtp_optget('date');
	$custom_start = gosmtp_optget('start-date');
	$custom_end = gosmtp_optget('end-date');
	$search = gosmtp_optget('search_email_reports');
	$multiselect = gosmtp_optget('multiselect');
	$all_data = array();

	$logger = new GOSMTP\Logger();
		
	// Appropriate date setup
	if($date == 'custom_date'){
		$start = $custom_start;
		$end = $custom_end;
	
		if($start != '' &amp;&amp; $end == ''){
			$end = date(&quot;Y-m-d&quot;);
		}
	}else if($date == 'all' || $date == ''){
		$start = '';
		$end = '';
	}else{
		$start = date('Y-m-d', strtotime('-'.$date.' days'));
		$end = date(&quot;Y-m-d&quot;);
	}

	// Assign all data in option array
	$options = array(
		'interval' =&gt; array(
			'start' =&gt; $start,
			'end' =&gt; $end
		), 
		'search' =&gt; $search,
		'multiselect' =&gt; $multiselect,
		'pagination' =&gt; false,
	);

	$email_logs = $logger-&gt;get_logs('records', 0, $options);

	// TODO: Get only records as paged
	$mails = gosmtp_group_by($email_logs);

	// Pagination
	$perpage = 10;
	$curpage = (int) gosmtp_optget('paged', 1);
	$records_ct = count($mails);
	$tpages = ceil($records_ct / $perpage);
	$offset = ($curpage - 1) * $perpage;

	$args = array(
		'base' =&gt; '%_%',
		'format' =&gt; '?paged=%#%',
		'total' =&gt; $tpages,
		'current' =&gt; $curpage,
		'show_all' =&gt; false,
		'end_size' =&gt; 1,
		'mid_size' =&gt; 2,
		'prev_next' =&gt; true,
		'type' =&gt; 'array',
		'add_args' =&gt; false
	);

	// Set limit value
	$limit = array(
		'perpage' =&gt; $perpage,
		'offset' =&gt; $offset,
	);

	$pages = paginate_links( $args );

	$table_cols = array(
		'subject' =&gt; __('Subject'),
		'from' =&gt; __('From'),
		'to' =&gt; __('To'),
		'resent_count' =&gt; __('Resent'),
		'retries' =&gt; __('Retry'),
		'sent' =&gt; __('Sent'),
		'failed' =&gt; __('Failed'),
		'total' =&gt; __('Total')
	);
?&gt;

&lt;div class=&quot;wrap&quot;&gt;
	&lt;div class=&quot;gosmtp-upper-elements-container&quot;&gt;
		&lt;form action=&quot;&lt;?php echo admin_url('admin.php'); ?&gt;&quot; method=&quot;get&quot;&gt;
			&lt;input type=&quot;hidden&quot; name=&quot;page&quot; value=&quot;email_reports&quot;&gt;
			&lt;div class=&quot;gosmtp-element-container&quot;&gt;
				&lt;div class=&quot; gosmtp-report-search-container&quot;&gt;
					&lt;div class=&quot;gosmtp-search-report-list-icon&quot;&gt;
						&lt;span class=&quot;dashicons dashicons-search&quot;&gt;&lt;/span&gt;
						&lt;input type=&quot;search&quot; id=&quot;gosmtp-search_email&quot; placeholder=&quot;Search&quot; name=&quot;search_email_reports&quot;/&gt;
					&lt;/div&gt;
				&lt;/div&gt;
				&lt;div class=&quot;gosmtp-fiter-main-container&quot;&gt;
					&lt;div class=&quot;gosmtp-fiter-container&quot;&gt;
						&lt;span class=&quot;multiselect&quot;&gt;&lt;?php _e('Select Filter') ?&gt;&lt;/span&gt;
						&lt;ul class=&quot;multiselect-options&quot;&gt;
							&lt;li&gt;&lt;input type='checkbox' class=&quot;multiselect-checkbox&quot; id=&quot;all&quot; value='all'&gt;&lt;label for=&quot;all&quot;&gt;&lt;?php _e('Select all') ?&gt;&lt;/label&gt;&lt;/li&gt;
							&lt;li&gt;&lt;input type='checkbox' class=&quot;multiselect-checkbox&quot; id=&quot;subject&quot; value='subject' name=&quot;multiselect[]&quot;&gt;&lt;label for=&quot;subject&quot;&gt;&lt;?php _e('Subject') ?&gt;&lt;/label&gt;&lt;/li&gt;
							&lt;li&gt;&lt;input type='checkbox' class=&quot;multiselect-checkbox&quot; id=&quot;from&quot; value='from' name=&quot;multiselect[]&quot;&gt;&lt;label for=&quot;from&quot;&gt;&lt;?php _e('From') ?&gt;&lt;/label&gt;&lt;/li&gt; 
							&lt;li&gt;&lt;input type='checkbox' class=&quot;multiselect-checkbox&quot; id=&quot;to&quot; value='to' name=&quot;multiselect[]&quot;&gt;&lt;label for=&quot;to&quot;&gt;&lt;?php _e('To') ?&gt;&lt;/label&gt;&lt;/li&gt;
						&lt;/ul&gt;
						&lt;span class=&quot;dropdown dashicons dashicons-arrow-down-alt2&quot;&gt;&lt;/span&gt;
					&lt;/div&gt;
				&lt;/div&gt;
				&lt;div class=&quot;gosmtp-date-option-container&quot;&gt;
					&lt;select id=&quot;gosmtp-date-option-filter&quot; name='date'&gt;
						&lt;option value=&quot;all&quot; selected disabled&gt;&lt;?php _e('Select date') ?&gt;&lt;/option&gt;
						&lt;option value=&quot;7&quot;&gt;&lt;?php _e('Last 7 days') ?&gt;&lt;/option&gt;
						&lt;option value=&quot;14&quot;&gt;&lt;?php _e('Last 14 days') ?&gt;&lt;/option&gt;
						&lt;option value=&quot;30&quot;&gt;&lt;?php _e('Last 30 days') ?&gt;&lt;/option&gt;
						&lt;option value=&quot;custom_date&quot;&gt;&lt;?php _e('Custom date') ?&gt;&lt;/option&gt;
					&lt;/select&gt;
					&lt;div class='gosmtp-report-date-container'&gt;
						&lt;input type=&quot;date&quot; name=&quot;start-date&quot; id=&quot;gosmtp-start-date&quot; placeholder=&quot;Start date&quot; /&gt; 
						&lt;input type=&quot;date&quot; name=&quot;end-date&quot; id=&quot;gosmtp-end-date&quot; placeholder=&quot;End date&quot; /&gt;
					&lt;/div&gt;
				&lt;/div&gt;
				&lt;div class=&quot; gosmtp-report-submit-container&quot;&gt;
					&lt;input type=&quot;submit&quot; class=&quot;button button-primary submit-email-reports&quot; id=&quot;submit-email-reports&quot; name=&quot;submit-email-reports&quot; value=&quot;Search&quot;/&gt;
				&lt;/div&gt;
			&lt;/div&gt;	
		&lt;/form&gt;
		&lt;!-- &lt;div class=&quot;graph-container&quot;&gt;
			&lt;canvas id=&quot;myChart&quot;&gt;&lt;/canvas&gt;
		&lt;/div&gt; --&gt;
	&lt;/div&gt;	
	&lt;table cellspacing=&quot;0&quot; cellpadding=&quot;8&quot; border=&quot;0&quot; width=&quot;100%&quot; class=&quot;gosmtp-email-report&quot; id=&quot;gosmtp-email-reports&quot;&gt;
		&lt;tr&gt;
			&lt;td colspan=&quot;9&quot;&gt;
				&lt;h2&gt;&lt;?php _e('Email Reports') ?&gt;&lt;/h2&gt;
			&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
		&lt;?php
		foreach($table_cols as $col){
			echo '&lt;th&gt;'.$col.'&lt;/th&gt;';
		}
		?&gt;
			&lt;!-- &lt;th&gt;&lt;?php _e('Graph') ?&gt;&lt;/th&gt; --&gt;
		&lt;/tr&gt;
		&lt;?php
		// Mail list array
		$mail_list = gosmtp_group_by($email_logs, $limit);
		
		// Append HTML value
		if(!empty($mail_list)){

			$all_data = array();
			foreach($mail_list as $main_key =&gt; $mail){
				
				$mail_array = $mail['total'];
					
				echo &quot;&lt;tr&gt;&quot;;
				
				foreach($table_cols as $ck =&gt; $col){
					echo '&lt;td&gt;'.$mail_array[$ck].'&lt;/td&gt;';
				}
				
				echo '&lt;!-- &lt;td&gt;
						&lt;span class =&quot;dashicons dashicons-chart-area email_report_icon&quot; data-data=&quot;'.$main_key.'&quot; onclick=&quot;gosmtp_load_graph([\&quot;'.$main_key.'\&quot;])&quot;&gt;&lt;/span&gt;
					&lt;/td&gt; --&gt;
				&lt;/tr&gt;';

				// Add by date data in all data
				array_push($all_data, $mail['by_dates']);
			}
		}else{
			// Empty all data when no result found 
			$all_data = array();
		?&gt;
		&lt;tr&gt;
			&lt;td colspan=&quot;9&quot; class=&quot;gosmtp-empty-row&quot;&gt;&lt;?php _e('Records not found!'); ?&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;?php 
		}
	?&gt;
	&lt;/table&gt;
	
	&lt;?php 
	// Render pagination HTML
	if( is_array( $pages ) ){
		echo '&lt;div class=&quot;gosmtp-pagination&quot;&gt;&lt;ul class=&quot;gosmtp-pagination-wrap&quot;&gt;';
		
		foreach ( $pages as $page ) {
			echo '&lt;li class=&quot;gosmtp-pagination-links&quot;&gt;'.$page.'&lt;/li&gt;';
		}
		
		echo '&lt;/ul&gt;&lt;/div&gt;';
	} 
	?&gt;
&lt;/div&gt;
&lt;script&gt;
	var gosmtp_ajaxurl = &quot;&lt;?php echo admin_url( 'admin-ajax.php' ); ?&gt;?&quot;;
	var gosmtp_ajax_nonce = &quot;&lt;?php echo wp_create_nonce('gosmtp_ajax'); ?&gt;&quot;;
&lt;/script&gt;

&lt;?php
}

// Set Custom array
function gosmtp_set_custom_array($val){

	$return = array();

	foreach($val as $kk =&gt; $vv){
		
		switch($kk){
			case 'to':
				$tos = maybe_unserialize($vv);
				$to_list = [];
				
				foreach($tos as $keys =&gt; $to){
					$to_list[] = $to[0];
				}
				
				$return['total']['to'] = implode(',', $to_list);
				break;
			case 'status':
				if($vv == 'sent'){
					$return['total']['sent'] = 1;
					$return['total']['failed'] = 0;
				}elseif($vv == 'failed'){
					$return['total']['sent'] = 0;
					$return['total']['failed'] = 1;
				}
				break;
			case 'subject': 
				$return['total'][$kk] = empty($vv) ? '[No Subject]' : $vv;
	    			break;
			default:
				$return['total'][$kk] = $vv;
		}
		
	}
	
	$return['total']['total'] = $return['total']['sent'] + $return['total']['failed'];

	$return['by_dates'][$val-&gt;created_at] = array(
		'sent' =&gt; $return['total']['sent'],
		'failed' =&gt; $return['total']['failed'],
		'retries' =&gt; $return['total']['retries'],
		'resent_count' =&gt; $return['total']['resent_count'],
		'total' =&gt; $return['total']['total'],
	);
	
	return $return;

}

// Generate Array with group by
function gosmtp_group_by($logs, $limit = array(), $multiselect = array('subject', 'from', 'to')){
	
	$groups = array();
	$i = 0;
	$key_array = array();

	if(empty($logs)){
		return array();
	}
	
	foreach($logs as $val){
		
		$val = gosmtp_set_custom_array($val);
		$total = $val['total'];
		
		$groups_val = array();
		foreach($multiselect as $multi_val){
			array_push($groups_val, $total[$multi_val]);
		}

		// Add new group
		if(!in_array($groups_val, $key_array)){
			
			$key_array[$i] = $groups_val;
			
			$groups[$i]['total'] = $val['total'];
			$groups[$i]['by_dates'] = $val['by_dates'];
			$i++;
		
		}else{
			foreach($key_array as $kk =&gt; $vv){
				
				if($groups_val != $vv){
					continue;
				}
				
				$group_total = $groups[$kk]['total'];
				
				$total['sent'] = $group_total['sent'] + $total['sent'];
				$total['failed'] = $group_total['failed'] + $total['failed'];
				$total['retries'] = $group_total['retries'] + $total['retries'];
				$total['resent_count'] = $group_total['resent_count'] + $total['resent_count'];
				$total['total'] = $group_total['total'] + $total['total'];
				
				$groups[$kk]['total'] = $total;
				$groups[$kk]['by_dates'][array_keys($val['by_dates'])[0]] = $val['by_dates'][array_keys($val['by_dates'])[0]];
			}
		}
	}

	// Set limit for Pagination
	if(!empty($limit)){
		
		$limit_res = array();
		
		for($i = 0; $i&lt; $limit['perpage']; $i++){
			$j = $i+$limit['offset'];	

			if(isset($groups[$j])){
				array_push($limit_res, $groups[$j] );
			}
		}
		
		$groups = $limit_res;
	}
	
	return $groups;		   
}</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fsitepad%2Feditor%2Fsite-data%2Fplugins%2Fgosmtp-pro%2Fmain'>Back to Directory</a>