Instructors_List.php — Tutor LMS – eLearning and online course solution 1.9.13

tutor / classes / Instructors_List.php

tutor / classes Last commit date

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

Instructors_List.php

230 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 Instructors_List extends \Tutor_List_Table {
13
14	const INSTRUCTOR_LIST_PAGE = 'tutor-instructors';
15
16	function __construct() {
17	global $status, $page;
18
19	// Set parent defaults
20	parent::__construct(
21	array(
22	'singular' => 'instructor', // singular name of the listed records
23	'plural' => 'instructors', // plural name of the listed records
24	'ajax' => false, // does this table support ajax?
25	)
26	);
27
28	// $this->process_bulk_action();
29	}
30
31	function column_default( $item, $column_name ) {
32	switch ( $column_name ) {
33	case 'user_email':
34	case 'display_name':
35	return $item->$column_name;
36	case 'registration_date':
37	return esc_html( date( get_option( 'date_format' ), strtotime( $item->user_registered ) ) );
38	default:
39	return print_r( $item, true ); // Show the whole array for troubleshooting purposes
40	}
41	}
42
43	function column_total_course( $item ) {
44	global $wpdb;
45	$course_post_type = tutor()->course_post_type;
46
47	$total_course = (int) $wpdb->get_var( $wpdb->prepare(
48	"SELECT count(ID) from {$wpdb->posts}
49	WHERE post_author=%d AND post_type=%s ",
50	$item->ID,
51	$course_post_type
52	) );
53
54	echo $total_course;
55	}
56
57	/**
58	* @param $item
59	*
60	* Completed Course by User
61	*/
62	function column_status( $item ) {
63	$status = tutor_utils()->instructor_status( $item->ID, false );
64	$status_name = tutor_utils()->instructor_status( $item->ID );
65	echo '<span class="tutor-status-context tutor-status-' . $status . '-context">' . $status_name . '</span>';
66	}
67
68	function column_display_name( $item ) {
69	// Build row actions
70	$actions = array();
71
72	$status = tutor_utils()->instructor_status( $item->ID, false );
73
74	switch ( $status ) {
75	case 'pending':
76	$actions['approved'] = sprintf( '<a class="instructor-action" data-action="approve" data-instructor-id="' . $item->ID . '" href="?page=%s&action=%s&instructor=%s">' . __( 'Approve', 'tutor' ) . '</a>', self::INSTRUCTOR_LIST_PAGE, 'approve', $item->ID );
77	break;
78	case 'approved':
79	$actions['blocked'] = sprintf( '<a data-prompt-message="' . __( 'Sure to Block?', 'tutor' ) . '" class="instructor-action" data-action="blocked" data-instructor-id="' . $item->ID . '" href="?page=%s&action=%s&instructor=%s">' . __( 'Block', 'tutor' ) . '</a>', self::INSTRUCTOR_LIST_PAGE, 'blocked', $item->ID );
80	break;
81	case 'blocked':
82	$actions['approved'] = sprintf( '<a data-prompt-message="' . __( 'Sure to Un Block?', 'tutor' ) . '" class="instructor-action" data-action="approve" data-instructor-id="' . $item->ID . '" href="?page=%s&action=%s&instructor=%s">' . __( 'Unblock', 'tutor' ) . '</a>', self::INSTRUCTOR_LIST_PAGE, 'approve', $item->ID );
83	break;
84	}
85
86	// Add user edit link
87	$edit_link = get_edit_user_link( $item->ID );
88	$edit_link = '<a href="' . esc_url( $edit_link ) . '">' . esc_html__( 'Edit' ) . '</a>';
89	$actions['tutor-instructor-edit-link'] = $edit_link;
90
91	// Add remove instructor action
92	$removal_title = $status == 'pending' ? __( 'Reject', 'tutor' ) : __( 'Remove as Instructor', 'tutor' );
93	$removal_warning = $status == 'pending' ? __( 'Sure to Reject?', 'tutor' ) : __( 'Sure to Remove as Instructor?', 'tutor' );
94	$actions['tutor-remove-instructor'] = sprintf( '<a data-prompt-message="' . $removal_warning . '" class="instructor-action" data-action="remove-instructor" data-instructor-id="' . $item->ID . '" href="?page=%s&action=%s&instructor=%s">' . $removal_title . '</a>', self::INSTRUCTOR_LIST_PAGE, 'remove-instructor', $item->ID );
95
96	// Return the title contents
97	return sprintf(
98	'%1$s <span style="color:silver">(id:%2$s)</span>%3$s',
99	$item->display_name,
100	$item->ID,
101	$this->row_actions( $actions )
102	);
103	}
104
105	function column_cb( $item ) {
106	return sprintf(
107	'<input type="checkbox" name="%1$s[]" value="%2$s" />',
108	/$1%s/ $this->_args['singular'], // Let's simply repurpose the table's singular label ("instructor")
109	/$2%s/ $item->ID // The value of the checkbox should be the record's id
110	);
111	}
112
113	function column_instructor_commission( $item ) {
114	$commision = apply_filters( 'tutor_pro_instructor_commission_string', $item->ID );
115
116	// If the return value is numeric, it means the filter was not executed.
117	// may be pro is not installed. So show N\A. The return value will something like '23 percent'
118
119	return ! is_numeric( $commision ) ? $commision : 'N\\A';
120	}
121
122	function get_columns() {
123	$columns = array(
124	'cb' => '<input type="checkbox" />', // Render a checkbox instead of text
125	'display_name' => __( 'Name', 'tutor' ),
126	'user_email' => __( 'E-Mail', 'tutor' ),
127	'total_course' => __( 'Total Course', 'tutor' ),
128	'instructor_commission' => __( 'Instructor Commission', 'tutor' ),
129	'registration_date' => __( 'Date', 'tutor' ),
130	'status' => __( 'Status', 'tutor' ),
131	);
132	return $columns;
133	}
134
135	function get_sortable_columns() {
136	$sortable_columns = array(
137	// 'display_name' => array('title',false), //true means it's already sorted
138	);
139	return $sortable_columns;
140	}
141
142	function get_bulk_actions() {
143	$actions = array(
144	'delete' => 'Delete',
145	);
146	return $actions;
147	}
148
149	function process_bulk_action() {
150	if ( 'approve' === $this->current_action() ) {
151	$instructor_id = (int) sanitize_text_field( $_GET['instructor'] );
152
153	do_action( 'tutor_before_approved_instructor', $instructor_id );
154
155	update_user_meta( $instructor_id, '_tutor_instructor_status', 'approved' );
156	update_user_meta( $instructor_id, '_tutor_instructor_approved', tutor_time() );
157
158	$instructor = new \WP_User( $instructor_id );
159	$instructor->add_role( tutor()->instructor_role );
160
161	// TODO: send E-Mail to this user about instructor approval, should via hook
162	do_action( 'tutor_after_approved_instructor', $instructor_id );
163	}
164
165	if ( 'blocked' === $this->current_action() ) {
166	$instructor_id = (int) sanitize_text_field( $_GET['instructor'] );
167
168	do_action( 'tutor_before_blocked_instructor', $instructor_id );
169	update_user_meta( $instructor_id, '_tutor_instructor_status', 'blocked' );
170
171	$instructor = new \WP_User( $instructor_id );
172	$instructor->remove_role( tutor()->instructor_role );
173	do_action( 'tutor_after_blocked_instructor', $instructor_id );
174
175	// TODO: send E-Mail to this user about instructor blocked, should via hook
176	}
177
178	// Detect when a bulk action is being triggered...
179	if ( 'delete' === $this->current_action() ) {
180
181	$delete_instructors = tutor_sanitize_data($_GET['instructor']);
182	if ( count( $delete_instructors ) ) {
183	foreach ( $delete_instructors as $instructor ) {
184	do_action( 'tutor_insctructor_before_delete', $instructor );
185
186	wp_delete_user( $instructor );
187
188	do_action( 'tutor_insctructor_after_delete', $instructor );
189
190	}
191	}
192	}
193	}
194
195	/**
196	* Filter support added
197	*
198	* @param optional
199	*
200	* @since 1.9.7
201	*/
202	function prepare_items( $search_filter = '', $course_filter = '', $date_filter = '', $order_filter = '' ) {
203	$per_page = 20;
204
205	// $search_term = '';
206	// if (isset($_REQUEST['s'])){
207	// $search_term = sanitize_text_field($_REQUEST['s']);
208	// }
209
210	$columns = $this->get_columns();
211	$hidden = array();
212	$sortable = $this->get_sortable_columns();
213
214	$this->_column_headers = array( $columns, $hidden, $sortable );
215	$this->process_bulk_action();
216	$current_page = $this->get_pagenum();
217
218	$total_items = tutor_utils()->get_total_instructors( $search_filter );
219	$this->items = tutor_utils()->get_instructors( ( $current_page - 1 ) * $per_page, $per_page, $search_filter, $course_filter, $date_filter, $order_filter, $status = null, $cat_ids = array() );
220
221	$this->set_pagination_args(
222	array(
223	'total_items' => $total_items,
224	'per_page' => $per_page,
225	'total_pages' => ceil( $total_items / $per_page ),
226	)
227	);
228	}
229	}
230