java/zhihuishenqu.git

			@@ -21,10 +21,12 @@
			@Select("<script> " +
			"SELECT\n" +
			"w.id,\n" +
			"u.NAME sponsor_name,\n" +
			"u.name sponsor_name,\n" +
			"u.image_url ,\n" +
			"w.sponsor_phone,\n" +
			"w.wish_name,\n" +
			"w.`status`,\n" +
			"count(wu.id)start_num,\n" +
			"w.`detail`,\n" +
			"w.start_num,\n" +
			"w.form,\n" +
			@@ -33,6 +35,7 @@
			"w.create_at \n" +
			"FROM\n" +
			"com_act_micro_wish w\n" +
			"left join com_act_micro_wish_user wu on w.id=wu.micro_wish_id "+
			"JOIN sys_user u ON w.sponsor_id = u.user_id \n" +
			"<if test='comActMicroWishVO.sponsorName != null and comActMicroWishVO.sponsorName.trim() != ""'>" +
			"AND u.name = #{comActMicroWishVO.sponsorName} \n" +
			@@ -53,17 +56,23 @@
			"AND w.create_at BETWEEN #{comActMicroWishVO.createBegin} \n" +
			"AND #{comActMicroWishVO.createEnd}" +
			" </if> " +
			"<if test='comActMicroWishVO.isApplets != null and comActMicroWishVO.isApplets != 0'>" +
			"AND w.status in (3,6) \n" +
			" </if> " +
			" group by w.id \n"+
			"ORDER BY w.`status`, w.create_at "+
			"</script>")
			IPage<ComActMicroWishVO> pageMicroWish(Page page, @Param("comActMicroWishVO") ComActMicroWishVO comActMicroWishVO);
			@Select("SELECT\n" +
			"w.id,\n" +
			"w.start_num,\n" +
			"u.NAME sponsor_name,\n" +
			"u.name sponsor_name,\n" +
			"w.create_at,\n" +
			"u.image_url,\n" +
			"w.sponsor_phone,\n" +
			"w.`status`,\n" +
			"w.wish_name,\n" +
			"count(wu.id)startNum,\n" +
			"w.detail,\n" +
			"w.photo_path_list,\n" +
			"su.`name` responsible_name,\n" +
			@@ -79,7 +88,10 @@
			"com_act_micro_wish w\n" +
			"JOIN sys_user u ON w.sponsor_id = u.user_id\n" +
			"LEFT JOIN sys_user su ON w.responsible_id = su.user_id \n" +
			"LEFT JOIN com_act_micro_wish_user wu ON w.id = wu.micro_wish_id \n" +
			"WHERE\n" +
			"w.id =#{id}")
			"w.id =#{id}"+
			" group by w.id "
			)
			ComActMicroWishVO detailMicroWish(Long id);
			}