From bc7d9c98bc1b23ef6ef29ed4a6313753f6900640 Mon Sep 17 00:00:00 2001 From: value <z1292839451@163.com> Date: 星期二, 14 五月 2024 02:25:01 +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