/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50740
Source Host           : localhost:3306
Source Database       : law-enforcement

Target Server Type    : MYSQL
Target Server Version : 50740
File Encoding         : 65001

Date: 2025-05-11 10:37:15
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bus_law_enforcement
-- ----------------------------
DROP TABLE IF EXISTS `bus_law_enforcement`;
CREATE TABLE `bus_law_enforcement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `case_number` varchar(20) NOT NULL COMMENT '案件编号',
  `case_type` varchar(50) NOT NULL COMMENT '案件类型',
  `case_title` varchar(100) NOT NULL COMMENT '案件标题',
  `case_description` text COMMENT '案件描述',
  `involved_person` varchar(50) DEFAULT NULL COMMENT '涉案人员',
  `involved_company` varchar(100) DEFAULT NULL COMMENT '涉案企业',
  `case_amount` decimal(15,2) DEFAULT NULL COMMENT '涉案金额',
  `case_location` varchar(100) NOT NULL COMMENT '案发地点',
  `case_time` datetime NOT NULL COMMENT '案发时间',
  `law_enforcement_officer` varchar(50) NOT NULL COMMENT '执法人员',
  `enforcement_department` varchar(100) NOT NULL COMMENT '执法部门',
  `enforcement_action` varchar(50) NOT NULL COMMENT '执法行为',
  `punishment_type` varchar(50) DEFAULT NULL COMMENT '处罚类型',
  `punishment_amount` decimal(15,2) DEFAULT NULL COMMENT '处罚金额',
  `case_status` varchar(20) NOT NULL COMMENT '案件状态',
  `filing_time` datetime NOT NULL COMMENT '立案时间',
  `closing_time` datetime DEFAULT NULL COMMENT '结案时间',
  `evidence_list` text COMMENT '证据清单',
  `legal_basis` varchar(200) NOT NULL COMMENT '法律依据',
  `remark` text COMMENT '备注',
  `hex_id` varchar(500) DEFAULT NULL COMMENT '哈希',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `case_number` (`case_number`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COMMENT='业务需求—执法数据表';

-- ----------------------------
-- Records of bus_law_enforcement
-- ----------------------------
INSERT INTO `bus_law_enforcement` VALUES ('1', '2023-JC-001', '经济犯罪', '某公司偷税漏税案', '该公司通过虚假账目逃避税收', '张某', '某科技有限公司', '500000.00', '北京市朝阳区', '2023-01-15 09:30:00', '王警官', '北京市税务局稽查局', '税务稽查', '罚款', '150000.00', '已结案', '2023-01-20 10:00:00', '2023-03-10 16:30:00', '账本复印件,银行流水,证人证言', '《中华人民共和国税收征收管理法》第六十三条', '当事人已缴纳罚款', '0x940ece4ab9c708e8fe2492a24c194762bbd054bc664955b100a3fc0a5fd52027', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('2', '2023-XF-002', '消费欺诈', '某商场虚假宣传案', '该商场销售假冒伪劣商品并虚假宣传', null, '某购物中心有限公司', '200000.00', '上海市浦东新区', '2023-02-10 14:15:00', '李警官', '上海市市场监督管理局', '现场检查', '罚款+责令整改', '50000.00', '已结案', '2023-02-12 09:00:00', '2023-04-01 11:20:00', '商品样品,销售记录,广告宣传材料', '《中华人民共和国消费者权益保护法》第五十六条', '商家已整改完毕', '0x28460454275b0a882f8cf03be619e39190813af5619f2c163e3bd45174865122', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('3', '2023-HJ-003', '环境污染', '某工厂非法排污案', '该工厂未经处理直接排放工业废水', '李某', '某化工有限公司', null, '广州市白云区', '2023-03-05 08:00:00', '陈警官', '广东省生态环境厅', '取样检测', '责令停产+罚款', '300000.00', '处理中', '2023-03-08 14:30:00', null, '水质检测报告,现场照片,生产记录', '《中华人民共和国环境保护法》第六十条', '案件正在处理中', '0xa4641b0dffc3865c01131e7f4dc95274303c6cc6fbad610d49376f075697ca03', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('4', '2023-WS-004', '食品安全', '某餐厅使用过期食材案', '该餐厅使用过期食材制作食品', null, '某餐饮有限公司', null, '成都市武侯区', '2023-04-12 11:45:00', '赵警官', '成都市食品药品监督管理局', '突击检查', '罚款+吊销许可证', '100000.00', '已结案', '2023-04-15 10:30:00', '2023-05-20 15:00:00', '食材样品,监控录像,顾客投诉记录', '《中华人民共和国食品安全法》第一百二十四条', '餐厅已停业整顿', '0x8642427984988a52b1f4a4791962df8aa6e343fb65c7e988d7b0291cf870e7ee', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('5', '2023-ZJ-005', '知识产权', '某公司侵犯商标权案', '该公司生产销售假冒知名品牌商品', '王某', '某服饰有限公司', '800000.00', '杭州市余杭区', '2023-05-20 13:20:00', '孙警官', '浙江省市场监督管理局', '查封扣押', '罚款+没收违法所得', '400000.00', '已结案', '2023-05-25 09:15:00', '2023-07-10 14:00:00', '假冒商品,销售记录,商标注册证', '《中华人民共和国商标法》第六十条', '当事人已缴纳罚款', '0xe69b6c18642960d896081dedc19136da1b796ba82c548f67ce19187ad0b7f070', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('6', '2023-LD-006', '劳动纠纷', '某企业拖欠工资案', '该企业长期拖欠员工工资', '刘某', '某制造有限公司', '350000.00', '深圳市龙岗区', '2023-06-08 10:00:00', '周警官', '深圳市人力资源和社会保障局', '调查取证', '责令支付+罚款', '50000.00', '已结案', '2023-06-10 14:30:00', '2023-07-05 11:00:00', '工资单,劳动合同,员工证言', '《中华人民共和国劳动法》第九十一条', '工资已全部支付完毕', '0xe5b3d8d9acdd5700ba1c791bdea280ea8e41da0091475dcddabde67843cd8888', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('7', '2023-JS-007', '建设违规', '某工地违规施工案', '该工地未取得施工许可擅自开工', null, '某建筑工程有限公司', null, '南京市鼓楼区', '2023-07-15 09:00:00', '吴警官', '南京市城乡建设委员会', '现场检查', '责令停工+罚款', '200000.00', '处理中', '2023-07-18 15:30:00', null, '现场照片,施工日志,规划文件', '《中华人民共和国建筑法》第六十四条', '案件正在处理中', '0xfb25ca515c8ac3903ce37a8750fbd7f28f8704b66ac00e0656114693a4ffa3b9', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('8', '2023-JR-008', '金融违规', '某金融机构违规放贷案', '该机构违反规定向不符合条件客户放贷', '钱某', '某商业银行支行', '1200000.00', '天津市和平区', '2023-08-10 14:00:00', '郑警官', '中国银行保险监督管理委员会', '审计调查', '罚款+业务限制', '500000.00', '已结案', '2023-08-15 10:30:00', '2023-10-05 16:00:00', '贷款合同,审批记录,客户资料', '《中华人民共和国银行业监督管理法》第四十五条', '已整改完毕', '0x291c9e2b574308095506614096a79013f5a814ff3876b9f11888dc2aefe1d9d4', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('9', '2023-YL-009', '医疗违规', '某医院乱收费案', '该医院违规收取不合理医疗费用', null, '某三甲医院', '250000.00', '武汉市武昌区', '2023-09-05 10:30:00', '冯警官', '湖北省卫生健康委员会', '数据核查', '退款+罚款', '100000.00', '已结案', '2023-09-10 14:00:00', '2023-11-15 11:30:00', '收费清单,病历记录,患者证言', '《医疗机构管理条例》第三十七条', '已退还多收费用', '0xb90cf70ab560653f32929eaaa51172e1d948604c4d3b4dba77d24459e6d20811', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('10', '2023-JY-010', '教育违规', '某培训机构虚假宣传案', '该机构虚假承诺保过名校', '李某', '某教育咨询有限公司', '500000.00', '西安市雁塔区', '2023-10-12 13:45:00', '董警官', '陕西省教育厅', '暗访调查', '罚款+责令整改', '150000.00', '处理中', '2023-10-15 09:30:00', null, '宣传材料,合同文本,学员证言', '《中华人民共和国民办教育促进法》第六十二条', '案件正在处理中', '0xa3f673a25ff9554c4552cb65e236843e7ccabf4f6f8a67a926f0ce025508e611', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('11', '2023-GA-011', '治安管理', '某娱乐场所涉黄案', '该场所涉嫌组织卖淫活动', '黄某', '某娱乐会所', null, '长沙市天心区', '2023-11-08 22:30:00', '林警官', '长沙市公安局治安支队', '突击检查', '责令停业+罚款', '300000.00', '已结案', '2023-11-10 10:00:00', '2023-12-20 15:30:00', '监控录像,交易记录,证人证言', '《中华人民共和国治安管理处罚法》第六十六条', '场所已关闭', '0x6a118f7e3eb8ce4a7710fe79fdaccd9ea3e3ddd9ac1617bc34c125e28002cf02', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('12', '2023-NY-012', '农业违规', '某农场使用禁用农药案', '该农场在蔬菜种植中使用禁用农药', '赵某', '某生态农场', null, '郑州市惠济区', '2023-12-05 09:00:00', '徐警官', '河南省农业农村厅', '抽样检测', '罚款+销毁产品', '200000.00', '已结案', '2023-12-08 14:30:00', '2024-01-15 11:00:00', '农药样品,蔬菜样本,销售记录', '《中华人民共和国农产品质量安全法》第三十三条', '问题产品已销毁', '0xa7523fe9ff6cdcfea0553c3f9fcc9ae15edde3a2807fdaeb5d0ad1027e4c2739', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('13', '2023-DS-013', '电商违规', '某网店销售假货案', '该网店销售假冒名牌手表', '周某', null, '600000.00', '网络平台', '2024-01-10 00:00:00', '高警官', '国家市场监督管理总局', '网络巡查', '罚款+关闭店铺', '300000.00', '已结案', '2024-01-15 10:30:00', '2024-02-28 16:00:00', '商品照片,交易记录,鉴定报告', '《中华人民共和国电子商务法》第八十五条', '网店已关闭', '0xc1e8cf51d85a97dcef56dea12523ea3a2a5dc7b346c877f53c0649f34821b25e', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('14', '2024-CJ-014', '城建违规', '某开发商违规售房案', '该开发商未取得预售许可违规销售', null, '某房地产开发有限公司', '20000000.00', '青岛市市南区', '2024-02-15 10:00:00', '郭警官', '青岛市住房和城乡建设局', '调查取证', '罚款+暂停资质', '1000000.00', '处理中', '2024-02-20 14:30:00', null, '销售合同,收款凭证,审批文件', '《城市房地产开发经营管理条例》第三十六条', '案件正在处理中', '0x022ed7421753aefcbee20e470665defc9d871609aad9c051783a7fa576998a56', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('15', '2024-TY-015', '体育违规', '某俱乐部打假球案', '该俱乐部在比赛中故意输球', '钱某', '某足球俱乐部', '500000.00', '大连市中山区', '2024-03-08 15:00:00', '马警官', '中国足球协会纪律委员会', '调查取证', '罚款+扣分', '200000.00', '已结案', '2024-03-10 10:30:00', '2024-04-15 14:00:00', '比赛录像,通讯记录,证人证言', '《中国足球协会纪律准则》第六十条', '俱乐部已接受处罚', '0x6e219f48a9e000af9a17c6cb15d585664634aeaca8b733157bd3e4ee13190a06', '2025-05-04 10:45:47', '2025-05-04 10:45:47');
INSERT INTO `bus_law_enforcement` VALUES ('16', '2024-JS-016', '建设违规', '某工地安全事故案', '该工地发生脚手架坍塌事故', '孙某', '某建设集团有限公司', null, '苏州市工业园区', '2024-04-10 08:30:00', '朱警官', '江苏省住房和城乡建设厅', '事故调查', '罚款+停工整顿', '500000.00', '已结案', '2024-04-12 10:00:00', '2024-06-15 14:30:00', '事故现场照片,施工日志,安全记录', '《建设工程安全生产管理条例》第六十四条', '工地已完成整改', '0x2f422124bf9341ebdd7666be8e452d4e4fbcdb0739de8c13bcacc49e321ebd95', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('17', '2024-SP-017', '食品安全', '某超市销售变质食品案', '该超市销售过期变质肉类产品', null, '某连锁超市有限公司', null, '重庆市渝中区', '2024-05-08 11:00:00', '秦警官', '重庆市市场监督管理局', '抽样检查', '罚款+下架产品', '80000.00', '已结案', '2024-05-10 09:30:00', '2024-06-20 16:00:00', '食品样品,进货记录,监控录像', '《中华人民共和国食品安全法》第三十四条', '问题产品已全部下架', '0xb80e83140f35d2f0cb336ca0d230b1964445939dd4aec5cf40b1677b76975d8a', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('18', '2024-HB-018', '环保违规', '某企业噪音扰民案', '该企业夜间生产噪音超标', null, '某机械制造有限公司', null, '长沙市岳麓区', '2024-06-15 22:00:00', '许警官', '湖南省生态环境厅', '噪音监测', '罚款+限时生产', '100000.00', '处理中', '2024-06-18 14:00:00', null, '噪音检测报告,居民投诉记录', '《中华人民共和国环境噪声污染防治法》第五十九条', '企业已调整生产时间', '0x0e7c5adf47f4b21f14091ee6b6466af64150d90df81f184288ee1b6dd412c93a', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('19', '2024-JR-019', '金融违规', '某P2P平台非法集资案', '该平台涉嫌非法吸收公众存款', '陈某', '某金融信息服务有限公司', '5000000.00', '上海市浦东新区', '2024-07-05 10:00:00', '何警官', '上海市金融监督管理局', '查封账户', '罚款+刑事立案', '2000000.00', '已结案', '2024-07-10 09:30:00', '2024-09-20 15:00:00', '资金流水,投资人证言,平台数据', '《非法金融机构和非法金融业务活动取缔办法》第四条', '案件已移交司法机关', '0xb79f98ff31e0ccc591847a165f4f5824e31e94fc34d8dd93aa3dae37f9dd6724', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('20', '2024-ZS-020', '知识产权', '某网店盗版软件案', '该网店销售盗版专业软件', '林某', null, '300000.00', '网络平台', '2024-08-12 00:00:00', '邓警官', '国家版权局', '网络巡查', '罚款+关闭店铺', '150000.00', '已结案', '2024-08-15 10:30:00', '2024-09-28 16:00:00', '软件样本,销售记录,鉴定报告', '《中华人民共和国著作权法》第五十三条', '网店已关闭', '0x63c2ba49f5603c79ed4b40d87700caaa76a3786639b3de0c2a76ee5eb1a364fc', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('21', '2024-LD-021', '劳动纠纷', '某工厂违法加班案', '该工厂强制员工超时加班', '王某', '某电子制造有限公司', null, '东莞市长安镇', '2024-09-10 08:00:00', '钟警官', '广东省人力资源和社会保障厅', '员工访谈', '罚款+限期整改', '120000.00', '已结案', '2024-09-12 14:30:00', '2024-10-25 11:00:00', '考勤记录,工资单,员工证言', '《中华人民共和国劳动法》第四十一条', '工厂已调整工作时间', '0x1e79ef50141bca458b8090b2c96fb7a2a483ed18c612c24cc812d4c386b57fdd', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('22', '2024-WH-022', '文化违规', '某书店非法出版物案', '该书店销售非法政治类出版物', null, '某图书有限公司', null, '北京市海淀区', '2024-10-15 14:00:00', '彭警官', '北京市文化市场综合执法总队', '突击检查', '没收+罚款', '200000.00', '处理中', '2024-10-18 10:30:00', null, '出版物样本,进货渠道记录', '《出版管理条例》第六十二条', '案件正在处理中', '0x8d867b2a1fa935931a4fabf8a7f08a424729abf31440f352d57c884ef507b03c', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('23', '2024-JD-023', '交通违规', '某物流公司超载案', '该公司车辆长期超载运输', '刘某', '某物流运输有限公司', null, '武汉市东西湖区', '2024-11-08 09:30:00', '袁警官', '湖北省交通运输厅', '路面检查', '罚款+扣分', '80000.00', '已结案', '2024-11-10 14:00:00', '2024-12-15 16:30:00', '过磅记录,监控录像,运输合同', '《中华人民共和国道路交通安全法》第九十二条', '公司已整改', '0x425e9980cfef40172845a8a7f0b03e4f6cd3bd243f5f80c6f7b5b6e466fb6e8d', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('24', '2024-NY-024', '农业违规', '某养殖场违禁药物案', '该养殖场使用违禁饲料添加剂', '赵某', '某畜牧养殖有限公司', null, '成都市双流区', '2024-12-05 10:00:00', '崔警官', '四川省农业农村厅', '抽样检测', '罚款+销毁产品', '150000.00', '已结案', '2024-12-08 14:30:00', '2025-01-20 11:00:00', '饲料样本,检测报告,销售记录', '《饲料和饲料添加剂管理条例》第三十九条', '问题产品已销毁', '0xc8ef347b80e0dbb9734d616ce4430a8082451f38d69bd71d9c94536e3b9bfadc', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('25', '2024-YL-025', '医疗违规', '某诊所非法行医案', '该诊所使用无资质人员行医', '李某', '某综合诊所', null, '南京市鼓楼区', '2025-01-10 09:00:00', '陆警官', '江苏省卫生健康委员会', '暗访调查', '罚款+吊销执照', '120000.00', '已结案', '2025-01-15 10:30:00', '2025-03-01 14:00:00', '就诊记录,人员资质证明', '《医疗机构管理条例》第四十四条', '诊所已关闭', '0xb9bcb7079a70afb4cfe4af9bc1872967676bec574bedf3c49895c75eb98f55e5', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('26', '2025-JS-026', '建设违规', '某楼盘质量缺陷案', '该楼盘存在严重建筑质量问题', null, '某房地产开发有限公司', '10000000.00', '广州市天河区', '2025-02-15 10:00:00', '江警官', '广东省住房和城乡建设厅', '质量检测', '罚款+限期整改', '500000.00', '处理中', '2025-02-20 14:30:00', null, '检测报告,业主投诉记录', '《建设工程质量管理条例》第五十六条', '开发商正在整改', '0x714e8e1f99ed484bc698fb8785cef0cc884036696d69a7fbe101c3852d108754', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('27', '2025-SP-027', '食品安全', '某食品厂卫生不达标案', '该厂生产环境不符合卫生标准', null, '某食品加工厂', null, '天津市西青区', '2025-03-08 09:30:00', '韩警官', '天津市市场监督管理委员会', '现场检查', '罚款+停产整顿', '180000.00', '已结案', '2025-03-10 10:00:00', '2025-04-25 15:30:00', '现场照片,检测报告,生产记录', '《中华人民共和国食品安全法》第一百二十六条', '工厂已完成整改', '0x4dfed620504abaec6c8e5314e19c34175638de5cd39cbdd18ded66a312b52706', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('28', '2025-HJ-028', '环境污染', '某企业废气超标排放案', '该企业废气处理设施不正常运行', '钱某', '某化工有限公司', null, '宁波市镇海区', '2025-04-10 08:00:00', '杨警官', '浙江省生态环境厅', '在线监测', '罚款+限产', '250000.00', '处理中', '2025-04-15 14:30:00', null, '监测数据,运行记录', '《中华人民共和国大气污染防治法》第九十九条', '企业正在整改', '0xb00cad305ba05ede0284530b1ac23ae4e3366c3562280dfeddf1e38cb4dbd606', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('29', '2025-JR-029', '金融违规', '某证券公司内幕交易案', '该公司员工涉嫌利用内幕信息交易', '周某', '某证券股份有限公司', '3000000.00', '深圳市福田区', '2025-05-12 10:30:00', '曹警官', '中国证券监督管理委员会', '数据筛查', '罚款+市场禁入', '2000000.00', '已结案', '2025-05-15 09:00:00', '2025-07-20 16:00:00', '交易记录,通讯记录,账户流水', '《中华人民共和国证券法》第一百九十一条', '案件已移交司法机关', '0xcea553b3e0a1411520e928dcb8376062ca56c041caaa45ca57fa8bf9bbf92425', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('30', '2025-ZJ-030', '经济犯罪', '某公司合同诈骗案', '该公司通过虚假合同骗取货款', '吴某', '某贸易有限公司', '2000000.00', '杭州市萧山区', '2025-06-08 14:00:00', '魏警官', '浙江省公安厅经侦总队', '调查取证', '刑事立案', null, '已结案', '2025-06-10 10:30:00', '2025-08-15 14:30:00', '合同文本,资金流向,证人证言', '《中华人民共和国刑法》第二百二十四条', '案件已移交检察机关', '0xadd4bd56021510d951eefd6425d768b1d8615d922994f7293804926031a637e8', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('31', '2025-XF-031', '消费欺诈', '某4S店欺诈销售案', '该店将事故车作为新车销售', null, '某汽车销售服务有限公司', '800000.00', '西安市未央区', '2025-07-15 11:00:00', '吕警官', '陕西省市场监督管理局', '技术鉴定', '退一赔三+罚款', '500000.00', '已结案', '2025-07-18 14:30:00', '2025-09-10 15:00:00', '车辆检测报告,销售合同,维修记录', '《中华人民共和国消费者权益保护法》第五十五条', '已赔偿消费者', '0x09e4d7a9337c0b1643093a9f323c72de3edd271fa3986be520e41bb0c59c70de', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('32', '2025-WS-032', '卫生违规', '某酒店卫生不达标案', '该酒店客房卫生严重不达标', null, '某国际酒店管理有限公司', null, '三亚市吉阳区', '2025-08-20 09:30:00', '蒋警官', '海南省卫生健康委员会', '暗访检查', '罚款+限期整改', '150000.00', '处理中', '2025-08-22 10:00:00', null, '检测报告,现场照片', '《公共场所卫生管理条例》第十四条', '酒店正在整改', '0xd96b6f0b4e90067b6fafa0f7f6226c6e785d776a68674e9f4937f6a83010b64d', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('33', '2025-JY-033', '教育违规', '某学校乱收费案', '该学校违规收取赞助费等费用', '张某', '某私立学校', '1200000.00', '青岛市市北区', '2025-09-10 10:30:00', '沈警官', '山东省教育厅', '家长访谈', '退款+罚款', '300000.00', '已结案', '2025-09-15 14:00:00', '2025-11-20 16:30:00', '收费凭证,家长证言', '《中华人民共和国教育法》第七十八条', '已退还违规收费', '0x160a500d2dbb1c987af6bf951d67afe87a8ed2b6a74cfc0cecc3693f39df984f', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('34', '2025-TY-034', '体育违规', '某运动员使用兴奋剂案', '该运动员比赛期间使用违禁药物', '李某', null, null, '北京市朝阳区', '2025-10-15 00:00:00', '范警官', '国家体育总局反兴奋剂中心', '尿样检测', '取消成绩+禁赛', null, '已结案', '2025-10-18 10:30:00', '2025-12-01 14:00:00', '检测报告,比赛录像', '《反兴奋剂条例》第四十六条', '运动员已接受处罚', '0x810e261a299aa8cedd6700113d4188d68e32945f19c86acf29ca9af6a3d4bf00', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('35', '2025-GA-035', '治安管理', '某酒吧打架斗殴案', '该酒吧发生群体性斗殴事件', '王某', '某娱乐管理有限公司', null, '上海市静安区', '2025-11-08 23:30:00', '方警官', '上海市公安局治安总队', '现场处置', '罚款+停业整顿', '200000.00', '处理中', '2025-11-10 10:00:00', null, '监控录像,伤情鉴定,证人证言', '《中华人民共和国治安管理处罚法》第二十六条', '酒吧正在停业整顿', '0x786a616d479449478c387d6739af3460f78812f514781be4b5a00e014e48920f', '2025-05-04 10:49:25', '2025-05-04 10:49:25');
INSERT INTO `bus_law_enforcement` VALUES ('36', '1112134-123ADF', '交通违规', '交通红灯', '交通红灯', '唐某某', '某某滴滴公司', '30000.00', '上海市浦东新区', '2025-05-09 21:33:01', '陈某某', '交通执法部门', '缴纳罚款', '罚款', '20000.00', '处理中', '2025-05-09 21:33:49', null, 'xxx', 'xx', 'aadf', '0x37220718e2e7bfb56a2ccd2c975b88b4e566076ed3098a9ff1c4d5b1a7a3b3e0', '2025-05-09 21:33:55', '2025-05-09 21:33:55');

-- ----------------------------
-- Table structure for bus_law_enforcement_chain
-- ----------------------------
DROP TABLE IF EXISTS `bus_law_enforcement_chain`;
CREATE TABLE `bus_law_enforcement_chain` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `law_id` int(11) NOT NULL COMMENT '案件id',
  `case_number` varchar(20) DEFAULT NULL COMMENT '案件编号',
  `case_type` varchar(50) DEFAULT NULL COMMENT '案件类型',
  `case_title` varchar(100) DEFAULT NULL COMMENT '案件标题',
  `case_description` text COMMENT '案件描述',
  `involved_person` varchar(50) DEFAULT NULL COMMENT '涉案人员',
  `involved_company` varchar(100) DEFAULT NULL COMMENT '涉案企业',
  `case_amount` decimal(15,2) DEFAULT NULL COMMENT '涉案金额',
  `case_location` varchar(100) DEFAULT NULL COMMENT '案发地点',
  `case_time` datetime DEFAULT NULL COMMENT '案发时间',
  `law_enforcement_officer` varchar(50) DEFAULT NULL COMMENT '执法人员',
  `enforcement_department` varchar(100) DEFAULT NULL COMMENT '执法部门',
  `enforcement_action` varchar(50) DEFAULT NULL COMMENT '执法行为',
  `punishment_type` varchar(50) DEFAULT NULL COMMENT '处罚类型',
  `punishment_amount` decimal(15,2) DEFAULT NULL COMMENT '处罚金额',
  `case_status` varchar(20) DEFAULT NULL COMMENT '案件状态',
  `filing_time` datetime DEFAULT NULL COMMENT '立案时间',
  `closing_time` datetime DEFAULT NULL COMMENT '结案时间',
  `evidence_list` text COMMENT '证据清单',
  `legal_basis` varchar(200) DEFAULT NULL COMMENT '法律依据',
  `remark` text COMMENT '备注',
  `hex_id` varchar(500) DEFAULT NULL COMMENT '上链哈希',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=406 DEFAULT CHARSET=utf8mb4 COMMENT='业务需求—执法数据表-链路';

-- ----------------------------
-- Records of bus_law_enforcement_chain
-- ----------------------------
INSERT INTO `bus_law_enforcement_chain` VALUES ('352', '1', '2023-JC-001', '经济犯罪', '某公司偷税漏税案', '该公司通过虚假账目逃避税收', '张某', '某科技有限公司', '500000.00', '北京市朝阳区', '2023-01-15 09:30:00', '王警官', '北京市税务局稽查局', '税务稽查', '罚款', '150000.00', '已结案', '2023-01-20 10:00:00', '2023-03-10 16:30:00', '账本复印件,银行流水,证人证言', '《中华人民共和国税收征收管理法》第六十三条', '当事人已缴纳罚款', '0x940ece4ab9c708e8fe2492a24c194762bbd054bc664955b100a3fc0a5fd52027', '2025-05-08 20:06:11');
INSERT INTO `bus_law_enforcement_chain` VALUES ('353', '2', '2023-XF-002', '消费欺诈', '某商场虚假宣传案', '该商场销售假冒伪劣商品并虚假宣传', null, '某购物中心有限公司', '200000.00', '上海市浦东新区', '2023-02-10 14:15:00', '李警官', '上海市市场监督管理局', '现场检查', '罚款+责令整改', '50000.00', '已结案', '2023-02-12 09:00:00', '2023-04-01 11:20:00', '商品样品,销售记录,广告宣传材料', '《中华人民共和国消费者权益保护法》第五十六条', '商家已整改完毕', '0x28460454275b0a882f8cf03be619e39190813af5619f2c163e3bd45174865122', '2025-05-08 20:06:11');
INSERT INTO `bus_law_enforcement_chain` VALUES ('354', '3', '2023-HJ-003', '环境污染', '某工厂非法排污案', '该工厂未经处理直接排放工业废水', '李某', '某化工有限公司', null, '广州市白云区', '2023-03-05 08:00:00', '陈警官', '广东省生态环境厅', '取样检测', '责令停产+罚款', '300000.00', '处理中', '2023-03-08 14:30:00', null, '水质检测报告,现场照片,生产记录', '《中华人民共和国环境保护法》第六十条', '案件正在处理中', '0xa4641b0dffc3865c01131e7f4dc95274303c6cc6fbad610d49376f075697ca03', '2025-05-08 20:06:12');
INSERT INTO `bus_law_enforcement_chain` VALUES ('355', '4', '2023-WS-004', '食品安全', '某餐厅使用过期食材案', '该餐厅使用过期食材制作食品', null, '某餐饮有限公司', null, '成都市武侯区', '2023-04-12 11:45:00', '赵警官', '成都市食品药品监督管理局', '突击检查', '罚款+吊销许可证', '100000.00', '已结案', '2023-04-15 10:30:00', '2023-05-20 15:00:00', '食材样品,监控录像,顾客投诉记录', '《中华人民共和国食品安全法》第一百二十四条', '餐厅已停业整顿', '0x8642427984988a52b1f4a4791962df8aa6e343fb65c7e988d7b0291cf870e7ee', '2025-05-08 20:06:12');
INSERT INTO `bus_law_enforcement_chain` VALUES ('356', '5', '2023-ZJ-005', '知识产权', '某公司侵犯商标权案', '该公司生产销售假冒知名品牌商品', '王某', '某服饰有限公司', '800000.00', '杭州市余杭区', '2023-05-20 13:20:00', '孙警官', '浙江省市场监督管理局', '查封扣押', '罚款+没收违法所得', '400000.00', '已结案', '2023-05-25 09:15:00', '2023-07-10 14:00:00', '假冒商品,销售记录,商标注册证', '《中华人民共和国商标法》第六十条', '当事人已缴纳罚款', '0xe69b6c18642960d896081dedc19136da1b796ba82c548f67ce19187ad0b7f070', '2025-05-08 20:06:12');
INSERT INTO `bus_law_enforcement_chain` VALUES ('357', '6', '2023-LD-006', '劳动纠纷', '某企业拖欠工资案', '该企业长期拖欠员工工资', '刘某', '某制造有限公司', '350000.00', '深圳市龙岗区', '2023-06-08 10:00:00', '周警官', '深圳市人力资源和社会保障局', '调查取证', '责令支付+罚款', '50000.00', '已结案', '2023-06-10 14:30:00', '2023-07-05 11:00:00', '工资单,劳动合同,员工证言', '《中华人民共和国劳动法》第九十一条', '工资已全部支付完毕', '0xe5b3d8d9acdd5700ba1c791bdea280ea8e41da0091475dcddabde67843cd8888', '2025-05-08 20:06:12');
INSERT INTO `bus_law_enforcement_chain` VALUES ('358', '7', '2023-JS-007', '建设违规', '某工地违规施工案', '该工地未取得施工许可擅自开工', null, '某建筑工程有限公司', null, '南京市鼓楼区', '2023-07-15 09:00:00', '吴警官', '南京市城乡建设委员会', '现场检查', '责令停工+罚款', '200000.00', '处理中', '2023-07-18 15:30:00', null, '现场照片,施工日志,规划文件', '《中华人民共和国建筑法》第六十四条', '案件正在处理中', '0xfb25ca515c8ac3903ce37a8750fbd7f28f8704b66ac00e0656114693a4ffa3b9', '2025-05-08 20:06:12');
INSERT INTO `bus_law_enforcement_chain` VALUES ('359', '8', '2023-JR-008', '金融违规', '某金融机构违规放贷案', '该机构违反规定向不符合条件客户放贷', '钱某', '某商业银行支行', '1200000.00', '天津市和平区', '2023-08-10 14:00:00', '郑警官', '中国银行保险监督管理委员会', '审计调查', '罚款+业务限制', '500000.00', '已结案', '2023-08-15 10:30:00', '2023-10-05 16:00:00', '贷款合同,审批记录,客户资料', '《中华人民共和国银行业监督管理法》第四十五条', '已整改完毕', '0x291c9e2b574308095506614096a79013f5a814ff3876b9f11888dc2aefe1d9d4', '2025-05-08 20:06:12');
INSERT INTO `bus_law_enforcement_chain` VALUES ('360', '9', '2023-YL-009', '医疗违规', '某医院乱收费案', '该医院违规收取不合理医疗费用', null, '某三甲医院', '250000.00', '武汉市武昌区', '2023-09-05 10:30:00', '冯警官', '湖北省卫生健康委员会', '数据核查', '退款+罚款', '100000.00', '已结案', '2023-09-10 14:00:00', '2023-11-15 11:30:00', '收费清单,病历记录,患者证言', '《医疗机构管理条例》第三十七条', '已退还多收费用', '0xb90cf70ab560653f32929eaaa51172e1d948604c4d3b4dba77d24459e6d20811', '2025-05-08 20:06:12');
INSERT INTO `bus_law_enforcement_chain` VALUES ('361', '10', '2023-JY-010', '教育违规', '某培训机构虚假宣传案', '该机构虚假承诺保过名校', '李某', '某教育咨询有限公司', '500000.00', '西安市雁塔区', '2023-10-12 13:45:00', '董警官', '陕西省教育厅', '暗访调查', '罚款+责令整改', '150000.00', '处理中', '2023-10-15 09:30:00', null, '宣传材料,合同文本,学员证言', '《中华人民共和国民办教育促进法》第六十二条', '案件正在处理中', '0xa3f673a25ff9554c4552cb65e236843e7ccabf4f6f8a67a926f0ce025508e611', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('362', '11', '2023-GA-011', '治安管理', '某娱乐场所涉黄案', '该场所涉嫌组织卖淫活动', '黄某', '某娱乐会所', null, '长沙市天心区', '2023-11-08 22:30:00', '林警官', '长沙市公安局治安支队', '突击检查', '责令停业+罚款', '300000.00', '已结案', '2023-11-10 10:00:00', '2023-12-20 15:30:00', '监控录像,交易记录,证人证言', '《中华人民共和国治安管理处罚法》第六十六条', '场所已关闭', '0x6a118f7e3eb8ce4a7710fe79fdaccd9ea3e3ddd9ac1617bc34c125e28002cf02', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('363', '12', '2023-NY-012', '农业违规', '某农场使用禁用农药案', '该农场在蔬菜种植中使用禁用农药', '赵某', '某生态农场', null, '郑州市惠济区', '2023-12-05 09:00:00', '徐警官', '河南省农业农村厅', '抽样检测', '罚款+销毁产品', '200000.00', '已结案', '2023-12-08 14:30:00', '2024-01-15 11:00:00', '农药样品,蔬菜样本,销售记录', '《中华人民共和国农产品质量安全法》第三十三条', '问题产品已销毁', '0xa7523fe9ff6cdcfea0553c3f9fcc9ae15edde3a2807fdaeb5d0ad1027e4c2739', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('364', '13', '2023-DS-013', '电商违规', '某网店销售假货案', '该网店销售假冒名牌手表', '周某', null, '600000.00', '网络平台', '2024-01-10 00:00:00', '高警官', '国家市场监督管理总局', '网络巡查', '罚款+关闭店铺', '300000.00', '已结案', '2024-01-15 10:30:00', '2024-02-28 16:00:00', '商品照片,交易记录,鉴定报告', '《中华人民共和国电子商务法》第八十五条', '网店已关闭', '0xc1e8cf51d85a97dcef56dea12523ea3a2a5dc7b346c877f53c0649f34821b25e', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('365', '14', '2024-CJ-014', '城建违规', '某开发商违规售房案', '该开发商未取得预售许可违规销售', null, '某房地产开发有限公司', '20000000.00', '青岛市市南区', '2024-02-15 10:00:00', '郭警官', '青岛市住房和城乡建设局', '调查取证', '罚款+暂停资质', '1000000.00', '处理中', '2024-02-20 14:30:00', null, '销售合同,收款凭证,审批文件', '《城市房地产开发经营管理条例》第三十六条', '案件正在处理中', '0x022ed7421753aefcbee20e470665defc9d871609aad9c051783a7fa576998a56', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('366', '15', '2024-TY-015', '体育违规', '某俱乐部打假球案', '该俱乐部在比赛中故意输球', '钱某', '某足球俱乐部', '500000.00', '大连市中山区', '2024-03-08 15:00:00', '马警官', '中国足球协会纪律委员会', '调查取证', '罚款+扣分', '200000.00', '已结案', '2024-03-10 10:30:00', '2024-04-15 14:00:00', '比赛录像,通讯记录,证人证言', '《中国足球协会纪律准则》第六十条', '俱乐部已接受处罚', '0x6e219f48a9e000af9a17c6cb15d585664634aeaca8b733157bd3e4ee13190a06', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('367', '16', '2024-JS-016', '建设违规', '某工地安全事故案', '该工地发生脚手架坍塌事故', '孙某', '某建设集团有限公司', null, '苏州市工业园区', '2024-04-10 08:30:00', '朱警官', '江苏省住房和城乡建设厅', '事故调查', '罚款+停工整顿', '500000.00', '已结案', '2024-04-12 10:00:00', '2024-06-15 14:30:00', '事故现场照片,施工日志,安全记录', '《建设工程安全生产管理条例》第六十四条', '工地已完成整改', '0x2f422124bf9341ebdd7666be8e452d4e4fbcdb0739de8c13bcacc49e321ebd95', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('368', '17', '2024-SP-017', '食品安全', '某超市销售变质食品案', '该超市销售过期变质肉类产品', null, '某连锁超市有限公司', null, '重庆市渝中区', '2024-05-08 11:00:00', '秦警官', '重庆市市场监督管理局', '抽样检查', '罚款+下架产品', '80000.00', '已结案', '2024-05-10 09:30:00', '2024-06-20 16:00:00', '食品样品,进货记录,监控录像', '《中华人民共和国食品安全法》第三十四条', '问题产品已全部下架', '0xb80e83140f35d2f0cb336ca0d230b1964445939dd4aec5cf40b1677b76975d8a', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('369', '18', '2024-HB-018', '环保违规', '某企业噪音扰民案', '该企业夜间生产噪音超标', null, '某机械制造有限公司', null, '长沙市岳麓区', '2024-06-15 22:00:00', '许警官', '湖南省生态环境厅', '噪音监测', '罚款+限时生产', '100000.00', '处理中', '2024-06-18 14:00:00', null, '噪音检测报告,居民投诉记录', '《中华人民共和国环境噪声污染防治法》第五十九条', '企业已调整生产时间', '0x0e7c5adf47f4b21f14091ee6b6466af64150d90df81f184288ee1b6dd412c93a', '2025-05-08 20:06:13');
INSERT INTO `bus_law_enforcement_chain` VALUES ('370', '19', '2024-JR-019', '金融违规', '某P2P平台非法集资案', '该平台涉嫌非法吸收公众存款', '陈某', '某金融信息服务有限公司', '5000000.00', '上海市浦东新区', '2024-07-05 10:00:00', '何警官', '上海市金融监督管理局', '查封账户', '罚款+刑事立案', '2000000.00', '已结案', '2024-07-10 09:30:00', '2024-09-20 15:00:00', '资金流水,投资人证言,平台数据', '《非法金融机构和非法金融业务活动取缔办法》第四条', '案件已移交司法机关', '0xb79f98ff31e0ccc591847a165f4f5824e31e94fc34d8dd93aa3dae37f9dd6724', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('371', '20', '2024-ZS-020', '知识产权', '某网店盗版软件案', '该网店销售盗版专业软件', '林某', null, '300000.00', '网络平台', '2024-08-12 00:00:00', '邓警官', '国家版权局', '网络巡查', '罚款+关闭店铺', '150000.00', '已结案', '2024-08-15 10:30:00', '2024-09-28 16:00:00', '软件样本,销售记录,鉴定报告', '《中华人民共和国著作权法》第五十三条', '网店已关闭', '0x63c2ba49f5603c79ed4b40d87700caaa76a3786639b3de0c2a76ee5eb1a364fc', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('372', '21', '2024-LD-021', '劳动纠纷', '某工厂违法加班案', '该工厂强制员工超时加班', '王某', '某电子制造有限公司', null, '东莞市长安镇', '2024-09-10 08:00:00', '钟警官', '广东省人力资源和社会保障厅', '员工访谈', '罚款+限期整改', '120000.00', '已结案', '2024-09-12 14:30:00', '2024-10-25 11:00:00', '考勤记录,工资单,员工证言', '《中华人民共和国劳动法》第四十一条', '工厂已调整工作时间', '0x1e79ef50141bca458b8090b2c96fb7a2a483ed18c612c24cc812d4c386b57fdd', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('373', '22', '2024-WH-022', '文化违规', '某书店非法出版物案', '该书店销售非法政治类出版物', null, '某图书有限公司', null, '北京市海淀区', '2024-10-15 14:00:00', '彭警官', '北京市文化市场综合执法总队', '突击检查', '没收+罚款', '200000.00', '处理中', '2024-10-18 10:30:00', null, '出版物样本,进货渠道记录', '《出版管理条例》第六十二条', '案件正在处理中', '0x8d867b2a1fa935931a4fabf8a7f08a424729abf31440f352d57c884ef507b03c', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('374', '23', '2024-JD-023', '交通违规', '某物流公司超载案', '该公司车辆长期超载运输', '刘某', '某物流运输有限公司', null, '武汉市东西湖区', '2024-11-08 09:30:00', '袁警官', '湖北省交通运输厅', '路面检查', '罚款+扣分', '80000.00', '已结案', '2024-11-10 14:00:00', '2024-12-15 16:30:00', '过磅记录,监控录像,运输合同', '《中华人民共和国道路交通安全法》第九十二条', '公司已整改', '0x425e9980cfef40172845a8a7f0b03e4f6cd3bd243f5f80c6f7b5b6e466fb6e8d', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('375', '24', '2024-NY-024', '农业违规', '某养殖场违禁药物案', '该养殖场使用违禁饲料添加剂', '赵某', '某畜牧养殖有限公司', null, '成都市双流区', '2024-12-05 10:00:00', '崔警官', '四川省农业农村厅', '抽样检测', '罚款+销毁产品', '150000.00', '已结案', '2024-12-08 14:30:00', '2025-01-20 11:00:00', '饲料样本,检测报告,销售记录', '《饲料和饲料添加剂管理条例》第三十九条', '问题产品已销毁', '0xc8ef347b80e0dbb9734d616ce4430a8082451f38d69bd71d9c94536e3b9bfadc', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('376', '25', '2024-YL-025', '医疗违规', '某诊所非法行医案', '该诊所使用无资质人员行医', '李某', '某综合诊所', null, '南京市鼓楼区', '2025-01-10 09:00:00', '陆警官', '江苏省卫生健康委员会', '暗访调查', '罚款+吊销执照', '120000.00', '已结案', '2025-01-15 10:30:00', '2025-03-01 14:00:00', '就诊记录,人员资质证明', '《医疗机构管理条例》第四十四条', '诊所已关闭', '0xb9bcb7079a70afb4cfe4af9bc1872967676bec574bedf3c49895c75eb98f55e5', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('377', '26', '2025-JS-026', '建设违规', '某楼盘质量缺陷案', '该楼盘存在严重建筑质量问题', null, '某房地产开发有限公司', '10000000.00', '广州市天河区', '2025-02-15 10:00:00', '江警官', '广东省住房和城乡建设厅', '质量检测', '罚款+限期整改', '500000.00', '处理中', '2025-02-20 14:30:00', null, '检测报告,业主投诉记录', '《建设工程质量管理条例》第五十六条', '开发商正在整改', '0x714e8e1f99ed484bc698fb8785cef0cc884036696d69a7fbe101c3852d108754', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('378', '27', '2025-SP-027', '食品安全', '某食品厂卫生不达标案', '该厂生产环境不符合卫生标准', null, '某食品加工厂', null, '天津市西青区', '2025-03-08 09:30:00', '韩警官', '天津市市场监督管理委员会', '现场检查', '罚款+停产整顿', '180000.00', '已结案', '2025-03-10 10:00:00', '2025-04-25 15:30:00', '现场照片,检测报告,生产记录', '《中华人民共和国食品安全法》第一百二十六条', '工厂已完成整改', '0x4dfed620504abaec6c8e5314e19c34175638de5cd39cbdd18ded66a312b52706', '2025-05-08 20:06:14');
INSERT INTO `bus_law_enforcement_chain` VALUES ('379', '28', '2025-HJ-028', '环境污染', '某企业废气超标排放案', '该企业废气处理设施不正常运行', '钱某', '某化工有限公司', null, '宁波市镇海区', '2025-04-10 08:00:00', '杨警官', '浙江省生态环境厅', '在线监测', '罚款+限产', '250000.00', '处理中', '2025-04-15 14:30:00', null, '监测数据,运行记录', '《中华人民共和国大气污染防治法》第九十九条', '企业正在整改', '0xb00cad305ba05ede0284530b1ac23ae4e3366c3562280dfeddf1e38cb4dbd606', '2025-05-08 20:06:15');
INSERT INTO `bus_law_enforcement_chain` VALUES ('380', '29', '2025-JR-029', '金融违规', '某证券公司内幕交易案', '该公司员工涉嫌利用内幕信息交易', '周某', '某证券股份有限公司', '3000000.00', '深圳市福田区', '2025-05-12 10:30:00', '曹警官', '中国证券监督管理委员会', '数据筛查', '罚款+市场禁入', '2000000.00', '已结案', '2025-05-15 09:00:00', '2025-07-20 16:00:00', '交易记录,通讯记录,账户流水', '《中华人民共和国证券法》第一百九十一条', '案件已移交司法机关', '0xcea553b3e0a1411520e928dcb8376062ca56c041caaa45ca57fa8bf9bbf92425', '2025-05-08 20:06:15');
INSERT INTO `bus_law_enforcement_chain` VALUES ('381', '30', '2025-ZJ-030', '经济犯罪', '某公司合同诈骗案', '该公司通过虚假合同骗取货款', '吴某', '某贸易有限公司', '2000000.00', '杭州市萧山区', '2025-06-08 14:00:00', '魏警官', '浙江省公安厅经侦总队', '调查取证', '刑事立案', null, '已结案', '2025-06-10 10:30:00', '2025-08-15 14:30:00', '合同文本,资金流向,证人证言', '《中华人民共和国刑法》第二百二十四条', '案件已移交检察机关', '0xadd4bd56021510d951eefd6425d768b1d8615d922994f7293804926031a637e8', '2025-05-08 20:06:15');
INSERT INTO `bus_law_enforcement_chain` VALUES ('382', '31', '2025-XF-031', '消费欺诈', '某4S店欺诈销售案', '该店将事故车作为新车销售', null, '某汽车销售服务有限公司', '800000.00', '西安市未央区', '2025-07-15 11:00:00', '吕警官', '陕西省市场监督管理局', '技术鉴定', '退一赔三+罚款', '500000.00', '已结案', '2025-07-18 14:30:00', '2025-09-10 15:00:00', '车辆检测报告,销售合同,维修记录', '《中华人民共和国消费者权益保护法》第五十五条', '已赔偿消费者', '0x09e4d7a9337c0b1643093a9f323c72de3edd271fa3986be520e41bb0c59c70de', '2025-05-08 20:06:15');
INSERT INTO `bus_law_enforcement_chain` VALUES ('383', '32', '2025-WS-032', '卫生违规', '某酒店卫生不达标案', '该酒店客房卫生严重不达标', null, '某国际酒店管理有限公司', null, '三亚市吉阳区', '2025-08-20 09:30:00', '蒋警官', '海南省卫生健康委员会', '暗访检查', '罚款+限期整改', '150000.00', '处理中', '2025-08-22 10:00:00', null, '检测报告,现场照片', '《公共场所卫生管理条例》第十四条', '酒店正在整改', '0xd96b6f0b4e90067b6fafa0f7f6226c6e785d776a68674e9f4937f6a83010b64d', '2025-05-08 20:06:15');
INSERT INTO `bus_law_enforcement_chain` VALUES ('384', '33', '2025-JY-033', '教育违规', '某学校乱收费案', '该学校违规收取赞助费等费用', '张某', '某私立学校', '1200000.00', '青岛市市北区', '2025-09-10 10:30:00', '沈警官', '山东省教育厅', '家长访谈', '退款+罚款', '300000.00', '已结案', '2025-09-15 14:00:00', '2025-11-20 16:30:00', '收费凭证,家长证言', '《中华人民共和国教育法》第七十八条', '已退还违规收费', '0x160a500d2dbb1c987af6bf951d67afe87a8ed2b6a74cfc0cecc3693f39df984f', '2025-05-08 20:06:15');
INSERT INTO `bus_law_enforcement_chain` VALUES ('385', '34', '2025-TY-034', '体育违规', '某运动员使用兴奋剂案', '该运动员比赛期间使用违禁药物', '李某', null, null, '北京市朝阳区', '2025-10-15 00:00:00', '范警官', '国家体育总局反兴奋剂中心', '尿样检测', '取消成绩+禁赛', null, '已结案', '2025-10-18 10:30:00', '2025-12-01 14:00:00', '检测报告,比赛录像', '《反兴奋剂条例》第四十六条', '运动员已接受处罚', '0x810e261a299aa8cedd6700113d4188d68e32945f19c86acf29ca9af6a3d4bf00', '2025-05-08 20:06:15');
INSERT INTO `bus_law_enforcement_chain` VALUES ('403', '35', '2025-GA-035', '治安管理', '某酒吧打架斗殴案', '该酒吧发生群体性斗殴事件', '王某', '某娱乐管理有限公司', null, '上海市静安区', '2025-11-08 23:30:00', '方警官', '上海市公安局治安总队', '现场处置', '罚款+停业整顿', '200000.00', '处理中', '2025-11-10 10:00:00', null, '监控录像,伤情鉴定,证人证言', '《中华人民共和国治安管理处罚法》第二十六条', '酒吧正在停业整顿', '0x786a616d479449478c387d6739af3460f78812f514781be4b5a00e014e48920f', '2025-05-09 21:31:38');
INSERT INTO `bus_law_enforcement_chain` VALUES ('404', '36', '1112134-123ADF', '交通违规', '交通红灯', '交通红灯', '唐某某', '某某滴滴公司', '30000.00', '上海市浦东新区', '2025-05-09 21:33:01', '陈某某', 'xx部门', '1112', '罚款', '20000.00', '处理中', '2025-05-09 21:33:49', null, 'xxx', 'xx', 'aadf', '0xc9cb653d0ddb77218b717a2ccba6a0c98a7c453c76afaaed4b496d0533ec31e2', '2025-05-09 21:33:58');
INSERT INTO `bus_law_enforcement_chain` VALUES ('405', '36', '1112134-123ADF', '交通违规', '交通红灯', '交通红灯', '唐某某', '某某滴滴公司', '30000.00', '上海市浦东新区', '2025-05-09 21:33:01', '陈某某', '交通执法部门', '缴纳罚款', '罚款', '20000.00', '处理中', '2025-05-09 21:33:49', null, 'xxx', 'xx', 'aadf', '0x37220718e2e7bfb56a2ccd2c975b88b4e566076ed3098a9ff1c4d5b1a7a3b3e0', '2025-05-09 21:34:48');

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级部门',
  `sub_count` int(5) DEFAULT '0' COMMENT '子部门数目',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `dept_sort` int(5) DEFAULT '999' COMMENT '排序',
  `enabled` bit(1) NOT NULL COMMENT '状态',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE,
  KEY `idx_pid` (`pid`),
  KEY `idx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES ('2', '7', '1', '研发部', '3', '', 'admin', 'admin', '2019-03-25 09:15:32', '2020-08-02 14:48:47');
