页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL,
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `sort` varchar(255)  DEFAULT NULL,
  `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 = 18 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	11	undefined

登陆

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	231	insert

排课任务

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
排课任务	arrangeTaskManagement	showInMenu	null	1	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	arrangeTaskManagement	selectItemList	null	sql	{ "table": "arrange_task", "operation": "select" }	{}	363	insert
✅添加	arrangeTaskManagement	insertItem	null	sql	{ "table": "arrange_task", "operation": "insert" }	{}	364	insert
✅更新	arrangeTaskManagement	updateItem	{ "after": [ { "service": "timetable", "serviceFunction": "afterUpdateArrangeTask" } ] }	sql	{ "table": "arrange_task", "operation": "jhUpdate" }	{}	365	insert
✅删除	arrangeTaskManagement	deleteItem	{ "after": [ { "service": "timetable", "serviceFunction": "afterDeleteArrangeTask" } ] }	sql	{ "table": "arrange_task", "operation": "jhDelete" }	{}	366	insert
✅自动排课	arrangeTaskManagement	autoArrangeTimetable	null	service	{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}	{}	404	insert
✅自动排课	arrangeTaskManagement	selectClassList	null	sql	{"table":"view01_class","operation":"select"}		405	insert
✅查询教师	arrangeTaskManagement	selectTeacherList	{}	sql	{"table":"view01_employeeld","operation":"select"}		407	insert
✅查询列表	arrangeTaskManagement	selectPlanTeacherList	null	sql	{ "table": "teaching_plan", "operation": "select" }	{}	413	insert

教学计划

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
教学计划	teachingPlanManagement	dynamicInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	teachingPlanManagement	selectItemList	null	sql	{ "table": "teaching_plan", "operation": "select" }	{}	367	insert
✅添加	teachingPlanManagement	insertItem	null	service	{"service": "timetablePlan", "serviceFunction": "insertPlanItem"}	{}	368	insert
✅更新	teachingPlanManagement	updateItem	null	service	{"service": "timetablePlan", "serviceFunction": "updatePlanItem"}	{}	369	insert
✅删除	teachingPlanManagement	deleteItem	null	sql	{ "table": "teaching_plan", "operation": "jhDelete" }	{}	370	insert
✅教学计划-查询老师列表	teachingPlanManagement	selectTeacherList	null	sql	{"table":"view01_employeeld","operation":"select"}	{}	375	insert
✅批量保存	teachingPlanManagement	batchSaveTeachingPlan	null	service	{"service": "timetable", "serviceFunction": "batchSaveTeachingPlan"}		406	insert
覆盖保存	teachingPlanManagement	batchInsertItem	null	service	{"service": "timetablePlan", "serviceFunction": "batchInsertItem"}		415	insert

课表调整

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
课表调整	timetableManagement	dynamicInMenu	null	7	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	timetableManagement	selectItemList	null	sql	{ "table": "view02_timetable", "operation": "select" }	{}	371	insert
✅添加	timetableManagement	insertItem	null	sql	{ "table": "timetable", "operation": "insert" }	{}	372	insert
✅更新	timetableManagement	updateItem	null	sql	{ "table": "timetable", "operation": "jhUpdate" }	{}	373	insert
✅删除	timetableManagement	deleteItem	null	sql	{ "table": "timetable", "operation": "jhDelete" }	{}	374	insert
✅课表-更新课表	timetableManagement	upsertTimetableItem	null	service	{"service": "timetable", "serviceFunction": "upsertTimetableItem"}	{}	376	insert
✅自动排课	timetableManagement	autoArrangeTimetable	null	service	{"service": "timetable", "serviceFunction": "autoArrangeTimetable"}		381	insert
	timetableManagement	checkReplaceItem	null	service	{"service": "timetable", "serviceFunction": "getSectionReplaceable"}		395	insert

课表合班

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
课表合班	mergeTimetableManagement	dynamicInMenu	null	6	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	mergeTimetableManagement	selectItemList	null	sql	{ "table": "timetable", "operation": "select" }	{}	377	insert
✅添加	mergeTimetableManagement	insertItem	null	sql	{ "table": "timetable", "operation": "insert" }	{}	378	insert
✅更新	mergeTimetableManagement	updateItem	null	sql	{ "table": "timetable", "operation": "jhUpdate" }	{}	379	insert
✅删除	mergeTimetableManagement	deleteItem	null	sql	{ "table": "timetable", "operation": "jhDelete" }	{}	380	insert

全校课表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
全校课表	schoolTimetableView	dynamicInMenu	null	8	undefined

学期升级

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学期升级	semesterArchive	showInAvatarMenu	null	10	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	semesterArchive	semesterArchive	null	service	{"service": "semester", "serviceFunction": "semesterArchive"}			382	insert

全校教研组

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
全校教研组	constantManagement	dynamicInMenu	null	2	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询-查询列表	constantManagement	selectItemList	null	sql	{"table": "_constant", "operation": "select"}	{}	383	insert
✅查询-添加成员	constantManagement	insertItem	null	sql	{"table": "_constant", "operation": "insert"}	{}	384	insert
✅查询-更新成员	constantManagement	updateItem	null	sql	{"table": "_constant", "operation": "jhUpdate"}	{}	385	insert
✅查询-删除信息	constantManagement	deleteItem	null	sql	{"table": "_constant", "operation": "jhDelete"}	{}	386	insert
✅查询-用户教师列表	constantManagement	getEmployeeList	null	sql	{"table":"view01_employeeld","operation":"select"}		387	insert

教师明细

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
教师明细	teacherTimetable	dynamicInMenu	null	4	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅老师排课表-查询老师列表	teacherTimetable	selectTeacherList	null	sql	{"table":"view01_employeeld","operation":"select"}	{}	388	insert
✅老师排课表-查询老师排课表	teacherTimetable	selectList	null	sql	{ "table": "timetable", "operation": "select" }	{}	389	insert
✅查询列表	teacherTimetable	selectItemList	null	sql	{ "table": "view02_timetable", "operation": "select" }	{}	390	insert
✅添加	teacherTimetable	insertItem	null	sql	{ "table": "class_timetable", "operation": "insert" }	{}	391	insert
✅更新	teacherTimetable	updateItem	null	sql	{ "table": "class_timetable", "operation": "jhUpdate" }	{}	392	insert
✅删除	teacherTimetable	deleteItem	null	sql	{ "table": "class_timetable", "operation": "jhDelete" }	{}	393	insert
✅老师排课表-查询老师列表	teacherTimetable	getTaskInfo	null	sql	{"table":"arrange_task","operation":"select"}	{}	412	insert

无课时间

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
无课时间	exclusionRuleManagement	dynamicInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	exclusionRuleManagement	selectItemList	{}	sql	{"table":"exclusion_rule","operation":"select"}		396	insert
✅添加	exclusionRuleManagement	insertItem	{}	sql	{"table":"exclusion_rule","operation":"jhInsert"}		397	insert
✅更新	exclusionRuleManagement	updateItem	{}	sql	{"table":"exclusion_rule","operation":"jhUpdate"}		398	insert
✅删除	exclusionRuleManagement	deleteItem	{}	sql	{"table":"exclusion_rule","operation":"jhDelete"}		399	insert
✅查询列表	exclusionRuleManagement	selectRecordHistory	null	sql	{ "table": "_record_history", "operation": "select" }	{}	400	insert
✅查询排课任务详情	exclusionRuleManagement	selectTaskData	{}	sql	{"table":"arrange_task","operation":"select"}		401	insert
✅查询教师	exclusionRuleManagement	selectTeacherList	{}	sql	{"table":"view01_employeeld","operation":"select"}		402	insert
✅查询教师	exclusionRuleManagement	selectClassList	{}	sql	{"table":"view01_class","operation":"select"}		403	insert
✅查询列表	exclusionRuleManagement	selectPlanTeacherList	null	sql	{ "table": "teaching_plan", "operation": "select" }	{}	414	insert

教师安排

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
教师安排	teachingArrangement	dynamicInMenu	null	3	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅批量保存	teachingArrangement	batchSaveTeachingPlan	null	service	{"service": "timetable", "serviceFunction": "batchSaveTeacherArrangement"}		409	insert
✅查询列表	teachingArrangement	selectItemList	null	sql	{ "table": "teaching_plan", "operation": "select" }	{}	410	insert
✅教学计划-查询老师列表	teachingArrangement	selectTeacherList	null	sql	{"table":"view01_employeeld","operation":"select"}	{}	411	insert

_page语句

INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'help', 'helpV4', '帮助', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'login', 'loginV4', '登陆', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'arrangeTaskManagement', NULL, '排课任务', 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'teachingPlanManagement', NULL, '教学计划', 'dynamicInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'timetableManagement', NULL, '课表调整', 'dynamicInMenu', '7', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'mergeTimetableManagement', NULL, '课表合班', 'dynamicInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'schoolTimetableView', NULL, '全校课表', 'dynamicInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'semesterArchive', NULL, '学期升级', 'showInAvatarMenu', '10', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'constantManagement', NULL, '全校教研组', 'dynamicInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'teacherTimetable', NULL, '教师明细', 'dynamicInMenu', '4', '', 'insert', NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'exclusionRuleManagement', NULL, '无课时间', 'dynamicInMenu', '5', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'teachingArrangement', NULL, '教师安排', 'dynamicInMenu', '3', 'insert', NULL, NULL, NULL);

# 页面总览

## _page结构

```sql
CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL,
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `sort` varchar(255)  DEFAULT NULL,
  `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 = 18 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'
```

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | help | dynamicInMenu | helpV4 | 11 | undefined |

