任务管理辖区过滤

tangzy

2022-02-18 8cb60525cb924b795392d5661d74732fec7bacbb

任务管理辖区过滤

 src/main/java/org/springblade/modules/auth/utils/TokenUtil.java

@@ -104,6 +104,7 @@
                .set(TokenConstant.DEPT_ID, user.getDeptId())
                .set(TokenConstant.POST_ID, user.getPostId())
                .set(TokenConstant.ROLE_ID, user.getRoleId())
                .set("jurisdiction", user.getJurisdiction())
                .set(TokenConstant.OAUTH_ID, userInfo.getOauthId())
                .set(TokenConstant.ACCOUNT, user.getAccount())
                .set(TokenConstant.USER_NAME, user.getAccount())

 src/main/java/org/springblade/modules/taskqd/mapper/TaskqdMapper.xml

@@ -55,19 +55,19 @@

    <select id="selectLi" resultMap="taskResultMap">
        SELECT A.*,IFNULL(B.num,0) as nums FROM (
        select qd.* from sys_taskqd qd LEFT JOIN sys_jurisdiction j ON j.id = qd.jurisdiction where 1=1
        select qd.* from sys_taskqd qd LEFT JOIN sys_jurisdiction j ON j.id = qd.jurisdiction where 1=1 AND qd.jnum!=qd.num
        <if test="type==0">
            and find_in_set(#{serid}, serid)) A LEFT JOIN (SELECT COUNT(*) as num,hdid,serid FROM sys_taskfk WHERE
            serid=#{serid} GROUP BY hdid,serid) B ON A.id=B.hdid
        </if>
        <if test="type==1">
            <if test="jurisdiction!=null and jurisdiction!=''">
            <if test="jurisdiction!=null and jurisdiction!='' and jurisdiction!='1372091709474910209'">
                and (j.id =#{jurisdiction} or
                j.parent_id = #{jurisdiction}) AND qd.jnum!=qd.num
                j.parent_id = #{jurisdiction})
            </if>
            ) A LEFT JOIN (SELECT
            COUNT(*)
            as num,hdid,serid FROM sys_taskfk GROUP BY hdid,serid) B ON A.id=B.hdid
            as num,hdid FROM sys_taskfk GROUP BY hdid) B ON A.id=B.hdid
        </if>
    </select>
</mapper>