prs/prs.classes/Entities/Stock/StockSummary.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Runtime.CompilerServices;
using InABox.Core;

namespace Comal.Classes
{
    public class StockSummaryBOMAggregate : CoreAggregate<StockSummary, JobBillOfMaterialsItem, double>
    {
        public override Expression<Func<JobBillOfMaterialsItem, double>> Aggregate => x => x.Quantity;

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Dictionary<Expression<Func<JobBillOfMaterialsItem, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<JobBillOfMaterialsItem, object>>, Expression<Func<StockSummary, object>>>()
            {
                { JobBillOfMaterialsItem => JobBillOfMaterialsItem.Product.ID, StockSummary => StockSummary.Product.ID },
                { JobBillOfMaterialsItem => JobBillOfMaterialsItem.Style.ID, StockSummary => StockSummary.Style.ID },
                { JobBillOfMaterialsItem => JobBillOfMaterialsItem.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };

        public override Filter<JobBillOfMaterialsItem> Filter =>
            new Filter<JobBillOfMaterialsItem>(x => x.BillOfMaterials.Approved).IsNotEqualTo(DateTime.MinValue);
    }

    public class StockSummaryTotalRequiredAggregate : CoreAggregate<StockSummary, JobRequisitionItem, double>
    {
        public override Expression<Func<JobRequisitionItem, double>> Aggregate => x => x.Qty;

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Dictionary<Expression<Func<JobRequisitionItem, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<JobRequisitionItem, object>>, Expression<Func<StockSummary, object>>>()
            {
                { StockSummaryRequisitionItem => StockSummaryRequisitionItem.Product.ID, StockSummary => StockSummary.Product.ID },
                { StockSummaryRequisitionItem => StockSummaryRequisitionItem.Style.ID, StockSummary => StockSummary.Style.ID },
                { StockSummaryRequisitionItem => StockSummaryRequisitionItem.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };
        
        public override Filter<JobRequisitionItem> Filter =>
            new Filter<JobRequisitionItem>(x => x.Requisition.Approved).IsNotEqualTo(DateTime.MinValue);

    }
    
    public class StockSummaryOrderAggregate : CoreAggregate<StockSummary, PurchaseOrderItem, double>
    {
        public override Expression<Func<PurchaseOrderItem, double>> Aggregate => x => x.Qty;

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Dictionary<Expression<Func<PurchaseOrderItem, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<PurchaseOrderItem, object>>, Expression<Func<StockSummary, object>>>()
            {
                { PurchaseOrderItem => PurchaseOrderItem.Product.ID, StockSummary => StockSummary.Product.ID },
                { PurchaseOrderItem => PurchaseOrderItem.Style.ID, StockSummary => StockSummary.Style.ID },
                { PurchaseOrderItem => PurchaseOrderItem.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };

        public override Filter<PurchaseOrderItem> Filter => new Filter<PurchaseOrderItem>(x => x.ReceivedDate).IsEqualTo(DateTime.MinValue);
    }

    public class StockSummaryOrderValue : CoreAggregate<StockSummary, PurchaseOrderItem, double>
    {
        public override Expression<Func<PurchaseOrderItem, double>> Aggregate => x => x.ExTax;

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Dictionary<Expression<Func<PurchaseOrderItem, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<PurchaseOrderItem, object>>, Expression<Func<StockSummary, object>>>()
            {
                { PurchaseOrderItem => PurchaseOrderItem.Product.ID, StockSummary => StockSummary.Product.ID },
                { PurchaseOrderItem => PurchaseOrderItem.Style.ID, StockSummary => StockSummary.Style.ID },
                { PurchaseOrderItem => PurchaseOrderItem.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };

        public override Filter<PurchaseOrderItem> Filter => new Filter<PurchaseOrderItem>(x => x.ReceivedDate).IsEqualTo(DateTime.MinValue);
    }

    public class StockSummaryReceivedAggregate : CoreAggregate<StockSummary, StockMovement, double>
    {
        public override Expression<Func<StockMovement, double>> Aggregate => x => x.Received;

        public override Filter<StockMovement> Filter => new Filter<StockMovement>(x => x.IsTransfer).IsEqualTo(false);

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockSummary => StockSummary.Product.ID },
                { StockMovement => StockMovement.Style.ID, StockSummary => StockSummary.Style.ID },
                { StockMovement => StockMovement.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };
    }

    public class StockSummaryIssuedAggregate : CoreAggregate<StockSummary, StockMovement, double>
    {
        public override Expression<Func<StockMovement, double>> Aggregate => x => x.Issued;

        public override Filter<StockMovement> Filter => new Filter<StockMovement>(x => x.IsTransfer).IsEqualTo(false);

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockSummary => StockSummary.Product.ID },
                { StockMovement => StockMovement.Style.ID, StockSummary => StockSummary.Style.ID },
                { StockMovement => StockMovement.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };
    }

