页面

12086

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jhId` varchar(255) DEFAULT NULL,
  `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text,
  `pageFile` varchar(255) DEFAULT NULL COMMENT 'page 指定文件',
  `sort` varchar(255) DEFAULT NULL,
  `pageHook` text COMMENT '{\n  "beforeHook":[\n  {"field": "doc", "service": "doc", "serviceFunc": "getDoc"}\n  ]\n}',
  `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 = 47 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '页面表; 软删除未启用;'

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	--废弃--help	dynamicInMenu	helpV4	11	null

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	1	seo	insert
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	17	admin	insert

操作手册

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
操作手册	--废弃--manual	showInMenu	null	0	null

首页

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
首页	--废弃--home	seo	null		{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" }, { "field": "userInfo", "service": "user", "serviceFunc": "userInfo" } ] }

用户管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
用户管理	userManagement	showInMenu	null	6	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	jhId	operation	operationAt	requestDemo	responseDemo
✅用户管理-查询信息	userManagement	selectItemList	null	sql	{ "table": "_user", "operation": "select" }	7	seo	update	2022-04-25T15:31:19+08:00
✅用户管理-查询信息	userManagement	insertItem	null	service	{ "service": "userManagement", "serviceFunction": "addUser" }	8	seo	update	2022-02-18T20:19:24+08:00
✅用户管理-修改密码	userManagement	resetUserPassword	null	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	9	seo	update	2022-04-25T14:40:49+08:00
✅用户管理-更新用户	userManagement	updateItem	null	sql	{ "table": "_user", "operation": "jhUpdate" }	10	seo	update	2022-04-25T14:38:08+08:00
✅用户管理-查询信息	userManagement	selectItemList	null	sql	{ "table": "_user", "operation": "select" }	30	admin	update	2022-04-25T15:31:19+08:00	{"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"}}
✅用户管理-查询信息	userManagement	insertItem	null	service	{ "service": "userManagement", "serviceFunction": "addUser" }	31	admin	update	2022-02-18T20:19:24+08:00
✅用户管理-修改密码	userManagement	resetUserPassword	null	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	32	admin	update	2022-04-25T14:40:49+08:00	{"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"}}
✅用户管理-更新用户	userManagement	updateItem	null	sql	{ "table": "_user", "operation": "jhUpdate" }	33	admin	update	2022-04-25T14:38:08+08:00	{"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"}}

文章详情

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章详情	article	seo	null	null	{ "beforeHook": [ { "field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles" }, { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" }, { "field": "userInfo", "service": "user", "serviceFunc": "userInfo" } ] }

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅文章页面	article	addComment	null	sql	{ "table": "comment", "operation": "jhInsert" }		{}	11	seo	insert

xfPage文章详情

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
xfPage文章详情	xfArticle	seo	null		{ "beforeHook": [ { "field": "xfPage", "service": "xfPage", "serviceFunc": "getXfPageAndFillArticles" }, { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" }, { "field": "userInfo", "service": "user", "serviceFunc": "userInfo" } ] }

欢迎

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
欢迎	welcome	null	null	null	null

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	11	null

登陆

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	1	seo	insert
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	17	admin	insert

[分类]分类管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[分类]分类管理	categoryManagement	showInMenu	null	1	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅分类管理-查询列表	categoryManagement	selectItemList	null	sql	{ "table": "view01_category", "operation": "select" }	{}	27	admin	insert
✅分类管理-创建成员	categoryManagement	jhInsertItem	{ "before": [ { "service": "category", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [] }	sql	{ "table": "category", "operation": "jhInsert" }	{}	28	admin	insert
✅分类管理-更新成员	categoryManagement	jhUpdateItem	{ "before": [ { "service": "category", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [] }	sql	{ "table": "category", "operation": "jhUpdate" }	{}	29	admin	insert

文章管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章管理	articleManagement	showInMenu	null	2	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅文章管理-查询列表(不包含内容)	articleManagement	selectItemList	null	sql	{ "table": "view01_article", "operation": "select" }	{}	22	admin	jhInsert
✅文章编辑-更新成员	articleManagement	jhUpdateItem	{ "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhUpdate" }	{}	23	admin	insert
✅文章管理-查询分类列表	articleManagement	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }	{}	24	admin	insert
✅文章编辑-将文章移至回收站	articleManagement	deletedArticle	null	service	{ "service": "article", "serviceFunction": "deletedArticle" }	{}	25	admin	insert
✅文章编辑-文章恢复	articleManagement	restoreArticle	null	service	{ "service": "article", "serviceFunction": "restoreArticle" }	{}	26	admin	insert

[分类]精选集管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[分类]精选集管理	albumManagement	showInMenu	null	3	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅精选集管理-查询列表	albumManagement	selectItemList	null	sql	{ "table": "album", "operation": "select" }	{}	34	admin	insert
✅精选集管理-添加成员	albumManagement	insertItem	{ "before": [ { "service": "album", "serviceFunction": "albumIdGenerateBeforeHook" } ], "after": [] }	sql	{ "table": "album", "operation": "insert" }	{}	35	admin	insert
✅精选集管理-更新成员	albumManagement	updateItem	null	sql	{ "table": "album", "operation": "jhUpdate" }	{}	36	admin	insert
✅精选集管理-删除信息	albumManagement	deleteItem	null	sql	{ "table": "album", "operation": "jhDelete" }	{}	37	admin	insert
✅精选集管理-查询专辑文章列表	albumManagement	viewAlbumArticleList	null	service	{ "service": "album", "serviceFunction": "viewAlbumArticleList" }	{}	38	admin	insert

[用户]用户管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[用户]用户管理	userManagement	showInMenu	null	6

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	jhId	operation	operationAt	requestDemo	responseDemo
✅用户管理-查询信息	userManagement	selectItemList	null	sql	{ "table": "_user", "operation": "select" }	7	seo	update	2022-04-25T15:31:19+08:00
✅用户管理-查询信息	userManagement	insertItem	null	service	{ "service": "userManagement", "serviceFunction": "addUser" }	8	seo	update	2022-02-18T20:19:24+08:00
✅用户管理-修改密码	userManagement	resetUserPassword	null	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	9	seo	update	2022-04-25T14:40:49+08:00
✅用户管理-更新用户	userManagement	updateItem	null	sql	{ "table": "_user", "operation": "jhUpdate" }	10	seo	update	2022-04-25T14:38:08+08:00
✅用户管理-查询信息	userManagement	selectItemList	null	sql	{ "table": "_user", "operation": "select" }	30	admin	update	2022-04-25T15:31:19+08:00	{"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"}}
✅用户管理-查询信息	userManagement	insertItem	null	service	{ "service": "userManagement", "serviceFunction": "addUser" }	31	admin	update	2022-02-18T20:19:24+08:00
✅用户管理-修改密码	userManagement	resetUserPassword	null	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	32	admin	update	2022-04-25T14:40:49+08:00	{"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"}}
✅用户管理-更新用户	userManagement	updateItem	null	sql	{ "table": "_user", "operation": "jhUpdate" }	33	admin	update	2022-04-25T14:38:08+08:00	{"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"}}

文章详情

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章详情	article	seo	null	null	{ "beforeHook": [ { "field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles" } ] }

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅文章页面	article	addComment	null	sql	{ "table": "comment", "operation": "jhInsert" }		{}	11	seo	insert

[用户]修改密码

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[用户]修改密码	resetUserPassword	showInMenu	null	11

素材管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
素材管理	materialManagement	showInMenu	null	5	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅素材管理-文件列表	materialManagement	list	null	service	{ "service": "material", "serviceFunction": "list" }	{}	50	admin	insert
✅素材管理-创建文件夹	materialManagement	mkdir	null	service	{ "service": "material", "serviceFunction": "mkdir" }	{}	51	admin	insert
✅素材管理-删除	materialManagement	delete	null	service	{ "service": "material", "serviceFunction": "delete" }	{}	52	admin	insert
✅素材管理-清空回收站	materialManagement	clearRecycle	null	service	{ "service": "material", "serviceFunction": "clearRecycle" }	{}	53	admin	insert
✅素材管理-文件重命名	materialManagement	renameFile	null	service	{ "service": "material", "serviceFunction": "renameFile" }	{}	54	admin	insert
✅素材管理-移动文件	materialManagement	moveFile	null	service	{ "service": "material", "serviceFunction": "moveFile" }	{}	57	admin	insert
✅素材管理-复制文件	materialManagement	copyFile	null	service	{ "service": "material", "serviceFunction": "copyFile" }	{}	58	admin	insert

文章编辑

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章编辑	articleEdit	dynamicInMenu	null	null	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅文章编辑-查询带文集信息的文章	articleEdit	selectArticleWithCategory	null	service	{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }	{}	39	admin	insert
✅文章编辑-使用素材	articleEdit	useMaterial	null	service	{ "service": "material", "serviceFunction": "useMaterial" }	{}	40	admin	insert
✅文章编辑-查询列表	articleEdit	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }	{}	41	admin	insert
✅文章编辑-添加成员	articleEdit	jhInsertItem	{ "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhInsert" }	{}	42	admin	jhInsert
✅文章编辑-查询文章列表	articleEdit	selectItemList	null	sql	{ "table": "article", "operation": "select" }	{}	43	admin	jhInsert
✅文章编辑-更新成员	articleEdit	jhUpdateItem	{ "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhUpdate" }	{}	44	admin	insert
✅文章编辑-将文章移至回收站	articleEdit	deletedArticle		service	{ "service": "article", "serviceFunction": "deletedArticle" }	{}	45	admin	insert
✅文章编辑-文章恢复	articleEdit	restoreArticle	null	service	{ "service": "article", "serviceFunction": "restoreArticle" }	{}	46	admin	insert
✅文章编辑-代码块列表	articleEdit	selectCodeList	null	sql	{ "table": "code_view", "operation": "select" }		47	admin	insert
✅修改codeview	articleEdit	updateCodeItem	null	sql	{ "table": "code_view", "operation": "jhUpdate" }		48	admin	insert
✅xf编辑-文件列表	articleEdit	list	null	service	{ "service": "material", "serviceFunction": "list" }	{}	85	admin	insert
✅xf编辑-创建文件夹	articleEdit	mkdir	null	service	{ "service": "material", "serviceFunction": "mkdir" }	{}	86	admin	insert
✅xf编辑-移动文件	articleEdit	moveFile	null	service	{ "service": "material", "serviceFunction": "moveFile" }	{}	87	admin	insert
✅xf编辑-复制文件	articleEdit	copyFile	null	service	{ "service": "material", "serviceFunction": "copyFile" }	{}	88	admin	insert
✅xf编辑-文件重命名	articleEdit	renameFile	null	service	{ "service": "material", "serviceFunction": "renameFile" }	{}	89	admin	insert
✅xf编辑-删除	articleEdit	delete	null	service	{ "service": "material", "serviceFunction": "delete" }	{}	90	admin	insert
✅xf编辑-清空回收站	articleEdit	clearRecycle	null	service	{ "service": "material", "serviceFunction": "clearRecycle" }	{}	91	admin	insert

文章历史版本管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章历史版本管理	articleHistoryManagement	dynamicInMenu	null	null	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅文章历史版本管理-恢复版本	articleHistoryManagement	selectItemList	null	sql	{ "table": "article_history", "operation": "select" }		{}	55	admin	insert
✅文章历史版本管理-恢复版本	articleHistoryManagement	jhUpdateArticleItem	null	service	{ "table": "article", "operation": "jhUpdate" }		{}	56	admin	insert

xf页面编辑

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
xf页面编辑	xfPageEdit	dynamicInMenu	null	null	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅文章编辑-查询带文集信息的文章	xfPageEdit	selectXfPageWithCategory	null	service	{"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"}	{}	61	admin	insert
✅文章编辑-使用素材	xfPageEdit	useMaterial	null	service	{"service": "material", "serviceFunction": "xfPageMaterial"}	{}	62	admin	insert
✅文章编辑-查询列表	xfPageEdit	selectCategoryList	null	sql	{"table": "view01_category", "operation": "select"}	{}	63	admin	insert
✅文章编辑-添加成员	xfPageEdit	jhInsertItem	{ "before": [ { "service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook" } ] }	sql	{"table": "xf_page", "operation": "jhInsert"}	{}	64	admin	jhInsert
✅文章编辑-查询文章列表	xfPageEdit	selectItemList	null	sql	{"table": "xf_page", "operation": "select"}	{}	65	admin	jhInsert
✅文章编辑-更新成员	xfPageEdit	jhUpdateItem	{ "before": [ { "service": "xfPage", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook" } ] }	sql	{"table": "xf_page", "operation": "jhUpdate"}	{}	66	admin	insert
✅文章编辑-将文章移至回收站	xfPageEdit	deletedItem		service	{"service": "xfPage", "serviceFunction": "deletedXfPage"}	{}	67	admin	insert
✅文章编辑-文章恢复	xfPageEdit	restoreItem	null	service	{"service": "xfPage", "serviceFunction": "restoreXfPage"}	{}	68	admin	insert

xf页面管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
xf页面管理	xfPageManagement	showInMenu	null	5

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId
✅xfPageManagement查询-查询列表	xfPageManagement	selectItemList	null	sql	{"table": "xf_page", "operation": "select"}	{}	69	admin	update	2022-06-16T16:58:21+08:00	vscode	vscode
✅xfPageManagement查询-添加成员	xfPageManagement	insertItem	null	sql	{"table": "xf_page", "operation": "insert"}	{}	70	admin	update	2022-06-16T16:58:21+08:00	vscode	vscode
✅xfPageManagement查询-更新成员	xfPageManagement	updateItem	null	sql	{"table": "xf_page", "operation": "jhUpdate"}	{}	71	admin	update	2022-06-16T16:58:21+08:00	vscode	vscode
✅xfPageManagement查询-删除信息	xfPageManagement	deleteItem	null	sql	{"table": "xf_page", "operation": "jhDelete"}	{}	72	admin	update	2022-06-16T16:58:21+08:00	vscode	vscode

xf文章历史

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
xf文章历史	xfPageHistoryManagement	dynamicInMenu	null	5

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅xfPageHistoryManagement查询-查询列表	xfPageHistoryManagement	selectItemList	null	sql	{"table": "xf_page_history", "operation": "select"}	{}	73	admin	insert
✅xfPageHistoryManagement查询-添加成员	xfPageHistoryManagement	insertItem	null	sql	{"table": "xf_page_history", "operation": "insert"}	{}	74	admin	insert
✅xfPageHistoryManagement查询-更新成员	xfPageHistoryManagement	updateItem	null	sql	{"table": "xf_page_history", "operation": "jhUpdate"}	{}	75	admin	insert
✅xfPageHistoryManagement查询-删除信息	xfPageHistoryManagement	deleteItem	null	sql	{"table": "xf_page_history", "operation": "jhDelete"}	{}	76	admin	insert

代码块管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
代码块管理	codeViewManagement	showInMenu	null	5	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅查询列表	codeViewManagement	selectItemList	null	sql	{ "table": "code_view", "operation": "select" }	{}	77	admin	insert
✅添加	codeViewManagement	insertItem	{ "before": [ { "service": "codeView", "serviceFunction": "beforeCreateCodeId" } ] }	sql	{ "table": "code_view", "operation": "insert" }	{}	78	admin	insert
✅更新	codeViewManagement	updateItem	null	sql	{ "table": "code_view", "operation": "jhUpdate" }	{}	79	admin	insert
✅删除	codeViewManagement	deleteItem	null	sql	{ "table": "code_view", "operation": "jhDelete" }	{}	80	admin	insert

UI配置

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
UI配置	constantUiManagement	showInMenu	null	null	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	jhId	operation
✅constantUiManagement查询-查询列表	constantUiManagement	selectItemList	null	sql	{"table": "seo_ui", "operation": "select"}	{}	81	admin	insert
✅constantUiManagement查询-添加成员	constantUiManagement	insertItem	null	sql	{"table": "seo_ui", "operation": "insert"}	{}	82	admin	insert
✅constantUiManagement查询-更新成员	constantUiManagement	updateItem	null	sql	{"table": "seo_ui", "operation": "jhUpdate"}	{}	83	admin	insert
✅constantUiManagement查询-删除信息	constantUiManagement	deleteItem	null	sql	{"table": "seo_ui", "operation": "jhDelete"}	{}	84	admin	insert

通知/待办

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
通知/待办	https://demo.jianghujs.org/task/page/noticeManagement	showInRightMenu	null	null	null

_page语句

INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'seo', '--废弃--help', '帮助', 'dynamicInMenu', NULL, 'helpV4', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'seo', 'login', '登录', '', NULL, 'loginV4', '', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'seo', '--废弃--manual', '操作手册', 'showInMenu', NULL, NULL, '0', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'seo', '--废弃--home', '首页', 'seo', NULL, NULL, '', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
        {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'seo', 'userManagement', '用户管理', 'showInMenu', NULL, NULL, '6', NULL, NULL, NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'seo', 'article', '文章详情', 'seo', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"},
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
        {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'seo', 'xfArticle', 'xfPage文章详情', 'seo', NULL, NULL, '', '{
  "beforeHook":[
    {"field": "xfPage", "service": "xfPage", "serviceFunc": "getXfPageAndFillArticles"},
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
        {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'admin', 'welcome', '欢迎', NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'admin', 'help', '帮助', 'dynamicInMenu', NULL, 'helpV4', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'admin', 'login', '登陆', '', NULL, 'loginV4', '', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'admin', 'categoryManagement', '[分类]分类管理', 'showInMenu', NULL, NULL, '1', NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'admin', 'articleManagement', '文章管理', 'showInMenu', NULL, NULL, '2', NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'admin', 'albumManagement', '[分类]精选集管理', 'showInMenu', NULL, NULL, '3', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'admin', 'userManagement', '[用户]用户管理', 'showInMenu', NULL, NULL, '6', '', NULL, NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'admin', 'article', '文章详情', 'seo', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'admin', 'resetUserPassword', '[用户]修改密码', 'showInMenu', NULL, NULL, '11', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'admin', 'materialManagement', '素材管理', 'showInMenu', NULL, NULL, '5', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'admin', 'articleEdit', '文章编辑', 'dynamicInMenu', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'admin', 'articleHistoryManagement', '文章历史版本管理', 'dynamicInMenu', NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'admin', 'xfPageEdit', 'xf页面编辑', 'dynamicInMenu', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', '', 'insert', NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'admin', 'xfPageManagement', 'xf页面管理', 'showInMenu', NULL, NULL, '5', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'admin', 'xfPageHistoryManagement', 'xf文章历史', 'dynamicInMenu', NULL, NULL, '5', '', 'update', 'vscode', 'vscode', '2022-06-17T09:10:36+08:00');
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'admin', 'codeViewManagement', '代码块管理', 'showInMenu', NULL, NULL, '5', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'admin', 'constantUiManagement', 'UI配置', 'showInMenu', NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (46, NULL, 'https://demo.jianghujs.org/task/page/noticeManagement', '通知/待办', 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);

# 页面总览

## _page结构

```sql
CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jhId` varchar(255) DEFAULT NULL,
  `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text,
  `pageFile` varchar(255) DEFAULT NULL COMMENT 'page 指定文件',
  `sort` varchar(255) DEFAULT NULL,
  `pageHook` text COMMENT '{\n  "beforeHook":[\n  {"field": "doc", "service": "doc", "serviceFunc": "getDoc"}\n  ]\n}',
  `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 = 47 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '页面表; 软删除未启用;'
```

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | --废弃--help | dynamicInMenu | helpV4 | 11 | null |

