| | | 1 | | using System.Net; |
| | | 2 | | using System.Text; |
| | | 3 | | using OzonDomains.Models; |
| | | 4 | | using Services.ApiServices._1CApi.Models; |
| | | 5 | | using Services.ApiServices._1CApi.OData; |
| | | 6 | | |
| | | 7 | | namespace OzonOrdersWeb.Areas.Studio2.Helpers; |
| | | 8 | | |
| | | 9 | | /// <summary> |
| | | 10 | | /// Формирует краткую сводку для алерта и полную детализацию для комментария транзакции 1С. |
| | | 11 | | /// </summary> |
| | | 12 | | public static class OneCTransactionSummaryHelper |
| | | 13 | | { |
| | | 14 | | public static string WrapSection(string sectionTitle, string innerHtml) |
| | | 15 | | { |
| | 2 | 16 | | if (string.IsNullOrWhiteSpace(innerHtml)) |
| | 1 | 17 | | return string.Empty; |
| | | 18 | | |
| | 1 | 19 | | if (sectionTitle is "Проведённые документы 1С" or "Черновики 1С по дефицитным позициям") |
| | 0 | 20 | | return innerHtml; |
| | | 21 | | |
| | 1 | 22 | | var sb = new StringBuilder(); |
| | 1 | 23 | | sb.Append("<div class='mb-2'>"); |
| | 1 | 24 | | sb.Append($"<div class='fw-semibold small text-muted mb-1'>{H(sectionTitle)}</div>"); |
| | 1 | 25 | | sb.Append(innerHtml); |
| | 1 | 26 | | sb.Append("</div>"); |
| | 1 | 27 | | return sb.ToString(); |
| | | 28 | | } |
| | | 29 | | |
| | | 30 | | /// <summary> |
| | | 31 | | /// Краткая сводка для алерта: склады, количество товаров, номер документа 1С, GUID. |
| | | 32 | | /// </summary> |
| | | 33 | | public static string BuildAlertSummary( |
| | | 34 | | List<Order> ordersToTransfer, |
| | | 35 | | List<OneCResponse> transferResult, |
| | | 36 | | string? warehouseSender = null, |
| | | 37 | | string? warehouseRecipient = null) |
| | | 38 | | { |
| | 19 | 39 | | transferResult ??= new List<OneCResponse>(); |
| | 41 | 40 | | var successful = transferResult.Where(r => r.Success).ToList(); |
| | 41 | 41 | | var failed = transferResult.Where(r => !r.Success).ToList(); |
| | | 42 | | |
| | 19 | 43 | | var sb = new StringBuilder(); |
| | | 44 | | |
| | 19 | 45 | | var draftsWithMissing = successful |
| | 20 | 46 | | .Where(r => r.IsDraft || !string.IsNullOrWhiteSpace(r.MissingNomenclature)) |
| | 19 | 47 | | .ToList(); |
| | 19 | 48 | | var postingFailures = successful |
| | 20 | 49 | | .Where(r => !r.IsPosted && !string.IsNullOrWhiteSpace(r.PostingError)) |
| | 19 | 50 | | .ToList(); |
| | | 51 | | |
| | 19 | 52 | | if (draftsWithMissing.Any()) |
| | 3 | 53 | | return BuildDraftAlertSummary(ordersToTransfer, successful, draftsWithMissing, warehouseSender, warehouseRec |
| | | 54 | | |
| | 29 | 55 | | if (successful.Any() && failed.Count == 0 && successful.All(r => r.IsPosted)) |
| | 8 | 56 | | return BuildPostedAlertSummary(ordersToTransfer, successful, warehouseSender, warehouseRecipient); |
| | | 57 | | |
| | 8 | 58 | | if (successful.Any()) |
| | | 59 | | { |
| | 12 | 60 | | var allPosted = successful.All(r => r.IsPosted); |
| | 6 | 61 | | var alertClass = postingFailures.Any() || draftsWithMissing.Any() |
| | 6 | 62 | | ? "alert-warning" |
| | 6 | 63 | | : allPosted ? "alert-success" : "alert-warning"; |
| | 6 | 64 | | var title = draftsWithMissing.Any() |
| | 6 | 65 | | ? "⚠ Создано в 1С как черновик" |
| | 6 | 66 | | : postingFailures.Any() |
| | 6 | 67 | | ? "⚠ Создано в 1С, проведение не выполнено" |
| | 6 | 68 | | : allPosted |
| | 6 | 69 | | ? "✅ Успешно создано в 1С" |
| | 6 | 70 | | : "⚠ Создано в 1С, проведение не выполнено"; |
| | 6 | 71 | | sb.Append($"<div class='alert {alertClass} mb-2'>"); |
| | 6 | 72 | | sb.Append($"<strong>{title}</strong>"); |
| | 6 | 73 | | sb.Append("<ul class='list-unstyled mb-0 small text-secondary mt-1'>"); |
| | | 74 | | |
| | | 75 | | // Организация |
| | 6 | 76 | | var orgs = ordersToTransfer |
| | 0 | 77 | | .Select(o => o.OzonClient?.Name?.Trim()) |
| | 0 | 78 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 6 | 79 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 6 | 80 | | .ToList(); |
| | 6 | 81 | | var inns = ordersToTransfer |
| | 0 | 82 | | .Select(o => o.OzonClient?.INNCode?.Trim()) |
| | 0 | 83 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 6 | 84 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 6 | 85 | | .ToList(); |
| | 6 | 86 | | if (orgs.Any()) |
| | | 87 | | { |
| | 0 | 88 | | var innPart = inns.Any() ? $" (ИНН {H(string.Join(", ", inns))})" : ""; |
| | 0 | 89 | | sb.Append($"<li><span class='text-muted'>Орг.:</span> {H(string.Join(", ", orgs))}{innPart}</li>"); |
| | | 90 | | } |
| | | 91 | | |
| | | 92 | | // Отправитель (поставщик) |
| | 6 | 93 | | var senders = ordersToTransfer |
| | 0 | 94 | | .Select(o => o.Supplier?.Name?.Trim()) |
| | 0 | 95 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 6 | 96 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 6 | 97 | | .ToList(); |
| | 6 | 98 | | if (senders.Any()) |
| | 0 | 99 | | sb.Append($"<li><span class='text-muted'>Отпр.:</span> {H(string.Join(", ", senders))}</li>"); |
| | 6 | 100 | | else if (ordersToTransfer.Any()) |
| | 0 | 101 | | sb.Append("<li><span class='text-muted'>Отпр.:</span> Не указан</li>"); |
| | | 102 | | |
| | | 103 | | // Склад отправителя |
| | 6 | 104 | | var senderWarehouses = !string.IsNullOrEmpty(warehouseSender) |
| | 6 | 105 | | ? new List<string> { warehouseSender.Trim() } |
| | 6 | 106 | | : ordersToTransfer.Select(GetEffectiveWarehouse) |
| | 6 | 107 | | .Where(x => !string.IsNullOrEmpty(x)).Distinct(StringComparer.OrdinalIgnoreCase).ToList(); |
| | 6 | 108 | | if (senderWarehouses.Any()) |
| | 0 | 109 | | sb.Append($"<li><span class='text-muted'>Склад отпр.:</span> {H(string.Join(", ", senderWarehouses))}</l |
| | | 110 | | |
| | | 111 | | // Склад получателя |
| | 6 | 112 | | var recipientWarehouses = !string.IsNullOrEmpty(warehouseRecipient) |
| | 6 | 113 | | ? new List<string> { warehouseRecipient.Trim() } |
| | 0 | 114 | | : ordersToTransfer.Select(o => o.OzonClient?.WarehouseName?.Trim()) |
| | 0 | 115 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 0 | 116 | | .Select(x => x!) |
| | 6 | 117 | | .Distinct(StringComparer.OrdinalIgnoreCase).ToList(); |
| | 6 | 118 | | if (recipientWarehouses.Any()) |
| | 0 | 119 | | sb.Append($"<li><span class='text-muted'>Склад получ.:</span> {H(string.Join(", ", recipientWarehouses)) |
| | | 120 | | |
| | | 121 | | // Заказы / товары / артикулы |
| | 6 | 122 | | var productGroups = ResolveProducts(ordersToTransfer, successful); |
| | | 123 | | |
| | 6 | 124 | | if (productGroups.Any()) |
| | | 125 | | { |
| | 0 | 126 | | var articleParts = productGroups.Take(4).Select(FormatProduct).ToList(); |
| | 0 | 127 | | var remaining = productGroups.Count - articleParts.Count; |
| | 0 | 128 | | var articlesStr = string.Join(", ", articleParts) + (remaining > 0 ? $" +{remaining}" : ""); |
| | 0 | 129 | | sb.Append($"<li>{BuildCountsLine(ordersToTransfer.Count, productGroups)} — {articlesStr}</li>"); |
| | | 130 | | } |
| | | 131 | | |
| | | 132 | | // Документов + IsPosted badge |
| | 6 | 133 | | var postedBadge = allPosted |
| | 6 | 134 | | ? "<span class='badge bg-success-subtle text-success ms-1'>✔ проведено</span>" |
| | 6 | 135 | | : draftsWithMissing.Any() |
| | 6 | 136 | | ? "<span class='badge bg-warning-subtle text-warning ms-1'>⚠ черновик</span>" |
| | 6 | 137 | | : "<span class='badge bg-warning-subtle text-warning ms-1'>⚠ не проведено</span>"; |
| | 6 | 138 | | sb.Append($"<li>{Plural(successful.Count, "документ", "документа", "документов")} {postedBadge}</li>"); |
| | | 139 | | |
| | 6 | 140 | | if (draftsWithMissing.Any()) |
| | | 141 | | { |
| | 0 | 142 | | var missingList = draftsWithMissing |
| | 0 | 143 | | .Select(d => d.MissingNomenclature) |
| | 0 | 144 | | .Where(m => !string.IsNullOrWhiteSpace(m)) |
| | 0 | 145 | | .Distinct() |
| | 0 | 146 | | .ToList(); |
| | | 147 | | // Проверяем есть ли документы где ВСЕ позиции без номенклатуры (пустые строки) |
| | 0 | 148 | | var allMissingDocs = draftsWithMissing.Where(r => !r.IsPosted).ToList(); |
| | 0 | 149 | | if (allMissingDocs.Count == successful.Count && missingList.Any()) |
| | 0 | 150 | | sb.Append("<li class='text-warning-emphasis fw-semibold'>⚠ Все позиции отсутствуют в номенклатуре 1С |
| | 0 | 151 | | if (missingList.Any()) |
| | | 152 | | { |
| | 0 | 153 | | sb.Append("<li class='text-warning-emphasis'><span class='text-muted'>Без номенклатуры:</span> "); |
| | 0 | 154 | | sb.Append(H(string.Join("; ", missingList))); |
| | 0 | 155 | | sb.Append("</li>"); |
| | | 156 | | } |
| | | 157 | | } |
| | | 158 | | |
| | 6 | 159 | | var createdNomenclature = successful |
| | 8 | 160 | | .Select(r => r.CreatedNomenclature) |
| | 8 | 161 | | .Where(x => !string.IsNullOrWhiteSpace(x)) |
| | 6 | 162 | | .Distinct() |
| | 6 | 163 | | .ToList(); |
| | 6 | 164 | | if (createdNomenclature.Any()) |
| | 0 | 165 | | sb.Append($"<li class='text-info-emphasis'><span class='text-muted'>Создана номенклатура 1С:</span> {H(s |
| | | 166 | | |
| | | 167 | | // Номера документов (читаемые) — со ссылками на страницу документа |
| | 6 | 168 | | var docLinks = successful |
| | 8 | 169 | | .Where(s => !string.IsNullOrWhiteSpace(s.DocumentNumber) || !string.IsNullOrWhiteSpace(s.TransactionId)) |
| | 2 | 170 | | .DistinctBy(s => s.TransactionId ?? s.DocumentNumber) |
| | 6 | 171 | | .Take(5) |
| | 6 | 172 | | .Select(s => |
| | 6 | 173 | | { |
| | 2 | 174 | | var label = !string.IsNullOrWhiteSpace(s.DocumentNumber) ? s.DocumentNumber : s.TransactionId; |
| | 2 | 175 | | if (!string.IsNullOrWhiteSpace(s.TransactionId) && Guid.TryParse(s.TransactionId, out _)) |
| | 0 | 176 | | return $"<a href='/Studio2/OneCDocument/Details?refKey={H(s.TransactionId)}' target='_blank'>{H( |
| | 2 | 177 | | return H(label); |
| | 6 | 178 | | }) |
| | 6 | 179 | | .ToList(); |
| | 6 | 180 | | if (docLinks.Any()) |
| | 2 | 181 | | sb.Append($"<li class='fw-medium text-dark'>{string.Join(", ", docLinks)}</li>"); |
| | | 182 | | |
| | | 183 | | // Ошибки проведения (например, нехватка остатков на складе 1С) |
| | 6 | 184 | | if (postingFailures.Any()) |
| | | 185 | | { |
| | 4 | 186 | | sb.Append("<li class='text-danger fw-semibold mt-1'>⛔ Ошибка проведения в 1С:</li>"); |
| | 24 | 187 | | foreach (var group in postingFailures.GroupBy(r => OneCODataErrorFormatter.Format(r.PostingError))) |
| | | 188 | | { |
| | 5 | 189 | | var err = OneCResponseErrors.AppendOneCDetails(group.Key, group) ?? group.Key; |
| | 5 | 190 | | var docLabels = group |
| | 6 | 191 | | .Select(r => !string.IsNullOrWhiteSpace(r.DocumentNumber) |
| | 6 | 192 | | ? $"№{r.DocumentNumber}" |
| | 6 | 193 | | : !string.IsNullOrWhiteSpace(r.TransactionId) |
| | 6 | 194 | | ? r.TransactionId |
| | 6 | 195 | | : "документ") |
| | 5 | 196 | | .Distinct() |
| | 5 | 197 | | .ToList(); |
| | 5 | 198 | | var docLabel = string.Join(", ", docLabels); |
| | 5 | 199 | | sb.Append($"<li class='text-danger small'><span class='fw-medium'>{H(docLabel)}:</span> {H(err)}</li |
| | | 200 | | } |
| | | 201 | | } |
| | | 202 | | |
| | | 203 | | // GUID (для поиска / перехода в 1С) |
| | 6 | 204 | | var guids = successful |
| | 8 | 205 | | .Select(s => s.TransactionId) |
| | 8 | 206 | | .Where(id => !string.IsNullOrWhiteSpace(id)) |
| | 6 | 207 | | .Distinct().Take(5).ToList(); |
| | 6 | 208 | | if (guids.Any()) |
| | 0 | 209 | | sb.Append($"<li class='font-monospace text-muted user-select-all' style='font-size:0.78em'>{H(string.Joi |
| | | 210 | | |
| | 6 | 211 | | sb.Append("</ul></div>"); |
| | | 212 | | } |
| | | 213 | | |
| | 8 | 214 | | if (failed.Any()) |
| | | 215 | | { |
| | 2 | 216 | | sb.Append("<div class='alert alert-warning'>"); |
| | 2 | 217 | | sb.Append("<strong>⚠️ С ошибками</strong><br/>"); |
| | 2 | 218 | | sb.Append($"Ошибок: {failed.Count}<br/>"); |
| | 4 | 219 | | var errors = failed.Select(f => f.Message).Distinct().Take(2); |
| | 2 | 220 | | sb.Append($"<small>{H(string.Join("; ", errors))}</small>"); |
| | 2 | 221 | | if (failed.Count > 2) sb.Append("..."); |
| | 2 | 222 | | sb.Append("</div>"); |
| | | 223 | | } |
| | | 224 | | |
| | 8 | 225 | | return sb.ToString(); |
| | | 226 | | } |
| | | 227 | | |
| | | 228 | | /// <summary> |
| | | 229 | | /// Позиции для сводки. Приоритет — строки, реально ушедшие в документ 1С: при утере |
| | | 230 | | /// реализатором в транзит уходит остаток склада, а не Quantity заказа, и показывать «×1» |
| | | 231 | | /// там, где в 1С записано 9, нельзя. Если строк в ответе нет (старые вызовы, ошибки |
| | | 232 | | /// создания документа) — считаем по заказам. |
| | | 233 | | /// </summary> |
| | | 234 | | private static List<(string Article, decimal Qty)> ResolveProducts( |
| | | 235 | | List<Order> orders, |
| | | 236 | | List<OneCResponse> successful) |
| | | 237 | | { |
| | 17 | 238 | | var fromDocument = successful |
| | 20 | 239 | | .Where(r => r.DocumentLines != null) |
| | 1 | 240 | | .SelectMany(r => r.DocumentLines!) |
| | 1 | 241 | | .Where(l => !string.IsNullOrWhiteSpace(l.Article) && l.Quantity > 0) |
| | 1 | 242 | | .GroupBy(l => l.Article.Trim(), StringComparer.OrdinalIgnoreCase) |
| | 2 | 243 | | .Select(g => (Article: g.Key, Qty: g.Sum(l => l.Quantity))) |
| | 1 | 244 | | .OrderByDescending(x => x.Qty) |
| | 17 | 245 | | .ToList(); |
| | 17 | 246 | | if (fromDocument.Count > 0) |
| | 1 | 247 | | return fromDocument; |
| | | 248 | | |
| | 16 | 249 | | return orders |
| | 6 | 250 | | .Where(o => !string.IsNullOrWhiteSpace(o.Article) && o.Quantity > 0) |
| | 6 | 251 | | .GroupBy(o => o.Article!.Trim(), StringComparer.OrdinalIgnoreCase) |
| | 12 | 252 | | .Select(g => (Article: g.Key, Qty: (decimal)g.Sum(o => o.Quantity ?? 0))) |
| | 6 | 253 | | .OrderByDescending(x => x.Qty) |
| | 16 | 254 | | .ToList(); |
| | | 255 | | } |
| | | 256 | | |
| | | 257 | | /// <summary>«1 заказ», «2 заказа», «5 заказов».</summary> |
| | | 258 | | private static string Plural(decimal value, string one, string few, string many) |
| | | 259 | | { |
| | 20 | 260 | | var text = FormatQty(value); |
| | 20 | 261 | | if (value != Math.Truncate(value)) |
| | 0 | 262 | | return $"{text} {many}"; |
| | | 263 | | |
| | 20 | 264 | | var n = (long)Math.Abs(Math.Truncate(value)); |
| | 20 | 265 | | var mod100 = n % 100; |
| | 20 | 266 | | var mod10 = n % 10; |
| | 20 | 267 | | var word = mod100 is >= 11 and <= 14 ? many |
| | 20 | 268 | | : mod10 == 1 ? one |
| | 20 | 269 | | : mod10 is >= 2 and <= 4 ? few |
| | 20 | 270 | | : many; |
| | 20 | 271 | | return $"{text} {word}"; |
| | | 272 | | } |
| | | 273 | | |
| | | 274 | | private static string FormatQty(decimal value) => |
| | 31 | 275 | | value == Math.Truncate(value) |
| | 31 | 276 | | ? ((long)value).ToString() |
| | 31 | 277 | | : value.ToString("0.###"); |
| | | 278 | | |
| | | 279 | | /// <summary>«1 заказ · 1 позиция · 9 шт» — без «заказ(ов)» и прочих скобок.</summary> |
| | | 280 | | private static string BuildCountsLine(int ordersCount, List<(string Article, decimal Qty)> products) |
| | | 281 | | { |
| | 11 | 282 | | var parts = new List<string> { Plural(ordersCount, "заказ", "заказа", "заказов") }; |
| | 11 | 283 | | if (products.Count > 0) |
| | | 284 | | { |
| | 3 | 285 | | parts.Add(Plural(products.Count, "позиция", "позиции", "позиций")); |
| | 10 | 286 | | parts.Add($"{FormatQty(products.Sum(p => p.Qty))} шт"); |
| | | 287 | | } |
| | | 288 | | |
| | 11 | 289 | | return string.Join(" · ", parts); |
| | | 290 | | } |
| | | 291 | | |
| | | 292 | | private static string FormatProduct((string Article, decimal Qty) product) => |
| | 7 | 293 | | $"{H(product.Article)} × {FormatQty(product.Qty)}"; |
| | | 294 | | |
| | | 295 | | private static string BuildDraftAlertSummary( |
| | | 296 | | List<Order> orders, |
| | | 297 | | List<OneCResponse> successful, |
| | | 298 | | List<OneCResponse> drafts, |
| | | 299 | | string? warehouseSender, |
| | | 300 | | string? warehouseRecipient) |
| | | 301 | | { |
| | 3 | 302 | | var organization = orders.Select(o => o.OzonClient?.Name?.Trim()).FirstOrDefault(x => !string.IsNullOrWhiteSpace |
| | 3 | 303 | | var sender = !string.IsNullOrWhiteSpace(warehouseSender) |
| | 3 | 304 | | ? warehouseSender.Trim() |
| | 3 | 305 | | : orders.Select(GetEffectiveWarehouse).FirstOrDefault(x => !string.IsNullOrWhiteSpace(x)) ?? "—"; |
| | 3 | 306 | | var recipient = !string.IsNullOrWhiteSpace(warehouseRecipient) |
| | 3 | 307 | | ? warehouseRecipient.Trim() |
| | 3 | 308 | | : orders.Select(o => o.OzonClient?.WarehouseName?.Trim()).FirstOrDefault(x => !string.IsNullOrWhiteSpace(x)) |
| | 3 | 309 | | var products = ResolveProducts(orders, successful); |
| | 7 | 310 | | var firstDocument = successful.FirstOrDefault(r => !string.IsNullOrWhiteSpace(r.DocumentNumber) || !string.IsNul |
| | 3 | 311 | | var documentLabel = firstDocument?.DocumentNumber ?? "Черновик 1С"; |
| | 3 | 312 | | var documentLink = firstDocument?.TransactionId is { } transactionId && Guid.TryParse(transactionId, out _) |
| | 3 | 313 | | ? $"<a class='onec-draft-document-link' href='/Studio2/OneCDocument/Details?refKey={H(transactionId)}' targe |
| | 3 | 314 | | : H(documentLabel); |
| | 11 | 315 | | var missing = drafts.Select(d => d.MissingNomenclature).Where(x => !string.IsNullOrWhiteSpace(x)).Distinct().ToL |
| | 11 | 316 | | var guids = successful.Select(s => s.TransactionId).Where(x => !string.IsNullOrWhiteSpace(x)).Distinct().Take(5) |
| | | 317 | | |
| | 3 | 318 | | var sb = new StringBuilder(); |
| | 3 | 319 | | sb.Append("<div class='alert alert-warning mb-2 onec-draft-summary'>"); |
| | 3 | 320 | | sb.Append("<div class='d-flex align-items-start justify-content-between gap-2'>"); |
| | 3 | 321 | | sb.Append("<div><strong>Требуется действие по документу 1С</strong><div class='small text-warning-emphasis'>Черн |
| | 3 | 322 | | sb.Append("<span class='badge bg-warning-subtle text-warning'>Черновик</span></div>"); |
| | 3 | 323 | | sb.Append($"<div class='onec-draft-document mt-2'>{documentLink}</div>"); |
| | 3 | 324 | | sb.Append($"<div class='small text-secondary'>{H(organization)} · {H(sender)} → {H(recipient)}</div>"); |
| | 3 | 325 | | sb.Append($"<div class='small mt-2'>{BuildCountsLine(orders.Count, products)}</div>"); |
| | 3 | 326 | | if (products.Any()) |
| | 0 | 327 | | sb.Append($"<div class='small text-secondary'>{string.Join(" · ", products.Take(3).Select(FormatProduct))}{( |
| | 3 | 328 | | sb.Append("<details class='mt-2'><summary class='small fw-semibold'>Подробнее</summary><div class='small mt-2'>" |
| | 3 | 329 | | sb.Append("<div class='fw-semibold'>Что нужно сделать</div><div class='text-secondary'>Проведите приход в 1С, за |
| | 3 | 330 | | if (missing.Any()) |
| | 2 | 331 | | sb.Append($"<div class='mt-2'><span class='fw-semibold'>Позиции без номенклатуры:</span> {H(string.Join("; " |
| | 3 | 332 | | if (guids.Any()) |
| | 0 | 333 | | sb.Append($"<div class='mt-2 text-muted'>ID 1С: <span class='font-monospace user-select-all'>{H(string.Join( |
| | 3 | 334 | | sb.Append("</div></details></div>"); |
| | 3 | 335 | | return sb.ToString(); |
| | | 336 | | } |
| | | 337 | | |
| | | 338 | | private static string BuildPostedAlertSummary( |
| | | 339 | | List<Order> orders, |
| | | 340 | | List<OneCResponse> successful, |
| | | 341 | | string? warehouseSender, |
| | | 342 | | string? warehouseRecipient) |
| | | 343 | | { |
| | 14 | 344 | | var organization = orders.Select(o => o.OzonClient?.Name?.Trim()).FirstOrDefault(x => !string.IsNullOrWhiteSpace |
| | 22 | 345 | | var inn = orders.Select(o => o.OzonClient?.INNCode?.Trim()).FirstOrDefault(x => !string.IsNullOrWhiteSpace(x)); |
| | 8 | 346 | | var sender = !string.IsNullOrWhiteSpace(warehouseSender) |
| | 8 | 347 | | ? warehouseSender.Trim() |
| | 10 | 348 | | : orders.Select(GetEffectiveWarehouse).FirstOrDefault(x => !string.IsNullOrWhiteSpace(x)) ?? "—"; |
| | 8 | 349 | | var recipient = !string.IsNullOrWhiteSpace(warehouseRecipient) |
| | 8 | 350 | | ? warehouseRecipient.Trim() |
| | 20 | 351 | | : orders.Select(o => o.OzonClient?.WarehouseName?.Trim()).FirstOrDefault(x => !string.IsNullOrWhiteSpace(x)) |
| | 8 | 352 | | var products = ResolveProducts(orders, successful); |
| | 16 | 353 | | var firstDocument = successful.FirstOrDefault(r => !string.IsNullOrWhiteSpace(r.DocumentNumber) || !string.IsNul |
| | 8 | 354 | | var documentLabel = firstDocument?.DocumentNumber ?? "Документ 1С"; |
| | 8 | 355 | | var documentLink = firstDocument?.TransactionId is { } transactionId && Guid.TryParse(transactionId, out _) |
| | 8 | 356 | | ? $"<a class='onec-draft-document-link' href='/Studio2/OneCDocument/Details?refKey={H(transactionId)}' targe |
| | 8 | 357 | | : H(documentLabel); |
| | 24 | 358 | | var guids = successful.Select(s => s.TransactionId).Where(x => !string.IsNullOrWhiteSpace(x)).Distinct().Take(5) |
| | | 359 | | |
| | 8 | 360 | | var sb = new StringBuilder(); |
| | 8 | 361 | | sb.Append("<div class='alert alert-success mb-2 onec-posted-summary'>"); |
| | 8 | 362 | | sb.Append("<div class='d-flex align-items-start justify-content-between gap-2'><strong>Документ 1С создан и пров |
| | 8 | 363 | | sb.Append($"<div class='onec-draft-document mt-2'>{documentLink}</div>"); |
| | 8 | 364 | | sb.Append($"<div class='small text-secondary'>{H(organization)} · {H(sender)} → {H(recipient)}</div>"); |
| | 8 | 365 | | sb.Append($"<div class='small mt-2'>{BuildCountsLine(orders.Count, products)}</div>"); |
| | 8 | 366 | | sb.Append("<details class='mt-2'><summary class='small fw-semibold'>Подробнее</summary><div class='small mt-2'>" |
| | 8 | 367 | | sb.Append($"<div><span class='text-muted'>Клиент:</span> {H(organization)}{(string.IsNullOrWhiteSpace(inn) ? str |
| | 8 | 368 | | sb.Append($"<div><span class='text-muted'>Маршрут:</span> {H(sender)} → {H(recipient)}</div>"); |
| | 8 | 369 | | if (products.Any()) |
| | 3 | 370 | | sb.Append($"<div class='mt-2'><span class='text-muted'>Товары:</span> {string.Join(" · ", products.Select(Fo |
| | 10 | 371 | | if (guids.Any()) sb.Append($"<div class='mt-2 text-muted'>ID 1С: <span class='font-monospace user-select-all'>{H |
| | 8 | 372 | | sb.Append("</div></details></div>"); |
| | 8 | 373 | | return sb.ToString(); |
| | | 374 | | } |
| | | 375 | | |
| | 97 | 376 | | private static string H(string? value) => WebUtility.HtmlEncode(value ?? string.Empty); |
| | | 377 | | |
| | | 378 | | /// <summary> |
| | | 379 | | /// Полная детализация для комментария транзакции: все товары, склады, количества, номера документов. |
| | | 380 | | /// </summary> |
| | | 381 | | public static string BuildCommentDetails( |
| | | 382 | | List<Order> ordersToTransfer, |
| | | 383 | | List<OneCResponse> transferResult, |
| | | 384 | | string? warehouseSender = null, |
| | | 385 | | string? warehouseRecipient = null) |
| | | 386 | | { |
| | 9 | 387 | | transferResult ??= new List<OneCResponse>(); |
| | 19 | 388 | | var successful = transferResult.Where(r => r.Success).ToList(); |
| | 19 | 389 | | var failed = transferResult.Where(r => !r.Success).ToList(); |
| | | 390 | | |
| | 9 | 391 | | var sb = new StringBuilder(); |
| | | 392 | | |
| | 9 | 393 | | var requestSummary = BuildRequestSummary(ordersToTransfer, warehouseSender, warehouseRecipient); |
| | 9 | 394 | | if (!string.IsNullOrWhiteSpace(requestSummary)) |
| | | 395 | | { |
| | 1 | 396 | | sb.Append(requestSummary.Trim().TrimEnd('.')).Append(". "); |
| | | 397 | | } |
| | | 398 | | |
| | | 399 | | // Номера документов |
| | 9 | 400 | | var txIds = successful |
| | 9 | 401 | | .Select(s => !string.IsNullOrWhiteSpace(s.DocumentNumber) ? s.DocumentNumber : s.TransactionId) |
| | 9 | 402 | | .Where(id => !string.IsNullOrWhiteSpace(id)) |
| | 9 | 403 | | .ToList(); |
| | 9 | 404 | | if (txIds.Any()) |
| | | 405 | | { |
| | 3 | 406 | | sb.Append("1С документы: ").Append(string.Join(", ", txIds)).Append(". "); |
| | | 407 | | } |
| | | 408 | | |
| | | 409 | | // Количества берём из строк документа 1С — они могут отличаться от Quantity заказа |
| | | 410 | | // (утеря реализатором уводит в транзит весь остаток склада). |
| | 9 | 411 | | var docQtyByArticle = successful |
| | 9 | 412 | | .Where(r => r.DocumentLines != null) |
| | 1 | 413 | | .SelectMany(r => r.DocumentLines!) |
| | 1 | 414 | | .Where(l => !string.IsNullOrWhiteSpace(l.Article)) |
| | 1 | 415 | | .GroupBy(l => l.Article.Trim(), StringComparer.OrdinalIgnoreCase) |
| | 12 | 416 | | .ToDictionary(g => g.Key, g => g.Sum(l => l.Quantity), StringComparer.OrdinalIgnoreCase); |
| | | 417 | | |
| | | 418 | | // Группировка по складу |
| | 9 | 419 | | var warehouseGroups = ordersToTransfer |
| | 1 | 420 | | .Where(o => !string.IsNullOrEmpty(o.Article) && o.Quantity > 0) |
| | 1 | 421 | | .GroupBy(o => GetEffectiveWarehouse(o)) |
| | 9 | 422 | | .ToList(); |
| | | 423 | | |
| | 20 | 424 | | foreach (var group in warehouseGroups) |
| | | 425 | | { |
| | 1 | 426 | | sb.Append($"Склад '{group.Key}': "); |
| | | 427 | | |
| | 1 | 428 | | var items = group |
| | 1 | 429 | | .Select(o => docQtyByArticle.TryGetValue(o.Article!.Trim(), out var docQty) |
| | 1 | 430 | | ? $"{o.Article} x{FormatQty(docQty)}" |
| | 1 | 431 | | : $"{o.Article} x{o.Quantity}") |
| | 1 | 432 | | .ToList(); |
| | | 433 | | |
| | | 434 | | // Если товаров много — показываем первые 10 и счётчик |
| | 1 | 435 | | if (items.Count <= 10) |
| | | 436 | | { |
| | 1 | 437 | | sb.Append(string.Join(", ", items)); |
| | | 438 | | } |
| | | 439 | | else |
| | | 440 | | { |
| | 0 | 441 | | sb.Append(string.Join(", ", items.Take(10))); |
| | 0 | 442 | | sb.Append($" и ещё {items.Count - 10} шт."); |
| | | 443 | | } |
| | 1 | 444 | | sb.Append(". "); |
| | | 445 | | } |
| | | 446 | | |
| | | 447 | | // Черновик: пропущенная номенклатура |
| | 9 | 448 | | var missingNotes = successful |
| | 9 | 449 | | .Where(r => !string.IsNullOrWhiteSpace(r.MissingNomenclature)) |
| | 1 | 450 | | .Select(r => r.MissingNomenclature) |
| | 9 | 451 | | .Distinct() |
| | 9 | 452 | | .ToList(); |
| | 9 | 453 | | if (missingNotes.Any()) |
| | | 454 | | { |
| | 1 | 455 | | sb.Append("1С черновик — не найдена номенклатура: "); |
| | 1 | 456 | | sb.Append(string.Join("; ", missingNotes)); |
| | 1 | 457 | | sb.Append(". "); |
| | | 458 | | } |
| | | 459 | | |
| | 9 | 460 | | var createdNotes = successful |
| | 9 | 461 | | .Select(r => r.CreatedNomenclature) |
| | 9 | 462 | | .Where(x => !string.IsNullOrWhiteSpace(x)) |
| | 9 | 463 | | .Distinct() |
| | 9 | 464 | | .ToList(); |
| | 9 | 465 | | if (createdNotes.Any()) |
| | | 466 | | { |
| | 0 | 467 | | sb.Append("В 1С создана номенклатура: "); |
| | 0 | 468 | | sb.Append(string.Join("; ", createdNotes)); |
| | 0 | 469 | | sb.Append(". "); |
| | | 470 | | } |
| | | 471 | | |
| | | 472 | | // Ошибки проведения (IsPosted=false, но документ создан) |
| | 9 | 473 | | var postingErrorNotes = successful |
| | 9 | 474 | | .Where(r => !r.IsPosted && !string.IsNullOrWhiteSpace(r.PostingError)) |
| | 5 | 475 | | .Select(r => r.PostingError!) |
| | 9 | 476 | | .Distinct() |
| | 9 | 477 | | .ToList(); |
| | 9 | 478 | | if (postingErrorNotes.Any()) |
| | | 479 | | { |
| | 3 | 480 | | sb.Append("1С ошибка проведения: "); |
| | 3 | 481 | | sb.Append(string.Join("; ", postingErrorNotes.Select(OneCODataErrorFormatter.Format))); |
| | 3 | 482 | | sb.Append(". "); |
| | | 483 | | } |
| | | 484 | | |
| | | 485 | | // Ошибки создания документа (Success=false) |
| | 9 | 486 | | if (failed.Any()) |
| | | 487 | | { |
| | 1 | 488 | | sb.Append("Ошибки 1С: "); |
| | 2 | 489 | | var errors = failed.Select(f => f.Message).Distinct().Take(3); |
| | 1 | 490 | | sb.Append(string.Join("; ", errors)); |
| | 1 | 491 | | if (failed.Count > 3) sb.Append("..."); |
| | 1 | 492 | | sb.Append(". "); |
| | | 493 | | } |
| | | 494 | | |
| | 9 | 495 | | return sb.ToString().TrimEnd(); |
| | | 496 | | } |
| | | 497 | | |
| | | 498 | | public static string BuildRequestSummary( |
| | | 499 | | List<Order> ordersToTransfer, |
| | | 500 | | string? warehouseSender = null, |
| | | 501 | | string? warehouseRecipient = null) |
| | | 502 | | { |
| | 9 | 503 | | if (ordersToTransfer == null || !ordersToTransfer.Any()) |
| | 8 | 504 | | return string.Empty; |
| | | 505 | | |
| | 1 | 506 | | var distinctOrganizations = ordersToTransfer |
| | 1 | 507 | | .Select(o => o.OzonClient?.Name?.Trim()) |
| | 1 | 508 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 1 | 509 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 510 | | .ToList(); |
| | | 511 | | |
| | 1 | 512 | | var distinctOrganizationINNs = ordersToTransfer |
| | 1 | 513 | | .Select(o => o.OzonClient?.INNCode?.Trim()) |
| | 1 | 514 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 1 | 515 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 516 | | .ToList(); |
| | | 517 | | |
| | 1 | 518 | | var distinctSenders = ordersToTransfer |
| | 1 | 519 | | .Select(o => o.Supplier?.Name?.Trim()) |
| | 1 | 520 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 1 | 521 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 522 | | .ToList(); |
| | | 523 | | |
| | 1 | 524 | | var distinctSenderINNs = ordersToTransfer |
| | 1 | 525 | | .Select(o => o.Supplier?.INNCode?.Trim()) |
| | 1 | 526 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 1 | 527 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 528 | | .ToList(); |
| | | 529 | | |
| | 1 | 530 | | var senderWarehouses = !string.IsNullOrEmpty(warehouseSender) |
| | 1 | 531 | | ? new List<string> { warehouseSender.Trim() } |
| | 1 | 532 | | : ordersToTransfer |
| | 1 | 533 | | .Select(GetEffectiveWarehouse) |
| | 0 | 534 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 1 | 535 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 536 | | .ToList(); |
| | | 537 | | |
| | 1 | 538 | | var recipientWarehouses = !string.IsNullOrEmpty(warehouseRecipient) |
| | 1 | 539 | | ? new List<string> { warehouseRecipient.Trim() } |
| | 1 | 540 | | : ordersToTransfer |
| | 0 | 541 | | .Select(o => o.OzonClient?.WarehouseName?.Trim()) |
| | 0 | 542 | | .Where(x => !string.IsNullOrEmpty(x)) |
| | 0 | 543 | | .Select(x => x!) |
| | 1 | 544 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 545 | | .ToList(); |
| | | 546 | | |
| | 1 | 547 | | var productGroups = ordersToTransfer |
| | 1 | 548 | | .Where(o => !string.IsNullOrEmpty(o.Article) && o.Quantity > 0) |
| | 1 | 549 | | .GroupBy(o => o.Article!.Trim()) |
| | 1 | 550 | | .Select(g => new |
| | 1 | 551 | | { |
| | 1 | 552 | | Article = g.Key, |
| | 1 | 553 | | Quantity = g.Sum(o => o.Quantity ?? 0) |
| | 1 | 554 | | }) |
| | 1 | 555 | | .OrderByDescending(g => g.Quantity) |
| | 1 | 556 | | .ToList(); |
| | | 557 | | |
| | 1 | 558 | | var result = new StringBuilder(); |
| | | 559 | | |
| | 1 | 560 | | if (distinctOrganizations.Any()) |
| | | 561 | | { |
| | 1 | 562 | | result.Append($"Организация: {string.Join(", ", distinctOrganizations)}"); |
| | 1 | 563 | | if (distinctOrganizationINNs.Any()) |
| | 0 | 564 | | result.Append($" (ИНН {string.Join(", ", distinctOrganizationINNs)})"); |
| | 1 | 565 | | result.Append(". "); |
| | | 566 | | } |
| | | 567 | | |
| | 1 | 568 | | if (distinctSenders.Any()) |
| | | 569 | | { |
| | 0 | 570 | | result.Append($"Отправитель: {string.Join(", ", distinctSenders)}"); |
| | 0 | 571 | | if (distinctSenderINNs.Any()) |
| | 0 | 572 | | result.Append($" (ИНН {string.Join(", ", distinctSenderINNs)})"); |
| | 0 | 573 | | result.Append(". "); |
| | | 574 | | } |
| | | 575 | | |
| | 1 | 576 | | if (senderWarehouses.Any()) |
| | | 577 | | { |
| | 1 | 578 | | result.Append($"Склад отправителя: {string.Join(", ", senderWarehouses)}. "); |
| | | 579 | | } |
| | | 580 | | |
| | 1 | 581 | | if (recipientWarehouses.Any()) |
| | | 582 | | { |
| | 1 | 583 | | result.Append($"Склад получателя: {string.Join(", ", recipientWarehouses)}. "); |
| | | 584 | | } |
| | | 585 | | |
| | 1 | 586 | | if (productGroups.Any()) |
| | | 587 | | { |
| | 2 | 588 | | var totalQuantity = productGroups.Sum(x => x.Quantity); |
| | 1 | 589 | | var articleSummaries = productGroups |
| | 1 | 590 | | .Take(4) |
| | 1 | 591 | | .Select(x => $"{x.Article}×{x.Quantity}") |
| | 1 | 592 | | .ToList(); |
| | | 593 | | |
| | 1 | 594 | | result.Append($"Вход: заказов {ordersToTransfer.Count}, товаров {totalQuantity}"); |
| | 1 | 595 | | if (articleSummaries.Any()) |
| | | 596 | | { |
| | 1 | 597 | | result.Append($", артикулы: {string.Join(", ", articleSummaries)}"); |
| | 1 | 598 | | var remaining = productGroups.Count - articleSummaries.Count; |
| | 1 | 599 | | if (remaining > 0) |
| | 0 | 600 | | result.Append($" +{remaining}"); |
| | | 601 | | } |
| | 1 | 602 | | result.Append("."); |
| | | 603 | | } |
| | | 604 | | |
| | 1 | 605 | | return result.ToString().Trim(); |
| | | 606 | | } |
| | | 607 | | |
| | | 608 | | private static string GetEffectiveWarehouse(Order order) |
| | | 609 | | { |
| | 3 | 610 | | var zasyl = order.OrderExtensions? |
| | 0 | 611 | | .FirstOrDefault(e => string.Equals(e.Key, "Засыл", StringComparison.OrdinalIgnoreCase)) |
| | 3 | 612 | | ?.Value?.Trim(); |
| | | 613 | | |
| | 3 | 614 | | if (!string.IsNullOrWhiteSpace(zasyl)) |
| | 0 | 615 | | return zasyl; |
| | | 616 | | |
| | 3 | 617 | | return order.ShipmentWarehouse?.Name?.Trim() ?? "—"; |
| | | 618 | | } |
| | | 619 | | } |