页面

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 = 41 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
考试列表	examManagement	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	examManagement	selectItemList	null	sql	{ "table": "view01_exam", "operation": "select" }		{}	361	insert
✅添加	examManagement	insertItem	{ "before": [ { "service": "exam", "serviceFunction": "appendExamIdBeforeCreate" } ] }	sql	{ "table": "exam", "operation": "insert" }		{}	362	insert
✅更新	examManagement	updateItem	null	sql	{ "table": "exam", "operation": "jhUpdate" }		{}	363	insert
✅删除	examManagement	deleteItem	null	sql	{ "table": "exam", "operation": "jhDelete" }		{}	364	insert
✅考试-标记成绩已录入	examManagement	markExamResultAsUploaded	null	sql	{ "table": "exam", "operation": "jhUpdate" }		{}	374	insert
✅考试-标记成绩未录入	examManagement	markExamResultAsCancelled	null	sql	{ "table": "exam", "operation": "jhUpdate" }		{}	377	insert
✅考试-确认成绩无误	examManagement	markExamResultAsChecked	{ "after": [ { "service": "exam", "serviceFunction": "confirmResultChecked" } ] }	sql	{ "table": "exam", "operation": "jhUpdate" }		{}	378	insert
✅考试-取消确认成绩无误	examManagement	markExamResultAsUnchecked	{ "after": [ { "service": "exam", "serviceFunction": "uncheckResult" } ] }	sql	{ "table": "exam", "operation": "jhUpdate" }		{}	379	insert
✅考试-删除考试	examManagement	markExamStatusAsDeleted	null	sql	{ "table": "exam", "operation": "jhUpdate" }		{}	381	insert
✅考试-发送通知	examManagement	generateNoticeForExam	null	service	{ "service": "notice", "serviceFunction": "generateNoticeForExam" }		{}	383	insert
✅考试-更新通知模板	examManagement	updateNoticeTemplateForExam	null	sql	{ "table": "exam", "operation": "jhUpdate" }		{}	384	insert
✅考试-获取成绩通知消息模板	examManagement	getNoticeTemplateList	null	sql	{ "table": "notice_template", "operation": "select" }		{}	385	insert

考试成绩列表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
考试成绩列表	studentResultListByExam	dynamicInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	studentResultListByExam	selectItemList	null	sql	{ "table": "student_exam_result_overall", "operation": "select" }		{}	365	insert
✅添加	studentResultListByExam	insertItem	null	sql	{ "table": "student_exam_result_overall", "operation": "insert" }		{}	366	insert
✅更新	studentResultListByExam	updateItem	null	sql	{ "table": "student_exam_result_overall", "operation": "jhUpdate" }		{}	367	insert
✅删除	studentResultListByExam	deleteItem	null	sql	{ "table": "student_exam_result_overall", "operation": "jhDelete" }		{}	368	insert
✅查询列表	studentResultListByExam	getExamInfo	null	sql	{ "table": "view01_exam", "operation": "select" }		{}	369	insert
✅查询列表	studentResultListByExam	selectOverallResultList	null	sql	{ "table": "student_exam_result_overall", "operation": "select" }		{}	370	insert
✅查询列表	studentResultListByExam	selectSubjectResultList	null	sql	{ "table": "student_exam_result_subject", "operation": "select" }		{}	371	insert
✅成绩-删除总成绩	studentResultListByExam	deleteOverallResult	null	sql	{ "table": "student_exam_result_overall", "operation": "jhDelete" }		{}	375	insert
✅成绩-删除科目成绩	studentResultListByExam	deleteItemSubjectResult	null	sql	{ "table": "student_exam_result_subject", "operation": "jhDelete" }		{}	376	insert
✅成绩-上传成绩	studentResultListByExam	uploadResultList	null	service	{ "service": "exam", "serviceFunction": "batchInsertExamResult" }		{}	380	insert
✅考试-获取考试中的班级列表	studentResultListByExam	getClassListByExam	null	service	{ "service": "exam", "serviceFunction": "getClassListByExam" }		{}	382	insert
✅成绩-上传成绩前检查考号	studentResultListByExam	checkWrongStudentId	null	service	{ "service": "exam", "serviceFunction": "checkWrongStudentId" }		{}	395	insert

学生列表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生列表	studentManagement	showInMenu	null	6	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询学生列表	studentManagement	selectItemList	null	sql	{ "table": "view01_student", "operation": "select" }		{}	386	insert

按学生查考考试成绩

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
按学生查考考试成绩	studentResultListByStudent	dynamicInMenu	null	7	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	studentResultListByStudent	selectItemList	null	sql	{ "table": "student_exam_result_overall", "operation": "select" }		{}	387	insert
	studentResultListByStudent	getStudentInfo	null	sql	{ "table": "view01_student", "operation": "select" }		{}	388	insert
	studentResultListByStudent	selectOverallResultList	null	sql	{ "table": "view01_student_exam_result_overall", "operation": "select" }		{}	389	insert
	studentResultListByStudent	selectSubjectResultList	null	sql	{ "table": "view01_student_exam_result_subject", "operation": "select" }		{}	390	insert
	studentResultListByStudent	deleteOverallResult	null	sql	{ "table": "student_exam_result_overall", "operation": "jhDelete" }		{}	391	insert
	studentResultListByStudent	deleteItemSubjectResult	null	sql	{ "table": "student_exam_result_subject", "operation": "jhDelete" }		{}	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 (37, 'examManagement', NULL, '考试列表', 'showInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'studentResultListByExam', NULL, '考试成绩列表', 'dynamicInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'studentManagement', NULL, '学生列表', 'showInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'studentResultListByStudent', NULL, '按学生查考考试成绩', 'dynamicInMenu', '7', 'insert', NULL, NULL, NULL);