-----------------------------------------------------------
mysql.h
-----------------------------------------------------------
#ifndef MYSQL_H
#define MYSQL_H

#include <mysql++.h>
using namespace mysqlpp;

class Database
{
public:
	Result executeSQL (char* host, char* dtbse, char* usern, char* passwd, char* stmnt);
};

Result Database::executeSQL (char* host, char* dtbse, char* usern, char* passwd, char* stmnt)
{
	Connection connection (use_exceptions);
	connection.connect("", host, usern, passwd);
	connection.select_db(dtbse);
	Query qr = connection.query();
	qr << stmnt;
	return qr.store();
}


#endif

-----------------------------------------------------------
-----------------------------------------------------------
texnologia.cpp
-----------------------------------------------------------
#ifdef HAVE_CONFIG_H
#include <config.h>
#endif

#include <iostream>
#include <cstdlib>
#include <time.h>
#include "mysql.h"

//Epistrefei tin diefthinsi apo arrays pelatwn kai ypalilwn (kai texnikwn se sunexia)
void *adressbook(int i); //declaration panw apo to include gt xrisimopoieitai i sunartisi mesa se mia methodo
#include "texnologia.h"

void emulateerror(pelaths *);	//dinei se random xrono se random pelati ena random error
void emulatecust(pelaths *);	//kalei se olous tous pelates tin act method
void initpelates(pelaths *);	//Arxikopoiei tis times me kapoies realistikes times

using namespace std;

void *adb[2]; //krataei tis diefthinseis tou adressbook

int main(int argc, char *argv[])
{
	pelaths  customers[CUST_NO]; 
	ypalilos ypal[EMPL_NO];
	adb[0] = customers;	//init ta global pointers pou kratan tis 
	adb[1] = ypal;		//diefthinseis ap ta arrays

	initpelates(customers);

	for (;;)
	{
		emulateerror(customers); //Ena error
		emulatecust(customers);  //act oloi oi pelates
	}
	return EXIT_SUCCESS;
}

//epistrefei tin diefthinsi apo 0:pelates 1:ypalilous
void *adressbook(int i){
	return adb[i];
}

void emulateerror(pelaths customers[CUST_NO])
{
	time_t	t1,t2;
	int	i, tmp;

	srand(time(0));
	(void)time(&t1); //pernoume tin wra
	tmp = rand()%10; //se posa sec tha parei o pelaths (ews 10)
	for ((void)time(&t2); (int) t2-t1 < tmp; (void)time(&t2)); //perimenoume na ftasei o xronos
	//eftase i ora gia ena error
	tmp = rand()%(CUST_NO-1); //dialegoume random customer 
	i   = rand()%3+1; //dialegoume random error - excluding NOERROR 
	customers[tmp].haveerror = (errortype)i; //topo8etoume to provlima ston pelati
}

void emulatecust(pelaths customers[CUST_NO])
{
	int i;
	for (i=0; i < CUST_NO; i++)
		customers[i].act();
}

//Einai statiko vazei stixeia stis protes 10 theseis
void initpelates(pelaths customers[CUST_NO])
{
	if (CUST_NO != 10) return; //Einai mono gia 10 pelates
	
	customers++->set_attr("Giorgos Palaiologos",	2108192648);
	customers++->set_attr("Kostas Manolopoulos",	2105656482);
	customers++->set_attr("Feh Mavragani",		2105555554);
	customers++->set_attr("Vlasis Mponatsos",	2101000001);
	customers++->set_attr("Grigoris Mpithikotsis",	2105468495);
	customers++->set_attr("Dimosthenis Liakopoulos",2310521010);
	customers++->set_attr("Aleka Papariga",		2104234895);
	customers++->set_attr("Vasilis Leventis)",	2107989584);
	customers++->set_attr("Solomos Solomou",	2103216549);
	customers++->set_attr("Tassos Isaak",		2109876543);
	return;
}

-----------------------------------------------------------
-----------------------------------------------------------
texnologia.h
-----------------------------------------------------------
#ifndef TEXNOLOGIA_H
#define TEXNOLOGIA_H
#define CUST_NO 10
#define EMPL_NO 1

#include <string.h>
#include "mysql.h"

extern void *adressbook(int);

