package com.tievd.jyz.mapper;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.tievd.jyz.entity.vo.SysDepartVO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
@Mapper
|
public interface SysDepartVOMapper extends BaseMapper<SysDepartVO> {
|
|
/**
|
* 自定义查询
|
* @param page
|
* @param queryWrapper
|
* @return
|
*/
|
@Select("select a.*, sd.depart_name parentName from (select * from sys_depart ${ew.customSqlSegment}) a left join sys_depart sd on a.parent_id = sd.id")
|
IPage<SysDepartVO> tables(Page page, @Param("ew") QueryWrapper queryWrapper);
|
}
|
