django : How to disable dates in datepicker, based on the entries form db?

Question

I have n number of dates defined in this below model in the database, these are directly inserted by admin, not by modelforms or anything.

class Calendar(models.Model):

    date = models.DateField()
    occasion = models.CharField(max_length = 20)

the form that has the date fields,

class LeaveRequestForm(ModelForm):

    class Meta:
        fields = (... "from_date", "to_date" ...)
        model = Leave

        widgets =  {
            ...
            'from_date' : DateInput(attrs={'class': 'datepicker'}),
            'to_date' : DateInput(attrs={'class': 'datepicker'}),
            ...

        }

I have this datepicker script which disable weekends,

<script>

    $(document).ready(function() {
        $('.datepicker').datepicker(
          {
            minDate : 0,
            beforeShowDay : $.datepicker.noWeekends
          }
        );
    });

    </script>

Now I want to disable the dates defined in the database + weekends as well. How do I do that?

update :

var array = {{ 
               {% for x in disabled_dates %}
               {{x.dates}}
               {% endfor  %} 
            }}

$('datepicker').datepicker({
    beforeShowDay: function(date){
        var string = jQuery.datepicker.formatDate('yy-mm-dd', date);
        return array.indexOf(string) != -1 ? [false] : $.datepicker.noWeekends(date);
    }
});

No luck yet!

The answers here were helpful to me https://stackoverflow.com/questions/14484159/jquery-datepicker-and-beforeshowday — devdob, Sep 08 '18 at 09:41
It shows how to disable dates, isnt that what you are asking about?! — devdob, Sep 08 '18 at 10:53
@devdob `Now I want to disable the dates defined in the database + weekends as well. How do I do that?` — Aasma Rehman, Sep 08 '18 at 10:55

devdob · Answer 1 · 2018-09-10T12:01:31.067

2

As referenced from the answers here and here,

var array = [
    {% for x in disabled_dates %}
        {{x.dates}}
    {% endfor  %} 
]

$('datepicker').datepicker({
    beforeShowDay: function(date){
        var string = jQuery.datepicker.formatDate('yy-mm-dd', date);
        return array.indexOf(string) != -1 ? [false] : $.datepicker.noWeekends(date);
    }
});

Edit: Added the weekends alongside your array of dates.

Edit: Added for loop for dates (although i think you should've sent a ready list from your view function)

Hope this helps!

edited Sep 10 '18 at 12:01

answered Sep 08 '18 at 11:10

devdob

1,404
12
13

Does this answer your question? – devdob Sep 08 '18 at 11:19
yup, but no luck yet! – Aasma Rehman Sep 10 '18 at 03:43
What problem are you still facing? – devdob Sep 10 '18 at 07:24
The for loop to retrieve data from db – Aasma Rehman Sep 10 '18 at 07:53
Check the answer now, this should solve you problem hopefully. – devdob Sep 10 '18 at 12:02

django : How to disable dates in datepicker, based on the entries form db?

1 Answers1