页面

12135

页面总览

_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',
  `pageHook` varchar(255) DEFAULT NULL,
  `pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text,
  `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 = 60 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '页面表; 软删除未启用;'

帮助

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	null	helpV4	null	null

登陆

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login	null	loginV4	null	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }			70	update	2023-02-24T13:54:35+08:00			{"appData":{"pageId":"login","actionId":"passwordLogin","actionData":{"userId":"admin","password":"123456","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome"},"appId":"directory","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36"},"packageId":"1677218075598_2695287","packageType":"httpRequest"}	{"packageId":"1677218075598_2695287","packageType":"httpResponse","status":"success","timestamp":"2023-02-24T13:54:35+08:00","appData":{"authToken":"AUxhx6Z48Vgas6teOIqijUo-I5qpBikMIHu_","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome","userId":"admin","resultData":{"authToken":"AUxhx6Z48Vgas6teOIqijUo-I5qpBikMIHu_","deviceId":"127.0.0.1:7007_Mac.10.15.7_fbae8120_chrome","userId":"admin"},"appId":"directory","pageId":"login","actionId":"passwordLogin"}}

操作手册

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
操作手册	manual	null	null	null	null

任务

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
任务	taskManagement	showInMenu	null	1	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" }, { "service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj" } ] }

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	taskManagement	selectItemList	null	sql	{ "table": "task", "operation": "select" }		{}	110	insert
✅添加	taskManagement	insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	sql	{ "table": "task", "operation": "insert" }		{}	111	insert
✅更新	taskManagement	updateItem	null	sql	{ "table": "task", "operation": "jhUpdate" }		{}	112	insert
✅删除	taskManagement	deleteItem	null	sql	{ "table": "task", "operation": "jhDelete" }		{}	113	insert

[审批]我收到的

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[审批]我收到的	ticketManagement	showInMenu	null	12	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	ticketManagement	selectItemList	null	sql	{ "table": "_view01_task", "operation": "select" }		{}	170	insert
✅添加	ticketManagement	insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	sql	{ "table": "task", "operation": "insert" }		{}	171	insert
✅更新	ticketManagement	updateItem	null	sql	{ "table": "task", "operation": "jhUpdate" }		{}	172	insert
✅删除	ticketManagement	deleteItem	null	sql	{ "table": "task", "operation": "jhDelete" }		{}	173	insert
✅获取任务模板列表	ticketManagement	selectTaskTemplateList	null	sql	{ "table": "task_template", "operation": "select" }		{}	174	insert
✅处理审批	ticketManagement	handleTicketApply	null	service	{ "service": "ticket", "serviceFunction": "handleTicketApply" }		{}	175	insert

[日志]我收到的

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[日志]我收到的	journalManagement	showInMenu	null	33	null

通知

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
通知	noticeManagement	showInMenu	null	40	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	noticeManagement	selectItemList	{ "before": [], "after": [ { "service": "notice", "serviceFunction": "replaceNoticeUrlAfterHook" } ] }	sql	{ "table": "task", "operation": "select" }		{}	90	insert
✅添加	noticeManagement	insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	sql	{ "table": "task", "operation": "insert" }		{}	91	insert
✅更新	noticeManagement	updateItem	null	sql	{ "table": "task", "operation": "jhUpdate" }		{}	92	insert
✅删除	noticeManagement	deleteItem	null	sql	{ "table": "task", "operation": "jhDelete" }		{}	93	insert
✅更新未读消息列表	noticeManagement	updateAllNotReadNotice	null	service	{ "service": "notice", "serviceFunction": "updateAllNotReadNotice" }		{}	95	insert
✅删除已读消息列表	noticeManagement	deleteAllReadNotice	null	service	{ "service": "notice", "serviceFunction": "deleteAllReadNotice" }		{}	96	insert

