From f71e39c30acb958181f7198b063633a1110c9a1c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 10 八月 2023 11:32:55 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/mapper/XlsReportMapper.java | 30 +++++++++++++++++++++++++++---
1 files changed, 27 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/yssh/mapper/XlsReportMapper.java b/src/main/java/com/yssh/mapper/XlsReportMapper.java
index 3d24e30..6e023e6 100644
--- a/src/main/java/com/yssh/mapper/XlsReportMapper.java
+++ b/src/main/java/com/yssh/mapper/XlsReportMapper.java
@@ -13,9 +13,33 @@
*/
@Mapper
public interface XlsReportMapper {
- List<XlsReport> selectByPage(@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);
- int xlsExists(@Param("type") String type, @Param("start") String start);
+ /**
+ * 鎶ュ憡鏄惁瀛樺湪
+ */
+ int reportExists(@Param("type") String type, @Param("start") String start);
- int insert(XlsReport xls);
+ /**
+ * 鎻掑叆鎶ュ憡
+ */
+ int insertReport(XlsReport xls);
+
+ /**
+ * 鏌ヨ鏃ュ潎鍊�
+ */
+ 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 selectYearAccumulate(@Param("time") String time, @Param("name") String name);
}
--
Gitblit v1.9.3