prs/prs.desktop/Panels/GPSTrackers/GPSTrackerLocationGrid.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Controls;
using Comal.Classes;
using Comal.Stores;
using InABox.Clients;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.WPF;

namespace PRSDesktop;

internal class GPSTrackerLocationGrid : DynamicOneToManyGrid<GPSTracker, GPSTrackerLocation>
{
    private static List<GPSTrackerLocation> _cache;

    protected override void Init()
    {
        base.Init();
        Criteria.Add(
            new Filter<GPSTrackerLocation>(x => x.Location.Timestamp).IsGreaterThanOrEqualTo(DateTime.Now.AddDays(-1))
        );

        HiddenColumns.Add(x => x.Location.Longitude);
        HiddenColumns.Add(x => x.Location.Latitude);
        HiddenColumns.Add(x => x.Location.Address);

        ActionColumns.Add(new DynamicMapColumn<GPSTrackerLocation>(this, x => x.Location));

        AddButton("Get Addresses", null, GetAddressClick);
    }

    protected override void DoReconfigure(DynamicGridOptions options)
    {
        base.DoReconfigure(options);
        options.SelectColumns = true;
        options.RecordCount = true;
        options.FilterRows = true;
    }

    public static string ReverseGeocode(double latitude, double longitude)
    {
        _cache ??= Client.Query(
                new Filter<GPSTrackerLocation>(x => x.Location.Address).IsNotEqualTo(""),
                Columns.None<GPSTrackerLocation>().Add(
                    x => x.Location.Address,
                    x => x.Location.Longitude,
                    x => x.Location.Latitude))
            .ToList<GPSTrackerLocation>();
        var tuple = _cache.FirstOrDefault(x => Equals(x.Location.Latitude, latitude) && Equals(x.Location.Longitude, longitude));
        if (tuple == null)
        {
            var address = StoreUtils.ReverseGeocode(latitude, longitude);
            if (!string.IsNullOrWhiteSpace(address))
            {
                tuple = new GPSTrackerLocation();
                tuple.Location.Latitude = latitude;
                tuple.Location.Longitude = longitude;
                tuple.Location.Address = address;
                _cache.Add(tuple);
            }
        }

        return tuple != null ? tuple.Location.Address : "";
    }

    private bool GetAddressClick(Button arg1, CoreRow[] arg2)
    {
        var result = false;
        var rows = Data.Rows.Where(r =>
            string.IsNullOrWhiteSpace(r.Get<GPSTrackerLocation, string>(c => c.Location.Address))
            && !Equals(r.Get<GPSTrackerLocation, double>(c => c.Location.Latitude), 0.0F)
            && !Equals(r.Get<GPSTrackerLocation, double>(c => c.Location.Longitude), 0.0F)
        );
        Progress.ShowModal("Updating Addresses", progress =>
        {
            foreach (var row in rows)
            {
                var item = LoadItem(row);
                var address = ReverseGeocode(
                    row.Get<GPSTrackerLocation, double>(x => x.Location.Latitude),
                    row.Get<GPSTrackerLocation, double>(x => x.Location.Longitude)
                );
                if (!string.IsNullOrWhiteSpace(address))
                {
                    item.Location.Address = address;
                    UpdateRow<GPSTrackerLocation, string>(row, x => x.Location.Address, address, false);
                    result = true;
                }
            }
        });
        return result;
    }
}