错误 #18098
1.进入能耗费用报表-单个租户
2.查看租户名称下拉框数据
期望结果:
1.租户名称下拉框显示所有状态的数据
实际结果:
1.租户总数共45条,单个租户报表页面-租户名称下拉框只显示了39条数据
select cons.project_id,cons.id,cons.status,tec.id,tec.name from
yl_tenant_energy_charge.tec_contract cons
join yl_tenant_energy_charge.tec_tenant tec on cons.tenant_id=tec.id
where cons.project_id='Pj1101110005'
2.查看租户名称下拉框数据
期望结果:
1.租户名称下拉框显示所有状态的数据
实际结果:
1.租户总数共45条,单个租户报表页面-租户名称下拉框只显示了39条数据
select cons.project_id,cons.id,cons.status,tec.id,tec.name from
yl_tenant_energy_charge.tec_contract cons
join yl_tenant_energy_charge.tec_tenant tec on cons.tenant_id=tec.id
where cons.project_id='Pj1101110005'