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
|
* @version 0.2
|
* @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);
|
}
|
