def group_week(self, group_name, course_name=None):
"""
Render group's schedule for entire week.
:param group_name: Full name of the group (including year index)
:pram course_name: Optional name of the course
"""
schedule = Schedule.current()
group = Group.by_full_name(group_name)
if group is None:
c.group_name = group_name
return render('schedule/group/not_found.xml')
gs = group.schedule(schedule.id)
# Fetch the course schedule and merge it with group schedule
if course_name is not None:
course = Group.by_full_name(group_name[0] + course_name)
c.course = course
if course is None:
c.group_name = group_name[0] + course_name
return render('schedule/group/not_found.xml')
else:
cs = course.schedule(schedule.id)
if cs is not None:
for day_number, day in enumerate(cs):
for order, lesson in enumerate(day):
while len(gs[day_number]) < order + 1:
gs[day_number].append(None)
if gs[day_number][order] is None:
gs[day_number][order] = lesson
else:
c.course = None
c.courses = None
if len(group_name) != 2:
# group is not course
from sqlalchemy import func
q = Group.query_active().filter(Group.year_id == group.year_id).\
filter(func.length(Group.name) == 1).\
order_by(Group.name)
c.courses = q.all()
c.group = group
c.group_name = group_name
c.year = schedule.year
c.schedule = gs
return render('schedule/group/week.xml')
def group_week(self, group_name, course_name=None):
"""
Render group's schedule for entire week.
:param group_name: Full name of the group (including year index)
:pram course_name: Optional name of the course
"""
schedule = Schedule.current()
group = Group.by_full_name(group_name)
if group is None:
c.group_name = group_name
return render('schedule/group/not_found.xml')
gs = group.schedule(schedule.id)
# Fetch the course schedule and merge it with group schedule
if course_name is not None:
course = Group.by_full_name(group_name[0]+course_name)
c.course = course
if course is None:
c.group_name = group_name[0]+course_name
return render('schedule/group/not_found.xml')
else:
cs = course.schedule(schedule.id)
if cs is not None:
for day_number, day in enumerate(cs):
for order, lesson in enumerate(day):
while len(gs[day_number]) < order + 1:
gs[day_number].append(None)
if gs[day_number][order] is None:
gs[day_number][order] = lesson
else:
c.course = None
c.courses = None
if len(group_name) != 2:
# group is not course
from sqlalchemy import func
q = Group.query_active().filter(Group.year_id == group.year_id).\
filter(func.length(Group.name) == 1).\
order_by(Group.name)
c.courses = q.all()
c.group = group
c.group_name = group_name
c.year = schedule.year
c.schedule = gs
return render('schedule/group/week.xml')
def groups(self):
"""
Render full currently active groups schedule
(every group and every weekday).
"""
schedule = Schedule.current()
q = Group.query_active(schedule_id=schedule.id).\
join((SchoolYear, Group.year_id == SchoolYear.id)).\
order_by(desc(SchoolYear.start), Group.name)
groups = []
for g in q.all():
s = g.schedule(schedule.id)
groups.append((g, s))
c.year = schedule.year
c.groups = groups
return render('schedule/group/full_table.xml')
def groups(self):
"""
Render full currently active groups schedule
(every group and every weekday).
"""
schedule = Schedule.current()
q = Group.query_active(schedule_id=schedule.id).\
join((SchoolYear, Group.year_id == SchoolYear.id)).\
order_by(desc(SchoolYear.start), Group.name)
groups = []
for g in q.all():
s = g.schedule(schedule.id)
groups.append((g, s))
c.year = schedule.year
c.groups = groups
return render('schedule/group/full_table.xml')
def index(self):
"""
Render schedule management control panel. Handle POST redirects.
"""
day = request.params.get('day', None)
group_name = request.params.get('group_name', None)
course_name = request.params.get('course_name', None)
teacher_last_name = request.params.get('teacher_last_name', None)
if group_name is not None:
if course_name is not None:
if day == 'week':
redirect(
url('schedule_group_course_week',
group_name=group_name,
course_name=course_name))
elif day is not None:
redirect(
url('schedule_group_course',
day_name=day,
group_name=group_name,
course_name=course_name))
else:
redirect(
url('schedule_group_course_today',
group_name=group_name,
course_name=course_name))
else:
if day == 'week':
redirect(url('schedule_group_week', group_name=group_name))
elif day is not None:
redirect(
url('schedule_group',
day_name=day,
group_name=group_name))
else:
redirect(url('schedule_group_today',
group_name=group_name))
if teacher_last_name is not None:
if day == 'week':
redirect(
url('schedule_teacher_week',
teacher_name=teacher_last_name))
elif day is not None:
redirect(
url('schedule_teacher',
day_name=day,
teacher_name=request.params.get('teacher_last_name')))
else:
redirect(
url('schedule_teacher_today',
teacher_name=request.params.get('teacher_last_name')))
schedule = Schedule.current()
c.year = schedule.year
groups = Group.query_active(schedule.id).\
join((SchoolYear, Group.year_id == SchoolYear.id)).\
order_by(desc(SchoolYear.start), Group.name).all()
courses = []
classes = []
for g in groups:
if len(g.name) == 1 and g.name not in courses:
courses.append(g.name)
elif len(g.name) != 1 and g.name not in classes:
classes.append(g.full_name(schedule.year))
courses.sort()
classes.sort()
teachers = Educator.query_active(schedule.id).\
order_by(Educator.last_name).all()
c.groups = groups
c.courses = courses
c.classes = classes
c.teachers = teachers
return render('schedule/index.xml')
def index(self):
"""
Render schedule management control panel. Handle POST redirects.
"""
day = request.params.get('day', None)
group_name = request.params.get('group_name', None)
course_name = request.params.get('course_name', None)
teacher_last_name = request.params.get('teacher_last_name', None)
if group_name is not None:
if course_name is not None:
if day == 'week':
redirect(url('schedule_group_course_week',
group_name=group_name, course_name=course_name))
elif day is not None:
redirect(url('schedule_group_course', day_name=day,
group_name=group_name, course_name=course_name))
else:
redirect(url('schedule_group_course_today',
group_name=group_name, course_name=course_name))
else:
if day == 'week':
redirect(url('schedule_group_week', group_name=group_name))
elif day is not None:
redirect(url('schedule_group', day_name=day,
group_name=group_name))
else:
redirect(url('schedule_group_today',
group_name=group_name))
if teacher_last_name is not None:
if day == 'week':
redirect(url('schedule_teacher_week',
teacher_name=teacher_last_name))
elif day is not None:
redirect(url('schedule_teacher', day_name=day,
teacher_name=request.params.get('teacher_last_name')))
else:
redirect(url('schedule_teacher_today',
teacher_name=request.params.get('teacher_last_name')))
schedule = Schedule.current()
c.year = schedule.year
groups = Group.query_active(schedule.id).\
join((SchoolYear, Group.year_id == SchoolYear.id)).\
order_by(desc(SchoolYear.start), Group.name).all()
courses = []
classes = []
for g in groups:
if len(g.name) == 1 and g.name not in courses:
courses.append(g.name)
elif len(g.name) != 1 and g.name not in classes:
classes.append(g.full_name(schedule.year))
courses.sort()
classes.sort()
teachers = Educator.query_active(schedule.id).\
order_by(Educator.last_name).all()
c.groups = groups
c.courses = courses
c.classes = classes
c.teachers = teachers
return render('schedule/index.xml')
