页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `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 = 31 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	update	2022-04-27T15:32:57+08:00

[入学]学生入学

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[入学]学生入学	enrollment	showInMenu	enrollment/enrollment	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询入学学生列表	enrollment	selectItemList	null	sql	{ "table": "student_basic", "operation": "select" }		{}	259	insert
✅添加入学学生	enrollment	insertItem	{ "before": [ { "service": "student", "serviceFunction": "beforHookForGenerateStudentId" } ] }	sql	{ "table": "student_basic", "operation": "insert" }		{}	260	insert
✅更新入学学生	enrollment	updateItem	{ "after": [ { "service": "student", "serviceFunction": "studentStatusHistory" } ] }	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	261	insert
✅删除入学学生	enrollment	deleteItem	null	sql	{ "table": "student_basic", "operation": "jhDelete" }		{}	262	insert
✅录入信息 - 获取当前最新的学生ID	enrollment	getNewMaxId	null	service	{ "service": "student", "serviceFunction": "getNewMaxId" }		{}	263	insert
✅添加再入学班级历史	enrollment	insertHistory	null	sql	{ "table": "student_class_history", "operation": "insert" }		{}	347	insert
✅查询入学学生列表	enrollment	selectDetailItem	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	348	insert

[入学]工单打印预览

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[入学]工单打印预览	workflowPrintPreview	dynamicInMenu	enrollment/workflowPrintPreview	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅工单打印预览 - 获取学生信息	workflowPrintPreview	getStudentWorkflowInfo	null	sql	{ "table": "student_basic", "operation": "select" }		{}	264	insert

[入学]分配宿舍床位

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[入学]分配宿舍床位	logisticsAssignment	dynamicInMenu	enrollment/logisticsAssignment	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询入学学生住宿列表	logisticsAssignment	selectItemList	null	sql	{ "table": "student_basic", "operation": "select" }		{}	265	insert
✅更新入学学生住宿信息	logisticsAssignment	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	266	insert

[入学]查看缴费状况

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[入学]查看缴费状况	updatePaymentStatus	dynamicInMenu	enrollment/updatePaymentStatus	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询入学学生缴费情况列表	updatePaymentStatus	selectItemList	null	sql	{ "table": "view01_student_bill", "operation": "select" }		{}	267	insert
✅更新入学学生缴费信息	updatePaymentStatus	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	268	insert

班级管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
班级管理	classManagement	showInMenu	null	4	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询班级列表	classManagement	selectItemList	null	sql	{ "table": "view01_class", "operation": "select" }		{}	269	insert
✅添加新班级	classManagement	insertItem	{ "before": [ { "service": "class", "serviceFunction": "checkClassBeforeInsert" } ] }	sql	{ "table": "class", "operation": "insert" }		{}	270	insert
✅删除班级	classManagement	deleteItem	null	sql	{ "table": "class", "operation": "jhDelete" }		{}	272	insert
✅修改班级标签	classManagement	updateItem	null	sql	{ "table": "class", "operation": "jhUpdate" }		{}	313	insert
✅	classManagement	getAllUserList	null	sql	{ "table": "_view01_user", "operation": "select" }			349	insert

班级的学生管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
班级的学生管理	studentManagementOfOneClass	dynamicInMenu	null	4	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅班级的学生管理-查询当前班级下的学生列表	studentManagementOfOneClass	selectItemList	null	service	{ "service": "student", "serviceFunction": "getAllotStudent" }		{}	273	insert
✅班级的学生管理-把学生加到班级	studentManagementOfOneClass	insertItem	null	sql	{ "table": "student_basic", "operation": "jhInsert" }		{}	274	insert
✅班级的学生管理-更新学生数据	studentManagementOfOneClass	allotItem	{ "after": [ { "service": "student", "serviceFunction": "studentStatusHistory" } ] }	service	{ "service": "student", "serviceFunction": "allotStudentInsertHistory" }		{}	275	insert
✅班级的学生管理-把学生从班级中移除	studentManagementOfOneClass	deleteItem	null	sql	{ "table": "student_basic", "operation": "jhDelete" }		{}	276	insert
✅班级的学生管理-查询未分配的学生查询	studentManagementOfOneClass	selectUnassignedList	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	277	insert
✅班级的学生管理-更新学生数据	studentManagementOfOneClass	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	350	insert

学生的班级管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生的班级管理	classManagementOfOneStudent	dynamicInMenu	null	4	undefined

[入学]批准入学

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[入学]批准入学	enrollmentApproved	showInMenu	enrollment/enrollmentApproved	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	enrollmentApproved	selectItemList	null	sql	{ "table": "student_basic", "operation": "select" }		{}	278	insert
✅添加	enrollmentApproved	insertItem	null	sql	{ "table": "student_basic", "operation": "insert" }		{}	279	insert
✅更新	enrollmentApproved	updateItem	{ "after": [ { "service": "student", "serviceFunction": "studentStatusHistory" } ] }	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	280	insert
✅删除	enrollmentApproved	deleteItem	null	sql	{ "table": "student_basic", "operation": "jhDelete" }		{}	281	insert
✅添加	enrollmentApproved	insertItemtoStudentClass	null	sql	{ "table": "student_class", "operation": "insert" }		{}	282	insert

[入学]入学通知书打印

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[入学]入学通知书打印	approvalAcknowledgementPrintPreview	dynamicInMenu	enrollment/approvalAcknowledgementPrintPreview	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅入学批准打印预览 - 获取学生信息	approvalAcknowledgementPrintPreview	getStudentEnrollmentInfo	null	sql	{ "table": "student_basic", "operation": "select" }		{}	283	insert

学生升级

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生升级	studentUpgrade	dynamicInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询学生班级列表	studentUpgrade	selectItemList	null	sql	{ "table": "class", "operation": "select" }		{}	284	insert
✅升级	studentUpgrade	upgradeItem	null	service	{ "service": "class", "serviceFunction": "upgradeItem" }		{}	285	insert
✅毕业	studentUpgrade	graduationItem	null	service	{ "service": "class", "serviceFunction": "graduationItem" }		{}	286	insert

[退学]批准退学

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[退学]批准退学	quitApproved	showInMenu	quit/quitApproved	2	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	quitApproved	selectItemList	null	sql	{ "table": "view01_student_basic_request", "operation": "select" }		{}	287	insert
✅更新	quitApproved	updateItem	{ "before": [ { "service": "student", "serviceFunction": "beforHookForUpdateStudentAssignClassId" } ] }	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	288	insert
✅查询列表	quitApproved	selectOtherStatusItemList	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	293	insert
✅更新	quitApproved	updateApproveStatus	{ "after": [ { "service": "student", "serviceFunction": "studentStatusHistory" } ] }	sql	{ "table": "student_request", "operation": "jhUpdate" }		{}	299	insert
✅删除	quitApproved	deleteItemFromRequest	null	sql	{ "table": "student_request", "operation": "jhDelete" }		{}	308	insert

学生基础信息

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生基础信息	studentManagement	showInMenu	null	4	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅更新学生信息	studentManagement	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	294	insert
✅查询学生列表	studentManagement	selectItemList	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	295	insert
✅查询附件	studentManagement	fileUpload-selectItemList	null	sql	{"table":"student_attachment","operation":"select"}			355	insert
✅新增附件	studentManagement	fileUpload-insertItem	null	sql	{"table":"student_attachment","operation":"jhInsert"}			356	insert
✅编辑附件	studentManagement	fileUpload-updateItem	null	sql	{"table":"student_attachment","operation":"jhUpdate"}			357	insert
✅删除附件	studentManagement	fileUpload-deleteItem	null	sql	{"table":"student_attachment","operation":"jhDelete"}			358	insert

[退学]申请退学

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[退学]申请退学	quitRequest	showInMenu	quit/quitRequest	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	quitRequest	selectItemList	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	296	insert
✅更新	quitRequest	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	297	insert
✅复制提交申请的学生去申请表	quitRequest	createItem	{ "after": [ { "service": "student", "serviceFunction": "studentStatusHistory" } ] }	service	{ "service": "student", "serviceFunction": "batchSubmitRequest" }		{}	298	insert

[修改年级]申请修改年级

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[修改年级]申请修改年级	changeLevelRequest	showInMenu	changeLevel/changeLevelRequest	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅复制提交申请的学生去申请表	changeLevelRequest	createItem	null	sql	{ "table": "student_request", "operation": "insert" }		{}	302	insert
✅查询列表	changeLevelRequest	selectItemList	null	sql	{ "table": "student_basic", "operation": "select" }		{}	304	insert
✅更新基础班申请类型	changeLevelRequest	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	305	insert

[修改年级]批准修改年级

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[修改年级]批准修改年级	approvalChangeLevel	showInMenu	changeLevel/approvalChangeLevel	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅更新申请表	approvalChangeLevel	updateLevelItem	null	sql	{ "table": "student_request", "operation": "jhUpdate" }		{}	301	insert
✅更新班级表	approvalChangeLevel	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	306	insert
✅查询列表	approvalChangeLevel	selectItemList	null	sql	{ "table": "student_request", "operation": "select" }		{}	307	insert
✅更新-驳回	approvalChangeLevel	updateRequestItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	309	insert
✅删除	approvalChangeLevel	deleteItemFromRequest	null	sql	{ "table": "student_request", "operation": "jhDelete" }		{}	310	insert

[退学]退宿舍

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[退学]退宿舍	quitAssignment	dynamicInMenu	quit/quitAssignment	2	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	quitAssignment	selectItemList	null	sql	{ "table": "view01_student_basic_request", "operation": "select" }		{}	311	insert

[退学]退费

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[退学]退费	quitPayment	dynamicInMenu	quit/quitPayment	2	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	quitPayment	selectItemList	null	sql	{ "table": "view01_student_basic_request", "operation": "select" }		{}	312	insert

[升级毕业]5.小学升级

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[升级毕业]5.小学升级	primarySchoolUpgrade	showInMenu	null	9	undefined

[升级毕业]4.初中升级

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[升级毕业]4.初中升级	middleSchoolUpgrade	showInMenu	null	8	undefined

[升级毕业]3.高中升级

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[升级毕业]3.高中升级	highSchoolUpgrade	showInMenu	null	7	undefined

[升级毕业]2.高中毕业

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[升级毕业]2.高中毕业	highSchoolGraduation	showInMenu	null	6	undefined

权限管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
权限管理	userGroupRole	showInAvatarMenu		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"}			326	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"}			327	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"}			328	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": ""}			329	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)})"}			330	update	2022-02-18T12:09:29+08:00			{}	{}
✅权限管理页-删除权限配置	userGroupRole	deleteItem	null	sql	{"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}			331	update	2022-02-18T21:03:41+08:00			{}	{}
✅权限管理页-查询角色	userGroupRole	selectRole	null	sql	{"table": "_role", "operation": "select"}			332	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"}			333	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"}			334	update	2022-02-18T19:55:57+08:00			{}	{}
✅权限管理页-添加角色	userGroupRole	insertRole	null	sql	{"table": "_role", "operation": "jhInsert"}			335	update	2022-02-18T20:00:37+08:00			{}	{}
✅权限管理页-删除用户	userGroupRole	deleteUser	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_user", "operation": "jhDelete"}			336	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"}			337	update	2022-02-18T19:56:11+08:00			{}	{}
✅权限管理页-删除角色	userGroupRole	deleteRole	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_role", "operation": "jhDelete"}			338	update	2022-02-18T20:04:23+08:00			{}	{}
✅权限管理页-更新群组	userGroupRole	updateGroup	null	sql	{"table": "_group", "operation": "jhUpdate"}			339	update	2022-02-18T20:45:26+08:00			{}	{}
✅权限管理页-更新角色	userGroupRole	updateRole	null	sql	{"table": "_role", "operation": "jhUpdate"}			340	update	2022-02-18T19:56:37+08:00			{}	{}

学生身份信息

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生身份信息	studentIcNumberManagement	showInMenu	null	4	undefined

学生导入

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生导入	studentImport	showInAvatarMenu	null	null	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅缴费信息导入-数据校验	studentImport	checkImportData	null	service	{"service": "student", "serviceFunction": "checkImportData"}		{}	341	insert
✅缴费信息导入-导入	studentImport	importPaymentData	null	service	{"service":"student","serviceFunction":"importPaymentData"}		{}	342	insert

[升级毕业]1.学生毕业

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[升级毕业]1.学生毕业	studentGraduation	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	studentGraduation	selectItemList	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	343	insert
✅更新	studentGraduation	updateItem	null	sql	{ "table": "student_basic", "operation": "jhUpdate" }		{}	345	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 (4, 'enrollment', 'enrollment/enrollment', '[入学]学生入学', 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'workflowPrintPreview', 'enrollment/workflowPrintPreview', '[入学]工单打印预览', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'logisticsAssignment', 'enrollment/logisticsAssignment', '[入学]分配宿舍床位', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'updatePaymentStatus', 'enrollment/updatePaymentStatus', '[入学]查看缴费状况', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'classManagement', NULL, '班级管理', 'showInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'studentManagementOfOneClass', NULL, '班级的学生管理', 'dynamicInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'classManagementOfOneStudent', NULL, '学生的班级管理', 'dynamicInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'enrollmentApproved', 'enrollment/enrollmentApproved', '[入学]批准入学', 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'approvalAcknowledgementPrintPreview', 'enrollment/approvalAcknowledgementPrintPreview', '[入学]入学通知书打印', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'studentUpgrade', NULL, '学生升级', 'dynamicInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'quitApproved', 'quit/quitApproved', '[退学]批准退学', 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'studentManagement', NULL, '学生基础信息', 'showInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'quitRequest', 'quit/quitRequest', '[退学]申请退学', 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'changeLevelRequest', 'changeLevel/changeLevelRequest', '[修改年级]申请修改年级', 'showInMenu', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'approvalChangeLevel', 'changeLevel/approvalChangeLevel', '[修改年级]批准修改年级', 'showInMenu', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'quitAssignment', 'quit/quitAssignment', '[退学]退宿舍', 'dynamicInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'quitPayment', 'quit/quitPayment', '[退学]退费', 'dynamicInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'primarySchoolUpgrade', NULL, '[升级毕业]5.小学升级', 'showInMenu', '9', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'middleSchoolUpgrade', NULL, '[升级毕业]4.初中升级', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'highSchoolUpgrade', NULL, '[升级毕业]3.高中升级', 'showInMenu', '7', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'highSchoolGraduation', NULL, '[升级毕业]2.高中毕业', 'showInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'userGroupRole', '', '权限管理', 'showInAvatarMenu', '11', 'insert', 'insert', NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'studentIcNumberManagement', NULL, '学生身份信息', 'showInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'studentImport', NULL, '学生导入', 'showInAvatarMenu', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'studentGraduation', NULL, '[升级毕业]1.学生毕业', 'showInMenu', '5', 'insert', NULL, NULL, NULL);