接口

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 = 533 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" }
327	✅文章管理-查询列表	articleList	selectItemList	sql		{ "table": "view01_article", "operation": "select" }
331	✅文章管理-查询分类列表	articleList	selectCategoryList	sql		{ "table": "view01_category", "operation": "select" }
332	✅文章编辑-将文章移至回收站	articleList	deletedArticle	service		{ "service": "article", "serviceFunction": "deletedArticle" }
333	✅文章编辑-文章恢复	articleList	restoreArticle	service		{ "service": "article", "serviceFunction": "restoreArticle" }
345	✅分类管理-查询列表	categoryList	selectItemList	sql		{ "table": "view01_category", "operation": "select" }
346	✅分类管理-创建成员	categoryList	jhInsertItem	sql	{ "before": [
{"service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
] }	{ "table": "category", "operation": "jhInsert" }
347	✅分类管理-更新成员	categoryList	jhUpdateItem	sql	{ "before": [
{"service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }	{ "table": "category", "operation": "jhUpdate" }
354	✅用户管理-查询信息	userList	selectItemList	sql		{ "table": "_user", "operation": "select" }
355	✅用户管理-查询信息	userList	insertItem	service		{ "service": "userManagement", "serviceFunction": "addUser" }
356	✅用户管理-修改密码	userList	resetUserPassword	service		{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
357	✅用户管理-更新用户	userList	updateItem	sql		{ "table": "_user", "operation": "jhUpdate" }
381	✅文章编辑-查询文章详情	articleEdit	selectArticleInfo	service		{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }
382	✅文章编辑-导入素材	articleEdit	importMaterial	service		{ "service": "article", "serviceFunction": "importMaterial" }
383	✅文章编辑-查询列表	articleEdit	selectCategoryList	sql		{ "table": "view01_category", "operation": "select" }
385	✅文章编辑-添加成员	articleEdit	jhInsertItem	sql	{ "before": [
{"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [{"service": "article", "serviceFunction": "insertItemAfterHook"}]}	{ "table": "article", "operation": "jhInsert" }
386	✅文章编辑-查询文章列表	articleEdit	selectItemList	sql		{ "table": "article", "operation": "select" }
387	✅文章编辑-更新成员	articleEdit	jhUpdateItem	sql	{ "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [
] }	{ "table": "article", "operation": "jhUpdate" }
388	✅文章编辑-将文章移至回收站	articleEdit	deletedArticle	service		{ "service": "article", "serviceFunction": "deletedArticle" }
389	✅文章编辑-文章恢复	articleEdit	restoreArticle	service		{ "service": "article", "serviceFunction": "restoreArticle" }
411	✅文章历史版本管理-恢复版本	articleHistory	selectItemList	sql		{ "table": "article_history", "operation": "select" }
412	✅文章历史版本管理-恢复版本	articleHistory	jhUpdateArticleItem	service		{ "table": "article", "operation": "jhUpdate" }
476	✅文章编辑-查询带文集信息的文章	xfPageEdit	selectXfPageWithCategory	service		{"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"}
477	✅文章编辑-使用素材	xfPageEdit	importMaterial	service		{"service": "xfPage", "serviceFunction": "importMaterial"}
478	✅文章编辑-查询列表	xfPageEdit	selectCategoryList	sql		{"table": "view01_category", "operation": "select"}
479	✅文章编辑-添加成员	xfPageEdit	jhInsertItem	sql	{ "before": [
{"service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"},
{"service": "xfPage", "serviceFunction": "insertItemAfterHook"}
] }	{"table": "xf_page", "operation": "jhInsert"}
480	✅文章编辑-查询文章列表	xfPageEdit	selectItemList	sql		{"table": "xf_page", "operation": "select"}
481	✅文章编辑-更新成员	xfPageEdit	jhUpdateItem	sql	{ "before": [
{"service": "xfPage", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"}
] }	{"table": "xf_page", "operation": "jhUpdate"}
482	✅文章编辑-将文章移至回收站	xfPageEdit	deletedItem	service		{"service": "xfPage", "serviceFunction": "deletedXfPage"}
483	✅文章编辑-文章恢复	xfPageEdit	restoreItem	service		{"service": "xfPage", "serviceFunction": "restoreXfPage"}
487	✅xfPageManagement查询-查询列表	xfPageList	selectItemList	sql		{"table": "xf_page", "operation": "select"}
488	✅xfPageManagement查询-添加成员	xfPageList	insertItem	sql		{"table": "xf_page", "operation": "insert"}
489	✅xfPageManagement查询-更新成员	xfPageList	updateItem	sql		{"table": "xf_page", "operation": "jhUpdate"}
490	✅xfPageManagement查询-删除信息	xfPageList	deleteItem	sql		{"table": "xf_page", "operation": "jhDelete"}
491	✅xfPageHistoryManagement查询-查询列表	xfPageHistory	selectItemList	sql		{"table": "xf_page_history", "operation": "select"}
492	✅xfPageHistoryManagement查询-添加成员	xfPageHistory	insertItem	sql		{"table": "xf_page_history", "operation": "insert"}
493	✅xfPageHistoryManagement查询-更新成员	xfPageHistory	updateItem	sql		{"table": "xf_page_history", "operation": "jhUpdate"}
496	✅xfPageHistoryManagement查询-删除信息	xfPageHistory	deleteItem	sql		{"table": "xf_page_history", "operation": "jhDelete"}
505	✅constantUiManagement查询-查询列表	constantUiList	selectItemList	sql		{"table": "web_constant_ui", "operation": "select"}
506	✅constantUiManagement查询-添加成员	constantUiList	insertItem	sql		{"table": "web_constant_ui", "operation": "insert"}
507	✅constantUiManagement查询-更新成员	constantUiList	updateItem	sql		{"table": "web_constant_ui", "operation": "jhUpdate"}
508	✅constantUiManagement查询-删除信息	constantUiList	deleteItem	sql		{"table": "web_constant_ui", "operation": "jhDelete"}
529	✅查询列表	calendarManagement	selectItemList	sql		{ "table": "calendar", "operation": "select" }
530	✅添加	calendarManagement	insertItem	sql		{ "table": "calendar", "operation": "insert" }
531	✅更新	calendarManagement	updateItem	sql		{ "table": "calendar", "operation": "jhUpdate" }
532	✅删除	calendarManagement	deleteItem	sql		{ "table": "calendar", "operation": "jhDelete" }

_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 (327, NULL, NULL, 'articleList', 'selectItemList', '✅文章管理-查询列表', 'sql', '{}', '{ "table": "view01_article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (331, NULL, NULL, 'articleList', 'selectCategoryList', '✅文章管理-查询分类列表', 'sql', '{}', '{ "table": "view01_category", "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 (332, NULL, NULL, 'articleList', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (333, NULL, NULL, 'articleList', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (345, NULL, NULL, 'categoryList', 'selectItemList', '✅分类管理-查询列表', 'sql', '{}', '{ "table": "view01_category", "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 (346, NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
] }', 'categoryList', 'jhInsertItem', '✅分类管理-创建成员', 'sql', '{}', '{ "table": "category", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (347, NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }', 'categoryList', 'jhUpdateItem', '✅分类管理-更新成员', 'sql', '{}', '{ "table": "category", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (354, NULL, NULL, 'userList', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{ "table": "_user", "operation": "select" }', '{"appData":{"pageId":"userManagement","actionId":"selectItemList","actionData":{},"where":{},"orderBy":[{"column":"operationAt","order":"desc"}],"appId":"demo_advanced","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"},"packageId":"1650871878788_6841435","packageType":"httpRequest"}', '{"packageId":"1650871878788_6841435","packageType":"httpResponse","status":"success","timestamp":"2022-04-25T15:31:19+08:00","appData":{"rows":[{"id":1,"idSequence":null,"userId":"admin","username":"admin","clearTextPassword":"123456","password":"f0cc7a42ef0c399737c024202b1aaa3f","md5Salt":"9PMF7J7VPsUy","userStatus":"active","userType":"common","config":null,"operation":"jhUpdate","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T15:31:11+08:00","initPassword":null},{"id":68,"idSequence":"26260000","userId":"001","username":"小华","clearTextPassword":"1234567","password":"b9e96d6ebc84dd51f2bd1fb56a79d8cb","md5Salt":"ZsPkQcHpYZQT","userStatus":"active","userType":"common","config":null,"operation":"update","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T14:40:49+08:00","initPassword":null}],"resultData":{"rows":[{"id":1,"idSequence":null,"userId":"admin","username":"admin","clearTextPassword":"123456","password":"f0cc7a42ef0c399737c024202b1aaa3f","md5Salt":"9PMF7J7VPsUy","userStatus":"active","userType":"common","config":null,"operation":"jhUpdate","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T15:31:11+08:00","initPassword":null},{"id":68,"idSequence":"26260000","userId":"001","username":"小华","clearTextPassword":"1234567","password":"b9e96d6ebc84dd51f2bd1fb56a79d8cb","md5Salt":"ZsPkQcHpYZQT","userStatus":"active","userType":"common","config":null,"operation":"update","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T14:40:49+08:00","initPassword":null}]},"appId":"demo_advanced","pageId":"userManagement","actionId":"selectItemList"}}', 'update', NULL, NULL, '2022-04-25T15:31:19+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (355, NULL, NULL, 'userList', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "addUser" }', NULL, NULL, 'update', NULL, NULL, '2022-02-18T20:19:24+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (356, NULL, NULL, 'userList', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '{"appData":{"pageId":"userManagement","actionId":"resetUserPassword","actionData":{"userId":"001","clearTextPassword":"1234567"},"appId":"demo_advanced","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"},"packageId":"1650868849466_1403837","packageType":"httpRequest"}', '{"packageId":"1650868849466_1403837","packageType":"httpResponse","status":"success","timestamp":"2022-04-25T14:40:49+08:00","appData":{"appId":"demo_advanced","pageId":"userManagement","actionId":"resetUserPassword"}}', 'update', NULL, NULL, '2022-04-25T14:40:49+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (357, NULL, NULL, 'userList', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{ "table": "_user", "operation": "jhUpdate" }', '{"appData":{"pageId":"userManagement","actionId":"updateItem","actionData":{"idSequence":"26260000","username":"小华","clearTextPassword":"123456","password":"891f5a52508153b06adce61736863ad3","md5Salt":"FWhG88C2KSCz","userStatus":"active","userType":"common","config":null,"operation":"jhRestore","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-02-21T00:47:08+08:00","initPassword":null},"where":{"id":68},"appId":"demo_advanced","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"},"packageId":"1650868688492_7978792","packageType":"httpRequest"}', '{"packageId":"1650868688492_7978792","packageType":"httpResponse","status":"success","timestamp":"2022-04-25T14:38:08+08:00","appData":{"rows":1,"appId":"demo_advanced","pageId":"userManagement","actionId":"updateItem"}}', 'update', NULL, NULL, '2022-04-25T14:38:08+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, NULL, 'articleEdit', 'selectArticleInfo', '✅文章编辑-查询文章详情', 'service', '{}', '{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'articleEdit', 'importMaterial', '✅文章编辑-导入素材', 'service', '{}', '{ "service": "article", "serviceFunction": "importMaterial" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, NULL, 'articleEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{ "table": "view01_category", "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 (385, NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [{"service": "article", "serviceFunction": "insertItemAfterHook"}]}', 'articleEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{ "table": "article", "operation": "jhInsert" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (386, NULL, NULL, 'articleEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{ "table": "article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (387, NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [
] }', 'articleEdit', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (388, NULL, '', 'articleEdit', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (389, NULL, NULL, 'articleEdit', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (411, NULL, NULL, 'articleHistory', 'selectItemList', '✅文章历史版本管理-恢复版本', 'sql', '{}', '{ "table": "article_history", "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 (412, NULL, NULL, 'articleHistory', 'jhUpdateArticleItem', '✅文章历史版本管理-恢复版本', 'service', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (476, NULL, NULL, 'xfPageEdit', 'selectXfPageWithCategory', '✅文章编辑-查询带文集信息的文章', 'service', '{}', '{"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (477, NULL, NULL, 'xfPageEdit', 'importMaterial', '✅文章编辑-使用素材', 'service', '{}', '{"service": "xfPage", "serviceFunction": "importMaterial"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (478, NULL, NULL, 'xfPageEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{"table": "view01_category", "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 (479, NULL, '{ "before": [
{"service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"},
{"service": "xfPage", "serviceFunction": "insertItemAfterHook"}
] }', 'xfPageEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhInsert"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (480, NULL, NULL, 'xfPageEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (481, NULL, '{ "before": [
{"service": "xfPage", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"}
] }', 'xfPageEdit', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (482, NULL, '', 'xfPageEdit', 'deletedItem', '✅文章编辑-将文章移至回收站', 'service', '{}', '{"service": "xfPage", "serviceFunction": "deletedXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (483, NULL, NULL, 'xfPageEdit', 'restoreItem', '✅文章编辑-文章恢复', 'service', '{}', '{"service": "xfPage", "serviceFunction": "restoreXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (487, NULL, NULL, 'xfPageList', 'selectItemList', '✅xfPageManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (488, NULL, NULL, 'xfPageList', 'insertItem', '✅xfPageManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "insert"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (489, NULL, NULL, 'xfPageList', 'updateItem', '✅xfPageManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhUpdate"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (490, NULL, NULL, 'xfPageList', 'deleteItem', '✅xfPageManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page", "operation": "jhDelete"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (491, NULL, NULL, 'xfPageHistory', 'selectItemList', '✅xfPageHistoryManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page_history", "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 (492, NULL, NULL, 'xfPageHistory', 'insertItem', '✅xfPageHistoryManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "insert"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (493, NULL, NULL, 'xfPageHistory', 'updateItem', '✅xfPageHistoryManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (496, NULL, NULL, 'xfPageHistory', 'deleteItem', '✅xfPageHistoryManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhDelete"}', '', '', '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, 'constantUiList', '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, 'constantUiList', '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, 'constantUiList', '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, 'constantUiList', '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 (529, NULL, NULL, 'calendarManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "calendar", "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 (530, NULL, NULL, 'calendarManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "calendar", "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 (531, NULL, NULL, 'calendarManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "calendar", "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, 'calendarManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "calendar", "operation": "jhDelete" }', 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 = 533 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" } |
| 327 | ✅文章管理-查询列表 | articleList | selectItemList | sql |  | { "table": "view01_article", "operation": "select" } |
| 331 | ✅文章管理-查询分类列表 | articleList | selectCategoryList | sql |  | { "table": "view01_category", "operation": "select" } |
| 332 | ✅文章编辑-将文章移至回收站 | articleList | deletedArticle | service |  | { "service": "article", "serviceFunction": "deletedArticle" } |
| 333 | ✅文章编辑-文章恢复 | articleList | restoreArticle | service |  | { "service": "article", "serviceFunction": "restoreArticle" } |
| 345 | ✅分类管理-查询列表 | categoryList | selectItemList | sql |  | { "table": "view01_category", "operation": "select" } |
| 346 | ✅分类管理-创建成员 | categoryList | jhInsertItem | sql | { "before": [
{"service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
] } | { "table": "category", "operation": "jhInsert" } |
| 347 | ✅分类管理-更新成员 | categoryList | jhUpdateItem | sql | { "before": [
{"service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] } | { "table": "category", "operation": "jhUpdate" } |
| 354 | ✅用户管理-查询信息 | userList | selectItemList | sql |  | { "table": "_user", "operation": "select" } |
| 355 | ✅用户管理-查询信息 | userList | insertItem | service |  | { "service": "userManagement", "serviceFunction": "addUser" } |
| 356 | ✅用户管理-修改密码 | userList | resetUserPassword | service |  | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |
| 357 | ✅用户管理-更新用户 | userList | updateItem | sql |  | { "table": "_user", "operation": "jhUpdate" } |
| 381 | ✅文章编辑-查询文章详情 | articleEdit | selectArticleInfo | service |  | { "service": "article", "serviceFunction": "getArticleAndFillArticles" } |
| 382 | ✅文章编辑-导入素材 | articleEdit | importMaterial | service |  | { "service": "article", "serviceFunction": "importMaterial" } |
| 383 | ✅文章编辑-查询列表 | articleEdit | selectCategoryList | sql |  | { "table": "view01_category", "operation": "select" } |
| 385 | ✅文章编辑-添加成员 | articleEdit | jhInsertItem | sql | { "before": [
{"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [{"service": "article", "serviceFunction": "insertItemAfterHook"}]} | { "table": "article", "operation": "jhInsert" } |
| 386 | ✅文章编辑-查询文章列表 | articleEdit | selectItemList | sql |  | { "table": "article", "operation": "select" } |
| 387 | ✅文章编辑-更新成员 | articleEdit | jhUpdateItem | sql | { "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [
] } | { "table": "article", "operation": "jhUpdate" } |
| 388 | ✅文章编辑-将文章移至回收站 | articleEdit | deletedArticle | service |  | { "service": "article", "serviceFunction": "deletedArticle" } |
| 389 | ✅文章编辑-文章恢复 | articleEdit | restoreArticle | service |  | { "service": "article", "serviceFunction": "restoreArticle" } |
| 411 | ✅文章历史版本管理-恢复版本 | articleHistory | selectItemList | sql |  | { "table": "article_history", "operation": "select" } |
| 412 | ✅文章历史版本管理-恢复版本 | articleHistory | jhUpdateArticleItem | service |  | { "table": "article", "operation": "jhUpdate" } |
| 476 | ✅文章编辑-查询带文集信息的文章 | xfPageEdit | selectXfPageWithCategory | service |  | {"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"} |
| 477 | ✅文章编辑-使用素材 | xfPageEdit | importMaterial | service |  | {"service": "xfPage", "serviceFunction": "importMaterial"} |
| 478 | ✅文章编辑-查询列表 | xfPageEdit | selectCategoryList | sql |  | {"table": "view01_category", "operation": "select"} |
| 479 | ✅文章编辑-添加成员 | xfPageEdit | jhInsertItem | sql | { "before": [
{"service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"},
{"service": "xfPage", "serviceFunction": "insertItemAfterHook"}
] } | {"table": "xf_page", "operation": "jhInsert"} |
| 480 | ✅文章编辑-查询文章列表 | xfPageEdit | selectItemList | sql |  | {"table": "xf_page", "operation": "select"} |
| 481 | ✅文章编辑-更新成员 | xfPageEdit | jhUpdateItem | sql | { "before": [
{"service": "xfPage", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"}
] } | {"table": "xf_page", "operation": "jhUpdate"} |
| 482 | ✅文章编辑-将文章移至回收站 | xfPageEdit | deletedItem | service |  | {"service": "xfPage", "serviceFunction": "deletedXfPage"} |
| 483 | ✅文章编辑-文章恢复 | xfPageEdit | restoreItem | service |  | {"service": "xfPage", "serviceFunction": "restoreXfPage"} |
| 487 | ✅xfPageManagement查询-查询列表 | xfPageList | selectItemList | sql |  | {"table": "xf_page", "operation": "select"} |
| 488 | ✅xfPageManagement查询-添加成员 | xfPageList | insertItem | sql |  | {"table": "xf_page", "operation": "insert"} |
| 489 | ✅xfPageManagement查询-更新成员 | xfPageList | updateItem | sql |  | {"table": "xf_page", "operation": "jhUpdate"} |
| 490 | ✅xfPageManagement查询-删除信息 | xfPageList | deleteItem | sql |  | {"table": "xf_page", "operation": "jhDelete"} |
| 491 | ✅xfPageHistoryManagement查询-查询列表 | xfPageHistory | selectItemList | sql |  | {"table": "xf_page_history", "operation": "select"} |
| 492 | ✅xfPageHistoryManagement查询-添加成员 | xfPageHistory | insertItem | sql |  | {"table": "xf_page_history", "operation": "insert"} |
| 493 | ✅xfPageHistoryManagement查询-更新成员 | xfPageHistory | updateItem | sql |  | {"table": "xf_page_history", "operation": "jhUpdate"} |
| 496 | ✅xfPageHistoryManagement查询-删除信息 | xfPageHistory | deleteItem | sql |  | {"table": "xf_page_history", "operation": "jhDelete"} |
| 505 | ✅constantUiManagement查询-查询列表 | constantUiList | selectItemList | sql |  | {"table": "web_constant_ui", "operation": "select"} |
| 506 | ✅constantUiManagement查询-添加成员 | constantUiList | insertItem | sql |  | {"table": "web_constant_ui", "operation": "insert"} |
| 507 | ✅constantUiManagement查询-更新成员 | constantUiList | updateItem | sql |  | {"table": "web_constant_ui", "operation": "jhUpdate"} |
| 508 | ✅constantUiManagement查询-删除信息 | constantUiList | deleteItem | sql |  | {"table": "web_constant_ui", "operation": "jhDelete"} |
| 529 | ✅查询列表 | calendarManagement | selectItemList | sql |  | { "table": "calendar", "operation": "select" } |
| 530 | ✅添加 | calendarManagement | insertItem | sql |  | { "table": "calendar", "operation": "insert" } |
| 531 | ✅更新 | calendarManagement | updateItem | sql |  | { "table": "calendar", "operation": "jhUpdate" } |
| 532 | ✅删除 | calendarManagement | deleteItem | sql |  | { "table": "calendar", "operation": "jhDelete" } |
## _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 (327, NULL, NULL, 'articleList', 'selectItemList', '✅文章管理-查询列表', 'sql', '{}', '{ "table": "view01_article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (331, NULL, NULL, 'articleList', 'selectCategoryList', '✅文章管理-查询分类列表', 'sql', '{}', '{ "table": "view01_category", "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 (332, NULL, NULL, 'articleList', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (333, NULL, NULL, 'articleList', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (345, NULL, NULL, 'categoryList', 'selectItemList', '✅分类管理-查询列表', 'sql', '{}', '{ "table": "view01_category", "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 (346, NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
] }', 'categoryList', 'jhInsertItem', '✅分类管理-创建成员', 'sql', '{}', '{ "table": "category", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (347, NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }', 'categoryList', 'jhUpdateItem', '✅分类管理-更新成员', 'sql', '{}', '{ "table": "category", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (354, NULL, NULL, 'userList', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{ "table": "_user", "operation": "select" }', '{"appData":{"pageId":"userManagement","actionId":"selectItemList","actionData":{},"where":{},"orderBy":[{"column":"operationAt","order":"desc"}],"appId":"demo_advanced","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"},"packageId":"1650871878788_6841435","packageType":"httpRequest"}', '{"packageId":"1650871878788_6841435","packageType":"httpResponse","status":"success","timestamp":"2022-04-25T15:31:19+08:00","appData":{"rows":[{"id":1,"idSequence":null,"userId":"admin","username":"admin","clearTextPassword":"123456","password":"f0cc7a42ef0c399737c024202b1aaa3f","md5Salt":"9PMF7J7VPsUy","userStatus":"active","userType":"common","config":null,"operation":"jhUpdate","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T15:31:11+08:00","initPassword":null},{"id":68,"idSequence":"26260000","userId":"001","username":"小华","clearTextPassword":"1234567","password":"b9e96d6ebc84dd51f2bd1fb56a79d8cb","md5Salt":"ZsPkQcHpYZQT","userStatus":"active","userType":"common","config":null,"operation":"update","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T14:40:49+08:00","initPassword":null}],"resultData":{"rows":[{"id":1,"idSequence":null,"userId":"admin","username":"admin","clearTextPassword":"123456","password":"f0cc7a42ef0c399737c024202b1aaa3f","md5Salt":"9PMF7J7VPsUy","userStatus":"active","userType":"common","config":null,"operation":"jhUpdate","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T15:31:11+08:00","initPassword":null},{"id":68,"idSequence":"26260000","userId":"001","username":"小华","clearTextPassword":"1234567","password":"b9e96d6ebc84dd51f2bd1fb56a79d8cb","md5Salt":"ZsPkQcHpYZQT","userStatus":"active","userType":"common","config":null,"operation":"update","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-04-25T14:40:49+08:00","initPassword":null}]},"appId":"demo_advanced","pageId":"userManagement","actionId":"selectItemList"}}', 'update', NULL, NULL, '2022-04-25T15:31:19+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (355, NULL, NULL, 'userList', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "addUser" }', NULL, NULL, 'update', NULL, NULL, '2022-02-18T20:19:24+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (356, NULL, NULL, 'userList', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '{"appData":{"pageId":"userManagement","actionId":"resetUserPassword","actionData":{"userId":"001","clearTextPassword":"1234567"},"appId":"demo_advanced","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"},"packageId":"1650868849466_1403837","packageType":"httpRequest"}', '{"packageId":"1650868849466_1403837","packageType":"httpResponse","status":"success","timestamp":"2022-04-25T14:40:49+08:00","appData":{"appId":"demo_advanced","pageId":"userManagement","actionId":"resetUserPassword"}}', 'update', NULL, NULL, '2022-04-25T14:40:49+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (357, NULL, NULL, 'userList', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{ "table": "_user", "operation": "jhUpdate" }', '{"appData":{"pageId":"userManagement","actionId":"updateItem","actionData":{"idSequence":"26260000","username":"小华","clearTextPassword":"123456","password":"891f5a52508153b06adce61736863ad3","md5Salt":"FWhG88C2KSCz","userStatus":"active","userType":"common","config":null,"operation":"jhRestore","operationByUserId":"admin","operationByUser":"admin","operationAt":"2022-02-21T00:47:08+08:00","initPassword":null},"where":{"id":68},"appId":"demo_advanced","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36"},"packageId":"1650868688492_7978792","packageType":"httpRequest"}', '{"packageId":"1650868688492_7978792","packageType":"httpResponse","status":"success","timestamp":"2022-04-25T14:38:08+08:00","appData":{"rows":1,"appId":"demo_advanced","pageId":"userManagement","actionId":"updateItem"}}', 'update', NULL, NULL, '2022-04-25T14:38:08+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, NULL, 'articleEdit', 'selectArticleInfo', '✅文章编辑-查询文章详情', 'service', '{}', '{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'articleEdit', 'importMaterial', '✅文章编辑-导入素材', 'service', '{}', '{ "service": "article", "serviceFunction": "importMaterial" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, NULL, 'articleEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{ "table": "view01_category", "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 (385, NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [{"service": "article", "serviceFunction": "insertItemAfterHook"}]}', 'articleEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{ "table": "article", "operation": "jhInsert" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (386, NULL, NULL, 'articleEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{ "table": "article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (387, NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"},
{"service": "articleParser", "serviceFunction": "parseJhTags"}
], "after": [
] }', 'articleEdit', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (388, NULL, '', 'articleEdit', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (389, NULL, NULL, 'articleEdit', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (411, NULL, NULL, 'articleHistory', 'selectItemList', '✅文章历史版本管理-恢复版本', 'sql', '{}', '{ "table": "article_history", "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 (412, NULL, NULL, 'articleHistory', 'jhUpdateArticleItem', '✅文章历史版本管理-恢复版本', 'service', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (476, NULL, NULL, 'xfPageEdit', 'selectXfPageWithCategory', '✅文章编辑-查询带文集信息的文章', 'service', '{}', '{"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (477, NULL, NULL, 'xfPageEdit', 'importMaterial', '✅文章编辑-使用素材', 'service', '{}', '{"service": "xfPage", "serviceFunction": "importMaterial"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (478, NULL, NULL, 'xfPageEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{"table": "view01_category", "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 (479, NULL, '{ "before": [
{"service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"},
{"service": "xfPage", "serviceFunction": "insertItemAfterHook"}
] }', 'xfPageEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhInsert"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (480, NULL, NULL, 'xfPageEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (481, NULL, '{ "before": [
{"service": "xfPage", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"}
] }', 'xfPageEdit', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (482, NULL, '', 'xfPageEdit', 'deletedItem', '✅文章编辑-将文章移至回收站', 'service', '{}', '{"service": "xfPage", "serviceFunction": "deletedXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (483, NULL, NULL, 'xfPageEdit', 'restoreItem', '✅文章编辑-文章恢复', 'service', '{}', '{"service": "xfPage", "serviceFunction": "restoreXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (487, NULL, NULL, 'xfPageList', 'selectItemList', '✅xfPageManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (488, NULL, NULL, 'xfPageList', 'insertItem', '✅xfPageManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "insert"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (489, NULL, NULL, 'xfPageList', 'updateItem', '✅xfPageManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhUpdate"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (490, NULL, NULL, 'xfPageList', 'deleteItem', '✅xfPageManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page", "operation": "jhDelete"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (491, NULL, NULL, 'xfPageHistory', 'selectItemList', '✅xfPageHistoryManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page_history", "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 (492, NULL, NULL, 'xfPageHistory', 'insertItem', '✅xfPageHistoryManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "insert"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (493, NULL, NULL, 'xfPageHistory', 'updateItem', '✅xfPageHistoryManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (496, NULL, NULL, 'xfPageHistory', 'deleteItem', '✅xfPageHistoryManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhDelete"}', '', '', '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, 'constantUiList', '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, 'constantUiList', '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, 'constantUiList', '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, 'constantUiList', '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 (529, NULL, NULL, 'calendarManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "calendar", "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 (530, NULL, NULL, 'calendarManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "calendar", "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 (531, NULL, NULL, 'calendarManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "calendar", "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, 'calendarManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "calendar", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```