2023年8月27日 星期日

實驗2-1 Node-RED , MQTT , ESP32 LED , SQLite , Line Notify (利用ESP32 multitasking)

 實驗2-1 Node-RED , MQTT , ESP32 LED , SQLite , Line Notify (利用ESP32 multitasking)









[{"id":"f7dae001c3314160","type":"comment","z":"bfec384c4faa9831","name":"Node-Red publish 到 HiveMQ Broker  , ESP32訂閱","info":"將 alex9ufo/inTopic 到(publish)HiveMQ Broker \n給 Arduino 訂閱(Subscribe)","x":210,"y":40,"wires":[]},{"id":"dbc2bfd8348eec63","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":1,"width":2,"height":1,"passthru":false,"label":"LED 開","tooltip":"","color":"white","bgcolor":"","className":"","icon":"fa-circle","payload":"on","payloadType":"str","topic":"","topicType":"str","x":80,"y":80,"wires":[["0fcc2c03fddd02b1"]]},{"id":"cde8627353ccec65","type":"mqtt out","z":"bfec384c4faa9831","name":"Control LED","topic":"alex9ufo/esp32/led","qos":"1","retain":"true","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"70940176.2b2d3","x":430,"y":100,"wires":[]},{"id":"e24b7e110800a06c","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":2,"width":2,"height":1,"passthru":false,"label":"LED 關","tooltip":"","color":"black","bgcolor":"","className":"","icon":"fa-circle-o","payload":"off","payloadType":"str","topic":"","topicType":"str","x":80,"y":120,"wires":[["0fcc2c03fddd02b1"]]},{"id":"d970e8fdf4530916","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":7,"width":2,"height":1,"passthru":false,"label":"LED 閃爍","tooltip":"","color":"black","bgcolor":"","className":"","icon":"fa-circle-o","payload":"flash","payloadType":"str","topic":"","topicType":"str","x":80,"y":160,"wires":[["0fcc2c03fddd02b1"]]},{"id":"812263efbd257749","type":"ui_text","z":"bfec384c4faa9831","group":"bcc5d75a99cd926e","order":8,"width":8,"height":1,"name":"","label":"Node-RED發行到MQTT的資料","format":"{{msg.payload}}","layout":"row-left","className":"","x":470,"y":140,"wires":[]},{"id":"951bd841abaf9ec2","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":5,"width":2,"height":1,"passthru":false,"label":"LED反向","tooltip":"","color":"black","bgcolor":"","className":"","icon":"fa-circle-o","payload":"toggle","payloadType":"str","topic":"","topicType":"str","x":80,"y":200,"wires":[["0fcc2c03fddd02b1"]]},{"id":"42cce06e0e1c8c30","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":4,"width":2,"height":1,"passthru":false,"label":"LED 定時5秒","tooltip":"","color":"black","bgcolor":"","className":"","icon":"fa-circle-o","payload":"timer","payloadType":"str","topic":"","topicType":"str","x":90,"y":240,"wires":[["0fcc2c03fddd02b1"]]},{"id":"0172f5806f2ca578","type":"ui_audio","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","voice":"Google US English","always":true,"x":560,"y":220,"wires":[]},{"id":"54711505154b656f","type":"comment","z":"bfec384c4faa9831","name":"Node-Red  subscribe HiveMQ Broker  , ESP32發行","info":"將 alex9ufo/inTopic 到(publish)HiveMQ Broker \n給 Arduino 訂閱(Subscribe)","x":200,"y":280,"wires":[]},{"id":"80030d0c3958e845","type":"comment","z":"bfec384c4faa9831","name":"Line Notify Message ","info":"","x":610,"y":260,"wires":[]},{"id":"a073d5b3a5535cf6","type":"function","z":"bfec384c4faa9831","name":"Set Line API ","func":"msg.headers = {'content-type':'application/x-www-form-urlencoded','Authorization':'Bearer A4wwPNh2WqB7dlfeQyyIAwtggn1kfZSI5LkkCdia1gB'};\nmsg.payload = {\"message\":msg.payload};\nreturn msg;\n\n//oR7KdXvK1eobRr2sRRgsl4PMq23DjDlhfUs96SyUBZu","outputs":1,"noerr":0,"x":470,"y":300,"wires":[["8349d1f3d7a98121"]]},{"id":"e5420d3f682a2646","type":"mqtt in","z":"bfec384c4faa9831","name":"LED status ","topic":"alex9ufo/esp32/led_status","qos":"2","datatype":"utf8","broker":"841df58d.ee5e98","nl":false,"rap":true,"rh":0,"inputs":0,"x":80,"y":320,"wires":[["7cb9d91737b872eb"]]},{"id":"7cb9d91737b872eb","type":"function","z":"bfec384c4faa9831","name":"function 63","func":"msg.payload=\" ---ESP32回來資料---\" +msg.payload;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":250,"y":320,"wires":[["b6d4e95834b3e0b2","1b7d27c545c0f092","a073d5b3a5535cf6"]]},{"id":"8349d1f3d7a98121","type":"http request","z":"bfec384c4faa9831","name":"","method":"POST","ret":"txt","paytoqs":false,"url":"https://notify-api.line.me/api/notify","tls":"","persist":false,"proxy":"","authType":"","x":620,"y":300,"wires":[["c552b46647524559"]]},{"id":"c552b46647524559","type":"debug","z":"bfec384c4faa9831","name":"debug ","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":750,"y":300,"wires":[]},{"id":"74c7723fda8e695c","type":"ui_audio","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","voice":"en-US","always":"","x":700,"y":380,"wires":[]},{"id":"1b7d27c545c0f092","type":"delay","z":"bfec384c4faa9831","name":"","pauseType":"delay","timeout":"1","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":440,"y":340,"wires":[["74c7723fda8e695c","63988fb30136c625"]]},{"id":"b6d4e95834b3e0b2","type":"ui_text","z":"bfec384c4faa9831","group":"bcc5d75a99cd926e","order":10,"width":8,"height":1,"name":"","label":"Node-RED 訂閱MQTT的資料","format":"{{msg.payload}}","layout":"row-left","className":"","x":500,"y":380,"wires":[]},{"id":"984acdd346d0bfb5","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":15,"width":3,"height":1,"passthru":false,"label":"建立資料庫","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"建立資料庫","payloadType":"str","topic":"topic","topicType":"msg","x":90,"y":440,"wires":[["3c17346ebaadcc29","cebc47e42b341ffe"]]},{"id":"3c17346ebaadcc29","type":"function","z":"bfec384c4faa9831","name":"CREATE DATABASE","func":"\n\n//CREATE TABLE \"LEDtable\" (\n//\t\"id\"\tINT NOT NULL,\n//  \"Status\"  TEXT,\n//  \"Ldate\" DATE, \n//  \"Ltime\" TIME\n//\tPRIMARY KEY(\"id\")\n//);\nmsg.topic = \"CREATE TABLE LEDtable(id INTEGER PRIMARY KEY AUTOINCREMENT, Status TEXT, Ldate DATE, Ltime TIME)\";\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":300,"y":480,"wires":[["090c3511cbd3d21a"]]},{"id":"cebc47e42b341ffe","type":"ui_audio","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":260,"y":440,"wires":[]},{"id":"cbfa761aac341775","type":"function","z":"bfec384c4faa9831","name":"檢視資料","func":"\n//CREATE TABLE \"RFIDtable\" (\n//\t\"id\"\tINT NOT NULL,\n//  \"Status\"  TEXT,\n//  \"Ldate\" DATE, \n//  \"Ltime\" TIME\n//\tPRIMARY KEY(\"id\")\n//);\n\n//SELECT * FROM RFIDtable ORDER BY  id DESC LIMIT 50;\n\nmsg.topic = \"SELECT * FROM LEDtable ORDER BY id DESC LIMIT 50\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":540,"y":540,"wires":[["4602c172fa6b66ea"]]},{"id":"090c3511cbd3d21a","type":"sqlite","z":"bfec384c4faa9831","mydb":"590d3de91eaf27bf","sqlquery":"msg.topic","sql":"","name":"My_LED_database","x":530,"y":480,"wires":[["cbfa761aac341775","79fcb800cd598e68"]]},{"id":"4602c172fa6b66ea","type":"sqlite","z":"bfec384c4faa9831","mydb":"590d3de91eaf27bf","sqlquery":"msg.topic","sql":"","name":"My_LED_database","x":710,"y":540,"wires":[["9e060230c9354091"]]},{"id":"9e060230c9354091","type":"ui_table","z":"bfec384c4faa9831","group":"bcc5d75a99cd926e","name":"","order":17,"width":12,"height":8,"columns":[],"outputs":0,"cts":false,"x":870,"y":540,"wires":[]},{"id":"33b812997a1eaaf9","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":16,"width":6,"height":1,"passthru":false,"label":"檢視資料庫資料","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"檢視資料","payloadType":"str","topic":"topic","topicType":"msg","x":100,"y":540,"wires":[["99846cf16ee4af96","cbfa761aac341775"]]},{"id":"99846cf16ee4af96","type":"ui_audio","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":280,"y":520,"wires":[]},{"id":"2e0974f4d7c58555","type":"function","z":"bfec384c4faa9831","name":"function ","func":"var temp= msg.payload;\nmsg.payload= \"新增一筆資料\" + temp;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":280,"y":640,"wires":[["8305de5e9264b0bc"]]},{"id":"c69e8880a8799c71","type":"ui_text","z":"bfec384c4faa9831","group":"bcc5d75a99cd926e","order":9,"width":4,"height":2,"name":"","label":"LED Status","format":"<font face='arial'><font size=4><font color={{fcolor}}>{{msg.payload}}","layout":"row-left","className":"","x":690,"y":640,"wires":[]},{"id":"a99150555b9286ba","type":"function","z":"bfec384c4faa9831","name":"INSERT","func":"var Today = new Date();\nvar yyyy = Today.getFullYear(); //年\nvar MM = Today.getMonth()+1;    //月\nvar dd = Today.getDate();       //日\nvar h = Today.getHours();       //時\nvar m = Today.getMinutes();     //分\nvar s = Today.getSeconds();     //秒\nif(MM<10)\n{\n   MM = '0'+MM;\n}\n\nif(dd<10)\n{\n   dd = '0'+dd;\n}\n\nif(h<10)\n{\n   h = '0'+h;\n}\n\nif(m<10)\n{\n  m = '0' + m;\n}\n\nif(s<10)\n{\n  s = '0' + s;\n}\nvar var_date = yyyy+'/'+MM+'/'+dd;\nvar var_time = h+':'+m+':'+s;\n\nvar myLED = msg.payload;\n\n\nmsg.topic = \"INSERT INTO LEDtable ( Status , Ldate, Ltime ) VALUES ($myLED,  $var_date ,  $var_time ) \" ;\nmsg.payload = [myLED, var_date , var_time ]\nreturn msg;\n\n//CREATE TABLE \"LEDtable\" (\n//\t\"id\"\tINT NOT NULL,\n//  \"Status\"  TEXT,\n//  \"Ldate\" DATE, \n//  \"Ltime\" TIME\n//\tPRIMARY KEY(\"id\")\n//);","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":280,"y":600,"wires":[["090c3511cbd3d21a","2f37f0399feb180d"]]},{"id":"79fcb800cd598e68","type":"debug","z":"bfec384c4faa9831","name":"debug ","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":730,"y":480,"wires":[]},{"id":"2f37f0399feb180d","type":"debug","z":"bfec384c4faa9831","name":"debug ","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":430,"y":600,"wires":[]},{"id":"cf8fb7ae79a7894c","type":"mqtt in","z":"bfec384c4faa9831","name":"LED status ","topic":"alex9ufo/esp32/led_status","qos":"2","datatype":"utf8","broker":"841df58d.ee5e98","nl":false,"rap":true,"rh":0,"inputs":0,"x":80,"y":600,"wires":[["a99150555b9286ba","2e0974f4d7c58555","4fc9f5403d05abf2"]]},{"id":"8305de5e9264b0bc","type":"change","z":"bfec384c4faa9831","name":"","rules":[{"t":"set","p":"fcolor","pt":"msg","to":"red","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":440,"y":640,"wires":[["c69e8880a8799c71"]]},{"id":"c6125fb76a7fc1af","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":11,"width":3,"height":1,"passthru":false,"label":"刪除一筆資料","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"刪除一筆資料","payloadType":"str","topic":"topic","topicType":"msg","x":100,"y":680,"wires":[["0d2bdf1382ec6de6","929a0f12e6d7706d"]]},{"id":"616db8f2855471e2","type":"function","z":"bfec384c4faa9831","name":"確認 刪除","func":"var del_id = flow.get(\"idtemp\");\n\nmsg.topic = \"DELETE FROM LEDtable WHERE id= ($del_id) \" ;\nmsg.payload = [del_id]\n\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":480,"y":740,"wires":[["d9106170c3221428"]]},{"id":"d9106170c3221428","type":"sqlite","z":"bfec384c4faa9831","mydb":"590d3de91eaf27bf","sqlquery":"msg.topic","sql":"DELETE FROM dhtreadings WHERE id =  VALUES ($theid)","name":"My_LED_database","x":710,"y":740,"wires":[["cbfa761aac341775"]]},{"id":"db47617b0c9644d4","type":"debug","z":"bfec384c4faa9831","name":"debug 158","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":670,"y":820,"wires":[]},{"id":"47898d2d6a579a1d","type":"function","z":"bfec384c4faa9831","name":"SELECT ALL","func":"var del_idtemp=msg.payload;\nflow.set(\"idtemp\", del_idtemp);\n\nmsg.topic = \"SELECT * FROM LEDtable \";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":390,"y":820,"wires":[["4226de1a2c6402ec","db47617b0c9644d4"]]},{"id":"41b0a12dd8b06e59","type":"ui_numeric","z":"bfec384c4faa9831","name":"","label":"刪除的database_id","tooltip":"","group":"bcc5d75a99cd926e","order":12,"width":5,"height":1,"wrap":false,"passthru":true,"topic":"topic","topicType":"msg","format":"{{value}}","min":"1","max":"100","step":1,"className":"","x":110,"y":820,"wires":[["a7e7d69290dc1425","47898d2d6a579a1d"]]},{"id":"aefb902f83df4c6b","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":14,"width":3,"height":1,"passthru":false,"label":"刪除所有資料","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"刪除所有資料","payloadType":"str","topic":"topic","topicType":"msg","x":100,"y":900,"wires":[["a7e7d69290dc1425","2bb2a378d4274192"]]},{"id":"025ac1787ba3952e","type":"ui_button","z":"bfec384c4faa9831","name":"","group":"bcc5d75a99cd926e","order":13,"width":4,"height":1,"passthru":false,"label":"刪除資料庫","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"刪除資料庫","payloadType":"str","topic":"topic","topicType":"msg","x":90,"y":940,"wires":[["a7e7d69290dc1425","209c0d435b18b850"]]},{"id":"a665f6f582a9f77c","type":"function","z":"bfec384c4faa9831","name":"刪除資料庫","func":"//DROP TABLE LEDtable\nmsg.topic = \"DROP TABLE LEDtable\";\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":630,"y":940,"wires":[["4226de1a2c6402ec"]]},{"id":"f8c86f7fd5094c39","type":"function","z":"bfec384c4faa9831","name":"刪除所有資料","func":"//DELETE from LEDtable\nmsg.topic = \"DELETE from LEDtable\";\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":620,"y":900,"wires":[["4226de1a2c6402ec"]]},{"id":"a7e7d69290dc1425","type":"ui_audio","z":"bfec384c4faa9831","name":"","group":"9eb91d4467c6eec5","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":280,"y":980,"wires":[]},{"id":"4226de1a2c6402ec","type":"sqlite","z":"bfec384c4faa9831","mydb":"590d3de91eaf27bf","sqlquery":"msg.topic","sql":"","name":"My_LED_database","x":810,"y":900,"wires":[["635fd1b5abfa8a5a","cbfa761aac341775"]]},{"id":"635fd1b5abfa8a5a","type":"debug","z":"bfec384c4faa9831","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":990,"y":920,"wires":[]},{"id":"0d2bdf1382ec6de6","type":"ui_audio","z":"bfec384c4faa9831","name":"","group":"9eb91d4467c6eec5","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":300,"y":680,"wires":[]},{"id":"929a0f12e6d7706d","type":"ui_toast","z":"bfec384c4faa9831","position":"prompt","displayTime":"3","highlight":"","sendall":true,"outputs":1,"ok":"OK","cancel":"Cancel","raw":true,"className":"","topic":"","name":"","x":110,"y":760,"wires":[["9324d99e6ea38ff9"]]},{"id":"c793468c651c5fb5","type":"debug","z":"bfec384c4faa9831","name":"debug 160","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":490,"y":700,"wires":[]},{"id":"49e629d983852399","type":"inject","z":"bfec384c4faa9831","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":"1","topic":"","payload":"","payloadType":"date","x":100,"y":1020,"wires":[["b75ccba7780f6602"]]},{"id":"b75ccba7780f6602","type":"function","z":"bfec384c4faa9831","name":"SELECT ALL","func":"var del_idtemp=1;\nflow.set(\"idtemp\", del_idtemp);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":290,"y":1020,"wires":[[]]},{"id":"9324d99e6ea38ff9","type":"function","z":"bfec384c4faa9831","name":"function 65","func":"var topic=msg.payload;\nif (topic==\"\"){\n    return [msg,null];\n    \n}\nif (topic==\"Cancel\"){\n    return [null,msg];\n    \n}\nreturn msg;","outputs":2,"noerr":0,"initialize":"","finalize":"","libs":[],"x":270,"y":760,"wires":[["616db8f2855471e2","c793468c651c5fb5"],["f156bde85ff820ac"]]},{"id":"f156bde85ff820ac","type":"debug","z":"bfec384c4faa9831","name":"debug 161","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":490,"y":780,"wires":[]},{"id":"2bb2a378d4274192","type":"ui_toast","z":"bfec384c4faa9831","position":"prompt","displayTime":"3","highlight":"","sendall":true,"outputs":1,"ok":"OK","cancel":"Cancel","raw":true,"className":"","topic":"","name":"","x":290,"y":900,"wires":[["9a211ebe57d83487"]]},{"id":"9a211ebe57d83487","type":"function","z":"bfec384c4faa9831","name":"function 66","func":"var topic=msg.payload;\nif (topic==\"\"){\n    return [msg,null];\n    \n}\nif (topic==\"Cancel\"){\n    return [null,msg];\n    \n}\nreturn msg;","outputs":2,"noerr":0,"initialize":"","finalize":"","libs":[],"x":450,"y":900,"wires":[["f8c86f7fd5094c39"],[]]},{"id":"209c0d435b18b850","type":"ui_toast","z":"bfec384c4faa9831","position":"prompt","displayTime":"3","highlight":"","sendall":true,"outputs":1,"ok":"OK","cancel":"Cancel","raw":true,"className":"","topic":"","name":"","x":290,"y":940,"wires":[["a4b961e07d638f37"]]},{"id":"a4b961e07d638f37","type":"function","z":"bfec384c4faa9831","name":"function 67","func":"var topic=msg.payload;\nif (topic==\"\"){\n    return [msg,null];\n    \n}\nif (topic==\"Cancel\"){\n    return [null,msg];\n    \n}\nreturn msg;","outputs":2,"noerr":0,"initialize":"","finalize":"","libs":[],"x":470,"y":940,"wires":[["a665f6f582a9f77c"],[]]},{"id":"2b3c135cd918b6ff","type":"ui_toast","z":"bfec384c4faa9831","position":"top right","displayTime":"3","highlight":"","sendall":true,"outputs":0,"ok":"OK","cancel":"Cancel","raw":false,"className":"","topic":"","name":"","x":590,"y":180,"wires":[]},{"id":"0fcc2c03fddd02b1","type":"link out","z":"bfec384c4faa9831","name":"link out 20","mode":"link","links":["49f4623ee3304332"],"x":225,"y":140,"wires":[]},{"id":"49f4623ee3304332","type":"link in","z":"bfec384c4faa9831","name":"link in 20","links":["0fcc2c03fddd02b1"],"x":275,"y":140,"wires":[["812263efbd257749","cde8627353ccec65","bfa5f20eefe2d124"]]},{"id":"bfa5f20eefe2d124","type":"function","z":"bfec384c4faa9831","name":"function 72","func":"var a=msg.payload;\nmsg.payload=\"LED \" +a;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":410,"y":180,"wires":[["2b3c135cd918b6ff","0172f5806f2ca578"]]},{"id":"63988fb30136c625","type":"ui_toast","z":"bfec384c4faa9831","position":"top right","displayTime":"3","highlight":"","sendall":true,"outputs":0,"ok":"OK","cancel":"Cancel","raw":false,"className":"","topic":"","name":"","x":730,"y":340,"wires":[]},{"id":"4fc9f5403d05abf2","type":"debug","z":"bfec384c4faa9831","name":"debug 165","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":290,"y":560,"wires":[]},{"id":"bcc5d75a99cd926e","type":"ui_group","name":"LED CONTROL","tab":"e01b6f.a9d07c9","order":2,"disp":true,"width":12,"collapse":false,"className":""},{"id":"70940176.2b2d3","type":"mqtt-broker","name":"","broker":"broker.mqtt-dashboard.com","port":"1883","clientid":"","autoConnect":true,"usetls":false,"protocolVersion":4,"keepalive":"15","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"841df58d.ee5e98","type":"mqtt-broker","name":"","broker":"broker.mqtt-dashboard.com","port":"1883","clientid":"","autoConnect":true,"usetls":false,"compatmode":false,"protocolVersion":4,"keepalive":"15","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"590d3de91eaf27bf","type":"sqlitedb","db":"C:\\Users\\User\\.node-red\\2023LED.db","mode":"RWC"},{"id":"9eb91d4467c6eec5","type":"ui_group","name":"Default","tab":"23af251c8a87881d","order":1,"disp":true,"width":"14","collapse":false,"className":""},{"id":"e01b6f.a9d07c9","type":"ui_tab","name":"Home","icon":"dashboard","disabled":false,"hidden":false},{"id":"23af251c8a87881d","type":"ui_tab","name":"Home_RFID","icon":"dashboard","disabled":false,"hidden":false}]



//wifi &  MQTT
#include <WiFi.h>
#include <PubSubClient.h>

//RC522 SPI Mode
#include <SPI.h>
#include <MFRC522.h>

//GPIO 2 D1 Build in LED
#define LED 2


// WiFi
const char *ssid = "alex9ufo"; // Enter your Wi-Fi name
const char *password = "alex9981";  // Enter Wi-Fi password

// MQTT Broker
const char *mqtt_broker = "broker.mqtt-dashboard.com";
const char *topic1 = "alex9ufo/esp32/led";
const char *topic2 = "alex9ufo/esp32/RFID";   //in this program not uesd
const char *topic = "alex9ufo/esp32/Starting";
const char *topic3 = "alex9ufo/esp32/led_status";  

const char *mqtt_username = "alex9ufo";
const char *mqtt_password = "public";
const int mqtt_port = 1883;

bool ledState = false;
bool atwork = false;


WiFiClient espClient;
PubSubClient client(espClient);


String json = "";
bool Flash = false;  //true
bool Timer = false;  //true
bool Send = false;  //true
int Count= 0;

char jsonChar1[50];  //client.publish("alex9ufo/Esp32/RFID"
//宣告任務Task1
TaskHandle_t Task1;

// Wifi reconnect
unsigned long previousMillis = 0;
unsigned long interval = 30000;
//===========================================================
//任務1副程式Task1_senddata
void Task1_senddata(void * pvParameters ) {
  //無窮迴圈
  for (;;) {
   
    if (client.connected()) {        
        if (Send) {
          // Convert JSON string to character array
          json.toCharArray(jsonChar1, json.length()+1);
          Serial.print("Publish message: ");
          Serial.println(json);
          // Publish JSON character array to MQTT topic
          client.publish(topic3,jsonChar1); //"alex9ufo/esp32/led_status";
        }
        Send = false;    
    }
    else
    {
      if (WiFi.status() != WL_CONNECTED)  {
        Serial.println("Reconnecting to WiFi...");
        WiFi.disconnect();
        WiFi.reconnect();
      }
    }

   
  //Task1休息,delay(X)不可省略
  delay(1000);
  }
}
//===========================================================

void setup_wifi() {
  delay(10);
  // We start by connecting to a WiFi network
  Serial.println();
  Serial.print("Connecting to ");
  Serial.println(ssid);

  WiFi.begin(ssid, password);

  while (WiFi.status() != WL_CONNECTED) {
    delay(500);
    Serial.print(".");
  }

  Serial.println("");
  Serial.println("WiFi connected");
  Serial.println("IP address: ");
  Serial.println(WiFi.localIP());
}    

//===========================================================
void callback(char *topic, byte *payload, unsigned int length) {
    Serial.print("Message arrived in topic: ");
    Serial.println(topic);
    Serial.print("Message: ");
    String message;
    for (int i = 0; i < length; i++) {
        message += (char) payload[i];  // Convert *byte to string
    }
    Serial.print(message);
    if (message == "on" && !ledState) {
        digitalWrite(LED, HIGH);  // Turn on the LED
        ledState = true;  //ledState = ture HIGH
        Flash = false;
        Timer = false;
        json ="ON";
        Send = true ;
    }
    if (message == "off" && ledState) {
        digitalWrite(LED, LOW); // Turn off the LED
        ledState = false; //ledState = false LOW
        Flash = false;
        Timer = false;
        json ="OFF";
        Send = true ;

    }
    if (message == "flash" ) {
        digitalWrite(LED, LOW); // Turn off the LED
        Flash = true;
        Timer = false;
        json ="FLASH";
        Send = true ;        

    }
    if (message == "timer" ) {
        digitalWrite(LED, LOW); // Turn off the LED
        Flash = false;
        Timer = true;
        json ="TIMER";
        Send = true ;
        Count= 11;
    }

    if (message == "toggle" ) {
        digitalWrite(LED, !digitalRead(LED));   // Turn the LED toggle
        if (digitalRead(LED))
            ledState = true;
        else
            ledState = false;
       
        Flash = false;
        Timer = false;
        json ="TOGGLE";
        Send = true ;        
    }

    Serial.println();
    Serial.println("-----------------------");
}
//===========================================================
void reconnect() {
  // Loop until we're reconnected
  while (!client.connected()) {
    Serial.print("Attempting MQTT connection...");
    // Attempt to connect

    if (client.connect("esp32-client-")) {
      Serial.println("connected");
      // Subscribe
      client.subscribe("alex9ufo/esp32/led");
      client.subscribe("alex9ufo/esp32/RFID");      
    } else {
      Serial.print("failed, rc=");
      Serial.print(client.state());
      Serial.println(" try again in 5 seconds");
      // Wait 5 seconds before retrying
      delay(5000);
      if (WiFi.status() != WL_CONNECTED)  {
        Serial.println("Reconnecting to WiFi...");
        WiFi.disconnect();
        WiFi.reconnect();
      }
    }
  }
}
//===========================================================
void LED_flash_timer() {
  if (Flash){
    digitalWrite(LED, !digitalRead(LED));
    delay(500);
    if (digitalRead(LED))
      ledState = true;
    else
      ledState = false;
  } //(Flash)
       
  if (Timer) {
    digitalWrite(LED, HIGH);
    delay(500);
    if (digitalRead(LED))
        ledState = true;
    else
        ledState = false;

    Count=Count-1;
    if (Count == 0 ){
        Timer=false;
        digitalWrite(LED, LOW);
        ledState = false;
    }
  } //(Timer)

}
 //===========================================================  
void setup() {
    // Set software serial baud to 115200;
    Serial.begin(115200);
    delay(1000); // Delay for stability
    //======================================================
    // Connecting to a WiFi network
    setup_wifi();
    // Setting LED pin as output
    pinMode(LED, OUTPUT);
    digitalWrite(LED, LOW);  // Turn off the LED initially
    //======================================================

    Serial.println(F("=========Ready!==========="));
    Serial.println(F("=========================="));
    // Connecting to an MQTT broker
    client.setServer(mqtt_broker, mqtt_port);
    client.setCallback(callback);
    while (!client.connected()) {
        String client_id = "esp32-client-";
        client_id += String(WiFi.macAddress());
        Serial.printf("The client %s connects to the public MQTT broker\n", client_id.c_str());
        if (client.connect(client_id.c_str(), mqtt_username, mqtt_password)) {
            Serial.println("Public HiveMQ MQTT broker (broker.mqtt-dashboard.com) connected");
        } else {
            Serial.print("Failed with state ");
            Serial.print(client.state());
            delay(2000);
        }
    }

    // Publish and subscribe
    client.subscribe(topic1);

    //在核心0啟動任務1
    xTaskCreatePinnedToCore(
    Task1_senddata, /*任務實際對應的Function*/
      "Task1",        /*任務名稱*/
      10000,          /*堆疊空間*/
      NULL,           /*無輸入值*/
      0,              /*優先序0*/
      &Task1,         /*對應的任務變數位址*/
      0);             /*指定在核心0執行 */
}
//===========================================================
void loop()
{
 if (!client.connected()) {
      reconnect();
      Serial.print(" client not connected  reconnect ");
      delay(200);
    }
  client.loop();

  //process Timer & Flash
  LED_flash_timer();

  unsigned long currentMillis = millis();
  // if WiFi is down, try reconnecting
  if ((WiFi.status() != WL_CONNECTED) && (currentMillis - previousMillis >=interval)) {
    Serial.print(millis());
    Serial.println("Reconnecting to WiFi...");
    WiFi.disconnect();
    WiFi.reconnect();
    previousMillis = currentMillis;

    client.setCallback(callback);
  }

}
//===========================================================



2023年8月26日 星期六

實驗1-2 2023-08 ESP32 + RFID + MQTT Explorer + Google App MyMQTT + Node-Red

 實驗1-2 2023-08  ESP32 + RFID + MQTT Explorer + Google App MyMQTT + Node-Red






// MQTT Broker
const char *mqtt_broker = "broker.mqtt-dashboard.com";
const char *topic1 = "alex9ufo/esp32/led";
const char *topic2 = "alex9ufo/esp32/RFID";


































  或







[{"id":"580c94b9d2d28477","type":"ui_button","z":"e4cba267a9614782","name":"","group":"d783cb980c3979fc","order":16,"width":2,"height":1,"passthru":false,"label":"LED 開","tooltip":"","color":"white","bgcolor":"","className":"","icon":"fa-circle","payload":"on","payloadType":"str","topic":"","topicType":"str","x":140,"y":100,"wires":[["e04b9ae6c9cf13a0","1ddef96e0b39a7ed","5763812d921d3686"]]},{"id":"8d12b5b63d88d34d","type":"ui_button","z":"e4cba267a9614782","name":"","group":"d783cb980c3979fc","order":18,"width":2,"height":1,"passthru":false,"label":"LED 關","tooltip":"","color":"black","bgcolor":"","className":"","icon":"fa-circle-o","payload":"off","payloadType":"str","topic":"","topicType":"str","x":140,"y":140,"wires":[["e04b9ae6c9cf13a0","1ddef96e0b39a7ed","5763812d921d3686"]]},{"id":"e04b9ae6c9cf13a0","type":"mqtt out","z":"e4cba267a9614782","name":"Control LED","topic":"alex9ufo/esp32/led","qos":"1","retain":"true","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"70940176.2b2d3","x":390,"y":100,"wires":[]},{"id":"17fde028714c2ffe","type":"comment","z":"e4cba267a9614782","name":"Node-Red publish 到 HiveMQ Broker  , ESP32訂閱","info":"將 alex9ufo/inTopic 到(publish)HiveMQ Broker \n給 Arduino 訂閱(Subscribe)","x":270,"y":40,"wires":[]},{"id":"1ddef96e0b39a7ed","type":"ui_audio","z":"e4cba267a9614782","name":"","group":"6c9116b.b62d4e8","voice":"zh-TW","always":true,"x":380,"y":180,"wires":[]},{"id":"5763812d921d3686","type":"ui_text","z":"e4cba267a9614782","group":"d783cb980c3979fc","order":20,"width":10,"height":2,"name":"","label":"Node-RED發行到MQTT的資料","format":"{{msg.payload}}","layout":"row-left","className":"","x":450,"y":140,"wires":[]},{"id":"1eaabded303264f6","type":"ui_audio","z":"e4cba267a9614782","name":"","group":"d783cb980c3979fc","voice":"Google US English","always":"","x":380,"y":340,"wires":[]},{"id":"a205cc8ff1b96783","type":"mqtt in","z":"e4cba267a9614782","name":"RFID Card","topic":"alex9ufo/esp32/RFID","qos":"2","datatype":"utf8","broker":"841df58d.ee5e98","nl":false,"rap":true,"rh":0,"inputs":0,"x":160,"y":400,"wires":[["1eaabded303264f6","49d0a9e2f1d09530","c702f883eaed76eb"]]},{"id":"49d0a9e2f1d09530","type":"debug","z":"e4cba267a9614782","name":"debug 94","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":380,"y":420,"wires":[]},{"id":"a04b2d423bfd191b","type":"comment","z":"e4cba267a9614782","name":"Node-Red  subscribe HiveMQ Broker  , ESP32發行","info":"將 alex9ufo/inTopic 到(publish)HiveMQ Broker \n給 Arduino 訂閱(Subscribe)","x":260,"y":280,"wires":[]},{"id":"c702f883eaed76eb","type":"ui_text","z":"e4cba267a9614782","group":"d783cb980c3979fc","order":21,"width":10,"height":2,"name":"","label":"Node-RED 訂閱MQTT的資料","format":"{{msg.payload}}","layout":"row-left","className":"","x":440,"y":380,"wires":[]},{"id":"d783cb980c3979fc","type":"ui_group","name":"Demo","tab":"0449b3b1fea99d52","order":1,"disp":true,"width":"10","collapse":false,"className":""},{"id":"70940176.2b2d3","type":"mqtt-broker","name":"","broker":"broker.mqtt-dashboard.com","port":"1883","clientid":"","autoConnect":true,"usetls":false,"protocolVersion":4,"keepalive":"15","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"6c9116b.b62d4e8","type":"ui_group","name":"2023 Storing IOT Data ","tab":"6249073d2714bfd4","order":1,"disp":true,"width":"16","collapse":true,"className":""},{"id":"841df58d.ee5e98","type":"mqtt-broker","name":"","broker":"broker.mqtt-dashboard.com","port":"1883","clientid":"","autoConnect":true,"usetls":false,"compatmode":false,"protocolVersion":4,"keepalive":"15","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"0449b3b1fea99d52","type":"ui_tab","name":"Demo","icon":"dashboard","disabled":false,"hidden":false},{"id":"6249073d2714bfd4","type":"ui_tab","name":"RFID Home","icon":"dashboard","disabled":false,"hidden":false}]



//Wifi  + MQTT
#include <WiFi.h>
#include <PubSubClient.h>

//RFID SPI + RC522
#include <SPI.h>
#include <MFRC522.h>

// GPIO 2 D1
#define LED 2

/* Wiring RFID RC522 module
=============================================================================
GND     = GND   3.3V    = 3.3V
The following table shows the typical pin layout used:
 *             MFRC522      ESP32     Arduino       Arduino   Arduino    Arduino          Arduino
 *             Reader/PCD             Uno/101       Mega      Nano v3    Leonardo/Micro   Pro Micro
 * Signal      Pin          Pin       Pin           Pin       Pin        Pin              Pin
 * -----------------------------------------------------------------------------------------
 * RST/Reset   RST          GPIO27    9             5         D9         RESET/ICSP-5     RST
 * SPI SS      SDA(SS)      GPIO5     10            53        D10        10               10
 * SPI MOSI    MOSI         GPIO23    11 / ICSP-4   51        D11        ICSP-4           16
 * SPI MISO    MISO         GPIO19    12 / ICSP-1   50        D12        ICSP-1           14
 * SPI SCK     SCK          GPIO18    13 / ICSP-3   52        D13        ICSP-3           15
 *
[1] (1, 2) Configurable, typically defined as RST_PIN in sketch/program.
[2] (1, 2) Configurable, typically defined as SS_PIN in sketch/program.
[3] The SDA pin might be labeled SS on some/older MFRC522 boards
=============================================================================
*/
// SPI 
#define SS_PIN  5  // ESP32 pin GIOP5
#define RST_PIN 27 // ESP32 pin GIOP27


// WiFi
const char *ssid = "alex9ufo"; // Enter your Wi-Fi name
const char *password = "alex9981";  // Enter Wi-Fi password

// MQTT Broker
const char *mqtt_broker = "broker.mqtt-dashboard.com";
const char *topic1 = "alex9ufo/esp32/led";
const char *topic2 = "alex9ufo/esp32/RFID";

const char *mqtt_username = "alex9ufo";
const char *mqtt_password = "public";
const int mqtt_port = 1883;

bool ledState = false;

WiFiClient espClient;
PubSubClient client(espClient);
MFRC522 rfid(SS_PIN, RST_PIN); // Create MFRC522 instance

long lastMsg = 0;
char msg[50];
String json = "";    
char jsonChar1[50];  //client.publish("alex9ufo/Esp32/RFID"

//宣告任務Task1
TaskHandle_t Task1;

// Wifi reconnect
unsigned long previousMillis = 0;
unsigned long interval = 30000;
//===========================================================
//任務1副程式Task1_senddata
void Task1_senddata(void * pvParameters ) {
  //無窮迴圈
  for (;;) {
    //偵測上傳旗標是否為true
    Serial.println("Reading RFID tag");
    if (rfid.PICC_IsNewCardPresent()) { // new tag is available
      if (rfid.PICC_ReadCardSerial()) { // NUID has been readed
        MFRC522::PICC_Type piccType = rfid.PICC_GetType(rfid.uid.sak);
        Serial.print("RFID/NFC Tag Type: ");
        Serial.println(rfid.PICC_GetTypeName(piccType));
        String rfidno="";
        // print UID in Serial Monitor in the hex format
        Serial.print("UID:");
        for (int i = 0; i < rfid.uid.size; i++) {
          Serial.print(rfid.uid.uidByte[i] < 0x10 ? " 0" : " ");
          Serial.print(rfid.uid.uidByte[i], HEX);
        }
        Serial.println();

        String json = printHex(rfid.uid.uidByte, rfid.uid.size);
        json.trim();
        json.toUpperCase();
        // Convert JSON string to character array
        json.toCharArray(jsonChar1, json.length()+1);
   
        if  (client.connected()) {
            Serial.print("Publish message: ");
            Serial.println(json);
            // Publish JSON character array to MQTT topic
            client.publish(topic2,jsonChar1);
             
          rfid.PICC_HaltA(); // halt PICC
          rfid.PCD_StopCrypto1(); // stop encryption on PCD
        }  
        else
        {
          Serial.print("MQTT not connected ");
        }
     
      }
    }


    else  
    {
      // PN532 probably timed out waiting for a card
      Serial.println("Timed out waiting for a card");
    }      
    //Task1休息,delay(X)不可省略
    delay(1000);
  }
}

//===========================================================
String printHex(byte *buffer, byte bufferSize) {
      String id = "";
      for (byte i = 0; i < bufferSize; i++) {
        id += buffer[i] < 0x10 ? "0" : "";
        id += String(buffer[i], HEX);
        id +=" ";
      }
      return id;
    }

//===========================================================
void reconnect() {
  // Loop until we're reconnected
  while (!client.connected()) {
    Serial.print("Attempting MQTT connection...");
    // Attempt to connect

    if (client.connect("esp32-client-")) {
      Serial.println("connected");
      // Subscribe
      client.subscribe("alex9ufo/esp32/led");
      client.subscribe("alex9ufo/esp32/RFID");      
    } else {
      Serial.print("failed, rc=");
      Serial.print(client.state());
      Serial.println(" try again in 5 seconds");
      // Wait 5 seconds before retrying
      delay(5000);
      if (WiFi.status() != WL_CONNECTED)  {
        Serial.println("Reconnecting to WiFi...");
        WiFi.disconnect();
        WiFi.reconnect();
      }
    }
  }
}
//===========================================================
void callback(char *topic, byte *payload, unsigned int length) {
    Serial.print("Message arrived in topic: ");
    Serial.println(topic);
    Serial.print("Message: ");
    String message;
    for (int i = 0; i < length; i++) {
        message += (char) payload[i];  // Convert *byte to string
    }
    Serial.print(message);
    if (message == "on" && !ledState) {
        digitalWrite(LED, HIGH);  // Turn on the LED
        ledState = true;
    }
    if (message == "off" && ledState) {
        digitalWrite(LED, LOW); // Turn off the LED
        ledState = false;
    }
    Serial.println();
    Serial.println("-----------------------");
}
//===========================================================

void setup() {
    // Set software serial baud to 115200;
    Serial.begin(115200);
    delay(1000); // Delay for stability
    //======================================================
    // Connecting to a WiFi network
    WiFi.begin(ssid, password);
    while (WiFi.status() != WL_CONNECTED) {
        delay(500);
        Serial.println("Connecting to WiFi...");
    }
    Serial.println("Connected to the WiFi network");

    // Setting LED pin as output
    pinMode(LED, OUTPUT);
    digitalWrite(LED, LOW);  // Turn off the LED initially
    //======================================================
    SPI.begin();           // Init SPI bus
    rfid.PCD_Init();    // Init MFRC522

    Serial.println(F("Ready!"));
    Serial.println(F("======================================================"));
    Serial.println("Tap an RFID/NFC tag on the RFID-RC522 reader");


    // Connecting to an MQTT broker
    client.setServer(mqtt_broker, mqtt_port);
    client.setCallback(callback);
    while (!client.connected()) {
        String client_id = "esp32-client-";
        client_id += String(WiFi.macAddress());
        Serial.printf("The client %s connects to the public MQTT broker\n", client_id.c_str());
        if (client.connect(client_id.c_str(), mqtt_username, mqtt_password)) {
            Serial.println("Public HiveMQ MQTT broker (broker.mqtt-dashboard.com) connected");
        } else {
            Serial.print("Failed with state ");
            Serial.print(client.state());
            delay(2000);
        }
    }

    // Publish and subscribe
    client.subscribe(topic1);
    //在核心0啟動任務1
    xTaskCreatePinnedToCore(
    Task1_senddata, /*任務實際對應的Function*/
      "Task1",        /*任務名稱*/
      10000,          /*堆疊空間*/
      NULL,           /*無輸入值*/
      0,              /*優先序0*/
      &Task1,         /*對應的任務變數位址*/
      0);             /*指定在核心0執行 */

}
//===========================================================
void loop() {
  if (!client.connected()) {
      reconnect();
      Serial.print(" client not connected  reconnect ");
      delay(200);
  }
  client.loop();
  // Process LED message

  unsigned long currentMillis = millis();
  // if WiFi is down, try reconnecting
  if ((WiFi.status() != WL_CONNECTED) && (currentMillis - previousMillis >=interval)) {
    Serial.print(millis());
    Serial.println("Reconnecting to WiFi...");
    WiFi.disconnect();
    WiFi.reconnect();
    previousMillis = currentMillis;
    client.setCallback(callback);
  }

}
//===========================================================

Messaging API作為替代方案

  LINE超好用功能要沒了!LINE Notify明年3月底終止服務,有什麼替代方案? LINE Notify將於2025年3月31日結束服務,官方建議改用Messaging API作為替代方案。 //CHANNEL_ACCESS_TOKEN = 'Messaging ...