def search(request):
query = request.GET.get('q', '')
if query:
try:
member_id = int(query)
return HttpResponseRedirect(
reverse('member_detail', args=(member_id, )))
except ValueError:
members_query = Member.objects.filter(
Q(member_id=F('players__pin_player'))).filter(
full_name__icontains=query).values(
"member_id", "chapter_id", "join_date", "state",
"players__rating", "country", "full_name",
"family_name").order_by('family_name')
member_table = MemberTable(members_query)
RequestConfig(request, paginate={
'per_page': 100
}).configure(member_table)
return render(request, 'agagd_core/search_player.html', {
'member_table': member_table,
'query': query,
})
else:
return HttpResponseRedirect('/')
def chapter_detail(request, chapter_code):
chapter = Chapters.objects.get(code=chapter_code)
member_table = MemberTable(Member.objects.filter(chapter=chapter_code).order_by('family_name') )
return render(request, 'agagd_core/chapter.html',
{
'member_table': member_table,
'chapter': chapter,
})
def country_detail(request, country_name):
member_table = MemberTable(Member.objects.filter(country=country_name).order_by('family_name') )
RequestConfig(request, paginate={'per_page': 100}).configure(member_table)
return render(request, 'agagd_core/country.html',
{
'country_name': country_name,
'member_table': member_table, })
def chapter_detail(request, chapter_id):
chapter = get_object_or_404(Chapters, member_id=chapter_id)
member_table = MemberTable(
Member.objects.filter(chapter_id=chapter_id).values(
"member_id", "chapter_id", "renewal_due", "state",
"players__rating", "country", "full_name",
"family_name").order_by('family_name'))
return render(request, 'agagd_core/chapter.html', {
'member_table': member_table,
'chapter': chapter,
})
def country_detail(request, country_name):
member_table = MemberTable(
Member.objects.filter(country=country_name).values(
"member_id", "chapter_id", "renewal_due", "state",
"players__rating", "country", "full_name",
"family_name").order_by('family_name'))
RequestConfig(request, paginate={'per_page': 100}).configure(member_table)
return render(request, 'agagd_core/country.html', {
'country_name': country_name,
'member_table': member_table,
})
def search(request):
query = request.GET.get('q', '')
if query:
try:
member_id = int(query)
return HttpResponseRedirect(
reverse('agagd_core.views.member_detail', args=(member_id, )))
except ValueError:
member_table = MemberTable(
Member.objects.filter(
full_name__icontains=query).order_by('family_name'))
RequestConfig(request, paginate={
'per_page': 100
}).configure(member_table)
return render(request, 'agagd_core/search_player.html', {
'member_table': member_table,
'query': query,
})
else:
return HttpResponseRedirect('/')
def country_detail(request, country_name):
member_table = MemberTable(
Member.objects.filter(country=country_name).order_by('family_name'))
return render(request, 'agagd_core/country.html', {
'member_table': member_table,
})