From b42e88afc77b0d40ea8bbad87df6cc22d03414e1 Mon Sep 17 00:00:00 2001
From: yujian <yujian>
Date: 星期一, 14 一月 2019 18:03:13 +0800
Subject: [PATCH] 后台订单统计 用户统计
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java | 33 ++++++++++++++++++++++++++++++++-
1 files changed, 32 insertions(+), 1 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java
index bbd72a1..edd3b33 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java
@@ -2,6 +2,7 @@
import java.math.BigDecimal;
import java.util.List;
+import java.util.Map;
import org.apache.ibatis.annotations.Param;
@@ -109,7 +110,7 @@
* @param minMoney
* @return
*/
- double countAllMoney(@Param("minMoney") Double minMoney);
+ BigDecimal countAllMoney(@Param("minMoney") Double minMoney);
/**
@@ -119,4 +120,34 @@
*/
List<Long> longTimeNoLogin(@Param("daysNum") int daysNum, @Param("list") List<Long> list);
+ /**
+ * 缁熻娴佸け鐢ㄦ埛鏁伴噺:锛� num 澶╂湭浣跨敤鐧诲綍骞朵笖鏃犱换浣曡祫閲戞祦鍔ㄧ殑璐﹀彿鏁伴噺锛�
+ * @param num 180
+ * @return
+ */
+ long countLoseUser(@Param("num") int num);
+
+
+ /**
+ * 绱鏈夎喘涔扮敤鎴锋暟
+ * @return
+ */
+ long countHasOrderUser();
+
+
+ /**
+ * 缁熻鏂板鐢ㄦ埛
+ * @return
+ */
+ List<Map<String, Object>> countNewUserByDate(@Param("channel")String channel,@Param("type")Integer type, @Param("years") String years,
+ @Param("startTime")String startTime, @Param("endTime")String endTime);
+
+
+ /**
+ * 缁熻鏂板鐢ㄦ埛
+ * @return
+ */
+ List<Map<String, Object>> getTodayHasOrder(@Param("channel")String channel,@Param("type")Integer type, @Param("years") String years,
+ @Param("startTime")String startTime, @Param("endTime")String endTime);
+
}
\ No newline at end of file
--
Gitblit v1.8.0