currency.class.cpp

Go to the documentation of this file.

class cls_currency
{
  public:

    string entity;
    string currency_name;
    string currency_id;   
    //char   symbol;
    
    string dropDown_currency(string defaultCurr = "EUR");
    bool  set_curr(string the_curr);
    float to_curr(float amnt, string the_curr);
    float conversion_factor(string from_curr, string to_curr);
};

/*************************************
 * dropDown_currency
 *
 * ***********************************/
string cls_currency::dropDown_currency(string defaultCurr)
{
  string s;

  s = s + "<select required name=\"currency\">";
  db.res = db.stmt->executeQuery("SELECT currency_id FROM " + oConfig.tbl_prefix + "_currencies;");
  while (db.res->next())
  {
    s = s + "<option value=\"" + db.res->getString("currency_id") + "\"";
    if (db.res->getString("currency_id") == defaultCurr) {s = s + " selected "; }
    s = s + ">" + db.res->getString("currency_id") + "</option>";
  }
   s = s + "</select>";
   return s;
}

bool cls_currency::set_curr(string the_curr)
{
  string s;
  db_helper this_db;
  //s = "SELECT COUNT(*) AS EXIST_NBR from " + oConfig.tbl_prefix + "_currencies WHERE currency_id = '" + the_curr + "';";
  s = "SELECT currency_id FROM " + oConfig.tbl_prefix + "_currencies WHERE currency_id = '" + the_curr + "';";
  this_db.res = this_db.stmt->executeQuery(s);
  if(this_db.res->rowsCount() == 1)
  {
    this->currency_id = the_curr;
    return true;
  }
  else
  {
    error_message = error_message + "<li>ERRNO3411</li>";
    return false; //table not found ;-)
  }
  error_message = error_message + "<li>ERRNO3412</li>";
  return false; //table not found ;-)
}

inline float cls_currency::to_curr(float amnt, string to_curr)
{  
  if (to_curr == this->currency_id) { return amnt; }
  db_helper this_db;
  string s;
  
  s = "SELECT * FROM " + oConfig.tbl_prefix + "_currencies WHERE currency_id = '" + this->currency_id + "';";
  this_db.res = this_db.stmt->executeQuery(s);
  if (this_db.res->next())
  {
    amnt = amnt * atof(this_db.res->getString("eur_p_one").c_str());
  }
  else
  {
    error_message = error_message + "<li>ERRNO.C.1011: invalid start currency</li>";
    return 0; //no currency
  }  

  if (to_curr != "EUR")
  {
    s = "SELECT * FROM " + oConfig.tbl_prefix + "_currencies WHERE currency_id = '" + to_curr + "';";
    this_db.res = this_db.stmt->executeQuery(s);
    if (this_db.res->next())    
    {
      amnt = amnt * atof(this_db.res->getString("one_p_eur").c_str());
    }
    else 
    {
      error_message = error_message + "<li>ERRNO.C.1010: invalid destiny currency in to_curr</li>";
      return 0;
    }
  }
  
  return amnt;
}