springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/EldersAuthDAO.java
@@ -148,8 +148,18 @@ IPage<ComEldersAuthRecordForCommunityVO> selectCommunityEldersRecordByPage(Page page, @Param("pageEldersAuthRecordDTO") PageEldersAuthRecordDTO pageEldersAuthRecordDTO); Map<String,String> getEldersAuthStatistics(@Param("communityId") Long communityId); /** * 根据社区id查询当前社区有多少人未认证和认证 * @param communityId 社区id * @return 前社区有多少人未认证和认证 */ Map<String,Object> getEldersAuthStatistics(@Param("communityId") Long communityId); /** * 查询社区上月所有视频认证记录 * @param communityId 社区id * @return 上月所有视频认证记录 */ List<ComEldersAuthHistoryVO> getEldersAuthRecords(@Param("communityId") Long communityId); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/EldersAuthServiceImpl.java
@@ -539,16 +539,16 @@ actList.forEach(act -> { //查询社区老人认证统计信息，并存储到数据库中 Map<String,String> resultMap = this.baseMapper.getEldersAuthStatistics(act.getCommunityId()); Map<String,Object> resultMap = this.baseMapper.getEldersAuthStatistics(act.getCommunityId()); if(resultMap != null){ ComEldersAuthStatisticsDO authStatisticsDO = new ComEldersAuthStatisticsDO(); authStatisticsDO.setCommunityId(act.getCommunityId()); authStatisticsDO.setMonth(DateUtils.getMonth(nowDate)); authStatisticsDO.setYear(DateUtils.getYear(nowDate)); authStatisticsDO.setCreateAt(nowDate); authStatisticsDO.setSum(Integer.parseInt(resultMap.get("oldCount"))); authStatisticsDO.setNoAuthSum(Integer.parseInt(resultMap.get("noCount"))); authStatisticsDO.setAuthSum(Integer.parseInt(resultMap.get("yesCount"))); authStatisticsDO.setSum(Integer.parseInt(resultMap.get("oldCount").toString())); authStatisticsDO.setNoAuthSum(Integer.parseInt(resultMap.get("noCount").toString())); authStatisticsDO.setAuthSum(Integer.parseInt(resultMap.get("yesCount").toString())); comEldersAuthStatisticsMapper.insert(authStatisticsDO); } }); springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComEldersAuthDOMapper.xml
@@ -56,7 +56,7 @@ FROM com_act AS ca WHERE community_id = 2 community_id = #{communityId} </select> <select id="getEldersAuthRecords" resultType="com.panzhihua.common.model.vos.elders.ComEldersAuthHistoryVO">
