tangzheng/block-law-enforcement
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
master
block-law-enforcement/eladmin/law-enforcement.sql
tangzh 5bc72e6f3b 推送
2025-05-11 21:16:30 +08:00

611 lines
183 KiB
SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
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');
Reference in New Issue View Git Blame Copy Permalink