页面

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 'page文件指定; 默认使用pageId.html',
  `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text,
  `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 = 104 DEFAULT CHARSET = utf8mb4 COMMENT = '页面表; 软删除未启用;'

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	0	undefined

登陆

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	1	insert

员工帐号

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
员工帐号	userManagement	dynamicInMenu	null	3	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅用户管理页-修改用户状态	userManagement	changeUserStatus	null	sql	{ "table": "_user", "operation": "update" }	{"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["userStatus"],"properties":{"userStatus":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"userId":{"type":"string"}}}},"additionalProperties":true}	377	insert
✅用户管理页-创建用户	userManagement	insertItem	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	service	{ "service": "userManagement", "serviceFunction": "addUser" }	{}	378	insert
✅用户管理页-修改用户密码	userManagement	resetUserPassword	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp" } ] }	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	{}	379	insert
✅用户管理页-修改用户信息	userManagement	updateItem	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp" } ] }	sql	{ "table": "_user", "operation": "jhUpdate" }	{"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["username"],"properties":{"username":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"id":{"type":"string"}}}},"additionalProperties":true}	380	insert
✅用户管理页-查询用户列表	userManagement	selectItemList	{ "after": [ { "service": "userManagement", "serviceFunction": "filterUserData" } ] }	sql	{ "table": "enterprise_user", "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}	381	insert
✅查询App列表	userManagement	getAppList	null	sql	{ "table": "view01_user_app_role", "operation": "select" }	{}	449	insert
✅查询组织列表	userManagement	getGroupList	{ "after": [ { "service": "userManagement", "serviceFunction": "filterGroupByAuth" } ] }	sql	{ "table": "_group", "operation": "select" }	{}	452	insert
✅查询角色列表	userManagement	getRoleList	null	sql	{ "table": "_role", "operation": "select" }	{}	453	insert
✅查询待创建的用户列表	userManagement	selectUserToBeCreatedList	null	service	{ "service": "userManagement", "serviceFunction": "getUserToBeCreatedList" }	{}	454	insert
✅计算待创建的用户列表	userManagement	calculateToBeCreatedUser	null	service	{ "service": "userManagement", "serviceFunction": "calculateToBeCreatedUser" }	{}	455	insert

用户列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
用户列表	staffUserList	showInMenu	null	3	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅用户列表【职员】-修改用户密码	staffUserList	batchStaffUserAddApp	null	service	{ "service": "staff", "serviceFunction": "batchStaffUserAddApp" }	{}	458	insert
✅用户列表【职员】-查询用户列表	staffUserList	selectAppList	null	sql	{ "table": "enterprise_app", "operation": "select" }	{}	459	insert
✅用户列表【职员】-批量创建用户	staffUserList	batchCreateStaffUser	null	service	{ "service": "userManagement", "serviceFunction": "batchCreateStaffUser" }	{}	461	insert
✅用户列表【职员】-创建用户	staffUserList	insertItem	null	service	{ "service": "userManagement", "serviceFunction": "addUser" }	{}	462	insert
✅用户列表【职员】-修改用户信息	staffUserList	updateItem	null	sql	{ "table": "_user", "operation": "update" }	{}	463	insert
✅用户列表【职员】-查询用户列表	staffUserList	selectItemList	null	sql	{ "table": "_view01_user", "operation": "select" }	{}	464	insert
✅用户列表【职员】-修改用户密码	staffUserList	resetUserPassword	null	service	{ "service": "userManagement", "serviceFunction": "resetUserPassword" }	{}	465	insert
✅用户列表【职员】-查询职员列表	staffUserList	selectStaffList	null	sql	{ "table": "view01_employee", "operation": "select" }	{}	466	insert

用户列表【学生】

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
用户列表【学生】	studentUserList	dynamicInMenu	null	4	undefined

应用管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
应用管理	appManagement	showInMenu		2	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅APP管理-查询APP列表	appManagement	selectItemList	null	sql	{ "table": "enterprise_app", "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}	382	insert
✅APP管理-更新	appManagement	updateItem		sql	{ "table": "enterprise_app", "operation": "jhUpdate" }	{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}	383	insert
✅APP管理-创建APP	appManagement	insertItem	{ "after": [ { "service": "app", "serviceFunction": "buildSupperAdminUserApp" } ] }	sql	{ "table": "enterprise_app", "operation": "jhInsert" }	{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}	384	insert
✅APP管理-删除APP	appManagement	deleteItem	{ "after": [ { "service": "app", "serviceFunction": "buildSupperAdminUserApp" } ] }	sql	{ "table": "enterprise_app", "operation": "jhDelete" }	{"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true}	385	insert
✅APP管理-查询用户列表	appManagement	getUserList	null	sql	{ "table": "view01_user_app_role", "operation": "select" }		447	insert
✅APP管理-查询组织列表	appManagement	getGroupList	null	sql	{ "table": "enterprise_group", "operation": "select" }		448	insert

应用目录管理【临时】

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
应用目录管理【临时】	appDirectoryManagement	dynamicInMenu	appSetting	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	operation
✅APP目录管理-查询APP列表	appDirectoryManagement	selectItemList	null	sql	{ "table": "enterprise_app", "operation": "select" }	413	insert
✅APP目录管理-更新	appDirectoryManagement	updateItem		sql	{ "table": "enterprise_app", "operation": "jhUpdate" }	414	insert
✅APP目录管理-更新到目录	appDirectoryManagement	updateToDirectoryApp	null	service	{ "service": "app", "serviceFunction": "updateToDirectoryApp" }	415	insert
✅APP目录管理-更新App _user_group_role	appDirectoryManagement	updateAppUserGroupRole	null	service	{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }	416	insert

用户的App权限

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
用户的App权限	appManagementOfOneUser	dynamicInMenu	null	4	undefined

App的用户权限

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
App的用户权限	userManagementOfOneApp	dynamicInMenu	null	6	undefined

绑定微信

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
绑定微信	bindWx	dynamicInMenu	null	null	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	bindWx	passwordLogin	null	service	{ "service": "userManagement", "serviceFunction": "passwordLogin" }		{}	460	insert

enterpriseRoleManagement页面

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
enterpriseRoleManagement页面	enterpriseRoleManagement		null	5	undefined

应用设置

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
应用设置	appSetting	showInAvatarMenu		0	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅APP管理-查询APP列表	appSetting	selectItemList	null	sql	{ "table": "enterprise_app", "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}	417	insert
✅APP管理-更新	appSetting	updateItem	{ "before": [ { "service": "app", "serviceFunction": "checkDatabaseExist" } ] }	sql	{ "table": "enterprise_app", "operation": "jhUpdate" }	{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName","appType"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}	418	insert
✅APP管理-创建APP	appSetting	insertItem	{ "before": [ { "service": "app", "serviceFunction": "checkDatabaseExist" } ], "after": [ { "service": "app", "serviceFunction": "buildSupperAdminUserApp" } ] }	sql	{ "table": "enterprise_app", "operation": "jhInsert" }	{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName","appType"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}	419	insert
✅APP管理-删除APP	appSetting	deleteItem	{ "after": [ { "service": "app", "serviceFunction": "buildSupperAdminUserApp" } ] }	sql	{ "table": "enterprise_app", "operation": "jhDelete" }	{"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true}	420	insert
✅APP目录管理-更新App _user_group_role	appSetting	updateAppUserGroupRole	null	service	{ "service": "app", "serviceFunction": "updateAppUserGroupRole" }		421	insert

[组织权限]组织管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[组织权限]组织管理	groupManagement	showInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	groupManagement	selectItemList	null	sql	{ "table": "enterprise_group", "operation": "select" }	{}	422	insert
✅添加	groupManagement	insertItem	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	sql	{ "table": "enterprise_group", "operation": "insert" }	{"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["groupId","groupName"],"properties":{"groupId":{"type":"string"},"groupName":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true}	423	insert
✅更新	groupManagement	updateItem	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	sql	{ "table": "enterprise_group", "operation": "jhUpdate" }	{}	424	insert
✅删除	groupManagement	deleteItem	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	service	{ "service": "group", "serviceFunction": "deteleGroup" }	{}	425	insert
✅查询用户列表	groupManagement	getUserList	null	sql	{ "table": "enterprise_user", "operation": "select" }	{}	450	insert
✅设置组织负责人	groupManagement	setPrincipal	null	sql	{ "table": "_group", "operation": "jhUpdate" }	{}	451	insert

[组织权限]组织权限分配

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[组织权限]组织权限分配	groupAuthorityManagement	showInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅删除	groupAuthorityManagement	deleteItem		service	{ "service": "userGroupRole", "serviceFunction": "deleteGroupRole" }	{}	397	insert
✅组织权限列表	groupAuthorityManagement	selectItemList	null	sql	{ "table": "view01_user_role", "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}	426	insert
✅获取App列表	groupAuthorityManagement	selectAppList	null	sql	{ "table": "enterprise_app", "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}	427	insert
✅获取角色列表	groupAuthorityManagement	selectRoleList	null	sql	{ "table": "enterprise_role", "operation": "select" }	{}	428	insert
✅角色的用户列表	groupAuthorityManagement	getUserGroupRolePage	null	sql	{ "table": "enterprise_user_group_role_page", "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}	429	insert
✅角色的用户列表	groupAuthorityManagement	updateUserGroupRolePage	null	service	{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRolePage" }	{}	430	insert
✅添加	groupAuthorityManagement	insertRoleItem	{ "after": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	sql	{ "table": "enterprise_role", "operation": "insert" }	{}	431	insert

[组织权限]组织人员

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[组织权限]组织人员	groupUserManagement	showInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅组织权限列表	groupUserManagement	selectItemList	{ "after": [ { "service": "userManagement", "serviceFunction": "filterUserData" } ] }	sql	{ "table": "view01_user_role", "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}	441	insert
✅查询列表	groupUserManagement	selectRoleList	null	sql	{ "table": "enterprise_role", "operation": "select" }	{}	442	insert
✅添加	groupUserManagement	insertGroupUser	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	service	{ "service": "userGroupRole", "serviceFunction": "insertUserGroupRole" }	{}	443	insert
✅更新	groupUserManagement	updateGroupUser	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	service	{ "service": "userGroupRole", "serviceFunction": "updateUserGroupRole" }	{}	444	insert
✅删除	groupUserManagement	deleteGroupUser	{ "before": [ { "service": "userGroupRole", "serviceFunction": "checkIsGroupPrincipalByCommon" } ] }	service	{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }	{}	445	insert
✅角色的用户列表	groupUserManagement	getUserData	null	sql	{ "table": "_view01_user", "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}	446	insert
✅查询组织列表	groupUserManagement	getGroupList	{ "after": [ { "service": "userManagement", "serviceFunction": "filterGroupByAuth" } ] }	sql	{ "table": "_group", "operation": "select" }	{}	456	insert

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', NULL, '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'userManagement', '员工帐号', NULL, 'dynamicInMenu', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'staffUserList', '用户列表', NULL, 'showInMenu', NULL, '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'studentUserList', '用户列表【学生】', NULL, 'dynamicInMenu', NULL, '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'appManagement', '应用管理', '', 'showInMenu', NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'appDirectoryManagement', '应用目录管理【临时】', 'appSetting', 'dynamicInMenu', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 'appManagementOfOneUser', '用户的App权限', NULL, 'dynamicInMenu', NULL, '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'userManagementOfOneApp', 'App的用户权限', NULL, 'dynamicInMenu', NULL, '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'bindWx', '绑定微信', NULL, 'dynamicInMenu', '{"beforeHook": [
    {"service": "wechat", "serviceFunc": "checkUserLogin", "field": "wxConfig"}
]}', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'enterpriseRoleManagement', 'enterpriseRoleManagement页面', NULL, '', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'appSetting', '应用设置', '', 'showInAvatarMenu', NULL, '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'groupManagement', '[组织权限]组织管理', NULL, 'showInMenu', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'groupAuthorityManagement', '[组织权限]组织权限分配', NULL, 'showInMenu', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (63, 'groupUserManagement', '[组织权限]组织人员', NULL, 'showInMenu', NULL, '5', '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 'page文件指定; 默认使用pageId.html',
  `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text,
  `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 = 104 DEFAULT CHARSET = utf8mb4 COMMENT = '页面表; 软删除未启用;'
```

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | help | dynamicInMenu | helpV4 | 0 | undefined |

## 登陆

- **页面信息**

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

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | login | passwordLogin | null | service | { "service": "user", "serviceFunction": "passwordLogin" } |  | {} | 1 | insert |  |  |  |  |  |

## 员工帐号

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 员工帐号 | userManagement | dynamicInMenu | null | 3 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅用户管理页-修改用户状态 | userManagement | changeUserStatus | null | sql | { "table": "_user", "operation": "update" } |  | {"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["userStatus"],"properties":{"userStatus":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"userId":{"type":"string"}}}},"additionalProperties":true} | 377 | insert |  |  |  |  |  |
| ✅用户管理页-创建用户 | userManagement | insertItem | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | service | { "service": "userManagement", "serviceFunction": "addUser" } |  | {} | 378 | insert |  |  |  |  |  |
| ✅用户管理页-修改用户密码 | userManagement | resetUserPassword | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"     }   ] } | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  | {} | 379 | insert |  |  |  |  |  |
| ✅用户管理页-修改用户信息 | userManagement | updateItem | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByDeleteGroupIp"     }   ] } | sql | { "table": "_user", "operation": "jhUpdate" } |  | {"type":"object","required":["actionData","where"],"properties":{"actionData":{"type":"object","required":["username"],"properties":{"username":{"type":"string"}},"additionalProperties":true},"where":{"type":"object","required":["userId"],"properties":{"id":{"type":"string"}}}},"additionalProperties":true} | 380 | insert |  |  |  |  |  |
| ✅用户管理页-查询用户列表 | userManagement | selectItemList | {   "after": [     {       "service": "userManagement",       "serviceFunction": "filterUserData"     }   ] } | sql | { "table": "enterprise_user", "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} | 381 | insert |  |  |  |  |  |
| ✅查询App列表 | userManagement | getAppList | null | sql | { "table": "view01_user_app_role", "operation": "select" } |  | {} | 449 | insert |  |  |  |  |  |
| ✅查询组织列表 | userManagement | getGroupList | {   "after": [     {       "service": "userManagement",       "serviceFunction": "filterGroupByAuth"     }   ] } | sql | { "table": "_group", "operation": "select" } |  | {} | 452 | insert |  |  |  |  |  |
| ✅查询角色列表 | userManagement | getRoleList | null | sql | { "table": "_role", "operation": "select" } |  | {} | 453 | insert |  |  |  |  |  |
| ✅查询待创建的用户列表 | userManagement | selectUserToBeCreatedList | null | service | { "service": "userManagement", "serviceFunction": "getUserToBeCreatedList" } |  | {} | 454 | insert |  |  |  |  |  |
| ✅计算待创建的用户列表 | userManagement | calculateToBeCreatedUser | null | service | { "service": "userManagement", "serviceFunction": "calculateToBeCreatedUser" } |  | {} | 455 | insert |  |  |  |  |  |

## 用户列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 用户列表 | staffUserList | showInMenu | null | 3 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅用户列表【职员】-修改用户密码 | staffUserList | batchStaffUserAddApp | null | service | { "service": "staff", "serviceFunction": "batchStaffUserAddApp" } |  | {} | 458 | insert |  |  |  |  |  |
| ✅用户列表【职员】-查询用户列表 | staffUserList | selectAppList | null | sql | { "table": "enterprise_app", "operation": "select" } |  | {} | 459 | insert |  |  |  |  |  |
| ✅用户列表【职员】-批量创建用户 | staffUserList | batchCreateStaffUser | null | service | { "service": "userManagement", "serviceFunction": "batchCreateStaffUser" } |  | {} | 461 | insert |  |  |  |  |  |
| ✅用户列表【职员】-创建用户 | staffUserList | insertItem | null | service | { "service": "userManagement", "serviceFunction": "addUser" } |  | {} | 462 | insert |  |  |  |  |  |
| ✅用户列表【职员】-修改用户信息 | staffUserList | updateItem | null | sql | { "table": "_user", "operation": "update" } |  | {} | 463 | insert |  |  |  |  |  |
| ✅用户列表【职员】-查询用户列表 | staffUserList | selectItemList | null | sql | { "table": "_view01_user", "operation": "select" } |  | {} | 464 | insert |  |  |  |  |  |
| ✅用户列表【职员】-修改用户密码 | staffUserList | resetUserPassword | null | service | { "service": "userManagement", "serviceFunction": "resetUserPassword" } |  | {} | 465 | insert |  |  |  |  |  |
| ✅用户列表【职员】-查询职员列表 | staffUserList | selectStaffList | null | sql | { "table": "view01_employee", "operation": "select" } |  | {} | 466 | insert |  |  |  |  |  |

## 用户列表【学生】

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 用户列表【学生】 | studentUserList | dynamicInMenu | null | 4 | undefined |

## 应用管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 应用管理 | appManagement | showInMenu |  | 2 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅APP管理-查询APP列表 | appManagement | selectItemList | null | sql | { "table": "enterprise_app", "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} | 382 | insert |  |  |  |  |  |
| ✅APP管理-更新 | appManagement | updateItem |  | sql | { "table": "enterprise_app", "operation": "jhUpdate" } |  | {"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true} | 383 | insert |  |  |  |  |  |
| ✅APP管理-创建APP | appManagement | insertItem | {   "after": [     {       "service": "app",       "serviceFunction": "buildSupperAdminUserApp"     }   ] } | sql | { "table": "enterprise_app", "operation": "jhInsert" } |  | {"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true} | 384 | insert |  |  |  |  |  |
| ✅APP管理-删除APP | appManagement | deleteItem | {   "after": [     {       "service": "app",       "serviceFunction": "buildSupperAdminUserApp"     }   ] } | sql | { "table": "enterprise_app", "operation": "jhDelete" } |  | {"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true} | 385 | insert |  |  |  |  |  |
| ✅APP管理-查询用户列表 | appManagement | getUserList | null | sql | { "table": "view01_user_app_role", "operation": "select" } |  |  | 447 | insert |  |  |  |  |  |
| ✅APP管理-查询组织列表 | appManagement | getGroupList | null | sql | { "table": "enterprise_group", "operation": "select" } |  |  | 448 | insert |  |  |  |  |  |

## 应用目录管理【临时】

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 应用目录管理【临时】 | appDirectoryManagement | dynamicInMenu | appSetting | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅APP目录管理-查询APP列表 | appDirectoryManagement | selectItemList | null | sql | { "table": "enterprise_app", "operation": "select" } |  |  | 413 | insert |  |  |  |  |  |
| ✅APP目录管理-更新 | appDirectoryManagement | updateItem |  | sql | { "table": "enterprise_app", "operation": "jhUpdate" } |  |  | 414 | insert |  |  |  |  |  |
| ✅APP目录管理-更新到目录 | appDirectoryManagement | updateToDirectoryApp | null | service | { "service": "app", "serviceFunction": "updateToDirectoryApp" } |  |  | 415 | insert |  |  |  |  |  |
| ✅APP目录管理-更新App _user_group_role | appDirectoryManagement | updateAppUserGroupRole | null | service | { "service": "app", "serviceFunction": "updateAppUserGroupRole" } |  |  | 416 | insert |  |  |  |  |  |

## 用户的App权限

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 用户的App权限 | appManagementOfOneUser | dynamicInMenu | null | 4 | undefined |

## App的用户权限

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| App的用户权限 | userManagementOfOneApp | dynamicInMenu | null | 6 | undefined |

## 绑定微信

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 绑定微信 | bindWx | dynamicInMenu | null | null | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | bindWx | passwordLogin | null | service | { "service": "userManagement", "serviceFunction": "passwordLogin" } |  | {} | 460 | insert |  |  |  |  |  |

## enterpriseRoleManagement页面

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| enterpriseRoleManagement页面 | enterpriseRoleManagement |  | null | 5 | undefined |

## 应用设置

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 应用设置 | appSetting | showInAvatarMenu |  | 0 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅APP管理-查询APP列表 | appSetting | selectItemList | null | sql | { "table": "enterprise_app", "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} | 417 | insert |  |  |  |  |  |
| ✅APP管理-更新 | appSetting | updateItem | {   "before": [     {       "service": "app",       "serviceFunction": "checkDatabaseExist"     }   ] } | sql | { "table": "enterprise_app", "operation": "jhUpdate" } |  | {"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appName","appType"],"properties":{"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true} | 418 | insert |  |  |  |  |  |
| ✅APP管理-创建APP | appSetting | insertItem | {   "before": [     {       "service": "app",       "serviceFunction": "checkDatabaseExist"     }   ],   "after": [     {       "service": "app",       "serviceFunction": "buildSupperAdminUserApp"     }   ] } | sql | { "table": "enterprise_app", "operation": "jhInsert" } |  | {"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["appId","appName","appType"],"properties":{"appId":{"type":"string"},"appName":{"type":"string"},"appType":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true} | 419 | insert |  |  |  |  |  |
| ✅APP管理-删除APP | appSetting | deleteItem | {   "after": [     {       "service": "app",       "serviceFunction": "buildSupperAdminUserApp"     }   ] } | sql | { "table": "enterprise_app", "operation": "jhDelete" } |  | {"type":"object","required":["where"],"properties":{"where":{"type":"object","required":["id"],"properties":{"id":{"type":"number"}}}},"additionalProperties":true} | 420 | insert |  |  |  |  |  |
| ✅APP目录管理-更新App _user_group_role | appSetting | updateAppUserGroupRole | null | service | { "service": "app", "serviceFunction": "updateAppUserGroupRole" } |  |  | 421 | insert |  |  |  |  |  |

## [组织权限]组织管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| [组织权限]组织管理 | groupManagement | showInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | groupManagement | selectItemList | null | sql | { "table": "enterprise_group", "operation": "select" } |  | {} | 422 | insert |  |  |  |  |  |
| ✅添加 | groupManagement | insertItem | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | sql | { "table": "enterprise_group", "operation": "insert" } |  | {"type":"object","required":["actionData"],"properties":{"actionData":{"type":"object","required":["groupId","groupName"],"properties":{"groupId":{"type":"string"},"groupName":{"type":"string"}},"additionalProperties":true}},"additionalProperties":true} | 423 | insert |  |  |  |  |  |
| ✅更新 | groupManagement | updateItem | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | sql | { "table": "enterprise_group", "operation": "jhUpdate" } |  | {} | 424 | insert |  |  |  |  |  |
| ✅删除 | groupManagement | deleteItem | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | service | { "service": "group", "serviceFunction": "deteleGroup" } |  | {} | 425 | insert |  |  |  |  |  |
| ✅查询用户列表 | groupManagement | getUserList | null | sql | { "table": "enterprise_user", "operation": "select" } |  | {} | 450 | insert |  |  |  |  |  |
| ✅设置组织负责人 | groupManagement | setPrincipal | null | sql | { "table": "_group", "operation": "jhUpdate" } |  | {} | 451 | insert |  |  |  |  |  |

## [组织权限]组织权限分配

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| [组织权限]组织权限分配 | groupAuthorityManagement | showInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅删除 | groupAuthorityManagement | deleteItem |  | service | { "service": "userGroupRole", "serviceFunction": "deleteGroupRole" } |  | {} | 397 | insert |  |  |  |  |  |
| ✅组织权限列表 | groupAuthorityManagement | selectItemList | null | sql | { "table": "view01_user_role", "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} | 426 | insert |  |  |  |  |  |
| ✅获取App列表 | groupAuthorityManagement | selectAppList | null | sql | { "table": "enterprise_app", "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} | 427 | insert |  |  |  |  |  |
| ✅获取角色列表 | groupAuthorityManagement | selectRoleList | null | sql | { "table": "enterprise_role", "operation": "select" } |  | {} | 428 | insert |  |  |  |  |  |
| ✅角色的用户列表 | groupAuthorityManagement | getUserGroupRolePage | null | sql | { "table": "enterprise_user_group_role_page", "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} | 429 | insert |  |  |  |  |  |
| ✅角色的用户列表 | groupAuthorityManagement | updateUserGroupRolePage | null | service | { "service": "userGroupRole", "serviceFunction": "updateUserGroupRolePage" } |  | {} | 430 | insert |  |  |  |  |  |
| ✅添加 | groupAuthorityManagement | insertRoleItem | {   "after": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | sql | { "table": "enterprise_role", "operation": "insert" } |  | {} | 431 | insert |  |  |  |  |  |

## [组织权限]组织人员

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| [组织权限]组织人员 | groupUserManagement | showInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅组织权限列表 | groupUserManagement | selectItemList | {   "after": [     {       "service": "userManagement",       "serviceFunction": "filterUserData"     }   ] } | sql | { "table": "view01_user_role", "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} | 441 | insert |  |  |  |  |  |
| ✅查询列表 | groupUserManagement | selectRoleList | null | sql | { "table": "enterprise_role", "operation": "select" } |  | {} | 442 | insert |  |  |  |  |  |
| ✅添加 | groupUserManagement | insertGroupUser | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | service | { "service": "userGroupRole", "serviceFunction": "insertUserGroupRole" } |  | {} | 443 | insert |  |  |  |  |  |
| ✅更新 | groupUserManagement | updateGroupUser | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | service | { "service": "userGroupRole", "serviceFunction": "updateUserGroupRole" } |  | {} | 444 | insert |  |  |  |  |  |
| ✅删除 | groupUserManagement | deleteGroupUser | {   "before": [     {       "service": "userGroupRole",       "serviceFunction": "checkIsGroupPrincipalByCommon"     }   ] } | service | { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } |  | {} | 445 | insert |  |  |  |  |  |
| ✅角色的用户列表 | groupUserManagement | getUserData | null | sql | { "table": "_view01_user", "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} | 446 | insert |  |  |  |  |  |
| ✅查询组织列表 | groupUserManagement | getGroupList | {   "after": [     {       "service": "userManagement",       "serviceFunction": "filterGroupByAuth"     }   ] } | sql | { "table": "_group", "operation": "select" } |  | {} | 456 | insert |  |  |  |  |  |

## _page语句

```sql
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', NULL, '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'userManagement', '员工帐号', NULL, 'dynamicInMenu', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'staffUserList', '用户列表', NULL, 'showInMenu', NULL, '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'studentUserList', '用户列表【学生】', NULL, 'dynamicInMenu', NULL, '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'appManagement', '应用管理', '', 'showInMenu', NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'appDirectoryManagement', '应用目录管理【临时】', 'appSetting', 'dynamicInMenu', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 'appManagementOfOneUser', '用户的App权限', NULL, 'dynamicInMenu', NULL, '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'userManagementOfOneApp', 'App的用户权限', NULL, 'dynamicInMenu', NULL, '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'bindWx', '绑定微信', NULL, 'dynamicInMenu', '{"beforeHook": [
	{"service": "wechat", "serviceFunc": "checkUserLogin", "field": "wxConfig"}
]}', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'enterpriseRoleManagement', 'enterpriseRoleManagement页面', NULL, '', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'appSetting', '应用设置', '', 'showInAvatarMenu', NULL, '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'groupManagement', '[组织权限]组织管理', NULL, 'showInMenu', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'groupAuthorityManagement', '[组织权限]组织权限分配', NULL, 'showInMenu', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (63, 'groupUserManagement', '[组织权限]组织人员', NULL, 'showInMenu', NULL, '5', 'insert', NULL, NULL, NULL);
```