页面

12079

页面总览

_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',
  `pageHook` varchar(255)  DEFAULT NULL COMMENT 'pageHook',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text ,
  `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 = 174 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

• 页面信息

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

登陆

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		null

• 接口信息

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
结账	checkout-periodCheckout	showInMenu	null	11	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅计算科目余额	checkout-periodCheckout	computeSubjectBalance	null	service	{"service": "period", "serviceFunction": "computeSubjectBalance"}		{}	350	insert
✅试算平衡	checkout-periodCheckout	checkSubjectBalance	null	service	{"service": "period", "serviceFunction": "checkSubjectBalance"}		{}	351	insert
✅查询列表	checkout-periodCheckout	selectItemList	null	sql	{"table": "period", "operation": "select" }		{}	352	insert
✅创建第一个会计期间	checkout-periodCheckout	createPeriodStart	null	service	{"service": "period", "serviceFunction": "createPeriodStart"}		{}	353	insert
✅结账	checkout-periodCheckout	checkout	null	service	{"service": "period", "serviceFunction": "checkout"}		{}	354	insert
✅重新结账All【开发调试】	checkout-periodCheckout	reCheckoutAllPeriod	null	service	{"service": "period", "serviceFunction": "reCheckoutAllPeriod"}		{}	355	insert
✅反结账	checkout-periodCheckout	reverseCheckout	null	service	{"service": "period", "serviceFunction": "reverseCheckout"}		{}	356	insert
✅凭证模板-删除结转凭证	checkout-periodCheckout	voucherTemplate-deleteCheckoutVoucher	null	service	{"service": "period", "serviceFunction": "deleteCheckoutVoucher"}		{}	451	insert
✅凭证模板-查询列表	checkout-periodCheckout	voucherTemplate-getCheckoutVoucherList	null	service	{"service": "period", "serviceFunction": "getCheckoutVoucherList"}		{}	452	insert
✅凭证模板-添加	checkout-periodCheckout	voucherTemplate-insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	sql	{ "table": "voucher_template", "operation": "insert" }		{}	453	insert
✅凭证模板-更新	checkout-periodCheckout	voucherTemplate-updateItem	null	sql	{ "table": "voucher_template", "operation": "jhUpdate" }		{}	454	insert
✅凭证模板-删除	checkout-periodCheckout	voucherTemplate-deleteItem	null	sql	{ "table": "voucher_template", "operation": "jhDelete" }		{}	455	insert
✅查询科目列表	checkout-periodCheckout	voucherTemplate-selectSubjectList	null	sql	{ "table": "view01_subject", "operation": "select" }		{}	456	insert
✅生成结转凭证	checkout-periodCheckout	voucherTemplate-generateCheckoutVoucherList	null	service	{"service": "period", "serviceFunction": "generateCheckoutVoucherList"}		{}	457	insert
✅结账检查	checkout-periodCheckout	checkoutExamine	null	service	{"service": "period", "serviceFunction": "checkoutExamine"}		{}	776	insert

[设置]凭证模版

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]凭证模版	setting-voucherTemplateManagement	showInMenu	null	91	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅凭证模板-查询列表	setting-voucherTemplateManagement	selectVoucherTemplateList	null	sql	{"table": "voucher_template", "operation": "select" }		{}	499	insert

[设置]科目管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]科目管理	setting-subjectManagement	showInMenu	null	92	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	setting-subjectManagement	selectItemList	null	sql	{"table": "subject", "operation": "select" }		{}	361	insert
✅添加	setting-subjectManagement	createSubject		service	{"service": "subject", "serviceFunction": "createSubject"}		{}	362	insert
✅更新	setting-subjectManagement	updateItem	null	service	{"service": "subject", "serviceFunction": "updateSubject"}		{}	363	insert
✅删除	setting-subjectManagement	removeSubject	null	service	{"service": "subject", "serviceFunction": "removeSubject"}		{}	364	insert
✅查询列表	setting-subjectManagement	getAmendSubjectList	null	service	{"service": "subject", "serviceFunction": "getAmendSubjectList"}		{}	740	insert
✅获取外币列表	setting-subjectManagement	getCurrency	null	sql	{ "table": "currency", "operation": "select" }		{}	783	insert

[设置]辅助核算

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]辅助核算	setting-assistManagement	showInMenu	null	94	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

[设置]科目初始设置

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]科目初始设置	setting-subjectBalanceStart	showInMenu	null	93	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询期初设置	setting-subjectBalanceStart	selectSubjectBalanceList	null	sql	{"table": "view01_subject_balance_start", "operation": "select" }		{}	741	insert
✅更新期初设置	setting-subjectBalanceStart	saveSubjectBalanceStart	null	service	{"service": "period", "serviceFunction": "saveSubjectBalanceStart"}		{}	742	insert
✅查询会计期间	setting-subjectBalanceStart	selectPeriodList	null	sql	{"table": "period", "operation": "select" }		{}	743	insert

[设置]币别设置

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]币别设置	setting-currencyManagement	showInMenu	null	95	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

凭证

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
凭证	voucher-voucherManagement	showInMenu	null	21	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	voucher-voucherManagement	selectItemList	null	sql	{ "table": "view01_voucher_entry", "operation": "select" }		{}	381	insert
✅查询下一个凭证号	voucher-voucherManagement	selectNextVoucherNumber	null	service	{"service": "voucher", "serviceFunction": "selectNextVoucherNumber"}		{}	382	insert
✅查询科目列表	voucher-voucherManagement	selectSubjectList	null	sql	{ "table": "view01_subject", "operation": "select" }		{}	384	insert
✅添加凭证和条目	voucher-voucherManagement	createVoucherAndVoucherEntry	null	service	{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}		{}	386	insert
✅删除凭证	voucher-voucherManagement	removeVoucher	null	service	{"service": "voucher", "serviceFunction": "removeVoucher"}		{}	387	insert
✅凭证单据-查询列表	voucher-voucherManagement	file-selectItemList	null	sql	{ "table": "voucher_file", "operation": "select" }		{}	388	insert
✅凭证单据-添加	voucher-voucherManagement	file-insertItem	null	sql	{ "table": "voucher_file", "operation": "insert" }		{}	389	insert
✅凭证单据-更新	voucher-voucherManagement	file-updateItem	null	sql	{ "table": "voucher_file", "operation": "jhUpdate" }		{}	390	insert
✅凭证单据-删除	voucher-voucherManagement	file-deleteItem	null	sql	{ "table": "voucher_file", "operation": "jhDelete" }		{}	391	insert
✅更新凭证和条目	voucher-voucherManagement	updateVoucherAndVoucherEntry	null	service	{"service": "voucher", "serviceFunction": "updateVoucherAndVoucherEntry"}		{}	392	insert
✅凭证-查询辅助信息列表	voucher-voucherManagement	entry-selectAssistList	null	service	{"service": "assist", "serviceFunction": "selectAssistList"}		{}	393	insert
✅查询下一个凭证号	voucher-voucherManagement	selectNextVoucherNumberMap	null	sql	{ "table": "view01_next_voucher_number", "operation": "select" }		{}	500	insert
✅凭证-查询外币列表	voucher-voucherManagement	entry-selectCurrencyList	null	sql	{ "table": "subject", "operation": "select" }		{}	796	insert

[账薄]总账

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]总账	account-generalLedger	showInMenu	null	31	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	account-generalLedger	selectItemList		service	{"service": "account", "serviceFunction": "getItemListOfGeneralLedger"}		{}	401	insert

[账薄]科目余额

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]科目余额	account-subjectBalance	showInMenu	null	33	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	account-subjectBalance	selectItemList	null	sql	{ "table": "view01_subject_balance_period", "operation": "select" }		{}	756	insert

[账薄]明细账

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]明细账	account-subjectDetail	showInMenu	null	35	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询科目列表	account-subjectDetail	selectSubjectList	null	sql	{ "table": "view01_subject_balance_period", "operation": "select" }		{}	403	insert
✅查询列表	account-subjectDetail	selectItemList	null	service	{"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}		{}	404	insert
✅查询科目余额列表	account-subjectDetail	selectSubjectBalancePeriodList	null	sql	{ "table": "view01_subject_balance_period", "operation": "select" }		{}	411	insert
✅添加凭证条目列表	account-subjectDetail	selectVoucherEntryList	null	sql	{ "table": "view01_voucher_entry", "operation": "select" }		{}	412	insert

[账薄]多栏明细账

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]多栏明细账	account-multicolumnLedger	showInMenu	null	36	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	account-multicolumnLedger	selectItemList	null	service	{"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}		{}	405	insert

[账薄]核算项目明细账

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]核算项目明细账	account-auxiliaryDetailedLedger	showInMenu	null	38	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	account-auxiliaryDetailedLedger	selectItemList	null	service	{"service": "account", "serviceFunction": "getItemListOfAuxiliaryDetailedLedger"}		{}	406	insert

[账薄]核算项目余额

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]核算项目余额	account-auxiliaryBalanceSheet	showInMenu	null	37	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	account-auxiliaryBalanceSheet	selectItemList	null	service	{"service": "account", "serviceFunction": "getItemListOfAuxiliaryBalanceSheet"}		{}	407	insert

[账薄]序时账

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]序时账	account-chronological	showInMenu	null	34	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	account-chronological	selectItemList	null	sql	{ "table": "view01_voucher_entry", "operation": "select" }		{}	408	insert

[账薄]科目汇总

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[账薄]科目汇总	account-subjectSummary	showInMenu	null	32	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	account-subjectSummary	selectItemList	null	service	{"service": "account", "serviceFunction": "getItemListOfSubjectBalance"}		{}	413	insert

[报表]资产负债

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]资产负债	report-assetLiability	showInMenu	null	41	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询资产负债列表	report-assetLiability	getItemListOfAssetLiability	null	service	{"service": "report", "serviceFunction": "getItemListOfAssetLiability"}		{}	420	insert
✅查询科目列表	report-assetLiability	selectSubjectList	null	sql	{ "table": "view01_subject", "operation": "select" }		{}	422	insert
✅获取公式列表	report-assetLiability	selectFormulaList	null	sql	{ "table": "view02_report_asset_liability_formula", "operation": "select" }		{}	423	insert
✅保存公式列表	report-assetLiability	saveFormulaListOfAssetLiability	null	service	{"service": "report", "serviceFunction": "saveFormulaListOfAssetLiability"}		{}	424	insert
✅删除公式	report-assetLiability	deleteFormulaItem	null	sql	{ "table": "report_asset_liability_formula", "operation": "delete" }		{}	425	insert

[报表]利润

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]利润	report-profit	showInMenu	null	42	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询利润列表	report-profit	getItemListOfProfit	null	service	{"service": "report", "serviceFunction": "getItemListOfProfit"}		{}	430	insert
✅查询科目列表	report-profit	selectSubjectList	null	sql	{ "table": "view01_subject", "operation": "select" }		{}	432	insert
✅获取公式列表	report-profit	selectFormulaList	null	sql	{ "table": "view02_report_profit_formula", "operation": "select" }		{}	433	insert
✅保存公式列表	report-profit	saveFormulaListOfAssetLiability	null	service	{"service": "report", "serviceFunction": "saveFormulaListOfProfit"}		{}	434	insert
✅删除公式	report-profit	deleteFormulaItem	null	sql	{ "table": "report_profit_formula", "operation": "delete" }		{}	435	insert

[报表]利润季报

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]利润季报	report-profitQuarter	showInMenu	null	44	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询利润列表-季度	report-profitQuarter	getItemListOfProfitOfQuarter	null	service	{"service": "report", "serviceFunction": "getItemListOfProfitOfQuarter"}		{}	716	insert

[报表]现金流量季报

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]现金流量季报	report-cashFlowQuarter	showInMenu	null	45	null

[报表]附-去年凭证

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]附-去年凭证	report-subjectBalanceYearStartAdjust	showInMenu	null	49	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询会计期间	report-subjectBalanceYearStartAdjust	selectPeriodList	null	sql	{"table": "period", "operation": "select" }		{}	375	insert
✅查询科目余额-年	report-subjectBalanceYearStartAdjust	selectSubjectBalanceYearList	null	sql	{"table": "view01_subject_balance_year", "operation": "select" }		{}	376	insert
✅查询科目余额-年	report-subjectBalanceYearStartAdjust	selectVoucherEntryList	null	sql	{"table": "view01_voucher_entry", "operation": "select" }		{}	377	insert

[报表]财务概要信息

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]财务概要信息	report-summary	showInMenu	null	48	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询财务概要信息列表	report-summary	getItemListOfSummary	null	service	{"service": "report", "serviceFunction": "getItemListOfSummary"}		{}	447	insert

[报表]部门利润表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]部门利润表	report-profitDept	showInMenu	null	46	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询部门列表	report-profitDept	selectAssistDepartList	null	sql	{"table": "assist_depart", "operation": "select" }		{}	436	insert
✅查询利润列表-部门	report-profitDept	getItemListOfProfitOfAssist	null	service	{"service": "report", "serviceFunction": "getItemListOfProfitOfAssist"}		{}	717	insert

[报表]项目利润表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]项目利润表	report-profitProject	showInMenu	null	47	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询辅助核算列表	report-profitProject	selectAssistList	null	service	{"service": "assist", "serviceFunction": "selectAssistList"}		{}	437	insert
✅查询利润列表-部门	report-profitProject	getItemListOfProfitOfAssist	null	service	{"service": "report", "serviceFunction": "getItemListOfProfitOfAssist"}		{}	718	insert
✅查询项目列表	report-profitProject	selectAssistProjectList	null	sql	{"table": "assist_project", "operation": "select" }		{}	719	insert

[报表]现金流量【旧】

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]现金流量【旧】	report-cashFlow		null	43	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询现金流列表	report-cashFlow	getItemListOfCashFlow	null	service	{"service": "report", "serviceFunction": "getItemListOfCashFlow"}		{}	440	insert
✅查询现金流EX列表	report-cashFlow	ex-getItemListOfCashFlowEx	null	service	{"service": "report", "serviceFunction": "getItemListOfCashFlowEx"}		{}	441	insert
✅查询科目列表	report-cashFlow	ex-selectSubjectList	null	sql	{ "table": "view01_subject", "operation": "select" }		{}	442	insert
✅获取公式列表	report-cashFlow	ex-selectFormulaList	null	sql	{ "table": "view02_report_cash_flow_ex_formula", "operation": "select" }		{}	443	insert
✅保存公式列表	report-cashFlow	ex-saveFormulaListOfCashFlowEx	null	service	{"service": "report", "serviceFunction": "saveFormulaListOfCashFlowEx"}		{}	444	insert
✅删除公式	report-cashFlow	ex-deleteFormulaItem	null	sql	{ "table": "report_cash_flow_ex_formula", "operation": "delete" }		{}	445	insert
✅查询现金流列表	report-cashFlow	getItemListOfCashFlowForPeriodIdList	null	service	{"service": "report", "serviceFunction": "getItemListOfCashFlowForPeriodIdList"}		{}	446	insert
✅查询现金流列表	report-cashFlow	getItemListOfCashFlowOfQuarter	null	service	{"service": "report", "serviceFunction": "getItemListOfCashFlowOfQuarter"}		{}	720	insert
✅获取现金流量的凭证列表	report-cashFlow	getSubjectCashflowVoucherList	null	service	{"service": "subject", "serviceFunction": "getSubjectCashflowVoucherList"}		{}	774	insert

[报表]现金流量

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[报表]现金流量	report-cashFlow3	showInMenu	null	43	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅更新年中数	report-cashFlow3	updateCashFlowMidYear	null	sql	{ "table": "report_cash_flow_item3", "operation": "jhUpdate" }		{}	775	insert
✅查询现金流列表	report-cashFlow3	getItemListOfCashFlow	null	service	{"service": "report", "serviceFunction": "getItemListOfCashFlow3"}		{}	784	insert

凭证-打印凭证

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
凭证-打印凭证	voucher-printVoucher	dynamicInMenu	null	44	{"beforeHook": [{"service": "voucher", "serviceFunc": "appendVoucherInfoPageBeforeHook", "field": "voucherInfo"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

[资金]账户设置

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[资金]账户设置	fundAccountManagement	showInMenu	null	46	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	fundAccountManagement	selectItemList		sql	{ "table": "fund_account", "operation": "select" }		{}	490	insert
✅添加	fundAccountManagement	insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	sql	{ "table": "fund_account", "operation": "insert" }		{}	491	insert
✅更新	fundAccountManagement	updateItem	null	sql	{ "table": "fund_account", "operation": "jhUpdate" }		{}	492	insert
✅删除	fundAccountManagement	deleteItem	null	sql	{ "table": "fund_account", "operation": "jhDelete" }		{}	493	insert
✅账户设置-获取会计科目	fundAccountManagement	selectSubjectList		sql	{"table": "subject", "operation": "select" }		{}	498	insert
✅查询资金报表分组	fundAccountManagement	getStatementGroup	null	service	{"service": "fundAccountEntry", "serviceFunction": "getStatementGroup"}		{}	721	insert

[资金]账户日记帐

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[资金]账户日记帐	fundAccountEntryManagement	showInMenu	null	47	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	fundAccountEntryManagement	selectItemList	null	sql	{ "table": "view01_fund_account_entry", "operation": "select" }		{}	494	insert
✅添加	fundAccountEntryManagement	insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] }	sql	{ "table": "fund_account_entry", "operation": "insert" }		{}	495	insert
✅更新	fundAccountEntryManagement	updateItem	null	sql	{ "table": "fund_account_entry", "operation": "jhUpdate" }		{}	496	insert
✅删除	fundAccountEntryManagement	deleteItem	{ "after": [ { "service": "fundAccountEntry", "serviceFunction": "removeVoucher" } ] }	sql	{ "table": "fund_account_entry", "operation": "jhDelete" }		{}	497	insert
✅添加凭证和条目	fundAccountEntryManagement	createVoucherAndVoucherEntry	{ "after": [ { "service": "voucher", "serviceFunction": "relAccountEntryVoucherIdAfterHook" } ] }	service	{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}		{}	501	insert
✅导入日记账记录	fundAccountEntryManagement	importFundAccountEntryData	null	service	{"service": "fundAccountEntry", "serviceFunction": "importFundAccountEntryData"}			502	insert

发票

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
发票	invoice-invoiceManagement	showInMenu	null	55	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	invoice-invoiceManagement	selectItemList	null	service	{"service": "invoice", "serviceFunction": "selectInvoice"}		{}	600	insert
✅查询模板列表	invoice-invoiceManagement	selectTemplateList	null	sql	{ "table": "voucher_template", "operation": "select" }		{}	601	insert
✅更新发票	invoice-invoiceManagement	updateItem	null	service	{"service": "invoice", "serviceFunction": "updateItem"}		{}	603	insert
✅删除模板	invoice-invoiceManagement	deleteItem	null	service	{"service": "invoice", "serviceFunction": "deleteItem"}		{}	604	insert
✅新建发票	invoice-invoiceManagement	createItem	null	service	{"service": "invoice", "serviceFunction": "createItem"}		{}	605	insert
✅查询客户列表	invoice-invoiceManagement	selectCustomerList	null	sql	{ "table": "assist_customer", "operation": "select" }		{}	606	insert
✅查询供应商列表	invoice-invoiceManagement	selectSupplierList	null	sql	{ "table": "assist_supplier", "operation": "select" }		{}	607	insert
✅查询发票详情数据	invoice-invoiceManagement	selectEntryList	null	sql	{ "table": "invoice_entry", "operation": "select" }		{}	608	insert
✅添加凭证和条目	invoice-invoiceManagement	createVoucherAndVoucherEntry	{ "after": [ { "service": "invoice", "serviceFunction": "syncVoucherIdToInvoice" } ] }	service	{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}		{}	609	insert
✅添加凭证和条目	invoice-invoiceManagement	deleteSelected		service	{"service": "invoice", "serviceFunction": "deleteSelected"}		{}	610	insert

[资金]内部转账

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[资金]内部转账	fundAccountTransferEntryManagement	showInMenu	null	48	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅导入资金转账数据	fundAccountTransferEntryManagement	importFundAccountTransferEntryData	null	service	{"service": "fundAccountTransferEntry", "serviceFunction": "importFundAccountTransferEntryData"}			623	insert
✅查询列表	fundAccountTransferEntryManagement	selectItemList	null	sql	{ "table": "view01_voucher_transfer_entry", "operation": "select" }		{}	624	insert
✅添加	fundAccountTransferEntryManagement	insertItem	{ "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "fundAccountTransferEntry", "serviceFunction": "createFundAccountEntryAfterHook" } ] }	sql	{ "table": "fund_account_transfer_entry", "operation": "insert" }		{}	625	insert
✅更新	fundAccountTransferEntryManagement	updateItem	null	sql	{ "table": "fund_account_transfer_entry", "operation": "jhUpdate" }		{}	626	insert
✅删除	fundAccountTransferEntryManagement	deleteItem	null	sql	{ "table": "fund_account_transfer_entry", "operation": "jhDelete" }		{}	627	insert

[资金]资金报表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[资金]资金报表	fundStatementManagement	showInMenu	null	49	null

[工资]工资管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[工资]工资管理	salary-salaryManagement	showInMenu	null	67	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询工资员工列表	salary-salaryManagement	selectEmployeeList	null	sql	{ "table": "employee", "operation": "select" }		{}	700	insert
✅更新默认五险一金常量	salary-salaryManagement	insuranceConfig	null	sql	{ "table": "_constant", "operation": "jhUpdate", "where": {"constantKey":"defaultMemberInsuranceConfig"} }		{}	702	insert
✅录入员工信息	salary-salaryManagement	createEmployee	null	sql	{ "table": "employee", "operation": "insert" }		{}	703	insert
✅修改员工信息	salary-salaryManagement	updateEmployee	null	sql	{ "table": "employee", "operation": "jhUpdate" }		{}	704	insert
✅删除员工信息	salary-salaryManagement	deleteEmployee	null	sql	{ "table": "employee", "operation": "jhDelete" }		{}	705	insert
✅查询工资列表	salary-salaryManagement	selectItemList	null	sql	{ "table": "view01_employee_salary_record", "operation": "select" }		{}	706	insert
✅检查是否需要生成工资表	salary-salaryManagement	createListFromEmployee	null	service	{"service": "salary", "serviceFunction": "createListFromEmployee"}		{}	707	insert
✅保存工资配置项目	salary-salaryManagement	saveCustomSalaryProject	null	service	{ "service": "salary", "serviceFunction": "saveCustomSalaryProject" }		{}	708	insert
✅保存工资变动	salary-salaryManagement	saveChanged	null	service	{ "service": "salary", "serviceFunction": "saveChanged" }		{}	709	insert
✅获取月度工资表	salary-salaryManagement	selectMonthItemList	null	sql	{ "table": "salary_month_record", "operation": "select" }		{}	710	insert
✅获取月度工资凭证模板	salary-salaryManagement	selectTemplateList	null	sql	{ "table": "voucher_template", "operation": "select" }		{}	711	insert
✅创建工资凭证	salary-salaryManagement	createVoucherAndVoucherEntry	{ "after": [ { "service": "salary", "serviceFunction": "syncVoucherIdToInvoice" } ] }	service	{ "service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry" }		{}	712	insert
✅删除工资条	salary-salaryManagement	deleteSelected	null	service	{ "service": "salary", "serviceFunction": "deleteSelected" }		{}	713	insert
✅导入数据	salary-salaryManagement	importExcel	null	service	{ "service": "salary", "serviceFunction": "importExcel" }		{}	714	insert
✅导入员工数据	salary-salaryManagement	importEmployeeData	null	service	{"service": "employee", "serviceFunction": "importEmployeeData"}		{}	760	insert

[工资]五险一金配置

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[工资]五险一金配置	salary-insuranceConfigManagement	showInMenu	null	65	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

[工资]员工管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[工资]员工管理	salary-employeeManagement	showInMenu	null	66	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

用户管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
用户管理	userManagement	showInAvatarMenu	null	6	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅用户管理-查询信息	userManagement	selectItemList	null	sql	{"table": "_user", "operation": "select"}			611	update	2022-04-29T16:33:28+08:00			{"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "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": "1651221207913_1347965", "packageType": "httpRequest"}	{"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"}
✅用户管理-查询信息	userManagement	insertItem	null	service	{"service": "userManagement", "serviceFunction": "addUser"}			612	update	2022-04-28T16:36:00+08:00			{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "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": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"}	{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"}
✅用户管理-修改密码	userManagement	resetUserPassword	null	service	{"service": "userManagement", "serviceFunction": "resetUserPassword"}			613	update	2022-04-28T16:37:21+08:00			{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "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": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"}	{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"}
✅用户管理-更新用户	userManagement	updateItem	null	sql	{"table": "_user", "operation": "jhUpdate"}			614	update	2022-04-29T16:33:27+08:00			{"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "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": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"}

[设置]帐套管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]帐套管理	appAccountManagement	showInMenu	null	90	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	appAccountManagement	selectItemList	null	service	{"service": "appAccount", "serviceFunction": "selectAppAccountList"}		{}	615	insert
✅添加账套	appAccountManagement	createAppAcount	null	service	{"service": "appAccount", "serviceFunction": "createAppAcount"}		{}	616	insert
✅更新	appAccountManagement	updateItem	null	sql	{ "table": "_app_account", "operation": "jhUpdate" }		{}	617	insert
✅初始化账套配置表	appAccountManagement	initAppAccountConfigTable	null	service	{"service": "appAccount", "serviceFunction": "initAppAcountConfigTable"}		{}	618	insert
✅导入账套数据-科目列表	appAccountManagement	importAppAccountDataOfSubjectList	null	service	{"service": "appAccount", "serviceFunction": "importAppAccountDataOfSubjectList"}		{}	619	insert
✅导入账套数据-凭证列表	appAccountManagement	importAppAccountDataOfVoucherList	null	service	{"service": "appAccount", "serviceFunction": "importAppAccountDataOfVoucherList"}		{}	620	insert
✅计算科目余额	appAccountManagement	reCheckoutAllPeriod	null	service	{"service": "appAccount", "serviceFunction": "reCheckoutAllPeriod"}		{}	621	insert
✅查询科目列表	appAccountManagement	selectSubjectList	null	sql	{"table": "view01_subject", "operation": "select" }		{}	622	insert
✅套账-获取用户列表	appAccountManagement	selectUserList	null	sql	{"table": "_view01_user", "operation": "select"}		{}	715	insert
✅查询账薄是否有凭证	appAccountManagement	checkAppAccountExistVoucher	null	service	{"service": "appAccount", "serviceFunction": "checkAppAccountExistVoucher"}		{}	730	insert
✅更新账薄	appAccountManagement	updateAppAcount	null	service	{"service": "appAccount", "serviceFunction": "updateAppAcount"}		{}	731	insert
✅删除账套	appAccountManagement	deleteAppAccount	null	service	{"service": "appAccount", "serviceFunction": "deleteAppAccount"}		{}	757	insert
✅账套信息更新	appAccountManagement	updateAppAccountData	null	service	{"service": "appAccount", "serviceFunction": "updateAppAccountData"}		{}	797	insert

[资金]核对总账

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[资金]核对总账	fundLedgerManagement	showInMenu	null	50	null

[设置]归档管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]归档管理	setting-archiveManagement	showInMenu	null	96	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅账套归档	setting-archiveManagement	archiveAppAcount	null	service	{"service": "appAccount", "serviceFunction": "archiveAppAcount"}		{}	781	insert
✅获取账套归档列表	setting-archiveManagement	getArchiveList	null	sql	{ "table": "app_account_file", "operation": "select" }		{}	782	insert

[设置]操作日志

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]操作日志	setting-recordHistoryManagement	showInMenu	null	96	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询操作记录	setting-recordHistoryManagement	selectItemList	null	sql	{ "table": "_record_history", "operation": "select" }		{}	790	insert

[设置]科目现金流量对照

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[设置]科目现金流量对照	setting-subjectCashManagement2	showInMenu	null	95	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅现金流量列表	setting-subjectCashManagement2	getCashflowList	null	sql	{ "table": "report_cash_flow_item3", "operation": "select" }		{}	792	insert
✅科目和现金流对照表	setting-subjectCashManagement2	getSubjectCashflowList	null	sql	{ "table": "subject", "operation": "select" }		{}	793	insert
✅更新科目和现金流对照表	setting-subjectCashManagement2	updateSubjectCashflow	null	sql	{ "table": "subject", "operation": "jhUpdate" }		{}	794	insert
✅重置科目和现金流对照表	setting-subjectCashManagement2	resetSubjectCashflow	null	service	{"service": "subject", "serviceFunction": "resetSubjectCashflow"}		{}	795	insert

通知/待办

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
通知/待办	https://demo.jianghujs.org/task/page/noticeManagement	showInRightMenu	null	null	null

_page语句

INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', NULL, '帮助', 'dynamicInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'login', 'loginV4', NULL, '登陆', '', NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'checkout-periodCheckout', NULL, NULL, '结账', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'setting-voucherTemplateManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]凭证模版', 'showInMenu', NULL, '91', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'setting-subjectManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]科目管理', 'showInMenu', NULL, '92', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'setting-assistManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]辅助核算', 'showInMenu', NULL, '94', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'setting-subjectBalanceStart', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]科目初始设置', 'showInMenu', NULL, '93', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'setting-currencyManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]币别设置', 'showInMenu', NULL, '95', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'voucher-voucherManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '凭证', 'showInMenu', NULL, '21', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'account-generalLedger', NULL, NULL, '[账薄]总账', 'showInMenu', NULL, '31', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'account-subjectBalance', NULL, NULL, '[账薄]科目余额', 'showInMenu', NULL, '33', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (73, 'account-subjectDetail', NULL, NULL, '[账薄]明细账', 'showInMenu', NULL, '35', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'account-multicolumnLedger', NULL, NULL, '[账薄]多栏明细账', 'showInMenu', NULL, '36', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (75, 'account-auxiliaryDetailedLedger', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[账薄]核算项目明细账', 'showInMenu', NULL, '38', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (76, 'account-auxiliaryBalanceSheet', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[账薄]核算项目余额', 'showInMenu', NULL, '37', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (77, 'account-chronological', NULL, NULL, '[账薄]序时账', 'showInMenu', NULL, '34', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (78, 'account-subjectSummary', NULL, NULL, '[账薄]科目汇总', 'showInMenu', NULL, '32', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (81, 'report-assetLiability', NULL, NULL, '[报表]资产负债', 'showInMenu', NULL, '41', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (82, 'report-profit', NULL, NULL, '[报表]利润', 'showInMenu', NULL, '42', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'report-profitQuarter', NULL, NULL, '[报表]利润季报', 'showInMenu', NULL, '44', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (85, 'report-cashFlowQuarter', NULL, NULL, '[报表]现金流量季报', 'showInMenu', NULL, '45', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (86, 'report-subjectBalanceYearStartAdjust', NULL, NULL, '[报表]附-去年凭证', 'showInMenu', NULL, '49', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (87, 'report-summary', NULL, NULL, '[报表]财务概要信息', 'showInMenu', NULL, '48', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (88, 'report-profitDept', NULL, NULL, '[报表]部门利润表', 'showInMenu', NULL, '46', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (89, 'report-profitProject', NULL, NULL, '[报表]项目利润表', 'showInMenu', NULL, '47', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (90, 'report-cashFlow', NULL, NULL, '[报表]现金流量【旧】', '', NULL, '43', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (92, 'report-cashFlow3', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[报表]现金流量', 'showInMenu', NULL, '43', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (93, 'voucher-printVoucher', NULL, '{"beforeHook": [{"service": "voucher", "serviceFunc": "appendVoucherInfoPageBeforeHook", "field": "voucherInfo"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '凭证-打印凭证', 'dynamicInMenu', NULL, '44', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (94, 'fundAccountManagement', NULL, NULL, '[资金]账户设置', 'showInMenu', NULL, '46', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (95, 'fundAccountEntryManagement', NULL, NULL, '[资金]账户日记帐', 'showInMenu', NULL, '47', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (96, 'invoice-invoiceManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '发票', 'showInMenu', NULL, '55', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (97, 'fundAccountTransferEntryManagement', NULL, NULL, '[资金]内部转账', 'showInMenu', NULL, '48', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (98, 'fundStatementManagement', NULL, NULL, '[资金]资金报表', 'showInMenu', NULL, '49', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (120, 'salary-salaryManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[工资]工资管理', 'showInMenu', NULL, '67', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (121, 'salary-insuranceConfigManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[工资]五险一金配置', 'showInMenu', NULL, '65', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (122, 'salary-employeeManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[工资]员工管理', 'showInMenu', NULL, '66', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (123, 'userManagement', NULL, NULL, '用户管理', 'showInAvatarMenu', NULL, '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (125, 'appAccountManagement', NULL, NULL, '[设置]帐套管理', 'showInMenu', NULL, '90', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (127, 'fundLedgerManagement', NULL, NULL, '[资金]核对总账', 'showInMenu', NULL, '50', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (129, 'setting-archiveManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]归档管理', 'showInMenu', NULL, '96', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (130, 'setting-recordHistoryManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]操作日志', 'showInMenu', NULL, '96', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (131, 'setting-subjectCashManagement2', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[设置]科目现金流量对照', 'showInMenu', NULL, '95', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (173, 'https://demo.jianghujs.org/task/page/noticeManagement', NULL, NULL, '通知/待办', 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, 'insert', NULL, NULL, NULL);