江湖数字化平台
登录

接口

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 = 47 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 ✅获取用户信息 allPage userInfo service {"service": "user", "serviceFunction": "userInfo"}
4 ✅查询常量 allPage getConstantList sql {"table": "_constant", "operation": "select"}
5 ✅查看和填写评语查询-查询列表 studentList selectItemList sql { "table": "view01_student_new_structure", "operation": "select" }
6 ✅查询-查询列表 studentCommentList selectItemList sql { "table": "comment_for_student", "operation": "select" }
7 ✅评语管理-添加成员 studentCommentList insertItem sql { "table": "comment_for_student", "operation": "insert" }
8 ✅评语管理-更新成员 studentCommentList updateItem sql { "table": "comment_for_student", "operation": "jhUpdate" }
9 ✅评语管理-删除信息 studentCommentList deleteItem sql { "table": "comment_for_student", "operation": "jhDelete" }
10 ✅学生管理-基础信息查询-查询列表 studentNewStructureList selectItemList sql { "table": "view01_student_new_structure", "operation": "select" }
11 ✅学生管理-联系方式查询-查询列表 studentContactList selectItemList sql { "table": "view01_student_contact", "operation": "select" }
12 ✅学生管理-教育背景查询-查询列表 studentEducationBackgroundList selectItemList sql { "table": "view01_student_education_background", "operation": "select" }
13 ✅学生管理-助学金查询-查询列表 studentFinancialAidList selectItemList sql { "table": "view01_student_financial_aid", "operation": "select" }
14 ✅学生管理-监护人查询-查询列表 studentGuardianList selectItemList sql { "table": "view01_student_guardian", "operation": "select" }
15 ✅学生管理-籍贯查询-查询列表 studentHometownList selectItemList sql { "table": "view01_student_hometown", "operation": "select" }
16 ✅学生管理-宿舍查询-查询列表 studentLogisticsList selectItemList sql { "table": "view01_student_logistics", "operation": "select" }
17 ✅异常日志记录 allPage htmlErrorLogRecord service {"service": "error", "serviceFunction": "htmlErrorLogRecord"}
18 ✅查询列表 appraisalManagement selectItemList sql { "table": "view02_appraisal", "operation": "select"}
19 ✅添加 appraisalManagement insertItem service {"service": "appraisal", "serviceFunction": "createAppraisal"}
20 ✅更新 appraisalManagement updateItem sql { "table": "appraisal", "operation": "jhUpdate" }
21 ✅删除 appraisalManagement deleteItem sql { "table": "appraisal", "operation": "jhDelete" }
22 ✅班级列表 appraisalManagement selectClassList sql { "table": "view01_class", "operation": "select", "where": { "formTeacherId": "ctx.userInfo.userId" } }
23 ✅评语的学生评语管理-查询当前学生评语下的评语列表 appraisalStudentManagementOfOneAppraisal selectCurrentList sql { "table": "view02_appraisal_student", "operation": "select" }
24 ✅评语的学生评语管理-建立关系 appraisalStudentManagementOfOneAppraisal insertItem sql { "table": "appraisal_student", "operation": "jhInsert" }
25 ✅评语的学生评语管理-更新数据 appraisalStudentManagementOfOneAppraisal updateItem sql { "table": "appraisal_student", "operation": "jhUpdate" }
26 ✅评语的学生评语管理-删除信息 appraisalStudentManagementOfOneAppraisal deleteItem sql { "table": "appraisal_student", "operation": "jhDelete" }
27 ✅评语查询-查询列表 appraisalStudentManagementOfOneAppraisal selectAllList sql { "table": "appraisal_student", "operation": "select" }
28 ✅发送通知 appraisalManagement sendNotice service {"service": "appraisal", "serviceFunction": "sendNotice"}
29 ✅发送通知 appraisalManagement selectAppraisalStudentList sql { "table": "view02_appraisal_student", "operation": "select" }
30 ✅权限管理页-查询已配置权限列表 userGroupRole selectItemList sql {"table": "_user_group_role", "operation": "select"}
31 ✅权限管理页-查询用户 userGroupRole selectUser sql {"table": "_view02_user_app", "operation": "select"}
32 ✅权限管理页-查询群组 userGroupRole selectGroup sql {"table": "_group", "operation": "select"}
33 ✅权限管理页-创建权限配置 userGroupRole insertItem sql {"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""}
34 ✅权限管理页-更新权限配置 userGroupRole updateItem sql {"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}
35 ✅权限管理页-删除权限配置 userGroupRole deleteItem sql {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}
36 ✅权限管理页-查询角色 userGroupRole selectRole sql {"table": "_role", "operation": "select"}
37 ✅权限管理页-添加群组 userGroupRole insertGroup sql {"table": "_group", "operation": "jhInsert"}
38 ✅权限管理页-添加角色 userGroupRole insertRole sql {"table": "_role", "operation": "jhInsert"}
39 ✅权限管理页-删除群组 userGroupRole deleteGroup sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_group", "operation": "jhDelete"}
40 ✅权限管理页-删除角色 userGroupRole deleteRole sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_role", "operation": "jhDelete"}
41 ✅权限管理页-更新群组 userGroupRole updateGroup sql {"table": "_group", "operation": "jhUpdate"}
42 ✅权限管理页-更新角色 userGroupRole updateRole sql {"table": "_role", "operation": "jhUpdate"}
43 ✅查询列表 appraisalSetting selectItemList sql { "table": "_constant", "operation": "select" }
44 ✅添加 appraisalSetting insertItem sql { "table": "_constant", "operation": "insert" }
45 ✅更新 appraisalSetting updateItem sql { "table": "_constant", "operation": "jhUpdate" }
46 ✅删除 appraisalSetting deleteItem sql { "table": "_constant", "operation": "jhDelete" }

_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', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', NULL, NULL, 'update', NULL, NULL, '2022-04-27T15:32:57+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', '{}', '{"service": "user", "serviceFunction": "logout"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  3. 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"}', NULL, NULL, 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
  4. 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);
  5. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, NULL, NULL, 'studentList', 'selectItemList', '✅查看和填写评语查询-查询列表', 'sql', '{}', '{ "table": "view01_student_new_structure", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  6. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, NULL, NULL, 'studentCommentList', 'selectItemList', '✅查询-查询列表', 'sql', '{}', '{ "table": "comment_for_student", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  7. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, NULL, NULL, 'studentCommentList', 'insertItem', '✅评语管理-添加成员', 'sql', '{}', '{ "table": "comment_for_student", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  8. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (8, NULL, NULL, 'studentCommentList', 'updateItem', '✅评语管理-更新成员', 'sql', '{}', '{ "table": "comment_for_student", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  9. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (9, NULL, NULL, 'studentCommentList', 'deleteItem', '✅评语管理-删除信息', 'sql', '{}', '{ "table": "comment_for_student", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  10. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (10, NULL, NULL, 'studentNewStructureList', 'selectItemList', '✅学生管理-基础信息查询-查询列表', 'sql', '{}', '{ "table": "view01_student_new_structure", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  11. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (11, NULL, NULL, 'studentContactList', 'selectItemList', '✅学生管理-联系方式查询-查询列表', 'sql', '{}', '{ "table": "view01_student_contact", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  12. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (12, NULL, NULL, 'studentEducationBackgroundList', 'selectItemList', '✅学生管理-教育背景查询-查询列表', 'sql', '{}', '{ "table": "view01_student_education_background", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  13. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (13, NULL, NULL, 'studentFinancialAidList', 'selectItemList', '✅学生管理-助学金查询-查询列表', 'sql', '{}', '{ "table": "view01_student_financial_aid", "operation": "select" }', 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 (14, NULL, NULL, 'studentGuardianList', 'selectItemList', '✅学生管理-监护人查询-查询列表', 'sql', '{}', '{ "table": "view01_student_guardian", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  15. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (15, NULL, NULL, 'studentHometownList', 'selectItemList', '✅学生管理-籍贯查询-查询列表', 'sql', '{}', '{ "table": "view01_student_hometown", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  16. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (16, NULL, NULL, 'studentLogisticsList', 'selectItemList', '✅学生管理-宿舍查询-查询列表', 'sql', '{}', '{ "table": "view01_student_logistics", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  17. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (17, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', 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 (18, NULL, NULL, 'appraisalManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view02_appraisal", "operation": "select"}', 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 (19, NULL, '', 'appraisalManagement', 'insertItem', '✅添加', 'service', '{}', '{"service": "appraisal", "serviceFunction": "createAppraisal"}', 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 (20, NULL, NULL, 'appraisalManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "appraisal", "operation": "jhUpdate" }', 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 (21, NULL, NULL, 'appraisalManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "appraisal", "operation": "jhDelete" }', 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 (22, NULL, NULL, 'appraisalManagement', 'selectClassList', '✅班级列表', 'sql', '{}', '{ "table": "view01_class", "operation": "select", "where": { "formTeacherId": "ctx.userInfo.userId" } }', 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 (23, NULL, NULL, 'appraisalStudentManagementOfOneAppraisal', 'selectCurrentList', '✅评语的学生评语管理-查询当前学生评语下的评语列表', 'sql', '{}', '{ "table": "view02_appraisal_student", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  24. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (24, NULL, NULL, 'appraisalStudentManagementOfOneAppraisal', 'insertItem', '✅评语的学生评语管理-建立关系', 'sql', '{}', '{ "table": "appraisal_student", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  25. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (25, NULL, NULL, 'appraisalStudentManagementOfOneAppraisal', 'updateItem', '✅评语的学生评语管理-更新数据', 'sql', '{}', '{ "table": "appraisal_student", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  26. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (26, NULL, NULL, 'appraisalStudentManagementOfOneAppraisal', 'deleteItem', '✅评语的学生评语管理-删除信息', 'sql', '{}', '{ "table": "appraisal_student", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  27. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (27, NULL, NULL, 'appraisalStudentManagementOfOneAppraisal', 'selectAllList', '✅评语查询-查询列表', 'sql', '{}', '{ "table": "appraisal_student", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  28. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (28, NULL, NULL, 'appraisalManagement', 'sendNotice', '✅发送通知', 'service', '{}', '{"service": "appraisal", "serviceFunction": "sendNotice"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  29. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (29, NULL, NULL, 'appraisalManagement', 'selectAppraisalStudentList', '✅发送通知', 'sql', '{}', '{ "table": "view02_appraisal_student", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  30. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 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');
  31. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 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');
  32. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 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');
  33. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (33, 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');
  34. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 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');
  35. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 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');
  36. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 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');
  37. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (37, NULL, NULL, 'userGroupRole', 'insertGroup', '✅权限管理页-添加群组', 'sql', NULL, '{"table": "_group", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:55:57+08:00');
  38. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (38, NULL, NULL, 'userGroupRole', 'insertRole', '✅权限管理页-添加角色', 'sql', NULL, '{"table": "_role", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:00:37+08:00');
  39. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 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');
  40. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 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');
  41. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (41, NULL, NULL, 'userGroupRole', 'updateGroup', '✅权限管理页-更新群组', 'sql', NULL, '{"table": "_group", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:45:26+08:00');
  42. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (42, NULL, NULL, 'userGroupRole', 'updateRole', '✅权限管理页-更新角色', 'sql', NULL, '{"table": "_role", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:56:37+08:00');
  43. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (43, NULL, NULL, 'appraisalSetting', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  44. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (44, NULL, NULL, 'appraisalSetting', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "_constant", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  45. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, NULL, NULL, 'appraisalSetting', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "_constant", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  46. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (46, NULL, NULL, 'appraisalSetting', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "_constant", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);