From ad4a2b67db73e07992aee0b51493495c63d10bc4 Mon Sep 17 00:00:00 2001 From: shichongfu <shi_chongfu@163.com> Date: 星期三, 24 五月 2023 09:22:26 +0800 Subject: [PATCH] 人员信息 个人信息 --- product-server-admin/src/main/java/com/product/admin/service/PersonalCenterService.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/product-server-admin/src/main/java/com/product/admin/service/PersonalCenterService.java b/product-server-admin/src/main/java/com/product/admin/service/PersonalCenterService.java index 44c09d8..f23d09d 100644 --- a/product-server-admin/src/main/java/com/product/admin/service/PersonalCenterService.java +++ b/product-server-admin/src/main/java/com/product/admin/service/PersonalCenterService.java @@ -98,7 +98,7 @@ StringBuilder sql = new StringBuilder(); SystemUser currentUser = SpringMVCContextHolder.getCurrentUser(); if (!currentUser.isManager()) { - sql.append("\n SELECT b.user_phone_number,b.user_primary_email,b.user_name,a.sex,b.user_id,b.user_signature,b.thumbnail_img,c.job_post_name,d.org_level_name dept_name,d.uuid dept_uuid,d.org_level_uuid,d.org_level_all ,e.org_level_name company_name FROM product_sys_staffs a "); + sql.append("\n SELECT b.gender, b.user_phone_number,b.user_primary_email,b.user_name,a.sex,b.user_id,b.user_signature,b.thumbnail_img,c.job_post_name,d.org_level_name dept_name,d.uuid dept_uuid,d.org_level_uuid,d.org_level_all ,e.org_level_name company_name FROM product_sys_staffs a "); sql.append("\n join product_sys_users b on a.user_id=b.user_id and a.user_id=? "); sql.append("\n join product_sys_job_posts c on a.job_post_uuid=c.uuid "); sql.append("\n join product_sys_org_levels d on d.uuid=a.dept_uuid "); -- Gitblit v1.9.2