变更记录:
跟梁贵荣确认参数,需增加一些参数,见下方原型
需求内容:
新增查询仓租费用明细API
查询逻辑:
按月查询,支持查询当前的仓储费用明细
箱和箱产品,需返回装箱产品清单
详细字段见下方原型图

变更记录:
跟梁贵荣确认参数,需增加一些参数,见下方原型
需求内容:
新增查询仓租费用明细API
查询逻辑:
按月查询,支持查询当前的仓储费用明细
箱和箱产品,需返回装箱产品清单
详细字段见下方原型图

001-
001+
002+
001-
001+ <p><img src="{192004.png}" alt="" /></p>
002+ <p><br /></p>
001-
001+ 时间:自定义
002-
002+
003+
004+
001-<p><img src="{192004.png}" alt="" /></p>
001+ <p>时间:自定义</p>
002-<p><br /></p>
002+ <p><br /></p>
003+ <p><img src="{192004.png}" alt="" /></p>
004+ <p><br /></p>
001-时间:自定义
001+
003-
003+
004-
001-<p>时间:自定义</p>
001+ <p><br /></p>
003-<p><img src="{192004.png}" alt="" /></p>
003+ <p><img src="{192364.png}" alt="" /></p>
004-<p><br /></p>
001-
001+ 变更记录:
002-
002+ 跟梁贵荣确认参数,需增加一些参数,见下方原型
003-
003+
004+ 需求内容:
005+ 新增查询仓租费用明细API
006+
007+ 查询逻辑:
008+ 按月查询,支持查询当前的仓储费用明细
009+ 箱和箱产品,需返回装箱产品清单
010+ 详细字段见下方原型图
011+
012+
001-<p><br /></p>
001+ <p>变更记录:</p>
002-<p><br /></p>
002+ <p>跟梁贵荣确认参数,需增加一些参数,见下方原型</p>
003-<p><img src="{192364.png}" alt="" /></p>
003+ <p><br /></p>
004+ <p>需求内容:</p>
005+ <p>新增查询仓租费用明细API</p>
006+ <p><br /></p>
007+ <p>查询逻辑:</p>
008+ <p>按月查询,支持查询当前的仓储费用明细</p>
009+ <p>箱和箱产品,需返回装箱产品清单</p>
010+ <p>详细字段见下方原型图</p>
011+ <p><br /></p>
012+ <p><img src="{192364.png}" alt="" /></p>
003-
003+ 增加分页
004-需求内容:
004+
005-新增查询仓租费用明细API
005+ 需求内容:
006-
006+ 新增查询仓租费用明细API
007-查询逻辑:
007+
008-按月查询,支持查询当前的仓储费用明细
008+ 查询逻辑:
009-箱和箱产品,需返回装箱产品清单
009+ 按月查询,支持查询当前的仓储费用明细
010-详细字段见下方原型图
010+ 箱和箱产品,需返回装箱产品清单
011-
011+ 详细字段见下方原型图
012-
012+
013+
003-<p><br /></p>
003+ <p>增加分页</p>
004-<p>需求内容:</p>
004+ <p><br /></p>
005-<p>新增查询仓租费用明细API</p>
005+ <p>需求内容:</p>
006-<p><br /></p>
006+ <p>新增查询仓租费用明细API</p>
007-<p>查询逻辑:</p>
007+ <p><br /></p>
008-<p>按月查询,支持查询当前的仓储费用明细</p>
008+ <p>查询逻辑:</p>
009-<p>箱和箱产品,需返回装箱产品清单</p>
009+ <p>按月查询,支持查询当前的仓储费用明细</p>
010-<p>详细字段见下方原型图</p>
010+ <p>箱和箱产品,需返回装箱产品清单</p>
011-<p><br /></p>
011+ <p>详细字段见下方原型图</p>
012-<p><img src="{192364.png}" alt="" /></p>
012+ <p><br /></p>
013+ <p><img src="{192860.png}" alt="" /></p>
004-
004+ 调整为先聚合成另一种报告,再把此报告通过本次开发的API同步给ERP
005-需求内容:
005+
006-新增查询仓租费用明细API
006+ 需求内容:
007-
007+ 新增查询仓租费用明细API
008-查询逻辑:
008+
009-按月查询,支持查询当前的仓储费用明细
009+ 查询逻辑:
010-箱和箱产品,需返回装箱产品清单
010+ 按月查询,支持查询当前的仓储费用明细
011-详细字段见下方原型图
011+ 箱和箱产品,需返回装箱产品清单
012-
012+ 详细字段见下方原型图
013-
013+
014+ <a href="http://192.168.200.206:8030/%E6%B5%B7%E5%A4%96%E4%BB%93/2022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%E6%9C%AC/#g=1&p=%E4%BB%93%E5%82%A8%E8%B4%B9-%E8%B4%B9%E7%94%A8%E6%98%8E%E7%BB%86%E5%88%97%E8%A1%A8%EF%BC%882022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%EF%BC%89">仓储费-费用明细列表(2022年4月第二版)
015+
004-<p><br /></p>
004+ <p>调整为先聚合成另一种报告,再把此报告通过本次开发的API同步给ERP</p>
005-<p>需求内容:</p>
005+ <p><br /></p>
006-<p>新增查询仓租费用明细API</p>
006+ <p>需求内容:</p>
007-<p><br /></p>
007+ <p>新增查询仓租费用明细API</p>
008-<p>查询逻辑:</p>
008+ <p><br /></p>
009-<p>按月查询,支持查询当前的仓储费用明细</p>
009+ <p>查询逻辑:</p>
010-<p>箱和箱产品,需返回装箱产品清单</p>
010+ <p>按月查询,支持查询当前的仓储费用明细</p>
011-<p>详细字段见下方原型图</p>
011+ <p>箱和箱产品,需返回装箱产品清单</p>
012-<p><br /></p>
012+ <p>详细字段见下方原型图</p>
013-<p><img src="{192860.png}" alt="" /></p>
013+ <p><br /></p>
014+ <p><a href="http://192.168.200.206:8030/%E6%B5%B7%E5%A4%96%E4%BB%93/2022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%E6%9C%AC/#g=1&p=%E4%BB%93%E5%82%A8%E8%B4%B9-%E8%B4%B9%E7%94%A8%E6%98%8E%E7%BB%86%E5%88%97%E8%A1%A8%EF%BC%882022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%EF%BC%89">仓储费-费用明细列表(2022年4月第二版)</a></p>
015+ <p><img src="{193914.png}" alt="" /></p>
009-查询逻辑:
009+ 聚合汇总仓租,参考SQL:
010-按月查询,支持查询当前的仓储费用明细
010+ 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 DISTINCT `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 eGROUP BY e.`WarehouseChargeCode`, e.`CustomerCode`, e.`WarehouseId`, e.`StorageModeId`, e.`ItemCode`, e.`MultiCode`, e.`ChargingDate`, e.`ChargingDay`, e.`CurrencyId`;
011-箱和箱产品,需返回装箱产品清单
011+
012-详细字段见下方原型图
012+ 查询逻辑:
013-
013+ 按月查询,支持查询当前的仓储费用明细
014-<a href="http://192.168.200.206:8030/%E6%B5%B7%E5%A4%96%E4%BB%93/2022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%E6%9C%AC/#g=1&p=%E4%BB%93%E5%82%A8%E8%B4%B9-%E8%B4%B9%E7%94%A8%E6%98%8E%E7%BB%86%E5%88%97%E8%A1%A8%EF%BC%882022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%EF%BC%89">仓储费-费用明细列表(2022年4月第二版)
014+ 箱和箱产品,需返回装箱产品清单
015-
015+ 详细字段见下方原型图
016+
017+ <a href="http://192.168.200.206:8030/%E6%B5%B7%E5%A4%96%E4%BB%93/2022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%E6%9C%AC/#g=1&p=%E4%BB%93%E5%82%A8%E8%B4%B9-%E8%B4%B9%E7%94%A8%E6%98%8E%E7%BB%86%E5%88%97%E8%A1%A8%EF%BC%882022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%EF%BC%89">仓储费-费用明细列表(2022年4月第二版)
018+
009-<p>查询逻辑:</p>
009+ <p>聚合汇总仓租,参考SQL:</p>
010-<p>按月查询,支持查询当前的仓储费用明细</p>
010+ <p>SELECT<br /><span> </span>e.`WarehouseChargeCode`,<br /><span> </span>e.`CustomerCode`,<br /><span> </span>e.`WarehouseId`,<br /><span> </span>e.`WarehouseName`,<br /><span> </span>e.`StorageModeId`,<br /><span> </span>e.`StorageModeName`,<br /><span> </span>e.`ItemCode`,<br /><span> </span>e.`MultiCode`,<br /><span> </span>e.`ChargingDate`,<br /><span> </span>e.`PutawayDate`,<br /><span> </span>e.`ChargingDay`,<br /><span> </span>e.`CurrencyId`,<br /><span> </span>e.`CurrencyName`,<br /><span> </span>sum( e.ChargingAmount ),<br /><span> </span>sum( e.ProductNumber )<br />FROM<br /><span> </span>(<br />SELECT DISTINCT<br /><span> </span>`WarehouseChargeCode`,<br /><span> </span>`CustomerCode`,<br /><span> </span>`WarehouseId`,<br /><span> </span>`WarehouseName`,<br /><span> </span>`StorageModeId`,<br /><span> </span>`StorageModeName`,<br /><span> </span>`OrderCode`,<br /><span> </span>`ItemCode`,<br /><span> </span>`MultiCode`,<br /><span> </span>`ChargingDate`,<br /><span> </span>`PutawayDate`,<br /><span> </span>`ChargingDay`,<br /><span> </span>`UnitPrice`,<br /><span> </span>`CurrencyId`,<br /><span> </span>`CurrencyName`,<br /><span> </span>`ChargingAmount`,<br /><span> </span>`ProductNumber`,<br /><span> </span>`ChargingVolume`,<br /><span> </span>`QuotationCode`<br />FROM<br /><span> </span>`fee_warehousechargecount`<br />WHERE<br /><span> </span>chargingdate >= 20220417<br /><span> </span>AND chargingdate < 20220418<br /><span> </span>AND customercode IN ( '000060', '000079', '000067', '000021', '000288' )<br /><span> </span>and ChargingAmount > 0<br /><span> </span>) AS e<br />GROUP BY<br /><span> </span>e.`WarehouseChargeCode`,<br /><span> </span>e.`CustomerCode`,<br /><span> </span>e.`WarehouseId`,<br /><span> </span>e.`StorageModeId`,<br /><span> </span>e.`ItemCode`,<br /><span> </span>e.`MultiCode`,<br /><span> </span>e.`ChargingDate`,<br /><span> </span>e.`ChargingDay`,<br /><span> </span>e.`CurrencyId`;<br /></p>
011-<p>箱和箱产品,需返回装箱产品清单</p>
011+ <p><br /></p>
012-<p>详细字段见下方原型图</p>
012+ <p>查询逻辑:</p>
013-<p><br /></p>
013+ <p>按月查询,支持查询当前的仓储费用明细</p>
014-<p><a href="http://192.168.200.206:8030/%E6%B5%B7%E5%A4%96%E4%BB%93/2022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%E6%9C%AC/#g=1&p=%E4%BB%93%E5%82%A8%E8%B4%B9-%E8%B4%B9%E7%94%A8%E6%98%8E%E7%BB%86%E5%88%97%E8%A1%A8%EF%BC%882022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%EF%BC%89">仓储费-费用明细列表(2022年4月第二版)</a></p>
014+ <p>箱和箱产品,需返回装箱产品清单</p>
015-<p><img src="{193914.png}" alt="" /></p>
015+ <p>详细字段见下方原型图</p>
016+ <p><br /></p>
017+ <p><a href="http://192.168.200.206:8030/%E6%B5%B7%E5%A4%96%E4%BB%93/2022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%E6%9C%AC/#g=1&p=%E4%BB%93%E5%82%A8%E8%B4%B9-%E8%B4%B9%E7%94%A8%E6%98%8E%E7%BB%86%E5%88%97%E8%A1%A8%EF%BC%882022%E5%B9%B44%E6%9C%88%E7%AC%AC%E4%BA%8C%E7%89%88%EF%BC%89">仓储费-费用明细列表(2022年4月第二版)</a></p>
018+ <p><img src="{193914.png}" alt="" /></p>
010-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 DISTINCT `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 eGROUP BY e.`WarehouseChargeCode`, e.`CustomerCode`, e.`WarehouseId`, e.`StorageModeId`, e.`ItemCode`, e.`MultiCode`, e.`ChargingDate`, e.`ChargingDay`, e.`CurrencyId`;
010+ 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 eGROUP BY e.`WarehouseChargeCode`, e.`CustomerCode`, e.`WarehouseId`, e.`StorageModeId`, e.`ItemCode`, e.`MultiCode`, e.`ChargingDate`, e.`ChargingDay`, e.`CurrencyId`;
010-<p>SELECT<br /><span> </span>e.`WarehouseChargeCode`,<br /><span> </span>e.`CustomerCode`,<br /><span> </span>e.`WarehouseId`,<br /><span> </span>e.`WarehouseName`,<br /><span> </span>e.`StorageModeId`,<br /><span> </span>e.`StorageModeName`,<br /><span> </span>e.`ItemCode`,<br /><span> </span>e.`MultiCode`,<br /><span> </span>e.`ChargingDate`,<br /><span> </span>e.`PutawayDate`,<br /><span> </span>e.`ChargingDay`,<br /><span> </span>e.`CurrencyId`,<br /><span> </span>e.`CurrencyName`,<br /><span> </span>sum( e.ChargingAmount ),<br /><span> </span>sum( e.ProductNumber )<br />FROM<br /><span> </span>(<br />SELECT DISTINCT<br /><span> </span>`WarehouseChargeCode`,<br /><span> </span>`CustomerCode`,<br /><span> </span>`WarehouseId`,<br /><span> </span>`WarehouseName`,<br /><span> </span>`StorageModeId`,<br /><span> </span>`StorageModeName`,<br /><span> </span>`OrderCode`,<br /><span> </span>`ItemCode`,<br /><span> </span>`MultiCode`,<br /><span> </span>`ChargingDate`,<br /><span> </span>`PutawayDate`,<br /><span> </span>`ChargingDay`,<br /><span> </span>`UnitPrice`,<br /><span> </span>`CurrencyId`,<br /><span> </span>`CurrencyName`,<br /><span> </span>`ChargingAmount`,<br /><span> </span>`ProductNumber`,<br /><span> </span>`ChargingVolume`,<br /><span> </span>`QuotationCode`<br />FROM<br /><span> </span>`fee_warehousechargecount`<br />WHERE<br /><span> </span>chargingdate >= 20220417<br /><span> </span>AND chargingdate < 20220418<br /><span> </span>AND customercode IN ( '000060', '000079', '000067', '000021', '000288' )<br /><span> </span>and ChargingAmount > 0<br /><span> </span>) AS e<br />GROUP BY<br /><span> </span>e.`WarehouseChargeCode`,<br /><span> </span>e.`CustomerCode`,<br /><span> </span>e.`WarehouseId`,<br /><span> </span>e.`StorageModeId`,<br /><span> </span>e.`ItemCode`,<br /><span> </span>e.`MultiCode`,<br /><span> </span>e.`ChargingDate`,<br /><span> </span>e.`ChargingDay`,<br /><span> </span>e.`CurrencyId`;<br /></p>
010+ <p>SELECT<br /><span> </span>e.`WarehouseChargeCode`,<br /><span> </span>e.`CustomerCode`,<br /><span> </span>e.`WarehouseId`,<br /><span> </span>e.`WarehouseName`,<br /><span> </span>e.`StorageModeId`,<br /><span> </span>e.`StorageModeName`,<br /><span> </span>e.`ItemCode`,<br /><span> </span>e.`MultiCode`,<br /><span> </span>e.`ChargingDate`,<br /><span> </span>e.`PutawayDate`,<br /><span> </span>e.`ChargingDay`,<br /><span> </span>e.`CurrencyId`,<br /><span> </span>e.`CurrencyName`,<br /><span> </span>sum( e.ChargingAmount ),<br /><span> </span>sum( e.ProductNumber )<br />FROM<br /><span> </span>(<br />SELECT<br /><span> </span>`WarehouseChargeCode`,<br /><span> </span>`CustomerCode`,<br /><span> </span>`WarehouseId`,<br /><span> </span>`WarehouseName`,<br /><span> </span>`StorageModeId`,<br /><span> </span>`StorageModeName`,<br /><span> </span>`OrderCode`,<br /><span> </span>`ItemCode`,<br /><span> </span>`MultiCode`,<br /><span> </span>`ChargingDate`,<br /><span> </span>`PutawayDate`,<br /><span> </span>`ChargingDay`,<br /><span> </span>`UnitPrice`,<br /><span> </span>`CurrencyId`,<br /><span> </span>`CurrencyName`,<br /><span> </span>`ChargingAmount`,<br /><span> </span>`ProductNumber`,<br /><span> </span>`ChargingVolume`,<br /><span> </span>`QuotationCode`<br />FROM<br /><span> </span>`fee_warehousechargecount`<br />WHERE<br /><span> </span>chargingdate >= 20220417<br /><span> </span>AND chargingdate < 20220418<br /><span> </span>AND customercode IN ( '000060', '000079', '000067', '000021', '000288' )<br /><span> </span>and ChargingAmount > 0<br /><span> </span>) AS e<br />GROUP BY<br /><span> </span>e.`WarehouseChargeCode`,<br /><span> </span>e.`CustomerCode`,<br /><span> </span>e.`WarehouseId`,<br /><span> </span>e.`StorageModeId`,<br /><span> </span>e.`ItemCode`,<br /><span> </span>e.`MultiCode`,<br /><span> </span>e.`ChargingDate`,<br /><span> </span>e.`ChargingDay`,<br /><span> </span>e.`CurrencyId`;</p>
018-
018+
018-<p><img src="{193914.png}" alt="" /></p>
018+ <p><img src="{201217.png}" alt="" /></p>
| 提报业务部门 | |
|---|---|
| 提报人员 | 会计部-林昔贤 |
| 需求来源 | 业务方迭代需求 |
| 所属模块 | 供应链 仓储物流 |
| 所属计划 |
|
| 开发组 | |
| 受益业务部门 | 财务管理中心 |
| 验收人员 | |
| 业务价值 | 控制风险 |
| 每月价值量 | 32人天/月 |
| 每月节省人数 | 0 |
| 优先级 | P2 |
| 价值类型 | |
| 预计工时 | 12 |
| 成本 | |
| ROI | |
| 操作手册 | |
| 更新点 | |
| 是否高危 | 否 |
| 评分 | |
| 当前状态 | 已关闭 |
| 所处阶段 | 已关闭 |
| 关键词 | 计划 5月20日发版 5月1版本迁移分支 |
| 计划上线 | |
| 上线时间 | |
| 计划验收时间 | |
| 业务验收时间 | |
| 满意度 | |
| 价值验收 | |
| 满意度分值 | |
| 业务回填价值 | |
| 验收达成价值 | |
| 验收达成ROI |
| 由谁创建 | zhangcheng 于 2022-03-21 13:45:25 |
|---|---|
| 指派给 | Closed 于 2022-06-10 09:20:38 |
| 由谁评审 | 刘灿 |
| 评审时间 | 2022-06-01 |
| 由谁关闭 | zhengqiao 于 2022-06-10 09:20:38 |
| 关闭原因 | 已完成 |
| 最后修改 | zhengqiao 于 2022-09-26 14:15:42 |