models.py 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. from urlparse import urlparse
  2. from django.core.urlresolvers import reverse
  3. from django.db import models
  4. from django.utils.translation import ugettext_lazy as _
  5. from mptt.managers import TreeManager
  6. from mptt.models import MPTTModel, TreeForeignKey
  7. from misago.acl import version as acl_version
  8. from misago.acl.models import BaseRole
  9. from misago.conf import settings
  10. from misago.core.cache import cache
  11. from misago.core.utils import slugify
  12. from misago.threads import threadtypes
  13. CACHE_NAME = 'misago_categories_tree'
  14. CATEGORIES_TREE_ID = 1
  15. class CategoryManager(TreeManager):
  16. def private_threads(self):
  17. return self.get_special('private_threads')
  18. def root_category(self):
  19. return self.get_special('root_category')
  20. def get_special(self, special_role):
  21. cache_name = '%s_%s' % (CACHE_NAME, special_role)
  22. special_category = cache.get(cache_name, 'nada')
  23. if special_category == 'nada':
  24. special_category = self.get(special_role=special_role)
  25. cache.set(cache_name, special_category)
  26. return special_category
  27. def all_categories(self, include_root=False):
  28. qs = self.filter(tree_id=CATEGORIES_TREE_ID)
  29. if not include_root:
  30. qs = self.filter(level__gt=0)
  31. return qs.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. class Category(MPTTModel):
  46. parent = TreeForeignKey(
  47. 'self', null=True, blank=True, related_name='children')
  48. special_role = models.CharField(max_length=255, null=True, blank=True)
  49. name = models.CharField(max_length=255)
  50. slug = models.CharField(max_length=255)
  51. description = models.TextField(null=True, blank=True)
  52. is_closed = models.BooleanField(default=False)
  53. threads = models.PositiveIntegerField(default=0)
  54. posts = models.PositiveIntegerField(default=0)
  55. last_post_on = models.DateTimeField(null=True, blank=True)
  56. last_thread = models.ForeignKey('misago_threads.Thread', related_name='+',
  57. null=True, blank=True,
  58. on_delete=models.SET_NULL)
  59. last_thread_title = models.CharField(max_length=255, null=True, blank=True)
  60. last_thread_slug = models.CharField(max_length=255, null=True, blank=True)
  61. last_poster = models.ForeignKey(settings.AUTH_USER_MODEL,
  62. related_name='+',
  63. null=True, blank=True,
  64. on_delete=models.SET_NULL)
  65. last_poster_name = models.CharField(max_length=255, null=True, blank=True)
  66. last_poster_slug = models.CharField(max_length=255, null=True, blank=True)
  67. prune_started_after = models.PositiveIntegerField(default=0)
  68. prune_replied_after = models.PositiveIntegerField(default=0)
  69. archive_pruned_in = models.ForeignKey('self',
  70. related_name='pruned_archive',
  71. null=True, blank=True,
  72. on_delete=models.SET_NULL)
  73. css_class = models.CharField(max_length=255, null=True, blank=True)
  74. objects = CategoryManager()
  75. @property
  76. def thread_type(self):
  77. return threadtypes.get(self.special_role or 'thread')
  78. def __unicode__(self):
  79. return unicode(self.thread_type.get_category_name(self))
  80. def lock(self):
  81. return Category.objects.select_for_update().get(id=self.id)
  82. def delete(self, *args, **kwargs):
  83. Category.objects.clear_cache()
  84. acl_version.invalidate()
  85. return super(Category, self).delete(*args, **kwargs)
  86. def synchronize(self):
  87. self.threads = self.thread_set.filter(is_moderated=False).count()
  88. if self.threads:
  89. replies_sum = self.thread_set.aggregate(models.Sum('replies'))
  90. self.posts = self.threads + replies_sum['replies__sum']
  91. else:
  92. self.posts = 0
  93. if self.threads:
  94. last_thread_qs = self.thread_set.filter(is_moderated=False)
  95. last_thread = last_thread_qs.order_by('-last_post_on')[:1][0]
  96. self.set_last_thread(last_thread)
  97. else:
  98. self.empty_last_thread()
  99. def delete_content(self):
  100. from misago.categories.signals import delete_category_content
  101. delete_category_content.send(sender=self)
  102. def move_content(self, new_category):
  103. from misago.categories.signals import move_category_content
  104. move_category_content.send(sender=self, new_category=new_category)
  105. def get_absolute_url(self):
  106. return self.thread_type.get_category_absolute_url(self)
  107. def set_name(self, name):
  108. self.name = name
  109. self.slug = slugify(name)
  110. def set_last_thread(self, thread):
  111. self.last_post_on = thread.last_post_on
  112. self.last_thread = thread
  113. self.last_thread_title = thread.title
  114. self.last_thread_slug = thread.slug
  115. self.last_poster = thread.last_poster
  116. self.last_poster_name = thread.last_poster_name
  117. self.last_poster_slug = thread.last_poster_slug
  118. def empty_last_thread(self):
  119. self.last_post_on = None
  120. self.last_thread = None
  121. self.last_thread_title = None
  122. self.last_thread_slug = None
  123. self.last_poster = None
  124. self.last_poster_name = None
  125. self.last_poster_slug = None
  126. def has_child(self, child):
  127. return child.lft > self.lft and child.rght < self.rght
  128. class CategoryRole(BaseRole):
  129. pass
  130. class RoleCategoryACL(models.Model):
  131. role = models.ForeignKey('misago_acl.Role', related_name='categories_acls')
  132. category = models.ForeignKey('Category', related_name='category_role_set')
  133. category_role = models.ForeignKey(CategoryRole)