--- a/common.inc.php +++ b/common.inc.php @@ -1,6 +1,18 @@ <?php date_default_timezone_set("Australia/Sydney"); +try { + $conn = new PDO("pgsql:dbname=scannr;user=postgres;password=snmc;host=localhost"); + $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); +} +catch(PDOException $e) { + die('Unable to connect to database server.'); +} +catch(Exception $e) { + die('Unknown error in ' . __FILE__ . '.'); +} +$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $basePath = ""; +$DATA_DIR = "./data"; /** Returns the offset from the origin timezone to the remote timezone, in seconds. * @param $remote_tz; @@ -21,97 +33,42 @@ return $offset; } -function getSensorValuesByHour($sensorID, $timeFrom, $timeTo) { - $sql = 'select min(time) as time, min(value), max(value), avg(value), stddev(value) from sensor_values where sensor_id = ? - and extract(epoch from time) > ? and extract(epoch from time) < ? - group by sensor_id, date_trunc(\'hour\', time) order by time'; - $query = $this->db->query($sql, Array($sensorID, $timeFrom, $timeTo)); - return $query->result_array(); -} -function getSensorValuesByDay($sensorID, $dayFrom, $dayTo) { - $sql = 'select min(time) as time, min(value), max(value), avg(value), stddev(value) from sensor_values where sensor_id = ? - group by sensor_id, date_trunc(\'day\', time) order by time'; - $query = $this->db->query($sql, Array($sensorID)); - return $query->result_array(); -} - -function getSensorDataYears($sensorID, $timeFrom, $timeTo) { - $sql = "select distinct extract('year' from time) as year from sensor_values where sensor_id = ? order by year"; - - $query = $this->db->query($sql, Array($sensorID)); - return $query->result_array(); -} - -function getSensorDataMonths($sensorID, $timeFrom, $timeTo) { - $sql = "select distinct extract('month' from time) as month, extract('year' from time) as year from sensor_values where sensor_id = ? order by year, month"; - - $query = $this->db->query($sql, Array($sensorID)); - return $query->result_array(); -} - -function getSensorDataDays($sensorID, $timeFrom, $timeTo) { - $sql = "select distinct extract('day' from time) as day, extract('month' from time) as month, extract('year' from time) as year from sensor_values where sensor_id = ? order by year,month,day"; - - $query = $this->db->query($sql, Array($sensorID)); - return $query->result_array(); -} function include_header($title) { global $basePath; ?> - <!DOCTYPE html> +<!DOCTYPE html> +<!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]--> +<!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]--> +<!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]--> +<!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]--> +<head> + <meta charset="utf-8"> + <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> + <title></title> + <meta name="description" content=""> + <meta name="viewport" content="width=device-width"> - <!-- paulirish.com/2008/conditional-stylesheets-vs-css-hacks-answer-neither/ --> - <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7" lang="en"> <![endif]--> - <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8" lang="en"> <![endif]--> - <!--[if IE 8]> <html class="no-js lt-ie9" lang="en"> <![endif]--> - <!--[if gt IE 8]><!--> <html lang="en"> <!--<![endif]--> - <head> - <meta charset="utf-8" /> + <!-- Place favicon.ico and apple-touch-icon.png in the root directory --> - <!-- Set the viewport width to device width for mobile --> - <meta name="viewport" content="width=device-width" /> + <link rel="stylesheet" href="css/normalize.css"> + <link rel="stylesheet" href="css/main.css"> + <script src="js/vendor/modernizr-2.6.1.min.js"></script> + <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js"></script> + <!--<script>window.jQuery || document.write('<script src="js/vendor/jquery-1.8.0.min.js"><\/script>')</script>--> + <script type="text/javascript" src="<?php echo $basePath ?>js/flotr2/flotr2.js"></script> + <script src="js/plugins.js"></script> + <script src="js/main.js"></script> +</head> + <body> + <!--[if lt IE 7]> +<p class="chromeframe">You are using an outdated browser. <a href="http://browsehappy.com/">Upgrade your browser today</a> or <a href="http://www.google.com/chromeframe/?redirect=true">install Google Chrome Frame</a> to better experience this site.</p> +<![endif]--> - <title><?php echo $title; ?> - Scannr</title> - - <!-- Included CSS Files --> - <link rel="stylesheet" href="<?php echo $basePath ?>stylesheets/foundation.css"> - <link rel="stylesheet" href="<?php echo $basePath ?>stylesheets/app.css"> - - <!--[if lt IE 9]> - <link rel="stylesheet" href="<?php echo $basePath ?>stylesheets/ie.css"> - <![endif]--> - - - <!-- IE Fix for HTML5 Tags --> - <!--[if lt IE 9]> - <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script> - <![endif]--> - - </head> - <body xmlns:schema="http://schema.org/" xmlns:foaf="http://xmlns.com/foaf/0.1/"> - - <!-- navBar --> - <div id="navbar" class="container"> - <div class="row"> - <div class="four columns"> - <h1><a href="/">Disclosr</a></h1> - </div> - <div class="eight columns hide-on-phones"> - <strong class="right"> - <a href="getAgency.php">Agencies</a> - <a href="about.php">About/FAQ</a> - </strong> - </div> - </div> - </div> - <!-- /navBar --> - - <!-- container --> - <div class="container"> +<!-- Add your site or application content here --> <?php } @@ -119,41 +76,19 @@ global $basePath; ?> - </div> - <!-- container --> - - - - <!-- Included JS Files --> - <script src="<?php echo $basePath; ?>js/foundation.js"></script> - <script src="<?php echo $basePath; ?>js/app.js"></script> - <script src="http://code.jquery.com/jquery-1.7.1.min.js"></script> - <script>window.jQuery || document.write('<script src="js/jquery-1.8.2.min.js"><\/script>')</script> - - <script type="text/javascript" src="<?php echo $basePath ?>js/flotr2/flotr2.js"></script> - <?php - if (strpos($_SERVER['SERVER_NAME'], ".gs")) { - ?> - <script type="text/javascript"> - - var _gaq = _gaq || []; - _gaq.push(['_setAccount', 'UA-12341040-2']); - _gaq.push(['_trackPageview']); - - (function() { - var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; - ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; - var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); - })(); - - </script> - - </body> - </html> + <!-- Google Analytics: change UA-XXXXX-X to be your site's ID. --> + <script> + var _gaq=[['_setAccount','UA-XXXXX-X'],['_trackPageview']]; + (function(d,t){var g=d.createElement(t),s=d.getElementsByTagName(t)[0]; + g.src=('https:'==location.protocol?'//ssl':'//www')+'.google-analytics.com/ga.js'; + s.parentNode.insertBefore(g,s)}(document,'script')); + </script> + </body> +</html> <?php - } + }