1DATE_ADD(MemberBookFacility.time, INTERVAL 1 hour) <= '
2
3if (isset($data_search["time_start"]) && !empty(trim($data_search["time_start"]))) {
4 $conditions['TIME(MemberBookFacility.time) >= '] = $data_search["time_start"]; // date('H:i', strtotime($data_search["time_start"]));
5}
6
7if (isset($data_search["time_end"]) && !empty(trim($data_search["time_end"]))) {
8 $conditions['DATE_ADD(MemberBookFacility.time, INTERVAL 1 hour) <= '] = $data_search["time_end"]; // date('H:i', strtotime($data_search["time_end"]));
9}