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>(new Filter<StockMovement>(x=>x.Job.JobStatus.Active).IsEqualTo(true));
    //         AddTable<JobBillOfMaterialsItem>(new Filter<JobBillOfMaterialsItem>(x=>x.Job.JobStatus.Active).IsEqualTo(true));
    //         AddTable<JobRequisitionItem>(new Filter<JobRequisitionItem>(x=>x.Job.JobStatus.Active).IsEqualTo(true));
    //         AddTable<PurchaseOrderItem>(new Filter<PurchaseOrderItem>(x=>x.Job.JobStatus.Active).IsEqualTo(true));
    //     }
    //
    //     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();
    //     }
    //     
    // }
}