using namespace std;
//Typos/kathgoria provlimatos
enum errortype { NOERROR = 0, PSTN = 1, ISDN = 2, ADSL = 3, INTERNET = 4};
//Structure pou krataei ena record gia tin vasi dedomenwn
typedef struct{
	int	  id;
	string 	  onoma;
	unsigned  long long tel;
	errortype category;
	bool	  condition;
}record;

class ypalilos; //declaration
class pelaths;	//declaration

class pelaths
{
public:
	//Constructors/Destructor
	pelaths():haveerror((errortype)0), reported(0), found(NULL){}
	pelaths(string on, unsigned long long til):
		haveerror((errortype)0), 
		reported(0), onoma(on),
		phone_num(til),found(NULL){}
	~pelaths(){}

	//public methodoi
	void	  act();				//Kanei ton pelati na drasei, elegxei an exei provlima
	string	  get_onoma()const{return onoma;}	//epistrefei to onoma tou pelati
	errortype get_error()const{return haveerror;}	//epistrefei ton typo toy provlimatos
	void	  set_attr(string on, unsigned long long til)//Orizei onoma k til
			{onoma = on; phone_num = til;}

	//public idiotites
	unsigned long long phone_num;	//arithmos tilefonou pelath	
	errortype 	   haveerror;	//typos problimatos (0=NOERROR)
private://private methodoi
	bool 	  findhelp(); 		//psaxnei gia diathesimo upalilo kai ton kalei
	void 	  talk(); 		//kanei tin sinomilia

	//private idiotites
	int	  reported;		//an exei dilothei i vlavi exei to ID
	string 	  onoma;		//onoma pelath
	ypalilos* found;		//pointer ston upalilo pou vrethike gia eksipiretisi
};

class ypalilos
{
/* ypothetoume oti leitourgei enas kai mono ypalilos, tou opoiou to interface tha fenetai 
 * tha fenetai  stin othoni. Gia skopous realismou, i efthini tis ilopoiisis twn diadikasiwn
 * afinetai ston xristi tou programmatos. Autos einai ypefthinos na kanei tis diadikasies,
 * aftos einai ipefthinos na pei An epidiorthothike i vlavi i oxi (aneksartita apo to an
 * ontws epidiorthothike). O pelaths tha vasizete stis apantiseis tou upalilou gia to
 * an i vlavi tou epidiorthothike i graftike stin vasi.
 * O upalilos tha exei diathesimes energies MONO otan ton "paroun tilefono". */
public:
	//Constructor/Destructor
	ypalilos();
	~ypalilos(){}

	int	answer(pelaths*,int); 		//H "main" tou ypaliliou
	bool	getcond()const{return busy;}	//Katastasi upalilou (busy i oxi)

private://Private methodoi (diaxirisi vasis, ginete mono ap ton upalilo)
	int	db_add();	//giving data to database
	void	db_del(int){cout << "del db" <<endl;}	//delete data with ID TODO
	void	db_rea(int);	//read record with ID, 0 shows all
	void	db_cha(int){cout << "cha db" <<endl;}	//change record with ID TODO
	char	menu(int);	//Rwtaei ti na kanei 
	void	initrec();	//Midenizei to record se kathe telos klisis

	bool 	busy;	//Katastasi ipalilou
	record	data;	//Temp record gia diaxeirisi
};
/*-----------------------------------------------------------------*/
/*H act() gia enan pelati tha elegxei an yparxei provlima. An yparxei
 *proxoraei stin anazitisi diathesimou upalilou apo to adressbook.
 *An vrei diathesimo ipalilo, kalei tin sinartisi gia epikinwnia mazi tou
 *Apo tin klisi afti, se kathe arnitiki apantisi (eite den apantise, eite
 *den eksipiretithike) den epireazei tipota. Diaforetika, analogws ti 
 *"erwtisi" ekane, epireazei analogws */
void	pelaths::act()
{
	if (haveerror == 0) return; //No error, no actions
			//Yparxei provlima
			//Psaxnoume upalilo gia voithia kai ton kaloume
	if (findhelp()) //An vrethei diathesimos ipalilos
		talk(); //ton kaloume
			//an den vrethike, den kanoume kati
	found == NULL;  //teliosame, den exoume ipalilo diathesimo
	return;
}

