From d91f76b90245603c1c7f08e3d5864ada3f3fbba7 Mon Sep 17 00:00:00 2001
From: 晏有为 <13214124+yan-youwei@user.noreply.gitee.com>
Date: 星期一, 27 五月 2024 16:24:37 +0800
Subject: [PATCH] 完成客户管理添加,查询字段优化

---
 framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java |    4 ++++
 1 files changed, 4 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..c6db317 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,8 @@
 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);
 }
 

--
Gitblit v1.9.3