| | | 1 | | using Newtonsoft.Json.Linq; |
| | | 2 | | using OzonDomains.Models; |
| | | 3 | | using OzonDomains.Models.BitrixModels; |
| | | 4 | | using Services.ApiServices.OzonApi.Filters; |
| | | 5 | | using Services.FiltersServices.DataFilterManagers; |
| | | 6 | | |
| | | 7 | | namespace Services.BitrixStockServices; |
| | | 8 | | |
| | | 9 | | /// <summary> |
| | | 10 | | /// Связка остатков Bitrix → Ozon по WarehouseMapping при загрузке BitrixStock. |
| | | 11 | | /// Учитываются только связи с заполненным OzonWarehouseId и допустимым именованием склада Ozon. |
| | | 12 | | /// </summary> |
| | | 13 | | public static class BitrixOzonStockLinkage |
| | | 14 | | { |
| | | 15 | | /// <summary>Ищет блок остатков Ozon по offer_id (точное совпадение, артикул без суффикса, без учёта регистра).</sum |
| | | 16 | | public static JObject? FindStocksForArticle(JObject? allStocks, string articleWithKey, string? article = null) |
| | | 17 | | { |
| | 3 | 18 | | if (allStocks?["items"] is not JArray items) |
| | | 19 | | { |
| | 1 | 20 | | return null; |
| | | 21 | | } |
| | | 22 | | |
| | 2 | 23 | | var candidates = BuildOfferIdCandidates(articleWithKey, article); |
| | 7 | 24 | | foreach (var stockItem in items) |
| | | 25 | | { |
| | 2 | 26 | | var offerId = stockItem["offer_id"]?.ToString(); |
| | 2 | 27 | | if (string.IsNullOrWhiteSpace(offerId)) |
| | | 28 | | { |
| | | 29 | | continue; |
| | | 30 | | } |
| | | 31 | | |
| | 2 | 32 | | if (candidates.Contains(offerId.Trim())) |
| | | 33 | | { |
| | 1 | 34 | | return new JObject { ["items"] = new JArray { stockItem } }; |
| | | 35 | | } |
| | | 36 | | } |
| | | 37 | | |
| | 1 | 38 | | return null; |
| | 1 | 39 | | } |
| | | 40 | | |
| | | 41 | | public static JObject? FindStocksForArticle(JObject? allStocks, RemainingStockBitrix item) => |
| | 0 | 42 | | FindStocksForArticle(allStocks, item.ArticleWithKey, item.Article); |
| | | 43 | | |
| | | 44 | | public static HashSet<string> BuildOfferIdCandidates(string? articleWithKey, string? article = null) |
| | | 45 | | { |
| | 7 | 46 | | var set = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | 7 | 47 | | if (!string.IsNullOrWhiteSpace(articleWithKey)) |
| | 4 | 48 | | set.Add(articleWithKey.Trim()); |
| | 7 | 49 | | if (!string.IsNullOrWhiteSpace(article)) |
| | 2 | 50 | | set.Add(article.Trim()); |
| | 7 | 51 | | return set; |
| | | 52 | | } |
| | | 53 | | |
| | | 54 | | public static JArray GetWarehousesArray(JToken? warehouseInfo) |
| | | 55 | | { |
| | 10 | 56 | | if (warehouseInfo == null) |
| | | 57 | | { |
| | 3 | 58 | | return new JArray(); |
| | | 59 | | } |
| | | 60 | | |
| | 7 | 61 | | if (warehouseInfo["result"] is JArray resultArray) |
| | | 62 | | { |
| | 5 | 63 | | return resultArray; |
| | | 64 | | } |
| | | 65 | | |
| | 2 | 66 | | if (warehouseInfo["products"] is JArray productsArray) |
| | | 67 | | { |
| | 1 | 68 | | return productsArray; |
| | | 69 | | } |
| | | 70 | | |
| | 1 | 71 | | return new JArray(); |
| | | 72 | | } |
| | | 73 | | |
| | | 74 | | private static bool HasRequiredLinkageFields(WarehouseMapping mapping) => |
| | 36 | 75 | | !string.IsNullOrWhiteSpace(mapping.OzonWarehouseId) && |
| | 36 | 76 | | !string.IsNullOrWhiteSpace(mapping.BitrixWarehouseName) && |
| | 36 | 77 | | !string.IsNullOrWhiteSpace(mapping.OzonWarehouseName); |
| | | 78 | | |
| | | 79 | | /// <summary> |
| | | 80 | | /// Именование 1С↔Ozon: M2→M2, M2→M2S, B1→B12. Не покрывает B2→B12 (B12 не начинается с B2). |
| | | 81 | | /// </summary> |
| | | 82 | | public static bool MatchesStockLinkageNamingRule(WarehouseMapping mapping) |
| | | 83 | | { |
| | 21 | 84 | | if (!HasRequiredLinkageFields(mapping)) |
| | | 85 | | { |
| | 2 | 86 | | return false; |
| | | 87 | | } |
| | | 88 | | |
| | 19 | 89 | | var bitrix = mapping.BitrixWarehouseName!.Trim(); |
| | 19 | 90 | | var ozon = mapping.OzonWarehouseName!.Trim(); |
| | 19 | 91 | | if (string.Equals(bitrix, ozon, StringComparison.OrdinalIgnoreCase)) |
| | | 92 | | { |
| | 9 | 93 | | return true; |
| | | 94 | | } |
| | | 95 | | |
| | 10 | 96 | | return ozon.StartsWith(bitrix, StringComparison.OrdinalIgnoreCase); |
| | | 97 | | } |
| | | 98 | | |
| | | 99 | | /// <summary> |
| | | 100 | | /// Связь применима по именованию (M2→M2, M2→M2S, B1→B12; не M2→M1). |
| | | 101 | | /// Для полного набора складов на один Ozon Warehouse ID см. <see cref="GetStockLinkageMappings"/>. |
| | | 102 | | /// </summary> |
| | | 103 | | public static bool IsStockLinkageMapping(WarehouseMapping mapping) => |
| | 6 | 104 | | MatchesStockLinkageNamingRule(mapping); |
| | | 105 | | |
| | | 106 | | /// <summary> |
| | | 107 | | /// Связи для наката/отчёта: именование + все 1С-склады на тот же Ozon Warehouse ID |
| | | 108 | | /// (коллизия B1+B2→B12, M2+OZON Interparts→M2). |
| | | 109 | | /// </summary> |
| | | 110 | | public static List<WarehouseMapping> GetStockLinkageMappings(IEnumerable<WarehouseMapping> clientMappings) |
| | | 111 | | { |
| | 11 | 112 | | var eligible = clientMappings.Where(HasRequiredLinkageFields).ToList(); |
| | 11 | 113 | | if (eligible.Count == 0) |
| | | 114 | | { |
| | 1 | 115 | | return eligible; |
| | | 116 | | } |
| | | 117 | | |
| | 10 | 118 | | var primaryWarehouseIds = eligible |
| | 10 | 119 | | .Where(MatchesStockLinkageNamingRule) |
| | 11 | 120 | | .Select(m => m.OzonWarehouseId!.Trim()) |
| | 10 | 121 | | .ToHashSet(StringComparer.OrdinalIgnoreCase); |
| | | 122 | | |
| | 10 | 123 | | return eligible |
| | 15 | 124 | | .Where(m => primaryWarehouseIds.Contains(m.OzonWarehouseId!.Trim())) |
| | 10 | 125 | | .ToList(); |
| | | 126 | | } |
| | | 127 | | |
| | | 128 | | /// <summary> |
| | | 129 | | /// Все 1С-склады, привязанные к одному Ozon Warehouse ID (для суммы B1+B2→B12). |
| | | 130 | | /// </summary> |
| | | 131 | | public static IReadOnlyList<string> CollectLinkedBitrixStoreNames( |
| | | 132 | | long ozonWarehouseId, |
| | | 133 | | IEnumerable<WarehouseMapping> linkageMappings, |
| | | 134 | | IReadOnlyList<WarehouseOzon> warehouseList, |
| | | 135 | | IEnumerable<string> allowedBitrixStores) |
| | | 136 | | { |
| | 1 | 137 | | if (ozonWarehouseId <= 0) |
| | | 138 | | { |
| | 0 | 139 | | return Array.Empty<string>(); |
| | | 140 | | } |
| | | 141 | | |
| | 1 | 142 | | var allowed = allowedBitrixStores |
| | 4 | 143 | | .Where(s => !string.IsNullOrWhiteSpace(s)) |
| | 4 | 144 | | .Select(s => s.Trim()) |
| | 1 | 145 | | .ToHashSet(StringComparer.OrdinalIgnoreCase); |
| | | 146 | | |
| | 1 | 147 | | return linkageMappings |
| | 1 | 148 | | .Where(m => |
| | 1 | 149 | | { |
| | 2 | 150 | | var resolved = ResolveOzonWarehouse(m, warehouseList); |
| | 2 | 151 | | return resolved?.WarehouseId == ozonWarehouseId; |
| | 1 | 152 | | }) |
| | 2 | 153 | | .Select(m => m.BitrixWarehouseName?.Trim()) |
| | 2 | 154 | | .Where(name => !string.IsNullOrWhiteSpace(name) && allowed.Contains(name!)) |
| | 2 | 155 | | .Select(name => name!) |
| | 1 | 156 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 2 | 157 | | .OrderBy(name => name, StringComparer.OrdinalIgnoreCase) |
| | 1 | 158 | | .ToList(); |
| | | 159 | | } |
| | | 160 | | |
| | | 161 | | public static bool IsInactiveProduct(RemainingStockBitrix item) => |
| | 9 | 162 | | string.Equals(item.Active, "N", StringComparison.OrdinalIgnoreCase); |
| | | 163 | | |
| | | 164 | | public static bool HasValidOzonProductId(StockByStore store) => |
| | 19 | 165 | | long.TryParse(store.ProductId?.Trim(), out var id) && id > 0; |
| | | 166 | | |
| | | 167 | | public static bool IsMissingOzonProductError(string? message) => |
| | 8 | 168 | | !string.IsNullOrWhiteSpace(message) && |
| | 8 | 169 | | message.Contains("product_id", StringComparison.OrdinalIgnoreCase); |
| | | 170 | | |
| | | 171 | | /// <summary>Убирает склады Ozon без товара в каталоге клиента (нет product_id).</summary> |
| | | 172 | | public static void PruneUnlistedOzonProductStores(RemainingStockBitrix item, string? clientName = null) |
| | | 173 | | { |
| | 2 | 174 | | lock (item.OzonStores) |
| | | 175 | | { |
| | 2 | 176 | | item.OzonStores.RemoveAll(s => |
| | 5 | 177 | | (string.IsNullOrWhiteSpace(clientName) || |
| | 5 | 178 | | string.Equals(s.ClientName, clientName, StringComparison.OrdinalIgnoreCase)) && |
| | 5 | 179 | | (!HasValidOzonProductId(s) || IsMissingOzonProductError(s.LastOzonSyncError))); |
| | 2 | 180 | | } |
| | 2 | 181 | | } |
| | | 182 | | |
| | | 183 | | public static void PruneUnlistedOzonProductStores( |
| | | 184 | | IEnumerable<RemainingStockBitrix> items, |
| | | 185 | | string? clientName = null) |
| | | 186 | | { |
| | 0 | 187 | | foreach (var item in items) |
| | | 188 | | { |
| | 0 | 189 | | PruneUnlistedOzonProductStores(item, clientName); |
| | | 190 | | } |
| | 0 | 191 | | } |
| | | 192 | | |
| | | 193 | | /// <summary>Суммирует остатки из itemStocks по схемам (fbs, rfbs, fbo).</summary> |
| | | 194 | | public static (int Fbs, int Rfbs, int Fbo) ExtractStocksByType(JObject? itemStocks) |
| | | 195 | | { |
| | 24 | 196 | | int fbs = 0, rfbs = 0, fbo = 0; |
| | 8 | 197 | | if (itemStocks?["items"] is JArray items) |
| | 28 | 198 | | foreach (var stockItem in items) |
| | 7 | 199 | | if (stockItem["stocks"] is JArray stocks) |
| | 34 | 200 | | foreach (var s in stocks) |
| | | 201 | | { |
| | 10 | 202 | | var present = s["present"]?.Value<int>() ?? 0; |
| | 10 | 203 | | switch (s["type"]?.ToString()) |
| | | 204 | | { |
| | 14 | 205 | | case "fbs": fbs += present; break; |
| | 4 | 206 | | case "rfbs": rfbs += present; break; |
| | 1 | 207 | | case "fbo": fbo += present; break; |
| | | 208 | | } |
| | | 209 | | } |
| | 8 | 210 | | return (fbs, rfbs, fbo); |
| | | 211 | | } |
| | | 212 | | |
| | | 213 | | public static long ExtractProductIdFromStocks(JObject? itemStocks) |
| | | 214 | | { |
| | 3 | 215 | | if (itemStocks?["items"] is not JArray items || items.Count == 0) |
| | | 216 | | { |
| | 2 | 217 | | return 0; |
| | | 218 | | } |
| | | 219 | | |
| | 1 | 220 | | return items[0]?["product_id"]?.Value<long>() ?? 0; |
| | | 221 | | } |
| | | 222 | | |
| | | 223 | | /// <returns>true — использован FBS-fallback (склад взят из WarehouseMapping, т.к. /v2/product/info/stocks-by-wareho |
| | | 224 | | public static bool ApplyMappedStocks( |
| | | 225 | | RemainingStockBitrix item, |
| | | 226 | | OzonClient client, |
| | | 227 | | JToken? warehouseInfo, |
| | | 228 | | IReadOnlyList<WarehouseMapping> clientMappings, |
| | | 229 | | IReadOnlyList<WarehouseOzon> warehouseList, |
| | | 230 | | HashSet<string> allowedBitrixStores, |
| | | 231 | | string offerArticle, |
| | | 232 | | long stocksProductId = 0, |
| | | 233 | | OzonApiFoundInfo? ozonInfo = null) |
| | | 234 | | { |
| | 2 | 235 | | var linkageMappings = GetStockLinkageMappings(clientMappings); |
| | 2 | 236 | | if (linkageMappings.Count == 0) |
| | | 237 | | { |
| | 0 | 238 | | return false; |
| | | 239 | | } |
| | | 240 | | |
| | 2 | 241 | | var warehousesArray = GetWarehousesArray(warehouseInfo); |
| | 2 | 242 | | var defaultProductId = stocksProductId > 0 |
| | 2 | 243 | | ? stocksProductId |
| | 2 | 244 | | : ExtractDefaultProductId(warehousesArray); |
| | 2 | 245 | | var mappedWarehouseIds = new HashSet<long>(); |
| | 2 | 246 | | var inactive = IsInactiveProduct(item); |
| | | 247 | | |
| | | 248 | | |
| | 2 | 249 | | if (inactive) |
| | | 250 | | { |
| | 0 | 251 | | RegisterLinkageWarehouseIdsForDisplay( |
| | 0 | 252 | | linkageMappings, |
| | 0 | 253 | | warehouseList, |
| | 0 | 254 | | allowedBitrixStores, |
| | 0 | 255 | | mappedWarehouseIds); |
| | | 256 | | } |
| | | 257 | | else |
| | | 258 | | { |
| | 10 | 259 | | foreach (var mapping in linkageMappings) |
| | | 260 | | { |
| | 3 | 261 | | ApplySingleMapping( |
| | 3 | 262 | | item, |
| | 3 | 263 | | client, |
| | 3 | 264 | | mapping, |
| | 3 | 265 | | warehouseList, |
| | 3 | 266 | | allowedBitrixStores, |
| | 3 | 267 | | offerArticle, |
| | 3 | 268 | | defaultProductId, |
| | 3 | 269 | | mappedWarehouseIds); |
| | | 270 | | } |
| | | 271 | | } |
| | | 272 | | |
| | 2 | 273 | | EnrichMappedWarehousesFromApi( |
| | 2 | 274 | | item, |
| | 2 | 275 | | client, |
| | 2 | 276 | | warehousesArray, |
| | 2 | 277 | | linkageMappings, |
| | 2 | 278 | | warehouseList, |
| | 2 | 279 | | allowedBitrixStores, |
| | 2 | 280 | | mappedWarehouseIds, |
| | 2 | 281 | | offerArticle, |
| | 2 | 282 | | defaultProductId); |
| | | 283 | | |
| | | 284 | | // FBS-fallback: /v2/product/info/stocks-by-warehouse/fbs не вернул данных по SKU товара |
| | | 285 | | // (характерно для SDS-схемы). Используем суммарный FBS-остаток из /v4/product/info/stocks |
| | | 286 | | // и привязываем к складу из WarehouseMapping. Срабатывает даже при FBS=0 — создаём запись |
| | | 287 | | // с ozonQty=0, чтобы сравнение с 1С qty дало Push. |
| | 2 | 288 | | var fbsFallback = false; |
| | 2 | 289 | | if (warehousesArray.Count == 0 && ozonInfo is { Found: true }) |
| | | 290 | | { |
| | 2 | 291 | | fbsFallback = ApplyFbsFallbackStocks( |
| | 2 | 292 | | item, client, ozonInfo, linkageMappings, warehouseList, |
| | 2 | 293 | | allowedBitrixStores, offerArticle, defaultProductId, mappedWarehouseIds); |
| | | 294 | | } |
| | | 295 | | |
| | | 296 | | // Для страницы BitrixStock показываем все фактические склады Ozon. |
| | | 297 | | // Удаление unmapped складов отключено, иначе реальные склады (в т.ч. с 0) пропадают из таблицы. |
| | | 298 | | |
| | 2 | 299 | | PruneUnlistedOzonProductStores(item, client.Name); |
| | 2 | 300 | | return fbsFallback; |
| | | 301 | | } |
| | | 302 | | |
| | | 303 | | /// <summary> |
| | | 304 | | /// FBS-fallback: создаёт OzonStore-записи из WarehouseMapping когда Ozon FBS warehouse API |
| | | 305 | | /// не вернул данных по SKU (SDS/схема без привязки к конкретному складу). |
| | | 306 | | /// </summary> |
| | | 307 | | private static bool ApplyFbsFallbackStocks( |
| | | 308 | | RemainingStockBitrix item, |
| | | 309 | | OzonClient client, |
| | | 310 | | OzonApiFoundInfo ozonInfo, |
| | | 311 | | List<WarehouseMapping> linkageMappings, |
| | | 312 | | IReadOnlyList<WarehouseOzon> warehouseList, |
| | | 313 | | HashSet<string> allowedBitrixStores, |
| | | 314 | | string offerArticle, |
| | | 315 | | long defaultProductId, |
| | | 316 | | HashSet<long> mappedWarehouseIds) |
| | | 317 | | { |
| | 2 | 318 | | var productIdStr = defaultProductId > 0 |
| | 2 | 319 | | ? defaultProductId.ToString() |
| | 2 | 320 | | : ozonInfo.OzonProductId > 0 ? ozonInfo.OzonProductId.ToString() : string.Empty; |
| | 2 | 321 | | var resolvedOfferId = ozonInfo.FoundOfferId ?? offerArticle; |
| | 2 | 322 | | var fbsTotal = ozonInfo.FbsFamilyTotal; |
| | 2 | 323 | | var fallbackUsed = false; |
| | 2 | 324 | | var storesByWarehouseId = new Dictionary<long, (WarehouseOzon Warehouse, List<string> LinkStores)>(); |
| | | 325 | | |
| | 10 | 326 | | foreach (var mapping in linkageMappings) |
| | | 327 | | { |
| | 3 | 328 | | var bitrixName = mapping.BitrixWarehouseName?.Trim(); |
| | 3 | 329 | | if (string.IsNullOrWhiteSpace(bitrixName) || !allowedBitrixStores.Contains(bitrixName!)) |
| | | 330 | | { |
| | | 331 | | continue; |
| | | 332 | | } |
| | | 333 | | |
| | 3 | 334 | | var ozonWarehouse = ResolveOzonWarehouse(mapping, warehouseList); |
| | 3 | 335 | | if (ozonWarehouse == null) |
| | | 336 | | { |
| | | 337 | | continue; |
| | | 338 | | } |
| | | 339 | | |
| | 3 | 340 | | mappedWarehouseIds.Add(ozonWarehouse.WarehouseId); |
| | | 341 | | |
| | 3 | 342 | | if (!storesByWarehouseId.TryGetValue(ozonWarehouse.WarehouseId, out var entry)) |
| | | 343 | | { |
| | 3 | 344 | | entry = (ozonWarehouse, new List<string>()); |
| | 3 | 345 | | storesByWarehouseId[ozonWarehouse.WarehouseId] = entry; |
| | | 346 | | } |
| | | 347 | | |
| | 3 | 348 | | if (!entry.LinkStores.Contains(bitrixName!, StringComparer.OrdinalIgnoreCase)) |
| | | 349 | | { |
| | 3 | 350 | | entry.LinkStores.Add(bitrixName!); |
| | | 351 | | } |
| | | 352 | | } |
| | | 353 | | |
| | | 354 | | // Суммарный FBS+rFBS остаток относится ко всем складам сразу. Если связанных складов |
| | | 355 | | // несколько, приписать эту сумму каждому нельзя: 1 шт на M2 + 1 шт на M2S превращались |
| | | 356 | | // в «2 на каждом складе» и давали вечные ложные Decrease/Clear. В таком случае остаток |
| | | 357 | | // считается неизвестным — строка идёт как пропуск, накат по ней не выполняется. |
| | 2 | 358 | | var stockUnknown = storesByWarehouseId.Count > 1; |
| | | 359 | | |
| | 10 | 360 | | foreach (var (warehouseId, entry) in storesByWarehouseId) |
| | | 361 | | { |
| | 3 | 362 | | var linkStores = entry.LinkStores |
| | 3 | 363 | | .OrderBy(s => s, StringComparer.OrdinalIgnoreCase) |
| | 3 | 364 | | .ToList(); |
| | | 365 | | |
| | 3 | 366 | | UpsertOzonStore(item, client, |
| | 3 | 367 | | warehouseId, |
| | 3 | 368 | | entry.Warehouse.Name ?? "", |
| | 3 | 369 | | stockUnknown ? 0 : fbsTotal, |
| | 3 | 370 | | productIdStr, |
| | 3 | 371 | | resolvedOfferId, |
| | 3 | 372 | | linkStores, |
| | 3 | 373 | | ozonPresentBefore: stockUnknown ? null : fbsTotal, |
| | 3 | 374 | | isFbsFallback: true, |
| | 3 | 375 | | isFbsStockUnknown: stockUnknown); |
| | | 376 | | |
| | 3 | 377 | | fallbackUsed = true; |
| | | 378 | | } |
| | | 379 | | |
| | 2 | 380 | | return fallbackUsed; |
| | | 381 | | } |
| | | 382 | | |
| | | 383 | | /// <summary>Склады по связкам для отображения (без наката Bitrix → Ozon).</summary> |
| | | 384 | | private static void RegisterLinkageWarehouseIdsForDisplay( |
| | | 385 | | IReadOnlyList<WarehouseMapping> linkageMappings, |
| | | 386 | | IReadOnlyList<WarehouseOzon> warehouseList, |
| | | 387 | | HashSet<string> allowedBitrixStores, |
| | | 388 | | HashSet<long> mappedWarehouseIds) |
| | | 389 | | { |
| | 0 | 390 | | foreach (var mapping in linkageMappings) |
| | | 391 | | { |
| | 0 | 392 | | var bitrixName = mapping.BitrixWarehouseName!.Trim(); |
| | 0 | 393 | | if (!allowedBitrixStores.Contains(bitrixName)) |
| | | 394 | | { |
| | | 395 | | continue; |
| | | 396 | | } |
| | | 397 | | |
| | 0 | 398 | | var ozonWarehouse = ResolveOzonWarehouse(mapping, warehouseList); |
| | 0 | 399 | | if (ozonWarehouse != null) |
| | | 400 | | { |
| | 0 | 401 | | mappedWarehouseIds.Add(ozonWarehouse.WarehouseId); |
| | | 402 | | } |
| | | 403 | | } |
| | 0 | 404 | | } |
| | | 405 | | |
| | | 406 | | private static void ApplySingleMapping( |
| | | 407 | | RemainingStockBitrix item, |
| | | 408 | | OzonClient client, |
| | | 409 | | WarehouseMapping mapping, |
| | | 410 | | IReadOnlyList<WarehouseOzon> warehouseList, |
| | | 411 | | HashSet<string> allowedBitrixStores, |
| | | 412 | | string offerArticle, |
| | | 413 | | long defaultProductId, |
| | | 414 | | HashSet<long> mappedWarehouseIds) |
| | | 415 | | { |
| | 3 | 416 | | var bitrixName = mapping.BitrixWarehouseName!.Trim(); |
| | 3 | 417 | | if (!allowedBitrixStores.Contains(bitrixName)) |
| | | 418 | | { |
| | 0 | 419 | | return; |
| | | 420 | | } |
| | | 421 | | |
| | 3 | 422 | | var ozonWarehouse = ResolveOzonWarehouse(mapping, warehouseList); |
| | 3 | 423 | | if (ozonWarehouse == null) |
| | | 424 | | { |
| | 0 | 425 | | return; |
| | | 426 | | } |
| | | 427 | | |
| | 3 | 428 | | mappedWarehouseIds.Add(ozonWarehouse.WarehouseId); |
| | 3 | 429 | | } |
| | | 430 | | |
| | | 431 | | /// <summary>Подтягивает product_id и остатки по всем складам из ответа Ozon, помечая связанные склады.</summary> |
| | | 432 | | private static void EnrichMappedWarehousesFromApi( |
| | | 433 | | RemainingStockBitrix item, |
| | | 434 | | OzonClient client, |
| | | 435 | | JArray warehousesArray, |
| | | 436 | | List<WarehouseMapping> linkageMappings, |
| | | 437 | | IReadOnlyList<WarehouseOzon> warehouseList, |
| | | 438 | | HashSet<string> allowedBitrixStores, |
| | | 439 | | HashSet<long> mappedWarehouseIds, |
| | | 440 | | string offerArticle, |
| | | 441 | | long defaultProductId) |
| | | 442 | | { |
| | 2 | 443 | | if (warehousesArray.Count == 0) |
| | | 444 | | { |
| | 2 | 445 | | return; |
| | | 446 | | } |
| | | 447 | | |
| | 0 | 448 | | foreach (var w in warehousesArray) |
| | | 449 | | { |
| | 0 | 450 | | var warehouseId = w["warehouse_id"]?.Value<long>() ?? 0; |
| | 0 | 451 | | if (warehouseId <= 0) |
| | | 452 | | { |
| | | 453 | | continue; |
| | | 454 | | } |
| | | 455 | | |
| | 0 | 456 | | var linkedBitrixStores = CollectLinkedBitrixStoreNames( |
| | 0 | 457 | | warehouseId, |
| | 0 | 458 | | linkageMappings, |
| | 0 | 459 | | warehouseList, |
| | 0 | 460 | | allowedBitrixStores).ToList(); |
| | | 461 | | |
| | 0 | 462 | | var warehouseName = w["warehouse_name"]?.ToString()?.Trim() |
| | 0 | 463 | | ?? linkageMappings |
| | 0 | 464 | | .Where(m => |
| | 0 | 465 | | { |
| | 0 | 466 | | var resolved = ResolveOzonWarehouse(m, warehouseList); |
| | 0 | 467 | | return resolved?.WarehouseId == warehouseId; |
| | 0 | 468 | | }) |
| | 0 | 469 | | .Select(m => m.OzonWarehouseName?.Trim()) |
| | 0 | 470 | | .FirstOrDefault(name => !string.IsNullOrWhiteSpace(name)) |
| | 0 | 471 | | ?? $"Warehouse {warehouseId}"; |
| | 0 | 472 | | var ozonPresent = w["present"]?.Value<int>() ?? 0; |
| | 0 | 473 | | var productId = w["product_id"]?.ToString(); |
| | 0 | 474 | | if (string.IsNullOrWhiteSpace(productId) && defaultProductId > 0) |
| | | 475 | | { |
| | 0 | 476 | | productId = defaultProductId.ToString(); |
| | | 477 | | } |
| | | 478 | | |
| | | 479 | | // Для отображения в UI используем фактический остаток Ozon (present), |
| | | 480 | | // а не расчетный/связанный остаток Bitrix. |
| | 0 | 481 | | var displayAmount = ozonPresent; |
| | | 482 | | |
| | 0 | 483 | | UpsertOzonStore( |
| | 0 | 484 | | item, |
| | 0 | 485 | | client, |
| | 0 | 486 | | warehouseId, |
| | 0 | 487 | | warehouseName, |
| | 0 | 488 | | displayAmount, |
| | 0 | 489 | | productId ?? string.Empty, |
| | 0 | 490 | | offerArticle, |
| | 0 | 491 | | linkedBitrixStores, |
| | 0 | 492 | | ozonPresentBefore: ozonPresent); |
| | | 493 | | } |
| | 0 | 494 | | } |
| | | 495 | | |
| | | 496 | | /// <summary>Убирает накат на склады клиента, не входящие в активные связи с остатком Bitrix.</summary> |
| | | 497 | | private static void ZeroUnmappedClientStores( |
| | | 498 | | RemainingStockBitrix item, |
| | | 499 | | string clientName, |
| | | 500 | | HashSet<long> mappedWarehouseIds) |
| | | 501 | | { |
| | 0 | 502 | | lock (item.OzonStores) |
| | | 503 | | { |
| | 0 | 504 | | item.OzonStores.RemoveAll(s => |
| | 0 | 505 | | string.Equals(s.ClientName, clientName, StringComparison.OrdinalIgnoreCase) && |
| | 0 | 506 | | s.StoreId > 0 && |
| | 0 | 507 | | !mappedWarehouseIds.Contains(s.StoreId)); |
| | 0 | 508 | | } |
| | 0 | 509 | | } |
| | | 510 | | |
| | | 511 | | public static WarehouseOzon? ResolveOzonWarehouse(WarehouseMapping mapping, IReadOnlyList<WarehouseOzon> warehouseLi |
| | | 512 | | { |
| | 19 | 513 | | if (!string.IsNullOrWhiteSpace(mapping.OzonWarehouseId) && |
| | 19 | 514 | | long.TryParse(mapping.OzonWarehouseId.Trim(), out var warehouseId)) |
| | | 515 | | { |
| | 35 | 516 | | var byId = warehouseList.FirstOrDefault(w => w.WarehouseId == warehouseId); |
| | 16 | 517 | | if (byId != null) |
| | | 518 | | { |
| | 14 | 519 | | return byId; |
| | | 520 | | } |
| | | 521 | | } |
| | | 522 | | |
| | 5 | 523 | | if (!string.IsNullOrWhiteSpace(mapping.OzonWarehouseName)) |
| | | 524 | | { |
| | 5 | 525 | | return warehouseList.FirstOrDefault(w => |
| | 10 | 526 | | string.Equals(w.Name?.Trim(), mapping.OzonWarehouseName.Trim(), StringComparison.OrdinalIgnoreCase)); |
| | | 527 | | } |
| | | 528 | | |
| | 0 | 529 | | return null; |
| | | 530 | | } |
| | | 531 | | |
| | | 532 | | /// <summary>Суммирует остатки 1С по всем складам из <paramref name="linkStores"/>.</summary> |
| | | 533 | | public static int GetLinkedOneCQuantity(RemainingStockBitrix item, IEnumerable<string>? linkStores) |
| | | 534 | | { |
| | 5 | 535 | | if (linkStores == null) |
| | | 536 | | { |
| | 0 | 537 | | return 0; |
| | | 538 | | } |
| | | 539 | | |
| | 5 | 540 | | var total = 0; |
| | 26 | 541 | | foreach (var linkStore in linkStores) |
| | | 542 | | { |
| | 8 | 543 | | if (string.IsNullOrWhiteSpace(linkStore)) |
| | | 544 | | { |
| | | 545 | | continue; |
| | | 546 | | } |
| | | 547 | | |
| | 8 | 548 | | total += GetBitrixAmount(item, linkStore.Trim()); |
| | | 549 | | } |
| | | 550 | | |
| | 5 | 551 | | return total; |
| | | 552 | | } |
| | | 553 | | |
| | | 554 | | /// <summary>Подпись связанных складов 1С (через запятую).</summary> |
| | | 555 | | public static string GetLinkedOneCStoreLabel(IEnumerable<string>? linkStores) |
| | | 556 | | { |
| | 2 | 557 | | if (linkStores == null) |
| | | 558 | | { |
| | 0 | 559 | | return "—"; |
| | | 560 | | } |
| | | 561 | | |
| | 2 | 562 | | var names = linkStores |
| | 5 | 563 | | .Where(s => !string.IsNullOrWhiteSpace(s)) |
| | 5 | 564 | | .Select(s => s.Trim()) |
| | 2 | 565 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 4 | 566 | | .OrderBy(s => s, StringComparer.OrdinalIgnoreCase) |
| | 2 | 567 | | .ToList(); |
| | | 568 | | |
| | 2 | 569 | | return names.Count == 0 ? "—" : string.Join(", ", names); |
| | | 570 | | } |
| | | 571 | | |
| | | 572 | | /// <summary>Есть ли хотя бы один связанный склад 1С в <paramref name="item"/>.</summary> |
| | | 573 | | public static bool HasLinkedOneCStore(RemainingStockBitrix item, IEnumerable<string>? linkStores) |
| | | 574 | | { |
| | 2 | 575 | | if (linkStores == null || item.Stores == null) |
| | | 576 | | { |
| | 0 | 577 | | return false; |
| | | 578 | | } |
| | | 579 | | |
| | 2 | 580 | | return linkStores.Any(ls => |
| | 5 | 581 | | !string.IsNullOrWhiteSpace(ls) && |
| | 8 | 582 | | item.Stores.Any(s => string.Equals(s.Title?.Trim(), ls.Trim(), StringComparison.OrdinalIgnoreCase))); |
| | | 583 | | } |
| | | 584 | | |
| | | 585 | | /// <summary>Суммирует резерв заказов по всем связанным складам 1С.</summary> |
| | | 586 | | public static int GetLinkedReservedQuantity( |
| | | 587 | | string? article, |
| | | 588 | | IEnumerable<string>? linkStores, |
| | | 589 | | IReadOnlyDictionary<string, Dictionary<string, int>> reserveMap) |
| | | 590 | | { |
| | 21 | 591 | | var normalizedArticle = OrderDataFilterManager.NormalizeArticleForSearch(article); |
| | 21 | 592 | | if (string.IsNullOrEmpty(normalizedArticle) || linkStores == null || |
| | 21 | 593 | | !reserveMap.TryGetValue(normalizedArticle, out var storeReserves)) |
| | | 594 | | { |
| | 13 | 595 | | return 0; |
| | | 596 | | } |
| | | 597 | | |
| | 8 | 598 | | var total = 0; |
| | 34 | 599 | | foreach (var linkStore in linkStores) |
| | | 600 | | { |
| | 9 | 601 | | if (string.IsNullOrWhiteSpace(linkStore)) |
| | | 602 | | { |
| | | 603 | | continue; |
| | | 604 | | } |
| | | 605 | | |
| | 9 | 606 | | if (storeReserves.TryGetValue(linkStore.Trim(), out var reserved)) |
| | | 607 | | { |
| | 8 | 608 | | total += reserved; |
| | | 609 | | } |
| | | 610 | | } |
| | | 611 | | |
| | 8 | 612 | | return total; |
| | | 613 | | } |
| | | 614 | | |
| | | 615 | | private static int GetBitrixAmount(RemainingStockBitrix item, string bitrixStoreName) |
| | | 616 | | { |
| | 8 | 617 | | var store = item.Stores.FirstOrDefault(s => |
| | 19 | 618 | | string.Equals(s.Title?.Trim(), bitrixStoreName, StringComparison.OrdinalIgnoreCase)); |
| | 8 | 619 | | if (store == null) |
| | | 620 | | { |
| | 1 | 621 | | return 0; |
| | | 622 | | } |
| | | 623 | | |
| | 7 | 624 | | return (int)Math.Max(0, Math.Round(store.Amount)); |
| | | 625 | | } |
| | | 626 | | |
| | | 627 | | private static void UpsertOzonStore( |
| | | 628 | | RemainingStockBitrix item, |
| | | 629 | | OzonClient client, |
| | | 630 | | long warehouseId, |
| | | 631 | | string warehouseName, |
| | | 632 | | int displayAmount, |
| | | 633 | | string? productId, |
| | | 634 | | string offerArticle, |
| | | 635 | | List<string> linkedBitrixStores, |
| | | 636 | | int? ozonPresentBefore = null, |
| | | 637 | | bool isFbsFallback = false, |
| | | 638 | | bool isFbsStockUnknown = false) |
| | | 639 | | { |
| | 3 | 640 | | if (IsInactiveProduct(item)) |
| | | 641 | | { |
| | 0 | 642 | | if (ozonPresentBefore.HasValue) |
| | | 643 | | { |
| | 0 | 644 | | displayAmount = ozonPresentBefore.Value; |
| | | 645 | | } |
| | | 646 | | |
| | 0 | 647 | | lock (item.OzonStores) |
| | | 648 | | { |
| | 0 | 649 | | var existing = item.OzonStores.FirstOrDefault(s => |
| | 0 | 650 | | string.Equals(s.ClientName, client.Name, StringComparison.OrdinalIgnoreCase) && |
| | 0 | 651 | | (warehouseId > 0 |
| | 0 | 652 | | ? s.StoreId == warehouseId |
| | 0 | 653 | | : string.Equals(s.Title, warehouseName, StringComparison.OrdinalIgnoreCase))); |
| | | 654 | | |
| | 0 | 655 | | if (existing != null) |
| | | 656 | | { |
| | 0 | 657 | | if (ozonPresentBefore.HasValue) |
| | | 658 | | { |
| | 0 | 659 | | existing.OzonPresentOnOzon = ozonPresentBefore.Value; |
| | 0 | 660 | | existing.Amount = ozonPresentBefore.Value; |
| | | 661 | | } |
| | | 662 | | |
| | 0 | 663 | | existing.Title = warehouseName; |
| | 0 | 664 | | existing.LinkStores = MergeLinkStores(existing.LinkStores, linkedBitrixStores); |
| | 0 | 665 | | if (!string.IsNullOrWhiteSpace(productId)) |
| | | 666 | | { |
| | 0 | 667 | | existing.ProductId = productId; |
| | | 668 | | } |
| | | 669 | | |
| | 0 | 670 | | existing.PendingOzonApiSync = false; |
| | 0 | 671 | | return; |
| | | 672 | | } |
| | | 673 | | |
| | 0 | 674 | | if (!ozonPresentBefore.HasValue && warehouseId <= 0) |
| | | 675 | | { |
| | 0 | 676 | | return; |
| | | 677 | | } |
| | | 678 | | |
| | 0 | 679 | | item.OzonStores.Add(new StockByStore |
| | 0 | 680 | | { |
| | 0 | 681 | | StoreId = warehouseId, |
| | 0 | 682 | | Title = warehouseName, |
| | 0 | 683 | | Amount = displayAmount, |
| | 0 | 684 | | ClientName = client.Name, |
| | 0 | 685 | | ClientId = client.DecryptClientId, |
| | 0 | 686 | | ProductId = productId ?? string.Empty, |
| | 0 | 687 | | OfferId = offerArticle, |
| | 0 | 688 | | LinkStores = linkedBitrixStores.ToList(), |
| | 0 | 689 | | OzonPresentOnOzon = ozonPresentBefore, |
| | 0 | 690 | | PendingOzonApiSync = false, |
| | 0 | 691 | | IsFbsFallback = isFbsFallback, |
| | 0 | 692 | | IsFbsStockUnknown = isFbsStockUnknown |
| | 0 | 693 | | }); |
| | 0 | 694 | | } |
| | | 695 | | |
| | 0 | 696 | | return; |
| | | 697 | | } |
| | | 698 | | |
| | 3 | 699 | | lock (item.OzonStores) |
| | | 700 | | { |
| | 3 | 701 | | var existing = item.OzonStores.FirstOrDefault(s => |
| | 4 | 702 | | string.Equals(s.ClientName, client.Name, StringComparison.OrdinalIgnoreCase) && |
| | 4 | 703 | | (warehouseId > 0 |
| | 4 | 704 | | ? s.StoreId == warehouseId |
| | 4 | 705 | | : string.Equals(s.Title, warehouseName, StringComparison.OrdinalIgnoreCase))); |
| | | 706 | | |
| | 3 | 707 | | if (existing != null) |
| | | 708 | | { |
| | 0 | 709 | | if (ozonPresentBefore.HasValue) |
| | | 710 | | { |
| | 0 | 711 | | existing.OzonPresentOnOzon = ozonPresentBefore.Value; |
| | | 712 | | } |
| | | 713 | | |
| | 0 | 714 | | existing.Amount = displayAmount; |
| | 0 | 715 | | existing.Title = warehouseName; |
| | 0 | 716 | | existing.LinkStores = MergeLinkStores(existing.LinkStores, linkedBitrixStores); |
| | 0 | 717 | | if (!string.IsNullOrWhiteSpace(productId)) |
| | | 718 | | { |
| | 0 | 719 | | existing.ProductId = productId; |
| | | 720 | | } |
| | | 721 | | |
| | | 722 | | // Авто-отправка в Ozon только вручную (кнопки на странице / фоновые задания). |
| | 0 | 723 | | existing.PendingOzonApiSync = false; |
| | 0 | 724 | | return; |
| | | 725 | | } |
| | | 726 | | |
| | 3 | 727 | | var ozonPresent = ozonPresentBefore; |
| | 3 | 728 | | item.OzonStores.Add(new StockByStore |
| | 3 | 729 | | { |
| | 3 | 730 | | StoreId = warehouseId, |
| | 3 | 731 | | Title = warehouseName, |
| | 3 | 732 | | Amount = displayAmount, |
| | 3 | 733 | | ClientName = client.Name, |
| | 3 | 734 | | ClientId = client.DecryptClientId, |
| | 3 | 735 | | ProductId = productId ?? string.Empty, |
| | 3 | 736 | | OfferId = offerArticle, |
| | 3 | 737 | | LinkStores = linkedBitrixStores.ToList(), |
| | 3 | 738 | | OzonPresentOnOzon = ozonPresent, |
| | 3 | 739 | | PendingOzonApiSync = false, |
| | 3 | 740 | | IsFbsFallback = isFbsFallback, |
| | 3 | 741 | | IsFbsStockUnknown = isFbsStockUnknown |
| | 3 | 742 | | }); |
| | 3 | 743 | | } |
| | 3 | 744 | | } |
| | | 745 | | |
| | | 746 | | private static long ExtractDefaultProductId(JArray warehousesArray) |
| | | 747 | | { |
| | 0 | 748 | | foreach (var w in warehousesArray) |
| | | 749 | | { |
| | 0 | 750 | | var productId = w["product_id"]?.Value<long>() ?? 0; |
| | 0 | 751 | | if (productId > 0) |
| | | 752 | | { |
| | 0 | 753 | | return productId; |
| | | 754 | | } |
| | | 755 | | } |
| | | 756 | | |
| | 0 | 757 | | return 0; |
| | 0 | 758 | | } |
| | | 759 | | |
| | | 760 | | private static List<string>? MergeLinkStores(List<string>? current, IEnumerable<string> additional) |
| | | 761 | | { |
| | 0 | 762 | | var set = new HashSet<string>(current ?? Enumerable.Empty<string>(), StringComparer.OrdinalIgnoreCase); |
| | 0 | 763 | | foreach (var a in additional) |
| | | 764 | | { |
| | 0 | 765 | | if (!string.IsNullOrWhiteSpace(a)) |
| | | 766 | | { |
| | 0 | 767 | | set.Add(a.Trim()); |
| | | 768 | | } |
| | | 769 | | } |
| | | 770 | | |
| | 0 | 771 | | return set.ToList(); |
| | | 772 | | } |
| | | 773 | | |
| | | 774 | | } |