function initTimestamp($arr) { $zwave = new Zwave(); $arrMvt2 = array(); for ($i = 0; $i < count($arr); $i++) { array_push($arrMvt2, $zwave->GetTimestamp($arr[$i]['sensor'])); } return $arrMvt2; }
function saveHistory() { $bdd = getBDD(); $zwave = new Zwave(); $req = $bdd->query('SELECT * FROM at_sensors WHERE history = 1'); while ($data = $req->fetch()) { $id = $data['id']; $sensor = $data['sensor']; $protocol = $data['protocol']; switch ($protocol) { case 'zwave': $value = $zwave->getValue($sensor); $timestamp = $zwave->GetTimestamp($sensor); $date = date('Y-m-d', $timestamp); $time = date('H:i:s', $timestamp); $bdd->exec("INSERT INTO at_sensors_values VALUES ('', '{$id}', '{$value}', '{$date}', '{$time}')"); break; } } }