| | |
|---|
| | | <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},'%') |
|---|
