package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.WmspRestackMakeResult;
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 org.apache.ibatis.annotations.Select;

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

@Mapper
public interface WmspRestackMakeResultMapper extends IBaseMapper<WmspRestackMakeResult, BigDecimal> {

    List<Map<String,Object>> selectRestackMakeResultList(Map<String,Object> mapval);
    // 添加库管员填写倒垛单实绩
    int insertSelective(WmspRestackMakeResult wmspRestackMakeResult);
    @Select("select seq_WMSP_RESTACK_MAKE_RESULT.nextval from dual")
    BigDecimal selectMaxId();
    //层次号下拉框
    @MapKey("")
    List<Map<String,Object>> selectGardationNumber(@Param("warehouseid") Integer warehouseid,@Param("stackingId") Integer stackingId);
    @MapKey("")
        //垛位号下拉框
    List<Map<String,Object>> selectStackingId(Integer warehouseid);
    List<Map<String,Object>>   selectWarehouse();
    BigDecimal  getWarehouseId();
    //查询倒垛单
    List<Map<String,Object>> selectRestack(Map<String,Object> mapval);
    //渲染数据
    List<Map<String,Object>> selectAfterWarehouseByResultId(String resultId);
    List<Map<String,Object>> selectAfterstackingByResultId(String resultId);
    //根据实绩id查找物资信息
    List<Map<String,Object>> selectMaterialInfoByResultId(String resultId);
    //根据仓库名称和下发状态查找倒垛单
    @MapKey("")
    List<Map<String,Object>> selectRestackByWarehouseId(Map<String,Object> map);
    //根据钢材物资id查找仓储网格id
    Integer selectGridIdByMaterialId(BigDecimal materialSteelId);
    BigDecimal selectGridIdByWarehouseAndSatcking(Map<String,Object> map);
    //根据倒垛实绩查找倒垛信息
    List<Map<String,Object>> selectRestackInfoByResultId(String resultId);
    //Pc端展示未下发的倒垛实绩
    List<Map<String,Object>> selectRestackForPc(Map<String,Object> map);
    //根据实绩id查找中间表id
    List<Map<String,Object>> selectMakeMaterialIdByResultId(Integer resultId);
    //Pc端展示已下发的倒垛实绩
    List<Map<String, Object>> selectRestackForPc2(Map<String, Object> map);
}