1

phpcjl

2024-12-17 cd6658d494de5339095d226101e22a52918659ad

1

 ruoyi-service/ruoyi-other/src/main/java/com/ruoyi/other/controller/SeckillActivityInfoController.java

@@ -24,6 +24,7 @@
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.time.LocalDateTime;
import java.time.ZoneOffset;
import java.util.List;

@@ -105,6 +106,18 @@
                                                 Goods goods)
    {
        IPage<SeckillActivityVO> IPage = seckillActivityInfoMapper.querySeckillActivity(Page.of(pageNum, pageSize), goods);
        for (SeckillActivityVO record : IPage.getRecords()) {
            LocalDateTime startTime = record.getStartTime();
            LocalDateTime now = LocalDateTime.now();
            LocalDateTime endTime = record.getEndTime();
            if (endTime.isBefore(now)){
                record.setStatus(2); //已结束
            }else if (startTime.isBefore(now)){
                record.setStatus(1); // 已开始
            }else {
                record.setStatus(0); // 未开始
            }
        }
        return R.ok(IPage);
    }


 ruoyi-service/ruoyi-other/src/main/resources/mapper/other/SeckillActivityInfoMapper.xml

@@ -60,7 +60,8 @@
        tgs.selling_price,
        tg.sale_num,
        tsai.start_time,
        tsai.end_time
        tsai.end_time,
        tsai.is_shelves showStatus
        FROM
        t_seckill_activity_info tsai
        LEFT JOIN t_goods tg ON tsai.good_id = tg.id