页面

12114

页面总览

_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',
  `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 = 100 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	accessControlTable	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"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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

[销售]客户列表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[销售]客户列表	customerManagement			04	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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

[采购]采购订单

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[采购]采购订单	purchaseOrderManagement	showInMenu	null	05	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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	sql	{ "table": "purchase_order", "operation": "jhDelete" }		{}	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": "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		null	06	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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	sql	{ "table": "sale_order", "operation": "jhDelete" }		{}	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	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	warehouseInventoryManagement	selectItemList	null	sql	{ "table": "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	accessControlTable	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	12	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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	accessControlTable	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		11	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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	accessControlTable	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	accessControlTable	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	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	assetFinanceManagement	selectItemList	null	sql	{ "table": "view01_finance_asset_info", "operation": "select" }		{}	20	insert
✅添加	assetFinanceManagement	insertItem	null	sql	{ "table": "finance_asset", "operation": "insert" }		{}	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	initDepreciationData	null	service	{ "service": "voucher", "serviceFunction": "initDepreciationData" }			659	insert

[财务收款付款]工单【收/付款】

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[财务收款付款]工单【收/付款】	paymentTicketRequest	showInMenu		24	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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	accessControlTable	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		null	07	{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	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	accessControlTable	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-selectProductListFromAsset	{ "after": [ { "service": "purchase", "serviceFunction": "calcAssetOrderCount" } ] }	sql	{ "table": "warehouse_asset", "operation": "select" }		{}	798	insert
✅查询可退货采购列表	purchaseReturnOrderManagement	createPurchaseReturnOrder-selectPurchaseAssetList	null	sql	{ "table": "warehouse_asset", "operation": "select" }		{}	799	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
打印退货出库单	printTicketWarehouseOut	seo	null	99	{"beforeHook": [{"service": "print", "serviceFunc": "appendTicketWarehouseOutInvoiceInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}

_page语句

INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', NULL, '帮助', 'dynamicInMenu', '67', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', NULL, '登陆', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'supplierManagement', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[采购]供货商列表', 'showInMenu', '03', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'customerManagement', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]客户列表', '', '04', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'purchaseOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[采购]采购订单', 'showInMenu', '05', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'saleOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '申领/归还', '', '06', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'warehouseInventoryManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[商品仓库]库存', 'showInMenu', '08', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'warehouseInventoryRecordOfProduct', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[商品仓库]商品记录', 'showInMenu', '12', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'warehouseInventoryRecordOfOrder', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[商品仓库]出/入库单【打印】', 'showInMenu', '13', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'warehouseAssetManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]库存', 'showInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'warehouseAssetRecord', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]资产记录', 'showInMenu', '12', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'warehouseTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[商品仓库]申请单', 'showInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (68, 'assetTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[资产仓库]申请单', 'showInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'paymentOfReceipt', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]收款管理', 'showInMenu', '21', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'paymentOfPay', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]付款管理', 'showInMenu', '20', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'assetFinanceManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]资产价值管理', 'showInMenu', '25', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'paymentTicketRequest', '', '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务收款付款]工单【收/付款】', 'showInMenu', '24', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (75, 'voucherGenerate', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[财务凭证]凭证生成', 'showInMenu', '27', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (80, 'salesReturnOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[销售]销售退货单', '', '07', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (81, 'purchaseReturnOrderManagement', NULL, '{"beforeHook": [{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '[采购]采购退货单', 'showInMenu', '06', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (92, 'printPurchaseReturnOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendPurchaseReturnInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '采购退货单打印', 'seo', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (93, 'printSaleOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendSaleOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印销售订单', 'seo', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (94, 'printSaleReturnOrder', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendSaleReturnOrderInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印销售退货单', 'seo', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (95, 'printTicketWarehouseIn', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendTicketWarehouseInInvoiceInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印采购入库单', 'seo', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (97, 'printWarehouseInventoryIn', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryInInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印入库单', 'seo', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (98, 'printWarehouseInventoryOut', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendWarehouseInventoryOutInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印出库单', 'seo', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageHook, pageName, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (99, 'printTicketWarehouseOut', NULL, '{"beforeHook": [{"service": "print", "serviceFunc": "appendTicketWarehouseOutInvoiceInfoPageBeforeHook", "field": "chunkObjList"},{"service": "constant", "serviceFunc": "getConstantObj", "field": "constantObj"}]}', '打印退货出库单', 'seo', '99', 'insert', NULL, NULL, NULL);