<?php

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

// Required CSS and JS
$required_css		= array('picker-default', 'picker-default.date', 'cpma-video');
$required_js		= array('picker' => 1, 'picker.date' => 1, 'date_range' => 1, 'cpma-video' => 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 . "'";
}

$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0" . $select_range;
$query = $db->prepare($sql);
$query->execute();
$cpma_sw_totalScans = $query->fetchColumn();

// Scan breakdown

// Artemus
$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0 AND barcode = :barcode" . $select_range;
$query = $db->prepare($sql);
$query->execute( array(':barcode' => '2345-B') );
$cpma_sw_totalScansArtimus = $query->fetchColumn();

// Baxter
$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0 AND barcode = :barcode" . $select_range;
$query = $db->prepare($sql);
$query->execute( array(':barcode' => '1234-A') );
$cpma_sw_totalScansBaxter = $query->fetchColumn();

// Brayden
$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0 AND barcode = :barcode" . $select_range;
$query = $db->prepare($sql);
$query->execute( array(':barcode' => '6789-F') );
$cpma_sw_totalScansBrayden = $query->fetchColumn();

// Cookie
$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0 AND barcode = :barcode" . $select_range;
$query = $db->prepare($sql);
$query->execute( array(':barcode' => '3456-C') );
$cpma_sw_totalScansCookie = $query->fetchColumn();

// Mono
$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0 AND barcode = :barcode" . $select_range;
$query = $db->prepare($sql);
$query->execute( array(':barcode' => '4567-D') );
$cpma_sw_totalScansMono = $query->fetchColumn();

// Tacoma
$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0 AND barcode = :barcode" . $select_range;
$query = $db->prepare($sql);
$query->execute( array(':barcode' => '7890-G') );
$cpma_sw_totalScansTacoma = $query->fetchColumn();

// Invalid
$sql = "SELECT count(*) FROM cpma_sw_metrics WHERE datetime != 0 AND barcode = :barcode" . $select_range;
$query = $db->prepare($sql);
$query->execute( array(':barcode' => 'invalid') );
$cpma_sw_totalScansInv = $query->fetchColumn();




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

?>