From d595e0cb5798a34d53ef9ac9045f07a25795b98f Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期五, 20 十二月 2024 09:56:51 +0800
Subject: [PATCH] 电路试验添加隔离度+端口间隔离度
---
framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java b/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java
index c6db317..045f040 100644
--- a/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java
+++ b/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java
@@ -22,5 +22,14 @@
@Select("select coalesce(count(id), 0) from ${tableName} where create_time like concat('%', #{date}, '%')")
int countRowsByNow(String tableName, String date);
+
+ @Select("select coalesce(count(id), 0) from ${tableName} where examine_time like concat('%', #{date}, '%')")
+ int countRowsByNow2(String tableName, String date);
+
+ @Select("select coalesce(count(id), 0) from ${tableName} where examine_time like concat('%', #{date}, '%') and laboratory=#{laboratory} and company_id=#{companyId}")
+ int countRowsByNow3(String tableName, Long companyId, String laboratory, String date);
+
+ @Select("select coalesce(count(id), 0) from ${tableName} where create_time like concat('%', #{date}, '%') and laboratory=#{laboratory} and company_id=#{companyId}")
+ int countRowsByNow4(String tableName, Long companyId, String laboratory, String date);
}
--
Gitblit v1.9.3