Page

12132

Page Overview

_page Structure

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page file specification; defaults to pageId.html',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255)  DEFAULT NULL COMMENT 'page type; showInMenu, dynamicInMenu',
  `pageIcon` text ,
  `sort` varchar(255)  DEFAULT NULL,
  `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`)
) ENGINE = InnoDB AUTO_INCREMENT = 51 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Page table; soft delete not enabled;'

Help

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Help	help	dynamicInMenu	helpV4	11	undefined

Login

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Login	login		loginV4		undefined

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Login	login	passwordLogin	null	service	{"service": "user", "serviceFunction": "passwordLogin"}		{}	231	update	2022-04-27T15:32:57+08:00

Audit Template List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Audit Template List	auditProjectTemplate	showInMenu	null	1	undefined

Audit Project List

• Page Information

pageName	pageId	pageType	pageFile	sort	pageHook
Audit Project List	auditProjectManagement	showInMenu	null	2	undefined

• API Information

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅Query Audit Project List	auditProjectManagement	selectAuditProjectList	null	service	{"service": "auditProject", "serviceFunction": "selectAuditProjectList"}		{}	360	insert
✅Query List	auditProjectManagement	selectItemList	null	sql	{ "table": "view01_audit_project", "operation": "select" }		{}	361	insert
✅Create Audit Project	auditProjectManagement	createAuditProject	null	service	{"service": "auditProject", "serviceFunction": "createAuditProject"}		{}	362	insert
✅Update	auditProjectManagement	updateItem	{ "before": [], "after": [ { "service": "auditProject", "serviceFunction": "updateAuditProjectDirectoryAfterHook" } ] }	sql	{ "table": "audit_project", "operation": "jhUpdate" }		{}	363	insert
✅Delete	auditProjectManagement	deleteItem	null	sql	{ "table": "audit_project", "operation": "jhDelete" }		{}	364	insert
✅Audit List - Get User List	auditProjectManagement	selectUserList	null	sql	{"table": "view01_user_select", "operation": "select"}		{}	382	insert
✅Audit List - Move to Recycle Bin	auditProjectManagement	deletedProject	null	service	{"service": "auditProject", "serviceFunction": "deletedProject"}		{}	383	insert
✅Audit List - Restore Data	auditProjectManagement	restoreProject	null	service	{"service": "auditProject", "serviceFunction": "restoreProject"}		{}	384	insert
✅Audit List - Create Account	auditProjectManagement	createAppAccountOfManual	null	service	{"service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual"}		{}	394	insert
✅Update Organizer	auditProjectManagement	updateProjectOrganizer	{ "before": [], "after": [