|  |  | 
 |  |  |         bookquery.selectAs(BookingTime::getTimeId, Bookings::getRoomTimeId); | 
 |  |  |         bookquery.selectAs(BookingTime::getId, Bookings::getBookingTimeId); | 
 |  |  |         bookquery.eq(Bookings::getIsdeleted, Constants.ZERO); | 
 |  |  |         bookquery.eq(BookingTime::getIsdeleted, Constants.ZERO); | 
 |  |  |         bookquery.eq(Bookings::getRoomId, roomTime.getRoomId()); | 
 |  |  |         bookquery.eq(Bookings::getStatus,Constants.ZERO); | 
 |  |  |         bookquery.apply("DATE_FORMAT(t.START_TIME,'%Y-%m-%d') = DATE_FORMAT('" + DateUtil.dateToString(roomTime.getYudingDate(), "yyyy-MM-dd") + "','%Y-%m-%d') "); |