Question_Answers_List.php — Tutor LMS – eLearning and online course solution 1.9.2

tutor / classes / Question_Answers_List.php

tutor / classes Last commit date

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

Question_Answers_List.php

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