## 登陆

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 登陆 | login |  | loginV4 |  | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | login | passwordLogin | null | service | { "service": "user", "serviceFunction": "passwordLogin" } |  | {} | 231 | insert |  |  |  |  |  |

## 排课任务

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 排课任务 | arrangeTaskManagement | showInMenu | null | 1 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | arrangeTaskManagement | selectItemList | null | sql | { "table": "arrange_task", "operation": "select" } |  | {} | 363 | insert |  |  |  |  |  |
| ✅添加 | arrangeTaskManagement | insertItem | null | sql | { "table": "arrange_task", "operation": "insert" } |  | {} | 364 | insert |  |  |  |  |  |
| ✅更新 | arrangeTaskManagement | updateItem | {   "after": [     {       "service": "timetable",       "serviceFunction": "afterUpdateArrangeTask"     }   ] } | sql | { "table": "arrange_task", "operation": "jhUpdate" } |  | {} | 365 | insert |  |  |  |  |  |
| ✅删除 | arrangeTaskManagement | deleteItem | {   "after": [     {       "service": "timetable",       "serviceFunction": "afterDeleteArrangeTask"     }   ] } | sql | { "table": "arrange_task", "operation": "jhDelete" } |  | {} | 366 | insert |  |  |  |  |  |
| ✅自动排课 | arrangeTaskManagement | autoArrangeTimetable | null | service | {"service": "timetable", "serviceFunction": "autoArrangeTimetable"} |  | {} | 404 | insert |  |  |  |  |  |
| ✅自动排课 | arrangeTaskManagement | selectClassList | null | sql | {"table":"view01_class","operation":"select"} |  |  | 405 | insert |  |  |  |  |  |
| ✅查询教师 | arrangeTaskManagement | selectTeacherList | {} | sql | {"table":"view01_employeeld","operation":"select"} |  |  | 407 | insert |  |  |  |  |  |
| ✅查询列表 | arrangeTaskManagement | selectPlanTeacherList | null | sql | { "table": "teaching_plan", "operation": "select" } |  | {} | 413 | insert |  |  |  |  |  |

