column.class.cpp

Go to the documentation of this file.

/*
* convention: the first column object is supposed to be the PK
*/
class column
{
public:
  string column_name;         // name used in the database, eg. asset_class, asset_id
  char   col_type;            // i=int, f=float, s=string, d=date
//  bool   show_it = true;    // true if it should be shown to the user
//  bool   is_used = false;   // true if if it is used by the relevant class
  string input_type;          // text, number, checkbox, etc.
                              //  ==> set to "hidden" in order not to show it on the screen
                              //  ==> set to "dropDown" for drop_down box
                              //  ==> set to "date" for date
  string drop_down_table;     // eg. " + oConfig.tbl_prefix + "_asset_classes
  string drop_down_keyField;  // eg. asset_class_id
  string drop_down_keyFieldQuote; // "" or "'"
  string drop_down_showField; // eg. asset_class_name
  string drop_down_default;   // eg. USD
  string label;               // eg. description, amount, etc. (column header)
  string placeholder;         // eg. describe the goal, boss@universe.com
  string post_code;           // eg. desc, amnt, aid, iid, etc. NOTE: also used for the "id" (not only for "name") attributes
  bool   show_with_previous = false; // eg. from_Date, till_Date and frequency to be stacked in one table cell -->
                                     // in that case show_with_previous should be true for the two last
  string data_align = "center";  // data-align = left | right | center

  string quote();
  int    get_iValue();
  string get_sValue();
  float  get_fValue();
  struct tm get_dValue();
  void   set_value(int    value);
  void   set_value(string value);
  void   set_value(float  value);
  void   show_inputField(int iid, bool showExisting = false);   // send the input field to stdout
  void   show();              // send the field value to stdout in a readable form (simply get_sValue or the dop_down_showField of the referenced table)
private:
  int    iValue;
  string sValue;
  float  fValue;
  struct tm dValue;
};

int    column::get_iValue() { return iValue;}
string column::get_sValue() { return sValue;}
float  column::get_fValue() { return fValue;}
struct tm column::get_dValue() { return dValue;}

void column::set_value(int    value) {
  iValue = value;
  sValue = std::to_string(value);
  fValue = value + 0.0;
}
void column::set_value(string value) {
  sValue = value;
  if (col_type == 'd') dateStr2tm(value, &dValue);
  if (col_type != 'd' && col_type != 's')
  {
    iValue = atoi(value.c_str());
    fValue = atof(value.c_str());
  }
}
void column::set_value(float  value) {
  iValue = round(value);
  sValue = to_string(value);
  fValue = value;
  }

 string column::quote() {
   return (col_type == 's' || col_type == 'd') ? "'" : "";
 }

 /* ************************************
  *  show
  * ************************************
  */
void column::show()
{
  if (input_type != "hidden"){
    if ((input_type != "dropDown") || (drop_down_keyField == drop_down_showField))
    {
      if (col_type == 'f') cout << curr_format(get_fValue());
         else cout << get_sValue();
    }
    else
    {
    db.res2 = db.stmt->executeQuery("SELECT " + drop_down_showField + " FROM " + drop_down_table + " WHERE " + drop_down_keyField + " = " +drop_down_keyFieldQuote + get_sValue() + drop_down_keyFieldQuote + ";");
    while (db.res2->next()) cout << db.res2->getString(drop_down_showField);
    }
  }
}

 /* ************************************
  *show_inputField
  * ************************************
  */
 void column::show_inputField(int iid, bool showExisting)
 {
 string input_type_fld;
 if (input_type == "dropDown")
    {
       cout <<  "<select ";
       if (input_type != "hidden") cout << "required ";
       cout << "name=\"" + post_code + "\" id=\"" + post_code + "\">";
       db.res = db.stmt->executeQuery("SELECT " + drop_down_keyField + ", " + drop_down_showField + " FROM " + drop_down_table + ";");
       while (db.res->next())
       {
      cout << "<option value=\"" + db.res->getString(drop_down_keyField) + "\"";
      if (showExisting)
      {
        if (db.res->getString(drop_down_keyField) == get_sValue()) cout << " selected "; 
      }
      else
      {
        if (db.res->getString(drop_down_keyField) == drop_down_default) {cout << " selected "; }
      }
      cout << ">" << db.res->getString(drop_down_showField) + "</option>";
      }
      cout <<  "</select>";
    }
    else
    {
      input_type_fld = (input_type != "date")?input_type:"text\" data-date-format=\"yyyy-mm-dd";
      cout << "<input type=\"" << input_type_fld << "\" name=\"" << post_code << "\" id=\"" << post_code << "\" ";
      if (input_type != "hidden")
      {
    cout << " required ";
        if (col_type == 'i') cout << " size=\"1\" ";
          else if (col_type == 'f') cout << " size=\"5\" ";
          else if (col_type == 'd') cout << " size=\"6\" ";
          else cout << " size=\"12\" ";
      }
      if (post_code == "iid") 
      {
    cout << " value=\"" << to_string(iid) << "\" ";
      }
      else 
      {
    if (showExisting) cout << " value=\"" << get_sValue() << "\" "; 
      }
      cout << " placeholder=\""  << placeholder << "\">\n";
    }
 }

/* *********usage
  tbl[1].column_name = "asset_id";
  tbl[1].set_value(cgi("aid"));
  tbl[1].col_type = 'i';
  tbl[1].show_it = false;
  tbl[1].drop_down = false;

  tbl[2].column_name = "description";
  tbl[2].set_value(cgi("description"));
  tbl[2].col_type = 's';
  tbl[2].show_it = true;
  tbl[2].drop_down = false;

for (tbl::iterator it=tbl.begin(); it!=tbl.end(); ++it)
    std::cout << it->column_name << " => " << it->get_value() << '\n';

for (int i , i < 10, i++)
{cout << i << ": exists:" << exists(i) << "\n";}

return o;
 } //main
 */