filtering in job list view
[qcg-portal.git] / qcg / views.py
1 from datetime import datetime, timedelta
2 from django.conf import settings
3 from django.contrib.auth import REDIRECT_FIELD_NAME
4 from django.contrib.auth.decorators import login_required
5 from django.core.urlresolvers import reverse
6 from django.db.models import Q
7 from django.http import HttpResponse
8 from django.shortcuts import render, get_object_or_404
9 from django.utils.http import urlencode
10 from django.utils.timezone import UTC
11 from django_openid_auth.views import make_consumer
12 from openid.extensions import ax
13 from pyqcg import QCG
14
15 from qcg.forms import FiltersForm
16 from qcg.utils import update_user_data, paginator_context
17
18
19 def index(request):
20     return render(request, 'qcg/base.html')
21
22
23 def openid_begin(request):
24     openid_request = make_consumer(request).begin(settings.OPENID_SSO_SERVER_URL)
25
26     fetch_request = ax.FetchRequest()
27     for (attr, alias) in [('http://axschema.org/namePerson/friendly', 'nickname'),
28                           ('http://axschema.org/contact/email', 'email'),
29                           ('http://axschema.org/namePerson', 'fullname'),
30                           ('http://openid.plgrid.pl/certificate/proxy', 'proxy'),
31                           ('http://openid.plgrid.pl/certificate/userCert', 'userCert'),
32                           ('http://openid.plgrid.pl/certificate/proxyPrivKey', 'proxyPrivKey'),
33                           ('http://openid.plgrid.pl/POSTresponse', 'POSTresponse')]:
34         fetch_request.add(ax.AttrInfo(attr, alias=alias, required=True))
35     openid_request.addExtension(fetch_request)
36
37     return_to = request.build_absolute_uri(reverse('openid-complete'))
38
39     redirect_to = request.GET.get(REDIRECT_FIELD_NAME)
40     if redirect_to:
41         return_to += '?' + urlencode({REDIRECT_FIELD_NAME: redirect_to})
42
43     return HttpResponse(openid_request.htmlMarkup(request.build_absolute_uri('/'), return_to))
44
45
46 search_fields = ('status_description', 'type', 'note', 'task_id', 'job__note', 'job__project', 'job__job_id',
47                  'allocations__status_description', 'allocations__processes_group_id', 'allocations__comment')
48
49
50 def parse_date(string):
51     return datetime.strptime(string.strip(), "%d.%m.%Y").replace(tzinfo=UTC())
52
53
54 @login_required
55 def jobs_list(request):
56     # QCG.start()
57     # update_user_data(request.user, request.session['proxy'])
58
59     tasks = request.user.tasks.order_by('-job__submission_time', '-submission_time') \
60         .select_related('job').prefetch_related('allocations__nodes')
61
62     filters = FiltersForm(request.GET)
63     advanced = False
64     if filters.is_valid():
65         keywords = filters.cleaned_data['keywords']
66         status = filters.cleaned_data['status']
67         host = filters.cleaned_data['host']
68         status_exact = filters.cleaned_data['status_exact']
69         submission = filters.cleaned_data['submission']
70         finish = filters.cleaned_data['finish']
71
72         if status:
73             statuses = []
74             for s in status:
75                 statuses.extend(FiltersForm.STATUS_MAP[int(s)])
76
77             print statuses
78
79             tasks = tasks.filter(status__in=statuses)
80         if host:
81             tasks = tasks.filter(allocations__host_name__in=host)
82
83         if keywords:
84             and_query = Q()
85
86             for q in keywords.split():
87                 or_query = Q()
88                 for field in search_fields:
89                     or_query |= Q(**{field + '__icontains': q})
90                 and_query &= or_query
91
92             tasks = tasks.filter(and_query)
93         if status_exact:
94             tasks = tasks.filter(status=status_exact)
95         if submission:
96             start, end = submission.split('-')
97
98             tasks = tasks.filter(submission_time__gte=parse_date(start),
99                                  submission_time__lte=parse_date(end) + timedelta(days=1))
100         if finish:
101             start, end = finish.split('-')
102
103             tasks = tasks.filter(finish_time__gte=parse_date(start),
104                                  finish_time__lte=parse_date(end) + timedelta(days=1))
105
106         advanced = bool(keywords or status_exact or submission or finish)
107
108     context = {'filters': filters, 'advanced': advanced}
109     context.update(paginator_context(request, tasks))
110
111     return render(request, 'qcg/jobs.html', context)
112
113
114 @login_required
115 def job_details(request, job_id):
116     job = get_object_or_404(request.user.jobs.prefetch_related('tasks'), job_id=job_id)
117
118     return render(request, 'qcg/job.html', {'job': job})
119
120
121 def task_details(request, job_id, task_id):
122     task = get_object_or_404(request.user.tasks.select_related('job').prefetch_related('allocations'),
123                              job__job_id=job_id, task_id=task_id)
124
125     return render(request, 'qcg/task.html', {'task': task})