页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255)  DEFAULT NULL,
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `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 = 85 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

页面信息

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	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	231	insert

分类列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
分类列表	categoryList	showInMenu	null	1	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

接口信息

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

文章列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章列表	articleList	showInMenu	null	2	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅文章管理-查询列表	articleList	selectItemList	null	sql	{ "table": "view01_article", "operation": "select" }	{}	327	jhInsert
✅文章管理-查询分类列表	articleList	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }	{}	331	insert
✅文章编辑-将文章移至回收站	articleList	deletedArticle	null	service	{ "service": "article", "serviceFunction": "deletedArticle" }	{}	332	insert
✅文章编辑-文章恢复	articleList	restoreArticle	null	service	{ "service": "article", "serviceFunction": "restoreArticle" }	{}	333	insert

用户列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
用户列表	userList	showInMenu	null	6	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	operation	operationAt	requestDemo	responseDemo
✅用户管理-查询信息	userList	selectItemList	null	sql	{ "table": "_user", "operation": "select" }	354	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"}}
✅用户管理-查询信息	userList	insertItem	null	service	{ "service": "userManagement", "serviceFunction": "addUser" }	355	update	2022-02-18T20:19:24+08:00
✅用户管理-修改密码	userList	resetUserPassword	null	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	356	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"}}
✅用户管理-更新用户	userList	updateItem	null	sql	{ "table": "_user", "operation": "jhUpdate" }	357	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"}

]
} |

修改密码

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
修改密码	resetUserPassword	showInMenu	null	11

素材列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
素材列表	materialList	showInMenu	null	5	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

文章编辑

页面信息

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	operation
✅文章编辑-查询文章详情	articleEdit	selectArticleInfo	null	service	{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }	{}	381	insert
✅文章编辑-导入素材	articleEdit	importMaterial	null	service	{ "service": "article", "serviceFunction": "importMaterial" }	{}	382	insert
✅文章编辑-查询列表	articleEdit	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }	{}	383	insert
✅文章编辑-添加成员	articleEdit	jhInsertItem	{ "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" }, { "service": "articleParser", "serviceFunction": "parseJhTags" } ], "after": [ { "service": "article", "serviceFunction": "insertItemAfterHook" } ] }	sql	{ "table": "article", "operation": "jhInsert" }	{}	385	jhInsert
✅文章编辑-查询文章列表	articleEdit	selectItemList	null	sql	{ "table": "article", "operation": "select" }	{}	386	jhInsert
✅文章编辑-更新成员	articleEdit	jhUpdateItem	{ "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" }, { "service": "articleParser", "serviceFunction": "parseJhTags" } ], "after": [] }	sql	{ "table": "article", "operation": "jhUpdate" }	{}	387	insert
✅文章编辑-将文章移至回收站	articleEdit	deletedArticle		service	{ "service": "article", "serviceFunction": "deletedArticle" }	{}	388	insert
✅文章编辑-文章恢复	articleEdit	restoreArticle	null	service	{ "service": "article", "serviceFunction": "restoreArticle" }	{}	389	insert

文章历史版本

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章历史版本	articleHistory	dynamicInMenu	null	null	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅文章历史版本管理-恢复版本	articleHistory	selectItemList	null	sql	{ "table": "article_history", "operation": "select" }		{}	411	insert
✅文章历史版本管理-恢复版本	articleHistory	jhUpdateArticleItem	null	service	{ "table": "article", "operation": "jhUpdate" }		{}	412	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	operation
✅文章编辑-查询带文集信息的文章	xfPageEdit	selectXfPageWithCategory	null	service	{"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"}	{}	476	insert
✅文章编辑-使用素材	xfPageEdit	importMaterial	null	service	{"service": "xfPage", "serviceFunction": "importMaterial"}	{}	477	insert
✅文章编辑-查询列表	xfPageEdit	selectCategoryList	null	sql	{"table": "view01_category", "operation": "select"}	{}	478	insert
✅文章编辑-添加成员	xfPageEdit	jhInsertItem	{ "before": [ { "service": "xfPage", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook" }, { "service": "xfPage", "serviceFunction": "insertItemAfterHook" } ] }	sql	{"table": "xf_page", "operation": "jhInsert"}	{}	479	jhInsert
✅文章编辑-查询文章列表	xfPageEdit	selectItemList	null	sql	{"table": "xf_page", "operation": "select"}	{}	480	jhInsert
✅文章编辑-更新成员	xfPageEdit	jhUpdateItem	{ "before": [ { "service": "xfPage", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "xfPage", "serviceFunction": "xfPageHistoryRecordAfterHook" } ] }	sql	{"table": "xf_page", "operation": "jhUpdate"}	{}	481	insert
✅文章编辑-将文章移至回收站	xfPageEdit	deletedItem		service	{"service": "xfPage", "serviceFunction": "deletedXfPage"}	{}	482	insert
✅文章编辑-文章恢复	xfPageEdit	restoreItem	null	service	{"service": "xfPage", "serviceFunction": "restoreXfPage"}	{}	483	insert

xf页面列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
xf页面列表	xfPageList	showInMenu	null	5	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

接口信息

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

xf文章历史

页面信息

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

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅xfPageHistoryManagement查询-查询列表	xfPageHistory	selectItemList	null	sql	{"table": "xf_page_history", "operation": "select"}	{}	491	insert
✅xfPageHistoryManagement查询-添加成员	xfPageHistory	insertItem	null	sql	{"table": "xf_page_history", "operation": "insert"}	{}	492	insert
✅xfPageHistoryManagement查询-更新成员	xfPageHistory	updateItem	null	sql	{"table": "xf_page_history", "operation": "jhUpdate"}	{}	493	insert
✅xfPageHistoryManagement查询-删除信息	xfPageHistory	deleteItem	null	sql	{"table": "xf_page_history", "operation": "jhDelete"}	{}	496	insert

UI配置

页面信息

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

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅constantUiManagement查询-查询列表	constantUiList	selectItemList	null	sql	{"table": "web_constant_ui", "operation": "select"}	{}	505	insert
✅constantUiManagement查询-添加成员	constantUiList	insertItem	null	sql	{"table": "web_constant_ui", "operation": "insert"}	{}	506	insert
✅constantUiManagement查询-更新成员	constantUiList	updateItem	null	sql	{"table": "web_constant_ui", "operation": "jhUpdate"}	{}	507	insert
✅constantUiManagement查询-删除信息	constantUiList	deleteItem	null	sql	{"table": "web_constant_ui", "operation": "jhDelete"}	{}	508	insert

日历管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
日历管理	calendarManagement	showInMenu	null	5	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	calendarManagement	selectItemList	null	sql	{ "table": "calendar", "operation": "select" }	{}	529	insert
✅添加	calendarManagement	insertItem	null	sql	{ "table": "calendar", "operation": "insert" }	{}	530	insert
✅更新	calendarManagement	updateItem	null	sql	{ "table": "calendar", "operation": "jhUpdate" }	{}	531	insert
✅删除	calendarManagement	deleteItem	null	sql	{ "table": "calendar", "operation": "jhDelete" }	{}	532	insert

日历事件管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
日历事件管理	calendarEvent	dynamicInMenu	null	null	null

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', '', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'categoryList', '分类列表', NULL, 'showInMenu', '1', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'articleList', '文章列表', NULL, 'showInMenu', '2', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (33, 'userList', '用户列表', NULL, 'showInMenu', '6', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', NULL, NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 'article', '文章详情', NULL, 'seo', NULL, '{
  "beforeHook":[
    {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'resetUserPassword', '修改密码', NULL, 'showInMenu', '11', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'materialList', '素材列表', NULL, 'showInMenu', '5', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'articleEdit', '文章编辑', NULL, 'dynamicInMenu', NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'articleHistory', '文章历史版本', NULL, 'dynamicInMenu', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'xfPageEdit', 'xf页面编辑', NULL, 'dynamicInMenu', NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', '', 'insert', NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'xfPageList', 'xf页面列表', NULL, 'showInMenu', '5', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'xfPageHistory', 'xf文章历史', NULL, 'dynamicInMenu', '5', '', 'update', 'vscode', 'vscode', '2022-06-17T09:10:36+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (82, 'constantUiList', 'UI配置', NULL, 'showInMenu', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'calendarManagement', '日历管理', NULL, 'showInMenu', '5', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (84, 'calendarEvent', '日历事件管理', NULL, 'dynamicInMenu', NULL, NULL, 'insert', NULL, NULL, NULL);

# 页面总览

## _page结构

```sql
CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255)  DEFAULT NULL,
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `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 = 85 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'
```

