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

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_Settings_Tabs.php 5 years ago Course_Widget.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 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

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