Page

12123

Page Overview

_page Structure

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jhId` varchar(255) DEFAULT NULL,
  `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255) DEFAULT NULL,
  `pageType` varchar(255) DEFAULT NULL COMMENT 'Page type; showInMenu, dynamicInMenu',
  `pageIcon` text,
  `sort` varchar(255) DEFAULT NULL,
  `pageHook` text COMMENT '{\n  "beforeHook":[\n  {"field": "doc", "service": "doc", "serviceFunc": "getDoc"}\n  ]\n}',
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 243 DEFAULT CHARSET = utf8mb4 COMMENT = 'Page table; soft delete not enabled;'

Login

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Login	login		loginV4	null	null

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Login	login	passwordLogin	null	service	{"service": "user", "serviceFunction": "passwordLogin"}		{}	1	course_mgmt	update	2022-04-27T15:32:57+08:00
✅Login	login	passwordLogin	null	service	{"service": "user", "serviceFunction": "passwordLogin"}		{}	94	sys_admin	update	2022-04-27T15:32:57+08:00
✅Login	login	passwordLogin	{ "before": [], "after": [ { "service": "userCenter", "serviceFunction": "afterLoginEditLoginAt" } ] }	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	134	student	insert
✅Login	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	234	teacher	insert

User Manual

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
User Manual	manual	null	null	998	null

Help

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Help	help	null	helpV4	999	null

Course List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Course List	courseList	showInMenu	null	101	null

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Course List - Query Courses	courseList	selectItemList	null	sql	{ "table": "view01_course_with_article_count", "operation": "select" }	access_control_course	{}	11	course_mgmt	insert
Course - Sync Courses from Course and Class Management	courseList	syncCourseList	null	service	{ "service": "course", "serviceFunction": "syncCourseList" }			12	course_mgmt	insert
✅Course List - Get My Courses	courseList	getMyCourseList	null	sql	{ "table": "view01_user_course", "operation": "select" }		{}	136	student	insert

Course Article List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Course Article List	articleListByCourse	null	null	103	null

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Course Article List - Get Articles by Course	articleListByCourse	getArticleListByCourse	null	sql	{ "table": "view01_course_article", "operation": "select" }	access_control_album_or_article		13	course_mgmt	insert
✅Course Article List - Bind Textbook	articleListByCourse	insertItem	null	sql	{ "table": "course_article", "operation": "jhInsert" }			14	course_mgmt	insert
✅Course Article List - Update Item	articleListByCourse	updateItem	null	sql	{ "table": "course_article", "operation": "jhUpdate" }			15	course_mgmt	insert
✅Course Article List - Unbind Textbook	articleListByCourse	deleteItem	null	sql	{ "table": "course_article", "operation": "jhDelete" }			16	course_mgmt	insert
✅Course Article List - Get Article Category List	articleListByCourse	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }			18	course_mgmt	insert
	articleListByCourse	getArticleList	null	sql	{ "table": "view01_article_list", "operation": "select" }	access_control_album_or_article		19	course_mgmt	insert
✅Course Article List - Add Article or Exam	articleListByCourse	insertArticleItem	{ "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhInsert" }		{}	21	course_mgmt	insert
______✅[Cancelable] Course Article List - Get Articles Not Bound to Courses	articleListByCourse	getCourseArticleBinding		service	{ "service": "course", "serviceFunction": "getCourseArticleBinding" }		{}	22	course_mgmt	insert
✅Course Article List - Update Article Title	articleListByCourse	updateArticleTitle	null	sql	{ "table": "article", "operation": "jhUpdate" }			24	course_mgmt	insert
	articleListByCourse	getCourseInfo	null	sql	{"table":"course","operation":"select"}			25	course_mgmt	insert
