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 | 32 +++++++++++++++++++++++++++++++- 1 files changed, 31 insertions(+), 1 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 ccc4171..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,8 +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.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; @@ -177,6 +184,29 @@ @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(); + 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