接口
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 = 469 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
_resource 内容
| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
|---|---|---|---|---|---|---|
| 231 | ✅登陆 | login | passwordLogin | service | { "service": "user", "serviceFunction": "passwordLogin" } | |
| 251 | ✅登出 | allPage | logout | service | { "service": "user", "serviceFunction": "logout" } | |
| 253 | ✅获取用户信息 | allPage | userInfo | service | { "service": "user", "serviceFunction": "userInfo" } | |
| 258 | ✅查询常量 | allPage | getConstantList | sql | { "table": "_constant", "operation": "select" } | |
| 259 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service | {"service": "file", "serviceFunction": "uploadFileChunkByStream"} | |
| 260 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service | {"service": "file", "serviceFunction": "uploadFileDone"} | |
| 329 | ✅查询列表 | recruitmentManagement | selectItemList | sql | { "table": "view01_student_recruitment", "operation": "select" } | |
| 330 | ✅添加 | recruitmentManagement | insertItem | sql | {"before": [ | |
| {"service": "recruitment", "serviceFunction": "createStudentBeforeCheck"} | ||||||
| ]} | { "table": "student_recruitment", "operation": "insert" } | |||||
| 331 | ✅更新 | recruitmentManagement | updateItem | sql | { "table": "student_recruitment", "operation": "jhUpdate" } | |
| 332 | ✅删除 | recruitmentManagement | deleteItem | sql | { "table": "student_recruitment", "operation": "jhDelete" } | |
| 333 | ✅内部报名 | recruitmentManagement | recruitmentByManagement | service | { "service": "recruitment", "serviceFunction": "recruitmentByManagement" } | |
| 334 | ✅获取excel配置信息 | recruitmentManagement | getExcelTemplateConfig | service | { "service": "recruitment", "serviceFunction": "getExcelTemplateConfig" } | |
| 335 | ✅报名列表检查 | recruitmentManagement | studentListCheck | service | { "service": "recruitment", "serviceFunction": "studentListCheck" } | |
| 336 | ✅随机分配-跟进人 | recruitmentManagement | randomFollowUp | service | { "service": "recruitment", "serviceFunction": "randomFollowUp" } | |
| 434 | ✅学生报名 | studentRecruitment | recruitmentByStudent | service | { "service": "recruitment", "serviceFunction": "recruitmentByStudent" } | |
| 435 | ✅查询-入学跟进人列表 | recruitmentManagement | selectFollowUpByUser | sql | { "table": "view01_follow_up_user", "operation": "select" } | |
| 436 | ✅查询-入学跟进数 | recruitmentManagement | selectFollowUpCount | sql | { "table": "view01_follow_up_count", "operation": "select" } | |
| 437 | ✅跟进-学生报名 | recruitmentManagement | followUpRecruitment | service | { "service": "recruitment", "serviceFunction": "followUpRecruitment" } | |
| 438 | ✅转让跟进-学生报名 | recruitmentManagement | followUpTransfer | service | { "service": "recruitment", "serviceFunction": "followUpTransfer" } | |
| 439 | ✅随机分配-跟进人 | recruitmentManagement | recommendFollowUp | service | { "service": "recruitment", "serviceFunction": "recommendFollowUp" } | |
| 440 | ✅内部报名 | followUpStudent | selectItemList | service | { "service": "recruitment", "serviceFunction": "getFllowUpUserList" } | |
| 441 | ✅内部报名 | followUpStudent | batchFollowUp | service | { "service": "recruitment", "serviceFunction": "batchFollowUp" } | |
| 442 | ✅跟进-学生报名 | followUpStudent | followUpRecruitment | service | { "service": "recruitment", "serviceFunction": "followUpRecruitment" } | |
| 443 | ✅转让跟进-学生报名 | followUpStudent | followUpTransfer | service | { "service": "recruitment", "serviceFunction": "followUpTransfer" } | |
| 444 | ✅更新 | followUpStudent | updateItem | sql | { "table": "student_recruitment", "operation": "jhUpdate" } | |
| 445 | ✅权限管理页-查询已配置权限列表 | userGroupRole | selectItemList | sql | {"table": "_user_group_role", "operation": "select"} | |
| 446 | ✅权限管理页-查询用户 | userGroupRole | selectUser | sql | {"table": "_view02_user_app", "operation": "select"} | |
| 447 | ✅权限管理页-查询群组 | userGroupRole | selectGroup | sql | {"table": "_group", "operation": "select"} | |
| 448 | ✅权限管理页-创建权限配置 | userGroupRole | insertItem | sql | {"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""} | |
| 449 | ✅权限管理页-更新权限配置 | userGroupRole | updateItem | sql | {"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} | |
| 450 | ✅权限管理页-删除权限配置 | userGroupRole | deleteItem | sql | {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} | |
| 451 | ✅权限管理页-查询角色 | userGroupRole | selectRole | sql | {"table": "_role", "operation": "select"} | |
| 452 | ✅权限管理页-添加用户 | userGroupRole | insertUser | service | {"service": "userManagement", "serviceFunction": "addUser"} | |
| 453 | ✅权限管理页-添加群组 | userGroupRole | insertGroup | sql | {"table": "_group", "operation": "jhInsert"} | |
| 454 | ✅权限管理页-添加角色 | userGroupRole | insertRole | sql | {"table": "_role", "operation": "jhInsert"} | |
| 455 | ✅权限管理页-删除用户 | userGroupRole | deleteUser | sql | { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } | {"table": "_user", "operation": "jhDelete"} |
| 456 | ✅权限管理页-删除群组 | userGroupRole | deleteGroup | sql | { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } | {"table": "_group", "operation": "jhDelete"} |
| 457 | ✅权限管理页-删除角色 | userGroupRole | deleteRole | sql | { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } | {"table": "_role", "operation": "jhDelete"} |
| 458 | ✅权限管理页-更新用户 | userGroupRole | updateUser | sql | {"table": "_user", "operation": "jhUpdate"} | |
| 459 | ✅权限管理页-更新群组 | userGroupRole | updateGroup | sql | {"table": "_group", "operation": "jhUpdate"} | |
| 460 | ✅权限管理页-更新角色 | userGroupRole | updateRole | sql | {"table": "_role", "operation": "jhUpdate"} | |
| 461 | ✅查询列表 | recruitmentSuper | selectItemList | sql | { "table": "student_recruitment", "operation": "select" } | |
| 462 | ✅添加 | recruitmentSuper | insertItem | sql | { "table": "student_recruitment", "operation": "insert" } | |
| 463 | ✅更新 | recruitmentSuper | updateItem | sql | { "table": "student_recruitment", "operation": "jhUpdate" } | |
| 464 | ✅删除 | recruitmentSuper | deleteItem | sql | { "table": "student_recruitment", "operation": "jhDelete" } | |
| 467 | ✅查询列表 | recruitmentAdmin | selectItemList | sql | { "table": "view01_student_recruitment", "operation": "select" } | |
| 468 | ✅更新 | recruitmentAdmin | updateItem | sql | {"after": [{ |
"service": "recruitment", "serviceFunction": "checkGenerateStudent"
}]} | { "table": "student_recruitment", "operation": "jhUpdate" } |
_resource语句
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, 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 (251, 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 (253, 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 (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "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 (259, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (260, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (329, NULL, '', 'recruitmentManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_recruitment", "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 (330, NULL, '{"before": [{"service": "recruitment", "serviceFunction": "createStudentBeforeCheck"}]}', 'recruitmentManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "student_recruitment", "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 (331, NULL, NULL, 'recruitmentManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_recruitment", "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 (332, NULL, NULL, 'recruitmentManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "student_recruitment", "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 (333, NULL, NULL, 'recruitmentManagement', 'recruitmentByManagement', '✅内部报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "recruitmentByManagement" }', 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 (334, NULL, NULL, 'recruitmentManagement', 'getExcelTemplateConfig', '✅获取excel配置信息', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "getExcelTemplateConfig" }', 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 (335, NULL, NULL, 'recruitmentManagement', 'studentListCheck', '✅报名列表检查', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "studentListCheck" }', 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 (336, NULL, NULL, 'recruitmentManagement', 'randomFollowUp', '✅随机分配-跟进人', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "randomFollowUp" }', 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 (434, NULL, NULL, 'studentRecruitment', 'recruitmentByStudent', '✅学生报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "recruitmentByStudent" }', 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 (435, NULL, NULL, 'recruitmentManagement', 'selectFollowUpByUser', '✅查询-入学跟进人列表', 'sql', '{}', '{ "table": "view01_follow_up_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 (436, NULL, NULL, 'recruitmentManagement', 'selectFollowUpCount', '✅查询-入学跟进数', 'sql', '{}', '{ "table": "view01_follow_up_count", "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 (437, NULL, NULL, 'recruitmentManagement', 'followUpRecruitment', '✅跟进-学生报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "followUpRecruitment" }', 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 (438, NULL, NULL, 'recruitmentManagement', 'followUpTransfer', '✅转让跟进-学生报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "followUpTransfer" }', 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 (439, NULL, NULL, 'recruitmentManagement', 'recommendFollowUp', '✅随机分配-跟进人', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "recommendFollowUp" }', 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 (440, NULL, '', 'followUpStudent', 'selectItemList', '✅内部报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "getFllowUpUserList" }', 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, NULL, 'followUpStudent', 'batchFollowUp', '✅内部报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "batchFollowUp" }', 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, 'followUpStudent', 'followUpRecruitment', '✅跟进-学生报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "followUpRecruitment" }', 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, NULL, 'followUpStudent', 'followUpTransfer', '✅转让跟进-学生报名', 'service', '{}', '{ "service": "recruitment", "serviceFunction": "followUpTransfer" }', 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, '', 'followUpStudent', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_recruitment", "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 (445, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (446, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (447, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (448, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (449, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (450, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (451, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (452, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (453, NULL, NULL, 'userGroupRole', 'insertGroup', '✅权限管理页-添加群组', 'sql', NULL, '{"table": "_group", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:55:57+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (454, NULL, NULL, 'userGroupRole', 'insertRole', '✅权限管理页-添加角色', 'sql', NULL, '{"table": "_role", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:00:37+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (455, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (456, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (457, 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');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (458, NULL, NULL, 'userGroupRole', 'updateUser', '✅权限管理页-更新用户', 'sql', NULL, '{"table": "_user", "operation": "jhUpdate"}', '{"appData": {"appId": "demo_advanced", "where": {"id": 68}, "pageId": "userGroupRole", "actionId": "updateUser", "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": {"config": null, "userId": "001", "md5Salt": "ZsPkQcHpYZQT", "password": "b9e96d6ebc84dd51f2bd1fb56a79d8cb", "userType": "common", "username": "å°ÂÃ¥ÂÂ", "operation": "jhUpdate", "idSequence": "26260000", "userStatus": "active", "operationAt": "2022-05-02T15:21:34+08:00", "initPassword": null, "operationByUser": "adminName", "clearTextPassword": "1234567", "operationByUserId": "admin"}}, "packageId": "1651476236716_5991856", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "updateUser", "resultData": {"rows": 1}}, "packageId": "1651476236716_5991856", "timestamp": "2022-05-02T15:23:57+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:23:57+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (459, NULL, NULL, 'userGroupRole', 'updateGroup', '✅权限管理页-更新群组', 'sql', NULL, '{"table": "_group", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:45:26+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (460, NULL, NULL, 'userGroupRole', 'updateRole', '✅权限管理页-更新角色', 'sql', NULL, '{"table": "_role", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:56:37+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (461, NULL, NULL, 'recruitmentSuper', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student_recruitment", "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 (462, NULL, NULL, 'recruitmentSuper', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "student_recruitment", "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 (463, NULL, NULL, 'recruitmentSuper', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_recruitment", "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 (464, NULL, NULL, 'recruitmentSuper', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "student_recruitment", "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 (467, NULL, NULL, 'recruitmentAdmin', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_recruitment", "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 (468, NULL, '{"after": [{"service": "recruitment", "serviceFunction": "checkGenerateStudent"}]}', 'recruitmentAdmin', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_recruitment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);