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

import com.shkpr.service.aimodelpower.dbdao.providers.WODispatchCmdBatchDisposalSqlProvider;
import com.shkpr.service.aimodelpower.dbdao.providers.WODispatchCmdBatchItemSqlProvider;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.annotations.UpdateProvider;

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

public interface WODispatchCmdPatchItemMapper {

    @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.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);

    @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.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);

    @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "getByUniqueId")
    Map<String, Object> getOne(@Param("table") String table, @Param("filed") String filed, @Param("id") Object id);

    @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.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);

    @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.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 = WODispatchCmdBatchItemSqlProvider.class, method = "inserts")
    int inserts(@Param("inserts") Map<String, Object> inserts);

    /**
     * update和delete返回受影响条数需要配合useAffectedRows=true
     * @param datas
     * @param andWheres
     * @return
     */
    @UpdateProvider(type = WODispatchCmdBatchItemSqlProvider.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);

    @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.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);

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

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