express+mysql+vue,从零搭建一个商城管理系统13-生成订单

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 80028 Source Host : localhost:3306 Source Database : express_service Target Server Type : MYSQL Target Server Version : 80028 File Encoding : 65001 Date: 2024-03-15 13:45:13 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for cart -- ---------------------------- DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `id` int NOT NULL AUTO_INCREMENT, `userId` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `goodsId` varchar(255) DEFAULT NULL, `goodsName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `count` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of cart -- ---------------------------- INSERT INTO `cart` VALUES ('2', '9e14ebba3be0ae546374e8f5a49f9e80', '79194be0b10509d407ec414e297da595', 'shop03', '59ab7156aab608c14f90ddd7e1dcbdd4', '娃哈哈500ml', '4.5', '5', '500ml/瓶', '2024-03-14 03:23:12', '2024-03-14 03:23:48'); INSERT INTO `cart` VALUES ('3', '9e14ebba3be0ae546374e8f5a49f9e80', 'a81184a745ad97a4de19823f9782f733', 'shop02', 'a1787a5e48133e3b688412c27643df80', '大辣片', '4.9', '1', '240克/袋', '2024-03-14 03:26:40', '2024-03-14 03:26:40'); INSERT INTO `cart` VALUES ('4', '9e14ebba3be0ae546374e8f5a49f9e80', 'a81184a745ad97a4de19823f9782f733', 'shop02', 'dd427517fbdc6760a14b11ee84772685', '卫龙辣条', '4.9', '2', '35克/袋', '2024-03-14 03:27:20', '2024-03-14 03:27:33'); INSERT INTO `cart` VALUES ('5', '9e14ebba3be0ae546374e8f5a49f9e80', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '8.8', '1', '200克/盒', '2024-03-14 03:30:26', '2024-03-14 03:30:26'); INSERT INTO `cart` VALUES ('6', '9e14ebba3be0ae546374e8f5a49f9e80', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '6.4', '3', '160克/罐', '2024-03-14 03:31:03', '2024-03-14 03:49:04'); -- ---------------------------- -- Table structure for goods -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `id` int NOT NULL AUTO_INCREMENT, `goodsId` varchar(255) DEFAULT NULL, `goodsName` varchar(255) NOT NULL, `createId` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `inventory` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `goodsName` (`goodsName`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('1', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '8.8', '99', '200克/盒', '2024-03-13 08:08:51', '2024-03-15 05:42:22'); INSERT INTO `goods` VALUES ('5', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '6.4', '197', '160克/罐', '2024-03-13 08:37:07', '2024-03-15 05:42:22'); INSERT INTO `goods` VALUES ('6', 'dd427517fbdc6760a14b11ee84772685', '卫龙辣条', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '4.9', '998', '35克/袋', '2024-03-14 02:45:20', '2024-03-15 05:42:22'); INSERT INTO `goods` VALUES ('7', '52f20f495e66657126497715130a2997', '亲嘴铜锣烧', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '1.2', '2400', '10克/袋', '2024-03-14 02:46:01', '2024-03-14 02:46:01'); INSERT INTO `goods` VALUES ('8', 'a1787a5e48133e3b688412c27643df80', '大辣片', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '4.9', '199', '240克/袋', '2024-03-14 02:46:33', '2024-03-15 05:42:22'); INSERT INTO `goods` VALUES ('9', '59ab7156aab608c14f90ddd7e1dcbdd4', '娃哈哈100ml', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '5.9', '2000', '6瓶/排', '2024-03-14 02:47:53', '2024-03-14 02:47:53'); INSERT INTO `goods` VALUES ('10', 'd1d828d718d4db54e1790e17c69055dc', '娃哈哈220g', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '7.8', '2000', '4瓶/排', '2024-03-14 02:49:06', '2024-03-14 02:49:06'); INSERT INTO `goods` VALUES ('11', '552528655c60297fa70d2ca1cb96f995', '娃哈哈500ml', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '4.5', '495', '500ml/瓶', '2024-03-14 02:49:38', '2024-03-15 05:42:22'); -- ---------------------------- -- Table structure for order -- ---------------------------- DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `id` int NOT NULL AUTO_INCREMENT, `orderId` varchar(255) DEFAULT NULL, `userId` varchar(255) DEFAULT NULL, `userName` varchar(255) DEFAULT NULL, `total` float DEFAULT NULL, `goods` varchar(3000) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of order -- ---------------------------- INSERT INTO `order` VALUES ('4', '2ae440ce4b3c8fa8513a58e25a3ba1b2', '9e14ebba3be0ae546374e8f5a49f9e80', 'long001', '51.95', '[{\"goodsId\":\"3984cac360808573a7b703b61a66d0fe\",\"goodsName\":\"奥利奥原味饼干\",\"price\":8.8,\"count\":1},{\"goodsId\":\"94f2965af1c719ade377fd9f85b61e1f\",\"goodsName\":\"乐事薯片\",\"price\":6.4,\"count\":3},{\"goodsId\":\"a1787a5e48133e3b688412c27643df80\",\"goodsName\":\"大辣片\",\"price\":4.9,\"count\":1},{\"goodsId\":\"dd427517fbdc6760a14b11ee84772685\",\"goodsName\":\"卫龙辣条\",\"price\":4.9,\"count\":2},{\"goodsId\":\"552528655c60297fa70d2ca1cb96f995\",\"goodsName\":\"娃哈哈500ml\",\"price\":4.5,\"count\":5}]', '2024-03-15 05:42:22', '2024-03-15 05:42:22'); -- ---------------------------- -- Table structure for order_item -- ---------------------------- DROP TABLE IF EXISTS `order_item`; CREATE TABLE `order_item` ( `id` int NOT NULL AUTO_INCREMENT, `orderId` varchar(255) DEFAULT NULL, `userId` varchar(255) DEFAULT NULL, `userName` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `goodsId` varchar(255) DEFAULT NULL, `goodsName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `count` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `preferential` varchar(3000) DEFAULT NULL, `total` float DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of order_item -- ---------------------------- INSERT INTO `order_item` VALUES ('16', '2ae440ce4b3c8fa8513a58e25a3ba1b2', '9e14ebba3be0ae546374e8f5a49f9e80', 'long001', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '8.8', '1', '200克/盒', '[{\"name\":\"会员95折\",\"value\":0.95,\"operation\":\"x\"}]', '8.36', '2024-03-15 05:42:22', '2024-03-15 05:42:22'); INSERT INTO `order_item` VALUES ('17', '2ae440ce4b3c8fa8513a58e25a3ba1b2', '9e14ebba3be0ae546374e8f5a49f9e80', 'long001', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '6.4', '3', '160克/罐', '[{\"name\":\"会员95折\",\"value\":0.95,\"operation\":\"x\"},{\"name\":\"满3件减5元\",\"value\":5,\"operation\":\"-\"}]', '13.