['$gte' => date('c', strtotime('-24 hours'))]];
$opciones = ['sort' => ['datos.timestamp' => 1]];
$query = new MongoDB\Driver\Query($filtro, $opciones);
$cursor = $manager->executeQuery("calderaDB.calefacionGasoil", $query);
$data = [
'sonda1' => [],
'sonda2' => [],
'sonda3' => [],
'bmeTemp' => [],
'bmeHum' => [],
'bmePres' => [],
'bmeGas' => []
];
foreach ($cursor as $doc) {
if (!isset($doc->datos)) continue;
$d = $doc->datos;
if (!isset($d->timestamp)) continue;
$ts = strtotime($d->timestamp) * 1000;
$data['sonda1'][] = [$ts, isset($d->sonda1) ? (float)$d->sonda1 : null];
$data['sonda2'][] = [$ts, isset($d->sonda2) ? (float)$d->sonda2 : null];
$data['sonda3'][] = [$ts, isset($d->sonda3) ? (float)$d->sonda3 : null];
$data['bmeTemp'][] = [$ts, isset($d->bmeTemp) ? (float)$d->bmeTemp : null];
$data['bmeHum'][] = [$ts, isset($d->bmeHum) ? (float)$d->bmeHum : null];
//$data['bmePres'][] = [$ts, isset($d->bmePres) ? (float)$d->bmePres : null];
$data['bmePres'][] = [$ts, isset($d->bmePres) ? (float)$d->bmePres * 10 : null];
$data['bmeGas'][] = [$ts, isset($d->bmeGas) ? (float)$d->bmeGas : null];
}
} catch (Exception $e) {
die("Error de conexión: " . $e->getMessage());
}
?>
Gráficas Caldera
Temperaturas (Sondas 1, 2, 3)
BME680 (Temp, Humedad, Gas)
BME680 - Presión
Ãrea Gas + Sondas (1,2,3)