1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
from django.core.management.base import NoArgsCommand
from django.db.models import Q
from django.template.loader import get_template
from askbot import models
from askbot import const
from askbot.conf import settings as askbot_settings
from django.utils.translation import ungettext
from askbot import mail
from askbot.utils.classes import ReminderSchedule
from askbot.models.question import Thread
from askbot.utils.html import site_url
from django.template import Context
DEBUG_THIS_COMMAND = False
class Command(NoArgsCommand):
"""management command that sends reminders
about unanswered questions to all users
"""
def handle_noargs(self, **options):
if askbot_settings.ENABLE_EMAIL_ALERTS == False:
return
if askbot_settings.ENABLE_UNANSWERED_REMINDERS == False:
return
#get questions without answers, excluding closed and deleted
#order it by descending added_at date
schedule = ReminderSchedule(
askbot_settings.DAYS_BEFORE_SENDING_UNANSWERED_REMINDER,
askbot_settings.UNANSWERED_REMINDER_FREQUENCY,
max_reminders = askbot_settings.MAX_UNANSWERED_REMINDERS
)
questions = models.Post.objects.get_questions()
#we don't report closed, deleted or moderation queue questions
exclude_filter = Q(thread__closed=True) | Q(deleted=True)
if askbot_settings.CONTENT_MODERATION_MODE == 'premoderation':
exclude_filter |= Q(approved=False)
questions = questions.exclude(exclude_filter)
#select questions within the range of the reminder schedule
questions = questions.added_between(
start=schedule.start_cutoff_date,
end=schedule.end_cutoff_date
)
#take only questions with zero answers
questions = questions.filter(thread__answer_count=0)
if questions.count() == 0:
#nothing to do
return
questions = questions.order_by('-added_at')
if askbot_settings.UNANSWERED_REMINDER_RECIPIENTS == 'admins':
recipient_statuses = ('d', 'm')
else:
recipient_statuses = ('a', 'w', 'd', 'm')
#for all users, excluding blocked
#for each user, select a tag filtered subset
#format the email reminder and send it
for user in models.User.objects.filter(status__in=recipient_statuses):
user_questions = questions.exclude(author=user)
user_questions = user.get_tag_filtered_questions(user_questions)
if askbot_settings.GROUPS_ENABLED:
user_groups = user.get_groups()
user_questions = user_questions.filter(groups__in = user_groups)
final_question_list = user_questions.get_questions_needing_reminder(
user = user,
activity_type = const.TYPE_ACTIVITY_UNANSWERED_REMINDER_SENT,
recurrence_delay = schedule.recurrence_delay
)
question_count = len(final_question_list)
if question_count == 0:
continue
threads = Thread.objects.filter(id__in=[qq.thread_id for qq in final_question_list])
tag_summary = Thread.objects.get_tag_summary_from_threads(threads)
if question_count == 1:
unanswered_questions_phrase = askbot_settings.WORDS_UNANSWERED_QUESTION_SINGULAR
else:
unanswered_questions_phrase = askbot_settings.WORDS_UNANSWERED_QUESTION_PLURAL
subject_line = ungettext(
'%(question_count)d %(unanswered_questions)s about %(topics)s',
'%(question_count)d %(unanswered_questions)s about %(topics)s',
question_count
) % {
'question_count': question_count,
'unanswered_questions': unanswered_questions_phrase,
'topics': tag_summary
}
data = {
'site_url': site_url(''),
'questions': final_question_list,
'subject_line': subject_line
}
template = get_template('email/unanswered_question_reminder.html')
body_text = template.render(Context(data))#todo: set lang
if DEBUG_THIS_COMMAND:
print "User: %s<br>\nSubject:%s<br>\nText: %s<br>\n" % \
(user.email, subject_line, body_text)
else:
mail.send_mail(
subject_line = subject_line,
body_text = body_text,
recipient_list = (user.email,)
)
|