页面

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 COMMENT 'page文件指定; 默认使用pageId.html',
  `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 = 37 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
学情考试	baseExamList	showInMenu	null	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询学情考试	baseExamList	selectItem	null	service	{ "service": "baseExam", "serviceFunction": "getBaseExamList" }		{}	371	insert
✅查询考试列表	baseExamList	selectExamList	null	service	{ "service": "baseExam", "serviceFunction": "getExamList" }		{}	372	insert
✅保存学情考试	baseExamList	saveBaseExam		service	{ "service": "baseExam", "serviceFunction": "saveBaseExamList" }		{}	373	insert
✅查询班级学情考试M值	baseExamList	getClassSubjectMValue	null	service	{ "service": "baseExam", "serviceFunction": "getClassSubjectMValue" }		{}	374	insert

考试列表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
考试列表	examList	showInMenu	null	2	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	examList	selectItemList	null	service	{ "service": "examList", "serviceFunction": "getExamList" }		{}	443	insert
✅查询老师考试N值	examList	getClassSubjectNValue	null	service	{ "service": "examList", "serviceFunction": "getClassSubjectNValue" }		{}	444	insert

月度老师绩效

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
月度老师绩效	performanceList	showInMenu	null	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询老师绩效奖励	performanceList	getTeacherMoneyList	null	service	{ "service": "performanceList", "serviceFunction": "getTeacherMoneyList" }		{}	500	insert
✅查询老师绩效奖励	performanceList	getTeacherDetail	null	service	{ "service": "performanceList", "serviceFunction": "getTeacherDetail" }		{}	501	insert

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 'baseExamList', '学情考试', NULL, 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 'examList', '考试列表', NULL, 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'performanceList', '月度老师绩效', NULL, 'showInMenu', '3', 'insert', NULL, NULL, NULL);