| | |
| | | if (pageWrap.getModel().getStartTime() != null) { |
| | | queryWrapper.lambda().eq(ApplyChagneDetail::getStartTime, pageWrap.getModel().getStartTime()); |
| | | } |
| | | if (pageWrap.getModel().getIdcardNo() != null) { |
| | | queryWrapper.lambda().ge(ApplyChagneDetail::getIdcardNo, Utils.Date.getStart(pageWrap.getModel().getIdcardNo())); |
| | | queryWrapper.lambda().le(ApplyChagneDetail::getIdcardNo, Utils.Date.getEnd(pageWrap.getModel().getIdcardNo())); |
| | | } |
| | | if (pageWrap.getModel().getDuId() != null) { |
| | | queryWrapper.lambda().eq(ApplyChagneDetail::getDuId, pageWrap.getModel().getDuId()); |
| | | } |
| | |
| | | queryWrapper.selectAs(Member::getName,ApplyChagneDetail::getMemberName); |
| | | ApplyDetailPageDTO applyDetailPageDTO = pageWrap.getModel(); |
| | | queryWrapper.exists(!Objects.isNull(applyDetailPageDTO.getApplyId()), |
| | | " select 1 from apply_change ac where ac.isdeleted = 0 and ac.status in (1,2) and ac.applyId = "+applyDetailPageDTO.getApplyId()+" and ac.id = t.apply_change_id "); |
| | | " select 1 from apply_change ac where ac.isdeleted = 0 and ac.status in (1,2) and ac.apply_id = "+applyDetailPageDTO.getApplyId()+" and ac.id = t.apply_change_id "); |
| | | //在保 |
| | | queryWrapper.le(!Objects.isNull(applyDetailPageDTO.getApplyStatus()) |
| | | &&applyDetailPageDTO.getApplyStatus().equals(Constants.ONE), |