DIL-DAZHOU-WMS2/src/main/java/com/steerinfo/dil/mapper/WmspOutboundResultMapper.java

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.WmspOutboundResult;
import com.steerinfo.dil.vo.OutBoundMaterialDetailedInfo;
import com.steerinfo.framework.mapper.IBaseMapper;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

@Mapper
public interface WmspOutboundResultMapper extends IBaseMapper<WmspOutboundResult, BigDecimal> {
    /**
     * 查询出库实绩
     */
    List<Map<String, Object>> selectResultNumber (Map<String, Object> map);
    /**
     * 根据运输订单号查询订单主键id
     * @return
     */
    Map<String, Object> getOrder (String orderNumber);
    /**
     * 根据运输订单主键id查询出库单详情
     */
    List<Map<String, Object>> getwmspOutboundResultdetails (Integer orderId);
    /**
     * 根据运输订单主键id查询出库单数量
     */
    int getcountOrderNumber (Integer orderId);
    /**
     * 根据出库单id查询物资编码
     */
    String getmaterialCode(Integer resultId);
    //根据运输订单号查找物资信息
    @MapKey("")
    List<Map<String, Object>> selectOutbountResultByOrderNumber(String orderNumber);
    //通过装卸工工号查询装卸工名称
    String getPersonnelNameByJobnumber(String personnelJobNumber);
    /**
     * 根据运输订单id查询还没装货的物资id
     */
    List<Map<String,Object>> getMaterial(Integer orderId);
    //根据运输订单ID和物资id查询出库单(没有逻辑删除）
    int ExistWmspOutboundResult(Map<String, Object> map);
    //返回出库单详情信息
    Map<String,Object> getOutBoundDetailedInfo(BigDecimal orderId);
    //通过出库单号查询出库实绩ID
    BigDecimal getOutBoundId(String resultNumber);
    //通过装卸工工号查询装卸工Id
    BigDecimal getPersonnelIdByJobnumber(String personnelJobNumber);
    //根据扫描结果查询扫描实绩是否存在
    int ExistScanResult(String resultMaterial);
    //通过物资物资唯一编码查询钢材物资表的物资Id
    BigDecimal getSteelMaterialIdByMaterialOnlyCode(String MaterialOnlyCode);
    //通过出库实绩Id查询物资Id
    BigDecimal getOutboundMaterialByResultId(BigDecimal resultId);
    //获取月台Id
    BigDecimal getPlatformIdByResultId(BigDecimal resultId);
    //通过月台Id获取仓库名称
    String getWarehouseNameByPlatformId(BigDecimal platformId);
    //获取出库单统一信息
    Map<String,Object> theSameOutboundInfo(BigDecimal resultId);
    //返回已扫描并并稽核成功的物资信息
    List<Map<String,Object>> scanAuditSuccessInfo(BigDecimal resultId);
    //通过唯一编码获取物资名称、计量单位、垛位
    Map<String,Object> getOtherInfoByMaterialOnlyCode(String MaterialOnlyCode1);

    // 得到出库物资
    List<Map<String, Object>> getScanMaterialNumber(BigDecimal resultId);
    // 得到运单中间表的物资件数
    List<Map<String, Object>> getOunboundOrderNumber(BigDecimal resultId);
    // 修改网格为已删除
    int updateGrid(BigDecimal materialId);
//    根据orderId获得当前运输订单的状态
    int getOutboundStatus(BigDecimal orderId);

    int updateStatus(BigDecimal resultId);

    List<Map<String, Object>> selectOutResult(Map<String, Object> mapval);

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

    Map<String, Object> getOutboundMesByMateAndResultId(@Param("resultId") BigDecimal resultId, @Param("materialId")BigDecimal materialId);

    //通过钢材物资ID查询仓库Id
    Integer getWarehouseIdBySteelMaterialId(BigDecimal steelMaterialId);

    //通过出库物资中间表ID和物资ID查询炉号和物资件数
    List<Map<String, Object>> getLuHaoAndNumber(@Param("resultMaterialId") BigDecimal resultMaterialId, @Param("materialId") BigDecimal materialId);

    Map<String, Object> getIsOutBound(Map<String,Object>mapVal);

    int getOutBoundingNum(BigDecimal orderId);

    int updateMaterialStatus(BigDecimal resultMaterialId);

    BigDecimal getLoadId(Map<String, Object> mapVal);

    BigDecimal getSteelOrderType(BigDecimal orderId);

    //根据出库实绩id查询出库扫码实绩信息
    List<OutBoundMaterialDetailedInfo>  getOutBoundMaterialDetailedInfo(@Param("resultId") BigDecimal resultId);

    /**
     * @author:zyf
     * @version:1.0
     * @Date:
     * @Description:计算出理重总和
    */
    BigDecimal calculateTW(BigDecimal resultMaterialId,BigDecimal materialId);

    /**
     * @author:zyf
     * @version:1.0
     * @Date:
     * @Description:查出总实绩ID
    */
    BigDecimal queryID(BigDecimal orderId);
}