package com.steerinfo.dil.mapper;
import com.steerinfo.dil.model.WmspRestackScanResult;
import com.steerinfo.framework.mapper.IBaseMapper;
import org.apache.ibatis.annotations.MapKey;
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 WmspRestackScanResultMapper extends IBaseMapper<WmspRestackScanResult, BigDecimal> {
    int insertSelective(WmspRestackScanResult wmspRestackScanResult);
    //根据条件查找信息
    @MapKey("")
    List<Map<String,Object>> selectByLoaderId(Map<String,Object> mapval);
    //查询最大id
    @Select("select seq_WMSP_RESTACK_SCAN_RESULT.nextval from dual\n")
    BigDecimal selectMaxId();
    //稽核倒垛单信息
    Integer selectRestackAudit(String materialCode);
    int updateByPrimaryKeySelective(WmspRestackScanResult wmspRestackScanResult);
    //根据稽核结果统计订单数量
    int CountByAuditResult(Integer resultId);
    //根据垛位id查询垛位已堆放物资数量
    Integer selectNumber(Integer stackingId1);
    //稽核阶段，根据物资id查找物资id
    @MapKey("")
    Map<String,Object> selectListByAuditResult(Integer mateialId);
    //稽核阶段，根据实绩id查找物资id
    @MapKey("")
    List<Map<String,Object>> selectMaterialIdByResultId(Integer resultId);
    //根据实绩id查找倒垛后的仓库id和垛位id
    @MapKey("")
    Map<String,Object> selectWarehouseIdAndStakingId(Integer resultId);
    Integer selectGridIdByStakingNoAndGrandationnumber(Map<String,Object> map);
    //根据扫描结果查询是否存在
    Integer selectResultScanTag(String resultScanTag);
    //根据网格id和物资id查找主键id
    Integer selectGmIdByGridIdAndMaterialId(Integer gridId,Integer materialId);
    //根据网格id查找物资id
    Integer selectMaterialIdByGridId(Integer gridId);
    //根据物资id查找倒垛前的仓储网格
    Integer selectGridIdByResultId(Integer resultId);
    //根据实绩id查找扫描结果
    List<Map<String,Object>> selectTagByResultId(Integer resultId);
//    判断当前的物资是否已经存在并且倒垛状态为已倒垛
    int getWmspRestackScanResultCount(String onlyCode);

    BigDecimal getResultId(String content);
}