coi/app/report/filters.py

import django_filters
from core.models import Report

class ReportFilter(django_filters.FilterSet):
    name = django_filters.CharFilter(
        field_name='name', 
        lookup_expr='icontains', 
        label='Report Name'
    )
    created_by = django_filters.CharFilter(
        field_name='created_by__username', 
        lookup_expr='icontains', 
        label='Created By'
    )
    created_at = django_filters.DateFromToRangeFilter(
        field_name='created_at', 
        label='Created Date Range',
        widget=django_filters.widgets.RangeWidget(
            attrs={
                'type': 'date',
                'class': 'w-full p-2 border border-gray-300 rounded-md focus:outline-none focus:ring focus:ring-blue-300'
            }
        )
    )

    class Meta:
        model = Report
        fields = ['name', 'created_by', 'created_at']