6 |
#include "FlisServerDlg.h" |
#include "FlisServerDlg.h" |
7 |
#include <vector> |
#include <vector> |
8 |
#include ".\flisserverdlg.h" |
#include ".\flisserverdlg.h" |
9 |
|
#include <atlrx.h> |
10 |
|
|
11 |
#ifdef _DEBUG |
#ifdef _DEBUG |
12 |
#define new DEBUG_NEW |
#define new DEBUG_NEW |
66 |
ON_WM_QUERYDRAGICON() |
ON_WM_QUERYDRAGICON() |
67 |
//}}AFX_MSG_MAP |
//}}AFX_MSG_MAP |
68 |
ON_BN_CLICKED(IDCLOSE, OnBnClickedClose) |
ON_BN_CLICKED(IDCLOSE, OnBnClickedClose) |
|
ON_BN_CLICKED(IDC_GSMPIN, OnBnClickedGsmpin) |
|
69 |
ON_BN_CLICKED(IDC_Start, OnBnClickedStart) |
ON_BN_CLICKED(IDC_Start, OnBnClickedStart) |
70 |
END_MESSAGE_MAP() |
END_MESSAGE_MAP() |
71 |
|
|
224 |
} |
} |
225 |
void CFlisServerDlg::SetPin() |
void CFlisServerDlg::SetPin() |
226 |
{ |
{ |
227 |
|
bool ready = true; |
228 |
CString tekst; |
CString tekst; |
229 |
std::vector<unsigned char> data; |
std::vector<unsigned char> data; |
230 |
|
|
231 |
data.push_back('a'); |
data.push_back('a'); |
232 |
data.push_back('t'); |
data.push_back('t'); |
233 |
data.push_back('+'); |
data.push_back('+'); |
235 |
data.push_back('p'); |
data.push_back('p'); |
236 |
data.push_back('i'); |
data.push_back('i'); |
237 |
data.push_back('n'); |
data.push_back('n'); |
238 |
data.push_back('='); |
data.push_back('?'); |
|
data.push_back('2'); |
|
|
data.push_back('5'); |
|
|
data.push_back('9'); |
|
|
data.push_back('5'); |
|
239 |
|
|
240 |
writeFrame(data); |
writeFrame(data); |
241 |
|
Sleep(100); |
242 |
|
if(Serial.getComstat().cbInQue > 0) |
243 |
|
{ |
244 |
|
std::vector<unsigned char> answer = readFrame(); |
245 |
|
Sleep(50); |
246 |
|
|
247 |
|
for (int i=0; i<answer.size(); i++) |
248 |
|
{ |
249 |
|
if ((answer[i] != 0x0A) && (answer[i] != 0x0D)) |
250 |
|
{ |
251 |
|
tekst.AppendChar(answer[i]); |
252 |
|
} |
253 |
|
} |
254 |
|
AppendText(tekst); |
255 |
|
} |
256 |
|
Sleep(5); |
257 |
|
tekst.MakeLower(); |
258 |
|
int pos = tekst.Find("+cpin: ",0); |
259 |
|
if (pos != -1) |
260 |
|
{ |
261 |
|
tekst = tekst.Right( tekst.GetLength() - pos -1); |
262 |
|
} |
263 |
|
|
264 |
|
if (tekst == "cpin: sim pin") |
265 |
|
{ |
266 |
|
CString pin; |
267 |
|
ConfigFile config; |
268 |
|
try { |
269 |
|
config.ReadSettings(); |
270 |
|
} catch(...) { |
271 |
|
MessageBox("Could not open config file"); |
272 |
|
} |
273 |
|
Sleep(50); |
274 |
|
|
275 |
|
data.clear(); |
276 |
|
data.push_back('a'); |
277 |
|
data.push_back('t'); |
278 |
|
data.push_back('+'); |
279 |
|
data.push_back('c'); |
280 |
|
data.push_back('p'); |
281 |
|
data.push_back('i'); |
282 |
|
data.push_back('n'); |
283 |
|
data.push_back('='); |
284 |
|
for (int i = 0; i<config.pincode.GetLength(); i++) |
285 |
|
{ |
286 |
|
data.push_back(config.pincode[i]); |
287 |
|
} |
288 |
|
|
289 |
|
writeFrame(data); |
290 |
|
|
291 |
|
Sleep(500); |
292 |
|
|
293 |
|
while (ready == true) |
294 |
|
{ |
295 |
|
if (Serial.getComstat().cbInQue > 120) |
296 |
|
{ |
297 |
|
std::vector<unsigned char> answer = readFrame(); |
298 |
|
CString tekst; |
299 |
|
|
300 |
|
for (int i=0; i<answer.size(); i++) |
301 |
|
{ |
302 |
|
if ((answer[i] != 0x0A) && (answer[i] != 0x0D)) |
303 |
|
{ |
304 |
|
tekst.AppendChar(answer[i]); |
305 |
|
} |
306 |
|
} |
307 |
|
int n = tekst.Find("WIND: 11",0); |
308 |
|
if (n > -1) |
309 |
|
{ |
310 |
|
ready = false; |
311 |
|
} |
312 |
|
else |
313 |
|
{ |
314 |
|
AppendText(tekst); |
315 |
|
} |
316 |
|
} |
317 |
|
Sleep(10); //Small delay to avoid busy wait |
318 |
|
} |
319 |
|
} |
320 |
|
else if (tekst == "cpin: ready") |
321 |
|
{ |
322 |
|
AppendText("No pincode needed"); |
323 |
|
} |
324 |
|
else |
325 |
|
{ |
326 |
|
AppendText("Error in set pin part of the code"); |
327 |
|
} |
328 |
} |
} |
329 |
void CFlisServerDlg::SendSmsData(std::vector<unsigned char> data) |
void CFlisServerDlg::SendSmsData(std::vector<unsigned char> data) |
330 |
{ |
{ |
430 |
if(Serial.getComstat().cbInQue > 0) |
if(Serial.getComstat().cbInQue > 0) |
431 |
{ |
{ |
432 |
std::vector<unsigned char> answer = readFrame(); |
std::vector<unsigned char> answer = readFrame(); |
433 |
//Sleep(50); |
Sleep(50); |
434 |
|
|
435 |
for (int i=0; i<answer.size(); i++) |
for (int i=0; i<answer.size(); i++) |
436 |
{ |
{ |
450 |
char CharData[150]; |
char CharData[150]; |
451 |
strcpy(CharData,data); |
strcpy(CharData,data); |
452 |
TlfNr = data.Mid(24,8); |
TlfNr = data.Mid(24,8); |
453 |
FyrData = data.Mid(57,data.GetLength()-3); |
FyrData = data.Mid(57,data.GetLength()-59); |
454 |
FyrData.Append(":"); |
FyrData.Append(":"); |
455 |
|
|
456 |
|
if (FyrData.MakeLower() == "conf ok:") |
457 |
|
{ |
458 |
|
HandleAcknowledge(TlfNr); |
459 |
|
return; |
460 |
|
} |
461 |
|
CAtlRegExp<> regex; |
462 |
|
if (regex.Parse("^{[0-9]+}:{[0-9]+}:[0-1]:[0-1]:[0-1]:[0-1]:$") == REPARSE_ERROR_OK) |
463 |
|
{ |
464 |
|
|
465 |
|
CAtlREMatchContext<> pContext; |
466 |
|
|
467 |
|
if (!regex.Match(FyrData, &pContext)) |
468 |
|
{ |
469 |
|
AppendText("Invalid SMS recieved"); |
470 |
|
return; |
471 |
|
} |
472 |
|
} |
473 |
|
else |
474 |
|
{ |
475 |
|
AppendText("Regex PARSE error!!!"); //Burde aldrig kunne ske ! |
476 |
|
} |
477 |
|
|
478 |
SmsCount = Splitter(FyrData); |
SmsCount = Splitter(FyrData); |
479 |
Temper = Splitter(FyrData); |
Temper = Splitter(FyrData); |
480 |
Flamme = Splitter(FyrData); |
Flamme = Splitter(FyrData); |
495 |
rs.Close(); |
rs.Close(); |
496 |
|
|
497 |
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); |
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); |
498 |
|
try |
499 |
|
{ |
500 |
db.ExecuteSQL(SQL); |
db.ExecuteSQL(SQL); |
501 |
|
} |
502 |
|
catch(CDBException* e) |
503 |
|
{ |
504 |
|
MessageBox(e->m_strError); |
505 |
|
} |
506 |
AppendText("Sms added to Log"); |
AppendText("Sms added to Log"); |
507 |
Sleep(150); |
Sleep(150); |
508 |
} |
} |
522 |
{ |
{ |
523 |
// TODO: Add your control notification handler code here |
// TODO: Add your control notification handler code here |
524 |
continueThread = 0; |
continueThread = 0; |
525 |
|
Sleep(250); |
526 |
DeleteSms(); |
DeleteSms(); |
527 |
|
|
528 |
Sleep(500); |
Sleep(500); |
539 |
OnOK(); |
OnOK(); |
540 |
|
|
541 |
} |
} |
|
|
|
|
void CFlisServerDlg::OnBnClickedGsmpin() |
|
|
{ |
|
|
// TODO: Add your control notification handler code here |
|
|
m_Textwindow.SetWindowText("Indsætter Pinkode, efterfuldt af 60sec pause"); |
|
|
UpdateWindow(); |
|
|
SetPin(); |
|
|
Sleep(50000); |
|
|
|
|
|
while (Serial.getComstat().cbInQue > 0) |
|
|
{ |
|
|
Serial.readByte(); //Flush the incoming queue |
|
|
} |
|
|
|
|
|
OnBnClickedStart(); |
|
|
} |
|
542 |
void CFlisServerDlg::DeleteSms() |
void CFlisServerDlg::DeleteSms() |
543 |
{ |
{ |
544 |
vector<unsigned char> atcommand; |
vector<unsigned char> atcommand; |
573 |
{ |
{ |
574 |
while (continueThread != 0) |
while (continueThread != 0) |
575 |
{ |
{ |
576 |
Reader(); |
MyMainThread(); |
577 |
} |
} |
578 |
} |
} |
579 |
void CFlisServerDlg::Reader() |
void CFlisServerDlg::MyMainThread() |
580 |
{ |
{ |
581 |
if(Serial.getComstat().cbInQue > 0) |
if(Serial.getComstat().cbInQue > 0) |
582 |
{ |
{ |
584 |
std::vector<unsigned char> answer = readFrame(); |
std::vector<unsigned char> answer = readFrame(); |
585 |
Sleep(500); |
Sleep(500); |
586 |
CString tekst, oldtekst; |
CString tekst, oldtekst; |
|
int lol; |
|
587 |
|
|
588 |
for (int i=0; i<answer.size(); i++) |
for (int i=0; i<answer.size(); i++) |
589 |
{ |
{ |
595 |
tekst.Append(":"); |
tekst.Append(":"); |
596 |
|
|
597 |
CString command; |
CString command; |
598 |
bool plus; |
bool plus = false; |
599 |
int pos = tekst.Find('+',0); |
int pos = tekst.Find('+',0); |
600 |
if (pos != -1) |
if (pos != -1) |
601 |
{ |
{ |
607 |
} |
} |
608 |
|
|
609 |
|
|
610 |
if(tekst == "OK") |
if(tekst.MakeLower() == "ok") |
611 |
{ |
{ |
612 |
AppendText("OK tekst modtaget"); |
AppendText("OK tekst modtaget"); |
613 |
} |
} |
614 |
else if (tekst == "error") |
else if (tekst.MakeLower() == "error") |
615 |
{ |
{ |
616 |
CString send; |
CString send; |
617 |
send.Append("error tekst"); |
send.Append("error tekst"); |
621 |
} |
} |
622 |
else if (plus == true) |
else if (plus == true) |
623 |
{ |
{ |
624 |
if (command == "cmti") |
if (command.MakeLower() == "cmti") |
625 |
{ |
{ |
626 |
CString smscount, oldteskst; |
CString smscount, oldteskst; |
627 |
int pos = tekst.Find(',',0); |
int pos = tekst.Find(',',0); |
646 |
{ |
{ |
647 |
data.push_back(smscount[i]); |
data.push_back(smscount[i]); |
648 |
} |
} |
649 |
m_Textwindow.GetWindowText(oldteskst); |
AppendText(CString(&data[0])); |
|
oldteskst.Append("\r\n"); |
|
|
for (int i=0; i<data.size();i++) |
|
|
{ |
|
|
oldteskst.AppendChar(data[i]); |
|
|
} |
|
|
m_Textwindow.SetWindowText(oldteskst); |
|
650 |
writeFrame(data); |
writeFrame(data); |
651 |
Sleep(200); |
Sleep(200); |
652 |
ReadSms(); |
ReadSms(); |
653 |
ResetSms++; |
ResetSms++; |
654 |
|
|
655 |
} |
} |
656 |
else if(command == "wind") |
else if(command.MakeLower() == "wind") |
657 |
{ |
{ |
658 |
|
|
659 |
CString send; |
CString send; |
665 |
} |
} |
666 |
else |
else |
667 |
{ |
{ |
668 |
CString send; |
AppendText(tekst); |
|
send.Append("Anden tekst end forventet"); |
|
|
send.Append("\r\n"); |
|
|
send.Append(tekst); |
|
|
AppendText(send); |
|
669 |
} |
} |
670 |
if(ResetSms == 20) |
if(ResetSms == 20) |
671 |
{ |
{ |
687 |
sIDnr = data[i].IDnr; |
sIDnr = data[i].IDnr; |
688 |
sCommandID = data[i].CommandID; |
sCommandID = data[i].CommandID; |
689 |
commandtest = atoi(data[i].CommandID); |
commandtest = atoi(data[i].CommandID); |
690 |
|
sInstallationsID = "0"; |
691 |
|
|
692 |
if(commandtest > 1) |
if(commandtest > 1) |
693 |
{ |
{ |
694 |
sInstallationsID = data[i].InstallationsID; |
sInstallationsID = data[i].InstallationsID; |
695 |
} |
} |
696 |
} |
} |
697 |
sIDnr = Splitter(testdata); |
|
|
sCommandID = Splitter(testdata); |
|
|
sInstallationsID = "0"; |
|
698 |
if (commandtest > 1) |
if (commandtest > 1) |
699 |
{ |
{ |
|
sInstallationsID = Splitter(testdata); |
|
700 |
iAll = 0; |
iAll = 0; |
701 |
} |
} |
702 |
|
|
704 |
{ |
{ |
705 |
SendConfig(sIDnr,sCommandID,sInstallationsID); |
SendConfig(sIDnr,sCommandID,sInstallationsID); |
706 |
} |
} |
707 |
|
Sleep(300); |
708 |
|
|
709 |
|
CheckAcknowledges(); |
710 |
Sleep(500); |
Sleep(500); |
711 |
} |
} |
712 |
|
CTime now = CTime::GetCurrentTime(); |
713 |
|
|
714 |
|
CTimeSpan elapsed = now-Alive.tid; |
715 |
|
|
716 |
|
if (elapsed.GetTotalSeconds() >= 900) |
717 |
|
{ |
718 |
|
keepaliveandread(); |
719 |
|
} |
720 |
} |
} |
721 |
void CFlisServerDlg::SendConfig(CString IDnr,CString CommandID,CString InstallationsID) |
void CFlisServerDlg::SendConfig(CString IDnr,CString CommandID,CString InstallationsID) |
722 |
{ |
{ |
|
CString ServerTlfNr; |
|
|
int i = 0; |
|
|
ServerTlfNr = "29860132"; |
|
|
|
|
723 |
|
|
724 |
std::vector<Installation> inst; |
std::vector<Installation> inst; |
725 |
inst = DBReadPhone(InstallationsID); |
|
726 |
while (i < inst.size()) |
if (CommandID == "1") |
727 |
|
inst = DBReadPhone("0"); |
728 |
|
else |
729 |
|
inst = DBReadPhone(InstallationsID); |
730 |
|
|
731 |
|
for ( int j=0; j < inst.size(); j++) |
732 |
{ |
{ |
733 |
CString TlfNr, Imei, updaterate; |
CString TlfNr, Imei, updaterate; |
734 |
TlfNr.Empty(); |
TlfNr.Empty(); |
735 |
Imei.Empty(); |
Imei.Empty(); |
736 |
updaterate.Empty(); |
updaterate.Empty(); |
737 |
|
|
738 |
CString dataen = inst[i].InstPhoneNr; |
CString dataen = inst[j].InstPhoneNr; |
739 |
TlfNr.Append(dataen); |
TlfNr.Append(dataen); |
740 |
CString Imeidata = inst[i].Imei; |
CString Imeidata = inst[j].Imei; |
741 |
Imei.Append(Imeidata); |
Imei.Append(Imeidata); |
742 |
CString updaterat = inst[i].Updaterate; |
CString updaterat = inst[j].Updaterate; |
743 |
updaterate.Append(updaterat); |
updaterate.Append(updaterat); |
|
i++; |
|
744 |
|
|
745 |
vector<unsigned char> tlfnr; |
vector<unsigned char> tlfnr; |
746 |
for (int i=0; i<TlfNr.GetLength(); i++) |
for (int i=0; i<TlfNr.GetLength(); i++) |
747 |
{ |
{ |
748 |
tlfnr.push_back(TlfNr[i]); |
tlfnr.push_back(TlfNr[i]); |
749 |
} |
} |
750 |
|
|
751 |
int calcimei; |
int calcimei; |
752 |
__int64 buf; |
__int64 buf; |
753 |
|
|
754 |
buf = atof(Imei); |
buf = atof(Imei); |
755 |
|
|
756 |
calcimei = tversum(buf); |
calcimei = tversum(buf); |
757 |
|
|
758 |
Imei.Format("%d",calcimei); |
Imei.Format("%d",calcimei); |
759 |
|
|
760 |
SendSmsHead(tlfnr); |
SendSmsHead(tlfnr); |
761 |
Sleep(250); |
Sleep(250); |
762 |
|
|
763 |
vector<unsigned char> smsdata; |
vector<unsigned char> smsdata; |
764 |
|
|
765 |
for (int i=0; i<Imei.GetLength(); i++) |
for (int i=0; i<Imei.GetLength(); i++) |
766 |
{ |
{ |
767 |
smsdata.push_back(Imei[i]); |
smsdata.push_back(Imei[i]); |
768 |
} |
} |
769 |
smsdata.push_back(':'); |
smsdata.push_back(':'); |
770 |
for (int i=0; i<ServerTlfNr.GetLength(); i++) |
for (int i=0; i<Alive.Phonenr.GetLength(); i++) |
771 |
{ |
{ |
772 |
smsdata.push_back(ServerTlfNr[i]); |
smsdata.push_back(Alive.Phonenr[i]); |
773 |
} |
} |
774 |
smsdata.push_back(':'); |
smsdata.push_back(':'); |
775 |
for (int i=0; i<updaterate.GetLength(); i++) |
for (int i=0; i<updaterate.GetLength(); i++) |
776 |
{ |
{ |
777 |
smsdata.push_back(updaterate[i]); |
smsdata.push_back(updaterate[i]); |
778 |
} |
} |
779 |
|
|
780 |
|
SendSmsData(smsdata); |
781 |
|
Sleep(500); |
782 |
|
|
783 |
|
if (IDnr != "0") |
784 |
|
{ |
785 |
|
Acks.push_back( Acknowledge(inst[j].instID,TlfNr) ); |
786 |
|
} |
787 |
|
|
|
SendSmsData(smsdata); |
|
|
Sleep(500); |
|
|
|
|
788 |
} |
} |
789 |
|
|
790 |
|
if (IDnr != "0") |
791 |
|
{ |
792 |
CString SQL, Textwindow; |
CString SQL, Textwindow; |
793 |
SQL.Format("update command set executed=now() where id=%s",IDnr); |
SQL.Format("update command set executed=now() where id=%s",IDnr); |
794 |
db.ExecuteSQL(SQL); |
db.ExecuteSQL(SQL); |
795 |
|
Sleep(100); |
796 |
AppendText("Command executed"); |
AppendText("Command executed"); |
797 |
Sleep(150); |
} |
798 |
|
Sleep(150); |
799 |
|
|
800 |
|
|
801 |
|
|
802 |
|
|
803 |
} |
} |
804 |
vector<Installation> CFlisServerDlg::DBReadPhone(CString sInstallationsID) |
vector<Installation> CFlisServerDlg::DBReadPhone(CString sInstallationsID) |
805 |
{ |
{ |
806 |
vector<Installation> buffer; |
vector<Installation> buffer; |
807 |
|
|
808 |
CString SQL, phonenr, imei, updaterate; |
CString SQL, phonenr, imei, updaterate, id; |
|
int installernull; |
|
809 |
Installation Myinst; |
Installation Myinst; |
810 |
installernull = atoi(sInstallationsID); |
|
811 |
if (installernull > 1) |
if (sInstallationsID != "0") |
812 |
{ |
{ |
813 |
SQL.Format("select installationphonenr, imei, updaterate from installation WHERE id = %s", sInstallationsID); |
SQL.Format("select installationphonenr, imei, updaterate, id from installation WHERE id = %s", sInstallationsID); |
814 |
} |
} |
815 |
else if(installernull < 2) |
else |
816 |
{ |
{ |
817 |
SQL.Format("select installationphonenr, imei, updaterate from installation"); |
SQL.Format("select installationphonenr, imei, updaterate, id from installation"); |
818 |
} |
} |
819 |
|
|
820 |
CRecordset rs(&db); |
CRecordset rs(&db); |
821 |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
822 |
if (rs.GetRecordCount()>0) |
if (rs.GetRecordCount()>0) |
828 |
rs.GetFieldValue((short)0,phonenr); |
rs.GetFieldValue((short)0,phonenr); |
829 |
rs.GetFieldValue(1,imei); |
rs.GetFieldValue(1,imei); |
830 |
rs.GetFieldValue(2,updaterate); |
rs.GetFieldValue(2,updaterate); |
831 |
|
rs.GetFieldValue(3,id); |
832 |
|
|
833 |
Myinst.InstPhoneNr = phonenr; |
Myinst.InstPhoneNr = phonenr; |
834 |
Myinst.Imei = imei; |
Myinst.Imei = imei; |
835 |
Myinst.Updaterate = updaterate; |
Myinst.Updaterate = updaterate; |
836 |
|
Myinst.instID = id; |
837 |
|
|
838 |
buffer.push_back(Myinst); |
buffer.push_back(Myinst); |
839 |
rs.MoveNext(); |
rs.MoveNext(); |
856 |
{ |
{ |
857 |
// TODO: Add your control notification handler code here |
// TODO: Add your control notification handler code here |
858 |
|
|
859 |
|
AppendText("Indsætter Pinkode, og venter på modem bliver klar, hvis pinkode er nødvendig"); |
860 |
|
UpdateWindow(); |
861 |
|
SetPin(); |
862 |
|
|
863 |
|
Sleep(100); //Give the modem a chance to send the last data |
864 |
|
while(Serial.getComstat().cbInQue > 0) |
865 |
|
{ |
866 |
|
Serial.readByte(); //Flush the incoming queue |
867 |
|
Sleep(1); |
868 |
|
} |
869 |
|
Sleep(5); |
870 |
|
|
871 |
continueThread = 1; |
continueThread = 1; |
872 |
m_Textwindow.SetWindowText("Started"); |
keepaliveandread(); |
873 |
|
Sleep(150); |
874 |
|
AppendText(CString("Server phonenr read from db: ") + Alive.Phonenr ); |
875 |
|
AppendText("Started"); |
876 |
AfxBeginThread(threadWrapper,AfxGetMainWnd()); |
AfxBeginThread(threadWrapper,AfxGetMainWnd()); |
877 |
} |
} |
878 |
void CFlisServerDlg::AppendText(CString s) |
void CFlisServerDlg::AppendText(CString s) |
879 |
{ |
{ |
880 |
|
CTime now = CTime::GetCurrentTime(); |
881 |
CString Tekst; |
CString Tekst; |
882 |
m_Textwindow.GetWindowText(Tekst); |
m_Textwindow.GetWindowText(Tekst); |
883 |
Tekst.Append("\r\n"); |
Tekst.AppendFormat("%02d:%02d:%02d : ", now.GetHour(), now.GetMinute(), now.GetSecond()); |
884 |
Tekst.Append(s); |
Tekst.Append(s); |
885 |
|
Tekst.Append("\r\n"); |
886 |
|
|
887 |
m_Textwindow.SetWindowText(Tekst); |
m_Textwindow.SetWindowText(Tekst); |
888 |
|
Sleep(5); |
889 |
|
int g = m_Textwindow.GetScrollLimit(SB_VERT); |
890 |
|
if (g > 0) |
891 |
|
{ |
892 |
|
m_Textwindow.SetSel(m_Textwindow.GetWindowTextLength() -1,m_Textwindow.GetWindowTextLength(),false); |
893 |
|
} |
894 |
|
|
895 |
} |
} |
896 |
void ConfigFile::ReadSettings() |
void ConfigFile::ReadSettings() |
922 |
database = value; |
database = value; |
923 |
else if (key == "comport") |
else if (key == "comport") |
924 |
comport = value; |
comport = value; |
925 |
|
else if (key == "pincode") |
926 |
|
pincode = value; |
927 |
} |
} |
928 |
|
|
929 |
} |
} |
930 |
|
|
931 |
file.close(); |
file.close(); |
|
} |
|
932 |
|
} |
933 |
|
void CFlisServerDlg::HandleAcknowledge(CString tlfnr) |
934 |
|
{ |
935 |
|
for (std::list<Acknowledge>::iterator it = Acks.begin(); it != Acks.end(); ++it) |
936 |
|
{ |
937 |
|
Acknowledge& current = (*it); |
938 |
|
if (current.sTlfNr == tlfnr) |
939 |
|
{ |
940 |
|
CString SQL; |
941 |
|
SQL.Format("UPDATE installation SET commerror = false WHERE id = %s", current.sInstallationID); |
942 |
|
db.ExecuteSQL(SQL); |
943 |
|
|
944 |
|
Acks.erase(it); |
945 |
|
|
946 |
|
return; |
947 |
|
} |
948 |
|
} |
949 |
|
} |
950 |
|
|
951 |
|
void CFlisServerDlg::CheckAcknowledges() |
952 |
|
{ |
953 |
|
CTime now = CTime::GetCurrentTime(); |
954 |
|
for (std::list<Acknowledge>::iterator it = Acks.begin(); it != Acks.end(); ++it) |
955 |
|
{ |
956 |
|
Acknowledge& current = (*it); |
957 |
|
|
958 |
|
CTimeSpan elapsed = now-current.cTime; |
959 |
|
|
960 |
|
if (elapsed.GetTotalSeconds() >= 300) |
961 |
|
{ |
962 |
|
DumpAckList(); |
963 |
|
if (current.iRetry >= 1) |
964 |
|
{ |
965 |
|
CString SQL; |
966 |
|
SQL.Format("UPDATE installation SET commerror = true WHERE id = %s", current.sInstallationID); |
967 |
|
db.ExecuteSQL(SQL); |
968 |
|
Acks.erase(it); |
969 |
|
return; // the iterator is now invalidated, but the thread loop will make sure we are here soon again |
970 |
|
} |
971 |
|
else |
972 |
|
{ |
973 |
|
SendConfig("0","2",current.sInstallationID); |
974 |
|
current.iRetry++; |
975 |
|
current.cTime = CTime::GetCurrentTime(); |
976 |
|
AppendText( CString("Retry send config to ") + current.sTlfNr ); |
977 |
|
} |
978 |
|
} |
979 |
|
} |
980 |
|
} |
981 |
|
|
982 |
|
void CFlisServerDlg::DumpAckList() /* Debug tool */ |
983 |
|
{ |
984 |
|
|
985 |
|
CTime now = CTime::GetCurrentTime(); |
986 |
|
OutputDebugString("-------------------------------\n"); |
987 |
|
int count = 0; |
988 |
|
for (std::list<Acknowledge>::iterator it = Acks.begin(); it != Acks.end(); ++it) |
989 |
|
{ |
990 |
|
CString msg; |
991 |
|
msg.Format("%d:%d:%d> %4d : %s\n", now.GetHour(), now.GetMinute(), now.GetSecond(), count, (*it).sTlfNr); |
992 |
|
OutputDebugString(msg); |
993 |
|
count++; |
994 |
|
} |
995 |
|
} |
996 |
|
vector<keepalive> CFlisServerDlg::keepaliveandread(void) |
997 |
|
{ |
998 |
|
vector<keepalive> buffer; |
999 |
|
|
1000 |
|
CString SQL, name, value; |
1001 |
|
SQL = "select name, value from config;"; |
1002 |
|
CRecordset rs(&db); |
1003 |
|
try |
1004 |
|
{ |
1005 |
|
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
1006 |
|
if (rs.GetRecordCount()>0) |
1007 |
|
{ |
1008 |
|
rs.MoveFirst(); |
1009 |
|
|
1010 |
|
rs.GetFieldValue((short)0, name); |
1011 |
|
rs.GetFieldValue(1,value); |
1012 |
|
|
1013 |
|
Alive.name = name; |
1014 |
|
Alive.value = value; |
1015 |
|
Alive.tid = CTime::GetCurrentTime(); |
1016 |
|
if(Alive.name == "phonenr") |
1017 |
|
{ |
1018 |
|
Alive.Phonenr = value; |
1019 |
|
} |
1020 |
|
|
1021 |
|
buffer.push_back(Alive); |
1022 |
|
rs.MoveNext(); |
1023 |
|
|
1024 |
|
} |
1025 |
|
rs.Close(); |
1026 |
|
return buffer; |
1027 |
|
} |
1028 |
|
catch (char * str) |
1029 |
|
{ |
1030 |
|
AppendText("Keepalive failed, closing and opening the db connection again"); |
1031 |
|
if(db.IsOpen()) |
1032 |
|
{ |
1033 |
|
db.Close(); |
1034 |
|
AppendText("DB connection closed"); |
1035 |
|
} |
1036 |
|
if(!db.IsOpen()) |
1037 |
|
{ |
1038 |
|
DBConnect(); |
1039 |
|
AppendText("DB connection started again"); |
1040 |
|
} |
1041 |
|
return buffer; |
1042 |
|
} |
1043 |
|
|
1044 |
|
|
1045 |
|
} |