models.py 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205
  1. from mptt.managers import TreeManager
  2. from mptt.models import MPTTModel, TreeForeignKey
  3. from django.db import models
  4. from django.utils import six
  5. from django.utils.encoding import python_2_unicode_compatible
  6. from misago.acl import version as acl_version
  7. from misago.acl.models import BaseRole
  8. from misago.conf import settings
  9. from misago.core.cache import cache
  10. from misago.core.utils import slugify
  11. from misago.threads.threadtypes import trees_map
  12. from . import PRIVATE_THREADS_ROOT_NAME, THREADS_ROOT_NAME
  13. CACHE_NAME = 'misago_categories_tree'
  14. class CategoryManager(TreeManager):
  15. def private_threads(self):
  16. return self.get_special(PRIVATE_THREADS_ROOT_NAME)
  17. def root_category(self):
  18. return self.get_special(THREADS_ROOT_NAME)
  19. def get_special(self, special_role):
  20. cache_name = '%s_%s' % (CACHE_NAME, special_role)
  21. special_category = cache.get(cache_name, 'nada')
  22. if special_category == 'nada':
  23. special_category = self.get(special_role=special_role)
  24. cache.set(cache_name, special_category)
  25. return special_category
  26. def all_categories(self, include_root=False):
  27. tree_id = trees_map.get_tree_id_for_root(THREADS_ROOT_NAME)
  28. queryset = self.filter(tree_id=tree_id)
  29. if not include_root:
  30. queryset = queryset.filter(level__gt=0)
  31. return queryset.order_by('lft')
  32. def get_cached_categories_dict(self):
  33. categories_dict = cache.get(CACHE_NAME, 'nada')
  34. if categories_dict == 'nada':
  35. categories_dict = self.get_categories_dict_from_db()
  36. cache.set(CACHE_NAME, categories_dict)
  37. return categories_dict
  38. def get_categories_dict_from_db(self):
  39. categories_dict = {}
  40. for category in self.all_categories(include_root=True):
  41. categories_dict[category.pk] = category
  42. return categories_dict
  43. def clear_cache(self):
  44. cache.delete(CACHE_NAME)
  45. @python_2_unicode_compatible
  46. class Category(MPTTModel):
  47. parent = TreeForeignKey(
  48. 'self',
  49. null=True,
  50. blank=True,
  51. related_name='children',
  52. on_delete=models.CASCADE,
  53. )
  54. special_role = models.CharField(max_length=255, null=True, blank=True)
  55. name = models.CharField(max_length=255)
  56. slug = models.CharField(max_length=255)
  57. description = models.TextField(null=True, blank=True)
  58. is_closed = models.BooleanField(default=False)
  59. threads = models.PositiveIntegerField(default=0)
  60. posts = models.PositiveIntegerField(default=0)
  61. last_post_on = models.DateTimeField(null=True, blank=True)
  62. last_thread = models.ForeignKey(
  63. 'misago_threads.Thread',
  64. related_name='+',
  65. null=True,
  66. blank=True,
  67. on_delete=models.SET_NULL,
  68. )
  69. last_thread_title = models.CharField(max_length=255, null=True, blank=True)
  70. last_thread_slug = models.CharField(max_length=255, null=True, blank=True)
  71. last_poster = models.ForeignKey(
  72. settings.AUTH_USER_MODEL,
  73. related_name='+',
  74. null=True,
  75. blank=True,
  76. on_delete=models.SET_NULL,
  77. )
  78. last_poster_name = models.CharField(max_length=255, null=True, blank=True)
  79. last_poster_slug = models.CharField(max_length=255, null=True, blank=True)
  80. require_threads_approval = models.BooleanField(default=False)
  81. require_replies_approval = models.BooleanField(default=False)
  82. require_edits_approval = models.BooleanField(default=False)
  83. prune_started_after = models.PositiveIntegerField(default=0)
  84. prune_replied_after = models.PositiveIntegerField(default=0)
  85. archive_pruned_in = models.ForeignKey(
  86. 'self',
  87. related_name='pruned_archive',
  88. null=True,
  89. blank=True,
  90. on_delete=models.SET_NULL,
  91. )
  92. css_class = models.CharField(max_length=255, null=True, blank=True)
  93. objects = CategoryManager()
  94. def __str__(self):
  95. return six.text_type(self.thread_type.get_category_name(self))
  96. @property
  97. def thread_type(self):
  98. return trees_map.get_type_for_tree_id(self.tree_id)
  99. def delete(self, *args, **kwargs):
  100. Category.objects.clear_cache()
  101. acl_version.invalidate()
  102. return super(Category, self).delete(*args, **kwargs)
  103. def synchronize(self):
  104. threads_queryset = self.thread_set.filter(is_hidden=False, is_unapproved=False)
  105. self.threads = threads_queryset.count()
  106. if self.threads:
  107. replies_sum = threads_queryset.aggregate(models.Sum('replies'))
  108. self.posts = self.threads + replies_sum['replies__sum']
  109. else:
  110. self.posts = 0
  111. if self.threads:
  112. last_thread_qs = threads_queryset.filter(is_hidden=False, is_unapproved=False)
  113. last_thread = last_thread_qs.order_by('-last_post_on')[:1][0]
  114. self.set_last_thread(last_thread)
  115. else:
  116. self.empty_last_thread()
  117. def delete_content(self):
  118. from .signals import delete_category_content
  119. delete_category_content.send(sender=self)
  120. def move_content(self, new_category):
  121. from .signals import move_category_content
  122. move_category_content.send(sender=self, new_category=new_category)
  123. def get_absolute_url(self):
  124. return self.thread_type.get_category_absolute_url(self)
  125. def get_last_thread_url(self):
  126. return self.thread_type.get_category_last_thread_url(self)
  127. def get_last_thread_new_url(self):
  128. return self.thread_type.get_category_last_thread_new_url(self)
  129. def get_last_post_url(self):
  130. return self.thread_type.get_category_last_post_url(self)
  131. def get_read_api_url(self):
  132. return self.thread_type.get_category_read_api_url(self)
  133. def set_name(self, name):
  134. self.name = name
  135. self.slug = slugify(name)
  136. def set_last_thread(self, thread):
  137. self.last_post_on = thread.last_post_on
  138. self.last_thread = thread
  139. self.last_thread_title = thread.title
  140. self.last_thread_slug = thread.slug
  141. self.last_poster = thread.last_poster
  142. self.last_poster_name = thread.last_poster_name
  143. self.last_poster_slug = thread.last_poster_slug
  144. def empty_last_thread(self):
  145. self.last_post_on = None
  146. self.last_thread = None
  147. self.last_thread_title = None
  148. self.last_thread_slug = None
  149. self.last_poster = None
  150. self.last_poster_name = None
  151. self.last_poster_slug = None
  152. def has_child(self, child):
  153. return child.lft > self.lft and child.rght < self.rght
  154. class CategoryRole(BaseRole):
  155. pass
  156. class RoleCategoryACL(models.Model):
  157. role = models.ForeignKey(
  158. 'misago_acl.Role',
  159. related_name='categories_acls',
  160. on_delete=models.CASCADE,
  161. )
  162. category = models.ForeignKey(
  163. 'Category',
  164. related_name='category_role_set',
  165. on_delete=models.CASCADE,
  166. )
  167. category_role = models.ForeignKey(CategoryRole, on_delete=models.CASCADE)