Interface

12079

Interface Overview

_resource Structure

CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255)  DEFAULT NULL COMMENT 'Data rule control table',
  `resourceHook` text  COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'Page ID; E.g: index',
  `actionId` varchar(255)  DEFAULT NULL COMMENT 'Action ID; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `resourceType` varchar(255)  DEFAULT NULL COMMENT 'Resource type; E.g: auth service sql',
  `appDataSchema` text  COMMENT 'AppData parameter validation',
  `resourceData` text  COMMENT 'Resource data; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text  COMMENT 'Request demo',
  `responseDemo` text  COMMENT 'Response demo',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 798 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Request resource table; Soft delete not enabled; resourceId=`${appId}.${pageId}.${actionId}`'

_resource Content

id	desc	pageId	actionId	resourceType	resourceHook	resourceData
231	✅ Login	login	passwordLogin	service		{"service": "user", "serviceFunction": "passwordLogin"}
251	✅ Logout	allPage	logout	service		{"service": "user", "serviceFunction": "logout"}
253	✅ Get User Info	allPage	userInfo	service		{"service": "user", "serviceFunction": "userInfo"}
258	✅ Query Constants	allPage	getConstantList	sql		{"table": "_constant", "operation": "select"}
259	✅ Query Accounting Period List	allPage	selectPeriodList	sql		{"table": "period", "operation": "select" }
261	✅ File Chunk Upload - All Chunks Uploaded	allPage	uploadFileDone	service		{"service": "file", "serviceFunction": "uploadFileDone"}
262	✅ File Chunk Upload - HTTP File Stream	allPage	httpUploadByStream	service		{"service": "file", "serviceFunction": "uploadFileChunkByStream"}
263	✅ Query Subject List	allPage	selectSubjectList	sql		{"table": "view01_subject", "operation": "select" }
264	✅ Voucher - Query Auxiliary Info List	allPage	selectAssistList	service		{"service": "assist", "serviceFunction": "selectAssistList"}
265	✅ Query List	allPage	selectVoucherList	sql		{ "table": "view01_voucher_entry", "operation": "select" }
266	✅ Query Subject List	allPage	selectSubjectListByPeriod	sql		{"table": "view01_subject_balance_period", "operation": "select" }
267	✅ Query Account Set List	allPage	selectAppAccountList	service		{"service": "appAccount", "serviceFunction": "selectAppAccountList"}
268	✅ Query User List	allPage	selectUserList	sql		{"table": "_user", "operation": "select" }
350	✅ Calculate Subject Balance	checkout-periodCheckout	computeSubjectBalance	service		{"service": "period", "serviceFunction": "computeSubjectBalance"}
351	✅ Trial Balance	checkout-periodCheckout	checkSubjectBalance	service		{"service": "period", "serviceFunction": "checkSubjectBalance"}
352	✅ Query List	checkout-periodCheckout	selectItemList	sql		{"table": "period", "operation": "select" }
353	✅ Create First Accounting Period	checkout-periodCheckout	createPeriodStart	service		{"service": "period", "serviceFunction": "createPeriodStart"}
354	✅ Checkout	checkout-periodCheckout	checkout	service		{"service": "period", "serviceFunction": "checkout"}
355	✅ Re-checkout All [Development Debugging]	checkout-periodCheckout	reCheckoutAllPeriod	service		{"service": "period", "serviceFunction": "reCheckoutAllPeriod"}
356	✅ Reverse Checkout	checkout-periodCheckout	reverseCheckout	service		{"service": "period", "serviceFunction": "reverseCheckout"}
361	✅ Query List	setting-subjectManagement	selectItemList	sql		{"table": "subject", "operation": "select" }
362	✅ Add	setting-subjectManagement	createSubject	service		{"service": "subject", "serviceFunction": "createSubject"}
363	✅ Update	setting-subjectManagement	updateItem	service		{"service": "subject", "serviceFunction": "updateSubject"}
364	✅ Delete	setting-subjectManagement	removeSubject	service		{"service": "subject", "serviceFunction": "removeSubject"}
375	✅ Query Accounting Period	report-subjectBalanceYearStartAdjust	selectPeriodList	sql		{"table": "period", "operation": "select" }
376	✅ Query Subject Balance - Year	report-subjectBalanceYearStartAdjust	selectSubjectBalanceYearList	sql		{"table": "view01_subject_balance_year", "operation": "select" }
377	✅ Query Subject Balance - Year	report-subjectBalanceYearStartAdjust	selectVoucherEntryList	sql		{"table": "view01_voucher_entry", "operation": "select" }
381	✅ Query List	voucher-voucherManagement	selectItemList	sql		{ "table": "view01_voucher_entry", "operation": "select" }
382	✅ Query Next Voucher Number	voucher-voucherManagement	selectNextVoucherNumber	service		{"service": "voucher", "serviceFunction": "selectNextVoucherNumber"}
384	✅ Query Subject List	voucher-voucherManagement	selectSubjectList	sql		{ "table": "view01_subject", "operation": "select" }
386	✅ Add Voucher and Entry	voucher-voucherManagement	createVoucherAndVoucherEntry	service		{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}
387	✅ Delete Voucher	voucher-voucherManagement	removeVoucher	service		{"service": "voucher", "serviceFunction": "removeVoucher"}
388	✅ Voucher Document - Query List	voucher-voucherManagement	file-selectItemList	sql		{ "table": "voucher_file", "operation": "select" }
389	✅ Voucher Document - Add	voucher-voucherManagement	file-insertItem	sql		{ "table": "voucher_file", "operation": "insert" }
390	✅ Voucher Document - Update	voucher-voucherManagement	file-updateItem	sql		{ "table": "voucher_file", "operation": "jhUpdate" }
391	✅ Voucher Document - Delete	voucher-voucherManagement	file-deleteItem	sql		{ "table": "voucher_file", "operation": "jhDelete" }
392	✅ Update Voucher and Entry	voucher-voucherManagement	updateVoucherAndVoucherEntry	service		{"service": "voucher", "serviceFunction": "updateVoucherAndVoucherEntry"}
393	✅ Voucher - Query Auxiliary Info List	voucher-voucherManagement	entry-selectAssistList	service		{"service": "assist", "serviceFunction": "selectAssistList"}
401	✅ Query List	account-generalLedger	selectItemList	service		{"service": "account", "serviceFunction": "getItemListOfGeneralLedger"}
403	✅ Query Subject List	account-subjectDetail	selectSubjectList	sql		{ "table": "view01_subject_balance_period", "operation": "select" }
404	✅ Query List	account-subjectDetail	selectItemList	service		{"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}
405	✅ Query List	account-multicolumnLedger	selectItemList	service		{"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}
406	✅ Query List	account-auxiliaryDetailedLedger	selectItemList	service		{"service": "account", "serviceFunction": "getItemListOfAuxiliaryDetailedLedger"}
407	✅ Query List	account-auxiliaryBalanceSheet	selectItemList	service		{"service": "account", "serviceFunction": "getItemListOfAuxiliaryBalanceSheet"}
408	✅ Query List	account-chronological	selectItemList	sql		{ "table": "view01_voucher_entry", "operation": "select" }
411	✅ Query Subject Balance List	account-subjectDetail	selectSubjectBalancePeriodList	sql		{ "table": "view01_subject_balance_period", "operation": "select" }
412	✅ Add Voucher Entry List	account-subjectDetail	selectVoucherEntryList	sql		{ "table": "view01_voucher_entry", "operation": "select" }
413	✅ Query List	account-subjectSummary	selectItemList	service		{"service": "account", "serviceFunction": "getItemListOfSubjectBalance"}
420	✅ Query Asset Liability List	report-assetLiability	getItemListOfAssetLiability	service		{"service": "report", "serviceFunction": "getItemListOfAssetLiability"}
422	✅ Query Subject List	report-assetLiability	selectSubjectList	sql		{ "table": "view01_subject", "operation": "select" }
423	✅ Get Formula List	report-assetLiability	selectFormulaList	sql		{ "table": "view02_report_asset_liability_formula", "operation": "select" }
424	✅ Save Formula List	report-assetLiability	saveFormulaListOfAssetLiability	service		{"service": "report", "serviceFunction": "saveFormulaListOfAssetLiability"}
425	✅ Delete Formula	report-assetLiability	deleteFormulaItem	sql		{ "table": "report_asset_liability_formula", "operation": "delete" }
430	✅ Query Profit List	report-profit	getItemListOfProfit	service		{"service": "report", "serviceFunction": "getItemListOfProfit"}
432	✅ Query Subject List	report-profit	selectSubjectList	sql		{ "table": "view01_subject", "operation": "select" }
433	✅ Get Formula List	report-profit	selectFormulaList	sql		{ "table": "view02_report_profit_formula", "operation": "select" }
434	✅ Save Formula List	report-profit	saveFormulaListOfAssetLiability	service		{"service": "report", "serviceFunction": "saveFormulaListOfProfit"}
435	✅ Delete Formula	report-profit	deleteFormulaItem	sql		{ "table": "report_profit_formula", "operation": "delete" }
436	✅ Query Department List	report-profitDept	selectAssistDepartList	sql		{"table": "assist_depart", "operation": "select" }
437	✅ Query Auxiliary Accounting List	report-profitProject	selectAssistList	service		{"service": "assist", "serviceFunction": "selectAssistList"}
440	✅ Query Cash Flow List	report-cashFlow	getItemListOfCashFlow	service		{"service": "report", "serviceFunction": "getItemListOfCashFlow"}
441	✅ Query Cash Flow EX List	report-cashFlow	ex-getItemListOfCashFlowEx	service		{"service": "report", "serviceFunction": "getItemListOfCashFlowEx"}
442	✅ Query Subject List	report-cashFlow	ex-selectSubjectList	sql		{ "table": "view01_subject", "operation": "select" }
443	✅ Get Formula List	report-cashFlow	ex-selectFormulaList	sql		{ "table": "view02_report_cash_flow_ex_formula", "operation": "select" }
444	✅ Save Formula List	report-cashFlow	ex-saveFormulaListOfCashFlowEx	service		{"service": "report", "serviceFunction": "saveFormulaListOfCashFlowEx"}
445	✅ Delete Formula	report-cashFlow	ex-deleteFormulaItem	sql		{ "table": "report_cash_flow_ex_formula", "operation": "delete" }
446	✅ Query Cash Flow List	report-cashFlow	getItemListOfCashFlowForPeriodIdList	service		{"service": "report", "serviceFunction": "getItemListOfCashFlowForPeriodIdList"}
447	✅ Query Financial Summary Info List	report-summary	getItemListOfSummary	service		{"service": "report", "serviceFunction": "getItemListOfSummary"}
451	✅ Voucher Template - Delete Carry Forward Voucher	checkout-periodCheckout	voucherTemplate-deleteCheckoutVoucher	service		{"service": "period", "serviceFunction": "deleteCheckoutVoucher"}
452	✅ Voucher Template - Query List	checkout-periodCheckout	voucherTemplate-getCheckoutVoucherList	service		{"service": "period", "serviceFunction": "getCheckoutVoucherList"}
453	✅ Voucher Template - Add	checkout-periodCheckout	voucherTemplate-insertItem	sql	{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}	{ "table": "voucher_template", "operation": "insert" }
454	✅ Voucher Template - Update	checkout-periodCheckout	voucherTemplate-updateItem	sql		{ "table": "voucher_template", "operation": "jhUpdate" }
455	✅ Voucher Template - Delete	checkout-periodCheckout	voucherTemplate-deleteItem	sql		{ "table": "voucher_template", "operation": "jhDelete" }
456	✅ Query Subject List	checkout-periodCheckout	voucherTemplate-selectSubjectList	sql		{ "table": "view01_subject", "operation": "select" }
457	✅ Generate Carry Forward Voucher	checkout-periodCheckout	voucherTemplate-generateCheckoutVoucherList	service		{"service": "period", "serviceFunction": "generateCheckoutVoucherList"}
458	✅ Query List	assistCustomerManagement	selectItemList	sql		{ "table": "assist_customer", "operation": "select" }
459	✅ Add	assistCustomerManagement	insertItem	sql		{ "table": "assist_customer", "operation": "insert" }
460	✅ Update	assistCustomerManagement	updateItem	sql		{ "table": "assist_customer", "operation": "jhUpdate" }
461	✅ Delete	assistCustomerManagement	deleteItem	sql		{ "table": "assist_customer", "operation": "jhDelete" }
462	✅ Stock - Query List	assistManagement	assistCustomer-selectItemList	sql		{ "table": "assist_customer", "operation": "select" }
463	✅ Stock - Add	assistManagement	assistCustomer-insertItem	sql		{ "table": "assist_customer", "operation": "insert" }
464	✅ Stock - Update	assistManagement	assistCustomer-updateItem	sql		{ "table": "assist_customer", "operation": "jhUpdate" }
465	✅ Stock - Delete	assistManagement	assistCustomer-deleteItem	sql		{ "table": "assist_customer", "operation": "jhDelete" }
466	✅ Stock - Query List	assistManagement	assistDepart-selectItemList	sql		{ "table": "assist_depart", "operation": "select" }
467	✅ Stock - Add	assistManagement	assistDepart-insertItem	sql		{ "table": "assist_depart", "operation": "insert" }
468	✅ Stock - Update	assistManagement	assistDepart-updateItem	sql		{ "table": "assist_depart", "operation": "jhUpdate" }
469	✅ Stock - Delete	assistManagement	assistDepart-deleteItem	sql		{ "table": "assist_depart", "operation": "jhDelete" }
470	✅ Stock - Query List	assistManagement	project-selectItemList	sql		{ "table": "assist_project", "operation": "select" }
471	✅ Stock - Add	assistManagement	project-insertItem	sql		{ "table": "assist_project", "operation": "insert" }
472	✅ Stock - Update	assistManagement	project-updateItem	sql		{ "table": "assist_project", "operation": "jhUpdate" }
473	✅ Stock - Delete	assistManagement	project-deleteItem	sql		{ "table": "assist_project", "operation": "jhDelete" }
474	✅ Stock - Query List	assistManagement	staff-selectItemList	sql		{ "table": "assist_staff", "operation": "select" }
475	✅ Stock - Add	assistManagement	staff-insertItem	sql		{ "table": "assist_staff", "operation": "insert" }
476	✅ Stock - Update	assistManagement	staff-updateItem	sql		{ "table": "assist_staff", "operation": "jhUpdate" }
477	✅ Stock - Delete	assistManagement	staff-deleteItem	sql		{ "table": "assist_staff", "operation": "jhDelete" }
478	✅ Stock - Query List	assistManagement	supplier-selectItemList	sql		{ "table": "assist_supplier", "operation": "select" }
479	✅ Stock - Add	assistManagement	supplier-insertItem	sql		{ "table": "assist_supplier", "operation": "insert" }
480	✅ Stock - Update	assistManagement	supplier-updateItem	sql		{ "table": "assist_supplier", "operation": "jhUpdate" }
481	✅ Stock - Delete	assistManagement	supplier-deleteItem	sql		{ "table": "assist_supplier", "operation": "jhDelete" }
482	✅ Stock - Query List	assistManagement	customer-selectItemList	sql		{ "table": "assist_customer", "operation": "select" }
483	✅ Stock - Add	assistManagement	customer-insertItem	sql		{ "table": "assist_customer", "operation": "insert" }
484	✅ Stock - Update	assistManagement	customer-updateItem	sql		{ "table": "assist_customer", "operation": "jhUpdate" }
485	✅ Stock - Delete	assistManagement	customer-deleteItem	sql		{ "table": "assist_customer", "operation": "jhDelete" }
486	✅ Stock - Query List	assistManagement	depart-selectItemList	sql		{ "table": "assist_depart", "operation": "select" }
487	✅ Stock - Add	assistManagement	depart-insertItem	sql		{ "table": "assist_depart", "operation": "insert" }
488	✅ Stock - Update	assistManagement	depart-updateItem	sql		{ "table": "assist_depart", "operation": "jhUpdate" }
489	✅ Stock - Delete	assistManagement	depart-deleteItem	sql		{ "table": "assist_depart", "operation": "jhDelete" }
490	✅ Query List	fundAccountManagement	selectItemList	sql		{ "table": "fund_account", "operation": "select" }
491	✅ Add	fundAccountManagement	insertItem	sql	{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}	{ "table": "fund_account", "operation": "insert" }
492	✅ Update	fundAccountManagement	updateItem	sql		{ "table": "fund_account", "operation": "jhUpdate" }
493	✅ Delete	fundAccountManagement	deleteItem	sql		{ "table": "fund_account", "operation": "jhDelete" }
494	✅ Query List	fundAccountEntryManagement	selectItemList	sql		{ "table": "view01_fund_account_entry", "operation": "select" }
495	✅ Add	fundAccountEntryManagement	insertItem	sql	{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}	{ "table": "fund_account_entry", "operation": "insert" }
496	✅ Update	fundAccountEntryManagement	updateItem	sql		{ "table": "fund_account_entry", "operation": "jhUpdate" }
497	✅ Delete	fundAccountEntryManagement	deleteItem	sql	{"after": [{"service": "fundAccountEntry", "serviceFunction": "removeVoucher"}]}	{ "table": "fund_account_entry", "operation": "jhDelete" }
498	✅ Account Settings - Get Accounting Subjects	fundAccountManagement	selectSubjectList	sql		{"table": "subject", "operation": "select" }
499	✅ Voucher Template - Query List	setting-voucherTemplateManagement	selectVoucherTemplateList	sql		{"table": "voucher_template", "operation": "select" }
500	✅ Query Next Voucher Number	voucher-voucherManagement	selectNextVoucherNumberMap	sql		{ "table": "view01_next_voucher_number", "operation": "select" }
501	✅ Add Voucher and Entry	fundAccountEntryManagement	createVoucherAndVoucherEntry	service	{"after": [{"service": "voucher", "serviceFunction": "relAccountEntryVoucherIdAfterHook"}]}	{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}
502	✅ Import Journal Records	fundAccountEntryManagement	importFundAccountEntryData	service		{"service": "fundAccountEntry", "serviceFunction": "importFundAccountEntryData"}
600	✅ Query List	invoice-invoiceManagement	selectItemList	service		{"service": "invoice", "serviceFunction": "selectInvoice"}
601	✅ Query Template List	invoice-invoiceManagement	selectTemplateList	sql		{ "table": "voucher_template", "operation": "select" }
603	✅ Update Invoice	invoice-invoiceManagement	updateItem	service		{"service": "invoice", "serviceFunction": "updateItem"}
604	✅ Delete Template	invoice-invoiceManagement	deleteItem	service		{"service": "invoice", "serviceFunction": "deleteItem"}
605	✅ Create Invoice	invoice-invoiceManagement	createItem	service		{"service": "invoice", "serviceFunction": "createItem"}
606	✅ Query Customer List	invoice-invoiceManagement	selectCustomerList	sql		{ "table": "assist_customer", "operation": "select" }
607	✅ Query Supplier List	invoice-invoiceManagement	selectSupplierList	sql		{ "table": "assist_supplier", "operation": "select" }
608	✅ Query Invoice Detail Data	invoice-invoiceManagement	selectEntryList	sql		{ "table": "invoice_entry", "operation": "select" }
609	✅ Add Voucher and Entry	invoice-invoiceManagement	createVoucherAndVoucherEntry	service	{"after": [{"service": "invoice", "serviceFunction": "syncVoucherIdToInvoice"}]}	{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}
610	✅ Add Voucher and Entry	invoice-invoiceManagement	deleteSelected	service		{"service": "invoice", "serviceFunction": "deleteSelected"}
611	✅ User Management - Query Info	userManagement	selectItemList	sql		{"table": "_user", "operation": "select"}
612	✅ User Management - Query Info	userManagement	insertItem	service		{"service": "userManagement", "serviceFunction": "addUser"}
613	✅ User Management - Reset Password	userManagement	resetUserPassword	service		{"service": "userManagement", "serviceFunction": "resetUserPassword"}
614	✅ User Management - Update User	userManagement	updateItem	sql		{"table": "_user", "operation": "jhUpdate"}
615	✅ Query List	appAccountManagement	selectItemList	service		{"service": "appAccount", "serviceFunction": "selectAppAccountList"}
616	✅ Add Account Set	appAccountManagement	createAppAcount	service		{"service": "appAccount", "serviceFunction": "createAppAcount"}
617	✅ Update	appAccountManagement	updateItem	sql		{ "table": "_app_account", "operation": "jhUpdate" }
618	✅ Initialize Account Set Configuration Table	appAccountManagement	initAppAccountConfigTable	service		{"service": "appAccount", "serviceFunction": "initAppAcountConfigTable"}
619	✅ Import Account Set Data - Subject List	appAccountManagement	importAppAccountDataOfSubjectList	service		{"service": "appAccount", "serviceFunction": "importAppAccountDataOfSubjectList"}
620	✅ Import Account Set Data - Voucher List	appAccountManagement	importAppAccountDataOfVoucherList	service		{"service": "appAccount", "serviceFunction": "importAppAccountDataOfVoucherList"}
621	✅ Calculate Subject Balance	appAccountManagement	reCheckoutAllPeriod	service		{"service": "appAccount", "serviceFunction": "reCheckoutAllPeriod"}
622	✅ Query Subject List	appAccountManagement	selectSubjectList	sql		{"table": "view01_subject", "operation": "select" }
623	✅ Import Fund Transfer Data	fundAccountTransferEntryManagement	importFundAccountTransferEntryData	service		{"service": "fundAccountTransferEntry", "serviceFunction": "importFundAccountTransferEntryData"}
624	✅ Query List	fundAccountTransferEntryManagement	selectItemList	sql		{ "table": "view01_voucher_transfer_entry", "operation": "select" }
625	✅ Add	fundAccountTransferEntryManagement	insertItem	sql	{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [{"service": "fundAccountTransferEntry", "serviceFunction": "createFundAccountEntryAfterHook"}]}	{ "table": "fund_account_transfer_entry", "operation": "insert" }
626	✅ Update	fundAccountTransferEntryManagement	updateItem	sql		{ "table": "fund_account_transfer_entry", "operation": "jhUpdate" }
627	✅ Delete	fundAccountTransferEntryManagement	deleteItem	sql		{ "table": "fund_account_transfer_entry", "operation": "jhDelete" }
700	✅ Query Salary Employee List	salary-salaryManagement	selectEmployeeList	sql		{ "table": "employee", "operation": "select" }
702	✅ Update Default Five Insurances and One Fund Constant	salary-salaryManagement	insuranceConfig	sql		{ "table": "_constant", "operation": "jhUpdate", "where": {"constantKey":"defaultMemberInsuranceConfig"} }
703	✅ Enter Employee Information	salary-salaryManagement	createEmployee	sql		{ "table": "employee", "operation": "insert" }
704	✅ Modify Employee Information	salary-salaryManagement	updateEmployee	sql		{ "table": "employee", "operation": "jhUpdate" }
705	✅ Delete Employee Information	salary-salaryManagement	deleteEmployee	sql		{ "table": "employee", "operation": "jhDelete" }
706	✅ Query Salary List	salary-salaryManagement	selectItemList	sql		{ "table": "view01_employee_salary_record", "operation": "select" }
707	✅ Check if Salary Sheet Needs to be Generated	salary-salaryManagement	createListFromEmployee	service		{"service": "salary", "serviceFunction": "createListFromEmployee"}
708	✅ Save Salary Configuration Item	salary-salaryManagement	saveCustomSalaryProject	service		{ "service": "salary", "serviceFunction": "saveCustomSalaryProject" }
709	✅ Save Salary Changes	salary-salaryManagement	saveChanged	service		{ "service": "salary", "serviceFunction": "saveChanged" }
710	✅ Get Monthly Salary Sheet	salary-salaryManagement	selectMonthItemList	sql		{ "table": "salary_month_record", "operation": "select" }
711	✅ Get Monthly Salary Voucher Template	salary-salaryManagement	selectTemplateList	sql		{ "table": "voucher_template", "operation": "select" }
712	✅ Create Salary Voucher	salary-salaryManagement	createVoucherAndVoucherEntry	service	{"after": [{"service": "salary", "serviceFunction": "syncVoucherIdToInvoice"}]}	{ "service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry" }
713	✅ Delete Salary Slip	salary-salaryManagement	deleteSelected	service		{ "service": "salary", "serviceFunction": "deleteSelected" }
714	✅ Import Data	salary-salaryManagement	importExcel	service		{ "service": "salary", "serviceFunction": "importExcel" }
715	✅ Account Set - Get User List	appAccountManagement	selectUserList	sql		{"table": "_view01_user", "operation": "select"}
716	✅ Query Profit List - Quarterly	report-profitQuarter	getItemListOfProfitOfQuarter	service		{"service": "report", "serviceFunction": "getItemListOfProfitOfQuarter"}
717	✅ Query Profit List - Department	report-profitDept	getItemListOfProfitOfAssist	service		{"service": "report", "serviceFunction": "getItemListOfProfitOfAssist"}
718	✅ Query Profit List - Department	report-profitProject	getItemListOfProfitOfAssist	service		{"service": "report", "serviceFunction": "getItemListOfProfitOfAssist"}
719	✅ Query Project List	report-profitProject	selectAssistProjectList	sql		{"table": "assist_project", "operation": "select" }
720	✅ Query Cash Flow List	report-cashFlow	getItemListOfCashFlowOfQuarter	service		{"service": "report", "serviceFunction": "getItemListOfCashFlowOfQuarter"}
721	✅ Query Fund Report Group	fundAccountManagement	getStatementGroup	service		{"service": "fundAccountEntry", "serviceFunction": "getStatementGroup"}
730	✅ Query if Account Ledger has Vouchers	appAccountManagement	checkAppAccountExistVoucher	service		{"service": "appAccount", "serviceFunction": "checkAppAccountExistVoucher"}
731	✅ Update Account Ledger	appAccountManagement	updateAppAcount	service		{"service": "appAccount", "serviceFunction": "updateAppAcount"}
740	✅ Query List	setting-subjectManagement	getAmendSubjectList	service		{"service": "subject", "serviceFunction": "getAmendSubjectList"}
741	✅ Query Initial Settings	setting-subjectBalanceStart	selectSubjectBalanceList	sql		{"table": "view01_subject_balance_start", "operation": "select" }
742	✅ Update Initial Settings	setting-subjectBalanceStart	saveSubjectBalanceStart	service		{"service": "period", "serviceFunction": "saveSubjectBalanceStart"}
743	✅ Query Accounting Period	setting-subjectBalanceStart	selectPeriodList	sql		{"table": "period", "operation": "select" }
750	✅ Custom Auxiliary Accounting	assistManagement	addCustomAssist	service		{"service": "appAccount", "serviceFunction": "addCustomAssist"}
752	✅ Get Auxiliary Accounting List	assistManagement	getAssistList	service		{"service": "assist", "serviceFunction": "getAssistList"}
753	✅ Add Auxiliary Accounting Data	assistManagement	insertAssistItem	service		{"service": "assist", "serviceFunction": "insertAssistItem"}
754	✅ Query Cash Flow List - Auxiliary Accounting	report-cashFlow2	getItemListOfCashFlowOfAssist	service		{"service": "report", "serviceFunction": "getItemListOfCashFlowOfAssist"}
755	✅ Query Cash Flow List - Auxiliary Accounting	assistManagement	getCashflowList	sql		{"table": "assist_cashflow", "operation": "select" }
756	✅ Query List	account-subjectBalance	selectItemList	sql		{ "table": "view01_subject_balance_period", "operation": "select" }
757	✅ Delete Account Set	appAccountManagement	deleteAppAccount	service		{"service": "appAccount", "serviceFunction": "deleteAppAccount"}
760	✅ Import Employee Data	salary-salaryManagement	importEmployeeData	service		{"service": "employee", "serviceFunction": "importEmployeeData"}
761	✅ Query Cash Flow List	report-cashFlow2	getItemListOfCashFlowOfFormula	service		{"service": "report", "serviceFunction": "getItemListOfCashFlow2"}
762	✅ Cash Flow - Save Formula Calculation Adjustment Value	report-cashFlow2	saveComputeAdjustList	service		{"service": "report", "serviceFunction": "saveComputeAdjustList"}
774	✅ Get Cash Flow Voucher List	report-cashFlow	getSubjectCashflowVoucherList	service		{"service": "subject", "serviceFunction": "getSubjectCashflowVoucherList"}
775	✅ Update Mid-Year Figures	report-cashFlow3	updateCashFlowMidYear	sql		{ "table": "report_cash_flow_item3", "operation": "jhUpdate" }
776	✅ Checkout Check	checkout-periodCheckout	checkoutExamine	service		{"service": "period", "serviceFunction": "checkoutExamine"}
777	✅ Query List	currencyManagement	selectItemList	sql		{ "table": "currency", "operation": "select" }
778	✅ Add	currencyManagement	insertItem	sql		{ "table": "currency", "operation": "insert" }
779	✅ Update	currencyManagement	updateItem	sql		{ "table": "currency", "operation": "jhUpdate" }
780	✅ Delete	currencyManagement	deleteItem	sql		{ "table": "currency", "operation": "jhDelete" }
781	✅ Archive Account Set	setting-archiveManagement	archiveAppAcount	service		{"service": "appAccount", "serviceFunction": "archiveAppAcount"}
782	✅ Get Account Set Archive List	setting-archiveManagement	getArchiveList	sql		{ "table": "app_account_file", "operation": "select" }
783	✅ Get Foreign Currency List	setting-subjectManagement	getCurrency	sql		{ "table": "currency", "operation": "select" }
784	✅ Query Cash Flow List	report-cashFlow3	getItemListOfCashFlow	service		{"service": "report", "serviceFunction": "getItemListOfCashFlow3"}
790	✅ Query Operation Records	setting-recordHistoryManagement	selectItemList	sql		{ "table": "_record_history", "operation": "select" }
792	✅ Cash Flow List	setting-subjectCashManagement2	getCashflowList	sql		{ "table": "report_cash_flow_item3", "operation": "select" }
793	✅ Subject and Cash Flow Correspondence Table	setting-subjectCashManagement2	getSubjectCashflowList	sql		{ "table": "subject", "operation": "select" }
794	✅ Update Subject and Cash Flow Correspondence Table	setting-subjectCashManagement2	updateSubjectCashflow	sql		{ "table": "subject", "operation": "jhUpdate" }
795	✅ Reset Subject and Cash Flow Correspondence Table	setting-subjectCashManagement2	resetSubjectCashflow	service		{"service": "subject", "serviceFunction": "resetSubjectCashflow"}
796	✅ Voucher - Query Foreign Currency List	voucher-voucherManagement	entry-selectCurrencyList	sql		{ "table": "subject", "operation": "select" }
797	✅ Update Account Set Information	appAccountManagement	updateAppAccountData	service		{"service": "appAccount", "serviceFunction": "updateAppAccountData"}

_resource Statements

INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'login', 'passwordLogin', '✅ Login', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅ Logout', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅ Get User Info', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅ Query Constants', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (259, NULL, NULL, 'allPage', 'selectPeriodList', '✅ Query Accounting Period List', 'sql', '{}', '{"table": "period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (261, NULL, NULL, 'allPage', 'uploadFileDone', '✅ File Chunk Upload - All Chunks Uploaded', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', '', '', 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (262, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ File Chunk Upload - HTTP File Stream', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', '', '', 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (263, NULL, NULL, 'allPage', 'selectSubjectList', '✅ Query Subject List', 'sql', '{}', '{"table": "view01_subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (264, NULL, NULL, 'allPage', 'selectAssistList', '✅ Voucher - Query Auxiliary Info List', 'service', '{}', '{"service": "assist", "serviceFunction": "selectAssistList"}', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (265, NULL, NULL, 'allPage', 'selectVoucherList', '✅ Query List', 'sql', '{}', '{ "table": "view01_voucher_entry", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (266, NULL, NULL, 'allPage', 'selectSubjectListByPeriod', '✅ Query Subject List', 'sql', '{}', '{"table": "view01_subject_balance_period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType,