diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml index 1dc9ba6..1791329 100644 --- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml +++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml @@ -122,7 +122,7 @@ INNER JOIN ter_device_info di ON t.sn = di.sn WHERE - di.project_code = #{projectCode} + di.project_code = #{projectCode} AND t.date >= di.first_warn_datetime GROUP BY di.project_code, YEAR(t.date),