接口

12120

接口总览

_resource结构

CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  `appDataSchema` text COMMENT 'appData 参数校验',
  `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 729 DEFAULT CHARSET = utf8mb4 COMMENT = '请求资源表; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
101	✅ 文件分片下载-获取分片信息	allPage	getChunkInfo	service	null	{ "service": "file", "serviceFunction": "getChunkInfo" }
102	✅ 文件分片上传-所有分片上传完毕	allPage	uploadFileDone	service	null	{ "service": "file", "serviceFunction": "uploadFileDone" }
105	✅ 文件分片上传-http文件流	allPage	httpUploadByStream	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }
106	✅ 文件分片上传-http base64	allPage	httpUploadByBase64	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
107	✅ 文件分片上传-socket 文件流	allPage	socketUploadByStream	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByBuffer" }
108	✅ 文件分片上传-socket base64	allPage	socketUploadByBase64	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
112	✅ 文件分片下载-http base64	allPage	httpDownloadByBase64	service	null	{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
113	✅ 文件分片下载-socket文件流	allPage	socketDownloadByStream	service	null	{ "service": "file", "serviceFunction": "downloadFileChunkByBuffer" }
114	✅ 文件分片下载-socket base64	allPage	socketDownloadByBase64	service	null	{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
299	✅ 密码登录	login	passwordLogin	service	null	{ "service": "user", "serviceFunction": "passwordLogin" }
301	✅ 获取全局常量	allPage	getConstantList	sql	null	{ "table": "_constant", "operation": "select" }
302	✅ 用户信息	allPage	userInfo	service	null	{ "service": "user", "serviceFunction": "userInfo" }
303	✅ 上传base64的文件	allPage	uploadByBase64	service	null	{ "service": "file", "serviceFunction": "uploadByBase64" }
304	✅ 上传流文件	allPage	uploadByStream	service	null	{ "service": "file", "serviceFunction": "uploadByStream" }
305	✅ 退出登录	allPage	logout	service	null	{ "service": "user", "serviceFunction": "logout" }
332	✅ 设置用户信息	user	setUserDetail	service	null	{ "service": "duoxingUser", "serviceFunction": "setUserDetail" }
334	✅ 修改用户密码	user	resetPassword	service	null	{ "service": "user", "serviceFunction": "resetPassword" }
339	✅查询用户列表	agentManagement	getItemList	sql	null	{ "table": "_user", "operation": "select" }
340	✅ 插入新用户	agentManagement	addUser	service	null	{ "service": "userManagement", "serviceFunction": "addUser" }
341	✅ 更新用户	agentManagement	setItem	sql	null	{ "table": "_user", "operation": "jhUpdate" }
343	✅重新设置用户密码	agentManagement	resetUserPassword	service	null	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
347	✅获取指定表的使用中的数据列表	recordHistoryManagement	selectOnUseItemListByTable	service	null	{ "service": "recordHistory", "serviceFunction": "selectOnUseItemListByTable" }
348	✅获取指定表的已删除的数据列表	recordHistoryManagement	selectDeletedItemListByTable	service	null	{ "service": "recordHistory", "serviceFunction": "selectDeletedItemListByTable" }
349	✅获取数据历史表	recordHistoryManagement	selectItemList	sql	null	{ "table": "_record_history", "operation": "select" }
350	✅还原数据	recordHistoryManagement	restoreRecordByRecordHistory	service	null	{ "service": "recordHistory", "serviceFunction": "restoreRecordByRecordHistory" }
351	✅ 查询用户信息	chat	getUserInfo	sql	null	{ "table": "_view02_user", "operation": "select" }
367	✅ 会话列表	chat	getChatSession	service	null	{ "service": "duoxingMessage", "serviceFunction": "getChatSession" }
368	✅ 消息列表[往历史找]	chat	getMessageHistory	service	null	{ "service": "duoxingMessage", "serviceFunction": "getMessageHistory" }
369	✅ 消息列表[往最新找]	chat	getMessageHistoryByMaxId	service	null	{ "service": "duoxingMessage", "serviceFunction": "getMessageHistory" }
370	✅ 撤回消息	chat	revokeMessage	service	null	{ "service": "duoxingMessage", "serviceFunction": "revokeMessage" }
371	✅ 删除离线消息	chat	delMessageOffline	service	null	{ "service": "duoxingMessage", "serviceFunction": "delMessageOffline" }
374	✅ 置顶会话	chat	toggleChatSession	service	null	{ "service": "duoxingMessage", "serviceFunction": "toggleChatSession" }
375	✅ 删除会话	chat	deleteChatSession	service	null	{ "service": "duoxingMessage", "serviceFunction": "deleteChatSession" }
501	✅ socket 连接鉴权及创建会话	socket	connect	service		{ "service": "duoxingSocket", "serviceFunction": "connect" }
502	✅ socket 关闭连接	socket	disconnect	service	null	{ "service": "duoxingSocket", "serviceFunction": "disconnect" }
503	✅ socket 发送一对一聊天信息	socket	userSendMessageToUser	service	null	{ "service": "duoxingSocket", "serviceFunction": "userSendMessageToUser" }
504	✅ socket 发送群聊天信息	socket	userSendMessageToRoom	service	null	{ "service": "duoxingSocket", "serviceFunction": "userSendMessageToRoom" }
505	✅constantUiList-查询列表	constantUiList	selectItemList	sql	null	{ "table": "web_constant_ui", "operation": "select" }
506	✅constantUiList-添加成员	constantUiList	insertItem	sql	null	{ "table": "web_constant_ui", "operation": "insert" }
507	✅constantUiList-更新成员	constantUiList	updateItem	sql	null	{ "table": "web_constant_ui", "operation": "jhUpdate" }
508	✅constantUiList-删除信息	constantUiList	deleteItem	sql	null	{ "table": "web_constant_ui", "operation": "jhDelete" }
701	✅ 访客留言	visitor	sendVisitorTicket	service	null	{ "service": "visitor", "serviceFunction": "visitorTicket" }
702	✅ 留言列表	visitorTicketManagement	getVisitorTicketList	sql	null	{ "table": "visitor_ticket", "operation": "select" }
703	✅ 获取客服在线状态	visitor	getAgentOnlineStatus	service	null	{ "service": "visitor", "serviceFunction": "getAgentOnlineStatus" }
704	✅ 游客登录	visitor	visitorLogin	service	null	{ "service": "visitor", "serviceFunction": "visitorLogin" }
705	✅ 更新留言已读状态	visitorTicketManagement	updateTicketReadStatus	sql	null	{ "table": "visitor_ticket", "operation": "jhUpdate" }
706	✅ 更新游客信息	visitor	updateItem	sql	null	{ "table": "visitor", "operation": "jhUpdate" }
707	✅ 获取未接待的游客聊天列表	chat	getUnassignedRoomList	service	null	{ "service": "agent", "serviceFunction": "getUnassignedRoomList" }
708	✅ 获取自己接待的群组列表	chat	getMyRoomList	service	null	{ "service": "agent", "serviceFunction": "getMyRoomList" }
709	✅ 获取已接待的聊天列表	chat	getAssignedGroupList	service	null	{ "service": "agent", "serviceFunction": "getAssignedRoomList" }
710	✅ 客服主动接待访客	chat	checkAndReceiptVisitor	service	null	{ "service": "agent", "serviceFunction": "checkAndReceiptVisitor" }
711	✅ 获取群信息（群成员列表）	chat	getRoomInfo	service	{ "before": [ { "service": "duoxingRoom", "serviceFunction": "roomOpeartionBeforeHook" } ], "after": [] }	{ "service": "duoxingRoom", "serviceFunction": "getRoomInfo" }
712	✅查询访客列表	visitorManagement	getItemList	sql	null	{ "table": "visitor", "operation": "select" }
720		index	getUserSession	sql	null	{ "table": "_user_session", "operation": "select" }
722	✅ 留言列表【包含用户名】	visitor	getVisitorTicketList	sql	null	{ "table": "view01_visitor_ticket", "operation": "select" }
723	✅ 更新访客信息	visitorManagement	updateVisitor	service	null	{ "service": "visitor", "serviceFunction": "updateVisitor" }
724	✅ 清除聊天消息未读，消息已读	chat	cleanChatSessionUnreadCount	service	null	{ "service": "duoxingMessage", "serviceFunction": "cleanChatSessionUnreadCount" }
725	✅ui配置编辑-查询列表	constantUiEditor	getItemInfo	sql	null	{ "table": "web_constant_ui", "operation": "select" }
726	✅ui配置编辑-添加数据	constantUiEditor	insertItem	sql	null	{ "table": "web_constant_ui", "operation": "insert" }
727	✅ui配置编辑-更新数据	constantUiEditor	updateItem	sql	null	{ "table": "web_constant_ui", "operation": "jhUpdate" }
728	✅ 获取访客统计信息	chat	getVisitorStatistic	service	null	{ "service": "agent", "serviceFunction": "getVisitorStatistic" }

_resource语句

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (101, NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (102, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (105, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (106, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (107, NULL, NULL, 'allPage', 'socketUploadByStream', '✅ 文件分片上传-socket 文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBuffer" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (108, NULL, NULL, 'allPage', 'socketUploadByBase64', '✅ 文件分片上传-socket base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (112, NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (113, NULL, NULL, 'allPage', 'socketDownloadByStream', '✅ 文件分片下载-socket文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBuffer" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (114, NULL, NULL, 'allPage', 'socketDownloadByBase64', '✅ 文件分片下载-socket base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (299, NULL, NULL, 'login', 'passwordLogin', '✅ 密码登录', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'update', NULL, NULL, '2022-03-12T21:41:08+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (301, NULL, NULL, 'allPage', 'getConstantList', '✅ 获取全局常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:43+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (302, NULL, NULL, 'allPage', 'userInfo', '✅ 用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'update', NULL, NULL, '2022-03-05T21:44:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (303, NULL, NULL, 'allPage', 'uploadByBase64', '✅ 上传base64的文件', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:34:20+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (304, NULL, NULL, 'allPage', 'uploadByStream', '✅ 上传流文件', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (305, NULL, NULL, 'allPage', 'logout', '✅ 退出登录', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'update', NULL, NULL, '2022-03-12T21:41:03+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (332, NULL, NULL, 'user', 'setUserDetail', '✅ 设置用户信息', 'service', '{}', '{ "service": "duoxingUser", "serviceFunction": "setUserDetail" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (334, NULL, NULL, 'user', 'resetPassword', '✅ 修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (339, NULL, NULL, 'agentManagement', 'getItemList', '✅查询用户列表', 'sql', '{}', '{ "table": "_user", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-05T21:44:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (340, NULL, NULL, 'agentManagement', 'addUser', '✅ 插入新用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "addUser" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (341, NULL, NULL, 'agentManagement', 'setItem', '✅ 更新用户', 'sql', '{}', '{ "table": "_user", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (343, NULL, NULL, 'agentManagement', 'resetUserPassword', '✅重新设置用户密码', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (347, NULL, NULL, 'recordHistoryManagement', 'selectOnUseItemListByTable', '✅获取指定表的使用中的数据列表', 'service', NULL, '{ "service": "recordHistory", "serviceFunction": "selectOnUseItemListByTable" }', '', '', 'update', NULL, NULL, '2022-02-21T19:58:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (348, NULL, NULL, 'recordHistoryManagement', 'selectDeletedItemListByTable', '✅获取指定表的已删除的数据列表', 'service', NULL, '{ "service": "recordHistory", "serviceFunction": "selectDeletedItemListByTable" }', '', '', 'update', NULL, NULL, '2022-02-21T19:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (349, NULL, NULL, 'recordHistoryManagement', 'selectItemList', '✅获取数据历史表', 'sql', NULL, '{ "table": "_record_history", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-02-21T19:58:30+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (350, NULL, NULL, 'recordHistoryManagement', 'restoreRecordByRecordHistory', '✅还原数据', 'service', NULL, '{ "service": "recordHistory", "serviceFunction": "restoreRecordByRecordHistory" }', '', '', 'update', NULL, NULL, '2022-02-21T00:47:08+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (351, NULL, NULL, 'chat', 'getUserInfo', '✅ 查询用户信息', 'sql', '{}', '{ "table": "_view02_user", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:14+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (367, NULL, NULL, 'chat', 'getChatSession', '✅ 会话列表', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "getChatSession" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:13+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'chat', 'getMessageHistory', '✅ 消息列表[往历史找]', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "getMessageHistory" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:15+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'chat', 'getMessageHistoryByMaxId', '✅ 消息列表[往最新找]', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "getMessageHistory" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (370, NULL, NULL, 'chat', 'revokeMessage', '✅ 撤回消息', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "revokeMessage" }', '', '', 'update', NULL, NULL, '2022-03-12T21:07:46+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (371, NULL, NULL, 'chat', 'delMessageOffline', '✅ 删除离线消息', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "delMessageOffline" }', '', '', 'update', NULL, NULL, '2022-03-12T21:40:51+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (374, NULL, NULL, 'chat', 'toggleChatSession', '✅ 置顶会话', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "toggleChatSession" }', '', '', 'update', NULL, NULL, '2022-03-11T21:57:48+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (375, NULL, NULL, 'chat', 'deleteChatSession', '✅ 删除会话', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "deleteChatSession" }', '', '', 'update', NULL, NULL, '2022-03-10T20:57:28+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (501, NULL, '', 'socket', 'connect', '✅ socket 连接 鉴权及创建会话', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "connect" }', '', '', 'update', NULL, NULL, '2022-03-12T21:35:05+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (502, NULL, NULL, 'socket', 'disconnect', '✅ socket 关闭连接', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "disconnect" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (503, NULL, NULL, 'socket', 'userSendMessageToUser', '✅ socket 发送一对一聊天信息', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "userSendMessageToUser" }', '', '', 'update', NULL, NULL, '2022-03-12T21:08:02+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (504, NULL, NULL, 'socket', 'userSendMessageToRoom', '✅ socket 发送群聊天信息', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "userSendMessageToRoom" }', '', '', 'update', NULL, NULL, '2022-03-12T20:28:15+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (505, NULL, NULL, 'constantUiList', 'selectItemList', '✅constantUiList-查询列表', 'sql', '{}', '{"table": "web_constant_ui", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (506, NULL, NULL, 'constantUiList', 'insertItem', '✅constantUiList-添加成员', 'sql', '{}', '{"table": "web_constant_ui", "operation": "insert"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (507, NULL, NULL, 'constantUiList', 'updateItem', '✅constantUiList-更新成员', 'sql', '{}', '{"table": "web_constant_ui", "operation": "jhUpdate"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (508, NULL, NULL, 'constantUiList', 'deleteItem', '✅constantUiList-删除信息', 'sql', '{}', '{"table": "web_constant_ui", "operation": "jhDelete"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (701, NULL, NULL, 'visitor', 'sendVisitorTicket', '✅ 访客留言', 'service', '{}', '{ "service": "visitor", "serviceFunction": "visitorTicket" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (702, NULL, NULL, 'visitorTicketManagement', 'getVisitorTicketList', '✅ 留言列表', 'sql', '{}', '{ "table": "visitor_ticket", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (703, NULL, NULL, 'visitor', 'getAgentOnlineStatus', '✅ 获取客服在线状态', 'service', NULL, '{ "service": "visitor", "serviceFunction": "getAgentOnlineStatus" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (704, NULL, NULL, 'visitor', 'visitorLogin', ' ✅ 游客登录', 'service', NULL, '{ "service": "visitor", "serviceFunction": "visitorLogin" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (705, NULL, NULL, 'visitorTicketManagement', 'updateTicketReadStatus', '✅ 更新留言已读状态', 'sql', NULL, '{ "table": "visitor_ticket", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (706, NULL, NULL, 'visitor', 'updateItem', '✅ 更新游客信息', 'sql', NULL, '{ "table": "visitor", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (707, NULL, NULL, 'chat', 'getUnassignedRoomList', '✅ 获取未接待的游客聊天列表', 'service', NULL, '{ "service": "agent", "serviceFunction": "getUnassignedRoomList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (708, NULL, NULL, 'chat', 'getMyRoomList', '✅ 获取自己接待的群组列表', 'service', NULL, '{ "service": "agent", "serviceFunction": "getMyRoomList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (709, NULL, NULL, 'chat', 'getAssignedGroupList', '✅ 获取已接待的聊天列表', 'service', NULL, '{ "service": "agent", "serviceFunction": "getAssignedRoomList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (710, NULL, NULL, 'chat', 'checkAndReceiptVisitor', '✅ 客服主动接待访客', 'service', NULL, '{ "service": "agent", "serviceFunction": "checkAndReceiptVisitor" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (711, NULL, '{ "before": [{ "service": "duoxingRoom", "serviceFunction": "roomOpeartionBeforeHook" }], "after": [] }', 'chat', 'getRoomInfo', '✅ 获取群信息（群成员列表）', 'service', '{}', '{ "service": "duoxingRoom", "serviceFunction": "getRoomInfo" }', NULL, NULL, 'update', NULL, NULL, '2022-03-12T21:41:25+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (712, NULL, NULL, 'visitorManagement', 'getItemList', '✅查询访客列表', 'sql', '{}', '{ "table": "visitor", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-05T21:44:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (720, NULL, NULL, 'index', 'getUserSession', NULL, 'sql', NULL, '{ "table": "_user_session", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (722, NULL, NULL, 'visitor', 'getVisitorTicketList', '✅ 留言列表【包含用户名】', 'sql', '{}', '{ "table": "view01_visitor_ticket", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (723, NULL, NULL, 'visitorManagement', 'updateVisitor', '✅ 更新访客信息', 'service', '{}', '{ "service": "visitor", "serviceFunction": "updateVisitor" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (724, NULL, NULL, 'chat', 'cleanChatSessionUnreadCount', '✅ 清除聊天消息未读，消息已读', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "cleanChatSessionUnreadCount" }', NULL, NULL, 'update', NULL, NULL, '2022-03-12T21:40:51+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (725, NULL, NULL, 'constantUiEditor', 'getItemInfo', '✅ui配置编辑-查询列表', 'sql', '{}', '{ "table": "web_constant_ui", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (726, NULL, NULL, 'constantUiEditor', 'insertItem', '✅ui配置编辑-添加数据', 'sql', '{}', '{ "table": "web_constant_ui", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (727, NULL, NULL, 'constantUiEditor', 'updateItem', '✅ui配置编辑-更新数据', 'sql', '{}', '{ "table": "web_constant_ui", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (728, NULL, NULL, 'chat', 'getVisitorStatistic', '✅ 获取访客统计信息', 'service', NULL, '{ "service": "agent", "serviceFunction": "getVisitorStatistic" }', NULL, NULL, 'insert', NULL, NULL, NULL);

## 接口总览

## _resource结构

```sql
CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  `appDataSchema` text COMMENT 'appData 参数校验',
  `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 729 DEFAULT CHARSET = utf8mb4 COMMENT = '请求资源表; resourceId=`${appId}.${pageId}.${actionId}`'
```

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 101 | ✅ 文件分片下载-获取分片信息 | allPage | getChunkInfo | service | null | {   "service": "file",   "serviceFunction": "getChunkInfo" } |
| 102 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service | null | {   "service": "file",   "serviceFunction": "uploadFileDone" } |
| 105 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByStream" } |
| 106 | ✅ 文件分片上传-http base64 | allPage | httpUploadByBase64 | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByBase64" } |
| 107 | ✅ 文件分片上传-socket 文件流 | allPage | socketUploadByStream | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByBuffer" } |
| 108 | ✅ 文件分片上传-socket base64 | allPage | socketUploadByBase64 | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByBase64" } |
| 112 | ✅ 文件分片下载-http base64 | allPage | httpDownloadByBase64 | service | null | {   "service": "file",   "serviceFunction": "downloadFileChunkByBase64" } |
| 113 | ✅ 文件分片下载-socket文件流 | allPage | socketDownloadByStream | service | null | {   "service": "file",   "serviceFunction": "downloadFileChunkByBuffer" } |
| 114 | ✅ 文件分片下载-socket base64 | allPage | socketDownloadByBase64 | service | null | {   "service": "file",   "serviceFunction": "downloadFileChunkByBase64" } |
| 299 | ✅ 密码登录 | login | passwordLogin | service | null | {   "service": "user",   "serviceFunction": "passwordLogin" } |
| 301 | ✅ 获取全局常量 | allPage | getConstantList | sql | null | {   "table": "_constant",   "operation": "select" } |
| 302 | ✅ 用户信息 | allPage | userInfo | service | null | {   "service": "user",   "serviceFunction": "userInfo" } |
| 303 | ✅ 上传base64的文件 | allPage | uploadByBase64 | service | null | {   "service": "file",   "serviceFunction": "uploadByBase64" } |
| 304 | ✅ 上传流文件 | allPage | uploadByStream | service | null | {   "service": "file",   "serviceFunction": "uploadByStream" } |
| 305 | ✅ 退出登录 | allPage | logout | service | null | {   "service": "user",   "serviceFunction": "logout" } |
| 332 | ✅ 设置用户信息 | user | setUserDetail | service | null | {   "service": "duoxingUser",   "serviceFunction": "setUserDetail" } |
| 334 | ✅ 修改用户密码 | user | resetPassword | service | null | {   "service": "user",   "serviceFunction": "resetPassword" } |
| 339 | ✅查询用户列表 | agentManagement | getItemList | sql | null | {   "table": "_user",   "operation": "select" } |
| 340 | ✅ 插入新用户 | agentManagement | addUser | service | null | {   "service": "userManagement",   "serviceFunction": "addUser" } |
| 341 | ✅ 更新用户 | agentManagement | setItem | sql | null | {   "table": "_user",   "operation": "jhUpdate" } |
| 343 | ✅重新设置用户密码 | agentManagement | resetUserPassword | service | null | {   "service": "userManagement",   "serviceFunction": "resetUserPassword" } |
| 347 | ✅获取指定表的使用中的数据列表 | recordHistoryManagement | selectOnUseItemListByTable | service | null | {   "service": "recordHistory",   "serviceFunction": "selectOnUseItemListByTable" } |
| 348 | ✅获取指定表的已删除的数据列表 | recordHistoryManagement | selectDeletedItemListByTable | service | null | {   "service": "recordHistory",   "serviceFunction": "selectDeletedItemListByTable" } |
| 349 | ✅获取数据历史表 | recordHistoryManagement | selectItemList | sql | null | {   "table": "_record_history",   "operation": "select" } |
| 350 | ✅还原数据 | recordHistoryManagement | restoreRecordByRecordHistory | service | null | {   "service": "recordHistory",   "serviceFunction": "restoreRecordByRecordHistory" } |
| 351 | ✅ 查询用户信息 | chat | getUserInfo | sql | null | {   "table": "_view02_user",   "operation": "select" } |
| 367 | ✅ 会话列表 | chat | getChatSession | service | null | {   "service": "duoxingMessage",   "serviceFunction": "getChatSession" } |
| 368 | ✅ 消息列表[往历史找] | chat | getMessageHistory | service | null | {   "service": "duoxingMessage",   "serviceFunction": "getMessageHistory" } |
| 369 | ✅ 消息列表[往最新找] | chat | getMessageHistoryByMaxId | service | null | {   "service": "duoxingMessage",   "serviceFunction": "getMessageHistory" } |
| 370 | ✅ 撤回消息 | chat | revokeMessage | service | null | {   "service": "duoxingMessage",   "serviceFunction": "revokeMessage" } |
| 371 | ✅ 删除离线消息 | chat | delMessageOffline | service | null | {   "service": "duoxingMessage",   "serviceFunction": "delMessageOffline" } |
| 374 | ✅ 置顶会话 | chat | toggleChatSession | service | null | {   "service": "duoxingMessage",   "serviceFunction": "toggleChatSession" } |
| 375 | ✅ 删除会话 | chat | deleteChatSession | service | null | {   "service": "duoxingMessage",   "serviceFunction": "deleteChatSession" } |
| 501 | ✅ socket 连接 鉴权及创建会话 | socket | connect | service |  | {   "service": "duoxingSocket",   "serviceFunction": "connect" } |
| 502 | ✅ socket 关闭连接 | socket | disconnect | service | null | {   "service": "duoxingSocket",   "serviceFunction": "disconnect" } |
| 503 | ✅ socket 发送一对一聊天信息 | socket | userSendMessageToUser | service | null | {   "service": "duoxingSocket",   "serviceFunction": "userSendMessageToUser" } |
| 504 | ✅ socket 发送群聊天信息 | socket | userSendMessageToRoom | service | null | {   "service": "duoxingSocket",   "serviceFunction": "userSendMessageToRoom" } |
| 505 | ✅constantUiList-查询列表 | constantUiList | selectItemList | sql | null | {   "table": "web_constant_ui",   "operation": "select" } |
| 506 | ✅constantUiList-添加成员 | constantUiList | insertItem | sql | null | {   "table": "web_constant_ui",   "operation": "insert" } |
| 507 | ✅constantUiList-更新成员 | constantUiList | updateItem | sql | null | {   "table": "web_constant_ui",   "operation": "jhUpdate" } |
| 508 | ✅constantUiList-删除信息 | constantUiList | deleteItem | sql | null | {   "table": "web_constant_ui",   "operation": "jhDelete" } |
| 701 | ✅ 访客留言 | visitor | sendVisitorTicket | service | null | {   "service": "visitor",   "serviceFunction": "visitorTicket" } |
| 702 | ✅ 留言列表 | visitorTicketManagement | getVisitorTicketList | sql | null | {   "table": "visitor_ticket",   "operation": "select" } |
| 703 | ✅ 获取客服在线状态 | visitor | getAgentOnlineStatus | service | null | {   "service": "visitor",   "serviceFunction": "getAgentOnlineStatus" } |
| 704 |  ✅ 游客登录 | visitor | visitorLogin | service | null | {   "service": "visitor",   "serviceFunction": "visitorLogin" } |
| 705 | ✅ 更新留言已读状态 | visitorTicketManagement | updateTicketReadStatus | sql | null | {   "table": "visitor_ticket",   "operation": "jhUpdate" } |
| 706 | ✅ 更新游客信息 | visitor | updateItem | sql | null | {   "table": "visitor",   "operation": "jhUpdate" } |
| 707 | ✅ 获取未接待的游客聊天列表 | chat | getUnassignedRoomList | service | null | {   "service": "agent",   "serviceFunction": "getUnassignedRoomList" } |
| 708 | ✅ 获取自己接待的群组列表 | chat | getMyRoomList | service | null | {   "service": "agent",   "serviceFunction": "getMyRoomList" } |
| 709 | ✅ 获取已接待的聊天列表 | chat | getAssignedGroupList | service | null | {   "service": "agent",   "serviceFunction": "getAssignedRoomList" } |
| 710 | ✅ 客服主动接待访客 | chat | checkAndReceiptVisitor | service | null | {   "service": "agent",   "serviceFunction": "checkAndReceiptVisitor" } |
| 711 | ✅ 获取群信息（群成员列表） | chat | getRoomInfo | service | {   "before": [     {       "service": "duoxingRoom",       "serviceFunction": "roomOpeartionBeforeHook"     }   ],   "after": [] } | {   "service": "duoxingRoom",   "serviceFunction": "getRoomInfo" } |
| 712 | ✅查询访客列表 | visitorManagement | getItemList | sql | null | {   "table": "visitor",   "operation": "select" } |
| 720 |  | index | getUserSession | sql | null | {   "table": "_user_session",   "operation": "select" } |
| 722 | ✅ 留言列表【包含用户名】 | visitor | getVisitorTicketList | sql | null | {   "table": "view01_visitor_ticket",   "operation": "select" } |
| 723 | ✅ 更新访客信息 | visitorManagement | updateVisitor | service | null | {   "service": "visitor",   "serviceFunction": "updateVisitor" } |
| 724 | ✅ 清除聊天消息未读，消息已读 | chat | cleanChatSessionUnreadCount | service | null | {   "service": "duoxingMessage",   "serviceFunction": "cleanChatSessionUnreadCount" } |
| 725 | ✅ui配置编辑-查询列表 | constantUiEditor | getItemInfo | sql | null | {   "table": "web_constant_ui",   "operation": "select" } |
| 726 | ✅ui配置编辑-添加数据 | constantUiEditor | insertItem | sql | null | {   "table": "web_constant_ui",   "operation": "insert" } |
| 727 | ✅ui配置编辑-更新数据 | constantUiEditor | updateItem | sql | null | {   "table": "web_constant_ui",   "operation": "jhUpdate" } |
| 728 | ✅ 获取访客统计信息 | chat | getVisitorStatistic | service | null | {   "service": "agent",   "serviceFunction": "getVisitorStatistic" } |
## _resource语句

