package com.ruoyi.business.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.business.domain.TBaseStorageAreaLocation;

import java.util.List;

/**
 * 库位资料Mapper接口
 * 
 * @author wms
 * @date 2022-12-24
 */
public interface TBaseStorageAreaLocationMapper extends BaseMapper<TBaseStorageAreaLocation>
{
    /**
     * 库位爆仓预警
     */
    public int outOfStockWarning();

    /**
     * 库位预警
     */
    public String outOfRemainingWarning();

    /**
     * 查询库位资料
     * 
     * @param locationId 库位资料主键
     * @return 库位资料
     */
    public TBaseStorageAreaLocation selectTBaseStorageAreaLocationByLocationId(String locationId);

    /**
     * 查询库位资料列表
     * 
     * @param tBaseStorageAreaLocation 库位资料
     * @return 库位资料集合
     */
    public List<TBaseStorageAreaLocation> selectTBaseStorageAreaLocationList(TBaseStorageAreaLocation tBaseStorageAreaLocation);

    /**
     * 新增库位资料
     * 
     * @param tBaseStorageAreaLocation 库位资料
     * @return 结果
     */
    public int insertTBaseStorageAreaLocation(TBaseStorageAreaLocation tBaseStorageAreaLocation);

    /**
     * 修改库位资料
     * 
     * @param tBaseStorageAreaLocation 库位资料
     * @return 结果
     */
    public int updateTBaseStorageAreaLocation(TBaseStorageAreaLocation tBaseStorageAreaLocation);

    /**
     * 删除库位资料
     * 
     * @param locationId 库位资料主键
     * @return 结果
     */
    public int deleteTBaseStorageAreaLocationByLocationId(String locationId);

    /**
     * 批量删除库位资料
     * 
     * @param locationIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTBaseStorageAreaLocationByLocationIds(String[] locationIds);
}
