<?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) {
