package com.shkpr.service.aimodelpower.dbdao.mapper;

import com.shkpr.service.aimodelpower.dbdao.pgtype.GisPointTypeHandlePg;
import com.shkpr.service.aimodelpower.dbdao.providers.TestGeomInfoSqlProvider;
import com.shkpr.service.aimodelpower.dto.SelfGis;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.type.JdbcType;

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

public interface TestGeomInfoMapper {
    @SelectProvider(type = TestGeomInfoSqlProvider.class, method = "totalCounts")
    int totalCounts(@Param("table") String table
            , @Param("andWheres") Map<String, Object> andWheres
            , @Param("orWheres") Map<String, Object> orWheres
            , @Param("extend") String extend);

    @Results({
            @Result(property = "gis_xy", column = "gis_xy", javaType = SelfGis.class ,jdbcType = JdbcType.OTHER, typeHandler = GisPointTypeHandlePg.class)
    })
    @SelectProvider(type = TestGeomInfoSqlProvider.class, method = "listAllWiths")
    List<Map<String, Object>> listAllWiths(@Param("table") String table, @Param("filed") String file
            , @Param("limit") int limit
            , @Param("offset") int offset
            , @Param("andWheres") Map<String, Object> andWheres
            , @Param("orWheres") Map<String, Object> orWheres
            , @Param("order") String order
            , @Param("extend") String extend);

    @Results({
            @Result(property = "gis_xy", column = "gis_xy", javaType = SelfGis.class ,jdbcType = JdbcType.OTHER, typeHandler = GisPointTypeHandlePg.class)
    })
    @SelectProvider(type = TestGeomInfoSqlProvider.class, method = "getByUniqueId")
    Map<String, Object> getOne(@Param("table") String table, @Param("filed") String filed, @Param("id") Object id);

    @Results({
            @Result(property = "gis_xy", column = "gis_xy", javaType = SelfGis.class ,jdbcType = JdbcType.OTHER, typeHandler = GisPointTypeHandlePg.class)
    })
    @SelectProvider(type = TestGeomInfoSqlProvider.class, method = "batchQueryIn")
    List<Map<String, Object>> batchQueryIn(@Param("table") String table, @Param("filed") String file
            , @Param("ids") List<? extends Object> ids
            , @Param("order") String order
            , @Param("extend") String extend);

    @Results({
            @Result(property = "gis_xy", column = "gis_xy", javaType = SelfGis.class ,jdbcType = JdbcType.OTHER, typeHandler = GisPointTypeHandlePg.class)
    })
    @SelectProvider(type = TestGeomInfoSqlProvider.class, method = "batchQueryWiths")
    List<Map<String, Object>> batchQueryWiths(@Param("table") String table, @Param("filed") String filed
            , @Param("andWheres") Map<String, Object> andWheres
            , @Param("orWheres") Map<String, Object> orWheres
            , @Param("order") String order
            , @Param("extend") String extend);

    @InsertProvider(type = TestGeomInfoSqlProvider.class, method = "inserts")
    int inserts(@Param("inserts") Map<String, Object> inserts);

    /**
     * update和delete返回受影响条数需要配合useAffectedRows=true
     * @param datas
     * @param andWheres
     * @return
     */
    @UpdateProvider(type = TestGeomInfoSqlProvider.class, method = "updateWiths")
    int updateWiths(@Param("datas") Map<String, Object> datas
            , @Param("andWheres") Map<String, Object> andWheres
            , @Param("orWheres") Map<String, Object> orWheres
            , @Param("extend") String extend);

    @UpdateProvider(type = TestGeomInfoSqlProvider.class, method = "updateWiths")
    int updateWithsEx(@Param("datas") Map<String, Object> datas
            , @Param("datasEx") Map<String, Object> datasEx
            , @Param("andWheres") Map<String, Object> andWheres
            , @Param("orWheres") Map<String, Object> orWheres
            , @Param("extend") String extend);

    @SelectProvider(type = TestGeomInfoSqlProvider.class, method = "existsLine")
    boolean existLine(@Param("table") String table
            , @Param("andWheres") Map<String, Object> andWheres
            , @Param("orWheres") Map<String, Object> orWheres
            , @Param("extend") String extend);

    @DeleteProvider(type = TestGeomInfoSqlProvider.class, method = "deleteWiths")
    int deleteWithsEx(@Param("andWheres") Map<String, Object> andWheres
            , @Param("orWheres") Map<String, Object> orWheres
            , @Param("extend") String extend);

    @UpdateProvider(type = TestGeomInfoSqlProvider.class, method = "batchUpdateWiths")
    int batchUpdateWiths( @Param("andWheres") List<Map<String, Object>> andWheres
            , @Param("datas") List<Map<String, Object>> datas);
}