## 帮助

- **页面信息**

| 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 | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | login | passwordLogin | null | service | { "service": "user", "serviceFunction": "passwordLogin" } |  | {} | 231 | insert |  |  |  |  |  |

## 分类列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 分类列表 | categoryList | showInMenu | null | 1 | {
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
} |

- **接口信息**

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

## 文章列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 文章列表 | articleList | showInMenu | null | 2 | {
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
} |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章管理-查询列表 | articleList | selectItemList | null | sql | { "table": "view01_article", "operation": "select" } |  | {} | 327 | jhInsert |  |  |  |  |  |
| ✅文章管理-查询分类列表 | articleList | selectCategoryList | null | sql | { "table": "view01_category", "operation": "select" } |  | {} | 331 | insert |  |  |  |  |  |
| ✅文章编辑-将文章移至回收站 | articleList | deletedArticle | null | service | { "service": "article", "serviceFunction": "deletedArticle" } |  | {} | 332 | insert |  |  |  |  |  |
| ✅文章编辑-文章恢复 | articleList | restoreArticle | null | service | { "service": "article", "serviceFunction": "restoreArticle" } |  | {} | 333 | insert |  |  |  |  |  |

## 用户列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 用户列表 | userList | showInMenu | null | 6 | {
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
} |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅用户管理-查询信息 | userList | selectItemList | null | sql | { "table": "_user", "operation": "select" } |  |  | 354 | 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"}} |
| ✅用户管理-查询信息 | userList | insertItem | null | service | { "service": "userManagement", "serviceFunction": "addUser" } |  |  | 355 | update | 2022-02-18T20:19:24+08:00 |  |  |  |  |
| ✅用户管理-修改密码 | userList | resetUserPassword | null | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  |  | 356 | 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"}} |
| ✅用户管理-更新用户 | userList | updateItem | null | sql | { "table": "_user", "operation": "jhUpdate" } |  |  | 357 | 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"}
  ]
} |

