页面

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 = 41 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	update	2022-04-27T15:32:57+08:00

我的报销

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
我的报销	reimbursementManagement	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅报销申请-查询列表	reimbursementManagement	selectItemList	{ "before": [ { "service": "reimbursement", "serviceFunction": "assignWhereUserIdBeforeHook" } ] }	sql	{ "table": "view01_reimbursement", "operation": "select" }		{}	361	insert
✅报销申请-添加	reimbursementManagement	insertItem	{ "before": [ { "service": "reimbursement", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "reimbursement", "serviceFunction": "recordConfirmHistory" } ] }	sql	{ "table": "reimbursement","operation": "jhInsert" }		{}	362	insert
✅报销申请-更新	reimbursementManagement	updateItem	{ "before": [ { "service": "reimbursement", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "reimbursement", "serviceFunction": "recordConfirmHistory" } ] }	sql	{ "table": "reimbursement", "operation": "jhUpdate" }		{}	363	insert
✅报销申请-删除	reimbursementManagement	deleteItem	null	sql	{ "table": "reimbursement", "operation": "jhDelete" }		{}	364	insert
✅报销申请-查询员工列表	reimbursementManagement	selectEmployeeList	null	sql	{ "table": "view01_member_org_role", "operation": "select" }		{}	365	insert
✅报销申请-撤销	reimbursementManagement	revokeItem	{ "before": [ { "service": "reimbursement", "serviceFunction": "fillRevokeItemParamsBeforeHook" } ], "after": [ { "service": "reimbursement", "serviceFunction": "recordConfirmHistory" } ] }	sql	{ "table": "reimbursement", "operation": "jhUpdate" }		{}	385	insert

我的审批

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
我的审批	auditManagement	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅报销审批-驳回	auditManagement	rejectItem	{ "after": [ { "service": "reimbursement", "serviceFunction": "recordConfirmHistory" } ] }	service	{"service": "audit", "serviceFunction": "rejectItem"}		{}	367	insert
✅报销审批-审核通过	auditManagement	approveItem	{ "after": [ { "service": "reimbursement", "serviceFunction": "recordConfirmHistory" } ] }	service	{"service": "audit", "serviceFunction": "approveItem"}		{}	374	insert
✅报销审批-查询列表	auditManagement	selectItemList	{ "before": [ { "service": "audit", "serviceFunction": "fillWhereOptionsBeforeHook" } ] }	sql	{ "table": "view01_reimbursement", "operation": "select" }		{}	384	insert
✅报销审批-查询员工列表	auditManagement	selectEmployeeList	null	sql	{ "table": "view01_member_org_role", "operation": "select" }		{}	386	insert

转账回执

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
转账回执	transferManagement	showInMenu	null	7	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅报销转账-查询列表	transferManagement	selectItemList	{ "before": [ { "service": "transfer", "serviceFunction": "fillWhereOptionsBeforeHook" } ] }	sql	{ "table": "view01_reimbursement", "operation": "select" }		{}	377	insert
✅报销转账-转账	transferManagement	transferItem	{ "after": [ { "service": "reimbursement", "serviceFunction": "recordConfirmHistory" } ] }	service	{"service": "transfer", "serviceFunction": "transferItem"}		{}	378	insert
✅报销转账-异常	transferManagement	exceptionItem	{ "after": [ { "service": "reimbursement", "serviceFunction": "recordConfirmHistory" } ] }	service	{"service": "transfer", "serviceFunction": "exceptionItem"}		{}	379	insert
✅报销转账-查询员工列表	transferManagement	selectEmployeeList	null	sql	{ "table": "view01_member_org_role", "operation": "select" }		{}	381	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 (37, 'reimbursementManagement', NULL, '我的报销', 'showInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'auditManagement', NULL, '我的审批', 'showInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'transferManagement', NULL, '转账回执', 'showInMenu', '7', 'insert', NULL, NULL, NULL);