HA - HR - Hent data fra madplan DB

[{"id":"729e05e6.40214c","type":"mysql","z":"64da1afb.ab6304","mydb":"aa2a4e4d.8eef8","name":"","x":460,"y":610,"wires":[["7f5517e9.8b0ed8","d5e40d1b.cdc47","694b6588.8b08fc"]]},{"id":"405c6fe8.b7d3a","type":"inject","z":"64da1afb.ab6304","name":"","props":[{"p":"payload"}],"repeat":"10800","crontab":"","once":false,"onceDelay":"0.1","topic":"","payload":"","payloadType":"date","x":120,"y":610,"wires":[["5cd381ca.d0ead"]]},{"id":"5cd381ca.d0ead","type":"function","z":"64da1afb.ab6304","name":"Hent dagens ret","func":"msg.topic=\"SELECT * FROM `mad_Madplan` M LEFT JOIN `mad_Opskrifter` O on M.refOpskrift=O.OpskriftID WHERE Dato=CURDATE();\"\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":290,"y":610,"wires":[["729e05e6.40214c"]]},{"id":"d5e40d1b.cdc47","type":"ha-entity","z":"64da1afb.ab6304","name":"Dagens ret sensor","server":"","version":1,"debugenabled":false,"outputs":1,"entityType":"sensor","config":[{"property":"name","value":"madplan_dagensret"},{"property":"device_class","value":""},{"property":"icon","value":"mdi:silverware"},{"property":"unit_of_measurement","value":""}],"state":"payload[0].Navn","stateType":"msg","attributes":[],"resend":true,"outputLocation":"","outputLocationType":"none","inputOverride":"allow","x":660,"y":560,"wires":[[]]},{"id":"7f5517e9.8b0ed8","type":"ha-entity","z":"64da1afb.ab6304","name":"Dagens ret image sensor","server":"","version":1,"debugenabled":false,"outputs":1,"entityType":"sensor","config":[{"property":"name","value":"madplan_dagensret_image"},{"property":"device_class","value":""},{"property":"icon","value":"mdi:silverware"},{"property":"unit_of_measurement","value":""}],"state":"payload[0].Billede_link","stateType":"msg","attributes":[],"resend":true,"outputLocation":"","outputLocationType":"none","inputOverride":"allow","x":680,"y":610,"wires":[[]]},{"id":"694b6588.8b08fc","type":"ha-entity","z":"64da1afb.ab6304","name":"Dagens ret link sensor","server":"","version":1,"debugenabled":false,"outputs":1,"entityType":"sensor","config":[{"property":"name","value":"madplan_dagensretlink"},{"property":"device_class","value":""},{"property":"icon","value":"mdi:silverware"},{"property":"unit_of_measurement","value":""}],"state":"payload[0].Reference","stateType":"msg","attributes":[],"resend":true,"outputLocation":"","outputLocationType":"none","inputOverride":"allow","x":670,"y":660,"wires":[[]]},{"id":"aa2a4e4d.8eef8","type":"MySQLdatabase","name":"Madplan DB","host":"core-mariadb","port":"3306","db":"madplan","tz":"","charset":"UTF8"}]