def photos(id0):
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
ID = id0
photo0 = []
dates = []
photos1 = []
photos0 = Photo.query.filter_by(photo_user_id=ID).all()
photo_len = len(photos0)
for x in range(len(photos0)):
photo11 = photos0[x]
link = url_for('static', filename='profile_pics/' + str(photo11.photo))
photos1.append(link)
dates.append(str(photo11.created))
photos1.reverse()
dates.reverse()
return render_template('photos.html', photo=photos1, date=dates, photo_len=photo_len)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def delete_confirmed():
try:
wyb = request.form['wyb1']
admin = User.query.filter_by(role='1').first()
if admin == current_user:
flash('Nie można usunąć admina', 'danger')
return redirect(url_for('account'))
else:
if wyb == "TAK":
user = current_user
post = Post.query.filter_by(post_id=current_user.id).first()
if post:
db.session.delete(post)
info = Info.query.filter_by(info_id=current_user.id).first()
if info:
db.session.delete(info)
photo = Photo.query.filter_by(photo_id=current_user.id).first()
if photo:
db.session.delete(photo)
db.session.delete(user)
db.session.commit()
flash('Pomyślnie usunięto konto', 'info')
return redirect(url_for('login'))
else:
flash('Konto nie zostało usunięte', 'danger')
return redirect(url_for('home'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def ban_confirm():
user_id = request.form['ban1']
time = request.form['time']
if time == "1": time = "1"
if time == "7": time = "7"
if time == "30": time = "30"
if time == "Na zawsze": time = "Infinite"
if user_id == "1":
flash("Nie można zablokować admina", "danger")
return redirect(url_for('admin'))
ban_list = Ban_list.query.filter_by(user_id = user_id).first()
if not ban_list == None:
flash('Użytkownik ma już zablokowany dostęp', 'danger')
return redirect(url_for('admin'))
else:
try:
ban_user(user_id, time)
flash('Poprawnie zablokowano dostęp', 'info')
return redirect(url_for('admin'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def add2():#TODO fix gdy bezpośrednio przechodzisz to add2 błąd odświeżenie naprawia
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
result = request.form
start_date = request.form['start_date']
start_time1 = request.form['start_time']
end_time1 = request.form['end_time']
len1 = request.form['lenght']
if len(start_date) == 0:
flash('Nie podałeś daty', 'danger')
return redirect(url_for('add'))
if len(start_time1) == 0:
flash('Nie podałeś godziny', 'danger')
return redirect(url_for('add'))
if len(end_time1) == 0:
flash('Nie podałeś godziny zakończenia', 'danger')
return redirect(url_for('add'))
if len(len1) == 0:
flash('Nie podałeś długości wydarzenia', 'danger')
return redirect(url_for('add'))
multi_add_events(start_date, start_time1, end_time1, len1)
flash('Poprawnie dodano wydarzenia', 'info')
return redirect(url_for('admin'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def stats():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
last_7 = last_events(date=7)
last_30 = last_events(date=30)
last_90 = last_events(date=90)
user_count_nr = User.query.order_by(User.id).all()
user_count_nr = len(user_count_nr)
users = User.query.order_by(User.id).all()
avr_age = []
for user in users:
avr_age.append(user.age)
avr_nr = 0
avr_nr0 = len(avr_age)
for x in range(len(avr_age)):
avr_nr += int(avr_age.pop(0))
avr_nr = avr_nr/avr_nr0
return render_template('stats.html', last_7=last_7, last_30=last_30, last_90=last_90, user_count=user_count_nr, avr_age=avr_nr)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def delete():
try:
return render_template('del_warning.html')
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def lokalizacja():
try:
return render_template('lokalizacja.html')
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def logout():
try:
logout_user()
return redirect(url_for('home'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def bug_confirm():
try:
text = request.form['bug1']
bugs(current_user.username, current_user.id, text)
flash("Poprawnie zgłoszono błąd", "info")
return redirect(url_for('home'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def rezerwacja():
try:
day12 = False
summary, start1, list1 = events(day12)
list_len = list1
next1 = url_for('rezerwacja2')
return render_template('rezerwacja.html', start=start1, summary=summary, list_len=list_len, now1=date_now, next=next1)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def account():
try:
name = current_user.username
email = current_user.email
tel = current_user.tel_nr
age = current_user.age
return render_template('account.html', title='Account', name=name, email=email, tel=tel, age=age,)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def rezerwacja7():
try:
day12 = 6
summary, start1, list1 = events(day12)
list_len = list1
previous = url_for('rezerwacja6')
previous1 = True
next1 = False
return render_template('rezerwacja.html', start=start1, summary=summary, list_len=list_len, now1=date_6, next=next1, previous=previous, previous1=previous1)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def ban():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
user = User.query.order_by(User.username).all()
user_len = len(user)
return render_template('ban.html', user=user, user_len=user_len)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def rejestr2(): #TODO fix gdy bezpośrednio przechodzisz to rejestr2 błąd poprostu refresh naprawia
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
id1 = request.form['wyb1']
check_user = User.query.filter_by(id=id1).first()
if check_user == None:
flash('Użytkiwnik nie istnieje, podaj poprawne ID', 'danger')
return redirect(url_for('rejestr'))
if len(id1) == 0:
flash('Podaj ID', 'danger')
return redirect(url_for('rejestr'))
check = Post.query.filter_by(post_user_id=id1).first()
if check == None:
user1 = User.query.filter_by(id=id1).first()
post = Post(author=user1, created=now_date)
db.session.add(post)
db.session.commit()
form = MngForm()
form.id0 = id1
user1 = User.query.filter_by(id=id1).first()
info = Info.query.filter_by(info_id=id1).first()
post1 = []
posts = Post.query.filter_by(post_user_id=id1).all()
for post in posts:
post1.append(post)
post1.reverse()
post2 = post1.pop(0)
choroba = post2.choroba
objawy = post2.objawa
notes = post2.notes
visit_nr = post2.visit_nr + 1
return render_template('rejestr2.html',id0 = id1, user1=user1, form=form, choroba=choroba, objawy=objawy, visit_nr=visit_nr, notes=notes)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def confirm_admin():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
summary, start1, list2, desc1 = awaiting_events()
list_len_confirm_admin = list2
return render_template('confirm_admin.html',summary=summary, start1=start1, list_len_confirm_admin=list_len_confirm_admin, desc1=desc1)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def confirm_admin3():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
start_date_confirm = request.form['start_date']
update_event_admin(start_date_confirm)
flash('Zatwierdzono Wydarzenia', 'info')
return redirect(url_for('admin'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def login():
try:
if current_user.is_authenticated:
return redirect(url_for('home'))
form = LoginForm()
if form.validate_on_submit():
user = User.query.filter_by(email=form.email.data).first()
if user and bcrypt.check_password_hash(user.password, form.password.data):
login_user(user, remember=form.remember.data)
next_page = request.args.get('next')
return redirect(next_page) if next_page else redirect(url_for('home'))
else:
flash('Logowanie się nie powiodło. Sprawdź email lub hasło', 'danger')
return render_template('login.html', title='Login', form=form)
except Exception as e:
print("Error at ", e)
log(e, request.path, False)
return render_template('error_page.html', error = type(e))
def add():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
len12 = int(24) - int(now_hour)
now_date1 = []
for x in range(7):
target = datetime.date.today() + datetime.timedelta(days=int(x))
now_date1.append(target)
return render_template('add.html', title='add', list1=admin_events(), now1=now, now_date1=now_date1)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def confirm_admin2():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
start_date_confirm = request.form['test1']
start_time, desc = get_desc(start_date_confirm)
id0 = get_id(start_date_confirm)
desc0 = User.query.filter_by(id=id0).first()
return render_template('confirm_admin2.html',start_date_confirm=start_time, desc_awaiting=desc0, id0=id0)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def rejestr2_more():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
post1 = []
user1 = User.query.filter_by(id=id1).first()
posts = Post.query.filter_by(post_user_id=id1).all()
post_len = len(posts)
for post in posts:
post1.append(post)
id0 = id1
post1.reverse()
return render_template('rejestr2_more.html', post=post1, post_len=post_len)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def rejestr3():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
form = MngForm()
ID = request.form['id0']
author = User.query.filter_by(id=str(ID)).first()
post = Post.query.filter_by(post_id=str(ID)).first()
if post:
post_choroba = post.choroba
post_objawa = post.objawa
post_notes = post.notes
post_visit_nr = post.visit_nr
visit_nr1 = post_visit_nr + 1
else:
visit_nr1 = 0
if form.picture.data:
picture_file = save_picture(form.picture.data)
author.image_file = picture_file
photo1 = Photo(author=author, photo=author.image_file, created=now_date)
db.session.add(photo1)
post = Post(choroba=form.choroba.data, objawa=form.objawa.data, notes=form.notes.data, created=now_date, visit_nr=visit_nr1, author=author)
db.session.add(post)
db.session.commit()
flash('Poprawnie zaaktualizowano dane pacjęta', 'info')
return redirect(url_for('admin'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def register():
try:
if current_user.is_authenticated:
return redirect(url_for('home'))
form = RegistrationForm()
if form.validate_on_submit():
if str(form.tel_nr.data).isdigit()==True:
tel = User.query.filter_by(tel_nr=form.tel_nr.data).first()
if tel == None:
hashed_password = bcrypt.generate_password_hash(form.password.data).decode('utf-8')
user = User(username=form.username.data, email=form.email.data,tel_nr=form.tel_nr.data, age=form.age.data, password=hashed_password)
db.session.add(user)
db.session.commit()
user1 = User.query.filter_by(username=form.username.data).first()
info = Info(author=user1, created=now_date)
db.session.add(info)
db.session.commit()
flash('Towje konto zostało stworzone!', 'success')
return redirect(url_for('login'))
else:
flash("Numer telefonu jest już zajęty", "danger")
return redirect(url_for('register'))
else:
flash("Numer telefonu nie może zawierać znaków", "danger")
return redirect(url_for('register'))
return render_template('register.html', title='Rejestracja', form=form)
except Exception as e:
print("Error at ", e)
log(e, request.path, False)
return render_template('error_page.html', error = type(e))
def admin():
admin = User.query.filter_by(role='1').first()
if admin == current_user:
try:
summary_admin, start_admin, list_admin, desc_admin = admin_events() # zatwierdzone
list_len_admin = list_admin
summary_awaiting, start_awaiting, list_awaiting, desc_awaiting = awaiting_events() # oczekujące potwierdzenia
list_len_awaiting = list_awaiting
summary_user, start_user, list_user = admin_free_events() # wolne terminy
list_len_user = list_user
return render_template('admin.html', title='admin', start_admin=start_admin, summary_admin=summary_admin, list_len_admin=list_len_admin,
start_user=start_user, summary_user=summary_user, list_len_user=list_len_user,
start_awaiting=start_awaiting, summary_awaiting=summary_awaiting, list_len_awaiting=list_len_awaiting, now1=now_date)
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
else:
flash('Nie masz uprawnien', 'danger')
return redirect(url_for('home'))
def page_not_found(e):
log(e, request.path, current_user.id)
return render_template('error.html', error = e)
def bad_request(e):
log(e, request.path, current_user.id)
return render_template('error.html', error = e)
def confirm1():
try:
start_date_confirm = request.form.get("test1")
if len(start_date_confirm) == 0:
flash('Nie wybrano terminu', 'danger')
return redirect(url_for('rezerwacja'))
if isascii(start_date_confirm) == False:
flash('Podano nieprawidłowe znaki', 'danger')
return redirect(url_for('rezerwacja'))
date = get_id(start_date_confirm)
if not date == True:
print("Not False")
flash('Termin jest już zajęty', 'danger')
return redirect(url_for('rezerwacja'))
else:
print("Not True")
len_ban_list = len(Ban_list.query.order_by(Ban_list.ban_id).all()) + 1
for x in range(1, len_ban_list):
ban_list = Ban_list.query.filter_by(ban_id=x).first()
if current_user.id == ban_list.user_id:
if ban_list.time == "Infinite":
flash('Masz dożywotnio zablokowany dostęp do strony', 'danger')
return redirect(url_for('rezerwacja'))
else:
time = date_now + datetime.timedelta(days=int(ban_list.time))
flash('Masz zablokowany dostęp do strony do dnia: '+str(time), 'danger')
return redirect(url_for('rezerwacja'))
letter1 = []
for letter in start_date_confirm:
letter1.append(letter)
for x in range(len(letter1)-10):
letter1.pop(-1)
letter1 = "".join(letter1)
format = "%Y-%m-%d"
try:
letter1 = now.strptime(letter1, format)
except:
flash('Nie poprawny format', 'danger')
return redirect(url_for('rezerwacja'))
letter1_days = letter1.strftime("%d")
letter1_months = letter1.strftime("%m")
letter1_years = letter1.strftime("%Y")
if int(now_date_years) <= int(letter1_years):#TODO fix blisko nowego roku błąd ponieważ niepoprawna data
if int(now_date_months) <= int(letter1_months):
if int(now_date_days) <= int(letter1_days):
update_event(start_date_confirm)
else:
flash('Wybierz poprawną datę', 'danger')
return redirect(url_for('rezerwacja'))
else:
flash('Wybierz poprawną datę', 'danger')
return redirect(url_for('rezerwacja'))
else:
flash('Wybierz poprawną datę', 'danger')
return redirect(url_for('rezerwacja'))
flash('Poprawnie zarezerwowano termin. Proszę poczekać na potwierdzenie które otrzymasz drogą telefoniczną, może to portwać do kilku godzin.', 'info')
return redirect(url_for('rezerwacja'))
except Exception as e:
print("Error at ", e)
log(e, request.path, current_user.id)
return render_template('error_page.html', error = type(e))
def method_not_allowed(e):
log(e, request.path, current_user.id)
return render_template('error.html', error = e)
