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

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.TmstruckMeasureCommission;
import com.steerinfo.framework.mapper.IBaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

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

@Mapper
public interface TmstruckMeasureCommissionMapper extends IBaseMapper<TmstruckMeasureCommission, BigDecimal> {

    //查询计量委托
    List<Map<String, Object>> getMeasureCommission(Map<String, Object> map);

    //查询最大主键Id
    @Select("select seq_measure_commission.nextval from dual")
    BigDecimal selectMaxId();

    //查询采购计量委托
    Map<String, Object> getCGMeasureCommission(Map<String, Object> map);

    //查询销售计量委托
    Map<String, Object> getXSMeasureCommission(Map<String, Object> map);

    //通过总实绩ID查询没有净重的计量实绩
    Integer selectNoNetWeightResult(BigDecimal resultTotalId);

    //通过订单ID查询组织对单位ID
    Integer getReceiveIdByOrderId(BigDecimal orderId);

    //通过订单ID查询发货单位ID
    Integer getShipperIdByOrderId(BigDecimal orderId);

    //销售查询计毛
    Map<String, Object> selectMakesureGrossForSaleByOrderNumber(Map<String, Object> map);

    //销售查询计皮
    Map<String, Object> selectMakesureTareForSaleByOrderNumber(Map<String, Object> map);

    //内转查询计皮
    Map<String, Object> selectMakesureTareForConvertedByOrderNumber(Map<String, Object> map);

    //内转查询计毛
    Map<String, Object> selectMakesureGrossForConvertedByOrderNumber(Map<String, Object> map);

    //采购查询计皮
    Map<String, Object> selectMakesureGrossForPurchase(Map<String, Object> map);

    //采购查询计毛
    Map<String, Object> selectMakesureTareForPurchase(Map<String, Object> map);

    //采购计量委托
    Map<String, Object> purchaseMeasure(Map<String, Object> map);

    //采购计量委托（达兴）
    Map<String, Object> purchaseDXMeasure(Map<String, Object> map);

    //销售计量委托
    Map<String, Object> saleMeasure(Map<String, Object> map);

    //销售计量委托（达兴）
    Map<String, Object> saleDXMeasure(Map<String, Object> map);

    //零星物资进厂计量委托
    Map<String, Object> sporadicDXMeasure(Map<String, Object> map);

    //零星计量委托(老厂区)
    Map<String,Object> sproadicMeasure(Map<String,Object> map);

    //内转计量委托(老厂区)
    Map<String,Object> purchaseXqCgNzMeasure(Map<String,Object> map);

    //内转
    Integer getReceiveIdByRequirementOrderId(Object orderId);

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

    //通过订单ID获取零星订单父级收货单位
    Integer getLxRealReceiveIdByOrderId(BigDecimal orderId);

    //通过订单ID获取零星订单父级发货单位
    Integer getLxRealSendUnitIdByOrderId(BigDecimal orderId);

    //查询零星订单收货单位ID
    Integer getPtLxReceiveIdByOrderId(BigDecimal orderId);

    //查询零星订单发货单位ID
    Integer getPtLxSendUnitIdByOrderId(BigDecimal orderId);
}