package cn.com.goldenwater.dcproj.dao;

import cn.com.goldenwater.core.persistence.CrudDao;
import cn.com.goldenwater.dcproj.dto.BisInspAllDto;
import cn.com.goldenwater.dcproj.dto.DataDto;
import cn.com.goldenwater.dcproj.dto.OrgDto;
import cn.com.goldenwater.dcproj.dto.UserLineDto;
import cn.com.goldenwater.dcproj.model.BisInspAll;
import cn.com.goldenwater.dcproj.model.BisInspAllNode;
import cn.com.goldenwater.dcproj.model.BisInspAllRlation;
import cn.com.goldenwater.dcproj.model.InspType;
import cn.com.goldenwater.dcproj.param.BisInspAllParam;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

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

@Repository
public interface BisInspAllDao extends CrudDao<BisInspAll, BisInspAllParam> {

    List<BisInspAllDto> listByMap(Map<String, Object> paramMap);

    List<BisInspAllDto> listByMap2(Map<String, String> paramMap);

    BisInspAll getMaxOne(@Param("pid") String guid, @Param("orgId") String orgId);

    List<BisInspAll> getAllNode(@Param("userid") String userid,
                                @Param("orgType") String orgType,
                                @Param("province") String province,
                                @Param("orgId") String orgId,
                                @Param("tabType") String tabType,
                                @Param("nowTime") String nowTime,
                                @Param("year") String year,
                                @Param("yearTaskId") String yearTaskId,
                                @Param("curYear") String curYear,
                                @Param("leadDep") String leadDep);

    List<BisInspAll> getAllNodeByLevel(@Param("persId") String persId, @Param("objType") String objType, @Param("level") int level, @Param("province") String province);

    List<BisInspAllNode> BisInspAllObjById(@Param("id") String id, @Param("province") String province);

    List<Map<String, Object>> getUserByOrg(@Param("objType") String objType, @Param("province") String province);

    /**
     * 导出模块流域树，根据pid和code过滤节点
     *
     * @param pid  父节点
     * @param code 行政编码
     * @param type 查询类型 水库1 人饮2 水毁3
     * @return 流域树节点列表
     */
    List<Map<String, Object>> getNodeByPidAndCode(@Param("pid") String pid, @Param("code") String code, @Param("type") String type, @Param("province") String province);

    List<BisInspAll> findNodeByPersId(@Param("persId") String persId, @Param("province") String province);

    List<BisInspAll> findAreas();

    String selectMax(BisInspAllParam inspAllParam);

    BisInspAll getOne(BisInspAllParam inspAllParam);

    List<InspType> listInspType();

    List<BisInspAllRlation> findExistList(BisInspAllParam inspAllRParam);

    int selectCount(BisInspAllParam inspAllParam);

    List<BisInspAll> getAllNodeById(String s);

    DataDto countSysMsg(@Param("nowTIme") String nowTime, @Param("orgId") String orgId);

    List<OrgDto> findOrgMsg();

    List<UserLineDto> countUserLine();

    List<UserLineDto> countUserLine2(@Param("orgId") String orgId);

    List<BisInspAll> listByName(@Param("pTypes") String pTypes, @Param("length") String length);

    String[] getYearById(@Param("id") String id);

    List<BisInspAll> getPersDcWork(@Param("persId") String persId);

    /**
     * 首页 四川  批次数汇总
     */
    List<Map<String,Object>> getInspBatchNum(Map<String, Object> paramMap ) ;
}