页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT '对应的html文件',
  `pageHook` varchar(255)  DEFAULT NULL COMMENT 'pageHook',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `sort` varchar(255)  DEFAULT NULL,
  `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 = 56 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	11	null

登陆

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{"service": "user", "serviceFunction": "passwordLogin"}			1	update	2022-06-30T09:59:55+08:00

流程管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
流程管理	workflowManagement	showInMenu	null	1	null

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId
✅查询-用户列表	workflowManagement	selectUserList		sql	{"table": "_view01_user", "operation": "select"}		101	update	2022-07-04T22:27:58+08:00	vscode	vscode
✅查询-组列表	workflowManagement	selectGroupList		sql	{"table": "_group", "operation": "select"}		102	update	2022-07-04T22:27:58+08:00	vscode	vscode
✅workflowManagement查询-查询列表	workflowManagement	selectItemList	null	sql	{"table": "workflow", "operation": "select"}	{}	103	insert
✅workflowManagement查询-添加成员	workflowManagement	insertItem	{ "before": [ { "service": "workflow", "serviceFunction": "createWorkflowId" } ] }	sql	{"table": "workflow", "operation": "jhInsert"}	{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["workflowName","workflowId","workflowConfig","workflowForm"],"properties":{"workflowName":{"type":"string"},"workflowConfig":{"type":"string"},"workflowForm":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}	104	insert
✅workflowManagement查询-更新成员	workflowManagement	updateItem	null	sql	{"table": "workflow", "operation": "jhUpdate"}	{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["workflowName","workflowId","workflowConfig","workflowForm"],"properties":{"workflowName":{"type":"string"},"workflowId":{"type":"string"},"workflowConfig":{"type":"string"},"workflowForm":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}	105	insert

流程编辑

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
流程编辑	workflowEditor	dynamicInMenu	null	1	null

发起工单

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
发起工单	createTask	showInMenu	null	2	{
"beforeHook":[

{"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
]

} |

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId
✅添加	createTask	insertTask	null	service	{ "service": "workflow", "serviceFunction": "createWorkflowTask" }	{}	201	insert
✅查询-查询列表	createTask	selectItemList	{ "before": [ { "service": "task", "serviceFunction": "appendTaskInitUserBeforeHook" } ] }	sql	{"table": "task", "operation": "select"}	{}	202	insert
✅查询-用户列表	createTask	selectUserList		sql	{"table": "_view01_user", "operation": "select"}		203	update	2022-07-04T22:27:58+08:00	vscode	vscode
✅查询-流程列表	createTask	createTaskDrawer-selectWorkflowList	null	sql	{"table": "workflow", "operation": "select"}	{}	204	insert

处理工单

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
处理工单	todo	showInMenu	null	7	{
"beforeHook":[

{"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
]

} |

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	todo	selectItemList	null	sql	{ "table": "task", "operation": "select" }	{}	301	insert
✅更新	todo	submitNode	null	service	{ "service": "task", "serviceFunction": "submitNode" }	{}	302	insert
✅已处理	todo	selectHistoryList	null	sql	{ "table": "task_history", "operation": "select" }	{"type":"object","required":["where","whereLike","orderBy"],"properties":{"where":{"type":"object","required":["taskStatus"],"properties":{"taskStatus":{"type":"string"}}},"whereLike":{"type":"object","required":["taskEditUserList"],"properties":{"taskEditUserList":{"type":"string"},"taskConfigId":{"type":"string"}}},"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}	303	insert
✅添加	todo	getTaskHistory	null	service	{ "service": "workflow", "serviceFunction": "getTaskHistory" }	{}	304	insert
✅转交	todo	transferNode	null	service	{ "service": "task", "serviceFunction": "transferNode" }	{}	305	insert
✅沟通	todo	addCommentNode	null	service	{ "service": "task", "serviceFunction": "addCommentNode" }	{}	306	insert

工单列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
工单列表	taskHistory	showInMenu	null	8	{
"beforeHook":[

{"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
]

} |

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅作业-创建作业	taskHistory	selectItemList	{ "after": [ { "service": "workflow", "serviceFunction": "appendUsername" } ] }	sql	{ "table": "task", "operation": "select" }		{"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true}	401	insert

权限管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
权限管理	userGroupRole	showInMenu		11

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	operation	operationAt	requestDemo	responseDemo
✅权限管理页-查询已配置权限列表	userGroupRole	selectItemList	null	sql	{"table": "_user_group_role", "operation": "select"}	402	update	2022-05-02T15:23:51+08:00	{"appData": {"appId": "demo_advanced", "where": {"userId": "001"}, "pageId": "userGroupRole", "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476230231_7262893", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectItemList", "resultData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476230231_7262893", "timestamp": "2022-05-02T15:23:50+08:00", "packageType": "httpResponse"}
✅权限管理页-查询用户	userGroupRole	selectUser	null	sql	{"table": "_view02_user_app", "operation": "select"}	403	update	2022-05-02T15:23:58+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476237658_7645348", "packageType": "httpRequest"}	{"status": "success", "packageId": "1651476237658_7645348", "timestamp": "2022-05-02T15:23:58+08:00", "packageType": "httpResponse"}
✅权限管理页-查询群组	userGroupRole	selectGroup	null	sql	{"table": "_group", "operation": "select"}	404	update	2022-05-02T15:21:29+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_6618462", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "resultData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476088200_6618462", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}
✅权限管理页-创建权限配置	userGroupRole	insertItem	null	sql	{"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""}	405	update	2022-04-28T20:36:12+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"roleId": "teacher", "userId": "admin2", "groupId": "adminGroup"}}, "packageId": "1651149371608_1485871", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [599], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "resultData": {"rows": [599]}}, "packageId": "1651149371608_1485871", "timestamp": "2022-04-28T20:36:12+08:00", "packageType": "httpResponse"}
✅权限管理页-更新权限配置	userGroupRole	updateItem	null	sql	{"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}	406	update	2022-02-18T12:09:29+08:00	{}	{}
✅权限管理页-删除权限配置	userGroupRole	deleteItem	null	sql	{"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}	407	update	2022-02-18T21:03:41+08:00	{}	{}
✅权限管理页-查询角色	userGroupRole	selectRole	null	sql	{"table": "_role", "operation": "select"}	408	update	2022-05-02T15:21:29+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_7966907", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "resultData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}]}}, "packageId": "1651476088200_7966907", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}
✅权限管理页-添加用户	userGroupRole	insertUser	null	service	{"service": "userManagement", "serviceFunction": "addUser"}	409	update	2022-04-28T20:35:24+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "admin2", "username": "admin2", "clearTextPassword": "123456"}}, "packageId": "1651149323428_7722305", "packageType": "httpRequest"}	{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "resultData": {}}, "packageId": "1651149323428_7722305", "timestamp": "2022-04-28T20:35:24+08:00", "packageType": "httpResponse"}
✅权限管理页-添加群组	userGroupRole	insertGroup	null	sql	{"table": "_group", "operation": "jhInsert"}	410	update	2022-02-18T19:55:57+08:00	{}	{}
✅权限管理页-添加角色	userGroupRole	insertRole	null	sql	{"table": "_role", "operation": "jhInsert"}	411	update	2022-02-18T20:00:37+08:00	{}	{}
✅权限管理页-删除用户	userGroupRole	deleteUser	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_user", "operation": "jhDelete"}	412	update	2022-04-28T20:36:24+08:00	{"appData": {"appId": "demo_advanced", "where": {"userId": "admin2"}, "pageId": "userGroupRole", "actionId": "deleteUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651149383707_8632195", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "deleteUser", "resultData": {"rows": 1}}, "packageId": "1651149383707_8632195", "timestamp": "2022-04-28T20:36:24+08:00", "packageType": "httpResponse"}
✅权限管理页-删除群组	userGroupRole	deleteGroup	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_group", "operation": "jhDelete"}	413	update	2022-02-18T19:56:11+08:00	{}	{}
✅权限管理页-删除角色	userGroupRole	deleteRole	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_role", "operation": "jhDelete"}	414	update	2022-02-18T20:04:23+08:00	{}	{}
✅权限管理页-更新群组	userGroupRole	updateGroup	null	sql	{"table": "_group", "operation": "jhUpdate"}	416	update	2022-02-18T20:45:26+08:00	{}	{}
✅权限管理页-更新角色	userGroupRole	updateRole	null	sql	{"table": "_role", "operation": "jhUpdate"}	417	update	2022-02-18T19:56:37+08:00	{}	{}

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (48, 'help', '帮助', 'helpV4', NULL, 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'login', '登陆', 'loginV4', NULL, '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'workflowManagement', '流程管理', NULL, NULL, 'showInMenu', '1', 'update', 'vscode', 'vscode', '2022-10-08T09:35:35+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'workflowEditor', '流程编辑', NULL, NULL, 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'createTask', '发起工单', NULL, '{
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
    ]
}', 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (53, 'todo', '处理工单', NULL, '{
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
    ]
}', 'showInMenu', '7', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'taskHistory', '工单列表', NULL, '{
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
    ]
}', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'userGroupRole', '权限管理', '', '', 'showInMenu', '11', 'insert', NULL, NULL, NULL);

# 页面总览

## _page结构

```sql
CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT '对应的html文件',
  `pageHook` varchar(255)  DEFAULT NULL COMMENT 'pageHook',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `sort` varchar(255)  DEFAULT NULL,
  `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 = 56 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'
```

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | help | dynamicInMenu | helpV4 | 11 | null |

