package ltd.newbee.mall.controller.admin;
import ltd.newbee.mall.common.ServiceResultEnum;
import ltd.newbee.mall.controller.vo.NewBeeMallOrderItemVO;
import ltd.newbee.mall.entity.NewBeeMallOrder;
import ltd.newbee.mall.service.NewBeeMallOrderService;
import ltd.newbee.mall.util.PageQueryUtil;
import ltd.newbee.mall.util.Result;
import ltd.newbee.mall.util.ResultGenerator;
import org.springframework.stereotype.Controller;
import org.springframework.util.CollectionUtils;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;
import java.util.Map;
import java.util.Objects;
@Controller
@RequestMapping(“/admin”)
public class NewBeeMallOrderController {
@Resource
private NewBeeMallOrderService newBeeMallOrderService;
@GetMapping(“/orders”)
public String ordersPage(HttpServletRequest request) {
request.setAttribute(“path”, “orders”);
return “admin/newbee_mall_order”;
}
@RequestMapping(value = “/orders/list”, method = RequestMethod.GET)
@ResponseBody
public Result list(@RequestParam Map
if (StringUtils.isEmpty(params.get(“page”)) || StringUtils.isEmpty(params.get(“limit”))) {
return ResultGenerator.genFailResult(“参数异常！”);
}
PageQueryUtil pageUtil = new PageQueryUtil(params);
return ResultGenerator.genSuccessResult(newBeeMallOrderService.getNewBeeMallOrdersPage(pageUtil));
}
@RequestMapping(value = “/orders/update”, method = RequestMethod.POST)
@ResponseBody
public Result update(@RequestBody NewBeeMallOrder newBeeMallOrder) {
if (Objects.isNull(newBeeMallOrder.getTotalPrice())
|| Objects.isNull(newBeeMallOrder.getOrderId())
|| newBeeMallOrder.getOrderId() < 1
|| newBeeMallOrder.getTotalPrice() < 1
|| StringUtils.isEmpty(newBeeMallOrder.getUserAddress())) {
return ResultGenerator.genFailResult(“参数异常！”);
}
String result = newBeeMallOrderService.updateOrderInfo(newBeeMallOrder);
if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult(result);
}
}
@GetMapping(“/order-items/{id}”)
@ResponseBody
public Result info(@PathVariable(“id”) Long id) {
List orderItems = newBeeMallOrderService.getOrderItems(id);
if (!CollectionUtils.isEmpty(orderItems)) {
return ResultGenerator.genSuccessResult(orderItems);
}
return ResultGenerator.genFailResult(ServiceResultEnum.DATA_NOT_EXIST.getResult());
}
@RequestMapping(value = “/orders/checkDone”, method = RequestMethod.POST)
@ResponseBody
public Result checkDon 《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》无偿开源 威信搜索公众号【编程进阶路】 e(@RequestBody Long[] ids) {
if (ids.length < 1) {
return ResultGenerator.genFailResult(“参数异常！”);
}
String result = newBeeMallOrderService.checkDone(ids);
if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult(result);
}
}
@RequestMapping(value = “/orders/checkOut”, method = RequestMethod.POST)
@ResponseBody
public Result checkOut(@RequestBody Long[] ids) {
if (ids.length < 1) {
return ResultGenerator.genFailResult(“参数异常！”);
}
String result = newBeeMallOrderService.checkOut(ids);
if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult(result);
}
}
@RequestMapping(value = “/orders/close”, method = RequestMethod.POST)
@ResponseBody
public Result closeOrder(@RequestBody Long[] ids) {
if (ids.length < 1) {
return ResultGenerator.genFailResult(“参数异常！”);
}
String result = newBeeMallOrderService.closeOrder(ids);
if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult(result);
}
}
}
后台商品信息的维护 商品订单的处理和流程控制 修改密码： 数据库主要表设计： 用户表：CREATE TABLE NewTable (
user_id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘用户主键id’ ,
nick_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用户昵称’ ,
login_name varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘登陆名称(默认为手机号)’ ,
password_md5 varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘MD5加密后的密码’ ,
introduce_sign varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘个性签名’ ,
address varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货地址’ ,
is_deleted tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘注销标识字段(0-正常 1-已注销)’ ,
locked_flag tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘锁定标识字段(0-未锁定 1-已锁定)’ ,
create_time datetime NULL DEFAULT NULL COMMENT ‘注册时间’ ,
PRIMARY KEY (user_id)
)
商品信息表：CREATE TABLE NewTable (
goods_id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘商品表主键id’ ,
goods_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品名’ ,
goods_intro varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品简介’ ,
goods_category_id bigint(20) NOT NULL DEFAULT 0 COMMENT ‘关联分类id’ ,
goods_cover_img varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘/admin/dist/img/no-img.png’ COMMENT ‘商品主图’ ,
goods_carousel varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘/admin/dist/img/no-img.png’ COMMENT ‘商品轮播图’ ,
goods_detail_content text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品详情’ ,
original_price int(11) NOT NULL DEFAULT 1 COMMENT ‘商品价格’ ,
selling_price int(11) NOT NULL DEFAULT 1 COMMENT ‘商品实际售价’ ,
stock_num int(11) NOT NULL DEFAULT 0 COMMENT ‘商品库存数量’ ,
tag varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品标签’ ,
goods_sell_status tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘商品上架状态 0-下架 1-上架’ ,
create_user int(11) NOT NULL DEFAULT 0 COMMENT ‘添加者主键id’ ,
create_time datetime NULL DEFAULT NULL COMMENT ‘商品添加时间’ ,
update_user int(11) NOT NULL DEFAULT 0 COMMENT ‘修改者主键id’ ,
update_time datetime NULL DEFAULT NULL COMMENT ‘商品修改时间’ ,
PRIMARY KEY (goods_id)
)
订单表设计：CREATE TABLE NewTable (
order_id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘订单表主键id’ ,
order_no varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘订单号’ ,
user_id bigint(20) NOT NULL DEFAULT 0 COMMENT ‘用户主键id’ ,
total_price int(11) NOT NULL DEFAULT 1 COMMENT ‘订单总价’ ,
pay_status bigint(20) NOT NULL DEFAULT 0 COMMENT ‘支付状态:0.未支付,1.支付成功,-1:支付失败’ ,
pay_type bigint(20) NOT NULL DEFAULT 0 COMMENT ‘0.无 1.支付宝支付 2.微信支付’ ,
pay_time datetime NULL DEFAULT NULL COMMENT ‘支付时间’ ,
order_status bigint(20) NOT NULL DEFAULT 0 COMMENT ‘订单状态:0.待支付 1.已支付 2.配货完成 3:出库成功 4.交易成功 -1.手动关闭 -2.超时关闭 -3.商家关闭’ ,
extra_info varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘订单body’ ,
user_name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货人姓名’ ,
user_phone varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货人手机号’ ,
user_address varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货人收货地址’ ,
is_deleted tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘删除标识字段(0-未删除 1-已删除)’ ,
create_time datetime NULL DEFAULT NULL COMMENT ‘创建时间’ ,
update_time datetime NULL DEFAULT NULL COMMENT ‘最新修改时间’ ,
PRIMARY KEY (order_id)
