From 0b4221a457d7899809d3f733c2c64c977fb9553e Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期六, 14 三月 2026 09:46:52 +0800
Subject: [PATCH] 查询物料规格列表接口优化增加如果没有传参则查询所有产品的规格
---
src/main/java/com/ruoyi/production/service/impl/ProductMaterialSkuServiceImpl.java | 53 ++++++++++++++++++++++++++++++-----------------------
1 files changed, 30 insertions(+), 23 deletions(-)
diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductMaterialSkuServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductMaterialSkuServiceImpl.java
index b319f53..b3717ad 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductMaterialSkuServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductMaterialSkuServiceImpl.java
@@ -1,6 +1,7 @@
package com.ruoyi.production.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.StringUtils;
@@ -49,37 +50,43 @@
* 鏌ヨ鐗╂枡瑙勬牸鍒楄〃
*/
@Override
- public List<ProductMaterialSkuDto> productMaterialSkuList(Long materialId) {
-
- if (materialId == null) {
- return Collections.emptyList();
- }
-
+ public Page<ProductMaterialSkuDto> productMaterialSkuList(Page<ProductMaterialSku> page, ProductMaterialSkuDto dto) {
LambdaQueryWrapper<ProductMaterialSku> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(ProductMaterialSku::getMaterialId, materialId)
- .orderByAsc(ProductMaterialSku::getId);
- List<ProductMaterialSku> skuList = this.list(queryWrapper);
- if (skuList == null || skuList.isEmpty()) {
- return Collections.emptyList();
+ if (dto != null && dto.getMaterialId() != null) {
+ queryWrapper.eq(ProductMaterialSku::getMaterialId, dto.getMaterialId())
+ .like(StringUtils.isNotBlank(dto.getSpecification()),
+ ProductMaterialSku::getSpecification, dto.getSpecification())
+ .like(StringUtils.isNotBlank(dto.getMaterialCode()),
+ ProductMaterialSku::getMaterialCode, dto.getMaterialCode())
+ .orderByAsc(ProductMaterialSku::getId);
}
- // 鏌ヨ鐗╂枡淇℃伅
- ProductMaterial material = productMaterialMapper.selectById(materialId);
+ Page<ProductMaterialSku> skuPage = this.page(page, queryWrapper);
+ List<ProductMaterialSku> skuList = skuPage.getRecords();
+ if (skuList == null || skuList.isEmpty()) {
+ return new Page<>();
+ }
+ ProductMaterial material = productMaterialMapper.selectById(dto.getMaterialId());
String materialName = material != null ? material.getMaterialName() : null;
String baseUnit = material != null ? material.getBaseUnit() : null;
List<ProductMaterialSkuDto> result = new ArrayList<>(skuList.size());
for (ProductMaterialSku sku : skuList) {
- ProductMaterialSkuDto dto = new ProductMaterialSkuDto();
- dto.setMaterialId(materialId);
- dto.setMaterialName(materialName);
- dto.setBaseUnit(baseUnit);
- dto.setSkuId(sku.getId());
- dto.setSpecification(sku.getSpecification());
- dto.setSupplyType(sku.getSupplyType());
- result.add(dto);
+ ProductMaterialSkuDto productMaterialSkuDto = new ProductMaterialSkuDto();
+ productMaterialSkuDto.setMaterialId(dto.getMaterialId());
+ productMaterialSkuDto.setMaterialName(materialName);
+ productMaterialSkuDto.setMaterialCode(sku.getMaterialCode());
+ productMaterialSkuDto.setBaseUnit(baseUnit);
+ productMaterialSkuDto.setSkuId(sku.getId());
+ productMaterialSkuDto.setSpecification(sku.getSpecification());
+ productMaterialSkuDto.setSupplyType(sku.getSupplyType());
+ result.add(productMaterialSkuDto);
}
-
- return result;
+ Page<ProductMaterialSkuDto> dtoPage = new Page<>();
+ dtoPage.setCurrent(skuPage.getCurrent());
+ dtoPage.setSize(skuPage.getSize());
+ dtoPage.setTotal(skuPage.getTotal());
+ dtoPage.setRecords(result);
+ return dtoPage;
}
/**
--
Gitblit v1.9.3