From 0ab71d4f9154dc2a0306ea57ec08659f4e28e449 Mon Sep 17 00:00:00 2001
From: Xiajijian <1176061145@qq.com>
Date: Mon, 16 Mar 2026 16:04:06 +0800
Subject: [PATCH] 1. 智云3.0业务优化,优化类型获取。

---
 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