页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL,
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `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 = 43 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	11	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" }		{}	231	insert

操作手册

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
操作手册	manual	dynamicInMenu	null	0	undefined

学生宿舍管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生宿舍管理	studentHostelManagement	showInMenu	null	7	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId
✅学生宿舍管理-查询列表	studentHostelManagement	selectItemList	null	sql	{"table":"view02_student_hostel","operation":"select"}	{}	331	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生宿舍管理-添加信息	studentHostelManagement	insertItem	{ "before": [ { "service": "studentHostel", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [] }	service	{"service":"studentHostel","serviceFunction":"addHostel"}	{}	332	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生宿舍管理-更新信息	studentHostelManagement	updateItem	null	service	{"service":"studentHostel","serviceFunction":"updateHostel"}	{}	333	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生宿舍管理-删除信息	studentHostelManagement	deleteItem	null	sql	{ "table": "student_hostel", "operation": "jhDelete" }	{}	334	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生宿舍管理-查询房间信息	studentHostelManagement	selectRoomList	null	sql	{"table":"view01_student_hostel_room","operation":"select"}	{}	350	update	2022-07-19T13:45:11+08:00	vscode	vscode

学生床位分配

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生床位分配	studentBedAllocation	showInMenu	null	8	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId
✅学生床位分配-查询楼栋信息	studentBedAllocation	selectHotelList	null	sql	{"table":"view02_student_hostel","operation":"select"}	{}	351	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生床位分配-查询房间信息	studentBedAllocation	selectRoomList	null	service	{"service":"studentHostel","serviceFunction":"selectRoomList"}	{}	352	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生床位分配-分配床位	studentBedAllocation	allotRoomBed	null	service	{"service":"studentHostel","serviceFunction":"allotRoomBed"}	{}	353	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生床位分配-查询学生信息	studentBedAllocation	selectStudentList	null	service	{"service":"studentHostel","serviceFunction":"selectStudentList"}	{}	354	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅学生床位分配-查询房间信息	studentBedAllocation	searchStudentItem	null	sql	{"table": "view02_student_hostel_detail", "operation": "select"}	{}	390	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅查询没有分配床位的学生	studentBedAllocation	waitingStudent	null	sql	{"table": "view01_waiting_student", "operation": "select"}		396	insert

职员宿舍管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
职员宿舍管理	employeeHostelManagement	showInMenu	null	8	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId
✅职员宿舍管理-查询列表	employeeHostelManagement	selectItemList	null	sql	{"table":"view02_employee_hostel","operation":"select"}	{}	355	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员宿舍管理-添加信息	employeeHostelManagement	insertItem	{ "before": [ { "service": "employeeHostel", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [] }	service	{"service":"employeeHostel","serviceFunction":"addHostel"}	{}	356	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员宿舍管理-更新信息	employeeHostelManagement	updateItem	null	service	{"service":"employeeHostel","serviceFunction":"updateHostel"}	{}	357	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员宿舍管理-删除信息	employeeHostelManagement	deleteItem	null	sql	{ "table": "employee_hostel", "operation": "jhDelete" }	{}	358	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员宿舍管理-查询房间信息	employeeHostelManagement	selectRoomList	null	sql	{"table":"view01_employee_hostel_room","operation":"select"}	{}	359	update	2022-07-19T13:45:11+08:00	vscode	vscode

职员床位分配

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
职员床位分配	employeeBedAllocation	showInMenu	null	8	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId
✅职员床位分配-查询楼栋信息	employeeBedAllocation	selectHotelList	null	sql	{"table":"view02_employee_hostel","operation":"select"}	{}	360	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员床位分配-查询房间信息	employeeBedAllocation	selectRoomList	null	service	{"service":"employeeHostel","serviceFunction":"selectRoomList"}	{}	361	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员床位分配-分配床位	employeeBedAllocation	allotRoomBed	null	service	{"service":"employeeHostel","serviceFunction":"allotRoomBed"}	{}	362	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员床位分配-查询职员信息	employeeBedAllocation	selectEmployeeList	null	service	{"service":"employeeHostel","serviceFunction":"selectEmployeeList"}	{}	363	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅职员床位分配-查询职员信息	employeeBedAllocation	searchEmployeeItem	null	sql	{"table": "view02_employee_hostel_detail", "operation": "select"}	{}	391	update	2022-07-19T13:45:11+08:00	vscode	vscode

学生宿舍导入

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生宿舍导入	importHostelData	showInMenu	null	9	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生宿舍导入-导入	importHostelData	importStudentData	null	service	{"service":"studentHostel","serviceFunction":"importStudentData"}		{}	366	insert
✅学生宿舍导入-查询学生信息	importHostelData	getStudentData	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	367	insert

员工宿舍导入

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
员工宿舍导入	importEmployeeHostelData	showInMenu	null	10	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅职员宿舍导入-查询楼栋列表	importEmployeeHostelData	selectHostelItemList	null	sql	{ "table": "employee_hostel", "operation": "select" }	{}	368	insert
✅职员宿舍导入-导入	importEmployeeHostelData	importEmployeeData	null	service	{"service":"employeeHostel","serviceFunction":"importEmployeeData"}	{}	369	insert
✅职员宿舍导入-获取员工列表	importEmployeeHostelData	getEmployeeList	null	sql	{ "table": "view01_employee", "operation": "select" }	{}	372	insert
✅职员宿舍导入-查询楼栋房间列表	importEmployeeHostelData	selectHostelRoomItemList	null	sql	{ "table": "employee_hostel_room", "operation": "select" }	{}	373	insert

权限管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
权限管理	userGroupRole	showInAvatarMenu	null	11	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	operation	operationAt	requestDemo	responseDemo
✅权限管理页-查询已配置权限列表	userGroupRole	selectItemList	null	sql	{"table": "_user_group_role", "operation": "select"}	374	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"}	375	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"}	376	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": ""}	377	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)})"}	378	update	2022-02-18T12:09:29+08:00	{}	{}
✅权限管理页-删除权限配置	userGroupRole	deleteItem	null	sql	{"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}	379	update	2022-02-18T21:03:41+08:00	{}	{}
✅权限管理页-查询角色	userGroupRole	selectRole	null	sql	{"table": "_role", "operation": "select"}	380	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"}	381	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"}	382	update	2022-02-18T19:55:57+08:00	{}	{}
✅权限管理页-添加角色	userGroupRole	insertRole	null	sql	{"table": "_role", "operation": "jhInsert"}	383	update	2022-02-18T20:00:37+08:00	{}	{}
✅权限管理页-删除用户	userGroupRole	deleteUser	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_user", "operation": "jhDelete"}	384	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"}	385	update	2022-02-18T19:56:11+08:00	{}	{}
✅权限管理页-删除角色	userGroupRole	deleteRole	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_role", "operation": "jhDelete"}	386	update	2022-02-18T20:04:23+08:00	{}	{}
✅权限管理页-更新用户	userGroupRole	updateUser	null	sql	{"table": "_user", "operation": "jhUpdate"}	387	update	2022-05-02T15:23:57+08:00	{"appData": {"appId": "demo_advanced", "where": {"id": 68}, "pageId": "userGroupRole", "actionId": "updateUser", "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": {"config": null, "userId": "001", "md5Salt": "ZsPkQcHpYZQT", "password": "b9e96d6ebc84dd51f2bd1fb56a79d8cb", "userType": "common", "username": "Ã¥Â°ÂÃ¥ÂÂ", "operation": "jhUpdate", "idSequence": "26260000", "userStatus": "active", "operationAt": "2022-05-02T15:21:34+08:00", "initPassword": null, "operationByUser": "adminName", "clearTextPassword": "1234567", "operationByUserId": "admin"}}, "packageId": "1651476236716_5991856", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "updateUser", "resultData": {"rows": 1}}, "packageId": "1651476236716_5991856", "timestamp": "2022-05-02T15:23:57+08:00", "packageType": "httpResponse"}
✅权限管理页-更新群组	userGroupRole	updateGroup	null	sql	{"table": "_group", "operation": "jhUpdate"}	388	update	2022-02-18T20:45:26+08:00	{}	{}
✅权限管理页-更新角色	userGroupRole	updateRole	null	sql	{"table": "_role", "operation": "jhUpdate"}	389	update	2022-02-18T19:56:37+08:00	{}	{}

学期归档

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学期归档	semesterArchive	showInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	semesterArchive	semesterArchive	null	service	{"service": "semester", "serviceFunction": "semesterArchive"}			392	insert

_page语句

INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', '帮助', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', '登陆', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'manual', NULL, '操作手册', 'dynamicInMenu', '0', 'update', 'vscode', 'vscode', '2022-07-19T14:11:15+08:00');
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'studentHostelManagement', NULL, '学生宿舍管理', 'showInMenu', '7', 'update', 'vscode', 'vscode', '2022-07-16T22:24:19+08:00');
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'studentBedAllocation', NULL, '学生床位分配', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'employeeHostelManagement', NULL, '职员宿舍管理', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'employeeBedAllocation', NULL, '职员床位分配', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'importHostelData', NULL, '学生宿舍导入', 'showInMenu', '9', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'importEmployeeHostelData', NULL, '员工宿舍导入', 'showInMenu', '10', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'userGroupRole', NULL, '权限管理', 'showInAvatarMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'semesterArchive', NULL, '学期归档', 'showInMenu', '5', 'insert', NULL, NULL, NULL);

# 页面总览

## _page结构

```sql
CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL,
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `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 = 43 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'
```

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | help | dynamicInMenu | helpV4 | 11 | 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" } |  | {} | 231 | insert |  |  |  |  |  |

