| | |
| | | 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') "); |