From 4d86269a103b9530ff3bd46836e0e89a3e43e42b Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期三, 24 九月 2025 17:20:21 +0800
Subject: [PATCH] 小程序接口修改

---
 ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysEducationalInfoController.java   |    8 +---
 ruoyi-system/src/main/java/com/ruoyi/system/service/TSysLiveService.java                     |    6 +++
 ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysLiveController.java              |    6 +--
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysEducationalInfoMapper.java            |    7 +++
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysLiveServiceImpl.java            |   25 ++++++++++++
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysLiveMapper.java                       |    7 +++
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysEducationalInfoServiceImpl.java |    7 +++
 ruoyi-system/src/main/resources/mapper/system/TSysEducationalInfoMapper.xml                  |   19 +++++++++
 ruoyi-system/src/main/resources/mapper/system/TSysLiveMapper.xml                             |   23 +++++++++++
 ruoyi-system/src/main/java/com/ruoyi/system/wxPay/config/WxConfig.java                       |    2 
 ruoyi-system/src/main/java/com/ruoyi/system/service/TSysEducationalInfoService.java          |    6 +++
 11 files changed, 105 insertions(+), 11 deletions(-)

diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysEducationalInfoController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysEducationalInfoController.java
index 926d98c..f4ca8ff 100644
--- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysEducationalInfoController.java
+++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysEducationalInfoController.java
@@ -44,12 +44,8 @@
      */
     @ApiOperation(value = "获取教育资讯分页列表")
     @PostMapping(value = "/pageList")
-    public R<PageInfo<TSysEducationalInfo>> pageList(@RequestBody TSysEducationalInfoQuery query) {
-        Integer roleType = tokenService.getLoginUser().getUser().getRoleType();
-        if(roleType == 5){
-            query.setRoleType(roleType);
-        }
-        return R.ok(sysEducationalInfoService.pageList(query));
+    public R<PageInfo<TSysEducationalInfo>> pageListApp(@RequestBody TSysEducationalInfoQuery query) {
+        return R.ok(sysEducationalInfoService.pageListApp(query));
     }
 
     /**
diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysLiveController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysLiveController.java
index 76437ba..da74297 100644
--- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysLiveController.java
+++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/TSysLiveController.java
@@ -54,10 +54,8 @@
      */
     @ApiOperation(value = "获取直播管理分页列表")
     @PostMapping(value = "/pageList")
-    public R<PageInfo<TSysLiveVO>> pageList(@RequestBody TSysLiveQuery query) {
-        String userId = tokenService.getLoginUserApplet().getUserId();
-        query.setAppUserId(userId);
-        return R.ok(sysLiveService.pageList(query));
+    public R<PageInfo<TSysLiveVO>> pageListApp(@RequestBody TSysLiveQuery query) {
+        return R.ok(sysLiveService.pageListApp(query));
     }
 
     /**
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysEducationalInfoMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysEducationalInfoMapper.java
index d246d38..5e06362 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysEducationalInfoMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysEducationalInfoMapper.java
@@ -25,4 +25,11 @@
      * @return
      */
     List<TSysEducationalInfo> pageList(@Param("query") TSysEducationalInfoQuery query, @Param("pageInfo")PageInfo<TSysEducationalInfo> pageInfo);
+    /**
+     * 获取教育资讯分页列表
+     * @param query
+     * @param pageInfo
+     * @return
+     */
+    List<TSysEducationalInfo> pageListApp(@Param("query") TSysEducationalInfoQuery query, @Param("pageInfo")PageInfo<TSysEducationalInfo> pageInfo);
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysLiveMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysLiveMapper.java
index ab8879f..1bc0863 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysLiveMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysLiveMapper.java
@@ -26,4 +26,11 @@
      * @return 直播管理列表
      */
     List<TSysLiveVO> pageList(@Param("query") TSysLiveQuery query, @Param("pageInfo")PageInfo<TSysLiveVO> pageInfo);
+    /**
+     * 获取直播管理分页列表
+     *
+     * @param query 查询参数
+     * @return 直播管理列表
+     */
+    List<TSysLiveVO> pageListApp(@Param("query") TSysLiveQuery query, @Param("pageInfo")PageInfo<TSysLiveVO> pageInfo);
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysEducationalInfoService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysEducationalInfoService.java
index 1836feb..7421efa 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysEducationalInfoService.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysEducationalInfoService.java
@@ -21,4 +21,10 @@
      * @return
      */
     PageInfo<TSysEducationalInfo> pageList(TSysEducationalInfoQuery query);
+    /**
+     * 获取教育资讯分页列表
+     * @param query
+     * @return
+     */
+    PageInfo<TSysEducationalInfo> pageListApp(TSysEducationalInfoQuery query);
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysLiveService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysLiveService.java
index 77f824a..8eada09 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysLiveService.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysLiveService.java
@@ -30,4 +30,10 @@
      * @return
      */
     PageInfo<TSysLiveVO> pageList(TSysLiveQuery query);
+    /**
+     * 获取直播管理分页列表
+     * @param query
+     * @return
+     */
+    PageInfo<TSysLiveVO> pageListApp(TSysLiveQuery query);
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysEducationalInfoServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysEducationalInfoServiceImpl.java
index 927069e..14bd192 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysEducationalInfoServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysEducationalInfoServiceImpl.java
@@ -29,4 +29,11 @@
         pageInfo.setRecords(list);
         return pageInfo;
     }
+    @Override
+    public PageInfo<TSysEducationalInfo> pageListApp(TSysEducationalInfoQuery query) {
+        PageInfo<TSysEducationalInfo> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
+        List<TSysEducationalInfo> list = this.baseMapper.pageListApp(query,pageInfo);
+        pageInfo.setRecords(list);
+        return pageInfo;
+    }
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysLiveServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysLiveServiceImpl.java
index 62b5b0e..1e8bbd3 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysLiveServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysLiveServiceImpl.java
@@ -91,4 +91,29 @@
         pageInfo.setRecords(list);
         return pageInfo;
     }
