DAI_DAZHOU-OMS/src/main/java/com/steerinfo/dil/mapper/OmstruckOrderMaterialMapper.java

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.OmstruckOrder;
import com.steerinfo.dil.model.OmstruckOrderMaterial;
import com.steerinfo.framework.mapper.IBaseMapper;
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 OmstruckOrderMaterialMapper extends IBaseMapper<OmstruckOrderMaterial, BigDecimal> {
    //新增运单子表
    int insertSelective(OmstruckOrderMaterial omstruckOrderMaterial);

    //修改运输订单子表
    int updateByPrimaryKeySelective(OmstruckOrder omstruckOrder);

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

    //通过订单Id
    BigDecimal getOrderMaterialIdByOrderId(BigDecimal orderId);

    //通过订单id或者订单号查询订单子表物资ID
    List<Map<String, Object>> getUnloadOrderMaterial(Map<String, Object> map);

    //通过订单主键 查询所有物资子表信息 (仅限单拼)
    OmstruckOrderMaterial selectByOrderIdPrimaryKey(BigDecimal orderId);

    //批量删除物资子表
    Integer batchByOrderIdDelete(List<BigDecimal> list);

    //批量删除总实绩表
    Integer batchByOrderIdForTotalDelete(List<BigDecimal> list);

    //根据订单ID查询订单物资ID
    List<Map<String, Object>> getOrderMaterial(Integer orderId);

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

    //通过车牌号获取钢材订单ID
    List<Map<String, Object>> getSteelOrderNumByCapacityNumber(BigDecimal capacityId);

    //修改订单物资子表
    int updateMaterialMes(OmstruckOrderMaterial omstruckOrderMaterial);

    //修改出库实绩
    int updateOutBoundResult(OmstruckOrderMaterial omstruckOrderMaterial);

    //修改出库实绩
    Map<String, Object> getSaleOrderMaterialNum(@Param("orderId")BigDecimal orderId,@Param("materialId") BigDecimal materialId);


    int updateSaleOrderMaterialMes(BigDecimal saleMaterialId, BigDecimal materialNum, BigDecimal newWeight);
}