From 9486766c806fe1d9e082b2fd02ea1cc558f1b443 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期四, 08 五月 2025 09:21:57 +0800
Subject: [PATCH] bug修改

---
 cloud-server-activity/src/main/java/com/dsh/activity/service/impl/BenefitsVideosServiceImpl.java |   45 +++++++++++++++++++++++++--------------------
 1 files changed, 25 insertions(+), 20 deletions(-)

diff --git a/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/BenefitsVideosServiceImpl.java b/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/BenefitsVideosServiceImpl.java
index a287320..3d22fa8 100644
--- a/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/BenefitsVideosServiceImpl.java
+++ b/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/BenefitsVideosServiceImpl.java
@@ -51,17 +51,13 @@
 
     @Resource
     private UserIntegralChangesClient userIntegralChangesClient;
-    @Autowired
-    private BenefitsVideoClassificationMapper benefitsVideoClassificationMapper;
-    @Autowired
+    @Resource
     private BenefitsVideosMapper benefitsVideosMapper;
-
-
-
 
 
     /**
      * 获取福利视频分类列表数据
+     *
      * @param uid
      * @param search
      * @return
@@ -70,12 +66,14 @@
     @Override
     public List<BenefitsVideoClassificationListVo> queryClassificationBenefitsVideosList(Integer uid, Integer position, String search) throws Exception {
         QueryWrapper<BenefitsVideoClassification> wrapper = new QueryWrapper<BenefitsVideoClassification>().eq("position", position);
-        if(ToolUtil.isNotEmpty(search)){
+        if (ToolUtil.isNotEmpty(search)) {
             wrapper.like("name", search);
         }
 
-        List<BenefitsVideoClassification> list = benefitsVideoClassificationService.list(wrapper.orderByAsc("sort"));
-        List<UserBenefitsVideos> userBenefitsVideos = userBenefitsVideosService.list(new QueryWrapper<UserBenefitsVideos>().eq("appUserId", uid));
+        List<BenefitsVideoClassification> list = benefitsVideoClassificationService.list(wrapper.eq("state", 1)
+                .orderByDesc("sort"));
+        List<UserBenefitsVideos> userBenefitsVideos = userBenefitsVideosService.list(new QueryWrapper<UserBenefitsVideos>()
+                .eq("appUserId", uid));
         List<Integer> collect = userBenefitsVideos.stream().map(UserBenefitsVideos::getBenefitsVideosId).collect(Collectors.toList());
 
         List<BenefitsVideoClassificationListVo> listVos = new ArrayList<>();
@@ -84,14 +82,15 @@
                 BenefitsVideoClassificationListVo benefitsVideoClassificationListVo = new BenefitsVideoClassificationListVo();
                 benefitsVideoClassificationListVo.setId(benefitsVideoClassification.getId());
                 benefitsVideoClassificationListVo.setName(benefitsVideoClassification.getName());
-                QueryWrapper<BenefitsVideos> benefitsVideosQueryWrapper = new QueryWrapper<BenefitsVideos>().eq("state", 1).eq("benefitsVideoClassificationId", benefitsVideoClassification.getId());
+                QueryWrapper<BenefitsVideos> benefitsVideosQueryWrapper = new QueryWrapper<BenefitsVideos>()
+                        .eq("state", 1).eq("benefitsVideoClassificationId", benefitsVideoClassification.getId());
                 if (collect.size() > 0) {
                     benefitsVideosQueryWrapper.notIn("id", collect);
                 }
-                List<BenefitsVideos> list1 = this.list(benefitsVideosQueryWrapper.orderByDesc("insertTime").last(" limit 0, 4"));
+                List<BenefitsVideos> list1 = this.list(benefitsVideosQueryWrapper.orderByAsc("insertTime").last(" limit 0, 4"));
                 List<BenefitsVideosListVo> lists = new ArrayList<>();
                 for (BenefitsVideos benefitsVideos : list1) {
-                    if (benefitsVideos.getState()==1) {
+                    if (benefitsVideos.getState() == 1) {
                         Integer courseId = benefitsVideos.getCourseId();
                         Course course = courseClient.queryCourseById(courseId);
                         BenefitsVideosListVo benefitsVideosListVo = new BenefitsVideosListVo();
@@ -108,10 +107,11 @@
         }
         return listVos;
     }
+
     @Override
     public List<BenefitsVideoClassificationListVo> queryClassificationBenefitsVideosListOne(Integer uid, Integer position, String search) throws Exception {
         QueryWrapper<BenefitsVideoClassification> wrapper = new QueryWrapper<BenefitsVideoClassification>().eq("position", position);
-        if(ToolUtil.isNotEmpty(search)){
+        if (ToolUtil.isNotEmpty(search)) {
             wrapper.like("name", search);
         }
         List<BenefitsVideoClassification> list = benefitsVideoClassificationService.list(wrapper.orderByAsc("sort"));
@@ -124,7 +124,7 @@
             benefitsVideoClassificationListVo.setId(benefitsVideoClassification.getId());
             benefitsVideoClassificationListVo.setName(benefitsVideoClassification.getName());
             QueryWrapper<BenefitsVideos> benefitsVideosQueryWrapper = new QueryWrapper<BenefitsVideos>().eq("state", 1);
-            if(collect.size() > 0){
+            if (collect.size() > 0) {
                 benefitsVideosQueryWrapper.notIn("id", collect);
             }
             List<BenefitsVideos> list1 = this.list(benefitsVideosQueryWrapper.orderByDesc("insertTime").last(" limit 0, 4"));
@@ -151,12 +151,15 @@
         pageSize = (pageSize - 1) * pageNo;
         List<Integer> ids = null;
 
-        if(ToolUtil.isNotEmpty(search)){
+        if (ToolUtil.isNotEmpty(search)) {
             List<Course> courses = courseClient.queryCourseByName(search);
             ids = courses.stream().map(Course::getId).collect(Collectors.toList());
         }
+        int offset = (pageNo - 1) * pageSize;
+        int limit = pageSize;
 
-        List<Map<String, Object>> benefitsVideos = this.baseMapper.queryBenefitsVideosList(uid, classificationId, ids, pageSize, pageNo);
+
+        List<Map<String, Object>> benefitsVideos = this.baseMapper.queryBenefitsVideosList(uid, classificationId, ids, offset, limit);
         List<BenefitsVideosListVo> lists = new ArrayList<>();
         for (Map<String, Object> benefitsVideo : benefitsVideos) {
             Integer id = Integer.valueOf(benefitsVideo.get("id").toString());
@@ -179,6 +182,7 @@
 
     /**
      * 获取福利视频详情
+     *
      * @param uid
      * @param id
      * @return
@@ -205,6 +209,7 @@
 
     /**
      * 视频观看完毕后获得奖励
+     *
      * @param uid
      * @param id
      * @throws Exception
@@ -213,7 +218,7 @@
     public void receiveAward(Integer uid, Integer id) throws Exception {
         BenefitsVideos benefitsVideos = this.getById(id);
         UserBenefitsVideos one = userBenefitsVideosService.getOne(new QueryWrapper<UserBenefitsVideos>().eq("appUserId", uid).eq("benefitsVideosId", id));
-        if(null == one){
+        if (null == one) {
             one = new UserBenefitsVideos();
             one.setAppUserId(uid);
             one.setBenefitsVideoClassificationId(benefitsVideos.getBenefitsVideoClassificationId());
@@ -232,13 +237,13 @@
     }
 
     @Override
-    public List<BenefitsVideos> getBenefitVideoById(Integer id) {
-        return benefitsVideosMapper.getBenefitVideoById(id);
+    public List<BenefitsVideos> getBenefitVideoById(Integer id, Integer state) {
+        return benefitsVideosMapper.getBenefitVideoById(id, state);
     }
 
     @Override
     public List<BenefitsVideos> getBybIdAndcId(Integer benefitsVideoClassificationId, Integer courseId) {
-        return  benefitsVideosMapper.getBybIdAndcId(benefitsVideoClassificationId,courseId);
+        return benefitsVideosMapper.getBybIdAndcId(benefitsVideoClassificationId, courseId);
     }
 
 

--
Gitblit v1.7.1