本論文主要研究利用PHP網頁控制技術搭配MySQL資料庫進行智能照護中心照護設備系統開發，設備包含智能藥櫃、智能餐櫃及智能手臂。智能餐櫃與智能藥櫃透過PLC控制伺服馬達編碼器及步進馬達驅動器，進而操控餐櫃與藥櫃進行給料與存料之控制，並藉由NodeMCU之Tx、Rx輸出口，經RS485線路與PLC進行溝通，NodeMCU則與自行架設之Apache伺服器主機內PHP程式進行串接，達到網頁控制餐櫃與藥櫃設備之功效。此外，智能手臂則透過ESP32之Arduino晶片模組，控制六軸機械手臂之六組步進馬達驅動器 ，並藉由ESP32連線至指定伺服器之PHP網頁程式，達到網頁控制手臂之效果，並可將所有操作指令與歷史紀錄存入MySQL資料庫內；將以上模組進行搭配使用，即可達到智能給藥、智能供餐及智能倉儲管理之功能；最後，本研究使用市售一般型WebCam搭配PHP程式碼進行QRcode掃描，藉此確認每樣入庫料盤之身分別，以利於倉儲系統進行統計與管理，達到餐櫃與藥櫃之智能化效果。

This thesis mainly studies the use of PHP web control technology with MySQL database to develop a smart care center care equipment system, including intelligent medicine cabinets, intelligent food cabinets and intelligent arms. Intelligent food cabinets and intelligent medicine cabinets control servo motor encoders and step motor drives through PLC, as well as slender food cabinets and medicine cabinets for feeding and storage control, and through the Rx and Tx output ports of NodeMCU, via RS485 lines and PLC For communication, NodeMCU is connected with the Apache server host set up by itself through a PHP programmer to achieve the efficiency of web control of food cabinets and medicine cabinets. Going to the PHP webpage program of the designated server to achieve the effect of web control arm, and gradually store all operation commands and historical records into the MySQL database; use the above modules together to achieve intelligent administration, intelligent serveing and the function of intelligent warehouse management; finally, this research uses a commercially available general WebCam with PHP code to scan QRcode, and confirms the difference of each warehousing tray, so as to facilitate the statistics and management of the storage system to reach the food cabinet and medicine cabinet intelligent effect.

