背景
在途库存显示，功能更新后部分历史数据需同步进行处理；
需求
按下列范围搜索数据进行处理；
1、备库订单
2、本地--海外仓
3、有入库单、已发货、订单状态正常
4、时间范围大于等于2022年8月1日
根据海外仓入库单号查询云仓接口，返回入库类型和入库方式，回写ERP表RB_OrderInfo_BeikuExpand：--DeliveryType--StorageModels
| 所属迭代 | 技术研发中心 2月分支版本（2023年） |
|---|---|
| 所属模块 | / |
| 相关需求 | 历史备库订单在途库存修改（无需发版） |
| 指派给 | Closed 于 2023-04-12 11:26:03 |
| 任务类型 | 后端 |
| 任务标签 | 初始 |
| 开发组 | |
| 任务状态 | 已关闭 |
| 进度 | 100% |
| 优先级 | P2 |
| 关键词 | |
| 抄送给 |
| 由谁创建 | 程伟 于 2023-02-07 09:39:02 |
|---|---|
| 由谁完成 | 鞠智明 于 2023-02-07 18:23:02 |
| 由谁取消 | 暂无 |
| 由谁关闭 | 鞠智明 于 2023-04-12 11:26:03 |
| 关闭原因 | 已完成 |
| 最后编辑 | 鞠智明 于 2023-04-12 11:26:03 |
| 团队 | 最初预计 | 总计消耗 | 预计剩余 |
|---|
| 最初预计 | 3工时 |
|---|---|
| 总计消耗 | 3工时 |
| 预计剩余 | 0工时 |
| 预计开始 | 0000-00-00 |
| 实际开始 | 2023-02-07 |
| 截止日期 | 0000-00-00 |
开发报告
1.根据条件查询erp对应的订单数据
SELECT pop.ID,
pop.CustomerID,
pop.MergerPackageNo,
pop.StockOrderNumber
FROM dbo.RB_Procurement_Order_Package (NOLOCK) pop
LEFT JOIN dbo.RB_OrderInfo (NOLOCK) oi
ON oi.CustomerID = pop.CustomerID
AND pop.MergerPackageNo = oi.OrderCode
LEFT JOIN dbo.RB_OrderInfo_BeikuExpand (NOLOCK) expand
ON expand.CustomerID = oi.CustomerID
AND expand.OrderCode = oi.OrderCode
LEFT JOIN dbo.RB_WareHouse (NOLOCK) wh
ON wh.CustomerID = oi.CustomerID
AND oi.WareHouseID = wh.ID
LEFT JOIN dbo.RB_WareHouse (NOLOCK) towh
ON towh.CustomerID = oi.CustomerID
AND oi.ToWareHouseID = towh.ID
WHERE oi.CustomerID = 1
AND pop.IsStockOrderWithPackage = 1
AND expand.OrderBuildType = 3
--AND oi.OrderState = 2
AND wh.WareHouseType = 1
AND towh.WareHouseType = 60
AND ISNULL(pop.StockOrderNumber,'')<>''
AND oi.AddTime >= '2022-08-01'
AND oi.AddTime < '2022-12-30'
查询出入库单号，去查询海外仓的订单把类型和入库方式查询出来SELECT StorageOrderCode,DeliveryTypeId ,DeliveryTypeName ,StorageModeId ,StorageModeName
from inv_storageorder where storageOrderCode in('RO670ABLX','RO670AAQP','RO670AATF','RO670AB0H','RO670AB0J','RO670ABJV','RO600A9YW','RO600AL30','RO790AL48','RO600ALBX','RO600ALBW','RO600ALC3','RO600ALC4','RO600ALNU','RO670A586','RO670A58C','RO670A4GG','RO670A7LF','RO670A66Y','RO670A60W','RO670A6U0','RO600AB42','RO600AB44','RO600AAL6','RO670ACEM','RO670ADK9','RO600AKFJ','RO600AKFH','RO670A083','RO670A0L3','RO670A0L4','RO3220AD34','RO3220ADP6','RO3220ADPK','RO3220AD36','RO3220ADPM','RO3220ADPN','RO3220ADPN','RO3220AD37','RO3220AD38','RO3220AD39','RO3220ADPP','RO3220AD8B','RO3220AD8C','RO3220ADPT','RO3220AD8E','RO3220AD8F','RO3220AD8G','RO3220ADB4','RO3220ADB5','RO3220ADB6','RO3220ADPW','RO3220ADPY','RO3220AD35','RO3220AD3A','RO3220ADQ0','RO3220ADPU','RO3220ADPV','RO3220AE3G','RO3220AE68','RO3220AD3A','RO3220AE3G','RO3220AE68','RO3220AFJE','RO600AE23','RO600AD2L','RO600ANC5','RO670AGJB','RO670AP65','RO600A6LH','RO600ACHL','RO670AHB4','RO600AH55','RO600AHBB','RO670ALT8','RO670AM48','RO600AM82','RO600AMCT','RO600AMDC','RO600A6XJ','RO600A6XG','RO670A976','RO670A977','RO600A7FH','RO600AJR7','RO600AJQU','RO600AJXJ','RO600AJXH','RO600AJXG','RO600AJXF','RO600AJTL','RO600AJWX','RO6709YW4','RO6709YUN','RO6709YUN','RO6709YUN','RO6709YUN','RO6709YUN','RO670A0DW','RO6709XBM','RO670AAQH','RO670A66U','RO670A66V','RO6709WJL','RO6709WJK','RO6709X7N','RO670A48D','RO670A6AH','RO600AFJD','RO600A3J9','RO600A3K9','RO600A3K8','RO600A3K7','RO600A3K4','RO670AP66','RO600A546','RO600A41V','RO600A41U','RO600A41T','RO600A41R','RO600A41Q','RO670A66W','RO670A613','RO600A42P','RO670AGJD','RO600AFEQ','RO600AFA5','RO600AFA2','RO600AGUP','RO670A9JJ','RO600A860','RO670A61H','RO600A5AJ','RO600A5AG','RO600A5AE','RO670A6TX','RO600A5YB','RO670A6TY','RO670A7R1','RO670AB47','RO600A5Y9','RO600A5Y7','RO600A5Y6','RO600A5YA','RO600A5Y8','RO670AP62','RO670A9JX','RO600A5KW','RO670ABM0','RO600AMDD','RO670AMVF','RO600ANC6','RO600AMQ6','RO600AMH8','RO600AMHA','RO600AMH9')
操作更新