江湖数字化平台
登录

接口

12114

接口总览

_resource结构

  1. CREATE TABLE `_resource` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `accessControlTable` varchar(255)  DEFAULT NULL COMMENT '数据规则控制表',
  4.   `resourceHook` text  COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  5.   `pageId` varchar(255)  DEFAULT NULL COMMENT 'page id; E.g: index',
  6.   `actionId` varchar(255)  DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  7.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  8.   `resourceType` varchar(255)  DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  9.   `appDataSchema` text  COMMENT 'appData 参数校验',
  10.   `resourceData` text  COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  11.   `requestDemo` text  COMMENT '请求Demo',
  12.   `responseDemo` text  COMMENT '响应Demo',
  13.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  14.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  15.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  16.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  17.   PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE = InnoDB AUTO_INCREMENT = 418 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin 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 ✅刷新authToken allPage refreshToken service {"service": "user", "serviceFunction": "refreshToken"}
4 ✅获取用户信息 allPage userInfo service {"service": "user", "serviceFunction": "userInfo"}
5 ✅重置密码 resetUserPassword resetPassword service {"service": "user", "serviceFunction": "resetPassword"}
6 ✅ 文件分片上传-http文件流 allPage httpUploadByStream service {"service": "file", "serviceFunction": "uploadFileChunkByStream"}
7 ✅ 文件分片上传-所有分片上传完毕 allPage uploadFileDone service {"service": "file", "serviceFunction": "uploadFileDone"}
101 ✅查询-用户列表 workflowManagement selectUserList sql {"table": "_view01_user", "operation": "select"}
102 ✅查询-组列表 workflowManagement selectGroupList sql {"table": "_group", "operation": "select"}
103 ✅workflowManagement查询-查询列表 workflowManagement selectItemList sql {"table": "workflow", "operation": "select"}
104 ✅workflowManagement查询-添加成员 workflowManagement insertItem sql {"before":[{"service":"workflow","serviceFunction":"createWorkflowId"}]} {"table": "workflow", "operation": "jhInsert"}
105 ✅workflowManagement查询-更新成员 workflowManagement updateItem sql {"table": "workflow", "operation": "jhUpdate"}
201 ✅添加 createTask insertTask service { "service": "workflow", "serviceFunction": "createWorkflowTask" }
202 ✅查询-查询列表 createTask selectItemList sql {"before":[{"service":"task","serviceFunction":"appendTaskInitUserBeforeHook"}]} {"table": "task", "operation": "select"}
203 ✅查询-用户列表 createTask selectUserList sql {"table": "_view01_user", "operation": "select"}
204 ✅查询-流程列表 createTask createTaskDrawer-selectWorkflowList sql {"table": "workflow", "operation": "select"}
301 ✅查询列表 todo selectItemList sql { "table": "task", "operation": "select" }
302 ✅更新 todo submitNode service { "service": "task", "serviceFunction": "submitNode" }
303 ✅已处理 todo selectHistoryList sql { "table": "task_history", "operation": "select" }
304 ✅添加 todo getTaskHistory service { "service": "workflow", "serviceFunction": "getTaskHistory" }
305 ✅转交 todo transferNode service { "service": "task", "serviceFunction": "transferNode" }
306 ✅沟通 todo addCommentNode service { "service": "task", "serviceFunction": "addCommentNode" }
401 ✅作业-创建作业 taskHistory selectItemList sql {"after":[{"service":"workflow","serviceFunction":"appendUsername"}]} { "table": "task", "operation": "select" }
402 ✅权限管理页-查询已配置权限列表 userGroupRole selectItemList sql {"table": "_user_group_role", "operation": "select"}
403 ✅权限管理页-查询用户 userGroupRole selectUser sql {"table": "_view02_user_app", "operation": "select"}
404 ✅权限管理页-查询群组 userGroupRole selectGroup sql {"table": "_group", "operation": "select"}
405 ✅权限管理页-创建权限配置 userGroupRole insertItem sql {"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""}
406 ✅权限管理页-更新权限配置 userGroupRole updateItem sql {"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}
407 ✅权限管理页-删除权限配置 userGroupRole deleteItem sql {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}
408 ✅权限管理页-查询角色 userGroupRole selectRole sql {"table": "_role", "operation": "select"}
409 ✅权限管理页-添加用户 userGroupRole insertUser service {"service": "userManagement", "serviceFunction": "addUser"}
410 ✅权限管理页-添加群组 userGroupRole insertGroup sql {"table": "_group", "operation": "jhInsert"}
411 ✅权限管理页-添加角色 userGroupRole insertRole sql {"table": "_role", "operation": "jhInsert"}
412 ✅权限管理页-删除用户 userGroupRole deleteUser sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_user", "operation": "jhDelete"}
413 ✅权限管理页-删除群组 userGroupRole deleteGroup sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_group", "operation": "jhDelete"}
414 ✅权限管理页-删除角色 userGroupRole deleteRole sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_role", "operation": "jhDelete"}
416 ✅权限管理页-更新群组 userGroupRole updateGroup sql {"table": "_group", "operation": "jhUpdate"}
417 ✅权限管理页-更新角色 userGroupRole updateRole sql {"table": "_role", "operation": "jhUpdate"}

_resource语句

  1. 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', NULL, '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-06-30T09:59:55+08:00');
  2. 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', NULL, '{"service": "user", "serviceFunction": "logout"}', '', '', 'update', NULL, NULL, '2022-04-25T14:39:56+08:00');
  3. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, NULL, NULL, 'allPage', 'refreshToken', '✅刷新authToken', 'service', NULL, '{"service": "user", "serviceFunction": "refreshToken"}', '', '', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (4, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', NULL, '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-07-05T16:14:31+08:00');
  5. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, NULL, NULL, 'resetUserPassword', 'resetPassword', '✅重置密码', 'service', NULL, '{"service": "user", "serviceFunction": "resetPassword"}', '', '', 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  6. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
  7. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
  8. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (101, NULL, '', 'workflowManagement', 'selectUserList', '✅查询-用户列表', 'sql', NULL, '{"table": "_view01_user", "operation": "select"}', '', '', 'update', 'vscode', 'vscode', '2022-07-04T22:27:58+08:00');
  9. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (102, NULL, '', 'workflowManagement', 'selectGroupList', '✅查询-组列表', 'sql', NULL, '{"table": "_group", "operation": "select"}', '', '', 'update', 'vscode', 'vscode', '2022-07-04T22:27:58+08:00');
  10. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (103, NULL, NULL, 'workflowManagement', 'selectItemList', '✅workflowManagement查询-查询列表', 'sql', '{}', '{"table": "workflow", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  11. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (104, NULL, '{"before":[{"service":"workflow","serviceFunction":"createWorkflowId"}]}', 'workflowManagement', 'insertItem', '✅workflowManagement查询-添加成员', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["workflowName","workflowId","workflowConfig","workflowForm"],"properties":{"workflowName":{"type":"string"},"workflowConfig":{"type":"string"},"workflowForm":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{"table": "workflow", "operation": "jhInsert"}', '', '', 'insert', NULL, NULL, NULL);
  12. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (105, NULL, NULL, 'workflowManagement', 'updateItem', '✅workflowManagement查询-更新成员', 'sql', '{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["workflowName","workflowId","workflowConfig","workflowForm"],"properties":{"workflowName":{"type":"string"},"workflowId":{"type":"string"},"workflowConfig":{"type":"string"},"workflowForm":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}', '{"table": "workflow", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
  13. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (201, NULL, NULL, 'createTask', 'insertTask', '✅添加', 'service', '{}', '{ "service": "workflow", "serviceFunction": "createWorkflowTask" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  14. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (202, NULL, '{"before":[{"service":"task","serviceFunction":"appendTaskInitUserBeforeHook"}]}', 'createTask', 'selectItemList', '✅查询-查询列表', 'sql', '{}', '{"table": "task", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  15. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (203, NULL, '', 'createTask', 'selectUserList', '✅查询-用户列表', 'sql', NULL, '{"table": "_view01_user", "operation": "select"}', '', '', 'update', 'vscode', 'vscode', '2022-07-04T22:27:58+08:00');
  16. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (204, NULL, NULL, 'createTask', 'createTaskDrawer-selectWorkflowList', '✅查询-流程列表', 'sql', '{}', '{"table": "workflow", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  17. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (301, NULL, NULL, 'todo', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  18. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (302, NULL, NULL, 'todo', 'submitNode', '✅更新', 'service', '{}', '{ "service": "task", "serviceFunction": "submitNode" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  19. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (303, NULL, NULL, 'todo', 'selectHistoryList', '✅已处理', 'sql', '{"type":"object","required":["where","whereLike","orderBy"],"properties":{"where":{"type":"object","required":["taskStatus"],"properties":{"taskStatus":{"type":"string"}}},"whereLike":{"type":"object","required":["taskEditUserList"],"properties":{"taskEditUserList":{"type":"string"},"taskConfigId":{"type":"string"}}},"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}', '{ "table": "task_history", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  20. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (304, NULL, NULL, 'todo', 'getTaskHistory', '✅添加', 'service', '{}', '{ "service": "workflow", "serviceFunction": "getTaskHistory" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  21. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (305, NULL, NULL, 'todo', 'transferNode', '✅转交', 'service', '{}', '{ "service": "task", "serviceFunction": "transferNode" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  22. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (306, NULL, NULL, 'todo', 'addCommentNode', '✅沟通', 'service', '{}', '{ "service": "task", "serviceFunction": "addCommentNode" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  23. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (401, NULL, '{"after":[{"service":"workflow","serviceFunction":"appendUsername"}]}', 'taskHistory', '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": "task", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  24. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (402, NULL, NULL, 'userGroupRole', 'selectItemList', '✅权限管理页-查询已配置权限列表', 'sql', NULL, '{"table": "_user_group_role", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "where": {"userId": "001"}, "pageId": "userGroupRole", "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476230231_7262893", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectItemList", "resultData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476230231_7262893", "timestamp": "2022-05-02T15:23:50+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:23:51+08:00');
  25. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (403, NULL, NULL, 'userGroupRole', 'selectUser', '✅权限管理页-查询用户', 'sql', NULL, '{"table": "_view02_user_app", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476237658_7645348", "packageType": "httpRequest"}', '{"status": "success", "packageId": "1651476237658_7645348", "timestamp": "2022-05-02T15:23:58+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:23:58+08:00');
  26. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (404, NULL, NULL, 'userGroupRole', 'selectGroup', '✅权限管理页-查询群组', 'sql', NULL, '{"table": "_group", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_6618462", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "管理组", "groupName": "管理组", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "resultData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "管理组", "groupName": "管理组", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476088200_6618462", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:21:29+08:00');
  27. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (405, NULL, NULL, 'userGroupRole', 'insertItem', '✅权限管理页-创建权限配置', 'sql', NULL, '{"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"roleId": "teacher", "userId": "admin2", "groupId": "adminGroup"}}, "packageId": "1651149371608_1485871", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [599], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "resultData": {"rows": [599]}}, "packageId": "1651149371608_1485871", "timestamp": "2022-04-28T20:36:12+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T20:36:12+08:00');
  28. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (406, NULL, NULL, 'userGroupRole', 'updateItem', '✅权限管理页-更新权限配置', 'sql', NULL, '{"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T12:09:29+08:00');
  29. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (407, NULL, NULL, 'userGroupRole', 'deleteItem', '✅权限管理页-删除权限配置', 'sql', NULL, '{"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T21:03:41+08:00');
  30. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (408, NULL, NULL, 'userGroupRole', 'selectRole', '✅权限管理页-查询角色', 'sql', NULL, '{"table": "_role", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_7966907", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "系统管理员", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "老师", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "学生", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "resultData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "系统管理员", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "老师", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "学生", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}]}}, "packageId": "1651476088200_7966907", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:21:29+08:00');
  31. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (409, NULL, NULL, 'userGroupRole', 'insertUser', '✅权限管理页-添加用户', 'service', NULL, '{"service": "userManagement", "serviceFunction": "addUser"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "admin2", "username": "admin2", "clearTextPassword": "123456"}}, "packageId": "1651149323428_7722305", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "resultData": {}}, "packageId": "1651149323428_7722305", "timestamp": "2022-04-28T20:35:24+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T20:35:24+08:00');
  32. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (410, NULL, NULL, 'userGroupRole', 'insertGroup', '✅权限管理页-添加群组', 'sql', NULL, '{"table": "_group", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:55:57+08:00');
  33. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (411, NULL, NULL, 'userGroupRole', 'insertRole', '✅权限管理页-添加角色', 'sql', NULL, '{"table": "_role", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:00:37+08:00');
  34. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (412, NULL, '{ "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] }', 'userGroupRole', 'deleteUser', '✅权限管理页-删除用户', 'sql', NULL, '{"table": "_user", "operation": "jhDelete"}', '{"appData": {"appId": "demo_advanced", "where": {"userId": "admin2"}, "pageId": "userGroupRole", "actionId": "deleteUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651149383707_8632195", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "deleteUser", "resultData": {"rows": 1}}, "packageId": "1651149383707_8632195", "timestamp": "2022-04-28T20:36:24+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T20:36:24+08:00');
  35. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (413, NULL, '{ "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] }', 'userGroupRole', 'deleteGroup', '✅权限管理页-删除群组', 'sql', NULL, '{"table": "_group", "operation": "jhDelete"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:56:11+08:00');
  36. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (414, NULL, '{ "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] }', 'userGroupRole', 'deleteRole', '✅权限管理页-删除角色', 'sql', NULL, '{"table": "_role", "operation": "jhDelete"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:04:23+08:00');
  37. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (416, NULL, NULL, 'userGroupRole', 'updateGroup', '✅权限管理页-更新群组', 'sql', NULL, '{"table": "_group", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:45:26+08:00');
  38. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (417, NULL, NULL, 'userGroupRole', 'updateRole', '✅权限管理页-更新角色', 'sql', NULL, '{"table": "_role", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:56:37+08:00');