public async Task <ActionResult <CourseExercisesStatisticsResponse> > CourseStatistics([FromQuery(Name = "course_id")][BindRequired]
string courseId, int count = 10000, DateTime?from = null, DateTime?to = null)
{
var course = await courseManager.FindCourseAsync(courseId);
if (course == null)
{
return(NotFound());
}
if (!from.HasValue)
{
from = DateTime.MinValue;
}
if (!to.HasValue)
{
to = DateTime.MaxValue;
}
count = Math.Min(count, 10000);
var isInstructor = await courseRolesRepo.HasUserAccessToCourse(UserId, course.Id, CourseRoleType.Instructor).ConfigureAwait(false);
var exerciseSlides = course.GetSlides(isInstructor).OfType <ExerciseSlide>().ToList();
/* TODO (andgein): I can't select all submissions because ApplicationUserId column doesn't exist in database (ApplicationUser_Id exists).
* We should remove this column after EF Core 2.1 release (and remove tuples here)
*/
var submissions = await userSolutionsRepo.GetAllSubmissions(course.Id, includeManualAndAutomaticCheckings : false)
.Where(s => s.Timestamp >= from && s.Timestamp <= to)
.OrderByDescending(s => s.Timestamp)
.Take(count)
.Select(s => Tuple.Create(s.SlideId, s.AutomaticCheckingIsRightAnswer, s.Timestamp))
.ToListAsync().ConfigureAwait(false);
var getSlideMaxScoreFunc = await BuildGetSlideMaxScoreFunc(solutionsRepo, userQuizzesRepo, visitsRepo, groupsRepo, course, User.GetUserId());
var getGitEditLinkFunc = await BuildGetGitEditLinkFunc(User.GetUserId(), course, courseRolesRepo, coursesRepo);
const int daysLimit = 30;
var result = new CourseExercisesStatisticsResponse
{
AnalyzedSubmissionsCount = submissions.Count,
Exercises = exerciseSlides.Select(
slide =>
{
/* Statistics for this exercise slide: */
var exerciseSubmissions = submissions.Where(s => s.Item1 == slide.Id).ToList();
return(new OneExerciseStatistics
{
Exercise = slideRenderer.BuildShortSlideInfo(course.Id, slide, getSlideMaxScoreFunc, getGitEditLinkFunc, Url),
SubmissionsCount = exerciseSubmissions.Count,
AcceptedCount = exerciseSubmissions.Count(s => s.Item2),
/* Select last 30 (`datesLimit`) dates */
LastDates = exerciseSubmissions.GroupBy(s => s.Item3.Date).OrderByDescending(g => g.Key).Take(daysLimit).ToDictionary(
/* Date: */
g => g.Key,
/* Statistics for this date: */
g => new OneExerciseStatisticsForDate
{
SubmissionsCount = g.Count(),
AcceptedCount = g.Count(s => s.Item2)
}
)
});
}).ToList()
};
return(result);
}
public async Task <ActionResult <CourseExercisesStatisticsResponse> > CourseStatistics(Course course, int count = 10000, DateTime?from = null, DateTime?to = null)
{
if (course == null)
{
return(NotFound());
}
if (!from.HasValue)
{
from = DateTime.MinValue;
}
if (!to.HasValue)
{
to = DateTime.MaxValue;
}
count = Math.Min(count, 10000);
var exerciseSlides = course.Slides.OfType <ExerciseSlide>().ToList();
/* TODO (andgein): I can't select all submissions because ApplicationUserId column doesn't exist in database (ApplicationUser_Id exists).
* We should remove this column after EF Core 2.1 release (and remove tuples here)
*/
var submissions = await userSolutionsRepo.GetAllSubmissions(course.Id, includeManualCheckings : false)
.Where(s => s.Timestamp >= from && s.Timestamp <= to)
.OrderByDescending(s => s.Timestamp)
.Take(count)
.Select(s => Tuple.Create(s.SlideId, s.AutomaticCheckingIsRightAnswer, s.Timestamp))
.ToListAsync().ConfigureAwait(false);
const int daysLimit = 30;
var result = new CourseExercisesStatisticsResponse
{
AnalyzedSubmissionsCount = submissions.Count,
Exercises = exerciseSlides.Select(
slide =>
{
/* Statistics for this exercise slide: */
var exerciseSubmissions = submissions.Where(s => s.Item1 == slide.Id).ToList();
return(new OneExerciseStatistics
{
Exercise = BuildSlideInfo(course.Id, slide),
SubmissionsCount = exerciseSubmissions.Count,
AcceptedCount = exerciseSubmissions.Count(s => s.Item2),
/* Select last 30 (`datesLimit`) dates */
LastDates = exerciseSubmissions.GroupBy(s => s.Item3.Date).OrderByDescending(g => g.Key).Take(daysLimit).ToDictionary(
/* Date: */
g => g.Key,
/* Statistics for this date: */
g => new OneExerciseStatisticsForDate
{
SubmissionsCount = g.Count(),
AcceptedCount = g.Count(s => s.Item2)
}
)
});
}).ToList()
};
return(result);
}