import itertools

from django.db.models import Count, Min

from symposion.schedule.models import Room, Slot, SlotRoom

class TimeTable(object):

    def __init__(self, day):

        self.day = day

    def slots_qs(self):

        qs = Slot.objects.all()

        qs = qs.filter(day=self.day)

        return qs

    def rooms(self):

        qs = Room.objects.all()

        qs = qs.filter(schedule=self.day.schedule)

        qs = qs.filter(

            pk__in=SlotRoom.objects.filter(slot__in=self.slots_qs().values("pk")).values("room"))

        qs = qs.order_by("order")

        return qs