✅Course Article List - Bind Article to Course	articleListByCourse	bindNewArticleToCourse	null	service	{ "service": "article", "serviceFunction": "bindNewArticleToCourse" }		{}	26	course_mgmt	insert
✅Course Article List - Move Article to Trash	articleListByCourse	setArticleAsDeleted	null	service	{ "service": "article", "serviceFunction": "deletedArticle" }		{}	27	course_mgmt	insert
✅Course Article List - Unbind Article from Course	articleListByCourse	unbindArticleFromCourse	null	sql	{ "table": "course_article", "operation": "jhDelete" }		{}	28	course_mgmt	insert
	articleListByCourse	getArticleJustInserted	null	sql	{ "table": "article", "operation": "select" }		{}	29	course_mgmt	insert

Course Exam List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Course Exam List	examListByCourse	null	null	104	null

Textbook Management

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Textbook Management	albumList	null	null	201	null

Textbook Article List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Textbook Article List	articleListByAlbum	null	null	202	null

Article List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Article List	articleList	showInMenu	null	401	null

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Article List - Query List (Excluding Content)	articleList	selectItemList	null	sql	{ "table": "view01_article", "operation": "select" }	access_control_album_or_article	{}	45	course_mgmt	jhInsert
✅Article List - Query Category List	articleList	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }		{}	46	course_mgmt	insert
✅Article List - Update Members	articleList	jhUpdateItem	{ "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhUpdate" }		{}	49	course_mgmt	insert
✅Article Edit - Move Article to Trash	articleList	deletedArticle	null	service	{ "service": "article", "serviceFunction": "deletedArticle" }		{}	50	course_mgmt	insert
✅Article Edit - Restore Article	articleList	restoreArticle	null	service	{ "service": "article", "serviceFunction": "restoreArticle" }		{}	51	course_mgmt	insert
✅Article List - Unbind Article from Course	articleList	unbindArticleFromCourse	null	sql	{ "table": "course_article", "operation": "jhDelete" }		{}	52	course_mgmt	insert

Article Edit

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Article Edit	articleEdit	null	null	403	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Article Edit - Query Article List	articleEdit	selectItemList	null	sql	{ "table": "article", "operation": "select" }		{}	53	course_mgmt	jhInsert
✅Article Edit - Query List	articleEdit	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }		{}	54	course_mgmt	insert
✅Article Edit - Course List	articleEdit	selectCourseList	null	sql	{"table":"course","operation":"select", "fieldList": ["courseId", "courseBatchId", "courseName", "courseStatus", "operationAt"]}	access_control_course	{}	55	course_mgmt	update	2022-07-28T08:56:53+08:00	vscode	vscode
✅Article Edit - Query Articles with Collection Information	articleEdit	selectArticleWithCategory	null	service	{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }		{}	57	course_mgmt	insert
✅Article Edit - Add Members	articleEdit	jhInsertItem	{ "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhInsert" }		{}	58	course_mgmt	jhInsert
✅Article Edit - Update Members	articleEdit	jhUpdateItem	{ "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhUpdate" }		{}	59	course_mgmt	insert
✅Article Edit - Move Article to Trash	articleEdit	deletedArticle		service	{ "service": "article", "serviceFunction": "deletedArticle" }		{}	60	course_mgmt	insert
✅Article Edit - Restore Article	articleEdit	restoreArticle	null	service	{ "service": "article", "serviceFunction": "restoreArticle" }		{}	61	course_mgmt	insert
✅Article Edit - Use Material	articleEdit	useMaterial	null	service	{ "service": "material", "serviceFunction": "useMaterial" }		{}	62	course_mgmt	insert
✅xf Edit - File List	articleEdit	list	null	service	{ "service": "material", "serviceFunction": "list" }		{}	68	course_mgmt	insert
✅xf Edit - Create Folder	articleEdit	mkdir	null	service	{ "service": "material", "serviceFunction": "mkdir" }		{}	69	course_mgmt	insert
✅xf Edit - Move File	articleEdit	moveFile	null	service	{ "service": "material", "serviceFunction": "moveFile" }		{}	70	course_mgmt	insert
✅xf Edit - Copy File	articleEdit	copyFile	null	service	{ "service": "material", "serviceFunction": "copyFile" }		{}	71	course_mgmt	insert
✅xf Edit - Rename File	articleEdit	renameFile	null	service	{ "service": "material", "serviceFunction": "renameFile" }		{}	72	course_mgmt	insert
✅xf Edit - Delete	articleEdit	delete	null	service	{ "service": "material", "serviceFunction": "delete" }		{}	73	course_mgmt	insert
✅xf Edit - Clear Recycle Bin	articleEdit	clearRecycle	null	service	{ "service": "material", "serviceFunction": "clearRecycle" }		{}	74	course_mgmt	insert
✅Article Edit - Unbind Article from Course	articleEdit	unbindArticleFromCourse	null	sql	{ "table": "course_article", "operation": "jhDelete" }		{}	89	course_mgmt	insert

