查询部门id

wl

2022-10-28 7ec36eee3bae7b9efa32dba01776f5760d91b81a

查询部门id

 ycl-common/src/main/java/com/ycl/entity/user/UmsAdmin.java

@@ -80,6 +80,10 @@
    @TableField(exist = false)
    private String departName;

    @ApiModelProperty(value = "部门id")
    @TableField(exist = false)
    private String departmentId;

    @ApiModelProperty(value = "用户类型")
    private Integer userType;


 ycl-common/src/main/resources/mapper/user/UmsAdminMapper.xml

@@ -61,6 +61,7 @@
        <result column="is_dy" property="isDy"/>
        <result column="job_title" property="jobTitle"/>
        <result column="depart_name" property="departName"/>
        <result column="departmentId" property="departmentId"/>
        <result column="user_type" property="userType"/>
        <result column="zj" property="zj"/>
        <result column="mobile" property="mobile"/>
@@ -85,7 +86,8 @@
    </select>
    <select id="selectPageByWordKey" resultMap="adminMap">
        SELECT t1.*,
        t3.depart_name
        t3.depart_name,
        t3.id as departmentId
        FROM `ums_admin` t1
        LEFT JOIN ums_depart_manager t2 ON t1.id = t2.user_id
        LEFT JOIN ums_depart t3 ON t2.depart_id = t3.id