## 修改密码

- **页面信息**

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

## 素材列表

- **页面信息**

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

## 文章编辑

- **页面信息**

| 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 | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章编辑-查询文章详情 | articleEdit | selectArticleInfo | null | service | { "service": "article", "serviceFunction": "getArticleAndFillArticles" } |  | {} | 381 | insert |  |  |  |  |  |
| ✅文章编辑-导入素材 | articleEdit | importMaterial | null | service | { "service": "article", "serviceFunction": "importMaterial" } |  | {} | 382 | insert |  |  |  |  |  |
| ✅文章编辑-查询列表 | articleEdit | selectCategoryList | null | sql | { "table": "view01_category", "operation": "select" } |  | {} | 383 | insert |  |  |  |  |  |
| ✅文章编辑-添加成员 | articleEdit | jhInsertItem | {   "before": [     {       "service": "article",       "serviceFunction": "fillInsertItemParamsBeforeHook"     },     {       "service": "articleParser",       "serviceFunction": "parseJhTags"     }   ],   "after": [     {       "service": "article",       "serviceFunction": "insertItemAfterHook"     }   ] } | sql | { "table": "article", "operation": "jhInsert" } |  | {} | 385 | jhInsert |  |  |  |  |  |
| ✅文章编辑-查询文章列表 | articleEdit | selectItemList | null | sql | { "table": "article", "operation": "select" } |  | {} | 386 | jhInsert |  |  |  |  |  |
| ✅文章编辑-更新成员 | articleEdit | jhUpdateItem | {   "before": [     {       "service": "article",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     },     {       "service": "articleParser",       "serviceFunction": "parseJhTags"     }   ],   "after": [] } | sql | { "table": "article", "operation": "jhUpdate" } |  | {} | 387 | insert |  |  |  |  |  |
| ✅文章编辑-将文章移至回收站 | articleEdit | deletedArticle |  | service | { "service": "article", "serviceFunction": "deletedArticle" } |  | {} | 388 | insert |  |  |  |  |  |
| ✅文章编辑-文章恢复 | articleEdit | restoreArticle | null | service | { "service": "article", "serviceFunction": "restoreArticle" } |  | {} | 389 | insert |  |  |  |  |  |

## 文章历史版本

