16 lines
647 B
SQL
Executable File
16 lines
647 B
SQL
Executable File
-- 业绩看板「未归属中心」按创建人拆解接口（fans/yeji · pid=293）
|
||
-- 幂等：按 perms 判重
|
||
|
||
INSERT INTO `zyt_system_menu`
|
||
(`pid`, `type`, `name`, `icon`, `sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_show`, `is_disable`, `create_time`, `update_time`)
|
||
SELECT
|
||
293, 'A', '业绩-未归属拆解', '', 9,
|
||
'stats.yejiStats/unassignedBreakdown', '', '', '', '',
|
||
1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
||
FROM DUAL
|
||
WHERE EXISTS (SELECT 1 FROM `zyt_system_menu` p WHERE p.id = 293)
|
||
AND NOT EXISTS (
|
||
SELECT 1 FROM `zyt_system_menu` m
|
||
WHERE m.perms = 'stats.yejiStats/unassignedBreakdown'
|
||
);
|