require "../conn/pdo.php"; require "../conn/conninfo.php"; $sensors = new conninfo($pdo); //$data_sensor_name = trim($_GET["sensor"]); $lastMinutes = trim($_GET["min"]); $arraySensors = array("A1"); $arrayNum = 0; $sensorName = array(); $jsonCategories = array(); $jsonData = array(); //if(strlen($data_sensor_name)>0) { foreach ($arraySensors as $data_sensor_name) { $nowtime = time(); $startDate = $nowtime - 60 * $lastMinutes; $endDate = $nowtime; $tmpList = $sensors->get_sensordata_range($data_sensor_name, $startDate, $endDate); $numX = count($tmpList) / 10; $i = 0; $jsonCategories[$arrayNum] = '['; $jsonData[$arrayNum] = '['; foreach ($tmpList as $row) { if ($i == 0) { $startTime = $row['datetime']; } $endTime = $row['datetime']; $sensorName[$arrayNum] = $row['name']; if ($i > 0) { $jsonCategories[$arrayNum] = $jsonCategories[$arrayNum] . ', '; $jsonData[$arrayNum] = $jsonData[$arrayNum] . ', '; } $jsonCategories[$arrayNum] = $jsonCategories[$arrayNum] . "'" . date("H:i", $row['datetime']) . "'";
require "../conn/conninfo.php"; require_once "../../phpChart_Lite/conf.php"; $sensors = new conninfo($pdo); $data_sensor_name = trim($_GET["sensor"]); ?> <!DOCTYPE HTML> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>phpChart - Basic Chart</title> </head> <body> <?php if (strlen($data_sensor_name) > 0) { $tmpList = $sensors->get_sensordata_range($data_sensor_name, 60); $arrayData = array(); $i = 0; foreach ($tmpList as $row) { $arrayData[$i] = $row['txtdata']; if ($i == 0) { $startTime = $row['datetime']; } $endTime = $row['datetime']; $i++; } $dateTitle = date("Y-m-d H:i", $startTime) . "~" . date("Y-m-d H:i", $endTime) . "溫度趨線圖"; //print_r($arrayData); $pc = new C_PhpChartX(array($arrayData), 'basic_chart'); $pc->set_animate(true); $pc->set_title(array('text' => $dateTitle));
<?php require "../conn/pdo.php"; require "../conn/conninfo.php"; require "functions.php"; $sensors = new conninfo($pdo); $lastMinutes = trim($_GET["min"]); $typeSensor = trim($_GET["type"]); $endDate = time(); $startDate = $endDate - 60 * $lastMinutes; $arrayDATA = ''; $arrayLABLE = ''; $arrayValueDisplay = ''; $arrayUNIT = ''; $tmpList = $sensors->get_sensordata_range($typeSensor, $startDate, $endDate); $counts = count($tmpList); $i = 0; if ($counts > 0) { foreach ($tmpList as $row) { $i++; if ($counts <= 4) { $arrayLABLE = $arrayLABLE . '"' . $row['datetime'] . '"'; $arrayValueDisplay = $arrayValueDisplay . '"' . round($row['txtdata'], 1) . $row['unit'] . '"'; } else { if ($counts > 4 and $counts <= 10) { if ($i % 2 == 0) { $arrayLABLE = $arrayLABLE . '"' . $row['datetime'] . '"'; $arrayValueDisplay = $arrayValueDisplay . '"' . round($row['txtdata'], 1) . $row['unit'] . '"'; } else { $arrayLABLE = $arrayLABLE . '"\\r\\n' . $row['datetime'] . '"'; $arrayValueDisplay = $arrayValueDisplay . '"\\r\\n' . round($row['txtdata'], 1) . $row['unit'] . '"';