Addons.php
4 years ago
Admin.php
4 years ago
Ajax.php
4 years ago
Announcements.php
4 years ago
Assets.php
4 years ago
Backend_Page_Trait.php
4 years ago
Course.php
3 years ago
Course_Filter.php
4 years ago
Course_List.php
3 years ago
Course_Settings_Tabs.php
4 years ago
Course_Widget.php
4 years ago
Custom_Validation.php
4 years ago
Dashboard.php
3 years ago
FormHandler.php
4 years ago
Frontend.php
3 years ago
Gutenberg.php
4 years ago
Input.php
3 years ago
Instructor.php
4 years ago
Instructors_List.php
3 years ago
Lesson.php
4 years ago
Options_V2.php
3 years ago
Post_types.php
4 years ago
Private_Course_Access.php
4 years ago
Q_and_A.php
4 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
Reviews.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
3 years ago
Theme_Compatibility.php
5 years ago
Tools.php
3 years ago
Tools_V2.php
4 years ago
Tutor.php
3 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
3 years ago
Video_Stream.php
4 years ago
Withdraw.php
3 years ago
Withdraw_Requests_List.php
4 years ago
WooCommerce.php
3 years ago
Withdraw_Requests_List.php
212 lines
| 1 | <?php |
| 2 | /** |
| 3 | * Withdraw Class |
| 4 | * |
| 5 | * @package Withdraw |
| 6 | */ |
| 7 | |
| 8 | namespace TUTOR; |
| 9 | |
| 10 | if ( ! defined( 'ABSPATH' ) ) { |
| 11 | exit; |
| 12 | } |
| 13 | /** |
| 14 | * Handle withdraw request logic |
| 15 | */ |
| 16 | class Withdraw_Requests_List { |
| 17 | |
| 18 | public $page_title; |
| 19 | |
| 20 | const WITHDRAW_REQUEST_LIST_PAGE = 'tutor_withdraw_requests'; |
| 21 | |
| 22 | public function __construct() { |
| 23 | $this->page_title = __( 'Withdraw Request', 'tutor' ); |
| 24 | /** |
| 25 | * Approve or reject withdraw request |
| 26 | */ |
| 27 | add_action( 'wp_ajax_tutor_admin_withdraw_action', array( $this, 'update_withdraw_status' ) ); |
| 28 | } |
| 29 | |
| 30 | /** |
| 31 | * Available tabs that will visible on the right side of page navbar |
| 32 | * |
| 33 | * @param string $date withdraw request date | optional. |
| 34 | * @param string $search search by instructor name or email | optional. |
| 35 | * @return array |
| 36 | * @since v2.0.0 |
| 37 | */ |
| 38 | public function tabs_key_value( $date = '', $search = '' ): array { |
| 39 | $approved = self::tabs_data( 'approved', $date, $search ); |
| 40 | $pending = self::tabs_data( 'pending', $date, $search ); |
| 41 | $rejected = self::tabs_data( 'rejected', $date, $search ); |
| 42 | |
| 43 | $url = get_pagenum_link(); |
| 44 | $tabs = array( |
| 45 | array( |
| 46 | 'key' => 'all', |
| 47 | 'title' => __( 'All', 'tutor-pro' ), |
| 48 | 'value' => $approved + $pending + $rejected, |
| 49 | 'url' => $url . '&data=all', |
| 50 | ), |
| 51 | array( |
| 52 | 'key' => 'approved', |
| 53 | 'title' => __( 'Approved', 'tutor-pro' ), |
| 54 | 'value' => $approved, |
| 55 | 'url' => $url . '&data=approved', |
| 56 | ), |
| 57 | array( |
| 58 | 'key' => 'pending', |
| 59 | 'title' => __( 'Pending', 'tutor-pro' ), |
| 60 | 'value' => $pending, |
| 61 | 'url' => $url . '&data=pending', |
| 62 | ), |
| 63 | array( |
| 64 | 'key' => 'rejected', |
| 65 | 'title' => __( 'Rejected', 'tutor-pro' ), |
| 66 | 'value' => $rejected, |
| 67 | 'url' => $url . '&data=rejected', |
| 68 | ), |
| 69 | ); |
| 70 | return $tabs; |
| 71 | } |
| 72 | |
| 73 | /** |
| 74 | * Get counted number of withdraw list by status ex: approved | pending | rejected |
| 75 | * |
| 76 | * @param string $status status required | available : (approved | pending | rejected). |
| 77 | * @param string $date withdraw request date | optional | YYYY-MM-DD. |
| 78 | * @param string $search search by instructor name or email | optional. |
| 79 | * @return int |
| 80 | * @since v2.0.0 |
| 81 | */ |
| 82 | public static function tabs_data( string $status, $date = '', $search = '' ): int { |
| 83 | global $wpdb; |
| 84 | $withdraw_table = $wpdb->prefix . 'tutor_withdraws'; |
| 85 | $user_table = $wpdb->users; |
| 86 | $status = sanitize_text_field( $status ); |
| 87 | $date = sanitize_text_field( $date ); |
| 88 | $search = sanitize_text_field( $search ); |
| 89 | // Prepare date query. |
| 90 | $date_query = ''; |
| 91 | if ( '' !== $date ) { |
| 92 | $date_query = "AND DATE(withdraw.created_at) = CAST('{$date}' AS DATE) "; |
| 93 | } |
| 94 | |
| 95 | // Prepare search query. |
| 96 | $search = '%' . $wpdb->esc_like( $search ) . '%'; |
| 97 | |
| 98 | $count = $wpdb->get_var( |
| 99 | $wpdb->prepare( |
| 100 | "SELECT count(*) FROM {$withdraw_table} AS withdraw |
| 101 | INNER JOIN {$user_table} AS user |
| 102 | ON user.ID = withdraw.user_id |
| 103 | WHERE withdraw.status = %s |
| 104 | {$date_query} |
| 105 | AND ( user.user_login LIKE %s OR user.user_nicename LIKE %s OR user.user_email LIKE %s OR user.display_name LIKE %s ) |
| 106 | ", |
| 107 | $status, |
| 108 | $search, |
| 109 | $search, |
| 110 | $search, |
| 111 | $search |
| 112 | ) |
| 113 | ); |
| 114 | return $count ? $count : 0; |
| 115 | } |
| 116 | |
| 117 | /** |
| 118 | * Handle ajax request for updating withdraw status | available status (approved, rejected, pending) |
| 119 | * |
| 120 | * @return string json response. |
| 121 | * @since v2.0.0 |
| 122 | */ |
| 123 | public function update_withdraw_status() { |
| 124 | tutor_utils()->checking_nonce(); |
| 125 | $status = isset( $_POST['action-type'] ) ? $_POST['action-type'] : ''; |
| 126 | $withdraw_id = isset( $_POST['withdraw-id'] ) ? $_POST['withdraw-id'] : ''; |
| 127 | $reject_type = isset( $_POST['reject-type'] ) ? $_POST['reject-type'] : ''; |
| 128 | $reject_comment = isset( $_POST['reject-comment'] ) ? $_POST['reject-comment'] : ''; |
| 129 | if ( '' === $withdraw_id ) { |
| 130 | return false; |
| 131 | } else { |
| 132 | $update = self::update( $status, $withdraw_id, $reject_type, $reject_comment ); |
| 133 | return $update ? wp_send_json( true ) : false; |
| 134 | } |
| 135 | exit; |
| 136 | } |
| 137 | |
| 138 | /** |
| 139 | * Update withdraw status | available status (approved, rejected, pending) |
| 140 | * |
| 141 | * @param string $status | required. |
| 142 | * @param int $withdraw_id | required. |
| 143 | * @param string $reject_type | optional. |
| 144 | * @param string $reject_comment | optional. |
| 145 | * @return bool json response. |
| 146 | * @since v2.0.0 |
| 147 | */ |
| 148 | public static function update( string $status, int $withdraw_id, $reject_type = '', $reject_comment = '' ): bool { |
| 149 | global $wpdb; |
| 150 | $withdraw_table = $wpdb->prefix . 'tutor_withdraws'; |
| 151 | $withdraw_id = sanitize_text_field( $withdraw_id ); |
| 152 | $status = sanitize_text_field( $status ); |
| 153 | |
| 154 | // Prepare data for update. |
| 155 | $data = array( |
| 156 | 'status' => $status, |
| 157 | 'updated_at' => date( 'Y-m-d H:i:s' ), |
| 158 | ); |
| 159 | |
| 160 | // If rejected then append reject_type and comment with method_data. |
| 161 | if ( 'rejected' === $status ) { |
| 162 | $withdraw = self::get_withdraw_by_id( $withdraw_id ); |
| 163 | if ( $withdraw ) { |
| 164 | $details = unserialize( $withdraw->method_data ); |
| 165 | |
| 166 | $details['rejects'] = array( |
| 167 | 'reject_type' => sanitize_text_field( $reject_type ), |
| 168 | 'reject_comment' => sanitize_text_field( $reject_comment ), |
| 169 | ); |
| 170 | $data['method_data'] = maybe_serialize( $details ); |
| 171 | |
| 172 | // trigger email after rejecting withdraw |
| 173 | do_action( 'tutor_after_rejected_withdraw', $withdraw_id ); |
| 174 | } |
| 175 | } else { |
| 176 | do_action( 'tutor_after_approved_withdraw', $withdraw_id ); |
| 177 | } |
| 178 | |
| 179 | // Update. |
| 180 | $update = $wpdb->update( |
| 181 | $withdraw_table, |
| 182 | $data, |
| 183 | array( |
| 184 | 'withdraw_id' => $withdraw_id, |
| 185 | ) |
| 186 | ); |
| 187 | return $update ? true : false; |
| 188 | } |
| 189 | |
| 190 | |
| 191 | /** |
| 192 | * Get withdraw by id |
| 193 | * |
| 194 | * @param int $withdraw_id | required. |
| 195 | * @return object withdraw list. |
| 196 | * @since v2.0.0 |
| 197 | */ |
| 198 | public static function get_withdraw_by_id( int $withdraw_id ) { |
| 199 | global $wpdb; |
| 200 | $withdraw_table = $wpdb->prefix . 'tutor_withdraws'; |
| 201 | return $wpdb->get_row( |
| 202 | $wpdb->prepare( |
| 203 | " SELECT *FROM {$withdraw_table} |
| 204 | WHERE withdraw_id = %d |
| 205 | ", |
| 206 | $withdraw_id |
| 207 | ) |
| 208 | ); |
| 209 | } |
| 210 | |
| 211 | } |
| 212 |