| | | 1 | | namespace Services.BitrixStockServices; |
| | | 2 | | |
| | | 3 | | /// <summary> |
| | | 4 | | /// Сопоставление offer_id из Ozon seller_stocks с ключами строк отчёта BitrixStock (этап 5). |
| | | 5 | | /// Учитывает суффиксы [N], разный регистр бренда и строки NotFound с OzonWarehouseId=0. |
| | | 6 | | /// </summary> |
| | | 7 | | public static class BitrixStockOrphanOfferMatching |
| | | 8 | | { |
| | | 9 | | public sealed class ReportKeyIndex |
| | | 10 | | { |
| | 40 | 11 | | public HashSet<(string OfferId, string WarehouseId)> ExactByWarehouse { get; } = new(); |
| | 39 | 12 | | public HashSet<(string OfferId, string WarehouseId)> NormalizedByWarehouse { get; } = new(); |
| | | 13 | | } |
| | | 14 | | |
| | | 15 | | public static ReportKeyIndex BuildReportKeyIndex(IEnumerable<ReportLineKey> lines) |
| | | 16 | | { |
| | 16 | 17 | | var index = new ReportKeyIndex(); |
| | 64 | 18 | | foreach (var line in lines) |
| | | 19 | | { |
| | 16 | 20 | | var offerId = line.OfferId?.Trim(); |
| | 16 | 21 | | if (string.IsNullOrEmpty(offerId)) |
| | | 22 | | continue; |
| | | 23 | | |
| | 14 | 24 | | var warehouseId = line.WarehouseId?.Trim() ?? string.Empty; |
| | 14 | 25 | | var exact = offerId.ToLowerInvariant(); |
| | 14 | 26 | | var normalized = NormalizeOfferId(offerId); |
| | 14 | 27 | | var hasMappedWarehouse = long.TryParse(warehouseId, out var wid) && wid > 0; |
| | | 28 | | |
| | 14 | 29 | | if (hasMappedWarehouse) |
| | | 30 | | { |
| | 10 | 31 | | index.ExactByWarehouse.Add((exact, warehouseId)); |
| | 10 | 32 | | if (!string.IsNullOrEmpty(normalized)) |
| | 10 | 33 | | index.NormalizedByWarehouse.Add((normalized, warehouseId)); |
| | | 34 | | } |
| | | 35 | | } |
| | | 36 | | |
| | 16 | 37 | | return index; |
| | | 38 | | } |
| | | 39 | | |
| | | 40 | | public static bool IsCoveredByReport(ReportKeyIndex index, string ozonOriginalOfferId, string warehouseId) |
| | | 41 | | { |
| | 7 | 42 | | return ExplainCoverage(index, ozonOriginalOfferId, warehouseId) != null; |
| | | 43 | | } |
| | | 44 | | |
| | | 45 | | /// <summary> |
| | | 46 | | /// Делит непокрытые отчётом строки на настоящих сирот и полностью зарезервированные. |
| | | 47 | | /// Сирота — только та строка, у которой есть свободный остаток (<c>free_stock > 0</c>): именно её |
| | | 48 | | /// покупатель ещё может заказать. При <c>present = reserved</c> товар уже недоступен, а Ozon не |
| | | 49 | | /// опускает остаток ниже резерва — такие строки обнулялись вхолостую каждый прогон. |
| | | 50 | | /// </summary> |
| | | 51 | | public static (List<OzonCatalogStockRow> Orphans, List<OzonCatalogStockRow> FullyReserved) SplitByFreeStock( |
| | | 52 | | IEnumerable<OzonCatalogStockRow> potentialOrphans) |
| | | 53 | | { |
| | 4 | 54 | | var orphans = new List<OzonCatalogStockRow>(); |
| | 4 | 55 | | var fullyReserved = new List<OzonCatalogStockRow>(); |
| | | 56 | | |
| | 20 | 57 | | foreach (var row in potentialOrphans) |
| | | 58 | | { |
| | 6 | 59 | | if (row.FreeQty > 0) |
| | 4 | 60 | | orphans.Add(row); |
| | | 61 | | else |
| | 2 | 62 | | fullyReserved.Add(row); |
| | | 63 | | } |
| | | 64 | | |
| | 4 | 65 | | return (orphans, fullyReserved); |
| | | 66 | | } |
| | | 67 | | |
| | | 68 | | /// <summary>Возвращает имя сработавшего правила или null если не покрыто.</summary> |
| | | 69 | | public static string? ExplainCoverage(ReportKeyIndex index, string ozonOriginalOfferId, string warehouseId) |
| | | 70 | | { |
| | 15 | 71 | | if (string.IsNullOrWhiteSpace(ozonOriginalOfferId)) |
| | 2 | 72 | | return null; |
| | | 73 | | |
| | 13 | 74 | | var exact = ozonOriginalOfferId.Trim().ToLowerInvariant(); |
| | 13 | 75 | | var normalized = NormalizeOfferId(ozonOriginalOfferId); |
| | 13 | 76 | | var wh = warehouseId.Trim(); |
| | | 77 | | |
| | 13 | 78 | | if (index.ExactByWarehouse.Contains((exact, wh))) |
| | 2 | 79 | | return "exact"; |
| | 11 | 80 | | if (!string.IsNullOrEmpty(normalized) && index.NormalizedByWarehouse.Contains((normalized, wh))) |
| | 2 | 81 | | return "normalized_wh"; |
| | 9 | 82 | | return null; |
| | | 83 | | } |
| | | 84 | | |
| | | 85 | | /// <summary> |
| | | 86 | | /// Нормализует offer_id: lower + убирает вариант [N] после кода бренда (KJ2288=MSM[5] → kj2288=msm). |
| | | 87 | | /// </summary> |
| | | 88 | | public static string NormalizeOfferId(string? offerId) |
| | | 89 | | { |
| | 38 | 90 | | if (string.IsNullOrWhiteSpace(offerId)) |
| | 3 | 91 | | return string.Empty; |
| | | 92 | | |
| | 35 | 93 | | offerId = offerId.Trim(); |
| | 35 | 94 | | var eqIdx = offerId.IndexOf('='); |
| | 35 | 95 | | if (eqIdx <= 0) |
| | 2 | 96 | | return offerId.ToLowerInvariant(); |
| | | 97 | | |
| | 33 | 98 | | var article = offerId[..eqIdx].Trim(); |
| | 33 | 99 | | var brandPart = offerId[(eqIdx + 1)..].Trim(); |
| | 33 | 100 | | var bracketIdx = brandPart.IndexOf('['); |
| | 33 | 101 | | if (bracketIdx >= 0) |
| | 7 | 102 | | brandPart = brandPart[..bracketIdx].Trim(); |
| | | 103 | | |
| | 33 | 104 | | return $"{article}={brandPart}".ToLowerInvariant(); |
| | | 105 | | } |
| | | 106 | | |
| | | 107 | | /// <summary> |
| | | 108 | | /// Извлекает размер партии из OfferId: "9046709030=TYT[5]" → 5. Нет [N] или [1] → 1. |
| | | 109 | | /// </summary> |
| | | 110 | | public static int ExtractBatchMultiplier(string? offerId) |
| | | 111 | | { |
| | 113 | 112 | | if (string.IsNullOrWhiteSpace(offerId)) return 1; |
| | 105 | 113 | | var start = offerId.LastIndexOf('['); |
| | 105 | 114 | | var end = offerId.LastIndexOf(']'); |
| | 202 | 115 | | if (start < 0 || end <= start) return 1; |
| | 8 | 116 | | return int.TryParse(offerId[(start + 1)..end], out var n) && n > 1 ? n : 1; |
| | | 117 | | } |
| | | 118 | | |
| | | 119 | | public static string ExtractArticle(string? offerId) |
| | | 120 | | { |
| | 7 | 121 | | if (string.IsNullOrWhiteSpace(offerId)) |
| | 2 | 122 | | return string.Empty; |
| | | 123 | | |
| | 5 | 124 | | offerId = offerId.Trim(); |
| | 5 | 125 | | var eqIdx = offerId.IndexOf('='); |
| | 5 | 126 | | return (eqIdx > 0 ? offerId[..eqIdx] : offerId).Trim().ToLowerInvariant(); |
| | | 127 | | } |
| | | 128 | | |
| | | 129 | | /// <summary>Возвращает код производителя из <c>ARTICLE=PREFIX[N]</c>, иначе пустую строку.</summary> |
| | | 130 | | public static string ExtractMarketPrefix(string? offerId) |
| | | 131 | | { |
| | 6 | 132 | | if (string.IsNullOrWhiteSpace(offerId)) |
| | 0 | 133 | | return string.Empty; |
| | | 134 | | |
| | 6 | 135 | | var eqIdx = offerId.IndexOf('='); |
| | 6 | 136 | | if (eqIdx <= 0 || eqIdx == offerId.Length - 1) |
| | 1 | 137 | | return string.Empty; |
| | | 138 | | |
| | 5 | 139 | | var value = offerId[(eqIdx + 1)..].Trim(); |
| | 5 | 140 | | var bracketIdx = value.IndexOf('['); |
| | 5 | 141 | | return (bracketIdx >= 0 ? value[..bracketIdx] : value).Trim().ToUpperInvariant(); |
| | | 142 | | } |
| | | 143 | | |
| | | 144 | | public sealed class ReportLineKey |
| | | 145 | | { |
| | 48 | 146 | | public string OfferId { get; init; } = string.Empty; |
| | 46 | 147 | | public string WarehouseId { get; init; } = string.Empty; |
| | 16 | 148 | | public string? Article { get; init; } |
| | | 149 | | } |
| | | 150 | | } |