```sql
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (101, NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (102, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (105, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (106, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (107, NULL, NULL, 'allPage', 'socketUploadByStream', '✅ 文件分片上传-socket 文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBuffer" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (108, NULL, NULL, 'allPage', 'socketUploadByBase64', '✅ 文件分片上传-socket base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (112, NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (113, NULL, NULL, 'allPage', 'socketDownloadByStream', '✅ 文件分片下载-socket文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBuffer" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (114, NULL, NULL, 'allPage', 'socketDownloadByBase64', '✅ 文件分片下载-socket base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (299, NULL, NULL, 'login', 'passwordLogin', '✅ 密码登录', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'update', NULL, NULL, '2022-03-12T21:41:08+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (301, NULL, NULL, 'allPage', 'getConstantList', '✅ 获取全局常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:43+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (302, NULL, NULL, 'allPage', 'userInfo', '✅ 用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'update', NULL, NULL, '2022-03-05T21:44:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (303, NULL, NULL, 'allPage', 'uploadByBase64', '✅ 上传base64的文件', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:34:20+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (304, NULL, NULL, 'allPage', 'uploadByStream', '✅ 上传流文件', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (305, NULL, NULL, 'allPage', 'logout', '✅ 退出登录', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'update', NULL, NULL, '2022-03-12T21:41:03+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (332, NULL, NULL, 'user', 'setUserDetail', '✅ 设置用户信息', 'service', '{}', '{ "service": "duoxingUser", "serviceFunction": "setUserDetail" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (334, NULL, NULL, 'user', 'resetPassword', '✅ 修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (339, NULL, NULL, 'agentManagement', 'getItemList', '✅查询用户列表', 'sql', '{}', '{ "table": "_user", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-05T21:44:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (340, NULL, NULL, 'agentManagement', 'addUser', '✅ 插入新用户', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "addUser" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (341, NULL, NULL, 'agentManagement', 'setItem', '✅ 更新用户', 'sql', '{}', '{ "table": "_user", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (343, NULL, NULL, 'agentManagement', 'resetUserPassword', '✅重新设置用户密码', 'service', '{}', '{ "service": "userManagement", "serviceFunction": "resetUserPassword" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (347, NULL, NULL, 'recordHistoryManagement', 'selectOnUseItemListByTable', '✅获取指定表的使用中的数据列表', 'service', NULL, '{ "service": "recordHistory", "serviceFunction": "selectOnUseItemListByTable" }', '', '', 'update', NULL, NULL, '2022-02-21T19:58:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (348, NULL, NULL, 'recordHistoryManagement', 'selectDeletedItemListByTable', '✅获取指定表的已删除的数据列表', 'service', NULL, '{ "service": "recordHistory", "serviceFunction": "selectDeletedItemListByTable" }', '', '', 'update', NULL, NULL, '2022-02-21T19:58:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (349, NULL, NULL, 'recordHistoryManagement', 'selectItemList', '✅获取数据历史表', 'sql', NULL, '{ "table": "_record_history", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-02-21T19:58:30+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (350, NULL, NULL, 'recordHistoryManagement', 'restoreRecordByRecordHistory', '✅还原数据', 'service', NULL, '{ "service": "recordHistory", "serviceFunction": "restoreRecordByRecordHistory" }', '', '', 'update', NULL, NULL, '2022-02-21T00:47:08+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (351, NULL, NULL, 'chat', 'getUserInfo', '✅ 查询用户信息', 'sql', '{}', '{ "table": "_view02_user", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:14+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (367, NULL, NULL, 'chat', 'getChatSession', '✅ 会话列表', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "getChatSession" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:13+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'chat', 'getMessageHistory', '✅ 消息列表[往历史找]', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "getMessageHistory" }', '', '', 'update', NULL, NULL, '2022-03-12T21:42:15+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'chat', 'getMessageHistoryByMaxId', '✅ 消息列表[往最新找]', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "getMessageHistory" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (370, NULL, NULL, 'chat', 'revokeMessage', '✅ 撤回消息', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "revokeMessage" }', '', '', 'update', NULL, NULL, '2022-03-12T21:07:46+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (371, NULL, NULL, 'chat', 'delMessageOffline', '✅ 删除离线消息', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "delMessageOffline" }', '', '', 'update', NULL, NULL, '2022-03-12T21:40:51+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (374, NULL, NULL, 'chat', 'toggleChatSession', '✅ 置顶会话', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "toggleChatSession" }', '', '', 'update', NULL, NULL, '2022-03-11T21:57:48+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (375, NULL, NULL, 'chat', 'deleteChatSession', '✅ 删除会话', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "deleteChatSession" }', '', '', 'update', NULL, NULL, '2022-03-10T20:57:28+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (501, NULL, '', 'socket', 'connect', '✅ socket 连接 鉴权及创建会话', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "connect" }', '', '', 'update', NULL, NULL, '2022-03-12T21:35:05+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (502, NULL, NULL, 'socket', 'disconnect', '✅ socket 关闭连接', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "disconnect" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (503, NULL, NULL, 'socket', 'userSendMessageToUser', '✅ socket 发送一对一聊天信息', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "userSendMessageToUser" }', '', '', 'update', NULL, NULL, '2022-03-12T21:08:02+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (504, NULL, NULL, 'socket', 'userSendMessageToRoom', '✅ socket 发送群聊天信息', 'service', '{}', '{ "service": "duoxingSocket", "serviceFunction": "userSendMessageToRoom" }', '', '', 'update', NULL, NULL, '2022-03-12T20:28:15+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (505, NULL, NULL, 'constantUiList', 'selectItemList', '✅constantUiList-查询列表', 'sql', '{}', '{"table": "web_constant_ui", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (506, NULL, NULL, 'constantUiList', 'insertItem', '✅constantUiList-添加成员', 'sql', '{}', '{"table": "web_constant_ui", "operation": "insert"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (507, NULL, NULL, 'constantUiList', 'updateItem', '✅constantUiList-更新成员', 'sql', '{}', '{"table": "web_constant_ui", "operation": "jhUpdate"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (508, NULL, NULL, 'constantUiList', 'deleteItem', '✅constantUiList-删除信息', 'sql', '{}', '{"table": "web_constant_ui", "operation": "jhDelete"}', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (701, NULL, NULL, 'visitor', 'sendVisitorTicket', '✅ 访客留言', 'service', '{}', '{ "service": "visitor", "serviceFunction": "visitorTicket" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (702, NULL, NULL, 'visitorTicketManagement', 'getVisitorTicketList', '✅ 留言列表', 'sql', '{}', '{ "table": "visitor_ticket", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (703, NULL, NULL, 'visitor', 'getAgentOnlineStatus', '✅ 获取客服在线状态', 'service', NULL, '{ "service": "visitor", "serviceFunction": "getAgentOnlineStatus" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (704, NULL, NULL, 'visitor', 'visitorLogin', ' ✅ 游客登录', 'service', NULL, '{ "service": "visitor", "serviceFunction": "visitorLogin" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (705, NULL, NULL, 'visitorTicketManagement', 'updateTicketReadStatus', '✅ 更新留言已读状态', 'sql', NULL, '{ "table": "visitor_ticket", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (706, NULL, NULL, 'visitor', 'updateItem', '✅ 更新游客信息', 'sql', NULL, '{ "table": "visitor", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (707, NULL, NULL, 'chat', 'getUnassignedRoomList', '✅ 获取未接待的游客聊天列表', 'service', NULL, '{ "service": "agent", "serviceFunction": "getUnassignedRoomList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (708, NULL, NULL, 'chat', 'getMyRoomList', '✅ 获取自己接待的群组列表', 'service', NULL, '{ "service": "agent", "serviceFunction": "getMyRoomList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (709, NULL, NULL, 'chat', 'getAssignedGroupList', '✅ 获取已接待的聊天列表', 'service', NULL, '{ "service": "agent", "serviceFunction": "getAssignedRoomList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (710, NULL, NULL, 'chat', 'checkAndReceiptVisitor', '✅ 客服主动接待访客', 'service', NULL, '{ "service": "agent", "serviceFunction": "checkAndReceiptVisitor" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (711, NULL, '{ "before": [{ "service": "duoxingRoom", "serviceFunction": "roomOpeartionBeforeHook" }], "after": [] }', 'chat', 'getRoomInfo', '✅ 获取群信息（群成员列表）', 'service', '{}', '{ "service": "duoxingRoom", "serviceFunction": "getRoomInfo" }', NULL, NULL, 'update', NULL, NULL, '2022-03-12T21:41:25+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (712, NULL, NULL, 'visitorManagement', 'getItemList', '✅查询访客列表', 'sql', '{}', '{ "table": "visitor", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-03-05T21:44:23+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (720, NULL, NULL, 'index', 'getUserSession', NULL, 'sql', NULL, '{ "table": "_user_session", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (722, NULL, NULL, 'visitor', 'getVisitorTicketList', '✅ 留言列表【包含用户名】', 'sql', '{}', '{ "table": "view01_visitor_ticket", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (723, NULL, NULL, 'visitorManagement', 'updateVisitor', '✅ 更新访客信息', 'service', '{}', '{ "service": "visitor", "serviceFunction": "updateVisitor" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (724, NULL, NULL, 'chat', 'cleanChatSessionUnreadCount', '✅ 清除聊天消息未读，消息已读', 'service', '{}', '{ "service": "duoxingMessage", "serviceFunction": "cleanChatSessionUnreadCount" }', NULL, NULL, 'update', NULL, NULL, '2022-03-12T21:40:51+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (725, NULL, NULL, 'constantUiEditor', 'getItemInfo', '✅ui配置编辑-查询列表', 'sql', '{}', '{ "table": "web_constant_ui", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (726, NULL, NULL, 'constantUiEditor', 'insertItem', '✅ui配置编辑-添加数据', 'sql', '{}', '{ "table": "web_constant_ui", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (727, NULL, NULL, 'constantUiEditor', 'updateItem', '✅ui配置编辑-更新数据', 'sql', '{}', '{ "table": "web_constant_ui", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (728, NULL, NULL, 'chat', 'getVisitorStatistic', '✅ 获取访客统计信息', 'service', NULL, '{ "service": "agent", "serviceFunction": "getVisitorStatistic" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```