一、该问题的重现步骤是什么?
在application.yml添加了表名可以根据用户的租户id插入对应的租户数据,我自定义的sql中我希望我的管理账号查询数据时不插入当前管理账号的租户id,
下面是生成的sql
SELECT a.company_name, a.District, COALESCE(SUM(a.quota), 0) AS totalSum, REPLACE(FORMAT(COALESCE(SUM(c.TotalUseEnergy), 0), 2), ',', '') AS totalEnergySum FROM blade_company a LEFT JOIN (SELECT tenant_id, SUM(use_energy) AS TotalUseEnergy FROM blade_carbon_data WHERE is_deleted = 0 AND YEAR(create_time) = ? AND tenant_id = '000000' GROUP BY tenant_id) c ON a.tenant_id = c.tenant_id WHERE a.District LIKE ? GROUP BY a.company_name, a.District
2.
TenantUtil.ignore(()->);忽略提示问题
一个
TenantUtil.ignore(()->
List
);接收的List报错
换成
TenantUtil.ignore(()->
companyService.getUseEnergy(year,month,userId);
);
提示没有入参
3.
二、你期待的结果是什么?实际看到的又是什么?
我期待的效果是
SELECT a.company_name, a.District, COALESCE(SUM(a.quota), 0) AS totalSum, REPLACE(FORMAT(COALESCE(SUM(c.TotalUseEnergy), 0), 2), ',', '') AS totalEnergySum FROM blade_company a LEFT JOIN (SELECT tenant_id, SUM(use_energy) AS TotalUseEnergy FROM blade_carbon_data WHERE is_deleted = 0 AND YEAR(create_time) = ? GROUP BY tenant_id) c ON a.tenant_id = c.tenant_id WHERE a.District LIKE ? GROUP BY a.company_name, a.District
三、你正在使用的是什么产品,什么版本?在什么操作系统上?
四、请提供详细的错误堆栈信息,这很重要。
五、若有更多详细信息,请在下面提供。