| | | 1 | | namespace Syki.Back.Features.Academic.GetAcademicClasses; |
| | | 2 | | |
| | 8 | 3 | | public class GetAcademicClassesService(SykiDbContext ctx) : IAcademicService |
| | | 4 | | { |
| | | 5 | | public async Task<List<ClassOut>> Get(Guid institutionId, GetAcademicClassesIn query) |
| | | 6 | | { |
| | 8 | 7 | | var classes = await ctx.Classes.AsNoTracking() |
| | 8 | 8 | | .Include(t => t.Discipline) |
| | 8 | 9 | | .Include(t => t.Teacher) |
| | 8 | 10 | | .Include(t => t.Schedules) |
| | 8 | 11 | | .Include(t => t.Lessons) |
| | 8 | 12 | | .ThenInclude(l => l.Attendances) |
| | 8 | 13 | | .Where(c => c.InstitutionId == institutionId) |
| | 8 | 14 | | .ToListAsync(); |
| | | 15 | | |
| | 8 | 16 | | var periods = await ctx.EnrollmentPeriods.AsNoTracking().Where(x => x.InstitutionId == institutionId).ToListAsyn |
| | | 17 | | |
| | 16 | 18 | | var ids = classes.ConvertAll(x => x.Id); |
| | 8 | 19 | | var links = await ctx.ClassesStudents.AsNoTracking().Where(x => ids.Contains(x.ClassId)).ToListAsync(); |
| | 32 | 20 | | foreach (var @class in classes) |
| | | 21 | | { |
| | 10 | 22 | | var count = links.Count(x => x.ClassId == @class.Id); |
| | 8 | 23 | | @class.SetFillRatio(count); |
| | | 24 | | |
| | 12 | 25 | | var period = periods.FirstOrDefault(x => x.Id == @class.PeriodId); |
| | 8 | 26 | | if (@class.Status == ClassStatus.OnEnrollment && period?.EndAt < DateTime.UtcNow.ToDateOnly()) |
| | | 27 | | { |
| | 2 | 28 | | @class.Status = ClassStatus.AwaitingStart; |
| | | 29 | | } |
| | | 30 | | } |
| | | 31 | | |
| | 8 | 32 | | var status = query?.Status ?? null; |
| | 22 | 33 | | return classes.Where(x => status == null || x.Status == status).Select(t => t.ToOut()).ToList(); |
| | 8 | 34 | | } |
| | | 35 | | } |