接口

12132

接口总览

_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`)
) ENGINE = InnoDB AUTO_INCREMENT = 411 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin 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" }
112	✅ 文件分片下载-http base64	allPage	httpDownloadByBase64	service	null	{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
231	✅登陆	login	passwordLogin	service	null	{ "service": "user", "serviceFunction": "passwordLogin" }
251	✅登出	allPage	logout	service	null	{ "service": "user", "serviceFunction": "logout" }
253	✅获取用户信息	allPage	userInfo	service	null	{ "service": "user", "serviceFunction": "userInfo" }
258	✅查询常量	allPage	getConstantList	sql	null	{ "table": "_constant", "operation": "select" }
360	✅查询审计项目列表	auditProjectManagement	selectAuditProjectList	service	null	{ "service": "auditProject", "serviceFunction": "selectAuditProjectList" }
361	✅查询列表	auditProjectManagement	selectItemList	sql	null	{ "table": "view01_audit_project", "operation": "select" }
362	✅创建审计项目	auditProjectManagement	createAuditProject	service	null	{ "service": "auditProject", "serviceFunction": "createAuditProject" }
363	✅更新	auditProjectManagement	updateItem	sql	{ "before": [], "after": [ { "service": "auditProject", "serviceFunction": "updateAuditProjectDirectoryAfterHook" } ] }	{ "table": "audit_project", "operation": "jhUpdate" }
364	✅删除	auditProjectManagement	deleteItem	sql	null	{ "table": "audit_project", "operation": "jhDelete" }
365	✅审计详情-下载审计包	auditProjectDetail	downloadAuditProject	service	null	{ "service": "auditProject", "serviceFunction": "downloadAuditProject" }
366	✅审计详情-获取审计项目文件	auditProjectDetail	getProjectData	service	null	{ "service": "auditProject", "serviceFunction": "getProjectData" }
367	✅用户管理-查询信息	userManagement	selectItemList	sql	null	{ "table": "_user", "operation": "select" }
368	✅用户管理-查询信息	userManagement	insertItem	service	null	{ "service": "userManagement", "serviceFunction": "addUser" }
369	✅用户管理-修改密码	userManagement	resetUserPassword	service	null	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
370	✅用户管理-更新用户	userManagement	updateItem	sql	null	{ "table": "_user", "operation": "jhUpdate" }
380	✅审计详情-上传文件前置处理	auditProjectDetail	uploadFileBeforeHook	service	null	{ "service": "auditProject", "serviceFunction": "uploadFileBeforeHook" }
381	✅审计详情-删除文件	auditProjectDetail	deleteFile	service	null	{ "service": "auditProject", "serviceFunction": "deleteFile" }
382	✅审计列表-获取用户列表	auditProjectManagement	selectUserList	sql	null	{ "table": "view01_user_select", "operation": "select" }
383	✅审计列表-移入回收站	auditProjectManagement	deletedProject	service	null	{ "service": "auditProject", "serviceFunction": "deletedProject" }
384	✅审计列表-恢复数据	auditProjectManagement	restoreProject	service	null	{ "service": "auditProject", "serviceFunction": "restoreProject" }
385	✅查询列表	auditProjectDetail	selectAuditProject	sql	null	{ "table": "audit_project", "operation": "select" }
386	✅审核	auditProjectDetail	reviewItem	service	null	{ "service": "auditProject", "serviceFunction": "reviewItem" }
387	✅查询审核数据	auditProjectDetail	selectReviewData	sql	null	{ "table": "audit_review", "operation": "select" }
388	✅审核批量	auditProjectDetail	reviewItemBatch	service	null	{ "service": "auditProject", "serviceFunction": "reviewItemBatch" }
389	✅查询列表	auditProjectDetail	reviewSummary-selectItemList	sql	null	{ "table": "audit_review", "operation": "select" }
393	✅审计详情-获取审计信息	auditProjectDetail	getAuditReview	service	null	{ "service": "auditProject", "serviceFunction": "getAuditReview" }
394	✅审计列表-创建账套	auditProjectManagement	createAppAccountOfManual	service	null	{ "service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual" }
395	✅修改用户密码	resetUserPassword	resetPassword	service	null	{ "service": "user", "serviceFunction": "resetPassword" }
400	✅更新编制人	auditProjectManagement	updateProjectOrganizer	service	{ "before": [], "after": [ { "service": "auditProject", "serviceFunction": "syncAppAccountToFinance" } ] }	{ "service": "auditProject", "serviceFunction": "updateProjectOrganizer" }
410	✅审计详情-获取分工审计项目文件	auditProjectDetail	getWorkProjectData	service	null	{ "service": "auditProject", "serviceFunction": "getWorkProjectData" }

_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" }', NULL, NULL, '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" }', 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 (105, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', NULL, NULL, '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" }', NULL, NULL, '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" }', NULL, NULL, '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 (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "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 (360, NULL, NULL, 'auditProjectManagement', 'selectAuditProjectList', '✅查询审计项目列表', 'service', '{}', '{"service": "auditProject", "serviceFunction": "selectAuditProjectList"}', 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 (361, NULL, NULL, 'auditProjectManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_audit_project", "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 (362, NULL, NULL, 'auditProjectManagement', 'createAuditProject', '✅创建审计项目', 'service', '{}', '{"service": "auditProject", "serviceFunction": "createAuditProject"}', 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 (363, NULL, '{"before": [], "after": [{"service": "auditProject", "serviceFunction": "updateAuditProjectDirectoryAfterHook"}]}', 'auditProjectManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "audit_project", "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 (364, NULL, NULL, 'auditProjectManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "audit_project", "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 (365, NULL, NULL, 'auditProjectDetail', 'downloadAuditProject', '✅审计详情-下载审计包', 'service', '{}', '{"service": "auditProject", "serviceFunction": "downloadAuditProject"}', 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 (366, NULL, NULL, 'auditProjectDetail', 'getProjectData', '✅审计详情-获取审计项目文件', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getProjectData"}', 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 (367, NULL, NULL, 'userManagement', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{"table": "_user", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651221207913_1347965", "packageType": "httpRequest"}', '{"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-29T16:33:28+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{"service": "userManagement", "serviceFunction": "addUser"}', '{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T16:36:00+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'userManagement', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{"service": "userManagement", "serviceFunction": "resetUserPassword"}', '{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T16:37:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (370, NULL, NULL, 'userManagement', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{"table": "_user", "operation": "jhUpdate"}', '{"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-29T16:33:27+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, NULL, 'auditProjectDetail', 'uploadFileBeforeHook', '✅审计详情-上传文件前置处理', 'service', '{}', '{"service": "auditProject", "serviceFunction": "uploadFileBeforeHook"}', 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 (381, NULL, NULL, 'auditProjectDetail', 'deleteFile', '✅审计详情-删除文件', 'service', '{}', '{"service": "auditProject", "serviceFunction": "deleteFile"}', 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 (382, NULL, NULL, 'auditProjectManagement', 'selectUserList', '✅审计列表-获取用户列表', 'sql', '{}', '{"table": "view01_user_select", "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 (383, NULL, NULL, 'auditProjectManagement', 'deletedProject', '✅审计列表-移入回收站', 'service', '{}', '{"service": "auditProject", "serviceFunction": "deletedProject"}', 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 (384, NULL, NULL, 'auditProjectManagement', 'restoreProject', '✅审计列表-恢复数据', 'service', '{}', '{"service": "auditProject", "serviceFunction": "restoreProject"}', 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 (385, NULL, NULL, 'auditProjectDetail', 'selectAuditProject', '✅查询列表', 'sql', '{}', '{ "table": "audit_project", "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 (386, NULL, NULL, 'auditProjectDetail', 'reviewItem', '✅审核', 'service', '{}', '{"service": "auditProject", "serviceFunction": "reviewItem"}', 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 (387, NULL, NULL, 'auditProjectDetail', 'selectReviewData', '✅查询审核数据', 'sql', '{}', '{ "table": "audit_review", "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 (388, NULL, NULL, 'auditProjectDetail', 'reviewItemBatch', '✅审核批量', 'service', '{}', '{"service": "auditProject", "serviceFunction": "reviewItemBatch"}', 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 (389, NULL, NULL, 'auditProjectDetail', 'reviewSummary-selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "audit_review", "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 (393, NULL, NULL, 'auditProjectDetail', 'getAuditReview', '✅审计详情-获取审计信息', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getAuditReview"}', 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 (394, NULL, NULL, 'auditProjectManagement', 'createAppAccountOfManual', '✅审计列表-创建账套', 'service', '{}', '{"service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual"}', 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 (395, NULL, NULL, 'resetUserPassword', '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 (400, NULL, '{"before": [], "after": [{"service": "auditProject", "serviceFunction": "syncAppAccountToFinance"}]}', 'auditProjectManagement', 'updateProjectOrganizer', '✅更新编制人', 'service', '{}', '{"service": "auditProject", "serviceFunction": "updateProjectOrganizer"}', 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 (410, NULL, NULL, 'auditProjectDetail', 'getWorkProjectData', '✅审计详情-获取分工审计项目文件', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getWorkProjectData"}', 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`)
) ENGINE = InnoDB AUTO_INCREMENT = 411 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin 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" } |
| 112 | ✅ 文件分片下载-http base64 | allPage | httpDownloadByBase64 | service | null | {   "service": "file",   "serviceFunction": "downloadFileChunkByBase64" } |
| 231 | ✅登陆 | login | passwordLogin | service | null | {   "service": "user",   "serviceFunction": "passwordLogin" } |
| 251 | ✅登出 | allPage | logout | service | null | {   "service": "user",   "serviceFunction": "logout" } |
| 253 | ✅获取用户信息 | allPage | userInfo | service | null | {   "service": "user",   "serviceFunction": "userInfo" } |
| 258 | ✅查询常量 | allPage | getConstantList | sql | null | {   "table": "_constant",   "operation": "select" } |
| 360 | ✅查询审计项目列表 | auditProjectManagement | selectAuditProjectList | service | null | {   "service": "auditProject",   "serviceFunction": "selectAuditProjectList" } |
| 361 | ✅查询列表 | auditProjectManagement | selectItemList | sql | null | {   "table": "view01_audit_project",   "operation": "select" } |
| 362 | ✅创建审计项目 | auditProjectManagement | createAuditProject | service | null | {   "service": "auditProject",   "serviceFunction": "createAuditProject" } |
| 363 | ✅更新 | auditProjectManagement | updateItem | sql | {   "before": [],   "after": [     {       "service": "auditProject",       "serviceFunction": "updateAuditProjectDirectoryAfterHook"     }   ] } | {   "table": "audit_project",   "operation": "jhUpdate" } |
| 364 | ✅删除 | auditProjectManagement | deleteItem | sql | null | {   "table": "audit_project",   "operation": "jhDelete" } |
| 365 | ✅审计详情-下载审计包 | auditProjectDetail | downloadAuditProject | service | null | {   "service": "auditProject",   "serviceFunction": "downloadAuditProject" } |
| 366 | ✅审计详情-获取审计项目文件 | auditProjectDetail | getProjectData | service | null | {   "service": "auditProject",   "serviceFunction": "getProjectData" } |
| 367 | ✅用户管理-查询信息 | userManagement | selectItemList | sql | null | {   "table": "_user",   "operation": "select" } |
| 368 | ✅用户管理-查询信息 | userManagement | insertItem | service | null | {   "service": "userManagement",   "serviceFunction": "addUser" } |
| 369 | ✅用户管理-修改密码 | userManagement | resetUserPassword | service | null | {   "service": "userManagement",   "serviceFunction": "resetUserPassword" } |
| 370 | ✅用户管理-更新用户 | userManagement | updateItem | sql | null | {   "table": "_user",   "operation": "jhUpdate" } |
| 380 | ✅审计详情-上传文件前置处理 | auditProjectDetail | uploadFileBeforeHook | service | null | {   "service": "auditProject",   "serviceFunction": "uploadFileBeforeHook" } |
| 381 | ✅审计详情-删除文件 | auditProjectDetail | deleteFile | service | null | {   "service": "auditProject",   "serviceFunction": "deleteFile" } |
| 382 | ✅审计列表-获取用户列表 | auditProjectManagement | selectUserList | sql | null | {   "table": "view01_user_select",   "operation": "select" } |
| 383 | ✅审计列表-移入回收站 | auditProjectManagement | deletedProject | service | null | {   "service": "auditProject",   "serviceFunction": "deletedProject" } |
| 384 | ✅审计列表-恢复数据 | auditProjectManagement | restoreProject | service | null | {   "service": "auditProject",   "serviceFunction": "restoreProject" } |
| 385 | ✅查询列表 | auditProjectDetail | selectAuditProject | sql | null | {   "table": "audit_project",   "operation": "select" } |
| 386 | ✅审核 | auditProjectDetail | reviewItem | service | null | {   "service": "auditProject",   "serviceFunction": "reviewItem" } |
| 387 | ✅查询审核数据 | auditProjectDetail | selectReviewData | sql | null | {   "table": "audit_review",   "operation": "select" } |
| 388 | ✅审核批量 | auditProjectDetail | reviewItemBatch | service | null | {   "service": "auditProject",   "serviceFunction": "reviewItemBatch" } |
| 389 | ✅查询列表 | auditProjectDetail | reviewSummary-selectItemList | sql | null | {   "table": "audit_review",   "operation": "select" } |
| 393 | ✅审计详情-获取审计信息 | auditProjectDetail | getAuditReview | service | null | {   "service": "auditProject",   "serviceFunction": "getAuditReview" } |
| 394 | ✅审计列表-创建账套 | auditProjectManagement | createAppAccountOfManual | service | null | {   "service": "auditProject",   "serviceFunction": "syncAppAccountToFinanceOfManual" } |
| 395 | ✅修改用户密码 | resetUserPassword | resetPassword | service | null | {   "service": "user",   "serviceFunction": "resetPassword" } |
| 400 | ✅更新编制人 | auditProjectManagement | updateProjectOrganizer | service | {   "before": [],   "after": [     {       "service": "auditProject",       "serviceFunction": "syncAppAccountToFinance"     }   ] } | {   "service": "auditProject",   "serviceFunction": "updateProjectOrganizer" } |
| 410 | ✅审计详情-获取分工审计项目文件 | auditProjectDetail | getWorkProjectData | service | null | {   "service": "auditProject",   "serviceFunction": "getWorkProjectData" } |
## _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" }', NULL, NULL, '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" }', 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 (105, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', NULL, NULL, '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" }', NULL, NULL, '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" }', NULL, NULL, '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 (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "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 (360, NULL, NULL, 'auditProjectManagement', 'selectAuditProjectList', '✅查询审计项目列表', 'service', '{}', '{"service": "auditProject", "serviceFunction": "selectAuditProjectList"}', 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 (361, NULL, NULL, 'auditProjectManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_audit_project", "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 (362, NULL, NULL, 'auditProjectManagement', 'createAuditProject', '✅创建审计项目', 'service', '{}', '{"service": "auditProject", "serviceFunction": "createAuditProject"}', 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 (363, NULL, '{"before": [], "after": [{"service": "auditProject", "serviceFunction": "updateAuditProjectDirectoryAfterHook"}]}', 'auditProjectManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "audit_project", "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 (364, NULL, NULL, 'auditProjectManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "audit_project", "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 (365, NULL, NULL, 'auditProjectDetail', 'downloadAuditProject', '✅审计详情-下载审计包', 'service', '{}', '{"service": "auditProject", "serviceFunction": "downloadAuditProject"}', 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 (366, NULL, NULL, 'auditProjectDetail', 'getProjectData', '✅审计详情-获取审计项目文件', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getProjectData"}', 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 (367, NULL, NULL, 'userManagement', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{"table": "_user", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651221207913_1347965", "packageType": "httpRequest"}', '{"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-29T16:33:28+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{"service": "userManagement", "serviceFunction": "addUser"}', '{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T16:36:00+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'userManagement', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{"service": "userManagement", "serviceFunction": "resetUserPassword"}', '{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T16:37:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (370, NULL, NULL, 'userManagement', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{"table": "_user", "operation": "jhUpdate"}', '{"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-29T16:33:27+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, NULL, 'auditProjectDetail', 'uploadFileBeforeHook', '✅审计详情-上传文件前置处理', 'service', '{}', '{"service": "auditProject", "serviceFunction": "uploadFileBeforeHook"}', 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 (381, NULL, NULL, 'auditProjectDetail', 'deleteFile', '✅审计详情-删除文件', 'service', '{}', '{"service": "auditProject", "serviceFunction": "deleteFile"}', 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 (382, NULL, NULL, 'auditProjectManagement', 'selectUserList', '✅审计列表-获取用户列表', 'sql', '{}', '{"table": "view01_user_select", "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 (383, NULL, NULL, 'auditProjectManagement', 'deletedProject', '✅审计列表-移入回收站', 'service', '{}', '{"service": "auditProject", "serviceFunction": "deletedProject"}', 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 (384, NULL, NULL, 'auditProjectManagement', 'restoreProject', '✅审计列表-恢复数据', 'service', '{}', '{"service": "auditProject", "serviceFunction": "restoreProject"}', 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 (385, NULL, NULL, 'auditProjectDetail', 'selectAuditProject', '✅查询列表', 'sql', '{}', '{ "table": "audit_project", "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 (386, NULL, NULL, 'auditProjectDetail', 'reviewItem', '✅审核', 'service', '{}', '{"service": "auditProject", "serviceFunction": "reviewItem"}', 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 (387, NULL, NULL, 'auditProjectDetail', 'selectReviewData', '✅查询审核数据', 'sql', '{}', '{ "table": "audit_review", "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 (388, NULL, NULL, 'auditProjectDetail', 'reviewItemBatch', '✅审核批量', 'service', '{}', '{"service": "auditProject", "serviceFunction": "reviewItemBatch"}', 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 (389, NULL, NULL, 'auditProjectDetail', 'reviewSummary-selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "audit_review", "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 (393, NULL, NULL, 'auditProjectDetail', 'getAuditReview', '✅审计详情-获取审计信息', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getAuditReview"}', 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 (394, NULL, NULL, 'auditProjectManagement', 'createAppAccountOfManual', '✅审计列表-创建账套', 'service', '{}', '{"service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual"}', 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 (395, NULL, NULL, 'resetUserPassword', '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 (400, NULL, '{"before": [], "after": [{"service": "auditProject", "serviceFunction": "syncAppAccountToFinance"}]}', 'auditProjectManagement', 'updateProjectOrganizer', '✅更新编制人', 'service', '{}', '{"service": "auditProject", "serviceFunction": "updateProjectOrganizer"}', 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 (410, NULL, NULL, 'auditProjectDetail', 'getWorkProjectData', '✅审计详情-获取分工审计项目文件', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getWorkProjectData"}', NULL, NULL, 'insert', NULL, NULL, NULL);
```