页面

12126

页面总览

_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',
  `pageIcon` text,
  `pageHook` varchar(255) DEFAULT NULL,
  `sort` varchar(255) DEFAULT NULL,
  `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 = 90 DEFAULT CHARSET = utf8mb4 COMMENT = '页面表;'

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	1	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" }		{}	299	update	2022-03-12T21:41:08+08:00

聊天

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
聊天	index	showInMenu	null	1	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	index	getUserSession	null	sql	{ "table": "_user_session", "operation": "select" }			720	insert

客服管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
客服管理	agentManagement	showInMenu	null	2	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation	operationAt
✅查询用户列表	agentManagement	getItemList	null	sql	{ "table": "_user", "operation": "select" }	{}	339	update	2022-03-05T21:44:23+08:00
✅ 插入新用户	agentManagement	addUser	null	service	{ "service": "userManagement", "serviceFunction": "addUser" }	{}	340	insert
✅ 更新用户	agentManagement	setItem	null	sql	{ "table": "_user", "operation": "jhUpdate" }	{}	341	insert
✅重新设置用户密码	agentManagement	resetUserPassword	null	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	{}	343	insert

数据历史

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
数据历史	recordHistoryManagement	showInMenu	null	5	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	operation	operationAt
✅获取指定表的使用中的数据列表	recordHistoryManagement	selectOnUseItemListByTable	null	service	{ "service": "recordHistory", "serviceFunction": "selectOnUseItemListByTable" }	347	update	2022-02-21T19:58:23+08:00
✅获取指定表的已删除的数据列表	recordHistoryManagement	selectDeletedItemListByTable	null	service	{ "service": "recordHistory", "serviceFunction": "selectDeletedItemListByTable" }	348	update	2022-02-21T19:58:21+08:00
✅获取数据历史表	recordHistoryManagement	selectItemList	null	sql	{ "table": "_record_history", "operation": "select" }	349	update	2022-02-21T19:58:30+08:00
✅还原数据	recordHistoryManagement	restoreRecordByRecordHistory	null	service	{ "service": "recordHistory", "serviceFunction": "restoreRecordByRecordHistory" }	350	update	2022-02-21T00:47:08+08:00

访客

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
访客	visitor	dynamicInMenu	null		{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅ 访客留言	visitor	sendVisitorTicket	null	service	{ "service": "visitor", "serviceFunction": "visitorTicket" }	{}	701	insert
✅ 获取客服在线状态	visitor	getAgentOnlineStatus	null	service	{ "service": "visitor", "serviceFunction": "getAgentOnlineStatus" }		703	insert
✅ 游客登录	visitor	visitorLogin	null	service	{ "service": "visitor", "serviceFunction": "visitorLogin" }		704	insert
✅ 更新游客信息	visitor	updateItem	null	sql	{ "table": "visitor", "operation": "jhUpdate" }		706	insert
✅ 留言列表【包含用户名】	visitor	getVisitorTicketList	null	sql	{ "table": "view01_visitor_ticket", "operation": "select" }	{}	722	insert

test

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
test	test	dynamicInMenu	null		null

留言管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
留言管理	visitorTicketManagement	showInMenu	null	4	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅ 留言列表	visitorTicketManagement	getVisitorTicketList	null	sql	{ "table": "visitor_ticket", "operation": "select" }		{}	702	insert
✅ 更新留言已读状态	visitorTicketManagement	updateTicketReadStatus	null	sql	{ "table": "visitor_ticket", "operation": "jhUpdate" }			705	insert

访客资料

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
访客资料	visitorManagement	showInMenu	null	3	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询访客列表	visitorManagement	getItemList	null	sql	{ "table": "visitor", "operation": "select" }		{}	712	update	2022-03-05T21:44:23+08:00
✅ 更新访客信息	visitorManagement	updateVisitor	null	service	{ "service": "visitor", "serviceFunction": "updateVisitor" }		{}	723	insert

test-old

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
test-old	test-old	null	null	null	null

test02

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
test02	test02	dynamicInMenu	null		null

test03

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
test03	test03	dynamicInMenu	null		null

test04

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
test04	test04	dynamicInMenu	null		null

ui配置信息

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
ui配置信息	constantUiList	showInMenu	null	5	null

接口信息

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

编辑ui配置信息

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
编辑ui配置信息	constantUiEditor	dynamicInMenu	null	5	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅ui配置编辑-查询列表	constantUiEditor	getItemInfo	null	sql	{ "table": "web_constant_ui", "operation": "select" }	{}	725	insert
✅ui配置编辑-添加数据	constantUiEditor	insertItem	null	sql	{ "table": "web_constant_ui", "operation": "insert" }	{}	726	insert
✅ui配置编辑-更新数据	constantUiEditor	updateItem	null	sql	{ "table": "web_constant_ui", "operation": "jhUpdate" }	{}	727	insert

通知/待办

页面信息

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

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', NULL, NULL, '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'index', '聊天', NULL, 'showInMenu', NULL, NULL, '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'agentManagement', '客服管理', NULL, 'showInMenu', NULL, NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'recordHistoryManagement', '数据历史', NULL, 'showInMenu', NULL, NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'visitor', '访客', NULL, 'dynamicInMenu', NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'test', 'test', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'visitorTicketManagement', '留言管理', NULL, 'showInMenu', NULL, NULL, '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'visitorManagement', '访客资料', NULL, 'showInMenu', NULL, NULL, '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'test-old', 'test-old', NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (43, 'test02', 'test02', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (44, 'test03', 'test03', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'test04', 'test04', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'constantUiList', 'ui配置信息', NULL, 'showInMenu', NULL, NULL, '5', 'update', 'vscode', 'vscode', '2022-06-29T15:14:09+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (47, 'constantUiEditor', '编辑ui配置信息', NULL, 'dynamicInMenu', NULL, NULL, '5', 'update', 'vscode', 'vscode', '2022-06-29T15:14:09+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (89, 'https://demo.jianghujs.org/task/page/noticeManagement', '通知/待办', NULL, '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, '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',
  `pageIcon` text,
  `pageHook` varchar(255) DEFAULT NULL,
  `sort` varchar(255) DEFAULT NULL,
  `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 = 90 DEFAULT CHARSET = utf8mb4 COMMENT = '页面表;'
