江湖数字化平台
登录

接口

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 = 359 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id desc pageId actionId resourceType resourceHook resourceData
6 ✅ 文件分片上传-所有分片上传完毕 allPage uploadFileDone service {"service": "file", "serviceFunction": "uploadFileDone"}
7 ✅ 文件分片上传-http文件流 allPage httpUploadByStream service {"service": "file", "serviceFunction": "uploadFileChunkByStream"}
8 ✅ 文件分片上传-http base64 allPage httpUploadByBase64 service {"service": "file", "serviceFunction": "uploadFileChunkByBase64"}
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 ✅查询入学学生列表 enrollment selectItemList sql { "table": "student_basic", "operation": "select" }
260 ✅添加入学学生 enrollment insertItem sql {"before": [{"service": "student", "serviceFunction": "beforHookForGenerateStudentId"}]} { "table": "student_basic", "operation": "insert" }
261 ✅更新入学学生 enrollment updateItem sql {"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]} { "table": "student_basic", "operation": "jhUpdate" }
262 ✅删除入学学生 enrollment deleteItem sql { "table": "student_basic", "operation": "jhDelete" }
263 ✅录入信息 - 获取当前最新的学生ID enrollment getNewMaxId service { "service": "student", "serviceFunction": "getNewMaxId" }
264 ✅工单打印预览 - 获取学生信息 workflowPrintPreview getStudentWorkflowInfo sql { "table": "student_basic", "operation": "select" }
265 ✅查询入学学生住宿列表 logisticsAssignment selectItemList sql { "table": "student_basic", "operation": "select" }
266 ✅更新入学学生住宿信息 logisticsAssignment updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
267 ✅查询入学学生缴费情况列表 updatePaymentStatus selectItemList sql { "table": "view01_student_bill", "operation": "select" }
268 ✅更新入学学生缴费信息 updatePaymentStatus updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
269 ✅查询班级列表 classManagement selectItemList sql { "table": "view01_class", "operation": "select" }
270 ✅添加新班级 classManagement insertItem sql {"before": [{"service": "class", "serviceFunction": "checkClassBeforeInsert"}]} { "table": "class", "operation": "insert" }
272 ✅删除班级 classManagement deleteItem sql { "table": "class", "operation": "jhDelete" }
273 ✅班级的学生管理-查询当前班级下的学生列表 studentManagementOfOneClass selectItemList service { "service": "student", "serviceFunction": "getAllotStudent" }
274 ✅班级的学生管理-把学生加到班级 studentManagementOfOneClass insertItem sql { "table": "student_basic", "operation": "jhInsert" }
275 ✅班级的学生管理-更新学生数据 studentManagementOfOneClass allotItem service {"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]} { "service": "student", "serviceFunction": "allotStudentInsertHistory" }
276 ✅班级的学生管理-把学生从班级中移除 studentManagementOfOneClass deleteItem sql { "table": "student_basic", "operation": "jhDelete" }
277 ✅班级的学生管理-查询未分配的学生查询 studentManagementOfOneClass selectUnassignedList sql { "table": "view01_student_basic_class", "operation": "select" }
278 ✅查询列表 enrollmentApproved selectItemList sql { "table": "student_basic", "operation": "select" }
279 ✅添加 enrollmentApproved insertItem sql { "table": "student_basic", "operation": "insert" }
280 ✅更新 enrollmentApproved updateItem sql {"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]} { "table": "student_basic", "operation": "jhUpdate" }
281 ✅删除 enrollmentApproved deleteItem sql { "table": "student_basic", "operation": "jhDelete" }
282 ✅添加 enrollmentApproved insertItemtoStudentClass sql { "table": "student_class", "operation": "insert" }
283 ✅入学批准打印预览 - 获取学生信息 approvalAcknowledgementPrintPreview getStudentEnrollmentInfo sql { "table": "student_basic", "operation": "select" }
284 ✅查询学生班级列表 studentUpgrade selectItemList sql { "table": "class", "operation": "select" }
285 ✅升级 studentUpgrade upgradeItem service { "service": "class", "serviceFunction": "upgradeItem" }
286 ✅毕业 studentUpgrade graduationItem service { "service": "class", "serviceFunction": "graduationItem" }
287 ✅查询列表 quitApproved selectItemList sql { "table": "view01_student_basic_request", "operation": "select" }
288 ✅更新 quitApproved updateItem sql {"before": [{"service": "student", "serviceFunction": "beforHookForUpdateStudentAssignClassId"}]} { "table": "student_basic", "operation": "jhUpdate" }
293 ✅查询列表 quitApproved selectOtherStatusItemList sql { "table": "view01_student_basic_class", "operation": "select" }
294 ✅更新学生信息 studentManagement updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
295 ✅查询学生列表 studentManagement selectItemList sql { "table": "view01_student_basic_class", "operation": "select" }
296 ✅查询列表 quitRequest selectItemList sql { "table": "view01_student_basic_class", "operation": "select" }
297 ✅更新 quitRequest updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
298 ✅复制提交申请的学生去申请表 quitRequest createItem service {"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]} { "service": "student", "serviceFunction": "batchSubmitRequest" }
299 ✅更新 quitApproved updateApproveStatus sql {"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]} { "table": "student_request", "operation": "jhUpdate" }
301 ✅更新申请表 approvalChangeLevel updateLevelItem sql { "table": "student_request", "operation": "jhUpdate" }
302 ✅复制提交申请的学生去申请表 changeLevelRequest createItem sql { "table": "student_request", "operation": "insert" }
304 ✅查询列表 changeLevelRequest selectItemList sql { "table": "student_basic", "operation": "select" }
305 ✅更新基础班申请类型 changeLevelRequest updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
306 ✅更新班级表 approvalChangeLevel updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
307 ✅查询列表 approvalChangeLevel selectItemList sql { "table": "student_request", "operation": "select" }
308 ✅删除 quitApproved deleteItemFromRequest sql { "table": "student_request", "operation": "jhDelete" }
309 ✅更新-驳回 approvalChangeLevel updateRequestItem sql { "table": "student_basic", "operation": "jhUpdate" }
310 ✅删除 approvalChangeLevel deleteItemFromRequest sql { "table": "student_request", "operation": "jhDelete" }
311 ✅查询列表 quitAssignment selectItemList sql { "table": "view01_student_basic_request", "operation": "select" }
312 ✅查询列表 quitPayment selectItemList sql { "table": "view01_student_basic_request", "operation": "select" }
313 ✅修改班级标签 classManagement updateItem sql { "table": "class", "operation": "jhUpdate" }
326 ✅权限管理页-查询已配置权限列表 userGroupRole selectItemList sql {"table": "_user_group_role", "operation": "select"}
327 ✅权限管理页-查询用户 userGroupRole selectUser sql {"table": "_view02_user_app", "operation": "select"}
328 ✅权限管理页-查询群组 userGroupRole selectGroup sql {"table": "_group", "operation": "select"}
329 ✅权限管理页-创建权限配置 userGroupRole insertItem sql {"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""}
330 ✅权限管理页-更新权限配置 userGroupRole updateItem sql {"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}
331 ✅权限管理页-删除权限配置 userGroupRole deleteItem sql {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}
332 ✅权限管理页-查询角色 userGroupRole selectRole sql {"table": "_role", "operation": "select"}
333 ✅权限管理页-添加用户 userGroupRole insertUser service {"service": "userManagement", "serviceFunction": "addUser"}
334 ✅权限管理页-添加群组 userGroupRole insertGroup sql {"table": "_group", "operation": "jhInsert"}
335 ✅权限管理页-添加角色 userGroupRole insertRole sql {"table": "_role", "operation": "jhInsert"}
336 ✅权限管理页-删除用户 userGroupRole deleteUser sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_user", "operation": "jhDelete"}
337 ✅权限管理页-删除群组 userGroupRole deleteGroup sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_group", "operation": "jhDelete"}
338 ✅权限管理页-删除角色 userGroupRole deleteRole sql { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } {"table": "_role", "operation": "jhDelete"}
339 ✅权限管理页-更新群组 userGroupRole updateGroup sql {"table": "_group", "operation": "jhUpdate"}
340 ✅权限管理页-更新角色 userGroupRole updateRole sql {"table": "_role", "operation": "jhUpdate"}
341 ✅缴费信息导入-数据校验 studentImport checkImportData service {"service": "student", "serviceFunction": "checkImportData"}
342 ✅缴费信息导入-导入 studentImport importPaymentData service {"service":"student","serviceFunction":"importPaymentData"}
343 ✅查询列表 studentGraduation selectItemList sql { "table": "view01_student_basic_class", "operation": "select" }
345 ✅更新 studentGraduation updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
347 ✅添加再入学班级历史 enrollment insertHistory sql { "table": "student_class_history", "operation": "insert" }
348 ✅查询入学学生列表 enrollment selectDetailItem sql { "table": "view01_student_basic_class", "operation": "select" }
349 ✅ classManagement getAllUserList sql { "table": "_view01_user", "operation": "select" }
350 ✅班级的学生管理-更新学生数据 studentManagementOfOneClass updateItem sql { "table": "student_basic", "operation": "jhUpdate" }
351 ✅查询列表-student_status_history student_status_history studentStatusHistory-selectItemList sql {} {"table":"student_status_history","operation":"select"}
355 ✅查询附件 studentManagement fileUpload-selectItemList sql {"table":"student_attachment","operation":"select"}
356 ✅新增附件 studentManagement fileUpload-insertItem sql {"table":"student_attachment","operation":"jhInsert"}
357 ✅编辑附件 studentManagement fileUpload-updateItem sql {"table":"student_attachment","operation":"jhUpdate"}
358 ✅删除附件 studentManagement fileUpload-deleteItem sql {"table":"student_attachment","operation":"jhDelete"}

_resource语句

  1. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "uploadFileDone", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36", "actionData": {"hash": "2fa86466e9d98b1ffc4aeeaa2d60dcec", "total": 1, "fileDesc": "11", "filename": "终端存储的输出.txt", "chunkSize": 3145728, "fileDirectory": "testFile"}}, "packageId": "1657461344665_2984863", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "fileId": "1657461344688_791754", "pageId": "allPage", "actionId": "uploadFileDone", "fileDesc": "11", "filename": "终端存储的输出.txt", "binarySize": "1.42KB", "resultData": {"fileId": "1657461344688_791754", "fileDesc": "11", "filename": "终端存储的输出.txt", "binarySize": "1.42KB", "downloadTip": "https://xxx.xxx.xxx/${downloadBasePath}${downloadPath}", "downloadPath": "/testFile/1657461344688_791754_终端存储的输出.txt", "fileDirectory": "testFile", "filenameStorage": "1657461344688_791754_终端存储的输出.txt", "downloadBasePath": "/demo_advanced/upload"}, "downloadTip": "https://xxx.xxx.xxx/${downloadBasePath}${downloadPath}", "downloadPath": "/testFile/1657461344688_791754_终端存储的输出.txt", "fileDirectory": "testFile", "filenameStorage": "1657461344688_791754_终端存储的输出.txt", "downloadBasePath": "/demo_advanced/upload"}, "packageId": "1657461344665_2984863", "timestamp": "2022-07-10T21:55:44+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-07-10T21:55:44+08:00');
  2. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByStream", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36", "actionData": {"hash": "2fa86466e9d98b1ffc4aeeaa2d60dcec", "total": 1, "chunFile": {}, "filename": "终端存储的输出.txt", "chunkSize": 3145728, "indexString": "0000"}}, "packageId": "1657461344594_9853016", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByStream"}, "packageId": "1657461344594_9853016", "timestamp": "2022-07-10T21:55:44+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-07-10T21:55:44+08:00');
  3. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (8, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByBase64"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByBase64", "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": {"hash": "93a29a14e4b922cc102811b8daa4793b", "total": 1, "chunFile": {}, "filename": "answer-time-right-toast.png", "chunkSize": 3145728, "fileBase64": null, "indexString": "0000"}}, "packageId": "1651128190181_2258419", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByBase64"}, "packageId": "1651128190181_2258419", "timestamp": "2022-04-28T14:43:10+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T14:43:10+08:00');
  4. 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"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
  5. 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);
  6. 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"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
  7. 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);
  8. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (259, NULL, NULL, 'enrollment', 'selectItemList', '✅查询入学学生列表', 'sql', '{}', '{ "table": "student_basic", "operation": "select" }', 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 (260, NULL, '{"before": [{"service": "student", "serviceFunction": "beforHookForGenerateStudentId"}]}', 'enrollment', 'insertItem', '✅添加入学学生', 'sql', '{}', '{ "table": "student_basic", "operation": "insert" }', 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 (261, NULL, '{"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]}', 'enrollment', 'updateItem', '✅更新入学学生', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', 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 (262, NULL, NULL, 'enrollment', 'deleteItem', '✅删除入学学生', 'sql', '{}', '{ "table": "student_basic", "operation": "jhDelete" }', 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 (263, NULL, NULL, 'enrollment', 'getNewMaxId', '✅录入信息 - 获取当前最新的学生ID', 'service', '{}', '{ "service": "student", "serviceFunction": "getNewMaxId" }', 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 (264, NULL, NULL, 'workflowPrintPreview', 'getStudentWorkflowInfo', '✅工单打印预览 - 获取学生信息', 'sql', '{}', '{ "table": "student_basic", "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 (265, NULL, NULL, 'logisticsAssignment', 'selectItemList', '✅查询入学学生住宿列表', 'sql', '{}', '{ "table": "student_basic", "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 (266, NULL, NULL, 'logisticsAssignment', 'updateItem', '✅更新入学学生住宿信息', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', 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 (267, NULL, NULL, 'updatePaymentStatus', 'selectItemList', '✅查询入学学生缴费情况列表', 'sql', '{}', '{ "table": "view01_student_bill", "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 (268, NULL, NULL, 'updatePaymentStatus', 'updateItem', '✅更新入学学生缴费信息', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', 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 (269, NULL, NULL, 'classManagement', 'selectItemList', '✅查询班级列表', 'sql', '{}', '{ "table": "view01_class", "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 (270, NULL, '{"before": [{"service": "class", "serviceFunction": "checkClassBeforeInsert"}]}', 'classManagement', 'insertItem', '✅添加新班级', 'sql', '{}', '{ "table": "class", "operation": "insert" }', 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 (272, NULL, NULL, 'classManagement', 'deleteItem', '✅删除班级', 'sql', '{}', '{ "table": "class", "operation": "jhDelete" }', 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 (273, NULL, NULL, 'studentManagementOfOneClass', 'selectItemList', '✅班级的学生管理-查询当前班级下的学生列表', 'service', '{}', '{ "service": "student", "serviceFunction": "getAllotStudent" }', 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 (274, NULL, NULL, 'studentManagementOfOneClass', 'insertItem', '✅班级的学生管理-把学生加到班级', 'sql', '{}', '{ "table": "student_basic", "operation": "jhInsert" }', 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 (275, NULL, '{"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]}', 'studentManagementOfOneClass', 'allotItem', '✅班级的学生管理-更新学生数据', 'service', '{}', '{ "service": "student", "serviceFunction": "allotStudentInsertHistory" }', 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 (276, NULL, NULL, 'studentManagementOfOneClass', 'deleteItem', '✅班级的学生管理-把学生从班级中移除', 'sql', '{}', '{ "table": "student_basic", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  25. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (277, NULL, NULL, 'studentManagementOfOneClass', 'selectUnassignedList', '✅班级的学生管理-查询未分配的学生查询', 'sql', '{}', '{ "table": "view01_student_basic_class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  26. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (278, NULL, NULL, 'enrollmentApproved', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student_basic", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  27. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (279, NULL, NULL, 'enrollmentApproved', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "student_basic", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  28. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (280, NULL, '{"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]}', 'enrollmentApproved', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', 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 (281, NULL, NULL, 'enrollmentApproved', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "student_basic", "operation": "jhDelete" }', 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 (282, NULL, NULL, 'enrollmentApproved', 'insertItemtoStudentClass', '✅添加', 'sql', '{}', '{ "table": "student_class", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  31. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (283, NULL, NULL, 'approvalAcknowledgementPrintPreview', 'getStudentEnrollmentInfo', '✅入学批准打印预览 - 获取学生信息', 'sql', '{}', '{ "table": "student_basic", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  32. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (284, NULL, NULL, 'studentUpgrade', 'selectItemList', '✅查询学生班级列表', 'sql', '{}', '{ "table": "class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  33. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (285, NULL, NULL, 'studentUpgrade', 'upgradeItem', '✅升级', 'service', '{}', '{ "service": "class", "serviceFunction": "upgradeItem" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  34. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (286, NULL, NULL, 'studentUpgrade', 'graduationItem', '✅毕业', 'service', '{}', '{ "service": "class", "serviceFunction": "graduationItem" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  35. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (287, NULL, NULL, 'quitApproved', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_basic_request", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  36. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (288, NULL, '{"before": [{"service": "student", "serviceFunction": "beforHookForUpdateStudentAssignClassId"}]}', 'quitApproved', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  37. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (293, NULL, NULL, 'quitApproved', 'selectOtherStatusItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_basic_class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  38. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (294, NULL, NULL, 'studentManagement', 'updateItem', '✅更新学生信息', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  39. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (295, NULL, NULL, 'studentManagement', 'selectItemList', '✅查询学生列表', 'sql', '{}', '{ "table": "view01_student_basic_class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  40. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (296, NULL, NULL, 'quitRequest', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_basic_class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  41. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (297, NULL, NULL, 'quitRequest', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  42. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (298, NULL, '{"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]}', 'quitRequest', 'createItem', '✅复制提交申请的学生去申请表', 'service', '{}', '{ "service": "student", "serviceFunction": "batchSubmitRequest" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  43. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (299, NULL, '{"after": [{"service": "student", "serviceFunction": "studentStatusHistory"}]}', 'quitApproved', 'updateApproveStatus', '✅更新', 'sql', '{}', '{ "table": "student_request", "operation": "jhUpdate" }', 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 (301, NULL, NULL, 'approvalChangeLevel', 'updateLevelItem', '✅更新申请表', 'sql', '{}', '{ "table": "student_request", "operation": "jhUpdate" }', 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 (302, NULL, NULL, 'changeLevelRequest', 'createItem', '✅复制提交申请的学生去申请表', 'sql', '{}', '{ "table": "student_request", "operation": "insert" }', 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 (304, NULL, NULL, 'changeLevelRequest', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student_basic", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  47. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (305, NULL, NULL, 'changeLevelRequest', 'updateItem', '✅更新基础班申请类型', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  48. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (306, NULL, NULL, 'approvalChangeLevel', 'updateItem', '✅更新班级表', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  49. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (307, NULL, NULL, 'approvalChangeLevel', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student_request", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  50. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (308, NULL, NULL, 'quitApproved', 'deleteItemFromRequest', '✅删除', 'sql', '{}', '{ "table": "student_request", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  51. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (309, NULL, NULL, 'approvalChangeLevel', 'updateRequestItem', '✅更新-驳回', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  52. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (310, NULL, NULL, 'approvalChangeLevel', 'deleteItemFromRequest', '✅删除', 'sql', '{}', '{ "table": "student_request", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  53. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (311, NULL, NULL, 'quitAssignment', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_basic_request", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  54. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (312, NULL, NULL, 'quitPayment', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_basic_request", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  55. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (313, NULL, NULL, 'classManagement', 'updateItem', '✅修改班级标签', 'sql', '{}', '{ "table": "class", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  56. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (326, 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');
  57. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (327, 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');
  58. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (328, 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');
  59. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (329, 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');
  60. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (330, 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');
  61. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (331, 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');
  62. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (332, 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');
  63. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (333, 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');
  64. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (334, NULL, NULL, 'userGroupRole', 'insertGroup', '✅权限管理页-添加群组', 'sql', NULL, '{"table": "_group", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:55:57+08:00');
  65. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (335, NULL, NULL, 'userGroupRole', 'insertRole', '✅权限管理页-添加角色', 'sql', NULL, '{"table": "_role", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:00:37+08:00');
  66. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (336, 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');
  67. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (337, 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');
  68. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (338, 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');
  69. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (339, NULL, NULL, 'userGroupRole', 'updateGroup', '✅权限管理页-更新群组', 'sql', NULL, '{"table": "_group", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:45:26+08:00');
  70. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (340, NULL, NULL, 'userGroupRole', 'updateRole', '✅权限管理页-更新角色', 'sql', NULL, '{"table": "_role", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:56:37+08:00');
  71. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (341, NULL, NULL, 'studentImport', 'checkImportData', '✅缴费信息导入-数据校验', 'service', '{}', '{"service": "student", "serviceFunction": "checkImportData"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  72. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (342, NULL, NULL, 'studentImport', 'importPaymentData', '✅缴费信息导入-导入', 'service', '{}', '{"service":"student","serviceFunction":"importPaymentData"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  73. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (343, NULL, NULL, 'studentGraduation', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_student_basic_class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  74. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (345, NULL, NULL, 'studentGraduation', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  75. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (347, NULL, NULL, 'enrollment', 'insertHistory', '✅添加再入学班级历史', 'sql', '{}', '{ "table": "student_class_history", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  76. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (348, NULL, NULL, 'enrollment', 'selectDetailItem', '✅查询入学学生列表', 'sql', '{}', '{ "table": "view01_student_basic_class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  77. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (349, NULL, NULL, 'classManagement', 'getAllUserList', '✅', 'sql', NULL, '{ "table": "_view01_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  78. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (350, NULL, NULL, 'studentManagementOfOneClass', 'updateItem', '✅班级的学生管理-更新学生数据', 'sql', '{}', '{ "table": "student_basic", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  79. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (351, NULL, '{}', 'student_status_history', 'studentStatusHistory-selectItemList', '✅查询列表-student_status_history', 'sql', NULL, '{"table":"student_status_history","operation":"select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  80. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (355, NULL, NULL, 'studentManagement', 'fileUpload-selectItemList', '✅查询附件', 'sql', NULL, '{"table":"student_attachment","operation":"select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  81. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (356, NULL, NULL, 'studentManagement', 'fileUpload-insertItem', '✅新增附件', 'sql', NULL, '{"table":"student_attachment","operation":"jhInsert"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  82. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (357, NULL, NULL, 'studentManagement', 'fileUpload-updateItem', '✅编辑附件', 'sql', NULL, '{"table":"student_attachment","operation":"jhUpdate"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  83. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (358, NULL, NULL, 'studentManagement', 'fileUpload-deleteItem', '✅删除附件', 'sql', NULL, '{"table":"student_attachment","operation":"jhDelete"}', NULL, NULL, 'insert', NULL, NULL, NULL);