页面

12129

页面总览

_page结构

  1. CREATE TABLE `_page` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  4. `pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  5. `pageHook` varchar(255) DEFAULT NULL COMMENT 'pageHook',
  6. `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  7. `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  8. `pageIcon` text ,
  9. `sort` varchar(255) DEFAULT NULL,
  10. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  11. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  12. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  13. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  14. PRIMARY KEY (`id`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 159 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

  • 页面信息
pageName pageId pageType pageFile sort pageHook
帮助 help dynamicInMenu helpV4 67 null

登陆

  • 页面信息
pageName pageId pageType pageFile sort pageHook
登陆 login loginV4 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 3 update 2022-04-27T15:32:57+08:00

[采购]供货商列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[采购]供货商列表 supplierManagement showInMenu 03 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"},{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅productList-更新 supplierManagement productList-updateItem null sql { "table": "supplier_product", "operation": "jhUpdate" } {} 230 insert
✅productList-删除 supplierManagement productList-deleteItem null sql { "table": "supplier_product", "operation": "jhDelete" } {} 231 insert
✅createPurchaseOrder-查询供货商列表 supplierManagement createPurchaseOrder-selectSupplierList null sql { "table": "supplier", "operation": "select" } {} 232 insert
✅createPurchaseOrder-查询产品列表 supplierManagement createPurchaseOrder-selectProductList null sql { "table": "supplier_product", "operation": "select" } {} 233 insert
✅createPurchaseOrder-添加采购订单 supplierManagement createPurchaseOrder-insertItem { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } sql { "table": "purchase_order", "operation": "insert" } {} 234 insert
✅supplierManagement查询-查询列表 supplierManagement selectItemList null sql { "table": "view01_supplier_info", "operation": "select" } {} 235 insert
✅supplierManagement查询-添加成员 supplierManagement insertItem { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } sql { "table": "supplier", "operation": "insert" } {} 236 insert
✅supplierManagement查询-更新成员 supplierManagement updateItem null sql { "table": "supplier", "operation": "jhUpdate" } {} 237 insert
✅supplierManagement查询-删除信息 supplierManagement deleteItem null sql { "table": "supplier", "operation": "jhDelete" } {} 238 insert
✅productList-查询列表 supplierManagement productList-selectItemList null sql { "table": "supplier_product", "operation": "select" } {} 239 insert
✅productList-添加 supplierManagement productList-insertItem null sql { "table": "supplier_product", "operation": "insert" } {} 240 insert
✅createPurchaseOrder-添加采购产品价格记录 supplierManagement createPurchaseOrder-insertPurchasePriceRecord null sql { "table": "purchase_price_history", "operation": "jhInsert" } {} 818 insert
✅createPurchaseOrder-查询采购产品价格记录 supplierManagement createPurchaseOrder-selectPriceList null sql { "table": "purchase_price_history", "operation": "select" } {} 820 insert

[销售]客户列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[销售]客户列表 customerManagement showInMenu 04 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅createSaleOrder-查询客户列表 customerManagement createSaleOrder-selectCustomerList null sql { "table": "customer", "operation": "select" } {} 40 insert
✅createSaleOrder-查询库存列表 customerManagement createSaleOrder-selectProductListByInventory null sql { "table": "view01_warehouse_inventory", "operation": "select" } {} 41 insert
✅createSaleOrder-添加销售订单 customerManagement createSaleOrder-insertItem { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } sql { "table": "sale_order", "operation": "insert" } {} 42 insert
✅查询订单信息 customerManagement createSaleOrder-selectOrder null sql { "table": "sale_order", "operation": "select" } {} 43 insert
✅销售出库 customerManagement createSaleOrder-inventoryOut null service { "service": "inventory", "serviceFunction": "inventoryOut" } {} 44 insert
✅查销售订单 customerManagement selectSaleOrderList null sql { "table": "sale_order", "operation": "select" } {} 45 insert
✅新增销售退货订单 customerManagement insertSalesReturnOrder { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } sql { "table": "sale_return_order", "operation": "jhInsert" } {} 46 insert
✅customerManagement查询-查询列表 customerManagement selectItemList null sql { "table": "customer", "operation": "select" } {} 47 insert
✅customerManagement查询-添加成员 customerManagement insertItem { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } sql { "table": "customer", "operation": "insert" } {} 48 insert
✅customerManagement查询-更新成员 customerManagement updateItem null sql { "table": "customer", "operation": "jhUpdate" } {} 49 insert
✅customerManagement查询-删除信息 customerManagement deleteItem null sql { "table": "customer", "operation": "jhDelete" } {} 50 insert
✅createSaleOrder-添加销售产品价格记录 customerManagement createSaleOrder-insertSalesProductPriceRecord null sql { "table": "sale_price_history", "operation": "jhInsert" } {} 819 insert
✅createSaleOrder-查询采购产品价格记录 customerManagement createSaleOrder-selectPriceList null sql { "table": "sale_price_history", "operation": "select" } {} 821 insert

[采购]采购订单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[采购]采购订单 purchaseOrderManagement showInMenu null 05 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅更新订单备注 purchaseOrderManagement viewPurchaseOrder-updateOrderRemark null sql { "table": "purchase_order", "operation": "jhUpdate" } {} 130 insert
✅查询列表 purchaseOrderManagement selectItemList { "after": [ { "service": "purchase", "serviceFunction": "appendTicketList" } ] } sql { "table": "view01_purchase_order", "operation": "select" } {} 131 insert
✅添加 purchaseOrderManagement insertItem null sql { "table": "purchase_order", "operation": "insert" } {} 132 insert
✅更新 purchaseOrderManagement updateItem null sql { "table": "purchase_order", "operation": "jhUpdate" } {} 133 insert
✅删除 purchaseOrderManagement deleteItem null service { "service": "purchase", "serviceFunction": "deleteOrder" } {} 134 insert
✅查询订单信息 purchaseOrderManagement viewPurchaseOrder-selectOrder null sql { "table": "purchase_order", "operation": "select" } {} 135 insert
✅更新订单状态 purchaseOrderManagement viewPurchaseOrder-updateOrderStatus null sql { "table": "purchase_order", "operation": "jhUpdate" } {} 136 insert
✅查询供货商列表 purchaseOrderManagement selectSupplierList null sql { "table": "supplier", "operation": "select" } {} 137 insert
✅查询供货商信息 purchaseOrderManagement viewPurchaseOrder-selectSupplier null sql { "table": "supplier", "operation": "select" } {} 138 insert
✅查询订单信息 purchaseOrderManagement inventoryInByPurchaseOrder-selectOrder null sql { "table": "purchase_order", "operation": "select" } {} 139 insert
✅入库 purchaseOrderManagement inventoryInByPurchaseOrder-inventoryIn null service { "service": "inventory", "serviceFunction": "inventoryIn" } {} 140 insert
✅查询供货商信息 purchaseOrderManagement inventoryInByPurchaseOrder-selectSupplier null sql { "table": "supplier", "operation": "select" } {} 141 insert
✅查询入库信息 purchaseOrderManagement viewInventoryInByPurchaseOrder-selectInventoryInList null sql { "table": "view01_warehouse_inventory", "operation": "select" } {} 142 insert
✅查询订单信息 purchaseOrderManagement viewInventoryInByPurchaseOrder-selectOrder null sql { "table": "purchase_order", "operation": "select" } {} 143 insert
✅查询供货商信息 purchaseOrderManagement viewInventoryInByPurchaseOrder-selectSupplier null sql { "table": "supplier", "operation": "select" } {} 144 insert

[销售]销售订单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[销售]销售订单 saleOrderManagement showInMenu null 06 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询客户信息 saleOrderManagement inventoryOutBySaleOrder-selectCustomer null sql { "table": "customer", "operation": "select" } {} 123 insert
✅查询列表 saleOrderManagement selectItemList { "after": [ { "service": "sale", "serviceFunction": "appendTicketList" } ] } sql { "table": "view01_sale_order", "operation": "select" } {} 180 insert
✅添加 saleOrderManagement insertItem null sql { "table": "sale_order", "operation": "insert" } {} 181 insert
✅更新 saleOrderManagement updateItem null sql { "table": "sale_order", "operation": "jhUpdate" } {} 182 insert
✅删除 saleOrderManagement deleteItem null service { "service": "sale", "serviceFunction": "deleteOrder" } {} 183 insert
✅查询订单信息 saleOrderManagement viewSaleOrder-selectOrder null sql { "table": "sale_order", "operation": "select" } {} 184 insert
✅更新订单状态 saleOrderManagement viewSaleOrder-updateOrderStatus null sql { "table": "sale_order", "operation": "jhUpdate" } {} 185 insert
✅查询客户列表 saleOrderManagement selectCustomerList null sql { "table": "customer", "operation": "select" } {} 186 insert
✅查询客户信息 saleOrderManagement viewSaleOrder-selectCustomer null sql { "table": "customer", "operation": "select" } {} 187 insert
✅查询订单信息 saleOrderManagement inventoryOutBySaleOrder-selectOrder null sql { "table": "sale_order", "operation": "select" } {} 188 insert
✅销售出库 saleOrderManagement inventoryOutBySaleOrder-inventoryOut null service { "service": "inventory", "serviceFunction": "inventoryOut" } {} 189 insert
✅更新订单备注 saleOrderManagement viewSaleOrder-updateOrderRemark null sql { "table": "sale_order", "operation": "jhUpdate" } {} 191 insert

[库存仓库]库存管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[库存仓库]库存管理 warehouseInventoryManagement showInMenu null 08 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 warehouseInventoryManagement selectItemList null sql { "table": "view01_warehouse_inventory", "operation": "select" } {} 360 insert
✅添加 warehouseInventoryManagement insertItem null sql { "table": "warehouse_inventory", "operation": "insert" } {} 361 insert
✅更新 warehouseInventoryManagement updateItem null sql { "table": "warehouse_inventory", "operation": "jhUpdate" } {} 362 insert
✅删除 warehouseInventoryManagement deleteItem null sql { "table": "warehouse_inventory", "operation": "jhDelete" } {} 363 insert

[库存仓库]出入库记录

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[库存仓库]出入库记录 warehouseInventoryRecordOfProduct showInMenu null 12 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

[库存仓库]出入库单【打印】

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[库存仓库]出入库单【打印】 warehouseInventoryRecordOfOrder showInMenu null 13 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

[资产仓库]资产管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[资产仓库]资产管理 warehouseAssetManagement showInMenu null 11 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 warehouseAssetManagement selectItemList null sql { "table": "warehouse_asset", "operation": "select" } {} 320 insert
✅添加 warehouseAssetManagement insertItem null sql { "table": "warehouse_asset", "operation": "insert" } {} 321 insert
✅更新 warehouseAssetManagement updateItem null sql { "table": "warehouse_asset", "operation": "jhUpdate" } {} 322 insert
✅删除 warehouseAssetManagement deleteItem null sql { "table": "warehouse_asset", "operation": "jhDelete" } {} 323 insert

[资产仓库]资产记录

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[资产仓库]资产记录 warehouseAssetRecord showInMenu null 11 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 warehouseAssetRecord selectItemList null sql { "table": "warehouse_asset_record", "operation": "select" } {} 340 insert
✅添加 warehouseAssetRecord insertItem null sql { "table": "warehouse_asset_record", "operation": "insert" } {} 341 insert
✅更新 warehouseAssetRecord updateItem null sql { "table": "warehouse_asset_record", "operation": "jhUpdate" } {} 342 insert
✅删除 warehouseAssetRecord deleteItem null sql { "table": "warehouse_asset_record", "operation": "jhDelete" } {} 343 insert

[库存仓库]申请单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[库存仓库]申请单 warehouseTicketRequest showInMenu 11 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询客户列表 warehouseTicketRequest selectCustomerList null sql { "table": "customer", "operation": "select" } {} 400 insert
✅查询供货商列表 warehouseTicketRequest selectSupplierList null sql { "table": "supplier", "operation": "select" } {} 401 insert
✅查询申请单列表 warehouseTicketRequest selectTicketList null sql { "table": "ticket", "operation": "select"} {} 402 insert

[资产仓库]申请单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[资产仓库]申请单 assetTicketRequest showInMenu 12 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询客户列表 assetTicketRequest selectCustomerList null sql { "table": "customer", "operation": "select" } {} 420 insert
✅查询供货商列表 assetTicketRequest selectSupplierList null sql { "table": "supplier", "operation": "select" } {} 421 insert
✅查询申请单列表 assetTicketRequest selectTicketList null sql { "table": "ticket", "operation": "select"} {} 422 insert

[财务收款付款]收款管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务收款付款]收款管理 paymentOfReceipt showInMenu null 21 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 paymentOfReceipt selectItemList null sql { "table": "payment", "operation": "select" } {} 110 insert
✅添加 paymentOfReceipt insertItem null sql { "table": "payment", "operation": "insert" } {} 111 insert
✅更新 paymentOfReceipt updateItem null sql { "table": "payment", "operation": "jhUpdate" } {} 112 insert
✅删除 paymentOfReceipt deleteItem null sql { "table": "payment", "operation": "jhDelete" } {} 113 insert
✅查询订单列表 paymentOfReceipt selectPaymentOrderList null service {"service": "payment", "serviceFunction": "selectPaymentOrderList"} {} 114 insert

[财务收款付款]付款管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务收款付款]付款管理 paymentOfPay showInMenu null 20 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 paymentOfPay selectItemList null sql { "table": "payment", "operation": "select" } {} 90 insert
✅添加 paymentOfPay insertItem null sql { "table": "payment", "operation": "insert" } {} 91 insert
✅更新 paymentOfPay updateItem null sql { "table": "payment", "operation": "jhUpdate" } {} 92 insert
✅删除 paymentOfPay deleteItem null sql { "table": "payment", "operation": "jhDelete" } {} 93 insert
✅查询订单列表 paymentOfPay selectPaymentOrderList null service {"service": "payment", "serviceFunction": "selectPaymentOrderList"} {} 94 insert

[财务凭证]资产价值管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务凭证]资产价值管理 assetFinanceManagement showInMenu null 25 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅资产价值管理-查询资产信息 assetFinanceManagement selectFinanceAsset null sql { "table": "finance_asset", "operation": "select" } {} 20 insert
✅资产价值管理-添加 assetFinanceManagement insertItem null sql { "table": "finance_asset", "operation": "jhInsert" } {} 21 insert
✅资产价值管理-更新 assetFinanceManagement updateItem null sql { "table": "finance_asset", "operation": "jhUpdate" } {} 22 insert
✅资产价值管理-删除 assetFinanceManagement deleteItem null sql { "table": "finance_asset", "operation": "jhDelete" } {} 23 insert
✅资产价值管理-查询资产类别 assetFinanceManagement selectAssetType null sql { "table": "finance_asset_type", "operation": "select" } {} 24 insert
✅资产价值管理-查询资产折旧明细 assetFinanceManagement selectFinanceAssetRecord null sql {"table": "finance_asset_record", "operation": "select"} {} 25 insert
✅资产价值管理-初始化折旧数据 assetFinanceManagement initDepreciationData null service { "service": "voucher", "serviceFunction": "initDepreciationData" } 26 insert
✅资产价值管理-查询资产库存 assetFinanceManagement selectWarehouseAsset null sql { "table": "view01_warehouse_asset_not_in_finance_asset", "operation": "select" } {} 27 insert
✅资产价值管理-查询会计期间 assetFinanceManagement selectFinancePeriod null sql {"table": "view01_period_voucher", "operation": "select"} {} 28 insert
✅资产价值管理-查询会计科目 assetFinanceManagement selectFinanceSubject null sql {"table": "subject", "operation": "select"} {} 29 insert
✅查询下个凭证字号 assetFinanceManagement selectNextVoucherNumber null sql { "table": "view01_next_voucher_number", "operation": "select" } {} 814 insert

[财务收款付款]申请单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务收款付款]申请单 paymentTicketRequest showInMenu 24 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询客户列表 paymentTicketRequest selectCustomerList null sql { "table": "customer", "operation": "select" } {} 440 insert
✅查询供货商列表 paymentTicketRequest selectSupplierList null sql { "table": "supplier", "operation": "select" } {} 441 insert
✅查询申请单列表 paymentTicketRequest selectTicketList null sql { "table": "ticket", "operation": "select"} {} 442 insert

[财务凭证]凭证生成

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务凭证]凭证生成 voucherGenerate showInMenu null 27 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 voucherGenerate selectItemList null sql { "table": "view01_ticket_voucher", "operation": "select" } {} 300 insert
✅添加 voucherGenerate insertItem null sql { "table": "ticket", "operation": "insert" } {} 301 insert
✅更新 voucherGenerate updateItem null sql { "table": "ticket", "operation": "jhUpdate" } {} 302 insert
✅删除 voucherGenerate deleteItem null sql { "table": "ticket", "operation": "jhDelete" } {} 303 insert
✅查询下个凭证字号 voucherGenerate selectNextVoucherNumber null sql { "table": "view01_next_voucher_number", "operation": "select" } {} 304 insert
✅生成单据凭证 voucherGenerate createTicketVoucher null service { "service": "voucher", "serviceFunction": "createTicketVoucher" } {} 305 insert
✅删除凭证 voucherGenerate deleteVoucher null sql { "table": "voucher", "operation": "jhDelete" } {} 306 insert
✅查询凭证 voucherGenerate selectVoucher { "after": [ { "service": "voucher", "serviceFunction": "appendEntryList" } ] } sql { "table": "voucher", "operation": "select" } {} 307 insert
✅生成折旧凭证 voucherGenerate generateDepreciationVoucher null service { "service": "voucher", "serviceFunction": "generateDepreciationVoucher" } {} 657 insert

[销售]销售退货订单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[销售]销售退货订单 salesReturnOrderManagement showInMenu null 07 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询退货订单列表 salesReturnOrderManagement selectItemList { "after": [ { "service": "return", "serviceFunction": "appendTicketList" } ] } sql { "table": "view01_sale_return_order", "operation": "select" } {} 210 insert
✅查询客户列表 salesReturnOrderManagement selectCustomerList null sql { "table": "customer", "operation": "select" } {} 211 insert
✅更新退货订单 salesReturnOrderManagement updateReturnOrder sql { "table": "sale_return_order", "operation": "jhUpdate" } {} 212 insert

[采购]采购退货订单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[采购]采购退货订单 purchaseReturnOrderManagement showInMenu null 06 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询退货列表 purchaseReturnOrderManagement selectItemList { "after": [ { "service": "purchase", "serviceFunction": "appendTicketListWhenReturn" } ] } sql { "table": "view01_purchase_return_order", "operation": "select" } {} 160 insert
✅查询可退货采购列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectPurchaseList sql { "table": "view01_purchase_order", "operation": "select" } {} 161 insert
✅查询采购单的现有库存列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectProductListFromInventory { "after": [ { "service": "purchase", "serviceFunction": "calcInventoryOrderCount" } ] } sql { "table": "view01_warehouse_inventory", "operation": "select" } {} 162 insert
✅新增退货订单 purchaseReturnOrderManagement createPurchaseReturnOrder-insertItem { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } sql { "table": "purchase_return_order", "operation": "insert" } {} 163 insert
✅查询退货列表 purchaseReturnOrderManagement viewReturnOrder-selectOrder sql { "table": "view01_purchase_return_order", "operation": "select" } {} 164 insert
✅更新退货订单 purchaseReturnOrderManagement viewReturnOrder-updateOrderStatus null sql { "table": "purchase_return_order", "operation": "jhUpdate" } {} 165 insert
✅查询可退货采购列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectPurchaseAssetList null sql { "table": "warehouse_asset", "operation": "select" } {} 815 insert
✅查询资产采购单的现有库存列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectProductListFromAsset { "after": [ { "service": "purchase", "serviceFunction": "calcAssetOrderCount" } ] } sql { "table": "warehouse_asset", "operation": "select" } {} 816 insert

采购退货单打印

  • 页面信息
pageName pageId pageType pageFile sort pageHook
采购退货单打印 printPurchaseReturnOrder seo null 99 {"beforeHook": [{"service": "print", "serviceFunc": "appendPurchaseReturnInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

打印销售订单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
打印销售订单 printSaleOrder seo null 99 {"beforeHook": [{"service": "print", "serviceFunc": "appendSaleOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

打印销售退货单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
打印销售退货单 printSaleReturnOrder seo null 99 {"beforeHook": [{"service": "print", "serviceFunc": "appendSaleReturnOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

打印采购入库单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
打印采购入库单 printTicketWarehouseIn seo null 99 {"beforeHook": [{"service": "print", "serviceFunc": "appendTicketWarehouseInInvoiceInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

打印入库单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
打印入库单 printWarehouseInventoryIn seo null 99 {"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryInInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

打印入库单

  • 页面信息
pageName pageId pageType pageFile sort pageHook
打印入库单 printWarehouseInventoryOut seo null 99 {"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryOutInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

用户管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
用户管理 userManagement showInAvatarMenu null 6 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅用户管理-查询信息 userManagement selectItemList null sql {"table": "_user", "operation": "select"} 671 update 2022-04-29T16:33:28+08:00 {"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651221207913_1347965", "packageType": "httpRequest"} {"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"}
✅用户管理-查询信息 userManagement insertItem null service {"service": "userManagement", "serviceFunction": "addUser"} 672 update 2022-04-28T16:36:00+08:00 {"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"} {"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"}
✅用户管理-修改密码 userManagement resetUserPassword null service {"service": "userManagement", "serviceFunction": "resetUserPassword"} 673 update 2022-04-28T16:37:21+08:00 {"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"} {"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"}
✅用户管理-更新用户 userManagement updateItem null sql {"table": "_user", "operation": "jhUpdate"} 674 update 2022-04-29T16:33:27+08:00 {"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"} {"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"}

[财务凭证]资产折旧明细表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务凭证]资产折旧明细表 assetRecord showInMenu null 25 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅资产折旧明细-查询列表 assetRecord selectItemList null sql { "table": "finance_asset_record", "operation": "select" } {} 665 insert

[财务凭证]资产汇总

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务凭证]资产汇总 assetSummary showInMenu null 25 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅资产汇总-查询列表 assetSummary selectItemList null service { "service": "financePeriod", "serviceFunction": "assetSummary" } {} 666 insert

[财务凭证]资产核对总账

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务凭证]资产核对总账 assetCheck showInMenu null 25 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅资产核对总账-查询列表 assetCheck selectItemList null service { "service": "financePeriod", "serviceFunction": "assetCheck" } {} 667 insert
✅凭证明细列表 assetCheck selectVoucherEntryList null sql { "table": "view01_voucher_entry", "operation": "select" } 813 insert

[库存仓库]仓库管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[库存仓库]仓库管理 warehouseManagement showInMenu null 07 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅仓库管理-查询列表 warehouseManagement selectItemList null sql { "table": "warehouse_stock", "operation": "select" } {} 797 insert
✅仓库管理-添加 warehouseManagement insertItem { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } sql { "table": "warehouse_stock", "operation": "jhInsert" } {} 798 insert
✅仓库管理-更新 warehouseManagement updateItem null sql { "table": "warehouse_stock", "operation": "jhUpdate" } {} 799 insert
✅仓库管理-删除 warehouseManagement deleteItem null sql { "table": "warehouse_stock", "operation": "jhDelete" } {} 800 insert

[财务凭证]资产类别管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务凭证]资产类别管理 assetTypeManagement showInMenu null 25 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅资产类别管理-查询列表 assetTypeManagement selectItemList null sql { "table": "finance_asset_type", "operation": "select" } {} 661 insert
✅资产类别管理-添加信息 assetTypeManagement insertItem { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } sql { "table": "finance_asset_type", "operation": "insert" } {} 662 insert
✅资产类别管理-更新信息 assetTypeManagement updateItem null sql { "table": "finance_asset_type", "operation": "jhUpdate" } {} 663 insert
✅资产类别管理-删除信息 assetTypeManagement deleteItem null sql { "table": "finance_asset_type", "operation": "jhDelete" } {} 664 insert

[财务凭证]资产报废

  • 页面信息
pageName pageId pageType pageFile sort pageHook
[财务凭证]资产报废 assetScrapped showInMenu null 26 {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData appDataSchema id operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 assetScrapped selectItemList null sql { "table": "view01_warehouse_asset_finance", "operation": "select" } {} 807 insert
✅添加 assetScrapped insertItem null sql { "table": "finance_asset", "operation": "insert" } {} 808 insert
✅更新 assetScrapped generateScrappedVoucher null service { "service": "voucher", "serviceFunction": "generateScrappedVoucher" } 809 insert
✅会计期间列表 assetScrapped selectFinancePeriodList null sql {"table": "view01_period_voucher", "operation": "select"} {} 810 insert
✅资产列表 assetScrapped selectAssetList null sql { "table": "view01_finance_asset_last", "operation": "select" } {} 811 insert
✅凭证列表 assetScrapped selectVoucherList null sql { "table": "voucher", "operation": "select" } 812 insert
✅凭证明细列表 assetScrapped selectVoucherEntryList null sql { "table": "view01_voucher_entry", "operation": "select" } 822 insert

通知/待办

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

_page语句

  1. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', NULL, '帮助', 'dynamicInMenu', NULL, '67', 'insert', NULL, NULL, NULL);
  2. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', NULL, '登陆', '', NULL, '', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'supplierManagement', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"},{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}]}', '[采购]供货商列表', 'showInMenu', NULL, '03', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'customerManagement', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]客户列表', 'showInMenu', NULL, '04', 'insert', NULL, NULL, NULL);
  5. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'purchaseOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[采购]采购订单', 'showInMenu', NULL, '05', 'insert', NULL, NULL, NULL);
  6. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'saleOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]销售订单', 'showInMenu', NULL, '06', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'warehouseInventoryManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]库存管理', 'showInMenu', NULL, '08', 'insert', NULL, NULL, NULL);
  8. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'warehouseInventoryRecordOfProduct', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]出入库记录', 'showInMenu', NULL, '12', 'insert', NULL, NULL, NULL);
  9. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'warehouseInventoryRecordOfOrder', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]出入库单【打印】', 'showInMenu', NULL, '13', 'insert', NULL, NULL, NULL);
  10. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'warehouseAssetManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]资产管理', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
  11. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'warehouseAssetRecord', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]资产记录', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
  12. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'warehouseTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]申请单', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
  13. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (68, 'assetTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]申请单', 'showInMenu', NULL, '12', 'insert', NULL, NULL, NULL);
  14. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'paymentOfReceipt', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]收款管理', 'showInMenu', NULL, '21', 'insert', NULL, NULL, NULL);
  15. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'paymentOfPay', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]付款管理', 'showInMenu', NULL, '20', 'insert', NULL, NULL, NULL);
  16. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'assetFinanceManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产价值管理', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
  17. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'paymentTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]申请单', 'showInMenu', NULL, '24', 'insert', NULL, NULL, NULL);
  18. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (75, 'voucherGenerate', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]凭证生成', 'showInMenu', NULL, '27', 'insert', NULL, NULL, NULL);
  19. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (80, 'salesReturnOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]销售退货订单', 'showInMenu', NULL, '07', 'insert', NULL, NULL, NULL);
  20. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (81, 'purchaseReturnOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[采购]采购退货订单', 'showInMenu', NULL, '06', 'insert', NULL, NULL, NULL);
  21. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (92, 'printPurchaseReturnOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendPurchaseReturnInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '采购退货单打印', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
  22. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (93, 'printSaleOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendSaleOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印销售订单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
  23. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (94, 'printSaleReturnOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendSaleReturnOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印销售退货单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
  24. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (95, 'printTicketWarehouseIn', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendTicketWarehouseInInvoiceInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印采购入库单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
  25. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (97, 'printWarehouseInventoryIn', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryInInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印入库单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
  26. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (98, 'printWarehouseInventoryOut', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryOutInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印入库单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
  27. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (99, 'userManagement', NULL, NULL, '用户管理', 'showInAvatarMenu', NULL, '6', 'insert', NULL, NULL, NULL);
  28. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (111, 'assetRecord', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产折旧明细表', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
  29. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (112, 'assetSummary', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产汇总', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
  30. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (113, 'assetCheck', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产核对总账', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
  31. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (114, 'warehouseManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]仓库管理', 'showInMenu', NULL, '07', 'insert', NULL, NULL, NULL);
  32. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (115, 'assetTypeManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产类别管理', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
  33. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (116, 'assetScrapped', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产报废', 'showInMenu', NULL, '26', 'insert', NULL, NULL, NULL);
  34. INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (158, 'https://demo.jianghujs.org/task/page/noticeManagement', NULL, NULL, '通知/待办', 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, 'insert', NULL, NULL, NULL);