接口

12135

接口总览

_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", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 386 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
20	✅查询列表	afficheViewer	selectItemList	sql		{ "table": "task", "operation": "select" }
40	✅ 文件分片上传-所有分片上传完毕	allPage	uploadFileDone	service	null	{ "service": "file", "serviceFunction": "uploadFileDone" }
41	✅ 任务列表	allPage	getTaskList	sql	null	{ "table": "task", "operation": "select" }
42	✅ 更新任务	allPage	updateTask	sql	null	{ "table": "task", "operation": "jhUpdate" }
43	✅ 删除任务	allPage	deleteTask	sql	null	{ "table": "task", "operation": "jhDelete" }
44	✅ 添加审批通知	allPage	addApprovalNotice	service	null	{ "service": "notice", "serviceFunction": "addApprovalNotice" }
45	✅ 更新常量	allPage	updateConstant	sql	null	{ "table": "_constant", "operation": "jhUpdate" }
46	✅ 添加评论通知	allPage	addCommentNotice	service	null	{ "service": "notice", "serviceFunction": "addCommentNotice" }
47	✅文章编辑-使用素材	allPage	useMaterial	service	null	{ "service": "material", "serviceFunction": "useMaterial" }
48	✅xf编辑-文件列表	allPage	list	service	null	{ "service": "material", "serviceFunction": "list" }
49	✅xf编辑-创建文件夹	allPage	mkdir	service	null	{ "service": "material", "serviceFunction": "mkdir" }
50	✅xf编辑-移动文件	allPage	moveFile	service	null	{ "service": "material", "serviceFunction": "moveFile" }
51	✅xf编辑-复制文件	allPage	copyFile	service	null	{ "service": "material", "serviceFunction": "copyFile" }
52	✅xf编辑-文件重命名	allPage	renameFile	service	null	{ "service": "material", "serviceFunction": "renameFile" }
53	✅xf编辑-删除	allPage	delete	service	null	{ "service": "material", "serviceFunction": "delete" }
54	✅xf编辑-清空回收站	allPage	clearRecycle	service	null	{ "service": "material", "serviceFunction": "clearRecycle" }
55	✅登出	allPage	logout	service	null	{ "service": "user", "serviceFunction": "logout" }
56	✅获取用户信息	allPage	userInfo	service	null	{ "service": "user", "serviceFunction": "userInfo" }
57	✅获取用户信息	allPage	getUserList	sql	null	{ "table": "_view01_user_group", "operation": "select" }
58	✅ 文件分片上传-http文件流	allPage	httpUploadByStream	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }
59	✅添加通知	allPage	addNotice	service	null	{ "service": "notice", "serviceFunction": "addNotice" }
70	✅登陆	login	passwordLogin	service	null	{ "service": "user", "serviceFunction": "passwordLogin" }
90	✅查询列表	noticeManagement	selectItemList	sql	{ "before": [], "after": [ { "service": "notice", "serviceFunction": "replaceNoticeUrlAfterHook" } ] }	{ "table": "task", "operation": "select" }
91	✅添加	noticeManagement	insertItem	sql	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	{ "table": "task", "operation": "insert" }
92	✅更新	noticeManagement	updateItem	sql	null	{ "table": "task", "operation": "jhUpdate" }
93	✅删除	noticeManagement	deleteItem	sql	null	{ "table": "task", "operation": "jhDelete" }
95	✅更新未读消息列表	noticeManagement	updateAllNotReadNotice	service	null	{ "service": "notice", "serviceFunction": "updateAllNotReadNotice" }
96	✅删除已读消息列表	noticeManagement	deleteAllReadNotice	service	null	{ "service": "notice", "serviceFunction": "deleteAllReadNotice" }
110	✅查询列表	taskManagement	selectItemList	sql	null	{ "table": "task", "operation": "select" }
111	✅添加	taskManagement	insertItem	sql	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	{ "table": "task", "operation": "insert" }
112	✅更新	taskManagement	updateItem	sql	null	{ "table": "task", "operation": "jhUpdate" }
113	✅删除	taskManagement	deleteItem	sql	null	{ "table": "task", "operation": "jhDelete" }
150	✅查询列表	taskTemplateManagement	selectItemList	sql	null	{ "table": "task_template", "operation": "select" }
151	✅添加	taskTemplateManagement	insertItem	sql	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	{ "table": "task_template", "operation": "insert" }
152	✅更新	taskTemplateManagement	updateItem	sql	null	{ "table": "task_template", "operation": "jhUpdate" }
153	✅删除	taskTemplateManagement	deleteItem	sql	null	{ "table": "task_template", "operation": "jhDelete" }
154	✅测试企微通知	taskTemplateManagement	testQiWeiNotice	service	null	{ "service": "notice", "serviceFunction": "testQiWeiNotice" }
170	✅查询列表	ticketManagement	selectItemList	sql	null	{ "table": "_view01_task", "operation": "select" }
171	✅添加	ticketManagement	insertItem	sql	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	{ "table": "task", "operation": "insert" }
172	✅更新	ticketManagement	updateItem	sql	null	{ "table": "task", "operation": "jhUpdate" }
173	✅删除	ticketManagement	deleteItem	sql	null	{ "table": "task", "operation": "jhDelete" }
174	✅获取任务模板列表	ticketManagement	selectTaskTemplateList	sql	null	{ "table": "task_template", "operation": "select" }
175	✅处理审批	ticketManagement	handleTicketApply	service	null	{ "service": "ticket", "serviceFunction": "handleTicketApply" }
190	✅task模板列表	ticketStartApply	getTaskTemplateList	sql	null	{ "table": "task_template", "operation": "select" }
210	✅查询列表	ticketSubmitManagement	selectItemList	sql	null	{ "table": "_view01_task", "operation": "select" }
211	✅查询列表	ticketSubmitManagement	updateItem	sql	null	{ "table": "task", "operation": "jhUpdate" }
339	✅查询列表	afficheManagement	selectItemList	sql		{ "table": "task", "operation": "select" }