摘要..................................................................... i
ABSTRACT................................................................. ii
誌謝..................................................................... iv
目錄..................................................................... v
表目錄................................................................... viii
圖目錄................................................................... ix
第一章緒論............................................................... 1
1.1 研究背景............................................................. 1
1.2 文獻回顧............................................................. 3
1.3 研究動機與目的....................................................... 6
第二章基礎理論........................................................... 8
2.1 網頁程式語言與資料庫架設............................................. 8
2.1.1 智能照護中心....................................................... 8
2.1.2 PHP................................................................ 8
2.1.3 MySQL.............................................................. 9
2.1.4 Apache............................................................. 9
2.1.5 Ohsce ............................................................. 9
2.2 智能照護中心設備所使用之馬達......................................... 10
2.2.1 步進馬達........................................................... 10
2.2.2 步進馬達驅動器..................................................... 12
2.2.3 伺服馬達........................................................... 13
2.3 智能照護中心設備所使用之開發板....................................... 14
2.4 Arduino開發板........................................................ 14
2.4.1 Arduino IDE........................................................ 15
2.4.2 ESP8266與ESP-WROOM-32.............................................. 15
2.4.3 NodeMCU與ESP32 .................................................... 17
2.5 智能餐櫃與藥櫃之控制................................................. 19
2.5.1 PLC................................................................ 19
2.5.2 編輯軟體........................................................... 20
2.5.3 Modbus ............................................................ 21
2.5.4 序列埠............................................................. 21
2.5.5 Modbus ASCII....................................................... 22
第三章實驗架設........................................................... 23
3.1 智能手臂............................................................. 23
3.1.1 整體架構........................................................... 23
3.1.2 電控箱............................................................. 25
3.2 智能手臂網頁人機..................................................... 26
3.2.1 直接輸入指令....................................................... 26
3.2.2 動作名稱輸入....................................................... 26
3.3 智能餐櫃與藥櫃....................................................... 29
3.3.1 整體架構........................................................... 29
3.3.2 配電箱............................................................. 34
3.3.3 切換開關........................................................... 36
3.3.4 PLC控制指令........................................................ 38
3.4 智能餐櫃與藥櫃網頁人機............................................... 39
3.4.1 智能餐櫃與藥櫃操作流程............................................. 39
3.4.2 智能餐櫃網頁人機................................................... 40
3.4.3 智能藥櫃網頁人機................................................... 41
3.4.4 QRcode掃描畫面..................................................... 42
第四章結果與討論......................................................... 44
4.1 智能照護中心之應用................................................... 44
4.1.1 網頁控制收料與出料................................................. 44
4.1.2 內容物設定......................................................... 45
4.1.3 QRcode掃描餐點與藥物............................................... 47
4.1.4 遠端網頁控制....................................................... 50
4.2 智能手臂網頁人機開發................................................. 52
4.2.1 基本功能網頁架設................................................... 52
4.2.2 動作儲存........................................................... 54
4.2.3 緊急停止獨立迴路................................................... 54
4.3 智能餐櫃與藥櫃....................................................... 57
4.3.1 智能餐櫃與藥櫃PLC控制.............................................. 57
4.3.1.1 智能餐櫃與藥櫃配線路配置......................................... 57
4.3.1.2 PLC指令定義...................................................... 61
4.3.1.3 PLC防呆程式撰寫.................................................. 64
4.3.1.4 伺服馬達校正問題................................................. 70
4.3.2 智能餐櫃與藥櫃網頁開發............................................. 71
4.3.2.1 智能餐櫃與藥櫃資料庫架構......................................... 71
4.3.2.2 智能餐櫃與藥櫃收料與出料判斷..................................... 74
4.3.2.3 Ohsce程式應用.................................................... 76
4.3.2.4 智能餐櫃與藥櫃指令測試........................................... 76
4.3.2.5 回饋碼整理及運用................................................. 78
4.3.2.6 連續指令問題..................................................... 79
4.3.2.7 NodeMCU控制...................................................... 81
第五章結論............................................................... 83
第六章未來展望........................................................... 85
參考文獻................................................................. 86

