java/zhihuishenqu.git

			@@ -5,12 +5,14 @@
			import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
			import com.panzhihua.common.model.vos.community.ComActEasyPhotoVO;
			import com.panzhihua.common.model.vos.community.TodoEventsVO;
			import com.panzhihua.common.model.vos.screen.*;
			import com.panzhihua.service_community.model.dos.ComActEasyPhotoDO;
			import org.apache.ibatis.annotations.Mapper;
			import org.apache.ibatis.annotations.Param;
			import org.apache.ibatis.annotations.Select;

			import java.util.List;
			import java.util.Map;

			/**
			* @program: springcloud_k8s_panzhihuazhihuishequ
			@@ -36,6 +38,8 @@
			"p.`photo_path_list`,\n" +
			"p.create_at,\n" +
			"p.feedback_at,\n" +
			"p.is_report,\n" +
			"p.is_publicity,\n" +
			"p.examine_at \n" +
			"FROM\n" +
			"com_act_easy_photo p\n" +
			@@ -91,6 +95,8 @@
			"p.`photo_path_list`,\n" +
			"p.create_at,\n" +
			"p.feedback_at,\n" +
			"p.is_report,\n" +
			"p.is_publicity,\n" +
			"p.examine_at \n" +
			"FROM\n" +
			"com_act_easy_photo p\n" +
			@@ -142,6 +148,7 @@
			"p.examine_at,\n" +
			"p.create_at,\n" +
			"u.`name` sponsorName,\n" +
			"u.nick_name userNickName,\n" +
			"su.`name` handlerName,\n" +
			"u.`image_url`,\n" +
			"u.phone,\n" +
			@@ -178,7 +185,7 @@
			"SELECT\n" +
			"'1' type\n" +
			"FROM\n" +
			" p.del_tag = 0 and com_act_easy_photo p \n" +
			" com_act_easy_photo p \n" +
			"WHERE\n" +
			" p.del_tag = 0 and p.community_id = #{communityId} \n" +
			"AND p.`status` = 2 and p.is_need_feed_back=1 and p.handler_id=#{userId}\n"
			@@ -189,6 +196,7 @@
			"SELECT\n" +
			"p.id,\n" +
			"u.`name` sponsor_name,\n" +
			"u.`nick_name` userNickName,\n" +
			"u.phone sponsor_phone,\n" +
			"count(DISTINCT pu.id)giveThumbsUpNum,\n" +
			"count(DISTINCT c.id)commentNum,\n" +
			@@ -229,4 +237,36 @@
			"</script>"
			)
			IPage<ComActEasyPhotoVO> pageEasyPhotoApplets(Page page, @Param("comActEasyPhotoVO")ComActEasyPhotoVO comActEasyPhotoVO);

			@Select("SELECT t.name,COUNT(p.id) as num FROM com_act_easy_photo_type t LEFT JOIN com_act_easy_photo_type_relation r ON t.id = r.easy_type_id " +
			"LEFT JOIN com_act_easy_photo p ON r.easy_id = p.id AND p.community_id = #{communityId} AND p.status = 1 " +
			"GROUP BY t.name ")
			List<PieElementVO> countDeal(@Param("communityId")Long communityId);

			@Select("SELECT t.name,COUNT(p.id) as num FROM com_act_easy_photo_type t LEFT JOIN com_act_easy_photo_type_relation r ON t.id = r.easy_type_id " +
			"LEFT JOIN com_act_easy_photo p ON r.easy_id = p.id AND p.community_id = #{communityId} AND p.status = 4 " +
			"GROUP BY t.name ")
			List<PieElementVO> countPub(@Param("communityId")Long communityId);

			@Select("SELECT t.name,COUNT(p.id) as num FROM com_act_easy_photo_type t LEFT JOIN com_act_easy_photo_type_relation r ON t.id = r.easy_type_id " +
			"LEFT JOIN com_act_easy_photo p ON r.easy_id = p.id and p.community_id = #{communityId} AND p.status = 3 " +
			"GROUP BY t.name ")
			List<PieElementVO> countApproved(@Param("communityId")Long communityId);

			@Select("SELECT COUNT(id) AS noneDeal," +
			"(" +
			"SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = 2 AND create_at LIKE concat(#{nowDate},'%') " +
			") AS currentNum," +
			"(" +
			"(SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = #{communityId} AND status = 4 )*100/(SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = #{communityId} and (status = 3 or status = 4)) " +
			") AS pubPoint," +
			"(SELECT AVG(TIMESTAMPDIFF(MINUTE,create_at,feedback_at)) FROM com_act_easy_photo WHERE community_id = #{communityId} and status = 4 ) AS dealTime " +
			"FROM com_act_easy_photo where community_id = #{communityId} and status = 1 ")
			Map<String, Object> countByCommunityId(@Param("communityId")Long communityId,@Param("nowDate") String nowDate);

			@Select("SELECT COUNT(id) AS total, " +
			"(SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = #{communityId} AND #{start} < create_at and create_at < #{end} ) AS adds, " +
			"(SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id =#{communityId} AND (status = 3 or status = 4) AND #{start} < create_at and create_at < #{end}) AS deal " +
			"FROM com_act_easy_photo WHERE community_id = #{communityId} AND create_at < #{end} ")
			EastPhotoVO countByTime(@Param("start")String start, @Param("end")String end, @Param("nowDate")String nowDate, @Param("communityId")Long communityId);
			}