From c624a13eb32b90bb698f9fa9225c5a5ec07fa804 Mon Sep 17 00:00:00 2001
From: CeDo <cedoogle@gmail.com>
Date: 星期二, 20 四月 2021 18:43:22 +0800
Subject: [PATCH] Default Changelist
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopGoodsDAO.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/ComShopGoodsDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopGoodsDAO.java
index cafd364..ee65564 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
@@ -35,9 +35,14 @@
"<if test='pageComShopGoodsDTO.name != null and pageComShopGoodsDTO.name.trim() != ""'>" +
"and c.name like concat('%',#{pageComShopGoodsDTO.name},'%') \n" +
" </if> " +
+ "<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> " +
+ " order by c.create_at desc" +
" </where>" +
"</script>")
IPage<PageShopGoodsVO> pageShopGoods(Page page, @Param("pageComShopGoodsDTO") PageComShopGoodsDTO pageComShopGoodsDTO);
@@ -64,7 +69,8 @@
*/
@Select("<script> " +
"select id,`name`,store_id,goods_pic,images,`status`,sale,original_price,price,unit" +
- ",`order`,stock,details,delivery_type from com_shop_goods as csg " +
+ ",`order`,stock,details,delivery_type, create_at " +
+ " from com_shop_goods as csg " +
" where 1=1 and csg.delete_status = 1 " +
"<if test='comShopGoodsDTO.name != null and comShopGoodsDTO.name !=""'>" +
" AND csg.`name` like concat('%',#{comShopGoodsDTO.name},'%') " +
--
Gitblit v1.7.1