## 操作手册

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 操作手册 | manual | dynamicInMenu | null | 0 | undefined |

## 学生宿舍管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生宿舍管理 | studentHostelManagement | showInMenu | null | 7 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生宿舍管理-查询列表 | studentHostelManagement | selectItemList | null | sql | {"table":"view02_student_hostel","operation":"select"} |  | {} | 331 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生宿舍管理-添加信息 | studentHostelManagement | insertItem | {   "before": [     {       "service": "studentHostel",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [] } | service | {"service":"studentHostel","serviceFunction":"addHostel"} |  | {} | 332 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生宿舍管理-更新信息 | studentHostelManagement | updateItem | null | service | {"service":"studentHostel","serviceFunction":"updateHostel"} |  | {} | 333 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生宿舍管理-删除信息 | studentHostelManagement | deleteItem | null | sql | { "table": "student_hostel", "operation": "jhDelete" } |  | {} | 334 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生宿舍管理-查询房间信息 | studentHostelManagement | selectRoomList | null | sql | {"table":"view01_student_hostel_room","operation":"select"} |  | {} | 350 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |

## 学生床位分配

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生床位分配 | studentBedAllocation | showInMenu | null | 8 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生床位分配-查询楼栋信息 | studentBedAllocation | selectHotelList | null | sql | {"table":"view02_student_hostel","operation":"select"} |  | {} | 351 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生床位分配-查询房间信息 | studentBedAllocation | selectRoomList | null | service | {"service":"studentHostel","serviceFunction":"selectRoomList"} |  | {} | 352 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生床位分配-分配床位 | studentBedAllocation | allotRoomBed | null | service | {"service":"studentHostel","serviceFunction":"allotRoomBed"} |  | {} | 353 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生床位分配-查询学生信息 | studentBedAllocation | selectStudentList | null | service | {"service":"studentHostel","serviceFunction":"selectStudentList"} |  | {} | 354 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅学生床位分配-查询房间信息 | studentBedAllocation | searchStudentItem | null | sql | {"table": "view02_student_hostel_detail", "operation": "select"} |  | {} | 390 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅查询没有分配床位的学生 | studentBedAllocation | waitingStudent | null | sql | {"table": "view01_waiting_student", "operation": "select"} |  |  | 396 | insert |  |  |  |  |  |

