| | | 1 | | using System.Text.RegularExpressions; |
| | | 2 | | using Newtonsoft.Json.Linq; |
| | | 3 | | using Services.ApiServices.OzonApi; |
| | | 4 | | using Services.ApiServices.OzonApi.Filters; |
| | | 5 | | |
| | | 6 | | namespace Services.BitrixStockServices; |
| | | 7 | | |
| | | 8 | | public interface IOzonCatalogStockEnricher |
| | | 9 | | { |
| | | 10 | | /// <summary> |
| | | 11 | | /// Обогащает батч каталога остатками по целевым FBS/RFBS-складам через Ozon API. |
| | | 12 | | /// Возвращает строки с AvailableQty > 0 на одном из targetWarehouseIds. |
| | | 13 | | /// </summary> |
| | | 14 | | Task<IReadOnlyList<OzonCatalogStockRow>> EnrichBatchAsync( |
| | | 15 | | OzonApiDataManager apiManager, |
| | | 16 | | IReadOnlyList<OzonProductCatalogRow> catalogBatch, |
| | | 17 | | IReadOnlyCollection<long> targetWarehouseIds, |
| | | 18 | | IReadOnlyDictionary<long, string> warehouseNameById, |
| | | 19 | | List<WarehouseOzon> warehouseList, |
| | | 20 | | Func<string, Task>? log = null, |
| | | 21 | | CancellationToken cancellationToken = default); |
| | | 22 | | } |
| | | 23 | | |
| | | 24 | | public class OzonCatalogStockEnricher : IOzonCatalogStockEnricher |
| | | 25 | | { |
| | 1 | 26 | | private static readonly Regex BrandCodeRegex = |
| | 1 | 27 | | new(@"^([A-Z0-9]{2,5})(?:\[.*\])?$", RegexOptions.Compiled); |
| | | 28 | | |
| | | 29 | | public async Task<IReadOnlyList<OzonCatalogStockRow>> EnrichBatchAsync( |
| | | 30 | | OzonApiDataManager apiManager, |
| | | 31 | | IReadOnlyList<OzonProductCatalogRow> catalogBatch, |
| | | 32 | | IReadOnlyCollection<long> targetWarehouseIds, |
| | | 33 | | IReadOnlyDictionary<long, string> warehouseNameById, |
| | | 34 | | List<WarehouseOzon> warehouseList, |
| | | 35 | | Func<string, Task>? log = null, |
| | | 36 | | CancellationToken cancellationToken = default) |
| | | 37 | | { |
| | 7 | 38 | | if (catalogBatch.Count == 0 || targetWarehouseIds.Count == 0) |
| | 2 | 39 | | return Array.Empty<OzonCatalogStockRow>(); |
| | | 40 | | |
| | 5 | 41 | | var targetSet = targetWarehouseIds.ToHashSet(); |
| | 5 | 42 | | var catalogByOffer = catalogBatch |
| | 5 | 43 | | .Where(c => !string.IsNullOrWhiteSpace(c.OfferId)) |
| | 5 | 44 | | .GroupBy(c => c.OfferId, StringComparer.OrdinalIgnoreCase) |
| | 15 | 45 | | .ToDictionary(g => g.Key, g => g.First(), StringComparer.OrdinalIgnoreCase); |
| | | 46 | | |
| | 5 | 47 | | var offerIds = catalogByOffer.Keys.ToArray(); |
| | 5 | 48 | | if (log != null) |
| | 0 | 49 | | await log($" Ozon API POST /v4/product/info/stocks: {offerIds.Length} offer_id (chunk 200)").ConfigureAwait |
| | | 50 | | |
| | 5 | 51 | | var stocksResponse = await apiManager.GetProductStocks(offerIds, chunkSize: 200).ConfigureAwait(false); |
| | 5 | 52 | | if (stocksResponse["items"] is not JArray stockItems || stockItems.Count == 0) |
| | | 53 | | { |
| | 0 | 54 | | if (log != null) |
| | 0 | 55 | | await log($" Ozon API stocks: 0 товаров с данными в ответе").ConfigureAwait(false); |
| | 0 | 56 | | return Array.Empty<OzonCatalogStockRow>(); |
| | | 57 | | } |
| | | 58 | | |
| | 5 | 59 | | var itemsWithStock = new List<(string OfferId, JObject Stocks)>(); |
| | 20 | 60 | | foreach (var stockItem in stockItems.OfType<JObject>()) |
| | | 61 | | { |
| | 5 | 62 | | cancellationToken.ThrowIfCancellationRequested(); |
| | 5 | 63 | | var offerId = stockItem["offer_id"]?.ToString(); |
| | 5 | 64 | | if (string.IsNullOrWhiteSpace(offerId)) |
| | | 65 | | continue; |
| | | 66 | | |
| | 5 | 67 | | var (fbs, rfbs, _) = BitrixOzonStockLinkage.ExtractStocksByType(new JObject { ["items"] = new JArray { stock |
| | 5 | 68 | | if (fbs <= 0 && rfbs <= 0) |
| | | 69 | | continue; |
| | | 70 | | |
| | 4 | 71 | | itemsWithStock.Add((offerId, new JObject { ["items"] = new JArray { stockItem } })); |
| | | 72 | | } |
| | | 73 | | |
| | 5 | 74 | | if (log != null) |
| | 0 | 75 | | await log($" Ozon API stocks: FBS>0 или RFBS>0 у {itemsWithStock.Count} из {offerIds.Length} offer_id").Con |
| | | 76 | | |
| | 5 | 77 | | if (itemsWithStock.Count == 0) |
| | 1 | 78 | | return Array.Empty<OzonCatalogStockRow>(); |
| | | 79 | | |
| | 4 | 80 | | var batched = itemsWithStock |
| | 4 | 81 | | .Select(x => (x.OfferId, x.Stocks)) |
| | 4 | 82 | | .ToList(); |
| | | 83 | | |
| | 4 | 84 | | if (log != null) |
| | 0 | 85 | | await log($" Ozon API POST stocks-by-warehouse: {batched.Count} товар(ов)").ConfigureAwait(false); |
| | | 86 | | |
| | 4 | 87 | | var warehouseInfoByOffer = await apiManager.GetWarehouseInfoBatchedAsync(batched, warehouseList) |
| | 4 | 88 | | .ConfigureAwait(false); |
| | | 89 | | |
| | 4 | 90 | | var result = new List<OzonCatalogStockRow>(); |
| | 16 | 91 | | foreach (var (offerId, warehouseInfo) in warehouseInfoByOffer) |
| | | 92 | | { |
| | 4 | 93 | | cancellationToken.ThrowIfCancellationRequested(); |
| | 4 | 94 | | if (warehouseInfo == null) |
| | | 95 | | continue; |
| | | 96 | | |
| | 4 | 97 | | catalogByOffer.TryGetValue(offerId, out var catalogRow); |
| | 4 | 98 | | var warehouses = BitrixOzonStockLinkage.GetWarehousesArray(warehouseInfo); |
| | 16 | 99 | | foreach (var wh in warehouses.OfType<JObject>()) |
| | | 100 | | { |
| | 4 | 101 | | var warehouseId = wh["warehouse_id"]?.Value<long?>() ?? 0; |
| | 4 | 102 | | if (warehouseId <= 0 || !targetSet.Contains(warehouseId)) |
| | | 103 | | continue; |
| | | 104 | | |
| | 4 | 105 | | var present = wh["present"]?.Value<int?>() ?? 0; |
| | 4 | 106 | | if (present <= 0) |
| | | 107 | | continue; |
| | | 108 | | |
| | | 109 | | // free_stock = present - reserved. Строку с present > 0 оставляем в любом случае — |
| | | 110 | | // фаза 5a (партии [N]) накатывает по остатку 1С и не смотрит на Ozon qty. Решение |
| | | 111 | | // «сирота или нет» принимается по FreeQty уже в BitrixStockOzonOrphanCleanupService. |
| | 4 | 112 | | var reserved = wh["reserved"]?.Value<int?>() ?? 0; |
| | 4 | 113 | | var freeStock = wh["free_stock"]?.Value<int?>() ?? (present - reserved); |
| | | 114 | | |
| | 4 | 115 | | var (cleanOfferId, brandCode) = ParseOfferId(offerId); |
| | 4 | 116 | | var warehouseName = warehouseNameById.TryGetValue(warehouseId, out var mappedName) && !string.IsNullOrWh |
| | 4 | 117 | | ? mappedName |
| | 4 | 118 | | : wh["warehouse_name"]?.ToString() ?? warehouseId.ToString(); |
| | | 119 | | |
| | 4 | 120 | | result.Add(new OzonCatalogStockRow |
| | 4 | 121 | | { |
| | 4 | 122 | | WarehouseId = warehouseId.ToString(), |
| | 4 | 123 | | WarehouseName = warehouseName, |
| | 4 | 124 | | OfferId = cleanOfferId, |
| | 4 | 125 | | OriginalOfferId = offerId, |
| | 4 | 126 | | BrandCode = brandCode, |
| | 4 | 127 | | ProductName = catalogRow?.Name, |
| | 4 | 128 | | AvailableQty = present, |
| | 4 | 129 | | ReservedQty = reserved, |
| | 4 | 130 | | FreeQty = Math.Max(0, freeStock), |
| | 4 | 131 | | ProductId = catalogRow?.ProductId ?? wh["product_id"]?.Value<long?>() |
| | 4 | 132 | | }); |
| | | 133 | | } |
| | | 134 | | } |
| | | 135 | | |
| | 4 | 136 | | if (log != null) |
| | 0 | 137 | | await log($" Ozon API stocks-by-warehouse: +{result.Count} строк на целевых складах ({targetWarehouseIds.Co |
| | | 138 | | |
| | 4 | 139 | | return result; |
| | 7 | 140 | | } |
| | | 141 | | |
| | | 142 | | private static (string CleanOfferId, string? BrandCode) ParseOfferId(string rawOfferId) |
| | | 143 | | { |
| | 4 | 144 | | var eqIdx = rawOfferId.IndexOf('='); |
| | 4 | 145 | | if (eqIdx > 0) |
| | | 146 | | { |
| | 4 | 147 | | var clean = rawOfferId[..eqIdx].Trim(); |
| | 4 | 148 | | var brandPart = rawOfferId[(eqIdx + 1)..].Trim(); |
| | 4 | 149 | | var m = BrandCodeRegex.Match(brandPart); |
| | 4 | 150 | | return (clean, m.Success ? m.Groups[1].Value : null); |
| | | 151 | | } |
| | | 152 | | |
| | 0 | 153 | | return (rawOfferId.Trim(), null); |
| | | 154 | | } |
| | | 155 | | } |