def arsiv_dosyaUpdate(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
dosya = Adosya.objects.get(pk=pk)
form = AdosyaForm(request.POST or None, instance=dosya)
parametre = AdosyaParametre.objects.filter(dosya=dosya)
print(parametre)
if request.method == 'POST':
if form.is_valid():
test = form.save(commit=False)
test.save()
return redirect('sbs:klasor-guncelle', dosya.klasor.pk)
return render(request, 'arsiv/DosyaGuncelle.html', {
'form': form,
'dosya': dosya,
'parametre': parametre
})
def vize_delete(request, grade_pk, referee_pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
obj = Level.objects.get(pk=grade_pk)
referee = Judge.objects.get(pk=referee_pk)
referee.visa.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 updateClubRole(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
clubrole = ClubRole.objects.get(id=pk)
clubrole_form = ClubRoleForm(request.POST or None, instance=clubrole)
if request.method == 'POST':
if clubrole_form.is_valid():
clubrole_form.save()
messages.success(request, 'Başarıyla Güncellendi')
return redirect('sbs:kulup-uye-rolu')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'kulup/kulupRolDuzenle.html',
{'clubrole_form': clubrole_form})
def musabaka_kademe_aktar(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
turn = TurnKategorileri.objects.all()
for item in turn:
com = Competition.objects.get(pk=item.turnuvaid.turnuvaid)
category = Category.objects.get(pk=item.kategoriid.kategoriid)
com.categoryies.add(category)
com.save()
print(com.count())
return redirect('sbs:admin')
def return_activity(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
comquery = CompetitionSearchForm()
activity_type = ActivityType.objects.all()
activity = None
if request.method == 'POST':
name = request.POST.get('name')
startDate = request.POST.get('startDate')
compType = request.POST.get('compType')
finishDate = request.POST.get('finishDate')
a_type = request.POST.get('type')
if startDate:
startDate = datetime.strptime(startDate, '%d/%m/%Y').date()
if finishDate:
finishDate = datetime.strptime(finishDate, "%d/%m/%Y").date()
if name or startDate or compType or finishDate or a_type:
query = Q()
if name:
query &= Q(name__icontains=name)
if startDate:
query &= Q(startDate__gte=startDate)
if compType:
query &= Q(compType=compType)
if finishDate:
query &= Q(finishDate__lte=finishDate)
if a_type:
query &= Q(type__id=a_type)
activity = Activity.objects.filter(query).distinct()
else:
activity = Activity.objects.all()
return render(request, 'faliyet/faaliyetler.html', {
'activity': activity,
'query': comquery,
'activity_type': activity_type
})
def musabaka_hakem_aktar(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
turn = TurnHakemleri.objects.all()
for item in turn:
com = Competition.objects.get(pk=item.turnuvaid.turnuvaid)
judge = Judge.objects.get(oldpk=item.hakemid.sporcuid)
com.judges.add(judge)
com.save()
print(turn.count())
return redirect('sbs:admin')
def arsiv_klasorUpdate(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
klasor = Aklasor.objects.get(pk=pk)
klasor_form = AklasorForm(request.POST or None, instance=klasor)
dosya = Adosya.objects.filter(klasor=klasor)
if request.method == 'POST':
if klasor_form.is_valid():
test = klasor_form.save()
test.save()
return render(request, 'arsiv/KlasorGuncelle.html', {
'form': klasor_form,
'dosya': dosya,
'klasor': klasor
})
def update_member_role(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
memberRole = DirectoryMemberRole.objects.get(id=pk)
member_role_form = DirectoryMemberRoleForm(request.POST or None, instance=memberRole)
if request.method == 'POST':
if member_role_form.is_valid():
member_role_form.save()
messages.success(request, 'Başarıyla Güncellendi')
return redirect('sbs:kurul-uye-rolleri')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'yonetim/kurul-uye-rol-duzenle.html',
{'member_role_form': member_role_form})
def delete_commission(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
obj = DirectoryCommission.objects.get(pk=pk)
log = str(obj.name) + " kurul silindi"
log = general_methods.logwrite(request, request.user, log)
obj.delete()
return JsonResponse({'status': 'Success', 'messages': 'save successfully'})
except DirectoryCommission.DoesNotExist:
return JsonResponse({'status': 'Fail', 'msg': 'Object does not exist'})
else:
return JsonResponse({'status': 'Fail', 'msg': 'Not a valid request'})
def soru_update(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
questions = Question.objects.get(pk=pk)
form = QuestionsForm(request.POST or None, instance=questions)
if request.method == 'POST':
if form.is_valid():
form.save()
messages.success(request, 'Soru-Cevap Başari ile Güncellenmiştir.')
return redirect('sbs:soru-ekle')
else:
messages.warning(request, 'Alanlari kontrol ediniz')
return render(request, 'Soru/soru-guncelle.html', {'form': form})
def Exam_list_antroner_delete(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST' and request.is_ajax():
try:
obj = SportsClub.objects.get(pk=pk)
obj.delete()
return JsonResponse({
'status': 'Success',
'messages': 'save successfully'
})
except SportsClub.DoesNotExist:
return JsonResponse({
'status': 'Fail',
'msg': 'Object does not exist'
})
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 clubUpdate(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
club = SportsClub.objects.get(id=pk)
try:
com_id = club.communication.pk
communication = Communication.objects.get(id=com_id)
communication_form = CommunicationForm(request.POST or None,
instance=communication)
except:
communication_form = CommunicationForm(request.POST or None)
club_form = ClubForm(request.POST or None, instance=club)
clubPersons = club.clubUser.all()
clubCoachs = club.coachs.all()
if request.method == 'POST':
if club_form.is_valid():
club_form.save()
if not club.communication:
communication = communication_form.save(commit=False)
communication.save()
club.communication = communication
club.save()
else:
communication_form.save()
messages.success(request, 'Başarıyla Güncellendi')
return redirect('sbs:kulupler')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(
request, 'kulup/kulupDuzenle.html', {
'club_form': club_form,
'communication_form': communication_form,
'clubPersons': clubPersons,
'club': club,
'clubCoachs': clubCoachs
})
def TcnoControl(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
sayi = 0
athletes = Athlete.objects.all()
print(athletes.count())
for item in athletes:
if Sporcular.objects.get(sporcuid=item.oldpk):
if item.person.tc != Sporcular.objects.get(
sporcuid=item.oldpk).tcno:
print(item)
e = Sporcular.objects.get(sporcuid=item.oldpk)
person = Person(
tc=e.tcno,
birthplace=e.dogumyeri,
motherName=e.anneadi,
fatherName=e.babaadi,
birthDate=e.dogumtarihi,
bloodType=e.kangrubu,
# profileImage=e.resim,
gender=e.cinsiyet,
uyrukid=e.uyrukid,
nufus_ailesirano=e.nufus_ailesirano,
nufus_ciltno=e.nufus_ciltno,
nufus_sirano=e.nufus_sirano,
meslek=e.meslek,
kurum=e.kurum,
is_unvani=e.is_unvani,
# meterial=meterial.id,
# education=e.egitimid
)
person.save()
item.person = person
item.save()
sayi += 1
print(sayi)
return redirect('sbs:admin')
def return_add_club(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
club_form = ClubForm()
communication_form = CommunicationForm()
if request.method == 'POST':
club_form = ClubForm(request.POST, request.FILES)
communication_form = CommunicationForm(request.POST, request.FILES)
if club_form.is_valid():
clubsave = SportsClub(
name=club_form.cleaned_data['name'],
shortName=club_form.cleaned_data['shortName'],
foundingDate=club_form.cleaned_data['foundingDate'],
logo=club_form.cleaned_data['logo'],
clubMail=club_form.cleaned_data['clubMail'],
isFormal=club_form.cleaned_data['isFormal'],
)
communication = communication_form.save(commit=False)
communication.save()
clubsave.communication = communication
clubsave.save()
messages.success(request, 'Kulüp Başarıyla Kayıt Edilmiştir.')
return redirect('sbs:kulupler')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'kulup/kulup-ekle.html', {
'club_form': club_form,
'communication_form': communication_form
})
def arsiv_dosyalar(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
dosya = Adosya.objects.none()
dosya_form = AdosyaFormSearch()
klasor_form = AklasorSearchForm()
if request.method == 'POST':
sirano = request.POST.get('sirano')
location = request.POST.get('location')
birim = request.POST.get('birim')
klasor = request.POST.get('klasor')
active = general_methods.controlGroup(request)
if not (klasor or sirano or location or birim):
if active != 'Personel':
dosya = Adosya.objects.all()
else:
dosya=Adosya.objects.filter(klasor__birim__employe=Employe.objects.get(user=request.user))
else:
query = Q()
if klasor:
query &= Q(klasor__pk=klasor)
if sirano:
query &= Q(sirano=sirano)
if location:
query &= Q(klasor__location__pk=location)
if birim:
query &= Q(klasor__birim__pk=birim)
if active != 'Personel':
dosya = Adosya.objects.filter(query)
else:
dosya=Adosya.objects.filter(klasor__birim__employe=Employe.objects.get(user=request.user)).filter(query)
return render(request, 'arsiv/DosyaListesi.html', {'dosya': dosya,
'klasor_form': klasor_form,
'dosya_form': dosya_form
})
def arsiv_anasayfa(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
data = []
oran = []
units_count = Abirim.objects.count()
klasor_count = Aklasor.objects.count()
dosyalar_count = Adosya.objects.count()
evrak_count = Aevrak.objects.count()
# öz yinelemeli hale gelecek
beka = []
birimler = Abirim.objects.distinct()
for birim in birimler:
sayi = 0
klasorler = Aklasor.objects.filter(birim=birim)
for klasor in klasorler:
dosyalar = Adosya.objects.filter(klasor=klasor)
for dosya in dosyalar:
sayi += int(dosya.evrak.count())
beka.append((birim.name, sayi))
def takeSecond(elem):
return elem[1]
beka.sort(key=takeSecond, reverse=True)
for item in beka[:6]:
data.append({'sayi': item[1], 'birim': item[0]})
oran.append({'oran': round((item[1] / beka[0][1]) * 100)})
return render(request, "arsiv/arsivAnasayfa.html",
{'units_count': units_count,
'klasor_count': klasor_count,
'dosyalar_count': dosyalar_count,
'evrak_count': evrak_count,
'data': data,
'oran': oran,
}
)
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 return_referees(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
referees = Judge.objects.none()
searchClupForm = SearchClupForm()
user_form = RefereeSearchForm()
if request.method == 'POST':
searchClupForm = SearchClupForm(request.POST)
user_form = RefereeSearchForm(request.POST)
branch = request.POST.get('branch')
grade = request.POST.get('definition')
visa = request.POST.get('visa')
firstName = request.POST.get('first_name')
lastName = request.POST.get('last_name')
email = request.POST.get('email')
# print(firstName, lastName, email, branch, grade, visa)
if not (firstName or lastName or email or branch or grade or visa):
referees = Judge.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 branch:
query &= Q(grades__branch=branch, grades__status='Onaylandı')
if grade:
query &= Q(grades__definition__name=grade, grades__status='Onaylandı')
if visa == 'VISA':
print('visa ')
query &= Q(visa__startDate__year=timezone.now().year)
referees = Judge.objects.filter(query).distinct()
if visa == 'NONE':
referees = referees.exclude(visa__startDate__year=timezone.now().year).distinct()
return render(request, 'hakem/hakemler.html',
{'referees': referees, 'user_form': user_form, 'branch': searchClupForm})
def sporcu_lisans_duzenle(request, license_pk, athlete_pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
license = License.objects.get(pk=license_pk)
license_form = LicenseForm(request.POST or None,
request.FILES or None,
instance=license,
initial={'sportsClub': license.sportsClub})
user = request.user
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)
license_form.fields['sportsClub'].queryset = SportsClub.objects.filter(
id__in=clubsPk)
elif user.groups.filter(name__in=['Yonetim', 'Admin']):
license_form.fields['sportsClub'].queryset = SportsClub.objects.all()
if request.method == 'POST':
if license_form.is_valid():
license_form.save()
if license.status != 'Onaylandı':
license.status = License.WAITED
license.save()
messages.success(request, 'Lisans Başarıyla Güncellenmiştir.')
return redirect('sbs:update-athletes', pk=athlete_pk)
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'sporcu/sporcu-lisans-duzenle.html', {
'license_form': license_form,
'license': license
})
def arsiv_dosyaUpdate(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
dosya = Adosya.objects.get(pk=pk)
form = AdosyaForm(dosya.klasor.pk, request.POST or None, instance=dosya)
dosyaparametre = AdosyaParametre.objects.filter(dosya=dosya)
for item in dosyaparametre:
form.fields[item.parametre.title].initial = item.value
files = Aevrak.objects.filter(adosya=dosya)
evraklist = []
for item in files:
# print(item.file.name)
if item.file.name.split(".")[len(item.file.name.split(".")) -
1] == "pdf":
evraklist.append(item)
if request.method == 'POST':
if request.FILES.get('file'):
evrak = Aevrak(file=request.FILES.get('file'))
evrak.save()
dosya = Adosya.objects.get(pk=pk)
dosya.evrak.add(evrak)
dosya.save()
dosya.sirano = request.POST.get('sirano')
# Sonradan parametre eklendigine kontrol yazılmasi lazım
if dosyaparametre:
for item in dosyaparametre:
if request.POST.get(item.parametre.title):
item.value = request.POST.get(item.parametre.title)
item.save()
else:
form.update(dosya.pk)
return render(request, 'arsiv/DosyaGuncelle.html', {
'form': form,
'dosya': dosya,
'files': files,
'evraklist': evraklist
})
def musabaka_sporcu_tamamla(request, athletes):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST':
athletes1 = request.POST.getlist('selected_options')
if athletes1:
return redirect('sbs:musabaka-sporcu-tamamla', athletes=athletes1)
# for x in athletes1:
#
# athlete = Athlete.objects.get(pk=x)
# compAthlete = CompAthlete()
# compAthlete.athlete = athlete
# compAthlete.competition = competition
# compAthlete.save()
else:
messages.warning(request, 'Sporcu Seçiniz')
return render(request, 'musabaka/musabaka-sonuclar.html', {'athletes': athletes})
def update_commission(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
commission = DirectoryCommission.objects.get(id=pk)
commission_form = DirectoryCommissionForm(request.POST or None,
instance=commission)
if request.method == 'POST':
if commission_form.is_valid():
commission_form.save()
messages.success(request, 'Başarıyla Güncellendi')
return redirect('sbs:kurullar')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'yonetim/kurul-duzenle.html',
{'commission_form': commission_form})
def arsiv_birimParametre(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
abirim = Abirim.objects.get(pk=pk)
category_item_form = AbirimparametreForm(request.POST or None)
if request.method == 'POST':
if category_item_form.is_valid():
test = AbirimParametre(
title=category_item_form.cleaned_data['title'],
birim=abirim,
type=category_item_form.cleaned_data['type'])
test.save()
return redirect('sbs:arsiv-birimUpdate', pk=abirim.pk)
return render(request, 'arsiv/parametreEkle.html', {
'parametre_form': category_item_form,
})
def BolgeAdd(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
if request.method == 'POST':
project_form = GbolgeForm(request.POST)
if project_form.is_valid():
project_form.save()
return redirect('sbs:bolge-list')
else:
print('alanlari kontrol ediniz')
project_form = GbolgeForm()
project_form.fields['town'].queryset = Town.objects.none()
return render(request, 'Bolge/BolgeAdd.html',
{'project_form': project_form})
def musabaka_ekle(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
competition_form = CompetitionForm()
if request.method == 'POST':
competition_form = CompetitionForm(request.POST)
if competition_form.is_valid():
competition_form.save()
messages.success(request, 'Müsabaka Başarıyla Kaydedilmiştir.')
return redirect('sbs:musabakalar')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'musabaka/musabaka-ekle.html',
{'competition_form': competition_form})
def kademe_onay(request, grade_pk, coach_pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
grade = Level.objects.get(pk=grade_pk)
coach = Coach.objects.get(pk=coach_pk)
try:
for item in coach.grades.all():
if item.branch == grade.branch:
item.isActive = False
item.save()
grade.status = Level.APPROVED
grade.isActive = True
grade.save()
messages.success(request, 'Kademe Onaylanmıştır')
except:
messages.warning(request, 'Lütfen yeniden deneyiniz.')
return redirect('sbs:update-coach', pk=coach_pk)
def categoryItemUpdate(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
categoryItem = CategoryItem.objects.get(id=pk)
category_item_form = CategoryItemForm(request.POST or None,
instance=categoryItem)
if request.method == 'POST':
if request.POST.get('name') is not None:
categoryItem.name = request.POST.get('name')
categoryItem.save()
messages.warning(request, 'Başarıyla Güncellendi')
return redirect('sbs:kademe')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'antrenor/kademeDuzenle.html',
{'category_item_form': category_item_form})
def arsiv_birim_update(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
birim = Abirim.objects.get(pk=pk)
category_item_form = AbirimForm(request.POST or None, instance=birim)
if request.method == 'POST':
if category_item_form.is_valid():
category_item_form.save()
categoryitem = AbirimParametre.objects.filter(birim=birim)
klasor = Aklasor.objects.filter(birim=birim)
return render(
request, 'arsiv/birimGuncelle.html', {
'category_item_form': category_item_form,
'categoryitem': categoryitem,
'birim': birim,
'klasor': klasor
})
def SporcuControl(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
sayi = 0
athletes = Athlete.objects.all()
print(athletes.count())
for item in athletes:
if Sporcular.objects.filter(sporcuid=item.oldpk, sporcu=1):
sayi = sayi + 1
else:
item.delete()
print(item)
print(sayi)
return redirect('sbs:admin')
