From 01e664e79f39091408570625f538898683658b92 Mon Sep 17 00:00:00 2001
From: zj <1772600164@qq.com>
Date: Wed, 21 Jan 2026 22:02:49 +0800
Subject: [PATCH] 1

---
 trading-order-admin/src/main/java/com/yami/trading/api/controller/ApiNewsController.java |   17 ++++++++++++-----
 1 files changed, 12 insertions(+), 5 deletions(-)

diff --git a/trading-order-admin/src/main/java/com/yami/trading/api/controller/ApiNewsController.java b/trading-order-admin/src/main/java/com/yami/trading/api/controller/ApiNewsController.java
index 9d82eac..d1f1804 100644
--- a/trading-order-admin/src/main/java/com/yami/trading/api/controller/ApiNewsController.java
+++ b/trading-order-admin/src/main/java/com/yami/trading/api/controller/ApiNewsController.java
@@ -19,6 +19,7 @@
 
 import javax.servlet.http.HttpServletRequest;
 import java.util.ArrayList;
+import java.util.Date;
 import java.util.List;
 
 @RestController
@@ -66,7 +67,8 @@
      */
     @RequestMapping(action + "list.action")
     public Object list(HttpServletRequest request) {
-
+        List<News> list = new ArrayList<>();
+        //return list;
         String page_no = request.getParameter("page_no");
         String language = request.getParameter("language");
         if (StringUtils.isNullOrEmpty(page_no)) {
@@ -81,11 +83,16 @@
         int page_no_int = Integer.valueOf(page_no).intValue();
         Page<News> page = new Page<>(1, 1000000);
 //			List<News> list = this.newsService.cachePagedQuery(page_no_int, 20, language).getElements();
-        LambdaQueryWrapper<News> lambdaQueryWrapper = Wrappers.<News>query().lambda().eq(News::getLanguage, language)
-                .eq(News::isPopUp,false);
+        // 1. 获取当前时间(对应SQL中的NOW())
+        Date now = new Date();
+        LambdaQueryWrapper<News> lambdaQueryWrapper = Wrappers.<News>query().lambda()
+                .eq(News::getLanguage, language)
+                .eq(News::isPopUp,false)
+                .le(News::getStartTime, now)
+                .ge(News::getEndTime, now);
         lambdaQueryWrapper.orderByDesc(News::getCreateTime);
         newsService.page(page, lambdaQueryWrapper);
-        List<News> list = page.getRecords();
+        list = page.getRecords();
         if (list != null) {
             for (int i = 0; i < list.size(); i++) {
                 list.get(i).setCreateTimeStr(DateUtils.format(list.get(i).getCreateTime(), DateUtils.DF_yyyyMMddHHmmss));
@@ -102,7 +109,7 @@
                     news.setShow(news.getUserId().equals(SecurityUtils.getCurrentUserId()));
                 }
                 if (StringUtils.isNotEmpty(news.getImgUrl())) {
-                    news.setImgUrl(news.getImgUrl());
+                    news.setImgUrl(Constants.IMAGES_HTTP+news.getImgUrl());
                 }
 
             }

--
Gitblit v1.9.3