threadmodel.py 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214
  1. from datetime import timedelta
  2. from django.conf import settings
  3. from django.db import models
  4. from django.db.models.signals import pre_delete
  5. from django.utils import timezone
  6. from django.utils.translation import ugettext_lazy as _
  7. from misago.signals import (delete_user_content, merge_thread, move_forum_content,
  8. move_thread, rename_user, sync_user_profile)
  9. from misago.utils.strings import slugify
  10. class ThreadManager(models.Manager):
  11. def filter_stats(self, start, end):
  12. return self.filter(start__gte=start).filter(start__lte=end)
  13. def with_reads(self, queryset, user):
  14. from misago.models import ForumRead, ThreadRead
  15. threads = []
  16. threads_dict = {}
  17. forum_reads = {}
  18. cutoff = timezone.now() - timedelta(days=settings.READS_TRACKER_LENGTH)
  19. if user.is_authenticated() and user.join_date > cutoff:
  20. cutoff = user.join_date
  21. for row in ForumRead.objects.filter(user=user).values('forum_id', 'cleared'):
  22. forum_reads[row['forum_id']] = row['cleared']
  23. for thread in queryset:
  24. thread.is_read = True
  25. if user.is_authenticated() and thread.last > cutoff:
  26. try:
  27. thread.is_read = thread.last <= forum_reads[thread.forum_id]
  28. except KeyError:
  29. pass
  30. threads.append(thread)
  31. threads_dict[thread.pk] = thread
  32. if user.is_authenticated():
  33. for read in ThreadRead.objects.filter(user=user).filter(thread__in=threads_dict.keys()):
  34. try:
  35. threads_dict[read.thread_id].is_read = (threads_dict[read.thread_id].last <= cutoff or
  36. threads_dict[read.thread_id].last <= read.updated or
  37. threads_dict[read.thread_id].last <= forum_reads[read.forum_id])
  38. except KeyError:
  39. pass
  40. return threads
  41. class Thread(models.Model):
  42. forum = models.ForeignKey('Forum')
  43. weight = models.PositiveIntegerField(default=0)
  44. name = models.CharField(max_length=255)
  45. slug = models.SlugField(max_length=255)
  46. replies = models.PositiveIntegerField(default=0)
  47. replies_reported = models.PositiveIntegerField(default=0)
  48. replies_moderated = models.PositiveIntegerField(default=0)
  49. replies_deleted = models.PositiveIntegerField(default=0)
  50. merges = models.PositiveIntegerField(default=0)
  51. score = models.PositiveIntegerField(default=30)
  52. upvotes = models.PositiveIntegerField(default=0)
  53. downvotes = models.PositiveIntegerField(default=0)
  54. start = models.DateTimeField()
  55. start_post = models.ForeignKey('Post', related_name='+', null=True, blank=True, on_delete=models.SET_NULL)
  56. start_poster = models.ForeignKey('User', null=True, blank=True, on_delete=models.SET_NULL)
  57. start_poster_name = models.CharField(max_length=255)
  58. start_poster_slug = models.SlugField(max_length=255)
  59. start_poster_style = models.CharField(max_length=255, null=True, blank=True)
  60. last = models.DateTimeField()
  61. last_post = models.ForeignKey('Post', related_name='+', null=True, blank=True, on_delete=models.SET_NULL)
  62. last_poster = models.ForeignKey('User', related_name='+', null=True, blank=True, on_delete=models.SET_NULL)
  63. last_poster_name = models.CharField(max_length=255, null=True, blank=True)
  64. last_poster_slug = models.SlugField(max_length=255, null=True, blank=True)
  65. last_poster_style = models.CharField(max_length=255, null=True, blank=True)
  66. participants = models.ManyToManyField('User', related_name='private_thread_set')
  67. moderated = models.BooleanField(default=False)
  68. deleted = models.BooleanField(default=False)
  69. closed = models.BooleanField(default=False)
  70. objects = ThreadManager()
  71. statistics_name = _('New Threads')
  72. class Meta:
  73. app_label = 'misago'
  74. def get_date(self):
  75. return self.start
  76. def new_start_post(self, post):
  77. self.start = post.date
  78. self.start_post = post
  79. self.start_poster = post.user
  80. self.start_poster_name = post.user.username
  81. self.start_poster_slug = post.user.username_slug
  82. if post.user.rank_id and post.user.rank.style:
  83. self.start_poster_style = post.user.rank.style
  84. def new_last_post(self, post):
  85. self.last = post.date
  86. self.last_post = post
  87. self.last_poster = post.user
  88. self.last_poster_name = post.user.username
  89. self.last_poster_slug = post.user.username_slug
  90. if post.user.rank_id and post.user.rank.style:
  91. self.last_poster_style = post.user.rank.style
  92. def move_to(self, move_to):
  93. move_thread.send(sender=self, move_to=move_to)
  94. self.forum = move_to
  95. def merge_with(self, thread, merge):
  96. merge_thread.send(sender=self, new_thread=thread, merge=merge)
  97. def sync(self):
  98. # Counters
  99. self.replies = self.post_set.filter(moderated=False).count() - 1
  100. if self.replies < 0:
  101. self.replies = 0
  102. self.replies_reported = self.post_set.filter(reported=True).count()
  103. self.replies_moderated = self.post_set.filter(moderated=True).count()
  104. self.replies_deleted = self.post_set.filter(deleted=True).count()
  105. # First post
  106. start_post = self.post_set.order_by('merge', 'id')[0:][0]
  107. self.start = start_post.date
  108. self.start_post = start_post
  109. self.start_poster = start_post.user
  110. self.start_poster_name = start_post.user_name
  111. self.start_poster_slug = slugify(start_post.user_name)
  112. self.start_poster_style = start_post.user.rank.style if start_post.user and start_post.user.rank else ''
  113. self.upvotes = start_post.upvotes
  114. self.downvotes = start_post.downvotes
  115. # Last visible post
  116. if self.replies > 0:
  117. last_post = self.post_set.order_by('-merge', '-id').filter(moderated=False)[0:][0]
  118. else:
  119. last_post = start_post
  120. self.last = last_post.date
  121. self.last_post = last_post
  122. self.last_poster = last_post.user
  123. self.last_poster_name = last_post.user_name
  124. self.last_poster_slug = slugify(last_post.user_name)
  125. self.last_poster_style = last_post.user.rank.style if last_post.user and last_post.user.rank else ''
  126. # Flags
  127. self.moderated = start_post.moderated
  128. self.deleted = start_post.deleted
  129. self.merges = last_post.merge
  130. def email_watchers(self, request, thread_type, post):
  131. from misago.acl.builder import acl
  132. from misago.acl.exceptions import ACLError403, ACLError404
  133. from misago.models import ThreadRead, WatchedThread
  134. for watch in WatchedThread.objects.filter(thread=self).filter(email=True).filter(last_read__gte=self.previous_last):
  135. user = watch.user
  136. if user.pk != request.user.pk:
  137. try:
  138. user_acl = acl(request, user)
  139. user_acl.forums.allow_forum_view(self.forum)
  140. user_acl.threads.allow_thread_view(user, self)
  141. user_acl.threads.allow_post_view(user, self, post)
  142. if not user.is_ignoring(request.user):
  143. user.email_user(
  144. request,
  145. '%s_reply_notification' % thread_type,
  146. _('New reply in thread "%(thread)s"') % {'thread': self.name},
  147. {'author': request.user, 'post': post, 'thread': self}
  148. )
  149. except (ACLError403, ACLError404):
  150. pass
  151. def rename_user_handler(sender, **kwargs):
  152. Thread.objects.filter(start_poster=sender).update(
  153. start_poster_name=sender.username,
  154. start_poster_slug=sender.username_slug,
  155. )
  156. Thread.objects.filter(last_poster=sender).update(
  157. last_poster_name=sender.username,
  158. last_poster_slug=sender.username_slug,
  159. )
  160. rename_user.connect(rename_user_handler, dispatch_uid="rename_user_threads")
  161. def delete_user_content_handler(sender, **kwargs):
  162. for thread in Thread.objects.filter(start_poster=sender):
  163. thread.delete()
  164. delete_user_content.connect(delete_user_content_handler, dispatch_uid="delete_user_threads")
  165. def move_forum_content_handler(sender, **kwargs):
  166. Thread.objects.filter(forum=sender).update(forum=kwargs['move_to'])
  167. move_forum_content.connect(move_forum_content_handler, dispatch_uid="move_forum_threads")
  168. def delete_user_handler(sender, instance, using, **kwargs):
  169. from misago.models import User
  170. if sender == User:
  171. for thread in instance.private_thread_set.all():
  172. thread.participants.remove(instance)
  173. if not thread.participants.count():
  174. thread.delete()
  175. pre_delete.connect(delete_user_handler, dispatch_uid="delete_user_participations")
  176. def sync_user_handler(sender, **kwargs):
  177. sender.threads = sender.thread_set.count()
  178. sync_user_profile.connect(sync_user_handler, dispatch_uid="sync_user_threads")