package com.newfiber.api.pc.dao.RiverManage;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.newfiber.api.pc.model.River.*;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * patrolManageBase model层
 *
 * @author luzhan
 */
@Repository
public interface PatrolManageBaseMapper extends BaseMapper<PatrolManageBase> {

    /**
     * 查询巡查基础列表
     * @param patrolType
     * @param projectName
     * @return
     */
    List<PatrolManageBaseDto> selectListByTypeAndName(@Param("patrolType") String patrolType, @Param("projectName")String projectName);

    /**
     * 查询巡查列表
     * @param collect
     * @return
     */
    List<PatrolManageBase> selectListByIds(@Param("collect") List<Long> collect,@Param("patrolType")String patrolType);

    /**
     * 查询负责人和河道
     * @param projectParentId
     * @param patrolType
     * @param projectName
     * @return
     */
    List<PatrolManageProjectDto> selectProjectList(@Param("projectParentId") Integer projectParentId, @Param("patrolType")Integer patrolType
                                                   , @Param("projectName")String projectName, @Param("handlerNo")String handlerNo);

    /**
     * 查询该类型的所有项目
     * @param patrolType
     * @param startTime
     * @param endTime
     * @return
     */
    List<PatrolProblemCountDto> selectCountList(@Param("patrolType")Integer patrolType, @Param("startTime")String startTime, @Param("endTime")String endTime);

    /**
     * 获取主处理人项目编号
     * @param projectId
     * @return
     */
    PatrolManageBase getProjectId(@Param("projectId")Long projectId,@Param("patrolType")Integer patrolType);

    /**
     * 查询所有的问题类型
     * @param patrolType
     * @param startTime
     * @param endTime
     * @return
     */
    List<PatrolProblemTypeCountDto> selectProblemCount(@Param("patrolType")Integer patrolType, @Param("startTime")String startTime, @Param("endTime")String endTime);

    /**
     * 查询配置列表
     * @param patrolType
     * @param areaCode
     * @param projectName
     * @param projectParentId
     * @return
     */
    List<PatrolManageBase> selectBase(@Param("patrolType")String patrolType, @Param("areaCode")String areaCode, @Param("projectName")String projectName, @Param("projectParentId")String projectParentId);
}