asset.class.cpp

Go to the documentation of this file.

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

class asset
{
public:
  int     asset_id;
  int     investor;
  int     asset_class;
  string  description;
  string  currency;
  float   amount;

  bool set_asset_id   (const std::string& s);
  bool set_investor   (const std::string& s);
  bool set_asset_class(const std::string& s);
  bool set_description(const std::string& s);
  bool set_currency   (const std::string& s);
  bool set_amount     (const std::string& s);
  void list_assets    (int iid);
  void show_edit_form (int iid);
  bool load();
  bool save();
  bool asset_delete ();

private:
  bool exists (int aid);
};


/**********************************************
 *       load
 *
 * ****************************************** */
bool asset::load()
{
  bool rc = false;
  string s = "";
  s = "SELECT * FROM " + oConfig.tbl_prefix + "_assets WHERE asset_id = " + std::to_string(asset_id) + ";";
  db.res = db.stmt->executeQuery(s);
  while (db.res->next())
  {
    if (set_investor   (db.res->getString("investor"))    &&
        set_asset_class(db.res->getString("asset_class")) &&
        set_description(db.res->getString("description")) &&
        set_currency   (db.res->getString("currency"))    &&
        set_amount     (db.res->getString("amount"))) rc = true;
  }
 return rc;
}

/**********************************************
 *   show_edit
 *
 * ****************************************** */
void asset::show_edit_form(int iid)
{

  cout << "<form method=\"post\" action=\"" + oConfig.soft_url + "?a=as\">";
  cout << "<table class=\"asset\">\n";
  cout << "<tr>";
  cout << "<th>Description</th><th>Asset Class</th><th>Amount</th><th>Currency</th><th>Actions</th>";
/*  cout << "</tr>\n";
  oAsset.list_assets(investor_id);
  */
  cout << "</tr>\n<tr>\n";
  cout << "<td><input type=\"text\" name=\"description\" required value=\"" << description << "\"></td>" ;
  cout << "<td>" << oAssetClass.dropDown_assetClass(asset_class) << "</td>" ;
  cout << "<td><input type=\"number\" min=\"0\" name=\"amount\"  required title=\"Please enter a positive number\" value=\"" << amount << "\"></td>" ;
  cout << "<td>" << oCurrency.dropDown_currency(currency) << "</td>" ;
  
    switch (oConfig.layout)
    {
      case '1' :
        cout << "<td><button type=\"submit\" value=\"Submit\"><img src=\"" << oConfig.css_dir << "check.svg\" alt=\"add\" width=\"16\" height=\"16\" alt=\"Save\"></button><a href=\"" + oConfig.soft_url + "?a=if&amp;iid=" << iid << "\" class=\"button\"><img src=\"" << oConfig.css_dir << "arrow_left.svg\" alt=\"Go back without saving the changes!\" width=\"16\" height=\"16\"></a></td>" ;
    break;
      case '2' :
        cout << "<td><button type=\"submit\" value=\"Submit\" data-toggle=\"tooltip\" title=\"" << t_save << "\"><span class=\"glyphicon glyphicon-ok\" style=\"color:green\"></span></button>";
        cout << "<a data-toggle=\"tooltip\" title=\"" << t_cancel << "\" href=\"" + oConfig.soft_url + "?a=if&amp;iid=" << iid << "\"><span class=\"glyphicon glyphicon-chevron-left\"  style=\"color:blue\"></span></a></td>" ;
    break;
      default :
        cout << "<td><button type=\"submit\" value=\"Submit\"><img src=\"" << oConfig.css_dir << "check.svg\" alt=\"add\" width=\"16\" height=\"16\" alt=\"Save\"></button><a href=\"" + oConfig.soft_url + "?a=if&amp;iid=" << iid << "\" class=\"button\"><img src=\"" << oConfig.css_dir << "arrow_left.svg\" alt=\"Go back without saving the changes!\" width=\"16\" height=\"16\"></a></td>" ;
        break;
    }
  
  cout << "</tr></table>\n";
  cout << "<input type=\"hidden\" name=\"iid\" value=\"" << iid << "\" />\n";
  cout << "<input type=\"hidden\" name=\"aid\" value=\"" << asset_id << "\" />\n";
  cout << "<p>All fields are required.</p>";
  cout << "</form>";
}

/**********************************************
 *   void    list_assets(investor_id);
 *
 * ****************************************** */
