foreign key daterange filtering in admin

Using Django The Admin
1

for a hotel booking system using django admin, I’d like to filter the rooms available for a given date range, models are as follow


class Room(models.Model):
    id = models.AutoField(primary_key=True)
    hotel = models.ForeignKey(Hotel, on_delete=models.CASCADE)


class Booking(models.Model):
    id = models.AutoField(primary_key=True)
    start_date = models.DateField(verbose_name=_("Start date"))
    end_date = models.DateField(verbose_name=_("End date"))
    room = models.ForeignKey(Room, on_delete=models.CASCADE)

how can I filter the rooms in the admin so I can pick a date range and return only the rooms that have no bookings on the select range?

thanks a lot

2

I found this blog post that describes adding a text entry field as a filter - How to Add a Text Filter to Django Admin | Haki Benita
You could use that as a starting point. You’ll want to create a pair of fields for start and end dates (or find some JavaScript widget), and use that to submit the range to the admin.

3

Thanks a lot for your response Ken, this looks like a good baseline. I will report back!