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);
|
}
|
