DAI_DAZHOU-OMS/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.Param;
import org.apache.ibatis.annotations.Select;

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

@Mapper
public interface OmstruckOrderMapper extends IBaseMapper<OmstruckOrder, BigDecimal> {
    //根据销售订单id查找销售订单信息
    List<Map<String, Object>> selectSaleNumberForCarrier(Integer saleOrderId);

    //查询已接收的焦炭发运计划
    List<Map<String, Object>> selectCokeDayPlanAndRecived(Map<String, Object> map);

    //查询已接收的水渣发运计划
    List<Map<String, Object>> selectWaterSlagDayPlanAndRecived(Integer carrierId);

    //查询所有运输订单信息 状态：3
    //查询所有已下发运输订单 状态：4
    List<Map<String, Object>> getAllTruckOrder(Map<String, Object> map);

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

    //通过运输订单Id查询运输订单号
    String getOrderNumberByOrderId(Integer orderId);

    //通过运输订单号查询运输订单ID
    Integer getOrderIdByOrderNumber(String orderNumber);

    //查询所有运力信息
    List<Map<String, Object>> getAllCapacity(Map<String, Object> map);

    //通过运力Id 或 车牌号 修改运输状态
    int updateCapacityByCarIdOrNum(Map<String, Object> map);

    int updateCapacityById(Map<String, Object> map);

    //通过运输订单ID 或 运输订单号 查询运力Id
    BigDecimal getCapacityIdByOrderOrNum(Map<String, Object> map);

    //通过ID获取派单时间
    Date getInsertTimeById(Integer orderId);

    //通过车牌号查询运力id
    BigDecimal getCapacityIdByCapacityNum(String capacityNumber);

    //司机接单调用接口 通过运力Id匹配  /  通过运单ID查询运单信息 APP
    //查询所有接单或拒绝接单的订单 PC -- 采购
    List<Map<String, Object>>   getTruckOrderByCapacityNum(Map<String, Object> map);

    //查询所有接单或拒绝接单的订单 PC -- 销售
    List<Map<String, Object>> getSaleTruckOrderByCapacityNum(Map<String, Object> map);

    //查询司机所有已拒绝过的订单
    List<Map<String, Object>> getReceiveRefuseOrderByCapacityId(Map<String, Object> map);

    //  通过运输订单号或运输订单ID查询总实绩ID和订单类型
    Map<String, Object> getResultTotalIdByOrderNumAndId(Map<String, Object> map);

    // 通过运输订单Id查询运输订单子表有几种物资 ：物资ID
    List<Integer> getMaterialIdListByOrderId(Integer orderId);

    // 查询实绩地点和时间
    List<Map<String, Object>> selectPlaceAndTime(BigDecimal orderId);

    //通过运单号查询运单信息
    List<Map<String, Object>> getOrderByOrderId(BigDecimal orderId);

    //通过运输订单号查询预设路径的作业点ID  及 总实绩ID
    Map<String, Object> getPointIdByOrderNum(Map<String, Object> map);

    //运输派单
    List<Map<String, Object>> getTransportDispatch(Map<String, Object> map);

    //查询已下发未接受的销售订单信息
    List<Map<String, Object>> getOrderUnReceive(BigDecimal orderType);

    //查询已下发已接受的销售订单信息
    List<Map<String, Object>> getOrderReceived(BigDecimal orderType);

    //通过销售订单物资ID查找物资理重和物资件数
    Map<String, Object> selectTheoreticalWeightAndMaterialNumber(Integer saleOrderMaterialId);

    //销售物流：展示已经形成订单的水渣发运计划
    List<Map<String, Object>> selectWaterSlagForOrder(Map<String, Object> map);

    //销售物流：展示已经形成订单的焦炭发运计划
    List<Map<String, Object>> selectCokeRailPlanForOrder(Map<String, Object> map);

    //通过车序号表id查找物资id
    List<Map<String, Object>> selectMaterialIdBysaleOrderMaterialId(Integer saleOrderMaterialId);

    //查找司机排班表信息
    List<Map<String, Object>> selectCapacityAndDriver(Map<String, Object> map);

    //通过用户id查找用户姓名
    String selectPersonNameByPersonnelId(Integer personnelId);

    //通过车牌号、承运商匹配最新的运力id
    BigDecimal selectCapacityId(BigDecimal carrierId, String capacityNumber);

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

    //通过物资id查询批次表匹配最新的批次，关联最新的采购订单号
    Map<String, Object> selectNewOrderId(Map<String, Object> map);

    //查询所有的收货单位
    List<Map<String, Object>> getReceivingUnit();

    //查询所有的发货单位
    List<Map<String, Object>> getSupplier();

    //通过采购订单号查找采购订单ID
    BigDecimal getPurchaseOrderIdByNo(String purchaseOrderNo);


    //App
    //查询主干信息
    Map<String, Object> getSaleTruckOrderByCapacityId(Map<String, Object> map);

    //查询物资信息
    List<Map<String, Object>> getSaleTruckOrderByCapacityNumMaterial(Map<String, Object> map);

