From 0f52108bac0ebf47a563c41bcb97d934b7cf12ab Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期三, 11 十二月 2019 15:07:06 +0800
Subject: [PATCH] 订单筛选
---
fanli/src/main/java/com/yeshi/fanli/service/impl/count/UserInfoCountServiceImpl.java | 225 +++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 215 insertions(+), 10 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/service/impl/count/UserInfoCountServiceImpl.java b/fanli/src/main/java/com/yeshi/fanli/service/impl/count/UserInfoCountServiceImpl.java
index 542a69b..9c9132d 100644
--- a/fanli/src/main/java/com/yeshi/fanli/service/impl/count/UserInfoCountServiceImpl.java
+++ b/fanli/src/main/java/com/yeshi/fanli/service/impl/count/UserInfoCountServiceImpl.java
@@ -2,27 +2,29 @@
import java.math.BigDecimal;
-import java.text.SimpleDateFormat;
+import java.text.DecimalFormat;
import java.util.ArrayList;
-import java.util.Date;
-import java.util.HashMap;
import java.util.List;
-import java.util.Map;
import javax.annotation.Resource;
-import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Service;
import org.yeshi.utils.DateUtil;
+import com.yeshi.fanli.dao.mybatis.UserInfoCountMapper;
import com.yeshi.fanli.dao.mybatis.UserInfoMapper;
+import com.yeshi.fanli.dto.ChartTDO;
import com.yeshi.fanli.service.inter.count.UserInfoCountService;
+import com.yeshi.fanli.vo.user.UserGoldCoinVO;
@Service
public class UserInfoCountServiceImpl implements UserInfoCountService {
@Resource
private UserInfoMapper userInfoMapper;
+
+ @Resource
+ private UserInfoCountMapper userInfoCountMapper;
@Override
@@ -52,28 +54,231 @@
}
@Override
- public List<Map<String, Object>> countNewUserByDate(String channel,Integer type,String years, String startTime,
+ public List<ChartTDO> countNewUserByDate(String channel,Integer type,String years, String startTime,
String endTime) throws Exception {
return userInfoMapper.countNewUserByDate(channel, type, years, startTime, endTime);
}
@Override
- public List<Map<String, Object>> getTodayBuyRate(String channel,Integer type,String years, String startTime,
+ public List<ChartTDO> getTodayBuyRate(String channel, Integer dateType,String years, String startTime,
String endTime) throws Exception {
- List<Map<String, Object>> todayNum =
- userInfoMapper.getTodayHasOrder(channel, type, years, startTime, endTime);
+ List<ChartTDO> result_list = null;
+ List<ChartTDO> listToday =
+ userInfoMapper.getTodayHasOrder(channel, dateType, years, startTime, endTime);
+ if (listToday == null || listToday.size() == 0) {
+ return result_list;
+ }
- return todayNum;
+ List<ChartTDO> listTotal = userInfoMapper.countNewUserByDate(channel, dateType, years, startTime, endTime);
+ if (listTotal == null || listTotal.size() == 0) {
+ return result_list;
+ }
+ switch (dateType){
+ case 1: // 鎸夊ぉ澶勭悊
+ result_list = dayFactory(startTime, endTime, listTotal);
+ break;
+ case 2: // 鎸夋湀澶勭悊
+ result_list = monthFactory(listTotal);
+ break;
+ case 3:
+ result_list = yearFactory(listTotal);
+ break;
+ default:
+ break;
+ }
+ DecimalFormat df = new DecimalFormat("#.00");
+ for (int i = 0; i < result_list.size(); i++) {
+ double proportion = 0;
+ ChartTDO chartTDO = result_list.get(i);
+ String showDate = chartTDO.getShowDate();
+ for (int j = 0; j < listToday.size(); j++) {
+ ChartTDO innerTDO = listToday.get(j);
+ String innerDate = innerTDO.getShowDate();
+ if (innerDate != null && innerDate.equals(showDate)) {
+ String innerValue = innerTDO.getShowValue();
+ long innerData = Long.parseLong(innerValue);
+
+ String showValue = chartTDO.getShowValue();
+ long showData = Long.parseLong(showValue);
+
+ if (showData > 0) {
+ proportion = innerData/(double)showData;
+ }
+ break; // 缁撴潫鍐呴儴寰幆
+ }
+ }
+ chartTDO.setShowValue(Double.parseDouble(df.format(proportion *100)) + "");
+ }
+ return result_list;
}
+ @Override
+ public List<Object> getWeekBuyRate(String channel, String startTime, String endTime,
+ Integer orderNum, List<String> dateList) throws Exception {
+ List<Object> resultList = new ArrayList<Object>();
+ if (dateList == null || dateList.size() == 0) {
+ return resultList;
+ }
+ List<ChartTDO> totalList = userInfoMapper.countNewUserByDate(channel, 1, null, startTime, endTime);
+ if (totalList == null || totalList.size() == 0) {
+ return resultList;
+ }
+
+ DecimalFormat df = new DecimalFormat("#.00");
+ for (int i = 0; i < dateList.size(); i++) {
+ double proportion = 0;
+ String showDate = dateList.get(i);
+ String plusDay = DateUtil.plusDay(7, showDate);
+ ChartTDO chartTDO = userInfoMapper.getWeekHasOrder(channel, showDate, plusDay, orderNum);
+
+ String showValue = null;
+ if (chartTDO != null) {
+ showValue = chartTDO.getShowValue();
+ if (showValue != null) {
+ for (int j = 0; j < totalList.size(); j++) {
+ ChartTDO chart = totalList.get(j);
+ String reslutTime = chart.getShowDate();
+ if (showDate.equalsIgnoreCase(reslutTime)) {
+ String totalObject = chart.getShowValue();
+ long hasCount = Long.parseLong(showValue);
+ long total = Long.parseLong(totalObject);
+
+ if (total > 0) {
+ proportion = hasCount / (double) total;
+ }
+
+ break;
+ }
+ }
+ }
+ }
+ resultList.add(Double.parseDouble(df.format(proportion * 100)));
+ }
+
+ return resultList;
+ }
+
+
+ public List<ChartTDO> dayFactory(String startTime, String endTime, List<ChartTDO> list) throws Exception {
+ List<ChartTDO> listObject = new ArrayList<ChartTDO>();
+ if (startTime.equals(endTime)) {
+ ChartTDO chartTDO = list.get(0);
+ String showValue = chartTDO.getShowValue();
+ if (showValue == null) {
+ chartTDO.setShowValue("0");
+ }
+ listObject.add(chartTDO);
+ return listObject;
+ }
+
+ String plusDay = "";
+ for (int i = 0; i < 1000; i++) {
+ if (i == 0) {
+ plusDay = startTime;
+ } else {
+ plusDay = DateUtil.plusDay(i, startTime);
+ }
+
+
+ String total = null;
+ for (int j = 0; j < list.size(); j++) {
+ ChartTDO chartTDO = list.get(j);
+ String month = chartTDO.getShowDate();
+ if (plusDay.equalsIgnoreCase(month)) {
+ total = chartTDO.getShowValue();
+ break;
+ }
+ }
+
+ if (total == null) {
+ total = "0";
+ }
+ ChartTDO chartTDO = new ChartTDO();
+ chartTDO.setShowValue(total);
+ chartTDO.setShowDate(plusDay);
+ listObject.add(chartTDO);
+
+ if (plusDay.equals(endTime)) {
+ break; // 鏃堕棿缁撴潫
+ }
+ }
+
+ return listObject;
+ }
+
+ public List<ChartTDO> monthFactory(List<ChartTDO> list) {
+ List<ChartTDO> listObject = new ArrayList<ChartTDO>();
+ // 12 涓湀澶勭悊
+ for (int i = 1; i <= 12; i++) {
+ String total = null;
+ for (int j = 0; j < list.size(); j++) {
+ ChartTDO chartTDO = list.get(j);
+ String month = chartTDO.getShowDate();
+ if ((i + "").equalsIgnoreCase(month) || i == Integer.parseInt(month)) {
+ total = chartTDO.getShowValue();
+ break;
+ }
+ }
+
+ if (total == null) {
+ total = "0";
+ }
+
+ ChartTDO chartTDO = new ChartTDO();
+ chartTDO.setShowValue(total);
+
+ if (i <10) {
+ chartTDO.setShowDate( "0"+ i);
+ } else {
+ chartTDO.setShowDate( ""+ i);
+ }
+ listObject.add(chartTDO);
+ }
+ return listObject;
+ }
+
+ public List<ChartTDO> yearFactory(List<ChartTDO> list) {
+ List<ChartTDO> listObject = new ArrayList<ChartTDO>();
+ for (int i = 0; i < list.size(); i++) {
+ ChartTDO chartTDO = list.get(i);
+ String total = chartTDO.getShowValue();
+ if (total == null) {
+ total = "0";
+ }
+ chartTDO.setShowValue(total);
+ listObject.add(chartTDO);
+ }
+ return listObject;
+ }
+
+ @Override
+ public List<UserGoldCoinVO> listByUserGoldCoin(long start, int count, int type, String key) {
+ return userInfoCountMapper.listByUserGoldCoin(start, count, type, key);
+ }
+
+ @Override
+ public long countByUserGoldCoin(int type, String key) {
+ return userInfoCountMapper.countByUserGoldCoin(type, key);
+ }
+
+
+ @Override
+ public List<UserGoldCoinVO> listByHasGoldCoin(long start, int count, String key) {
+ return userInfoCountMapper.listByHasGoldCoin(start, count, key);
+ }
+
+ @Override
+ public long countByHasGoldCoin(String key) {
+ return userInfoCountMapper.countByHasGoldCoin(key);
+ }
}
--
Gitblit v1.8.0