| | |
| | | insert.setImgurl(projects.getImgurl()); |
| | | insert.setStatus(MeetConstants.ZERO); |
| | | insert.setSortnum(projects.getSortnum()); |
| | | insert.setCreateDate(new Date()); |
| | | projectsMapper.insert(insert); |
| | | return projects.getId(); |
| | | } |
| | |
| | | public List<ProjectsResponse> getProjectsList(Integer objId,Integer objType) { |
| | | return projectsMapper.getProjectsList(new QueryWrapper<ProjectsResponse>() |
| | | .eq("ISDELETED",MeetConstants.ZERO) |
| | | .exists(" select 1 from project_rel p where p.PROJECT_ID = projects.id and p.OBJ_ID = "+objId+" and p.OBJ_TYPE = "+objType+" ") |
| | | .exists(" select 1 from meeting_project_rel p where p.PROJECT_ID = projects.id and p.OBJ_ID = "+objId+" and p.OBJ_TYPE = "+objType+" ") |
| | | ); |
| | | } |
| | | } |