[ { "id": "dd0a198e.d4f608", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last CO2_01", "query": "select * from CO2_01 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 320, "y": 80, "wires": [ [ "dcc73a44.0dd05" ] ] }, { "id": "11486829.7d2fd8", "type": "inject", "z": "6ee0e9e7.a5e19", "name": "", "topic": "", "payload": "", "payloadType": "date", "repeat": "60", "crontab": "", "once": true, "onceDelay": 0.1, "x": 110, "y": 580, "wires": [ [ "dd0a198e.d4f608", "289b7424.d36ce4", "aab844ab.d20e9", "24ca7642.3f310a", "9b298305.2c2008", "b2b09fad.8075a", "3a9ab2c8.940776", "7672dfdc.61f098", "3a695b06.657f8c" ] ] }, { "id": "dcc73a44.0dd05", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 80, "wires": [ [ "207a0d.403355f4" ] ] }, { "id": "207a0d.403355f4", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 80, "wires": [ [ "407ba19.12cfbe" ] ] }, { "id": "407ba19.12cfbe", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 140, "wires": [ [ "a8d4f86.99f8b08" ] ] }, { "id": "5bb581b.7336", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_01_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 740, "y": 1020, "wires": [] }, { "id": "a8d4f86.99f8b08", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set CO2_01_json flow variable", "func": "flow.set(\"CO2_01_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 140, "wires": [ [] ] }, { "id": "7d818443.9ccbbc", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get CO2_01_json flow variable", "func": "msg.payload = flow.get(\"CO2_01_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1020, "wires": [ [ "5bb581b.7336" ] ] }, { "id": "25a433c8.5139c4", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_01", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 240, "y": 1020, "wires": [ [ "7d818443.9ccbbc" ] ] }, { "id": "289b7424.d36ce4", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last CO2_02", "query": "select * from CO2_02 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 320, "y": 180, "wires": [ [ "b5919493.503488" ] ] }, { "id": "b5919493.503488", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 180, "wires": [ [ "5b26874a.8650f8" ] ] }, { "id": "5b26874a.8650f8", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 180, "wires": [ [ "6db80420.50a5ec" ] ] }, { "id": "6db80420.50a5ec", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 240, "wires": [ [ "50aafd6e.72c1bc" ] ] }, { "id": "50aafd6e.72c1bc", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set CO2_02_json flow variable", "func": "flow.set(\"CO2_02_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 240, "wires": [ [] ] }, { "id": "aab844ab.d20e9", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last CO2_03", "query": "select * from CO2_03 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 320, "y": 280, "wires": [ [ "eaaf030c.84fa7" ] ] }, { "id": "eaaf030c.84fa7", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 280, "wires": [ [ "bbb99597.3379b" ] ] }, { "id": "bbb99597.3379b", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 280, "wires": [ [ "55a243e5.8068f4" ] ] }, { "id": "55a243e5.8068f4", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 340, "wires": [ [ "6ee22e3a.69887" ] ] }, { "id": "6ee22e3a.69887", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set CO2_03_json flow variable", "func": "flow.set(\"CO2_03_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 340, "wires": [ [] ] }, { "id": "24ca7642.3f310a", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last CO2_04", "query": "select * from CO2_04 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 320, "y": 380, "wires": [ [ "d09e8ad9.c9a1f8" ] ] }, { "id": "d09e8ad9.c9a1f8", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 380, "wires": [ [ "4ad59c8e.cfe264" ] ] }, { "id": "4ad59c8e.cfe264", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 380, "wires": [ [ "f5c984c5.9012a8" ] ] }, { "id": "f5c984c5.9012a8", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 440, "wires": [ [ "66de3e5c.8df73" ] ] }, { "id": "66de3e5c.8df73", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set CO2_04_json flow variable", "func": "flow.set(\"CO2_04_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 440, "wires": [ [] ] }, { "id": "75c81d52.573614", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_02_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 740, "y": 1080, "wires": [] }, { "id": "dc03f60c.d9c8b", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get CO2_02_json flow variable", "func": "msg.payload = flow.get(\"CO2_02_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1080, "wires": [ [ "75c81d52.573614" ] ] }, { "id": "fe5c77e9.48ee88", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_02", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 240, "y": 1080, "wires": [ [ "dc03f60c.d9c8b" ] ] }, { "id": "23a0057b.5467fa", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_03_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 740, "y": 1140, "wires": [] }, { "id": "b5b4dd2b.fdca98", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get CO2_03_json flow variable", "func": "msg.payload = flow.get(\"CO2_03_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1140, "wires": [ [ "23a0057b.5467fa" ] ] }, { "id": "d3a4a8f9.f9c7d8", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_03", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 240, "y": 1140, "wires": [ [ "b5b4dd2b.fdca98" ] ] }, { "id": "5ba01df.743ffe4", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_04_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 740, "y": 1200, "wires": [] }, { "id": "bbe12f2d.76d22", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get CO2_02_json flow variable", "func": "msg.payload = flow.get(\"CO2_04_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1200, "wires": [ [ "5ba01df.743ffe4" ] ] }, { "id": "63873130.dcc588", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "CO2_04", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 240, "y": 1200, "wires": [ [ "bbe12f2d.76d22" ] ] }, { "id": "9b298305.2c2008", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last aq01", "query": "select * from aq01 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 310, "y": 480, "wires": [ [ "d08f9c72.de50f8" ] ] }, { "id": "d08f9c72.de50f8", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 480, "wires": [ [ "5e542001.d6c19" ] ] }, { "id": "5e542001.d6c19", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 480, "wires": [ [ "4ff44c44.08d79c" ] ] }, { "id": "d4b86c5e.1fe3e", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set AQ_01_json flow variable", "func": "flow.set(\"AQ_01_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 540, "wires": [ [] ] }, { "id": "4ff44c44.08d79c", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 540, "wires": [ [ "d4b86c5e.1fe3e" ] ] }, { "id": "11ae7d4d.c511b3", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_01_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 730, "y": 1260, "wires": [] }, { "id": "f8689245.bc3ed8", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get AQ_01_json flow variable", "func": "msg.payload = flow.get(\"AQ_01_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1260, "wires": [ [ "11ae7d4d.c511b3" ] ] }, { "id": "4d71646c.d1a47c", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_01", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 230, "y": 1260, "wires": [ [ "f8689245.bc3ed8" ] ] }, { "id": "8784b4c4.16819", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_02_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 730, "y": 1320, "wires": [] }, { "id": "514cce26.3d736", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_02", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 230, "y": 1320, "wires": [ [ "ddaf43f0.697fc" ] ] }, { "id": "ddaf43f0.697fc", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get AQ_02_json flow variable", "func": "msg.payload = flow.get(\"AQ_02_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1320, "wires": [ [ "8784b4c4.16819" ] ] }, { "id": "a7215181.268eb8", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_03_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 730, "y": 1380, "wires": [] }, { "id": "58fe952e.d24524", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get AQ_03_json flow variable", "func": "msg.payload = flow.get(\"AQ_03_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1380, "wires": [ [ "a7215181.268eb8" ] ] }, { "id": "71b3b3fc.26bcd4", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_03", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 230, "y": 1380, "wires": [ [ "58fe952e.d24524" ] ] }, { "id": "819e9799.c3061", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_04_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 730, "y": 1440, "wires": [] }, { "id": "198efc01.63114c", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "AQ_04", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 230, "y": 1440, "wires": [ [ "a190b122.577328" ] ] }, { "id": "a190b122.577328", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get AQ_04_json flow variable", "func": "msg.payload = flow.get(\"AQ_04_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1440, "wires": [ [ "819e9799.c3061" ] ] }, { "id": "b2b09fad.8075a", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last aq02", "query": "select * from aq02 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 310, "y": 580, "wires": [ [ "65944328.d2b254" ] ] }, { "id": "65944328.d2b254", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 580, "wires": [ [ "ab228db.4f16ef" ] ] }, { "id": "ab228db.4f16ef", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 580, "wires": [ [ "92cdaec4.ef8b1" ] ] }, { "id": "2dc552b1.b574e6", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set AQ_02_json flow variable", "func": "flow.set(\"AQ_02_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 640, "wires": [ [] ] }, { "id": "92cdaec4.ef8b1", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 640, "wires": [ [ "2dc552b1.b574e6" ] ] }, { "id": "3a9ab2c8.940776", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last aq03", "query": "select * from aq03 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 310, "y": 680, "wires": [ [ "d9750d9d.d71aa8" ] ] }, { "id": "d9750d9d.d71aa8", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 680, "wires": [ [ "49febea9.8910c" ] ] }, { "id": "49febea9.8910c", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 680, "wires": [ [ "bf620f52.32588" ] ] }, { "id": "9eed0058.be228", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set AQ_03_json flow variable", "func": "flow.set(\"AQ_03_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 740, "wires": [ [] ] }, { "id": "bf620f52.32588", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 740, "wires": [ [ "9eed0058.be228" ] ] }, { "id": "7672dfdc.61f098", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last aq04", "query": "select * from aq04 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 310, "y": 780, "wires": [ [ "e107c29.0229fc" ] ] }, { "id": "e107c29.0229fc", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 780, "wires": [ [ "87490f42.655b8" ] ] }, { "id": "87490f42.655b8", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 780, "wires": [ [ "afac8d2c.dcd008" ] ] }, { "id": "970066fd.06b9c8", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set AQ_04_json flow variable", "func": "flow.set(\"AQ_04_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 570, "y": 840, "wires": [ [] ] }, { "id": "afac8d2c.dcd008", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 840, "wires": [ [ "970066fd.06b9c8" ] ] }, { "id": "3a695b06.657f8c", "type": "influxdb in", "z": "6ee0e9e7.a5e19", "influxdb": "e30e93f3.17f278", "name": "Last trs21_01", "query": "select * from trs21_01 group by * order by desc limit 1", "rawOutput": false, "precision": "", "retentionPolicy": "", "x": 320, "y": 880, "wires": [ [ "60225417.926d64" ] ] }, { "id": "60225417.926d64", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 470, "y": 880, "wires": [ [ "9e16be29.6fc6b8" ] ] }, { "id": "9e16be29.6fc6b8", "type": "function", "z": "6ee0e9e7.a5e19", "name": "Treiem \"[\" i \"]\"", "func": "msg.payload = msg.payload.replace(\"[\",\"\");\nmsg.payload = msg.payload.replace(\"]\",\"\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 620, "y": 880, "wires": [ [ "f87d0c18.e9055" ] ] }, { "id": "735563c8.b826b4", "type": "function", "z": "6ee0e9e7.a5e19", "name": "set TRS21_01_json flow variable", "func": "var vJson = msg.payload;\n\nvJson.fT = vJson.fSoilTemperature_degC;\n\nmsg.payload = vJson;\n\nflow.set(\"TRS21_01_json\",msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "x": 580, "y": 940, "wires": [ [] ] }, { "id": "f87d0c18.e9055", "type": "json", "z": "6ee0e9e7.a5e19", "name": "", "property": "payload", "action": "", "pretty": false, "x": 370, "y": 940, "wires": [ [ "735563c8.b826b4" ] ] }, { "id": "b58c72c4.6060a8", "type": "mqtt out", "z": "6ee0e9e7.a5e19", "name": "", "topic": "TRS21_01_json", "qos": "", "retain": "", "broker": "f182caa7.3580f8", "x": 740, "y": 1500, "wires": [] }, { "id": "50004610.4953c", "type": "mqtt in", "z": "6ee0e9e7.a5e19", "name": "", "topic": "TRS21_01", "qos": "2", "datatype": "auto", "broker": "f182caa7.3580f8", "x": 250, "y": 1500, "wires": [ [ "7d39531a.bc2af4" ] ] }, { "id": "7d39531a.bc2af4", "type": "function", "z": "6ee0e9e7.a5e19", "name": "get TRS21_01_json flow variable", "func": "msg.payload = flow.get(\"TRS21_01_json\");\nreturn msg;", "outputs": 1, "noerr": 0, "x": 490, "y": 1500, "wires": [ [ "b58c72c4.6060a8" ] ] }, { "id": "e30e93f3.17f278", "type": "influxdb", "z": "", "hostname": "127.0.0.1", "port": "8086", "protocol": "http", "database": "rubiSensorsDB", "name": "", "usetls": false, "tls": "" }, { "id": "f182caa7.3580f8", "type": "mqtt-broker", "z": "", "name": "", "broker": "localhost", "port": "1883", "clientid": "", "usetls": false, "compatmode": false, "keepalive": "60", "cleansession": true, "birthTopic": "", "birthQos": "0", "birthPayload": "", "closeTopic": "", "closeQos": "0", "closePayload": "", "willTopic": "", "willQos": "0", "willPayload": "" } ]