com.nb6868.onex.uc.dao.DeptDao Maven / Gradle / Ivy

Go to download
package com.nb6868.onex.uc.dao;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.nb6868.onex.common.jpa.BaseDao;
import com.nb6868.onex.uc.entity.DeptEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Mapper;

import java.io.Serializable;
import java.util.List;
import java.util.Map;

/**
 * 部门管理
 *
 * @author Charles [email protected]
 */
@Mapper
public interface DeptDao extends BaseDao {

    @Select("select uc_dept.*, " +
            "(select parent.name from uc_dept parent where parent.deleted = 0 and parent.id = uc_dept.pid) parentName from uc_dept " +
            "${ew.customSqlSegment}")
    @Override
    > E selectPage(E page, Wrapper ew);

    @Select("select uc_dept.*, " +
            "(select parent.name from uc_dept parent where parent.deleted = 0 and parent.id = uc_dept.pid) parentName from uc_dept " +
            "${ew.customSqlSegment}")
    List selectList(Map params);

    @Override
    @Select("select t1.*, (select t2.name from uc_dept t2 where t2.deleted = 0 and t2.id = t1.pid) parentName" +
            " from uc_dept t1" +
            " where t1.deleted = 0 and t1.id = #{id}")
    DeptEntity selectById(@Param("id") Serializable id);

    /**
     * 获取所有部门的id、pid列表
     */
    @Select("select t1.id, t1.pid from uc_dept t1 where t1.deleted = 0")
    List getIdAndPidList();

    /**
     * 根据部门ID，获取所有子部门ID列表
     * @param id   部门ID
     */
    @Select("select id from uc_dept where deleted = 0 and pids like #{id}")
    List getSubDeptIdList(@Param("id") String id);

}