using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using System.Windows; using InABox.Client.Remote.Json; using InABox.Clients; using InABox.Core; using InABox.DynamicGrid; using PRS.Shared; using RestSharp; namespace PRSServer.Forms.DatabaseLicense { public class LicenseTrackingItemGrid : DynamicGrid { public static HttpJsonClient LicenseClient = new("https", "remote.prsdigital.com.au", 5000); protected override void Init() { } protected override void DoReconfigure(FluentList options) { options.Clear(); } public DateTime Renewed { get; set; } public int Licenses { get; private set; } private static void RetrieveFees() { var summary = LicenseClient.GetRequest("LicenseSummary"); LicenseUtils.LoadSummary(summary); } protected override void DeleteItems(params CoreRow[] rows) { } protected override LicenseTrackingItem LoadItem(CoreRow row) { return row.ToObject(); } protected override void Reload(Filters criteria, Columns columns, ref SortOrder? sort, Action action) { Task.Run(() => { RetrieveFees(); var data = new Client() .Query( new Filter(x => x.Date).IsGreaterThanOrEqualTo(Renewed.Date) .And(x => x.TotalWrite).IsGreaterThan(0), new Columns(x => x.User.ID) .Add(x => x.Type)); Licenses = data.ExtractValues(x => x.User.ID).Distinct().Count(); var licensemap = LicenseUtils.LicenseMap(); var summaries = LicenseUtils.LicenseTypes() .Select(x => new LicenseSummary0(x, licensemap.Where(e => e.Value == x).Select(a => a.Key)) ).ToArray(); var missing = new List(); foreach (var row in data.Rows) { var type = row.Get(x => x.Type); var summary = summaries.FirstOrDefault(x => x.Entities.Contains(type)); if (summary != null) { summary.AddGuid(row.Get(x => x.User.ID)); } else { if (!missing.Contains(type)) { Logger.Send(LogType.Error, "", "Unknown License Type: " + type); missing.Add(type); } } } var result = new CoreTable(); result.LoadColumns(typeof(LicenseTrackingItem)); foreach (var summary in summaries.Where(x => x.Users > 0).OrderBy(x => x.Caption)) { var renewal = new LicenseTrackingItem { License = summary.Caption, Users = summary.Users, Rate = summary.Fee, ExGST = summary.Users * summary.Fee }; var row = result.NewRow(); result.LoadRow(row, renewal); result.Rows.Add(row); } action?.Invoke(result, null); }); } public override void SaveItem(LicenseTrackingItem item) { } private class LicenseSummary0 { private readonly List _guids = new(); public LicenseSummary0(Type license, IEnumerable entities) { License = license; Entities = entities.Select(x => x.EntityName().Split('.').Last()).ToArray(); _guids = new List(); } public Type License { get; } public string Caption => License != null ? License.GetCaption() : ""; public double Fee => License != null ? LicenseUtils.GetLicenseFee(License) : 0.00F; public string[] Entities { get; } public int Users => _guids.Count; public void AddGuid(Guid id) { if (!_guids.Contains(id)) _guids.Add(id); } } } }