接口

12114

接口总览

_resource结构

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

_resource 内容

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
1	✅登陆	login	passwordLogin	service		{"service": "user", "serviceFunction": "passwordLogin"}
2	✅登出	allPage	logout	service		{"service": "user", "serviceFunction": "logout"}
3	✅获取用户信息	allPage	userInfo	service		{"service": "user", "serviceFunction": "userInfo"}
4	✅查询常量	allPage	getConstantList	sql		{"table": "_constant", "operation": "select"}
5	✅ 文件分片下载-获取分片信息	allPage	getChunkInfo	service		{"service": "file", "serviceFunction": "getChunkInfo"}
6	✅ 文件分片上传-所有分片上传完毕	allPage	uploadFileDone	service		{"service": "file", "serviceFunction": "uploadFileDone"}
7	✅ 文件分片上传-http文件流	allPage	httpUploadByStream	service		{"service": "file", "serviceFunction": "uploadFileChunkByStream"}
8	✅ 文件分片上传-http base64	allPage	httpUploadByBase64	service		{"service": "file", "serviceFunction": "uploadFileChunkByBase64"}
9	✅ 文件分片下载-http base64	allPage	httpDownloadByBase64	service		{"service": "file", "serviceFunction": "downloadFileChunkByBase64"}
10	✅文件上传(文件流)	allPage	uploadByStream	service		{"service": "file", "serviceFunction": "uploadFileChunkByStream"}
11	✅文件上传(base64)	allPage	uploadByBase64	service		{"service": "file", "serviceFunction": "uploadFileChunkByBase64"}
12	✅异常日志记录	allPage	htmlErrorLogRecord	service		{"service": "error", "serviceFunction": "htmlErrorLogRecord"}
357	✅查询列表	studentManagement	selectItemList	sql		{ "table": "student", "operation": "select" }
358	✅添加	studentManagement	insertItem	sql		{ "table": "student", "operation": "insert" }
359	✅更新	studentManagement	updateItem	sql		{ "table": "student", "operation": "jhUpdate" }
360	✅删除	studentManagement	deleteItem	sql		{ "table": "student", "operation": "jhDelete" }
361		areaManagement	saveAreaData	sql		{"table":"_constant","operation":"jhUpdate"}
362		areaManagement	getClassList	sql		{"table":"view01_class","operation":"select"}
363	✅查询列表-deductionRecord	deductionRecord	selectItemList	sql	{}	{"table":"clean_deduction_record","operation":"select"}
364	✅添加-deductionRecord	deductionRecord	insertItem	sql	{}	{"table":"clean_deduction_record","operation":"jhInsert"}
365	✅更新-deductionRecord	deductionRecord	updateItem	sql	{}	{"table":"clean_deduction_record","operation":"jhUpdate"}
366	✅删除-deductionRecord	deductionRecord	deleteItem	sql	{}	{"table":"clean_deduction_record","operation":"jhDelete"}
367	✅查询列表	deductionRecord	selectRecordHistory	sql		{ "table": "_record_history", "operation": "select" }
372		areaList	getDeductionData	sql		{"table":"check_clean_record","operation":"select"}
373		areaList	getConstantList	sql		{"table":"_constant","operation":"select"}
374		areaList	getConstantList	sql		{"table":"_constant","operation":"select"}
375		areaList	rejectedDeduction	sql		{"table":"check_clean_record","operation":"jhInsert"}
376		areaList	rejectedDeduction	sql		{"table":"clean_deduction_record","operation":"jhInsert"}
377		areaList	approvedItem	sql		{"table":"check_clean_record","operation":"jhInsert"}
379	✅删除-deductionRecord	deductionRecord	deductionRecordOfArea-deleteItem	sql	{}	{"table":"check_clean_record","operation":"jhDelete"}
380	✅查询列表-deductionRecord	deductionRecord	deductionRecordOfArea-selectItemList	sql	{}	{"table":"check_clean_record","operation":"select"}
381		areaMonth	getDeductionData	sql		{"table":"check_clean_record","operation":"select"}
382		areaMonth	rejectedDeduction	sql		{"table":"check_clean_record","operation":"jhInsert"}
383		areaMonth	approvedItem	sql		{"table":"check_clean_record","operation":"jhInsert"}
384		areaMonth	getClassList	sql		{"table":"view01_class","operation":"select"}
385		classMonth	getDeductionData	sql		{"table":"check_clean_record","operation":"select"}
386		classMonth	getClassList	sql		{"table":"view01_class","operation":"select"}
395		areaManagement	getUserList	sql		{"table":"_view01_user","operation":"select"}
396		areaManagement	getUserList	sql		{"table":"view02_user_app","operation":"select"}
397		areaList	rejectedDeduction-insert	sql		{"table":"check_clean_record","operation":"jhInsert"}
398		areaList	rejectedDeduction-update	sql		{"table":"check_clean_record","operation":"jhUpdate"}
399		areaList	approvedItem-insert	sql		{"table":"check_clean_record","operation":"jhInsert"}
400		areaList	approvedItem-update	sql		{"table":"check_clean_record","operation":"jhUpdate"}
401		areaView	getDeductionData	sql		{"table":"check_clean_record","operation":"select"}
402		areaView	rejectedDeduction-insert	sql		{"table":"check_clean_record","operation":"jhInsert"}
403		areaView	rejectedDeduction-update	sql		{"table":"check_clean_record","operation":"jhUpdate"}
404		areaView	approvedItem-insert	sql		{"table":"check_clean_record","operation":"jhInsert"}
405		areaView	approvedItem-update	sql		{"table":"check_clean_record","operation":"jhUpdate"}

