江湖数字化平台
登录

页面

12114

页面总览

_page结构

  1. CREATE TABLE `_page` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  4.   `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  5.   `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  6.   `sort` varchar(255)  DEFAULT NULL,
  7.   `pageHook` text  COMMENT '{\n  "beforeHook":[\n  {"field": "doc", "service": "doc", "serviceFunc": "getDoc"}\n  ]\n}',
  8.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  9.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  10.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  11.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  12.   PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 93 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

  • 页面信息
pageName pageId pageType pageFile sort pageHook
帮助 help dynamicInMenu undefined 11 null

登录

  • 页面信息
pageName pageId pageType pageFile sort pageHook
登录 login undefined {
"beforeHook":[ 
  1. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}

]
} |

  • 接口信息
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
首页 home seo undefined {
"beforeHook":[ 
  1. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  2.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅分类管理-查询列表 home selectCategoryList null sql { "table": "view01_category", "operation": "select" } {} 345 insert

分类

  • 页面信息
pageName pageId pageType pageFile sort pageHook
分类 category seo undefined null {
"beforeHook":[ 
  1.     {"field": "articleSearch", "service": "article", "serviceFunc": "getArticleList"},
  2.     {"field": "articleNewList", "service": "article", "serviceFunc": "getArticleNewest"},
  3.     {"field": "category", "service": "category", "serviceFunc": "getCategoryList"},
  4. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  5.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

xf文章

  • 页面信息
pageName pageId pageType pageFile sort pageHook
xf文章 xfArticle seo undefined null {
"beforeHook":[ 
  1. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  2.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

搜索

  • 页面信息
pageName pageId pageType pageFile sort pageHook
搜索 search seo undefined null {
"beforeHook":[ 
  1. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  2.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

xfPage文章详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
xfPage文章详情 xfPage seo undefined {
"beforeHook":[ 
  1. {"field": "xfPage", "service": "xfPage", "serviceFunc": "getXfPageAndFillArticles"},
  2. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  3.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

文章详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
文章详情 article seo undefined null {
"beforeHook":[ 
  1. {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"},
  2. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  3.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅文章页面 article addComment null sql { "table": "comment", "operation": "jhInsert" } {} 461 insert

文章

  • 页面信息
pageName pageId pageType pageFile sort pageHook
文章 blog seo undefined null {
"beforeHook":[ 
  1.     {"field": "articleSearch", "service": "article", "serviceFunc": "getArticleList"},
  2.     {"field": "articleNewList", "service": "article", "serviceFunc": "getArticleNewest"},
  3.     {"field": "category", "service": "category", "serviceFunc": "getCategoryList"},
  4. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  5.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询分类列表 blog selectCategoryList null sql { "table": "view01_category", "operation": "select" } {} 462 insert

404

  • 页面信息
pageName pageId pageType pageFile sort pageHook
404 404 seo undefined null {
"beforeHook":[ 
  1. {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  2.     {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}

]
} |

_page语句

  1. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'dynamicInMenu', '11', NULL, 'insert', NULL, NULL, NULL);
  2. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登录', '', '', '{
  3.   "beforeHook":[
  4.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  5.   ]
  6. }', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'home', '首页', 'seo', '', '{
  8.   "beforeHook":[
  9.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  10.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  11.   ]
  12. }', 'insert', NULL, NULL, NULL);
  13. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'category', '分类', 'seo', NULL, '{
  14.   "beforeHook":[
  15.         {"field": "articleSearch", "service": "article", "serviceFunc": "getArticleList"},
  16.         {"field": "articleNewList", "service": "article", "serviceFunc": "getArticleNewest"},
  17.         {"field": "category", "service": "category", "serviceFunc": "getCategoryList"},
  18.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  19.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  20.   ]
  21. }', 'insert', NULL, NULL, NULL);
  22. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'xfArticle', 'xf文章', 'seo', NULL, '{
  23.   "beforeHook":[
  24.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  25.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  26.   ]
  27. }', 'insert', NULL, NULL, NULL);
  28. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (84, 'search', '搜索', 'seo', NULL, '{
  29.   "beforeHook":[
  30.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  31.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  32.   ]
  33. }', 'insert', NULL, NULL, NULL);
  34. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (89, 'xfPage', 'xfPage文章详情', 'seo', '', '{
  35.   "beforeHook":[
  36.     {"field": "xfPage", "service": "xfPage", "serviceFunc": "getXfPageAndFillArticles"},
  37.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  38.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  39.   ]
  40. }', 'insert', NULL, NULL, NULL);
  41. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (90, 'article', '文章详情', 'seo', NULL, '{
  42.   "beforeHook":[
  43.     {"field": "article", "service": "article", "serviceFunc": "getArticleAndFillArticles"},
  44.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  45.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  46.   ]
  47. }', 'insert', NULL, NULL, NULL);
  48. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (91, 'blog', '文章', 'seo', NULL, '{
  49.   "beforeHook":[
  50.         {"field": "articleSearch", "service": "article", "serviceFunc": "getArticleList"},
  51.         {"field": "articleNewList", "service": "article", "serviceFunc": "getArticleNewest"},
  52.         {"field": "category", "service": "category", "serviceFunc": "getCategoryList"},
  53.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  54.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  55.   ]
  56. }', 'insert', NULL, NULL, NULL);
  57. INSERT INTO _page (id, pageId, pageName, pageType, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (92, '404', '404', 'seo', NULL, '{
  58.   "beforeHook":[
  59.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  60.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  61.   ]
  62. }', 'insert', NULL, NULL, NULL);