views.py 27 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
import fiber.views
fred's avatar
fred committed
14
from haystack.query import SearchQuerySet
Simon Daron's avatar
Simon Daron committed
15 16
from jsonresponse import to_json

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

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

22 23
from newsletter.forms import SubscribeForm

fred's avatar
fred committed
24 25
from . import utils

Simon Daron's avatar
Simon Daron committed
26

27
class EmissionMixin:
fred's avatar
fred committed
28
    def get_emission_context(self, emission, episode_ids=None):
29
        context = {}
30 31 32

        # get all episodes, with an additional attribute to get the date of
        # their first diffusion
fred's avatar
fred committed
33 34 35 36 37 38
        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)

39
        context['episodes'] = \
fred's avatar
fred committed
40
                episodes_queryset.extra(select={
41 42 43 44 45 46 47 48 49 50 51
                        '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
52
        for soundfile in SoundFile.objects.select_related().filter(podcastable=True,
53
                fragment=False, episode__emission=emission):
54 55 56 57 58 59 60
            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
61 62
        #context['futurEpisodes'] = context['episodes'].filter(first_diffusion='2013')[0:3]

63
        return context
64 65 66 67 68 69 70 71 72


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')
73
        context['news'] = NewsItem.objects.all().filter(emission=self.object.id).order_by('-date')[:3]
74 75
        context.update(self.get_emission_context(self.object))
        return context
76 77
emission = EmissionDetailView.as_view()

78
class EpisodeDetailView(DetailView, EmissionMixin):
79 80 81 82
    model = Episode

    def get_context_data(self, **kwargs):
        context = super(EpisodeDetailView, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
83
        context['sectionName'] = "Emissions"
84 85
        context['diffusions'] = Diffusion.objects.select_related().filter(episode=self.object.id)
        context['soundfiles'] = SoundFile.objects.select_related().filter(episode=self.object.id)
86
        context['emission'] = Emission.objects.get(slug=self.kwargs.get('emission_slug'))
87
        context.update(self.get_emission_context(context['emission']))
88 89 90
        return context
episode = EpisodeDetailView.as_view()

Simon Daron's avatar
Simon Daron committed
91

92 93 94 95 96 97 98 99
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
100 101 102 103

        context['search_query'] = self.request.GET.get('q')
        if context['search_query']:
            # query string
fred's avatar
fred committed
104 105
            sqs = SearchQuerySet().filter(django_ct='emissions.episode',
                    emission_slug_exact=self.object.slug, text=context['search_query'])
fred's avatar
fred committed
106 107 108 109 110
            episode_ids = [x.pk for x in sqs]
        else:
            episode_ids = None

        context.update(self.get_emission_context(self.object, episode_ids=episode_ids))
111 112 113
        return context
emissionEpisodes = EmissionEpisodesDetailView.as_view()

Simon Daron's avatar
Simon Daron committed
114 115 116
class ProgramView(TemplateView):
    template_name = 'program.html'

Simon Daron's avatar
Simon Daron committed
117
    def get_context_data(self, year=None, week=None, **kwargs):
Simon Daron's avatar
Simon Daron committed
118
        context = super(ProgramView, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
119
        context['sectionName'] = "Emissions"
fred's avatar
fred committed
120

Simon Daron's avatar
Simon Daron committed
121
        context['weekday'] = datetime.today().weekday()
fred's avatar
fred committed
122 123 124 125 126 127 128 129 130 131 132 133 134 135

        context['week'] = week = int(week) if week is not None else datetime.today().isocalendar()[1]
        context['year'] = year = int(year) if year is not None else datetime.today().isocalendar()[0]
        context['week_first_day'] = utils.tofirstdayinisoweek(year, week)
        context['week_last_day'] = context['week_first_day'] + timedelta(days=6)

        previous_week = context['week_first_day'] - timedelta(days=7)
        context['previous_week_no'] = previous_week.isocalendar()[1]
        context['previous_week_year'] = previous_week.isocalendar()[0]

        next_week = context['week_first_day'] + timedelta(days=7)
        context['next_week_no'] = next_week.isocalendar()[1]
        context['next_week_year'] = next_week.isocalendar()[0]

Simon Daron's avatar
Simon Daron committed
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 164 165 166 167 168 169 170 171 172 173 174 175
        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
176
        context['sectionName'] = "Emissions"
Simon Daron's avatar
Simon Daron committed
177 178 179 180 181 182 183 184 185 186 187 188 189

        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.,
fred's avatar
fred committed
190
                                 nonstop.title, nonstop.slug])
Simon Daron's avatar
Simon Daron committed
191 192 193 194
            else:
                # crossing midnight
                nonstops.append([nonstop.start.hour + nonstop.start.minute/60.,
                                 24,
fred's avatar
fred committed
195
                                 nonstop.title, nonstop.slug])
Simon Daron's avatar
Simon Daron committed
196 197
                nonstops.append([0,
                                 nonstop.end.hour + nonstop.end.minute/60.,
fred's avatar
fred committed
198
                                 nonstop.title, nonstop.slug])
Simon Daron's avatar
Simon Daron committed
199 200 201 202 203 204 205 206 207 208
        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]
fred's avatar
fred committed
209
                time_cell.nonstop_slug = nonstop[3]
Simon Daron's avatar
Simon Daron committed
210 211 212 213 214 215
                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])