## 职员宿舍管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 职员宿舍管理 | employeeHostelManagement | showInMenu | null | 8 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅职员宿舍管理-查询列表 | employeeHostelManagement | selectItemList | null | sql | {"table":"view02_employee_hostel","operation":"select"} |  | {} | 355 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员宿舍管理-添加信息 | employeeHostelManagement | insertItem | {   "before": [     {       "service": "employeeHostel",       "serviceFunction": "fillInsertItemParamsBeforeHook"     }   ],   "after": [] } | service | {"service":"employeeHostel","serviceFunction":"addHostel"} |  | {} | 356 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员宿舍管理-更新信息 | employeeHostelManagement | updateItem | null | service | {"service":"employeeHostel","serviceFunction":"updateHostel"} |  | {} | 357 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员宿舍管理-删除信息 | employeeHostelManagement | deleteItem | null | sql | { "table": "employee_hostel", "operation": "jhDelete" } |  | {} | 358 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员宿舍管理-查询房间信息 | employeeHostelManagement | selectRoomList | null | sql | {"table":"view01_employee_hostel_room","operation":"select"} |  | {} | 359 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |

## 职员床位分配

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 职员床位分配 | employeeBedAllocation | showInMenu | null | 8 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅职员床位分配-查询楼栋信息 | employeeBedAllocation | selectHotelList | null | sql | {"table":"view02_employee_hostel","operation":"select"} |  | {} | 360 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员床位分配-查询房间信息 | employeeBedAllocation | selectRoomList | null | service | {"service":"employeeHostel","serviceFunction":"selectRoomList"} |  | {} | 361 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员床位分配-分配床位 | employeeBedAllocation | allotRoomBed | null | service | {"service":"employeeHostel","serviceFunction":"allotRoomBed"} |  | {} | 362 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员床位分配-查询职员信息 | employeeBedAllocation | selectEmployeeList | null | service | {"service":"employeeHostel","serviceFunction":"selectEmployeeList"} |  | {} | 363 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |
| ✅职员床位分配-查询职员信息 | employeeBedAllocation | searchEmployeeItem | null | sql | {"table": "view02_employee_hostel_detail", "operation": "select"} |  | {} | 391 | update | 2022-07-19T13:45:11+08:00 | vscode | vscode |  |  |

