[{"id":"44e9c5.802ac63c","type":"tab","label":"Final Flow","disabled":false,"info":""},{"id":"e96255ed.dd6798","type":"mqtt in","z":"44e9c5.802ac63c","name":"","topic":"room/light","qos":"2","broker":"327d5679.5ad00a","x":220,"y":180,"wires":[["ed467f6d.5036f"]]},{"id":"ed467f6d.5036f","type":"change","z":"44e9c5.802ac63c","name":"Convertion","rules":[{"t":"set","p":"payload","pt":"msg","to":"$number(payload)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":450,"y":180,"wires":[["cfd0e509.5c3d78","9f919ddd.c13e5"]]},{"id":"9f919ddd.c13e5","type":"function","z":"44e9c5.802ac63c","name":"set data","func":"// data is the variable that store the values of \n// light strength read by the light sensor that is connected to arduino\n// data is the coloumn name in data base (mydb)\nglobal.set(\"data\" , msg.payload);\n","outputs":1,"noerr":0,"x":700,"y":200,"wires":[[]]},{"id":"cfd0e509.5c3d78","type":"ui_gauge","z":"44e9c5.802ac63c","name":"","group":"d75b9cc1.d4b4d","order":0,"width":0,"height":0,"gtype":"gage","title":"Light Strength","label":"units","format":"{{value}}","min":0,"max":"1024","colors":["#00b500","#e6e600","#ca3838"],"seg1":"","seg2":"","x":720,"y":160,"wires":[]},{"id":"c1892007.79ab5","type":"debug","z":"44e9c5.802ac63c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":890,"y":340,"wires":[]},{"id":"d6cdb2f5.c7a62","type":"mysql","z":"44e9c5.802ac63c","mydb":"20222dfc.10cbd2","name":"","x":610,"y":500,"wires":[["83c7119d.e336e","4a4d7138.09e0a"]]},{"id":"4a4d7138.09e0a","type":"function","z":"44e9c5.802ac63c","name":"ChartFormat","func":"var temp = [];\nvar temp1 = [];\nvar ny = {};\n\nvar max = global.get(\"max\")\nvar j = 0;\nfor (var i = 0 ; i < max; i++) {\n\ntemp[j] = msg.payload[i].timestamp;\ntemp1[j] = msg.payload[i].data;\nj=j+1;\n\n}\n\nny.labels = temp;\nny.series = ['Light Value']\nny.data = [temp1];\nreturn {payload:[ny]};\n\n","outputs":1,"noerr":0,"x":790,"y":600,"wires":[["31359522.e8216a","8343aa2d.f66e48"]]},{"id":"31359522.e8216a","type":"debug","z":"44e9c5.802ac63c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":1110,"y":600,"wires":[]},{"id":"8343aa2d.f66e48","type":"ui_chart","z":"44e9c5.802ac63c","name":"","group":"40f1af7b.690e2","order":5,"width":0,"height":0,"label":"Graph from DB","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"1","removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":1140,"y":680,"wires":[[]]},{"id":"83c7119d.e336e","type":"function","z":"44e9c5.802ac63c","name":"Length","func":"var newLog = { payload: 'Logs in database : ' + msg.payload.length};\nvar newLog1 = { payload: msg.payload.length};\nreturn [[newLog], newLog1];\n","outputs":2,"noerr":0,"x":800,"y":500,"wires":[["d1e57c71.b3aec","488e2c02.473074"],[]]},{"id":"d1e57c71.b3aec","type":"debug","z":"44e9c5.802ac63c","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":1050,"y":460,"wires":[]},{"id":"488e2c02.473074","type":"ui_text","z":"44e9c5.802ac63c","group":"35c39e80.fdd632","order":1,"width":0,"height":0,"name":"","label":"DB info","format":"{{msg.payload}}","layout":"col-center","x":1040,"y":500,"wires":[]},{"id":"d67720bc.1bd19","type":"inject","z":"44e9c5.802ac63c","name":"0.5 sec interval","topic":"","payload":"","payloadType":"num","repeat":"5","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":480,"wires":[["fda9471d.02d798","663e4b7c.076284"]]},{"id":"fda9471d.02d798","type":"function","z":"44e9c5.802ac63c","name":"SQL select","func":"msg.topic='SELECT * FROM lightreading'\nreturn msg;","outputs":1,"noerr":0,"x":390,"y":480,"wires":[["d6cdb2f5.c7a62"]]},{"id":"663e4b7c.076284","type":"function","z":"44e9c5.802ac63c","name":"Convert Time","func":"var currentDate = new Date();\n\nvar date = currentDate.getDate();\nvar month = currentDate.getMonth();\nvar year = currentDate.getFullYear();\nvar hours = currentDate.getHours();\nvar minutes = currentDate.getMinutes();\nvar seconds = currentDate.getSeconds();\n\nvar dateStr = year + \"-\"  + (month + 1) + \"-\" + date +  \" \" +  hours + \"-\" + minutes+ \"-\" + seconds;\nmsg.payload = dateStr;\nglobal.set(\"timestamp\" , msg.payload);\nreturn msg;","outputs":1,"noerr":0,"x":400,"y":520,"wires":[[]]},{"id":"e54b906f.d7f4e","type":"inject","z":"44e9c5.802ac63c","name":"10 sec interval","topic":"","payload":"","payloadType":"num","repeat":"10","crontab":"","once":false,"onceDelay":0.1,"x":240,"y":340,"wires":[["fd048157.9d3bc"]]},{"id":"fd048157.9d3bc","type":"function","z":"44e9c5.802ac63c","name":"SQLInsert","func":"var timeStamp = global.get('timestamp');\nvar data =  global.get('data')\n\n\n\nmsg.topic = 'INSERT INTO lightreading(timestamp,data) VALUES ('+ \"'\" + timeStamp + \"'\" +  ', ' + data + ')'\nreturn msg;\n\n\n\n","outputs":1,"noerr":0,"x":490,"y":340,"wires":[["6a4414aa.61ccdc","1f0af021.c7f5a"]]},{"id":"6a4414aa.61ccdc","type":"debug","z":"44e9c5.802ac63c","name":"SQL insert test","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"topic","x":780,"y":400,"wires":[]},{"id":"1f0af021.c7f5a","type":"mysql","z":"44e9c5.802ac63c","mydb":"350f4d27.79af12","name":"Insert","x":750,"y":340,"wires":[["c1892007.79ab5"]]},{"id":"ca3b727b.f1e1c","type":"ui_form","z":"44e9c5.802ac63c","name":"","label":"","group":"40f1af7b.690e2","order":6,"width":0,"height":0,"options":[{"label":"insert max","value":"max","type":"number","required":true}],"formValue":{"max":""},"payload":"","submit":"submit","cancel":"cancel","topic":"","x":550,"y":780,"wires":[["4be5c08a.cafc5"]]},{"id":"4be5c08a.cafc5","type":"function","z":"44e9c5.802ac63c","name":"max","func":"\n\nglobal.set(\"max\" , msg.payload.max);\n\n\n\n","outputs":1,"noerr":0,"x":720,"y":780,"wires":[[]]},{"id":"8e2d91db.c6742","type":"ui_button","z":"44e9c5.802ac63c","name":"","group":"35c39e80.fdd632","order":1,"width":0,"height":0,"passthru":false,"label":"Empty DB","tooltip":"","color":"","bgcolor":"","icon":"","payload":"true","payloadType":"bool","topic":"delete","x":180,"y":620,"wires":[["95cf2eb0.ecc88","666dcb9e.99cda4"]]},{"id":"666dcb9e.99cda4","type":"function","z":"44e9c5.802ac63c","name":"empty","func":"var empty = global.get('delete');\n\nif (empty===true){ \n   msg.topic =  'DELETE FROM lightreading';\n    \n}\nreturn msg","outputs":1,"noerr":0,"x":390,"y":640,"wires":[["d6cdb2f5.c7a62"]]},{"id":"95cf2eb0.ecc88","type":"function","z":"44e9c5.802ac63c","name":"set delete","func":"\nglobal.set('delete', msg.payload)","outputs":1,"noerr":0,"x":400,"y":600,"wires":[[]]},{"id":"ec9a489f.0b37f8","type":"comment","z":"44e9c5.802ac63c","name":"","info":"Convert string to integer","x":440,"y":140,"wires":[]},{"id":"4a363f95.fe547","type":"comment","z":"44e9c5.802ac63c","name":"data and timestamp","info":"insert into db table ","x":490,"y":300,"wires":[]},{"id":"bd721ca0.dc109","type":"comment","z":"44e9c5.802ac63c","name":"db to chart","info":"this function create a chart from the data that is inserted in the data base","x":780,"y":560,"wires":[]},{"id":"f15f4f98.c1687","type":"comment","z":"44e9c5.802ac63c","name":"","info":"insert the max number of rows in data base to monitor in chart format","x":620,"y":740,"wires":[]},{"id":"327d5679.5ad00a","type":"mqtt-broker","z":"","name":"School","broker":"10.140.100.198","port":"1883","clientid":"","usetls":false,"compatmode":true,"keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"d75b9cc1.d4b4d","type":"ui_group","z":"","name":"Light sensor","tab":"843fb8f1.cc8578","disp":true,"width":"6","collapse":false},{"id":"20222dfc.10cbd2","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"mydb","tz":"+10GMT"},{"id":"40f1af7b.690e2","type":"ui_group","z":"","name":"DB Logs","tab":"843fb8f1.cc8578","order":2,"disp":false,"width":"6","collapse":false},{"id":"35c39e80.fdd632","type":"ui_group","z":"","name":"DB info","tab":"843fb8f1.cc8578","disp":true,"width":"6","collapse":false},{"id":"350f4d27.79af12","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"mydb","tz":"GMT +10"},{"id":"843fb8f1.cc8578","type":"ui_tab","z":"","name":"Room","icon":"dashboard","order":1,"disabled":false,"hidden":false}]