From 919d74639741f2b07dbaeee3f512df41056e5cd1 Mon Sep 17 00:00:00 2001
From: lyfO_o <764716047@qq.com>
Date: 星期一, 25 十月 2021 10:50:51 +0800
Subject: [PATCH] 试剂库查询Bug
---
src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml b/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml
index b565933..661eba9 100644
--- a/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml
+++ b/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml
@@ -134,7 +134,7 @@
and sr.product_sn like concat("%", #{productSn} ,"%")
</if>
UNION ALL
- SELECT
+ (SELECT
sr.*,
ss.meta_value AS product_home_name,
ss.order_index,
@@ -142,7 +142,7 @@
supplier.NAME AS supplierName,
f.id favor,
f.create_time favortime,
- supplier.valid_flag as supplierFlag
+ supplier.valid_flag as supplierFlag
FROM
sys_reagent AS sr
LEFT JOIN base_meta AS ss ON sr.product_home = ss.id
@@ -169,6 +169,7 @@
<if test="MaxSize != null">
limit #{MaxSize}
</if>
+ )
) as reagent
ORDER BY reagent.favortime DESC,length(reagent.name),reagent.order_index,price asc
<if test="first != null and pageSize != null">
--
Gitblit v1.9.2