/*H findhelp() gia enan pelati, anazitei apo to adressbook (pou dilonetai
 *sto kiriws source) gia kapoion diathesimo upalilo. An vrei, apothikevei
 *tin diefthinsi tou sto pointer found kai epistrefei true, allios false */
bool	pelaths::findhelp()
{
	ypalilos *tmp = (ypalilos*)adressbook(1); //Zitame to array twn ypalilwn (1)
	for (int i = 0; i < EMPL_NO; i++){
		if (tmp[i].getcond() == 0){ //Psaxnoume gia busy==0
			found = &tmp[i]; //Diefthinsi tou upalilou pou vrethike diathesimos
			return 1;
		}
	}
	return 0;
}

/*H talk() gia enan pelati, ylopoiei tin "epikinwnia" metaksi pelati kai ypalilou.
 *Analoga tin katastasi twn idiotitwn, kalei me sigkekrimeno thema gia eksipiretisi
 *1:dilosi vlavis, kai 2: erwtisi gia to pws paei i vlavi an epidiorthothike
 *Simiosi: Oso yparxei vlavi o pelatis tha pernei se kathe act(), gia na dilonei 
 *h na elegxei tin katastasi */
void pelaths::talk()
{
	int tmp = found->answer(this, reported); //"Klisi" ston upalilo

	//Meta to peras tis klisis...
	if (tmp){ //An eixe "thetiki" apantisi, tote analoga me tin erwtisi ananeonoume
		if (reported){ //an to provlima itan dilomeno, tote to "nai" simene oti epidiorthothike
			haveerror = (errortype)0;
			reported = 0;
			return;
		}
		else{ //an den itan, tote simenei oti dilothike kai to tmp==ID tou aitimatos
			reported = tmp;
			return;
		}
	} //An itan arnitiki apantisi, den epireazetai tipota
	return;
}

//Constructor initialising to NULL
ypalilos::ypalilos():busy(0)
{
	cout << "Line idle ... " <<endl;
	initrec();
}

/*H answer(pelaths*) gia enan ypalilo, einai i kiria diadikasia pou ulopoiei to interface
 *me ton xristi tou programatos kai tin epikinwnia me ton ypalilo. Energopoieitai kata tin
 *klisi ston ypalilo, dinei dinatotites opws mi apantisi, erwtiseis ston ypalilo, diaxeirisi
 *tis vasis ktl. Analoga to erwtima, i apantisi simenei:
 *1: se dilosi vlavis- Oti i vlavi dilothike kai i apantisi dinei ton kodiko tis
 *2: se erwtisi epilisis- I katafatiki apantisi simenei oti epilithike
 *Prosoxi kathws oi apantiseis DEN EKSARTONTAI ap tin pragmatikotita, gi afto prepei na didontai
 *ypefthina kai me prosoxi */
