<?
include "common.php";

$time = time();

$start_time = db_single_field(<<<EOQ
SELECT MIN(command_start) FROM commands
EOQ);


$res = db_query(<<<EOQ
SELECT time, command, gbuy, gsell, solar, `disc`, `chrg`, gbuy - gsell + solar + disc - chrg used, gov_price,
gov_price*(gbuy-gsell) grid FROM (
	SELECT FROM_UNIXTIME(epex_start) time, commands.command, epex_price, (epex_price+0.0205+0.1088)*1.21 gov_price,
		epex_start,
		meter1.meter_value_diff_next + meter2.meter_value_diff_next `gbuy`,
		meter3.meter_value_diff_next + meter4.meter_value_diff_next `gsell`,
		meter5.meter_value_diff_next `solar`,
		meter6.meter_value_diff_next `disc`,
		meter7.meter_value_diff_next `chrg`
	FROM commands
	LEFT JOIN commands AS next_commands ON next_commands.prev_command_id = commands.command_id
	JOIN epex ON epex_start >= commands.command_start AND epex_start < next_commands.command_start
	JOIN (
		SELECT meter_value_diff_next, meter_value, meter_value_time AS epex_start
		FROM meter_values WHERE meter_id = 1 AND meter_value_diff_next IS NOT NULL
	) AS meter1 USING (epex_start)
	JOIN (
		SELECT meter_value_diff_next, meter_value_time AS epex_start
		FROM meter_values WHERE meter_id = 2 AND meter_value_diff_next IS NOT NULL
	) AS meter2 USING (epex_start)
	JOIN (
		SELECT meter_value_diff_next, meter_value_time AS epex_start
		FROM meter_values WHERE meter_id = 3 AND meter_value_diff_next IS NOT NULL
	) AS meter3 USING (epex_start)
	JOIN (
		SELECT meter_value_diff_next, meter_value_time AS epex_start
		FROM meter_values WHERE meter_id = 4 AND meter_value_diff_next IS NOT NULL
	) AS meter4 USING (epex_start)
	JOIN (
		SELECT meter_value_diff_next, meter_value_time AS epex_start
		FROM meter_values WHERE meter_id = 5 AND meter_value_diff_next IS NOT NULL
	) AS meter5 USING (epex_start)
	JOIN (
		SELECT meter_value_diff_next, meter_value_time AS epex_start
		FROM meter_values WHERE meter_id = 6 AND meter_value_diff_next IS NOT NULL
	) AS meter6 USING (epex_start)
	JOIN (
		SELECT meter_value_diff_next, meter_value_time AS epex_start
		FROM meter_values WHERE meter_id = 7 AND meter_value_diff_next IS NOT NULL
	) AS meter7 USING (epex_start)
	WHERE commands.command_start >= $start_time
) AS bla
ORDER BY epex_start
EOQ);

html_start();

db_dump_result($res);

html_end();
?>