基于SpringBoot+Redis的前后端分离外卖项目-苍穹外卖微信小程序端(十四)

忘是亡心i 2024-04-17 10:03 8阅读 0赞

#### 用户下单 ####

*   *   *  2.1 需求分析和设计
         *   *  2.1.1 产品原型
             *  2.1.2 接口设计
             *  2.1.3 表设计
         *  2.2 代码开发
         *   *  2.2.1 DTO设计
             *  2.2.2 VO设计
             *  2.2.3 Controller层
             *  2.2.4 Service层接口
             *  2.2.5 Service层实现类
             *  2.2.6 Mapper层
         *  2.3 功能测试

#### 2.1 需求分析和设计 ####

##### 2.1.1 产品原型 #####

**用户下单业务说明：**  
在电商系统中，用户是通过下单的方式通知商家，用户已经购买了商品，需要商家进行备货和发货。用户将菜品或者套餐加入购物车后，可以点击购物车中的 “去结算” 按钮，页面跳转到订单确认页面，点击 “去支付” 按钮则完成下单操作。

**用户点餐业务流程(效果图)：**  
![在这里插入图片描述][48300412806b4e2faadf8ce708221469.png]

##### 2.1.2 接口设计 #####

**接口分析：**  
![在这里插入图片描述][9ead4668802c4e4190e747cd10795749.png]

**接口设计：**  
![在这里插入图片描述][9d64861d387244eda0b53eabe7ea68e8.png]

##### 2.1.3 表设计 #####

用户下单业务对应的数据表为orders表和order\_detail表(一对多关系,一个订单关联多个订单明细)：

<table> 
 <thead> 
  <tr> 
   <th>表名</th> 
   <th>含义</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>orders</td> 
   <td>订单表</td> 
   <td>主要存储订单的基本信息(如: 订单号、状态、金额、支付方式、下单用户、收件地址等)</td> 
  </tr> 
  <tr> 
   <td>order_detail</td> 
   <td>订单明细表</td> 
   <td>主要存储订单详情信息(如: 该订单关联的套餐及菜品的信息)</td> 
  </tr> 
 </tbody> 
</table>

具体的表结构如下:

**1). orders订单表**

<table> 
 <thead> 
  <tr> 
   <th><strong>字段名</strong></th> 
   <th><strong>数据类型</strong></th> 
   <th><strong>说明</strong></th> 
   <th><strong>备注</strong></th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>bigint</td> 
   <td>主键</td> 
   <td>自增</td> 
  </tr> 
  <tr> 
   <td>number</td> 
   <td>varchar(50)</td> 
   <td>订单号</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>status</td> 
   <td>int</td> 
   <td>订单状态</td> 
   <td>1待付款 2待接单 3已接单 4派送中 5已完成 6已取消</td> 
  </tr> 
  <tr> 
   <td>user_id</td> 
   <td>bigint</td> 
   <td>用户id</td> 
   <td>逻辑外键</td> 
  </tr> 
  <tr> 
   <td>address_book_id</td> 
   <td>bigint</td> 
   <td>地址id</td> 
   <td>逻辑外键</td> 
  </tr> 
  <tr> 
   <td>order_time</td> 
   <td>datetime</td> 
   <td>下单时间</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>checkout_time</td> 
   <td>datetime</td> 
   <td>付款时间</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>pay_method</td> 
   <td>int</td> 
   <td>支付方式</td> 
   <td>1微信支付 2支付宝支付</td> 
  </tr> 
  <tr> 
   <td>pay_status</td> 
   <td>tinyint</td> 
   <td>支付状态</td> 
   <td>0未支付 1已支付 2退款</td> 
  </tr> 
  <tr> 
   <td>amount</td> 
   <td>decimal(10,2)</td> 
   <td>订单金额</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>remark</td> 
   <td>varchar(100)</td> 
   <td>备注信息</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>phone</td> 
   <td>varchar(11)</td> 
   <td>手机号</td> 
   <td>冗余字段</td> 
  </tr> 
  <tr> 
   <td>address</td> 
   <td>varchar(255)</td> 
   <td>详细地址信息</td> 
   <td>冗余字段</td> 
  </tr> 
  <tr> 
   <td>consignee</td> 
   <td>varchar(32)</td> 
   <td>收货人</td> 
   <td>冗余字段</td> 
  </tr> 
  <tr> 
   <td>cancel_reason</td> 
   <td>varchar(255)</td> 
   <td>订单取消原因</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>rejection_reason</td> 
   <td>varchar(255)</td> 
   <td>拒单原因</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>cancel_time</td> 
   <td>datetime</td> 
   <td>订单取消时间</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>estimated_delivery_time</td> 
   <td>datetime</td> 
   <td>预计送达时间</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>delivery_status</td> 
   <td>tinyint</td> 
   <td>配送状态</td> 
   <td>1立即送出 0选择具体时间</td> 
  </tr> 
  <tr> 
   <td>delivery_time</td> 
   <td>datetime</td> 
   <td>送达时间</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>pack_amount</td> 
   <td>int</td> 
   <td>打包费</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>tableware_number</td> 
   <td>int</td> 
   <td>餐具数量</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>tableware_status</td> 
   <td>tinyint</td> 
   <td>餐具数量状态</td> 
   <td>1按餐量提供 0选择具体数量</td> 
  </tr> 
 </tbody> 
