X-Git-Url: https://git.p6c8.net/pcdenotes.git/blobdiff_plain/3fb7b9dea69252f64ee82967dfca97baf1b02df7..41cbbf03fd231637646702e6445eaf9ebfa2c770:/notes/models.py

diff --git a/notes/models.py b/notes/models.py
index 3584c26..a3fe24e 100644
--- a/notes/models.py
+++ b/notes/models.py
@@ -1,4 +1,6 @@
 from django.db import models
+from django.db.models import Count
+from django.db.models.functions import ExtractYear, ExtractMonth
 from django.contrib.auth.models import User
 from django.urls import reverse
 
@@ -7,8 +9,30 @@ from django.urls import reverse
 NOTE_STATUS = ((0, "Draft"),
                (1, "Published"))            
 
+class NoteQuerySet(models.QuerySet):
+    pass
+
+class NoteManager(models.Manager):
+    def per_year(self, year):
+        return super().get_queryset().filter(status=1, created_at__year=year)
+
+    def per_month(self, year, month):
+        return super().get_queryset().filter(status=1, created_at__year=year, created_at__month=month)
+
+    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')
+
+    def years_with_total(self):
+        return super().get_queryset().filter(status=1).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, unique=True)
+    title = models.CharField(max_length=250)
     slug = models.SlugField(max_length=250, unique=True)
     author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='notes_posted')
     content = models.TextField()
@@ -17,6 +41,8 @@ class Note(models.Model):
     created_at = models.DateTimeField(auto_now_add=True)
     updated_at = models.DateTimeField(auto_now=True)
 
+    objects = NoteManager()
+
     class Meta:
         ordering = ['-created_at']
 
@@ -25,5 +51,9 @@ 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
\ No newline at end of file