learnpress / inc / admin / class-lp-reset-data.php

class-lp-reset-data.php in LearnPress – WordPress LMS Plugin for Create and Sell Online Courses 4.4.3, at inc/admin/class-lp-reset-data.php

327 lines 8.3 KB

Raw Download Zip

1	<?php
2	class LP_Reset_Data {
3	public static function init() {
4	$ajax_events = array(
5	'search-users',
6	'reset-user-courses' => 'ajax_reset_user_courses',
7	'reset-user-item' => 'ajax_reset_user_item',
8	);
9
10	foreach ( $ajax_events as $action => $callback ) {
11	if ( is_numeric( $action ) ) {
12	$action = $callback;
13	}
14
15	$actions = LP_Request::parse_action( $action );
16	$method = $actions['action'];
17
18	if ( ! is_callable( $callback ) ) {
19	$callback = array( __CLASS__, $callback );
20
21	if ( ! is_callable( $callback ) ) {
22	$method = preg_replace( '/-/', '_', $method );
23	$callback = array( __CLASS__, $method );
24	}
25	}
26	LP_Request::register_ajax( "rs-{$action}", $callback );
27	}
28	}
29
30	public static function ajax_reset_user_item() {
31	if ( ! current_user_can( ADMIN_ROLE ) ) {
32	return;
33	}
34
35	$nonce = LP_Request::get_param( 'nonce' );
36	if ( ! wp_verify_nonce( $nonce, 'wp_rest' ) ) {
37	die( 'Nonce is invalid!' );
38	}
39
40	$user_id = LP_Request::get_string( 'user_id' );
41	$item_id = LP_Request::get_int( 'item_id' );
42
43	if ( ! is_numeric( $user_id ) ) {
44	$user_email = get_user_by( 'email', $user_id );
45	$user_login = get_user_by( 'login', $user_id );
46
47	if ( $user_email ) {
48	$user_id = $user_email->ID;
49	} elseif ( $user_login ) {
50	$user_id = $user_login->ID;
51	}
52	}
53
54	global $wpdb;
55
56	$query = $wpdb->prepare(
57	"
58	SELECT user_item_id
59	FROM {$wpdb->learnpress_user_items}
60	WHERE user_id = %d AND item_id = %d
61	",
62	$user_id,
63	$item_id
64	);
65
66	$user_item_ids = $wpdb->get_col( $query );
67	if ( $user_item_ids ) {
68	$query = "
69	SELECT DISTINCT parent_id AS parent, item_id
70	FROM {$wpdb->learnpress_user_items}
71	WHERE user_item_id IN(" . join( ',', $user_item_ids ) . ')
72	';
73	$parents = $wpdb->get_results( $query );
74
75	$format = array_fill( 0, sizeof( $user_item_ids ), '%d' );
76	$query = $wpdb->prepare(
77	"
78	DELETE
79	FROM {$wpdb->learnpress_user_itemmeta}
80	WHERE learnpress_user_item_id IN(" . join( ',', $format ) . ')
81	',
82	$user_item_ids
83	);
84	$wpdb->query( $query );
85
86	$query = $wpdb->prepare(
87	"
88	DELETE
89	FROM {$wpdb->learnpress_user_items}
90	WHERE user_id = %d AND item_id = %d
91	",
92	$user_id,
93	$item_id
94	);
95
96	$wpdb->query( $query );
97
98	if ( $parents ) {
99	foreach ( $parents as $parent ) {
100	$retaken_items = learn_press_get_user_item_meta( $parent->parent, '_retaken_items', true );
101	if ( $retaken_items ) {
102	if ( ! isset( $retaken_items[ $parent->item_id ] ) ) {
103	continue;
104	}
105
106	unset( $retaken_items[ $parent->item_id ] );
107	learn_press_update_user_item_meta( $parent->parent, '_retaken_items', $retaken_items );
108	}
109	}
110	}
111
112	echo __( 'Item progress is deleted', 'learnpress' );
113	} else {
114	echo __( 'No data found', 'learnpress' );
115	}
116	// LP_Debug::rollbackTransaction();
117	die();
118	}
119
120	public static function search_users() {
121	global $wpdb;
122
123	$nonce = LP_Request::get_param( 'nonce' );
124	if ( ! wp_verify_nonce( $nonce, 'wp_rest' ) ) {
125	die( 'Nonce is invalid!' );
126	}
127
128	if ( ! current_user_can( 'administrator' ) ) {
129	return;
130	}
131
132	$s = LP_Request::get_string( 's' );
133	$query = $wpdb->prepare(
134	"
135	SELECT ID AS id, user_login AS username, user_email AS email, '' AS status
136	FROM {$wpdb->users}
137	WHERE user_login LIKE %s
138	OR user_email LIKE %s
139	",
140	'%' . $wpdb->esc_like( $s ) . '%',
141	'%' . $wpdb->esc_like( $s ) . '%'
142	);
143
144	$users = array();
145
146	$rows = $wpdb->get_results( $query );
147	if ( $rows ) {
148	$user_ids = wp_list_pluck( $rows, 'id' );
149	$format = array_fill( 0, sizeof( $user_ids ), '%d' );
150	$args = $user_ids;
151	$args[] = LP_COURSE_CPT;
152	$query = $wpdb->prepare( "SELECT user_id, item_id FROM {$wpdb->learnpress_user_items} WHERE user_id IN(" . join( ',', $format ) . ') AND item_type = %s', $args );
153
154	$items = $wpdb->get_results( $query );
155	if ( $items ) {
156	$uids = wp_list_pluck( $items, 'user_id' );
157	for ( $n = sizeof( $rows ), $i = $n - 1; $i >= 0; $i -- ) {
158
159	if ( ! in_array( $rows[ $i ]->id, $uids ) ) {
160	unset( $rows[ $i ] );
161	continue;
162	}
163
164	if ( empty( $rows[ $i ]->courses ) ) {
165	$rows[ $i ]->courses = array();
166	}
167	foreach ( $items as $item ) {
168	if ( $item->user_id == $rows[ $i ]->id ) {
169	$rows[ $i ]->courses[ $item->item_id ] = array(
170	'url' => get_the_permalink( $item->item_id ),
171	'id' => $item->item_id,
172	'title' => get_the_title( $item->item_id ),
173	);
174	}
175	}
176	}
177	} else {
178	$rows = array();
179	}
180
181	if ( $rows ) {
182	foreach ( $rows as $k => $row ) {
183	$users[] = $row;
184	if ( sizeof( $users ) > 100 ) {
185	break;
186	}
187	}
188	}
189	}
190
191	learn_press_send_json( $users );
192	}
193
194	public static function ajax_reset_user_courses() {
195	$user_id = LP_Request::get_int( 'user_id' );
196	$course_id = LP_Request::get_int( 'course_id' );
197	$object_reset = LP_Request::get_string( 'object_reset' );
198	$user = learn_press_get_user( $user_id );
199	if ( ! current_user_can( 'administrator' ) ) {
200	return;
201	}
202
203	$nonce = LP_Request::get_param( 'nonce' );
204	if ( ! wp_verify_nonce( $nonce, 'wp_rest' ) ) {
205	die( 'Nonce is invalid!' );
206	}
207
208	if ( $course_id && $object_reset == 'single' ) {
209	$user_course_data = $user->get_course_data( $course_id );
210	if ( ! $user_course_data ) {
211	return;
212	}
213
214	// Set status, start_time, end_time of course to enrol.
215	$user_course_data->set_status( LP_COURSE_ENROLLED )
216	->set_start_time( time() )
217	->set_end_time()
218	->set_graduation( LP_COURSE_GRADUATION_IN_PROGRESS )
219	->update();
220	// Remove items' course user learned.
221	$filter_remove = new LP_User_Items_Filter();
222	$filter_remove->parent_id = $user_course_data->get_user_item_id();
223	$filter_remove->user_id = $user_course_data->get_user_id();
224	$filter_remove->limit = - 1;
225	LP_User_Items_DB::getInstance()->remove_items_of_user_course( $filter_remove );
226	}
227	if ( $object_reset == 'all' && $user_id ) {
228	global $wpdb;
229	$query = $wpdb->prepare(
230	"
231	SELECT item_id
232	FROM {$wpdb->learnpress_user_items}
233	WHERE user_id = %d AND item_type='lp_course'
234	",
235	$user_id
236	);
237	$user_item_ids = $wpdb->get_col( $query );
238	if ( $user_item_ids ) {
239	foreach ( $user_item_ids as $user_item_id ) {
240	$course_id = $user_item_id;
241	$user_course_data = $user->get_course_data( $course_id );
242	if ( ! $user_course_data ) {
243	continue;
244	}
245
246	// Set status, start_time, end_time of course to enrolled.
247	$user_course_data->set_status( LP_COURSE_ENROLLED )
248	->set_start_time( time() )
249	->set_end_time()
250	->set_graduation( LP_COURSE_GRADUATION_IN_PROGRESS )
251	->update();
252	// Remove items' course user learned.
253	$filter_remove = new LP_User_Items_Filter();
254	$filter_remove->parent_id = $user_course_data->get_user_item_id();
255	$filter_remove->user_id = $user_course_data->get_user_id();
256	$filter_remove->limit = - 1;
257	LP_User_Items_DB::getInstance()->remove_items_of_user_course( $filter_remove );
258	}
259	}
260	}
261
262	die();
263	}
264
265	public static function get_user_item_courses( $course_id, $user_id = 0 ) {
266	global $wpdb;
267
268	$where = '';
269	if ( $user_id ) {
270	$where = $wpdb->prepare( 'AND user_id = %d', $user_id );
271	}
272
273	$query = $wpdb->prepare(
274	"
275	SELECT *
276	FROM {$wpdb->learnpress_user_items}
277	WHERE item_type = %s
278	AND item_id = %d
279	$where
280	",
281	LP_COURSE_CPT,
282	$course_id
283	);
284
285	echo "$query\n";
286
287	return $wpdb->get_results( $query );
288	}
289
290	public static function delete_user_items_by_id( $ids ) {
291	settype( $ids, 'array' );
292
293	global $wpdb;
294
295	// Delete meta
296	$format = array_fill( 0, sizeof( $ids ), '%d' );
297	$query = $wpdb->prepare( "DELETE FROM {$wpdb->learnpress_user_itemmeta} WHERE learnpress_user_item_id IN(" . join( ',', $format ) . ')', $ids );
298	$wpdb->query( $query );
299	echo "$query\n";
300
301	// Delete items
302	$query = $wpdb->prepare( "DELETE FROM {$wpdb->learnpress_user_items} WHERE user_item_id IN(" . join( ',', $format ) . ')', $ids );
303	$wpdb->query( $query );
304
305	echo "$query\n";
306
307	}
308
309	public static function get_user_items_by_parent( $parent_id ) {
310	global $wpdb;
311
312	$query = $wpdb->prepare(
313	"
314	SELECT *
315	FROM {$wpdb->learnpress_user_items}
316	WHERE parent_id = %d
317	",
318	$parent_id
319	);
320
321	echo "$query\n";
322
323	return $wpdb->get_results( $query );
324	}
325	}
326	LP_Reset_Data::init();
327