DAL-TMS-TRUCK-API/src/main/java/com/steerinfo/dil/mapper/TmstruckWeightResultMapper.java

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.TmstruckWeightResult;
import com.steerinfo.framework.mapper.IBaseMapper;
import io.swagger.models.auth.In;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

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

@Mapper
public interface TmstruckWeightResultMapper extends IBaseMapper<TmstruckWeightResult, Short> {
    //查询最大主键Id
    @Select("select seq_tmstruck_weight_result.nextval from dual")
    BigDecimal selectMaxId();

    //通过订单Id 查询路段顺序号为最小的 且没有净重的计量实绩ID
    BigDecimal getWeightIdBySQEAndOrderId(Map<String, Object> map);

    //通过运输订单号和查询订单Id 和物资ID (针对单拼)
    Map<String, Object> getOrderIdAndMaterialIdByOrderNum(String orderNumber);

    //通过物资名称和规格型号查询物资Id
    Integer getMaterialIdByMaterialNameAndSpe(Map<String, Object> map);

    //通过订单号查询计重实绩数据
    Map<String, Object> selectTotalIdByOrderNo(Map<String, Object> map);

    //通过汽车衡编号查询汽车衡ID
    Integer selectTruckCalculateId(String truckCalculateNumber);

    //查询采购所有计毛实绩
    List<Map<String, Object>> getCGAllJiMaoResult(Map<String, Object> map);

    //查询销售计毛实绩
    List<Map<String, Object>> getXSAllJiMaoResult(Map<String, Object> map);

    //查询采购所有计皮实绩
    List<Map<String, Object>> getCGAllJiPiResult(Map<String, Object> map);

    //查询销售所有计皮实绩
    List<Map<String, Object>> getXSAllJiPiResult(Map<String, Object> map);

    //查询内转到钢材到异地库计皮实绩
    List<Map<String, Object>> getSteelNzJiPiResult(Map<String, Object> map);

    //查询内转钢材到异地库计毛实绩
    List<Map<String, Object>> getSteelNzJiMaoResult(Map<String, Object> map);

    //查询国产矿进口矿计毛实绩
    List<Map<String, Object>> getImportedDomesticNzJiMaoResult(Map<String, Object> map);

    //查询国产矿进口矿计皮实绩
    List<Map<String, Object>> getImportedDomesticNzJiPiResult(Map<String, Object> map);

    //查询国产矿进口矿计皮实绩(老区-厂内)
    List<Map<String, Object>> getImportedDomesticNzJiPi2Result(Map<String, Object> map);

    //查询国产矿进口矿计毛实绩(老区-厂内)
    List<Map<String, Object>> getImportedDomesticNzJiMao2Result(Map<String, Object> map);

    //查询内转厂内物资计量实绩
    List<Map<String, Object>> getInFactoryJiLiangResult(Map<String, Object> map);

    //查询订单下所有的物资件数和物资理重
    List<Map<String, Object>> getMaterialMes(Integer orderId);

    //通过运输订单id获取路段顺序号、物资类型、计量实绩主键、line_id
    Map<String, BigDecimal> selectByOrderId(BigDecimal orderId);

    //零星物资根据运输订单Id获取计毛实绩
    List<Map<String, Object>> getFactorySkinSporadicJiMiao(Map<String, Object> map);

    //零星物资根据运输订单Id获取计皮实绩
    List<Map<String, Object>> getFactorySkinSporadicJIPi(Map<String, Object> map);

    //根据运输订单Id获取计皮实绩
    List<Map<String, Object>> getSporadicSuppliesJiPiResult(Map<String, Object> map);

     //根据运输订单Id获取计毛实绩
    List<Map<String, Object>> getSporadicSuppliesJiMiaoResult(Map<String, Object> map);

//    BigDecimal getXqCgWeightIdByLineAndOrderId(Map<String, Object> map);

    //通过总实绩ID查询订单类型
    Integer getOrderTypeByTotalId(BigDecimal resultTotalId);


}