## 登录

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 登录 | login |  | loginV4 |  | {   "beforeHook": [     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     }   ] } |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | login | passwordLogin | null | service | { "service": "user", "serviceFunction": "passwordLogin" } |  | {} | 1 | seo | insert |  |  |  |  |  |
| ✅登陆 | login | passwordLogin | null | service | { "service": "user", "serviceFunction": "passwordLogin" } |  | {} | 17 | admin | insert |  |  |  |  |  |

## 操作手册

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 操作手册 | --废弃--manual | showInMenu | null | 0 | null |

## 首页

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 首页 | --废弃--home | seo | null |  | {   "beforeHook": [     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     },     {       "field": "userInfo",       "service": "user",       "serviceFunc": "userInfo"     }   ] } |

## 用户管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 用户管理 | userManagement | showInMenu | null | 6 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅用户管理-查询信息 | userManagement | selectItemList | null | sql | { "table": "_user", "operation": "select" } |  |  | 7 | seo | update | 2022-04-25T15:31:19+08:00 |  |  |  |  |
| ✅用户管理-查询信息 | userManagement | insertItem | null | service | { "service": "userManagement", "serviceFunction": "addUser" } |  |  | 8 | seo | update | 2022-02-18T20:19:24+08:00 |  |  |  |  |
| ✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  |  | 9 | seo | update | 2022-04-25T14:40:49+08:00 |  |  |  |  |
| ✅用户管理-更新用户 | userManagement | updateItem | null | sql | { "table": "_user", "operation": "jhUpdate" } |  |  | 10 | seo | update | 2022-04-25T14:38:08+08:00 |  |  |  |  |
| ✅用户管理-查询信息 | userManagement | selectItemList | null | sql | { "table": "_user", "operation": "select" } |  |  | 30 | admin | update | 2022-04-25T15:31:19+08:00 |  |  | {"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"}} |
| ✅用户管理-查询信息 | userManagement | insertItem | null | service | { "service": "userManagement", "serviceFunction": "addUser" } |  |  | 31 | admin | update | 2022-02-18T20:19:24+08:00 |  |  |  |  |
| ✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  |  | 32 | admin | update | 2022-04-25T14:40:49+08:00 |  |  | {"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"}} |
| ✅用户管理-更新用户 | userManagement | updateItem | null | sql | { "table": "_user", "operation": "jhUpdate" } |  |  | 33 | admin | update | 2022-04-25T14:38:08+08:00 |  |  | {"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"}} |

