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
5 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
5 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
Question_Answers_List.php
146 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 Question_Answers_List extends \Tutor_List_Table { |
| 13 | |
| 14 | const Question_Answer_PAGE = 'question_answer'; |
| 15 | |
| 16 | function __construct() { |
| 17 | global $status, $page; |
| 18 | |
| 19 | // Set parent defaults |
| 20 | parent::__construct( |
| 21 | array( |
| 22 | 'singular' => 'question', // singular name of the listed records |
| 23 | 'plural' => 'questions', // 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 'user_email': |
| 32 | case 'display_name': |
| 33 | case 'post_title': |
| 34 | case 'answer_count': |
| 35 | return $item->$column_name; |
| 36 | default: |
| 37 | return print_r( $item, true ); // Show the whole array for troubleshooting purposes |
| 38 | } |
| 39 | } |
| 40 | |
| 41 | function column_question( $item ) { |
| 42 | // Build row actions |
| 43 | $actions = array( |
| 44 | // 'edit' => sprintf('<a href="?page=%s&action=%s&instructor=%s">Edit</a>',$_REQUEST['page'],'edit',$item->comment_ID), |
| 45 | // 'delete' => sprintf('<a href="?page=%s&action=%s&instructor=%s">Delete</a>',$_REQUEST['page'],'delete',$item->comment_ID), |
| 46 | ); |
| 47 | $answer_action_text = __( 'Answer', 'tutor' ); |
| 48 | |
| 49 | $actions['answer'] = sprintf( '<a href="?page=%s&sub_page=%s&question_id=%s">' . $answer_action_text . '</a>', $_REQUEST['page'], 'answer', $item->comment_ID ); |
| 50 | |
| 51 | // Return the title contents |
| 52 | return sprintf( |
| 53 | '%1$s <span style="color:silver">(id:%2$s)</span>%3$s', |
| 54 | wp_kses_post( stripslashes( $item->comment_content ) ), |
| 55 | $item->comment_ID, |
| 56 | $this->row_actions( $actions ) |
| 57 | ); |
| 58 | } |
| 59 | |
| 60 | function column_cb( $item ) { |
| 61 | return sprintf( |
| 62 | '<input type="checkbox" name="%1$s[]" value="%2$s" />', |
| 63 | /*$1%s*/ $this->_args['singular'], // Let's simply repurpose the table's singular label ("instructor") |
| 64 | /*$2%s*/ $item->comment_ID // The value of the checkbox should be the record's id |
| 65 | ); |
| 66 | } |
| 67 | |
| 68 | function column_course( $item ) { |
| 69 | |
| 70 | return $item->comment_ID; |
| 71 | } |
| 72 | |
| 73 | function get_columns() { |
| 74 | $columns = array( |
| 75 | 'cb' => '<input type="checkbox" />', // Render a checkbox instead of text |
| 76 | 'question' => __( 'Question', 'tutor' ), |
| 77 | 'display_name' => __( 'Student', 'tutor' ), |
| 78 | 'post_title' => __( 'Course', 'tutor' ), |
| 79 | 'answer_count' => __( 'Answer', 'tutor' ), |
| 80 | ); |
| 81 | return $columns; |
| 82 | } |
| 83 | |
| 84 | function get_sortable_columns() { |
| 85 | $sortable_columns = array( |
| 86 | // 'display_name' => array('title',false), //true means it's already sorted |
| 87 | ); |
| 88 | return $sortable_columns; |
| 89 | } |
| 90 | |
| 91 | function get_bulk_actions() { |
| 92 | $actions = array( |
| 93 | 'delete' => 'Delete', |
| 94 | ); |
| 95 | return $actions; |
| 96 | } |
| 97 | |
| 98 | function process_bulk_action() { |
| 99 | global $wpdb; |
| 100 | |
| 101 | // Detect when a bulk action is being triggered... |
| 102 | if ( 'delete' === $this->current_action() ) { |
| 103 | if ( empty( $_GET['question'] ) || ! is_array( $_GET['question'] ) ) { |
| 104 | return; |
| 105 | } |
| 106 | |
| 107 | $question_ids = array_map( 'sanitize_text_field', $_GET['question'] ); |
| 108 | $question_ids = implode( ',', array_map( 'absint', $question_ids ) ); |
| 109 | |
| 110 | // Deleting question (comment), child question and question meta (comment meta) |
| 111 | $wpdb->query( "DELETE FROM {$wpdb->comments} WHERE {$wpdb->comments}.comment_ID IN($question_ids)" ); |
| 112 | $wpdb->query( "DELETE FROM {$wpdb->comments} WHERE {$wpdb->comments}.comment_parent IN($question_ids)" ); |
| 113 | $wpdb->query( "DELETE FROM {$wpdb->commentmeta} WHERE {$wpdb->commentmeta}.comment_id IN($question_ids)" ); |
| 114 | } |
| 115 | } |
| 116 | |
| 117 | function prepare_items() { |
| 118 | $per_page = 20; |
| 119 | |
| 120 | $search_term = ''; |
| 121 | if ( isset( $_REQUEST['s'] ) ) { |
| 122 | $search_term = sanitize_text_field( $_REQUEST['s'] ); |
| 123 | } |
| 124 | |
| 125 | $columns = $this->get_columns(); |
| 126 | $hidden = array(); |
| 127 | $sortable = $this->get_sortable_columns(); |
| 128 | |
| 129 | $this->_column_headers = array( $columns, $hidden, $sortable ); |
| 130 | $this->process_bulk_action(); |
| 131 | |
| 132 | $current_page = $this->get_pagenum(); |
| 133 | |
| 134 | $total_items = tutor_utils()->get_total_qa_question( $search_term ); |
| 135 | $this->items = tutor_utils()->get_qa_questions( ( $current_page - 1 ) * $per_page, $per_page, $search_term ); |
| 136 | |
| 137 | $this->set_pagination_args( |
| 138 | array( |
| 139 | 'total_items' => $total_items, |
| 140 | 'per_page' => $per_page, |
| 141 | 'total_pages' => ceil( $total_items / $per_page ), |
| 142 | ) |
| 143 | ); |
| 144 | } |
| 145 | } |
| 146 |