非管理员查询部门数据

xieb

2024-01-11 85716c6a3f52cb67dbb5afb9cb113a4c17df0e60

非管理员查询部门数据

 src/main/java/org/springblade/modules/assessment/controller/AssessmentScoreController.java

@@ -28,6 +28,7 @@
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.secure.BladeUser;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.constant.BladeConstant;
import org.springblade.core.tool.utils.DateUtil;
@@ -105,10 +106,10 @@
        assessmentScore.setAssessmentTaskId(taskId);

        //增加根据登录用户部门筛选
//        boolean isadmin = AuthUtil.isAdmin();
//        if (!isadmin) {
//            assessmentScore.setDeptName();
//        }
        boolean isadmin = AuthUtil.isAdmin();
        if (!isadmin) {
            assessmentScore.setDeptId(AuthUtil.getDeptId());
        }

        IPage<AssessmentScoreEntity> pages = assessmentScoreService.selectAssessmentScoreGroupByBeidPage(Condition.getPage(query), assessmentScore);


 src/main/java/org/springblade/modules/assessment/mapper/AssessmentScoreMapper.xml

@@ -48,6 +48,9 @@
            <if test="assessmentScore.userName != null and assessmentScore.userName != ''">
                and b.name like concat('%', #{assessmentScore.userName},'%')
            </if>
            <if test="assessmentScore.deptId != null and assessmentScore.deptId != ''">
                and c.id = #{assessmentScore.deptId}
            </if>
            <if test="assessmentScore.deptName != null and assessmentScore.deptName != ''">
                and c.dept_name like concat('%', #{assessmentScore.deptName},'%')
            </if>