package com.shinsoft.sto.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.shinsoft.sto.model.PickRecord;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

/**
 * <p>
 * 领料记录表 Mapper 接口
 * </p>
 *
 * @author system
 * @since 2025-01-13
 */
public interface PickRecordMapper extends BaseMapper<PickRecord> {

    @Select("SELECT * FROM STO_PICK_RECORD WHERE ID = #{id}")
    PickRecord selectByPK(String id);

    IPage<PickRecord> queryList (Page<PickRecord> autoPage, @Param("map") Map<String, Object> map);

    String getMax(@Param("startDate") String startDate, @Param("endDate") String endDate);

}