216 217
        for schedule in Schedule.objects.prefetch_related(
                'emission__categories').select_related().order_by('datetime'):
Simon Daron's avatar
Simon Daron committed
218 219 220 221 222 223 224 225 226 227 228 229
            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]

230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248
        # 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
249 250 251 252 253 254 255 256 257 258 259
                        schedule_list.sort(lambda x,y: cmp(x.get_duration(), y.get_duration()))

                        schedule = schedule_list[0]
                        end_time = schedule.datetime + timedelta(
                                minutes=schedule.get_duration())
                        grid[i][j].time_label = '%02d:%02d-%02d:%02d' % (
                                schedule.datetime.hour,
                                schedule.datetime.minute,
                                end_time.hour,
                                end_time.minute)

260 261 262 263 264 265 266
                        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
267 268 269

        # 1st thing is to merge cells on the same line, this will mostly catch
        # consecutive nonstop cells
Simon Daron's avatar
Simon Daron committed
270 271 272 273 274 275
        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
276 277
                    # if the cells are identical, they are removed from the
                    # grid, and current cell width is increased
Simon Daron's avatar
Simon Daron committed
278 279 280 281 282 283
                    while grid[i][j+t] == cell:
                        cell.w += 1
                        grid[i][j+t] = None
                        t += 1
                except IndexError:
                    pass
fred's avatar
fred committed
284 285

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

fred's avatar
fred committed
288 289
        # 2nd thing is to merge cells vertically, this is emissions that last
        # for more than 30 minutes
Simon Daron's avatar
Simon Daron committed
290 291 292 293 294 295 296 297
        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
298
                        # we look if the next time cell has the same emissions
Simon Daron's avatar
Simon Daron committed
299 300
                        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
301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331
                        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)
332
                            current_cell_emissions = set([x.emission for x in current_cell_schedules])
fred's avatar
fred committed
333 334 335 336 337 338 339
                            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]
340 341 342
                                same_cell_below_emissions = set([x.emission for x in same_cell_below.schedules])

                                if current_cell_emissions.issubset(same_cell_below_emissions):
fred's avatar
fred committed
343 344 345 346
                                    # 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)
347 348
                                elif same_cell_below_emissions and \
                                        current_cell_emissions.issuperset(same_cell_below_emissions):
fred's avatar
fred committed
349
                                    # this handles case B (see comment above)
350 351
                                    # we set the cell time label to the longest
                                    # period
fred's avatar
fred committed
352
                                    grid[i][j].time_label = same_cell_below.time_label
353 354 355 356 357 358 359 360 361 362 363 364 365 366 367
                                    # 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
368 369
                                    grid[i][j].h += 1
                                    grid[i+cursor].remove(same_cell_below)
370 371 372 373 374 375 376
                                elif same_cell_below_emissions and \
                                        current_cell_emissions.intersection(same_cell_below_emissions):
                                    same_cell_below.schedules = [x for x in
                                            same_cell_below.schedules if
                                            x.emission not in
                                            current_cell_emissions or
                                            x.get_duration() < 30]
fred's avatar
fred committed
377
                                cursor += 1
Simon Daron's avatar
Simon Daron committed
378 379 380 381 382 383 384 385 386 387
                            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
388
        context['categories'] = Category.objects.all()
Simon Daron's avatar
Simon Daron committed
389 390 391 392 393 394 395 396 397 398 399 400 401
        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
402
        context['sectionName'] = "Home"
fred's avatar
fred committed
403
        context['focus'] = NewsItem.objects.select_related('category').filter(focus=True).exclude(image__isnull=True).exclude(image__exact='').order_by('-date')[:9]
404
        context['emissions'] = list(Emission.objects.filter(archived=False).order_by('title'))
Simon Daron's avatar
Simon Daron committed
405 406 407 408 409 410
        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
411

