Interface

12132

Interface Overview

_resource Structure

CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255)  DEFAULT NULL COMMENT 'Data rule control table',
  `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 'Description',
  `resourceType` varchar(255)  DEFAULT NULL COMMENT 'Resource type; E.g: auth service sql',
  `appDataSchema` text  COMMENT 'AppData parameter validation',
  `resourceData` text  COMMENT 'Resource data; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text  COMMENT 'Request Demo',
  `responseDemo` text  COMMENT 'Response Demo',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 411 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Request resource table; Soft delete not enabled; resourceId=`${appId}.${pageId}.${actionId}`'

_resource Content

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
101	✅ File chunk download - Get chunk information	allPage	getChunkInfo	service	null	{ "service": "file", "serviceFunction": "getChunkInfo" }
102	✅ File chunk upload - All chunks uploaded	allPage	uploadFileDone	service	null	{ "service": "file", "serviceFunction": "uploadFileDone" }
105	✅ File chunk upload - HTTP file stream	allPage	httpUploadByStream	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }
106	✅ File chunk upload - HTTP base64	allPage	httpUploadByBase64	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
112	✅ File chunk download - HTTP base64	allPage	httpDownloadByBase64	service	null	{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
231	✅ Login	login	passwordLogin	service	null	{ "service": "user", "serviceFunction": "passwordLogin" }
251	✅ Logout	allPage	logout	service	null	{ "service": "user", "serviceFunction": "logout" }
253	✅ Get user information	allPage	userInfo	service	null	{ "service": "user", "serviceFunction": "userInfo" }
258	✅ Query constants	allPage	getConstantList	sql	null	{ "table": "_constant", "operation": "select" }
360	✅ Query audit project list	auditProjectManagement	selectAuditProjectList	service	null	{ "service": "auditProject", "serviceFunction": "selectAuditProjectList" }
361	✅ Query list	auditProjectManagement	selectItemList	sql	null	{ "table": "view01_audit_project", "operation": "select" }
362	✅ Create audit project	auditProjectManagement	createAuditProject	service	null	{ "service": "auditProject", "serviceFunction": "createAuditProject" }
363	✅ Update	auditProjectManagement	updateItem	sql	{ "before": [], "after": [ { "service": "auditProject", "serviceFunction": "updateAuditProjectDirectoryAfterHook" } ] }	{ "table": "audit_project", "operation": "jhUpdate" }
364	✅ Delete	auditProjectManagement	deleteItem	sql	null	{ "table": "audit_project", "operation": "jhDelete" }
365	✅ Audit details - Download audit package	auditProjectDetail	downloadAuditProject	service	null	{ "service": "auditProject", "serviceFunction": "downloadAuditProject" }
366	✅ Audit details - Get audit project files	auditProjectDetail	getProjectData	service	null	{ "service": "auditProject", "serviceFunction": "getProjectData" }
367	✅ User management - Query information	userManagement	selectItemList	sql	null	{ "table": "_user", "operation": "select" }
368	✅ User management - Query information	userManagement	insertItem	service	null	{ "service": "userManagement", "serviceFunction": "addUser" }
369	✅ User management - Change password	userManagement	resetUserPassword	service	null	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }
370	✅ User management - Update user	userManagement	updateItem	sql	null	{ "table": "_user", "operation": "jhUpdate" }
380	✅ Audit details - Upload file pre-processing	auditProjectDetail	uploadFileBeforeHook	service	null	{ "service": "auditProject", "serviceFunction": "uploadFileBeforeHook" }
381	✅ Audit details - Delete file	auditProjectDetail	deleteFile	service	null	{ "service": "auditProject", "serviceFunction": "deleteFile" }
382	✅ Audit list - Get user list	auditProjectManagement	selectUserList	sql	null	{ "table": "view01_user_select", "operation": "select" }
383	✅ Audit list - Move to recycle bin	auditProjectManagement	deletedProject	service	null	{ "service": "auditProject", "serviceFunction": "deletedProject" }
384	✅ Audit list - Restore data	auditProjectManagement	restoreProject	service	null	{ "service": "auditProject", "serviceFunction": "restoreProject" }
385	✅ Query list	auditProjectDetail	selectAuditProject	sql	null	{ "table": "audit_project", "operation": "select" }
386	✅ Review	auditProjectDetail	reviewItem	service	null	{ "service": "auditProject", "serviceFunction": "reviewItem" }
387	✅ Query review data	auditProjectDetail	selectReviewData	sql	null	{ "table": "audit_review", "operation": "select" }
388	✅ Review batch	auditProjectDetail	reviewItemBatch	service	null	{ "service": "auditProject", "serviceFunction": "reviewItemBatch" }
389	✅ Query list	auditProjectDetail	reviewSummary-selectItemList	sql	null	{ "table": "audit_review", "operation": "select" }
393	✅ Audit details - Get audit information	auditProjectDetail	getAuditReview	service	null	{ "service": "auditProject", "serviceFunction": "getAuditReview" }
394	✅ Audit list - Create account set	auditProjectManagement	createAppAccountOfManual	service	null	{ "service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual" }
395	✅ Change user password	resetUserPassword	resetPassword	service	null	{ "service": "user", "serviceFunction": "resetPassword" }
400	✅ Update organizer	auditProjectManagement	updateProjectOrganizer	service	{ "before": [], "after": [ { "service": "auditProject", "serviceFunction": "syncAppAccountToFinance" } ] }	{ "service": "auditProject", "serviceFunction": "updateProjectOrganizer" }
410	✅ Audit details - Get division audit project files	auditProjectDetail	getWorkProjectData	service	null	{ "service": "auditProject", "serviceFunction": "getWorkProjectData" }

_resource Statements

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (101, NULL, NULL, 'allPage', 'getChunkInfo', '✅ File chunk download - Get chunk information', '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', '✅ File chunk upload - All chunks uploaded', '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', '✅ File chunk upload - HTTP file stream', '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', '✅ File chunk upload - 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', '✅ File chunk download - 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', '✅ Login', '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', '✅ 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', '✅ Get user information', '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', '✅ Query constants', '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', '✅ Query audit project list', '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', '✅ Query list', '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', '✅ Create audit project', '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', '✅ Update', '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', '✅ Delete', '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', '✅ Audit details - Download audit package', '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', '✅ Audit details - Get audit project files', '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', '✅ User management - Query information', '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', '✅ User management - Query information', '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', '✅ User management - Change password', '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', '✅ User management - Update user', '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', '✅ Audit details - Upload file pre-processing', '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', '✅ Audit details - Delete file', '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', '✅ Audit list - Get user list', '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', '✅ Audit list - Move to recycle bin', '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', '✅ Audit list - Restore data', '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', '✅ Query list', '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', '✅ Review', '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', '✅ Query review data', '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', '✅ Review batch', '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', '✅ Query list', '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', '✅ Audit details - Get audit information', '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', '✅ Audit list - Create account set', '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', '✅ Change user password', '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', '✅ Update organizer', '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', '✅ Audit details - Get division audit project files', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getWorkProjectData"}', NULL, NULL, 'insert', NULL, NULL, NULL);

## Interface Overview

## _resource Structure

```sql
CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255)  DEFAULT NULL COMMENT 'Data rule control table',
  `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 'Description',
  `resourceType` varchar(255)  DEFAULT NULL COMMENT 'Resource type; E.g: auth service sql',
  `appDataSchema` text  COMMENT 'AppData parameter validation',
  `resourceData` text  COMMENT 'Resource data; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text  COMMENT 'Request Demo',
  `responseDemo` text  COMMENT 'Response Demo',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 411 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Request resource table; Soft delete not enabled; resourceId=`${appId}.${pageId}.${actionId}`'
```

