页面

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"}		{}	1	update	2022-04-27T15:32:57+08:00

查看和填写评语

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
查看和填写评语	studentList	dynamicInMenu	null	1	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查看和填写评语查询-查询列表	studentList	selectItemList	null	sql	{ "table": "view01_student_new_structure", "operation": "select" }		{}	5	insert

学生基础信息

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生基础信息	studentNewStructureList	dynamicInMenu	null	2	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生管理-基础信息查询-查询列表	studentNewStructureList	selectItemList	null	sql	{ "table": "view01_student_new_structure", "operation": "select" }		{}	10	insert

学生联系方式

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生联系方式	studentContactList	dynamicInMenu	null	3	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生管理-联系方式查询-查询列表	studentContactList	selectItemList	null	sql	{ "table": "view01_student_contact", "operation": "select" }		{}	11	insert

学生教育背景

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生教育背景	studentEducationBackgroundList	dynamicInMenu	null	4	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生管理-教育背景查询-查询列表	studentEducationBackgroundList	selectItemList	null	sql	{ "table": "view01_student_education_background", "operation": "select" }		{}	12	insert

学生助学金

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生助学金	studentFinancialAidList	dynamicInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生管理-助学金查询-查询列表	studentFinancialAidList	selectItemList	null	sql	{ "table": "view01_student_financial_aid", "operation": "select" }		{}	13	insert

学生监护人

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生监护人	studentGuardianList	dynamicInMenu	null	6	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生管理-监护人查询-查询列表	studentGuardianList	selectItemList	null	sql	{ "table": "view01_student_guardian", "operation": "select" }		{}	14	insert

学生籍贯

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生籍贯	studentHometownList	dynamicInMenu	null	7	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生管理-籍贯查询-查询列表	studentHometownList	selectItemList	null	sql	{ "table": "view01_student_hometown", "operation": "select" }		{}	15	insert

学生宿舍

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生宿舍	studentLogisticsList	dynamicInMenu	null	8	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生管理-宿舍查询-查询列表	studentLogisticsList	selectItemList	null	sql	{ "table": "view01_student_logistics", "operation": "select" }		{}	16	insert

评语管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
评语管理	studentCommentList	dynamicInMenu	null	1	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询-查询列表	studentCommentList	selectItemList	null	sql	{ "table": "comment_for_student", "operation": "select" }	{}	6	insert
✅评语管理-添加成员	studentCommentList	insertItem	null	sql	{ "table": "comment_for_student", "operation": "insert" }	{}	7	insert
✅评语管理-更新成员	studentCommentList	updateItem	null	sql	{ "table": "comment_for_student", "operation": "jhUpdate" }	{}	8	insert
✅评语管理-删除信息	studentCommentList	deleteItem	null	sql	{ "table": "comment_for_student", "operation": "jhDelete" }	{}	9	insert

学生评语管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生评语管理	appraisalManagement	showInMenu	null	0	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	appraisalManagement	selectItemList	null	sql	{ "table": "view02_appraisal", "operation": "select"}	{}	18	insert
✅添加	appraisalManagement	insertItem		service	{"service": "appraisal", "serviceFunction": "createAppraisal"}	{}	19	insert
✅更新	appraisalManagement	updateItem	null	sql	{ "table": "appraisal", "operation": "jhUpdate" }	{}	20	insert
✅删除	appraisalManagement	deleteItem	null	sql	{ "table": "appraisal", "operation": "jhDelete" }	{}	21	insert
✅班级列表	appraisalManagement	selectClassList	null	sql	{ "table": "view01_class", "operation": "select", "where": { "formTeacherId": "ctx.userInfo.userId" } }	{}	22	insert
✅发送通知	appraisalManagement	sendNotice	null	service	{"service": "appraisal", "serviceFunction": "sendNotice"}	{}	28	insert
✅发送通知	appraisalManagement	selectAppraisalStudentList	null	sql	{ "table": "view02_appraisal_student", "operation": "select" }	{}	29	insert

评语的学生评语管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
评语的学生评语管理	appraisalStudentManagementOfOneAppraisal	dynamicInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅评语的学生评语管理-查询当前学生评语下的评语列表	appraisalStudentManagementOfOneAppraisal	selectCurrentList	null	sql	{ "table": "view02_appraisal_student", "operation": "select" }	{}	23	jhInsert
✅评语的学生评语管理-建立关系	appraisalStudentManagementOfOneAppraisal	insertItem	null	sql	{ "table": "appraisal_student", "operation": "jhInsert" }	{}	24	jhInsert
✅评语的学生评语管理-更新数据	appraisalStudentManagementOfOneAppraisal	updateItem	null	sql	{ "table": "appraisal_student", "operation": "jhUpdate" }	{}	25	jhInsert
✅评语的学生评语管理-删除信息	appraisalStudentManagementOfOneAppraisal	deleteItem	null	sql	{ "table": "appraisal_student", "operation": "jhDelete" }	{}	26	jhInsert
✅评语查询-查询列表	appraisalStudentManagementOfOneAppraisal	selectAllList	null	sql	{ "table": "appraisal_student", "operation": "select" }	{}	27	jhInsert

