From f653130e5df936041f7a5ae005e10c91415b64b1 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期四, 10 七月 2025 15:54:33 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java | 20 -------------------- 1 files changed, 0 insertions(+), 20 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java index f2b91f4..34f0108 100644 --- a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java +++ b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java @@ -1,30 +1,10 @@ package com.zy.asrs.mapper; -import com.zy.asrs.domain.vo.LocChartPie; 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(); - - @Select("select * from asr_loc_use_view") - LocChartPie getLocUseRate(); } -- Gitblit v1.9.1