接口

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 = 416 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" }
354	✅异常日志记录	allPage	htmlErrorLogRecord	service		{"service": "error", "serviceFunction": "htmlErrorLogRecord"}
357	✅获取班级列表	allPage	selectClassList	sql		{ "table": "view01_class", "operation": "select" }
363	✅查询列表	arrangeTaskManagement	selectItemList	sql		{ "table": "arrange_task", "operation": "select" }
364	✅添加	arrangeTaskManagement	insertItem	sql		{ "table": "arrange_task", "operation": "insert" }
365	✅更新	arrangeTaskManagement	updateItem	sql	{"after": [{"service": "timetable", "serviceFunction": "afterUpdateArrangeTask"}]}	{ "table": "arrange_task", "operation": "jhUpdate" }
366	✅删除	arrangeTaskManagement	deleteItem	sql	{"after": [{"service": "timetable", "serviceFunction": "afterDeleteArrangeTask"}]}	{ "table": "arrange_task", "operation": "jhDelete" }
367	✅查询列表	teachingPlanManagement	selectItemList	sql		{ "table": "teaching_plan", "operation": "select" }
368	✅添加	teachingPlanManagement	insertItem	service		{"service": "timetablePlan", "serviceFunction": "insertPlanItem"}
369	✅更新	teachingPlanManagement	updateItem	service		{"service": "timetablePlan", "serviceFunction": "updatePlanItem"}
370	✅删除	teachingPlanManagement	deleteItem	sql		{ "table": "teaching_plan", "operation": "jhDelete" }
371	✅查询列表	timetableManagement	selectItemList	sql		{ "table": "view02_timetable", "operation": "select" }
372	✅添加	timetableManagement	insertItem	sql		{ "table": "timetable", "operation": "insert" }
373	✅更新	timetableManagement	updateItem	sql		{ "table": "timetable", "operation": "jhUpdate" }
374	✅删除	timetableManagement	deleteItem	sql		{ "table": "timetable", "operation": "jhDelete" }
375	✅教学计划-查询老师列表	teachingPlanManagement	selectTeacherList	sql		{"table":"view01_employeeld","operation":"select"}
376	✅课表-更新课表	timetableManagement	upsertTimetableItem	service		{"service": "timetable", "serviceFunction": "upsertTimetableItem"}
377	✅查询列表	mergeTimetableManagement	selectItemList	sql		{ "table": "timetable", "operation": "select" }
378	✅添加	mergeTimetableManagement	insertItem	sql		{ "table": "timetable", "operation": "insert" }
379	✅更新	mergeTimetableManagement	updateItem	sql		{ "table": "timetable", "operation": "jhUpdate" }
380	✅删除	mergeTimetableManagement	deleteItem	sql		{ "table": "timetable", "operation": "jhDelete" }
381	✅自动排课	timetableManagement	autoArrangeTimetable	service		{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}
382	✅查询列表	semesterArchive	semesterArchive	service		{"service": "semester", "serviceFunction": "semesterArchive"}
383	✅查询-查询列表	constantManagement	selectItemList	sql		{"table": "_constant", "operation": "select"}
384	✅查询-添加成员	constantManagement	insertItem	sql		{"table": "_constant", "operation": "insert"}
385	✅查询-更新成员	constantManagement	updateItem	sql		{"table": "_constant", "operation": "jhUpdate"}
386	✅查询-删除信息	constantManagement	deleteItem	sql		{"table": "_constant", "operation": "jhDelete"}
387	✅查询-用户教师列表	constantManagement	getEmployeeList	sql		{"table":"view01_employeeld","operation":"select"}
388	✅老师排课表-查询老师列表	teacherTimetable	selectTeacherList	sql		{"table":"view01_employeeld","operation":"select"}
389	✅老师排课表-查询老师排课表	teacherTimetable	selectList	sql		{ "table": "timetable", "operation": "select" }
390	✅查询列表	teacherTimetable	selectItemList	sql		{ "table": "view02_timetable", "operation": "select" }
391	✅添加	teacherTimetable	insertItem	sql		{ "table": "class_timetable", "operation": "insert" }
392	✅更新	teacherTimetable	updateItem	sql		{ "table": "class_timetable", "operation": "jhUpdate" }
393	✅删除	teacherTimetable	deleteItem	sql		{ "table": "class_timetable", "operation": "jhDelete" }
394	✅	teacherTimetableList	getTeacherTimetable	sql		{ "table": "timetable", "operation": "select" }
395		timetableManagement	checkReplaceItem	service		{"service": "timetable", "serviceFunction": "getSectionReplaceable"}
396	✅查询列表	exclusionRuleManagement	selectItemList	sql	{}	{"table":"exclusion_rule","operation":"select"}
397	✅添加	exclusionRuleManagement	insertItem	sql	{}	{"table":"exclusion_rule","operation":"jhInsert"}
398	✅更新	exclusionRuleManagement	updateItem	sql	{}	{"table":"exclusion_rule","operation":"jhUpdate"}
399	✅删除	exclusionRuleManagement	deleteItem	sql	{}	{"table":"exclusion_rule","operation":"jhDelete"}
400	✅查询列表	exclusionRuleManagement	selectRecordHistory	sql		{ "table": "_record_history", "operation": "select" }
401	✅查询排课任务详情	exclusionRuleManagement	selectTaskData	sql	{}	{"table":"arrange_task","operation":"select"}
402	✅查询教师	exclusionRuleManagement	selectTeacherList	sql	{}	{"table":"view01_employeeld","operation":"select"}
403	✅查询教师	exclusionRuleManagement	selectClassList	sql	{}	{"table":"view01_class","operation":"select"}
404	✅自动排课	arrangeTaskManagement	autoArrangeTimetable	service		{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}
405	✅自动排课	arrangeTaskManagement	selectClassList	sql		{"table":"view01_class","operation":"select"}
406	✅批量保存	teachingPlanManagement	batchSaveTeachingPlan	service		{"service": "timetable", "serviceFunction": "batchSaveTeachingPlan"}
407	✅查询教师	arrangeTaskManagement	selectTeacherList	sql	{}	{"table":"view01_employeeld","operation":"select"}
409	✅批量保存	teachingArrangement	batchSaveTeachingPlan	service		{"service": "timetable", "serviceFunction": "batchSaveTeacherArrangement"}
410	✅查询列表	teachingArrangement	selectItemList	sql		{ "table": "teaching_plan", "operation": "select" }
411	✅教学计划-查询老师列表	teachingArrangement	selectTeacherList	sql		{"table":"view01_employeeld","operation":"select"}
412	✅老师排课表-查询老师列表	teacherTimetable	getTaskInfo	sql		{"table":"arrange_task","operation":"select"}
413	✅查询列表	arrangeTaskManagement	selectPlanTeacherList	sql		{ "table": "teaching_plan", "operation": "select" }
414	✅查询列表	exclusionRuleManagement	selectPlanTeacherList	sql		{ "table": "teaching_plan", "operation": "select" }
415	覆盖保存	teachingPlanManagement	batchInsertItem	service		{"service": "timetablePlan", "serviceFunction": "batchInsertItem"}

