if ($_POST['num_package'] != NULL) { $cur_model = $_SESSION['cur_model'] = $_POST['num_package']; } elseif ($_POST['num_package'] == NULL && $_SESSION['cur_model'] == NULL) { $cur_model = $_SESSION[cur_model]; } else { $cur_model = $_SESSION[cur_model]; } // baseline sql file path if ($cur_model == $_SESSION['Model'][0]) { $sql_file = "ENERGYPLUS/idf/{$cur_model}/EnergyPlusPreProcess/EnergyPlus-0/eplusout.sql"; } else { // eem sql file path $sql_file = "eem/{$_SESSION['user_dir']}/Output/{$cur_model}.sql"; } $eeb = new EEB_SQLITE3("{$sql_file}"); $e_vals = $eeb->getValuesByMonthly('END USE ENERGY CONSUMPTION ELECTRICITY MONTHLY', 'Meter', '', '%'); $ng_vals = $eeb->getValuesByMonthly('END USE ENERGY CONSUMPTION NATURAL GAS MONTHLY', 'Meter', '', '%'); // echo $eeb->getFilePath(); function printRow($row) { foreach ($row as $v) { if ($v >= 0) { echo "<td> {$v} </td>"; } else { echo "<td> 0.0 </td>"; } } } function printMonthlyData($row) { echo '[';
$baseline_value[Apr] = array_sum($base_e_vals["April"]); $baseline_value[May] = array_sum($base_e_vals["May"]); $baseline_value[Jun] = array_sum($base_e_vals["June"]); $baseline_value[Jul] = array_sum($base_e_vals["July"]); $baseline_value[Aug] = array_sum($base_e_vals["August"]); $baseline_value[Sep] = array_sum($base_e_vals["September"]); $baseline_value[Oct] = array_sum($base_e_vals["October"]); $baseline_value[Nov] = array_sum($base_e_vals["November"]); $baseline_value[Dec] = array_sum($base_e_vals["December"]); $baseline_data = "[" . convertToDataString($baseline_value, NULL, NULL, NULL) . "]"; //print_r($baseline_data); # EEM data $base2_e_vals = $baseline->getValuesByMonthly('END USE ENERGY CONSUMPTION ELECTRICITY MONTHLY', 'Meter', '', '%'); $eem1_e_vals = $eem1->getValuesByMonthly('END USE ENERGY CONSUMPTION ELECTRICITY MONTHLY', 'Meter', '', '%'); $eem2_e_vals = $eem2->getValuesByMonthly('END USE ENERGY CONSUMPTION ELECTRICITY MONTHLY', 'Meter', '', '%'); $eem3_e_vals = $eem3->getValuesByMonthly('END USE ENERGY CONSUMPTION ELECTRICITY MONTHLY', 'Meter', '', '%'); /* input_data: 2d Array eg. array['INTERIORLIGHTS:ELECTRICITY'] * start_month: integer eg. 1 = January * end_month: integer eg. 3 = March * return a string eg. "1 , 2, 3, 4" */ function getDataByMonth($input_data, $start_month, $end_month) { $index = 0; $counter = 1; // Start From January $output = ""; if ($start_month < 1 | $end_month > 12) { return 1; } foreach ($input_data as $input) {