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