200 lines
5.4 KiB
PHP
200 lines
5.4 KiB
PHP
|
|
<?php
|
||
|
|
/**
|
||
|
|
* This file creates the Stats page
|
||
|
|
*
|
||
|
|
* @since 4.3.0
|
||
|
|
*/
|
||
|
|
|
||
|
|
if ( ! defined( 'ABSPATH' ) ) exit;
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Generates the HTML for the Stats page
|
||
|
|
*
|
||
|
|
* Retrieves the HTML for the tab of Stats page from the plugin helper
|
||
|
|
*
|
||
|
|
* @since 4.3.0
|
||
|
|
* @return void
|
||
|
|
*/
|
||
|
|
function qmn_generate_stats_page()
|
||
|
|
{
|
||
|
|
if ( !current_user_can('moderate_comments') )
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
global $mlwQuizMasterNext;
|
||
|
|
$active_tab = isset( $_GET[ 'tab' ] ) ? $_GET[ 'tab' ] : 'quiz-and-survey-submissions';
|
||
|
|
$tab_array = $mlwQuizMasterNext->pluginHelper->get_stats_tabs();
|
||
|
|
?>
|
||
|
|
<div class="wrap">
|
||
|
|
<h2><?php _e('Quiz/Survey Statistics', 'quiz-master-next'); ?></h2>
|
||
|
|
<?php qsm_show_adverts(); ?>
|
||
|
|
<h2 class="nav-tab-wrapper">
|
||
|
|
<?php
|
||
|
|
foreach($tab_array as $tab)
|
||
|
|
{
|
||
|
|
$active_class = '';
|
||
|
|
if ($active_tab == $tab['slug'])
|
||
|
|
{
|
||
|
|
$active_class = 'nav-tab-active';
|
||
|
|
}
|
||
|
|
echo "<a href=\"?page=qmn_stats&tab=".$tab['slug']."\" class=\"nav-tab $active_class\">".$tab['title']."</a>";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</h2>
|
||
|
|
<div>
|
||
|
|
<?php
|
||
|
|
foreach($tab_array as $tab)
|
||
|
|
{
|
||
|
|
if ($active_tab == $tab['slug'])
|
||
|
|
{
|
||
|
|
call_user_func($tab['function']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Adds Overview Tab To Stats Page
|
||
|
|
*
|
||
|
|
* @since 4.3.0
|
||
|
|
* @return void
|
||
|
|
*/
|
||
|
|
function qmn_stats_overview_tab()
|
||
|
|
{
|
||
|
|
global $mlwQuizMasterNext;
|
||
|
|
$mlwQuizMasterNext->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,";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<style>
|
||
|
|
.postbox:after {
|
||
|
|
display:table;
|
||
|
|
content:" ";
|
||
|
|
clear:both;
|
||
|
|
}
|
||
|
|
.postbox {
|
||
|
|
padding: 10px 1%;
|
||
|
|
}
|
||
|
|
.postbox h3 {
|
||
|
|
padding: 0;
|
||
|
|
margin: 0 0 20px;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
<div class="metabox-holder">
|
||
|
|
<div class="postbox">
|
||
|
|
<form action="" method="post">
|
||
|
|
<select name="range">
|
||
|
|
<option value="daily" <?php if ( $range == "daily" ) { echo 'selected="selected"'; } ?>>Daily</option>
|
||
|
|
<option value="weekly" <?php if ( $range == "weekly" ) { echo 'selected="selected"'; } ?>>Weekly</option>
|
||
|
|
<option value="monthly" <?php if ( $range == "monthly" ) { echo 'selected="selected"'; } ?>>Monthly</option>
|
||
|
|
<?php do_action('qmn_quiz_taken_stats_options'); ?>
|
||
|
|
</select>
|
||
|
|
<button type="submit" class="button">Filter</button>
|
||
|
|
</form>
|
||
|
|
<div>
|
||
|
|
<canvas id="graph_canvas"></canvas>
|
||
|
|
<script>
|
||
|
|
var graph_data = {
|
||
|
|
labels : [<?php echo $labels; ?>],
|
||
|
|
datasets : [
|
||
|
|
{
|
||
|
|
label: "",
|
||
|
|
fillColor : "rgba(220,220,220,0.2)",
|
||
|
|
strokeColor : "rgba(220,220,220,1)",
|
||
|
|
pointColor : "rgba(220,220,220,1)",
|
||
|
|
pointStrokeColor : "#fff",
|
||
|
|
pointHighlightFill : "#fff",
|
||
|
|
pointHighlightStroke : "rgba(220,220,220,1)",
|
||
|
|
data : [<?php echo $value; ?>]
|
||
|
|
}
|
||
|
|
]
|
||
|
|
}
|
||
|
|
window.onload = function(){
|
||
|
|
var graph_ctx = document.getElementById("graph_canvas").getContext("2d");
|
||
|
|
window.stats_graph = new Chart(graph_ctx).Line(graph_data, {
|
||
|
|
responsive: true
|
||
|
|
});
|
||
|
|
}
|
||
|
|
</script>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Loads Stats From mlw_results
|
||
|
|
*
|
||
|
|
* Creates array of stats from counting the amount of rows in mlw_results according to the $type.
|
||
|
|
*
|
||
|
|
* @since 4.3.0
|
||
|
|
* @param $type string The type of stat report
|
||
|
|
* @param $amount int The amount of stats to pull
|
||
|
|
* @return array The array of stats
|
||
|
|
*/
|
||
|
|
function qmn_load_stats($type, $amount = 0) {
|
||
|
|
$stats = array();
|
||
|
|
switch ($type) {
|
||
|
|
case 'daily':
|
||
|
|
global $wpdb;
|
||
|
|
for ($i=0; $i < $amount; $i++) {
|
||
|
|
$stat_date = date("Y-m-d", mktime(0, 0, 0, date("m") , date("d")-$i, 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_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;
|
||
|
|
}
|
||
|
|
?>
|