页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `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 = 38 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
招生数据管理	recruitmentManagement	showInMenu	null	2	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	recruitmentManagement	selectItemList		sql	{ "table": "view01_student_recruitment", "operation": "select" }		{}	329	insert
✅添加	recruitmentManagement	insertItem	{ "before": [ { "service": "recruitment", "serviceFunction": "createStudentBeforeCheck" } ] }	sql	{ "table": "student_recruitment", "operation": "insert" }		{}	330	insert
✅更新	recruitmentManagement	updateItem	null	sql	{ "table": "student_recruitment", "operation": "jhUpdate" }		{}	331	insert
✅删除	recruitmentManagement	deleteItem	null	sql	{ "table": "student_recruitment", "operation": "jhDelete" }		{}	332	insert
✅内部报名	recruitmentManagement	recruitmentByManagement	null	service	{ "service": "recruitment", "serviceFunction": "recruitmentByManagement" }		{}	333	insert
✅获取excel配置信息	recruitmentManagement	getExcelTemplateConfig	null	service	{ "service": "recruitment", "serviceFunction": "getExcelTemplateConfig" }		{}	334	insert
✅报名列表检查	recruitmentManagement	studentListCheck	null	service	{ "service": "recruitment", "serviceFunction": "studentListCheck" }		{}	335	insert
✅随机分配-跟进人	recruitmentManagement	randomFollowUp	null	service	{ "service": "recruitment", "serviceFunction": "randomFollowUp" }		{}	336	insert
✅查询-入学跟进人列表	recruitmentManagement	selectFollowUpByUser	null	sql	{ "table": "view01_follow_up_user", "operation": "select" }		{}	435	insert
✅查询-入学跟进数	recruitmentManagement	selectFollowUpCount	null	sql	{ "table": "view01_follow_up_count", "operation": "select" }		{}	436	insert
✅跟进-学生报名	recruitmentManagement	followUpRecruitment	null	service	{ "service": "recruitment", "serviceFunction": "followUpRecruitment" }		{}	437	insert
✅转让跟进-学生报名	recruitmentManagement	followUpTransfer	null	service	{ "service": "recruitment", "serviceFunction": "followUpTransfer" }		{}	438	insert
✅随机分配-跟进人	recruitmentManagement	recommendFollowUp	null	service	{ "service": "recruitment", "serviceFunction": "recommendFollowUp" }		{}	439	insert

学生报名

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学生报名	studentRecruitment	showInMenu	null	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅学生报名	studentRecruitment	recruitmentByStudent	null	service	{ "service": "recruitment", "serviceFunction": "recruitmentByStudent" }		{}	434	insert

跟进学生

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
跟进学生	followUpStudent	showInMenu	null	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅内部报名	followUpStudent	selectItemList		service	{ "service": "recruitment", "serviceFunction": "getFllowUpUserList" }		{}	440	insert
✅内部报名	followUpStudent	batchFollowUp	null	service	{ "service": "recruitment", "serviceFunction": "batchFollowUp" }		{}	441	insert
✅跟进-学生报名	followUpStudent	followUpRecruitment	null	service	{ "service": "recruitment", "serviceFunction": "followUpRecruitment" }		{}	442	insert
✅转让跟进-学生报名	followUpStudent	followUpTransfer	null	service	{ "service": "recruitment", "serviceFunction": "followUpTransfer" }		{}	443	insert
✅更新	followUpStudent	updateItem		sql	{ "table": "student_recruitment", "operation": "jhUpdate" }		{}	444	insert

权限管理

• 页面信息

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"}			445	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"}			446	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"}			447	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": ""}			448	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)})"}			449	update	2022-02-18T12:09:29+08:00			{}	{}
✅权限管理页-删除权限配置	userGroupRole	deleteItem	null	sql	{"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}			450	update	2022-02-18T21:03:41+08:00			{}	{}
✅权限管理页-查询角色	userGroupRole	selectRole	null	sql	{"table": "_role", "operation": "select"}			451	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	insertUser	null	service	{"service": "userManagement", "serviceFunction": "addUser"}			452	update	2022-04-28T20:35:24+08:00			{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "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": {"userId": "admin2", "username": "admin2", "clearTextPassword": "123456"}}, "packageId": "1651149323428_7722305", "packageType": "httpRequest"}	{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "resultData": {}}, "packageId": "1651149323428_7722305", "timestamp": "2022-04-28T20:35:24+08:00", "packageType": "httpResponse"}
✅权限管理页-添加群组	userGroupRole	insertGroup	null	sql	{"table": "_group", "operation": "jhInsert"}			453	update	2022-02-18T19:55:57+08:00			{}	{}
✅权限管理页-添加角色	userGroupRole	insertRole	null	sql	{"table": "_role", "operation": "jhInsert"}			454	update	2022-02-18T20:00:37+08:00			{}	{}
✅权限管理页-删除用户	userGroupRole	deleteUser	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_user", "operation": "jhDelete"}			455	update	2022-04-28T20:36:24+08:00			{"appData": {"appId": "demo_advanced", "where": {"userId": "admin2"}, "pageId": "userGroupRole", "actionId": "deleteUser", "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": "1651149383707_8632195", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "deleteUser", "resultData": {"rows": 1}}, "packageId": "1651149383707_8632195", "timestamp": "2022-04-28T20:36:24+08:00", "packageType": "httpResponse"}
✅权限管理页-删除群组	userGroupRole	deleteGroup	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_group", "operation": "jhDelete"}			456	update	2022-02-18T19:56:11+08:00			{}	{}
✅权限管理页-删除角色	userGroupRole	deleteRole	{ "before": [], "after": [ { "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" } ] }	sql	{"table": "_role", "operation": "jhDelete"}			457	update	2022-02-18T20:04:23+08:00			{}	{}
✅权限管理页-更新用户	userGroupRole	updateUser	null	sql	{"table": "_user", "operation": "jhUpdate"}			458	update	2022-05-02T15:23:57+08:00			{"appData": {"appId": "demo_advanced", "where": {"id": 68}, "pageId": "userGroupRole", "actionId": "updateUser", "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": {"config": null, "userId": "001", "md5Salt": "ZsPkQcHpYZQT", "password": "b9e96d6ebc84dd51f2bd1fb56a79d8cb", "userType": "common", "username": "小华", "operation": "jhUpdate", "idSequence": "26260000", "userStatus": "active", "operationAt": "2022-05-02T15:21:34+08:00", "initPassword": null, "operationByUser": "adminName", "clearTextPassword": "1234567", "operationByUserId": "admin"}}, "packageId": "1651476236716_5991856", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "updateUser", "resultData": {"rows": 1}}, "packageId": "1651476236716_5991856", "timestamp": "2022-05-02T15:23:57+08:00", "packageType": "httpResponse"}
✅权限管理页-更新群组	userGroupRole	updateGroup	null	sql	{"table": "_group", "operation": "jhUpdate"}			459	update	2022-02-18T20:45:26+08:00			{}	{}
✅权限管理页-更新角色	userGroupRole	updateRole	null	sql	{"table": "_role", "operation": "jhUpdate"}			460	update	2022-02-18T19:56:37+08:00			{}	{}

资料提交

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
资料提交	recruitmentSuper	showInMenu	null	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	recruitmentSuper	selectItemList	null	sql	{ "table": "student_recruitment", "operation": "select" }		{}	461	insert
✅添加	recruitmentSuper	insertItem	null	sql	{ "table": "student_recruitment", "operation": "insert" }		{}	462	insert
✅更新	recruitmentSuper	updateItem	null	sql	{ "table": "student_recruitment", "operation": "jhUpdate" }		{}	463	insert
✅删除	recruitmentSuper	deleteItem	null	sql	{ "table": "student_recruitment", "operation": "jhDelete" }		{}	464	insert

校长审核

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
校长审核	recruitmentAdmin	showInMenu	null	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	recruitmentAdmin	selectItemList	null	sql	{ "table": "view01_student_recruitment", "operation": "select" }		{}	467	insert
✅更新	recruitmentAdmin	updateItem	{ "after": [ { "service": "recruitment", "serviceFunction": "checkGenerateStudent" } ] }	sql	{ "table": "student_recruitment", "operation": "jhUpdate" }		{}	468	insert

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'recruitmentManagement', '招生数据管理', NULL, 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (33, 'studentRecruitment', '学生报名', NULL, 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (34, 'followUpStudent', '跟进学生', NULL, 'showInMenu', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 'userGroupRole', '权限管理', NULL, 'showInAvatarMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'recruitmentSuper', '资料提交', NULL, 'showInMenu', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'recruitmentAdmin', '校长审核', NULL, 'showInMenu', '3', 'insert', NULL, NULL, NULL);