学生评语

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生评语	appraisalView	showInMenu	null	0	undefined

权限管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
权限管理	userGroupRole	showInAvatarMenu	null	11	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	operation	operationAt	requestDemo	responseDemo
✅权限管理页-查询已配置权限列表	userGroupRole	selectItemList	null	sql	{"table": "_user_group_role", "operation": "select"}	30	update	2022-05-02T15:23:51+08:00	{"appData": {"appId": "demo_advanced", "where": {"userId": "001"}, "pageId": "userGroupRole", "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476230231_7262893", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectItemList", "resultData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476230231_7262893", "timestamp": "2022-05-02T15:23:50+08:00", "packageType": "httpResponse"}
✅权限管理页-查询用户	userGroupRole	selectUser	null	sql	{"table": "_view02_user_app", "operation": "select"}	31	update	2022-05-02T15:23:58+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476237658_7645348", "packageType": "httpRequest"}	{"status": "success", "packageId": "1651476237658_7645348", "timestamp": "2022-05-02T15:23:58+08:00", "packageType": "httpResponse"}
✅权限管理页-查询群组	userGroupRole	selectGroup	null	sql	{"table": "_group", "operation": "select"}	32	update	2022-05-02T15:21:29+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_6618462", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "resultData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476088200_6618462", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}
✅权限管理页-创建权限配置	userGroupRole	insertItem	null	sql	{"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""}	33	update	2022-04-28T20:36:12+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"roleId": "teacher", "userId": "admin2", "groupId": "adminGroup"}}, "packageId": "1651149371608_1485871", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [599], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "resultData": {"rows": [599]}}, "packageId": "1651149371608_1485871", "timestamp": "2022-04-28T20:36:12+08:00", "packageType": "httpResponse"}
✅权限管理页-更新权限配置	userGroupRole	updateItem	null	sql	{"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}	34	update	2022-02-18T12:09:29+08:00	{}	{}
✅权限管理页-删除权限配置	userGroupRole	deleteItem	null	sql	{"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}	35	update	2022-02-18T21:03:41+08:00	{}	{}
✅权限管理页-查询角色	userGroupRole	selectRole	null	sql	{"table": "_role", "operation": "select"}	36	update	2022-05-02T15:21:29+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_7966907", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "resultData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}]}}, "packageId": "1651476088200_7966907", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}
✅权限管理页-添加群组	userGroupRole	insertGroup	null	sql	{"table": "_group", "operation": "jhInsert"}	37	update	2022-02-18T19:55:57+08:00	{}	{}
✅权限管理页-添加角色	userGroupRole	insertRole	null	sql	{"table": "_role", "operation": "jhInsert"}	38	update	2022-02-18T20:00:37+08:00	{}	{}
✅权限管理页-删除群组	userGroupRole	deleteGroup	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_group", "operation": "jhDelete"}	39	update	2022-02-18T19:56:11+08:00	{}	{}
✅权限管理页-删除角色	userGroupRole	deleteRole	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_role", "operation": "jhDelete"}	40	update	2022-02-18T20:04:23+08:00	{}	{}
✅权限管理页-更新群组	userGroupRole	updateGroup	null	sql	{"table": "_group", "operation": "jhUpdate"}	41	update	2022-02-18T20:45:26+08:00	{}	{}
✅权限管理页-更新角色	userGroupRole	updateRole	null	sql	{"table": "_role", "operation": "jhUpdate"}	42	update	2022-02-18T19:56:37+08:00	{}	{}

评语配置

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
评语配置	appraisalSetting	showInMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询列表	appraisalSetting	selectItemList	null	sql	{ "table": "_constant", "operation": "select" }	{}	43	insert
✅添加	appraisalSetting	insertItem	null	sql	{ "table": "_constant", "operation": "insert" }	{}	44	insert
✅更新	appraisalSetting	updateItem	null	sql	{ "table": "_constant", "operation": "jhUpdate" }	{}	45	insert
✅删除	appraisalSetting	deleteItem	null	sql	{ "table": "_constant", "operation": "jhDelete" }	{}	46	insert

