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})