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

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.WmspInboundScanResult;
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 WmspInboundScanResultMapper extends IBaseMapper<WmspInboundScanResult, BigDecimal> {
    /**
     * 1.获取最大ID
     * @return
     */
    @Select("select Seq_wmsp_inbound_scan_result.nextval from dual")
    BigDecimal getCount();

    BigDecimal getScanNumber(Map<String,Object> map);

    /**
     * 展示未下发未入库实绩
     * @param map
     * @return
     */
    List<Map<String, Object>> selectScanTagResult(Map<String, Object> map);

    /**
     * 更新异常值
     * @param
     * @return
     */
    int updateInboundAbnormal(Map<String,Object> map);

    List<WmspInboundScanResult> selectRepeat(WmspInboundScanResult wmspInboundScanResult);

    /**
     * 展示正常入库实绩
     * @param map
     * @return
     */
    List<Map<String, Object>> selectIssuedScanTagResult(Map<String, Object> map);

    /**
     * 判断是否重复插入
     * @param map
     * @return
     */
    List<Map<String, Object>> checkScanResult(Map<String,Object> map);

    /**
     * 获取异常入库
     * @param map
     * @return
     */
    List<Map<String, Object>> selectIssuedScanTagNoResult(Map<String, Object> map);


    /**
     * 更新入库扫描吊牌实绩
     * @param map
     * @return
     */
    Integer updateInboundScanResult(Map<String, Object> map);

    Integer updateReboundScanResult(Map<String, Object> map);


    /**
     * 获取退库已下发吊牌实绩
     * @param map
     * @return
     */
    List<Map<String, Object>> selectReIssuedScanResult(Map<String, Object> map);

    /*
    获取退库未下发扫描吊牌实绩
     */
    List<Map<String, Object>> selectReScanTagResult(Map<String, Object> map);

    /**
     * 获取倒库入库已下发吊牌实绩
     * @param map
     * @return
     */
    List<Map<String, Object>> selectIvIssuedScanResult(Map<String, Object> map);

    /*
    获取倒库入库未下发扫描吊牌实绩
     */
    List<Map<String, Object>> selectIvScanTagResult(Map<String, Object> map);

    //获取id
    BigDecimal getLoadId(Map<String, Object> map);

     //获取扫描实绩
    List<Map<String, Object>> getScanResult(BigDecimal loadId);

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

    //返回信息
    List<Map<String,Object>> getReScanresult(BigDecimal loadId);

    BigDecimal getOtherLoadId(Map<String, Object> map);

    Integer getOtherMaterialSteelId(Map<String, Object> map);

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

    Integer updataStatus(Map<String, Object> map);
    //判断物资是否为线材
    BigDecimal selectMaterialTypeByMaterialId(BigDecimal materialId);
    //判断是否已经被扫过了
    int isExist(@Param("userName") String userId, @Param("resultMaterial")String resultMaterial);
    //查询被扫描没有下发的物质
    List<Map<String, Object>> noIssueScanResult(String userId);

    BigDecimal getScanedNumber(String userId);

    List<Map<String, Object>> noIssueScanResultList(String userName);

    int updataStatusByResultId(BigDecimal resultId ,BigDecimal inboundId);

    Integer getResultStatusByResultId(String resultId);

    int isExist2(String userName, String resultMaterial);

    List<Map<String, Object>> noIssueScanResultList2(String userName);
//    根据物资Id查询相对应的入库实绩ID
    List<Map<String, Object>> getInboundResultIdByMaterial(String subResultMaterial);

    int isExistInboundScanResult(String resultMaterial);
    int isExistInboundTwo(String resultMaterial);

    //根据运输订单号取得订单类型和订单id
    Map<String, Object> getOrderTypeByNum(String orderNumber);

    //根据入库实绩id查询运输订单id和类型
    Map<String, Object> getOrderTypeByInboundId(String resultId);

    //根据运输订单号查询出库扫码实绩
    List<Map<String, Object>> findInboundScanResult(String orderNumber);

    //查询装货实绩数量
    Integer isExistLoad(String orderNumber);

    //查询物资编码的详情
    Map<String,Object> findMaterialDetails(String materialCode);

    BigDecimal getMaterialSteelId(Map<String, Object> map);

    int deleteMaterialSteel(BigDecimal materialSteelId);

    int deleteInboundResult(BigDecimal materialSteelId);


    int deleteInboundScanResult(BigDecimal materialSteelId);

}