Produits Entr'ouvert » Passerelle

from datetime import datetime, time

class CustomDateInput(forms.DateInput):

    input_type = 'date'

class CustomTimeInput(forms.TimeInput):

    input_type = 'time'

class LogFilterForm(forms.Form):

    date__gte = forms.DateField(required=False, widget=CustomDateInput)

    time__gte = forms.TimeField(required=False, widget=CustomTimeInput, initial=time(0, 0))

    date__lte = forms.DateField(required=False, widget=CustomDateInput)

    time__lte = forms.TimeField(required=False, widget=CustomTimeInput, initial=time(0, 0))

    order_by = forms.ChoiceField(required=False,

        choices=(('timestamp', 'timestamp'), ('-timestamp', '-timestamp')),

        initial=('-timestamp', '-timestamp'))

    page = forms.IntegerField(required=False, initial=1, min_value=1)

    page_size = forms.IntegerField(required=False, initial=10, min_value=1, max_value=1000)

    def prepare_query(self):

        '''Transform input to datetime lte and gte dictionnary

        '''

        query_filter = {}

        if self.cleaned_data.get('date__gte'):

            time__gte = self.cleaned_data['time__gte'] or time(0,0)

            query_filter.update({

                'timestamp__gte': datetime.combine(self.cleaned_data.get('date__gte'), time__gte)})

        if self.cleaned_data.get('date__lte'):

            time__lte = self.cleaned_data['time__lte'] or time(0,0)

            query_filter.update({

                'timestamp__lte': datetime.combine(self.cleaned_data.get('date__lte'), time__lte)})

        return query_filter, {

            'page': self.cleaned_data['page'],

            'page_size': self.cleaned_data['page_size'],

            'order_by': self.cleaned_data['order_by']

        }

import urllib

from django.core.urlresolvers import reverse

from django.utils.dateparse import parse_datetime

from django.db.models import Q

from ..forms import LogFilterForm

def get_resource_log_query(request):

    query_params = {

        'page': 1,

        'page_size': 10,

        'order_by': '-timestamp'

    }

    query_filter = {}

    get = request.GET.dict()

    # Add search parameters from request.GET

    for param in ['page', 'order_by', 'page_size']:

        try:

            query_params[param] = get.pop(param)

        except KeyError:

            continue

    # Add query filters from request.GET

    for key, value in get.items():

        if key.startswith('timestamp'):

            datetime_obj = parse_datetime(value)

            if datetime_obj:

                query_filter[key] = datetime_obj

    return query_filter, query_params

def post_resource_log_query(logfilterform):

    '''Add search parameters from From'''

    query_params = {}

    query_filter = {}

    if logfilterform.is_valid():

        query_filter, query_params = logfilterform.prepare_query()

    return query_filter, query_params

    '''Logs table with customizable pagination and timestamp filters

    '''

    # defaults params

    query_params = {

        'page': 1,

        'page_size': 10,

        'order_by': '-timestamp'

    }

    query_filter = {}

    # Add search parameters from request query

    if request.method == 'GET':

        query_filter, query_params = get_resource_log_query(request)

        # GET params initialize the Form data

        date__gte, time__gte, date__lte, time__lte = False, False, False, False

        if query_filter.get('timestamp__gte'):

            date__gte = query_filter['timestamp__gte'].date().isoformat()

            time__gte = query_filter['timestamp__gte'].time()

        if query_filter.get('timestamp__lte'):

            date__lte = query_filter['timestamp__lte'].date()

            time__lte = query_filter['timestamp__lte'].time().isoformat()

        logfilterform = LogFilterForm(data=dict({

            'date__gte': date__gte or None,

            'time__gte': time__gte or None,

            'date__lte': date__lte or None,

            'time__lte': time__lte or None

        }, **query_params))

    else:

        logfilterform = LogFilterForm(data=request.POST)

        query_filter, query_params = post_resource_log_query(logfilterform)

    if len(query_filter.keys()):

        qs = ResourceLog.objects.filter(Q(**query_filter))

        qs = qs.filter(appname=connector, slug=resource.slug)

    else:

        qs = ResourceLog.objects.filter(appname=connector, slug=resource.slug)

    qs = qs.order_by(query_params['order_by'])

    paginator = Paginator(qs, int(query_params['page_size']))

        logrecords = paginator.page(query_params['page'])

    context.update({

        'logfilterform': logfilterform,

        'query_filter': query_filter,

        'query_params': query_params,

        'logrecords': logrecords,

        'permalink': reverse('view-connector', args=(connector, resource.slug)) + '?' + urllib.urlencode(dict(query_filter, **query_params))

    })

<form action="." method="POST" id="logfilter" style="padding:1em; border: 1px solid gray;">

  {% csrf_token %}

  {{ logfilterform }}

  <input type="submit" id="_submit" style="height: 3.3rem;">

</form>

<a href="{{ permalink }}">{% trans "Link to the results" %}</a>

    def post(self, request, *args, **kwargs):

        return self.get(request, *args, **kwargs)