0.17版本没有“测试管理”了吗？

mxjstone · 2019 年6 月 6 日 10:32

我看下菜单配置那边，是显示 ”菜单无对应权限“

Song · 2019 年6 月 6 日 14:51

你好，测试的菜单是有配置权限的，你这边查询一下数据库看下权限是否初始化进去了。
SELECT * FROM iam_menu_permission WHERE PERMISSION_CODE = 'test-manager-service.test-cycle.getTestCycle';

mxjstone · 2019 年6 月 6 日 15:05

你好：

superlee · 2019 年6 月 10 日 02:02

SELECT
	imb.id,
	imb.CODE,
CASE
		
		WHEN imt.NAME IS NULL THEN
		imb.NAME ELSE imt.NAME 
	END AS NAME,
	imb.resource_level,
	imb.parent_code,
	imb.type,
	imb.sort,
	imb.is_default,
	imb.icon,
	imb.category,
	imb.page_permission_code,
	imb.object_version_number,
	ip2.path AS route,
	ip2.permission_type AS page_permission_type 
FROM
	iam_menu_b imb
	INNER JOIN iam_menu_permission imp ON imb.CODE = imp.menu_code
	INNER JOIN (
	SELECT DISTINCT
		t2.CODE 
	FROM
		(
		SELECT
			ip.* 
		FROM
			iam_permission ip
			INNER JOIN iam_role_permission irp ON ip.id = irp.permission_id
			INNER JOIN (
			SELECT DISTINCT
				imr.role_id 
			FROM
				iam_member_role imr
				INNER JOIN iam_role ir ON imr.role_id = ir.id 
				AND ir.is_enabled = 1 
			WHERE
				imr.member_id = ? 
				AND imr.source_type = 'project' 
				AND imr.source_id = ? 
				AND imr.member_type = 'user'
			) t1 ON t1.role_id = irp.role_id UNION
		SELECT
			ip1.* 
		FROM
			iam_permission ip1 
		WHERE
			ip1.is_login_access = 1 
			OR ip1.is_public_access = 1 
		) t2 
	) t3 ON imp.permission_code = t3.
	CODE LEFT JOIN iam_menu_tl imt ON imb.id = imt.id 
	AND imt.lang = 'zh_CN'
	LEFT JOIN iam_permission ip2 ON imb.page_permission_code = ip2.CODE 
WHERE
	1 = 1 
	AND imb.resource_level = 'project' 
	AND ( imb.category NOT LIKE 'PROGRAM' OR imb.category IS NULL )

查一下菜单，member_id为项目所有者用户的id，source_id为项目id