package cn.com.goldenwater.dcproj.dao;

import cn.com.goldenwater.dcproj.dto.*;
import cn.com.goldenwater.dcproj.model.*;
import cn.com.goldenwater.dcproj.param.InGroupResParam;
import cn.com.goldenwater.dcproj.param.InspObjParam;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

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

/**
 * Created by 61618 on 2019/4/17.
 */
@Repository
public interface SupervisionPlanDao {
    List<AllNodeDto> getNodeByPersid(@Param("persid") String persid, @Param("ptype") String ptype, @Param("orgId") String orgId, @Param("province") String province);

    List<PersAllInfoDto> getAllInfoByPersidAndOrgId(@Param("persid") String persid, @Param("inspYear") String inspYear, @Param("inspMnth") String inspMnth, @Param("orgIdStr") String orgIdStr, @Param("orgId") String orgId, @Param("province") String province, @Param("yearPlanId") String yearPlanId);

    List<PersAllDto> getPersAllDtoList(@Param("id") String id, @Param("orgId") String orgId, @Param("province") String province);

    List<PersAllObjDto> getPersAllObjDtoList(@Param("id") String id, @Param("orgId") String orgId, @Param("province") String province);

    List<PersAllAreaDto> getPersAllAreaDtoList(@Param("id") String id, @Param("orgId") String orgId, @Param("province") String province);

    List<AllNodeDto> getNode(@Param("id") String id, @Param("orgId") String orgId, @Param("province") String province);

    AllNodeDto getNodeById(@Param("id") String id);

    List<AttSupResBase> getSupResByGroup(InGroupResParam inGroupResParam);

    List<AttSupResBase> getSupRivListNotInspGroupId(@Param("inspGroupId") String inspGroupId, @Param("objType") String objType, @Param("rsName") String rsName, @Param("engScal") String engScal, @Param("rsAdmDep") String rsAdmDep, @Param("adCode") String adCode);

    List<AttSupAdBase> getSupCwsListNotInspGroupId(InspObjParam inspObjParam);

    List<BisInspSupWtdst> getSupWtdListNotInspGroupId(@Param("inspGroupId") String inspGroupId, @Param("province") String province, @Param("objType") String objType, @Param("wtdstType") String wtdstType, @Param("wtdstNm") String wtdstNm, @Param("wtdstState") String wtdstState, @Param("adCode") String adCode, @Param("nm") String nm, @Param("orderBy") String orderBy, @Param("year") String year, @Param("prjState") String prjState);

    void insertPers(@Param("id") String id, @Param("guid") String guid, @Param("persType") String persType, @Param("orgId") String orgId, @Param("adCode") String province, @Param("type") String type);

    LgtdAndLttd getLgtdAndLttd(@Param("code") String code, @Param("type") String type);

    void insertSupArea(@Param("uuid") String uuid, @Param("id") String id, @Param("adCode") String adCode, @Param("adName") String adName, @Param("orgId") String orgId, @Param("province") String province);

    ObjIdDto getPers(@Param("id") String id, @Param("guid") String guid);

    int updatePersType(@Param("id") String id, @Param("guid") String guid, @Param("persType") String persType);

    List<PersTypeDto> getPersType(@Param("persid") String persid, @Param("orgId") String orgId, @Param("province") String province);

    void updateTeamLeader(@Param("id") String id);

    void updateGroupNm(@Param("id") String id, @Param("nm") String nm);

    List<PersTypeDto> getPersTypeByPersid(@Param("persid") String persid, @Param("orgId") String orgId, @Param("province") String province);

    List<PersTypeDto> getPersTypeByPersidOrg(@Param("persid") String persid, @Param("province") String province);

    List<EmpwtprjDto> getSupEmpListNotInspGroupId(@Param("inspGroupId") String inspGroupId, @Param("objType") String objType, @Param("nm") String nm, @Param("adCode") String adCode, @Param("engSta") String engSta, @Param("orderBy") String orderBy, @Param("orgId") String orgId, @Param("province") String province);

    List<GrwDto> getSupGrwListNotInspGroupId(@Param("inspGroupId") String inspGroupId, @Param("objType") String objType, @Param("nm") String nm, @Param("adCode") String adCode, @Param("orderBy") String orderBy, @Param("sttp") String sttp, @Param("gateType") String gateType, @Param("orgId") String orgId, @Param("province") String province);

    List<WagaDto> getSupWagaListNotInspGroupId(InspObjParam inspObjParam);

    /**
     * 获取不在督查组范围内的稽察项目
     * inspGroupId 督查组id
     * objType  督查类型
     * nm  督查对象名称
     * adCode 行政区划
     * engSta 类型
     * orderBy 排序字段
     *
     * @return
     */
    List<TacAttPawpBase> getSupPawpListNotInspGroupId(InspObjParam inspObjParam);

    List<PersAllInfoDto> getAllInfoByPersid(@Param("persid") String persid, @Param("ptype") String ptype, @Param("id") String id, @Param("orgId") String orgId, @Param("province") String province);

    List<PersAllObjDto> getPersAllObjDtoListByType(@Param("id") String id, @Param("ptype") String ptype, @Param("orgId") String orgId, @Param("province") String province);

