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