- **页面信息**

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

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章历史版本管理-恢复版本 | articleHistory | selectItemList | null | sql | { "table": "article_history", "operation": "select" } |  | {} | 411 | insert |  |  |  |  |  |
| ✅文章历史版本管理-恢复版本 | articleHistory | jhUpdateArticleItem | null | service | { "table": "article", "operation": "jhUpdate" } |  | {} | 412 | 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 | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅文章编辑-查询带文集信息的文章 | xfPageEdit | selectXfPageWithCategory | null | service | {"service": "xfPage", "serviceFunction": "getXfPageAndFillArticles"} |  | {} | 476 | insert |  |  |  |  |  |
| ✅文章编辑-使用素材 | xfPageEdit | importMaterial | null | service | {"service": "xfPage", "serviceFunction": "importMaterial"} |  | {} | 477 | insert |  |  |  |  |  |
| ✅文章编辑-查询列表 | xfPageEdit | selectCategoryList | null | sql | {"table": "view01_category", "operation": "select"} |  | {} | 478 | insert |  |  |  |  |  |
| ✅文章编辑-添加成员 | xfPageEdit | jhInsertItem | {   "before": [     {       "service": "xfPage",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [     {       "service": "xfPage",       "serviceFunction": "xfPageHistoryRecordAfterHook"     },     {       "service": "xfPage",       "serviceFunction": "insertItemAfterHook"     }   ] } | sql | {"table": "xf_page", "operation": "jhInsert"} |  | {} | 479 | jhInsert |  |  |  |  |  |
| ✅文章编辑-查询文章列表 | xfPageEdit | selectItemList | null | sql | {"table": "xf_page", "operation": "select"} |  | {} | 480 | jhInsert |  |  |  |  |  |
| ✅文章编辑-更新成员 | xfPageEdit | jhUpdateItem | {   "before": [     {       "service": "xfPage",       "serviceFunction": "fillUpdateItemParamsBeforeHook"     }   ],   "after": [     {       "service": "xfPage",       "serviceFunction": "xfPageHistoryRecordAfterHook"     }   ] } | sql | {"table": "xf_page", "operation": "jhUpdate"} |  | {} | 481 | insert |  |  |  |  |  |
| ✅文章编辑-将文章移至回收站 | xfPageEdit | deletedItem |  | service | {"service": "xfPage", "serviceFunction": "deletedXfPage"} |  | {} | 482 | insert |  |  |  |  |  |
| ✅文章编辑-文章恢复 | xfPageEdit | restoreItem | null | service | {"service": "xfPage", "serviceFunction": "restoreXfPage"} |  | {} | 483 | insert |  |  |  |  |  |

## xf页面列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| xf页面列表 | xfPageList | showInMenu | null | 5 | {
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
} |

- **接口信息**

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

## xf文章历史

- **页面信息**

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

- **接口信息**

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

## UI配置

- **页面信息**

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

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅constantUiManagement查询-查询列表 | constantUiList | selectItemList | null | sql | {"table": "web_constant_ui", "operation": "select"} |  | {} | 505 | insert |  |  |  |  |  |
| ✅constantUiManagement查询-添加成员 | constantUiList | insertItem | null | sql | {"table": "web_constant_ui", "operation": "insert"} |  | {} | 506 | insert |  |  |  |  |  |
| ✅constantUiManagement查询-更新成员 | constantUiList | updateItem | null | sql | {"table": "web_constant_ui", "operation": "jhUpdate"} |  | {} | 507 | insert |  |  |  |  |  |
| ✅constantUiManagement查询-删除信息 | constantUiList | deleteItem | null | sql | {"table": "web_constant_ui", "operation": "jhDelete"} |  | {} | 508 | insert |  |  |  |  |  |

## 日历管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 日历管理 | calendarManagement | showInMenu | null | 5 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | calendarManagement | selectItemList | null | sql | { "table": "calendar", "operation": "select" } |  | {} | 529 | insert |  |  |  |  |  |
| ✅添加 | calendarManagement | insertItem | null | sql | { "table": "calendar", "operation": "insert" } |  | {} | 530 | insert |  |  |  |  |  |
| ✅更新 | calendarManagement | updateItem | null | sql | { "table": "calendar", "operation": "jhUpdate" } |  | {} | 531 | insert |  |  |  |  |  |
| ✅删除 | calendarManagement | deleteItem | null | sql | { "table": "calendar", "operation": "jhDelete" } |  | {} | 532 | insert |  |  |  |  |  |

## 日历事件管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 日历事件管理 | calendarEvent | dynamicInMenu | null | null | null |

## _page语句

```sql
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', '', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'categoryList', '分类列表', NULL, 'showInMenu', '1', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'articleList', '文章列表', NULL, 'showInMenu', '2', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (33, 'userList', '用户列表', NULL, 'showInMenu', '6', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', NULL, NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 'article', '文章详情', NULL, 'seo', NULL, '{
  "beforeHook":[
    {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'resetUserPassword', '修改密码', NULL, 'showInMenu', '11', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'materialList', '素材列表', NULL, 'showInMenu', '5', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'articleEdit', '文章编辑', NULL, 'dynamicInMenu', NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'articleHistory', '文章历史版本', NULL, 'dynamicInMenu', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'xfPageEdit', 'xf页面编辑', NULL, 'dynamicInMenu', NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', '', 'insert', NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'xfPageList', 'xf页面列表', NULL, 'showInMenu', '5', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'xfPageHistory', 'xf文章历史', NULL, 'dynamicInMenu', '5', '', 'update', 'vscode', 'vscode', '2022-06-17T09:10:36+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (82, 'constantUiList', 'UI配置', NULL, 'showInMenu', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'calendarManagement', '日历管理', NULL, 'showInMenu', '5', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (84, 'calendarEvent', '日历事件管理', NULL, 'dynamicInMenu', NULL, NULL, 'insert', NULL, NULL, NULL);
```