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 adminhome(request):
if request.method == 'POST':
sem = request.POST.get('sems')
qry = "select * from student_data where sem='" + sem + "'"
data4 = dbconnection.selectalldata(qry)
return render(request, "administrator/index.html", {'data': data4})
return render(request, "administrator/index.html", {})
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 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 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 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 managecourse(request):
if request.method=='POST':
dep=request.POST.get('d')
sem=request.POST.get('sem')
sc=request.POST.get('sc')
sn=request.POST.get('sn')
sql="insert into subject_data values ('','"+dep+"','"+sem+"','"+sc+"','"+sn+"','0')"
if dbconnection.insertdata(sql):
x="Insert Successfully"
print(x)
return render(request,"administrator/addsubject.html",{"x":x})
sql="select * from subject_data order by sem asc"
data=dbconnection.selectalldata(sql)
if data:
jj=0
return render(request,"administrator/addsubject.html",{"data":data,"inc":jj})
return render(request,"administrator/addsubject.html",{})
def managestaff(request):
qry1="select * from staff_data"
data1=dbconnection.selectalldata(qry1)
if request.method=='POST':
sn=request.POST.get('sn')
con=request.POST.get('con')
addr=request.POST.get('addr')
myfile=request.FILES['up']
fs=FileSystemStorage()
filename=fs.save("C:\\Users\\Administrator\\Desktop\\python\\python\\labq\\labreport\\static\\userpic\\"+myfile.name,myfile)
u=request.POST.get('u')
p=request.POST.get('p')
qry="insert into staff_data values('','"+sn+"','"+con+"','"+addr+"','"+myfile.name+"','"+u+"','1')"
dbconnection.insertdata(qry)
qry="insert into user_log values('','"+u+"','"+p+"','staff','1')"
dbconnection.insertdata(qry)
return HttpResponseRedirect("http://127.0.0.1:8000/managestaff")
return render(request,"administrator/addstaff.html",{'stf':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 managestudent(request):
qry1 = "select * from student_data"
data3 = dbconnection.selectalldata(qry1)
if request.method == 'POST':
sem = request.POST.get('sem')
sn = request.POST.get('sn')
rn = request.POST.get('rn')
p = request.POST.get('p')
con = request.POST.get('con')
addr = request.POST.get('addr')
myfile = request.FILES['up']
fs = FileSystemStorage()
filename = fs.save(
"C:\\Users\\sudhe\\Desktop\\python\\labq-cut1\\labq-cut1\\labreport\\static\\studpic\\"
+ myfile.name, myfile)
qry = "insert into student_data values('','" + sem + "','" + sn + "','" + rn + "','" + con + "','" + addr + "','" + myfile.name + "','1')"
dbconnection.insertdata(qry)
qry = "insert into user_log values('','" + rn + "','" + p + "','stud','1')"
dbconnection.insertdata(qry)
return HttpResponseRedirect("http://127.0.0.1:8000/managestudent")
return render(request, "administrator/addstudent.html", {'data': data3})
