接口

12114

接口总览

_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 = 502 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id	desc	pageId	actionId	resourceType	resourceData
231	✅登陆	login	passwordLogin	service	{ "service": "user", "serviceFunction": "passwordLogin" }
251	✅登出	allPage	logout	service	{ "service": "user", "serviceFunction": "logout" }
253	✅获取用户信息	allPage	userInfo	service	{ "service": "user", "serviceFunction": "userInfo" }
258	✅查询常量	allPage	getConstantList	sql	{ "table": "_constant", "operation": "select" }
259	✅查询常量	allPage	getExamConstantList	sql	{ "table": "_view01_exam_constant", "operation": "select" }
371	✅查询学情考试	baseExamList	selectItem	service	{ "service": "baseExam", "serviceFunction": "getBaseExamList" }
372	✅查询考试列表	baseExamList	selectExamList	service	{ "service": "baseExam", "serviceFunction": "getExamList" }
373	✅保存学情考试	baseExamList	saveBaseExam	service	{ "service": "baseExam", "serviceFunction": "saveBaseExamList" }
374	✅查询班级学情考试M值	baseExamList	getClassSubjectMValue	service	{ "service": "baseExam", "serviceFunction": "getClassSubjectMValue" }
443	✅查询列表	examList	selectItemList	service	{ "service": "examList", "serviceFunction": "getExamList" }
444	✅查询老师考试N值	examList	getClassSubjectNValue	service	{ "service": "examList", "serviceFunction": "getClassSubjectNValue" }
500	✅查询老师绩效奖励	performanceList	getTeacherMoneyList	service	{ "service": "performanceList", "serviceFunction": "getTeacherMoneyList" }
501	✅查询老师绩效奖励	performanceList	getTeacherDetail	service	{ "service": "performanceList", "serviceFunction": "getTeacherDetail" }

_resource语句

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" }', '', '', 'insert', NULL, NULL, NULL);
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" }', '', '', 'insert', NULL, NULL, NULL);
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', '{}', '{ "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 (259, NULL, NULL, 'allPage', 'getExamConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_view01_exam_constant", "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 (371, NULL, NULL, 'baseExamList', 'selectItem', '✅查询学情考试', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "getBaseExamList" }', 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 (372, NULL, NULL, 'baseExamList', 'selectExamList', '✅查询考试列表', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "getExamList" }', 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 (373, NULL, '', 'baseExamList', 'saveBaseExam', '✅保存学情考试', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "saveBaseExamList" }', 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 (374, NULL, NULL, 'baseExamList', 'getClassSubjectMValue', '✅查询班级学情考试M值', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "getClassSubjectMValue" }', 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 (443, NULL, NULL, 'examList', 'selectItemList', '✅查询列表', 'service', '{}', '{ "service": "examList", "serviceFunction": "getExamList" }', 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 (444, NULL, NULL, 'examList', 'getClassSubjectNValue', '✅查询老师考试N值', 'service', '{}', '{ "service": "examList", "serviceFunction": "getClassSubjectNValue" }', 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, 'performanceList', 'getTeacherMoneyList', '✅查询老师绩效奖励', 'service', '{}', '{ "service": "performanceList", "serviceFunction": "getTeacherMoneyList" }', 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, 'performanceList', 'getTeacherDetail', '✅查询老师绩效奖励', 'service', '{}', '{ "service": "performanceList", "serviceFunction": "getTeacherDetail" }', NULL, NULL, 'insert', NULL, NULL, NULL);

## 接口总览

## _resource结构

```sql
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 = 502 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
```

## _resource 内容

| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
| --- | --- | --- | --- | --- | --- | --- |
| 231 | ✅登陆 | login | passwordLogin | service |  | { "service": "user", "serviceFunction": "passwordLogin" } |
| 251 | ✅登出 | allPage | logout | service |  | { "service": "user", "serviceFunction": "logout" } |
| 253 | ✅获取用户信息 | allPage | userInfo | service |  | { "service": "user", "serviceFunction": "userInfo" } |
| 258 | ✅查询常量 | allPage | getConstantList | sql |  | { "table": "_constant", "operation": "select" } |
| 259 | ✅查询常量 | allPage | getExamConstantList | sql |  | { "table": "_view01_exam_constant", "operation": "select" } |
| 371 | ✅查询学情考试 | baseExamList | selectItem | service |  | { "service": "baseExam", "serviceFunction": "getBaseExamList" } |
| 372 | ✅查询考试列表 | baseExamList | selectExamList | service |  | { "service": "baseExam", "serviceFunction": "getExamList" } |
| 373 | ✅保存学情考试 | baseExamList | saveBaseExam | service |  | { "service": "baseExam", "serviceFunction": "saveBaseExamList" } |
| 374 | ✅查询班级学情考试M值 | baseExamList | getClassSubjectMValue | service |  | { "service": "baseExam", "serviceFunction": "getClassSubjectMValue" } |
| 443 | ✅查询列表 | examList | selectItemList | service |  | { "service": "examList", "serviceFunction": "getExamList" } |
| 444 | ✅查询老师考试N值 | examList | getClassSubjectNValue | service |  | { "service": "examList", "serviceFunction": "getClassSubjectNValue" } |
| 500 | ✅查询老师绩效奖励 | performanceList | getTeacherMoneyList | service |  | { "service": "performanceList", "serviceFunction": "getTeacherMoneyList" } |
| 501 | ✅查询老师绩效奖励 | performanceList | getTeacherDetail | service |  | { "service": "performanceList", "serviceFunction": "getTeacherDetail" } |
## _resource语句

```sql
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" }', '', '', 'insert', NULL, NULL, NULL);
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" }', '', '', 'insert', NULL, NULL, NULL);
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', '{}', '{ "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 (259, NULL, NULL, 'allPage', 'getExamConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_view01_exam_constant", "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 (371, NULL, NULL, 'baseExamList', 'selectItem', '✅查询学情考试', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "getBaseExamList" }', 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 (372, NULL, NULL, 'baseExamList', 'selectExamList', '✅查询考试列表', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "getExamList" }', 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 (373, NULL, '', 'baseExamList', 'saveBaseExam', '✅保存学情考试', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "saveBaseExamList" }', 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 (374, NULL, NULL, 'baseExamList', 'getClassSubjectMValue', '✅查询班级学情考试M值', 'service', '{}', '{ "service": "baseExam", "serviceFunction": "getClassSubjectMValue" }', 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 (443, NULL, NULL, 'examList', 'selectItemList', '✅查询列表', 'service', '{}', '{ "service": "examList", "serviceFunction": "getExamList" }', 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 (444, NULL, NULL, 'examList', 'getClassSubjectNValue', '✅查询老师考试N值', 'service', '{}', '{ "service": "examList", "serviceFunction": "getClassSubjectNValue" }', 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, 'performanceList', 'getTeacherMoneyList', '✅查询老师绩效奖励', 'service', '{}', '{ "service": "performanceList", "serviceFunction": "getTeacherMoneyList" }', 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, 'performanceList', 'getTeacherDetail', '✅查询老师绩效奖励', 'service', '{}', '{ "service": "performanceList", "serviceFunction": "getTeacherDetail" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```