prs/prs.desktop/Panels/StockSummary/StockSummaryGrid.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using Comal.Classes;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.Wpf;
using InABox.WPF;
using Newtonsoft.Json;

namespace PRSDesktop;


public class StockSummaryGrid : DynamicDataGrid<ProductInstance>, IDataModelSource
{

    private enum ColumnTag
    {
        MinimumStockRequired,
        GeneralStockHoldings,
        GeneralPurchaseOrders,
        JobStockRequired,
        JobStockHoldings,
        JobPurchaseOrders,
        BalanceRequired
    }
    
    private CoreTable? _stockHoldings = null;
    private CoreTable? _poItems = null;
    private CoreTable? _jobBOMs = null;
    private CoreTable? _stockMovements = null;
    private CoreTable? _supplierProducts = null;
    
    private static readonly BitmapImage _warning = InABox.Wpf.Resources.warning.AsBitmapImage();

    public Guid[] GroupIDs { get; set; } = [];
    public Guid[] JobIDs { get; set; } = [];
    public HashSet<Guid> SupplierIDs { get; set; } = [];

    private readonly Button? OrderButton;
    
    public StockSummaryGrid() : base()
    {
        
        ColumnsTag = "StockSummaryGrid";
        
        HiddenColumns.Add(x=>x.ID);
        HiddenColumns.Add(x => x.Product.ID);
        HiddenColumns.Add(x => x.Product.Issues);
        HiddenColumns.Add(x => x.Style.ID);
        HiddenColumns.Add(x => x.Dimensions.UnitSize);
        HiddenColumns.Add(x => x.Product.Image.ID);
        HiddenColumns.Add(x => x.Product.Image.FileName);
        HiddenColumns.Add(x=>x.Product.Supplier.SupplierLink.ID);
        HiddenColumns.Add(x=>x.MinimumStockLevel);
        
        ActionColumns.Add(new DynamicImageColumn(Issues_Image, null)
        {
            ToolTip = Issues_Tooltip,
            Position = DynamicActionColumnPosition.Start
        });
        ActionColumns.Add(new DynamicImagePreviewColumn<StockSummary>(x => x.Product.Image)
        {
            Position = DynamicActionColumnPosition.Start
        });
        
        CreateColumn(GetMinimumStockLevel, ColumnTag.MinimumStockRequired,"Min Stk.","F2");
        CreateColumn(GetGeneralStockLevel, ColumnTag.GeneralStockHoldings,"Gen Hld.","F2");
        CreateColumn(GetGeneralPurchaseOrder, ColumnTag.GeneralPurchaseOrders, "Gen PO.","F2");
        CreateColumn(GetBOMBalance, ColumnTag.JobStockRequired, "Job BOM.","F2");
        CreateColumn(GetReservedStock, ColumnTag.JobStockHoldings, "Job Hld.","F2");
        CreateColumn(GetReservedPurchaseOrder, ColumnTag.JobPurchaseOrders, "Job PO.","F2");
        CreateColumn(GetBalanceRequired, ColumnTag.BalanceRequired,"Required","");
        
        OrderButton = AddButton("Order Stock", PRSDesktop.Resources.purchase.ToBitmapImage(), OrderStock_Click);
        OrderButton.IsEnabled = false;
    }

    private void CreateColumn(DynamicTextColumn.GetTextDelegate calculate, ColumnTag tag, string header, string format)
    {
        var column = new DynamicTextColumn(calculate)
        {
            Width = 60, 
            Format=format, 
            Position = DynamicActionColumnPosition.End, 
            Tag = tag,
            HeaderText = header
        };
        ActionColumns.Add(column);
    }


    protected override void SelectItems(CoreRow[]? rows)
    {
        base.SelectItems(rows);

        OrderButton.IsEnabled = rows is not null && rows.Length > 0;
    }
    
    private BitmapImage? Issues_Image(CoreRow? row)
    {
        return (row is null)
            ? _warning
            : row.Get<ProductInstance, string>(x => x.Product.Issues).IsNullOrWhiteSpace() 
                ? null 
                : _warning;
    }

