<?php |
<?php |
date_default_timezone_set("Australia/Sydney"); |
date_default_timezone_set("Australia/Sydney"); |
try { |
try { |
$conn = new PDO("pgsql:dbname=scannr;user=postgres;password=snmc;host=localhost"); |
$conn = new PDO("pgsql:dbname=scannr;user=postgres;password=snmc;host=localhost"); |
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
} |
} catch (PDOException $e) { |
catch(PDOException $e) { |
|
die('Unable to connect to database server.'); |
die('Unable to connect to database server.'); |
} |
} |
catch(Exception $e) { |
catch (Exception $e) { |
die('Unknown error in ' . __FILE__ . '.'); |
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 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"> |
|
|
|
<!-- Place favicon.ico and apple-touch-icon.png in the root directory --> |
|
|
|
<link rel="stylesheet" href="css/normalize.css"> |
|
<link rel="stylesheet" href="css/main.css"> |
|
|
|
<link href="css/daterangepicker.css" rel="stylesheet"> |
|
<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> |
|
<!-- xcharts includes --> |
|
<script src="//cdnjs.cloudflare.com/ajax/libs/d3/2.10.0/d3.v2.js"></script> |
|
|
|
<!-- The daterange picker bootstrap plugin --> |
|
<script src="js/sugar.min.js"></script> |
|
<script src="js/daterangepicker.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]--> |
|
|
|
<!-- Add your site or application content here --> |
|
<?php |
|
} |
|
|
|
function include_footer() |
|
{ |
|
global $basePath; |
|
?> |
|
|
|
|
|
<!-- 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> |
|
|
function include_header($title) { |
<?php |
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"> |
|
|
|
<!-- Place favicon.ico and apple-touch-icon.png in the root directory --> |
|
|
|
<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]--> |
|
|
|
<!-- Add your site or application content here --> |
|
<?php |
|
} |
|
|
|
function include_footer() { |
|
global $basePath; |
|
?> |
|
|
|
|
|
<!-- 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 |
|
|
|
} |
} |
|
|
|
|