public void AddOverlapTest()
{
var calendar = new ClockWorkUnitCollection(Worker, new ClockWorkUnit(DateTime.Today.AddHours(8), DateTime.Today.AddHours(17)))
{
new ClockWorkUnit(DateTime.Today.AddHours(4), DateTime.Today.AddHours(5))
};
Assert.Equal(2, calendar.Count);
calendar.Add(new ClockWorkUnit(DateTime.Today.AddHours(7.5), DateTime.Today.AddHours(8.5)));
Assert.Equal(2, calendar.Count);
Assert.Equal(7.5, calendar.Last().Start.TimeOfDay.TotalHours);
Assert.Equal(17, calendar.Last().End.TimeOfDay.TotalHours);
calendar.Add(new ClockWorkUnit(DateTime.Today.AddHours(16.5), DateTime.Today.AddHours(17.5)));
Assert.Equal(2, calendar.Count);
Assert.Equal(7.5, calendar.Last().Start.TimeOfDay.TotalHours);
Assert.Equal(17.5, calendar.Last().End.TimeOfDay.TotalHours);
calendar.Add(new ClockWorkUnit(DateTime.Today.AddHours(7), DateTime.Today.AddHours(18)));
Assert.Equal(2, calendar.Count);
Assert.Equal(7, calendar.Last().Start.TimeOfDay.TotalHours);
Assert.Equal(18, calendar.Last().End.TimeOfDay.TotalHours);
calendar.Add(new ClockWorkUnit(DateTime.Today.AddHours(8), DateTime.Today.AddHours(17)));
Assert.Equal(2, calendar.Count);
Assert.Equal(7, calendar.Last().Start.TimeOfDay.TotalHours);
Assert.Equal(18, calendar.Last().End.TimeOfDay.TotalHours);
}
public void Save(ClockWorkUnitCollection calendar)
{
var existingCalender = _loadedCollections.SingleOrDefault(p => p.Worker.Equals(calendar.Worker));
if (existingCalender != null)
{
_loadedCollections.Remove(existingCalender);
}
_loadedCollections.Add(calendar);
using (var db = GetDatabase(_options))
{
var workers = db.Workers;
var units = db.Units;
var foundWorker = workers.FindOne(p => p.Id == calendar.Worker.Id);
if (foundWorker == null)
{
Save(calendar.Worker);
foundWorker = Worker.FromBusinessModel(calendar.Worker);
}
units.EnsureIndex(p => p.Start);
units.EnsureIndex(p => p.End);
units.Delete(p => p.Start >= calendar.First().Start.Date&& p.End < calendar.Last().End.Date.AddDays(1) && p.Worker.Id == foundWorker.Id);
units.InsertBulk(calendar.Select(p => Unit.FromBusinessModel(p, foundWorker)));
}
}
public void RealDataTest()
{
var worker = new ClockWorker("Mustermann", "Max", new DateTime(1970, 5, 10));
var calendar = new ClockWorkUnitCollection(
worker,
new ClockWorkUnit(new DateTime(2018, 10, 01, 07, 38, 0), new DateTime(2018, 10, 01, 16, 12, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 02, 07, 33, 0), new DateTime(2018, 10, 02, 17, 00, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 04, 07, 35, 0), new DateTime(2018, 10, 04, 17, 07, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 05, 07, 36, 0), new DateTime(2018, 10, 05, 17, 05, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 08, 06, 58, 0), new DateTime(2018, 10, 08, 15, 35, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 09, 07, 33, 0), new DateTime(2018, 10, 09, 17, 01, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 10, 07, 35, 0), new DateTime(2018, 10, 10, 21, 00, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 11, 08, 30, 0), new DateTime(2018, 10, 11, 21, 00, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 12, 07, 35, 0), new DateTime(2018, 10, 12, 16, 45, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 15, 07, 42, 0), new DateTime(2018, 10, 15, 17, 00, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 16, 07, 38, 0), new DateTime(2018, 10, 16, 15, 42, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 17, 07, 33, 0), new DateTime(2018, 10, 17, 17, 08, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 18, 07, 34, 0), new DateTime(2018, 10, 18, 17, 00, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 19, 07, 35, 0), new DateTime(2018, 10, 19, 17, 11, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 22, 07, 38, 0), new DateTime(2018, 10, 22, 16, 12, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 23, 07, 45, 0), new DateTime(2018, 10, 23, 17, 00, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 24, 00, 00, 0), new DateTime(2018, 10, 24, 00, 00, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 25, 07, 40, 0), new DateTime(2018, 10, 25, 16, 36, 0)),
new ClockWorkUnit(new DateTime(2018, 10, 26, 07, 32, 0), new DateTime(2018, 10, 26, 17, 02, 0))
);
IEffectiveWorkingTimeCalculator calculator = new StsWorkCalculator();
var calculationResult = calculator.Calculate(calendar);
string DisplayTime(TimeSpan ts)
{
return($"{(ts < TimeSpan.Zero ? "-" : "+")}{(int) Math.Abs(ts.TotalHours):D2}:{Math.Abs(ts.Minutes):D2}");
}
void LogResult(CalculationResultCollection r, Func <CalculationResult, string> getPrefix)
{
r.ToList().ForEach(p => _output.WriteLine("{0}: balance {1}", getPrefix(p), DisplayTime(p.Overtime)));
}
_output.WriteLine($"Calculated working time for calendar from {calendar.First().Start.Date:dd.MM.yyyy} to {calendar.Last().Start.Date:dd.MM.yyyy}");
_output.WriteLine($" Regular working hours: {DisplayTime(calculationResult.WorkingHours)}");
_output.WriteLine($" Hours accounted for: {DisplayTime(calculationResult.CalculatedWorkedHours)}");
_output.WriteLine($" Unaccounted time: {DisplayTime(calculationResult.ExactWorkedHours - calculationResult.CalculatedWorkedHours)}");
_output.WriteLine($" Accounted overtime: {DisplayTime(calculationResult.Overtime)}");
_output.WriteLine("".PadLeft(80, '='));
_output.WriteLine(string.Empty);
_output.WriteLine("Output by day:");
LogResult(calculationResult, p => p.Date.ToString("dd.MM.yyyy"));
_output.WriteLine("".PadLeft(80, '='));
Assert.Equal(19, calculationResult.Count);
Assert.Equal(calculationResult, calculationResult.GroupBy.Day);
var result = calculationResult.GroupBy.Week;
_output.WriteLine("Output by week:");
LogResult(result, p => "KW " + (1 + (p.Date.DayOfYear - 1) / 7));
_output.WriteLine("".PadLeft(80, '='));
Assert.Equal(4, result.Count);
result = calculationResult.GroupBy.Month;
_output.WriteLine("Output by month:");
LogResult(result, p => p.Date.ToString("MMMM", new CultureInfo("de-DE")));
_output.WriteLine("".PadLeft(80, '='));
Assert.Single(result);
result = calculationResult.GroupBy.Year;
_output.WriteLine("Output by year:");
LogResult(result, p => p.Date.Year.ToString(CultureInfo.InvariantCulture));
_output.WriteLine("".PadLeft(80, '='));
Assert.Single(result);
}