江湖数字化平台
登录

接口

12079

接口总览

_resource结构

  1. CREATE TABLE `_resource` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `accessControlTable` varchar(255)  DEFAULT NULL COMMENT '数据规则控制表',
  4.   `resourceHook` text  COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  5.   `pageId` varchar(255)  DEFAULT NULL COMMENT 'page id; E.g: index',
  6.   `actionId` varchar(255)  DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  7.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  8.   `resourceType` varchar(255)  DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  9.   `appDataSchema` text  COMMENT 'appData 参数校验',
  10.   `resourceData` text  COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  11.   `requestDemo` text  COMMENT '请求Demo',
  12.   `responseDemo` text  COMMENT '响应Demo',
  13.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  14.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  15.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  16.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  17.   PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE = InnoDB AUTO_INCREMENT = 798 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id desc pageId actionId resourceType resourceHook resourceData
231 ✅登陆 login passwordLogin service {"service": "user", "serviceFunction": "passwordLogin"}
251 ✅登出 allPage logout service {"service": "user", "serviceFunction": "logout"}
253 ✅获取用户信息 allPage userInfo service {"service": "user", "serviceFunction": "userInfo"}
258 ✅查询常量 allPage getConstantList sql {"table": "_constant", "operation": "select"}
259 ✅查询会计期间列表 allPage selectPeriodList sql {"table": "period", "operation": "select" }
261 ✅ 文件分片上传-所有分片上传完毕 allPage uploadFileDone service {"service": "file", "serviceFunction": "uploadFileDone"}
262 ✅ 文件分片上传-http文件流 allPage httpUploadByStream service {"service": "file", "serviceFunction": "uploadFileChunkByStream"}
263 ✅查询科目列表 allPage selectSubjectList sql {"table": "view01_subject", "operation": "select" }
264 ✅凭证-查询辅助信息列表 allPage selectAssistList service {"service": "assist", "serviceFunction": "selectAssistList"}
265 ✅查询列表 allPage selectVoucherList sql { "table": "view01_voucher_entry", "operation": "select" }
266 ✅查询科目列表 allPage selectSubjectListByPeriod sql {"table": "view01_subject_balance_period", "operation": "select" }
267 ✅查询帐套列表 allPage selectAppAccountList service {"service": "appAccount", "serviceFunction": "selectAppAccountList"}
268 ✅查询用户列表 allPage selectUserList sql {"table": "_user", "operation": "select" }
350 ✅计算科目余额 checkout-periodCheckout computeSubjectBalance service {"service": "period", "serviceFunction": "computeSubjectBalance"}
351 ✅试算平衡 checkout-periodCheckout checkSubjectBalance service {"service": "period", "serviceFunction": "checkSubjectBalance"}
352 ✅查询列表 checkout-periodCheckout selectItemList sql {"table": "period", "operation": "select" }
353 ✅创建第一个会计期间 checkout-periodCheckout createPeriodStart service {"service": "period", "serviceFunction": "createPeriodStart"}
354 ✅结账 checkout-periodCheckout checkout service {"service": "period", "serviceFunction": "checkout"}
355 ✅重新结账All【开发调试】 checkout-periodCheckout reCheckoutAllPeriod service {"service": "period", "serviceFunction": "reCheckoutAllPeriod"}
356 ✅反结账 checkout-periodCheckout reverseCheckout service {"service": "period", "serviceFunction": "reverseCheckout"}
361 ✅查询列表 setting-subjectManagement selectItemList sql {"table": "subject", "operation": "select" }
362 ✅添加 setting-subjectManagement createSubject service {"service": "subject", "serviceFunction": "createSubject"}
363 ✅更新 setting-subjectManagement updateItem service {"service": "subject", "serviceFunction": "updateSubject"}
364 ✅删除 setting-subjectManagement removeSubject service {"service": "subject", "serviceFunction": "removeSubject"}
375 ✅查询会计期间 report-subjectBalanceYearStartAdjust selectPeriodList sql {"table": "period", "operation": "select" }
376 ✅查询科目余额-年 report-subjectBalanceYearStartAdjust selectSubjectBalanceYearList sql {"table": "view01_subject_balance_year", "operation": "select" }
377 ✅查询科目余额-年 report-subjectBalanceYearStartAdjust selectVoucherEntryList sql {"table": "view01_voucher_entry", "operation": "select" }
381 ✅查询列表 voucher-voucherManagement selectItemList sql { "table": "view01_voucher_entry", "operation": "select" }
382 ✅查询下一个凭证号 voucher-voucherManagement selectNextVoucherNumber service {"service": "voucher", "serviceFunction": "selectNextVoucherNumber"}
384 ✅查询科目列表 voucher-voucherManagement selectSubjectList sql { "table": "view01_subject", "operation": "select" }
386 ✅添加凭证和条目 voucher-voucherManagement createVoucherAndVoucherEntry service {"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}
387 ✅删除凭证 voucher-voucherManagement removeVoucher service {"service": "voucher", "serviceFunction": "removeVoucher"}
388 ✅凭证单据-查询列表 voucher-voucherManagement file-selectItemList sql { "table": "voucher_file", "operation": "select" }
389 ✅凭证单据-添加 voucher-voucherManagement file-insertItem sql { "table": "voucher_file", "operation": "insert" }
390 ✅凭证单据-更新 voucher-voucherManagement file-updateItem sql { "table": "voucher_file", "operation": "jhUpdate" }
391 ✅凭证单据-删除 voucher-voucherManagement file-deleteItem sql { "table": "voucher_file", "operation": "jhDelete" }
392 ✅更新凭证和条目 voucher-voucherManagement updateVoucherAndVoucherEntry service {"service": "voucher", "serviceFunction": "updateVoucherAndVoucherEntry"}
393 ✅凭证-查询辅助信息列表 voucher-voucherManagement entry-selectAssistList service {"service": "assist", "serviceFunction": "selectAssistList"}
401 ✅查询列表 account-generalLedger selectItemList service {"service": "account", "serviceFunction": "getItemListOfGeneralLedger"}
403 ✅查询科目列表 account-subjectDetail selectSubjectList sql { "table": "view01_subject_balance_period", "operation": "select" }
404 ✅查询列表 account-subjectDetail selectItemList service {"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}
405 ✅查询列表 account-multicolumnLedger selectItemList service {"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}
406 ✅查询列表 account-auxiliaryDetailedLedger selectItemList service {"service": "account", "serviceFunction": "getItemListOfAuxiliaryDetailedLedger"}
407 ✅查询列表 account-auxiliaryBalanceSheet selectItemList service {"service": "account", "serviceFunction": "getItemListOfAuxiliaryBalanceSheet"}
408 ✅查询列表 account-chronological selectItemList sql { "table": "view01_voucher_entry", "operation": "select" }
411 ✅查询科目余额列表 account-subjectDetail selectSubjectBalancePeriodList sql { "table": "view01_subject_balance_period", "operation": "select" }
412 ✅添加凭证条目列表 account-subjectDetail selectVoucherEntryList sql { "table": "view01_voucher_entry", "operation": "select" }
413 ✅查询列表 account-subjectSummary selectItemList service {"service": "account", "serviceFunction": "getItemListOfSubjectBalance"}
420 ✅查询资产负债列表 report-assetLiability getItemListOfAssetLiability service {"service": "report", "serviceFunction": "getItemListOfAssetLiability"}
422 ✅查询科目列表 report-assetLiability selectSubjectList sql { "table": "view01_subject", "operation": "select" }
423 ✅获取公式列表 report-assetLiability selectFormulaList sql { "table": "view02_report_asset_liability_formula", "operation": "select" }
424 ✅保存公式列表 report-assetLiability saveFormulaListOfAssetLiability service {"service": "report", "serviceFunction": "saveFormulaListOfAssetLiability"}
425 ✅删除公式 report-assetLiability deleteFormulaItem sql { "table": "report_asset_liability_formula", "operation": "delete" }
430 ✅查询利润列表 report-profit getItemListOfProfit service {"service": "report", "serviceFunction": "getItemListOfProfit"}
432 ✅查询科目列表 report-profit selectSubjectList sql { "table": "view01_subject", "operation": "select" }
433 ✅获取公式列表 report-profit selectFormulaList sql { "table": "view02_report_profit_formula", "operation": "select" }
434 ✅保存公式列表 report-profit saveFormulaListOfAssetLiability service {"service": "report", "serviceFunction": "saveFormulaListOfProfit"}
435 ✅删除公式 report-profit deleteFormulaItem sql { "table": "report_profit_formula", "operation": "delete" }
436 ✅查询部门列表 report-profitDept selectAssistDepartList sql {"table": "assist_depart", "operation": "select" }
437 ✅查询辅助核算列表 report-profitProject selectAssistList service {"service": "assist", "serviceFunction": "selectAssistList"}
440 ✅查询现金流列表 report-cashFlow getItemListOfCashFlow service {"service": "report", "serviceFunction": "getItemListOfCashFlow"}
441 ✅查询现金流EX列表 report-cashFlow ex-getItemListOfCashFlowEx service {"service": "report", "serviceFunction": "getItemListOfCashFlowEx"}
442 ✅查询科目列表 report-cashFlow ex-selectSubjectList sql { "table": "view01_subject", "operation": "select" }
443 ✅获取公式列表 report-cashFlow ex-selectFormulaList sql { "table": "view02_report_cash_flow_ex_formula", "operation": "select" }
444 ✅保存公式列表 report-cashFlow ex-saveFormulaListOfCashFlowEx service {"service": "report", "serviceFunction": "saveFormulaListOfCashFlowEx"}
445 ✅删除公式 report-cashFlow ex-deleteFormulaItem sql { "table": "report_cash_flow_ex_formula", "operation": "delete" }
446 ✅查询现金流列表 report-cashFlow getItemListOfCashFlowForPeriodIdList service {"service": "report", "serviceFunction": "getItemListOfCashFlowForPeriodIdList"}
447 ✅查询财务概要信息列表 report-summary getItemListOfSummary service {"service": "report", "serviceFunction": "getItemListOfSummary"}
451 ✅凭证模板-删除结转凭证 checkout-periodCheckout voucherTemplate-deleteCheckoutVoucher service {"service": "period", "serviceFunction": "deleteCheckoutVoucher"}
452 ✅凭证模板-查询列表 checkout-periodCheckout voucherTemplate-getCheckoutVoucherList service {"service": "period", "serviceFunction": "getCheckoutVoucherList"}
453 ✅凭证模板-添加 checkout-periodCheckout voucherTemplate-insertItem sql {"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []} { "table": "voucher_template", "operation": "insert" }
454 ✅凭证模板-更新 checkout-periodCheckout voucherTemplate-updateItem sql { "table": "voucher_template", "operation": "jhUpdate" }
455 ✅凭证模板-删除 checkout-periodCheckout voucherTemplate-deleteItem sql { "table": "voucher_template", "operation": "jhDelete" }
456 ✅查询科目列表 checkout-periodCheckout voucherTemplate-selectSubjectList sql { "table": "view01_subject", "operation": "select" }
457 ✅生成结转凭证 checkout-periodCheckout voucherTemplate-generateCheckoutVoucherList service {"service": "period", "serviceFunction": "generateCheckoutVoucherList"}
458 ✅查询列表 assistCustomerManagement selectItemList sql { "table": "assist_customer", "operation": "select" }
459 ✅添加 assistCustomerManagement insertItem sql { "table": "assist_customer", "operation": "insert" }
460 ✅更新 assistCustomerManagement updateItem sql { "table": "assist_customer", "operation": "jhUpdate" }
461 ✅删除 assistCustomerManagement deleteItem sql { "table": "assist_customer", "operation": "jhDelete" }
462 ✅stock-查询列表 assistManagement assistCustomer-selectItemList sql { "table": "assist_customer", "operation": "select" }
463 ✅stock-添加 assistManagement assistCustomer-insertItem sql { "table": "assist_customer", "operation": "insert" }
464 ✅stock-更新 assistManagement assistCustomer-updateItem sql { "table": "assist_customer", "operation": "jhUpdate" }
465 ✅stock-删除 assistManagement assistCustomer-deleteItem sql { "table": "assist_customer", "operation": "jhDelete" }
466 ✅stock-查询列表 assistManagement assistDepart-selectItemList sql { "table": "assist_depart", "operation": "select" }
467 ✅stock-添加 assistManagement assistDepart-insertItem sql { "table": "assist_depart", "operation": "insert" }
468 ✅stock-更新 assistManagement assistDepart-updateItem sql { "table": "assist_depart", "operation": "jhUpdate" }
469 ✅stock-删除 assistManagement assistDepart-deleteItem sql { "table": "assist_depart", "operation": "jhDelete" }
470 ✅stock-查询列表 assistManagement project-selectItemList sql { "table": "assist_project", "operation": "select" }
471 ✅stock-添加 assistManagement project-insertItem sql { "table": "assist_project", "operation": "insert" }
472 ✅stock-更新 assistManagement project-updateItem sql { "table": "assist_project", "operation": "jhUpdate" }
473 ✅stock-删除 assistManagement project-deleteItem sql { "table": "assist_project", "operation": "jhDelete" }
474 ✅stock-查询列表 assistManagement staff-selectItemList sql { "table": "assist_staff", "operation": "select" }
475 ✅stock-添加 assistManagement staff-insertItem sql { "table": "assist_staff", "operation": "insert" }
476 ✅stock-更新 assistManagement staff-updateItem sql { "table": "assist_staff", "operation": "jhUpdate" }
477 ✅stock-删除 assistManagement staff-deleteItem sql { "table": "assist_staff", "operation": "jhDelete" }
478 ✅stock-查询列表 assistManagement supplier-selectItemList sql { "table": "assist_supplier", "operation": "select" }
479 ✅stock-添加 assistManagement supplier-insertItem sql { "table": "assist_supplier", "operation": "insert" }
480 ✅stock-更新 assistManagement supplier-updateItem sql { "table": "assist_supplier", "operation": "jhUpdate" }
481 ✅stock-删除 assistManagement supplier-deleteItem sql { "table": "assist_supplier", "operation": "jhDelete" }
482 ✅stock-查询列表 assistManagement customer-selectItemList sql { "table": "assist_customer", "operation": "select" }
483 ✅stock-添加 assistManagement customer-insertItem sql { "table": "assist_customer", "operation": "insert" }
484 ✅stock-更新 assistManagement customer-updateItem sql { "table": "assist_customer", "operation": "jhUpdate" }
485 ✅stock-删除 assistManagement customer-deleteItem sql { "table": "assist_customer", "operation": "jhDelete" }
486 ✅stock-查询列表 assistManagement depart-selectItemList sql { "table": "assist_depart", "operation": "select" }
487 ✅stock-添加 assistManagement depart-insertItem sql { "table": "assist_depart", "operation": "insert" }
488 ✅stock-更新 assistManagement depart-updateItem sql { "table": "assist_depart", "operation": "jhUpdate" }
489 ✅stock-删除 assistManagement depart-deleteItem sql { "table": "assist_depart", "operation": "jhDelete" }
490 ✅查询列表 fundAccountManagement selectItemList sql { "table": "fund_account", "operation": "select" }
491 ✅添加 fundAccountManagement insertItem sql {"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []} { "table": "fund_account", "operation": "insert" }
492 ✅更新 fundAccountManagement updateItem sql { "table": "fund_account", "operation": "jhUpdate" }
493 ✅删除 fundAccountManagement deleteItem sql { "table": "fund_account", "operation": "jhDelete" }
494 ✅查询列表 fundAccountEntryManagement selectItemList sql { "table": "view01_fund_account_entry", "operation": "select" }
495 ✅添加 fundAccountEntryManagement insertItem sql {"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []} { "table": "fund_account_entry", "operation": "insert" }
496 ✅更新 fundAccountEntryManagement updateItem sql { "table": "fund_account_entry", "operation": "jhUpdate" }
497 ✅删除 fundAccountEntryManagement deleteItem sql {"after": [{"service": "fundAccountEntry", "serviceFunction": "removeVoucher"}]} { "table": "fund_account_entry", "operation": "jhDelete" }
498 ✅账户设置-获取会计科目 fundAccountManagement selectSubjectList sql {"table": "subject", "operation": "select" }
499 ✅凭证模板-查询列表 setting-voucherTemplateManagement selectVoucherTemplateList sql {"table": "voucher_template", "operation": "select" }
500 ✅查询下一个凭证号 voucher-voucherManagement selectNextVoucherNumberMap sql { "table": "view01_next_voucher_number", "operation": "select" }
501 ✅添加凭证和条目 fundAccountEntryManagement createVoucherAndVoucherEntry service {"after": [{"service": "voucher", "serviceFunction": "relAccountEntryVoucherIdAfterHook"}]} {"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}
502 ✅导入日记账记录 fundAccountEntryManagement importFundAccountEntryData service {"service": "fundAccountEntry", "serviceFunction": "importFundAccountEntryData"}
600 ✅查询列表 invoice-invoiceManagement selectItemList service {"service": "invoice", "serviceFunction": "selectInvoice"}
601 ✅查询模板列表 invoice-invoiceManagement selectTemplateList sql { "table": "voucher_template", "operation": "select" }
603 ✅更新发票 invoice-invoiceManagement updateItem service {"service": "invoice", "serviceFunction": "updateItem"}
604 ✅删除模板 invoice-invoiceManagement deleteItem service {"service": "invoice", "serviceFunction": "deleteItem"}
605 ✅新建发票 invoice-invoiceManagement createItem service {"service": "invoice", "serviceFunction": "createItem"}
606 ✅查询客户列表 invoice-invoiceManagement selectCustomerList sql { "table": "assist_customer", "operation": "select" }
607 ✅查询供应商列表 invoice-invoiceManagement selectSupplierList sql { "table": "assist_supplier", "operation": "select" }
608 ✅查询发票详情数据 invoice-invoiceManagement selectEntryList sql { "table": "invoice_entry", "operation": "select" }
609 ✅添加凭证和条目 invoice-invoiceManagement createVoucherAndVoucherEntry service {"after": [{"service": "invoice", "serviceFunction": "syncVoucherIdToInvoice"}]} {"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}
610 ✅添加凭证和条目 invoice-invoiceManagement deleteSelected service {"service": "invoice", "serviceFunction": "deleteSelected"}
611 ✅用户管理-查询信息 userManagement selectItemList sql {"table": "_user", "operation": "select"}
612 ✅用户管理-查询信息 userManagement insertItem service {"service": "userManagement", "serviceFunction": "addUser"}
613 ✅用户管理-修改密码 userManagement resetUserPassword service {"service": "userManagement", "serviceFunction": "resetUserPassword"}
614 ✅用户管理-更新用户 userManagement updateItem sql {"table": "_user", "operation": "jhUpdate"}
615 ✅查询列表 appAccountManagement selectItemList service {"service": "appAccount", "serviceFunction": "selectAppAccountList"}
616 ✅添加账套 appAccountManagement createAppAcount service {"service": "appAccount", "serviceFunction": "createAppAcount"}
617 ✅更新 appAccountManagement updateItem sql { "table": "_app_account", "operation": "jhUpdate" }
618 ✅初始化账套配置表 appAccountManagement initAppAccountConfigTable service {"service": "appAccount", "serviceFunction": "initAppAcountConfigTable"}
619 ✅导入账套数据-科目列表 appAccountManagement importAppAccountDataOfSubjectList service {"service": "appAccount", "serviceFunction": "importAppAccountDataOfSubjectList"}
620 ✅导入账套数据-凭证列表 appAccountManagement importAppAccountDataOfVoucherList service {"service": "appAccount", "serviceFunction": "importAppAccountDataOfVoucherList"}
621 ✅计算科目余额 appAccountManagement reCheckoutAllPeriod service {"service": "appAccount", "serviceFunction": "reCheckoutAllPeriod"}
622 ✅查询科目列表 appAccountManagement selectSubjectList sql {"table": "view01_subject", "operation": "select" }
623 ✅导入资金转账数据 fundAccountTransferEntryManagement importFundAccountTransferEntryData service {"service": "fundAccountTransferEntry", "serviceFunction": "importFundAccountTransferEntryData"}
624 ✅查询列表 fundAccountTransferEntryManagement selectItemList sql { "table": "view01_voucher_transfer_entry", "operation": "select" }
625 ✅添加 fundAccountTransferEntryManagement insertItem sql {"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [{"service": "fundAccountTransferEntry", "serviceFunction": "createFundAccountEntryAfterHook"}]} { "table": "fund_account_transfer_entry", "operation": "insert" }
626 ✅更新 fundAccountTransferEntryManagement updateItem sql { "table": "fund_account_transfer_entry", "operation": "jhUpdate" }
627 ✅删除 fundAccountTransferEntryManagement deleteItem sql { "table": "fund_account_transfer_entry", "operation": "jhDelete" }
700 ✅查询工资员工列表 salary-salaryManagement selectEmployeeList sql { "table": "employee", "operation": "select" }
702 ✅更新默认五险一金常量 salary-salaryManagement insuranceConfig sql { "table": "_constant", "operation": "jhUpdate", "where": {"constantKey":"defaultMemberInsuranceConfig"} }
703 ✅录入员工信息 salary-salaryManagement createEmployee sql { "table": "employee", "operation": "insert" }
704 ✅修改员工信息 salary-salaryManagement updateEmployee sql { "table": "employee", "operation": "jhUpdate" }
705 ✅删除员工信息 salary-salaryManagement deleteEmployee sql { "table": "employee", "operation": "jhDelete" }
706 ✅查询工资列表 salary-salaryManagement selectItemList sql { "table": "view01_employee_salary_record", "operation": "select" }
707 ✅检查是否需要生成工资表 salary-salaryManagement createListFromEmployee service {"service": "salary", "serviceFunction": "createListFromEmployee"}
708 ✅保存工资配置项目 salary-salaryManagement saveCustomSalaryProject service { "service": "salary", "serviceFunction": "saveCustomSalaryProject" }
709 ✅保存工资变动 salary-salaryManagement saveChanged service { "service": "salary", "serviceFunction": "saveChanged" }
710 ✅获取月度工资表 salary-salaryManagement selectMonthItemList sql { "table": "salary_month_record", "operation": "select" }
711 ✅获取月度工资凭证模板 salary-salaryManagement selectTemplateList sql { "table": "voucher_template", "operation": "select" }
712 ✅创建工资凭证 salary-salaryManagement createVoucherAndVoucherEntry service {"after": [{"service": "salary", "serviceFunction": "syncVoucherIdToInvoice"}]} { "service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry" }
713 ✅删除工资条 salary-salaryManagement deleteSelected service { "service": "salary", "serviceFunction": "deleteSelected" }
714 ✅导入数据 salary-salaryManagement importExcel service { "service": "salary", "serviceFunction": "importExcel" }
715 ✅套账-获取用户列表 appAccountManagement selectUserList sql {"table": "_view01_user", "operation": "select"}
716 ✅查询利润列表-季度 report-profitQuarter getItemListOfProfitOfQuarter service {"service": "report", "serviceFunction": "getItemListOfProfitOfQuarter"}
717 ✅查询利润列表-部门 report-profitDept getItemListOfProfitOfAssist service {"service": "report", "serviceFunction": "getItemListOfProfitOfAssist"}
718 ✅查询利润列表-部门 report-profitProject getItemListOfProfitOfAssist service {"service": "report", "serviceFunction": "getItemListOfProfitOfAssist"}
719 ✅查询项目列表 report-profitProject selectAssistProjectList sql {"table": "assist_project", "operation": "select" }
720 ✅查询现金流列表 report-cashFlow getItemListOfCashFlowOfQuarter service {"service": "report", "serviceFunction": "getItemListOfCashFlowOfQuarter"}
721 ✅查询资金报表分组 fundAccountManagement getStatementGroup service {"service": "fundAccountEntry", "serviceFunction": "getStatementGroup"}
730 ✅查询账薄是否有凭证 appAccountManagement checkAppAccountExistVoucher service {"service": "appAccount", "serviceFunction": "checkAppAccountExistVoucher"}
731 ✅更新账薄 appAccountManagement updateAppAcount service {"service": "appAccount", "serviceFunction": "updateAppAcount"}
740 ✅查询列表 setting-subjectManagement getAmendSubjectList service {"service": "subject", "serviceFunction": "getAmendSubjectList"}
741 ✅查询期初设置 setting-subjectBalanceStart selectSubjectBalanceList sql {"table": "view01_subject_balance_start", "operation": "select" }
742 ✅更新期初设置 setting-subjectBalanceStart saveSubjectBalanceStart service {"service": "period", "serviceFunction": "saveSubjectBalanceStart"}
743 ✅查询会计期间 setting-subjectBalanceStart selectPeriodList sql {"table": "period", "operation": "select" }
750 ✅自定义辅助核算 assistManagement addCustomAssist service {"service": "appAccount", "serviceFunction": "addCustomAssist"}
752 ✅获取辅助核算列表 assistManagement getAssistList service {"service": "assist", "serviceFunction": "getAssistList"}
753 ✅新增辅助核算数据 assistManagement insertAssistItem service {"service": "assist", "serviceFunction": "insertAssistItem"}
754 ✅查询现金流列表-辅助核算 report-cashFlow2 getItemListOfCashFlowOfAssist service {"service": "report", "serviceFunction": "getItemListOfCashFlowOfAssist"}
755 ✅查询现金流列表-辅助核算 assistManagement getCashflowList sql {"table": "assist_cashflow", "operation": "select" }
756 ✅查询列表 account-subjectBalance selectItemList sql { "table": "view01_subject_balance_period", "operation": "select" }
757 ✅删除账套 appAccountManagement deleteAppAccount service {"service": "appAccount", "serviceFunction": "deleteAppAccount"}
760 ✅导入员工数据 salary-salaryManagement importEmployeeData service {"service": "employee", "serviceFunction": "importEmployeeData"}
761 ✅查询现金流列表 report-cashFlow2 getItemListOfCashFlowOfFormula service {"service": "report", "serviceFunction": "getItemListOfCashFlow2"}
762 ✅现金流量-保存公式计算调整数值 report-cashFlow2 saveComputeAdjustList service {"service": "report", "serviceFunction": "saveComputeAdjustList"}
774 ✅获取现金流量的凭证列表 report-cashFlow getSubjectCashflowVoucherList service {"service": "subject", "serviceFunction": "getSubjectCashflowVoucherList"}
775 ✅更新年中数 report-cashFlow3 updateCashFlowMidYear sql { "table": "report_cash_flow_item3", "operation": "jhUpdate" }
776 ✅结账检查 checkout-periodCheckout checkoutExamine service {"service": "period", "serviceFunction": "checkoutExamine"}
777 ✅查询列表 currencyManagement selectItemList sql { "table": "currency", "operation": "select" }
778 ✅添加 currencyManagement insertItem sql { "table": "currency", "operation": "insert" }
779 ✅更新 currencyManagement updateItem sql { "table": "currency", "operation": "jhUpdate" }
780 ✅删除 currencyManagement deleteItem sql { "table": "currency", "operation": "jhDelete" }
781 ✅账套归档 setting-archiveManagement archiveAppAcount service {"service": "appAccount", "serviceFunction": "archiveAppAcount"}
782 ✅获取账套归档列表 setting-archiveManagement getArchiveList sql { "table": "app_account_file", "operation": "select" }
783 ✅获取外币列表 setting-subjectManagement getCurrency sql { "table": "currency", "operation": "select" }
784 ✅查询现金流列表 report-cashFlow3 getItemListOfCashFlow service {"service": "report", "serviceFunction": "getItemListOfCashFlow3"}
790 ✅查询操作记录 setting-recordHistoryManagement selectItemList sql { "table": "_record_history", "operation": "select" }
792 ✅现金流量列表 setting-subjectCashManagement2 getCashflowList sql { "table": "report_cash_flow_item3", "operation": "select" }
793 ✅科目和现金流对照表 setting-subjectCashManagement2 getSubjectCashflowList sql { "table": "subject", "operation": "select" }
794 ✅更新科目和现金流对照表 setting-subjectCashManagement2 updateSubjectCashflow sql { "table": "subject", "operation": "jhUpdate" }
795 ✅重置科目和现金流对照表 setting-subjectCashManagement2 resetSubjectCashflow service {"service": "subject", "serviceFunction": "resetSubjectCashflow"}
796 ✅凭证-查询外币列表 voucher-voucherManagement entry-selectCurrencyList sql { "table": "subject", "operation": "select" }
797 ✅账套信息更新 appAccountManagement updateAppAccountData service {"service": "appAccount", "serviceFunction": "updateAppAccountData"}

_resource语句

  1. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
  2. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
  4. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  5. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (259, NULL, NULL, 'allPage', 'selectPeriodList', '✅查询会计期间列表', 'sql', '{}', '{"table": "period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  6. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (261, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileDone"}', '', '', 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
  7. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (262, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{"service": "file", "serviceFunction": "uploadFileChunkByStream"}', '', '', 'update', NULL, NULL, '2022-05-04T16:02:58+08:00');
  8. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (263, NULL, NULL, 'allPage', 'selectSubjectList', '✅查询科目列表', 'sql', '{}', '{"table": "view01_subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  9. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (264, NULL, NULL, 'allPage', 'selectAssistList', '✅凭证-查询辅助信息列表', 'service', '{}', '{"service": "assist", "serviceFunction": "selectAssistList"}', '', '', 'insert', NULL, NULL, NULL);
  10. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (265, NULL, NULL, 'allPage', 'selectVoucherList', '✅查询列表', 'sql', '{}', '{ "table": "view01_voucher_entry", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  11. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (266, NULL, NULL, 'allPage', 'selectSubjectListByPeriod', '✅查询科目列表', 'sql', '{}', '{"table": "view01_subject_balance_period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  12. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (267, NULL, NULL, 'allPage', 'selectAppAccountList', '✅查询帐套列表', 'service', '{}', '{"service": "appAccount", "serviceFunction": "selectAppAccountList"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  13. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (268, NULL, NULL, 'allPage', 'selectUserList', '✅查询用户列表', 'sql', '{}', '{"table": "_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  14. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (350, NULL, NULL, 'checkout-periodCheckout', 'computeSubjectBalance', '✅计算科目余额', 'service', '{}', '{"service": "period", "serviceFunction": "computeSubjectBalance"}', '', '', 'insert', NULL, NULL, NULL);
  15. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (351, NULL, NULL, 'checkout-periodCheckout', 'checkSubjectBalance', '✅试算平衡', 'service', '{}', '{"service": "period", "serviceFunction": "checkSubjectBalance"}', '', '', 'insert', NULL, NULL, NULL);
  16. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (352, NULL, NULL, 'checkout-periodCheckout', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table": "period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  17. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (353, NULL, NULL, 'checkout-periodCheckout', 'createPeriodStart', '✅创建第一个会计期间', 'service', '{}', '{"service": "period", "serviceFunction": "createPeriodStart"}', '', '', 'insert', NULL, NULL, NULL);
  18. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (354, NULL, NULL, 'checkout-periodCheckout', 'checkout', '✅结账', 'service', '{}', '{"service": "period", "serviceFunction": "checkout"}', '', '', 'insert', NULL, NULL, NULL);
  19. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (355, NULL, NULL, 'checkout-periodCheckout', 'reCheckoutAllPeriod', '✅重新结账All【开发调试】', 'service', '{}', '{"service": "period", "serviceFunction": "reCheckoutAllPeriod"}', '', '', 'insert', NULL, NULL, NULL);
  20. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (356, NULL, NULL, 'checkout-periodCheckout', 'reverseCheckout', '✅反结账', 'service', '{}', '{"service": "period", "serviceFunction": "reverseCheckout"}', '', '', 'insert', NULL, NULL, NULL);
  21. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (361, NULL, NULL, 'setting-subjectManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table": "subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  22. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (362, NULL, '', 'setting-subjectManagement', 'createSubject', '✅添加', 'service', '{}', '{"service": "subject", "serviceFunction": "createSubject"}', '', '', 'insert', NULL, NULL, NULL);
  23. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (363, NULL, NULL, 'setting-subjectManagement', 'updateItem', '✅更新', 'service', '{}', '{"service": "subject", "serviceFunction": "updateSubject"}', '', '', 'insert', NULL, NULL, NULL);
  24. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (364, NULL, NULL, 'setting-subjectManagement', 'removeSubject', '✅删除', 'service', '{}', '{"service": "subject", "serviceFunction": "removeSubject"}', '', '', 'insert', NULL, NULL, NULL);
  25. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (375, NULL, NULL, 'report-subjectBalanceYearStartAdjust', 'selectPeriodList', '✅查询会计期间', 'sql', '{}', '{"table": "period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  26. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (376, NULL, NULL, 'report-subjectBalanceYearStartAdjust', 'selectSubjectBalanceYearList', '✅查询科目余额-年', 'sql', '{}', '{"table": "view01_subject_balance_year", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  27. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (377, NULL, NULL, 'report-subjectBalanceYearStartAdjust', 'selectVoucherEntryList', '✅查询科目余额-年', 'sql', '{}', '{"table": "view01_voucher_entry", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  28. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, NULL, 'voucher-voucherManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_voucher_entry", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  29. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'voucher-voucherManagement', 'selectNextVoucherNumber', '✅查询下一个凭证号', 'service', '{}', '{"service": "voucher", "serviceFunction": "selectNextVoucherNumber"}', '', '', 'insert', NULL, NULL, NULL);
  30. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (384, NULL, NULL, 'voucher-voucherManagement', 'selectSubjectList', '✅查询科目列表', 'sql', '{}', '{ "table": "view01_subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  31. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (386, NULL, NULL, 'voucher-voucherManagement', 'createVoucherAndVoucherEntry', '✅添加凭证和条目', 'service', '{}', '{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}', '', '', 'insert', NULL, NULL, NULL);
  32. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (387, NULL, NULL, 'voucher-voucherManagement', 'removeVoucher', '✅删除凭证', 'service', '{}', '{"service": "voucher", "serviceFunction": "removeVoucher"}', '', '', 'insert', NULL, NULL, NULL);
  33. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (388, NULL, NULL, 'voucher-voucherManagement', 'file-selectItemList', '✅凭证单据-查询列表', 'sql', '{}', '{ "table": "voucher_file", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  34. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (389, NULL, NULL, 'voucher-voucherManagement', 'file-insertItem', '✅凭证单据-添加', 'sql', '{}', '{ "table": "voucher_file", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  35. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (390, NULL, NULL, 'voucher-voucherManagement', 'file-updateItem', '✅凭证单据-更新', 'sql', '{}', '{ "table": "voucher_file", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  36. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (391, NULL, NULL, 'voucher-voucherManagement', 'file-deleteItem', '✅凭证单据-删除', 'sql', '{}', '{ "table": "voucher_file", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  37. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (392, NULL, NULL, 'voucher-voucherManagement', 'updateVoucherAndVoucherEntry', '✅更新凭证和条目', 'service', '{}', '{"service": "voucher", "serviceFunction": "updateVoucherAndVoucherEntry"}', '', '', 'insert', NULL, NULL, NULL);
  38. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (393, NULL, NULL, 'voucher-voucherManagement', 'entry-selectAssistList', '✅凭证-查询辅助信息列表', 'service', '{}', '{"service": "assist", "serviceFunction": "selectAssistList"}', '', '', 'insert', NULL, NULL, NULL);
  39. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (401, NULL, '', 'account-generalLedger', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "account", "serviceFunction": "getItemListOfGeneralLedger"}', '', '', 'insert', NULL, NULL, NULL);
  40. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (403, NULL, NULL, 'account-subjectDetail', 'selectSubjectList', '✅查询科目列表', 'sql', '{}', '{ "table": "view01_subject_balance_period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  41. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (404, NULL, NULL, 'account-subjectDetail', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  42. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (405, NULL, NULL, 'account-multicolumnLedger', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "account", "serviceFunction": "getItemListOfMulticolumnLedger"}', '', '', 'insert', NULL, NULL, NULL);
  43. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (406, NULL, NULL, 'account-auxiliaryDetailedLedger', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "account", "serviceFunction": "getItemListOfAuxiliaryDetailedLedger"}', '', '', 'insert', NULL, NULL, NULL);
  44. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (407, NULL, NULL, 'account-auxiliaryBalanceSheet', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "account", "serviceFunction": "getItemListOfAuxiliaryBalanceSheet"}', '', '', 'insert', NULL, NULL, NULL);
  45. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (408, NULL, NULL, 'account-chronological', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_voucher_entry", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  46. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (411, NULL, NULL, 'account-subjectDetail', 'selectSubjectBalancePeriodList', '✅查询科目余额列表', 'sql', '{}', '{ "table": "view01_subject_balance_period", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  47. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (412, NULL, NULL, 'account-subjectDetail', 'selectVoucherEntryList', '✅添加凭证条目列表', 'sql', '{}', '{ "table": "view01_voucher_entry", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  48. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (413, NULL, NULL, 'account-subjectSummary', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "account", "serviceFunction": "getItemListOfSubjectBalance"}', '', '', 'insert', NULL, NULL, NULL);
  49. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (420, NULL, NULL, 'report-assetLiability', 'getItemListOfAssetLiability', '✅查询资产负债列表', 'service', '{}', '{"service": "report", "serviceFunction": "getItemListOfAssetLiability"}', '', '', 'insert', NULL, NULL, NULL);
  50. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (422, NULL, NULL, 'report-assetLiability', 'selectSubjectList', '✅查询科目列表', 'sql', '{}', '{ "table": "view01_subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  51. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (423, NULL, NULL, 'report-assetLiability', 'selectFormulaList', '✅获取公式列表', 'sql', '{}', '{ "table": "view02_report_asset_liability_formula", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  52. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (424, NULL, NULL, 'report-assetLiability', 'saveFormulaListOfAssetLiability', '✅保存公式列表', 'service', '{}', '{"service": "report", "serviceFunction": "saveFormulaListOfAssetLiability"}', '', '', 'insert', NULL, NULL, NULL);
  53. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (425, NULL, NULL, 'report-assetLiability', 'deleteFormulaItem', '✅删除公式', 'sql', '{}', '{ "table": "report_asset_liability_formula", "operation": "delete" }', '', '', 'insert', NULL, NULL, NULL);
  54. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (430, NULL, NULL, 'report-profit', 'getItemListOfProfit', '✅查询利润列表', 'service', '{}', '{"service": "report", "serviceFunction": "getItemListOfProfit"}', '', '', 'insert', NULL, NULL, NULL);
  55. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (432, NULL, NULL, 'report-profit', 'selectSubjectList', '✅查询科目列表', 'sql', '{}', '{ "table": "view01_subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  56. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (433, NULL, NULL, 'report-profit', 'selectFormulaList', '✅获取公式列表', 'sql', '{}', '{ "table": "view02_report_profit_formula", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  57. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (434, NULL, NULL, 'report-profit', 'saveFormulaListOfAssetLiability', '✅保存公式列表', 'service', '{}', '{"service": "report", "serviceFunction": "saveFormulaListOfProfit"}', '', '', 'insert', NULL, NULL, NULL);
  58. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (435, NULL, NULL, 'report-profit', 'deleteFormulaItem', '✅删除公式', 'sql', '{}', '{ "table": "report_profit_formula", "operation": "delete" }', '', '', 'insert', NULL, NULL, NULL);
  59. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (436, NULL, NULL, 'report-profitDept', 'selectAssistDepartList', '✅查询部门列表', 'sql', '{}', '{"table": "assist_depart", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  60. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (437, NULL, NULL, 'report-profitProject', 'selectAssistList', '✅查询辅助核算列表', 'service', '{}', '{"service": "assist", "serviceFunction": "selectAssistList"}', '', '', 'insert', NULL, NULL, NULL);
  61. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (440, NULL, NULL, 'report-cashFlow', 'getItemListOfCashFlow', '✅查询现金流列表', 'service', '{}', '{"service": "report", "serviceFunction": "getItemListOfCashFlow"}', '', '', 'insert', NULL, NULL, NULL);
  62. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (441, NULL, NULL, 'report-cashFlow', 'ex-getItemListOfCashFlowEx', '✅查询现金流EX列表', 'service', '{}', '{"service": "report", "serviceFunction": "getItemListOfCashFlowEx"}', '', '', 'insert', NULL, NULL, NULL);
  63. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (442, NULL, NULL, 'report-cashFlow', 'ex-selectSubjectList', '✅查询科目列表', 'sql', '{}', '{ "table": "view01_subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  64. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (443, NULL, NULL, 'report-cashFlow', 'ex-selectFormulaList', '✅获取公式列表', 'sql', '{}', '{ "table": "view02_report_cash_flow_ex_formula", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  65. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (444, NULL, NULL, 'report-cashFlow', 'ex-saveFormulaListOfCashFlowEx', '✅保存公式列表', 'service', '{}', '{"service": "report", "serviceFunction": "saveFormulaListOfCashFlowEx"}', '', '', 'insert', NULL, NULL, NULL);
  66. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (445, NULL, NULL, 'report-cashFlow', 'ex-deleteFormulaItem', '✅删除公式', 'sql', '{}', '{ "table": "report_cash_flow_ex_formula", "operation": "delete" }', '', '', 'insert', NULL, NULL, NULL);
  67. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (446, NULL, NULL, 'report-cashFlow', 'getItemListOfCashFlowForPeriodIdList', '✅查询现金流列表', 'service', '{}', '{"service": "report", "serviceFunction": "getItemListOfCashFlowForPeriodIdList"}', '', '', 'insert', NULL, NULL, NULL);
  68. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (447, NULL, NULL, 'report-summary', 'getItemListOfSummary', '✅查询财务概要信息列表', 'service', '{}', '{"service": "report", "serviceFunction": "getItemListOfSummary"}', '', '', 'insert', NULL, NULL, NULL);
  69. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (451, NULL, NULL, 'checkout-periodCheckout', 'voucherTemplate-deleteCheckoutVoucher', '✅凭证模板-删除结转凭证', 'service', '{}', '{"service": "period", "serviceFunction": "deleteCheckoutVoucher"}', '', '', 'insert', NULL, NULL, NULL);
  70. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (452, NULL, NULL, 'checkout-periodCheckout', 'voucherTemplate-getCheckoutVoucherList', '✅凭证模板-查询列表', 'service', '{}', '{"service": "period", "serviceFunction": "getCheckoutVoucherList"}', '', '', 'insert', NULL, NULL, NULL);
  71. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (453, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'checkout-periodCheckout', 'voucherTemplate-insertItem', '✅凭证模板-添加', 'sql', '{}', '{ "table": "voucher_template", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  72. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (454, NULL, NULL, 'checkout-periodCheckout', 'voucherTemplate-updateItem', '✅凭证模板-更新', 'sql', '{}', '{ "table": "voucher_template", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  73. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (455, NULL, NULL, 'checkout-periodCheckout', 'voucherTemplate-deleteItem', '✅凭证模板-删除', 'sql', '{}', '{ "table": "voucher_template", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  74. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (456, NULL, NULL, 'checkout-periodCheckout', 'voucherTemplate-selectSubjectList', '✅查询科目列表', 'sql', '{}', '{ "table": "view01_subject", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  75. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (457, NULL, NULL, 'checkout-periodCheckout', 'voucherTemplate-generateCheckoutVoucherList', '✅生成结转凭证', 'service', '{}', '{"service": "period", "serviceFunction": "generateCheckoutVoucherList"}', '', '', 'insert', NULL, NULL, NULL);
  76. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (458, NULL, NULL, 'assistCustomerManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "assist_customer", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  77. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (459, NULL, NULL, 'assistCustomerManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "assist_customer", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  78. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (460, NULL, NULL, 'assistCustomerManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "assist_customer", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  79. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (461, NULL, NULL, 'assistCustomerManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "assist_customer", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  80. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (462, NULL, NULL, 'assistManagement', 'assistCustomer-selectItemList', '✅stock-查询列表', 'sql', '{}', '{ "table": "assist_customer", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  81. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (463, NULL, NULL, 'assistManagement', 'assistCustomer-insertItem', '✅stock-添加', 'sql', '{}', '{ "table": "assist_customer", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  82. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (464, NULL, NULL, 'assistManagement', 'assistCustomer-updateItem', '✅stock-更新', 'sql', '{}', '{ "table": "assist_customer", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  83. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (465, NULL, NULL, 'assistManagement', 'assistCustomer-deleteItem', '✅stock-删除', 'sql', '{}', '{ "table": "assist_customer", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  84. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (466, NULL, NULL, 'assistManagement', 'assistDepart-selectItemList', '✅stock-查询列表', 'sql', '{}', '{ "table": "assist_depart", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  85. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (467, NULL, NULL, 'assistManagement', 'assistDepart-insertItem', '✅stock-添加', 'sql', '{}', '{ "table": "assist_depart", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  86. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (468, NULL, NULL, 'assistManagement', 'assistDepart-updateItem', '✅stock-更新', 'sql', '{}', '{ "table": "assist_depart", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  87. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (469, NULL, NULL, 'assistManagement', 'assistDepart-deleteItem', '✅stock-删除', 'sql', '{}', '{ "table": "assist_depart", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  88. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (470, NULL, NULL, 'assistManagement', 'project-selectItemList', '✅stock-查询列表', 'sql', '{}', '{ "table": "assist_project", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  89. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (471, NULL, NULL, 'assistManagement', 'project-insertItem', '✅stock-添加', 'sql', '{}', '{ "table": "assist_project", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  90. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (472, NULL, NULL, 'assistManagement', 'project-updateItem', '✅stock-更新', 'sql', '{}', '{ "table": "assist_project", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  91. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (473, NULL, NULL, 'assistManagement', 'project-deleteItem', '✅stock-删除', 'sql', '{}', '{ "table": "assist_project", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  92. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (474, NULL, NULL, 'assistManagement', 'staff-selectItemList', '✅stock-查询列表', 'sql', '{}', '{ "table": "assist_staff", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  93. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (475, NULL, NULL, 'assistManagement', 'staff-insertItem', '✅stock-添加', 'sql', '{}', '{ "table": "assist_staff", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  94. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (476, NULL, NULL, 'assistManagement', 'staff-updateItem', '✅stock-更新', 'sql', '{}', '{ "table": "assist_staff", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  95. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (477, NULL, NULL, 'assistManagement', 'staff-deleteItem', '✅stock-删除', 'sql', '{}', '{ "table": "assist_staff", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  96. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (478, NULL, NULL, 'assistManagement', 'supplier-selectItemList', '✅stock-查询列表', 'sql', '{}', '{ "table": "assist_supplier", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  97. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (479, NULL, NULL, 'assistManagement', 'supplier-insertItem', '✅stock-添加', 'sql', '{}', '{ "table": "assist_supplier", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  98. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (480, NULL, NULL, 'assistManagement', 'supplier-updateItem', '✅stock-更新', 'sql', '{}', '{ "table": "assist_supplier", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  99. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (481, NULL, NULL, 'assistManagement', 'supplier-deleteItem', '✅stock-删除', 'sql', '{}', '{ "table": "assist_supplier", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  100. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (482, NULL, NULL, 'assistManagement', 'customer-selectItemList', '✅stock-查询列表', 'sql', '{}', '{ "table": "assist_customer", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  101. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (483, NULL, NULL, 'assistManagement', 'customer-insertItem', '✅stock-添加', 'sql', '{}', '{ "table": "assist_customer", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  102. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (484, NULL, NULL, 'assistManagement', 'customer-updateItem', '✅stock-更新', 'sql', '{}', '{ "table": "assist_customer", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  103. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (485, NULL, NULL, 'assistManagement', 'customer-deleteItem', '✅stock-删除', 'sql', '{}', '{ "table": "assist_customer", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  104. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (486, NULL, NULL, 'assistManagement', 'depart-selectItemList', '✅stock-查询列表', 'sql', '{}', '{ "table": "assist_depart", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  105. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (487, NULL, NULL, 'assistManagement', 'depart-insertItem', '✅stock-添加', 'sql', '{}', '{ "table": "assist_depart", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  106. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (488, NULL, NULL, 'assistManagement', 'depart-updateItem', '✅stock-更新', 'sql', '{}', '{ "table": "assist_depart", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  107. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (489, NULL, NULL, 'assistManagement', 'depart-deleteItem', '✅stock-删除', 'sql', '{}', '{ "table": "assist_depart", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  108. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (490, NULL, '', 'fundAccountManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "fund_account", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  109. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (491, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'fundAccountManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "fund_account", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  110. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (492, NULL, NULL, 'fundAccountManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "fund_account", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  111. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (493, NULL, NULL, 'fundAccountManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "fund_account", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  112. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (494, NULL, NULL, 'fundAccountEntryManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_fund_account_entry", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  113. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (495, NULL, '{"before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": []}', 'fundAccountEntryManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "fund_account_entry", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  114. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (496, NULL, NULL, 'fundAccountEntryManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "fund_account_entry", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  115. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (497, NULL, '{"after": [{"service": "fundAccountEntry", "serviceFunction": "removeVoucher"}]}', 'fundAccountEntryManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "fund_account_entry", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  116. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (498, NULL, '', 'fundAccountManagement', 'selectSubjectList', '✅账户设置-获取会计科目', 'sql', '{}', '{"table": "subject", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  117. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (499, NULL, NULL, 'setting-voucherTemplateManagement', 'selectVoucherTemplateList', '✅凭证模板-查询列表', 'sql', '{}', '{"table": "voucher_template", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  118. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (500, NULL, NULL, 'voucher-voucherManagement', 'selectNextVoucherNumberMap', '✅查询下一个凭证号', 'sql', '{}', '{ "table": "view01_next_voucher_number", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  119. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (501, NULL, '{"after": [{"service": "voucher", "serviceFunction": "relAccountEntryVoucherIdAfterHook"}]}', 'fundAccountEntryManagement', 'createVoucherAndVoucherEntry', '✅添加凭证和条目', 'service', '{}', '{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  120. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (502, NULL, NULL, 'fundAccountEntryManagement', 'importFundAccountEntryData', '✅导入日记账记录', 'service', NULL, '{"service": "fundAccountEntry", "serviceFunction": "importFundAccountEntryData"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  121. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (600, NULL, NULL, 'invoice-invoiceManagement', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "invoice", "serviceFunction": "selectInvoice"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  122. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (601, NULL, NULL, 'invoice-invoiceManagement', 'selectTemplateList', '✅查询模板列表', 'sql', '{}', '{ "table": "voucher_template", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  123. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (603, NULL, NULL, 'invoice-invoiceManagement', 'updateItem', '✅更新发票', 'service', '{}', '{"service": "invoice", "serviceFunction": "updateItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  124. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (604, NULL, NULL, 'invoice-invoiceManagement', 'deleteItem', '✅删除模板', 'service', '{}', '{"service": "invoice", "serviceFunction": "deleteItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  125. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (605, NULL, NULL, 'invoice-invoiceManagement', 'createItem', '✅新建发票', 'service', '{}', '{"service": "invoice", "serviceFunction": "createItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  126. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (606, NULL, NULL, 'invoice-invoiceManagement', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "assist_customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  127. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (607, NULL, NULL, 'invoice-invoiceManagement', 'selectSupplierList', '✅查询供应商列表', 'sql', '{}', '{ "table": "assist_supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  128. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (608, NULL, NULL, 'invoice-invoiceManagement', 'selectEntryList', '✅查询发票详情数据', 'sql', '{}', '{ "table": "invoice_entry", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  129. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (609, NULL, '{"after": [{"service": "invoice", "serviceFunction": "syncVoucherIdToInvoice"}]}', 'invoice-invoiceManagement', 'createVoucherAndVoucherEntry', '✅添加凭证和条目', 'service', '{}', '{"service": "voucher", "serviceFunction": "createVoucherAndVoucherEntry"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  130. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (610, NULL, '', 'invoice-invoiceManagement', 'deleteSelected', '✅添加凭证和条目', 'service', '{}', '{"service": "invoice", "serviceFunction": "deleteSelected"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  131. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (611, NULL, NULL, 'userManagement', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{"table": "_user", "operation": "select"}', '{"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"}', 'update', NULL, NULL, '2022-04-29T16:33:28+08:00');
  132. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (612, NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{"service": "userManagement", "serviceFunction": "addUser"}', '{"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"}', 'update', NULL, NULL, '2022-04-28T16:36:00+08:00');
  133. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (613, NULL, NULL, 'userManagement', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{"service": "userManagement", "serviceFunction": "resetUserPassword"}', '{"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"}', 'update', NULL, NULL, '2022-04-28T16:37:21+08:00');
  134. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (614, NULL, NULL, 'userManagement', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{"table": "_user", "operation": "jhUpdate"}', '{"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"}', 'update', NULL, NULL, '2022-04-29T16:33:27+08:00');
  135. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (615, NULL, NULL, 'appAccountManagement', 'selectItemList', '✅查询列表', 'service', '{}', '{"service": "appAccount", "serviceFunction": "selectAppAccountList"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  136. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (616, NULL, NULL, 'appAccountManagement', 'createAppAcount', '✅添加账套', 'service', '{}', '{"service": "appAccount", "serviceFunction": "createAppAcount"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  137. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (617, NULL, NULL, 'appAccountManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "_app_account", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  138. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (618, NULL, NULL, 'appAccountManagement', 'initAppAccountConfigTable', '✅初始化账套配置表', 'service', '{}', '{"service": "appAccount", "serviceFunction": "initAppAcountConfigTable"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  139. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (619, NULL, NULL, 'appAccountManagement', 'importAppAccountDataOfSubjectList', '✅导入账套数据-科目列表', 'service', '{}', '{"service": "appAccount", "serviceFunction": "importAppAccountDataOfSubjectList"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  140. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (620, NULL, NULL, 'appAccountManagement', 'importAppAccountDataOfVoucherList', '✅导入账套数据-凭证列表', 'service', '{}', '{"service": "appAccount", "serviceFunction": "importAppAccountDataOfVoucherList"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  141. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (621, NULL, NULL, 'appAccountManagement', 'reCheckoutAllPeriod', '✅计算科目余额', 'service', '{}', '{"service": "appAccount", "serviceFunction": "reCheckoutAllPeriod"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  142. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (622, NULL, NULL, 'appAccountManagement', 'selectSubjectList', '✅查询科目列表', 'sql', '{}', '{"table": "view01_subject", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  143. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (623, NULL, NULL, 'fundAccountTransferEntryManagement', 'importFundAccountTransferEntryData', '✅导入资金转账数据', 'service', NULL, '{"service": "fundAccountTransferEntry", "serviceFunction": "importFundAccountTransferEntryData"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  144. INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (624, NULL, NULL, 'fundAccountTransferEntryManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_voucher_transfer_entry", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  145. INSERT INTO _resource