页面
12120页面总览
_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',
`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 = 84 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'
帮助
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
帮助 | help | dynamicInMenu | undefined | 11 | undefined |
登陆
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
登陆 | login | undefined | 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 |
---|---|---|---|---|---|
网站管理 | websiteManagement | showInMenu | undefined | 2 | undefined |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅站点管理-查询列表 | websiteManagement | selectItemList | null | sql | {"table": "website", "operation": "select"} | {} | 383 | insert | ||||||
✅站点管理-添加成员 | websiteManagement | addWebsite | null | service | {"service": "websiteManagement", "serviceFunction": "addWebsite"} | {} | 384 | insert | ||||||
✅站点管理-更新成员 | websiteManagement | updateItem | null | sql | {"table": "website", "operation": "jhUpdate"} | {} | 385 | insert | ||||||
✅站点管理-删除信息 | websiteManagement | deleteItem | null | sql | {"table": "website", "operation": "jhDelete"} | {} | 386 | insert |
网站数据分析
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
网站数据分析 | websiteDashboard | dynamicInMenu | undefined | 2 | undefined |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅网站数据分析-浏览量折线图 | websiteDashboard | getPageviewLineChart | null | service | {"service": "websiteDashboard", "serviceFunction": "getPageviewLineChart"} | 388 | insert | |||||||
⛔️网站数据分析-总览 | websiteDashboard | getOverview | null | service | {"service": "websiteDashboard", "serviceFunction": "getOverview"} | 389 | insert | |||||||
✅网站数据分析-访问日志列表 | websiteDashboard | getPageviewList | null | service | {"service": "websiteDashboard", "serviceFunction": "getPageviewList"} | 390 | insert | |||||||
✅网站数据分析-实时用户列表 | websiteDashboard | getRealtimeDeviceList | null | service | {"service": "websiteDashboard", "serviceFunction": "getRealtimeDeviceList"} | 391 | insert | |||||||
⛔️网站数据分析-站内搜索关键词 | websiteDashboard | getWebsiteSearchList | null | service | {"service": "websiteDashboard", "serviceFunction": "getWebsiteSearchList"} | 392 | insert | |||||||
⛔️网站数据分析-搜索引擎搜索关键词 | websiteDashboard | getBrowserSearchList | null | service | {"service": "websiteDashboard", "serviceFunction": "getBrowserSearchList"} | 393 | insert | |||||||
✅网站数据分析-页面访问量排行 | websiteDashboard | getPageviewRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getPageviewRankingList"} | 394 | insert | |||||||
✅网站数据分析-来源域名排行 | websiteDashboard | getReferenceRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getReferenceRankingList"} | 395 | insert | |||||||
✅网站数据分析-国家排行 | websiteDashboard | getCountryRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getCountryRankingList"} | 396 | insert | |||||||
✅网站数据分析-浏览器排行 | websiteDashboard | getBrowserRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getBrowserRankingList"} | 397 | insert | |||||||
✅网站数据分析-语言排行 | websiteDashboard | getLanguageRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getLanguageRankingList"} | 398 | insert | |||||||
✅网站数据分析-屏幕分辨率排行 | websiteDashboard | getScreenRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getScreenRankingList"} | 399 | insert | |||||||
✅网站数据分析-操作系统排行 | websiteDashboard | getSystemOsRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getSystemOsRankingList"} | 400 | insert | |||||||
⛔️网站数据分析-分类排行 | websiteDashboard | getCategoryRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getCategoryRankingList"} | 401 | insert | |||||||
⛔️网站数据分析-文章排行 | websiteDashboard | getPageRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getPageRankingList"} | 402 | insert | |||||||
⛔️网站数据分析-浏览器搜索引擎排行 | websiteDashboard | getSearchEngineRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getSearchEngineRankingList"} | 403 | insert | |||||||
⛔️网站数据分析-访客停留时间排行 | websiteDashboard | getVisitTimeRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getVisitTimeRankingList"} | 404 | insert | |||||||
✅网站数据分析-404访问日志列表 | websiteDashboard | getPageviewList404 | null | service | {"service": "websiteDashboard", "serviceFunction": "getPageviewList404"} | 405 | insert | |||||||
✅网站数据分析-IP排行 | websiteDashboard | getIpRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getIpRankingList"} | 406 | insert | |||||||
✅网站数据分析-用户访问排行 | websiteDashboard | getUserRankingList | null | service | {"service": "websiteDashboard", "serviceFunction": "getUserRankingList"} | 407 | insert |
用户管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
用户管理 | userManagement | showInMenu | undefined | 3 | undefined |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | {"service": "userManagement", "serviceFunction": "resetUserPassword"} | 343 | update | 2022-06-11T13:49:17+08:00 | vscode | vscode | ||||
✅用户管理-更新用户 | userManagement | updateItem | null | sql | {"table": "_user", "operation": "jhUpdate"} | 344 | update | 2022-06-11T13:49:18+08:00 | vscode | vscode | ||||
✅用户管理-查询信息 | userManagement | selectItemList | null | sql | {"table": "_user", "operation": "select"} | 354 | update | 2022-06-11T13:49:18+08:00 | vscode | vscode | ||||
✅用户管理-查询信息 | userManagement | insertItem | null | service | {"service": "userManagement", "serviceFunction": "addUser"} | 355 | update | 2022-06-11T13:49:18+08:00 | vscode | vscode | ||||
✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | {"service": "userManagement", "serviceFunction": "resetUserPassword"} | 356 | update | 2022-06-11T13:49:18+08:00 | vscode | vscode | ||||
✅用户管理-更新用户 | userManagement | updateItem | null | sql | {"table": "_user", "operation": "jhUpdate"} | 357 | update | 2022-06-11T13:49:18+08:00 | vscode | vscode |
测试页面
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
测试页面 | test | dynamicInMenu | undefined | null | undefined |
通知/待办
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
通知/待办 | https://demo.jianghujs.org/task/page/noticeManagement | showInRightMenu | undefined | null | undefined |
_page语句
INSERT INTO _page (id, pageId, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'dynamicInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', '', NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'websiteManagement', '网站管理', 'showInMenu', NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'websiteDashboard', '网站数据分析', 'dynamicInMenu', NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'userManagement', '用户管理', 'showInMenu', NULL, '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'test', '测试页面', 'dynamicInMenu', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'https://demo.jianghujs.org/task/page/noticeManagement', '通知/待办', '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);