| | | 1 | | using System.Text; |
| | | 2 | | using Microsoft.EntityFrameworkCore; |
| | | 3 | | using Microsoft.Extensions.Logging; |
| | | 4 | | using OzonRepositories.Context; |
| | | 5 | | using Services.ApiServices; |
| | | 6 | | using Services.ApiServices._1CApi.Models; |
| | | 7 | | using Services.StockSyncServices; |
| | | 8 | | |
| | | 9 | | namespace Services.AiAssistant; |
| | | 10 | | |
| | | 11 | | /// <summary> |
| | | 12 | | /// Таблица остатков + карта движений 1С (как /WarehouseStock и movement-map). |
| | | 13 | | /// </summary> |
| | | 14 | | public sealed class AiProductContextLoader |
| | | 15 | | { |
| | | 16 | | private readonly ApplicationDbContext _db; |
| | | 17 | | private readonly IWarehouseStockLookupService _warehouseLookup; |
| | | 18 | | private readonly OneCDataManager _oneCDataManager; |
| | | 19 | | private readonly ILogger<AiProductContextLoader> _logger; |
| | | 20 | | |
| | 0 | 21 | | public AiProductContextLoader( |
| | 0 | 22 | | ApplicationDbContext db, |
| | 0 | 23 | | IWarehouseStockLookupService warehouseLookup, |
| | 0 | 24 | | OneCDataManager oneCDataManager, |
| | 0 | 25 | | ILogger<AiProductContextLoader> logger) |
| | | 26 | | { |
| | 0 | 27 | | _db = db; |
| | 0 | 28 | | _warehouseLookup = warehouseLookup; |
| | 0 | 29 | | _oneCDataManager = oneCDataManager; |
| | 0 | 30 | | _logger = logger; |
| | 0 | 31 | | } |
| | | 32 | | |
| | | 33 | | public async Task<string> LoadFormattedAsync( |
| | | 34 | | string article, |
| | | 35 | | string? manufacturer, |
| | | 36 | | CancellationToken ct = default) |
| | | 37 | | { |
| | 0 | 38 | | article = article.Trim(); |
| | 0 | 39 | | if (string.IsNullOrWhiteSpace(article)) |
| | 0 | 40 | | return "Артикул товара не указан."; |
| | | 41 | | |
| | 0 | 42 | | var sb = new StringBuilder(); |
| | 0 | 43 | | sb.AppendLine($"=== Товар и склад (таблица остатков + 1С) — артикул {article} ==="); |
| | 0 | 44 | | if (!string.IsNullOrWhiteSpace(manufacturer)) |
| | 0 | 45 | | sb.AppendLine($"Производитель (из заказа/запроса): {manufacturer}"); |
| | | 46 | | |
| | 0 | 47 | | await AppendWarehouseStockSectionAsync(sb, article, manufacturer, ct); |
| | 0 | 48 | | await AppendMovementMapSectionAsync(sb, article, ct); |
| | | 49 | | |
| | 0 | 50 | | return sb.ToString().TrimEnd(); |
| | 0 | 51 | | } |
| | | 52 | | |
| | | 53 | | private async Task AppendWarehouseStockSectionAsync( |
| | | 54 | | StringBuilder sb, |
| | | 55 | | string article, |
| | | 56 | | string? manufacturer, |
| | | 57 | | CancellationToken ct) |
| | | 58 | | { |
| | 0 | 59 | | var lookup = await _warehouseLookup.LookupAsync(article, manufacturer, ct); |
| | 0 | 60 | | var rows = await _db.WarehouseStockSnapshots |
| | 0 | 61 | | .AsNoTracking() |
| | 0 | 62 | | .Where(x => x.Article != null && x.Article.Contains(article)) |
| | 0 | 63 | | .OrderBy(x => x.Article) |
| | 0 | 64 | | .Take(15) |
| | 0 | 65 | | .ToListAsync(ct); |
| | | 66 | | |
| | 0 | 67 | | if (rows.Count == 0 && lookup is not { Found: true }) |
| | | 68 | | { |
| | 0 | 69 | | sb.AppendLine("Таблица остатков: строк не найдено."); |
| | 0 | 70 | | return; |
| | | 71 | | } |
| | | 72 | | |
| | 0 | 73 | | sb.AppendLine("--- Таблица остатков ---"); |
| | 0 | 74 | | sb.AppendLine( |
| | 0 | 75 | | "⚠ Дробные значения здесь — из Google Sheets/снэпшота. Отчёт BitrixStock и накат Ozon используют " + |
| | 0 | 76 | | "целые штуки (Math.Round при построении отчёта). Не смешивай с OneCQty из синхронизации."); |
| | 0 | 77 | | if (lookup is { Found: true }) |
| | | 78 | | { |
| | 0 | 79 | | sb.AppendLine( |
| | 0 | 80 | | $"Лучшее совпадение: строка #{lookup.SourceRowNumber}, C0 {lookup.C0:N0} ₽, " + |
| | 0 | 81 | | $"M2 {lookup.M2Qty} шт., M3 {lookup.M3Qty} шт., B1 {lookup.B1Qty} шт., B2 {lookup.B2Qty} шт." + |
| | 0 | 82 | | (lookup.FuzzyManufacturer ? " (производитель — fuzzy match)" : "")); |
| | | 83 | | } |
| | | 84 | | |
| | 0 | 85 | | foreach (var r in rows) |
| | | 86 | | { |
| | 0 | 87 | | sb.AppendLine( |
| | 0 | 88 | | $" • {r.Article} | {r.Manufacturer} | {r.ProductName} | " + |
| | 0 | 89 | | $"M2 {r.M2Qty} шт., M3 {r.M3Qty} шт., B1 {r.B1Qty} шт., B2 {r.B2Qty} шт. | " + |
| | 0 | 90 | | $"C0 {r.C0:N0} ₽ | Sale={r.SaleFlag} | sync {r.SyncedAtUtc:dd.MM.yyyy HH:mm} UTC"); |
| | | 91 | | } |
| | 0 | 92 | | } |
| | | 93 | | |
| | | 94 | | private async Task AppendMovementMapSectionAsync(StringBuilder sb, string article, CancellationToken ct) |
| | | 95 | | { |
| | 0 | 96 | | sb.AppendLine(); |
| | 0 | 97 | | sb.AppendLine("--- Карта движений 1С ---"); |
| | | 98 | | |
| | | 99 | | try |
| | | 100 | | { |
| | 0 | 101 | | var map = await _oneCDataManager.GetMovementMapAsync(article); |
| | 0 | 102 | | if (map == null) |
| | | 103 | | { |
| | 0 | 104 | | sb.AppendLine("В 1С номенклатура по этому артикулу не найдена."); |
| | 0 | 105 | | return; |
| | | 106 | | } |
| | | 107 | | |
| | 0 | 108 | | sb.AppendLine($"Наименование 1С: {map.NomenclatureName}"); |
| | 0 | 109 | | if (map.CurrentBalance is { Count: > 0 }) |
| | | 110 | | { |
| | 0 | 111 | | sb.AppendLine("Текущий остаток по складам 1С:"); |
| | 0 | 112 | | foreach (var b in map.CurrentBalance) |
| | 0 | 113 | | sb.AppendLine($" • {b.Warehouse}: {b.Quantity} шт."); |
| | | 114 | | } |
| | | 115 | | |
| | 0 | 116 | | sb.AppendLine( |
| | 0 | 117 | | $"Итого приход: {map.TotalReceiptQty} шт. ({map.TotalReceiptDocs} док.), " + |
| | 0 | 118 | | $"расход: {map.TotalExpenseQty} ({map.TotalExpenseDocs}), " + |
| | 0 | 119 | | $"перемещения: {map.TotalTransferQty} ({map.TotalTransferDocs})"); |
| | | 120 | | |
| | 0 | 121 | | var movements = (map.Movements ?? []) |
| | 0 | 122 | | .Where(m => !m.IsDeleted) |
| | 0 | 123 | | .OrderByDescending(m => m.Date) |
| | 0 | 124 | | .Take(12) |
| | 0 | 125 | | .ToList(); |
| | | 126 | | |
| | 0 | 127 | | if (movements.Count > 0) |
| | | 128 | | { |
| | 0 | 129 | | sb.AppendLine("Последние движения:"); |
| | 0 | 130 | | foreach (var m in movements) |
| | | 131 | | { |
| | 0 | 132 | | var wh = m.Kind == MovementKind.Transfer |
| | 0 | 133 | | ? $"{m.WarehouseFrom} → {m.WarehouseTo}" |
| | 0 | 134 | | : m.WarehouseFrom ?? m.WarehouseTo ?? "—"; |
| | 0 | 135 | | sb.AppendLine( |
| | 0 | 136 | | $" {m.Date:dd.MM.yyyy HH:mm} | {m.Kind} | {m.DocType} №{m.DocNumber} | " + |
| | 0 | 137 | | $"{m.Quantity} шт. | {m.Price:N0} ₽ | {wh}"); |
| | | 138 | | } |
| | | 139 | | } |
| | 0 | 140 | | } |
| | 0 | 141 | | catch (Exception ex) |
| | | 142 | | { |
| | 0 | 143 | | _logger.LogWarning(ex, "AI product context: movement-map failed for {Article}", article); |
| | 0 | 144 | | sb.AppendLine($"Карта движений 1С временно недоступна: {ex.Message}"); |
| | 0 | 145 | | } |
| | 0 | 146 | | } |
| | | 147 | | } |