X-Git-Url: https://git.p6c8.net/pcdenotes.git/blobdiff_plain/e066dce5d28b9230039a600d9c8171c1389165a2..4f2fc553b395668623d66dc5ca65b22b9da03953:/notes/models.py?ds=sidebyside diff --git a/notes/models.py b/notes/models.py index e480221..0056f0e 100644 --- a/notes/models.py +++ b/notes/models.py @@ -1,12 +1,47 @@ from django.db import models +from django.db.models import Count +from django.db.models.functions import ExtractYear, ExtractMonth, Coalesce +from django.db.models.signals import pre_save + +from django.dispatch import receiver from django.contrib.auth.models import User from django.urls import reverse +from datetime import datetime + # Create your models here. NOTE_STATUS = ((0, "Draft"), (1, "Published")) +class NoteQuerySet(models.QuerySet): + pass + +class NoteManager(models.Manager): + def all_published(self): + return super().get_queryset().filter(status=1).annotate(publication_date=Coalesce('published_at', 'created_at')).order_by('-publication_date') + + def all(self): + return super().all().annotate(publication_date=Coalesce('published_at', 'created_at')).order_by('-publication_date') + + def per_year(self, year): + return self.all_published().filter(created_at__year=year) + + def per_month(self, year, month): + return self.per_year(year).filter(created_at__month=month) + + def years(self): + return self.all_published().annotate(created_year=ExtractYear('created_at')).values_list('created_year', flat=True).distinct().order_by('created_year') + + def years_with_total(self): + return self.all_published().annotate(created_year=ExtractYear('created_at')).values('created_year').annotate(total=Count('id')).order_by('created_year').values('created_year', 'total').distinct() + + def months(self, year): + return self.per_year(year).annotate(created_month=ExtractMonth('created_at')).values_list('created_month', flat=True).distinct().order_by('created_month') + + def months_with_total(self, year): + return self.per_year(year).annotate(created_month=ExtractMonth('created_at')).values('created_month').annotate(total=Count('id')).order_by('created_month').values('created_month', 'total').distinct() + class Note(models.Model): title = models.CharField(max_length=250) slug = models.SlugField(max_length=250, unique=True) @@ -16,6 +51,9 @@ class Note(models.Model): created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) + published_at = models.DateTimeField(null=True, editable=False) + + objects = NoteManager() class Meta: ordering = ['-created_at'] @@ -25,5 +63,20 @@ class Note(models.Model): def get_absolute_url(self): return reverse("notes:note_detail", kwargs={"note_slug": self.slug}) - #return "/notes/%s" % (self.slug) + def is_draft(self): + return self.status == 0 + + def is_published(self): + return self.status == 1 + +@receiver(pre_save, sender=Note) +def note_pre_save(sender, instance, **kwargs): + if instance.pk is None: + if instance.status == 1: + instance.published_at = datetime.now() + else: + old_instance = Note.objects.get(pk=instance.pk) + + if old_instance.status == 0 and instance.status == 1: + instance.published_at = datetime.now() \ No newline at end of file