From 2d6895f99ce9d5fff6c1c6b353e61dc7938418a5 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期二, 20 四月 2021 20:20:47 +0800
Subject: [PATCH] bug修复
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopGoodsDAO.java | 3 +--
1 files changed, 1 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopGoodsDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopGoodsDAO.java
index 0cfaa0d..ddea14d 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopGoodsDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopGoodsDAO.java
@@ -27,7 +27,7 @@
@Select("<script>" +
"select c.id,c.type_id,css.name as storeName,c.name,c.store_id,c.goods_pic,c.images,c.status,c.sale,c.original_price,c.price,c.unit,c.order,c.stock,c.details,c.remark,c.goods_describe,c.delivery_type,c.delete_status,c.create_at,c.update_at from com_shop_goods c \n" +
- "right join com_shop_store css on c.store_id=css.id\n" +
+ "left join com_shop_store css on c.store_id=css.id\n" +
" <where>" +
"<if test='pageComShopGoodsDTO.storeName != null and pageComShopGoodsDTO.storeName.trim() != ""'>" +
"and css.name like concat('%',#{pageComShopGoodsDTO.storeName},'%') \n" +
@@ -38,7 +38,6 @@
"<if test='pageComShopGoodsDTO.storeId != null'>" +
"and css.id=#{pageComShopGoodsDTO.storeId} \n" +
" </if> " +
-
"<if test='pageComShopGoodsDTO.status != null'>" +
"and c.status like concat('%',#{pageComShopGoodsDTO.status},'%') \n" +
" </if> " +
--
Gitblit v1.7.1