| | | 1 | | using System.Text; |
| | | 2 | | using Services.BitrixStockServices; |
| | | 3 | | |
| | | 4 | | namespace Services.AiAssistant; |
| | | 5 | | |
| | | 6 | | /// <summary> |
| | | 7 | | /// Текстовое резюме истории BitrixStock для промпта AI (человекочитаемые предложения + правила этапов). |
| | | 8 | | /// </summary> |
| | | 9 | | public static class BitrixStockArticleHistoryAiFormatter |
| | | 10 | | { |
| | | 11 | | private const int DefaultMaxReports = 5; |
| | | 12 | | private const int MaxRowsPerReport = 12; |
| | | 13 | | private const int MaxTotalRows = 40; |
| | | 14 | | |
| | | 15 | | private const int AiMaxReports = 20; |
| | | 16 | | private const int AiMaxRowsPerReport = 15; |
| | | 17 | | private const int AiMaxTotalRows = 150; |
| | | 18 | | |
| | | 19 | | public static string Format( |
| | | 20 | | BitrixStockArticleHistoryPageDto page, |
| | | 21 | | string? manufacturerPrefix = null, |
| | | 22 | | int maxReports = DefaultMaxReports) => |
| | 15 | 23 | | FormatNarrative(page, manufacturerPrefix, maxReports); |
| | | 24 | | |
| | | 25 | | /// <summary>Полный разбор для AI: правила этапов, все отчёты, партии, хронология цен.</summary> |
| | | 26 | | public static string FormatForAiAnalysis( |
| | | 27 | | BitrixStockArticleHistoryPageDto page, |
| | | 28 | | string? manufacturerPrefix = null) |
| | | 29 | | { |
| | 10 | 30 | | if (string.IsNullOrWhiteSpace(page.Article)) |
| | 3 | 31 | | return "Артикул не указан."; |
| | | 32 | | |
| | 7 | 33 | | var sb = new StringBuilder(); |
| | 7 | 34 | | sb.AppendLine(BitrixStockSyncAiKnowledge.GetPromptSection()); |
| | 7 | 35 | | sb.AppendLine(); |
| | | 36 | | |
| | 7 | 37 | | if (page.TotalReportCount == 0) |
| | | 38 | | { |
| | 1 | 39 | | sb.AppendLine($"История синхронизаций Ozon по артикулу «{page.Article}»: отчётов не найдено."); |
| | 1 | 40 | | return sb.ToString().TrimEnd(); |
| | | 41 | | } |
| | | 42 | | |
| | 6 | 43 | | AppendBatchSummary(sb, page); |
| | 6 | 44 | | AppendPriceChronology(sb, page); |
| | 6 | 45 | | sb.AppendLine(FormatNarrative(page, manufacturerPrefix, AiMaxReports, AiMaxRowsPerReport, AiMaxTotalRows)); |
| | | 46 | | |
| | 6 | 47 | | if (page.TotalReportCount > page.Reports.Count) |
| | | 48 | | { |
| | 1 | 49 | | sb.AppendLine(); |
| | 1 | 50 | | sb.AppendLine( |
| | 1 | 51 | | $"⚠ В контексте {page.Reports.Count} из {page.TotalReportCount} отчётов. " + |
| | 1 | 52 | | "UI: /Studio2/BitrixStock?tab=sync → история по артикулу."); |
| | | 53 | | } |
| | | 54 | | |
| | 6 | 55 | | return sb.ToString().TrimEnd(); |
| | | 56 | | } |
| | | 57 | | |
| | | 58 | | public static string FormatBrief( |
| | | 59 | | BitrixStockArticleHistoryPageDto page, |
| | | 60 | | string? manufacturerPrefix = null, |
| | | 61 | | int maxReports = DefaultMaxReports) => |
| | 3 | 62 | | FormatNarrative(page, manufacturerPrefix, maxReports); |
| | | 63 | | |
| | | 64 | | public static string FormatNarrative( |
| | | 65 | | BitrixStockArticleHistoryPageDto page, |
| | | 66 | | string? manufacturerPrefix = null, |
| | | 67 | | int maxReports = DefaultMaxReports) => |
| | 18 | 68 | | FormatNarrative(page, manufacturerPrefix, maxReports, MaxRowsPerReport, MaxTotalRows); |
| | | 69 | | |
| | | 70 | | private static string FormatNarrative( |
| | | 71 | | BitrixStockArticleHistoryPageDto page, |
| | | 72 | | string? manufacturerPrefix, |
| | | 73 | | int maxReports, |
| | | 74 | | int maxRowsPerReport, |
| | | 75 | | int maxTotalRows) |
| | | 76 | | { |
| | 24 | 77 | | if (string.IsNullOrWhiteSpace(page.Article)) |
| | 6 | 78 | | return "Артикул не указан."; |
| | | 79 | | |
| | 18 | 80 | | if (page.TotalReportCount == 0) |
| | 1 | 81 | | return $"История синхронизаций Ozon по артикулу «{page.Article}»: отчётов не найдено."; |
| | | 82 | | |
| | 17 | 83 | | var sb = new StringBuilder(); |
| | 17 | 84 | | sb.AppendLine($"=== История синхронизаций по артикулу {page.Article} ==="); |
| | 17 | 85 | | if (!string.IsNullOrWhiteSpace(manufacturerPrefix)) |
| | 1 | 86 | | sb.AppendLine($"Product key: {page.Article}={manufacturerPrefix}"); |
| | 17 | 87 | | sb.AppendLine( |
| | 17 | 88 | | $"Всего отчётов: {page.TotalReportCount}. " + |
| | 17 | 89 | | $"В контексте: {Math.Min(maxReports, page.Reports.Count)} (от старых к новым в выборке)."); |
| | 17 | 90 | | sb.AppendLine(); |
| | | 91 | | |
| | 17 | 92 | | var rowBudget = maxTotalRows; |
| | 110 | 93 | | foreach (var report in page.Reports.Take(maxReports)) |
| | | 94 | | { |
| | 38 | 95 | | if (rowBudget <= 0) break; |
| | | 96 | | |
| | 38 | 97 | | var msk = BitrixStockMskDateTime.Format(report.GeneratedAtUtc); |
| | 38 | 98 | | var client = report.IsMultiClient |
| | 38 | 99 | | ? string.Join(", ", report.MultiClientNames.Values.DefaultIfEmpty(report.OzonClientName).Distinct()) |
| | 38 | 100 | | : report.OzonClientName ?? "—"; |
| | | 101 | | |
| | 38 | 102 | | sb.AppendLine($"— Отчёт {msk} ({client}), id …{ShortReportId(report.ReportId)}:"); |
| | | 103 | | |
| | 38 | 104 | | var rows = report.Rows.Take(Math.Min(maxRowsPerReport, rowBudget)).ToList(); |
| | 38 | 105 | | rowBudget -= rows.Count; |
| | | 106 | | |
| | 176 | 107 | | foreach (var row in rows) |
| | | 108 | | { |
| | 50 | 109 | | sb.AppendLine(FormatNarrativeRow(row, page.HasPrices, page.HasPushes)); |
| | 50 | 110 | | var rule = ExplainActionRule(row.Line); |
| | 50 | 111 | | if (!string.IsNullOrWhiteSpace(rule)) |
| | 49 | 112 | | sb.AppendLine($" Правило: {rule}"); |
| | | 113 | | } |
| | | 114 | | |
| | 38 | 115 | | if (report.Rows.Count > rows.Count) |
| | 1 | 116 | | sb.AppendLine($" …ещё {report.Rows.Count - rows.Count} строк в этом отчёте"); |
| | | 117 | | |
| | 38 | 118 | | sb.AppendLine(); |
| | | 119 | | } |
| | | 120 | | |
| | 17 | 121 | | return sb.ToString().TrimEnd(); |
| | | 122 | | } |
| | | 123 | | |
| | | 124 | | private static void AppendBatchSummary(StringBuilder sb, BitrixStockArticleHistoryPageDto page) |
| | | 125 | | { |
| | 6 | 126 | | var batches = page.Reports |
| | 75 | 127 | | .SelectMany(r => r.Rows.Select(x => x.Line)) |
| | 6 | 128 | | .Select(ResolveBatchInfo) |
| | 38 | 129 | | .Where(b => b.Multiplier > 1) |
| | 3 | 130 | | .GroupBy(b => b.Multiplier) |
| | 3 | 131 | | .OrderBy(g => g.Key) |
| | 6 | 132 | | .ToList(); |
| | | 133 | | |
| | 10 | 134 | | if (batches.Count == 0) return; |
| | | 135 | | |
| | 2 | 136 | | sb.AppendLine("--- Партии [N] по артикулу ---"); |
| | 10 | 137 | | foreach (var g in batches) |
| | | 138 | | { |
| | 3 | 139 | | var sample = g.First(); |
| | 3 | 140 | | sb.AppendLine( |
| | 3 | 141 | | $"• Партия ×{g.Key}: OfferId «{sample.OfferId}» → на Ozon floor(1С/{g.Key}) упаковок; " + |
| | 3 | 142 | | $"цена = PriceOptimizationManager × {g.Key} (этап 5a или этап 2 с BatchMultiplier)."); |
| | 3 | 143 | | if (!string.IsNullOrWhiteSpace(sample.BaseArticle)) |
| | 2 | 144 | | sb.AppendLine($" Базовый артикул в 1С: «{sample.BaseArticle}»."); |
| | | 145 | | } |
| | | 146 | | |
| | 2 | 147 | | sb.AppendLine(); |
| | 2 | 148 | | } |
| | | 149 | | |
| | | 150 | | private static void AppendPriceChronology(StringBuilder sb, BitrixStockArticleHistoryPageDto page) |
| | | 151 | | { |
| | 6 | 152 | | var events = new List<(DateTime When, string Text)>(); |
| | | 153 | | |
| | 123 | 154 | | foreach (var report in page.Reports.OrderBy(r => r.GeneratedAtUtc)) |
| | | 155 | | { |
| | 37 | 156 | | var msk = BitrixStockMskDateTime.Format(report.GeneratedAtUtc); |
| | 150 | 157 | | foreach (var row in report.Rows) |
| | | 158 | | { |
| | 38 | 159 | | var w = row.Line; |
| | 38 | 160 | | var pi = row.Price; |
| | 38 | 161 | | if (pi == null) continue; |
| | | 162 | | |
| | 34 | 163 | | if (pi.PricePushedNew.HasValue || !string.IsNullOrWhiteSpace(pi.PricePushStatus)) |
| | | 164 | | { |
| | 31 | 165 | | var status = string.IsNullOrWhiteSpace(pi.PricePushStatus) ? "изменена" : pi.PricePushStatus; |
| | 31 | 166 | | events.Add(( |
| | 31 | 167 | | report.GeneratedAtUtc, |
| | 31 | 168 | | $"{msk}: этап 4 — пуш цены {pi.PricePushedOld:N0} → {pi.PricePushedNew:N0} ₽ ({status}), " + |
| | 31 | 169 | | $"склад Ozon «{w.OzonWarehouseName}»")); |
| | | 170 | | } |
| | 3 | 171 | | else if (w.BatchPushedPrice.HasValue) |
| | | 172 | | { |
| | 1 | 173 | | events.Add(( |
| | 1 | 174 | | report.GeneratedAtUtc, |
| | 1 | 175 | | $"{msk}: этап 5a — цена партии ×{w.BatchMultiplier} = {w.BatchPushedPrice:N0} ₽, " + |
| | 1 | 176 | | $"OfferId «{w.OfferId}»")); |
| | | 177 | | } |
| | 3 | 178 | | else if (pi.TruePrice.HasValue && events.All(e => !e.Text.Contains("индекс"))) |
| | | 179 | | { |
| | 1 | 180 | | var idx = BitrixStockSyncReportRowPresenter.FormatPriceIndex(pi.ColorIndex); |
| | 1 | 181 | | if (!string.IsNullOrWhiteSpace(idx)) |
| | | 182 | | { |
| | 1 | 183 | | events.Add(( |
| | 1 | 184 | | report.GeneratedAtUtc, |
| | 1 | 185 | | $"{msk}: снимок цены Ozon {pi.TruePrice:N0} ₽, индекс «{idx}», C0 {w.OneCPrice:N0} ₽")); |
| | | 186 | | } |
| | | 187 | | } |
| | | 188 | | } |
| | | 189 | | } |
| | | 190 | | |
| | 9 | 191 | | if (events.Count == 0) return; |
| | | 192 | | |
| | 3 | 193 | | sb.AppendLine("--- Хронология цен (все отчёты в контексте) ---"); |
| | 95 | 194 | | foreach (var (_, text) in events.OrderBy(e => e.When).Take(25)) |
| | 28 | 195 | | sb.AppendLine($" • {text}"); |
| | 3 | 196 | | sb.AppendLine(); |
| | 3 | 197 | | } |
| | | 198 | | |
| | | 199 | | public static string ExplainActionRule(BitrixStockSyncReportWarehouseLineDto w) |
| | | 200 | | { |
| | 66 | 201 | | var action = w.Action ?? ""; |
| | 66 | 202 | | var batchN = w.BatchMultiplier > 1 |
| | 66 | 203 | | ? w.BatchMultiplier |
| | 66 | 204 | | : BitrixStockOrphanOfferMatching.ExtractBatchMultiplier(w.OfferId); |
| | | 205 | | |
| | 66 | 206 | | if (w.IsOzonOrphan) |
| | 1 | 207 | | return "этап 5b: сирота — остаток на Ozon без покрытия в снэпшоте 1С → обнуление (OzonZero)"; |
| | | 208 | | |
| | 65 | 209 | | if (string.Equals(action, BitrixStockSyncReportActions.BatchVariant, StringComparison.OrdinalIgnoreCase) |
| | 65 | 210 | | || batchN > 1) |
| | | 211 | | { |
| | 6 | 212 | | var packs = batchN > 1 ? (int)Math.Floor(w.OneCQty / (double)batchN) : (int?)null; |
| | 6 | 213 | | return batchN > 1 |
| | 6 | 214 | | ? $"этап 5a/2 партия ×{batchN}: floor({w.OneCQty}/{batchN})={packs} упак. на Ozon «{w.OzonWarehouseName} |
| | 6 | 215 | | : "партийный товар: пересчёт штук в упаковки"; |
| | | 216 | | } |
| | | 217 | | |
| | 59 | 218 | | if (string.Equals(action, BitrixStockSyncReportActions.BatchVariantDisabledLink, StringComparison.OrdinalIgnoreC |
| | 1 | 219 | | return "этап 5a: склад в ApplyDisabledWarehouseMappingIds → Stock=0 (⓪ связь снята)"; |
| | | 220 | | |
| | 58 | 221 | | if (string.Equals(action, BitrixStockSyncReportActions.CleanupExtra, StringComparison.OrdinalIgnoreCase)) |
| | 1 | 222 | | return "этап 3: лишний FBS-склад Ozon (не в защищённых) → обнуление CleanupExtra"; |
| | | 223 | | |
| | 57 | 224 | | if (string.Equals(action, BitrixStockSyncReportActions.ClearDisabledLink, StringComparison.OrdinalIgnoreCase)) |
| | 1 | 225 | | return "этап 2: связь склада отключена в пресете → принудительное обнуление"; |
| | | 226 | | |
| | 56 | 227 | | if (string.Equals(action, BitrixStockSyncReportActions.Push, StringComparison.OrdinalIgnoreCase)) |
| | | 228 | | { |
| | 48 | 229 | | var reserve = w.ReservedQty > 0 ? $", резерв заказов {w.ReservedQty} шт. вычтен из 1С" : ""; |
| | 48 | 230 | | return $"этап 1→2: Ozon {w.OzonQty} < 1С {w.OneCQty} шт.{reserve} → накат цели {w.OneCQty} шт."; |
| | | 231 | | } |
| | | 232 | | |
| | 8 | 233 | | if (string.Equals(action, BitrixStockSyncReportActions.Decrease, StringComparison.OrdinalIgnoreCase)) |
| | 1 | 234 | | return $"этап 1→2: Ozon {w.OzonQty} > 1С {w.OneCQty} шт. → уменьшение до {w.OneCQty} шт."; |
| | | 235 | | |
| | 7 | 236 | | if (string.Equals(action, BitrixStockSyncReportActions.Clear, StringComparison.OrdinalIgnoreCase)) |
| | 1 | 237 | | return "этап 1→2: остаток 1С=0 → обнуление на Ozon (Clear)"; |
| | | 238 | | |
| | 6 | 239 | | if (string.Equals(action, BitrixStockSyncReportActions.Match, StringComparison.OrdinalIgnoreCase)) |
| | 1 | 240 | | return "этап 1: остатки совпадают (Match), накат не требуется"; |
| | | 241 | | |
| | 5 | 242 | | if (string.Equals(action, BitrixStockSyncReportActions.NotFound, StringComparison.OrdinalIgnoreCase)) |
| | 1 | 243 | | return "этап 1: артикул не найден в каталоге Ozon (NotFound)"; |
| | | 244 | | |
| | 4 | 245 | | if (string.Equals(action, BitrixStockSyncReportActions.FbsNoWarehouse, StringComparison.OrdinalIgnoreCase)) |
| | 1 | 246 | | return "этап 1: FBS без привязки склада — нужен WarehouseMapping (FbsNoWarehouse)"; |
| | | 247 | | |
| | 3 | 248 | | if (!string.IsNullOrWhiteSpace(w.MappingDescription)) |
| | 1 | 249 | | return $"маппинг: {w.MappingDescription}"; |
| | | 250 | | |
| | 2 | 251 | | return ""; |
| | | 252 | | } |
| | | 253 | | |
| | | 254 | | private static string FormatNarrativeRow( |
| | | 255 | | BitrixStockArticleHistoryRowDto row, |
| | | 256 | | bool hasPrices, |
| | | 257 | | bool hasPushes) |
| | | 258 | | { |
| | 50 | 259 | | var w = row.Line; |
| | 50 | 260 | | var pi = row.Price; |
| | 50 | 261 | | var oneCStore = w.OneCStore ?? "—"; |
| | 50 | 262 | | var ozonWh = w.OzonWarehouseName ?? "—"; |
| | 50 | 263 | | var apply = BitrixStockSyncReportRowPresenter.FormatOzonApplyStatus(w); |
| | 50 | 264 | | var action = w.ActionLabel ?? w.Action ?? "—"; |
| | | 265 | | |
| | 50 | 266 | | var sb = new StringBuilder(); |
| | 50 | 267 | | if (!string.IsNullOrWhiteSpace(w.OfferId)) |
| | 49 | 268 | | sb.Append($" OfferId «{w.OfferId}»: "); |
| | | 269 | | |
| | 50 | 270 | | sb.Append($"склад 1С «{oneCStore}» → Ozon «{ozonWh}»: "); |
| | 50 | 271 | | sb.Append($"1С {w.OneCQty} шт., Ozon {w.OzonQty} шт."); |
| | | 272 | | |
| | 50 | 273 | | if (w.ReservedQty > 0) |
| | 1 | 274 | | sb.Append($" (резерв {w.ReservedQty} шт.)"); |
| | | 275 | | |
| | 50 | 276 | | if (w.OzonQtyAfter.HasValue) |
| | 1 | 277 | | sb.Append($" → после этапа 2: {w.OzonQtyAfter} шт. на Ozon"); |
| | | 278 | | |
| | 50 | 279 | | sb.Append($" | действие «{action}»"); |
| | | 280 | | |
| | 50 | 281 | | if (!string.IsNullOrWhiteSpace(apply)) |
| | 0 | 282 | | sb.Append($", накат: {apply}"); |
| | | 283 | | |
| | 50 | 284 | | if (w.OneCPrice.HasValue) |
| | | 285 | | { |
| | 3 | 286 | | var deltaC0 = BitrixStockSyncReportRowPresenter.FormatDeltaC0(w.OneCPrice, w.PrevOneCPrice); |
| | 3 | 287 | | sb.Append($". C0 {w.OneCPrice.Value:N0} ₽"); |
| | 3 | 288 | | if (!string.IsNullOrWhiteSpace(deltaC0)) |
| | 1 | 289 | | sb.Append($" ({deltaC0})"); |
| | | 290 | | } |
| | | 291 | | |
| | 50 | 292 | | if (hasPrices && pi != null) |
| | | 293 | | { |
| | 2 | 294 | | if (pi.TruePrice.HasValue) |
| | 2 | 295 | | sb.Append($". Цена Ozon {pi.TruePrice.Value:N0} ₽"); |
| | 2 | 296 | | if (pi.SellingPrice.HasValue && pi.SellingPrice != pi.TruePrice) |
| | 1 | 297 | | sb.Append($", витрина {pi.SellingPrice.Value:N0} ₽"); |
| | 2 | 298 | | if (!string.IsNullOrWhiteSpace(pi.ColorIndex)) |
| | | 299 | | { |
| | 1 | 300 | | var indexLabel = BitrixStockSyncReportRowPresenter.FormatPriceIndex(pi.ColorIndex); |
| | 1 | 301 | | if (!string.IsNullOrWhiteSpace(indexLabel)) |
| | 1 | 302 | | sb.Append($", индекс «{indexLabel}»"); |
| | | 303 | | } |
| | | 304 | | } |
| | | 305 | | |
| | 50 | 306 | | if (hasPushes && pi != null && |
| | 50 | 307 | | (pi.PricePushedOld.HasValue || pi.PricePushedNew.HasValue || !string.IsNullOrWhiteSpace(pi.PricePushStatus)) |
| | | 308 | | { |
| | 2 | 309 | | if (pi.PricePushedOld.HasValue || pi.PricePushedNew.HasValue) |
| | 1 | 310 | | sb.Append($". Этап 4: {pi.PricePushedOld:N0} → {pi.PricePushedNew:N0} ₽"); |
| | 2 | 311 | | if (!string.IsNullOrWhiteSpace(pi.PricePushStatus)) |
| | 2 | 312 | | sb.Append($" ({pi.PricePushStatus})"); |
| | 2 | 313 | | if (pi.PricePushedAtUtc.HasValue) |
| | 2 | 314 | | sb.Append($", {BitrixStockMskDateTime.Format(pi.PricePushedAtUtc.Value)}"); |
| | | 315 | | } |
| | | 316 | | |
| | 50 | 317 | | if (w.BatchPushedPrice.HasValue) |
| | 2 | 318 | | sb.Append($". Этап 5a цена партии: {w.BatchPushedPrice:N0} ₽"); |
| | | 319 | | |
| | 50 | 320 | | if (!string.IsNullOrWhiteSpace(w.Note)) |
| | 1 | 321 | | sb.Append($". {w.Note}"); |
| | | 322 | | |
| | 50 | 323 | | sb.Append('.'); |
| | 50 | 324 | | return sb.ToString(); |
| | | 325 | | } |
| | | 326 | | |
| | | 327 | | private static (int Multiplier, string? OfferId, string? BaseArticle) ResolveBatchInfo( |
| | | 328 | | BitrixStockSyncReportWarehouseLineDto w) |
| | | 329 | | { |
| | 38 | 330 | | var mult = w.BatchMultiplier > 1 |
| | 38 | 331 | | ? w.BatchMultiplier |
| | 38 | 332 | | : BitrixStockOrphanOfferMatching.ExtractBatchMultiplier(w.OfferId); |
| | 38 | 333 | | return (mult, w.OfferId, w.BatchBaseArticle); |
| | | 334 | | } |
| | | 335 | | |
| | | 336 | | private static string ShortReportId(string? reportId) |
| | | 337 | | { |
| | 38 | 338 | | if (string.IsNullOrWhiteSpace(reportId)) return "—"; |
| | 38 | 339 | | return reportId.Length <= 8 ? reportId : reportId[^8..]; |
| | | 340 | | } |
| | | 341 | | } |