[{"id":"fe7c372a.3f09a","type":"tab","label":"Thermostat/Relais","disabled":false,"info":""},{"id":"cd0c1dc3.db5608","type":"ui_gauge","z":"fe7c372a.3f09a","name":"Solltemperatur","group":"f7e0940a.03b098","order":6,"width":0,"height":0,"gtype":"gage","title":"Solltemperatur","label":"","format":"{{value}}","min":"18","max":"30","colors":["#0000ff","#800000","#ff0000"],"seg1":"20","seg2":"22","x":780,"y":320,"wires":[]},{"id":"b044b756.f6151","type":"ui_slider","z":"fe7c372a.3f09a","name":"solltemp","label":"Solltemp +/-","tooltip":"","group":"f7e0940a.03b098","order":7,"width":0,"height":0,"passthru":true,"outs":"all","topic":"solltemp","min":"18","max":"30","step":".5","x":466.914306640625,"y":391.57142639160156,"wires":[["cd0c1dc3.db5608","a3c11b24.ba0b5","64c4acf1.8b8d14","f476bba4.72964","f35a9f5f.7c3318","8dd89c85.dd1ad8"]]},{"id":"7d0a9e7b.86211","type":"debug","z":"fe7c372a.3f09a","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":1123.9141845703125,"y":503.1999816894531,"wires":[]},{"id":"2906b98d.be72e6","type":"mqtt in","z":"fe7c372a.3f09a","name":"","topic":"/EOH_Thermostat_WZ/temp_wz/TempWZ","qos":"0","datatype":"auto","broker":"2e7e0d99.9e092a","x":180.71429443359375,"y":238.1999969482422,"wires":[["1190784.e161708","248a684e.b20a98","15b7673b.836141"]]},{"id":"e087aca0.4c5be8","type":"http request","z":"fe7c372a.3f09a","name":"","method":"GET","ret":"txt","paytoqs":false,"url":"","tls":"","persist":false,"proxy":"","authType":"","x":920.5,"y":493.9429016113281,"wires":[["7d0a9e7b.86211"]]},{"id":"f476bba4.72964","type":"function","z":"fe7c372a.3f09a","name":"Funktion Solltemp an espEasy_Thermostat","func":"//var solltemp = flow.get(\"solltemp\");\nvar solltemp=msg.payload;\nmsg.url=\"http://192.168.178.78/control?cmd=TaskValueSet 2,1,\";\n//var solltemp=24;\nmsg.url=msg.url + solltemp;\nreturn msg;","outputs":1,"noerr":0,"x":610,"y":520,"wires":[["e087aca0.4c5be8"]]},{"id":"c45af371.38e838","type":"inject","z":"fe7c372a.3f09a","name":"","topic":"solltemp","payload":"25","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":401.21429443359375,"y":583.5714263916016,"wires":[["f476bba4.72964"]]},{"id":"a3c11b24.ba0b5","type":"debug","z":"fe7c372a.3f09a","name":"debug-solltemp","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":724.7142944335938,"y":208.63811683654785,"wires":[]},{"id":"989aefd3.7e3878","type":"inject","z":"fe7c372a.3f09a","name":"","topic":"","payload":"25","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":270.2143249511719,"y":379.5714111328125,"wires":[["b044b756.f6151"]]},{"id":"64c4acf1.8b8d14","type":"change","z":"fe7c372a.3f09a","name":"","rules":[{"t":"set","p":"solltemp","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":798.2142944335938,"y":380.3714141845703,"wires":[["a6ce5c30.56ce1"]]},{"id":"a6ce5c30.56ce1","type":"debug","z":"fe7c372a.3f09a","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1025.2142944335938,"y":379.97145080566406,"wires":[]},{"id":"cb41378c.0fc4c8","type":"mqtt in","z":"fe7c372a.3f09a","name":"","topic":"/ESP_Relais/relais/HeizungStatus","qos":"2","datatype":"auto","broker":"2e7e0d99.9e092a","x":447.91429138183594,"y":630.7714385986328,"wires":[["fc6a9ecd.9c077"]]},{"id":"fc6a9ecd.9c077","type":"function","z":"fe7c372a.3f09a","name":"Funktion Heizungsstatus","func":"var heizungstatus=msg.payload;\nif (heizungstatus == 1){\nmsg.payload=\"Heizung ist an\"    \n} else {\n    msg.payload=\"Heizung ist aus\";\n}\nreturn msg;","outputs":1,"noerr":0,"x":796.5646553039551,"y":621.9764556884766,"wires":[["696d82da.9c6aec","5d01a94.2f56058"]]},{"id":"696d82da.9c6aec","type":"debug","z":"fe7c372a.3f09a","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1088.0714111328125,"y":658.4000244140625,"wires":[]},{"id":"5d01a94.2f56058","type":"ui_text","z":"fe7c372a.3f09a","group":"f7e0940a.03b098","order":8,"width":0,"height":0,"name":"","label":"Heizungsstatus:","format":"{{msg.payload}}","layout":"row-spread","x":1080,"y":560,"wires":[]},{"id":"1190784.e161708","type":"debug","z":"fe7c372a.3f09a","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":422.2142028808594,"y":279.1142578125,"wires":[]},{"id":"b1f3c773.e7db28","type":"debug","z":"fe7c372a.3f09a","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":885.2142944335938,"y":705.5714263916016,"wires":[]},{"id":"6f49b694.5a7db","type":"inject","z":"fe7c372a.3f09a","name":"","topic":"","payload":"","payloadType":"date","repeat":"1","crontab":"","once":true,"onceDelay":0.1,"x":373.21429443359375,"y":706.5714111328125,"wires":[["616982d.3850c7c"]]},{"id":"616982d.3850c7c","type":"moment","z":"fe7c372a.3f09a","name":"","topic":"","input":"","inputType":"date","inTz":"Europe/Berlin","adjAmount":0,"adjType":"days","adjDir":"add","format":"  dd DD.MM.YYYY HH:mm:ss","locale":"de_DE","output":"","outputType":"msg","outTz":"Europe/Berlin","x":623.0376892089844,"y":716.84326171875,"wires":[["b1f3c773.e7db28","3eb53e66.717f3a"]]},{"id":"3eb53e66.717f3a","type":"ui_text","z":"fe7c372a.3f09a","group":"f7e0940a.03b098","order":2,"width":0,"height":0,"name":"","label":"Datum/Uhrzeit:","format":"{{msg.payload}}","layout":"col-center","x":896.2142791748047,"y":770.5714111328125,"wires":[]},{"id":"248a684e.b20a98","type":"ui_text","z":"fe7c372a.3f09a","group":"f7e0940a.03b098","order":4,"width":0,"height":0,"name":"","label":"Aktuelle Temperatur:","format":"{{msg.payload}}","layout":"col-center","x":484.2142028808594,"y":181.7714385986328,"wires":[]},{"id":"15b7673b.836141","type":"function","z":"fe7c372a.3f09a","name":"Funktion mysql insert","func":"var temperature=msg.payload;\nmsg.topic=\"INSERT INTO temp_test (temperature) VALUES ('\" + temperature + \"')\";\nreturn msg;","outputs":1,"noerr":0,"x":454.2142639160156,"y":129.02857971191406,"wires":[["685c4557.bcfbd4"]]},{"id":"34ce0dc3.54feca","type":"mysql","z":"fe7c372a.3f09a","mydb":"aa52b272.9325e8","name":"mysql thermostat_temp","x":785.2142791748047,"y":89.57142639160156,"wires":[["7c868e4f.bf2b7"]]},{"id":"7c868e4f.bf2b7","type":"debug","z":"fe7c372a.3f09a","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1079.2142944335938,"y":88.57142639160156,"wires":[]},{"id":"685c4557.bcfbd4","type":"delay","z":"fe7c372a.3f09a","name":"","pauseType":"rate","timeout":"60","timeoutUnits":"seconds","rate":"1","nbRateUnits":"300","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":true,"x":688.357177734375,"y":163.42857360839844,"wires":[["34ce0dc3.54feca"]]},{"id":"b3b7b1ce.7525b","type":"debug","z":"fe7c372a.3f09a","name":"relais","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":1334.9998779296875,"y":220.2856903076172,"wires":[]},{"id":"61a2aa3a.194e34","type":"debug","z":"fe7c372a.3f09a","name":"Webseite","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":1716.2383499145508,"y":588.7619190216064,"wires":[]},{"id":"79e8e3de.66ac6c","type":"mysql","z":"fe7c372a.3f09a","mydb":"d8d257e3.8491e","name":"","x":1590.0004539489746,"y":438.2953414916992,"wires":[["ba027cd.5d5ce"]]},{"id":"6bfb907.2ec83f","type":"function","z":"fe7c372a.3f09a","name":"mysql select tab_heizung_relais","func":"jetzt = new Date();\njetzt.toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\nvar gesetzt = new Date();\n var tage = 8;\n\t\t\t\t\ngesetzt.setDate(jetzt.getDate() - tage);\nvar datum=gesetzt.toLocaleDateString('se-SE', { year: 'numeric', month: '2-digit', day: '2-digit' });\n\nmsg.topic=\"SELECT id, DATE_FORMAT(datum_zeit,'%d.%m.%Y %H:%i') AS datum_zeit, heizung_relais AS hzg, temp_thermostat,solltemp FROM  tab_heizung_relais where date_format(datum_zeit,'%Y-%m-%d') >=  '\" + datum + \"' ORDER BY datum_zeit DESC\";\nreturn msg;","outputs":1,"noerr":0,"x":1328.809684753418,"y":409.2952289581299,"wires":[["79e8e3de.66ac6c","924b2de.74d9a5"]]},{"id":"ba027cd.5d5ce","type":"debug","z":"fe7c372a.3f09a","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1731.21435546875,"y":341.1143493652344,"wires":[]},{"id":"bb1bec70.0b402","type":"http response","z":"fe7c372a.3f09a","name":"","statusCode":"","headers":{"content-type":"text/html"},"x":1800.7860107421875,"y":495.6286315917969,"wires":[]},{"id":"3b9e1324.2b7f44","type":"function","z":"fe7c372a.3f09a","name":"","func":"jetzt = new Date();\njetzt.toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\nvar gesetzt = new Date();\n var tage = 5;\n\t\t\t\t\ngesetzt.setDate(jetzt.getDate() - tage);\nvar datum=gesetzt.toLocaleDateString('se-SE', { year: 'numeric', month: '2-digit', day: 'numeric' });\nmsg.payload=datum;\nreturn msg;","outputs":1,"noerr":0,"x":1427.857208251953,"y":684.5714242117745,"wires":[["a82999c1.e0905"]]},{"id":"7861a82a.3af2d8","type":"inject","z":"fe7c372a.3f09a","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":1239.285692487444,"y":707.142835344587,"wires":[["3b9e1324.2b7f44"]]},{"id":"a82999c1.e0905","type":"debug","z":"fe7c372a.3f09a","name":"datum","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":1567.857208251953,"y":686.2857273646763,"wires":[]},{"id":"924b2de.74d9a5","type":"debug","z":"fe7c372a.3f09a","name":"datum_heizungsrelais","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":1696.9999694824214,"y":248.7999877929687,"wires":[]},{"id":"4ba68fc7.65fd88","type":"mqtt in","z":"fe7c372a.3f09a","name":"temp_thermostat","topic":"/EOH_Thermostat_WZ/temp_wz/TempWZ","qos":"2","datatype":"auto","broker":"2e7e0d99.9e092a","x":961,"y":280.79998779296875,"wires":[["b3b7b1ce.7525b","f8d01b6.733c268"]]},{"id":"f8d01b6.733c268","type":"function","z":"fe7c372a.3f09a","name":"speichern_temp_thermostat","func":"var temp_thermostat=global.get('temp_thermostat') || 0;\nglobal.set('temp_thermostat',msg.payload);\nmsg.payload=temp_thermostat;\nreturn msg;","outputs":1,"noerr":0,"x":1273,"y":144.79998779296875,"wires":[["db7a1ad9.44dc38"]]},{"id":"db7a1ad9.44dc38","type":"debug","z":"fe7c372a.3f09a","name":"flow","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":1452.9999694824216,"y":62.799987792968736,"wires":[]},{"id":"f35a9f5f.7c3318","type":"function","z":"fe7c372a.3f09a","name":"flow set solltemp","func":"var solltemp_flow=flow.get('solltemp_flow') || 0;\nglobal.set('solltemp_flow',msg.payload);\nmsg.payload=solltemp_flow;\nreturn msg;","outputs":1,"noerr":0,"x":718.9999694824218,"y":447.99996948242176,"wires":[[]]},{"id":"8dd89c85.dd1ad8","type":"function","z":"fe7c372a.3f09a","name":"mysql insert solltemp","func":" var solltemp= msg.payload;\n var temp_thermostat=global.get('temp_thermostat');\nmsg.topic=\"INSERT INTO tab_solltemp (solltemp,akt_temp) VALUES ('\" + solltemp + \"','\" + temp_thermostat + \"')\";\nreturn msg;","outputs":1,"noerr":0,"x":264.99999999999994,"y":481.99996948242176,"wires":[["df0fea1.d90aa98","4e66c1f9.72046","4211d64e.3994b"]]},{"id":"df0fea1.d90aa98","type":"mysql","z":"fe7c372a.3f09a","mydb":"d8d257e3.8491e","name":"","x":132.99999999999997,"y":602.8000183105468,"wires":[[]]},{"id":"45caad1e.d3db0c","type":"mysql","z":"fe7c372a.3f09a","mydb":"aa52b272.9325e8","name":"","x":420,"y":860,"wires":[["d71ee146.83a81"]]},{"id":"68f2b1a4.b6cea8","type":"function","z":"fe7c372a.3f09a","name":"","func":"jetzt = new Date();\njetzt.toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\nvar gesetzt = new Date();\n var tage = 7;\n\t\t\t\t\ngesetzt.setDate(jetzt.getDate() - tage);\nvar datum=gesetzt.toLocaleDateString('se-SE', { year: 'numeric', month: '2-digit', day: '2-digit' });\n\nmsg.topic=\"SELECT id, DATE_FORMAT(datum_zeit,'%d.%m.%Y %H:%i') AS datum_zeit, solltemp, akt_temp FROM  tab_solltemp where date_format(datum_zeit,'%Y-%m-%d') >=  '\" + datum + \"' ORDER BY datum_zeit DESC\";\nreturn msg;","outputs":1,"noerr":0,"x":285.01555252075195,"y":891.3974761962891,"wires":[["45caad1e.d3db0c"]]},{"id":"d71ee146.83a81","type":"ui_template","z":"fe7c372a.3f09a","group":"d9abaea8.3c87c","name":"Webseite Solltemp","order":3,"width":"6","height":"12","format":"<p>Veränderung Solltemperatur</p>\n<table id=\"table\" border=\"1\">\n     <tr>\n        <th>id</th> \n        <th>datum_zeit</th>\n        <th>solltemp</th>\n         <th>akt_temp</th>\n        \n </tr>\n <tbody>\n <tr ng-repeat=\"row in msg.payload\">\n   <td ng-repeat=\"item in row\" align=\"center\" style=\"padding-left: 10px; padding-right: 10px;\">{{item}}</td>\n </tr>\n </tbody>\n</table>\n\n","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":634.4982757568359,"y":882.8602447509766,"wires":[[]]},{"id":"84a2c451.23dcc8","type":"ui_button","z":"fe7c372a.3f09a","name":"","group":"d9abaea8.3c87c","order":2,"width":0,"height":0,"passthru":false,"label":"Tabelle Solltemp aktualisieren","tooltip":"","color":"","bgcolor":"","icon":"","payload":"","payloadType":"date","topic":"","x":194.39999389648438,"y":802.4000244140625,"wires":[["68f2b1a4.b6cea8"]]},{"id":"fc4ac129.ff6f4","type":"mqtt in","z":"fe7c372a.3f09a","name":"","topic":"/EOH_Thermostat_WZ/Solltemp_Dev/SollTemp","qos":"2","datatype":"auto","broker":"2e7e0d99.9e092a","x":185,"y":312.8000183105469,"wires":[["b044b756.f6151"]]},{"id":"4e66c1f9.72046","type":"debug","z":"fe7c372a.3f09a","name":"solltemp","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":143,"y":690.800048828125,"wires":[]},{"id":"4211d64e.3994b","type":"debug","z":"fe7c372a.3f09a","name":"payload solltemp_insert","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":200,"y":560,"wires":[]},{"id":"f7e0940a.03b098","type":"ui_group","z":"","name":"           Akt.Temperatur/Solltemperatur","tab":"99ea10ca.1b537","disp":true,"width":"6","collapse":false},{"id":"2e7e0d99.9e092a","type":"mqtt-broker","z":"","name":"","broker":"192.168.178.101","port":"1883","clientid":"","usetls":false,"compatmode":true,"keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"aa52b272.9325e8","type":"MySQLdatabase","z":"","host":"192.168.178.101","port":"3306","db":"node-red","tz":""},{"id":"d8d257e3.8491e","type":"MySQLdatabase","z":"","host":"192.168.178.101","port":"3306","db":"node-red","tz":"Europe/Berlin"},{"id":"d9abaea8.3c87c","type":"ui_group","z":"","name":"Solltemp Tabelle","tab":"ca8e9a6a.066ca","disp":true,"width":"6","collapse":false},{"id":"99ea10ca.1b537","type":"ui_tab","z":"","name":"            Aktuelle Temperatur Solltemperatur","icon":"dashboard","order":4,"disabled":false,"hidden":false},{"id":"ca8e9a6a.066ca","type":"ui_tab","z":"","name":"Solltemp Tabelle","icon":"dashboard","order":6,"disabled":false,"hidden":false}]