MINISTRY OF EDUCATION AND TRAINING
HO CHI MINH CITY UNIVERSITY
OF TECHNOLOGY AND EDUCATION
FACULTY OF ELECTRICAL AND ELECTRONICS
ENGINEERING
-⸙∆⸙-

GRADUATION PROJECT
DESIGNING AN IOT SYSTEM FOR MACHINE
PRODUCTIVITY MANAGEMENT
Mentor: PhD. Nguyễn Văn Thái
Candidate: Tô Hoàng Nhân

ID: 19142349

Candidate: Đoàn Nguyễn Minh Tiến

ID: 19142040

Ho Chi Minh city, July 2023

TABLE OF CONTENTS
INTRODUCTION ........................................................................... 1
1.1. Problem statement........................................................................................ 1
1.2. Research objectives...................................................................................... 2
1.3. Research scope ............................................................................................. 2
1.4. Research limits ............................................................................................. 2
1.5. Research contents ........................................................................................ 3
1.6. Report structure............................................................................................ 4
LITURATURE REVIEW ............................................................... 5
2.1. Internet of Things......................................................................................... 5
Introduction ........................................................................................... 5
IoT systems structure ............................................................................ 6
2.2. LoRa Technology ........................................................................................ 7
LoRa...................................................................................................... 7
LoRa parameters ................................................................................... 8
LoRaWAN ............................................................................................ 9
2.3. SPI Interface .............................................................................................. 10
General Introduction ........................................................................... 10
SPI operating principle ....................................................................... 11
2.4. I2C Interface .............................................................................................. 12
Genera
...

...
query = sqlsrv_query($conn, $sql2)
if ($query == false)
echo false
else echo success

-4-

APPENDIX
}
else if ($ProcessTime==NULL)
{
$sql1 = top(1) * FROM dbo.SupportRequest WHERE MachineID =
$MachineID order by RequestDate DESC
$result1 = sqlsrv_query($conn, $sql1)
if ($result1 == false)
echo NoC
$data1 = sqlsrv_fetch_array($result1)
if ($data1!=NULL)
{
if (($data1[Status] == 0 || $data1[Status] == 1) &amp&amp
$data1[RequestType] == Process Issue)
else
{
$sql1 = top(1) SupportID FROM dbo.SupportRequest order
by ID DESC
$result = sqlsrv_query($conn, $sql1)
if ($result==false) $SupportID = SUPR000000000
else
{
$data = sqlsrv_fetch_array($result)
if ($data!=NULL)
{
$SupportID =
sprintf(SUPR%09d,((int)substr($data[SupportID],5)+1))
}
else
{
$SupportID = SUPR000000000
}
}
$sql = into dbo.SupportRequest values
($SupportID,getdate(),getdate(),Reporter,$MachineID,$Product,Process
Issue,None,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL)

$finalresult=sqlsrv_query($conn, $sql)
if ($finalresult==false)
echo Fail!
if ($finalresult==true) echo Success!
}
}
else
{
$sql1 = top(1) SupportID FROM dbo.SupportRequest order
by ID DESC
$result = sqlsrv_query($conn, $sql1)

-5-

APPENDIX
if ($result==false) $SupportID = SUPR000000000
else
{
$data = sqlsrv_fetch_array($result)
if ($data!=NULL)
{
$SupportID =
sprintf(SUPR%09d,((int)substr($data[SupportID],5)+1))
}
else
{
$SupportID = SUPR000000000
}
}
$sql = into dbo.SupportRequest values
($SupportID,getdate(),getdate(),Reporter,$MachineID,$Product,Process
Issue,None,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL)

$finalresult=sqlsrv_query($conn, $sql)
if ($finalresult==false)
echo Fail!
if ($finalresult==true) echo Success!
}
$sql2 = into dbo.machineoutput
Values($Product,Dateadd(second,-$Date,getdate()),Dateadd(second,$Date,getdate()),$ProcessTime,$StaffsID,$MachineID,NULL,NULL)
$query = sqlsrv_query($conn, $sql2)
if ($query == false)
echo false
else echo success
}
}

-6-

APPENDIX
[7].

General Flowchart of the system.

Based on this sequential calling protocol, there is no limit to the number of nodes.
However, it should be noted that as the number of nodes on a single gateway increases,
the time it takes to complete one cycle of the protocol also increases. This can result in
slower data s.

-7-