412
        context['episodes'] = Episode.objects.prefetch_related('emission__categories').filter(
413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432
                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') [:6]

        # 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)

433 434
        context['newsletter_form'] = SubscribeForm()

Simon Daron's avatar
Simon Daron committed
435 436 437 438
        return context

home = Home.as_view()

Simon Daron's avatar
Simon Daron committed
439
class NewsItemView(DetailView):
Simon Daron's avatar
Simon Daron committed
440 441
    model = NewsItem
    def get_context_data(self, **kwargs):
Simon Daron's avatar
Simon Daron committed
442
        context = super(NewsItemView, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
443
        context['sectionName'] = "News"
fred's avatar
fred committed
444
        context['focus'] = list(NewsItem.objects.select_related('category').filter(focus=True).exclude(image__isnull=True).exclude(image__exact='').order_by('-date')[0:9])
Simon Daron's avatar
Simon Daron committed
445
        context['categories'] = NewsCategory.objects.all()
Simon Daron's avatar
Simon Daron committed
446
        return context
Simon Daron's avatar
Simon Daron committed
447
newsitemview = NewsItemView.as_view()
Simon Daron's avatar
Simon Daron committed
448

Simon Daron's avatar
Simon Daron committed
449 450 451 452
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
453
        context['sectionName'] = "News"
fred's avatar
fred committed
454 455
        context['focus'] = NewsItem.objects.select_related('category').filter(focus=True).exclude(image__isnull=True).exclude(image__exact='').order_by('-date')[:9]
        context['news'] = NewsItem.objects.all().exclude(focus=True).exclude(image__isnull=True).exclude(image__exact='').order_by('-date')[3:14]
Simon Daron's avatar
Simon Daron committed
456 457 458 459
        return context

news = News.as_view()

460 461 462 463 464
class NewsArchives(TemplateView):
    template_name = 'news/archives.html'
    def get_context_data(self, **kwargs):
        context = super(NewsArchives, self).get_context_data(**kwargs)
        context['sectionName'] = "News"
fred's avatar
fred committed
465 466 467 468 469
        context['search_query'] = self.request.GET.get('q')
        sqs = SearchQuerySet().filter(django_ct='emissions.newsitem')
        if context['search_query']:
            # query string
            sqs = sqs.filter(text=context['search_query'])
fred's avatar
fred committed
470 471
        else:
            sqs = sqs.order_by('-date')
fred's avatar
fred committed
472 473 474 475 476

        sqs = sqs.load_all()

        context['results'] = sqs

477 478 479 480
        return context

newsArchives = NewsArchives.as_view()

Simon Daron's avatar
Simon Daron committed
481 482 483 484 485
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
486
        context['sectionName'] = "Emissions"
487
        context['emissions'] = Emission.objects.prefetch_related('categories').filter(archived=False).order_by('title')
Simon Daron's avatar
Simon Daron committed
488
        context['categories'] = Category.objects.all()
Simon Daron's avatar
Simon Daron committed
489 490 491 492
        return context

emissions = Emissions.as_view()

493
class EmissionsArchives(TemplateView):
494
    template_name = 'emissions/archives.html'
495

Simon Daron's avatar
Simon Daron committed
496
    def get_context_data(self, **kwargs):
497
        context = super(EmissionsArchives, self).get_context_data(**kwargs)
Simon Daron's avatar
Simon Daron committed
498
        context['sectionName'] = "Emissions"
fred's avatar
fred committed
499
        context['emissions'] = Emission.objects.prefetch_related('categories').filter(archived=True).order_by('title')
Simon Daron's avatar
Simon Daron committed
500
        return context
501 502
emissionsArchives = EmissionsArchives.as_view()

Simon Daron's avatar
Simon Daron committed
503

Simon Daron's avatar
Simon Daron committed
504 505 506 507 508 509 510 511 512 513 514 515 516 517
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
518
        context['sectionName'] = "Listen"
519
        context['episodes'] = Episode.objects.prefetch_related('emission__categories').filter(
520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538
                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
539
        context['categories'] = Category.objects.all()
fred's avatar
fred committed
540

Simon Daron's avatar
Simon Daron committed
541 542 543 544
        return context

listen = Listen.as_view()

Simon Daron's avatar
Simon Daron committed
545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575
class ListenArchives(TemplateView):
    template_name = 'listen/archives.html'
    def get_context_data(self, **kwargs):

        context = super(ListenArchives, self).get_context_data(**kwargs)
        context['sectionName'] = "Listen"
        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)
        context['categories'] = Category.objects.all()

        return context

listenArchives = ListenArchives.as_view()
Simon Daron's avatar
Simon Daron committed
576

577
@cache_control(max_age=25)
Simon Daron's avatar
Simon Daron committed
578 579 580 581 582 583 584 585 586 587 588 589 590 591
@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
592 593 594 595 596
    if d.get('nonstop'):
        d['nonstop'] = {
            'title': d['nonstop'].title,
        }
    if d.get('current_slot'):
fred's avatar
fred committed
597
        del d['current_slot']
Simon Daron's avatar
Simon Daron committed
598 599 600 601 602 603 604
    return d


class NewsItemDetailView(DetailView):
    model = NewsItem

newsitem = NewsItemDetailView.as_view()
fred's avatar
fred committed
605 606 607 608 609 610 611 612 613 614 615 616 617 618


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()
fred's avatar
fred committed
619 620 621 622 623 624 625 626


class FiberPageView(fiber.views.FiberTemplateView):
    def get_context_data(self, **kwargs):
        context = super(FiberPageView, self).get_context_data(**kwargs)
        context['sectionName'] = 'About'
        return context
fiber_page = FiberPageView.as_view()