| | |
| | | queryWrapper.leftJoin(Company.class, Company::getId, Declares::getCompanyId); |
| | | queryWrapper.leftJoin(ProjectLabel.class, ProjectLabel::getId, Declares::getDiagnoseTypeId); |
| | | queryWrapper.eq(Declares::getIsdeleted, Constants.ZERO); |
| | | queryWrapper.ne(Declares::getStatus, Constants.ZERO); |
| | | queryWrapper.eq(Declares::getProjectId, param.getProjectId()); |
| | | queryWrapper.apply(param.getAreaId()!=null,"t2.area_id =" +param.getAreaId()); |
| | | queryWrapper.groupBy(Declares::getDiagnoseTypeId); |
| | |
| | | queryWrapper.leftJoin(Company.class, Company::getId, Declares::getCompanyId); |
| | | queryWrapper.leftJoin(Areas.class, Areas::getId, Company::getAreaId); |
| | | queryWrapper.eq(Declares::getIsdeleted, Constants.ZERO); |
| | | queryWrapper.ne(Declares::getStatus, Constants.ZERO); |
| | | queryWrapper.eq(Declares::getProjectId, param.getProjectId()); |
| | | queryWrapper.eq(param.getDiagnoseType()!=null,Declares::getDiagnoseTypeId, param.getDiagnoseTypeId()); |
| | | queryWrapper.apply(param.getAreaId()!=null,"t1.area_id =" +param.getAreaId()); |
| | |
| | | .leftJoin(DeclareService.class,DeclareService::getDeclareId,Declares::getId) |
| | | .eq(Declares::getSoId,soId) |
| | | .eq(DeclareService::getIsdeleted,Constants.ZERO) |
| | | .ne(DeclareService::getStatus,Constants.ZERO) |
| | | .groupBy(DeclareService::getDeclareId); |
| | | List<Map<String, Object>> maps = |
| | | declareServiceMapper.selectMaps(declareServiceQuery); |