#include "parse.h"


Parse::Parse()
{
  Mysql = new MySQL;
  Mysql->host = "10.1.20.62";
  Mysql->user = "secret";
  Mysql->password = "secret";
  Mysql->database = "work";
  Mysql->connect();

  vector< vector<string> > sql_result;
  vector< vector<string> >::iterator iter_ii;
  vector<string>::iterator iter_jj;
  sql_result = Mysql->sql_query("select werknemerid from werknemers");
  int ii = 0;
  int jj = 0;
  vector< int >::iterator it1;
  vector< User* >::iterator it2;
  it1 = users_lookup.begin();
  it2 = users.begin();
  for (ii=0; ii<sql_result.size(); ii++)
  {
    User* tmpuser = new User;
    int number;
    istringstream ss( sql_result[ii][0] );
    ss >> number;
    if (! ss.good())
    {
      it1 = users_lookup.insert ( it1 , number );
      cout << number << endl;
      it2 = users.insert ( it2 , tmpuser );
    }
  }
}

Parse::~Parse()
{
}

int Parse::parse(string data)
{
  int number;
  istringstream ss( data );
  ss >> number;
  if (! ss.good())
  {
    int i = 0;
    for (i = 0; i < users_lookup.size(); i++)
    {
      if (users_lookup[i] == number)
      {
        int busy = -1;
        busy = users[i]->addtime();
        if (busy == 2)
        {
          string starttime;
          string endtime;
          string id;
          stringstream out0;
          stringstream out1;
          stringstream out2;
          User* tmpuser = dynamic_cast<User*>( users[i] );
          out0 << users_lookup[i];
          id = out0.str();
          out1 << tmpuser->starttime;
          starttime = out1.str();
          out2 << tmpuser->endtime;
          endtime = out2.str();
          cout << starttime << endl;
          string sql_string = "insert into uren (werknemer_id, start, end) VALUES ( '";
          sql_string.append( id );
          sql_string.append( "', '" );
          sql_string.append( starttime );
          sql_string.append( "', '" );
          sql_string.append( endtime );
          sql_string.append( "' )" );
          cout << sql_string << endl;
//          const char *sql_char_ary = sql_string.c_str();
          char *sql_char_ary = new char[sql_string.length()+1];
          strcpy ( sql_char_ary, sql_string.c_str() ); // that is correct
          Mysql->connect();
          Mysql->sql_insert(sql_char_ary);
          Mysql->disconnect();
        }
        return busy;
      }
    }
    return -1;
  }
  return -2;
}