/** * Display the Stats * * @access public * @return void */ function nnr_stats_tracker_load_v1() { do_action('nnr_stats_before_load_v1'); // Check for Table Name if (!isset($_POST['table_name']) || empty($_POST['table_name'])) { echo 'No Stats table name found.'; die; } // Check for Table Name if (!isset($_POST['data_table_name']) || empty($_POST['data_table_name'])) { echo 'No Data Manager table name found.'; die; } // Check for Text Domain if (!isset($_POST['text_domain']) || empty($_POST['text_domain'])) { $_POST['text_domain'] = ''; } // Check for Stats Page if (!isset($_POST['stats_page']) || empty($_POST['stats_page'])) { $_POST['stats_page'] = ''; } // Check for Text Domain if (!isset($_POST['prefix']) || empty($_POST['prefix'])) { $_POST['prefix'] = ''; } $pie_chart_colors = array('#00a0b0', '#edc951', '#eb6841', '#4f372d', '#cc2a36'); $stats_tracker = new NNR_Stats_Tracker_v1($_POST['table_name']); $data_manager = new NNR_Data_Manager_v1($_POST['data_table_name']); // Get Start and End Dates $start_date = date('Y-m-d', mktime(0, 0, 0, date("m") - 1, date("d"), date("Y"))); $end_date = date('Y-m-d', strtotime(current_time('mysql'))); $post_start_date = urldecode($_POST['start_date']); $post_end_date = urldecode($_POST['end_date']); if (isset($post_start_date) && $post_start_date != '') { $start_date = date('Y-m-d', strtotime($post_start_date)); } if (isset($post_end_date) && $post_end_date != '') { $end_date = date('Y-m-d', strtotime($post_end_date)); } global $wpdb; // All optin_fire stats if (isset($_POST['data_id']) && $_POST['data_id'] == 'false') { $data = $data_manager->get_data(); $stats = $stats_tracker->get_stats($start_date, $end_date); $data_stats = array(); foreach ($data as $item) { foreach ($stats as $stat) { if ($item['id'] == $stat['data_id']) { $data_stats[$item['id']] = array('data_id' => $stat['data_id'], 'name' => $item['name'], 'date' => $stat['date'], 'impressions' => isset($data_stats[$item['id']]['impressions']) ? $data_stats[$item['id']]['impressions'] + $stat['impressions'] : $stat['impressions'], 'conversions' => isset($data_stats[$item['id']]['conversions']) ? $data_stats[$item['id']]['conversions'] + $stat['conversions'] : $stat['conversions']); } } } $impressions_total = 0; $conversions_total = 0; foreach ($data_stats as $data_stat) { $impressions_total += $data_stat['impressions']; $conversions_total += $data_stat['conversions']; } $ctr = $impressions_total != 0 ? round($conversions_total / $impressions_total * 100, 2) : 0; $stats_content = ' <div class="nnr-stats-total-container col-sm-12"> <div class="nnr-stats-totals col-sm-4"> <div class="nnr-stats-impressions-total"> <span>' . __('Impressions', $_POST['text_domain']) . '</span> <div class="nnr-stats-totals-text">' . number_format($impressions_total) . '</div> <i class="fa fa-globe"></i> </div> </div> <div class="nnr-stats-totals col-sm-4"> <div class="nnr-stats-conversions-total"> <span>' . __('Conversions', $_POST['text_domain']) . '</span> <div class="nnr-stats-totals-text">' . number_format($conversions_total) . '</div> <i class="fa fa-certificate"></i> </div> </div> <div class="nnr-stats-totals col-sm-4"> <div class="nnr-stats-conversion-rate-total"> <span>' . __('Conversion Rate', $_POST['text_domain']) . '</span> <div class="nnr-stats-totals-text">' . $ctr . '%</div> <i class="fa fa-usd"></i> </div> </div> </div> <div class="clearfix"></div> <div class="col-sm-6 nnr-stats-table-container"> <h3 id="nnr-heading" class="text-center">' . __('Total Stats', $_POST['text_domain']) . '</h3> <table class="nnr-stats-table table sortable"> <thead> <tr> <th>' . __('Name', $_POST['text_domain']) . '</th> <th class="nnr-impressions-key">' . __('Impressions', $_POST['text_domain']) . '</th> <th class="nnr-conversions-key">' . __('Conversions', $_POST['text_domain']) . '</th> <th data-defaultsort="desc" class="nnr-conversion-rate-key">' . __('Conversion Rate', $_POST['text_domain']) . '</th> </tr> </thead> <tbody>'; if (count($data_stats) < 1) { $stats_content .= '<tr><td>' . __('No Stats Data for this time period', $_POST['text_domain']) . '</td></tr>'; } foreach ($data_stats as $data_stat) { $ctr = $data_stat['impressions'] > 0 ? round($data_stat['conversions'] / $data_stat['impressions'] * 100, 2) : '0'; $stats_content .= '<tr> <td data-value="' . $data_stat['name'] . '"><a href="' . admin_url() . 'admin.php?page=' . $_POST['stats_page'] . '&data_id=' . $data_stat['data_id'] . '&data_name=' . $data_stat['name'] . '" class="">' . $data_stat['name'] . '</a></td> <td data-value="' . $data_stat['impressions'] . '">' . number_format($data_stat['impressions']) . '</td>'; $stats_content .= ' <td data-value="' . $data_stat['conversions'] . '">' . number_format($data_stat['conversions']) . '</td> <td data-value="' . $ctr . '" class="conversions column-conversions">' . $ctr . '%</td> </tr>'; } $stats_content .= '</tbody> </table> </div> <div class="nnr-conversion-chart col-sm-6"> <h3 id="nnr-heading" class="text-center">' . __('Conversion Distribution', $_POST['text_domain']) . '</h3> <div class="col-sm-12"> <canvas id="nnr-pie-chart"></canvas> </div> <ul class="col-sm-12 nnr-pie-chart-legend-colors">'; $counter = 0; foreach ($data_stats as $data_stat) { if ($data_stat['conversions'] < 1) { continue; } $stats_content .= '<li class="nnr-pie-chart-legend-item"> <span class="nnr-pie-chart-legend-color" style="background-color:' . $pie_chart_colors[$counter % count($pie_chart_colors)] . '"></span> <span class="nnr-pie-chart-optin-name">' . $data_stat['name'] . '</span> </li>'; $counter++; } $stats_content .= '</ul> </div>'; } else { if (isset($_POST['data_id']) && $_POST['data_id'] != 'false') { $data_stats = $stats_tracker->get_stats_from_id($_POST['data_id'], $start_date, $end_date); $data = $data_manager->get_data_from_id($_POST['data_id']); $stats_display = new NNR_Stats_Tracker_Display_v1(''); $data_stats = $stats_display->add_empty_data($start_date, $end_date, $data_stats); // Unset index foreach ($data_stats as $key => $data_stat) { unset($data_stats[$key]['id']); unset($data_stats[$key]['data_id']); } $impressions_total = 0; $conversions_total = 0; foreach ($data_stats as $data_stat) { $impressions_total += $data_stat['impressions']; $conversions_total += $data_stat['conversions']; } $ctr = $impressions_total != 0 ? round($conversions_total / $impressions_total * 100, 2) : 0; $stats_content = '<div class="nnr-stats-total-container col-sm-12"> <div class="nnr-stats-totals col-sm-4"> <div class="nnr-stats-impressions-total"> <span>' . __('Impressions', $_POST['text_domain']) . '</span> <div class="nnr-stats-totals-text">' . number_format($impressions_total) . '</div> <i class="fa fa-globe"></i> </div> </div> <div class="nnr-stats-totals col-sm-4"> <div class="nnr-stats-conversions-total"> <span>' . __('Conversions', $_POST['text_domain']) . '</span> <div class="nnr-stats-totals-text">' . number_format($conversions_total) . '</div> <i class="fa fa-certificate"></i> </div> </div> <div class="nnr-stats-totals col-sm-4"> <div class="nnr-stats-conversion-rate-total"> <span>' . __('Conversion Rate', $_POST['text_domain']) . '</span> <div class="nnr-stats-totals-text">' . $ctr . '%</div> <i class="fa fa-usd"></i> </div> </div> </div> <div class="clearfix"></div> <div class="nnr-line-graph-container"> <h3 id="nnr-heading" class="text-center">' . __('Impressions and Conversions', $_POST['text_domain']) . '</h3> <canvas id="nnr-line-graph"></canvas> </div> <div class="col-sm-12"> <h3 id="nnr-heading" class="text-center">' . __('Total Stats', $_POST['text_domain']) . '</h3> <table class="table table-responsive sortable"> <thead> <th data-defaultsort="desc">' . __('Date', $_POST['text_domain']) . '</th> <th class="nnr-impressions-key">' . __('Impressions', $_POST['text_domain']) . '</th> <th class="nnr-conversions-key">' . __('Conversions', $_POST['text_domain']) . '</th> <th class="nnr-conversion-rate-key">' . __('Conversion Rate', $_POST['text_domain']) . '</th> </thead>'; foreach (array_reverse($data_stats) as $data_stat) { $ctr = $data_stat['impressions'] > 0 ? round($data_stat['conversions'] / $data_stat['impressions'] * 100, 2) : '0'; $stats_content .= '<tr> <td data-value="' . strtotime($data_stat['date']) . '">' . date('M j Y', strtotime($data_stat['date'])) . '</td> <td data-value="' . $data_stat['impressions'] . '">' . number_format($data_stat['impressions']) . '</td> <td data-value="' . $data_stat['conversions'] . '">' . number_format($data_stat['conversions']) . '</td> <td data-value="' . $ctr . '" class="conversions column-conversions">' . $ctr . '%</td>'; $stats_content .= '</tr>'; } $stats_content .= '</table> </div>'; } } do_action('nnr_stats_after_load_v1'); echo json_encode(apply_filters('nnr_stats_load_data_v1', array('stats_content' => $stats_content, 'data_stats' => $data_stats))); die; // this is required to terminate immediately and return a proper response }
/** * Conversion Rate column * * @since 1.0.0 * * @param array $item A singular item (one full row's worth of data) * @param array $column_name The name/slug of the column to be processed * @return string Text or HTML to be placed inside the column <td> */ function column_conversion_rate($item) { do_action('nnr_data_man_before_table_column_conversion_rate_v1'); $stats_tracker = new NNR_Stats_Tracker_v1($this->stats_table_name); $stats = $stats_tracker->get_stats(null, null, $item['id']); $impressions_total = 0; $conversions_total = 0; foreach ($stats as $stat) { $conversions_total += $stat['conversions']; $impressions_total += $stat['impressions']; } $ctr = $impressions_total != 0 ? round($conversions_total / $impressions_total * 100, 2) : 0; do_action('nnr_data_man_after_table_column_conversion_rate_v1'); return apply_filters('nnr_data_man_table_column_conversion_rate_v1', $ctr . '%'); }