    private FrameworkElement? Issues_Tooltip(DynamicActionColumn column, CoreRow? row)
    {
        return (row is null)
            ? null
            : column.TextToolTip(row.Get<ProductInstance, string>(x => x.Product.Issues));
    }

    private UIComponent? _uicomponent = null;
    private class UIComponent : DynamicGridGridUIComponent<ProductInstance>
    {
        private StockSummaryGrid Grid;

        public UIComponent(StockSummaryGrid grid)
        {
            Grid = grid;
            Parent = grid;
        }

        private int? _instanceProductIDCol;
        private int? _instanceStyleIDCol;
        private int? _instanceUnitSizeCol;
        private int? _instanceSupplierCol;
        
        private int? _supplierProductIDCol;
        private int? _supplierStyleIDCol;
        private int? _supplierUnitSizeCol;
        private int? _supplierSupplierCol;
        
        public bool CheckSuppliers(CoreRow row)
        {
            if (Grid._supplierProducts == null)
                return false;
            
            _supplierProductIDCol ??=
                new Columns<SupplierProduct>(Grid._supplierProducts.Columns).IndexOf(x => x.Product.ID);
            _supplierStyleIDCol ??=
                new Columns<SupplierProduct>(Grid._supplierProducts.Columns).IndexOf(x => x.Style.ID);
            _supplierUnitSizeCol ??=
                new Columns<SupplierProduct>(Grid._supplierProducts.Columns).IndexOf(x => x.Dimensions.UnitSize);
            _supplierSupplierCol ??=
                new Columns<SupplierProduct>(Grid._supplierProducts.Columns).IndexOf(x => x.SupplierLink.ID);

            _instanceProductIDCol ??= new Columns<ProductInstance>(row.Table.Columns).IndexOf(x => x.Product.ID);
            _instanceStyleIDCol ??= new Columns<ProductInstance>(row.Table.Columns).IndexOf(x => x.Style.ID);
            _instanceUnitSizeCol ??= new Columns<ProductInstance>(row.Table.Columns).IndexOf(x => x.Dimensions.UnitSize);
            
            return Grid._supplierProducts.Rows.Any(r =>
                    Equals(r.Values[_supplierProductIDCol.Value], row.Values[_instanceProductIDCol.Value])
                    && Equals(r.Values[_supplierStyleIDCol.Value], row.Values[_instanceStyleIDCol.Value])
                    && Equals(r.Values[_supplierUnitSizeCol.Value], row.Values[_instanceUnitSizeCol.Value])
                    && Grid.SupplierIDs.Contains((Guid?)r.Values[_supplierSupplierCol.Value] ?? Guid.Empty));
        }
        
        protected override Brush? GetCellBackground(CoreRow row, DynamicColumnBase column)
        {
            _instanceProductIDCol ??= new Columns<ProductInstance>(row.Table.Columns).IndexOf(x => x.Product.ID);
            _instanceStyleIDCol ??= new Columns<ProductInstance>(row.Table.Columns).IndexOf(x => x.Style.ID);
            _instanceUnitSizeCol ??= new Columns<ProductInstance>(row.Table.Columns).IndexOf(x => x.Dimensions.UnitSize);

            if (Grid.AllStock && !CheckSuppliers(row))
                return new SolidColorBrush(Colors.Silver) { Opacity = 0.5F };

            if (column is DynamicTextColumn col && Grid._summaryinfo.TryGetValue(row.Get<ProductInstance,Guid>(x=>x.ID), out StockSummaryInfo? info))
            {
                var stock = Math.Max(0.0F, info.MinStock - (info.GenStock + info.GenPO)).IsEffectivelyEqual(0.0F)
                    ? new SolidColorBrush(Colors.LightBlue) { Opacity = 0.5 }
                    : new SolidColorBrush(Colors.LightSalmon) { Opacity = 0.5 };
                
                var job = Math.Max(0.0F, info.JobBOM - (info.JobStock + info.JobPO)).IsEffectivelyEqual(0.0F)
                    ? new SolidColorBrush(Colors.LightGreen) { Opacity = 0.5 }
                    : new SolidColorBrush(Colors.LightSalmon) { Opacity = 0.5 };
                
                var overall = !(Grid.Optimise ? info.Optimised : info.Required).IsEffectivelyEqual(0.0F)
                    ? new SolidColorBrush(Colors.LightSalmon) { Opacity = 0.5 }
                    : null;
                
                return col.Tag switch
                {
                    ColumnTag.MinimumStockRequired => stock,
                    ColumnTag.GeneralStockHoldings => stock,
                    ColumnTag.GeneralPurchaseOrders => stock,
                    ColumnTag.JobStockRequired => job,
                    ColumnTag.JobStockHoldings => job,
                    ColumnTag.JobPurchaseOrders => job,
                    ColumnTag.BalanceRequired => overall,
                    _ => null
                };
            }
            
            return null;
        }


    }
    protected override IDynamicGridUIComponent<ProductInstance> CreateUIComponent()
    {
        return _uicomponent ??= new UIComponent(this);
    }
    
