X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=reminder.py;h=7b7c07fe65de7cb2e3e262c4d479083f15e72176;hb=HEAD;hp=6ebac88a20da19f13c6e087af74ec0902f96b488;hpb=b4a7c4f77721bd665a7e6cf0c15599120b3595e8;p=cavote.git diff --git a/reminder.py b/reminder.py index 6ebac88..7b7c07f 100644 --- a/reminder.py +++ b/reminder.py @@ -32,16 +32,17 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_ for user in c.execute('select users.id, users.email, users.name from users join user_group on users.id=user_group.id_user where user_group.id_group = ?', voting_group).fetchall(): userchoice_request = (user[0], vote[0],) userchoice = c.execute('select * from user_choice join choices on user_choice.id_choice = choices.id where id_user = ? and id_vote = ?', userchoice_request).fetchone() - print "Checking if user %s already voted %s" % (user[1], vote[3]) + print "Checking if user %s already voted %s" % (user[1].encode('utf-8'), vote[3].encode('utf-8')) print userchoice if userchoice is None: #user didn't vote yet - link = "http://vote.ffdn.org/vote/%d" % vote[0] + link = VOTE_URL % vote[0] BODY = string.join(( "From: %s" % EMAIL, "To: %s" % user[1], "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, "", "%s %s : %s" % (gettext(u"A vote concerns you and is going to terminate on"), vote[2], vote[3]), @@ -55,19 +56,21 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_ server = smtplib.SMTP(SMTP_SERVER) print EMAIL print user[1] - print BODY + print BODY.encode('utf-8') server.sendmail(EMAIL, user[1], BODY.encode('utf-8')) server.quit() else: + link = VOTE_URL % vote[0] BODY = string.join(( "From: %s" % EMAIL, "To: %s" % user[1], "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, "", "%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"), + gettext(u"You have already voted but you can still modify your choice"), "", gettext(u"This link will bring you to the form where you will be able to participate :"), link, @@ -77,6 +80,6 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_ server = smtplib.SMTP(SMTP_SERVER) print EMAIL print user[1] - print BODY + print BODY.encode('utf-8') server.sendmail(EMAIL, user[1], BODY.encode('utf-8')) server.quit()