接口
12129接口总览
_resource结构
CREATE TABLE `_resource` (`id` int(11) NOT NULL AUTO_INCREMENT,`resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',`pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',`actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',`desc` varchar(255) DEFAULT NULL COMMENT '描述',`resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',`appDataSchema` text COMMENT 'appData 参数校验',`resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',`requestDemo` text COMMENT '请求Demo',`responseDemo` text COMMENT '响应Demo',`operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',`operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',`operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',`operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 823 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
_resource 内容
| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
|---|---|---|---|---|---|---|
| 1 | ✅登出 | allPage | logout | service | {"service": "user", "serviceFunction": "logout"} | |
| 2 | ✅获取用户信息 | allPage | userInfo | service | {"service": "user", "serviceFunction": "userInfo"} | |
| 3 | ✅登陆 | login | passwordLogin | service | {"service": "user", "serviceFunction": "passwordLogin"} | |
| 20 | ✅资产价值管理-查询资产信息 | assetFinanceManagement | selectFinanceAsset | sql | { "table": "finance_asset", "operation": "select" } | |
| 21 | ✅资产价值管理-添加 | assetFinanceManagement | insertItem | sql | { "table": "finance_asset", "operation": "jhInsert" } | |
| 22 | ✅资产价值管理-更新 | assetFinanceManagement | updateItem | sql | { "table": "finance_asset", "operation": "jhUpdate" } | |
| 23 | ✅资产价值管理-删除 | assetFinanceManagement | deleteItem | sql | { "table": "finance_asset", "operation": "jhDelete" } | |
| 24 | ✅资产价值管理-查询资产类别 | assetFinanceManagement | selectAssetType | sql | { "table": "finance_asset_type", "operation": "select" } | |
| 25 | ✅资产价值管理-查询资产折旧明细 | assetFinanceManagement | selectFinanceAssetRecord | sql | {"table": "finance_asset_record", "operation": "select"} | |
| 26 | ✅资产价值管理-初始化折旧数据 | assetFinanceManagement | initDepreciationData | service | { "service": "voucher", "serviceFunction": "initDepreciationData" } | |
| 27 | ✅资产价值管理-查询资产库存 | assetFinanceManagement | selectWarehouseAsset | sql | { "table": "view01_warehouse_asset_not_in_finance_asset", "operation": "select" } | |
| 28 | ✅资产价值管理-查询会计期间 | assetFinanceManagement | selectFinancePeriod | sql | {"table": "view01_period_voucher", "operation": "select"} | |
| 29 | ✅资产价值管理-查询会计科目 | assetFinanceManagement | selectFinanceSubject | sql | {"table": "subject", "operation": "select"} | |
| 40 | ✅createSaleOrder-查询客户列表 | customerManagement | createSaleOrder-selectCustomerList | sql | { "table": "customer", "operation": "select" } | |
| 41 | ✅createSaleOrder-查询库存列表 | customerManagement | createSaleOrder-selectProductListByInventory | sql | { "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 | { "table": "sale_order", "operation": "select" } | |
| 44 | ✅销售出库 | customerManagement | createSaleOrder-inventoryOut | service | { "service": "inventory", "serviceFunction": "inventoryOut" } | |
| 45 | ✅查销售订单 | customerManagement | selectSaleOrderList | sql | { "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 | { "table": "customer", "operation": "select" } | |
| 48 | ✅customerManagement查询-添加成员 | customerManagement | insertItem | sql | { "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [] } | { "table": "customer", "operation": "insert" } |
| 49 | ✅customerManagement查询-更新成员 | customerManagement | updateItem | sql | { "table": "customer", "operation": "jhUpdate" } | |
| 50 | ✅customerManagement查询-删除信息 | customerManagement | deleteItem | sql | { "table": "customer", "operation": "jhDelete" } | |
| 90 | ✅查询列表 | paymentOfPay | selectItemList | sql | { "table": "payment", "operation": "select" } | |
| 91 | ✅添加 | paymentOfPay | insertItem | sql | { "table": "payment", "operation": "insert" } | |
| 92 | ✅更新 | paymentOfPay | updateItem | sql | { "table": "payment", "operation": "jhUpdate" } | |
| 93 | ✅删除 | paymentOfPay | deleteItem | sql | { "table": "payment", "operation": "jhDelete" } | |
| 94 | ✅查询订单列表 | paymentOfPay | selectPaymentOrderList | service | {"service": "payment", "serviceFunction": "selectPaymentOrderList"} | |
| 110 | ✅查询列表 | paymentOfReceipt | selectItemList | sql | { "table": "payment", "operation": "select" } | |
| 111 | ✅添加 | paymentOfReceipt | insertItem | sql | { "table": "payment", "operation": "insert" } | |
| 112 | ✅更新 | paymentOfReceipt | updateItem | sql | { "table": "payment", "operation": "jhUpdate" } | |
| 113 | ✅删除 | paymentOfReceipt | deleteItem | sql | { "table": "payment", "operation": "jhDelete" } | |
| 114 | ✅查询订单列表 | paymentOfReceipt | selectPaymentOrderList | service | {"service": "payment", "serviceFunction": "selectPaymentOrderList"} | |
| 123 | ✅查询客户信息 | saleOrderManagement | inventoryOutBySaleOrder-selectCustomer | sql | { "table": "customer", "operation": "select" } | |
| 130 | ✅更新订单备注 | purchaseOrderManagement | viewPurchaseOrder-updateOrderRemark | sql | { "table": "purchase_order", "operation": "jhUpdate" } | |
| 131 | ✅查询列表 | purchaseOrderManagement | selectItemList | sql | {"after":[{"service":"purchase","serviceFunction":"appendTicketList"}]} | { "table": "view01_purchase_order", "operation": "select" } |
| 132 | ✅添加 | purchaseOrderManagement | insertItem | sql | { "table": "purchase_order", "operation": "insert" } | |
| 133 | ✅更新 | purchaseOrderManagement | updateItem | sql | { "table": "purchase_order", "operation": "jhUpdate" } | |
| 134 | ✅删除 | purchaseOrderManagement | deleteItem | service | { "service": "purchase", "serviceFunction": "deleteOrder" } | |
| 135 | ✅查询订单信息 | purchaseOrderManagement | viewPurchaseOrder-selectOrder | sql | { "table": "purchase_order", "operation": "select" } | |
| 136 | ✅更新订单状态 | purchaseOrderManagement | viewPurchaseOrder-updateOrderStatus | sql | { "table": "purchase_order", "operation": "jhUpdate" } | |
| 137 | ✅查询供货商列表 | purchaseOrderManagement | selectSupplierList | sql | { "table": "supplier", "operation": "select" } | |
| 138 | ✅查询供货商信息 | purchaseOrderManagement | viewPurchaseOrder-selectSupplier | sql | { "table": "supplier", "operation": "select" } | |
| 139 | ✅查询订单信息 | purchaseOrderManagement | inventoryInByPurchaseOrder-selectOrder | sql | { "table": "purchase_order", "operation": "select" } | |
| 140 | ✅入库 | purchaseOrderManagement | inventoryInByPurchaseOrder-inventoryIn | service | { "service": "inventory", "serviceFunction": "inventoryIn" } | |
| 141 | ✅查询供货商信息 | purchaseOrderManagement | inventoryInByPurchaseOrder-selectSupplier | sql | { "table": "supplier", "operation": "select" } | |
| 142 | ✅查询入库信息 | purchaseOrderManagement | viewInventoryInByPurchaseOrder-selectInventoryInList | sql | { "table": "view01_warehouse_inventory", "operation": "select" } | |
| 143 | ✅查询订单信息 | purchaseOrderManagement | viewInventoryInByPurchaseOrder-selectOrder | sql | { "table": "purchase_order", "operation": "select" } | |
| 144 | ✅查询供货商信息 | purchaseOrderManagement | viewInventoryInByPurchaseOrder-selectSupplier | sql | { "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 | { "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 | { "table": "sale_order", "operation": "insert" } | |
| 182 | ✅更新 | saleOrderManagement | updateItem | sql | { "table": "sale_order", "operation": "jhUpdate" } | |
| 183 | ✅删除 | saleOrderManagement | deleteItem | service | { "service": "sale", "serviceFunction": "deleteOrder" } | |
| 184 | ✅查询订单信息 | saleOrderManagement | viewSaleOrder-selectOrder | sql | { "table": "sale_order", "operation": "select" } | |
| 185 | ✅更新订单状态 | saleOrderManagement | viewSaleOrder-updateOrderStatus | sql | { "table": "sale_order", "operation": "jhUpdate" } | |
| 186 | ✅查询客户列表 | saleOrderManagement | selectCustomerList | sql | { "table": "customer", "operation": "select" } | |
| 187 | ✅查询客户信息 | saleOrderManagement | viewSaleOrder-selectCustomer | sql | { "table": "customer", "operation": "select" } | |
| 188 | ✅查询订单信息 | saleOrderManagement | inventoryOutBySaleOrder-selectOrder | sql | { "table": "sale_order", "operation": "select" } | |
| 189 | ✅销售出库 | saleOrderManagement | inventoryOutBySaleOrder-inventoryOut | service | { "service": "inventory", "serviceFunction": "inventoryOut" } | |
| 191 | ✅更新订单备注 | saleOrderManagement | viewSaleOrder-updateOrderRemark | sql | { "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 | { "table": "customer", "operation": "select" } | |
| 212 | ✅更新退货订单 | salesReturnOrderManagement | updateReturnOrder | sql | { "table": "sale_return_order", "operation": "jhUpdate" } | |
| 230 | ✅productList-更新 | supplierManagement | productList-updateItem | sql | { "table": "supplier_product", "operation": "jhUpdate" } | |
| 231 | ✅productList-删除 | supplierManagement | productList-deleteItem | sql | { "table": "supplier_product", "operation": "jhDelete" } | |
| 232 | ✅createPurchaseOrder-查询供货商列表 | supplierManagement | createPurchaseOrder-selectSupplierList | sql | { "table": "supplier", "operation": "select" } | |
| 233 | ✅createPurchaseOrder-查询产品列表 | supplierManagement | createPurchaseOrder-selectProductList | sql | { "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 | { "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 | { "table": "supplier", "operation": "jhUpdate" } | |
| 238 | ✅supplierManagement查询-删除信息 | supplierManagement | deleteItem | sql | { "table": "supplier", "operation": "jhDelete" } | |
| 239 | ✅productList-查询列表 | supplierManagement | productList-selectItemList | sql | { "table": "supplier_product", "operation": "select" } | |
| 240 | ✅productList-添加 | supplierManagement | productList-insertItem | sql | { "table": "supplier_product", "operation": "insert" } | |
| 260 | ✅查询列表 | ticketManagement | selectItemList | sql | { "table": "ticket", "operation": "select"} | |
| 261 | ✅创建工单 | ticketManagement | createTicket | service | {"service": "ticket", "serviceFunction": "createTicket"} | |
| 262 | ✅更新 | ticketManagement | updateItem | sql | { "table": "ticket", "operation": "jhUpdate" } | |
| 263 | ✅删除 | ticketManagement | deleteItem | sql | { "table": "ticket", "operation": "jhDelete" } | |
| 264 | ✅查询订单信息 | ticketManagement | selectItem | sql | { "table": "ticket", "operation": "select" } | |
| 265 | ✅查询供货商列表 | ticketManagement | selectSupplierList | sql | { "table": "supplier", "operation": "select" } | |
| 266 | ✅工单-采购付款申请单-处理 | ticketManagement | handlePurchasePaymentRequest | service | {"service": "payment", "serviceFunction": "paymentIn"} | |
| 267 | ✅查询采购单列表 | ticketManagement | selectPurchaseOrderList | sql | { "table": "view01_purchase_order", "operation": "select" } | |
| 268 | ✅查询销售单列表 | ticketManagement | selectSaleOrderList | sql | { "table": "view01_sale_order", "operation": "select" } | |
| 269 | ✅工单-采购入库申请单-处理 | ticketManagement | handlePurchaseWarehouseInRequest | service | {"service": "warehouse", "serviceFunction": "inventoryIn"} | |
| 270 | ✅查询客户列表 | ticketManagement | selectCustomerList | sql | { "table": "customer", "operation": "select" } | |
| 271 | ✅处理销售收款申请单 | ticketManagement | payment-handleSalePaymentInRequest-handleItem | service | {"service": "payment", "serviceFunction": "paymentIn"} | |
| 272 | ✅处理资产申请单 | ticketManagement | asset-handlePurchaseAssetInRequest-handleItem | service | {"service": "asset", "serviceFunction": "handleTicket"} | |
| 273 | ✅工单-销售出库申请单-处理 | ticketManagement | handleSaleWarehouseOutRequest | service | {"service": "warehouse", "serviceFunction": "inventoryOut"} | |
| 274 | ✅查询资产列表 | ticketManagement | selectAssetList | sql | { "table": "warehouse_asset", "operation": "select" } | |
| 275 | ✅查询资产列表 | ticketManagement | selectAssetListByUse | sql | { "table": "view01_asset_list_for_apply", "operation": "select" } | |
| 276 | ✅查询采购退货工单列表 | ticketManagement | selectPurchaseReturnOrderList | sql | { "table": "view01_purchase_return_order", "operation": "select" } | |
| 277 | ✅工单-采购退货出库申请单-处理 | ticketManagement | handlePurchaseReturnWarehouseOutRequest | service | {"service": "warehouse", "serviceFunction": "inventoryOut"} | |
| 278 | ✅处理采购收款工单 | ticketManagement | payment-handlePurchaseReturnPaymentInRequest-handleItem | service | {"service": "payment", "serviceFunction": "paymentIn"} | |
| 279 | ✅工单-销售退货入库申请单-处理 | ticketManagement | handleSaleReturnWarehouseInRequest | service | {"service": "warehouse", "serviceFunction": "inventoryIn"} | |
| 300 | ✅查询列表 | voucherGenerate | selectItemList | sql | { "table": "view01_ticket_voucher", "operation": "select" } | |
| 301 | ✅添加 | voucherGenerate | insertItem | sql | { "table": "ticket", "operation": "insert" } | |
| 302 | ✅更新 | voucherGenerate | updateItem | sql | { "table": "ticket", "operation": "jhUpdate" } | |
| 303 | ✅删除 | voucherGenerate | deleteItem | sql | { "table": "ticket", "operation": "jhDelete" } | |
| 304 | ✅查询下个凭证字号 | voucherGenerate | selectNextVoucherNumber | sql | { "table": "view01_next_voucher_number", "operation": "select" } | |
| 305 | ✅生成单据凭证 | voucherGenerate | createTicketVoucher | service | { "service": "voucher", "serviceFunction": "createTicketVoucher" } | |
| 306 | ✅删除凭证 | voucherGenerate | deleteVoucher | sql | { "table": "voucher", "operation": "jhDelete" } | |
| 307 | ✅查询凭证 | voucherGenerate | selectVoucher | sql | {"after":[{"service":"voucher","serviceFunction":"appendEntryList"}]} | { "table": "voucher", "operation": "select" } |
| 320 | ✅查询列表 | warehouseAssetManagement | selectItemList | sql | { "table": "warehouse_asset", "operation": "select" } | |
| 321 | ✅添加 | warehouseAssetManagement | insertItem | sql | { "table": "warehouse_asset", "operation": "insert" } | |
| 322 | ✅更新 | warehouseAssetManagement | updateItem | sql | { "table": "warehouse_asset", "operation": "jhUpdate" } | |
| 323 | ✅删除 | warehouseAssetManagement | deleteItem | sql | { "table": "warehouse_asset", "operation": "jhDelete" } | |
| 340 | ✅查询列表 | warehouseAssetRecord | selectItemList | sql | { "table": "warehouse_asset_record", "operation": "select" } | |
| 341 | ✅添加 | warehouseAssetRecord | insertItem | sql | { "table": "warehouse_asset_record", "operation": "insert" } | |
| 342 | ✅更新 | warehouseAssetRecord | updateItem | sql | { "table": "warehouse_asset_record", "operation": "jhUpdate" } | |
| 343 | ✅删除 | warehouseAssetRecord | deleteItem | sql | { "table": "warehouse_asset_record", "operation": "jhDelete" } | |
| 360 | ✅查询列表 | warehouseInventoryManagement | selectItemList | sql | { "table": "view01_warehouse_inventory", "operation": "select" } | |
| 361 | ✅添加 | warehouseInventoryManagement | insertItem | sql | { "table": "warehouse_inventory", "operation": "insert" } | |
| 362 | ✅更新 | warehouseInventoryManagement | updateItem | sql | { "table": "warehouse_inventory", "operation": "jhUpdate" } | |
| 363 | ✅删除 | warehouseInventoryManagement | deleteItem | sql | { "table": "warehouse_inventory", "operation": "jhDelete" } | |
| 380 | ✅查询列表 | warehouseInventoryRecord | selectItemList | sql | { "table": "warehouse_inventory_record", "operation": "select" } | |
| 381 | ✅添加 | warehouseInventoryRecord | insertItem | sql | { "table": "warehouse_inventory_record", "operation": "insert" } | |
| 382 | ✅更新 | warehouseInventoryRecord | updateItem | sql | { "table": "warehouse_inventory_record", "operation": "jhUpdate" } | |
| 383 | ✅删除 | warehouseInventoryRecord | deleteItem | sql | { "table": "warehouse_inventory_record", "operation": "jhDelete" } | |
| 400 | ✅查询客户列表 | warehouseTicketRequest | selectCustomerList | sql | { "table": "customer", "operation": "select" } | |
| 401 | ✅查询供货商列表 | warehouseTicketRequest | selectSupplierList | sql | { "table": "supplier", "operation": "select" } | |
| 402 | ✅查询申请单列表 | warehouseTicketRequest | selectTicketList | sql | { "table": "ticket", "operation": "select"} | |
| 420 | ✅查询客户列表 | assetTicketRequest | selectCustomerList | sql | { "table": "customer", "operation": "select" } | |
| 421 | ✅查询供货商列表 | assetTicketRequest | selectSupplierList | sql | { "table": "supplier", "operation": "select" } | |
| 422 | ✅查询申请单列表 | assetTicketRequest | selectTicketList | sql | { "table": "ticket", "operation": "select"} | |
| 440 | ✅查询客户列表 | paymentTicketRequest | selectCustomerList | sql | { "table": "customer", "operation": "select" } | |
| 441 | ✅查询供货商列表 | paymentTicketRequest | selectSupplierList | sql | { "table": "supplier", "operation": "select" } | |
| 442 | ✅查询申请单列表 | paymentTicketRequest | selectTicketList | sql | { "table": "ticket", "operation": "select"} | |
| 652 | ✅获取库存-待处理出入库数据 | ticketManagement | warehouse-getTicketOrderHandleData | sql | {"table": "view01_ticket_order", "operation": "select"} | |
| 653 | ✅获取会计期间列表 | financePeriodManagement | selectItemList | sql | {"table": "view01_period_voucher", "operation": "select"} | |
| 654 | ✅添加会计期间 | financePeriodManagement | insertItem | sql | {"before":[{"service":"financePeriod","serviceFunction":"checkRepeat"}]} | {"table": "finance_period", "operation": "insert"} |
| 657 | ✅生成折旧凭证 | voucherGenerate | generateDepreciationVoucher | service | { "service": "voucher", "serviceFunction": "generateDepreciationVoucher" } | |
| 660 | ✅查询常量 | allPage | getConstantList | sql | {"table": "_constant", "operation": "select"} | |
| 661 | ✅资产类别管理-查询列表 | assetTypeManagement | selectItemList | sql | { "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 | { "table": "finance_asset_type", "operation": "jhUpdate" } | |
| 664 | ✅资产类别管理-删除信息 | assetTypeManagement | deleteItem | sql | { "table": "finance_asset_type", "operation": "jhDelete" } | |
| 665 | ✅资产折旧明细-查询列表 | assetRecord | selectItemList | sql | { "table": "finance_asset_record", "operation": "select" } | |
| 666 | ✅资产汇总-查询列表 | assetSummary | selectItemList | service | { "service": "financePeriod", "serviceFunction": "assetSummary" } | |
| 667 | ✅资产核对总账-查询列表 | assetCheck | selectItemList | service | { "service": "financePeriod", "serviceFunction": "assetCheck" } | |
| 671 | ✅用户管理-查询信息 | userManagement | selectItemList | sql | {"table": "_user", "operation": "select"} | |
| 672 | ✅用户管理-查询信息 | userManagement | insertItem | service | {"service": "userManagement", "serviceFunction": "addUser"} | |
| 673 | ✅用户管理-修改密码 | userManagement | resetUserPassword | service | {"service": "userManagement", "serviceFunction": "resetUserPassword"} | |
| 674 | ✅用户管理-更新用户 | userManagement | updateItem | sql | {"table": "_user", "operation": "jhUpdate"} | |
| 795 | ticketManagement | getUserList | sql | {"table": "_view01_user", "operation": "select"} | ||
| 796 | ✅创建工单 | ticketManagement | createAssetTicket | service | {"service": "ticket", "serviceFunction": "createAssetTicket"} | |
| 797 | ✅仓库管理-查询列表 | warehouseManagement | selectItemList | sql | { "table": "warehouse_stock", "operation": "select" } | |
| 798 | ✅仓库管理-添加 | warehouseManagement | insertItem | sql | { "before": [ | |
| {"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"} | ||||||
| ], "after": [ | ||||||
| ] } | { "table": "warehouse_stock", "operation": "jhInsert" } | |||||
| 799 | ✅仓库管理-更新 | warehouseManagement | updateItem | sql | { "table": "warehouse_stock", "operation": "jhUpdate" } | |
| 800 | ✅仓库管理-删除 | warehouseManagement | deleteItem | sql | { "table": "warehouse_stock", "operation": "jhDelete" } | |
| 801 | ✅工单-查询仓库列表 | ticketManagement | selectWarehouseList | sql | { "table": "warehouse_stock", "operation": "select" } | |
| 806 | ✅采购资产退货 | ticketManagement | asset-handlePurchaseReturnOutRequest-handleItem | service | { "service": "asset", "serviceFunction": "inventoryOut" } | |
| 807 | ✅查询列表 | assetScrapped | selectItemList | sql | { "table": "view01_warehouse_asset_finance", "operation": "select" } | |
| 808 | ✅添加 | assetScrapped | insertItem | sql | { "table": "finance_asset", "operation": "insert" } | |
| 809 | ✅更新 | assetScrapped | generateScrappedVoucher | service | { "service": "voucher", "serviceFunction": "generateScrappedVoucher" } | |
| 810 | ✅会计期间列表 | assetScrapped | selectFinancePeriodList | sql | {"table": "view01_period_voucher", "operation": "select"} | |
| 811 | ✅资产列表 | assetScrapped | selectAssetList | sql | { "table": "view01_finance_asset_last", "operation": "select" } | |
| 812 | ✅凭证列表 | assetScrapped | selectVoucherList | sql | { "table": "voucher", "operation": "select" } | |
| 813 | ✅凭证明细列表 | assetCheck | selectVoucherEntryList | sql | { "table": "view01_voucher_entry", "operation": "select" } | |
| 814 | ✅查询下个凭证字号 | assetFinanceManagement | selectNextVoucherNumber | sql | { "table": "view01_next_voucher_number", "operation": "select" } | |
| 815 | ✅查询可退货采购列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectPurchaseAssetList | sql | { "table": "warehouse_asset", "operation": "select" } | |
| 816 | ✅查询资产采购单的现有库存列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectProductListFromAsset | sql | {"after":[{"service":"purchase","serviceFunction":"calcAssetOrderCount"}]} | { "table": "warehouse_asset", "operation": "select" } |
| 817 | ✅查询列表 | warehouseInventoryRecord | selectAssetItemList | sql | { "table": "warehouse_asset_record", "operation": "select" } | |
| 818 | ✅createPurchaseOrder-添加采购产品价格记录 | supplierManagement | createPurchaseOrder-insertPurchasePriceRecord | sql | { "table": "purchase_price_history", "operation": "jhInsert" } | |
| 819 | ✅createSaleOrder-添加销售产品价格记录 | customerManagement | createSaleOrder-insertSalesProductPriceRecord | sql | { "table": "sale_price_history", "operation": "jhInsert" } | |
| 820 | ✅createPurchaseOrder-查询采购产品价格记录 | supplierManagement | createPurchaseOrder-selectPriceList | sql | { "table": "purchase_price_history", "operation": "select" } | |
| 821 | ✅createSaleOrder-查询采购产品价格记录 | customerManagement | createSaleOrder-selectPriceList | sql | { "table": "sale_price_history", "operation": "select" } | |
| 822 | ✅凭证明细列表 | assetScrapped | selectVoucherEntryList | sql | { "table": "view01_voucher_entry", "operation": "select" } |
_resource语句
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);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');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');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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (163, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [{"service": "common", "serviceFunction": "generateBizIdOfAfterHook"}] }', 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-insertItem', '✅新增退货订单', 'sql', '{}', '{ "table": "purchase_return_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (234, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [{"service": "common", "serviceFunction": "generateBizIdOfAfterHook"}] }', 'supplierManagement', 'createPurchaseOrder-insertItem', '✅createPurchaseOrder-添加采购订单', 'sql', '{}', '{ "table": "purchase_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);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);INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (236, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [] }', 'supplierManagement', 'insertItem', '✅supplierManagement查询-添加成员', 'sql', '{}', '{ "table": "supplier", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (662, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [] }', 'assetTypeManagement', 'insertItem', '✅资产类别管理-添加信息', 'sql', '{}', '{ "table": "finance_asset_type", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);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);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);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);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);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);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');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');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');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');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);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);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);INSERT INTO _resource (id, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (798, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [] }', 'warehouseManagement', 'insertItem', '✅仓库管理-添加', 'sql', '{}', '{ "table": "warehouse_stock", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);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);