## _resource Content

| id  | desc                                             | pageId       | actionId            | resourceType | resourceHook | resourceData                                                                                   |
| --- | ------------------------------------------------ | ------------ | ------------------- | ------------ | ------------ | ---------------------------------------------------------------------------------------------- |
| 101 | ✅ File chunk download - Get chunk information   | allPage     | getChunkInfo        | service      | null         | { "service": "file", "serviceFunction": "getChunkInfo" }                                    |
| 102 | ✅ File chunk upload - All chunks uploaded       | allPage     | uploadFileDone      | service      | null         | { "service": "file", "serviceFunction": "uploadFileDone" }                                  |
| 105 | ✅ File chunk upload - HTTP file stream          | allPage     | httpUploadByStream   | service      | null         | { "service": "file", "serviceFunction": "uploadFileChunkByStream" }                         |
| 106 | ✅ File chunk upload - HTTP base64               | allPage     | httpUploadByBase64   | service      | null         | { "service": "file", "serviceFunction": "uploadFileChunkByBase64" }                         |
| 112 | ✅ File chunk download - HTTP base64             | allPage     | httpDownloadByBase64 | service      | null         | { "service": "file", "serviceFunction": "downloadFileChunkByBase64" }                       |
| 231 | ✅ Login                                         | login        | passwordLogin       | service      | null         | { "service": "user", "serviceFunction": "passwordLogin" }                                   |
| 251 | ✅ Logout                                        | allPage     | logout              | service      | null         | { "service": "user", "serviceFunction": "logout" }                                          |
| 253 | ✅ Get user information                           | allPage     | userInfo            | service      | null         | { "service": "user", "serviceFunction": "userInfo" }                                        |
| 258 | ✅ Query constants                               | allPage     | getConstantList     | sql          | null         | { "table": "_constant", "operation": "select" }                                             |
| 360 | ✅ Query audit project list                      | auditProjectManagement | selectAuditProjectList | service | null         | { "service": "auditProject", "serviceFunction": "selectAuditProjectList" }                   |
| 361 | ✅ Query list                                    | auditProjectManagement | selectItemList     | sql          | null         | { "table": "view01_audit_project", "operation": "select" }                                  |
| 362 | ✅ Create audit project                          | auditProjectManagement | createAuditProject  | service | null         | { "service": "auditProject", "serviceFunction": "createAuditProject" }                       |
| 363 | ✅ Update                                        | auditProjectManagement | updateItem          | sql          | { "before": [], "after": [ { "service": "auditProject", "serviceFunction": "updateAuditProjectDirectoryAfterHook" } ] } | { "table": "audit_project", "operation": "jhUpdate" } |
| 364 | ✅ Delete                                        | auditProjectManagement | deleteItem          | sql          | null         | { "table": "audit_project", "operation": "jhDelete" }                                       |
| 365 | ✅ Audit details - Download audit package       | auditProjectDetail | downloadAuditProject | service | null         | { "service": "auditProject", "serviceFunction": "downloadAuditProject" }                     |
| 366 | ✅ Audit details - Get audit project files      | auditProjectDetail | getProjectData      | service | null         | { "service": "auditProject", "serviceFunction": "getProjectData" }                          |
| 367 | ✅ User management - Query information           | userManagement | selectItemList      | sql          | null         | { "table": "_user", "operation": "select" }                                                 |
| 368 | ✅ User management - Query information           | userManagement | insertItem          | service | null         | { "service": "userManagement", "serviceFunction": "addUser" }                                |
| 369 | ✅ User management - Change password             | userManagement | resetUserPassword   | service | null         | { "service": "userManagement", "serviceFunction": "resetUserPassword" }                      |
| 370 | ✅ User management - Update user                 | userManagement | updateItem          | sql          | null         | { "table": "_user", "operation": "jhUpdate" }                                              |
| 380 | ✅ Audit details - Upload file pre-processing    | auditProjectDetail | uploadFileBeforeHook | service | null         | { "service": "auditProject", "serviceFunction": "uploadFileBeforeHook" }                     |
| 381 | ✅ Audit details - Delete file                   | auditProjectDetail | deleteFile          | service | null         | { "service": "auditProject", "serviceFunction": "deleteFile" }                               |
| 382 | ✅ Audit list - Get user list                   | auditProjectManagement | selectUserList      | sql          | null         | { "table": "view01_user_select", "operation": "select" }                                    |
| 383 | ✅ Audit list - Move to recycle bin             | auditProjectManagement | deletedProject       | service | null         | { "service": "auditProject", "serviceFunction": "deletedProject" }                           |
| 384 | ✅ Audit list - Restore data                     | auditProjectManagement | restoreProject       | service | null         | { "service": "auditProject", "serviceFunction": "restoreProject" }                           |
| 385 | ✅ Query list                                    | auditProjectDetail | selectAuditProject   | sql          | null         | { "table": "audit_project", "operation": "select" }                                         |
| 386 | ✅ Review                                         | auditProjectDetail | reviewItem          | service | null         | { "service": "auditProject", "serviceFunction": "reviewItem" }                               |
| 387 | ✅ Query review data                             | auditProjectDetail | selectReviewData    | sql          | null         | { "table": "audit_review", "operation": "select" }                                          |
| 388 | ✅ Review batch                                  | auditProjectDetail | reviewItemBatch     | service | null         | { "service": "auditProject", "serviceFunction": "reviewItemBatch" }                          |
| 389 | ✅ Query list                                    | auditProjectDetail | reviewSummary-selectItemList | sql | null         | { "table": "audit_review", "operation": "select" }                                          |
| 393 | ✅ Audit details - Get audit information         | auditProjectDetail | getAuditReview      | service | null         | { "service": "auditProject", "serviceFunction": "getAuditReview" }                           |
| 394 | ✅ Audit list - Create account set               | auditProjectManagement | createAppAccountOfManual | service | null         | { "service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual" }         |
| 395 | ✅ Change user password                          | resetUserPassword | resetPassword       | service | null         | { "service": "user", "serviceFunction": "resetPassword" }                                   |
| 400 | ✅ Update organizer                              | auditProjectManagement | updateProjectOrganizer | service | { "before": [], "after": [ { "service": "auditProject", "serviceFunction": "syncAppAccountToFinance" } ] } | { "service": "auditProject", "serviceFunction": "updateProjectOrganizer" } |
| 410 | ✅ Audit details - Get division audit project files | auditProjectDetail | getWorkProjectData  | service | null         | { "service": "auditProject", "serviceFunction": "getWorkProjectData" }                       |