_page语句

INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', '帮助', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', '登陆', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'studentList', NULL, '查看和填写评语', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'studentNewStructureList', NULL, '学生基础信息', 'dynamicInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'studentContactList', NULL, '学生联系方式', 'dynamicInMenu', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'studentEducationBackgroundList', NULL, '学生教育背景', 'dynamicInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'studentFinancialAidList', NULL, '学生助学金', 'dynamicInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'studentGuardianList', NULL, '学生监护人', 'dynamicInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'studentHometownList', NULL, '学生籍贯', 'dynamicInMenu', '7', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'studentLogisticsList', NULL, '学生宿舍', 'dynamicInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'studentCommentList', NULL, '评语管理', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'appraisalManagement', NULL, '学生评语管理', 'showInMenu', '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'appraisalStudentManagementOfOneAppraisal', NULL, '评语的学生评语管理', 'dynamicInMenu', '5', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'appraisalView', NULL, '学生评语', 'showInMenu', '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'userGroupRole', NULL, '权限管理', 'showInAvatarMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'appraisalSetting', NULL, '评语配置', 'showInMenu', '5', '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"} |  | {} | 1 | update | 2022-04-27T15:32:57+08:00 |  |  |  |  |

## 查看和填写评语

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 查看和填写评语 | studentList | dynamicInMenu | null | 1 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查看和填写评语查询-查询列表 | studentList | selectItemList | null | sql | { "table": "view01_student_new_structure", "operation": "select" } |  | {} | 5 | insert |  |  |  |  |  |

## 学生基础信息

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生基础信息 | studentNewStructureList | dynamicInMenu | null | 2 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生管理-基础信息查询-查询列表 | studentNewStructureList | selectItemList | null | sql | { "table": "view01_student_new_structure", "operation": "select" } |  | {} | 10 | insert |  |  |  |  |  |

## 学生联系方式

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生联系方式 | studentContactList | dynamicInMenu | null | 3 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生管理-联系方式查询-查询列表 | studentContactList | selectItemList | null | sql | { "table": "view01_student_contact", "operation": "select" } |  | {} | 11 | insert |  |  |  |  |  |

## 学生教育背景

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生教育背景 | studentEducationBackgroundList | dynamicInMenu | null | 4 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生管理-教育背景查询-查询列表 | studentEducationBackgroundList | selectItemList | null | sql | { "table": "view01_student_education_background", "operation": "select" } |  | {} | 12 | insert |  |  |  |  |  |

## 学生助学金

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生助学金 | studentFinancialAidList | dynamicInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生管理-助学金查询-查询列表 | studentFinancialAidList | selectItemList | null | sql | { "table": "view01_student_financial_aid", "operation": "select" } |  | {} | 13 | insert |  |  |  |  |  |

## 学生监护人

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生监护人 | studentGuardianList | dynamicInMenu | null | 6 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生管理-监护人查询-查询列表 | studentGuardianList | selectItemList | null | sql | { "table": "view01_student_guardian", "operation": "select" } |  | {} | 14 | insert |  |  |  |  |  |

## 学生籍贯

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生籍贯 | studentHometownList | dynamicInMenu | null | 7 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生管理-籍贯查询-查询列表 | studentHometownList | selectItemList | null | sql | { "table": "view01_student_hometown", "operation": "select" } |  | {} | 15 | insert |  |  |  |  |  |

## 学生宿舍

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生宿舍 | studentLogisticsList | dynamicInMenu | null | 8 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅学生管理-宿舍查询-查询列表 | studentLogisticsList | selectItemList | null | sql | { "table": "view01_student_logistics", "operation": "select" } |  | {} | 16 | insert |  |  |  |  |  |

## 评语管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 评语管理 | studentCommentList | dynamicInMenu | null | 1 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询-查询列表 | studentCommentList | selectItemList | null | sql | { "table": "comment_for_student", "operation": "select" } |  | {} | 6 | insert |  |  |  |  |  |
| ✅评语管理-添加成员 | studentCommentList | insertItem | null | sql | { "table": "comment_for_student", "operation": "insert" } |  | {} | 7 | insert |  |  |  |  |  |
| ✅评语管理-更新成员 | studentCommentList | updateItem | null | sql | { "table": "comment_for_student", "operation": "jhUpdate" } |  | {} | 8 | insert |  |  |  |  |  |
| ✅评语管理-删除信息 | studentCommentList | deleteItem | null | sql | { "table": "comment_for_student", "operation": "jhDelete" } |  | {} | 9 | insert |  |  |  |  |  |

