江湖数字化平台
登录

接口

12144

接口总览

_resource结构

  1. CREATE TABLE `_resource` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  4.   `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  5.   `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  6.   `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  7.   `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  8.   `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  9.   `appDataSchema` text COMMENT 'appData 参数校验',
  10.   `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  11.   `requestDemo` text COMMENT '请求Demo',
  12.   `responseDemo` text COMMENT '响应Demo',
  13.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  14.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  15.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  16.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  17.   PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE = InnoDB AUTO_INCREMENT = 555 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id desc pageId actionId resourceType resourceHook resourceData
104 ✅ 文件分片下载-获取分片信息 allPage getChunkInfo service null { "service": "file", "serviceFunction": "getChunkInfo" }
105 ✅ 文件分片上传-所有分片上传完毕 allPage uploadFileDone service null { "service": "file", "serviceFunction": "uploadFileDone" }
106 ✅ 文件分片上传-http文件流 allPage httpUploadByStream service null { "service": "file", "serviceFunction": "uploadFileChunkByStream" }
107 ✅ 文件分片上传-http base64 allPage httpUploadByBase64 service null { "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
231 ✅登陆 login passwordLogin service null { "service": "user", "serviceFunction": "passwordLogin" }
251 ✅登出 allPage logout service null { "service": "user", "serviceFunction": "logout" }
253 ✅获取用户信息 allPage userInfo service null { "service": "user", "serviceFunction": "userInfo" }
258 ✅查询常量 allPage getConstantList sql null { "table": "_constant", "operation": "select" }
325 ✅前端规范-查询列表 doUiAction selectItemList sql null { "table": "student", "operation": "select" }
326 ✅前端规范-添加成员 doUiAction insertItem sql null { "table": "student", "operation": "jhInsert" }
327 ✅前端规范-更新成员 doUiAction updateItem sql null { "table": "student", "operation": "jhUpdate" }
328 ✅前端规范-删除信息 doUiAction deleteItem sql null { "table": "student", "operation": "jhDelete" }
497 ✅云盘-获取用户云盘 cloud_drive getUserCloudDriveList service null { "service": "cloudDrive", "serviceFunction": "getUserCloudDriveList" }
498 ✅云盘-保存markdown文件 cloud_drive saveMarkdown service null { "service": "cloudDrive", "serviceFunction": "saveMarkdown" }
499 ✅云盘-移动文件 cloud_drive moveFile service null { "service": "cloudDrive", "serviceFunction": "moveFile" }
500 ✅云盘-复制文件 cloud_drive copyFile service null { "service": "cloudDrive", "serviceFunction": "copyFile" }
501 ✅云盘-文件列表 cloud_drive getDirItemList service null { "service": "cloudDrive", "serviceFunction": "getDirItemList" }
502 ✅云盘-删除文件 cloud_drive deleteDirOrFile service null { "service": "cloudDrive", "serviceFunction": "deleteDirOrFile" }
503 ✅云盘-获取markdown内容 cloud_drive getMarkdownContent service null { "service": "cloudDrive", "serviceFunction": "getMarkdownContent" }
504 ✅云盘- 重命名文件 cloud_drive renameFile service null { "service": "cloudDrive", "serviceFunction": "renameFile" }
505 ✅云盘-创建文件目录 cloud_drive mkdir service null { "service": "cloudDrive", "serviceFunction": "mkdir" }
506 ✅云盘-清空回收站 cloud_drive clearRecycle service null { "service": "cloudDrive", "serviceFunction": "clearRecycle" }
511 ✅查询列表 leads selectRecordHistory sql null { "table": "_record_history", "operation": "select" }
520 ✅查询列表 leads selectItemList sql null { "table": "leads", "operation": "select" }
521 ✅添加 leads insertItem sql { "table": "leads", "operation": "jhInsert" }
522 ✅更新 leads updateItem sql null { "table": "leads", "operation": "jhUpdate" }
523 ✅删除 leads deleteItem sql null { "table": "leads", "operation": "jhDelete" }
532 ✅查询列表 exampleClass selectItemList sql null { "table": "example_class", "operation": "select" }
533 ✅添加 exampleClass insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ] } { "table": "example_class", "operation": "jhInsert" }
534 ✅更新 exampleClass updateItem sql null { "table": "example_class", "operation": "jhUpdate" }
535 ✅删除 exampleClass deleteItem sql null { "table": "example_class", "operation": "jhDelete" }
536 ✅查询列表 exampleClass selectRecordHistory sql null { "table": "_record_history", "operation": "select" }
537 ✅查询当前{{nameA}}下的{{nameB}}列表 exampleClass studentOfClass-selectItemList sql null { "table": "example_student", "operation": "select" }
538 ✅建立关系 exampleClass studentOfClass-insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ] } { "table": "example_student", "operation": "jhInsert" }
539 ✅更新数据 exampleClass studentOfClass-updateItem sql null { "table": "example_student", "operation": "jhUpdate" }
540 ✅删除信息 exampleClass studentOfClass-deleteItem sql null { "table": "example_student", "operation": "jhDelete" }
541 ✅线索池-查询线索列表 leadsSeas selectLeadList sql null { "table": "leads", "operation": "select" }
542 ✅线索池-查询线索池列表 leadsSeas selectItemList sql null { "table": "leads_pool", "operation": "select" }
543 ✅客户-查询列表 customer selectItemList sql null { "table": "customer", "operation": "select" }
544 ✅客户公海-查询客户列表 customerSeas selectCustomerList sql null { "table": "customer", "operation": "select" }
545 ✅客户公海-查询客户公海列表 customerSeas selectItemList sql null { "table": "customer_pool", "operation": "select" }
546 ✅联系人-查询列表 contacts selectItemList sql null { "table": "contacts", "operation": "select" }
547 ✅商机-查询列表 business selectItemList sql null { "table": "business", "operation": "select" }
548 ✅合同-查询列表 contract selectItemList sql null { "table": "contract", "operation": "select" }
549 ✅回款-查询列表 receivables selectItemList sql null { "table": "receivables", "operation": "select" }
550 ✅回款计划-查询列表 receivablesPlan selectItemList sql null { "table": "receivables_plan", "operation": "select" }
551 ✅回访-查询列表 visit selectItemList sql null { "table": "return_visit", "operation": "select" }
552 ✅产品-查询列表 product selectItemList sql null { "table": "product", "operation": "select" }
553 ✅营销-查询列表 marketing selectItemList sql null { "table": "marketing", "operation": "select" }
554 ✅发票-查询列表 invoice selectItemList sql null { "table": "invoice", "operation": "select" }

_resource语句

  1. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (104, NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', NULL, NULL, 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  2. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (105, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  3. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (106, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', NULL, NULL, 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  4. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (107, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', NULL, NULL, 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  5. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
  6. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
  8. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{
  9.     "type": "object",
  10.     "additionalProperties": true,
  11.     "required": [],
  12.     "properties": {}
  13. }', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  14. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (325, NULL, NULL, 'doUiAction', 'selectItemList', '✅前端规范-查询列表', 'sql', '{
  15.     "type": "object",
  16.     "additionalProperties": true,
  17.     "required": [],
  18.     "properties": {}
  19. }', '{"table": "student", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  20. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (326, NULL, NULL, 'doUiAction', 'insertItem', '✅前端规范-添加成员', 'sql', '{
  21.     "type": "object",
  22.     "required": ["actionData"],
  23.     "properties": {
  24.         "actionData": {
  25.             "type": "object",
  26.             "required": ["classId", "name", "level", "gender", "dateOfBirth"],
  27.             "properties": {
  28.                 "name": {
  29.                     "type": "string"
  30.                 },
  31.                 "level": {
  32.                     "anyOf": [{
  33.                         "type": "string"
  34.                     }, {
  35.                         "type": "number"
  36.                     }]
  37.                 },
  38.                 "gender": {
  39.                     "type": "string"
  40.                 },
  41.                 "classId": {
  42.                     "type": "string"
  43.                 },
  44.                 "dateOfBirth": {
  45.                     "type": "string",
  46.                     "format": "date"
  47.                 }
  48.             },
  49.             "additionalProperties": true
  50.         }
  51.     },
  52.     "additionalProperties": true
  53. }', '{"table": "student", "operation": "jhInsert"}', '', '', 'insert', NULL, NULL, NULL);
  54. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (327, NULL, NULL, 'doUiAction', 'updateItem', '✅前端规范-更新成员', 'sql', '{
  55.     "type": "object",
  56.     "required": ["where", "actionData"],
  57.     "properties": {
  58.         "where": {
  59.             "type": "object",
  60.             "required": ["id"],
  61.             "properties": {
  62.                 "id": {
  63.                     "type": "number"
  64.                 }
  65.             }
  66.         },
  67.         "actionData": {
  68.             "type": "object",
  69.             "properties": {
  71.                 "studentId": {
  72.                     "type": "string"
  73.                 },
  74.                 "name": {
  75.                     "type": "string"
  76.                 },
  77.                 "level": {
  78.                     "anyOf": [{
  79.                         "type": "string"
  80.                     }, {
  81.                         "type": "number"
  82.                     }]
  83.                 },
  84.                 "gender": {
  85.                     "type": "string"
  86.                 },
  87.                 "classId": {
  88.                     "type": "string"
  89.                 },
  90.                 "dateOfBirth": {
  91.                     "type": "string",
  92.                     "format": "date"
  93.                 }
  94.             },
  95.             "additionalProperties": true
  96.         }
  97.     },
  98.     "additionalProperties": true
  99. }', '{"table": "student", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
  100. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (328, NULL, NULL, 'doUiAction', 'deleteItem', '✅前端规范-删除信息', 'sql', '{
  101.     "type": "object",
  102.     "required": ["where"],
  103.     "properties": {
  104.         "where": {
  105.             "type": "object",
  106.             "required": ["id"],
  107.             "properties": {
  108.                 "id": {
  109.                     "type": "number"
  110.                 }
  111.             },
  112.             "additionalProperties": true
  113.         }
  114.     },
  115.     "additionalProperties": true
  116. }', '{"table": "student", "operation": "jhDelete"}', '', '', 'insert', NULL, NULL, NULL);
  117. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (497, NULL, NULL, 'cloud_drive', 'getUserCloudDriveList', '✅云盘-获取用户云盘', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getUserCloudDriveList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  118. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (498, NULL, NULL, 'cloud_drive', 'saveMarkdown', '✅云盘-保存markdown文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "saveMarkdown" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  119. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (499, NULL, NULL, 'cloud_drive', 'moveFile', '✅云盘-移动文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "moveFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  120. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (500, NULL, NULL, 'cloud_drive', 'copyFile', '✅云盘-复制文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "copyFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  121. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (501, NULL, NULL, 'cloud_drive', 'getDirItemList', '✅云盘-文件列表', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getDirItemList" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  122. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (502, NULL, NULL, 'cloud_drive', 'deleteDirOrFile', '✅云盘-删除文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "deleteDirOrFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  123. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (503, NULL, NULL, 'cloud_drive', 'getMarkdownContent', '✅云盘-获取markdown内容', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "getMarkdownContent" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  124. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (504, NULL, NULL, 'cloud_drive', 'renameFile', '✅云盘- 重命名文件', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "renameFile" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  125. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (505, NULL, NULL, 'cloud_drive', 'mkdir', '✅云盘-创建文件目录', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "mkdir" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  126. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (506, NULL, NULL, 'cloud_drive', 'clearRecycle', '✅云盘-清空回收站', 'service', '{}', '{ "service": "cloudDrive", "serviceFunction": "clearRecycle" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  127. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (511, NULL, NULL, 'leads', 'selectRecordHistory', '✅查询列表', 'sql', '{}', '{ "table": "_record_history", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  128. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (520, NULL, NULL, 'leads', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "leads", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  129. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (521, NULL, '', 'leads', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "leads", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  130. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (522, NULL, NULL, 'leads', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "leads", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  131. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (523, NULL, NULL, 'leads', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "leads", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  132. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (532, NULL, NULL, 'exampleClass', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "example_class", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  133. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (533, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}]}', 'exampleClass', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "example_class", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  134. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (534, NULL, NULL, 'exampleClass', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "example_class", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  135. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (535, NULL, NULL, 'exampleClass', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "example_class", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  136. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (536, NULL, NULL, 'exampleClass', 'selectRecordHistory', '✅查询列表', 'sql', '{}', '{ "table": "_record_history", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  137. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (537, NULL, NULL, 'exampleClass', 'studentOfClass-selectItemList', '✅查询当前{{nameA}}下的{{nameB}}列表', 'sql', '{}', '{ "table": "example_student", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  138. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (538, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}]}', 'exampleClass', 'studentOfClass-insertItem', '✅建立关系', 'sql', '{}', '{ "table": "example_student", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  139. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (539, NULL, NULL, 'exampleClass', 'studentOfClass-updateItem', '✅更新数据', 'sql', '{}', '{ "table": "example_student", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  140. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (540, NULL, NULL, 'exampleClass', 'studentOfClass-deleteItem', '✅删除信息', 'sql', '{}', '{ "table": "example_student", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  141. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (541, NULL, NULL, 'leadsSeas', 'selectLeadList', '✅线索池-查询线索列表', 'sql', '{}', '{ "table": "leads", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  142. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (542, NULL, NULL, 'leadsSeas', 'selectItemList', '✅线索池-查询线索池列表', 'sql', '{}', '{ "table": "leads_pool", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  143. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (543, NULL, NULL, 'customer', 'selectItemList', '✅客户-查询列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  144. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (544, NULL, NULL, 'customerSeas', 'selectCustomerList', '✅客户公海-查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  145. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (545, NULL, NULL, 'customerSeas', 'selectItemList', '✅客户公海-查询客户公海列表', 'sql', '{}', '{ "table": "customer_pool", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  146. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (546, NULL, NULL, 'contacts', 'selectItemList', '✅联系人-查询列表', 'sql', '{}', '{ "table": "contacts", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  147. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (547, NULL, NULL, 'business', 'selectItemList', '✅商机-查询列表', 'sql', '{}', '{ "table": "business", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  148. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (548, '', NULL, 'contract', 'selectItemList', '✅合同-查询列表', 'sql', '{}', '{ "table": "contract", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  149. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (549, NULL, NULL, 'receivables', 'selectItemList', '✅回款-查询列表', 'sql', '{}', '{ "table": "receivables", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  150. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (550, NULL, NULL, 'receivablesPlan', 'selectItemList', '✅回款计划-查询列表', 'sql', '{}', '{ "table": "receivables_plan", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  151. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (551, NULL, NULL, 'visit', 'selectItemList', '✅回访-查询列表', 'sql', '{}', '{ "table": "return_visit", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  152. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (552, NULL, NULL, 'product', 'selectItemList', '✅产品-查询列表', 'sql', '{}', '{ "table": "product", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  153. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (553, NULL, NULL, 'marketing', 'selectItemList', '✅营销-查询列表', 'sql', '{}', '{ "table": "marketing", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  154. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (554, NULL, NULL, 'invoice', 'selectItemList', '✅发票-查询列表', 'sql', '{}', '{ "table": "invoice", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);