| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using OzonDomains.Models; |
| | | 3 | | using OzonRepositories.Context; |
| | | 4 | | |
| | | 5 | | namespace Services.BackgroundJobsServices; |
| | | 6 | | |
| | | 7 | | public sealed class WarehouseSelectionResolver |
| | | 8 | | { |
| | | 9 | | private const string ZasylKey = "Засыл"; |
| | | 10 | | |
| | | 11 | | public sealed class SenderWarehouseResolution |
| | | 12 | | { |
| | 0 | 13 | | public string? SenderWarehouseName { get; set; } |
| | 0 | 14 | | public List<string> Errors { get; } = new(); |
| | 0 | 15 | | public bool HasErrors => Errors.Count > 0; |
| | | 16 | | } |
| | | 17 | | |
| | | 18 | | public sealed class RecipientWarehouseResolution |
| | | 19 | | { |
| | 7 | 20 | | public List<string> PreferredRecipientWarehouses { get; } = new(); |
| | 3 | 21 | | public List<string> Warnings { get; } = new(); |
| | 2 | 22 | | public List<string> BlockingErrors { get; } = new(); |
| | 0 | 23 | | public bool HasBlockingErrors => BlockingErrors.Count > 0; |
| | | 24 | | } |
| | | 25 | | |
| | | 26 | | public sealed class RecipientByOrderResolution |
| | | 27 | | { |
| | 34 | 28 | | public Dictionary<int, string> RecipientByOrderId { get; } = new(); |
| | 21 | 29 | | public Dictionary<int, string> RecipientExplanationByOrderId { get; } = new(); |
| | 19 | 30 | | public HashSet<int> ReturnWarehouseOrderIds { get; } = []; |
| | 14 | 31 | | public List<string> Warnings { get; } = new(); |
| | 37 | 32 | | public List<string> BlockingErrors { get; } = new(); |
| | 14 | 33 | | public bool HasBlockingErrors => BlockingErrors.Count > 0; |
| | | 34 | | } |
| | | 35 | | |
| | | 36 | | /// <summary>Вариант склада возврата для введённого в форме засыла.</summary> |
| | 3 | 37 | | public sealed record CustomerReturnZasylOption( |
| | 2 | 38 | | string Warehouse, |
| | 1 | 39 | | string Explanation, |
| | 4 | 40 | | bool UsesReturnWarehouse); |
| | | 41 | | |
| | | 42 | | /// <summary> |
| | | 43 | | /// Варианты засыла одного заказа для браузера: <see cref="Fallback"/> применяется при пустом |
| | | 44 | | /// поле «Засыл», <see cref="Options"/> — при вводе конкретного значения. |
| | | 45 | | /// </summary> |
| | 1 | 46 | | public sealed record CustomerReturnZasylOrderOptions( |
| | 1 | 47 | | Dictionary<string, CustomerReturnZasylOption> Options, |
| | 2 | 48 | | CustomerReturnZasylOption? Fallback); |
| | | 49 | | |
| | | 50 | | public sealed class CommissionerSenderWarehouseResolution |
| | | 51 | | { |
| | 10 | 52 | | public Dictionary<int, string> WarehouseByOrderId { get; } = new(); |
| | 10 | 53 | | public List<string> BlockingErrors { get; } = new(); |
| | 4 | 54 | | public bool HasBlockingErrors => BlockingErrors.Count > 0; |
| | | 55 | | } |
| | | 56 | | |
| | | 57 | | private readonly ApplicationDbContext _context; |
| | | 58 | | |
| | 21 | 59 | | public WarehouseSelectionResolver(ApplicationDbContext context) |
| | | 60 | | { |
| | 21 | 61 | | _context = context; |
| | 21 | 62 | | } |
| | | 63 | | |
| | | 64 | | public async Task<SenderWarehouseResolution> ResolveSenderWarehouseAsync(IEnumerable<Order> orders) |
| | | 65 | | { |
| | 0 | 66 | | var resolution = new SenderWarehouseResolution(); |
| | 0 | 67 | | var sourceOrders = orders?.ToList() ?? new List<Order>(); |
| | | 68 | | |
| | 0 | 69 | | if (!sourceOrders.Any()) |
| | | 70 | | { |
| | 0 | 71 | | resolution.Errors.Add("Не выбраны заказы для определения склада отправителя."); |
| | 0 | 72 | | return resolution; |
| | | 73 | | } |
| | | 74 | | |
| | 0 | 75 | | var missingClientOrderIds = sourceOrders |
| | 0 | 76 | | .Where(o => o.OzonClient == null || string.IsNullOrWhiteSpace(o.OzonClient.WarehouseName)) |
| | 0 | 77 | | .Select(o => o.Id) |
| | 0 | 78 | | .Distinct() |
| | 0 | 79 | | .ToList(); |
| | | 80 | | |
| | 0 | 81 | | if (missingClientOrderIds.Count > 0) |
| | | 82 | | { |
| | 0 | 83 | | var dbOrders = await _context.Orders |
| | 0 | 84 | | .AsNoTracking() |
| | 0 | 85 | | .Include(o => o.OzonClient) |
| | 0 | 86 | | .Where(o => missingClientOrderIds.Contains(o.Id)) |
| | 0 | 87 | | .ToListAsync(); |
| | 0 | 88 | | var dbById = dbOrders.ToDictionary(o => o.Id); |
| | | 89 | | |
| | 0 | 90 | | foreach (var order in sourceOrders.Where(o => missingClientOrderIds.Contains(o.Id))) |
| | | 91 | | { |
| | 0 | 92 | | if (dbById.TryGetValue(order.Id, out var dbOrder)) |
| | | 93 | | { |
| | 0 | 94 | | order.OzonClient = dbOrder.OzonClient; |
| | | 95 | | } |
| | | 96 | | } |
| | | 97 | | } |
| | | 98 | | |
| | 0 | 99 | | var resolvedNames = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | 0 | 100 | | foreach (var order in sourceOrders) |
| | | 101 | | { |
| | 0 | 102 | | var senderWarehouseName = order.OzonClient?.WarehouseName?.Trim(); |
| | 0 | 103 | | if (string.IsNullOrWhiteSpace(senderWarehouseName)) |
| | | 104 | | { |
| | 0 | 105 | | resolution.Errors.Add( |
| | 0 | 106 | | $"Заказ {order.ShipmentNumber}: у клиента Ozon не заполнено поле 'Название склада'."); |
| | 0 | 107 | | continue; |
| | | 108 | | } |
| | | 109 | | |
| | 0 | 110 | | resolvedNames.Add(senderWarehouseName); |
| | | 111 | | } |
| | | 112 | | |
| | 0 | 113 | | if (resolvedNames.Count > 1) |
| | | 114 | | { |
| | 0 | 115 | | resolution.Errors.Add( |
| | 0 | 116 | | $"Невозможно выбрать единый склад-источник: по выбранным заказам получены разные склады ({string.Join(", |
| | 0 | 117 | | return resolution; |
| | | 118 | | } |
| | | 119 | | |
| | 0 | 120 | | if (resolvedNames.Count == 1 && !resolution.HasErrors) |
| | | 121 | | { |
| | 0 | 122 | | resolution.SenderWarehouseName = resolvedNames.First(); |
| | | 123 | | } |
| | | 124 | | |
| | 0 | 125 | | return resolution; |
| | 0 | 126 | | } |
| | | 127 | | |
| | | 128 | | public async Task<RecipientWarehouseResolution> ResolveRecipientWarehousesAsync(IEnumerable<Order> orders) |
| | | 129 | | { |
| | 2 | 130 | | var result = new RecipientWarehouseResolution(); |
| | 2 | 131 | | var sourceOrders = orders?.ToList() ?? new List<Order>(); |
| | 2 | 132 | | if (!sourceOrders.Any()) |
| | | 133 | | { |
| | 0 | 134 | | return result; |
| | | 135 | | } |
| | | 136 | | |
| | 2 | 137 | | var missingOrderIds = sourceOrders |
| | 2 | 138 | | .Where(o => o.OzonClient == null || |
| | 2 | 139 | | string.IsNullOrWhiteSpace(o.OzonClient.Name) || |
| | 2 | 140 | | o.ShipmentWarehouse == null || |
| | 2 | 141 | | string.IsNullOrWhiteSpace(o.ShipmentWarehouse.Name)) |
| | 2 | 142 | | .Select(o => o.Id) |
| | 2 | 143 | | .Distinct() |
| | 2 | 144 | | .ToList(); |
| | | 145 | | |
| | 2 | 146 | | if (missingOrderIds.Count > 0) |
| | | 147 | | { |
| | 2 | 148 | | var dbOrders = await _context.Orders |
| | 2 | 149 | | .AsNoTracking() |
| | 2 | 150 | | .Include(o => o.OzonClient) |
| | 2 | 151 | | .Include(o => o.ShipmentWarehouse) |
| | 2 | 152 | | .Where(o => missingOrderIds.Contains(o.Id)) |
| | 2 | 153 | | .ToListAsync(); |
| | 2 | 154 | | var byId = dbOrders.ToDictionary(o => o.Id); |
| | 10 | 155 | | foreach (var order in sourceOrders.Where(o => missingOrderIds.Contains(o.Id))) |
| | | 156 | | { |
| | 2 | 157 | | if (byId.TryGetValue(order.Id, out var dbOrder)) |
| | | 158 | | { |
| | 0 | 159 | | order.OzonClient = dbOrder.OzonClient; |
| | 0 | 160 | | order.ShipmentWarehouse = dbOrder.ShipmentWarehouse; |
| | | 161 | | } |
| | | 162 | | } |
| | | 163 | | } |
| | | 164 | | |
| | 2 | 165 | | var mappings = await _context.WarehouseMappings.AsNoTracking().ToListAsync(); |
| | 2 | 166 | | var preferred = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | | 167 | | |
| | 2 | 168 | | var uniquePairs = sourceOrders |
| | 2 | 169 | | .Select(o => new |
| | 2 | 170 | | { |
| | 2 | 171 | | ClientId = o.OzonClientId, |
| | 2 | 172 | | Warehouse = o.ShipmentWarehouse?.Name?.Trim() |
| | 2 | 173 | | }) |
| | 2 | 174 | | .Where(x => x.ClientId.HasValue && !string.IsNullOrWhiteSpace(x.Warehouse)) |
| | 2 | 175 | | .Distinct() |
| | 2 | 176 | | .ToList(); |
| | | 177 | | |
| | 2 | 178 | | var missingPairData = sourceOrders.Any(o => |
| | 4 | 179 | | !o.OzonClientId.HasValue || string.IsNullOrWhiteSpace(o.ShipmentWarehouse?.Name)); |
| | | 180 | | |
| | 2 | 181 | | if (missingPairData) |
| | | 182 | | { |
| | 0 | 183 | | result.Warnings.Add( |
| | 0 | 184 | | "Для части заказов не заполнены клиент маркетплейса или склад отгрузки — приоритетный склад получателя н |
| | | 185 | | } |
| | | 186 | | |
| | 2 | 187 | | if (uniquePairs.Count > 1) |
| | | 188 | | { |
| | 0 | 189 | | result.Warnings.Add( |
| | 0 | 190 | | "В набор попали заказы с разными комбинациями клиента маркетплейса и склада отгрузки — приоритетный скла |
| | | 191 | | } |
| | | 192 | | |
| | 8 | 193 | | foreach (var order in sourceOrders) |
| | | 194 | | { |
| | 2 | 195 | | var clientId = order.OzonClientId; |
| | 2 | 196 | | var ozonWarehouseName = order.ShipmentWarehouse?.Name?.Trim(); |
| | | 197 | | |
| | 2 | 198 | | if (!clientId.HasValue || string.IsNullOrWhiteSpace(ozonWarehouseName)) |
| | | 199 | | { |
| | 0 | 200 | | result.Warnings.Add( |
| | 0 | 201 | | $"Заказ {order.ShipmentNumber}: не удалось определить приоритетный склад получателя (клиент/склад за |
| | 0 | 202 | | continue; |
| | | 203 | | } |
| | | 204 | | |
| | 2 | 205 | | var candidates = mappings |
| | 2 | 206 | | .Where(m => |
| | 5 | 207 | | !string.IsNullOrWhiteSpace(m.OzonWarehouseName) && |
| | 5 | 208 | | !string.IsNullOrWhiteSpace(m.BitrixWarehouseName) && |
| | 5 | 209 | | m.OzonClientId.HasValue && |
| | 5 | 210 | | m.OzonClientId.Value == clientId.Value && |
| | 5 | 211 | | string.Equals(m.OzonWarehouseName.Trim(), ozonWarehouseName, StringComparison.OrdinalIgnoreCase)) |
| | 5 | 212 | | .OrderBy(m => m.Priority) |
| | 5 | 213 | | .ThenBy(m => m.Id) |
| | 5 | 214 | | .Select(m => m.BitrixWarehouseName!.Trim()) |
| | 2 | 215 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 2 | 216 | | .ToList(); |
| | | 217 | | |
| | 2 | 218 | | if (candidates.Count == 0) |
| | | 219 | | { |
| | 0 | 220 | | result.Warnings.Add( |
| | 0 | 221 | | $"Заказ {order.ShipmentNumber}: для клиента (Id={clientId}) и склада '{ozonWarehouseName}' не найден |
| | 0 | 222 | | continue; |
| | | 223 | | } |
| | | 224 | | |
| | 12 | 225 | | foreach (var candidate in candidates) |
| | | 226 | | { |
| | 4 | 227 | | preferred.Add(candidate); |
| | | 228 | | } |
| | | 229 | | } |
| | | 230 | | |
| | 6 | 231 | | result.PreferredRecipientWarehouses.AddRange(preferred.OrderBy(x => x)); |
| | 2 | 232 | | return result; |
| | 2 | 233 | | } |
| | | 234 | | |
| | | 235 | | public async Task<RecipientByOrderResolution> ResolveRecipientByOrderAsync(IEnumerable<Order> orders) |
| | | 236 | | { |
| | 9 | 237 | | var result = new RecipientByOrderResolution(); |
| | 9 | 238 | | var sourceOrders = orders?.ToList() ?? new List<Order>(); |
| | 9 | 239 | | if (!sourceOrders.Any()) |
| | | 240 | | { |
| | 1 | 241 | | result.BlockingErrors.Add("Не выбраны заказы для определения склада получателя."); |
| | 1 | 242 | | return result; |
| | | 243 | | } |
| | | 244 | | |
| | 8 | 245 | | var missingOrderIds = sourceOrders |
| | 9 | 246 | | .Where(o => o.ShipmentWarehouse == null || string.IsNullOrWhiteSpace(o.ShipmentWarehouse.Name)) |
| | 0 | 247 | | .Select(o => o.Id) |
| | 8 | 248 | | .Distinct() |
| | 8 | 249 | | .ToList(); |
| | | 250 | | |
| | 8 | 251 | | if (missingOrderIds.Count > 0) |
| | | 252 | | { |
| | 0 | 253 | | var dbOrders = await _context.Orders |
| | 0 | 254 | | .AsNoTracking() |
| | 0 | 255 | | .Include(o => o.ShipmentWarehouse) |
| | 0 | 256 | | .Include(o => o.OzonClient) |
| | 0 | 257 | | .Where(o => missingOrderIds.Contains(o.Id)) |
| | 0 | 258 | | .ToListAsync(); |
| | 0 | 259 | | var byId = dbOrders.ToDictionary(o => o.Id); |
| | 0 | 260 | | foreach (var order in sourceOrders.Where(o => missingOrderIds.Contains(o.Id))) |
| | | 261 | | { |
| | 0 | 262 | | if (byId.TryGetValue(order.Id, out var dbOrder)) |
| | | 263 | | { |
| | 0 | 264 | | order.ShipmentWarehouse = dbOrder.ShipmentWarehouse; |
| | 0 | 265 | | order.OzonClient ??= dbOrder.OzonClient; |
| | | 266 | | } |
| | | 267 | | } |
| | | 268 | | } |
| | | 269 | | |
| | 8 | 270 | | var mappings = await _context.WarehouseMappings.AsNoTracking().ToListAsync(); |
| | 34 | 271 | | foreach (var order in sourceOrders) |
| | | 272 | | { |
| | 9 | 273 | | var clientId = order.OzonClientId; |
| | 9 | 274 | | var ozonWarehouseName = order.ShipmentWarehouse?.Name?.Trim(); |
| | 9 | 275 | | if (!clientId.HasValue || string.IsNullOrWhiteSpace(ozonWarehouseName)) |
| | | 276 | | { |
| | 1 | 277 | | result.BlockingErrors.Add( |
| | 1 | 278 | | $"Заказ {order.ShipmentNumber}: не заполнены данные для определения склада получателя."); |
| | 1 | 279 | | continue; |
| | | 280 | | } |
| | | 281 | | |
| | 8 | 282 | | var best = mappings |
| | 8 | 283 | | .Where(m => |
| | 12 | 284 | | m.OzonClientId.HasValue && |
| | 12 | 285 | | m.OzonClientId.Value == clientId.Value && |
| | 12 | 286 | | !string.IsNullOrWhiteSpace(m.OzonWarehouseName) && |
| | 12 | 287 | | !string.IsNullOrWhiteSpace(m.BitrixWarehouseName) && |
| | 12 | 288 | | string.Equals(m.OzonWarehouseName.Trim(), ozonWarehouseName, StringComparison.OrdinalIgnoreCase)) |
| | 8 | 289 | | .OrderBy(m => m.Priority) |
| | 8 | 290 | | .ThenBy(m => m.Id) |
| | 8 | 291 | | .FirstOrDefault(); |
| | | 292 | | |
| | 8 | 293 | | if (best == null) |
| | | 294 | | { |
| | 2 | 295 | | result.BlockingErrors.Add( |
| | 2 | 296 | | $"Заказ {order.ShipmentNumber}: не найден маппинг получателя для склада '{ozonWarehouseName}'."); |
| | 2 | 297 | | continue; |
| | | 298 | | } |
| | | 299 | | |
| | 6 | 300 | | result.RecipientByOrderId[order.Id] = best.BitrixWarehouseName!.Trim(); |
| | | 301 | | } |
| | | 302 | | |
| | 8 | 303 | | return result; |
| | 9 | 304 | | } |
| | | 305 | | |
| | | 306 | | /// <summary> |
| | | 307 | | /// Склад-получатель для «Возврата покупателя»: выделенный склад возврата из WarehouseMapping, |
| | | 308 | | /// а при его отсутствии — обычный склад 1С из той же связи. |
| | | 309 | | /// </summary> |
| | | 310 | | public async Task<RecipientByOrderResolution> ResolveCustomerReturnRecipientByOrderAsync( |
| | | 311 | | IEnumerable<Order> orders) |
| | | 312 | | { |
| | 5 | 313 | | var result = new RecipientByOrderResolution(); |
| | 5 | 314 | | var sourceOrders = orders?.ToList() ?? new List<Order>(); |
| | 5 | 315 | | if (!sourceOrders.Any()) |
| | | 316 | | { |
| | 0 | 317 | | result.BlockingErrors.Add("Не выбраны заказы для определения склада получателя."); |
| | 0 | 318 | | return result; |
| | | 319 | | } |
| | | 320 | | |
| | 5 | 321 | | var missingOrderIds = sourceOrders |
| | 5 | 322 | | .Where(o => o.ShipmentWarehouse == null || string.IsNullOrWhiteSpace(o.ShipmentWarehouse.Name)) |
| | 0 | 323 | | .Select(o => o.Id) |
| | 5 | 324 | | .Distinct() |
| | 5 | 325 | | .ToList(); |
| | | 326 | | |
| | 5 | 327 | | if (missingOrderIds.Count > 0) |
| | | 328 | | { |
| | 0 | 329 | | var dbOrders = await _context.Orders |
| | 0 | 330 | | .AsNoTracking() |
| | 0 | 331 | | .Include(o => o.ShipmentWarehouse) |
| | 0 | 332 | | .Include(o => o.OzonClient) |
| | 0 | 333 | | .Where(o => missingOrderIds.Contains(o.Id)) |
| | 0 | 334 | | .ToListAsync(); |
| | 0 | 335 | | var byId = dbOrders.ToDictionary(o => o.Id); |
| | 0 | 336 | | foreach (var order in sourceOrders.Where(o => missingOrderIds.Contains(o.Id))) |
| | | 337 | | { |
| | 0 | 338 | | if (byId.TryGetValue(order.Id, out var dbOrder)) |
| | | 339 | | { |
| | 0 | 340 | | order.ShipmentWarehouse = dbOrder.ShipmentWarehouse; |
| | 0 | 341 | | order.OzonClient ??= dbOrder.OzonClient; |
| | | 342 | | } |
| | | 343 | | } |
| | | 344 | | } |
| | | 345 | | |
| | 5 | 346 | | var mappings = await _context.WarehouseMappings.AsNoTracking().ToListAsync(); |
| | 20 | 347 | | foreach (var order in sourceOrders) |
| | | 348 | | { |
| | 5 | 349 | | var clientId = order.OzonClientId; |
| | 5 | 350 | | var zasyl = order.OrderExtensions |
| | 1 | 351 | | .FirstOrDefault(extension => string.Equals(extension.Key, ZasylKey, StringComparison.OrdinalIgnoreCase)) |
| | 5 | 352 | | ?.Value? |
| | 5 | 353 | | .Trim(); |
| | 5 | 354 | | var ozonWarehouseName = WarehouseNameNormalizer.Normalize( |
| | 5 | 355 | | !string.IsNullOrWhiteSpace(zasyl) ? zasyl : order.ShipmentWarehouse?.Name); |
| | 5 | 356 | | if (!clientId.HasValue || string.IsNullOrWhiteSpace(ozonWarehouseName)) |
| | | 357 | | { |
| | 0 | 358 | | result.BlockingErrors.Add( |
| | 0 | 359 | | $"Заказ {order.ShipmentNumber}: не заполнены данные для определения склада получателя."); |
| | 0 | 360 | | continue; |
| | | 361 | | } |
| | | 362 | | |
| | 5 | 363 | | var best = mappings |
| | 5 | 364 | | .Where(m => |
| | 6 | 365 | | m.OzonClientId.HasValue && |
| | 6 | 366 | | m.OzonClientId.Value == clientId.Value && |
| | 6 | 367 | | !string.IsNullOrWhiteSpace(m.OzonWarehouseName) && |
| | 6 | 368 | | !string.IsNullOrWhiteSpace(m.BitrixWarehouseName) && |
| | 6 | 369 | | string.Equals(WarehouseNameNormalizer.Normalize(m.OzonWarehouseName), ozonWarehouseName, |
| | 6 | 370 | | StringComparison.OrdinalIgnoreCase)) |
| | 5 | 371 | | .OrderBy(m => m.Priority) |
| | 5 | 372 | | .ThenBy(m => m.Id) |
| | 5 | 373 | | .FirstOrDefault(); |
| | | 374 | | |
| | 5 | 375 | | if (best == null) |
| | | 376 | | { |
| | 1 | 377 | | result.BlockingErrors.Add( |
| | 1 | 378 | | $"Заказ {order.ShipmentNumber}: не найден маппинг получателя для склада '{ozonWarehouseName}'."); |
| | 1 | 379 | | continue; |
| | | 380 | | } |
| | | 381 | | |
| | 4 | 382 | | var returnWarehouse = best.ReturnBitrixWarehouseName?.Trim(); |
| | 4 | 383 | | var mappingSource = !string.IsNullOrWhiteSpace(zasyl) |
| | 4 | 384 | | ? $" по засылу {ozonWarehouseName}" |
| | 4 | 385 | | : string.Empty; |
| | 4 | 386 | | if (!string.IsNullOrWhiteSpace(returnWarehouse)) |
| | | 387 | | { |
| | 3 | 388 | | result.RecipientByOrderId[order.Id] = returnWarehouse; |
| | 3 | 389 | | result.RecipientExplanationByOrderId[order.Id] = |
| | 3 | 390 | | $"Склад возврата из связи{mappingSource}: {returnWarehouse}"; |
| | 3 | 391 | | result.ReturnWarehouseOrderIds.Add(order.Id); |
| | 3 | 392 | | continue; |
| | | 393 | | } |
| | | 394 | | |
| | 1 | 395 | | var primaryWarehouse = best.BitrixWarehouseName!.Trim(); |
| | 1 | 396 | | result.RecipientByOrderId[order.Id] = primaryWarehouse; |
| | 1 | 397 | | result.RecipientExplanationByOrderId[order.Id] = |
| | 1 | 398 | | $"Основной склад из связи{mappingSource}: {primaryWarehouse} — склад возврата не задан."; |
| | | 399 | | } |
| | | 400 | | |
| | 5 | 401 | | return result; |
| | 5 | 402 | | } |
| | | 403 | | |
| | | 404 | | /// <summary> |
| | | 405 | | /// Строит для страницы варианты склада возврата при изменении «Засыла». Правило идентично |
| | | 406 | | /// <see cref="ResolveCustomerReturnRecipientByOrderAsync"/>: засыл заменяет склад отгрузки, |
| | | 407 | | /// затем выбирается связь с минимальными Priority и Id. |
| | | 408 | | /// </summary> |
| | | 409 | | public async Task<Dictionary<string, CustomerReturnZasylOrderOptions>> |
| | | 410 | | BuildCustomerReturnZasylOptionsAsync(IEnumerable<Order> orders, IEnumerable<string?>? warehouseNames) |
| | | 411 | | { |
| | 1 | 412 | | var result = new Dictionary<string, CustomerReturnZasylOrderOptions>(); |
| | 1 | 413 | | var sourceOrders = orders?.ToList() ?? []; |
| | 1 | 414 | | if (sourceOrders.Count == 0) |
| | 0 | 415 | | return result; |
| | | 416 | | |
| | 1 | 417 | | var mappings = await _context.WarehouseMappings.AsNoTracking().ToListAsync(); |
| | 1 | 418 | | var names = (warehouseNames ?? Enumerable.Empty<string?>()) |
| | 0 | 419 | | .Where(name => !string.IsNullOrWhiteSpace(name)) |
| | 0 | 420 | | .Select(name => name!.Trim()) |
| | 1 | 421 | | .ToList(); |
| | | 422 | | |
| | 4 | 423 | | foreach (var order in sourceOrders) |
| | | 424 | | { |
| | 1 | 425 | | if (!order.OzonClientId.HasValue) |
| | | 426 | | continue; |
| | | 427 | | |
| | 1 | 428 | | var orderNames = names |
| | 2 | 429 | | .Concat(mappings.Where(mapping => mapping.OzonClientId == order.OzonClientId) |
| | 2 | 430 | | .Select(mapping => mapping.OzonWarehouseName)) |
| | 1 | 431 | | .Append(order.ShipmentWarehouse?.Name) |
| | 1 | 432 | | .Append(order.OrderExtensions? |
| | 0 | 433 | | .FirstOrDefault(extension => string.Equals(extension.Key, ZasylKey, StringComparison.OrdinalIgnoreCa |
| | 1 | 434 | | ?.Value) |
| | 4 | 435 | | .Where(name => !string.IsNullOrWhiteSpace(name)) |
| | 3 | 436 | | .Select(name => name!.Trim()) |
| | 1 | 437 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 438 | | .ToList(); |
| | | 439 | | |
| | | 440 | | CustomerReturnZasylOption? Resolve(string? sourceWarehouse, bool fromZasyl) |
| | | 441 | | { |
| | 3 | 442 | | var normalized = WarehouseNameNormalizer.Normalize(sourceWarehouse); |
| | 3 | 443 | | if (string.IsNullOrWhiteSpace(normalized)) |
| | 0 | 444 | | return null; |
| | | 445 | | |
| | 3 | 446 | | var mapping = mappings |
| | 6 | 447 | | .Where(candidate => candidate.OzonClientId == order.OzonClientId && |
| | 6 | 448 | | !string.IsNullOrWhiteSpace(candidate.OzonWarehouseName) && |
| | 6 | 449 | | !string.IsNullOrWhiteSpace(candidate.BitrixWarehouseName) && |
| | 6 | 450 | | string.Equals(WarehouseNameNormalizer.Normalize(candidate.OzonWarehouseName), no |
| | 6 | 451 | | StringComparison.OrdinalIgnoreCase)) |
| | 3 | 452 | | .OrderBy(candidate => candidate.Priority) |
| | 3 | 453 | | .ThenBy(candidate => candidate.Id) |
| | 3 | 454 | | .FirstOrDefault(); |
| | 3 | 455 | | if (mapping == null) |
| | 0 | 456 | | return null; |
| | | 457 | | |
| | 3 | 458 | | var returnWarehouse = mapping.ReturnBitrixWarehouseName?.Trim(); |
| | 3 | 459 | | var sourceSuffix = fromZasyl ? $" по засылу {normalized}" : string.Empty; |
| | 3 | 460 | | if (!string.IsNullOrWhiteSpace(returnWarehouse)) |
| | | 461 | | { |
| | 1 | 462 | | return new CustomerReturnZasylOption( |
| | 1 | 463 | | returnWarehouse, |
| | 1 | 464 | | $"Склад возврата из связи{sourceSuffix}: {returnWarehouse}", |
| | 1 | 465 | | true); |
| | | 466 | | } |
| | | 467 | | |
| | 2 | 468 | | var primaryWarehouse = mapping.BitrixWarehouseName!.Trim(); |
| | 2 | 469 | | return new CustomerReturnZasylOption( |
| | 2 | 470 | | primaryWarehouse, |
| | 2 | 471 | | $"Основной склад из связи{sourceSuffix}: {primaryWarehouse} — склад возврата не задан.", |
| | 2 | 472 | | false); |
| | | 473 | | } |
| | | 474 | | |
| | 1 | 475 | | var options = new Dictionary<string, CustomerReturnZasylOption>(StringComparer.OrdinalIgnoreCase); |
| | 6 | 476 | | foreach (var name in orderNames) |
| | | 477 | | { |
| | 2 | 478 | | var key = WarehouseNameNormalizer.Normalize(name)?.ToLowerInvariant(); |
| | 2 | 479 | | var option = Resolve(name, fromZasyl: true); |
| | 2 | 480 | | if (key != null && option != null) |
| | 2 | 481 | | options.TryAdd(key, option); |
| | | 482 | | } |
| | | 483 | | |
| | 1 | 484 | | result[order.Id.ToString()] = new CustomerReturnZasylOrderOptions( |
| | 1 | 485 | | options, |
| | 1 | 486 | | Resolve(order.ShipmentWarehouse?.Name, fromZasyl: false)); |
| | | 487 | | } |
| | | 488 | | |
| | 1 | 489 | | return result; |
| | 1 | 490 | | } |
| | | 491 | | |
| | | 492 | | /// <summary> |
| | | 493 | | /// Склад отправителя для отгрузки комиссионеру: BitrixWarehouseName из связки складов (клиент + склад заказа). |
| | | 494 | | /// </summary> |
| | | 495 | | public async Task<CommissionerSenderWarehouseResolution> ResolveCommissionerSenderWarehousesAsync( |
| | | 496 | | IEnumerable<Order> orders) |
| | | 497 | | { |
| | 4 | 498 | | var result = new CommissionerSenderWarehouseResolution(); |
| | 4 | 499 | | var sourceOrders = orders?.ToList() ?? new List<Order>(); |
| | 4 | 500 | | if (!sourceOrders.Any()) |
| | | 501 | | { |
| | 0 | 502 | | result.BlockingErrors.Add("Не выбраны заказы для определения склада отправителя."); |
| | 0 | 503 | | return result; |
| | | 504 | | } |
| | | 505 | | |
| | 4 | 506 | | var missingOrderIds = sourceOrders |
| | 4 | 507 | | .Where(o => o.ShipmentWarehouse == null || string.IsNullOrWhiteSpace(o.ShipmentWarehouse.Name)) |
| | 1 | 508 | | .Select(o => o.Id) |
| | 4 | 509 | | .Distinct() |
| | 4 | 510 | | .ToList(); |
| | | 511 | | |
| | 4 | 512 | | if (missingOrderIds.Count > 0) |
| | | 513 | | { |
| | 1 | 514 | | var dbOrders = await _context.Orders |
| | 1 | 515 | | .AsNoTracking() |
| | 1 | 516 | | .Include(o => o.ShipmentWarehouse) |
| | 1 | 517 | | .Include(o => o.OzonClient) |
| | 1 | 518 | | .Include(o => o.OrderExtensions) |
| | 1 | 519 | | .Where(o => missingOrderIds.Contains(o.Id)) |
| | 1 | 520 | | .ToListAsync(); |
| | 1 | 521 | | var byId = dbOrders.ToDictionary(o => o.Id); |
| | 5 | 522 | | foreach (var order in sourceOrders.Where(o => missingOrderIds.Contains(o.Id))) |
| | | 523 | | { |
| | 1 | 524 | | if (byId.TryGetValue(order.Id, out var dbOrder)) |
| | | 525 | | { |
| | 0 | 526 | | order.ShipmentWarehouse = dbOrder.ShipmentWarehouse; |
| | 0 | 527 | | order.OzonClient ??= dbOrder.OzonClient; |
| | 0 | 528 | | order.OrderExtensions = dbOrder.OrderExtensions; |
| | | 529 | | } |
| | | 530 | | } |
| | | 531 | | } |
| | | 532 | | |
| | 4 | 533 | | var mappings = await _context.WarehouseMappings.AsNoTracking().ToListAsync(); |
| | 16 | 534 | | foreach (var order in sourceOrders) |
| | | 535 | | { |
| | 4 | 536 | | var warehouse = ShippedToCommissionerWarehouseResolver.ResolveSenderWarehouse(order, mappings); |
| | 4 | 537 | | if (string.IsNullOrWhiteSpace(warehouse)) |
| | | 538 | | { |
| | 1 | 539 | | result.BlockingErrors.Add( |
| | 1 | 540 | | $"Заказ {order.ShipmentNumber}: не заполнен склад отгрузки и не найдена связка WarehouseMapping."); |
| | 1 | 541 | | continue; |
| | | 542 | | } |
| | | 543 | | |
| | 3 | 544 | | result.WarehouseByOrderId[order.Id] = warehouse; |
| | | 545 | | } |
| | | 546 | | |
| | 4 | 547 | | return result; |
| | 4 | 548 | | } |
| | | 549 | | |
| | | 550 | | public async Task<SenderWarehouseResolution> ResolveSenderWarehouseFromShipmentAsync(IEnumerable<Order> orders) |
| | | 551 | | { |
| | 0 | 552 | | var resolution = new SenderWarehouseResolution(); |
| | 0 | 553 | | var sourceOrders = orders?.ToList() ?? new List<Order>(); |
| | | 554 | | |
| | 0 | 555 | | if (!sourceOrders.Any()) |
| | | 556 | | { |
| | 0 | 557 | | resolution.Errors.Add("Не выбраны заказы для определения склада отправителя."); |
| | 0 | 558 | | return resolution; |
| | | 559 | | } |
| | | 560 | | |
| | 0 | 561 | | var missingOrderIds = sourceOrders |
| | 0 | 562 | | .Where(o => o.ShipmentWarehouse == null || string.IsNullOrWhiteSpace(o.ShipmentWarehouse.Name)) |
| | 0 | 563 | | .Select(o => o.Id) |
| | 0 | 564 | | .Distinct() |
| | 0 | 565 | | .ToList(); |
| | | 566 | | |
| | 0 | 567 | | if (missingOrderIds.Count > 0) |
| | | 568 | | { |
| | 0 | 569 | | var dbOrders = await _context.Orders |
| | 0 | 570 | | .AsNoTracking() |
| | 0 | 571 | | .Include(o => o.ShipmentWarehouse) |
| | 0 | 572 | | .Where(o => missingOrderIds.Contains(o.Id)) |
| | 0 | 573 | | .ToListAsync(); |
| | 0 | 574 | | var byId = dbOrders.ToDictionary(o => o.Id); |
| | 0 | 575 | | foreach (var order in sourceOrders.Where(o => missingOrderIds.Contains(o.Id))) |
| | | 576 | | { |
| | 0 | 577 | | if (byId.TryGetValue(order.Id, out var dbOrder)) |
| | | 578 | | { |
| | 0 | 579 | | order.ShipmentWarehouse = dbOrder.ShipmentWarehouse; |
| | | 580 | | } |
| | | 581 | | } |
| | | 582 | | } |
| | | 583 | | |
| | 0 | 584 | | var resolvedNames = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | 0 | 585 | | foreach (var order in sourceOrders) |
| | | 586 | | { |
| | 0 | 587 | | var shipmentWarehouseName = order.ShipmentWarehouse?.Name?.Trim(); |
| | 0 | 588 | | if (string.IsNullOrWhiteSpace(shipmentWarehouseName)) |
| | | 589 | | { |
| | 0 | 590 | | resolution.Errors.Add( |
| | 0 | 591 | | $"Заказ {order.ShipmentNumber}: не заполнено поле 'Склад отгрузки'."); |
| | 0 | 592 | | continue; |
| | | 593 | | } |
| | | 594 | | |
| | 0 | 595 | | resolvedNames.Add(shipmentWarehouseName); |
| | | 596 | | } |
| | | 597 | | |
| | 0 | 598 | | if (resolvedNames.Count > 1) |
| | | 599 | | { |
| | 0 | 600 | | resolution.Errors.Add( |
| | 0 | 601 | | $"Невозможно выбрать единый склад-источник: по выбранным заказам получены разные склады ({string.Join(", |
| | 0 | 602 | | return resolution; |
| | | 603 | | } |
| | | 604 | | |
| | 0 | 605 | | if (resolvedNames.Count == 1 && !resolution.HasErrors) |
| | | 606 | | { |
| | 0 | 607 | | resolution.SenderWarehouseName = resolvedNames.First(); |
| | | 608 | | } |
| | | 609 | | |
| | 0 | 610 | | return resolution; |
| | 0 | 611 | | } |
| | | 612 | | } |