X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=reminder.py;h=56cf4bc29e6ac475bcb3405ec9dded657d4d1e9e;hb=de9e465a93dde670ac6677f8b036e40d939cc84f;hp=007487f207271c619f6f7a47da6b2e5966160026;hpb=0a372d651f8cdb8ab5f0442060104caef8319f18;p=cavote.git

diff --git a/reminder.py b/reminder.py
index 007487f..56cf4bc 100644
--- a/reminder.py
+++ b/reminder.py
@@ -6,14 +6,14 @@ from datetime import date, datetime, timedelta
 import time
 
 from settings import *
-
+from flaskext.babel import gettext
 
 import sqlite3
 
 conn = sqlite3.connect(DATABASE)
 c = conn.cursor()
 
-for vote in c.execute('select id, id_group, date_end, title from votes where is_open=1 and is_terminated=0'):
+for vote in c.execute('select id, id_group, date_end, title from votes where is_open=1 and is_terminated=0').fetchall():
     date_end_vote = datetime.strptime(vote[2], "%Y-%m-%d")
     date_today = datetime.today()
     date_begin_reminder = date_end_vote + timedelta(days=-3)
@@ -40,43 +40,45 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_
                 BODY = string.join((
                     "From: %s" % EMAIL,
                     "To: %s" % user[1],
-                    "Subject: [Cavote] Vote reminder - You didn't take part to it",
+                    "Subject: [Cavote] %s" % gettext(u"Vote reminder - You didn't take part to it"),
                     "Date: %s" % time.strftime("%a, %d %b %Y %H:%M:%S +0000", time.gmtime()).decode('utf-8'),
+                    "Content-type: text/plain; charset=utf-8",
                     "X-Mailer: %s" % VERSION,
                     "",
-                    "A vote concerns you and is going to terminate on %s : %s" % (vote[2], vote[3]),
-                    "You still didn't take part to it !",
+                    "%s %s : %s" % (gettext(u"A vote concerns you and is going to terminate on"), vote[2], vote[3]),
+                    gettext(u"You still didn't take part to it !"),
                     "",
-                    "This link will bring you to the form where you will be able to participate :",
+                    gettext(u"This link will bring you to the form where you will be able to participate :"),
                     link,
                     "",
-                    "If you think this mail is not for you, please ignore and delete it."
+                    gettext(u"If you think this mail is not for you, please ignore and delete it.")
                     ), "\r\n")
                 server = smtplib.SMTP(SMTP_SERVER)
                 print EMAIL
                 print user[1]
                 print BODY
-                server.sendmail(EMAIL, user[1], BODY)
+                server.sendmail(EMAIL, user[1], BODY.encode('utf-8'))
                 server.quit()
             else:
                 BODY = string.join((
                     "From: %s" % EMAIL,
                     "To: %s" % user[1],
-                    "Subject: [Cavote] Vote reminder - Last days to modify your choice",
+                    "Subject: [Cavote] %s" % gettext(u"Vote reminder - Last days to modify your choice"),
                     "Date: %s" % time.strftime("%a, %d %b %Y %H:%M:%S +0000", time.gmtime()).decode('utf-8'),
+                    "Content-type: text/plain; charset=utf-8",
                     "X-Mailer: %s" % VERSION,
                     "",
-                    "A vote concerns you and is going to terminate on %s : %s" % (vote[2], vote[3]),
-                    "You have already voted by can still modify you choice",
+                    "%s %s : %s" % (gettext(u"A vote concerns you and is going to terminate on "), vote[2], vote[3]),
+                    gettext(u"You have already voted but you can still modify you choice"),
                     "",
-                    "This link will bring you to the form where you will be able to participate :",
+                    gettext(u"This link will bring you to the form where you will be able to participate :"),
                     link,
                     "",
-                    "If you think this mail is not for you, please ignore and delete it."
+                    gettext(u"If you think this mail is not for you, please ignore and delete it.")
                     ), "\r\n")
                 server = smtplib.SMTP(SMTP_SERVER)
                 print EMAIL
                 print user[1]
                 print BODY
-                server.sendmail(EMAIL, user[1], BODY)
+                server.sendmail(EMAIL, user[1], BODY.encode('utf-8'))
                 server.quit()