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
176 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->comment_ID); |
| 37 | //$actions['delete'] = sprintf('<a href="?page=%s&action=%s&attempt_id=%s">Delete</a>',$_REQUEST['page'],'delete',$item->comment_ID); |
| 38 | |
| 39 | $quiz_title = '<strong>'.$item->display_name.'</strong> <br />'.$item->user_email.'<br /><br />'. human_time_diff(strtotime |
| 40 | ($item->comment_date)).__(' 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->comment_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->comment_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->comment_post_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 | |
| 72 | function column_total_questions($item) { |
| 73 | $attempt_info = maybe_unserialize($item->quiz_attempt_info); |
| 74 | |
| 75 | echo tutor_utils()->avalue_dot('total_question', $attempt_info); |
| 76 | } |
| 77 | |
| 78 | function column_earned_marks($item){ |
| 79 | $attempt_info = maybe_unserialize($item->quiz_attempt_info); |
| 80 | |
| 81 | $answers_mark = wp_list_pluck(tutor_utils()->avalue_dot('answers', $attempt_info), 'question_mark' ); |
| 82 | $total_marks = array_sum($answers_mark); |
| 83 | |
| 84 | $marks_earned = tutor_utils()->avalue_dot('marks_earned', $attempt_info); |
| 85 | $earned_percentage = $marks_earned > 0 ? ( number_format(($marks_earned * 100) / $total_marks)) : 0; |
| 86 | |
| 87 | $pass_mark_percent = tutor_utils()->avalue_dot('pass_mark_percent', $attempt_info); |
| 88 | |
| 89 | $output = $marks_earned." out of {$total_marks} ({$earned_percentage}%) "; |
| 90 | if ($earned_percentage >= $pass_mark_percent){ |
| 91 | $output .= '<span class="result-pass">'.__('Pass', 'tutor').'</span>'; |
| 92 | }else{ |
| 93 | $output .= '<span class="result-fail">'.__('Fail', 'tutor').'</span>'; |
| 94 | } |
| 95 | |
| 96 | return $output; |
| 97 | } |
| 98 | |
| 99 | function column_attempt_status($item){ |
| 100 | $status = ucwords(str_replace('quiz_', '', $item->attempt_status)); |
| 101 | return "<span class='tutor-status-context {$item->attempt_status}'>{$status}</span>"; |
| 102 | } |
| 103 | |
| 104 | |
| 105 | function get_columns(){ |
| 106 | $columns = array( |
| 107 | 'cb' => '<input type="checkbox" />', //Render a checkbox instead of text |
| 108 | 'student' => __('Students', 'tutor'), |
| 109 | 'quiz' => __('Quiz', 'tutor'), |
| 110 | 'course' => __('Course', 'tutor'), |
| 111 | 'total_questions' => __('Total Questions', 'tutor'), |
| 112 | 'earned_marks' => __('Earned Mark', 'tutor'), |
| 113 | 'attempt_status' => __('Earned Mark', 'tutor'), |
| 114 | ); |
| 115 | return $columns; |
| 116 | } |
| 117 | |
| 118 | function get_sortable_columns() { |
| 119 | $sortable_columns = array( |
| 120 | //'display_name' => array('title',false), //true means it's already sorted |
| 121 | ); |
| 122 | return $sortable_columns; |
| 123 | } |
| 124 | |
| 125 | function get_bulk_actions() { |
| 126 | $actions = array( |
| 127 | 'delete' => 'Delete' |
| 128 | ); |
| 129 | return $actions; |
| 130 | } |
| 131 | |
| 132 | function process_bulk_action() { |
| 133 | global $wpdb; |
| 134 | |
| 135 | //Detect when a bulk action is being triggered... |
| 136 | if( 'delete' === $this->current_action() ) { |
| 137 | if ( empty($_GET['attempt']) || ! is_array($_GET['attempt'])){ |
| 138 | return; |
| 139 | } |
| 140 | |
| 141 | $attempt_ids = array_map('sanitize_text_field', $_GET['attempt']); |
| 142 | $attempt_ids = implode( ',', array_map( 'absint', $attempt_ids ) ); |
| 143 | |
| 144 | //Deleting attempt (comment), child attempt and attempt meta (comment meta) |
| 145 | $wpdb->query( "DELETE FROM {$wpdb->comments} WHERE {$wpdb->comments}.comment_ID IN($attempt_ids)" ); |
| 146 | $wpdb->query( "DELETE FROM {$wpdb->commentmeta} WHERE {$wpdb->commentmeta}.comment_id IN($attempt_ids)" ); |
| 147 | } |
| 148 | } |
| 149 | |
| 150 | function prepare_items() { |
| 151 | $per_page = 20; |
| 152 | |
| 153 | $search_term = ''; |
| 154 | if (isset($_REQUEST['s'])){ |
| 155 | $search_term = sanitize_text_field($_REQUEST['s']); |
| 156 | } |
| 157 | |
| 158 | $columns = $this->get_columns(); |
| 159 | $hidden = array(); |
| 160 | $sortable = $this->get_sortable_columns(); |
| 161 | |
| 162 | $this->_column_headers = array($columns, $hidden, $sortable); |
| 163 | $this->process_bulk_action(); |
| 164 | |
| 165 | $current_page = $this->get_pagenum(); |
| 166 | |
| 167 | $total_items = tutor_utils()->get_total_quiz_attempts($search_term); |
| 168 | $this->items = tutor_utils()->get_quiz_attempts(($current_page-1)*$per_page, $per_page, $search_term); |
| 169 | |
| 170 | $this->set_pagination_args( array( |
| 171 | 'total_items' => $total_items, |
| 172 | 'per_page' => $per_page, |
| 173 | 'total_pages' => ceil($total_items/$per_page) |
| 174 | ) ); |
| 175 | } |
| 176 | } |