java/zhihuishenqu.git

			@@ -193,8 +193,9 @@
			"GROUP BY d.id")
			ComActDiscussVO selectHaveSignAndHaveVote(@Param("id") Long id, @Param("loginUserId")Long loginUserId);

			@Select(" SELECT COUNT(id) AS currentNum," +
			"(SELECT COUNT(id) FROM com_act_discuss WHERE community_id = 2 AND type = 1)AS imgNum," +
			@Select(" SELECT COUNT(id) AS totalNum," +
			"(SELECT COUNT(id) FROM com_act_discuss WHERE community_id = 2 AND create_at LIKE CONCAT('','%'))AS currentNum," +
			"(SELECT COUNT(id) FROM com_act_discuss WHERE community_id = 2 AND TYPE = 1)AS imgNum," +
			"(" +
			"SELECT COUNT(DISTINCT(user_id)) FROM (" +
			" SELECT c.user_id FROM com_act_discuss d INNER JOIN com_act_discuss_comment c ON d.id = c.discuss_id WHERE d.community_id = 2 AND d.type = 1 " +
			@@ -205,8 +206,7 @@
			" UNION ALL " +
			" SELECT u.user_id FROM com_act_discuss d INNER JOIN com_act_discuss_user u ON d.id = u.discuss_id WHERE d.community_id = 2 AND d.type = 1 " +
			")d " +
			")AS imgPeopleNum," +
			"(SELECT COUNT(id) FROM com_act_discuss WHERE community_id = 2 AND type = 2)AS voteNum," +
			")AS commonPeopleNum," +
			"(" +
			"SELECT COUNT(DISTINCT(user_id)) FROM (" +
			" SELECT c.user_id FROM com_act_discuss d INNER JOIN com_act_discuss_comment c ON d.id = c.discuss_id WHERE d.community_id = 2 AND d.type = 2 " +
			@@ -217,8 +217,8 @@
			" UNION ALL " +
			" SELECT u.user_id FROM com_act_discuss d INNER JOIN com_act_discuss_user u ON d.id = u.discuss_id WHERE d.community_id = 2 AND d.type = 2 " +
			")d " +
			")AS votePeopleNum " +
			" FROM com_act_discuss WHERE community_id = 2 AND create_at LIKE CONCAT('','%')")
			")AS volunteerPeopleNum " +
			" FROM com_act_discuss")
			Map<String, Long> countByCommunityId(@Param("communityId")Long communityId, @Param("date")String date);

			@Select(" SELECT id,discuss_subject AS content,IF(type = 1,'图文','投票') AS typeName FROM com_act_discuss WHERE community_id = #{communityId} ORDER BY create_at DESC LIMIT #{pageSize}")