<?php

require($cfg[ 'server_path' ] . '/check_login.php');

// Required CSS and JS
$required_css		= array('picker-default', 'picker-default.date');
$required_js		= array('picker' => 1, 'picker.date' => 1, 'date_range' => 1);

// Chnage default meta details
$pagedata['title']				= "Elanco - Admin";
$pagedata['description']		= "Elanco - Admin";
$pagedata['og:title']			= "Elanco - Admin";
$pagedata['og:description']		= "Elanco - Admin";


$date_regex = "/^((((19|[2-9]\d)\d{2})\-(0[13578]|1[02])\-(0[1-9]|[12]\d|3[01]))|(((19|[2-9]\d)\d{2})\-(0[13456789]|1[012])\-(0[1-9]|[12]\d|30))|(((19|[2-9]\d)\d{2})\-02\-(0[1-9]|1\d|2[0-8]))|(((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))\-02\-29))$/";


if ( isset($_GET['from']) && preg_match($date_regex, $_GET['from']) ) {
	$fromDate = $_GET['from'];
} else {
	$fromDate = "";
}

if ( isset($_GET['to']) && preg_match($date_regex, $_GET['to']) ) {
	$toDate = $_GET['to'];
} else {
	$toDate = "";
}


$select_range = "";

if ($fromDate != "") {
	$select_range .= " AND DATE(FROM_UNIXTIME(datetime)) >= '" . $fromDate . "'";
}

if ($toDate != "") {
	$select_range .= " AND DATE(FROM_UNIXTIME(datetime)) <= '" . $toDate . "'";
}

// Start
$sql = "SELECT count(*) FROM t2z_wall_metrics WHERE datetime != 0 AND metric = :metric" . $select_range;
$query = $db->prepare($sql);
$query->execute( array('metric' => 'start') );
$t2z_wall_start = $query->fetchColumn();

//Video 1 content
$sql = "SELECT metric, count(*) as total FROM t2z_wall_metrics WHERE datetime != 0 AND metric != 'start' AND metric LIKE 'vid1%'" . $select_range . " GROUP BY metric";
$query = $db->prepare($sql);
$query->execute();
$t2z_wall_vid1_content = $query->fetchAll(PDO::FETCH_ASSOC);

//Video 2 content
$sql = "SELECT metric, count(*) as total FROM t2z_wall_metrics WHERE datetime != 0 AND metric != 'start' AND metric LIKE 'vid2%'" . $select_range . " GROUP BY metric";
$query = $db->prepare($sql);
$query->execute();
$t2z_wall_vid2_content = $query->fetchAll(PDO::FETCH_ASSOC);

//Video 3 content
$sql = "SELECT metric, count(*) as total FROM t2z_wall_metrics WHERE datetime != 0 AND metric != 'start' AND metric LIKE 'vid3%'" . $select_range . " GROUP BY metric";
$query = $db->prepare($sql);
$query->execute();
$t2z_wall_vid3_content = $query->fetchAll(PDO::FETCH_ASSOC);


/*
echo('<pre>');
print_r ($t2z_wall_content);
echo('</pre>');
exit;
*/

// Load the view
require ($cfg['server_path'].'/view/v-t2z-wall.php');

?>