_resource语句

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 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 (2, 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 (3, 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 (4, 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 (5, NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{"service": "file", "serviceFunction": "getChunkInfo"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "getChunkInfo", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"downloadPath": "/testFile/1651300342370_442150_ææ5.0.11.apk"}}, "packageId": "1651301467895_7807757", "packageType": "httpRequest"}', '{"status": "success", "appData": {"hash": "3cb636e0662ba1c9a63951f6ff8a2865", "appId": "demo_advanced", "total": 9, "pageId": "allPage", "actionId": "getChunkInfo", "fileSize": 25181025, "chunkSize": 3145728, "resultData": {"hash": "3cb636e0662ba1c9a63951f6ff8a2865", "total": 9, "fileSize": 25181025, "chunkSize": 3145728}}, "packageId": "1651301467895_7807757", "timestamp": "2022-04-30T14:51:09+08:00", "packageType": "httpResponse"}', 'jhUpdate', 'admin', 'adminName', '2022-05-03T12:46:39+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "uploadFileDone", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36", "actionData": {"hash": "2fa86466e9d98b1ffc4aeeaa2d60dcec", "total": 1, "fileDesc": "11", "filename": "终端存储的输出.txt", "chunkSize": 3145728, "fileDirectory": "testFile"}}, "packageId": "1657461344665_2984863", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "fileId": "1657461344688_791754", "pageId": "allPage", "actionId": "uploadFileDone", "fileDesc": "11", "filename": "终端存储的输出.txt", "binarySize": "1.42KB", "resultData": {"fileId": "1657461344688_791754", "fileDesc": "11", "filename": "终端存储的输出.txt", "binarySize": "1.42KB", "downloadTip": "https://xxx.xxx.xxx/${downloadBasePath}${downloadPath}", "downloadPath": "/testFile/1657461344688_791754_终端存储的输出.txt", "fileDirectory": "testFile", "filenameStorage": "1657461344688_791754_终端存储的输出.txt", "downloadBasePath": "/demo_advanced/upload"}, "downloadTip": "https://xxx.xxx.xxx/${downloadBasePath}${downloadPath}", "downloadPath": "/testFile/1657461344688_791754_终端存储的输出.txt", "fileDirectory": "testFile", "filenameStorage": "1657461344688_791754_终端存储的输出.txt", "downloadBasePath": "/demo_advanced/upload"}, "packageId": "1657461344665_2984863", "timestamp": "2022-07-10T21:55:44+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-07-10T21:55:44+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByStream", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36", "actionData": {"hash": "2fa86466e9d98b1ffc4aeeaa2d60dcec", "total": 1, "chunFile": {}, "filename": "终端存储的输出.txt", "chunkSize": 3145728, "indexString": "0000"}}, "packageId": "1657461344594_9853016", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByStream"}, "packageId": "1657461344594_9853016", "timestamp": "2022-07-10T21:55:44+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-07-10T21:55:44+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (8, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByBase64"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByBase64", "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": {"hash": "93a29a14e4b922cc102811b8daa4793b", "total": 1, "chunFile": {}, "filename": "answer-time-right-toast.png", "chunkSize": 3145728, "fileBase64": null, "indexString": "0000"}}, "packageId": "1651128190181_2258419", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByBase64"}, "packageId": "1651128190181_2258419", "timestamp": "2022-04-28T14:43:10+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T14:43:10+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (9, NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{"service": "file", "serviceFunction": "downloadFileChunkByBase64"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpDownloadByBase64", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"hash": "3cb636e0662ba1c9a63951f6ff8a2865", "index": 8, "total": 9, "chunkSize": 3145728, "downloadPath": "/testFile/1651300342370_442150_ææ5.0.11.apk"}}, "packageId": "1651301556570_8673061", "packageType": "httpRequest"}', '{"status": "success", "packageId": "1651301556570_8673061", "timestamp": "2022-04-30T14:52:37+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-30T14:52:38+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (10, NULL, NULL, 'allPage', 'uploadByStream', '✅文件上传(文件流)', 'service', NULL, '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', '{}', '{}', 'update', NULL, NULL, '2022-02-22T19:36:33+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (11, NULL, NULL, 'allPage', 'uploadByBase64', '✅文件上传(base64)', 'service', NULL, '{"service": "file", "serviceFunction": "uploadFileChunkByBase64"}', '{}', '{}', 'update', NULL, NULL, '2022-02-22T18:59:14+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (12, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', 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 (357, NULL, NULL, 'studentManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student", "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 (358, NULL, NULL, 'studentManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "student", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (359, NULL, NULL, 'studentManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (360, NULL, NULL, 'studentManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "student", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (361, NULL, NULL, 'areaManagement', 'saveAreaData', NULL, 'sql', NULL, '{"table":"_constant","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 (362, NULL, NULL, 'areaManagement', 'getClassList', NULL, 'sql', NULL, '{"table":"view01_class","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 (363, NULL, '{}', 'deductionRecord', 'selectItemList', '✅查询列表-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","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 (364, NULL, '{}', 'deductionRecord', 'insertItem', '✅添加-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","operation":"jhInsert"}', 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, '{}', 'deductionRecord', 'updateItem', '✅更新-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","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 (366, NULL, '{}', 'deductionRecord', 'deleteItem', '✅删除-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","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 (367, NULL, NULL, 'deductionRecord', 'selectRecordHistory', '✅查询列表', 'sql', '{}', '{ "table": "_record_history", "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 (372, NULL, NULL, 'areaList', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (373, NULL, NULL, 'areaList', 'getConstantList', NULL, 'sql', NULL, '{"table":"_constant","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 (374, NULL, NULL, 'areaList', 'getConstantList', NULL, 'sql', NULL, '{"table":"_constant","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 (375, NULL, NULL, 'areaList', 'rejectedDeduction', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (376, NULL, NULL, 'areaList', 'rejectedDeduction', NULL, 'sql', NULL, '{"table":"clean_deduction_record","operation":"jhInsert"}', 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 (377, NULL, NULL, 'areaList', 'approvedItem', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (379, NULL, '{}', 'deductionRecord', 'deductionRecordOfArea-deleteItem', '✅删除-deductionRecord', 'sql', NULL, '{"table":"check_clean_record","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 (380, NULL, '{}', 'deductionRecord', 'deductionRecordOfArea-selectItemList', '✅查询列表-deductionRecord', 'sql', NULL, '{"table":"check_clean_record","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 (381, NULL, NULL, 'areaMonth', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (382, NULL, NULL, 'areaMonth', 'rejectedDeduction', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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, 'areaMonth', 'approvedItem', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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, 'areaMonth', 'getClassList', NULL, 'sql', NULL, '{"table":"view01_class","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 (385, NULL, NULL, 'classMonth', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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, 'classMonth', 'getClassList', NULL, 'sql', NULL, '{"table":"view01_class","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 (395, NULL, NULL, 'areaManagement', 'getUserList', NULL, 'sql', NULL, '{"table":"_view01_user","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 (396, NULL, NULL, 'areaManagement', 'getUserList', NULL, 'sql', NULL, '{"table":"view02_user_app","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 (397, NULL, NULL, 'areaList', 'rejectedDeduction-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (398, NULL, NULL, 'areaList', 'rejectedDeduction-update', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (399, NULL, NULL, 'areaList', 'approvedItem-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (400, NULL, NULL, 'areaList', 'approvedItem-update', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (401, NULL, NULL, 'areaView', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (402, NULL, NULL, 'areaView', 'rejectedDeduction-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (403, NULL, NULL, 'areaView', 'rejectedDeduction-update', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (404, NULL, NULL, 'areaView', 'approvedItem-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (405, NULL, NULL, 'areaView', 'approvedItem-update', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhUpdate"}', NULL, NULL, 'insert', NULL, NULL, NULL);

## 接口总览

## _resource结构

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

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | ✅登陆 | login | passwordLogin | service |  | {"service": "user", "serviceFunction": "passwordLogin"} |
| 2 | ✅登出 | allPage | logout | service |  | {"service": "user", "serviceFunction": "logout"} |
| 3 | ✅获取用户信息 | allPage | userInfo | service |  | {"service": "user", "serviceFunction": "userInfo"} |
| 4 | ✅查询常量 | allPage | getConstantList | sql |  | {"table": "_constant", "operation": "select"} |
| 5 | ✅ 文件分片下载-获取分片信息 | allPage | getChunkInfo | service |  | {"service": "file", "serviceFunction": "getChunkInfo"} |
| 6 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service |  | {"service": "file", "serviceFunction": "uploadFileDone"} |
| 7 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service |  | {"service": "file", "serviceFunction": "uploadFileChunkByStream"} |
| 8 | ✅ 文件分片上传-http base64 | allPage | httpUploadByBase64 | service |  | {"service": "file", "serviceFunction": "uploadFileChunkByBase64"} |
| 9 | ✅ 文件分片下载-http base64 | allPage | httpDownloadByBase64 | service |  | {"service": "file", "serviceFunction": "downloadFileChunkByBase64"} |
| 10 | ✅文件上传(文件流) | allPage | uploadByStream | service |  | {"service": "file", "serviceFunction": "uploadFileChunkByStream"} |
| 11 | ✅文件上传(base64) | allPage | uploadByBase64 | service |  | {"service": "file", "serviceFunction": "uploadFileChunkByBase64"} |
| 12 | ✅异常日志记录 | allPage | htmlErrorLogRecord | service |  | {"service": "error", "serviceFunction": "htmlErrorLogRecord"} |
| 357 | ✅查询列表 | studentManagement | selectItemList | sql |  | { "table": "student", "operation": "select" } |
| 358 | ✅添加 | studentManagement | insertItem | sql |  | { "table": "student", "operation": "insert" } |
| 359 | ✅更新 | studentManagement | updateItem | sql |  | { "table": "student", "operation": "jhUpdate" } |
| 360 | ✅删除 | studentManagement | deleteItem | sql |  | { "table": "student", "operation": "jhDelete" } |
| 361 |  | areaManagement | saveAreaData | sql |  | {"table":"_constant","operation":"jhUpdate"} |
| 362 |  | areaManagement | getClassList | sql |  | {"table":"view01_class","operation":"select"} |
| 363 | ✅查询列表-deductionRecord | deductionRecord | selectItemList | sql | {} | {"table":"clean_deduction_record","operation":"select"} |
| 364 | ✅添加-deductionRecord | deductionRecord | insertItem | sql | {} | {"table":"clean_deduction_record","operation":"jhInsert"} |
| 365 | ✅更新-deductionRecord | deductionRecord | updateItem | sql | {} | {"table":"clean_deduction_record","operation":"jhUpdate"} |
| 366 | ✅删除-deductionRecord | deductionRecord | deleteItem | sql | {} | {"table":"clean_deduction_record","operation":"jhDelete"} |
| 367 | ✅查询列表 | deductionRecord | selectRecordHistory | sql |  | { "table": "_record_history", "operation": "select" } |
| 372 |  | areaList | getDeductionData | sql |  | {"table":"check_clean_record","operation":"select"} |
| 373 |  | areaList | getConstantList | sql |  | {"table":"_constant","operation":"select"} |
| 374 |  | areaList | getConstantList | sql |  | {"table":"_constant","operation":"select"} |
| 375 |  | areaList | rejectedDeduction | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 376 |  | areaList | rejectedDeduction | sql |  | {"table":"clean_deduction_record","operation":"jhInsert"} |
| 377 |  | areaList | approvedItem | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 379 | ✅删除-deductionRecord | deductionRecord | deductionRecordOfArea-deleteItem | sql | {} | {"table":"check_clean_record","operation":"jhDelete"} |
| 380 | ✅查询列表-deductionRecord | deductionRecord | deductionRecordOfArea-selectItemList | sql | {} | {"table":"check_clean_record","operation":"select"} |
| 381 |  | areaMonth | getDeductionData | sql |  | {"table":"check_clean_record","operation":"select"} |
| 382 |  | areaMonth | rejectedDeduction | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 383 |  | areaMonth | approvedItem | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 384 |  | areaMonth | getClassList | sql |  | {"table":"view01_class","operation":"select"} |
| 385 |  | classMonth | getDeductionData | sql |  | {"table":"check_clean_record","operation":"select"} |
| 386 |  | classMonth | getClassList | sql |  | {"table":"view01_class","operation":"select"} |
| 395 |  | areaManagement | getUserList | sql |  | {"table":"_view01_user","operation":"select"} |
| 396 |  | areaManagement | getUserList | sql |  | {"table":"view02_user_app","operation":"select"} |
| 397 |  | areaList | rejectedDeduction-insert | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 398 |  | areaList | rejectedDeduction-update | sql |  | {"table":"check_clean_record","operation":"jhUpdate"} |
| 399 |  | areaList | approvedItem-insert | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 400 |  | areaList | approvedItem-update | sql |  | {"table":"check_clean_record","operation":"jhUpdate"} |
| 401 |  | areaView | getDeductionData | sql |  | {"table":"check_clean_record","operation":"select"} |
| 402 |  | areaView | rejectedDeduction-insert | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 403 |  | areaView | rejectedDeduction-update | sql |  | {"table":"check_clean_record","operation":"jhUpdate"} |
| 404 |  | areaView | approvedItem-insert | sql |  | {"table":"check_clean_record","operation":"jhInsert"} |
| 405 |  | areaView | approvedItem-update | sql |  | {"table":"check_clean_record","operation":"jhUpdate"} |
## _resource语句

```sql
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 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 (2, 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 (3, 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 (4, 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 (5, NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{"service": "file", "serviceFunction": "getChunkInfo"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "getChunkInfo", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"downloadPath": "/testFile/1651300342370_442150_ææ5.0.11.apk"}}, "packageId": "1651301467895_7807757", "packageType": "httpRequest"}', '{"status": "success", "appData": {"hash": "3cb636e0662ba1c9a63951f6ff8a2865", "appId": "demo_advanced", "total": 9, "pageId": "allPage", "actionId": "getChunkInfo", "fileSize": 25181025, "chunkSize": 3145728, "resultData": {"hash": "3cb636e0662ba1c9a63951f6ff8a2865", "total": 9, "fileSize": 25181025, "chunkSize": 3145728}}, "packageId": "1651301467895_7807757", "timestamp": "2022-04-30T14:51:09+08:00", "packageType": "httpResponse"}', 'jhUpdate', 'admin', 'adminName', '2022-05-03T12:46:39+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "uploadFileDone", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36", "actionData": {"hash": "2fa86466e9d98b1ffc4aeeaa2d60dcec", "total": 1, "fileDesc": "11", "filename": "终端存储的输出.txt", "chunkSize": 3145728, "fileDirectory": "testFile"}}, "packageId": "1657461344665_2984863", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "fileId": "1657461344688_791754", "pageId": "allPage", "actionId": "uploadFileDone", "fileDesc": "11", "filename": "终端存储的输出.txt", "binarySize": "1.42KB", "resultData": {"fileId": "1657461344688_791754", "fileDesc": "11", "filename": "终端存储的输出.txt", "binarySize": "1.42KB", "downloadTip": "https://xxx.xxx.xxx/${downloadBasePath}${downloadPath}", "downloadPath": "/testFile/1657461344688_791754_终端存储的输出.txt", "fileDirectory": "testFile", "filenameStorage": "1657461344688_791754_终端存储的输出.txt", "downloadBasePath": "/demo_advanced/upload"}, "downloadTip": "https://xxx.xxx.xxx/${downloadBasePath}${downloadPath}", "downloadPath": "/testFile/1657461344688_791754_终端存储的输出.txt", "fileDirectory": "testFile", "filenameStorage": "1657461344688_791754_终端存储的输出.txt", "downloadBasePath": "/demo_advanced/upload"}, "packageId": "1657461344665_2984863", "timestamp": "2022-07-10T21:55:44+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-07-10T21:55:44+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByStream", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36", "actionData": {"hash": "2fa86466e9d98b1ffc4aeeaa2d60dcec", "total": 1, "chunFile": {}, "filename": "终端存储的输出.txt", "chunkSize": 3145728, "indexString": "0000"}}, "packageId": "1657461344594_9853016", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByStream"}, "packageId": "1657461344594_9853016", "timestamp": "2022-07-10T21:55:44+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-07-10T21:55:44+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (8, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByBase64"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByBase64", "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": {"hash": "93a29a14e4b922cc102811b8daa4793b", "total": 1, "chunFile": {}, "filename": "answer-time-right-toast.png", "chunkSize": 3145728, "fileBase64": null, "indexString": "0000"}}, "packageId": "1651128190181_2258419", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpUploadByBase64"}, "packageId": "1651128190181_2258419", "timestamp": "2022-04-28T14:43:10+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T14:43:10+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (9, NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{"service": "file", "serviceFunction": "downloadFileChunkByBase64"}', '{"appData": {"appId": "demo_advanced", "pageId": "allPage", "actionId": "httpDownloadByBase64", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"hash": "3cb636e0662ba1c9a63951f6ff8a2865", "index": 8, "total": 9, "chunkSize": 3145728, "downloadPath": "/testFile/1651300342370_442150_ææ5.0.11.apk"}}, "packageId": "1651301556570_8673061", "packageType": "httpRequest"}', '{"status": "success", "packageId": "1651301556570_8673061", "timestamp": "2022-04-30T14:52:37+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-30T14:52:38+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (10, NULL, NULL, 'allPage', 'uploadByStream', '✅文件上传(文件流)', 'service', NULL, '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', '{}', '{}', 'update', NULL, NULL, '2022-02-22T19:36:33+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (11, NULL, NULL, 'allPage', 'uploadByBase64', '✅文件上传(base64)', 'service', NULL, '{"service": "file", "serviceFunction": "uploadFileChunkByBase64"}', '{}', '{}', 'update', NULL, NULL, '2022-02-22T18:59:14+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (12, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', 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 (357, NULL, NULL, 'studentManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student", "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 (358, NULL, NULL, 'studentManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "student", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (359, NULL, NULL, 'studentManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (360, NULL, NULL, 'studentManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "student", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (361, NULL, NULL, 'areaManagement', 'saveAreaData', NULL, 'sql', NULL, '{"table":"_constant","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 (362, NULL, NULL, 'areaManagement', 'getClassList', NULL, 'sql', NULL, '{"table":"view01_class","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 (363, NULL, '{}', 'deductionRecord', 'selectItemList', '✅查询列表-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","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 (364, NULL, '{}', 'deductionRecord', 'insertItem', '✅添加-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","operation":"jhInsert"}', 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, '{}', 'deductionRecord', 'updateItem', '✅更新-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","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 (366, NULL, '{}', 'deductionRecord', 'deleteItem', '✅删除-deductionRecord', 'sql', NULL, '{"table":"clean_deduction_record","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 (367, NULL, NULL, 'deductionRecord', 'selectRecordHistory', '✅查询列表', 'sql', '{}', '{ "table": "_record_history", "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 (372, NULL, NULL, 'areaList', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (373, NULL, NULL, 'areaList', 'getConstantList', NULL, 'sql', NULL, '{"table":"_constant","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 (374, NULL, NULL, 'areaList', 'getConstantList', NULL, 'sql', NULL, '{"table":"_constant","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 (375, NULL, NULL, 'areaList', 'rejectedDeduction', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (376, NULL, NULL, 'areaList', 'rejectedDeduction', NULL, 'sql', NULL, '{"table":"clean_deduction_record","operation":"jhInsert"}', 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 (377, NULL, NULL, 'areaList', 'approvedItem', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (379, NULL, '{}', 'deductionRecord', 'deductionRecordOfArea-deleteItem', '✅删除-deductionRecord', 'sql', NULL, '{"table":"check_clean_record","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 (380, NULL, '{}', 'deductionRecord', 'deductionRecordOfArea-selectItemList', '✅查询列表-deductionRecord', 'sql', NULL, '{"table":"check_clean_record","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 (381, NULL, NULL, 'areaMonth', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (382, NULL, NULL, 'areaMonth', 'rejectedDeduction', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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, 'areaMonth', 'approvedItem', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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, 'areaMonth', 'getClassList', NULL, 'sql', NULL, '{"table":"view01_class","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 (385, NULL, NULL, 'classMonth', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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, 'classMonth', 'getClassList', NULL, 'sql', NULL, '{"table":"view01_class","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 (395, NULL, NULL, 'areaManagement', 'getUserList', NULL, 'sql', NULL, '{"table":"_view01_user","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 (396, NULL, NULL, 'areaManagement', 'getUserList', NULL, 'sql', NULL, '{"table":"view02_user_app","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 (397, NULL, NULL, 'areaList', 'rejectedDeduction-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (398, NULL, NULL, 'areaList', 'rejectedDeduction-update', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (399, NULL, NULL, 'areaList', 'approvedItem-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (400, NULL, NULL, 'areaList', 'approvedItem-update', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (401, NULL, NULL, 'areaView', 'getDeductionData', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (402, NULL, NULL, 'areaView', 'rejectedDeduction-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (403, NULL, NULL, 'areaView', 'rejectedDeduction-update', NULL, 'sql', NULL, '{"table":"check_clean_record","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 (404, NULL, NULL, 'areaView', 'approvedItem-insert', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhInsert"}', 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 (405, NULL, NULL, 'areaView', 'approvedItem-update', NULL, 'sql', NULL, '{"table":"check_clean_record","operation":"jhUpdate"}', NULL, NULL, 'insert', NULL, NULL, NULL);
```