_resource语句

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (20, NULL, '', 'afficheViewer', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (40, 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 (41, NULL, NULL, 'allPage', 'getTaskList', '✅ 任务列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (42, NULL, NULL, 'allPage', 'updateTask', '✅ 更新任务', 'sql', '{}', '{ "table": "task", "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 (43, NULL, NULL, 'allPage', 'deleteTask', '✅ 删除任务', 'sql', '{}', '{ "table": "task", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (44, NULL, NULL, 'allPage', 'addApprovalNotice', '✅ 添加审批通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "addApprovalNotice" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, NULL, NULL, 'allPage', 'updateConstant', '✅ 更新常量', 'sql', '{}', '{ "table": "_constant", "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 (46, NULL, NULL, 'allPage', 'addCommentNotice', '✅ 添加评论通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "addCommentNotice" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (47, NULL, NULL, 'allPage', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{ "service": "material", "serviceFunction": "useMaterial" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (48, NULL, NULL, 'allPage', 'list', '✅xf编辑-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (49, NULL, NULL, 'allPage', 'mkdir', '✅xf编辑-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (50, NULL, NULL, 'allPage', 'moveFile', '✅xf编辑-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (51, NULL, NULL, 'allPage', 'copyFile', '✅xf编辑-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (52, NULL, NULL, 'allPage', 'renameFile', '✅xf编辑-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (53, NULL, NULL, 'allPage', 'delete', '✅xf编辑-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (54, NULL, NULL, 'allPage', 'clearRecycle', '✅xf编辑-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (55, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', NULL, '{ "service": "user", "serviceFunction": "logout" }', '', '', 'update', NULL, NULL, '2022-02-23T23:08:31+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (56, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', NULL, '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'update', NULL, NULL, '2022-11-04T11:49:34+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (57, NULL, NULL, 'allPage', 'getUserList', '✅获取用户信息', 'sql', NULL, '{ "table": "_view01_user_group", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-11-04T11:49:34+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 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 (59, NULL, NULL, 'allPage', 'addNotice', '✅添加通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "addNotice" }', 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 (70, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', NULL, '{ "service": "user", "serviceFunction": "passwordLogin" }', '{"appData":{"pageId":"login","actionId":"passwordLogin","actionData":{"userId":"admin","password":"123456","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome"},"appId":"directory","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36"},"packageId":"1677218075598_2695287","packageType":"httpRequest"}', '{"packageId":"1677218075598_2695287","packageType":"httpResponse","status":"success","timestamp":"2023-02-24T13:54:35+08:00","appData":{"authToken":"AUxhx6Z48Vgas6teOIqijUo-I5qpBikMIHu_","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome","userId":"admin","resultData":{"authToken":"AUxhx6Z48Vgas6teOIqijUo-I5qpBikMIHu_","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome","userId":"admin"},"appId":"directory","pageId":"login","actionId":"passwordLogin"}}', 'update', NULL, NULL, '2023-02-24T13:54:35+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (90, NULL, '{"before": [], "after": [{"service": "notice", "serviceFunction": "replaceNoticeUrlAfterHook"}]}', 'noticeManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (91, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'noticeManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "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 (92, NULL, NULL, 'noticeManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "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 (93, NULL, NULL, 'noticeManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "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 (95, NULL, NULL, 'noticeManagement', 'updateAllNotReadNotice', '✅更新未读消息列表', 'service', '{}', '{ "service": "notice", "serviceFunction": "updateAllNotReadNotice" }', 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 (96, NULL, NULL, 'noticeManagement', 'deleteAllReadNotice', '✅删除已读消息列表', 'service', '{}', '{ "service": "notice", "serviceFunction": "deleteAllReadNotice" }', 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 (110, NULL, NULL, 'taskManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (111, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'taskManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "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 (112, NULL, NULL, 'taskManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "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 (113, NULL, NULL, 'taskManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "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 (150, NULL, NULL, 'taskTemplateManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task_template", "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 (151, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'taskTemplateManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task_template", "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 (152, NULL, NULL, 'taskTemplateManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task_template", "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 (153, NULL, NULL, 'taskTemplateManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task_template", "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 (154, NULL, NULL, 'taskTemplateManagement', 'testQiWeiNotice', '✅测试企微通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "testQiWeiNotice" }', 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 (170, NULL, NULL, 'ticketManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "_view01_task", "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 (171, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'ticketManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "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 (172, NULL, NULL, 'ticketManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "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 (173, NULL, NULL, 'ticketManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "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 (174, NULL, NULL, 'ticketManagement', 'selectTaskTemplateList', '✅获取任务模板列表', 'sql', '{}', '{ "table": "task_template", "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 (175, NULL, NULL, 'ticketManagement', 'handleTicketApply', '✅处理审批', 'service', '{}', '{ "service": "ticket", "serviceFunction": "handleTicketApply" }', 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 (190, NULL, NULL, 'ticketStartApply', 'getTaskTemplateList', '✅task模板列表', 'sql', '{}', '{ "table": "task_template", "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 (210, NULL, NULL, 'ticketSubmitManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "_view01_task", "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 (211, NULL, NULL, 'ticketSubmitManagement', 'updateItem', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (339, NULL, '', 'afficheManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', 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", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 386 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
```

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 20 | ✅查询列表 | afficheViewer | selectItemList | sql |  | {   "table": "task",   "operation": "select" } |
| 40 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service | null | {   "service": "file",   "serviceFunction": "uploadFileDone" } |
| 41 | ✅ 任务列表 | allPage | getTaskList | sql | null | {   "table": "task",   "operation": "select" } |
| 42 | ✅ 更新任务 | allPage | updateTask | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 43 | ✅ 删除任务 | allPage | deleteTask | sql | null | {   "table": "task",   "operation": "jhDelete" } |
| 44 | ✅ 添加审批通知 | allPage | addApprovalNotice | service | null | {   "service": "notice",   "serviceFunction": "addApprovalNotice" } |
| 45 | ✅ 更新常量 | allPage | updateConstant | sql | null | {   "table": "_constant",   "operation": "jhUpdate" } |
| 46 | ✅ 添加评论通知 | allPage | addCommentNotice | service | null | {   "service": "notice",   "serviceFunction": "addCommentNotice" } |
| 47 | ✅文章编辑-使用素材 | allPage | useMaterial | service | null | {   "service": "material",   "serviceFunction": "useMaterial" } |
| 48 | ✅xf编辑-文件列表 | allPage | list | service | null | {   "service": "material",   "serviceFunction": "list" } |
| 49 | ✅xf编辑-创建文件夹 | allPage | mkdir | service | null | {   "service": "material",   "serviceFunction": "mkdir" } |
| 50 | ✅xf编辑-移动文件 | allPage | moveFile | service | null | {   "service": "material",   "serviceFunction": "moveFile" } |
| 51 | ✅xf编辑-复制文件 | allPage | copyFile | service | null | {   "service": "material",   "serviceFunction": "copyFile" } |
| 52 | ✅xf编辑-文件重命名 | allPage | renameFile | service | null | {   "service": "material",   "serviceFunction": "renameFile" } |
| 53 | ✅xf编辑-删除 | allPage | delete | service | null | {   "service": "material",   "serviceFunction": "delete" } |
| 54 | ✅xf编辑-清空回收站 | allPage | clearRecycle | service | null | {   "service": "material",   "serviceFunction": "clearRecycle" } |
| 55 | ✅登出 | allPage | logout | service | null | {   "service": "user",   "serviceFunction": "logout" } |
| 56 | ✅获取用户信息 | allPage | userInfo | service | null | {   "service": "user",   "serviceFunction": "userInfo" } |
| 57 | ✅获取用户信息 | allPage | getUserList | sql | null | {   "table": "_view01_user_group",   "operation": "select" } |
| 58 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByStream" } |
| 59 | ✅添加通知 | allPage | addNotice | service | null | {   "service": "notice",   "serviceFunction": "addNotice" } |
| 70 | ✅登陆 | login | passwordLogin | service | null | {   "service": "user",   "serviceFunction": "passwordLogin" } |
| 90 | ✅查询列表 | noticeManagement | selectItemList | sql | {   "before": [],   "after": [     {       "service": "notice",       "serviceFunction": "replaceNoticeUrlAfterHook"     }   ] } | {   "table": "task",   "operation": "select" } |
| 91 | ✅添加 | noticeManagement | insertItem | sql | {   "before": [     {       "service": "common",       "serviceFunction": "generateBizIdOfBeforeHook"     }   ],   "after": [] } | {   "table": "task",   "operation": "insert" } |
| 92 | ✅更新 | noticeManagement | updateItem | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 93 | ✅删除 | noticeManagement | deleteItem | sql | null | {   "table": "task",   "operation": "jhDelete" } |
| 95 | ✅更新未读消息列表 | noticeManagement | updateAllNotReadNotice | service | null | {   "service": "notice",   "serviceFunction": "updateAllNotReadNotice" } |
| 96 | ✅删除已读消息列表 | noticeManagement | deleteAllReadNotice | service | null | {   "service": "notice",   "serviceFunction": "deleteAllReadNotice" } |
| 110 | ✅查询列表 | taskManagement | selectItemList | sql | null | {   "table": "task",   "operation": "select" } |
| 111 | ✅添加 | taskManagement | insertItem | sql | {   "before": [     {       "service": "common",       "serviceFunction": "generateBizIdOfBeforeHook"     }   ],   "after": [] } | {   "table": "task",   "operation": "insert" } |
| 112 | ✅更新 | taskManagement | updateItem | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 113 | ✅删除 | taskManagement | deleteItem | sql | null | {   "table": "task",   "operation": "jhDelete" } |
| 150 | ✅查询列表 | taskTemplateManagement | selectItemList | sql | null | {   "table": "task_template",   "operation": "select" } |
| 151 | ✅添加 | taskTemplateManagement | insertItem | sql | {   "before": [     {       "service": "common",       "serviceFunction": "generateBizIdOfBeforeHook"     }   ],   "after": [] } | {   "table": "task_template",   "operation": "insert" } |
| 152 | ✅更新 | taskTemplateManagement | updateItem | sql | null | {   "table": "task_template",   "operation": "jhUpdate" } |
| 153 | ✅删除 | taskTemplateManagement | deleteItem | sql | null | {   "table": "task_template",   "operation": "jhDelete" } |
| 154 | ✅测试企微通知 | taskTemplateManagement | testQiWeiNotice | service | null | {   "service": "notice",   "serviceFunction": "testQiWeiNotice" } |
| 170 | ✅查询列表 | ticketManagement | selectItemList | sql | null | {   "table": "_view01_task",   "operation": "select" } |
| 171 | ✅添加 | ticketManagement | insertItem | sql | {   "before": [     {       "service": "common",       "serviceFunction": "generateBizIdOfBeforeHook"     }   ],   "after": [] } | {   "table": "task",   "operation": "insert" } |
| 172 | ✅更新 | ticketManagement | updateItem | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 173 | ✅删除 | ticketManagement | deleteItem | sql | null | {   "table": "task",   "operation": "jhDelete" } |
| 174 | ✅获取任务模板列表 | ticketManagement | selectTaskTemplateList | sql | null | {   "table": "task_template",   "operation": "select" } |
| 175 | ✅处理审批 | ticketManagement | handleTicketApply | service | null | {   "service": "ticket",   "serviceFunction": "handleTicketApply" } |
| 190 | ✅task模板列表 | ticketStartApply | getTaskTemplateList | sql | null | {   "table": "task_template",   "operation": "select" } |
| 210 | ✅查询列表 | ticketSubmitManagement | selectItemList | sql | null | {   "table": "_view01_task",   "operation": "select" } |
| 211 | ✅查询列表 | ticketSubmitManagement | updateItem | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 339 | ✅查询列表 | afficheManagement | selectItemList | sql |  | {   "table": "task",   "operation": "select" } |
## _resource语句

```sql
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (20, NULL, '', 'afficheViewer', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (40, 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 (41, NULL, NULL, 'allPage', 'getTaskList', '✅ 任务列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (42, NULL, NULL, 'allPage', 'updateTask', '✅ 更新任务', 'sql', '{}', '{ "table": "task", "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 (43, NULL, NULL, 'allPage', 'deleteTask', '✅ 删除任务', 'sql', '{}', '{ "table": "task", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (44, NULL, NULL, 'allPage', 'addApprovalNotice', '✅ 添加审批通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "addApprovalNotice" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, NULL, NULL, 'allPage', 'updateConstant', '✅ 更新常量', 'sql', '{}', '{ "table": "_constant", "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 (46, NULL, NULL, 'allPage', 'addCommentNotice', '✅ 添加评论通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "addCommentNotice" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (47, NULL, NULL, 'allPage', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{ "service": "material", "serviceFunction": "useMaterial" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (48, NULL, NULL, 'allPage', 'list', '✅xf编辑-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (49, NULL, NULL, 'allPage', 'mkdir', '✅xf编辑-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (50, NULL, NULL, 'allPage', 'moveFile', '✅xf编辑-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (51, NULL, NULL, 'allPage', 'copyFile', '✅xf编辑-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (52, NULL, NULL, 'allPage', 'renameFile', '✅xf编辑-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (53, NULL, NULL, 'allPage', 'delete', '✅xf编辑-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (54, NULL, NULL, 'allPage', 'clearRecycle', '✅xf编辑-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (55, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', NULL, '{ "service": "user", "serviceFunction": "logout" }', '', '', 'update', NULL, NULL, '2022-02-23T23:08:31+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (56, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', NULL, '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'update', NULL, NULL, '2022-11-04T11:49:34+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (57, NULL, NULL, 'allPage', 'getUserList', '✅获取用户信息', 'sql', NULL, '{ "table": "_view01_user_group", "operation": "select" }', '', '', 'update', NULL, NULL, '2022-11-04T11:49:34+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 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 (59, NULL, NULL, 'allPage', 'addNotice', '✅添加通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "addNotice" }', 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 (70, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', NULL, '{ "service": "user", "serviceFunction": "passwordLogin" }', '{"appData":{"pageId":"login","actionId":"passwordLogin","actionData":{"userId":"admin","password":"123456","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome"},"appId":"directory","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36"},"packageId":"1677218075598_2695287","packageType":"httpRequest"}', '{"packageId":"1677218075598_2695287","packageType":"httpResponse","status":"success","timestamp":"2023-02-24T13:54:35+08:00","appData":{"authToken":"AUxhx6Z48Vgas6teOIqijUo-I5qpBikMIHu_","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome","userId":"admin","resultData":{"authToken":"AUxhx6Z48Vgas6teOIqijUo-I5qpBikMIHu_","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome","userId":"admin"},"appId":"directory","pageId":"login","actionId":"passwordLogin"}}', 'update', NULL, NULL, '2023-02-24T13:54:35+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (90, NULL, '{"before": [], "after": [{"service": "notice", "serviceFunction": "replaceNoticeUrlAfterHook"}]}', 'noticeManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (91, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'noticeManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "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 (92, NULL, NULL, 'noticeManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "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 (93, NULL, NULL, 'noticeManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "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 (95, NULL, NULL, 'noticeManagement', 'updateAllNotReadNotice', '✅更新未读消息列表', 'service', '{}', '{ "service": "notice", "serviceFunction": "updateAllNotReadNotice" }', 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 (96, NULL, NULL, 'noticeManagement', 'deleteAllReadNotice', '✅删除已读消息列表', 'service', '{}', '{ "service": "notice", "serviceFunction": "deleteAllReadNotice" }', 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 (110, NULL, NULL, 'taskManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (111, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'taskManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "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 (112, NULL, NULL, 'taskManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "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 (113, NULL, NULL, 'taskManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "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 (150, NULL, NULL, 'taskTemplateManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task_template", "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 (151, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'taskTemplateManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task_template", "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 (152, NULL, NULL, 'taskTemplateManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task_template", "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 (153, NULL, NULL, 'taskTemplateManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task_template", "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 (154, NULL, NULL, 'taskTemplateManagement', 'testQiWeiNotice', '✅测试企微通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "testQiWeiNotice" }', 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 (170, NULL, NULL, 'ticketManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "_view01_task", "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 (171, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'ticketManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "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 (172, NULL, NULL, 'ticketManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "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 (173, NULL, NULL, 'ticketManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "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 (174, NULL, NULL, 'ticketManagement', 'selectTaskTemplateList', '✅获取任务模板列表', 'sql', '{}', '{ "table": "task_template", "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 (175, NULL, NULL, 'ticketManagement', 'handleTicketApply', '✅处理审批', 'service', '{}', '{ "service": "ticket", "serviceFunction": "handleTicketApply" }', 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 (190, NULL, NULL, 'ticketStartApply', 'getTaskTemplateList', '✅task模板列表', 'sql', '{}', '{ "table": "task_template", "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 (210, NULL, NULL, 'ticketSubmitManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "_view01_task", "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 (211, NULL, NULL, 'ticketSubmitManagement', 'updateItem', '✅查询列表', 'sql', '{}', '{ "table": "task", "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 (339, NULL, '', 'afficheManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```