需求背景
不同的用户对相同产品的诉求不同， 有些追求时效有些追求性价比，因此有出单的listing需同时存在虚拟及直发listing
需求描述
1.支持虚拟海外仓的直发店铺（需提供支持海外仓的标记），新建刊登脚本，每日判断新进订单表的listing，及listing是否为直发/虚拟海外仓listing
a.若来源渠道对应SKU的SKU类型的虚拟海外仓listing有销量，则判断该SKU是否存在对应SKU类型直发listing，若不存在则刊登，若存在则不刊登
b.若来源渠道对应SKU的SKU类型的直发listing有销量，则判断该SKU是否存在应SKU类型虚拟海外仓listing，若不存在则刊登，若存在则不刊登
c.刊登时需判断店铺今日可刊登数量是否为正数，为正数则可刊登，为负数则不刊登记录在刊登队列，待店铺今日可刊登数量为正数时（每日判断一次），重新执行组装数据刊登
d.虚拟仓调用计算器为960，直发listing调用计算器为962；直发listing需遵循店铺利润率进行刊登
e.初始化，获取直发账号支持虚拟海外仓的在线所有有销量listing，进行判断是否有对应的直发/虚拟海外仓listing，无则进入刊登队列，判断店铺今日可刊登数量后进行刊登
验证如下：
1、前置条件准备：
（1）来源渠道表，准备直发测试店铺表：7773（直发-Ebay-Z02162-DE/245/reg）20700（直发-Ebay-Z02625-UK/136/goal）
（2）支持海外仓标记数据表： sys_ebay_virtualordersource where OrderSourceId in (20700,7773);
（3）增量调度表 +准备订单表数据（订单支付时间需落在增量调度表的执行时间范围内）+
订单表：sys_orderinfo where CustomerId =1 and Marketid =2 and OrderSourceId in (20700,7773) and SellerSkus = '?'
增量调度表：sys_syncdata where BusinessType = 'GetEbaySaleListingMutualism'
2、测试数据：
（1）虚拟海外仓数据（转刊直发listing）：
获取数据：SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (20700) and country !='CN' and type in（1,2) 且有销量 limit 10
A、单体
订单数据
select * from sys_orderinfo where CustomerId =1 and Marketid =2 and ordersourceid = 20700 and sellerskus in (
'160434D36MR20700',
'16044101UKB20700',
'102246EON0K20700',
'102313O81B920700',
'135451KA1ES20700',
'135459WL3DP20700');
listing数据：
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (20700) and country !='CN' and quantitysold >0 and type=1 and sellerSku in (select SellerSkus from sys_orderinfo where CustomerId =1 and Marketid =2 and ordersourceid = 20700)
and ProductId in (
'375047979402',
'375047675752',
'375057823210',
'375059994365',
'375058323843',
'375060323763')
预期结果1：满足条件的刊登SKU
验证：已刊登虚拟海外仓listing对应sku，是否存在有直发的
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (20700) and country !='CN' and sku in
('8617141',
'8895959',
'9947233',
'14189207',
'15605316',
'5659307')
B、多变体
订单表数据：
select * from sys_orderinfo where CustomerId =1 and Marketid =2 and Ordersourceid = 20700 and SellerSkus in (
'170338KCAIE20700',
'170340BMA8220700',
'170437DO3DF20700',
'170355AEX9720700',
'173301MSO8720700',
'173236N59HH20700')
listing数据：
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (20700) and country !='CN' and type=1 and sellerSku in (select SellerSkus from sys_orderinfo where CustomerId =1 and Marketid =2 and ordersourceid = 20700)
and productid in (
'375099563003',
'375099565822',
'375099634160',
'375099846134',
'375089428720',
'375089704361')
预期结果2：满足条件的刊登SKU
验证：已刊登虚拟海外仓listing对应sku，是否存在有直发的
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (20700) and country ='CN' and sku in
('13450674',
'15380597',
'3750823',
'3787386',
'15418886',
'12092450')
（2）直发listing数据（转刊虚拟海外仓）：
获取数据：SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (7773) and country ='CN' and type in (1,2) limit 10;
A、单体
订单表数据：
select * from sys_orderinfo where CustomerId =1 and Marketid =2 and ordersourceid = 7773 and sellerskus in (
'V8Y2032392PIUS201',
'1IL162452PW386C1M',
'IR4171524A33GQ4SN',
'3AY1222337RXKJGRB');
listing数据：
and productid in (
'403737736152',
'403931872563',
'403922751817',
'403944015814')
验证：已刊登直发listing对应sku，是否存在有虚拟的
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (7773) and country !='CN' and sku in('13656150',
'7601983',
'8701119',
'13910701')
B、多变体
订单表数据：
select * from sys_orderinfo where CustomerId =1 and Marketid =2 and ordersourceid = 7773 and sellerskus in ('288024108OR8NHIH3',
'KZB0436587FDXFUAO',
'1D6052925O3OBFTWS');
listing表数据：
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (7773) and country ='CN' and type=1 and sellerSku in (select SellerSkus from sys_orderinfo where CustomerId =1 and Marketid =2 and ordersourceid = 7773)
and productid in (
'145219296152',
'145313009344',
'145319114712')
验证：已刊登直发listing对应sku，是否存在有虚拟的
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (7773) and country !='CN' and sku in('15682166',
'7375813',
'11118069')
3、验证场景如下：
场景1：虚拟转刊直发，策略id：76051
——20700 单体+多变体，选择单个SKU、关联变体SKU符合条件的策略SKU
通过调度服务：Ebay--直发虚拟互转数据同步：GetEbaySaleListingMutualism-dev
查看对应落入策略SKU表中系统SKU，理应符合预期结果1、2
实际结果：符合预期
对应策略SKU表展示：符合预期
场景2：直发转刊虚拟，策略id：76052
——7333 单体+多变体，选择单个SKU、关联变体SKU符合条件的策略SKU
通过调度服务：Ebay--直发虚拟互转数据同步：GetEbaySaleListingMutualism-dev
查看对应落入策略SKU表中系统SKU，理应符合预期结果3、4
实际结果：符合预期
对应策略SKU表展示：符合预期