[1] H. K. Mohajan, The First Industrial Revolution: Creation of a New Global Human Era, Journal of Social Sciences and Humantites, 2019.
[2] H. S. Jevons, The Second Industrial Revolution, The Economic Journal, 2015, pp. 1-18.
[3] G. de Vasconcelos, The Third Industrial Revolution - Internet, Energy And A New Financial System, Entrepreneurs, 2015.
[4] 賀桂芬、辜樹仁，工業4.0：58秒的競爭，天下雜誌，2016。
[5] E. Howard, The Evolution of the Industrial Ages: Industry 1.0 to 4.0, Simio Forward Thinking, 2018.
[6] L.L.C. Simio, Simio’s 8 Reasons to Adopt Industry 4.0, PR Newswire, 2018.
[7] VDI Verlag GmbH, Industrie 4.0: Mit dem Internet der Dinge auf dem Weg zur 4. industriellen Revolution, VDI-Nachrichten, 2011.
[8] T. M. B‥ohler, Industrie 4.0 – Smarte Produkte und Fabriken revolutionieren die Industrie, Produktion Magazin, 2014.
[9] M. Luenendonk, Industry 4.0: Definition, Design Principles, Challenges, and the Future of Employment, CLEVERISM Magazine, 2017.
[10] 盧昱霖，工業4.0智能技術在長照及製造系統產品開發，碩士論文，國立台北科技大學，台北，2019，第90-102頁。
[11] United Nations Population Fund, Population Ageing is One of the Most Significant Trends of 21st Century, United Nations, 2018.
[12] 國家法展委員會，高齡化指標，國家法展委員會人口推估查詢系統，2018。
[13] 經濟部，全球人口老化之現況與趨勢，經濟會人力規劃處，2013。
[14] 周岱蓉，長期照顧機構經營之研究，碩士論文，國立宜蘭大學，宜蘭，2018，第4-6頁。
[15] 傅千育、李如婷，高齡社會照顧服務及智慧醫療之現況與發展，2016，第84-91頁。
[16] 巖淑伊、華慧敏，高齡化社會之外籍看護工人力需求分析，2016，第207-208頁。
[17] 勞動統計查詢網，https://statdb.mol.gov.tw/evta/jspProxy.aspx， 到訪日：2020/6/25。
[18] 內政部，內政統計通報109年第10周，內政部統計處，2020。
[19] 黃富順，高齡化社會的挑戰與因應，成人及終身教育，2011，第2-15頁。
[20] S. Caspar, A. Phinney, S. Spenceley and P. Ratner, Creating Cultures of Care: Exploring the Social Organization of Care Delivery in Long-Term Care Homes, Journal of Long-Term Care, 2019
[21] 我國長期照顧十年計畫摘要本，衛生福利部，2007。
[22] 長期照顧十年計畫2.0，衛生福利部，2016。
[23] 魏嘉賢，雲端健康照護之研究-以台灣基督教門諾醫院為例，碩士論文，國立東華大學，花蓮，第69-73頁。
[24] C. Evans, Smart Care Spaces: Pervasive Sensing Technologies for At-Home Care, International Journal of Ad Hoc and Ubiquitous Computing, 2012.
[25] 李家昶，智慧照護-樂齡陪伴機器人之智能感知技術探索，工研院，2018。
[26] T. S. Busse, S. Kernebeck, L. Nef and J. P. Ehlers, What Role for Social Robots in Nursing: A qualitative expert-foresight workshop (Preprint), British Journal of Community Nursing, 2020.
[27] C. H. Lee, Y. S. Chung and M. Moon, The Effect of Smart Care Ubiquitous Health Service on Hypertension Management, Medicine, 2013.
[28] Y. S. Chung, Y. Kim, C. H. Lee, Effectiveness of the Smart Care Service for Diabetes Management, Healthcare Informatics Research, 2014.
[29] E. S. Ha, The Implementation of Smart Care System for Dementia Patients, Journal Korean Acad, 2014.
[30] Y. S. Hong, Smart Care Beds for Elderly Patients with Impaired Mobility, Wireless Communications and Mobile Computing, 2018.
[31] M. Hagland, Smart Rooms, Smart Care Delivery: UPMC Clinician Leaders Leverage Technology for Greater Effectiveness in Patient Care, Healthc Inform, 2011.
[32] C. Evans, F. Xhafa, Smart Care Spaces: Needs for Intelligent At-Home Care , International Journal of Space-Based and Situated Computing, 2013.
[33] D. Yamunathagam, G. Shobana, M. Suguna, Smart Care-Predictive Maintenance System in Washing Machine Using IOT, Journal of Advanced Rearch in Dynamical and Control Systems, 2018, pp. 914-917
[34] 陳昱廷，物聯網推波助瀾　智慧家庭應用加速發展，新通訊元件雜誌，2017。
[35] 梁永漢，工業4.0智能工廠與智慧藥櫃技術開發，碩士論文，國立台北科技大學，台北，2019。
[36] 柯力端，機械製造結合工業4.0之智能工廠整合技術開發，碩士論文，國立台北科技大學，台北，2019。
[37] J. Meloni, PHP, MySQL and Apache, Sams Publishing, 2007.
[38] D. Marc, Mastering PHPMyAdmin 2.11 for Effective MySQL Managent, Packt Publishing, 2008.
[39] 吳建達，動態網頁應用程式調校-以Apache+PHP+MySQL為例，碩士論文，國立清華大學，新竹，2006，第8-14頁。
[40] P. Cowburn, PHP Manual, PHP Documentation Group, 2020.
[41] E. L. Barnes, 25 Years of PHP with Rasmus Lerdorf, Laravel News, 2019.
[42] D. Sklar, Learning PHP: A Pain-Free Introduction to Building Interactive Websites, Orelly, 2016.
[43] D. Marc, Mastering PHPMyAdmin 2.11 for Effective MySQL Management, Packt Publishing, 2008.
[44] F. M. Kromann, Beginning PHP and MySQL, Apress Publishing, 2018, pp.14-22.
[45] D. Marc, Creating Your MySQL Database : Practical Design Tips and Techniques, Packet Publishing, 2006.
[46] K. H. Lu, Design and Analysis of Open Source Software Based on the Virtual Host Management System, 2011.
[47] Ohsec開發教程，https://www.w3cschool.cn/ohsce/，到訪日：2020/5/25。
[48] National Instruments, Basic Motor Teaching: Motor Principles and Types, 2019.
[49] 台灣東方馬達，由步進馬達的基礎認識到使用方法，台灣東方馬達技術研討會，2013，第3-55頁。
[50] 鄭自宏，線性步進馬達滑台設計與製作，碩士論文，國立聯合大學，苗栗，2018，第18-23頁。
[51] 吳峰政，步進馬達控制之人機介面的開發，碩士論文，國立嘉義大學，嘉義，2019，第13-15頁。
[52] Structure of Stepper Motors, https://www.orientalmotor.com/steppermotors/technology/stepper-motor-overview.html, Visted: 2020/6/15.
[53] Matthew Scarpino, MOTORS for MAKERS, Que Publishing, 2015.
[54] Working Principle of Stepper Motor, https://www.electronicwings.com/sensorsmodules/stepper-motor, Visted: 2020/6/15.
[55] DFROBOT， 步進馬達專用驅動器TB6600使用說明，https://www.dfrobot.com.cn/images/upload/File/DRI0043/20161012102520yg1obn.pdf，到訪日：2020/6/5。
[56] 劉晉源，直流伺服馬達之儀表與控制韌體開發，碩士論文，國立中正大學，嘉義，2019，第5-12頁。
[57] 士林電機，士林伺服SDE系列伺服馬達，士林電機，2020。
[58] N. Zambetti, https://www.arduino.cc/en/Main/ArduinoBoardSerial, Visted: 2020/6/6.
[59] 林璟佑，智慧居家生活之一氧化碳防範研究—以Ardunio為例，碩士論文，建國科技大學，彰化，2017，第39-47頁。
[60] 劉咸章，以Arduino實現遠程醫療保健系統中的呼吸速率量測器，碩士論文，健行科技大學，桃園，2019，第15-19頁。
[61] H. Major, Comparison of the Differences between Arduino Development Boards，https://hanmajor.blogspot.com/2013/10/arduino.html, Visted: 2020/6/7。
[62] M. C. Ramon, Arduino IDE and Wiring Language, Professional and Applied Computing, 2013, pp.93-143.
[63] M. McRoberts, Beiginning Arduino, Apress Publishing, 2003, pp. 2-5.
[64] S. Marco, Internet of Things with the Arduino Y’un projects to Help You Build aWorld of Smarter Things, Packt Publishing, 2014.
[65] Y. Sadik and B. Mustafa, Web Based Smart Meter for General Purpose Smart Home Systems with ESP8266, International Symposium on Multidisciplinary Studies and Innovative Technologie, 2019.
[66] S. P. Makhanya, E. M. Dogo, N. I. Nwulu and U. Damisa, A Smart Switch Control System Using ESP8266 Wi-Fi Module Integrated with an Android Application, IEEE Expolre, 2019.
[67] S. Santos, ESP32 vs ESP8266 – Pros and Cons, Maker Advisor, 2020.
[68] 羅峻譯，以NodeMCU以及MIT App Inventor 2在Android行動裝置上的研究-開發具有GPS移動偵測以及UV量測功能的智慧衣系統，碩士論文，國立交通大學，新竹市，2017，第24-26頁。
[69] 廖文煇，可程式控制器應用-基礎篇，全華出版社，2018，第25-30頁。
[70] DELTA，DVP-PLC編程實作範例，台達電子工業股份有限公司，2008。
[71] DELTA，DVP-PLC應用技術手冊(程式篇)， 台達電子工業股份有限公司，2014，第14-52頁。
[72] National Instruments， 深入了解Modbus協定，https://www.ni.com/zhtw/innovations/white-papers/14/the-modbus-protocol-in-depth.html， 到訪日:2020/5/9。
[73] Delta，DELTA產品MODBUS RS-485通訊設定，台達電子工業股份有限公司，2014。
[74] A. Jan, Serial Port Complete:COM Ports, USB Virtual COM Ports, and Ports for Embedded Systems, Lakeview Research, 2007.
[75] S. Pradeeka, Building Arduino PLCs: the Essential Techniques You Need to Develop Arduino-Based PLCs / by Pradeeka Seneviratne, Apress, 2017, pp.15-26.
[76] 北島李工，「MODBUS協議的ASCII模式和RTU模式有什麼不同？」，每日頭條，2019。
[77] ASCII碼介紹，http://kevin.hwai.edu.tw/ kevin/material/JAVA/Sample2016/ASCII.htm，到訪日:2020/6/9。