--- trunk/FlisServer/FlisServerDlg.cpp	2007/12/01 14:18:33	113
+++ trunk/FlisServer/FlisServerDlg.cpp	2007/12/03 11:46:03	132
@@ -5,6 +5,7 @@
 #include "FlisServer.h"
 #include "FlisServerDlg.h"
 #include <vector>
+#include ".\flisserverdlg.h"
 
 #ifdef _DEBUG
 #define new DEBUG_NEW
@@ -64,9 +65,9 @@
 	ON_WM_QUERYDRAGICON()
 	ON_MESSAGE(UWM_MYMESSAGE, OnShowString)
 	//}}AFX_MSG_MAP
-	ON_BN_CLICKED(IDC_test, OnBnClickedtest)
 	ON_BN_CLICKED(IDCLOSE, OnBnClickedClose)
 	ON_BN_CLICKED(IDC_GSMPIN, OnBnClickedGsmpin)
+	ON_BN_CLICKED(IDC_Start, OnBnClickedStart)
 END_MESSAGE_MAP()
 
 
@@ -102,15 +103,7 @@
 	// TODO: Add extra initialization here
 	StartSerial();
 	DBConnect();
-	continueThread = 1;
 	ResetSms = 0;
-	/*
-////////////Start Tråd////////////////////////
-	MyThread *t = new MyThread(AfxGetMainWnd());
-	t->start();
-////////////Start Tråd////////////////////////
-*/
-	AfxBeginThread(threadWrapper,AfxGetMainWnd());
 	
 	return TRUE;  // return TRUE  unless you set the focus to a control
 }
@@ -169,11 +162,13 @@
 	CString SerialPort = "COM3";
 
 	Baud = 1200;
