江湖数字化平台
登录

页面

12144

页面总览

_page结构

  1. CREATE TABLE `_page` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  4.   `pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  5.   `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  6.   `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  7.   `pageIcon` longtext COMMENT '页面icon，svg格式',
  8.   `sort` varchar(255) DEFAULT NULL,
  9.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  11.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  12.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  13.   `pageHook` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL,
  14.   PRIMARY KEY (`id`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 45 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '页面表; 软删除未启用;'

帮助

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

登陆

  • 页面信息
pageName pageId pageType pageFile sort pageHook
登陆 login loginV4 null
  • 接口信息
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
通知 https://www.openjianghu.org/doc/directory showInRightMenu null 5 null

仪表盘

  • 页面信息
pageName pageId pageType pageFile sort pageHook
仪表盘 workbench showInMenu null 1 null

[线索]线索管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[线索]线索管理 leads showInMenu null 2 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 leads selectRecordHistory null sql { "table": "_record_history", "operation": "select" } {} 511 insert
✅查询列表 leads selectItemList null sql { "table": "leads", "operation": "select" } {} 520 jhInsert
✅添加 leads insertItem sql { "table": "leads", "operation": "jhInsert" } {} 521 jhInsert
✅更新 leads updateItem null sql { "table": "leads", "operation": "jhUpdate" } {} 522 jhInsert
✅删除 leads deleteItem null sql { "table": "leads", "operation": "jhDelete" } {} 523 jhInsert

[线索]线索池

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[线索]线索池 leadsSeas showInMenu null 3 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅线索池-查询线索列表 leadsSeas selectLeadList null sql { "table": "leads", "operation": "select" } {} 541 jhInsert
✅线索池-查询线索池列表 leadsSeas selectItemList null sql { "table": "leads_pool", "operation": "select" } {} 542 jhInsert

[客户]客户公海

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[客户]客户公海 customerSeas showInMenu null 5 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅客户公海-查询客户列表 customerSeas selectCustomerList null sql { "table": "customer", "operation": "select" } {} 544 jhInsert
✅客户公海-查询客户公海列表 customerSeas selectItemList null sql { "table": "customer_pool", "operation": "select" } {} 545 jhInsert

[客户]客户管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[客户]客户管理 customer showInMenu null 4 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅客户-查询列表 customer selectItemList null sql { "table": "customer", "operation": "select" } {} 543 jhInsert

联系人

  • 页面信息
pageName pageId pageType pageFile sort pageHook
联系人 contacts showInMenu null 6 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅联系人-查询列表 contacts selectItemList null sql { "table": "contacts", "operation": "select" } {} 546 jhInsert

商机

  • 页面信息
pageName pageId pageType pageFile sort pageHook
商机 business showInMenu null 7 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅商机-查询列表 business selectItemList null sql { "table": "business", "operation": "select" } {} 547 jhInsert

合同

  • 页面信息
pageName pageId pageType pageFile sort pageHook
合同 contract showInMenu null 8 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅合同-查询列表 contract selectItemList null sql { "table": "contract", "operation": "select" } {} 548 jhInsert

[回款]回款计划

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[回款]回款计划 receivablesPlan showInMenu null 9 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅回款计划-查询列表 receivablesPlan selectItemList null sql { "table": "receivables_plan", "operation": "select" } {} 550 jhInsert

[回款]回款管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[回款]回款管理 receivables showInMenu null 9 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅回款-查询列表 receivables selectItemList null sql { "table": "receivables", "operation": "select" } {} 549 jhInsert

发票

  • 页面信息
pageName pageId pageType pageFile sort pageHook
发票 invoice 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
✅发票-查询列表 invoice selectItemList null sql { "table": "invoice", "operation": "select" } {} 554 jhInsert

回访

  • 页面信息
pageName pageId pageType pageFile sort pageHook
回访 visit showInMenu null 11 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅回访-查询列表 visit selectItemList null sql { "table": "return_visit", "operation": "select" } {} 551 jhInsert

产品

  • 页面信息
pageName pageId pageType pageFile sort pageHook
产品 product showInMenu null 12 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅产品-查询列表 product selectItemList null sql { "table": "product", "operation": "select" } {} 552 jhInsert

营销

  • 页面信息
pageName pageId pageType pageFile sort pageHook
营销 marketing 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
✅营销-查询列表 marketing selectItemList null sql { "table": "marketing", "operation": "select" } {} 553 jhInsert

通知/待办

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

_page语句

  1. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (2, 'help', 'helpV4', '帮助', 'dynamicInMenu', NULL, '11', 'insert', NULL, NULL, NULL, NULL);
  2. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (3, 'login', 'loginV4', '登陆', '', NULL, '', 'insert', NULL, NULL, NULL, NULL);
  3. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (5, 'https://www.openjianghu.org/doc/directory', 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>', '5', 'insert', NULL, NULL, NULL, NULL);
  4. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (24, 'workbench', NULL, '仪表盘', 'showInMenu', NULL, '1', 'insert', NULL, NULL, NULL, NULL);
  5. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (25, 'leads', NULL, '[线索]线索管理', 'showInMenu', '', '2', 'insert', NULL, NULL, NULL, '{
  6.   "beforeHook":[
  7.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  8.     ]
  9. }');
  10. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (26, 'leadsSeas', NULL, '[线索]线索池', 'showInMenu', NULL, '3', 'insert', NULL, NULL, NULL, '{
  11.   "beforeHook":[
  12.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  13.     ]
  14. }');
  15. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (27, 'customerSeas', NULL, '[客户]客户公海', 'showInMenu', NULL, '5', 'insert', NULL, NULL, NULL, '{
  16.   "beforeHook":[
  17.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  18.     ]
  19. }');
  20. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (28, 'customer', NULL, '[客户]客户管理', 'showInMenu', NULL, '4', 'insert', NULL, NULL, NULL, '{
  21.   "beforeHook":[
  22.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  23.     ]
  24. }');
  25. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (29, 'contacts', NULL, '联系人', 'showInMenu', NULL, '6', 'insert', NULL, NULL, NULL, '{
  26.   "beforeHook":[
  27.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  28.     ]
  29. }');
  30. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (31, 'business', NULL, '商机', 'showInMenu', NULL, '7', 'insert', NULL, NULL, NULL, '{
  31.   "beforeHook":[
  32.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  33.     ]
  34. }');
  35. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (32, 'contract', NULL, '合同', 'showInMenu', NULL, '8', 'insert', NULL, NULL, NULL, '{
  36.   "beforeHook":[
  37.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  38.     ]
  39. }');
  40. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (33, 'receivablesPlan', NULL, '[回款]回款计划', 'showInMenu', NULL, '9', 'insert', NULL, NULL, NULL, '{
  41.   "beforeHook":[
  42.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  43.     ]
  44. }');
  45. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (34, 'receivables', NULL, '[回款]回款管理', 'showInMenu', NULL, '9', 'insert', NULL, NULL, NULL, '{
  46.   "beforeHook":[
  47.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  48.     ]
  49. }');
  50. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (35, 'invoice', NULL, '发票', 'showInMenu', NULL, '10', 'insert', NULL, NULL, NULL, '{
  51.   "beforeHook":[
  52.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  53.     ]
  54. }');
  55. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (36, 'visit', NULL, '回访', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL, '{
  56.   "beforeHook":[
  57.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  58.     ]
  59. }');
  60. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (37, 'product', NULL, '产品', 'showInMenu', NULL, '12', 'insert', NULL, NULL, NULL, '{
  61.   "beforeHook":[
  62.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  63.     ]
  64. }');
  65. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (38, 'marketing', NULL, '营销', 'showInMenu', NULL, '13', 'insert', NULL, NULL, NULL, '{
  66.   "beforeHook":[
  67.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  68.     ]
  69. }');
  70. INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt, pageHook) VALUES (44, 'https://demo.jianghujs.org/task/page/noticeManagement', 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, NULL);