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, })