-	if( Serial.isOpen() ){
+	if( Serial.isOpen() )
+	{
 		Serial.close();
 		Serial.open( SerialPort, Baud );
 	}
-	else {
+	else 
+	{
 		Serial.open( SerialPort, Baud );
 	}
 
@@ -185,53 +180,13 @@
 	std::vector<unsigned char> buf;
 	while(Serial.getComstat().cbInQue > 0)
 	{
-	unsigned char data = Serial.readByte();
+		unsigned char data = Serial.readByte();
 
-	buf.push_back(data);
+		buf.push_back(data);
 	}
 	return buf;
 }
-void CFlisServerDlg::OnBnClickedtest()
-{
-	// TODO: Add your control notification handler code here
-
-/*	
-///////////////Send sms stuff/////////////////
-	vector<unsigned char> tlfnr;
-	vector<unsigned char> smsdata;
-	tlfnr.push_back('2');
-	tlfnr.push_back('9');
-	tlfnr.push_back('7');
-	tlfnr.push_back('2');
-	tlfnr.push_back('2');
-	tlfnr.push_back('6');
-	tlfnr.push_back('0');
-	tlfnr.push_back('3');
-
-	SendSmsHead(tlfnr);
-
-	 //35:29860132:75 <--- demo pakke;
-	 vector<unsigned char> smsdata;
-	smsdata.push_back('3');
-	smsdata.push_back('5');
-	smsdata.push_back(':');
-	smsdata.push_back('2');
-	smsdata.push_back('9');
-	smsdata.push_back('8');
-	smsdata.push_back('6');
-	smsdata.push_back('0');
-	smsdata.push_back('1');
-	smsdata.push_back('3');
-	smsdata.push_back('2');
-	smsdata.push_back(':');
-	smsdata.push_back('7');
-	smsdata.push_back('5');
-
-	SendSmsData(smsdata);
-///////////////Send sms stuff/////////////////
-*/
 
-}
 void CFlisServerDlg::writeFrame(std::vector<unsigned char> data)
 {
 	for (int i=0; i<data.size(); i++)
@@ -261,28 +216,6 @@
 	data.push_back('5');
 
 	writeFrame(data);
-/*	Sleep(750);
-	if(Serial.getComstat().cbInQue > 0)
-	{
-		std::vector<unsigned char> answer = readFrame();
-		Sleep(50);
-			char array1[25];
-			int i;
-			for (int i=0; i<answer.size(); i++)
-			{
-				array1[i] = answer[i];
-			}
-		
-			for (int i=0; i<answer.size(); i++)
-			{
-				if ((array1[i] != 0x0A) && (array1[i] != 0x0D))
-				{
-					tekst.AppendChar(array1[i]);
-				}
-			}
-			m_Textwindow.SetWindowText(tekst);
-	}
-*/
 }
 void CFlisServerDlg::SendSmsData(std::vector<unsigned char> data)
 {	
@@ -299,7 +232,7 @@
 		CString tekst;
 		std::vector<unsigned char> answer = readFrame();
 		Sleep(50);
-			char array1[25];
+			char array1[150];
 			int i;
 			for (int i=0; i<answer.size(); i++)
 			{
@@ -349,8 +282,8 @@
 void CFlisServerDlg::DBConnect()
 {
 	CString dsn;
-	dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=t-hoerup.dk; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");
-	//dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=192.168.134.132; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");   //skole server
+	//dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=t-hoerup.dk; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");	//Torben
+	dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=192.168.134.132; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");   //skole server
 	db.OpenEx(dsn, CDatabase::noOdbcDialog);
 }
 vector<Commands> CFlisServerDlg::DBRead(void)
@@ -366,17 +299,17 @@
 		rs.MoveFirst();
 		while(!rs.IsEOF())
 		{
-		Commands Mycom;
-		rs.GetFieldValue((short)0, IDnr);
-		rs.GetFieldValue(3, CommandID);
-		rs.GetFieldValue(4, InstallationsID);
-		
-		Mycom.IDnr = IDnr;
-		Mycom.CommandID = CommandID;
-		Mycom.InstallationsID = InstallationsID;
+			Commands Mycom;
+			rs.GetFieldValue((short)0, IDnr);
+			rs.GetFieldValue(3, CommandID);
+			rs.GetFieldValue(4, InstallationsID);
+			
+			Mycom.IDnr = IDnr;
+			Mycom.CommandID = CommandID;
+			Mycom.InstallationsID = InstallationsID;
 
-		buffer.push_back(Mycom);
-		rs.MoveNext();
+			buffer.push_back(Mycom);
+			rs.MoveNext();
 		}
 	}
 	rs.Close();
@@ -437,31 +370,28 @@
 	Flis = Splitter(FyrData);
 	FremFejl = Splitter(FyrData);
 	PowerFail = Splitter(FyrData);
-///////////////////////////////////////////////////////////////////////////////////////////////////////
-///////////////////// Her skal sendes data til databasen //////////////////////////////////////////////
-		m_Textwindow.GetWindowText(oldtekst);
-		oldtekst.Append("\r\n");
-		oldtekst.Append("På næste linie kommer SmsCount. \r\n");
-		oldtekst.Append(SmsCount);
-		oldtekst.Append("\r\n");
-		oldtekst.Append("På næste linie kommer Temper. \r\n");
-		oldtekst.Append(Temper);
-		oldtekst.Append("\r\n");
-		oldtekst.Append("På næste linie kommer Flamme. \r\n");
-		oldtekst.Append(Flamme);
-		oldtekst.Append("\r\n");
-		oldtekst.Append("På næste linie kommer Flis. \r\n");
-		oldtekst.Append(Flis);
-		oldtekst.Append("\r\n");
-		oldtekst.Append("På næste linie kommer FremFejl. \r\n");
-		oldtekst.Append(FremFejl);
-		oldtekst.Append("\r\n");
-		oldtekst.Append("På næste linie kommer PowerFail. \r\n");
-		oldtekst.Append(PowerFail);
-		oldtekst.Append("\r\n");
-		oldtekst.Append("På næste linie kommer TlfNR. \r\n");
-		oldtekst.Append(TlfNr);
-		m_Textwindow.SetWindowText(oldtekst);
+		
+		CString SQL, Textwindow, InstallNR;
+		SQL.Format("select ID from installation where installationphonenr=%s",TlfNr);
+	
+		CRecordset rs(&db);
+		rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
+		if (rs.GetRecordCount()>0)
+		{
+			rs.MoveFirst();		
+			rs.GetFieldValue((short)0,InstallNR);
+		}
+		rs.Close();
+
+		SQL.Format("insert into logtable (logtime,temperature,flamedetector,solidfuelempty,conveyorerror,powerfailure,messagenr,installationnr) Values (now(),%s,'%s','%s','%s','%s',%s,%s)",Temper, Flamme, Flis, FremFejl, PowerFail, SmsCount,InstallNR);
+		db.ExecuteSQL(SQL);
+
+		m_Textwindow.GetWindowText(Textwindow);
+		Textwindow.Append("\r\n");
+		Textwindow.Append("Sms added to Log");
+		m_Textwindow.SetWindowText(Textwindow);
+		Sleep(150);
+
 ///////////////////////////////////////////////////////////////////////////////////////////////////////
 ///////////////////// Her skal sendes data til databasen //////////////////////////////////////////////
 }
@@ -481,7 +411,7 @@
 {
 	// TODO: Add your control notification handler code here
 	continueThread = 0;
-	DeleteSms();   //<--- crasher, men gider ikke bruge flere af mine penge på at teste det med sms'er, hele close laver crash, bare ikke når jeg stepper. :S
+	DeleteSms();
 
 	Sleep(500);
 	if( Serial.isOpen() )
@@ -491,7 +421,7 @@
 	
 	if(db.IsOpen())
 	{
-	db.Close();
+		db.Close();
 	}
 	
 	OnOK();
@@ -501,8 +431,17 @@
 void CFlisServerDlg::OnBnClickedGsmpin()
 {
 	// TODO: Add your control notification handler code here
+	m_Textwindow.SetWindowText("Indsætter Pinkode, efterfuldt af 60sec pause");
+	UpdateWindow();
 	SetPin();
-	//Sleep(5000);
+	Sleep(50000);
+
+	while (Serial.getComstat().cbInQue > 0)
+	{
+		Serial.readByte(); //Flush the incoming queue
+	}
+
+	OnBnClickedStart();
 }
 void CFlisServerDlg::DeleteSms()
 {
@@ -629,14 +568,17 @@
 						{
 							data.push_back(smscount[i]);
 						}
+						m_Textwindow.GetWindowText(oldteskst);
+						oldteskst.Append("\r\n");
 						for (int i=0; i<data.size();i++)
 						{
-						oldteskst.AppendChar(data[i]);
+							oldteskst.AppendChar(data[i]);
 						}
 						m_Textwindow.SetWindowText(oldteskst);
 						writeFrame(data);
 						Sleep(200);
 						ReadSms();
+						ResetSms++;
 
 				}
 				else if(command = "wind")
@@ -648,17 +590,31 @@
 					m_Textwindow.SetWindowText(oldtekst);
 				}
 			}
