"publication_date" is now an annotated field

[pcdenotes.git] / notes / models.py

diff --git a/notes/models.py b/notes/models.py
index 2957cb8470891280a3bb4e0053433740f1022a2c..0056f0e706d29990ba4f5721cc0fc9dbdbf51375 100644 (file)
--- a/notes/models.py
+++ b/notes/models.py
@@ -1,8 +1,14 @@
 from django.db import models
 from django.db import models

-from django.db.models.functions import ExtractYear, ExtractMonth
+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 django.contrib.auth.models import User
 from django.urls import reverse
 

+from datetime import datetime
+

 # Create your models here.
 
 NOTE_STATUS = ((0, "Draft"),
 # Create your models here.
 
 NOTE_STATUS = ((0, "Draft"),


@@ -12,18 +18,30 @@ class NoteQuerySet(models.QuerySet):
     pass
 
 class NoteManager(models.Manager):
     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):
     def per_year(self, year):

-        return super().get_queryset().filter(status=1, created_at__year=year)
+        return self.all_published().filter(created_at__year=year)

 
     def per_month(self, year, month):
 
     def per_month(self, year, month):

-        return super().get_queryset().filter(status=1, created_at__year=year, created_at__month=month)
+        return self.per_year(year).filter(created_at__month=month)

 
     def years(self):
 
     def years(self):

-        return super().get_queryset().filter(status=1).annotate(created_year=ExtractYear('created_at')).values_list('created_year', flat=True).distinct().order_by('created_year')
+        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(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)
 class Note(models.Model):
     title = models.CharField(max_length=250)
     slug = models.SlugField(max_length=250, unique=True)


@@ -33,6 +51,7 @@ class Note(models.Model):
     
     created_at = models.DateTimeField(auto_now_add=True)
     updated_at = models.DateTimeField(auto_now=True)
     
     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()
 
 
     objects = NoteManager()
 


@@ -49,4 +68,15 @@ class Note(models.Model):
         return self.status == 0
 
     def is_published(self):
         return self.status == 0
 
     def is_published(self):

-        return self.status == 1
\ No newline at end of file
+        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