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