From 208d2d08a381a787e1030328319132de5d92a7cc Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 10 八月 2023 12:25:46 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/mapper/XlsReportMapper.java | 6 ++++++
src/main/resources/mapper/XlsReportMapper.xml | 8 ++++++++
2 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/yssh/mapper/XlsReportMapper.java b/src/main/java/com/yssh/mapper/XlsReportMapper.java
index 6e023e6..6694a3d 100644
--- a/src/main/java/com/yssh/mapper/XlsReportMapper.java
+++ b/src/main/java/com/yssh/mapper/XlsReportMapper.java
@@ -1,5 +1,6 @@
package com.yssh.mapper;
+import com.yssh.entity.SuYuan700;
import com.yssh.entity.xls.XlsReport;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@@ -42,4 +43,9 @@
* 鏌ヨ骞寸疮璁″��
*/
double selectYearAccumulate(@Param("time") String time, @Param("name") String name);
+
+ /**
+ * 鏍规嵁鏃堕棿鏌ヨ婧簮
+ */
+ List<SuYuan700> selectSuYuanByTime(@Param("id") String id, @Param("start") Integer start, @Param("end") Integer end);
}
diff --git a/src/main/resources/mapper/XlsReportMapper.xml b/src/main/resources/mapper/XlsReportMapper.xml
index 1bd4f46..2ac8e08 100644
--- a/src/main/resources/mapper/XlsReportMapper.xml
+++ b/src/main/resources/mapper/XlsReportMapper.xml
@@ -63,4 +63,12 @@
from yssh_qxsh
where time like #{time} and name = #{name};
</select>
+
+ <!-- 鏍规嵁鏃堕棿鏌ヨ婧簮 -->
+ <select id="selectSuYuanByTime" resultType="com.yssh.entity.SuYuan700">
+ select *
+ from suyuan_46
+ where su_yuan_id = #{id} and create_time between #{start} and #{end}
+ order by time;
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3