java/zhihuishenqu.git

			@@ -5,6 +5,8 @@

			import com.panzhihua.common.model.dtos.PageBaseDTO;
			import com.panzhihua.common.model.vos.community.StatisticsCommVO;
			import com.panzhihua.common.model.vos.neighbor.*;
			import com.panzhihua.service_community.entity.NewFightNeedProblemClaim;
			import org.apache.ibatis.annotations.Mapper;
			import org.apache.ibatis.annotations.Param;
			import org.apache.ibatis.annotations.Select;
			@@ -14,10 +16,6 @@
			import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
			import com.panzhihua.common.model.dtos.neighbor.ComActNeighborCircleAdminDTO;
			import com.panzhihua.common.model.dtos.neighbor.ComActNeighborCircleAppDTO;
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleAdminVO;
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleAppVO;
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleDetailAppVO;
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCommentReplyAppVO;
			import com.panzhihua.common.model.vos.screen.CarouselInfoVO;
			import com.panzhihua.common.model.vos.screen.PieElementVO;
			import com.panzhihua.common.model.vos.user.AdministratorsUserVO;
			@@ -39,15 +37,25 @@
			*/
			IPage<ComActNeighborCircleAppVO> pageNeighborByApp(Page page, @Param("neighborCircleAppDTO") ComActNeighborCircleAppDTO neighborCircleAppDTO);

			@Select("<script> " + "select canc.id,su.nick_name as name,su.image_url as headUrl,canc.release_content "
			+ ",canc.release_images,canc.comment_num,canc.fabulous_num,canc.forward_num,canc.views_num,canct.name as topicName,canc.refuse_reason "
			+ ",canc.is_boutique,canc.create_at,canc.reply_at,su.community_id,canc.type from com_act_neighbor_circle as canc "
			+ " left join sys_user as su on su.user_id = canc.release_id "
			+ " left join com_act_neighbor_circle_topic as canct on canct.id = canc.topic_id where canc.id = #{circleId} and canc.is_del = 2"
			+ " </script>")
			/**
			* 分页查询邻里圈列表
			* @param neighborCircleAppDTO 请求参数
			* @return 邻里圈列表
			*/
			IPage<ComActNeighborCircleAppVO> selectSolve(Page page, @Param("neighborCircleAppDTO") ComActNeighborCircleAppDTO neighborCircleAppDTO);

			ComActNeighborCircleDetailAppVO neighborDetailByApp(@Param("circleId") Long circleId);


			IPage<ComActNeighborCircleAdminVO> pageNeighborByAdmin(Page page,@Param("neighborCircleAdminDTO") ComActNeighborCircleAdminDTO neighborCircleAdminDTO);

			/**
			* 大屏清单查询
			* @param page
			* @param neighborCircleAdminDTO
			* @return
			*/
			IPage<ComActNeighborCircleAdminVO> pageNeighborByBigScreen(Page page,@Param("neighborCircleAdminDTO") ComActNeighborCircleAdminDTO neighborCircleAdminDTO);

			@Select("select * from sys_user where user_id=#{userId}")
			AdministratorsUserVO selectUserByUserId(@Param("userId") Long userId);
			@@ -89,7 +97,7 @@
			+ "UNION ALL "
			+ "SELECT COUNT(id) as num,'一起议' as name FROM com_act_discuss WHERE community_id = ${communityId} "
			+ "UNION ALL "
			+ "SELECT COUNT(id) as num,'邻里圈' as name FROM com_act_neighbor_circle WHERE community_id = ${communityId} AND STATUS = 2 and belong_type = 1"
			+ "SELECT COUNT(id) as num,'邻里圈' as name FROM com_act_neighbor_circle WHERE community_id = ${communityId} AND STATUS = 2 and belong_type = 1 "
			+ "UNION ALL "
			+ "SELECT COUNT( e.id ) AS num,'网格事件' AS name FROM `event` as e left join event_grid_data as egd on egd.id = e.grid_id WHERE egd.grid_community_id = ${communityId} AND e.event_process_status = 2 "
			+ "UNION ALL "
			@@ -102,7 +110,7 @@
			+ "UNION ALL "
			+ "SELECT COUNT(id) as num,'一起议' as name FROM com_act_discuss WHERE community_id = ${communityId} "
			+ "UNION ALL "
			+ "SELECT COUNT(id) as num,'邻里圈' as name FROM com_act_neighbor_circle WHERE community_id = ${communityId} AND STATUS = 1 and belong_type = 1"
			+ "SELECT COUNT(id) as num,'邻里圈' as name FROM com_act_neighbor_circle WHERE community_id = ${communityId} AND STATUS = 1 and belong_type = 1 "
			+ "UNION ALL "
			+ "SELECT COUNT( e.id ) AS num,'网格事件' AS NAME FROM `event` as e left join event_grid_data as egd on egd.id = e.grid_id WHERE egd.grid_community_id = ${communityId} AND e.event_status = 2 and e.event_deal_status in (1,2,3) "
			+ "UNION ALL "
			@@ -142,4 +150,98 @@
			StatisticsCommVO getNeighborTotalPolylineDate(@Param("communityId") Long communityId, @Param("date") String date);

			IPage<ComActNeighborCircleAdminVO> indexNeighborList(@Param("page") Page page, @Param("pageBaseDTO") PageBaseDTO pageBaseDTO);

			ServiceStaticsVO selectStatsCheckUnit(@Param("checkUnitId") Long checkUnitId,@Param("date")String date);

			ServiceStaticsVO selectStatsUser(@Param("phone") String phone,@Param("checkUnitId")String checkUnitId, @Param("date")String date);

			List<ComActNeighborCircleAppVO> selectListByCheckUnitId(@Param("checkUnitId")Long checkUnitId,@Param("date")String date);

			List<ComActNeighborCircleAppVO> selectListByPhone(@Param("phone")String phone,@Param("date")String date);

			/**
			* 单位服务统计
			*/
			List<UnitActivityAnalysisVO> institutionalUnitServiceAnalysis(@Param("beginTime") String beginTime,
			@Param("endTime") String endTIme,
			@Param("belongTo") String belongTo,
			@Param("communityId") Long communityId,
			@Param("unitId") Long unitId);

			List<UnitActivityAnalysisVO> getNewTaskList(@Param("beginTime") String beginTime,
			@Param("endTime") String endTIme,
			@Param("belongTo") String belongTo,
			@Param("communityId") Long communityId);

			List<UnitActivityAnalysisVO> institutionalUnitActivityAnalysis(@Param("beginTime") String beginTime,
			@Param("endTime") String endTIme,
			@Param("belongTo") String belongTo,
			@Param("communityId") Long communityId,
			@Param("unitId") Long unitId);

			List<PartyMemberAnalysisVO> getNewPartyMemberTaskList(@Param("beginTime") String beginTime,
			@Param("endTime") String endTIme,
			@Param("belongTo") String belongTo,
			@Param("communityId") Long communityId,
			@Param("unitId") Long unitId,
			@Param("searchContent") String searchContent
			);
			List<PartyMemberAnalysisVO> institutionalPartyMemberServiceAnalysis(@Param("beginTime") String beginTime,
			@Param("endTime") String endTIme,
			@Param("belongTo") String belongTo,
			@Param("communityId") Long communityId,
			@Param("unitId") Long unitId,
			@Param("searchContent") String searchContent
			);
			List<PartyMemberAnalysisVO> institutionalPartyMemberActAnalysis(@Param("beginTime") String beginTime,
			@Param("endTime") String endTIme,
			@Param("belongTo") String belongTo,
			@Param("communityId") Long communityId,
			@Param("unitId") Long unitId,
			@Param("searchContent") String searchContent);
			List<PartyMemberAnalysisVO> institutionalPartyMemberServiceAnalysisByServicesTimes(@Param("beginTime") String beginTime, @Param("endTime") String endTIme, @Param("belongTo") String belongTo);

			/**
			* 查询我的问题数量
			* @param type
			* @param phone
			* @return
			*/
			Integer selectCount(@Param("type") Integer type,@Param("phone") String phone,@Param("communityId") Long communityId);

			/**
			* 分页查询可关联清单列表
			* @param neighborCircleAppDTO
			* @return
			*/
			IPage<ComActNeighborCircleAppVO> pageRelationList(@Param("userPage") Page userPage, @Param("neighborCircleAppDTO") ComActNeighborCircleAppDTO neighborCircleAppDTO);

			/**
			* 单位获取服务明细
			* @param checkUnitId
			* @param date
			* @param serviceType
			* @return
			*/
			List<ServiceDetailStaticsVO> selectServiceDetailList(@Param("checkUnitId") Long checkUnitId, @Param("date") String date, @Param("serviceType") Integer serviceType);

			/**
			* 个人获取服务明细
			* @param checkUnitId
			* @param phone
			* @param date
			* @param serviceType
			* @return
			*/
			List<ServiceDetailStaticsVO> selectServiceDetailListForPersonal(@Param("checkUnitId") Long checkUnitId, @Param("phone") String phone, @Param("date") String date, @Param("serviceType") Integer serviceType);


			/**
			* 根据手机好查询用户完成清单任务
			* @param phone
			* @return
			*/
			List<NewFightNeedProblemClaim> getNewServiceNum(@Param("phone") String phone,@Param("unitId") String unitId);


			}