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
| -- 注意：该页面对应的前台目录为views/dry文件夹下
| -- 如果你想更改到其他目录，请修改sql中component字段对应的值
|
|
| INSERT INTO sys_permission(id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, hide_tab, description, status, del_flag, rule_flag, create_by, create_time, update_by, update_time, internal_or_external)
| VALUES ('202507230857430230', NULL, '出入库记录表', '/dry/drySpareStockLogList', 'dry/spareParts/DrySpareStockLogList', NULL, NULL, 0, NULL, '1', 0.00, 0, NULL, 1, 0, 0, 0, 0, NULL, '1', 0, 0, 'admin', '2025-07-23 08:57:23', NULL, NULL, 0);
|
| -- 权限控制sql
| -- 新增
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('202507230857430231', '202507230857430230', '添加出入库记录表', NULL, NULL, 0, NULL, NULL, 2, 'dry:dry_spare_stock_log:add', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2025-07-23 08:57:23', NULL, NULL, 0, 0, '1', 0);
| -- 编辑
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('202507230857430232', '202507230857430230', '编辑出入库记录表', NULL, NULL, 0, NULL, NULL, 2, 'dry:dry_spare_stock_log:edit', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2025-07-23 08:57:23', NULL, NULL, 0, 0, '1', 0);
| -- 删除
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('202507230857430233', '202507230857430230', '删除出入库记录表', NULL, NULL, 0, NULL, NULL, 2, 'dry:dry_spare_stock_log:delete', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2025-07-23 08:57:23', NULL, NULL, 0, 0, '1', 0);
| -- 批量删除
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('202507230857430234', '202507230857430230', '批量删除出入库记录表', NULL, NULL, 0, NULL, NULL, 2, 'dry:dry_spare_stock_log:deleteBatch', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2025-07-23 08:57:23', NULL, NULL, 0, 0, '1', 0);
| -- 导出excel
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('202507230857430235', '202507230857430230', '导出excel_出入库记录表', NULL, NULL, 0, NULL, NULL, 2, 'dry:dry_spare_stock_log:exportXls', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2025-07-23 08:57:23', NULL, NULL, 0, 0, '1', 0);
| -- 导入excel
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('202507230857430236', '202507230857430230', '导入excel_出入库记录表', NULL, NULL, 0, NULL, NULL, 2, 'dry:dry_spare_stock_log:importExcel', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2025-07-23 08:57:23', NULL, NULL, 0, 0, '1', 0);
|
|