Assignment Design

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Assignment Design	assignmentDesign	null	null	405	null

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Query Article Assignment	assignmentDesign	selectArticleAssignment	null	sql	{ "table": "article", "operation": "select" }		{}	63	course_mgmt	insert
✅Update Article Assignment	assignmentDesign	updateArticleAssignment	{ "after": [ { "service": "article", "serviceFunction": "afterEditQuestionHook" } ] }	sql	{ "table": "article", "operation": "jhUpdate" }		{}	64	course_mgmt	insert
✅Assignment Design - Question Bank List	assignmentDesign	selectQuestionList	null	sql	{"table":"question","operation":"select"}		{}	65	course_mgmt	update	2022-07-28T08:56:53+08:00	vscode	vscode
✅Get Question Suggestions	assignmentDesign	getAnswerPoints	null	service	{"service": "assignment", "serviceFunction": "getAnswerPoints"}			93	course_mgmt	insert

Article Preview

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Article Preview	articlePreview	seo	articleViewer	406	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" }, { "field": "userInfo", "service": "user", "serviceFunc": "userInfo" } ] }

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	articlePreview	selectItemList	null	service	{ "service": "article", "serviceFunction": "getArticleListFromArticleQuery" }			66	course_mgmt	insert
	articlePreview	selectArticleInfo	null	service	{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }			67	course_mgmt	insert

Exam List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Exam List	examList	showInMenu	null	402	null

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Exam List - Query List (Excluding Content)	examList	selectItemList	null	sql	{ "table": "view01_article", "operation": "select" }		{}	75	course_mgmt	jhInsert
✅Exam List - Query Category List	examList	selectCategoryList	null	sql	{ "table": "view01_category", "operation": "select" }		{}	76	course_mgmt	insert
✅Exam List - Get Course List	examList	selectCourseList	null	sql	{"table":"course","operation":"select"}		{}	77	course_mgmt	update	2022-07-28T08:56:53+08:00	vscode	vscode
	examList	insertArticleItem	{ "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] }	sql	{ "table": "article", "operation": "jhInsert" }		{}	78	course_mgmt	insert
	examList	updateArticleTitle	null	sql	{ "table": "article", "operation": "jhUpdate" }		{}	79	course_mgmt	insert
✅Exam List - Unbind Article from Course	examList	unbindArticleFromCourse	null	sql	{ "table": "course_article", "operation": "jhDelete" }		{}	80	course_mgmt	insert

Media Library

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Media Library	mediaLibrary	showInMenu	null	501	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	jhId	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Media Management - File List	mediaLibrary	list	null	service	{ "service": "material", "serviceFunction": "list" }		{}	81	course_mgmt	insert
✅Media Management - Create Folder	mediaLibrary	mkdir	null	service	{ "service": "material", "serviceFunction": "mkdir" }		{}	82	course_mgmt	insert
✅Media Management - Delete	mediaLibrary	delete	null	service	{ "service": "material", "serviceFunction": "delete" }		{}	83	course_mgmt	insert
✅Media