[{"id":"b7b2c211.332","type":"ui_template","z":"d2f6e143.e8d15","group":"f270e19d.c0b56","name":"FILL","order":1,"width":3,"height":2,"format":"<md-button \n    class=\"md-cornered\" \n    style=\"width: 140px; height: 120px;\"\n    ng-click=\"msg.payload = 'On';send(msg);\"\n    title=\"FILL\"\n        >\nFILL\n</md-button>","storeOutMessages":true,"fwdInMessages":true,"resendOnRefresh":false,"templateScope":"local","x":190,"y":1480,"wires":[["85f70fbc.c2305"]],"icon":"font-awesome/fa-search-plus"},{"id":"85f70fbc.c2305","type":"function","z":"d2f6e143.e8d15","name":"select statement","func":"\n//msg.topic = \"SELECT `device` FROM `usblamp` WHERE `device` not in ('usblamp','tvhuiskamer') GROUP BY(device)\"\nmsg.topic = \"SELECT `device` FROM `usblamp` WHERE 1 GROUP BY(device)\"\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":360,"y":1480,"wires":[["d5184a6d.f3a0b"]]},{"id":"d5184a6d.f3a0b","type":"mysql","z":"d2f6e143.e8d15","mydb":"cde7dc1.620b42","name":"database","x":540,"y":1480,"wires":[["6d414aaf.bb1584"]]},{"id":"6d414aaf.bb1584","type":"function","z":"d2f6e143.e8d15","name":"convert msg","func":"// function to fille a list node\n\nmsg.org_devices      = [\n                    {\n                        \"title\": \"Device\",\n                        \"icon\": \"https://upload.wikimedia.org/wikipedia/commons/e/e6/Emblem-persons-blue-green.svg\",\n                        \"menu\": [\n                            \"new device\",\n                            \"usblamp\",\n                            \"tvhuiskamer\"\n                                ],\n\n                    }\n                ];\n\nsqlnames = msg.payload;\n\nmsg.payload        = [{\n                        \"title\": \"Device\",\"icon\": \"https://upload.wikimedia.org/wikipedia/commons/e/e6/Emblem-persons-blue-green.svg\",\n                        \"menu\": sqlnames,\n                    }];\nmsg.sqlnames = sqlnames\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":710,"y":1480,"wires":[["31c9512b.c6d1e6","43f9c2db.84c414"]]},{"id":"43adcb99.aec6a4","type":"inject","z":"d2f6e143.e8d15","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":140,"y":1420,"wires":[["b7b2c211.332"]]},{"id":"31c9512b.c6d1e6","type":"debug","z":"d2f6e143.e8d15","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":810,"y":1560,"wires":[]},{"id":"43f9c2db.84c414","type":"ui_list","z":"d2f6e143.e8d15","group":"f270e19d.c0b56","name":"device","order":1,"width":6,"height":2,"lineType":"one","actionType":"menu","allowHTML":true,"outputs":1,"topic":"selectielijst_levelnaam","x":890,"y":1480,"wires":[[]]},{"id":"f270e19d.c0b56","type":"ui_group","name":"test","tab":"ee7d12b5.222e4","order":7,"disp":true,"width":16,"collapse":false},{"id":"cde7dc1.620b42","type":"MySQLdatabase","name":"pvknew","host":"192.168.20.38","port":"6603","db":"pvknew","tz":"","charset":"UTF8"},{"id":"ee7d12b5.222e4","type":"ui_tab","name":"BEHEEROMGEVING DOMOTICA","icon":"dashboard","order":1,"disabled":false,"hidden":false}]