## 文章详情

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 文章详情 | article | seo | null | null | {   "beforeHook": [     {       "field": "article",       "service": "article",       "serviceFunc": "getArticleAndFillArticles"     },     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     },     {       "field": "userInfo",       "service": "user",       "serviceFunc": "userInfo"     }   ] } |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章页面 | article | addComment | null | sql | { "table": "comment", "operation": "jhInsert" } |  | {} | 11 | seo | insert |  |  |  |  |  |

## xfPage文章详情

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| xfPage文章详情 | xfArticle | seo | null |  | {   "beforeHook": [     {       "field": "xfPage",       "service": "xfPage",       "serviceFunc": "getXfPageAndFillArticles"     },     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     },     {       "field": "userInfo",       "service": "user",       "serviceFunc": "userInfo"     }   ] } |

## 欢迎

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 欢迎 | welcome | null | null | null | null |

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | help | dynamicInMenu | helpV4 | 11 | null |

## 登陆

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 登陆 | login |  | loginV4 |  | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | login | passwordLogin | null | service | { "service": "user", "serviceFunction": "passwordLogin" } |  | {} | 1 | seo | insert |  |  |  |  |  |
| ✅登陆 | login | passwordLogin | null | service | { "service": "user", "serviceFunction": "passwordLogin" } |  | {} | 17 | admin | insert |  |  |  |  |  |