</table>

**2). order\_detail订单明细表**

**说明**：用户提交订单时，需要往订单表orders中插入一条记录，并且需要往order\_detail中插入一条或多条记录。

#### 2.2 代码开发 ####

##### 2.2.1 DTO设计 #####

**根据用户下单接口的参数设计DTO：**  
![在这里插入图片描述][af3690cc72c0481ab2be2d3a4b222cfa.png]

在sky-pojo模块，OrdersSubmitDTO.java已定义

package com.sky.dto;
    
    @Data
    public class OrdersSubmitDTO implements Serializable {
        
        //地址簿id
        private Long addressBookId;
        //付款方式
        private int payMethod;
        //备注
        private String remark;
        //预计送达时间
        @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd HH:mm:ss")
        private LocalDateTime estimatedDeliveryTime;
        //配送状态  1立即送出  0选择具体时间
        private Integer deliveryStatus;
        //餐具数量
        private Integer tablewareNumber;
        //餐具数量状态  1按餐量提供  0选择具体数量
        private Integer tablewareStatus;
        //打包费
        private Integer packAmount;
        //总金额
        private BigDecimal amount;
    }

##### 2.2.2 VO设计 #####

**根据用户下单接口的返回结果设计VO：**

![在这里插入图片描述][2ff9b8abee45490ab1a63369894a5ad5.png]

在sky-pojo模块，OrderSubmitVO.java已定义

package com.sky.vo;
    
    
    @Data
    @Builder
    @NoArgsConstructor
    @AllArgsConstructor
    public class OrderSubmitVO implements Serializable {
        
        //订单id
        private Long id;
        //订单号
        private String orderNumber;
        //订单金额
        private BigDecimal orderAmount;
        //下单时间
        private LocalDateTime orderTime;
    }

##### 2.2.3 Controller层 #####

**创建OrderController并提供用户下单方法：**

package com.sky.controller.user;
    
    /**
     * 订单
     */
    @RestController("userOrderController")
    @RequestMapping("/user/order")
    @Slf4j
    @Api(tags = "C端-订单接口")
    public class OrderController {
        
    
        @Autowired
        private OrderService orderService;
    
        /**
         * 用户下单
         *
         * @param ordersSubmitDTO
         * @return
         */
        @PostMapping("/submit")
        @ApiOperation("用户下单")
        public Result<OrderSubmitVO> submit(@RequestBody OrdersSubmitDTO ordersSubmitDTO) {
        
            log.info("用户下单：{}", ordersSubmitDTO);
            OrderSubmitVO orderSubmitVO = orderService.submitOrder(ordersSubmitDTO);
            return Result.success(orderSubmitVO);
        } 
    
    }

##### 2.2.4 Service层接口 #####

**创建OrderService接口，并声明用户下单方法：**

package com.sky.service;
    
    import com.sky.dto.*;
    import com.sky.vo.OrderSubmitVO;
    
    public interface OrderService {
        
    
        /**
         * 用户下单
         * @param ordersSubmitDTO
         * @return
         */
        OrderSubmitVO submitOrder(OrdersSubmitDTO ordersSubmitDTO);
    }

##### 2.2.5 Service层实现类 #####

**创建OrderServiceImpl实现OrderService接口：**

