0 Time Event

Steve Mason sorry for going radio silent on you. You gave me inspiration and I ended up going DEEP into the scripting. I went with Grids populated with Value Boxes.

It will find all the assets that match the type I hard coded and create 1 grid for each asset. Then it will grab the relevant tag for that asset, get all the data in the configured window, and add 1 row per data point retrieved. I love StartBound because it gives me what it was right before the window I care about, meaning I can tell them what it was before the first change, which is important.

I've never done this much scripting in Axiom before. I was super impressed with what all you can do with it. I will say, the UI was pretty frustrating. No debugging, vague errors, no intellisense. But, overall, super cool stuff.

using AxiomCore2.Client;
using AxiomCore2.ControlProperties;
using AxiomCore2.Controls;
using AxiomCore2.Data;
using AxiomCore2.Events;
using AxiomCore2.Legacy;
using AxiomCore2.Log;
using AxiomCore2.Managers;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Collections;
using System.Drawing;
//using CanaryWebServiceHelper;
//using CanaryWebServiceHelper.HistorianWebService;

namespace AxiomScript
{
    public partial class ScreenScript : IDisposable
    {
        // NOTE: click help icon in dialog header for API documentation and examples.
        // NOTE: use EventTimer class when timer is necessary. See API documentation.

        // axiom references
        public ControlApplication Application { get; } = ControlApplication.Instance;
        public ControlFactoryManager ControlFactory { get; } = ControlFactoryManager.Instance;
        public IDataProvider DataProvider { get; } = DataProviderManager.CreateInstance();
        public ILog Log { get; } = ClientLog.UserScript;
        public NavigationManager Navigation { get; } = NavigationManager.Instance;
        public ControlScreen Screen => _screen;

        public void OnScreenVisible()
        {
            RefreshData();
        }

        public void OnScreenInvisible()
        {
        }

        public void Dispose()
        {
        }

        public string GetSourceTag(PropertyAssetInstance instance)
        {
            return $"{instance.AssetView}.{instance.AssetPath}.Separator";
        }

        public string GetControlSafeName(string name)
        {
            return name.Replace(" ","").Replace(".","");
        }

        public IEnumerable<PropertyAssetInstance> GetAssetInstances()
        {
            AssetBrowseResult assetBrowseResult = DataProvider.BrowseAssetInstances("localhost","GOM",null,"Well","[Separator]");
            IEnumerable<PropertyAssetInstance> instances = assetBrowseResult.AssetInstances;
            return instances;
        }

        public DateTime GetStartDateTime()
        {
            ControlDateTimePicker dateTime = _screen.ScreenControls["DateTimePicker"] as ControlDateTimePicker;

            ControlTextBox textBox = _screen.ScreenControls["TB_LookbackDays"] as ControlTextBox;
            double lookbackDays;
            if (!double.TryParse(textBox.Text, out lookbackDays))
            {
                Log.Error("Lookback days is not a number. Defaulting to 7.");
                lookbackDays = 7;
            }

            return dateTime.DateTime.ToLocalTime().AddDays(-lookbackDays);
        }

        public DateTime GetEndDateTime()
        {
            ControlDateTimePicker dateTime = _screen.ScreenControls["DateTimePicker"] as ControlDateTimePicker;

            return dateTime.DateTime.ToLocalTime();
        }

        public void SetDateRangeSummary()
        {
            ControlParagraph pDateRange = _screen.ScreenControls["P_DateRange"] as ControlParagraph;
            pDateRange.Text = $"Data shown for\n{GetStartDateTime()}\nto\n{GetEndDateTime()}";
        }

