views.py 22.2 KB
Newer Older
Simon Daron's avatar
Simon Daron committed
1
from datetime import datetime, timedelta
Simon Daron's avatar
Simon Daron committed
2
import time
3
import math
Simon Daron's avatar
Simon Daron committed
4

5
from django.views.decorators.cache import cache_control
Simon Daron's avatar
Simon Daron committed
6 7 8
from django.views.generic.base import TemplateView
from django.views.generic.detail import DetailView
from django.views.decorators.csrf import csrf_exempt
fred's avatar
fred committed
9
from django.views.generic.dates import _date_from_string
Simon Daron's avatar
Simon Daron committed
10

Simon Daron's avatar
Simon Daron committed
11 12
from django.core.paginator import Paginator

fred's avatar
fred committed
13
from haystack.query import SearchQuerySet
Simon Daron's avatar
Simon Daron committed
14 15
from jsonresponse import to_json

Simon Daron's avatar
Simon Daron committed
16
from emissions.models import Category, Emission, Episode, Diffusion, SoundFile, \
Simon Daron's avatar
Simon Daron committed
17 18
        Schedule, Nonstop, NewsItem, NewsCategory

fred's avatar
fred committed
19
from emissions.utils import whatsonair, period_program
Simon Daron's avatar
Simon Daron committed
20

Simon Daron's avatar
Simon Daron committed
21

22
class EmissionMixin:
fred's avatar
fred committed
23
    def get_emission_context(self, emission, episode_ids=None):
24
        context = {}
25 26 27

        # get all episodes, with an additional attribute to get the date of
        # their first diffusion
fred's avatar
fred committed
28 29 30 31 32 33
        episodes_queryset = Episode.objects.select_related()
        if episode_ids is not None:
            episodes_queryset = episodes_queryset.filter(id__in=episode_ids)
        else:
            episodes_queryset = episodes_queryset.filter(emission=emission)

34
        context['episodes'] = \
fred's avatar
fred committed
35
                episodes_queryset.extra(select={
36 37 38 39 40 41 42 43 44 45 46
                        'first_diffusion': 'emissions_diffusion.datetime',
                        },
                        select_params=(False, True),
                        where=['''datetime = (SELECT MIN(datetime)
                                                FROM emissions_diffusion
                                               WHERE episode_id = emissions_episode.id)'''],
                        tables=['emissions_diffusion'],
                    ).order_by('-first_diffusion')

        # get all related soundfiles in a single query
        soundfiles = {}
fred's avatar
fred committed
47
        for soundfile in SoundFile.objects.select_related().filter(podcastable=True,
48
                fragment=False, episode__emission=emission):
49 50 51 52 53 54 55 56
            soundfiles[soundfile.episode_id] = soundfile

        # replace dynamic property by a static attribute, to avoid database
        # lookups
        for episode in context['episodes']:
            episode.main_sound = soundfiles.get(episode.id)

        return context
57 58 59 60 61 62 63 64 65 66 67


class EmissionDetailView(DetailView, EmissionMixin):
    model = Emission

    def get_context_data(self, **kwargs):
        context = super(EmissionDetailView, self).get_context_data(**kwargs)
        context['sectionName'] = "Emissions"
        context['schedules'] = Schedule.objects.select_related().filter(emission=self.object).order_by('datetime')
        context.update(self.get_emission_context(self.object))
        return context
68 69
emission = EmissionDetailView.as_view()