-			if(ResetSms == 50)
+			else
+			{
+				m_Textwindow.GetWindowText(oldtekst);
+				oldtekst.Append("\r\n");
+				oldtekst.Append("Anden tekst end forventet");
+				oldtekst.Append("\r\n");
+				oldtekst.Append(tekst);
+				m_Textwindow.SetWindowText(oldtekst);
+			}
+			if(ResetSms == 20)
 			{
 				DeleteSms();
+				m_Textwindow.GetWindowText(oldtekst);
+				oldtekst.Append("\r\n");
+				oldtekst.Append("Slettet Sendte og læste beskeder da vi nåede grænsen.");
+				m_Textwindow.SetWindowText(oldtekst);
 			}
 
 		}
 		if (continueThread = 1)
 		{
 			
-			////////////////DBRead stuff//////////////////
-			CString testdata, dataframe,testprint, sIDnr, sCommandID, sInstallationsID;
+			CString testdata, dataframe,testprint, sIDnr, sCommandID, sInstallationsID, sImei;
+			int commandtest = 0;
+			int iAll = 1;
 			std::vector<Commands> data;
 			data = DBRead();
 			for (int i=0; i<data.size(); i++)
@@ -667,84 +623,119 @@
 				testdata.Append(":");
 				testdata.Append(data[i].CommandID);
 				testdata.Append(":");
-				testdata.Append(data[i].InstallationsID);
-				testdata.Append(":");
+				commandtest = atoi(data[i].CommandID);
+
+				if(commandtest > 1)
+				{
+					testdata.Append(data[i].InstallationsID);
+					testdata.Append(":");
+				}
 			}
 			sIDnr = Splitter(testdata);
 			sCommandID = Splitter(testdata);
-			sInstallationsID = Splitter(testdata);
+			sInstallationsID = "0";
+			if (commandtest > 1)
+			{
+				sInstallationsID = Splitter(testdata);
+				iAll = 0;
+			}
 
-			testprint.Append("sIDnr på næste linie\r\n");
-			testprint.Append(sIDnr);
-			testprint.Append("\r\n");
-			testprint.Append("sCommandID på næste linie\r\n");
-			testprint.Append(sCommandID);
-			testprint.Append("\r\n");
-			testprint.Append("sInstallationsID på næste linie\r\n");
-			testprint.Append(sInstallationsID);
-			m_Textwindow.SetWindowText(testprint);
-			
-			
 			if (sIDnr.GetLength() > 0)
 			{
 				DBReadData(sIDnr,sCommandID,sInstallationsID);
 			}
 			Sleep(500);
