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 or None) 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'], petition=club_form.cleaned_data['petition'], ) communication = communication_form.save(commit=False) communication.save() clubsave.communication = communication clubsave.save() log = str(club_form.cleaned_data['name']) + " Klup eklendi" log = general_methods.logwrite(request, request.user, log) messages.success(request, 'Kulüp Başarıyla Kayıt Edilmiştir.') return redirect('sbs:update-club',clubsave.pk) else: messages.warning(request, 'Alanları Kontrol Ediniz') return render(request, 'kulup/kulup-ekle.html', {'club_form': club_form, 'communication_form': communication_form})
def approve_preRegistration(request, pk): perm = general_methods.control_access(request) if not perm: logout(request) return redirect('accounts:login') basvuru = PreRegistration.objects.get(pk=pk) if basvuru.status != PreRegistration.APPROVED: mail = basvuru.email if not (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)): user = User() user.username = basvuru.email user.first_name = unicode_tr(basvuru.first_name).upper() user.last_name = unicode_tr(basvuru.last_name).upper() user.email = basvuru.email user.is_active = True user.is_staff = basvuru.is_staff group = Group.objects.get(name='KlupUye') password = User.objects.make_random_password() user.set_password(password) user.save() user.groups.add(group) user.save() # person kaydet person = Person() person.tc = basvuru.tc person.birthplace = basvuru.birthplace person.motherName = basvuru.motherName person.fatherName = basvuru.fatherName person.profileImage = basvuru.profileImage person.birthDate = basvuru.birthDate person.bloodType = basvuru.bloodType if basvuru.gender == 'Erkek': person.gender = Person.MALE else: person.gender = Person.FEMALE person.save() # Communication kaydet com = Communication() com.postalCode = basvuru.postalCode com.phoneNumber = basvuru.phoneNumber com.phoneNumber2 = basvuru.phoneNumber2 com.address = basvuru.address com.city = basvuru.city com.country = basvuru.country com.save() Sportclup = SportClubUser() Sportclup.user = user Sportclup.person = person Sportclup.communication = com Sportclup.role = basvuru.role Sportclup.save() comclup = Communication() comclup.postalCode = basvuru.clubpostalCode comclup.phoneNumber = basvuru.clubphoneNumber comclup.phoneNumber2 = basvuru.clubphoneNumber2 comclup.address = basvuru.clubaddress comclup.city = basvuru.clubcity comclup.country = basvuru.clubcountry comclup.save() # SportClup clup = SportsClub() clup.name = basvuru.name clup.shortName = basvuru.shortName clup.foundingDate = basvuru.foundingDate clup.clubMail = basvuru.clubMail clup.logo = basvuru.logo clup.isFormal = basvuru.isFormal clup.petition = basvuru.petition clup.communication = comclup clup.save() clup.clubUser.add(Sportclup) clup.save() # burada kadik if basvuru.isCoach: coach = Coach() coach.user = user coach.person = person coach.communication = com coach.iban = basvuru.iban coach.save() group = Group.objects.get(name='Antrenor') user.groups.add(group) user.save() grade = Level( startDate=basvuru.kademe_startDate, dekont=basvuru.kademe_belge, branch=EnumFields.HALTER.value) try: grade.definition = CategoryItem.objects.get(name=basvuru.kademe_definition) except: grade.definition = CategoryItem.objects.get(name='1.Kademe') grade.levelType = EnumFields.LEVELTYPE.GRADE grade.status = Level.APPROVED grade.isActive = True grade.save() coach.grades.add(grade) coach.save() clup.coachs.add(coach) clup.save() basvuru.status = PreRegistration.APPROVED basvuru.save() fdk = Forgot(user=user, status=False) fdk.save() html_content = '' subject, from_email, to = 'Bilgi Sistemi Kullanıcı Bilgileri', '*****@*****.**', user.email html_content = '<h2>TÜRKİYE BADMİNTON 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://sbs.badminton.gov.tr/newpassword?query=' + str( fdk.uuid) + '">http://sbs.badminton.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, 'Başari ile kaydedildi') log = str(clup) + " Klup basvurusu onaylandi" log = general_methods.logwrite(request, request.user, log) # try: # # user kaydet # print() # except: # messages.warning(request, 'Lütfen sistem yöneticisi ile görüşünüz ') # log = str(basvuru.name) + " Klup basvurusu hata oldu" # log = general_methods.logwrite(request, request.user, log) else: messages.warning(request, 'Mail adresi sistem de kayıtlıdır.') else: messages.warning(request, 'Bu basvuru sisteme kaydedilmistir.') prepegidtration = PreRegistration.objects.all() return render(request, 'kulup/kulupBasvuru.html', {'prepegidtration': prepegidtration})
def import_csv(): doc_root = settings.BASE_DIR + '/media/wushu_csv.csv' with open(doc_root) as csv_file: file_reader = csv.reader(csv_file, delimiter=';') next(file_reader, None) # skip the headers for row in file_reader: club = SportsClub() club.name = row[14] club.shortName = row[15] club.foundingDate = row[16] club.save() comClub = Communication() comClub.city = City.objects.get(name__icontains=row[18].strip()) comClub.phoneNumber = row[17] comClub.address = row[19] comClub.country = Country.objects.get(name__icontains="TÜRKİYE") comClub.save() club.comminication = comClub club.save() user = User() user.first_name = row[1] user.last_name = row[2] user.username = row[10] password = User.objects.make_random_password() user.set_password(password) user.save() user.groups.add(Group.objects.get(name='KulupUye')) user.save() person = Person() person.tc = row[0] person.motherName = row[3] person.fatherName = row[4] person.gender = row[5] person.birthDate = row[7] person.birthplace = row[6] person.bloodType = row[8] person.save() comClubUser = Communication() comClubUser.city = City.objects.get( name__icontains=row[12].strip()) comClubUser.phoneNumber = row[11] comClubUser.address = row[13] comClubUser.country = Country.objects.get(name="TÜRKİYE") comClubUser.save() sportClubUser = SportClubUser() sportClubUser.person = person sportClubUser.user = user sportClubUser.communication = comClubUser sportClubUser.sportClub = club sportClubUser.role = ClubRole.objects.get( name__icontains=row[9].strip()) sportClubUser.save() print(row)
def approve_preRegistration(request, pk): perm = general_methods.control_access(request) if not perm: logout(request) return redirect('accounts:login') basvuru = PreRegistration.objects.get(pk=pk) if basvuru.status != PreRegistration.APPROVED: if not (User.objects.filter(email=basvuru.email).exists()): # user kaydet try: user = User() user.username = basvuru.email user.first_name = basvuru.first_name user.last_name = basvuru.last_name user.email = basvuru.email user.is_active = basvuru.is_active user.is_staff = basvuru.is_staff group = Group.objects.get(name='KulupUye') password = User.objects.make_random_password() user.set_password(password) user.save() user.groups.add(group) user.save() except: messages.warning(request, ' Kullanici eklenmedi ') try: # person kaydet person = Person() person.tc = basvuru.tc person.height = basvuru.height person.weight = basvuru.weight person.birthplace = basvuru.birthplace person.motherName = basvuru.motherName person.fatherName = basvuru.fatherName person.profileImage = basvuru.profileImage person.birthDate = basvuru.birthDate person.bloodType = basvuru.bloodType person.gender = basvuru.gender person.save() except: messages.warning(request, ' Kullanici eklenmedi ') try: # Communication kaydet com = Communication() com.postalCode = basvuru.postalCode com.phoneNumber = basvuru.phoneNumber com.phoneNumber2 = basvuru.phoneNumber2 com.address = basvuru.address com.city = basvuru.city com.country = basvuru.country com.save() Sportclup = SportClubUser() Sportclup.user = user Sportclup.person = person Sportclup.communication = com Sportclup.role = basvuru.role Sportclup.save() comclup = Communication() comclup.postalCode = basvuru.clubpostalCode comclup.phoneNumber = basvuru.clubphoneNumber comclup.phoneNumber2 = basvuru.clubphoneNumber2 comclup.address = basvuru.clubaddress comclup.city = basvuru.clubcity comclup.country = basvuru.clubcountry comclup.save() # SportClup clup = SportsClub() clup.name = basvuru.name clup.shortName = basvuru.shortName clup.foundingDate = basvuru.foundingDate clup.clubMail = basvuru.clubMail clup.logo = basvuru.logo clup.isFormal = basvuru.isFormal clup.communication = comclup clup.save() clup.clubUser.add(Sportclup) clup.save() basvuru.status = PreRegistration.APPROVED basvuru.save() except: messages.success(request, 'Klüp ve iletisim kaydedilemedi') try: fdk = Forgot(user=user, status=False) fdk.save() html_content = '' subject, from_email, to = 'THF Bilgi Sistemi Kullanıcı Bilgileri', '*****@*****.**', mail html_content = '<h2>TÜRKİYE HALTER 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.halter.gov.tr/newpassword?query=' + str( fdk.uuid ) + '">http://sbs.halter.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, "Giriş bilgileriniz mail adresinize gönderildi. ") except: messages.success(request, "Mail Gönderilemedi") else: messages.warning(request, 'Mail adresi sistem de kayıtlıdır. ') else: messages.warning(request, 'Bu basvuru sisteme kaydedilmistir.') prepegidtration = PreRegistration.objects.all() return render(request, 'kulup/kulupBasvuru.html', {'prepegidtration': prepegidtration})