package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.TmstruckWeightResult;
import com.steerinfo.framework.mapper.IBaseMapper;
import java.math.*;
import java.util.List;
import java.util.Map;

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

@Mapper
public interface TmstruckWeightResultMapper extends IBaseMapper<TmstruckWeightResult, BigDecimal> {

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

    // 得到计重实绩主键id
    BigDecimal getWeightTaskResultId(Map<String,Object>mapValue);

    // 得到汽车衡id
    BigDecimal getTruckCalculateId(String resultCalculateNumber);

    List<Map<String,Object>> selectWzInputId();

    int updateWzInputId(BigDecimal wzInputId);

    BigDecimal getWeightTaskResultId(String orderNumber);

    Integer updateTruckWeightResult(Map<String, Object> mapValue);

    Integer updateTruckWeightResultGross(Map<String, Object> mapValue);

    //通过运输订单号 查询实绩Id、总实绩ID
    Map<String, Object> selectTotalIdByOrderNo(Map<String, Object> map);

    //通过运输订单号 和物资ID 查询实绩ID
    Map<String, Object> selectResultIdByOrderNoAndMaterialId(Map<String, Object> map);

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

    //通过运输订单号查询计量实绩Id 条件 路段顺序号 和 净重
    Map<String, Object> selectWeightIdByOrderId(Map<String, Object> map);

    //通过订单Id查询还没有净重的计量实绩
    Integer selectNoNetWeightResult(String orderNumber);

    //查询采购订单信息
    Map<String, Object> getPurOrderMesToKD(String orderNumber);

    //查询采购内转总厂到老区的订单信息
    Map<String, Object> get20PurOrderMesToKD(String orderNumber);


    int linkageDeleteTransportOrder(@Param("orderNumber") String orderNumber);

    //钢材查询下一个未计量的实绩
    List<Map<String, Object>> getNoNetWeightResultId(BigDecimal resultTotalId);

    //销售退货查询下一个未计量的实绩
     List<Map<String,Object>> getNoNetWeightResultForSaleReturn(BigDecimal resultTotalId);

     //查询是否为多拼
    List<Map<String,Object>> getMaterialNumber(BigDecimal resultTotalId);

    //通过采购订单号查询采购订单ID  和物资ID
    Map<String, Object> getAPOMes(String arrivalBillNo);

    //修改普通采购运输订单实绩关联的采购订单ID
    int updateOmsTruckPlanId(Map<String, Object> mesMap);

    //修改运输订单子表物资ID
    int updateOmsTruckMaterialId(Map<String, Object> mesMap);

    //修改采购内转的运输订单需求中关联的采购订单Id
    int updatePurchaseInwordAPOId(Map<String, Object> mesMap);

    List<Map<String, Object>> getShipQualityResult(Map<String,Object> map);
}