package com.yuanchu.limslaboratory.mapper;

import com.yuanchu.limslaboratory.pojo.Material;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 江苏鵷雏网络科技有限公司
 * @since 2023-07-17
 */
public interface MaterialMapper extends BaseMapper<Material> {


    //查询物料信息
    List<Map> selectMaterialLimit(int num1,int num2, int type);

    //根据物料id查询物料信息
    Map selectMaterialById(String materialId);

    // 四级树
    List<Map<String, Object>> FourTree();


    Map<String, Object> getTreeByMaterialId(Integer id);
}