def viewquestion(request, subid):
uid = request.session['stud']
qry = "select * from student_data where rollnum='" + uid + "'"
data = dbconnection.selectdata(qry)
qry = "select * from qn_data where subj_id='" + subid + "'"
data1 = dbconnection.selectalldata(qry)
qry = "select * from subject_data where subj_id='" + subid + "'"
data2 = dbconnection.selectdata(qry)
return render(request, "student/viewquestion.html", {
'data': data,
'qns': data1,
'sub': data2
})
def answers(request, qid):
uid = request.session['st']
qry = "select * from staff_data where uid='" + uid + "'"
data = dbconnection.selectdata(qry)
qry = "select * from qn_data where id='" + qid + "'"
data1 = dbconnection.selectdata(qry)
qry = "select * from answr_data,student_data where student_data.rollnum=answr_data.regnum and answr_data.qn_id='" + qid + "'"
data2 = dbconnection.selectalldata(qry)
return render(request, "staff/answers.html", {
'data': data,
'qn': data1,
'stlist': data2
})
def staffhome(request):
uid = request.session['st']
qry = "select * from staff_data where uid='" + uid + "'"
data = dbconnection.selectdata(qry)
qry = "select * from subj_assign where stf_id='" + uid + "'"
data1 = dbconnection.selectalldata(qry)
return render(request, "staff/index.html", {'data': data, 'sdata': data1})
def editquestion(request, subid, qid):
uid = request.session['st']
qry = "select * from staff_data where uid='" + uid + "'"
data = dbconnection.selectdata(qry)
qry = "select * from qn_data where id='" + qid + "'"
data1 = dbconnection.selectdata(qry)
if request.method == 'POST':
qn = request.POST.get('qn')
qry = "update qn_data set qn='" + qn + "' where id='" + qid + "'"
dbconnection.updatedata(qry)
return HttpResponseRedirect("http://127.0.0.1:8000/addquestion/" +
subid)
return render(request, "staff/editquestion.html", {
'data': data,
'subjid': subid,
'qn': data1
})
def addanswer(request, subid, qid):
msg = ""
temp = ""
quest = request.POST.get("qn")
uid = request.session['stud']
qry = "select * from student_data where rollnum='" + uid + "'"
data = dbconnection.selectdata(qry)
qry = "select * from qn_data where id='" + qid + "'"
data1 = dbconnection.selectdata(qry)
qry = "select * from answr_data where qn_id='" + qid + "' and regnum='" + uid + "'"
data3 = dbconnection.selectalldata(qry)
qry = "select * from answr_data where qn_id='" + qid + "' and regnum='" + uid + "' order by id desc"
data4 = dbconnection.selectdata(qry)
if data4:
if str(data4[5]) == "0":
temp = 1
elif str(data4[5]) == "1":
temp = 1
else:
temp = 2
else:
temp = 2
if request.method == 'POST':
myfile = request.FILES['up']
ps = request.POST.get('ps')
fs = FileSystemStorage()
filename = fs.save(
"/home/silpa/Desktop/labq/labreport/static/o_answer/" +
myfile.name, myfile)
qry = "insert into answr_data values('','" + qid + "','" + uid + "','" + myfile.name + "','2018-09-22','0')"
dbconnection.insertdata(qry)
if ps == "1":
cstructure.structure(myfile.name, quest, qid)
return HttpResponseRedirect("http://127.0.0.1:8000/addanswer/" +
subid + "/" + qid)
#filename=fs.save("C:\\Users\\Administrator\\Desktop\\python\\python\\labq\\labreport\\static\\studpic\\"+myfile.name,myfile)
return render(request, "student/addanswer.html", {
'data': data,
'qns': data1,
'ans': data3,
'subid': subid,
'temp': temp
})
def studenthome(request):
uid = request.session['stud']
qry = "select * from student_data where rollnum='" + uid + "'"
data = dbconnection.selectdata(qry)
qry = "select * from subject_data where sem='" + data[1] + "'"
data1 = dbconnection.selectalldata(qry)
return render(request, "student/index.html", {
'data': data,
'sdata': data1
})
def assignsubject(request,sid):
qry="select * from staff_data where uid='"+str(sid)+"'"
data=dbconnection.selectdata(qry)
qry="select subj_id,subj_nme from subject_data"
data1=dbconnection.selectalldata(qry)
qry1="select * from subj_assign where stf_id='"+str(sid)+"'"
data3=dbconnection.selectalldata(qry1)
if request.method=='POST':
sn=request.POST.get('sn')
subj=request.POST.get('subj')
x=subj.split(',')
qry="insert into subj_assign values ('','"+x[0]+"','"+x[1]+"','"+sn+"')"
dbconnection.insertdata(qry)
return HttpResponseRedirect("http://127.0.0.1:8000/assignsubject/"+sn)
return render(request,"administrator/assign.html",{'data':data,'sdata':data1,'subj':data3})
def addquestion(request, subid):
uid = request.session['st']
qry = "select * from staff_data where uid='" + uid + "'"
data = dbconnection.selectdata(qry)
qry = "select * from qn_data where stf_id='" + uid + "' and subj_id='" + subid + "'"
data1 = dbconnection.selectalldata(qry)
if request.method == 'POST':
qn = request.POST.get('qn')
qry = "insert into qn_data values('','" + uid + "','" + subid + "','" + qn + "')"
dbconnection.insertdata(qry)
return HttpResponseRedirect("http://127.0.0.1:8000/addquestion/" +
subid)
return render(request, "staff/addquestion.html", {
'data': data,
'qns': data1,
'subjid': subid
})
def login(request):
if request.method=='POST':
a=request.POST.get('u')
b=request.POST.get('p')
sql="select * from user_log where uid='"+a+"' and pass='******'"
data=dbconnection.selectdata(sql)
if data:
if data[3]=="admin":
request.session['x']=a
return HttpResponseRedirect("http://127.0.0.1:8000/adminhome")
elif data[3]=="staff":
request.session['st']=a
return HttpResponseRedirect("http://127.0.0.1:8000/staffhome")
elif data[3]=="stud":
request.session['stud']=a
return HttpResponseRedirect("http://127.0.0.1:8000/studenthome")
else:
e="Invalid"
return render(request,'login.html',{'error':e})
return render(request,"login.html",{})