INSERT INTO `sys_dept` VALUES ('5', '7', '0', '运维部', '4', '', 'admin', 'admin', '2019-03-25 09:20:44', '2020-05-17 14:27:27');
INSERT INTO `sys_dept` VALUES ('6', '8', '0', '测试部', '6', '', 'admin', 'admin', '2019-03-25 09:52:18', '2020-06-08 11:59:21');
INSERT INTO `sys_dept` VALUES ('7', null, '2', '华南分部', '0', '', 'admin', 'admin', '2019-03-25 11:04:50', '2020-06-08 12:08:56');
INSERT INTO `sys_dept` VALUES ('8', null, '2', '华北分部', '1', '', 'admin', 'admin', '2019-03-25 11:04:53', '2020-05-14 12:54:00');
INSERT INTO `sys_dept` VALUES ('15', '8', '0', 'UI部门', '7', '', 'admin', 'admin', '2020-05-13 22:56:53', '2020-05-14 12:54:13');
INSERT INTO `sys_dept` VALUES ('17', '2', '0', '研发一组', '999', '', 'admin', 'admin', '2020-08-02 14:49:07', '2020-08-02 14:49:07');

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '字典名称',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='数据字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES ('1', 'user_status', '用户状态', null, null, '2019-10-27 20:31:36', null);
INSERT INTO `sys_dict` VALUES ('4', 'dept_status', '部门状态', null, null, '2019-10-27 20:31:36', null);
INSERT INTO `sys_dict` VALUES ('5', 'job_status', '岗位状态', null, null, '2019-10-27 20:31:36', null);
INSERT INTO `sys_dict` VALUES ('6', 'case_type', '案件类型', null, null, null, null);

