Addons.php
7 years ago
Admin.php
7 years ago
Ajax.php
7 years ago
Assets.php
7 years ago
Course.php
7 years ago
Gutenberg.php
7 years ago
Instructor.php
7 years ago
Instructors_List.php
7 years ago
Lesson.php
7 years ago
Options.php
7 years ago
Post_types.php
7 years ago
Q_and_A.php
7 years ago
Question.php
7 years ago
Question_Answers_List.php
7 years ago
Quiz.php
7 years ago
Quiz_Attempts_List.php
7 years ago
Rewrite_Rules.php
7 years ago
Shortcode.php
7 years ago
Student.php
7 years ago
Students_List.php
7 years ago
Template.php
7 years ago
Theme_Compatibility.php
7 years ago
Tools.php
7 years ago
Tutor_Base.php
7 years ago
Tutor_List_Table.php
7 years ago
User.php
7 years ago
Utils.php
7 years ago
Video_Stream.php
7 years ago
init.php
7 years ago
Quiz_Attempts_List.php
197 lines
| 1 | <?php |
| 2 | namespace TUTOR; |
| 3 | |
| 4 | if ( ! defined( 'ABSPATH' ) ) |
| 5 | exit; |
| 6 | |
| 7 | if (! class_exists('Tutor_List_Table')){ |
| 8 | include_once tutor()->path.'classes/Tutor_List_Table.php'; |
| 9 | } |
| 10 | |
| 11 | class Quiz_Attempts_List extends \Tutor_List_Table { |
| 12 | |
| 13 | function __construct(){ |
| 14 | global $status, $page; |
| 15 | |
| 16 | //Set parent defaults |
| 17 | parent::__construct( array( |
| 18 | 'singular' => 'attempt', //singular name of the listed records |
| 19 | 'plural' => 'attempts', //plural name of the listed records |
| 20 | 'ajax' => false //does this table support ajax? |
| 21 | ) ); |
| 22 | } |
| 23 | |
| 24 | function column_default($item, $column_name){ |
| 25 | switch($column_name){ |
| 26 | case 'unknown_col': |
| 27 | return $item->$column_name; |
| 28 | default: |
| 29 | //return print_r($item,true); //Show the whole array for troubleshooting purposes |
| 30 | } |
| 31 | } |
| 32 | |
| 33 | function column_student($item){ |
| 34 | $actions = array(); |
| 35 | |
| 36 | $actions['answer'] = sprintf('<a href="?page=%s&sub_page=%s&attempt_id=%s">'.__('Review', 'tutor').'</a>',$_REQUEST['page'],'view_attempt',$item->attempt_id); |
| 37 | //$actions['delete'] = sprintf('<a href="?page=%s&action=%s&attempt_id=%s">Delete</a>',$_REQUEST['page'],'delete',$item->attempt_id); |
| 38 | |
| 39 | $quiz_title = '<strong>'.$item->display_name.'</strong> <br />'.$item->user_email.'<br /><br />'. human_time_diff(strtotime |
| 40 | ($item->attempt_ended_at)).__(' ago', 'tutor'); |
| 41 | |
| 42 | //Return the title contents |
| 43 | return sprintf('%1$s <span style="color:silver">(id:%2$s)</span>%3$s', |
| 44 | $quiz_title, |
| 45 | $item->attempt_id, |
| 46 | $this->row_actions($actions) |
| 47 | ); |
| 48 | } |
| 49 | |
| 50 | function column_quiz($item){ |
| 51 | return $item->post_title; |
| 52 | } |
| 53 | |
| 54 | function column_cb($item){ |
| 55 | return sprintf( |
| 56 | '<input type="checkbox" name="%1$s[]" value="%2$s" />', |
| 57 | /*$1%s*/ $this->_args['singular'], //Let's simply repurpose the table's singular label ("instructor") |
| 58 | /*$2%s*/ $item->attempt_id //The value of the checkbox should be the record's id |
| 59 | ); |
| 60 | } |
| 61 | |
| 62 | function column_course($item) { |
| 63 | $quiz = tutor_utils()->get_course_by_quiz($item->quiz_id); |
| 64 | |
| 65 | if ($quiz) { |
| 66 | $title = get_the_title( $quiz->ID ); |
| 67 | return "<a href='" . admin_url( "post.php?post={$quiz->ID}&action=edit" ) . "'>{$title}</a>"; |
| 68 | } |
| 69 | } |
| 70 | |
| 71 | function column_total_questions($item) { |
| 72 | echo $item->total_questions; |
| 73 | } |
| 74 | |
| 75 | function column_earned_marks($item){ |
| 76 | $pass_mark_percent = tutor_utils()->get_quiz_option($item->quiz_id, 'passing_grade', 0); |
| 77 | $earned_percentage = $item->earned_marks > 0 ? ( number_format(($item->earned_marks * 100) / $item->total_marks)) : 0; |
| 78 | |
| 79 | $output = $item->earned_marks." out of {$item->total_marks} <br />"; |
| 80 | $output .= "({$earned_percentage}%) out of ({$pass_mark_percent}%) <br />"; |
| 81 | |
| 82 | if ($earned_percentage >= $pass_mark_percent){ |
| 83 | $output .= '<span class="result-pass">'.__('Pass', 'tutor').'</span>'; |
| 84 | }else{ |
| 85 | $output .= '<span class="result-fail">'.__('Fail', 'tutor').'</span>'; |
| 86 | } |
| 87 | |
| 88 | return $output; |
| 89 | } |
| 90 | |
| 91 | function column_attempt_status($item){ |
| 92 | $status = ucwords(str_replace('quiz_', '', $item->attempt_status)); |
| 93 | return "<span class='tutor-status-context {$item->attempt_status}'>{$status}</span>"; |
| 94 | } |
| 95 | |
| 96 | function get_columns(){ |
| 97 | $columns = array( |
| 98 | 'cb' => '<input type="checkbox" />', //Render a checkbox instead of text |
| 99 | 'student' => __('Students', 'tutor'), |
| 100 | 'quiz' => __('Quiz', 'tutor'), |
| 101 | 'course' => __('Course', 'tutor'), |
| 102 | 'total_questions' => __('Total Questions', 'tutor'), |
| 103 | 'earned_marks' => __('Earned Mark', 'tutor'), |
| 104 | 'attempt_status' => __('Attempt Status', 'tutor'), |
| 105 | ); |
| 106 | return $columns; |
| 107 | } |
| 108 | |
| 109 | function get_sortable_columns() { |
| 110 | $sortable_columns = array( |
| 111 | //'display_name' => array('title',false), //true means it's already sorted |
| 112 | ); |
| 113 | return $sortable_columns; |
| 114 | } |
| 115 | |
| 116 | function get_bulk_actions() { |
| 117 | $actions = array( |
| 118 | 'delete' => 'Delete' |
| 119 | ); |
| 120 | return $actions; |
| 121 | } |
| 122 | |
| 123 | function process_bulk_action() { |
| 124 | global $wpdb; |
| 125 | |
| 126 | //Detect when a bulk action is being triggered... |
| 127 | if( 'delete' === $this->current_action() ) { |
| 128 | if ( empty($_GET['attempt']) || ! is_array($_GET['attempt'])){ |
| 129 | return; |
| 130 | } |
| 131 | |
| 132 | $attempt_ids = array_map('sanitize_text_field', $_GET['attempt']); |
| 133 | $attempt_ids = implode( ',', array_map( 'absint', $attempt_ids ) ); |
| 134 | |
| 135 | //Deleting attempt (comment), child attempt and attempt meta (comment meta) |
| 136 | $wpdb->query( "DELETE FROM {$wpdb->comments} WHERE {$wpdb->comments}.comment_ID IN($attempt_ids)" ); |
| 137 | $wpdb->query( "DELETE FROM {$wpdb->commentmeta} WHERE {$wpdb->commentmeta}.comment_id IN($attempt_ids)" ); |
| 138 | } |
| 139 | } |
| 140 | |
| 141 | function prepare_items() { |
| 142 | global $wpdb; |
| 143 | |
| 144 | $per_page = 20; |
| 145 | $search_term = ''; |
| 146 | if (isset($_REQUEST['s'])){ |
| 147 | $search_term = sanitize_text_field($_REQUEST['s']); |
| 148 | } |
| 149 | |
| 150 | $columns = $this->get_columns(); |
| 151 | $hidden = array(); |
| 152 | $sortable = $this->get_sortable_columns(); |
| 153 | |
| 154 | $this->_column_headers = array($columns, $hidden, $sortable); |
| 155 | $this->process_bulk_action(); |
| 156 | |
| 157 | $current_page = $this->get_pagenum(); |
| 158 | |
| 159 | $total_items = 0; |
| 160 | $this->items = array(); |
| 161 | |
| 162 | if (current_user_can('administrator')) { |
| 163 | $total_items = tutor_utils()->get_total_quiz_attempts( $search_term ); |
| 164 | $this->items = tutor_utils()->get_quiz_attempts( ( $current_page - 1 ) * $per_page, $per_page, $search_term ); |
| 165 | }elseif (current_user_can('tutor_instructor')){ |
| 166 | /** |
| 167 | * Instructors course specific quiz attempts |
| 168 | */ |
| 169 | $user_id = get_current_user_id(); |
| 170 | $get_assigned_courses_ids = $wpdb->get_col("SELECT meta_value from {$wpdb->usermeta} WHERE meta_key = '_tutor_instructor_course_id' AND user_id = {$user_id} "); |
| 171 | |
| 172 | $custom_author_query = "AND {$wpdb->posts}.post_author = {$user_id}"; |
| 173 | if (is_array($get_assigned_courses_ids) && count($get_assigned_courses_ids)){ |
| 174 | $in_query_pre = implode($get_assigned_courses_ids, ','); |
| 175 | $custom_author_query = " AND ( {$wpdb->posts}.post_author = {$user_id} OR {$wpdb->posts}.ID IN({$in_query_pre}) ) "; |
| 176 | } |
| 177 | $course_post_type = tutor()->course_post_type; |
| 178 | $get_course_ids = $wpdb->get_col("SELECT ID from {$wpdb->posts} where post_type = '{$course_post_type}' $custom_author_query ; "); |
| 179 | |
| 180 | if (is_array($get_course_ids) && count($get_course_ids)){ |
| 181 | $total_items = tutor_utils()->get_total_quiz_attempts_by_course_ids($get_course_ids, $search_term ); |
| 182 | $this->items = tutor_utils()->get_quiz_attempts_by_course_ids(( $current_page - 1 ) * $per_page, $per_page, $get_course_ids, $search_term ); |
| 183 | } |
| 184 | |
| 185 | } |
| 186 | |
| 187 | |
| 188 | |
| 189 | |
| 190 | |
| 191 | $this->set_pagination_args( array( |
| 192 | 'total_items' => $total_items, |
| 193 | 'per_page' => $per_page, |
| 194 | 'total_pages' => ceil($total_items/$per_page) |
| 195 | ) ); |
| 196 | } |
| 197 | } |