src/modules/report/service/tasksiteservice.ts
@@ -42,6 +42,7 @@ .select([ 'site.id AS siteId', // 拿最新的自增ID作为每日表的 siteId 'site.businessName AS siteName', // 永远拿当前后台最新的站点名称,防止设备传旧名称 'site.departmentId AS departmentId', 'weight.weight AS weight', 'weight.garbageType AS garbageType' ]) @@ -74,6 +75,7 @@ date: targetDate, siteId: siteId, siteName: row.siteName, departmentId:row.departmentId, weightTotal: 0, timeTotal: 0, carbonTotal: 0 }; // 动态初始化宽表里各子类型的 0 值