/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 100603
 Source Host           : localhost:3306
 Source Schema         : erpdb

 Target Server Type    : MySQL
 Target Server Version : 100603
 File Encoding         : 65001

 Date: 23/07/2021 18:26:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `organ_id` bigint(20) DEFAULT NULL,
  `hands_id` bigint(20) DEFAULT NULL,
  `total_price` decimal(24, 6) DEFAULT NULL,
  `account_id` bigint(20) DEFAULT NULL,
  `bill_no` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `remark` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `delete_flag` tinyint(1) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for bill
-- ----------------------------
DROP TABLE IF EXISTS `bill`;
CREATE TABLE `bill`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) DEFAULT NULL,
  `invoic_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `verify_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `dealer` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  `total_price` decimal(24, 6) DEFAULT NULL,
  `remark` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `sales_man` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `delete_flag` tinyint(1) DEFAULT NULL,
  `bill_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `pass_word` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bill
-- ----------------------------
INSERT INTO `bill` VALUES (14, 3, '65076238', '07261626865076238736', '副总', '2021-07-21 18:57:56', '2021-06-15 00:00:00', 53980.000000, '诚信智为', '人事', 1, 0, '251012124021', '|4b-410602975bc7584605cecb4-e4e3b44/df31e02=+15f30142c1/1a422e5?9773e1~af1ea^b09855*2-c8c1c1bb54548a5b764e79');

-- ----------------------------
-- Table structure for msg
-- ----------------------------
DROP TABLE IF EXISTS `msg`;
CREATE TABLE `msg`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `msg_title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `msg_content` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `delete_flag` tinyint(1) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `number` int(26) DEFAULT NULL,
  `oper_id` bigint(20) DEFAULT NULL,
  `trader_id` bigint(20) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `delete_flag` tinyint(1) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1069 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (1, '出库', 1, 53, 26, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (2, '出库', 5, 34, 47, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (3, '出库', 3, 20, 4, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (4, '入库', 6, 12, 1, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (5, '出库', 6, 34, 23, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (6, '入库', 6, 50, 16, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (7, '入库', 7, 22, 3, 4, 1, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (8, '出库', 3, 45, 6, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (9, '入库', 5, 36, 5, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (10, '出库', 4, 35, 47, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (11, '出库', 5, 27, 8, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (12, '出库', 4, 34, 26, 10, 1, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (13, '入库', 4, 27, 2, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (14, '出库', 7, 68, 50, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (15, '出库', 4, 25, 6, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (16, '入库', 3, 62, 2, 4, 1, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (17, '出库', 5, 45, 50, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (18, '入库', 3, 39, 3, 11, 1, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (19, '出库', 1, 58, 6, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (20, '入库', 7, 72, 37, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (21, '入库', 3, 14, 19, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (22, '入库', 1, 34, 22, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (23, '出库', 1, 8, 15, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (24, '出库', 1, 79, 23, 9, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (25, '出库', 1, 36, 6, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (26, '出库', 1, 16, 16, 9, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (27, '入库', 7, 76, 4, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (28, '入库', 6, 26, 35, 4, 1, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (29, '出库', 1, 26, 13, 10, 1, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (30, '入库', 3, 75, 50, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (31, '出库', 3, 10, 35, 8, 1, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (32, '出库', 7, 17, 19, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (33, '入库', 5, 41, 14, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (34, '入库', 3, 21, 33, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (35, '入库', 7, 37, 27, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (36, '出库', 6, 36, 5, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (37, '入库', 1, 65, 21, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (38, '入库', 4, 40, 49, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (39, '出库', 4, 18, 48, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (40, '出库', 5, 75, 47, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (41, '出库', 4, 77, 29, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (42, '入库', 4, 17, 7, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (43, '出库', 7, 50, 23, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (44, '入库', 7, 27, 43, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (45, '出库', 3, 61, 24, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (46, '出库', 7, 64, 43, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (47, '入库', 3, 9, 11, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (48, '出库', 6, 58, 18, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (49, '入库', 5, 9, 14, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (50, '出库', 4, 68, 10, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (51, '出库', 2, 19, 17, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (52, '入库', 6, 30, 17, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (53, '入库', 6, 63, 50, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (54, '出库', 2, 1, 6, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (55, '入库', 1, 26, 3, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (56, '出库', 6, 44, 32, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (57, '入库', 1, 45, 12, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (58, '入库', 5, 74, 42, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (59, '入库', 4, 76, 3, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (60, '出库', 6, 25, 42, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (61, '出库', 6, 57, 11, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (62, '出库', 1, 52, 30, 9, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (63, '出库', 1, 53, 7, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (64, '出库', 2, 60, 10, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (65, '入库', 5, 30, 9, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (66, '入库', 2, 76, 15, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (67, '出库', 6, 46, 4, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (68, '出库', 6, 12, 24, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (69, '入库', 5, 24, 46, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (70, '入库', 3, 80, 29, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (71, '入库', 6, 25, 42, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (72, '入库', 2, 49, 43, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (73, '出库', 4, 7, 47, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (74, '出库', 6, 40, 49, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (75, '入库', 4, 60, 9, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (76, '入库', 5, 36, 12, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (77, '出库', 3, 6, 37, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (78, '出库', 5, 67, 34, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (79, '入库', 3, 19, 3, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (80, '入库', 7, 3, 35, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (81, '入库', 3, 29, 23, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (82, '入库', 6, 47, 24, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (83, '入库', 4, 1, 33, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (84, '入库', 3, 21, 31, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (85, '入库', 1, 62, 10, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (86, '入库', 6, 41, 47, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (87, '出库', 2, 12, 14, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (88, '出库', 5, 43, 48, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (89, '入库', 2, 54, 31, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (90, '入库', 5, 77, 48, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (91, '出库', 7, 61, 30, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (92, '入库', 4, 65, 41, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (93, '入库', 2, 47, 11, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (94, '出库', 7, 68, 37, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (95, '出库', 7, 75, 37, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (96, '入库', 5, 43, 3, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (97, '入库', 4, 69, 40, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (98, '入库', 3, 26, 6, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (99, '入库', 3, 39, 49, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (100, '出库', 3, 3, 40, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (101, '入库', 1, 43, 7, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (102, '入库', 6, 30, 35, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (103, '出库', 3, 67, 35, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (104, '入库', 1, 27, 21, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (105, '入库', 6, 46, 32, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (106, '入库', 6, 46, 40, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (107, '入库', 7, 9, 3, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (108, '入库', 4, 56, 9, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (109, '出库', 7, 22, 6, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (110, '出库', 5, 5, 43, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (111, '出库', 4, 70, 28, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (112, '入库', 3, 7, 13, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (113, '入库', 1, 40, 27, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (114, '出库', 5, 24, 15, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (115, '出库', 5, 71, 24, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (116, '出库', 2, 58, 46, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (117, '入库', 1, 47, 45, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (118, '入库', 3, 80, 26, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (119, '入库', 4, 47, 17, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (120, '出库', 6, 2, 13, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (121, '入库', 4, 15, 21, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (122, '入库', 2, 32, 39, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (123, '出库', 7, 49, 25, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (124, '出库', 1, 30, 40, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (125, '出库', 3, 6, 13, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (126, '入库', 2, 54, 43, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (127, '入库', 5, 18, 18, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (128, '入库', 3, 66, 38, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (129, '入库', 2, 54, 48, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (130, '入库', 6, 20, 46, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (131, '出库', 7, 15, 38, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (132, '入库', 2, 30, 10, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (133, '出库', 2, 67, 32, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (134, '出库', 1, 69, 2, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (135, '出库', 3, 41, 5, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (136, '入库', 4, 43, 46, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (137, '入库', 6, 53, 40, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (138, '入库', 6, 79, 32, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (139, '入库', 2, 10, 30, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (140, '出库', 4, 44, 16, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (141, '入库', 1, 50, 18, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (142, '入库', 4, 58, 8, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (143, '出库', 4, 52, 7, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (144, '入库', 6, 57, 9, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (145, '出库', 6, 29, 7, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (146, '入库', 3, 13, 10, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (147, '入库', 7, 26, 36, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (148, '入库', 1, 42, 11, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (149, '入库', 7, 2, 47, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (150, '出库', 7, 14, 47, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (151, '出库', 4, 26, 16, 8, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (152, '出库', 5, 77, 35, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (153, '入库', 5, 24, 27, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (154, '入库', 3, 71, 36, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (155, '入库', 6, 4, 47, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (156, '出库', 3, 64, 33, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (157, '入库', 5, 42, 7, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (158, '出库', 4, 27, 16, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (159, '入库', 3, 78, 12, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (160, '入库', 7, 65, 23, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (161, '出库', 6, 20, 35, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (162, '出库', 5, 49, 21, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (163, '入库', 4, 68, 41, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (164, '出库', 6, 35, 14, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (165, '入库', 2, 30, 39, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (166, '入库', 3, 53, 28, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (167, '出库', 2, 34, 44, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (168, '入库', 7, 29, 31, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (169, '入库', 5, 63, 9, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (170, '出库', 5, 56, 27, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (171, '出库', 1, 18, 12, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (172, '出库', 1, 45, 7, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (173, '出库', 6, 40, 5, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (174, '入库', 3, 58, 40, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (175, '出库', 7, 67, 24, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (176, '入库', 7, 6, 10, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (177, '出库', 4, 8, 18, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (178, '入库', 1, 43, 33, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (179, '出库', 6, 66, 2, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (180, '出库', 6, 3, 49, 9, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (181, '出库', 7, 13, 8, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (182, '入库', 5, 74, 36, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (183, '出库', 6, 25, 50, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (184, '出库', 7, 40, 50, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (185, '入库', 4, 78, 13, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (186, '入库', 6, 57, 38, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (187, '出库', 6, 68, 30, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (188, '入库', 6, 37, 40, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (189, '出库', 5, 51, 27, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (190, '出库', 1, 33, 18, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (191, '入库', 6, 17, 5, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (192, '入库', 6, 52, 8, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (193, '入库', 3, 25, 46, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (194, '出库', 7, 15, 43, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (195, '出库', 4, 38, 42, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (196, '入库', 6, 59, 26, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (197, '入库', 5, 53, 29, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (198, '入库', 4, 70, 4, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (199, '出库', 3, 49, 24, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (200, '入库', 1, 72, 7, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (201, '出库', 4, 60, 4, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (202, '出库', 3, 73, 49, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (203, '入库', 1, 45, 20, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (204, '出库', 7, 25, 38, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (205, '出库', 2, 1, 7, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (206, '出库', 3, 22, 18, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (207, '入库', 3, 77, 7, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (208, '入库', 7, 59, 20, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (209, '入库', 6, 68, 12, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (210, '入库', 7, 24, 21, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (211, '入库', 7, 24, 50, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (212, '出库', 1, 11, 50, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (213, '出库', 1, 64, 42, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (214, '出库', 1, 15, 24, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (215, '入库', 3, 8, 32, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (216, '入库', 5, 30, 4, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (217, '出库', 7, 32, 28, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (218, '出库', 4, 12, 42, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (219, '入库', 2, 49, 10, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (220, '出库', 3, 62, 35, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (221, '出库', 3, 76, 21, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (222, '出库', 4, 51, 29, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (223, '入库', 3, 16, 28, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (224, '入库', 2, 53, 30, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (225, '入库', 1, 40, 49, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (226, '入库', 6, 67, 10, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (227, '入库', 6, 46, 31, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (228, '入库', 6, 49, 22, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (229, '出库', 7, 80, 11, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (230, '入库', 3, 66, 27, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (231, '出库', 7, 3, 43, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (232, '入库', 5, 22, 30, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (233, '入库', 2, 35, 19, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (234, '入库', 3, 21, 30, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (235, '出库', 7, 57, 35, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (236, '出库', 3, 10, 11, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (237, '入库', 4, 23, 33, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (238, '入库', 4, 30, 26, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (239, '入库', 2, 23, 24, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (240, '出库', 4, 46, 44, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (241, '入库', 7, 25, 7, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (242, '出库', 7, 44, 37, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (243, '出库', 1, 58, 50, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (244, '出库', 4, 78, 11, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (245, '入库', 3, 61, 15, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (246, '入库', 3, 57, 3, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (247, '出库', 5, 12, 31, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (248, '出库', 6, 50, 43, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (249, '入库', 1, 51, 42, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (250, '出库', 7, 21, 26, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (251, '入库', 5, 36, 6, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (252, '出库', 7, 36, 8, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (253, '入库', 6, 10, 26, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (254, '入库', 1, 63, 16, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (255, '入库', 5, 5, 46, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (256, '出库', 5, 33, 46, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (257, '入库', 1, 63, 5, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (258, '出库', 5, 68, 7, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (259, '出库', 3, 14, 22, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (260, '出库', 4, 1, 35, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (261, '出库', 2, 19, 43, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (262, '入库', 3, 72, 30, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (263, '入库', 2, 30, 25, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (264, '入库', 5, 16, 21, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (265, '出库', 2, 37, 14, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (266, '入库', 3, 14, 5, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (267, '出库', 2, 27, 50, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (268, '出库', 3, 64, 13, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (269, '出库', 2, 51, 8, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (270, '入库', 6, 67, 11, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (271, '出库', 1, 62, 47, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (272, '出库', 5, 17, 11, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (273, '出库', 2, 77, 30, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (274, '入库', 3, 56, 39, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (275, '出库', 2, 43, 20, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (276, '出库', 6, 4, 22, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (277, '出库', 2, 55, 38, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (278, '入库', 5, 27, 14, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (279, '入库', 7, 41, 19, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (280, '出库', 2, 74, 4, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (281, '入库', 1, 1, 7, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (282, '出库', 7, 18, 26, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (283, '入库', 5, 39, 30, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (284, '入库', 1, 63, 17, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (285, '入库', 7, 68, 26, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (286, '入库', 5, 15, 4, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (287, '入库', 5, 20, 11, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (288, '出库', 1, 60, 38, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (289, '出库', 4, 41, 31, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (290, '入库', 2, 27, 12, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (291, '入库', 2, 30, 13, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (292, '入库', 6, 69, 50, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (293, '入库', 4, 45, 9, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (294, '出库', 7, 20, 4, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (295, '入库', 5, 30, 7, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (296, '入库', 6, 1, 25, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (297, '入库', 5, 19, 15, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (298, '入库', 6, 16, 48, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (299, '出库', 1, 19, 46, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (300, '出库', 7, 40, 34, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (301, '入库', 6, 14, 40, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (302, '入库', 7, 3, 31, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (303, '入库', 3, 8, 36, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (304, '出库', 3, 41, 37, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (305, '出库', 5, 77, 27, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (306, '入库', 6, 60, 14, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (307, '入库', 1, 62, 43, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (308, '出库', 6, 68, 35, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (309, '入库', 4, 66, 32, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (310, '出库', 3, 44, 48, 8, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (311, '出库', 4, 74, 14, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (312, '出库', 7, 30, 32, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (313, '入库', 2, 68, 6, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (314, '入库', 2, 5, 14, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (315, '入库', 4, 29, 45, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (316, '入库', 7, 56, 39, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (317, '入库', 7, 1, 46, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (318, '出库', 1, 40, 38, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (319, '入库', 1, 76, 18, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (320, '出库', 4, 45, 28, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (321, '入库', 4, 74, 14, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (322, '出库', 4, 66, 18, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (323, '出库', 5, 40, 40, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (324, '入库', 4, 23, 25, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (325, '入库', 6, 29, 28, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (326, '出库', 2, 23, 46, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (327, '出库', 4, 70, 30, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (328, '入库', 6, 69, 29, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (329, '入库', 7, 9, 31, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (330, '出库', 1, 9, 19, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (331, '入库', 6, 6, 27, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (332, '出库', 4, 50, 15, 9, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (333, '入库', 3, 50, 21, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (334, '入库', 7, 2, 12, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (335, '入库', 7, 42, 8, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (336, '出库', 5, 32, 23, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (337, '入库', 1, 24, 12, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (338, '出库', 7, 46, 38, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (339, '出库', 3, 24, 24, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (340, '入库', 4, 20, 42, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (341, '出库', 5, 58, 39, 9, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (342, '入库', 7, 25, 8, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (343, '入库', 4, 21, 2, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (344, '出库', 7, 66, 37, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (345, '出库', 4, 29, 41, 8, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (346, '出库', 4, 42, 46, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (347, '出库', 6, 49, 13, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (348, '出库', 3, 21, 6, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (349, '入库', 4, 27, 27, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (350, '入库', 1, 70, 8, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (351, '入库', 4, 3, 7, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (352, '入库', 1, 26, 23, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (353, '出库', 1, 15, 41, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (354, '入库', 1, 50, 17, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (355, '入库', 7, 44, 38, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (356, '出库', 6, 15, 24, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (357, '入库', 6, 6, 47, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (358, '入库', 3, 72, 3, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (359, '出库', 7, 16, 21, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (360, '入库', 3, 79, 43, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (361, '出库', 3, 44, 44, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (362, '入库', 7, 45, 26, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (363, '入库', 4, 53, 6, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (364, '出库', 3, 16, 34, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (365, '出库', 4, 79, 22, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (366, '出库', 6, 18, 21, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (367, '出库', 5, 41, 34, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (368, '入库', 5, 73, 37, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (369, '入库', 7, 4, 42, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (370, '入库', 5, 57, 41, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (371, '入库', 2, 24, 25, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (372, '出库', 3, 24, 32, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (373, '入库', 1, 32, 13, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (374, '出库', 6, 19, 48, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (375, '入库', 3, 9, 39, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (376, '出库', 1, 66, 44, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (377, '出库', 2, 80, 38, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (378, '入库', 1, 5, 31, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (379, '出库', 3, 66, 36, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (380, '入库', 2, 22, 36, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (381, '出库', 1, 76, 9, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (382, '出库', 7, 1, 2, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (383, '入库', 5, 10, 46, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (384, '出库', 6, 5, 30, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (385, '入库', 2, 26, 7, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (386, '入库', 7, 72, 11, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (387, '入库', 7, 26, 27, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (388, '出库', 2, 32, 18, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (389, '出库', 1, 22, 46, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (390, '出库', 5, 1, 50, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (391, '出库', 5, 19, 37, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (392, '入库', 6, 56, 35, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (393, '出库', 1, 28, 26, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (394, '入库', 1, 57, 35, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (395, '入库', 4, 20, 3, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (396, '入库', 7, 7, 36, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (397, '入库', 7, 7, 8, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (398, '入库', 1, 11, 47, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (399, '入库', 2, 4, 10, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (400, '入库', 7, 47, 50, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (401, '出库', 4, 74, 13, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (402, '入库', 4, 44, 38, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (403, '出库', 1, 8, 46, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (404, '出库', 2, 54, 20, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (405, '入库', 6, 16, 17, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (406, '出库', 7, 14, 45, 9, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (407, '出库', 4, 24, 28, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (408, '入库', 1, 54, 5, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (409, '入库', 3, 57, 46, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (410, '入库', 6, 43, 45, 12, 1, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (411, '出库', 1, 58, 33, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (412, '出库', 2, 30, 9, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (413, '出库', 1, 39, 35, 7, 1, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (414, '入库', 4, 70, 21, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (415, '入库', 6, 6, 49, 11, 1, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (416, '入库', 6, 72, 45, 3, 1, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (417, '入库', 4, 18, 50, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (418, '入库', 1, 76, 11, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (419, '入库', 2, 54, 17, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (420, '入库', 1, 37, 29, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (421, '出库', 7, 35, 50, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (422, '出库', 1, 65, 46, 8, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (423, '入库', 4, 39, 48, 5, 1, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (424, '入库', 2, 4, 14, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (425, '入库', 4, 37, 16, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (426, '出库', 6, 61, 46, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (427, '入库', 4, 13, 18, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (428, '入库', 1, 40, 19, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (429, '入库', 1, 64, 33, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (430, '出库', 5, 58, 8, 10, 1, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (431, '入库', 3, 69, 42, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (432, '出库', 1, 24, 46, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (433, '出库', 4, 8, 11, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (434, '出库', 2, 36, 17, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (435, '出库', 5, 19, 49, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (436, '入库', 3, 15, 15, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (437, '入库', 5, 11, 47, 12, 1, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (438, '出库', 3, 56, 10, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (439, '出库', 4, 76, 49, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (440, '出库', 5, 2, 10, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (441, '入库', 1, 22, 38, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (442, '出库', 4, 67, 25, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (443, '出库', 5, 9, 4, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (444, '入库', 7, 36, 12, 4, 1, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (445, '入库', 1, 38, 8, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (446, '出库', 2, 49, 49, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (447, '出库', 6, 33, 37, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (448, '出库', 3, 73, 25, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (449, '入库', 1, 3, 47, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (450, '入库', 3, 21, 6, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (451, '出库', 1, 50, 38, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (452, '入库', 7, 1, 29, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (453, '入库', 6, 73, 41, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (454, '出库', 3, 18, 17, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (455, '出库', 4, 39, 19, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (456, '入库', 6, 69, 2, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (457, '入库', 1, 33, 32, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (458, '出库', 1, 44, 6, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (459, '入库', 2, 14, 29, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (460, '入库', 1, 41, 28, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (461, '出库', 7, 59, 49, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (462, '出库', 7, 48, 9, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (463, '入库', 6, 24, 24, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (464, '出库', 4, 13, 31, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (465, '入库', 3, 71, 31, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (466, '入库', 6, 4, 20, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (467, '出库', 6, 69, 3, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (468, '入库', 1, 32, 18, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (469, '入库', 6, 61, 9, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (470, '入库', 4, 16, 5, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (471, '出库', 3, 13, 49, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (472, '入库', 6, 24, 45, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (473, '入库', 2, 1, 3, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (474, '出库', 2, 36, 33, 9, 1, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (475, '入库', 3, 25, 15, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (476, '入库', 2, 20, 23, 3, 1, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (477, '入库', 7, 29, 9, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (478, '出库', 7, 26, 8, 8, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (479, '出库', 1, 29, 42, 10, 1, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (480, '入库', 4, 9, 6, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (481, '入库', 7, 36, 18, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (482, '出库', 1, 36, 18, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (483, '出库', 3, 64, 31, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (484, '出库', 1, 17, 16, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (485, '入库', 1, 5, 2, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (486, '入库', 4, 42, 37, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (487, '出库', 1, 44, 16, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (488, '入库', 2, 30, 31, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (489, '入库', 3, 1, 24, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (490, '出库', 3, 79, 26, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (491, '出库', 4, 47, 4, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (492, '出库', 3, 9, 35, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (493, '入库', 3, 58, 34, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (494, '入库', 3, 57, 9, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (495, '入库', 2, 25, 21, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (496, '出库', 2, 75, 28, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (497, '出库', 3, 19, 50, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (498, '出库', 2, 33, 18, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (499, '出库', 4, 76, 25, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (500, '出库', 3, 35, 3, 9, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (501, '入库', 4, 75, 46, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (502, '入库', 1, 32, 41, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (503, '入库', 4, 5, 44, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (504, '入库', 5, 34, 25, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (505, '入库', 7, 4, 16, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (506, '出库', 5, 1, 12, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (507, '出库', 1, 16, 2, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (508, '出库', 5, 21, 23, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (509, '出库', 5, 15, 20, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (510, '入库', 4, 49, 13, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (511, '入库', 5, 76, 26, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (512, '出库', 1, 46, 11, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (513, '出库', 5, 76, 7, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (514, '出库', 6, 79, 5, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (515, '出库', 5, 1, 4, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (516, '入库', 7, 49, 15, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (517, '入库', 4, 9, 37, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (518, '入库', 6, 18, 46, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (519, '出库', 1, 21, 3, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (520, '入库', 7, 4, 30, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (521, '入库', 3, 39, 14, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (522, '出库', 6, 1, 7, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (523, '入库', 3, 15, 32, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (524, '入库', 6, 70, 41, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (525, '入库', 2, 45, 17, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (526, '入库', 2, 75, 34, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (527, '入库', 1, 38, 5, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (528, '出库', 1, 76, 45, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (529, '入库', 4, 11, 23, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (530, '入库', 7, 5, 37, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (531, '入库', 6, 27, 6, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (532, '入库', 5, 49, 24, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (533, '入库', 2, 25, 33, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (534, '入库', 2, 53, 46, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (535, '入库', 4, 48, 48, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (536, '出库', 1, 77, 3, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (537, '出库', 4, 34, 22, 9, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (538, '入库', 4, 62, 40, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (539, '入库', 3, 50, 40, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (540, '入库', 5, 6, 30, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (541, '入库', 4, 62, 38, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (542, '入库', 5, 28, 21, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (543, '出库', 2, 13, 47, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (544, '入库', 4, 43, 37, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (545, '入库', 3, 74, 49, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (546, '出库', 2, 8, 27, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (547, '入库', 1, 20, 20, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (548, '出库', 7, 23, 43, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (549, '出库', 5, 38, 22, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (550, '入库', 4, 43, 40, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (551, '入库', 2, 68, 45, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (552, '入库', 3, 44, 37, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (553, '入库', 5, 67, 39, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (554, '入库', 3, 71, 7, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (555, '出库', 6, 12, 29, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (556, '出库', 5, 15, 46, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (557, '入库', 4, 61, 37, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (558, '出库', 6, 55, 11, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (559, '出库', 5, 10, 7, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (560, '入库', 1, 58, 39, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (561, '入库', 3, 49, 21, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (562, '入库', 3, 61, 50, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (563, '入库', 5, 11, 37, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (564, '入库', 3, 36, 16, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (565, '入库', 1, 7, 33, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (566, '入库', 3, 61, 22, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (567, '入库', 4, 6, 39, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (568, '入库', 6, 41, 50, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (569, '入库', 5, 17, 21, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (570, '出库', 5, 56, 29, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (571, '入库', 7, 45, 35, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (572, '入库', 6, 7, 47, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (573, '入库', 6, 17, 37, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (574, '出库', 6, 40, 39, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (575, '入库', 6, 8, 3, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (576, '出库', 1, 45, 36, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (577, '出库', 2, 50, 39, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (578, '入库', 6, 65, 18, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (579, '入库', 2, 25, 37, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (580, '入库', 3, 13, 20, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (581, '出库', 2, 74, 18, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (582, '入库', 4, 68, 26, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (583, '入库', 3, 14, 27, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (584, '入库', 2, 17, 5, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (585, '入库', 5, 11, 19, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (586, '出库', 4, 2, 47, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (587, '入库', 4, 35, 37, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (588, '入库', 1, 69, 35, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (589, '入库', 3, 16, 3, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (590, '入库', 2, 57, 25, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (591, '入库', 5, 6, 44, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (592, '出库', 6, 72, 5, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (593, '入库', 2, 29, 9, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (594, '入库', 6, 68, 31, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (595, '入库', 6, 67, 4, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (596, '入库', 7, 38, 26, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (597, '出库', 4, 57, 45, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (598, '出库', 2, 39, 14, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (599, '入库', 7, 63, 14, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (600, '入库', 2, 11, 25, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (601, '出库', 5, 73, 47, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (602, '出库', 5, 24, 32, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (603, '出库', 2, 16, 32, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (604, '出库', 4, 66, 41, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (605, '入库', 7, 66, 14, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (606, '入库', 6, 8, 16, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (607, '出库', 6, 41, 23, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (608, '出库', 6, 31, 33, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (609, '入库', 1, 13, 47, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (610, '出库', 1, 30, 33, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (611, '入库', 7, 7, 3, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (612, '出库', 1, 66, 14, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (613, '入库', 6, 71, 43, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (614, '出库', 3, 15, 28, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (615, '入库', 6, 45, 9, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (616, '出库', 4, 68, 46, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (617, '出库', 6, 66, 28, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (618, '出库', 2, 75, 45, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (619, '入库', 3, 52, 16, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (620, '出库', 5, 27, 8, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (621, '出库', 2, 34, 39, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (622, '出库', 5, 39, 4, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (623, '入库', 6, 10, 15, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (624, '入库', 7, 2, 46, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (625, '出库', 3, 28, 24, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (626, '出库', 1, 67, 24, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (627, '入库', 6, 33, 35, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (628, '入库', 2, 42, 38, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (629, '出库', 6, 63, 49, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (630, '出库', 3, 66, 8, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (631, '入库', 5, 19, 19, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (632, '出库', 5, 30, 44, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (633, '入库', 5, 10, 23, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (634, '出库', 1, 48, 40, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (635, '出库', 1, 10, 29, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (636, '入库', 6, 26, 29, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (637, '入库', 1, 22, 37, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (638, '入库', 7, 3, 36, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (639, '出库', 6, 1, 2, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (640, '入库', 2, 17, 15, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (641, '出库', 2, 13, 49, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (642, '出库', 4, 62, 34, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (643, '入库', 4, 64, 15, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (644, '入库', 7, 47, 43, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (645, '出库', 1, 4, 36, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (646, '入库', 7, 77, 28, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (647, '入库', 4, 27, 42, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (648, '出库', 3, 3, 2, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (649, '出库', 6, 36, 25, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (650, '入库', 3, 50, 10, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (651, '入库', 5, 61, 7, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (652, '入库', 3, 47, 33, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (653, '出库', 4, 65, 30, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (654, '入库', 3, 34, 10, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (655, '入库', 6, 56, 4, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (656, '入库', 2, 59, 20, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (657, '入库', 6, 30, 28, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (658, '入库', 2, 48, 6, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (659, '入库', 7, 20, 4, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (660, '出库', 2, 41, 7, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (661, '出库', 5, 57, 5, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (662, '入库', 6, 60, 46, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (663, '入库', 1, 56, 5, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (664, '出库', 3, 36, 45, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (665, '入库', 1, 22, 48, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (666, '出库', 6, 56, 2, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (667, '出库', 1, 30, 46, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (668, '出库', 5, 69, 12, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (669, '出库', 5, 62, 11, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (670, '入库', 7, 76, 30, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (671, '出库', 5, 19, 43, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (672, '出库', 3, 52, 44, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (673, '入库', 7, 51, 19, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (674, '出库', 3, 68, 32, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (675, '入库', 3, 71, 10, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (676, '入库', 2, 80, 48, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (677, '入库', 6, 21, 6, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (678, '出库', 7, 14, 22, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (679, '出库', 1, 68, 22, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (680, '入库', 5, 50, 21, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (681, '出库', 3, 53, 3, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (682, '入库', 4, 21, 47, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (683, '入库', 3, 21, 2, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (684, '入库', 4, 33, 39, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (685, '出库', 7, 46, 29, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (686, '入库', 3, 48, 12, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (687, '入库', 5, 4, 50, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (688, '出库', 6, 42, 4, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (689, '入库', 2, 15, 36, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (690, '入库', 1, 16, 24, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (691, '入库', 2, 18, 49, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (692, '出库', 2, 47, 18, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (693, '入库', 3, 38, 10, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (694, '出库', 2, 69, 24, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (695, '入库', 3, 56, 41, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (696, '出库', 6, 35, 36, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (697, '入库', 2, 54, 28, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (698, '入库', 5, 24, 3, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (699, '入库', 3, 17, 7, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (700, '入库', 2, 39, 44, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (701, '出库', 2, 37, 50, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (702, '入库', 3, 12, 42, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (703, '出库', 6, 38, 17, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (704, '出库', 6, 61, 22, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (705, '入库', 5, 66, 31, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (706, '出库', 4, 70, 22, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (707, '出库', 6, 58, 8, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (708, '入库', 6, 5, 24, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (709, '入库', 1, 78, 45, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (710, '入库', 1, 40, 29, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (711, '入库', 2, 60, 12, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (712, '出库', 2, 79, 16, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (713, '入库', 1, 5, 49, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (714, '入库', 2, 41, 26, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (715, '出库', 3, 78, 11, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (716, '入库', 2, 27, 43, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (717, '出库', 2, 34, 30, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (718, '出库', 7, 3, 47, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (719, '入库', 7, 58, 32, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (720, '出库', 3, 78, 24, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (721, '入库', 6, 34, 49, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (722, '出库', 3, 77, 5, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (723, '入库', 7, 28, 8, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (724, '出库', 7, 79, 13, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (725, '出库', 7, 63, 43, 9, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (726, '入库', 5, 30, 45, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (727, '入库', 3, 1, 42, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (728, '入库', 3, 49, 32, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (729, '出库', 5, 15, 47, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (730, '入库', 2, 33, 30, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (731, '出库', 4, 50, 28, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (732, '入库', 6, 45, 10, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (733, '出库', 3, 9, 23, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (734, '入库', 6, 67, 49, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (735, '出库', 2, 20, 33, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (736, '入库', 2, 67, 14, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (737, '出库', 6, 32, 30, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (738, '出库', 6, 20, 45, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (739, '入库', 5, 58, 11, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (740, '入库', 4, 79, 43, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (741, '出库', 5, 49, 24, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (742, '入库', 1, 71, 23, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (743, '出库', 1, 16, 34, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (744, '入库', 4, 27, 7, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (745, '出库', 6, 19, 40, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (746, '入库', 2, 73, 15, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (747, '出库', 1, 26, 31, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (748, '出库', 4, 23, 32, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (749, '出库', 2, 26, 6, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (750, '入库', 6, 80, 38, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (751, '出库', 7, 9, 28, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (752, '入库', 7, 22, 31, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (753, '入库', 7, 37, 31, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (754, '入库', 5, 9, 23, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (755, '入库', 1, 38, 37, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (756, '入库', 5, 72, 34, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (757, '入库', 7, 13, 39, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (758, '入库', 1, 48, 7, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (759, '出库', 5, 41, 18, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (760, '入库', 1, 28, 6, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (761, '出库', 2, 13, 10, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (762, '出库', 5, 42, 8, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (763, '入库', 7, 74, 35, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (764, '出库', 2, 76, 14, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (765, '入库', 5, 69, 47, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (766, '出库', 3, 44, 36, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (767, '出库', 7, 55, 2, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (768, '出库', 5, 39, 4, 9, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (769, '入库', 4, 38, 35, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (770, '入库', 7, 56, 19, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (771, '入库', 2, 60, 47, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (772, '出库', 4, 10, 10, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (773, '出库', 5, 39, 19, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (774, '出库', 4, 76, 41, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (775, '入库', 4, 61, 5, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (776, '出库', 7, 43, 37, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (777, '入库', 7, 43, 4, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (778, '出库', 5, 30, 30, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (779, '入库', 6, 5, 42, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (780, '入库', 4, 18, 39, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (781, '入库', 4, 15, 9, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (782, '出库', 1, 22, 32, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (783, '入库', 3, 10, 4, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (784, '出库', 3, 43, 2, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (785, '入库', 4, 3, 17, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (786, '入库', 6, 39, 7, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (787, '入库', 4, 61, 42, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (788, '出库', 2, 10, 30, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (789, '入库', 3, 77, 24, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (790, '出库', 2, 47, 6, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (791, '入库', 2, 39, 40, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (792, '入库', 2, 41, 46, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (793, '出库', 3, 32, 36, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (794, '入库', 7, 29, 3, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (795, '入库', 2, 20, 7, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (796, '出库', 6, 72, 40, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (797, '入库', 1, 3, 42, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (798, '入库', 7, 71, 31, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (799, '出库', 4, 55, 36, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (800, '入库', 3, 8, 14, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (801, '出库', 5, 19, 48, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (802, '入库', 2, 1, 30, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (803, '出库', 1, 46, 2, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (804, '出库', 7, 17, 12, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (805, '出库', 4, 28, 9, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (806, '入库', 1, 38, 44, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (807, '出库', 5, 63, 48, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (808, '入库', 2, 14, 40, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (809, '出库', 5, 61, 3, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (810, '入库', 6, 77, 35, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (811, '入库', 6, 49, 11, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (812, '出库', 7, 55, 32, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (813, '出库', 6, 21, 33, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (814, '出库', 7, 51, 27, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (815, '入库', 3, 30, 27, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (816, '入库', 4, 50, 48, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (817, '入库', 3, 49, 30, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (818, '入库', 2, 34, 13, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (819, '出库', 4, 48, 44, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (820, '出库', 4, 44, 28, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (821, '入库', 3, 46, 3, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (822, '入库', 7, 52, 34, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (823, '出库', 6, 72, 41, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (824, '出库', 5, 49, 28, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (825, '出库', 1, 44, 26, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (826, '入库', 4, 36, 29, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (827, '入库', 6, 43, 30, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (828, '入库', 1, 21, 18, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (829, '入库', 4, 28, 17, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (830, '出库', 6, 57, 47, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (831, '入库', 4, 48, 37, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (832, '出库', 1, 75, 37, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (833, '入库', 4, 3, 36, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (834, '入库', 7, 11, 11, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (835, '出库', 6, 33, 4, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (836, '入库', 3, 31, 21, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (837, '出库', 5, 48, 31, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (838, '入库', 7, 12, 21, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (839, '入库', 6, 18, 37, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (840, '出库', 6, 32, 43, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (841, '入库', 3, 78, 45, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (842, '出库', 7, 50, 18, 8, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (843, '入库', 7, 43, 37, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (844, '出库', 3, 15, 35, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (845, '出库', 1, 56, 32, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (846, '入库', 5, 43, 45, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (847, '入库', 1, 18, 22, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (848, '入库', 5, 73, 46, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (849, '出库', 5, 19, 18, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (850, '出库', 6, 73, 30, 9, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (851, '入库', 4, 73, 2, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (852, '入库', 3, 35, 16, 12, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (853, '入库', 3, 5, 7, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (854, '入库', 4, 16, 33, 4, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (855, '入库', 2, 46, 33, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (856, '入库', 2, 39, 45, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (857, '入库', 5, 21, 13, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (858, '出库', 4, 14, 45, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (859, '出库', 4, 74, 11, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (860, '入库', 5, 44, 12, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (861, '出库', 4, 18, 49, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (862, '入库', 1, 69, 29, 12, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (863, '出库', 2, 31, 23, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (864, '入库', 6, 46, 33, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (865, '入库', 6, 9, 21, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (866, '出库', 4, 37, 17, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (867, '出库', 1, 71, 31, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (868, '入库', 5, 28, 13, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (869, '入库', 3, 60, 50, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (870, '出库', 5, 64, 25, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (871, '出库', 4, 75, 36, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (872, '入库', 5, 43, 36, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (873, '出库', 5, 15, 17, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (874, '出库', 4, 21, 39, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (875, '入库', 4, 65, 49, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (876, '入库', 7, 71, 43, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (877, '入库', 6, 66, 4, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (878, '出库', 5, 8, 43, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (879, '入库', 3, 56, 29, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (880, '出库', 1, 40, 38, 8, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (881, '出库', 7, 68, 26, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (882, '出库', 4, 55, 39, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (883, '出库', 7, 66, 27, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (884, '入库', 5, 8, 8, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (885, '出库', 4, 20, 17, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (886, '出库', 3, 69, 15, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (887, '入库', 1, 20, 21, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (888, '出库', 5, 68, 25, 7, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (889, '入库', 4, 54, 4, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (890, '出库', 1, 17, 44, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (891, '出库', 4, 16, 27, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (892, '入库', 2, 25, 13, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (893, '出库', 1, 28, 39, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (894, '出库', 6, 48, 14, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (895, '入库', 5, 12, 49, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (896, '入库', 2, 47, 11, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (897, '出库', 3, 18, 42, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (898, '出库', 6, 3, 24, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (899, '出库', 3, 20, 38, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (900, '出库', 7, 64, 16, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (901, '出库', 1, 79, 15, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (902, '出库', 3, 31, 20, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (903, '入库', 2, 45, 33, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (904, '出库', 5, 12, 45, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (905, '出库', 4, 5, 10, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (906, '出库', 1, 6, 8, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (907, '出库', 7, 15, 45, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (908, '出库', 3, 60, 18, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (909, '出库', 2, 63, 10, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (910, '入库', 3, 8, 34, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (911, '出库', 3, 34, 25, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (912, '入库', 1, 78, 24, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (913, '出库', 5, 9, 7, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (914, '入库', 5, 61, 47, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (915, '出库', 4, 71, 23, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (916, '入库', 3, 67, 30, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (917, '入库', 4, 68, 8, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (918, '入库', 6, 29, 8, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (919, '出库', 3, 60, 5, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (920, '入库', 5, 29, 2, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (921, '出库', 7, 55, 49, 6, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (922, '入库', 7, 63, 19, 11, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (923, '出库', 3, 79, 26, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (924, '出库', 3, 10, 44, 6, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (925, '出库', 5, 40, 50, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (926, '入库', 6, 45, 37, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (927, '出库', 3, 74, 24, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (928, '出库', 1, 40, 17, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (929, '出库', 3, 52, 24, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (930, '出库', 3, 53, 41, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (931, '出库', 1, 45, 25, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (932, '出库', 5, 5, 30, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (933, '出库', 3, 40, 29, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (934, '入库', 2, 61, 13, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (935, '入库', 5, 44, 4, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (936, '入库', 6, 57, 37, 3, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (937, '出库', 1, 36, 19, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (938, '出库', 2, 49, 40, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (939, '出库', 2, 64, 17, 9, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (940, '出库', 1, 42, 39, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (941, '入库', 7, 42, 7, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (942, '出库', 1, 57, 49, 2, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (943, '出库', 7, 39, 11, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (944, '入库', 1, 58, 31, 4, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (945, '出库', 7, 51, 35, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (946, '入库', 2, 17, 9, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (947, '入库', 4, 61, 10, 3, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (948, '出库', 1, 53, 15, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (949, '入库', 3, 3, 37, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (950, '入库', 3, 65, 37, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (951, '入库', 6, 46, 8, 11, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (952, '出库', 3, 57, 31, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (953, '出库', 2, 52, 5, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (954, '入库', 7, 74, 42, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (955, '入库', 4, 11, 25, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (956, '出库', 3, 1, 14, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (957, '入库', 2, 77, 43, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (958, '入库', 3, 33, 40, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (959, '入库', 5, 25, 34, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (960, '入库', 1, 67, 39, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (961, '出库', 7, 77, 25, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (962, '出库', 3, 43, 45, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (963, '出库', 6, 58, 34, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (964, '出库', 3, 56, 27, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (965, '出库', 7, 1, 30, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (966, '入库', 7, 5, 44, 11, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (967, '出库', 4, 41, 38, 6, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (968, '入库', 2, 44, 41, 5, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (969, '入库', 1, 33, 8, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (970, '入库', 6, 37, 41, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (971, '出库', 4, 54, 36, 8, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (972, '出库', 1, 9, 26, 10, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (973, '入库', 4, 48, 10, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (974, '入库', 1, 69, 50, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (975, '入库', 1, 60, 7, 5, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (976, '出库', 2, 28, 25, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (977, '出库', 7, 55, 19, 10, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (978, '出库', 7, 55, 19, 7, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (979, '出库', 1, 35, 42, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (980, '出库', 3, 9, 27, 9, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (981, '出库', 2, 35, 20, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (982, '出库', 2, 50, 12, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (983, '入库', 5, 15, 3, 3, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (984, '入库', 1, 43, 15, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (985, '出库', 6, 14, 47, 10, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (986, '入库', 6, 65, 41, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (987, '出库', 6, 54, 21, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (988, '入库', 5, 35, 18, 5, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (989, '出库', 4, 71, 16, 2, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (990, '出库', 1, 66, 10, 8, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (991, '出库', 7, 5, 12, 8, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (992, '入库', 4, 19, 28, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (993, '入库', 5, 61, 40, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (994, '出库', 7, 54, 35, 8, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (995, '入库', 6, 60, 27, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (996, '出库', 5, 58, 39, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (997, '出库', 4, 64, 13, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (998, '入库', 5, 72, 43, 4, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (999, '出库', 4, 6, 9, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1000, '出库', 1, 7, 22, 10, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (1001, '出库', 5, 29, 39, 7, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1002, '出库', 4, 69, 7, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1003, '出库', 6, 73, 5, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1004, '入库', 2, 33, 23, 12, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1005, '入库', 2, 4, 12, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1006, '出库', 7, 60, 37, 6, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (1007, '入库', 4, 44, 29, 5, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1008, '出库', 1, 2, 29, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1009, '出库', 7, 42, 27, 10, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1010, '入库', 1, 80, 19, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1011, '入库', 1, 2, 38, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (1012, '入库', 1, 63, 30, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1013, '出库', 3, 6, 22, 6, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1014, '入库', 2, 77, 17, 12, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1015, '入库', 6, 66, 43, 11, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1016, '入库', 1, 19, 10, 11, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1017, '入库', 7, 27, 30, 3, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (1018, '入库', 1, 11, 35, 5, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1019, '出库', 5, 26, 49, 2, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1020, '入库', 4, 17, 36, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1021, '入库', 7, 47, 48, 4, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1022, '出库', 1, 65, 18, 2, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1023, '入库', 6, 39, 29, 4, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (1024, '入库', 5, 78, 35, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1025, '入库', 5, 38, 44, 3, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1026, '入库', 2, 57, 28, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1027, '出库', 2, 65, 44, 2, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1028, '入库', 4, 29, 33, 3, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1029, '入库', 1, 36, 20, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1030, '入库', 3, 18, 50, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1031, '出库', 5, 72, 22, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1032, '出库', 3, 5, 15, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1033, '入库', 5, 10, 30, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1034, '出库', 6, 44, 35, 7, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1035, '入库', 1, 46, 15, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1036, '入库', 2, 25, 30, 4, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1037, '出库', 5, 75, 41, 10, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1038, '出库', 3, 34, 20, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1039, '出库', 2, 49, 4, 9, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1040, '出库', 2, 56, 11, 7, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');
INSERT INTO `orders` VALUES (1041, '出库', 5, 48, 26, 2, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (1042, '入库', 6, 46, 35, 5, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1043, '出库', 2, 76, 40, 8, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1044, '出库', 3, 33, 11, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1045, '出库', 3, 38, 14, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (1046, '出库', 2, 1, 5, 7, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (1047, '入库', 4, 37, 3, 11, 0, 0, '2021-07-15 00:00:00', '2021-07-15 00:00:00');
INSERT INTO `orders` VALUES (1048, '入库', 7, 52, 7, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1049, '入库', 2, 40, 7, 3, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1050, '入库', 2, 74, 46, 5, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1051, '入库', 5, 10, 18, 11, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1052, '入库', 4, 51, 3, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1053, '出库', 7, 45, 33, 6, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1054, '出库', 7, 68, 33, 9, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1055, '入库', 1, 63, 9, 12, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1056, '出库', 2, 78, 6, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1057, '出库', 6, 17, 38, 7, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1058, '出库', 7, 23, 18, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1059, '出库', 5, 69, 9, 6, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1060, '入库', 4, 18, 31, 12, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1061, '入库', 6, 26, 27, 4, 0, 0, '2021-04-15 00:00:00', '2021-04-15 00:00:00');
INSERT INTO `orders` VALUES (1062, '出库', 7, 32, 7, 9, 0, 0, '2021-02-15 00:00:00', '2021-02-15 00:00:00');
INSERT INTO `orders` VALUES (1063, '出库', 1, 36, 14, 8, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1064, '出库', 1, 18, 32, 10, 0, 0, '2021-03-15 00:00:00', '2021-03-15 00:00:00');
INSERT INTO `orders` VALUES (1065, '出库', 2, 30, 29, 9, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1066, '入库', 2, 34, 4, 12, 0, 0, '2021-01-15 00:00:00', '2021-01-15 00:00:00');
INSERT INTO `orders` VALUES (1067, '出库', 1, 64, 32, 2, 0, 0, '2021-05-15 00:00:00', '2021-05-15 00:00:00');
INSERT INTO `orders` VALUES (1068, '出库', 5, 19, 46, 9, 0, 0, '2021-06-15 00:00:00', '2021-06-15 00:00:00');

-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `mfrs` bigint(20) DEFAULT NULL,
  `model` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `color` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `unit_price` decimal(24, 6) DEFAULT NULL,
  `unit` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `remark` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `status` tinyint(2) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES (1, '商用', 'Dell/戴尔成就3000十代英特尔酷睿3681小机箱4年服务网课游戏办公设计财务台式电脑主机', 11, 'D29M', '黑色', 4548.000000, '台', '商品具有中国强制性产品认证（CCC）编号，符合国家CCC认证标准。', 0, NULL, NULL);
INSERT INTO `products` VALUES (2, '商用', '惠普HP 十代酷睿i3/i5/i7迷你主机商用台式电脑办公家用微型电脑全套mini小主机', 12, 'HP/惠普 小欧390', '黑色', 3899.000000, '台', '微型计算机', 0, NULL, NULL);
INSERT INTO `products` VALUES (3, '家用', '变频分体挂壁式空调器', 3, 'KFR-26GW/N8PJA3', '白色', 2699.000000, '台', '壁挂式', 0, NULL, NULL);
INSERT INTO `products` VALUES (4, '商用', '美的饮水机立式家用上置水桶冷热即热桶装水多功能全自动上水917', 4, 'MYD917S--X', '黑金', 1149.000000, '件', '其他智能', 0, NULL, NULL);
INSERT INTO `products` VALUES (5, '家用', 'Haier/海尔 XQS120-BZ866 12公斤大容量双动力直驱变频波轮洗衣机', 5, 'XQS120-BZ866', '灰色', 4299.000000, '件', '变频电机', 0, NULL, NULL);
INSERT INTO `products` VALUES (6, '家用', '便携式计算机', 12, '14sR5-cr', '灰白', 4799.000000, '台', ' 250GB固态硬盘 512G固态硬盘', 0, NULL, NULL);
INSERT INTO `products` VALUES (7, '家用', '便携式计算机', 11, ' 7700-R1783B', '黑色', 12999.000000, '台', 'Dell/戴尔G7 7700 17.3英寸英特尔酷睿i7独显2070游戏本笔记本电脑外星人绘图渲染2060', 0, NULL, NULL);

-- ----------------------------
-- Table structure for repository
-- ----------------------------
DROP TABLE IF EXISTS `repository`;
CREATE TABLE `repository`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `address` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `manager_id` bigint(20) DEFAULT NULL,
  `status` tinyint(2) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of repository
-- ----------------------------
INSERT INTO `repository` VALUES (1, '成都电子产品仓库', '成都市武侯区', '家电产品', 3, 0, '2020-06-18 00:00:00', NULL);
INSERT INTO `repository` VALUES (2, '成都大家电仓库', '成都市武侯区', '商用电器', 2, 0, '2020-06-18 00:00:00', NULL);

-- ----------------------------
-- Table structure for rights
-- ----------------------------
DROP TABLE IF EXISTS `rights`;
CREATE TABLE `rights`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `path` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1816 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of rights
-- ----------------------------
INSERT INTO `rights` VALUES (1, '个人中心', 0, '', 1, '2021-02-18 19:17:23', '2021-02-18 19:17:23');
INSERT INTO `rights` VALUES (2, '仓库管理', 0, '', 1, '2021-02-18 19:22:19', '2021-02-18 19:22:19');
INSERT INTO `rights` VALUES (3, '人事管理', 0, '', 1, '2021-02-18 19:22:41', '2021-02-18 19:22:41');
INSERT INTO `rights` VALUES (4, '财务管理', 0, '', 1, '2021-02-18 19:23:12', '2021-02-18 19:23:12');
INSERT INTO `rights` VALUES (6, '公司事务', 0, '', 1, '2021-02-18 19:25:00', '2021-02-18 19:25:00');
INSERT INTO `rights` VALUES (7, '我的资料', 1, '/user', 2, '2021-02-18 19:23:44', '2021-02-18 19:23:44');
INSERT INTO `rights` VALUES (8, '订单信息', 2, '/orders', 2, '2021-02-18 19:24:12', '2021-02-18 19:24:12');
INSERT INTO `rights` VALUES (9, '我的订单', 1, '/myorder', 2, '2021-02-18 19:24:12', '2021-02-18 19:24:12');
INSERT INTO `rights` VALUES (11, '事务申请', 1, '/apply', 2, '2021-02-18 19:24:12', '2021-02-18 19:24:12');
INSERT INTO `rights` VALUES (12, '库存信息', 2, '/stock', 2, '2021-02-18 19:24:12', '2021-02-18 19:24:12');
INSERT INTO `rights` VALUES (13, '员工管理', 3, '/staff', 2, '2021-02-18 19:24:12', '2021-02-18 19:24:12');
INSERT INTO `rights` VALUES (14, '报销审批', 4, '/checktips', 2, '2021-06-25 17:18:20', '2021-06-25 17:18:20');
INSERT INTO `rights` VALUES (15, '订单审批', 4, '/checkorder', 2, '2021-06-25 17:18:20', '2021-06-25 17:18:20');
INSERT INTO `rights` VALUES (16, '供应商管理', 2, '/trader', 2, '2021-02-18 19:17:23', '2021-02-18 19:17:23');
INSERT INTO `rights` VALUES (17, '客户管理', 4, '/clientele', 2, '2021-02-18 19:17:23', '2021-02-18 19:17:23');
INSERT INTO `rights` VALUES (18, '表单审批', 3, '/applycheck', 2, '2021-06-18 17:10:09', '2021-06-18 17:10:09');
INSERT INTO `rights` VALUES (19, '货品管理', 2, '/products', 2, '2021-06-28 20:35:01', '2021-06-28 20:35:05');
INSERT INTO `rights` VALUES (22, '公司业绩', 6, '/welcome', 2, '2021-02-18 19:24:12', '2021-02-18 19:24:12');
INSERT INTO `rights` VALUES (24, '待办事项', 6, '/boss', 2, '2021-02-18 19:24:12', '2021-02-18 19:24:12');

-- ----------------------------
-- Table structure for stock
-- ----------------------------
DROP TABLE IF EXISTS `stock`;
CREATE TABLE `stock`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `material_id` bigint(20) DEFAULT NULL,
  `repository_id` bigint(20) DEFAULT NULL,
  `current_number` bigint(30) DEFAULT NULL,
  `delete_flag` tinyint(1) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of stock
-- ----------------------------
INSERT INTO `stock` VALUES (3, 3, 1, 245, 0, '2021-06-26 19:23:11', '2021-06-26 19:23:11');
INSERT INTO `stock` VALUES (5, 5, 1, 8, 0, '2021-06-26 19:23:11', '2021-06-26 19:23:11');
INSERT INTO `stock` VALUES (6, 6, 1, 45, 0, '2021-06-26 19:23:11', '2021-06-26 19:23:11');
INSERT INTO `stock` VALUES (7, 7, 1, 485, 0, '2021-06-26 19:23:11', '2021-06-26 19:23:11');
INSERT INTO `stock` VALUES (8, 1, 2, 8, 0, '2021-06-26 19:23:11', '2021-06-26 19:23:11');
INSERT INTO `stock` VALUES (9, 2, 2, 557, 0, '2021-06-26 19:23:11', '2021-06-26 19:23:11');
INSERT INTO `stock` VALUES (11, 4, 2, 457, 0, '2021-06-26 19:23:11', '2021-06-26 19:23:11');

-- ----------------------------
-- Table structure for trader
-- ----------------------------
DROP TABLE IF EXISTS `trader`;
CREATE TABLE `trader`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `contacts` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `phone_num` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `description` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `isystem` tinyint(1) DEFAULT NULL,
  `type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `all_get` decimal(24, 6) DEFAULT NULL,
  `all_pay` decimal(24, 6) DEFAULT NULL,
  `telephone` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `address` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `tax_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `bank_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `account_number` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `tax_rate` decimal(24, 6) DEFAULT NULL,
  `delete_flag` tinyint(1) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of trader
-- ----------------------------
INSERT INTO `trader` VALUES (1, '智威科技', '老总', '15283886254', '[email protected]', '电器、电子产品、机械产品、通讯设备及相关配件、工业自动化控制设备、计算机软硬件及辅助设备的研发与制造；家用电器及电子产品技术咨询服务；进出口业务（按外经贸部核准范围经营）；批发零售：国内商业（国家禁止商品除外）；从事数字科技、智能科技、软件科技；技术开发、技术咨询、技术转让、技术服务（包含工业互联网及家电产品等）；数据处理;应用软件开发及服务；先进控制与优化技术的开发与应用研究；矿泉水制造、饮食、旅游服务（限分支机构经营)；企业管理服务及咨询、信息技术服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）', 1, '本店', 0, 746210.250000, 502045.500000, '028-88888888', '成都市武侯区孵化园E号9座', '91110105523678742F', '兴业', '5218993215216548624', 0.520000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (2, '北京普思投资有限公司', '普老板', '13158945236', '[email protected]', '从事数字科技、智能科技、软件科技；技术开发、技术咨询、技术转让、技术服务（包含工业互联网及家电产品等）；数据处理;应用软件开发及服务；先进控制与优化技术的开发与应用研究；矿泉水制造、饮食、旅游服务（限分支机构经营)；企业管理服务及咨询、信息技术服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）', 0, '客户', 0, 0.000000, 42351.500000, '010-65818630', '北京市朝阳区建国路93号A座1605室', '91110105697678742F', '开业', '6222603215520548624', 0.270000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (3, '山东美的制冷产品销售有限公司', '吕峰', '18555215236', '[email protected]', '电器、电子产品、机械产品、通讯设备及相关配件、工业自动化控制设备、计算机软硬件及辅助设备的研发与制造；家用电器及电子产品技术咨询服务；进出口业务（按外经贸部核准范围经营）；批发零售：国内商业（国家禁止商品除外）', 0, '供应', 0, 72154.250000, 0.000000, '021-62568630', '济南市历城区遥墙机场路7617号二层', '91370100679211030F', '工商', '4026743215216548624', 0.230000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (4, '青岛美的新世纪饮水设备有限公司', '王君', '15685214563', '[email protected]', '从事数字科技、智能科技、软件科技；技术开发、技术咨询、技术转让、技术服务（包含工业互联网及家电产品等）；数据处理;应用软件开发及服务；先进控制与优化技术的开发与应用研究；矿泉水制造、饮食、旅游服务（限分支机构经营)；企业管理服务及咨询、信息技术服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）', 0, '供应', 0, 52300.500000, 0.000000, '028-88656565', '山东省青岛市市北区辽宁路247-263号中新大厦2517', '91375630679211030B', '建设', '6228923215216548624', 0.370000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (5, '海尔智家股份有限公司 ', '梁海山', '15235462884', '[email protected]', '电器、电子产品、机械产品、通讯设备及相关配件、工业自动化控制设备、计算机软硬件及辅助设备的研发与制造；家用电器及电子产品技术咨询服务；进出口业务（按外经贸部核准范围经营）；批发零售：国内商业（国家禁止商品除外）', 0, '供应', 0, 56320.500000, 0.000000, '820-65411126', '青岛市崂山区海尔工业园内', '91354200679211030F', '邮政', '6221883215216548624', 0.290000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (6, '比亚迪汽车工业有限公司济宁分公司', '边杰', '13825631458', '[email protected]', '汽车、电动车及其零配件、汽车模具及其相关附件、汽车电子装置的研发;开发、研究无线通讯技术及系统;销售自产软件;太阳能充电器、充电桩、充电柜、电池管理系统、换流柜、逆变柜/器、汇流箱、开关柜、储能机组、家庭能源系统产品的研发及销售;从事货物及技术的进出口(不含分销及国家专营专控产品);太阳能电池及其部件的批发、佣金代理(拍卖除外)、进出口及相关配套业务(不涉及国营贸易管理商品,涉及配额、许可证管理商品的,按国家有关规定办理申请);电动汽车充电设施经营及维护;汽车租赁;', 0, '客户', 0, 0.000000, 123500.500000, '010-88656565', '青岛市崂山区海尔工业园内', '91370106329211030B', '中国', '6029693215216548624', 0.590000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (7, '成都比亚迪商用车有限公司 ', '王杰', '18832145632', '[email protected]', '电器、电子产品、机械产品、通讯设备及相关配件、工业自动化控制设备、计算机软硬件及辅助设备的研发与制造；家用电器及电子产品技术咨询服务；进出口业务（按外经贸部核准范围经营）；批发零售：国内商业（国家禁止商品除外）', 0, '客户', 0, 0.000000, 83500.500000, '101-99955412', '四川省成都市天府新区邛崃产业园区羊横四路68号', '91370125179211030F', '开业', '6227603215216548624', 0.270000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (8, '成都比亚迪科技有限公司', '唐科琼', '17521563145', '[email protected]', '研发机电产品并提供技术咨询、技术推广；开发节能产品、新能源技术；开发、销售计算机软硬件并提供技术推广。', 0, '客户', 0, 0.000000, 64500.500000, '028-65411126', '成都高新区永丰路17号303室', '91378520679211030B', '兴业', '4096663215216548624', 0.590000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (9, '富士康工业互联网股份有限公司 ', '李军旗', '18631459632', '[email protected]', '一般经营项目是：，许可经营项目是：工业互联网技术研发；通讯系统研发；企业管理服务；从事电子产品及其零配件的进出口及相关配套业务（不涉及国营贸易管理商品，涉及配额、许可证管理及其它专项规定管理的商品，按国家有关规定办理申请）。', 0, '客户', 0, 0.000000, 153210.500000, '820-66666666', '深圳市龙华区龙华街道东环二路二号富士康科技园C1栋二层', '91370100321211030B', '工商', '4380883215216548624', 0.420000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (10, '富智康（成都）智能科技有限公司', '柳宏昌', '13256425842', '[email protected]', '计算机及通讯的软件开发及技术服务；数据录入、处理、加工等服务；计算机、软件及辅助设备批发；通信终端设备（不含卫星地面接收设备）的批发和进出口；销售自产产品；提供自产产品的技术咨询、测试服务、技术培训、技术转让；电脑图文设计、制作；美术设计；企业形象策划；设计、制作、代理、发布广告（不含气球广告）；信息技术咨询服务；互联网接入及相关服务；互联网信息服务。（依法须经批准的项目，经相关部门批准后方可开展经营活动）', 0, '客户', 0, 0.000000, 83520.500000, '101-99955412', '中国（四川）自由贸易试验区成都高新区世纪城南路599号天府软件园D区5栋12层', '91379870679211030F', '邮政', '6227633215216548624', 0.390000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (11, '戴尔（成都）有限公司', 'CHENHONG HUANG', '13548456945', '[email protected]', '研发、制造计算机产品和其他电子产品以及销售上述产品；从事其他产品的进出口、批发、零售业务；承包信息技术工程并提供整体解决方案，为所承包工程提供相关配套的信息技术产品，提供售后和技术咨询服务；信息技术设备设施的技术咨询、技术服务；软件应用系统集成的设计、安装、调试、维护；软件的开发、设计、制作、销售自产产品，并提供相关的技术咨询和技术服务', 0, '供应', 0, 45621.500000, 0.000000, '028-65415456', '四川省成都高新区西区天勤路800号', '91510100569680768F', '中国', '6227603215254268624', 0.340000, 0, NULL, NULL);
INSERT INTO `trader` VALUES (12, '成华区普惠销售部', '苏建', '18456245848', '[email protected]', '批发零售：日用品', 0, '供应', 0, 36214.200000, 0.000000, '048-58465621', '四川省成都市成华区五桂桥北路8号104号', '91510108MA68DMTC97', '建设', '4096663215215846546', 0.240000, 0, NULL, NULL);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `msg_num` int(11) DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `login_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `password` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `leader_id` bigint(20) DEFAULT NULL,
  `position` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `department` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `phone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `ismanager` int(1) DEFAULT NULL,
  `isystem` tinyint(3) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `description` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `id_num` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `img_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 0, '系统保留', 'admin', '0967fd80832830bc7b02d9adab38e9d5', NULL, 'sys', NULL, NULL, NULL, 0, 1, 0, '系统账号不可法删除', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (2, 0, '高管', 'boss', '0967fd80832830bc7b02d9adab38e9d5', 2, '老总', '商务部', '[email protected]', '15283829514', 0, 0, 0, NULL, NULL, NULL, NULL, 1, '510145625411145846', '//');
INSERT INTO `user` VALUES (3, 0, '财务', 'finance', '0967fd80832830bc7b02d9adab38e9d5', 2, '财务总监', '财务部', '[email protected]', '18452654841', 1, 0, 0, NULL, NULL, NULL, NULL, 0, '530154844125494563', '//');
INSERT INTO `user` VALUES (4, 0, '人事', 'personnel', '0967fd80832830bc7b02d9adab38e9d5', 2, '人事主管', '人事部', '[email protected]', '15462584563', 2, 0, 0, NULL, NULL, NULL, NULL, 1, '512365448599996542', '//');
INSERT INTO `user` VALUES (5, 0, '仓库', 'library', '0967fd80832830bc7b02d9adab38e9d5', 7, '仓管', '仓储物流部', '[email protected]', '13454856324', 3, 0, 0, NULL, NULL, NULL, NULL, 0, '523154865412548632', '//');
INSERT INTO `user` VALUES (6, 0, '员工', 'staff', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456254', 4, 0, 0, NULL, NULL, NULL, NULL, 1, '512051855632145633', '//');
INSERT INTO `user` VALUES (7, 0, '副总', 'boss02', '0967fd80832830bc7b02d9adab38e9d5', 2, '副总', '商务部', '[email protected]', '16485214564', 0, 0, 0, NULL, NULL, NULL, NULL, 0, '523648596544512451', NULL);
INSERT INTO `user` VALUES (8, 0, '梅七', 'staff01', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 1, '5120518556321455413', '//');
INSERT INTO `user` VALUES (9, 0, '陈六', 'staff02', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456254', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 0, '5120519556321455413', '//');
INSERT INTO `user` VALUES (10, 0, '李五', 'staff03', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 2, '5120518556321455413', '//');
INSERT INTO `user` VALUES (11, 0, '陈三', 'staff04', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456255', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 1, '5120519556321455413', '//');
INSERT INTO `user` VALUES (12, 0, '张三', 'staff05', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 3, '5120518556321455413', '//');
INSERT INTO `user` VALUES (13, 0, '王二', 'staff06', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456256', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 2, '5120519556321455413', '//');
INSERT INTO `user` VALUES (14, 0, '周四', 'staff07', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 4, '5120518556321455413', '//');
INSERT INTO `user` VALUES (15, 0, '陈三', 'staff08', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 2, '5120518556321455413', '//');
INSERT INTO `user` VALUES (16, 0, '杨七', 'staff09', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456255', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 1, '5120519556321455413', '//');
INSERT INTO `user` VALUES (17, 0, '李五', 'staff10', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 3, '5120518556321455413', '//');
INSERT INTO `user` VALUES (18, 0, '梅七', 'staff11', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456256', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 2, '5120519556321455413', '//');
INSERT INTO `user` VALUES (19, 0, '周三', 'staff12', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 4, '5120518556321455413', '//');
INSERT INTO `user` VALUES (20, 0, '梅二', 'staff13', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456257', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 3, '5120519556321455413', '//');
INSERT INTO `user` VALUES (21, 0, '王五', 'staff14', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 5, '5120518556321455413', '//');
INSERT INTO `user` VALUES (22, 0, '张二', 'staff15', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 3, '5120518556321455413', '//');
INSERT INTO `user` VALUES (23, 0, '王三', 'staff16', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456256', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 2, '5120519556321455413', '//');
INSERT INTO `user` VALUES (24, 0, '张三', 'staff17', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 4, '5120518556321455413', '//');
INSERT INTO `user` VALUES (25, 0, '周四', 'staff18', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456257', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 3, '5120519556321455413', '//');
INSERT INTO `user` VALUES (26, 0, '周六', 'staff19', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 5, '5120518556321455413', '//');
INSERT INTO `user` VALUES (27, 0, '周五', 'staff20', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456258', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 4, '5120519556321455413', '//');
INSERT INTO `user` VALUES (28, 0, '张五', 'staff21', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 6, '5120518556321455413', '//');
INSERT INTO `user` VALUES (29, 0, '周七', 'staff22', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 4, '5120518556321455413', '//');
INSERT INTO `user` VALUES (30, 0, '王五', 'staff23', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456257', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 3, '5120519556321455413', '//');
INSERT INTO `user` VALUES (31, 0, '王三', 'staff24', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 5, '5120518556321455413', '//');
INSERT INTO `user` VALUES (32, 0, '王二', 'staff25', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456258', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 4, '5120519556321455413', '//');
INSERT INTO `user` VALUES (33, 0, '周七', 'staff26', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 6, '5120518556321455413', '//');
INSERT INTO `user` VALUES (34, 0, '王二', 'staff27', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456259', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 5, '5120519556321455413', '//');
INSERT INTO `user` VALUES (35, 0, '杨三', 'staff28', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 7, '5120518556321455413', '//');
INSERT INTO `user` VALUES (36, 0, '张六', 'staff29', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 5, '5120518556321455413', '//');
INSERT INTO `user` VALUES (37, 0, '杨三', 'staff30', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456258', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 4, '5120519556321455413', '//');
INSERT INTO `user` VALUES (38, 0, '张一', 'staff31', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 6, '5120518556321455413', '//');
INSERT INTO `user` VALUES (39, 0, '杨二', 'staff32', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456259', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 5, '5120519556321455413', '//');
INSERT INTO `user` VALUES (40, 0, '陈四', 'staff33', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 7, '5120518556321455413', '//');
INSERT INTO `user` VALUES (41, 0, '陈四', 'staff34', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456260', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 6, '5120519556321455413', '//');
INSERT INTO `user` VALUES (42, 0, '张六', 'staff35', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 8, '5120518556321455413', '//');
INSERT INTO `user` VALUES (43, 0, '陈六', 'staff36', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 6, '5120518556321455413', '//');
INSERT INTO `user` VALUES (44, 0, '王二', 'staff37', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456259', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 5, '5120519556321455413', '//');
INSERT INTO `user` VALUES (45, 0, '梅七', 'staff38', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 7, '5120518556321455413', '//');
INSERT INTO `user` VALUES (46, 0, '梅七', 'staff39', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456260', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 6, '5120519556321455413', '//');
INSERT INTO `user` VALUES (47, 0, '张四', 'staff40', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 8, '5120518556321455413', '//');
INSERT INTO `user` VALUES (48, 0, '王七', 'staff41', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456261', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 7, '5120519556321455413', '//');
INSERT INTO `user` VALUES (49, 0, '陈五', 'staff42', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 9, '5120518556321455413', '//');
INSERT INTO `user` VALUES (50, 0, '陈五', 'staff43', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 7, '5120518556321455413', '//');
INSERT INTO `user` VALUES (51, 0, '周四', 'staff44', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456260', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 6, '5120519556321455413', '//');
INSERT INTO `user` VALUES (52, 0, '王四', 'staff45', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 8, '5120518556321455413', '//');
INSERT INTO `user` VALUES (53, 0, '梅七', 'staff46', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456261', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 7, '5120519556321455413', '//');
INSERT INTO `user` VALUES (54, 0, '张六', 'staff47', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 9, '5120518556321455413', '//');
INSERT INTO `user` VALUES (55, 0, '陈四', 'staff48', '0967fd80832830bc7b02d9adab38e9d5', 7, '员工', '生产部', '[email protected]', '15325456262', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 8, '5120519556321455413', '//');
INSERT INTO `user` VALUES (56, 0, '王一', 'staff49', '0967fd80832830bc7b02d9adab38e9d5', 2, '员工', '生产部', '[email protected]', '15325456253', 4, 0, 0, NULL, NULL, '2021-01-07 00:00:00', '2022-01-07 00:00:00', 10, '5120518556321455413', '//');

-- ----------------------------
-- Table structure for user_requests
-- ----------------------------
DROP TABLE IF EXISTS `user_requests`;
CREATE TABLE `user_requests`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `status` int(2) DEFAULT NULL,
  `type` int(6) DEFAULT NULL,
  `processors` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `start_type` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `end_type` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `total` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `remark` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `delete_flag` tinyint(1) DEFAULT NULL,
  `created` datetime(0) DEFAULT NULL,
  `updated` datetime(0) DEFAULT NULL,
  `leader_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_requests
-- ----------------------------
INSERT INTO `user_requests` VALUES (7, 1, 0, 1, '1', '2021年07月01日', '2021年07月03日', '2天', '想玩', 1, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (8, 1, 0, 1, '1', '2021年07月01日', '2021年07月03日', '2天', '想玩', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (9, 1, 1, 1, '1,2', '2021年07月01日', '2021年07月02日', '2天', '不想上班', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (10, 1, 0, 1, '1', '2021年07月01日', '2021年07月09日', '2天', '想玩游戏', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (11, 1, 0, 1, '1', '2021年07月01日', '2021年07月07日', '2天', '想学习', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (12, 1, 0, 1, '1', '2021年07月01日', '2021年06月08日', '2天', '想回家', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (13, 1, 0, 1, '1', '2021年07月01日', '2021年06月17日', '2天', '回家种地', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (14, 1, 0, 1, '1', '2021年07月01日', '2021年06月17日', '2天', '回家相亲', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (15, 1, 0, 1, '1', '2021年07月01日', '2021年06月19日', '2天', '回家娶老婆', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (16, 1, 0, 1, '1', '2021年07月01日', '2021年07月08日', '2天', '出国旅游', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (17, 1, 0, 1, '1', '2021年07月01日', '2021年07月08日', '2天', '走亲戚', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (18, 1, 0, 1, '1', '2021年07月01日', '2021年07月08日', '2天', '伺候老婆', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (19, 2, 1, 1, '2,2', '2021年07月07日', '2021年07月08日', '2天', '玩两天', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (20, 2, 0, 1, '2', '2021年06月30日', '2021年07月01日', '2天', '休息', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (21, 2, 1, 2, '2', '2021年07月08日', '住宿', '200元', '出差住宿', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (22, 2, 1, 3, '2', '2021年06月30日', '2050年07月29日', '10622天', '也该退休了', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (23, 2, 1, 2, '2', '2021年07月09日', '餐饮', '1000元', '聚餐', 0, NULL, NULL, 2);
INSERT INTO `user_requests` VALUES (24, 6, 0, 1, '6', '2021年07月15日', '2021年07月16日', '2天', '休息两天', 0, NULL, NULL, 7);
INSERT INTO `user_requests` VALUES (25, 3, 0, 1, '3', '2021年07月16日', '2021年07月16日', '1天', '身体不适', 0, NULL, NULL, 2);

SET FOREIGN_KEY_CHECKS = 1;