| | | 1 | | using Microsoft.AspNetCore.WebUtilities; |
| | | 2 | | using Microsoft.Extensions.Primitives; |
| | | 3 | | using OzonOrdersWeb.Areas.Studio2.ViewModels.Bitrix; |
| | | 4 | | |
| | | 5 | | namespace Services.BitrixStockServices; |
| | | 6 | | |
| | | 7 | | public static class BitrixStockFilterQueryParser |
| | | 8 | | { |
| | | 9 | | public static RemainingStockFilter FromQueryString(string? queryString) |
| | | 10 | | { |
| | 31 | 11 | | var filter = new RemainingStockFilter(); |
| | 31 | 12 | | if (string.IsNullOrWhiteSpace(queryString)) |
| | | 13 | | { |
| | 3 | 14 | | return filter; |
| | | 15 | | } |
| | | 16 | | |
| | 28 | 17 | | var q = queryString.Trim(); |
| | 28 | 18 | | if (!q.StartsWith('?')) |
| | | 19 | | { |
| | 1 | 20 | | q = "?" + q; |
| | | 21 | | } |
| | | 22 | | |
| | 28 | 23 | | var parsed = QueryHelpers.ParseQuery(q); |
| | | 24 | | |
| | 28 | 25 | | filter.ProductId = ParseInt(parsed, "ProductId"); |
| | 28 | 26 | | filter.Article = First(parsed, "Article"); |
| | 28 | 27 | | filter.PreviewText = First(parsed, "PreviewText"); |
| | 28 | 28 | | filter.Active = First(parsed, "Active"); |
| | 28 | 29 | | filter.Available = First(parsed, "Available"); |
| | 28 | 30 | | filter.Supplier = First(parsed, "Supplier"); |
| | 28 | 31 | | filter.QuantityFrom = ParseInt(parsed, "QuantityFrom"); |
| | 28 | 32 | | filter.QuantityTo = ParseInt(parsed, "QuantityTo"); |
| | 28 | 33 | | filter.DateFrom = ParseDate(parsed, "DateFrom"); |
| | 28 | 34 | | filter.DateTo = ParseDate(parsed, "DateTo"); |
| | 28 | 35 | | filter.PriceValueFrom = ParseDecimal(parsed, "PriceValueFrom"); |
| | 28 | 36 | | filter.PriceValueTo = ParseDecimal(parsed, "PriceValueTo"); |
| | 28 | 37 | | filter.RegistrationPriceFrom = ParseDecimal(parsed, "RegistrationPriceFrom"); |
| | 28 | 38 | | filter.RegistrationPriceTo = ParseDecimal(parsed, "RegistrationPriceTo"); |
| | 28 | 39 | | filter.StoreId = ParseInt(parsed, "StoreId"); |
| | 28 | 40 | | filter.StoreTitle = First(parsed, "StoreTitle"); |
| | 28 | 41 | | filter.AmountFrom = ParseDouble(parsed, "AmountFrom"); |
| | 28 | 42 | | filter.AmountTo = ParseDouble(parsed, "AmountTo"); |
| | 28 | 43 | | filter.OzonStoreTitle = First(parsed, "OzonStoreTitle"); |
| | 28 | 44 | | filter.OzonAmountFrom = ParseDouble(parsed, "OzonAmountFrom"); |
| | 28 | 45 | | filter.OzonAmountTo = ParseDouble(parsed, "OzonAmountTo"); |
| | 28 | 46 | | filter.SelectedClientId = ParseInt(parsed, "SelectedClientId"); |
| | 28 | 47 | | filter.Page = ParseInt(parsed, "Page") ?? 1; |
| | 28 | 48 | | filter.PageSize = ParseInt(parsed, "PageSize") ?? 10_000; |
| | 28 | 49 | | filter.SortColumn = First(parsed, "SortColumn"); |
| | 28 | 50 | | filter.SortDirection = First(parsed, "SortDirection") ?? "asc"; |
| | | 51 | | |
| | 28 | 52 | | filter.LoadOzonWarehouses = HasTruthy(parsed, "LoadOzonWarehouses"); |
| | 28 | 53 | | filter.LoadOneCStocks = HasTruthy(parsed, "LoadOneCStocks"); |
| | 28 | 54 | | filter.DiffOzonWarehouses = HasTruthy(parsed, "DiffOzonWarehouses"); |
| | 28 | 55 | | filter.LoadOzonPriceIndexes = HasTruthy(parsed, "LoadOzonPriceIndexes"); |
| | 28 | 56 | | filter.RedOzonPriceIndexes = HasTruthy(parsed, "RedOzonPriceIndexes"); |
| | 28 | 57 | | filter.OnlyInactive = HasTruthy(parsed, "OnlyInactive"); |
| | 28 | 58 | | filter.OnlyActive = HasTruthy(parsed, "OnlyActive"); |
| | 28 | 59 | | filter.DisablePagination = HasTruthy(parsed, "DisablePagination"); |
| | | 60 | | |
| | 28 | 61 | | if (parsed.TryGetValue("SelectedStoreTitles", out var storeValues)) |
| | | 62 | | { |
| | 1 | 63 | | filter.SelectedStoreTitles = storeValues |
| | 6 | 64 | | .Where(v => !string.IsNullOrWhiteSpace(v)) |
| | 4 | 65 | | .Select(v => v!.Trim()) |
| | 1 | 66 | | .Distinct(StringComparer.OrdinalIgnoreCase) |
| | 1 | 67 | | .ToList(); |
| | | 68 | | } |
| | | 69 | | |
| | 28 | 70 | | return filter; |
| | | 71 | | } |
| | | 72 | | |
| | | 73 | | private static string? First(Dictionary<string, StringValues> parsed, string key) => |
| | 728 | 74 | | parsed.TryGetValue(key, out var v) ? v.FirstOrDefault()?.Trim() : null; |
| | | 75 | | |
| | | 76 | | private static int? ParseInt(Dictionary<string, StringValues> parsed, string key) |
| | | 77 | | { |
| | 196 | 78 | | var s = First(parsed, key); |
| | 196 | 79 | | return int.TryParse(s, out var n) ? n : null; |
| | | 80 | | } |
| | | 81 | | |
| | | 82 | | private static double? ParseDouble(Dictionary<string, StringValues> parsed, string key) |
| | | 83 | | { |
| | 112 | 84 | | var s = First(parsed, key); |
| | 112 | 85 | | return double.TryParse(s?.Replace(',', '.'), System.Globalization.NumberStyles.Any, |
| | 112 | 86 | | System.Globalization.CultureInfo.InvariantCulture, out var n) |
| | 112 | 87 | | ? n |
| | 112 | 88 | | : null; |
| | | 89 | | } |
| | | 90 | | |
| | | 91 | | private static decimal? ParseDecimal(Dictionary<string, StringValues> parsed, string key) |
| | | 92 | | { |
| | 112 | 93 | | var s = First(parsed, key); |
| | 112 | 94 | | return decimal.TryParse(s?.Replace(',', '.'), System.Globalization.NumberStyles.Any, |
| | 112 | 95 | | System.Globalization.CultureInfo.InvariantCulture, out var n) |
| | 112 | 96 | | ? n |
| | 112 | 97 | | : null; |
| | | 98 | | } |
| | | 99 | | |
| | | 100 | | private static DateTime? ParseDate(Dictionary<string, StringValues> parsed, string key) |
| | | 101 | | { |
| | 56 | 102 | | var s = First(parsed, key); |
| | 56 | 103 | | return DateTime.TryParse(s, out var d) ? d : null; |
| | | 104 | | } |
| | | 105 | | |
| | | 106 | | private static bool HasTruthy(Dictionary<string, StringValues> parsed, string key) |
| | | 107 | | { |
| | 224 | 108 | | if (!parsed.TryGetValue(key, out var values)) |
| | | 109 | | { |
| | 143 | 110 | | return false; |
| | | 111 | | } |
| | | 112 | | |
| | 81 | 113 | | return values.Any(v => |
| | 163 | 114 | | string.Equals(v, "true", StringComparison.OrdinalIgnoreCase) || |
| | 163 | 115 | | string.Equals(v, "on", StringComparison.OrdinalIgnoreCase) || |
| | 163 | 116 | | v == "1"); |
| | | 117 | | } |
| | | 118 | | } |