-- ----------------------------
-- Table structure for sys_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_detail`;
CREATE TABLE `sys_dict_detail` (
  `detail_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dict_id` bigint(11) DEFAULT NULL COMMENT '字典id',
  `label` varchar(255) NOT NULL COMMENT '字典标签',
  `value` varchar(255) NOT NULL COMMENT '字典值',
  `dict_sort` int(5) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`detail_id`) USING BTREE,
  KEY `idx_dict_id` (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='数据字典详情';

-- ----------------------------
-- Records of sys_dict_detail
-- ----------------------------
INSERT INTO `sys_dict_detail` VALUES ('1', '1', '激活', 'true', '1', null, null, '2019-10-27 20:31:36', null);
INSERT INTO `sys_dict_detail` VALUES ('2', '1', '禁用', 'false', '2', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('3', '4', '启用', 'true', '1', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('4', '4', '停用', 'false', '2', null, null, '2019-10-27 20:31:36', null);
INSERT INTO `sys_dict_detail` VALUES ('5', '5', '启用', 'true', '1', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('6', '5', '停用', 'false', '2', null, null, '2019-10-27 20:31:36', null);
INSERT INTO `sys_dict_detail` VALUES ('7', '6', '交通违规', '交通违规', '1', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('10', '6', '农业违规', '农业违规', '10', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('11', '6', '劳动纠纷', '劳动纠纷', '11', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('12', '6', '医疗违规', '医疗违规', '12', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('13', '6', '卫生违规', '卫生违规', '13', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('14', '6', '城建违规', '城建违规', '14', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('15', '6', '建设违规', '建设违规', '15', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('16', '6', '教育违规', '教育违规', '16', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('17', '6', '文化违规', '文化违规', '17', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('18', '6', '治安管理', '治安管理', '18', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('19', '6', '消费欺诈', '消费欺诈', '19', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('20', '6', '环保违规', '环保违规', '20', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('21', '6', '环境污染', '环境污染', '21', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('22', '6', '电商违规', '电商违规', '22', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('23', '6', '知识产权', '知识产权', '23', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('24', '6', '经济犯罪', '经济犯罪', '24', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('25', '6', '金融违规', '金融违规', '25', null, null, null, null);
INSERT INTO `sys_dict_detail` VALUES ('26', '6', '食品安全', '食品安全', '26', null, null, null, null);

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(180) NOT NULL COMMENT '岗位名称',
  `enabled` bit(1) NOT NULL COMMENT '岗位状态',
  `job_sort` int(5) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`job_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`),
  KEY `idx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='岗位';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
