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.SysUserVO;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
@Mapper
|
public interface SysUserVOMapper extends BaseMapper<SysUserVO> {
|
|
@Select("select su.*, sr.id roleId, sr.role_name roleName, sd.id departId, sd.depart_name departName from sys_user su left join sys_user_role sur on su.id = sur.user_id left join sys_role sr on sur.role_id = sr.id left join sys_user_depart sud on sud.user_id = su.id left join sys_depart sd on sud.dep_id = sd.id ${ew.customSqlSegment}")
|
IPage<SysUserVO> tables(Page<SysUserVO> page, @Param("ew") QueryWrapper<SysUserVO> queryWrapper);
|
|
@Delete("delete from sys_user where org_code like concat(#{orgCode}, '%')")
|
void physicalRemove(@Param("orgCode") String orgCode);
|
}
|
