臺灣博碩士論文加值系統

本論文目標為一個定點式物聯網資料採集系統的NB-IoT通用型閘道器的設計及製作。NB-IoT通用型閘道器能夠定時將周邊設備使用RS485總線透過MODBUS通訊協定採集資料，再透過NB-IoT通用型閘道器內部的NB-IoT通訊模組將資料上傳至網路伺服器。並且實際架設了伺服器能夠接收上傳的資料並察看最新資料及歷史紀錄。
NB-IoT通用型閘道器使用STM32F103RCT6微控制器作為主控系統，一邊作為MODBUS通訊主端向周邊裝置收集資料，另一邊對NB-IoT通訊模組UBLOX SARA-R410M-02B透過UART AT Command進行操作後，將資料交由NB-IoT通訊模組進行上傳的動作。NB-IoT通用型閘道器的電源透過外部24~5V DC電源供應，並加裝了鋰電池及充電晶片，能在外部供電中斷或不穩時讓系統能夠繼續運作。
資料上傳方式使用HTTP GET的方法上傳至伺服器，將資料透過URL參數將資料傳送給PHP網頁，PHP網頁依照收到參數中的資料存放在MySQL資料庫中。在PHP頁面查看資料紀錄時，PHP則會根據瀏覽的分類對MySQL進行搜尋後顯示在網頁上。
本研究最終完成了NB-IoT通用型閘道器，並且經由測試能夠透過設定，使用MODBUS通訊協定將資料收集，並透過NB-IoT模組上傳至PHP頁面，並且能夠在PHP頁面上查閱各個裝置的歷史紀錄。

The purpose of this thesis is to design and fabricate a NB-IoT universal gateway for a fixed-point IoT data acquisition system. The NB-IoT universal gateway can periodically collect data from peripheral devices using the RS485 bus through the MODBUS protocol, and then upload the data to the network server through the NB-IoT communication module inside the NB-IoT universal gateway. And the actual server is set up to receive the uploaded data and view the latest information and historical records.
The NB-IoT universal gateway uses the STM32F103RCT6 microcontroller as the main control system. It collects data from the peripheral device as the MODBUS communication master and the UB-IoT communication module UBLOX SARA-R410M-02B through the UART AT Command. After the operation, the data is transferred to the NB-IoT communication module for uploading. The NB-IoT universal gateway is powered by an external 24~5V DC power supply and is equipped with a lithium battery and a charging chip to allow the system to continue operating when external power is interrupted or unstable. The data upload method is uploaded to the server by using the HTTP GET method, and the data is transmitted to the PHP webpage through the URL parameter, and the PHP webpage is stored in the MySQL database according to the data in the received parameters. When viewing the data record on the PHP page, PHP will search for the MySQL based on the browsed category and display it on the web page.
This study finally completed the NB-IoT universal gateway, and through the test, the data can be collected through the MODBUS protocol and uploaded to the PHP page through the NB-IoT module, and the devices history log can be viewed on the PHP page.

誌謝 i
摘要 ii
目錄 vi
圖目錄 x
表目錄 xi
第一章 緒論 1
1.1 NB-IOT 1
1.2 MODBUS 3
第二章 系統設計 4
2.1 硬體設計 5
2.1.1 系統架構圖 5
2.1.2 外殼及擺件設計 8
2.1.3 電路設計 11
2.2 程式架構設計 13
2.2.1 HAL 層 13
2.2.2 驅動層 14
2.2.3 應用層 16
第三章 SARA-R4 17
3.1 SARA-R4相關知識 17
3.1.1 SARA-R4 硬體介面 17
3.1.2 NB-IoT 無線通訊相關知識 18
3.2 動作流程 22
3.2.1 開機設定 23
3.2.2 註網 25
3.2.3 上傳 27
3.2.4 關機 27
第四章 MODBUS 通訊實踐 28
4.1 MODBUS 封包格式 28
4.1.1 MODBUS資訊框架 28
4.1.2 MODBUS 資料類型 29
4.1.3 ADU 資料格式 29
4.2 MODBUS 程式設計 35
4.2.1 程式架構 35
4.2.2 控制流程 36
第五章 網頁伺服器規畫 39
5.1 PHP網頁規畫 39
5.1.1 PHP上傳頁面 39
5.1.2 PHP 檢視頁面 39
5.2 MYSQL資料庫規畫 40
第六章 結論 41
6.1 MODBUS 通訊驗證 41
6.2 HTTP 資料上傳測試 43
6.3 PHP頁面展示 43
第七章 未來展望 45
7.1 連線功能 45
7.2 CONSOLE PORT 未來規劃 45
參考文獻 46
中文部份 46
英文部份 47

