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

-- 直发库存
SELECT
whp.SKU,
wh.ID AS WareHouseID,
wh.WareHouseName ,
ISNULL( whp.GoodNum, 0 ) GoodNum,
ISNULL( whp.ProtectNum, 0 ) ProtectNum,
wh.WareHouseCountry,
wh.WareHouseType,
1 AS StockType 
FROM
dbo.RB_WareHouse wh ( NOLOCK )
LEFT JOIN dbo.RB_WareHouse_Product whp ( NOLOCK ) ON wh.CustomerID = whp.CustomerID 
AND wh.ID = whp.WareHouseID 
WHERE
wh.CustomerID = 1 
AND whp.SKU = '1251196' 
AND ( ( wh.WareHouseType = 3 AND whp.OrderSourceID= 10275 AND whp.OrderSourceSKU= 'R50SHP8E4310RSYMK' ) OR wh.WareHouseType <> 3 ) 
ORDER BY
whp.GoodNum DESC;
-- 箱产品库存
SELECT
b.RelationSku AS SKU,
a.WareHouseID,
c.WareHouseName,
c.WareHouseCountry,
c.WareHouseType,
SUM ( a.GoodNum* b.ProductQuantity ) AS GoodNum,
SUM ( a.ProtectNum ) AS ProtectNum,
a.StockType 
FROM
RB_WareHouse_Product a ( nolock )
INNER JOIN RB_WareHouse_ProductDetail b ( nolock ) ON b.CustomerId = a.CustomerID 
AND a.OrderSourceSKU = b.ItemCode 
AND a.WareHouseID = b.WarehouseId
INNER JOIN RB_WareHouse c ( nolock ) ON a.CustomerID = c.CustomerID 
AND a.WareHouseID = c.ID 
WHERE
a.CustomerID = 1 
AND a.StockType IN ( 2, 3 ) 
AND b.RelationSku = '1251196' 
GROUP BY
b.RelationSku,
a.WareHouseID,
c.WareHouseName,
c.WareHouseCountry,
c.WareHouseType,
a.StockType;
--在途库存
SELECT
CustomerID,
SKU,
ToWareHouseID AS WareHouseID,
TransitNum,
OrderCode 
FROM
RB_TransitOrderList ( NOLOCK ) 
WHERE
ShipStatus IN ( 1, 2 ) 
AND CustomerID = 1 
AND SKU = '1251196';
-- 在途库存类型
SELECT
DeliveryType,
StorageModels,
OrderCode
FROM
RB_OrderInfo_BeikuExpand ( NOLOCK ) 
WHERE
OrderCode IN ( SELECT item FROM dbo.CharSplitForIn ( '202212241613830125', ',' ) ) 
AND CustomerID = 1  

路由：ASHX/IrobotBox/AmazonListHeandler.ashx?ActionType=GetStoreDetailNew&SKU=2374906&OrdersourceSKU=OG-VRTV-7FGJ&OrdersourceID=6110&ASIN=B075RW2VZ1&_=1672919774446