package com.siwei.apply.mapper;

import com.siwei.apply.domain.CadastreFile;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

@Mapper
public interface CadastreFileMapper {
    /**
     * 新增
     */
    void add(CadastreFile cadastreFile);

    /**
     * 根据ID查询
     */
    CadastreFile get(String id);

    /**
     * 更新
     */
    void update(CadastreFile cadastreFile);

    /**
     * 删除
     */
    void delete(String id);

    /**
     * 批量删除
     */
    void batchDelete(@Param("ids") List<String> ids);


    /**
     * 列表查询
     */
    List<CadastreFile> getList(CadastreFile cadastreFile);

    /**
     * 分页列表查询
     */
    List<CadastreFile> getListByFilter(com.siwei.apply.domain.vo.CadastreFileFilterVo filterVo);

    /**
     * 查询总数（用于分页）
     */
    int getCountByFilter(com.siwei.apply.domain.vo.CadastreFileFilterVo filterVo);


    /**
     * 查询当前表的所有列
     */
    List<String> selectTableCollum(String tableName);

    List<Map<String,String>> selectTableCollumAndType(@Param("tableName") String tableName);

    List<String> selectDistinctValueByField(@Param("tableName") String tableName, @Param("fieldName") String fieldName,@Param("validFlag") String validFlag);

    /**
     * 查询所有表名
     */
    List<String> selectAllTable();


    /**
     * 查询所有表名无视图
     */
    List<String> selectAllTableNoView();

    int insertTableData(@Param("tableName") String tableName, @Param("data") Map<String, Object> data, @Param("shpDbSRID") Integer shpDbSRID);


    String selectGeoms(String tableName);

    /**
     * 增加valid_flag字段
     */
    void addValidFlagColumn(@Param("tableName") String tableName);

    void updateValidFlag(@Param("validFlag") String validFlag, @Param("oldValidFlag") String oldValidFlag, @Param("tableName") String tableName);


    void deleteByValidFlag(@Param("validFlag") String validFlag,@Param("tableName") String tableName);


    Integer countByValidFlag(@Param("validFlag") String validFlag, @Param("tableName") String tableName);

    List<Map<String,Object>> selectTableData(@Param("validFlag") String validFlag, @Param("tableName") String tableName);

    Map<String,Object> selectExistsSameData(@Param("validFlag") String validFlag, @Param("data") Map<String, Object> data, @Param("tableName") String tableName);

    int batchUpdateByBsm(@Param("tableName") String tableName, @Param("list") List<Map<String, Object>> list);

    int batchDeleteByBsm(@Param("tableName") String tableName, @Param("list") List<Map<String, Object>> list);

    List<Map<String,Object>> selectTableDataByCondition(@Param("validFlag") String validFlag, @Param("tableName") String tableName,@Param("bsm") String bsm,@Param("ywh") String ywh,@Param("needLimit") Boolean needLimit);


    List<Map<String,Object>> selectTableDataByZDDMorBDCDYH(@Param("validFlag") String validFlag, @Param("tableName") String tableName,@Param("zdIdList") List<String> zdIdList,@Param("zddmKey") String zddmKey,@Param("bdcIdList") List<String> bdcIdList) ;

    //获取相交的数据
    List<Map<String,Object>> intersectsTableWkt(@Param("tableName") String tableName, @Param("validFlag") String validFlag, @Param("ewkt") String ewkt);


    Map<String,Object> selectTableDataByBsm(@Param("tableName") String tableName,@Param("bsm") String bsm);


    List<Map<String,Object>> selectTableRowExcel(@Param("tableName") String tableName, @Param("geomFlag") String geomFlag, @Param("bsmList") List<Object> bsmList, @Param("ywhList") List<String> ywhList);


    String checkQueryWhere(@Param("tableName") String tableName, @Param("queryWhere") String queryWhere);

    String transformTo4326(@Param("ewkt") String ewkt);


    List<Map<String,Object>> selectQlrList(@Param("name") String name, @Param("validFlag") String validFlag);


}