Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement