package com.zy.acs.manager.manager.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zy.acs.manager.manager.entity.Sta;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StaMapper extends BaseMapper<Sta> {

    // inbound -------------------

    int tryReserveIn(@Param("staId") Long staId, @Param("qty") Integer qty);

    int releaseReserveIn(@Param("staId") Long staId, @Param("qty") Integer qty);

    int confirmReserveIn(@Param("staId") Long staId, @Param("qty") Integer qty);

    // outbound ------------------

    int tryReserveOut(@Param("staId") Long staId, @Param("qty") Integer qty);

    int releaseReserveOut(@Param("staId") Long staId, @Param("qty") Integer qty);

    int confirmReserveOut(@Param("staId") Long staId, @Param("qty") Integer qty);


    // query ------------------

    List<Sta> selectAvailableOutSta(@Param("minAvailableQty") Integer minAvailableQty);

    List<Sta> selectAvailableInSta(@Param("minAvailableQty") Integer minAvailableQty);

}