From 62e0ba83e0ceedc2b1333761d713402f6727c98c Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Mon, 11 Jul 2022 15:23:43 +0800
Subject: [PATCH] 大屏接口对接
---
src/main/java/org/springblade/modules/sale/vo/SaleVO.java | 16 ++++++++++++++++
src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml | 16 +++++++++++++---
2 files changed, 29 insertions(+), 3 deletions(-)
diff --git a/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml b/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml
index 6cc54f8..7050b96 100644
--- a/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml
+++ b/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml
@@ -22,9 +22,19 @@
<select id="selectSalePage" resultMap="saleResultMap">
- select *
- from sys_sale
- where is_deleted = 0
+ SELECT
+ sale.*,
+ user.real_name,
+ strain.strain_name,
+ strain.url,
+ district.name as district
+ FROM
+ sys_sale sale
+ LEFT JOIN blade_user user on sale.create_user = user.id
+ LEFT JOIN sys_strain strain on sale.strain_id = strain.id
+ LEFT JOIN sys_district district on sale.sale_destination = district.code
+ WHERE
+ sale.is_deleted = 0
</select>
diff --git a/src/main/java/org/springblade/modules/sale/vo/SaleVO.java b/src/main/java/org/springblade/modules/sale/vo/SaleVO.java
index 4636f3b..9b96b1c 100644
--- a/src/main/java/org/springblade/modules/sale/vo/SaleVO.java
+++ b/src/main/java/org/springblade/modules/sale/vo/SaleVO.java
@@ -31,4 +31,20 @@
public class SaleVO extends Sale {
private static final long serialVersionUID = 1L;
+ /**
+ * 创建人名称
+ */
+ private String realName;
+ /**
+ * 品种名称
+ */
+ private String strainName;
+ /**
+ * 品种图片
+ */
+ private String url;
+ /**
+ * 销售地中文
+ */
+ private String district;
}
--
Gitblit v1.9.3