EEB_SQLITE3 PHP Code Examples

Example #1

0

Show file

File: energy-use.php Project: urbanengr/openstudio_nodejs

// define the sql file path
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)
{

Example #2

0

Show file

File: zone-component-load.php Project: urbanengr/openstudio_nodejs

// define the sql file path
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}");
if ($_GET['for'] == '' && $_GET['table'] == '') {
    $_SESSION['for'] = '1ST FLOOR-MIDDLE';
    $_SESSION['table'] = 'Estimated Cooling Peak Load Components';
} else {
    if ($_GET['for'] == '') {
    } else {
        $_SESSION['for'] = $_GET['for'];
    }
    if ($_GET['table'] == '') {
    } else {
        $_SESSION['table'] = $_GET['table'];
    }
}
$load_vals = $eeb->getValuesByColumn('ZoneComponentLoadSummary', $_SESSION['for'], $_SESSION['table'], '%');
$zone = $eeb->getReportForStrings('ZoneComponentLoadSummary');

Example #3

0

Show file

File: energy-intensity.php Project: urbanengr/openstudio_nodejs

// define the sql file path
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}");
$total_vals = $eeb->getValues('AnnualBuildingUtilityPerformanceSummary', 'Entire Facility', 'Site and Source Energy', '%');
$site_vals = $eeb->getValues('AnnualBuildingUtilityPerformanceSummary', 'Entire Facility', 'End Uses', 'kBtu');
$source_vals = $eeb->getValues('SourceEnergyEndUseComponentsSummary', 'Entire Facility', 'Source Energy End Use Components Summary', 'kBtu');
$area_vals = $eeb->getValues('AnnualBuildingUtilityPerformanceSummary', 'Entire Facility', 'Building Area', '%');
?>

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title>EEB Hub Simulation Tools: Comprehensive</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="">

Example #4

0

Show file

File: simulate-eem.php Project: urbanengr/openstudio_nodejs

// go to eeb_rb folder
$cmd = "runenergyplus eem_{$version}.idf /usr/local/EnergyPlus-8-0-0/WeatherData/USA_PA_Philadelphia.Intl.AP.724080_TMY3.epw";
$run = shell_exec($cmd);
# run the simulation
# add the new version EEM model to the list
$_SESSION['Model'][$version] = "eem_{$version}";
// udpate the latest version
$cur_model = "eem_{$version}";
//assign the current model
// baseline energy cost
$baselineCost = $_SESSION['newCost'][0];
// the current year from 1 to 10
$current_yr = ++$_SESSION['current_yr'];
// add a new energy simulation cost
$sql_file = "Output/{$cur_model}.sql";
$eeb = new EEB_SQLITE3("{$sql_file}");
$electric_tariff = $eeb->getValues('Tariff Report', 'BLDG101_ELECTRIC_RATE', 'Categories', '%');
$gas_tariff = $eeb->getValues('Tariff Report', 'BLDG101_GAS_RATE', 'Categories', '%');
$newCost = $_SESSION['newCost'][$current_yr] = round($electric_tariff['Total (~~$~~)'][Sum] + $gas_tariff['Total (~~$~~)'][Sum], 2);
$_SESSION['cur_model'] = "eem_{$version}";
// add a new installation cost
if ($addAirEconCost) {
    // get the air economizer data from Fans report table
    $fans = $eeb->getValues('EquipmentSummary', 'Entire Facility', 'Fans', '%');
    $airEconUnit = 0.5;
    // air economizer unit ($/CFM)
    $measureCost = $fans['FAN VARIABLE VOLUME 1']['Max Air Flow Rate'] * $airEconUnit;
    $installationCost += $measureCost;
}
if ($addCondensingBoilerCost) {
    // get the water boiler data from Central Plant report table

Example #5

0

Show file

File: energy-cost.php Project: urbanengr/openstudio_nodejs

// define the sql file path
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}");
$electric_tariff = $eeb->getValues('Tariff Report', 'BLDG101_ELECTRIC_RATE', 'Categories', '%');
$gas_tariff = $eeb->getValues('Tariff Report', 'BLDG101_GAS_RATE', 'Categories', '%');
function printRow($Row)
{
    foreach ($Row as $r) {
        if ($r > 0) {
            echo "<td> {$r} </td>";
        } else {
            echo "<td> 0.0 </td>";
        }
    }
}
function getRowData($Row)
{
    echo '[';

Example #6

0

Show file

File: all-site-energy.php Project: urbanengr/openstudio_nodejs

    $sql_file3 = "eem/{$user_dir}/Output/{$_POST[Model][3]}.sql";
} else {
    $sql_file3 = "ENERGYPLUS/idf/{$_SESSION[Model][0]}/EnergyPlusPreProcess/EnergyPlus-0/eplusout.sql";
}
/*
$sql_file1="eem/{$user_dir0}{$_POST['Model'][0]}.idf/EnergyPlusPreProcess/EnergyPlus-0/eplusout.sql";
$sql_file2="eem/{$user_dir1}{$_POST['Model'][1]}.idf/EnergyPlusPreProcess/EnergyPlus-0/eplusout.sql";
$sql_file3="eem/{$user_dir2}{$_POST['Model'][2]}.idf/EnergyPlusPreProcess/EnergyPlus-0/eplusout.sql";
$sql_file4="eem/{$user_dir3}{$_POST['Model'][3]}.idf/EnergyPlusPreProcess/EnergyPlus-0/eplusout.sql";
*/
$sql_file = "eem/{$user_dir}/Output/{$_SESSION['cur_model']}.sql";
#$eeb = new EEB_SQLITE3('php/modified_V8_V720.sql');
$baseline = new EEB_SQLITE3("./{$sql_file0}");
$eem1 = new EEB_SQLITE3("./{$sql_file1}");
$eem2 = new EEB_SQLITE3("./{$sql_file2}");
$eem3 = new EEB_SQLITE3("./{$sql_file3}");
# Baseline data
$base_e_vals = $baseline->getValuesByCategory('END USE ENERGY CONSUMPTION ELECTRICITY MONTHLY', 'Meter', '', '%');
$baseline_value[Jan] = array_sum($base_e_vals["January"]);
$baseline_value[Feb] = array_sum($base_e_vals["February"]);
$baseline_value[Mar] = array_sum($base_e_vals["March"]);
$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) . "]";

PHP EEB_SQLITE3 Examples