| | | 1 | | namespace Syki.Back.Features.Student.GetStudentClassFrequency; |
| | | 2 | | |
| | 0 | 3 | | public class GetStudentClassFrequencyService(SykiDbContext ctx) : IStudentService |
| | | 4 | | { |
| | | 5 | | public async Task<OneOf<GetStudentClassFrequencyOut, SykiError>> Get(Guid studentId, Guid classId) |
| | | 6 | | { |
| | 0 | 7 | | var classOk = await ctx.ClassesStudents.AnyAsync(x => x.ClassId == classId && x.SykiStudentId == studentId); |
| | 0 | 8 | | if (!classOk) return new ClassNotFound(); |
| | | 9 | | |
| | 0 | 10 | | var lessons = await ctx.Lessons.AsNoTracking() |
| | 0 | 11 | | .Where(x => x.ClassId == classId) |
| | 0 | 12 | | .OrderBy(x => x.Number) |
| | 0 | 13 | | .ToListAsync(); |
| | | 14 | | |
| | 0 | 15 | | var attendances = await ctx.Attendances.AsNoTracking().Where(x => x.ClassId == classId && x.StudentId == student |
| | 0 | 16 | | var presences = attendances.Count(x => x.Present); |
| | 0 | 17 | | var absences = attendances.Count - presences; |
| | | 18 | | |
| | 0 | 19 | | var lessonsOut = new List<GetStudentClassLessonFrequencyOut>(); |
| | 0 | 20 | | foreach (var lesson in lessons) |
| | | 21 | | { |
| | 0 | 22 | | var attendance = attendances.FirstOrDefault(x => x.LessonId == lesson.Id); |
| | 0 | 23 | | lessonsOut.Add(new() |
| | 0 | 24 | | { |
| | 0 | 25 | | Lesson = lesson.Number, |
| | 0 | 26 | | Frequency = attendance == null ? 0.50M : attendance.Present ? 1 : 0, |
| | 0 | 27 | | LessonDate = $"{lesson.Date} {lesson.StartAt.GetDescription()}-{lesson.EndAt.GetDescription()}" |
| | 0 | 28 | | }); |
| | | 29 | | } |
| | | 30 | | |
| | 0 | 31 | | if (attendances.Count == 0) return new GetStudentClassFrequencyOut { TotalLessons = lessons.Count, Lessons = les |
| | | 32 | | |
| | 0 | 33 | | var frequency = Math.Round(100M*(1M * presences / (1M * attendances.Count)), 2); |
| | | 34 | | |
| | 0 | 35 | | return new GetStudentClassFrequencyOut |
| | 0 | 36 | | { |
| | 0 | 37 | | Frequency = frequency, |
| | 0 | 38 | | Presences = presences, |
| | 0 | 39 | | Attendances = attendances.Count, |
| | 0 | 40 | | Absences = absences, |
| | 0 | 41 | | TotalLessons = lessons.Count, |
| | 0 | 42 | | Lessons = lessonsOut, |
| | 0 | 43 | | }; |
| | 0 | 44 | | } |
| | | 45 | | } |