prs/prs.classes/Entities/Stock/StockHolding.cs

using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using InABox.Core;
using PRSClasses;

namespace Comal.Classes
{
    
    public class StockHoldingUnitAggregate : CoreAggregate<StockHolding, StockMovement, double>
    {
        public override Expression<Func<StockMovement, double>> Aggregate => x => x.Units;

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockHolding => StockHolding.Product.ID },
                { StockMovement => StockMovement.Job.ID, StockHolding => StockHolding.Job.ID },
                { StockMovement => StockMovement.Location.ID, StockHolding => StockHolding.Location.ID },
                { StockMovement => StockMovement.Style.ID, StockHolding => StockHolding.Style.ID },
                { StockMovement => StockMovement.Dimensions.Unit.ID, StockHolding => StockHolding.Dimensions.Unit.ID },
                { StockMovement => StockMovement.Dimensions.Quantity, StockHolding => StockHolding.Dimensions.Quantity },
                { StockMovement => StockMovement.Dimensions.Length, StockHolding => StockHolding.Dimensions.Length },
                { StockMovement => StockMovement.Dimensions.Width, StockHolding => StockHolding.Dimensions.Width },
                { StockMovement => StockMovement.Dimensions.Height, StockHolding => StockHolding.Dimensions.Height },
                { StockMovement => StockMovement.Dimensions.Weight, StockHolding => StockHolding.Dimensions.Weight },
            };

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;
    }
    
    public class StockHoldingValueAggregate : CoreAggregate<StockHolding, StockMovement, double>
    {
        public override Expression<Func<StockMovement, double>> Aggregate => x => x.Value;

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockHolding => StockHolding.Product.ID },
                { StockMovement => StockMovement.Job.ID, StockHolding => StockHolding.Job.ID },
                { StockMovement => StockMovement.Location.ID, StockHolding => StockHolding.Location.ID },
                { StockMovement => StockMovement.Style.ID, StockHolding => StockHolding.Style.ID },
                { StockMovement => StockMovement.Dimensions.Unit.ID, StockHolding => StockHolding.Dimensions.Unit.ID },
                { StockMovement => StockMovement.Dimensions.Quantity, StockHolding => StockHolding.Dimensions.Quantity },
                { StockMovement => StockMovement.Dimensions.Length, StockHolding => StockHolding.Dimensions.Length },
                { StockMovement => StockMovement.Dimensions.Width, StockHolding => StockHolding.Dimensions.Width },
                { StockMovement => StockMovement.Dimensions.Height, StockHolding => StockHolding.Dimensions.Height },
                { StockMovement => StockMovement.Dimensions.Weight, StockHolding => StockHolding.Dimensions.Weight },
            };

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;
    }
    
    public class StockHoldingAverageValueFormula : IFormula<StockHolding, double>
    {
        public Expression<Func<StockHolding, double>> Value => x => x.Value;

        public Expression<Func<StockHolding, double>>[] Modifiers => new Expression<Func<StockHolding, double>>[] { x => x.Units };

        public FormulaOperator Operator => FormulaOperator.Divide;
        
        public FormulaType Type => FormulaType.Virtual;
    }

    public class StockHoldingQuantityAggregate : CoreAggregate<StockHolding, StockMovement, double>
    {
        public override Expression<Func<StockMovement, double>> Aggregate => x => x.Qty;

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockHolding => StockHolding.Product.ID },
                { StockMovement => StockMovement.Job.ID, StockHolding => StockHolding.Job.ID },
                { StockMovement => StockMovement.Location.ID, StockHolding => StockHolding.Location.ID },
                { StockMovement => StockMovement.Style.ID, StockHolding => StockHolding.Style.ID },
                { StockMovement => StockMovement.Dimensions.Unit.ID, StockHolding => StockHolding.Dimensions.Unit.ID },
                { StockMovement => StockMovement.Dimensions.Quantity, StockHolding => StockHolding.Dimensions.Quantity },
                { StockMovement => StockMovement.Dimensions.Length, StockHolding => StockHolding.Dimensions.Length },
                { StockMovement => StockMovement.Dimensions.Width, StockHolding => StockHolding.Dimensions.Width },
                { StockMovement => StockMovement.Dimensions.Height, StockHolding => StockHolding.Dimensions.Height },
                { StockMovement => StockMovement.Dimensions.Weight, StockHolding => StockHolding.Dimensions.Weight },
            };

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;
    }

    public class StockHoldingAvailableAggregate : CoreAggregate<StockHolding, StockMovement, double>
    {
        public override Expression<Func<StockMovement, double>> Aggregate => x => x.Units;

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockHolding, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockHolding => StockHolding.Product.ID },
                { StockMovement => StockMovement.Job.ID, StockHolding => StockHolding.Job.ID },
                { StockMovement => StockMovement.Location.ID, StockHolding => StockHolding.Location.ID },
                { StockMovement => StockMovement.Style.ID, StockHolding => StockHolding.Style.ID },
                { StockMovement => StockMovement.Dimensions.Unit.ID, StockHolding => StockHolding.Dimensions.Unit.ID },
                { StockMovement => StockMovement.Dimensions.Quantity, StockHolding => StockHolding.Dimensions.Quantity },
                { StockMovement => StockMovement.Dimensions.Length, StockHolding => StockHolding.Dimensions.Length },
                { StockMovement => StockMovement.Dimensions.Width, StockHolding => StockHolding.Dimensions.Width },
                { StockMovement => StockMovement.Dimensions.Height, StockHolding => StockHolding.Dimensions.Height },
                { StockMovement => StockMovement.Dimensions.Weight, StockHolding => StockHolding.Dimensions.Weight },
            };

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Filter<StockMovement>? Filter => new Filter<StockMovement>(x => x.JobRequisitionItem.ID).IsEqualTo(Guid.Empty);
    }
    
    public class StockHoldingWeightFormula : IFormula<StockHolding, double>
    {
        public Expression<Func<StockHolding, double>> Value => x => x.Qty;

        public Expression<Func<StockHolding, double>>[] Modifiers => new Expression<Func<StockHolding, double>>[] { x => x.Dimensions.Weight };

        public FormulaOperator Operator => FormulaOperator.Multiply;
        
        public FormulaType Type => FormulaType.Virtual;
    }

    public class StockHoldingIsRemnantCondition : ICondition<StockHolding, double, object>
    {
        public Expression<Func<StockHolding, double>> Left => x => x.Dimensions.Value;

        public Condition Condition => Condition.LessThan;

        public Expression<Func<StockHolding, double>> Right => x => x.Product.DefaultInstance.Dimensions.Value;

        public Expression<Func<StockHolding, object>> True => x => true;

        public Expression<Func<StockHolding, object>> False => x => null;
        
        public ConditionType Type => ConditionType.Virtual;
    }
    
    public class StockHoldingUnionGenerator : AutoEntityUnionGenerator<IStockHolding>
    {
        protected override void Configure()
        {
            AddTable<StockMovement>();
        }

        public override bool Distinct => true;

        public override Column<IStockHolding>[] IDColumns => Columns;

        public static Column<IStockHolding>[] Columns => new Column<IStockHolding>[]
        {
            new Column<IStockHolding>(x => x.Job.ID),
            new Column<IStockHolding>(x => x.Location.ID),
            new Column<IStockHolding>(x => x.Product.ID),
            new Column<IStockHolding>(x => x.Style.ID),
            new Column<IStockHolding>(x => x.Dimensions.Unit.ID),
            new Column<IStockHolding>(x => x.Dimensions.Quantity),
            new Column<IStockHolding>(x => x.Dimensions.Length),
            new Column<IStockHolding>(x => x.Dimensions.Width),
            new Column<IStockHolding>(x => x.Dimensions.Height),
            new Column<IStockHolding>(x => x.Dimensions.Weight),
        };

        public static Filter<StockMovement>? GetFilter(IStockHolding holding)
        {
            var filter = new Filters<StockMovement>();

            foreach(var column in Columns)
            {
                filter.Add(new Filter<StockMovement>(column.Cast<StockMovement>()).IsEqualTo(CoreUtils.GetPropertyValue(holding, column.Property)));
            }

            return filter.Combine();
        }
    }
    
    [UserTracking(typeof(StockMovement))]
    [AutoEntity(typeof(StockHoldingUnionGenerator))]
    public class StockHolding : StockEntity, IRemotable, IPersistent, IOneToMany<StockLocation>, IOneToMany<Product>, 
        IStockHolding, ILicense<WarehouseLicense>
    {
        
        public override ProductLink Product { get; set; }

        public ProductStyleLink Style { get; set; }

        public StockLocationLink Location { get; set; }

        public JobLink Job { get; set; }

        [RequiredColumn]
        [DimensionsEditor(typeof(StockDimensions), AllowEditingUnit = false)]
        public override StockDimensions Dimensions { get; set; }

        [Condition(typeof(StockHoldingIsRemnantCondition))]
        [NullEditor]
        public bool IsRemnant { get; set; }
        
        [Aggregate(typeof(StockHoldingUnitAggregate))]
        [DoubleEditor(Editable = Editable.Disabled, Summary = Summary.Sum)]
        public double Units { get; set; }
        
        [Aggregate(typeof(StockHoldingAvailableAggregate))]
        [DoubleEditor(Editable = Editable.Disabled, Summary = Summary.Sum)]
        public double Available { get; set; }
        
        [Aggregate(typeof(StockHoldingQuantityAggregate))]
        [DoubleEditor(Editable = Editable.Disabled, Summary = Summary.Sum)]
        public double Qty { get; set; }
        
        [Formula(typeof(StockHoldingWeightFormula))]
        [DoubleEditor(Editable = Editable.Disabled, Summary = Summary.Sum)]
        public double Weight { get; set; }
        
        [Aggregate(typeof(StockHoldingValueAggregate))]
        [DoubleEditor(Editable = Editable.Disabled, Summary = Summary.Sum)]
        public double Value { get; set; }
        
        [Formula(typeof(StockHoldingAverageValueFormula))]
        [DoubleEditor(Editable = Editable.Disabled)]
        public double AverageValue { get; set; }
    }
}