package com.ruoyi.basic.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.basic.pojo.ProductModel;
import com.ruoyi.basic.vo.ProductModelVo;
import com.ruoyi.procurementrecord.bean.dto.ProcurementPageDto;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

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


/**
 * 【请填写功能名称】Mapper接口
 *
 * @author ruoyi
 * @date 2025-05-19
 */
public interface ProductModelMapper extends BaseMapper<ProductModel> {

    IPage<ProductModelVo> listPageProductModel(Page<ProductModelVo> page, @Param("c") ProductModel productModel);

    IPage<ProductModel> listPageProductionStock(Page<ProductModel> page, @Param("req") ProcurementPageDto req);

    ProductModel selectLatestRecord();

    List<Map<String, Object>> getProductAndModelList();

    /**
     * 按产品名称 + 规格型号查询产品型号
     *
     * @param productName 产品名称
     * @param model       规格型号
     * @return 产品型号（取第一条）
     */
    @Select("select pm.id, pm.product_id, pm.model, pm.unit from product_model pm " +
            "left join product p on pm.product_id = p.id " +
            "where p.product_name = #{productName} and pm.model = #{model} " +
            "order by pm.id limit 1")
    ProductModel selectByProductNameAndModel(@Param("productName") String productName, @Param("model") String model);
}