<?php
require_once 'config/config.php';
$minTime = date("U") - 60 * 60 * 24;
$res = BDD::chartPresent($mysqli, $minTime);
$labels = BDD::nodesLabel($mysqli, $minTime);
$nodeUid = null;
$startTime = null;
$lastTime = null;
$trace = "\n";
echo "var jsonData = [";
while ($row = $res->fetch_assoc()) {
if ($nodeUid == null) {
$nodeUid = $row['nodeUid'];
$trace .= "New node: {$nodeUid}\n";
if ($row['isPresent'] == "1") {
$startTime = $row['eventTime'];
$trace .= "Begin {$startTime}\n";
}
} elseif ($nodeUid == $row['nodeUid']) {
$trace .= "Same Node\n";
if ($startTime == null) {
if ($row['isPresent'] == "1") {
$startTime = $row['eventTime'];
$trace .= "Begin {$startTime}\n";
}
} elseif ($row['isPresent'] == "0") {
$lastTime = $row['eventTime'];
echo "['{$labels[$nodeUid]}',new Date({$startTime}*1000),new Date({$lastTime}*1000)],";
$trace .= "Stop {$lastTime}\n";
$startTime = null;
