thread.py 9.0 KB

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