页面
12129页面总览
_page结构
CREATE TABLE `_page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
`pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
`pageHook` varchar(255) DEFAULT NULL COMMENT 'pageHook',
`pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
`pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
`pageIcon` text ,
`sort` varchar(255) DEFAULT NULL,
`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 = 159 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'
帮助
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
帮助 | help | dynamicInMenu | helpV4 | 67 | null |
登陆
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
登陆 | login | loginV4 | null |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅登陆 | login | passwordLogin | null | service | {"service": "user", "serviceFunction": "passwordLogin"} | {} | 3 | update | 2022-04-27T15:32:57+08:00 |
[采购]供货商列表
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[采购]供货商列表 | supplierManagement | showInMenu | 03 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"},{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅productList-更新 | supplierManagement | productList-updateItem | null | sql | { "table": "supplier_product", "operation": "jhUpdate" } | {} | 230 | insert | |||||
✅productList-删除 | supplierManagement | productList-deleteItem | null | sql | { "table": "supplier_product", "operation": "jhDelete" } | {} | 231 | insert | |||||
✅createPurchaseOrder-查询供货商列表 | supplierManagement | createPurchaseOrder-selectSupplierList | null | sql | { "table": "supplier", "operation": "select" } | {} | 232 | insert | |||||
✅createPurchaseOrder-查询产品列表 | supplierManagement | createPurchaseOrder-selectProductList | null | sql | { "table": "supplier_product", "operation": "select" } | {} | 233 | insert | |||||
✅createPurchaseOrder-添加采购订单 | supplierManagement | createPurchaseOrder-insertItem | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } | sql | { "table": "purchase_order", "operation": "insert" } | {} | 234 | insert | |||||
✅supplierManagement查询-查询列表 | supplierManagement | selectItemList | null | sql | { "table": "view01_supplier_info", "operation": "select" } | {} | 235 | insert | |||||
✅supplierManagement查询-添加成员 | supplierManagement | insertItem | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } | sql | { "table": "supplier", "operation": "insert" } | {} | 236 | insert | |||||
✅supplierManagement查询-更新成员 | supplierManagement | updateItem | null | sql | { "table": "supplier", "operation": "jhUpdate" } | {} | 237 | insert | |||||
✅supplierManagement查询-删除信息 | supplierManagement | deleteItem | null | sql | { "table": "supplier", "operation": "jhDelete" } | {} | 238 | insert | |||||
✅productList-查询列表 | supplierManagement | productList-selectItemList | null | sql | { "table": "supplier_product", "operation": "select" } | {} | 239 | insert | |||||
✅productList-添加 | supplierManagement | productList-insertItem | null | sql | { "table": "supplier_product", "operation": "insert" } | {} | 240 | insert | |||||
✅createPurchaseOrder-添加采购产品价格记录 | supplierManagement | createPurchaseOrder-insertPurchasePriceRecord | null | sql | { "table": "purchase_price_history", "operation": "jhInsert" } | {} | 818 | insert | |||||
✅createPurchaseOrder-查询采购产品价格记录 | supplierManagement | createPurchaseOrder-selectPriceList | null | sql | { "table": "purchase_price_history", "operation": "select" } | {} | 820 | insert |
[销售]客户列表
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[销售]客户列表 | customerManagement | showInMenu | 04 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅createSaleOrder-查询客户列表 | customerManagement | createSaleOrder-selectCustomerList | null | sql | { "table": "customer", "operation": "select" } | {} | 40 | insert | |||||
✅createSaleOrder-查询库存列表 | customerManagement | createSaleOrder-selectProductListByInventory | null | sql | { "table": "view01_warehouse_inventory", "operation": "select" } | {} | 41 | insert | |||||
✅createSaleOrder-添加销售订单 | customerManagement | createSaleOrder-insertItem | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } | sql | { "table": "sale_order", "operation": "insert" } | {} | 42 | insert | |||||
✅查询订单信息 | customerManagement | createSaleOrder-selectOrder | null | sql | { "table": "sale_order", "operation": "select" } | {} | 43 | insert | |||||
✅销售出库 | customerManagement | createSaleOrder-inventoryOut | null | service | { "service": "inventory", "serviceFunction": "inventoryOut" } | {} | 44 | insert | |||||
✅查销售订单 | customerManagement | selectSaleOrderList | null | sql | { "table": "sale_order", "operation": "select" } | {} | 45 | insert | |||||
✅新增销售退货订单 | customerManagement | insertSalesReturnOrder | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } | sql | { "table": "sale_return_order", "operation": "jhInsert" } | {} | 46 | insert | |||||
✅customerManagement查询-查询列表 | customerManagement | selectItemList | null | sql | { "table": "customer", "operation": "select" } | {} | 47 | insert | |||||
✅customerManagement查询-添加成员 | customerManagement | insertItem | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } | sql | { "table": "customer", "operation": "insert" } | {} | 48 | insert | |||||
✅customerManagement查询-更新成员 | customerManagement | updateItem | null | sql | { "table": "customer", "operation": "jhUpdate" } | {} | 49 | insert | |||||
✅customerManagement查询-删除信息 | customerManagement | deleteItem | null | sql | { "table": "customer", "operation": "jhDelete" } | {} | 50 | insert | |||||
✅createSaleOrder-添加销售产品价格记录 | customerManagement | createSaleOrder-insertSalesProductPriceRecord | null | sql | { "table": "sale_price_history", "operation": "jhInsert" } | {} | 819 | insert | |||||
✅createSaleOrder-查询采购产品价格记录 | customerManagement | createSaleOrder-selectPriceList | null | sql | { "table": "sale_price_history", "operation": "select" } | {} | 821 | insert |
[采购]采购订单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[采购]采购订单 | purchaseOrderManagement | showInMenu | null | 05 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅更新订单备注 | purchaseOrderManagement | viewPurchaseOrder-updateOrderRemark | null | sql | { "table": "purchase_order", "operation": "jhUpdate" } | {} | 130 | insert | |||||
✅查询列表 | purchaseOrderManagement | selectItemList | { "after": [ { "service": "purchase", "serviceFunction": "appendTicketList" } ] } | sql | { "table": "view01_purchase_order", "operation": "select" } | {} | 131 | insert | |||||
✅添加 | purchaseOrderManagement | insertItem | null | sql | { "table": "purchase_order", "operation": "insert" } | {} | 132 | insert | |||||
✅更新 | purchaseOrderManagement | updateItem | null | sql | { "table": "purchase_order", "operation": "jhUpdate" } | {} | 133 | insert | |||||
✅删除 | purchaseOrderManagement | deleteItem | null | service | { "service": "purchase", "serviceFunction": "deleteOrder" } | {} | 134 | insert | |||||
✅查询订单信息 | purchaseOrderManagement | viewPurchaseOrder-selectOrder | null | sql | { "table": "purchase_order", "operation": "select" } | {} | 135 | insert | |||||
✅更新订单状态 | purchaseOrderManagement | viewPurchaseOrder-updateOrderStatus | null | sql | { "table": "purchase_order", "operation": "jhUpdate" } | {} | 136 | insert | |||||
✅查询供货商列表 | purchaseOrderManagement | selectSupplierList | null | sql | { "table": "supplier", "operation": "select" } | {} | 137 | insert | |||||
✅查询供货商信息 | purchaseOrderManagement | viewPurchaseOrder-selectSupplier | null | sql | { "table": "supplier", "operation": "select" } | {} | 138 | insert | |||||
✅查询订单信息 | purchaseOrderManagement | inventoryInByPurchaseOrder-selectOrder | null | sql | { "table": "purchase_order", "operation": "select" } | {} | 139 | insert | |||||
✅入库 | purchaseOrderManagement | inventoryInByPurchaseOrder-inventoryIn | null | service | { "service": "inventory", "serviceFunction": "inventoryIn" } | {} | 140 | insert | |||||
✅查询供货商信息 | purchaseOrderManagement | inventoryInByPurchaseOrder-selectSupplier | null | sql | { "table": "supplier", "operation": "select" } | {} | 141 | insert | |||||
✅查询入库信息 | purchaseOrderManagement | viewInventoryInByPurchaseOrder-selectInventoryInList | null | sql | { "table": "view01_warehouse_inventory", "operation": "select" } | {} | 142 | insert | |||||
✅查询订单信息 | purchaseOrderManagement | viewInventoryInByPurchaseOrder-selectOrder | null | sql | { "table": "purchase_order", "operation": "select" } | {} | 143 | insert | |||||
✅查询供货商信息 | purchaseOrderManagement | viewInventoryInByPurchaseOrder-selectSupplier | null | sql | { "table": "supplier", "operation": "select" } | {} | 144 | insert |
[销售]销售订单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[销售]销售订单 | saleOrderManagement | showInMenu | null | 06 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询客户信息 | saleOrderManagement | inventoryOutBySaleOrder-selectCustomer | null | sql | { "table": "customer", "operation": "select" } | {} | 123 | insert | |||||
✅查询列表 | saleOrderManagement | selectItemList | { "after": [ { "service": "sale", "serviceFunction": "appendTicketList" } ] } | sql | { "table": "view01_sale_order", "operation": "select" } | {} | 180 | insert | |||||
✅添加 | saleOrderManagement | insertItem | null | sql | { "table": "sale_order", "operation": "insert" } | {} | 181 | insert | |||||
✅更新 | saleOrderManagement | updateItem | null | sql | { "table": "sale_order", "operation": "jhUpdate" } | {} | 182 | insert | |||||
✅删除 | saleOrderManagement | deleteItem | null | service | { "service": "sale", "serviceFunction": "deleteOrder" } | {} | 183 | insert | |||||
✅查询订单信息 | saleOrderManagement | viewSaleOrder-selectOrder | null | sql | { "table": "sale_order", "operation": "select" } | {} | 184 | insert | |||||
✅更新订单状态 | saleOrderManagement | viewSaleOrder-updateOrderStatus | null | sql | { "table": "sale_order", "operation": "jhUpdate" } | {} | 185 | insert | |||||
✅查询客户列表 | saleOrderManagement | selectCustomerList | null | sql | { "table": "customer", "operation": "select" } | {} | 186 | insert | |||||
✅查询客户信息 | saleOrderManagement | viewSaleOrder-selectCustomer | null | sql | { "table": "customer", "operation": "select" } | {} | 187 | insert | |||||
✅查询订单信息 | saleOrderManagement | inventoryOutBySaleOrder-selectOrder | null | sql | { "table": "sale_order", "operation": "select" } | {} | 188 | insert | |||||
✅销售出库 | saleOrderManagement | inventoryOutBySaleOrder-inventoryOut | null | service | { "service": "inventory", "serviceFunction": "inventoryOut" } | {} | 189 | insert | |||||
✅更新订单备注 | saleOrderManagement | viewSaleOrder-updateOrderRemark | null | sql | { "table": "sale_order", "operation": "jhUpdate" } | {} | 191 | insert |
[库存仓库]库存管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[库存仓库]库存管理 | warehouseInventoryManagement | showInMenu | null | 08 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询列表 | warehouseInventoryManagement | selectItemList | null | sql | { "table": "view01_warehouse_inventory", "operation": "select" } | {} | 360 | insert | |||||
✅添加 | warehouseInventoryManagement | insertItem | null | sql | { "table": "warehouse_inventory", "operation": "insert" } | {} | 361 | insert | |||||
✅更新 | warehouseInventoryManagement | updateItem | null | sql | { "table": "warehouse_inventory", "operation": "jhUpdate" } | {} | 362 | insert | |||||
✅删除 | warehouseInventoryManagement | deleteItem | null | sql | { "table": "warehouse_inventory", "operation": "jhDelete" } | {} | 363 | insert |
[库存仓库]出入库记录
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[库存仓库]出入库记录 | warehouseInventoryRecordOfProduct | showInMenu | null | 12 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
[库存仓库]出入库单【打印】
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[库存仓库]出入库单【打印】 | warehouseInventoryRecordOfOrder | showInMenu | null | 13 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
[资产仓库]资产管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[资产仓库]资产管理 | warehouseAssetManagement | showInMenu | null | 11 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询列表 | warehouseAssetManagement | selectItemList | null | sql | { "table": "warehouse_asset", "operation": "select" } | {} | 320 | insert | |||||
✅添加 | warehouseAssetManagement | insertItem | null | sql | { "table": "warehouse_asset", "operation": "insert" } | {} | 321 | insert | |||||
✅更新 | warehouseAssetManagement | updateItem | null | sql | { "table": "warehouse_asset", "operation": "jhUpdate" } | {} | 322 | insert | |||||
✅删除 | warehouseAssetManagement | deleteItem | null | sql | { "table": "warehouse_asset", "operation": "jhDelete" } | {} | 323 | insert |
[资产仓库]资产记录
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[资产仓库]资产记录 | warehouseAssetRecord | showInMenu | null | 11 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询列表 | warehouseAssetRecord | selectItemList | null | sql | { "table": "warehouse_asset_record", "operation": "select" } | {} | 340 | insert | |||||
✅添加 | warehouseAssetRecord | insertItem | null | sql | { "table": "warehouse_asset_record", "operation": "insert" } | {} | 341 | insert | |||||
✅更新 | warehouseAssetRecord | updateItem | null | sql | { "table": "warehouse_asset_record", "operation": "jhUpdate" } | {} | 342 | insert | |||||
✅删除 | warehouseAssetRecord | deleteItem | null | sql | { "table": "warehouse_asset_record", "operation": "jhDelete" } | {} | 343 | insert |
[库存仓库]申请单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[库存仓库]申请单 | warehouseTicketRequest | showInMenu | 11 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询客户列表 | warehouseTicketRequest | selectCustomerList | null | sql | { "table": "customer", "operation": "select" } | {} | 400 | insert | |||||
✅查询供货商列表 | warehouseTicketRequest | selectSupplierList | null | sql | { "table": "supplier", "operation": "select" } | {} | 401 | insert | |||||
✅查询申请单列表 | warehouseTicketRequest | selectTicketList | null | sql | { "table": "ticket", "operation": "select"} | {} | 402 | insert |
[资产仓库]申请单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[资产仓库]申请单 | assetTicketRequest | showInMenu | 12 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询客户列表 | assetTicketRequest | selectCustomerList | null | sql | { "table": "customer", "operation": "select" } | {} | 420 | insert | |||||
✅查询供货商列表 | assetTicketRequest | selectSupplierList | null | sql | { "table": "supplier", "operation": "select" } | {} | 421 | insert | |||||
✅查询申请单列表 | assetTicketRequest | selectTicketList | null | sql | { "table": "ticket", "operation": "select"} | {} | 422 | insert |
[财务收款付款]收款管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务收款付款]收款管理 | paymentOfReceipt | showInMenu | null | 21 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询列表 | paymentOfReceipt | selectItemList | null | sql | { "table": "payment", "operation": "select" } | {} | 110 | insert | |||||
✅添加 | paymentOfReceipt | insertItem | null | sql | { "table": "payment", "operation": "insert" } | {} | 111 | insert | |||||
✅更新 | paymentOfReceipt | updateItem | null | sql | { "table": "payment", "operation": "jhUpdate" } | {} | 112 | insert | |||||
✅删除 | paymentOfReceipt | deleteItem | null | sql | { "table": "payment", "operation": "jhDelete" } | {} | 113 | insert | |||||
✅查询订单列表 | paymentOfReceipt | selectPaymentOrderList | null | service | {"service": "payment", "serviceFunction": "selectPaymentOrderList"} | {} | 114 | insert |
[财务收款付款]付款管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务收款付款]付款管理 | paymentOfPay | showInMenu | null | 20 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询列表 | paymentOfPay | selectItemList | null | sql | { "table": "payment", "operation": "select" } | {} | 90 | insert | |||||
✅添加 | paymentOfPay | insertItem | null | sql | { "table": "payment", "operation": "insert" } | {} | 91 | insert | |||||
✅更新 | paymentOfPay | updateItem | null | sql | { "table": "payment", "operation": "jhUpdate" } | {} | 92 | insert | |||||
✅删除 | paymentOfPay | deleteItem | null | sql | { "table": "payment", "operation": "jhDelete" } | {} | 93 | insert | |||||
✅查询订单列表 | paymentOfPay | selectPaymentOrderList | null | service | {"service": "payment", "serviceFunction": "selectPaymentOrderList"} | {} | 94 | insert |
[财务凭证]资产价值管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务凭证]资产价值管理 | assetFinanceManagement | showInMenu | null | 25 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅资产价值管理-查询资产信息 | assetFinanceManagement | selectFinanceAsset | null | sql | { "table": "finance_asset", "operation": "select" } | {} | 20 | insert | |||||
✅资产价值管理-添加 | assetFinanceManagement | insertItem | null | sql | { "table": "finance_asset", "operation": "jhInsert" } | {} | 21 | insert | |||||
✅资产价值管理-更新 | assetFinanceManagement | updateItem | null | sql | { "table": "finance_asset", "operation": "jhUpdate" } | {} | 22 | insert | |||||
✅资产价值管理-删除 | assetFinanceManagement | deleteItem | null | sql | { "table": "finance_asset", "operation": "jhDelete" } | {} | 23 | insert | |||||
✅资产价值管理-查询资产类别 | assetFinanceManagement | selectAssetType | null | sql | { "table": "finance_asset_type", "operation": "select" } | {} | 24 | insert | |||||
✅资产价值管理-查询资产折旧明细 | assetFinanceManagement | selectFinanceAssetRecord | null | sql | {"table": "finance_asset_record", "operation": "select"} | {} | 25 | insert | |||||
✅资产价值管理-初始化折旧数据 | assetFinanceManagement | initDepreciationData | null | service | { "service": "voucher", "serviceFunction": "initDepreciationData" } | 26 | insert | ||||||
✅资产价值管理-查询资产库存 | assetFinanceManagement | selectWarehouseAsset | null | sql | { "table": "view01_warehouse_asset_not_in_finance_asset", "operation": "select" } | {} | 27 | insert | |||||
✅资产价值管理-查询会计期间 | assetFinanceManagement | selectFinancePeriod | null | sql | {"table": "view01_period_voucher", "operation": "select"} | {} | 28 | insert | |||||
✅资产价值管理-查询会计科目 | assetFinanceManagement | selectFinanceSubject | null | sql | {"table": "subject", "operation": "select"} | {} | 29 | insert | |||||
✅查询下个凭证字号 | assetFinanceManagement | selectNextVoucherNumber | null | sql | { "table": "view01_next_voucher_number", "operation": "select" } | {} | 814 | insert |
[财务收款付款]申请单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务收款付款]申请单 | paymentTicketRequest | showInMenu | 24 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询客户列表 | paymentTicketRequest | selectCustomerList | null | sql | { "table": "customer", "operation": "select" } | {} | 440 | insert | |||||
✅查询供货商列表 | paymentTicketRequest | selectSupplierList | null | sql | { "table": "supplier", "operation": "select" } | {} | 441 | insert | |||||
✅查询申请单列表 | paymentTicketRequest | selectTicketList | null | sql | { "table": "ticket", "operation": "select"} | {} | 442 | insert |
[财务凭证]凭证生成
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务凭证]凭证生成 | voucherGenerate | showInMenu | null | 27 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询列表 | voucherGenerate | selectItemList | null | sql | { "table": "view01_ticket_voucher", "operation": "select" } | {} | 300 | insert | |||||
✅添加 | voucherGenerate | insertItem | null | sql | { "table": "ticket", "operation": "insert" } | {} | 301 | insert | |||||
✅更新 | voucherGenerate | updateItem | null | sql | { "table": "ticket", "operation": "jhUpdate" } | {} | 302 | insert | |||||
✅删除 | voucherGenerate | deleteItem | null | sql | { "table": "ticket", "operation": "jhDelete" } | {} | 303 | insert | |||||
✅查询下个凭证字号 | voucherGenerate | selectNextVoucherNumber | null | sql | { "table": "view01_next_voucher_number", "operation": "select" } | {} | 304 | insert | |||||
✅生成单据凭证 | voucherGenerate | createTicketVoucher | null | service | { "service": "voucher", "serviceFunction": "createTicketVoucher" } | {} | 305 | insert | |||||
✅删除凭证 | voucherGenerate | deleteVoucher | null | sql | { "table": "voucher", "operation": "jhDelete" } | {} | 306 | insert | |||||
✅查询凭证 | voucherGenerate | selectVoucher | { "after": [ { "service": "voucher", "serviceFunction": "appendEntryList" } ] } | sql | { "table": "voucher", "operation": "select" } | {} | 307 | insert | |||||
✅生成折旧凭证 | voucherGenerate | generateDepreciationVoucher | null | service | { "service": "voucher", "serviceFunction": "generateDepreciationVoucher" } | {} | 657 | insert |
[销售]销售退货订单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[销售]销售退货订单 | salesReturnOrderManagement | showInMenu | null | 07 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询退货订单列表 | salesReturnOrderManagement | selectItemList | { "after": [ { "service": "return", "serviceFunction": "appendTicketList" } ] } | sql | { "table": "view01_sale_return_order", "operation": "select" } | {} | 210 | insert | |||||
✅查询客户列表 | salesReturnOrderManagement | selectCustomerList | null | sql | { "table": "customer", "operation": "select" } | {} | 211 | insert | |||||
✅更新退货订单 | salesReturnOrderManagement | updateReturnOrder | sql | { "table": "sale_return_order", "operation": "jhUpdate" } | {} | 212 | insert |
[采购]采购退货订单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[采购]采购退货订单 | purchaseReturnOrderManagement | showInMenu | null | 06 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询退货列表 | purchaseReturnOrderManagement | selectItemList | { "after": [ { "service": "purchase", "serviceFunction": "appendTicketListWhenReturn" } ] } | sql | { "table": "view01_purchase_return_order", "operation": "select" } | {} | 160 | insert | |||||
✅查询可退货采购列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectPurchaseList | sql | { "table": "view01_purchase_order", "operation": "select" } | {} | 161 | insert | ||||||
✅查询采购单的现有库存列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectProductListFromInventory | { "after": [ { "service": "purchase", "serviceFunction": "calcInventoryOrderCount" } ] } | sql | { "table": "view01_warehouse_inventory", "operation": "select" } | {} | 162 | insert | |||||
✅新增退货订单 | purchaseReturnOrderManagement | createPurchaseReturnOrder-insertItem | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [ { "service": "common", "serviceFunction": "generateBizIdOfAfterHook" } ] } | sql | { "table": "purchase_return_order", "operation": "insert" } | {} | 163 | insert | |||||
✅查询退货列表 | purchaseReturnOrderManagement | viewReturnOrder-selectOrder | sql | { "table": "view01_purchase_return_order", "operation": "select" } | {} | 164 | insert | ||||||
✅更新退货订单 | purchaseReturnOrderManagement | viewReturnOrder-updateOrderStatus | null | sql | { "table": "purchase_return_order", "operation": "jhUpdate" } | {} | 165 | insert | |||||
✅查询可退货采购列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectPurchaseAssetList | null | sql | { "table": "warehouse_asset", "operation": "select" } | {} | 815 | insert | |||||
✅查询资产采购单的现有库存列表 | purchaseReturnOrderManagement | createPurchaseReturnOrder-selectProductListFromAsset | { "after": [ { "service": "purchase", "serviceFunction": "calcAssetOrderCount" } ] } | sql | { "table": "warehouse_asset", "operation": "select" } | {} | 816 | insert |
采购退货单打印
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
采购退货单打印 | printPurchaseReturnOrder | seo | null | 99 | {"beforeHook": [{"service": "print", "serviceFunc": "appendPurchaseReturnInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
打印销售订单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
打印销售订单 | printSaleOrder | seo | null | 99 | {"beforeHook": [{"service": "print", "serviceFunc": "appendSaleOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
打印销售退货单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
打印销售退货单 | printSaleReturnOrder | seo | null | 99 | {"beforeHook": [{"service": "print", "serviceFunc": "appendSaleReturnOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
打印采购入库单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
打印采购入库单 | printTicketWarehouseIn | seo | null | 99 | {"beforeHook": [{"service": "print", "serviceFunc": "appendTicketWarehouseInInvoiceInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
打印入库单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
打印入库单 | printWarehouseInventoryIn | seo | null | 99 | {"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryInInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
打印入库单
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
打印入库单 | printWarehouseInventoryOut | seo | null | 99 | {"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryOutInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
用户管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
用户管理 | userManagement | showInAvatarMenu | null | 6 | null |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅用户管理-查询信息 | userManagement | selectItemList | null | sql | {"table": "_user", "operation": "select"} | 671 | update | 2022-04-29T16:33:28+08:00 | {"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651221207913_1347965", "packageType": "httpRequest"} | {"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"} | |||
✅用户管理-查询信息 | userManagement | insertItem | null | service | {"service": "userManagement", "serviceFunction": "addUser"} | 672 | update | 2022-04-28T16:36:00+08:00 | {"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"} | {"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"} | |||
✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | {"service": "userManagement", "serviceFunction": "resetUserPassword"} | 673 | update | 2022-04-28T16:37:21+08:00 | {"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"} | {"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"} | |||
✅用户管理-更新用户 | userManagement | updateItem | null | sql | {"table": "_user", "operation": "jhUpdate"} | 674 | update | 2022-04-29T16:33:27+08:00 | {"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"} |
[财务凭证]资产折旧明细表
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务凭证]资产折旧明细表 | assetRecord | showInMenu | null | 25 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅资产折旧明细-查询列表 | assetRecord | selectItemList | null | sql | { "table": "finance_asset_record", "operation": "select" } | {} | 665 | insert |
[财务凭证]资产汇总
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务凭证]资产汇总 | assetSummary | showInMenu | null | 25 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅资产汇总-查询列表 | assetSummary | selectItemList | null | service | { "service": "financePeriod", "serviceFunction": "assetSummary" } | {} | 666 | insert |
[财务凭证]资产核对总账
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务凭证]资产核对总账 | assetCheck | showInMenu | null | 25 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅资产核对总账-查询列表 | assetCheck | selectItemList | null | service | { "service": "financePeriod", "serviceFunction": "assetCheck" } | {} | 667 | insert | |||||
✅凭证明细列表 | assetCheck | selectVoucherEntryList | null | sql | { "table": "view01_voucher_entry", "operation": "select" } | 813 | insert |
[库存仓库]仓库管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[库存仓库]仓库管理 | warehouseManagement | showInMenu | null | 07 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅仓库管理-查询列表 | warehouseManagement | selectItemList | null | sql | { "table": "warehouse_stock", "operation": "select" } | {} | 797 | insert | |||||
✅仓库管理-添加 | warehouseManagement | insertItem | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } | sql | { "table": "warehouse_stock", "operation": "jhInsert" } | {} | 798 | insert | |||||
✅仓库管理-更新 | warehouseManagement | updateItem | null | sql | { "table": "warehouse_stock", "operation": "jhUpdate" } | {} | 799 | insert | |||||
✅仓库管理-删除 | warehouseManagement | deleteItem | null | sql | { "table": "warehouse_stock", "operation": "jhDelete" } | {} | 800 | insert |
[财务凭证]资产类别管理
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务凭证]资产类别管理 | assetTypeManagement | showInMenu | null | 25 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅资产类别管理-查询列表 | assetTypeManagement | selectItemList | null | sql | { "table": "finance_asset_type", "operation": "select" } | {} | 661 | insert | |||||
✅资产类别管理-添加信息 | assetTypeManagement | insertItem | { "before": [ { "service": "common", "serviceFunction": "generateBizIdOfBeforeHook" } ], "after": [] } | sql | { "table": "finance_asset_type", "operation": "insert" } | {} | 662 | insert | |||||
✅资产类别管理-更新信息 | assetTypeManagement | updateItem | null | sql | { "table": "finance_asset_type", "operation": "jhUpdate" } | {} | 663 | insert | |||||
✅资产类别管理-删除信息 | assetTypeManagement | deleteItem | null | sql | { "table": "finance_asset_type", "operation": "jhDelete" } | {} | 664 | insert |
[财务凭证]资产报废
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
[财务凭证]资产报废 | assetScrapped | showInMenu | null | 26 | {"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]} |
- 接口信息
desc | pageId | actionId | resourceHook | resourceType | resourceData | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
✅查询列表 | assetScrapped | selectItemList | null | sql | { "table": "view01_warehouse_asset_finance", "operation": "select" } | {} | 807 | insert | |||||
✅添加 | assetScrapped | insertItem | null | sql | { "table": "finance_asset", "operation": "insert" } | {} | 808 | insert | |||||
✅更新 | assetScrapped | generateScrappedVoucher | null | service | { "service": "voucher", "serviceFunction": "generateScrappedVoucher" } | 809 | insert | ||||||
✅会计期间列表 | assetScrapped | selectFinancePeriodList | null | sql | {"table": "view01_period_voucher", "operation": "select"} | {} | 810 | insert | |||||
✅资产列表 | assetScrapped | selectAssetList | null | sql | { "table": "view01_finance_asset_last", "operation": "select" } | {} | 811 | insert | |||||
✅凭证列表 | assetScrapped | selectVoucherList | null | sql | { "table": "voucher", "operation": "select" } | 812 | insert | ||||||
✅凭证明细列表 | assetScrapped | selectVoucherEntryList | null | sql | { "table": "view01_voucher_entry", "operation": "select" } | 822 | insert |
通知/待办
- 页面信息
pageName | pageId | pageType | pageFile | sort | pageHook |
---|---|---|---|---|---|
通知/待办 | https://demo.jianghujs.org/task/page/noticeManagement | showInRightMenu | null | null | null |
_page语句
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', NULL, '帮助', 'dynamicInMenu', NULL, '67', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', NULL, '登陆', '', NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'supplierManagement', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"},{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}]}', '[采购]供货商列表', 'showInMenu', NULL, '03', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'customerManagement', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]客户列表', 'showInMenu', NULL, '04', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'purchaseOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[采购]采购订单', 'showInMenu', NULL, '05', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'saleOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]销售订单', 'showInMenu', NULL, '06', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'warehouseInventoryManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]库存管理', 'showInMenu', NULL, '08', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'warehouseInventoryRecordOfProduct', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]出入库记录', 'showInMenu', NULL, '12', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'warehouseInventoryRecordOfOrder', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]出入库单【打印】', 'showInMenu', NULL, '13', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'warehouseAssetManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]资产管理', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'warehouseAssetRecord', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]资产记录', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'warehouseTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]申请单', 'showInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (68, 'assetTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]申请单', 'showInMenu', NULL, '12', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'paymentOfReceipt', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]收款管理', 'showInMenu', NULL, '21', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'paymentOfPay', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]付款管理', 'showInMenu', NULL, '20', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'assetFinanceManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产价值管理', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'paymentTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]申请单', 'showInMenu', NULL, '24', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (75, 'voucherGenerate', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]凭证生成', 'showInMenu', NULL, '27', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (80, 'salesReturnOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]销售退货订单', 'showInMenu', NULL, '07', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (81, 'purchaseReturnOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[采购]采购退货订单', 'showInMenu', NULL, '06', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (92, 'printPurchaseReturnOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendPurchaseReturnInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '采购退货单打印', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (93, 'printSaleOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendSaleOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印销售订单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (94, 'printSaleReturnOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendSaleReturnOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印销售退货单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (95, 'printTicketWarehouseIn', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendTicketWarehouseInInvoiceInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印采购入库单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (97, 'printWarehouseInventoryIn', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryInInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印入库单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (98, 'printWarehouseInventoryOut', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryOutInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印入库单', 'seo', NULL, '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (99, 'userManagement', NULL, NULL, '用户管理', 'showInAvatarMenu', NULL, '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (111, 'assetRecord', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产折旧明细表', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (112, 'assetSummary', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产汇总', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (113, 'assetCheck', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产核对总账', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (114, 'warehouseManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[库存仓库]仓库管理', 'showInMenu', NULL, '07', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (115, 'assetTypeManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产类别管理', 'showInMenu', NULL, '25', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (116, 'assetScrapped', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产报废', 'showInMenu', NULL, '26', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (158, 'https://demo.jianghujs.org/task/page/noticeManagement', NULL, NULL, '通知/待办', 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, 'insert', NULL, NULL, NULL);