| | | 1 | | |
| | | 2 | | namespace Services.BitrixStockServices; |
| | | 3 | | |
| | | 4 | | /// <summary> |
| | | 5 | | /// Агрегация заказов «Не указан» / «Заказан реализатору» в карту резерва (артикул + склад). |
| | | 6 | | /// </summary> |
| | | 7 | | public static class OrderReserveAggregation |
| | | 8 | | { |
| | | 9 | | public static string ResolveOrderNumber(string? shipmentNumber, string? key, int id) |
| | | 10 | | { |
| | 7 | 11 | | if (!string.IsNullOrWhiteSpace(shipmentNumber)) |
| | 5 | 12 | | return shipmentNumber.Trim(); |
| | 2 | 13 | | if (!string.IsNullOrWhiteSpace(key)) |
| | 1 | 14 | | return key.Trim(); |
| | 1 | 15 | | return $"#{id}"; |
| | | 16 | | } |
| | | 17 | | |
| | | 18 | | public static int ResolveReserveQty(int? quantity, string? productKey) |
| | | 19 | | { |
| | 5 | 20 | | var qty = quantity ?? 1; |
| | 5 | 21 | | return qty * OzonDomains.Nomenclature.ProductKeyParser.BatchMultiplier(productKey); |
| | | 22 | | } |
| | | 23 | | |
| | | 24 | | public static string? ResolveWarehouseName(string? warehouseName, string? zasylValue) => |
| | 6 | 25 | | !string.IsNullOrWhiteSpace(warehouseName) ? warehouseName.Trim() |
| | 6 | 26 | | : !string.IsNullOrWhiteSpace(zasylValue) ? zasylValue.Trim() |
| | 6 | 27 | | : null; |
| | | 28 | | |
| | | 29 | | public static List<OrderReserveLineDto> BuildLines( |
| | | 30 | | IEnumerable<OrderReserveSourceRow> rows, |
| | | 31 | | IReadOnlySet<string>? storeFilter) |
| | | 32 | | { |
| | 3 | 33 | | var grouped = new Dictionary<(string Article, string Store), (int Qty, Dictionary<string, OrderReserveOrderDto> |
| | | 34 | | |
| | 18 | 35 | | foreach (var row in rows) |
| | | 36 | | { |
| | 6 | 37 | | if (string.IsNullOrWhiteSpace(row.Article)) continue; |
| | 6 | 38 | | if (string.IsNullOrWhiteSpace(row.StatusName)) continue; |
| | | 39 | | |
| | 5 | 40 | | var warehouseName = ResolveWarehouseName(row.WarehouseName, row.ZasylValue); |
| | 5 | 41 | | if (warehouseName == null) continue; |
| | | 42 | | |
| | 5 | 43 | | if (storeFilter is { Count: > 0 } && !storeFilter.Contains(warehouseName)) |
| | | 44 | | continue; |
| | | 45 | | |
| | 4 | 46 | | var qty = ResolveReserveQty(row.Quantity, row.ProductKey); |
| | 4 | 47 | | var orderNumber = ResolveOrderNumber(row.ShipmentNumber, row.Key, row.Id); |
| | 4 | 48 | | var key = (row.Article.Trim(), warehouseName); |
| | 4 | 49 | | var orderDto = new OrderReserveOrderDto |
| | 4 | 50 | | { |
| | 4 | 51 | | OrderNumber = orderNumber, |
| | 4 | 52 | | ShipmentNumber = string.IsNullOrWhiteSpace(row.ShipmentNumber) ? null : row.ShipmentNumber.Trim(), |
| | 4 | 53 | | ProcessingDate = row.ProcessingDate, |
| | 4 | 54 | | StatusName = row.StatusName.Trim(), |
| | 4 | 55 | | StatusColor = string.IsNullOrWhiteSpace(row.StatusColor) ? "#ffffff" : row.StatusColor.Trim(), |
| | 4 | 56 | | }; |
| | | 57 | | |
| | 4 | 58 | | if (grouped.TryGetValue(key, out var existing)) |
| | | 59 | | { |
| | 1 | 60 | | existing.Qty += qty; |
| | 1 | 61 | | existing.Orders[orderNumber] = orderDto; |
| | 1 | 62 | | grouped[key] = existing; |
| | | 63 | | } |
| | | 64 | | else |
| | | 65 | | { |
| | 3 | 66 | | grouped[key] = (qty, new Dictionary<string, OrderReserveOrderDto>(StringComparer.OrdinalIgnoreCase) |
| | 3 | 67 | | { |
| | 3 | 68 | | [orderNumber] = orderDto |
| | 3 | 69 | | }); |
| | | 70 | | } |
| | | 71 | | } |
| | | 72 | | |
| | 3 | 73 | | return grouped |
| | 3 | 74 | | .Select(kvp => new OrderReserveLineDto |
| | 3 | 75 | | { |
| | 3 | 76 | | Article = kvp.Key.Article, |
| | 3 | 77 | | Store = kvp.Key.Store, |
| | 3 | 78 | | ReservedQty = kvp.Value.Qty, |
| | 3 | 79 | | OrderCount = kvp.Value.Orders.Count, |
| | 3 | 80 | | OrderNumbers = kvp.Value.Orders.Keys |
| | 4 | 81 | | .OrderBy(n => n, StringComparer.OrdinalIgnoreCase) |
| | 3 | 82 | | .ToList(), |
| | 3 | 83 | | Orders = kvp.Value.Orders.Values |
| | 4 | 84 | | .OrderBy(o => o.OrderNumber, StringComparer.OrdinalIgnoreCase) |
| | 3 | 85 | | .ToList(), |
| | 3 | 86 | | }) |
| | 3 | 87 | | .OrderBy(l => l.Article, StringComparer.OrdinalIgnoreCase) |
| | 3 | 88 | | .ThenBy(l => l.Store, StringComparer.OrdinalIgnoreCase) |
| | 3 | 89 | | .ToList(); |
| | | 90 | | } |
| | | 91 | | } |
| | | 92 | | |
| | | 93 | | public sealed class OrderReserveSourceRow |
| | | 94 | | { |
| | | 95 | | public int Id { get; init; } |
| | | 96 | | public string? Article { get; init; } |
| | | 97 | | public string? ProductKey { get; init; } |
| | | 98 | | public int? Quantity { get; init; } |
| | | 99 | | public string? WarehouseName { get; init; } |
| | | 100 | | public string? ZasylValue { get; init; } |
| | | 101 | | public string? ShipmentNumber { get; init; } |
| | | 102 | | public string? Key { get; init; } |
| | | 103 | | public DateTime? ProcessingDate { get; init; } |
| | | 104 | | public string? StatusName { get; init; } |
| | | 105 | | public string? StatusColor { get; init; } |
| | | 106 | | } |