From 2f65a830dcbea60c4e1854cd08a59410c68db724 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期三, 02 七月 2025 16:16:04 +0800
Subject: [PATCH] 视频搜索接口，视频es索引加发布时间字段，重构视频es索引的sql完善
---
framework/src/main/java/cn/lili/modules/lmk/mapper/VideoMapper.java | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 51 insertions(+), 8 deletions(-)
diff --git a/framework/src/main/java/cn/lili/modules/lmk/mapper/VideoMapper.java b/framework/src/main/java/cn/lili/modules/lmk/mapper/VideoMapper.java
index 2b91e57..252babb 100644
--- a/framework/src/main/java/cn/lili/modules/lmk/mapper/VideoMapper.java
+++ b/framework/src/main/java/cn/lili/modules/lmk/mapper/VideoMapper.java
@@ -1,13 +1,9 @@
package cn.lili.modules.lmk.mapper;
import cn.lili.modules.lmk.domain.entity.Video;
-import cn.lili.modules.lmk.domain.query.AuthorVideoQuery;
-import cn.lili.modules.lmk.domain.query.ManagerVideoQuery;
-import cn.lili.modules.lmk.domain.query.VideoQuery;
-import cn.lili.modules.lmk.domain.vo.CollectTypeNumVO;
-import cn.lili.modules.lmk.domain.vo.VideoAccountVO;
-import cn.lili.modules.lmk.domain.vo.VideoVO;
-import cn.lili.modules.lmk.domain.vo.WxEditVideoVO;
+import cn.lili.modules.lmk.domain.es.VideoIndex;
+import cn.lili.modules.lmk.domain.query.*;
+import cn.lili.modules.lmk.domain.vo.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Mapper;
@@ -49,7 +45,12 @@
*
* @return
*/
- IPage recommendVideo(IPage page);
+ IPage recommendVideo(IPage page, @Param("query") VideoQuery query);
+
+ IPage recommendHealthVideo(IPage page, @Param("query") WxHealthVideoQuery query);
+
+
+ IPage wxKitchenVideoQuery(IPage page, @Param("query") WxKitchenVideoQuery query);
/**
* 鎵归噺鏇存柊瑙嗛鏀惰棌鏁伴噺
@@ -64,6 +65,13 @@
* @param numList
*/
void updateCommentNumBatch(@Param("list") List<CollectTypeNumVO> numList);
+
+ /**
+ * 鎵归噺鏇存柊瑙嗛鐐硅禐鏁�
+ *
+ * @param numList
+ */
+ void updateThumbsUpNumBatch(@Param("list") List<CollectTypeNumVO> numList);
/**
* 瑙嗛涓婚〉浣滆�呬俊鎭�
@@ -106,10 +114,45 @@
IPage getAuthorCollectVideoPage(IPage page, @Param("query") AuthorVideoQuery query);
/**
+ * 鑾峰彇瑙嗛涓婚〉浣滆�呯偣璧炵殑瑙嗛鍒嗛〉
+ *
+ * @param page
+ * @param query
+ */
+ IPage getAuthorLikeVideoPage(IPage page, @Param("query") AuthorVideoQuery query);
+
+ /**
* 灏忕▼搴�-瑙嗛璇︽儏
*
* @param id
* @return
*/
WxEditVideoVO wxDetail(@Param("id") String id);
+
+ /**
+ * 澶у仴搴疯棰戝垎椤�
+ *
+ * @param page
+ * @param query
+ */
+ IPage healthPage(IPage page, @Param("query") HealthVideoQuery query);
+
+ IPage kitchenPage(IPage page, @Param("query") KitchenVideoQuery query);
+
+ /**
+ * 鑾峰彇瑙嗛鎮寕鍟嗗搧
+ *
+ * @param videoId
+ * @return
+ */
+ List<VideoGoodsDetailVO> getVideoGoods(@Param("id") String videoId);
+
+ /**
+ * es鍚屾鏌ヨ瑙嗛鏁版嵁
+ *
+ * @param start 寮�濮嬩綅缃�
+ * @param pageSize 姣忛〉鏉℃暟
+ * @return
+ */
+ List<VideoIndex> getEsPage(@Param("start") int start, @Param("pageSize") int pageSize);
}
--
Gitblit v1.8.0