package com.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface UserMapper extends BaseMapper<User> {

    @Select("SELECT u.*, d.dept_name FROM sys_user u LEFT JOIN sys_department d ON u.dept_code = d.dept_code WHERE u.deleted = 0 AND u.id = #{id}")
    User selectUserWithDeptById(@Param("id") Long id);

    IPage<User> selectUserPage(Page<User> page, @Param("username") String username, @Param("realName") String realName, @Param("deptCode") String deptCode, @Param("permissionDeptCodes") List<String> permissionDeptCodes);

    @Select("SELECT * FROM sys_user WHERE deleted = 0 AND dept_code = #{deptCode}")
    List<User> selectByDeptCode(@Param("deptCode") String deptCode);
}