## 登陆

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 登陆 | login |  | loginV4 |  | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | login | passwordLogin | null | service | {"service": "user", "serviceFunction": "passwordLogin"} |  |  | 1 | update | 2022-06-30T09:59:55+08:00 |  |  |  |  |

## 流程管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 流程管理 | workflowManagement | showInMenu | null | 1 | null |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询-用户列表 | workflowManagement | selectUserList |  | sql | {"table": "_view01_user", "operation": "select"} |  |  | 101 | update | 2022-07-04T22:27:58+08:00 | vscode | vscode |  |  |
| ✅查询-组列表 | workflowManagement | selectGroupList |  | sql | {"table": "_group", "operation": "select"} |  |  | 102 | update | 2022-07-04T22:27:58+08:00 | vscode | vscode |  |  |
| ✅workflowManagement查询-查询列表 | workflowManagement | selectItemList | null | sql | {"table": "workflow", "operation": "select"} |  | {} | 103 | insert |  |  |  |  |  |
| ✅workflowManagement查询-添加成员 | workflowManagement | insertItem | {   "before": [     {       "service": "workflow",       "serviceFunction": "createWorkflowId"     }   ] } | sql | {"table": "workflow", "operation": "jhInsert"} |  | {"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["workflowName","workflowId","workflowConfig","workflowForm"],"properties":{"workflowName":{"type":"string"},"workflowConfig":{"type":"string"},"workflowForm":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true} | 104 | insert |  |  |  |  |  |
| ✅workflowManagement查询-更新成员 | workflowManagement | updateItem | null | sql | {"table": "workflow", "operation": "jhUpdate"} |  | {"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["workflowName","workflowId","workflowConfig","workflowForm"],"properties":{"workflowName":{"type":"string"},"workflowId":{"type":"string"},"workflowConfig":{"type":"string"},"workflowForm":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true} | 105 | insert |  |  |  |  |  |

## 流程编辑

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 流程编辑 | workflowEditor | dynamicInMenu | null | 1 | null |

## 发起工单

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 发起工单 | createTask | showInMenu | null | 2 | {
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
	]
} |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅添加 | createTask | insertTask | null | service | { "service": "workflow", "serviceFunction": "createWorkflowTask" } |  | {} | 201 | insert |  |  |  |  |  |
| ✅查询-查询列表 | createTask | selectItemList | {   "before": [     {       "service": "task",       "serviceFunction": "appendTaskInitUserBeforeHook"     }   ] } | sql | {"table": "task", "operation": "select"} |  | {} | 202 | insert |  |  |  |  |  |
| ✅查询-用户列表 | createTask | selectUserList |  | sql | {"table": "_view01_user", "operation": "select"} |  |  | 203 | update | 2022-07-04T22:27:58+08:00 | vscode | vscode |  |  |
| ✅查询-流程列表 | createTask | createTaskDrawer-selectWorkflowList | null | sql | {"table": "workflow", "operation": "select"} |  | {} | 204 | insert |  |  |  |  |  |

## 处理工单

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 处理工单 | todo | showInMenu | null | 7 | {
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
	]
} |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | todo | selectItemList | null | sql | { "table": "task", "operation": "select" } |  | {} | 301 | insert |  |  |  |  |  |
| ✅更新 | todo | submitNode | null | service | { "service": "task", "serviceFunction": "submitNode" } |  | {} | 302 | insert |  |  |  |  |  |
| ✅已处理 | todo | selectHistoryList | null | sql | { "table": "task_history", "operation": "select" } |  | {"type":"object","required":["where","whereLike","orderBy"],"properties":{"where":{"type":"object","required":["taskStatus"],"properties":{"taskStatus":{"type":"string"}}},"whereLike":{"type":"object","required":["taskEditUserList"],"properties":{"taskEditUserList":{"type":"string"},"taskConfigId":{"type":"string"}}},"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true} | 303 | insert |  |  |  |  |  |
| ✅添加 | todo | getTaskHistory | null | service | { "service": "workflow", "serviceFunction": "getTaskHistory" } |  | {} | 304 | insert |  |  |  |  |  |
| ✅转交 | todo | transferNode | null | service | { "service": "task", "serviceFunction": "transferNode" } |  | {} | 305 | insert |  |  |  |  |  |
| ✅沟通 | todo | addCommentNode | null | service | { "service": "task", "serviceFunction": "addCommentNode" } |  | {} | 306 | insert |  |  |  |  |  |

## 工单列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 工单列表 | taskHistory | showInMenu | null | 8 | {
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
	]
} |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅作业-创建作业 | taskHistory | selectItemList | {   "after": [     {       "service": "workflow",       "serviceFunction": "appendUsername"     }   ] } | sql | { "table": "task", "operation": "select" } |  | {"type":"object","required":["orderBy"],"properties":{"orderBy":{"type":"array","minItems":1,"items":{"type":"object","required":["column","order"],"properties":{"column":{"type":"string"},"order":{"type":"string"}}}}},"additionalProperties":true} | 401 | insert |  |  |  |  |  |