## 教学计划

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 教学计划 | teachingPlanManagement | dynamicInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | teachingPlanManagement | selectItemList | null | sql | { "table": "teaching_plan", "operation": "select" } |  | {} | 367 | insert |  |  |  |  |  |
| ✅添加 | teachingPlanManagement | insertItem | null | service | {"service": "timetablePlan", "serviceFunction": "insertPlanItem"} |  | {} | 368 | insert |  |  |  |  |  |
| ✅更新 | teachingPlanManagement | updateItem | null | service | {"service": "timetablePlan", "serviceFunction": "updatePlanItem"} |  | {} | 369 | insert |  |  |  |  |  |
| ✅删除 | teachingPlanManagement | deleteItem | null | sql | { "table": "teaching_plan", "operation": "jhDelete" } |  | {} | 370 | insert |  |  |  |  |  |
| ✅教学计划-查询老师列表 | teachingPlanManagement | selectTeacherList | null | sql | {"table":"view01_employeeld","operation":"select"} |  | {} | 375 | insert |  |  |  |  |  |
| ✅批量保存 | teachingPlanManagement | batchSaveTeachingPlan | null | service | {"service": "timetable", "serviceFunction": "batchSaveTeachingPlan"} |  |  | 406 | insert |  |  |  |  |  |
| 覆盖保存 | teachingPlanManagement | batchInsertItem | null | service | {"service": "timetablePlan", "serviceFunction": "batchInsertItem"} |  |  | 415 | insert |  |  |  |  |  |

