[{"id":"88cbe83a.26e2a8","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"aefb48bb.435868","type":"serial in","z":"88cbe83a.26e2a8","name":"","serial":"23acad23.0a1f9a","x":130,"y":140,"wires":[["1a128438.302474","1ece36f6.f6dff9"]]},{"id":"62d3ae01.8c4de","type":"serial out","z":"88cbe83a.26e2a8","name":"","serial":"23acad23.0a1f9a","x":790,"y":280,"wires":[]},{"id":"5420c507.8f4584","type":"ui_slider","z":"88cbe83a.26e2a8","name":"","label":"mælk","group":"5f286fc8.211378","order":8,"width":0,"height":0,"passthru":false,"topic":"","min":"20004","max":"24004","step":"1","x":350,"y":460,"wires":[["62d3ae01.8c4de"]]},{"id":"f289c616.cbe298","type":"ui_slider","z":"88cbe83a.26e2a8","name":"","label":"kakao","group":"5f286fc8.211378","order":6,"width":0,"height":0,"passthru":false,"topic":"","min":"10003","max":"18003","step":"1","x":350,"y":420,"wires":[["62d3ae01.8c4de"]]},{"id":"1ece36f6.f6dff9","type":"function","z":"88cbe83a.26e2a8","name":"split","func":"var var1 ={payload: msg.payload.split(\",\")[0]};\nvar var2 ={payload: msg.payload.split(\",\")[1]};\nvar var3 ={payload: msg.payload.split(\",\")[2]};\nvar var4 ={payload: msg.payload.split(\",\")[3]};\nvar var5 ={payload: msg.payload.split(\",\")[4]};\nvar var6 ={payload: msg.payload.split(\",\")[5]};\nvar var7 ={payload: msg.payload.split(\",\")[6]};\nvar var8 ={payload: msg.payload.split(\",\")[7]};\nvar var9 ={payload: msg.payload.split(\",\")[8]};\nvar var10 ={payload: msg.payload.split(\",\")[9]};\nvar var11 ={payload: msg.payload.split(\",\")[10]};\nreturn[var1,var2,var3,var4,var5,var6,var7,var8,var9,var10,var11];\n","outputs":11,"noerr":0,"x":350,"y":180,"wires":[[],[],[],[],[],["b08c56a6.6356e8"],["c56ce71e.413ea8"],["ef3419cc.205e08"],["6d870af7.158534"],["5f6ad4ad.1ebc84"],["75089821.ec4ad8"]]},{"id":"36f0979f.3cdef8","type":"ui_button","z":"88cbe83a.26e2a8","name":"","group":"5f286fc8.211378","order":9,"width":0,"height":0,"passthru":false,"label":"start","color":"","bgcolor":"","icon":"","payload":"1","payloadType":"num","topic":"","x":350,"y":340,"wires":[["62d3ae01.8c4de"]]},{"id":"a16aeaa7.b894b8","type":"ui_text_input","z":"88cbe83a.26e2a8","name":"","label":"mælk køretid","group":"6cc31f30.6bd1c8","order":4,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":860,"y":700,"wires":[[]]},{"id":"decdfec6.4e88c","type":"ui_text_input","z":"88cbe83a.26e2a8","name":"","label":"kakao køretid","group":"6cc31f30.6bd1c8","order":3,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":860,"y":660,"wires":[[]]},{"id":"ab542eeb.e6a33","type":"ui_text_input","z":"88cbe83a.26e2a8","name":"","label":"pumpe køretid","group":"6cc31f30.6bd1c8","order":5,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":860,"y":740,"wires":[[]]},{"id":"b08c56a6.6356e8","type":"ui_gauge","z":"88cbe83a.26e2a8","name":"","group":"1474d326.9cff85","order":1,"width":0,"height":0,"gtype":"gage","title":"temperatur","label":"grader","format":"{{value}}","min":0,"max":"100","colors":["#0d04b0","#e6e600","#ca3838"],"seg1":"80","seg2":"90","x":670,"y":20,"wires":[]},{"id":"ef3419cc.205e08","type":"ui_gauge","z":"88cbe83a.26e2a8","name":"","group":"adc75ec.064bda","order":2,"width":0,"height":0,"gtype":"compass","title":"kørt tid","label":"procent","format":"{{value}}","min":0,"max":"100","colors":["#80ff00","#80ff00","#80ff00"],"seg1":"80","seg2":"90","x":660,"y":100,"wires":[]},{"id":"8b0b4b42.ffb37","type":"ui_slider","z":"88cbe83a.26e2a8","name":"","label":"kaffe","group":"5f286fc8.211378","order":4,"width":0,"height":0,"passthru":false,"topic":"","min":"2","max":"8002","step":"1","x":350,"y":380,"wires":[["62d3ae01.8c4de"]]},{"id":"c56ce71e.413ea8","type":"ui_text_input","z":"88cbe83a.26e2a8","name":"","label":"indstillet tid","group":"5f286fc8.211378","order":1,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":670,"y":60,"wires":[[]]},{"id":"1a128438.302474","type":"function","z":"88cbe83a.26e2a8","name":"split","func":"var var1 ={payload: msg.payload.split(\":\")[0]};\nvar var2 ={payload: msg.payload.split(\",\")[1]};\nreturn[var1,var2];\n","outputs":2,"noerr":0,"x":130,"y":200,"wires":[["b3a6be6f.39a9d"],[]]},{"id":"e9e6e52f.b487d8","type":"mysql","z":"88cbe83a.26e2a8","mydb":"13e3c871.7e442","name":"kaffe","x":130,"y":380,"wires":[[]]},{"id":"f5d7267f.dd0818","type":"function","z":"88cbe83a.26e2a8","name":"nodered","func":"var data = msg.payload.split(\",\");\nvar kaffe = data[0];\nvar kakao = data[1];\nvar maelk = data[2];\nvar pumpe = data[3];\nvar out = \"INSERT INTO kaffemaskine.kaffe (time,kaffe,kakao,maelk,pumpe) VALUES('\"+new Date().toISOString().slice(0, 19).replace('T', ' ')+\"','\"+kaffe+\"','\"+kakao+\"','\"+maelk+\"','\"+pumpe+\"')\";\nmsg.topic = out;\nreturn msg;\n\n//var out = \"INSERT INTO kaffemaskine.kaffe (time,kaffe,kakao,maelk,pumpe) VALUES('\"+new Date().toISOString().slice(0, 19).replace('T', ' ')+\"','\"+kaffe+\"','\"+kakao+\"','\"+maelk+\"','\"+pumpe+\"')\";\n","outputs":1,"noerr":0,"x":140,"y":320,"wires":[["e9e6e52f.b487d8"]]},{"id":"b3a6be6f.39a9d","type":"delay","z":"88cbe83a.26e2a8","name":"","pauseType":"rate","timeout":"5","timeoutUnits":"seconds","rate":"1","nbRateUnits":"2","rateUnits":"minute","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":true,"x":160,"y":260,"wires":[["f5d7267f.dd0818","b37be81e.f028d"]]},{"id":"7f32babb.b57a04","type":"inject","z":"88cbe83a.26e2a8","name":"","topic":"","payload":"","payloadType":"str","repeat":"10","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":620,"wires":[["95825634.47cdc8"]]},{"id":"95825634.47cdc8","type":"function","z":"88cbe83a.26e2a8","name":"","func":"//msg.topic = \"SELECT kaffe FROM Kaffe ORDER BY time DESC LIMIT 1\";\nmsg.topic = \"SELECT kaffe FROM Kaffe ORDER BY time\";\n\nreturn msg;","outputs":1,"noerr":0,"x":470,"y":620,"wires":[["900bb2cd.a85ae8"]]},{"id":"900bb2cd.a85ae8","type":"mysql","z":"88cbe83a.26e2a8","mydb":"13e3c871.7e442","name":"kaffe","x":590,"y":620,"wires":[["4d7a1a74.71c89c"]]},{"id":"605aa6c8.f72a4","type":"ui_text_input","z":"88cbe83a.26e2a8","name":"","label":"kaffe køretid","group":"6cc31f30.6bd1c8","order":2,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":850,"y":620,"wires":[[]]},{"id":"4d7a1a74.71c89c","type":"function","z":"88cbe83a.26e2a8","name":"","func":"var i;\nvar a =0;\n\n\nfor (i = 0; i < msg.payload.length ; i++) {\n a = Number(msg.payload[i].kaffe)+a \n \n \n}\nmsg.payload = a; \nreturn msg; \n\n\n\n\n//cars.length","outputs":1,"noerr":0,"x":710,"y":620,"wires":[["605aa6c8.f72a4"]]},{"id":"1c947aa6.9acec5","type":"inject","z":"88cbe83a.26e2a8","name":"","topic":"","payload":"","payloadType":"str","repeat":"10","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":660,"wires":[["76725c54.1021a4"]]},{"id":"76725c54.1021a4","type":"function","z":"88cbe83a.26e2a8","name":"","func":"msg.topic = \"SELECT kakao FROM Kaffe ORDER BY time\";\n\nreturn msg;","outputs":1,"noerr":0,"x":470,"y":660,"wires":[["f74549bc.41872"]]},{"id":"f74549bc.41872","type":"mysql","z":"88cbe83a.26e2a8","mydb":"13e3c871.7e442","name":"kaffe","x":590,"y":660,"wires":[["5321250d.178f2c"]]},{"id":"5321250d.178f2c","type":"function","z":"88cbe83a.26e2a8","name":"","func":"var i;\nvar a =0;\n\n\nfor (i = 0; i < msg.payload.length ; i++) {\n a = Number(msg.payload[i].kakao)+a \n \n \n}\nmsg.payload = a; \nreturn msg; \n\n\n\n\n//cars.length","outputs":1,"noerr":0,"x":710,"y":660,"wires":[["decdfec6.4e88c"]]},{"id":"fbe2d0f1.540e2","type":"inject","z":"88cbe83a.26e2a8","name":"","topic":"","payload":"","payloadType":"str","repeat":"10","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":700,"wires":[["3180e13e.046b96"]]},{"id":"3180e13e.046b96","type":"function","z":"88cbe83a.26e2a8","name":"","func":"//msg.topic = \"SELECT kaffe FROM Kaffe ORDER BY time DESC LIMIT 1\";\nmsg.topic = \"SELECT maelk FROM Kaffe ORDER BY time\";\n\nreturn msg;","outputs":1,"noerr":0,"x":470,"y":700,"wires":[["bcd6978c.eca728"]]},{"id":"bcd6978c.eca728","type":"mysql","z":"88cbe83a.26e2a8","mydb":"13e3c871.7e442","name":"kaffe","x":590,"y":700,"wires":[["f814cef1.c76d7"]]},{"id":"f814cef1.c76d7","type":"function","z":"88cbe83a.26e2a8","name":"","func":"var i;\nvar a =0;\n\n\nfor (i = 0; i < msg.payload.length ; i++) {\n a = Number(msg.payload[i].maelk)+a \n \n \n}\nmsg.payload = a; \nreturn msg; \n\n\n\n\n//cars.length","outputs":1,"noerr":0,"x":710,"y":700,"wires":[["a16aeaa7.b894b8"]]},{"id":"795cffc6.34b058","type":"inject","z":"88cbe83a.26e2a8","name":"","topic":"","payload":"","payloadType":"str","repeat":"10","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":740,"wires":[["f94b9fb8.20a998"]]},{"id":"f94b9fb8.20a998","type":"function","z":"88cbe83a.26e2a8","name":"","func":"//msg.topic = \"SELECT kaffe FROM Kaffe ORDER BY time DESC LIMIT 1\";\nmsg.topic = \"SELECT pumpe FROM Kaffe ORDER BY time\";\n\nreturn msg;","outputs":1,"noerr":0,"x":470,"y":740,"wires":[["ac94311a.8b41f8"]]},{"id":"ac94311a.8b41f8","type":"mysql","z":"88cbe83a.26e2a8","mydb":"13e3c871.7e442","name":"kaffe","x":590,"y":740,"wires":[["91259a1f.cc9b68"]]},{"id":"91259a1f.cc9b68","type":"function","z":"88cbe83a.26e2a8","name":"","func":"var i;\nvar a =0;\n\n\nfor (i = 0; i < msg.payload.length ; i++) {\n a = Number(msg.payload[i].pumpe)+a \n \n \n}\nmsg.payload = a; \nreturn msg; \n\n\n\n\n//cars.length","outputs":1,"noerr":0,"x":710,"y":740,"wires":[["ab542eeb.e6a33"]]},{"id":"b37be81e.f028d","type":"function","z":"88cbe83a.26e2a8","name":"","func":"msg.payload = 24007\nreturn msg;","outputs":1,"noerr":0,"x":350,"y":280,"wires":[["62d3ae01.8c4de"]]},{"id":"c18035e9.169048","type":"ui_button","z":"88cbe83a.26e2a8","name":"","group":"299e7329.377ce4","order":2,"width":0,"height":0,"passthru":false,"label":"reset kaffe niveau","color":"","bgcolor":"","icon":"","payload":"24008","payloadType":"num","topic":"","x":390,"y":500,"wires":[["62d3ae01.8c4de"]]},{"id":"c0c00a3e.deefd8","type":"ui_button","z":"88cbe83a.26e2a8","name":"","group":"8647bf6b.24792","order":2,"width":0,"height":0,"passthru":false,"label":"reset mælk niveau","color":"","bgcolor":"","icon":"","payload":"24010","payloadType":"num","topic":"","x":390,"y":580,"wires":[["62d3ae01.8c4de"]]},{"id":"a3f437c.8e417c8","type":"ui_button","z":"88cbe83a.26e2a8","name":"","group":"70a0336c.915bec","order":2,"width":0,"height":0,"passthru":false,"label":"reset kakao niveau","color":"","bgcolor":"","icon":"","payload":"24009","payloadType":"num","topic":"","x":390,"y":540,"wires":[["62d3ae01.8c4de"]]},{"id":"6d870af7.158534","type":"ui_gauge","z":"88cbe83a.26e2a8","name":"","group":"299e7329.377ce4","order":1,"width":0,"height":0,"gtype":"wave","title":"kaffe beholder","label":"%","format":"{{value}}","min":"0","max":"100","colors":["#ff0000","#e6e600","#00ff00"],"seg1":"","seg2":"","x":680,"y":140,"wires":[]},{"id":"5f6ad4ad.1ebc84","type":"ui_gauge","z":"88cbe83a.26e2a8","name":"","group":"70a0336c.915bec","order":1,"width":0,"height":0,"gtype":"wave","title":"kakao beholder","label":"%","format":"{{value}}","min":"0","max":"100","colors":["#ff0000","#e6e600","#00ff00"],"seg1":"","seg2":"","x":680,"y":180,"wires":[]},{"id":"75089821.ec4ad8","type":"ui_gauge","z":"88cbe83a.26e2a8","name":"","group":"8647bf6b.24792","order":1,"width":0,"height":0,"gtype":"wave","title":"mælke beholder","label":"%","format":"{{value}}","min":"0","max":"100","colors":["#ff0000","#e6e600","#00ff00"],"seg1":"","seg2":"","x":690,"y":220,"wires":[]},{"id":"23acad23.0a1f9a","type":"serial-port","z":"","serialport":"COM6","serialbaud":"9600","databits":"8","parity":"none","stopbits":"1","newline":"\\n","bin":"false","out":"char","addchar":false,"responsetimeout":"10000"},{"id":"5f286fc8.211378","type":"ui_group","z":"","name":"knapper","tab":"3dfdaa3.91cf856","order":2,"disp":false,"width":"6","collapse":false},{"id":"6cc31f30.6bd1c8","type":"ui_group","z":"","name":"køretider","tab":"3dfdaa3.91cf856","order":3,"disp":false,"width":"6","collapse":false},{"id":"1474d326.9cff85","type":"ui_group","z":"","name":"temp","tab":"3dfdaa3.91cf856","order":4,"disp":false,"width":"10","collapse":false},{"id":"adc75ec.064bda","type":"ui_group","z":"","name":"tid","tab":"3dfdaa3.91cf856","order":1,"disp":false,"width":"12","collapse":false},{"id":"13e3c871.7e442","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"kaffemaskine","tz":""},{"id":"299e7329.377ce4","type":"ui_group","z":"","name":"niveau kaffe","tab":"3dfdaa3.91cf856","order":5,"disp":true,"width":"6","collapse":false},{"id":"8647bf6b.24792","type":"ui_group","z":"","name":"niveau mælk","tab":"3dfdaa3.91cf856","order":7,"disp":true,"width":"6","collapse":false},{"id":"70a0336c.915bec","type":"ui_group","z":"","name":"niveau kakao","tab":"3dfdaa3.91cf856","order":6,"disp":true,"width":"6","collapse":false},{"id":"3dfdaa3.91cf856","type":"ui_tab","z":"","name":"Home","icon":"dashboard","order":1}]