    protected override void DoReconfigure(FluentList<DynamicGridOption> options)
    {
        base.DoReconfigure(options);

        options
            .BeginUpdate()
            .Clear()
            .Add(DynamicGridOption.RecordCount)
            .Add(DynamicGridOption.SelectColumns)
            .Add(DynamicGridOption.FilterRows)
            .Add(DynamicGridOption.ExportData)
            .Add(DynamicGridOption.MultiSelect)
            .EndUpdate();
    }

    public override DynamicGridColumns GenerateColumns()
    {
        var columns = new DynamicGridColumns();
        columns.Add<ProductInstance, string>(x => x.Product.Code, 120, "Product Code", "", Alignment.MiddleCenter);
        columns.Add<ProductInstance, string>(x => x.Product.Name, 0, "Product Name", "", Alignment.MiddleLeft);
        columns.Add<ProductInstance, string>(x => x.Style.Code, 120, "Style Code", "", Alignment.MiddleCenter);
        columns.Add<ProductInstance, string>(x => x.Dimensions.UnitSize, 120, "Unit Size", "", Alignment.MiddleCenter);
        return columns;
    }

    private void ShowDetailGrid<TEntity>(
        String tag, 
        Expression<Func<TEntity,object?>> productcol, 
        Guid productid, 
        Expression<Func<TEntity,object?>> stylecol, 
        Guid? styleid, 
        Expression<Func<TEntity,object?>> unitcol, 
        String unitsize,
        Expression<Func<TEntity,object?>>? jobcol,
        Filter<TEntity>? extrafilter,
        Func<CoreRow,bool>? rowfilter
    )
    {
        var grid = (Activator.CreateInstance(typeof(DynamicDataGrid<>).MakeGenericType(typeof(TEntity))) as IDynamicDataGrid);
        if (grid == null)
        {
            MessageWindow.ShowError($"Cannot create Grid for [{typeof(TEntity).Name}]", "", shouldLog: false);
            return;
        }
        grid.ColumnsTag = $"{ColumnsTag}.{tag}";
        grid.Reconfigure(options => { options.BeginUpdate().Clear().AddRange(DynamicGridOption.FilterRows, DynamicGridOption.SelectColumns).EndUpdate(); });
        grid.OnDefineFilter += t =>
        {
            var filter = new Filter<TEntity>(productcol).IsEqualTo(productid)
                .And(unitcol).IsEqualTo(unitsize);
            
            if (styleid.HasValue)
                filter = filter.And(stylecol).IsEqualTo(styleid);

            if (jobcol != null)
                filter = filter.And(new Filter<TEntity>(jobcol).InList(JobIDs));
                
            if (extrafilter != null)
                filter = filter.And(extrafilter);
            
            return filter;
        };
        grid.OnFilterRecord += row => rowfilter?.Invoke(row) ?? true;
        var window = DynamicGridUtils.CreateGridWindow($"Viewing {CoreUtils.Neatify(tag)} Calculation", grid);
        window.ShowDialog();
    }

