页面

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 = 46 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"}		{}	1	update	2022-04-27T15:32:57+08:00

学生管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生管理	studentManagement	dynamicInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	studentManagement	selectItemList	null	sql	{ "table": "student", "operation": "select" }		{}	357	insert
✅添加	studentManagement	insertItem	null	sql	{ "table": "student", "operation": "insert" }		{}	358	insert
✅更新	studentManagement	updateItem	null	sql	{ "table": "student", "operation": "jhUpdate" }		{}	359	insert
✅删除	studentManagement	deleteItem	null	sql	{ "table": "student", "operation": "jhDelete" }		{}	360	insert

区域设置

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
区域设置	areaManagement	showInMenu	null	null	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	areaManagement	saveAreaData	null	sql	{"table":"_constant","operation":"jhUpdate"}			361	insert
	areaManagement	getClassList	null	sql	{"table":"view01_class","operation":"select"}			362	insert
	areaManagement	getUserList	null	sql	{"table":"_view01_user","operation":"select"}			395	insert
	areaManagement	getUserList	null	sql	{"table":"view02_user_app","operation":"select"}			396	insert

区域打分

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
区域打分	areaList	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	areaList	getDeductionData	null	sql	{"table":"check_clean_record","operation":"select"}			372	insert
	areaList	getConstantList	null	sql	{"table":"_constant","operation":"select"}			373	insert
	areaList	getConstantList	null	sql	{"table":"_constant","operation":"select"}			374	insert
	areaList	rejectedDeduction	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			375	insert
	areaList	rejectedDeduction	null	sql	{"table":"clean_deduction_record","operation":"jhInsert"}			376	insert
	areaList	approvedItem	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			377	insert
	areaList	rejectedDeduction-insert	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			397	insert
	areaList	rejectedDeduction-update	null	sql	{"table":"check_clean_record","operation":"jhUpdate"}			398	insert
	areaList	approvedItem-insert	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			399	insert
	areaList	approvedItem-update	null	sql	{"table":"check_clean_record","operation":"jhUpdate"}			400	insert

月度班级统计

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
月度班级统计	classMonth	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	classMonth	getDeductionData	null	sql	{"table":"check_clean_record","operation":"select"}			385	insert
	classMonth	getClassList	null	sql	{"table":"view01_class","operation":"select"}			386	insert

月度区域统计

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
月度区域统计	areaMonth	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	areaMonth	getDeductionData	null	sql	{"table":"check_clean_record","operation":"select"}			381	insert
	areaMonth	rejectedDeduction	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			382	insert
	areaMonth	approvedItem	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			383	insert
	areaMonth	getClassList	null	sql	{"table":"view01_class","operation":"select"}			384	insert

班主任查看

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
班主任查看	areaView	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
	areaView	getDeductionData	null	sql	{"table":"check_clean_record","operation":"select"}			401	insert
	areaView	rejectedDeduction-insert	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			402	insert
	areaView	rejectedDeduction-update	null	sql	{"table":"check_clean_record","operation":"jhUpdate"}			403	insert
	areaView	approvedItem-insert	null	sql	{"table":"check_clean_record","operation":"jhInsert"}			404	insert
	areaView	approvedItem-update	null	sql	{"table":"check_clean_record","operation":"jhUpdate"}			405	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 (36, 'studentManagement', NULL, '学生管理', 'dynamicInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'areaManagement', NULL, '区域设置', 'showInMenu', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'areaList', NULL, '区域打分', 'showInMenu', '5', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (43, 'classMonth', NULL, '月度班级统计', 'showInMenu', '5', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (44, 'areaMonth', NULL, '月度区域统计', 'showInMenu', '5', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'areaView', NULL, '班主任查看', 'showInMenu', '5', 'jhInsert', NULL, NULL, NULL);