[{"id":"1d8b4c3e0a7903a2","type":"tab","label":"Pi-Hole Stats","disabled":false,"info":""},{"id":"7c34cca282628eb9","type":"group","z":"1d8b4c3e0a7903a2","name":"Pi-Hole 1","style":{"stroke":"#ffC000","label":true,"fill":"#ffefbf","fill-opacity":"0.25","color":"#000000"},"nodes":["81308a7f761fb1ce","a4455ddc5150aba5","b5245b8547bd631b","1f5059a48705d2d0","a31189ab1575f654"],"x":334,"y":599,"w":292,"h":202},{"id":"9ca4b2df3a6805f6","type":"group","z":"1d8b4c3e0a7903a2","name":"Pi-Hole 2","style":{"stroke":"#ffC000","fill":"#ffefbf","fill-opacity":"0.25","label":true,"color":"#000000"},"nodes":["b7875708feea1ca0","3801b0f46f96a993","a8e00e1194cc9e79","b7e7053a4f852262","158a3e3886ad44d4"],"x":654,"y":599,"w":292,"h":202},{"id":"e10ad3d0334ac3c2","type":"group","z":"1d8b4c3e0a7903a2","name":"Combined","style":{"stroke":"#ffC000","label":true,"fill":"#ffefbf","fill-opacity":"0.25","color":"#000000"},"nodes":["12137e733ee7b19c","e168129d8a14d22c","11922fab09a11b8b","72b77237ad41ac86","4cd0c965f48bd8ab","6df4bc7a528fc88b"],"x":14,"y":559,"w":292,"h":242},{"id":"148ea8421691ffe2","type":"switch","z":"1d8b4c3e0a7903a2","name":"Split","property":"responseUrl","propertyType":"msg","rules":[{"t":"cont","v":"pihole[0]","vt":"flow"},{"t":"cont","v":"pihole[1]","vt":"flow"}],"checkall":"false","repair":false,"outputs":2,"x":610,"y":180,"wires":[["c96b37605b3b4493"],["f6468806480bf133"]]},{"id":"f6468806480bf133","type":"link out","z":"1d8b4c3e0a7903a2","name":"Display 2","links":["158a3e3886ad44d4"],"x":760,"y":200,"wires":[],"l":true},{"id":"c96b37605b3b4493","type":"link out","z":"1d8b4c3e0a7903a2","name":"Display 1","links":["a31189ab1575f654"],"x":760,"y":160,"wires":[],"l":true},{"id":"85fd1bd1cf95c902","type":"catch","z":"1d8b4c3e0a7903a2","name":"Catch All","scope":["5f0537e0.b72758","7c634fdb.9c626","c78af61d.c427f8","42b26bef.e3f4c4","b01046fc.2ce648","85c9e6ea.3585d8","130bd7d0.a403c8","44bedf190eaf321f","caa06e04.c5dab","5b6cc621.487a88","159fc309.90a7ed","f0539f7d.5126b","c3bda84d.1f5018","e21b1da4.084b8","3908b232.2325ae","3553ea8.f279716","29911ff0.78115","c03e16.6dd131e8","185adda3.1c75d2","59a08c4b.5fcf54","238cde26.69eb62","a3370c93.35c24","2e1a774e.f92df8"],"uncaught":false,"x":980,"y":40,"wires":[["44bedf190eaf321f"]]},{"id":"44bedf190eaf321f","type":"link out","z":"1d8b4c3e0a7903a2","name":"To Error Logging","links":["498db3b5.39bc9c"],"x":1095,"y":40,"wires":[],"icon":"font-awesome/fa-exclamation"},{"id":"db858d3b0c5d49d6","type":"link in","z":"1d8b4c3e0a7903a2","name":"Pi-Hole","links":["ad5c676a.412f78"],"x":35,"y":40,"wires":[["ee4e75da3ad99eb8"]],"icon":"font-awesome/fa-repeat"},{"id":"e1a0bfacd8298aea","type":"inject","z":"1d8b4c3e0a7903a2","name":"Inject","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payloadType":"date","x":90,"y":320,"wires":[["ee4e75da3ad99eb8"]]},{"id":"6c50ceaf912b848e","type":"http request","z":"1d8b4c3e0a7903a2","name":"API Call","method":"GET","ret":"obj","paytoqs":"ignore","url":"","tls":"","persist":false,"proxy":"","authType":"","x":400,"y":240,"wires":[["c72376013d7f4758"]]},{"id":"2cc27acc236f0ad2","type":"function","z":"1d8b4c3e0a7903a2","name":"URLs","func":"var urls = [\n    \"summary\",\n    \"overTimeData10mins\"\n]\n\nflow.get(\"pihole\").forEach(pi => {\n    urls.forEach(url => {\n        msg = {};\n        msg.url = `http://${pi}/admin/api.php?${url}`;\n        node.send(msg);\n    });\n});\n\nnode.done;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":250,"y":260,"wires":[["6c50ceaf912b848e"]]},{"id":"cc9ee7d65d2001b6","type":"join","z":"1d8b4c3e0a7903a2","name":"Join","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"5","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":610,"y":280,"wires":[["a795f989bd3b7919"]]},{"id":"a795f989bd3b7919","type":"function","z":"1d8b4c3e0a7903a2","name":"Merge Data","func":"const zeroPad = (num, places) => String(num).padStart(places, \"0\")\nfunction addCommas(n) {\n    var rx = /(\\d+)(\\d{3})/;\n    return String(n).replace(/^\\d+/, function (w) {\n        while (rx.test(w)) {\n            w = w.replace(rx, '$1,$2');\n        }\n        return w;\n    });\n}\nvar rtn = {\n    \"domains_being_blocked\": 0,\n    \"dns_queries_today\": 0,\n    \"ads_blocked_today\": 0,\n    \"ads_percentage_today\": 0,\n    \"last_updated\": \"never\"\n}\n\nmsg.payload.forEach(item => {\n    rtn.domains_being_blocked  = parseFloat(item.domains_being_blocked.replace(/\\,/g, \"\"));\n    rtn.dns_queries_today     += parseFloat(item.dns_queries_today.replace(/\\,/g, \"\"));\n    rtn.ads_blocked_today     += parseFloat(item.ads_blocked_today.replace(/\\,/g, \"\"));\n});\n\nrtn.ads_percentage_today = ((rtn.ads_blocked_today / rtn.dns_queries_today) * 100).toFixed(1);\n\nrtn.last_updated = `` +\n    `${        msg.payload[0].gravity_last_updated.relative.days}d, ` +\n    `${zeroPad(msg.payload[0].gravity_last_updated.relative.hours,   2)}:` +\n    `${zeroPad(msg.payload[0].gravity_last_updated.relative.minutes, 2)} ago`;\n\n\nrtn.domains_being_blocked = addCommas(rtn.domains_being_blocked);\nrtn.dns_queries_today     = addCommas(rtn.dns_queries_today);\nrtn.ads_blocked_today     = addCommas(rtn.ads_blocked_today);\n\nreturn {payload: rtn};\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":770,"y":280,"wires":[["8283703bf96665ce"]]},{"id":"12137e733ee7b19c","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"e10ad3d0334ac3c2","group":"a446b7977f7fef02","order":1,"width":7,"height":1,"name":"Total","label":"Total Queries","format":"{{payload.dns_queries_today}}","layout":"row-spread","x":190,"y":600,"wires":[]},{"id":"e168129d8a14d22c","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"e10ad3d0334ac3c2","group":"a446b7977f7fef02","order":2,"width":7,"height":1,"name":"Blocked","label":"Queries Blocked","format":"{{payload.ads_blocked_today}}","layout":"row-spread","x":200,"y":640,"wires":[]},{"id":"11922fab09a11b8b","type":"ui_gauge","z":"1d8b4c3e0a7903a2","g":"e10ad3d0334ac3c2","name":"% Blocked","group":"a446b7977f7fef02","order":3,"width":7,"height":4,"gtype":"donut","title":"","label":"%","format":"{{payload.ads_percentage_today}}","min":0,"max":"100","colors":["#bf790a","#bf790a","#bf790a"],"seg1":"","seg2":"","x":210,"y":720,"wires":[]},{"id":"72b77237ad41ac86","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"e10ad3d0334ac3c2","group":"a446b7977f7fef02","order":4,"width":7,"height":1,"name":"Domains","label":"Domains On Blocklist","format":"{{payload.domains_being_blocked}}","layout":"row-spread","x":200,"y":680,"wires":[]},{"id":"4cd0c965f48bd8ab","type":"link in","z":"1d8b4c3e0a7903a2","g":"e10ad3d0334ac3c2","name":"Combined","links":["8283703bf96665ce"],"x":55,"y":620,"wires":[["12137e733ee7b19c","e168129d8a14d22c","72b77237ad41ac86","11922fab09a11b8b","6df4bc7a528fc88b"]]},{"id":"8283703bf96665ce","type":"link out","z":"1d8b4c3e0a7903a2","name":"Combined","links":["4cd0c965f48bd8ab"],"x":950,"y":280,"wires":[],"l":true},{"id":"c72376013d7f4758","type":"switch","z":"1d8b4c3e0a7903a2","name":"Switch","property":"payload.domains_being_blocked","propertyType":"msg","rules":[{"t":"nnull"},{"t":"else"}],"checkall":"false","repair":false,"outputs":2,"x":450,"y":300,"wires":[["cc9ee7d65d2001b6","148ea8421691ffe2"],["7aeac8260c9f129f"]]},{"id":"7aeac8260c9f129f","type":"join","z":"1d8b4c3e0a7903a2","name":"Join","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"5","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":610,"y":320,"wires":[["407c60470168b1f4"]]},{"id":"407c60470168b1f4","type":"function","z":"1d8b4c3e0a7903a2","name":"Format Chart Data","func":"var queries = [];  // domains_over_time\nvar blocked = [];  // ads_over_time\nvar labels  = [];\n\nObject.keys(msg.payload[0].domains_over_time).forEach(item => {\n    var q = 0;\n    var b = 0;\n\n    msg.payload.forEach(pihole => {\n        q += parseInt(pihole.domains_over_time[item] || 0);\n        b += parseInt(pihole.ads_over_time[item] || 0);\n    });\n\n    queries.push(q);\n    blocked.push(b);\n\n    var time = new Date(parseInt(`${item}000`)).toLocaleTimeString(\"en-GB\", { timeStyle: \"short\", hour12: false });\n    labels.push(time);\n});\n\n\n// Node Status Text\nnode.status({\n    fill: \"green\",\n    shape: \"dot\",\n    text: `Updated: ${(new Date().toLocaleTimeString(\"en-GB\", { timeStyle: \"short\", hour12: false }))}`\n});\n\n\nreturn {\n    payload: [{\n        series: [\"Queries\", \"Blocked\"],\n        data: [queries, blocked],\n        labels: labels\n    }]\n};\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":790,"y":320,"wires":[["0547972f0bf139b0"]]},{"id":"0547972f0bf139b0","type":"ui_chart","z":"1d8b4c3e0a7903a2","name":"Chart","group":"3fa859c69921aae9","order":1,"width":24,"height":8,"label":"Pi-Hole Combined Results","chartType":"bar","legend":"true","xformat":"HH:mm","interpolate":"bezier","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"138","removeOlderUnit":"604800","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#008548","#009abf","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"x":970,"y":320,"wires":[[]]},{"id":"6df4bc7a528fc88b","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"e10ad3d0334ac3c2","group":"a446b7977f7fef02","order":5,"width":7,"height":1,"name":"Updated","label":"Gravity Updated","format":"{{payload.last_updated}}","layout":"row-spread","x":200,"y":760,"wires":[]},{"id":"126283b1a8e36ecb","type":"ui_template","z":"1d8b4c3e0a7903a2","group":"8d2a1c92.0b91f","name":"Section Colours","order":26,"width":0,"height":0,"format":"<style>\n/* GLOBAL */\n    [node-id=\"12137e733ee7b19c\"]:before,\n    [node-id=\"e168129d8a14d22c\"]:before,\n    [node-id=\"11922fab09a11b8b\"]:before,\n    [node-id=\"72b77237ad41ac86\"]:before,\n    [node-id=\"6df4bc7a528fc88b\"]:before {\n        font-size: 2.5em !important;\n    }\n\n    [node-id=\"12137e733ee7b19c\"]:before,\n    [node-id=\"81308a7f761fb1ce\"]:before,\n    [node-id=\"3801b0f46f96a993\"]:before,\n    [node-id=\"e168129d8a14d22c\"]:before,\n    [node-id=\"a4455ddc5150aba5\"]:before,\n    [node-id=\"a8e00e1194cc9e79\"]:before,\n    [node-id=\"11922fab09a11b8b\"]:before,\n    [node-id=\"b5245b8547bd631b\"]:before,\n    [node-id=\"b7875708feea1ca0\"]:before,\n    [node-id=\"72b77237ad41ac86\"]:before,\n    [node-id=\"1f5059a48705d2d0\"]:before,\n    [node-id=\"b7e7053a4f852262\"]:before,\n    [node-id=\"6df4bc7a528fc88b\"]:before {\n        position: absolute;\n        font-family: 'FontAwesome';\n        top: 3px;\n        left: auto;\n        right: 5px;\n        font-size: 1.5em;\n        display: block;\n        color: #FFFFFF40;\n    }\n\n\n/* TOTAL - Green */\n    [node-id=\"12137e733ee7b19c\"]:before,\n    [node-id=\"81308a7f761fb1ce\"]:before,\n    [node-id=\"3801b0f46f96a993\"]:before {\n        content: \"\\f0ac\";\n    }\n\n    [node-id=\"12137e733ee7b19c\"],\n    [node-id=\"81308a7f761fb1ce\"],\n    [node-id=\"3801b0f46f96a993\"] {\n        background-color: #008548FF !important;\n    }\n\n\n/* BLOCKED - Blue */\n    [node-id=\"e168129d8a14d22c\"]:before,\n    [node-id=\"a4455ddc5150aba5\"]:before,\n    [node-id=\"a8e00e1194cc9e79\"]:before {\n        content: \"\\f256\";\n    }\n\n    [node-id=\"e168129d8a14d22c\"],\n    [node-id=\"a4455ddc5150aba5\"],\n    [node-id=\"a8e00e1194cc9e79\"] {\n        background-color: #009ABFFF !important;\n    }\n\n\n/* PERCENT BLOCKED - Orange */\n    [node-id=\"11922fab09a11b8b\"]:before,\n    [node-id=\"b5245b8547bd631b\"]:before,\n    [node-id=\"b7875708feea1ca0\"]:before {\n        content: \"\\f200\";\n    }\n\n    [node-id=\"11922fab09a11b8b\"],\n    [node-id=\"b5245b8547bd631b\"],\n    [node-id=\"b7875708feea1ca0\"] {\n        background-color: #BF790A50 !important;\n    }\n\n\n/* BLOCKLIST - Red */\n    [node-id=\"72b77237ad41ac86\"]:before,\n    [node-id=\"1f5059a48705d2d0\"]:before,\n    [node-id=\"b7e7053a4f852262\"]:before {\n        content: \"\\f022\";\n    }\n\n    [node-id=\"72b77237ad41ac86\"],\n    [node-id=\"1f5059a48705d2d0\"],\n    [node-id=\"b7e7053a4f852262\"] {\n        background-color: #A22B1CFF !important;\n    }\n\n/* UPDATE */\n    [node-id=\"6df4bc7a528fc88b\"]:before {\n        content: \"\\f017\";\n    }\n</style>\n","storeOutMessages":true,"fwdInMessages":true,"resendOnRefresh":true,"templateScope":"global","x":800,"y":40,"wires":[[]]},{"id":"81308a7f761fb1ce","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"7c34cca282628eb9","group":"8aa946fb18d5a4ad","order":1,"width":3,"height":1,"name":"Total","label":"","format":"{{payload.dns_queries_today}}","layout":"row-spread","x":510,"y":640,"wires":[]},{"id":"a4455ddc5150aba5","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"7c34cca282628eb9","group":"8aa946fb18d5a4ad","order":4,"width":3,"height":1,"name":"Blocked","label":"","format":"{{payload.ads_blocked_today}}","layout":"row-spread","x":520,"y":680,"wires":[]},{"id":"b5245b8547bd631b","type":"ui_gauge","z":"1d8b4c3e0a7903a2","g":"7c34cca282628eb9","name":"% Blocked","group":"8aa946fb18d5a4ad","order":7,"width":3,"height":2,"gtype":"donut","title":"","label":"%","format":"{{payload.ads_percentage_today}}","min":0,"max":"100","colors":["#bf790a","#bf790a","#bf790a"],"seg1":"","seg2":"","x":530,"y":760,"wires":[]},{"id":"1f5059a48705d2d0","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"7c34cca282628eb9","group":"8aa946fb18d5a4ad","order":11,"width":3,"height":1,"name":"Domains","label":"","format":"{{payload.domains_being_blocked}}","layout":"row-spread","x":520,"y":720,"wires":[]},{"id":"a31189ab1575f654","type":"link in","z":"1d8b4c3e0a7903a2","g":"7c34cca282628eb9","name":"Display 1","links":["c96b37605b3b4493"],"x":375,"y":660,"wires":[["81308a7f761fb1ce","a4455ddc5150aba5","b5245b8547bd631b","1f5059a48705d2d0"]]},{"id":"b7875708feea1ca0","type":"ui_gauge","z":"1d8b4c3e0a7903a2","g":"9ca4b2df3a6805f6","name":"% Blocked","group":"8aa946fb18d5a4ad","order":9,"width":3,"height":2,"gtype":"donut","title":"","label":"%","format":"{{payload.ads_percentage_today}}","min":0,"max":"100","colors":["#bf790a","#bf790a","#bf790a"],"seg1":"","seg2":"","x":850,"y":760,"wires":[]},{"id":"3801b0f46f96a993","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"9ca4b2df3a6805f6","group":"8aa946fb18d5a4ad","order":3,"width":3,"height":1,"name":"Total","label":"","format":"{{payload.dns_queries_today}}","layout":"row-spread","x":830,"y":640,"wires":[]},{"id":"a8e00e1194cc9e79","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"9ca4b2df3a6805f6","group":"8aa946fb18d5a4ad","order":6,"width":3,"height":1,"name":"Blocked","label":"","format":"{{payload.ads_blocked_today}}","layout":"row-spread","x":840,"y":680,"wires":[]},{"id":"b7e7053a4f852262","type":"ui_text","z":"1d8b4c3e0a7903a2","g":"9ca4b2df3a6805f6","group":"8aa946fb18d5a4ad","order":13,"width":3,"height":1,"name":"Domains","label":"","format":"{{payload.domains_being_blocked}}","layout":"row-spread","x":840,"y":720,"wires":[]},{"id":"158a3e3886ad44d4","type":"link in","z":"1d8b4c3e0a7903a2","g":"9ca4b2df3a6805f6","name":"Display 2","links":["f6468806480bf133"],"x":695,"y":660,"wires":[["b7875708feea1ca0","3801b0f46f96a993","a8e00e1194cc9e79","b7e7053a4f852262"]]},{"id":"ee4e75da3ad99eb8","type":"change","z":"1d8b4c3e0a7903a2","name":"Settings","rules":[{"t":"set","p":"pihole","pt":"flow","to":"[\"192.168.1.1\",\"192.168.1.2\"]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":100,"y":260,"wires":[["2cc27acc236f0ad2"]]},{"id":"feb90b4184aae41e","type":"ui_spacer","z":"1d8b4c3e0a7903a2","name":"spacer","group":"8aa946fb18d5a4ad","order":2,"width":1,"height":1},{"id":"fc1b9ec644420c7f","type":"ui_spacer","z":"1d8b4c3e0a7903a2","name":"spacer","group":"8aa946fb18d5a4ad","order":5,"width":1,"height":1},{"id":"589d9f446c711aba","type":"ui_spacer","z":"1d8b4c3e0a7903a2","name":"spacer","group":"8aa946fb18d5a4ad","order":8,"width":1,"height":1},{"id":"2ff832d83e4b0942","type":"ui_spacer","z":"1d8b4c3e0a7903a2","name":"spacer","group":"8aa946fb18d5a4ad","order":10,"width":1,"height":1},{"id":"6f269d10b882c461","type":"ui_spacer","z":"1d8b4c3e0a7903a2","name":"spacer","group":"8aa946fb18d5a4ad","order":12,"width":1,"height":1},{"id":"6cb7f33e2dbfa915","type":"ui_spacer","z":"1d8b4c3e0a7903a2","name":"spacer","group":"8aa946fb18d5a4ad","order":15,"width":1,"height":1},{"id":"a446b7977f7fef02","type":"ui_group","name":"Combined","tab":"76430e3d260dac90","order":1,"disp":true,"width":"7","collapse":false},{"id":"3fa859c69921aae9","type":"ui_group","name":"Combined Chart","tab":"76430e3d260dac90","order":2,"disp":true,"width":24,"collapse":false},{"id":"8d2a1c92.0b91f","type":"ui_group","name":"Countdown Timers","tab":"1d54b591.3f74ea","order":2,"disp":true,"width":"7","collapse":false},{"id":"8aa946fb18d5a4ad","type":"ui_group","name":"Individual Pi-Holes","tab":"76430e3d260dac90","order":4,"disp":true,"width":"7","collapse":false},{"id":"76430e3d260dac90","type":"ui_tab","name":"Pi-Hole","icon":"phonelink","order":10,"disabled":false,"hidden":false},{"id":"1d54b591.3f74ea","type":"ui_tab","name":"Timers","icon":"timer","order":1,"disabled":false,"hidden":false}]