From 473b5351fbbfd4e5fa4b0f87356253776bfa6da6 Mon Sep 17 00:00:00 2001
From: zhaowenyu <35589726@qq.com>
Date: Mon, 02 Mar 2026 08:25:41 +0800
Subject: [PATCH] 2026-03-02 优化媒体文件查询列表，新增任务名称
---
ard-sample/src/main/java/com/ard/sample/media/mapper/IFileMapper.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/ard-sample/src/main/java/com/ard/sample/media/mapper/IFileMapper.java b/ard-sample/src/main/java/com/ard/sample/media/mapper/IFileMapper.java
index a4c8219..7d4cc6e 100644
--- a/ard-sample/src/main/java/com/ard/sample/media/mapper/IFileMapper.java
+++ b/ard-sample/src/main/java/com/ard/sample/media/mapper/IFileMapper.java
@@ -1,7 +1,11 @@
package com.ard.sample.media.mapper;
+import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ard.sample.media.model.MediaFileEntity;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
/**
* @author sean
@@ -9,4 +13,10 @@
* @date 2021/12/9
*/
public interface IFileMapper extends BaseMapper<MediaFileEntity> {
+
+ @Select("SELECT m.* ,j.name as 'job_name'" +
+ "FROM media_file m " +
+ "left join wayline_job j on j.job_id = m.job_id " +
+ "${ew.customSqlSegment.replace('job_id', 'm.job_id')}")
+ <P extends IPage<MediaFileEntity>> P selectPage(P page, @Param("ew") Wrapper<MediaFileEntity> queryWrapper);
}
--
Gitblit v1.9.3