【个人收集】上报维修管理系统（springboot+vue+elementui+微信小程序）

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80026 Source Host : localhost:3306 Source Schema : ideamerry_repair_v3 Target Server Type : MySQL Target Server Version : 80026 File Encoding : 65001 Date: 14/03/2022 15:35:01 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for repair_info -- ---------------------------- DROP TABLE IF EXISTS `repair_info`; CREATE TABLE `repair_info` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `type` tinyint DEFAULT NULL COMMENT '报修类型', `status` tinyint DEFAULT NULL COMMENT '报修单状态', `repair_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '报修时间', `address` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '报修地址', `description` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '故障描述', `image_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '故障图片', `message` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '留言', `evaluate` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '意见和建议', `reason` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '故障原因', `consumables` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '故障耗材', `applicant_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '申请人姓名', `remarks` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '申请人联系电话', `star` tinyint DEFAULT NULL COMMENT '星级别评级', `radio_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '语音url', `evaluate_date` datetime DEFAULT NULL COMMENT '评价时间', `openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'openid', `campus` int DEFAULT '1' COMMENT '学校', `finish_time` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '维修完成时间', `allocated_time` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务分配时间', `detail` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '故障处理说明', `repair_cancel_reason` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '报修取消原因', `repair_cancel_reason_remark` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '报修取消原因备注', `repair_cancel_date` datetime DEFAULT NULL COMMENT '报修取消时间', `location` tinyint DEFAULT NULL COMMENT '位置名称', `level` tinyint DEFAULT '3' COMMENT '维修级别', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=650 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='报修信息'; -- ---------------------------- -- Records of repair_info -- ---------------------------- BEGIN; INSERT INTO `repair_info` VALUES (613, 2, 1, '2022-03-01 14:56:36', '电子阅览室', '键盘故障，不能使用', '', '', NULL, '', '', '刘晓晓', '224', '222', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (614, 1, 1, '2022-03-02 10:56:29', '3号公寓1层', '卫生间灯不亮', '', '', NULL, '', '', '安浩鑫', '2', '3', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (615, 1, 1, '2022-03-03 10:50:20', '南一教学楼403', '投影仪不亮', '', '', NULL, '', '', '岳泽飞', '323', '32', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (616, 1, 1, '2022-03-03 10:56:14', '一号餐厅', '入口门玻璃坏了', '', '', NULL, '', '', '张丁洋', '3232', '嗯嗯', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (617, 2, 1, '2022-03-05 10:56:06', '门卫亭', '灯管坏了三个需要更换', '', '', NULL, '', '', '安浩鑫', '测', '1800192811', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (618, 1, 1, '2022-03-05 10:55:58', '逸夫楼101', '电子大屏不亮', '', '', NULL, '', '', '梅泽宇', '23323', '32', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (619, 2, 1, '2022-03-06 20:44:43', '荷园餐厅荤切间', '成品库冰箱不制冷', '', '', NULL, '', '', '安浩鑫', '电风扇', '发生地方', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (620, 2, 1, '2022-03-07 11:53:33', '东学餐厅', '筷子消毒车不工作了，请尽快维修。谢谢', '', '', NULL, '', '', '卢子健', '热二', '热', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (621, 1, 1, '2022-03-08 10:55:24', '西餐厅', '水池需要安装一个水龙头', '', '', NULL, '', '', '卢子健', '23232', '422', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (622, 1, 3, '2022-03-09 22:55:17', '逸夫楼109', '灯管坏3个', '', '', NULL, '', '', '张丁洋', '232323', '18920609603', NULL, '', NULL, 'orswI40HV1PiLRZCKlYpz06uDWaY', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (623, 1, 3, '2022-03-10 22:55:04', '一号餐厅', '餐桌桌腿断了需要维修', '', '', NULL, '', '', '梅泽宇', '热惹他', '18920609603', NULL, '', NULL, 'orswI40HV1PiLRZCKlYpz06uDWaY', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (624, 2, 3, '2022-03-11 22:55:09', '图书馆', '借书电脑刷学生卡不能显示信息', '', '', NULL, '', '', '张丁洋', '4343', '18920609603', NULL, '', NULL, 'orswI40HV1PiLRZCKlYpz06uDWaY', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (625, 1, 3, '2022-03-11 22:54:59', '电子阅览室', '预约管理系统不能连接网络', '', '', '', '', '', '张丁洋', '323223', '18920609603', 4, '', NULL, 'orswI40HV1PiLRZCKlYpz06uDWaY', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (626, 1, 3, '2022-03-12 22:54:53', '逸夫楼1003', '门锁损坏', '', 'null', NULL, 'null', 'null', '王笑笑', '', '18920609603', NULL, '', NULL, 'orswI40HV1PiLRZCKlYpz06uDWaY', NULL, NULL, NULL, 'null', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (646, 1, 3, '2022-03-12 21:32:05', 'dafdas', 'dafdaf', '/upload/2022-03-12/new-javXbsrQRmcda453941995ed138e75e7ed0af605f33a.png', 'null', '', 'null', 'null', '王亮', '', '18920609602', 5, '', NULL, 'orswI40HV1PiLRZCKlYpz06uDWaY', NULL, NULL, NULL, 'null', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (648, 2, 3, '2022-03-14 13:36:17', '逸夫楼909', '不知道哪里里坏了', '', '', NULL, '', '', '王亮', '就想报修', '18920609602', NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); INSERT INTO `repair_info` VALUES (649, 1, 3, '2022-03-14 13:41:47', '测试地点', '测试', '/upload/2022-03-14/new-54RGJM7qioOk87d8e4dd47486aba12f6b06c46fbb66d.jpg', NULL, '', NULL, NULL, 'admin', '', '18920609603', 4, '', NULL, 'orswI40HV1PiLRZCKlYpz06uDWaY', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` int NOT NULL