def new(self, format='html'):
"""GET /substitutions/new: Form to create a new item"""
# url('new_substitution')
c.date = self._closest_working_day(datetime.date.today())
c.groups = Session.query(Group).join(Group.year).\
order_by(desc(SchoolYear.start), Group.name).all()
c.educators = Session.query(Educator).\
order_by(Educator.last_name).all()
c.year = SchoolYear.current()
return render('substitutions/new.xml')
def new(self, format='html'):
"""GET /substitutions/new: Form to create a new item"""
# url('new_substitution')
c.date = self._closest_working_day(datetime.date.today())
c.groups = Session.query(Group).join(Group.year).\
order_by(desc(SchoolYear.start), Group.name).all()
c.educators = Session.query(Educator).\
order_by(Educator.last_name).all()
c.year = SchoolYear.current()
return render('substitutions/new.xml')
def parse(self):
# Retrieve schoolyear's start/end dates
meta = self.lines.pop(0).strip()
try:
start_str, end_str = meta[1:].split('-')
start = datetime.datetime.strptime(start_str, '%d.%m.%Y')
end = datetime.datetime.strptime(end_str, '%d.%m.%Y')
except ValueError:
raise ParserError("""Metadata line is not valid.""")
self.year = SchoolYear(start, end)
super(StudentsParser, self).parse()
self.post_parse()
def left(cls):
"""
Get left lucky numbers, not used before, sorted.
"""
student_count = func.count(Student.id).label('student_count')
recent_years = [sy.id for sy in SchoolYear.recent()]
stmt = Session.query(student_count, Student).\
join(GroupMembership).\
join(Group).group_by(Group.id).\
filter(Group.year_id.in_(recent_years)).subquery()
max = Session.query(func.max(stmt.c.student_count)).first()[0]
count = Session.query(func.count(LuckyNumber.id)).first()[0]
past = Session.query(LuckyNumber.number).\
order_by(desc(LuckyNumber.date)).\
limit(count % max).all()
all = set(range(1, max + 1))
past = set(x[0] for x in past)
left = list(all.difference(past))
left.sort()
return left
def table(self, date=None):
"""
Create a table of substitutions.
This action tries to recreate table view as based on
http://www.staszic.edu.pl/zastepstwa/.
It gathers following data:
1. Which lessons do the group ussually have?
2. Which lessons do groups have in substitution?
3. Which groups (parts) are released (freed from the lesson)
"""
if date is None:
date = self._closest_working_day(datetime.datetime.today()).date()
else:
date = datetime.datetime.strptime(date, '%Y-%m-%d').date()
# Fetch substitutions from database
q = Session.query(Substitution).filter_by(date=date)
# Filter out pointless substitutions (those, which have both
# parts set as False - no part is set)
q = q.filter(
not_(and_(Substitution.part1 == False,
Substitution.part2 == False)))
subs = q.all()
# Create a dictionary of educators and their lessons by schedule
# (before) and the new ones which are substitutes (after).
before = {}
after = {}
# Create released groups dict:
# keys are lesson orders and value is the list of released groups
released = {}
def fill(d, educator, order, fill):
"""
Helper function for filling the dict.
It tries to fill as less data as possible so
it merges parts intro groups.
"""
if not d.has_key(educator):
d[educator] = {}
e = d[educator]
if not e.has_key(order):
e[order] = []
o = e[order]
g = fill[0]
p = fill[1]
if (g, None) in o:
# We are trying to append part whereas entire group is present
return
if p is None:
# We are appending entire group, delete "parted" entries
for x in [1, 2]:
try:
o.remove((g, x))
except ValueError:
pass
o.append(fill)
def opposite_substituted(subs, sub):
"""
Helper function for checking whether opposite group
has been already substituted or the scheduled teacher
is having a substituion which stops him from keeping
the opposite group.
It return True when both conditions are met:
1. Opposite group doesn't have any substituion on that hour and,
2. Scheduled teacher doesn't have any substition with other group.
"""
SUBSTITUTED = False
EDUCATOR_FREE = True
opposite_part = sub.part % 2 + 1
for s in subs:
if s.order != sub.order:
# We want only the same lesson order
continue
if s.group == sub.group and s.part == opposite_part:
SUBSTITUTED = True
break
if s.teacher == lesson.teacher:
EDUCATOR_FREE = False
if not SUBSTITUTED and EDUCATOR_FREE:
return True
else:
return False
class ReleasedGroup(Exception):
pass
# Loop the substitutions
for sub in subs:
if sub.teacher is None:
# Group is released
for lesson in sub.group_lesson():
fill(before, lesson.teacher, lesson.order,
(lesson.group, lesson.part))
if sub.part is not None and \
opposite_substituted(subs, sub):
fill(after, lesson.teacher, lesson.order,
(lesson.group, sub.part % 2 + 1))
if not released.has_key(sub.order):
released[sub.order] = []
released[sub.order].append((sub.group, sub.part))
continue
# What lesson does the group have normally?
# And with which educator it is?
for lesson in sub.group_lesson():
fill(before, lesson.teacher, lesson.order,
(lesson.group, lesson.part))
if lesson.part is None and sub.part is not None:
if opposite_substituted(subs, sub):
fill(after, lesson.teacher, lesson.order,
(lesson.group, sub.part % 2 + 1))
for lesson in sub.teacher_lesson():
fill(after, lesson.teacher, lesson.order,
(lesson.group, lesson.part))
fill(after, sub.teacher, sub.order, (sub.group, sub.part))
c.debug = ("Substitutions for %s:\nbefore:\t\t%r\nafter:\t\t%r\n" + \
"released:\t%r") % (date, before, after, released)
c.year = SchoolYear.current()
c.date = date
c.before = before
c.after = after
c.released = released
return render('substitutions/table.xml')
def table(self, date=None):
"""
Create a table of substitutions.
This action tries to recreate table view as based on
http://www.staszic.edu.pl/zastepstwa/.
It gathers following data:
1. Which lessons do the group ussually have?
2. Which lessons do groups have in substitution?
3. Which groups (parts) are released (freed from the lesson)
"""
if date is None:
date = self._closest_working_day(datetime.datetime.today()).date()
else:
date = datetime.datetime.strptime(date, '%Y-%m-%d').date()
# Fetch substitutions from database
q = Session.query(Substitution).filter_by(date=date)
# Filter out pointless substitutions (those, which have both
# parts set as False - no part is set)
q = q.filter(not_(and_(Substitution.part1 == False,
Substitution.part2 == False)))
subs = q.all()
# Create a dictionary of educators and their lessons by schedule
# (before) and the new ones which are substitutes (after).
before = {}
after = {}
# Create released groups dict:
# keys are lesson orders and value is the list of released groups
released = {}
def fill(d, educator, order, fill):
"""
Helper function for filling the dict.
It tries to fill as less data as possible so
it merges parts intro groups.
"""
if not d.has_key(educator):
d[educator] = {}
e = d[educator]
if not e.has_key(order):
e[order] = []
o = e[order]
g = fill[0]
p = fill[1]
if (g, None) in o:
# We are trying to append part whereas entire group is present
return
if p is None:
# We are appending entire group, delete "parted" entries
for x in [1, 2]:
try:
o.remove((g, x))
except ValueError:
pass
o.append(fill)
def opposite_substituted(subs, sub):
"""
Helper function for checking whether opposite group
has been already substituted or the scheduled teacher
is having a substituion which stops him from keeping
the opposite group.
It return True when both conditions are met:
1. Opposite group doesn't have any substituion on that hour and,
2. Scheduled teacher doesn't have any substition with other group.
"""
SUBSTITUTED = False
EDUCATOR_FREE = True
opposite_part = sub.part % 2 + 1
for s in subs:
if s.order != sub.order:
# We want only the same lesson order
continue
if s.group == sub.group and s.part == opposite_part:
SUBSTITUTED = True
break
if s.teacher == lesson.teacher:
EDUCATOR_FREE = False
if not SUBSTITUTED and EDUCATOR_FREE:
return True
else:
return False
class ReleasedGroup(Exception):
pass
# Loop the substitutions
for sub in subs:
if sub.teacher is None:
# Group is released
for lesson in sub.group_lesson():
fill(before, lesson.teacher, lesson.order,
(lesson.group, lesson.part))
if sub.part is not None and \
opposite_substituted(subs, sub):
fill(after, lesson.teacher, lesson.order,
(lesson.group, sub.part % 2 + 1))
if not released.has_key(sub.order):
released[sub.order] = []
released[sub.order].append((sub.group, sub.part))
continue
# What lesson does the group have normally?
# And with which educator it is?
for lesson in sub.group_lesson():
fill(before, lesson.teacher, lesson.order,
(lesson.group, lesson.part))
if lesson.part is None and sub.part is not None:
if opposite_substituted(subs, sub):
fill(after, lesson.teacher, lesson.order,
(lesson.group, sub.part % 2 + 1))
for lesson in sub.teacher_lesson():
fill(after, lesson.teacher, lesson.order,
(lesson.group, lesson.part))
fill(after, sub.teacher, sub.order, (sub.group, sub.part))
c.debug = ("Substitutions for %s:\nbefore:\t\t%r\nafter:\t\t%r\n" + \
"released:\t%r") % (date, before, after, released)
c.year = SchoolYear.current()
c.date = date
c.before = before
c.after = after
c.released = released
return render('substitutions/table.xml')
