<?php 

// ================================================================================
// ******************************* DEFINE CONSTANTS *******************************
// ================================================================================

require("includes/constants.php");
include(INCLUDE_DIR . "/db_connect.php");

//Required for display.
require('smarty/Smarty.class.php');
$smarty = new Smarty;
$smarty->template_dir = 'smarty/templates';
$smarty->compile_dir = 'smarty/templates_c';
$smarty->cache_dir = 'smarty/cache';
$smarty->config_dir = 'smarty/configs';

//Change the TZ to Los Angeles
date_default_timezone_set('America/Los_Angeles');

$currentDate = strtotime(date("m/d/y"));

if($_GET['date'] == 'yesterday'){
	$yesterdayTimestamp = strtotime("-1 day", $currentDate);
	
	$query = "SELECT SensorName, SUM(CountA) AS Traffic, StartDate, EndDate FROM counterdata 
				WHERE StartDate >= '{$yesterdayTimestamp}'
				GROUP BY StartDate, SensorName";
	$result = mysql_query($query);
	
	$i = 0;
	$noDataError = false;
	while($row = mysql_fetch_assoc($result)){
		$row['StartDate2'] = date('m/d/y', $row['StartDate']);
		$row['EndDate2'] = date('m/d/y', $row['EndDate']);
		
		if($i == 0){
			$tmpRows['date'] = $row['StartDate2'];
		}
			
		if($i < 6){
			$tmpRows[] = $row;
			$i++;
		}
		else {
			$rows[] = $tmpRows;
			$tmpRows = '';
			$i = 0;
			
			$tmpRows['date'] = $row['StartDate2'];
			$tmpRows[] = $row;
			$i++;
		}
	}
	
	if($rows == ''){
		$noDataError = true;
	}
	
	$smarty->assign('noDataError', $noDataError);
	$smarty->assign('dataArray', $rows);
	$smarty->assign('date', 'yesterday');
	$smarty->assign('listStartDate', date('m/d/y', $yesterdayTimestamp));
	$smarty->display('report.tpl');
	die;
}
elseif($_GET['date'] == 'week'){
	$weekAgoTimestamp = strtotime("-7 day", $currentDate);
	
	$query = "SELECT SensorName, SUM(CountA) AS Traffic, StartDate, EndDate FROM counterdata 
				WHERE StartDate >= '{$weekAgoTimestamp}' AND EndDate <= '{$currentDate}'
				GROUP BY StartDate, SensorName";
	$result = mysql_query($query);
	
	$i = 0;
	$noDataError = false;
	while($row = mysql_fetch_assoc($result)){
		$row['StartDate2'] = date('m/d/y', $row['StartDate']);
		$row['EndDate2'] = date('m/d/y', $row['EndDate']);
		
		if($i == 0){
			$tmpRows['date'] = $row['StartDate2'];
		}
			
		if($i < 6){
			$tmpRows[] = $row;
			$i++;
		}
		else {
			$rows[] = $tmpRows;
			$tmpRows = '';
			$i = 0;
			
			$tmpRows['date'] = $row['StartDate2'];
			$tmpRows[] = $row;
			$i++;
		}
	}
	
	if($rows == ''){
		$noDataError = true;
	}
	
	$smarty->assign('noDataError', $noDataError);
	$smarty->assign('dataArray', $rows);
	$smarty->assign('date', 'week');
	$smarty->assign('listStartDate', date('m/d/y', $weekAgoTimestamp));
	$smarty->assign('listEndDate', date('m/d/y', $currentDate));
	$smarty->display('report.tpl');
	die;
}
elseif($_GET['date'] == 'month'){
	$monthAgoTimestamp = strtotime("-31 days", $currentDate);
	
//	$query = "SELECT SensorName, StartDate, TIME_FORMAT(StartTime, '%H:%i') as StartTime, 
//				EndDate, TIME_FORMAT(EndTime, '%H:%i') as EndTime, CountA
//				FROM counterdata WHERE StartDate >= '{$monthAgoTimestamp}' AND EndDate <= '{$currentDate}'";

	$query = "SELECT SensorName, SUM(CountA) AS Traffic, StartDate, EndDate FROM counterdata 
				WHERE StartDate >= '{$monthAgoTimestamp}' AND EndDate <= '{$currentDate}'
				GROUP BY StartDate, SensorName";
	$result = mysql_query($query);
	
	$i = 0;
	while($row = mysql_fetch_assoc($result)){
		$row['StartDate2'] = date('m/d/y', $row['StartDate']);
		$row['EndDate2'] = date('m/d/y', $row['EndDate']);
		
		if($i == 0)
			$tmpRows['date'] = $row['StartDate2'];
			
		if($i < 6){

			$tmpRows[] = $row;
			$i++;
		}
		else {
			$rows[] = $tmpRows;
			$tmpRows = '';
			$i = 0;
			
			$tmpRows['date'] = $row['StartDate2'];
			$tmpRows[] = $row;
			$i++;
		}
	}
	
	$smarty->assign('dataArray', $rows);
	$smarty->assign('date', 'month');
	$smarty->assign('listStartDate', date('m/d/y', $monthAgoTimestamp));
	$smarty->assign('listEndDate', date('m/d/y', $currentDate));
	$smarty->display('report.tpl');
	die;
}
elseif($_GET['date'] == 'semester'){
	$smarty->assign('date', 'semester');
	$smarty->display('report.tpl');
	die;
}

?>