import datetime
+from combo.data.models import Page
from django.http import HttpResponseRedirect
from django.urls import reverse
from django.views.generic.base import TemplateView
-
from emissions.models import Diffusion, Emission, Episode, NewsItem
-from combo.data.models import Page
import panikweb.views
# force detour-vers-le-futur to go first
detour = [x for x in context['emissions'] if x.slug == 'detour-vers-le-futur']
context['emissions'] = detour + [x for x in context['emissions'] if x.slug != 'detour-vers-le-futur']
- context['newsitems'] = NewsItem.objects.exclude(date__gt=datetime.date.today()
- ).exclude(expiration_date__lt=datetime.date.today()).order_by('-date')[:3]
+ context['newsitems'] = (
+ NewsItem.objects.exclude(date__gt=datetime.date.today())
+ .exclude(expiration_date__lt=datetime.date.today())
+ .order_by('-date')[:3]
+ )
context['extra_pages'] = Page.objects.filter(exclude_from_navigation=False)
return context
else:
episodes_queryset = episodes_queryset.filter(emission=emission)
- context['all_episodes'] = episodes_queryset.filter(
- creation_timestamp__gt=current_year
- ).extra(select={
- 'first_diffusion': 'emissions_diffusion.datetime',
- },
- select_params=(False, True),
- where=['''datetime = (SELECT MIN(datetime)
+ context['all_episodes'] = (
+ episodes_queryset.filter(creation_timestamp__gt=current_year)
+ .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').distinct()
+ )'''
+ ],
+ tables=['emissions_diffusion'],
+ )
+ .order_by('first_diffusion')
+ .distinct()
+ )
return context