= commands.command_start AND epex_start < next_commands.command_start JOIN ( SELECT tax.tax_per_kwh, tax.tax_start, next_tax.tax_start tax_end FROM tax JOIN tax AS next_tax ON next_tax.prev_tax_id = tax.tax_id ) AS ebal ON tax_start <= epex_start AND tax_end > epex_start JOIN ( SELECT fee.fee_per_kwh, fee.fee_start, next_fee.fee_start fee_end FROM fee JOIN fee AS next_fee ON next_fee.prev_fee_id = fee.fee_id ) AS efee ON fee_start <= epex_start AND fee_end > epex_start JOIN ( SELECT btw.btw_percent, btw.btw_start, next_btw.btw_start btw_end FROM btw JOIN btw AS next_btw ON next_btw.prev_btw_id = btw.btw_id ) AS ebtw ON btw_start <= epex_start AND btw_end > epex_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(); echo("\n\n"); while (($finfo = $res->fetch_field())) { echo(''); } echo(""); echo(""); echo(""); echo(""); echo("\n\n"); $roundtrip = 0.844; $bat = 8 - 7.64; $cost = $bat*0.30083/$roundtrip; $prof = 0; while (($row = mysqli_fetch_array($res, MYSQLI_ASSOC))) { echo(''); foreach ($row as $data) { if ($data === NULL) echo(''); else echo(''); } echo(""); echo(""); echo(""); echo(""); echo("\n"); $bp = $cost/$bat; $bat -= $row['disc']; $cost -= $row['disc']*$bp; $prof += $row['disc']*($row['gov_price'] - $bp); $bat += $roundtrip*$row['chrg']; $cost += $row['chrg']*$row['gov_price']; } echo(''); for ($i = 0; $i < 10; $i++) { echo(''); } echo(""); echo(""); echo(""); echo(""); echo("\n"); echo("\n"); echo("

'); //if ($show_table_names) echo($finfo->table.' '); echo($finfo->name.'	bat	ink	bp	prof
NULL	'.$data.'	".round($bat,3)."	".round($cost,2)."	".round($cost/$bat,5)."	".round($prof,2)."
---	".round($bat,3)."	".round($cost,2)."	".round($cost/$bat,5)."	".round($prof,2)."

\n"); html_end(); ?>