asset_class.class.cpp

Go to the documentation of this file.

/*
 *
 * class assets_class
 *
 * copyright: (c) Philippe De Brouwer 2014
 *
 * last modification:
 *
 */

class asset_class
{
public:
  int     asset_class_id;
  string  asset_class_name;
  float   E_R;

  string dropDown_assetClass(int defaultAC = 0);
  bool exists(int acID);
  std::map <int, string> get_assetList();

private:
};


/* **********************************************
 *
 * exists
 * **********************************************/
/* returns "" if investment is valid             */
bool asset_class::exists(int acID)
{
  // if exists asset_class

  // correct currency
  return true;
}

/*************************************
 * dropDown_assetClass
 *
 * returns a string that is a dropdown box of all asset classes
 * ***********************************/
string asset_class::dropDown_assetClass(int defaultAC)
{
  string s;

  s = s + "<select required name=\"asset_class\">";
  db.res = db.stmt->executeQuery("SELECT asset_class_id, asset_class_name FROM " + oConfig.tbl_prefix + "_asset_classes;");
  while (db.res->next())
  {
    s = s + "<option value=\"" + db.res->getString("asset_class_id") + "\"";
    if (db.res->getString("asset_class_id") == std::to_string(defaultAC)) {s = s + " selected "; }
    s = s + ">" + db.res->getString("asset_class_name") + "</option>";
  }
  s = s + "</select>";
  return s;
  }


std::map<int, string> asset_class::get_assetList()
{
  int i;
  std::map<int, string> theList;
  db.res = db.stmt->executeQuery("SELECT * FROM " + oConfig.tbl_prefix + "_asset_classes ORDER BY asset_class_id;");
  while (db.res->next())
    {
      i = atoi(db.res->getString("asset_class_id").c_str());
      theList[i] = db.res->getString("asset_class_name");
    }
  return theList;
}