bona.class.cpp

Go to the documentation of this file.

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

class bona
{
public:
  std::map<int, column> tbl;
  string tbl_name = oConfig.tbl_prefix + "_assets";
  string class_name = "";     // eg. goal, cash flow, investment
  string action_ref;          // eg. g, c, i
  void list (int iid, bool editable = true);
  bool save();
  void show(bool editable = true);
  void show_edit_form(int iid, bool showExisting = false);
  bool delete_bona();
  bool exists ();
  bool load_fromEnv();
  bool load_fromDB();
  std::map<string, int> defList;  
protected:
    string order_by = ""; 
private:
  bool verify();
  void load_fromRecordSet();
  void show_th(bool editable);
  void show_tc();
  string s_get(string lbl);
  float  f_get(string lbl);
  int    i_get(string lbl);
  struct tm  d_get(string lbl);
};

/**********************************************
 *       load
 * loads the bona from the database if the key is set
 * ****************************************** */
bool bona::load_fromDB()
{
  bool rc = false;
  string s = "";
  s = "SELECT * FROM `" + tbl_name + "` WHERE " + tbl[1].column_name + "  = " + tbl[1].quote()  + tbl[1].get_sValue() + tbl[1].quote() + ";";
  db.res = db.stmt->executeQuery(s);
  while (db.res->next())
  {
    load_fromRecordSet();
  }
 return rc;
}

/**********************************************
 *   load_fromRecordSet
 * ****************************************** */
void bona::load_fromRecordSet()
{
   for (std::map<int, column>::iterator it=tbl.begin(); it!=tbl.end(); ++it)
    {
      it->second.set_value(db.res->getString(it->second.column_name));
    }
}

/**********************************************
 *   show_th  == table header
 * ****************************************** */
void bona::show_th(bool editable)
{
  cout << "<table class=\"table table-hover " + class_name + "\">\n";
  // the table header
  cout << "<thead><tr>";
  for (std::map<int, column>::iterator it=tbl.begin(); it!=tbl.end(); ++it) 
  {
   if (it->second.input_type != "hidden")
   {
    if (it->second.show_with_previous)
      { cout << "<br>";}
      else
      { cout << "<th>";}
    cout <<  it->second.label;
    std::map<int, column>::iterator it_2 = it;
    if (it!=tbl.end()) it_2++;
    if (it==tbl.end() || !(it_2->second.show_with_previous))
       { 
     cout << "</th>";
       }  
//    cout << "<th>" << it->second.label << "</th>";
   }
  }
  if (editable) cout << "<th>Actions</th>";
  cout << "</tr></thead><tbody>\n";
} 
/**********************************************
 *   show_tc  == table close
 * ****************************************** */
void bona::show_tc()
{
  cout << "</tbody></table>\n";
}

/**********************************************
 *   show_edit
 * ****************************************** */
