From e5cc807a611a078b1c152731ff7a07e765bbb9a5 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期一, 30 三月 2026 14:41:37 +0800
Subject: [PATCH] fix: 添加规格型号搜索
---
src/main/resources/mapper/consumables/ConsumablesInventoryMapper.xml | 3 +++
src/main/resources/mapper/stock/StockInventoryMapper.xml | 3 +++
2 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/mapper/consumables/ConsumablesInventoryMapper.xml b/src/main/resources/mapper/consumables/ConsumablesInventoryMapper.xml
index 77e3943..3b4e6d3 100644
--- a/src/main/resources/mapper/consumables/ConsumablesInventoryMapper.xml
+++ b/src/main/resources/mapper/consumables/ConsumablesInventoryMapper.xml
@@ -105,6 +105,9 @@
<if test="ew.productName != null and ew.productName != ''">
AND p.product_name LIKE CONCAT('%', #{ew.productName}, '%')
</if>
+ <if test="ew.model != null and ew.model != ''">
+ AND pm.model LIKE CONCAT('%', #{ew.model}, '%')
+ </if>
</where>
) temp
WHERE qualitity != 0
diff --git a/src/main/resources/mapper/stock/StockInventoryMapper.xml b/src/main/resources/mapper/stock/StockInventoryMapper.xml
index 5b8bcab..b99a589 100644
--- a/src/main/resources/mapper/stock/StockInventoryMapper.xml
+++ b/src/main/resources/mapper/stock/StockInventoryMapper.xml
@@ -97,6 +97,9 @@
<if test="ew.productName != null and ew.productName != ''">
AND p.product_name LIKE CONCAT('%', #{ew.productName}, '%')
</if>
+ <if test="ew.model != null and ew.model != ''">
+ AND pm.model LIKE CONCAT('%', #{ew.model}, '%')
+ </if>
</where>
) temp
WHERE qualitity != 0
--
Gitblit v1.9.3