package com.yeshi.fanli.service.impl.count;
|
|
import java.math.BigDecimal;
|
import java.text.DecimalFormat;
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.annotation.Resource;
|
|
import org.springframework.stereotype.Service;
|
import org.yeshi.utils.DateUtil;
|
|
import com.yeshi.fanli.dao.mybatis.jd.JDOrderItemMapper;
|
import com.yeshi.fanli.dao.mybatis.order.CommonOrderCountMapper;
|
import com.yeshi.fanli.dao.mybatis.pdd.PDDOrderMapper;
|
import com.yeshi.fanli.dao.mybatis.taobao.TaoBaoOrderMapper;
|
import com.yeshi.fanli.dao.mybatis.taobao.TaoBaoWeiQuanOrderMapper;
|
import com.yeshi.fanli.dto.ChartTDO;
|
import com.yeshi.fanli.service.inter.order.CommonOrderCountService;
|
import com.yeshi.fanli.util.Constant;
|
|
@Service
|
public class CommonOrderCountServiceImpl implements CommonOrderCountService {
|
|
@Resource
|
private TaoBaoWeiQuanOrderMapper taoBaoWeiQuanOrderMapper;
|
|
@Resource
|
private TaoBaoOrderMapper taoBaoOrderMapper;
|
|
@Resource
|
private JDOrderItemMapper jdOrderItemMapper;
|
|
@Resource
|
private PDDOrderMapper pddOrderMapper;
|
|
@Resource
|
private CommonOrderCountMapper commonOrderCountMapper;
|
|
@Override
|
public Long countByState(Integer state) {
|
return commonOrderCountMapper.countByState(state);
|
}
|
|
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 showDate = chartTDO.getShowDate();
|
if (plusDay.equalsIgnoreCase(showDate)) {
|
total = chartTDO.getShowValue();
|
break;
|
}
|
}
|
if (total == null) {
|
total = "0";
|
}
|
ChartTDO chartTDO = new ChartTDO();
|
chartTDO.setShowDate(plusDay);
|
chartTDO.setShowValue(total);
|
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 showValue = chartTDO.getShowValue();
|
if (showValue == null) {
|
chartTDO.setShowValue("0");
|
}
|
listObject.add(chartTDO);
|
}
|
return listObject;
|
}
|
|
@Override
|
public List<ChartTDO> getTrackAccuracyRate(Integer dateType, String year, String startTime, String endTime,
|
int sourceType) throws Exception {
|
|
List<ChartTDO> result_list = null;
|
|
// 用户订单
|
List<ChartTDO> listTotal = commonOrderCountMapper.countOrderNumber(dateType, year, startTime, endTime,
|
sourceType);
|
if (listTotal == null || listTotal.size() == 0) {
|
return result_list;
|
}
|
|
// 淘宝联盟
|
List<ChartTDO> type_list = null;
|
switch (sourceType) {
|
case Constant.SOURCE_TYPE_TAOBAO:
|
type_list = taoBaoOrderMapper.countOrderNumber(dateType, year, startTime, endTime);
|
break;
|
case Constant.SOURCE_TYPE_JD:
|
type_list = jdOrderItemMapper.countOrderNumber(dateType, year, startTime, endTime);
|
break;
|
case Constant.SOURCE_TYPE_PDD:
|
type_list = pddOrderMapper.countOrderNumber(dateType, year, startTime, endTime);
|
break;
|
}
|
if (type_list == null || type_list.size() == 0) {
|
return null;
|
}
|
|
switch (dateType) {
|
case 1: // 按天处理
|
result_list = dayFactory(startTime, endTime, type_list);
|
break;
|
case 2: // 按月处理
|
result_list = monthFactory(type_list);
|
break;
|
case 3:
|
result_list = yearFactory(type_list);
|
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 < listTotal.size(); j++) {
|
ChartTDO innerChartTDO = listTotal.get(j);
|
String innerDate = innerChartTDO.getShowDate();
|
if (innerDate != null && innerDate.toString().equals(showDate.toString())) {
|
String innerValue = innerChartTDO.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<ChartTDO> countWeiQaunOrderMoney(Integer dateType, String year, String startTime, String endTime)
|
throws Exception {
|
return taoBaoWeiQuanOrderMapper.countWeiQaunOrderMoney(dateType, year, startTime, endTime);
|
}
|
|
@Override
|
public List<ChartTDO> countWeiQaunOrderNumber(Integer dateType, String year, String startTime, String endTime)
|
throws Exception {
|
return taoBaoWeiQuanOrderMapper.countWeiQaunOrderNumber(dateType, year, startTime, endTime);
|
}
|
|
@Override
|
public Map<String, Object> countOrderNumberBySettleTime(Long uid, Integer state, Integer day) {
|
return commonOrderCountMapper.countOrderNumberBySettleTime(uid, state, day);
|
}
|
|
/**
|
* 根据结算时间筛选 上个月已结算的订订单数量
|
*
|
* @param uid
|
* @return
|
*/
|
@Override
|
public Map<String, Object> lastMonthSettleOrderNumber(Long uid) {
|
return countOrderNumberBySettleTime(uid, 2, 4); // 根据
|
}
|
|
@Override
|
public BigDecimal getMoneyByOrderNo(String orderNo) {
|
return commonOrderCountMapper.getMoneyByOrderNo(orderNo);
|
}
|
|
@Override
|
public long countValidOrderByDate(Long uid, String dateTime) {
|
return commonOrderCountMapper.countValidOrderByDate(uid, dateTime);
|
}
|
|
@Override
|
public long countSameShopOrderByUidAndHongBaoType(List<Integer> typeList, Long uid, int minSameShopGoodsCount) {
|
return commonOrderCountMapper.countSameShopOrderByUidAndHongBaoType(typeList, uid, minSameShopGoodsCount);
|
}
|
|
@Override
|
public long countSameGoodsOrderByUidAndHongBaoType(List<Integer> typeList, Long uid, int minSameGoodsOrderCount) {
|
return commonOrderCountMapper.countSameGoodsOrderByUidAndHongBaoType(typeList, uid, minSameGoodsOrderCount);
|
}
|
|
|
@Override
|
public List<Long> getSameShopOrderByUidAndHongBaoType(List<Integer> typeList, Long uid, int minSameShopGoodsCount) {
|
return commonOrderCountMapper.getSameShopOrderByUidAndHongBaoType(typeList, uid, minSameShopGoodsCount);
|
}
|
|
@Override
|
public List<Long> getSameGoodsOrderByUidAndHongBaoType(List<Integer> typeList, Long uid, int minSameGoodsOrderCount) {
|
return commonOrderCountMapper.getSameGoodsOrderByUidAndHongBaoType(typeList, uid, minSameGoodsOrderCount);
|
}
|
}
|