    protected override void DoDoubleClick(object sender, DynamicGridCellClickEventArgs args)
    {
        //base.DoDoubleClick(sender, args);

        Guid productid = args?.Row?.Get<StockSummary, Guid>(c => c.Product.ID) ?? Guid.Empty;
        Guid? styleid = HasStyle() ? args?.Row?.Get<StockSummary, Guid>(c => c.Style.ID) : null;
        String unitsize = args?.Row?.Get<StockSummary, String>(c => c.Dimensions.UnitSize) ?? "";

        if (Equals(args?.Column?.Tag, ColumnTag.GeneralStockHoldings))
        {
            ShowDetailGrid<StockHolding>(
                ColumnTag.GeneralStockHoldings.ToString(), 
                x => x.Product.ID, 
                productid, 
                x => x.Style.ID, 
                styleid, 
                x=>x.Dimensions.UnitSize,
                unitsize,
                null,
                new Filter<StockHolding>(x=>x.Job.ID).IsEqualTo(Guid.Empty),
                null
            );               
        }
        
        else if (Equals(args?.Column?.Tag, ColumnTag.GeneralPurchaseOrders))
        {
            ShowDetailGrid<PurchaseOrderItem>(
                ColumnTag.GeneralPurchaseOrders.ToString(), 
                x => x.Product.ID, 
                productid, 
                x => x.Style.ID, 
                styleid, 
                x=>x.Dimensions.UnitSize,
                unitsize,
                null,
                new Filter<PurchaseOrderItem>(x=>x.Job.ID).IsEqualTo(Guid.Empty)
                    .And(x=>x.ReceivedDate).IsEqualTo(DateTime.MinValue),
                null
            );                  
        }
        
        else if (Equals(args?.Column?.Tag, ColumnTag.JobStockRequired))
        {
            ShowDetailGrid<JobBillOfMaterialsItem>(
                ColumnTag.JobStockRequired.ToString(), 
                x => x.Product.ID, 
                productid, 
                x => x.Style.ID, 
                styleid, 
                x=>x.Dimensions.UnitSize,
                unitsize,
                x => x.Job.ID,
                new Filter<JobBillOfMaterialsItem>(x=>x.BillOfMaterials.Approved).IsNotEqualTo(DateTime.MinValue),
                null
            );
        }
        
        else if (Equals(args?.Column?.Tag, ColumnTag.JobStockHoldings))
        {
            ShowDetailGrid<StockHolding>(
                ColumnTag.JobStockHoldings.ToString(), 
                x => x.Product.ID, 
                productid, 
                x => x.Style.ID, 
                styleid, 
                x=>x.Dimensions.UnitSize,
                unitsize,
                x => x.Job.ID,
                null,
                null
            );
        }
        
        else if (Equals(args?.Column?.Tag, ColumnTag.JobPurchaseOrders))
        {
            ShowDetailGrid<PurchaseOrderItem>(
                ColumnTag.GeneralPurchaseOrders.ToString(), 
                x => x.Product.ID, 
                productid, 
                x => x.Style.ID, 
                styleid, 
                x=>x.Dimensions.UnitSize,
                unitsize,
                x=>x.Job.ID,
                new Filter<PurchaseOrderItem>(x=>x.ReceivedDate).IsEqualTo(DateTime.MinValue),
                null
            );                  
        }
        
    }

    private bool HasStyle()
    {
        return DataColumns().ColumnNames().Any(x => x.StartsWith("Style.") && !x.Equals("Style.ID"));
    }
    
    private Tuple<Guid,Guid?,String>[] GetKeys(IEnumerable<CoreRow> rows, Columns<ProductInstance> columns, bool hasstyle)
    {
        int productcol = columns.IndexOf(x => x.Product.ID);
        int stylecol = hasstyle ? columns.IndexOf(x => x.Style.ID) : -1;
        int unitcol = columns.IndexOf(x => x.Dimensions.UnitSize);
        
        var result = rows.Select(r => new Tuple<Guid, Guid?, String>(
            (Guid)(r.Values[productcol] ?? Guid.Empty),
            (stylecol != -1) ? (Guid)(r.Values[stylecol] ?? Guid.Empty) : null,
            (String)(r.Values[unitcol] ?? ""))
        ).Distinct().ToArray();
        
        return result;
    }

