| | |
| | | Join<RiskAssessPlan, RiskAssessPlanEvaluateUser> evaluateUserJoin = root.join("riskAssessPlanEvaluateUsers", JoinType.LEFT); |
| | | |
| | | if (roleTag == UserTagEnum.USER_TAG_0.getCode()) { |
| | | |
| | | predicateList.add(criteriaBuilder.equal(root.get("planUserId"), currentUserId)); |
| | | //此处应有谁能查询:辨识专家,评价专家,实验负责人(此处未存相关信息,以实验id为条件查询) |
| | | predicateList.add(criteriaBuilder.or( |
| | | criteriaBuilder.equal(identificationUserJoin.get("identificationUserId"), currentUserId), |
| | | criteriaBuilder.equal(evaluateUserJoin.get("evaluateUserId"), currentUserId), |
| | | criteriaBuilder.in(root.get("experimentId")).value(experimentIdList) |
| | | ) |
| | | ); |
| | | // predicateList.add(criteriaBuilder.or( |
| | | // criteriaBuilder.equal(identificationUserJoin.get("identificationUserId"), currentUserId), |
| | | // criteriaBuilder.equal(evaluateUserJoin.get("evaluateUserId"), currentUserId), |
| | | // criteriaBuilder.in(root.get("experimentId")).value(experimentIdList) |
| | | // ) |
| | | // ); |
| | | } |
| | | query.groupBy(root.get("id")); |
| | | predicateList.add(criteriaBuilder.equal(root.get("deleteStatus"), StatusEnum.DELETE_NOT.getCode())); |
| | |
| | | predicateList.add(criteriaBuilder.equal(root.get("planExecStatus"), queryParam.getPlanExecStatus())); |
| | | } |
| | | } |
| | | |
| | | if (queryParam.getTag() == 2) { |
| | | predicateList.add(criteriaBuilder.isNotNull(root.get("identificationTime"))); |
| | | } |
| | |
| | | Join<RiskAssessPlan, RiskAssessPlanEvaluateUser> evaluateUserJoin = root.join("riskAssessPlanEvaluateUsers", JoinType.LEFT); |
| | | Join<RiskAssessPlan, User> planUserJoin = root.join("planUser", JoinType.LEFT); |
| | | |
| | | |
| | | if (roleTag == UserTagEnum.USER_TAG_0.getCode()) { |
| | | //辨识 |
| | | if (queryParam.getTag() == 1) { |
| | | predicateList.add(criteriaBuilder.equal(identificationUserJoin.get("identificationUserId"), currentUserId)); |
| | | } |
| | | //评论 |
| | | if (queryParam.getTag() == 2) { |
| | | predicateList.add(criteriaBuilder.equal(evaluateUserJoin.get("evaluateUserId"), currentUserId)); |
| | | } |
| | | //此处应有谁能查询:辨识专家,评价专家,实验负责人(此处未存相关信息,以实验id为条件查询) |
| | | predicateList.add(criteriaBuilder.or( |
| | | criteriaBuilder.equal(identificationUserJoin.get("identificationUserId"), currentUserId), |
| | | criteriaBuilder.equal(evaluateUserJoin.get("evaluateUserId"), currentUserId), |
| | | criteriaBuilder.in(root.get("experimentId")).value(experimentIdList) |
| | | ) |
| | | ); |
| | | //predicateList.add(criteriaBuilder.in(root.get("experimentId")).value(experimentIdList)); |
| | | // predicateList.add(criteriaBuilder.or( |
| | | // criteriaBuilder.equal(root.get("identificationUserId"), currentUserId), |
| | | // criteriaBuilder.equal(root.get("evaluateUserId"), currentUserId), |