-			////////////////DBRead stuff//////////////////	
 		}
 }
 void CFlisServerDlg::DBReadData(CString IDnr,CString CommandID,CString InstallationsID)
 {
-	CString TlfNr;
+	CString ServerTlfNr;
+	int i = 0;
+	ServerTlfNr = "29860132";
 		
-	//kald dbreadphone som du kalder dbread
+	
 	std::vector<Installation> inst;
 	inst = DBReadPhone(InstallationsID);
-	for (int i=0; i<inst.size(); i++)
+	while (i < inst.size())
 	{
+		CString TlfNr, Imei, updaterate;
+		TlfNr.Empty();
+		Imei.Empty();
+		updaterate.Empty();
+
 		CString dataen = inst[i].InstPhoneNr;
 		TlfNr.Append(dataen);
-	}
+		CString Imeidata = inst[i].Imei;
+		Imei.Append(Imeidata);
+		CString updaterat = inst[i].Updaterate;
+		updaterate.Append(updaterat);
+		i++;
+	
 	vector<unsigned char> tlfnr;
 	for (int i=0; i<TlfNr.GetLength(); i++)
 	{
 		tlfnr.push_back(TlfNr[i]);
 	}
+	
+	int calcimei; 
+	__int64 buf;
 
+	buf = atof(Imei);
+	
+	calcimei = tversum(buf);
+	
+	Imei.Format("%d",calcimei);
+	
 	SendSmsHead(tlfnr);
-	Sleep(500);
-	//35:29860132:75 <--- demo pakke;
+	Sleep(250);
+	
 	vector<unsigned char> smsdata;
-	smsdata.push_back('3');
-	smsdata.push_back('5');
+	
+	for (int i=0; i<Imei.GetLength(); i++)
+	{
+		smsdata.push_back(Imei[i]);
+	}
 	smsdata.push_back(':');
-	smsdata.push_back('2');
-	smsdata.push_back('9');
-	smsdata.push_back('8');
-	smsdata.push_back('6');
-	smsdata.push_back('0');
-	smsdata.push_back('1');
-	smsdata.push_back('3');
-	smsdata.push_back('2');
+	for (int i=0; i<ServerTlfNr.GetLength(); i++)
+	{
+		smsdata.push_back(ServerTlfNr[i]);
+	}
 	smsdata.push_back(':');
-	smsdata.push_back('7');
-	smsdata.push_back('5');
+	for (int i=0; i<updaterate.GetLength(); i++)
+	{
+		smsdata.push_back(updaterate[i]);
+	}
 
 	SendSmsData(smsdata);
-	Sleep(250);
-
-	CString SQL;
+	Sleep(500);
+	
+	}
+		CString SQL, Textwindow;
+		SQL.Format("update command set executed=now() where id=%s",IDnr);
+		db.ExecuteSQL(SQL);
+		m_Textwindow.GetWindowText(Textwindow);
+		Textwindow.Append("\r\n");
+		Textwindow.Append("Command executed");
+		m_Textwindow.SetWindowText(Textwindow);
+		Sleep(150);
 
-	SQL.Format("update command set executed=now() where id=%s",IDnr);
-	db.ExecuteSQL(SQL);
-	Sleep(150);
 }
 vector<Installation> CFlisServerDlg::DBReadPhone(CString sInstallationsID)
 {
 	vector<Installation> buffer;
 
-	CString SQL, phonenr;
-	SQL.Format("select installationphonenr from installation WHERE id = %s",sInstallationsID);
+	CString SQL, phonenr, imei, updaterate;
+	int installernull;
+	Installation Myinst;
+	installernull = atoi(sInstallationsID);
+	if (installernull > 1)
+	{
+		SQL.Format("select installationphonenr, imei, updaterate from installation WHERE id = %s", sInstallationsID);
+	}
+	else if(installernull < 2)
+	{
+		SQL.Format("select installationphonenr, imei, updaterate from installation");
+	}
 	CRecordset rs(&db);
 	rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
 	if (rs.GetRecordCount()>0) 
@@ -752,15 +743,37 @@
 		rs.MoveFirst();
 		while(!rs.IsEOF())
 		{
-		Installation Myinst;
-		rs.GetFieldValue((short)0,phonenr);
-
-		Myinst.InstPhoneNr.Append(phonenr);
+		
+			rs.GetFieldValue((short)0,phonenr);
+			rs.GetFieldValue(1,imei);
+			rs.GetFieldValue(2,updaterate);
+
+			Myinst.InstPhoneNr = phonenr;
+			Myinst.Imei = imei;
+			Myinst.Updaterate = updaterate;
 
-		buffer.push_back(Myinst);
-		rs.MoveNext();
+			buffer.push_back(Myinst);
+			rs.MoveNext();
 		}
 	}
 	rs.Close();
 	return buffer;
-}
\ No newline at end of file
+}
+int CFlisServerDlg::tversum(__int64 input)
+{
+	int sum = 0;
+	while (input > 0)
+	{
+		sum += (input %10);
+		input /= 10;
+	}
+	return sum;
+}
+void CFlisServerDlg::OnBnClickedStart()
+{
+// TODO: Add your control notification handler code here
+
+	continueThread = 1;
+	m_Textwindow.SetWindowText("Started");
+	AfxBeginThread(threadWrapper,AfxGetMainWnd());
+}