页面

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 = 43 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
餐厅管理	restaurantManagement	showInMenu	null	7	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅餐厅管理-查询列表	restaurantManagement	selectItemList	null	service	{"service":"restaurant","serviceFunction":"selectRestaurantList"}		{}	331	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅餐厅管理-添加信息	restaurantManagement	insertItem	{ "before": [ { "service": "restaurant", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [] }	sql	{ "table": "restaurant", "operation": "jhInsert" }		{}	332	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅餐厅管理-更新信息	restaurantManagement	updateItem	null	sql	{ "table": "restaurant", "operation": "jhUpdate" }		{}	333	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅餐厅管理-删除信息	restaurantManagement	deleteItem	null	sql	{ "table": "restaurant", "operation": "jhDelete" }		{}	334	update	2022-07-19T13:45:11+08:00	vscode	vscode

一批次餐桌分配

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
一批次餐桌分配	oneBatchStudentAllocation	showInMenu	null	8	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅一批次餐桌分配-查询餐厅信息	oneBatchStudentAllocation	selectRestaurantList	null	sql	{"table":"view01_restaurant","operation":"select"}		{}	351	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅一批次餐桌分配-查询餐桌分配信息	oneBatchStudentAllocation	selectRestaurantStudentList	null	sql	{"table":"view01_restaurant_student","operation":"select"}		{}	352	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅一批次餐桌分配-分配餐桌	oneBatchStudentAllocation	allotSeat	null	service	{"service":"restaurant","serviceFunction":"allotSeat"}		{}	353	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅一批次餐桌分配-查询学生信息	oneBatchStudentAllocation	selectStudentList	null	service	{"service":"restaurant","serviceFunction":"selectStudentList"}		{}	354	update	2022-07-19T13:45:11+08:00	vscode	vscode

二批次餐桌分配

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
二批次餐桌分配	twoBatchStudentAllocation	showInMenu	null	9	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅二批次餐桌分配-查询餐厅信息	twoBatchStudentAllocation	selectRestaurantList	null	sql	{"table":"view01_restaurant","operation":"select"}		{}	368	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅二批次餐桌分配-查询餐桌分配信息	twoBatchStudentAllocation	selectRestaurantStudentList	null	sql	{"table":"view01_restaurant_student","operation":"select"}		{}	369	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅二批次餐桌分配-分配餐桌	twoBatchStudentAllocation	allotSeat	null	service	{"service":"restaurant","serviceFunction":"allotSeat"}		{}	370	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅二批次餐桌分配-查询学生信息	twoBatchStudentAllocation	selectStudentList	null	service	{"service":"restaurant","serviceFunction":"selectStudentList"}		{}	371	update	2022-07-19T13:45:11+08:00	vscode	vscode

餐桌数据导入

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
餐桌数据导入	importRestaurantData	showInMenu	null	10	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅餐桌数据导入-查询餐厅信息	importRestaurantData	selectRestaurantList	null	sql	{"table":"view01_restaurant","operation":"select"}		{}	365	update	2022-07-19T13:45:11+08:00	vscode	vscode
✅餐桌数据导入-导入	importRestaurantData	importRestaurantData	null	service	{"service":"restaurant","serviceFunction":"importRestaurantData"}		{}	366	insert
✅餐桌数据导入-查询学生信息	importRestaurantData	getStudentData	null	sql	{ "table": "view01_student_basic_class", "operation": "select" }		{}	367	insert

学期归档

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
学期归档	semesterArchive	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	semesterArchive	semesterArchive	null	service	{"service": "semester", "serviceFunction": "semesterArchive"}			391	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 (32, 'restaurantManagement', NULL, '餐厅管理', 'showInMenu', '7', 'update', 'vscode', 'vscode', '2022-07-16T22:24:19+08:00');
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'oneBatchStudentAllocation', NULL, '一批次餐桌分配', 'showInMenu', '8', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'twoBatchStudentAllocation', NULL, '二批次餐桌分配', 'showInMenu', '9', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'importRestaurantData', NULL, '餐桌数据导入', 'showInMenu', '10', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'semesterArchive', NULL, '学期归档', 'showInMenu', '5', 'insert', NULL, NULL, NULL);