服务派遣统计接口修改

Administrator

2021-12-04 7690d03283226b22cb78a35137c5e1d493384be1

服务派遣统计接口修改

 src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml

@@ -1354,9 +1354,13 @@
        GROUP BY
        dept_id
        ) J ON J.dept_id = H.departmentid
        left join
        sys_jurisdiction sj
        on
        sj.id = H.jurisdiction
        WHERE 1 = 1
        <if test="jurisdiction!=null and jurisdiction!='' and jurisdiction!='1372091709474910209'">
            AND H.jurisdiction in(${jurisdiction})
            AND (sj.id = #{jurisdiction} or sj.parent_id = #{jurisdiction})
        </if>
        <if test="deptid!=null and deptid!=''">
            AND H.departmentid = #{deptid}
@@ -3009,7 +3013,7 @@
            and (sj.id = #{information.jurisdiction} or sj.parent_id = #{information.jurisdiction})
        </if>
        ) b
        where b.znum &lt; 2
        where b.znum &lt; #{information.proportion}
        <if test="information.departmentid!=null and information.departmentid!=''">
            and b.departmentid = #{information.departmentid}
        </if>