From a438c5735834c26c584abfcc7221a06c1ccadcdc Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期三, 29 五月 2019 17:28:50 +0800
Subject: [PATCH] 资金到账明细优化
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/LostOrderMapper.java | 108 +++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 91 insertions(+), 17 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/LostOrderMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/LostOrderMapper.java
index e9f2743..095f521 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/LostOrderMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/LostOrderMapper.java
@@ -5,13 +5,10 @@
import org.apache.ibatis.annotations.Param;
+import com.yeshi.fanli.dao.BaseMapper;
import com.yeshi.fanli.entity.bus.user.LostOrder;
-public interface LostOrderMapper {
-
- LostOrder selectByPrimaryKey(Long id);
-
- int updateByPrimaryKeySelective(LostOrder record);
+public interface LostOrderMapper extends BaseMapper<LostOrder> {
/**
* 閫氳繃璁㈠崟鍙锋煡璇涪澶辫鍗�
@@ -19,17 +16,19 @@
* @param orderId
* @return
*/
- List<LostOrder> selectByOrderId(String orderId);
-
+ List<LostOrder> selectByOrderIdAndType(@Param("orderId")String orderId,@Param("type") int type);
+
/**
* 缁熻鐢ㄦ埛鐢宠瘔娆℃暟
+ *
* @param uid
* @return
*/
Map<String, Object> countByUid(@Param("uid") Long uid);
-
+
/**
* 鍚庣鍒楄〃鏌ヨ
+ *
* @param start
* @param count
* @param key
@@ -37,32 +36,107 @@
*/
List<LostOrder> listQuery(@Param("start") long start, @Param("count") int count, @Param("key") String key,
@Param("state") Integer state, @Param("handleType") Integer handleType);
-
+
long countQuery(@Param("key") String key, @Param("state") Integer state, @Param("handleType") Integer handleType);
/**
* 缁熻鐢宠瘔璁㈠崟鏁伴噺
- * @param type
+ *
+ * @param type
* @param state
* @param years
* @param startTime
* @param endTime
* @return
*/
- List<Map<String, Object>> countLostNum(@Param("dateType")Integer dateType,@Param("resultCode")Integer resultCode,
- @Param("year") String year, @Param("startTime")String startTime, @Param("endTime")String endTime);
-
-
+ List<Map<String, Object>> countLostNum(@Param("dateType") Integer dateType, @Param("resultCode") Integer resultCode,
+ @Param("year") String year, @Param("startTime") String startTime, @Param("endTime") String endTime);
+
/**
* 缁熻鐢宠瘔鎴愬姛璁㈠崟閲戦
- * @param type
+ *
+ * @param type
* @param state
* @param years
* @param startTime
* @param endTime
* @return
*/
- List<Map<String, Object>> countAppealMoney(@Param("dateType")Integer dateType, @Param("year") String year,
- @Param("startTime")String startTime, @Param("endTime")String endTime);
+ List<Map<String, Object>> countAppealMoney(@Param("dateType") Integer dateType, @Param("year") String year,
+ @Param("startTime") String startTime, @Param("endTime") String endTime);
+
+ /**
+ * 鏍规嵁鐢ㄦ埛鍒犻櫎
+ *
+ * @param uid
+ * @return
+ */
+ int deleteByUid(Long uid);
+
+ /**
+ *
+ * @param uid
+ * @param start
+ * @param count
+ * @return
+ */
+ List<LostOrder> listByUidOrderByCreateTimeDesc(@Param("uid") Long uid, @Param("start") long start,
+ @Param("count") int count);
+
+ /**
+ * 鑾峰彇鐢ㄦ埛璁㈠崟鏁伴噺
+ *
+ * @param uid
+ * @return
+ */
+ long countAllByUid(Long uid);
+
+ /**
+ *
+ * @param orderId
+ * @param type
+ * @param stateList
+ * @return
+ */
+ List<LostOrder> listByOrderIdAndTypeAndState(@Param("orderId") String orderId, @Param("type") int type,
+ @Param("stateList") List<Integer> stateList);
+
+ /**
+ * 澶勭悊澶辫触
+ *
+ * @return
+ */
+ int processFail();
+
+ /**
+ * 鏍规嵁鐘舵�佸拰缁撴灉鐮佽幏鍙栧垪琛�
+ *
+ * @param state
+ * @param resultCode
+ * @param start
+ * @param count
+ * @return
+ */
+ List<LostOrder> listByStateAndResultCode(@Param("state") Integer state, @Param("resultCode") Integer resultCode,
+ @Param("start") long start, @Param("count") int count);
+
+ /**
+ * 缁熻浠婃棩鐢宠瘔娆℃暟
+ *
+ * @param uid
+ * @return
+ */
+ long countTodayAppeal(@Param("uid") Long uid);
+
+ /**
+ * 鏍规嵁澶勭悊鐨勬渶澶ф椂闂村拰鐘舵�侊紝澶勭悊缁撴灉鏌ヨ
+ *
+ * @param maxTime
+ * @param state
+ * @param resultCode
+ * @return
+ */
+ List<LostOrder> listByMaxHandleTimeAndStateAndResultCode(@Param("maxTime") long maxTime,
+ @Param("state") Integer state, @Param("resultCode") Integer resultCode);
}
\ No newline at end of file
--
Gitblit v1.8.0