接口

12076

接口总览

_resource结构

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

_resource 内容

id desc pageId actionId resourceType resourceHook resourceData
1 ✅登出 allPage logout service null { "service": "user", "serviceFunction": "logout" }
2 ✅获取用户信息 allPage userInfo service null { "service": "user", "serviceFunction": "userInfo" }
3 ✅登陆 login passwordLogin service null { "service": "user", "serviceFunction": "passwordLogin" }
20 ✅资产价值管理-查询资产信息 assetFinanceManagement selectFinanceAsset sql null { "table": "finance_asset", "operation": "select" }
21 ✅资产价值管理-添加 assetFinanceManagement insertItem sql null { "table": "finance_asset", "operation": "jhInsert" }
22 ✅资产价值管理-更新 assetFinanceManagement updateItem sql null { "table": "finance_asset", "operation": "jhUpdate" }
23 ✅资产价值管理-删除 assetFinanceManagement deleteItem sql null { "table": "finance_asset", "operation": "jhDelete" }
24 ✅资产价值管理-查询资产类别 assetFinanceManagement selectAssetType sql null { "table": "finance_asset_type", "operation": "select" }
25 ✅资产价值管理-查询资产折旧明细 assetFinanceManagement selectFinanceAssetRecord sql null { "table": "finance_asset_record", "operation": "select" }
26 ✅资产价值管理-初始化折旧数据 assetFinanceManagement initDepreciationData service null { "service": "voucher", "serviceFunction": "initDepreciationData" }
27 ✅资产价值管理-查询资产库存 assetFinanceManagement selectWarehouseAsset sql null { "table": "view01_warehouse_asset_not_in_finance_asset", "operation": "select" }
28 ✅资产价值管理-查询会计期间 assetFinanceManagement selectFinancePeriod sql null { "table": "view01_period_voucher", "operation": "select" }
29 ✅资产价值管理-查询会计科目 assetFinanceManagement selectFinanceSubject sql null { "table": "subject", "operation": "select" }
40 ✅createSaleOrder-查询客户列表 customerManagement createSaleOrder-selectCustomerList sql null { "table": "customer", "operation": "select" }
41 ✅createSaleOrder-查询库存列表 customerManagement createSaleOrder-selectProductListByInventory sql null { "table": "view01_warehouse_inventory", "operation": "select" }
42 ✅createSaleOrder-添加销售订单 customerManagement createSaleOrder-insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } { "table": "sale_order", "operation": "insert" }
43 ✅查询订单信息 customerManagement createSaleOrder-selectOrder sql null { "table": "sale_order", "operation": "select" }
44 ✅销售出库 customerManagement createSaleOrder-inventoryOut service null { "service": "inventory", "serviceFunction": "inventoryOut" }
45 ✅查销售订单 customerManagement selectSaleOrderList sql null { "table": "sale_order", "operation": "select" }
46 ✅新增销售退货订单 customerManagement insertSalesReturnOrder sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } { "table": "sale_return_order", "operation": "jhInsert" }
47 ✅customerManagement查询-查询列表 customerManagement selectItemList sql null { "table": "customer", "operation": "select" }
48 ✅customerManagement查询-添加成员 customerManagement insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } { "table": "customer", "operation": "insert" }
49 ✅customerManagement查询-更新成员 customerManagement updateItem sql null { "table": "customer", "operation": "jhUpdate" }
50 ✅customerManagement查询-删除信息 customerManagement deleteItem sql null { "table": "customer", "operation": "jhDelete" }
90 ✅查询列表 paymentOfPay selectItemList sql null { "table": "payment", "operation": "select" }
91 ✅添加 paymentOfPay insertItem sql null { "table": "payment", "operation": "insert" }
92 ✅更新 paymentOfPay updateItem sql null { "table": "payment", "operation": "jhUpdate" }
93 ✅删除 paymentOfPay deleteItem sql null { "table": "payment", "operation": "jhDelete" }
94 ✅查询订单列表 paymentOfPay selectPaymentOrderList service null { "service": "payment", "serviceFunction": "selectPaymentOrderList" }
110 ✅查询列表 paymentOfReceipt selectItemList sql null { "table": "payment", "operation": "select" }
111 ✅添加 paymentOfReceipt insertItem sql null { "table": "payment", "operation": "insert" }
112 ✅更新 paymentOfReceipt updateItem sql null { "table": "payment", "operation": "jhUpdate" }
113 ✅删除 paymentOfReceipt deleteItem sql null { "table": "payment", "operation": "jhDelete" }
114 ✅查询订单列表 paymentOfReceipt selectPaymentOrderList service null { "service": "payment", "serviceFunction": "selectPaymentOrderList" }
123 ✅查询客户信息 saleOrderManagement inventoryOutBySaleOrder-selectCustomer sql null { "table": "customer", "operation": "select" }
130 ✅更新订单备注 purchaseOrderManagement viewPurchaseOrder-updateOrderRemark sql null { "table": "purchase_order", "operation": "jhUpdate" }
131 ✅查询列表 purchaseOrderManagement selectItemList sql { "after": [ { "service": "purchase", "serviceFunction": "appendTicketList" } ] } { "table": "view01_purchase_order", "operation": "select" }
132 ✅添加 purchaseOrderManagement insertItem sql null { "table": "purchase_order", "operation": "insert" }
133 ✅更新 purchaseOrderManagement updateItem sql null { "table": "purchase_order", "operation": "jhUpdate" }
134 ✅删除 purchaseOrderManagement deleteItem service null { "service": "purchase", "serviceFunction": "deleteOrder" }
135 ✅查询订单信息 purchaseOrderManagement viewPurchaseOrder-selectOrder sql null { "table": "purchase_order", "operation": "select" }
136 ✅更新订单状态 purchaseOrderManagement viewPurchaseOrder-updateOrderStatus sql null { "table": "purchase_order", "operation": "jhUpdate" }
137 ✅查询供货商列表 purchaseOrderManagement selectSupplierList sql null { "table": "supplier", "operation": "select" }
138 ✅查询供货商信息 purchaseOrderManagement viewPurchaseOrder-selectSupplier sql null { "table": "supplier", "operation": "select" }
139 ✅查询订单信息 purchaseOrderManagement inventoryInByPurchaseOrder-selectOrder sql null { "table": "purchase_order", "operation": "select" }
140 ✅入库 purchaseOrderManagement inventoryInByPurchaseOrder-inventoryIn service null { "service": "inventory", "serviceFunction": "inventoryIn" }
141 ✅查询供货商信息 purchaseOrderManagement inventoryInByPurchaseOrder-selectSupplier sql null { "table": "supplier", "operation": "select" }
142 ✅查询入库信息 purchaseOrderManagement viewInventoryInByPurchaseOrder-selectInventoryInList sql null { "table": "view01_warehouse_inventory", "operation": "select" }
143 ✅查询订单信息 purchaseOrderManagement viewInventoryInByPurchaseOrder-selectOrder sql null { "table": "purchase_order", "operation": "select" }
144 ✅查询供货商信息 purchaseOrderManagement viewInventoryInByPurchaseOrder-selectSupplier sql null { "table": "supplier", "operation": "select" }
160 ✅查询退货列表 purchaseReturnOrderManagement selectItemList sql { "after": [ { "service": "purchase", "serviceFunction": "appendTicketListWhenReturn" } ] } { "table": "view01_purchase_return_order", "operation": "select" }
161 ✅查询可退货采购列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectPurchaseList sql { "table": "view01_purchase_order", "operation": "select" }
162 ✅查询采购单的现有库存列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectProductListFromInventory sql { "after": [ { "service": "purchase", "serviceFunction": "calcInventoryOrderCount" } ] } { "table": "view01_warehouse_inventory", "operation": "select" }
163 ✅新增退货订单 purchaseReturnOrderManagement createPurchaseReturnOrder-insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } { "table": "purchase_return_order", "operation": "insert" }
164 ✅查询退货列表 purchaseReturnOrderManagement viewReturnOrder-selectOrder sql { "table": "view01_purchase_return_order", "operation": "select" }
165 ✅更新退货订单 purchaseReturnOrderManagement viewReturnOrder-updateOrderStatus sql null { "table": "purchase_return_order", "operation": "jhUpdate" }
180 ✅查询列表 saleOrderManagement selectItemList sql { "after": [ { "service": "sale", "serviceFunction": "appendTicketList" } ] } { "table": "view01_sale_order", "operation": "select" }
181 ✅添加 saleOrderManagement insertItem sql null { "table": "sale_order", "operation": "insert" }
182 ✅更新 saleOrderManagement updateItem sql null { "table": "sale_order", "operation": "jhUpdate" }
183 ✅删除 saleOrderManagement deleteItem service null { "service": "sale", "serviceFunction": "deleteOrder" }
184 ✅查询订单信息 saleOrderManagement viewSaleOrder-selectOrder sql null { "table": "sale_order", "operation": "select" }
185 ✅更新订单状态 saleOrderManagement viewSaleOrder-updateOrderStatus sql null { "table": "sale_order", "operation": "jhUpdate" }
186 ✅查询客户列表 saleOrderManagement selectCustomerList sql null { "table": "customer", "operation": "select" }
187 ✅查询客户信息 saleOrderManagement viewSaleOrder-selectCustomer sql null { "table": "customer", "operation": "select" }
188 ✅查询订单信息 saleOrderManagement inventoryOutBySaleOrder-selectOrder sql null { "table": "sale_order", "operation": "select" }
189 ✅销售出库 saleOrderManagement inventoryOutBySaleOrder-inventoryOut service null { "service": "inventory", "serviceFunction": "inventoryOut" }
191 ✅更新订单备注 saleOrderManagement viewSaleOrder-updateOrderRemark sql null { "table": "sale_order", "operation": "jhUpdate" }
210 ✅查询退货订单列表 salesReturnOrderManagement selectItemList sql { "after": [ { "service": "return", "serviceFunction": "appendTicketList" } ] } { "table": "view01_sale_return_order", "operation": "select" }
211 ✅查询客户列表 salesReturnOrderManagement selectCustomerList sql null { "table": "customer", "operation": "select" }
212 ✅更新退货订单 salesReturnOrderManagement updateReturnOrder sql { "table": "sale_return_order", "operation": "jhUpdate" }
230 ✅productList-更新 supplierManagement productList-updateItem sql null { "table": "supplier_product", "operation": "jhUpdate" }
231 ✅productList-删除 supplierManagement productList-deleteItem sql null { "table": "supplier_product", "operation": "jhDelete" }
232 ✅createPurchaseOrder-查询供货商列表 supplierManagement createPurchaseOrder-selectSupplierList sql null { "table": "supplier", "operation": "select" }
233 ✅createPurchaseOrder-查询产品列表 supplierManagement createPurchaseOrder-selectProductList sql null { "table": "supplier_product", "operation": "select" }
234 ✅createPurchaseOrder-添加采购订单 supplierManagement createPurchaseOrder-insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } { "table": "purchase_order", "operation": "insert" }
235 ✅supplierManagement查询-查询列表 supplierManagement selectItemList sql null { "table": "view01_supplier_info", "operation": "select" }
236 ✅supplierManagement查询-添加成员 supplierManagement insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } { "table": "supplier", "operation": "insert" }
237 ✅supplierManagement查询-更新成员 supplierManagement updateItem sql null { "table": "supplier", "operation": "jhUpdate" }
238 ✅supplierManagement查询-删除信息 supplierManagement deleteItem sql null { "table": "supplier", "operation": "jhDelete" }
239 ✅productList-查询列表 supplierManagement productList-selectItemList sql null { "table": "supplier_product", "operation": "select" }
240 ✅productList-添加 supplierManagement productList-insertItem sql null { "table": "supplier_product", "operation": "insert" }
260 ✅查询列表 ticketManagement selectItemList sql null { "table": "ticket", "operation": "select" }
261 ✅创建工单 ticketManagement createTicket service { "service": "ticket", "serviceFunction": "createTicket" }
262 ✅更新 ticketManagement updateItem sql null { "table": "ticket", "operation": "jhUpdate" }
263 ✅删除 ticketManagement deleteItem sql null { "table": "ticket", "operation": "jhDelete" }
264 ✅查询订单信息 ticketManagement selectItem sql null { "table": "ticket", "operation": "select" }
265 ✅查询供货商列表 ticketManagement selectSupplierList sql null { "table": "supplier", "operation": "select" }
266 ✅工单-采购付款申请单-处理 ticketManagement handlePurchasePaymentRequest service null { "service": "payment", "serviceFunction": "paymentIn" }
267 ✅查询采购单列表 ticketManagement selectPurchaseOrderList sql null { "table": "view01_purchase_order", "operation": "select" }
268 ✅查询销售单列表 ticketManagement selectSaleOrderList sql null { "table": "view01_sale_order", "operation": "select" }
269 ✅工单-采购入库申请单-处理 ticketManagement handlePurchaseWarehouseInRequest service null { "service": "warehouse", "serviceFunction": "inventoryIn" }
270 ✅查询客户列表 ticketManagement selectCustomerList sql null { "table": "customer", "operation": "select" }
271 ✅处理销售收款申请单 ticketManagement payment-handleSalePaymentInRequest-handleItem service null { "service": "payment", "serviceFunction": "paymentIn" }
272 ✅处理资产申请单 ticketManagement asset-handlePurchaseAssetInRequest-handleItem service null { "service": "asset", "serviceFunction": "handleTicket" }
273 ✅工单-销售出库申请单-处理 ticketManagement handleSaleWarehouseOutRequest service null { "service": "warehouse", "serviceFunction": "inventoryOut" }
274 ✅查询资产列表 ticketManagement selectAssetList sql null { "table": "warehouse_asset", "operation": "select" }
275 ✅查询资产列表 ticketManagement selectAssetListByUse sql null { "table": "view01_asset_list_for_apply", "operation": "select" }
276 ✅查询采购退货工单列表 ticketManagement selectPurchaseReturnOrderList sql null { "table": "view01_purchase_return_order", "operation": "select" }
277 ✅工单-采购退货出库申请单-处理 ticketManagement handlePurchaseReturnWarehouseOutRequest service null { "service": "warehouse", "serviceFunction": "inventoryOut" }
278 ✅处理采购收款工单 ticketManagement payment-handlePurchaseReturnPaymentInRequest-handleItem service null { "service": "payment", "serviceFunction": "paymentIn" }
279 ✅工单-销售退货入库申请单-处理 ticketManagement handleSaleReturnWarehouseInRequest service null { "service": "warehouse", "serviceFunction": "inventoryIn" }
300 ✅查询列表 voucherGenerate selectItemList sql null { "table": "view01_ticket_voucher", "operation": "select" }
301 ✅添加 voucherGenerate insertItem sql null { "table": "ticket", "operation": "insert" }
302 ✅更新 voucherGenerate updateItem sql null { "table": "ticket", "operation": "jhUpdate" }
303 ✅删除 voucherGenerate deleteItem sql null { "table": "ticket", "operation": "jhDelete" }
304 ✅查询下个凭证字号 voucherGenerate selectNextVoucherNumber sql null { "table": "view01_next_voucher_number", "operation": "select" }
305 ✅生成单据凭证 voucherGenerate createTicketVoucher service null { "service": "voucher", "serviceFunction": "createTicketVoucher" }
306 ✅删除凭证 voucherGenerate deleteVoucher sql null { "table": "voucher", "operation": "jhDelete" }
307 ✅查询凭证 voucherGenerate selectVoucher sql { "after": [ { "service": "voucher", "serviceFunction": "appendEntryList" } ] } { "table": "voucher", "operation": "select" }
320 ✅查询列表 warehouseAssetManagement selectItemList sql null { "table": "warehouse_asset", "operation": "select" }
321 ✅添加 warehouseAssetManagement insertItem sql null { "table": "warehouse_asset", "operation": "insert" }
322 ✅更新 warehouseAssetManagement updateItem sql null { "table": "warehouse_asset", "operation": "jhUpdate" }
323 ✅删除 warehouseAssetManagement deleteItem sql null { "table": "warehouse_asset", "operation": "jhDelete" }
340 ✅查询列表 warehouseAssetRecord selectItemList sql null { "table": "warehouse_asset_record", "operation": "select" }
341 ✅添加 warehouseAssetRecord insertItem sql null { "table": "warehouse_asset_record", "operation": "insert" }
342 ✅更新 warehouseAssetRecord updateItem sql null { "table": "warehouse_asset_record", "operation": "jhUpdate" }
343 ✅删除 warehouseAssetRecord deleteItem sql null { "table": "warehouse_asset_record", "operation": "jhDelete" }
360 ✅查询列表 warehouseInventoryManagement selectItemList sql null { "table": "view01_warehouse_inventory", "operation": "select" }
361 ✅添加 warehouseInventoryManagement insertItem sql null { "table": "warehouse_inventory", "operation": "insert" }
362 ✅更新 warehouseInventoryManagement updateItem sql null { "table": "warehouse_inventory", "operation": "jhUpdate" }
363 ✅删除 warehouseInventoryManagement deleteItem sql null { "table": "warehouse_inventory", "operation": "jhDelete" }
380 ✅查询列表 warehouseInventoryRecord selectItemList sql null { "table": "warehouse_inventory_record", "operation": "select" }
381 ✅添加 warehouseInventoryRecord insertItem sql null { "table": "warehouse_inventory_record", "operation": "insert" }
382 ✅更新 warehouseInventoryRecord updateItem sql null { "table": "warehouse_inventory_record", "operation": "jhUpdate" }
383 ✅删除 warehouseInventoryRecord deleteItem sql null { "table": "warehouse_inventory_record", "operation": "jhDelete" }
400 ✅查询客户列表 warehouseTicketRequest selectCustomerList sql null { "table": "customer", "operation": "select" }
401 ✅查询供货商列表 warehouseTicketRequest selectSupplierList sql null { "table": "supplier", "operation": "select" }
402 ✅查询申请单列表 warehouseTicketRequest selectTicketList sql null { "table": "ticket", "operation": "select" }
420 ✅查询客户列表 assetTicketRequest selectCustomerList sql null { "table": "customer", "operation": "select" }
421 ✅查询供货商列表 assetTicketRequest selectSupplierList sql null { "table": "supplier", "operation": "select" }
422 ✅查询申请单列表 assetTicketRequest selectTicketList sql null { "table": "ticket", "operation": "select" }
440 ✅查询客户列表 paymentTicketRequest selectCustomerList sql null { "table": "customer", "operation": "select" }
441 ✅查询供货商列表 paymentTicketRequest selectSupplierList sql null { "table": "supplier", "operation": "select" }
442 ✅查询申请单列表 paymentTicketRequest selectTicketList sql null { "table": "ticket", "operation": "select" }
652 ✅获取库存-待处理出入库数据 ticketManagement warehouse-getTicketOrderHandleData sql null { "table": "view01_ticket_order", "operation": "select" }
653 ✅获取会计期间列表 financePeriodManagement selectItemList sql null { "table": "view01_period_voucher", "operation": "select" }
654 ✅添加会计期间 financePeriodManagement insertItem sql { "before": [ { "service": "financePeriod", "serviceFunction": "checkRepeat" } ] } { "table": "finance_period", "operation": "insert" }
657 ✅生成折旧凭证 voucherGenerate generateDepreciationVoucher service null { "service": "voucher", "serviceFunction": "generateDepreciationVoucher" }
660 ✅查询常量 allPage getConstantList sql null { "table": "_constant", "operation": "select" }
661 ✅资产类别管理-查询列表 assetTypeManagement selectItemList sql null { "table": "finance_asset_type", "operation": "select" }
662 ✅资产类别管理-添加信息 assetTypeManagement insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } { "table": "finance_asset_type", "operation": "insert" }
663 ✅资产类别管理-更新信息 assetTypeManagement updateItem sql null { "table": "finance_asset_type", "operation": "jhUpdate" }
664 ✅资产类别管理-删除信息 assetTypeManagement deleteItem sql null { "table": "finance_asset_type", "operation": "jhDelete" }
665 ✅资产折旧明细-查询列表 assetRecord selectItemList sql null { "table": "finance_asset_record", "operation": "select" }
666 ✅资产汇总-查询列表 assetSummary selectItemList service null { "service": "financePeriod", "serviceFunction": "assetSummary" }
667 ✅资产核对总账-查询列表 assetCheck selectItemList service null { "service": "financePeriod", "serviceFunction": "assetCheck" }
671 ✅用户管理-查询信息 userManagement selectItemList sql null { "table": "_user", "operation": "select" }
672 ✅用户管理-查询信息 userManagement insertItem service null { "service": "userManagement", "serviceFunction": "addUser" }
673 ✅用户管理-修改密码 userManagement resetUserPassword service null { "service": "userManagement", "serviceFunction": "resetUserPassword" }
674 ✅用户管理-更新用户 userManagement updateItem sql null { "table": "_user", "operation": "jhUpdate" }
795 ticketManagement getUserList sql null { "table": "_view01_user", "operation": "select" }
796 ✅创建工单 ticketManagement createAssetTicket service null { "service": "ticket", "serviceFunction": "createAssetTicket" }
797 ✅仓库管理-查询列表 warehouseManagement selectItemList sql null { "table": "warehouse_stock", "operation": "select" }
798 ✅仓库管理-添加 warehouseManagement insertItem sql { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } { "table": "warehouse_stock", "operation": "jhInsert" }
799 ✅仓库管理-更新 warehouseManagement updateItem sql null { "table": "warehouse_stock", "operation": "jhUpdate" }
800 ✅仓库管理-删除 warehouseManagement deleteItem sql null { "table": "warehouse_stock", "operation": "jhDelete" }
801 ✅工单-查询仓库列表 ticketManagement selectWarehouseList sql null { "table": "warehouse_stock", "operation": "select" }
806 ✅采购资产退货 ticketManagement asset-handlePurchaseReturnOutRequest-handleItem service null { "service": "asset", "serviceFunction": "inventoryOut" }
807 ✅查询列表 assetScrapped selectItemList sql null { "table": "view01_warehouse_asset_finance", "operation": "select" }
808 ✅添加 assetScrapped insertItem sql null { "table": "finance_asset", "operation": "insert" }
809 ✅更新 assetScrapped generateScrappedVoucher service null { "service": "voucher", "serviceFunction": "generateScrappedVoucher" }
810 ✅会计期间列表 assetScrapped selectFinancePeriodList sql null { "table": "view01_period_voucher", "operation": "select" }
811 ✅资产列表 assetScrapped selectAssetList sql null { "table": "view01_finance_asset_last", "operation": "select" }
812 ✅凭证列表 assetScrapped selectVoucherList sql null { "table": "voucher", "operation": "select" }
813 ✅凭证明细列表 assetCheck selectVoucherEntryList sql null { "table": "view01_voucher_entry", "operation": "select" }
814 ✅查询下个凭证字号 assetFinanceManagement selectNextVoucherNumber sql null { "table": "view01_next_voucher_number", "operation": "select" }
815 ✅查询可退货采购列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectPurchaseAssetList sql null { "table": "warehouse_asset", "operation": "select" }
816 ✅查询资产采购单的现有库存列表 purchaseReturnOrderManagement createPurchaseReturnOrder-selectProductListFromAsset sql { "after": [ { "service": "purchase", "serviceFunction": "calcAssetOrderCount" } ] } { "table": "warehouse_asset", "operation": "select" }
817 ✅查询列表 warehouseInventoryRecord selectAssetItemList sql null { "table": "warehouse_asset_record", "operation": "select" }
818 ✅createPurchaseOrder-添加采购产品价格记录 supplierManagement createPurchaseOrder-insertPurchasePriceRecord sql null { "table": "purchase_price_history", "operation": "jhInsert" }
819 ✅createSaleOrder-添加销售产品价格记录 customerManagement createSaleOrder-insertSalesProductPriceRecord sql null { "table": "sale_price_history", "operation": "jhInsert" }
820 ✅createPurchaseOrder-查询采购产品价格记录 supplierManagement createPurchaseOrder-selectPriceList sql null { "table": "purchase_price_history", "operation": "select" }
821 ✅createSaleOrder-查询采购产品价格记录 customerManagement createSaleOrder-selectPriceList sql null { "table": "sale_price_history", "operation": "select" }
822 ✅凭证明细列表 assetScrapped selectVoucherEntryList sql null { "table": "view01_voucher_entry", "operation": "select" }