```

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | help | dynamicInMenu | helpV4 | 1 | 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" } |  | {} | 299 | update | 2022-03-12T21:41:08+08:00 |  |  |  |  |

## 聊天

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 聊天 | index | showInMenu | null | 1 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | index | getUserSession | null | sql | { "table": "_user_session", "operation": "select" } |  |  | 720 | insert |  |  |  |  |  |

## 客服管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 客服管理 | agentManagement | showInMenu | null | 2 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询用户列表 | agentManagement | getItemList | null | sql | { "table": "_user", "operation": "select" } |  | {} | 339 | update | 2022-03-05T21:44:23+08:00 |  |  |  |  |
| ✅ 插入新用户 | agentManagement | addUser | null | service | { "service": "userManagement", "serviceFunction": "addUser" } |  | {} | 340 | insert |  |  |  |  |  |
| ✅ 更新用户 | agentManagement | setItem | null | sql | { "table": "_user", "operation": "jhUpdate" } |  | {} | 341 | insert |  |  |  |  |  |
| ✅重新设置用户密码 | agentManagement | resetUserPassword | null | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  | {} | 343 | insert |  |  |  |  |  |

## 数据历史

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 数据历史 | recordHistoryManagement | showInMenu | null | 5 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅获取指定表的使用中的数据列表 | recordHistoryManagement | selectOnUseItemListByTable | null | service | { "service": "recordHistory", "serviceFunction": "selectOnUseItemListByTable" } |  |  | 347 | update | 2022-02-21T19:58:23+08:00 |  |  |  |  |
| ✅获取指定表的已删除的数据列表 | recordHistoryManagement | selectDeletedItemListByTable | null | service | { "service": "recordHistory", "serviceFunction": "selectDeletedItemListByTable" } |  |  | 348 | update | 2022-02-21T19:58:21+08:00 |  |  |  |  |
| ✅获取数据历史表 | recordHistoryManagement | selectItemList | null | sql | { "table": "_record_history", "operation": "select" } |  |  | 349 | update | 2022-02-21T19:58:30+08:00 |  |  |  |  |
| ✅还原数据 | recordHistoryManagement | restoreRecordByRecordHistory | null | service | { "service": "recordHistory", "serviceFunction": "restoreRecordByRecordHistory" } |  |  | 350 | update | 2022-02-21T00:47:08+08:00 |  |  |  |  |

## 访客

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 访客 | visitor | dynamicInMenu | null |  | {   "beforeHook": [     {       "field": "constantUiMap",       "service": "constantUi",       "serviceFunc": "getConstantUiMap"     }   ] } |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅ 访客留言 | visitor | sendVisitorTicket | null | service | { "service": "visitor", "serviceFunction": "visitorTicket" } |  | {} | 701 | insert |  |  |  |  |  |
| ✅ 获取客服在线状态 | visitor | getAgentOnlineStatus | null | service | { "service": "visitor", "serviceFunction": "getAgentOnlineStatus" } |  |  | 703 | insert |  |  |  |  |  |
|  ✅ 游客登录 | visitor | visitorLogin | null | service | { "service": "visitor", "serviceFunction": "visitorLogin" } |  |  | 704 | insert |  |  |  |  |  |
| ✅ 更新游客信息 | visitor | updateItem | null | sql | { "table": "visitor", "operation": "jhUpdate" } |  |  | 706 | insert |  |  |  |  |  |
| ✅ 留言列表【包含用户名】 | visitor | getVisitorTicketList | null | sql | { "table": "view01_visitor_ticket", "operation": "select" } |  | {} | 722 | insert |  |  |  |  |  |

## test

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| test | test | dynamicInMenu | null |  | null |

## 留言管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 留言管理 | visitorTicketManagement | showInMenu | null | 4 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅ 留言列表 | visitorTicketManagement | getVisitorTicketList | null | sql | { "table": "visitor_ticket", "operation": "select" } |  | {} | 702 | insert |  |  |  |  |  |
| ✅ 更新留言已读状态 | visitorTicketManagement | updateTicketReadStatus | null | sql | { "table": "visitor_ticket", "operation": "jhUpdate" } |  |  | 705 | insert |  |  |  |  |  |

## 访客资料

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 访客资料 | visitorManagement | showInMenu | null | 3 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询访客列表 | visitorManagement | getItemList | null | sql | { "table": "visitor", "operation": "select" } |  | {} | 712 | update | 2022-03-05T21:44:23+08:00 |  |  |  |  |
| ✅ 更新访客信息 | visitorManagement | updateVisitor | null | service | { "service": "visitor", "serviceFunction": "updateVisitor" } |  | {} | 723 | insert |  |  |  |  |  |

## test-old

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| test-old | test-old | null | null | null | null |

## test02

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| test02 | test02 | dynamicInMenu | null |  | null |

## test03

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| test03 | test03 | dynamicInMenu | null |  | null |

## test04

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| test04 | test04 | dynamicInMenu | null |  | null |

## ui配置信息

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| ui配置信息 | constantUiList | showInMenu | null | 5 | null |

- **接口信息**

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

## 编辑ui配置信息

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 编辑ui配置信息 | constantUiEditor | dynamicInMenu | null | 5 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅ui配置编辑-查询列表 | constantUiEditor | getItemInfo | null | sql | { "table": "web_constant_ui", "operation": "select" } |  | {} | 725 | insert |  |  |  |  |  |
| ✅ui配置编辑-添加数据 | constantUiEditor | insertItem | null | sql | { "table": "web_constant_ui", "operation": "insert" } |  | {} | 726 | insert |  |  |  |  |  |
| ✅ui配置编辑-更新数据 | constantUiEditor | updateItem | null | sql | { "table": "web_constant_ui", "operation": "jhUpdate" } |  | {} | 727 | insert |  |  |  |  |  |

## 通知/待办

- **页面信息**

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

## _page语句

```sql
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', NULL, NULL, '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'index', '聊天', NULL, 'showInMenu', NULL, NULL, '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'agentManagement', '客服管理', NULL, 'showInMenu', NULL, NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'recordHistoryManagement', '数据历史', NULL, 'showInMenu', NULL, NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'visitor', '访客', NULL, 'dynamicInMenu', NULL, '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'test', 'test', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'visitorTicketManagement', '留言管理', NULL, 'showInMenu', NULL, NULL, '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'visitorManagement', '访客资料', NULL, 'showInMenu', NULL, NULL, '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'test-old', 'test-old', NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (43, 'test02', 'test02', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (44, 'test03', 'test03', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'test04', 'test04', NULL, 'dynamicInMenu', NULL, NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'constantUiList', 'ui配置信息', NULL, 'showInMenu', NULL, NULL, '5', 'update', 'vscode', 'vscode', '2022-06-29T15:14:09+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (47, 'constantUiEditor', '编辑ui配置信息', NULL, 'dynamicInMenu', NULL, NULL, '5', 'update', 'vscode', 'vscode', '2022-06-29T15:14:09+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, pageHook, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (89, 'https://demo.jianghujs.org/task/page/noticeManagement', '通知/待办', NULL, '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, 'insert', NULL, NULL, NULL);
```