thread.py 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287
  1. from django.core.exceptions import ObjectDoesNotExist
  2. from django.db import models
  3. from django.utils import timezone
  4. from django.utils.translation import gettext_lazy as _
  5. from misago.conf import settings
  6. from misago.core.pgutils import PgPartialIndex
  7. from misago.core.utils import slugify
  8. class Thread(models.Model):
  9. WEIGHT_DEFAULT = 0
  10. WEIGHT_PINNED = 1
  11. WEIGHT_GLOBAL = 2
  12. WEIGHT_CHOICES = [
  13. (WEIGHT_DEFAULT, _("Don't pin thread")),
  14. (WEIGHT_PINNED, _("Pin thread within category")),
  15. (WEIGHT_GLOBAL, _("Pin thread globally")),
  16. ]
  17. category = models.ForeignKey("misago_categories.Category", on_delete=models.CASCADE)
  18. title = models.CharField(max_length=255)
  19. slug = models.CharField(max_length=255)
  20. replies = models.PositiveIntegerField(default=0, db_index=True)
  21. has_events = models.BooleanField(default=False)
  22. has_poll = models.BooleanField(default=False)
  23. has_reported_posts = models.BooleanField(default=False)
  24. has_open_reports = models.BooleanField(default=False)
  25. has_unapproved_posts = models.BooleanField(default=False)
  26. has_hidden_posts = models.BooleanField(default=False)
  27. started_on = models.DateTimeField(db_index=True)
  28. last_post_on = models.DateTimeField(db_index=True)
  29. first_post = models.ForeignKey(
  30. "misago_threads.Post",
  31. related_name="+",
  32. null=True,
  33. blank=True,
  34. on_delete=models.SET_NULL,
  35. )
  36. starter = models.ForeignKey(
  37. settings.AUTH_USER_MODEL, null=True, blank=True, on_delete=models.SET_NULL
  38. )
  39. starter_name = models.CharField(max_length=255)
  40. starter_slug = models.CharField(max_length=255)
  41. last_post = models.ForeignKey(
  42. "misago_threads.Post",
  43. related_name="+",
  44. null=True,
  45. blank=True,
  46. on_delete=models.SET_NULL,
  47. )
  48. last_post_is_event = models.BooleanField(default=False)
  49. last_poster = models.ForeignKey(
  50. settings.AUTH_USER_MODEL,
  51. related_name="last_poster_set",
  52. null=True,
  53. blank=True,
  54. on_delete=models.SET_NULL,
  55. )
  56. last_poster_name = models.CharField(max_length=255, null=True, blank=True)
  57. last_poster_slug = models.CharField(max_length=255, null=True, blank=True)
  58. weight = models.PositiveIntegerField(default=WEIGHT_DEFAULT)
  59. is_unapproved = models.BooleanField(default=False, db_index=True)
  60. is_hidden = models.BooleanField(default=False)
  61. is_closed = models.BooleanField(default=False)
  62. best_answer = models.ForeignKey(
  63. "misago_threads.Post",
  64. related_name="+",
  65. null=True,
  66. blank=True,
  67. on_delete=models.SET_NULL,
  68. )
  69. best_answer_is_protected = models.BooleanField(default=False)
  70. best_answer_marked_on = models.DateTimeField(null=True, blank=True)
  71. best_answer_marked_by = models.ForeignKey(
  72. settings.AUTH_USER_MODEL,
  73. related_name="marked_best_answer_set",
  74. null=True,
  75. blank=True,
  76. on_delete=models.SET_NULL,
  77. )
  78. best_answer_marked_by_name = models.CharField(max_length=255, null=True, blank=True)
  79. best_answer_marked_by_slug = models.CharField(max_length=255, null=True, blank=True)
  80. participants = models.ManyToManyField(
  81. settings.AUTH_USER_MODEL,
  82. related_name="privatethread_set",
  83. through="ThreadParticipant",
  84. through_fields=("thread", "user"),
  85. )
  86. class Meta:
  87. indexes = [
  88. PgPartialIndex(fields=["weight"], where={"weight": 2}),
  89. PgPartialIndex(fields=["weight"], where={"weight": 1}),
  90. PgPartialIndex(fields=["weight"], where={"weight": 0}),
  91. PgPartialIndex(fields=["weight"], where={"weight__lt": 2}),
  92. PgPartialIndex(
  93. fields=["has_reported_posts"], where={"has_reported_posts": True}
  94. ),
  95. PgPartialIndex(
  96. fields=["has_unapproved_posts"], where={"has_unapproved_posts": True}
  97. ),
  98. PgPartialIndex(fields=["is_hidden"], where={"is_hidden": False}),
  99. ]
  100. index_together = [
  101. ["category", "id"],
  102. ["category", "last_post_on"],
  103. ["category", "replies"],
  104. ]
  105. def __str__(self):
  106. return self.title
  107. def delete(self, *args, **kwargs):
  108. from misago.threads.signals import delete_thread
  109. delete_thread.send(sender=self)
  110. super().delete(*args, **kwargs)
  111. def merge(self, other_thread):
  112. if self.pk == other_thread.pk:
  113. raise ValueError("thread can't be merged with itself")
  114. from misago.threads.signals import merge_thread
  115. merge_thread.send(sender=self, other_thread=other_thread)
  116. def move(self, new_category):
  117. from misago.threads.signals import move_thread
  118. self.category = new_category
  119. move_thread.send(sender=self)
  120. def synchronize(self):
  121. try:
  122. self.has_poll = bool(self.poll)
  123. except ObjectDoesNotExist:
  124. self.has_poll = False
  125. self.replies = self.post_set.filter(is_event=False, is_unapproved=False).count()
  126. if self.replies > 0:
  127. self.replies -= 1
  128. reported_post_qs = self.post_set.filter(has_reports=True)
  129. self.has_reported_posts = reported_post_qs.exists()
  130. if self.has_reported_posts:
  131. open_reports_qs = self.post_set.filter(has_open_reports=True)
  132. self.has_open_reports = open_reports_qs.exists()
  133. else:
  134. self.has_open_reports = False
  135. unapproved_post_qs = self.post_set.filter(is_unapproved=True)
  136. self.has_unapproved_posts = unapproved_post_qs.exists()
  137. hidden_post_qs = self.post_set.filter(is_hidden=True)[:1]
  138. self.has_hidden_posts = hidden_post_qs.exists()
  139. posts = self.post_set.order_by("id")
  140. first_post = posts.first()
  141. self.set_first_post(first_post)
  142. last_post = posts.filter(is_unapproved=False).last()
  143. if last_post:
  144. self.set_last_post(last_post)
  145. else:
  146. self.set_last_post(first_post)
  147. self.has_events = False
  148. if last_post:
  149. if last_post.is_event:
  150. self.has_events = True
  151. else:
  152. self.has_events = self.post_set.filter(is_event=True).exists()
  153. @property
  154. def has_best_answer(self):
  155. return bool(self.best_answer_id)
  156. @property
  157. def thread_type(self):
  158. return self.category.thread_type
  159. def get_api_url(self):
  160. return self.thread_type.get_thread_api_url(self)
  161. def get_editor_api_url(self):
  162. return self.thread_type.get_thread_editor_api_url(self)
  163. def get_merge_api_url(self):
  164. return self.thread_type.get_thread_merge_api_url(self)
  165. def get_posts_api_url(self):
  166. return self.thread_type.get_thread_posts_api_url(self)
  167. def get_post_merge_api_url(self):
  168. return self.thread_type.get_post_merge_api_url(self)
  169. def get_post_move_api_url(self):
  170. return self.thread_type.get_post_move_api_url(self)
  171. def get_post_split_api_url(self):
  172. return self.thread_type.get_post_split_api_url(self)
  173. def get_poll_api_url(self):
  174. return self.thread_type.get_thread_poll_api_url(self)
  175. def get_absolute_url(self, page=1):
  176. return self.thread_type.get_thread_absolute_url(self, page)
  177. def get_new_post_url(self):
  178. return self.thread_type.get_thread_new_post_url(self)
  179. def get_last_post_url(self):
  180. return self.thread_type.get_thread_last_post_url(self)
  181. def get_best_answer_url(self):
  182. return self.thread_type.get_thread_best_answer_url(self)
  183. def get_unapproved_post_url(self):
  184. return self.thread_type.get_thread_unapproved_post_url(self)
  185. def set_title(self, title):
  186. self.title = title
  187. self.slug = slugify(title)
  188. def set_first_post(self, post):
  189. self.started_on = post.posted_on
  190. self.first_post = post
  191. self.starter = post.poster
  192. self.starter_name = post.poster_name
  193. if post.poster:
  194. self.starter_slug = post.poster.slug
  195. else:
  196. self.starter_slug = slugify(post.poster_name)
  197. self.is_unapproved = post.is_unapproved
  198. self.is_hidden = post.is_hidden
  199. def set_last_post(self, post):
  200. self.last_post_on = post.posted_on
  201. self.last_post_is_event = post.is_event
  202. self.last_post = post
  203. self.last_poster = post.poster
  204. self.last_poster_name = post.poster_name
  205. if post.poster:
  206. self.last_poster_slug = post.poster.slug
  207. else:
  208. self.last_poster_slug = slugify(post.poster_name)
  209. def set_best_answer(self, user, post):
  210. if post.thread_id != self.id:
  211. raise ValueError("post to set as best answer must be in same thread")
  212. if post.is_first_post:
  213. raise ValueError("post to set as best answer can't be first post")
  214. if post.is_hidden:
  215. raise ValueError("post to set as best answer can't be hidden")
  216. if post.is_unapproved:
  217. raise ValueError("post to set as best answer can't be unapproved")
  218. self.best_answer = post
  219. self.best_answer_is_protected = post.is_protected
  220. self.best_answer_marked_on = timezone.now()
  221. self.best_answer_marked_by = user
  222. self.best_answer_marked_by_name = user.username
  223. self.best_answer_marked_by_slug = user.slug
  224. def clear_best_answer(self):
  225. self.best_answer = None
  226. self.best_answer_is_protected = False
  227. self.best_answer_marked_on = None
  228. self.best_answer_marked_by = None
  229. self.best_answer_marked_by_name = None
  230. self.best_answer_marked_by_slug = None