move files to data folder
[scannr.git] / common.inc.php
blob:a/common.inc.php -> blob:b/common.inc.php
--- a/common.inc.php
+++ b/common.inc.php
@@ -1,14 +1,25 @@
 <?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;
- *    @param $origin_tz; If null the servers current timezone is used as the origin.
- *    @return int;
+ * @param $remote_tz;
+ * @param $origin_tz; If null the servers current timezone is used as the origin.
+ * @return int;
  */
-function get_timezone_offset($remote_tz, $origin_tz = null) {
+function get_timezone_offset($remote_tz, $origin_tz = null)
+{
     if ($origin_tz === null) {
         if (!is_string($origin_tz = date_default_timezone_get())) {
             return false; // A UTC timestamp was returned -- bail out!
@@ -22,138 +33,71 @@
     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) {
+function include_header($title)
+{
     global $basePath;
     ?>
     <!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>
+    <!-- Add your site or application content here -->
+<?php
+}
 
-            <!-- 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]-->
+function include_footer()
+{
+    global $basePath;
+    ?>
 
 
-            <!-- IE Fix for HTML5 Tags -->
-            <!--[if lt IE 9]>
-                    <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
-            <![endif]-->
+    <!-- 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>
 
-        </head>
-        <body xmlns:schema="http://schema.org/"  xmlns:foaf="http://xmlns.com/foaf/0.1/">
+<?php
 
-            <!-- 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">
-            <?php
-            }
-
-            function include_footer() {
-                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>
-
-    <?php
-    }
 }