void asset::list_assets(int iid)
{
  string s = "";
  s = "SELECT A.*, AC.asset_class_name  FROM " + oConfig.tbl_prefix + "_assets AS A, " + oConfig.tbl_prefix + "_asset_classes AS AC WHERE A.asset_class = AC.asset_class_id && A.investor = " + std::to_string(iid) + ";";
  //cout << s;
  db.res = db.stmt->executeQuery(s);

  s = "";
  while (db.res->next())
  {
    s = s + "<tr>";
    s = s + "<td>" + db.res->getString("description") + "</td>";
    s = s + "<td>" + db.res->getString("asset_class_name") + "</td>";
    s = s + "<td>" + db.res->getString("amount") + "</td>";
    s = s + "<td>" + db.res->getString("currency") + "</td>";

    switch (oConfig.layout)
    {
      case '1' :
        s = s + "<td><a href=\"" + oConfig.soft_url + "?a=ae&amp;iid=" + std::to_string(iid) + "&amp;aid=" + db.res->getString("asset_id") + "\"><img src=\"" + oConfig.css_dir + "pen.svg\" alt=\"edit\" width=\"16\" height=\"16\"></a>&nbsp;";
    s =s + "<a href=\"" + oConfig.soft_url + "?a=ad&amp;iid=" + std::to_string(iid) + "&amp;aid=" + db.res->getString("asset_id") + "\"><img src=\"" + oConfig.css_dir + "x.svg\" alt=\"delete\" width=\"16\" height=\"16\"></a></td>";
        break;
      case '2' :
        s = s + "<td><a class=\"btn btn-default\" href=\"" + oConfig.soft_url + "?a=ae&amp;iid=" + std::to_string(iid) + "&amp;aid=" + db.res->getString("asset_id") + "\" data-toggle=\"tooltip\" title=\"" + t_edit + "\"><span class=\"glyphicon glyphicon-pencil\" style=\"color:blue\"></span></a>&nbsp;";
    s = s + "<a href=\"" + oConfig.soft_url + "?a=ad&amp;iid=" + std::to_string(iid) + "&amp;aid=" + db.res->getString("asset_id") + "\" data-toggle=\"tooltip\" title=\"" + t_delete + "\"><span class=\"glyphicon glyphicon-remove\"  style=\"color:red\"></span></a></td>";
    break;
      default :
        s = s + "<td><a href=\"" + oConfig.soft_url + "?a=ae&amp;iid=" + std::to_string(iid) + "&amp;aid=" + db.res->getString("asset_id") + "\"><img src=\"" + oConfig.css_dir + "pen.svg\" alt=\"edit\" width=\"16\" height=\"16\"></a>&nbsp;";
    s =s + "<a href=\"" + oConfig.soft_url + "?a=ad&amp;iid=" + std::to_string(iid) + "&amp;aid=" + db.res->getString("asset_id") + "\"><img src=\"" + oConfig.css_dir + "x.svg\" alt=\"delete\" width=\"16\" height=\"16\"></a></td>";
    break;
    } 
    s = s + "</tr>";
  }
 cout << s;
}

/******************************************
 * set functions
 * ****************************************/

bool asset::set_asset_id(const std::string& s)
{
  int a = atoi(s.c_str());
  bool rc = true;

  if ((a < 0) || (a > 1000000))  //TODO : ad real check if investor_id exists
                                // and if not, block IP and report!!!
  {
    rc = false;
    error_message = error_message + "<li>Sorry, an error occured. The asset cannot be found.</li>";
  }
  else {asset_id = a;}
  return rc;
}

bool asset::set_investor(const std::string& s)
{
  int a = atoi(s.c_str());
  bool rc = true;

  if ((a < 0) || (a > 1000000))  //TODO : ad real check if investor_id exists
                                // and if not, block IP and report!!!
  {
    rc = false;
    error_message = error_message + "<li>...please contact me, I know ...</li>";
  }
  else {investor = a;}
  return rc;
}

bool asset::set_description(const std::string& s)
{
  bool rc = true;
  if (s.length() < 2)
  {
    rc = false;
    error_message = error_message + "<li>a description of the asset is required</li>";
  }
  else  {description = s;}
  return rc;
}

bool asset::set_asset_class(const std::string& s)
{
  int a = atoi(s.c_str());
  bool rc = true;

  if ((a < 0) || (a > 100))  //TODO : ad real check if asset_class exists
  {
    rc = false;
    error_message = error_message + "<li>...please contact me, I know ...</li>";
  }
  else {asset_class = a;}
  return rc;
}

bool asset::set_amount(const std::string& s)
{
  int a = atof(s.c_str());
  bool rc = true;

  if ((a < 0) || (a > 100000000))
  {
    rc = false;
    error_message = error_message + "<li>the amount seems wrong (please correct or email the " + t_author + ")</li>";
  }
  else {amount = a;}
  return rc;
}

bool asset::set_currency(const std::string& s)
{
  bool rc = true;
  if (s.length() != 3)   //TODO: do a real check if the currency exists
  {
    rc = false;
    error_message = error_message + "<li>Invalid currency ... how did you do that?</li>";
  }
  else  {currency = s;}
  return rc;
}

bool asset::save()
{
  string s;
  if (!exists(asset_id))
  {
    s = "INSERT INTO " + oConfig.tbl_prefix + "_assets (investor, asset_class, description, currency, amount)  ";
    s = s + "value (" + std::to_string(investor) + ", " + std::to_string(asset_class) + ", '" + description + "', ";
    s = s + "'" + currency + "', " + std::to_string(amount) + ");";
  }
  else
  {
   s = "UPDATE " + oConfig.tbl_prefix + "_assets SET asset_class=" + std::to_string(asset_class);
   s = s + ", description='" + description + "', currency='" + currency + "', amount=" + std::to_string(amount);
   s = s + " WHERE asset_id=" + std::to_string(asset_id) + ";";
  }
  if (db.runSQL(s))
  {return true;}
  else
  {
#ifdef DEBUG
cout << s;
#endif
    error_message = error_message + "Sorry, I failed to add/edit the asset :-/";
    return false;
  }
}

bool asset::exists(int aid)
{
  string s;
  bool rc = false;
  s = "SELECT COUNT(*) AS CNT FROM " + oConfig.tbl_prefix + "_assets WHERE asset_id = " + std::to_string(aid) + ";";
  db.res = db.stmt->executeQuery(s);
  while (db.res->next()) {rc = (db.res->getString("CNT") == "1") ? true : false;}
  return rc;
}

bool asset::asset_delete()
{
  string s;
  s = "DELETE FROM " + oConfig.tbl_prefix + "_assets WHERE asset_id=" + std::to_string(asset_id) + ";";
  if (db.runSQL(s))
  {return true;}
  else
  {
#ifdef DEBUG
cout << s;
#endif
    error_message = error_message + "Sorry, I failed to delete the asset :-/";
    return false;
  }
}