接口
12114接口总览
_resource结构
CREATE TABLE `_resource` (`id` int(11) NOT NULL AUTO_INCREMENT,`accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',`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 = 802 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 | selectItemList | sql | { "table": "view01_finance_asset_info", "operation": "select" } | |
| 21 | ✅添加 | assetFinanceManagement | insertItem | sql | { "table": "finance_asset", "operation": "insert" } | |
| 22 | ✅更新 | assetFinanceManagement | updateItem | sql | { "table": "finance_asset", "operation": "jhUpdate" } | |
| 23 | ✅删除 | assetFinanceManagement | deleteItem | sql | { "table": "finance_asset", "operation": "jhDelete" } | |
| 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 | sql | { "table": "purchase_order", "operation": "jhDelete" } | |
| 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": "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 | sql | { "table": "sale_order", "operation": "jhDelete" } | |
| 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": "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"} |
| 655 | ✅资产折旧记录明细列表 | financeAssetRecord | selectItemList | sql | {"table": "finance_asset_record", "operation": "select"} | |
| 657 | ✅生成折旧凭证 | voucherGenerate | generateDepreciationVoucher | service | { "service": "voucher", "serviceFunction": "generateDepreciationVoucher" } | |
| 659 | ✅初始化折旧数据 | assetFinanceManagement | initDepreciationData | service | { "service": "voucher", "serviceFunction": "initDepreciationData" } | |
| 660 | ✅查询常量 | allPage | getConstantList | sql | {"table": "_constant", "operation": "select"} | |
| 795 | ticketManagement | getUserList | sql | {"table": "_view01_user", "operation": "select"} | ||
| 796 | ✅创建工单 | ticketManagement | createAssetTicket | service | {"service": "ticket", "serviceFunction": "createAssetTicket"} | |
| 797 | ✅商品库存 | ticketManagement | selectWarehouseList | sql | { "table": "warehouse_inventory", "operation": "select" } | |
| 798 | ✅查询资产采购单的现有库存列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectProductListFromAsset | sql | {"after":[{"service":"purchase","serviceFunction":"calcAssetOrderCount"}]} | { "table": "warehouse_asset", "operation": "select" } |
| 799 | ✅查询可退货采购列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectPurchaseAssetList | sql | { "table": "warehouse_asset", "operation": "select" } | |
| 800 | ✅采购资产退货 | ticketManagement | asset-handlePurchaseReturnOutRequest-handleItem | service | { "service": "asset", "serviceFunction": "inventoryOut" } | |
| 801 | ✅查询列表 | warehouseInventoryRecord | selectAssetItemList | sql | { "table": "warehouse_asset_record", "operation": "select" } |
_resource语句
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (2, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (20, NULL, NULL, 'assetFinanceManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_finance_asset_info", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (21, NULL, NULL, 'assetFinanceManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "finance_asset", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (22, NULL, NULL, 'assetFinanceManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "finance_asset", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (23, NULL, NULL, 'assetFinanceManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "finance_asset", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (40, NULL, NULL, 'customerManagement', 'createSaleOrder-selectCustomerList', '✅createSaleOrder-查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (41, NULL, NULL, 'customerManagement', 'createSaleOrder-selectProductListByInventory', '✅createSaleOrder-查询库存列表', 'sql', '{}', '{ "table": "view01_warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (42, NULL, '{ "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, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (43, NULL, NULL, 'customerManagement', 'createSaleOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (44, NULL, NULL, 'customerManagement', 'createSaleOrder-inventoryOut', '✅销售出库', 'service', '{}', '{ "service": "inventory", "serviceFunction": "inventoryOut" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, NULL, NULL, 'customerManagement', 'selectSaleOrderList', '✅查销售订单', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (46, NULL, '{ "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, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (47, NULL, NULL, 'customerManagement', 'selectItemList', '✅customerManagement查询-查询列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (48, NULL, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [] }', 'customerManagement', 'insertItem', '✅customerManagement查询-添加成员', 'sql', '{}', '{ "table": "customer", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (49, NULL, NULL, 'customerManagement', 'updateItem', '✅customerManagement查询-更新成员', 'sql', '{}', '{ "table": "customer", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (50, NULL, NULL, 'customerManagement', 'deleteItem', '✅customerManagement查询-删除信息', 'sql', '{}', '{ "table": "customer", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (90, NULL, NULL, 'paymentOfPay', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "payment", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (91, NULL, NULL, 'paymentOfPay', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "payment", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (92, NULL, NULL, 'paymentOfPay', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "payment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (93, NULL, NULL, 'paymentOfPay', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "payment", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (94, NULL, NULL, 'paymentOfPay', 'selectPaymentOrderList', '✅查询订单列表', 'service', '{}', '{"service": "payment", "serviceFunction": "selectPaymentOrderList"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (110, NULL, NULL, 'paymentOfReceipt', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "payment", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (111, NULL, NULL, 'paymentOfReceipt', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "payment", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (112, NULL, NULL, 'paymentOfReceipt', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "payment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (113, NULL, NULL, 'paymentOfReceipt', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "payment", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (114, NULL, NULL, 'paymentOfReceipt', 'selectPaymentOrderList', '✅查询订单列表', 'service', '{}', '{"service": "payment", "serviceFunction": "selectPaymentOrderList"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (123, NULL, NULL, 'saleOrderManagement', 'inventoryOutBySaleOrder-selectCustomer', '✅查询客户信息', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (130, NULL, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-updateOrderRemark', '✅更新订单备注', 'sql', '{}', '{ "table": "purchase_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (131, NULL, '{"after":[{"service":"purchase","serviceFunction":"appendTicketList"}]}', 'purchaseOrderManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (132, NULL, NULL, 'purchaseOrderManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "purchase_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (133, NULL, NULL, 'purchaseOrderManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "purchase_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (134, NULL, NULL, 'purchaseOrderManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "purchase_order", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (135, NULL, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (136, NULL, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-updateOrderStatus', '✅更新订单状态', 'sql', '{}', '{ "table": "purchase_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (137, NULL, NULL, 'purchaseOrderManagement', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (138, NULL, NULL, 'purchaseOrderManagement', 'viewPurchaseOrder-selectSupplier', '✅查询供货商信息', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (139, NULL, NULL, 'purchaseOrderManagement', 'inventoryInByPurchaseOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (140, NULL, NULL, 'purchaseOrderManagement', 'inventoryInByPurchaseOrder-inventoryIn', '✅入库', 'service', '{}', '{ "service": "inventory", "serviceFunction": "inventoryIn" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (141, NULL, NULL, 'purchaseOrderManagement', 'inventoryInByPurchaseOrder-selectSupplier', '✅查询供货商信息', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (142, NULL, NULL, 'purchaseOrderManagement', 'viewInventoryInByPurchaseOrder-selectInventoryInList', '✅查询入库信息', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (143, NULL, NULL, 'purchaseOrderManagement', 'viewInventoryInByPurchaseOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (144, NULL, NULL, 'purchaseOrderManagement', 'viewInventoryInByPurchaseOrder-selectSupplier', '✅查询供货商信息', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (160, NULL, '{"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, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (161, NULL, '', 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-selectPurchaseList', '✅查询可退货采购列表', 'sql', '{}', '{ "table": "view01_purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (162, NULL, '{"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, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (163, NULL, '{ "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, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (164, NULL, '', 'purchaseReturnOrderManagement', 'viewReturnOrder-selectOrder', '✅查询退货列表', 'sql', '{}', '{ "table": "view01_purchase_return_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (165, NULL, NULL, 'purchaseReturnOrderManagement', 'viewReturnOrder-updateOrderStatus', '✅更新退货订单', 'sql', '{}', '{ "table": "purchase_return_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (180, NULL, '{"after":[{"service":"sale","serviceFunction":"appendTicketList"}]}', 'saleOrderManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (181, NULL, NULL, 'saleOrderManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "sale_order", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (182, NULL, NULL, 'saleOrderManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "sale_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (183, NULL, NULL, 'saleOrderManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "sale_order", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (184, NULL, NULL, 'saleOrderManagement', 'viewSaleOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (185, NULL, NULL, 'saleOrderManagement', 'viewSaleOrder-updateOrderStatus', '✅更新订单状态', 'sql', '{}', '{ "table": "sale_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (186, NULL, NULL, 'saleOrderManagement', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (187, NULL, NULL, 'saleOrderManagement', 'viewSaleOrder-selectCustomer', '✅查询客户信息', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (188, NULL, NULL, 'saleOrderManagement', 'inventoryOutBySaleOrder-selectOrder', '✅查询订单信息', 'sql', '{}', '{ "table": "sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (189, NULL, NULL, 'saleOrderManagement', 'inventoryOutBySaleOrder-inventoryOut', '✅销售出库', 'service', '{}', '{ "service": "inventory", "serviceFunction": "inventoryOut" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (191, NULL, NULL, 'saleOrderManagement', 'viewSaleOrder-updateOrderRemark', '✅更新订单备注', 'sql', '{}', '{ "table": "sale_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (210, NULL, '{"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, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (211, NULL, NULL, 'salesReturnOrderManagement', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (212, NULL, '', 'salesReturnOrderManagement', 'updateReturnOrder', '✅更新退货订单', 'sql', '{}', '{ "table": "sale_return_order", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (230, NULL, NULL, 'supplierManagement', 'productList-updateItem', '✅productList-更新', 'sql', '{}', '{ "table": "supplier_product", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'supplierManagement', 'productList-deleteItem', '✅productList-删除', 'sql', '{}', '{ "table": "supplier_product", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (232, NULL, NULL, 'supplierManagement', 'createPurchaseOrder-selectSupplierList', '✅createPurchaseOrder-查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (233, NULL, NULL, 'supplierManagement', 'createPurchaseOrder-selectProductList', '✅createPurchaseOrder-查询产品列表', 'sql', '{}', '{ "table": "supplier_product", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (234, NULL, '{ "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, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (235, NULL, NULL, 'supplierManagement', 'selectItemList', '✅supplierManagement查询-查询列表', 'sql', '{}', '{ "table": "view01_supplier_info", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (236, NULL, '{ "before": [{"service": "common", "serviceFunction": "generateBizIdOfBeforeHook"}], "after": [] }', 'supplierManagement', 'insertItem', '✅supplierManagement查询-添加成员', 'sql', '{}', '{ "table": "supplier", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (237, NULL, NULL, 'supplierManagement', 'updateItem', '✅supplierManagement查询-更新成员', 'sql', '{}', '{ "table": "supplier", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (238, NULL, NULL, 'supplierManagement', 'deleteItem', '✅supplierManagement查询-删除信息', 'sql', '{}', '{ "table": "supplier", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (239, NULL, NULL, 'supplierManagement', 'productList-selectItemList', '✅productList-查询列表', 'sql', '{}', '{ "table": "supplier_product", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (240, NULL, NULL, 'supplierManagement', 'productList-insertItem', '✅productList-添加', 'sql', '{}', '{ "table": "supplier_product", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (260, NULL, NULL, 'ticketManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (261, NULL, '', 'ticketManagement', 'createTicket', '✅创建工单', 'service', '{}', '{"service": "ticket", "serviceFunction": "createTicket"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (262, NULL, NULL, 'ticketManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "ticket", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (263, NULL, NULL, 'ticketManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "ticket", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (264, NULL, NULL, 'ticketManagement', 'selectItem', '✅查询订单信息', 'sql', '{}', '{ "table": "ticket", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (265, NULL, NULL, 'ticketManagement', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (266, NULL, NULL, 'ticketManagement', 'handlePurchasePaymentRequest', '✅工单-采购付款申请单-处理', 'service', '{}', '{"service": "payment", "serviceFunction": "paymentIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (267, NULL, NULL, 'ticketManagement', 'selectPurchaseOrderList', '✅查询采购单列表', 'sql', '{}', '{ "table": "view01_purchase_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (268, NULL, NULL, 'ticketManagement', 'selectSaleOrderList', '✅查询销售单列表', 'sql', '{}', '{ "table": "view01_sale_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (269, NULL, NULL, 'ticketManagement', 'handlePurchaseWarehouseInRequest', '✅工单-采购入库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (270, NULL, NULL, 'ticketManagement', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (271, NULL, NULL, 'ticketManagement', 'payment-handleSalePaymentInRequest-handleItem', '✅处理销售收款申请单', 'service', '{}', '{"service": "payment", "serviceFunction": "paymentIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (272, NULL, NULL, 'ticketManagement', 'asset-handlePurchaseAssetInRequest-handleItem', '✅处理资产申请单', 'service', '{}', '{"service": "asset", "serviceFunction": "handleTicket"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (273, NULL, NULL, 'ticketManagement', 'handleSaleWarehouseOutRequest', '✅工单-销售出库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryOut"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (274, NULL, NULL, 'ticketManagement', 'selectAssetList', '✅查询资产列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (275, NULL, NULL, 'ticketManagement', 'selectAssetListByUse', '✅查询资产列表', 'sql', '{}', '{ "table": "view01_asset_list_for_apply", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (276, NULL, NULL, 'ticketManagement', 'selectPurchaseReturnOrderList', '✅查询采购退货工单列表', 'sql', '{}', '{ "table": "view01_purchase_return_order", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (277, NULL, NULL, 'ticketManagement', 'handlePurchaseReturnWarehouseOutRequest', '✅工单-采购退货出库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryOut"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (278, NULL, NULL, 'ticketManagement', 'payment-handlePurchaseReturnPaymentInRequest-handleItem', '✅处理采购收款工单', 'service', '{}', '{"service": "payment", "serviceFunction": "paymentIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (279, NULL, NULL, 'ticketManagement', 'handleSaleReturnWarehouseInRequest', '✅工单-销售退货入库申请单-处理', 'service', '{}', '{"service": "warehouse", "serviceFunction": "inventoryIn"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (300, NULL, NULL, 'voucherGenerate', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_ticket_voucher", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (301, NULL, NULL, 'voucherGenerate', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "ticket", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (302, NULL, NULL, 'voucherGenerate', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "ticket", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (303, NULL, NULL, 'voucherGenerate', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "ticket", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (304, NULL, NULL, 'voucherGenerate', 'selectNextVoucherNumber', '✅查询下个凭证字号', 'sql', '{}', '{ "table": "view01_next_voucher_number", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (305, NULL, NULL, 'voucherGenerate', 'createTicketVoucher', '✅生成单据凭证', 'service', '{}', '{ "service": "voucher", "serviceFunction": "createTicketVoucher" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (306, NULL, NULL, 'voucherGenerate', 'deleteVoucher', '✅删除凭证', 'sql', '{}', '{ "table": "voucher", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (307, NULL, '{"after":[{"service":"voucher","serviceFunction":"appendEntryList"}]}', 'voucherGenerate', 'selectVoucher', '✅查询凭证', 'sql', '{}', '{ "table": "voucher", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (320, NULL, NULL, 'warehouseAssetManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (321, NULL, NULL, 'warehouseAssetManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (322, NULL, NULL, 'warehouseAssetManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (323, NULL, NULL, 'warehouseAssetManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (340, NULL, NULL, 'warehouseAssetRecord', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (341, NULL, NULL, 'warehouseAssetRecord', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (342, NULL, NULL, 'warehouseAssetRecord', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (343, NULL, NULL, 'warehouseAssetRecord', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (360, NULL, NULL, 'warehouseInventoryManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (361, NULL, NULL, 'warehouseInventoryManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (362, NULL, NULL, 'warehouseInventoryManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (363, NULL, NULL, 'warehouseInventoryManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, NULL, 'warehouseInventoryRecord', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, NULL, 'warehouseInventoryRecord', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'warehouseInventoryRecord', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, NULL, 'warehouseInventoryRecord', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "warehouse_inventory_record", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (400, NULL, NULL, 'warehouseTicketRequest', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (401, NULL, NULL, 'warehouseTicketRequest', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (402, NULL, NULL, 'warehouseTicketRequest', 'selectTicketList', '✅查询申请单列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (420, NULL, NULL, 'assetTicketRequest', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (421, NULL, NULL, 'assetTicketRequest', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (422, NULL, NULL, 'assetTicketRequest', 'selectTicketList', '✅查询申请单列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (440, NULL, NULL, 'paymentTicketRequest', 'selectCustomerList', '✅查询客户列表', 'sql', '{}', '{ "table": "customer", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (441, NULL, NULL, 'paymentTicketRequest', 'selectSupplierList', '✅查询供货商列表', 'sql', '{}', '{ "table": "supplier", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (442, NULL, NULL, 'paymentTicketRequest', 'selectTicketList', '✅查询申请单列表', 'sql', '{}', '{ "table": "ticket", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (652, NULL, NULL, 'ticketManagement', 'warehouse-getTicketOrderHandleData', '✅获取库存-待处理出入库数据', 'sql', '{}', '{"table": "view01_ticket_order", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (653, NULL, NULL, 'financePeriodManagement', 'selectItemList', '✅获取会计期间列表', 'sql', '{}', '{"table": "view01_period_voucher", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (654, NULL, '{"before":[{"service":"financePeriod","serviceFunction":"checkRepeat"}]}', 'financePeriodManagement', 'insertItem', '✅添加会计期间', 'sql', '{}', '{"table": "finance_period", "operation": "insert"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (655, NULL, NULL, 'financeAssetRecord', 'selectItemList', '✅资产折旧记录明细列表', 'sql', '{}', '{"table": "finance_asset_record", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (657, NULL, NULL, 'voucherGenerate', 'generateDepreciationVoucher', '✅生成折旧凭证', 'service', '{}', '{ "service": "voucher", "serviceFunction": "generateDepreciationVoucher" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (659, NULL, NULL, 'assetFinanceManagement', 'initDepreciationData', '✅初始化折旧数据', 'service', NULL, '{ "service": "voucher", "serviceFunction": "initDepreciationData" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (660, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (795, NULL, NULL, 'ticketManagement', 'getUserList', NULL, 'sql', NULL, '{"table": "_view01_user", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (796, NULL, NULL, 'ticketManagement', 'createAssetTicket', '✅创建工单', 'service', '{}', '{"service": "ticket", "serviceFunction": "createAssetTicket"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (797, NULL, NULL, 'ticketManagement', 'selectWarehouseList', '✅商品库存', 'sql', '{}', '{ "table": "warehouse_inventory", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (798, NULL, '{"after":[{"service":"purchase","serviceFunction":"calcAssetOrderCount"}]}', 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-selectProductListFromAsset', '✅查询资产采购单的现有库存列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (799, NULL, NULL, 'purchaseReturnOrderManagement', 'createPurchaseReturnOrder-selectPurchaseAssetList', '✅查询可退货采购列表', 'sql', '{}', '{ "table": "warehouse_asset", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (800, NULL, NULL, 'ticketManagement', 'asset-handlePurchaseReturnOutRequest-handleItem', '✅采购资产退货', 'service', NULL, '{ "service": "asset", "serviceFunction": "inventoryOut" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (801, NULL, NULL, 'warehouseInventoryRecord', 'selectAssetItemList', '✅查询列表', 'sql', '{}', '{ "table": "warehouse_asset_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);