def update_directory_member(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
member = DirectoryMember.objects.get(pk=pk)
if not member.user.groups.all():
user = judge.user
member.user.groups.add(Group.objects.get(name="Yonetim"))
member.save()
groups = Group.objects.all()
user = User.objects.get(pk=member.user.pk)
person = Person.objects.get(pk=member.person.pk)
user_form = UserForm(request.POST or None, instance=user)
person_form = PersonForm(request.POST or None, request.FILES or None, instance=person)
member_form = DirectoryForm(request.POST or None, instance=member)
communication = Communication.objects.get(pk=member.communication.pk)
if person.material:
metarial = Material.objects.get(pk=member.person.material.pk)
else:
metarial = Material()
metarial.save()
person.material = metarial
person.save()
communication_form = CommunicationForm(request.POST or None, instance=communication)
metarial_form = MaterialForm(request.POST or None, instance=metarial)
if request.method == 'POST':
# controller tc email
mail = request.POST.get('email')
if user.email != mail:
if User.objects.filter(email=mail) or ReferenceCoach.objects.exclude(status=ReferenceCoach.DENIED).filter(
email=mail) or ReferenceReferee.objects.exclude(status=ReferenceReferee.DENIED).filter(
email=mail) or PreRegistration.objects.exclude(status=PreRegistration.DENIED).filter(
email=mail):
messages.warning(request, 'Mail adresi başka bir kullanici tarafından kullanilmaktadir.')
return render(request, 'yonetim/kurul-uyesi-duzenle.html',
{'user_form': user_form, 'communication_form': communication_form, 'member': member,
'person_form': person_form, 'member_form': member_form, 'groups': groups,
'metarial_form': metarial_form,
})
tc = request.POST.get('tc')
if person.tc != tc:
if Person.objects.filter(tc=tc) or ReferenceCoach.objects.exclude(status=ReferenceCoach.DENIED).filter(
tc=tc) or ReferenceReferee.objects.exclude(status=ReferenceReferee.DENIED).filter(
tc=tc) or PreRegistration.objects.exclude(status=PreRegistration.DENIED).filter(tc=tc):
messages.warning(request, 'Tc kimlik numarasi sistemde kayıtlıdır. ')
return render(request, 'yonetim/kurul-uyesi-duzenle.html',
{'user_form': user_form, 'communication_form': communication_form, 'member': member,
'person_form': person_form, 'member_form': member_form, 'groups': groups,
'metarial_form': metarial_form,
})
name = request.POST.get('first_name')
surname = request.POST.get('last_name')
year = request.POST.get('birthDate')
year = year.split('/')
# client = Client('https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx?WSDL')
# if not (client.service.TCKimlikNoDogrula(tc, name, surname, year[2])):
# messages.warning(request, 'Tc kimlik numarasi ile isim soyisim dogum yılı bilgileri uyuşmamaktadır. ')
# return render(request, 'yonetim/kurul-uyesi-duzenle.html',
# {'user_form': user_form, 'communication_form': communication_form, 'member': member,
# 'person_form': person_form, 'member_form': member_form, 'groups': groups,
# 'metarial_form': metarial_form,
# })
if user_form.is_valid() and person_form.is_valid() and communication_form.is_valid() and member_form.is_valid():
user_form.save()
person_form.save()
communication_form.save()
member_form.save()
log = str(user.get_full_name()) + " Kurul uyesi guncellendi"
log = general_methods.logwrite(request, request.user, log)
messages.success(request, 'Kurul Üyesi Başarıyla Güncellendi')
# return redirect('sbs:kurul-uyeleri')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(request, 'yonetim/kurul-uyesi-duzenle.html',
{'user_form': user_form, 'communication_form': communication_form, 'member': member,
'person_form': person_form, 'member_form': member_form, 'groups': groups,
'metarial_form': metarial_form,
})
def add_directory_member(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
user_form = UserForm()
person_form = PersonForm()
communication_form = CommunicationForm()
member_form = DirectoryForm()
if request.method == 'POST':
user_form = UserForm(request.POST)
person_form = PersonForm(request.POST, request.FILES)
communication_form = CommunicationForm(request.POST)
member_form = DirectoryForm(request.POST)
# controller tc email
mail = request.POST.get('email')
if User.objects.filter(email=mail) or ReferenceCoach.objects.exclude(status=ReferenceCoach.DENIED).filter(
email=mail) or ReferenceReferee.objects.exclude(status=ReferenceReferee.DENIED).filter(
email=mail) or PreRegistration.objects.exclude(status=PreRegistration.DENIED).filter(
email=mail):
messages.warning(request, 'Mail adresi başka bir kullanici tarafından kullanilmaktadir.')
return render(request, 'yonetim/kurul-uyesi-ekle.html',
{'user_form': user_form, 'person_form': person_form, 'communication_form': communication_form,
'member_form': member_form})
tc = request.POST.get('tc')
if Person.objects.filter(tc=tc) or ReferenceCoach.objects.exclude(status=ReferenceCoach.DENIED).filter(
tc=tc) or ReferenceReferee.objects.exclude(status=ReferenceReferee.DENIED).filter(
tc=tc) or PreRegistration.objects.exclude(status=PreRegistration.DENIED).filter(tc=tc):
messages.warning(request, 'Tc kimlik numarasi sistemde kayıtlıdır. ')
return render(request, 'yonetim/kurul-uyesi-ekle.html',
{'user_form': user_form, 'person_form': person_form, 'communication_form': communication_form,
'member_form': member_form})
name = request.POST.get('first_name')
surname = request.POST.get('last_name')
year = request.POST.get('birthDate')
year = year.split('/')
# client = Client('https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx?WSDL')
# if not (client.service.TCKimlikNoDogrula(tc, name, surname, year[2])):
# messages.warning(request, 'Tc kimlik numarasi ile isim soyisim dogum yılı bilgileri uyuşmamaktadır. ')
# return render(request, 'yonetim/kurul-uyesi-ekle.html',
# {'user_form': user_form, 'person_form': person_form, 'communication_form': communication_form,
# 'member_form': member_form})
if user_form.is_valid() and person_form.is_valid() and communication_form.is_valid() and member_form.is_valid():
user = User()
user.username = user_form.cleaned_data['email']
user.first_name = unicode_tr(user_form.cleaned_data['first_name']).upper()
user.last_name = unicode_tr(user_form.cleaned_data['last_name']).upper()
user.email = user_form.cleaned_data['email']
group = Group.objects.get(name='Yonetim')
password = User.objects.make_random_password()
user.set_password(password)
user.save()
user.groups.add(group)
user.save()
person = person_form.save(commit=False)
communication = communication_form.save(commit=False)
person.save()
communication.save()
directoryMember = DirectoryMember(user=user, person=person, communication=communication)
directoryMember.role = member_form.cleaned_data['role']
directoryMember.commission = member_form.cleaned_data['commission']
directoryMember.save()
# subject, from_email, to = 'Halter - Yönetim/Federasyon Bilgi Sistemi Kullanıcı Giriş Bilgileri', '*****@*****.**', user.email
# text_content = 'Aşağıda ki bilgileri kullanarak sisteme giriş yapabilirsiniz.'
# html_content = '<p> <strong>Site adresi: </strong> <a href="http://sbs.twf.gov.tr:81/"></a>sbs.twf.gov.tr:81</p>'
# html_content = html_content + '<p><strong>Kullanıcı Adı: </strong>' + user.username + '</p>'
# html_content = html_content + '<p><strong>Şifre: </strong>' + password + '</p>'
# msg = EmailMultiAlternatives(subject, text_content, from_email, [to])
# msg.attach_alternative(html_content, "text/html")
# msg.send()
log = str(user.get_full_name()) + " Kurul Uyesi kaydedildi"
log = general_methods.logwrite(request, request.user, log)
messages.success(request, 'Kurul Üyesi Başarıyla Kayıt Edilmiştir.')
return redirect('sbs:kurul-uyesi-duzenle', directoryMember.pk)
else:
for x in user_form.errors.as_data():
messages.warning(request, user_form.errors[x][0])
return render(request, 'yonetim/kurul-uyesi-ekle.html',
{'user_form': user_form, 'person_form': person_form, 'communication_form': communication_form,
'member_form': member_form})
def newlogin(request, pk):
clup = SportsClub.objects.get(pk=pk)
# clüp
club_form = ClubForm(instance=clup)
communication_formclup = CommunicationForm(instance=clup.communication)
# klüp üyesi
user_form = UserForm()
person_form = PersonForm()
communication_form = CommunicationForm()
sportClubUser_form = SportClubUserForm()
if request.method == 'POST':
user_form = UserForm(request.POST)
person_form = PersonForm(request.POST, request.FILES)
communication_form = CommunicationForm(request.POST, request.FILES)
sportClubUser_form = SportClubUserForm(request.POST)
club_form = ClubForm(request.POST, request.FILES)
communication_formclup = CommunicationForm(request.POST, request.FILES)
if club_form.is_valid() and user_form.is_valid(
) and person_form.is_valid() and communication_form.is_valid(
) and sportClubUser_form.is_valid():
tc = request.POST.get('tc')
if Coach.objects.get(person__tc=tc):
# print("Bu degerde elimde tc si olan bir antrenör var ")
coach = Coach.objects.get(person__tc=tc)
user = coach.user
club_person = SportClubUser(
user=coach.user,
person=coach.person,
communication=coach.communication,
role=sportClubUser_form.cleaned_data['role'])
club_person.save()
group = Group.objects.get(name='KlupUye')
coach.user.groups.add(group)
coach.save()
communication = communication_formclup.save(commit=False)
communication.save()
clup.communication = communication
clup.coachs.add(coach)
clup.save()
messages.success(
request,
'Antrenör şifreniz ile sisteme giriş yapabilirsiniz')
log = general_methods.logwrite(
request, user,
"Antrenör klup üyesi olarak giris yaptı new login ")
else:
mail = request.POST.get('email')
if User.objects.filter(
email=mail) or ReferenceCoach.objects.filter(
email=mail) or ReferenceReferee.objects.filter(
email=mail) or PreRegistration.objects.filter(
email=mail):
messages.warning(
request,
'Mail adresi başka bir kullanici tarafından kullanilmaktadir.'
)
return render(
request, 'registration/newlogin.html', {
'user_form': user_form,
'person_form': person_form,
'communication_form': communication_form,
'sportClubUser_form': sportClubUser_form,
'club_form': club_form,
'communication_formclup': communication_formclup
})
tc = request.POST.get('tc')
if Person.objects.filter(
tc=tc) or ReferenceCoach.objects.filter(
tc=tc) or ReferenceReferee.objects.filter(
tc=tc) or PreRegistration.objects.filter(
tc=tc):
messages.warning(
request, 'Tc kimlik numarasi sistemde kayıtlıdır. ')
return render(
request, 'registration/newlogin.html', {
'user_form': user_form,
'person_form': person_form,
'communication_form': communication_form,
'sportClubUser_form': sportClubUser_form,
'club_form': club_form,
'communication_formclup': communication_formclup
})
name = request.POST.get('first_name')
surname = request.POST.get('last_name')
year = request.POST.get('birthDate')
year = year.split('/')
client = Client(
'https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx?WSDL')
if not (client.service.TCKimlikNoDogrula(
tc, name, surname, year[2])):
messages.warning(
request,
'Tc kimlik numarasi ile isim soyisim dogum yılı bilgileri uyuşmamaktadır. '
)
return render(
request, 'registration/newlogin.html', {
'user_form': user_form,
'person_form': person_form,
'communication_form': communication_form,
'sportClubUser_form': sportClubUser_form,
'club_form': club_form,
'communication_formclup': communication_formclup
})
clup.name = request.POST.get('name')
clup.shortName = request.POST.get('shortName')
clup.foundingDate = request.POST.get('foundingDate')
clup.logo = request.POST.get('logo')
clup.clubMail = request.POST.get('clubMail')
clup.petition = request.POST.get('petition')
clup.isFormal = request.POST.get('isFormal')
user = User()
user.username = user_form.cleaned_data['email']
user.first_name = user_form.cleaned_data['first_name']
user.last_name = user_form.cleaned_data['last_name']
user.email = user_form.cleaned_data['email']
group = Group.objects.get(name='KlupUye')
user.save()
user.groups.add(group)
user.save()
communication = communication_formclup.save(commit=False)
communication.save()
clup.communication = communication
clup.save()
person = person_form.save(commit=False)
communication = communication_form.save(commit=False)
person.save()
communication.save()
club_person = SportClubUser(
user=user,
person=person,
communication=communication,
role=sportClubUser_form.cleaned_data['role'],
)
club_person.save()
fdk = Forgot(user=user, status=False)
fdk.save()
html_content = ''
subject, from_email, to = 'TGF Bilgi Sistemi Kullanıcı Bilgileri', '*****@*****.**', user.email
html_content = '<h2>TÜRKİYE GÜREŞ FEDERASYONU BİLGİ SİSTEMİ</h2>'
html_content = html_content + '<p><strong>Kullanıcı Adınız :' + str(
fdk.user.username) + '</strong></p>'
# html_content = html_content + '<p> <strong>Site adresi:</strong> <a href="http://127.0.0.1:8000/newpassword?query=' + str(
# fdk.uuid) + '">http://127.0.0.1:8000/sbs/profil-guncelle/?query=' + str(fdk.uuid) + '</p></a>'
html_content = html_content + '<p> <strong>Site adresi:</strong> <a href="http://sbs.tgf.gov.tr/newpassword?query=' + str(
fdk.uuid
) + '">http://sbs.tgf.gov.tr/sbs/profil-guncelle/?query=' + str(
fdk.uuid) + '</p></a>'
msg = EmailMultiAlternatives(subject, '', from_email, [to])
msg.attach_alternative(html_content, "text/html")
msg.send()
messages.success(
request,
'Mail adresinize gelen link ile sistemde giriş yapabilirsiniz.'
)
clup.clubUser.add(club_person)
clup.dataAccessControl = False
clup.isRegister = True
clup.save()
log = general_methods.logwrite(request, user,
"Eski sifre ile giris yapildi")
return redirect("accounts:login")
return render(
request, 'registration/newlogin.html', {
'user_form': user_form,
'person_form': person_form,
'communication_form': communication_form,
'sportClubUser_form': sportClubUser_form,
'club_form': club_form,
'communication_formclup': communication_formclup
})
def updatejudge(request, tc, pk):
judge = Judge.objects.filter(person__tc=tc)[0]
if not (judge.user.groups.all()):
user = judge.user
judge.user.groups.add(Group.objects.get(name="Hakem"))
judge.save()
groups = Group.objects.all()
user = User.objects.get(pk=judge.user.pk)
person = Person.objects.get(pk=judge.person.pk)
user_form = UserForm(request.POST or None, instance=user)
person_form = PersonForm(request.POST or None,
request.FILES or None,
instance=person)
communication = Communication.objects.get(pk=judge.communication.pk)
if person.material:
metarial = Material.objects.get(pk=judge.person.material.pk)
else:
metarial = Material()
metarial.save()
person.material = metarial
person.save()
communication_form = CommunicationForm(request.POST or None,
instance=communication)
metarial_form = MaterialForm(request.POST or None, instance=metarial)
if Competition.objects.filter(judges=judge).distinct():
competitions = Competition.objects.filter(judges=judge).distinct()
else:
competitions = Competition.objects.none()
iban_form = IbanFormJudge(request.POST or None, instance=judge)
grade_form = judge.grades.all()
visa_form = judge.visa.all()
if request.method == "POST":
name = request.POST.get('first_name')
surname = request.POST.get('last_name')
year = request.POST.get('birthDate')
year = year.split('/')
mail = request.POST.get('email')
if mail != judge.user.email:
if User.objects.filter(
email=mail) or ReferenceCoach.objects.exclude(
status=ReferenceCoach.DENIED
).filter(email=mail) or ReferenceReferee.objects.exclude(
status=ReferenceReferee.DENIED).filter(
email=mail) or PreRegistration.objects.exclude(
status=PreRegistration.DENIED).filter(
email=mail):
messages.warning(
request,
'Mail adresi başka bir kullanici tarafından kullanilmaktadir.'
)
return render(
request, 'hakem/hakemDuzenle.html', {
'user_form': user_form,
'communication_form': communication_form,
'person_form': person_form,
'judge': judge,
'grade_form': grade_form,
'visa_form': visa_form,
'iban_form': iban_form,
'groups': groups,
'metarial_form': metarial_form
})
tc = request.POST.get('tc')
if tc != judge.person.tc:
if Person.objects.filter(tc=tc) or ReferenceCoach.objects.exclude(
status=ReferenceCoach.DENIED).filter(
tc=tc) or ReferenceReferee.objects.exclude(
status=ReferenceReferee.DENIED).filter(
tc=tc) or PreRegistration.objects.exclude(
status=PreRegistration.DENIED).filter(
tc=tc):
messages.warning(request,
'Tc kimlik numarasi sisteme kayıtlıdır. ')
return render(
request, 'hakem/hakemDuzenle.html', {
'user_form': user_form,
'communication_form': communication_form,
'person_form': person_form,
'judge': judge,
'grade_form': grade_form,
'visa_form': visa_form,
'iban_form': iban_form,
'groups': groups,
'metarial_form': metarial_form,
})
client = Client(
'https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx?WSDL')
if not (client.service.TCKimlikNoDogrula(tc, name, surname, year[2])):
messages.warning(
request,
'Tc kimlik numarasi ile isim soyisim dogum yılı bilgileri uyuşmamaktadır. '
)
return render(
request, 'registration/JudgeUpdate.html', {
'user_form': user_form,
'communication_form': communication_form,
'person_form': person_form,
'judge': judge,
'grade_form': grade_form,
'visa_form': visa_form,
'iban_form': iban_form,
'groups': groups,
'metarial_form': metarial_form,
})
if user_form.is_valid() and person_form.is_valid(
) and communication_form.is_valid() and iban_form.is_valid(
) and metarial_form.is_valid():
user.username = user_form.cleaned_data['email']
user.first_name = user_form.cleaned_data['first_name']
user.last_name = user_form.cleaned_data['last_name']
user.email = user_form.cleaned_data['email']
user.save()
log = str(user.get_full_name()) + " Hakemi güncelledi"
log = general_methods.logwrite(request, request.user, log)
iban_form.save()
person_form.save()
communication_form.save()
metarial_form.save()
fdk = Forgot(user=user, status=False)
fdk.save()
html_content = ''
subject, from_email, to = 'Güreş Bilgi Sistemi Kullanıcı Bilgileri', '*****@*****.**', user.email
html_content = '<h2>TÜRKİYE GÜREŞ FEDERASYONU BİLGİ SİSTEMİ</h2>'
html_content = html_content + '<p><strong>Kullanıcı Adınız :' + str(
fdk.user.username) + '</strong></p>'
# html_content = html_content + '<p> <strong>Site adresi:</strong> <a href="http://127.0.0.1:8000/newpassword?query=' + str(
# fdk.uuid) + '">http://127.0.0.1:8000/sbs/profil-guncelle/?query=' + str(fdk.uuid) + '</p></a>'
html_content = html_content + '<p> <strong>Site adresi:</strong> <a href="http://sbs.tgf.gov.tr/newpassword?query=' + str(
fdk.uuid
) + '">http://sbs.tgf.gov.tr/sbs/profil-guncelle/?query=' + str(
fdk.uuid) + '</p></a>'
msg = EmailMultiAlternatives(subject, '', from_email, [to])
msg.attach_alternative(html_content, "text/html")
msg.send()
user.is_active = True
user.save()
messages.success(request,
'Giris Bilgileriniz mail adresinize Gönderildi')
return redirect('accounts:login')
else:
messages.warning(request, 'Alanları Kontrol Ediniz')
return render(
request, 'registration/JudgeUpdate.html', {
'user_form': user_form,
'communication_form': communication_form,
'person_form': person_form,
'judge': judge,
'grade_form': grade_form,
'visa_form': visa_form,
'iban_form': iban_form,
'groups': groups,
'metarial_form': metarial_form,
'competitions': competitions
})
return render(request, 'registration/JudgeUpdate.html')
def add_employee(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
user_form = UserForm()
person_form = PersonForm()
communication=Communication()
country=Country.objects.get(name='Türkiye')
communication.country=country
communication_form = CommunicationForm(instance=communication)
employee_form = EmployeeForm()
employee_form.fields['workDefinition'].queryset = CategoryItem.objects.filter(forWhichClazz="EMPLOYEE_WORKDEFINITION")
if request.method == 'POST':
user_form = UserForm(request.POST)
person_form = PersonForm(request.POST , request.FILES or None)
communication_form = CommunicationForm(request.POST, request.FILES)
sportClubUser_form = EmployeeForm(request.POST)
if user_form.is_valid() and person_form.is_valid() and communication_form.is_valid() and sportClubUser_form.is_valid():
user = User()
user.username = user_form.cleaned_data['email']
user.first_name = user_form.cleaned_data['first_name']
user.last_name = user_form.cleaned_data['last_name']
user.email = user_form.cleaned_data['email']
group = Group.objects.get(name='Teknik')
password = User.objects.make_random_password()
user.set_password(password)
user.save()
user.groups.add(group)
user.save()
person = person_form.save(commit=False)
communication = communication_form.save(commit=False)
person.save()
communication.save()
personel = Employee(
user=user, person=person, communication=communication,
workDefinition=sportClubUser_form.cleaned_data['workDefinition'],
)
personel.save()
messages.success(request, 'Personel Başarıyla Kayıt Edilmiştir.')
return redirect('sbs:personeller-teknik')
else:
for x in user_form.errors.as_data():
messages.warning(request, user_form.errors[x][0])
return render(request, 'personel/personel-ekle.html',
{'user_form': user_form, 'person_form': person_form, 'communication_form': communication_form,
'employee_form': employee_form,
})
def edit_employee(request, pk):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
employee = Employee.objects.get(pk=pk)
user = User.objects.get(pk=employee.user.pk)
person = Person.objects.get(pk=employee.person.pk)
communication = Communication.objects.get(pk=employee.communication.pk)
user_form = UserForm(request.POST or None, instance=user)
person_form = PersonForm(request.POST or None, request.FILES or None, instance=person)
communication_form = CommunicationForm(request.POST or None, instance=communication)
employee_form = EmployeeForm(request.POST or None, instance=employee)
employee_form.fields['workDefinition'].queryset = CategoryItem.objects.filter(
forWhichClazz="EMPLOYEE_WORKDEFINITION")
projects=EPProject.objects.filter(employees__employee__user=user ).distinct()
projects|=EPProject.objects.filter(sorumlu__user=user).distinct()
cezainfaz = int(projects.filter(projeCinsi=EPProject.CIK).distinct().aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
adaletbinasi =int(projects.filter(projeCinsi=EPProject.AB).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
adlitip = int(projects.filter(projeCinsi=EPProject.AT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bolgeadliye = int(projects.filter(projeCinsi=EPProject.BAM).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bolgeidari = int(projects.filter(projeCinsi=EPProject.BIM).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
denetimserbeslik = int(projects.filter(projeCinsi=EPProject.DS).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
personelegitim = int(projects.filter(projeCinsi=EPProject.PEM).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bakanlikbinasi = int(projects.filter(projeCinsi=EPProject.BB).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
diger = int(projects.filter(projeCinsi=EPProject.DIGER).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
lojman = int(projects.filter(projeCinsi=EPProject.LOJMAN).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
cezainfaz_tam = int(projects.filter(projeCinsi=EPProject.CIK,projectStatus=EPProject.PT).distinct().aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
adaletbinasi_tam =int(projects.filter(projeCinsi=EPProject.AB,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
adlitip_tam = int(projects.filter(projeCinsi=EPProject.AT,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bolgeadliye_tam = int(projects.filter(projeCinsi=EPProject.BAM,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bolgeidari_tam = int(projects.filter(projeCinsi=EPProject.BIM,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
denetimserbeslik_tam = int(
projects.filter(projeCinsi=EPProject.DS, projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))[
'insaatAlani__sum'] or 0)
personelegitim_tam = int(projects.filter(projeCinsi=EPProject.PEM,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bakanlikbinasi_tam = int(projects.filter(projeCinsi=EPProject.BB,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
diger_tam = int(projects.filter(projeCinsi=EPProject.DIGER,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
lojman_tam = int(projects.filter(projeCinsi=EPProject.LOJMAN,projectStatus=EPProject.PT).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
cezainfaz_dev = int(projects.filter(projeCinsi=EPProject.CIK,projectStatus=EPProject.PDE).distinct().aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
adaletbinasi_dev =int(projects.filter(projeCinsi=EPProject.AB,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
adlitip_dev = int(projects.filter(projeCinsi=EPProject.AT,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bolgeadliye_dev = int(projects.filter(projeCinsi=EPProject.BAM,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bolgeidari_dev = int(projects.filter(projeCinsi=EPProject.BIM,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
denetimserbeslik_dev = int(
projects.filter(projeCinsi=EPProject.DS, projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))[
'insaatAlani__sum'] or 0)
personelegitim_dev = int(projects.filter(projeCinsi=EPProject.PEM,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
bakanlikbinasi_dev = int(projects.filter(projeCinsi=EPProject.BB,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
diger_dev = int(projects.filter(projeCinsi=EPProject.DIGER,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
lojman_dev = int(projects.filter(projeCinsi=EPProject.LOJMAN,projectStatus=EPProject.PDE).aggregate(Sum('insaatAlani'))['insaatAlani__sum'] or 0)
# bildirimden gelinmisse ve sistem deki kisinin ise true yap daha görülmesin
get = request.GET.get('notification')
if get:
notification = Notification.objects.get(pk=int(get))
if notification.users == request.user:
notification.is_show = True
notification.save()
if request.method == 'POST':
if user_form.is_valid() and communication_form.is_valid() and person_form.is_valid() and employee_form.is_valid():
user = user_form.save(commit=False)
user.username = user_form.cleaned_data['email']
user.first_name = user_form.cleaned_data['first_name']
user.last_name = user_form.cleaned_data['last_name']
user.email = user_form.cleaned_data['email']
user.save()
person_form.save()
communication_form.save()
employee_form.save()
log = str(user.get_full_name()) + " personel güncellendi"
log = general_methods.logwrite(request, log)
messages.success(request, 'Personel Başarıyla Güncellenmiştir.')
# return redirect('sbs:personeller')
else:
for x in user_form.errors.as_data():
messages.warning(request, user_form.errors[x][0])
return render(request, 'personel/personel-duzenle.html',
{'user_form': user_form, 'communication_form': communication_form,
'person_form': person_form, 'employee_form': employee_form,'projects':projects,'personel':user,
'cezainfaz': cezainfaz,
'adaletbinasi': adaletbinasi,
'adlitip': adlitip,
'bolgeadliye': bolgeadliye,
'bolgeidari': bolgeidari,
'denetimserbeslik': denetimserbeslik,
'personelegitim': personelegitim,
'bakanlikbinasi': bakanlikbinasi,
'diger': diger,
'lojman': lojman,
'cezainfaz_dev': cezainfaz_dev,
'adaletbinasi_dev': adaletbinasi_dev,
'adlitip_dev': adlitip_dev,
'bolgeadliye_dev': bolgeadliye_dev,
'bolgeidari_dev': bolgeidari_dev,
'denetimserbeslik_dev': denetimserbeslik_dev,
'personelegitim_dev': personelegitim_dev,
'bakanlikbinasi_dev': bakanlikbinasi_dev,
'diger_dev': diger_dev,
'lojman_dev': lojman_dev,
'cezainfaz_tam': cezainfaz_tam,
'adaletbinasi_tam': adaletbinasi_tam,
'adlitip_tam': adlitip_tam,
'bolgeadliye_tam': bolgeadliye_tam,
'bolgeidari_tam': bolgeidari_tam,
'denetimserbeslik_tam': denetimserbeslik_tam,
'personelegitim_tam': personelegitim_tam,
'bakanlikbinasi_tam': bakanlikbinasi_tam,
'diger_tam': diger_tam,
'lojman_tam': lojman_tam,
})
def return_add_club_person(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
user_form = UserForm()
person_form = PersonForm()
communication_form = CommunicationForm()
sportClubUser_form = SportClubUserForm()
if request.method == 'POST':
user_form = UserForm(request.POST)
person_form = PersonForm(request.POST, request.FILES)
communication_form = CommunicationForm(request.POST, request.FILES)
sportClubUser_form = SportClubUserForm(request.POST)
if user_form.is_valid() and person_form.is_valid(
) and communication_form.is_valid() and sportClubUser_form.is_valid():
user = User()
user.username = user_form.cleaned_data['email']
user.first_name = user_form.cleaned_data['first_name']
user.last_name = user_form.cleaned_data['last_name']
user.email = user_form.cleaned_data['email']
group = Group.objects.get(name='KulupUye')
password = User.objects.make_random_password()
user.set_password(password)
user.save()
user.groups.add(group)
user.save()
person = person_form.save(commit=False)
communication = communication_form.save(commit=False)
person.save()
communication.save()
club_person = SportClubUser(
user=user,
person=person,
communication=communication,
role=sportClubUser_form.cleaned_data['role'],
)
club_person.save()
subject, from_email, to = 'Halter - Kulüp Üye Bilgi Sistemi Kullanıcı Giriş Bilgileri', '*****@*****.**', user.email
text_content = 'Aşağıda ki bilgileri kullanarak sisteme giriş yapabilirsiniz.'
html_content = '<p> <strong>Site adresi: </strong> <a href="http://sbs.twf.gov.tr:81/"></a>sbs.twf.gov.tr:81</p>'
html_content = html_content + '<p><strong>Kullanıcı Adı: </strong>' + user.username + '</p>'
html_content = html_content + '<p><strong>Şifre: </strong>' + password + '</p>'
msg = EmailMultiAlternatives(subject, text_content, from_email,
[to])
msg.attach_alternative(html_content, "text/html")
msg.send()
messages.success(request,
'Kulüp Üyesi Başarıyla Kayıt Edilmiştir.')
return redirect('sbs:kulup-uyeleri')
else:
for x in user_form.errors.as_data():
messages.warning(request, user_form.errors[x][0])
return render(
request, 'kulup/kulup-uyesi-ekle.html', {
'user_form': user_form,
'person_form': person_form,
'communication_form': communication_form,
'sportClubUser_form': sportClubUser_form,
})
def sporcu_lisans_listesi(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 = UserForm(request.POST, request.FILES or None)
# ilk açılıs alani
# if user.groups.filter(name='KulupUye'):
# clubuser = SportClubUser.objects.get(user=user)
# clubs = SportsClub.objects.filter(clubUser=clubuser)
# clubsPk = []
# for club in clubs:
# clubsPk.append(club.pk)
# licenses = License.objects.filter(athlete__licenses__sportsClub__in=clubsPk).distinct()
# 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']):
# licenses = License.objects.all().distinct()
# sportclup.fields['sportsClub'].queryset = SportsClub.objects.all()
# ilk açılıs son
licenses = not License.objects.none()
if request.method == 'POST':
brans = request.POST.get('branch')
sportsclup = request.POST.get('sportsClub')
firstName = request.POST.get('first_name')
lastName = request.POST.get('last_name')
email = request.POST.get('email')
status = request.POST.get('status')
if firstName or lastName or email or sportsclup or brans or status:
query = Q()
if firstName:
query &= Q(athlete__user__first_name__icontains=firstName)
if lastName:
query &= Q(athlete__user__last_name__icontains=lastName)
if email:
query &= Q(athlete__user__email__icontains=email)
if sportsclup:
query &= Q(sportsClub__name__icontains=sportsclup)
if brans:
query &= Q(branch__icontains=brans)
if status:
query &= Q(status=status)
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)
licenses = License.objects.filter(
sportsClub_id__in=clubsPk).filter(query).distinct()
elif user.groups.filter(name__in=['Yonetim', 'Admin']):
licenses = License.objects.filter(query).distinct()
else:
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)
licenses = License.objects.filter(
sportsClub_id__in=clubsPk).distinct()
elif user.groups.filter(name__in=['Yonetim', 'Admin']):
licenses = License.objects.all().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/sporcu-lisans-listesi.html', {
'licenses': licenses,
'user_form': user_form,
'Sportclup': sportclup
})
def return_add_athlete(request):
perm = general_methods.control_access(request)
if not perm:
logout(request)
return redirect('accounts:login')
user_form = UserForm()
person_form = PersonForm()
communication_form = CommunicationForm()
# lisans ekleme baslangıç
# klüp üyesi sadece kendi klüplerini görebiliyor
user = request.user
license_form = LicenseForm(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)
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()
# lisan ekleme son alani bu alanlar sadece form bileselerinin sisteme gidebilmesi icin post ile gelen veride gene ayni şekilde karşılama ve kaydetme islemi yapilacak
if request.method == 'POST':
user_form = UserForm(request.POST)
person_form = PersonForm(request.POST, request.FILES)
communication_form = CommunicationForm(request.POST)
license_form = LicenseForm(request.POST, request.FILES or None)
if user_form.is_valid() and person_form.is_valid(
) and license_form.is_valid() and communication_form.is_valid():
user = User()
user.username = user_form.cleaned_data['email']
user.first_name = user_form.cleaned_data['first_name'].upper()
user.last_name = user_form.cleaned_data['last_name'].upper()
user.email = user_form.cleaned_data['email']
group = Group.objects.get(name='Sporcu')
password = User.objects.make_random_password()
user.set_password(password)
user.is_active = False
user.save()
user.groups.add(group)
user.save()
person = person_form.save(commit=False)
communication = communication_form.save(commit=False)
person.save()
communication.save()
athlete = Athlete(
user=user,
person=person,
communication=communication,
)
# lisans kaydedildi kakydetmeden id degeri alamayacagi icin önce kaydedip sonra ekleme islemi yaptık
license = license_form.save()
athlete.save()
athlete.licenses.add(license)
# subject, from_email, to = 'WUSHU - Sporcu Bilgi Sistemi Kullanıcı Giriş Bilgileri', '*****@*****.**', user.email
# text_content = 'Aşağıda ki bilgileri kullanarak sisteme giriş yapabilirsiniz.'
# html_content = '<p> <strong>Site adresi: </strong> <a href="https://www.twf.gov.tr/"></a>https://www.twf.gov.tr/</p>'
# html_content = html_content + '<p><strong>Kullanıcı Adı: </strong>' + user.username + '</p>'
# html_content = html_content + '<p><strong>Şifre: </strong>' + password + '</p>'
# msg = EmailMultiAlternatives(subject, text_content, from_email, [to])
# msg.attach_alternative(html_content, "text/html")
# msg.send()
messages.success(request, 'Sporcu Başarıyla Kayıt Edilmiştir.')
return redirect('sbs:sporcular')
else:
for x in user_form.errors.as_data():
messages.warning(request, user_form.errors[x][0])
return render(
request, 'sporcu/sporcu-ekle.html', {
'user_form': user_form,
'person_form': person_form,
'license_form': license_form,
'communication_form': communication_form
})