    private CoreRow[] GetRows<TSource>(IEnumerable<CoreRow> rows, Columns<TSource> columns, Guid productid, Guid? styleid, string unitsize, Guid[] jobids) where TSource : IJobMaterial
    {
        int productcol = columns.IndexOf(x => x.Product.ID);
        int stylecol = styleid.HasValue ? columns.IndexOf(x => x.Style.ID) : -1;
        int unitcol = columns.IndexOf(x => x.Dimensions.UnitSize);
        int jobcol = columns.IndexOf(x => x.Job.ID);
        
        var subset = rows
            .Where(r=>
                Guid.Equals(r.Values[productcol], productid)
                && (!styleid.HasValue || Guid.Equals(r.Values[stylecol], styleid))
                && String.Equals(r.Values[unitcol], unitsize)
                && jobids.Any(x=>Equals(x,r.Values[jobcol]))
            );
        
        return subset.ToArray();
    }

    private double Aggregate<TSource>(IEnumerable<CoreRow> rows, Columns<TSource> columns, bool hasstyle, bool hasjob, Expression<Func<TSource, object>> source, CoreRow? target = null, Expression<Func<StockSummary, object>>? aggregate = null)
    {
        int srcol = columns.IndexOf(source);
        
        if (srcol == -1)
            return 0.00;

        var total =  rows.Aggregate(0d, (value, row) => value + (double)(row.Values[srcol] ?? 0.0d));
        
        // int productcol = columns.IndexOf(x => x.Product.ID);
        // int stylecol = hasstyle ? columns.IndexOf(x => x.Style.ID) : -1;
        // int jobcol = hasjob ? columns.IndexOf(x => x.Job.ID) : -1;
        // int unitcol = columns.IndexOf(x => x.Dimensions.UnitSize);
        //
        // var tuples = rows.Select(r => new Tuple<Guid, Guid?, Guid?, String, double>(
        //     (Guid)(r.Values[productcol] ?? Guid.Empty),
        //     (hasstyle ? (Guid)(r.Values[stylecol] ?? Guid.Empty) : null),
        //     (hasjob ? (Guid)(r.Values[jobcol] ?? Guid.Empty) : null),
        //     (String)(r.Values[unitcol] ?? ""),
        //     (double)(r.Values[aggcol] ?? 0.0d))
        // ).ToArray();
        //
        // var total = tuples.Aggregate(0d, (value, tuple) => value + tuple.Item5);

        if(aggregate is not null)
        {
            target?.Set(aggregate, total);
        }
        return total;
    }
    
    private class StockSummaryInfo
    {
        public double MinStock { get; set; }
        public double GenStock { get; set; }
        public double GenPO { get; set; }
        public double JobBOM { get; set; }
        public double JobStock { get; set; }
        public double JobPO { get; set; }
        
        public double Required => Math.Max((MinStock + JobBOM) - (GenStock + GenPO + JobStock + JobPO), 0.0F);
        
        public double Optimised => Math.Max(Math.Max(MinStock,JobBOM) - (GenStock + GenPO + JobStock + JobPO), 0.0F);
    }

    private Dictionary<Guid, StockSummaryInfo> _summaryinfo = new Dictionary<Guid, StockSummaryInfo>();
    
