接口

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

_resource 内容

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
22	✅云盘-获取用户云盘	cloud_drive	getUserCloudDriveList	service		{ "service": "cloudDrive", "serviceFunction": "getUserCloudDriveList" }
23	✅云盘-保存markdown文件	cloud_drive	saveMarkdown	service		{ "service": "cloudDrive", "serviceFunction": "saveMarkdown" }
24	✅云盘-移动文件	cloud_drive	moveFile	service		{ "service": "cloudDrive", "serviceFunction": "moveFile" }
25	✅云盘-复制文件	cloud_drive	copyFile	service		{ "service": "cloudDrive", "serviceFunction": "copyFile" }
26	✅云盘-文件列表	cloud_drive	getDirItemList	service		{ "service": "cloudDrive", "serviceFunction": "getDirItemList" }
27	✅云盘-删除文件	cloud_drive	deleteDirOrFile	service		{ "service": "cloudDrive", "serviceFunction": "deleteDirOrFile" }
28	✅云盘-获取markdown内容	cloud_drive	getMarkdownContent	service		{ "service": "cloudDrive", "serviceFunction": "getMarkdownContent" }
29	✅云盘- 重命名文件	cloud_drive	renameFile	service		{ "service": "cloudDrive", "serviceFunction": "renameFile" }
30	✅云盘-创建文件目录	cloud_drive	mkdir	service		{ "service": "cloudDrive", "serviceFunction": "mkdir" }
31	✅云盘-清空回收站	cloud_drive	clearRecycle	service		{ "service": "cloudDrive", "serviceFunction": "clearRecycle" }
101	✅ 文件分片下载-获取分片信息	allPage	getChunkInfo	service		{ "service": "file", "serviceFunction": "getChunkInfo" }
102	✅ 文件分片上传-所有分片上传完毕	allPage	uploadFileDone	service		{ "service": "file", "serviceFunction": "uploadFileDone" }
105	✅ 文件分片上传-http文件流	allPage	httpUploadByStream	service		{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }
106	✅ 文件分片上传-http base64	allPage	httpUploadByBase64	service		{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
112	✅ 文件分片下载-http base64	allPage	httpDownloadByBase64	service		{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
231	✅登陆	login	passwordLogin	service		{ "service": "user", "serviceFunction": "passwordLogin" }
251	✅登出	allPage	logout	service		{ "service": "user", "serviceFunction": "logout" }
253	✅获取用户信息	allPage	userInfo	service		{ "service": "user", "serviceFunction": "userInfo" }
254	✅修改用户密码	allPage	resetPassword	service		{ "service": "user", "serviceFunction": "resetPassword" }
258	✅查询常量	allPage	getConstantList	sql		{ "table": "_constant", "operation": "select" }
497	✅查询列表	codeViewManagement	selectItemList	sql		{ "table": "code_view", "operation": "select" }
498	✅添加	codeViewManagement	insertItem	sql	{ "before": [
{"service": "codeView", "serviceFunction": "beforeCreateCodeId"}
]
}	{ "table": "code_view", "operation": "insert" }
499	✅更新	codeViewManagement	updateItem	sql		{ "table": "code_view", "operation": "jhUpdate" }
500	✅删除	codeViewManagement	deleteItem	sql		{ "table": "code_view", "operation": "jhDelete" }
505	✅constantUiManagement查询-查询列表	constantUiManagement	selectItemList	sql		{"table": "web_constant_ui", "operation": "select"}
506	✅constantUiManagement查询-添加成员	constantUiManagement	insertItem	sql		{"table": "web_constant_ui", "operation": "insert"}
507	✅constantUiManagement查询-更新成员	constantUiManagement	updateItem	sql		{"table": "web_constant_ui", "operation": "jhUpdate"}
508	✅constantUiManagement查询-删除信息	constantUiManagement	deleteItem	sql		{"table": "web_constant_ui", "operation": "jhDelete"}
509	✅教材列表-查询列表	bookManagement	selectItemList	sql		{ "table": "view01_book", "operation": "select" }
510	✅教材列表-添加数据	bookManagement	insertItem	sql	{ "before": [
{"service": "book", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [{"service": "book", "serviceFunction": "addBookMaterialDir"}
] }	{ "table": "book", "operation": "insert" }
511	✅教材列表-更新数据	bookManagement	updateItem	sql	{ "before": [
{"service": "book", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }	{ "table": "book", "operation": "jhUpdate" }
512	✅教材列表-删除数据	bookManagement	deleteItem	sql	{ "before": [], "after": [{"service": "book", "serviceFunction": "deleteBookMaterialDir"}
] }	{ "table": "book", "operation": "jhUpdate" }
513	✅查询列表	bookSectionProgress	selectItemList	sql		{ "table": "book", "operation": "select" }
514	✅添加	bookSectionProgress	insertItem	sql		{ "table": "book", "operation": "insert" }
515	✅更新	bookSectionProgress	updateItem	sql		{ "table": "book", "operation": "jhUpdate" }
516	✅删除	bookSectionProgress	deleteItem	sql		{ "table": "book", "operation": "jhDelete" }
521	✅查询列表	bookSectionManagement	selectItemList	sql		{ "table": "section", "operation": "select" }
522	✅添加	bookSectionManagement	insertItem	sql		{ "table": "section", "operation": "insert" }
523	✅更新	bookSectionManagement	updateItem	service		{ "service": "section", "serviceFunction": "batchUpdate" }
524	✅删除	bookSectionManagement	deleteItem	sql		{ "table": "section", "operation": "jhDelete" }
525	✅教材列表	bookSectionManagement	selectBookList	sql		{ "table": "view01_book", "operation": "select" }
527	✅文章编辑-使用素材	sectionEdit	useMaterial	service		{ "service": "material", "serviceFunction": "useMaterial" }
528	✅文章编辑-查询列表	sectionEdit	selectBookList	sql		{ "table": "view01_book", "operation": "select" }
529	✅文章编辑-添加成员	sectionEdit	insertItem	sql	{ "before": [
{"service": "section", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]}	{ "table": "section", "operation": "jhInsert" }
530	✅文章编辑-查询文章列表	sectionEdit	selectItemList	sql		{ "table": "section", "operation": "select" }
531	✅文章编辑-更新成员	sectionEdit	updateItem	sql	{ "before": [
{"service": "section", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
]}	{ "table": "section", "operation": "jhUpdate" }
532	✅文章编辑-将文章移至回收站	sectionEdit	deleteItem	service		{ "service": "section", "serviceFunction": "delete" }
533	✅文章编辑-文章恢复	sectionEdit	restoreItem	service		{ "service": "section", "serviceFunction": "restore" }
535	✅查询列表	sectionList	selectItemList	sql		{ "table": "view01_book_section_groupby", "operation": "select" }
536	✅添加	sectionList	insertItem	sql		{ "table": "section", "operation": "insert" }
537	✅更新	sectionList	updateItem	sql		{ "table": "section", "operation": "jhUpdate" }
538	✅删除	sectionList	deleteItem	sql		{ "table": "section", "operation": "jhDelete" }
539	✅查询	bookLessonEditor	selectSectionList	sql		{ "table": "view01_section", "operation": "select" }
540	✅查询	bookLessonEditor	selectLessonList	sql		{ "table": "section_lesson", "operation": "select" }
541	✅添加	bookLessonEditor	insertItem	sql	{ "before": [
{"service": "lesson", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]}	{ "table": "section_lesson", "operation": "jhInsert" }
542	✅更新	bookLessonEditor	updateItem	sql		{ "table": "section_lesson", "operation": "jhUpdate" }
543	✅xf编辑-文件列表	sectionEdit	list	service		{ "service": "material", "serviceFunction": "list" }
544	✅xf编辑-创建文件夹	sectionEdit	mkdir	service		{ "service": "material", "serviceFunction": "mkdir" }
545	✅xf编辑-移动文件	sectionEdit	moveFile	service		{ "service": "material", "serviceFunction": "moveFile" }
546	✅xf编辑-复制文件	sectionEdit	copyFile	service		{ "service": "material", "serviceFunction": "copyFile" }
547	✅xf编辑-文件重命名	sectionEdit	renameFile	service		{ "service": "material", "serviceFunction": "renameFile" }
548	✅xf编辑-删除	sectionEdit	delete	service		{ "service": "material", "serviceFunction": "delete" }
549	✅xf编辑-清空回收站	sectionEdit	clearRecycle	service		{ "service": "material", "serviceFunction": "clearRecycle" }
550	✅教材详情	bookLessonEditor	selectBookList	sql		{ "table": "book", "operation": "select" }
554	✅查询列表	sectionList	selectBookGroupList	sql		{ "table": "view01_book_group", "operation": "select" }
555	✅教材列表-恢复数据	bookManagement	resumeItem	sql	{ "before": [], "after": [{"service": "book", "serviceFunction": "restoreBookMaterialDir"}
] }	{ "table": "book", "operation": "jhUpdate" }
556	✅备课-创建教材章节素材目录	bookLessonEditor	addSetionMaterialDir	service		{ "service": "section", "serviceFunction": "addSetionMaterialDir" }

_resource语句

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (22, NULL, NULL, 'cloud_drive', 'getUserCloudDriveList', '✅云盘-获取用户云盘', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getUserCloudDriveList" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (23, NULL, NULL, 'cloud_drive', 'saveMarkdown', '✅云盘-保存markdown文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "saveMarkdown" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (24, NULL, NULL, 'cloud_drive', 'moveFile', '✅云盘-移动文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "moveFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (25, NULL, NULL, 'cloud_drive', 'copyFile', '✅云盘-复制文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "copyFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (26, NULL, NULL, 'cloud_drive', 'getDirItemList', '✅云盘-文件列表', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getDirItemList" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (27, NULL, NULL, 'cloud_drive', 'deleteDirOrFile', '✅云盘-删除文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "deleteDirOrFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (28, NULL, NULL, 'cloud_drive', 'getMarkdownContent', '✅云盘-获取markdown内容', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getMarkdownContent" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (29, NULL, NULL, 'cloud_drive', 'renameFile', '✅云盘- 重命名文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "renameFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (30, NULL, NULL, 'cloud_drive', 'mkdir', '✅云盘-创建文件目录', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "mkdir" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (31, NULL, NULL, 'cloud_drive', 'clearRecycle', '✅云盘-清空回收站', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "clearRecycle" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (101, NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (102, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (105, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (106, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (112, NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
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 (254, NULL, NULL, 'allPage', 'resetPassword', '✅修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', 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 (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 (497, NULL, NULL, 'codeViewManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "code_view", "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 (498, NULL, '{ "before": [
{"service": "codeView", "serviceFunction": "beforeCreateCodeId"}
]
}', 'codeViewManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "code_view", "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 (499, NULL, NULL, 'codeViewManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "code_view", "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 (500, NULL, NULL, 'codeViewManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "code_view", "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 (505, NULL, NULL, 'constantUiManagement', 'selectItemList', '✅constantUiManagement查询-查询列表', 'sql', '{}', '{"table": "web_constant_ui", "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 (506, NULL, NULL, 'constantUiManagement', 'insertItem', '✅constantUiManagement查询-添加成员', 'sql', '{}', '{"table": "web_constant_ui", "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 (507, NULL, NULL, 'constantUiManagement', 'updateItem', '✅constantUiManagement查询-更新成员', 'sql', '{}', '{"table": "web_constant_ui", "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 (508, NULL, NULL, 'constantUiManagement', 'deleteItem', '✅constantUiManagement查询-删除信息', 'sql', '{}', '{"table": "web_constant_ui", "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 (509, NULL, NULL, 'bookManagement', 'selectItemList', '✅教材列表-查询列表', 'sql', '{}', '{ "table": "view01_book", "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 (510, NULL, '{ "before": [
{"service": "book", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [{"service": "book", "serviceFunction": "addBookMaterialDir"}
] }', 'bookManagement', 'insertItem', '✅教材列表-添加数据', 'sql', '{}', '{ "table": "book", "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 (511, NULL, '{ "before": [
{"service": "book", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }', 'bookManagement', 'updateItem', '✅教材列表-更新数据', 'sql', '{}', '{ "table": "book", "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 (512, NULL, '{ "before": [], "after": [{"service": "book", "serviceFunction": "deleteBookMaterialDir"}
] }', 'bookManagement', 'deleteItem', '✅教材列表-删除数据', 'sql', '{}', '{ "table": "book", "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 (513, NULL, NULL, 'bookSectionProgress', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "book", "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 (514, NULL, NULL, 'bookSectionProgress', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "book", "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 (515, NULL, NULL, 'bookSectionProgress', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "book", "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 (516, NULL, NULL, 'bookSectionProgress', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "book", "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 (521, NULL, NULL, 'bookSectionManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "section", "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 (522, NULL, NULL, 'bookSectionManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "section", "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 (523, NULL, NULL, 'bookSectionManagement', 'updateItem', '✅更新', 'service', '{}', '{ "service": "section", "serviceFunction": "batchUpdate" }', 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 (524, NULL, NULL, 'bookSectionManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "section", "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 (525, NULL, NULL, 'bookSectionManagement', 'selectBookList', '✅教材列表', 'sql', NULL, '{ "table": "view01_book", "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 (527, NULL, NULL, 'sectionEdit', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{ "service": "material", "serviceFunction": "useMaterial" }', 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 (528, NULL, NULL, 'sectionEdit', 'selectBookList', '✅文章编辑-查询列表', 'sql', '{}', '{ "table": "view01_book", "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 (529, NULL, '{ "before": [
{"service": "section", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]}', 'sectionEdit', 'insertItem', '✅文章编辑-添加成员', 'sql', '{}', '{ "table": "section", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (530, NULL, NULL, 'sectionEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{ "table": "section", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (531, NULL, '{ "before": [
{"service": "section", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
]}', 'sectionEdit', 'updateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "section", "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 (532, NULL, NULL, 'sectionEdit', 'deleteItem', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "section", "serviceFunction": "delete" }', 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 (533, NULL, NULL, 'sectionEdit', 'restoreItem', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "section", "serviceFunction": "restore" }', 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 (535, NULL, NULL, 'sectionList', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_book_section_groupby", "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 (536, NULL, NULL, 'sectionList', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "section", "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 (537, NULL, NULL, 'sectionList', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "section", "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 (538, NULL, NULL, 'sectionList', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "section", "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 (539, NULL, NULL, 'bookLessonEditor', 'selectSectionList', '✅查询', 'sql', '{}', '{ "table": "view01_section", "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 (540, NULL, '', 'bookLessonEditor', 'selectLessonList', '✅查询', 'sql', '{}', '{ "table": "section_lesson", "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 (541, NULL, '{ "before": [
{"service": "lesson", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]}', 'bookLessonEditor', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "section_lesson", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (542, NULL, NULL, 'bookLessonEditor', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "section_lesson", "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 (543, NULL, NULL, 'sectionEdit', 'list', '✅xf编辑-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', 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 (544, NULL, NULL, 'sectionEdit', 'mkdir', '✅xf编辑-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', 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 (545, NULL, NULL, 'sectionEdit', 'moveFile', '✅xf编辑-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', 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 (546, NULL, NULL, 'sectionEdit', 'copyFile', '✅xf编辑-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', 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 (547, NULL, NULL, 'sectionEdit', 'renameFile', '✅xf编辑-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', 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 (548, NULL, NULL, 'sectionEdit', 'delete', '✅xf编辑-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', 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 (549, NULL, NULL, 'sectionEdit', 'clearRecycle', '✅xf编辑-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', 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 (550, NULL, NULL, 'bookLessonEditor', 'selectBookList', '✅教材详情', 'sql', NULL, '{ "table": "book", "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 (554, NULL, NULL, 'sectionList', 'selectBookGroupList', '✅查询列表', 'sql', '{}', '{ "table": "view01_book_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (555, NULL, '{ "before": [], "after": [{"service": "book", "serviceFunction": "restoreBookMaterialDir"}
] }', 'bookManagement', 'resumeItem', '✅教材列表-恢复数据', 'sql', '{}', '{ "table": "book", "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 (556, NULL, NULL, 'bookLessonEditor', 'addSetionMaterialDir', '✅备课-创建教材章节素材目录', 'service', '{}', '{ "service": "section", "serviceFunction": "addSetionMaterialDir" }', NULL, NULL, 'insert', NULL, NULL, NULL);

## 接口总览

## _resource结构

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

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 22 | ✅云盘-获取用户云盘 | cloud_drive | getUserCloudDriveList | service |  | { "service": "cloudDrive", "serviceFunction": "getUserCloudDriveList" } |
| 23 | ✅云盘-保存markdown文件 | cloud_drive | saveMarkdown | service |  | { "service": "cloudDrive", "serviceFunction": "saveMarkdown" } |
| 24 | ✅云盘-移动文件 | cloud_drive | moveFile | service |  | { "service": "cloudDrive", "serviceFunction": "moveFile" } |
| 25 | ✅云盘-复制文件 | cloud_drive | copyFile | service |  | { "service": "cloudDrive", "serviceFunction": "copyFile" } |
| 26 | ✅云盘-文件列表 | cloud_drive | getDirItemList | service |  | { "service": "cloudDrive", "serviceFunction": "getDirItemList" } |
| 27 | ✅云盘-删除文件 | cloud_drive | deleteDirOrFile | service |  | { "service": "cloudDrive", "serviceFunction": "deleteDirOrFile" } |
| 28 | ✅云盘-获取markdown内容 | cloud_drive | getMarkdownContent | service |  | { "service": "cloudDrive", "serviceFunction": "getMarkdownContent" } |
| 29 | ✅云盘- 重命名文件 | cloud_drive | renameFile | service |  | { "service": "cloudDrive", "serviceFunction": "renameFile" } |
| 30 | ✅云盘-创建文件目录 | cloud_drive | mkdir | service |  | { "service": "cloudDrive", "serviceFunction": "mkdir" } |
| 31 | ✅云盘-清空回收站 | cloud_drive | clearRecycle | service |  | { "service": "cloudDrive", "serviceFunction": "clearRecycle" } |
| 101 | ✅ 文件分片下载-获取分片信息 | allPage | getChunkInfo | service |  | { "service": "file", "serviceFunction": "getChunkInfo" } |
| 102 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service |  | { "service": "file", "serviceFunction": "uploadFileDone" } |
| 105 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service |  | { "service": "file", "serviceFunction": "uploadFileChunkByStream" } |
| 106 | ✅ 文件分片上传-http base64 | allPage | httpUploadByBase64 | service |  | { "service": "file", "serviceFunction": "uploadFileChunkByBase64" } |
| 112 | ✅ 文件分片下载-http base64 | allPage | httpDownloadByBase64 | service |  | { "service": "file", "serviceFunction": "downloadFileChunkByBase64" } |
| 231 | ✅登陆 | login | passwordLogin | service |  | { "service": "user", "serviceFunction": "passwordLogin" } |
| 251 | ✅登出 | allPage | logout | service |  | { "service": "user", "serviceFunction": "logout" } |
| 253 | ✅获取用户信息 | allPage | userInfo | service |  | { "service": "user", "serviceFunction": "userInfo" } |
| 254 | ✅修改用户密码 | allPage | resetPassword | service |  | { "service": "user", "serviceFunction": "resetPassword" } |
| 258 | ✅查询常量 | allPage | getConstantList | sql |  | { "table": "_constant", "operation": "select" } |
| 497 | ✅查询列表 | codeViewManagement | selectItemList | sql |  | { "table": "code_view", "operation": "select" } |
| 498 | ✅添加 | codeViewManagement | insertItem | sql | { "before": [
{"service": "codeView", "serviceFunction": "beforeCreateCodeId"}
]
} | { "table": "code_view", "operation": "insert" } |
| 499 | ✅更新 | codeViewManagement | updateItem | sql |  | { "table": "code_view", "operation": "jhUpdate" } |
| 500 | ✅删除 | codeViewManagement | deleteItem | sql |  | { "table": "code_view", "operation": "jhDelete" } |
| 505 | ✅constantUiManagement查询-查询列表 | constantUiManagement | selectItemList | sql |  | {"table": "web_constant_ui", "operation": "select"} |
| 506 | ✅constantUiManagement查询-添加成员 | constantUiManagement | insertItem | sql |  | {"table": "web_constant_ui", "operation": "insert"} |
| 507 | ✅constantUiManagement查询-更新成员 | constantUiManagement | updateItem | sql |  | {"table": "web_constant_ui", "operation": "jhUpdate"} |
| 508 | ✅constantUiManagement查询-删除信息 | constantUiManagement | deleteItem | sql |  | {"table": "web_constant_ui", "operation": "jhDelete"} |
| 509 | ✅教材列表-查询列表 | bookManagement | selectItemList | sql |  | { "table": "view01_book", "operation": "select" } |
| 510 | ✅教材列表-添加数据 | bookManagement | insertItem | sql | { "before": [
{"service": "book", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [{"service": "book", "serviceFunction": "addBookMaterialDir"}
] } | { "table": "book", "operation": "insert" } |
| 511 | ✅教材列表-更新数据 | bookManagement | updateItem | sql | { "before": [
{"service": "book", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] } | { "table": "book", "operation": "jhUpdate" } |
| 512 | ✅教材列表-删除数据 | bookManagement | deleteItem | sql | { "before": [], "after": [{"service": "book", "serviceFunction": "deleteBookMaterialDir"}
] } | { "table": "book", "operation": "jhUpdate" } |
| 513 | ✅查询列表 | bookSectionProgress | selectItemList | sql |  | { "table": "book", "operation": "select" } |
| 514 | ✅添加 | bookSectionProgress | insertItem | sql |  | { "table": "book", "operation": "insert" } |
| 515 | ✅更新 | bookSectionProgress | updateItem | sql |  | { "table": "book", "operation": "jhUpdate" } |
| 516 | ✅删除 | bookSectionProgress | deleteItem | sql |  | { "table": "book", "operation": "jhDelete" } |
| 521 | ✅查询列表 | bookSectionManagement | selectItemList | sql |  | { "table": "section", "operation": "select" } |
| 522 | ✅添加 | bookSectionManagement | insertItem | sql |  | { "table": "section", "operation": "insert" } |
| 523 | ✅更新 | bookSectionManagement | updateItem | service |  | { "service": "section", "serviceFunction": "batchUpdate" } |
| 524 | ✅删除 | bookSectionManagement | deleteItem | sql |  | { "table": "section", "operation": "jhDelete" } |
| 525 | ✅教材列表 | bookSectionManagement | selectBookList | sql |  | { "table": "view01_book", "operation": "select" } |
| 527 | ✅文章编辑-使用素材 | sectionEdit | useMaterial | service |  | { "service": "material", "serviceFunction": "useMaterial" } |
| 528 | ✅文章编辑-查询列表 | sectionEdit | selectBookList | sql |  | { "table": "view01_book", "operation": "select" } |
| 529 | ✅文章编辑-添加成员 | sectionEdit | insertItem | sql | { "before": [
{"service": "section", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]} | { "table": "section", "operation": "jhInsert" } |
| 530 | ✅文章编辑-查询文章列表 | sectionEdit | selectItemList | sql |  | { "table": "section", "operation": "select" } |
| 531 | ✅文章编辑-更新成员 | sectionEdit | updateItem | sql | { "before": [
{"service": "section", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
]} | { "table": "section", "operation": "jhUpdate" } |
| 532 | ✅文章编辑-将文章移至回收站 | sectionEdit | deleteItem | service |  | { "service": "section", "serviceFunction": "delete" } |
| 533 | ✅文章编辑-文章恢复 | sectionEdit | restoreItem | service |  | { "service": "section", "serviceFunction": "restore" } |
| 535 | ✅查询列表 | sectionList | selectItemList | sql |  | { "table": "view01_book_section_groupby", "operation": "select" } |
| 536 | ✅添加 | sectionList | insertItem | sql |  | { "table": "section", "operation": "insert" } |
| 537 | ✅更新 | sectionList | updateItem | sql |  | { "table": "section", "operation": "jhUpdate" } |
| 538 | ✅删除 | sectionList | deleteItem | sql |  | { "table": "section", "operation": "jhDelete" } |
| 539 | ✅查询 | bookLessonEditor | selectSectionList | sql |  | { "table": "view01_section", "operation": "select" } |
| 540 | ✅查询 | bookLessonEditor | selectLessonList | sql |  | { "table": "section_lesson", "operation": "select" } |
| 541 | ✅添加 | bookLessonEditor | insertItem | sql | { "before": [
{"service": "lesson", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]} | { "table": "section_lesson", "operation": "jhInsert" } |
| 542 | ✅更新 | bookLessonEditor | updateItem | sql |  | { "table": "section_lesson", "operation": "jhUpdate" } |
| 543 | ✅xf编辑-文件列表 | sectionEdit | list | service |  | { "service": "material", "serviceFunction": "list" } |
| 544 | ✅xf编辑-创建文件夹 | sectionEdit | mkdir | service |  | { "service": "material", "serviceFunction": "mkdir" } |
| 545 | ✅xf编辑-移动文件 | sectionEdit | moveFile | service |  | { "service": "material", "serviceFunction": "moveFile" } |
| 546 | ✅xf编辑-复制文件 | sectionEdit | copyFile | service |  | { "service": "material", "serviceFunction": "copyFile" } |
| 547 | ✅xf编辑-文件重命名 | sectionEdit | renameFile | service |  | { "service": "material", "serviceFunction": "renameFile" } |
| 548 | ✅xf编辑-删除 | sectionEdit | delete | service |  | { "service": "material", "serviceFunction": "delete" } |
| 549 | ✅xf编辑-清空回收站 | sectionEdit | clearRecycle | service |  | { "service": "material", "serviceFunction": "clearRecycle" } |
| 550 | ✅教材详情 | bookLessonEditor | selectBookList | sql |  | { "table": "book", "operation": "select" } |
| 554 | ✅查询列表 | sectionList | selectBookGroupList | sql |  | { "table": "view01_book_group", "operation": "select" } |
| 555 | ✅教材列表-恢复数据 | bookManagement | resumeItem | sql | { "before": [], "after": [{"service": "book", "serviceFunction": "restoreBookMaterialDir"}
] } | { "table": "book", "operation": "jhUpdate" } |
| 556 | ✅备课-创建教材章节素材目录 | bookLessonEditor | addSetionMaterialDir | service |  | { "service": "section", "serviceFunction": "addSetionMaterialDir" } |
## _resource语句

```sql
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (22, NULL, NULL, 'cloud_drive', 'getUserCloudDriveList', '✅云盘-获取用户云盘', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getUserCloudDriveList" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (23, NULL, NULL, 'cloud_drive', 'saveMarkdown', '✅云盘-保存markdown文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "saveMarkdown" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (24, NULL, NULL, 'cloud_drive', 'moveFile', '✅云盘-移动文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "moveFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (25, NULL, NULL, 'cloud_drive', 'copyFile', '✅云盘-复制文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "copyFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (26, NULL, NULL, 'cloud_drive', 'getDirItemList', '✅云盘-文件列表', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getDirItemList" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (27, NULL, NULL, 'cloud_drive', 'deleteDirOrFile', '✅云盘-删除文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "deleteDirOrFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (28, NULL, NULL, 'cloud_drive', 'getMarkdownContent', '✅云盘-获取markdown内容', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getMarkdownContent" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (29, NULL, NULL, 'cloud_drive', 'renameFile', '✅云盘- 重命名文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "renameFile" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (30, NULL, NULL, 'cloud_drive', 'mkdir', '✅云盘-创建文件目录', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "mkdir" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (31, NULL, NULL, 'cloud_drive', 'clearRecycle', '✅云盘-清空回收站', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "clearRecycle" }', NULL, NULL, 'insert', 'admin', '系统管理员', '2022-09-15T23:46:04+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (101, NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (102, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (105, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (106, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (112, NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
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 (254, NULL, NULL, 'allPage', 'resetPassword', '✅修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', 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 (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 (497, NULL, NULL, 'codeViewManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "code_view", "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 (498, NULL, '{ "before": [
{"service": "codeView", "serviceFunction": "beforeCreateCodeId"}
]
}', 'codeViewManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "code_view", "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 (499, NULL, NULL, 'codeViewManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "code_view", "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 (500, NULL, NULL, 'codeViewManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "code_view", "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 (505, NULL, NULL, 'constantUiManagement', 'selectItemList', '✅constantUiManagement查询-查询列表', 'sql', '{}', '{"table": "web_constant_ui", "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 (506, NULL, NULL, 'constantUiManagement', 'insertItem', '✅constantUiManagement查询-添加成员', 'sql', '{}', '{"table": "web_constant_ui", "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 (507, NULL, NULL, 'constantUiManagement', 'updateItem', '✅constantUiManagement查询-更新成员', 'sql', '{}', '{"table": "web_constant_ui", "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 (508, NULL, NULL, 'constantUiManagement', 'deleteItem', '✅constantUiManagement查询-删除信息', 'sql', '{}', '{"table": "web_constant_ui", "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 (509, NULL, NULL, 'bookManagement', 'selectItemList', '✅教材列表-查询列表', 'sql', '{}', '{ "table": "view01_book", "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 (510, NULL, '{ "before": [
{"service": "book", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [{"service": "book", "serviceFunction": "addBookMaterialDir"}
] }', 'bookManagement', 'insertItem', '✅教材列表-添加数据', 'sql', '{}', '{ "table": "book", "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 (511, NULL, '{ "before": [
{"service": "book", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }', 'bookManagement', 'updateItem', '✅教材列表-更新数据', 'sql', '{}', '{ "table": "book", "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 (512, NULL, '{ "before": [], "after": [{"service": "book", "serviceFunction": "deleteBookMaterialDir"}
] }', 'bookManagement', 'deleteItem', '✅教材列表-删除数据', 'sql', '{}', '{ "table": "book", "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 (513, NULL, NULL, 'bookSectionProgress', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "book", "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 (514, NULL, NULL, 'bookSectionProgress', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "book", "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 (515, NULL, NULL, 'bookSectionProgress', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "book", "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 (516, NULL, NULL, 'bookSectionProgress', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "book", "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 (521, NULL, NULL, 'bookSectionManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "section", "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 (522, NULL, NULL, 'bookSectionManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "section", "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 (523, NULL, NULL, 'bookSectionManagement', 'updateItem', '✅更新', 'service', '{}', '{ "service": "section", "serviceFunction": "batchUpdate" }', 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 (524, NULL, NULL, 'bookSectionManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "section", "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 (525, NULL, NULL, 'bookSectionManagement', 'selectBookList', '✅教材列表', 'sql', NULL, '{ "table": "view01_book", "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 (527, NULL, NULL, 'sectionEdit', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{ "service": "material", "serviceFunction": "useMaterial" }', 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 (528, NULL, NULL, 'sectionEdit', 'selectBookList', '✅文章编辑-查询列表', 'sql', '{}', '{ "table": "view01_book", "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 (529, NULL, '{ "before": [
{"service": "section", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]}', 'sectionEdit', 'insertItem', '✅文章编辑-添加成员', 'sql', '{}', '{ "table": "section", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (530, NULL, NULL, 'sectionEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{ "table": "section", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (531, NULL, '{ "before": [
{"service": "section", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
]}', 'sectionEdit', 'updateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "section", "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 (532, NULL, NULL, 'sectionEdit', 'deleteItem', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "section", "serviceFunction": "delete" }', 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 (533, NULL, NULL, 'sectionEdit', 'restoreItem', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "section", "serviceFunction": "restore" }', 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 (535, NULL, NULL, 'sectionList', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_book_section_groupby", "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 (536, NULL, NULL, 'sectionList', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "section", "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 (537, NULL, NULL, 'sectionList', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "section", "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 (538, NULL, NULL, 'sectionList', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "section", "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 (539, NULL, NULL, 'bookLessonEditor', 'selectSectionList', '✅查询', 'sql', '{}', '{ "table": "view01_section", "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 (540, NULL, '', 'bookLessonEditor', 'selectLessonList', '✅查询', 'sql', '{}', '{ "table": "section_lesson", "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 (541, NULL, '{ "before": [
{"service": "lesson", "serviceFunction": "fillInsertItemParamsBeforeHook"}
]}', 'bookLessonEditor', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "section_lesson", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (542, NULL, NULL, 'bookLessonEditor', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "section_lesson", "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 (543, NULL, NULL, 'sectionEdit', 'list', '✅xf编辑-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', 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 (544, NULL, NULL, 'sectionEdit', 'mkdir', '✅xf编辑-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', 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 (545, NULL, NULL, 'sectionEdit', 'moveFile', '✅xf编辑-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', 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 (546, NULL, NULL, 'sectionEdit', 'copyFile', '✅xf编辑-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', 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 (547, NULL, NULL, 'sectionEdit', 'renameFile', '✅xf编辑-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', 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 (548, NULL, NULL, 'sectionEdit', 'delete', '✅xf编辑-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', 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 (549, NULL, NULL, 'sectionEdit', 'clearRecycle', '✅xf编辑-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', 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 (550, NULL, NULL, 'bookLessonEditor', 'selectBookList', '✅教材详情', 'sql', NULL, '{ "table": "book", "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 (554, NULL, NULL, 'sectionList', 'selectBookGroupList', '✅查询列表', 'sql', '{}', '{ "table": "view01_book_group", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (555, NULL, '{ "before": [], "after": [{"service": "book", "serviceFunction": "restoreBookMaterialDir"}
] }', 'bookManagement', 'resumeItem', '✅教材列表-恢复数据', 'sql', '{}', '{ "table": "book", "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 (556, NULL, NULL, 'bookLessonEditor', 'addSetionMaterialDir', '✅备课-创建教材章节素材目录', 'service', '{}', '{ "service": "section", "serviceFunction": "addSetionMaterialDir" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```