| | |
| | | @Autowired |
| | | private EmayService emayService; |
| | | |
| | | |
| | | |
| | | @Override |
| | | public Integer create(Visits visits) { |
| | | visitsMapper.insert(visits); |
| | |
| | | QueryWrapper<Visits> wrapper = new QueryWrapper<>(visits); |
| | | return visitsMapper.selectCount(wrapper); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public PageData<Visits> retentionPage(PageWrap<Visits> pageWrap) { |
| | | public static PageData<Visits> retentionPageBiz(PageWrap<Visits> pageWrap, VisitsJoinMapper visitsJoinMapper,SystemDictDataBiz systemDictDataBiz) { |
| | | 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.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
| | | 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.OUT_DATE) <= "+code+" "); |
| | | |
| | | queryWrapper.ne("m.type ",Constants.TWO); |
| | |
| | | return PageData.from(result); |
| | | } |
| | | |
| | | @Override |
| | | public PageData<Visits> retentionPage(PageWrap<Visits> pageWrap) { |
| | | return retentionPageBiz(pageWrap,visitsJoinMapper,systemDictDataBiz); |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |