Jianghu Digital Platform
Login

Interface

12144

接口总览

_resource结构

CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  `appDataSchema` text COMMENT 'appData 参数校验',
  `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `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 = 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语句

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');
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);
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');
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');
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');
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);
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');
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', '{
    "type": "object",
    "additionalProperties": true,
    "required": [],
    "properties": {}
}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
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', '{
    "type": "object",
    "additionalProperties": true,
    "required": [],
    "properties": {}
}', '{"table": "student", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
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', '{
    "type": "object",
    "required": ["actionData"],
    "properties": {
        "actionData": {
            "type": "object",
            "required": ["classId", "name", "level", "gender", "dateOfBirth"],
            "properties": {
                "name": {
                    "type": "string"
                },
                "level": {
                    "anyOf": [{
                        "type": "string"
                    }, {
                        "type": "number"
                    }]
                },
                "gender": {
                    "type": "string"
                },
                "classId": {
                    "type": "string"
                },
                "dateOfBirth": {
                    "type": "string",
                    "format": "date"
                }
            },
            "additionalProperties": true
        }
    },
    "additionalProperties": true
}', '{"table": "student", "operation": "jhInsert"}', '', '', 'insert', NULL, NULL, NULL);
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', '{
    "type": "object",
    "required": ["where", "actionData"],
    "properties": {
        "where": {
            "type": "object",
            "required": ["id"],
            "properties": {
                "id": {
                    "type": "number"
                }
            }
        },
        "actionData": {
            "type": "object",
            "properties": {

                "studentId": {
                    "type": "string"
                },
                "name": {
                    "type": "string"
                },
                "level": {
                    "anyOf": [{
                        "type": "string"
                    }, {
                        "type": "number"
                    }]
                },
                "gender": {
                    "type": "string"
                },
                "classId": {
                    "type": "string"
                },
                "dateOfBirth": {
                    "type": "string",
                    "format": "date"
                }
            },
            "additionalProperties": true
        }
    },
    "additionalProperties": true
}', '{"table": "student", "operation": "jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
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', '{
    "type": "object",
    "required": ["where"],
    "properties": {
        "where": {
            "type": "object",
            "required": ["id"],
            "properties": {
                "id": {
                    "type": "number"
                }
            },
            "additionalProperties": true
        }
    },
    "additionalProperties": true
}', '{"table": "student", "operation": "jhDelete"}', '', '', 'insert', NULL, NULL, NULL);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);