def askquestion(request):
con = settings.CONNECTION()
cr = con.cursor()
id = request.session['userdata'].get('id')
if request.method == 'POST':
qus = request.POST.get('qus')
query = "insert into question(qus,ask_by) value('{0}',{1})".format(
qus, id)
cr.execute(query)
con.commit()
# get all question ..
query = "select * from question where ask_by={0} order by qid DESC".format(
id)
cr.execute(query)
questions = cr.fetchall()
finaldata = []
for qus in questions:
lst = list(qus)
qid = lst[0]
qu = "select ans,ans_date,name from answer,user where qus={0} and answer.ans_by=user.uid".format(
qid)
cr.execute(qu)
a = cr.fetchall()
lst.append(a)
finaldata.append(lst)
print(finaldata)
con.close()
return render(request, "ask.html", {"questions": questions})
def signup(request):
name = request.POST.get('name')
mail = request.POST.get('mail')
pwd = request.POST.get('pwd')
query = "insert into signup(name,mail,password) value('{0}','{1}','{2}')".format(
name, mail, pwd)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
cnn.commit()
msg = "Sign Up Success!"
return render(request, "signup.html", {"msg": msg})
def verify(request):
if request.method == "GET":
return render(request, 'verify.html')
else:
otp = request.POST.get('otp')
mail = request.POST.get('email')
query = "update user set isVerify=1 where mail='{0}' and otp={1}".format(
mail, otp)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
cnn.commit()
return redirect('/college/login')
def resend(request):
name = request.POST.get('NAME')
email = request.POST.get('EMAIL')
otp = sendMail(name, email)
print(name, email, otp)
#query = "update user set name=NULL, email=NULL,otp=NULL where email='{1}'".format(email,otp)
query = "update user set otp={1} where mail='{0}'".format(email, otp)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
cnn.commit()
msg = "OTP Sent!"
return render(request, 'verify1.html', {"msg": msg})
def home(request):
name = request.session['userdata'].get('name')
branch = request.session['userdata'].get('branch')
query = "select name,mail,phone from user where branch={0} and type=2".format(branch)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
students = cr.fetchall()
return render(request,"facthome.html",{"name":name,"students":students})
def home1(request):
name = request.session['userdata'].get('name')
branch = request.session['userdata'].get('branch')
id = request.session['userdata'].get('id')
query = "select name,mail,phone from user where branch={0} and type=2 and uid!={1}".format(branch,id)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
names = cr.fetchall()
return render(request,"studhome1.html",{"name":name,"branch":branch,"names":names})
def verify1(request):
if request.method == "GET":
return render(request, 'verify1.html')
else:
otp = request.POST.get('otp')
mail = request.POST.get('email')
#password = request.POST.get('password')
query = "update user set isVerify=1 where mail='{0}' and otp={1}".format(
mail, otp)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
#record = cr.fetchone()
#type = record[5]
cnn.commit()
#msg = "Invalid OTP"
return redirect('/college/login1')
def register(request):
name = request.POST.get('username')
email = request.POST.get('email')
pwd = request.POST.get('pwd')
type = request.POST.get('type')
branch = request.POST.get('branch')
#mail = request.session['userdata'].get('email')
#if email!=mail:
otp = sendMail(name, email)
query = "insert into user(name,mail,password,type,branch,otp) value('{0}','{1}','{2}',{3},{4},{5})".format(
name, email, pwd, type, branch, otp)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
cnn.commit()
reg = "Registration Success!"
return render(request, "login1.html", {"reg": reg})
def saveContact(request):
name = request.POST.get("cname")
mail = request.POST.get("email")
phone = request.POST.get("phone")
sub = request.POST.get("subject")
msg = request.POST.get("message")
query = "insert into contact(name,email,phone,subject,message) value('{0}','{1}','{2}','{3}','{4}')".format(
name, mail, phone, sub, msg)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
cnn.commit()
#print(name,mail,phone,sub,msg)
context = "Contact Saved!"
return render(request, "contact1.html", {"messages": context})
def resetpw(request):
if request.method == "GET":
return render(request, 'resetpw.html')
else:
MAIL = request.POST.get('MAIL')
np = request.POST.get('np')
PWD = request.POST.get('PWD')
if np == PWD:
query = "update user set password='******' where mail='{0}'".format(
MAIL, np)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
cnn.commit()
return redirect('/college/login1')
else:
msg = "Password NOT matched!"
return render(request, 'resetpw.html', {"msg": msg})
def loginuser(request):
email = request.POST.get('email')
pwd = request.POST.get('pwd')
query = "select * from user where mail='{0}' and password='******'".format(
email, pwd)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
record = cr.fetchone()
#print("Record: ",record)
if record is None:
msg = "Login Failed!"
return redirect('/college/login1?error=1')
else:
id = record[0]
name = record[1]
email = record[2]
phone = record[3]
branch = record[6]
type = record[5]
isVerify = record[8] # 0
if isVerify == 0:
return redirect('/college/verify1')
else:
user = {
"id": id,
"name": name,
"email": email,
"phone": phone,
"branch": branch,
"type": type
}
request.session['userdata'] = user
if type == 1: # faculty
return redirect('/faculty/home1')
else: # student
return redirect('/student/home1')
def register(request):
name = request.POST.get('name')
email = request.POST.get('mail')
password = request.POST.get('password')
type = request.POST.get('type')
branch = request.POST.get('branch')
otp = sendMail(name, email)
query = "insert into user(name,mail,password,type,branch,otp) value('{0}','{1}','{2}',{3},{4},{5})".format(
name, email, password, type, branch, otp)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
cnn.commit()
cnn.close()
return HttpResponse("Register User Success !")
def stuanswer1(request):
branch = request.session['userdata'].get('branch')
sid = request.session['userdata'].get('id')
cnn = settings.CONNECTION()
cr = cnn.cursor()
if request.method=="POST":
answer = request.POST.get('answer')
qus = request.POST.get('qus')
query = "insert into stuanswer(ans,qus,ans_by) value('{0}','{1}',{2})".format(answer,qus,sid)
cr.execute(query)
cnn.commit()
# subquery - nested query
query = "select qid,qus,qus_date,name from stuquestion, user where ask_by in (select uid from user where branch={0} and type=2 and uid!={1}) and stuquestion.ask_by=user.uid".format(branch,sid)
cr.execute(query)
questions = cr.fetchall()
return render(request,'stuanswer1.html',{'questions':questions})
def loginuser(request):
email = request.POST.get('email')
pwd = request.POST.get('pwd')
from cryptography.fernet import Fernet
cipher_suite = Fernet(HASHKEY)
# query = "select * from user where mail='{0}' and password='******'".format(email,pwd)
query = "select * from user where mail='{0}'".format(email)
cnn = settings.CONNECTION()
cr = cnn.cursor()
cr.execute(query)
record = cr.fetchone()
if record is None:
msg = "Login Failed !"
return redirect('/college/login?error=1')
ciphered_text = record[4]
print(">>>>>", ciphered_text)
ciphered_text = bytes(ciphered_text, "utf-8")
try:
unciphered_text = (cipher_suite.decrypt(ciphered_text))
print("this is uncipherd txt>>>>>>", unciphered_text)
except Exception as e:
print(":Exception")
return redirect("/college/login?error=1")
if pwd != unciphered_text.decode("utf-8"):
print("pwd not matched")
msg = "Login Failed !"
return redirect('/college/login?error=1')
else:
print(">>>>>> ", record)
id = record[0]
name = record[1]
email = record[2]
phone = record[3]
branch = record[6]
type = record[5] # type
isVerify = record[8] # 0
if isVerify == 1:
return redirect('/college/verify')
else:
user = {
"id": id,
"name": name,
"email": email,
"phone": phone,
"branch": branch,
"type": type
}
request.session['userdata'] = user
if type == 1: # faculty
return redirect('/faculty/home')
else: # student
return redirect('/student/home')