[审批]审批模板

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[审批]审批模板	taskTemplateManagement	showInMenu	null	50	{ "beforeHook": [ { "service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj" } ] }

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	taskTemplateManagement	selectItemList	null	sql	{ "table": "task_template", "operation": "select" }		{}	150	insert
✅添加	taskTemplateManagement	insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	sql	{ "table": "task_template", "operation": "insert" }		{}	151	insert
✅更新	taskTemplateManagement	updateItem	null	sql	{ "table": "task_template", "operation": "jhUpdate" }		{}	152	insert
✅删除	taskTemplateManagement	deleteItem	null	sql	{ "table": "task_template", "operation": "jhDelete" }		{}	153	insert
✅测试企微通知	taskTemplateManagement	testQiWeiNotice	null	service	{ "service": "notice", "serviceFunction": "testQiWeiNotice" }		{}	154	insert

工作台

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
工作台	workbench	showInMenu	null	0	null

日历

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
日历	calendarManagement	showInMenu	null	0	null

[审批]审批首页

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[审批]审批首页	ticketIndex		null	10	null

[审批]审批报表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[审批]审批报表	ticketReport		null	13	null

[审批]发起申请

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[审批]发起申请	ticketStartApply	showInMenu	null	10	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅task模板列表	ticketStartApply	getTaskTemplateList	null	sql	{ "table": "task_template", "operation": "select" }		{}	190	insert

[审批]我提交的

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[审批]我提交的	ticketSubmitManagement	showInMenu	null	13	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	ticketSubmitManagement	selectItemList	null	sql	{ "table": "_view01_task", "operation": "select" }		{}	210	insert
✅查询列表	ticketSubmitManagement	updateItem	null	sql	{ "table": "task", "operation": "jhUpdate" }		{}	211	insert

公告

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
公告	afficheManagement	showInMenu	null	30	{ "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }

• 接口信息

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

公告预览

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
公告预览	afficheViewer		null	30	null

• 接口信息

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

[日志]日志模板

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[日志]日志模板	journalTemplateManagement	showInMenu	null	34	{ "beforeHook": [ { "service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj" } ] }

[日志]新建日志

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[日志]新建日志	journalStartAdd	showInMenu	null	30

[日志]我发出的

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[日志]我发出的	journalSubmitManagement	showInMenu	null	32	null

通知/待办

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
通知/待办	https://demo.jianghujs.org/task/page/noticeManagement	showInRightMenu	null	null	null

_page语句

INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', NULL, 'helpV4', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', NULL, 'loginV4', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'manual', '操作手册', NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'taskManagement', '任务', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
        {"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}
    ]
}', NULL, 'showInMenu', NULL, '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'ticketManagement', '[审批]我收到的', NULL, NULL, 'showInMenu', NULL, '12', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'journalManagement', '[日志]我收到的', NULL, NULL, 'showInMenu', NULL, '33', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'noticeManagement', '通知', NULL, NULL, 'showInMenu', NULL, '40', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'taskTemplateManagement', '[审批]审批模板', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', NULL, 'showInMenu', NULL, '50', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'workbench', '工作台', NULL, NULL, 'showInMenu', NULL, '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'calendarManagement', '日历', NULL, NULL, 'showInMenu', NULL, '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'ticketIndex', '[审批]审批首页', NULL, NULL, '', NULL, '10', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'ticketReport', '[审批]审批报表', NULL, NULL, '', NULL, '13', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'ticketStartApply', '[审批]发起申请', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
    ]
}', NULL, 'showInMenu', NULL, '10', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'ticketSubmitManagement', '[审批]我提交的', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
    ]
}', NULL, 'showInMenu', NULL, '13', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'afficheManagement', '公告', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
    ]
}', NULL, 'showInMenu', NULL, '30', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'afficheViewer', '公告预览', NULL, NULL, '', NULL, '30', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'journalTemplateManagement', '[日志]日志模板', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', NULL, 'showInMenu', NULL, '34', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'journalStartAdd', '[日志]新建日志', '', NULL, 'showInMenu', NULL, '30', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'journalSubmitManagement', '[日志]我发出的', NULL, NULL, 'showInMenu', NULL, '32', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'https://demo.jianghujs.org/task/page/noticeManagement', '通知/待办', NULL, NULL, 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, 'insert', NULL, NULL, NULL);