## 课表调整

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 课表调整 | timetableManagement | dynamicInMenu | null | 7 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | timetableManagement | selectItemList | null | sql | { "table": "view02_timetable", "operation": "select" } |  | {} | 371 | insert |  |  |  |  |  |
| ✅添加 | timetableManagement | insertItem | null | sql | { "table": "timetable", "operation": "insert" } |  | {} | 372 | insert |  |  |  |  |  |
| ✅更新 | timetableManagement | updateItem | null | sql | { "table": "timetable", "operation": "jhUpdate" } |  | {} | 373 | insert |  |  |  |  |  |
| ✅删除 | timetableManagement | deleteItem | null | sql | { "table": "timetable", "operation": "jhDelete" } |  | {} | 374 | insert |  |  |  |  |  |
| ✅课表-更新课表 | timetableManagement | upsertTimetableItem | null | service | {"service": "timetable", "serviceFunction": "upsertTimetableItem"} |  | {} | 376 | insert |  |  |  |  |  |
| ✅自动排课 | timetableManagement | autoArrangeTimetable | null | service | {"service": "timetable", "serviceFunction": "autoArrangeTimetable"} |  |  | 381 | insert |  |  |  |  |  |
|  | timetableManagement | checkReplaceItem | null | service | {"service": "timetable", "serviceFunction": "getSectionReplaceable"} |  |  | 395 | insert |  |  |  |  |  |

## 课表合班

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 课表合班 | mergeTimetableManagement | dynamicInMenu | null | 6 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | mergeTimetableManagement | selectItemList | null | sql | { "table": "timetable", "operation": "select" } |  | {} | 377 | insert |  |  |  |  |  |
| ✅添加 | mergeTimetableManagement | insertItem | null | sql | { "table": "timetable", "operation": "insert" } |  | {} | 378 | insert |  |  |  |  |  |
| ✅更新 | mergeTimetableManagement | updateItem | null | sql | { "table": "timetable", "operation": "jhUpdate" } |  | {} | 379 | insert |  |  |  |  |  |
| ✅删除 | mergeTimetableManagement | deleteItem | null | sql | { "table": "timetable", "operation": "jhDelete" } |  | {} | 380 | insert |  |  |  |  |  |

## 全校课表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 全校课表 | schoolTimetableView | dynamicInMenu | null | 8 | undefined |

## 学期升级

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学期升级 | semesterArchive | showInAvatarMenu | null | 10 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | semesterArchive | semesterArchive | null | service | {"service": "semester", "serviceFunction": "semesterArchive"} |  |  | 382 | insert |  |  |  |  |  |

## 全校教研组

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 全校教研组 | constantManagement | dynamicInMenu | null | 2 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询-查询列表 | constantManagement | selectItemList | null | sql | {"table": "_constant", "operation": "select"} |  | {} | 383 | insert |  |  |  |  |  |
| ✅查询-添加成员 | constantManagement | insertItem | null | sql | {"table": "_constant", "operation": "insert"} |  | {} | 384 | insert |  |  |  |  |  |
| ✅查询-更新成员 | constantManagement | updateItem | null | sql | {"table": "_constant", "operation": "jhUpdate"} |  | {} | 385 | insert |  |  |  |  |  |
| ✅查询-删除信息 | constantManagement | deleteItem | null | sql | {"table": "_constant", "operation": "jhDelete"} |  | {} | 386 | insert |  |  |  |  |  |
| ✅查询-用户教师列表 | constantManagement | getEmployeeList | null | sql | {"table":"view01_employeeld","operation":"select"} |  |  | 387 | insert |  |  |  |  |  |

