错误 #17729
+1新增租户合同—租赁铺位及仪表信息—当前可用租赁空间数据总量与数据库查询结果不一致
0%
描述
前置条件:
1.入口:租户能源收费—租户管理
2.测试账号:qibei0013/123456qwe
3.测试项目:万科群岛
操作步骤:
1.点击新增租户合同进入新增页面
2.查看getRoomList返回铺位总量与数据库查询结果对比
预期结果:
与数据库查询结果一致,当前可用铺位数量应为62
实际结果:
与数据库查询结果不一致,当前可用铺位数量应为75
#查询指定项目下,租赁空间状态及可租赁状态均为1且空间下的设备为电\水\燃气的空间信息
select * from dt_relation where project_id='Pj1101110005' and rel_code='Eq2Sp' and valid='1' and obj_to
in (select id FROM dt_object WHERE project_id='Pj1101110005' and obj_type='space' and JSON_UNQUOTE(infos-> '$.isLeasableZone') = '1' and JSON_UNQUOTE(infos-> '$.isLeasableState') = '1') and
obj_from in (select id from dc_dic_yl.dt_object obj where obj.obj_type='equipment' and obj.class_code in('WESSFL','WESSEE') and obj.project_id='Pj1101110005')
#查询已绑定合同的铺位信息
select * from tenant_energy_charge_yl.tec_contract_room_rel where project_id='Pj1101110005'
and room_id in (select t.obj_to from (select * from dc_dic_yl.dt_relation rela
where rela.project_id='Pj1101110005' and rela.rel_code='Eq2Sp'
and rela.obj_from in (select id from dc_dic_yl.dt_object obj where obj.obj_type='equipment' and obj.class_code in('WESSFL','WESSEE') and obj.project_id='Pj1101110005' ))t)
文件