252 |
CString tekst; |
CString tekst; |
253 |
std::vector<unsigned char> answer = readFrame(); |
std::vector<unsigned char> answer = readFrame(); |
254 |
Sleep(50); |
Sleep(50); |
255 |
char array1[25]; |
char array1[150]; |
256 |
int i; |
int i; |
257 |
for (int i=0; i<answer.size(); i++) |
for (int i=0; i<answer.size(); i++) |
258 |
{ |
{ |
302 |
void CFlisServerDlg::DBConnect() |
void CFlisServerDlg::DBConnect() |
303 |
{ |
{ |
304 |
CString dsn; |
CString dsn; |
305 |
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=t-hoerup.dk; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer"); //Torben |
306 |
//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=192.168.134.132; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer"); //skole server |
307 |
db.OpenEx(dsn, CDatabase::noOdbcDialog); |
db.OpenEx(dsn, CDatabase::noOdbcDialog); |
308 |
} |
} |
309 |
vector<Commands> CFlisServerDlg::DBRead(void) |
vector<Commands> CFlisServerDlg::DBRead(void) |
319 |
rs.MoveFirst(); |
rs.MoveFirst(); |
320 |
while(!rs.IsEOF()) |
while(!rs.IsEOF()) |
321 |
{ |
{ |
322 |
Commands Mycom; |
Commands Mycom; |
323 |
rs.GetFieldValue((short)0, IDnr); |
rs.GetFieldValue((short)0, IDnr); |
324 |
rs.GetFieldValue(3, CommandID); |
rs.GetFieldValue(3, CommandID); |
325 |
rs.GetFieldValue(4, InstallationsID); |
rs.GetFieldValue(4, InstallationsID); |
326 |
|
|
327 |
Mycom.IDnr = IDnr; |
Mycom.IDnr = IDnr; |
328 |
Mycom.CommandID = CommandID; |
Mycom.CommandID = CommandID; |
329 |
Mycom.InstallationsID = InstallationsID; |
Mycom.InstallationsID = InstallationsID; |
330 |
|
|
331 |
buffer.push_back(Mycom); |
buffer.push_back(Mycom); |
332 |
rs.MoveNext(); |
rs.MoveNext(); |
333 |
} |
} |
334 |
} |
} |
335 |
rs.Close(); |
rs.Close(); |
612 |
if (continueThread = 1) |
if (continueThread = 1) |
613 |
{ |
{ |
614 |
|
|
|
////////////////DBRead stuff////////////////// |
|
615 |
CString testdata, dataframe,testprint, sIDnr, sCommandID, sInstallationsID, sImei; |
CString testdata, dataframe,testprint, sIDnr, sCommandID, sInstallationsID, sImei; |
616 |
|
int commandtest = 0; |
617 |
|
int iAll = 1; |
618 |
std::vector<Commands> data; |
std::vector<Commands> data; |
619 |
data = DBRead(); |
data = DBRead(); |
620 |
for (int i=0; i<data.size(); i++) |
for (int i=0; i<data.size(); i++) |
623 |
testdata.Append(":"); |
testdata.Append(":"); |
624 |
testdata.Append(data[i].CommandID); |
testdata.Append(data[i].CommandID); |
625 |
testdata.Append(":"); |
testdata.Append(":"); |
626 |
|
commandtest = atoi(data[i].CommandID); |
627 |
|
|
628 |
|
if(commandtest > 1) |
629 |
|
{ |
630 |
testdata.Append(data[i].InstallationsID); |
testdata.Append(data[i].InstallationsID); |
631 |
testdata.Append(":"); |
testdata.Append(":"); |
632 |
|
} |
633 |
} |
} |
634 |
sIDnr = Splitter(testdata); |
sIDnr = Splitter(testdata); |
635 |
sCommandID = Splitter(testdata); |
sCommandID = Splitter(testdata); |
636 |
|
sInstallationsID = "0"; |
637 |
|
if (commandtest > 1) |
638 |
|
{ |
639 |
sInstallationsID = Splitter(testdata); |
sInstallationsID = Splitter(testdata); |
640 |
|
iAll = 0; |
641 |
|
} |
642 |
|
|
643 |
if (sIDnr.GetLength() > 0) |
if (sIDnr.GetLength() > 0) |
644 |
{ |
{ |
645 |
DBReadData(sIDnr,sCommandID,sInstallationsID); |
DBReadData(sIDnr,sCommandID,sInstallationsID); |
646 |
} |
} |
647 |
Sleep(500); |
Sleep(500); |
|
////////////////DBRead stuff////////////////// |
|
648 |
} |
} |
649 |
} |
} |
650 |
void CFlisServerDlg::DBReadData(CString IDnr,CString CommandID,CString InstallationsID) |
void CFlisServerDlg::DBReadData(CString IDnr,CString CommandID,CString InstallationsID) |
651 |
{ |
{ |
652 |
CString TlfNr, Imei, ServerTlfNr, updaterate; |
CString ServerTlfNr; |
653 |
|
int i = 0; |
654 |
ServerTlfNr = "29860132"; |
ServerTlfNr = "29860132"; |
655 |
|
|
656 |
//kald dbreadphone som du kalder dbread |
|
657 |
std::vector<Installation> inst; |
std::vector<Installation> inst; |
658 |
inst = DBReadPhone(InstallationsID); |
inst = DBReadPhone(InstallationsID); |
659 |
for (int i=0; i<inst.size(); i++) |
while (i < inst.size()) |
660 |
{ |
{ |
661 |
|
CString TlfNr, Imei, updaterate; |
662 |
|
TlfNr.Empty(); |
663 |
|
Imei.Empty(); |
664 |
|
updaterate.Empty(); |
665 |
|
|
666 |
CString dataen = inst[i].InstPhoneNr; |
CString dataen = inst[i].InstPhoneNr; |
667 |
TlfNr.Append(dataen); |
TlfNr.Append(dataen); |
668 |
CString Imeidata = inst[i].Imei; |
CString Imeidata = inst[i].Imei; |
669 |
Imei.Append(Imeidata); |
Imei.Append(Imeidata); |
670 |
CString updaterat = inst[i].Updaterate; |
CString updaterat = inst[i].Updaterate; |
671 |
updaterate.Append(updaterat); |
updaterate.Append(updaterat); |
672 |
} |
i++; |
673 |
|
|
674 |
vector<unsigned char> tlfnr; |
vector<unsigned char> tlfnr; |
675 |
for (int i=0; i<TlfNr.GetLength(); i++) |
for (int i=0; i<TlfNr.GetLength(); i++) |
676 |
{ |
{ |
678 |
} |
} |
679 |
|
|
680 |
int calcimei; |
int calcimei; |
681 |
double buf; |
__int64 buf; |
|
Imei.Remove('0'); |
|
682 |
|
|
683 |
buf = atof(Imei); |
buf = atof(Imei); |
684 |
|
|
687 |
Imei.Format("%d",calcimei); |
Imei.Format("%d",calcimei); |
688 |
|
|
689 |
SendSmsHead(tlfnr); |
SendSmsHead(tlfnr); |
690 |
Sleep(500); |
Sleep(250); |
691 |
//35:29860132:75 <--- demo pakke; |
|
692 |
vector<unsigned char> smsdata; |
vector<unsigned char> smsdata; |
693 |
|
|
694 |
for (int i=0; i<Imei.GetLength(); i++) |
for (int i=0; i<Imei.GetLength(); i++) |
707 |
} |
} |
708 |
|
|
709 |
SendSmsData(smsdata); |
SendSmsData(smsdata); |
710 |
Sleep(250); |
Sleep(500); |
711 |
|
|
712 |
CString SQL; |
} |
713 |
|
CString SQL, Textwindow; |
714 |
SQL.Format("update command set executed=now() where id=%s",IDnr); |
SQL.Format("update command set executed=now() where id=%s",IDnr); |
715 |
db.ExecuteSQL(SQL); |
db.ExecuteSQL(SQL); |
716 |
Sleep(150); |
m_Textwindow.GetWindowText(Textwindow); |
717 |
|
Textwindow.Append("\r\n"); |
718 |
|
Textwindow.Append("Command executed"); |
719 |
|
m_Textwindow.SetWindowText(Textwindow); |
720 |
|
Sleep(150); |
721 |
|
|
722 |
} |
} |
723 |
vector<Installation> CFlisServerDlg::DBReadPhone(CString sInstallationsID) |
vector<Installation> CFlisServerDlg::DBReadPhone(CString sInstallationsID) |
725 |
vector<Installation> buffer; |
vector<Installation> buffer; |
726 |
|
|
727 |
CString SQL, phonenr, imei, updaterate; |
CString SQL, phonenr, imei, updaterate; |
728 |
SQL.Format("select installationphonenr, imei, updaterate from installation WHERE id = %s",sInstallationsID); |
int installernull; |
729 |
|
Installation Myinst; |
730 |
|
installernull = atoi(sInstallationsID); |
731 |
|
if (installernull > 1) |
732 |
|
{ |
733 |
|
SQL.Format("select installationphonenr, imei, updaterate from installation WHERE id = %s", sInstallationsID); |
734 |
|
} |
735 |
|
else if(installernull < 2) |
736 |
|
{ |
737 |
|
SQL.Format("select installationphonenr, imei, updaterate from installation"); |
738 |
|
} |
739 |
CRecordset rs(&db); |
CRecordset rs(&db); |
740 |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
741 |
if (rs.GetRecordCount()>0) |
if (rs.GetRecordCount()>0) |
743 |
rs.MoveFirst(); |
rs.MoveFirst(); |
744 |
while(!rs.IsEOF()) |
while(!rs.IsEOF()) |
745 |
{ |
{ |
746 |
Installation Myinst; |
|
747 |
rs.GetFieldValue((short)0,phonenr); |
rs.GetFieldValue((short)0,phonenr); |
748 |
rs.GetFieldValue(1,imei); |
rs.GetFieldValue(1,imei); |
749 |
rs.GetFieldValue(2,updaterate); |
rs.GetFieldValue(2,updaterate); |
750 |
|
|
751 |
Myinst.InstPhoneNr.Append(phonenr); |
Myinst.InstPhoneNr = phonenr; |
752 |
Myinst.Imei.Append(imei); |
Myinst.Imei = imei; |
753 |
Myinst.Updaterate.Append(updaterate); |
Myinst.Updaterate = updaterate; |
754 |
|
|
755 |
buffer.push_back(Myinst); |
buffer.push_back(Myinst); |
756 |
rs.MoveNext(); |
rs.MoveNext(); |
757 |
} |
} |
758 |
} |
} |
759 |
rs.Close(); |
rs.Close(); |
760 |
return buffer; |
return buffer; |
761 |
} |
} |
762 |
int CFlisServerDlg::tversum(unsigned input) |
int CFlisServerDlg::tversum(__int64 input) |
763 |
{ |
{ |
764 |
int sum = 0; |
int sum = 0; |
765 |
while (input > 0) |
while (input > 0) |