pluginHelper->get_stats_tabs(); ?>

pluginHelper->register_stats_settings_tab(__("Quiz And Survey Submissions", 'quiz-master-next'), "qmn_stats_overview_content"); } add_action("plugins_loaded", 'qmn_stats_overview_tab'); /** * Generates HTML For Overview Tab * * @since 4.3.0 * @return void */ function qmn_stats_overview_content() { wp_enqueue_script('ChartJS', plugins_url( '../../js/Chart.min.js' , __FILE__ )); $range = "daily"; if (isset($_POST["range"]) && $_POST["range"] != '') { $range = sanitize_text_field( $_POST["range"] ); } $data = qmn_load_stats($range, 7); $labels = ""; $value = ""; foreach($data as $stat) { $labels .= '"",' ; $value .= "$stat,"; } ?>
get_var("SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$stat_date." 00:00:00' AND '".$stat_date." 23:59:59') AND deleted=0"); array_unshift($stats, $retrieved_stats); } break; case 'weekly': global $wpdb; for ($i=0; $i < $amount; $i++) { $stat_date = date("Y-m-d", mktime(0, 0, 0, date("m") , date("d")-(6+($i*7)), date("Y"))); $stat_end_date = date("Y-m-d", mktime(0, 0, 0, date("m") , date("d")-($i*7), date("Y"))); $retrieved_stats = $wpdb->get_var("SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$stat_date." 00:00:00' AND '".$stat_end_date." 23:59:59') AND deleted=0"); array_unshift($stats, $retrieved_stats); } break; case 'monthly': global $wpdb; for ($i=0; $i < $amount; $i++) { $stat_date = date("Y-m-d", mktime(0, 0, 0, date("m")-$i, 1, date("Y"))); $stat_end_date = date("Y-m-t", mktime(0, 0, 0, date("m")-$i, date("d"), date("Y"))); $retrieved_stats = $wpdb->get_var("SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$stat_date." 00:00:00' AND '".$stat_end_date." 23:59:59') AND deleted=0"); array_unshift($stats, $retrieved_stats); } break; default: # code... break; } $stats = apply_filters('qmn_quiz_taken_stats_load_stats', $stats, $type, $amount); return $stats; } ?>