From 2f55cebbad3dea187a5f91d16ec80a9677dab699 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 13 十一月 2024 11:16:53 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/mapper/XlsReportMapper.java | 28 +++++++++++++++++++---------
1 files changed, 19 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/yssh/mapper/XlsReportMapper.java b/src/main/java/com/yssh/mapper/XlsReportMapper.java
index 87db22b..46a61df 100644
--- a/src/main/java/com/yssh/mapper/XlsReportMapper.java
+++ b/src/main/java/com/yssh/mapper/XlsReportMapper.java
@@ -7,22 +7,27 @@
import java.util.List;
-/**
- * XlsReportMapper
- * @author WWW
- * @date 2023-08-09
- */
@Mapper
public interface XlsReportMapper {
+ /**
+ * 鏌ヨ鎶ュ憡璁板綍鏁�
+ */
+ Integer selectReportCount(@Param("type") String type, @Param("start") String start, @Param("end") String end, @Param("limit") Integer limit, @Param("offset") Integer offset);
+
/**
* 鍒嗛〉鏌ヨ鎶ュ憡
*/
List<XlsReport> selectReportByPage(@Param("type") String type, @Param("start") String start, @Param("end") String end, @Param("limit") Integer limit, @Param("offset") Integer offset);
/**
+ * 鏍规嵁ID鏌ヨ鎶ュ憡
+ */
+ XlsReport selectById(@Param("id") Integer id);
+
+ /**
* 鎶ュ憡鏄惁瀛樺湪
*/
- int reportExists(@Param("type") String type, @Param("start") String start);
+ int reportExists(@Param("type") String type, @Param("name") String name);
/**
* 鎻掑叆鎶ュ憡
@@ -32,20 +37,25 @@
/**
* 鏌ヨ鏃ュ潎鍊�
*/
- Double selectDayAvg(@Param("time") String time, @Param("name") String name);
+ double selectDayAvg(@Param("time") String time, @Param("name") String name);
/**
* 鏌ヨ绱鍊�
*/
- Double selectAccumulate(@Param("start") Integer start, @Param("end") Integer end, @Param("name") String name);
+ double selectAccumulate(@Param("start") Integer start, @Param("end") Integer end, @Param("name") String name);
/**
* 鏌ヨ骞寸疮璁″��
*/
- Double selectYearAccumulate(@Param("time") String time, @Param("name") String name);
+ double selectYearAccumulate(@Param("time") String time, @Param("name") String name);
/**
* 鏍规嵁鏃堕棿鏌ヨ婧簮
*/
List<SuYuan700> selectSuYuanByTime(@Param("id") String id, @Param("start") String start, @Param("end") String end);
+
+ /**
+ * 鏍规嵁鏃堕棿娈垫煡璇㈡函婧�
+ */
+ List<SuYuan700> selectSuYuanByStartAndEnd(@Param("id") String id, @Param("name") String name, @Param("yjz") double yjz, @Param("start") Integer start, @Param("end") Integer end);
}
--
Gitblit v1.9.3