15生鲜电商平台-售后模块的设计与架构(代码片段)

CREATE TABLE `suggestion` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘自动增加ID‘,
  `suggestion_content` varchar(1024) DEFAULT NULL COMMENT ‘建议内容‘,
  `suggestion_imgs` varchar(255) DEFAULT NULL COMMENT ‘多张图片‘,
  `user_id` bigint(20) DEFAULT NULL COMMENT ‘所属用户ID‘,
  `create_time` datetime DEFAULT NULL COMMENT ‘创建时间‘,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COMMENT=‘用户对平台的建议‘;

CREATE TABLE `suggestion_reply` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘自动增加ID‘,
  `suggestion_id` bigint(20) DEFAULT NULL COMMENT ‘客户的建议?ID‘,
  `content` varchar(512) DEFAULT NULL COMMENT ‘回复的内容‘,
  `create_time` datetime DEFAULT NULL COMMENT ‘创建时间‘,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT=‘客户建议回复信息表‘;

CREATE TABLE `order_timeline` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘自动增加ID‘,
  `item_id` bigint(20) DEFAULT NULL COMMENT ‘订单项ID‘,
  `remarks` varchar(256) DEFAULT NULL COMMENT ‘备注‘,
  `create_time` datetime DEFAULT NULL COMMENT ‘创建时间‘,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1980 DEFAULT CHARSET=utf8 COMMENT=‘售后模块，退换货时间轴，针对的是某一个订单项‘;

补货需求
业务需求：
    当卖家主动点击缺货，则配送师傅看到这个异常订单项，然后他有两种选择，
第一种补货（有货，他也想补或者客户说要货不要钱）
第二种不补货（无货可补，他不想补或者客户说退钱等等）
第一种补货业务：
1.    当配送师傅点击已补货，则把这个订单项对应的金额从买家中直接扣除，前提是线上付款，如果这个订单是线下付款，则不用处理扣款逻辑，直接修改状态即可。同时记录时间轴日志。
第二种不补货业务：
2.    当师傅点击不补货，则这个订单项不做任何扣款逻辑，不管线下还是线上，直接修改状态即可，同时记录时间轴日志。
补充说明：补货与不补货属于互斥操作，即已补货后不允许再出现不补货，不补货后不再允许出现补货。按照规则来处理。

/**
 * 订单项退货*/
@RestController
@RequestMapping("/delivery")
public class OrderReturnController extends BaseController 

    private static final Logger logger = LoggerFactory.getLogger(OrderReturnController.class);

    @Autowired
    private OrderItemService orderItemService;

    @Autowired
    private OrderReturnService orderReturnService;

    /**
     * 订单项退货
     * 
     */
    @RequestMapping(value = "/order/return/item", method =  RequestMethod.GET, RequestMethod.POST )
    public JsonResult orderReturnItem(HttpServletRequest request, HttpServletResponse response,
            @Param("itemId") Long itemId, @Param("deliveryId") Long deliveryId, @Param("status") int status) 
        try 
            if (itemId == null) 
                return new JsonResult(JsonResultCode.FAILURE, "item参数有误", "");
            

            OrderItem orderItem = orderItemService.getOrderItemByItemId(itemId);

            if (orderItem == null) 
                return new JsonResult(JsonResultCode.FAILURE, "无此订单项", "");
            
            
            String returnMsg = "";
            if(status == BuyerStatus.THREE)
                returnMsg = TimelineTemplate.return_MSG;
            if(status == BuyerStatus.FOUR)
                returnMsg = TimelineTemplate.BACK_MSG;
            if(status == BuyerStatus.ZERO)
                returnMsg = TimelineTemplate.OFF_MSG;
            
            orderItemService.updateOrderItemStatus(itemId, status, deliveryId, returnMsg);
            return new JsonResult(JsonResultCode.SUCCESS, "操作成功", "");
         catch (Exception ex) 
            logger.error("[OrderReturnController][orderReturnItem] exception :", ex);
            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");
        
    

    /**
     * 退还列表
     */
    @RequestMapping(value = "/order/return/list", method =  RequestMethod.GET, RequestMethod.POST )
    public JsonResult orderReturnList(HttpServletRequest request, HttpServletResponse response,@Param("deliveryId") Long deliveryId, @Param("status") int status) 
        try 
        
            // 组装成为最终的列表结果
            List<OrderReturnVo> listResult = new ArrayList<OrderReturnVo>();

            List<OrderGoodsVo> goodsList = orderReturnService.getReturnOrderGoodsList(deliveryId,status);

            if (CollectionUtils.isEmpty(goodsList)) 
                return new JsonResult(JsonResultCode.SUCCESS, "查询完成", listResult);
            

            // 临时参数，判断时间
            Map<String, List<OrderReturnEntity>> paramTimeMap = new HashMap<String, List<OrderReturnEntity>>();

            // 过滤卖家
            Map<String, List<OrderGoodsVo>> paramSellerMap = new HashMap<String, List<OrderGoodsVo>>();

            for (OrderGoodsVo vo : goodsList) 
                String bestTime = DateUtil.dateToString(vo.getBestTime(), "yyyy-MM-dd");

                // 时间相同
                if (paramTimeMap.get(bestTime) != null) 
                    List<OrderReturnEntity> mapOrderReturnEntity = paramTimeMap.get(bestTime);

                    // 组装时间
                    OrderReturnVo resultVo = new OrderReturnVo();
                    resultVo.setBestTime(bestTime);

                    // 判断是否是同一个卖家的
                    if (paramSellerMap.get(vo.getSellerName()) != null) 
                    
                        OrderReturnEntity entity = new OrderReturnEntity();
                        List<OrderGoodsVo> listVo = paramSellerMap.get(vo.getSellerName());
                        listVo.add(vo);
                        entity.setListOrderGoodsVo(listVo);
                        resultVo.setListOrderReturnEntity(mapOrderReturnEntity);
                    else
                    
                        //不同买家
                        OrderReturnEntity entity = new OrderReturnEntity();
                        entity.setSellerName(vo.getSellerName());
                        
                        List<OrderGoodsVo> listVo =new ArrayList<OrderGoodsVo>();
                        listVo.add(vo);
                        entity.setListOrderGoodsVo(listVo);
                        mapOrderReturnEntity.add(entity);
                        
                        paramSellerMap.put(vo.getSellerName(), listVo);
                    
                 else 
                    // 组装时间
                    OrderReturnVo resultVo = new OrderReturnVo();
                    resultVo.setBestTime(bestTime);

                    OrderReturnEntity entity = new OrderReturnEntity();
                    entity.setSellerName(vo.getSellerName());

                    List<OrderGoodsVo> paramOrderGoodsVo = new ArrayList<OrderGoodsVo>();
                    paramOrderGoodsVo.add(vo);
                    entity.setListOrderGoodsVo(paramOrderGoodsVo);

                    List<OrderReturnEntity> listOrderReturnEntity = new ArrayList<OrderReturnEntity>();
                    listOrderReturnEntity.add(entity);

                    resultVo.setListOrderReturnEntity(listOrderReturnEntity);

                    listResult.add(resultVo);

                    paramSellerMap.put(vo.getSellerName(), paramOrderGoodsVo);

                    paramTimeMap.put(bestTime, listOrderReturnEntity);
                
            
            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", listResult);
         catch (Exception ex) 
            logger.error("[OrderReturnController][orderReturnItem] exception :", ex);
            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");