package cn.com.goldenwater.dcproj.dao;

import cn.com.goldenwater.core.persistence.CrudDao;
import cn.com.goldenwater.dcproj.model.AttRsBase;
import cn.com.goldenwater.dcproj.model.BisInspSelArea;
import cn.com.goldenwater.dcproj.param.BisInspSelAreaParam;
import cn.com.goldenwater.dcproj.param.InGroupResParam;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

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

@Repository
public interface BisInspSelAreaDao extends CrudDao<BisInspSelArea, BisInspSelAreaParam> {

    List<Map<String, Object>> getAreaByPersid(@Param("persId") String persId, @Param("orgId") String orgId);

    List<Map<String, Object>> getProvinceAreaByPersid(@Param("persId") String persId, @Param("end") String end
            , @Param("str") String str, @Param("pattern") String pattern, @Param("adCode") String adCode, @Param("pType") String pType, @Param("orgId") String orgId);

    List<Map<String, Object>> getAddvcdByAdCode(@Param("adCode") String adCode, @Param("adGrad") String adGrad);

    List<Map<String, Object>> getAddvcdCacheByAdCode(@Param("adCode") String adCode, @Param("adGrad") String adGrad);

    List<Map<String, Object>> getPersByArea(@Param("adCode") String adCode, @Param("orgId") String orgId);

    List<Map<String, Object>> getResByArea(BisInspSelAreaParam p);

    List<Map<String, Object>> getOptionalArea(@Param("id") String id, @Param("adGrid") String adGrid, @Param("adName") String adName, @Param("adCode") String adCode, @Param("orgId") String orgId);

    /**
     * 根据批次、行政区划获取该批次下已添加该市的组名
     *
     * @param id     批次
     * @param adCode 行政区划
     * @return
     */
    List<Map<String, String>> getPnmByBatchAndAdCode(@Param("id") String id, @Param("adCode") String adCode);

    List<BisInspSelArea> getAllSub(BisInspSelAreaParam param);

    List<AttRsBase> getResByGroup(InGroupResParam inGroupResParam);

    int deleteByGroupId(@Param("id") String id, @Param("adCode") String adCode, @Param("orgId") String orgId);

    List<Map<String, Object>> getAreaByGroup(@Param("id") String id, @Param("adGrid") String adGrid, @Param("adName") String adName, @Param("adCode") String adCode, @Param("province") String province);

    List<Map<String, Object>> getAreaByAdCode(@Param("adCode") String adCode, @Param("adName") String adName);

    //稽察项目同组范围内只能督查一次
    List<Map<String, Object>> getPawpByArea(BisInspSelAreaParam p);
}