## 学生宿舍导入

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生宿舍导入 | importHostelData | showInMenu | null | 9 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生宿舍导入-导入 | importHostelData | importStudentData | null | service | {"service":"studentHostel","serviceFunction":"importStudentData"} |  | {} | 366 | insert |  |  |  |  |  |
| ✅学生宿舍导入-查询学生信息 | importHostelData | getStudentData | null | sql | { "table": "view01_student_basic_class", "operation": "select" } |  | {} | 367 | insert |  |  |  |  |  |

## 员工宿舍导入

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 员工宿舍导入 | importEmployeeHostelData | showInMenu | null | 10 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅职员宿舍导入-查询楼栋列表 | importEmployeeHostelData | selectHostelItemList | null | sql | { "table": "employee_hostel", "operation": "select" } |  | {} | 368 | insert |  |  |  |  |  |
| ✅职员宿舍导入-导入 | importEmployeeHostelData | importEmployeeData | null | service | {"service":"employeeHostel","serviceFunction":"importEmployeeData"} |  | {} | 369 | insert |  |  |  |  |  |
| ✅职员宿舍导入-获取员工列表 | importEmployeeHostelData | getEmployeeList | null | sql | { "table": "view01_employee", "operation": "select" } |  | {} | 372 | insert |  |  |  |  |  |
| ✅职员宿舍导入-查询楼栋房间列表 | importEmployeeHostelData | selectHostelRoomItemList | null | sql | { "table": "employee_hostel_room", "operation": "select" } |  | {} | 373 | insert |  |  |  |  |  |

## 权限管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 权限管理 | userGroupRole | showInAvatarMenu | null | 11 | undefined |

- **接口信息**

