接口

12114

接口总览

_resource结构

CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  `appDataSchema` text COMMENT 'appData 参数校验',
  `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 472 DEFAULT CHARSET = utf8mb4 COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
1	✅登陆	login	passwordLogin	service		{ "service": "user", "serviceFunction": "passwordLogin" }
2	✅登出	allPage	logout	service		{ "service": "user", "serviceFunction": "logout" }
3	✅获取用户信息	allPage	userInfo	service		{ "service": "user", "serviceFunction": "userInfo" }
4	✅查询常量	allPage	getConstantList	sql		{"table": "_constant", "operation": "select"}
5	✅获取组织列表	allPage	selectGroupList	sql		{ "table": "enterprise_group", "operation": "select" }
377	✅用户管理页-修改用户状态	userManagement	changeUserStatus	sql		{ "table": "_user", "operation": "update" }
378	✅用户管理页-创建用户	userManagement	insertItem	service	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "service": "userManagement", "serviceFunction": "addUser" }
379	✅用户管理页-修改用户密码	userManagement	resetUserPassword	service	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]}	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
380	✅用户管理页-修改用户信息	userManagement	updateItem	sql	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]}	{ "table": "_user", "operation": "jhUpdate" }
381	✅用户管理页-查询用户列表	userManagement	selectItemList	sql	{"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]}	{ "table": "enterprise_user", "operation": "select" }
382	✅APP管理-查询APP列表	appManagement	selectItemList	sql		{ "table": "enterprise_app", "operation": "select" }
383	✅APP管理-更新	appManagement	updateItem	sql		{ "table": "enterprise_app", "operation": "jhUpdate" }
384	✅APP管理-创建APP	appManagement	insertItem	sql	{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}	{ "table": "enterprise_app", "operation": "jhInsert" }
385	✅APP管理-删除APP	appManagement	deleteItem	sql	{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}	{ "table": "enterprise_app", "operation": "jhDelete" }
397	✅删除	groupAuthorityManagement	deleteItem	service		{ "service": "userGroupRole", "serviceFunction": "deleteGroupRole" }
413	✅APP目录管理-查询APP列表	appDirectoryManagement	selectItemList	sql		{ "table": "enterprise_app", "operation": "select" }
414	✅APP目录管理-更新	appDirectoryManagement	updateItem	sql		{ "table": "enterprise_app", "operation": "jhUpdate" }
415	✅APP目录管理-更新到目录	appDirectoryManagement	updateToDirectoryApp	service		{ "service": "app", "serviceFunction": "updateToDirectoryApp" }
416	✅APP目录管理-更新App _user_group_role	appDirectoryManagement	updateAppUserGroupRole	service		{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }
417	✅APP管理-查询APP列表	appSetting	selectItemList	sql		{ "table": "enterprise_app", "operation": "select" }
418	✅APP管理-更新	appSetting	updateItem	sql	{"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}]}	{ "table": "enterprise_app", "operation": "jhUpdate" }
419	✅APP管理-创建APP	appSetting	insertItem	sql	{"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}], "after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}	{ "table": "enterprise_app", "operation": "jhInsert" }
420	✅APP管理-删除APP	appSetting	deleteItem	sql	{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}	{ "table": "enterprise_app", "operation": "jhDelete" }
421	✅APP目录管理-更新App _user_group_role	appSetting	updateAppUserGroupRole	service		{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }
422	✅查询列表	groupManagement	selectItemList	sql		{ "table": "enterprise_group", "operation": "select" }
423	✅添加	groupManagement	insertItem	sql	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "table": "enterprise_group", "operation": "insert" }
424	✅更新	groupManagement	updateItem	sql	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "table": "enterprise_group", "operation": "jhUpdate" }
425	✅删除	groupManagement	deleteItem	service	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "service": "group", "serviceFunction": "deteleGroup" }
426	✅组织权限列表	groupAuthorityManagement	selectItemList	sql		{ "table": "view01_user_role", "operation": "select" }
427	✅获取App列表	groupAuthorityManagement	selectAppList	sql		{ "table": "enterprise_app", "operation": "select" }
428	✅获取角色列表	groupAuthorityManagement	selectRoleList	sql		{ "table": "enterprise_role", "operation": "select" }
429	✅角色的用户列表	groupAuthorityManagement	getUserGroupRolePage	sql		{ "table": "enterprise_user_group_role_page", "operation": "select" }
430	✅角色的用户列表	groupAuthorityManagement	updateUserGroupRolePage	service		{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRolePage" }
431	✅添加	groupAuthorityManagement	insertRoleItem	sql	{"after": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "table": "enterprise_role", "operation": "insert" }
441	✅组织权限列表	groupUserManagement	selectItemList	sql	{"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]}	{ "table": "view01_user_role", "operation": "select" }
442	✅查询列表	groupUserManagement	selectRoleList	sql		{ "table": "enterprise_role", "operation": "select" }
443	✅添加	groupUserManagement	insertGroupUser	service	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "service": "userGroupRole", "serviceFunction": "insertUserGroupRole" }
444	✅更新	groupUserManagement	updateGroupUser	service	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRole" }
445	✅删除	groupUserManagement	deleteGroupUser	service	{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}	{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }
446	✅角色的用户列表	groupUserManagement	getUserData	sql		{ "table": "_view01_user", "operation": "select" }
447	✅APP管理-查询用户列表	appManagement	getUserList	sql		{ "table": "view01_user_app_role", "operation": "select" }
448	✅APP管理-查询组织列表	appManagement	getGroupList	sql		{ "table": "enterprise_group", "operation": "select" }
449	✅查询App列表	userManagement	getAppList	sql		{ "table": "view01_user_app_role", "operation": "select" }
450	✅查询用户列表	groupManagement	getUserList	sql		{ "table": "enterprise_user", "operation": "select" }
451	✅设置组织负责人	groupManagement	setPrincipal	sql		{ "table": "_group", "operation": "jhUpdate" }
452	✅查询组织列表	userManagement	getGroupList	sql	{"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]}	{ "table": "_group", "operation": "select" }
453	✅查询角色列表	userManagement	getRoleList	sql		{ "table": "_role", "operation": "select" }
454	✅查询待创建的用户列表	userManagement	selectUserToBeCreatedList	service		{ "service": "userManagement", "serviceFunction": "getUserToBeCreatedList" }
455	✅计算待创建的用户列表	userManagement	calculateToBeCreatedUser	service		{ "service": "userManagement", "serviceFunction": "calculateToBeCreatedUser" }
456	✅查询组织列表	groupUserManagement	getGroupList	sql	{"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]}	{ "table": "_group", "operation": "select" }
457	✅异常日志记录	allPage	htmlErrorLogRecord	service		{"service": "error", "serviceFunction": "htmlErrorLogRecord"}
458	✅用户列表【职员】-修改用户密码	staffUserList	batchStaffUserAddApp	service		{ "service": "staff", "serviceFunction": "batchStaffUserAddApp" }
459	✅用户列表【职员】-查询用户列表	staffUserList	selectAppList	sql		{ "table": "enterprise_app", "operation": "select" }
460	✅登陆	bindWx	passwordLogin	service		{ "service": "userManagement", "serviceFunction": "passwordLogin" }
461	✅用户列表【职员】-批量创建用户	staffUserList	batchCreateStaffUser	service		{ "service": "userManagement", "serviceFunction": "batchCreateStaffUser" }
462	✅用户列表【职员】-创建用户	staffUserList	insertItem	service		{ "service": "userManagement", "serviceFunction": "addUser" }
463	✅用户列表【职员】-修改用户信息	staffUserList	updateItem	sql		{ "table": "_user", "operation": "update" }
464	✅用户列表【职员】-查询用户列表	staffUserList	selectItemList	sql		{ "table": "_view01_user", "operation": "select" }
465	✅用户列表【职员】-修改用户密码	staffUserList	resetUserPassword	service		{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
466	✅用户列表【职员】-查询职员列表	staffUserList	selectStaffList	sql		{ "table": "view01_employee", "operation": "select" }

_resource语句

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (2, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (4, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, NULL, NULL, 'allPage', 'selectGroupList', '✅获取组织列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (377, NULL, NULL, 'userManagement', 'changeUserStatus', '✅用户管理页-修改用户状态', 'sql', '{"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["userStatus"],"properties":{"userStatus":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"userId":{"type":"string"}}}},"additionalProperties":true}', '{ "table": "_user", "operation": "update" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (378, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'userManagement', 'insertItem', '✅用户管理页-创建用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "addUser" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (379, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]}', 'userManagement', 'resetUserPassword', '✅用户管理页-修改用户密码', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]}', 'userManagement', 'updateItem', '✅用户管理页-修改用户信息', 'sql', '{"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["username"],"properties":{"username":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"id":{"type":"string"}}}},"additionalProperties":true}', '{ "table": "_user", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]}', 'userManagement', 'selectItemList', '✅用户管理页-查询用户列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_user", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'appManagement', 'selectItemList', '✅APP管理-查询APP列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, '', 'appManagement', 'updateItem', '✅APP管理-更新', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (384, NULL, '{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appManagement', 'insertItem', '✅APP管理-创建APP', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (385, NULL, '{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appManagement', 'deleteItem', '✅APP管理-删除APP', 'sql', '{"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (397, NULL, '', 'groupAuthorityManagement', 'deleteItem', '✅删除', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "deleteGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (413, NULL, NULL, 'appDirectoryManagement', 'selectItemList', '✅APP目录管理-查询APP列表', 'sql', '', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (414, NULL, '', 'appDirectoryManagement', 'updateItem', '✅APP目录管理-更新', 'sql', '', '{ "table": "enterprise_app", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (415, NULL, NULL, 'appDirectoryManagement', 'updateToDirectoryApp', '✅APP目录管理-更新到目录', 'service', '', '{ "service": "app", "serviceFunction": "updateToDirectoryApp" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (416, NULL, NULL, 'appDirectoryManagement', 'updateAppUserGroupRole', '✅APP目录管理-更新App _user_group_role', 'service', NULL, '{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (417, NULL, NULL, 'appSetting', 'selectItemList', '✅APP管理-查询APP列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (418, NULL, '{"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}]}', 'appSetting', 'updateItem', '✅APP管理-更新', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName","appType"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (419, NULL, '{"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}], "after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appSetting', 'insertItem', '✅APP管理-创建APP', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName","appType"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (420, NULL, '{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appSetting', 'deleteItem', '✅APP管理-删除APP', 'sql', '{"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (421, NULL, NULL, 'appSetting', 'updateAppUserGroupRole', '✅APP目录管理-更新App _user_group_role', 'service', NULL, '{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (422, NULL, NULL, 'groupManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "enterprise_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (423, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupManagement', 'insertItem', '✅添加', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["groupId","groupName"],"properties":{"groupId":{"type":"string"},"groupName":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_group", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (424, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "enterprise_group", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (425, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupManagement', 'deleteItem', '✅删除', 'service', '{}', '{ "service": "group", "serviceFunction": "deteleGroup" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (426, NULL, NULL, 'groupAuthorityManagement', 'selectItemList', '✅组织权限列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "view01_user_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (427, NULL, NULL, 'groupAuthorityManagement', 'selectAppList', '✅获取App列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (428, NULL, NULL, 'groupAuthorityManagement', 'selectRoleList', '✅获取角色列表', 'sql', '{}', '{ "table": "enterprise_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (429, NULL, NULL, 'groupAuthorityManagement', 'getUserGroupRolePage', '✅角色的用户列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_user_group_role_page", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (430, NULL, NULL, 'groupAuthorityManagement', 'updateUserGroupRolePage', '✅角色的用户列表', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRolePage" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (431, NULL, '{"after": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupAuthorityManagement', 'insertRoleItem', '✅添加', 'sql', '{}', '{ "table": "enterprise_role", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (441, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]}', 'groupUserManagement', 'selectItemList', '✅组织权限列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "view01_user_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (442, NULL, NULL, 'groupUserManagement', 'selectRoleList', '✅查询列表', 'sql', '{}', '{ "table": "enterprise_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (443, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupUserManagement', 'insertGroupUser', '✅添加', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "insertUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (444, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupUserManagement', 'updateGroupUser', '✅更新', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (445, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupUserManagement', 'deleteGroupUser', '✅删除', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (446, NULL, NULL, 'groupUserManagement', 'getUserData', '✅角色的用户列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "_view01_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (447, NULL, NULL, 'appManagement', 'getUserList', '✅APP管理-查询用户列表', 'sql', '', '{ "table": "view01_user_app_role", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (448, NULL, NULL, 'appManagement', 'getGroupList', '✅APP管理-查询组织列表', 'sql', '', '{ "table": "enterprise_group", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (449, NULL, NULL, 'userManagement', 'getAppList', '✅查询App列表', 'sql', '{}', '{ "table": "view01_user_app_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (450, NULL, NULL, 'groupManagement', 'getUserList', '✅查询用户列表', 'sql', '{}', '{ "table": "enterprise_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (451, NULL, NULL, 'groupManagement', 'setPrincipal', '✅设置组织负责人', 'sql', '{}', '{ "table": "_group", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (452, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]}', 'userManagement', 'getGroupList', '✅查询组织列表', 'sql', '{}', '{ "table": "_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (453, NULL, NULL, 'userManagement', 'getRoleList', '✅查询角色列表', 'sql', '{}', '{ "table": "_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (454, NULL, NULL, 'userManagement', 'selectUserToBeCreatedList', '✅查询待创建的用户列表', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "getUserToBeCreatedList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (455, NULL, NULL, 'userManagement', 'calculateToBeCreatedUser', '✅计算待创建的用户列表', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "calculateToBeCreatedUser" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (456, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]}', 'groupUserManagement', 'getGroupList', '✅查询组织列表', 'sql', '{}', '{ "table": "_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (457, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (458, NULL, NULL, 'staffUserList', 'batchStaffUserAddApp', '✅用户列表【职员】-修改用户密码', 'service', '{}', '{ "service": "staff", "serviceFunction": "batchStaffUserAddApp" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (459, NULL, NULL, 'staffUserList', 'selectAppList', '✅用户列表【职员】-查询用户列表', 'sql', '{}', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (460, NULL, NULL, 'bindWx', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "passwordLogin" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (461, NULL, NULL, 'staffUserList', 'batchCreateStaffUser', '✅用户列表【职员】-批量创建用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "batchCreateStaffUser" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (462, NULL, NULL, 'staffUserList', 'insertItem', '✅用户列表【职员】-创建用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "addUser" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (463, NULL, NULL, 'staffUserList', 'updateItem', '✅用户列表【职员】-修改用户信息', 'sql', '{}', '{ "table": "_user", "operation": "update" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (464, NULL, NULL, 'staffUserList', 'selectItemList', '✅用户列表【职员】-查询用户列表', 'sql', '{}', '{ "table": "_view01_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (465, NULL, NULL, 'staffUserList', 'resetUserPassword', '✅用户列表【职员】-修改用户密码', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (466, NULL, NULL, 'staffUserList', 'selectStaffList', '✅用户列表【职员】-查询职员列表', 'sql', '{}', '{ "table": "view01_employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);

## 接口总览

## _resource结构

```sql
CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  `appDataSchema` text COMMENT 'appData 参数校验',
  `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 472 DEFAULT CHARSET = utf8mb4 COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
```

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | ✅登陆 | login | passwordLogin | service |  | { "service": "user", "serviceFunction": "passwordLogin" } |
| 2 | ✅登出 | allPage | logout | service |  | { "service": "user", "serviceFunction": "logout" } |
| 3 | ✅获取用户信息 | allPage | userInfo | service |  | { "service": "user", "serviceFunction": "userInfo" } |
| 4 | ✅查询常量 | allPage | getConstantList | sql |  | {"table": "_constant", "operation": "select"} |
| 5 | ✅获取组织列表 | allPage | selectGroupList | sql |  | { "table": "enterprise_group", "operation": "select" } |
| 377 | ✅用户管理页-修改用户状态 | userManagement | changeUserStatus | sql |  | { "table": "_user", "operation": "update" } |
| 378 | ✅用户管理页-创建用户 | userManagement | insertItem | service | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "service": "userManagement", "serviceFunction": "addUser" } |
| 379 | ✅用户管理页-修改用户密码 | userManagement | resetUserPassword | service | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]} | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |
| 380 | ✅用户管理页-修改用户信息 | userManagement | updateItem | sql | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]} | { "table": "_user", "operation": "jhUpdate" } |
| 381 | ✅用户管理页-查询用户列表 | userManagement | selectItemList | sql | {"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]} | { "table": "enterprise_user", "operation": "select" } |
| 382 | ✅APP管理-查询APP列表 | appManagement | selectItemList | sql |  | { "table": "enterprise_app", "operation": "select" } |
| 383 | ✅APP管理-更新 | appManagement | updateItem | sql |  | { "table": "enterprise_app", "operation": "jhUpdate" } |
| 384 | ✅APP管理-创建APP | appManagement | insertItem | sql | {"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]} | { "table": "enterprise_app", "operation": "jhInsert" } |
| 385 | ✅APP管理-删除APP | appManagement | deleteItem | sql | {"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]} | { "table": "enterprise_app", "operation": "jhDelete" } |
| 397 | ✅删除 | groupAuthorityManagement | deleteItem | service |  | { "service": "userGroupRole", "serviceFunction": "deleteGroupRole" } |
| 413 | ✅APP目录管理-查询APP列表 | appDirectoryManagement | selectItemList | sql |  | { "table": "enterprise_app", "operation": "select" } |
| 414 | ✅APP目录管理-更新 | appDirectoryManagement | updateItem | sql |  | { "table": "enterprise_app", "operation": "jhUpdate" } |
| 415 | ✅APP目录管理-更新到目录 | appDirectoryManagement | updateToDirectoryApp | service |  | { "service": "app", "serviceFunction": "updateToDirectoryApp" } |
| 416 | ✅APP目录管理-更新App _user_group_role | appDirectoryManagement | updateAppUserGroupRole | service |  | { "service": "app", "serviceFunction": "updateAppUserGroupRole" } |
| 417 | ✅APP管理-查询APP列表 | appSetting | selectItemList | sql |  | { "table": "enterprise_app", "operation": "select" } |
| 418 | ✅APP管理-更新 | appSetting | updateItem | sql | {"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}]} | { "table": "enterprise_app", "operation": "jhUpdate" } |
| 419 | ✅APP管理-创建APP | appSetting | insertItem | sql | {"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}], "after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]} | { "table": "enterprise_app", "operation": "jhInsert" } |
| 420 | ✅APP管理-删除APP | appSetting | deleteItem | sql | {"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]} | { "table": "enterprise_app", "operation": "jhDelete" } |
| 421 | ✅APP目录管理-更新App _user_group_role | appSetting | updateAppUserGroupRole | service |  | { "service": "app", "serviceFunction": "updateAppUserGroupRole" } |
| 422 | ✅查询列表 | groupManagement | selectItemList | sql |  | { "table": "enterprise_group", "operation": "select" } |
| 423 | ✅添加 | groupManagement | insertItem | sql | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "table": "enterprise_group", "operation": "insert" } |
| 424 | ✅更新 | groupManagement | updateItem | sql | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "table": "enterprise_group", "operation": "jhUpdate" } |
| 425 | ✅删除 | groupManagement | deleteItem | service | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "service": "group", "serviceFunction": "deteleGroup" } |
| 426 | ✅组织权限列表 | groupAuthorityManagement | selectItemList | sql |  | { "table": "view01_user_role", "operation": "select" } |
| 427 | ✅获取App列表 | groupAuthorityManagement | selectAppList | sql |  | { "table": "enterprise_app", "operation": "select" } |
| 428 | ✅获取角色列表 | groupAuthorityManagement | selectRoleList | sql |  | { "table": "enterprise_role", "operation": "select" } |
| 429 | ✅角色的用户列表 | groupAuthorityManagement | getUserGroupRolePage | sql |  | { "table": "enterprise_user_group_role_page", "operation": "select" } |
| 430 | ✅角色的用户列表 | groupAuthorityManagement | updateUserGroupRolePage | service |  | { "service": "userGroupRole", "serviceFunction": "updateUserGroupRolePage" } |
| 431 | ✅添加 | groupAuthorityManagement | insertRoleItem | sql | {"after": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "table": "enterprise_role", "operation": "insert" } |
| 441 | ✅组织权限列表 | groupUserManagement | selectItemList | sql | {"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]} | { "table": "view01_user_role", "operation": "select" } |
| 442 | ✅查询列表 | groupUserManagement | selectRoleList | sql |  | { "table": "enterprise_role", "operation": "select" } |
| 443 | ✅添加 | groupUserManagement | insertGroupUser | service | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "service": "userGroupRole", "serviceFunction": "insertUserGroupRole" } |
| 444 | ✅更新 | groupUserManagement | updateGroupUser | service | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "service": "userGroupRole", "serviceFunction": "updateUserGroupRole" } |
| 445 | ✅删除 | groupUserManagement | deleteGroupUser | service | {"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]} | { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } |
| 446 | ✅角色的用户列表 | groupUserManagement | getUserData | sql |  | { "table": "_view01_user", "operation": "select" } |
| 447 | ✅APP管理-查询用户列表 | appManagement | getUserList | sql |  | { "table": "view01_user_app_role", "operation": "select" } |
| 448 | ✅APP管理-查询组织列表 | appManagement | getGroupList | sql |  | { "table": "enterprise_group", "operation": "select" } |
| 449 | ✅查询App列表 | userManagement | getAppList | sql |  | { "table": "view01_user_app_role", "operation": "select" } |
| 450 | ✅查询用户列表 | groupManagement | getUserList | sql |  | { "table": "enterprise_user", "operation": "select" } |
| 451 | ✅设置组织负责人 | groupManagement | setPrincipal | sql |  | { "table": "_group", "operation": "jhUpdate" } |
| 452 | ✅查询组织列表 | userManagement | getGroupList | sql | {"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]} | { "table": "_group", "operation": "select" } |
| 453 | ✅查询角色列表 | userManagement | getRoleList | sql |  | { "table": "_role", "operation": "select" } |
| 454 | ✅查询待创建的用户列表 | userManagement | selectUserToBeCreatedList | service |  | { "service": "userManagement", "serviceFunction": "getUserToBeCreatedList" } |
| 455 | ✅计算待创建的用户列表 | userManagement | calculateToBeCreatedUser | service |  | { "service": "userManagement", "serviceFunction": "calculateToBeCreatedUser" } |
| 456 | ✅查询组织列表 | groupUserManagement | getGroupList | sql | {"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]} | { "table": "_group", "operation": "select" } |
| 457 | ✅异常日志记录 | allPage | htmlErrorLogRecord | service |  | {"service": "error", "serviceFunction": "htmlErrorLogRecord"} |
| 458 | ✅用户列表【职员】-修改用户密码 | staffUserList | batchStaffUserAddApp | service |  | { "service": "staff", "serviceFunction": "batchStaffUserAddApp" } |
| 459 | ✅用户列表【职员】-查询用户列表 | staffUserList | selectAppList | sql |  | { "table": "enterprise_app", "operation": "select" } |
| 460 | ✅登陆 | bindWx | passwordLogin | service |  | { "service": "userManagement", "serviceFunction": "passwordLogin" } |
| 461 | ✅用户列表【职员】-批量创建用户 | staffUserList | batchCreateStaffUser | service |  | { "service": "userManagement", "serviceFunction": "batchCreateStaffUser" } |
| 462 | ✅用户列表【职员】-创建用户 | staffUserList | insertItem | service |  | { "service": "userManagement", "serviceFunction": "addUser" } |
| 463 | ✅用户列表【职员】-修改用户信息 | staffUserList | updateItem | sql |  | { "table": "_user", "operation": "update" } |
| 464 | ✅用户列表【职员】-查询用户列表 | staffUserList | selectItemList | sql |  | { "table": "_view01_user", "operation": "select" } |
| 465 | ✅用户列表【职员】-修改用户密码 | staffUserList | resetUserPassword | service |  | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |
| 466 | ✅用户列表【职员】-查询职员列表 | staffUserList | selectStaffList | sql |  | { "table": "view01_employee", "operation": "select" } |
## _resource语句

```sql
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (2, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (4, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, NULL, NULL, 'allPage', 'selectGroupList', '✅获取组织列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (377, NULL, NULL, 'userManagement', 'changeUserStatus', '✅用户管理页-修改用户状态', 'sql', '{"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["userStatus"],"properties":{"userStatus":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"userId":{"type":"string"}}}},"additionalProperties":true}', '{ "table": "_user", "operation": "update" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (378, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'userManagement', 'insertItem', '✅用户管理页-创建用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "addUser" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (379, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]}', 'userManagement', 'resetUserPassword', '✅用户管理页-修改用户密码', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"}]}', 'userManagement', 'updateItem', '✅用户管理页-修改用户信息', 'sql', '{"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["username"],"properties":{"username":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"id":{"type":"string"}}}},"additionalProperties":true}', '{ "table": "_user", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]}', 'userManagement', 'selectItemList', '✅用户管理页-查询用户列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_user", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'appManagement', 'selectItemList', '✅APP管理-查询APP列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, '', 'appManagement', 'updateItem', '✅APP管理-更新', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (384, NULL, '{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appManagement', 'insertItem', '✅APP管理-创建APP', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (385, NULL, '{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appManagement', 'deleteItem', '✅APP管理-删除APP', 'sql', '{"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (397, NULL, '', 'groupAuthorityManagement', 'deleteItem', '✅删除', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "deleteGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (413, NULL, NULL, 'appDirectoryManagement', 'selectItemList', '✅APP目录管理-查询APP列表', 'sql', '', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (414, NULL, '', 'appDirectoryManagement', 'updateItem', '✅APP目录管理-更新', 'sql', '', '{ "table": "enterprise_app", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (415, NULL, NULL, 'appDirectoryManagement', 'updateToDirectoryApp', '✅APP目录管理-更新到目录', 'service', '', '{ "service": "app", "serviceFunction": "updateToDirectoryApp" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (416, NULL, NULL, 'appDirectoryManagement', 'updateAppUserGroupRole', '✅APP目录管理-更新App _user_group_role', 'service', NULL, '{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (417, NULL, NULL, 'appSetting', 'selectItemList', '✅APP管理-查询APP列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (418, NULL, '{"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}]}', 'appSetting', 'updateItem', '✅APP管理-更新', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName","appType"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (419, NULL, '{"before": [{"service": "app", "serviceFunction": "checkDatabaseExist"}], "after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appSetting', 'insertItem', '✅APP管理-创建APP', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName","appType"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (420, NULL, '{"after": [{"service": "app", "serviceFunction": "buildSupperAdminUserApp"}]}', 'appSetting', 'deleteItem', '✅APP管理-删除APP', 'sql', '{"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (421, NULL, NULL, 'appSetting', 'updateAppUserGroupRole', '✅APP目录管理-更新App _user_group_role', 'service', NULL, '{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (422, NULL, NULL, 'groupManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "enterprise_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (423, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupManagement', 'insertItem', '✅添加', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["groupId","groupName"],"properties":{"groupId":{"type":"string"},"groupName":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{ "table": "enterprise_group", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (424, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "enterprise_group", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (425, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupManagement', 'deleteItem', '✅删除', 'service', '{}', '{ "service": "group", "serviceFunction": "deteleGroup" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (426, NULL, NULL, 'groupAuthorityManagement', 'selectItemList', '✅组织权限列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "view01_user_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (427, NULL, NULL, 'groupAuthorityManagement', 'selectAppList', '✅获取App列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (428, NULL, NULL, 'groupAuthorityManagement', 'selectRoleList', '✅获取角色列表', 'sql', '{}', '{ "table": "enterprise_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (429, NULL, NULL, 'groupAuthorityManagement', 'getUserGroupRolePage', '✅角色的用户列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "enterprise_user_group_role_page", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (430, NULL, NULL, 'groupAuthorityManagement', 'updateUserGroupRolePage', '✅角色的用户列表', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRolePage" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (431, NULL, '{"after": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupAuthorityManagement', 'insertRoleItem', '✅添加', 'sql', '{}', '{ "table": "enterprise_role", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (441, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterUserData"}]}', 'groupUserManagement', 'selectItemList', '✅组织权限列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "view01_user_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (442, NULL, NULL, 'groupUserManagement', 'selectRoleList', '✅查询列表', 'sql', '{}', '{ "table": "enterprise_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (443, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupUserManagement', 'insertGroupUser', '✅添加', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "insertUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (444, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupUserManagement', 'updateGroupUser', '✅更新', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (445, NULL, '{"before": [{"service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon"}]}', 'groupUserManagement', 'deleteGroupUser', '✅删除', 'service', '{}', '{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (446, NULL, NULL, 'groupUserManagement', 'getUserData', '✅角色的用户列表', 'sql', '{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "_view01_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (447, NULL, NULL, 'appManagement', 'getUserList', '✅APP管理-查询用户列表', 'sql', '', '{ "table": "view01_user_app_role", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (448, NULL, NULL, 'appManagement', 'getGroupList', '✅APP管理-查询组织列表', 'sql', '', '{ "table": "enterprise_group", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (449, NULL, NULL, 'userManagement', 'getAppList', '✅查询App列表', 'sql', '{}', '{ "table": "view01_user_app_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (450, NULL, NULL, 'groupManagement', 'getUserList', '✅查询用户列表', 'sql', '{}', '{ "table": "enterprise_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (451, NULL, NULL, 'groupManagement', 'setPrincipal', '✅设置组织负责人', 'sql', '{}', '{ "table": "_group", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (452, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]}', 'userManagement', 'getGroupList', '✅查询组织列表', 'sql', '{}', '{ "table": "_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (453, NULL, NULL, 'userManagement', 'getRoleList', '✅查询角色列表', 'sql', '{}', '{ "table": "_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (454, NULL, NULL, 'userManagement', 'selectUserToBeCreatedList', '✅查询待创建的用户列表', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "getUserToBeCreatedList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (455, NULL, NULL, 'userManagement', 'calculateToBeCreatedUser', '✅计算待创建的用户列表', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "calculateToBeCreatedUser" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (456, NULL, '{"after": [{"service": "userManagement", "serviceFunction": "filterGroupByAuth"}]}', 'groupUserManagement', 'getGroupList', '✅查询组织列表', 'sql', '{}', '{ "table": "_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (457, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (458, NULL, NULL, 'staffUserList', 'batchStaffUserAddApp', '✅用户列表【职员】-修改用户密码', 'service', '{}', '{ "service": "staff", "serviceFunction": "batchStaffUserAddApp" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (459, NULL, NULL, 'staffUserList', 'selectAppList', '✅用户列表【职员】-查询用户列表', 'sql', '{}', '{ "table": "enterprise_app", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (460, NULL, NULL, 'bindWx', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "passwordLogin" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (461, NULL, NULL, 'staffUserList', 'batchCreateStaffUser', '✅用户列表【职员】-批量创建用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "batchCreateStaffUser" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (462, NULL, NULL, 'staffUserList', 'insertItem', '✅用户列表【职员】-创建用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "addUser" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (463, NULL, NULL, 'staffUserList', 'updateItem', '✅用户列表【职员】-修改用户信息', 'sql', '{}', '{ "table": "_user", "operation": "update" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (464, NULL, NULL, 'staffUserList', 'selectItemList', '✅用户列表【职员】-查询用户列表', 'sql', '{}', '{ "table": "_view01_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (465, NULL, NULL, 'staffUserList', 'resetUserPassword', '✅用户列表【职员】-修改用户密码', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (466, NULL, NULL, 'staffUserList', 'selectStaffList', '✅用户列表【职员】-查询职员列表', 'sql', '{}', '{ "table": "view01_employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```