接口

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 = 397 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"}
361	✅查询列表	examManagement	selectItemList	sql		{ "table": "view01_exam", "operation": "select" }
362	✅添加	examManagement	insertItem	sql	{"before":[{"service":"exam","serviceFunction":"appendExamIdBeforeCreate"}]}	{ "table": "exam", "operation": "insert" }
363	✅更新	examManagement	updateItem	sql		{ "table": "exam", "operation": "jhUpdate" }
364	✅删除	examManagement	deleteItem	sql		{ "table": "exam", "operation": "jhDelete" }
365	✅查询列表	studentResultListByExam	selectItemList	sql		{ "table": "student_exam_result_overall", "operation": "select" }
366	✅添加	studentResultListByExam	insertItem	sql		{ "table": "student_exam_result_overall", "operation": "insert" }
367	✅更新	studentResultListByExam	updateItem	sql		{ "table": "student_exam_result_overall", "operation": "jhUpdate" }
368	✅删除	studentResultListByExam	deleteItem	sql		{ "table": "student_exam_result_overall", "operation": "jhDelete" }
369	✅查询列表	studentResultListByExam	getExamInfo	sql		{ "table": "view01_exam", "operation": "select" }
370	✅查询列表	studentResultListByExam	selectOverallResultList	sql		{ "table": "student_exam_result_overall", "operation": "select" }
371	✅查询列表	studentResultListByExam	selectSubjectResultList	sql		{ "table": "student_exam_result_subject", "operation": "select" }
374	✅考试-标记成绩已录入	examManagement	markExamResultAsUploaded	sql		{ "table": "exam", "operation": "jhUpdate" }
375	✅成绩-删除总成绩	studentResultListByExam	deleteOverallResult	sql		{ "table": "student_exam_result_overall", "operation": "jhDelete" }
376	✅成绩-删除科目成绩	studentResultListByExam	deleteItemSubjectResult	sql		{ "table": "student_exam_result_subject", "operation": "jhDelete" }
377	✅考试-标记成绩未录入	examManagement	markExamResultAsCancelled	sql		{ "table": "exam", "operation": "jhUpdate" }
378	✅考试-确认成绩无误	examManagement	markExamResultAsChecked	sql	{"after":[{"service":"exam","serviceFunction":"confirmResultChecked"}]}	{ "table": "exam", "operation": "jhUpdate" }
379	✅考试-取消确认成绩无误	examManagement	markExamResultAsUnchecked	sql	{"after":[{"service":"exam","serviceFunction":"uncheckResult"}]}	{ "table": "exam", "operation": "jhUpdate" }
380	✅成绩-上传成绩	studentResultListByExam	uploadResultList	service		{ "service": "exam", "serviceFunction": "batchInsertExamResult" }
381	✅考试-删除考试	examManagement	markExamStatusAsDeleted	sql		{ "table": "exam", "operation": "jhUpdate" }
382	✅考试-获取考试中的班级列表	studentResultListByExam	getClassListByExam	service		{ "service": "exam", "serviceFunction": "getClassListByExam" }
383	✅考试-发送通知	examManagement	generateNoticeForExam	service		{ "service": "notice", "serviceFunction": "generateNoticeForExam" }
384	✅考试-更新通知模板	examManagement	updateNoticeTemplateForExam	sql		{ "table": "exam", "operation": "jhUpdate" }
385	✅考试-获取成绩通知消息模板	examManagement	getNoticeTemplateList	sql		{ "table": "notice_template", "operation": "select" }
386	✅查询学生列表	studentManagement	selectItemList	sql		{ "table": "view01_student", "operation": "select" }
387		studentResultListByStudent	selectItemList	sql		{ "table": "student_exam_result_overall", "operation": "select" }
388		studentResultListByStudent	getStudentInfo	sql		{ "table": "view01_student", "operation": "select" }
389		studentResultListByStudent	selectOverallResultList	sql		{ "table": "view01_student_exam_result_overall", "operation": "select" }
390		studentResultListByStudent	selectSubjectResultList	sql		{ "table": "view01_student_exam_result_subject", "operation": "select" }
391		studentResultListByStudent	deleteOverallResult	sql		{ "table": "student_exam_result_overall", "operation": "jhDelete" }
392		studentResultListByStudent	deleteItemSubjectResult	sql		{ "table": "student_exam_result_subject", "operation": "jhDelete" }
395	✅成绩-上传成绩前检查考号	studentResultListByExam	checkWrongStudentId	service		{ "service": "exam", "serviceFunction": "checkWrongStudentId" }
396