[1]. 無線聯網技術推助　物聯網閘道器應用熱度狂飆 | 新通訊
https://www.2cm.com.tw/2cm/zh-tw/magazine/-CoverStory/C9636801F9DF433FB70909B87B8BDAF4
[2]. NB-IoT補足物聯網的重要缺口 - 技術趨勢 - 工研院資訊與通訊研究所
https://ictjournal.itri.org.tw/Content/Messagess/contents.aspx?MmmID=654304432122064271&MSID=1002354273351465771
[3]. Modbus-Organization, Inc. ( April 26, 2012).
MODBUS APPLICATION PROTOCOL SPECIFICATION V1.1b3
Modbus_Application_Protocol_V1_1b3.pdf
[4]. Modbus-Organization, Inc. ( Dec 20, 2006).
MODBUS over serial line specification and implementation guide V1.02
Modbus_over_serial_line_V1_02.pdf
[5]. Olof Liberg, Marten SundbergEric, Eric Wang, Johan Bergman, Joachim Sachs, (2017).
Cellular Internet of Things, Technologies, Standards, and Performance.
(ISBN：978-0-12-812458-1). United States : Academic Press.
[6]. U-blox. ( Sep 13, 2018 ).
SARA-R4/N4 series AT Commands Manual.
SARA-R4_N4 AT Commands Manual.pdf
www.u-blox.com UBX-17003787 - R11
[7]. U-blox. ( Sep 20, 2018 ).
SARA-R4/N4 series System Integration Manual
SARA-R4_DataSheet_(UBX-16024152).pdf
www.u-blox.com UBX-16029218 - R10
[8]. U-blox. ( Jan 04, 2018 ).
SARA-R4 series Data Sheet
PM-3133 User's Manual_En v1.07.pdf
www.u-blox.com UBX-16024152 - R08
[9]. 3rd Generation Partnership Project. (Nov, 2015)
Cellular System Support for Ultra-Low Complexity and Low Throughput Internet of Things.
http://www.3gpp.org 3GPP TR 45.820 V13.1.0
[10]. 3rd Generation Partnership Project. (Jun, 2019)
Numbering, addressing and identification
http://www.3gpp.org 3GPP TR 23.003 V15.7.0
[11]. 3rd Generation Partnership Project. (Sep, 2018)
Physical layer
http://www.3gpp.org 3GPP TR 36.211 V15.6.0
[12]. 3rd Generation Partnership Project. (Jun, 2019)
Physical channels and modulation
http://www.3gpp.org 3GPP TR 36.214 V15.3.0
[13]. 3rd Generation Partnership Project. (Mar, 2019)
Base Station (BS) radio transmission and reception
http://www.3gpp.org 3GPP TR 36.104 V15.6.0
[14]. Network Working Group (May, 2019)
RFC 8615: Well-Known Uniform Resource Identifiers (URIs)
http://www.rfc-editor.org/rfc/rfc8615.html
[15]. Network Working Group (Jan, 2005)
RFC 3986: Uniform Resource Identifier (URI): Generic Syntax
http://www.rfc-editor.org/rfc/rfc3986.html
[16]. Network Working Group (Nov, 1996)
RFC 2056: Uniform Resource Locators for Z39.50
http://www.rfc-editor.org/rfc/rfc2056.html
[17]. (Aug. 4, 2019, 02:02. UTC). URL - Wikipedia
https://en.wikipedia.org/wiki/URL
[18]. 3rd Generation Partnership Project. (Jun. 22, 2016)
Standardization of NB-IOT completed
Retrieved from:
https://www.3gpp.org/news-events/1785-nb_iot_complete
[19]. (27. july, 2017) A Short History of LPWAN, and Why the IoT Can’t Live Without It – TEOCO.
Retrieved from:
https://www.teoco.com/latest/news/blog/short-history-lpwan/
[20]. (July. 2, 2019, 04:44. UTC). Modbus – Wikipedia.
Retrieved from: https://en.wikipedia.org/wiki/Modbus
[21]. LTE RSSI, RSRP and RSRQ Measurement – CableFree
Retrieved from:
https://www.cablefree.net/wirelesstechnology/4glte/rsrp-rsrq-measurement-lte/
[22]. ShareTechnote. RSRP, RSRQ, RSSI, SINR Interplay
Retrieved from:
http://www.sharetechnote.com/html/Handbook_LTE_RSRP_RSRQ_SINR_Interplay.html
[23]. ShareTechnote. RSSI(Recieved Signal Strength Indicator)
Retrieved from:
http://www.sharetechnote.com/html/Handbook_LTE_RSSI.html
[24]. ShareTechnote. RSRP(Reference Signal Recieved Power)
Retrieved from:
http://www.sharetechnote.com/html/Handbook_LTE_RSRP.html
[25]. ShareTechnote. RSRQ(Reference Signal Recieved Quality)
Retrieved from:
http://www.sharetechnote.com/html/Handbook_LTE_RSRQ.html