TASK#22371 帮忙导一下11月份截至到今天的产品库存换标单和中转订单和入库单数据（表格中的字段） / 【主干】产品中心12月第二个版本（2021年）

任务描述

- 东霞（dongxia)
  
  客服小仙女
- 帮忙导一下11月份截至到今天的产品库存换标单和中转订单和入库单数据（表格中的字段）

需求描述

系统框架升级合并oms wms库
解决由于网络引发同步数据不一致问题，解决多方并发修改同表同字段后的同步问题
升级netcore 提升产品整体能力

验收标准

系统框架升级合并oms wms库解决由于网络引发同步数据不一致问题，解决多方并发修改同表同字段后的同步问题升级netcore 提升产品整体能力说明： 1. 框架升级预计2022-1-5发布上线由于迭代内容比较久，迭代周期较长，期间部分完成的功能没有办法部分上线

历史记录

2021-11-15 15:40:04, 由 pengbin 创建。
2021-11-15 17:17:45, 由 husikai 完成。
修改了 总计消耗，旧值为 "0"，新值为 "2"。
修改了 指派给 ，旧值为 "husikai"，新值为 "pengbin"。
修改了 实际完成，旧值为 ""，新值为 "2021-11-15 16:36:14"。
修改了 任务状态，旧值为 "wait"，新值为 "done"。
修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2021-11-15 17:17:45"。
修改了 预计剩余，旧值为 "3"，新值为 "0"。
修改了 由谁完成，旧值为 ""，新值为 "husikai"。

#产品库存换标

select
a.CustomerCode as '客户编号',
a.ChangeLabelOrder as '单号',
a.WarehouseId as '仓库',
a.IsRebrandService as '是否换标',
b.CartonNo as '箱号',
b.CartonCode as '箱条码',
b.ProductSkuNumber as 'SKU数量',
b.DeliveryChannelSourceName as '新账号',
b.CartonWeight as '箱重(kg)',
b.CartonLength as '箱长(cm)',
b.CartonWidth as '箱宽(cm)',
b.CartonHeight as '箱高(cm)',
c.OldMappingProductBarCode as '旧条码',
c.NewMappingProductBarCode as '新条码',
c.ProductName as '产品名称',
c.ProductNumber as '已处理数量',
a.CreationTime as '创建时间',
a.SubmitTime as '提交时间',
a.LastModificationTime as '完成时间',
a.Status as '状态',
a.Description as '备注'
from p_changelabelorder a
left join p_changelabelpackingproductcarton b on a.ChangeLabelOrder=b.ChangeLabelOrder
left join p_changelabelpackingproduct c on a.ChangeLabelOrder=b.ChangeLabelOrder
where
a.CreationTime>'2021-11-01 00:00:00'
and a.ChangeLabelType=1
and a.Status=3

#换标单

select
a.CustomerCode as '客户编号',
a.ChangeLabelOrder as '单号',
a.WarehouseId as '仓库',
a.IsRebrandService as '是否换标',
b.CartonNo as '箱号',
b.CartonCode as '箱条码',
b.ProductSkuNumber as 'SKU数量',
b.DeliveryChannelSourceName as '新账号',
b.CartonWeight as '箱重(kg)',
b.CartonLength as '箱长(cm)',
b.CartonWidth as '箱宽(cm)',
b.CartonHeight as '箱高(cm)',
c.OldMappingProductBarCode as '旧条码',
c.NewMappingProductBarCode as '新条码',
c.ProductName as '产品名称',
c.ProductNumber as '已处理数量',
a.CreationTime as '创建时间',
a.SubmitTime as '提交时间',
a.LastModificationTime as '完成时间',
a.Status as '状态',
a.Description as '备注'
from p_changelabelorder a
left join p_changelabelpackingproductcarton b on a.ChangeLabelOrder=b.ChangeLabelOrder
left join p_changelabelpackingproduct c on b.ChangeLabelOrder=c.ChangeLabelOrder
where
a.CreationTime>'2021-11-01 00:00:00'
and a.ChangeLabelType=1
and a.Status=3
2021-11-16 11:03:22, 由 husikai 编辑。
修改了 任务描述，区别为：
008-
008+
009- ~~客服小仙女~~
009+ 客服小仙女
010-
010+

008- ~~<div class="msg-group-info" style="margin:0px 0px 3px;padding:0px;"><span class="msg-group-info-name">~~
008+ <div class="msg-group-info" style="margin:0px 0px 3px;padding:0px;"><span class="msg-group-info-name"> </span>
009- ~~</span><div class="profile-name-wrapper" style="margin:0px;padding:0px;">客服小仙女</div>~~
009+ <div class="profile-name-wrapper" style="margin:0px;padding:0px;">客服小仙女</div>
010- ~~</div>~~
010+ </div>

