package com.vincent.rsf.server.manager.mapper;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.vincent.rsf.server.manager.entity.LocItem;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

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

@Mapper
@Repository
public interface LocItemMapper extends BaseMapper<LocItem> {

    List<LocItem> listByMatnr(@Param("type") String type, @Param("channel") String channel, @Param(Constants.WRAPPER) LambdaQueryWrapper<LocItem> matnr);

    /**
     * 按物料ID汇总库位库存数量；可选按库位状态过滤。
     * @param matnrIds 物料ID列表
     * @param locUseStatus 库位状态，为空则不过滤
     * @return 每行: matnrId, stockQty, locStatuses(逗号分隔的库位状态，仅当 locUseStatus 为空时返回)
     */
    List<Map<String, Object>> listStockByMatnrIds(@Param("matnrIds") List<Long> matnrIds, @Param("locUseStatus") String locUseStatus);
}