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