苍穹外卖（用户下单、订单支付）

用户下单、订单支付

导入地址簿功能代码

接口设计

数据库设计（address_book表）

代码导入 

功能测试

用户下单

接口设计

数据库设计

订单表 orders 

订单明细表 order_detail 

代码开发 

根据用户下单接口的参数设计DTO 

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

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

创建OrderService接口 

创建OrderServiceImpl实现OrderService接口 

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

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

订单支付 

微信支付准备工作 

下载cpolar 

连接账户 

导入功能代码 

---

导入地址簿功能代码

接口设计

数据库设计（address_book表）

代码导入 

功能测试

用户下单

接口设计

数据库设计

订单表 orders 

订单明细表 order_detail 

代码开发 

根据用户下单接口的参数设计DTO 

初始代码已提供 

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

初始代码已提供

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

package com.sky.controller.user;import com.sky.dto.OrdersSubmitDTO;
import com.sky.result.Result;
import com.sky.service.Orderservice;
import com.sky.vo.OrderSubmitVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;@RestController("userOrderController")
@RequestMapping("/user/order")
@Api(tags = "用户端订单相关接口")
@Slf4j
public class OrderController {@Autowiredprivate 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);}
}

创建OrderService接口 

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

创建OrderServiceImpl实现OrderService接口 

package com.sky.service.impl;import com.sky.constant.MessageConstant;
import com.sky.context.BaseContext;
import com.sky.dto.OrdersSubmitDTO;
import com.sky.entity.AddressBook;
import com.sky.entity.OrderDetail;
import com.sky.entity.Orders;
import com.sky.entity.ShoppingCart;
import com.sky.exception.AddressBookBusinessException;
import com.sky.mapper.AddressBookMapper;
import com.sky.mapper.OrderDetailMapper;
import com.sky.mapper.OrderMapper;
import com.sky.mapper.ShoppingCartMapper;
import com.sky.service.Orderservice;
import com.sky.vo.OrderSubmitVO;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;@Service
public class OrderServiceImpl implements Orderservice {@Autowiredprivate OrderMapper orderMapper;@Autowiredprivate OrderDetailMapper orderDetailMapper;@Autowiredprivate AddressBookMapper addressBookMapper;@Autowiredprivate ShoppingCartMapper shoppingCartMapper;/*** 用户下单* @param ordersSubmitDTO* @return*/@Transactionalpublic 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 AddressBookBusinessException(MessageConstant.SHOPPING_CART_IS_NULL);}//向订单表插入1条数据Orders orders = new Orders();BeanUtils.copyProperties(ordersSubmitDTO, orders);orders.setOrderTime(LocalDateTime.now());orders.setPayStatus(Orders.UN_PAID);orders.setStatus(Orders.PENDING_PAYMENT);orders.setNumber(String.valueOf(System.currentTimeMillis()));orders.setPhone(addressBook.getPhone());orders.setConsignee(addressBook.getConsignee());orders.setUserId(userId);orderMapper.insert(orders);List<OrderDetail> orderDetailList = new ArrayList<>();//向订单明细表插入多条数据for(ShoppingCart cart : shoppingCartList){OrderDetail orderDetail = new OrderDetail();//订单明细BeanUtils.copyProperties(cart, orderDetail);orderDetail.setOrderId(orders.getId());//设置当前订单明细关联的订单IDorderDetailList.add(orderDetail);}orderDetailMapper.insertBatch(orderDetailList);//清空当前用户购物车中的数据shoppingCartMapper.deleteByUserId(userId);//封装VO返回结果OrderSubmitVO orderSubmitVO = OrderSubmitVO.builder().id(orders.getId()).orderTime(orders.getOrderTime()).orderNumber(orders.getNumber()).orderAmount(orders.getAmount()).build();return orderSubmitVO;}
}

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

package com.sky.mapper;import com.sky.entity.Orders;
import org.apache.ibatis.annotations.Mapper;@Mapper
public interface OrderMapper {/*** 插入订单数据* @param orders*/void insert(Orders orders);
}

<?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" useGeneratedKeys="true" keyProperty="id">insert into sky_take_out.orders(number, status, user_id, address_book_id, order_time, checkout_time, pay_method, pay_status, amount, remark, phone, address, user_name, consignee, cancel_reason, rejection_reason, cancel_time, estimated_delivery_time, delivery_status, delivery_time, pack_amount, tableware_number, tableware_status)values (#{number}, #{status}, #{userId}, #{addressBookId}, #{orderTime}, #{checkoutTime}, #{payMethod}, #{payStatus}, #{amount}, #{remark}, #{phone}, #{address}, #{userName}, #{consignee}, #{cancelReason}, #{rejectionReason}, #{cancelTime}, #{estimatedDeliveryTime}, #{deliveryStatus}, #{deliveryTime}, #{packAmount}, #{tablewareNumber}, #{tablewareStatus})</insert>
</mapper>

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

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

<?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">insert into sky_take_out.order_detail(name, image, order_id, dish_id, setmeal_id, dish_flavor, number, amount)values<foreach collection="orderDetailList" item="od" separator=",">(#{od.name}, #{od.image}, #{od.orderId}, #{od.dishId}, #{od.setmealId}, #{od.dishFlavor}, #{od.number}, #{od.amount})</foreach></insert>
</mapper>

订单支付 

微信支付准备工作 

下载cpolar 

地址：cpolar - secure introspectable tunnels to localhost 

连接账户 

在软件安装目录下打开命令行

启动服务获取IP 

导入功能代码 

没有营业执照无法真正支付，所以绕过支付，直接支付成功。

在微信小程序里的pay包下的index.js中将如下的代码注释掉 

把原先注释掉的重定向解除

把OrderServiceImpl中的如下代码注释掉

在OrderServiceImpl中，写入如下代码

 在OrderMapper中写入如下代码 

    @Update("update sky_take_out.orders set status = #{orderStatus},pay_status = #{orderPaidStatus} ,checkout_time = #{check_out_time} where id = #{id}")void updateStatus(Integer orderStatus, Integer orderPaidStatus, LocalDateTime check_out_time, Long id);

在OrderServiceImp中的如下位置给全局变量赋值