接口

12138

接口总览

_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 = 401 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
231	✅登陆	login	passwordLogin	service	null	{ "service": "user", "serviceFunction": "passwordLogin" }
251	✅登出	allPage	logout	service	null	{ "service": "user", "serviceFunction": "logout" }
253	✅获取用户信息	allPage	userInfo	service	null	{ "service": "user", "serviceFunction": "userInfo" }
258	✅查询常量	allPage	getConstantList	sql	null	{ "table": "_constant", "operation": "select" }
259	✅查询用户列表	allPage	getUserList	sql	null	{ "table": "_view01_user", "operation": "select" }
260	✅查询任务列表	allPage	getTaskList	sql	null	{ "table": "task", "operation": "select" }
261	✅更新task	allPage	updateTask	sql	null	{ "table": "task", "operation": "jhUpdate" }
262	✅删除task	allPage	deleteTask	sql	null	{ "table": "task", "operation": "jhDelete" }
263	✅项目列表查询	allPage	getProjectList	sql	null	{ "table": "project", "operation": "select" }
264	✅ 文件分片上传-http文件流	allPage	httpUploadByStream	service	null	{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }
265	✅ 文件分片上传-所有分片上传完毕	allPage	uploadFileDone	service	null	{ "service": "file", "serviceFunction": "uploadFileDone" }
357	✅查询列表	studentManagement	selectItemList	sql	null	{ "table": "student", "operation": "select" }
358	✅添加	studentManagement	insertItem	sql	null	{ "table": "student", "operation": "insert" }
359	✅更新	studentManagement	updateItem	sql	null	{ "table": "student", "operation": "jhUpdate" }
360	✅删除	studentManagement	deleteItem	sql	null	{ "table": "student", "operation": "jhDelete" }
361	✅查询列表	workbenchManagement	selectItemList	sql	null	{ "table": "task", "operation": "select" }
362	✅添加	workbenchManagement	insertItem	sql	null	{ "table": "task", "operation": "insert" }
363	✅更新	workbenchManagement	updateItem	sql	null	{ "table": "task", "operation": "jhUpdate" }
364	✅删除	workbenchManagement	deleteItem	sql	null	{ "table": "task", "operation": "jhDelete" }
365	✅项目查询-查询列表	projectManagement	selectItemList	sql	null	{ "table": "view01_project", "operation": "select" }
366	✅项目查询-添加成员	projectManagement	insertItem	sql	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	{ "table": "project", "operation": "jhInsert" }
367	✅项目查询-更新成员	projectManagement	updateItem	sql	null	{ "table": "project", "operation": "jhUpdate" }
368	✅项目查询-删除信息	projectManagement	deleteItem	sql	null	{ "table": "project", "operation": "jhDelete" }
369	✅项目的任务管理-查询当前任务下的项目列表	taskManagementOfOneProject	selectCurrentList	sql	null	{ "table": "task", "operation": "select" }
370	✅项目的任务管理-建立关系	taskManagementOfOneProject	insertItem	sql	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	{ "table": "task", "operation": "jhInsert" }
371	✅项目的任务管理-更新数据	taskManagementOfOneProject	updateItem	sql	null	{ "table": "task", "operation": "jhUpdate" }
372	✅项目的任务管理-删除信息	taskManagementOfOneProject	deleteItem	sql	null	{ "table": "task", "operation": "jhDelete" }
373	✅项目查询-查询列表	taskManagementOfOneProject	selectAllList	sql	null	{ "table": "task", "operation": "select" }
374	✅项目查询-查询列表	taskManagementOfOneProject	getProjectList	sql	null	{ "table": "view01_project", "operation": "select" }
400	✅彻底删除项目	projectRecycledManagement	deleteProject	service	null	{ "service": "project", "serviceFunction": "deleteProject" }

