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);
}