    protected override void Reload(Filters<ProductInstance> criteria, Columns<ProductInstance> columns, ref SortOrder<ProductInstance>? sort,
        Action<CoreTable?, Exception?> action)
    {
        
        var query = new MultiQuery();
        
        query.Add<ProductInstance>(
            GroupIDs.Length == 0
                ? new Filter<ProductInstance>().None() 
                : new Filter<ProductInstance>(pi=>pi.Product.Group.ID).InList(GroupIDs),
            columns,
            new SortOrder<ProductInstance>(x=>x.Product.Code)
        );
        
        query.Add<StockHolding>(
            GroupIDs.Length == 0
                ? new Filter<StockHolding>().None()
                : new Filter<StockHolding>(x=>x.Product.Group.ID).InList(GroupIDs)
                    .And(new Filter<StockHolding>(x=>x.Job.ID).InList(JobIDs).Or(x=>x.Job.ID).IsEqualTo(Guid.Empty)),
            new Columns<StockHolding>(x=>x.Product.ID)
                .Add(x=>x.Job.ID)
                .Add(x=>x.Style.ID)
                .Add(x=>x.Dimensions.Unit.ID)
                .Add(x=>x.Dimensions.UnitSize)
                .Add(x=>x.Units),
            null
        );
        
        query.Add<PurchaseOrderItem>(
            GroupIDs.Length == 0
                ? new Filter<PurchaseOrderItem>().None()
                : new Filter<PurchaseOrderItem>(x=>x.Product.Group.ID).InList(GroupIDs)
                    .And(x=>x.ReceivedDate).IsEqualTo(DateTime.MinValue)
                    .And(new Filter<PurchaseOrderItem>(x=>x.Job.ID).InList(JobIDs).Or(x=>x.Job.ID).IsEqualTo(Guid.Empty)),
            new Columns<PurchaseOrderItem>(x=>x.Product.ID)
                .Add(x=>x.Job.ID)
                .Add(x=>x.Style.ID)
                .Add(x=>x.Dimensions.Unit.ID)
                .Add(x=>x.Dimensions.UnitSize)
                .Add(x=>x.Qty),
            null
        );
        
        query.Add<JobBillOfMaterialsItem>(
            GroupIDs.Length == 0
                ? new Filter<JobBillOfMaterialsItem>().None()
                : new Filter<JobBillOfMaterialsItem>(x=>x.Product.Group.ID).InList(GroupIDs)
                    .And(new Filter<JobBillOfMaterialsItem>(x=>x.Job.ID).InList(JobIDs).Or(x=>x.Job.ID).IsEqualTo(Guid.Empty)),
            new Columns<JobBillOfMaterialsItem>(x=>x.Product.ID)
                .Add(x=>x.Job.ID)
                .Add(x=>x.Style.ID)
                .Add(x=>x.Dimensions.Unit.ID)
                .Add(x=>x.Dimensions.UnitSize)
                .Add(x=>x.Quantity),
            null
        );
        
        query.Add<StockMovement>(
            GroupIDs.Length == 0
                ? new Filter<StockMovement>().None()
                : new Filter<StockMovement>(x=>x.Product.Group.ID).InList(GroupIDs)
                    .And(x=>x.Type).IsEqualTo(StockMovementType.Issue)
                    .And(new Filter<StockMovement>(x=>x.Job.ID).InList(JobIDs).Or(x=>x.Job.ID).IsEqualTo(Guid.Empty)),
            new Columns<StockMovement>(x=>x.Product.ID)
                .Add(x=>x.Job.ID)
                .Add(x=>x.Style.ID)
                .Add(x=>x.Dimensions.Unit.ID)
                .Add(x=>x.Dimensions.UnitSize)
                .Add(x=>x.Units),
            null
        );
        
        query.Add<SupplierProduct>(
            GroupIDs.Length == 0
                ? new Filter<SupplierProduct>().None()
                : new Filter<SupplierProduct>(x => x.Product.Group.ID).InList(GroupIDs)
                    .And(new Filter<SupplierProduct>(x => x.Job.ID).InList(JobIDs).Or(x => x.Job.ID).IsEqualTo(Guid.Empty)),
            new Columns<SupplierProduct>(x=>x.Product.ID)
                .Add(x=>x.Job.ID)
                .Add(x=>x.Style.ID)
                .Add(x=>x.Dimensions.Unit.ID)
                .Add(x=>x.Dimensions.UnitSize)
                .Add(x=>x.SupplierLink.ID)
                .Add(x=>x.CostPrice)
                .Add(x=>x.Discount)
                .Add(x=>x.TaxCode.ID),
            null
        );
        
        query.Query(q =>
        {
            _stockHoldings = query.Get<StockHolding>();
            _poItems = query.Get<PurchaseOrderItem>();
            _jobBOMs = query.Get<JobBillOfMaterialsItem>();
            _stockMovements = query.Get<StockMovement>();
            _supplierProducts = query.Get<SupplierProduct>();

            var products = query.Get<ProductInstance>();
            _summaryinfo.Clear();
            
            var _productInstanceCols = new Columns<ProductInstance>(products.Columns);
            var _idCol = _productInstanceCols.IndexOf(x => x.ID);
            var _productIDCol = _productInstanceCols.IndexOf(x => x.Product.ID);
            var _styleIDCol = _productInstanceCols.IndexOf(x => x.Style.ID);
            var _unitSizeCol = _productInstanceCols.IndexOf(x => x.Dimensions.UnitSize);
            
            var _stockHoldingCols = new Columns<StockHolding>(_stockHoldings.Columns);
            var _poItemCols = new Columns<PurchaseOrderItem>(_poItems.Columns);
            var _jobBOMColumns = new Columns<JobBillOfMaterialsItem>(_jobBOMs.Columns);
            var _stockMovementCols = new Columns<StockMovement>(_stockMovements.Columns);
            foreach (var row in products.Rows)
            {
                var _id = row.Values[_idCol] as Guid? ?? Guid.Empty;
                var _productid = row.Values[_productIDCol] as Guid? ?? Guid.Empty;
                var _styleid = row.Values[_styleIDCol] as Guid? ?? Guid.Empty;
                var _unitsize = row.Values[_unitSizeCol] as string ?? "";
                var info = new StockSummaryInfo();
                info.MinStock = row.Get<ProductInstance, double>(x => x.MinimumStockLevel);
                
                var genstockrows = GetRows<StockHolding>(_stockHoldings.Rows, _stockHoldingCols, _productid, _styleid, _unitsize, new Guid[] { Guid.Empty });
                info.GenStock = Aggregate(genstockrows, _stockHoldingCols, true, true, x=>x.Units);
                
                var genporows = GetRows(_poItems.Rows, _poItemCols, _productid, _styleid, _unitsize, new Guid[] { Guid.Empty });
                info.GenPO = Aggregate(genporows, _poItemCols, true, true, x=>x.Qty);
                
                var bomrows = GetRows(_jobBOMs.Rows, _jobBOMColumns, _productid, _styleid, _unitsize, JobIDs);
                var bom = Aggregate(bomrows, _jobBOMColumns, true, true, x=>x.Quantity);
        
                var mvmtrows = GetRows(_stockMovements.Rows, _stockMovementCols, _productid, _styleid, _unitsize, JobIDs);
                var mvmts = Aggregate(mvmtrows, _jobBOMColumns, true, true, x=>x.Quantity);
        
                info.JobBOM =  bom - mvmts;
                
                var jobstockrows = GetRows<StockHolding>(_stockHoldings.Rows, _stockHoldingCols, _productid, _styleid, _unitsize, JobIDs);
                info.JobStock = Aggregate(jobstockrows, _stockHoldingCols, true, true, x=>x.Units);
                
                var jobporows = GetRows(_poItems.Rows, _poItemCols, _productid, _styleid, _unitsize, JobIDs);
                info.JobPO = Aggregate(jobporows, _poItemCols, true, true, x=>x.Qty);

                _summaryinfo[_id] = info;

            }
            // Process the tables here
            action.Invoke(query.Get<ProductInstance>(), null);
        });
            
    }

