From 69bee82b81626b82b7f39f0e459e4f56b1699b51 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期三, 13 三月 2019 12:02:16 +0800
Subject: [PATCH] 正式数据库修改
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/LostOrderMapper.java | 48 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 48 insertions(+), 0 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 d45065c..debd30d 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
@@ -1,6 +1,9 @@
package com.yeshi.fanli.dao.mybatis.order;
import java.util.List;
+import java.util.Map;
+
+import org.apache.ibatis.annotations.Param;
import com.yeshi.fanli.entity.bus.user.LostOrder;
@@ -15,4 +18,49 @@
* @return
*/
List<LostOrder> selectByOrderId(String orderId);
+
+ /**
+ * 缁熻鐢ㄦ埛鐢宠瘔娆℃暟
+ * @param uid
+ * @return
+ */
+ Map<String, Object> countByUid(@Param("uid") Long uid);
+
+ /**
+ * 鍚庣鍒楄〃鏌ヨ
+ * @param start
+ * @param count
+ * @param key
+ * @return
+ */
+ 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 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);
+
+
+ /**
+ * 缁熻鐢宠瘔鎴愬姛璁㈠崟閲戦
+ * @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);
+
}
\ No newline at end of file
--
Gitblit v1.8.0