Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- views.py
- # gets current year and stores it in currentYear.
- currentYear = datetime.now().year
- # opmToReview = posts.objects.filter(reviewYear = 'currentYear').count()
- # gives error - Cannot resolve keyword 'reviewYear' into field.
- # opmToReview = posts.objects.filter(reviewDue = 'currentYear').count()
- # gives error - 'currentYear' value has invalid format.
- #Tried this too but, doesn't work
- # testing for comparing dates
- def opmToReview(request):
- count = 0
- for post in posts
- if currentYear == reviewYear
- count = count + 1
- return render(request, 'opmStatistics.html', {'currentYearReview' : currentYearReview})
- models.py
- class posts(models.Model):
- OPMnumber = models.CharField(max_length = 30)
- title = models.TextField()
- contacts = models.CharField(max_length = 50)
- dateLastReviewed = models.DateTimeField()
- reviewDue = models.DateTimeField()
- status = models.CharField(max_length = 20)
- assignedTo = models.CharField(max_length = 30)
- comments = models.TextField()
- #used to extract the year from reviewDue date
- def reviewYear(self):
- return self.reviewDue.strftime('%Y')
- '''
- Expected results is the total number of procedure needed to be review for current year.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement