java/zhihuishenqu.git

			@@ -22,6 +22,8 @@
			"p.id,\n" +
			"u.`name` sponsor_name,\n" +
			"u.phone sponsor_phone,\n" +
			"count(pu.id)giveThumbsUpNum,\n" +
			"u.image_url,\n" +
			"p.happen_addr,\n" +
			"su.`name` handler_name,\n" +
			"p.`status`,\n" +
			@@ -30,6 +32,7 @@
			"FROM\n" +
			"com_act_easy_photo p\n" +
			"JOIN sys_user u ON p.sponsor_id = u.user_id \n" +
			"left join com_act_easy_photo_user pu ON p.id = pu.easy_photo_id \n" +
			"<if test='comActEasyPhotoVO.sponsorName != null and comActEasyPhotoVO.sponsorName.trim() != ""'>" +
			"AND u.`name` = #{comActEasyPhotoVO.sponsorName} \n" +
			" </if> " +
			@@ -48,12 +51,17 @@
			"AND p.create_at BETWEEN #{comActEasyPhotoVO.createBegin} \n" +
			"AND #{comActEasyPhotoVO.createEnd}" +
			" </if> " +
			"<if test='comActEasyPhotoVO.sponsorId != null and comActEasyPhotoVO.sponsorId != 0'>" +
			"AND p.sponsor_id =#{comActEasyPhotoVO.sponsorId} \n" +
			" </if> " +
			" group by p.id "+
			"</script>")
			IPage<ComActEasyPhotoVO> pageEasyPhoto(Page page, @Param("comActEasyPhotoVO") ComActEasyPhotoVO comActEasyPhotoVO);
			@Select("SELECT \n" +
			"p.id,\n" +
			"p.create_at,\n" +
			"u.`name`,\n" +
			"u.`image_url`,\n" +
			"u.phone,\n" +
			"p.detail,\n" +
			"p.happen_addr,\n" +