From 88ee0212f8e3e6f1a61ba25c13e0c19b45c68a6c Mon Sep 17 00:00:00 2001
From: CeDo <cedoogle@gmail.com>
Date: 星期一, 19 四月 2021 11:27:02 +0800
Subject: [PATCH] add 按店铺名称搜索
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java
index 3d1f05e..f51d358 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java
@@ -44,6 +44,9 @@
" LEFT JOIN com_shop_user_address uad ON sr.receiver_id = uad.id \n" +
" LEFT JOIN com_shop_store ss ON sr.store_id = ss.id \n" +
" WHERE sr.delete_status = 1" +
+ "<if test='pageComShopOrderSearchDTO.userId != null'>" +
+ " AND sr.user_id = #{pageComShopOrderSearchDTO.userId} " +
+ " </if> " +
"<if test='pageComShopOrderSearchDTO.createAtStart != null'>" +
" AND #{pageComShopOrderSearchDTO.createAtStart} <![CDATA[<=]]> sr.create_at " +
" </if> " +
@@ -67,6 +70,9 @@
" </if> " +
"<if test='pageComShopOrderSearchDTO.status != null '>" +
" AND sr.status = #{pageComShopOrderSearchDTO.status} " +
+ " </if> " +
+ "<if test='pageComShopOrderSearchDTO.storeName != null '>" +
+ " AND ss.name like concat('%', #{pageComShopOrderSearchDTO.storeName}, '%') " +
" </if> " +
" ORDER BY sr.create_at "+
"</script>")
@@ -94,7 +100,7 @@
" LEFT JOIN com_shop_store ss ON sr.store_id = ss.id \n" +
" WHERE sr.delete_status = 1" +
"<if test='comShopOrderExportDTO.userId != null'>" +
- " AND com_shop_store.user_id = #{comShopOrderExportDTO.userId} " +
+ " AND ss.user_id = #{comShopOrderExportDTO.userId} " +
" </if> " +
"<if test='comShopOrderExportDTO.orderIds != null and comShopOrderExportDTO.orderIds.length>0 '>" +
" AND sr.id in " +
--
Gitblit v1.7.1