java/zhihuishenqu.git

			@@ -44,6 +44,8 @@
			"p.feedback_at, " +
			"p.is_report, " +
			"p.is_publicity, " +
			"p.activity_type, " +
			"p.activity_amount, " +
			"p.examine_at " +
			"FROM " +
			"com_act_easy_photo p " +
			@@ -80,6 +82,15 @@
			" </if> " +
			"<if test='comActEasyPhotoVO.sponsorId != null and comActEasyPhotoVO.sponsorId != 0'>" +
			"AND p.sponsor_id =#{comActEasyPhotoVO.sponsorId} " +
			" </if> " +
			"<if test='comActEasyPhotoVO.activityType != null'>" +
			"AND p.activity_type =#{comActEasyPhotoVO.activityType} " +
			" </if> " +
			"<if test='comActEasyPhotoVO.easyType != null and comActEasyPhotoVO.easyType == 1'>" +
			" AND (p.status = 1 or (p.status > 1 and is_need_feed_back = 0)) " +
			" </if> " +
			"<if test='comActEasyPhotoVO.easyType != null and comActEasyPhotoVO.easyType == 2'>" +
			" AND p.status > 1 and is_need_feed_back = 1 " +
			" </if> " +
			"group by p.id "+

			@@ -291,13 +302,13 @@

			@Select("SELECT " +
			" count( id ) AS examineNum, " +
			" ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 2 AND community_id = #{communityId} ) AS verificationNum, " +
			" ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 3 AND community_id = #{communityId} ) AS rejectNum, " +
			" ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 4 AND community_id = #{communityId} ) AS completeNum " +
			" ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 2 AND community_id = #{communityId} and del_tag = 0 ) AS verificationNum, " +
			" ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 3 AND community_id = #{communityId} and del_tag = 0 ) AS rejectNum, " +
			" ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 4 AND community_id = #{communityId} and del_tag = 0 ) AS completeNum " +
			"FROM " +
			" com_act_easy_photo " +
			"WHERE " +
			" `status` = 1 " +
			" AND community_id = #{communityId}")
			" AND community_id = #{communityId} and del_tag = 0")
			ComActEasyPhotoStatisticsVO getEasyPhotoStatistics(@Param("communityId")Long communityId);
			}