## _resource Statements

```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', '✅ File chunk download - Get chunk information', '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', '✅ File chunk upload - All chunks uploaded', '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', '✅ File chunk upload - HTTP file stream', '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', '✅ File chunk upload - 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', '✅ File chunk download - 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', '✅ Login', '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', '✅ 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', '✅ Get user information', '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', '✅ Query constants', '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', '✅ Query audit project list', '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', '✅ Query list', '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', '✅ Create audit project', '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', '✅ Update', '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', '✅ Delete', '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', '✅ Audit details - Download audit package', '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', '✅ Audit details - Get audit project files', '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', '✅ User management - Query information', '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', '✅ User management - Query information', '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', '✅ User management - Change password', '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', '✅ User management - Update user', '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', '✅ Audit details - Upload file pre-processing', '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', '✅ Audit details - Delete file', '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', '✅ Audit list - Get user list', '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', '✅ Audit list - Move to recycle bin', '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', '✅ Audit list - Restore data', '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', '✅ Query list', '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', '✅ Review', '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', '✅ Query review data', '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', '✅ Review batch', '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', '✅ Query list', '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', '✅ Audit details - Get audit information', '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', '✅ Audit list - Create account set', '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', '✅ Change user password', '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', '✅ Update organizer', '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', '✅ Audit details - Get division audit project files', 'service', '{}', '{"service": "auditProject", "serviceFunction": "getWorkProjectData"}', NULL, NULL, 'insert', NULL, NULL, NULL);
```