<?php
require_once "conf.php";
require_once "funcoes.php";
pg_retorna("SELECT *,\n to_char(timestamp, 'DD/MM/YY HH24:MI:SS') as timestamp_ajustado\n\t\t\t\t\t\t\t\t FROM data WHERE 1 = 1 \n AND id_sensor = " . $_GET["id_sensor"] . "\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t AND id_end_device = " . $_GET["id_end_device"] . "\n\t\t\t\t\t\t\t\t\t\t\t ORDER BY timestamp DESC LIMIT 1", $rQryDataUlt);
?>
<html>
<head>
<meta http-equiv="refresh" content="7" >
<!--Load the AJAX API-->
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(drawChart);
function drawChart() {
var jsonData = $.ajax({
url: "getData.php?tipo=<?php
echo $_GET["tipo"];
?>
&id_end_device=<?php
echo $_GET["id_end_device"];
?>
&id_sensor=<?php
<?php
require_once "conf.php";
require_once "funcoes.php";
$_GET["tipo"] = "end_device";
$_GET["id_end_device"] = "666";
if (!$_GET["periodo"]) {
$_GET["periodo"] = 24;
}
pg_retorna("SELECT *,\n to_char(timestamp, 'DD-MM-YY HH24:MI:SS') as timestamp_ajustado\n\t\t\t\t\t\t\t\t FROM data WHERE 1 = 1 \n AND id_sensor = 2\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t ORDER BY timestamp DESC LIMIT 1", $rQryDataTemperatura);
pg_retorna("SELECT *,\n to_char(timestamp, 'DD-MM-YY HH24:MI:SS') as timestamp_ajustado\n\t\t\t\t\t\t\t\t FROM data WHERE 1 = 1 \n AND id_sensor = 3\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t ORDER BY timestamp DESC LIMIT 1", $rQryDataUmidade);
?>
<html>
<head>
<!--Load the AJAX API-->
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(drawChart);
function drawChart() {
var jsonData1 = $.ajax({
url: "getData.php?tipo=<?php
echo $_GET["tipo"];
?>
<?php
require_once "conf.php";
require_once "funcoes.php";
if ($_GET["tipo"] == "end_device") {
if ($_GET["id_end_device"]) {
$end_device_sql = "AND id_end_device = " . $_GET["id_end_device"] . "";
}
if ($_GET["periodo"] > 24) {
$timestamp_sql = "to_char(timestamp, 'DD-MM-YY HH24:MI') as timestamp_ajustado";
} else {
$timestamp_sql = "to_char(timestamp, 'HH24:MI') as timestamp_ajustado";
}
$iQryData = pg_retorna("SELECT *,\n " . $timestamp_sql . "\n\t\t\t\t\t\t\t\t FROM data WHERE 1 = 1 \n " . $end_device_sql . "\n AND id_sensor = " . $_GET["id_sensor"] . " \t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t AND timestamp > (now()::timestamp(0) at time zone 'GMT-2' - INTERVAL '" . $_GET["periodo"] . " HOUR') ORDER BY timestamp ASC", $rQryData);
}
$array = array();
$array['cols'][] = array('type' => 'string');
$array['cols'][] = array('type' => 'number');
//HERE you have the difference
for ($i = 0; $i < $iQryData; $i++) {
if ($rQryData[$i]["payload"] > 0) {
$array['rows'][]['c'] = array(array('v' => $rQryData[$i]["timestamp_ajustado"]), array('v' => $rQryData[$i]["payload"]));
}
}
echo json_encode($array);
?>