+    @Override
+    public PageInfo<TSysLiveVO> pageListApp(TSysLiveQuery query) {
+        PageInfo<TSysLiveVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
+        List<TSysLiveVO> list = this.baseMapper.pageListApp(query,pageInfo);
+        if (CollectionUtils.isEmpty(list)){
+            return pageInfo;
+        }
+        // 判断状态
+        for (TSysLiveVO sysLive : list) {
+            if(sysLive.getStartTime().isAfter(LocalDateTime.now())){
+                sysLive.setLiveStatus(1);
+            }
+            if(sysLive.getStartTime().isBefore(LocalDateTime.now()) && sysLive.getEndTime().isAfter(LocalDateTime.now())){
+                sysLive.setLiveStatus(2);
+            }
+            if(sysLive.getEndTime().isBefore(LocalDateTime.now())){
+                sysLive.setLiveStatus(3);
+            }
+            // 查看是否包含该值
+            boolean memberInSet = redisCache.isMemberInSet(Constants.LIVE_APPOINTMENT_PUSH + sysLive.getId(), query.getAppUserId());
+            sysLive.setAppointmentStatus(memberInSet ? 2 : 1);
+        }
+        pageInfo.setRecords(list);
+        return pageInfo;
+    }
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/wxPay/config/WxConfig.java b/ruoyi-system/src/main/java/com/ruoyi/system/wxPay/config/WxConfig.java
index c70a034..39c05ea 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/wxPay/config/WxConfig.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/wxPay/config/WxConfig.java
@@ -13,7 +13,7 @@
  *
  * @author lihen
  */
-//@Configuration
+@Configuration
 public class WxConfig {
 
     private final WeixinPayProperties weixinPayProperties;
diff --git a/ruoyi-system/src/main/resources/mapper/system/TSysEducationalInfoMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TSysEducationalInfoMapper.xml
index 1ee5f4c..0da46f1 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TSysEducationalInfoMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TSysEducationalInfoMapper.xml
@@ -44,5 +44,24 @@
         </where>
         ORDER BY create_time DESC
     </select>
+    <select id="pageListApp" resultType="com.ruoyi.system.model.TSysEducationalInfo">
+        select
+        <include refid="Base_Column_List" />
+            from t_sys_educational_info
+        <where>
+            <if test="query.infoTitle != null and query.infoTitle != ''">
+                and info_title like concat('%',#{query.infoTitle},'%')
+            </if>
+            <if test="query.showType != null">
+                and show_type = #{query.showType}
+            </if>
+            <if test="query.status != null">
+                and status = #{query.status}
+            </if>
+            and show_type in (1,3)
+            AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
+        </where>
+        ORDER BY create_time DESC
+    </select>
 
 </mapper>
diff --git a/ruoyi-system/src/main/resources/mapper/system/TSysLiveMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TSysLiveMapper.xml
index fd8083c..c127795 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TSysLiveMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TSysLiveMapper.xml
@@ -53,4 +53,27 @@
         ORDER BY create_time DESC
     </select>
 
+    <select id="pageListApp" resultType="com.ruoyi.system.vo.TSysLiveVO">
+        SELECT
+        <include refid="Base_Column_List"/>
+            FROM t_sys_live
+        <where>
+            <if test="query.liveTitle != null and query.liveTitle != ''">
+                AND live_title LIKE concat('%',#{query.liveTitle},'%')
+            </if>
+            <if test="query.liveStatus != null and query.liveStatus == 1">
+                AND date_format(start_time,'%y%m%d %H%i%s') &gt; date_format(NOW(),'%y%m%d %H%i%s')
+            </if>
+            <if test="query.liveStatus != null and query.liveStatus == 2">
+                AND date_format(start_time,'%y%m%d %H%i%s') &lt;= date_format(NOW(),'%y%m%d %H%i%s')
+                AND date_format(end_time,'%y%m%d %H%i%s') &gt;= date_format(NOW(),'%y%m%d %H%i%s')
+            </if>
+            <if test="query.liveStatus != null and query.liveStatus == 3">
+                AND date_format(end_time,'%y%m%d %H%i%s') &lt; date_format(NOW(),'%y%m%d %H%i%s')
+            </if>
+            AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
+        </where>
+        ORDER BY create_time DESC
+    </select>
+
 </mapper>

--
Gitblit v1.7.1