正式数据库修改

admin

2019-03-13 69bee82b81626b82b7f39f0e459e4f56b1699b51

 fanli/src/main/java/com/yeshi/fanli/service/impl/hongbao/HongBaoV2ServiceImpl.java

@@ -2,8 +2,6 @@


import java.math.BigDecimal;

import java.util.Calendar;

import java.util.Collections;

import java.util.Comparator;

import java.util.Date;

import java.util.HashMap;

import java.util.HashSet;

@@ -18,7 +16,6 @@
import org.springframework.transaction.annotation.Transactional;



import com.yeshi.fanli.dao.mybatis.HongBaoV2Mapper;

import com.yeshi.fanli.dao.mybatis.PidOrderMapper;

import com.yeshi.fanli.dao.mybatis.hongbao.HongBaoMapper;

import com.yeshi.fanli.dao.mybatis.order.CommonOrderGoodsMapper;

import com.yeshi.fanli.dao.mybatis.order.CommonOrderMapper;

@@ -37,9 +34,7 @@
import com.yeshi.fanli.entity.order.CommonOrderGoods;

import com.yeshi.fanli.entity.order.HongBaoOrder;

import com.yeshi.fanli.entity.order.ShareGoodsActivityOrder;

import com.yeshi.fanli.entity.taobao.PidOrder;

import com.yeshi.fanli.entity.taobao.TaoBaoOrder;

import com.yeshi.fanli.entity.taobao.TaoBaoWeiQuanOrder;

import com.yeshi.fanli.exception.HongBaoException;

import com.yeshi.fanli.exception.order.ShareGoodsActivityOrderException;

import com.yeshi.fanli.exception.share.UserShareGoodsRecordException;

@@ -61,7 +56,6 @@
import com.yeshi.fanli.util.MoneyBigDecimalUtil;

import com.yeshi.fanli.util.StringUtil;

import com.yeshi.fanli.util.TimeUtil;

import com.yeshi.fanli.util.taobao.TaoBaoOrderUtil;



@Service

public class HongBaoV2ServiceImpl implements HongBaoV2Service {

@@ -102,8 +96,6 @@
   @Resource

   private UserShareGoodsGroupService userShareGoodsGroupService;



   @Resource

   private PidOrderMapper pidOrderMapper;



   @Resource

