From 87794ed4e7b7cf7b13f7deef5da3e3ff03255d81 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期日, 04 八月 2024 23:01:09 +0800
Subject: [PATCH] 检验任务负责人展示修改
---
framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java | 13 +++++++++++++
1 files changed, 13 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 c57f37b..045f040 100644
--- a/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java
+++ b/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java
@@ -7,6 +7,7 @@
import com.yuanchu.mom.pojo.PageSystemLogDto;
import com.yuanchu.mom.pojo.SystemLog;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
/**
* 绯荤粺鏃ュ織(SystemLog)琛ㄦ暟鎹簱璁块棶灞�
@@ -18,5 +19,17 @@
public interface SystemLogMapper extends BaseMapper<SystemLog> {
IPage<PageSystemLogDto> selectSystemLogList(Page page, QueryWrapper<PageSystemLogDto> ew);
+
+ @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