70
class EpisodeDetailView(DetailView, EmissionMixin):
71 72 73 74
    model = Episode

    def get_context_data(self, **kwargs):
        context = super(EpisodeDetailView, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
75
        context['sectionName'] = "Emissions"
76 77
        context['diffusions'] = Diffusion.objects.select_related().filter(episode=self.object.id)
        context['soundfiles'] = SoundFile.objects.select_related().filter(episode=self.object.id)
78
        context['emission'] = Emission.objects.get(slug=self.kwargs.get('emission_slug'))
79
        context.update(self.get_emission_context(context['emission']))
80 81 82
        return context
episode = EpisodeDetailView.as_view()

Simon Daron's avatar
Simon Daron committed
83

84 85 86 87 88 89 90 91
class EmissionEpisodesDetailView(DetailView, EmissionMixin):
    model = Emission
    template_name = 'emissions/episodes.html'

    def get_context_data(self, **kwargs):
        context = super(EmissionEpisodesDetailView, self).get_context_data(**kwargs)
        context['sectionName'] = "Emissions"
        context['schedules'] = Schedule.objects.select_related().filter(emission=self.object).order_by('datetime')
fred's avatar
fred committed
92 93 94 95 96 97 98 99 100 101

        context['search_query'] = self.request.GET.get('q')
        if context['search_query']:
            # query string
            sqs = SearchQuerySet().filter(emission_slug_exact=self.object.slug, text=context['search_query'])
            episode_ids = [x.pk for x in sqs]
        else:
            episode_ids = None

        context.update(self.get_emission_context(self.object, episode_ids=episode_ids))
102 103 104
        return context
emissionEpisodes = EmissionEpisodesDetailView.as_view()

Simon Daron's avatar
Simon Daron committed
105 106 107
class ProgramView(TemplateView):
    template_name = 'program.html'

Simon Daron's avatar
Simon Daron committed
108
    def get_context_data(self, year=None, week=None, **kwargs):
Simon Daron's avatar
Simon Daron committed
109
        context = super(ProgramView, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
110
        context['sectionName'] = "Emissions"
111
        schedules = Schedule.objects.select_related().order_by('datetime')
Simon Daron's avatar
Simon Daron committed
112 113 114 115 116
        days = []
        for day in range(7):
            days.append({'schedules': [x for x in schedules if x.is_on_weekday(day+1)],
                         'datetime': datetime(2007, 1, day+1)})
        context['days'] = days
Simon Daron's avatar
Simon Daron committed
117
        context['weekday'] = datetime.today().weekday()
Simon Daron's avatar
Simon Daron committed
118 119
        context['week'] = week = int(week) if week is not None else datetime.today().isocalendar()[1]-1
        context['year'] = year = int(year) if year is not None else datetime.today().year
Simon Daron's avatar
Simon Daron committed
120 121 122 123
        context['week_first_day'] = datetime.strptime(str(year)+' '+str(week)+' 1', '%Y %U %w')
        context['week_last_day'] = context['week_first_day'] + timedelta(days=+6)
        context['week_previous'] =  context['week_first_day'] + timedelta(days=-7)
        context['week_next'] = context['week_last_day']
Simon Daron's avatar
Simon Daron committed
124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163
        return context

program = ProgramView.as_view()

class TimeCell:
    nonstop = None
    w = 1
    h = 1
    time_label = None

    def __init__(self, i, j):
        self.x = i
        self.y = j
        self.schedules = []

    def add_schedule(self, schedule):
        end_time = schedule.datetime + timedelta(
                minutes=schedule.get_duration())
        self.time_label = '%02d:%02d-%02d:%02d' % (
                schedule.datetime.hour,
                schedule.datetime.minute,
                end_time.hour,
                end_time.minute)
        self.schedules.append(schedule)

    def __unicode__(self):
        if self.schedules:
            return ', '.join([x.emission.title for x in self.schedules])
        else:
            return self.nonstop

    def __eq__(self, other):
        return (unicode(self) == unicode(other) and self.time_label == other.time_label)


class Grid(TemplateView):
    template_name = 'grid.html'

    def get_context_data(self, **kwargs):
        context = super(Grid, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
164
        context['sectionName'] = "Emissions"
Simon Daron's avatar
Simon Daron committed
165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202

        nb_lines = 2 * 24 # the cells are half hours
        grid = []

        times = ['%02d:%02d' % (x/2, x%2*30) for x in range(nb_lines)]
        # start grid after the night programs
        times = times[2*Schedule.DAY_HOUR_START:] + times[:2*Schedule.DAY_HOUR_START]

        nonstops = []
        for nonstop in Nonstop.objects.all():
            if nonstop.start < nonstop.end:
                nonstops.append([nonstop.start.hour + nonstop.start.minute/60.,
                                 nonstop.end.hour + nonstop.end.minute/60.,
                                 nonstop.title])
            else:
                # crossing midnight
                nonstops.append([nonstop.start.hour + nonstop.start.minute/60.,
                                 24,
                                 nonstop.title])
                nonstops.append([0,
                                 nonstop.end.hour + nonstop.end.minute/60.,
                                 nonstop.title])
        nonstops.sort()

        for i in range(nb_lines):
            grid.append([])
            for j in range(7):
                grid[-1].append(TimeCell(i, j))

            nonstop = [x for x in nonstops if i>=x[0]*2 and i<x[1]*2][0]
            for time_cell in grid[-1]:
                time_cell.nonstop = nonstop[2]
                if nonstop[1] == 5:
                    # the one ending at 5am will be cut down, so we inscribe
                    # its duration manually
                    time_cell.time_label = '%02d:00-%02d:00' % (
                            nonstop[0], nonstop[1])

203
        for schedule in Schedule.objects.select_related().order_by('datetime'):
Simon Daron's avatar
Simon Daron committed
204 205 206 207 208 209 210 211 212 213 214 215
            row_start = schedule.datetime.hour * 2 + \
                    int(math.ceil(schedule.datetime.minute / 30))
            day_no = schedule.get_weekday()

            for step in range(int(math.ceil(schedule.get_duration() / 30.))):
                if grid[(row_start+step)%nb_lines][day_no] is None:
                    grid[(row_start+step)%nb_lines][day_no] = TimeCell()
                grid[(row_start+step)%nb_lines][day_no].add_schedule(schedule)

        # start grid after the night programs
        grid = grid[2*Schedule.DAY_HOUR_START:] + grid[:2*Schedule.DAY_HOUR_START]

216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242
        # look for the case where the same emission has different schedules for
        # the same time cell, for example if it lasts one hour the first week,
        # and two hours the third week.
        for i in range(nb_lines):
            grid[i] = [x for x in grid[i] if x is not None]
            for j, cell in enumerate(grid[i]):
                if grid[i][j] is None:
                    continue
                if len(grid[i][j].schedules) > 1:
                    time_cell_emissions = {}
                    for schedule in grid[i][j].schedules:
                        if not schedule.emission.id in time_cell_emissions:
                            time_cell_emissions[schedule.emission.id] = []
                        time_cell_emissions[schedule.emission.id].append(schedule)
                    for schedule_list in time_cell_emissions.values():
                        if len(schedule_list) == 1:
                            continue
                        # here it is, same cell, same emission, several
                        # schedules
                        schedule_list.sort(lambda x,y: -cmp(x.get_duration(), y.get_duration()))
                        for schedule in schedule_list[1:]:
                            grid[i][j].schedules.remove(schedule)
                            end_time = schedule.datetime + timedelta(minutes=schedule.get_duration())
                            schedule_list[0].time_label_extra = ', -%02d:%02d %s' % (
                                    end_time.hour, end_time.minute, schedule.weeks_string)

        # merge adjacent
fred's avatar
fred committed
243 244 245

        # 1st thing is to merge cells on the same line, this will mostly catch
        # consecutive nonstop cells
Simon Daron's avatar
Simon Daron committed
246 247 248 249 250 251
        for i in range(nb_lines):
            for j, cell in enumerate(grid[i]):
                if grid[i][j] is None:
                    continue
                t = 1
                try:
fred's avatar
fred committed
252 253
                    # if the cells are identical, they are removed from the
                    # grid, and current cell width is increased
Simon Daron's avatar
Simon Daron committed
254 255 256 257 258 259
                    while grid[i][j+t] == cell:
                        cell.w += 1
                        grid[i][j+t] = None
                        t += 1
                except IndexError:
                    pass
fred's avatar
fred committed
260 261

            # once we're done we remove empty cells
Simon Daron's avatar
Simon Daron committed
262 263
            grid[i] = [x for x in grid[i] if x is not None]

fred's avatar
fred committed
264 265
        # 2nd thing is to merge cells vertically, this is emissions that last
        # for more than 30 minutes
Simon Daron's avatar
Simon Daron committed
266 267 268 269 270 271 272 273
        for i in range(nb_lines):
            grid[i] = [x for x in grid[i] if x is not None]
            for j, cell in enumerate(grid[i]):
                if grid[i][j] is None:
                    continue
                t = 1
                try:
                    while True:
fred's avatar
fred committed
274
                        # we look if the next time cell has the same emissions
Simon Daron's avatar
Simon Daron committed
275 276
                        same_cell_below = [(bj, x) for bj, x in enumerate(grid[i+cell.h])
                                           if x == cell and x.y == cell.y and x.w == cell.w]
fred's avatar
fred committed
277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322
                        if same_cell_below:
                            # if the cell was identical, we remove it and
                            # increase current cell height
                            bj, same_cell_below = same_cell_below[0]
                            del grid[i+cell.h][bj]
                            cell.h += 1
                        else:
                            # if the cell is different, we have a closer look
                            # to it, so we can remove emissions that will
                            # already be mentioned in the current cell.
                            #
                            # For example:
                            #  - 7am30, seuls contre tout, 1h30
                            #  - 8am, du pied gauche & la voix de la rue, 1h
                            # should produce: (this is case A)
                            #  |      7:30-9:00      |
                            #  |  seuls contre tout  |
                            #  |---------------------|
                            #  |      8:00-9:00      |
                            #  |   du pied gauche    |
                            #  |  la voix de la rue  |
                            #
                            # On the other hand, if all three emissions started
                            # at 7am30, we want: (this is case B)
                            #  |      7:30-9:00      |
                            #  |  seuls contre tout  |
                            #  |   du pied gauche    |
                            #  |  la voix de la rue  |
                            # that is we merge all of them, ignoring the fact
                            # that the other emissions will stop at 8am30
                            current_cell_schedules = set(grid[i][j].schedules)
                            cursor = 1
                            while True and current_cell_schedules:
                                same_cell_below = [x for x in grid[i+cursor] if x.y == grid[i][j].y]
                                if not same_cell_below:
                                    cursor += 1
                                    continue
                                same_cell_below = same_cell_below[0]
                                if current_cell_schedules.issubset(same_cell_below.schedules):
                                    # this handles case A (see comment above)
                                    for schedule in current_cell_schedules:
                                        if schedule in same_cell_below.schedules:
                                            same_cell_below.schedules.remove(schedule)
                                elif same_cell_below.schedules and \
                                        current_cell_schedules.issuperset(same_cell_below.schedules):
                                    # this handles case B (see comment above)
323 324
                                    # we set the cell time label to the longest
                                    # period
fred's avatar
fred committed
325
                                    grid[i][j].time_label = same_cell_below.time_label
326 327 328 329 330 331 332 333 334 335 336 337 338 339 340
                                    # then we sort emissions so the longest are
                                    # put first
                                    grid[i][j].schedules.sort(
                                            lambda x, y: -cmp(x.get_duration(), y.get_duration()))
                                    # then we add individual time labels to the
                                    # other schedules
                                    for schedule in current_cell_schedules:
                                        if schedule not in same_cell_below.schedules:
                                            end_time = schedule.datetime + timedelta(
                                                    minutes=schedule.get_duration())
                                            schedule.time_label = '%02d:%02d-%02d:%02d' % (
                                                    schedule.datetime.hour,
                                                    schedule.datetime.minute,
                                                    end_time.hour,
                                                    end_time.minute)
fred's avatar
fred committed
341 342 343
                                    grid[i][j].h += 1
                                    grid[i+cursor].remove(same_cell_below)
                                cursor += 1
Simon Daron's avatar
Simon Daron committed
344 345 346 347 348 349 350 351 352 353
                            break
                except IndexError:
                    pass

        # cut night at 3am
        grid = grid[:42]
        times = times[:42]

        context['grid'] = grid
        context['times'] = times
Simon Daron's avatar
Simon Daron committed
354
        context['categories'] = Category.objects.all()
Simon Daron's avatar
Simon Daron committed
355 356 357 358 359 360 361 362 363 364 365 366 367
        context['weekdays'] = ['Lundi', 'Mardi', 'Mercredi', 'Jeudi',
                'Vendredi', 'Samedi', 'Dimanche']

        return context

grid = Grid.as_view()


class Home(TemplateView):
    template_name = 'home.html'

    def get_context_data(self, **kwargs):
        context = super(Home, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
368
        context['sectionName'] = "Home"
Simon Daron's avatar
Simon Daron committed
369 370
        context['focus'] = list(NewsItem.objects.all().exclude(image__isnull=True).exclude(image__exact='').order_by('-datetime')[0:3])
        context['news'] = list(NewsItem.objects.all().exclude(image__isnull=True).exclude(image__exact='').order_by('-datetime')[3:10])
371
        context['emissions'] = list(Emission.objects.filter(archived=False).order_by('title'))
Simon Daron's avatar
Simon Daron committed
372 373 374 375 376 377
        schedules = Schedule.objects.select_related().order_by('datetime')
        days = []
        for day in range(7):
            days.append({'schedules': [x for x in schedules if x.is_on_weekday(day+1)],
                         'datetime': datetime(2007, 1, day+1)})
        context['days'] = days
Simon Daron's avatar
Simon Daron committed
378 379 380 381
        return context

home = Home.as_view()

Simon Daron's avatar
Simon Daron committed
382
class NewsItemView(DetailView):
Simon Daron's avatar
Simon Daron committed
383 384
    model = NewsItem
    def get_context_data(self, **kwargs):
Simon Daron's avatar
Simon Daron committed
385
        context = super(NewsItemView, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
386
        context['sectionName'] = "News"
Simon Daron's avatar
Simon Daron committed
387 388 389
        context['focus'] = list(NewsItem.objects.all().exclude(image__isnull=True).exclude(image__exact='').order_by('-datetime')[0:3])
        context['news'] = list(NewsItem.objects.all().exclude(image__isnull=True).exclude(image__exact='').order_by('-datetime')[3:10])
        context['newsAll'] = list(NewsItem.objects.all().order_by('-datetime')[:60])
Simon Daron's avatar
Simon Daron committed
390 391
        context['categories'] = list(NewsCategory.objects.all())
        return context
Simon Daron's avatar
Simon Daron committed
392
newsitemview = NewsItemView.as_view()
Simon Daron's avatar
Simon Daron committed
393

Simon Daron's avatar
Simon Daron committed
394 395 396 397
class News(TemplateView):
    template_name = 'news.html'
    def get_context_data(self, **kwargs):
        context = super(News, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
398
        context['sectionName'] = "News"
Simon Daron's avatar
Simon Daron committed
399 400 401
        context['focus'] = list(NewsItem.objects.all().exclude(image__isnull=True).exclude(image__exact='').order_by('-datetime')[0:3])
        context['news'] = list(NewsItem.objects.all().exclude(image__isnull=True).exclude(image__exact='').order_by('-datetime')[3:10])
        context['newsAll'] = list(NewsItem.objects.all().order_by('-datetime')[:60])
402
        context['categories'] = list(NewsCategory.objects.all())
Simon Daron's avatar
Simon Daron committed
403 404 405 406
        return context

news = News.as_view()

Simon Daron's avatar
Simon Daron committed
407 408 409 410 411
class Emissions(TemplateView):
    template_name = 'emissions.html'

    def get_context_data(self, **kwargs):
        context = super(Emissions, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
412
        context['sectionName'] = "Emissions"
413
        context['emissions'] = Emission.objects.prefetch_related('categories').filter(archived=False).order_by('title')
Simon Daron's avatar
Simon Daron committed
414
        context['categories'] = Category.objects.all()
Simon Daron's avatar
Simon Daron committed
415 416 417 418
        return context

emissions = Emissions.as_view()

Simon Daron's avatar
Simon Daron committed
419 420 421 422
class Archives(TemplateView):
    template_name = 'archives.html'
    def get_context_data(self, **kwargs):
        context = super(Archives, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
423
        context['sectionName'] = "Emissions"
fred's avatar
fred committed
424
        context['emissions'] = Emission.objects.prefetch_related('categories').filter(archived=True).order_by('title')
Simon Daron's avatar
Simon Daron committed
425 426 427 428
        return context

archives = Archives.as_view()

Simon Daron's avatar
Simon Daron committed
429 430 431 432 433 434 435 436 437 438 439 440 441 442
class Get(TemplateView):
    template_name = 'get.html'
    def get_context_data(self, **kwargs):
        context = super(Get, self).get_context_data(**kwargs)
        context['emissions'] = Emission.objects.all().order_by('title')
        return context

get = Get.as_view()

class Listen(TemplateView):
    template_name = 'listen.html'

    def get_context_data(self, **kwargs):
        context = super(Listen, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
443
        context['sectionName'] = "Listen"
444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463
        context['episodes'] = Episode.objects.filter(
                soundfile__podcastable=True, soundfile__fragment=False) \
                .select_related().extra(select={
                    'first_diffusion': 'emissions_diffusion.datetime', },
                    select_params=(False, True),
                    where=['''datetime = (SELECT MIN(datetime)
                                            FROM emissions_diffusion
                                        WHERE episode_id = emissions_episode.id)'''],
                    tables=['emissions_diffusion'],).order_by('-first_diffusion') [:60]

        # get all related soundfiles in a single query
        soundfiles = {}
        for soundfile in SoundFile.objects.select_related().filter(podcastable=True,
                fragment=False, episode__in=[x.id for x in context['episodes']]):
            soundfiles[soundfile.episode_id] = soundfile

        # replace dynamic property by a static attribute, to avoid database
        # lookups
        for episode in context['episodes']:
            episode.main_sound = soundfiles.get(episode.id)
Simon Daron's avatar
Simon Daron committed
464
        context['categories'] = Category.objects.all()
fred's avatar
fred committed
465

Simon Daron's avatar
Simon Daron committed
466 467 468 469 470
        return context

listen = Listen.as_view()


471
@cache_control(max_age=25)
Simon Daron's avatar
Simon Daron committed
472 473 474 475 476 477 478 479 480 481 482 483 484 485
@csrf_exempt
@to_json('api')
def onair(request):
    d = whatsonair()
    if d.get('episode'):
        d['episode'] = {
            'title': d['episode'].title,
            'url': d['episode'].get_absolute_url()
        }
    if d.get('emission'):
        d['emission'] = {
            'title': d['emission'].title,
            'url': d['emission'].get_absolute_url()
        }
fred's avatar
fred committed
486 487 488 489 490
    if d.get('nonstop'):
        d['nonstop'] = {
            'title': d['nonstop'].title,
        }
    if d.get('current_slot'):
fred's avatar
fred committed
491
        del d['current_slot']
Simon Daron's avatar
Simon Daron committed
492 493 494 495 496 497 498
    return d


class NewsItemDetailView(DetailView):
    model = NewsItem

newsitem = NewsItemDetailView.as_view()
fred's avatar
fred committed
499 500 501 502 503 504 505 506 507 508 509 510 511 512


class PodcastsFeedView(TemplateView):
    template_name = 'podcasts.html'
    content_type = 'application/rss+xml'

    def get_context_data(self, **kwargs):
        context = super(PodcastsFeedView, self).get_context_data(**kwargs)
        context['base_url'] = self.request.build_absolute_uri('/')[:-1]
        context['soundfiles'] = SoundFile.objects.select_related().filter(
                podcastable=True).order_by('-creation_timestamp')
        return context

podcasts_feed = PodcastsFeedView.as_view()