接口

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 = 460 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	✅ 文件分片上传-http文件流	allPage	httpUploadByStream	service		{"service": "file", "serviceFunction": "uploadFileChunkByStream"}
260	✅ 文件分片上传-所有分片上传完毕	allPage	uploadFileDone	service		{"service": "file", "serviceFunction": "uploadFileDone"}
425	✅奖学金管理-转出	scholarshipManagement	scholarshipTransfer	sql	{"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}	{ "table": "student_scholarship_record", "operation": "insert" }
426	✅奖学金管理-查询	scholarshipManagement	selectItemList	sql		{ "table": "view01_student_scholarship", "operation": "select" }
427	✅奖学金管理-添加	scholarshipManagement	insertItem	sql	{"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}	{ "table": "student_scholarship_record", "operation": "insert" }
428	✅奖学金管理-查询明细	scholarshipManagement	selectRecordList	sql		{ "table": "view01_student_scholarship_record", "operation": "select" }
429	✅奖学金管理-查询学生数据	scholarshipManagement	selectStudentList	service		{"service": "scholarship", "serviceFunction": "selectStudentList"}
430	✅奖学金管理-学期奖学金余额	scholarshipManagement	semesterAmount	service		{"service": "scholarship", "serviceFunction": "setSemesterAmount"}
431	✅奖学金导入-导入	scholarshipImport	importScholarshipData	service		{"service":"scholarship","serviceFunction":"importScholarshipData"}
432	✅奖学金导入-查询学生信息	scholarshipImport	getStudentData	sql		{ "table": "view00_student_basic_class", "operation": "select" }
435	✅账单批次-查询列表	billBatchManagement	selectItemList	sql		{ "table": "view01_bill_batch", "operation": "select" }
436	✅账单批次-添加	billBatchManagement	insertItem	sql	{"before": [{"service": "billBatch", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []}	{ "table": "bill_batch", "operation": "insert" }
437	✅账单批次-更新	billBatchManagement	updateItem	sql		{ "table": "bill_batch", "operation": "jhUpdate" }
438	✅账单批次-删除	billBatchManagement	deleteItem	sql		{ "table": "bill_batch", "operation": "jhDelete" }
439	✅账单批次-获取学生数据	billBatchManagement	selectStudentList	sql		{ "table": "view00_student_basic_class", "operation": "select" }
440	✅账单批次-生成账单	billBatchManagement	generateBill	service		{"service": "billBatch", "serviceFunction": "generateBill"}
441	✅账单管理-确认	billManagement	confirmItem	service		{"service": "bill", "serviceFunction": "confirmItem"}
442	✅账单管理-查询	billManagement	selectItemList	service		{"service": "bill", "serviceFunction": "selectItemList"}
443	✅账单管理-删除	billManagement	deleteItem	service		{"service": "bill", "serviceFunction": "deleteItem"}
444	✅账单管理-添加	billManagement	insertItem	service		{"service": "bill", "serviceFunction": "addBill"}
445	✅账单管理-查询缴费明细	billManagement	selectPaymentRecordList	sql		{ "table": "payment_record", "operation": "select" }
446	✅账单管理-更新	billManagement	updateItem	sql		{"service": "bill", "serviceFunction": "updateBill"}
447	✅账单管理-查询学生数据	billManagement	selectStudentList	service		{"service": "bill", "serviceFunction": "selectStudentList"}
449	✅缴费信息导入-数据校验	paymentImport	checkImportData	service		{"service": "payment", "serviceFunction": "checkImportData"}
450	✅缴费信息导入-导入	paymentImport	importPaymentData	service		{"service":"payment","serviceFunction":"importPaymentData"}
452	✅账单管理-删除缴费明细	billManagement	deletePaymentRecord	service		{"service": "bill", "serviceFunction": "deletePaymentRecord"}
453	✅账单管理-添加缴费记录	billManagement	addPaymentRecord	service		{"service": "bill", "serviceFunction": "addPaymentRecord"}
454	✅修改明细	scholarshipManagement	updateRecordItem	sql	{"before": [{"service": "scholarship", "serviceFunction": "prepareUpdateRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}	{ "table": "student_scholarship_record", "operation": "jhUpdate" }
455	✅删除明细	scholarshipManagement	deleteRecordItem	sql	{"before": [{"service": "scholarship", "serviceFunction": "prepareDeleteRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}	{ "table": "student_scholarship_record", "operation": "jhDelete" }
456	✅账单批次-结束生成账单	billBatchManagement	endBillGenerate	sql		{ "table": "bill_batch", "operation": "jhUpdate" }
457	✅账单管理-结束当前学年	billManagement	lockCurrentSemester	service		{"service": "bill", "serviceFunction": "lockCurrentSemester"}
458	✅账单管理-编辑缴费状态	billManagement	completedPayment	sql		{ "table": "bill", "operation": "jhUpdate" }
459	✅账单管理-账单批次	billManagement	selectBillBatchList	sql		{ "table": "view01_bill_batch", "operation": "select" }

_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 (259, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (260, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (425, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'scholarshipTransfer', '✅奖学金管理-转出', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (426, NULL, NULL, 'scholarshipManagement', 'selectItemList', '✅奖学金管理-查询', 'sql', '{}', '{ "table": "view01_student_scholarship", "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 (427, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'insertItem', '✅奖学金管理-添加', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (428, NULL, NULL, 'scholarshipManagement', 'selectRecordList', '✅奖学金管理-查询明细', 'sql', '{}', '{ "table": "view01_student_scholarship_record", "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 (429, NULL, NULL, 'scholarshipManagement', 'selectStudentList', '✅奖学金管理-查询学生数据', 'service', '{}', '{"service": "scholarship", "serviceFunction": "selectStudentList"}', 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 (430, NULL, NULL, 'scholarshipManagement', 'semesterAmount', '✅奖学金管理-学期奖学金余额', 'service', '{}', '{"service": "scholarship", "serviceFunction": "setSemesterAmount"}', 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 (431, NULL, NULL, 'scholarshipImport', 'importScholarshipData', '✅奖学金导入-导入', 'service', '{}', '{"service":"scholarship","serviceFunction":"importScholarshipData"}', 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 (432, NULL, NULL, 'scholarshipImport', 'getStudentData', '✅奖学金导入-查询学生信息', 'sql', '{}', '{ "table": "view00_student_basic_class", "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 (435, NULL, NULL, 'billBatchManagement', 'selectItemList', '✅账单批次-查询列表', 'sql', '{}', '{ "table": "view01_bill_batch", "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 (436, NULL, '{"before": [{"service": "billBatch", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []}', 'billBatchManagement', 'insertItem', '✅账单批次-添加', 'sql', '{}', '{ "table": "bill_batch", "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 (437, NULL, NULL, 'billBatchManagement', 'updateItem', '✅账单批次-更新', 'sql', '{}', '{ "table": "bill_batch", "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 (438, NULL, NULL, 'billBatchManagement', 'deleteItem', '✅账单批次-删除', 'sql', '{}', '{ "table": "bill_batch", "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 (439, NULL, NULL, 'billBatchManagement', 'selectStudentList', '✅账单批次-获取学生数据', 'sql', '{}', '{ "table": "view00_student_basic_class", "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 (440, NULL, NULL, 'billBatchManagement', 'generateBill', '✅账单批次-生成账单', 'service', '{}', '{"service": "billBatch", "serviceFunction": "generateBill"}', 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 (441, NULL, NULL, 'billManagement', 'confirmItem', '✅账单管理-确认', 'service', '{}', '{"service": "bill", "serviceFunction": "confirmItem"}', 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 (442, NULL, NULL, 'billManagement', 'selectItemList', '✅账单管理-查询', 'service', '{}', '{"service": "bill", "serviceFunction": "selectItemList"}', 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, 'billManagement', 'deleteItem', '✅账单管理-删除', 'service', '{}', '{"service": "bill", "serviceFunction": "deleteItem"}', 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, '', 'billManagement', 'insertItem', '✅账单管理-添加', 'service', '{}', '{"service": "bill", "serviceFunction": "addBill"}', 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 (445, NULL, NULL, 'billManagement', 'selectPaymentRecordList', '✅账单管理-查询缴费明细', 'sql', '{}', '{ "table": "payment_record", "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 (446, NULL, NULL, 'billManagement', 'updateItem', '✅账单管理-更新', 'sql', '{}', '{"service": "bill", "serviceFunction": "updateBill"}', 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 (447, NULL, NULL, 'billManagement', 'selectStudentList', '✅账单管理-查询学生数据', 'service', '{}', '{"service": "bill", "serviceFunction": "selectStudentList"}', 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 (449, NULL, NULL, 'paymentImport', 'checkImportData', '✅缴费信息导入-数据校验', 'service', '{}', '{"service": "payment", "serviceFunction": "checkImportData"}', 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 (450, NULL, NULL, 'paymentImport', 'importPaymentData', '✅缴费信息导入-导入', 'service', '{}', '{"service":"payment","serviceFunction":"importPaymentData"}', 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 (452, NULL, NULL, 'billManagement', 'deletePaymentRecord', '✅账单管理-删除缴费明细', 'service', '{}', '{"service": "bill", "serviceFunction": "deletePaymentRecord"}', 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 (453, NULL, NULL, 'billManagement', 'addPaymentRecord', '✅账单管理-添加缴费记录', 'service', '{}', '{"service": "bill", "serviceFunction": "addPaymentRecord"}', 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 (454, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "prepareUpdateRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'updateRecordItem', '✅修改明细', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (455, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "prepareDeleteRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'deleteRecordItem', '✅删除明细', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (456, NULL, NULL, 'billBatchManagement', 'endBillGenerate', '✅账单批次-结束生成账单', 'sql', '{}', '{ "table": "bill_batch", "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 (457, NULL, NULL, 'billManagement', 'lockCurrentSemester', '✅账单管理-结束当前学年', 'service', '{}', '{"service": "bill", "serviceFunction": "lockCurrentSemester"}', 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 (458, NULL, NULL, 'billManagement', 'completedPayment', '✅账单管理-编辑缴费状态', 'sql', NULL, '{ "table": "bill", "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 (459, NULL, NULL, 'billManagement', 'selectBillBatchList', '✅账单管理-账单批次', 'sql', NULL, '{ "table": "view01_bill_batch", "operation": "select" }', 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 = 460 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 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service |  | {"service": "file", "serviceFunction": "uploadFileChunkByStream"} |
| 260 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service |  | {"service": "file", "serviceFunction": "uploadFileDone"} |
| 425 | ✅奖学金管理-转出 | scholarshipManagement | scholarshipTransfer | sql | {"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]} | { "table": "student_scholarship_record", "operation": "insert" } |
| 426 | ✅奖学金管理-查询 | scholarshipManagement | selectItemList | sql |  | { "table": "view01_student_scholarship", "operation": "select" } |
| 427 | ✅奖学金管理-添加 | scholarshipManagement | insertItem | sql | {"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]} | { "table": "student_scholarship_record", "operation": "insert" } |
| 428 | ✅奖学金管理-查询明细 | scholarshipManagement | selectRecordList | sql |  | { "table": "view01_student_scholarship_record", "operation": "select" } |
| 429 | ✅奖学金管理-查询学生数据 | scholarshipManagement | selectStudentList | service |  | {"service": "scholarship", "serviceFunction": "selectStudentList"} |
| 430 | ✅奖学金管理-学期奖学金余额 | scholarshipManagement | semesterAmount | service |  | {"service": "scholarship", "serviceFunction": "setSemesterAmount"} |
| 431 | ✅奖学金导入-导入 | scholarshipImport | importScholarshipData | service |  | {"service":"scholarship","serviceFunction":"importScholarshipData"} |
| 432 | ✅奖学金导入-查询学生信息 | scholarshipImport | getStudentData | sql |  | { "table": "view00_student_basic_class", "operation": "select" } |
| 435 | ✅账单批次-查询列表 | billBatchManagement | selectItemList | sql |  | { "table": "view01_bill_batch", "operation": "select" } |
| 436 | ✅账单批次-添加 | billBatchManagement | insertItem | sql | {"before": [{"service": "billBatch", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []} | { "table": "bill_batch", "operation": "insert" } |
| 437 | ✅账单批次-更新 | billBatchManagement | updateItem | sql |  | { "table": "bill_batch", "operation": "jhUpdate" } |
| 438 | ✅账单批次-删除 | billBatchManagement | deleteItem | sql |  | { "table": "bill_batch", "operation": "jhDelete" } |
| 439 | ✅账单批次-获取学生数据 | billBatchManagement | selectStudentList | sql |  | { "table": "view00_student_basic_class", "operation": "select" } |
| 440 | ✅账单批次-生成账单 | billBatchManagement | generateBill | service |  | {"service": "billBatch", "serviceFunction": "generateBill"} |
| 441 | ✅账单管理-确认 | billManagement | confirmItem | service |  | {"service": "bill", "serviceFunction": "confirmItem"} |
| 442 | ✅账单管理-查询 | billManagement | selectItemList | service |  | {"service": "bill", "serviceFunction": "selectItemList"} |
| 443 | ✅账单管理-删除 | billManagement | deleteItem | service |  | {"service": "bill", "serviceFunction": "deleteItem"} |
| 444 | ✅账单管理-添加 | billManagement | insertItem | service |  | {"service": "bill", "serviceFunction": "addBill"} |
| 445 | ✅账单管理-查询缴费明细 | billManagement | selectPaymentRecordList | sql |  | { "table": "payment_record", "operation": "select" } |
| 446 | ✅账单管理-更新 | billManagement | updateItem | sql |  | {"service": "bill", "serviceFunction": "updateBill"} |
| 447 | ✅账单管理-查询学生数据 | billManagement | selectStudentList | service |  | {"service": "bill", "serviceFunction": "selectStudentList"} |
| 449 | ✅缴费信息导入-数据校验 | paymentImport | checkImportData | service |  | {"service": "payment", "serviceFunction": "checkImportData"} |
| 450 | ✅缴费信息导入-导入 | paymentImport | importPaymentData | service |  | {"service":"payment","serviceFunction":"importPaymentData"} |
| 452 | ✅账单管理-删除缴费明细 | billManagement | deletePaymentRecord | service |  | {"service": "bill", "serviceFunction": "deletePaymentRecord"} |
| 453 | ✅账单管理-添加缴费记录 | billManagement | addPaymentRecord | service |  | {"service": "bill", "serviceFunction": "addPaymentRecord"} |
| 454 | ✅修改明细 | scholarshipManagement | updateRecordItem | sql | {"before": [{"service": "scholarship", "serviceFunction": "prepareUpdateRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]} | { "table": "student_scholarship_record", "operation": "jhUpdate" } |
| 455 | ✅删除明细 | scholarshipManagement | deleteRecordItem | sql | {"before": [{"service": "scholarship", "serviceFunction": "prepareDeleteRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]} | { "table": "student_scholarship_record", "operation": "jhDelete" } |
| 456 | ✅账单批次-结束生成账单 | billBatchManagement | endBillGenerate | sql |  | { "table": "bill_batch", "operation": "jhUpdate" } |
| 457 | ✅账单管理-结束当前学年 | billManagement | lockCurrentSemester | service |  | {"service": "bill", "serviceFunction": "lockCurrentSemester"} |
| 458 | ✅账单管理-编辑缴费状态 | billManagement | completedPayment | sql |  | { "table": "bill", "operation": "jhUpdate" } |
| 459 | ✅账单管理-账单批次 | billManagement | selectBillBatchList | sql |  | { "table": "view01_bill_batch", "operation": "select" } |
## _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 (259, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (260, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', NULL, NULL, 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (425, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'scholarshipTransfer', '✅奖学金管理-转出', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (426, NULL, NULL, 'scholarshipManagement', 'selectItemList', '✅奖学金管理-查询', 'sql', '{}', '{ "table": "view01_student_scholarship", "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 (427, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'insertItem', '✅奖学金管理-添加', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (428, NULL, NULL, 'scholarshipManagement', 'selectRecordList', '✅奖学金管理-查询明细', 'sql', '{}', '{ "table": "view01_student_scholarship_record", "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 (429, NULL, NULL, 'scholarshipManagement', 'selectStudentList', '✅奖学金管理-查询学生数据', 'service', '{}', '{"service": "scholarship", "serviceFunction": "selectStudentList"}', 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 (430, NULL, NULL, 'scholarshipManagement', 'semesterAmount', '✅奖学金管理-学期奖学金余额', 'service', '{}', '{"service": "scholarship", "serviceFunction": "setSemesterAmount"}', 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 (431, NULL, NULL, 'scholarshipImport', 'importScholarshipData', '✅奖学金导入-导入', 'service', '{}', '{"service":"scholarship","serviceFunction":"importScholarshipData"}', 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 (432, NULL, NULL, 'scholarshipImport', 'getStudentData', '✅奖学金导入-查询学生信息', 'sql', '{}', '{ "table": "view00_student_basic_class", "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 (435, NULL, NULL, 'billBatchManagement', 'selectItemList', '✅账单批次-查询列表', 'sql', '{}', '{ "table": "view01_bill_batch", "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 (436, NULL, '{"before": [{"service": "billBatch", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []}', 'billBatchManagement', 'insertItem', '✅账单批次-添加', 'sql', '{}', '{ "table": "bill_batch", "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 (437, NULL, NULL, 'billBatchManagement', 'updateItem', '✅账单批次-更新', 'sql', '{}', '{ "table": "bill_batch", "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 (438, NULL, NULL, 'billBatchManagement', 'deleteItem', '✅账单批次-删除', 'sql', '{}', '{ "table": "bill_batch", "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 (439, NULL, NULL, 'billBatchManagement', 'selectStudentList', '✅账单批次-获取学生数据', 'sql', '{}', '{ "table": "view00_student_basic_class", "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 (440, NULL, NULL, 'billBatchManagement', 'generateBill', '✅账单批次-生成账单', 'service', '{}', '{"service": "billBatch", "serviceFunction": "generateBill"}', 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 (441, NULL, NULL, 'billManagement', 'confirmItem', '✅账单管理-确认', 'service', '{}', '{"service": "bill", "serviceFunction": "confirmItem"}', 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 (442, NULL, NULL, 'billManagement', 'selectItemList', '✅账单管理-查询', 'service', '{}', '{"service": "bill", "serviceFunction": "selectItemList"}', 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, 'billManagement', 'deleteItem', '✅账单管理-删除', 'service', '{}', '{"service": "bill", "serviceFunction": "deleteItem"}', 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, '', 'billManagement', 'insertItem', '✅账单管理-添加', 'service', '{}', '{"service": "bill", "serviceFunction": "addBill"}', 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 (445, NULL, NULL, 'billManagement', 'selectPaymentRecordList', '✅账单管理-查询缴费明细', 'sql', '{}', '{ "table": "payment_record", "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 (446, NULL, NULL, 'billManagement', 'updateItem', '✅账单管理-更新', 'sql', '{}', '{"service": "bill", "serviceFunction": "updateBill"}', 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 (447, NULL, NULL, 'billManagement', 'selectStudentList', '✅账单管理-查询学生数据', 'service', '{}', '{"service": "bill", "serviceFunction": "selectStudentList"}', 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 (449, NULL, NULL, 'paymentImport', 'checkImportData', '✅缴费信息导入-数据校验', 'service', '{}', '{"service": "payment", "serviceFunction": "checkImportData"}', 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 (450, NULL, NULL, 'paymentImport', 'importPaymentData', '✅缴费信息导入-导入', 'service', '{}', '{"service":"payment","serviceFunction":"importPaymentData"}', 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 (452, NULL, NULL, 'billManagement', 'deletePaymentRecord', '✅账单管理-删除缴费明细', 'service', '{}', '{"service": "bill", "serviceFunction": "deletePaymentRecord"}', 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 (453, NULL, NULL, 'billManagement', 'addPaymentRecord', '✅账单管理-添加缴费记录', 'service', '{}', '{"service": "bill", "serviceFunction": "addPaymentRecord"}', 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 (454, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "prepareUpdateRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'updateRecordItem', '✅修改明细', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (455, NULL, '{"before": [{"service": "scholarship", "serviceFunction": "prepareDeleteRecordValidate"}], "after": [{"service": "scholarship", "serviceFunction": "updateScholarship"}]}', 'scholarshipManagement', 'deleteRecordItem', '✅删除明细', 'sql', '{}', '{ "table": "student_scholarship_record", "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 (456, NULL, NULL, 'billBatchManagement', 'endBillGenerate', '✅账单批次-结束生成账单', 'sql', '{}', '{ "table": "bill_batch", "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 (457, NULL, NULL, 'billManagement', 'lockCurrentSemester', '✅账单管理-结束当前学年', 'service', '{}', '{"service": "bill", "serviceFunction": "lockCurrentSemester"}', 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 (458, NULL, NULL, 'billManagement', 'completedPayment', '✅账单管理-编辑缴费状态', 'sql', NULL, '{ "table": "bill", "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 (459, NULL, NULL, 'billManagement', 'selectBillBatchList', '✅账单管理-账单批次', 'sql', NULL, '{ "table": "view01_bill_batch", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
```