变更记录:
跟梁贵荣确认参数,需增加一些参数,见下方原型
增加分页
调整为先聚合成另一种报告,再把此报告通过本次开发的API同步给ERP
需求内容:
新增查询仓租费用明细API
聚合汇总仓租,参考SQL:
SELECT
e.`WarehouseChargeCode`,
e.`CustomerCode`,
e.`WarehouseId`,
e.`WarehouseName`,
e.`StorageModeId`,
e.`StorageModeName`,
e.`ItemCode`,
e.`MultiCode`,
e.`ChargingDate`,
e.`PutawayDate`,
e.`ChargingDay`,
e.`CurrencyId`,
e.`CurrencyName`,
sum( e.ChargingAmount ),
sum( e.ProductNumber )
FROM
(
SELECT
`WarehouseChargeCode`,
`CustomerCode`,
`WarehouseId`,
`WarehouseName`,
`StorageModeId`,
`StorageModeName`,
`OrderCode`,
`ItemCode`,
`MultiCode`,
`ChargingDate`,
`PutawayDate`,
`ChargingDay`,
`UnitPrice`,
`CurrencyId`,
`CurrencyName`,
`ChargingAmount`,
`ProductNumber`,
`ChargingVolume`,
`QuotationCode`
FROM
`fee_warehousechargecount`
WHERE
chargingdate >= 20220417
AND chargingdate < 20220418
AND customercode IN ( '000060', '000079', '000067', '000021', '000288' )
and ChargingAmount > 0
) AS e
GROUP BY
e.`WarehouseChargeCode`,
e.`CustomerCode`,
e.`WarehouseId`,
e.`StorageModeId`,
e.`ItemCode`,
e.`MultiCode`,
e.`ChargingDate`,
e.`ChargingDay`,
e.`CurrencyId`;
查询逻辑:
按月查询,支持查询当前的仓储费用明细
箱和箱产品,需返回装箱产品清单
详细字段见下方原型图
