fix(bug修复): 用户部门显示allDeptName
| | |
| | | @TableField(exist = false) |
| | | private String deptIds; |
| | | |
| | | @TableField(exist = false) |
| | | private String allDeptName; |
| | | } |
| | |
| | | @ExcelField(value = "护卫点(部门)") |
| | | @TableField("allDeptName") |
| | | private String allDeptName = ""; |
| | | |
| | | // @FieldInfo(name = "dimissRemark", type = "varchar", explain = "离职备注") |
| | | // @TableField("dimissRemark") |
| | | // private String dimissRemark = ""; |
| | | } |
| | |
| | | u.avatar, |
| | | d.dept_name deptName, |
| | | GROUP_CONCAT(r.role_id) roleId, |
| | | GROUP_CONCAT(r.role_name) roleName |
| | | GROUP_CONCAT(r.role_name) roleName, |
| | | d.allDeptName |
| | | FROM |
| | | t_user u |
| | | LEFT JOIN t_dept d ON (u.dept_id = d.dept_id) |