+import functools
+from flask import (
+ Blueprint, flash, g, redirect, render_template, request, session, url_for, abort
+)
+from werkzeug.security import check_password_hash, generate_password_hash
+
+
+from webapp.db import get_db
+
+bp = Blueprint('auth', __name__, url_prefix='/auth')
+
+@bp.route('/login', methods=('GET', 'POST'))
+def login():
+ if request.method == 'POST':
+ username = request.form['username']
+ password = request.form['password']
+ db = get_db()
+ error = None
+ user = db.execute(
+ 'SELECT u.*, p.name FROM user u join permissions p on u.perm = p.id WHERE u.username = ?', (username,)
+ ).fetchone()
+
+ if user is None:
+ error = 'Incorrect username.'
+ elif not check_password_hash(user['password'], password):
+ error = 'Incorrect password.'
+
+ if error is None:
+ session.clear()
+ session['user_id'] = user['id']
+ session['user_perm'] = user['name']
+ return redirect(url_for('index'))
+
+ flash(error)
+ """db.execute(
+ "insert into user (username,password,perm) values (?,?,?)",
+ ('mir', generate_password_hash('Dupago'), 9),)
+ db.commit()"""
+
+ return render_template('auth/login.html')
+
+@bp.before_app_request
+def load_logged_in_user():
+ user_id = session.get('user_id')
+
+ if user_id is None:
+ g.user = None
+ else:
+ g.user = get_db().execute(
+ 'SELECT u.*, p.name FROM user u join permissions p on u.perm = p.id WHERE u.id = ?', (user_id,)
+ ).fetchone()
+
+@bp.route('/logout')
+def logout():
+ session.clear()
+ return redirect(url_for('index'))
+
+def login_required(view):
+ @functools.wraps(view)
+ def wrapped_view(**kwargs):
+ if g.user is None:
+ return redirect(url_for('auth.login'))
+
+ return view(**kwargs)
+
+ return wrapped_view
+
+@bp.route('/register', methods=('GET', 'POST'))
+@login_required
+def register():
+ if request.method == 'POST':
+ if session.get('user_perm') != 'ADMIN':
+ abort(403)
+ username = request.form['username']
+ password = request.form['password']
+ confirm = request.form['confirm']
+ perm = request.form['perm']
+ db = get_db()
+ error = None
+
+ if not username:
+ error = 'Username is required.'
+ elif not password:
+ error = 'Password is required.'
+ elif password != confirm:
+ error = 'Confirmation of password failed.'
+
+ if error is None:
+ if not perm:
+ perm = 'USER'
+ else:
+ perm = perm.upper()
+ try:
+ row = get_db().execute('SELECT id FROM permissions where name = ?', (perm,)).fetchone()
+ db.execute(
+ "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)",
+ (username, generate_password_hash(password), row[0]),
+ )
+ db.commit()
+ except db.IntegrityError:
+ error = f"User {username} is already registered."
+ except TypeError:
+ error = f"Permission '{perm}' is invalid."
+ else:
+ return redirect(url_for("dashboard.index"))
+
+ flash(error)
+
+ perms = get_db().execute('SELECT name FROM permissions').fetchall()
+
+ return render_template('auth/register.html', perms=[row[0] for row in perms])
+
+@bp.route('/changepwd/<id>', methods=('GET', 'POST'))
+@login_required
+def changepwd(id):
+ if request.method == 'POST':
+ oldpwd = request.form['oldpwd']
+ password = request.form['password']
+ confirm = request.form['confirm']
+ db = get_db()
+ error = None
+ id = int(id)
+ print(f"id: {id} oldpwd: {oldpwd} password: {password} confirm: {confirm} new: {generate_password_hash(password)} perm: {session.get('user_perm')}")
+ user = db.execute(
+ "select * from user where id = ?",
+ (id, )
+ ).fetchone()
+ if session.get('user_perm') == 'ADMIN':
+ if not password:
+ error = 'Password is required.'
+ elif password != confirm:
+ error = 'Confirmation of password failed.'
+ else:
+ if not oldpwd:
+ error = 'Old Password is required.'
+ elif not password:
+ error = 'Password is required.'
+ elif password != confirm:
+ error = 'Confirmation of password failed.'
+ elif not check_password_hash(user['password'], oldpwd):
+ error = "Incorrect old Password."
+
+ if error is None:
+ try:
+ db.execute(
+ "UPDATE user SET password = ? WHERE id = ?",
+ (generate_password_hash(password), id),
+ )
+ db.commit()
+ except db.IntegrityError:
+ error = "User does not exist."
+ except TypeError:
+ error = "Permission is invalid."
+ else:
+ return redirect(url_for("dashboard.index"))
+
+ flash(error)
+
+ return render_template('auth/changepwd.html')
+
+@bp.route('/update', methods=('GET', 'POST'))
+@login_required
+def update():
+ if request.method == 'POST':
+ if session.get('user_perm') != 'ADMIN':
+ abort(403)
+ username = request.form['username']
+ password = request.form['password']
+ perm = request.form['perm']
+ db = get_db()
+ error = None
+
+ if not username:
+ error = 'Username is required.'
+ elif not password:
+ error = 'Password is required.'
+
+ if error is None:
+ if not perm:
+ perm = 'USER'
+ else:
+ perm = perm.upper()
+ try:
+ row = get_db().execute('SELECT id FROM permissions where name = ?', (perm,)).fetchone()
+ db.execute(
+ "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)",
+ (username, generate_password_hash(password), row[0]),
+ )
+ db.commit()
+ except db.IntegrityError:
+ error = f"User {username} is already registered."
+ except TypeError:
+ error = f"Permission '{perm}' is invalid."
+ else:
+ return redirect(url_for("dashboard.index"))
+
+ flash(error)
+
+ perm = get_db().execute("""SELECT * FROM permissions""").fetchall()
+
+ user = get_db().execute("""
+ SELECT u.id, u.username, p.name FROM
+ user u join permissions p on u.perm = p.id
+ """).fetchall()
+
+ return render_template('auth/update.html', perms=perm, users=user)
+
+@bp.route('/userupdate/<id>', methods=('POST',))
+@login_required
+def userupdate(id):
+ if session.get('user_perm') != 'ADMIN':
+ abort(403)
+
+ content = request.json
+ id = int(id)
+ perm_id = content['perm_id']
+ print("Updating {0} perm = {1}".format(id, perm_id))
+ db = get_db()
+ try:
+ db.execute(
+ "UPDATE user set perm = ? where id = ?",
+ (perm_id, id),
+ )
+ db.commit()
+ except db.IntegrityError:
+ error = f"User {id} does not exist."
+ except TypeError:
+ error = f"Permission '{perm_id}' is invalid."
+ else:
+ return render_template('dashboard/index.html')
+
+# logger.error(error)
+
+@bp.route('/userdelete/<id>', methods=('POST',))
+@login_required
+def userdelete(id):
+ if session.get('user_perm') != 'ADMIN':
+ abort(403)
+
+ print("Deleting {0}".format(id))
+ id = int(id)
+ db = get_db()
+ try:
+ db.execute(
+ "DELETE FROM user where id = ?",
+ (id, ),
+ )
+ db.commit()
+ except db.IntegrityError:
+ error = f"User {id} does not exist."
+ else:
+ return render_template('dashboard/index.html')
+
+# logger.error(error)