postmodel.py 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199
  1. from django.db import models
  2. from django.db.models import F
  3. from django.db.models.signals import pre_save, pre_delete
  4. from django.utils import timezone
  5. from django.utils.translation import ugettext_lazy as _
  6. from misago.markdown import clear_markdown
  7. from misago.signals import (delete_user_content, merge_post, merge_thread,
  8. move_forum_content, move_post, move_thread,
  9. rename_user, sync_user_profile)
  10. from misago.utils.translation import ugettext_lazy
  11. class PostManager(models.Manager):
  12. def filter_stats(self, start, end):
  13. return self.filter(date__gte=start).filter(date__lte=end)
  14. class Post(models.Model):
  15. forum = models.ForeignKey('Forum')
  16. thread = models.ForeignKey('Thread')
  17. merge = models.PositiveIntegerField(default=0)
  18. user = models.ForeignKey('User', null=True, blank=True, on_delete=models.SET_NULL)
  19. user_name = models.CharField(max_length=255)
  20. ip = models.GenericIPAddressField()
  21. agent = models.CharField(max_length=255)
  22. post = models.TextField()
  23. post_preparsed = models.TextField()
  24. upvotes = models.PositiveIntegerField(default=0)
  25. downvotes = models.PositiveIntegerField(default=0)
  26. mentions = models.ManyToManyField('User', related_name="mention_set")
  27. checkpoints = models.BooleanField(default=False)
  28. date = models.DateTimeField()
  29. edits = models.PositiveIntegerField(default=0)
  30. edit_date = models.DateTimeField(null=True, blank=True)
  31. edit_reason = models.CharField(max_length=255, null=True, blank=True)
  32. edit_user = models.ForeignKey('User', related_name='+', null=True, blank=True, on_delete=models.SET_NULL)
  33. edit_user_name = models.CharField(max_length=255, null=True, blank=True)
  34. edit_user_slug = models.SlugField(max_length=255, null=True, blank=True)
  35. reported = models.BooleanField(default=False, db_index=True)
  36. moderated = models.BooleanField(default=False)
  37. deleted = models.BooleanField(default=False)
  38. protected = models.BooleanField(default=False)
  39. objects = PostManager()
  40. statistics_name = _('New Posts')
  41. class Meta:
  42. app_label = 'misago'
  43. def delete(self, *args, **kwargs):
  44. """
  45. FUGLY HAX for weird stuff that happens with
  46. relations on model deletion in MySQL
  47. """
  48. if self.reported:
  49. self.report_set.update(report_for=None)
  50. return super(Post, self).delete(*args, **kwargs)
  51. def get_date(self):
  52. return self.date
  53. def quote(self):
  54. quote = []
  55. quote.append('@%s' % self.user_name)
  56. for line in self.post.splitlines():
  57. quote.append('> %s' % line)
  58. quote.append('\r\n')
  59. return '\r\n'.join(quote)
  60. @property
  61. def post_clean(self):
  62. return clear_markdown(self.post_preparsed)
  63. def move_to(self, thread):
  64. move_post.send(sender=self, move_to=thread)
  65. self.thread = thread
  66. self.forum = thread.forum
  67. def merge_with(self, post):
  68. post.post = '%s\n- - -\n%s' % (post.post, self.post)
  69. merge_post.send(sender=self, new_post=post)
  70. def set_checkpoint(self, request, action, user=None, forum=None):
  71. if request.user.is_authenticated():
  72. self.checkpoints = True
  73. self.checkpoint_set.create(
  74. forum=self.forum,
  75. thread=self.thread,
  76. post=self,
  77. action=action,
  78. user=request.user,
  79. user_name=request.user.username,
  80. user_slug=request.user.username_slug,
  81. date=timezone.now(),
  82. ip=request.session.get_ip(request),
  83. agent=request.META.get('HTTP_USER_AGENT'),
  84. target_user=user,
  85. target_user_name=(user.username if user else None),
  86. target_user_slug=(user.username_slug if user else None),
  87. old_forum=forum,
  88. old_forum_name=(forum.name if forum else None),
  89. old_forum_slug=(forum.slug if forum else None),
  90. )
  91. def notify_mentioned(self, request, thread_type, users):
  92. from misago.acl.builder import acl
  93. from misago.acl.exceptions import ACLError403, ACLError404
  94. mentioned = self.mentions.all()
  95. for slug, user in users.items():
  96. if user.pk != request.user.pk and user not in mentioned:
  97. self.mentions.add(user)
  98. try:
  99. acl = acl(request, user)
  100. acl.forums.allow_forum_view(self.forum)
  101. acl.threads.allow_thread_view(user, self.thread)
  102. acl.threads.allow_post_view(user, self.thread, self)
  103. if not user.is_ignoring(request.user):
  104. alert = user.alert(ugettext_lazy("%(username)s has mentioned you in his reply in thread %(thread)s").message)
  105. alert.profile('username', request.user)
  106. alert.post('thread', thread_type, self.thread, self)
  107. alert.save_all()
  108. except (ACLError403, ACLError404):
  109. pass
  110. def is_reported(self):
  111. self.reported = self.report_set.filter(weight=2).count() > 0
  112. def live_report(self):
  113. try:
  114. return self.report_set.filter(weight=2)[0]
  115. except IndexError:
  116. return None
  117. def rename_user_handler(sender, **kwargs):
  118. Post.objects.filter(user=sender).update(
  119. user_name=sender.username,
  120. )
  121. Post.objects.filter(edit_user=sender).update(
  122. edit_user_name=sender.username,
  123. edit_user_slug=sender.username_slug,
  124. )
  125. rename_user.connect(rename_user_handler, dispatch_uid="rename_user_posts")
  126. def delete_user_content_handler(sender, **kwargs):
  127. from misago.models import Thread
  128. threads = []
  129. prev_posts = []
  130. for post in sender.post_set.filter(checkpoints=True):
  131. threads.append(post.thread_id)
  132. prev_post = Post.objects.filter(thread=post.thread_id).exclude(merge__gt=post.merge).exclude(user=sender).order_by('merge', '-id')[:1][0]
  133. post.checkpoint_set.update(post=prev_post)
  134. if not prev_post.pk in prev_posts:
  135. prev_posts.append(prev_post.pk)
  136. sender.post_set.all().delete()
  137. Post.objects.filter(id__in=prev_posts).update(checkpoints=True)
  138. for post in sender.post_set.distinct().values('thread_id').iterator():
  139. if not post['thread_id'] in threads:
  140. threads.append(post['thread_id'])
  141. for post in Post.objects.filter(user=sender):
  142. post.delete()
  143. for thread in Thread.objects.filter(id__in=threads):
  144. thread.sync()
  145. thread.save(force_update=True)
  146. delete_user_content.connect(delete_user_content_handler, dispatch_uid="delete_user_posts")
  147. def move_forum_content_handler(sender, **kwargs):
  148. Post.objects.filter(forum=sender).update(forum=kwargs['move_to'])
  149. move_forum_content.connect(move_forum_content_handler, dispatch_uid="move_forum_posts")
  150. def move_thread_handler(sender, **kwargs):
  151. Post.objects.filter(thread=sender).update(forum=kwargs['move_to'])
  152. move_thread.connect(move_thread_handler, dispatch_uid="move_thread_posts")
  153. def merge_thread_handler(sender, **kwargs):
  154. Post.objects.filter(thread=sender).update(thread=kwargs['new_thread'], merge=F('merge') + kwargs['merge'])
  155. merge_thread.connect(merge_thread_handler, dispatch_uid="merge_threads_posts")
  156. def sync_user_handler(sender, **kwargs):
  157. sender.posts = sender.post_set.count()
  158. sync_user_profile.connect(sync_user_handler, dispatch_uid="sync_user_posts")