接口

12086

接口总览

_resource结构

CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jhId` varchar(255) DEFAULT NULL,
  `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 = 92 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
1	✅登陆	login	passwordLogin	service	null	{ "service": "user", "serviceFunction": "passwordLogin" }
2	✅登出	allPage	logout	service	null	{ "service": "user", "serviceFunction": "logout" }
3	✅获取用户信息	allPage	userInfo	service	null	{ "service": "user", "serviceFunction": "userInfo" }
4	✅修改用户密码	allPage	resetPassword	service	null	{ "service": "user", "serviceFunction": "resetPassword" }
5	✅查询常量	allPage	getConstantList	sql	null	{ "table": "_constant", "operation": "select" }
6	✅分类管理-查询列表	home	selectCategoryList	sql	null	{ "table": "view01_category", "operation": "select" }
7	✅用户管理-查询信息	userManagement	selectItemList	sql	null	{ "table": "_user", "operation": "select" }
8	✅用户管理-查询信息	userManagement	insertItem	service	null	{ "service": "userManagement", "serviceFunction": "addUser" }
9	✅用户管理-修改密码	userManagement	resetUserPassword	service	null	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
10	✅用户管理-更新用户	userManagement	updateItem	sql	null	{ "table": "_user", "operation": "jhUpdate" }
11	✅文章页面	article	addComment	sql	null	{ "table": "comment", "operation": "jhInsert" }
12	✅ 文件分片下载-获取分片信息	allPage	getChunkInfo	service	null	{ "service": "file", "serviceFunction": "getChunkInfo" }
13	✅ 文件分片上传-所有分片上传完毕	allPage	uploadFileDone	service	null	{ "service": "file", "serviceFunction": "uploadFileDone" }
14	✅ 文件分片上传-http文件流	allPage	httpUploadByStream	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }
15	✅ 文件分片上传-http base64	allPage	httpUploadByBase64	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
16	✅ 文件分片下载-http base64	allPage	httpDownloadByBase64	service	null	{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
17	✅登陆	login	passwordLogin	service	null	{ "service": "user", "serviceFunction": "passwordLogin" }
18	✅登出	allPage	logout	service	null	{ "service": "user", "serviceFunction": "logout" }
19	✅获取用户信息	allPage	userInfo	service	null	{ "service": "user", "serviceFunction": "userInfo" }
20	✅修改用户密码	allPage	resetPassword	service	null	{ "service": "user", "serviceFunction": "resetPassword" }
21	✅查询常量	allPage	getConstantList	sql	null	{ "table": "_constant", "operation": "select" }
22	✅文章管理-查询列表(不包含内容)	articleManagement	selectItemList	sql	null	{ "table": "view01_article", "operation": "select" }
23	✅文章编辑-更新成员	articleManagement	jhUpdateItem	sql	{ "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	{ "table": "article", "operation": "jhUpdate" }
24	✅文章管理-查询分类列表	articleManagement	selectCategoryList	sql	null	{ "table": "view01_category", "operation": "select" }
25	✅文章编辑-将文章移至回收站	articleManagement	deletedArticle	service	null	{ "service": "article", "serviceFunction": "deletedArticle" }
26	✅文章编辑-文章恢复	articleManagement	restoreArticle	service	null	{ "service": "article", "serviceFunction": "restoreArticle" }
27	✅分类管理-查询列表	categoryManagement	selectItemList	sql	null	{ "table": "view01_category", "operation": "select" }
28	✅分类管理-创建成员	categoryManagement	jhInsertItem	sql	{ "before": [ { "service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [] }	{ "table": "category", "operation": "jhInsert" }
29	✅分类管理-更新成员	categoryManagement	jhUpdateItem	sql	{ "before": [ { "service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [] }	{ "table": "category", "operation": "jhUpdate" }
30	✅用户管理-查询信息	userManagement	selectItemList	sql	null	{ "table": "_user", "operation": "select" }
31	✅用户管理-查询信息	userManagement	insertItem	service	null	{ "service": "userManagement", "serviceFunction": "addUser" }
32	✅用户管理-修改密码	userManagement	resetUserPassword	service	null	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
33	✅用户管理-更新用户	userManagement	updateItem	sql	null	{ "table": "_user", "operation": "jhUpdate" }
34	✅精选集管理-查询列表	albumManagement	selectItemList	sql	null	{ "table": "album", "operation": "select" }
35	✅精选集管理-添加成员	albumManagement	insertItem	sql	{ "before": [ { "service": "album", "serviceFunction": "albumIdGenerateBeforeHook" } ], "after": [] }	{ "table": "album", "operation": "insert" }
36	✅精选集管理-更新成员	albumManagement	updateItem	sql	null	{ "table": "album", "operation": "jhUpdate" }
37	✅精选集管理-删除信息	albumManagement	deleteItem	sql	null	{ "table": "album", "operation": "jhDelete" }
38	✅精选集管理-查询专辑文章列表	albumManagement	viewAlbumArticleList	service	null	{ "service": "album", "serviceFunction": "viewAlbumArticleList" }
39	✅文章编辑-查询带文集信息的文章	articleEdit	selectArticleWithCategory	service	null	{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }
40	✅文章编辑-使用素材	articleEdit	useMaterial	service	null	{ "service": "material", "serviceFunction": "useMaterial" }
41	✅文章编辑-查询列表	articleEdit	selectCategoryList	sql	null	{ "table": "view01_category", "operation": "select" }
42	✅文章编辑-添加成员	articleEdit	jhInsertItem	sql	{ "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	{ "table": "article", "operation": "jhInsert" }
43	✅文章编辑-查询文章列表	articleEdit	selectItemList	sql	null	{ "table": "article", "operation": "select" }
44	✅文章编辑-更新成员	articleEdit	jhUpdateItem	sql	{ "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	{ "table": "article", "operation": "jhUpdate" }
45	✅文章编辑-将文章移至回收站	articleEdit	deletedArticle	service		{ "service": "article", "serviceFunction": "deletedArticle" }
46	✅文章编辑-文章恢复	articleEdit	restoreArticle	service	null	{ "service": "article", "serviceFunction": "restoreArticle" }
47	✅文章编辑-代码块列表	articleEdit	selectCodeList	sql	null	{ "table": "code_view", "operation": "select" }
48	✅修改codeview	articleEdit	updateCodeItem	sql	null	{ "table": "code_view", "operation": "jhUpdate" }
49					null	null
50	✅素材管理-文件列表	materialManagement	list	service	null	{ "service": "material", "serviceFunction": "list" }
51	✅素材管理-创建文件夹	materialManagement	mkdir	service	null	{ "service": "material", "serviceFunction": "mkdir" }
52	✅素材管理-删除	materialManagement	delete	service	null	{ "service": "material", "serviceFunction": "delete" }
53	✅素材管理-清空回收站	materialManagement	clearRecycle	service	null	{ "service": "material", "serviceFunction": "clearRecycle" }
54	✅素材管理-文件重命名	materialManagement	renameFile	service	null	{ "service": "material", "serviceFunction": "renameFile" }
55	✅文章历史版本管理-恢复版本	articleHistoryManagement	selectItemList	sql	null	{ "table": "article_history", "operation": "select" }
56	✅文章历史版本管理-恢复版本	articleHistoryManagement	jhUpdateArticleItem	service	null	{ "table": "article", "operation": "jhUpdate" }
57	✅素材管理-移动文件	materialManagement	moveFile	service	null	{ "service": "material", "serviceFunction": "moveFile" }
58	✅素材管理-复制文件	materialManagement	copyFile	service	null	{ "service": "material", "serviceFunction": "copyFile" }
59	✅更新文章作业	assignmentDesign	updateArticleAssignment	sql	null	{ "table": "article", "operation": "jhUpdate" }
60	✅查询文章作业	assignmentDesign	selectArticleAssignment	sql	null	{ "table": "article", "operation": "select" }
61	✅文章编辑-查询带文集信息的文章	xfPageEdit	selectXfPageWithCategory	service	null	{ "service": "xfPage", "serviceFunction": "getXfPageAndFillArticles" }
62	✅文章编辑-使用素材	xfPageEdit	useMaterial	service	null	{ "service": "material", "serviceFunction": "xfPageMaterial" }
63	✅文章编辑-查询列表	xfPageEdit	selectCategoryList	sql	null	{ "table": "view01_category", "operation": "select" }
64	✅文章编辑-添加成员	xfPageEdit	jhInsertItem	sql	{ "before": [ { "service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook" } ] }	{ "table": "xf_page", "operation": "jhInsert" }
65	✅文章编辑-查询文章列表	xfPageEdit	selectItemList	sql	null	{ "table": "xf_page", "operation": "select" }
66	✅文章编辑-更新成员	xfPageEdit	jhUpdateItem	sql	{ "before": [ { "service": "xfPage", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook" } ] }	{ "table": "xf_page", "operation": "jhUpdate" }
67	✅文章编辑-将文章移至回收站	xfPageEdit	deletedItem	service		{ "service": "xfPage", "serviceFunction": "deletedXfPage" }
68	✅文章编辑-文章恢复	xfPageEdit	restoreItem	service	null	{ "service": "xfPage", "serviceFunction": "restoreXfPage" }
69	✅xfPageManagement查询-查询列表	xfPageManagement	selectItemList	sql	null	{ "table": "xf_page", "operation": "select" }
70	✅xfPageManagement查询-添加成员	xfPageManagement	insertItem	sql	null	{ "table": "xf_page", "operation": "insert" }
71	✅xfPageManagement查询-更新成员	xfPageManagement	updateItem	sql	null	{ "table": "xf_page", "operation": "jhUpdate" }
72	✅xfPageManagement查询-删除信息	xfPageManagement	deleteItem	sql	null	{ "table": "xf_page", "operation": "jhDelete" }
73	✅xfPageHistoryManagement查询-查询列表	xfPageHistoryManagement	selectItemList	sql	null	{ "table": "xf_page_history", "operation": "select" }
74	✅xfPageHistoryManagement查询-添加成员	xfPageHistoryManagement	insertItem	sql	null	{ "table": "xf_page_history", "operation": "insert" }
75	✅xfPageHistoryManagement查询-更新成员	xfPageHistoryManagement	updateItem	sql	null	{ "table": "xf_page_history", "operation": "jhUpdate" }
76	✅xfPageHistoryManagement查询-删除信息	xfPageHistoryManagement	deleteItem	sql	null	{ "table": "xf_page_history", "operation": "jhDelete" }
77	✅查询列表	codeViewManagement	selectItemList	sql	null	{ "table": "code_view", "operation": "select" }
78	✅添加	codeViewManagement	insertItem	sql	{ "before": [ { "service": "codeView", "serviceFunction": "beforeCreateCodeId" } ] }	{ "table": "code_view", "operation": "insert" }
79	✅更新	codeViewManagement	updateItem	sql	null	{ "table": "code_view", "operation": "jhUpdate" }
80	✅删除	codeViewManagement	deleteItem	sql	null	{ "table": "code_view", "operation": "jhDelete" }
81	✅constantUiManagement查询-查询列表	constantUiManagement	selectItemList	sql	null	{ "table": "seo_ui", "operation": "select" }
82	✅constantUiManagement查询-添加成员	constantUiManagement	insertItem	sql	null	{ "table": "seo_ui", "operation": "insert" }
83	✅constantUiManagement查询-更新成员	constantUiManagement	updateItem	sql	null	{ "table": "seo_ui", "operation": "jhUpdate" }
84	✅constantUiManagement查询-删除信息	constantUiManagement	deleteItem	sql	null	{ "table": "seo_ui", "operation": "jhDelete" }
85	✅xf编辑-文件列表	articleEdit	list	service	null	{ "service": "material", "serviceFunction": "list" }
86	✅xf编辑-创建文件夹	articleEdit	mkdir	service	null	{ "service": "material", "serviceFunction": "mkdir" }
87	✅xf编辑-移动文件	articleEdit	moveFile	service	null	{ "service": "material", "serviceFunction": "moveFile" }
88	✅xf编辑-复制文件	articleEdit	copyFile	service	null	{ "service": "material", "serviceFunction": "copyFile" }
89	✅xf编辑-文件重命名	articleEdit	renameFile	service	null	{ "service": "material", "serviceFunction": "renameFile" }
90	✅xf编辑-删除	articleEdit	delete	service	null	{ "service": "material", "serviceFunction": "delete" }
91	✅xf编辑-清空回收站	articleEdit	clearRecycle	service	null	{ "service": "material", "serviceFunction": "clearRecycle" }

_resource语句

INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'seo', NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'seo', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'seo', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'seo', NULL, NULL, 'allPage', 'resetPassword', '✅修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'seo', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'seo', NULL, NULL, 'home', 'selectCategoryList', '✅分类管理-查询列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'seo', NULL, NULL, 'userManagement', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{ "table": "_user", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-04-25T15:31:19+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'seo', NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "addUser" }', '', '', 'update', NULL, NULL, '2022-02-18T20:19:24+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'seo', NULL, NULL, 'userManagement', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '', '', 'update', NULL, NULL, '2022-04-25T14:40:49+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'seo', NULL, NULL, 'userManagement', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{ "table": "_user", "operation": "jhUpdate" }', '', '', 'update', NULL, NULL, '2022-04-25T14:38:08+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'seo', NULL, NULL, 'article', 'addComment', '✅文章页面', 'sql', '{}', '{ "table": "comment", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'admin', NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'admin', NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'admin', NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'admin', 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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'admin', 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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'admin', NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'admin', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'admin', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'admin', NULL, NULL, 'allPage', 'resetPassword', '✅修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'admin', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'admin', NULL, NULL, 'articleManagement', 'selectItemList', '✅文章管理-查询列表(不包含内容)', 'sql', '{}', '{ "table": "view01_article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'admin', NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
] }', 'articleManagement', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'admin', NULL, NULL, 'articleManagement', 'selectCategoryList', '✅文章管理-查询分类列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'admin', NULL, NULL, 'articleManagement', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'admin', NULL, NULL, 'articleManagement', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'admin', NULL, NULL, 'categoryManagement', 'selectItemList', '✅分类管理-查询列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'admin', NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
] }', 'categoryManagement', 'jhInsertItem', '✅分类管理-创建成员', 'sql', '{}', '{ "table": "category", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'admin', NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }', 'categoryManagement', 'jhUpdateItem', '✅分类管理-更新成员', 'sql', '{}', '{ "table": "category", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'admin', NULL, NULL, 'userManagement', '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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'admin', NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "addUser" }', NULL, NULL, 'update', NULL, NULL, '2022-02-18T20:19:24+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'admin', NULL, NULL, 'userManagement', '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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (33, 'admin', NULL, NULL, 'userManagement', '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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 'admin', NULL, NULL, 'albumManagement', 'selectItemList', '✅精选集管理-查询列表', 'sql', '{}', '{ "table": "album", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 'admin', NULL, '{ "before": [{"service": "album", "serviceFunction": "albumIdGenerateBeforeHook"}], "after": [] }', 'albumManagement', 'insertItem', '✅精选集管理-添加成员', 'sql', '{}', '{ "table": "album", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'admin', NULL, NULL, 'albumManagement', 'updateItem', '✅精选集管理-更新成员', 'sql', '{}', '{ "table": "album", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'admin', NULL, NULL, 'albumManagement', 'deleteItem', '✅精选集管理-删除信息', 'sql', '{}', '{ "table": "album", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'admin', NULL, NULL, 'albumManagement', 'viewAlbumArticleList', '✅精选集管理-查询专辑文章列表', 'service', '{}', '{ "service": "album", "serviceFunction": "viewAlbumArticleList" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'admin', NULL, NULL, 'articleEdit', 'selectArticleWithCategory', '✅文章编辑-查询带文集信息的文章', 'service', '{}', '{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'admin', NULL, NULL, 'articleEdit', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{ "service": "material", "serviceFunction": "useMaterial" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'admin', NULL, NULL, 'articleEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'admin', NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
] }', 'articleEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{ "table": "article", "operation": "jhInsert" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (43, 'admin', NULL, NULL, 'articleEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{ "table": "article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (44, 'admin', NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
] }', 'articleEdit', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'admin', NULL, '', 'articleEdit', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'admin', NULL, NULL, 'articleEdit', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (47, 'admin', NULL, NULL, 'articleEdit', 'selectCodeList', '✅文章编辑-代码块列表', 'sql', NULL, '{ "table": "code_view", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (48, 'admin', NULL, NULL, 'articleEdit', 'updateCodeItem', '✅修改codeview', 'sql', NULL, '{ "table": "code_view", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'admin', NULL, NULL, 'materialManagement', 'list', '✅素材管理-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'admin', NULL, NULL, 'materialManagement', 'mkdir', '✅素材管理-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'admin', NULL, NULL, 'materialManagement', 'delete', '✅素材管理-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (53, 'admin', NULL, NULL, 'materialManagement', 'clearRecycle', '✅素材管理-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'admin', NULL, NULL, 'materialManagement', 'renameFile', '✅素材管理-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'admin', NULL, NULL, 'articleHistoryManagement', 'selectItemList', '✅文章历史版本管理-恢复版本', 'sql', '{}', '{ "table": "article_history", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'admin', NULL, NULL, 'articleHistoryManagement', 'jhUpdateArticleItem', '✅文章历史版本管理-恢复版本', 'service', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'admin', NULL, NULL, 'materialManagement', 'moveFile', '✅素材管理-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'admin', NULL, NULL, 'materialManagement', 'copyFile', '✅素材管理-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'admin', NULL, NULL, 'assignmentDesign', 'updateArticleAssignment', '✅更新文章作业', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'admin', NULL, NULL, 'assignmentDesign', 'selectArticleAssignment', '✅查询文章作业', 'sql', '{}', '{ "table": "article", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'admin', NULL, NULL, 'xfPageEdit', 'selectXfPageWithCategory', '✅文章编辑-查询带文集信息的文章', 'service', '{}', '{"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'admin', NULL, NULL, 'xfPageEdit', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{"service": "material", "serviceFunction": "xfPageMaterial"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (63, 'admin', NULL, NULL, 'xfPageEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{"table": "view01_category", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (64, 'admin', NULL, '{ "before": [
{"service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"}
] }', 'xfPageEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhInsert"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (65, 'admin', NULL, NULL, 'xfPageEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'admin', 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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'admin', NULL, '', 'xfPageEdit', 'deletedItem', '✅文章编辑-将文章移至回收站', 'service', '{}', '{"service": "xfPage", "serviceFunction": "deletedXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (68, 'admin', NULL, NULL, 'xfPageEdit', 'restoreItem', '✅文章编辑-文章恢复', 'service', '{}', '{"service": "xfPage", "serviceFunction": "restoreXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (69, 'admin', NULL, NULL, 'xfPageManagement', 'selectItemList', '✅xfPageManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'admin', NULL, NULL, 'xfPageManagement', 'insertItem', '✅xfPageManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "insert"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'admin', NULL, NULL, 'xfPageManagement', 'updateItem', '✅xfPageManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhUpdate"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'admin', NULL, NULL, 'xfPageManagement', 'deleteItem', '✅xfPageManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page", "operation": "jhDelete"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (73, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'selectItemList', '✅xfPageHistoryManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page_history", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'insertItem', '✅xfPageHistoryManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "insert"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (75, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'updateItem', '✅xfPageHistoryManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (76, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'deleteItem', '✅xfPageHistoryManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhDelete"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (77, 'admin', NULL, NULL, 'codeViewManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "code_view", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (78, 'admin', NULL, '{ "before": [
{"service": "codeView", "serviceFunction": "beforeCreateCodeId"}
]
}', 'codeViewManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "code_view", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (79, 'admin', NULL, NULL, 'codeViewManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "code_view", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (80, 'admin', NULL, NULL, 'codeViewManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "code_view", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (81, 'admin', NULL, NULL, 'constantUiManagement', 'selectItemList', '✅constantUiManagement查询-查询列表', 'sql', '{}', '{"table": "seo_ui", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (82, 'admin', NULL, NULL, 'constantUiManagement', 'insertItem', '✅constantUiManagement查询-添加成员', 'sql', '{}', '{"table": "seo_ui", "operation": "insert"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'admin', NULL, NULL, 'constantUiManagement', 'updateItem', '✅constantUiManagement查询-更新成员', 'sql', '{}', '{"table": "seo_ui", "operation": "jhUpdate"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (84, 'admin', NULL, NULL, 'constantUiManagement', 'deleteItem', '✅constantUiManagement查询-删除信息', 'sql', '{}', '{"table": "seo_ui", "operation": "jhDelete"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (85, 'admin', NULL, NULL, 'articleEdit', 'list', '✅xf编辑-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (86, 'admin', NULL, NULL, 'articleEdit', 'mkdir', '✅xf编辑-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (87, 'admin', NULL, NULL, 'articleEdit', 'moveFile', '✅xf编辑-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (88, 'admin', NULL, NULL, 'articleEdit', 'copyFile', '✅xf编辑-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (89, 'admin', NULL, NULL, 'articleEdit', 'renameFile', '✅xf编辑-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (90, 'admin', NULL, NULL, 'articleEdit', 'delete', '✅xf编辑-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (91, 'admin', NULL, NULL, 'articleEdit', 'clearRecycle', '✅xf编辑-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', NULL, NULL, 'insert', NULL, NULL, NULL);

## 接口总览

## _resource结构

```sql
CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jhId` varchar(255) DEFAULT NULL,
  `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 = 92 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
```

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | ✅登陆 | login | passwordLogin | service | null | {   "service": "user",   "serviceFunction": "passwordLogin" } |
| 2 | ✅登出 | allPage | logout | service | null | {   "service": "user",   "serviceFunction": "logout" } |
| 3 | ✅获取用户信息 | allPage | userInfo | service | null | {   "service": "user",   "serviceFunction": "userInfo" } |
| 4 | ✅修改用户密码 | allPage | resetPassword | service | null | {   "service": "user",   "serviceFunction": "resetPassword" } |
| 5 | ✅查询常量 | allPage | getConstantList | sql | null | {   "table": "_constant",   "operation": "select" } |
| 6 | ✅分类管理-查询列表 | home | selectCategoryList | sql | null | {   "table": "view01_category",   "operation": "select" } |
| 7 | ✅用户管理-查询信息 | userManagement | selectItemList | sql | null | {   "table": "_user",   "operation": "select" } |
| 8 | ✅用户管理-查询信息 | userManagement | insertItem | service | null | {   "service": "userManagement",   "serviceFunction": "addUser" } |
| 9 | ✅用户管理-修改密码 | userManagement | resetUserPassword | service | null | {   "service": "userManagement",   "serviceFunction": "resetUserPassword" } |
| 10 | ✅用户管理-更新用户 | userManagement | updateItem | sql | null | {   "table": "_user",   "operation": "jhUpdate" } |
| 11 | ✅文章页面 | article | addComment | sql | null | {   "table": "comment",   "operation": "jhInsert" } |
| 12 | ✅ 文件分片下载-获取分片信息 | allPage | getChunkInfo | service | null | {   "service": "file",   "serviceFunction": "getChunkInfo" } |
| 13 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service | null | {   "service": "file",   "serviceFunction": "uploadFileDone" } |
| 14 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByStream" } |
| 15 | ✅ 文件分片上传-http base64 | allPage | httpUploadByBase64 | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByBase64" } |
| 16 | ✅ 文件分片下载-http base64 | allPage | httpDownloadByBase64 | service | null | {   "service": "file",   "serviceFunction": "downloadFileChunkByBase64" } |
| 17 | ✅登陆 | login | passwordLogin | service | null | {   "service": "user",   "serviceFunction": "passwordLogin" } |
| 18 | ✅登出 | allPage | logout | service | null | {   "service": "user",   "serviceFunction": "logout" } |
| 19 | ✅获取用户信息 | allPage | userInfo | service | null | {   "service": "user",   "serviceFunction": "userInfo" } |
| 20 | ✅修改用户密码 | allPage | resetPassword | service | null | {   "service": "user",   "serviceFunction": "resetPassword" } |
| 21 | ✅查询常量 | allPage | getConstantList | sql | null | {   "table": "_constant",   "operation": "select" } |
| 22 | ✅文章管理-查询列表(不包含内容) | articleManagement | selectItemList | sql | null | {   "table": "view01_article",   "operation": "select" } |
| 23 | ✅文章编辑-更新成员 | articleManagement | jhUpdateItem | sql | {   "before": [     {       "service": "article",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [     {       "service": "article",       "serviceFunction": "articleHistoryRecordAfterHook"     }   ] } | {   "table": "article",   "operation": "jhUpdate" } |
| 24 | ✅文章管理-查询分类列表 | articleManagement | selectCategoryList | sql | null | {   "table": "view01_category",   "operation": "select" } |
| 25 | ✅文章编辑-将文章移至回收站 | articleManagement | deletedArticle | service | null | {   "service": "article",   "serviceFunction": "deletedArticle" } |
| 26 | ✅文章编辑-文章恢复 | articleManagement | restoreArticle | service | null | {   "service": "article",   "serviceFunction": "restoreArticle" } |
| 27 | ✅分类管理-查询列表 | categoryManagement | selectItemList | sql | null | {   "table": "view01_category",   "operation": "select" } |
| 28 | ✅分类管理-创建成员 | categoryManagement | jhInsertItem | sql | {   "before": [     {       "service": "category",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [] } | {   "table": "category",   "operation": "jhInsert" } |
| 29 | ✅分类管理-更新成员 | categoryManagement | jhUpdateItem | sql | {   "before": [     {       "service": "category",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [] } | {   "table": "category",   "operation": "jhUpdate" } |
| 30 | ✅用户管理-查询信息 | userManagement | selectItemList | sql | null | {   "table": "_user",   "operation": "select" } |
| 31 | ✅用户管理-查询信息 | userManagement | insertItem | service | null | {   "service": "userManagement",   "serviceFunction": "addUser" } |
| 32 | ✅用户管理-修改密码 | userManagement | resetUserPassword | service | null | {   "service": "userManagement",   "serviceFunction": "resetUserPassword" } |
| 33 | ✅用户管理-更新用户 | userManagement | updateItem | sql | null | {   "table": "_user",   "operation": "jhUpdate" } |
| 34 | ✅精选集管理-查询列表 | albumManagement | selectItemList | sql | null | {   "table": "album",   "operation": "select" } |
| 35 | ✅精选集管理-添加成员 | albumManagement | insertItem | sql | {   "before": [     {       "service": "album",       "serviceFunction": "albumIdGenerateBeforeHook"     }   ],   "after": [] } | {   "table": "album",   "operation": "insert" } |
| 36 | ✅精选集管理-更新成员 | albumManagement | updateItem | sql | null | {   "table": "album",   "operation": "jhUpdate" } |
| 37 | ✅精选集管理-删除信息 | albumManagement | deleteItem | sql | null | {   "table": "album",   "operation": "jhDelete" } |
| 38 | ✅精选集管理-查询专辑文章列表 | albumManagement | viewAlbumArticleList | service | null | {   "service": "album",   "serviceFunction": "viewAlbumArticleList" } |
| 39 | ✅文章编辑-查询带文集信息的文章 | articleEdit | selectArticleWithCategory | service | null | {   "service": "article",   "serviceFunction": "getArticleAndFillArticles" } |
| 40 | ✅文章编辑-使用素材 | articleEdit | useMaterial | service | null | {   "service": "material",   "serviceFunction": "useMaterial" } |
| 41 | ✅文章编辑-查询列表 | articleEdit | selectCategoryList | sql | null | {   "table": "view01_category",   "operation": "select" } |
| 42 | ✅文章编辑-添加成员 | articleEdit | jhInsertItem | sql | {   "before": [     {       "service": "article",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [     {       "service": "article",       "serviceFunction": "articleHistoryRecordAfterHook"     }   ] } | {   "table": "article",   "operation": "jhInsert" } |
| 43 | ✅文章编辑-查询文章列表 | articleEdit | selectItemList | sql | null | {   "table": "article",   "operation": "select" } |
| 44 | ✅文章编辑-更新成员 | articleEdit | jhUpdateItem | sql | {   "before": [     {       "service": "article",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [     {       "service": "article",       "serviceFunction": "articleHistoryRecordAfterHook"     }   ] } | {   "table": "article",   "operation": "jhUpdate" } |
| 45 | ✅文章编辑-将文章移至回收站 | articleEdit | deletedArticle | service |  | {   "service": "article",   "serviceFunction": "deletedArticle" } |
| 46 | ✅文章编辑-文章恢复 | articleEdit | restoreArticle | service | null | {   "service": "article",   "serviceFunction": "restoreArticle" } |
| 47 | ✅文章编辑-代码块列表 | articleEdit | selectCodeList | sql | null | {   "table": "code_view",   "operation": "select" } |
| 48 | ✅修改codeview | articleEdit | updateCodeItem | sql | null | {   "table": "code_view",   "operation": "jhUpdate" } |
| 49 |  |  |  |  | null | null |
| 50 | ✅素材管理-文件列表 | materialManagement | list | service | null | {   "service": "material",   "serviceFunction": "list" } |
| 51 | ✅素材管理-创建文件夹 | materialManagement | mkdir | service | null | {   "service": "material",   "serviceFunction": "mkdir" } |
| 52 | ✅素材管理-删除 | materialManagement | delete | service | null | {   "service": "material",   "serviceFunction": "delete" } |
| 53 | ✅素材管理-清空回收站 | materialManagement | clearRecycle | service | null | {   "service": "material",   "serviceFunction": "clearRecycle" } |
| 54 | ✅素材管理-文件重命名 | materialManagement | renameFile | service | null | {   "service": "material",   "serviceFunction": "renameFile" } |
| 55 | ✅文章历史版本管理-恢复版本 | articleHistoryManagement | selectItemList | sql | null | {   "table": "article_history",   "operation": "select" } |
| 56 | ✅文章历史版本管理-恢复版本 | articleHistoryManagement | jhUpdateArticleItem | service | null | {   "table": "article",   "operation": "jhUpdate" } |
| 57 | ✅素材管理-移动文件 | materialManagement | moveFile | service | null | {   "service": "material",   "serviceFunction": "moveFile" } |
| 58 | ✅素材管理-复制文件 | materialManagement | copyFile | service | null | {   "service": "material",   "serviceFunction": "copyFile" } |
| 59 | ✅更新文章作业 | assignmentDesign | updateArticleAssignment | sql | null | {   "table": "article",   "operation": "jhUpdate" } |
| 60 | ✅查询文章作业 | assignmentDesign | selectArticleAssignment | sql | null | {   "table": "article",   "operation": "select" } |
| 61 | ✅文章编辑-查询带文集信息的文章 | xfPageEdit | selectXfPageWithCategory | service | null | {   "service": "xfPage",   "serviceFunction": "getXfPageAndFillArticles" } |
| 62 | ✅文章编辑-使用素材 | xfPageEdit | useMaterial | service | null | {   "service": "material",   "serviceFunction": "xfPageMaterial" } |
| 63 | ✅文章编辑-查询列表 | xfPageEdit | selectCategoryList | sql | null | {   "table": "view01_category",   "operation": "select" } |
| 64 | ✅文章编辑-添加成员 | xfPageEdit | jhInsertItem | sql | {   "before": [     {       "service": "xfPage",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [     {       "service": "xfPage",       "serviceFunction": "xfPageHistoryRecordAfterHook"     }   ] } | {   "table": "xf_page",   "operation": "jhInsert" } |
| 65 | ✅文章编辑-查询文章列表 | xfPageEdit | selectItemList | sql | null | {   "table": "xf_page",   "operation": "select" } |
| 66 | ✅文章编辑-更新成员 | xfPageEdit | jhUpdateItem | sql | {   "before": [     {       "service": "xfPage",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [     {       "service": "xfPage",       "serviceFunction": "xfPageHistoryRecordAfterHook"     }   ] } | {   "table": "xf_page",   "operation": "jhUpdate" } |
| 67 | ✅文章编辑-将文章移至回收站 | xfPageEdit | deletedItem | service |  | {   "service": "xfPage",   "serviceFunction": "deletedXfPage" } |
| 68 | ✅文章编辑-文章恢复 | xfPageEdit | restoreItem | service | null | {   "service": "xfPage",   "serviceFunction": "restoreXfPage" } |
| 69 | ✅xfPageManagement查询-查询列表 | xfPageManagement | selectItemList | sql | null | {   "table": "xf_page",   "operation": "select" } |
| 70 | ✅xfPageManagement查询-添加成员 | xfPageManagement | insertItem | sql | null | {   "table": "xf_page",   "operation": "insert" } |
| 71 | ✅xfPageManagement查询-更新成员 | xfPageManagement | updateItem | sql | null | {   "table": "xf_page",   "operation": "jhUpdate" } |
| 72 | ✅xfPageManagement查询-删除信息 | xfPageManagement | deleteItem | sql | null | {   "table": "xf_page",   "operation": "jhDelete" } |
| 73 | ✅xfPageHistoryManagement查询-查询列表 | xfPageHistoryManagement | selectItemList | sql | null | {   "table": "xf_page_history",   "operation": "select" } |
| 74 | ✅xfPageHistoryManagement查询-添加成员 | xfPageHistoryManagement | insertItem | sql | null | {   "table": "xf_page_history",   "operation": "insert" } |
| 75 | ✅xfPageHistoryManagement查询-更新成员 | xfPageHistoryManagement | updateItem | sql | null | {   "table": "xf_page_history",   "operation": "jhUpdate" } |
| 76 | ✅xfPageHistoryManagement查询-删除信息 | xfPageHistoryManagement | deleteItem | sql | null | {   "table": "xf_page_history",   "operation": "jhDelete" } |
| 77 | ✅查询列表 | codeViewManagement | selectItemList | sql | null | {   "table": "code_view",   "operation": "select" } |
| 78 | ✅添加 | codeViewManagement | insertItem | sql | {   "before": [     {       "service": "codeView",       "serviceFunction": "beforeCreateCodeId"     }   ] } | {   "table": "code_view",   "operation": "insert" } |
| 79 | ✅更新 | codeViewManagement | updateItem | sql | null | {   "table": "code_view",   "operation": "jhUpdate" } |
| 80 | ✅删除 | codeViewManagement | deleteItem | sql | null | {   "table": "code_view",   "operation": "jhDelete" } |
| 81 | ✅constantUiManagement查询-查询列表 | constantUiManagement | selectItemList | sql | null | {   "table": "seo_ui",   "operation": "select" } |
| 82 | ✅constantUiManagement查询-添加成员 | constantUiManagement | insertItem | sql | null | {   "table": "seo_ui",   "operation": "insert" } |
| 83 | ✅constantUiManagement查询-更新成员 | constantUiManagement | updateItem | sql | null | {   "table": "seo_ui",   "operation": "jhUpdate" } |
| 84 | ✅constantUiManagement查询-删除信息 | constantUiManagement | deleteItem | sql | null | {   "table": "seo_ui",   "operation": "jhDelete" } |
| 85 | ✅xf编辑-文件列表 | articleEdit | list | service | null | {   "service": "material",   "serviceFunction": "list" } |
| 86 | ✅xf编辑-创建文件夹 | articleEdit | mkdir | service | null | {   "service": "material",   "serviceFunction": "mkdir" } |
| 87 | ✅xf编辑-移动文件 | articleEdit | moveFile | service | null | {   "service": "material",   "serviceFunction": "moveFile" } |
| 88 | ✅xf编辑-复制文件 | articleEdit | copyFile | service | null | {   "service": "material",   "serviceFunction": "copyFile" } |
| 89 | ✅xf编辑-文件重命名 | articleEdit | renameFile | service | null | {   "service": "material",   "serviceFunction": "renameFile" } |
| 90 | ✅xf编辑-删除 | articleEdit | delete | service | null | {   "service": "material",   "serviceFunction": "delete" } |
| 91 | ✅xf编辑-清空回收站 | articleEdit | clearRecycle | service | null | {   "service": "material",   "serviceFunction": "clearRecycle" } |
## _resource语句

```sql
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'seo', NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'seo', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'seo', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'seo', NULL, NULL, 'allPage', 'resetPassword', '✅修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'seo', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'seo', NULL, NULL, 'home', 'selectCategoryList', '✅分类管理-查询列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'seo', NULL, NULL, 'userManagement', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{ "table": "_user", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-04-25T15:31:19+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'seo', NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "addUser" }', '', '', 'update', NULL, NULL, '2022-02-18T20:19:24+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'seo', NULL, NULL, 'userManagement', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '', '', 'update', NULL, NULL, '2022-04-25T14:40:49+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'seo', NULL, NULL, 'userManagement', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{ "table": "_user", "operation": "jhUpdate" }', '', '', 'update', NULL, NULL, '2022-04-25T14:38:08+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'seo', NULL, NULL, 'article', 'addComment', '✅文章页面', 'sql', '{}', '{ "table": "comment", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'admin', NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'admin', NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'admin', NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'admin', 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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'admin', 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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'admin', NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'admin', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'admin', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'admin', NULL, NULL, 'allPage', 'resetPassword', '✅修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'admin', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'admin', NULL, NULL, 'articleManagement', 'selectItemList', '✅文章管理-查询列表(不包含内容)', 'sql', '{}', '{ "table": "view01_article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'admin', NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
] }', 'articleManagement', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'admin', NULL, NULL, 'articleManagement', 'selectCategoryList', '✅文章管理-查询分类列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'admin', NULL, NULL, 'articleManagement', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'admin', NULL, NULL, 'articleManagement', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'admin', NULL, NULL, 'categoryManagement', 'selectItemList', '✅分类管理-查询列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'admin', NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
] }', 'categoryManagement', 'jhInsertItem', '✅分类管理-创建成员', 'sql', '{}', '{ "table": "category", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'admin', NULL, '{ "before": [
{"service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
] }', 'categoryManagement', 'jhUpdateItem', '✅分类管理-更新成员', 'sql', '{}', '{ "table": "category", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'admin', NULL, NULL, 'userManagement', '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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'admin', NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{ "service": "userManagement", "serviceFunction": "addUser" }', NULL, NULL, 'update', NULL, NULL, '2022-02-18T20:19:24+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'admin', NULL, NULL, 'userManagement', '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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (33, 'admin', NULL, NULL, 'userManagement', '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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 'admin', NULL, NULL, 'albumManagement', 'selectItemList', '✅精选集管理-查询列表', 'sql', '{}', '{ "table": "album", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 'admin', NULL, '{ "before": [{"service": "album", "serviceFunction": "albumIdGenerateBeforeHook"}], "after": [] }', 'albumManagement', 'insertItem', '✅精选集管理-添加成员', 'sql', '{}', '{ "table": "album", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'admin', NULL, NULL, 'albumManagement', 'updateItem', '✅精选集管理-更新成员', 'sql', '{}', '{ "table": "album", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'admin', NULL, NULL, 'albumManagement', 'deleteItem', '✅精选集管理-删除信息', 'sql', '{}', '{ "table": "album", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'admin', NULL, NULL, 'albumManagement', 'viewAlbumArticleList', '✅精选集管理-查询专辑文章列表', 'service', '{}', '{ "service": "album", "serviceFunction": "viewAlbumArticleList" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'admin', NULL, NULL, 'articleEdit', 'selectArticleWithCategory', '✅文章编辑-查询带文集信息的文章', 'service', '{}', '{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'admin', NULL, NULL, 'articleEdit', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{ "service": "material", "serviceFunction": "useMaterial" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'admin', NULL, NULL, 'articleEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'admin', NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
] }', 'articleEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{ "table": "article", "operation": "jhInsert" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (43, 'admin', NULL, NULL, 'articleEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{ "table": "article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (44, 'admin', NULL, '{ "before": [
{"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
], "after": [
{"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
] }', 'articleEdit', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'admin', NULL, '', 'articleEdit', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'admin', NULL, NULL, 'articleEdit', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (47, 'admin', NULL, NULL, 'articleEdit', 'selectCodeList', '✅文章编辑-代码块列表', 'sql', NULL, '{ "table": "code_view", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (48, 'admin', NULL, NULL, 'articleEdit', 'updateCodeItem', '✅修改codeview', 'sql', NULL, '{ "table": "code_view", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'admin', NULL, NULL, 'materialManagement', 'list', '✅素材管理-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'admin', NULL, NULL, 'materialManagement', 'mkdir', '✅素材管理-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'admin', NULL, NULL, 'materialManagement', 'delete', '✅素材管理-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (53, 'admin', NULL, NULL, 'materialManagement', 'clearRecycle', '✅素材管理-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'admin', NULL, NULL, 'materialManagement', 'renameFile', '✅素材管理-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'admin', NULL, NULL, 'articleHistoryManagement', 'selectItemList', '✅文章历史版本管理-恢复版本', 'sql', '{}', '{ "table": "article_history", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'admin', NULL, NULL, 'articleHistoryManagement', 'jhUpdateArticleItem', '✅文章历史版本管理-恢复版本', 'service', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'admin', NULL, NULL, 'materialManagement', 'moveFile', '✅素材管理-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'admin', NULL, NULL, 'materialManagement', 'copyFile', '✅素材管理-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'admin', NULL, NULL, 'assignmentDesign', 'updateArticleAssignment', '✅更新文章作业', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'admin', NULL, NULL, 'assignmentDesign', 'selectArticleAssignment', '✅查询文章作业', 'sql', '{}', '{ "table": "article", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'admin', NULL, NULL, 'xfPageEdit', 'selectXfPageWithCategory', '✅文章编辑-查询带文集信息的文章', 'service', '{}', '{"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'admin', NULL, NULL, 'xfPageEdit', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{"service": "material", "serviceFunction": "xfPageMaterial"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (63, 'admin', NULL, NULL, 'xfPageEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{"table": "view01_category", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (64, 'admin', NULL, '{ "before": [
{"service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook"}
], "after": [
{"service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook"}
] }', 'xfPageEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhInsert"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (65, 'admin', NULL, NULL, 'xfPageEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'admin', 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, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'admin', NULL, '', 'xfPageEdit', 'deletedItem', '✅文章编辑-将文章移至回收站', 'service', '{}', '{"service": "xfPage", "serviceFunction": "deletedXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (68, 'admin', NULL, NULL, 'xfPageEdit', 'restoreItem', '✅文章编辑-文章恢复', 'service', '{}', '{"service": "xfPage", "serviceFunction": "restoreXfPage"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (69, 'admin', NULL, NULL, 'xfPageManagement', 'selectItemList', '✅xfPageManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page", "operation": "select"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'admin', NULL, NULL, 'xfPageManagement', 'insertItem', '✅xfPageManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page", "operation": "insert"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'admin', NULL, NULL, 'xfPageManagement', 'updateItem', '✅xfPageManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page", "operation": "jhUpdate"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'admin', NULL, NULL, 'xfPageManagement', 'deleteItem', '✅xfPageManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page", "operation": "jhDelete"}', '', '', 'update', 'vscode', 'vscode', '2022-06-16T16:58:21+08:00');
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (73, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'selectItemList', '✅xfPageHistoryManagement查询-查询列表', 'sql', '{}', '{"table": "xf_page_history", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'insertItem', '✅xfPageHistoryManagement查询-添加成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "insert"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (75, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'updateItem', '✅xfPageHistoryManagement查询-更新成员', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (76, 'admin', NULL, NULL, 'xfPageHistoryManagement', 'deleteItem', '✅xfPageHistoryManagement查询-删除信息', 'sql', '{}', '{"table": "xf_page_history", "operation": "jhDelete"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (77, 'admin', NULL, NULL, 'codeViewManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "code_view", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (78, 'admin', NULL, '{ "before": [
{"service": "codeView", "serviceFunction": "beforeCreateCodeId"}
]
}', 'codeViewManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "code_view", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (79, 'admin', NULL, NULL, 'codeViewManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "code_view", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (80, 'admin', NULL, NULL, 'codeViewManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "code_view", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (81, 'admin', NULL, NULL, 'constantUiManagement', 'selectItemList', '✅constantUiManagement查询-查询列表', 'sql', '{}', '{"table": "seo_ui", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (82, 'admin', NULL, NULL, 'constantUiManagement', 'insertItem', '✅constantUiManagement查询-添加成员', 'sql', '{}', '{"table": "seo_ui", "operation": "insert"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'admin', NULL, NULL, 'constantUiManagement', 'updateItem', '✅constantUiManagement查询-更新成员', 'sql', '{}', '{"table": "seo_ui", "operation": "jhUpdate"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (84, 'admin', NULL, NULL, 'constantUiManagement', 'deleteItem', '✅constantUiManagement查询-删除信息', 'sql', '{}', '{"table": "seo_ui", "operation": "jhDelete"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (85, 'admin', NULL, NULL, 'articleEdit', 'list', '✅xf编辑-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (86, 'admin', NULL, NULL, 'articleEdit', 'mkdir', '✅xf编辑-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (87, 'admin', NULL, NULL, 'articleEdit', 'moveFile', '✅xf编辑-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (88, 'admin', NULL, NULL, 'articleEdit', 'copyFile', '✅xf编辑-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (89, 'admin', NULL, NULL, 'articleEdit', 'renameFile', '✅xf编辑-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (90, 'admin', NULL, NULL, 'articleEdit', 'delete', '✅xf编辑-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (91, 'admin', NULL, NULL, 'articleEdit', 'clearRecycle', '✅xf编辑-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```