db fixes
[scannr.git] / common.inc.php
blob:a/common.inc.php -> blob:b/common.inc.php
--- a/common.inc.php
+++ b/common.inc.php
@@ -1,5 +1,15 @@
 <?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__ . '.');
+}
 $basePath = "";
 $DATA_DIR = "./data";
 
@@ -22,96 +32,42 @@
     return $offset;
 }
 
-function getSensorValuesByHour($sensorID, $timeFrom, $timeTo) {
-    $sql = 'select min(call_timestamp) as time, count(*), min(length), max(length), avg(length), stddev(length) from recordings
-            group by tgid, date_trunc(\'hour\', call_timestamp) 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 call_timestamp) as year from recordings where tgid = ? 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 +75,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
-    }
+
 }