## 权限管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 权限管理 | userGroupRole | showInMenu |  | 11 |  |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅权限管理页-查询已配置权限列表 | userGroupRole | selectItemList | null | sql | {"table": "_user_group_role", "operation": "select"} |  |  | 402 | update | 2022-05-02T15:23:51+08:00 |  |  | {"appData": {"appId": "demo_advanced", "where": {"userId": "001"}, "pageId": "userGroupRole", "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476230231_7262893", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectItemList", "resultData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476230231_7262893", "timestamp": "2022-05-02T15:23:50+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-查询用户 | userGroupRole | selectUser | null | sql | {"table": "_view02_user_app", "operation": "select"} |  |  | 403 | update | 2022-05-02T15:23:58+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476237658_7645348", "packageType": "httpRequest"} | {"status": "success", "packageId": "1651476237658_7645348", "timestamp": "2022-05-02T15:23:58+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-查询群组 | userGroupRole | selectGroup | null | sql | {"table": "_group", "operation": "select"} |  |  | 404 | update | 2022-05-02T15:21:29+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_6618462", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "resultData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476088200_6618462", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-创建权限配置 | userGroupRole | insertItem | null | sql | {"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""} |  |  | 405 | update | 2022-04-28T20:36:12+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"roleId": "teacher", "userId": "admin2", "groupId": "adminGroup"}}, "packageId": "1651149371608_1485871", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [599], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "resultData": {"rows": [599]}}, "packageId": "1651149371608_1485871", "timestamp": "2022-04-28T20:36:12+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-更新权限配置 | userGroupRole | updateItem | null | sql | {"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} |  |  | 406 | update | 2022-02-18T12:09:29+08:00 |  |  | {} | {} |
| ✅权限管理页-删除权限配置 | userGroupRole | deleteItem | null | sql | {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} |  |  | 407 | update | 2022-02-18T21:03:41+08:00 |  |  | {} | {} |
| ✅权限管理页-查询角色 | userGroupRole | selectRole | null | sql | {"table": "_role", "operation": "select"} |  |  | 408 | update | 2022-05-02T15:21:29+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_7966907", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "resultData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}]}}, "packageId": "1651476088200_7966907", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-添加用户 | userGroupRole | insertUser | null | service | {"service": "userManagement", "serviceFunction": "addUser"} |  |  | 409 | update | 2022-04-28T20:35:24+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "admin2", "username": "admin2", "clearTextPassword": "123456"}}, "packageId": "1651149323428_7722305", "packageType": "httpRequest"} | {"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "resultData": {}}, "packageId": "1651149323428_7722305", "timestamp": "2022-04-28T20:35:24+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-添加群组 | userGroupRole | insertGroup | null | sql | {"table": "_group", "operation": "jhInsert"} |  |  | 410 | update | 2022-02-18T19:55:57+08:00 |  |  | {} | {} |
| ✅权限管理页-添加角色 | userGroupRole | insertRole | null | sql | {"table": "_role", "operation": "jhInsert"} |  |  | 411 | update | 2022-02-18T20:00:37+08:00 |  |  | {} | {} |
| ✅权限管理页-删除用户 | userGroupRole | deleteUser | {   "before": [],   "after": [     {       "service": "userGroupRole",       "serviceFunction": "deleteUserGroupRole"     }   ] } | sql | {"table": "_user", "operation": "jhDelete"} |  |  | 412 | update | 2022-04-28T20:36:24+08:00 |  |  | {"appData": {"appId": "demo_advanced", "where": {"userId": "admin2"}, "pageId": "userGroupRole", "actionId": "deleteUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651149383707_8632195", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "deleteUser", "resultData": {"rows": 1}}, "packageId": "1651149383707_8632195", "timestamp": "2022-04-28T20:36:24+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-删除群组 | userGroupRole | deleteGroup | {   "before": [],   "after": [     {       "service": "userGroupRole",       "serviceFunction": "deleteUserGroupRole"     }   ] } | sql | {"table": "_group", "operation": "jhDelete"} |  |  | 413 | update | 2022-02-18T19:56:11+08:00 |  |  | {} | {} |
| ✅权限管理页-删除角色 | userGroupRole | deleteRole | {   "before": [],   "after": [     {       "service": "userGroupRole",       "serviceFunction": "deleteUserGroupRole"     }   ] } | sql | {"table": "_role", "operation": "jhDelete"} |  |  | 414 | update | 2022-02-18T20:04:23+08:00 |  |  | {} | {} |
| ✅权限管理页-更新群组 | userGroupRole | updateGroup | null | sql | {"table": "_group", "operation": "jhUpdate"} |  |  | 416 | update | 2022-02-18T20:45:26+08:00 |  |  | {} | {} |
| ✅权限管理页-更新角色 | userGroupRole | updateRole | null | sql | {"table": "_role", "operation": "jhUpdate"} |  |  | 417 | update | 2022-02-18T19:56:37+08:00 |  |  | {} | {} |

## _page语句

```sql
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (48, 'help', '帮助', 'helpV4', NULL, 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'login', '登陆', 'loginV4', NULL, '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'workflowManagement', '流程管理', NULL, NULL, 'showInMenu', '1', 'update', 'vscode', 'vscode', '2022-10-08T09:35:35+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'workflowEditor', '流程编辑', NULL, NULL, 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'createTask', '发起工单', NULL, '{
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
	]
}', 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (53, 'todo', '处理工单', NULL, '{
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
	]
}', 'showInMenu', '7', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'taskHistory', '工单列表', NULL, '{
  "beforeHook":[
    {"field": "userList", "service": "common", "serviceFunc": "getUserListBeforeHook"}
	]
}', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageHook, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'userGroupRole', '权限管理', '', '', 'showInMenu', '11', 'insert', NULL, NULL, NULL);
```