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;
}
?>