_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"}', '', '', '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', '{}', '{"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 (361, NULL, NULL, 'examManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_exam", "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 (362, NULL, '{"before":[{"service":"exam","serviceFunction":"appendExamIdBeforeCreate"}]}', 'examManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "exam", "operation": "insert" }', 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 (363, NULL, NULL, 'examManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (364, NULL, NULL, 'examManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "exam", "operation": "jhDelete" }', 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 (365, NULL, NULL, 'studentResultListByExam', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student_exam_result_overall", "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 (366, NULL, NULL, 'studentResultListByExam', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "insert" }', 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 (367, NULL, NULL, 'studentResultListByExam', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhUpdate" }', 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 (368, NULL, NULL, 'studentResultListByExam', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhDelete" }', 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 (369, NULL, NULL, 'studentResultListByExam', 'getExamInfo', '✅查询列表', 'sql', '{}', '{ "table": "view01_exam", "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 (370, NULL, NULL, 'studentResultListByExam', 'selectOverallResultList', '✅查询列表', 'sql', '{}', '{ "table": "student_exam_result_overall", "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, 'studentResultListByExam', 'selectSubjectResultList', '✅查询列表', 'sql', '{}', '{ "table": "student_exam_result_subject", "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 (374, NULL, NULL, 'examManagement', 'markExamResultAsUploaded', '✅考试-标记成绩已录入', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (375, NULL, NULL, 'studentResultListByExam', 'deleteOverallResult', '✅成绩-删除总成绩', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhDelete" }', 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 (376, NULL, NULL, 'studentResultListByExam', 'deleteItemSubjectResult', '✅成绩-删除科目成绩', 'sql', '{}', '{ "table": "student_exam_result_subject", "operation": "jhDelete" }', 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 (377, NULL, NULL, 'examManagement', 'markExamResultAsCancelled', '✅考试-标记成绩未录入', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (378, NULL, '{"after":[{"service":"exam","serviceFunction":"confirmResultChecked"}]}', 'examManagement', 'markExamResultAsChecked', '✅考试-确认成绩无误', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (379, NULL, '{"after":[{"service":"exam","serviceFunction":"uncheckResult"}]}', 'examManagement', 'markExamResultAsUnchecked', '✅考试-取消确认成绩无误', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (380, NULL, NULL, 'studentResultListByExam', 'uploadResultList', '✅成绩-上传成绩', 'service', '{}', '{ "service": "exam", "serviceFunction": "batchInsertExamResult" }', 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 (381, NULL, NULL, 'examManagement', 'markExamStatusAsDeleted', '✅考试-删除考试', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (382, NULL, NULL, 'studentResultListByExam', 'getClassListByExam', '✅考试-获取考试中的班级列表', 'service', '{}', '{ "service": "exam", "serviceFunction": "getClassListByExam" }', 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 (383, NULL, NULL, 'examManagement', 'generateNoticeForExam', '✅考试-发送通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "generateNoticeForExam" }', 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 (384, NULL, NULL, 'examManagement', 'updateNoticeTemplateForExam', '✅考试-更新通知模板', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (385, NULL, NULL, 'examManagement', 'getNoticeTemplateList', '✅考试-获取成绩通知消息模板', 'sql', '{}', '{ "table": "notice_template", "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 (386, NULL, NULL, 'studentManagement', 'selectItemList', '✅查询学生列表', 'sql', '{}', '{ "table": "view01_student", "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 (387, NULL, NULL, 'studentResultListByStudent', 'selectItemList', NULL, 'sql', '{}', '{ "table": "student_exam_result_overall", "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 (388, '', NULL, 'studentResultListByStudent', 'getStudentInfo', NULL, 'sql', '{}', '{ "table": "view01_student", "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 (389, NULL, NULL, 'studentResultListByStudent', 'selectOverallResultList', NULL, 'sql', '{}', '{ "table": "view01_student_exam_result_overall", "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 (390, NULL, NULL, 'studentResultListByStudent', 'selectSubjectResultList', NULL, 'sql', '{}', '{ "table": "view01_student_exam_result_subject", "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 (391, NULL, NULL, 'studentResultListByStudent', 'deleteOverallResult', NULL, 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhDelete" }', 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 (392, NULL, NULL, 'studentResultListByStudent', 'deleteItemSubjectResult', NULL, 'sql', '{}', '{ "table": "student_exam_result_subject", "operation": "jhDelete" }', 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 (395, NULL, NULL, 'studentResultListByExam', 'checkWrongStudentId', '✅成绩-上传成绩前检查考号', 'service', '{}', '{ "service": "exam", "serviceFunction": "checkWrongStudentId" }', 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 (396, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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 = 397 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"} |
| 361 | ✅查询列表 | examManagement | selectItemList | sql |  | { "table": "view01_exam", "operation": "select" } |
| 362 | ✅添加 | examManagement | insertItem | sql | {"before":[{"service":"exam","serviceFunction":"appendExamIdBeforeCreate"}]} | { "table": "exam", "operation": "insert" } |
| 363 | ✅更新 | examManagement | updateItem | sql |  | { "table": "exam", "operation": "jhUpdate" } |
| 364 | ✅删除 | examManagement | deleteItem | sql |  | { "table": "exam", "operation": "jhDelete" } |
| 365 | ✅查询列表 | studentResultListByExam | selectItemList | sql |  | { "table": "student_exam_result_overall", "operation": "select" } |
| 366 | ✅添加 | studentResultListByExam | insertItem | sql |  | { "table": "student_exam_result_overall", "operation": "insert" } |
| 367 | ✅更新 | studentResultListByExam | updateItem | sql |  | { "table": "student_exam_result_overall", "operation": "jhUpdate" } |
| 368 | ✅删除 | studentResultListByExam | deleteItem | sql |  | { "table": "student_exam_result_overall", "operation": "jhDelete" } |
| 369 | ✅查询列表 | studentResultListByExam | getExamInfo | sql |  | { "table": "view01_exam", "operation": "select" } |
| 370 | ✅查询列表 | studentResultListByExam | selectOverallResultList | sql |  | { "table": "student_exam_result_overall", "operation": "select" } |
| 371 | ✅查询列表 | studentResultListByExam | selectSubjectResultList | sql |  | { "table": "student_exam_result_subject", "operation": "select" } |
| 374 | ✅考试-标记成绩已录入 | examManagement | markExamResultAsUploaded | sql |  | { "table": "exam", "operation": "jhUpdate" } |
| 375 | ✅成绩-删除总成绩 | studentResultListByExam | deleteOverallResult | sql |  | { "table": "student_exam_result_overall", "operation": "jhDelete" } |
| 376 | ✅成绩-删除科目成绩 | studentResultListByExam | deleteItemSubjectResult | sql |  | { "table": "student_exam_result_subject", "operation": "jhDelete" } |
| 377 | ✅考试-标记成绩未录入 | examManagement | markExamResultAsCancelled | sql |  | { "table": "exam", "operation": "jhUpdate" } |
| 378 | ✅考试-确认成绩无误 | examManagement | markExamResultAsChecked | sql | {"after":[{"service":"exam","serviceFunction":"confirmResultChecked"}]} | { "table": "exam", "operation": "jhUpdate" } |
| 379 | ✅考试-取消确认成绩无误 | examManagement | markExamResultAsUnchecked | sql | {"after":[{"service":"exam","serviceFunction":"uncheckResult"}]} | { "table": "exam", "operation": "jhUpdate" } |
| 380 | ✅成绩-上传成绩 | studentResultListByExam | uploadResultList | service |  | { "service": "exam", "serviceFunction": "batchInsertExamResult" } |
| 381 | ✅考试-删除考试 | examManagement | markExamStatusAsDeleted | sql |  | { "table": "exam", "operation": "jhUpdate" } |
| 382 | ✅考试-获取考试中的班级列表 | studentResultListByExam | getClassListByExam | service |  | { "service": "exam", "serviceFunction": "getClassListByExam" } |
| 383 | ✅考试-发送通知 | examManagement | generateNoticeForExam | service |  | { "service": "notice", "serviceFunction": "generateNoticeForExam" } |
| 384 | ✅考试-更新通知模板 | examManagement | updateNoticeTemplateForExam | sql |  | { "table": "exam", "operation": "jhUpdate" } |
| 385 | ✅考试-获取成绩通知消息模板 | examManagement | getNoticeTemplateList | sql |  | { "table": "notice_template", "operation": "select" } |
| 386 | ✅查询学生列表 | studentManagement | selectItemList | sql |  | { "table": "view01_student", "operation": "select" } |
| 387 |  | studentResultListByStudent | selectItemList | sql |  | { "table": "student_exam_result_overall", "operation": "select" } |
| 388 |  | studentResultListByStudent | getStudentInfo | sql |  | { "table": "view01_student", "operation": "select" } |
| 389 |  | studentResultListByStudent | selectOverallResultList | sql |  | { "table": "view01_student_exam_result_overall", "operation": "select" } |
| 390 |  | studentResultListByStudent | selectSubjectResultList | sql |  | { "table": "view01_student_exam_result_subject", "operation": "select" } |
| 391 |  | studentResultListByStudent | deleteOverallResult | sql |  | { "table": "student_exam_result_overall", "operation": "jhDelete" } |
| 392 |  | studentResultListByStudent | deleteItemSubjectResult | sql |  | { "table": "student_exam_result_subject", "operation": "jhDelete" } |
| 395 | ✅成绩-上传成绩前检查考号 | studentResultListByExam | checkWrongStudentId | service |  | { "service": "exam", "serviceFunction": "checkWrongStudentId" } |
| 396 |  |  |  |  |  |  |
## _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"}', '', '', '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', '{}', '{"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 (361, NULL, NULL, 'examManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_exam", "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 (362, NULL, '{"before":[{"service":"exam","serviceFunction":"appendExamIdBeforeCreate"}]}', 'examManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "exam", "operation": "insert" }', 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 (363, NULL, NULL, 'examManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (364, NULL, NULL, 'examManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "exam", "operation": "jhDelete" }', 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 (365, NULL, NULL, 'studentResultListByExam', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "student_exam_result_overall", "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 (366, NULL, NULL, 'studentResultListByExam', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "insert" }', 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 (367, NULL, NULL, 'studentResultListByExam', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhUpdate" }', 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 (368, NULL, NULL, 'studentResultListByExam', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhDelete" }', 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 (369, NULL, NULL, 'studentResultListByExam', 'getExamInfo', '✅查询列表', 'sql', '{}', '{ "table": "view01_exam", "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 (370, NULL, NULL, 'studentResultListByExam', 'selectOverallResultList', '✅查询列表', 'sql', '{}', '{ "table": "student_exam_result_overall", "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, 'studentResultListByExam', 'selectSubjectResultList', '✅查询列表', 'sql', '{}', '{ "table": "student_exam_result_subject", "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 (374, NULL, NULL, 'examManagement', 'markExamResultAsUploaded', '✅考试-标记成绩已录入', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (375, NULL, NULL, 'studentResultListByExam', 'deleteOverallResult', '✅成绩-删除总成绩', 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhDelete" }', 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 (376, NULL, NULL, 'studentResultListByExam', 'deleteItemSubjectResult', '✅成绩-删除科目成绩', 'sql', '{}', '{ "table": "student_exam_result_subject", "operation": "jhDelete" }', 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 (377, NULL, NULL, 'examManagement', 'markExamResultAsCancelled', '✅考试-标记成绩未录入', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (378, NULL, '{"after":[{"service":"exam","serviceFunction":"confirmResultChecked"}]}', 'examManagement', 'markExamResultAsChecked', '✅考试-确认成绩无误', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (379, NULL, '{"after":[{"service":"exam","serviceFunction":"uncheckResult"}]}', 'examManagement', 'markExamResultAsUnchecked', '✅考试-取消确认成绩无误', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (380, NULL, NULL, 'studentResultListByExam', 'uploadResultList', '✅成绩-上传成绩', 'service', '{}', '{ "service": "exam", "serviceFunction": "batchInsertExamResult" }', 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 (381, NULL, NULL, 'examManagement', 'markExamStatusAsDeleted', '✅考试-删除考试', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (382, NULL, NULL, 'studentResultListByExam', 'getClassListByExam', '✅考试-获取考试中的班级列表', 'service', '{}', '{ "service": "exam", "serviceFunction": "getClassListByExam" }', 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 (383, NULL, NULL, 'examManagement', 'generateNoticeForExam', '✅考试-发送通知', 'service', '{}', '{ "service": "notice", "serviceFunction": "generateNoticeForExam" }', 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 (384, NULL, NULL, 'examManagement', 'updateNoticeTemplateForExam', '✅考试-更新通知模板', 'sql', '{}', '{ "table": "exam", "operation": "jhUpdate" }', 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 (385, NULL, NULL, 'examManagement', 'getNoticeTemplateList', '✅考试-获取成绩通知消息模板', 'sql', '{}', '{ "table": "notice_template", "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 (386, NULL, NULL, 'studentManagement', 'selectItemList', '✅查询学生列表', 'sql', '{}', '{ "table": "view01_student", "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 (387, NULL, NULL, 'studentResultListByStudent', 'selectItemList', NULL, 'sql', '{}', '{ "table": "student_exam_result_overall", "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 (388, '', NULL, 'studentResultListByStudent', 'getStudentInfo', NULL, 'sql', '{}', '{ "table": "view01_student", "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 (389, NULL, NULL, 'studentResultListByStudent', 'selectOverallResultList', NULL, 'sql', '{}', '{ "table": "view01_student_exam_result_overall", "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 (390, NULL, NULL, 'studentResultListByStudent', 'selectSubjectResultList', NULL, 'sql', '{}', '{ "table": "view01_student_exam_result_subject", "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 (391, NULL, NULL, 'studentResultListByStudent', 'deleteOverallResult', NULL, 'sql', '{}', '{ "table": "student_exam_result_overall", "operation": "jhDelete" }', 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 (392, NULL, NULL, 'studentResultListByStudent', 'deleteItemSubjectResult', NULL, 'sql', '{}', '{ "table": "student_exam_result_subject", "operation": "jhDelete" }', 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 (395, NULL, NULL, 'studentResultListByExam', 'checkWrongStudentId', '✅成绩-上传成绩前检查考号', 'service', '{}', '{ "service": "exam", "serviceFunction": "checkWrongStudentId" }', 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 (396, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
```