页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `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 = 52 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	update	2022-04-27T15:32:57+08:00

账单管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
账单管理	billManagement	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅账单管理-确认	billManagement	confirmItem	null	service	{"service": "bill", "serviceFunction": "confirmItem"}		{}	441	insert
✅账单管理-查询	billManagement	selectItemList	null	service	{"service": "bill", "serviceFunction": "selectItemList"}		{}	442	insert
✅账单管理-删除	billManagement	deleteItem	null	service	{"service": "bill", "serviceFunction": "deleteItem"}		{}	443	insert
✅账单管理-添加	billManagement	insertItem		service	{"service": "bill", "serviceFunction": "addBill"}		{}	444	insert
✅账单管理-查询缴费明细	billManagement	selectPaymentRecordList	null	sql	{ "table": "payment_record", "operation": "select" }		{}	445	insert
✅账单管理-更新	billManagement	updateItem	null	sql	{"service": "bill", "serviceFunction": "updateBill"}		{}	446	insert
✅账单管理-查询学生数据	billManagement	selectStudentList	null	service	{"service": "bill", "serviceFunction": "selectStudentList"}		{}	447	insert
✅账单管理-删除缴费明细	billManagement	deletePaymentRecord	null	service	{"service": "bill", "serviceFunction": "deletePaymentRecord"}		{}	452	insert
✅账单管理-添加缴费记录	billManagement	addPaymentRecord	null	service	{"service": "bill", "serviceFunction": "addPaymentRecord"}		{}	453	insert
✅账单管理-结束当前学年	billManagement	lockCurrentSemester	null	service	{"service": "bill", "serviceFunction": "lockCurrentSemester"}		{}	457	insert
✅账单管理-编辑缴费状态	billManagement	completedPayment	null	sql	{ "table": "bill", "operation": "jhUpdate" }			458	insert
✅账单管理-账单批次	billManagement	selectBillBatchList	null	sql	{ "table": "view01_bill_batch", "operation": "select" }			459	insert

奖学金管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
奖学金管理	scholarshipManagement	showInMenu	null	6	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅奖学金管理-转出	scholarshipManagement	scholarshipTransfer	{ "before": [ { "service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "scholarship", "serviceFunction": "updateScholarship" } ] }	sql	{ "table": "student_scholarship_record", "operation": "insert" }		{}	425	insert
✅奖学金管理-查询	scholarshipManagement	selectItemList	null	sql	{ "table": "view01_student_scholarship", "operation": "select" }		{}	426	insert
✅奖学金管理-添加	scholarshipManagement	insertItem	{ "before": [ { "service": "scholarship", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "scholarship", "serviceFunction": "updateScholarship" } ] }	sql	{ "table": "student_scholarship_record", "operation": "insert" }		{}	427	insert
✅奖学金管理-查询明细	scholarshipManagement	selectRecordList	null	sql	{ "table": "view01_student_scholarship_record", "operation": "select" }		{}	428	insert
✅奖学金管理-查询学生数据	scholarshipManagement	selectStudentList	null	service	{"service": "scholarship", "serviceFunction": "selectStudentList"}		{}	429	insert
✅奖学金管理-学期奖学金余额	scholarshipManagement	semesterAmount	null	service	{"service": "scholarship", "serviceFunction": "setSemesterAmount"}		{}	430	insert
✅修改明细	scholarshipManagement	updateRecordItem	{ "before": [ { "service": "scholarship", "serviceFunction": "prepareUpdateRecordValidate" } ], "after": [ { "service": "scholarship", "serviceFunction": "updateScholarship" } ] }	sql	{ "table": "student_scholarship_record", "operation": "jhUpdate" }		{}	454	insert
✅删除明细	scholarshipManagement	deleteRecordItem	{ "before": [ { "service": "scholarship", "serviceFunction": "prepareDeleteRecordValidate" } ], "after": [ { "service": "scholarship", "serviceFunction": "updateScholarship" } ] }	sql	{ "table": "student_scholarship_record", "operation": "jhDelete" }		{}	455	insert

缴费信息导入

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
缴费信息导入	paymentImport	showInMenu	null	5	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅缴费信息导入-数据校验	paymentImport	checkImportData	null	service	{"service": "payment", "serviceFunction": "checkImportData"}		{}	449	insert
✅缴费信息导入-导入	paymentImport	importPaymentData	null	service	{"service":"payment","serviceFunction":"importPaymentData"}		{}	450	insert

奖学金导入

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
奖学金导入	scholarshipImport	showInMenu	null	6	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅奖学金导入-导入	scholarshipImport	importScholarshipData	null	service	{"service":"scholarship","serviceFunction":"importScholarshipData"}		{}	431	insert
✅奖学金导入-查询学生信息	scholarshipImport	getStudentData	null	sql	{ "table": "view00_student_basic_class", "operation": "select" }		{}	432	insert

账单批次

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
账单批次	billBatchManagement	showInMenu	null	4	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅账单批次-查询列表	billBatchManagement	selectItemList	null	sql	{ "table": "view01_bill_batch", "operation": "select" }		{}	435	insert
✅账单批次-添加	billBatchManagement	insertItem	{ "before": [ { "service": "billBatch", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [] }	sql	{ "table": "bill_batch", "operation": "insert" }		{}	436	insert
✅账单批次-更新	billBatchManagement	updateItem	null	sql	{ "table": "bill_batch", "operation": "jhUpdate" }		{}	437	insert
✅账单批次-删除	billBatchManagement	deleteItem	null	sql	{ "table": "bill_batch", "operation": "jhDelete" }		{}	438	insert
✅账单批次-获取学生数据	billBatchManagement	selectStudentList	null	sql	{ "table": "view00_student_basic_class", "operation": "select" }		{}	439	insert
✅账单批次-生成账单	billBatchManagement	generateBill	null	service	{"service": "billBatch", "serviceFunction": "generateBill"}		{}	440	insert
✅账单批次-结束生成账单	billBatchManagement	endBillGenerate	null	sql	{ "table": "bill_batch", "operation": "jhUpdate" }		{}	456	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 (45, 'billManagement', NULL, '账单管理', 'showInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'scholarshipManagement', NULL, '奖学金管理', 'showInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'paymentImport', NULL, '缴费信息导入', 'showInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'scholarshipImport', NULL, '奖学金导入', 'showInMenu', '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'billBatchManagement', NULL, '账单批次', 'showInMenu', '4', 'insert', NULL, NULL, NULL);