   private HongBaoManageService hongBaoManageService;

@@ -162,229 +154,6 @@
      return hongBaoV2Mapper.selectByPrimaryKey(id);

   }



   private HongBaoV2 getHongBaoV2(HongBao hb) {

      int type = hb.getType().intValue();

      HongBaoV2 v2 = new HongBaoV2(hb.getId());

      v2.setCreateTime(new Date(hb.getCreatetime()));

      if (hb.getGetTime() == null || hb.getGetTime() == 0)

         v2.setGetTime(null);

      else

         v2.setGetTime(new Date(hb.getGetTime()));



      v2.setMoney(hb.getMoney());

      if (hb.getParent() != null)

         v2.setParent(new HongBaoV2(hb.getParent().getId()));



      if (hb.getType() == HongBao.TYPE_SHARE_GOODS) {

         if (hb.getBalanceTime() != null)

            v2.setPreGetTime(new Date(hb.getPreGettime()));

         else

            v2.setPreGetTime(null);

      } else {

         if (hb.getPreGettime() == null || hb.getPreGettime() == 0)

            v2.setPreGetTime(null);

         else

            v2.setPreGetTime(new Date(hb.getPreGettime()));

      }



      v2.setState(hb.getState());

      if (hb.getState() == 1 && hb.getBalanceTime() != null) {

         v2.setState(HongBaoV2.STATE_KELINGQU);

      }

      v2.setType(type);

      v2.setUpdateTime(new Date(hb.getCreatetime()));

      v2.setUrank(hb.getUrank());

      v2.setUserInfo(hb.getUserInfo());

      v2.setVersion(hb.getVersion());

      return v2;

   }



   @Transactional

   @Override

   public void convert(HongBao hb) {

      if (hb == null || hb.getParent() != null)

         return;



      int type = hb.getType().intValue();

      if (type == HongBao.TYPE_TAOBAO || type == HongBao.TYPE_SHARE_GOODS) {// 自购与分享赚需要查询出所有的订单

         // 属于返利订单

         String orderId = "";

         if (hb.getOrder() != null) {

            orderId = hb.getOrder().getOrderId();

            // 查询同一订单号的非子红包

         } else

            orderId = hb.getOrderId();



         int count = commonOrderMapper.countByOrderNOAndOrderType(orderId, Constant.SOURCE_TYPE_TAOBAO);



         // 已经插入订单

         if (count > 0)

            return;



         //



         if (hb.getVersion() == 1) {// 很老版本的处理方式,已hongbao为主

            if (hongBaoV2Mapper.selectByPrimaryKey(hb.getId()) != null)

               return;

            HongBaoV2 hongBaoV2 = getHongBaoV2(hb);

            hongBaoV2.setBeizhu("订单号:" + orderId);

            hongBaoV2Mapper.insert(hongBaoV2);



            if (hb.getHasChild())// 存在子红包

            {

               List<HongBao> children = hongBaoMapper.selectChildHongBaoByPid(hb.getId());

               if (children != null)

                  for (HongBao hongBao : children) {

                     HongBaoV2 child = getHongBaoV2(hongBao);

                     hongBaoV2Mapper.insert(child);

                  }

            }



         } else {// 新版本处理方式



            List<HongBao> list = hongBaoMapper.selectByOrderId(orderId);



            if (list.size() == 0)

               list = hongBaoMapper.selectByOid(hb.getOrder().getId());

            if (list != null)

               // 删除子红包

               for (int i = 0; i < list.size(); i++) {

               if (list.get(i).getParent() != null) {

               list.remove(i);

               i--;

               }



               }



            if (list.size() <= 0)

               return;

            if (list.get(0).getType() == 20)

               for (HongBao hb1 : list) {

                  PidOrder pidOrder = pidOrderMapper.getPidOrderByHongBaoId(hb1.getId());

                  if (pidOrder != null)

                     hb1.setAuctionId(pidOrder.getAuctionId());



               }



            List<TaoBaoOrder> orderList = taoBaoOrderMapper.selectTaoBaoOrderByOrderId(orderId);



            if (orderList == null || orderList.size() < list.size()) {

               System.out.println("红包数与订单数不对应");

               return;

            }



            // 加入排序值

            for (int i = 0; i < orderList.size(); i++) {

               orderList.get(i).setOrderBy(i + 1);

            }



            // 按照auctionId,payMoney排序

            Comparator<HongBao> cm = new Comparator<HongBao>() {

               @Override

               public int compare(HongBao o1, HongBao o2) {

                  if (o1.getAuctionId().longValue() < o2.getAuctionId().longValue())

                     return -3;

                  else if (o1.getAuctionId().longValue() > o2.getAuctionId().longValue()) {

                     return 3;

                  } else {

                     if (o1.getState() - o2.getState() > 0)

                        return 2;

                     else if (o1.getState() - o2.getState() < 0)

                        return -2;

                     else {

                        if (o1.getPayMoney().compareTo(o2.getPayMoney()) >= 0)

                           return 1;

                        else

                           return -1;

                     }

                  }

               }

            };



            Collections.sort(list, cm);



            Comparator<TaoBaoOrder> cmOrder = new Comparator<TaoBaoOrder>() {



               @Override

               public int compare(TaoBaoOrder o1, TaoBaoOrder o2) {



                  if (o1.getAuctionId().longValue() < o2.getAuctionId().longValue())

                     return -3;

                  else if (o1.getAuctionId().longValue() > o2.getAuctionId().longValue()) {

                     return 3;

                  } else {

                     if (o1.getPayment().compareTo(o2.getPayment()) < 0)

                        return 2;

                     else

                        return -2;

                  }

               }

            };



            Collections.sort(orderList, cmOrder);



            for (TaoBaoOrder t : orderList)

               System.out.println(t.getAuctionId());



            for (int i = 0; i < list.size(); i++) {

               CommonOrder commonOrder = TaoBaoOrderUtil.convert(orderList.get(i));

               CommonOrderGoods goods = new CommonOrderGoods();

               goods.setGoodsId(orderList.get(i).getAuctionId() + "");

               goods.setGoodsType(Constant.SOURCE_TYPE_TAOBAO);

               // 商品是否已经插入

               List<CommonOrderGoods> commonGoodsList = commonOrderGoodsMapper

                     .listByGoodsIdAndGoodsType(goods.getGoodsId(), goods.getGoodsType());

               if (commonGoodsList.size() <= 0)// 不存在就插入商品

                  commonOrderGoodsMapper.insertSelective(goods);

               else

                  goods.setId(commonGoodsList.get(commonGoodsList.size() - 1).getId());

               commonOrder.setCommonOrderGoods(goods);



               commonOrder.setUserInfo(list.get(i).getUserInfo());

               commonOrder.setCreateTime(new Date(list.get(i).getCreatetime()));



               // TODO 维权判断

               List<TaoBaoWeiQuanOrder> weiQuanList = taoBaoWeiQuanOrderMapper.selectListByOrderIdAndState(orderId,

                     "维权成功");

               if (weiQuanList != null && weiQuanList.size() > 0)

                  commonOrder.setState(CommonOrder.STATE_WQ);



               commonOrderMapper.insertSelective(commonOrder);



               // 插入红包

               HongBaoV2 hongBaoV2 = getHongBaoV2(list.get(i));

               hongBaoV2.setId(list.get(i).getId());

               hongBaoV2Mapper.insert(hongBaoV2);



               HongBaoOrder ho = new HongBaoOrder();

               ho.setCommonOrder(commonOrder);

               ho.setCreateTime(new Date());

               ho.setHongBaoV2(hongBaoV2);

               hongBaoOrderMapper.insertSelective(ho);



               if (list.get(i).getHasChild())// 存在子红包

               {

                  List<HongBao> children = hongBaoMapper.selectChildHongBaoByPid(list.get(i).getId());

                  if (children != null)

                     for (HongBao hongBao : children) {

                        HongBaoV2 child = getHongBaoV2(hongBao);

                        hongBaoV2Mapper.insert(child);

                     }

               }

            }

         }



      } else {// 直接插入



         if (type != HongBao.TYPE_ERJI && type != HongBao.TYPE_YIJI && type != HongBao.TYPE_SHARE_YIJI

               && type != HongBao.TYPE_SHARE_ERJI) {

            if (hongBaoV2Mapper.selectByPrimaryKey(hb.getId()) == null)

               hongBaoV2Mapper.insert(getHongBaoV2(hb));

         }



      }



   }



   @Transactional

   @Override

@@ -542,7 +311,7 @@
            hongBao.setPreGetTime(new Date(commonOrder.getSettleTime().getTime() + 1000 * 60 * 60 * 24 * 15L));

            if (mianDan)

               hongBao.setMoney(commonOrder.getSettlement().compareTo(commonOrder.getPayment()) <= 0

                     ? commonOrder.getSettlement() : commonOrder.getPayment());//返利结算与付款较小的金额

                     ? commonOrder.getSettlement() : commonOrder.getPayment());// 返利结算与付款较小的金额

         } else if (commonOrder.getState() == CommonOrder.STATE_SX) {

            hongBao.setState(HongBaoV2.STATE_SHIXIAO);

            hongBao.setMoney(new BigDecimal(0));