From 9e7ee2d8ad0b8684a2e13de7fe7838d79e09478b Mon Sep 17 00:00:00 2001
From: SZH <szh_hello@163.com>
Date: 星期二, 23 八月 2022 16:43:01 +0800
Subject: [PATCH] 修改数据库连接配置 增加环境配置文件
---
equipment/equipment-service/src/main/java/com/gkhy/safePlatform/equipment/repository/EquipmentInfoRepository.java | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/equipment/equipment-service/src/main/java/com/gkhy/safePlatform/equipment/repository/EquipmentInfoRepository.java b/equipment/equipment-service/src/main/java/com/gkhy/safePlatform/equipment/repository/EquipmentInfoRepository.java
index 41cf464..a3b67b6 100644
--- a/equipment/equipment-service/src/main/java/com/gkhy/safePlatform/equipment/repository/EquipmentInfoRepository.java
+++ b/equipment/equipment-service/src/main/java/com/gkhy/safePlatform/equipment/repository/EquipmentInfoRepository.java
@@ -2,6 +2,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gkhy.safePlatform.equipment.entity.EquipmentInfo;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
/**
@@ -13,4 +14,8 @@
@Repository
public interface EquipmentInfoRepository extends BaseMapper<EquipmentInfo> {
+ @Select("<script> select count(1) from equipment_info m INNER JOIN \n" +
+ "(select a.id,max(b.takecare_date) mdate from equipment_info a INNER JOIN equipment_takecare_detail b on a.id = b.equipment_id GROUP BY b.equipment_id) n \n" +
+ "on m.id = n.id where DATEDIFF(NOW(),n.mdate) >m.takecare_cycle</script> ")
+ Object countOverTime();
}
\ No newline at end of file
--
Gitblit v1.9.2