On Saturday, November 15, 2014 4:47:12 PM UTC+5:30, Sachin Tiwari wrote:
>
> Hi All,
>
> I am using below daterange filter package but it did not work if
> from_date and to_date field are same,
>
>
> https://github.com/DXist/django-daterange-filter/blob/master/daterange_filter/filter.py
>
> Please suggest the solution
>
> I was trying by converting to_date + timedelta(days=1) but it gives below
> error
>
>
> time data '<django.forms.fields.DateField object at 0x7f80e9200190>' does not
> match format '%Y-%m-%d'
>
>
> Edited Code of above link
>
> import datetime
>
> to_date = self.form.fields.get('measureddate__lte')
> #toDate = datetime.datetime.strptime('2014-11-15', "%Y-%m-%d").date()
> toDate = datetime.datetime.strptime(to_date.__str__(), "%Y-%m-%d").date()
> //Error
> toTotom = toDate + datetime.timedelta(days=1)
> self.replace_value_with_definition('measureddate__lte', toTotom.__str__())
>
>
>
>
> def replace_value_with_definition(self,key_to_find, definition):
> for key in self.form.cleaned_data.keys():
> if key == key_to_find:
> self.form.cleaned_data[key] = definition
> return self.form.cleaned_data
>
>
>
>
>
Hi Collin,
Thanks for your kind support,
Sharing more details,
self.form.cleaned_data.get('measureddate__lte')
gives below error,
[u"'None' value has an invalid format. It must be in YYYY-MM-DD
HH:MM[:ss[.uuuuuu]][TZ] format."]
Original implementation is available at above link,
This filter does not show the event if both dates are same, for e.g.
from_date : 2014-11-18 to_date : 2014-11-18, then events of today date will
not be displayed.
Please suggest the solution,
class DateRangeForm(forms.Form):
def __init__(self, *args, **kwargs):
self.field_name = kwargs.pop('field_name')
super(DateRangeForm, self).__init__(*args, **kwargs)
self.fields['%s__gte' % self.field_name] = forms.DateField(
label='', widget=forms.widgets.DateInput(format="%Y-%m-%d",
attrs={'placeholder': _('From date')}), localize=True,
input_formats="%Y-%m-%d",
required=False)
self.fields['%s__lte' % self.field_name] = forms.DateField(
label='', widget=forms.widgets.DateInput(format="%Y-%m-%d",
attrs={'placeholder': _('To date')}), localize=True,
input_formats="%Y-%m-%d",
required=False)
class DateRangeFilter2(admin.filters.DateFieldListFilter):
template = 'daterange_filter/filter.html'
def __init__(self, field, request, params, model, model_admin,
field_path):
super(DateRangeFilter2, self).__init__(
field, request, params, model, model_admin, field_path)
self.form = self.get_form(request)
self.field_generic = '%s__' % field_path
self.date_params = dict([(k, v) for k, v in params.items()
if k.startswith(self.field_generic)])
def expected_parameters(self):
return [self.lookup_kwarg_since, self.lookup_kwarg_until]
def get_form(self, request):
return DateRangeForm(data=self.used_parameters,
field_name=self.field_path)
def replace_value_with_definition(self,key_to_find, definition):
for key in self.form.cleaned_data.keys():
if key == key_to_find:
self.form.cleaned_data[key] = definition
return self.form.cleaned_data
def queryset(self, request, queryset):
if self.form.is_valid():
to_date = self.form.cleaned_data.get('measureddate__gte')
#if isinstance(to_date, forms.DateField):
# to_date = now.replace(hour=0, minute=0, second=0)
#from_date = self.form.fields.get('measureddate__lte')
from_date = self.form.cleaned_data.get('measureddate__lte')
#if isinstance(from_date, forms.DateField):
# from_date = now.replace(hour=0, minute=0, second=0)
#return
queryset.filter(measureddate__gte=datetime.date(from_date),
measureddate__lte=datetime.date(to_date))
return queryset.filter(measureddate__gte=from_date.__str__(),
measureddate__lte=to_date.__str__())
else:
return queryset
FieldListFilter.register(
lambda f: isinstance(f, forms.DateField), DateFieldListFilter)
[u"'None' value has an invalid format. It must be in YYYY-MM-DD
HH:MM[:ss[.uuuuuu]][TZ] format."]
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/ae6b4e01-6a2f-454e-9cac-17f37bbe099a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
