From 36ccc814cb2499757a0cfd5525d5e8d0c2309b64 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期三, 27 十一月 2024 16:02:42 +0800 Subject: [PATCH] 企业微信的消息提醒的信息改成单号样品名+检验下单的模版保存,如果存在同名的情况,将原有的情况覆盖掉,并添加提示框+首页展示添加样品名称 --- framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java | 6 ++++++ 1 files changed, 6 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 fb75b18..045f040 100644 --- a/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java +++ b/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java @@ -25,5 +25,11 @@ @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