From 744594ef1a2f530fc3e86ea9dc48b62247f79420 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 19 五月 2020 17:13:23 +0800
Subject: [PATCH] 饿了么绘图，添加口碑
---
fanli/src/main/java/com/yeshi/fanli/dao/order/OrderMoneyDailyCountDao.java | 217 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 215 insertions(+), 2 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/order/OrderMoneyDailyCountDao.java b/fanli/src/main/java/com/yeshi/fanli/dao/order/OrderMoneyDailyCountDao.java
index 5fb7f62..2ad0044 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/order/OrderMoneyDailyCountDao.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/order/OrderMoneyDailyCountDao.java
@@ -56,6 +56,12 @@
update.set("teamSubsidy", info.getTeamSubsidy());
if (info.getTeamSubsidyNum() != null)
update.set("teamSubsidyNum", info.getTeamSubsidyNum());
+ if (info.getDirectOrderNum() != null)
+ update.set("directOrderNum", info.getDirectOrderNum());
+ if (info.getInDirectOrderNum() != null)
+ update.set("inDirectOrderNum", info.getInDirectOrderNum());
+ if (info.getBeyondOrderNum() != null)
+ update.set("beyondOrderNum", info.getBeyondOrderNum());
update.set("updateTime", new Date());
update(query, update);
}
@@ -126,6 +132,10 @@
for (int i = 0; i < mapResult.size(); i++) {
BasicDBObject object = mapResult.get(i + "");
+ if (object == null || object.get("sourceType") == null) {
+ continue;
+ }
+
SourceTypeEnum sourceTypeEnum = null;
for (int m = 0; m < arrayEnun.length; m++) {
if (arrayEnun[m].name().equals(object.get("sourceType").toString())) {
@@ -191,8 +201,10 @@
SourceTypeEnum[] arrayEnun = SourceTypeEnum.values();
for (int i = 0; i < mapResult.size(); i++) {
BasicDBObject object = mapResult.get(i + "");
- OrderMoneyDailyCount dailyCount = new OrderMoneyDailyCount();
-
+ if (object == null || object.get("sourceType") == null) {
+ continue;
+ }
+
SourceTypeEnum sourceTypeEnum = null;
for (int m = 0; m < arrayEnun.length; m++) {
if (arrayEnun[m].name().equals(object.get("sourceType").toString())) {
@@ -200,6 +212,7 @@
break;
}
}
+ OrderMoneyDailyCount dailyCount = new OrderMoneyDailyCount();
dailyCount.setSourceType(sourceTypeEnum);
dailyCount.setIncome(new BigDecimal(object.get("totalIncome").toString()).intValue());
dailyCount.setOrderNum(new BigDecimal(object.get("totalNum").toString()).intValue());
@@ -510,4 +523,204 @@
return results;
}
+
+
+ private String getTeamOrderNumReduce() {
+ StringBuilder builder = new StringBuilder();
+ builder.append("function(doc, aggr){ ");
+ builder.append(" aggr.directOrderNum += doc.directOrderNum;");
+ builder.append(" aggr.inDirectOrderNum += doc.inDirectOrderNum;");
+ builder.append(" aggr.beyondOrderNum += doc.beyondOrderNum;");
+ builder.append(" }");
+ return builder.toString();
+ }
+
+ /**
+ * 缁熻姣忔湀璁㈠崟鏀跺叆銆佹暟閲�
+ * @param uid
+ * @param minDate
+ * @param maxDate
+ * @return
+ */
+ public List<OrderMoneyDailyCount> sumTeamOrderNumGroupByCountDay(Long uid, Date minDate, Date maxDate) {
+ // 鏌ヨ鏉′欢
+ List<Criteria> list = new ArrayList<Criteria>();
+ list.add(Criteria.where("uid").is(uid));
+ if (minDate != null)
+ list.add(Criteria.where("countDay").gte(minDate));
+ if (maxDate != null)
+ list.add(Criteria.where("countDay").lte(maxDate));
+
+ Query query = new Query();
+ if (list.size() > 0) {
+ Criteria[] cas = new Criteria[list.size()];
+ for (int i = 0; i < list.size(); i++)
+ cas[i] = list.get(i);
+ query.addCriteria(new Criteria().andOperator(cas));
+ }
+
+ Map<String, Object> map = new HashMap<>();
+ map.put("directOrderNum", 0);
+ map.put("inDirectOrderNum", 0);
+ map.put("beyondOrderNum", 0);
+ BasicDBObject initial = new BasicDBObject(map);
+
+ // 杩涜鎸夊ぉ銆佸懆銆佹湀鍒嗙粍
+ BasicDBObject agg = new BasicDBObject("countDay", "");
+ DBCollection collection = mongoTemplate.getCollection(collectionName);
+ GroupCommand xx = new GroupCommand(collection, agg, query.getQueryObject(), initial, getTeamOrderNumReduce(), null);
+ BasicDBList objects = (BasicDBList) collection.group(xx);
+
+ List<OrderMoneyDailyCount> results = new ArrayList<>();
+ if (objects != null) {
+ SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd HH:mm:ss z yyyy", Locale.US);
+ for (int i = 0; i < objects.size(); i++) {
+ BasicDBObject dbObject = (BasicDBObject) objects.get(i);
+ if (dbObject == null) {
+ continue;
+ }
+
+ Object object = dbObject.get("countDay");
+ if (object == null) {
+ continue;
+ }
+
+ try {
+ String date = object.toString();
+ Date dtime = sdf.parse(date);
+ OrderMoneyDailyCount dailyCount = new OrderMoneyDailyCount();
+ dailyCount.setCountDay(dtime);
+ dailyCount.setDirectOrderNum(new BigDecimal(dbObject.get("directOrderNum").toString()).intValue());
+ dailyCount.setInDirectOrderNum(new BigDecimal(dbObject.get("inDirectOrderNum").toString()).intValue());
+ dailyCount.setBeyondOrderNum(new BigDecimal(dbObject.get("beyondOrderNum").toString()).intValue());
+ results.add(dailyCount);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+ }
+ return results;
+ }
+
+
+ /**
+ * 缁熻姣忔湀璁㈠崟鏀跺叆銆佹暟閲�
+ * @param uid
+ * @param minDate
+ * @param maxDate
+ * @return
+ */
+ public List<OrderMoneyDailyCount> sumTeamOrderNumGroupByYearMonth(Long uid, Date minDate, Date maxDate) {
+ // 鏌ヨ鏉′欢
+ List<Criteria> list = new ArrayList<Criteria>();
+ list.add(Criteria.where("uid").is(uid));
+ if (minDate != null)
+ list.add(Criteria.where("countDay").gte(minDate));
+ if (maxDate != null)
+ list.add(Criteria.where("countDay").lte(maxDate));
+
+ Query query = new Query();
+ if (list.size() > 0) {
+ Criteria[] cas = new Criteria[list.size()];
+ for (int i = 0; i < list.size(); i++)
+ cas[i] = list.get(i);
+ query.addCriteria(new Criteria().andOperator(cas));
+ }
+
+ Map<String, Object> map = new HashMap<>();
+ map.put("directOrderNum", 0);
+ map.put("inDirectOrderNum", 0);
+ map.put("beyondOrderNum", 0);
+ BasicDBObject initial = new BasicDBObject(map);
+
+ // 杩涜鎸夊ぉ銆佸懆銆佹湀鍒嗙粍
+ BasicDBObject agg = new BasicDBObject("yearMonth", "");
+ DBCollection collection = mongoTemplate.getCollection(collectionName);
+ GroupCommand xx = new GroupCommand(collection, agg, query.getQueryObject(), initial, getTeamOrderNumReduce(), null);
+ BasicDBList objects = (BasicDBList) collection.group(xx);
+
+ List<OrderMoneyDailyCount> results = new ArrayList<>();
+ if (objects != null) {
+ for (int i = 0; i < objects.size(); i++) {
+ BasicDBObject dbObject = (BasicDBObject) objects.get(i);
+ if (dbObject == null) {
+ continue;
+ }
+
+ Object object = dbObject.get("yearMonth");
+ if (object == null) {
+ continue;
+ }
+
+ OrderMoneyDailyCount dailyCount = new OrderMoneyDailyCount();
+ dailyCount.setYearMonth(object.toString());
+ dailyCount.setDirectOrderNum(new BigDecimal(dbObject.get("directOrderNum").toString()).intValue());
+ dailyCount.setInDirectOrderNum(new BigDecimal(dbObject.get("inDirectOrderNum").toString()).intValue());
+ dailyCount.setBeyondOrderNum(new BigDecimal(dbObject.get("beyondOrderNum").toString()).intValue());
+
+ results.add(dailyCount);
+ }
+ }
+ return results;
+ }
+
+ /**
+ * 缁熻姣忔湀璁㈠崟鏀跺叆銆佹暟閲�
+ * @param uid
+ * @param minDate
+ * @param maxDate
+ * @return
+ */
+ public List<OrderMoneyDailyCount> sumTeamOrderNumGroupByUid(Long uid, Date minDate, Date maxDate) {
+ // 鏌ヨ鏉′欢
+ List<Criteria> list = new ArrayList<Criteria>();
+ list.add(Criteria.where("uid").is(uid));
+ if (minDate != null)
+ list.add(Criteria.where("countDay").gte(minDate));
+ if (maxDate != null)
+ list.add(Criteria.where("countDay").lte(maxDate));
+
+ Query query = new Query();
+ if (list.size() > 0) {
+ Criteria[] cas = new Criteria[list.size()];
+ for (int i = 0; i < list.size(); i++)
+ cas[i] = list.get(i);
+ query.addCriteria(new Criteria().andOperator(cas));
+ }
+
+ Map<String, Object> map = new HashMap<>();
+ map.put("directOrderNum", 0);
+ map.put("inDirectOrderNum", 0);
+ map.put("beyondOrderNum", 0);
+ BasicDBObject initial = new BasicDBObject(map);
+
+ // 杩涜鎸夊ぉ銆佸懆銆佹湀鍒嗙粍
+ BasicDBObject agg = new BasicDBObject("uid", "");
+ DBCollection collection = mongoTemplate.getCollection(collectionName);
+ GroupCommand xx = new GroupCommand(collection, agg, query.getQueryObject(), initial, getTeamOrderNumReduce(), null);
+ BasicDBList objects = (BasicDBList) collection.group(xx);
+
+ List<OrderMoneyDailyCount> results = new ArrayList<>();
+ if (objects != null) {
+ for (int i = 0; i < objects.size(); i++) {
+ BasicDBObject dbObject = (BasicDBObject) objects.get(i);
+ if (dbObject == null) {
+ continue;
+ }
+
+ Object object = dbObject.get("uid");
+ if (object == null) {
+ continue;
+ }
+
+ OrderMoneyDailyCount dailyCount = new OrderMoneyDailyCount();
+ dailyCount.setDirectOrderNum(new BigDecimal(dbObject.get("directOrderNum").toString()).intValue());
+ dailyCount.setInDirectOrderNum(new BigDecimal(dbObject.get("inDirectOrderNum").toString()).intValue());
+ dailyCount.setBeyondOrderNum(new BigDecimal(dbObject.get("beyondOrderNum").toString()).intValue());
+
+ results.add(dailyCount);
+ }
+ }
+ return results;
+ }
}
--
Gitblit v1.8.0