## 教师明细

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 教师明细 | teacherTimetable | dynamicInMenu | null | 4 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅老师排课表-查询老师列表 | teacherTimetable | selectTeacherList | null | sql | {"table":"view01_employeeld","operation":"select"} |  | {} | 388 | insert |  |  |  |  |  |
| ✅老师排课表-查询老师排课表 | teacherTimetable | selectList | null | sql | { "table": "timetable", "operation": "select" } |  | {} | 389 | insert |  |  |  |  |  |
| ✅查询列表 | teacherTimetable | selectItemList | null | sql | { "table": "view02_timetable", "operation": "select" } |  | {} | 390 | insert |  |  |  |  |  |
| ✅添加 | teacherTimetable | insertItem | null | sql | { "table": "class_timetable", "operation": "insert" } |  | {} | 391 | insert |  |  |  |  |  |
| ✅更新 | teacherTimetable | updateItem | null | sql | { "table": "class_timetable", "operation": "jhUpdate" } |  | {} | 392 | insert |  |  |  |  |  |
| ✅删除 | teacherTimetable | deleteItem | null | sql | { "table": "class_timetable", "operation": "jhDelete" } |  | {} | 393 | insert |  |  |  |  |  |
| ✅老师排课表-查询老师列表 | teacherTimetable | getTaskInfo | null | sql | {"table":"arrange_task","operation":"select"} |  | {} | 412 | insert |  |  |  |  |  |

## 无课时间

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 无课时间 | exclusionRuleManagement | dynamicInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | exclusionRuleManagement | selectItemList | {} | sql | {"table":"exclusion_rule","operation":"select"} |  |  | 396 | insert |  |  |  |  |  |
| ✅添加 | exclusionRuleManagement | insertItem | {} | sql | {"table":"exclusion_rule","operation":"jhInsert"} |  |  | 397 | insert |  |  |  |  |  |
| ✅更新 | exclusionRuleManagement | updateItem | {} | sql | {"table":"exclusion_rule","operation":"jhUpdate"} |  |  | 398 | insert |  |  |  |  |  |
| ✅删除 | exclusionRuleManagement | deleteItem | {} | sql | {"table":"exclusion_rule","operation":"jhDelete"} |  |  | 399 | insert |  |  |  |  |  |
| ✅查询列表 | exclusionRuleManagement | selectRecordHistory | null | sql | { "table": "_record_history", "operation": "select" } |  | {} | 400 | insert |  |  |  |  |  |
| ✅查询排课任务详情 | exclusionRuleManagement | selectTaskData | {} | sql | {"table":"arrange_task","operation":"select"} |  |  | 401 | insert |  |  |  |  |  |
| ✅查询教师 | exclusionRuleManagement | selectTeacherList | {} | sql | {"table":"view01_employeeld","operation":"select"} |  |  | 402 | insert |  |  |  |  |  |
| ✅查询教师 | exclusionRuleManagement | selectClassList | {} | sql | {"table":"view01_class","operation":"select"} |  |  | 403 | insert |  |  |  |  |  |
| ✅查询列表 | exclusionRuleManagement | selectPlanTeacherList | null | sql | { "table": "teaching_plan", "operation": "select" } |  | {} | 414 | insert |  |  |  |  |  |

## 教师安排

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 教师安排 | teachingArrangement | dynamicInMenu | null | 3 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅批量保存 | teachingArrangement | batchSaveTeachingPlan | null | service | {"service": "timetable", "serviceFunction": "batchSaveTeacherArrangement"} |  |  | 409 | insert |  |  |  |  |  |
| ✅查询列表 | teachingArrangement | selectItemList | null | sql | { "table": "teaching_plan", "operation": "select" } |  | {} | 410 | insert |  |  |  |  |  |
| ✅教学计划-查询老师列表 | teachingArrangement | selectTeacherList | null | sql | {"table":"view01_employeeld","operation":"select"} |  | {} | 411 | insert |  |  |  |  |  |

## _page语句

```sql
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'help', 'helpV4', '帮助', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'login', 'loginV4', '登陆', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'arrangeTaskManagement', NULL, '排课任务', 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'teachingPlanManagement', NULL, '教学计划', 'dynamicInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'timetableManagement', NULL, '课表调整', 'dynamicInMenu', '7', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'mergeTimetableManagement', NULL, '课表合班', 'dynamicInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'schoolTimetableView', NULL, '全校课表', 'dynamicInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'semesterArchive', NULL, '学期升级', 'showInAvatarMenu', '10', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'constantManagement', NULL, '全校教研组', 'dynamicInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'teacherTimetable', NULL, '教师明细', 'dynamicInMenu', '4', '', 'insert', NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'exclusionRuleManagement', NULL, '无课时间', 'dynamicInMenu', '5', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'teachingArrangement', NULL, '教师安排', 'dynamicInMenu', '3', 'insert', NULL, NULL, NULL);
```