pihome-shc / pihome

PiHome - Smart Heating, Ventilation and Air Conditioning (HVAC)
http://www.pihome.eu
Other
52 stars 25 forks source link

Bug - Scheduling #331

Closed dvdcut closed 3 years ago

dvdcut commented 3 years ago

there is issue with scheduling, i can create schedule but no zone list, i can create schedule and have to go back to modify to list all zone.

image

dvdcut commented 3 years ago

ok, fix is easy, change line 182

$query = "select zone.id as tz_id, zone.name as zone_name, zone.status as tz_status, zone.type, zone_type.category FROM zone, zone_type WHERE zone.type = zone_type.type AND status = 1 ANDpurge= 0 ORDER BY index_id asc;";

to $query = "select zone.id as tz_id, zone.name as zone_name, zone.status as tz_status, zone.type, zone_type.category FROM zone, zone_type WHERE zone.type = zone_type.type AND status = 1 AND zone.purge= 0 ORDER BY index_id asc;";

dvdcut commented 3 years ago

this issue if fixed, i m closing this.