    protected override bool FilterRecord(CoreRow row)
    {
        bool result = base.FilterRecord(row);
        if (_summaryinfo.TryGetValue(row.Get<ProductInstance, Guid>(x => x.ID), out StockSummaryInfo? info))
        {
            if (RequiredOnly)
            {
                result = result && Optimise
                    ? !info.Optimised.IsEffectivelyEqual(0)
                    : !info.Required.IsEffectivelyEqual(0);
            }

            if (!AllStock)
                result = result && _uicomponent?.CheckSuppliers(row) == true;

        }

        return result;
    }

    private object GetMinimumStockLevel(CoreRow? row) => row?.Get<ProductInstance, double>(x => x.MinimumStockLevel) ?? 0.0F;
    
    private object GetGeneralStockLevel(CoreRow? row)
    {
        if (row != null && _summaryinfo.TryGetValue(row.Get<ProductInstance, Guid>(x => x.ID), out StockSummaryInfo? info))
            return info.GenStock;
        return 0.0F;
    }

    private object GetGeneralPurchaseOrder(CoreRow? row)
    {
        if (row != null && _summaryinfo.TryGetValue(row.Get<ProductInstance, Guid>(x => x.ID), out StockSummaryInfo? info))
            return info.GenPO;
        return 0.0F;
    }
    
