<?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;