        public void RefreshAssets(object sender, EventArgs eventArgs)
        {
            int x = 0;
            int y = 0;
            int column = 1;
            int width = 300;
            int gridHeight = 300;

            IEnumerable<PropertyAssetInstance> instances = GetAssetInstances();

            // Remove grids and associated labels
            List<string> controlsToKeep = new List<string>(){"DateTimePicker", "TB_LookbackDays", "L_Days", "B_RefreshAssets", "B_RefreshData", "P_DateRange", "B_SetEndToNow"};
            for (int i = _screen.Children.Count - 1; i >= 0; i--)
            {
                ControlBase control = _screen.Children[i] as ControlBase;
                if (!controlsToKeep.Contains(control.Name))
                {
                    _screen.Children.Remove(control);
                }
            }

            // Step through each asset
            foreach (PropertyAssetInstance instance in instances)
            {
                string controlNameRoot = GetControlSafeName(instance.AssetPath);

                // Build Label
                ControlLabel label = ControlFactory.CreateControl(ControlKind.Label, $"L_{controlNameRoot}") as ControlLabel;
                label.X = x;
                label.Y = y;
                label.Width = width;
                label.Text = instance.AssetPath;
                _screen.Children.Add(label);

                // Build Grid
                ControlGrid grid = ControlFactory.CreateControl(ControlKind.Grid, $"G_{controlNameRoot}") as ControlGrid;
                grid.X = x;
                grid.Y = y+35;
                grid.Width = width;
                grid.Height = gridHeight;
                grid.ColumnCount = 2;
                grid.ColumnHeaders = new string[] {"Date", "Separator"};
                grid.ColumnWidths = new object[] {75, "Auto"};
                _screen.Children.Add(grid);

                PopulateGrid(grid, instance);

                if (column == 5) // Next grid will be on next row
                {
                    x = 0;
                    y = y + 350;
                    column = 1;
                }
                else
                {
                    x = x + width + 10;
                    column++;
                }
            }


            SetDateRangeSummary();
        }

        public void SetEndToNow(object sender, EventArgs eventArgs)
        {
            ControlDateTimePicker dtPicker = _screen.ScreenControls["DateTimePicker"] as ControlDateTimePicker;
            dtPicker.DateTime = DateTime.Now;
        }

        public void RefreshDataButton(object sender, EventArgs eventArgs)
        {
            RefreshData();
        }

        public void RefreshData()
        {
            IEnumerable<PropertyAssetInstance> instances = GetAssetInstances();

            for (int i = 0; i < _screen.Children.Count; i++)
            {
                ControlBase control = _screen.Children[i] as ControlBase;
                if (control.Kind == ControlKind.Grid)
                {
                    PropertyAssetInstance match = instances.FirstOrDefault(a => $"G_{GetControlSafeName(a.AssetPath)}" == control.Name);
                    if (match == null)
                    {
                        Log.Error($"{control.Name} no longer exists. Please hit the Refresh Assets button.");
                    }
                    else
                    {
                        ControlGrid grid = control as ControlGrid;
                        grid.Children.Clear();
                        PopulateGrid(grid, match);
                    }
                }
            }

            SetDateRangeSummary();
        }

        public void PopulateGrid(ControlGrid grid, PropertyAssetInstance instance)
        {
            string controlNameRoot = GetControlSafeName(instance.AssetPath);
            string sourceTag = GetSourceTag(instance);

            TagDataResult tagDataResult = DataProvider.GetRawData(sourceTag, GetStartDateTime(), GetEndDateTime(), 100, true);

            if (tagDataResult.HasValues)
            {
                TVQ[] values = tagDataResult.Values;
                int r = 1;
                foreach (TVQ tvq in values)
                {
                    if (tvq.IsNoData || tvq.Quality == 1216) continue; // NoBounds or Extended

                    ControlGridRow gridRow = ControlFactory.CreateControl(ControlKind.GridRow, $"GR_{controlNameRoot}_{r}") as ControlGridRow;
                    grid.Children.Add(gridRow);

                    ControlLabel gridRowTimestamp = ControlFactory.CreateControl(ControlKind.Label, $"L_{controlNameRoot}_{r}_T") as ControlLabel;
                    gridRowTimestamp.Text = tvq.Timestamp.ToString();

                    ControlLabel gridRowValue = ControlFactory.CreateControl(ControlKind.Label, $"L_{controlNameRoot}_{r}_V") as ControlLabel;
                    gridRowValue.Text = tvq.Value.ToString();

                    gridRow.Children.Insert(gridRowTimestamp,0);
                    gridRow.Children.Insert(gridRowValue,1);
                    r++;
                }
            }
            else
            {
                Log.Info($"No date for {instance.AssetPath}");
            }
        }
    }
}