From b3ad0200bb7dc1d9c2bf75edb14de3f4fde2c40d Mon Sep 17 00:00:00 2001 From: lidongdong <1459917685@qq.com> Date: 星期二, 04 六月 2024 14:02:14 +0800 Subject: [PATCH] 花城 议事投票评论提交报错 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java | 37 ++++++++++++++++++++++++++++++++++--- 1 files changed, 34 insertions(+), 3 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java index ab35b17..de24a6d 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java @@ -2,10 +2,15 @@ import java.util.List; +import com.panzhihua.common.model.dtos.community.building.BuildingDto; +import com.panzhihua.common.model.dtos.community.large.AreaStreetDetailResp; +import com.panzhihua.common.model.dtos.community.large.SumAreaStreetResp; +import com.panzhihua.common.model.dtos.partybuilding.QryReportResp; +import com.panzhihua.common.model.vos.area.StreetAndBuildVO; import com.panzhihua.common.model.vos.community.ComActPasswordVo; -import com.panzhihua.common.model.vos.community.DataCount; -import com.panzhihua.common.model.vos.partybuilding.ComPbMemberTypeVO; -import com.panzhihua.common.model.vos.puda.DynamicVO; +import com.panzhihua.common.model.vos.community.bigscreen.ScreenStatics; +import com.panzhihua.common.model.vos.community.screen.event.EventPopulationSpecialStatisticsVO; +import com.panzhihua.common.model.vos.neighbor.UnitActivityAnalysisVO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; @@ -178,4 +183,30 @@ */ @Select("SELECT count(1) FROM com_act_social_org") Integer countSocialOrg(); + + @Select("select * from com_act where area_code = #{areaCode}") + List<ComActVO> panzhihuaMap(@Param("areaCode")String areaCode); + + List<StreetAndBuildVO> oneTagThreeReal(@Param("streetId") Long streetId); + + ScreenStatics getScreenStatics(); + + EventPopulationSpecialStatisticsVO getPopulationSpecial(@Param("streetId") Long streetId); + + Integer getPopulationAge(@Param("streetId") Long streetId, @Param("age") Integer age); + + List<UnitActivityAnalysisVO> institutionalUnitServiceAnalysis(@Param("beginTime") String beginTime, @Param("endTime") String endTIme); + + List<UnitActivityAnalysisVO> institutionalUnitActivityAnalysis(@Param("beginTime") String beginTime, @Param("endTime") String endTIme); + + @Select("SELECT count(1) FROM com_pb_check_unit WHERE belong_to = #{belongTo}") + Integer arriveUnit(@Param("belongTo") String belongTo); + + SumAreaStreetResp sumAreaStreet(); + + AreaStreetDetailResp selectVillage(@Param("ids") List<Long> ids,@Param("type") String type); + + EventPopulationSpecialStatisticsVO selectEvent(@Param("ids") List<Long> ids); + + List<QryReportResp> qryReport(String yearTime); } -- Gitblit v1.7.1