需求背景
用户想根据不同的店铺类型进行调价/重刊,尤其是新增店铺,每次都需要重新选择,繁琐
需求描述
1.凤凰计划策略,来源渠道条件,改为单选条件,值有所有直发来源渠道/所有海外仓来源渠道/纯直发来源渠道/虚拟仓来源渠道/指定来源渠道,默认选择为所有直发来源渠道
a.所有直发来源渠道:默认为选中该选项,指所有的直发店铺作为过滤条件过滤店铺
b.所有海外仓来源渠道:点击该选项,指所有的海外仓店铺作为过滤条件过滤店铺
c.纯直发来源渠道:点击该选项,指只有直发listing权限无海外仓listing权限的直发店铺作为过滤条件
d.虚拟仓来源渠道:点击该选项,指有直海外仓listing权限的直发店铺作为过滤条件
e.指定来源渠道:点击该选项,下拉展示来源渠道选项(多选),可选择指定的来源渠道,也可导入指定的来源渠道(同现有凤凰计划),历史策略初始化均为指定的来源渠道



验证如下:测试场景如下:
##---策略ID:9410 所有直发来源渠道20700
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (20700) and Country ='CN' and quantitysold =0 order by LastModificationTime desc limit 10;
SELECT * FROM m_ebay_listing_sub WHERE CustomerId = 1 and EditStatus =1 and OrdersourceId in (20700) and ItemLocation ='CN' and quantitysold =0 order by LastModificationTime desc limit 10;
375505032935
375505024251
select t.productid,t.sku,t.sellersku,t.ordersourceid,t.price,t.Quantity,t.QuantitySold,t.WarehouseIds,t.OnlineStatus,t.WareHouseType,t.PublishTime,t.country,t.type,t.* from m_ebay_listing t where t.productid in ('375505032935','375505024251');
##---策略ID:9409 虚拟来源渠道(有海外仓权限)20494
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (20494) and Country !='CN' and quantitysold =0 order by LastModificationTime desc limit 10;
SELECT * FROM m_ebay_listing_sub WHERE CustomerId = 1 and EditStatus =1 and OrdersourceId in (20494) and ItemLocation !='CN' and quantitysold =0 order by LastModificationTime desc limit 10;
285667688901
285540306989
select t.productid,t.sku,t.sellersku,t.ordersourceid,t.price,t.Quantity,t.QuantitySold,t.WarehouseIds,t.OnlineStatus,t.WareHouseType,t.PublishTime,t.country,t.type,t.* from m_ebay_listing t where t.productid in ('285667688901','285540306989');
##---策略ID:9408 纯直发来源渠道(无海外仓权限)5080
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (5080) and Country !='CN' and quantitysold=0 order by LastModificationTime desc limit 10;
SELECT * FROM m_ebay_listing_sub WHERE CustomerId = 1 and EditStatus =1 and OrdersourceId in (5080) and ItemLocation !='CN' and quantitysold =0 order by LastModificationTime desc limit 10;
135167173476
135167146310
备份:
145915972179
select t.productid,t.sku,t.sellersku,t.ordersourceid,t.price,t.Quantity,t.QuantitySold,t.WarehouseIds,t.OnlineStatus,t.WareHouseType,t.PublishTime,t.country,t.type,t.* from m_ebay_listing t
where t.productid in ('135167173476','145915972179','135167146310');
##---策略ID:9409 对接所有海外仓来源渠道 9802
SELECT * FROM m_ebay_listing WHERE CustomerId = 1 and onlinestatus =1 and OrdersourceId in (9802) and Country !='CN' and quantitysold=0 order by LastModificationTime desc limit 10;
SELECT * FROM m_ebay_listing_sub WHERE CustomerId = 1 and EditStatus =1 and OrdersourceId in (9802) and ItemLocation !='CN' and quantitysold =0 order by LastModificationTime desc limit 10;
126571017821
126571017531
备份
126571017527
select t.productid,t.sku,t.sellersku,t.ordersourceid,t.price,t.Quantity,t.QuantitySold,t.WarehouseIds,t.OnlineStatus,t.WareHouseType,t.PublishTime,t.country,t.type,t.* from m_ebay_listing t
where t.productid in ('126571017527','126571017821','126571017531');
##----策略ID:9406 指定来源渠道 7773
145773247739
select t.productid,t.sku,t.sellersku,t.ordersourceid,t.price,t.Quantity,t.QuantitySold,t.WarehouseIds,t.OnlineStatus,t.WareHouseType,t.PublishTime,t.country,t.type,t.* from m_ebay_listing t where t.productid in ('145773247739');