From 5839384228e2f10d880d23c7a1c99ba86430634c Mon Sep 17 00:00:00 2001 From: 许鹏程 <1821349743@qq.com> Date: 星期三, 24 五月 2023 14:59:07 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- 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