DAL-DAZHOU-AMS-API/src/main/java/com/steerinfo/dil/mapper/OmstruckOrderMapper.java

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.OmstruckOrder;
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 OmstruckOrderMapper extends IBaseMapper<OmstruckOrder, BigDecimal> {

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

    //通过运输订单ID查询数据 用于websocket推送数据
    Map<String, Object> pushMesToWebsocket(Map<String, Object> map);

    int selectOrderTypeByOrderId(BigDecimal orderId);
    // 通过详细地址得到单价
    BigDecimal getPriceId(Map<String,Object> priceMap);

    BigDecimal findMaxPrice(Object addressId);

    List<Map<String, Object>> findMaxPriceId(Map<String, Object> priceMap);

    String findCarNumberByOrderId(BigDecimal orderId);

    int deleteWeightResult(BigDecimal resultTotalId);

    //删除装货实绩
    int deleteLoadResult(BigDecimal resultTotalId);

    //删除出厂实绩
    int deleteLeaveResult(BigDecimal resultTotalId);

    //删除进厂实绩
    int deleteEnResult(BigDecimal resultTotalId);

    BigDecimal getOldCapacityId(BigDecimal orderId);

    //查询车牌号的电话
    String getTelByCapacityId(BigDecimal capacityId);

    //选择运力的车牌号
    BigDecimal getCapacityTel(String capacityNo);

    int deleteSpellingList(Object listId);

    //删除排队实绩
    int deleteQueuingPerformance(BigDecimal resultTotalId);

    int deleteQueueList(Object listId);

    Map<String, Object> getSteelIsSpelling(BigDecimal orderId);

    int getResultCount(BigDecimal orderId);

    Integer getOrderStatus(BigDecimal orderId);

    int getOrderMaterialNum(BigDecimal orderId);

    int getWeightResultNum(BigDecimal orderId);

    int selectNetWeightCount(BigDecimal orderId);

    List<BigDecimal> getOrderIdsBySale(BigDecimal toSplitSaleOrderMaterialID);

    String getOrderCapacityHistory(BigDecimal orderId);

    int selectOutFactory(BigDecimal orderId);

    String getOldCapacityNumber(BigDecimal oldCapacityId);

    int updateOrderStatus(BigDecimal previousOrderId);

    int selectSaleMaterialNum(BigDecimal orderId);

    BigDecimal getOrderType(BigDecimal orderId);

    int updateTotalOrderStatus(BigDecimal resultTotalId);

    String getAddressPlace(BigDecimal orderId);

}