From 09e41d546b030b47661877d4b8141c88584d7598 Mon Sep 17 00:00:00 2001 From: 罗元桥 <2376770955@qq.com> Date: 星期五, 24 九月 2021 16:03:52 +0800 Subject: [PATCH] Merge branch 'test' into 'four_member' --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/EldersAuthServiceImpl.java | 72 ++++++++++++++++++++++++------------ 1 files changed, 48 insertions(+), 24 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/EldersAuthServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/EldersAuthServiceImpl.java index 1b4be99..9a9cef8 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/EldersAuthServiceImpl.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/EldersAuthServiceImpl.java @@ -67,6 +67,10 @@ private ComEldersAuthStatisticsMapper comEldersAuthStatisticsMapper; @Resource private ComActDAO comActDAO; + @Resource + private ComElderAuthRecordsDAO comElderAuthRecordsDAO; + @Resource + private ComElderAuthElderliesDAO comElderAuthElderliesDAO; @Value("${domain.aesKey:}") private String aesKey; @@ -561,40 +565,60 @@ } /** - * 检测上月所有视频认证记录,取最后一条记录为认证成功记录 + * 检测本月所有认证记录,认证成功记录更新到历史记录中 * @return 执行结果 */ @Override @Transactional(rollbackFor = Exception.class) public R timedTaskEldersRecordAuthJobHandler(){ Date nowDate = new Date(); - //查询所有启用中社区 - List<ComActDO> actList = comActDAO.selectList(new QueryWrapper<ComActDO>().lambda().eq(ComActDO::getState,0)); - actList.forEach(act -> { - //查询社区上月所有视频认证 - List<ComEldersAuthHistoryVO> authList = eldersAuthDAO.getEldersAuthRecords(act.getCommunityId()); - authList.forEach(auth -> { - if(auth.getUserId() != null){ - ComEldersAuthHistoryRecordDO authHistoryRecordDO = new ComEldersAuthHistoryRecordDO(); - authHistoryRecordDO.setCommunityId(auth.getCommunityId()); - authHistoryRecordDO.setCreateAt(auth.getCreateAt()); - authHistoryRecordDO.setAuthId(auth.getId()); - authHistoryRecordDO.setUserId(auth.getUserId()); - authHistoryRecordDO.setBrithday(auth.getBirthday()); - authHistoryRecordDO.setDomicile(auth.getDomicile()); - authHistoryRecordDO.setIdCard(auth.getIdCard()); - authHistoryRecordDO.setName(auth.getName()); - authHistoryRecordDO.setIsAuth(1); - try { - Integer age = IdcardUtil.getAgeByIdCard(auth.getIdCard()); - authHistoryRecordDO.setAge(age); - }catch (Exception e){ - log.error("年龄转换失败"); + String authPeriod = DateUtils.getCurrentDateString_YYYY_MM(); + //查询所有老人信息并加入到老人认证历史记录表中,如果不存在则新增,存在则不做操作 + List<ComElderAuthElderliesDO> authElderliesList = comElderAuthElderliesDAO.selectList(new QueryWrapper<>()); + authElderliesList.forEach(authElderlies -> { + ComEldersAuthHistoryRecordDO authHistoryRecordDO = comEldersAuthHistoryRecordMapper.selectOne(new QueryWrapper<ComEldersAuthHistoryRecordDO>().lambda() + .eq(ComEldersAuthHistoryRecordDO::getElderliesId,authElderlies.getId()) + .eq(ComEldersAuthHistoryRecordDO::getAuthPeriod,authPeriod)); + if(authHistoryRecordDO == null){ + authHistoryRecordDO = new ComEldersAuthHistoryRecordDO(); + BeanUtils.copyProperties(authElderlies,authHistoryRecordDO); + authHistoryRecordDO.setIsAuth(ComEldersAuthHistoryRecordDO.isAuth.no); + authHistoryRecordDO.setElderliesId(authElderlies.getId()); + authHistoryRecordDO.setAuthPeriod(authPeriod); + authHistoryRecordDO.setCreateAt(nowDate); + comEldersAuthHistoryRecordMapper.insert(authHistoryRecordDO); + } + }); + + List<ComElderAuthRecordsDO> authRecordsList = comElderAuthRecordsDAO.selectList(new QueryWrapper<ComElderAuthRecordsDO>().lambda() + .ge(ComElderAuthRecordsDO::getCreateAt,DateUtils.getFirstDayOfMonth())); + //遍历认证记录列表 + authRecordsList.forEach(authRecords -> { + if(authRecords.getApprovalStatus().equals(ComElderAuthRecordsDO.approvalStatus.tg)){ + ComEldersAuthHistoryRecordDO authHistoryRecordDO = comEldersAuthHistoryRecordMapper.selectOne(new QueryWrapper<ComEldersAuthHistoryRecordDO>().lambda() + .eq(ComEldersAuthHistoryRecordDO::getElderliesId,authRecords.getElderliesId()) + .eq(ComEldersAuthHistoryRecordDO::getAuthPeriod,authRecords.getAuthPeriod())); + if(authHistoryRecordDO != null){//存在记录 + if(authHistoryRecordDO.getIsAuth().equals(ComEldersAuthHistoryRecordDO.isAuth.no)){ + authHistoryRecordDO.setIsAuth(ComEldersAuthHistoryRecordDO.isAuth.yes); + authHistoryRecordDO.setAuthDate(authRecords.getApprovalDate()); + authHistoryRecordDO.setApprovalDate(authRecords.getApprovalDate()); + authHistoryRecordDO.setApproverId(authRecords.getApproverId()); + authHistoryRecordDO.setSubmitUserId(authRecords.getSubmitUserId()); + authHistoryRecordDO.setAuthMethod(authRecords.getAuthMethod()); + authHistoryRecordDO.setVerificationResult(authRecords.getVerificationResult()); + authHistoryRecordDO.setAuthId(authRecords.getId()); + comEldersAuthHistoryRecordMapper.updateById(authHistoryRecordDO); } + }else{ + authHistoryRecordDO = new ComEldersAuthHistoryRecordDO(); + BeanUtils.copyProperties(authRecords,authHistoryRecordDO); + authHistoryRecordDO.setIsAuth(ComEldersAuthHistoryRecordDO.isAuth.yes); + authHistoryRecordDO.setAuthId(authRecords.getId()); comEldersAuthHistoryRecordMapper.insert(authHistoryRecordDO); } - }); + } }); return R.ok(); } -- Gitblit v1.7.1