package com.sky.service.impl;
    
    /**
     * 订单
     */
    @Service
    @Slf4j
    public class OrderServiceImpl implements OrderService {
        
        @Autowired
        private OrderMapper orderMapper;
        @Autowired
        private OrderDetailMapper orderDetailMapper;
        @Autowired
        private ShoppingCartMapper shoppingCartMapper;
        @Autowired
        private AddressBookMapper addressBookMapper;
    
    
        /**
         * 用户下单
         *
         * @param ordersSubmitDTO
         * @return
         */
        @Transactional
        public OrderSubmitVO submitOrder(OrdersSubmitDTO ordersSubmitDTO) {
        
            //异常情况的处理（收货地址为空、超出配送范围、购物车为空）
            AddressBook addressBook = addressBookMapper.getById(ordersSubmitDTO.getAddressBookId());
            if (addressBook == null) {
        
                throw new AddressBookBusinessException(MessageConstant.ADDRESS_BOOK_IS_NULL);
            }
    
            Long userId = BaseContext.getCurrentId();
            ShoppingCart shoppingCart = new ShoppingCart();
            shoppingCart.setUserId(userId);
    
            //查询当前用户的购物车数据
            List<ShoppingCart> shoppingCartList = shoppingCartMapper.list(shoppingCart);
            if (shoppingCartList == null || shoppingCartList.size() == 0) {
        
                throw new ShoppingCartBusinessException(MessageConstant.SHOPPING_CART_IS_NULL);
            }
    
            //构造订单数据
            Orders order = new Orders();
            BeanUtils.copyProperties(ordersSubmitDTO,order);
            order.setPhone(addressBook.getPhone());
            order.setAddress(addressBook.getDetail());
            order.setConsignee(addressBook.getConsignee());
            order.setNumber(String.valueOf(System.currentTimeMillis()));
            order.setUserId(userId);
            order.setStatus(Orders.PENDING_PAYMENT);
            order.setPayStatus(Orders.UN_PAID);
            order.setOrderTime(LocalDateTime.now());
    
            //向订单表插入1条数据
            orderMapper.insert(order);
    
            //订单明细数据
            List<OrderDetail> orderDetailList = new ArrayList<>();
            for (ShoppingCart cart : shoppingCartList) {
        
                OrderDetail orderDetail = new OrderDetail();
                BeanUtils.copyProperties(cart, orderDetail);
                orderDetail.setOrderId(order.getId());
                orderDetailList.add(orderDetail);
            }
    
            //向明细表插入n条数据
            orderDetailMapper.insertBatch(orderDetailList);
    
            //清理购物车中的数据
            shoppingCartMapper.deleteByUserId(userId);
    
            //封装返回结果
            OrderSubmitVO orderSubmitVO = OrderSubmitVO.builder()
                    .id(order.getId())
                    .orderNumber(order.getNumber())
                    .orderAmount(order.getAmount())
                    .orderTime(order.getOrderTime())
                    .build();
    
            return orderSubmitVO;
        }
        
    }

##### 2.2.6 Mapper层 #####

**创建OrderMapper接口和对应的xml映射文件：**

OrderMapper.java

package com.sky.mapper;
    
    @Mapper
    public interface OrderMapper {
        
        /**
         * 插入订单数据
         * @param order
         */
        void insert(Orders order);
    }

OrderMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.sky.mapper.OrderMapper">
    
        <insert id="insert" parameterType="Orders" useGeneratedKeys="true" keyProperty="id">
            insert into orders
            (number, status, user_id, address_book_id, order_time, checkout_time, pay_method, pay_status, amount, remark,
             phone, address, consignee, estimated_delivery_time, delivery_status, pack_amount, tableware_number,
             tableware_status)
            values (#{number}, #{status}, #{userId}, #{addressBookId}, #{orderTime}, #{checkoutTime}, #{payMethod},
                    #{payStatus}, #{amount}, #{remark}, #{phone}, #{address}, #{consignee},
                    #{estimatedDeliveryTime}, #{deliveryStatus}, #{packAmount}, #{tablewareNumber}, #{tablewareStatus})
        </insert>
    </mapper>

**创建OrderDetailMapper接口和对应的xml映射文件：**

OrderDetailMapper.java

package com.sky.mapper;
    
    import com.sky.entity.OrderDetail;
    import java.util.List;
    
    @Mapper
    public interface OrderDetailMapper {
        
    
        /**
         * 批量插入订单明细数据
         * @param orderDetails
         */
        void insertBatch(List<OrderDetail> orderDetails);
    
    }

OrderDetailMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.sky.mapper.OrderDetailMapper">
    
        <insert id="insertBatch" parameterType="list">
            insert into order_detail
            (name, order_id, dish_id, setmeal_id, dish_flavor, number, amount, image)
            values
            <foreach collection="orderDetails" item="od" separator=",">
                (#{od.name},#{od.orderId},#{od.dishId},#{od.setmealId},#{od.dishFlavor},
                 #{od.number},#{od.amount},#{od.image})
            </foreach>
        </insert>
    
    </mapper>

#### 2.3 功能测试 ####

**去结算–>去支付**

![在这里插入图片描述][6f971eeda0f74c26871655ff68572095.png]

**后记  
👉👉💕💕美好的一天，到此结束，下次继续努力！欲知后续，请看下回分解，写作不易，感谢大家的支持！！ 🌹🌹🌹**

[48300412806b4e2faadf8ce708221469.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/e0e1f486b1594899ab9d71c1c0982e47.png
[9ead4668802c4e4190e747cd10795749.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/376037b998e5413994b316fd7385e8de.png
[9d64861d387244eda0b53eabe7ea68e8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/7fcb0a30c78b4089a3b1a2f11549ce32.png
[af3690cc72c0481ab2be2d3a4b222cfa.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/2f14672ae68b449db2ec8d32a5abddf4.png
[2ff9b8abee45490ab1a63369894a5ad5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/7957609007494dcfaaf65bc89f5b8045.png
[6f971eeda0f74c26871655ff68572095.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/15/fd4b61b6a89148d19600befc7133fa74.png