models.py 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199
  1. from django.conf import settings
  2. from django.core.cache import cache
  3. from django.db import models
  4. from django.utils.translation import ugettext_lazy as _
  5. from mptt.models import MPTTModel, TreeForeignKey
  6. from misago.roles.models import Role
  7. from misago.users.signals import rename_user
  8. class ForumManager(models.Manager):
  9. forums_tree = None
  10. def token_to_pk(self, token):
  11. self.populate_tree()
  12. try:
  13. return self.forums_tree[token].pk
  14. except KeyError:
  15. return 0
  16. def populate_tree(self, force=False):
  17. if not self.forums_tree:
  18. self.forums_tree = cache.get('forums_tree')
  19. if not self.forums_tree or force:
  20. self.forums_tree = {}
  21. for forum in Forum.objects.order_by('lft'):
  22. self.forums_tree[forum.pk] = forum
  23. if forum.token:
  24. self.forums_tree[forum.token] = forum
  25. cache.set('forums_tree', self.forums_tree)
  26. def forum_parents(self, forum, include_self=False):
  27. self.populate_tree()
  28. parents = []
  29. parent = self.forums_tree[forum]
  30. if include_self:
  31. parents.append(parent)
  32. while parent.level > 1:
  33. parent = self.forums_tree[parent.parent_id]
  34. parents.append(parent)
  35. return reversed(parents)
  36. def parents_aware_forum(self, forum):
  37. self.populate_tree()
  38. proxy = Forum()
  39. try:
  40. proxy.id = forum.pk
  41. proxy.pk = forum.pk
  42. except AttributeError:
  43. proxy.id = forum
  44. proxy.pk = forum
  45. proxy.closed = False
  46. for parent in self.forum_parents(proxy.pk):
  47. if parent.closed:
  48. proxy.closed = True
  49. return proxy
  50. return proxy
  51. def treelist(self, acl, parent=None, tracker=None):
  52. complete_list = []
  53. forums_list = []
  54. parents = {}
  55. if parent:
  56. queryset = Forum.objects.filter(pk__in=acl.known_forums).filter(lft__gt=parent.lft).filter(rght__lt=parent.rght).order_by('lft')
  57. else:
  58. queryset = Forum.objects.filter(pk__in=acl.known_forums).order_by('lft')
  59. for forum in queryset:
  60. forum.subforums = []
  61. forum.is_read = False
  62. if tracker:
  63. forum.is_read = tracker.is_read(forum)
  64. parents[forum.pk] = forum
  65. complete_list.append(forum)
  66. if forum.parent_id in parents:
  67. parents[forum.parent_id].subforums.append(forum)
  68. else:
  69. forums_list.append(forum)
  70. # Second iteration - sum up forum counters
  71. for forum in reversed(complete_list):
  72. if forum.parent_id in parents and parents[forum.parent_id].type != 'redirect':
  73. parents[forum.parent_id].threads += forum.threads
  74. parents[forum.parent_id].threads_delta += forum.threads_delta
  75. parents[forum.parent_id].posts += forum.posts
  76. parents[forum.parent_id].posts_delta += forum.posts_delta
  77. if acl.can_browse(forum.pk):
  78. # If forum is unread, make parent unread too
  79. if not forum.is_read:
  80. parents[forum.parent_id].is_read = False
  81. # Sum stats
  82. if forum.last_thread_date and (not parents[forum.parent_id].last_thread_date or forum.last_thread_date > parents[forum.parent_id].last_thread_date):
  83. parents[forum.parent_id].last_thread_id = forum.last_thread_id
  84. parents[forum.parent_id].last_thread_name = forum.last_thread_name
  85. parents[forum.parent_id].last_thread_slug = forum.last_thread_slug
  86. parents[forum.parent_id].last_thread_date = forum.last_thread_date
  87. parents[forum.parent_id].last_poster_id = forum.last_poster_id
  88. parents[forum.parent_id].last_poster_name = forum.last_poster_name
  89. parents[forum.parent_id].last_poster_slug = forum.last_poster_slug
  90. parents[forum.parent_id].last_poster_style = forum.last_poster_style
  91. return forums_list
  92. class Forum(MPTTModel):
  93. parent = TreeForeignKey('self', null=True, blank=True, related_name='children')
  94. type = models.CharField(max_length=12)
  95. token = models.CharField(max_length=255, null=True, blank=True)
  96. name = models.CharField(max_length=255)
  97. slug = models.SlugField(max_length=255)
  98. description = models.TextField(null=True, blank=True)
  99. description_preparsed = models.TextField(null=True, blank=True)
  100. threads = models.PositiveIntegerField(default=0)
  101. threads_delta = models.PositiveIntegerField(default=0)
  102. posts = models.PositiveIntegerField(default=0)
  103. posts_delta = models.IntegerField(default=0)
  104. redirects = models.PositiveIntegerField(default=0)
  105. redirects_delta = models.IntegerField(default=0)
  106. last_thread = models.ForeignKey('threads.Thread', related_name='+', null=True, blank=True, on_delete=models.SET_NULL)
  107. last_thread_name = models.CharField(max_length=255, null=True, blank=True)
  108. last_thread_slug = models.SlugField(max_length=255, null=True, blank=True)
  109. last_thread_date = models.DateTimeField(null=True, blank=True)
  110. last_poster = models.ForeignKey('users.User', related_name='+', null=True, blank=True, on_delete=models.SET_NULL)
  111. last_poster_name = models.CharField(max_length=255, null=True, blank=True)
  112. last_poster_slug = models.SlugField(max_length=255, null=True, blank=True)
  113. last_poster_style = models.CharField(max_length=255, null=True, blank=True)
  114. prune_start = models.PositiveIntegerField(default=0)
  115. prune_last = models.PositiveIntegerField(default=0)
  116. redirect = models.CharField(max_length=255, null=True, blank=True)
  117. template = models.CharField(default='row', max_length=255, null=True, blank=True)
  118. show_details = models.BooleanField(default=True)
  119. style = models.CharField(max_length=255, null=True, blank=True)
  120. closed = models.BooleanField(default=False)
  121. objects = ForumManager()
  122. def __unicode__(self):
  123. if self.token == 'root':
  124. return unicode(_('Root Category'))
  125. return unicode(self.name)
  126. def set_description(self, description):
  127. self.description = description.strip()
  128. self.description_preparsed = ''
  129. if self.description:
  130. import markdown
  131. self.description_preparsed = markdown.markdown(description, safe_mode='escape', output_format=settings.OUTPUT_FORMAT)
  132. def copy_permissions(self, target):
  133. if target.pk != self.pk:
  134. for role in Role.objects.all():
  135. perms = role.get_permissions()
  136. try:
  137. perms['forums'][self.pk] = perms['forums'][target.pk]
  138. role.set_permissions(perms)
  139. role.save(force_update=True)
  140. except KeyError:
  141. pass
  142. def move_content(self, target):
  143. pass
  144. def sync(self):
  145. self.threads = self.thread_set.filter(moderated=False).filter(deleted=False).count()
  146. self.posts = self.post_set.filter(moderated=False).filter(deleted=False).count()
  147. self.last_poster = None
  148. self.last_poster_name = None
  149. self.last_poster_slug = None
  150. self.last_poster_style = None
  151. self.last_thread = None
  152. self.last_thread_date = None
  153. self.last_thread_name = None
  154. self.last_thread_slug = None
  155. try:
  156. last_thread = self.thread_set.filter(moderated=False).filter(deleted=False).order_by('-last').all()[0:][0]
  157. self.last_poster_name = last_thread.last_poster_name
  158. self.last_poster_slug = last_thread.last_poster_slug
  159. self.last_poster_style = last_thread.last_poster_style
  160. if last_thread.last_poster:
  161. self.last_poster = last_thread.last_poster
  162. self.last_thread = last_thread
  163. self.last_thread_date = last_thread.start
  164. self.last_thread_name = last_thread.name
  165. self.last_thread_slug = last_thread.slug
  166. except (IndexError, AttributeError):
  167. pass
  168. def prune(self):
  169. pass
  170. """
  171. Signals
  172. """
  173. def rename_user_handler(sender, **kwargs):
  174. Forum.objects.filter(last_poster=sender).update(
  175. last_poster_name=sender.username,
  176. last_poster_slug=sender.username_slug,
  177. )
  178. rename_user.connect(rename_user_handler, dispatch_uid="rename_forums_last_poster")