From 996e076ab3201464086505e08caafa0088eeec34 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期二, 22 四月 2025 10:12:39 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java | 16 ---------------- 1 files changed, 0 insertions(+), 16 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java index aa3770b..34f0108 100644 --- a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java +++ b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java @@ -1,26 +1,10 @@ package com.zy.asrs.mapper; import org.apache.ibatis.annotations.Mapper; -import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; - -import java.util.List; -import java.util.Map; @Mapper @Repository public interface ReportQueryMapper { - - - @Select("select \n" + - "Min(wm.io_time) as node,\n" + - "isnull(count(1), 0) as val\n" + - "from asr_wrk_mast_log wm\n" + - "where wm.wrk_sts = 5 \n" + - "and (wm.io_type = 1 OR wm.io_type = 54)\n" + - "and datediff(d, wm.io_time, getdate())<=7 \n" + - "group by datediff(day,wm.io_time,getdate())\n" + - "order by Min(wm.io_time) asc\n") - List<Map<String, Object>> queryPakinRep(); } -- Gitblit v1.9.1