| | | 1 | | using Hangfire; |
| | | 2 | | using Hangfire.Storage; |
| | | 3 | | using Microsoft.AspNetCore.Authorization; |
| | | 4 | | using Microsoft.AspNetCore.Mvc; |
| | | 5 | | using Microsoft.EntityFrameworkCore; |
| | | 6 | | using OzonDomains.Models; |
| | | 7 | | using OzonDomains.Models.Authorization.Enums; |
| | | 8 | | using OzonOrdersWeb.Authorization; |
| | | 9 | | using OzonOrdersWeb.WebServices.Grid; |
| | | 10 | | using OzonOrdersWeb.WebServices.Journals; |
| | | 11 | | using OzonRepositories.Context; |
| | | 12 | | using OzonDomains; |
| | | 13 | | using OzonOrdersWeb.Areas.Studio2.ViewModels.OrderReturns; |
| | | 14 | | using Services.DataServices; |
| | | 15 | | using Services.HangfireService; |
| | | 16 | | using Services.OzonReturnsServices; |
| | | 17 | | using Services.ParserServices.HelpDictEnum; |
| | | 18 | | |
| | | 19 | | namespace OzonOrdersWeb.Areas.Studio2.Controllers; |
| | | 20 | | |
| | | 21 | | [Authorize(Roles = "Admin")] |
| | | 22 | | [Area("Studio2")] |
| | | 23 | | public class OrderReturnsController : Controller |
| | | 24 | | { |
| | | 25 | | private const string PageCode = "Studio2.OrderReturns.Index"; |
| | | 26 | | private readonly OrderReturnDataServices _orderReturnDataServices; |
| | | 27 | | private readonly OzonClientServices _ozonClientServices; |
| | | 28 | | private readonly ApplicationDbContext _context; |
| | | 29 | | |
| | 0 | 30 | | public OrderReturnsController( |
| | 0 | 31 | | OrderReturnDataServices orderReturnDataServices, |
| | 0 | 32 | | OzonClientServices ozonClientServices, |
| | 0 | 33 | | ApplicationDbContext context) |
| | | 34 | | { |
| | 0 | 35 | | _orderReturnDataServices = orderReturnDataServices; |
| | 0 | 36 | | _ozonClientServices = ozonClientServices; |
| | 0 | 37 | | _context = context; |
| | 0 | 38 | | } |
| | | 39 | | |
| | | 40 | | public async Task<IActionResult> GetReturnDetails(long id) |
| | | 41 | | { |
| | 0 | 42 | | var r = await _orderReturnDataServices.GetByIdAsync(id); |
| | 0 | 43 | | if (r == null) |
| | 0 | 44 | | return NotFound(); |
| | | 45 | | |
| | 0 | 46 | | return PartialView("_ReturnDetailsPartial", r); |
| | 0 | 47 | | } |
| | | 48 | | |
| | | 49 | | /// <summary>Каркас страницы: форма загрузки из API и серверный грид. orderId — ссылка из заказа (только его возврат |
| | | 50 | | public async Task<IActionResult> Index(int? orderId = null, CancellationToken cancellationToken = default) |
| | | 51 | | { |
| | 0 | 52 | | var clients = await _ozonClientServices.GetOzonClients(); |
| | 0 | 53 | | long? autoOpenId = orderId.HasValue |
| | 0 | 54 | | ? await _context.OrderReturns.AsNoTracking() |
| | 0 | 55 | | .Where(r => r.OrderId == orderId) |
| | 0 | 56 | | .OrderByDescending(r => r.VisualStatusChangeMoment).ThenByDescending(r => r.Id) |
| | 0 | 57 | | .Select(r => (long?)r.Id) |
| | 0 | 58 | | .FirstOrDefaultAsync(cancellationToken) |
| | 0 | 59 | | : null; |
| | | 60 | | |
| | 0 | 61 | | return View(new OrderReturnsIndexViewModel |
| | 0 | 62 | | { |
| | 0 | 63 | | OzonClients = clients.Where(c => c.ClientType == ClientType.OZON).ToList(), |
| | 0 | 64 | | TotalCount = await _context.OrderReturns.CountAsync(cancellationToken), |
| | 0 | 65 | | VisualStatusOptions = OzonStatus.ReturnVisualStatuses, |
| | 0 | 66 | | OrderId = orderId, |
| | 0 | 67 | | AutoOpenReturnId = autoOpenId |
| | 0 | 68 | | }); |
| | 0 | 69 | | } |
| | | 70 | | |
| | | 71 | | [HttpPost("Studio2/OrderReturns/grid")] |
| | | 72 | | [ValidateAntiForgeryToken] |
| | | 73 | | [PageAuthorize(PageCode, AccessType.View)] |
| | | 74 | | public async Task<IActionResult> GridRows([FromBody] ServerGridRequest? request, CancellationToken cancellationToken |
| | | 75 | | { |
| | 0 | 76 | | var error = ServerGridQuery.Validate(request); |
| | 0 | 77 | | if (error != null) return BadRequest(new { success = false, error }); |
| | | 78 | | |
| | 0 | 79 | | var def = JournalGridDefinitions.OrderReturns; |
| | 0 | 80 | | var filtered = ServerGridQuery.ApplyFilters(ReturnsQuery(request!), def, request!); |
| | 0 | 81 | | var total = await filtered.CountAsync(cancellationToken); |
| | 0 | 82 | | var start = Math.Max(0, request!.StartRow); |
| | 0 | 83 | | var take = Math.Clamp(request.EndRow - start, 1, ServerGridQuery.MaxBlockSize); |
| | 0 | 84 | | var rows = start >= total |
| | 0 | 85 | | ? [] |
| | 0 | 86 | | : await ServerGridQuery.ApplySort(filtered, def, request.SortModel).Skip(start).Take(take) |
| | 0 | 87 | | .Select(r => new |
| | 0 | 88 | | { |
| | 0 | 89 | | r.Id, r.PostingNumber, r.OrderNumber, ClientName = r.OzonClient != null ? r.OzonClient.Name : null, |
| | 0 | 90 | | r.ProductName, r.ProductOfferId, r.ProductQuantity, r.ProductPrice, r.ProductPriceCurrency, |
| | 0 | 91 | | VisualStatus = r.VisualStatusSysName, r.ReturnReasonName, r.ReturnType, r.Schema, r.PlaceName, |
| | 0 | 92 | | CompensationStatus = r.CompensationStatusDisplayName, r.OrderId, r.VisualStatusChangeMoment, r.Retur |
| | 0 | 93 | | }) |
| | 0 | 94 | | .ToListAsync(cancellationToken); |
| | 0 | 95 | | var lastRow = start + rows.Count >= total ? total : -1; |
| | 0 | 96 | | return Ok(new { success = true, rows, totalCount = total, lastRow }); |
| | 0 | 97 | | } |
| | | 98 | | |
| | | 99 | | [HttpPost("Studio2/OrderReturns/grid/facets")] |
| | | 100 | | [ValidateAntiForgeryToken] |
| | | 101 | | [PageAuthorize(PageCode, AccessType.View)] |
| | | 102 | | public async Task<IActionResult> GridFacets([FromBody] ServerGridRequest? request, CancellationToken cancellationTok |
| | | 103 | | { |
| | 0 | 104 | | if (request is null || string.IsNullOrWhiteSpace(request.ColId)) return BadRequest(new { success = false, error |
| | 0 | 105 | | request.StartRow = 0; |
| | 0 | 106 | | request.EndRow = 1; |
| | 0 | 107 | | var error = ServerGridQuery.Validate(request); |
| | 0 | 108 | | if (error != null) return BadRequest(new { success = false, error }); |
| | 0 | 109 | | var values = await ServerGridQuery.FacetsAsync(ReturnsQuery(request), JournalGridDefinitions.OrderReturns, reque |
| | 0 | 110 | | return Ok(new { success = true, values }); |
| | 0 | 111 | | } |
| | | 112 | | |
| | | 113 | | private IQueryable<OrderReturn> ReturnsQuery(ServerGridRequest request) |
| | | 114 | | { |
| | 0 | 115 | | var query = _context.OrderReturns.AsNoTracking(); |
| | 0 | 116 | | return request.Params.TryGetValue("orderId", out var raw) && int.TryParse(raw, out var orderId) && orderId > 0 |
| | 0 | 117 | | ? query.Where(r => r.OrderId == orderId) |
| | 0 | 118 | | : query; |
| | | 119 | | } |
| | | 120 | | |
| | | 121 | | [HttpPost] |
| | | 122 | | public async Task<IActionResult> StartLoadReturns(int ozonClientId, DateTime from, DateTime to, [FromForm] string jo |
| | | 123 | | { |
| | 0 | 124 | | if (string.IsNullOrWhiteSpace(jobId)) |
| | 0 | 125 | | return BadRequest(new { error = "jobId обязателен" }); |
| | | 126 | | |
| | 0 | 127 | | if (ozonClientId < 0) |
| | 0 | 128 | | return BadRequest(new { error = "Выберите клиента Ozon или «Все клиенты»" }); |
| | | 129 | | |
| | 0 | 130 | | if (ozonClientId > 0) |
| | | 131 | | { |
| | 0 | 132 | | var client = await _ozonClientServices.GetOzonClientAsync(ozonClientId); |
| | 0 | 133 | | if (client == null || string.IsNullOrEmpty(client.DecryptClientId) || string.IsNullOrEmpty(client.DecryptApi |
| | 0 | 134 | | return BadRequest(new { error = "Клиент Ozon не найден или не настроены учётные данные" }); |
| | | 135 | | } |
| | | 136 | | else |
| | | 137 | | { |
| | 0 | 138 | | var ozonClients = (await _ozonClientServices.GetOzonClients()) |
| | 0 | 139 | | .Where(c => c.ClientType == ClientType.OZON).ToList(); |
| | 0 | 140 | | if (ozonClients.Count == 0) |
| | 0 | 141 | | return BadRequest(new { error = "Нет клиентов с типом Ozon" }); |
| | | 142 | | } |
| | | 143 | | |
| | | 144 | | // Проба лока: сразу отвечаем 409, если загрузка уже идёт, вместо постановки задачи, |
| | | 145 | | // которая всё равно упрётся в тот же лок и молча завершится. Лок здесь и берётся, и |
| | | 146 | | // отпускается — удерживает его сам джоб. Соединение обязательно закрыть: пул Hangfire |
| | | 147 | | // (Application Name=st2-hangfire) на 64 соединения, и каждый клик по кнопке подтекал. |
| | | 148 | | try |
| | | 149 | | { |
| | 0 | 150 | | using var lockConnection = JobStorage.Current.GetConnection(); |
| | 0 | 151 | | using var distLock = lockConnection.AcquireDistributedLock(OzonReturnsSyncService.LockKey, TimeSpan.FromMill |
| | 0 | 152 | | } |
| | 0 | 153 | | catch (DistributedLockTimeoutException) |
| | | 154 | | { |
| | 0 | 155 | | return StatusCode(409, new { success = false, message = "Загрузка возвратов уже выполняется." }); |
| | | 156 | | } |
| | | 157 | | |
| | 0 | 158 | | var postingNumbersArray = postingNumbers? |
| | 0 | 159 | | .Split(new[] { ',', ';', ' ', '\n' }, StringSplitOptions.RemoveEmptyEntries) |
| | 0 | 160 | | .Select(s => s.Trim()) |
| | 0 | 161 | | .Where(s => !string.IsNullOrEmpty(s)) |
| | 0 | 162 | | .Take(50) |
| | 0 | 163 | | .ToArray(); |
| | | 164 | | |
| | | 165 | | // Ручной запуск всегда читает выбранный период целиком: пользователь задал границы явно. |
| | 0 | 166 | | HangfireJobClientExtensions.EnqueueMain<LoadOzonReturnsJob>(j => |
| | 0 | 167 | | j.RunManualAsync(ozonClientId, from, to, jobId.Trim(), postingNumbersArray)); |
| | | 168 | | |
| | 0 | 169 | | return Json(new { success = true, jobId = jobId.Trim() }); |
| | 0 | 170 | | } |
| | | 171 | | } |