| | | 1 | | using System.Security.Claims; |
| | | 2 | | using Microsoft.EntityFrameworkCore; |
| | | 3 | | using OzonRepositories.Context; |
| | | 4 | | using Services.FeedPriceServices; |
| | | 5 | | |
| | | 6 | | namespace OzonOrdersWeb.WebServices.Orders.Grid; |
| | | 7 | | |
| | | 8 | | public interface IOrdersGridFeedPriceService |
| | | 9 | | { |
| | | 10 | | /// <summary> |
| | | 11 | | /// Цена и остатки артикула заказа в фиде; null — заказ не найден или недоступен пользователю. |
| | | 12 | | /// <paramref name="currentOnly"/> — без истории цены (колонки грида), в ответе заполнен <c>ForOrder</c>. |
| | | 13 | | /// </summary> |
| | | 14 | | Task<FeedPriceResult?> GetAsync(int orderId, ClaimsPrincipal principal, CancellationToken cancellationToken, bool cu |
| | | 15 | | |
| | | 16 | | /// <summary> |
| | | 17 | | /// Как получилась цена позиции заказа: расшифровка по сборкам кабинетов и выбранная по клиенту заказа. |
| | | 18 | | /// <paramref name="runId"/> — конкретная сборка; без него последняя сборка каждого кабинета с планом. null — заказ |
| | | 19 | | /// </summary> |
| | | 20 | | Task<FeedOrderExplanation?> GetExplanationAsync(int orderId, ClaimsPrincipal principal, long? runId, CancellationTok |
| | | 21 | | |
| | | 22 | | /// <summary> |
| | | 23 | | /// Строка фида для каждого заказа пачки (колонки Feed в гридах): один запрос доступа, одна выборка заказов и пачки |
| | | 24 | | /// ключей в feed API вместо запроса на каждый заказ. Недоступные пользователю заказы получают статус <c>noAccess</c |
| | | 25 | | /// </summary> |
| | | 26 | | Task<IReadOnlyList<FeedBatchItem>> GetBatchAsync(IReadOnlyCollection<int> orderIds, ClaimsPrincipal principal, Cance |
| | | 27 | | } |
| | | 28 | | |
| | | 29 | | /// <summary>Модалка «Фид: цена и остатки»: проверяет доступ к заказу тем же RLS-запросом, что и список, и собирает ключ |
| | | 30 | | public sealed class OrdersGridFeedPriceService : IOrdersGridFeedPriceService |
| | | 31 | | { |
| | | 32 | | private readonly ApplicationDbContext _context; |
| | | 33 | | private readonly IOrdersGridScopedQuery _scoped; |
| | | 34 | | private readonly IFeedPriceService _feedPrice; |
| | | 35 | | private readonly IFeedExplanationService _explanation; |
| | | 36 | | |
| | 0 | 37 | | public OrdersGridFeedPriceService(ApplicationDbContext context, IOrdersGridScopedQuery scoped, IFeedPriceService fee |
| | 0 | 38 | | IFeedExplanationService explanation) |
| | | 39 | | { |
| | 0 | 40 | | _context = context; |
| | 0 | 41 | | _scoped = scoped; |
| | 0 | 42 | | _feedPrice = feedPrice; |
| | 0 | 43 | | _explanation = explanation; |
| | 0 | 44 | | } |
| | | 45 | | |
| | | 46 | | public async Task<FeedPriceResult?> GetAsync(int orderId, ClaimsPrincipal principal, CancellationToken cancellationT |
| | | 47 | | bool currentOnly = false) |
| | | 48 | | { |
| | 0 | 49 | | var user = await _scoped.ResolveUserAsync(principal); |
| | 0 | 50 | | if (user is null) return null; |
| | 0 | 51 | | var accessible = await _scoped.FilterAccessibleAsync(user, [orderId], includeArchived: true, cancellationToken); |
| | 0 | 52 | | if (accessible.Count == 0) return null; |
| | | 53 | | |
| | 0 | 54 | | var order = await _context.Orders.AsNoTracking() |
| | 0 | 55 | | .Where(o => o.Id == orderId) |
| | 0 | 56 | | .Select(o => new |
| | 0 | 57 | | { |
| | 0 | 58 | | o.ProductKey, |
| | 0 | 59 | | o.Article, |
| | 0 | 60 | | MarketPrefix = o.EtProducer != null ? o.EtProducer.MarketPrefix : null, |
| | 0 | 61 | | Client = o.OzonClient != null ? o.OzonClient.Name : null, |
| | 0 | 62 | | Warehouse = o.ShipmentWarehouse != null ? o.ShipmentWarehouse.Name : null |
| | 0 | 63 | | }) |
| | 0 | 64 | | .FirstOrDefaultAsync(cancellationToken); |
| | 0 | 65 | | if (order is null) return null; |
| | | 66 | | |
| | 0 | 67 | | var keys = FeedArticleKey.Build(order.ProductKey, order.Article, order.MarketPrefix); |
| | 0 | 68 | | var result = currentOnly |
| | 0 | 69 | | ? await _feedPrice.GetCurrentAsync(keys, cancellationToken) |
| | 0 | 70 | | : await _feedPrice.GetAsync(keys, cancellationToken); |
| | | 71 | | |
| | | 72 | | // При ошибке фида строку выбирать не из чего: клиент покажет Error. |
| | 0 | 73 | | return result.Error is null |
| | 0 | 74 | | ? result.WithOrder(FeedOrderRowPicker.Pick(result.Current, keys, order.Client, order.Warehouse)) |
| | 0 | 75 | | : result; |
| | 0 | 76 | | } |
| | | 77 | | |
| | | 78 | | public async Task<FeedOrderExplanation?> GetExplanationAsync(int orderId, ClaimsPrincipal principal, long? runId, |
| | | 79 | | CancellationToken cancellationToken) |
| | | 80 | | { |
| | 0 | 81 | | var user = await _scoped.ResolveUserAsync(principal); |
| | 0 | 82 | | if (user is null) return null; |
| | 0 | 83 | | var accessible = await _scoped.FilterAccessibleAsync(user, [orderId], includeArchived: true, cancellationToken); |
| | 0 | 84 | | if (accessible.Count == 0) return null; |
| | | 85 | | |
| | 0 | 86 | | var order = await _context.Orders.AsNoTracking() |
| | 0 | 87 | | .Where(o => o.Id == orderId) |
| | 0 | 88 | | .Select(o => new |
| | 0 | 89 | | { |
| | 0 | 90 | | o.ProductKey, |
| | 0 | 91 | | o.Article, |
| | 0 | 92 | | MarketPrefix = o.EtProducer != null ? o.EtProducer.MarketPrefix : null, |
| | 0 | 93 | | Client = o.OzonClient != null ? o.OzonClient.Name : null |
| | 0 | 94 | | }) |
| | 0 | 95 | | .FirstOrDefaultAsync(cancellationToken); |
| | 0 | 96 | | if (order is null) return null; |
| | | 97 | | |
| | 0 | 98 | | var keys = FeedArticleKey.Build(order.ProductKey, order.Article, order.MarketPrefix); |
| | 0 | 99 | | var result = await _explanation.GetAsync(keys, runId, cancellationToken); |
| | 0 | 100 | | return FeedOrderExplanationPicker.Pick(result, keys.Count, order.Client); |
| | 0 | 101 | | } |
| | | 102 | | |
| | | 103 | | public async Task<IReadOnlyList<FeedBatchItem>> GetBatchAsync(IReadOnlyCollection<int> orderIds, ClaimsPrincipal pri |
| | | 104 | | CancellationToken cancellationToken) |
| | | 105 | | { |
| | 0 | 106 | | var ids = orderIds.Distinct().ToArray(); |
| | | 107 | | IReadOnlyList<FeedBatchItem> NoAccess(IEnumerable<int> missing) => |
| | 0 | 108 | | missing.Select(id => new FeedBatchItem { Id = id, Status = FeedBatchItem.NoAccess }).ToArray(); |
| | | 109 | | |
| | 0 | 110 | | var user = await _scoped.ResolveUserAsync(principal); |
| | 0 | 111 | | if (user is null || ids.Length == 0) return NoAccess(ids); |
| | 0 | 112 | | var accessible = (await _scoped.FilterAccessibleAsync(user, ids, includeArchived: true, cancellationToken)).ToHa |
| | 0 | 113 | | if (accessible.Count == 0) return NoAccess(ids); |
| | | 114 | | |
| | 0 | 115 | | var accessibleIds = accessible.ToArray(); |
| | 0 | 116 | | var rows = await _context.Orders.AsNoTracking() |
| | 0 | 117 | | .Where(o => accessibleIds.Contains(o.Id)) |
| | 0 | 118 | | .Select(o => new |
| | 0 | 119 | | { |
| | 0 | 120 | | o.Id, |
| | 0 | 121 | | o.ProductKey, |
| | 0 | 122 | | o.Article, |
| | 0 | 123 | | MarketPrefix = o.EtProducer != null ? o.EtProducer.MarketPrefix : null, |
| | 0 | 124 | | Client = o.OzonClient != null ? o.OzonClient.Name : null, |
| | 0 | 125 | | Warehouse = o.ShipmentWarehouse != null ? o.ShipmentWarehouse.Name : null |
| | 0 | 126 | | }) |
| | 0 | 127 | | .ToListAsync(cancellationToken); |
| | | 128 | | |
| | 0 | 129 | | var orders = rows |
| | 0 | 130 | | .Select(o => new FeedBatchOrder(o.Id, FeedArticleKey.Build(o.ProductKey, o.Article, o.MarketPrefix), o.Clien |
| | 0 | 131 | | .ToList(); |
| | 0 | 132 | | var keys = orders.SelectMany(o => o.Keys).Distinct(StringComparer.OrdinalIgnoreCase).ToArray(); |
| | 0 | 133 | | var feedRows = await _feedPrice.GetCurrentRowsAsync(keys, cancellationToken); |
| | | 134 | | |
| | 0 | 135 | | var items = FeedBatchPicker.Build(orders, feedRows).ToList(); |
| | | 136 | | // Заказы, которых нет среди доступных или найденных, отдаются как недоступные — клиент не должен ждать их беско |
| | 0 | 137 | | var found = items.Select(i => i.Id).ToHashSet(); |
| | 0 | 138 | | items.AddRange(NoAccess(ids.Where(id => !found.Contains(id)))); |
| | 0 | 139 | | return items; |
| | 0 | 140 | | } |
| | | 141 | | } |