add command to notify teachers about unconfirmed students

diff --git a/wtem/management/commands/notify_teachers.py b/wtem/management/commands/notify_teachers.py
new file mode 100644 (file)
index 0000000..354ab43
--- /dev/null
+++ b/wtem/management/commands/notify_teachers.py
@@ -0,0 +1,45 @@
+# -*- coding: utf-8 -*-
+from datetime import timedelta
+from django.core.management.base import BaseCommand
+from django.template.loader import render_to_string
+from django.utils import timezone
+
+from contact.models import Contact
+from wtem.management.commands import send_mail
+from wtem.models import Confirmation
+
+
+class Command(BaseCommand):
+    def handle(self, *args, **options):
+        sent = 0
+        failed = 0
+
+        query = Contact.objects.filter(form_tag='olimpiada').order_by('contact').distinct('contact')
+        template_name = 'notify_unconfirmed'
+        message_template = 'wtem/' + template_name + '.txt'
+        subject = render_to_string('wtem/' + template_name + '_subject.txt')
+
+        threshold = timezone.now() - timedelta(4)
+
+        for contact in query:
+            unconfirmed = []
+            for similar_contact in Contact.objects.filter(contact=contact.contact):
+                unconfirmed += list(Confirmation.objects.filter(
+                    contact=similar_contact, confirmed=False, contact__created_at__lt=threshold))
+            if not unconfirmed:
+                continue
+            message = render_to_string(message_template, {'unconfirmed': unconfirmed})
+            try:
+                self.send_message(message, subject, contact.contact)
+            except Exception as e:
+                failed += 1
+                self.stdout.write('failed sending to: ' + contact.contact + ' - ' + str(e))
+            else:
+                sent += 1
+                self.stdout.write('message sent to: ' + contact.contact)
+
+        self.stdout.write('sent: %s, failed: %s' % (sent, failed))
+
+    def send_message(self, message, subject, email):
+        self.stdout.write('>>> sending to %s' % email)
+        send_mail(subject=subject, body=message, to=[email])

diff --git a/wtem/templates/wtem/notify_unconfirmed.txt b/wtem/templates/wtem/notify_unconfirmed.txt
new file mode 100644 (file)
index 0000000..7fc8fb7
--- /dev/null
+++ b/wtem/templates/wtem/notify_unconfirmed.txt
@@ -0,0 +1,13 @@
+Dzień dobry,
+Dziękujemy za zarejestrowanie uczniów do udziału w Olimpiadzie Cyfrowej.
+
+Sprawdziliśmy, że nie mamy potwierdzenia rejestracji od kilku Pani/Pana uczniów (tzn. nie kliknęli w link, który otrzymali na maila):
+{% for confirmation in unconfirmed %}
+{{ confirmation.first_name }} {{ confirmation.last_name}} – {{ confirmation.email }}{% endfor %}
+
+Może to oznaczać, że podczas rejestracji zostały podane nieprawidłowe adresy, albo że mail od nas wpadł uczniom do spamu. Prosimy o sprawdzenie tego i przypomnienie uczniom o konieczności kliknięcia w link z maila.
+
+Pozdrawiamy,
+
+zespół Olimpiady Cyfrowej
+fundacja Nowoczesna Polska
\ No newline at end of file

diff --git a/wtem/templates/wtem/notify_unconfirmed_subject.txt b/wtem/templates/wtem/notify_unconfirmed_subject.txt
new file mode 100644 (file)
index 0000000..d5bf64d
--- /dev/null
+++ b/wtem/templates/wtem/notify_unconfirmed_subject.txt
@@ -0,0 +1 @@
+Olimpiada Cyfrowa – brak potwierdzenia zgłoszeń przez uczniów
\ No newline at end of file