| 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"} |  |  | 374 | 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"} |  |  | 375 | 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"} |  |  | 376 | 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": ""} |  |  | 377 | 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)})"} |  |  | 378 | update | 2022-02-18T12:09:29+08:00 |  |  | {} | {} |
| ✅权限管理页-删除权限配置 | userGroupRole | deleteItem | null | sql | {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} |  |  | 379 | update | 2022-02-18T21:03:41+08:00 |  |  | {} | {} |
| ✅权限管理页-查询角色 | userGroupRole | selectRole | null | sql | {"table": "_role", "operation": "select"} |  |  | 380 | 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"} |  |  | 381 | 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"} |  |  | 382 | update | 2022-02-18T19:55:57+08:00 |  |  | {} | {} |
| ✅权限管理页-添加角色 | userGroupRole | insertRole | null | sql | {"table": "_role", "operation": "jhInsert"} |  |  | 383 | update | 2022-02-18T20:00:37+08:00 |  |  | {} | {} |
| ✅权限管理页-删除用户 | userGroupRole | deleteUser | {   "before": [],   "after": [     {       "service": "userGroupRole",       "serviceFunction": "deleteUserGroupRole"     }   ] } | sql | {"table": "_user", "operation": "jhDelete"} |  |  | 384 | 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"} |  |  | 385 | update | 2022-02-18T19:56:11+08:00 |  |  | {} | {} |
| ✅权限管理页-删除角色 | userGroupRole | deleteRole | {   "before": [],   "after": [     {       "service": "userGroupRole",       "serviceFunction": "deleteUserGroupRole"     }   ] } | sql | {"table": "_role", "operation": "jhDelete"} |  |  | 386 | update | 2022-02-18T20:04:23+08:00 |  |  | {} | {} |
| ✅权限管理页-更新用户 | userGroupRole | updateUser | null | sql | {"table": "_user", "operation": "jhUpdate"} |  |  | 387 | update | 2022-05-02T15:23:57+08:00 |  |  | {"appData": {"appId": "demo_advanced", "where": {"id": 68}, "pageId": "userGroupRole", "actionId": "updateUser", "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": {"config": null, "userId": "001", "md5Salt": "ZsPkQcHpYZQT", "password": "b9e96d6ebc84dd51f2bd1fb56a79d8cb", "userType": "common", "username": "Ã¥Â°ÂÃ¥ÂÂ", "operation": "jhUpdate", "idSequence": "26260000", "userStatus": "active", "operationAt": "2022-05-02T15:21:34+08:00", "initPassword": null, "operationByUser": "adminName", "clearTextPassword": "1234567", "operationByUserId": "admin"}}, "packageId": "1651476236716_5991856", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "updateUser", "resultData": {"rows": 1}}, "packageId": "1651476236716_5991856", "timestamp": "2022-05-02T15:23:57+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-更新群组 | userGroupRole | updateGroup | null | sql | {"table": "_group", "operation": "jhUpdate"} |  |  | 388 | update | 2022-02-18T20:45:26+08:00 |  |  | {} | {} |
| ✅权限管理页-更新角色 | userGroupRole | updateRole | null | sql | {"table": "_role", "operation": "jhUpdate"} |  |  | 389 | update | 2022-02-18T19:56:37+08:00 |  |  | {} | {} |

## 学期归档

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学期归档 | semesterArchive | showInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | semesterArchive | semesterArchive | null | service | {"service": "semester", "serviceFunction": "semesterArchive"} |  |  | 392 | insert |  |  |  |  |  |

## _page语句

```sql
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', '帮助', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', '登陆', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'manual', NULL, '操作手册', 'dynamicInMenu', '0', 'update', 'vscode', 'vscode', '2022-07-19T14:11:15+08:00');
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'studentHostelManagement', NULL, '学生宿舍管理', 'showInMenu', '7', 'update', 'vscode', 'vscode', '2022-07-16T22:24:19+08:00');
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'studentBedAllocation', NULL, '学生床位分配', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'employeeHostelManagement', NULL, '职员宿舍管理', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'employeeBedAllocation', NULL, '职员床位分配', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'importHostelData', NULL, '学生宿舍导入', 'showInMenu', '9', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'importEmployeeHostelData', NULL, '员工宿舍导入', 'showInMenu', '10', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'userGroupRole', NULL, '权限管理', 'showInAvatarMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'semesterArchive', NULL, '学期归档', 'showInMenu', '5', 'insert', NULL, NULL, NULL);
```