    ObjectNameDto getNodeBy(@Param("id") String id, @Param("inspYear") String inspYear, @Param("inspMnth") String inspMnth, @Param("orgId") String orgId, @Param("province") String province);

    ObjIdDto getMaxGroupId(@Param("id") String id, @Param("orgId") String orgId, @Param("province") String province);

    void insertNode(BisInspAllNodeDto bisInspAllNodeDto);

    void updateNode(BisInspAllDto bisInspAllDto);

    BisInspAllRlationPersDto getPersInfo(@Param("persid") String persid);

    List<AllNodeDto> getNodeByOrgId(@Param("orgIdStr") String orgIdStr, @Param("orgId") String orgId, @Param("province") String province);

    int deleteNodeByPersid(@Param("persid") String persid);

    List<AttFscBaseDto> getSupFscListNotInspGroupId(InspObjParam inspObjParam);

    List<AttOtherBaseDto> getSupOtherListNotInspGroupId(InspObjParam inspObjParam);

    List<AttSdBase> getSupSdListNotInspGroupId(InspObjParam inspObjParam);

    List<AttSwhsBase> getSupSwhsListNotInspGroupId(InspObjParam inspObjParam);

    List<AttWiuBase> getSupWiuListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getAdXBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getWuntListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getPrdListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getJSFLListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getJSWAListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getEcofrdListNotInspGroupId(InspObjParam inspObjParam);

    List<AttSupResBase> getSupResRsmlByGroup(InGroupResParam inGroupResParam);

    List<SupervisionPlanDto> getAdBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<AttSupResBase> getSupResStndByGroup(InGroupResParam inGroupResParam);

    /**
     * 获取不在督查组中的对象
     *
     * @param inspObjParam: ObjType= 11
     * @return
     */
    List<SupervisionPlanDto> getNotSuperviseGroupObj(InspObjParam inspObjParam);

    List<AttRsBase> getRsBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<AttSupAdBase> getSupMfdpListNotInspGroupId(@Param("inspGroupId") String inspGroupId, @Param("province") String province, @Param("objType") String objType, @Param("adName") String adName, @Param("adCode") String adCode, @Param("nm") String nm, @Param("orderBy") String orderBy);

    List<BisInspWagaSapRgstr> getSapBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getEfpBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<BisInspWintRgstr> getWintuBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getWtuntBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getWtgtBaseListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getAdBaseMunicipalLevelListNotInspGroupIds(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getAdBaseCountyLevelListNotInspGroupIds(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getRsListNotInGroup(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSamListNotInGroup(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSupCdepListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSupBidListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSupRlrwListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSupGrowListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSupFundListNotInspGroupId(InspObjParam inspObjParam);

    /**
     * 69
     *
     * @param inspObjParam
     * @return
     */
    List<SupervisionPlanDto> getSupDrdmpListNotInspGroupId(InspObjParam inspObjParam);

    /**
     * 72
     *
     * @param inspObjParam
     * @return
     */
    List<SupervisionPlanDto> getSupWiuqhListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSafetyListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getYndepListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getRvgmListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getDpgmListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getWtprjListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getUnwtListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getFloodqhListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getDstfldqhListNotInspGroupId(InspObjParam inspObjParam);

    List<AttSupAdBase> getAddAxListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getStstnListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getGnrlListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getSwhsjsListNotInspGroupId(InspObjParam inspObjParam);
    //山东小水库督查
    List<SupervisionPlanDto> getRsvrSdListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getXsdyhglListNotInspGroupId(InspObjParam inspObjParam);
    //广东农饮工程督查
    List<SupervisionPlanDto> getRdwpGdListNotInspGroupId(InspObjParam inspObjParam);

    // 江苏计划用水户及取水口
    List<SupervisionPlanDto> getJsPwiuListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getJsPwiu2024ListNotInspGroupId(InspObjParam inspObjParam);

    List<SupervisionPlanDto> getFjgnrlListNotInspGroupId(InspObjParam inspObjParam);

    Map<String,String> getYearMonth(@Param("groupId") String groupId);

    List<PersAllDto> getPersAllDtoByIdsList(@Param("ids")String ids);

    List<PersAllAreaDto> getPersAllAreaDtoByIdsList(@Param("ids")String ids);
    List<PersAllObjDto> getPersAllObjDtoByIdList(@Param("id")String id);

    //121福建水利工程项目法人安全生产标准化评审
    List<SupervisionPlanDto> getFpjlglListNotInspGroupId(InspObjParam inspObjParam);
    //122福建水利工程管理单位安全生产标准化评审标准
    List<SupervisionPlanDto> getFjpjmgdpListNotInspGroupId(InspObjParam inspObjParam);
    //123福建水利水电施工企业安全生产标准化评审标准
    List<SupervisionPlanDto> getFjaccpListNotInspGroupId(InspObjParam inspObjParam);

    //124福建水利水电勘测设计单位安全生产标准化评审
    List<SupervisionPlanDto> getFjsduListNotInspGroupId(InspObjParam inspObjParam);
    //125福建水利工程建设监理单位安全生产标准化评审
    List<SupervisionPlanDto> getFjpjcsuListNotInspGroupId(InspObjParam inspObjParam);
}