_resource语句

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (259, NULL, NULL, 'allPage', 'getUserList', '✅查询用户列表', 'sql', '{}', '{"table": "_view01_user", "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 (260, NULL, NULL, 'allPage', 'getTaskList', '✅查询任务列表', 'sql', '{}', '{"table": "task", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (261, NULL, NULL, 'allPage', 'updateTask', '✅更新task', 'sql', '{}', '{"table": "task", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (262, NULL, NULL, 'allPage', 'deleteTask', '✅删除task', 'sql', '{}', '{"table": "task", "operation": "jhDelete"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (263, NULL, NULL, 'allPage', 'getProjectList', '✅项目列表查询', 'sql', '{}', '{"table": "project", "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 (264, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (265, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (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, 'workbenchManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (362, NULL, NULL, 'workbenchManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (363, NULL, NULL, 'workbenchManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (364, NULL, NULL, 'workbenchManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (365, NULL, NULL, 'projectManagement', 'selectItemList', '✅项目查询-查询列表', 'sql', '{}', '{ "table": "view01_project", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (366, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'projectManagement', 'insertItem', '✅项目查询-添加成员', 'sql', '{}', '{ "table": "project", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', 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, 'projectManagement', 'updateItem', '✅项目查询-更新成员', 'sql', '{}', '{ "table": "project", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'projectManagement', 'deleteItem', '✅项目查询-删除信息', 'sql', '{}', '{ "table": "project", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'taskManagementOfOneProject', 'selectCurrentList', '✅项目的任务管理-查询当前任务下的项目列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (370, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'taskManagementOfOneProject', 'insertItem', '✅项目的任务管理-建立关系', 'sql', '{}', '{ "table": "task", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (371, NULL, NULL, 'taskManagementOfOneProject', 'updateItem', '✅项目的任务管理-更新数据', 'sql', '{}', '{ "table": "task", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', 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, 'taskManagementOfOneProject', 'deleteItem', '✅项目的任务管理-删除信息', 'sql', '{}', '{ "table": "task", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', 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, 'taskManagementOfOneProject', 'selectAllList', '✅项目查询-查询列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'jhInsert', 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, 'taskManagementOfOneProject', 'getProjectList', '✅项目查询-查询列表', 'sql', '{}', '{ "table": "view01_project", "operation": "select" }', NULL, NULL, 'jhInsert', 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, 'projectRecycledManagement', 'deleteProject', '✅彻底删除项目', 'service', '{}', '{"service": "project", "serviceFunction": "deleteProject"}', NULL, NULL, 'jhInsert', 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 = 401 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
```

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 231 | ✅登陆 | login | passwordLogin | service | null | {   "service": "user",   "serviceFunction": "passwordLogin" } |
| 251 | ✅登出 | allPage | logout | service | null | {   "service": "user",   "serviceFunction": "logout" } |
| 253 | ✅获取用户信息 | allPage | userInfo | service | null | {   "service": "user",   "serviceFunction": "userInfo" } |
| 258 | ✅查询常量 | allPage | getConstantList | sql | null | {   "table": "_constant",   "operation": "select" } |
| 259 | ✅查询用户列表 | allPage | getUserList | sql | null | {   "table": "_view01_user",   "operation": "select" } |
| 260 | ✅查询任务列表 | allPage | getTaskList | sql | null | {   "table": "task",   "operation": "select" } |
| 261 | ✅更新task | allPage | updateTask | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 262 | ✅删除task | allPage | deleteTask | sql | null | {   "table": "task",   "operation": "jhDelete" } |
| 263 | ✅项目列表查询 | allPage | getProjectList | sql | null | {   "table": "project",   "operation": "select" } |
| 264 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service | null | {   "service": "file",   "serviceFunction": "uploadFileChunkByStream" } |
| 265 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service | null | {   "service": "file",   "serviceFunction": "uploadFileDone" } |
| 357 | ✅查询列表 | studentManagement | selectItemList | sql | null | {   "table": "student",   "operation": "select" } |
| 358 | ✅添加 | studentManagement | insertItem | sql | null | {   "table": "student",   "operation": "insert" } |
| 359 | ✅更新 | studentManagement | updateItem | sql | null | {   "table": "student",   "operation": "jhUpdate" } |
| 360 | ✅删除 | studentManagement | deleteItem | sql | null | {   "table": "student",   "operation": "jhDelete" } |
| 361 | ✅查询列表 | workbenchManagement | selectItemList | sql | null | {   "table": "task",   "operation": "select" } |
| 362 | ✅添加 | workbenchManagement | insertItem | sql | null | {   "table": "task",   "operation": "insert" } |
| 363 | ✅更新 | workbenchManagement | updateItem | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 364 | ✅删除 | workbenchManagement | deleteItem | sql | null | {   "table": "task",   "operation": "jhDelete" } |
| 365 | ✅项目查询-查询列表 | projectManagement | selectItemList | sql | null | {   "table": "view01_project",   "operation": "select" } |
| 366 | ✅项目查询-添加成员 | projectManagement | insertItem | sql | {   "before": [     {       "service": "common",       "serviceFunction": "generateBizIdOfBeforeHook"     }   ],   "after": [] } | {   "table": "project",   "operation": "jhInsert" } |
| 367 | ✅项目查询-更新成员 | projectManagement | updateItem | sql | null | {   "table": "project",   "operation": "jhUpdate" } |
| 368 | ✅项目查询-删除信息 | projectManagement | deleteItem | sql | null | {   "table": "project",   "operation": "jhDelete" } |
| 369 | ✅项目的任务管理-查询当前任务下的项目列表 | taskManagementOfOneProject | selectCurrentList | sql | null | {   "table": "task",   "operation": "select" } |
| 370 | ✅项目的任务管理-建立关系 | taskManagementOfOneProject | insertItem | sql | {   "before": [     {       "service": "common",       "serviceFunction": "generateBizIdOfBeforeHook"     }   ],   "after": [] } | {   "table": "task",   "operation": "jhInsert" } |
| 371 | ✅项目的任务管理-更新数据 | taskManagementOfOneProject | updateItem | sql | null | {   "table": "task",   "operation": "jhUpdate" } |
| 372 | ✅项目的任务管理-删除信息 | taskManagementOfOneProject | deleteItem | sql | null | {   "table": "task",   "operation": "jhDelete" } |
| 373 | ✅项目查询-查询列表 | taskManagementOfOneProject | selectAllList | sql | null | {   "table": "task",   "operation": "select" } |
| 374 | ✅项目查询-查询列表 | taskManagementOfOneProject | getProjectList | sql | null | {   "table": "view01_project",   "operation": "select" } |
| 400 | ✅彻底删除项目 | projectRecycledManagement | deleteProject | service | null | {   "service": "project",   "serviceFunction": "deleteProject" } |
## _resource语句

```sql
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (259, NULL, NULL, 'allPage', 'getUserList', '✅查询用户列表', 'sql', '{}', '{"table": "_view01_user", "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 (260, NULL, NULL, 'allPage', 'getTaskList', '✅查询任务列表', 'sql', '{}', '{"table": "task", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (261, NULL, NULL, 'allPage', 'updateTask', '✅更新task', 'sql', '{}', '{"table": "task", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (262, NULL, NULL, 'allPage', 'deleteTask', '✅删除task', 'sql', '{}', '{"table": "task", "operation": "jhDelete"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (263, NULL, NULL, 'allPage', 'getProjectList', '✅项目列表查询', 'sql', '{}', '{"table": "project", "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 (264, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (265, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (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, 'workbenchManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (362, NULL, NULL, 'workbenchManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "task", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (363, NULL, NULL, 'workbenchManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "task", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (364, NULL, NULL, 'workbenchManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "task", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (365, NULL, NULL, 'projectManagement', 'selectItemList', '✅项目查询-查询列表', 'sql', '{}', '{ "table": "view01_project", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (366, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'projectManagement', 'insertItem', '✅项目查询-添加成员', 'sql', '{}', '{ "table": "project", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', 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, 'projectManagement', 'updateItem', '✅项目查询-更新成员', 'sql', '{}', '{ "table": "project", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'projectManagement', 'deleteItem', '✅项目查询-删除信息', 'sql', '{}', '{ "table": "project", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'taskManagementOfOneProject', 'selectCurrentList', '✅项目的任务管理-查询当前任务下的项目列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (370, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'taskManagementOfOneProject', 'insertItem', '✅项目的任务管理-建立关系', 'sql', '{}', '{ "table": "task", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (371, NULL, NULL, 'taskManagementOfOneProject', 'updateItem', '✅项目的任务管理-更新数据', 'sql', '{}', '{ "table": "task", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', 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, 'taskManagementOfOneProject', 'deleteItem', '✅项目的任务管理-删除信息', 'sql', '{}', '{ "table": "task", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', 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, 'taskManagementOfOneProject', 'selectAllList', '✅项目查询-查询列表', 'sql', '{}', '{ "table": "task", "operation": "select" }', NULL, NULL, 'jhInsert', 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, 'taskManagementOfOneProject', 'getProjectList', '✅项目查询-查询列表', 'sql', '{}', '{ "table": "view01_project", "operation": "select" }', NULL, NULL, 'jhInsert', 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, 'projectRecycledManagement', 'deleteProject', '✅彻底删除项目', 'service', '{}', '{"service": "project", "serviceFunction": "deleteProject"}', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
```