#中转单详情
select
a.WarehouseName,
a.ShipmentOrderCode,
a.ShipmentModeName,
a.CustomerCode,
'已出库' as '状态',
a.ChannelSourceName,
a.ShipmentId,
a.DeliveryModeName,
a.LogisticsModeName,
a.ReferenceCode,
a.TotalCartonNumber,
a.ProductSkuNumber,
a.ProductNumber,
a.TotalWeight,
a.ShipmentTime,
a.ActualTotalCartonNumber as '实际出库总箱数',
a.ActualProductSkuNumber as '实际出库SKU数',
a.ActualProductNumber as '实际出库产品数',
a.ActualTotalWeight as '实际出库重量',
b.AmazonReferenceID,

c.Contact as '联系人',
c.Company as '公司名称',
c.Email as '邮箱地址',
c.Telephone as '电话',
c.CountryId as '国家ID',
c.CountryName as '国家名称',
c.ProvinceId as '洲/省ID',
c.ProvinceName as '洲/省名称',
c.CityId as '城市ID',
c.CityName as '城市名称',
c.Address1 as '地址1',
c.Address2 as '地址2',
c.HouseNumber as '门牌号',
c.ZipCode as '邮编',
c.FbaWarehouseCode as 'FBA仓库编号'

from inv_shipmentorder a
left join inv_shipmentorderattach b on a.ShipmentOrderCode=b.ShipmentOrderCode
left join inv_shipmentaddress c on a.ShipmentOrderCode=c.ShipmentOrderCode
where a.`Status`=3
and a.CreationTime>'2021-11-01 00:00:00'
2021-11-16 11:19:38, 由 husikai 编辑。
修改了 任务描述，区别为：
008-
008+

008- ~~<div class="msg-group-info" style="margin:0px 0px 3px;padding:0px;"><span class="msg-group-info-name"> </span>~~
008+ <div class="msg-group-info" style="margin:0px 0px 3px;padding:0px;"><span class="msg-group-info-name"> </span>

中转实际出库产品数量

SELECT
a.ShipmentOrderCode as '单号',
a.CustomerCode as '客户编号',
b.ProductSku as 'SKU',
b.ShipmentNumber as '预报数',
b.ShipmentNumber-b.RegisterNotEnoughNumber as '实际出库数量'
from inv_shipmentorder a
left join inv_shipmentproduct b on a.ShipmentOrderCode=b.ShipmentOrderCode
where
a.Status=3
and a.CreationTime>'2021-11-01 00:00:00'
and a.ShipmentModeId!=2
UNION
select
a.ShipmentOrderCode as '单号',
a.CustomerCode as '客户编号',
b.CartonCode as 'SKU',
1 as '预报数',
1-b.RegisterNotEnoughNumber as '实际出库数量'
from inv_shipmentorder a
left join inv_shipmentproductcarton b on a.ShipmentOrderCode=b.ShipmentOrderCode
where
a.Status=3
and a.CreationTime>'2021-11-01 00:00:00'
and a.ShipmentModeId=2
2021-11-16 11:23:57, 由 husikai 添加备注。

入库单详细信息

select
b.StorageModeName as '出入库方式',
b.WarehouseName as '仓库',
b.CustomerCode as '客户编码',
b.ShippingReceivingNo as '入库单号',
b.OperationTypeName as '操作类型',
b.DetailNo as '入库批次号',
b.ItemCode as '商品编码',
b.MultiCode as '条码',
b.ProductName as '产品名称',
b.Quantity as '数量',
b.LastModificationTime as '出入库时间',
b.Description as '备注'
from inv_storageorder a
left join inv_shippingreceivingdetail b on a.StorageOrderCode=b.ShippingReceivingNo
where
a.CreationTime>'2021-11-01 00:00:00'
and b.id is not null
2021-12-04 16:54:24, 由 zhengqiao 编辑。
修改了 所属迭代，旧值为 "597"，新值为 "599"。

基本信息
任务的一生

所属迭代	【主干】产品中心12月第二个版本（2021年）
所属模块	赛盒科技海外仓系统
相关需求	系统框架升级合并oms wms库
指派给	彭斌于 2021-11-15 17:17:45
任务类型	后端
任务标签	初始
开发组
任务状态	已完成
进度	100%
优先级	P2
关键词
抄送给

由谁创建	pengbin 于 2021-11-15 15:40:04
由谁完成	husikai 于 2021-11-15 16:36:14
由谁取消	暂无
由谁关闭	暂无
关闭原因	暂无
最后编辑	zhengqiao 于 2021-12-04 16:54:24

团队	最初预计	总计消耗	预计剩余

工时信息

最初预计	3工时
总计消耗	2工时
预计剩余	0工时
预计开始	0000-00-00
实际开始	2021-11-15
截止日期	0000-00-00