    //根据发运计划id查找物资id
    Map<String, Object> selectMaterialIdAndWeightByDayPlanId(Integer dayPlanId);

    //销售模块，查看所有订单
    List<Map<String, Object>> selectAllOrderForSale(Map<String, Object> map);

    //根据车序号id查找销售订单
    List<Map<String, Object>> selectSaleBySaleOrderMaterialId(Integer saleOrderMaterialId);


    //销售：接收运输订单展示pc端界面
    List<Map<String, Object>> selectTransportOrderForSale(Map<String, Object> map);

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

    //销售：根据承运商查找承运商
    List<Map<String, Object>> selectSaleMaterialIdByCarrierId(Integer carrierId);

    //根据承运商查找销售订单
    List<Map<String, Object>> selectSteelSaleForCarrier(Map<String, Object> map);

    //根据销售订单id查找信息
    List<Map<String, Object>> selectInfoBySaleOrderId(Integer saleOrderId);

    //根据承运商查找发运计划
    List<Map<String, Object>> selectCokeRailPlan(Map<String, Object> map);

    //根据发运计划查找信息
    List<Map<String, Object>> selectInfoByDayPlanId(Map<String, Object> map);

    // 车牌号下拉
    List<Map<String, Object>> getDriverCapacity();

    // 派单信息
    Map<String, Object> getTruckNoDispatchMap(BigDecimal dispatchId);

    // 物资信息
    List<Map<String, Object>> getMaterialMessages(BigDecimal dispatchId);

    // 得到销售订单与物资中间表id
    BigDecimal getSaleMaterialId(BigDecimal dispatchId);

    // 根据车牌号查询运力id
    BigDecimal getCapacityId(String capacityNumber);

    // 根据运力id查询司机排班id
    BigDecimal getDriverCapacityId(BigDecimal capacityId);

    List<Map<String,Object>> getCapacityAndDriver(Map<String,Object> mapValue);

    List<BigDecimal> getNullOrNotNull(BigDecimal dispatchId);

    BigDecimal getInwardMaterial(BigDecimal planId);

    List<Map<String, Object>> getInwardOrderList(Map<String, Object> mapValue);

    List<Map<String, Object>> getResultList(BigDecimal driverCapacityId);

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

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

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

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

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

    //通过订单Id查询该订单下所有的物资
    List<Map<String,Object>> getMaterialMes(@Param("orderId") BigDecimal orderId, @Param("steelJudge") String steelJudge);

    //通过订单Id查询该订单下所有的物资
    List<Map<String,Object>> getMaterialMesForGrossWeight(BigDecimal orderId, String steelJudge);

    //通过订单Id查询该订单下所有的物资
    List<Map<String,Object>> getMaterialMesNew(@Param("orderId") BigDecimal orderId, @Param("steelJudge") String steelJudge);

    //根据运输订单查询车牌号
    String selectCapacityNumber(BigDecimal orderId);

    //根据运输订单查询运输状态
    BigDecimal selectOrderType(BigDecimal orderId);

    BigDecimal selectOrderId(BigDecimal dcId);

    //查询采购订单数据 给司机
    Map<String, Object> getCGOrderMessageToApp(Map<String, Object> map);

    //查询内转运输订单给APP 9 10 11
    Map<String, Object> getNZOrderMessageToApp(Map<String, Object> map);

    //查询采购零星物资订单给app 12 13 14
    Map<String,Object>  getSporadicOrder(Map<String, Object> map);

    //查询发运计划运输订单给APP  2 3 4
    Map<String, Object> getFYJHOrderMessageToApp(Map<String, Object> map);

    //查询销售运输订单给APP 1
    Map<String, Object> getXSOrderMessageToApp(Map<String, Object> map);


    //通过运输订单号查询运输订单类型
    Integer getOrderTypeByOrderNumber(@Param("orderId") BigDecimal orderId);

    //通过车牌号查询该车牌下所有已下发 未接收 的 订单Id （4）
    List<Map<String, Object>> getOrderIdListByCapacityNumber(String capacityNumber);

    //通过车牌号查询该车牌下所有已接收的订单ID （5）
    List<Integer> getReceiveOrderIdListByCapacityNum(String capacityNumber);

    //通过车牌号查询运输订单号和运输订单ID
    List<Map<String, Object>> getAllRefuseOrderNumberByCapacity(String capacityNumber);

    //通过运输订单Id或运输订单号查询订单类型
    Integer getOrderTypeByOrderId(BigDecimal orderId);

    // 销售中的运输订单
    Map<String, Object> getSaleMap(BigDecimal orderId);

    // 内转钢材的运输订单
    Map<String, Object> getSteelInwardMap(BigDecimal orderId);

    // 采购的运输订单
    Map<String, Object> getPurchaseMap(BigDecimal orderId);

    // 内转的运输订单
    Map<String, Object> getInwardMap(BigDecimal orderId);

    // 判断是走采购，销售还是内转
    List<Map<String, Object>> getResultListByCapacity(String capacityNumber);

