页面

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 = 35 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	4	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
日历管理	calendarManagement	showInMenu	null	2	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	calendarManagement	selectItemList	null	sql	{ "table": "calendar", "operation": "select" }		{}	439	insert
✅添加	calendarManagement	insertItem	{ "before": [ { "service": "calendar", "serviceFunction": "fillInsertItemParamsBeforeHook" } ] }	sql	{ "table": "calendar", "operation": "insert" }		{}	440	insert
✅更新	calendarManagement	updateItem	null	sql	{ "table": "calendar", "operation": "jhUpdate" }		{}	441	insert
✅删除	calendarManagement	deleteItem	null	sql	{ "table": "calendar", "operation": "jhDelete" }		{}	442	insert

日历预览

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
日历预览	calendarEventView	dynamicInMenu	null	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	calendarEventView	selectItemList	null	sql	{ "table": "calendar", "operation": "select" }		{}	443	insert

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', '4', '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 (32, 'calendarManagement', '日历管理', NULL, 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 'calendarEventView', '日历预览', NULL, 'dynamicInMenu', '3', 'insert', NULL, NULL, NULL);