INSERT INTO `sys_job` VALUES ('8', '人事专员', '', '3', null, null, '2019-03-29 14:52:28', null);
INSERT INTO `sys_job` VALUES ('10', '产品经理', '', '4', null, null, '2019-03-29 14:55:51', null);
INSERT INTO `sys_job` VALUES ('11', '全栈开发', '', '2', null, 'admin', '2019-03-31 13:39:30', '2020-05-05 11:33:43');
INSERT INTO `sys_job` VALUES ('12', '软件测试', '', '5', null, 'admin', '2019-03-31 13:39:43', '2020-05-10 19:56:26');

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `log_type` varchar(10) NOT NULL COMMENT '日志类型：INFI/ERROR',
  `method` varchar(255) DEFAULT NULL COMMENT '方法名',
  `params` text COMMENT '参数',
  `request_ip` varchar(255) DEFAULT NULL COMMENT '请求IP',
  `time` bigint(20) DEFAULT NULL COMMENT '执行时间',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `browser` varchar(255) DEFAULT NULL COMMENT '浏览器',
  `exception_detail` text COMMENT '异常',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `idx_create_time_index` (`create_time`),
  KEY `idx_log_type` (`log_type`)
) ENGINE=InnoDB AUTO_INCREMENT=3654 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO `sys_log` VALUES ('3593', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"32\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:c854a1a630994fa2a1f3153def629382\"}', '192.168.0.107', '572', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-03 20:12:46');
INSERT INTO `sys_log` VALUES ('3594', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"13\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:16fe71ee58fb4ad3a67d5c6a97c69eb8\"}', '192.168.0.107', '77', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-03 20:39:26');
INSERT INTO `sys_log` VALUES ('3595', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"16\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:693e8a67eaad457c8fb2c2d287411b59\"}', '192.168.0.107', '80', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-03 20:49:05');
INSERT INTO `sys_log` VALUES ('3596', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"18\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:d74461fb785043c9abaf9004581a6df7\"}', '192.168.0.107', '74', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-03 21:02:03');
INSERT INTO `sys_log` VALUES ('3597', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"24\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:734d31e4163549da845a360dc813a32d\"}', '192.168.0.107', '558', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-03 22:49:52');
INSERT INTO `sys_log` VALUES ('3598', '用户登录', 'ERROR', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"12\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:a5a25d5f13de436b89c2f09bd177c788\"}', '192.168.0.107', '376', 'admin', '内网IP', 'Chrome 101.0.4951.64', 'me.zhengjie.exception.BadRequestException: 验证码错误\r\n	at me.zhengjie.modules.security.rest.AuthController.login(AuthController.java:92)\r\n	at me.zhengjie.modules.security.rest.AuthController$$FastClassBySpringCGLIB$$7f997139.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)\r\n	at me.zhengjie.aspect.LogAspect.logAround(LogAspect.java:68)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)\r\n	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)\r\n	at me.zhengjie.modules.security.rest.AuthController$$EnhancerBySpringCGLIB$$b81b6287.login(<generated>)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)\r\n	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)\r\n	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)\r\n	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)\r\n	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:114)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at me.zhengjie.modules.security.security.TokenFilter.doFilter(TokenFilter.java:73)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221)\r\n	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)\r\n	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)\r\n	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)\r\n	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)\r\n	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)\r\n	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)\r\n	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)\r\n	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)\r\n	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)\r\n	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)\r\n	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)\r\n	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n	at java.lang.Thread.run(Thread.java:748)\r\n', '2025-05-03 22:54:28');
INSERT INTO `sys_log` VALUES ('3599', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"17\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:3865537b880642a3ab50231464066735\"}', '192.168.0.107', '152', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-03 22:54:31');
INSERT INTO `sys_log` VALUES ('3600', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"3\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:b4542f9f12794b5daba88f9712969b5d\"}', '192.168.0.107', '648', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-04 09:42:40');
INSERT INTO `sys_log` VALUES ('3601', '用户登录', 'ERROR', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"13\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:38e3a566e4f34c0f969ed67187b7bf37\"}', '192.168.0.107', '2', 'admin', '内网IP', 'Chrome 101.0.4951.64', 'me.zhengjie.exception.BadRequestException: 验证码不存在或已过期\r\n	at me.zhengjie.modules.security.rest.AuthController.login(AuthController.java:89)\r\n	at me.zhengjie.modules.security.rest.AuthController$$FastClassBySpringCGLIB$$7f997139.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)\r\n	at me.zhengjie.aspect.LogAspect.logAround(LogAspect.java:68)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)\r\n	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)\r\n	at me.zhengjie.modules.security.rest.AuthController$$EnhancerBySpringCGLIB$$2a94250c.login(<generated>)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)\r\n	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)\r\n	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)\r\n	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)\r\n	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:114)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at me.zhengjie.modules.security.security.TokenFilter.doFilter(TokenFilter.java:73)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221)\r\n	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)\r\n	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)\r\n	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)\r\n	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)\r\n	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)\r\n	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)\r\n	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)\r\n	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)\r\n	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)\r\n	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)\r\n	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)\r\n	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n	at java.lang.Thread.run(Thread.java:748)\r\n', '2025-05-04 10:50:06');
INSERT INTO `sys_log` VALUES ('3602', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"5\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:6fd20ee4d8204f08ba321a62b7d5c81c\"}', '192.168.0.107', '75', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 10:50:12');
INSERT INTO `sys_log` VALUES ('3603', '新增菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.createMenu()', '{\"IFrame\":false,\"cache\":false,\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:47.724\",\"hasChildren\":false,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":true,\"menuSort\":999,\"path\":\"system/busLawEnforcement\",\"pid\":1,\"subCount\":0,\"title\":\"执法数据\",\"type\":0,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:47.726\"}', '192.168.0.107', '40', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:16:48');
INSERT INTO `sys_log` VALUES ('3604', '修改角色菜单', 'INFO', 'me.zhengjie.modules.system.rest.RoleController.updateRoleMenu()', '{\"dataScope\":\"本级\",\"id\":1,\"level\":3,\"menus\":[{\"hasChildren\":false,\"id\":35,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":36,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":37,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":39,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":44,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":45,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":46,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":48,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":49,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":50,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":52,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":116,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":53,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":117,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":54,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":56,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":57,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":58,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":60,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":61,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":62,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":64,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":1,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":65,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":2,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":66,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":3,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":5,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":77,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":78,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":79,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":18,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":82,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":30,\"leaf\":true,\"menuSort\":999,\"subCount\":0}]}', '192.168.0.107', '36', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:17:15');
INSERT INTO `sys_log` VALUES ('3605', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":false,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":true,\"menuSort\":9,\"path\":\"system/busLawEnforcement\",\"pid\":1,\"subCount\":0,\"title\":\"执法数据\",\"type\":0,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}', '192.168.0.107', '27', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:17:42');
INSERT INTO `sys_log` VALUES ('3606', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":false,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":true,\"menuSort\":9,\"path\":\"system/busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":1,\"subCount\":0,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}', '192.168.0.107', '14', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:18:35');
INSERT INTO `sys_log` VALUES ('3607', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"component\":\"system/busLawEnforcement\",\"componentName\":\"执法数据\",\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":false,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":true,\"menuSort\":9,\"path\":\"system/busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":1,\"subCount\":0,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}', '192.168.0.107', '21', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:18:53');
INSERT INTO `sys_log` VALUES ('3608', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"component\":\"system/busLawEnforcement/index\",\"componentName\":\"执法数据\",\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":false,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":true,\"menuSort\":9,\"path\":\"busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":1,\"subCount\":0,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}', '192.168.0.107', '18', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:19:21');
INSERT INTO `sys_log` VALUES ('3609', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"component\":\"system/busLawEnforcement/index\",\"componentName\":\"BusLawEnforcement\",\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":false,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":true,\"menuSort\":9,\"path\":\"busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":1,\"subCount\":0,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}', '192.168.0.107', '18', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:20:13');
INSERT INTO `sys_log` VALUES ('3610', '新增菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.createMenu()', '{\"IFrame\":false,\"cache\":false,\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:21:08.869\",\"hasChildren\":false,\"hidden\":false,\"id\":118,\"label\":\"添加\",\"leaf\":true,\"menuSort\":1,\"permission\":\"busLawEnforcement:add\",\"pid\":117,\"subCount\":0,\"title\":\"添加\",\"type\":2,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:21:08.869\"}', '192.168.0.107', '14', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:21:09');
INSERT INTO `sys_log` VALUES ('3611', '新增菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.createMenu()', '{\"IFrame\":false,\"cache\":false,\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:21:38.39\",\"hasChildren\":false,\"hidden\":false,\"id\":119,\"label\":\"修改\",\"leaf\":true,\"menuSort\":999,\"permission\":\"busLawEnforcement:edit\",\"pid\":117,\"subCount\":0,\"title\":\"修改\",\"type\":2,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:21:38.39\"}', '192.168.0.107', '12', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:21:38');
INSERT INTO `sys_log` VALUES ('3612', '新增菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.createMenu()', '{\"IFrame\":false,\"cache\":false,\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:22:06.407\",\"hasChildren\":false,\"hidden\":false,\"id\":120,\"label\":\"删除\",\"leaf\":true,\"menuSort\":3,\"permission\":\"busLawEnforcement:del\",\"pid\":117,\"subCount\":0,\"title\":\"删除\",\"type\":2,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:22:06.407\"}', '192.168.0.107', '10', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:22:06');
INSERT INTO `sys_log` VALUES ('3613', '修改角色菜单', 'INFO', 'me.zhengjie.modules.system.rest.RoleController.updateRoleMenu()', '{\"dataScope\":\"本级\",\"id\":1,\"level\":3,\"menus\":[{\"hasChildren\":false,\"id\":35,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":36,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":37,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":39,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":44,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":45,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":46,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":48,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":49,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":50,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":52,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":116,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":53,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":117,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":54,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":118,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":119,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":56,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":120,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":57,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":58,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":60,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":61,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":62,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":64,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":1,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":65,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":2,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":66,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":3,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":5,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":77,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":78,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":79,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":18,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":82,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":30,\"leaf\":true,\"menuSort\":999,\"subCount\":0}]}', '192.168.0.107', '26', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-04 11:22:19');
INSERT INTO `sys_log` VALUES ('3614', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"6\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:563142824bda40e1b2578ac892a31d0b\"}', '192.168.5.101', '660', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 10:21:56');
INSERT INTO `sys_log` VALUES ('3615', '新增busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.createBusLawEnforcement()', '{\"caseAmount\":1234,\"caseDescription\":\"123\",\"caseLocation\":\"123\",\"caseNumber\":\"123\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-05-06 11:37:26\",\"caseTitle\":\"123\",\"caseType\":\"交通违规\",\"closingTime\":\"2025-05-06 11:37:43\",\"enforcementAction\":\"123\",\"enforcementDepartment\":\"sdf\",\"evidenceList\":\"123\",\"filingTime\":\"2025-05-06 11:37:39\",\"id\":36,\"involvedCompany\":\"12\",\"involvedPerson\":\"1212\",\"lawEnforcementOfficer\":\"123\",\"legalBasis\":\"123\",\"punishmentAmount\":123,\"punishmentType\":\"14\",\"remark\":\"123\"}', '192.168.5.101', '82', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 11:45:44');
INSERT INTO `sys_log` VALUES ('3616', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseAmount\":12345,\"caseDescription\":\"12345\",\"caseLocation\":\"12345\",\"caseNumber\":\"12345\",\"caseStatus\":\"已结案\",\"caseTime\":\"2025-05-06 11:37:26\",\"caseTitle\":\"12345\",\"caseType\":\"农业违规\",\"closingTime\":\"2025-05-06 11:37:43\",\"createTime\":\"2025-05-06 11:45:44\",\"enforcementAction\":\"12345\",\"enforcementDepartment\":\"12345\",\"evidenceList\":\"12345\",\"filingTime\":\"2025-05-06 11:37:39\",\"id\":36,\"involvedCompany\":\"12345\",\"involvedPerson\":\"12345\",\"lawEnforcementOfficer\":\"12345\",\"legalBasis\":\"12345\",\"punishmentAmount\":12345,\"punishmentType\":\"12345\",\"remark\":\"12345\",\"updateTime\":\"2025-05-06 11:45:44\"}', '192.168.5.101', '67', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 11:46:14');
INSERT INTO `sys_log` VALUES ('3617', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseAmount\":12345,\"caseDescription\":\"12345\",\"caseLocation\":\"12345\",\"caseNumber\":\"12345\",\"caseStatus\":\"已结案\",\"caseTime\":\"2025-05-07 11:37:26\",\"caseTitle\":\"12345\",\"caseType\":\"农业违规\",\"closingTime\":\"2025-05-07 11:37:43\",\"createTime\":\"2025-05-06 11:45:44\",\"enforcementAction\":\"12345\",\"enforcementDepartment\":\"12345\",\"evidenceList\":\"12345\",\"filingTime\":\"2025-05-07 11:37:39\",\"id\":36,\"involvedCompany\":\"12345\",\"involvedPerson\":\"12345\",\"lawEnforcementOfficer\":\"12345\",\"legalBasis\":\"12345\",\"punishmentAmount\":12345,\"punishmentType\":\"12345\",\"remark\":\"12345\",\"updateTime\":\"2025-05-06 11:45:44\"}', '192.168.5.101', '13', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 11:46:31');
INSERT INTO `sys_log` VALUES ('3618', '修改角色菜单', 'INFO', 'me.zhengjie.modules.system.rest.RoleController.updateRoleMenu()', '{\"dataScope\":\"本级\",\"id\":1,\"level\":3,\"menus\":[{\"hasChildren\":false,\"id\":35,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":36,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":37,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":39,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":44,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":45,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":46,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":48,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":49,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":50,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":52,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":116,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":53,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":117,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":54,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":118,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":119,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":56,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":120,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":57,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":58,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":60,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":61,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":62,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":64,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":1,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":65,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":2,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":66,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":3,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":5,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":10,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":11,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":77,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":78,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":79,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":18,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":82,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":30,\"leaf\":true,\"menuSort\":999,\"subCount\":0}]}', '192.168.5.101', '32', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 12:01:29');
INSERT INTO `sys_log` VALUES ('3619', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"-1\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:b12d11e16ea2434aa7305069b10d4c68\"}', '192.168.5.101', '128', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 13:52:27');
INSERT INTO `sys_log` VALUES ('3620', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"10\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:56b73c62f3bc4ef2952b5130f6e5ad60\"}', '192.168.5.101', '113', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 15:46:57');
INSERT INTO `sys_log` VALUES ('3621', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"13\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:5883bdcba51f4f3394eaf5edd42e639f\"}', '192.168.5.101', '2058', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-06 18:30:33');
INSERT INTO `sys_log` VALUES ('3622', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"27\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:c9886adeb6784a968466b566e90e0cf3\"}', '192.168.2.4', '676', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 21:12:23');
INSERT INTO `sys_log` VALUES ('3623', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"4\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:ca696f6b12684bfebb0eba57357cc06f\"}', '192.168.2.4', '90', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 22:09:47');
INSERT INTO `sys_log` VALUES ('3624', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"9\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:a8247e8e9691404ebb28eece02a2a64d\"}', '192.168.2.4', '84', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-06 22:24:46');
INSERT INTO `sys_log` VALUES ('3625', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"3\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:a88b1bc27b634539aa164d7836b6a77b\"}', '192.168.2.4', '84', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 22:43:07');
INSERT INTO `sys_log` VALUES ('3626', '新增busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.createBusLawEnforcement()', '{\"caseAmount\":12,\"caseDescription\":\"asdf\",\"caseLocation\":\"asdf\",\"caseNumber\":\"123zzcv\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-05-06 23:31:19\",\"caseTitle\":\"qqe\",\"caseType\":\"交通违规\",\"closingTime\":\"2025-05-06 23:31:30\",\"enforcementAction\":\"12\",\"enforcementDepartment\":\"aga\",\"evidenceList\":\"asd\",\"filingTime\":\"2025-05-06 23:31:29\",\"hexId\":\"NQHKGBT6F4\",\"id\":37,\"involvedCompany\":\"aer\",\"involvedPerson\":\"123\",\"lawEnforcementOfficer\":\"asdf\",\"legalBasis\":\"asdf\",\"punishmentAmount\":2,\"punishmentType\":\"asdf\",\"remark\":\"ag\"}', '192.168.2.4', '32', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 23:31:34');
INSERT INTO `sys_log` VALUES ('3627', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseAmount\":12,\"caseDescription\":\"asdf\",\"caseLocation\":\"asdf\",\"caseNumber\":\"123zzcv\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-05-06 23:31:19\",\"caseTitle\":\"qqe\",\"caseType\":\"交通违规\",\"closingTime\":\"2025-05-06 23:31:30\",\"createTime\":\"2025-05-06 23:31:34\",\"enforcementAction\":\"12\",\"enforcementDepartment\":\"aga\",\"evidenceList\":\"asd\",\"filingTime\":\"2025-05-06 23:31:29\",\"hexId\":\"NQHKGBT6F4\",\"id\":37,\"involvedCompany\":\"aer\",\"involvedPerson\":\"123\",\"lawEnforcementOfficer\":\"asdf\",\"legalBasis\":\"asdf\",\"punishmentAmount\":2,\"punishmentType\":\"asdf\",\"remark\":\"agatwet\",\"updateTime\":\"2025-05-06 23:31:34\"}', '192.168.2.4', '61', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-06 23:31:50');
INSERT INTO `sys_log` VALUES ('3628', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"8\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:5818cffe640c455aba7891e3446f4c0d\"}', '192.168.5.116', '677', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 10:11:59');
INSERT INTO `sys_log` VALUES ('3629', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"56\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:2a29db04547d4a3694f7557f3a71a63b\"}', '192.168.5.116', '643', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 11:20:02');
INSERT INTO `sys_log` VALUES ('3630', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"4\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:238d5b13c6ea460e951ea6f07ea7a463\"}', '192.168.5.116', '111', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 17:18:48');
INSERT INTO `sys_log` VALUES ('3631', '用户登录', 'ERROR', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"42\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:d44fd605b2e54eb58c604f3672b642f9\"}', '192.168.5.116', '21', 'admin', '内网IP', 'Chrome 101.0.4951.64', 'me.zhengjie.exception.BadRequestException: 验证码错误\r\n	at me.zhengjie.modules.security.rest.AuthController.login(AuthController.java:92)\r\n	at me.zhengjie.modules.security.rest.AuthController$$FastClassBySpringCGLIB$$7f997139.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)\r\n	at me.zhengjie.aspect.LogAspect.logAround(LogAspect.java:68)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)\r\n	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)\r\n	at me.zhengjie.modules.security.rest.AuthController$$EnhancerBySpringCGLIB$$b454e804.login(<generated>)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)\r\n	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)\r\n	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)\r\n	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)\r\n	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:114)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at me.zhengjie.modules.security.security.TokenFilter.doFilter(TokenFilter.java:73)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221)\r\n	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)\r\n	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)\r\n	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)\r\n	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)\r\n	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)\r\n	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)\r\n	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)\r\n	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)\r\n	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)\r\n	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)\r\n	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)\r\n	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n	at java.lang.Thread.run(Thread.java:748)\r\n', '2025-05-07 20:44:42');
INSERT INTO `sys_log` VALUES ('3632', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"30\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:37a01f80b153447eb25f487a2b00dea7\"}', '192.168.5.116', '109', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 20:44:44');
INSERT INTO `sys_log` VALUES ('3633', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"4\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:db3de885fb5f4a149c4ed0ce8334a0d5\"}', '192.168.2.4', '574', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 22:39:57');
INSERT INTO `sys_log` VALUES ('3634', '新增菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.createMenu()', '{\"IFrame\":false,\"cache\":false,\"children\":[{\"IFrame\":false,\"cache\":false,\"component\":\"system/user/index\",\"componentName\":\"User\",\"createTime\":\"2018-12-18 15:14:44\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"peoples\",\"id\":2,\"label\":\"用户管理\",\"leaf\":false,\"menuSort\":2,\"path\":\"user\",\"permission\":\"user:list\",\"pid\":1,\"subCount\":3,\"title\":\"用户管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/role/index\",\"componentName\":\"Role\",\"createTime\":\"2018-12-18 15:16:07\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"role\",\"id\":3,\"label\":\"角色管理\",\"leaf\":false,\"menuSort\":3,\"path\":\"role\",\"permission\":\"roles:list\",\"pid\":1,\"subCount\":3,\"title\":\"角色管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/menu/index\",\"componentName\":\"Menu\",\"createTime\":\"2018-12-18 15:17:28\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"menu\",\"id\":5,\"label\":\"菜单管理\",\"leaf\":false,\"menuSort\":5,\"path\":\"menu\",\"permission\":\"menu:list\",\"pid\":1,\"subCount\":3,\"title\":\"菜单管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/dept/index\",\"componentName\":\"Dept\",\"createTime\":\"2019-03-25 09:46:00\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"dept\",\"id\":35,\"label\":\"部门管理\",\"leaf\":false,\"menuSort\":6,\"path\":\"dept\",\"permission\":\"dept:list\",\"pid\":1,\"subCount\":3,\"title\":\"部门管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/job/index\",\"componentName\":\"Job\",\"createTime\":\"2019-03-29 13:51:18\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"Steve-Jobs\",\"id\":37,\"label\":\"岗位管理\",\"leaf\":false,\"menuSort\":7,\"path\":\"job\",\"permission\":\"job:list\",\"pid\":1,\"subCount\":3,\"title\":\"岗位管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/dict/index\",\"componentName\":\"Dict\",\"createTime\":\"2019-04-10 11:49:04\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"dictionary\",\"id\":39,\"label\":\"字典管理\",\"leaf\":false,\"menuSort\":8,\"path\":\"dict\",\"permission\":\"dict:list\",\"pid\":1,\"subCount\":3,\"title\":\"字典管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/busLawEnforcement/index\",\"componentName\":\"BusLawEnforcement\",\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":false,\"menuSort\":9,\"path\":\"busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":1,\"subCount\":3,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}],\"createBy\":\"admin\",\"createTime\":\"2025-05-07 23:13:45.086\",\"hasChildren\":false,\"hidden\":false,\"icon\":\"lock\",\"id\":121,\"label\":\"执法管理\",\"leaf\":true,\"menuSort\":999,\"path\":\"1\",\"subCount\":0,\"title\":\"执法管理\",\"type\":0,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-07 23:13:45.087\"}', '192.168.2.4', '40', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 23:13:45');
INSERT INTO `sys_log` VALUES ('3635', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"children\":[{\"IFrame\":false,\"cache\":false,\"component\":\"system/user/index\",\"componentName\":\"User\",\"createTime\":\"2018-12-18 15:14:44\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"peoples\",\"id\":2,\"label\":\"用户管理\",\"leaf\":false,\"menuSort\":2,\"path\":\"user\",\"permission\":\"user:list\",\"pid\":1,\"subCount\":3,\"title\":\"用户管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/role/index\",\"componentName\":\"Role\",\"createTime\":\"2018-12-18 15:16:07\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"role\",\"id\":3,\"label\":\"角色管理\",\"leaf\":false,\"menuSort\":3,\"path\":\"role\",\"permission\":\"roles:list\",\"pid\":1,\"subCount\":3,\"title\":\"角色管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/menu/index\",\"componentName\":\"Menu\",\"createTime\":\"2018-12-18 15:17:28\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"menu\",\"id\":5,\"label\":\"菜单管理\",\"leaf\":false,\"menuSort\":5,\"path\":\"menu\",\"permission\":\"menu:list\",\"pid\":1,\"subCount\":3,\"title\":\"菜单管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/dept/index\",\"componentName\":\"Dept\",\"createTime\":\"2019-03-25 09:46:00\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"dept\",\"id\":35,\"label\":\"部门管理\",\"leaf\":false,\"menuSort\":6,\"path\":\"dept\",\"permission\":\"dept:list\",\"pid\":1,\"subCount\":3,\"title\":\"部门管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/job/index\",\"componentName\":\"Job\",\"createTime\":\"2019-03-29 13:51:18\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"Steve-Jobs\",\"id\":37,\"label\":\"岗位管理\",\"leaf\":false,\"menuSort\":7,\"path\":\"job\",\"permission\":\"job:list\",\"pid\":1,\"subCount\":3,\"title\":\"岗位管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/dict/index\",\"componentName\":\"Dict\",\"createTime\":\"2019-04-10 11:49:04\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"dictionary\",\"id\":39,\"label\":\"字典管理\",\"leaf\":false,\"menuSort\":8,\"path\":\"dict\",\"permission\":\"dict:list\",\"pid\":1,\"subCount\":3,\"title\":\"字典管理\",\"type\":1},{\"IFrame\":false,\"cache\":false,\"component\":\"system/busLawEnforcement/index\",\"componentName\":\"BusLawEnforcement\",\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":false,\"menuSort\":9,\"path\":\"busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":1,\"subCount\":3,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}],\"createBy\":\"admin\",\"createTime\":\"2025-05-07 23:13:45\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"lock\",\"id\":121,\"label\":\"执法管理\",\"leaf\":false,\"menuSort\":999,\"path\":\"system\",\"subCount\":7,\"title\":\"执法管理\",\"type\":0,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-07 23:13:45\"}', '192.168.2.4', '34', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 23:14:13');
INSERT INTO `sys_log` VALUES ('3636', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"component\":\"system/busLawEnforcement/index\",\"componentName\":\"BusLawEnforcement\",\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":false,\"menuSort\":9,\"path\":\"busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":121,\"subCount\":3,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}', '192.168.2.4', '24', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 23:14:57');
INSERT INTO `sys_log` VALUES ('3637', '修改角色菜单', 'INFO', 'me.zhengjie.modules.system.rest.RoleController.updateRoleMenu()', '{\"dataScope\":\"本级\",\"id\":1,\"level\":3,\"menus\":[{\"hasChildren\":false,\"id\":35,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":37,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":39,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":44,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":45,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":46,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":48,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":49,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":50,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":52,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":53,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":117,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":54,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":118,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":119,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":56,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":120,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":57,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":121,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":58,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":60,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":61,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":62,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":64,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":1,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":65,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":2,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":66,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":3,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":5,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":10,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":11,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":77,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":78,\"leaf\":true,\"menuSort\":999,\"subCount\":0},{\"hasChildren\":false,\"id\":79,\"leaf\":true,\"menuSort\":999,\"subCount\":0}]}', '192.168.2.4', '29', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 23:15:44');
INSERT INTO `sys_log` VALUES ('3638', '修改菜单', 'INFO', 'me.zhengjie.modules.system.rest.MenuController.updateMenu()', '{\"IFrame\":false,\"cache\":false,\"children\":[{\"IFrame\":false,\"cache\":false,\"component\":\"system/busLawEnforcement/index\",\"componentName\":\"BusLawEnforcement\",\"createBy\":\"admin\",\"createTime\":\"2025-05-04 11:16:48\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"anq\",\"id\":117,\"label\":\"执法数据\",\"leaf\":false,\"menuSort\":9,\"path\":\"busLawEnforcement\",\"permission\":\"busLawEnforcement:list\",\"pid\":121,\"subCount\":3,\"title\":\"执法数据\",\"type\":1,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-04 11:16:48\"}],\"createBy\":\"admin\",\"createTime\":\"2025-05-07 23:13:45\",\"hasChildren\":true,\"hidden\":false,\"icon\":\"lock\",\"id\":121,\"label\":\"执法管理\",\"leaf\":false,\"menuSort\":999,\"path\":\"busLawEnforcement\",\"subCount\":1,\"title\":\"执法管理\",\"type\":0,\"updateBy\":\"admin\",\"updateTime\":\"2025-05-07 23:13:45\"}', '192.168.2.4', '20', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-07 23:16:35');
INSERT INTO `sys_log` VALUES ('3639', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"8\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:d92db6534ee94b328010ea7b68d5212b\"}', '192.168.2.4', '96', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-07 23:20:23');
INSERT INTO `sys_log` VALUES ('3640', '用户登录', 'ERROR', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"30\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:acca60ddd0dd4eaaabc661e3bfd76229\"}', '192.168.5.120', '376', 'admin', '内网IP', 'MSEdge 131', 'me.zhengjie.exception.BadRequestException: 验证码不存在或已过期\r\n	at me.zhengjie.modules.security.rest.AuthController.login(AuthController.java:89)\r\n	at me.zhengjie.modules.security.rest.AuthController$$FastClassBySpringCGLIB$$7f997139.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)\r\n	at me.zhengjie.aspect.LogAspect.logAround(LogAspect.java:68)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)\r\n	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)\r\n	at me.zhengjie.modules.security.rest.AuthController$$EnhancerBySpringCGLIB$$4930ab81.login(<generated>)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)\r\n	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)\r\n	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)\r\n	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)\r\n	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:114)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at me.zhengjie.modules.security.security.TokenFilter.doFilter(TokenFilter.java:73)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221)\r\n	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)\r\n	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)\r\n	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)\r\n	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)\r\n	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)\r\n	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)\r\n	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)\r\n	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)\r\n	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)\r\n	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)\r\n	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)\r\n	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n	at java.lang.Thread.run(Thread.java:748)\r\n', '2025-05-08 10:39:20');
INSERT INTO `sys_log` VALUES ('3641', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"5\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:09b362dcbf974c43a30abe9c75cbc773\"}', '192.168.5.120', '207', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-08 10:39:24');
INSERT INTO `sys_log` VALUES ('3642', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseDescription\":\"该酒吧发生群体性斗殴事件\",\"caseLocation\":\"上海市静安区\",\"caseNumber\":\"2025-GA-035\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-11-08 23:30:00\",\"caseTitle\":\"某酒吧打架斗殴案\",\"caseType\":\"治安管理\",\"createTime\":\"2025-05-04 10:49:25\",\"enforcementAction\":\"现场处置\",\"enforcementDepartment\":\"上海市公安局治安总队\",\"evidenceList\":\"监控录像,伤情鉴定,证人证言\",\"filingTime\":\"2025-11-10 10:00:00\",\"hexId\":\"123123\",\"id\":35,\"involvedCompany\":\"某娱乐管理有限公司\",\"involvedPerson\":\"王某\",\"lawEnforcementOfficer\":\"方警官\",\"legalBasis\":\"《中华人民共和国治安管理处罚法》第二十六条\",\"punishmentAmount\":200000,\"punishmentType\":\"罚款+停业整顿\",\"remark\":\"酒吧正在停业整顿\",\"updateTime\":\"2025-05-04 10:49:25\"}', '192.168.5.120', '3597', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-08 10:44:09');
INSERT INTO `sys_log` VALUES ('3643', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseDescription\":\"该酒吧发生群体性斗殴事件\",\"caseLocation\":\"上海市静安区\",\"caseNumber\":\"2025-GA-035\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-11-08 23:30:00\",\"caseTitle\":\"某酒吧打架斗殴案\",\"caseType\":\"治安管理\",\"createTime\":\"2025-05-04 10:49:25\",\"enforcementAction\":\"现场处置\",\"enforcementDepartment\":\"上海市公安局治安总队\",\"evidenceList\":\"监控录像,伤情鉴定,证人证言\",\"filingTime\":\"2025-11-10 10:00:00\",\"hexId\":\"123123\",\"id\":35,\"involvedCompany\":\"某娱乐管理有限公司\",\"involvedPerson\":\"王某\",\"lawEnforcementOfficer\":\"方警官\",\"legalBasis\":\"《中华人民共和国治安管理处罚法》第二十六条\",\"punishmentAmount\":200000,\"punishmentType\":\"罚款+停业整顿\",\"remark\":\"酒吧正在停业整顿\",\"updateTime\":\"2025-05-04 10:49:25\"}', '192.168.5.120', '3560', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-08 10:45:11');
INSERT INTO `sys_log` VALUES ('3644', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseDescription\":\"该酒吧发生群体性斗殴事件\",\"caseLocation\":\"上海市静安区\",\"caseNumber\":\"2025-GA-035\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-11-08 23:30:00\",\"caseTitle\":\"某酒吧打架斗殴案\",\"caseType\":\"治安管理\",\"createTime\":\"2025-05-04 10:49:25\",\"enforcementAction\":\"现场处置\",\"enforcementDepartment\":\"上海市公安局治安总队\",\"evidenceList\":\"监控录像,伤情鉴定,证人证言\",\"filingTime\":\"2025-11-10 10:00:00\",\"hexId\":\"123123\",\"id\":35,\"involvedCompany\":\"某娱乐管理有限公司\",\"involvedPerson\":\"王某\",\"lawEnforcementOfficer\":\"方警官\",\"legalBasis\":\"《中华人民共和国治安管理处罚法》第二十六条\",\"punishmentAmount\":200000,\"punishmentType\":\"罚款+停业整顿\",\"remark\":\"酒吧正在停业整顿\",\"updateTime\":\"2025-05-04 10:49:25\"}', '192.168.5.120', '145', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-08 10:52:51');
INSERT INTO `sys_log` VALUES ('3645', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"27\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:11a2ffc3738a41028c88fcd449d84a67\"}', '192.168.5.120', '595', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-08 20:18:01');
INSERT INTO `sys_log` VALUES ('3646', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseDescription\":\"该酒吧发生群体性斗殴事件\",\"caseLocation\":\"上海市静安区\",\"caseNumber\":\"2025-GA-035\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-11-08 23:30:00\",\"caseTitle\":\"某酒吧打架斗殴案\",\"caseType\":\"治安管理\",\"createTime\":\"2025-05-04 10:49:25\",\"enforcementAction\":\"现场处置\",\"enforcementDepartment\":\"上海市公安局治安总队\",\"evidenceList\":\"监控录像,伤情鉴定,证人证言\",\"filingTime\":\"2025-11-10 10:00:00\",\"hexId\":\"0x603f00236f1d1278f0e711530110caf8ae18584108fe077cec2717876ae1ce7b\",\"id\":35,\"involvedCompany\":\"某娱乐管理有限公司\",\"involvedPerson\":\"王某\",\"lawEnforcementOfficer\":\"方警官\",\"legalBasis\":\"《中华人民共和国治安管理处罚法》第二十六条\",\"punishmentAmount\":200000,\"punishmentType\":\"罚款+停业整顿\",\"remark\":\"酒吧正在停业整顿\",\"updateTime\":\"2025-05-04 10:49:25\"}', '192.168.5.120', '69', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-08 20:18:25');
INSERT INTO `sys_log` VALUES ('3647', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"5\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:c160e6e56c814b7cad87e2218a2755d6\"}', '192.168.2.4', '729', 'admin', '内网IP', 'Chrome 101.0.4951.64', null, '2025-05-09 00:00:53');
INSERT INTO `sys_log` VALUES ('3648', '用户登录', 'ERROR', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"8\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:2a41617abadd4a8b842f4a842b8fa462\"}', '192.168.2.4', '358', 'admin', '内网IP', 'MSEdge 131', 'me.zhengjie.exception.BadRequestException: 验证码不存在或已过期\r\n	at me.zhengjie.modules.security.rest.AuthController.login(AuthController.java:89)\r\n	at me.zhengjie.modules.security.rest.AuthController$$FastClassBySpringCGLIB$$7f997139.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)\r\n	at me.zhengjie.aspect.LogAspect.logAround(LogAspect.java:68)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)\r\n	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)\r\n	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)\r\n	at me.zhengjie.modules.security.rest.AuthController$$EnhancerBySpringCGLIB$$3f203ac0.login(<generated>)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)\r\n	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)\r\n	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)\r\n	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)\r\n	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)\r\n	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n	at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:114)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)\r\n	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122)\r\n	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)\r\n	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at me.zhengjie.modules.security.security.TokenFilter.doFilter(TokenFilter.java:73)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)\r\n	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)\r\n	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112)\r\n	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)\r\n	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221)\r\n	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)\r\n	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)\r\n	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)\r\n	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)\r\n	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)\r\n	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)\r\n	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)\r\n	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)\r\n	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)\r\n	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)\r\n	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)\r\n	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)\r\n	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)\r\n	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)\r\n	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)\r\n	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)\r\n	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n	at java.lang.Thread.run(Thread.java:748)\r\n', '2025-05-09 21:20:48');
INSERT INTO `sys_log` VALUES ('3649', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"-2\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:cd68bb7fd28848b49b3ee34db1faf93b\"}', '192.168.2.4', '146', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-09 21:20:52');
INSERT INTO `sys_log` VALUES ('3650', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseDescription\":\"该酒吧发生群体性斗殴事件\",\"caseLocation\":\"上海市静安区\",\"caseNumber\":\"2025-GA-035\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-11-08 23:30:00\",\"caseTitle\":\"某酒吧打架斗殴案\",\"caseType\":\"治安管理\",\"createTime\":\"2025-05-04 10:49:25\",\"enforcementAction\":\"现场处置\",\"enforcementDepartment\":\"上海市公安局治安总队\",\"evidenceList\":\"监控录像,伤情鉴定,证人证言\",\"filingTime\":\"2025-11-10 10:00:00\",\"hexId\":\"0x9d36bb24c1c50fc907dd594f42e1a6c5b8b81bb32849c1544f2db99bba853784\",\"id\":35,\"involvedCompany\":\"某娱乐管理有限公司\",\"involvedPerson\":\"王某\",\"lawEnforcementOfficer\":\"方警官\",\"legalBasis\":\"《中华人民共和国治安管理处罚法》第二十六条\",\"punishmentAmount\":200000,\"punishmentType\":\"罚款+停业整顿\",\"remark\":\"酒吧正在停业整顿\",\"updateTime\":\"2025-05-04 10:49:25\"}', '192.168.2.4', '78', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-09 21:21:04');
INSERT INTO `sys_log` VALUES ('3651', '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthController.login()', '{\"code\":\"4\",\"password\":\"******\",\"username\":\"admin\",\"uuid\":\"captcha_code:e155b63a5d1c4e54b9b3298d65fa40c0\"}', '192.168.2.4', '123', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-09 21:32:12');
INSERT INTO `sys_log` VALUES ('3652', '新增busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.createBusLawEnforcement()', '{\"caseAmount\":30000,\"caseDescription\":\"交通红灯\",\"caseLocation\":\"上海市浦东新区\",\"caseNumber\":\"1112134-123ADF\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-05-09 21:33:01\",\"caseTitle\":\"交通红灯\",\"caseType\":\"交通违规\",\"enforcementAction\":\"1112\",\"enforcementDepartment\":\"xx部门\",\"evidenceList\":\"xxx\",\"filingTime\":\"2025-05-09 21:33:49\",\"id\":36,\"involvedCompany\":\"某某滴滴公司\",\"involvedPerson\":\"唐某某\",\"lawEnforcementOfficer\":\"陈某某\",\"legalBasis\":\"xx\",\"punishmentAmount\":20000,\"punishmentType\":\"罚款\",\"remark\":\"aadf\"}', '192.168.2.4', '15', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-09 21:33:56');
INSERT INTO `sys_log` VALUES ('3653', '修改busLawEnforcement', 'INFO', 'me.zhengjie.modules.system.rest.BusLawEnforcementController.updateBusLawEnforcement()', '{\"caseAmount\":30000,\"caseDescription\":\"交通红灯\",\"caseLocation\":\"上海市浦东新区\",\"caseNumber\":\"1112134-123ADF\",\"caseStatus\":\"处理中\",\"caseTime\":\"2025-05-09 21:33:01\",\"caseTitle\":\"交通红灯\",\"caseType\":\"交通违规\",\"createTime\":\"2025-05-09 21:33:55\",\"enforcementAction\":\"缴纳罚款\",\"enforcementDepartment\":\"交通执法部门\",\"evidenceList\":\"xxx\",\"filingTime\":\"2025-05-09 21:33:49\",\"hexId\":\"0xc9cb653d0ddb77218b717a2ccba6a0c98a7c453c76afaaed4b496d0533ec31e2\",\"id\":36,\"involvedCompany\":\"某某滴滴公司\",\"involvedPerson\":\"唐某某\",\"lawEnforcementOfficer\":\"陈某某\",\"legalBasis\":\"xx\",\"punishmentAmount\":20000,\"punishmentType\":\"罚款\",\"remark\":\"aadf\",\"updateTime\":\"2025-05-09 21:33:55\"}', '192.168.2.4', '83', 'admin', '内网IP', 'MSEdge 131', null, '2025-05-09 21:34:47');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级菜单ID',
  `sub_count` int(5) DEFAULT '0' COMMENT '子菜单数目',
  `type` int(11) DEFAULT NULL COMMENT '菜单类型',
  `title` varchar(100) DEFAULT NULL COMMENT '菜单标题',
  `name` varchar(100) DEFAULT NULL COMMENT '组件名称',
  `component` varchar(255) DEFAULT NULL COMMENT '组件',
  `menu_sort` int(5) DEFAULT NULL COMMENT '排序',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `path` varchar(255) DEFAULT NULL COMMENT '链接地址',
  `i_frame` bit(1) DEFAULT NULL COMMENT '是否外链',
  `cache` bit(1) DEFAULT b'0' COMMENT '缓存',
  `hidden` bit(1) DEFAULT b'0' COMMENT '隐藏',
  `permission` varchar(255) DEFAULT NULL COMMENT '权限',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`menu_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`),
  UNIQUE KEY `uniq_title` (`title`),
  KEY `idx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1', null, '6', '0', '系统管理', null, null, '1', 'system', 'system', '\0', '\0', '\0', null, null, 'admin', '2018-12-18 15:11:29', '2025-01-14 15:48:18');
INSERT INTO `sys_menu` VALUES ('2', '1', '3', '1', '用户管理', 'User', 'system/user/index', '2', 'peoples', 'user', '\0', '\0', '\0', 'user:list', null, null, '2018-12-18 15:14:44', null);
INSERT INTO `sys_menu` VALUES ('3', '1', '3', '1', '角色管理', 'Role', 'system/role/index', '3', 'role', 'role', '\0', '\0', '\0', 'roles:list', null, null, '2018-12-18 15:16:07', null);
INSERT INTO `sys_menu` VALUES ('5', '1', '3', '1', '菜单管理', 'Menu', 'system/menu/index', '5', 'menu', 'menu', '\0', '\0', '\0', 'menu:list', null, null, '2018-12-18 15:17:28', null);
INSERT INTO `sys_menu` VALUES ('35', '1', '3', '1', '部门管理', 'Dept', 'system/dept/index', '6', 'dept', 'dept', '\0', '\0', '\0', 'dept:list', null, null, '2019-03-25 09:46:00', null);
INSERT INTO `sys_menu` VALUES ('37', '1', '3', '1', '岗位管理', 'Job', 'system/job/index', '7', 'Steve-Jobs', 'job', '\0', '\0', '\0', 'job:list', null, null, '2019-03-29 13:51:18', null);
INSERT INTO `sys_menu` VALUES ('39', '1', '3', '1', '字典管理', 'Dict', 'system/dict/index', '8', 'dictionary', 'dict', '\0', '\0', '\0', 'dict:list', null, null, '2019-04-10 11:49:04', null);
INSERT INTO `sys_menu` VALUES ('44', '2', '0', '2', '用户新增', null, '', '2', '', '', '\0', '\0', '\0', 'user:add', null, null, '2019-10-29 10:59:46', null);
INSERT INTO `sys_menu` VALUES ('45', '2', '0', '2', '用户编辑', null, '', '3', '', '', '\0', '\0', '\0', 'user:edit', null, null, '2019-10-29 11:00:08', null);
INSERT INTO `sys_menu` VALUES ('46', '2', '0', '2', '用户删除', null, '', '4', '', '', '\0', '\0', '\0', 'user:del', null, null, '2019-10-29 11:00:23', null);
INSERT INTO `sys_menu` VALUES ('48', '3', '0', '2', '角色创建', null, '', '2', '', '', '\0', '\0', '\0', 'roles:add', null, null, '2019-10-29 12:45:34', null);
INSERT INTO `sys_menu` VALUES ('49', '3', '0', '2', '角色修改', null, '', '3', '', '', '\0', '\0', '\0', 'roles:edit', null, null, '2019-10-29 12:46:16', null);
INSERT INTO `sys_menu` VALUES ('50', '3', '0', '2', '角色删除', null, '', '4', '', '', '\0', '\0', '\0', 'roles:del', null, null, '2019-10-29 12:46:51', null);
INSERT INTO `sys_menu` VALUES ('52', '5', '0', '2', '菜单新增', null, '', '2', '', '', '\0', '\0', '\0', 'menu:add', null, null, '2019-10-29 12:55:07', null);
INSERT INTO `sys_menu` VALUES ('53', '5', '0', '2', '菜单编辑', null, '', '3', '', '', '\0', '\0', '\0', 'menu:edit', null, null, '2019-10-29 12:55:40', null);
INSERT INTO `sys_menu` VALUES ('54', '5', '0', '2', '菜单删除', null, '', '4', '', '', '\0', '\0', '\0', 'menu:del', null, null, '2019-10-29 12:56:00', null);
INSERT INTO `sys_menu` VALUES ('56', '35', '0', '2', '部门新增', null, '', '2', '', '', '\0', '\0', '\0', 'dept:add', null, null, '2019-10-29 12:57:09', null);
INSERT INTO `sys_menu` VALUES ('57', '35', '0', '2', '部门编辑', null, '', '3', '', '', '\0', '\0', '\0', 'dept:edit', null, null, '2019-10-29 12:57:27', null);
INSERT INTO `sys_menu` VALUES ('58', '35', '0', '2', '部门删除', null, '', '4', '', '', '\0', '\0', '\0', 'dept:del', null, null, '2019-10-29 12:57:41', null);
INSERT INTO `sys_menu` VALUES ('60', '37', '0', '2', '岗位新增', null, '', '2', '', '', '\0', '\0', '\0', 'job:add', null, null, '2019-10-29 12:58:27', null);
INSERT INTO `sys_menu` VALUES ('61', '37', '0', '2', '岗位编辑', null, '', '3', '', '', '\0', '\0', '\0', 'job:edit', null, null, '2019-10-29 12:58:45', null);
INSERT INTO `sys_menu` VALUES ('62', '37', '0', '2', '岗位删除', null, '', '4', '', '', '\0', '\0', '\0', 'job:del', null, null, '2019-10-29 12:59:04', null);
INSERT INTO `sys_menu` VALUES ('64', '39', '0', '2', '字典新增', null, '', '2', '', '', '\0', '\0', '\0', 'dict:add', null, null, '2019-10-29 13:00:17', null);
INSERT INTO `sys_menu` VALUES ('65', '39', '0', '2', '字典编辑', null, '', '3', '', '', '\0', '\0', '\0', 'dict:edit', null, null, '2019-10-29 13:00:42', null);
INSERT INTO `sys_menu` VALUES ('66', '39', '0', '2', '字典删除', null, '', '4', '', '', '\0', '\0', '\0', 'dict:del', null, null, '2019-10-29 13:00:59', null);
INSERT INTO `sys_menu` VALUES ('77', '18', '0', '2', '上传文件', null, '', '2', '', '', '\0', '\0', '\0', 'storage:add', null, null, '2019-10-29 13:09:09', null);
INSERT INTO `sys_menu` VALUES ('78', '18', '0', '2', '文件编辑', null, '', '3', '', '', '\0', '\0', '\0', 'storage:edit', null, null, '2019-10-29 13:09:22', null);
INSERT INTO `sys_menu` VALUES ('79', '18', '0', '2', '文件删除', null, '', '4', '', '', '\0', '\0', '\0', 'storage:del', null, null, '2019-10-29 13:09:34', null);
INSERT INTO `sys_menu` VALUES ('117', '121', '3', '1', '执法数据', 'BusLawEnforcement', 'system/busLawEnforcement/index', '9', 'anq', 'busLawEnforcement', '\0', '\0', '\0', 'busLawEnforcement:list', 'admin', 'admin', '2025-05-04 11:16:48', '2025-05-04 11:16:48');
INSERT INTO `sys_menu` VALUES ('118', '117', '0', '2', '添加', null, null, '1', null, null, '\0', '\0', '\0', 'busLawEnforcement:add', 'admin', 'admin', '2025-05-04 11:21:09', '2025-05-04 11:21:09');
INSERT INTO `sys_menu` VALUES ('119', '117', '0', '2', '修改', null, null, '999', null, null, '\0', '\0', '\0', 'busLawEnforcement:edit', 'admin', 'admin', '2025-05-04 11:21:38', '2025-05-04 11:21:38');
INSERT INTO `sys_menu` VALUES ('120', '117', '0', '2', '删除', null, null, '3', null, null, '\0', '\0', '\0', 'busLawEnforcement:del', 'admin', 'admin', '2025-05-04 11:22:06', '2025-05-04 11:22:06');
INSERT INTO `sys_menu` VALUES ('121', null, '1', '0', '执法管理', null, null, '999', 'lock', 'busLawEnforcement', '\0', '\0', '\0', null, 'admin', 'admin', '2025-05-07 23:13:45', '2025-05-07 23:13:45');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(100) NOT NULL COMMENT '名称',
  `level` int(50) DEFAULT NULL COMMENT '角色级别',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `data_scope` varchar(255) DEFAULT NULL COMMENT '数据权限',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`),
  KEY `idx_level` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1', '超级管理员', '1', '-', '全部', null, 'admin', '2018-11-23 11:04:37', '2020-08-06 16:10:24');
INSERT INTO `sys_role` VALUES ('2', '普通用户', '2', '-', '本级', null, 'admin', '2018-11-23 13:09:06', '2020-09-05 10:45:12');

-- ----------------------------
-- Table structure for sys_roles_depts
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_depts`;
CREATE TABLE `sys_roles_depts` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE,
  KEY `idx_role_id` (`role_id`),
  KEY `idx_dept_id` (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色部门关联';

-- ----------------------------
-- Records of sys_roles_depts
-- ----------------------------

-- ----------------------------
-- Table structure for sys_roles_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_menus`;
CREATE TABLE `sys_roles_menus` (
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`menu_id`,`role_id`) USING BTREE,
  KEY `idx_menu_id` (`menu_id`),
  KEY `idx_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色菜单关联';

-- ----------------------------
-- Records of sys_roles_menus
-- ----------------------------
INSERT INTO `sys_roles_menus` VALUES ('1', '1');
INSERT INTO `sys_roles_menus` VALUES ('1', '2');
INSERT INTO `sys_roles_menus` VALUES ('2', '1');
INSERT INTO `sys_roles_menus` VALUES ('2', '2');
INSERT INTO `sys_roles_menus` VALUES ('3', '1');
INSERT INTO `sys_roles_menus` VALUES ('5', '1');
INSERT INTO `sys_roles_menus` VALUES ('10', '1');
INSERT INTO `sys_roles_menus` VALUES ('11', '1');
INSERT INTO `sys_roles_menus` VALUES ('30', '2');
INSERT INTO `sys_roles_menus` VALUES ('35', '1');
INSERT INTO `sys_roles_menus` VALUES ('36', '2');
INSERT INTO `sys_roles_menus` VALUES ('37', '1');
INSERT INTO `sys_roles_menus` VALUES ('39', '1');
INSERT INTO `sys_roles_menus` VALUES ('44', '1');
INSERT INTO `sys_roles_menus` VALUES ('45', '1');
INSERT INTO `sys_roles_menus` VALUES ('46', '1');
INSERT INTO `sys_roles_menus` VALUES ('48', '1');
INSERT INTO `sys_roles_menus` VALUES ('49', '1');
INSERT INTO `sys_roles_menus` VALUES ('50', '1');
INSERT INTO `sys_roles_menus` VALUES ('52', '1');
INSERT INTO `sys_roles_menus` VALUES ('53', '1');
INSERT INTO `sys_roles_menus` VALUES ('54', '1');
INSERT INTO `sys_roles_menus` VALUES ('56', '1');
INSERT INTO `sys_roles_menus` VALUES ('57', '1');
INSERT INTO `sys_roles_menus` VALUES ('58', '1');
INSERT INTO `sys_roles_menus` VALUES ('60', '1');
INSERT INTO `sys_roles_menus` VALUES ('61', '1');
INSERT INTO `sys_roles_menus` VALUES ('62', '1');
INSERT INTO `sys_roles_menus` VALUES ('64', '1');
INSERT INTO `sys_roles_menus` VALUES ('65', '1');
INSERT INTO `sys_roles_menus` VALUES ('66', '1');
INSERT INTO `sys_roles_menus` VALUES ('77', '1');
INSERT INTO `sys_roles_menus` VALUES ('78', '1');
INSERT INTO `sys_roles_menus` VALUES ('79', '1');
INSERT INTO `sys_roles_menus` VALUES ('82', '2');
INSERT INTO `sys_roles_menus` VALUES ('116', '2');
INSERT INTO `sys_roles_menus` VALUES ('117', '1');
INSERT INTO `sys_roles_menus` VALUES ('118', '1');
INSERT INTO `sys_roles_menus` VALUES ('119', '1');
INSERT INTO `sys_roles_menus` VALUES ('120', '1');
INSERT INTO `sys_roles_menus` VALUES ('121', '1');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门名称',
  `username` varchar(180) DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(255) DEFAULT NULL COMMENT '昵称',
  `gender` varchar(2) DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(180) DEFAULT NULL COMMENT '邮箱',
  `avatar_name` varchar(255) DEFAULT NULL COMMENT '头像地址',
  `avatar_path` varchar(255) DEFAULT NULL COMMENT '头像真实路径',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `is_admin` bit(1) DEFAULT b'0' COMMENT '是否为admin账号',
  `enabled` bit(1) DEFAULT NULL COMMENT '状态：1启用、0禁用',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `pwd_reset_time` datetime DEFAULT NULL COMMENT '修改密码的时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `uniq_email` (`email`) USING BTREE,
  UNIQUE KEY `uniq_username` (`username`) USING BTREE,
  KEY `idx_dept_id` (`dept_id`) USING BTREE,
  KEY `idx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', '2', 'admin', '管理员', '男', '18888888888', '201507802@qq.com', 'avatar-20250507101352916.png', 'C:\\eladmin\\avatar\\avatar-20250507101352916.png', '$2a$10$Egp1/gvFlt7zhlXVfEFw4OfWQCGPw0ClmMcc6FjTnvXNRVf9zdMRa', '', '', null, 'admin', '2020-05-03 16:38:31', '2025-05-06 09:11:56', '2020-09-05 10:43:31');
INSERT INTO `sys_user` VALUES ('2', '2', 'test', '测试', '男', '19999999999', '231@qq.com', null, null, '$2a$10$4XcyudOYTSz6fue6KFNMHeUQnCX5jbBQypLEnGk1PmekXt5c95JcK', '\0', '', 'admin', 'admin', null, '2025-05-07 09:11:56', '2020-09-05 10:43:38');

-- ----------------------------
-- Table structure for sys_users_jobs
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_jobs`;
CREATE TABLE `sys_users_jobs` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `job_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`job_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_job_id` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户与岗位关联表';

-- ----------------------------
-- Records of sys_users_jobs
-- ----------------------------
INSERT INTO `sys_users_jobs` VALUES ('1', '11');
INSERT INTO `sys_users_jobs` VALUES ('2', '12');

-- ----------------------------
-- Table structure for sys_users_roles
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_roles`;
CREATE TABLE `sys_users_roles` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `idx_user_id` (`user_id`),
  KEY `idx_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户角色关联';

-- ----------------------------
-- Records of sys_users_roles
-- ----------------------------
INSERT INTO `sys_users_roles` VALUES ('1', '1');
INSERT INTO `sys_users_roles` VALUES ('2', '2');
