南昌市物联网技防平台-后台
parent: dee60718 | patch | commit | ignore whitespace
zengh
2021-05-20 795a63d9d39c0040a25b76a43f74a72746913127 
解决客户管理无法查询设备的问题
1 files modified
6 ■■■■■ changed files
blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.xml 6 ●●●●● patch | view | raw | blame | history 
 blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.xml


@@ -35,11 +35,9 @@


        left join


        blade_dept bd


        on


        bt.tenant_id=bd.tenant_id


        bt.tenant_name=bd.dept_name


        where bt.is_deleted = 0


        and bt.tenant_id!=000000


        and bd.dept_category=1


        AND bd.is_deleted = 0


        AND bt.tenant_id != 000000


        <if test="tenant.tenantName!=null and tenant.tenantName!=''">


            and tenant_name=#{tenant.tenantName}


        </if>