| | |
|---|
| | | package com.yeshi.fanli.service.impl.count;
|
|---|
| | |
|
|---|
| | | import java.text.SimpleDateFormat;
|
|---|
| | | import java.math.BigDecimal;
|
|---|
| | | 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.springframework.stereotype.Service;
|
|---|
| | | import org.yeshi.utils.DateUtil;
|
|---|
| | |
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.HongBaoV2CountMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.hongbao.HongBaoMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.order.CommonOrderGoodsMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.order.CommonOrderMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.order.HongBaoOrderMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.order.OrderItemMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.order.OrderMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.taobao.TaoBaoOrderMapper;
|
|---|
| | | import com.yeshi.fanli.dao.mybatis.taobao.TaoBaoWeiQuanOrderMapper;
|
|---|
| | | import com.yeshi.fanli.entity.bus.user.HongBaoV2;
|
|---|
| | | import com.yeshi.fanli.service.inter.count.HongBaoV2CountService;
|
|---|
| | | import com.yeshi.fanli.service.inter.order.CommonOrderService;
|
|---|
| | | import com.yeshi.fanli.service.inter.user.UserInfoService;
|
|---|
| | | import com.yeshi.fanli.vo.order.HongBaoV2VO;
|
|---|
| | |
|
|---|
| | | @Service
|
|---|
| | | public class HongBaoV2CountServiceImpl implements HongBaoV2CountService {
|
|---|
| | |
|---|
| | | @Resource
|
|---|
| | | private HongBaoV2CountMapper hongBaoV2CountMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private HongBaoMapper hongBaoMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private TaoBaoOrderMapper taoBaoOrderMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private OrderItemMapper orderItemMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private CommonOrderMapper commonOrderMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private CommonOrderGoodsMapper commonOrderGoodsMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private HongBaoOrderMapper hongBaoOrderMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private OrderMapper orderMapper;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private CommonOrderService commonOrderService;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private UserInfoService userInfoService;
|
|---|
| | |
|
|---|
| | | @Resource
|
|---|
| | | private TaoBaoWeiQuanOrderMapper taoBaoWeiQuanOrderMapper;
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public Long countOrderByTypeAndDate(Integer orderType, String preDay) {
|
|---|
| | | return hongBaoV2CountMapper.countOrderByTypeAndDate(orderType, preDay);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public List<Map<String, Object>> dayFactory(String startTime, String endTime, List<Map<String, Object>> list) throws Exception {
|
|---|
| | |
|
|---|
| | | List<Map<String, Object>> listObject = new ArrayList<Map<String, Object>>();
|
|---|
| | |
|
|---|
| | | if (startTime.equals(endTime)) {
|
|---|
| | |
|
|---|
| | | Map<String, Object> map = list.get(0);
|
|---|
| | | Object total = map.get("showValue");
|
|---|
| | | if (total == null) {
|
|---|
| | | map.put("showValue", 0);
|
|---|
| | | }
|
|---|
| | | listObject.add(map);
|
|---|
| | | return listObject;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | String plusDay = "";
|
|---|
| | | for (int i = 0; i < 1000; i++) {
|
|---|
| | | if (i == 0) {
|
|---|
| | | plusDay = startTime;
|
|---|
| | | } else {
|
|---|
| | | plusDay = DateUtil.plusDay(i, startTime);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | Map<String, Object> mapObject = new HashMap<String, Object>();
|
|---|
| | | Object total = null;
|
|---|
| | |
|
|---|
| | | for (int j = 0; j < list.size(); j++) {
|
|---|
| | | Map<String, Object> map = list.get(j);
|
|---|
| | | Object createDate = map.get("showDate");
|
|---|
| | | String month = createDate.toString();
|
|---|
| | | if (plusDay.equalsIgnoreCase(month)) {
|
|---|
| | | total = map.get("showValue");
|
|---|
| | | break;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | if (total == null) {
|
|---|
| | | total = 0;
|
|---|
| | | }
|
|---|
| | | mapObject.put("showValue", total);
|
|---|
| | |
|
|---|
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
|---|
| | | SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy/MM/dd");
|
|---|
| | | Date parseDate = sdf.parse(plusDay.toString());
|
|---|
| | |
|
|---|
| | | mapObject.put("showDate", sdf2.format(parseDate));
|
|---|
| | |
|
|---|
| | | listObject.add(mapObject);
|
|---|
| | |
|
|---|
| | | if (plusDay.equals(endTime)) {
|
|---|
| | | break; // 时间结束
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | return listObject;
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal countMoneyByUidAndState(Long uid, Integer state) {
|
|---|
| | | return hongBaoV2CountMapper.countMoneyByUidAndState(uid, state);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public List<Map<String, Object>> monthFactory(List<Map<String, Object>> list) {
|
|---|
| | |
|
|---|
| | | List<Map<String, Object>> listObject = new ArrayList<Map<String, Object>>();
|
|---|
| | | // 12 个月处理
|
|---|
| | | for (int i = 1; i <= 12; i++) {
|
|---|
| | | Map<String, Object> mapObject = new HashMap<String, Object>();
|
|---|
| | | Object total = null;
|
|---|
| | |
|
|---|
| | | for (int j = 0; j < list.size(); j++) {
|
|---|
| | | Map<String, Object> map = list.get(j);
|
|---|
| | | Object createDate = map.get("showDate");
|
|---|
| | | String month = createDate.toString();
|
|---|
| | | if ((i + "").equalsIgnoreCase(month) || i == Integer.parseInt(month)) {
|
|---|
| | | total = map.get("showValue");
|
|---|
| | | break;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | if (total == null) {
|
|---|
| | | total = 0;
|
|---|
| | | }
|
|---|
| | | mapObject.put("showValue", total);
|
|---|
| | |
|
|---|
| | | mapObject.put("showDate", i + "月");
|
|---|
| | |
|
|---|
| | | listObject.add(mapObject);
|
|---|
| | | }
|
|---|
| | | return listObject;
|
|---|
| | | @Override
|
|---|
| | | public Integer countNumberByUidAndState(Long uid, Integer state) {
|
|---|
| | | return hongBaoV2CountMapper.countNumberByUidAndState(uid, state);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public List<Map<String, Object>> yearFactory(List<Map<String, Object>> list) {
|
|---|
| | | @Override
|
|---|
| | | public int getTotalTiChengCount(Long uid) {
|
|---|
| | | return hongBaoV2CountMapper.getTotalTiChengCount(uid);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public long getHongBaoCount(Long uid,Integer type) {
|
|---|
| | | return hongBaoV2CountMapper.getHongBaoCount(uid, type);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | List<Map<String, Object>> listObject = new ArrayList<Map<String, Object>>();
|
|---|
| | | @Override
|
|---|
| | | public long countValidNumberByUid(Long uid, Integer dateType) {
|
|---|
| | | return hongBaoV2CountMapper.countValidNumberByUid(uid, dateType);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | for (int i = 0; i < list.size(); i++) {
|
|---|
| | | Map<String, Object> map = list.get(i);
|
|---|
| | | Object total = map.get("showValue");
|
|---|
| | | @Override
|
|---|
| | | public BigDecimal countWillGetMoneyByUid(Long uid) {
|
|---|
| | | return hongBaoV2CountMapper.countWillGetMoneyByUid(uid);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | if (total == null) {
|
|---|
| | | total = 0;
|
|---|
| | | }
|
|---|
| | | map.put("showValue", total);
|
|---|
| | | @Override
|
|---|
| | | public Date getLastHongBaoTime(Long uid) {
|
|---|
| | | return hongBaoV2CountMapper.getLastHongBaoTime(uid);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | listObject.add(map);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | return listObject;
|
|---|
| | | @Override
|
|---|
| | | public List<HongBaoV2VO> listShareAndInviteMoney(long start, int count, String date) {
|
|---|
| | | return hongBaoV2CountMapper.listShareAndInviteMoney(start, count, date);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public Integer countNumberByUid(Long uid) {
|
|---|
| | | long count = hongBaoV2CountMapper.countNumberByUid(uid);
|
|---|
| | | return (int) count;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public BigDecimal countRebateCouponMoney() {
|
|---|
| | | return hongBaoV2CountMapper.countRebateCouponMoney();
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public long countRebateOrder(Long uid) {
|
|---|
| | | return hongBaoV2CountMapper.countRebateOrder(uid);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public List<Map<String, Object>> countHongBaoMoney(String channel, Integer dateType, Integer state, |
|---|
| | | String year, String startTime, String endTime) throws Exception {
|
|---|
| | | |
|---|
| | | List<Map<String, Object>> list = hongBaoV2CountMapper.countHongBaoMoney(channel, dateType, state, year, startTime, endTime);
|
|---|
| | | |
|---|
| | | if (list == null || list.size() == 0) {
|
|---|
| | | return null;
|
|---|
| | | } |
|---|
| | | |
|---|
| | | switch (dateType){
|
|---|
| | | case 1: // 按天处理
|
|---|
| | | return dayFactory(startTime, endTime, list);
|
|---|
| | | case 2: // 按月处理
|
|---|
| | | return monthFactory(list);
|
|---|
| | | case 3: |
|---|
| | | return yearFactory(list);
|
|---|
| | | default: |
|---|
| | | return null;
|
|---|
| | | }
|
|---|
| | | public long countShareOrInviteOrder(Long uid) {
|
|---|
| | | return hongBaoV2CountMapper.countShareOrInviteOrder(uid);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public BigDecimal sumAlreadyGetMoneyByUid(Long uid, List<Integer> typeList, Date minGetTime, Date maxGetTime) {
|
|---|
| | | return hongBaoV2CountMapper.sumAlreadyGetMoneyByUid(uid, typeList, minGetTime, maxGetTime);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public long countAlreadyGetMoneyByUid(Long uid, List<Integer> typeList, Date minGetTime, Date maxGetTime) {
|
|---|
| | | return hongBaoV2CountMapper.countAlreadyGetMoneyByUid(uid, typeList, minGetTime, maxGetTime);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | @Override |
|---|
| | | public BigDecimal getOrderRewardByTeamUid(Long uid, Long teamUid, Date endTime) {
|
|---|
| | | return hongBaoV2CountMapper.getOrderRewardByTeamUid(uid, teamUid, endTime);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public List<Map<String, Object>> countHongBaoNum(String channel, Integer dateType, Integer state, |
|---|
| | | String year, String startTime, String endTime) throws Exception {
|
|---|
| | | |
|---|
| | | List<Map<String, Object>> list = hongBaoV2CountMapper.countHongBaoNum(channel, dateType, state, year, startTime, endTime);
|
|---|
| | | |
|---|
| | | if (list == null || list.size() == 0) {
|
|---|
| | | return null;
|
|---|
| | | } |
|---|
| | | |
|---|
| | | switch (dateType){
|
|---|
| | | case 1: // 按天处理
|
|---|
| | | return dayFactory(startTime, endTime, list);
|
|---|
| | | case 2: // 按月处理
|
|---|
| | | return monthFactory(list);
|
|---|
| | | case 3: |
|---|
| | | return yearFactory(list);
|
|---|
| | | default: |
|---|
| | | return null;
|
|---|
| | | }
|
|---|
| | | public BigDecimal getOrderRewardByTeamUidTheMonth(Long uid, Long teamUid) {
|
|---|
| | | return hongBaoV2CountMapper.getOrderRewardByTeamUidTheMonth(uid, teamUid); |
|---|
| | | }
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public List<Map<String, Object>> getProportionByType(Integer dateType, Integer type, String year,
|
|---|
| | | String startTime, String endTime) throws Exception {
|
|---|
| | | |
|---|
| | | List<Map<String, Object>> result_list = null;
|
|---|
| | | |
|---|
| | | List<Map<String, Object>> listTotal = hongBaoV2CountMapper.countHongBaoTotalNum(dateType, year, startTime, endTime);
|
|---|
| | | if (listTotal == null || listTotal.size() == 0) {
|
|---|
| | | return result_list;
|
|---|
| | | } |
|---|
| | | |
|---|
| | | List<Map<String, Object>> type_list = hongBaoV2CountMapper.countHongBaoType(dateType, type,
|
|---|
| | | year, startTime, endTime);
|
|---|
| | | |
|---|
| | | 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;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | |
|---|
| | | for (int i = 0; i < result_list.size(); i++) {
|
|---|
| | | |
|---|
| | | float proportion = 0;
|
|---|
| | | Map<String, Object> resultMap = result_list.get(i);
|
|---|
| | | |
|---|
| | | Object showDate = resultMap.get("showDate");
|
|---|
| | | for (int j = 0; j < listTotal.size(); j++) {
|
|---|
| | | Map<String, Object> innerMap = result_list.get(j);
|
|---|
| | | Object innerDate = innerMap.get("showDate");
|
|---|
| | | |
|---|
| | | if (innerDate != null && innerDate.toString().equals(showDate.toString())) {
|
|---|
| | | Object innerValue = innerMap.get("showValue");
|
|---|
| | | long innerData = Long.parseLong(innerValue.toString());
|
|---|
| | | |
|---|
| | | Object showValue = resultMap.get("showValue");
|
|---|
| | | long showData = Long.parseLong(showValue.toString());
|
|---|
| | | |
|---|
| | | if (showData > 0) {
|
|---|
| | | proportion = innerData/showData;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | break; // 结束内部循环
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | resultMap.put("showValue", proportion);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | return result_list;
|
|---|
| | | public BigDecimal getRewardMoneyBySelf(Long uid) {
|
|---|
| | | List<Integer> list = new ArrayList<Integer>();
|
|---|
| | | list.add(HongBaoV2.TYPE_ZIGOU);
|
|---|
| | | return hongBaoV2CountMapper.getRewardMoneyByUid(uid, list);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal getRewardMoneyByShare(Long uid) {
|
|---|
| | | List<Integer> list = new ArrayList<Integer>();
|
|---|
| | | list.add(HongBaoV2.TYPE_SHARE_GOODS);
|
|---|
| | | return hongBaoV2CountMapper.getRewardMoneyByUid(uid, list);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal getRewardMoneyByInvite(Long uid) {
|
|---|
| | | List<Integer> list = new ArrayList<Integer>();
|
|---|
| | | list.add(HongBaoV2.TYPE_YIJI);
|
|---|
| | | list.add(HongBaoV2.TYPE_ERJI);
|
|---|
| | | list.add(HongBaoV2.TYPE_SHARE_YIJI);
|
|---|
| | | list.add(HongBaoV2.TYPE_SHARE_ERJI);
|
|---|
| | | return hongBaoV2CountMapper.getRewardMoneyByUid(uid, list);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public long countMyDirectOrderByCashArrival(Long uid, BigDecimal payment) {
|
|---|
| | | Long count = hongBaoV2CountMapper.countMyDirectOrderByCashArrival(uid, payment);
|
|---|
| | | if (count == null) {
|
|---|
| | | count = 0L;
|
|---|
| | | }
|
|---|
| | | return count;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal getRewardMoneyToCount(Long uid, Integer dateType, Integer hbType, List<Integer> listSource) {
|
|---|
| | | BigDecimal money = hongBaoV2CountMapper.getRewardMoneyByDate(uid, dateType, hbType, null, null, null, null, null, listSource);
|
|---|
| | | if (money == null)
|
|---|
| | | money = BigDecimal.ZERO;
|
|---|
| | | return money;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal geBonusByuid(Long uid, Integer dateType, Integer hbType, Integer moneyState) {
|
|---|
| | | BigDecimal money = hongBaoV2CountMapper.getRewardMoneyByDate(uid, dateType, hbType, null, null, moneyState, null, null, null);
|
|---|
| | | if (money == null) {
|
|---|
| | | money = new BigDecimal(0);
|
|---|
| | | }
|
|---|
| | | return money;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal getRewardMoneyByToSearch(Long uid, Integer dateType, Integer orderType, Integer orderState,
|
|---|
| | | String orderNo, Integer moneyState, String startTime, String endTime, List<Integer> listSource) {
|
|---|
| | | return hongBaoV2CountMapper.getRewardMoneyByDate(uid, dateType, orderType, orderState, orderNo, moneyState, |
|---|
| | | startTime, endTime, listSource);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal sumMoneyArrivalByUidAndNearDay(Long uid, int day) {
|
|---|
| | | return hongBaoV2CountMapper.sumMoneyArrivalByUidAndNearDay(uid, day);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal sumMoneyBySettleTimeAndUid(Long uid, Date minDate, Date maxDate) {
|
|---|
| | | BigDecimal money = hongBaoV2CountMapper.sumMoneyBySettleTimeAndUid(uid, minDate, maxDate);
|
|---|
| | | if (money == null) {
|
|---|
| | | money = new BigDecimal(0);
|
|---|
| | | }
|
|---|
| | | return money;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public BigDecimal sumMoneyByANotSettleAndUid(Long uid) {
|
|---|
| | | BigDecimal money = hongBaoV2CountMapper.sumMoneyByANotSettleAndUid(uid);
|
|---|
| | | if (money == null) {
|
|---|
| | | money = new BigDecimal(0);
|
|---|
| | | }
|
|---|
| | | return money;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | |
|---|
| | |
|
|---|
| | | }
|
|---|