_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 (354, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', 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 (357, NULL, NULL, 'allPage', 'selectClassList', '✅获取班级列表', 'sql', '{}', '{ "table": "view01_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 (363, NULL, NULL, 'arrangeTaskManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "arrange_task", "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 (364, NULL, NULL, 'arrangeTaskManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "arrange_task", "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 (365, NULL, '{"after": [{"service": "timetable", "serviceFunction": "afterUpdateArrangeTask"}]}', 'arrangeTaskManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "arrange_task", "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 (366, NULL, '{"after": [{"service": "timetable", "serviceFunction": "afterDeleteArrangeTask"}]}', 'arrangeTaskManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "arrange_task", "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 (367, NULL, NULL, 'teachingPlanManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (368, NULL, NULL, 'teachingPlanManagement', 'insertItem', '✅添加', 'service', '{}', '{"service": "timetablePlan", "serviceFunction": "insertPlanItem"}', 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, 'teachingPlanManagement', 'updateItem', '✅更新', 'service', '{}', '{"service": "timetablePlan", "serviceFunction": "updatePlanItem"}', 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, 'teachingPlanManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "teaching_plan", "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 (371, NULL, NULL, 'timetableManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view02_timetable", "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 (372, NULL, NULL, 'timetableManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "timetable", "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 (373, NULL, NULL, 'timetableManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "timetable", "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 (374, NULL, NULL, 'timetableManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "timetable", "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 (375, NULL, NULL, 'teachingPlanManagement', 'selectTeacherList', '✅教学计划-查询老师列表', 'sql', '{}', '{"table":"view01_employeeld","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 (376, NULL, NULL, 'timetableManagement', 'upsertTimetableItem', '✅课表-更新课表', 'service', '{}', '{"service": "timetable", "serviceFunction": "upsertTimetableItem"}', 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, 'mergeTimetableManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "timetable", "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 (378, NULL, NULL, 'mergeTimetableManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "timetable", "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 (379, NULL, NULL, 'mergeTimetableManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "timetable", "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, 'mergeTimetableManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "timetable", "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 (381, NULL, NULL, 'timetableManagement', 'autoArrangeTimetable', '✅自动排课', 'service', NULL, '{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}', 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, 'semesterArchive', 'semesterArchive', '✅查询列表', 'service', NULL, '{"service": "semester", "serviceFunction": "semesterArchive"}', 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, 'constantManagement', 'selectItemList', '✅查询-查询列表', 'sql', '{}', '{"table": "_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 (384, NULL, NULL, 'constantManagement', 'insertItem', '✅查询-添加成员', 'sql', '{}', '{"table": "_constant", "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 (385, NULL, NULL, 'constantManagement', 'updateItem', '✅查询-更新成员', 'sql', '{}', '{"table": "_constant", "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 (386, NULL, NULL, 'constantManagement', 'deleteItem', '✅查询-删除信息', 'sql', '{}', '{"table": "_constant", "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 (387, NULL, NULL, 'constantManagement', 'getEmployeeList', '✅查询-用户教师列表', 'sql', NULL, '{"table":"view01_employeeld","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, NULL, 'teacherTimetable', 'selectTeacherList', '✅老师排课表-查询老师列表', 'sql', '{}', '{"table":"view01_employeeld","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, 'teacherTimetable', 'selectList', '✅老师排课表-查询老师排课表', 'sql', '{}', '{ "table": "timetable", "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, 'teacherTimetable', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view02_timetable", "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, 'teacherTimetable', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "class_timetable", "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 (392, NULL, NULL, 'teacherTimetable', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "class_timetable", "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 (393, NULL, NULL, 'teacherTimetable', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "class_timetable", "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 (394, NULL, NULL, 'teacherTimetableList', 'getTeacherTimetable', '✅', 'sql', NULL, '{ "table": "timetable", "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 (395, NULL, NULL, 'timetableManagement', 'checkReplaceItem', NULL, 'service', NULL, '{"service": "timetable", "serviceFunction": "getSectionReplaceable"}', 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, '{}', 'exclusionRuleManagement', 'selectItemList', '✅查询列表', 'sql', NULL, '{"table":"exclusion_rule","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 (397, NULL, '{}', 'exclusionRuleManagement', 'insertItem', '✅添加', 'sql', NULL, '{"table":"exclusion_rule","operation":"jhInsert"}', 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 (398, NULL, '{}', 'exclusionRuleManagement', 'updateItem', '✅更新', 'sql', NULL, '{"table":"exclusion_rule","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 (399, NULL, '{}', 'exclusionRuleManagement', 'deleteItem', '✅删除', 'sql', NULL, '{"table":"exclusion_rule","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 (400, NULL, NULL, 'exclusionRuleManagement', 'selectRecordHistory', '✅查询列表', 'sql', '{}', '{ "table": "_record_history", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (401, NULL, '{}', 'exclusionRuleManagement', 'selectTaskData', '✅查询排课任务详情', 'sql', NULL, '{"table":"arrange_task","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 (402, NULL, '{}', 'exclusionRuleManagement', 'selectTeacherList', '✅查询教师', 'sql', NULL, '{"table":"view01_employeeld","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 (403, NULL, '{}', 'exclusionRuleManagement', 'selectClassList', '✅查询教师', 'sql', NULL, '{"table":"view01_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 (404, NULL, NULL, 'arrangeTaskManagement', 'autoArrangeTimetable', '✅自动排课', 'service', '{}', '{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}', 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 (405, NULL, NULL, 'arrangeTaskManagement', 'selectClassList', '✅自动排课', 'sql', NULL, '{"table":"view01_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 (406, NULL, NULL, 'teachingPlanManagement', 'batchSaveTeachingPlan', '✅批量保存', 'service', NULL, '{"service": "timetable", "serviceFunction": "batchSaveTeachingPlan"}', 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 (407, NULL, '{}', 'arrangeTaskManagement', 'selectTeacherList', '✅查询教师', 'sql', NULL, '{"table":"view01_employeeld","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 (409, NULL, NULL, 'teachingArrangement', 'batchSaveTeachingPlan', '✅批量保存', 'service', NULL, '{"service": "timetable", "serviceFunction": "batchSaveTeacherArrangement"}', 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 (410, NULL, NULL, 'teachingArrangement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (411, NULL, NULL, 'teachingArrangement', 'selectTeacherList', '✅教学计划-查询老师列表', 'sql', '{}', '{"table":"view01_employeeld","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 (412, NULL, NULL, 'teacherTimetable', 'getTaskInfo', '✅老师排课表-查询老师列表', 'sql', '{}', '{"table":"arrange_task","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 (413, NULL, NULL, 'arrangeTaskManagement', 'selectPlanTeacherList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (414, NULL, NULL, 'exclusionRuleManagement', 'selectPlanTeacherList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (415, NULL, NULL, 'teachingPlanManagement', 'batchInsertItem', '覆盖保存', 'service', NULL, '{"service": "timetablePlan", "serviceFunction": "batchInsertItem"}', 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 = 416 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" } |
| 354 | ✅异常日志记录 | allPage | htmlErrorLogRecord | service |  | {"service": "error", "serviceFunction": "htmlErrorLogRecord"} |
| 357 | ✅获取班级列表 | allPage | selectClassList | sql |  | { "table": "view01_class", "operation": "select" } |
| 363 | ✅查询列表 | arrangeTaskManagement | selectItemList | sql |  | { "table": "arrange_task", "operation": "select" } |
| 364 | ✅添加 | arrangeTaskManagement | insertItem | sql |  | { "table": "arrange_task", "operation": "insert" } |
| 365 | ✅更新 | arrangeTaskManagement | updateItem | sql | {"after": [{"service": "timetable", "serviceFunction": "afterUpdateArrangeTask"}]} | { "table": "arrange_task", "operation": "jhUpdate" } |
| 366 | ✅删除 | arrangeTaskManagement | deleteItem | sql | {"after": [{"service": "timetable", "serviceFunction": "afterDeleteArrangeTask"}]} | { "table": "arrange_task", "operation": "jhDelete" } |
| 367 | ✅查询列表 | teachingPlanManagement | selectItemList | sql |  | { "table": "teaching_plan", "operation": "select" } |
| 368 | ✅添加 | teachingPlanManagement | insertItem | service |  | {"service": "timetablePlan", "serviceFunction": "insertPlanItem"} |
| 369 | ✅更新 | teachingPlanManagement | updateItem | service |  | {"service": "timetablePlan", "serviceFunction": "updatePlanItem"} |
| 370 | ✅删除 | teachingPlanManagement | deleteItem | sql |  | { "table": "teaching_plan", "operation": "jhDelete" } |
| 371 | ✅查询列表 | timetableManagement | selectItemList | sql |  | { "table": "view02_timetable", "operation": "select" } |
| 372 | ✅添加 | timetableManagement | insertItem | sql |  | { "table": "timetable", "operation": "insert" } |
| 373 | ✅更新 | timetableManagement | updateItem | sql |  | { "table": "timetable", "operation": "jhUpdate" } |
| 374 | ✅删除 | timetableManagement | deleteItem | sql |  | { "table": "timetable", "operation": "jhDelete" } |
| 375 | ✅教学计划-查询老师列表 | teachingPlanManagement | selectTeacherList | sql |  | {"table":"view01_employeeld","operation":"select"} |
| 376 | ✅课表-更新课表 | timetableManagement | upsertTimetableItem | service |  | {"service": "timetable", "serviceFunction": "upsertTimetableItem"} |
| 377 | ✅查询列表 | mergeTimetableManagement | selectItemList | sql |  | { "table": "timetable", "operation": "select" } |
| 378 | ✅添加 | mergeTimetableManagement | insertItem | sql |  | { "table": "timetable", "operation": "insert" } |
| 379 | ✅更新 | mergeTimetableManagement | updateItem | sql |  | { "table": "timetable", "operation": "jhUpdate" } |
| 380 | ✅删除 | mergeTimetableManagement | deleteItem | sql |  | { "table": "timetable", "operation": "jhDelete" } |
| 381 | ✅自动排课 | timetableManagement | autoArrangeTimetable | service |  | {"service": "timetable", "serviceFunction": "autoArrangeTimetable"} |
| 382 | ✅查询列表 | semesterArchive | semesterArchive | service |  | {"service": "semester", "serviceFunction": "semesterArchive"} |
| 383 | ✅查询-查询列表 | constantManagement | selectItemList | sql |  | {"table": "_constant", "operation": "select"} |
| 384 | ✅查询-添加成员 | constantManagement | insertItem | sql |  | {"table": "_constant", "operation": "insert"} |
| 385 | ✅查询-更新成员 | constantManagement | updateItem | sql |  | {"table": "_constant", "operation": "jhUpdate"} |
| 386 | ✅查询-删除信息 | constantManagement | deleteItem | sql |  | {"table": "_constant", "operation": "jhDelete"} |
| 387 | ✅查询-用户教师列表 | constantManagement | getEmployeeList | sql |  | {"table":"view01_employeeld","operation":"select"} |
| 388 | ✅老师排课表-查询老师列表 | teacherTimetable | selectTeacherList | sql |  | {"table":"view01_employeeld","operation":"select"} |
| 389 | ✅老师排课表-查询老师排课表 | teacherTimetable | selectList | sql |  | { "table": "timetable", "operation": "select" } |
| 390 | ✅查询列表 | teacherTimetable | selectItemList | sql |  | { "table": "view02_timetable", "operation": "select" } |
| 391 | ✅添加 | teacherTimetable | insertItem | sql |  | { "table": "class_timetable", "operation": "insert" } |
| 392 | ✅更新 | teacherTimetable | updateItem | sql |  | { "table": "class_timetable", "operation": "jhUpdate" } |
| 393 | ✅删除 | teacherTimetable | deleteItem | sql |  | { "table": "class_timetable", "operation": "jhDelete" } |
| 394 | ✅ | teacherTimetableList | getTeacherTimetable | sql |  | { "table": "timetable", "operation": "select" } |
| 395 |  | timetableManagement | checkReplaceItem | service |  | {"service": "timetable", "serviceFunction": "getSectionReplaceable"} |
| 396 | ✅查询列表 | exclusionRuleManagement | selectItemList | sql | {} | {"table":"exclusion_rule","operation":"select"} |
| 397 | ✅添加 | exclusionRuleManagement | insertItem | sql | {} | {"table":"exclusion_rule","operation":"jhInsert"} |
| 398 | ✅更新 | exclusionRuleManagement | updateItem | sql | {} | {"table":"exclusion_rule","operation":"jhUpdate"} |
| 399 | ✅删除 | exclusionRuleManagement | deleteItem | sql | {} | {"table":"exclusion_rule","operation":"jhDelete"} |
| 400 | ✅查询列表 | exclusionRuleManagement | selectRecordHistory | sql |  | { "table": "_record_history", "operation": "select" } |
| 401 | ✅查询排课任务详情 | exclusionRuleManagement | selectTaskData | sql | {} | {"table":"arrange_task","operation":"select"} |
| 402 | ✅查询教师 | exclusionRuleManagement | selectTeacherList | sql | {} | {"table":"view01_employeeld","operation":"select"} |
| 403 | ✅查询教师 | exclusionRuleManagement | selectClassList | sql | {} | {"table":"view01_class","operation":"select"} |
| 404 | ✅自动排课 | arrangeTaskManagement | autoArrangeTimetable | service |  | {"service": "timetable", "serviceFunction": "autoArrangeTimetable"} |
| 405 | ✅自动排课 | arrangeTaskManagement | selectClassList | sql |  | {"table":"view01_class","operation":"select"} |
| 406 | ✅批量保存 | teachingPlanManagement | batchSaveTeachingPlan | service |  | {"service": "timetable", "serviceFunction": "batchSaveTeachingPlan"} |
| 407 | ✅查询教师 | arrangeTaskManagement | selectTeacherList | sql | {} | {"table":"view01_employeeld","operation":"select"} |
| 409 | ✅批量保存 | teachingArrangement | batchSaveTeachingPlan | service |  | {"service": "timetable", "serviceFunction": "batchSaveTeacherArrangement"} |
| 410 | ✅查询列表 | teachingArrangement | selectItemList | sql |  | { "table": "teaching_plan", "operation": "select" } |
| 411 | ✅教学计划-查询老师列表 | teachingArrangement | selectTeacherList | sql |  | {"table":"view01_employeeld","operation":"select"} |
| 412 | ✅老师排课表-查询老师列表 | teacherTimetable | getTaskInfo | sql |  | {"table":"arrange_task","operation":"select"} |
| 413 | ✅查询列表 | arrangeTaskManagement | selectPlanTeacherList | sql |  | { "table": "teaching_plan", "operation": "select" } |
| 414 | ✅查询列表 | exclusionRuleManagement | selectPlanTeacherList | sql |  | { "table": "teaching_plan", "operation": "select" } |
| 415 | 覆盖保存 | teachingPlanManagement | batchInsertItem | service |  | {"service": "timetablePlan", "serviceFunction": "batchInsertItem"} |
## _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 (354, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', 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 (357, NULL, NULL, 'allPage', 'selectClassList', '✅获取班级列表', 'sql', '{}', '{ "table": "view01_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 (363, NULL, NULL, 'arrangeTaskManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "arrange_task", "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 (364, NULL, NULL, 'arrangeTaskManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "arrange_task", "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 (365, NULL, '{"after": [{"service": "timetable", "serviceFunction": "afterUpdateArrangeTask"}]}', 'arrangeTaskManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "arrange_task", "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 (366, NULL, '{"after": [{"service": "timetable", "serviceFunction": "afterDeleteArrangeTask"}]}', 'arrangeTaskManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "arrange_task", "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 (367, NULL, NULL, 'teachingPlanManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (368, NULL, NULL, 'teachingPlanManagement', 'insertItem', '✅添加', 'service', '{}', '{"service": "timetablePlan", "serviceFunction": "insertPlanItem"}', 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, 'teachingPlanManagement', 'updateItem', '✅更新', 'service', '{}', '{"service": "timetablePlan", "serviceFunction": "updatePlanItem"}', 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, 'teachingPlanManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "teaching_plan", "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 (371, NULL, NULL, 'timetableManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view02_timetable", "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 (372, NULL, NULL, 'timetableManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "timetable", "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 (373, NULL, NULL, 'timetableManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "timetable", "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 (374, NULL, NULL, 'timetableManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "timetable", "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 (375, NULL, NULL, 'teachingPlanManagement', 'selectTeacherList', '✅教学计划-查询老师列表', 'sql', '{}', '{"table":"view01_employeeld","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 (376, NULL, NULL, 'timetableManagement', 'upsertTimetableItem', '✅课表-更新课表', 'service', '{}', '{"service": "timetable", "serviceFunction": "upsertTimetableItem"}', 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, 'mergeTimetableManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "timetable", "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 (378, NULL, NULL, 'mergeTimetableManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "timetable", "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 (379, NULL, NULL, 'mergeTimetableManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "timetable", "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, 'mergeTimetableManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "timetable", "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 (381, NULL, NULL, 'timetableManagement', 'autoArrangeTimetable', '✅自动排课', 'service', NULL, '{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}', 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, 'semesterArchive', 'semesterArchive', '✅查询列表', 'service', NULL, '{"service": "semester", "serviceFunction": "semesterArchive"}', 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, 'constantManagement', 'selectItemList', '✅查询-查询列表', 'sql', '{}', '{"table": "_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 (384, NULL, NULL, 'constantManagement', 'insertItem', '✅查询-添加成员', 'sql', '{}', '{"table": "_constant", "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 (385, NULL, NULL, 'constantManagement', 'updateItem', '✅查询-更新成员', 'sql', '{}', '{"table": "_constant", "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 (386, NULL, NULL, 'constantManagement', 'deleteItem', '✅查询-删除信息', 'sql', '{}', '{"table": "_constant", "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 (387, NULL, NULL, 'constantManagement', 'getEmployeeList', '✅查询-用户教师列表', 'sql', NULL, '{"table":"view01_employeeld","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, NULL, 'teacherTimetable', 'selectTeacherList', '✅老师排课表-查询老师列表', 'sql', '{}', '{"table":"view01_employeeld","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, 'teacherTimetable', 'selectList', '✅老师排课表-查询老师排课表', 'sql', '{}', '{ "table": "timetable", "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, 'teacherTimetable', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view02_timetable", "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, 'teacherTimetable', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "class_timetable", "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 (392, NULL, NULL, 'teacherTimetable', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "class_timetable", "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 (393, NULL, NULL, 'teacherTimetable', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "class_timetable", "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 (394, NULL, NULL, 'teacherTimetableList', 'getTeacherTimetable', '✅', 'sql', NULL, '{ "table": "timetable", "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 (395, NULL, NULL, 'timetableManagement', 'checkReplaceItem', NULL, 'service', NULL, '{"service": "timetable", "serviceFunction": "getSectionReplaceable"}', 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, '{}', 'exclusionRuleManagement', 'selectItemList', '✅查询列表', 'sql', NULL, '{"table":"exclusion_rule","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 (397, NULL, '{}', 'exclusionRuleManagement', 'insertItem', '✅添加', 'sql', NULL, '{"table":"exclusion_rule","operation":"jhInsert"}', 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 (398, NULL, '{}', 'exclusionRuleManagement', 'updateItem', '✅更新', 'sql', NULL, '{"table":"exclusion_rule","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 (399, NULL, '{}', 'exclusionRuleManagement', 'deleteItem', '✅删除', 'sql', NULL, '{"table":"exclusion_rule","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 (400, NULL, NULL, 'exclusionRuleManagement', 'selectRecordHistory', '✅查询列表', 'sql', '{}', '{ "table": "_record_history", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (401, NULL, '{}', 'exclusionRuleManagement', 'selectTaskData', '✅查询排课任务详情', 'sql', NULL, '{"table":"arrange_task","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 (402, NULL, '{}', 'exclusionRuleManagement', 'selectTeacherList', '✅查询教师', 'sql', NULL, '{"table":"view01_employeeld","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 (403, NULL, '{}', 'exclusionRuleManagement', 'selectClassList', '✅查询教师', 'sql', NULL, '{"table":"view01_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 (404, NULL, NULL, 'arrangeTaskManagement', 'autoArrangeTimetable', '✅自动排课', 'service', '{}', '{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}', 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 (405, NULL, NULL, 'arrangeTaskManagement', 'selectClassList', '✅自动排课', 'sql', NULL, '{"table":"view01_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 (406, NULL, NULL, 'teachingPlanManagement', 'batchSaveTeachingPlan', '✅批量保存', 'service', NULL, '{"service": "timetable", "serviceFunction": "batchSaveTeachingPlan"}', 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 (407, NULL, '{}', 'arrangeTaskManagement', 'selectTeacherList', '✅查询教师', 'sql', NULL, '{"table":"view01_employeeld","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 (409, NULL, NULL, 'teachingArrangement', 'batchSaveTeachingPlan', '✅批量保存', 'service', NULL, '{"service": "timetable", "serviceFunction": "batchSaveTeacherArrangement"}', 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 (410, NULL, NULL, 'teachingArrangement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (411, NULL, NULL, 'teachingArrangement', 'selectTeacherList', '✅教学计划-查询老师列表', 'sql', '{}', '{"table":"view01_employeeld","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 (412, NULL, NULL, 'teacherTimetable', 'getTaskInfo', '✅老师排课表-查询老师列表', 'sql', '{}', '{"table":"arrange_task","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 (413, NULL, NULL, 'arrangeTaskManagement', 'selectPlanTeacherList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (414, NULL, NULL, 'exclusionRuleManagement', 'selectPlanTeacherList', '✅查询列表', 'sql', '{}', '{ "table": "teaching_plan", "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 (415, NULL, NULL, 'teachingPlanManagement', 'batchInsertItem', '覆盖保存', 'service', NULL, '{"service": "timetablePlan", "serviceFunction": "batchInsertItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);
```