    // 通过卸货点名称查询卸货点id
    BigDecimal getUnloadPointId(String unloadPoint);

    // 通过ssoId查询承运商id
    BigDecimal getCarrierIdBySSO(String carrierSsoId);

    List<Map<String, Object>> getOrderMaterialList(BigDecimal orderId);

    //通过订单查询趟次
    Map<String,Object> getSporadicOrderTimes(BigDecimal orderId);



    //根据运输订单id查找所有实绩id
    List<Map<String,Object>> getAllResultId(BigDecimal orderId);

    //查询订单是否确认
    Integer getDriverConfirmation(BigDecimal orderId);

    //查看当前订单最大路段顺序号 与当前订单路段顺序号
    Map<String, Object> getMaxLineSeqByOrderId(BigDecimal orderId);

    //查看配置表的相关信息
    String getDilVersion();

    //查询运输订单的送货单打印信息
    BigDecimal getPrintNumber(BigDecimal orderId);

    //通过订单id查询零星订单id，运力id
    Map<String, Object> getSporadicOrdermapAddOrder(BigDecimal orderId);

    //判断是否是钢材
    BigDecimal getIsSteel(BigDecimal lineId);

    //通过定向派单ID查询车序号表中的priceId
    BigDecimal getPriceIdByDispatchId(BigDecimal dispatchId);
//
//    //通过订单查询趟次
//    Integer getSporadicOrderTimes(BigDecimal orderId);
   //删除计重实绩
   int deleteWeightResult(BigDecimal resultTotalId);

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

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

   //删除卸货实绩
   int deleteUnloadResult(BigDecimal resultTotalId);

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

   //判断计时实绩是否已经存在
    int getTimeTaskByTotalId(BigDecimal resultTotalId);

   List<Map<String, Object>> getPurInwardOrderList(Map<String, Object> mapValue);

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

    int refuseCtrlZ(Map<String, Object> map);

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

    //计时订单
    Map<String, Object> getInwardTimeOrderMessageToApp(Map<String, Object> map) throws Exception ;
    //根据运输订单号查找需要用车时长
    Map<String,Object>  selectInwardTimeByOrderId(BigDecimal orderId);

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

    List<Map<String, Object>> getPauseTimeTaskDetail(Integer orderId);

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

     //删除计时实绩
    int deleteTimeTaskByTotalId(BigDecimal resultTotalId);

    int closeTruckOrder(BigDecimal orderId);

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

    List<Map<String, Object>> getLoadForLoadCarResult(Map<String, Object> map);
    // 查询路段顺序号
    BigDecimal getLineSeq(BigDecimal orderId);

    String getCapacityNumberByCapacityId(BigDecimal capacityNumber);

    //销售：接收运输订单展示pc端界面
    List<Map<String, Object>> getDriverInfoForSale2(Map<String, Object> map);

    List<Map<String, Object>> getTransportOrder(Map<String, Object> mapValue);

    //判断是否为达钢厂区内转
    Map<String,Object> isInwardLine(BigDecimal orderId);

    // 通过运单id或者运单号查询车辆是否放行
    String canCapacityEnfactory(Map<String, Object> mapValue);

    // 出库信息
    List<Map<String, Object>> getWarehouseMes(Map<String, Object> mapValue);

    // 通过运单下的物资信息
    int closeInwardOrderByPlan(BigDecimal bigDecimal);

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

    //查询内转多拼
    Map<String, Object> getMulInwardOrderMessageToApp(Map<String, Object> map);

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

    //查询出订单的钢材长度
    List<Map<String,Object>> getMaterialId(BigDecimal orderId);


    int getGoBeyondCount(Object orderId);

    int getMaterialNumByOrderId(BigDecimal orderId);

    int deleteQueueList(BigDecimal capacityId);

    int deleteQueueResult(BigDecimal resultTotalId);

    int deleteQueueSpellList(BigDecimal capacityId);

    Date getOrderPrintDate(BigDecimal orderId);

    String getPrintFlag();

    List<Map<String, Object>> materialMesNewContinue(BigDecimal orderId, String steelJudge);

    List<BigDecimal> selectContinueOrderId(BigDecimal orderId);

    int updateTotalResultNull(BigDecimal resultTotalId);

    int clsoePlanByPlan(BigDecimal bigDecimal);

    Date selectCapacityTimesTwoDay(String capacityNumber);

    int selectOutFactoryTimes(String capacityNumber, Date enFactoryTime);

    int updateEnFactoryResultRemark(BigDecimal resultTotalId);

    String getFactoryFlag();

    String selectLineName(BigDecimal lineId);

    int updateResultTotalId(Integer resultTotalId);

    int selectNetWeightByOrderId(Integer orderContinueId);

    int selectSaleMaterialNum(BigDecimal orderId);

    int selectOutFactory(BigDecimal orderId);

    int updateOrderStatus(@Param("orderContinueId") Integer orderContinueId, @Param("orderStatus") int orderStatus);

}