## 学生评语管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生评语管理 | appraisalManagement | showInMenu | null | 0 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | appraisalManagement | selectItemList | null | sql | { "table": "view02_appraisal", "operation": "select"} |  | {} | 18 | insert |  |  |  |  |  |
| ✅添加 | appraisalManagement | insertItem |  | service | {"service": "appraisal", "serviceFunction": "createAppraisal"} |  | {} | 19 | insert |  |  |  |  |  |
| ✅更新 | appraisalManagement | updateItem | null | sql | { "table": "appraisal", "operation": "jhUpdate" } |  | {} | 20 | insert |  |  |  |  |  |
| ✅删除 | appraisalManagement | deleteItem | null | sql | { "table": "appraisal", "operation": "jhDelete" } |  | {} | 21 | insert |  |  |  |  |  |
| ✅班级列表 | appraisalManagement | selectClassList | null | sql | { "table": "view01_class", "operation": "select", "where": { "formTeacherId": "ctx.userInfo.userId" } } |  | {} | 22 | insert |  |  |  |  |  |
| ✅发送通知 | appraisalManagement | sendNotice | null | service | {"service": "appraisal", "serviceFunction": "sendNotice"} |  | {} | 28 | insert |  |  |  |  |  |
| ✅发送通知 | appraisalManagement | selectAppraisalStudentList | null | sql | { "table": "view02_appraisal_student", "operation": "select" } |  | {} | 29 | insert |  |  |  |  |  |

## 评语的学生评语管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 评语的学生评语管理 | appraisalStudentManagementOfOneAppraisal | dynamicInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅评语的学生评语管理-查询当前学生评语下的评语列表 | appraisalStudentManagementOfOneAppraisal | selectCurrentList | null | sql | { "table": "view02_appraisal_student", "operation": "select" } |  | {} | 23 | jhInsert |  |  |  |  |  |
| ✅评语的学生评语管理-建立关系 | appraisalStudentManagementOfOneAppraisal | insertItem | null | sql | { "table": "appraisal_student", "operation": "jhInsert" } |  | {} | 24 | jhInsert |  |  |  |  |  |
| ✅评语的学生评语管理-更新数据 | appraisalStudentManagementOfOneAppraisal | updateItem | null | sql | { "table": "appraisal_student", "operation": "jhUpdate" } |  | {} | 25 | jhInsert |  |  |  |  |  |
| ✅评语的学生评语管理-删除信息 | appraisalStudentManagementOfOneAppraisal | deleteItem | null | sql | { "table": "appraisal_student", "operation": "jhDelete" } |  | {} | 26 | jhInsert |  |  |  |  |  |
| ✅评语查询-查询列表 | appraisalStudentManagementOfOneAppraisal | selectAllList | null | sql | { "table": "appraisal_student", "operation": "select" } |  | {} | 27 | jhInsert |  |  |  |  |  |

## 学生评语

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 学生评语 | appraisalView | showInMenu | null | 0 | undefined |

