用户下单
对各种业务异常进行判断--地址簿为空,购物车为空
向订单表插入一条数据
向订单明细表插入多条数据
清空购物车
封装VO返回结果
1.1 Controller层
package com.sky.controller.user;
import com.sky.dto.OrdersDTO;
import com.sky.dto.OrdersSubmitDTO;
import com.sky.result.Result;
import com.sky.service.OrderService;
import com.sky.vo.OrderSubmitVO;
import com.sky.vo.OrderVO;
import io.swagger.annotations.Api;
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")
@Slf4j
@Api(tags = "用户端订单相关操作")
public class OrderController {
@Autowired
private OrderService orderService;
@PostMapping("/submit")
public Result<OrderSubmitVO> submit(@RequestBody OrdersSubmitDTO ordersSubmitDTO){
log.info("用户提交订单:{}",ordersSubmitDTO);
OrderSubmitVO orderSubmitVO = orderService.orderSubmit(ordersSubmitDTO);
return Result.success(orderSubmitVO);
}
}
1.2 Service层
package com.sky.service.impl;
import com.sky.constant.MessageConstant;
import com.sky.context.BaseContext;
import com.sky.dto.OrdersDTO;
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.exception.ShoppingCartBusinessException;
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 com.sky.vo.OrderVO;
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 {
@Autowired
private OrderMapper orderMapper;
@Autowired
private OrderDetailMapper orderDetailMapper;
@Autowired
private AddressBookMapper addressBookMapper;
@Autowired
private ShoppingCartMapper shoppingCartMapper;
/**
* 用户提交订单
* @param ordersSubmitDTO
* @return
*/
@Override
@Transactional
public OrderSubmitVO orderSubmit(OrdersSubmitDTO ordersSubmitDTO) {
//处理各种业务异常(地址簿为空,购物车为空)
AddressBook addressBook = addressBookMapper.getById(ordersSubmitDTO.getAddressBookId());
if(addressBook==null){
//地址簿为空
throw new AddressBookBusinessException(MessageConstant.ADDRESS_BOOK_IS_NULL);
}
ShoppingCart shoppingCart = new ShoppingCart();
Long userId = BaseContext.getCurrentId();//获取当前用户id
shoppingCart.setUserId(userId);
List<ShoppingCart> shoppingCartList = shoppingCartMapper.list(shoppingCart);
if(shoppingCartList==null || shoppingCartList.isEmpty()){
//购物车为空
throw new ShoppingCartBusinessException(MessageConstant.SHOPPING_CART_IS_NULL);
}
//向订单表插入一条数据
Orders order = new Orders();
BeanUtils.copyProperties(ordersSubmitDTO,order);
order.setNumber(String.valueOf(System.currentTimeMillis()));
order.setPayStatus(Orders.UN_PAID);
order.setStatus(Orders.PENDING_PAYMENT);
order.setUserId(userId);
order.setOrderTime(LocalDateTime.now());
order.setPhone(addressBook.getPhone());
order.setConsignee(addressBook.getConsignee());
order.setAddress(addressBook.getDetail());
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);
}
orderDetailMapper.insertBatch(orderDetailList);
//清空购物车
shoppingCartMapper.deleteByUserId(userId);
//封装VO返回结果
OrderSubmitVO orderSubmitVO = OrderSubmitVO.builder()
.id(order.getId())
.orderTime(order.getOrderTime())
.orderNumber(order.getNumber())
.orderAmount(order.getAmount())
.build();
return orderSubmitVO;
}
}
1.3 Mapper层
<?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 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>
<?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 order_detail (name, image, order_id, dish_id, setmeal_id, dish_flavor, amount)
values
<foreach collection="orderDetailList" item="od" separator=",">
(#{od.name},#{od.image},#{od.orderId},#{od.dishId},#{od.setmealId},#{od.dishFlavor},#{od.amount})
</foreach>
</insert>
</mapper>