def return_directory_members(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
members = DirectoryMember.objects.none()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
if user_form.is_valid():
firstName = unicode_tr(user_form.cleaned_data['first_name']).upper()
lastName = unicode_tr(user_form.cleaned_data['last_name']).upper()
email = user_form.cleaned_data.get('email')
if not (firstName or lastName or email):
members = DirectoryMember.objects.all()
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
members = DirectoryMember.objects.filter(query)
return render(request, 'yonetim/kurul-uyeleri.html', {'members': members, 'user_form': user_form})
def return_directory_members(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
members = DirectoryMember.objects.filter(kobilid=2)
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
if user_form.is_valid():
firstName = user_form.cleaned_data.get('first_name')
lastName = user_form.cleaned_data.get('last_name')
email = user_form.cleaned_data.get('email')
if not (firstName or lastName or email):
messages.warning(request, 'Lütfen Arama Kriteri Giriniz.')
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
members = DirectoryMember.objects.filter(
kobilid=2).filter(query)
return render(request, 'yonetim/kurul-uyeleri.html', {
'members': members,
'user_form': user_form
})
def antroner(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
referee = ReferenceCoach.objects.none()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
firstName = unicode_tr(request.POST.get('first_name')).upper()
lastName = unicode_tr(request.POST.get('last_name')).upper()
email = request.POST.get('email')
active = request.POST.get('is_active')
if not (firstName or lastName or email or active):
referee = ReferenceCoach.objects.all()
else:
query = Q()
if lastName:
query &= Q(last_name__icontains=lastName)
if firstName:
query &= Q(first_name__icontains=firstName)
if email:
query &= Q(email__icontains=email)
if active == '1':
query &= Q(status=ReferenceCoach.WAITED)
if active == '2':
query &= Q(status=ReferenceCoach.APPROVED)
if active == '3':
query &= Q(status=ReferenceCoach.DENIED)
referee = ReferenceCoach.objects.filter(query)
return render(request, 'basvurular/antrenorbasvuru.html', {
'referees': referee,
'user_form': user_form
})
def return_users(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
users = User.objects.none()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
if user_form.is_valid():
firstName = unicode_tr(request.POST.get('first_name')).upper()
lastName = unicode_tr(request.POST.get('last_name')).upper()
email = user_form.cleaned_data.get('email')
active = request.POST.get('is_active')
if not (firstName or lastName or email or active):
users = User.objects.all()
else:
query = Q()
if lastName:
query &= Q(last_name__icontains=lastName)
if firstName:
query &= Q(first_name__icontains=firstName)
if email:
query &= Q(email__icontains=email)
if active == 'True':
query &= Q(is_active=True)
if active == 'False':
query &= Q(is_active=False)
users = User.objects.filter(query)
return render(request, 'kullanici/kullanicilar.html', {
'users': users,
'user_form': user_form
})
def return_log(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
logs = Logs.objects.none()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
if user_form.is_valid():
firstName = user_form.cleaned_data.get('first_name')
lastName = user_form.cleaned_data.get('last_name')
email = user_form.cleaned_data.get('email')
if not (firstName or lastName or email):
logs = Logs.objects.all().order_by('-creationDate')
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
logs = Logs.objects.filter(query).order_by('-creationDate')
return render(request, 'Log/Logs.html', {
'logs': logs,
'user_form': user_form
})
def return_employees(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
user_form = UserSearchForm()
employees = Employee.objects.none()
get = request.GET.get('get')
if get:
if get == 'hepsi':
employees = Employee.objects.all()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
if user_form.is_valid() :
firstName = user_form.cleaned_data.get('first_name')
lastName = user_form.cleaned_data.get('last_name')
email = user_form.cleaned_data.get('email')
workDefinition=user_form.cleaned_data.get('workDefinition')
group=request.POST.get('group')
if not (firstName or lastName or email or workDefinition or group):
employees = Employee.objects.all()
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
if workDefinition:
query &= Q(workDefinition=workDefinition)
if group:
query &=Q(user__groups__name=group)
employees = Employee.objects.filter(query).distinct()
return render(request, 'personel/personeller.html',
{'employees': employees, 'user_form': user_form,})
def return_log(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
logs = Logs.objects.none()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
firstName = request.POST.get('first_name')
lastName = request.POST.get('last_name')
email = request.POST.get('email')
playDate = request.POST.get('playDate')
finishDate = request.POST.get('finishDate')
if playDate:
playDate = datetime.strptime(playDate, '%d/%m/%Y').date()
if finishDate:
finishDate = datetime.strptime(finishDate, "%d/%m/%Y").date()
if not (firstName or lastName or email or playDate or finishDate):
logs = Logs.objects.all().order_by('-creationDate')
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
if playDate:
query &= Q(creationDate__gte=playDate)
if finishDate:
query &= Q(creationDate__lt=finishDate)
logs = Logs.objects.filter(query).order_by('-creationDate')
return render(request, 'Log/Logs.html', {
'logs': logs,
'user_form': user_form
})
def choose_sport_club_user(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
sportClubUsers = SportClubUser.objects.all()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
athletes1 = request.POST.getlist('selected_options')
if user_form.is_valid():
firstName = user_form.cleaned_data.get('first_name')
lastName = user_form.cleaned_data.get('last_name')
email = user_form.cleaned_data.get('email')
if not (firstName or lastName or email):
print('')
# messages.warning(request, 'Lütfen Arama Kriteri Giriniz.')
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
sportClubUsers = SportClubUser.objects.filter(query)
if athletes1:
students = [int(x) for x in athletes1]
instances = SportClubUser.objects.filter(id__in=students)
club = SportsClub.objects.get(pk=pk)
for club_user in instances:
club.clubUser.add(club_user)
club.save()
messages.success(request, 'Kulüp Üyesi Başarıyla Eklenmiştir.')
return redirect('sbs:update-club', pk=pk)
return render(request, 'kulup/kulupuyesisec.html', {
'coaches': sportClubUsers,
'user_form': user_form
})
def musabaka_rapor(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
competition = Competition.objects.get(pk=pk)
compathlete = CompetitionsAthlete.objects.none()
weight = Weight.objects.all()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
firstName = unicode_tr(request.POST.get('first_name')).upper()
lastName = unicode_tr(request.POST.get('last_name')).upper()
email = request.POST.get('email')
category = request.POST.get('category')
siklet = request.POST.get('siklet')
if not (firstName or lastName or email or category or siklet):
compathlete = CompetitionsAthlete.objects.filter(
competition=competition)
else:
query = Q()
if lastName:
query &= Q(last_name__icontains=lastName)
if firstName:
query &= Q(first_name__icontains=firstName)
if email:
query &= Q(email__icontains=email)
if siklet:
query &= Q(siklet_id=siklet)
if category:
query &= Q(category_id=category)
compathlete = CompetitionsAthlete.objects.filter(
competition=competition).filter(query)
return render(
request, 'musabaka/musabaka-basvuru-raporu.html', {
'referees': compathlete,
'competition': competition,
'user_form': user_form,
'weight': weight
})
def choose_coach(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
coaches = Coach.objects.all()
user_form = UserSearchForm()
if request.method == 'POST':
if user_form.is_valid():
firstName = unicode_tr(user_form.cleaned_data['first_name']).upper()
lastName = unicode_tr(user_form.cleaned_data['last_name']).upper()
email = user_form.cleaned_data.get('email')
if not (firstName or lastName or email):
messages.warning(request, 'Lütfen Arama Kriteri Giriniz.')
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
coaches = Coach.objects.filter(query)
user_form = UserSearchForm(request.POST)
athletes1 = request.POST.getlist('selected_options')
if athletes1:
students = [int(x) for x in athletes1]
instances = Coach.objects.filter(id__in=students)
club = SportsClub.objects.get(pk=pk)
for coach in instances:
club.coachs.add(coach)
club.save()
messages.success(request, 'Antrenör Başarıyla Eklenmiştir.')
return redirect('sbs:update-club', pk=pk)
return render(request, 'antrenor/antrenorsec.html', {'coaches': coaches, 'user_form': user_form})
def return_employes(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
members = Employe.objects.none()
user_form = UserSearchForm()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
if user_form.is_valid():
firstName = unicode_tr(
user_form.cleaned_data['first_name']).upper()
lastName = unicode_tr(user_form.cleaned_data['last_name']).upper()
email = user_form.cleaned_data.get('email')
active = general_methods.controlGroup(request)
if not (firstName or lastName or email):
if active != 'Personel':
members = Employe.objects.all()
else:
members = Employe.objects.filter(user=request.user)
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
if active != 'Personel':
members = Employe.objects.filter(query)
else:
members = Employe.objects.filter(
user=request.user).filter(query)
return render(request, 'personel/personelListesi.html', {
'members': members,
'user_form': user_form
})
def return_claim(request):
perm = general_methods.control_access(request)
active = general_methods.controlGroup(request)
if not perm:
logout(request)
return redirect('accounts:login')
destek_form = DestekSearchform()
destek = Claim.objects.none()
user_form = UserSearchForm()
if request.method == 'POST':
destek_form = DestekSearchform(request.POST or None)
status = request.POST.get('status')
importanceSort = request.POST.get('importanceSort')
firstName = unicode_tr(request.POST.get('first_name')).upper()
lastName = unicode_tr(request.POST.get('last_name')).upper()
if not (status or importanceSort):
if active == 'Admin' or active == 'Arsiv':
destek = Claim.objects.all()
else:
query = Q()
if status:
query &= Q(status=status)
if importanceSort:
query &= Q(importanceSort=importanceSort)
if lastName:
query &= Q(last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if active == 'Admin' or active == 'Arsiv':
destek = Claim.objects.filter(query)
return render(request, 'Destek/DestekTalepListesi.html', {
'claims': destek,
'destek_form': destek_form,
'user_form': user_form,
})
def return_club_person(request):
perm = general_methods.control_access_klup(request)
active = general_methods.controlGroup(request)
if not perm:
logout(request)
return redirect('accounts:login')
user_form = UserSearchForm()
user = request.user
club_user_array = SportClubUser.objects.none()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
sportsclup = request.POST.get('sportsClub')
if user_form.is_valid():
firstName = unicode_tr(user_form.cleaned_data['first_name']).upper()
lastName = unicode_tr(user_form.cleaned_data['last_name']).upper()
email = user_form.cleaned_data.get('email')
if not (firstName or lastName or email or sportsclup):
club_user_array = []
if active == 'KlupUye':
clubuser = SportClubUser.objects.get(user=user)
clubs = SportsClub.objects.filter(clubUser=clubuser)
clubsPk = []
for club in clubs:
clubsPk.append(club.pk)
club_user_array = SportClubUser.objects.filter(sportsclub__in=clubsPk).distinct()
elif active == 'Yonetim' or active == 'Admin':
club_user_array = SportClubUser.objects.all()
else:
query = Q()
if lastName:
query &= Q(user__last_name__icontains=lastName)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if email:
query &= Q(user__email__icontains=email)
if sportsclup:
query &= Q(sportsclub__name__icontains=sportsclup)
club_user_array = []
if active == 'KlupUye':
clubuser = SportClubUser.objects.get(user=user)
clubs = SportsClub.objects.filter(clubUser=clubuser)
clubsPk = []
for club in clubs:
clubsPk.append(club.pk)
club_user_array = SportClubUser.objects.filter(sportsclub__in=clubsPk).filter(query).distinct()
elif active == 'Yonetim' or active == 'Admin':
club_user_array = SportClubUser.objects.filter(query).distinct()
sportclup = SearchClupForm(request.POST, request.FILES or None)
if active == 'KlupUye':
sc_user = SportClubUser.objects.get(user=user)
clubs = SportsClub.objects.filter(clubUser=sc_user)
clubsPk = []
for club in clubs:
clubsPk.append(club.pk)
sportclup.fields['sportsClub'].queryset = SportsClub.objects.filter(id__in=clubsPk)
elif active == 'Yonetim' or active == 'Admin':
sportclup.fields['sportsClub'].queryset = SportsClub.objects.all()
return render(request, 'kulup/kulup-uyeleri.html',
{'athletes': club_user_array, 'user_form': user_form, 'Sportclup': sportclup})
def return_penal_athlete(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
user_form = UserSearchForm()
data = []
if request.method == 'POST':
firstName = unicode_tr(request.POST.get('first_name')).upper()
lastName = unicode_tr(request.POST.get('last_name')).upper()
tcno = request.POST.get('tc')
email = request.POST.get('email')
if not (firstName or lastName or email or tcno):
test = Athlete.objects.exclude(person__penal__penal=None)
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = Coach.objects.exclude(person__penal__penal=None)
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = Judge.objects.exclude(person__penal__penal=None)
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = SportClubUser.objects.exclude(person__penal__penal=None)
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = DirectoryMember.objects.exclude(person__penal__penal=None)
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
elif firstName or lastName or email or sportsclup or coach or tcno:
query = Q()
if firstName:
query &= Q(user__first_name__icontains=firstName)
if tcno:
query &= Q(person__tc__icontains=tcno)
if lastName:
query &= Q(user__last_name__icontains=lastName)
if email:
query &= Q(user__email__icontains=email)
test = Athlete.objects.exclude(
person__penal__penal=None).filter(query).distinct()
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = Coach.objects.exclude(
person__penal__penal=None).filter(query).distinct()
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = Judge.objects.exclude(
person__penal__penal=None).filter(query).distinct()
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = SportClubUser.objects.exclude(
person__penal__penal=None).filter(query).distinct()
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
test = DirectoryMember.objects.exclude(
person__penal__penal=None).filter(query).distinct()
for item in test:
for penals in item.person.penal.all():
beka = {
'name': item.user.get_full_name(),
'penal': penals.penal,
'document': penals.file,
}
data.append(beka)
return render(request, 'Ceza/ceza-Listesi.html', {
'activity': data,
'user_form': user_form,
})
def return_athletes(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
login_user = request.user
user = User.objects.get(pk=login_user.pk)
user_form = UserSearchForm()
# # arama açıldıgı zaman burasi sillinecek
# if user.groups.filter(name='KulupUye'):
# sc_user = SportClubUser.objects.get(user=user)
# clubsPk = []
# clubs = SportsClub.objects.filter(clubUser=sc_user)
# for club in clubs:
# clubsPk.append(club.pk)
# athletes = Athlete.objects.filter(licenses__sportsClub__in=clubsPk).distinct()
# elif user.groups.filter(name__in=['Yonetim', 'Admin']):
# athletes = Athlete.objects.all()
# # silinecek son
athletes = Athlete.objects.none()
if request.method == 'POST':
user_form = UserSearchForm(request.POST)
brans = request.POST.get('branch')
sportsclup = request.POST.get('sportsClub')
if user_form.is_valid():
firstName = user_form.cleaned_data.get('first_name')
lastName = user_form.cleaned_data.get('last_name')
email = user_form.cleaned_data.get('email')
if not (firstName or lastName or email or brans or sportsclup):
if user.groups.filter(name='KulupUye'):
sc_user = SportClubUser.objects.get(user=user)
clubsPk = []
clubs = SportsClub.objects.filter(clubUser=sc_user)
for club in clubs:
clubsPk.append(club.pk)
athletes = Athlete.objects.filter(
licenses__sportsClub__in=clubsPk).distinct()
elif user.groups.filter(name__in=['Yonetim', 'Admin']):
athletes = Athlete.objects.all()
elif firstName or lastName or email or sportsclup or brans:
query = Q()
clubsPk = []
clubs = SportsClub.objects.filter(
name=request.POST.get('sportsClub'))
for club in clubs:
clubsPk.append(club.pk)
if firstName:
query &= Q(user__first_name__icontains=firstName)
if lastName:
query &= Q(user__last_name__icontains=lastName)
if email:
query &= Q(user__email__icontains=email)
if sportsclup:
query &= Q(licenses__sportsClub__in=clubsPk)
if brans:
query &= Q(licenses__branch=brans,
licenses__status='Onaylandı')
if user.groups.filter(name='KulupUye'):
sc_user = SportClubUser.objects.get(user=user)
clubsPk = []
clubs = SportsClub.objects.filter(clubUser=sc_user)
for club in clubs:
clubsPk.append(club.pk)
athletes = Athlete.objects.filter(
licenses__sportsClub__in=clubsPk).filter(
query).distinct()
elif user.groups.filter(name__in=['Yonetim', 'Admin']):
athletes = Athlete.objects.filter(query).distinct()
sportclup = SearchClupForm(request.POST, request.FILES or None)
if user.groups.filter(name='KulupUye'):
sc_user = SportClubUser.objects.get(user=user)
clubs = SportsClub.objects.filter(clubUser=sc_user)
clubsPk = []
for club in clubs:
clubsPk.append(club.pk)
sportclup.fields['sportsClub'].queryset = SportsClub.objects.filter(
id__in=clubsPk)
elif user.groups.filter(name__in=['Yonetim', 'Admin']):
sportclup.fields['sportsClub'].queryset = SportsClub.objects.all()
return render(request, 'sporcu/sporcular.html', {
'athletes': athletes,
'user_form': user_form,
'Sportclup': sportclup
})