package com.steerinfo.dil.mapper;

import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.mapstruct.Mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

/**
 * 通用接口
 * @ author    :TXF
 * @ time      :2021/10/19 18:03
 */

@Mapper
public interface UniversalMapper {

    List<Map<String, Object>> getCompanyMesByLike(Map<String, Object> map);

    List<Map<String, Object>> getCompanyMesByPlanLike(Map<String, Object> map);

    List<Map<String, Object>> getMaterialTypeByLike(Map<String, Object> map);
    List<Map<String, Object>> getMaterialByLike(Map<String, Object> map);

    List<Map<String, Object>> getCapacityTypeByLike(Map<String, Object> map);


    List<Map<String, Object>> getEmissionStandardByLike(Map<String, Object> map);

    List<Map<String, Object>> getOperationPointByLike(Map<String, Object> map);

    List<Map<String, Object>> getCategoryCodeByLike(Map<String, Object> map);


    List<Map<String, Object>> getPersonnelByLike(Map<String, Object> map);

    List<Map<String, Object>> getCapacityByLike(Map<String, Object> map);
    List<Map<String, Object>> getCapacityByLikeSc(Map<String, Object> map);

    List<Map<String, Object>> getTransRangeByLike(Map<String, Object> map);
    List<Map<String, Object>> getLineByLike(Map<String, Object> map);
    List<Map<String, Object>> getrmsrmsjobinfosBylike(Map<String, Object> map);


    List<String> getColumnNoRoutList(Map<String, Object> map);

    List<String> getColumnHiddenData(Map<String, Object> map);

    List<Map<String, Object>> getColumnShowData(Map<String, Object> map);

    List<Map<String, Object>> getColumnAllData(Map<String, Object> map);

    List<Map<String, Object>> getColumnAllScheme(Map<String, Object> map);

    String getWlUrl();

    //查询采购火运重复装车数量
    int countTrainLoad(Map<String, Object> map);

    //查询采购火运对应运单及计量实绩
    List<Map<String, Object>>  findTrainWeight(Map<String, Object> map);

    //查询采购火运对应运单及卸货实绩
    List<Map<String, Object>>  findTrainUnload(Map<String, Object> map);

    //查询火运计划下的运单数量
    int countTransOrder(Map<String, Object> map);

    List<Map<String, Object>> getBusinessTypeLike(Map<String, Object> map);

    List<Map<String, Object>> getFuelTypeByLike(Map<String, Object> map);

    List<Map<String, Object>> getOrderIds(Map<String, Object> map);

    List<Map<String, Object>> getDemandRulesCode(Map<String, Object> map);

    String getIdCardCode(Map<String, Object> map);

    List<Map<String, Object>> getMaterial(Map<String, Object> map);


    //获取车型剩余的空闲车辆和已经派车的数量
    List<Map<String, Object>> getcountCar(Map<String, Object> map);

    List<Map<String, Object>> getContainerList(Map<String,Object> map);

    String getRequirementNo(Map<String, Object> map);

    @Select("select seq_AMS_TRANS_REQUIREMENT.nextval from dual")
    @Options(flushCache = Options.FlushCachePolicy.TRUE)
    BigDecimal transRequirementId();

    List<Map<String, Object>> getDriverByLike(Map<String, Object> map);

    Map<String,Object> getConfigByName(String configName);
}