From d1f26741bddf6f512d62c0100d42c52be8d37e76 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期六, 06 二月 2021 15:35:40 +0800
Subject: [PATCH] 工具类优化
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ExtractAuditRecordMapper.java | 303 +++++++++++++++++++++++++++-----------------------
1 files changed, 162 insertions(+), 141 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ExtractAuditRecordMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ExtractAuditRecordMapper.java
index aa2e866..47dbff4 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ExtractAuditRecordMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/ExtractAuditRecordMapper.java
@@ -1,141 +1,162 @@
-package com.yeshi.fanli.dao.mybatis;
-
-import java.util.List;
-
-import org.apache.ibatis.annotations.Param;
-
-import com.yeshi.fanli.entity.bus.user.ExtractAuditRecord;
-
-public interface ExtractAuditRecordMapper {
-
- int deleteByPrimaryKey(Long id);
-
- int insert(ExtractAuditRecord record);
-
- int insertSelective(ExtractAuditRecord record);
-
- ExtractAuditRecord selectByPrimaryKey(Long id);
-
- int updateByPrimaryKeySelective(ExtractAuditRecord record);
-
- int updateByPrimaryKey(ExtractAuditRecord record);
-
- List<ExtractAuditRecord> getbyExtractId(Long extractId);
-
- List<ExtractAuditRecord> getListbyExtractId(Long extractId);
-
-
- /**
- * 鏌ヨ鎵�鏈夋彁鐜拌褰曚俊鎭�
- *
- * @param start
- * @param count
- * @param title
- * @param startTime
- * @param endTime
- * @return
- */
- List<ExtractAuditRecord> getList(@Param("start") long start,
- @Param("count") int count, @Param("key") String title,
- @Param("startTime") String startTime,
- @Param("endTime") String endTime);
-
- /**
- * 鏌ヨ鎵�鏈夋彁鐜拌褰曚俊鎭�昏鏁�
- *
- * @param title
- * @param startTime
- * @param endTime
- * @return
- */
- int getCount(@Param("key") String title,
- @Param("startTime") String startTime,
- @Param("endTime") String endTime);
-
- /**
- * 鏌ヨ褰撳墠瀹㈡湇瀹℃壒鐨勬墍鏈夎褰�
- *
- * @param start
- * @param count
- * @param title
- * @param state
- * @return
- */
- List<ExtractAuditRecord> getMyAuditedAllList(@Param("start") int start,
- @Param("count") int count, @Param("key") String title,
- @Param("state") Integer state, @Param("adminId") Long adminId);
-
- /**
- * 褰撳墠瀹㈡湇瀹℃壒鎬绘暟
- *
- * @param title
- * @param state
- * @param adminId
- * @return
- */
- int getMyAuditedAllCount(@Param("key") String title,
- @Param("state") Integer state, @Param("adminId") Long adminId);
-
- /**
- * 鏌ヨ褰撳墠瀹㈡湇瀹℃壒鐨勬椂闂存鍐呰褰�
- *
- * @param start
- * @param count
- * @param title
- * @param state
- * @return
- */
- List<ExtractAuditRecord> getMyAuditedTimeSlotList(@Param("start") int start, @Param("count") int count,
- @Param("key") String title, @Param("state") Integer state, @Param("adminId") Long adminId,
- @Param("days") Integer days);
-
-
- /**
- * 鏌ヨ褰撳墠瀹㈡湇瀹℃壒鐨勬椂闂存鍐呮�绘潯鏁�
- * @param title
- * @param state
- * @param adminId
- * @return
- */
- int getMyAuditedTimeSlotCount(@Param("key") String title, @Param("state") Integer state,
- @Param("adminId") Long adminId,@Param("days") Integer days);
-
-
- /**
- * 鏌ヨ褰撳墠瀹㈡湇绱鏈懆
- * @param adminId
- * @return
- */
- int getMyAuditedCountWeek(@Param("adminId") Long adminId);
-
- /**
- * 鏌ヨ褰撳墠瀹㈡湇绱鏈湀
- * @param adminId
- * @return
- */
- int getMyAuditedCountMonth(@Param("adminId") Long adminId);
-
- /**
- * 鏌ヨ褰撳墠瀹㈡湇褰撴棩澶勭悊绱
- * @param adminId
- * @return
- */
- int getMyAuditedCountToday(@Param("adminId") Long adminId);
-
-
- /**
- * 鏌ヨ璐︽埛鎻愮幇璁板綍淇℃伅
- *
- */
- List<ExtractAuditRecord> getByUidList(@Param("start") int start,
- @Param("count") int count, @Param("uid") Long uid);
-
- /**
- * 鏌ヨ璐︽埛鎻愮幇璁板綍淇℃伅
- *
- */
- int getByUidCount(@Param("uid") Long uid);
-
-
-
-}
+package com.yeshi.fanli.dao.mybatis;
+
+import java.math.BigDecimal;
+import java.util.List;
+
+import org.apache.ibatis.annotations.Param;
+
+import com.yeshi.fanli.entity.bus.user.ExtractAuditRecord;
+
+public interface ExtractAuditRecordMapper {
+
+ int deleteByPrimaryKey(Long id);
+
+ int insert(ExtractAuditRecord record);
+
+ int insertSelective(ExtractAuditRecord record);
+
+ ExtractAuditRecord selectByPrimaryKey(Long id);
+
+ int updateByPrimaryKeySelective(ExtractAuditRecord record);
+
+ int updateByPrimaryKey(ExtractAuditRecord record);
+
+ List<ExtractAuditRecord> getbyExtractId(Long extractId);
+
+ List<ExtractAuditRecord> getListbyExtractId(Long extractId);
+
+
+ /**
+ * 鏌ヨ鎵�鏈夋彁鐜拌褰曚俊鎭�
+ *
+ * @param start
+ * @param count
+ * @param title
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ List<ExtractAuditRecord> getList(@Param("start") long start,
+ @Param("count") int count, @Param("key") String title,
+ @Param("startTime") String startTime,
+ @Param("endTime") String endTime);
+
+ /**
+ * 鏌ヨ鎵�鏈夋彁鐜拌褰曚俊鎭�昏鏁�
+ *
+ * @param title
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ int getCount(@Param("key") String title,
+ @Param("startTime") String startTime,
+ @Param("endTime") String endTime);
+
+ /**
+ * 鏌ヨ褰撳墠瀹㈡湇瀹℃壒鐨勬墍鏈夎褰�
+ *
+ * @param start
+ * @param count
+ * @param title
+ * @param state
+ * @return
+ */
+ List<ExtractAuditRecord> getMyAuditedAllList(@Param("start") int start,
+ @Param("count") int count, @Param("key") String title,
+ @Param("state") Integer state, @Param("adminId") Long adminId);
+
+ /**
+ * 褰撳墠瀹㈡湇瀹℃壒鎬绘暟
+ *
+ * @param title
+ * @param state
+ * @param adminId
+ * @return
+ */
+ int getMyAuditedAllCount(@Param("key") String title,
+ @Param("state") Integer state, @Param("adminId") Long adminId);
+
+ /**
+ * 鏌ヨ褰撳墠瀹㈡湇瀹℃壒鐨勬椂闂存鍐呰褰�
+ *
+ * @param start
+ * @param count
+ * @param title
+ * @param state
+ * @return
+ */
+ List<ExtractAuditRecord> getMyAuditedTimeSlotList(@Param("start") int start, @Param("count") int count,
+ @Param("key") String title, @Param("state") Integer state, @Param("adminId") Long adminId,
+ @Param("days") Integer days);
+
+
+ /**
+ * 鏌ヨ褰撳墠瀹㈡湇瀹℃壒鐨勬椂闂存鍐呮�绘潯鏁�
+ * @param title
+ * @param state
+ * @param adminId
+ * @return
+ */
+ int getMyAuditedTimeSlotCount(@Param("key") String title, @Param("state") Integer state,
+ @Param("adminId") Long adminId,@Param("days") Integer days);
+
+
+ /**
+ * 鏌ヨ褰撳墠瀹㈡湇绱鏈懆
+ * @param adminId
+ * @return
+ */
+ int getMyAuditedCountWeek(@Param("adminId") Long adminId);
+
+ /**
+ * 鏌ヨ褰撳墠瀹㈡湇绱鏈湀
+ * @param adminId
+ * @return
+ */
+ int getMyAuditedCountMonth(@Param("adminId") Long adminId);
+
+ /**
+ * 鏌ヨ褰撳墠瀹㈡湇褰撴棩澶勭悊绱
+ * @param adminId
+ * @return
+ */
+ int getMyAuditedCountToday(@Param("adminId") Long adminId);
+
+
+ /**
+ * 鏌ヨ璐︽埛鎻愮幇璁板綍淇℃伅
+ *
+ */
+ List<ExtractAuditRecord> getByUidList(@Param("start") int start,
+ @Param("count") int count, @Param("uid") Long uid);
+
+ /**
+ * 鏌ヨ璐︽埛鎻愮幇璁板綍淇℃伅
+ *
+ */
+ int getByUidCount(@Param("uid") Long uid);
+
+
+ /**
+ * 缁熻瀹℃牳娆℃暟
+ * @param state
+ * @return
+ */
+ Long countAuditTotal(@Param("state")Integer state, @Param("preDay") String preDay);
+
+ /**
+ * 缁熻鐢宠鎻愮殑鐜版�婚噾棰�
+ * @param state
+ * @return
+ */
+ BigDecimal countApplyExtractMoney(@Param("preDay") String preDay);
+
+ /**
+ * 缁熻鐢宠鎻愮殑鐜版�绘鏁�
+ * @param preDay
+ * @return
+ */
+ Long countApplyNumberByDay(@Param("preDay") String preDay);
+
+}
--
Gitblit v1.8.0