Compare The Date Of All Datefields In A Model To The Current Date

if i have in my model class MyModel(models.model): field1 = models.ForignKey(AnotherModel) field2 = models.DateField(blank=True, null=True) field3 = models.DateField(bl

Solution 1:

We did something similar. In our code we used template tags (see https://docs.djangoproject.com/en/1.8/howto/custom-template-tags/. In the template tags file we have: (Note you can remove the part about handling datetimes):

from django import template
from datetime import date, datetime, timedelta

register = template.Library()

@register.filter(expects_localtime=True)defis_today(value):
    ifisinstance(value, datetime):
        value = value.date()
    return value == date.today()

@register.filter(expects_localtime=True)defis_past(value):
    ifisinstance(value, datetime):
        value = value.date()
    return value < date.today()

Then in the template you can do:

 {% if this_date_object|is_today  %} <spanclass="active">{{field}}</span> {% endif %}
 {% if this_date_object|is_past   %} <spanclass="past"> {{field}}</span> {% endif %}

Small advantages here are 1) you can reuse the date comparison in other places, and 2) your don't clutter your model with code only relevant to how it is to be displayed.

Solution 2:

Haven't tested it but I believe something like the following should work.

If you use a model method to compare the fields with the current date and return an array you should be able to loop through it in the template, so something like this

class MyModel(models.model):
    field1 = models.ForignKey(AnotherModel)
    field2 = models.DateField(blank=True, null=True)
    field3 = models.DateField(blank=True, null=True)
    field4 = models.DateField(blank=True, null=True)
    field5 = models.DateField(blank=True, null=True)
    field10 = models.DateField(blank=True, null=True)

    def is_past:
        past = []
        for field in fields:
            if field.date < datetime.now().date():
                past.append(True)
            else:
                past.append(False)
        return past

Template:

{% for field in context.is_past %}
    {% if field == True %}
       <spanclass="past">{{ field}}</span>
    {% else %}
        <spanclass="active">{{ field}}</span>
    {% endif %}
{% endfor %}

That should get you on the right track but may need some editing to work properly for you.

Solution 3:

define this method on your model

defis_past(self):
    fields = (
        self.field1, 
        self.field2, 
        self.field3, 
        self.field4, 
        self.field5, 
        self.field10,
    )
    for field in fields:
        if field.date < datetime.now().date():
            returnTruereturnFalse