深圳智汇创想科技有限公司

一、Task_Amazon_SyncListing-增量同步Listing

将以前的服务修改为设置开关，如果开关未开启，则保持原有逻辑，将手工和自动刊登的数据插入到RB_Amazon_Product_Base，不会插入RB_Amazon_Product_Base_AutoPub_Mid，当开关开启后，丢弃自动刊登的数据。

二、新增Task_Amazon_SyncAutoPubListing

同步自动刊登数据到新表：RB_Amazon_Product_Base_AutoPub_Mid，同时不会将手工刊登数据插入到RB_Amazon_Product_Base，只会将自动刊登的数据插入到RB_Amazon_Product_Base_AutoPub_Mid

三、自测

 select   * From RB_Amazon_Product_Base_AutoPub_Mid(NOLOCK);

四、svn提交

任务35936，自动刊登新刊登Listing插入冷数据库——新增服务，独立拉取自动刊登的数据

原服务测试按钮：

SELECT TOP 1 * FROM RB_SysCommon WITH(NOLOCK) WHERE CustomerID=1 AND Type=72 ORDER BY ID DESC--Status=1 代表未开启，2代表开启

SELECT TOP 1 * FROM RB_SysCommon WITH(NOLOCK) WHERE CustomerID=1 AND Type=72 ORDER BY ID DESC--Status=1 代表未开启，2代表开启
update RB_SysCommon set Status=1 where  CustomerID=1 AND Type=72 ;

--重置同步数据区间
update RB_Amazon_SyncDataRecord  set  BeginTime='2022-02-08 00:00:00' , EndTime='2023-02-15 10:08:02'  where Type=2 and CustomerID=1;
--手动+自动数据
select *From RB_Amazon_Product_Base where CustomerID=1 and OrderSourceSKUID in(270600929,270600930,270600931,270600932,270600933,270600934,270600935,270600937,270600938,270600939,270600940,270600941,270600943,270600944,270600945,270600947,270601984,270602005,270602006,270602004,270602015,270602018,270602019,270602022,270602023,270602032,270602035,270602039,270602040,270603054,270603059,270603060,270603061,270603066,270603067,270603068,270603069,270603070,270603071,270603084,270603090,270603091,270603093,270603094,270603096,270603097,270603098,270603099,270603100,270603101,270603103,270603104,270603105,270603106,270603108,270603115,270603116,270603120,270603122,270603155,270603156,270603157,270603158,270603159,270603163,270603164,270603165,270603177,270603178,270603179,270603191,270603192,270603197,270603210,270603211,270603212,270603213,270603218,270603219,270603220,270603221,270603255,270603258,270603257,270603256,270603259,270603260,270603261,270603262,270603263,270603264,270603265,270603266,270603267,270603268,270603269,270603270,270603271,270603272,270603273,270603274,270603275,270603276,270603291,270603293,270603294,270603296,270603332,270603335,270603336,270603337);
--自动刊登数据
select *From RB_Amazon_Product_Base where CustomerID=1 and OrderSourceSKUID in(270603218,270603219,270603220,270603221)
--清数据
delete  from  RB_Amazon_Product_Base where  CustomerID=1 and OrderSourceSKUID in(270600929,270600930,270600931,270600932,270600933,270600934,270600935,270600937,270600938,270600939,270600940,270600941,270600943,270600944,270600945,270600947,270601984,270602005,270602006,270602004,270602015,270602018,270602019,270602022,270602023,270602032,270602035,270602039,270602040,270603054,270603059,270603060,270603061,270603066,270603067,270603068,270603069,270603070,270603071,270603084,270603090,270603091,270603093,270603094,270603096,270603097,270603098,270603099,270603100,270603101,270603103,270603104,270603105,270603106,270603108,270603115,270603116,270603120,270603122,270603155,270603156,270603157,270603158,270603159,270603163,270603164,270603165,270603177,270603178,270603179,270603191,270603192,270603197,270603210,270603211,270603212,270603213,270603218,270603219,270603220,270603221,270603255,270603258,270603257,270603256,270603259,270603260,270603261,270603262,270603263,270603264,270603265,270603266,270603267,270603268,270603269,270603270,270603271,270603272,270603273,270603274,270603275,270603276,270603291,270603293,270603294,270603296,270603332,270603335,270603336,270603337);