int ypalilos::answer(pelaths *cust,const int id)
{
	char 	rep; 	//Epilogi ipalilou
	int 	ans = 1;//Default katafatiki apantisi
	string	tmp;

	//Ksekinaei to interface - Emfanisi klisis kai stoixeiwn
	cout 	<< "-Pelatis me noumero: " << cust->phone_num << " Kalei, Apantisi?(y/n) :";
	cin 	>> rep;

	if (rep == 'n') //Epilogi na min to sikosoume
	{
		cout << "Connection with Customer " << cust->phone_num << " refused" << endl << "Line idle..." << endl;
		initrec();return 0; //Epistrefete arnitiki apantisi
	}
	busy = 1; 	//An apantisoume, vazoume tin katastasi busy.
			//Se periptosi paralilwn diergasiwn tha eixe noima (leme twra..)

	//Aftomata kratame sto record to tilefono kai to ID(an idi uparxei)
	data.id = id;
	data.tel = cust->phone_num;
	cout << "Connection with Customer " << cust->phone_num << " established" << endl;
	if (id) //An dothike >0 simenei oti o pelatis rwtaei tin katastasi tou aitimatos tou gia ID=id
		cout << "O pelatis rwtaei an h vlavi me kwdiko " << id << " exei epilithei" << endl;
	else //Allios simenei oti den exei dilosei kapoia vlavi kai oti afto paei na kanei..
		cout << "O pelatis thelei na dilwsei nea vlavi" << endl;

	//Efoson deiksame tin erwtisi tou pelati, proxwrame ston rolo tou ypalilou...
	//Deixnoume tis diathesimes energies (mporei na praksei asxeta me to ti thelei o pelatis)
	rep = menu(id);
	while (rep != '0'){
		switch(rep){
		case '1':{//Erwtisi tou onomatos tou kai egrafi sto record
			data.onoma = cust->get_onoma();
			cout << " -" << data.onoma << endl;
			break;}
		case '2':{//Erwtisi provlimatos
			data.category = cust->get_error();
			cout << " -" << data.category << endl;
			break;}
		case '3':{//Eggrafi record stin vasi
			db_add(); //klisi methodou
			break;}
		case '4':{//Diagrafi aitimatos me ID apo tin vasi
			db_del(id);
			break;}
		case '5':{//Anagnosi aitimatos me ID apo tin vasi
			db_rea(id);
			break;}
		case '6':{//Allagi aitimatos me ID apo tin vasi
			db_cha(id);
			break;}
		case '7':{//Ektiposi trexontos record
			cout << "Trexousa kartela\n";
			cout << "--------------------------------------" << endl;
			cout << "Kwdikos:\t" 	<< data.id	 << endl;
			cout << "Onoma:\t\t:" 	<< data.onoma 	 << endl;
			cout << "Tilefono:\t"	<< data.tel 	 << endl;
			cout << "Katigoria:\t"	<< data.category << endl;
			cout << "Katastash:\t"	<< data.condition<< endl;
			cout << "--------------------------------------" << endl;
			break;}
		case '8':{//Katafatiki apantisi ston pelati
			if (id == 0) //An den itan dilomeni vlavi dinoume ton kodiko tis vlavis
			{
				ans == data.id; //reply the ID of record
				cout << "Giving ID to customer :" << ans << ". Is this correct? (y/n) " ;
				cin >> rep; //Teliki epiveveosi
				if (rep == 'n') 
				{
					cout << "Doste nea ID gia ton pelati ";
					cin >> ans;
					while (ans <= 0){
						cout << "Lathos id. Doste nea ID gia ton pelati ";
						cin >> ans;
					}
				}
			}
			cout << "Katafatiki apantisi ston pelati " << ans << endl << "Connection closed.";
			cout << endl << "Line idle ..." << endl;
			initrec();
			return ans;
			break;
			}
		case '9':{//Arnitiki apantisi ston pelati
			cout << "Replying negative to " << cust->phone_num << endl << "Connection closed" << endl << "Line idle..." << endl;
			initrec();return 0;break;
			}
		}
		rep = menu(id); //Show menu with actions
	}
	//Kleisimo tilefonou
	cout << "Connection terminated" << endl << "Line idle..." << endl;
	initrec();return 0;
}

char ypalilos::menu(int id)
{
	//Emfanisi tou menou ston ipalilo
	char tmp;
	cout << "\tTi tha thelate na kanete?" << endl;
	cout << "\t1: Erwtisi onomatos kai simplirosi eggrafis" << endl;
	cout << "\t2: Erwtisi provlimatos kai simplirosi eggrafis" << endl;
	cout << "\t3: Prosthiki eggrafis stin vasi dedomenwn" << endl;
	cout << "\t4: Diagrafi apo vasi dedomenwn (tis eggrafis ID:" << id << ")" << endl;
	cout << "\t5: Anagnosi apo vasi dedomenwn (tis eggrafis ID:" << id << ")" << endl;
	cout << "\t6: Allagi apo vasi dedomenwn (tis eggrafis ID:" << id << ")" << endl;
	cout << "\t7: Emfanisi trexousas eggrafis" << endl;
	cout << "\t8: Thetiki apantisi ston pelati" << endl;
	cout << "\t9: Arnitiki apantisi ston pelati" << endl;
	cout << "\t0: Klisimo tilefonou" << endl;
	cin >> tmp;
	return tmp;
}

