用例评审图：

通过站点，获取其站点下的店铺等级和刊登数量

SQL参考： 
select b1.PreDayMaxListingCount,s3.StoreLevel,s3.listingNum,s3.OrderSourceId,s3.OrderSourceName  from  sys_ebay_account_limit b1 join 
(select s1.StoreLevel,s1.listingNum,s1.OrderSourceId,s2.OrderSourceName from sys_ebay_odersource_level  s1 join sys_ordersource s2 on s1.OrderSourceId = s2.OrderSourceId where s1.siteCode in ('DE','US','AU','GB') and s2.OrderSourceName in ('澳洲-Ebay-Z02159-AU/133/soda',
'澳洲-Ebay-Z02061-AU/229/yoki',
'美国-Ebay-Z02250-US/122damoe',
'美国-Ebay-Z02330-US/153/dem',
'英国-Ebay-Z02152-UK/133/sas家居玩具',
'英国-Ebay-Z02212-UK/192/flo家居汽配',
'德国-Ebay-Z02154-DE/148/four家居玩具',
'德国-Ebay-Z02429-DE/232/hou')) s3  on b1.OrderSourceId = s3.OrderSourceId GROUP BY s3.StoreLevel,s3.listingNum,s3.OrderSourceId,s3.OrderSourceName;

今日预计可刊登数
今日预计可刊登数=（店铺免刊数量*额度限制百分比-当日（在线listing数【success】-等待刊登中listing【normal】）* 刊登系数
每日可刊登底线
输入底线数据
今日可刊登数量
取值为【今日预计刊登数量】与【每日可刊登底线】的最大值
补充
今日在线listing：
select  count(1)  from m_ebay_listing where OrderSourceid = XXX  and  onlinestatus =1; 

等待刊登中listing：
select  count(1)  from ap_autopublish_ebay_queue  where CustomerId = 1 and MarketId = 2 and  OrderSourceId =XXX  and Status='normal';

listing在线【有销量】总数（UK站点）:   
select count(1) from m_ebay_listing  where CustomerId=1  and  OnlineStatus=1 and  OrderSourceId = XXX  and  QuantitySold>0   and SiteCode='UK';

listing在线总数（UK站点）:  
select count(1) from m_ebay_listing where CustomerId=1    and OnlineStatus=1 and  ordersourceId=XXX  and SiteCode='UK'  

本月成功刊登数量：
 select count(1) from ap_autopublish_ebay_queue  aaeq  where aaeq.CustomerId = 1 and aaeq.MarketId = 2 and aaeq.OrderSourceId =XXX  and aaeq.`Status`='success' and  '2023-05-01'<=`Date`

刊登中数量:
 select count(1) from ap_autopublish_ebay_queue aaeq where aaeq.CustomerId = 1 and MarketId = 2 and  aaeq.OrderSourceId =XXX  and aaeq.`Status`='normal' and  '2023-05-01'<=`Date`

今日可刊登额度：

本月剩余数量（UK）
本月(UK站点)剩余可刊登的listing数量  =
(店铺本月可刊登数-listing在线【有销量】总数（UK站点）)  *  额度限制百分比 - 本月成功刊登数量（UK站点）- 刊登中数量（UK站点）

数量（UK）
日可刊登数量=
Min【（免刊登数量*  额度限制百分比  -  listing在线总数（UK站点）），本月剩余可刊登的listing数量（UK站点）】（取最小值）

验证1：1.对接海外仓店铺等级，按直发账号规则获取海外仓店铺对应站点等级及刊登数量

SQL参考：店铺为海外仓业务提供

select b1.PreDayMaxListingCount,s3.StoreLevel,s3.listingNum,s3.OrderSourceId,s3.OrderSourceName  from  sys_ebay_account_limit b1 join 
(select s1.StoreLevel,s1.listingNum,s1.OrderSourceId,s2.OrderSourceName from sys_ebay_odersource_level  s1 join sys_ordersource s2 on s1.OrderSourceId = s2.OrderSourceId where s1.siteCode in ('DE','US','AU','GB') and s2.OrderSourceName in ('澳洲-Ebay-Z02159-AU/133/soda',
'澳洲-Ebay-Z02061-AU/229/yoki',
'美国-Ebay-Z02250-US/122damoe',
'美国-Ebay-Z02330-US/153/dem',
'英国-Ebay-Z02152-UK/133/sas家居玩具',
'英国-Ebay-Z02212-UK/192/flo家居汽配',
'德国-Ebay-Z02154-DE/148/four家居玩具',
'德国-Ebay-Z02429-DE/232/hou')) s3  on b1.OrderSourceId = s3.OrderSourceId GROUP BY s3.StoreLevel,s3.listingNum,s3.OrderSourceId,s3.OrderSourceName;

数据库与页面刊登数量情况比对：

验证2.对接海外仓店铺额度试算，按直发账号规则试算海外仓店铺额度试算，控制海外仓店铺按额度刊登

今日预计可刊登数：
今日预计可刊登数=（店铺免刊数量*额度限制百分比-当日（在线listing数【onlinestatus =1】-等待刊登中listing【normal】）* 刊登系数

今日在线listing：
select  count(1)  from m_ebay_listing where OrderSourceid = 13753  and  SiteCode= 'Germany' and  onlinestatus =1; 
等待刊登中listing：
select  count(1)  from ap_autopublish_ebay_queue  where CustomerId = 1 and MarketId = 2 and OrderSourceid = 13753 and sitecode='Germany' and  Status='normal';

select (400 * 0.85 - 0 -162 ) * 0.15

每月剩余数量：

每月剩余免费刊登数量[298.35] = 店铺每月免费刊登数量([400]- 该店铺在线的有销量listing数量orderSourceSales[49])*[85]百分比-当月(刊登成功+刊登中)的数量[0]

select (400-41)*0.85 - 0 - 0

listing在线【有销量】总数（DE站点）:   
select count(1) from m_ebay_listing  where CustomerId=1  and  OnlineStatus=1 and  OrderSourceId = 13753  and SiteCode='Germany'  and  onlinestatus =1 and  QuantitySold>0;

listing在线总数（DE站点）:  
select count(1) from m_ebay_listing where CustomerId=1  and OnlineStatus=1 and  ordersourceId=13753  and SiteCode='Germany'  

本月成功刊登数量：
 select count(1) from ap_autopublish_ebay_queue  aaeq  where aaeq.CustomerId = 1 and aaeq.MarketId = 2 and aaeq.OrderSourceId =13753  and  aaeq.sitecode='Germany' and aaeq.`Status`='success' and  '2023-06-01'<=`Date`

刊登中数量:
 select count(1) from ap_autopublish_ebay_queue aaeq where aaeq.CustomerId = 1 and MarketId = 2 and  aaeq.OrderSourceId =13753  and  aaeq.sitecode='Germany'  and aaeq.`Status`='normal' and  '2023-06-01'<=`Date`