views: add variable with all episodes for emission template

[panikweb.git] / panikweb / views.py

diff --git a/panikweb/views.py b/panikweb/views.py
index 0c386eb50def9be8628a4d39d34811013d4e2d9e..4338b694d3ac2edc413820e275d720c2e3e935ff 100644 (file)
--- a/panikweb/views.py
+++ b/panikweb/views.py
@@ -80,6 +80,23 @@ class EmissionMixin:
             .distinct()
         )
 
+        context['all_episodes'] = (
+            episodes_queryset.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()
+        )
+
         context['futurEpisodes'] = (
             episodes_queryset.extra(
                 select={