springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
@@ -236,10 +236,10 @@ " left join com_mng_population as cmp on cmpct.population_id = cmp.id WHERE cmp.sex is not null and cmpct.community_id = ${communityId} GROUP BY cmp.sex") List<IndexPopulationSexStatisticsVO> getScreenIndexByPopulationSex(@Param("communityId") Long communityId); @Select("SELECT " + " e.happen_time as createAt, " + " e.event_des, " + " e.event_deal_status " + "FROM " + " `event` AS e " + " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " + "WHERE " + " egd.grid_community_id = ${communityId} " + " AND e.event_deal_status IN ( 1, 4 ) " + "ORDER BY " + " e.happen_time DESC " + " LIMIT 8") // @Select("SELECT " + " e.happen_time as createAt, " + " e.event_des, " + " e.event_deal_status " + "FROM " // + " `event` AS e " + " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " + "WHERE " // + " egd.grid_community_id = ${communityId} " + " AND e.event_deal_status IN ( 1, 4 ) " + "ORDER BY " // + " e.happen_time DESC " + " LIMIT 8") List<IndexEventListStatisticsVO> getScreenIndexByEventList(@Param("communityId") Long communityId); @Select("SELECT " + " count( id ) AS microWishTotal, " springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml
@@ -1262,4 +1262,28 @@ (select count(cmpct.id) from com_mng_population_community_tags cmpct INNER JOIN com_mng_population cmp on cmpct.population_id = cmp.id where cmpct.community_id = ${communityId} and cmp.person_type = 7) AS temporaryTotal from com_mng_population_community_tags as cmpct inner join com_mng_population as cmp on cmp.id = cmpct.population_id where community_id = ${communityId} </select> <select id="getScreenIndexByEventList" resultType="com.panzhihua.common.model.vos.community.screen.index.IndexEventListStatisticsVO" > SELECT e.happen_time as createAt, e.event_des,e.event_deal_status FROM `event` AS e LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id WHERE egd.grid_community_id = ${communityId} AND e.event_deal_status IN ( 1, 4 ) ORDER BY e.happen_time DESC LIMIT 8 </select> </mapper> springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventMapper.xml
@@ -961,7 +961,7 @@ LEFT JOIN sys_user AS su ON su.user_id = e.grid_member_id LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id <where> and event_status = 2 event_status = 2 <if test='eventListDTO.communityId != null'> and egd.grid_community_id = ${eventListDTO.communityId} </if>
