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

namespace Comal.Classes
{
    
    public class JobRequisitionItemPurchaseOrderItem : Entity, IRemotable, IPersistent, IOneToMany<JobRequisitionItem>, ILicense<ProjectManagementLicense>
    {
        [NullEditor]
        [EntityRelationship(DeleteAction.Cascade)]
        public JobRequisitionItemLink JobRequisitionItem { get; set; }

        private class PurchaseOrderItemLookup : LookupDefinitionGenerator<PurchaseOrderItem, JobRequisitionItemPurchaseOrderItem>
        {
            public override Filter<PurchaseOrderItem>? DefineFilter(JobRequisitionItemPurchaseOrderItem[] items)
            {
                var jobs = items.Select(x => x.JobRequisitionItem.Job.ID).Distinct().ToArray();
                var products = items.Select(x => x.JobRequisitionItem.Product.ID).Distinct().ToArray();
                if(jobs.Length == 1 && products.Length == 1)
                {
                    return new Filter<PurchaseOrderItem>(x => x.Job.ID).IsEqualTo(jobs.First())
                        .And(x => x.Product.ID).IsEqualTo(products.First());
                }
                {
                    return new Filter<PurchaseOrderItem>().None();
                }
            }

            public override Columns<JobRequisitionItemPurchaseOrderItem> DefineFilterColumns()
                => Columns.None<JobRequisitionItemPurchaseOrderItem>().Add(x => x.JobRequisitionItem.Job.ID)
                .Add(x => x.JobRequisitionItem.Product.ID);
        }
        [LookupDefinition(typeof(PurchaseOrderItemLookup))]
        [EntityRelationship(DeleteAction.Cascade)]
        public PurchaseOrderItemLink PurchaseOrderItem { get; set; }
    }
}