void bona::show_edit_form(int iid, bool showExisting)
{
  std::map<int, column>::iterator it;
  cout << "<span id=\"is" << this->class_name << "\"></span>";
  cout << "<form method=\"post\" action=\"" + oConfig.soft_url + "?a=" + action_ref + "s\">";
  show_th(true);  //of course editable ;-)
  // the input form
  cout << "<tr>";
  for (it=tbl.begin(); it!=tbl.end(); ++it)
  {
    if (it->second.show_with_previous)
      { cout << "<br>";}
      else
      { if (it->second.input_type != "hidden") cout << "<td>";}
    it->second.show_inputField(iid, showExisting);
    std::map<int, column>::iterator it_2 = it;
    if (it!=tbl.end()) it_2++;
    if (it==tbl.end() || !(it_2->second.show_with_previous))
       { 
     if (it->second.input_type != "hidden") cout << "</td>";
       }
  }
  switch (oConfig.layout)
    {
      case '1' :
         cout << "<td><button type=\"submit\" value=\"Submit\"><img src=\"" << oConfig.css_dir << "check.svg\" alt=\"add\" width=\"16\" alt=\"Save\"></button>";
     cout << "<a href=\"" + oConfig.soft_url + "?a="  <<  action_ref << "l&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="  <<  action_ref << "l&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\" alt=\"Save\"></button>";
     cout << "<a href=\"" + oConfig.soft_url + "?a="  <<  action_ref << "l&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>\n";
  show_tc();
  cout << "</form>";
}



void bona::list(int iid, bool editable)
{
  std::map<int, column>::iterator it;
 
  cout << "<span id=\"is" << this->class_name << "\"></span>";

  if (class_name != "")
  {
    cout << "<div class=\"alert alert-info\">";
    cout << "<p>" << t_before_list[this->class_name] << "</p>";
    cout << "</div>\n";
  }
  
  if (editable) cout << "<form method=\"post\" action=\"" + oConfig.soft_url + "?a=" + action_ref + "a\">";
  show_th(editable);

  // the list of existing bonas
  string s = "";
  s = "SELECT * FROM " + tbl_name + " WHERE investor = " + to_string(iid);
  if (this->order_by != "") s = s + " ORDER BY " + this->order_by;
  s = s + ";";
  db.res = db.stmt->executeQuery(s);
  while (db.res->next())
  {
    load_fromRecordSet();
    show(true);  // includes <tr> tags
  }

  // the input form
  if (editable)
  {
    cout << "<tr>";
    for (it=tbl.begin(); it!=tbl.end(); ++it)
    {
    if (it->second.input_type != "hidden")
      {

      if (it->second.show_with_previous)
        { cout << "<br>";}
        else
        { cout << "<td>";}
      it->second.show_inputField(iid, false);
      std::map<int, column>::iterator it_2 = it;
      if (it!=tbl.end()) it_2++;
      if (it==tbl.end() || !(it_2->second.show_with_previous))
       { 
     cout << "</td>";
       }
      }
    }
    cout << "<td>";
    switch (oConfig.layout)
    {
      case '1' :
        cout << "<button type=\"submit\" value=\"Submit\"><img src=\"" << oConfig.css_dir << "plus.svg\" alt=\"add\" width=\"16\" height=\"16\" alt=\"Save\"></button>";
        cout << "<button type=\"reset\"><img src=\"" << oConfig.css_dir << "undo.svg\" alt=\"Reset!\" width=\"16\" height=\"16\"></button></td>" ;
    break;
      case '2' :
        cout << "<button type=\"submit\" value=\"Submit\" data-toggle=\"tooltip\" title=\"" << t_save << "\"><span class=\"glyphicon glyphicon-ok\" style=\"color:green\"></span></button>";
        cout << "<button type=\"reset\" data-toggle=\"tooltip\" title=\"" << t_reset << "\"><span class=\"glyphicon glyphicon-chevron-left\"  style=\"color:blue\"></span></button></td>" ;
    break;
      default :
        cout << "<button type=\"submit\" value=\"Submit\"><img src=\"" << oConfig.css_dir << "plus.svg\" alt=\"add\" width=\"16\" height=\"16\" alt=\"Save\"></button>";
        cout << "<button type=\"reset\"><img src=\"" << oConfig.css_dir << "undo.svg\" alt=\"Reset!\" width=\"16\" height=\"16\"></button></td>" ;
    break;
    }
    cout << "</tr>\n";
  }
  show_tc();
  cout << "<input name=\"iid\" type=\"hidden\" value=\"" << to_string(iid) << "\">";
  cout << "</form>";
}

/******************************************
 * show
 * ****************************************/
void bona::show(bool editable)
{
  cout << "<tr>";
  for (std::map<int, column>::iterator it=tbl.begin(); it!=tbl.end(); ++it)
  {
    if (it->second.input_type != "hidden")
    {
    if (it->second.show_with_previous)
      { cout << "<br>";}
      else
      { cout << "<td>";}
    it->second.show();  
    std::map<int, column>::iterator it_2 = it;
    if (it!=tbl.end()) it_2++;
    if (it==tbl.end() || !(it_2->second.show_with_previous))
       { 
     cout << "</td>";
       }    
    }
  }
  if (editable)
  {
    switch (oConfig.layout)
    {
      case '1' :
        cout << "<td><a href=\"" + oConfig.soft_url + "?a=" + action_ref + "e&amp;" + action_ref + "id=" + tbl[1].get_sValue() + "\"><img src=\"" << oConfig.css_dir << "pen.svg\" width=\"16\" height=\"16\" ></a>&nbsp;<a href=\"" + oConfig.soft_url + "?a=" + action_ref + "d&amp;" + action_ref + "id=" + tbl[1].get_sValue() + "\"><img src=\"" << oConfig.css_dir << "x.svg\" width=\"16\" height=\"16\" ></a></td>";
    break;
      case '2' :
        cout << "<td><a class=\"btn btn-default\" href=\"" + oConfig.soft_url + "?a=" + action_ref + "e&amp;" + action_ref + "id=" + tbl[1].get_sValue() + "\" data-toggle=\"tooltip\" title=\"" << t_edit << "\"><span class=\"glyphicon glyphicon-pencil\" style=\"color:blue\"></span></a>&nbsp;";
    cout << "<a href=\"" + oConfig.soft_url + "?a=" + action_ref + "d&amp;" + action_ref + "id=" + tbl[1].get_sValue() + "\"  data-toggle=\"tooltip\" title=\"" << t_delete << "\"><span class=\"glyphicon glyphicon-remove\"  style=\"color:red\"></span></a></td>";
    break;
      default :
        cout << "<td><a href=\"" + oConfig.soft_url + "?a=" + action_ref + "e&amp;" + action_ref + "id=" + tbl[1].get_sValue() + "\"><img src=\"" << oConfig.css_dir << "pen.svg\" width=\"16\" height=\"16\" ></a>&nbsp;<a href=\"" + oConfig.soft_url + "?a=" + action_ref + "d&amp;" + action_ref + "id=" + tbl[1].get_sValue() + "\"><img src=\"" << oConfig.css_dir << "x.svg\" width=\"16\" height=\"16\" ></a></td>";
    break;
    } 
  }
  cout << "</tr>\n";
}

/******************************************
 * save
 * ****************************************/
bool bona::save()
{
  std::map<int, column>::iterator it;
  string s;
  if (exists())
  {
   s = "UPDATE `" + tbl_name + "` SET ";
   for (it=tbl.begin(); it!=tbl.end(); ++it)
    {
      s = s + it->second.column_name + " = " + it->second.quote() + it->second.get_sValue() + it->second.quote();
      if (++it!=tbl.end()) {s = s + ",";}
      --it;
    }
   s = s + " WHERE " + tbl[1].column_name + "=" + tbl[1].quote() + tbl[1].get_sValue() + tbl[1].quote() + ";";
  }
  else
    {
    s = "INSERT INTO `" + tbl_name + "` (";
    for (it=tbl.begin(); it!=tbl.end(); ++it)
      {
      if (it->second.get_sValue().length() > 0)
      {
    s = s + it->second.column_name;
        if (++it!=tbl.end()) {s = s + ",";}
        it--;
      }
      }
    s = s + ") value (" ;
    for (it=tbl.begin(); it!=tbl.end(); ++it)
    {
      if (it->second.get_sValue().length() > 0)
      {
    s = s + it->second.quote() + it->second.get_sValue() + it->second.quote();
        if (++it!=tbl.end()) {s = s + ",";}
        it--;
      }
    }
    s = s + ");";
  }
  #ifdef DEBUG
debug_info = debug_info + "<br>goal.save: " + s;
#endif

  if (db.runSQL(s))
  {return true;}
  else
  {
#ifdef DEBUG
debug_info = debug_info + "<br>" + s;
#endif
    error_message = error_message + "Sorry, I failed to add the " + class_name + "to the database.";
    return false;
  }
return true;

}

/******************************************
 * load_fromEnv
 * ****************************************/
bool bona::load_fromEnv()
{
 for (std::map<int, column>::iterator it=tbl.begin(); it!=tbl.end(); ++it)
 {
//   cout << it->second.post_code << "<BR>";
   it->second.set_value(cgi(it->second.post_code));
//   debug_info = debug_info + "<br>" + it->second.get_sValue();
 }
 if (verify()) {return true;} else {return false;}
}

/**********************************************
 *       delete_bona
 * ****************************************** */
bool bona::delete_bona()
{
  string s = "";
  s = "DELETE FROM `" + tbl_name + "` WHERE " + tbl[1].column_name + "  = " + tbl[1].quote()  + tbl[1].get_sValue() + tbl[1].quote() + ";";
  if (db.runSQL(s))
    {return true;}
    else
    {
#ifdef DEBUG
  cout << s;
#endif
      error_message = error_message + "Sorry, I failed to delete the goal :-/";
      return false;
    }
}

/******************************************
 * verify
 * ****************************************/
bool bona::verify()
{
  bool rc = true;
 for (std::map<int, column>::iterator it=tbl.begin(); it!=tbl.end(); ++it)
 {
 //  if (tbl[1].get_iValue() > 0)  {rc = true;} else {rc = false;}
 }
 return rc;
}

/************************
 * exits
 *************************/
bool bona::exists()
 {
   string s, q;
   q = tbl[1].quote();
   bool rc = false;
   s = "SELECT COUNT(*) AS CNT FROM `" + tbl_name + "` WHERE " + tbl[1].column_name + "  = " + tbl[1].quote()  + tbl[1].get_sValue() + tbl[1].quote() + ";";
#ifdef DEBUG
debug_info = debug_info + "<br>bona.exists(): " + s;
debug_info = debug_info + "<BR>to_string(tbl[1].get_iValue()): " + to_string(tbl[1].get_iValue()) + "<br>";
#endif
   if (tbl[1].get_iValue() != 0)
   {
   db.res = db.stmt->executeQuery(s);
   while (db.res->next()) {rc = (db.res->getString("CNT") == "1") ? true : false;}
     return rc;
   }
   else
   {return false;}
 } //exists


/* **************************************************
 * functions to accesss members via their label (such as description)
 * **************************************************
 * usage: descr = theBona.s_get('description');
 */
string bona::s_get(string lbl)  {return tbl[defList[lbl]].get_sValue();}
float  bona::f_get(string lbl)  {return tbl[defList[lbl]].get_fValue();}
int    bona::i_get(string lbl)  {return tbl[defList[lbl]].get_iValue();}
struct tm  bona::d_get(string lbl)  {return tbl[defList[lbl]].get_dValue();}