## 权限管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 权限管理 | userGroupRole | showInAvatarMenu | null | 11 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅权限管理页-查询已配置权限列表 | userGroupRole | selectItemList | null | sql | {"table": "_user_group_role", "operation": "select"} |  |  | 30 | update | 2022-05-02T15:23:51+08:00 |  |  | {"appData": {"appId": "demo_advanced", "where": {"userId": "001"}, "pageId": "userGroupRole", "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476230231_7262893", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectItemList", "resultData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476230231_7262893", "timestamp": "2022-05-02T15:23:50+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-查询用户 | userGroupRole | selectUser | null | sql | {"table": "_view02_user_app", "operation": "select"} |  |  | 31 | update | 2022-05-02T15:23:58+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476237658_7645348", "packageType": "httpRequest"} | {"status": "success", "packageId": "1651476237658_7645348", "timestamp": "2022-05-02T15:23:58+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-查询群组 | userGroupRole | selectGroup | null | sql | {"table": "_group", "operation": "select"} |  |  | 32 | update | 2022-05-02T15:21:29+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_6618462", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "resultData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "groupName": "Ã§Â®Â¡Ã§ÂÂÃ§Â»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476088200_6618462", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-创建权限配置 | userGroupRole | insertItem | null | sql | {"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""} |  |  | 33 | update | 2022-04-28T20:36:12+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"roleId": "teacher", "userId": "admin2", "groupId": "adminGroup"}}, "packageId": "1651149371608_1485871", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [599], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "resultData": {"rows": [599]}}, "packageId": "1651149371608_1485871", "timestamp": "2022-04-28T20:36:12+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-更新权限配置 | userGroupRole | updateItem | null | sql | {"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} |  |  | 34 | update | 2022-02-18T12:09:29+08:00 |  |  | {} | {} |
| ✅权限管理页-删除权限配置 | userGroupRole | deleteItem | null | sql | {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} |  |  | 35 | update | 2022-02-18T21:03:41+08:00 |  |  | {} | {} |
| ✅权限管理页-查询角色 | userGroupRole | selectRole | null | sql | {"table": "_role", "operation": "select"} |  |  | 36 | update | 2022-05-02T15:21:29+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_7966907", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "resultData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "Ã§Â³Â»Ã§Â»ÂÃ§Â®Â¡Ã§ÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "Ã¨ÂÂÃ¥Â¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "Ã¥ÂÂ¦Ã§ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}]}}, "packageId": "1651476088200_7966907", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"} |
| ✅权限管理页-添加群组 | userGroupRole | insertGroup | null | sql | {"table": "_group", "operation": "jhInsert"} |  |  | 37 | update | 2022-02-18T19:55:57+08:00 |  |  | {} | {} |
| ✅权限管理页-添加角色 | userGroupRole | insertRole | null | sql | {"table": "_role", "operation": "jhInsert"} |  |  | 38 | update | 2022-02-18T20:00:37+08:00 |  |  | {} | {} |
| ✅权限管理页-删除群组 | userGroupRole | deleteGroup | {   "before": [],   "after": [     {       "service": "userGroupRole",       "serviceFunction": "deleteUserGroupRole"     }   ] } | sql | {"table": "_group", "operation": "jhDelete"} |  |  | 39 | update | 2022-02-18T19:56:11+08:00 |  |  | {} | {} |
| ✅权限管理页-删除角色 | userGroupRole | deleteRole | {   "before": [],   "after": [     {       "service": "userGroupRole",       "serviceFunction": "deleteUserGroupRole"     }   ] } | sql | {"table": "_role", "operation": "jhDelete"} |  |  | 40 | update | 2022-02-18T20:04:23+08:00 |  |  | {} | {} |
| ✅权限管理页-更新群组 | userGroupRole | updateGroup | null | sql | {"table": "_group", "operation": "jhUpdate"} |  |  | 41 | update | 2022-02-18T20:45:26+08:00 |  |  | {} | {} |
| ✅权限管理页-更新角色 | userGroupRole | updateRole | null | sql | {"table": "_role", "operation": "jhUpdate"} |  |  | 42 | update | 2022-02-18T19:56:37+08:00 |  |  | {} | {} |

## 评语配置

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 评语配置 | appraisalSetting | showInMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询列表 | appraisalSetting | selectItemList | null | sql | { "table": "_constant", "operation": "select" } |  | {} | 43 | insert |  |  |  |  |  |
| ✅添加 | appraisalSetting | insertItem | null | sql | { "table": "_constant", "operation": "insert" } |  | {} | 44 | insert |  |  |  |  |  |
| ✅更新 | appraisalSetting | updateItem | null | sql | { "table": "_constant", "operation": "jhUpdate" } |  | {} | 45 | insert |  |  |  |  |  |
| ✅删除 | appraisalSetting | deleteItem | null | sql | { "table": "_constant", "operation": "jhDelete" } |  | {} | 46 | insert |  |  |  |  |  |

## _page语句

```sql
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', '帮助', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', '登陆', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'studentList', NULL, '查看和填写评语', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'studentNewStructureList', NULL, '学生基础信息', 'dynamicInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'studentContactList', NULL, '学生联系方式', 'dynamicInMenu', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'studentEducationBackgroundList', NULL, '学生教育背景', 'dynamicInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'studentFinancialAidList', NULL, '学生助学金', 'dynamicInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'studentGuardianList', NULL, '学生监护人', 'dynamicInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'studentHometownList', NULL, '学生籍贯', 'dynamicInMenu', '7', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'studentLogisticsList', NULL, '学生宿舍', 'dynamicInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'studentCommentList', NULL, '评语管理', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'appraisalManagement', NULL, '学生评语管理', 'showInMenu', '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'appraisalStudentManagementOfOneAppraisal', NULL, '评语的学生评语管理', 'dynamicInMenu', '5', 'jhInsert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'appraisalView', NULL, '学生评语', 'showInMenu', '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'userGroupRole', NULL, '权限管理', 'showInAvatarMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'appraisalSetting', NULL, '评语配置', 'showInMenu', '5', 'insert', NULL, NULL, NULL);
```