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

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.WmspGridMaterial;
import com.steerinfo.dil.vo.OutBoundMaterialDetailedInfo;
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 WmspGridMaterialMapper extends IBaseMapper<WmspGridMaterial, BigDecimal> {
  //查询实时库存数据
    List<Map<String,Object>> selectGridMaterial(Map<String,Object> mapval);
    Long countByGmId();
    List<Map<String,Object>> selectInboundTimeAndThreshold(BigDecimal gridId);
    //创建序列号
    @Select("select seq_WMSP_GRID_MATERIAL.nextval from dual")
    BigDecimal getCount();
  //通过成品仓库网格ID查询实时库存
  List<Map<String, Object>> selectGridMaterialListByGridId(Map<String, Object> mapval);
  //通过成品仓库网格ID获取物资钢材表ID
  BigDecimal selectMaterialSteelIdByGridId(BigDecimal gridId);
  //通过主键修改物资钢材表的质量是否合格字段和逻辑删除
  int updateRmsMaterialSteelDemotion(Map<String, Object> map);
  //通过钢材物资ID获取入库作业实绩表ID
  BigDecimal selectInboundIdByMaterialSteelId(BigDecimal materialSteelId);
  //通过入库实绩ID逻辑删除库管员纠正吊牌实绩数据
  int updateInboundCorrectByInboundId(BigDecimal inboundId);
  //通过入库实绩ID逻辑删除行车工吊装入库实绩数据
  int updateInboundDrivingByInboundId(BigDecimal inboundId);
  //通过入库实绩ID逻辑删除吊钢工扫描吊牌实绩数据
  int updateInboundScanByInboundId(BigDecimal inboundId);
  //通过入库实绩ID逻辑删除系统/库管员选择垛位实绩数据
  int updateInboundStackByInboundId(BigDecimal inboundId);
  //根据物资唯一编码查询实时库存id
  List<Map<String,Object>> selectGridIdByMaterialCode(Map<String,Object> map);

  Map<String, Object> getReboundScanResultByResultMaterial(@Param("material") String material, @Param("materialOnlyCode")String materialOnlyCode);

  List<Map<String, Object>> getMaterialTypeList(String warehouseid, BigDecimal stackingId, BigDecimal gradtionNumber);

  //根据物资唯一编码和网格id确定实时库存主键
  Map<String,Object> selectGmIdByMaterialOnlyCode(@Param("GirdId")BigDecimal GirdId);

  //根据物资唯一编码查找仓储网格原来的主键id
  BigDecimal slelectGridIdByMaterialOnlyCode(@Param("materialOnlyCode")String materialOnlyCode);

//  根据仓库id和物资类型编码查询对应的实时库存
  int getStockTakingList(String warehouseId, String materialCode);
//  根据物资编码查询对应的物资ID
  BigDecimal getMaterialIds(String materialCode);

  int updateByMaterialId(@Param("materialSteelId") BigDecimal materialSteelId, @Param("updateTime")Date updateTime);

  //查询id
    List<Map<String,Object>> getMaterialId(BigDecimal warehouseId);


  int deleteGridMaterial(@Param("thisMaterialDetailedInfos") List<OutBoundMaterialDetailedInfo> thisMaterialDetailedInfos,@Param("now")Date now);
}