| | |
|---|
| | | prquery.selectAll(ProjectRel.class); |
|---|
| | | prquery.eq(ProjectRel::getIsdeleted, MeetConstants.ZERO); |
|---|
| | | prquery.eq(ProjectRel::getObjId, s.getId()); |
|---|
| | | prquery.select("(select p.name from projects p where t.PROJECT_ID = p.id and p.ISDELETED = 0 ) as projectName"); |
|---|
| | | prquery.select("(select p.name from meeting_projects p where t.PROJECT_ID = p.id and p.ISDELETED = 0 ) as projectName"); |
|---|
| | | List<ProjectRel> prList = projectRelJoinMapper.selectJoinList(ProjectRel.class, prquery); |
|---|
| | | s.setProjectList(prList); |
|---|
| | | |
|---|
| | |
|---|
| | | @Override |
|---|
| | | public List<Bookings> getMyBookings(Integer userId, String dateMsg) { |
|---|
| | | return bookingsMapper.selectList(new QueryWrapper<Bookings>() |
|---|
| | | .apply(" id in ( select u.OBJ_ID from user_rel u where u.USER_ID = '" + userId + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ) ") |
|---|
| | | .apply(" id in ( select u.OBJ_ID from meeting_user_rel u where u.USER_ID = '" + userId + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ) ") |
|---|
| | | .eq("ISDELETED",MeetConstants.ZERO) |
|---|
| | | // .eq("STATUS",MeetConstants.ZERO) |
|---|
| | | .apply(" ROOM_ID in ( select r.id from rooms r where r.ISDELETED = 0 and r.STATUS = 0 )") |
|---|
| | |
|---|
| | | j -> j.like("a.NAME",pageWrap.getModel().getRoomsName()).or() |
|---|
| | | .like(" b.NAME", pageWrap.getModel().getRoomsName())) |
|---|
| | | .exists(pageWrap.getModel().getQueryType().equals(MeetConstants.ONE) && !Objects.isNull(pageWrap.getModel().getUserId()), |
|---|
| | | " select 1 from user_rel u where a.id = u.OBJ_ID and u.USER_ID = '" + pageWrap.getModel().getUserId() + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ") |
|---|
| | | " select 1 from meeting_user_rel u where a.id = u.OBJ_ID and u.USER_ID = '" + pageWrap.getModel().getUserId() + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ") |
|---|
| | | .eq(pageWrap.getModel().getQueryType().equals(MeetConstants.TWO) && !Objects.isNull(pageWrap.getModel().getUserId()), "a.CREATOR", pageWrap.getModel().getUserId()) |
|---|
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getQueryDate()), "a.START_TIME", pageWrap.getModel().getQueryDate()) |
|---|
| | | .eq(!Objects.isNull(pageWrap.getModel().getRoomsId()), "b.id", pageWrap.getModel().getRoomsId()) |
|---|
