def courseModify(request): errors = [] if request.method == 'GET': if 'term' in request.GET: inSearch = True searchTerm = request.GET.get('term') searchType = request.GET.get('type') if not searchTerm: errors.append('Please enter a key word') else: if searchType == 'course_id': courses = Course_info.objects.filter(course_id=searchTerm) elif searchType == 'course_name': courses = Course_info.objects.filter( name__icontains=searchTerm) #else: #courses = Course_info.objects.filter(teacher = searchTerm) if request.method == 'POST': if 'modifyid' in request.POST: inModify = True courseId = request.POST.get('modifyid') term = Course_info.objects.filter(course_id=courseId) form = CourseFormModify( initial={ 'course_name': term[0].name, 'credits': term[0].credits, 'semester': term[0].semester, 'textbook': term[0].textbook, 'college': term[0].college }) else: form = CourseFormModify(request.POST) if form.is_valid(): info = form.cleaned_data dbQuery = Course_info( course_id=request.POST.get('courseId'), name=info['course_name'], credits=info['credits'], semester=info['semester'], textbook=info['textbook'], college=info['college'], ) dbQuery.save() modifyIsDone = True return render(request, 'ModifyCourse.html', locals())
def courseModify(request): errors = [] if request.method == 'GET': if 'term' in request.GET: inSearch = True searchTerm = request.GET.get('term') searchType = request.GET.get('type') if not searchTerm: errors.append('Please enter a key word') else: if searchType == 'course_id': courses = Course_info.objects.filter(course_id = searchTerm) elif searchType == 'course_name': courses = Course_info.objects.filter(name__icontains = searchTerm) #else: #courses = Course_info.objects.filter(teacher = searchTerm) if request.method == 'POST': if 'modifyid' in request.POST: inModify = True courseId = request.POST.get('modifyid') term = Course_info.objects.filter(course_id = courseId) form = CourseFormModify(initial = { 'course_name': term[0].name, 'credits': term[0].credits, 'semester': term[0].semester, 'textbook': term[0].textbook, 'college': term[0].college} ) else: form = CourseFormModify(request.POST) if form.is_valid(): info = form.cleaned_data dbQuery = Course_info( course_id = request.POST.get('courseId'), name = info['course_name'], credits = info['credits'], semester = info['semester'], textbook = info['textbook'], college = info['college'], ) dbQuery.save() modifyIsDone = True return render(request, 'ModifyCourse.html', locals())
def courseModify(request): errors = [] #===========USER GROUP CHECK========================================================# isAdmin = False # isFaculty = False # userName = request.user.username # if Admin_user.objects.filter(id = userName): # userInfo = Admin_user.objects.filter(id = userName) # if userInfo[0].college == 'all': # isAdmin = True # userCollege = -1 # else: # isFaculty = True # userCollege = userInfo[0].college # elif Faculty_user.objects.filter(id = userName): # userInfo = Faculty_user.objects.filter(id = userName) # if userInfo[0].isSpecial and request.user.has_perm("IMS.course_manage"): # isFaculty = True # userCollege = userInfo[0].college # elif Student_user.objects.filter(id = userName): # userInfo = Student_user.objects.filter(id = userName) # if userInfo[0].isSpecial and request.user.has_perm("IMS.course_manage"): # isFaculty = True # userCollege = userInfo[0].college # #isAdmin = True # #isFaculty = False # #userCollege = -1 # #============END OF GROUP CHECK=====================================================# if request.method == 'POST': if 'term' in request.POST: #search box inSearch = True searchTerm = request.POST.get('term') searchType = request.POST.get('type') if not searchTerm: if isAdmin: courses = Course_info.objects.all() elif isFaculty: courses = Course_info.objects.filter(college = userCollege) else: courses = getSearchResult(searchType, searchTerm, isAdmin, isFaculty, userCollege) return render(request, 'ModifyCourse.html', locals()) elif 'modifyid' in request.POST: #initial info page inModify = True courseId = request.POST.get('modifyid') term = Course_info.objects.filter(course_id = courseId) if isAdmin: form = CourseFormModify(initial = { 'course_name': term[0].name, 'credits': term[0].credits, 'semester': term[0].semester, 'textbook': term[0].textbook, 'college': term[0].college, 'course_type' : term[0].course_type }) elif isFaculty: facultyModify = True form = CourseFormFacultyModify(initial = { 'course_name': term[0].name, 'credits': term[0].credits, 'semester': term[0].semester, 'textbook': term[0].textbook, 'course_type' : term[0].course_type }) return render(request, 'ModifyCourse.html', locals()) else: #DB update after press submit on initial info page if isAdmin: form = CourseFormModify(request.POST) if form.is_valid(): info = form.cleaned_data dbQuery = Course_info( course_id = request.POST.get('courseId'), name = info['course_name'], credits = info['credits'], semester = info['semester'], textbook = info['textbook'], college = info['college'], course_type = info['course_type'], ) dbQuery.save() modifyIsDone = True elif isFaculty: form = CourseFormFacultyModify(request.POST) if form.is_valid(): info = form.cleaned_data dbQuery = Course_info( course_id = request.POST.get('courseId'), name = info['course_name'], credits = info['credits'], semester = info['semester'], textbook = info['textbook'], college = userCollege, course_type = info['course_type'], ) dbQuery.save() modifyIsDone = True return render(request, 'ModifyCourse.html', locals()) return render(request, 'AccessFault.html')
def courseModify(request): errors = [] # ===========USER GROUP CHECK========================================================# isAdmin = False # isFaculty = False # userName = request.user.username # if Admin_user.objects.filter(id=userName): # userInfo = Admin_user.objects.filter(id=userName) # if userInfo[0].college == "all": # isAdmin = True # userCollege = -1 # else: # isFaculty = True # userCollege = userInfo[0].college # elif Faculty_user.objects.filter(id=userName): # userInfo = Faculty_user.objects.filter(id=userName) # if userInfo[0].isSpecial and request.user.has_perm("IMS.course_manage"): # isFaculty = True # userCollege = userInfo[0].college # elif Student_user.objects.filter(id=userName): # userInfo = Student_user.objects.filter(id=userName) # if userInfo[0].isSpecial and request.user.has_perm("IMS.course_manage"): # isFaculty = True # userCollege = userInfo[0].college # # isAdmin = True # # isFaculty = False # # userCollege = -1 # # ============END OF GROUP CHECK=====================================================# if request.method == "POST": if "term" in request.POST: # search box inSearch = True searchTerm = request.POST.get("term") searchType = request.POST.get("type") if not searchTerm: if isAdmin: courses = Course_info.objects.all() elif isFaculty: courses = Course_info.objects.filter(college=userCollege) else: courses = getSearchResult(searchType, searchTerm, isAdmin, isFaculty, userCollege) return render(request, "ModifyCourse.html", locals()) elif "modifyid" in request.POST: # initial info page inModify = True courseId = request.POST.get("modifyid") term = Course_info.objects.filter(id=courseId) if isAdmin: form = CourseFormModify( initial={ "name": term[0].name, "credits": term[0].credits, "semester": term[0].semester, "textbook": term[0].textbook, "college": term[0].college, "course_type": term[0].course_type, } ) elif isFaculty: facultyModify = True form = CourseFormFacultyModify( initial={ "name": term[0].name, "credits": term[0].credits, "semester": term[0].semester, "textbook": term[0].textbook, "course_type": term[0].course_type, } ) return render(request, "ModifyCourse.html", locals()) else: # DB update after press submit on initial info page if isAdmin: form = CourseFormModify(request.POST) if form.is_valid(): info = form.cleaned_data dbQuery = Course_info( id=request.POST.get("courseId"), name=info["name"], credits=info["credits"], semester=info["semester"], textbook=info["textbook"], college=info["college"], course_type=info["course_type"], ) dbQuery.save() modifyIsDone = True elif isFaculty: form = CourseFormFacultyModify(request.POST) if form.is_valid(): info = form.cleaned_data dbQuery = Course_info( id=request.POST.get("courseId"), name=info["name"], credits=info["credits"], semester=info["semester"], textbook=info["textbook"], college=userCollege, course_type=info["course_type"], ) dbQuery.save() modifyIsDone = True return render(request, "ModifyCourse.html", locals()) return render(request, "AccessFault.html")