From c94ad3432af0da487ab77eca990be2039418bb40 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 24 May 2022 11:00:10 +0800
Subject: [PATCH] 农产品查询修改
---
src/main/java/org/springblade/modules/farmplant/vo/FarmProductStockVO.java | 5 +++++
src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml | 2 +-
2 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml b/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml
index 96259bf..f9cb835 100644
--- a/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml
+++ b/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml
@@ -4,7 +4,7 @@
<!--自定义查询农产品库存分页数据-->
<select id="selectFarmProductStockPage" resultType="org.springblade.modules.farmplant.vo.FarmProductStockVO">
- select sfps.*,ss.url url from sys_farm_product_stock sfps
+ select sfps.*,ss.url,ss.strain_name strainName from sys_farm_product_stock sfps
left join sys_strain ss on ss.id = sfps.strain_id
where 1=1
<if test="farmProductStock.strainId!=null and farmProductStock.strainId!=''">
diff --git a/src/main/java/org/springblade/modules/farmplant/vo/FarmProductStockVO.java b/src/main/java/org/springblade/modules/farmplant/vo/FarmProductStockVO.java
index 632b8d2..912bee9 100644
--- a/src/main/java/org/springblade/modules/farmplant/vo/FarmProductStockVO.java
+++ b/src/main/java/org/springblade/modules/farmplant/vo/FarmProductStockVO.java
@@ -18,4 +18,9 @@
*/
private String url;
+ /**
+ * 农产品名称
+ */
+ private String strainName;
+
}
--
Gitblit v1.9.3