class QuestionController():
def __init__(self):
if 'instructor' in session:
self.loggedIn = True
self.newStudent_interest = Student_interest()
self.newCourse_interest = Course_interest()
self.newInterest = Interest()
self.newCourse = Course()
self.newStudent_subscription = Student_subscription()
self.newStudent = Student()
self.newInstructor = Instructor()
self.newLesson = Lesson()
self.newStudent_question = Student_question()
self.newQuestion_response = Question_response()
def course_questions(self, title):
data = {}
data['questions'] = []
course = self.newCourse.get_course_by_title(title)
questions = self.newStudent_question.get_course_questions(
str(course['_id']))
if questions:
for question in questions:
question['student'] = self.newStudent.get_student_by_id(
question['student_id'])
question['lesson'] = self.newLesson.get_lesson_by_id(
ObjectId(question['lesson_id']))
question[
'responses'] = self.newQuestion_response.get_question_responses(
str(question['_id']))
data['questions'].append(question)
data['course'] = course
return render_template("instructor/course_questions.html",
data=data)
return redirect(url_for('instructor_dashboard'))
def question(self, questionId):
data = {}
data['responses'] = []
question_id = ObjectId(questionId)
question = self.newStudent_question.get_question(question_id)
lesson = self.newLesson.get_lesson_by_id(
ObjectId(question['lesson_id']))
course = self.newCourse.get_course_by_id(
ObjectId(question['course_id']))
responses = self.newQuestion_response.get_question_responses(
questionId)
if (responses.count() > 0):
for response in responses:
if (response['student_id'] == 0):
instructor = self.newInstructor.get_instructor_by_id(
ObjectId(response['instructor_id']))
response['instructor'] = instructor
if (response['instructor_id'] == 0):
student = self.newStudent.get_student_by_id(
ObjectId(response['student_id']))
response['student'] = student
data['responses'].append(response)
data['question'] = question
#data['responses'] = responses
data['lesson'] = lesson
data['course'] = course
return render_template("instructor/question.html", data=data)
session['error_msg'].clear()
def respond(self):
instructor_id = session['instructor']['id']
question_id = request.form['question_id']
response = request.form['response']
result = self.newQuestion_response.instructor(question_id,
instructor_id, response)
if (result == 'ERROR'):
return question_id + ' ' + instructor_id + ' ' + response + ' OOPS! Problem occured while trying to submit your response, try again later'
return redirect(url_for('student_question', questionId=question_id))
class CourseController():
def __init__(self):
if 'student' not in session:
return redirect(url_for('index'))
self.newStudent_interest = Student_interest()
self.newCourse_interest = Course_interest()
self.newInterest = Interest()
self.newCourse = Course()
self.newStudent_subscription = Student_subscription()
self.newStudent = Student()
self.newInstructor = Instructor()
self.newLesson = Lesson()
self.newStudent_question = Student_question()
self.newQuestion_response = Question_response()
def single_course(self, courseId):
data = {}
data['loggedIn'] = False
data['course_lessons'] = []
data['similar_courses'] = []
data['loggedIn'] = True
data['student'] = session['student']
course = self.newCourse.get_course_by_id(ObjectId(courseId))
if course:
student_id = ObjectId(session['student']['id'])
similar_courses = self.newCourse_interest.get_similar_courses(course['_id'])
instructor = self.newInstructor.get_instructor_by_id(course['instructor_id'])
courseLessons = self.newLesson.get_lesson_by_courseId(course['_id'])
courseDuration = 0
for lesson in courseLessons:
courseDuration = int(courseDuration) + int(lesson['duration'])
data['course_lessons'].append(lesson)
subscribed = self.newStudent_subscription.get_student_course_subscriptions(student_id, course['_id'])
if subscribed:
data['subscribed'] = 1
else:
data['subscribed'] = 0
thisCourse = '';
data['course'] = course
data['instructor'] = instructor
data['course_duration'] = courseDuration
data['similar_courses'] = similar_courses
#return jsonify(len(similar_courses))
return render_template("course_single.html", data=data)
else:
return redirect(url_for('dashboard'))
def course_lesson(self, course_title, lesson_title):
data = {}
data['QForm'] = QuestionForm()
data['loggedIn'] = False
data['loggedIn'] = True
data['student'] = session['student']
data['course_lessons'] = []
data['lesson_questions'] = []
student_id = ObjectId(session['student']['id'])
course = self.newCourse.get_course_by_title(course_title)
fields = {"course_id":course['_id'], "title":lesson_title}
lesson = self.newLesson.get_lesson(fields)
subscribed = self.newStudent_subscription.get_student_course_subscriptions(student_id, lesson['course_id'])
free_lessons = self.newLesson.get_free_lessons(lesson['course_id'])
if ((subscribed) or (lesson['_id'] in free_lessons)):
#course = self.newCourse.get_course_by_id(lesson['course_id'])
similar_courses = self.newCourse_interest.get_similar_courses(course['_id'])
instructor = self.newInstructor.get_instructor_by_id(course['instructor_id'])
courseLessons = self.newLesson.get_lesson_by_courseId(course['_id'])
lesson_questions = self.newStudent_question.get_lesson_questions(str(lesson['_id']))
if lesson_questions.count() > 0:
for quest in lesson_questions:
question = {}
question['student'] = self.newStudent.get_student_by_id(quest['student_id'])['name']
question['date_asked'] = str(quest['date_asked'])
question['quest'] = quest
question['responses'] = self.newQuestion_response.get_question_responses(str(quest['_id']))
data['lesson_questions'].append(question)
courseDuration = 0
n = 0
nxt = 0
prev = ''
for courseLesson in courseLessons:
n = n + 1;
if nxt == 1:
lesson['nxt'] = courseLesson['title']
nxt = 0
if courseLesson['title'] == lesson['title']:
lesson['prev'] = prev
nxt = 1
prev = courseLesson['title']
courseDuration = int(courseDuration) + int(courseLesson['duration'])
data['course_lessons'].append(courseLesson)
data['course'] = course
data['lesson'] = lesson
data['instructor'] = instructor
data['course_duration'] = courseDuration
data['similar_courses'] = similar_courses
#return jsonify(len(similar_courses))
return render_template("course_lesson.html", data=data)
else:
return redirect(url_for('dashboard'))
def purchase_course(self, courseId):
#session['test'] = 'this'
data = {}
data['loggedIn'] = False
data['course_lessons'] = []
#session['reverse_cart'] = []
if 'cart' in session:
data['cart'] = session['cart']
else:
data['cart'] = []
if 'reverse_cart' in session:
data['reverse_cart'] = session['reverse_cart']
if 'cart_total' in session:
data['sub_total'] = session['cart_total']
else:
data['sub_total'] = 0
data['loggedIn'] = True
data['student'] = session['student']
course = self.newCourse.get_course_by_id(ObjectId(courseId))
#return jsonify(title)
instructor = self.newInstructor.get_instructor_by_id(course['instructor_id'])
courseLessons = self.newLesson.get_lesson_by_courseId(course['_id'])
courseDuration = 0
for lesson in courseLessons:
courseDuration = int(courseDuration) + int(lesson['duration'])
data['course_lessons'].append(lesson)
#cart = session['cart']
#count = len(cart)
#while count > 0:
# session['reverse_cart'].append(cart.pop())
# session.modified = True
# count = count - 1
data['course'] = course
data['instructor'] = instructor
data['course_duration'] = courseDuration
return render_template("purchase_course.html", data=data)
def ask_question(self):
form = QuestionForm()
student_id = ObjectId(session['student']['id'])
if form.validate() == False:
errors = ''
if form.question.errors:
for error in form.question.errors:
errors += ' '+error
return json.dumps({'status':'ERROR','message':errors});
else:
question = request.form['question']
lesson_id = request.form['lesson_id']
course_id = request.form['course_id']
result = self.newStudent_question.add(lesson_id, course_id, student_id, question)
if(result == 'OK'):
return json.dumps({'status':'OK'});
if(result == 'ERROR'):
return json.dumps({'status':'ERROR'});
def course_questions(self):
return render_template("course_questions.html")
class CourseController():
def __init__(self):
if 'instructor' in session:
self.loggedIn = True
else:
return redirect(url_for('instructor_login'))
self.newStudent_interest = Student_interest()
self.newCourse_interest = Course_interest()
self.newInterest = Interest()
self.newCourse = Course()
self.newStudent_subscription = Student_subscription()
self.newStudent = Student()
self.newInstructor = Instructor()
self.newLesson = Lesson()
self.newStudent_question = Student_question()
self.newQuestion_response = Question_response()
self.uploadFolder = 'static/images/courses_cover_photos'
self.allowedExtensions = set(['png', 'jpg', 'jpeg', 'gif', 'psd'])
def course_data(self, course_id):
data = {}
data['course_lessons'] = []
data['similar_courses'] = []
data['loggedIn'] = True
data['courses'] = []
data['instructor'] = self.newInstructor.get_instructor_by_name(session['instructor']['name'])
fields = {"instructor_id":data['instructor']['_id']}
courses = self.newCourse.get_courses(fields)
if courses:
for course in courses:
course_subscription = self.newStudent_subscription.get_course_subscriptions(course['_id'])
course['subscribed'] = course_subscription.count()
questions = self.newStudent_question.get_course_questions(str(course['_id']))
course['questions'] = questions.count()
data['courses'].append(course)
course = self.newCourse.get_course_by_id(ObjectId(course_id))
data['course'] = course
if course:
similar_courses = self.newCourse_interest.get_similar_courses(course['_id'])
instructor = self.newInstructor.get_instructor_by_id(course['instructor_id'])
courseLessons = self.newLesson.get_lesson_by_courseId(course['_id'])
courseDuration = 0
for lesson in courseLessons:
courseDuration = int(courseDuration) + int(lesson['duration'])
data['course_lessons'].append(lesson)
thisCourse = '';
data['instructor'] = instructor
data['course_duration'] = courseDuration
data['similar_courses'] = similar_courses
return data
def course(self, course_id):
if self.loggedIn != True:
return redirect(url_for('instructor_login'))
data = self.course_data(course_id)
data['new_course_form'] = CourseForm()
data['new_course_form'].instructor_id.data = data['instructor']['_id']
data['new_lesson_form'] = LessonForm()
data['new_lesson_form'].course_id.data = course_id
#return jsonify(len(similar_courses))
if data['course']:
return render_template("instructor/course.html", data=data)
else:
return redirect(url_for('index'))
def create(self):
form = CourseForm()
if request.method == 'POST':
instructor_id = form.instructor_id.data
instructor_id = ObjectId(instructor_id)
if form.validate() == False:
return redirect(url_for('new_course'))
else:
if 'cover_photo' not in request.files:
flash('No Cover Photo')
return redirect(url_for('new_course'))
photo = request.files['cover_photo']
if photo.filename == '':
flash('No Photo Selected')
return redirect(url_for('new_course'))
if photo and self.allowed_file(photo.filename):
filename = secure_filename(photo.filename)
photo.save(os.path.join(self.uploadFolder, filename))
id = self.newCourse.add(form.title.data, filename, form.description.data, instructor_id)
return redirect(url_for('instructor_courses'))
return redirect(url_for('instructor_dashboard'))
def edit(self, course_id):
form = EditCourseForm()
data = {}
course = self.newCourse.get_course_by_id(ObjectId(course_id))
data['edit_course_form'] = form
data['edit_course_form'].course_id.data = course_id
data['edit_course_form'].title.data = course['title']
data['edit_course_form'].cover_photo.data = course['cover_photo']
data['edit_course_form'].description.data = course['description']
data['course'] = course
data['instructor'] = self.newInstructor.get_instructor_by_name(session['instructor']['name'])
return render_template('instructor/edit_course.html', data=data)
def update(self):
form = EditCourseForm()
data = {}
if request.method == 'POST':
courseid = form.course_id.data
course_id = ObjectId(courseid)
course = self.newCourse.get_course_by_id(course_id)
if form.validate() == True:
if 'cover_photo' not in request.files:
flash('No Cover Photo')
return redirect(url_for('instructor_edit_course', courseId=course_id))
photo = request.files['cover_photo']
if photo.filename == '':
filename = ''
if photo and self.allowed_file(photo.filename):
filename = secure_filename(photo.filename)
#Add new photo
photo.save(os.path.join(self.uploadFolder, filename))
#Remove old photo
if os.path.isfile(self.uploadFolder+course['cover_photo']):
os.remove(os.path.join(self.uploadFolder, course['cover_photo']))
result = self.newCourse.update(course_id, form.title.data, filename, form.description.data)
if result == 'OK':
flash('1')
else:
flash('0')
#return jsonify(str(result))
return redirect(url_for('instructor_edit_course', courseId=course_id))
else:
return redirect(url_for('instructor_edit_course', courseId=course_id))
return redirect(url_for('instructor_dashboard'))
def lesson(self, lesson_id):
data = {}
data['QForm'] = QuestionForm()
data['course_lessons'] = []
data['lesson_questions'] = []
lesson = self.newLesson.get_lesson_by_id(ObjectId(lesson_id))
course = self.newCourse.get_course_by_id(lesson['course_id'])
if (lesson):
#course = self.newCourse.get_course_by_id(lesson['course_id'])
similar_courses = self.newCourse_interest.get_similar_courses(course['_id'])
instructor = self.newInstructor.get_instructor_by_id(course['instructor_id'])
courseLessons = self.newLesson.get_lesson_by_courseId(course['_id'])
lesson_questions = self.newStudent_question.get_lesson_questions(str(lesson['_id']))
if lesson_questions.count() > 0:
for quest in lesson_questions:
question = {}
question['student'] = self.newStudent.get_student_by_id(quest['student_id'])['name']
question['date_asked'] = str(quest['date_asked'])
question['quest'] = quest
question['responses'] = self.newQuestion_response.get_question_responses(str(quest['_id']))
data['lesson_questions'].append(question)
courseDuration = 0
n = 0
nxt = 0
prev = ''
for courseLesson in courseLessons:
n = n + 1;
if nxt == 1:
lesson['nxt'] = courseLesson['title']
nxt = 0
if courseLesson['title'] == lesson['title']:
lesson['prev'] = prev
nxt = 1
prev = courseLesson['title']
courseDuration = int(courseDuration) + int(courseLesson['duration'])
data['course_lessons'].append(courseLesson)
data['course'] = course
data['lesson'] = lesson
data['instructor'] = instructor
data['course_duration'] = courseDuration
data['similar_courses'] = similar_courses
#return jsonify(len(similar_courses))
return render_template("instructor/lesson.html", data=data)
else:
return redirect(url_for('instructor_dashboard'))
def new_lesson(self):
form = LessonForm()
if request.method == 'POST':
course_id = form.course_id.data
course_id = ObjectId(course_id)
if form.validate() == False:
data = self.course_data(course_id)
data['new_lesson_form'] = form
data['new'] = 1
return render_template('instructor/course.html', data=data)
else:
#return jsonify(course_id)
#course_id = '5a5e2612a8af96b319f84dce'
#data = self.course_data(str(course_id))
#duration = request.form['duration']
id = self.newLesson.add(form.title.data, form.video_url.data, form.description.data, form.duration.data, course_id)
return redirect(url_for('instructor_course', courseId=course_id))
return redirect(url_for('instructor_dashboard'))
def edit_lesson(self, lesson_id):
form = LessonForm()
data = {}
lesson = self.newLesson.get_lesson_by_id(ObjectId(lesson_id))
course = self.newCourse.get_course_by_id(lesson['course_id'])
data['edit_lesson_form'] = form
data['edit_lesson_form'].lesson_id.data = lesson_id
data['edit_lesson_form'].title.data = lesson['title']
data['edit_lesson_form'].video_url.data = lesson['video_url']
data['edit_lesson_form'].description.data = lesson['description']
data['edit_lesson_form'].duration.data = lesson['duration']
data['lesson'] = lesson
data['course'] = course
data['instructor'] = self.newInstructor.get_instructor_by_name(session['instructor']['name'])
return render_template('instructor/edit_lesson.html', data=data)
def update_lesson(self):
form = LessonForm()
data = {}
if request.method == 'POST':
lesson_id = form.lesson_id.data
lesson_id = ObjectId(lesson_id)
lesson = self.newLesson.get_lesson_by_id(lesson_id)
if form.validate() == True:
result = self.newLesson.update(lesson_id, form.title.data, form.video_url.data, form.description.data, form.duration.data)
if result == 'OK':
flash('1')
else:
flash('0')
#return jsonify(str(result))
return redirect(url_for('instructor_edit_lesson', lessonId=lesson_id))
else:
return redirect(url_for('instructor_edit_lesson', lessonId=lesson_id))
return redirect(url_for('instructor_dashboard'))
def course_questions(self, title):
data = {}
data['questions'] = []
course = self.newCourse.get_course_by_title(title)
questions = self.newStudent_question.get_course_questions(str(course['_id']))
if questions:
for question in questions:
question['student'] = self.newStudent.get_student_by_id(question['student_id'])
question['lesson'] = self.newLesson.get_lesson_by_id(ObjectId(question['lesson_id']))
data['questions'].append(question)
data['course'] = course
return render_template("instructor/course_questions.html", data=data)
return redirect(url_for('instructor_dashboard'))
def allowed_file(self, filename):
return '.' in filename and \
filename.rsplit('.', 1)[1].lower() in self.allowedExtensions
