数据库课程作业，仿天猫商场，着重数据库的设计，前端由thymeleaf设计，

package ltd.Emallix.mall.service.impl; import ltd.Emallix.mall.common.*; import ltd.Emallix.mall.controller.vo.*; import ltd.Emallix.mall.dao.EmallixMallGoodsMapper; import ltd.Emallix.mall.dao.EmallixMallOrderItemMapper; import ltd.Emallix.mall.dao.EmallixMallOrderMapper; import ltd.Emallix.mall.dao.EmallixMallShoppingCartItemMapper; import ltd.Emallix.mall.entity.EmallixMallGoods; import ltd.Emallix.mall.entity.EmallixMallOrder; import ltd.Emallix.mall.entity.EmallixMallOrderItem; import ltd.Emallix.mall.entity.StockNumDTO; import ltd.Emallix.mall.service.EmallixMallOrderService; import ltd.Emallix.mall.util.BeanUtil; import ltd.Emallix.mall.util.NumberUtil; import ltd.Emallix.mall.util.PageQueryUtil; import ltd.Emallix.mall.util.PageResult; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import org.springframework.util.StringUtils; import java.util.*; import java.util.function.Function; import java.util.stream.Collectors; import static java.util.stream.Collectors.groupingBy; @Service @Transactional public class EmallixMallOrderServiceImpl implements EmallixMallOrderService { @Autowired private EmallixMallOrderMapper EmallixMallOrderMapper; @Autowired private EmallixMallOrderItemMapper EmallixMallOrderItemMapper; @Autowired private EmallixMallShoppingCartItemMapper EmallixMallShoppingCartItemMapper; @Autowired private EmallixMallGoodsMapper EmallixMallGoodsMapper; @Override public PageResult getEmallixMallOrdersPage(PageQueryUtil pageUtil) { List<EmallixMallOrder> EmallixMallOrders = EmallixMallOrderMapper.findEmallixMallOrderList(pageUtil); int total = EmallixMallOrderMapper.getTotalEmallixMallOrders(pageUtil); PageResult pageResult = new PageResult(EmallixMallOrders, total, pageUtil.getLimit(), pageUtil.getPage()); return pageResult; } @Override @Transactional public String updateOrderInfo(EmallixMallOrder EmallixMallOrder) { EmallixMallOrder temp = EmallixMallOrderMapper.selectByPrimaryKey(EmallixMallOrder.getOrderId()); //不为空且orderStatus>=0且状态为出库之前可以修改部分信息 if (temp != null && temp.getOrderStatus() >= 0 && temp.getOrderStatus() < 3) { temp.setTotalPrice(EmallixMallOrder.getTotalPrice()); temp.setUserAddress(EmallixMallOrder.getUserAddress()); temp.setUpdateTime(new Date()); if (EmallixMallOrderMapper.updateByPrimaryKeySelective(temp) > 0) { return ServiceResultEnum.SUCCESS.getResult(); } return ServiceResultEnum.DB_ERROR.getResult(); } return ServiceResultEnum.DATA_NOT_EXIST.getResult(); } @Override @Transactional public String checkDone(Long[] ids) { //查询所有的订单 判断状态 修改状态和更新时间 List<EmallixMallOrder> orders = EmallixMallOrderMapper.selectByPrimaryKeys(Arrays.asList(ids)); String errorOrderNos = ""; if (!CollectionUtils.isEmpty(orders)) { for (EmallixMallOrder EmallixMallOrder : orders) { if (EmallixMallOrder.getIsDeleted() == 1) { errorOrderNos += EmallixMallOrder.getOrderNo() + " "; continue; } if (EmallixMallOrder.getOrderStatus() != 1) { errorOrderNos += EmallixMallOrder.getOrderNo() + " "; } } if (!StringUtils.hasText(errorOrderNos)) { //订单状态正常 可以执行配货完成操作 修改订单状态和更新时间 if (EmallixMallOrderMapper.checkDone(Arrays.asList(ids)) > 0) { return ServiceResultEnum.SUCCESS.getResult(); } else { return ServiceResultEnum.DB_ERROR.getResult(); } } else { //订单此时不可执行出库操作 if (errorOrderNos.length() > 0 && errorOrderNos.length() < 100) { return errorOrderNos + "订单的状态不是支付成功无法执行出库操作"; } else { return "你选择了太多状态不是支付成功的订单，无法执行配货完成操作"; } } } //未查询到数据 返回错误提示 return ServiceResultEnum.DATA_NOT_EXIST.getResult(); } @Override @Transactional public String checkOut(Long[] ids) { //查询所有的订单 判断状态 修改状态和更新时间 List<EmallixMallOrder> orders = EmallixMallOrderMapper.selectByPrimaryKeys(Arrays.asList(ids)); String errorOrderNos = ""; if (!CollectionUtils.isEmpty(orders)) { for (EmallixMallOrder EmallixMallOrder : orders) { if (EmallixMallOrder.getIsDeleted() == 1) { errorOrderNos += EmallixMallOrder.getOrderNo() + " "; continue; } if (EmallixMallOrder.getOrderStatus() != 1 && EmallixMallOrder.getOrderStatus() != 2) { errorOrderNos += EmallixMallOrder.getOrderNo() + " "; } } if (!StringUtils.hasText(errorOrderNos)) { //订单状态正常 可以执行出库操作 修改订单状态和更新时间 if (EmallixMallOrderMapper.checkOut(Arrays.asList(ids)) > 0) { return ServiceResultEnum.SUCCESS.getResult(); } else { return ServiceResultEnum.DB_ERROR.getResult(); } } else { //订单此时不可执行出库操作 if (errorOrderNos.length() > 0 && errorOrderNos.length() < 100) { return errorOrderNos + "订单的状态不是支付成功或配货完成无法执行出库操作"; } else { return "你选择了太多状态不是支付成功或配货完成的订单，无法执行出库操作"; } } } //未查询到数据 返回错误提示 return ServiceResultEnum.DATA_NOT_EXIST.getResult(); } @Override @Transactional public String closeOrder(Long[] ids) { //查询所有的订单 判断状态 修改状态和更新时间 List<EmallixMallOrder> orders = EmallixMallOrderMapper.selectByPrimaryKeys(Arrays.asList(ids)); String errorOrderNos = ""; if (!CollectionUtils.isEmpty(orders)) { for (EmallixMallOrder EmallixMallOrder : orders) { // isDeleted=1 一定为已关闭订单 if (EmallixMallOrder.getIsDeleted() == 1) { errorOrderNos += EmallixMallOrder.getOrderNo() + " "; continue; } //已关闭或者已完成无法关闭订单 if (EmallixMallOrder.getOrderStatus() == 4 || EmallixMallOrder.getOrderStatus() < 0) { errorOrderNos += EmallixMallOrder.getOrderNo() + " "; } } if (!StringUtils.hasText(errorOrderNos)) { //订单状态正常 可以执行关闭操作 修改订单状态和更新时间&&恢复库存 if (EmallixMallOrderMapper.closeOrder(Arrays.asList(ids), EmallixOrderStatusEnum.ORDER_CLOSED_BY_JUDGE.getOrderStatus()) > 0 && recoverStockNum(Arrays.asList(ids))) { return ServiceResultEnum.SUCCESS.getResult(); } else { return ServiceResultEnum.DB_ERROR.getResult(); } } else { //订单此时不可执行关闭操作 if (errorOrderNos.length() > 0 && errorOrderNos.length() < 100) { return er