def musabaka_sporcu_sec(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
weights = Weight.objects.all()
competition = Competition.objects.filter(registerStartDate__lte=timezone.now(),
registerFinishDate__gte=timezone.now())
# login_user = request.user
# user = User.objects.get(pk=login_user.pk)
# competition = Competition.objects.get(pk=pk)
# weights = Weight.objects.all()
# 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()
print(pk)
return render(request, 'musabaka/musabaka-sporcu-sec.html',
{'pk': pk, 'weights': weights, 'application': competition})
def update_athlete(request, pk, competition):
perm = general_methods.control_access_klup(request)
login_user = request.user
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
user = User.objects.get(pk=login_user.pk)
compAthlete = CompAthlete.objects.get(pk=competition)
total = request.POST.get('total')
siklet = request.POST.get('weight')
silk = request.POST.get('silk')
kop = request.POST.get('kop')
if total is not None:
compAthlete.total = total
if siklet is not None:
compAthlete.sıklet = Weight.objects.get(pk=siklet)
if silk is not None:
compAthlete.silk1 = silk
if kop is not None:
compAthlete.kop1 = kop
compAthlete.save()
return JsonResponse({'status': 'Success', 'messages': 'save successfully'})
except SandaAthlete.DoesNotExist:
return JsonResponse({'status': 'Fail', 'msg': 'Object does not exist'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def musabaka_sporcu_sil(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
athlete = CompetitionsAthlete.objects.get(pk=pk)
log = str(athlete.athlete.user.get_full_name()
) + " müsabakadan silindi "
log = general_methods.logwrite(request, request.user, log)
athlete.delete()
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except SandaAthlete.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def deneme(request):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
return render(request, 'sporcu/deneme.html')
def update_athlete(request, pk, competition):
perm = general_methods.control_access_klup(request)
login_user = request.user
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
compAthlete = CompetitionsAthlete.objects.get(pk=competition)
if Weight.objects.filter(pk=request.POST.get('category')):
compAthlete.siklet = Weight.objects.get(
pk=request.POST.get('category'))
if Category.objects.filter(pk=request.POST.get('year')):
compAthlete.category = Category.objects.get(
pk=request.POST.get('year'))
compAthlete.save()
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except SandaAthlete.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def musabaka_link_update(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
link = Link.objects.get(pk=pk)
if request.POST.get('defi'):
link.definition = request.POST.get('defi')
if request.POST.get('link'):
link.youtubelink = request.POST.get('link')
link.save()
log = str(pk) + " link güncellendi"
log = general_methods.logwrite(request, request.user, log)
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except SandaAthlete.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def choose_referee_ajax(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
competition = Competition.objects.get(pk=pk)
# if Link.objects.filter(pk=request.POST.get('pk')):
#
# return JsonResponse({'status': 'Success', 'messages': 'save successfully'})
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except SandaAthlete.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def antrenor_sporcu_ajax(request):
perm = general_methods.control_access_klup(request)
login_user = request.user
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
if request.POST.get('coach'):
coach = request.POST.get('coach')
beka = []
# antrenor verisi alınıp sistemde filtreleme yapılacak
for item in Athlete.objects.filter(
licenses__coach=Coach.objects.filter(pk=coach)[0]):
data = {
'pk': item.pk,
'name': item.user.get_full_name(),
}
beka.append(data)
return JsonResponse({'data': beka})
# return HttpResponse(serializers.serialize("json", Coach.objects.all()))
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def musabaka_photo_sil(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
dokuman = CompetitionPhotoDocumentDocument.objects.get(pk=pk)
log = str(dokuman.title) + " resim silindi "
log = general_methods.logwrite(request, request.user, log)
dokuman.delete()
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except SandaAthlete.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def return_competitions(request):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
comquery = CompetitionSearchForm()
competition = Competition.objects.filter(registerStartDate__lte=timezone.now(),
registerFinishDate__gte=timezone.now())
competitions = Competition.objects.none()
if request.method == 'POST':
name = request.POST.get('name')
startDate = request.POST.get('startDate')
compType = request.POST.get('compType')
compGeneralType = request.POST.get('compGeneralType')
if name or startDate or compType or compGeneralType:
query = Q()
if name:
query &= Q(name__icontains=name)
if startDate:
query &= Q(year=int(startDate))
if compType:
query &= Q(compType__in=compType)
if compGeneralType:
query &= Q(compGeneralType__in=compGeneralType)
competitions = Competition.objects.filter(query).order_by('-startDate').distinct()
else:
competitions = Competition.objects.all().order_by('-startDate')
return render(request, 'musabaka/musabakalar.html',
{'competitions': competitions, 'query': comquery, 'application': competition})
def result_list(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
competition = Competition.objects.get(pk=pk)
compAthlete = CompetitionsAthlete.objects.exclude(degree=0).filter(competition=pk).order_by('degree')
return render(request, 'musabaka/musabaka-sonuclar.html',
{ 'compAthlete': compAthlete,'competition':competition})
def choose_athlete(request, pk, competition):
perm = general_methods.control_access_klup(request)
login_user = request.user
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
if request.POST.get('weight'):
user = User.objects.get(pk=login_user.pk)
competition = Competition.objects.get(pk=competition)
athlete = Athlete.objects.get(pk=pk)
compAthlete = CompetitionsAthlete()
if CompetitionsAthlete.objects.filter(competition=competition).filter(athlete=athlete).count() <= 1:
if CompetitionsAthlete.objects.filter(competition=competition).filter(athlete=athlete):
competitionAthlete=CompetitionsAthlete.objects.get(athlete=athlete , competition=competition)
katagori=competitionAthlete.category.pk
if str(katagori) != request.POST.get('weight'):
if request.POST.get('sporcu'):
compAthlete.athleteTwo = Athlete.objects.get(pk=request.POST.get('sporcu'))
compAthlete.athlete = athlete
compAthlete.competition = competition
compAthlete.category = Category.objects.get(pk=request.POST.get('weight'))
compAthlete.save()
log = str(athlete.user.get_full_name()) + " Musabakaya sporcu eklendi "
log = general_methods.logwrite(request, request.user, log)
return JsonResponse({'status': 'Success', 'msg': 'Sporcu Başarı ile kaydedilmiştir.'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Aynı kategoride kayıt vardır.'})
else:
if request.POST.get('sporcu'):
compAthlete.athleteTwo = Athlete.objects.get(pk=request.POST.get('sporcu'))
compAthlete.athlete = athlete
compAthlete.competition = competition
compAthlete.category = Category.objects.get(pk=request.POST.get('weight'))
compAthlete.save()
log = str(athlete.user.get_full_name()) + " Musabakaya sporcu eklendi "
log = general_methods.logwrite(request, request.user, log)
return JsonResponse({'status': 'Success', 'msg': 'Sporcu Başarı ile kaydedilmiştir.'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Bir sporcu 3. defa eklenemez.'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Eksik'})
except SandaAthlete.DoesNotExist:
return JsonResponse({'status': 'Fail', 'msg': 'Object does not exist'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def choose_athlete_remove(request, pk, exam_pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
sinav = BeltExam.objects.get(pk=exam_pk)
sinav.athletes.remove(Athlete.objects.get(pk=pk))
return redirect('sbs:kusak-sinavi-incele', pk=exam_pk)
def musabaka_sporcu_sec(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
category = Category.objects.all()
competition = Competition.objects.filter(registerStartDate__lte=timezone.now(),
registerFinishDate__gte=timezone.now())
return render(request, 'musabaka/musabaka-sporcu-sec.html',
{'pk': pk, 'weights': category, 'application': competition})
def return_clubs(request):
perm = general_methods.control_access_klup(request)
active = general_methods.controlGroup(request)
if not perm:
logout(request)
return redirect('accounts:login')
user = request.user
clubs = SportsClub.objects.none()
ClupsSearchForm = ClubSearchForm(request.POST)
if request.method == 'POST':
if ClupsSearchForm.is_valid():
kisi = ClupsSearchForm.cleaned_data.get('kisi')
city = ClupsSearchForm.cleaned_data.get('city')
name = ClupsSearchForm.cleaned_data.get('name')
shortName = ClupsSearchForm.cleaned_data.get('shortName')
clubMail = ClupsSearchForm.cleaned_data.get('clubMail')
if not (kisi or city or name or shortName or clubMail):
if active == 'KlupUye':
clubuser = SportClubUser.objects.get(user=user)
clubs = SportsClub.objects.filter(clubUser=clubuser).order_by("-pk")
elif active == 'Yonetim' or active == 'Admin':
clubs = SportsClub.objects.all().order_by("-pk")
else:
query = Q()
if city:
query &= Q(communication__city__name__icontains=city)
if name:
query &= Q(name__icontains=name)
if clubMail:
query &= Q(clubMail__icontains=clubMail)
if shortName:
query &= Q(shortName__icontains=shortName)
if kisi:
query &= Q(clubUser=kisi)
if active == 'KlupUye':
clubuser = SportClubUser.objects.get(user=user)
clubs = SportsClub.objects.filter(clubUser=clubuser).filter(query)
elif active == 'Yonetim' or active == 'Admin':
clubs = SportsClub.objects.filter(query)
return render(request, 'kulup/kulupler.html', {'clubs': clubs, 'ClupsSearchForm': ClupsSearchForm, })
def return_coach_dashboard(request):
perm = general_methods.control_access_klup(request)
login_user = request.user
user = User.objects.get(pk=login_user.pk)
coach = Coach.objects.get(user=user)
clup = SportsClub.objects.filter(coachs=coach)
clupsPk = []
for item in clup:
clupsPk.append(item.pk)
athletes = Athlete.objects.filter(
licenses__sportsClub_id__in=clupsPk).distinct()
athletes |= Athlete.objects.filter(licenses__coach=coach).distinct()
athlete_count = athletes.count()
return render(request, 'anasayfa/antrenor.html',
{'athlete_count': athlete_count})
def choose_athlete(request, pk, competition):
perm = general_methods.control_access_klup(request)
login_user = request.user
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
if (request.POST.get('total') and request.POST.get('silk') and request.POST.get('kop') and request.POST.get(
'weight')):
user = User.objects.get(pk=login_user.pk)
competition = Competition.objects.get(pk=competition)
athlete = Athlete.objects.get(pk=pk)
compAthlete = CompAthlete()
compAthlete.athlete = athlete
compAthlete.competition = competition
compAthlete.total = request.POST.get('total')
compAthlete.sıklet = Weight.objects.get(pk=request.POST.get('weight'))
compAthlete.silk1 = request.POST.get('silk')
compAthlete.kop1 = request.POST.get('kop')
if (int(request.POST.get('silk')) + int(request.POST.get('kop'))) - 20 <= int(
request.POST.get('total')):
compAthlete.save()
log = str(athlete.user.get_full_name()) + " Musabaka sporcu eklendi "
log = general_methods.logwrite(request, request.user, log)
return JsonResponse({'status': 'Success', 'messages': 'save successfully'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Kural20'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Eksik'})
except SandaAthlete.DoesNotExist:
return JsonResponse({'status': 'Fail', 'msg': 'Object does not exist'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def choose_athlete_update(request, pk, competition):
perm = general_methods.control_access_klup(request)
login_user = request.user
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
# bu alanda sporcu güncelleme alani olacak kategorisini güncelleme yapabilecegiz
return JsonResponse({'status': 'Success', 'msg': 'save successfully'})
except SandaAthlete.DoesNotExist:
return JsonResponse({'status': 'Fail', 'msg': 'Object does not exist'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def aplication(request, pk):
perm = general_methods.control_access_klup(request)
active = general_methods.controlGroup(request)
if not perm:
logout(request)
return redirect('accounts:login')
musabaka = Competition.objects.get(pk=pk)
login_user = request.user
user = User.objects.get(pk=login_user.pk)
weights = Weight.objects.all()
if active == 'KlupUye':
sc_user = SportClubUser.objects.get(user=user)
if sc_user.dataAccessControl == True:
if active == 'KlupUye':
clubsPk = []
clubs = SportsClub.objects.filter(clubUser=sc_user)
for club in clubs:
clubsPk.append(club.pk)
comAthlete = CompetitionsAthlete.objects.filter(
competition=pk,
athlete__licenses__sportsClub__in=clubsPk).distinct()
else:
messages.warning(
request, 'Lütfen Eksik olan Sporcu Bilgilerini tamamlayiniz.')
return redirect('sbs:musabakalar')
elif active == 'Yonetim' or active == 'Admin':
comAthlete = CompetitionsAthlete.objects.filter(
competition=pk).distinct()
elif active == 'Antrenor':
coach = Coach.objects.get(user=user)
comAthlete = CompetitionsAthlete.objects.filter(
competition=pk, athlete__licenses__coach=coach).distinct()
return render(request, 'musabaka/basvuru.html', {
'athletes': comAthlete,
'competition': musabaka,
'weights': weights
})
def antrenor_ajax(request):
perm = general_methods.control_access_klup(request)
login_user = request.user
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
beka = []
for item in Coach.objects.all():
data = {
'pk': item.pk,
'name': item.user.get_full_name(),
}
beka.append(data)
return JsonResponse({'data': beka})
# return HttpResponse(serializers.serialize("json", Coach.objects.all()))
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def sporcu_lisans_sil(request, pk, athlete_pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
obj = License.objects.get(pk=pk)
athlete = Athlete.objects.get(pk=athlete_pk)
athlete.licenses.remove(obj)
obj.delete()
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except Level.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def updateClubPersonsProfile(request):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
user = request.user
club_user = SportClubUser.objects.get(user=user)
person = Person.objects.get(pk=club_user.person.pk)
communication = Communication.objects.get(pk=club_user.communication.pk)
user_form = DisabledUserForm(request.POST or None, instance=user)
person_form = DisabledPersonForm(request.POST or None, request.FILES or None, instance=person)
communication_form = DisabledCommunicationForm(request.POST or None, instance=communication)
club_form = DisabledSportClubUserForm(request.POST or None, instance=club_user)
password_form = SetPasswordForm(request.user, request.POST)
if request.method == 'POST':
data = request.POST.copy()
person_form = DisabledPersonForm(data)
if len(request.FILES) > 0:
person.profileImage = request.FILES['profileImage']
person.save()
messages.success(request, 'Profil Fotoğrafı Başarıyla Güncellenmiştir.')
if password_form.is_valid():
user.set_password(password_form.cleaned_data['new_password2'])
user.save()
update_session_auth_hash(request, user)
messages.success(request, 'Şifre Başarıyla Güncellenmiştir.')
return redirect('sbs:kulup-uyesi-profil-guncelle')
return render(request, 'kulup/kulup-uyesi-profil-guncelle.html',
{'user_form': user_form, 'communication_form': communication_form,
'person_form': person_form, 'password_form': password_form, 'club_form': club_form})
def musabaka_hakem_delete(request, pk):
perm = general_methods.control_access_klup(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
competition = Competition.objects.get(pk=pk)
if CompetitionJudgeRole.objects.filter(pk=request.POST.get('pk')):
role = CompetitionJudgeRole.objects.get(
pk=request.POST.get('pk'))
log = str(competition.name
) + " müsabasından" + role.judge.user.get_full_name(
) + " hakem silindi "
log = general_methods.logwrite(request, request.user, log)
competition.judges.remove(role)
competition.save()
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except SandaAthlete.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
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_club_user_dashboard(request):
active = general_methods.controlGroup(request)
perm = general_methods.control_access_klup(request)
# x = general_methods.import_csv()
if not perm:
logout(request)
return redirect('accounts:login')
login_user = request.user
user = User.objects.get(pk=login_user.pk)
current_user = request.user
clubuser = SportClubUser.objects.get(user=current_user)
club = SportsClub.objects.none()
if SportsClub.objects.filter(clubUser=clubuser):
club = SportsClub.objects.filter(clubUser=clubuser)[0]
total_club_user = 0
total_coach = 0
if SportsClub.objects.filter(clubUser=clubuser):
total_club_user = club.clubUser.count()
total_coach = Coach.objects.filter(sportsclub=club).count()
sc_user = SportClubUser.objects.get(user=user)
clubsPk = []
clubs = SportsClub.objects.filter(clubUser=sc_user)
for club in clubs:
clubsPk.append(club.pk)
total_athlete = Athlete.objects.filter(
licenses__sportsClub__in=clubsPk).distinct().count()
# Sporcu bilgilerinde eksik var mı diye control
athletes = Athlete.objects.none()
if active == 'KlupUye':
sc_user = SportClubUser.objects.get(user=user)
if sc_user.dataAccessControl == False or sc_user.dataAccessControl == None:
clubsPk = []
clubs = SportsClub.objects.filter(clubUser=sc_user)
for club in clubs:
if club.dataAccessControl == False or club.dataAccessControl is None:
clubsPk.append(club.pk)
# print(len(clubsPk))
if len(clubsPk) != 0:
athletes = Athlete.objects.filter(
licenses__sportsClub__in=clubsPk).distinct()
athletes = athletes.filter(
user__last_name=''
) | athletes.filter(user__first_name='') | athletes.filter(
user__email=''
) | athletes.filter(person__tc='') | athletes.filter(
person__birthDate=None) | athletes.filter(
person__gender=None) | athletes.filter(
person__birthplace='') | athletes.filter(
person__motherName='') | athletes.filter(
person__fatherName='') | athletes.filter(
communication__city__name=''
) | athletes.filter(
communication__country__name='')
# false degerinde clubun eksigi yok anlamında kulanilmistir.
for club in clubs:
if athletes:
club.dataAccessControl = False
club.save()
else:
club.dataAccessControl = True
club.save()
if athletes:
sc_user.dataAccessControl = False
else:
sc_user.dataAccessControl = True
sc_user.save()
else:
sc_user.dataAccessControl = True
sc_user.save()
return render(
request, 'anasayfa/kulup-uyesi.html', {
'total_club_user': total_club_user,
'total_coach': total_coach,
'total_athlete': total_athlete,
'athletes': athletes
})
def return_coach_dashboard(request):
perm = general_methods.control_access_klup(request)
login_user = request.user
user = User.objects.get(pk=login_user.pk)
coach = Coach.objects.get(user_id=request.user.pk)
clup = SportsClub.objects.filter(coachs=coach)
clupsPk = []
for item in clup:
clupsPk.append(item.pk)
athletes = Athlete.objects.filter(
licenses__sportsClub_id__in=clupsPk).distinct()
athletes |= Athlete.objects.filter(licenses__coach=coach).distinct()
athlete_count = athletes.count()
max = 0
max_male = 0
max_female = 0
maxcom = Competition.objects.none()
competitions = Competition.objects.filter().order_by('creationDate')
# if competitions:
# for item in competitions:
# if max < int(CompetitionsAthlete.objects.filter(competition=item).count()):
# maxcom = item
# max = int(CompetitionsAthlete.objects.filter(competition=item).count())
#
# max = CompetitionsAthlete.objects.filter(competition=maxcom).count()
# max_male = CompetitionsAthlete.objects.filter(competition=maxcom, athlete__person__gender=Person.MALE).count()
# max_female = CompetitionsAthlete.objects.filter(competition=maxcom,
# athlete__person__gender=Person.FEMALE).count()
# competitions = Competition.objects.none()
# lastcompetition = competitions
if Competition.objects.all():
competitions = Competition.objects.all().order_by('creationDate')[:6]
lastcompetition = Competition.objects.filter().order_by(
'-creationDate')[0]
datacount = []
for item in competitions:
competition = CompetitionsAthlete.objects.filter(
competition_id=item.pk)
beka = {'count': competition.count(), 'competiton': item}
datacount.append(beka)
last_athlete = Athlete.objects.order_by('-creationDate')[:8]
total_club = SportsClub.objects.all().count()
total_athlete = Athlete.objects.all().count()
total_athlete_gender_man = Athlete.objects.filter(
person__gender=Person.MALE).count()
total_athlete_gender_woman = Athlete.objects.filter(
person__gender=Person.FEMALE).count()
total_athlate_last_month = Athlete.objects.exclude(
user__date_joined__month=datetime.now().month).count()
total_club_user = SportClubUser.objects.all().count()
total_coachs = Coach.objects.all().count()
total_judge = Judge.objects.all().count()
return render(
request,
'anasayfa/antrenor.html',
{
'athlete_count': athlete_count,
'max_male': max_male,
'max_female': max_female,
# 'competition_male': CompetitionsAthlete.objects.filter(competition=lastcompetition,
# athlete__person__gender=Person.MALE).count(),
# 'competition_male_x': int((CompetitionsAthlete.objects.filter(competition=lastcompetition,
# athlete__person__gender=Person.MALE).count() * 100) / CompetitionsAthlete.objects.filter(
# competition=maxcom, athlete__person__gender=Person.MALE).count()),
# 'competition_female': CompetitionsAthlete.objects.filter(competition=lastcompetition,
# athlete__person__gender=Person.FEMALE).count(),
# 'competition_female_x': int((CompetitionsAthlete.objects.filter(competition=lastcompetition,
# athlete__person__gender=Person.FEMALE).count() * 100) / CompetitionsAthlete.objects.filter(
# competition=maxcom, athlete__person__gender=Person.FEMALE).count()),
# 'competition_athlete_count': CompetitionsAthlete.objects.filter(
# competition=lastcompetition).count(),
'max': max,
# 'max_x': int(
# (CompetitionsAthlete.objects.filter(competition=lastcompetition).count() * 100) / max),
'lastcompetition': lastcompetition,
'data': datacount,
'total_club': total_club,
'total_athlete': total_athlete,
'total_coachs': total_coachs,
'last_athletes': last_athlete,
'total_athlete_gender_man': total_athlete_gender_man,
'total_athlete_gender_woman': total_athlete_gender_woman,
'total_athlate_last_month': total_athlate_last_month,
'total_judge': total_judge,
'total_club_user': total_club_user,
})
