def login_teacher():
form = forms.LoginForm()
error = None
if request.method == 'POST':
flash("login form")
print(str(request.data))
username = request.form['username']
password = request.form['password']
user_type = request.form['user_type']
db = get_db()
if username is None:
error = 'username is required '
elif password is None:
error = 'password is required'
elif user_type is None:
error = 'user type is required'
elif user_type != 'te':
error = 'wrong user type '
print(error, 'huh')
flash(error)
return render_template('login.html',
title='login teacher',
form=form,
error=error)
else:
user = db.execute('SELECT * FROM teacher WHERE username = ?',
(username, )).fetchone()
if user is None:
error = 'incorrect username'
elif not check_password_hash(user['password'], password):
error = 'Incorrect password'
print(error, ' huh')
if error is None:
print("error is None")
session.clear()
session['username'] = str(user['username'])
session['address'] = str(user['asddress'])
session['Allocated Branch'] = str(user['Branch'])
session['qualification'] = str(user['qualification'])
session['name'] = str(user['names'])
session['email'] = str(user['email'])
session['mobile'] = str(user['mobile'])
# session['class'] = str(user['class'])
# session['branch'] = str(user['branch'])
# session['divison'] = user[divison]
# session['contact'] = str(user['mobile'])
error = ''
return redirect(url_for('index.index_teacher'))
return None
flash(error)
return render_template('login.html',
title='login teacher',
form=form,
error=error)
def login_committee():
form = forms.LoginForm()
error = None
if request.method == 'POST':
flash("login form")
print(str(request.data))
username = request.form['username']
password = request.form['password']
user_type = request.form['user_type']
db = get_db()
if username is None:
error = 'username is required '
elif password is None:
error = 'password is required'
elif user_type is None:
error = 'user type is required'
elif user_type != 'co':
error = 'user type is wrong'
flash(error)
return render_template('login.html',
title='login commitee',
form=form,
error=error)
else:
user = db.execute('SELECT * FROM comitteehead WHERE username = ?',
(username, )).fetchone()
print(username)
if user is None:
error = 'incorrect username'
elif not check_password_hash(user['password'], password):
error = 'Incorrect password'
print(error)
if error is None:
print("error is None")
session.clear()
# session['user_id'] = user['id']
session['name'] = str(user['names'])
session['class'] = str(user['class'])
session['branch'] = str(user['branch'])
session['email'] = str(user['email'])
session['post'] = str(user['position'])
session['comittee name'] = str(user['comittee_name'])
session['mobile'] = str(user['mobile'])
session['address'] = str(user['asddress'])
session['username'] = str(user['username'])
return redirect(url_for('index.index_comitee'))
return None
print("flashing now")
flash(error)
return render_template('login.html',
title='login commitee',
form=form,
error=error)
def register_comitteehead():
form = forms.RegisterFormco()
error = None
if request.method == 'POST':
print(str(request.data))
username = request.form['username']
print(username)
password = request.form['password']
names = request.form['name']
class_co = request.form['class_co']
branch = request.form['branch']
email = request.form['email']
position = request.form['position']
comittee_name = request.form['committee']
mobile = request.form['mob']
add = request.form['add']
db = get_db()
error = None
if not username:
error = 'username is required.'
elif not password:
error = 'password is required'
elif db.execute('SELECT id FROM comitteehead WHERE username = ?',
(username, )).fetchone() is not None:
error = f'user {username} is already registered'
print(error)
flash(error)
# return redirect(url_for('auth.login_committee'))
return render_template("register_committee.html",
title="Register-teacher",
form=form,
error=error)
if error is None:
db.execute(
'''INSERT INTO comitteehead (names, class, branch, email, position,
comittee_name, mobile, asddress,username, password)
VALUES (?,?,?,?,?,?,?,?,?,?)''',
(names, class_co, branch, email, position, comittee_name,
mobile, add, username, generate_password_hash(password)))
db.commit()
print("commited")
return redirect(url_for('auth.login_committee'))
print("flashing now")
flash(error)
if error is not None:
print(error)
flash(error)
return render_template("register_committee.html",
title="Register-teacher",
form=form,
error=error)
def get_data():
form = LoginForm()
if request.method == 'POST':
admin_name = request.form['username']
admin_password = request.form['password']
db = get_db()
error = None
if not admin_name:
error = 'admin name is required'
if not admin_password:
error = 'admin password is required'
elif db.execute('SELECT id FROM admin WHERE adminname = ?',
(admin_name, )).fetchone() is not None:
print('legit admin')
# return redirect(url_for('Admin.showall'))
student_list = []
db = get_db()
for i in range(1, 100):
a = (db.execute(
''' SELECT username, password,
id, names, mobile, asddress, class,
branch, divison
FROM student
WHERE id = ?''', (i, )).fetchone())
if a is not None:
for member in a:
student_list.append(member)
print(student_list)
print(member, end=' ')
print()
# return redirect(url_for('home'))
return render_template("showall.html",
title="show all",
student_list=student_list)
else:
return render_template('adminlogin.html',
tiltle='admin',
form=form)
return render_template('adminlogin.html', title='admin', form=form)
def register_student():
form = forms.RegisterFormSt()
error = None
if request.method == 'POST':
print(str(request.data))
username = request.form['username']
print(username)
password = request.form['password']
name = request.form['name']
print(name)
divison = request.form['div']
class_st = request.form['class_st']
branch = request.form['branch']
mobile = request.form['mob']
email = request.form['email']
address = request.form['add']
# for i, v in request.form:
# print(i, '=', v)
print(request.form)
for i in request.form:
print(i)
db = get_db()
error = None
if not username:
error = 'username is required.'
elif not password:
error = 'password is required'
elif db.execute('SELECT id FROM student WHERE username = ?',
(username, )).fetchone() is not None:
error = f'user {username} is already registered'
print(error)
flash(error)
# return redirect(url_for('auth.login_student'))
if error is None:
db.execute(
'''INSERT INTO student (names, class, branch, divison,email,mobile,
asddress,username, password)
VALUES (?,?,?,?,?,?,?,?,?)''',
(name, class_st, branch, divison, email, mobile, address,
username, generate_password_hash(password)))
db.commit()
print("commited")
return redirect(url_for('auth.login_student', username=username))
print("flashing now")
flash(error)
if error is not None:
print(error)
return render_template("register_student.html",
title="Register-Student",
form=form,
error=error)
def register_teacher():
form = forms.RegisterFormte()
error = None
if request.method == 'POST':
print(str(request.data))
username = request.form['username']
print(username)
password = request.form['password']
name = request.form['name']
address = request.form['add']
branch = request.form['branch']
qualification = request.form['qualification']
mobile = request.form['mob']
email = request.form['email']
db = get_db()
error = None
if not username:
error = 'username is required.'
elif not password:
error = 'password is required'
elif db.execute('SELECT id FROM teacher WHERE username = ?',
(username, )).fetchone() is not None:
error = f'user {username} is already registered'
print(error)
flash(error)
return render_template("register_teacher.html",
title="Register-teacher",
form=form,
error=error)
# return redirect(url_for('auth.login_teacher'))
if error is None:
db.execute(
'''INSERT INTO teacher (username,password,asddress,names,branch,
qualification,mobile,email) VALUES (?,?,?,?,?,?,?,?)''',
(username, generate_password_hash(password), address, name,
branch, qualification, mobile, email))
db.commit()
print("commited")
return redirect(url_for('auth.login_teacher', username=username))
print("flashing now")
flash(error)
if error is not None:
print(error)
return render_template("register_teacher.html",
title="Register-teacher",
form=form,
error=error)
def index_teacher():
items = None
items = session
db = get_db()
cur = db.execute(
'SELECT names,comittee_name,mobile FROM comitteehead'
)
comitee = cur.fetchall()
timetable = get_list_timetable()
syllabus = get_list_syllabus()
events = get_list_events()
notice = get_list_notice()
assignment = get_list_assignment()
return render_template('index_t.html', items=items ,comitee=comitee,
timetable=timetable,
syllabus=syllabus,
events=events,
notice=notice,
assignment=assignment)
def login_student():
form = forms.LoginForm()
error = None
if request.method == 'POST':
flash("login form")
print(str(request.data))
username = request.form['username']
print(username)
password = request.form['password']
print(password)
user_type = request.form['user_type']
db = get_db()
if username is None:
error = 'username is required '
elif password is None:
error = 'password is required'
elif user_type is None:
error = 'user type is required'
elif user_type != 'st':
error = 'user type is wrong'
print(error)
flash(error)
return render_template('login.html',
title='login student',
form=form,
error=error)
else:
user = db.execute('SELECT * FROM student WHERE username = ?',
(username, )).fetchone()
print('executing')
db.execute('SELECT * FROM student WHERE username = ?',
(username, ))
if user is None:
error = 'incorrect username'
elif not check_password_hash(user['password'], password):
error = 'Incorrect password'
print(error)
# if error is None that means that there is no error and user contains
# dict which ha skey value pair so we need to create a session for it
# and store this values in it
if error is None:
print("error is None")
session.clear()
session['username'] = str(user['username'])
session['name'] = str(user['names'])
session['email'] = str(user['email'])
session['class'] = str(user['class'])
session['branch'] = str(user['branch'])
session['divison'] = str(user['divison'])
session['contact'] = str(user['mobile'])
session['address'] = str(user['asddress'])
print('BITCH', session['name'])
# return redirect
# (url_for('index.index_student'))
# return redirect(url_for('index.index_student'))
return redirect(url_for('index.index_student'))
return None
print("flashing now")
flash(error)
return render_template('login.html',
title='login student',
form=form,
error=error)