Method getElecOrGasUse

src/utilities/sql/SqlFile_Impl.cpp:1189–1244

  }

  OptionalDouble SqlFile_Impl::getElecOrGasUse(bool bGetGas) const {
    boost::optional<std::vector<std::string>> selectedRowNames;

    boost::optional<std::vector<std::string>> qualifiedRowNames;
    boost::optional<std::vector<std::string>> fuelTypeRowNames;
    OptionalDouble result;

    std::string fuelType;
    if (bGetGas) {
      fuelType = "'COMM GAS'";
    } else {
      fuelType = "'COMM ELECT'";
    }

    std::string query("select rowname from TabularDataWithStrings where TableName = 'Tariff Summary' and ColumnName = 'Group' and Value = ");
    query += fuelType;

    selectedRowNames = execAndReturnVectorOfString(
      "select rowname from TabularDataWithStrings where TableName = 'Tariff Summary' and (ColumnName = 'Selected' and Value = 'Yes')");
    qualifiedRowNames = execAndReturnVectorOfString(
      "select rowname from TabularDataWithStrings where TableName = 'Tariff Summary' and (ColumnName = 'Qualified' and Value = 'Yes')");
    fuelTypeRowNames = execAndReturnVectorOfString(query);

    if (!selectedRowNames || !qualifiedRowNames || !fuelTypeRowNames) {
      return result;
    }

    std::vector<std::string> names;
    for (unsigned i = 0; i < selectedRowNames->size(); i++) {
      for (unsigned j = 0; j < qualifiedRowNames->size(); j++) {
        if (selectedRowNames->at(i) == qualifiedRowNames->at(j)) {
          names.push_back(selectedRowNames->at(i));
        }
      }
    }

    std::string name;
    for (unsigned i = 0; i < names.size(); i++) {
      for (unsigned j = 0; j < fuelTypeRowNames->size(); j++) {
        if (names.at(i) == fuelTypeRowNames->at(j)) {
          name = names.at(i);
          break;
        }
      }
    }
    if (name.empty()) {
      return result;
    }

    query = "SELECT value from TabularDataWithStrings where ReportName = 'Tariff Report' and ReportForString = '";
    query += name;
    query += "' and TableName = 'Native Variables' and ColumnName = 'Sum' and RowName = 'TotalEnergy'";
    result = execAndReturnFirstDouble(query);

    return result;
  }

  OptionalDouble SqlFile_Impl::getElecOrGasCost(bool bGetGas) const {