def admin():
username = session['username']
if check_grupa(username) == check_grupa('admin'):
return render_template('admin.html', grupa=check_grupa(username), info=username)
else:
session.pop('username', None)
session.clear()
return redirect(url_for('login')), flash('Nie jestes zalogowany!! Prosze sie wczesniej zalogować')
def search_db():
username = session['username']
if check_grupa(username) == check_grupa('admin'):
if request.method == 'POST':
pesel = request.form['person_id']
data = find_child(pesel)
return render_template('search_db.html', grupa=check_grupa(username), info=username, data=data[::])
return render_template('search_db.html', grupa=check_grupa(username), info=username)
else:
session.pop('username', None)
session.clear()
return redirect(url_for('login')), flash('Nie jestes zalogowany!! Prosze sie wczesniej zalogować')
def check_user():
if 'username' in session:
username = session['username']
data = check_username()
return render_template('check_users.html', grupa=check_grupa(username), info=username, data=data)
else:
return render_template('check_users.html',)
def upload_file():
username = session['username']
if check_grupa(username) == check_grupa('admin'):
if request.method == 'POST':
if 'file' not in request.files:
flash('No file part')
return redirect(request.url)
file = request.files['file']
if file.filename == '':
flash('No selected file')
return redirect(request.url)
if file and allowed_file(file.filename):
filename = secure_filename(file.filename)
file.save(os.path.join('static/storage', filename))
return redirect(url_for('index', filename=filename)), flash('Upload file successfull')
return render_template('upload.html', info=username, grupa=check_grupa(username))
def register():
username = session['username']
if check_grupa(username) == check_grupa('admin'):
if request.method == 'POST':
with sqlite3.connect("static/user.db") as db:
cursor = db.cursor()
cursor.execute(
'INSERT INTO users (grupa, username, password, email) VALUES (?, ?, ?, ?)',
(
request.form.get('grupa', type=str),
request.form.get('username', type=str),
hash_passwd(request.form.get('password', type=str)),
request.form.get('email', type=str))
)
db.commit()
return redirect(url_for('register'))
return render_template("register.html", the_title='BAZA PRZEDSZKOLAKA', info=username,
grupa=check_grupa(username))
def profil():
if 'username' in session:
username = session['username']
with sqlite3.connect("static/user.db") as db:
cursor = db.cursor()
cursor.execute('SELECT person_id, name, surname, birth, grupa FROM dzieci')
data = cursor.fetchall()
db.commit()
return render_template("profil.html", data=data, the_title='BAZA PRZEDSZKOLAKA', info=username,
grupa=check_grupa(username))
def login():
error = None
if request.method == 'POST':
username = request.form['username']
password = request.form['password']
completion = validate(username, password)
if completion is False:
error = 'Niepoprawny login lub hasło'
else:
session['username'] = request.form['username']
username = session['username']
if check_grupa(username) == 'admin':
info = "Witaj" + " " + check_grupa(username)+"ie"
flash(info)
if check_grupa(username) == 'nauczyciel':
info = "Witaj" + " " + check_grupa(username) + "u"
flash(info)
if check_grupa(username) == 'rodzic':
info = "Witaj" + " " + check_grupa(username) + "u"
flash(info)
return render_template('base.html', error=error, info=username, grupa=check_grupa(username))
return render_template('login.html', error=error)
def child():
if 'username' in session:
username = session['username']
if request.method == 'POST':
with sqlite3.connect("static/user.db") as db:
cursor = db.cursor()
cursor.execute(
'INSERT INTO dzieci (person_id, name, surname, birth, grupa) VALUES (?, ?, ?, ?, ?)',
(
request.form.get('person_id', type=str),
request.form.get('name', type=str),
request.form.get('surname', type=str),
request.form.get('birth', type=str),
request.form.get('grupa', type=str)
)
)
db.commit()
return redirect(url_for('child'))
return render_template("child.html", the_title='BAZA PRZEDSZKOLAKA', info=username, grupa=check_grupa(username))
def index():
if 'username' in session:
username = session['username']
return render_template('base.html', the_title="BAZA PRZEDSZKOLAKA", info=username, grupa=check_grupa(username))
else:
return render_template('base.html', the_title="BAZA PRZEDSZKOLAKA")