| | |
| | | List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>() |
| | | .lambda().eq(Member::getIsdeleted,Constants.ZERO) |
| | | .eq(Member::getType,Constants.memberType.internal) |
| | | .eq(Member::getStatus,Constants.ZERO) |
| | | .isNotNull(Member::getHkId) |
| | | .notExists(" SELECT 1 FROM device_event b WHERE b.ext_event_person_no = a.HK_ID AND TO_DAYS( NOW())- TO_DAYS( b.CREATE_DATE )> "+systemDictData.getCode()+") ") |
| | | .exists(" SELECT 1 FROM device_event b WHERE b.ext_event_person_no = HK_ID AND TO_DAYS( NOW()) - TO_DAYS( b.CREATE_DATE ) > "+systemDictData.getCode()+" ") |
| | | ); |
| | | if(CollectionUtils.isEmpty(memberList)){ |
| | | return; |
| | |
| | | //冻结状态 |
| | | memberMapper.update(null,new UpdateWrapper<Member>() |
| | | .lambda().set(Member::getStatus,Constants.TWO) |
| | | .set(Member::getEditDate,new Date()) |
| | | .in(Member::getId,memberIds) |
| | | ); |
| | | //处理下发数据 |
| | |
| | | .last(" limit 1 ") |
| | | ); |
| | | MemberVO memberVO = new MemberVO(); |
| | | BeanUtils.copyProperties(member,memberVO); |
| | | if(!Objects.isNull(member)){ |
| | | BeanUtils.copyProperties(member,memberVO); |
| | | }else{ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
| | | } |
| | | return memberVO; |
| | | } |
| | | |