def processUploadAttendance(request,course_code):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
if request.method == 'POST':
form1 = read(request.POST, request.FILES)
total = request.POST['date1']
course = Course.objects.get(id= course_code)
if form1.is_valid():
newdoc = Document1(docfile = request.FILES['docfile'])
newdoc.save()
path = os.path.abspath(newdoc.docfile.url[1:])
mark = np.genfromtxt(path, dtype='str', delimiter=',',unpack='True',skip_header=1)
for i in range(250):
try:
# k = mark[1][i]
student = Student.objects.get(rollno=int(mark[1][i]))
studentInCourse = course.getStudents().filter(rollno=student.id)
if studentInCourse:
k = str(total).split('/')
l = k[2]+"-"+k[1]+'-'+k[0]
if mark[2][i][0] == 'P':
present = True
else:
present=False
save = AttendanceDaily.objects.create(rollno=student,coursecode=course,date=l,present=present)
save.save()
except:
continue
return index(request)
return HttpResponseRedirect(redirect)
def courseHome(request, course_code):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_courseHome.html')
current = AdminStaff.objects.filter(
username=request.session['username'])[0]
course = Course.objects.filter(pk=course_code)[0]
course_semester = course.semester_offered
if course_semester[0] == "M":
course_semester = "Monsoon"
else:
course_semester = "Spring"
faculty = course.getFaculty().name
course = Course.objects.filter(id=course_code)[0]
#query = "SELECT * FROM Students_record WHERE Students_record.coursecode_id = \'"+str(course.id)+"\' AND Students_record.semester_date = \'"+course.semester_offered[0]+str(course.year)+"\'"
#ListofStudents = Record.objects.raw(query)
ListofStudents = Record.objects.filter(coursecode=course.id)
context = RequestContext(
request, {
'current': current,
'course': course,
'faculty': faculty,
'course_semester': course_semester,
'ListofStudents': ListofStudents
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def processUploadMarks(request,course_code):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
total = request.POST['totalMarks']
examName = request.POST['examName']
course = Course.objects.get(id= course_code)
if form.is_valid():
newdoc = Document(docfile = request.FILES['docfile'])
newdoc.save()
path = os.path.abspath(newdoc.docfile.url[1:])
mark = np.genfromtxt(path, dtype='str', delimiter=',',unpack='True',skip_header=1)
# sdfs = mark.ndarray
for i in range(250):
try:
if mark[0][i] == "":
continue
koo = mark[1][i]
student = Student.objects.get(rollno=int(mark[1][i]))
studentInCourse = course.getStudents().filter(rollno=student.id)
if studentInCourse:
looo = mark[2][i]
# return sdfs
save = Marks.objects.create(rollno=student,category=examName,semester_date=course.semester_offered[0] + str(course.year),
coursecode=course,marks=int(mark[2][i]),total=int(total))
save.save()
except:
continue
return index(request)
return HttpResponseRedirect(redirect)
def viewStudentProfile(request, roll_no):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
template = loader.get_template('faculty/_viewStudent.html')
current = Faculty.objects.filter(username=request.session['username'])[0]
return studentViewStudentProfile(request, roll_no, 'faculty/_viewStudent.html', current)
return HttpResponseRedirect(redirect)
def uploadSeatingChart(request,course_code):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
if request.method == 'POST':
date = request.POST['dateOfAttendance']
chart = request.FILES['seating']
seats = request.POST.getlist('SD[]')
newdoc = Document(docfile = chart)
newdoc.save()
course = Course.objects.get(id= course_code)
path = os.path.abspath(newdoc.docfile.url[1:])
mark = np.genfromtxt(path, dtype='str', delimiter=',',unpack='True',skip_header=1)
for i in range(250):
try:
# k = mark[1][i]
student = Student.objects.get(rollno=int(mark[1][i]))
studentInCourse = course.getStudents().filter(rollno=student.id)
if studentInCourse:
seatnumber = mark[2][i]
if str(seatnumber) in seats:
present = True
else:
present = False
k = str(date).split('/')
l = k[2]+"-"+k[1]+'-'+k[0]
save = AttendanceDaily.objects.create(rollno=student,coursecode=course,date=l,present=present)
save.save()
except:
continue
return index(request)
return HttpResponseRedirect(redirect)
def editprofile(request):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
template = loader.get_template('faculty/_editprofile.html')
current = Faculty.objects.filter(
username=request.session['username'])[0]
if request.method == "POST":
photo = request.FILES['picture']
current.username.photo = photo
current.username.save(update_fields=['photo'])
officeno = request.POST['officeno']
buildingno = request.POST['buildingno']
update = current
update.officeno = officeno
update.buildingno = buildingno
update.save(update_fields=['officeno', 'buildingno'])
email = str(current.username)
emailSplit = email.split('@')
context = RequestContext(
request, {
'current': current,
'emailsuffix': emailSplit[1],
'emailprefix': emailSplit[0]
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def upload(request):
redirect = checkIdentity(request,'ta')
if redirect == "":
template = loader.get_template('ta/upload.html')
current = TA.objects.filter(username=request.session['username'])[0]
context = RequestContext(request, {'current': current,})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def searchResults(request):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
current = Faculty.objects.filter(
username=request.session['username'])[0]
return portalSearchResults(request, 'faculty/_searchResults.html',
'faculty', current)
return HttpResponseRedirect(redirect)
def searchResults(request):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
current = AdminStaff.objects.filter(
username=request.session['username'])[0]
return portalSearchResults(request, 'adminStaff/_searchResults.html',
'adminStaff', current)
return HttpResponseRedirect(redirect)
def private_index(request):
redirect = checkIdentity(request,'student')
if redirect == "":
template = loader.get_template('Students/private_profile.html')
current = Student.objects.filter(username=request.session['username'])[0]
context = RequestContext(request, {'current': current,})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def reports(request):
redirect = checkIdentity(request, 'facultystaff')
if redirect == "":
current = FacultyStaff.objects.filter(
username=request.session['username'])[0]
return Reports(request, current, 'facultystaff/_reports.html',
'facultystaff/_results.html', 'facultystaff')
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request,'ta')
if redirect == "":
template = loader.get_template('ta/index.html')
current = TA.objects.filter(username=request.session['username'])[0]
ListofStudents = Record.objects.filter(coursecode=current.coursecode.id)
context = RequestContext(request, {'current': current,'ListofStudents': ListofStudents,})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request,'student')
if redirect == "":
template = loader.get_template('Students/index.html')
current = Student.objects.filter(username=request.session['username'])[0]
attendance = AttendanceDaily.objects.filter(rollno=current.id,present=False)
context = RequestContext(request, {'current': current,'attendance':attendance,})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def viewStudentProfile(request, roll_no):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
current = AdminStaff.objects.filter(
username=request.session['username'])[0]
return studentViewStudentProfile(request, roll_no,
'adminStaff/_viewStudent.html',
current)
return HttpResponseRedirect(redirect)
def viewStudentProfile(request, roll_no):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
template = loader.get_template('faculty/_viewStudent.html')
current = Faculty.objects.filter(
username=request.session['username'])[0]
return studentViewStudentProfile(request, roll_no,
'faculty/_viewStudent.html', current)
return HttpResponseRedirect(redirect)
def feedback(request): redirect = checkIdentity(request,'student') if redirect == "": current = Student.objects.filter(username=request.session['username'])[0] if request.method == "POST": feedback_message = request.POST['feedback_message'] flag = Feedback(message=feedback_message, fromusername=str(current.username), fromrole='student') flag.save() return index(request) return HttpResponseRedirect(redirect)
def upload(request):
redirect = checkIdentity(request, 'ta')
if redirect == "":
template = loader.get_template('ta/upload.html')
current = TA.objects.filter(username=request.session['username'])[0]
context = RequestContext(request, {
'current': current,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def private_index(request):
redirect = checkIdentity(request, 'student')
if redirect == "":
template = loader.get_template('Students/private_profile.html')
current = Student.objects.filter(
username=request.session['username'])[0]
context = RequestContext(request, {
'current': current,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def uploadPicture(request):
redirect = checkIdentity(request,'facultystaff')
if redirect == "":
# template = loader.get_template('facultyStaff/_index.html')
current = FacultyStaff.objects.filter(username=request.session['username'])[0]
if request.method == "POST":
picture = request.FILES['picture']
if picture:
current.username.photo = picture
current.username.save(update_fields=['photo',])
return new_index(request)
return HttpResponseRedirect(redirect)
def new_index(request):
redirect = checkIdentity(request,'facultystaff')
if redirect == "":
template = loader.get_template('facultyStaff/_index.html')
current = FacultyStaff.objects.filter(username=request.session['username'])[0]
course = current.courseDetails()
TAs = {}
if course:
TAs[course.coursename] = TA.objects.filter(coursecode_id=course.id)
context = RequestContext(request, {'current': current, 'courses': course, 'TAs': TAs, })
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
template = loader.get_template('faculty/_index.html')
current = Faculty.objects.filter(username=request.session['username'])[0]
courses = Course.objects.filter(faculty=current.id)
TAs = {}
for course in courses:
TAs[course.coursename] = TA.objects.filter(coursecode_id=course.id)
context = RequestContext(request, {'current': current, 'courses': courses, 'TAs': TAs, })
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def feedback(request):
redirect = checkIdentity(request, 'parent')
if redirect == "":
current = Parents.objects.filter(
username=request.session['username'])[0]
if request.method == "POST":
feedback_message = request.POST['feedback_message']
flag = Feedback(message=feedback_message,
fromusername=str(current.username),
fromrole='parent')
flag.save()
return notifications(request)
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request, 'ta')
if redirect == "":
template = loader.get_template('ta/index.html')
current = TA.objects.filter(username=request.session['username'])[0]
ListofStudents = Record.objects.filter(
coursecode=current.coursecode.id)
context = RequestContext(request, {
'current': current,
'ListofStudents': ListofStudents,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def editStudentProfile(request, roll_no):
redirect = checkIdentity(request, 'student')
if redirect == "":
current = Student.objects.filter(
username=request.session['username'])[0]
if request.method == "POST":
fathers_name = request.POST['fathersname']
mothers_name = request.POST['mothersname']
roomno = request.POST['roomno']
private = request.POST.getlist('private[]')
if "private" in private:
private = True
else:
private = False
hostel = request.POST['hostel']
pa_flatno = request.POST['pa_flatno']
pa_line1 = request.POST['pa_line1']
pa_line2 = request.POST['pa_line2']
pa_city = request.POST['pa_city']
pa_state = request.POST['pa_state']
pa_country = request.POST['pa_country']
pa_pincode = request.POST['pa_pincode']
update = current
update.fathers_name = fathers_name
update.mothers_name = mothers_name
update.roomno = roomno
update.hostel = hostel
update.pa_flatno = pa_flatno
update.pa_line1 = pa_line1
update.pa_line2 = pa_line2
update.pa_city = pa_city
update.pa_state = pa_state
update.pa_country = pa_country
update.pa_pincode = pa_pincode
update.private = private
update.save(update_fields=[
'private',
'fathers_name',
'mothers_name',
'roomno',
'hostel',
'pa_flatno',
'pa_line1',
'pa_line2',
'pa_city',
'pa_state',
'pa_country',
'pa_pincode',
])
return index(request)
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request, 'student')
if redirect == "":
template = loader.get_template('Students/index.html')
current = Student.objects.filter(
username=request.session['username'])[0]
attendance = AttendanceDaily.objects.filter(rollno=current.id,
present=False)
context = RequestContext(request, {
'current': current,
'attendance': attendance,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def uploadPicture(request,roll_no):
redirect = checkIdentity(request,'student')
if redirect == "":
template = loader.get_template('Students/index.html')
current = Student.objects.filter(username=request.session['username'])[0]
if request.method == "POST":
picture = request.FILES['picture']
if picture:
current.username.photo = picture
current.username.save(update_fields=['photo',])
attendance = AttendanceDaily.objects.filter(rollno=current.id,present=False)
context = RequestContext(request, {'current': current,'attendance':attendance,})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def uploadPicture(request):
redirect = checkIdentity(request,'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_index.html')
current = AdminStaff.objects.filter(username=request.session['username'])[0]
if request.method == "POST":
picture = request.FILES['picture']
if picture:
current.username.photo = picture
current.username.save(update_fields=['photo',])
feedbackList = Feedback.objects.all
context = RequestContext(request, {'current': current, 'feedbackList': feedbackList, 'sent':"", })
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def attendance(request):
redirect = checkIdentity(request, 'parent')
if redirect == "":
template = loader.get_template('Parents/attendance.html')
current = Parents.objects.filter(
username=request.session['username'])[0]
dailyAttendance = AttendanceDaily.objects.filter(
rollno=current.getStudent().id, present=False)
context = RequestContext(request, {
'current': current,
'dailyAttendance': dailyAttendance
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def uploadPicture(request):
redirect = checkIdentity(request, 'facultystaff')
if redirect == "":
# template = loader.get_template('facultyStaff/_index.html')
current = FacultyStaff.objects.filter(
username=request.session['username'])[0]
if request.method == "POST":
picture = request.FILES['picture']
if picture:
current.username.photo = picture
current.username.save(update_fields=[
'photo',
])
return new_index(request)
return HttpResponseRedirect(redirect)
def viewStudentProfile(request,roll_no):
redirect = checkIdentity(request,'student')
if redirect == "":
current = Student.objects.filter(username=request.session['username'])[0]
student = Student.objects.filter(rollno = roll_no)[0]
private = student.private
if student == current:
private = False
if private:
template = loader.get_template('Students/private_profile.html')
context = RequestContext(request, {'current': current, 'student':student,})
return HttpResponse(template.render(context))
else:
return studentViewStudentProfile(request,roll_no,'Students/viewStudentProfile.html',current)
return HttpResponseRedirect(redirect)
def addNewMonthlyAttendance(request,course_code):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
if request.method == 'POST':
start_date = request.POST['start_date']
end_date = request.POST['end_date']
classes_taken_place = request.POST['classes_taken_place']
course = Course.objects.get(id= course_code)
try:
save = AttendanceMonthly.objects.create(start_date=start_date,end_date=end_date,classes_taken_place=classes_taken_place,coursecode=course)
save.save()
except:
pass
return courseHome(request,course_code)
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_index.html')
current = AdminStaff.objects.filter(username=request.session['username'])[0]
feedbackList = Feedback.objects.all
if request.method == 'POST':
notification_message = request.POST['message']
sendNotification(request, 'ALL', '', notification_message)
sent = "Notification sent Successfully"
context = RequestContext(request, {'current': current, 'feedbackList': feedbackList, 'sent':sent, })
else:
context = RequestContext(request, {'current': current, 'feedbackList': feedbackList, 'sent':"", })
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def coursesList(request):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_coursesList.html')
current = AdminStaff.objects.filter(username=request.session['username'])[0]
if request.method == 'POST':
course_input = request.POST['course_input']
query = "SELECT * FROM portal_course WHERE coursename LIKE \'%"+course_input+"%\' OR coursecode LIKE \'%" +course_input+ "%\'"
courseList = Course.objects.raw(query)
view_all = "Search Results"
else:
courseList = Course.objects.all
view_all = "All"
context = RequestContext(request, {'current': current, 'courseList': courseList, 'all':view_all, })
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def notifications(request):
redirect = checkIdentity(request, 'parent')
if redirect == "":
template = loader.get_template('Parents/notifications.html')
current = Parents.objects.filter(
username=request.session['username'])[0]
# notifications = Notification.objects.raw("SELECT * FROM portal_notification WHERE to LIKE \'%"+str(current.username)+"\'% OR to = 'ALL' ")
lab = str(current.username)
notifications = Notification.objects.filter(
Q(to__contains=str(current.username)) | Q(to__contains='ALL'))
context = RequestContext(request, {
'current': current,
'notifications': notifications
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def new_index(request):
redirect = checkIdentity(request, 'facultystaff')
if redirect == "":
template = loader.get_template('facultyStaff/_index.html')
current = FacultyStaff.objects.filter(
username=request.session['username'])[0]
course = current.courseDetails()
TAs = {}
if course:
TAs[course.coursename] = TA.objects.filter(coursecode_id=course.id)
context = RequestContext(request, {
'current': current,
'courses': course,
'TAs': TAs,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
template = loader.get_template('faculty/_index.html')
current = Faculty.objects.filter(
username=request.session['username'])[0]
courses = Course.objects.filter(faculty=current.id)
TAs = {}
for course in courses:
TAs[course.coursename] = TA.objects.filter(coursecode_id=course.id)
context = RequestContext(request, {
'current': current,
'courses': courses,
'TAs': TAs,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def profile(request):
redirect = checkIdentity(request, 'parent')
if redirect == "":
current = Parents.objects.filter(
username=request.session['username'])[0]
if request.method == "POST":
name = request.POST['name']
contact_number = request.POST['contact_number']
plot_no = request.POST['plot_no']
addr_line1 = request.POST['addr_line1']
addr_line2 = request.POST['addr_line2']
city = request.POST['city']
state = request.POST['state']
country = request.POST['country']
pincode = request.POST['pincode']
update = current
update.name = name
update.contact_no = contact_number
update.plot_flatno = plot_no
update.addr_line1 = addr_line1
update.addr_line2 = addr_line2
update.city = city
update.state = state
update.country = country
update.pincode = pincode
update.save(update_fields=[
'name',
'contact_no',
'plot_flatno',
'addr_line1',
'addr_line2',
'city',
'state',
'country',
'pincode',
])
# return afsd
return notifications(request)
else:
template = loader.get_template('Parents/editprofile.html')
context = RequestContext(request, {
'current': current,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def courseHome(request, course_code):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_courseHome.html')
current = AdminStaff.objects.filter(username=request.session['username'])[0]
course = Course.objects.filter(pk=course_code)[0]
course_semester = course.semester_offered
if course_semester[0] == "M":
course_semester = "Monsoon"
else:
course_semester = "Spring"
faculty = course.getFaculty().name
course = Course.objects.filter(id=course_code)[0]
#query = "SELECT * FROM Students_record WHERE Students_record.coursecode_id = \'"+str(course.id)+"\' AND Students_record.semester_date = \'"+course.semester_offered[0]+str(course.year)+"\'"
#ListofStudents = Record.objects.raw(query)
ListofStudents = Record.objects.filter(coursecode=course.id)
context = RequestContext(request, {'current': current, 'course': course, 'faculty': faculty, 'course_semester': course_semester, 'ListofStudents': ListofStudents})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def addNewMonthlyAttendance(request, course_code):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
if request.method == 'POST':
start_date = request.POST['start_date']
end_date = request.POST['end_date']
classes_taken_place = request.POST['classes_taken_place']
course = Course.objects.get(id=course_code)
try:
save = AttendanceMonthly.objects.create(
start_date=start_date,
end_date=end_date,
classes_taken_place=classes_taken_place,
coursecode=course)
save.save()
except:
pass
return courseHome(request, course_code)
return HttpResponseRedirect(redirect)
def processUploadMarks(request, course_code):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
total = request.POST['totalMarks']
examName = request.POST['examName']
course = Course.objects.get(id=course_code)
if form.is_valid():
newdoc = Document(docfile=request.FILES['docfile'])
newdoc.save()
path = os.path.abspath(newdoc.docfile.url[1:])
mark = np.genfromtxt(path,
dtype='str',
delimiter=',',
unpack='True',
skip_header=1)
# sdfs = mark.ndarray
for i in range(250):
try:
if mark[0][i] == "":
continue
koo = mark[1][i]
student = Student.objects.get(rollno=int(mark[1][i]))
studentInCourse = course.getStudents().filter(
rollno=student.id)
if studentInCourse:
looo = mark[2][i]
# return sdfs
save = Marks.objects.create(
rollno=student,
category=examName,
semester_date=course.semester_offered[0] +
str(course.year),
coursecode=course,
marks=int(mark[2][i]),
total=int(total))
save.save()
except:
continue
return index(request)
return HttpResponseRedirect(redirect)
def viewStudentProfile(request, roll_no):
redirect = checkIdentity(request, 'student')
if redirect == "":
current = Student.objects.filter(
username=request.session['username'])[0]
student = Student.objects.filter(rollno=roll_no)[0]
private = student.private
if student == current:
private = False
if private:
template = loader.get_template('Students/private_profile.html')
context = RequestContext(request, {
'current': current,
'student': student,
})
return HttpResponse(template.render(context))
else:
return studentViewStudentProfile(
request, roll_no, 'Students/viewStudentProfile.html', current)
return HttpResponseRedirect(redirect)
def editprofile(request):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
template = loader.get_template('faculty/_editprofile.html')
current = Faculty.objects.filter(username=request.session['username'])[0]
if request.method == "POST":
photo = request.FILES['picture']
current.username.photo = photo
current.username.save(update_fields=['photo'])
officeno = request.POST['officeno']
buildingno = request.POST['buildingno']
update = current
update.officeno = officeno
update.buildingno = buildingno
update.save(update_fields=['officeno', 'buildingno'])
email = str(current.username)
emailSplit = email.split('@')
context = RequestContext(request, {'current': current, 'emailsuffix':emailSplit[1], 'emailprefix':emailSplit[0]})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def uploadSeatingChart(request, course_code):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
if request.method == 'POST':
date = request.POST['dateOfAttendance']
chart = request.FILES['seating']
seats = request.POST.getlist('SD[]')
newdoc = Document(docfile=chart)
newdoc.save()
course = Course.objects.get(id=course_code)
path = os.path.abspath(newdoc.docfile.url[1:])
mark = np.genfromtxt(path,
dtype='str',
delimiter=',',
unpack='True',
skip_header=1)
for i in range(250):
try:
# k = mark[1][i]
student = Student.objects.get(rollno=int(mark[1][i]))
studentInCourse = course.getStudents().filter(
rollno=student.id)
if studentInCourse:
seatnumber = mark[2][i]
if str(seatnumber) in seats:
present = True
else:
present = False
# m = seats.index(str(seatnumber))
k = str(date).split('/')
l = k[2] + "-" + k[1] + '-' + k[0]
save = AttendanceDaily.objects.create(
rollno=student,
coursecode=course,
date=l,
present=present)
save.save()
except:
continue
return courseHome(request, course_code)
return HttpResponseRedirect(redirect)
def uploadPicture(request, roll_no):
redirect = checkIdentity(request, 'student')
if redirect == "":
template = loader.get_template('Students/index.html')
current = Student.objects.filter(
username=request.session['username'])[0]
if request.method == "POST":
picture = request.FILES['picture']
if picture:
current.username.photo = picture
current.username.save(update_fields=[
'photo',
])
attendance = AttendanceDaily.objects.filter(rollno=current.id,
present=False)
context = RequestContext(request, {
'current': current,
'attendance': attendance,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def uploadPicture(request):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_index.html')
current = AdminStaff.objects.filter(
username=request.session['username'])[0]
if request.method == "POST":
picture = request.FILES['picture']
if picture:
current.username.photo = picture
current.username.save(update_fields=[
'photo',
])
feedbackList = Feedback.objects.all
context = RequestContext(request, {
'current': current,
'feedbackList': feedbackList,
'sent': "",
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def coursesList(request):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_coursesList.html')
current = AdminStaff.objects.filter(
username=request.session['username'])[0]
if request.method == 'POST':
course_input = request.POST['course_input']
query = "SELECT * FROM portal_course WHERE coursename LIKE \'%" + course_input + "%\' OR coursecode LIKE \'%" + course_input + "%\'"
courseList = Course.objects.raw(query)
view_all = "Search Results"
else:
courseList = Course.objects.all
view_all = "All"
context = RequestContext(request, {
'current': current,
'courseList': courseList,
'all': view_all,
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def processUploadAttendance(request, course_code):
redirect = checkIdentity(request, 'ta')
if redirect == "":
if request.method == 'POST':
form1 = read(request.POST, request.FILES)
total = request.POST['date1']
course = Course.objects.get(id=course_code)
if form1.is_valid():
newdoc = Document1(docfile=request.FILES['docfile'])
newdoc.save()
path = os.path.abspath(newdoc.docfile.url[1:])
mark = np.genfromtxt(path,
dtype='str',
delimiter=',',
unpack='True',
skip_header=1)
for i in range(250):
try:
# k = mark[1][i]
student = Student.objects.get(rollno=int(mark[1][i]))
studentInCourse = course.getStudents().filter(
rollno=student.id)
if studentInCourse:
k = str(total).split('/')
l = k[2] + "-" + k[1] + '-' + k[0]
if mark[2][i][0] == 'P':
present = True
else:
present = False
save = AttendanceDaily.objects.create(
rollno=student,
coursecode=course,
date=l,
present=present)
save.save()
except:
continue
return index(request)
return HttpResponseRedirect(redirect)
def statistics(request):
redirect = checkIdentity(request, 'parent')
if redirect == "":
template = loader.get_template('Parents/statistics.html')
current = Parents.objects.filter(
username=request.session['username'])[0]
cgpalist = []
colorlist1 = []
colorlist2 = []
keylist = []
k = 6
while k != 11:
cgpalist.append(getCGPAByRange(k - 1, k, current))
colorlist1.append(getRandomColor())
colorlist2.append(getRandomColor())
keylist.append("CGPA - " + str(k - 1) + ".0 and " + str(k) + ".0")
k = k + 1
cgpalist1 = zip(cgpalist, colorlist1, colorlist2, keylist)
cgpalist = []
colorlist1 = []
colorlist2 = []
keylist = []
k = 6
while k != 11:
cgpalist.append(getCGPAByRangeAndProgramme(k - 1, k, current))
colorlist1.append(getRandomColor())
colorlist2.append(getRandomColor())
keylist.append("CGPA - " + str(k - 1) + ".0 and " + str(k) + ".0")
k = k + 1
cgpalist2 = zip(cgpalist, colorlist1, colorlist2, keylist)
context = RequestContext(request, {
'current': current,
'cgpalist1': cgpalist1,
'cgpalist2': cgpalist2
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def editStudentProfile(request,roll_no):
redirect = checkIdentity(request,'student')
if redirect == "":
current = Student.objects.filter(username=request.session['username'])[0]
if request.method == "POST":
fathers_name = request.POST['fathersname']
mothers_name = request.POST['mothersname']
roomno = request.POST['roomno']
private = request.POST.getlist('private[]')
if "private" in private:
private = True
else:
private = False
hostel = request.POST['hostel']
pa_flatno = request.POST['pa_flatno']
pa_line1 = request.POST['pa_line1']
pa_line2 = request.POST['pa_line2']
pa_city = request.POST['pa_city']
pa_state = request.POST['pa_state']
pa_country = request.POST['pa_country']
pa_pincode = request.POST['pa_pincode']
update = current
update.fathers_name = fathers_name
update.mothers_name = mothers_name
update.roomno = roomno
update.hostel = hostel
update.pa_flatno = pa_flatno
update.pa_line1 = pa_line1
update.pa_line2 = pa_line2
update.pa_city = pa_city
update.pa_state = pa_state
update.pa_country = pa_country
update.pa_pincode = pa_pincode
update.private = private
update.save(update_fields=['private','fathers_name','mothers_name','roomno','hostel','pa_flatno','pa_line1','pa_line2','pa_city','pa_state','pa_country','pa_pincode',])
return index(request)
return HttpResponseRedirect(redirect)
def index(request):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
template = loader.get_template('adminStaff/_index.html')
current = AdminStaff.objects.filter(
username=request.session['username'])[0]
feedbackList = Feedback.objects.all
if request.method == 'POST':
notification_message = request.POST['message']
sendNotification(request, 'ALL', '', notification_message)
sent = "Notification sent Successfully"
context = RequestContext(request, {
'current': current,
'feedbackList': feedbackList,
'sent': sent,
})
else:
context = RequestContext(request, {
'current': current,
'feedbackList': feedbackList,
'sent': "",
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def searchResults(request):
redirect = checkIdentity(request, 'facultystaff')
if redirect == "":
current = FacultyStaff.objects.filter(username=request.session['username'])[0]
return portalSearchResults(request, 'facultystaff/_searchResults.html', 'facultystaff', current)
return HttpResponseRedirect(redirect)
def viewStudentProfile(request, roll_no):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
current = AdminStaff.objects.filter(username=request.session['username'])[0]
return studentViewStudentProfile(request, roll_no, 'adminStaff/_viewStudent.html', current)
return HttpResponseRedirect(redirect)
def reports(request):
redirect = checkIdentity(request, 'adminstaff')
if redirect == "":
current = AdminStaff.objects.filter(username=request.session['username'])[0]
return Reports(request, current, 'adminStaff/_reports.html', 'adminStaff/_results.html','adminStaff')
return HttpResponseRedirect(redirect)
def reports(request):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
current = Faculty.objects.filter(username=request.session['username'])[0]
return Reports(request, current, 'faculty/_reports.html', 'faculty/_results.html','faculty')
return HttpResponseRedirect(redirect)
def searchResults(request):
redirect = checkIdentity(request, 'student')
if redirect == "":
current = Student.objects.filter(username=request.session['username'])[0]
return portalSearchResults(request, 'Students/_searchResults.html', 'student', current)
return HttpResponseRedirect(redirect)
def grades(request, course_code):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
if request.method == 'POST':
category = request.POST['category']
k = []
if category == 'MidSem1':
cat = "MD1"
k = request.POST.getlist('MD1[]')
k1 = request.POST.getlist('MD1T[]')
elif category == 'MidSem2':
cat = "MD2"
k = request.POST.getlist('MD2[]')
k1 = request.POST.getlist('MD2T[]')
else:
cat = "ESM"
k = request.POST.getlist('ESM[]')
k1 = request.POST.getlist('ESMT[]')
names = request.POST.getlist('rollnos[]')
UpdateList = zip(names,k,k1)
course = Course.objects.filter(pk=course_code)[0]
for name,marks,total in UpdateList:
try:
Students = Marks.objects.get(coursecode=course.id, category=cat,rollno=name)
Students.marks = marks
Students.total = total
marks = marks
Students.save(update_fields=['marks','total'])
except:
k = Student.objects.get(id=name)
if not marks:
marks = 0
if not total:
total = 0
l = Marks.objects.create(rollno=k,coursecode=course,category=cat,marks=float(int(marks)),total=float(int(total)))
l.save()
template = loader.get_template('faculty/_grades.html')
current = Faculty.objects.filter(username=request.session['username'])[0]
course = Course.objects.filter(pk=course_code)[0]
course_semester = course.semester_offered
if course_semester[0] == "M":
course_semester = "Monsoon"
else:
course_semester = "Spring"
faculty = course.getFaculty().name
ListofStudents = course.getStudents()
StudentName = []
StudentID = []
ListofMarks1 = []
ListofMarks2 = []
ListofMarks3 = []
ListofTotal1 = []
ListofTotal2 = []
ListofTotal3 = []
for student in ListofStudents:
StudentName.append(student.rollno.name)
StudentID.append(student.rollno.id)
L1 = Marks.objects.filter(coursecode=course.id, category='MD1', rollno = student.rollno.id)
L2 = Marks.objects.filter(coursecode=course.id, category='MD2', rollno = student.rollno.id)
L3 = Marks.objects.filter(coursecode=course.id, category='ESM', rollno = student.rollno.id)
if L1:
ListofMarks1.append(L1[0].marks)
ListofTotal1.append(L1[0].total)
else:
ListofMarks1.append([])
ListofTotal1.append([])
if L2:
ListofMarks2.append(L2[0].marks)
ListofTotal2.append(L2[0].total)
else:
ListofMarks2.append([])
ListofTotal2.append([])
if L3:
ListofMarks3.append(L3[0].marks)
ListofTotal3.append(L3[0].total)
else:
ListofMarks3.append([])
ListofTotal3.append([])
ListofMarks = zip(StudentID,StudentName,ListofMarks1,ListofTotal1,ListofMarks2,ListofTotal2,ListofMarks3,ListofTotal3)
form = DocumentForm()
context = RequestContext(request, {'current': current, 'course': course, 'faculty': faculty, 'course_semester': course_semester, 'ListofMarks': ListofMarks,'form':form})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def attendance(request, course_code):
redirect = checkIdentity(request, 'faculty')
if redirect == "":
template = loader.get_template('faculty/_attendance.html')
current = Faculty.objects.filter(username=request.session['username'])[0]
course = Course.objects.filter(pk=course_code)[0]
course_semester = course.semester_offered
if course_semester[0] == "M":
course_semester = "Monsoon"
else:
course_semester = "Spring"
faculty = course.getFaculty().name
if request.method == "POST":
ListofStudents = course.getStudents()
period = request.POST['periods']
date = request.POST['date']
period = AttendanceMonthly.objects.filter(id = int(period))
if period:
selectValue = period[0]
attendance = []
for student in ListofStudents:
l = student.id
k = student.rollno
total = AttendanceDaily.objects.filter(rollno=student.rollno, coursecode=course.id, present=True, date__range=(period[0].start_date, period[0].end_date))
attendance.append(total.count())
# return adf
ListofStudents = zip(ListofStudents,attendance)
total = period[0].classes_taken_place
totalList = AttendanceMonthly.objects.filter(coursecode=course.id)
else:
selectValue = 0
attendance = []
for student in ListofStudents:
l = student.id
k = student.rollno
total = AttendanceDaily.objects.filter(rollno=student.rollno, coursecode=course.id, present=True)
attendance.append(total.count())
# return adf
ListofStudents = zip(ListofStudents,attendance)
total = AttendanceMonthly.objects.filter(coursecode=course.id).aggregate(Sum('classes_taken_place'))
total = total['classes_taken_place__sum']
totalList = AttendanceMonthly.objects.filter(coursecode=course.id)
if date == '1990-01-01':
DselectValue = 0
else:
DselectValue = date
DtotalList = AttendanceDaily.objects.filter(coursecode=course.id).values_list('date', flat=True).distinct()
DListofStudents = AttendanceDaily.objects.filter(coursecode=course.id,date=date)
context = RequestContext(request, {'current': current, 'course': course, 'faculty': faculty,
'course_semester': course_semester, 'ListofStudents': ListofStudents, 'total': total, 'totalList': totalList, 'DtotalList': DtotalList,'DListofStudents':DListofStudents, 'selectValue': selectValue,'DselectValue': DselectValue})
else:
selectValue = 0
ListofStudents = course.getStudents()
attendance = []
for student in ListofStudents:
l = student.id
k = student.rollno
total = AttendanceDaily.objects.filter(rollno=student.rollno, coursecode=course.id, present=True)
attendance.append(total.count())
# return adf
ListofStudents = zip(ListofStudents,attendance)
total = AttendanceMonthly.objects.filter(coursecode=course.id).aggregate(Sum('classes_taken_place'))
totalList = AttendanceMonthly.objects.filter(coursecode=course.id)
# return wers
form1 = read()
DtotalList = AttendanceDaily.objects.filter(coursecode=course.id).values_list('date', flat=True).distinct() #AttendanceDaily.objects.filter(coursecode=course.id).distinct('date')
total = total['classes_taken_place__sum']
context = RequestContext(request, {'current': current, 'course': course, 'faculty': faculty,
'course_semester': course_semester, 'ListofStudents': ListofStudents, 'total': total, 'totalList': totalList,'DtotalList': DtotalList, 'selectValue':selectValue,'form1':form1})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def updateMarks(request, course_code):
redirect = checkIdentity(request, 'ta')
if redirect == "":
if request.method == 'POST':
category = request.POST['category']
k = []
# if category == 'Quiz1':
# cat = "Q1"
# k = request.POST.getlist('Q1[]')
# k1 = request.POST.getlist('Q1T[]')
# if category == 'Quiz2':
# cat = "Q2"
# k = request.POST.getlist('Q2[]')
# k1 = request.POST.getlist('Q2T[]')
# if category == 'Quiz3':
# cat = "Q3"
# k = request.POST.getlist('Q3[]')
# k1 = request.POST.getlist('Q3T[]')
if category == 'MidSem1':
cat = "MD1"
k = request.POST.getlist('MD1[]')
k1 = request.POST.getlist('MD1T[]')
elif category == 'MidSem2':
cat = "MD2"
k = request.POST.getlist('MD2[]')
k1 = request.POST.getlist('MD2T[]')
else:
cat = "ESM"
k = request.POST.getlist('ESM[]')
k1 = request.POST.getlist('ESMT[]')
names = request.POST.getlist('rollnos[]')
UpdateList = zip(names, k, k1)
course = Course.objects.filter(pk=course_code)[0]
# return asf
for name, marks, total in UpdateList:
try:
Students = Marks.objects.get(coursecode=course.id,
category=cat,
rollno=name)
Students.marks = marks
Students.total = total
marks = marks
Students.save(update_fields=['marks', 'total'])
except:
k = Student.objects.get(id=name)
if not marks:
marks = 0
if not total:
total = 0
l = Marks.objects.create(rollno=k,
coursecode=course,
category=cat,
marks=float(int(marks)),
total=float(int(total)))
l.save()
#return ihuh
template = loader.get_template('ta/_updateMarks.html')
current = TA.objects.filter(username=request.session['username'])[0]
course = Course.objects.filter(pk=course_code)[0]
ListofStudents = course.getStudents()
StudentName = []
StudentID = []
ListofMarks1 = []
ListofMarks2 = []
ListofMarks3 = []
ListofTotal1 = []
ListofTotal2 = []
ListofTotal3 = []
# ListofMarks4 = []
# ListofMarks5 = []
# ListofMarks6 = []
# ListofTotal4 = []
# ListofTotal5 = []
# ListofTotal6 = []
for student in ListofStudents:
StudentName.append(student.rollno.name)
StudentID.append(student.rollno.id)
L1 = Marks.objects.filter(coursecode=course.id,
category='MD1',
rollno=student.rollno.id)
L2 = Marks.objects.filter(coursecode=course.id,
category='MD2',
rollno=student.rollno.id)
L3 = Marks.objects.filter(coursecode=course.id,
category='ESM',
rollno=student.rollno.id)
# L4 = Marks.objects.filter(coursecode=course.id, category='Q1', rollno = student.rollno.id)
# L5 = Marks.objects.filter(coursecode=course.id, category='Q2', rollno = student.rollno.id)
# L6 = Marks.objects.filter(coursecode=course.id, category='Q3', rollno = student.rollno.id)
if L1:
ListofMarks1.append(L1[0].marks)
ListofTotal1.append(L1[0].total)
else:
ListofMarks1.append([])
ListofTotal1.append([])
if L2:
ListofMarks2.append(L2[0].marks)
ListofTotal2.append(L2[0].total)
else:
ListofMarks2.append([])
ListofTotal2.append([])
if L3:
ListofMarks3.append(L3[0].marks)
ListofTotal3.append(L3[0].total)
else:
ListofMarks3.append([])
ListofTotal3.append([])
# if L4:
# ListofMarks4.append(L4[0].marks)
# ListofTotal4.append(L4[0].total)
# else:
# ListofMarks4.append([])
# ListofTotal4.append([])
# if L5:
# ListofMarks5.append(L5[0].marks)
# ListofTotal5.append(L5[0].total)
# else:
# ListofMarks5.append([])
# ListofTotal5.append([])
# if L6:
# ListofMarks6.append(L6[0].marks)
# ListofTotal6.append(L6[0].total)
# else:
# ListofMarks6.append([])
# ListofTotal6.append([])
ListofMarks = zip(
StudentID, StudentName, ListofMarks1, ListofTotal1, ListofMarks2,
ListofTotal2, ListofMarks3, ListofTotal3
) #,ListofMarks4,ListofTotal4,ListofMarks5,ListofTotal5,ListofMarks6,ListofTotal6)
form = DocumentForm()
context = RequestContext(
request, {
'current': current,
'course': course,
'ListofMarks': ListofMarks,
'form': form
})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)
def updateMarks(request, course_code):
redirect = checkIdentity(request, 'ta')
if redirect == "":
if request.method == 'POST':
category = request.POST['category']
k = []
# if category == 'Quiz1':
# cat = "Q1"
# k = request.POST.getlist('Q1[]')
# k1 = request.POST.getlist('Q1T[]')
# if category == 'Quiz2':
# cat = "Q2"
# k = request.POST.getlist('Q2[]')
# k1 = request.POST.getlist('Q2T[]')
# if category == 'Quiz3':
# cat = "Q3"
# k = request.POST.getlist('Q3[]')
# k1 = request.POST.getlist('Q3T[]')
if category == 'MidSem1':
cat = "MD1"
k = request.POST.getlist('MD1[]')
k1 = request.POST.getlist('MD1T[]')
elif category == 'MidSem2':
cat = "MD2"
k = request.POST.getlist('MD2[]')
k1 = request.POST.getlist('MD2T[]')
else:
cat = "ESM"
k = request.POST.getlist('ESM[]')
k1 = request.POST.getlist('ESMT[]')
names = request.POST.getlist('rollnos[]')
UpdateList = zip(names,k,k1)
course = Course.objects.filter(pk=course_code)[0]
# return asf
for name,marks,total in UpdateList:
try:
Students = Marks.objects.get(coursecode=course.id, category=cat,rollno=name)
Students.marks = marks
Students.total = total
marks = marks
Students.save(update_fields=['marks','total'])
except:
k = Student.objects.get(id=name)
if not marks:
marks = 0
if not total:
total = 0
l = Marks.objects.create(rollno=k,coursecode=course,category=cat,marks=float(int(marks)),total=float(int(total)))
l.save()
#return ihuh
template = loader.get_template('ta/_updateMarks.html')
current = TA.objects.filter(username=request.session['username'])[0]
course = Course.objects.filter(pk=course_code)[0]
ListofStudents = course.getStudents()
StudentName = []
StudentID = []
ListofMarks1 = []
ListofMarks2 = []
ListofMarks3 = []
ListofTotal1 = []
ListofTotal2 = []
ListofTotal3 = []
# ListofMarks4 = []
# ListofMarks5 = []
# ListofMarks6 = []
# ListofTotal4 = []
# ListofTotal5 = []
# ListofTotal6 = []
for student in ListofStudents:
StudentName.append(student.rollno.name)
StudentID.append(student.rollno.id)
L1 = Marks.objects.filter(coursecode=course.id, category='MD1', rollno = student.rollno.id)
L2 = Marks.objects.filter(coursecode=course.id, category='MD2', rollno = student.rollno.id)
L3 = Marks.objects.filter(coursecode=course.id, category='ESM', rollno = student.rollno.id)
# L4 = Marks.objects.filter(coursecode=course.id, category='Q1', rollno = student.rollno.id)
# L5 = Marks.objects.filter(coursecode=course.id, category='Q2', rollno = student.rollno.id)
# L6 = Marks.objects.filter(coursecode=course.id, category='Q3', rollno = student.rollno.id)
if L1:
ListofMarks1.append(L1[0].marks)
ListofTotal1.append(L1[0].total)
else:
ListofMarks1.append([])
ListofTotal1.append([])
if L2:
ListofMarks2.append(L2[0].marks)
ListofTotal2.append(L2[0].total)
else:
ListofMarks2.append([])
ListofTotal2.append([])
if L3:
ListofMarks3.append(L3[0].marks)
ListofTotal3.append(L3[0].total)
else:
ListofMarks3.append([])
ListofTotal3.append([])
# if L4:
# ListofMarks4.append(L4[0].marks)
# ListofTotal4.append(L4[0].total)
# else:
# ListofMarks4.append([])
# ListofTotal4.append([])
# if L5:
# ListofMarks5.append(L5[0].marks)
# ListofTotal5.append(L5[0].total)
# else:
# ListofMarks5.append([])
# ListofTotal5.append([])
# if L6:
# ListofMarks6.append(L6[0].marks)
# ListofTotal6.append(L6[0].total)
# else:
# ListofMarks6.append([])
# ListofTotal6.append([])
ListofMarks = zip(StudentID,StudentName,ListofMarks1,ListofTotal1,ListofMarks2,ListofTotal2,ListofMarks3,ListofTotal3)#,ListofMarks4,ListofTotal4,ListofMarks5,ListofTotal5,ListofMarks6,ListofTotal6)
form = DocumentForm()
context = RequestContext(request, {'current': current, 'course': course, 'ListofMarks': ListofMarks,'form':form})
return HttpResponse(template.render(context))
return HttpResponseRedirect(redirect)