    public class StockSummaryBalanceRequiredFormula : IFormula<StockSummary, double>
    {
        public Expression<Func<StockSummary, double>> Value => x => x.TotalRequired;
        public Expression<Func<StockSummary, double>>[] Modifiers => new Expression<Func<StockSummary, double>>[] { x => x.Issued };
        public FormulaOperator Operator => FormulaOperator.Subtract;
        public FormulaType Type => FormulaType.Virtual;
    }

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

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockSummary => StockSummary.Product.ID },
                { StockMovement => StockMovement.Style.ID, StockSummary => StockSummary.Style.ID },
                { StockMovement => StockMovement.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };
    }

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

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;

        public override Filter<StockMovement> Filter => new Filter<StockMovement>(x => x.Job).NotLinkValid().Or(x=>x.Job.JobStatus.Active).IsEqualTo(false);

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockSummary, object>>>()
            {
                { StockMovement => StockMovement.Product.ID, StockSummary => StockSummary.Product.ID },
                //{ StockMovement => StockMovement.Style.ID, StockSummary => StockSummary.Style.ID },
                //{ StockMovement => StockMovement.Dimensions.UnitSize, StockSummary => StockSummary.Dimensions.UnitSize }
            };
    }
    
    public interface IStockSummary
    {
        
        ProductLink Product { get; set; }

        ProductStyleLink Style { get; set; }

        StockDimensions Dimensions { get; set; }
    }

    public class StockSummaryUnionGenerator : AutoEntityUnionGenerator<IStockSummary>
    {
        protected override void Configure()
        {
            AddTable<StockMovement>();
            AddTable<JobBillOfMaterialsItem>();
            AddTable<JobRequisitionItem>();
            AddTable<PurchaseOrderItem>();
        }

        public override bool Distinct => true;

        public override Column<IStockSummary>[] IDColumns => new Column<IStockSummary>[]
        {
            new Column<IStockSummary>(x => x.Product.ID),
            new Column<IStockSummary>(x => x.Style.ID),
            new Column<IStockSummary>(x => x.Dimensions.Unit.ID),
            new Column<IStockSummary>(x => x.Dimensions.Quantity),
            new Column<IStockSummary>(x => x.Dimensions.Length),
            new Column<IStockSummary>(x => x.Dimensions.Width),
            new Column<IStockSummary>(x => x.Dimensions.Height),
            new Column<IStockSummary>(x => x.Dimensions.Weight)
        };
    }    
    
    
    [UserTracking(typeof(Product))]
    [AutoEntity(typeof(StockSummaryUnionGenerator))]
    public class StockSummary : StockEntity, IStockSummary, IRemotable, IPersistent, ILicense<ProductManagementLicense>/* , IDimensioned */
    {

        [EditorSequence(1)]
        public override ProductLink Product { get; set; }

        [EditorSequence(2)]
        public ProductStyleLink Style { get; set; }

        [NullEditor]
        [Obsolete("Replaced with Dimensions", true)]
        public double UnitSize { get; set; }

        [EditorSequence(3)]
        [RequiredColumn]
        [DimensionsEditor(typeof(StockDimensions), AllowEditingUnit = false)]
        public override StockDimensions Dimensions { get; set; }
        
        [EditorSequence(4)]
        [DoubleEditor]
        [Aggregate(typeof(StockSummaryBOMAggregate))]
        public double BillOfMaterials { get; set; }

        [EditorSequence(5)]
        [DoubleEditor]
        [Aggregate(typeof(StockSummaryTotalRequiredAggregate))]
        public double TotalRequired { get; set; }

        [EditorSequence(6)]
        [DoubleEditor]
        [Aggregate(typeof(StockSummaryOrderAggregate))]
        public double OnOrder { get; set; }

        [EditorSequence(7)]
        [DoubleEditor]
        [Aggregate(typeof(StockSummaryOrderValue))]
        public double OrderValue { get; set; }

        [EditorSequence(8)]
        [Aggregate(typeof(StockSummaryReceivedAggregate))]
        [DoubleEditor(Editable = Editable.Hidden)]
        public double Received { get; set; }

        [EditorSequence(9)]
        [Aggregate(typeof(StockSummaryIssuedAggregate))]
        [DoubleEditor(Editable = Editable.Hidden)]
        public double Issued { get; set; }

        [EditorSequence(10)]
        [DoubleEditor]
        [Formula(typeof(StockSummaryBalanceRequiredFormula))]
        public double BalanceRequired { get; set; }

        [EditorSequence(11)]
        [Aggregate(typeof(StockSummaryReservedStockAggregate))]
        [DoubleEditor(Editable = Editable.Hidden)]
        public double ReservedStock { get; set; }

        [EditorSequence(12)]
        [Aggregate(typeof(StockSummaryFreeStockAggregate))]
        [DoubleEditor(Editable = Editable.Hidden)]
        public double FreeStock { get; set; }
        
        protected override void Init()
        {
            base.Init();
            Style = new ProductStyleLink();
        }
        
    }
}