From 82e77c9148f1662d52360ac89e516ced0b3adb05 Mon Sep 17 00:00:00 2001 From: 张天森 <1292933220@qq.com> Date: 星期一, 18 七月 2022 15:16:32 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/huacheng_zts' into huacheng_test --- springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 55 insertions(+), 4 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java index 94eb01c..f147273 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java @@ -5,7 +5,10 @@ import java.util.Map; import com.panzhihua.common.model.vos.community.*; +import com.panzhihua.common.model.vos.community.acid.ComActAcidCheckRecordVO; import com.panzhihua.common.model.vos.community.acid.ComActAcidMemberVO; +import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO; +import com.panzhihua.common.model.vos.user.*; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.springframework.web.bind.annotation.RequestParam; @@ -27,10 +30,6 @@ import com.panzhihua.common.model.vos.community.screen.event.EventGridMemberVO; import com.panzhihua.common.model.vos.grid.GridMemberVO; import com.panzhihua.common.model.vos.partybuilding.ComPbServiceTeamWishVO; -import com.panzhihua.common.model.vos.user.AdministratorsUserVO; -import com.panzhihua.common.model.vos.user.SysUserNoticeVO; -import com.panzhihua.common.model.vos.user.SysUserVO; -import com.panzhihua.common.model.vos.user.UpdateUserArchivesVO; import com.panzhihua.service_user.model.dos.SysUserDO; import com.panzhihua.service_user.model.dtos.DataKanbanDTO; @@ -265,6 +264,13 @@ Integer selectOrgAdmin(@Param("phone") String phone); /** + * 查询报道单位id + * @param phone + * @return + */ + Long selectCheckUnitId(@Param("phone") String phone); + + /** * 根据社区名称查询区县社区联动关系 * @param relationName * @return @@ -277,4 +283,49 @@ * @return */ String selectAreaCodeByStreetId(Long streetId); + + /** + * 看板用户统计:用户占比统计 + * */ + List<UserProportion> userAnalysis(@Param("type") Integer type,@Param("range") String range,@Param("streetId") Long streetId,@Param("areaCode")Long areaCode); + + /** + * 统计区域实名用户数 + * */ + List<RealUser> realUserCount(@Param("type") Integer type,@Param("range") String range,@Param("streetId") Long streetId,@Param("areaCode")Long areaCode); + + /** + * 统计该街道内的所有用户数 + * */ + Integer streetUserCount(@Param("id") Long id,@Param("areaCode")Long areaCode); + + /** + * 街道用户统计 + * */ + IndexDataKanbanVO dataKanBanStreet(@Param("streetId") Long streetId,@Param("areaCode") Long areaCode,@Param("range") String range); + + /** + * 获取当天的新增和日活 + * */ + Map<String,Long> getDailyAddAndActive(@Param("date") Date date,@Param("id") Long streetId,@Param("areaCode") Long areaCode); + + + List<StreetVO> selectStreetByAreaCode(Integer code); + + ComActAcidCheckRecordVO selectComActAcidCheckRecordById(Long id); + + ComActAcidRecordVO selectComActAcidRecord(Long id); + + ComActAcidMemberVO selectComActAcidMember(Long id); + + /** + * 获取本月的 + * */ + Integer getMonthUsers(@Param("streetId") Long streetId,@Param("areaCode") Long areaCode,@Param("range") String range); + + /** + * 获取街道下属村/社区 + * */ + List<CommunityVO> selectCommunityByStreetId(@Param("id") Integer streetId,@Param("type") Integer type); + } -- Gitblit v1.7.1