页面

12076

页面总览

_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);