| | |
| | | service: BasicdataIotService, |
| | | pageQueryOp: { |
| | | keyWordLikeFields: ['a.iotName', 'a.iotCode'], |
| | | fieldEq: ['a.iotTypeCode', 'a.status', 'a.departmentName'], |
| | | fieldEq: ['a.iotTypeCode', 'a.status', 'a.departmentId'], |
| | | select: ['a.*', 'b.name AS departmentName'], |
| | | join: [ |
| | | { |
| | |
| | | 'd.businessName AS businessName', 'd.siteType AS siteType', // 垃圾名称 |
| | | |
| | | ], |
| | | fieldEq: ['d.siteType'], |
| | | fieldEq: ['d.siteType', 'a.departmentId'], |
| | | fieldLike: ['a.deviceNo'], |
| | | join: [ |
| | | { |
| | |
| | | service: PushVehicleGpsService, |
| | | pageQueryOp: { |
| | | keyWordLikeFields: ['a.sn', 'a.vehicleNo'], |
| | | fieldEq: ['a.status'], |
| | | fieldEq: ['a.status', 'a.departmentId'], |
| | | select: ['a.*', 'b.name AS departmentName'], |
| | | join: [ |
| | | { |
| | |
| | | service: ReportDailysiteService, |
| | | pageQueryOp: { |
| | | keyWordLikeFields: ['a.siteName'], |
| | | fieldEq: ['a.date', 'a.siteId'], |
| | | fieldEq: ['a.date', 'a.siteId', 'a.departmentId'], |
| | | select: ['a.*', 'b.name AS departmentName'], |
| | | join: [ |
| | | { |
| | |
| | | service: ReportDailySorterService, |
| | | pageQueryOp: { |
| | | keyWordLikeFields: ['a.businessName', 'a.businessId'], |
| | | fieldEq: ['a.date', 'a.businessId', 'a.attendanceStatus'], |
| | | fieldEq: ['a.date', 'a.businessId', 'a.attendanceStatus', 'a.departmentId'], |
| | | select: ['a.*'], |
| | | where: async ctx => { |
| | | const conditions: any[][] = []; |
| | |
| | | service: ReportDailyVehicleService, |
| | | pageQueryOp: { |
| | | keyWordLikeFields: ['a.vehicleNo'], |
| | | fieldEq: ['a.date', 'a.vehicleNo'], |
| | | fieldEq: ['a.date', 'a.vehicleNo', 'a.departmentId'], |
| | | select: ['a.*', 'b.name AS departmentName'], |
| | | join: [ |
| | | { |