def main(request, course_prefix, course_suffix, slug): try: common_page_data = get_common_page_data(request, course_prefix, course_suffix) page = AdditionalPage.objects.get(course=common_page_data['course'], slug=slug) except: raise Http404 if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course = common_page_data['ready_course'], user = request.user, page_type = 'additional_page', object_id = str(page.id), ) visit_log.save() if common_page_data['is_course_admin'] and common_page_data['course_mode'] == 'draft' and common_page_data['view_mode'] == 'edit': template = 'additional_pages/edit.html' else: template = 'additional_pages/view.html' course = common_page_data['course'] contentsection_list = ContentSection.objects.getByCourse(course=course) video_list = Video.objects.getByCourse(course=course) pset_list = ProblemSet.objects.getByCourse(course=course) additional_pages = AdditionalPage.objects.getSectionPagesByCourse(course=course) file_list = File.objects.getByCourse(course=course) groups = ContentGroup.objects.getByCourse(course=course) level1_items, level2_items = group_data(groups) full_contentsection_list, full_index_list = get_full_contentsection_list(course, contentsection_list, video_list, pset_list, additional_pages, file_list, level2_items) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response(template, {'common_page_data': common_page_data, 'page': page, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in}, context_instance=RequestContext(request))
def main(request, course_prefix, course_suffix, slug): try: common_page_data = get_common_page_data(request, course_prefix, course_suffix) page = AdditionalPage.objects.get(course=common_page_data["course"], slug=slug) except: raise Http404 if not common_page_data["is_course_admin"]: visit_log = PageVisitLog( course=common_page_data["ready_course"], user=request.user, page_type="additional_page", object_id=str(page.id), ) visit_log.save() if ( common_page_data["is_course_admin"] and common_page_data["course_mode"] == "draft" and common_page_data["view_mode"] == "edit" ): template = "additional_pages/edit.html" else: template = "additional_pages/view.html" course = common_page_data["course"] full_contentsection_list, full_index_list = get_full_contentsection_list(course) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response( template, { "common_page_data": common_page_data, "page": page, "contentsection_list": full_contentsection_list, "full_index_list": full_index_list, "is_logged_in": is_logged_in, }, context_instance=RequestContext(request), )
def main(request, course_prefix, course_suffix, slug): try: common_page_data = get_common_page_data(request, course_prefix, course_suffix) page = AdditionalPage.objects.get(course=common_page_data['course'], slug=slug) except: raise Http404 if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course = common_page_data['ready_course'], user = request.user, page_type = 'additional_page', object_id = str(page.id), ) visit_log.save() if common_page_data['is_course_admin'] and common_page_data['course_mode'] == 'draft' and common_page_data['view_mode'] == 'edit': template = 'additional_pages/edit.html' else: template = 'additional_pages/view.html' course = common_page_data['course'] contentsection_list = ContentSection.objects.getByCourse(course=course) video_list = Video.objects.getByCourse(course=course) pset_list = ProblemSet.objects.getByCourse(course=course) additional_pages = AdditionalPage.objects.getSectionPagesByCourse(course=course) file_list = File.objects.getByCourse(course=course) full_contentsection_list, full_index_list = get_full_contentsection_list(course, contentsection_list, video_list, pset_list, additional_pages, file_list) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response(template, {'common_page_data': common_page_data, 'page': page, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in}, context_instance=RequestContext(request))
def show(request, course_prefix, course_suffix, pset_slug): common_page_data = request.common_page_data try: ps = ProblemSet.objects.getByCourse( course=common_page_data['course']).get(slug=pset_slug) except ProblemSet.DoesNotExist: messages.add_message( request, messages.ERROR, 'This Problemset is not visible in the student view at this time. Please note that students will not see this message.' ) return HttpResponseRedirect( reverse('problemsets.views.listAll', args=(course_prefix, course_suffix))) except ProblemSet.MultipleObjectsReturned: messages.add_message( request, messages.ERROR, 'We found multiple problem sets with the same slug. Please try to delete one. This most likely happened due to copying content from another course.' ) return HttpResponseRedirect( reverse('problemsets.views.listAll', args=(course_prefix, course_suffix))) if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course=common_page_data['ready_course'], user=request.user, page_type='problemset', object_id=str(ps.id), ) visit_log.save() activity_list = [] cursor = connection.cursor() #Used to test for valid data cursor.execute( "SELECT `c2g_problemset_to_exercise`.`problemSet_id`, `c2g_exercises`.`fileName`, c2g_problemset_to_exercise.number, \ min(case when c2g_problem_activity.complete = 1 then c2g_problem_activity.id else null end) as `first_correct_answer`, \ max(c2g_problem_activity.id) as `max_activity_id` \ FROM `c2g_problem_activity` \ LEFT OUTER JOIN `c2g_problemset_to_exercise` ON (`c2g_problem_activity`.`problemset_to_exercise_id` = `c2g_problemset_to_exercise`.`id`) \ INNER JOIN `c2g_problem_sets` ON (`c2g_problemset_to_exercise`.`problemSet_id` = `c2g_problem_sets`.`id`) \ INNER JOIN `c2g_exercises` ON (`c2g_problemset_to_exercise`.`exercise_id` = `c2g_exercises`.`id`) \ WHERE (`c2g_problemset_to_exercise`.`problemSet_id` = %s \ AND `c2g_problem_activity`.`student_id` = %s ) \ GROUP BY `c2g_problemset_to_exercise`.`problemSet_id`, `c2g_exercises`.`fileName`, c2g_problemset_to_exercise.number \ ORDER BY c2g_problemset_to_exercise.number", [ps.id, request.user.id]) raw_activity_list = [] for row in cursor.fetchall(): problemset_id = row[0] filename = row[1] number = row[2] first_correct_answer = row[3] max_activity_id = row[4] raw_activity_item = { 'problemset_id': problemset_id, 'filename': filename, 'number': number, 'first_correct_answer': first_correct_answer, 'max_activity_id': max_activity_id } raw_activity_list.append(raw_activity_item) #Find deleted files cursor.execute( "select e.fileName, p2e.problemSet_id, \ count(case when p2e.is_deleted = 0 then 1 else null end) as `num_active` \ from c2g_problemset_to_exercise p2e, c2g_exercises e \ where p2e.exercise_id = e.id \ and p2e.problemSet_id = %s \ and p2e.mode = 'ready' \ group by e.filename, p2e.problemSet_id \ having num_active = 0", [ps.id]) deleted_exercise_list = [] for row in cursor.fetchall(): filename = row[0] problemset_id = row[1] filename_item = {'filename': filename, 'problemset_id': problemset_id} deleted_exercise_list.append(filename_item) for raw_activity_item in raw_activity_list: problemset_id = raw_activity_item['problemset_id'] filename = raw_activity_item['filename'] number = raw_activity_item['number'] first_correct_answer = raw_activity_item['first_correct_answer'] max_activity_id = raw_activity_item['max_activity_id'] if not filename_in_deleted_list(filename, problemset_id, deleted_exercise_list): if first_correct_answer == None or first_correct_answer == max_activity_id: activity_item = ProblemActivity.objects.get(id=max_activity_id) else: activity_item = ProblemActivity.objects.get( id=first_correct_answer) activity_list.append((activity_item, number)) course = common_page_data['course'] full_contentsection_list, full_index_list = get_full_contentsection_list( course) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response('problemsets/problemset.html', { 'common_page_data': common_page_data, 'pset': ps, 'pset_url': ps.path, 'pset_type': ps.assessment_type, 'pset_penalty': ps.resubmission_penalty, 'pset_attempts_allowed': ps.submissions_permitted, 'activity_list': activity_list, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in }, context_instance=RequestContext(request))
def view(request, course_prefix, course_suffix, slug): common_page_data = request.common_page_data try: #getByCourse takes care of checking for draft vs live, is_deleted and live times video = Video.objects.getByCourse(course=common_page_data['course']).get(slug=slug) except Video.DoesNotExist: raise Http404 if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course = common_page_data['ready_course'], user = request.user, page_type= 'video', object_id = str(video.id), ) visit_log.save() if not 'video_quiz_mode' in request.session: #Default to include quizzes in viewing videos request.session['video_quiz_mode'] = "quizzes included" videos = Video.objects.getByCourse(course=common_page_data['course']) #Get index of current video cur_index = None #just code safety for index, item in enumerate(videos): if item == video: cur_index = index break #code safety next_slug = None prev_slug = None if cur_index is not None: if cur_index > 0: prev_slug = videos[cur_index-1].slug else: prev_slug = None if cur_index < videos.count() - 1: next_slug = videos[cur_index+1].slug else: next_slug = None video_rec = request.user.videoactivity_set.filter(video=video) if video_rec: video_rec = video_rec[0] else: #note student field to be renamed to user, VideoActivity for all users now video_rec = VideoActivity(student=request.user, course=common_page_data['course'], video=video) video_rec.save() has_ex = VideoToExercise.objects.filter(is_deleted=False, video=video).exists() no_ex = 1 if (not has_ex) or request.session['video_quiz_mode'] != "quizzes included" else 0 course = common_page_data['course'] contentsection_list = ContentSection.objects.getByCourse(course=course) video_list = videos #Video.objects.getByCourse(course=course) pset_list = ProblemSet.objects.getByCourse(course=course) additional_pages = AdditionalPage.objects.getSectionPagesByCourse(course=course) file_list = File.objects.getByCourse(course=course) full_contentsection_list, full_index_list = get_full_contentsection_list(course, contentsection_list, video_list, pset_list, additional_pages, file_list) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response('videos/view.html', {'common_page_data': common_page_data, 'video': video, 'video_rec':video_rec, 'prev_slug': prev_slug, 'next_slug': next_slug, 'no_ex': no_ex, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in}, context_instance=RequestContext(request))
def view(request, course_prefix, course_suffix, slug): common_page_data = request.common_page_data try: #getByCourse takes care of checking for draft vs live, is_deleted and live times video = Video.objects.getByCourse(course=common_page_data['course']).get(slug=slug) except Video.DoesNotExist: raise Http404 if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course = common_page_data['ready_course'], user = request.user, page_type= 'video', object_id = str(video.id), ) visit_log.save() if not 'video_quiz_mode' in request.session: #Default to include quizzes in viewing videos request.session['video_quiz_mode'] = "quizzes included" videos = Video.objects.getByCourse(course=common_page_data['course']) #Get index of current video cur_index = None #just code safety for index, item in enumerate(videos): if item == video: cur_index = index break #code safety next_slug = None prev_slug = None if cur_index is not None: if cur_index > 0: prev_slug = videos[cur_index-1].slug else: prev_slug = None if cur_index < videos.count() - 1: next_slug = videos[cur_index+1].slug else: next_slug = None video_rec = request.user.videoactivity_set.filter(video=video) if video_rec: video_rec = video_rec[0] else: #note student field to be renamed to user, VideoActivity for all users now video_rec = VideoActivity(student=request.user, course=common_page_data['course'], video=video) video_rec.save() course = common_page_data['course'] full_contentsection_list, full_index_list = get_full_contentsection_list(course, filter_children=True) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 key = ('video', video.id) l1items, l2items = get_contentgroup_data(course=course) downloadable_content = get_children(key, l1items, l2items) if video.exam: try: #exam = Exam.objects.get(course=course, is_deleted=0, slug=exam_slug) exam = video.exam display_single = exam.display_single invideo = exam.invideo metadata_dom = parseString(exam.xml_metadata) #The DOM corresponding to the XML metadata video_questions = metadata_dom.getElementsByTagName('video') question_times = {} for video_node in video_questions: video_slug = video_node.getAttribute("url-identifier") if video_slug == "": video_slug = video_node.getAttribute("url_identifier") if video_slug == video.slug: question_children = video_node.getElementsByTagName("question") times = [] for question in question_children: time = "sec_%s" % question.getAttribute("time") if time not in question_times: question_times[time] = [] question_times[time].append(question.getAttribute("id")) print json.dumps(question_times) except Exam.DoesNotExist: raise Http404 else: sections = ContentSection.objects.getByCourse(course) section = sections[0] # create fake exam as exam template (which is what displays all videos) needs exam data to function # correctly (TODO: Refactor this) exam = Exam(course=course, slug=slug, title=video.title, description="Empty Exam", html_content="", xml_metadata="", due_date='', assessment_type="survey", mode="draft", total_score=0, grade_single=0, grace_period='', partial_credit_deadline='', late_penalty=0, submissions_permitted=0, resubmission_penalty=0, exam_type="survey", autograde=0, display_single=0, invideo=1, section=section,) exam.live_datetime = video.live_datetime # needed so video shows up question_times = "" videoURL = None thumbnailPath = None if is_storage_local(): videoURL = local_file_server_root() + "/" + str(video.file) thumbnailPath = local_file_server_root() + "/" + course.prefix + "/" + course.suffix + "/videos/" + str(video.id if video.mode == 'draft' else video.image.id) + "/jpegs/" elif video.url: videoURL = "http://www.youtube.com/embed/" + (video.url if video.mode == 'draft' else video.image.url) + "?autoplay=0&wmode=transparent&fs=0&rel=0&modestbranding=1&showinfo=0&start=0&enablejsapi=1&disablekb=1&" thumbnailPath = "http://" + settings.AWS_STORAGE_BUCKET_NAME + ".s3-website-us-west-2.amazonaws.com/" + course.prefix + "/" + course.suffix + "/videos/" + str(video.id if video.mode == 'draft' else video.image.id) + "/jpegs/" # change from 'videos/view.html' to 'exams/view_exam.html' return render_to_response('exams/view_exam.html', { 'common_page_data': common_page_data, 'video': video, 'video_rec': video_rec, 'videoURL': videoURL, 'thumbnailPath': thumbnailPath, 'prev_slug': prev_slug, 'next_slug': next_slug, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in, 'downloadable_content':downloadable_content, 'json_pre_pop':"{}", 'scores':"{}", 'editable':True, 'single_question':exam.display_single, 'videotest':exam.invideo, 'question_times':json.dumps(question_times), 'allow_submit':True, 'children': downloadable_content, 'exam':exam }, context_instance=RequestContext(request))
def show(request, course_prefix, course_suffix, pset_slug): def filename_in_deleted_list(filename, problem_set_id, deleted_exercise_list): """Used by course_materials templates for filtering""" for item in deleted_exercise_list: if item['filename'] == filename and item['problemset_id'] == problem_set_id: return True return False common_page_data = request.common_page_data try: ps = ProblemSet.objects.getByCourse(course=common_page_data['course']).get(slug=pset_slug) except ProblemSet.DoesNotExist: messages.add_message(request,messages.ERROR, 'This Problemset is not visible in the student view at this time. Please note that students will not see this message.') return HttpResponseRedirect(reverse('problemsets.views.listAll', args=(course_prefix, course_suffix))) except ProblemSet.MultipleObjectsReturned: messages.add_message(request,messages.ERROR, 'We found multiple problem sets with the same slug. Please try to delete one. This most likely happened due to copying content from another course.') return HttpResponseRedirect(reverse('problemsets.views.listAll', args=(course_prefix, course_suffix))) if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course = common_page_data['ready_course'], user = request.user, page_type = 'problemset', object_id = str(ps.id), ) visit_log.save() activity_list = [] cursor = connection.cursor() #Used to test for valid data cursor.execute("SELECT `c2g_problemset_to_exercise`.`problemSet_id`, `c2g_exercises`.`fileName`, c2g_problemset_to_exercise.number, \ min(case when c2g_problem_activity.complete = 1 then c2g_problem_activity.id else null end) as `first_correct_answer`, \ max(c2g_problem_activity.id) as `max_activity_id` \ FROM `c2g_problem_activity` \ LEFT OUTER JOIN `c2g_problemset_to_exercise` ON (`c2g_problem_activity`.`problemset_to_exercise_id` = `c2g_problemset_to_exercise`.`id`) \ INNER JOIN `c2g_problem_sets` ON (`c2g_problemset_to_exercise`.`problemSet_id` = `c2g_problem_sets`.`id`) \ INNER JOIN `c2g_exercises` ON (`c2g_problemset_to_exercise`.`exercise_id` = `c2g_exercises`.`id`) \ WHERE (`c2g_problemset_to_exercise`.`problemSet_id` = %s \ AND `c2g_problem_activity`.`student_id` = %s ) \ GROUP BY `c2g_problemset_to_exercise`.`problemSet_id`, `c2g_exercises`.`fileName`, c2g_problemset_to_exercise.number \ ORDER BY c2g_problemset_to_exercise.number", [ps.id, request.user.id]) raw_activity_list = [] for row in cursor.fetchall(): problemset_id = row[0] filename = row[1] number = row[2] first_correct_answer = row[3] max_activity_id = row[4] raw_activity_item = {'problemset_id' : problemset_id, 'filename' : filename, 'number' : number, 'first_correct_answer' : first_correct_answer, 'max_activity_id' : max_activity_id } raw_activity_list.append(raw_activity_item) #Find deleted files cursor.execute("select e.fileName, p2e.problemSet_id, \ count(case when p2e.is_deleted = 0 then 1 else null end) as `num_active` \ from c2g_problemset_to_exercise p2e, c2g_exercises e \ where p2e.exercise_id = e.id \ and p2e.problemSet_id = %s \ and p2e.mode = 'ready' \ group by e.filename, p2e.problemSet_id \ having num_active = 0", [ps.id]) deleted_exercise_list = [] for row in cursor.fetchall(): filename = row[0] problemset_id = row[1] filename_item = {'filename' : filename, 'problemset_id' : problemset_id } deleted_exercise_list.append(filename_item) for raw_activity_item in raw_activity_list: problemset_id = raw_activity_item['problemset_id'] filename = raw_activity_item['filename'] number = raw_activity_item['number'] first_correct_answer = raw_activity_item['first_correct_answer'] max_activity_id = raw_activity_item['max_activity_id'] if not filename_in_deleted_list( filename, problemset_id, deleted_exercise_list): if first_correct_answer == None or first_correct_answer == max_activity_id: activity_item = ProblemActivity.objects.get(id=max_activity_id) else: activity_item = ProblemActivity.objects.get(id=first_correct_answer) activity_list.append((activity_item, number)) course = common_page_data['course'] full_contentsection_list, full_index_list = get_full_contentsection_list(course) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response('problemsets/problemset.html', {'common_page_data':common_page_data, 'pset': ps, 'pset_url':ps.path, 'pset_type':ps.assessment_type, 'pset_penalty':ps.resubmission_penalty, 'pset_attempts_allowed':ps.submissions_permitted, 'activity_list': activity_list, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in }, context_instance=RequestContext(request))
def view(request, course_prefix, course_suffix, slug): common_page_data = request.common_page_data try: # getByCourse takes care of checking for draft vs live, is_deleted and live times video = Video.objects.getByCourse(course=common_page_data["course"]).get(slug=slug) except Video.DoesNotExist: raise Http404 if not common_page_data["is_course_admin"]: visit_log = PageVisitLog( course=common_page_data["ready_course"], user=request.user, page_type="video", object_id=str(video.id) ) visit_log.save() if not "video_quiz_mode" in request.session: # Default to include quizzes in viewing videos request.session["video_quiz_mode"] = "quizzes included" videos = Video.objects.getByCourse(course=common_page_data["course"]) # Get index of current video cur_index = None # just code safety for index, item in enumerate(videos): if item == video: cur_index = index break # code safety next_slug = None prev_slug = None if cur_index is not None: if cur_index > 0: prev_slug = videos[cur_index - 1].slug else: prev_slug = None if cur_index < videos.count() - 1: next_slug = videos[cur_index + 1].slug else: next_slug = None video_rec = request.user.videoactivity_set.filter(video=video) if video_rec: video_rec = video_rec[0] else: # note student field to be renamed to user, VideoActivity for all users now video_rec = VideoActivity(student=request.user, course=common_page_data["course"], video=video) video_rec.save() course = common_page_data["course"] full_contentsection_list, full_index_list = get_full_contentsection_list(course, filter_children=True) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 key = ("video", video.id) l1items, l2items = get_contentgroup_data(course=course) downloadable_content = get_children(key, l1items, l2items) if video.exam: try: # exam = Exam.objects.get(course=course, is_deleted=0, slug=exam_slug) exam = video.exam display_single = exam.display_single invideo = exam.invideo metadata_dom = parseString(exam.xml_metadata) # The DOM corresponding to the XML metadata video_questions = metadata_dom.getElementsByTagName("video") question_times = {} for video_node in video_questions: video_slug = video_node.getAttribute("url-identifier") if video_slug == "": video_slug = video_node.getAttribute("url_identifier") if video_slug == video.slug: question_children = video_node.getElementsByTagName("question") times = [] for question in question_children: time = "sec_%s" % question.getAttribute("time") if time not in question_times: question_times[time] = [] question_times[time].append(question.getAttribute("id")) print json.dumps(question_times) except Exam.DoesNotExist: raise Http404 else: sections = ContentSection.objects.getByCourse(course) section = sections[0] # create fake exam as exam template (which is what displays all videos) needs exam data to function # correctly (TODO: Refactor this) exam = Exam( course=course, slug=slug, title=video.title, description="Empty Exam", html_content="", xml_metadata="", due_date="", assessment_type="survey", mode="draft", total_score=0, grade_single=0, grace_period="", partial_credit_deadline="", late_penalty=0, submissions_permitted=0, resubmission_penalty=0, exam_type="survey", autograde=0, display_single=0, invideo=1, section=section, ) exam.live_datetime = video.live_datetime # needed so video shows up question_times = "" # change from 'videos/view.html' to 'exams/view_exam.html' return render_to_response( "exams/view_exam.html", { "common_page_data": common_page_data, "video": video, "video_rec": video_rec, "prev_slug": prev_slug, "next_slug": next_slug, "contentsection_list": full_contentsection_list, "full_index_list": full_index_list, "is_logged_in": is_logged_in, "downloadable_content": downloadable_content, "json_pre_pop": "{}", "scores": "{}", "editable": True, "single_question": exam.display_single, "videotest": exam.invideo, "question_times": json.dumps(question_times), "allow_submit": True, "children": downloadable_content, "exam": exam, }, context_instance=RequestContext(request), )
def main(request, course_prefix, course_suffix, slug): try: common_page_data = get_common_page_data(request, course_prefix, course_suffix) page = AdditionalPage.objects.get(course=common_page_data["course"], slug=slug) except: raise Http404 if not common_page_data["is_course_admin"]: visit_log = PageVisitLog( course=common_page_data["ready_course"], user=request.user, page_type="additional_page", object_id=str(page.id), ) visit_log.save() contentgroup_info = None # Empty for view mode sections = ContentSection.objects.getByCourse(course=common_page_data["course"]) if common_page_data["is_course_admin"] and common_page_data["course_mode"] == "draft": template = "additional_pages/edit.html" groupable_page = page if page.mode != "ready": groupable_page = page.image contentgroup_info = ContentGroup.groupinfo_by_id("additional_page", groupable_page.id) # Oh, so it turns out you can't dereference variables starting with _ # from Django templates if contentgroup_info: contentgroup_info["PARENT"] = contentgroup_info["__parent"] contentgroup_info["PARENT_TAG"] = contentgroup_info["__parent_tag"] else: template = "additional_pages/view.html" course = common_page_data["course"] course_instructors = CourseInstructor.objects.getByCourse(course=common_page_data["course"]) instructor_list = [] for ci in course_instructors: instructor_list.append(ci.instructor) full_contentsection_list, full_index_list = get_full_contentsection_list(course) try: video = Video.objects.getByCourse(course=common_page_data["course"]).get(slug="intro") except Video.DoesNotExist: video = None if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 ready_section = page.section if ready_section and ready_section.mode == "draft": ready_section = ready_section.image return render_to_response( template, { "common_page_data": common_page_data, "page": page, "contentsection_list": full_contentsection_list, "full_index_list": full_index_list, "instructor_list": instructor_list, "course": course, "is_logged_in": is_logged_in, "intro_video": video, "ready_section": ready_section, "contentgroup_info": contentgroup_info, "sections": sections, }, context_instance=RequestContext(request), )
def view(request, course_prefix, course_suffix, slug): common_page_data = request.common_page_data try: #getByCourse takes care of checking for draft vs live, is_deleted and live times video = Video.objects.getByCourse( course=common_page_data['course']).get(slug=slug) except Video.DoesNotExist: raise Http404 if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course=common_page_data['ready_course'], user=request.user, page_type='video', object_id=str(video.id), ) visit_log.save() if not 'video_quiz_mode' in request.session: #Default to include quizzes in viewing videos request.session['video_quiz_mode'] = "quizzes included" videos = Video.objects.getByCourse(course=common_page_data['course']) #Get index of current video cur_index = None #just code safety for index, item in enumerate(videos): if item == video: cur_index = index break #code safety next_slug = None prev_slug = None if cur_index is not None: if cur_index > 0: prev_slug = videos[cur_index - 1].slug else: prev_slug = None if cur_index < videos.count() - 1: next_slug = videos[cur_index + 1].slug else: next_slug = None video_rec = request.user.videoactivity_set.filter(video=video) if video_rec: video_rec = video_rec[0] else: #note student field to be renamed to user, VideoActivity for all users now video_rec = VideoActivity(student=request.user, course=common_page_data['course'], video=video) video_rec.save() has_ex = VideoToExercise.objects.filter(is_deleted=False, video=video).exists() no_ex = 1 if ( not has_ex ) or request.session['video_quiz_mode'] != "quizzes included" else 0 course = common_page_data['course'] contentsection_list = ContentSection.objects.getByCourse(course=course) video_list = videos #Video.objects.getByCourse(course=course) pset_list = ProblemSet.objects.getByCourse(course=course) additional_pages = AdditionalPage.objects.getSectionPagesByCourse( course=course) file_list = File.objects.getByCourse(course=course) full_contentsection_list, full_index_list = get_full_contentsection_list( course, contentsection_list, video_list, pset_list, additional_pages, file_list) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response('videos/view.html', { 'common_page_data': common_page_data, 'video': video, 'video_rec': video_rec, 'prev_slug': prev_slug, 'next_slug': next_slug, 'no_ex': no_ex, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in }, context_instance=RequestContext(request))
def view(request, course_prefix, course_suffix, slug): common_page_data = request.common_page_data try: #getByCourse takes care of checking for draft vs live, is_deleted and live times video = Video.objects.getByCourse( course=common_page_data['course']).get(slug=slug) except Video.DoesNotExist: raise Http404 if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course=common_page_data['ready_course'], user=request.user, page_type='video', object_id=str(video.id), ) visit_log.save() if not 'video_quiz_mode' in request.session: #Default to include quizzes in viewing videos request.session['video_quiz_mode'] = "quizzes included" videos = Video.objects.getByCourse(course=common_page_data['course']) #Get index of current video cur_index = None #just code safety for index, item in enumerate(videos): if item == video: cur_index = index break #code safety next_slug = None prev_slug = None if cur_index is not None: if cur_index > 0: prev_slug = videos[cur_index - 1].slug else: prev_slug = None if cur_index < videos.count() - 1: next_slug = videos[cur_index + 1].slug else: next_slug = None video_rec = request.user.videoactivity_set.filter(video=video) if video_rec: video_rec = video_rec[0] else: #note student field to be renamed to user, VideoActivity for all users now video_rec = VideoActivity(student=request.user, course=common_page_data['course'], video=video) video_rec.save() course = common_page_data['course'] full_contentsection_list, full_index_list = get_full_contentsection_list( course, filter_children=True) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 key = ('video', video.id) l1items, l2items = get_contentgroup_data(course=course) downloadable_content = get_children(key, l1items, l2items) if video.exam: try: #exam = Exam.objects.get(course=course, is_deleted=0, slug=exam_slug) exam = video.exam display_single = exam.display_single invideo = exam.invideo metadata_dom = parseString( exam.xml_metadata) #The DOM corresponding to the XML metadata video_questions = metadata_dom.getElementsByTagName('video') question_times = {} for video_node in video_questions: video_slug = video_node.getAttribute("url-identifier") if video_slug == "": video_slug = video_node.getAttribute("url_identifier") if video_slug == video.slug: question_children = video_node.getElementsByTagName( "question") times = [] for question in question_children: time = "sec_%s" % question.getAttribute("time") if time not in question_times: question_times[time] = [] question_times[time].append( question.getAttribute("id")) print json.dumps(question_times) except Exam.DoesNotExist: raise Http404 else: sections = ContentSection.objects.getByCourse(course) section = sections[0] # create fake exam as exam template (which is what displays all videos) needs exam data to function # correctly (TODO: Refactor this) exam = Exam( course=course, slug=slug, title=video.title, description="Empty Exam", html_content="", xml_metadata="", due_date='', assessment_type="survey", mode="draft", total_score=0, grade_single=0, grace_period='', partial_credit_deadline='', late_penalty=0, submissions_permitted=0, resubmission_penalty=0, exam_type="survey", autograde=0, display_single=0, invideo=1, section=section, ) exam.live_datetime = video.live_datetime # needed so video shows up question_times = "" videoURL = None thumbnailPath = None if is_storage_local(): videoURL = local_file_server_root() + "/" + str(video.file) thumbnailPath = local_file_server_root( ) + "/" + course.prefix + "/" + course.suffix + "/videos/" + str( video.id if video.mode == 'draft' else video.image.id) + "/jpegs/" elif video.url: videoURL = "http://www.youtube.com/embed/" + ( video.url if video.mode == 'draft' else video.image.url ) + "?autoplay=0&wmode=transparent&fs=0&rel=0&modestbranding=1&showinfo=0&start=0&enablejsapi=1&disablekb=1&" thumbnailPath = "http://" + settings.AWS_STORAGE_BUCKET_NAME + ".s3-website-us-west-2.amazonaws.com/" + course.prefix + "/" + course.suffix + "/videos/" + str( video.id if video.mode == 'draft' else video.image.id) + "/jpegs/" # change from 'videos/view.html' to 'exams/view_exam.html' return render_to_response('exams/view_exam.html', { 'common_page_data': common_page_data, 'video': video, 'video_rec': video_rec, 'videoURL': videoURL, 'thumbnailPath': thumbnailPath, 'prev_slug': prev_slug, 'next_slug': next_slug, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'is_logged_in': is_logged_in, 'downloadable_content': downloadable_content, 'json_pre_pop': "{}", 'scores': "{}", 'editable': True, 'single_question': exam.display_single, 'videotest': exam.invideo, 'question_times': json.dumps(question_times), 'allow_submit': True, 'children': downloadable_content, 'exam': exam }, context_instance=RequestContext(request))
def main(request, course_prefix, course_suffix, slug): try: common_page_data = get_common_page_data(request, course_prefix, course_suffix) page = AdditionalPage.objects.get(course=common_page_data['course'], slug=slug) except: raise Http404 if not common_page_data['is_course_admin']: visit_log = PageVisitLog( course=common_page_data['ready_course'], user=request.user, page_type='additional_page', object_id=str(page.id), ) visit_log.save() contentgroup_info = None # Empty for view mode sections = ContentSection.objects.getByCourse( course=common_page_data['course']) if common_page_data['is_course_admin'] and common_page_data[ 'course_mode'] == 'draft': template = 'additional_pages/edit.html' groupable_page = page if page.mode != 'ready': groupable_page = page.image contentgroup_info = ContentGroup.groupinfo_by_id( 'additional_page', groupable_page.id) # Oh, so it turns out you can't dereference variables starting with _ # from Django templates if contentgroup_info: contentgroup_info['PARENT'] = contentgroup_info['__parent'] contentgroup_info['PARENT_TAG'] = contentgroup_info['__parent_tag'] else: template = 'additional_pages/view.html' course = common_page_data['course'] course_instructors = CourseInstructor.objects.getByCourse( course=common_page_data['course']) instructor_list = [] for ci in course_instructors: instructor_list.append(ci.instructor) full_contentsection_list, full_index_list = get_full_contentsection_list( course) try: video = Video.objects.getByCourse( course=common_page_data['course']).get(slug='intro') except Video.DoesNotExist: video = None if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 ready_section = page.section if ready_section and ready_section.mode == "draft": ready_section = ready_section.image return render_to_response(template, { 'common_page_data': common_page_data, 'page': page, 'contentsection_list': full_contentsection_list, 'full_index_list': full_index_list, 'instructor_list': instructor_list, 'course': course, 'is_logged_in': is_logged_in, 'intro_video': video, 'ready_section': ready_section, 'contentgroup_info': contentgroup_info, 'sections': sections, }, context_instance=RequestContext(request))
def show(request, course_prefix, course_suffix, pset_slug): common_page_data = request.common_page_data try: ps = ProblemSet.objects.getByCourse(course=common_page_data["course"]).get(slug=pset_slug) except ProblemSet.DoesNotExist: messages.add_message( request, messages.ERROR, "This Problemset is not visible in the student view at this time. Please note that students will not see this message.", ) return HttpResponseRedirect(reverse("problemsets.views.listAll", args=(course_prefix, course_suffix))) except ProblemSet.MultipleObjectsReturned: messages.add_message( request, messages.ERROR, "We found multiple problem sets with the same slug. Please try to delete one. This most likely happened due to copying content from another course.", ) return HttpResponseRedirect(reverse("problemsets.views.listAll", args=(course_prefix, course_suffix))) if not common_page_data["is_course_admin"]: visit_log = PageVisitLog( course=common_page_data["ready_course"], user=request.user, page_type="problemset", object_id=str(ps.id) ) visit_log.save() activity_list = [] cursor = connection.cursor() # Used to test for valid data cursor.execute( "SELECT `c2g_problemset_to_exercise`.`problemSet_id`, `c2g_exercises`.`fileName`, c2g_problemset_to_exercise.number, \ min(case when c2g_problem_activity.complete = 1 then c2g_problem_activity.id else null end) as `first_correct_answer`, \ max(c2g_problem_activity.id) as `max_activity_id` \ FROM `c2g_problem_activity` \ LEFT OUTER JOIN `c2g_problemset_to_exercise` ON (`c2g_problem_activity`.`problemset_to_exercise_id` = `c2g_problemset_to_exercise`.`id`) \ INNER JOIN `c2g_problem_sets` ON (`c2g_problemset_to_exercise`.`problemSet_id` = `c2g_problem_sets`.`id`) \ INNER JOIN `c2g_exercises` ON (`c2g_problemset_to_exercise`.`exercise_id` = `c2g_exercises`.`id`) \ WHERE (`c2g_problemset_to_exercise`.`problemSet_id` = %s \ AND `c2g_problem_activity`.`student_id` = %s ) \ GROUP BY `c2g_problemset_to_exercise`.`problemSet_id`, `c2g_exercises`.`fileName`, c2g_problemset_to_exercise.number \ ORDER BY c2g_problemset_to_exercise.number", [ps.id, request.user.id], ) raw_activity_list = [] for row in cursor.fetchall(): problemset_id = row[0] filename = row[1] number = row[2] first_correct_answer = row[3] max_activity_id = row[4] raw_activity_item = { "problemset_id": problemset_id, "filename": filename, "number": number, "first_correct_answer": first_correct_answer, "max_activity_id": max_activity_id, } raw_activity_list.append(raw_activity_item) # Find deleted files cursor.execute( "select e.fileName, p2e.problemSet_id, \ count(case when p2e.is_deleted = 0 then 1 else null end) as `num_active` \ from c2g_problemset_to_exercise p2e, c2g_exercises e \ where p2e.exercise_id = e.id \ and p2e.problemSet_id = %s \ and p2e.mode = 'ready' \ group by e.filename, p2e.problemSet_id \ having num_active = 0", [ps.id], ) deleted_exercise_list = [] for row in cursor.fetchall(): filename = row[0] problemset_id = row[1] filename_item = {"filename": filename, "problemset_id": problemset_id} deleted_exercise_list.append(filename_item) for raw_activity_item in raw_activity_list: problemset_id = raw_activity_item["problemset_id"] filename = raw_activity_item["filename"] number = raw_activity_item["number"] first_correct_answer = raw_activity_item["first_correct_answer"] max_activity_id = raw_activity_item["max_activity_id"] if not filename_in_deleted_list(filename, problemset_id, deleted_exercise_list): if first_correct_answer == None or first_correct_answer == max_activity_id: activity_item = ProblemActivity.objects.get(id=max_activity_id) else: activity_item = ProblemActivity.objects.get(id=first_correct_answer) activity_list.append((activity_item, number)) course = common_page_data["course"] contentsection_list = ContentSection.objects.getByCourse(course=course) video_list = Video.objects.getByCourse(course=course) pset_list = ProblemSet.objects.getByCourse(course=course) additional_pages = AdditionalPage.objects.getSectionPagesByCourse(course=course) file_list = File.objects.getByCourse(course=course) full_contentsection_list, full_index_list = get_full_contentsection_list( course, contentsection_list, video_list, pset_list, additional_pages, file_list ) if request.user.is_authenticated(): is_logged_in = 1 else: is_logged_in = 0 return render_to_response( "problemsets/problemset.html", { "common_page_data": common_page_data, "pset": ps, "pset_url": ps.path, "pset_type": ps.assessment_type, "pset_penalty": ps.resubmission_penalty, "pset_attempts_allowed": ps.submissions_permitted, "activity_list": activity_list, "contentsection_list": full_contentsection_list, "full_index_list": full_index_list, "is_logged_in": is_logged_in, }, context_instance=RequestContext(request), )