正式数据库修改

admin

2019-03-13 69bee82b81626b82b7f39f0e459e4f56b1699b51

 fanli/src/main/java/com/yeshi/fanli/service/impl/taobao/TaoBaoOrderServiceImpl.java

@@ -47,6 +47,7 @@
         } catch (Exception e) {



         }

			
         addTaoBaoOrder(orderId, map.get(orderId));

         try {

            // 6小时内不再处理

@@ -69,18 +70,26 @@
            taoBaoOrderMapper.insertSelective(taoBaoOrder);

         }

      } else {

         boolean hasPayOrder = false;

         for (TaoBaoOrder order : oldOrderList)

            if (order.getOrderState().equalsIgnoreCase("订单付款")) {

               hasPayOrder = true;

               break;

            }

         // 删除原来的订单，加入新订单

         if (hasPayOrder) {

         if (StringUtil.isNullOrEmpty(oldOrderList.get(0).getTradeId())) {

            taoBaoOrderMapper.deleteByOrderId(orderId);

            for (TaoBaoOrder taoBaoOrder : list) {

               taoBaoOrder.setLatestUpdateTime(new Date());

               taoBaoOrderMapper.insertSelective(taoBaoOrder);

            }

         } else {

            // 按tradeId更新

            for (TaoBaoOrder taoBaoOrder : list) {

               TaoBaoOrder order = taoBaoOrderMapper.selectTaoBaoOrderByTradeId(taoBaoOrder.getTradeId());

               if (order == null) {

                  taoBaoOrder.setLatestUpdateTime(new Date());

                  taoBaoOrderMapper.insertSelective(taoBaoOrder);

               } else {

                  taoBaoOrder.setId(order.getId());

                  taoBaoOrder.setRelationId(order.getRelationId());

                  taoBaoOrder.setSpecialId(order.getSpecialId());

                  taoBaoOrder.setLatestUpdateTime(new Date());

                  taoBaoOrderMapper.updateByPrimaryKeySelective(taoBaoOrder);

               }

            }

         }

      }

@@ -91,10 +100,24 @@
      return taoBaoOrderMapper.selectTaoBaoOrderByOrderId(orderId);

   }





   @Override

   public double countEstimate(String date) throws Exception {

      return taoBaoOrderMapper.countEstimate(date);

   }



   @Override

   public void bindSpecialIdAndRealtionId(String tradeId, String specialId, String realtionId) {

      if (StringUtil.isNullOrEmpty(specialId) && StringUtil.isNullOrEmpty(realtionId))

         return;

      TaoBaoOrder order = taoBaoOrderMapper.selectTaoBaoOrderByTradeId(tradeId);

      if (order != null) {

         TaoBaoOrder update = new TaoBaoOrder();

         update.setId(order.getId());

         update.setSpecialId(specialId);

         update.setRelationId(realtionId);

         update.setLatestUpdateTime(new Date());

         taoBaoOrderMapper.updateByPrimaryKeySelective(update);

      }

   }



}