java/zhihuishenqu.git

			@@ -71,7 +71,7 @@
			"AND w.`status` = #{comActMicroWishVO.status} " +
			" </if> " +
			"<if test='comActMicroWishVO.status == 3 and comActMicroWishVO.isPageMyWish==null'>" +
			"AND ( w.`status` = 3 or w.`status` = 5 ) " +
			"AND w.`status` = 3 " +
			" </if> " +
			"<if test='comActMicroWishVO.status != null and comActMicroWishVO.status!=0 and comActMicroWishVO.isPageMyWish!=null and comActMicroWishVO.status==1'>" +
			"AND w.`status` =1 " +
			@@ -165,8 +165,8 @@
			int updateStatusAutoConfirm();

			@Select("SELECT COUNT(id) AS completedNum," +
			"(SELECT COUNT(id) FROM com_act_micro_wish WHERE community_id = #{communityId} AND (status =1 OR status =2 OR status = 3 OR status = 4 OR status = 5)) AS willNum ," +
			"(SELECT COUNT(id) FROM com_act_micro_wish WHERE community_id = #{communityId} AND create_at LIKE CONCAT(#{nowDate},'%')) AS currentNum " +
			"(SELECT COUNT(id) FROM com_act_micro_wish WHERE community_id = #{communityId} AND (status =1 OR status =2 OR status = 3 OR status = 5)) AS willNum ," +
			"(SELECT COUNT(id) FROM com_act_micro_wish WHERE community_id = #{communityId} AND (status =1 OR status =2 OR status = 3 OR status = 5 OR status = 6) AND create_at LIKE CONCAT(#{nowDate},'%')) AS currentNum " +
			"FROM com_act_micro_wish WHERE community_id = #{communityId} AND status = 6 ")
			Map<String, Long> countByCommunityId(@Param("communityId") Long communityId,@Param("nowDate") String nowDate);