From 31c79c44afa746ebd25a3ded8377f77b59c64abd Mon Sep 17 00:00:00 2001
From: phpcjl <phpcjl@gmail.com>
Date: 星期二, 17 十二月 2024 16:10:15 +0800
Subject: [PATCH] 1
---
ruoyi-service/ruoyi-other/src/main/resources/mapper/other/SeckillActivityInfoMapper.xml | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/SeckillActivityInfoMapper.xml b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/SeckillActivityInfoMapper.xml
index bf9639e..9d80fa9 100644
--- a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/SeckillActivityInfoMapper.xml
+++ b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/SeckillActivityInfoMapper.xml
@@ -49,17 +49,23 @@
<select id="querySeckillActivity" resultType="com.ruoyi.other.vo.SeckillActivityVO">
SELECT
tsai.id,
- tg.`name`,
+ tg.`name` goodsName,
tg.introduction,
+ tgc.`name` goodsCategoryName,
+ tg.operating_cost,
+ tg.shop_cost,
+ tg.purchase_limit maxNum,
tg.home_page_picture,
tg.original_price,
tgs.selling_price,
tg.sale_num,
- tsai.start_time
+ tsai.start_time,
+ tsai.end_time
FROM
t_seckill_activity_info tsai
LEFT JOIN t_goods tg ON tsai.good_id = tg.id
LEFT JOIN t_goods_seckill tgs ON tgs.seckill_activity_info_id = tsai.id
+ LEFT JOIN t_goods_category tgc ON tgc.id = tg.goods_category_id
WHERE tsai.end_time >= NOW() AND tsai.del_flag = 0
<if test="goods.name != null and goods.name != ''">
AND tg.`name` LIKE concat('%',#{goods.name},'%')
--
Gitblit v1.7.1