_resource语句

  1. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
  2. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (2, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
  3. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
  4. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (20, NULL, 'assetFinanceManagement', 'selectFinanceAsset', '✅资产价值管理-查询资产信息', 'sql', '{}', '{ "table": "finance_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  5. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (21, NULL, 'assetFinanceManagement', 'insertItem', '✅资产价值管理-添加', 'sql', '{}', '{ "table": "finance_asset", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  6. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (22, NULL, 'assetFinanceManagement', 'updateItem', '✅资产价值管理-更新', 'sql', '{}', '{ "table": "finance_asset", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  7. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (23, NULL, 'assetFinanceManagement', 'deleteItem', '✅资产价值管理-删除', 'sql', '{}', '{ "table": "finance_asset", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  8. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (24, NULL, 'assetFinanceManagement', 'selectAssetType', '✅资产价值管理-查询资产类别', 'sql', '{}', '{ "table": "finance_asset_type", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  9. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (25, NULL, 'assetFinanceManagement', 'selectFinanceAssetRecord', '✅资产价值管理-查询资产折旧明细', 'sql', '{}', '{"table": "finance_asset_record", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  10. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (26, NULL, 'assetFinanceManagement', 'initDepreciationData', '✅资产价值管理-初始化折旧数据', 'service', NULL, '{ "service": "voucher", "serviceFunction": "initDepreciationData" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  11. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (27, NULL, 'assetFinanceManagement', 'selectWarehouseAsset', '✅资产价值管理-查询资产库存', 'sql', '{}', '{ "table": "view01_warehouse_asset_not_in_finance_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  12. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (28, NULL, 'assetFinanceManagement', 'selectFinancePeriod', '✅资产价值管理-查询会计期间', 'sql', '{}', '{"table": "view01_period_voucher", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  13. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (29, NULL, 'assetFinanceManagement', 'selectFinanceSubject', '✅资产价值管理-查询会计科目', 'sql', '{}', '{"table": "subject", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  14. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (40, NULL, 'customerManagement', 'createSaleOrder-selectCustomerList', '✅createSaleOrder-查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  15. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (41, NULL, 'customerManagement', 'createSaleOrder-selectProductListByInventory', '✅createSaleOrder-查询库存列表', 'sql', '{}', '{ "table": "view01_warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  16. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (42, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [{"service": "common", "serviceFunction": "generateBizIdOfAfterHook"}] }', 'customerManagement', 'createSaleOrder-insertItem', '✅createSaleOrder-添加销售订单', 'sql', '{}', '{ "table": "sale_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  17. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (43, NULL, 'customerManagement', 'createSaleOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  18. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (44, NULL, 'customerManagement', 'createSaleOrder-inventoryOut', '✅销售出库', 'service', '{}', '{ "service": "inventory", "serviceFunction": "inventoryOut" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  19. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, NULL, 'customerManagement', 'selectSaleOrderList', '✅查销售订单', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  20. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (46, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [{"service": "common", "serviceFunction": "generateBizIdOfAfterHook"}] }', 'customerManagement', 'insertSalesReturnOrder', '✅新增销售退货订单', 'sql', '{}', '{ "table": "sale_return_order", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  21. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (47, NULL, 'customerManagement', 'selectItemList', '✅customerManagement查询-查询列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  22. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (48, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [] }', 'customerManagement', 'insertItem', '✅customerManagement查询-添加成员', 'sql', '{}', '{ "table": "customer", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  23. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (49, NULL, 'customerManagement', 'updateItem', '✅customerManagement查询-更新成员', 'sql', '{}', '{ "table": "customer", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  24. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (50, NULL, 'customerManagement', 'deleteItem', '✅customerManagement查询-删除信息', 'sql', '{}', '{ "table": "customer", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  25. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (90, NULL, 'paymentOfPay', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "payment", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  26. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (91, NULL, 'paymentOfPay', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "payment", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  27. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (92, NULL, 'paymentOfPay', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "payment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  28. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (93, NULL, 'paymentOfPay', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "payment", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  29. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (94, NULL, 'paymentOfPay', 'selectPaymentOrderList', '✅查询订单列表', 'service', '{}', '{"service": "payment", "serviceFunction": "selectPaymentOrderList"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  30. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (110, NULL, 'paymentOfReceipt', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "payment", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  31. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (111, NULL, 'paymentOfReceipt', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "payment", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  32. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (112, NULL, 'paymentOfReceipt', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "payment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  33. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (113, NULL, 'paymentOfReceipt', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "payment", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  34. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (114, NULL, 'paymentOfReceipt', 'selectPaymentOrderList', '✅查询订单列表', 'service', '{}', '{"service": "payment", "serviceFunction": "selectPaymentOrderList"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  35. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (123, NULL, 'saleOrderManagement', 'inventoryOutBySaleOrder-selectCustomer', '✅查询客户信息', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  36. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (130, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-updateOrderRemark', '✅更新订单备注', 'sql', '{}', '{ "table": "purchase_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  37. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (131, '{"after":[{"service":"purchase","serviceFunction":"appendTicketList"}]}', 'purchaseOrderManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  38. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (132, NULL, 'purchaseOrderManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "purchase_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  39. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (133, NULL, 'purchaseOrderManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "purchase_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  40. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (134, NULL, 'purchaseOrderManagement', 'deleteItem', '✅删除', 'service', '{}', '{ "service": "purchase", "serviceFunction": "deleteOrder" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  41. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (135, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  42. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (136, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-updateOrderStatus', '✅更新订单状态', 'sql', '{}', '{ "table": "purchase_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  43. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (137, NULL, 'purchaseOrderManagement', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  44. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (138, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-selectSupplier', '✅查询供货商信息', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  45. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (139, NULL, 'purchaseOrderManagement', 'inventoryInByPurchaseOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  46. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (140, NULL, 'purchaseOrderManagement', 'inventoryInByPurchaseOrder-inventoryIn', '✅入库', 'service', '{}', '{ "service": "inventory", "serviceFunction": "inventoryIn" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  47. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (141, NULL, 'purchaseOrderManagement', 'inventoryInByPurchaseOrder-selectSupplier', '✅查询供货商信息', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  48. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (142, NULL, 'purchaseOrderManagement', 'viewInventoryInByPurchaseOrder-selectInventoryInList', '✅查询入库信息', 'sql', '{}', '{ "table": "view01_warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  49. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (143, NULL, 'purchaseOrderManagement', 'viewInventoryInByPurchaseOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  50. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (144, NULL, 'purchaseOrderManagement', 'viewInventoryInByPurchaseOrder-selectSupplier', '✅查询供货商信息', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  51. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (160, '{"after":[{"service":"purchase","serviceFunction":"appendTicketListWhenReturn"}]}', 'purchaseReturnOrderManagement', 'selectItemList', '✅查询退货列表', 'sql', '{}', '{ "table": "view01_purchase_return_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  52. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (161, '', 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-selectPurchaseList', '✅查询可退货采购列表', 'sql', '{}', '{ "table": "view01_purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  53. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (162, '{"after":[{"service":"purchase","serviceFunction":"calcInventoryOrderCount"}]}', 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-selectProductListFromInventory', '✅查询采购单的现有库存列表', 'sql', '{}', '{ "table": "view01_warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  54. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (163, '{ "before": [
  55. {"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}
  56. ], "after": [
  57. {"service": "common", "serviceFunction": "generateBizIdOfAfterHook"}
  58. ] }', 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-insertItem', '✅新增退货订单', 'sql', '{}', '{ "table": "purchase_return_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  59. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (164, '', 'purchaseReturnOrderManagement', 'viewReturnOrder-selectOrder', '✅查询退货列表', 'sql', '{}', '{ "table": "view01_purchase_return_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  60. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (165, NULL, 'purchaseReturnOrderManagement', 'viewReturnOrder-updateOrderStatus', '✅更新退货订单', 'sql', '{}', '{ "table": "purchase_return_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  61. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (180, '{"after":[{"service":"sale","serviceFunction":"appendTicketList"}]}', 'saleOrderManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  62. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (181, NULL, 'saleOrderManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "sale_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  63. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (182, NULL, 'saleOrderManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "sale_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  64. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (183, NULL, 'saleOrderManagement', 'deleteItem', '✅删除', 'service', '{}', '{ "service": "sale", "serviceFunction": "deleteOrder" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  65. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (184, NULL, 'saleOrderManagement', 'viewSaleOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  66. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (185, NULL, 'saleOrderManagement', 'viewSaleOrder-updateOrderStatus', '✅更新订单状态', 'sql', '{}', '{ "table": "sale_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  67. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (186, NULL, 'saleOrderManagement', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  68. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (187, NULL, 'saleOrderManagement', 'viewSaleOrder-selectCustomer', '✅查询客户信息', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  69. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (188, NULL, 'saleOrderManagement', 'inventoryOutBySaleOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  70. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (189, NULL, 'saleOrderManagement', 'inventoryOutBySaleOrder-inventoryOut', '✅销售出库', 'service', '{}', '{ "service": "inventory", "serviceFunction": "inventoryOut" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  71. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (191, NULL, 'saleOrderManagement', 'viewSaleOrder-updateOrderRemark', '✅更新订单备注', 'sql', '{}', '{ "table": "sale_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  72. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (210, '{"after":[{"service":"return","serviceFunction":"appendTicketList"}]}', 'salesReturnOrderManagement', 'selectItemList', '✅查询退货订单列表', 'sql', '{}', '{ "table": "view01_sale_return_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  73. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (211, NULL, 'salesReturnOrderManagement', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  74. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (212, '', 'salesReturnOrderManagement', 'updateReturnOrder', '✅更新退货订单', 'sql', '{}', '{ "table": "sale_return_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  75. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (230, NULL, 'supplierManagement', 'productList-updateItem', '✅productList-更新', 'sql', '{}', '{ "table": "supplier_product", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  76. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, 'supplierManagement', 'productList-deleteItem', '✅productList-删除', 'sql', '{}', '{ "table": "supplier_product", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  77. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (232, NULL, 'supplierManagement', 'createPurchaseOrder-selectSupplierList', '✅createPurchaseOrder-查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  78. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (233, NULL, 'supplierManagement', 'createPurchaseOrder-selectProductList', '✅createPurchaseOrder-查询产品列表', 'sql', '{}', '{ "table": "supplier_product", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  79. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (234, '{ "before": [
  80. {"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}
  81. ], "after": [
  82. {"service": "common", "serviceFunction": "generateBizIdOfAfterHook"}
  83. ] }', 'supplierManagement', 'createPurchaseOrder-insertItem', '✅createPurchaseOrder-添加采购订单', 'sql', '{}', '{ "table": "purchase_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  84. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (235, NULL, 'supplierManagement', 'selectItemList', '✅supplierManagement查询-查询列表', 'sql', '{}', '{ "table": "view01_supplier_info", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  85. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (236, '{ "before": [
  86. {"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}
  87. ], "after": [
  88. ] }', 'supplierManagement', 'insertItem', '✅supplierManagement查询-添加成员', 'sql', '{}', '{ "table": "supplier", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  89. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (237, NULL, 'supplierManagement', 'updateItem', '✅supplierManagement查询-更新成员', 'sql', '{}', '{ "table": "supplier", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  90. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (238, NULL, 'supplierManagement', 'deleteItem', '✅supplierManagement查询-删除信息', 'sql', '{}', '{ "table": "supplier", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  91. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (239, NULL, 'supplierManagement', 'productList-selectItemList', '✅productList-查询列表', 'sql', '{}', '{ "table": "supplier_product", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  92. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (240, NULL, 'supplierManagement', 'productList-insertItem', '✅productList-添加', 'sql', '{}', '{ "table": "supplier_product", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  93. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (260, NULL, 'ticketManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  94. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (261, '', 'ticketManagement', 'createTicket', '✅创建工单', 'service', '{}', '{"service": "ticket", "serviceFunction": "createTicket"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  95. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (262, NULL, 'ticketManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "ticket", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  96. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (263, NULL, 'ticketManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "ticket", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  97. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (264, NULL, 'ticketManagement', 'selectItem', '✅查询订单信息', 'sql', '{}', '{ "table": "ticket", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  98. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (265, NULL, 'ticketManagement', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  99. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (266, NULL, 'ticketManagement', 'handlePurchasePaymentRequest', '✅工单-采购付款申请单-处理', 'service', '{}', '{"service": "payment", "serviceFunction": "paymentIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  100. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (267, NULL, 'ticketManagement', 'selectPurchaseOrderList', '✅查询采购单列表', 'sql', '{}', '{ "table": "view01_purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  101. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (268, NULL, 'ticketManagement', 'selectSaleOrderList', '✅查询销售单列表', 'sql', '{}', '{ "table": "view01_sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  102. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (269, NULL, 'ticketManagement', 'handlePurchaseWarehouseInRequest', '✅工单-采购入库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  103. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (270, NULL, 'ticketManagement', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  104. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (271, NULL, 'ticketManagement', 'payment-handleSalePaymentInRequest-handleItem', '✅处理销售收款申请单', 'service', '{}', '{"service": "payment", "serviceFunction": "paymentIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  105. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (272, NULL, 'ticketManagement', 'asset-handlePurchaseAssetInRequest-handleItem', '✅处理资产申请单', 'service', '{}', '{"service": "asset", "serviceFunction": "handleTicket"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  106. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (273, NULL, 'ticketManagement', 'handleSaleWarehouseOutRequest', '✅工单-销售出库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryOut"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  107. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (274, NULL, 'ticketManagement', 'selectAssetList', '✅查询资产列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  108. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (275, NULL, 'ticketManagement', 'selectAssetListByUse', '✅查询资产列表', 'sql', '{}', '{ "table": "view01_asset_list_for_apply", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  109. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (276, NULL, 'ticketManagement', 'selectPurchaseReturnOrderList', '✅查询采购退货工单列表', 'sql', '{}', '{ "table": "view01_purchase_return_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  110. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (277, NULL, 'ticketManagement', 'handlePurchaseReturnWarehouseOutRequest', '✅工单-采购退货出库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryOut"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  111. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (278, NULL, 'ticketManagement', 'payment-handlePurchaseReturnPaymentInRequest-handleItem', '✅处理采购收款工单', 'service', '{}', '{"service": "payment", "serviceFunction": "paymentIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  112. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (279, NULL, 'ticketManagement', 'handleSaleReturnWarehouseInRequest', '✅工单-销售退货入库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  113. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (300, NULL, 'voucherGenerate', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_ticket_voucher", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  114. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (301, NULL, 'voucherGenerate', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "ticket", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  115. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (302, NULL, 'voucherGenerate', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "ticket", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  116. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (303, NULL, 'voucherGenerate', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "ticket", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  117. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (304, NULL, 'voucherGenerate', 'selectNextVoucherNumber', '✅查询下个凭证字号', 'sql', '{}', '{ "table": "view01_next_voucher_number", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  118. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (305, NULL, 'voucherGenerate', 'createTicketVoucher', '✅生成单据凭证', 'service', '{}', '{ "service": "voucher", "serviceFunction": "createTicketVoucher" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  119. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (306, NULL, 'voucherGenerate', 'deleteVoucher', '✅删除凭证', 'sql', '{}', '{ "table": "voucher", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  120. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (307, '{"after":[{"service":"voucher","serviceFunction":"appendEntryList"}]}', 'voucherGenerate', 'selectVoucher', '✅查询凭证', 'sql', '{}', '{ "table": "voucher", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  121. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (320, NULL, 'warehouseAssetManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  122. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (321, NULL, 'warehouseAssetManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  123. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (322, NULL, 'warehouseAssetManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  124. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (323, NULL, 'warehouseAssetManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  125. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (340, NULL, 'warehouseAssetRecord', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  126. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (341, NULL, 'warehouseAssetRecord', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  127. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (342, NULL, 'warehouseAssetRecord', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  128. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (343, NULL, 'warehouseAssetRecord', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  129. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (360, NULL, 'warehouseInventoryManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  130. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (361, NULL, 'warehouseInventoryManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  131. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (362, NULL, 'warehouseInventoryManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  132. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (363, NULL, 'warehouseInventoryManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  133. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, 'warehouseInventoryRecord', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  134. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, 'warehouseInventoryRecord', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  135. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, 'warehouseInventoryRecord', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  136. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, 'warehouseInventoryRecord', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  137. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (400, NULL, 'warehouseTicketRequest', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  138. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (401, NULL, 'warehouseTicketRequest', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  139. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (402, NULL, 'warehouseTicketRequest', 'selectTicketList', '✅查询申请单列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  140. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (420, NULL, 'assetTicketRequest', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  141. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (421, NULL, 'assetTicketRequest', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  142. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (422, NULL, 'assetTicketRequest', 'selectTicketList', '✅查询申请单列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  143. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (440, NULL, 'paymentTicketRequest', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  144. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (441, NULL, 'paymentTicketRequest', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  145. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (442, NULL, 'paymentTicketRequest', 'selectTicketList', '✅查询申请单列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  146. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (652, NULL, 'ticketManagement', 'warehouse-getTicketOrderHandleData', '✅获取库存-待处理出入库数据', 'sql', '{}', '{"table": "view01_ticket_order", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  147. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (653, NULL, 'financePeriodManagement', 'selectItemList', '✅获取会计期间列表', 'sql', '{}', '{"table": "view01_period_voucher", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  148. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (654, '{"before":[{"service":"financePeriod","serviceFunction":"checkRepeat"}]}', 'financePeriodManagement', 'insertItem', '✅添加会计期间', 'sql', '{}', '{"table": "finance_period", "operation": "insert"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  149. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (657, NULL, 'voucherGenerate', 'generateDepreciationVoucher', '✅生成折旧凭证', 'service', '{}', '{ "service": "voucher", "serviceFunction": "generateDepreciationVoucher" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  150. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (660, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  151. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (661, NULL, 'assetTypeManagement', 'selectItemList', '✅资产类别管理-查询列表', 'sql', '{}', '{ "table": "finance_asset_type", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  152. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (662, '{ "before": [
  153. {"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}
  154. ], "after": [
  155. ] }', 'assetTypeManagement', 'insertItem', '✅资产类别管理-添加信息', 'sql', '{}', '{ "table": "finance_asset_type", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  156. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (663, NULL, 'assetTypeManagement', 'updateItem', '✅资产类别管理-更新信息', 'sql', '{}', '{ "table": "finance_asset_type", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  157. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (664, NULL, 'assetTypeManagement', 'deleteItem', '✅资产类别管理-删除信息', 'sql', '{}', '{ "table": "finance_asset_type", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  158. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (665, NULL, 'assetRecord', 'selectItemList', '✅资产折旧明细-查询列表', 'sql', '{}', '{ "table": "finance_asset_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  159. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (666, NULL, 'assetSummary', 'selectItemList', '✅资产汇总-查询列表', 'service', '{}', '{ "service": "financePeriod", "serviceFunction": "assetSummary" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  160. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (667, NULL, 'assetCheck', 'selectItemList', '✅资产核对总账-查询列表', 'service', '{}', '{ "service": "financePeriod", "serviceFunction": "assetCheck" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  161. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (671, 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');
  162. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (672, 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');
  163. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (673, 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');
  164. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (674, 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');
  165. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (795, NULL, 'ticketManagement', 'getUserList', NULL, 'sql', NULL, '{"table": "_view01_user", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  166. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (796, NULL, 'ticketManagement', 'createAssetTicket', '✅创建工单', 'service', '{}', '{"service": "ticket", "serviceFunction": "createAssetTicket"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  167. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (797, NULL, 'warehouseManagement', 'selectItemList', '✅仓库管理-查询列表', 'sql', '{}', '{ "table": "warehouse_stock", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  168. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (798, '{ "before": [
  169. {"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}
  170. ], "after": [
  171. ] }', 'warehouseManagement', 'insertItem', '✅仓库管理-添加', 'sql', '{}', '{ "table": "warehouse_stock", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  172. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (799, NULL, 'warehouseManagement', 'updateItem', '✅仓库管理-更新', 'sql', '{}', '{ "table": "warehouse_stock", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  173. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (800, NULL, 'warehouseManagement', 'deleteItem', '✅仓库管理-删除', 'sql', '{}', '{ "table": "warehouse_stock", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  174. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (801, NULL, 'ticketManagement', 'selectWarehouseList', '✅工单-查询仓库列表', 'sql', NULL, '{ "table": "warehouse_stock", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  175. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (806, NULL, 'ticketManagement', 'asset-handlePurchaseReturnOutRequest-handleItem', '✅采购资产退货', 'service', NULL, '{ "service": "asset", "serviceFunction": "inventoryOut" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  176. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (807, NULL, 'assetScrapped', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_warehouse_asset_finance", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  177. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (808, NULL, 'assetScrapped', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "finance_asset", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  178. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (809, NULL, 'assetScrapped', 'generateScrappedVoucher', '✅更新', 'service', NULL, '{ "service": "voucher", "serviceFunction": "generateScrappedVoucher" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  179. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (810, NULL, 'assetScrapped', 'selectFinancePeriodList', '✅会计期间列表', 'sql', '{}', '{"table": "view01_period_voucher", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  180. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (811, NULL, 'assetScrapped', 'selectAssetList', '✅资产列表', 'sql', '{}', '{ "table": "view01_finance_asset_last", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  181. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (812, NULL, 'assetScrapped', 'selectVoucherList', '✅凭证列表', 'sql', NULL, '{ "table": "voucher", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  182. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (813, NULL, 'assetCheck', 'selectVoucherEntryList', '✅凭证明细列表', 'sql', NULL, '{ "table": "view01_voucher_entry", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  183. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (814, NULL, 'assetFinanceManagement', 'selectNextVoucherNumber', '✅查询下个凭证字号', 'sql', '{}', '{ "table": "view01_next_voucher_number", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  184. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (815, NULL, 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-selectPurchaseAssetList', '✅查询可退货采购列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  185. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (816, '{"after":[{"service":"purchase","serviceFunction":"calcAssetOrderCount"}]}', 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-selectProductListFromAsset', '✅查询资产采购单的现有库存列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  186. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (817, NULL, 'warehouseInventoryRecord', 'selectAssetItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  187. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (818, NULL, 'supplierManagement', 'createPurchaseOrder-insertPurchasePriceRecord', '✅createPurchaseOrder-添加采购产品价格记录', 'sql', '{}', '{ "table": "purchase_price_history", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  188. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (819, NULL, 'customerManagement', 'createSaleOrder-insertSalesProductPriceRecord', '✅createSaleOrder-添加销售产品价格记录', 'sql', '{}', '{ "table": "sale_price_history", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  189. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (820, NULL, 'supplierManagement', 'createPurchaseOrder-selectPriceList', '✅createPurchaseOrder-查询采购产品价格记录', 'sql', '{}', '{ "table": "purchase_price_history", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  190. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (821, NULL, 'customerManagement', 'createSaleOrder-selectPriceList', '✅createSaleOrder-查询采购产品价格记录', 'sql', '{}', '{ "table": "sale_price_history", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  191. INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (822, NULL, 'assetScrapped', 'selectVoucherEntryList', '✅凭证明细列表', 'sql', NULL, '{ "table": "view01_voucher_entry", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);