using InABox.Core;
using System;

namespace Comal.Classes
{
    public class TimeSheetFormLookups : ILookupDefinition<DigitalForm, TimeSheetForm>, ILookupDefinition<DigitalForm, TimeSheet>
    {
        public Filter<DigitalForm> DefineFilter(TimeSheetForm[] items)
        {
            return new Filter<DigitalForm>(x => x.Active).IsEqualTo(true).And(x => x.AppliesTo).IsEqualTo("TimeSheet");
        }

        Columns<TimeSheetForm> ILookupDefinition<DigitalForm, TimeSheetForm>.DefineFilterColumns()
            => new Columns<TimeSheetForm>();

        public Filter<DigitalForm> DefineFilter(TimeSheet[] items)
        {
            var filter = DefineFilter(Array.Empty<TimeSheetForm>());

            foreach (var timesheet in items)
            {
                filter.And(x => x.ID).InQuery(
                    new Filter<EmployeeDigitalForm>(x => x.Employee.ID).IsEqualTo(timesheet.EmployeeLink.ID),
                    x => x.Form.ID);
            }

            return filter;
        }

        Columns<TimeSheet> ILookupDefinition<DigitalForm, TimeSheet>.DefineFilterColumns()
            => new Columns<TimeSheet>(x => x.EmployeeLink.ID);
    }
}