+ update_user_data(request.user, request.session['proxy'])
+
+ tasks = request.user.tasks.order_by('-job__submission_time', '-submission_time') \
+ .select_related('job').prefetch_related('allocations__nodes')
+
+ filters = FiltersForm(request.GET)
+ selected_filters = []
+ if filters.is_valid():
+ keywords = filters.cleaned_data['keywords']
+ status = filters.cleaned_data['status']
+ host = filters.cleaned_data['host']
+ submission = filters.cleaned_data['submission']
+ finish = filters.cleaned_data['finish']
+
+ if keywords:
+ and_query = Q()
+
+ for q in keywords.split():
+ or_query = Q()
+ for field in search_fields:
+ or_query |= Q(**{field + '__icontains': q})
+ and_query &= or_query
+
+ tasks = tasks.filter(and_query)
+ selected_filters.append((keywords, 'keywords', keywords))
+
+ if status:
+ statuses = []
+ for s in status:
+ si = int(s)
+ statuses.extend(FiltersForm.STATUS_MAP[si])
+ selected_filters.append((FiltersForm.STATUS_CHOICES_DICT[si], 'status', s))
+
+ tasks = tasks.filter(status__in=statuses)
+
+ if host:
+ tasks = tasks.filter(allocations__host_name__in=host)
+
+ host_dict = dict(filters.fields['host'].choices)
+ for h in host:
+ selected_filters.append((host_dict[h], 'host', h))
+
+ if submission:
+ start, end = submission.split('-')
+
+ tasks = tasks.filter(submission_time__gte=parse_date(start),
+ submission_time__lte=parse_date(end) + timedelta(days=1))
+ selected_filters.append((u'Data zlecenia: ' + submission, 'submission', submission))
+
+ if finish:
+ start, end = finish.split('-')
+
+ tasks = tasks.filter(finish_time__gte=parse_date(start),
+ finish_time__lte=parse_date(end) + timedelta(days=1))
+ selected_filters.append((u'Data zakończenia: ' + finish, 'finish', finish))
+
+ tasks = tasks.distinct()
+
+ checked_status = {i: widget.is_checked() for i, widget in enumerate(filters['status'])}
+
+ columns = ColumnsForm(QueryDict(request.COOKIES.get('columns', '')))
+
+ displayed = None
+ if columns.is_valid():
+ displayed = {int(c) for c in columns.cleaned_data['columns']}
+
+ # if invalid or empty
+ if not displayed:
+ displayed = set(columns.fields['columns'].initial)
+
+ context = {'filters': filters, 'checked_status': checked_status, 'selected_filters': selected_filters,
+ 'columns': ColumnsForm(initial={'columns': displayed}), 'displayed': displayed}