lingling
/
welfare-api
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
welfare-api/welfare_20231124_104211.sql

771 lines
31 MiB
MySQL
Raw Permalink Normal View History

提交
2023-12-21 10:29:44 +08:00
-- MySQL dump 10.13 Distrib 5.7.40, for Linux (x86_64)
--
-- Host: localhost Database: welfare
-- ------------------------------------------------------
-- Server version 5.7.40-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `bc_honor_show`
--
DROP TABLE IF EXISTS `bc_honor_show`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bc_honor_show` (
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`content` text COMMENT '内容',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`files` mediumtext COMMENT '附件',
`title` varchar(200) DEFAULT NULL COMMENT '标题',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`type` tinyint(4) DEFAULT '1' COMMENT '展示类型 ',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`if_top` tinyint(4) DEFAULT '0' COMMENT '是否置顶 1是 0否',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='荣誉橱窗展示表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bc_honor_show`
--
LOCK TABLES `bc_honor_show` WRITE;
/*!40000 ALTER TABLE `bc_honor_show` DISABLE KEYS */;
INSERT INTO `bc_honor_show` VALUES (NULL,'<section data-role=\"paragraph\" style=\"margin: 0px; padding: 0px; outline: 0px; max-width: 100%; color: rgba(0, 0, 0, 0.9); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; letter-spacing: 0.544px; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255); visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 2em; text-indent: 2em; visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; outline: 0px; max-width: 100%; box-sizing: border-box !important; overflow-wrap: break-word !important; font-size: 17px; font-family: 微软雅黑, &quot;Microsoft YaHei&quot;; visibility: visible;\">为更好地团结凝聚在外流动党员，不断推动流动党员教育管理走深向实，近日，下堡坪乡在乡飞地企业宜昌东方龙茶业有限公司成立了“下堡坪乡流动党员之家”，为流动党员搭建发挥作用、回报家乡的有力平台，让流动党员找到家、聚起来、有作为。</span></p></section><p></p><section data-role=\"paragraph\" style=\"margin: 0px; padding: 0px; outline: 0px; max-width: 100%; color: rgba(0, 0, 0, 0.9); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; letter-spacing: 0.544px; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255); box-sizing: border-box !important; overflow-wrap: break-word !important;\"><p style=\"padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; box-sizing: border-box !important; overflow-wrap: break-word !important;\"><img src=\"/welfare/sys/oss/show/20231018/a63b66d2a5d24459b75bf90b8f43bab5.jpg?width=1024\" title=\"2.jpg\" alt=\"2.jpg\"/></p></section><section data-role=\"paragraph\" style=\"margin: 0px; padding: 0px; outline: 0px; max-width: 100%; color: rgba(0, 0, 0, 0.9); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; letter-spacing: 0.544px; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255); box-sizing: border-box !important; overflow-wrap: break-word !important;\"><p style=\"padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; text-indent: 2em; line-height: 2em; box-sizing: border-box !important; overflow-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; outline: 0px; max-width: 100%; box-sizing: border-box !important; overflow-wrap: break-word !important; font-size: 17px; letter-spacing: 1px; line-height: 1.71em; font-family: 微软雅黑, &quot;Microsoft YaHei&quot;;\">7月19日，位于宜昌东方龙茶业有限公司的“流动党员之家”正式投入使用，长期居住在小溪塔及宜昌城区的19名下堡坪乡党员在此举办首次支部主题党日活动。</span></p></section><p></p><p><br/></p>','2023-10-18 23:01:17',NULL,'[{\"uid\":\"9\",\"name\":\"4.jpg\",\"url\":\"/welfare/sys/oss/show/20231018/da8fc5f2c7ff47b988dfc83398a32baa.jpg\"}]','下堡坪乡：让流动党员有“家”有“为”',1,1,NULL,'2023-10-26 08:50:00',NULL,1,0,3,0),(NULL,'<section powered-by=\"xiumi.us\" style=\"margin: 6px 0px 20px; padding: 0px; outline: 0px; max-width: 100%; color: rgb(127, 119, 118); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial,
/*!40000 ALTER TABLE `bc_honor_show` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bc_hospital_record`
--
DROP TABLE IF EXISTS `bc_hospital_record`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bc_hospital_record` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`type` tinyint(4) DEFAULT '1' COMMENT '记录类型 1-入院 2-出院',
`person_id` bigint(20) DEFAULT NULL COMMENT '人员id',
`room_id` bigint(20) DEFAULT NULL COMMENT '房间id',
`bed_id` bigint(20) DEFAULT NULL COMMENT '床位id',
`check_in_time` datetime DEFAULT NULL COMMENT '入住时间',
`check_out_time` datetime DEFAULT NULL COMMENT '退房时间',
`device_usage` varchar(500) DEFAULT NULL COMMENT '辅具使用情况',
`medication` varchar(500) DEFAULT NULL COMMENT '用药情况',
`doctor_advice` varchar(500) DEFAULT NULL COMMENT '医嘱',
`special_instruction` varchar(500) DEFAULT NULL COMMENT '特殊说明',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='入院记录表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bc_hospital_record`
--
LOCK TABLES `bc_hospital_record` WRITE;
/*!40000 ALTER TABLE `bc_hospital_record` DISABLE KEYS */;
INSERT INTO `bc_hospital_record` VALUES (1,1,8,1,9,'2023-09-15 23:12:27',NULL,NULL,NULL,NULL,NULL,1,'2023-09-15 23:12:27',1,'2023-10-17 15:45:49',1,1,'2023-10-21 10:40:27',NULL,'测试'),(2,1,2,4,8,'2023-09-15 23:52:10','2023-09-16 00:21:58',NULL,NULL,NULL,NULL,1,'2023-09-15 23:52:10',1,'2023-09-16 00:21:58',1,NULL,NULL,NULL,''),(3,1,27,8,19,'2023-10-21 09:41:21',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 09:41:21',NULL,NULL,1,1,'2023-10-21 10:40:26',NULL,NULL),(4,1,43,5,10,'2023-10-21 10:40:53',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:40:53',NULL,NULL,0,NULL,NULL,NULL,''),(5,1,75,5,11,'2023-10-21 10:41:15',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:41:15',1,'2023-11-03 15:30:38',0,NULL,NULL,NULL,''),(6,1,66,6,12,'2023-10-21 10:41:40',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:41:40',NULL,NULL,0,NULL,NULL,NULL,''),(7,1,67,6,13,'2023-10-21 10:41:57',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:41:57',1,'2023-11-03 15:51:20',0,NULL,NULL,NULL,''),(8,1,34,7,14,'2023-10-21 10:42:24',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:42:24',NULL,NULL,0,NULL,NULL,NULL,''),(9,1,48,7,15,'2023-10-21 10:42:45',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:42:45',NULL,NULL,0,NULL,NULL,NULL,''),(10,1,35,7,16,'2023-10-21 10:43:15',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:43:15',NULL,NULL,0,NULL,NULL,NULL,''),(11,1,64,7,17,'2023-10-21 10:43:33',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:43:33',1,'2023-11-03 15:53:44',0,NULL,NULL,NULL,''),(12,1,53,22,46,'2023-10-21 10:44:24',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:44:24',NULL,NULL,0,NULL,NULL,NULL,''),(13,1,79,22,48,'2023-10-21 10:47:19',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:47:19',1,'2023-11-03 15:27:14',0,NULL,NULL,NULL,''),(14,1,61,22,49,'2023-10-21 10:47:45',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:47:45',1,'2023-11-03 15:54:53',0,NULL,NULL,NULL,''),(15,1,77,21,44,'2023-10-21 10:48:24',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:48:24',1,'2023-11-03 15:28:53',0,NULL,NULL,NULL,''),(16,1,69,21,45,'2023-10-21 10:48:43',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:48:43',1,'2023-11-03 15:49:57',0,NULL,NULL,NULL,''),(17,1,19,20,42,'2023-10-21 10:49:19',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:49:19',NULL,NULL,0,NULL,NULL,NULL,''),(18,1,56,20,43,'2023-10-21 10:49:43',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:49:43',1,'2023-11-03 16:05:46',0,NULL,NULL,NULL,''),(19,1,32,19,40,'2023-10-21 10:50:10',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:50:10',NULL,NULL,0,NULL,NULL,NULL,''),(20,1,31,19,41,'2023-10-21 10:50:29',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:50:29',NULL,NULL,0,NULL,NULL,NULL,''),(21,1,76,18,38,'2023-10-21 10:50:52',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:50:52',1,'2023-11-03 15:29:26',0,NULL,NULL,NULL,''),(22,1,30,18,39,'2023-10-21 10:51:13',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:51:13',NULL,NULL,0,NULL,NULL,NULL,''),(23,1,17,16,34,'2023-10-21 10:53:16',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:53:16',NULL,NULL,0,NULL,NULL,NULL,''),(24,1,18,16,35,'2023-10-21 10:53:40',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:53:40',NULL,NULL,0,NULL,NULL,NULL,''),(25,1,65,15,32,'2023-10-21 10:54:01',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:54:01',NULL,NULL,0,NULL,NULL,NULL,''),(26,1,44,14,30,'2023-10-21 10:54:20',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:54:20',NULL,NULL,0,NULL,NULL,NULL,''),(27,1,28,14,31,'2023-10-21 10:54:44',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:54:44',NULL,NULL,0,NULL,NULL,NULL,''),(28,1,62,13,28,'2023-10-21 10:55:03',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:55:03',1,'2023-11-03 15:54:35',0,NULL,NULL,NULL,''),(29,1,63,13,29,'2023-10-21 10:56:48',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:56:48',1,'2023-11-03 15:54:16',0,NULL,NULL,NULL,''),(30,1,74,12,26,'2023-10-21 10:57:41',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:57:41',1,'2023-11-03 15:32:15',0,NULL,NULL,NULL,''),(31,1,39,12,27,'2023-10-21 10:58:02',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:58:02',NULL,NULL,0,NULL,NULL,NULL,''),(32,1,60,10,22,'2023-10-21 10:58:31',NULL,NULL,NULL,NULL,NULL,1,'2023-10-21 10:58:31',1,'2023-11-03 15:55:40',0,NULL,NULL,NULL,''),(33,1,59,10,23,'2023-10-21 10:58:52',NULL,NULL,NULL,NULL,NULL,1,'2023-10
/*!40000 ALTER TABLE `bc_hospital_record` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bc_person_family`
--
DROP TABLE IF EXISTS `bc_person_family`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bc_person_family` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`person_id` bigint(20) NOT NULL COMMENT '人员id',
`relation` varchar(255) DEFAULT NULL COMMENT '与人员关系',
`family_name` varchar(255) DEFAULT NULL COMMENT '家庭成员姓名',
`id_card_no` varchar(255) DEFAULT NULL COMMENT '身份证号',
`phone` varchar(255) DEFAULT NULL COMMENT '联系电话',
`work_info` varchar(255) DEFAULT NULL COMMENT '工作单位及职务家庭成员及社会关系人员工作单位及职务',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='人员-家庭成员表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bc_person_family`
--
LOCK TABLES `bc_person_family` WRITE;
/*!40000 ALTER TABLE `bc_person_family` DISABLE KEYS */;
INSERT INTO `bc_person_family` VALUES (1,2,NULL,'张三',NULL,NULL,NULL,1,'2023-09-13 22:14:56',NULL,NULL,1,1,'2023-09-13 22:16:49',NULL,NULL),(2,2,NULL,'张三',NULL,NULL,NULL,1,'2023-09-13 22:16:50',1,'2023-09-14 22:34:47',1,1,'2023-09-14 22:36:22',NULL,NULL),(3,2,NULL,'测试',NULL,NULL,NULL,1,'2023-09-13 22:23:58',NULL,NULL,1,1,'2023-09-13 22:24:11',NULL,NULL),(4,11,NULL,NULL,NULL,NULL,NULL,1,'2023-09-13 22:48:03',1,'2023-09-13 22:48:25',1,1,'2023-09-13 22:54:52',NULL,NULL),(5,11,NULL,NULL,NULL,NULL,NULL,1,'2023-09-13 22:48:25',NULL,NULL,1,1,'2023-09-13 22:54:52',NULL,NULL),(6,2,NULL,'力生物',NULL,NULL,NULL,1,'2023-09-14 22:34:47',1,'2023-09-14 23:03:08',1,1,'2023-09-14 23:06:40',NULL,NULL),(7,2,NULL,'喂喂喂',NULL,NULL,NULL,1,'2023-09-14 22:34:47',NULL,NULL,1,1,'2023-09-14 22:36:22',NULL,NULL),(8,2,NULL,'张三',NULL,NULL,NULL,1,'2023-09-14 23:14:08',NULL,NULL,1,1,'2023-10-20 17:18:48',NULL,NULL),(9,2,NULL,'测试',NULL,NULL,NULL,1,'2023-09-14 23:14:08',NULL,NULL,1,1,'2023-10-20 17:18:48',NULL,NULL),(10,11,NULL,'测试',NULL,NULL,NULL,1,'2023-09-14 23:22:06',NULL,NULL,1,1,'2023-10-21 09:00:02',NULL,NULL),(11,11,NULL,'力生物',NULL,NULL,NULL,1,'2023-09-14 23:22:06',NULL,NULL,1,1,'2023-10-21 09:00:02',NULL,NULL),(12,12,NULL,'张三',NULL,NULL,NULL,1,'2023-09-15 19:19:41',NULL,NULL,1,1,'2023-09-15 19:33:23',NULL,NULL),(13,12,NULL,'测试',NULL,NULL,NULL,1,'2023-09-15 19:19:41',NULL,NULL,1,1,'2023-09-15 19:33:23',NULL,NULL),(14,12,NULL,'张三',NULL,NULL,NULL,1,'2023-09-15 19:33:23',1,'2023-10-17 15:54:55',1,1,'2023-10-20 17:24:04',NULL,NULL),(15,12,NULL,'力生物',NULL,NULL,NULL,1,'2023-09-15 19:33:23',1,'2023-10-17 15:54:55',1,1,'2023-10-20 17:24:04',NULL,NULL);
/*!40000 ALTER TABLE `bc_person_family` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bc_person_service`
--
DROP TABLE IF EXISTS `bc_person_service`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bc_person_service` (
`id` bigint(20) NOT NULL COMMENT '用户ID',
`name` varchar(20) DEFAULT NULL COMMENT '姓名',
`id_card_no` varchar(30) DEFAULT NULL COMMENT '身份证号码',
`birthday` datetime DEFAULT NULL COMMENT '出生日期',
`sex` tinyint(1) DEFAULT NULL COMMENT '性别 1-男 0-女',
`phone` varchar(11) DEFAULT NULL COMMENT '手机号码',
`jobs` tinyint(4) DEFAULT NULL COMMENT '岗位',
`home_address` varchar(500) DEFAULT NULL COMMENT '家庭住址',
`marital_status` tinyint(1) DEFAULT NULL COMMENT '婚姻状况 1-未婚 2-已婚 3-离异 4-未知',
`native_place` varchar(200) DEFAULT NULL COMMENT '籍贯',
`nation` varchar(50) DEFAULT NULL COMMENT '民族',
`health` varchar(500) DEFAULT NULL COMMENT '身体状况',
`disease_history` varchar(500) DEFAULT NULL COMMENT '疾病史',
`awards` varchar(500) DEFAULT NULL COMMENT '获得奖项',
`punish` varchar(500) DEFAULT NULL COMMENT '受到处罚',
`train` varchar(500) DEFAULT NULL COMMENT '参加的培训课程',
`certificate` varchar(500) DEFAULT NULL COMMENT '获得的证书',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`political_outlook` tinyint(4) DEFAULT NULL COMMENT '政治面貌 数据字典0060',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='服务人员表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bc_person_service`
--
LOCK TABLES `bc_person_service` WRITE;
/*!40000 ALTER TABLE `bc_person_service` DISABLE KEYS */;
INSERT INTO `bc_person_service` VALUES (12,'张三三','500235199901110032',NULL,1,'13872577251',4,'测试',1,'湖北宜昌','汉','身体状况','疾病史','据报道，这起盗窃事件发生在德国科隆的一家享有声誉的东亚艺术博物馆。博物馆工作人员在当天发现展览空间的瓷器陈列区域被盗，失窃的文物包括了9件中国明清时代制造的珍贵瓷器，其中包括花瓶、瓷盘和瓷罐等。这些被盗文物的估计价值超过100万欧元，其艺术和历史价值无法估量。\n\n盗窃事件引起了博物馆和警方的高度关注。警方立即展开调查，并正在分析监控录像和相关线索，以期尽快找到并追回被盗文物。博物馆方面也呼吁公众提供任何可能的信息，以协助警方解决这一案件。\n\n这些被盗的中国明清时期瓷器是具有极高历史和文化价值的艺术品。明清时期的中国瓷器以其精湛的工艺和独特的美学风格而闻名于世。这些瓷器作品不仅代表了中国古代陶瓷艺术的巅峰之作，同时也记录了当时的社会、经济和文化背景。','据报道，这起盗窃事件发生在德国科隆的一家享有声誉的东亚艺术博物馆。博物馆工作人员在当天发现展览空间的瓷器陈列区域被盗，失窃的文物包括了9件中国明清时代制造的珍贵瓷器，其中包括花瓶、瓷盘和瓷罐等。这些被盗文物的估计价值超过100万欧元，其艺术和历史价值无法估量。\n\n盗窃事件引起了博物馆和警方的高度关注。警方立即展开调查，并正在分析监控录像和相关线索，以期尽快找到并追回被盗文物。博物馆方面也呼吁公众提供任何可能的信息，以协助警方解决这一案件。\n\n这些被盗的中国明清时期瓷器是具有极高历史和文化价值的艺术品。明清时期的中国瓷器以其精湛的工艺和独特的美学风格而闻名于世。这些瓷器作品不仅代表了中国古代陶瓷艺术的巅峰之作，同时也记录了当时的社会、经济和文化背景。','据报道，这起盗窃事件发生在德国科隆的一家享有声誉的东亚艺术博物馆。博物馆工作人员在当天发现展览空间的瓷器陈列区域被盗，失窃的文物包括了9件中国明清时代制造的珍贵瓷器，其中包括花瓶、瓷盘和瓷罐等。这些被盗文物的估计价值超过100万欧元，其艺术和历史价值无法估量。\n\n盗窃事件引起了博物馆和警方的高度关注。警方立即展开调查，并正在分析监控录像和相关线索，以期尽快找到并追回被盗文物。博物馆方面也呼吁公众提供任何可能的信息，以协助警方解决这一案件。\n\n这些被盗的中国明清时期瓷器是具有极高历史和文化价值的艺术品。明清时期的中国瓷器以其精湛的工艺和独特的美学风格而闻名于世。这些瓷器作品不仅代表了中国古代陶瓷艺术的巅峰之作，同时也记录了当时的社会、经济和文化背景。','获得证书\n',NULL,'2023-09-14 20:17:46',1,'2023-10-17 15:54:55',1,1,'2023-10-20 17:24:05',NULL,NULL,NULL),(15,'测试','11',NULL,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-09-14 20:42:33',NULL,NULL,1,1,'2023-09-14 20:42:37',NULL,NULL,NULL),(20,'鲁自鹏','42272119630809366X',NULL,0,'13317561333',1,'夷陵区下堡坪乡磨坪村',2,'溯北宜昌','汉','良',NULL,NULL,NULL,'2022.8参加养老护理培训,2023.8参加消防培训',NULL,NULL,'2023-10-20 17:24:01',1,'2023-11-04 15:02:12',0,NULL,NULL,NULL,NULL,1),(21,'谢俊维','420521198508023654',NULL,1,'15171734169',3,'夷陵区下堡坪乡赵勉河村',2,'湖北宜昌','汉','良',NULL,NULL,NULL,'2022.8参加养老护理培训,2023.8参加消防培训',NULL,NULL,'2023-10-20 17:24:56',1,'2023-11-04 15:05:35',0,NULL,NULL,NULL,NULL,3),(22,'陈天庆','42272119630714471X',NULL,1,'13872601476',2,'夷陵区下堡坪乡九山村',2,'湖北宜昌','汉','良',NULL,NULL,NULL,'2022.8月参加养老护理培训,2023.8月参<EFBFBD>
/*!40000 ALTER TABLE `bc_person_service` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bc_person_support`
--
DROP TABLE IF EXISTS `bc_person_support`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bc_person_support` (
`id` bigint(20) NOT NULL COMMENT '用户ID',
`name` varchar(20) DEFAULT NULL COMMENT '姓名',
`id_card_no` varchar(30) DEFAULT NULL COMMENT '身份证号码',
`phone` varchar(11) DEFAULT NULL COMMENT '手机号码',
`sex` tinyint(1) DEFAULT NULL COMMENT '性别 1-男 0-女',
`residence_address` varchar(200) DEFAULT NULL COMMENT '户籍地址',
`if_help_poor` tinyint(1) DEFAULT '0' COMMENT '是否精准扶贫户 1-是 0-否',
`exercise_habits` varchar(500) DEFAULT NULL COMMENT '运动习惯',
`mentality` varchar(500) DEFAULT NULL COMMENT '精神状态',
`doctor_advice` varchar(500) DEFAULT NULL COMMENT '医嘱',
`medication` varchar(500) DEFAULT NULL COMMENT '用药情况',
`health` varchar(500) DEFAULT NULL COMMENT '身体状况',
`marital_status` tinyint(1) DEFAULT NULL COMMENT '婚姻状况 1-未婚 2-已婚 3-离异 4-未知',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`bring_time` datetime DEFAULT NULL COMMENT '纳入时间',
`device_usage` varchar(500) DEFAULT NULL COMMENT '辅具使用情况',
`if_disabled` tinyint(1) DEFAULT '0' COMMENT '是否残疾 1-是 0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`activity_record` varchar(500) DEFAULT NULL COMMENT '共建共享志愿活动记录',
`favorite_activity` varchar(500) DEFAULT NULL COMMENT '喜好的文艺、体育等方面的活动',
`sleep_quality` varchar(500) DEFAULT NULL COMMENT '睡眠情况',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`disease_history` varchar(500) DEFAULT NULL COMMENT '疾病史',
`allowance_account` varchar(100) DEFAULT NULL COMMENT '补贴发放账户',
`hardship_allowance_basic` decimal(16,2) DEFAULT NULL COMMENT '特困供养金发放金额-基本生活补助金额',
`hardship_allowance_total` decimal(16,2) DEFAULT NULL COMMENT '特困供养金发放金额-合计金额',
`self_care` varchar(200) DEFAULT NULL COMMENT '自理情况登记',
`disability_level` varchar(50) DEFAULT NULL COMMENT '残疾等级',
`support_type` tinyint(1) DEFAULT NULL COMMENT '供养方式',
`type` tinyint(1) DEFAULT '1' COMMENT '人员类型 1-供养人员 2-医养结合护理人员',
`special_instruction` varchar(500) DEFAULT NULL COMMENT '特殊说明',
`allergy_history` varchar(500) DEFAULT NULL COMMENT '过敏史',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`hygiene` varchar(500) DEFAULT NULL COMMENT '卫生情况',
`medication_status` varchar(500) DEFAULT NULL COMMENT '服药情况',
`eating_habits` varchar(500) DEFAULT NULL COMMENT '饮食习惯',
`hardship_allowance_care` decimal(16,2) DEFAULT NULL COMMENT '特困供养金发放金额-护理照料补贴金额',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`residence_village` varchar(100) DEFAULT NULL COMMENT '归属村属',
`nursing_level` tinyint(1) DEFAULT NULL COMMENT '护理等级',
`village` tinyint(1) DEFAULT NULL COMMENT '所在村',
`is_in_hospital` tinyint(1) DEFAULT '1' COMMENT '是否在院 1是 0否',
`hospital_message` varchar(255) DEFAULT NULL COMMENT '住院信息',
`relative_contact` varchar(20) DEFAULT NULL COMMENT '亲属联系方式',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='供养人员表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bc_person_support`
--
LOCK TABLES `bc_person_support` WRITE;
/*!40000 ALTER TABLE `bc_person_support` DISABLE KEYS */;
INSERT INTO `bc_person_support` VALUES (2,'屈小丽','420500199901110011','13872572250',1,'重庆',0,NULL,NULL,NULL,NULL,NULL,3,NULL,'2023-09-13 00:00:00',NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,15000.00,31000.00,'111','测试残疾等级',1,1,NULL,NULL,'2023-09-14 23:14:08',NULL,NULL,NULL,16000.00,NULL,'2023-10-20 17:18:48','村',NULL,NULL,1,NULL,NULL,NULL,1),(8,'张三','500235199908273737','',1,'测试',0,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,0,1,1,NULL,NULL,NULL,'2023-09-13 17:36:50',NULL,NULL,NULL,NULL,'测试',NULL,1,1,NULL,NULL,'2023-10-17 15:45:49',NULL,NULL,NULL,NULL,NULL,'2023-10-20 17:18:44',NULL,1,1,1,NULL,NULL,NULL,1),(9,'李四','500235199701253474','',1,'测试二上',0,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,0,1,1,NULL,NULL,NULL,'2023-09-13 18:04:31',NULL,NULL,NULL,NULL,'测试',NULL,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-09-14 19:53:49',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL),(11,'王五','420500197302012123','13872572251',0,'户籍地址',0,NULL,NULL,NULL,NULL,'身体状况',3,NULL,'2023-09-13 00:00:00',NULL,0,1,1,NULL,NULL,NULL,'2023-09-13 22:44:15','疾病史',NULL,NULL,NULL,NULL,NULL,2,2,NULL,NULL,'2023-09-14 23:22:06',NULL,NULL,NULL,NULL,NULL,'2023-10-21 09:00:03',NULL,NULL,NULL,1,NULL,NULL,NULL,1),(16,'钱琦','420500196108123716','',1,'',0,NULL,NULL,NULL,NULL,NULL,2,NULL,'2023-10-11 00:00:00',NULL,0,1,1,NULL,NULL,NULL,'2023-10-11 21:53:02',NULL,NULL,NULL,NULL,NULL,NULL,2,1,NULL,NULL,'2023-10-11 21:54:58',NULL,NULL,NULL,NULL,NULL,'2023-10-20 17:18:53','一组',3,2,1,NULL,NULL,NULL,1),(17,'黄士树','422721195610184736','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-19 17:23:18',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'三组',3,1,1,NULL,NULL,NULL,NULL),(18,'张绿祥','422721193810264715','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2005-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-19 17:24:15',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'四组',3,1,1,NULL,NULL,NULL,NULL),(19,'汪振扬','420521198706274710','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-19 17:25:03',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'八组',3,1,1,NULL,NULL,NULL,NULL),(27,'贾相宏','422721196208084715','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2003-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-21 09:41:21',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'十组',3,1,1,NULL,NULL,NULL,NULL),(28,'黄自富','422721193402044713','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1995-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-21 09:42:35',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'十组',3,1,1,NULL,NULL,NULL,NULL),(29,'冯德伍','422721195505074711','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2004-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-21 09:43:25',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,'2023-11-04 15:56:56',NULL,NULL,NULL,NULL,NULL,NULL,'十三组',1,1,0,'小溪塔福利院',NULL,NULL,1),(30,'冯德平','422721196203194712','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-21 09:44:31',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'十三组',1,1,1,NULL,NULL,NULL,NULL),(31,'张祥全','422721195610064734','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2015-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-21 09:45:30',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,'2023-10-21 09:45:46',NULL,NULL,NULL,NULL,NULL,NULL,'四组',3,1,1,NULL,NULL,NULL,1),(32,'张祥平','42272119670708471X','',1,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-01 00:00:00',NULL,0,NULL,0,NULL,NULL,NULL,'2023-10-21 09:46:44',NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,'2023-10-21 09:47:06',NULL,NULL,NULL,NULL,NULL,NULL,'四组',3,1,1,NULL,NULL,NULL,1),(33,'张德秀','422721192709114726','',0,'',1,NULL,
/*!40000 ALTER TABLE `bc_person_support` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bc_room`
--
DROP TABLE IF EXISTS `bc_room`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bc_room` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) NOT NULL COMMENT '房间名称',
`bed_number` int(11) DEFAULT NULL COMMENT '房间床位',
`room_type` int(11) DEFAULT NULL COMMENT '房间类型 数据字典0010',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='房间表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bc_room`
--
LOCK TABLES `bc_room` WRITE;
/*!40000 ALTER TABLE `bc_room` DISABLE KEYS */;
INSERT INTO `bc_room` VALUES (1,'101室',3,1,1,'2023-09-14 22:20:33',1,'2023-09-15 19:21:53',1,1,'2023-10-21 09:04:47',NULL,NULL),(4,'102室',2,1,1,'2023-09-14 23:15:52',1,'2023-09-15 19:21:45',1,1,'2023-10-21 09:04:49',NULL,NULL),(5,'101',2,1,1,'2023-10-21 09:17:54',1,'2023-10-21 09:18:11',0,NULL,NULL,NULL,NULL),(6,'102',2,1,1,'2023-10-21 09:18:23',1,'2023-10-21 09:18:55',0,NULL,NULL,NULL,NULL),(7,'103',4,1,1,'2023-10-21 09:19:03',1,'2023-10-21 09:19:29',0,NULL,NULL,NULL,NULL),(8,'201',2,1,1,'2023-10-21 09:19:55',1,'2023-10-21 09:20:10',0,NULL,NULL,NULL,NULL),(9,'202',2,1,1,'2023-10-21 09:20:52',1,'2023-10-21 09:21:05',0,NULL,NULL,NULL,NULL),(10,'203',2,1,1,'2023-10-21 09:21:46',1,'2023-10-21 09:22:07',0,NULL,NULL,NULL,NULL),(11,'204',2,1,1,'2023-10-21 09:22:15',1,'2023-10-21 09:22:26',0,NULL,NULL,NULL,NULL),(12,'205',2,1,1,'2023-10-21 09:22:34',1,'2023-10-21 09:22:49',0,NULL,NULL,NULL,NULL),(13,'206',2,1,1,'2023-10-21 09:22:58',1,'2023-10-21 09:23:09',0,NULL,NULL,NULL,NULL),(14,'207',2,1,1,'2023-10-21 09:23:17',1,'2023-10-21 09:23:33',0,NULL,NULL,NULL,NULL),(15,'208',2,1,1,'2023-10-21 09:23:41',1,'2023-10-21 09:24:04',0,NULL,NULL,NULL,NULL),(16,'209',2,1,1,'2023-10-21 09:24:19',1,'2023-10-21 09:24:35',0,NULL,NULL,NULL,NULL),(17,'210',2,1,1,'2023-10-21 09:24:47',1,'2023-10-21 09:28:37',0,NULL,NULL,NULL,NULL),(18,'211',2,1,1,'2023-10-21 09:25:16',1,'2023-10-21 09:25:29',0,NULL,NULL,NULL,NULL),(19,'212',2,1,1,'2023-10-21 09:25:41',1,'2023-10-21 09:25:55',0,NULL,NULL,NULL,NULL),(20,'213',2,1,1,'2023-10-21 09:26:02',1,'2023-10-21 09:26:20',0,NULL,NULL,NULL,NULL),(21,'214',2,1,1,'2023-10-21 09:26:27',1,'2023-10-21 09:26:45',0,NULL,NULL,NULL,NULL),(22,'215',4,1,1,'2023-10-21 09:27:07',1,'2023-10-21 09:27:34',0,NULL,NULL,NULL,NULL),(23,'301',2,1,1,'2023-10-21 09:28:50',1,'2023-10-21 09:29:04',0,NULL,NULL,NULL,NULL),(24,'302',2,1,1,'2023-10-21 09:29:11',1,'2023-10-21 09:29:25',0,NULL,NULL,NULL,NULL),(25,'303',2,1,1,'2023-10-21 09:29:37',1,'2023-10-21 09:29:52',0,NULL,NULL,NULL,NULL),(26,'304',2,1,1,'2023-10-21 09:30:13',1,'2023-10-21 09:30:26',0,NULL,NULL,NULL,NULL),(27,'305',2,1,1,'2023-10-21 09:30:34',1,'2023-10-21 09:31:00',0,NULL,NULL,NULL,NULL),(28,'306',2,1,1,'2023-10-21 09:31:07',1,'2023-10-21 09:34:49',0,NULL,NULL,NULL,NULL),(29,'307',2,1,1,'2023-10-21 09:31:12',1,'2023-10-21 09:34:33',0,NULL,NULL,NULL,NULL),(30,'308',2,1,1,'2023-10-21 09:31:17',1,'2023-10-21 09:34:19',0,NULL,NULL,NULL,NULL),(31,'309',2,1,1,'2023-10-21 09:31:22',1,'2023-10-21 09:34:02',0,NULL,NULL,NULL,NULL),(32,'310',2,1,1,'2023-10-21 09:31:28',1,'2023-10-21 09:33:48',0,NULL,NULL,NULL,NULL),(33,'311',2,1,1,'2023-10-21 09:31:34',1,'2023-10-21 09:33:35',0,NULL,NULL,NULL,NULL),(34,'312',2,1,1,'2023-10-21 09:31:41',1,'2023-10-21 09:33:21',0,NULL,NULL,NULL,NULL),(35,'313',2,1,1,'2023-10-21 09:31:50',1,'2023-10-21 09:33:09',0,NULL,NULL,NULL,NULL),(36,'314',2,1,1,'2023-10-21 09:32:07',1,'2023-10-21 09:32:56',0,NULL,NULL,NULL,NULL),(37,'315',4,1,1,'2023-10-21 09:32:20',1,'2023-10-21 09:32:43',0,NULL,NULL,NULL,NULL),(38,'216',0,5,1,'2023-10-21 09:35:14',NULL,NULL,0,NULL,NULL,NULL,NULL),(39,'217',0,5,1,'2023-10-21 09:35:31',NULL,NULL,0,NULL,NULL,NULL,NULL),(40,'218',0,5,1,'2023-10-21 09:35:39',NULL,NULL,0,NULL,NULL,NULL,NULL),(41,'219',0,5,1,'2023-10-21 09:35:45',1,'2023-10-21 10:16:55',0,NULL,NULL,NULL,NULL),(42,'餐厅',0,2,1,'2023-10-21 11:25:19',NULL,NULL,0,NULL,NULL,NULL,NULL),(43,'厨房1',0,3,1,'2023-10-21 11:25:34',NULL,NULL,0,NULL,NULL,NULL,NULL),(44,'厨房2',0,3,1,'2023-10-21 11:25:42',NULL,NULL,0,NULL,NULL,NULL,NULL),(45,'厨房3',0,3,1,'2023-10-21 11:25:51',NULL,NULL,0,NULL,NULL,NULL,NULL),(46,'活动室',0,4,1,'2023-10-21 11:26:07',NULL,NULL,0,NULL,NULL,NULL,NULL),(47,'档案室',0,6,1,'2023-11-03 14:57:32',NULL,NULL,0,NULL,NULL,NULL,NULL),(48,'消防室监控室',0,7,1,'2023-11-03 14:58:17',NULL,NULL,0,NULL,NULL,NULL,NULL),(49,'消防水泵房',0,7,1,'2023-11-03 14:58:30',NULL,NULL,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `bc_room` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bc_room_bed`
--
DROP TABLE IF EXISTS `bc_room_bed`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bc_room_bed` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) NOT NULL COMMENT '床位名称',
`room_id` bigint(20) NOT NULL COMMENT '房间id',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='房间床位表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bc_room_bed`
--
LOCK TABLES `bc_room_bed` WRITE;
/*!40000 ALTER TABLE `bc_room_bed` DISABLE KEYS */;
INSERT INTO `bc_room_bed` VALUES (5,'1床',1,1,'2023-09-14 22:24:14',1,'2023-09-15 19:21:53',1,1,'2023-10-21 09:04:47',NULL,NULL),(6,'2床',1,1,'2023-09-14 22:24:14',1,'2023-09-15 19:21:53',1,1,'2023-10-21 09:04:47',NULL,NULL),(7,'1床',4,1,'2023-09-14 23:15:52',1,'2023-09-15 19:21:45',1,1,'2023-10-21 09:04:48',NULL,'1床备注'),(8,'2床',4,1,'2023-09-14 23:15:52',1,'2023-09-15 19:21:45',1,1,'2023-10-21 09:04:48',NULL,'备注'),(9,'3床',1,1,'2023-09-15 19:21:53',NULL,NULL,1,1,'2023-10-21 09:04:47',NULL,NULL),(10,'101-1',5,1,'2023-10-21 09:18:11',NULL,NULL,0,NULL,NULL,NULL,NULL),(11,'101-2',5,1,'2023-10-21 09:18:11',NULL,NULL,0,NULL,NULL,NULL,NULL),(12,'102-1',6,1,'2023-10-21 09:18:55',NULL,NULL,0,NULL,NULL,NULL,NULL),(13,'102-2',6,1,'2023-10-21 09:18:55',NULL,NULL,0,NULL,NULL,NULL,NULL),(14,'103-1',7,1,'2023-10-21 09:19:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(15,'103-2',7,1,'2023-10-21 09:19:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(16,'103-3',7,1,'2023-10-21 09:19:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(17,'103-4',7,1,'2023-10-21 09:19:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(18,'201-1',8,1,'2023-10-21 09:20:10',NULL,NULL,0,NULL,NULL,NULL,NULL),(19,'201-2',8,1,'2023-10-21 09:20:10',NULL,NULL,0,NULL,NULL,NULL,NULL),(20,'202-1',9,1,'2023-10-21 09:21:05',NULL,NULL,0,NULL,NULL,NULL,NULL),(21,'202-2',9,1,'2023-10-21 09:21:05',NULL,NULL,0,NULL,NULL,NULL,NULL),(22,'203-1',10,1,'2023-10-21 09:22:07',NULL,NULL,0,NULL,NULL,NULL,NULL),(23,'203-2',10,1,'2023-10-21 09:22:07',NULL,NULL,0,NULL,NULL,NULL,NULL),(24,'204-1',11,1,'2023-10-21 09:22:26',NULL,NULL,0,NULL,NULL,NULL,NULL),(25,'204-2',11,1,'2023-10-21 09:22:26',NULL,NULL,0,NULL,NULL,NULL,NULL),(26,'205-1',12,1,'2023-10-21 09:22:49',NULL,NULL,0,NULL,NULL,NULL,NULL),(27,'205-2',12,1,'2023-10-21 09:22:49',NULL,NULL,0,NULL,NULL,NULL,NULL),(28,'206-1',13,1,'2023-10-21 09:23:09',NULL,NULL,0,NULL,NULL,NULL,NULL),(29,'206-2',13,1,'2023-10-21 09:23:09',NULL,NULL,0,NULL,NULL,NULL,NULL),(30,'207-1',14,1,'2023-10-21 09:23:33',NULL,NULL,0,NULL,NULL,NULL,NULL),(31,'207-2',14,1,'2023-10-21 09:23:33',NULL,NULL,0,NULL,NULL,NULL,NULL),(32,'208-1',15,1,'2023-10-21 09:24:04',NULL,NULL,0,NULL,NULL,NULL,NULL),(33,'208-2',15,1,'2023-10-21 09:24:04',NULL,NULL,0,NULL,NULL,NULL,NULL),(34,'209-1',16,1,'2023-10-21 09:24:35',NULL,NULL,0,NULL,NULL,NULL,NULL),(35,'209-2',16,1,'2023-10-21 09:24:35',NULL,NULL,0,NULL,NULL,NULL,NULL),(36,'210-1',17,1,'2023-10-21 09:25:09',1,'2023-10-21 09:28:37',0,NULL,NULL,NULL,NULL),(37,'210-2',17,1,'2023-10-21 09:25:09',1,'2023-10-21 09:28:37',0,NULL,NULL,NULL,NULL),(38,'211-1',18,1,'2023-10-21 09:25:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(39,'211-2',18,1,'2023-10-21 09:25:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(40,'212-1',19,1,'2023-10-21 09:25:55',NULL,NULL,0,NULL,NULL,NULL,NULL),(41,'212-2',19,1,'2023-10-21 09:25:55',NULL,NULL,0,NULL,NULL,NULL,NULL),(42,'213-1',20,1,'2023-10-21 09:26:20',NULL,NULL,0,NULL,NULL,NULL,NULL),(43,'213-2',20,1,'2023-10-21 09:26:20',NULL,NULL,0,NULL,NULL,NULL,NULL),(44,'214-1',21,1,'2023-10-21 09:26:45',NULL,NULL,0,NULL,NULL,NULL,NULL),(45,'214-2',21,1,'2023-10-21 09:26:45',NULL,NULL,0,NULL,NULL,NULL,NULL),(46,'215-1',22,1,'2023-10-21 09:27:34',NULL,NULL,0,NULL,NULL,NULL,NULL),(47,'215-2',22,1,'2023-10-21 09:27:34',NULL,NULL,0,NULL,NULL,NULL,NULL),(48,'215-3',22,1,'2023-10-21 09:27:34',NULL,NULL,0,NULL,NULL,NULL,NULL),(49,'215-4',22,1,'2023-10-21 09:27:34',NULL,NULL,0,NULL,NULL,NULL,NULL),(50,'301-1',23,1,'2023-10-21 09:29:04',NULL,NULL,0,NULL,NULL,NULL,NULL),(51,'301-2',23,1,'2023-10-21 09:29:04',NULL,NULL,0,NULL,NULL,NULL,NULL),(52,'302-1',24,1,'2023-10-21 09:29:25',NULL,NULL,0,NULL,NULL,NULL,NULL),(53,'302-2',24,1,'2023-10-21 09:29:25',NULL,NULL,0,NULL,NULL,NULL,NULL),(54,'303-1',25,1,'2023-10-21 09:29:52',NULL,NULL,0,NULL,NULL,NULL,NULL),(55,'303-2',25,1,'2023-10-21 09:29:52',NULL,NULL,0,NULL,NULL,NULL,NULL),(56,'304-1',26,1,'2023-10-21 09:30:26',NULL,NULL,0,NULL,NULL,NULL,NULL),(57,'304-2',26,1,'2023-10-21 09:30:26',NULL,NULL,0,NULL,NULL,NULL,NULL),(58,'305-1',27,1,'2023-10-21 09:31:00',NULL,NULL,0,NULL,NULL,NULL,NULL),(59,'302-2',27,1,'2023-10-21 09:31:
/*!40000 ALTER TABLE `bc_room_bed` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_data_dictionary`
--
DROP TABLE IF EXISTS `sys_data_dictionary`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_data_dictionary` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录序号',
`dictionary_code` varchar(64) NOT NULL COMMENT '词典标识(键)',
`dictionary_name` varchar(255) NOT NULL COMMENT '词典名称',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `dictionary_code_` (`dictionary_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统词典分类表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_data_dictionary`
--
LOCK TABLES `sys_data_dictionary` WRITE;
/*!40000 ALTER TABLE `sys_data_dictionary` DISABLE KEYS */;
INSERT INTO `sys_data_dictionary` VALUES (1,'0010','房间类型',1,'2023-05-30 16:00:58',NULL,NULL,0,NULL,NULL,NULL,NULL),(2,'0020','供养方式',1,'2023-09-13 16:42:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(3,'0030','婚姻状况',1,'2023-09-13 20:29:35',NULL,NULL,0,NULL,NULL,NULL,NULL),(4,'0040','村组',1,'2023-10-11 09:23:04',NULL,NULL,0,NULL,NULL,NULL,NULL),(5,'0021','护理登记',1,'2023-10-11 09:23:04',NULL,NULL,0,NULL,NULL,NULL,NULL),(6,'0050','岗位',1,'2023-10-17 11:21:29',NULL,NULL,0,NULL,NULL,NULL,NULL),(7,'0060','政治面貌',1,'2023-10-29 22:42:40',NULL,NULL,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `sys_data_dictionary` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_data_dictionary_item`
--
DROP TABLE IF EXISTS `sys_data_dictionary_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_data_dictionary_item` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录序号自增',
`dictionary_code` varchar(64) NOT NULL COMMENT '词典标识(键)',
`name` varchar(255) NOT NULL COMMENT '词典项目名称',
`value` int(11) NOT NULL COMMENT '词典项目值',
`parentid` int(11) NOT NULL DEFAULT '-1' COMMENT '所属上级值顶级默认-1',
`description` varchar(500) DEFAULT NULL COMMENT '备注说明',
`sortid` smallint(6) DEFAULT '1' COMMENT '显示顺序',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE,
KEY `dictionary_code_` (`dictionary_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统词典项表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_data_dictionary_item`
--
LOCK TABLES `sys_data_dictionary_item` WRITE;
/*!40000 ALTER TABLE `sys_data_dictionary_item` DISABLE KEYS */;
INSERT INTO `sys_data_dictionary_item` VALUES (1,'0011','工具房',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(2,'0011','客房',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(3,'0011','供养房',3,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(4,'0011','办公室',4,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(5,'0011','档案室',5,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(6,'0011','活动室',6,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(7,'0011','厨房',7,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(8,'0011','餐厅',8,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(9,'0020','集中供养',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(10,'0020','分散供养',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(11,'0030','未婚',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(12,'0030','已婚',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(13,'0030','离异',3,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(14,'0030','未知',99,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(15,'0010','供养房',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(16,'0010','餐厅',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(17,'0010','厨房',3,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(18,'0010','活动室',4,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(19,'0010','办公室',5,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(20,'0040','下堡坪村',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(21,'0040','蛟龙寺村',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(22,'0040','九山村',3,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(23,'0040','马宗岭村',4,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(24,'0040','赵勉河村',5,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(25,'0040','秀水村',6,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(26,'0040','磨坪村',7,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(27,'0040','十八湾村',8,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(28,'0021','一级护理（全失能）',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(29,'0021','二级护理（半失能）',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(30,'0021','三级护理（自 理）',3,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(31,'0050','院长',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(32,'0050','会计',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(33,'0050','安全员',3,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(34,'0050','护理员',4,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(35,'0050','厨师',5,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(36,'0060','党员',1,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(37,'0060','团员',2,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(38,'0060','群众',3,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(39,'0010','档案室',6,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(40,'0010','消防室',7,-1,NULL,1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `sys_data_dictionary_item` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_menu`
--
DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
`name` varchar(255) NOT NULL COMMENT '菜单名称',
`code` varchar(255) NOT NULL COMMENT '编码',
`int_code` int(11) NOT NULL COMMENT '顺序',
`pid` bigint(20) NOT NULL COMMENT '顶级菜单默认为-1',
`pids` text,
`type` int(11) DEFAULT NULL COMMENT '菜单类型（字典 0目录 1菜单 2按钮） 3-服务级(待定）',
`router` varchar(255) DEFAULT NULL COMMENT '菜单项的说明',
`component` varchar(255) DEFAULT NULL COMMENT '组件地址',
`permission` varchar(100) DEFAULT NULL COMMENT '权限标识',
`visible` int(11) DEFAULT '0' COMMENT '是否显示 1-是 0-否',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `idx_code` (`code`) USING BTREE,
KEY `idx_parentID` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=289 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统菜单表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_menu`
--
LOCK TABLES `sys_menu` WRITE;
/*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
INSERT INTO `sys_menu` VALUES (1,'数据字典管理','1',2,0,NULL,NULL,'数据字典管理',NULL,NULL,0,1,'2021-08-19 15:09:38',NULL,NULL,1,1,'2021-08-28 11:23:51','',NULL),(2,'权限管理','security_manage',1,0,'[0],',0,'/security','RouteView','',1,1,'2021-08-28 11:15:52',NULL,NULL,0,NULL,NULL,NULL,NULL),(3,'菜单管理','sys_menu_mgr',3,2,'[0],[2],',1,'/menu','security/menu/MenuList','',1,1,'2021-08-28 11:26:06',NULL,NULL,0,NULL,NULL,NULL,NULL),(4,'角色管理','sys_role_mgr',2,2,'[0],[2],',1,'/role','security/role/RoleList','',1,1,'2021-08-28 15:12:51',NULL,NULL,0,NULL,NULL,NULL,NULL),(5,'菜单新增','sys_menu_mgr_add',1,3,'[0],[2],[3],',2,'','','sys:menu:add',1,1,'2021-08-28 15:17:19',NULL,NULL,0,NULL,NULL,NULL,NULL),(6,'主控面板','system_index',1,0,'[0],',0,'/','RouteView','',1,1,'2021-09-01 15:52:08',NULL,NULL,1,NULL,NULL,NULL,NULL),(7,'工作台','system_index_workplace',1,6,'[0],[6],',1,'/workplace','dashboard/Workplace','',1,1,'2021-09-01 15:53:59',NULL,NULL,1,NULL,NULL,NULL,NULL),(8,'用户管理','sys_user_mgr',1,2,'[0],[2],',1,'/user2','security/user/UserList','',1,1,'2021-09-01 16:37:52',NULL,NULL,0,NULL,NULL,NULL,NULL),(9,'用户增加','sys_user_mgr_add',100,8,'[0],[2],[8],',2,'','','sys:user:add',1,1,'2021-09-01 16:38:44',NULL,NULL,0,NULL,NULL,NULL,NULL),(10,'角色新增','sys_role_mgr_add',100,4,'[0],[2],[4],',2,'','','sys:role:add',1,1,'2021-09-01 16:39:30',NULL,NULL,0,NULL,NULL,NULL,NULL),(13,'菜单编辑','sysMenu',100,3,'[0],[2],[3],',2,'','','sys:menu:edit',1,1,'2021-09-06 11:53:03',NULL,NULL,0,NULL,NULL,NULL,NULL),(14,'人员管理','person_mgr',40,0,'[0],',0,'/person','RouteView','',1,1,'2023-09-13 11:50:16',NULL,NULL,0,NULL,NULL,NULL,NULL),(15,'供养人员管理','person_support_mgr',10,14,'[0],[14],',1,'/person/support','person/SupportList','',1,1,'2023-09-13 12:04:27',NULL,NULL,0,NULL,NULL,NULL,NULL),(16,'服务人员管理','person_service_mgr',20,14,'[0],[14],',1,'/person/service','person/ServiceList','',1,1,'2023-09-13 12:05:34',NULL,NULL,0,NULL,NULL,NULL,NULL),(17,'医养结合护理人员','person_care_mgr',30,14,'[0],[14],',1,'/person/care','person/SupportList','',1,1,'2023-09-13 12:06:33',NULL,NULL,0,NULL,NULL,NULL,NULL),(18,'供养人员新增','support_add',100,14,'[0],[14],',1,'/person/support/add','person/SupportAdd','',0,1,'2023-09-13 15:07:22',NULL,NULL,0,NULL,NULL,NULL,NULL),(19,'供养人员详情','support_deatil',100,14,'[0],[14],',1,'/person/support/detail','person/SupportDetail','',0,1,'2023-09-13 15:08:09',NULL,NULL,0,NULL,NULL,NULL,NULL),(20,'服务人员新增','service_add',100,14,'[0],[14],',1,'/person/service/add','person/ServiceAdd','',0,1,'2023-09-13 15:08:09',NULL,NULL,0,NULL,NULL,NULL,NULL),(21,'服务人员详情','service_deatil',100,14,'[0],[14],',1,'/person/service/detail','person/ServiceDetail','',0,1,'2023-09-13 15:08:09',NULL,NULL,0,NULL,NULL,NULL,NULL),(22,'房间管理','room_mgr',30,0,'[0],',0,'/room','RouteView',NULL,1,1,'2023-09-15 19:38:31',NULL,NULL,0,NULL,NULL,NULL,NULL),(23,'房源管理','room_bed_mgr',30,22,'[0],[22],',1,'/room/list','room/RoomList','',1,1,'2023-09-14 22:06:42',NULL,NULL,0,NULL,NULL,NULL,NULL),(24,'入住管理','room_checkin_mgr',10,22,'[0],[22],',1,'/room/checkin','room/RoomCheckinList',NULL,1,1,'2023-09-15 19:38:31',NULL,NULL,0,NULL,NULL,NULL,NULL),(25,'退房管理','room_checkout_mgr',20,22,'[0],[22],',1,'/room/checkout','room/RoomCheckoutList',NULL,1,1,'2023-09-15 19:38:31',NULL,NULL,0,NULL,NULL,NULL,NULL),(26,'房间新增','room_add',100,22,'[0],[22],',1,'/room/add','room/RoomAdd','',0,1,'2023-09-14 22:08:44',NULL,NULL,0,NULL,NULL,NULL,NULL),(27,'房间详情','room_detail',100,22,'[0],[22],',1,'/room/detail','room/RoomDetail','',0,1,'2023-09-14 22:08:44',NULL,NULL,0,NULL,NULL,NULL,NULL),(28,'入住新增','room_checkin_add',100,22,'[0],[22],',1,'/room/checkin/add','room/RoomCheckinAdd','',0,1,'2023-09-13 15:07:22',NULL,NULL,0,NULL,NULL,NULL,NULL),(29,'入住详情','room_checkin_detail',100,22,'[0],[22],',1,'/room/checkin/detail','room/RoomCheckinDetail',NULL,0,1,'2023-09-13 15:07:22',NULL,NULL,0,NULL,NULL,NU
/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_oper_log`
--
DROP TABLE IF EXISTS `sys_oper_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_oper_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
`title` varchar(50) DEFAULT NULL COMMENT '模块标题',
`business_type` int(11) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
`method` varchar(512) DEFAULT NULL COMMENT '方法名称',
`request_method` varchar(10) DEFAULT NULL COMMENT '请求方式',
`operator_type` int(11) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
`oper_name` varchar(50) DEFAULT NULL COMMENT '操作人员',
`dept_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
`oper_url` varchar(255) DEFAULT NULL COMMENT '请求URL',
`oper_ip` varchar(50) DEFAULT NULL COMMENT '主机地址',
`oper_location` varchar(255) DEFAULT NULL COMMENT '操作地点',
`oper_param` varchar(2000) DEFAULT NULL COMMENT '请求参数',
`json_result` mediumtext COMMENT '返回参数',
`status` int(11) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
`error_msg` varchar(2000) DEFAULT NULL COMMENT '错误消息',
`oper_time` datetime DEFAULT NULL COMMENT '操作时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10880 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统操作日志';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_oper_log`
--
LOCK TABLES `sys_oper_log` WRITE;
/*!40000 ALTER TABLE `sys_oper_log` DISABLE KEYS */;
INSERT INTO `sys_oper_log` VALUES (1,'用户登陆',0,'/login','POST',0,'admin',NULL,NULL,'127.0.0.1','',NULL,NULL,1,'Chrome;Windows 10 or Windows Server 2016;登录用户：admin 不存在','2023-06-24 20:07:07'),(2,'登陆系统',11,'com.org.system.controller.SysLoginController.login()','POST',1,NULL,NULL,'/login','127.0.0.1',NULL,'{\"password\":\"Xm1122\",\"roleCode\":\"platform_manager\",\"username\":\"admin\"}','null',1,'登录用户：admin 不存在','2023-06-24 20:07:08'),(3,'用户登陆',0,'/login','POST',0,'admin',NULL,NULL,'127.0.0.1','',NULL,NULL,0,'Chrome;Windows 10 or Windows Server 2016;登陆成功','2023-09-13 11:40:56'),(4,'登陆系统',11,'com.org.system.controller.SysLoginController.login()','POST',1,NULL,NULL,'/login','127.0.0.1',NULL,'{\"password\":\"Xm1122\",\"roleCode\":\"student\",\"username\":\"admin\"}','null',1,'当前用户没有该角色','2023-09-13 11:40:58'),(5,'用户登陆',0,'/login','POST',0,'admin',NULL,NULL,'127.0.0.1','',NULL,NULL,0,'Chrome;Windows 10 or Windows Server 2016;登陆成功','2023-09-13 11:42:46'),(6,'登陆系统',11,'com.org.system.controller.SysLoginController.login()','POST',1,NULL,NULL,'/login','127.0.0.1',NULL,'{\"password\":\"Xm1122\",\"roleCode\":\"platform_manager\",\"username\":\"admin\"}','null',1,'当前用户没有该角色','2023-09-13 11:42:46'),(7,'用户登陆',0,'/login','POST',0,'admin',NULL,NULL,'127.0.0.1','',NULL,NULL,0,'Chrome;Windows 10 or Windows Server 2016;登陆成功','2023-09-13 11:44:43'),(8,'登陆系统',11,'com.org.system.controller.SysLoginController.login()','POST',1,NULL,NULL,'/login','127.0.0.1',NULL,'{\"password\":\"Xm1122\",\"roleCode\":\"platform_manager\",\"username\":\"admin\"}','{\"msg\":\"操作成功\",\"code\":200,\"token\":\"eyJhbGciOiJIUzUxMiJ9.eyJsb2dpbl91c2VyX2tleSI6ImM2MmQ1MGQ2LWYyM2EtNGZmNi05NjhlLWU5NWE5MzA2ZmY4YyJ9.8w_Jhp17VbSVls-vnu_g8lGKqinL7eBwanlu9UmTa2vDSKF7rC3cdtfExBA8QwtytFsyEumc8etk6jL0XVM1mQ\"}',0,NULL,'2023-09-13 11:44:46'),(9,'获取当前登录用户信息',11,'com.org.system.controller.SysLoginController.getLoginUser()','POST',1,'admin',NULL,'/getLoginUser','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"browser\":\"Chrome\",\"credentialsNonExpired\":true,\"currentRole\":{\"code\":\"platform_manager\",\"createBy\":1,\"createTime\":1686294353000,\"id\":2,\"isDelete\":0,\"name\":\"平台管理员\",\"parentId\":-1,\"remark\":\"test\",\"sort\":2,\"updateBy\":2,\"updateTime\":1687579524000},\"currentRoleCode\":\"platform_manager\",\"enabled\":true,\"expireTime\":1802576685817,\"ipaddr\":\"127.0.0.1\",\"loginLocation\":\"\",\"loginTime\":1694576685817,\"menus\":[{\"component\":\"RouteView\",\"hidden\":false,\"id\":2,\"meta\":{\"show\":true,\"title\":\"权限管理\"},\"name\":\"security_manage\",\"path\":\"/security\",\"pid\":0},{\"component\":\"security/user/UserList\",\"hidden\":false,\"id\":8,\"meta\":{\"show\":true,\"title\":\"用户管理\"},\"name\":\"sys_user_mgr\",\"path\":\"/user\",\"pid\":2},{\"component\":\"security/role/RoleList\",\"hidden\":false,\"id\":4,\"meta\":{\"show\":true,\"title\":\"角色管理\"},\"name\":\"sys_role_mgr\",\"path\":\"/role\",\"pid\":2},{\"component\":\"security/menu/MenuList\",\"hidden\":false,\"id\":3,\"meta\":{\"show\":true,\"title\":\"菜单管理\"},\"name\":\"sys_menu_mgr\",\"path\":\"/menu\",\"pid\":2}],\"name\":\"超级管理员\",\"os\":\"Windows 10 or Windows Server 2016\",\"password\":\"789f753f1942350ff7502f73db0668c2\",\"permissions\":[\"*:*:*\"],\"roleList\":[{\"$ref\":\"$.data.currentRole\"},{\"code\":\"service_user\",\"id\":3,\"isDelete\":0,\"name\":\"服务人员\",\"parentId\":-1,\"sort\":3},{\"code\":\"support_user\",\"id\":4,\"isDelete\":0,\"name\":\"供养人员\",\"parentId\":-1,\"sort\":4},{\"code\":\"tend_user\",\"id\":5,\"isDelete\":0,\"name\":\"医养结合护理人员\",\"parentId\":-1,\"sort\":5}],\"token\":\"c62d50d6-f23a-4ff6-968e-e95a9306ff8c\",\"user\":{\"age\":2020,\"email\":\"1\",\"id\":1,\"idCardNo\":\"000000000000000000\",\"isDelete\":0,\"loginCount\":128,\
INSERT INTO `sys_oper_log` VALUES (914,'服务人员新增/编辑',1,'com.org.web.person.controller.BcPersonServiceController.add()','POST',1,'admin',NULL,'/person/service/addOrUpdate','127.0.0.1',NULL,'{\"nation\":\"汉\",\"idCardNo\":\"500235199901110032\",\"certificate\":\"获得证书\\n\",\"updateBy\":1,\"punish\":\"据报道，这起盗窃事件发生在德国科隆的一家享有声誉的东亚艺术博物馆。博物馆工作人员在当天发现展览空间的瓷器陈列区域被盗，失窃的文物包括了9件中国明清时代制造的珍贵瓷器，其中包括花瓶、瓷盘和瓷罐等。这些被盗文物的估计价值超过100万欧元，其艺术和历史价值无法估量。\\n\\n盗窃事件引起了博物馆和警方的高度关注。警方立即展开调查，并正在分析监控录像和相关线索，以期尽快找到并追回被盗文物。博物馆方面也呼吁公众提供任何可能的信息，以协助警方解决这一案件。\\n\\n这些被盗的中国明清时期瓷器是具有极高历史和文化价值的艺术品。明清时期的中国瓷器以其精湛的工艺和独特的美学风格而闻名于世。这些瓷器作品不仅代表了中国古代陶瓷艺术的巅峰之作，同时也记录了当时的社会、经济和文化背景。\",\"id\":12,\"train\":\"据报道，这起盗窃事件发生在德国科隆的一家享有声誉的东亚艺术博物馆。博物馆工作人员在当天发现展览空间的瓷器陈列区域被盗，失窃的文物包括了9件中国明清时代制造的珍贵瓷器，其中包括花瓶、瓷盘和瓷罐等。这些被盗文物的估计价值超过100万欧元，其艺术和历史价值无法估量。\\n\\n盗窃事件引起了博物馆和警方的高度关注。警方立即展开调查，并正在分析监控录像和相关线索，以期尽快找到并追回被盗文物。博物馆方面也呼吁公众提供任何可能的信息，以协助警方解决这一案件。\\n\\n这些被盗的中国明清时期瓷器是具有极高历史和文化价值的艺术品。明清时期的中国瓷器以其精湛的工艺和独特的美学风格而闻名于世。这些瓷器作品不仅代表了中国古代陶瓷艺术的巅峰之作，同时也记录了当时的社会、经济和文化背景。\",\"isDelete\":0,\"jobs\":\"岗位\",\"sex\":1,\"health\":\"身体状况\",\"updateTime\":1694777603412,\"diseaseHistory\":\"疾病史\",\"createTime\":1694693866000,\"phone\":\"13872577251\",\"awards\":\"据报道，这起盗窃事件发生在德国科隆的一家享有声誉的东亚艺术博物馆。博物馆工作人员在当天发现展览空间的瓷器陈列区域被盗，失窃的文物包括了9件中国明清时代制造的珍贵瓷器，其中包括花瓶、瓷盘和瓷罐等。这些被盗文物的估计价值超过100万欧元，其艺术和历史价值无法估量。\\n\\n盗窃事件引起了博物馆和警方的高度关注。警方立即展开调查，并正在分析监控录像和相关线索，以期尽快找到并追回被盗文物。博物馆方面也呼吁公众提供任何可能的信息，以协助警方解决这一案件。\\n\\n这些被盗的中国明清时期瓷器是具有极高历史和文化价值的艺术品。明清时期的中国瓷器以其精湛的工艺和独特的美学风格而闻名于世。这些瓷器作品不仅代表了中国古代陶瓷艺术的巅峰之作，同时也记录了当时的社会、经济和文化背景。\",\"name\":\"张三三\",\"nativePlace\":\"湖北宜昌\",\"familyList\":[{\"isDelete\":0,\"createBy\":1,\"createTime\":1694777603439,\"familyName\":\"张三\",\"personId\":12,\"id\":14},{\"isDelete\":0,\"createBy\":1,\"createTime\":1694777603439,\"familyName\":\"力生物\",\"personId\":12,\"id\":15}],\"maritalStatus\":1}','{\"msg\":\"操作成功\",\"code\":200,\"data\":true}',0,NULL,'2023-09-15 19:33:24'),(915,'服务人员列表查询',4,'com.org.web.person.controller.BcPersonServiceController.list()','GET',1,'admin',NULL,'/person/service/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成<E8AFA2>
INSERT INTO `sys_oper_log` VALUES (1368,'获取当前登录用户信息',11,'com.org.system.controller.SysLoginController.getLoginUser()','POST',1,'admin',NULL,'/getLoginUser','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"browser\":\"Chrome\",\"credentialsNonExpired\":true,\"currentRole\":{\"code\":\"platform_manager\",\"createBy\":1,\"createTime\":1686294353000,\"id\":2,\"isDelete\":0,\"name\":\"平台管理员\",\"parentId\":-1,\"remark\":\"test\",\"sort\":2,\"updateBy\":2,\"updateTime\":1687579524000},\"currentRoleCode\":\"platform_manager\",\"enabled\":true,\"expireTime\":1802966711814,\"ipaddr\":\"127.0.0.1\",\"loginLocation\":\"\",\"loginTime\":1694966711814,\"menus\":[{\"component\":\"RouteView\",\"hidden\":false,\"id\":2,\"meta\":{\"show\":true,\"title\":\"权限管理\"},\"name\":\"security_manage\",\"path\":\"/security\",\"pid\":0},{\"component\":\"security/user/UserList\",\"hidden\":false,\"id\":8,\"meta\":{\"show\":true,\"title\":\"用户管理\"},\"name\":\"sys_user_mgr\",\"path\":\"/user\",\"pid\":2},{\"component\":\"security/role/RoleList\",\"hidden\":false,\"id\":4,\"meta\":{\"show\":true,\"title\":\"角色管理\"},\"name\":\"sys_role_mgr\",\"path\":\"/role\",\"pid\":2},{\"component\":\"security/menu/MenuList\",\"hidden\":false,\"id\":3,\"meta\":{\"show\":true,\"title\":\"菜单管理\"},\"name\":\"sys_menu_mgr\",\"path\":\"/menu\",\"pid\":2},{\"component\":\"RouteView\",\"hidden\":false,\"id\":14,\"meta\":{\"show\":true,\"title\":\"人员管理\"},\"name\":\"person_mgr\",\"path\":\"/person\",\"pid\":0},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":15,\"meta\":{\"show\":true,\"title\":\"供养人员管理\"},\"name\":\"person_support_mgr\",\"path\":\"/person/support\",\"pid\":14},{\"component\":\"person/ServiceList\",\"hidden\":false,\"id\":16,\"meta\":{\"show\":true,\"title\":\"服务人员管理\"},\"name\":\"person_service_mgr\",\"path\":\"/person/service\",\"pid\":14},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":17,\"meta\":{\"show\":true,\"title\":\"医养结合护理人员\"},\"name\":\"person_care_mgr\",\"path\":\"/person/care\",\"pid\":14},{\"component\":\"person/SupportAdd\",\"hidden\":false,\"id\":18,\"meta\":{\"show\":false,\"title\":\"供养人员新增\"},\"name\":\"support_add\",\"path\":\"/person/support/add\",\"pid\":14},{\"component\":\"person/SupportDetail\",\"hidden\":false,\"id\":19,\"meta\":{\"show\":false,\"title\":\"供养人员详情\"},\"name\":\"support_deatil\",\"path\":\"/person/support/detail\",\"pid\":14},{\"component\":\"person/ServiceAdd\",\"hidden\":false,\"id\":20,\"meta\":{\"show\":false,\"title\":\"服务人员新增\"},\"name\":\"service_add\",\"path\":\"/person/service/add\",\"pid\":14},{\"component\":\"person/ServiceDetail\",\"hidden\":false,\"id\":21,\"meta\":{\"show\":false,\"title\":\"服务人员详情\"},\"name\":\"service_deatil\",\"path\":\"/person/service/detail\",\"pid\":14},{\"component\":\"RouteView\",\"hidden\":false,\"id\":22,\"meta\":{\"show\":true,\"title\":\"房间管理\"},\"name\":\"room_mgr\",\"path\":\"/room\",\"pid\":0},{\"component\":\"room/RoomList\",\"hidden\":false,\"id\":23,\"meta\":{\"show\":true,\"title\":\"房源管理\"},\"name\":\"room_bed_mgr\",\"path\":\"/room/list\",\"pid\":22},{\"component\":\"room/RoomCheckinList\",\"hidden\":false,\"id\":24,\"meta\":{\"show\":true,\"title\":\"入住管理\"},\"name\":\"room_checkin_mgr\",\"path\":\"/room/checkin\",\"pid\":22},{\"component\":\"room/RoomCheckoutList\",\"hidden\":false,\"id\":25,\"meta\":{\"show\":true,\"title\":\"退房管理\"},\"name\":\"room_checkout_mgr\",\"path\":\"/room/checkout\",\"pid\":22},{\"component\":\"room/RoomAdd\",\"hidden\":false,\"id\":26,\"meta\":{\"show\":false,\"title\":\"房间新增\"},\"name\":\"room_add\",\"path\":\"/room/add\",\"pid\":22},{\"component\":\"room/RoomDetail\",\"hidden\":false,\"id\":27,\"meta\":{\"show\":false,\"title\":\"房间详情\"},\"name\":\"room_detail\",\"path\":\"/room/detail\",\"pid\":22},{\"component\":\"room/RoomChecki
INSERT INTO `sys_oper_log` VALUES (1620,'获取当前登录用户信息',11,'com.org.system.controller.SysLoginController.getLoginUser()','POST',1,'admin',NULL,'/getLoginUser','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"browser\":\"Chrome\",\"credentialsNonExpired\":true,\"currentRole\":{\"code\":\"platform_manager\",\"createBy\":1,\"createTime\":1686294353000,\"id\":2,\"isDelete\":0,\"name\":\"平台管理员\",\"parentId\":-1,\"remark\":\"test\",\"sort\":2,\"updateBy\":2,\"updateTime\":1687579524000},\"currentRoleCode\":\"platform_manager\",\"enabled\":true,\"expireTime\":1804945606655,\"ipaddr\":\"127.0.0.1\",\"loginLocation\":\"\",\"loginTime\":1696945606655,\"menus\":[{\"component\":\"RouteView\",\"hidden\":false,\"id\":2,\"meta\":{\"show\":true,\"title\":\"权限管理\"},\"name\":\"security_manage\",\"path\":\"/security\",\"pid\":0},{\"component\":\"security/user/UserList\",\"hidden\":false,\"id\":8,\"meta\":{\"show\":true,\"title\":\"用户管理\"},\"name\":\"sys_user_mgr\",\"path\":\"/user\",\"pid\":2},{\"component\":\"security/role/RoleList\",\"hidden\":false,\"id\":4,\"meta\":{\"show\":true,\"title\":\"角色管理\"},\"name\":\"sys_role_mgr\",\"path\":\"/role\",\"pid\":2},{\"component\":\"security/menu/MenuList\",\"hidden\":false,\"id\":3,\"meta\":{\"show\":true,\"title\":\"菜单管理\"},\"name\":\"sys_menu_mgr\",\"path\":\"/menu\",\"pid\":2},{\"component\":\"RouteView\",\"hidden\":false,\"id\":14,\"meta\":{\"show\":true,\"title\":\"人员管理\"},\"name\":\"person_mgr\",\"path\":\"/person\",\"pid\":0},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":15,\"meta\":{\"show\":true,\"title\":\"供养人员管理\"},\"name\":\"person_support_mgr\",\"path\":\"/person/support\",\"pid\":14},{\"component\":\"person/ServiceList\",\"hidden\":false,\"id\":16,\"meta\":{\"show\":true,\"title\":\"服务人员管理\"},\"name\":\"person_service_mgr\",\"path\":\"/person/service\",\"pid\":14},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":17,\"meta\":{\"show\":true,\"title\":\"医养结合护理人员\"},\"name\":\"person_care_mgr\",\"path\":\"/person/care\",\"pid\":14},{\"component\":\"person/SupportAdd\",\"hidden\":false,\"id\":18,\"meta\":{\"show\":false,\"title\":\"供养人员新增\"},\"name\":\"support_add\",\"path\":\"/person/support/add\",\"pid\":14},{\"component\":\"person/SupportDetail\",\"hidden\":false,\"id\":19,\"meta\":{\"show\":false,\"title\":\"供养人员详情\"},\"name\":\"support_deatil\",\"path\":\"/person/support/detail\",\"pid\":14},{\"component\":\"person/ServiceAdd\",\"hidden\":false,\"id\":20,\"meta\":{\"show\":false,\"title\":\"服务人员新增\"},\"name\":\"service_add\",\"path\":\"/person/service/add\",\"pid\":14},{\"component\":\"person/ServiceDetail\",\"hidden\":false,\"id\":21,\"meta\":{\"show\":false,\"title\":\"服务人员详情\"},\"name\":\"service_deatil\",\"path\":\"/person/service/detail\",\"pid\":14},{\"component\":\"RouteView\",\"hidden\":false,\"id\":22,\"meta\":{\"show\":true,\"title\":\"房间管理\"},\"name\":\"room_mgr\",\"path\":\"/room\",\"pid\":0},{\"component\":\"room/RoomList\",\"hidden\":false,\"id\":23,\"meta\":{\"show\":true,\"title\":\"房源管理\"},\"name\":\"room_bed_mgr\",\"path\":\"/room/list\",\"pid\":22},{\"component\":\"room/RoomCheckinList\",\"hidden\":false,\"id\":24,\"meta\":{\"show\":true,\"title\":\"入住管理\"},\"name\":\"room_checkin_mgr\",\"path\":\"/room/checkin\",\"pid\":22},{\"component\":\"room/RoomCheckoutList\",\"hidden\":false,\"id\":25,\"meta\":{\"show\":true,\"title\":\"退房管理\"},\"name\":\"room_checkout_mgr\",\"path\":\"/room/checkout\",\"pid\":22},{\"component\":\"room/RoomAdd\",\"hidden\":false,\"id\":26,\"meta\":{\"show\":false,\"title\":\"房间新增\"},\"name\":\"room_add\",\"path\":\"/room/add\",\"pid\":22},{\"component\":\"room/RoomDetail\",\"hidden\":false,\"id\":27,\"meta\":{\"show\":false,\"title\":\"房间详情\"},\"name\":\"room_detail\",\"path\":\"/room/detail\",\"pid\":22},{\"component\":\"room/RoomChecki
INSERT INTO `sys_oper_log` VALUES (1896,'获取当前登录用户信息',11,'com.org.system.controller.SysLoginController.getLoginUser()','POST',1,'admin',NULL,'/getLoginUser','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"browser\":\"Chrome\",\"credentialsNonExpired\":true,\"currentRole\":{\"code\":\"platform_manager\",\"createBy\":1,\"createTime\":1686294353000,\"id\":2,\"isDelete\":0,\"name\":\"平台管理员\",\"parentId\":-1,\"remark\":\"test\",\"sort\":2,\"updateBy\":2,\"updateTime\":1687579524000},\"currentRoleCode\":\"platform_manager\",\"enabled\":true,\"expireTime\":1804955978289,\"ipaddr\":\"127.0.0.1\",\"loginLocation\":\"\",\"loginTime\":1696955978289,\"menus\":[{\"component\":\"RouteView\",\"hidden\":false,\"id\":2,\"meta\":{\"show\":true,\"title\":\"权限管理\"},\"name\":\"security_manage\",\"path\":\"/security\",\"pid\":0},{\"component\":\"security/user/UserList\",\"hidden\":false,\"id\":8,\"meta\":{\"show\":true,\"title\":\"用户管理\"},\"name\":\"sys_user_mgr\",\"path\":\"/user2\",\"pid\":2},{\"component\":\"security/role/RoleList\",\"hidden\":false,\"id\":4,\"meta\":{\"show\":true,\"title\":\"角色管理\"},\"name\":\"sys_role_mgr\",\"path\":\"/role\",\"pid\":2},{\"component\":\"security/menu/MenuList\",\"hidden\":false,\"id\":3,\"meta\":{\"show\":true,\"title\":\"菜单管理\"},\"name\":\"sys_menu_mgr\",\"path\":\"/menu\",\"pid\":2},{\"component\":\"RouteView\",\"hidden\":false,\"id\":14,\"meta\":{\"show\":true,\"title\":\"人员管理\"},\"name\":\"person_mgr\",\"path\":\"/person\",\"pid\":0},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":15,\"meta\":{\"show\":true,\"title\":\"供养人员管理\"},\"name\":\"person_support_mgr\",\"path\":\"/person/support\",\"pid\":14},{\"component\":\"person/ServiceList\",\"hidden\":false,\"id\":16,\"meta\":{\"show\":true,\"title\":\"服务人员管理\"},\"name\":\"person_service_mgr\",\"path\":\"/person/service\",\"pid\":14},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":17,\"meta\":{\"show\":true,\"title\":\"医养结合护理人员\"},\"name\":\"person_care_mgr\",\"path\":\"/person/care\",\"pid\":14},{\"component\":\"person/SupportAdd\",\"hidden\":false,\"id\":18,\"meta\":{\"show\":false,\"title\":\"供养人员新增\"},\"name\":\"support_add\",\"path\":\"/person/support/add\",\"pid\":14},{\"component\":\"person/SupportDetail\",\"hidden\":false,\"id\":19,\"meta\":{\"show\":false,\"title\":\"供养人员详情\"},\"name\":\"support_deatil\",\"path\":\"/person/support/detail\",\"pid\":14},{\"component\":\"person/ServiceAdd\",\"hidden\":false,\"id\":20,\"meta\":{\"show\":false,\"title\":\"服务人员新增\"},\"name\":\"service_add\",\"path\":\"/person/service/add\",\"pid\":14},{\"component\":\"person/ServiceDetail\",\"hidden\":false,\"id\":21,\"meta\":{\"show\":false,\"title\":\"服务人员详情\"},\"name\":\"service_deatil\",\"path\":\"/person/service/detail\",\"pid\":14},{\"component\":\"RouteView\",\"hidden\":false,\"id\":22,\"meta\":{\"show\":true,\"title\":\"房间管理\"},\"name\":\"room_mgr\",\"path\":\"/room\",\"pid\":0},{\"component\":\"room/RoomList\",\"hidden\":false,\"id\":23,\"meta\":{\"show\":true,\"title\":\"房源管理\"},\"name\":\"room_bed_mgr\",\"path\":\"/room/list\",\"pid\":22},{\"component\":\"room/RoomCheckinList\",\"hidden\":false,\"id\":24,\"meta\":{\"show\":true,\"title\":\"入住管理\"},\"name\":\"room_checkin_mgr\",\"path\":\"/room/checkin\",\"pid\":22},{\"component\":\"room/RoomCheckoutList\",\"hidden\":false,\"id\":25,\"meta\":{\"show\":true,\"title\":\"退房管理\"},\"name\":\"room_checkout_mgr\",\"path\":\"/room/checkout\",\"pid\":22},{\"component\":\"room/RoomAdd\",\"hidden\":false,\"id\":26,\"meta\":{\"show\":false,\"title\":\"房间新增\"},\"name\":\"room_add\",\"path\":\"/room/add\",\"pid\":22},{\"component\":\"room/RoomDetail\",\"hidden\":false,\"id\":27,\"meta\":{\"show\":false,\"title\":\"房间详情\"},\"name\":\"room_detail\",\"path\":\"/room/detail\",\"pid\":22},{\"component\":\"room/RoomCheck
INSERT INTO `sys_oper_log` VALUES (2409,'获取当前登录用户信息',11,'com.org.system.controller.SysLoginController.getLoginUser()','POST',1,'admin',NULL,'/getLoginUser','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"browser\":\"Chrome\",\"credentialsNonExpired\":true,\"currentRole\":{\"code\":\"platform_manager\",\"createBy\":1,\"createTime\":1686294353000,\"id\":2,\"isDelete\":0,\"name\":\"平台管理员\",\"parentId\":-1,\"remark\":\"test\",\"sort\":2,\"updateBy\":2,\"updateTime\":1687579524000},\"currentRoleCode\":\"platform_manager\",\"enabled\":true,\"expireTime\":1805597441979,\"ipaddr\":\"127.0.0.1\",\"loginLocation\":\"\",\"loginTime\":1697597441979,\"menus\":[{\"component\":\"RouteView\",\"hidden\":false,\"id\":2,\"meta\":{\"show\":true,\"title\":\"权限管理\"},\"name\":\"security_manage\",\"path\":\"/security\",\"pid\":0},{\"component\":\"security/user/UserList\",\"hidden\":false,\"id\":8,\"meta\":{\"show\":true,\"title\":\"用户管理\"},\"name\":\"sys_user_mgr\",\"path\":\"/user2\",\"pid\":2},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":279,\"meta\":{\"show\":true,\"title\":\"用药管理\"},\"name\":\"ylfw_yygl\",\"path\":\"/ylfw_yygl\",\"pid\":278},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":284,\"meta\":{\"show\":true,\"title\":\"人员定位\"},\"name\":\"aqld_rydw\",\"path\":\"/developing\",\"pid\":283},{\"component\":\"security/role/RoleList\",\"hidden\":false,\"id\":4,\"meta\":{\"show\":true,\"title\":\"角色管理\"},\"name\":\"sys_role_mgr\",\"path\":\"/role\",\"pid\":2},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":280,\"meta\":{\"show\":true,\"title\":\"餐饮管理\"},\"name\":\"ylfw_cygl\",\"path\":\"/ylfw_cygl\",\"pid\":278},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":285,\"meta\":{\"show\":true,\"title\":\"报警处理\"},\"name\":\"aqld_bjcl\",\"path\":\"/developing\",\"pid\":283},{\"component\":\"security/menu/MenuList\",\"hidden\":false,\"id\":3,\"meta\":{\"show\":true,\"title\":\"菜单管理\"},\"name\":\"sys_menu_mgr\",\"path\":\"/menu\",\"pid\":2},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":286,\"meta\":{\"show\":true,\"title\":\"健康检查\"},\"name\":\"aqld_jkjc\",\"path\":\"/developing\",\"pid\":283},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":281,\"meta\":{\"show\":true,\"title\":\"健康评估\"},\"name\":\"ylfw_jkpg\",\"path\":\"/ylfw_jkpg\",\"pid\":278},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":287,\"meta\":{\"show\":true,\"title\":\"床边检测\"},\"name\":\"aqld_cbjc\",\"path\":\"/developing\",\"pid\":283},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":282,\"meta\":{\"show\":true,\"title\":\"亲情关爱\"},\"name\":\"ylfw_qqga\",\"path\":\"/ylfw_qqga\",\"pid\":278},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":15,\"meta\":{\"show\":true,\"title\":\"供养人员管理\"},\"name\":\"person_support_mgr\",\"path\":\"/person/support\",\"pid\":14},{\"component\":\"room/RoomCheckinList\",\"hidden\":false,\"id\":24,\"meta\":{\"show\":true,\"title\":\"入住管理\"},\"name\":\"room_checkin_mgr\",\"path\":\"/room/checkin\",\"pid\":22},{\"component\":\"person/ServiceList\",\"hidden\":false,\"id\":16,\"meta\":{\"show\":true,\"title\":\"服务人员管理\"},\"name\":\"person_service_mgr\",\"path\":\"/person/service\",\"pid\":14},{\"component\":\"bigScreen/index\",\"hidden\":false,\"id\":273,\"meta\":{\"show\":true,\"title\":\"数据统计\"},\"name\":\"data2\",\"path\":\"/screen/data2\",\"pid\":0},{\"component\":\"room/RoomCheckoutList\",\"hidden\":false,\"id\":25,\"meta\":{\"show\":true,\"title\":\"退房管理\"},\"name\":\"room_checkout_mgr\",\"path\":\"/room/checkout\",\"pid\":22},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":17,\"meta\":{\"show\":true,\"title\":\"医养结合护理人员\"},\"name\":\"person_care_mgr\",\"path\":\"/person/care\",\"pid\":14},{\"component\":\"room/RoomList\",\"hidden\":false,
INSERT INTO `sys_oper_log` VALUES (2823,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[{\"age\":36,\"bringTime\":1325347200000,\"createTime\":1697707503000,\"familyList\":[],\"id\":19,\"idCardNo\":\"420521198706274710\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"汪振扬\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"八组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"village\":1,\"villageName\":\"下堡坪村\"},{\"age\":84,\"bringTime\":1104508800000,\"createTime\":1697707455000,\"familyList\":[],\"id\":18,\"idCardNo\":\"422721193810264715\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"张绿祥\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"village\":1,\"villageName\":\"下堡坪村\"},{\"age\":67,\"bringTime\":1167580800000,\"createTime\":1697707398000,\"familyList\":[],\"id\":17,\"idCardNo\":\"422721195610184736\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"黄士树\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"village\":1,\"villageName\":\"下堡坪村\"},{\"age\":62,\"bringTime\":1696953600000,\"createTime\":1697032382000,\"familyList\":[],\"id\":16,\"idCardNo\":\"420500196108123716\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":1,\"maritalStatus\":2,\"name\":\"钱琦\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"一组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1697032498000,\"village\":2,\"villageName\":\"蛟龙寺村\"},{\"age\":24,\"createTime\":1694597810000,\"familyList\":[],\"id\":8,\"idCardNo\":\"500235199908273737\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":1,\"maritalStatus\":3,\"name\":\"张三\",\"nursingLevel\":1,\"nursingLevelName\":\"一级护理（全失能）\",\"phone\":\"\",\"residenceAddress\":\"测试\",\"roomBed\":\"101室3床\",\"selfCare\":\"测试\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1697528749000,\"village\":1,\"villageName\":\"下堡坪村\"},{\"age\":24,\"bringTime\":1694534400000,\"disabilityLevel\":\"测试残疾等级\",\"familyList\":[],\"hardshipAllowanceBasic\":15000.00,\"hardshipAllowanceCare\":16000.00,\"hardshipAllowanceTotal\":31000.00,\"id\":2,\"idCardNo\":\"420500199901110011\",\"ifDisabled\":1,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":1,\"maritalStatus\":3,\"name\":\"屈小丽\",\"phone\":\"13872572250\",\"residenceAddress\":\"重庆\",\"residenceVillage\":\"村\",\"roomBed\":\"102室2床\",\"selfCare\":\"111\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1694704448000}],\"total\":6}',0,NULL,'2023-10-19 17:43:04'),(2824,'荣誉橱窗展示详情',4,'com.org.web.honor.controller.BcHonorShowController.detail()','POST',1,'admin',NULL,'/honor/show/detail','127.0.0.1',NULL,'{\"id\":3}','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"content\":\"<section data-role=\\\"paragraph\\\" style=\\\"margin: 0px; padding: 0px; outline: 0px; max-width: 100%; color: rgba(0, 0, 0, 0.9); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; letter-s
INSERT INTO `sys_oper_log` VALUES (3531,'房间列表查询',4,'com.org.web.room.controller.BcRoomController.list()','GET',1,'admin',NULL,'/room/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":3,\"rows\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851813000,\"id\":26,\"isDelete\":0,\"name\":\"304\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697851826000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851834000,\"id\":27,\"isDelete\":0,\"name\":\"305\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697851860000},{\"bedNumber\":0,\"createBy\":1,\"createTime\":1697851867000,\"id\":28,\"isDelete\":0,\"name\":\"306\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\"},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851872000,\"id\":29,\"isDelete\":0,\"name\":\"307\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697852073000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851877000,\"id\":30,\"isDelete\":0,\"name\":\"308\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697852059000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851882000,\"id\":31,\"isDelete\":0,\"name\":\"309\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697852042000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851888000,\"id\":32,\"isDelete\":0,\"name\":\"310\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697852028000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851894000,\"id\":33,\"isDelete\":0,\"name\":\"311\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697852015000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851901000,\"id\":34,\"isDelete\":0,\"name\":\"312\",\"roomBedList\":[],\"roomType\":1,\"roomTypeName\":\"供养房\",\"updateBy\":1,\"updateTime\":1697852001000}],\"total\":33}',0,NULL,'2023-10-21 09:34:35'),(3532,'房间详情',4,'com.org.web.room.controller.BcRoomController.detail()','POST',1,'admin',NULL,'/room/detail','127.0.0.1',NULL,'{\"id\":28}','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"bedNumber\":0,\"createBy\":1,\"createTime\":1697851867000,\"id\":28,\"isDelete\":0,\"name\":\"306\",\"roomBedList\":[],\"roomType\":1}}',0,NULL,'2023-10-21 09:34:39'),(3533,'词典项下拉选',4,'com.org.system.controller.SysDataDictionaryItemController.dropDown()','GET',1,'admin',NULL,'/sys/dictionary/item/dropDown','127.0.0.1',NULL,'{}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"id\":15,\"name\":\"供养房\",\"value\":1,\"parentid\":-1},{\"id\":16,\"name\":\"餐厅\",\"value\":2,\"parentid\":-1},{\"id\":17,\"name\":\"厨房\",\"value\":3,\"parentid\":-1},{\"id\":18,\"name\":\"活动室\",\"value\":4,\"parentid\":-1},{\"id\":19,\"name\":\"办公室\",\"value\":5,\"parentid\":-1}]}',0,NULL,'2023-10-21 09:34:39'),(3534,'房间新增/编辑',1,'com.org.web.room.controller.BcRoomController.addOrUpdate()','POST',1,'admin',NULL,'/room/addOrUpdate','127.0.0.1',NULL,'{\"isDelete\":0,\"updateTime\":1697852088814,\"roomBedList\":[{\"createBy\":1,\"createTime\":1697852088815,\"isDelete\":0,\"name\":\"306-1\",\"id\":80,\"roomId\":28},{\"createBy\":1,\"createTime\":1697852088815,\"isDelete\":0,\"name\":\"303-2\",\"id\":81,\"roomId\":28}],\"createBy\":1,\"createTime\":1697851867000,\"updateBy\":1,\"name\":\"306\",\"id\":28,\"bedNumber\":2,\"roomType\":1}','{\"msg\":\"操作成功\",\"code\":200,\"data\":true}',0,NULL,'2023-10-21 09:34:49'),(3535,'词典项下拉选',4,'com.org.system.controller.SysDataDictionaryItemController.dropDown()','GET',1,'admin',NULL,'/sys/dictionary/item/dropDown','127.0.0.1',NU
INSERT INTO `sys_oper_log` VALUES (3941,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,\"createBy\":1,\"createTi
INSERT INTO `sys_oper_log` VALUES (4296,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,\"createBy\":1,\"createTi
INSERT INTO `sys_oper_log` VALUES (4629,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllBed()','POST',1,'admin',NULL,'/room/listAllBed','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"createBy\":1,\"createTime\":1697851091000,\"id\":10,\"isDelete\":0,\"name\":\"101-1\",\"roomId\":5},{\"createBy\":1,\"createTime\":1697851091000,\"id\":11,\"isDelete\":0,\"name\":\"101-2\",\"roomId\":5},{\"createBy\":1,\"createTime\":1697851135000,\"id\":12,\"isDelete\":0,\"name\":\"102-1\",\"roomId\":6},{\"createBy\":1,\"createTime\":1697851135000,\"id\":13,\"isDelete\":0,\"name\":\"102-2\",\"roomId\":6},{\"createBy\":1,\"createTime\":1697851169000,\"id\":14,\"isDelete\":0,\"name\":\"103-1\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":15,\"isDelete\":0,\"name\":\"103-2\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":16,\"isDelete\":0,\"name\":\"103-3\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":17,\"isDelete\":0,\"name\":\"103-4\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851210000,\"id\":18,\"isDelete\":0,\"name\":\"201-1\",\"roomId\":8},{\"createBy\":1,\"createTime\":1697851210000,\"id\":19,\"isDelete\":0,\"name\":\"201-2\",\"roomId\":8},{\"createBy\":1,\"createTime\":1697851265000,\"id\":20,\"isDelete\":0,\"name\":\"202-1\",\"roomId\":9},{\"createBy\":1,\"createTime\":1697851265000,\"id\":21,\"isDelete\":0,\"name\":\"202-2\",\"roomId\":9},{\"createBy\":1,\"createTime\":1697851327000,\"id\":22,\"isDelete\":0,\"name\":\"203-1\",\"roomId\":10},{\"createBy\":1,\"createTime\":1697851327000,\"id\":23,\"isDelete\":0,\"name\":\"203-2\",\"roomId\":10},{\"createBy\":1,\"createTime\":1697851346000,\"id\":24,\"isDelete\":0,\"name\":\"204-1\",\"roomId\":11},{\"createBy\":1,\"createTime\":1697851346000,\"id\":25,\"isDelete\":0,\"name\":\"204-2\",\"roomId\":11},{\"createBy\":1,\"createTime\":1697851369000,\"id\":26,\"isDelete\":0,\"name\":\"205-1\",\"roomId\":12},{\"createBy\":1,\"createTime\":1697851369000,\"id\":27,\"isDelete\":0,\"name\":\"205-2\",\"roomId\":12},{\"createBy\":1,\"createTime\":1697851389000,\"id\":28,\"isDelete\":0,\"name\":\"206-1\",\"roomId\":13},{\"createBy\":1,\"createTime\":1697851389000,\"id\":29,\"isDelete\":0,\"name\":\"206-2\",\"roomId\":13},{\"createBy\":1,\"createTime\":1697851413000,\"id\":30,\"isDelete\":0,\"name\":\"207-1\",\"roomId\":14},{\"createBy\":1,\"createTime\":1697851413000,\"id\":31,\"isDelete\":0,\"name\":\"207-2\",\"roomId\":14},{\"createBy\":1,\"createTime\":1697851444000,\"id\":32,\"isDelete\":0,\"name\":\"208-1\",\"roomId\":15},{\"createBy\":1,\"createTime\":1697851444000,\"id\":33,\"isDelete\":0,\"name\":\"208-2\",\"roomId\":15},{\"createBy\":1,\"createTime\":1697851475000,\"id\":34,\"isDelete\":0,\"name\":\"209-1\",\"roomId\":16},{\"createBy\":1,\"createTime\":1697851475000,\"id\":35,\"isDelete\":0,\"name\":\"209-2\",\"roomId\":16},{\"createBy\":1,\"createTime\":1697851509000,\"id\":36,\"isDelete\":0,\"name\":\"210-1\",\"roomId\":17,\"updateBy\":1,\"updateTime\":1697851717000},{\"createBy\":1,\"createTime\":1697851509000,\"id\":37,\"isDelete\":0,\"name\":\"210-2\",\"roomId\":17,\"updateBy\":1,\"updateTime\":1697851717000},{\"createBy\":1,\"createTime\":1697851529000,\"id\":38,\"isDelete\":0,\"name\":\"211-1\",\"roomId\":18},{\"createBy\":1,\"createTime\":1697851529000,\"id\":39,\"isDelete\":0,\"name\":\"211-2\",\"roomId\":18},{\"createBy\":1,\"createTime\":1697851555000,\"id\":40,\"isDelete\":0,\"name\":\"212-1\",\"roomId\":19},{\"createBy\":1,\"createTime\":1697851555000,\"id\":41,\"isDelete\":0,\"name\":\"212-2\",\"roomId\":19},{\"createBy\":1,\"createTime\":1697851580000,\"id\":42,\"isDelete\":0,\"name\":\"213-1\",\"roomId\":20},{\"createBy\":1,\"createTime\":1697851580000,\"id\":43,\"isDelete\":0,\"name\":\"213-2\",\"roomId\":20},{\"createBy\":1,\"createTime\":1697851605000,\"id\":44,\"isDelete\":0,\"name\":\"214-1\",\"roomId\":21},{\"createBy\":1,\"createTime\":1697851605000,\"id\":45,\"isDelete\":0,\"name\":\"214-2\",\"roomId\":21},{\"createBy\":1,\"createTime\":1697851654
INSERT INTO `sys_oper_log` VALUES (4992,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,\"createBy\":1,\"createTi
INSERT INTO `sys_oper_log` VALUES (5363,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,\"createBy\":1,\"createTi
INSERT INTO `sys_oper_log` VALUES (5724,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,\"createBy\":1,\"createTi
INSERT INTO `sys_oper_log` VALUES (6081,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[{\"age\":67,\"createTime\":1697877272000,\"familyList\":[],\"id\":242,\"idCardNo\":\"422721195604074717\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"吴德荣\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":67,\"createTime\":1697877246000,\"familyList\":[],\"id\":241,\"idCardNo\":\"422721195609264720\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"陈定慈\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":0,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":64,\"createTime\":1697876693000,\"familyList\":[],\"id\":226,\"idCardNo\":\"422721195901074772\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"叶祥武\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"一组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":66,\"createTime\":1697876659000,\"familyList\":[],\"id\":225,\"idCardNo\":\"422721195709194715\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"陈廷智\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"一组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":65,\"createTime\":1697876252000,\"familyList\":[],\"id\":211,\"idCardNo\":\"420521195712164717\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"刘昌洲\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"八组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":66,\"createTime\":1697875703000,\"familyList\":[],\"id\":195,\"idCardNo\":\"420521195612174715\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"秦再新\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"八组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":73,\"createTime\":1697875680000,\"familyList\":[],\"id\":194,\"idCardNo\":\"422721195002174710\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"郑明忠\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"八组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":67,\"createTime\":1697875656000,\"familyList\":[],\"id\":193,\"idCardNo\":\"420521195610204714\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"郑明富\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"八组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":72,\"createTime\":1697875627000,\"familyList\":[],\"id\":192,\"idCardNo\":\"420521195104234718\",\"ifDisabled\":0,\"ifH
INSERT INTO `sys_oper_log` VALUES (6380,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllBed()','POST',1,'admin',NULL,'/room/listAllBed','127.0.0.1',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"createBy\":1,\"createTime\":1697851091000,\"id\":10,\"isDelete\":0,\"name\":\"101-1\",\"roomId\":5},{\"createBy\":1,\"createTime\":1697851091000,\"id\":11,\"isDelete\":0,\"name\":\"101-2\",\"roomId\":5},{\"createBy\":1,\"createTime\":1697851135000,\"id\":12,\"isDelete\":0,\"name\":\"102-1\",\"roomId\":6},{\"createBy\":1,\"createTime\":1697851135000,\"id\":13,\"isDelete\":0,\"name\":\"102-2\",\"roomId\":6},{\"createBy\":1,\"createTime\":1697851169000,\"id\":14,\"isDelete\":0,\"name\":\"103-1\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":15,\"isDelete\":0,\"name\":\"103-2\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":16,\"isDelete\":0,\"name\":\"103-3\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":17,\"isDelete\":0,\"name\":\"103-4\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851210000,\"id\":18,\"isDelete\":0,\"name\":\"201-1\",\"roomId\":8},{\"createBy\":1,\"createTime\":1697851210000,\"id\":19,\"isDelete\":0,\"name\":\"201-2\",\"roomId\":8},{\"createBy\":1,\"createTime\":1697851265000,\"id\":20,\"isDelete\":0,\"name\":\"202-1\",\"roomId\":9},{\"createBy\":1,\"createTime\":1697851265000,\"id\":21,\"isDelete\":0,\"name\":\"202-2\",\"roomId\":9},{\"createBy\":1,\"createTime\":1697851327000,\"id\":22,\"isDelete\":0,\"name\":\"203-1\",\"roomId\":10},{\"createBy\":1,\"createTime\":1697851327000,\"id\":23,\"isDelete\":0,\"name\":\"203-2\",\"roomId\":10},{\"createBy\":1,\"createTime\":1697851346000,\"id\":24,\"isDelete\":0,\"name\":\"204-1\",\"roomId\":11},{\"createBy\":1,\"createTime\":1697851346000,\"id\":25,\"isDelete\":0,\"name\":\"204-2\",\"roomId\":11},{\"createBy\":1,\"createTime\":1697851369000,\"id\":26,\"isDelete\":0,\"name\":\"205-1\",\"roomId\":12},{\"createBy\":1,\"createTime\":1697851369000,\"id\":27,\"isDelete\":0,\"name\":\"205-2\",\"roomId\":12},{\"createBy\":1,\"createTime\":1697851389000,\"id\":28,\"isDelete\":0,\"name\":\"206-1\",\"roomId\":13},{\"createBy\":1,\"createTime\":1697851389000,\"id\":29,\"isDelete\":0,\"name\":\"206-2\",\"roomId\":13},{\"createBy\":1,\"createTime\":1697851413000,\"id\":30,\"isDelete\":0,\"name\":\"207-1\",\"roomId\":14},{\"createBy\":1,\"createTime\":1697851413000,\"id\":31,\"isDelete\":0,\"name\":\"207-2\",\"roomId\":14},{\"createBy\":1,\"createTime\":1697851444000,\"id\":32,\"isDelete\":0,\"name\":\"208-1\",\"roomId\":15},{\"createBy\":1,\"createTime\":1697851444000,\"id\":33,\"isDelete\":0,\"name\":\"208-2\",\"roomId\":15},{\"createBy\":1,\"createTime\":1697851475000,\"id\":34,\"isDelete\":0,\"name\":\"209-1\",\"roomId\":16},{\"createBy\":1,\"createTime\":1697851475000,\"id\":35,\"isDelete\":0,\"name\":\"209-2\",\"roomId\":16},{\"createBy\":1,\"createTime\":1697851509000,\"id\":36,\"isDelete\":0,\"name\":\"210-1\",\"roomId\":17,\"updateBy\":1,\"updateTime\":1697851717000},{\"createBy\":1,\"createTime\":1697851509000,\"id\":37,\"isDelete\":0,\"name\":\"210-2\",\"roomId\":17,\"updateBy\":1,\"updateTime\":1697851717000},{\"createBy\":1,\"createTime\":1697851529000,\"id\":38,\"isDelete\":0,\"name\":\"211-1\",\"roomId\":18},{\"createBy\":1,\"createTime\":1697851529000,\"id\":39,\"isDelete\":0,\"name\":\"211-2\",\"roomId\":18},{\"createBy\":1,\"createTime\":1697851555000,\"id\":40,\"isDelete\":0,\"name\":\"212-1\",\"roomId\":19},{\"createBy\":1,\"createTime\":1697851555000,\"id\":41,\"isDelete\":0,\"name\":\"212-2\",\"roomId\":19},{\"createBy\":1,\"createTime\":1697851580000,\"id\":42,\"isDelete\":0,\"name\":\"213-1\",\"roomId\":20},{\"createBy\":1,\"createTime\":1697851580000,\"id\":43,\"isDelete\":0,\"name\":\"213-2\",\"roomId\":20},{\"createBy\":1,\"createTime\":1697851605000,\"id\":44,\"isDelete\":0,\"name\":\"214-1\",\"roomId\":21},{\"createBy\":1,\"createTime\":1697851605000,\"id\":45,\"isDelete\":0,\"name\":\"214-2\",\"roomId\":21},{\"createBy\":1,\"createTime\":1697851654
INSERT INTO `sys_oper_log` VALUES (6580,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[],\"total\":0}',0,NULL,'2023-10-26 08:50:52'),(6581,'词典项下拉选',4,'com.org.system.controller.SysDataDictionaryItemController.dropDown()','GET',1,'admin',NULL,'/sys/dictionary/item/dropDown','127.0.0.1',NULL,'{}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"id\":9,\"name\":\"集中供养\",\"value\":1,\"parentid\":-1},{\"id\":10,\"name\":\"分散供养\",\"value\":2,\"parentid\":-1}]}',0,NULL,'2023-10-26 08:53:19'),(6582,'词典项下拉选',4,'com.org.system.controller.SysDataDictionaryItemController.dropDown()','GET',1,'admin',NULL,'/sys/dictionary/item/dropDown','127.0.0.1',NULL,'{}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"id\":28,\"name\":\"一级护理（全失能）\",\"value\":1,\"parentid\":-1},{\"id\":29,\"name\":\"二级护理（半失能）\",\"value\":2,\"parentid\":-1},{\"id\":30,\"name\":\"三级护理（自理）\",\"value\":3,\"parentid\":-1}]}',0,NULL,'2023-10-26 08:53:19'),(6583,'词典项下拉选',4,'com.org.system.controller.SysDataDictionaryItemController.dropDown()','GET',1,'admin',NULL,'/sys/dictionary/item/dropDown','127.0.0.1',NULL,'{}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"id\":20,\"name\":\"下堡坪村\",\"value\":1,\"parentid\":-1},{\"id\":21,\"name\":\"蛟龙寺村\",\"value\":2,\"parentid\":-1},{\"id\":22,\"name\":\"九山村\",\"value\":3,\"parentid\":-1},{\"id\":23,\"name\":\"马宗岭村\",\"value\":4,\"parentid\":-1},{\"id\":24,\"name\":\"赵勉河村\",\"value\":5,\"parentid\":-1},{\"id\":25,\"name\":\"秀水村\",\"value\":6,\"parentid\":-1},{\"id\":26,\"name\":\"磨坪村\",\"value\":7,\"parentid\":-1},{\"id\":27,\"name\":\"十八湾村\",\"value\":8,\"parentid\":-1}]}',0,NULL,'2023-10-26 08:53:19'),(6584,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[{\"age\":64,\"createTime\":1697877374000,\"familyList\":[],\"id\":246,\"idCardNo\":\"422721195902073675\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"张光耀\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":8,\"villageName\":\"十八湾村\"},{\"age\":64,\"createTime\":1697877350000,\"familyList\":[],\"id\":245,\"idCardNo\":\"422721195901063651\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"黄仕焕\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":7,\"villageName\":\"磨坪村\"},{\"age\":64,\"createTime\":1697877328000,\"familyList\":[],\"id\":244,\"idCardNo\":\"422721195811303658\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"冀仕贵\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"十二组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":7,\"villageName\":\"磨坪村\"},{\"age\":64,\"createTime\":1697877296000,\"familyList\":[],\"id\":243,\"idCardNo\":\"422721195901313657\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"杜贵三\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":67,\"createTime\":1697877272000,\"f
INSERT INTO `sys_oper_log` VALUES (6772,'荣誉橱窗展示列表查询',4,'com.org.web.honor.controller.BcHonorShowController.list()','GET',1,'admin',NULL,'/honor/show/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[{\"content\":\"<p style=\\\"margin-top: 0px; margin-bottom: 24px; padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.6em; text-align: justify; text-indent: 2em; visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\\\"><span style=\\\"margin: 0px; padding: 0px; outline: 0px; max-width: 100%; color: rgb(51, 51, 51); font-size: 17px; visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\\\">3月7日，下堡坪乡新时代文明实践所联合乡卫生院志愿服务队前往下堡坪乡福利院，开展“送医送药送健康”志愿服务，真心守护夕阳红，为60余名老人免费开展健康体检、家庭医生签约、健康宣教、流感疫苗接种等服务工作，把健康送到老人们的手中。</span></p><p style=\\\"margin-top: 0px; margin-bottom: 24px; padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.6em; text-align: justify; text-indent: 2em; visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\\\"><span style=\\\"color: rgb(51, 51, 51); font-size: 17px; text-indent: 2em;\\\"><img src=\\\"/welfare/sys/oss/show/20231025/7aebe3c3fb2b42acbb67dd7f0f25a8a7.jpg?width=1024\\\" title=\\\"6401.jpg\\\" alt=\\\"6401.jpg\\\"/></span></p><p style=\\\"margin-top: 0px; margin-bottom: 24px; padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.6em; text-align: justify; text-indent: 2em; visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\\\"><span style=\\\"color: rgb(51, 51, 51); font-size: 17px; text-indent: 2em;\\\">活动现场，医务人员有序为老人们开展血压、心电图、 B 超、血尿常规等多项检查，为所有人员接种流感疫苗的同时进行健康知识宣讲。体检同时详细询问老人的既往病史、生活习惯，评估他们健康状况，逐一建立健康档案；向老人提供家庭医生签约服务；并根据老人们个体状况提出合理健康建议，指导老人合理饮食、科学锻炼、健康养生。</span></p><p style=\\\"margin-top: 0px; margin-bottom: 24px; padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.6em; text-align: justify; text-indent: 2em; visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\\\"><span style=\\\"color: rgb(51, 51, 51); font-size: 17px; text-indent: 2em;\\\"><img src=\\\"/welfare/sys/oss/show/20231025/597d5ffcb8f84079b76ce7b494f83283.jpg?width=1024\\\" title=\\\"6401 (1).jpg\\\" alt=\\\"6401 (1).jpg\\\"/></span></p><p style=\\\"margin-top: 0px; margin-bottom: 24px; padding: 0px; outline: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.6em; text-align: justify; text-indent: 2em; visibility: visible; box-sizing: border-box !important; overflow-wrap: break-word !important;\\\"><span style=\\\"color: rgb(51, 51, 51); font-size: 17px; text-indent: 2em;\\\">据悉，下堡坪乡卫生院2022年被评定为湖北省首批老年友善基层医疗机构。下一步，卫生院志愿服务队将积极探索“医养结合”模式，为福利院老人开通医疗服务“绿色通道”，定期开展义诊、体检及健康教育上门服务等活动。结合特殊群体的需求与困难，推行“医养融合驻点式”新模式，实现老有所养、老有所医，真正让老人们在家门口安享幸福晚年。</span></p><p style=\\\"margin-top: 0px; margin-bottom: 24px; padding: 0px; outline: 0px; max-width: 100%; min-height: 1em; box-sizing: border-box !important; overflow-wrap: break-word !important;\\\">文章来源：云上夷陵</p><p style=\\\"margin-top: 0px; margin-bottom: 24px; pad
INSERT INTO `sys_oper_log` VALUES (6813,'荣誉橱窗展示列表查询',4,'com.org.web.honor.controller.BcHonorShowController.list()','GET',1,'admin',NULL,'/honor/show/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[{\"content\":\"<p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><br/></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\">鲁自鹏，1963年8月出生，1993年6月加入中国共产党，现担任湖北省宜昌市夷陵区下堡坪乡农村福利院院长。鲁自鹏自担任下堡坪乡农村福利院院长20年来，用心用情呵护着下堡坪乡无依无靠的孤寡老人和无人抚养的孤儿群体，每一年春节都在福利院陪老人跨年守岁，把自己特别的爱奉献给了这个特殊的“家”。她曾先后获得“宜昌市农村福利院优秀院长”“夷陵区优秀共产党员”“夷陵区文明个人”等荣誉称号。</span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><img src=\\\"/welfare/sys/oss/show/20231027/9f3310fc94ed4f44ac1f3ea0d829be15.jpg?width=1024\\\" title=\\\"82cd563806e842eb9609ba3275ca20a3.jpg\\\" alt=\\\"82cd563806e842eb9609ba3275ca20a3.jpg\\\"/></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\">走进下堡坪乡农村福利院，绿树成荫、窗明几净，老人们或二人间或四人间，大床、衣柜、桌椅板凳、抽水马桶、淋浴、电视机、空调机一应俱全，院内会议室、活动室、药房、洗衣房、厨房、餐厅、放映厅应有尽有，老人们三三两两在一起聊天欢笑，一派平静祥和。</span></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><img src=\\\"/welfare/sys/oss/show/20231027/a0c786ab79824c499a888352d595937d.jpg?width=1024\\\" title=\\\"7410e994804746c590a1e281d6d21838.jpg\\\" alt=\\\"7410e994804746c590a1e281d6d21838.jpg\\\"/></span></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align
INSERT INTO `sys_oper_log` VALUES (6928,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','127.0.0.1',NULL,'{\"roomBedList\":[],\"roomType\":1}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedN
INSERT INTO `sys_oper_log` VALUES (7183,'荣誉橱窗展示列表查询',4,'com.org.web.honor.controller.BcHonorShowController.list()','GET',1,'admin',NULL,'/honor/show/list','127.0.0.1',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[{\"content\":\"<p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><br/></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\">鲁自鹏，1963年8月出生，1993年6月加入中国共产党，现担任湖北省宜昌市夷陵区下堡坪乡农村福利院院长。鲁自鹏自担任下堡坪乡农村福利院院长20年来，用心用情呵护着下堡坪乡无依无靠的孤寡老人和无人抚养的孤儿群体，每一年春节都在福利院陪老人跨年守岁，把自己特别的爱奉献给了这个特殊的“家”。她曾先后获得“宜昌市农村福利院优秀院长”“夷陵区优秀共产党员”“夷陵区文明个人”等荣誉称号。</span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><img src=\\\"/welfare/sys/oss/show/20231027/9f3310fc94ed4f44ac1f3ea0d829be15.jpg?width=1024\\\" title=\\\"82cd563806e842eb9609ba3275ca20a3.jpg\\\" alt=\\\"82cd563806e842eb9609ba3275ca20a3.jpg\\\"/></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\">走进下堡坪乡农村福利院，绿树成荫、窗明几净，老人们或二人间或四人间，大床、衣柜、桌椅板凳、抽水马桶、淋浴、电视机、空调机一应俱全，院内会议室、活动室、药房、洗衣房、厨房、餐厅、放映厅应有尽有，老人们三三两两在一起聊天欢笑，一派平静祥和。</span></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align: justify; text-wrap: wrap; background-color: rgb(250, 251, 252);\\\"><img src=\\\"/welfare/sys/oss/show/20231027/a0c786ab79824c499a888352d595937d.jpg?width=1024\\\" title=\\\"7410e994804746c590a1e281d6d21838.jpg\\\" alt=\\\"7410e994804746c590a1e281d6d21838.jpg\\\"/></span></span></p><p><span style=\\\"color: rgb(51, 51, 51); font-family: FZYaSongS-R-GB, FZYaSong-M-GBK, &quot;PingFang SC&quot;, miui, system-ui, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif; font-size: 20.25px; text-align
INSERT INTO `sys_oper_log` VALUES (7396,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllBed()','POST',1,'admin',NULL,'/room/listAllBed','223.104.20.169',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"createBy\":1,\"createTime\":1697851091000,\"id\":10,\"isDelete\":0,\"name\":\"101-1\",\"roomId\":5},{\"createBy\":1,\"createTime\":1697851091000,\"id\":11,\"isDelete\":0,\"name\":\"101-2\",\"roomId\":5},{\"createBy\":1,\"createTime\":1697851135000,\"id\":12,\"isDelete\":0,\"name\":\"102-1\",\"roomId\":6},{\"createBy\":1,\"createTime\":1697851135000,\"id\":13,\"isDelete\":0,\"name\":\"102-2\",\"roomId\":6},{\"createBy\":1,\"createTime\":1697851169000,\"id\":14,\"isDelete\":0,\"name\":\"103-1\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":15,\"isDelete\":0,\"name\":\"103-2\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":16,\"isDelete\":0,\"name\":\"103-3\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851169000,\"id\":17,\"isDelete\":0,\"name\":\"103-4\",\"roomId\":7},{\"createBy\":1,\"createTime\":1697851210000,\"id\":18,\"isDelete\":0,\"name\":\"201-1\",\"roomId\":8},{\"createBy\":1,\"createTime\":1697851210000,\"id\":19,\"isDelete\":0,\"name\":\"201-2\",\"roomId\":8},{\"createBy\":1,\"createTime\":1697851265000,\"id\":20,\"isDelete\":0,\"name\":\"202-1\",\"roomId\":9},{\"createBy\":1,\"createTime\":1697851265000,\"id\":21,\"isDelete\":0,\"name\":\"202-2\",\"roomId\":9},{\"createBy\":1,\"createTime\":1697851327000,\"id\":22,\"isDelete\":0,\"name\":\"203-1\",\"roomId\":10},{\"createBy\":1,\"createTime\":1697851327000,\"id\":23,\"isDelete\":0,\"name\":\"203-2\",\"roomId\":10},{\"createBy\":1,\"createTime\":1697851346000,\"id\":24,\"isDelete\":0,\"name\":\"204-1\",\"roomId\":11},{\"createBy\":1,\"createTime\":1697851346000,\"id\":25,\"isDelete\":0,\"name\":\"204-2\",\"roomId\":11},{\"createBy\":1,\"createTime\":1697851369000,\"id\":26,\"isDelete\":0,\"name\":\"205-1\",\"roomId\":12},{\"createBy\":1,\"createTime\":1697851369000,\"id\":27,\"isDelete\":0,\"name\":\"205-2\",\"roomId\":12},{\"createBy\":1,\"createTime\":1697851389000,\"id\":28,\"isDelete\":0,\"name\":\"206-1\",\"roomId\":13},{\"createBy\":1,\"createTime\":1697851389000,\"id\":29,\"isDelete\":0,\"name\":\"206-2\",\"roomId\":13},{\"createBy\":1,\"createTime\":1697851413000,\"id\":30,\"isDelete\":0,\"name\":\"207-1\",\"roomId\":14},{\"createBy\":1,\"createTime\":1697851413000,\"id\":31,\"isDelete\":0,\"name\":\"207-2\",\"roomId\":14},{\"createBy\":1,\"createTime\":1697851444000,\"id\":32,\"isDelete\":0,\"name\":\"208-1\",\"roomId\":15},{\"createBy\":1,\"createTime\":1697851444000,\"id\":33,\"isDelete\":0,\"name\":\"208-2\",\"roomId\":15},{\"createBy\":1,\"createTime\":1697851475000,\"id\":34,\"isDelete\":0,\"name\":\"209-1\",\"roomId\":16},{\"createBy\":1,\"createTime\":1697851475000,\"id\":35,\"isDelete\":0,\"name\":\"209-2\",\"roomId\":16},{\"createBy\":1,\"createTime\":1697851509000,\"id\":36,\"isDelete\":0,\"name\":\"210-1\",\"roomId\":17,\"updateBy\":1,\"updateTime\":1697851717000},{\"createBy\":1,\"createTime\":1697851509000,\"id\":37,\"isDelete\":0,\"name\":\"210-2\",\"roomId\":17,\"updateBy\":1,\"updateTime\":1697851717000},{\"createBy\":1,\"createTime\":1697851529000,\"id\":38,\"isDelete\":0,\"name\":\"211-1\",\"roomId\":18},{\"createBy\":1,\"createTime\":1697851529000,\"id\":39,\"isDelete\":0,\"name\":\"211-2\",\"roomId\":18},{\"createBy\":1,\"createTime\":1697851555000,\"id\":40,\"isDelete\":0,\"name\":\"212-1\",\"roomId\":19},{\"createBy\":1,\"createTime\":1697851555000,\"id\":41,\"isDelete\":0,\"name\":\"212-2\",\"roomId\":19},{\"createBy\":1,\"createTime\":1697851580000,\"id\":42,\"isDelete\":0,\"name\":\"213-1\",\"roomId\":20},{\"createBy\":1,\"createTime\":1697851580000,\"id\":43,\"isDelete\":0,\"name\":\"213-2\",\"roomId\":20},{\"createBy\":1,\"createTime\":1697851605000,\"id\":44,\"isDelete\":0,\"name\":\"214-1\",\"roomId\":21},{\"createBy\":1,\"createTime\":1697851605000,\"id\":45,\"isDelete\":0,\"name\":\"214-2\",\"roomId\":21},{\"createBy\":1,\"createTime\":16978
INSERT INTO `sys_oper_log` VALUES (7621,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','171.44.169.15',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":1,\"rows\":[{\"age\":64,\"createTime\":1697877374000,\"familyList\":[],\"id\":246,\"idCardNo\":\"422721195902073675\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"张光耀\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":8,\"villageName\":\"十八湾村\"},{\"age\":64,\"createTime\":1697877350000,\"familyList\":[],\"id\":245,\"idCardNo\":\"422721195901063651\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"黄仕焕\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":7,\"villageName\":\"磨坪村\"},{\"age\":64,\"createTime\":1697877328000,\"familyList\":[],\"id\":244,\"idCardNo\":\"422721195811303658\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"冀仕贵\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"十二组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":7,\"villageName\":\"磨坪村\"},{\"age\":64,\"createTime\":1697877296000,\"familyList\":[],\"id\":243,\"idCardNo\":\"422721195901313657\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"杜贵三\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":67,\"createTime\":1697877272000,\"familyList\":[],\"id\":242,\"idCardNo\":\"422721195604074717\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"吴德荣\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":67,\"createTime\":1697877246000,\"familyList\":[],\"id\":241,\"idCardNo\":\"422721195609264720\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"陈定慈\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":0,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":4,\"villageName\":\"马宗岭村\"},{\"age\":66,\"createTime\":1697877221000,\"familyList\":[],\"id\":240,\"idCardNo\":\"420521195708294711\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"朱国亮\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"五组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":3,\"villageName\":\"九山村\"},{\"age\":64,\"createTime\":1697877194000,\"familyList\":[],\"id\":239,\"idCardNo\":\"422721195904104711\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"秦百新\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"七组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":2,\"villageName\":\"蛟龙寺村\"},{\"age\":64,\"createTime\":1697877166000,\"familyList\":[],\"id\":238,\"idCardNo\":\"422721195905234710\",
INSERT INTO `sys_oper_log` VALUES (8057,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','171.44.169.15',NULL,'{\"roomBedList\":[]}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,\
INSERT INTO `sys_oper_log` VALUES (8442,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','171.44.136.171',NULL,'{\"roomBedList\":[]}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,
INSERT INTO `sys_oper_log` VALUES (8883,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','171.44.136.171',NULL,'{\"roomBedList\":[]}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,
INSERT INTO `sys_oper_log` VALUES (9282,'床位列表查询',4,'com.org.web.room.controller.BcRoomController.listAllRoom()','POST',1,'admin',NULL,'/room/listAllRoom','171.44.136.171',NULL,'{\"roomBedList\":[]}','{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851074000,\"id\":5,\"isDelete\":0,\"name\":\"101\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851091000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851103000,\"id\":6,\"isDelete\":0,\"name\":\"102\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851135000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851143000,\"id\":7,\"isDelete\":0,\"name\":\"103\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851169000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851195000,\"id\":8,\"isDelete\":0,\"name\":\"201\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851210000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851252000,\"id\":9,\"isDelete\":0,\"name\":\"202\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851265000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851306000,\"id\":10,\"isDelete\":0,\"name\":\"203\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851327000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851335000,\"id\":11,\"isDelete\":0,\"name\":\"204\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851346000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851354000,\"id\":12,\"isDelete\":0,\"name\":\"205\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851369000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851378000,\"id\":13,\"isDelete\":0,\"name\":\"206\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851389000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851397000,\"id\":14,\"isDelete\":0,\"name\":\"207\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851413000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851421000,\"id\":15,\"isDelete\":0,\"name\":\"208\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851444000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851459000,\"id\":16,\"isDelete\":0,\"name\":\"209\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851475000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851487000,\"id\":17,\"isDelete\":0,\"name\":\"210\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851717000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851516000,\"id\":18,\"isDelete\":0,\"name\":\"211\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851529000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851541000,\"id\":19,\"isDelete\":0,\"name\":\"212\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851555000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851562000,\"id\":20,\"isDelete\":0,\"name\":\"213\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851580000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851587000,\"id\":21,\"isDelete\":0,\"name\":\"214\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851605000},{\"bedNumber\":4,\"createBy\":1,\"createTime\":1697851627000,\"id\":22,\"isDelete\":0,\"name\":\"215\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851654000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851730000,\"id\":23,\"isDelete\":0,\"name\":\"301\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851744000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851751000,\"id\":24,\"isDelete\":0,\"name\":\"302\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851765000},{\"bedNumber\":2,\"createBy\":1,\"createTime\":1697851777000,\"id\":25,\"isDelete\":0,\"name\":\"303\",\"roomBedList\":[],\"roomType\":1,\"updateBy\":1,\"updateTime\":1697851792000},{\"bedNumber\":2,
INSERT INTO `sys_oper_log` VALUES (9715,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','171.44.171.15',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":2,\"rows\":[{\"age\":69,\"createTime\":1697877142000,\"familyList\":[],\"id\":237,\"idCardNo\":\"422721195403053653\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"胡学淼\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"七组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":6,\"villageName\":\"秀水村\"},{\"age\":68,\"createTime\":1697877116000,\"familyList\":[],\"id\":236,\"idCardNo\":\"422721195504173654\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"黄大生\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"五组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":8,\"villageName\":\"十八湾村\"},{\"age\":65,\"createTime\":1697877093000,\"familyList\":[],\"id\":235,\"idCardNo\":\"422721195805083652\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"何仕保\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":8,\"villageName\":\"十八湾村\"},{\"age\":65,\"createTime\":1697877071000,\"familyList\":[],\"id\":234,\"idCardNo\":\"422721195806293651\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"吴廷贵\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"一组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":8,\"villageName\":\"十八湾村\"},{\"age\":65,\"createTime\":1697877019000,\"familyList\":[],\"id\":232,\"idCardNo\":\"422721195801303670\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"陈世魁\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":7,\"villageName\":\"磨坪村\"},{\"age\":65,\"createTime\":1697876995000,\"familyList\":[],\"id\":231,\"idCardNo\":\"422721195808243658\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"向立炎\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":6,\"villageName\":\"秀水村\"},{\"age\":65,\"createTime\":1697876970000,\"familyList\":[],\"id\":230,\"idCardNo\":\"422721195805263653\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"张荣芳\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":6,\"villageName\":\"秀水村\"},{\"age\":65,\"createTime\":1697876943000,\"familyList\":[],\"id\":229,\"idCardNo\":\"422721195806013656\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"向国华\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":2,\"supportTypeName\":\"分散供养\",\"type\":1,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":66,\"createTime\":1697876915000,\"familyList\":[],\"id\":228,\"idCardNo\":\"422721195710233670\",\"ifDi
INSERT INTO `sys_oper_log` VALUES (10103,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','171.44.171.15',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":4,\"rows\":[{\"age\":61,\"bringTime\":1104508800000,\"createTime\":1697854427000,\"familyList\":[],\"id\":59,\"idCardNo\":\"422721196202123672\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"贾绍炳\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"五组\",\"roomBed\":\"203-2\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1698998653000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":85,\"bringTime\":915120000000,\"createTime\":1697854382000,\"familyList\":[],\"id\":58,\"idCardNo\":\"422721193801073650\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":1,\"name\":\"刘从元\",\"nursingLevel\":1,\"nursingLevelName\":\"一级护理（全失能）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":75,\"bringTime\":1199116800000,\"createTime\":1697854340000,\"familyList\":[],\"id\":57,\"idCardNo\":\"422721194801153655\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"韩永柱\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":52,\"bringTime\":1009814400000,\"createTime\":1697854295000,\"familyList\":[],\"id\":56,\"idCardNo\":\"422721197108073650\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":1,\"name\":\"张昌国\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"roomBed\":\"213-2\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1698998746000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":62,\"bringTime\":694195200000,\"createTime\":1697854245000,\"familyList\":[],\"id\":55,\"idCardNo\":\"42272119610713367X\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":1,\"name\":\"郑海清\",\"nursingLevel\":2,\"nursingLevelName\":\"二级护理（半失能）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1698998769000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":61,\"bringTime\":1136044800000,\"createTime\":1697854206000,\"familyList\":[],\"id\":54,\"idCardNo\":\"422721196204253673\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"董传相\",\"nursingLevel\":1,\"nursingLevelName\":\"一级护理（全失能）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1698998798000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":63,\"bringTime\":1420041600000,\"createTime\":1697854166000,\"familyList\":[],\"id\":53,\"idCardNo\":\"422721196007033655\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"黄有林\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"roomBed\":\"215-1\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":51,\"bringTime\":1136044800000,\"createTime\":1697854117000,\"familyList\":[],\"id\":52,\"idCardNo\":\"422721197205233652\",\"i
INSERT INTO `sys_oper_log` VALUES (10490,'供养人员列表查询',4,'com.org.web.person.controller.BcPersonSupportController.list()','GET',1,'admin',NULL,'/person/support/list','171.44.171.15',NULL,'{}','{\"code\":200,\"msg\":\"查询成功\",\"pageNo\":4,\"rows\":[{\"age\":61,\"bringTime\":1104508800000,\"createTime\":1697854427000,\"familyList\":[],\"id\":59,\"idCardNo\":\"422721196202123672\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"贾绍炳\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"五组\",\"roomBed\":\"203-2\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1698998653000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":85,\"bringTime\":915120000000,\"createTime\":1697854382000,\"familyList\":[],\"hospitalMessage\":\"小溪塔福利院\",\"id\":58,\"idCardNo\":\"422721193801073650\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"刘从元\",\"nursingLevel\":1,\"nursingLevelName\":\"一级护理（全失能）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"四组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1699083907000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":75,\"bringTime\":1199116800000,\"createTime\":1697854340000,\"familyList\":[],\"hospitalMessage\":\"康宁医院\",\"id\":57,\"idCardNo\":\"422721194801153655\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"韩永柱\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"三组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1699083959000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":52,\"bringTime\":1009814400000,\"createTime\":1697854295000,\"familyList\":[],\"id\":56,\"idCardNo\":\"422721197108073650\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":1,\"name\":\"张昌国\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"roomBed\":\"213-2\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1698998746000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":62,\"bringTime\":694195200000,\"createTime\":1697854245000,\"familyList\":[],\"hospitalMessage\":\"康宁医院\",\"id\":55,\"idCardNo\":\"42272119610713367X\",\"ifDisabled\":0,\"ifHelpPoor\":0,\"isDelete\":0,\"isInHospital\":0,\"name\":\"郑海清\",\"nursingLevel\":2,\"nursingLevelName\":\"二级护理（半失能）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1699084025000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":61,\"bringTime\":1136044800000,\"createTime\":1697854206000,\"familyList\":[],\"hospitalMessage\":\"小溪塔福利院\",\"id\":54,\"idCardNo\":\"422721196204253673\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":0,\"name\":\"董传相\",\"nursingLevel\":1,\"nursingLevelName\":\"一级护理（全失能）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"sex\":1,\"supportType\":1,\"supportTypeName\":\"集中供养\",\"type\":1,\"updateBy\":1,\"updateTime\":1699084070000,\"village\":5,\"villageName\":\"赵勉河村\"},{\"age\":63,\"bringTime\":1420041600000,\"createTime\":1697854166000,\"familyList\":[],\"id\":53,\"idCardNo\":\"422721196007033655\",\"ifDisabled\":0,\"ifHelpPoor\":1,\"isDelete\":0,\"isInHospital\":1,\"name\":\"黄有林\",\"nursingLevel\":3,\"nursingLevelName\":\"三级护理（自 理）\",\"phone\":\"\",\"residenceAddress\":\"\",\"residenceVillage\":\"二组\",\"roomBed\":\"215-1\",\"sex\":1,\"
INSERT INTO `sys_oper_log` VALUES (10711,'获取当前登录用户信息',11,'com.org.system.controller.SysLoginController.getLoginUser()','POST',1,'admin',NULL,'/getLoginUser','171.44.137.234',NULL,'','{\"msg\":\"操作成功\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"browser\":\"Chrome\",\"credentialsNonExpired\":true,\"currentRole\":{\"code\":\"platform_manager\",\"createBy\":1,\"createTime\":1686294353000,\"id\":2,\"isDelete\":0,\"name\":\"平台管理员\",\"parentId\":-1,\"remark\":\"test\",\"sort\":2,\"updateBy\":2,\"updateTime\":1687579524000},\"currentRoleCode\":\"platform_manager\",\"enabled\":true,\"expireTime\":1807090441623,\"ipaddr\":\"171.44.137.234\",\"loginLocation\":\"\",\"loginTime\":1699090441623,\"menus\":[{\"component\":\"RouteView\",\"hidden\":false,\"id\":2,\"meta\":{\"show\":true,\"title\":\"权限管理\"},\"name\":\"security_manage\",\"path\":\"/security\",\"pid\":0},{\"component\":\"security/user/UserList\",\"hidden\":false,\"id\":8,\"meta\":{\"show\":true,\"title\":\"用户管理\"},\"name\":\"sys_user_mgr\",\"path\":\"/user2\",\"pid\":2},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":279,\"meta\":{\"show\":true,\"title\":\"用药管理\"},\"name\":\"ylfw_yygl\",\"path\":\"/ylfw_yygl\",\"pid\":278},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":284,\"meta\":{\"show\":true,\"title\":\"人员定位\"},\"name\":\"aqld_rydw\",\"path\":\"/aqld_rydw\",\"pid\":283},{\"component\":\"security/role/RoleList\",\"hidden\":false,\"id\":4,\"meta\":{\"show\":true,\"title\":\"角色管理\"},\"name\":\"sys_role_mgr\",\"path\":\"/role\",\"pid\":2},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":280,\"meta\":{\"show\":true,\"title\":\"餐饮管理\"},\"name\":\"ylfw_cygl\",\"path\":\"/ylfw_cygl\",\"pid\":278},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":285,\"meta\":{\"show\":true,\"title\":\"报警处理\"},\"name\":\"aqld_bjcl\",\"path\":\"/aqld_bjcl\",\"pid\":283},{\"component\":\"security/menu/MenuList\",\"hidden\":false,\"id\":3,\"meta\":{\"show\":true,\"title\":\"菜单管理\"},\"name\":\"sys_menu_mgr\",\"path\":\"/menu\",\"pid\":2},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":281,\"meta\":{\"show\":true,\"title\":\"健康评估\"},\"name\":\"ylfw_jkpg\",\"path\":\"/ylfw_jkpg\",\"pid\":278},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":286,\"meta\":{\"show\":true,\"title\":\"健康检查\"},\"name\":\"aqld_jkjc\",\"path\":\"/aqld_jkjc\",\"pid\":283},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":282,\"meta\":{\"show\":true,\"title\":\"亲情关爱\"},\"name\":\"ylfw_qqga\",\"path\":\"/ylfw_qqga\",\"pid\":278},{\"component\":\"exception/developing\",\"hidden\":false,\"id\":287,\"meta\":{\"show\":true,\"title\":\"床边检测\"},\"name\":\"aqld_cbjc\",\"path\":\"/aqld_cbjc\",\"pid\":283},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":15,\"meta\":{\"show\":true,\"title\":\"供养人员管理\"},\"name\":\"person_support_mgr\",\"path\":\"/person/support\",\"pid\":14},{\"component\":\"room/RoomCheckinList\",\"hidden\":false,\"id\":24,\"meta\":{\"show\":true,\"title\":\"入住管理\"},\"name\":\"room_checkin_mgr\",\"path\":\"/room/checkin\",\"pid\":22},{\"component\":\"person/ServiceList\",\"hidden\":false,\"id\":16,\"meta\":{\"show\":true,\"title\":\"服务人员管理\"},\"name\":\"person_service_mgr\",\"path\":\"/person/service\",\"pid\":14},{\"component\":\"room/RoomCheckoutList\",\"hidden\":false,\"id\":25,\"meta\":{\"show\":true,\"title\":\"退房管理\"},\"name\":\"room_checkout_mgr\",\"path\":\"/room/checkout\",\"pid\":22},{\"component\":\"person/SupportList\",\"hidden\":false,\"id\":17,\"meta\":{\"show\":true,\"title\":\"医养结合护理人员\"},\"name\":\"person_care_mgr\",\"path\":\"/person/care\",\"pid\":14},{\"component\":\"RouteView\",\"hidden\":false,\"id\":22,\"meta\":{\"show\":true,\"title\":\"房间管理\"},\"name\":\"room_mgr\",\"path\":\"/room\",\"pid\":0},{\"component\":\"room/RoomList\",\"hidden\":false,\"id\
/*!40000 ALTER TABLE `sys_oper_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_org`
--
DROP TABLE IF EXISTS `sys_org`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_org` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`pid` bigint(20) NOT NULL COMMENT '父id',
`pids` text NOT NULL COMMENT '父ids',
`name` varchar(255) NOT NULL COMMENT '名称',
`code` varchar(255) DEFAULT NULL COMMENT '编码',
`org_type` int(11) DEFAULT '1' COMMENT '组织类型 1:单位部门 2:项目工程 ',
`type` int(11) NOT NULL DEFAULT '1' COMMENT '类型 orgType=1时 1:单位 2:部门 orgType=2时 1:项目 2:部门',
`sort` int(11) DEFAULT NULL COMMENT '排序',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`company_info` varchar(255) DEFAULT NULL COMMENT '企业信息',
`division` int(11) DEFAULT NULL COMMENT '行政区划',
`social_credit_code` varchar(255) DEFAULT NULL COMMENT '社会信用代码',
`invitation_code` varchar(255) DEFAULT NULL COMMENT '邀请码',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='单位部门组织机构表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_org`
--
LOCK TABLES `sys_org` WRITE;
/*!40000 ALTER TABLE `sys_org` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_org` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_oss`
--
DROP TABLE IF EXISTS `sys_oss`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_oss` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '附件ID',
`source_id` varchar(50) DEFAULT NULL COMMENT '来源ID',
`file_name` varchar(200) DEFAULT NULL COMMENT '附件名称',
`new_name` varchar(200) DEFAULT NULL COMMENT '附件新名称',
`file_type` varchar(100) DEFAULT NULL COMMENT '附件类型',
`real_path` varchar(200) DEFAULT NULL COMMENT '附件存放地址',
`url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_oss`
--
LOCK TABLES `sys_oss` WRITE;
/*!40000 ALTER TABLE `sys_oss` DISABLE KEYS */;
INSERT INTO `sys_oss` VALUES (1,NULL,'60A479E1379FB901934C5D456FB_45215D29_51BF37.jpg','0afba901fd5f400f83ecd0ae48041266.jpg',NULL,'/Users/welfare/Downloads/home/upload/20230917/0afba901fd5f400f83ecd0ae48041266.jpg','/welfare/sys/oss/show/20230917/0afba901fd5f400f83ecd0ae48041266.jpg',1,'2023-09-17 20:44:27',NULL,NULL,0,NULL,NULL,NULL,NULL),(2,NULL,'984616f3c80e44d29ec99e8e60a9cd6b.png','970e6889a7184c6c951722bc5f16ba37.png',NULL,'/Users/welfare/Downloads/home/upload/20230917/970e6889a7184c6c951722bc5f16ba37.png','/welfare/sys/oss/show/20230917/970e6889a7184c6c951722bc5f16ba37.png',1,'2023-09-17 20:44:35',NULL,NULL,0,NULL,NULL,NULL,NULL),(3,NULL,'bianzhidezhulan_4706870.jpg','a76d011493ce4f41bf69082005f15d96.jpg',NULL,'/Users/welfare/Downloads/home/upload/20230917/a76d011493ce4f41bf69082005f15d96.jpg','/welfare/sys/oss/show/20230917/a76d011493ce4f41bf69082005f15d96.jpg',1,'2023-09-17 20:50:45',NULL,NULL,0,NULL,NULL,NULL,NULL),(4,NULL,'1.jpg','7d071d37d18b4549b269d8ccafc08c07.jpg',NULL,'/Users/welfare/Downloads/home/upload/20230917/7d071d37d18b4549b269d8ccafc08c07.jpg','/welfare/sys/oss/show/20230917/7d071d37d18b4549b269d8ccafc08c07.jpg',1,'2023-09-17 20:51:07',NULL,NULL,0,NULL,NULL,NULL,NULL),(5,NULL,'4.jpg','537d32cfb2764b0b909d50cb9349969f.jpg',NULL,'/Users/welfare/Downloads/home/upload/20230917/537d32cfb2764b0b909d50cb9349969f.jpg','/welfare/sys/oss/show/20230917/537d32cfb2764b0b909d50cb9349969f.jpg',1,'2023-09-17 20:51:14',NULL,NULL,0,NULL,NULL,NULL,NULL),(6,'ueditor','2.jpg','6c7e806323884aaca311cbb206022f76.jpg','ueditor','/Users/welfare/Downloads/home/upload/20231018/6c7e806323884aaca311cbb206022f76.jpg','/welfare/sys/oss/show/20231018/6c7e806323884aaca311cbb206022f76.jpg',NULL,'2023-10-18 21:50:19',NULL,NULL,0,NULL,NULL,NULL,NULL),(7,NULL,'4.jpg','3d6ed5e607264591a7c9367b04dfebe6.jpg',NULL,'/Users/welfare/Downloads/home/upload/20231018/3d6ed5e607264591a7c9367b04dfebe6.jpg','/welfare/sys/oss/show/20231018/3d6ed5e607264591a7c9367b04dfebe6.jpg',1,'2023-10-18 21:50:36',NULL,NULL,0,NULL,NULL,NULL,NULL),(8,'ueditor','2.jpg','a63b66d2a5d24459b75bf90b8f43bab5.jpg','ueditor','/www/wwwroot/welfare/Downloads/home/upload/20231018/a63b66d2a5d24459b75bf90b8f43bab5.jpg','/welfare/sys/oss/show/20231018/a63b66d2a5d24459b75bf90b8f43bab5.jpg',NULL,'2023-10-18 23:01:01',NULL,NULL,0,NULL,NULL,NULL,NULL),(9,NULL,'4.jpg','da8fc5f2c7ff47b988dfc83398a32baa.jpg',NULL,'/www/wwwroot/welfare/Downloads/home/upload/20231018/da8fc5f2c7ff47b988dfc83398a32baa.jpg','/welfare/sys/oss/show/20231018/da8fc5f2c7ff47b988dfc83398a32baa.jpg',1,'2023-10-18 23:01:12',NULL,NULL,0,NULL,NULL,NULL,NULL),(10,'ueditor','640.jpg','3a2e3c78ca904f229fed7f159b10e112.jpg','ueditor','/www/wwwroot/welfare/Downloads/home/upload/20231019/3a2e3c78ca904f229fed7f159b10e112.jpg','/welfare/sys/oss/show/20231019/3a2e3c78ca904f229fed7f159b10e112.jpg',NULL,'2023-10-19 17:09:50',NULL,NULL,0,NULL,NULL,NULL,NULL),(11,'ueditor','640.png','9e956428137b4400814f3c7a4955e983.png','ueditor','/www/wwwroot/welfare/Downloads/home/upload/20231019/9e956428137b4400814f3c7a4955e983.png','/welfare/sys/oss/show/20231019/9e956428137b4400814f3c7a4955e983.png',NULL,'2023-10-19 17:10:12',NULL,NULL,0,NULL,NULL,NULL,NULL),(12,'ueditor','640 (1).png','162cbae7dc4040a6a6b73c8d35439f7b.png','ueditor','/www/wwwroot/welfare/Downloads/home/upload/20231019/162cbae7dc4040a6a6b73c8d35439f7b.png','/welfare/sys/oss/show/20231019/162cbae7dc4040a6a6b73c8d35439f7b.png',NULL,'2023-10-19 17:10:34',NULL,NULL,0,NULL,NULL,NULL,NULL),(13,NULL,'640.png','8a8cf1756fe94b2fa56cc8e195af6e79.png',NULL,'/www/wwwroot/welfare/Downloads/home/upload/20231019/8a8cf1756fe94b2fa56cc8e195af6e79.png','/welfare/sys/oss/show/20231019/8a8cf1756fe94b2fa56cc8e195af6e79.png',1,'2023-10-19 17:11:45',NULL,NULL,0,NULL,NULL,NULL,NULL),(14,'ueditor','6401.jpg','7aebe3c3fb2b42acbb67dd7f0f25a8a7.jpg','ueditor','/www/wwwroot/welfare/Downloads/home/upload/20231025/7aebe3c3fb2b42acbb67dd7f0f25a8a7.jpg','/welfare/sys/oss/show/20231025/7aebe3c3fb2b42acbb67dd7f0f25a8a7.jpg',NULL,'2023-10-25 10:53:00',NULL,NULL,0,NULL,NULL,NULL,NULL),(15,'ueditor','6401 (1)
/*!40000 ALTER TABLE `sys_oss` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_role`
--
DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
`name` varchar(255) NOT NULL COMMENT '角色名称',
`code` varchar(255) DEFAULT NULL COMMENT '编码',
`sort` int(11) DEFAULT NULL COMMENT '排序',
`org_code` bigint(20) DEFAULT NULL COMMENT '角色所属组织编码',
`parent_id` bigint(20) DEFAULT '-1' COMMENT '父级角色ID',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统角色表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_role`
--
LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'超级管理员','super_manager',1,NULL,-1,1,'2023-06-09 15:05:53',NULL,NULL,1,1,'2023-06-09 15:05:53',NULL,NULL),(2,'平台管理员','platform_manager',2,NULL,-1,1,'2023-06-09 15:05:53',2,'2023-06-24 12:05:24',0,NULL,NULL,NULL,'test'),(3,'服务人员','service_user',3,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(4,'供养人员','support_user',4,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(5,'医养结合护理人员','tend_user',5,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_role_menu`
--
DROP TABLE IF EXISTS `sys_role_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
`menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统角色菜单表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_role_menu`
--
LOCK TABLES `sys_role_menu` WRITE;
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
INSERT INTO `sys_role_menu` VALUES (1,2,22),(2,2,24),(3,2,25),(4,2,23),(5,2,26),(6,2,27),(7,2,28),(8,2,29),(9,2,14),(10,2,15),(11,2,16),(12,2,17),(13,2,18),(14,2,19),(15,2,20),(16,2,21),(17,2,278),(18,2,279),(19,2,280),(20,2,281),(21,2,282),(22,2,283),(23,2,284),(24,2,285),(25,2,286),(26,2,287),(27,2,273),(28,2,274),(29,2,275),(30,2,276),(31,2,288);
/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_sms`
--
DROP TABLE IF EXISTS `sys_sms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_sms` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
`phone` varchar(11) NOT NULL COMMENT '手机号码',
`type` varchar(20) NOT NULL COMMENT 'type',
`code` varchar(6) NOT NULL COMMENT '验证码',
`sms_content` varchar(100) DEFAULT NULL COMMENT '短信内容',
`is_use` int(11) NOT NULL DEFAULT '0' COMMENT '是否使用 1-是 0-否',
`is_push` int(11) NOT NULL DEFAULT '0' COMMENT '是否推送 1-是 0-否',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统短信表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_sms`
--
LOCK TABLES `sys_sms` WRITE;
/*!40000 ALTER TABLE `sys_sms` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_sms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_user`
--
DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`name` varchar(30) NOT NULL COMMENT '真实名称',
`user_name` varchar(30) DEFAULT NULL COMMENT '用户名',
`nick_name` varchar(30) DEFAULT NULL COMMENT '用户昵称',
`email` varchar(50) DEFAULT NULL COMMENT '用户邮箱',
`phone` varchar(50) DEFAULT NULL COMMENT '手机号码',
`wx_open_id` varchar(50) DEFAULT NULL COMMENT '微信OpenId',
`sex` int(11) DEFAULT '0' COMMENT '用户性别 0-未知 1-男 2-女',
`avatar` varchar(100) DEFAULT NULL COMMENT '头像地址',
`password` varchar(100) DEFAULT NULL COMMENT '用户密码',
`salt` varchar(50) DEFAULT NULL COMMENT '用户SALT',
`status` int(11) DEFAULT '0' COMMENT '用户状态 0-停用 1-正常',
`login_ip` varchar(50) DEFAULT NULL COMMENT '最后登录IP',
`login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
`login_count` int(11) DEFAULT NULL COMMENT '登录次数',
`id_card_no` varchar(30) DEFAULT NULL COMMENT '身份证号码',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1-是,0-否',
`delete_by` bigint(20) DEFAULT NULL COMMENT '删除人ID',
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
`delete_reason` varchar(255) DEFAULT NULL COMMENT '删除理由',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_user`
--
LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` VALUES (1,'超级管理员','admin','超级管理员','1','13000000000',NULL,1,NULL,'4112fc4460b72ae2ba5ca5947d950034','21232f297a57a5a743894a0e4a801fc3',1,NULL,NULL,225,'000000000000000000',NULL,NULL,1,'2023-09-17 23:25:50',0,NULL,NULL,NULL,NULL),(2,'屈小丽','420500199901110011','屈小丽','1','13872572250',NULL,1,NULL,'789f753f1942350ff7502f73db0668c2','21232f297a57a5a743894a0e4a801fc3',1,NULL,NULL,128,'420500199901110011',NULL,NULL,1,'2023-09-14 23:14:08',1,1,'2023-10-20 17:18:48','人员删除',NULL),(8,'张三','500235199908273737','张三',NULL,'',NULL,1,NULL,'b8eaf743fe7806799ee3016658050268','8f0f9a0ca2be2bf2bf35ef583fe81629',1,NULL,NULL,0,'500235199908273737',NULL,'2023-09-13 17:36:50',1,'2023-10-17 15:45:49',1,1,'2023-10-20 17:18:44','人员删除',NULL),(9,'李四','500235199701253474','李四',NULL,'',NULL,1,NULL,'64d41d391c62544e4de5e8c329f070af','87a18cb20a45437bc6fd82ca39bba57c',1,NULL,NULL,0,'500235199701253474',NULL,'2023-09-13 18:04:31',NULL,NULL,1,1,'2023-09-14 19:53:49','人员删除',NULL),(11,'王五','420500197302012123','王五',NULL,'13872572251',NULL,0,NULL,'95d0a804e221c6e47cf168593f133a60','a5ae8302ba192f9d25cf81dbcca8723b',1,NULL,NULL,0,'420500197302012123',NULL,'2023-09-13 22:44:15',1,'2023-09-14 23:22:06',1,1,'2023-10-21 09:00:03','人员删除',NULL),(12,'张三三','500235199901110032','张三三',NULL,'13872577251',NULL,1,NULL,'6156a906326aadaad2e9e1c49a0bced9','35c6e8d6614fd083de64b526ee595052',1,NULL,NULL,0,'500235199901110032',NULL,'2023-09-14 20:17:46',1,'2023-10-17 15:54:55',1,1,'2023-10-20 17:24:05','人员删除',NULL),(15,'测试','11','测试',NULL,'',NULL,0,NULL,'304a25e9a3746f2aa4a85e09fce7b264','6512bd43d9caa6e02c990b0a82652dca',1,NULL,NULL,0,'11',NULL,'2023-09-14 20:42:33',NULL,NULL,1,1,'2023-09-14 20:42:37','人员删除',NULL),(16,'钱琦','420500196108123716','钱琦',NULL,'',NULL,1,NULL,'e2b2fe376796007a96e75361ec8dc32a','42056019d12634b1197662c6c71018ba',1,NULL,NULL,0,'420500196108123716',NULL,'2023-10-11 21:53:02',1,'2023-10-11 21:54:58',1,1,'2023-10-20 17:18:53','人员删除',NULL),(17,'黄士树','422721195610184736','黄士树',NULL,'',NULL,1,NULL,'f4aac305fe5c73c95294e278a4e44cc2','b2fa8bbc316e01eedf0475528a0aab35',1,NULL,NULL,0,'422721195610184736',NULL,'2023-10-19 17:23:18',NULL,NULL,0,NULL,NULL,NULL,NULL),(18,'张绿祥','422721193810264715','张绿祥',NULL,'',NULL,1,NULL,'4cde896c31d96027b4c6f2bc7fb8a7c8','b9d6af4517f1b72e4f2193933087f357',1,NULL,NULL,0,'422721193810264715',NULL,'2023-10-19 17:24:15',NULL,NULL,0,NULL,NULL,NULL,NULL),(19,'汪振扬','420521198706274710','汪振扬',NULL,'',NULL,1,NULL,'58085eb229378230aa1fdc2687eaa58a','3b3407c152fa14d6ec2871c9cefc821c',1,NULL,NULL,0,'420521198706274710',NULL,'2023-10-19 17:25:03',NULL,NULL,0,NULL,NULL,NULL,NULL),(20,'鲁自鹏','42272119630809366X','鲁自鹏',NULL,'13317561333',NULL,0,NULL,'0d97ecb0c6f8d2c15284e1ef7c080d31','ca91aca1ad2577c9df19d859dc9ff001',1,NULL,NULL,3,'42272119630809366X',NULL,'2023-10-20 17:24:01',1,'2023-11-04 15:02:12',0,NULL,NULL,NULL,NULL),(21,'谢俊维','420521198508023654','谢俊维',NULL,'15171734169',NULL,1,NULL,'27bd6d12a2ce919586c3075885e6d4d8','f23a69c5fdc2eae8a0e019a915929732',1,NULL,NULL,1,'420521198508023654',NULL,'2023-10-20 17:24:56',1,'2023-11-04 15:05:35',0,NULL,NULL,NULL,NULL),(22,'陈天庆','42272119630714471X','陈天庆',NULL,'13872601476',NULL,1,NULL,'286e36117953a6bbee3b866f2a880856','773abe1e28f6b97acca3fa1f20ca1ebd',1,NULL,NULL,2,'42272119630714471X',NULL,'2023-10-20 17:25:53',1,'2023-11-04 15:08:29',0,NULL,NULL,NULL,NULL),(23,'杨宏华','422721197504163666','杨宏华',NULL,'15171729742',NULL,0,NULL,'0ad0a32f05c9bdb9c3b74ae15e1b705f','127a20cebafd7328520f82a5b8b677d2',1,NULL,NULL,0,'422721197504163666',NULL,'2023-10-20 17:26:40',1,'2023-11-04 15:13:12',0,NULL,NULL,NULL,NULL),(24,'夏金琴','422721197212073669','夏金琴',NULL,'13487295667',NULL,0,NULL,'c9f1dc99cab468ae4cb0b8abd7b37f2a','2d7135a66ca0d8e5d8d21e018a1d3c2b',1,NULL,NULL,0,'422721197212073669',NULL,'2023-10-20 17:27:25',1,'2023-11-04 15:16:41',0,NULL,NULL,NULL,NULL)
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_user_role`
--
DROP TABLE IF EXISTS `sys_user_role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
`role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统用户角色表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_user_role`
--
LOCK TABLES `sys_user_role` WRITE;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` VALUES (1,1,2),(13,17,4),(14,18,4),(15,19,4),(19,23,3),(20,24,3),(21,25,3),(22,26,3),(23,27,4),(24,28,4),(25,29,4),(26,30,4),(27,31,4),(28,32,4),(30,34,4),(31,35,4),(32,36,4),(33,37,4),(34,38,4),(35,39,4),(36,40,4),(37,41,4),(39,43,4),(40,44,4),(41,45,4),(42,46,4),(43,47,4),(44,48,4),(45,49,4),(46,50,4),(47,51,4),(48,52,4),(49,53,4),(50,54,4),(51,55,4),(52,56,4),(53,57,4),(54,58,4),(55,59,4),(56,60,4),(57,61,4),(58,62,4),(59,63,4),(60,64,4),(61,65,4),(62,66,4),(63,67,4),(64,68,4),(65,69,4),(66,70,4),(67,71,4),(68,72,4),(69,73,4),(70,74,4),(71,75,4),(72,76,4),(73,77,4),(74,78,4),(75,79,4),(76,80,4),(77,81,4),(78,82,4),(79,83,4),(80,84,4),(81,85,4),(82,86,4),(83,87,4),(84,88,4),(85,89,4),(86,90,4),(87,91,4),(88,92,4),(89,93,4),(90,94,4),(91,95,4),(92,96,4),(93,97,4),(94,98,4),(95,99,4),(96,100,4),(97,101,4),(98,102,4),(99,103,4),(100,104,4),(102,106,4),(103,107,4),(104,108,4),(106,110,4),(107,111,4),(108,112,4),(109,113,4),(110,114,4),(111,115,4),(113,117,4),(114,118,4),(115,119,4),(116,120,4),(117,121,4),(118,122,4),(119,123,4),(120,124,4),(121,125,4),(122,126,4),(123,127,4),(124,128,4),(125,129,4),(126,130,4),(127,131,4),(128,132,4),(129,133,4),(130,134,4),(131,135,4),(132,136,4),(133,137,4),(134,138,4),(135,139,4),(136,140,4),(137,141,4),(138,142,4),(139,143,4),(140,144,4),(141,145,4),(142,146,4),(143,147,4),(144,148,4),(145,149,4),(146,150,4),(147,151,4),(148,152,4),(149,153,4),(150,154,4),(151,155,4),(152,156,4),(153,157,4),(154,158,4),(155,159,4),(156,160,4),(157,161,4),(158,162,4),(159,163,4),(160,164,4),(161,165,4),(162,166,4),(163,167,4),(164,168,4),(165,169,4),(166,170,4),(167,171,4),(168,172,4),(169,173,4),(170,174,4),(171,175,4),(172,176,4),(174,178,4),(175,179,4),(176,180,4),(177,181,4),(178,182,4),(179,183,4),(180,184,4),(181,185,4),(182,186,4),(183,187,4),(184,188,4),(185,189,4),(186,190,4),(187,191,4),(188,192,4),(189,193,4),(190,194,4),(191,195,4),(192,196,4),(193,197,4),(194,198,4),(195,199,4),(196,200,4),(197,201,4),(198,202,4),(199,203,4),(200,204,4),(201,205,4),(202,206,4),(203,207,4),(204,208,4),(205,209,4),(206,210,4),(207,211,4),(208,212,4),(209,213,4),(210,214,4),(211,215,4),(212,216,4),(214,218,4),(215,219,4),(216,220,4),(217,221,4),(218,222,4),(219,223,4),(220,224,4),(221,225,4),(222,226,4),(223,227,4),(224,228,4),(225,229,4),(226,230,4),(227,231,4),(228,232,4),(230,234,4),(231,235,4),(232,236,4),(233,237,4),(234,238,4),(235,239,4),(236,240,4),(237,241,4),(238,242,4),(239,243,4),(240,244,4),(241,245,4),(242,246,4),(243,20,3),(244,20,2),(245,21,3),(246,21,2),(247,22,3),(248,22,2),(249,247,4);
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping events for database 'welfare'
--
--
-- Dumping routines for database 'welfare'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-11-24 10:42:12