public async Task EmployeesReportByDay_Generate_DoesGenerate()
{
OuterResource newArea = new OuterResource()
{
Name = "My OuterResource 1", Version = 1
};
OuterResource newArea1 = new OuterResource()
{
Name = "My OuterResource 2", Version = 1
};
OuterResource newArea2 = new OuterResource()
{
Name = "My OuterResource 3", Version = 1
};
InnerResource newMachine = new InnerResource()
{
Name = "My InnerResource 1", Version = 1
};
InnerResource newMachine1 = new InnerResource()
{
Name = "My InnerResource 2", Version = 1
};
InnerResource newMachine2 = new InnerResource()
{
Name = "My InnerResource 3", Version = 1
};
await newArea.Create(DbContext);
await newArea1.Create(DbContext);
await newArea2.Create(DbContext);
await newMachine.Create(DbContext);
await newMachine1.Create(DbContext);
await newMachine2.Create(DbContext);
// Different days
ResourceTimeRegistration newTimeRegistrationDay = new ResourceTimeRegistration()
{
OuterResourceId = newArea.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 13)
};
ResourceTimeRegistration newTimeRegistrationDay1 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 14)
};
ResourceTimeRegistration newTimeRegistrationDay2 = new ResourceTimeRegistration()
{
OuterResourceId = newArea2.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine2.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 15)
};
ResourceTimeRegistration newTimeRegistrationDay3 = new ResourceTimeRegistration()
{
OuterResourceId = newArea.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 13)
};
ResourceTimeRegistration newTimeRegistrationDay4 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 14)
};
ResourceTimeRegistration newTimeRegistrationDay5 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine2.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 15)
};
ResourceTimeRegistration newTimeRegistrationDay6 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 15)
};
await DbContext.ResourceTimeRegistrations.AddRangeAsync(newTimeRegistrationDay, newTimeRegistrationDay1,
newTimeRegistrationDay2, newTimeRegistrationDay3, newTimeRegistrationDay4, newTimeRegistrationDay5,
newTimeRegistrationDay6);
await DbContext.SaveChangesAsync();
GenerateReportModel model = new GenerateReportModel()
{
DateFrom = new DateTime(2019, 5, 13),
DateTo = new DateTime(2019, 5, 16),
Relationship = ReportRelationshipType.Employee,
Type = ReportType.Day
};
List <SiteDto> sitesList = new List <SiteDto>()
{
new SiteDto(1, "Test Site 1", "", "", 1, 1, 1, 1),
new SiteDto(2, "Test Site 2", "", "", 1, 1, 1, 1)
};
DateTime modelDateFrom = new DateTime(
model.DateFrom.Year,
model.DateFrom.Month,
model.DateFrom.Day,
0, 0, 0);
DateTime modelDateTo = new DateTime(
model.DateTo.Year,
model.DateTo.Month,
model.DateTo.Day,
23, 59, 59);
List <ResourceTimeRegistration> jobsList = await DbContext.ResourceTimeRegistrations
.Include(x => x.InnerResource)
.Include(x => x.OuterResource)
.Where(x => x.DoneAt >= modelDateFrom && x.DoneAt <= modelDateTo)
.ToListAsync();
ReportModel reportModel = ReportsHelper.GetReportData(model, jobsList, sitesList, (int)ReportTimeType.Minutes);
Assert.AreEqual(reportModel.SubReports.Count, 1);
Assert.AreEqual(reportModel.SubReports[0].TotalTime, 4200);
Assert.AreEqual(reportModel.SubReports[0].Entities.Count, sitesList.Count);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].EntityName, sitesList[0].SiteName);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].EntityName, sitesList[1].SiteName);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TotalTime, 1800);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].TotalTime, 2400);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[0], 600);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[1], 600);
}
public async Task <OperationDataResult <ReportModel> > GenerateReport(GenerateReportModel model)
{
try
{
var reportTimeType = _options.Value.ReportTimeType;
Core core = await _coreHelper.GetCore();
List <SiteDto> sitesList = await core.SiteReadAll(false);
DateTime modelDateFrom = new DateTime(
model.DateFrom.Year,
model.DateFrom.Month,
model.DateFrom.Day,
0, 0, 0);
DateTime modelDateTo = new DateTime(
model.DateTo.Year,
model.DateTo.Month,
model.DateTo.Day,
23, 59, 59);
// results to exclude
string outerResourceName = "";
OuterResource areaToExclude;
InnerResource machineToExclude;
string innerResourceName = "";
List <ResourceTimeRegistration> jobsList;
outerResourceName = _dbContext.PluginConfigurationValues.SingleOrDefault(x => x.Name == "OuterInnerResourceSettings:OuterTotalTimeName")?.Value;
areaToExclude = _dbContext.OuterResources.SingleOrDefaultAsync(x => x.Name == outerResourceName).Result;
innerResourceName = _dbContext.PluginConfigurationValues.SingleOrDefault(x => x.Name == "OuterInnerResourceSettings:InnerTotalTimeName")?.Value;
machineToExclude = await _dbContext.InnerResources.SingleOrDefaultAsync(x => x.Name == innerResourceName);
IQueryable <ResourceTimeRegistration> query = _dbContext.ResourceTimeRegistrations
.Include(x => x.InnerResource)
.Include(x => x.OuterResource);
if (areaToExclude != null && machineToExclude != null)
{
if (model.Relationship == ReportRelationshipType.EmployeeTotal)
{
query = query.Where(x =>
x.OuterResourceId == areaToExclude.Id && x.InnerResourceId == machineToExclude.Id);
}
else
{
query = query.Where(x =>
x.OuterResourceId != areaToExclude.Id && x.InnerResourceId != machineToExclude.Id);
}
}
else
{
query = query
.Where(x => x.DoneAt >= modelDateFrom && x.DoneAt <= modelDateTo);
}
jobsList = await query.ToListAsync();
ReportModel reportModel = ReportsHelper.GetReportData(model, jobsList, sitesList, reportTimeType);
return(new OperationDataResult <ReportModel>(true, reportModel));
}
catch (Exception e)
{
Trace.TraceError(e.Message);
_logger.LogError(e.Message);
return(new OperationDataResult <ReportModel>(false,
_outerInnerResourceLocalizationService.GetString("ErrorWhileGeneratingReport")));
}
}
public async Task EmployeesReportByMonth_Generate_DoesGenerate()
{
OuterResource newArea = new OuterResource()
{
Name = "My OuterResource 1", Version = 1
};
OuterResource newArea1 = new OuterResource()
{
Name = "My OuterResource 2", Version = 1
};
OuterResource newArea2 = new OuterResource()
{
Name = "My OuterResource 3", Version = 1
};
InnerResource newMachine = new InnerResource()
{
Name = "My InnerResource 1", Version = 1
};
InnerResource newMachine1 = new InnerResource()
{
Name = "My InnerResource 2", Version = 1
};
InnerResource newMachine2 = new InnerResource()
{
Name = "My InnerResource 3", Version = 1
};
await newArea.Create(DbContext);
await newArea1.Create(DbContext);
await newArea2.Create(DbContext);
await newMachine.Create(DbContext);
await newMachine1.Create(DbContext);
await newMachine2.Create(DbContext);
// Different Month
ResourceTimeRegistration newTimeRegistrationMonth = new ResourceTimeRegistration()
{
OuterResourceId = newArea.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 06, 13)
};
ResourceTimeRegistration newTimeRegistrationMonth1 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 07, 14)
};
ResourceTimeRegistration newTimeRegistrationMonth2 = new ResourceTimeRegistration()
{
OuterResourceId = newArea2.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine2.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 07, 15)
};
ResourceTimeRegistration newTimeRegistrationMonth3 = new ResourceTimeRegistration()
{
OuterResourceId = newArea.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 08, 13)
};
ResourceTimeRegistration newTimeRegistrationMonth4 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 08, 14)
};
ResourceTimeRegistration newTimeRegistrationMonth5 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine2.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 09, 15)
};
ResourceTimeRegistration newTimeRegistrationMonth6 = new ResourceTimeRegistration()
{
OuterResourceId = newArea1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 09, 15)
};
await DbContext.ResourceTimeRegistrations.AddRangeAsync(newTimeRegistrationMonth, newTimeRegistrationMonth1,
newTimeRegistrationMonth2, newTimeRegistrationMonth3, newTimeRegistrationMonth4, newTimeRegistrationMonth5,
newTimeRegistrationMonth6);
await DbContext.SaveChangesAsync();
GenerateReportModel model = new GenerateReportModel()
{
DateFrom = new DateTime(2019, 5, 13),
DateTo = new DateTime(2019, 9, 13),
Relationship = ReportRelationshipType.Employee,
Type = ReportType.Month
};
List <SiteDto> sitesList = new List <SiteDto>()
{
// new SiteDto(1, "Test Site 1", "", "", 1, 1, 1, 1),
new SiteDto()
{
CustomerNo = 1,
Email = "bla",
FirstName = "Test",
LastName = "Site 1",
OtpCode = 1,
SiteId = 1,
SiteName = "Test Site 1",
UnitId = 1,
WorkerUid = 1
},
// new SiteDto(2, "Test Site 2", "", "", 1, 1, 1, 1)
new SiteDto()
{
CustomerNo = 1,
Email = "bla",
FirstName = "Test",
LastName = "Site 2",
OtpCode = 1,
SiteId = 2,
SiteName = "Test Site 2",
UnitId = 1,
WorkerUid = 1
}
};
DateTime modelDateFrom = new DateTime(
model.DateFrom.Year,
model.DateFrom.Month,
model.DateFrom.Day,
0, 0, 0);
DateTime modelDateTo = new DateTime(
model.DateTo.Year,
model.DateTo.Month,
model.DateTo.Day,
23, 59, 59);
List <ResourceTimeRegistration> jobsList = await DbContext.ResourceTimeRegistrations
.Include(x => x.InnerResource)
.Include(x => x.OuterResource)
.Where(x => x.DoneAt >= modelDateFrom && x.DoneAt <= modelDateTo)
.ToListAsync();
ReportModel reportModel = ReportsHelper.GetReportData(model, jobsList, sitesList, (int)ReportTimeType.Minutes);
Assert.AreEqual(reportModel.SubReports.Count, 1);
Assert.AreEqual(reportModel.SubReports[0].TotalTime, 3000);
Assert.AreEqual(reportModel.SubReports[0].Entities.Count, sitesList.Count);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].EntityName, sitesList[0].SiteName);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].EntityName, sitesList[1].SiteName);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TotalTime, 1800);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].TotalTime, 1200);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[0], 0);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[1], 600);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[2], 1200);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[3], 0);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[4], 0);
}
public async Task OuterResourcesReportByWeek_Generate_DoesGenerate()
{
OuterResource newOuterResource = new OuterResource()
{
Name = "My OuterResource 1", Version = 1
};
OuterResource newOuterResource1 = new OuterResource()
{
Name = "My OuterResource 2", Version = 1
};
OuterResource newOuterResource2 = new OuterResource()
{
Name = "My OuterResource 3", Version = 1
};
InnerResource newMachine = new InnerResource()
{
Name = "My InnerResource 1", Version = 1
};
InnerResource newMachine1 = new InnerResource()
{
Name = "My InnerResource 2", Version = 1
};
InnerResource newMachine2 = new InnerResource()
{
Name = "My InnerResource 3", Version = 1
};
await newOuterResource.Create(DbContext);
await newOuterResource1.Create(DbContext);
await newOuterResource2.Create(DbContext);
await newMachine.Create(DbContext);
await newMachine1.Create(DbContext);
await newMachine2.Create(DbContext);
// Different Weeks
ResourceTimeRegistration newTimeRegistrationWeek = new ResourceTimeRegistration()
{
OuterResourceId = newOuterResource.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 20)
};
ResourceTimeRegistration newTimeRegistrationWeek1 = new ResourceTimeRegistration()
{
OuterResourceId = newOuterResource1.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 20)
};
ResourceTimeRegistration newTimeRegistrationWeek2 = new ResourceTimeRegistration()
{
OuterResourceId = newOuterResource2.Id, Version = 1, SDKSiteId = 1, InnerResourceId = newMachine2.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 05, 27)
};
ResourceTimeRegistration newTimeRegistrationWeek3 = new ResourceTimeRegistration()
{
OuterResourceId = newOuterResource.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 06, 27)
};
ResourceTimeRegistration newTimeRegistrationWeek4 = new ResourceTimeRegistration()
{
OuterResourceId = newOuterResource1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 06, 05)
};
ResourceTimeRegistration newTimeRegistrationWeek5 = new ResourceTimeRegistration()
{
OuterResourceId = newOuterResource1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine2.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 06, 05)
};
ResourceTimeRegistration newTimeRegistrationWeek6 = new ResourceTimeRegistration()
{
OuterResourceId = newOuterResource1.Id, Version = 1, SDKSiteId = 2, InnerResourceId = newMachine1.Id, TimeInSeconds = 36000, DoneAt = new DateTime(2019, 06, 06)
};
await DbContext.ResourceTimeRegistrations.AddRangeAsync(newTimeRegistrationWeek, newTimeRegistrationWeek1,
newTimeRegistrationWeek2, newTimeRegistrationWeek3, newTimeRegistrationWeek4, newTimeRegistrationWeek5,
newTimeRegistrationWeek6);
await DbContext.SaveChangesAsync();
GenerateReportModel model = new GenerateReportModel()
{
DateFrom = new DateTime(2019, 5, 13),
DateTo = new DateTime(2019, 6, 07),
Relationship = ReportRelationshipType.OuterResource,
Type = ReportType.Week
};
List <SiteDto> sitesList = new List <SiteDto>()
{
new SiteDto(1, "Test Site 1", "", "", 1, 1, 1, 1),
new SiteDto(2, "Test Site 2", "", "", 1, 1, 1, 1)
};
DateTime modelDateFrom = new DateTime(
model.DateFrom.Year,
model.DateFrom.Month,
model.DateFrom.Day,
0, 0, 0);
DateTime modelDateTo = new DateTime(
model.DateTo.Year,
model.DateTo.Month,
model.DateTo.Day,
23, 59, 59);
List <ResourceTimeRegistration> jobsList = await DbContext.ResourceTimeRegistrations
.Include(x => x.InnerResource)
.Include(x => x.OuterResource)
.Where(x => x.DoneAt >= modelDateFrom && x.DoneAt <= modelDateTo)
.ToListAsync();
ReportModel reportModel = ReportsHelper.GetReportData(model, jobsList, sitesList, (int)ReportTimeType.Minutes);
Assert.AreEqual(reportModel.SubReports.Count, 1);
Assert.AreEqual(reportModel.SubReports[0].TotalTime, 3600);
Assert.AreEqual(reportModel.SubReports[0].Entities.Count, 3);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].EntityName, newOuterResource.Name);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].EntityName, newOuterResource1.Name);
Assert.AreEqual(reportModel.SubReports[0].Entities[2].EntityName, newOuterResource2.Name);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TotalTime, 600);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].TotalTime, 2400);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[0], 0);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[1], 600);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[2], 0);
Assert.AreEqual(reportModel.SubReports[0].Entities[0].TimePerTimeUnit[3], 0);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].TimePerTimeUnit[0], 0);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].TimePerTimeUnit[1], 600);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].TimePerTimeUnit[2], 0);
Assert.AreEqual(reportModel.SubReports[0].Entities[1].TimePerTimeUnit[3], 1800);
}