prs/prs.classes/Entities/Stock/StockLocation/StockLocation.cs

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

namespace Comal.Classes
{
    
    public class StockLocationHoldings : CoreAggregate<StockLocation, StockHolding, Guid>
    {
        public override Expression<Func<StockHolding, Guid>> Aggregate => x => x.Product.ID;
        
        public override Dictionary<Expression<Func<StockHolding, object>>, Expression<Func<StockLocation, object>>> Links =>
            new Dictionary<Expression<Func<StockHolding, object>>, Expression<Func<StockLocation, object>>>()
            {
                { StockHolding => StockHolding.Location.ID, StockLocation => StockLocation.ID },
            };
    
        public override AggregateCalculation Calculation => AggregateCalculation.Count;
    }
    
    public class StockLocationLastStocktake : CoreAggregate<StockLocation, StockMovement, DateTime>
    {
        public override Expression<Func<StockMovement, DateTime>> Aggregate => x => x.Date;

        public override Filter<StockMovement> Filter => new Filter<StockMovement>(x => x.Batch).LinkValid().And(x => x.Batch.Type)
            .IsEqualTo(StockMovementBatchType.Stocktake);

        public override Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockLocation, object>>> Links =>
            new Dictionary<Expression<Func<StockMovement, object>>, Expression<Func<StockLocation, object>>>()
            {
                { StockMovement => StockMovement.Location.ID, StockLocation => StockLocation.ID }
            };

        public override AggregateCalculation Calculation => AggregateCalculation.Maximum;
    }
    
    [UserTracking(typeof(StockMovement))]
    public class StockLocation : Entity, IRemotable, IPersistent, IStockLocation, ILicense<WarehouseLicense>, IExportable, IImportable
    {
        
        
        [UniqueCodeEditor(Visible = Visible.Default, Editable = Editable.Enabled)]
        [EditorSequence(1)]
        public string Code { get; set; }

        [TextBoxEditor]
        [EditorSequence(2)]
        public string Description { get; set; }
        
        [EntityRelationship(DeleteAction.SetNull)]
        [EditorSequence(3)]
        public StockWarehouseLink Warehouse { get; set; }

        private class StockAreaLookup : LookupDefinitionGenerator<StockArea, StockLocation>
        {
            public override Filter<StockArea> DefineFilter(StockLocation[] items)
            {
                var ids = items.Select(x => x.Warehouse.ID).Distinct().ToArray();
                if (ids.Length == 1)
                    return new Filter<StockArea>(x => x.Warehouse.ID).IsEqualTo(ids[0]).And(x => x.Active).IsEqualTo(true);
                return new Filter<StockArea>(x => x.ID).IsEqualTo(CoreUtils.FullGuid);
            }

            public override Columns<StockLocation> DefineFilterColumns()
                => new Columns<StockLocation>(x => x.Warehouse.ID);
        }
        [LookupDefinition(typeof(StockAreaLookup))]
        [EntityRelationship(DeleteAction.SetNull)]
        [EditorSequence(4)]
        public StockAreaLink Area { get; set; }
        
        
        [EditorSequence(5)]
        public JobLink Job { get; set; }

        /// <summary>
        ///     Is the location a "shelf" (ie permanent) or "pack" (ie transient)
        /// </summary>
        [EnumLookupEditor(typeof(StockLocationType))]
        [EditorSequence(6)]
        public StockLocationType Type { get; set; }
        
        /// <summary>
        ///     Is the Stock Location Active?
        /// </summary>
        [EditorSequence(7)]
        public bool Active { get; set; }

        /// <summary>
        ///     Mark this location as the default receival location for the warehouse
        /// </summary>
        [EditorSequence(8)]
        public bool Default { get; set; }

        /// <summary>
        ///     Mark this location as a favourite which shows up in Timebench Transfer module for quick selection
        /// </summary>
        [EditorSequence(9)]
        public bool Favourite { get; set; } = false;
        
        [Aggregate(typeof(StockLocationHoldings))]
        [DoubleEditor(Editable = Editable.Hidden)]
        [EditorSequence(10)]
        public double Holdings { get; set; }

        [Aggregate(typeof(StockLocationLastStocktake))]
        [DateEditor(Editable = Editable.Hidden)]
        [EditorSequence(11)]
        public DateTime LastStocktake { get; set; }

    }
}