Merge lp:~dholbach/serious-donut/add-translations-dashboard into lp:serious-donut

[Daniel Holbach]

[lp:~dholbach/serious-donut/add-translations-dashboard]

46. By Daniel Holbach on 2016-05-15

uncommit local DATABASE change

Unmerged revisions

46. By Daniel Holbach on 2016-05-15

uncommit local DATABASE change

45. By Daniel Holbach on 2016-05-15

steal translations dashboard from dev portal

44. By Daniel Holbach on 2016-05-15

update components

=== modified file 'README.local.md'
--- README.local.md	2016-04-29 09:39:19 +0000
+++ README.local.md	2016-05-15 14:35:51 +0000
@@ -5,7 +5,7 @@
 
 virtualenv env
 ./env/bin/pip install -r community/requirements.txt
-./env/bin/python manage.py syncdb
+./env/bin/python manage.py migrate
 ./env/bin/python manage.py initdb
 ./env/bin/python manage.py collectstatic
 ./env/bin/python manage.py runserver

=== modified file 'community/requirements.txt'
--- community/requirements.txt	2016-04-29 09:54:53 +0000
+++ community/requirements.txt	2016-05-15 14:35:51 +0000
@@ -1,6 +1,6 @@
 aldryn-newsblog==1.2.1
 argparse==1.2.1
-Django==1.8.12
+Django==1.8.13
 django-classy-tags==0.7.2
 django-cms==3.2.5
 djangocms-admin-style==1.1.1
@@ -9,22 +9,22 @@
 djangocms-flash==0.3.0
 djangocms-googlemap==0.4.0
 djangocms-inherit==0.1.1
-djangocms-installer==0.8.7
+djangocms-installer==0.8.8
 djangocms-link==1.7.2
 djangocms-picture==1.0.0
 djangocms-style==1.7.0
 djangocms-teaser==0.2.0
 djangocms-text-ckeditor==2.9.3
 djangocms-video==1.0.0
-django-mptt==0.8.3
+django-mptt==0.8.4
 django-openid-auth==0.7
 django-reversion==1.10.2
 django-sekizai==0.9.0
 Django-Select2==5.8.4
-django-treebeard==4.0
+django-treebeard==4.0.1
 dj-database-url==0.4.1
 dj-static==0.0.6
-html5lib==0.999999
+html5lib==0.9999999
 Pillow==3.2.0
 python-openid==2.2.5
 pytz==2016.4

=== modified file 'community/urls.py'
--- community/urls.py	2016-04-29 09:39:19 +0000
+++ community/urls.py	2016-05-15 14:35:51 +0000
@@ -32,6 +32,12 @@
     url(r'^', include('cms.urls')),
 )
 
+urlpatterns += patterns('community.views',
+    url(r'^translations-dashboard/$', 'translations_dashboard',
+        name='translations_dashboard'),
+)
+
+
 # + static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT)
 
 # This is only needed when using runserver.

=== modified file 'community/views.py'
--- community/views.py	2015-07-31 23:49:24 +0000
+++ community/views.py	2016-05-15 14:35:51 +0000
@@ -6,10 +6,16 @@
 from django.conf import settings
 from django.contrib.auth import logout
 from django.utils.translation import ugettext_lazy as _
+from django.views.decorators.cache import never_cache
 from django.db.models import Q
 
 from django_openid_auth.signals import openid_login_complete
 
+from cms.models import CMSPlugin
+import datetime
+import pytz
+
+
 try:
     from django_openid_auth.exceptions import (
         MissingPhysicalMultiFactor,
@@ -44,7 +50,7 @@
     except:
         request.user.is_staff = False
     request.user.save()
-    
+
 def listen_for_login():
     openid_login_complete.connect(promote_staff)
 
@@ -85,3 +91,41 @@
         'query': query,
     }
     return TemplateResponse(request, 'search_results.html', RequestContext(request, context))
+
+
+def get_pages():
+    dashboard_data = []
+    known_paths = []
+    for plugin_change in CMSPlugin.objects.filter(
+            plugin_type__regex='TextPlugin|RawHtmlPlugin').order_by(
+                '-changed_date'):
+        date = plugin_change.changed_date
+        lang = plugin_change.language.replace('-', '_')
+        page = plugin_change.placeholder.page
+        if not page or page.publisher_is_draft:
+            continue
+        path = page.get_path()
+        if path not in known_paths:
+            known_paths.append(path)
+            dashboard_data.append({'path': path})
+        for p in dashboard_data:
+            if p['path'] == path:
+                p['title'] = page.get_title()
+                if p.get(lang):
+                    if date > p[lang]:
+                        p[lang] = date
+                else:
+                    p[lang] = date
+    # When an english page is missing, we still need a time to sort pages
+    notime = datetime.datetime(1, 1, 1, tzinfo=pytz.timezone('UTC'))
+    dashboard_data = list(reversed(sorted(
+        dashboard_data, key=lambda k: k.get('en', notime))))
+    return dashboard_data
+
+
+@never_cache
+def translations_dashboard(request):
+    return render_to_response(
+        'translations_dashboard.html',
+        {'cms_pages': get_pages()},
+        context_instance=RequestContext(request))

=== added file 'templates/translations_dashboard.html'
--- templates/translations_dashboard.html	1970-01-01 00:00:00 +0000
+++ templates/translations_dashboard.html	2016-05-15 14:35:51 +0000
@@ -0,0 +1,38 @@
+{% extends "base.html" %}
+{% load i18n static %}
+
+{% block content %}
+<div class="row">
+    <h2>{% trans "Translations dashboard" %}</h2>
+    <p>{% trans "A simple dashboard to keep track of updates between languages." %}</p>
+    <table>
+        <thead>
+            <tr>
+                <th>{% trans "Page" %}</th>
+                <th>{% trans "English" %}</th>
+                <th>{% trans "Simplified Chinese" %}</th>
+            </tr>
+        </thead>
+        <tbody
+            {% for page in cms_pages %}
+                 <tr>
+
+                    <td style="text-align:left;width:40%;"><a href="/{{ page.path }}">{{ page.title }}</a></td>
+                    <td style="text-align:left;">{{ page.en }}</td>
+                        {% if page.zh_cn > page.en %}
+                            <td style="text-align:left;background-color:#60ab5d;color:#fff;">
+                        {% else %}
+                            <td style="text-align:left;background-color:#f95e5d;color:#fff;">
+                        {% endif %}
+                        {% if page.zh_cn %}
+                            {{ page.zh_cn }}
+                        {% else %}
+                            <span style="color:lightgrey">{% trans "Not available" %}</span>
+                        {% endif %}
+                    </td>
+                </tr>
+            {% endfor %}
+        </tbody>
+    </table>
+</div>
+{% endblock content %}