void ypalilos::db_rea(int myid)
{/*Emfanizei apo tin vasi, eite ola ta stoixeia eite sigkekrimeno id */
	/*gia na apofigoume ta warnings tha xrisimopoiisoume char* anti gia string
	 *kai kata sinepia sprintf anti gia std::<< */ 
	Database mydb;
	char	 myStatement[200]; 		//To statement gia ton server
	char*	 server = "localhost";	//I diefthinsi tou server, ta vazoume fixed gia efkolia
	char*	 datb	= "texnologia"; //I database pou xrisimopoioume, fixed gia efkolia
	char*	 usr	= "root";	//username, root, fixed gia efkolia (me null pw)
	char* 	 pwd	= "";		//null pw
	Result 	 rs; 			//apotelesmata tou select
	Row 	 rw;			//se grammes
	Result::iterator itr;		//counter

	if (myid) sprintf(myStatement,"select * from problems where id = %d",myid); //An exoume kodiko tiponoume kodiko
	else 	  sprintf(myStatement,"select * from problems"); //Alios ta tiponoume ola

	rs = mydb.executeSQL(server, datb, usr, pwd,myStatement); //Dinoume to query

	//Tuponoume ta apotelesmata mas
	cout << "--------------------------------------" << endl;
	for ( itr = rs.begin(); itr != rs.end() ; itr++ )
	{ 
		rw = *itr;
		cout << "ID:\t\t" 	<< rw["id"] 	<< endl;
		cout << "Onoma:\t\t" 	<< rw["name"] 	<< endl;
		cout << "Phone:\t\t"	<< rw["phone"]	<< endl;
		cout << "Category:\t"	<< rw["cat"]	<< endl;
		cout << "Condition:\t"	<< rw["cond"]	<< endl;
		cout << "--------------------------------------" << endl;
	}
	cout << "Totally, " << rs.size() << " records listed." << endl;
	
	return;
}

int	ypalilos::db_add()
{/*Vriskei neo ID kai kataxorei to record stin vasi */
	Database mydb;
	char	 myStatement[200]; 		
	char*	 server = "localhost";	//I diefthinsi tou server, ta vazoume fixed gia efkolia
	char*	 datb	= "texnologia"; //I database pou xrisimopoioume, fixed gia efkolia
	char*	 usr	= "root";	//username, root, fixed gia efkolia (me null pw)
	char* 	 pwd	= "";		//null pw
	Result 	 rs; 			//apotelesmata tou select
	Row 	 rw;			//se grammes
	Result::iterator itr;		//counter
	int 	 myid;

	//Se periptosi pou ta stoixeia den einai eparkh
	if (data.onoma == "" || data.category == 0) {
		cout << "ERROR: Aneparkeis plirofories gia eggkrafh\n";
		cout << "Veveotheite na zitisete onoma kai provlima prin ksanadokimasete\n";
		return 0;
	}
		
	strncpy(myStatement,"select * from problems",200); //Diavazoume oles tis egrafes
	rs = mydb.executeSQL(server, datb, usr, pwd,myStatement); //Dinoume to query

	//Psaxnoume an idi exei eggrafh
	for ( itr = rs.begin(); itr != rs.end();itr++) { 
		rw = *itr;
		if (strcmp(data.onoma.c_str(),rw["id"]) == 0){ //An exei idi epistrefoume to ID tou
			cout << "ERROR: Customer already has reported an error, We give his error ID\n";
			data.id = atoi(rw["id"].c_str());
			return data.id;
		}
	}	
	//Psaxnoume gia Diathesimo ID
	myid = 1; //apo ena, mexri na vroume keno
	for ( itr = rs.begin(); itr != rs.end();)
	{ 
		rw = *itr;
		if (myid==atoi(rw["id"].c_str())){itr = rs.begin(); myid++;} //an yparxei, afksanoume kai psaxnoume ap tin arxi
		else	itr++; //allios proxorame,an ftasoume sto telos, vgenei ap to loop kai sinexizoume me to ID pou vrikame
	}	

	data.id = myid; //Grafoume stin kartela to ID pou dosame
	sprintf(myStatement,"insert into problems values('%d', '%s','%i','%d','%d')",data.id,data.onoma.c_str(), (int)data.tel , (int)data.category, (int)data.condition); //Grafoume to query
	mydb.executeSQL(server, datb, usr, pwd,myStatement); //Dinoume to query ston server

	return myid; //Epistrefoume to ID (den exei ousia opws einai twra, exei an kanoume optimize to code)
}

void	ypalilos::initrec()
{/* midenizei to record */
	busy = 0;
	data.id = 0;
	data.onoma = "";
	data.tel = 0;
	data.category = NOERROR;
	data.condition = 0;
}
#endif