function power_acc_to_kwhd($feedid, $time_now, $value)
{
if ($value > 0) {
$new_kwh = 0;
// Get last value
$last = get_feed_timevalue($feedid);
$last_kwh = $last['value'];
$last_time = strtotime($last['time']);
if ($last_time) {
// kWh calculation
$time_elapsed = $time_now - $last_time;
$kwh_inc = $time_elapsed * $value / 3600000;
$new_kwh = $last_kwh + $kwh_inc;
}
$feedtime = mktime(0, 0, 0, date("m", $time_now), date("d", $time_now), date("Y", $time_now));
update_feed_data($feedid, $time_now, $feedtime, $new_kwh);
return $value;
}
}
function feed_controller()
{
require "Models/feed_model.php";
global $session, $action, $format;
$output['content'] = "";
$output['message'] = "";
//---------------------------------------------------------------------------------------------------------
// Set feed datatype: DataType::UNDEFINED|REALTIME|DAILY|HISTOGRAM
// http://yoursite/emoncms/feed/type?id=1&type=1
//---------------------------------------------------------------------------------------------------------
if ($action == "type" && $session['write']) {
$feedid = intval($_GET["id"]);
$type = intval($_GET["type"]);
if (feed_belongs_user($feedid, $session['userid'])) {
set_feed_datatype($feedid, $type);
$output['message'] = _("Feed type changed");
} else {
$output['message'] = _("Feed does not exist");
}
if ($format == 'html') {
header("Location: view?id={$feedid}");
// Return to feed list page
}
} elseif ($action == "tag" && $session['write']) {
$feedid = intval($_GET["id"]);
if (feed_belongs_user($feedid, $session['userid'])) {
$newfeedtag = preg_replace('/[^\\w\\s-.]/', '', $_GET["tag"]);
// filter out all except for alphanumeric white space and dash and full stop
$newfeedtag = db_real_escape_string($newfeedtag);
set_feed_tag($feedid, $newfeedtag);
$output['message'] = _("Feed tag changed");
} else {
$output['message'] = _("Feed does not exist");
}
if ($format == 'html') {
header("Location: list");
// Return to feed list page
}
} elseif ($action == "rename" && $session['write']) {
$feedid = intval($_GET["id"]);
if (feed_belongs_user($feedid, $session['userid'])) {
$newfeedname = preg_replace('/[^\\w\\s-.]/', '', $_GET["name"]);
// filter out all except for alphanumeric white space and dash
$newfeedname = db_real_escape_string($newfeedname);
set_feed_name($feedid, $newfeedname);
$output['message'] = _("Feed renamed");
} else {
$output['message'] = _("Feed does not exist");
}
if ($format == 'html') {
header("Location: list");
// Return to feed list page
}
} elseif ($action == "delete" && $session['write']) {
$feedid = intval($_GET["id"]);
if (feed_belongs_user($feedid, $session['userid'])) {
delete_feed($userid, $feedid);
$output['message'] = _("Feed ") . get_feed_name($feedid) . _(" deleted");
} else {
$output['message'] = _("Feed does not exist");
}
}
//---------------------------------------------------------------------------------------------------------
// Permanent delete equivalent to empty recycle bin
// http://yoursite/emoncms/feed/permanentlydelete
//---------------------------------------------------------------------------------------------------------
if ($action == "permanentlydelete" && $session['write']) {
permanently_delete_feeds($session['userid']);
$output['message'] = "Deleted feeds are now permanently deleted";
}
//---------------------------------------------------------------------------------------------------------
// Restore feed ( if in recycle bin )
// http://yoursite/emoncms/feed/restore?id=1
//---------------------------------------------------------------------------------------------------------
if ($action == "restore" && $session['write']) {
$feedid = intval($_GET["id"]);
if (feed_belongs_user($feedid, $session['userid'])) {
restore_feed($userid, $feedid);
}
$output['message'] = "feed restored";
if ($format == 'html') {
header("Location: list");
}
// Return to feed list page
}
//---------------------------------------------------------------------------------------------------------
// Feed List
// http://yoursite/emoncms/feed/list.html
// http://yoursite/emoncms/feed/list.json
//---------------------------------------------------------------------------------------------------------
if ($action == 'list' && $session['read']) {
$del = 0;
if (isset($_GET["del"])) {
$del = intval($_GET["del"]);
}
$feeds = get_user_feeds($session['userid'], $del);
if ($format == 'json') {
$output['content'] = json_encode($feeds);
}
if ($format == 'html') {
$output['content'] = view("feed/list_view.php", array('feeds' => $feeds, 'del' => $del));
}
} elseif ($action == 'view' && $session['read']) {
$feedid = intval($_GET["id"]);
if (feed_belongs_user($feedid, $session['userid'])) {
$feed = get_feed($feedid);
}
if ($format == 'json') {
$output['content'] = json_encode($feed);
// Allow for AJAX from remote source
if ($_GET["callback"]) {
$output['content'] = $_GET["callback"] . "(" . json_encode($feed) . ");";
}
}
if ($format == 'html') {
$output['content'] = view("feed/feed_view.php", array('feed' => $feed));
}
} elseif ($action == 'value' && $session['read']) {
$feedid = intval($_GET["id"]);
if (feed_belongs_user($feedid, $session['userid'])) {
$output['content'] = get_feed_value($feedid);
}
} elseif ($action == 'data' && $session['read']) {
$feedid = intval($_GET['id']);
// Check if feed belongs to user
if (feed_belongs_user($feedid, $session['userid'])) {
$start = floatval($_GET['start']);
$end = floatval($_GET['end']);
$dp = intval($_GET['dp']);
$data = get_feed_data($feedid, $start, $end, $dp);
$output['content'] = json_encode($data);
} else {
$output['message'] = "Permission denied";
}
}
//---------------------------------------------------------------------------------------------------------
// get histogram data: energy used at different powers in the time range given
// http://yoursite/emoncms/feed/histogram?id=1&start=000&end=000
//---------------------------------------------------------------------------------------------------------
if ($action == 'histogram' && $session['read']) {
$feedid = intval($_GET['id']);
// Check if feed belongs to user
if (feed_belongs_user($feedid, $session['userid'])) {
$start = floatval($_GET['start']);
$end = floatval($_GET['end']);
$data = get_histogram_data($feedid, $start, $end);
$output['content'] = json_encode($data);
} else {
$output['message'] = "Permission denied";
}
}
//---------------------------------------------------------------------------------------------------------
// get kwh per day at given power range
// http://yoursite/emoncms/feed/kwhatpower?id=3&min=1000&max=10000
//---------------------------------------------------------------------------------------------------------
if ($action == 'kwhatpower' && $session['read']) {
$feedid = intval($_GET['id']);
// Check if feed belongs to user
if (feed_belongs_user($feedid, $session['userid'])) {
$min = floatval($_GET['min']);
$max = floatval($_GET['max']);
$data = get_kwhd_atpower($feedid, $min, $max);
$output['content'] = json_encode($data);
} else {
$output['message'] = "This is not your feed...";
}
}
//---------------------------------------------------------------------------------------------------------
// Set a datapoint at a given time.
// http://yoursite/emoncms/feed/edit?id=1&time=...&newvalue=...
//---------------------------------------------------------------------------------------------------------
if ($action == "edit" && $session['write']) {
$feedid = intval($_GET["id"]);
if (feed_belongs_user($feedid, $session['userid'])) {
$time = intval($_GET["time"]);
$value = floatval($_GET["newvalue"]);
update_feed_data($feedid, time(), $time, $value);
$output['message'] = "Edit";
}
}
if ($action == "export" && $session['write']) {
// Feed id and start time of feed to export
$feedid = intval($_GET["id"]);
$start = intval($_GET["start"]);
if (feed_belongs_user($feedid, $session['userid'])) {
// Open database etc here
// Extend timeout limit from 30s to 2mins
set_time_limit(120);
// Regulate mysql and apache load.
$block_size = 1000;
$sleep = 20000;
$feedname = "feed_" . trim($feedid) . "";
$fileName = $feedname . '.csv';
// There is no need for the browser to cache the output
header("Cache-Control: no-cache, no-store, must-revalidate");
// Tell the browser to handle output as a csv file to be downloaded
header('Content-Description: File Transfer');
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename={$fileName}");
header("Expires: 0");
header("Pragma: no-cache");
// Write to output stream
$fh = @fopen('php://output', 'w');
// Load new feed blocks until there is no more data
$moredata_available = 1;
while ($moredata_available) {
// 1) Load a block
$result = db_query("SELECT * FROM {$feedname} WHERE time>{$start} \n ORDER BY time Asc Limit {$block_size}");
$moredata_available = 0;
while ($row = db_fetch_array($result)) {
// Write block as csv to output stream
fputcsv($fh, array($row['time'], $row['data']));
// Set new start time so that we read the next block along
$start = $row['time'];
$moredata_available = 1;
}
// 2) Sleep for a bit
usleep($sleep);
}
fclose($fh);
exit;
}
}
return $output;
}
