<?php require "sqlite.php"; open_sqlite(); $p = array(); $res = $sq->query("SELECT time*1000, pwr FROM edata WHERE time > " . (time() - 300)); while ($r = $res->fetchArray(SQLITE3_NUM)) { $p[] = $r; } $res->finalize(); close_sqlite(); $data = json_encode($p, JSON_NUMERIC_CHECK); require "json_out.php";
<?php require "sqlite.php"; print "<table>\n"; print "<tr><th>date</th><th>peak</th><th>off-peak</th><th>cost</th><th>alt. tar. diff.</th></tr>\n"; for ($i = -30; $i <= 0; $i++) { $t = time() + $i * 86400; $peak = false; if ($a = get_stats($i)) { $peak = $a[0]; $off_peak = $a[1]; } else { if (!open_sqlite($i)) { continue; } $res = @$sq->query('SELECT MIN(tar0),MAX(tar0),MIN(tar1),MAX(tar1) FROM edata'); if (!$res instanceof Sqlite3Result) { close_sqlite(); continue; } while ($r = $res->fetchArray(SQLITE3_NUM)) { //print(($r[1]-$r[0])*(0.2003+0.4144+0.0115)."\n"); //print(($r[3]-$r[2])*(0.0691+0.2023+0.0115)."\n"); $peak = $r[1] - $r[0]; $off_peak = $r[3] - $r[2]; } $res->finalize(); close_sqlite(); save_stats($i, array($peak, $off_peak)); } if ($peak) {