18 lines
951 B
SQL
18 lines
951 B
SQL
-- 自动分配日志菜单（挂在「数据统计」目录下，紧邻复诊接诊率）
|
|
-- 页面路径: /stats/auto_assign_log
|
|
-- 前端组件: /stats/auto_assign_log/index
|
|
-- 查询权限: stats.autoAssignLog/lists
|
|
-- 数据来源: zyt_tcm_diagnosis_auto_assign_log（定时命令 tcm:auto-assign-pending 写入）
|
|
|
|
SET @stats_root_id = (SELECT id FROM zyt_system_menu WHERE name = '数据统计' AND type = 'M' LIMIT 1);
|
|
|
|
INSERT INTO `zyt_system_menu`
|
|
(`pid`, `type`, `name`, `icon`, `sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_show`, `is_disable`, `create_time`, `update_time`)
|
|
SELECT
|
|
@stats_root_id, 'C', '自动分配日志', '', 12,
|
|
'stats.autoAssignLog/lists', '/stats/auto_assign_log', '/stats/auto_assign_log/index',
|
|
'', '', 1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
FROM DUAL
|
|
WHERE @stats_root_id IS NOT NULL
|
|
AND NOT EXISTS (SELECT 1 FROM zyt_system_menu WHERE perms = 'stats.autoAssignLog/lists');
|