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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
|
from django.conf import settings
from django.contrib.auth.models import User
from django.core.paginator import Paginator, EmptyPage, PageNotAnInteger
from django.db.models import Q, Max, Count
from core.letters.models import Conversation, Letter, LetterAttachment
def get_or_create_conversation(user_a, user_b):
if user_a == user_b:
return False, "You cannot start a conversation with yourself."
p1, p2 = (user_a, user_b) if user_a.pk < user_b.pk else (user_b, user_a)
conversation, created = Conversation.objects.get_or_create(
participant_one=p1,
participant_two=p2,
)
return True, conversation
def send_letter(sender, conversation, content):
content = content.strip()
if sender not in (conversation.participant_one, conversation.participant_two):
return False, "You are not a participant in this conversation."
has_attachments = LetterAttachment.objects.filter(
conversation=conversation,
uploader=sender,
letter__isnull=True,
).exists()
if not content and not has_attachments:
return False, "Letter content is required."
letter = Letter.objects.create(
conversation=conversation,
sender=sender,
content=content,
)
link_attachments_to_letter(sender, conversation, letter)
conversation.save(update_fields=["updated_at"])
return True, letter
def get_user_inbox(user, page=1):
per_page = settings.LETTERS_INBOX_PER_PAGE
conversations = (
Conversation.objects.filter(
Q(participant_one=user) | Q(participant_two=user)
)
.select_related("participant_one", "participant_two")
.prefetch_related(
"participant_one__userprofile_set",
"participant_two__userprofile_set",
)
.annotate(
last_letter_time=Max("letters__created_at"),
unread_count=Count(
"letters",
filter=Q(letters__is_read=False) & ~Q(letters__sender=user),
),
)
.order_by("-updated_at")
)
paginator = Paginator(conversations, per_page)
try:
page_obj = paginator.page(page)
except PageNotAnInteger:
page_obj = paginator.page(1)
except EmptyPage:
page_obj = paginator.page(paginator.num_pages)
for conv in page_obj:
conv.last_letter = (
conv.letters.select_related("sender")
.prefetch_related("attachments")
.order_by("-created_at")
.first()
)
conv.other_user = conv.get_other_participant(user)
return True, page_obj
def get_conversation_letters(user, other_username, before_id=None):
batch_size = settings.LETTERS_BATCH_SIZE
other_user = User.objects.filter(username__iexact=other_username).first()
if not other_user:
return False, "User not found.", None
p1, p2 = (user, other_user) if user.pk < other_user.pk else (other_user, user)
conversation = (
Conversation.objects.filter(participant_one=p1, participant_two=p2)
.select_related("participant_one", "participant_two")
.first()
)
if not conversation:
conversation = Conversation(participant_one=p1, participant_two=p2)
conversation.other_user = other_user
return True, conversation, {"letters": [], "has_more": False}
Letter.objects.filter(
conversation=conversation,
is_read=False,
).exclude(sender=user).update(is_read=True)
letters_qs = conversation.letters.select_related("sender").prefetch_related("attachments")
if before_id:
letters_qs = letters_qs.filter(pk__lt=before_id)
letters = list(letters_qs.order_by("-created_at")[: batch_size + 1])
has_more = len(letters) > batch_size
letters = letters[:batch_size]
# Reverse so they display oldest-first
letters.reverse()
conversation.other_user = conversation.get_other_participant(user)
return True, conversation, {"letters": letters, "has_more": has_more}
def get_total_unread_count(user):
return Letter.objects.filter(
conversation__in=Conversation.objects.filter(
Q(participant_one=user) | Q(participant_two=user)
),
is_read=False,
).exclude(sender=user).count()
def find_user_by_username(username):
user = User.objects.filter(username__iexact=username.strip()).first()
if not user:
return False, "User not found."
return True, user
def upload_attachment(user, conversation, file):
if user not in (conversation.participant_one, conversation.participant_two):
return False, "You are not a participant in this conversation."
if file.size > settings.LETTERS_MAX_ATTACHMENT_SIZE:
return False, "File too large."
pending_count = LetterAttachment.objects.filter(
conversation=conversation,
uploader=user,
letter__isnull=True,
).count()
if pending_count >= settings.LETTERS_MAX_ATTACHMENTS:
return False, "Too many attachments."
attachment = LetterAttachment.objects.create(
uploader=user,
conversation=conversation,
file=file,
original_name=file.name,
file_size=file.size,
content_type=file.content_type or "application/octet-stream",
)
return True, attachment
def remove_attachment(user, attachment_id):
attachment = LetterAttachment.objects.filter(
pk=attachment_id,
uploader=user,
letter__isnull=True,
).first()
if not attachment:
return False, "Attachment not found."
attachment.delete()
return True, None
def link_attachments_to_letter(user, conversation, letter):
LetterAttachment.objects.filter(
conversation=conversation,
uploader=user,
letter__isnull=True,
).update(letter=letter)
def get_conversation_by_users(user, other_user):
if user == other_user:
return None
p1, p2 = (user, other_user) if user.pk < other_user.pk else (other_user, user)
return Conversation.objects.filter(
participant_one=p1, participant_two=p2
).first()
def has_pending_attachments(user, conversation):
return LetterAttachment.objects.filter(
conversation=conversation,
uploader=user,
letter__isnull=True,
).exists()
def get_letter_attachments(letter):
return [
{
"url": att.file.url,
"original_name": att.original_name,
"content_type": att.content_type,
}
for att in letter.attachments.all()
]
def mark_letters_read(user, conversation):
Letter.objects.filter(
conversation=conversation,
is_read=False,
).exclude(sender=user).update(is_read=True)
|