    private object GetBOMBalance(CoreRow? row)
    {
        if (row != null && _summaryinfo.TryGetValue(row.Get<ProductInstance, Guid>(x => x.ID), out StockSummaryInfo? info))
            return info.JobBOM;
        return 0.0F;
    }

    private object GetReservedStock(CoreRow? row)
    {
        if (row != null && _summaryinfo.TryGetValue(row.Get<ProductInstance, Guid>(x => x.ID), out StockSummaryInfo? info))
            return info.JobStock;
        return 0.0F;
    }

    private object GetReservedPurchaseOrder(CoreRow? row)
    {
        if (row != null && _summaryinfo.TryGetValue(row.Get<ProductInstance, Guid>(x => x.ID), out StockSummaryInfo? info))
            return info.JobPO;
        return 0.0F;
    }

    private object GetBalanceRequired(CoreRow? row)
    {
        if (row != null &&
            _summaryinfo.TryGetValue(row.Get<ProductInstance, Guid>(x => x.ID), out StockSummaryInfo? info))
            return Optimise
                ? info.Optimised.IsEffectivelyEqual(0.0F) ? "" : $"{info.Optimised:F2}"
                : info.Required.IsEffectivelyEqual(0.0F)
                    ? ""
                    : $"{info.Required:F2}";
        return "";
    }
    
    private bool OrderStock_Click(Button button, CoreRow[] rows)
    {
        if(rows.Length == 0)
        {
            return false;
        }

        var _instances = rows.ToObjects<ProductInstance>().ToArray();

        var order = new PurchaseOrder();
        order.Description = "Purchase Order created from Stock Forecast Screen";
        order.RaisedBy.ID = App.EmployeeID;
        order.IssuedBy.ID = App.EmployeeID;
        order.IssuedDate = DateTime.Today;

        var orderItems = new List<PurchaseOrderItem>();

        foreach(var stockSummary in _instances)
        {
            var orderItem = new PurchaseOrderItem();
            orderItem.Product.ID = stockSummary.Product.ID;
            orderItem.Style.ID = stockSummary.Style.ID;
            
            // Need to Breakout BOMs into individual Lines
            //orderItem.Job.ID = stockSummary.Job.ID;
            
            orderItem.Dimensions.CopyFrom(stockSummary.Dimensions);
 
            // Need to calculate Balance based on Supplier.OrderQty
            //orderItem.Qty = Math.Max(-stockSummary.BalanceAvailable, 0);
            
            orderItems.Add(orderItem);
        }
        LookupFactory.DoLookups<PurchaseOrderItem, Product, ProductLink>(
            orderItems.Select(x => new Tuple<PurchaseOrderItem, Guid>(x, x.Product.ID)),
            x => x.Product);
        LookupFactory.DoLookups<PurchaseOrderItem, ProductStyle, ProductStyleLink>(
            orderItems.Select(x => new Tuple<PurchaseOrderItem, Guid>(x, x.Style.ID)),
            x => x.Style);
        LookupFactory.DoLookups<PurchaseOrderItem, Job, JobLink>(
            orderItems.Select(x => new Tuple<PurchaseOrderItem, Guid>(x, x.Job.ID)),
            x => x.Job);

        if (DynamicGridUtils.EditEntity(order, t =>
        {
            if (t == typeof(PurchaseOrderItem))
            {
                var table = new CoreTable();
                table.LoadColumns(typeof(PurchaseOrderItem));
                table.LoadRows(orderItems);
                return table;
            }
            return null;
        }, preloadPages: true))
        {
            MessageWindow.ShowMessage("Purchase order created.", "Success.");
        }
        return false;
    }

    #region IDataModelSource
    
    public event DataModelUpdateEvent? OnUpdateDataModel;

    public string SectionName => "Stock Summary";
    
    public bool Optimise { get; set; }
    
    public bool AllStock { get; set; }
    
    public bool RequiredOnly { get; set; }

    public DataModel DataModel(Selection selection)
    {
        return new AutoDataModel<StockSummary>(null);
    }
    
    #endregion
}