| | |
| | | |
| | | @Override |
| | | public PageData<Visits> retentionPage(PageWrap<Visits> pageWrap) { |
| | | String code= systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.TIMEOUT_WARNING).getCode(); |
| | | IPage<Visits> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>(); |
| | | |
| | | queryWrapper.selectAll(Visits.class); |
| | | queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName); |
| | | queryWrapper.select("TIMESTAMPDIFF(MINUTE,t.ENDTIME , NOW()) AS timeOut"); |
| | | queryWrapper.select("TIMESTAMPDIFF( MINUTE, NOW(), t.ENDTIME) AS timeOut"); |
| | | queryWrapper.selectAs(Member::getType,Visits::getMemberType); |
| | | queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId); |
| | |
| | | queryWrapper.leftJoin(" member m on m.id=t.MEMBER_ID"); |
| | | |
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getLevelStatus()),Visits::getStatus,Constants.VisitStatus.signin); |
| | | |
| | | queryWrapper.apply(Objects.nonNull(pageWrap.getModel().getLevelStatus())," TIMESTAMPDIFF( MINUTE, NOW(), t.ENDTIME) <= "+code+" "); |
| | | |
| | | queryWrapper.ne("m.type ",Constants.TWO); |
| | | queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO); |
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Visits::getType,pageWrap.getModel().getType()); |
| | |
| | | .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Visits::getStatus,pageWrap.getModel().getStatus()); |
| | | queryWrapper.isNull(Visits::getOutDate); |
| | | queryWrapper.orderByDesc(Visits::getEditDate); |
| | | String code= systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.TIMEOUT_FREEZE).getCode(); |
| | | IPage<Visits> result = visitsJoinMapper.selectJoinPage(page, Visits.class,queryWrapper); |
| | | if(result!=null&&result.getRecords()!=null){ |
| | | result.getRecords().stream().forEach(s ->{ |
| | | if(s.getTimeOut()>=Constants.ZERO){ |
| | | s.setOutStatus(Constants.ONE); |
| | | }else if(s.getTimeOut()<=Integer.valueOf(code)&&s.getTimeOut()>0){ |
| | | if(s.getTimeOut()<=Integer.valueOf(code)&&s.getTimeOut()>=0){ |
| | | s.setOutStatus(Constants.TWO); |
| | | }else{ |
| | | }else if(s.getTimeOut()>Constants.ZERO){ |
| | | s.setOutStatus(Constants.ZERO); |
| | | }else{ |
| | | s.setOutStatus(Constants.ONE); |
| | | } |
| | | |
| | | }); |