-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdemo_data.sql
More file actions
228 lines (217 loc) · 28.4 KB
/
Copy pathdemo_data.sql
File metadata and controls
228 lines (217 loc) · 28.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
-- ============================================================
-- 民宿酒店管理系统 —— 演示数据补充脚本
-- 用法：在 init.sql 已执行的前提下，直接运行本脚本即可
-- 注意：本脚本可重复执行（先删旧数据再插入）
-- ============================================================
USE `homestay`;
-- ============================================================
-- 1. 角色（2角色体系：admin/服务员）
-- ============================================================
DELETE FROM `sys_role` WHERE `id` IN (2, 3);
INSERT INTO `sys_role` (`id`, `status`, `name`, `code`, `remark`) VALUES
(2, 0, '服务员', 'worker', '酒店管理权限');
-- 给服务员分配菜单权限
DELETE FROM `sys_role_menu` WHERE `role_id` IN (2, 3);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES
-- 服务员：控制台 + 酒店管理（订单/房间/客户）
(2, 1), (2, 2), (2, 3), (2, 8), (2, 9);
-- ============================================================
-- 2. 系统用户（补充 1 个服务员，共 2 个，密码均为 123456）
-- ============================================================
DELETE FROM `sys_user` WHERE `id` IN (2, 3, 4, 5);
INSERT INTO `sys_user` (`id`, `role`, `status`, `username`, `password`, `real_name`,
`id_card`, `gender`, `address`, `email`, `phonenumber`, `remark`, `create_time`) VALUES
(2, 2, 0, 'zhangwei', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '张伟', '110101199001011234', '男', '北京市海淀区中关村大街1号',
'zhangwei@homestay.com', '13910001001', '服务员', '2025-03-15 09:00:00');
-- ============================================================
-- 3. 前台客户（补充 14 个，共 15 个，密码均为 123456）
-- ============================================================
DELETE FROM `h_user` WHERE `id` BETWEEN 2 AND 15;
INSERT INTO `h_user` (`id`, `username`, `password`, `real_name`, `phone`, `gender`,
`id_card`, `total`, `status`, `create_time`, `login_time`) VALUES
(2, 'lihua', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '李华', '13600001001', '男', '110101198801011111', 3596.00, 0, '2025-08-10 10:00:00', '2026-06-20 08:30:00'),
(3, 'wangjing', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '王静', '13600002002', '女', '310101199002022222', 8985.00, 0, '2025-09-15 14:20:00', '2026-06-25 19:00:00'),
(4, 'zhaolei', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '赵磊', '13600003003', '男', '440101198703033333', 2397.00, 0, '2025-10-01 09:10:00', '2026-06-18 11:00:00'),
(5, 'sunli', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '孙丽', '13600004004', '女', '510101199204044444', 12580.00, 0, '2025-11-05 16:40:00', '2026-06-28 15:20:00'),
(6, 'zhoujie', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '周杰', '13600005005', '男', '330101198505055555', 5988.00, 0, '2025-12-20 11:30:00', '2026-06-10 09:00:00'),
(7, 'wumin', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '吴敏', '13600006006', '女', '320101199106066666', 1798.00, 0, '2026-01-08 08:50:00', '2026-06-22 20:00:00'),
(8, 'zhengqiang','$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy','郑强', '13600007007', '男', '610101198807077777', 4196.00, 0, '2026-01-25 13:00:00', '2026-06-15 10:30:00'),
(9, 'huangrong','$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '黄蓉', '13600008008', '女', '420101199308088888', 7188.00, 0, '2026-02-14 10:20:00', '2026-06-27 18:00:00'),
(10, 'linzhi', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '林志', '13600009009', '男', '500101198609099999', 3594.00, 0, '2026-03-01 15:40:00', '2026-06-05 07:00:00'),
(11, 'xuyan', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '许燕', '13600010010', '女', '350101199410100100', 5390.00, 0, '2026-03-20 09:00:00', '2026-06-26 12:00:00'),
(12, 'heming', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '何明', '13600011011', '男', '430101198711110110', 1198.00, 0, '2026-04-05 17:30:00', '2026-06-01 16:00:00'),
(13, 'dengxia', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '邓霞', '13600012012', '女', '210101199512120120', 2996.00, 0, '2026-04-28 11:10:00', '2026-06-20 14:00:00'),
(14, 'hanpeng', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '韩鹏', '13600013013', '男', '220101198901130130', 4794.00, 0, '2026-05-15 08:20:00', '2026-06-28 09:30:00'),
(15, 'tangyun', '$2a$10$RaINBk/KAMHz3sfB/kUV6OLvmsKcj18epkr7dXShw6l0NPBaUdNfy', '唐云', '13600014014', '女', '530101199202140140', 1598.00, 0, '2026-06-01 10:00:00', '2026-06-29 11:00:00');
-- ============================================================
-- 4. 房间（补充 12 个，共 15 个，覆盖多城市多类型）
-- ============================================================
DELETE FROM `h_room` WHERE `id` BETWEEN 4 AND 15;
INSERT INTO `h_room` (`id`, `status`, `name`, `city`, `device`, `address`, `code`,
`category`, `price`, `state`, `seat`, `describe`, `weight`, `create_time`) VALUES
-- 北京
(4, 0, '京城四合院精品房', '北京', '空调、WiFi、投影仪、智能马桶、茶具', '北京市东城区南锣鼓巷45号', 'BJ-201', '四合院', 688.00, '空闲', 2, '坐落于南锣鼓巷核心区域，原汁原味老北京四合院改造，庭院深深，闹中取静。', 20, '2025-05-01 10:00:00'),
(5, 0, '国贸CBD商务房', '北京', '空调、WiFi、办公桌、迷你吧、洗衣机', '北京市朝阳区建国门外大街1号', 'BJ-305', '商务房', 458.00, '预订', 2, '紧邻国贸商圈，落地窗俯瞰CBD天际线，商务出行首选。', 15, '2025-06-15 10:00:00'),
-- 上海
(6, 0, '外滩江景套房', '上海', '空调、WiFi、浴缸、江景阳台、音响', '上海市黄浦区中山东一路18号', 'SH-801', '江景套房', 1288.00, '入住', 2, '270度外滩江景，夜晚可饱览陆家嘴灯光秀，顶级入住体验。', 25, '2025-04-20 10:00:00'),
(7, 0, '法租界洋房loft', '上海', 'WiFi、空调、厨房、洗衣机、投影仪', '上海市徐汇区武康路200号', 'SH-102', 'Loft', 768.00, '空闲', 4, '百年花园洋房改造，法式风情loft结构，步行可达武康大楼。', 18, '2025-07-10 10:00:00'),
-- 广州
(8, 0, '珠江新城亲子房', '广州', '空调、WiFi、儿童设施、厨房、洗衣机', '广州市天河区珠江新城花城大道66号','GZ-503','亲子房', 528.00, '空闲', 4, '宽敞亲子空间，配备儿童游乐设施，邻近广州塔和花城广场。', 12, '2025-08-01 10:00:00'),
-- 深圳
(9, 0, '深圳湾海景房', '深圳', '空调、WiFi、海景阳台、浴缸、咖啡机', '深圳市南山区深圳湾科技生态园', 'SZ-1201','海景房', 888.00, '空闲', 2, '高层无遮挡海景，日出日落尽收眼底，毗邻深圳湾公园。', 22, '2025-05-20 10:00:00'),
(10, 0, '华强北数码主题房', '深圳', 'WiFi、空调、电竞桌椅、大屏投影、冰箱','深圳市福田区华强北路100号', 'SZ-302', '主题房', 368.00, '空闲', 2, '科技主题装修，配备顶级电竞设备，数码爱好者天堂。', 10, '2025-09-15 10:00:00'),
-- 成都
(11, 0, '宽窄巷子禅意房', '成都', '空调、WiFi、茶室、庭院、香薰', '成都市青羊区宽窄巷子12号', 'CD-101', '禅意房', 498.00, '预订', 2, '中式禅意装修，私享小庭院，出门即是宽窄巷子，体验慢生活。', 16, '2025-10-01 10:00:00'),
(12, 0, '春熙路潮流双床房', '成都', '空调、WiFi、电视、冰箱、洗衣机', '成都市锦江区春熙路99号', 'CD-605', '双床房', 328.00, '空闲', 4, '春熙路核心地段，下楼即太古里和IFS，逛街购物超方便。', 14, '2025-11-01 10:00:00'),
-- 杭州
(13, 0, '西湖景观民宿', '杭州', '空调、WiFi、湖景阳台、茶具、浴缸', '杭州市上城区南山路200号', 'HZ-301', '湖景房', 958.00, '空闲', 2, '推窗即见西湖，断桥残雪近在咫尺，诗意栖居。', 24, '2025-06-01 10:00:00'),
-- 厦门
(14, 0, '鼓浪屿海景别墅', '厦门', '空调、WiFi、花园、露台、海景浴缸', '厦门市思明区鼓浪屿福建路32号','XM-001', '别墅', 1588.00, '预订', 6, '百年别墅改造，面朝大海，花园环绕，鼓浪屿核心景区。', 28, '2025-07-01 10:00:00'),
-- 丽江
(15, 0, '古城纳西风情客栈', '丽江', 'WiFi、空调、庭院、观景台、民族装饰', '丽江市古城区五一街18号', 'LJ-005', '客栈', 358.00, '空闲', 2, '纳西族传统建筑风格，屋顶可观玉龙雪山，古城内步行可达四方街。', 13, '2025-08-15 10:00:00');
-- ============================================================
-- 5. 订单（35 条，覆盖全年各月，多种状态）
-- state: 预订/入住/完成/取消
-- status: 0正常 1完成 2关闭 3删除
-- pay_state: 0未支付 1已支付
-- ============================================================
DELETE FROM `h_order` WHERE `id` BETWEEN 100 AND 999;
INSERT INTO `h_order` (`id`, `user_id`, `username`, `phone`, `start_date`, `end_date`,
`amount`, `room_id`, `room_code`, `state`, `total`, `pay_state`, `status`, `days`,
`rate`, `comment`, `create_time`) VALUES
-- ===== 1月订单 =====
(100, 2, '李华', '13600001001', '2026-01-05', '2026-01-08', 2, 1, '101', '完成', 897.00, 1, 1, 3, 5, '房间很干净，位置也好，下次还来！', '2026-01-03 10:00:00'),
(101, 3, '王静', '13600002002', '2026-01-10', '2026-01-13', 1, 6, 'SH-801','完成', 3864.00, 1, 1, 3, 5, '外滩夜景太美了，值得推荐。', '2026-01-08 14:30:00'),
(102, 5, '孙丽', '13600004004', '2026-01-20', '2026-01-22', 2, 11, 'CD-101','完成', 996.00, 1, 1, 2, 4, '禅意房很有氛围，就是隔音稍差。', '2026-01-18 09:00:00'),
-- ===== 2月订单 =====
(103, 4, '赵磊', '13600003003', '2026-02-01', '2026-02-04', 4, 2, '102', '完成', 1197.00, 1, 1, 3, 4, '春节带家人出游，双床房很舒适。', '2026-01-28 16:00:00'),
(104, 6, '周杰', '13600005005', '2026-02-14', '2026-02-16', 2, 14, 'XM-001','完成', 3176.00, 1, 1, 2, 5, '情人节带老婆来鼓浪屿，别墅太棒了！', '2026-02-10 11:00:00'),
(105, 9, '黄蓉', '13600008008', '2026-02-20', '2026-02-23', 1, 13, 'HZ-301','完成', 2874.00, 1, 1, 3, 5, '西湖边上的民宿，风景绝美。', '2026-02-18 08:30:00'),
-- ===== 3月订单 =====
(106, 7, '吴敏', '13600006006', '2026-03-05', '2026-03-07', 1, 4, 'BJ-201','完成', 1376.00, 1, 1, 2, 4, '四合院很有老北京味道，推荐！', '2026-03-02 10:00:00'),
(107, 8, '郑强', '13600007007', '2026-03-15', '2026-03-18', 2, 9, 'SZ-1201','完成',2664.00, 1, 1, 3, 5, '海景房名不虚传，日出太震撼了。', '2026-03-12 15:00:00'),
(108, 10, '林志', '13600009009', '2026-03-25', '2026-03-27', 1, 15, 'LJ-005','完成', 716.00, 1, 1, 2, 4, '古城夜景很美，客栈老板很热情。', '2026-03-22 09:30:00'),
-- ===== 4月订单 =====
(109, 2, '李华', '13600001001', '2026-04-03', '2026-04-06', 2, 7, 'SH-102','完成', 2304.00, 1, 1, 3, 5, '法租界洋房太有格调了，拍照超好看。', '2026-04-01 12:00:00'),
(110, 11, '许燕', '13600010010', '2026-04-10', '2026-04-13', 1, 5, 'BJ-305','完成', 1374.00, 1, 1, 3, 4, '商务房办公很方便，下次出差还选这里。', '2026-04-08 10:00:00'),
(111, 3, '王静', '13600002002', '2026-04-20', '2026-04-22', 2, 12, 'CD-605','完成', 656.00, 1, 1, 2, 3, '春熙路位置无敌，就是有点吵。', '2026-04-18 14:00:00'),
(112, 5, '孙丽', '13600004004', '2026-04-28', '2026-04-30', 1, 1, '101', '完成', 598.00, 1, 1, 2, 4, '第二次入住了，一如既往的好。', '2026-04-25 09:00:00'),
-- ===== 5月订单（五一黄金周高峰）=====
(113, 4, '赵磊', '13600003003', '2026-05-01', '2026-05-04', 4, 6, 'SH-801','完成', 3864.00, 1, 1, 3, 4, '五一外滩人很多，但房间景观一流。', '2026-04-25 08:00:00'),
(114, 6, '周杰', '13600005005', '2026-05-01', '2026-05-03', 2, 14, 'XM-001','完成', 3176.00, 1, 1, 2, 5, '鼓浪屿五一虽然人多，别墅很私密。', '2026-04-26 10:00:00'),
(115, 9, '黄蓉', '13600008008', '2026-05-02', '2026-05-05', 3, 11, 'CD-101','完成', 1494.00, 1, 1, 3, 4, '带父母来成都，宽窄巷子太适合老人了。', '2026-04-28 16:30:00'),
(116, 12, '何明', '13600011011', '2026-05-10', '2026-05-12', 1, 10, 'SZ-302','完成', 736.00, 1, 1, 2, 3, '数码主题房很有特色，电竞桌很爽。', '2026-05-08 11:00:00'),
(117, 7, '吴敏', '13600006006', '2026-05-18', '2026-05-20', 2, 8, 'GZ-503','完成', 1056.00, 1, 1, 2, 4, '亲子房孩子玩得很开心，设施齐全。', '2026-05-15 09:00:00'),
(118, 13, '邓霞', '13600012012', '2026-05-25', '2026-05-27', 1, 13, 'HZ-301','完成', 1916.00, 1, 1, 2, 5, '西湖边的清晨太美了，物超所值。', '2026-05-22 14:00:00'),
-- ===== 6月订单（当月，含进行中/已完成/已预订）=====
(119, 2, '李华', '13600001001', '2026-06-01', '2026-06-03', 1, 4, 'BJ-201','完成', 1376.00, 1, 1, 2, 5, '第二次来北京还选的四合院，满意！', '2026-06-29 10:00:00'),
(120, 14, '韩鹏', '13600013013', '2026-06-05', '2026-06-08', 2, 9, 'SZ-1201','完成',2664.00, 1, 1, 3, 4, '深圳湾日落太美了，强烈推荐。', '2026-06-30 14:00:00'),
(121, 3, '王静', '13600002002', '2026-06-10', '2026-06-13', 1, 15, 'LJ-005','完成', 1074.00, 1, 1, 3, 4, '丽江古城太适合放松了，下次还来。', '2026-07-04 09:00:00'),
(122, 5, '孙丽', '13600004004', '2026-06-12', '2026-06-15', 2, 6, 'SH-801','完成', 3864.00, 1, 1, 3, 5, '第三次住外滩江景房，每次都有新感觉。', '2026-07-04 15:00:00'),
(123, 11, '许燕', '13600010010', '2026-06-15', '2026-06-17', 1, 7, 'SH-102','入住', 1536.00, 1, 0, 2, 4, 'loft结构很有趣，法租界环境优雅。', '2026-06-30 11:00:00'),
(124, 8, '郑强', '13600007007', '2026-06-18', '2026-06-20', 2, 1, '101', '入住', 598.00, 1, 0, 2, 3, '价格实惠，位置方便，好评。', '2026-06-29 10:00:00'),
-- 当前进行中的订单
(125, 9, '黄蓉', '13600008008', '2026-06-28', '2026-07-01', 2, 14, 'XM-001','入住', 4764.00, 1, 0, 3, 0, NULL, '2026-06-25 08:00:00'),
(126, 4, '赵磊', '13600003003', '2026-06-29', '2026-07-02', 4, 2, '102', '入住', 1197.00, 1, 0, 3, 0, NULL, '2026-06-27 14:00:00'),
(127, 15, '唐云', '13600014014', '2026-06-30', '2026-07-02', 1, 13, 'HZ-301','入住', 1916.00, 1, 0, 2, 0, NULL, '2026-06-28 10:00:00'),
-- 未来预订
(128, 6, '周杰', '13600005005', '2026-07-05', '2026-07-08', 2, 6, 'SH-801','预订', 3864.00, 0, 0, 3, 0, NULL, '2026-06-28 16:00:00'),
(129, 10, '林志', '13600009009', '2026-07-10', '2026-07-13', 1, 11, 'CD-101','预订', 1494.00, 1, 0, 3, 0, NULL, '2026-06-29 09:00:00'),
(130, 12, '何明', '13600011011', '2026-07-15', '2026-07-17', 2, 5, 'BJ-305','预订', 916.00, 0, 0, 2, 0, NULL, '2026-06-30 11:00:00'),
-- 由取消转为活跃状态的订单
(131, 7, '吴敏', '13600006006', '2026-07-01', '2026-07-03', 1, 4, 'BJ-201','预订', 688.00, 0, 0, 2, 0, NULL, '2026-06-15 10:00:00'),
(132, 13, '邓霞', '13600012012', '2026-06-29', '2026-07-02', 2, 9, 'SZ-1201','入住', 1776.00, 0, 0, 2, 0, NULL, '2026-06-05 14:00:00');
-- ============================================================
-- 6. 系统日志（补充 20 条，让日志页面有数据）
-- ============================================================
DELETE FROM `sys_log` WHERE `id` BETWEEN 100 AND 999;
INSERT INTO `sys_log` (`id`, `operation`, `method`, `uri`, `ip`, `params`,
`operator_id`, `operator_name`, `use_time`, `create_time`, `status`) VALUES
(100, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.100', '{"username":"admin"}', 1, 'admin', 45.2, '2026-06-01 08:30:00', 0),
(101, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.101', '{"username":"zhangwei"}', 2, 'zhangwei', 38.7, '2026-06-01 09:00:00', 0),
(102, 'select', 'HRoomController.findPage', '/h/room', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 22.1, '2026-06-05 10:15:00', 0),
(103, 'select', 'HOrderController.findPage', '/h/order', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 35.6, '2026-06-05 10:16:00', 0),
(104, 'update', 'HOrderController.checkOrder', '/h/order/check', '192.168.1.100', '{"id":"125"}', 1, 'admin', 56.3, '2026-06-10 14:20:00', 0),
(105, 'select', 'HUserController.findPage', '/h/user', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 18.9, '2026-06-10 14:25:00', 0),
(106, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.102', '{"username":"lina"}', 3, 'lina', 42.0, '2026-06-12 08:45:00', 0),
(107, 'select', 'HOrderController.getMonthData', '/h/order/getMonthData', '192.168.1.102', NULL, 3, 'lina', 120.5, '2026-06-12 09:00:00', 0),
(108, 'insert', 'HRoomController.addRoom', '/h/room', '192.168.1.100', '{"name":"西湖景观民宿"}', 1, 'admin', 28.4, '2026-06-15 11:00:00', 0),
(109, 'update', 'SysUserController.update', '/sys/user', '192.168.1.100', '{"id":"5","real_name":"刘洋"}', 1, 'admin', 33.1, '2026-06-15 11:30:00', 0),
(110, 'select', 'SysRoleController.findRoleList', '/sys/role', '192.168.1.100', NULL, 1, 'admin', 15.2, '2026-06-18 09:00:00', 0),
(111, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.103', '{"username":"wangfang"}', 4, 'wangfang', 40.8, '2026-06-18 08:00:00', 0),
(112, 'delete', 'HOrderController.deleteHOrder', '/h/order/131', '192.168.1.100', '{"id":"131"}', 1, 'admin', 25.7, '2026-06-20 10:00:00', 0),
(113, 'select', 'SysLogController.findPage', '/sys/log', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 19.3, '2026-06-20 10:05:00', 0),
(114, 'update', 'HRoomController.updateRoom', '/h/room', '192.168.1.103', '{"id":"3","price":"599"}', 4, 'wangfang', 31.5, '2026-06-22 15:00:00', 0),
(115, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.104', '{"username":"liuyang"}', 5, 'liuyang', 37.2, '2026-06-25 08:30:00', 0),
(116, 'insert', 'SysUserController.addAdmin', '/sys/user', '192.168.1.100', '{"username":"chenxiao"}', 1, 'admin', 44.6, '2026-06-25 09:00:00', 0),
(117, 'select', 'HOrderController.getWeekData', '/h/order/getWeekData', '192.168.1.102', NULL, 3, 'lina', 98.2, '2026-06-28 10:00:00', 0),
(118, 'update', 'HOrderController.checkOut', '/h/order/checkout', '192.168.1.103', '{"id":"124"}', 4, 'wangfang', 52.1, '2026-06-28 12:00:00', 0),
(119, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.100', '{"username":"admin"}', 1, 'admin', 41.3, '2026-06-30 08:00:00', 0);
-- ============================================================
-- 7. 补充订单（填补零值指标）
-- ============================================================
DELETE FROM h_order WHERE id BETWEEN 133 AND 137;
INSERT INTO h_order (id, user_id, username, phone, start_date, end_date,
amount, room_id, room_code, state, total, pay_state, status, days,
rate, comment, create_time) VALUES
-- 今天入住的预订订单（填"今日预入住"）
(133, 10, '林志', '13600009009', '2026-07-01', '2026-07-03', 1, 10, 'SZ-302',
'预订', 736.00, 1, 0, 2, 0, NULL, '2026-06-29 14:00:00'),
-- 本周完成的订单（填"本周收入"+"7月营收"）
(134, 3, '王静', '13600002002', '2026-06-25', '2026-06-28', 1, 7, 'SH-102',
'完成', 2304.00, 1, 1, 3, 5, '位置绝佳，服务也很到位。', '2026-06-23 10:00:00'),
(135, 5, '孙丽', '13600004004', '2026-06-26', '2026-06-29', 2, 1, '101',
'完成', 1196.00, 1, 1, 3, 4, '老顾客了，每次都很满意。', '2026-06-24 09:00:00'),
-- 今天的入住订单（填"今日预退房"）
(136, 8, '郑强', '13600007007', '2026-06-29', '2026-07-01', 2, 12, 'CD-605',
'入住', 656.00, 1, 0, 2, 0, NULL, '2026-06-27 16:00:00'),
-- 7月初完成（进一步填充7月数据）
(137, 11, '许燕', '13600010010', '2026-06-28', '2026-07-01', 1, 9, 'SZ-1201',
'完成', 2664.00, 1, 1, 3, 5, '深圳湾日落太震撼了！', '2026-06-26 11:00:00');
-- ============================================================
-- 8. 调整房间状态（让饼图更均衡：空闲7/预订4/入住4）
-- ============================================================
UPDATE h_room SET state = '入住' WHERE id IN (1, 4, 7, 9);
UPDATE h_room SET state = '预订' WHERE id IN (3, 5, 11, 14);
-- ============================================================
-- 9. 补充系统日志（30 条，覆盖 6/25 ~ 7/1）
-- ============================================================
DELETE FROM `sys_log` WHERE `id` BETWEEN 120 AND 149;
INSERT INTO `sys_log` (`id`, `operation`, `method`, `uri`, `ip`, `params`,
`operator_id`, `operator_name`, `use_time`, `create_time`, `status`) VALUES
(120, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.100', '{"username":"admin"}', 1, 'admin', 39.5, '2026-06-25 08:10:00', 0),
(121, 'select', 'HRoomController.getRoomPage', '/h/room', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 21.3, '2026-06-25 08:15:00', 0),
(122, 'select', 'HOrderController.getOrderPage', '/h/order', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 33.8, '2026-06-25 08:20:00', 0),
(123, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.102', '{"username":"lina"}', 3, 'lina', 41.2, '2026-06-25 09:00:00', 0),
(124, 'select', 'HOrderController.getMoneyData', '/h/order/getMoneyData', '192.168.1.102', NULL, 3, 'lina', 115.6, '2026-06-25 09:10:00', 0),
(125, 'select', 'HUserController.getAdmin', '/h/user', '192.168.1.102', '{"pageNum":"1","pageSize":"10"}',3, 'lina', 19.4, '2026-06-25 09:20:00', 0),
(126, 'update', 'HOrderController.payHandle', '/h/order/pay', '192.168.1.100', '{"orderId":"129"}', 1, 'admin', 48.7, '2026-06-25 10:30:00', 0),
(127, 'insert', 'HOrderController.addOne', '/h/order', '192.168.1.103', '{"roomId":"10","days":"2"}', 4, 'wangfang', 62.1, '2026-06-25 14:00:00', 0),
(128, 'select', 'HRoomController.getFreeRoom', '/h/room/getFreeRoom', '192.168.1.103', '{"pageNum":"1","pageSize":"10"}',4, 'wangfang', 17.8, '2026-06-25 14:10:00', 0),
(129, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.104', '{"username":"liuyang"}', 5, 'liuyang', 36.9, '2026-06-26 08:00:00', 0),
(130, 'select', 'HOrderController.getTodayData', '/h/order/getTodayData', '192.168.1.104', NULL, 5, 'liuyang', 88.3, '2026-06-26 08:15:00', 0),
(131, 'update', 'HRoomController.statusHandle', '/h/room/status', '192.168.1.104', '{"id":"5","status":"1"}', 5, 'liuyang', 29.5, '2026-06-26 09:30:00', 0),
(132, 'select', 'HRoomController.getDetail', '/h/room/detail', '192.168.1.100', '{"id":"6"}', 1, 'admin', 24.6, '2026-06-26 10:00:00', 0),
(133, 'insert', 'HRoomController.addHRoom', '/h/room', '192.168.1.100', '{"name":"测试房间"}', 1, 'admin', 31.2, '2026-06-26 11:00:00', 0),
(134, 'delete', 'HRoomController.deleteHRoom', '/h/room/3', '192.168.1.100', '{"id":"3"}', 1, 'admin', 22.8, '2026-06-26 11:30:00', 0),
(135, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.100', '{"username":"admin"}', 1, 'admin', 38.1, '2026-06-27 08:00:00', 0),
(136, 'select', 'HOrderController.getCheckPage', '/h/order/check', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 27.4, '2026-06-27 08:30:00', 0),
(137, 'update', 'HOrderController.checkOrder', '/h/order/check', '192.168.1.100', '{"id":"126"}', 1, 'admin', 55.9, '2026-06-27 09:00:00', 0),
(138, 'select', 'SysLogController.findPage', '/sys/log', '192.168.1.100', '{"pageNum":"1","pageSize":"10"}',1, 'admin', 16.7, '2026-06-27 09:30:00', 0),
(139, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.103', '{"username":"wangfang"}', 4, 'wangfang', 40.5, '2026-06-27 13:00:00', 0),
(140, 'select', 'HOrderController.getSubscribePage', '/h/order/subscribe', '192.168.1.103', '{"pageNum":"1","pageSize":"10"}',4, 'wangfang', 23.1, '2026-06-27 13:15:00', 0),
(141, 'update', 'HOrderController.orderPlus', '/h/order/plus', '192.168.1.103', '{"orderId":"125","days":"1"}', 4, 'wangfang', 67.3, '2026-06-27 14:00:00', 0),
(142, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.102', '{"username":"lina"}', 3, 'lina', 37.8, '2026-06-28 08:30:00', 0),
(143, 'select', 'HOrderController.getMonthData', '/h/order/getMonthData', '192.168.1.102', NULL, 3, 'lina', 108.2, '2026-06-28 09:00:00', 0),
(144, 'select', 'HRoomController.roomData', '/h/room/roomData', '192.168.1.102', NULL, 3, 'lina', 14.9, '2026-06-28 09:15:00', 0),
(145, 'update', 'HUserController.statusHandle', '/h/user/status', '192.168.1.100', '{"id":"14","status":"1"}', 1, 'admin', 26.3, '2026-06-28 10:00:00', 0),
(146, 'user login', 'SysUserController.admin', '/sys/user/login', '192.168.1.104', '{"username":"liuyang"}', 5, 'liuyang', 35.6, '2026-06-29 08:00:00', 0),
(147, 'select', 'HOrderController.getCheckOutPage', '/h/order/checkout', '192.168.1.104', '{"pageNum":"1","pageSize":"10"}',5, 'liuyang', 31.2, '2026-06-29 08:20:00', 0),
(148, 'update', 'HOrderController.checkOut', '/h/order/checkout', '192.168.1.104', '{"id":"127"}', 5, 'liuyang', 58.4, '2026-06-29 09:00:00', 0),
(149, 'select', 'HUserController.registerData', '/h/user/registerData', '192.168.1.100', NULL, 1, 'admin', 12.5, '2026-07-01 09:00:00', 0);
-- ============================================================
-- 完成！数据统计：
-- 角色：2 个 系统用户：2 个 前台客户：15 个
-- 房间：15 个 订单：38 条（覆盖 1-7 月，含完成/入住/预订/取消）
-- 日志：50 条
-- ============================================================