| | | 1 | | namespace Syki.Back.Features.Student.GetStudentFrequencies; |
| | | 2 | | |
| | 6 | 3 | | public class GetStudentFrequenciesService(SykiDbContext ctx) : IStudentService |
| | | 4 | | { |
| | | 5 | | public async Task<OneOf<List<GetStudentFrequenciesOut>, ErrorOut>> Get(Guid userId, Guid courseCurriculumId) |
| | | 6 | | { |
| | 6 | 7 | | var attendances = await ctx.Attendances.AsNoTracking().Where(x => x.StudentId == userId).ToListAsync(); |
| | | 8 | | |
| | 32 | 9 | | var classIds = attendances.Select(x => x.ClassId).Distinct(); |
| | 6 | 10 | | var classes = await ctx.Classes.AsNoTracking() |
| | 6 | 11 | | .Include(g => g.Discipline) |
| | 6 | 12 | | .Where(x => classIds.Contains(x.Id)) |
| | 6 | 13 | | .ToListAsync(); |
| | | 14 | | |
| | 20 | 15 | | var disciplineIds = classes.Select(x => x.DisciplineId); |
| | 6 | 16 | | var disciplines = await ctx.CourseCurriculumDisciplines.AsNoTracking() |
| | 6 | 17 | | .Where(x => x.CourseCurriculumId == courseCurriculumId && disciplineIds.Contains(x.DisciplineId)) |
| | 6 | 18 | | .ToListAsync(); |
| | | 19 | | |
| | 6 | 20 | | var classesStudents = await ctx.ClassesStudents.AsNoTracking() |
| | 6 | 21 | | .Where(x => x.SykiStudentId == userId).ToListAsync(); |
| | | 22 | | |
| | 6 | 23 | | var result = new List<GetStudentFrequenciesOut>(); |
| | 40 | 24 | | foreach (var item in classes) |
| | | 25 | | { |
| | 58 | 26 | | var period = disciplines.First(x => x.DisciplineId == item.DisciplineId).Period.ToString(); |
| | 160 | 27 | | var lessons = attendances.Count(x => x.ClassId == item.Id); |
| | 160 | 28 | | var presences = attendances.Count(x => x.ClassId == item.Id && x.Present); |
| | 58 | 29 | | var status = classesStudents.First(s => s.ClassId == item.Id).StudentDisciplineStatus; |
| | 14 | 30 | | result.Add(new(item.Discipline.Name, period, lessons, presences, status)); |
| | | 31 | | } |
| | | 32 | | |
| | 30 | 33 | | return result.OrderBy(x => x.Period).ThenBy(x => x.Name).ToList(); |
| | 6 | 34 | | } |
| | | 35 | | } |