[
    {
        "id": "edd704eac37c28c1",
        "type": "function",
        "z": "cac42713c2f8a208",
        "name": "SQL",
        "func": "// This will handle any device and any attribute as long as it is in the DB\nvar Week  = 604800000 ; //7 Days\nvar Day   =  86400000 ; // 1 Days\nvar d = new Date();\nvar epoch = d.getTime();\nvar fromdate = epoch - Day;\nvar enddate = epoch;\nvar output = [];\n\nfor (var property in msg.payload) {\n    if (msg.payload.hasOwnProperty(property)) {\n        //output.push({ payload: property + \" has value \"+msg.payload[property] });\n        if (msg.payload[property]) {\n            var parts = property.split(\"/\");\n            if (parts[0]===\"period\") {\n                switch (parts[1]) {\n                    case \"today\":\n                        fromdate = epoch-Day;\n                        enddate = epoch;\n                        break;\n                    case \"yesterday\":\n                        fromdate = epoch-2*Day;\n                        enddate = epoch-Day;\n                        break;\n                    case \"week\":\n                        fromdate = epoch-Week;\n                        enddate = epoch;\n                        break;\n                }\n            } else {\n                output.push({ topic: \"SELECT * FROM seedhouse WHERE Node='\"+parts[0]+\"' AND Sensor='\"+parts[1]+\"' AND epoch >= \" + fromdate + \" AND epoch <= \" + enddate });\n            }\n        }\n    }\n}\n\noutput[output.length-1].complete=true;\n\nreturn [ output ];\n\n//msg.topic = \"SELECT * FROM sensor_data WHERE device='growatt' AND sensor='power' AND epoch >= \" + fromdate + \" AND epoch <= \" + epoch ;\n//return msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 350,
        "y": 220,
        "wires": [
            [
                "da7b5016246df2fb",
                "c161f790bb333a62"
            ]
        ]
    },
    {
        "id": "63e36a68b9ad13f8",
        "type": "function",
        "z": "cac42713c2f8a208",
        "name": "Prep",
        "func": "var msg2 = [];\n\n// this is the logic when there are multiple data sets are received\nfor (var i=0; i<msg.payload.length; i++) {\n    var output = [];\n    for (var j=0; j<msg.payload[i].length; j++) {\n        output.push([msg.payload[i][j].Epoch, msg.payload[i][j].Value]);\n    }\n    msg2.push({ key: msg.payload[i][0].Node+\"/\"+msg.payload[i][0].Sensor, Value : output});\n}\n\nmsg.payload=msg2;\n\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 827,
        "y": 223,
        "wires": [
            [
                "77ecb32dc5a5b5c1",
                "01cbcea724a124aa"
            ]
        ]
    },
    {
        "id": "b9636e89d32ffa37",
        "type": "inject",
        "z": "cac42713c2f8a208",
        "name": "Reset chart",
        "repeat": "",
        "crontab": "",
        "once": false,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 185,
        "y": 343,
        "wires": [
            [
                "0f98d26a333ed33b"
            ]
        ]
    },
    {
        "id": "0f98d26a333ed33b",
        "type": "function",
        "z": "cac42713c2f8a208",
        "name": "Empty payload",
        "func": "msg.payload = [];\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "x": 513,
        "y": 342,
        "wires": [
            [
                "01cbcea724a124aa"
            ]
        ]
    },
    {
        "id": "e5025b32b4af5f4b",
        "type": "ui_form",
        "z": "cac42713c2f8a208",
        "name": "Data points",
        "label": "",
        "group": "1e17cd0b.862863",
        "order": 0,
        "width": 0,
        "height": 0,
        "options": [
            {
                "label": "Period: today",
                "value": "period/today",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Period: yesterday",
                "value": "period/yesterday",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Period: this week",
                "value": "period/week",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Node 201 Battery",
                "value": "node201/dev04",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Node 201 Temperature",
                "value": "node201/dev50",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Node 201 RSSI",
                "value": "node201/dev02",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Node 220 Battery",
                "value": "node220/dev04",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Node 220 Temperature",
                "value": "node220/dev48",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Node 220 Humidity",
                "value": "node220/dev49",
                "type": "checkbox",
                "required": false,
                "rows": null
            },
            {
                "label": "Node 220 RSSI",
                "value": "node220/dev02",
                "type": "checkbox",
                "required": false,
                "rows": null
            }
        ],
        "formValue": {
            "period/today": false,
            "period/yesterday": false,
            "period/week": false,
            "node201/dev04": false,
            "node201/dev50": false,
            "node201/dev02": false,
            "node220/dev04": false,
            "node220/dev48": false,
            "node220/dev49": false,
            "node220/dev02": false
        },
        "payload": "",
        "submit": "Submit",
        "cancel": "Cancel",
        "topic": "",
        "topicType": "str",
        "splitLayout": false,
        "className": "",
        "x": 155,
        "y": 167,
        "wires": [
            [
                "206fe9711c861818",
                "edd704eac37c28c1"
            ]
        ]
    },
    {
        "id": "1168162739bfaf7d",
        "type": "join",
        "z": "cac42713c2f8a208",
        "name": "",
        "mode": "custom",
        "build": "array",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": false,
        "timeout": "",
        "count": "",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "",
        "reduceFixup": "",
        "x": 638,
        "y": 221,
        "wires": [
            [
                "63e36a68b9ad13f8",
                "8dbf9c5f2b6c9767"
            ]
        ]
    },
    {
        "id": "66704174e3d62c9e",
        "type": "comment",
        "z": "cac42713c2f8a208",
        "name": "Dynamic report example",
        "info": "This flow can generate graph based from data stored\nin the database and display multiple data points\nin a single graph.",
        "x": 187.5,
        "y": 112.5,
        "wires": []
    },
    {
        "id": "206fe9711c861818",
        "type": "debug",
        "z": "cac42713c2f8a208",
        "name": "",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 390,
        "y": 120,
        "wires": []
    },
    {
        "id": "da7b5016246df2fb",
        "type": "sqlite",
        "z": "cac42713c2f8a208",
        "mydb": "1c25415d.b8427f",
        "sqlquery": "msg.topic",
        "sql": "",
        "name": "Node Red DB",
        "x": 473.75,
        "y": 265,
        "wires": [
            [
                "1168162739bfaf7d"
            ]
        ]
    },
    {
        "id": "8dbf9c5f2b6c9767",
        "type": "debug",
        "z": "cac42713c2f8a208",
        "name": "",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 723.75,
        "y": 145,
        "wires": []
    },
    {
        "id": "77ecb32dc5a5b5c1",
        "type": "debug",
        "z": "cac42713c2f8a208",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 983.75,
        "y": 185,
        "wires": []
    },
    {
        "id": "c161f790bb333a62",
        "type": "debug",
        "z": "cac42713c2f8a208",
        "name": "",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 530,
        "y": 160,
        "wires": []
    },
    {
        "id": "01cbcea724a124aa",
        "type": "ui_chart",
        "z": "cac42713c2f8a208",
        "name": "Chart",
        "group": "bd903d6.d9fc7c",
        "order": 0,
        "width": 0,
        "height": 0,
        "label": "",
        "chartType": "line",
        "legend": "false",
        "xformat": "%a %H:%M",
        "interpolate": "linear",
        "nodata": "",
        "ymin": "",
        "ymax": "",
        "removeOlder": "1",
        "removeOlderUnit": "604800",
        "outputs": 1,
        "x": 850,
        "y": 340,
        "wires": [
            []
        ]
    },
    {
        "id": "1e17cd0b.862863",
        "type": "ui_group",
        "name": "Selection",
        "tab": "1e3fe400.0baf5c",
        "order": 1,
        "disp": true,
        "width": "5"
    },
    {
        "id": "1c25415d.b8427f",
        "type": "sqlitedb",
        "db": "/home/pi/dbs/AgriMonTest"
    },
    {
        "id": "bd903d6.d9fc7c",
        "type": "ui_group",
        "name": "Report",
        "tab": "1e3fe400.0baf5c",
        "order": 2,
        "disp": true,
        "width": "18"
    },
    {
        "id": "1e3fe400.0baf5c",
        "type": "ui_tab",
        "name": "Reports",
        "icon": "dashboard",
        "order": 9
    }
]