From 0ff56cf152a4b2bb36febf47fd46d79f671b74c0 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期三, 20 三月 2024 17:14:58 +0800
Subject: [PATCH] 修改党员双报到 列表积分不显示4
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java | 28 ++++++++++++++++++++++++----
1 files changed, 24 insertions(+), 4 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 a43ad36..dfdb40a 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,12 @@
import java.util.List;
+import com.panzhihua.common.model.dtos.community.building.BuildingDto;
+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;
@@ -57,7 +59,8 @@
+ "and a.name LIKE concat( #{pageComActDTO.name}, '%' ) \n" + " </if> "
+ "<if test='pageComActDTO.areaCode != null and pageComActDTO.areaCode.trim() != ""'>"
+ "AND a.area_code = #{pageComActDTO.areaCode} \n" + " </if> "
- + "<if test='pageComActDTO.createAtBegin != null '>" + "AND a.create_at BETWEEN "
+ + "<if test='pageComActDTO.createAtBegin != null '>"
+ + "AND a.create_at BETWEEN "
+ "#{pageComActDTO.createAtBegin} \n" + "AND #{pageComActDTO.createAtEnd}" + " </if> " + " </where>"
+ " order by a.create_at desc" + "</script>")
IPage<ComActVO> pageCommunity(Page page, @Param("pageComActDTO") PageComActDTO pageComActDTO);
@@ -177,4 +180,21 @@
*/
@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);
}
--
Gitblit v1.7.1