页面

12114

页面总览

_page结构

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

欢迎

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
欢迎	welcome	null	null	null	null

帮助

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	11	null

登陆

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		null

• 接口信息

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
教材列表	bookManagement	showInMenu	null	6	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅教材列表-查询列表	bookManagement	selectItemList	null	sql	{ "table": "view01_book", "operation": "select" }		{}	509	insert
✅教材列表-添加数据	bookManagement	insertItem	{ "before": [ { "service": "book", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "book", "serviceFunction": "addBookMaterialDir" } ] }	sql	{ "table": "book", "operation": "insert" }		{}	510	insert
✅教材列表-更新数据	bookManagement	updateItem	{ "before": [ { "service": "book", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [] }	sql	{ "table": "book", "operation": "jhUpdate" }		{}	511	insert
✅教材列表-删除数据	bookManagement	deleteItem	{ "before": [], "after": [ { "service": "book", "serviceFunction": "deleteBookMaterialDir" } ] }	sql	{ "table": "book", "operation": "jhUpdate" }		{}	512	insert
✅教材列表-恢复数据	bookManagement	resumeItem	{ "before": [], "after": [ { "service": "book", "serviceFunction": "restoreBookMaterialDir" } ] }	sql	{ "table": "book", "operation": "jhUpdate" }		{}	555	insert

章节备课

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
章节备课	bookLessonEditor	dynamicInMenu	null	7	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询	bookLessonEditor	selectSectionList	null	sql	{ "table": "view01_section", "operation": "select" }		{}	539	insert
✅查询	bookLessonEditor	selectLessonList		sql	{ "table": "section_lesson", "operation": "select" }		{}	540	insert
✅添加	bookLessonEditor	insertItem	{ "before": [ { "service": "lesson", "serviceFunction": "fillInsertItemParamsBeforeHook" } ] }	sql	{ "table": "section_lesson", "operation": "jhInsert" }		{}	541	insert
✅更新	bookLessonEditor	updateItem	null	sql	{ "table": "section_lesson", "operation": "jhUpdate" }		{}	542	insert
✅教材详情	bookLessonEditor	selectBookList	null	sql	{ "table": "book", "operation": "select" }			550	insert
✅备课-创建教材章节素材目录	bookLessonEditor	addSetionMaterialDir	null	service	{ "service": "section", "serviceFunction": "addSetionMaterialDir" }		{}	556	insert

备课进度总览

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
备课进度总览	bookSectionProgress	dynamicInMenu	null	11	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	bookSectionProgress	selectItemList	null	sql	{ "table": "book", "operation": "select" }		{}	513	insert
✅添加	bookSectionProgress	insertItem	null	sql	{ "table": "book", "operation": "insert" }		{}	514	insert
✅更新	bookSectionProgress	updateItem	null	sql	{ "table": "book", "operation": "jhUpdate" }		{}	515	insert
✅删除	bookSectionProgress	deleteItem	null	sql	{ "table": "book", "operation": "jhDelete" }		{}	516	insert

章节列表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
章节列表	bookSectionManagement	dynamicInMenu	null	5	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	bookSectionManagement	selectItemList	null	sql	{ "table": "section", "operation": "select" }		{}	521	insert
✅添加	bookSectionManagement	insertItem	null	sql	{ "table": "section", "operation": "insert" }		{}	522	insert
✅更新	bookSectionManagement	updateItem	null	service	{ "service": "section", "serviceFunction": "batchUpdate" }		{}	523	insert
✅删除	bookSectionManagement	deleteItem	null	sql	{ "table": "section", "operation": "jhDelete" }		{}	524	insert
✅教材列表	bookSectionManagement	selectBookList	null	sql	{ "table": "view01_book", "operation": "select" }			525	insert

文章编辑

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
文章编辑	sectionEdit	dynamicInMenu	null	6	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅文章编辑-使用素材	sectionEdit	useMaterial	null	service	{ "service": "material", "serviceFunction": "useMaterial" }		{}	527	insert
✅文章编辑-查询列表	sectionEdit	selectBookList	null	sql	{ "table": "view01_book", "operation": "select" }		{}	528	insert
✅文章编辑-添加成员	sectionEdit	insertItem	{ "before": [ { "service": "section", "serviceFunction": "fillInsertItemParamsBeforeHook" } ] }	sql	{ "table": "section", "operation": "jhInsert" }		{}	529	jhInsert
✅文章编辑-查询文章列表	sectionEdit	selectItemList	null	sql	{ "table": "section", "operation": "select" }		{}	530	jhInsert
✅文章编辑-更新成员	sectionEdit	updateItem	{ "before": [ { "service": "section", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ] }	sql	{ "table": "section", "operation": "jhUpdate" }		{}	531	insert
✅文章编辑-将文章移至回收站	sectionEdit	deleteItem	null	service	{ "service": "section", "serviceFunction": "delete" }		{}	532	insert
✅文章编辑-文章恢复	sectionEdit	restoreItem	null	service	{ "service": "section", "serviceFunction": "restore" }		{}	533	insert
✅xf编辑-文件列表	sectionEdit	list	null	service	{ "service": "material", "serviceFunction": "list" }		{}	543	insert
✅xf编辑-创建文件夹	sectionEdit	mkdir	null	service	{ "service": "material", "serviceFunction": "mkdir" }		{}	544	insert
✅xf编辑-移动文件	sectionEdit	moveFile	null	service	{ "service": "material", "serviceFunction": "moveFile" }		{}	545	insert
✅xf编辑-复制文件	sectionEdit	copyFile	null	service	{ "service": "material", "serviceFunction": "copyFile" }		{}	546	insert
✅xf编辑-文件重命名	sectionEdit	renameFile	null	service	{ "service": "material", "serviceFunction": "renameFile" }		{}	547	insert
✅xf编辑-删除	sectionEdit	delete	null	service	{ "service": "material", "serviceFunction": "delete" }		{}	548	insert
✅xf编辑-清空回收站	sectionEdit	clearRecycle	null	service	{ "service": "material", "serviceFunction": "clearRecycle" }		{}	549	insert

备课

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
备课	sectionList	showInMenu	null	5	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	sectionList	selectItemList	null	sql	{ "table": "view01_book_section_groupby", "operation": "select" }		{}	535	insert
✅添加	sectionList	insertItem	null	sql	{ "table": "section", "operation": "insert" }		{}	536	insert
✅更新	sectionList	updateItem	null	sql	{ "table": "section", "operation": "jhUpdate" }		{}	537	insert
✅删除	sectionList	deleteItem	null	sql	{ "table": "section", "operation": "jhDelete" }		{}	538	insert
✅查询列表	sectionList	selectBookGroupList	null	sql	{ "table": "view01_book_group", "operation": "select" }		{}	554	insert

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'welcome', '欢迎', NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', '', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (65, 'bookManagement', '教材列表', NULL, 'showInMenu', '6', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'bookLessonEditor', '章节备课', NULL, 'dynamicInMenu', '7', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'bookSectionProgress', '备课进度总览', NULL, 'dynamicInMenu', '11', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'bookSectionManagement', '章节列表', NULL, 'dynamicInMenu', '5', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'sectionEdit', '文章编辑', NULL, 'dynamicInMenu', '6', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'sectionList', '备课', NULL, 'showInMenu', '5', NULL, 'insert', NULL, NULL, NULL);