|
|
import hashlib
|
|
|
from django.urls import reverse
|
|
|
from django.db import models
|
|
|
from django.db.models import Count, Q
|
|
|
from django.utils.translation import get_language
|
|
|
|
|
|
import boards
|
|
|
from boards.models import Attachment
|
|
|
from boards.models.attachment import FILE_TYPES_IMAGE
|
|
|
from boards.models.base import Viewable
|
|
|
from boards.models.thread import STATUS_ACTIVE, STATUS_BUMPLIMIT, STATUS_ARCHIVE
|
|
|
from boards.utils import cached_result
|
|
|
|
|
|
__author__ = 'neko259'
|
|
|
|
|
|
|
|
|
RELATED_TAGS_COUNT = 5
|
|
|
DEFAULT_LOCALE = 'default'
|
|
|
|
|
|
|
|
|
class TagAliasManager(models.Manager):
|
|
|
def filter_localized(self, *args, **kwargs):
|
|
|
locale = get_language()
|
|
|
tag_aliases = (self.filter(locale=locale)
|
|
|
| self.filter(Q(locale=DEFAULT_LOCALE)
|
|
|
& ~Q(parent__aliases__locale=locale)))
|
|
|
return tag_aliases.filter(**kwargs)
|
|
|
|
|
|
|
|
|
class TagAlias(models.Model, Viewable):
|
|
|
class Meta:
|
|
|
app_label = 'boards'
|
|
|
ordering = ('name',)
|
|
|
|
|
|
objects = TagAliasManager()
|
|
|
|
|
|
name = models.CharField(max_length=100, db_index=True)
|
|
|
locale = models.CharField(max_length=10, db_index=True)
|
|
|
|
|
|
parent = models.ForeignKey('Tag', on_delete=models.CASCADE, null=True,
|
|
|
blank=True, related_name='aliases')
|
|
|
|
|
|
|
|
|
class TagManager(models.Manager):
|
|
|
def get_not_empty_tags(self):
|
|
|
"""
|
|
|
Gets tags that have non-archived threads.
|
|
|
"""
|
|
|
|
|
|
return self.annotate(num_threads=Count('thread_tags'))\
|
|
|
.filter(num_threads__gt=0)\
|
|
|
.filter(aliases__in=TagAlias.objects.filter_localized())\
|
|
|
.order_by('aliases__name')
|
|
|
|
|
|
def get_tag_url_list(self, tags: list) -> str:
|
|
|
"""
|
|
|
Gets a comma-separated list of tag links.
|
|
|
"""
|
|
|
|
|
|
return ', '.join([tag.get_view() for tag in tags])
|
|
|
|
|
|
def get_by_alias(self, alias):
|
|
|
tag = None
|
|
|
aliases = TagAlias.objects.filter(name=alias).all()
|
|
|
if aliases:
|
|
|
tag = aliases[0].parent
|
|
|
|
|
|
return tag
|
|
|
|
|
|
def get_or_create_with_alias(self, name, required=False):
|
|
|
tag = self.get_by_alias(name)
|
|
|
created = False
|
|
|
if not tag:
|
|
|
tag = self.create(required=required)
|
|
|
TagAlias.objects.create(name=name, locale=DEFAULT_LOCALE, parent=tag)
|
|
|
created = True
|
|
|
return tag, created
|
|
|
|
|
|
|
|
|
class Tag(models.Model, Viewable):
|
|
|
"""
|
|
|
A tag is a text node assigned to the thread. The tag serves as a board
|
|
|
section. There can be multiple tags for each thread
|
|
|
"""
|
|
|
|
|
|
objects = TagManager()
|
|
|
|
|
|
class Meta:
|
|
|
app_label = 'boards'
|
|
|
|
|
|
required = models.BooleanField(default=False, db_index=True)
|
|
|
description = models.TextField(blank=True)
|
|
|
|
|
|
parent = models.ForeignKey('Tag', on_delete=models.CASCADE, null=True,
|
|
|
blank=True, related_name='children')
|
|
|
|
|
|
def get_name(self):
|
|
|
return self.aliases.get(locale=DEFAULT_LOCALE).name
|
|
|
|
|
|
def __str__(self):
|
|
|
return self.get_name()
|
|
|
|
|
|
def is_empty(self) -> bool:
|
|
|
"""
|
|
|
Checks if the tag has some threads.
|
|
|
"""
|
|
|
|
|
|
return self.get_thread_count() == 0
|
|
|
|
|
|
def get_thread_count(self, status=None) -> int:
|
|
|
threads = self.get_threads()
|
|
|
if status is not None:
|
|
|
threads = threads.filter(status=status)
|
|
|
return threads.count()
|
|
|
|
|
|
def get_active_thread_count(self) -> int:
|
|
|
return self.get_thread_count(status=STATUS_ACTIVE)
|
|
|
|
|
|
def get_bumplimit_thread_count(self) -> int:
|
|
|
return self.get_thread_count(status=STATUS_BUMPLIMIT)
|
|
|
|
|
|
def get_archived_thread_count(self) -> int:
|
|
|
return self.get_thread_count(status=STATUS_ARCHIVE)
|
|
|
|
|
|
@cached_result()
|
|
|
def get_absolute_url(self):
|
|
|
return reverse('tag', kwargs={'tag_name': self.get_name()})
|
|
|
|
|
|
def get_threads(self):
|
|
|
return self.thread_tags.order_by('-bump_time')
|
|
|
|
|
|
def is_required(self):
|
|
|
return self.required
|
|
|
|
|
|
def _get_locale_cache_key(self):
|
|
|
return '{}_{}'.format(self.id, get_language())
|
|
|
|
|
|
@cached_result(key_method=_get_locale_cache_key)
|
|
|
def get_localized_name(self):
|
|
|
locale = get_language()
|
|
|
|
|
|
aliases = self.aliases.filter(Q(locale=locale) | Q(locale=DEFAULT_LOCALE))
|
|
|
|
|
|
localized_tag_name = None
|
|
|
default_tag_name = None
|
|
|
|
|
|
for alias in aliases:
|
|
|
if alias.locale == locale:
|
|
|
localized_tag_name = alias.name
|
|
|
elif alias.locale == DEFAULT_LOCALE:
|
|
|
default_tag_name = alias.name
|
|
|
|
|
|
return localized_tag_name if localized_tag_name else default_tag_name
|
|
|
|
|
|
def get_view(self):
|
|
|
name = self.get_localized_name()
|
|
|
link = '<a class="tag" href="{}">{}</a>'.format(
|
|
|
self.get_absolute_url(), name)
|
|
|
if self.is_required():
|
|
|
link = '<b>{}</b>'.format(link)
|
|
|
return link
|
|
|
|
|
|
@cached_result()
|
|
|
def get_post_count(self):
|
|
|
return self.get_threads().aggregate(num_posts=Count('replies'))['num_posts']
|
|
|
|
|
|
def get_description(self):
|
|
|
return self.description
|
|
|
|
|
|
def get_random_image_post(self, status=[STATUS_ACTIVE, STATUS_BUMPLIMIT]):
|
|
|
posts = boards.models.Post.objects.filter(attachments__mimetype__in=FILE_TYPES_IMAGE)\
|
|
|
.annotate(images_count=Count(
|
|
|
'attachments')).filter(images_count__gt=0, thread__tags__in=[self])
|
|
|
if status is not None:
|
|
|
posts = posts.filter(thread__status__in=status)
|
|
|
return posts.order_by('?').first()
|
|
|
|
|
|
def get_first_letter(self):
|
|
|
name = self.get_localized_name()
|
|
|
return name and name[0] or ''
|
|
|
|
|
|
def get_related_tags(self):
|
|
|
return set(Tag.objects.filter(thread_tags__in=self.get_threads()).exclude(
|
|
|
id=self.id).order_by('?')[:RELATED_TAGS_COUNT])
|
|
|
|
|
|
@cached_result()
|
|
|
def get_color(self):
|
|
|
"""
|
|
|
Gets color hashed from the tag name.
|
|
|
"""
|
|
|
return hashlib.md5(self.get_name().encode()).hexdigest()[:6]
|
|
|
|
|
|
def get_parent(self):
|
|
|
return self.parent
|
|
|
|
|
|
def get_all_parents(self):
|
|
|
parents = list()
|
|
|
parent = self.get_parent()
|
|
|
if parent and parent not in parents:
|
|
|
parents.insert(0, parent)
|
|
|
parents = parent.get_all_parents() + parents
|
|
|
|
|
|
return parents
|
|
|
|
|
|
def get_children(self):
|
|
|
return self.children
|
|
|
|
|
|
def get_images(self):
|
|
|
return Attachment.objects.filter(
|
|
|
attachment_posts__thread__tags__in=[self]).filter(
|
|
|
mimetype__in=FILE_TYPES_IMAGE).order_by('-attachment_posts__pub_time')
|
|
|
|
|
|
|