move files to data folder
[scannr.git] / common.inc.php
blob:a/common.inc.php -> blob:b/common.inc.php
<?php <?php
date_default_timezone_set("Australia/Sydney"); 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 = ""; $basePath = "";
$DATA_DIR = "./data"; $DATA_DIR = "./data";
   
/** Returns the offset from the origin timezone to the remote timezone, in seconds. /** Returns the offset from the origin timezone to the remote timezone, in seconds.
* @param $remote_tz; * @param $remote_tz;
* @param $origin_tz; If null the servers current timezone is used as the origin. * @param $origin_tz; If null the servers current timezone is used as the origin.
* @return int; * @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 ($origin_tz === null) {
if (!is_string($origin_tz = date_default_timezone_get())) { if (!is_string($origin_tz = date_default_timezone_get())) {
return false; // A UTC timestamp was returned -- bail out! return false; // A UTC timestamp was returned -- bail out!
} }
} }
$origin_dtz = new DateTimeZone($origin_tz); $origin_dtz = new DateTimeZone($origin_tz);
$remote_dtz = new DateTimeZone($remote_tz); $remote_dtz = new DateTimeZone($remote_tz);
$origin_dt = new DateTime("now", $origin_dtz); $origin_dt = new DateTime("now", $origin_dtz);
$remote_dt = new DateTime("now", $remote_dtz); $remote_dt = new DateTime("now", $remote_dtz);
$offset = $origin_dtz->getOffset($origin_dt) - $remote_dtz->getOffset($remote_dt); $offset = $origin_dtz->getOffset($origin_dt) - $remote_dtz->getOffset($remote_dt);
return $offset; 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)); function include_header($title)
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; 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/ --> <!-- Place favicon.ico and apple-touch-icon.png in the root directory -->
<!--[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" />  
   
<!-- Set the viewport width to device width for mobile --> <link rel="stylesheet" href="css/normalize.css">
<meta name="viewport" content="width=device-width" /> <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 --> function include_footer()
<link rel="stylesheet" href="<?php echo $basePath ?>stylesheets/foundation.css"> {
<link rel="stylesheet" href="<?php echo $basePath ?>stylesheets/app.css"> global $basePath;
  ?>
<!--[if lt IE 9]>  
<link rel="stylesheet" href="<?php echo $basePath ?>stylesheets/ie.css">  
<![endif]-->  
   
   
<!-- IE Fix for HTML5 Tags --> <!-- Google Analytics: change UA-XXXXX-X to be your site's ID. -->
<!--[if lt IE 9]> <script>
<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script> var _gaq = [
<![endif]--> ['_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> <?php
<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">  
<?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  
}  
} }