## [分类]分类管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| [分类]分类管理 | categoryManagement | showInMenu | null | 1 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅分类管理-查询列表 | categoryManagement | selectItemList | null | sql | { "table": "view01_category", "operation": "select" } |  | {} | 27 | admin | insert |  |  |  |  |  |
| ✅分类管理-创建成员 | categoryManagement | jhInsertItem | {   "before": [     {       "service": "category",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [] } | sql | { "table": "category", "operation": "jhInsert" } |  | {} | 28 | admin | insert |  |  |  |  |  |
| ✅分类管理-更新成员 | categoryManagement | jhUpdateItem | {   "before": [     {       "service": "category",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [] } | sql | { "table": "category", "operation": "jhUpdate" } |  | {} | 29 | admin | insert |  |  |  |  |  |

## 文章管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 文章管理 | articleManagement | showInMenu | null | 2 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章管理-查询列表(不包含内容) | articleManagement | selectItemList | null | sql | { "table": "view01_article", "operation": "select" } |  | {} | 22 | admin | jhInsert |  |  |  |  |  |
| ✅文章编辑-更新成员 | articleManagement | jhUpdateItem | {   "before": [     {       "service": "article",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [     {       "service": "article",       "serviceFunction": "articleHistoryRecordAfterHook"     }   ] } | sql | { "table": "article", "operation": "jhUpdate" } |  | {} | 23 | admin | insert |  |  |  |  |  |
| ✅文章管理-查询分类列表 | articleManagement | selectCategoryList | null | sql | { "table": "view01_category", "operation": "select" } |  | {} | 24 | admin | insert |  |  |  |  |  |
| ✅文章编辑-将文章移至回收站 | articleManagement | deletedArticle | null | service | { "service": "article", "serviceFunction": "deletedArticle" } |  | {} | 25 | admin | insert |  |  |  |  |  |
| ✅文章编辑-文章恢复 | articleManagement | restoreArticle | null | service | { "service": "article", "serviceFunction": "restoreArticle" } |  | {} | 26 | admin | insert |  |  |  |  |  |

## [分类]精选集管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| [分类]精选集管理 | albumManagement | showInMenu | null | 3 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅精选集管理-查询列表 | albumManagement | selectItemList | null | sql | { "table": "album", "operation": "select" } |  | {} | 34 | admin | insert |  |  |  |  |  |
| ✅精选集管理-添加成员 | albumManagement | insertItem | {   "before": [     {       "service": "album",       "serviceFunction": "albumIdGenerateBeforeHook"     }   ],   "after": [] } | sql | { "table": "album", "operation": "insert" } |  | {} | 35 | admin | insert |  |  |  |  |  |
| ✅精选集管理-更新成员 | albumManagement | updateItem | null | sql | { "table": "album", "operation": "jhUpdate" } |  | {} | 36 | admin | insert |  |  |  |  |  |
| ✅精选集管理-删除信息 | albumManagement | deleteItem | null | sql | { "table": "album", "operation": "jhDelete" } |  | {} | 37 | admin | insert |  |  |  |  |  |
| ✅精选集管理-查询专辑文章列表 | albumManagement | viewAlbumArticleList | null | service | { "service": "album", "serviceFunction": "viewAlbumArticleList" } |  | {} | 38 | admin | insert |  |  |  |  |  |

## [用户]用户管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| [用户]用户管理 | userManagement | showInMenu | null | 6 |  |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅用户管理-查询信息 | userManagement | selectItemList | null | sql | { "table": "_user", "operation": "select" } |  |  | 7 | seo | update | 2022-04-25T15:31:19+08:00 |  |  |  |  |
| ✅用户管理-查询信息 | userManagement | insertItem | null | service | { "service": "userManagement", "serviceFunction": "addUser" } |  |  | 8 | seo | update | 2022-02-18T20:19:24+08:00 |  |  |  |  |
| ✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  |  | 9 | seo | update | 2022-04-25T14:40:49+08:00 |  |  |  |  |
| ✅用户管理-更新用户 | userManagement | updateItem | null | sql | { "table": "_user", "operation": "jhUpdate" } |  |  | 10 | seo | update | 2022-04-25T14:38:08+08:00 |  |  |  |  |
| ✅用户管理-查询信息 | userManagement | selectItemList | null | sql | { "table": "_user", "operation": "select" } |  |  | 30 | admin | update | 2022-04-25T15:31:19+08:00 |  |  | {"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"}} |
| ✅用户管理-查询信息 | userManagement | insertItem | null | service | { "service": "userManagement", "serviceFunction": "addUser" } |  |  | 31 | admin | update | 2022-02-18T20:19:24+08:00 |  |  |  |  |
| ✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  |  | 32 | admin | update | 2022-04-25T14:40:49+08:00 |  |  | {"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"}} |
| ✅用户管理-更新用户 | userManagement | updateItem | null | sql | { "table": "_user", "operation": "jhUpdate" } |  |  | 33 | admin | update | 2022-04-25T14:38:08+08:00 |  |  | {"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"}} |

## 文章详情

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 文章详情 | article | seo | null | null | {   "beforeHook": [     {       "field": "article",       "service": "article",       "serviceFunc": "getArticleAndFillArticles"     }   ] } |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章页面 | article | addComment | null | sql | { "table": "comment", "operation": "jhInsert" } |  | {} | 11 | seo | insert |  |  |  |  |  |

## [用户]修改密码

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| [用户]修改密码 | resetUserPassword | showInMenu | null | 11 |  |

## 素材管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 素材管理 | materialManagement | showInMenu | null | 5 | {   "beforeHook": [     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     }   ] } |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅素材管理-文件列表 | materialManagement | list | null | service | { "service": "material", "serviceFunction": "list" } |  | {} | 50 | admin | insert |  |  |  |  |  |
| ✅素材管理-创建文件夹 | materialManagement | mkdir | null | service | { "service": "material", "serviceFunction": "mkdir" } |  | {} | 51 | admin | insert |  |  |  |  |  |
| ✅素材管理-删除 | materialManagement | delete | null | service | { "service": "material", "serviceFunction": "delete" } |  | {} | 52 | admin | insert |  |  |  |  |  |
| ✅素材管理-清空回收站 | materialManagement | clearRecycle | null | service | { "service": "material", "serviceFunction": "clearRecycle" } |  | {} | 53 | admin | insert |  |  |  |  |  |
| ✅素材管理-文件重命名 | materialManagement | renameFile | null | service | { "service": "material", "serviceFunction": "renameFile" } |  | {} | 54 | admin | insert |  |  |  |  |  |
| ✅素材管理-移动文件 | materialManagement | moveFile | null | service | { "service": "material", "serviceFunction": "moveFile" } |  | {} | 57 | admin | insert |  |  |  |  |  |
| ✅素材管理-复制文件 | materialManagement | copyFile | null | service | { "service": "material", "serviceFunction": "copyFile" } |  | {} | 58 | admin | insert |  |  |  |  |  |

## 文章编辑

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 文章编辑 | articleEdit | dynamicInMenu | null | null | {   "beforeHook": [     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     }   ] } |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章编辑-查询带文集信息的文章 | articleEdit | selectArticleWithCategory | null | service | { "service": "article", "serviceFunction": "getArticleAndFillArticles" } |  | {} | 39 | admin | insert |  |  |  |  |  |
| ✅文章编辑-使用素材 | articleEdit | useMaterial | null | service | { "service": "material", "serviceFunction": "useMaterial" } |  | {} | 40 | admin | insert |  |  |  |  |  |
| ✅文章编辑-查询列表 | articleEdit | selectCategoryList | null | sql | { "table": "view01_category", "operation": "select" } |  | {} | 41 | admin | insert |  |  |  |  |  |
| ✅文章编辑-添加成员 | articleEdit | jhInsertItem | {   "before": [     {       "service": "article",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [     {       "service": "article",       "serviceFunction": "articleHistoryRecordAfterHook"     }   ] } | sql | { "table": "article", "operation": "jhInsert" } |  | {} | 42 | admin | jhInsert |  |  |  |  |  |
| ✅文章编辑-查询文章列表 | articleEdit | selectItemList | null | sql | { "table": "article", "operation": "select" } |  | {} | 43 | admin | jhInsert |  |  |  |  |  |
| ✅文章编辑-更新成员 | articleEdit | jhUpdateItem | {   "before": [     {       "service": "article",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [     {       "service": "article",       "serviceFunction": "articleHistoryRecordAfterHook"     }   ] } | sql | { "table": "article", "operation": "jhUpdate" } |  | {} | 44 | admin | insert |  |  |  |  |  |
| ✅文章编辑-将文章移至回收站 | articleEdit | deletedArticle |  | service | { "service": "article", "serviceFunction": "deletedArticle" } |  | {} | 45 | admin | insert |  |  |  |  |  |
| ✅文章编辑-文章恢复 | articleEdit | restoreArticle | null | service | { "service": "article", "serviceFunction": "restoreArticle" } |  | {} | 46 | admin | insert |  |  |  |  |  |
| ✅文章编辑-代码块列表 | articleEdit | selectCodeList | null | sql | { "table": "code_view", "operation": "select" } |  |  | 47 | admin | insert |  |  |  |  |  |
| ✅修改codeview | articleEdit | updateCodeItem | null | sql | { "table": "code_view", "operation": "jhUpdate" } |  |  | 48 | admin | insert |  |  |  |  |  |
| ✅xf编辑-文件列表 | articleEdit | list | null | service | { "service": "material", "serviceFunction": "list" } |  | {} | 85 | admin | insert |  |  |  |  |  |
| ✅xf编辑-创建文件夹 | articleEdit | mkdir | null | service | { "service": "material", "serviceFunction": "mkdir" } |  | {} | 86 | admin | insert |  |  |  |  |  |
| ✅xf编辑-移动文件 | articleEdit | moveFile | null | service | { "service": "material", "serviceFunction": "moveFile" } |  | {} | 87 | admin | insert |  |  |  |  |  |
| ✅xf编辑-复制文件 | articleEdit | copyFile | null | service | { "service": "material", "serviceFunction": "copyFile" } |  | {} | 88 | admin | insert |  |  |  |  |  |
| ✅xf编辑-文件重命名 | articleEdit | renameFile | null | service | { "service": "material", "serviceFunction": "renameFile" } |  | {} | 89 | admin | insert |  |  |  |  |  |
| ✅xf编辑-删除 | articleEdit | delete | null | service | { "service": "material", "serviceFunction": "delete" } |  | {} | 90 | admin | insert |  |  |  |  |  |
| ✅xf编辑-清空回收站 | articleEdit | clearRecycle | null | service | { "service": "material", "serviceFunction": "clearRecycle" } |  | {} | 91 | admin | insert |  |  |  |  |  |

## 文章历史版本管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 文章历史版本管理 | articleHistoryManagement | dynamicInMenu | null | null | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章历史版本管理-恢复版本 | articleHistoryManagement | selectItemList | null | sql | { "table": "article_history", "operation": "select" } |  | {} | 55 | admin | insert |  |  |  |  |  |
| ✅文章历史版本管理-恢复版本 | articleHistoryManagement | jhUpdateArticleItem | null | service | { "table": "article", "operation": "jhUpdate" } |  | {} | 56 | admin | insert |  |  |  |  |  |

## xf页面编辑

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| xf页面编辑 | xfPageEdit | dynamicInMenu | null | null | {   "beforeHook": [     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     }   ] } |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章编辑-查询带文集信息的文章 | xfPageEdit | selectXfPageWithCategory | null | service | {"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"} |  | {} | 61 | admin | insert |  |  |  |  |  |
| ✅文章编辑-使用素材 | xfPageEdit | useMaterial | null | service | {"service": "material", "serviceFunction": "xfPageMaterial"} |  | {} | 62 | admin | insert |  |  |  |  |  |
| ✅文章编辑-查询列表 | xfPageEdit | selectCategoryList | null | sql | {"table": "view01_category", "operation": "select"} |  | {} | 63 | admin | insert |  |  |  |  |  |
| ✅文章编辑-添加成员 | xfPageEdit | jhInsertItem | {   "before": [     {       "service": "xfPage",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [     {       "service": "xfPage",       "serviceFunction": "xfPageHistoryRecordAfterHook"     }   ] } | sql | {"table": "xf_page", "operation": "jhInsert"} |  | {} | 64 | admin | jhInsert |  |  |  |  |  |
| ✅文章编辑-查询文章列表 | xfPageEdit | selectItemList | null | sql | {"table": "xf_page", "operation": "select"} |  | {} | 65 | admin | jhInsert |  |  |  |  |  |
| ✅文章编辑-更新成员 | xfPageEdit | jhUpdateItem | {   "before": [     {       "service": "xfPage",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [     {       "service": "xfPage",       "serviceFunction": "xfPageHistoryRecordAfterHook"     }   ] } | sql | {"table": "xf_page", "operation": "jhUpdate"} |  | {} | 66 | admin | insert |  |  |  |  |  |
| ✅文章编辑-将文章移至回收站 | xfPageEdit | deletedItem |  | service | {"service": "xfPage", "serviceFunction": "deletedXfPage"} |  | {} | 67 | admin | insert |  |  |  |  |  |
| ✅文章编辑-文章恢复 | xfPageEdit | restoreItem | null | service | {"service": "xfPage", "serviceFunction": "restoreXfPage"} |  | {} | 68 | admin | insert |  |  |  |  |  |

## xf页面管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| xf页面管理 | xfPageManagement | showInMenu | null | 5 |  |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅xfPageManagement查询-查询列表 | xfPageManagement | selectItemList | null | sql | {"table": "xf_page", "operation": "select"} |  | {} | 69 | admin | update | 2022-06-16T16:58:21+08:00 | vscode | vscode |  |  |
| ✅xfPageManagement查询-添加成员 | xfPageManagement | insertItem | null | sql | {"table": "xf_page", "operation": "insert"} |  | {} | 70 | admin | update | 2022-06-16T16:58:21+08:00 | vscode | vscode |  |  |
| ✅xfPageManagement查询-更新成员 | xfPageManagement | updateItem | null | sql | {"table": "xf_page", "operation": "jhUpdate"} |  | {} | 71 | admin | update | 2022-06-16T16:58:21+08:00 | vscode | vscode |  |  |
| ✅xfPageManagement查询-删除信息 | xfPageManagement | deleteItem | null | sql | {"table": "xf_page", "operation": "jhDelete"} |  | {} | 72 | admin | update | 2022-06-16T16:58:21+08:00 | vscode | vscode |  |  |

## xf文章历史

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| xf文章历史 | xfPageHistoryManagement | dynamicInMenu | null | 5 |  |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅xfPageHistoryManagement查询-查询列表 | xfPageHistoryManagement | selectItemList | null | sql | {"table": "xf_page_history", "operation": "select"} |  | {} | 73 | admin | insert |  |  |  |  |  |
| ✅xfPageHistoryManagement查询-添加成员 | xfPageHistoryManagement | insertItem | null | sql | {"table": "xf_page_history", "operation": "insert"} |  | {} | 74 | admin | insert |  |  |  |  |  |
| ✅xfPageHistoryManagement查询-更新成员 | xfPageHistoryManagement | updateItem | null | sql | {"table": "xf_page_history", "operation": "jhUpdate"} |  | {} | 75 | admin | insert |  |  |  |  |  |
| ✅xfPageHistoryManagement查询-删除信息 | xfPageHistoryManagement | deleteItem | null | sql | {"table": "xf_page_history", "operation": "jhDelete"} |  | {} | 76 | admin | insert |  |  |  |  |  |

## 代码块管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 代码块管理 | codeViewManagement | showInMenu | null | 5 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | codeViewManagement | selectItemList | null | sql | { "table": "code_view", "operation": "select" } |  | {} | 77 | admin | insert |  |  |  |  |  |
| ✅添加 | codeViewManagement | insertItem | {   "before": [     {       "service": "codeView",       "serviceFunction": "beforeCreateCodeId"     }   ] } | sql | { "table": "code_view", "operation": "insert" } |  | {} | 78 | admin | insert |  |  |  |  |  |
| ✅更新 | codeViewManagement | updateItem | null | sql | { "table": "code_view", "operation": "jhUpdate" } |  | {} | 79 | admin | insert |  |  |  |  |  |
| ✅删除 | codeViewManagement | deleteItem | null | sql | { "table": "code_view", "operation": "jhDelete" } |  | {} | 80 | admin | insert |  |  |  |  |  |

## UI配置

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| UI配置 | constantUiManagement | showInMenu | null | null | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | jhId | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅constantUiManagement查询-查询列表 | constantUiManagement | selectItemList | null | sql | {"table": "seo_ui", "operation": "select"} |  | {} | 81 | admin | insert |  |  |  |  |  |
| ✅constantUiManagement查询-添加成员 | constantUiManagement | insertItem | null | sql | {"table": "seo_ui", "operation": "insert"} |  | {} | 82 | admin | insert |  |  |  |  |  |
| ✅constantUiManagement查询-更新成员 | constantUiManagement | updateItem | null | sql | {"table": "seo_ui", "operation": "jhUpdate"} |  | {} | 83 | admin | insert |  |  |  |  |  |
| ✅constantUiManagement查询-删除信息 | constantUiManagement | deleteItem | null | sql | {"table": "seo_ui", "operation": "jhDelete"} |  | {} | 84 | admin | insert |  |  |  |  |  |

## 通知/待办

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 通知/待办 | https://demo.jianghujs.org/task/page/noticeManagement | showInRightMenu | null | null | null |

## _page语句

```sql
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'seo', '--废弃--help', '帮助', 'dynamicInMenu', NULL, 'helpV4', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'seo', 'login', '登录', '', NULL, 'loginV4', '', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'seo', '--废弃--manual', '操作手册', 'showInMenu', NULL, NULL, '0', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'seo', '--废弃--home', '首页', 'seo', NULL, NULL, '', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
		{"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'seo', 'userManagement', '用户管理', 'showInMenu', NULL, NULL, '6', NULL, NULL, NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'seo', 'article', '文章详情', 'seo', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"},
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
		{"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'seo', 'xfArticle', 'xfPage文章详情', 'seo', NULL, NULL, '', '{
  "beforeHook":[
    {"field": "xfPage", "service": "xfPage", "serviceFunc": "getXfPageAndFillArticles"},
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
		{"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'admin', 'welcome', '欢迎', NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'admin', 'help', '帮助', 'dynamicInMenu', NULL, 'helpV4', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'admin', 'login', '登陆', '', NULL, 'loginV4', '', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'admin', 'categoryManagement', '[分类]分类管理', 'showInMenu', NULL, NULL, '1', NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'admin', 'articleManagement', '文章管理', 'showInMenu', NULL, NULL, '2', NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'admin', 'albumManagement', '[分类]精选集管理', 'showInMenu', NULL, NULL, '3', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'admin', 'userManagement', '[用户]用户管理', 'showInMenu', NULL, NULL, '6', '', NULL, NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'admin', 'article', '文章详情', 'seo', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'admin', 'resetUserPassword', '[用户]修改密码', 'showInMenu', NULL, NULL, '11', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'admin', 'materialManagement', '素材管理', 'showInMenu', NULL, NULL, '5', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'admin', 'articleEdit', '文章编辑', 'dynamicInMenu', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'admin', 'articleHistoryManagement', '文章历史版本管理', 'dynamicInMenu', NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'admin', 'xfPageEdit', 'xf页面编辑', 'dynamicInMenu', NULL, NULL, NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', '', 'insert', NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'admin', 'xfPageManagement', 'xf页面管理', 'showInMenu', NULL, NULL, '5', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'admin', 'xfPageHistoryManagement', 'xf文章历史', 'dynamicInMenu', NULL, NULL, '5', '', 'update', 'vscode', 'vscode', '2022-06-17T09:10:36+08:00');
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'admin', 'codeViewManagement', '代码块管理', 'showInMenu', NULL, NULL, '5', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'admin', 'constantUiManagement', 'UI配置', 'showInMenu', NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, jhId, pageId, pageName, pageType, pageIcon, pageFile, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (46, NULL, 'https://demo.jianghujs.org/task/page/noticeManagement', '通知/待办', 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
```