@@ -8,7 +8,7 @@ discard block |
||
8 | 8 | */ |
9 | 9 | |
10 | 10 | if ( ! defined( 'ABSPATH' ) ) { |
11 | - exit; // Exit if accessed directly |
|
11 | + exit; // Exit if accessed directly |
|
12 | 12 | } |
13 | 13 | |
14 | 14 | /** |
@@ -75,16 +75,16 @@ discard block |
||
75 | 75 | $class .= ' wpi-recurring'; |
76 | 76 | } |
77 | 77 | |
78 | - $refund_url = wp_nonce_url( |
|
79 | - add_query_arg( |
|
80 | - array( |
|
81 | - 'getpaid-admin-action' => 'refund_invoice', |
|
82 | - 'invoice_id' => $invoice->get_id(), |
|
83 | - ) |
|
84 | - ), |
|
85 | - 'getpaid-nonce', |
|
86 | - 'getpaid-nonce' |
|
87 | - ); |
|
78 | + $refund_url = wp_nonce_url( |
|
79 | + add_query_arg( |
|
80 | + array( |
|
81 | + 'getpaid-admin-action' => 'refund_invoice', |
|
82 | + 'invoice_id' => $invoice->get_id(), |
|
83 | + ) |
|
84 | + ), |
|
85 | + 'getpaid-nonce', |
|
86 | + 'getpaid-nonce' |
|
87 | + ); |
|
88 | 88 | ?> |
89 | 89 | |
90 | 90 | <div class="wpinv-items-wrap<?php echo esc_attr( $class ); ?>" id="wpinv_items_wrap" data-status="<?php echo esc_attr( $invoice->get_status() ); ?>"> |
@@ -96,8 +96,8 @@ discard block |
||
96 | 96 | <th class=" |
97 | 97 | <?php |
98 | 98 | echo esc_attr( $key ); |
99 | - echo 'total' == $key || 'qty' == $key ? ' hide-if-amount' : ''; |
|
100 | - ?> |
|
99 | + echo 'total' == $key || 'qty' == $key ? ' hide-if-amount' : ''; |
|
100 | + ?> |
|
101 | 101 | "><?php echo wp_kses_post( $label ); ?></th> |
102 | 102 | <?php endforeach; ?> |
103 | 103 | </tr> |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | <tbody class="wpinv-line-items"> |
107 | 107 | <?php |
108 | 108 | foreach ( $invoice->get_items() as $int => $item ) { |
109 | - self::output_row( $columns, $item, $invoice, $int % 2 == 0 ? 'even' : 'odd' ); |
|
109 | + self::output_row( $columns, $item, $invoice, $int % 2 == 0 ? 'even' : 'odd' ); |
|
110 | 110 | } |
111 | 111 | ?> |
112 | 112 | </tbody> |
@@ -151,13 +151,13 @@ discard block |
||
151 | 151 | <?php |
152 | 152 | wpinv_html_select( |
153 | 153 | array( |
154 | - 'options' => $item_types, |
|
155 | - 'name' => '_wpinv_quick[type]', |
|
156 | - 'id' => '_wpinv_quick_type', |
|
157 | - 'selected' => 'custom', |
|
158 | - 'show_option_all' => false, |
|
159 | - 'show_option_none' => false, |
|
160 | - 'class' => 'gdmbx2-text-medium wpinv-quick-type', |
|
154 | + 'options' => $item_types, |
|
155 | + 'name' => '_wpinv_quick[type]', |
|
156 | + 'id' => '_wpinv_quick_type', |
|
157 | + 'selected' => 'custom', |
|
158 | + 'show_option_all' => false, |
|
159 | + 'show_option_none' => false, |
|
160 | + 'class' => 'gdmbx2-text-medium wpinv-quick-type', |
|
161 | 161 | ) |
162 | 162 | ); |
163 | 163 | ?> |
@@ -172,16 +172,16 @@ discard block |
||
172 | 172 | <?php |
173 | 173 | wpinv_html_select( |
174 | 174 | array( |
175 | - 'options' => array_merge( |
|
176 | - array( '' => __( 'Select VAT Rule', 'invoicing' ) ), |
|
177 | - getpaid_get_tax_rules() |
|
178 | - ), |
|
179 | - 'name' => '_wpinv_quick[vat_rule]', |
|
180 | - 'id' => '_wpinv_quick_vat_rule', |
|
181 | - 'show_option_all' => false, |
|
182 | - 'show_option_none' => false, |
|
183 | - 'class' => 'gdmbx2-text-medium wpinv-quick-vat-rule', |
|
184 | - 'selected' => 'digital', |
|
175 | + 'options' => array_merge( |
|
176 | + array( '' => __( 'Select VAT Rule', 'invoicing' ) ), |
|
177 | + getpaid_get_tax_rules() |
|
178 | + ), |
|
179 | + 'name' => '_wpinv_quick[vat_rule]', |
|
180 | + 'id' => '_wpinv_quick_vat_rule', |
|
181 | + 'show_option_all' => false, |
|
182 | + 'show_option_none' => false, |
|
183 | + 'class' => 'gdmbx2-text-medium wpinv-quick-vat-rule', |
|
184 | + 'selected' => 'digital', |
|
185 | 185 | ) |
186 | 186 | ); |
187 | 187 | ?> |
@@ -194,16 +194,16 @@ discard block |
||
194 | 194 | <?php |
195 | 195 | wpinv_html_select( |
196 | 196 | array( |
197 | - 'options' => array_merge( |
|
198 | - array( '' => __( 'Select VAT Class', 'invoicing' ) ), |
|
199 | - getpaid_get_tax_classes() |
|
200 | - ), |
|
201 | - 'name' => '_wpinv_quick[vat_class]', |
|
202 | - 'id' => '_wpinv_quick_vat_class', |
|
203 | - 'show_option_all' => false, |
|
204 | - 'show_option_none' => false, |
|
205 | - 'class' => 'gdmbx2-text-medium wpinv-quick-vat-class', |
|
206 | - 'selected' => '_standard', |
|
197 | + 'options' => array_merge( |
|
198 | + array( '' => __( 'Select VAT Class', 'invoicing' ) ), |
|
199 | + getpaid_get_tax_classes() |
|
200 | + ), |
|
201 | + 'name' => '_wpinv_quick[vat_class]', |
|
202 | + 'id' => '_wpinv_quick_vat_class', |
|
203 | + 'show_option_all' => false, |
|
204 | + 'show_option_none' => false, |
|
205 | + 'class' => 'gdmbx2-text-medium wpinv-quick-vat-class', |
|
206 | + 'selected' => '_standard', |
|
207 | 207 | ) |
208 | 208 | ); |
209 | 209 | ?> |
@@ -294,37 +294,37 @@ discard block |
||
294 | 294 | </p> |
295 | 295 | <?php if ( getpaid_payment_gateway_supports( $invoice->get_gateway(), 'refunds' ) ) : ?> |
296 | 296 | <?php |
297 | - aui()->input( |
|
298 | - array( |
|
299 | - 'type' => 'checkbox', |
|
300 | - 'name' => 'getpaid_refund_remote', |
|
301 | - 'id' => 'getpaid_refund_remote', |
|
302 | - 'label' => sprintf( |
|
303 | - 'Refund payment in %s', |
|
304 | - wpinv_get_gateway_admin_label( $invoice->get_gateway() ) |
|
305 | - ), |
|
306 | - 'value' => 1, |
|
307 | - 'class' => 'getpaid-refund-field', |
|
308 | - ), |
|
309 | - true |
|
310 | - ); |
|
311 | - ?> |
|
297 | + aui()->input( |
|
298 | + array( |
|
299 | + 'type' => 'checkbox', |
|
300 | + 'name' => 'getpaid_refund_remote', |
|
301 | + 'id' => 'getpaid_refund_remote', |
|
302 | + 'label' => sprintf( |
|
303 | + 'Refund payment in %s', |
|
304 | + wpinv_get_gateway_admin_label( $invoice->get_gateway() ) |
|
305 | + ), |
|
306 | + 'value' => 1, |
|
307 | + 'class' => 'getpaid-refund-field', |
|
308 | + ), |
|
309 | + true |
|
310 | + ); |
|
311 | + ?> |
|
312 | 312 | <?php endif; ?> |
313 | 313 | |
314 | 314 | <?php if ( getpaid_get_invoice_subscriptions( $invoice ) ) : ?> |
315 | 315 | <?php |
316 | - aui()->input( |
|
317 | - array( |
|
318 | - 'type' => 'checkbox', |
|
319 | - 'name' => 'getpaid_cancel_subscription', |
|
320 | - 'id' => 'getpaid_cancel_subscription', |
|
321 | - 'label' => __( 'Cancel subscription', 'invoicing' ), |
|
322 | - 'value' => 1, |
|
323 | - 'class' => 'getpaid-refund-field', |
|
324 | - ), |
|
325 | - true |
|
326 | - ); |
|
327 | - ?> |
|
316 | + aui()->input( |
|
317 | + array( |
|
318 | + 'type' => 'checkbox', |
|
319 | + 'name' => 'getpaid_cancel_subscription', |
|
320 | + 'id' => 'getpaid_cancel_subscription', |
|
321 | + 'label' => __( 'Cancel subscription', 'invoicing' ), |
|
322 | + 'value' => 1, |
|
323 | + 'class' => 'getpaid-refund-field', |
|
324 | + ), |
|
325 | + true |
|
326 | + ); |
|
327 | + ?> |
|
328 | 328 | <?php endif; ?> |
329 | 329 | </div> |
330 | 330 | <div class="modal-footer"> |
@@ -364,23 +364,23 @@ discard block |
||
364 | 364 | <?php |
365 | 365 | if ( $invoice->is_paid() ) { |
366 | 366 | |
367 | - printf( |
|
368 | - '<span class="bsui"><button type="button" class="button button-primary" data-toggle="modal" data-bs-toggle="modal" data-bs-target="#getpaid-refund-invoice-modal" data-target="#getpaid-refund-invoice-modal">%s</button></span>', |
|
369 | - esc_html__( 'Refund', 'invoicing' ) |
|
370 | - ); |
|
367 | + printf( |
|
368 | + '<span class="bsui"><button type="button" class="button button-primary" data-toggle="modal" data-bs-toggle="modal" data-bs-target="#getpaid-refund-invoice-modal" data-target="#getpaid-refund-invoice-modal">%s</button></span>', |
|
369 | + esc_html__( 'Refund', 'invoicing' ) |
|
370 | + ); |
|
371 | 371 | } elseif ( ! $invoice->is_refunded() ) { |
372 | - wpinv_item_dropdown( |
|
373 | - array( |
|
374 | - 'name' => 'wpinv_invoice_item', |
|
375 | - 'id' => 'wpinv_invoice_item', |
|
376 | - 'show_recurring' => true, |
|
377 | - 'class' => 'wpi_select2', |
|
378 | - ) |
|
379 | - ); |
|
380 | - |
|
381 | - echo ' ' . '<button type="button" class="button button-primary" id="wpinv-add-item">' . sprintf( esc_html__( 'Add item to %s', 'invoicing' ), esc_html( $invoice->get_label() ) ) . '</button>'; |
|
382 | - echo ' ' . '<button type="button" class="button button-primary" id="wpinv-new-item">' . esc_html__( 'Create new item', 'invoicing' ) . '</button>'; |
|
383 | - echo ' ' . '<button type="button" class="button button-primary wpinv-flr" id="wpinv-recalc-totals">' . esc_html__( 'Recalculate Totals', 'invoicing' ) . '</button>'; |
|
372 | + wpinv_item_dropdown( |
|
373 | + array( |
|
374 | + 'name' => 'wpinv_invoice_item', |
|
375 | + 'id' => 'wpinv_invoice_item', |
|
376 | + 'show_recurring' => true, |
|
377 | + 'class' => 'wpi_select2', |
|
378 | + ) |
|
379 | + ); |
|
380 | + |
|
381 | + echo ' ' . '<button type="button" class="button button-primary" id="wpinv-add-item">' . sprintf( esc_html__( 'Add item to %s', 'invoicing' ), esc_html( $invoice->get_label() ) ) . '</button>'; |
|
382 | + echo ' ' . '<button type="button" class="button button-primary" id="wpinv-new-item">' . esc_html__( 'Create new item', 'invoicing' ) . '</button>'; |
|
383 | + echo ' ' . '<button type="button" class="button button-primary wpinv-flr" id="wpinv-recalc-totals">' . esc_html__( 'Recalculate Totals', 'invoicing' ) . '</button>'; |
|
384 | 384 | |
385 | 385 | } |
386 | 386 | ?> |
@@ -397,72 +397,72 @@ discard block |
||
397 | 397 | <?php foreach ( array_keys( $columns ) as $column ) : ?> |
398 | 398 | <td class=" |
399 | 399 | <?php |
400 | - echo esc_attr( $column ); |
|
401 | - echo 'total' == $column || 'qty' == $column ? ' hide-if-amount' : ''; |
|
402 | - ?> |
|
400 | + echo esc_attr( $column ); |
|
401 | + echo 'total' == $column || 'qty' == $column ? ' hide-if-amount' : ''; |
|
402 | + ?> |
|
403 | 403 | "> |
404 | 404 | <?php |
405 | 405 | switch ( $column ) { |
406 | - case 'id': |
|
407 | - echo (int) $item->get_id(); |
|
408 | - break; |
|
409 | - case 'title': |
|
410 | - printf( |
|
411 | - '<a href="%s" target="_blank">%s</a>', |
|
412 | - esc_url( get_edit_post_link( $item->get_id() ) ), |
|
413 | - esc_html( $item->get_raw_name() ) |
|
414 | - ); |
|
415 | - |
|
416 | - $summary = apply_filters( 'getpaid_admin_invoice_line_item_summary', $item->get_description(), $item, $invoice ); |
|
417 | - if ( $summary !== '' ) { |
|
418 | - printf( |
|
419 | - '<span class="meta">%s</span>', |
|
420 | - wp_kses_post( wpautop( $summary ) ) |
|
421 | - ); |
|
422 | - } |
|
423 | - |
|
424 | - printf( |
|
425 | - '<input type="hidden" value="%s" name="getpaid_items[%s][name]" class="getpaid-recalculate-prices-on-change" />', |
|
426 | - esc_attr( $item->get_raw_name() ), |
|
427 | - (int) $item->get_id() |
|
428 | - ); |
|
429 | - |
|
430 | - printf( |
|
431 | - '<textarea style="display: none;" name="getpaid_items[%s][description]" class="getpaid-recalculate-prices-on-change">%s</textarea>', |
|
432 | - (int) $item->get_id(), |
|
433 | - esc_attr( $item->get_description() ) |
|
434 | - ); |
|
435 | - |
|
436 | - break; |
|
437 | - case 'price': |
|
438 | - printf( |
|
439 | - '<input type="text" value="%s" name="getpaid_items[%s][price]" style="width: 100px;" class="getpaid-admin-invoice-item-price getpaid-recalculate-prices-on-change" />', |
|
440 | - esc_attr( getpaid_unstandardize_amount( $item->get_price() ) ), |
|
441 | - (int) $item->get_id() |
|
442 | - ); |
|
443 | - |
|
444 | - break; |
|
445 | - case 'qty': |
|
446 | - printf( |
|
447 | - '<input type="text" style="width: 100px;" value="%s" name="getpaid_items[%s][quantity]" class="getpaid-admin-invoice-item-quantity getpaid-recalculate-prices-on-change" />', |
|
448 | - floatval( $item->get_quantity() ), |
|
449 | - (int) $item->get_id() |
|
450 | - ); |
|
451 | - |
|
452 | - break; |
|
453 | - case 'total': |
|
454 | - wpinv_the_price( $item->get_sub_total(), $invoice->get_currency() ); |
|
455 | - |
|
456 | - break; |
|
457 | - case 'tax': |
|
458 | - echo floatval( wpinv_round_amount( getpaid_get_invoice_tax_rate( $invoice, $item ), 2 ) ) . '%'; |
|
459 | - |
|
460 | - break; |
|
461 | - case 'action': |
|
462 | - if ( ! $invoice->is_paid() && ! $invoice->is_refunded() ) { |
|
463 | - echo '<i class="fa fa-trash wpinv-item-remove"></i>'; |
|
406 | + case 'id': |
|
407 | + echo (int) $item->get_id(); |
|
408 | + break; |
|
409 | + case 'title': |
|
410 | + printf( |
|
411 | + '<a href="%s" target="_blank">%s</a>', |
|
412 | + esc_url( get_edit_post_link( $item->get_id() ) ), |
|
413 | + esc_html( $item->get_raw_name() ) |
|
414 | + ); |
|
415 | + |
|
416 | + $summary = apply_filters( 'getpaid_admin_invoice_line_item_summary', $item->get_description(), $item, $invoice ); |
|
417 | + if ( $summary !== '' ) { |
|
418 | + printf( |
|
419 | + '<span class="meta">%s</span>', |
|
420 | + wp_kses_post( wpautop( $summary ) ) |
|
421 | + ); |
|
422 | + } |
|
423 | + |
|
424 | + printf( |
|
425 | + '<input type="hidden" value="%s" name="getpaid_items[%s][name]" class="getpaid-recalculate-prices-on-change" />', |
|
426 | + esc_attr( $item->get_raw_name() ), |
|
427 | + (int) $item->get_id() |
|
428 | + ); |
|
429 | + |
|
430 | + printf( |
|
431 | + '<textarea style="display: none;" name="getpaid_items[%s][description]" class="getpaid-recalculate-prices-on-change">%s</textarea>', |
|
432 | + (int) $item->get_id(), |
|
433 | + esc_attr( $item->get_description() ) |
|
434 | + ); |
|
435 | + |
|
436 | + break; |
|
437 | + case 'price': |
|
438 | + printf( |
|
439 | + '<input type="text" value="%s" name="getpaid_items[%s][price]" style="width: 100px;" class="getpaid-admin-invoice-item-price getpaid-recalculate-prices-on-change" />', |
|
440 | + esc_attr( getpaid_unstandardize_amount( $item->get_price() ) ), |
|
441 | + (int) $item->get_id() |
|
442 | + ); |
|
443 | + |
|
444 | + break; |
|
445 | + case 'qty': |
|
446 | + printf( |
|
447 | + '<input type="text" style="width: 100px;" value="%s" name="getpaid_items[%s][quantity]" class="getpaid-admin-invoice-item-quantity getpaid-recalculate-prices-on-change" />', |
|
448 | + floatval( $item->get_quantity() ), |
|
449 | + (int) $item->get_id() |
|
450 | + ); |
|
451 | + |
|
452 | + break; |
|
453 | + case 'total': |
|
454 | + wpinv_the_price( $item->get_sub_total(), $invoice->get_currency() ); |
|
455 | + |
|
456 | + break; |
|
457 | + case 'tax': |
|
458 | + echo floatval( wpinv_round_amount( getpaid_get_invoice_tax_rate( $invoice, $item ), 2 ) ) . '%'; |
|
459 | + |
|
460 | + break; |
|
461 | + case 'action': |
|
462 | + if ( ! $invoice->is_paid() && ! $invoice->is_refunded() ) { |
|
463 | + echo '<i class="fa fa-trash wpinv-item-remove"></i>'; |
|
464 | 464 | } |
465 | - break; |
|
465 | + break; |
|
466 | 466 | } |
467 | 467 | do_action( 'getpaid_admin_edit_invoice_item_' . $column, $item, $invoice ); |
468 | 468 | ?> |
@@ -473,10 +473,10 @@ discard block |
||
473 | 473 | } |
474 | 474 | |
475 | 475 | /** |
476 | - * Output the metabox. |
|
477 | - * |
|
478 | - * @param WP_Post $post |
|
479 | - */ |
|
476 | + * Output the metabox. |
|
477 | + * |
|
478 | + * @param WP_Post $post |
|
479 | + */ |
|
480 | 480 | public static function output2( $post ) { |
481 | 481 | |
482 | 482 | // Prepare the invoice. |
@@ -10,211 +10,211 @@ |
||
10 | 10 | */ |
11 | 11 | class GetPaid_PayPal_API { |
12 | 12 | |
13 | - /** |
|
14 | - * Retrieves the bearer token. |
|
15 | - * |
|
13 | + /** |
|
14 | + * Retrieves the bearer token. |
|
15 | + * |
|
16 | 16 | * @return string|\WP_Error |
17 | - */ |
|
18 | - public static function get_token( $mode = 'live' ) { |
|
17 | + */ |
|
18 | + public static function get_token( $mode = 'live' ) { |
|
19 | 19 | |
20 | - $token = get_transient( 'getpaid_paypal_' . $mode . '_token' ); |
|
20 | + $token = get_transient( 'getpaid_paypal_' . $mode . '_token' ); |
|
21 | 21 | |
22 | - if ( $token ) { |
|
23 | - return $token; |
|
24 | - } |
|
22 | + if ( $token ) { |
|
23 | + return $token; |
|
24 | + } |
|
25 | 25 | |
26 | - $client_id = 'live' === $mode ? wpinv_get_option( 'paypal_client_id' ) : wpinv_get_option( 'paypal_sandbox_client_id' ); |
|
27 | - $secret_key = 'live' === $mode ? wpinv_get_option( 'paypal_secret_key' ) : wpinv_get_option( 'paypal_sandbox_secret_key' ); |
|
28 | - $url = self::get_api_url( 'v1/oauth2/token?grant_type=client_credentials', $mode ); |
|
26 | + $client_id = 'live' === $mode ? wpinv_get_option( 'paypal_client_id' ) : wpinv_get_option( 'paypal_sandbox_client_id' ); |
|
27 | + $secret_key = 'live' === $mode ? wpinv_get_option( 'paypal_secret_key' ) : wpinv_get_option( 'paypal_sandbox_secret_key' ); |
|
28 | + $url = self::get_api_url( 'v1/oauth2/token?grant_type=client_credentials', $mode ); |
|
29 | 29 | |
30 | 30 | if ( empty( $client_id ) || empty( $secret_key ) ) { |
31 | 31 | return new \WP_Error( 'invalid_request', 'Missing client id or secret key.', array( 'status' => 400 ) ); |
32 | 32 | } |
33 | 33 | |
34 | - $args = array( |
|
35 | - 'method' => 'POST', |
|
36 | - 'timeout' => 30, |
|
37 | - 'headers' => array( |
|
38 | - 'Authorization' => 'Basic ' . base64_encode( $client_id . ':' . $secret_key ), // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.obfuscation_base64_encode |
|
39 | - 'Accept' => 'application/json', |
|
40 | - 'Content-Type' => 'application/x-www-form-urlencoded', |
|
41 | - ), |
|
42 | - ); |
|
43 | - |
|
44 | - $response = self::response_or_error( wp_remote_post( $url, $args ) ); |
|
45 | - |
|
46 | - if ( is_wp_error( $response ) ) { |
|
47 | - return $response; |
|
48 | - } |
|
49 | - |
|
50 | - if ( ! isset( $response->access_token ) ) { |
|
51 | - return new \WP_Error( 'invalid_request', 'Could not create token.', array( 'status' => 400 ) ); |
|
52 | - } |
|
53 | - |
|
54 | - set_transient( 'getpaid_paypal_' . $mode . '_token', $response->access_token, $response->expires_in - 600 ); |
|
55 | - return $response->access_token; |
|
56 | - } |
|
57 | - |
|
58 | - /** |
|
59 | - * Retrieves the PayPal API URL. |
|
60 | - * |
|
61 | - * @param string $endpoint |
|
62 | - * @return string |
|
63 | - */ |
|
64 | - public static function get_api_url( $endpoint = '', $mode = 'live' ) { |
|
65 | - $endpoint = ltrim( $endpoint, '/' ); |
|
66 | - return 'live' === $mode ? 'https://api-m.paypal.com/' . $endpoint : 'https://api-m.sandbox.paypal.com/' . $endpoint; |
|
67 | - } |
|
68 | - |
|
69 | - /** |
|
70 | - * Handles a post request. |
|
71 | - * |
|
72 | - * @param string $path The path to the endpoint. |
|
73 | - * @param mixed $data The data to send. |
|
74 | - * @param string $method The method to use. |
|
75 | - * |
|
76 | - * @return true|\WP_Error |
|
77 | - */ |
|
78 | - public static function post( $path, $data, $mode = 'live', $method = 'POST' ) { |
|
79 | - |
|
80 | - $access_token = self::get_token( $mode ); |
|
81 | - |
|
82 | - if ( is_wp_error( $access_token ) ) { |
|
83 | - return $access_token; |
|
84 | - } |
|
85 | - |
|
86 | - $url = self::get_api_url( $path, $mode ); |
|
87 | - $args = array( |
|
88 | - 'method' => $method, |
|
89 | - 'headers' => array( |
|
90 | - 'Authorization' => 'Bearer ' . $access_token, |
|
91 | - 'Content-Type' => 'application/json', |
|
92 | - ), |
|
93 | - 'body' => wp_json_encode( $data ), |
|
94 | - ); |
|
95 | - |
|
96 | - return self::response_or_error( wp_remote_post( $url, $args ) ); |
|
97 | - } |
|
98 | - |
|
99 | - /** |
|
100 | - * Handles a get request. |
|
101 | - * |
|
102 | - * @param string $path The path to the endpoint. |
|
103 | - * @param string $method |
|
104 | - * @return object|\WP_Error |
|
105 | - */ |
|
106 | - public static function get( $path, $mode = 'live', $method = 'GET' ) { |
|
107 | - |
|
108 | - $access_token = self::get_token( $mode ); |
|
109 | - |
|
110 | - if ( is_wp_error( $access_token ) ) { |
|
111 | - return $access_token; |
|
112 | - } |
|
113 | - |
|
114 | - $url = self::get_api_url( $path, $mode ); |
|
115 | - $args = array( |
|
116 | - 'method' => $method, |
|
117 | - 'headers' => array( |
|
118 | - 'Authorization' => 'Bearer ' . $access_token, |
|
119 | - ), |
|
120 | - ); |
|
121 | - |
|
122 | - return self::response_or_error( wp_remote_get( $url, $args ) ); |
|
123 | - } |
|
124 | - |
|
125 | - /** |
|
126 | - * Returns the response body |
|
127 | - * |
|
128 | - * @since 1.0.0 |
|
129 | - * @version 1.0.0 |
|
130 | - * @param \WP_Error|array $response |
|
131 | - * @return \WP_Error|object |
|
132 | - */ |
|
133 | - public static function response_or_error( $response ) { |
|
134 | - |
|
135 | - if ( is_wp_error( $response ) ) { |
|
136 | - return new \WP_Error( 'paypal_error', __( 'There was a problem connecting to the PayPal API endpoint.', 'invoicing' ) ); |
|
137 | - } |
|
138 | - |
|
139 | - if ( empty( $response['body'] ) ) { |
|
140 | - return true; |
|
141 | - } |
|
142 | - |
|
143 | - $response_body = json_decode( wp_remote_retrieve_body( $response ) ); |
|
144 | - |
|
145 | - if ( wp_remote_retrieve_response_code( $response ) > 299 ) { |
|
146 | - |
|
147 | - // Normal errors. |
|
148 | - if ( $response_body && isset( $response_body->message ) ) { |
|
149 | - $error_message = $response_body->message; |
|
150 | - |
|
151 | - // Identity errors. |
|
152 | - } elseif ( $response_body && isset( $response_body->error_description ) ) { |
|
153 | - $error_message = $response_body->error_description; |
|
154 | - return new \WP_Error( 'paypal_error', wp_kses_post( $response_body->error_description ) ); |
|
155 | - } else { |
|
156 | - $error_message = __( 'There was an error connecting to the PayPal API endpoint.', 'invoicing' ); |
|
157 | - } |
|
158 | - |
|
159 | - return new \WP_Error( 'paypal_error', $error_message ); |
|
160 | - } |
|
161 | - |
|
162 | - return $response_body; |
|
163 | - } |
|
164 | - |
|
165 | - /** |
|
166 | - * Fetches an order. |
|
167 | - * |
|
168 | - * @since 1.0.0 |
|
169 | - * @version 1.0.0 |
|
170 | - * @param string $order_id |
|
171 | - * @link https://developer.paypal.com/docs/api/orders/v2/#orders_get |
|
172 | - * @return \WP_Error|object |
|
173 | - */ |
|
174 | - public static function get_order( $order_id, $mode = 'live' ) { |
|
175 | - return self::get( '/v2/checkout/orders/' . $order_id, $mode ); |
|
176 | - } |
|
177 | - |
|
178 | - /** |
|
179 | - * Fetches a subscription. |
|
180 | - * |
|
181 | - * @since 1.0.0 |
|
182 | - * @version 1.0.0 |
|
183 | - * @param string $subscription_id |
|
184 | - * @link https://developer.paypal.com/docs/api/subscriptions/v1/#subscriptions_get |
|
185 | - * @return \WP_Error|object |
|
186 | - */ |
|
187 | - public static function get_subscription( $subscription_id, $mode = 'live' ) { |
|
188 | - return self::get( '/v1/billing/subscriptions/' . $subscription_id, $mode ); |
|
189 | - } |
|
190 | - |
|
191 | - /** |
|
192 | - * Fetches a subscription's latest transactions (limits search to last one day). |
|
193 | - * |
|
194 | - * @since 1.0.0 |
|
195 | - * @version 1.0.0 |
|
196 | - * @param string $subscription_id |
|
197 | - * @link https://developer.paypal.com/docs/api/subscriptions/v1/#subscriptions_transactions |
|
198 | - * @return \WP_Error|object |
|
199 | - */ |
|
200 | - public static function get_subscription_transaction( $subscription_id, $mode = 'live' ) { |
|
201 | - $start_time = gmdate( 'Y-m-d\TH:i:s\Z', strtotime( '-1 day' ) ); |
|
202 | - $end_time = gmdate( 'Y-m-d\TH:i:s\Z' ); |
|
203 | - return self::get( "/v1/billing/subscriptions/$subscription_id/transactions?start_time=$start_time&end_time=$end_time", $mode ); |
|
204 | - } |
|
205 | - |
|
206 | - /** |
|
207 | - * Refunds a capture. |
|
208 | - * |
|
209 | - * @since 1.0.0 |
|
210 | - * @version 1.0.0 |
|
211 | - * @param string $capture_id |
|
212 | - * @param array $args |
|
213 | - * @link https://developer.paypal.com/docs/api/payments/v2/#captures_refund |
|
214 | - * @return \WP_Error|object |
|
215 | - */ |
|
216 | - public static function refund_capture( $capture_id, $args = array(), $mode = 'live' ) { |
|
217 | - return self::post( '/v2/payments/captures/' . $capture_id . '/refund', $args, $mode ); |
|
218 | - } |
|
34 | + $args = array( |
|
35 | + 'method' => 'POST', |
|
36 | + 'timeout' => 30, |
|
37 | + 'headers' => array( |
|
38 | + 'Authorization' => 'Basic ' . base64_encode( $client_id . ':' . $secret_key ), // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.obfuscation_base64_encode |
|
39 | + 'Accept' => 'application/json', |
|
40 | + 'Content-Type' => 'application/x-www-form-urlencoded', |
|
41 | + ), |
|
42 | + ); |
|
43 | + |
|
44 | + $response = self::response_or_error( wp_remote_post( $url, $args ) ); |
|
45 | + |
|
46 | + if ( is_wp_error( $response ) ) { |
|
47 | + return $response; |
|
48 | + } |
|
49 | + |
|
50 | + if ( ! isset( $response->access_token ) ) { |
|
51 | + return new \WP_Error( 'invalid_request', 'Could not create token.', array( 'status' => 400 ) ); |
|
52 | + } |
|
53 | + |
|
54 | + set_transient( 'getpaid_paypal_' . $mode . '_token', $response->access_token, $response->expires_in - 600 ); |
|
55 | + return $response->access_token; |
|
56 | + } |
|
57 | + |
|
58 | + /** |
|
59 | + * Retrieves the PayPal API URL. |
|
60 | + * |
|
61 | + * @param string $endpoint |
|
62 | + * @return string |
|
63 | + */ |
|
64 | + public static function get_api_url( $endpoint = '', $mode = 'live' ) { |
|
65 | + $endpoint = ltrim( $endpoint, '/' ); |
|
66 | + return 'live' === $mode ? 'https://api-m.paypal.com/' . $endpoint : 'https://api-m.sandbox.paypal.com/' . $endpoint; |
|
67 | + } |
|
68 | + |
|
69 | + /** |
|
70 | + * Handles a post request. |
|
71 | + * |
|
72 | + * @param string $path The path to the endpoint. |
|
73 | + * @param mixed $data The data to send. |
|
74 | + * @param string $method The method to use. |
|
75 | + * |
|
76 | + * @return true|\WP_Error |
|
77 | + */ |
|
78 | + public static function post( $path, $data, $mode = 'live', $method = 'POST' ) { |
|
79 | + |
|
80 | + $access_token = self::get_token( $mode ); |
|
81 | + |
|
82 | + if ( is_wp_error( $access_token ) ) { |
|
83 | + return $access_token; |
|
84 | + } |
|
85 | + |
|
86 | + $url = self::get_api_url( $path, $mode ); |
|
87 | + $args = array( |
|
88 | + 'method' => $method, |
|
89 | + 'headers' => array( |
|
90 | + 'Authorization' => 'Bearer ' . $access_token, |
|
91 | + 'Content-Type' => 'application/json', |
|
92 | + ), |
|
93 | + 'body' => wp_json_encode( $data ), |
|
94 | + ); |
|
95 | + |
|
96 | + return self::response_or_error( wp_remote_post( $url, $args ) ); |
|
97 | + } |
|
98 | + |
|
99 | + /** |
|
100 | + * Handles a get request. |
|
101 | + * |
|
102 | + * @param string $path The path to the endpoint. |
|
103 | + * @param string $method |
|
104 | + * @return object|\WP_Error |
|
105 | + */ |
|
106 | + public static function get( $path, $mode = 'live', $method = 'GET' ) { |
|
107 | + |
|
108 | + $access_token = self::get_token( $mode ); |
|
109 | + |
|
110 | + if ( is_wp_error( $access_token ) ) { |
|
111 | + return $access_token; |
|
112 | + } |
|
113 | + |
|
114 | + $url = self::get_api_url( $path, $mode ); |
|
115 | + $args = array( |
|
116 | + 'method' => $method, |
|
117 | + 'headers' => array( |
|
118 | + 'Authorization' => 'Bearer ' . $access_token, |
|
119 | + ), |
|
120 | + ); |
|
121 | + |
|
122 | + return self::response_or_error( wp_remote_get( $url, $args ) ); |
|
123 | + } |
|
124 | + |
|
125 | + /** |
|
126 | + * Returns the response body |
|
127 | + * |
|
128 | + * @since 1.0.0 |
|
129 | + * @version 1.0.0 |
|
130 | + * @param \WP_Error|array $response |
|
131 | + * @return \WP_Error|object |
|
132 | + */ |
|
133 | + public static function response_or_error( $response ) { |
|
134 | + |
|
135 | + if ( is_wp_error( $response ) ) { |
|
136 | + return new \WP_Error( 'paypal_error', __( 'There was a problem connecting to the PayPal API endpoint.', 'invoicing' ) ); |
|
137 | + } |
|
138 | + |
|
139 | + if ( empty( $response['body'] ) ) { |
|
140 | + return true; |
|
141 | + } |
|
142 | + |
|
143 | + $response_body = json_decode( wp_remote_retrieve_body( $response ) ); |
|
144 | + |
|
145 | + if ( wp_remote_retrieve_response_code( $response ) > 299 ) { |
|
146 | + |
|
147 | + // Normal errors. |
|
148 | + if ( $response_body && isset( $response_body->message ) ) { |
|
149 | + $error_message = $response_body->message; |
|
150 | + |
|
151 | + // Identity errors. |
|
152 | + } elseif ( $response_body && isset( $response_body->error_description ) ) { |
|
153 | + $error_message = $response_body->error_description; |
|
154 | + return new \WP_Error( 'paypal_error', wp_kses_post( $response_body->error_description ) ); |
|
155 | + } else { |
|
156 | + $error_message = __( 'There was an error connecting to the PayPal API endpoint.', 'invoicing' ); |
|
157 | + } |
|
158 | + |
|
159 | + return new \WP_Error( 'paypal_error', $error_message ); |
|
160 | + } |
|
161 | + |
|
162 | + return $response_body; |
|
163 | + } |
|
164 | + |
|
165 | + /** |
|
166 | + * Fetches an order. |
|
167 | + * |
|
168 | + * @since 1.0.0 |
|
169 | + * @version 1.0.0 |
|
170 | + * @param string $order_id |
|
171 | + * @link https://developer.paypal.com/docs/api/orders/v2/#orders_get |
|
172 | + * @return \WP_Error|object |
|
173 | + */ |
|
174 | + public static function get_order( $order_id, $mode = 'live' ) { |
|
175 | + return self::get( '/v2/checkout/orders/' . $order_id, $mode ); |
|
176 | + } |
|
177 | + |
|
178 | + /** |
|
179 | + * Fetches a subscription. |
|
180 | + * |
|
181 | + * @since 1.0.0 |
|
182 | + * @version 1.0.0 |
|
183 | + * @param string $subscription_id |
|
184 | + * @link https://developer.paypal.com/docs/api/subscriptions/v1/#subscriptions_get |
|
185 | + * @return \WP_Error|object |
|
186 | + */ |
|
187 | + public static function get_subscription( $subscription_id, $mode = 'live' ) { |
|
188 | + return self::get( '/v1/billing/subscriptions/' . $subscription_id, $mode ); |
|
189 | + } |
|
190 | + |
|
191 | + /** |
|
192 | + * Fetches a subscription's latest transactions (limits search to last one day). |
|
193 | + * |
|
194 | + * @since 1.0.0 |
|
195 | + * @version 1.0.0 |
|
196 | + * @param string $subscription_id |
|
197 | + * @link https://developer.paypal.com/docs/api/subscriptions/v1/#subscriptions_transactions |
|
198 | + * @return \WP_Error|object |
|
199 | + */ |
|
200 | + public static function get_subscription_transaction( $subscription_id, $mode = 'live' ) { |
|
201 | + $start_time = gmdate( 'Y-m-d\TH:i:s\Z', strtotime( '-1 day' ) ); |
|
202 | + $end_time = gmdate( 'Y-m-d\TH:i:s\Z' ); |
|
203 | + return self::get( "/v1/billing/subscriptions/$subscription_id/transactions?start_time=$start_time&end_time=$end_time", $mode ); |
|
204 | + } |
|
205 | + |
|
206 | + /** |
|
207 | + * Refunds a capture. |
|
208 | + * |
|
209 | + * @since 1.0.0 |
|
210 | + * @version 1.0.0 |
|
211 | + * @param string $capture_id |
|
212 | + * @param array $args |
|
213 | + * @link https://developer.paypal.com/docs/api/payments/v2/#captures_refund |
|
214 | + * @return \WP_Error|object |
|
215 | + */ |
|
216 | + public static function refund_capture( $capture_id, $args = array(), $mode = 'live' ) { |
|
217 | + return self::post( '/v2/payments/captures/' . $capture_id . '/refund', $args, $mode ); |
|
218 | + } |
|
219 | 219 | |
220 | 220 | } |
@@ -13,199 +13,199 @@ |
||
13 | 13 | */ |
14 | 14 | class GetPaid_Tax { |
15 | 15 | |
16 | - /** |
|
17 | - * Calculates tax for a line item. |
|
18 | - * |
|
19 | - * @param float $price The price to calc tax on. |
|
20 | - * @param array $rates The rates to apply. |
|
21 | - * @param boolean $price_includes_tax Whether the passed price has taxes included. |
|
22 | - * @return array Array of tax name => tax amount. |
|
23 | - */ |
|
24 | - public static function calc_tax( $price, $rates, $price_includes_tax = false ) { |
|
25 | - |
|
26 | - if ( $price_includes_tax ) { |
|
27 | - $taxes = self::calc_inclusive_tax( $price, $rates ); |
|
28 | - } else { |
|
29 | - $taxes = self::calc_exclusive_tax( $price, $rates ); |
|
30 | - } |
|
31 | - |
|
32 | - return apply_filters( 'getpaid_calc_tax', $taxes, $price, $rates, $price_includes_tax ); |
|
33 | - |
|
34 | - } |
|
35 | - |
|
36 | - /** |
|
37 | - * Calc tax from inclusive price. |
|
38 | - * |
|
39 | - * @param float $price Price to calculate tax for. |
|
40 | - * @param array $rates Array of tax rates. |
|
41 | - * @return array |
|
42 | - */ |
|
43 | - public static function calc_inclusive_tax( $price, $rates ) { |
|
44 | - $taxes = array(); |
|
45 | - $tax_rates = wp_list_pluck( $rates, 'rate', 'name' ); |
|
46 | - |
|
47 | - // Add tax rates. |
|
48 | - $tax_rate = 1 + ( array_sum( $tax_rates ) / 100 ); |
|
49 | - |
|
50 | - foreach ( $tax_rates as $name => $rate ) { |
|
51 | - $the_rate = ( $rate / 100 ) / $tax_rate; |
|
52 | - $net_price = $price - ( $the_rate * $price ); |
|
53 | - $tax_amount = apply_filters( 'getpaid_price_inc_tax_amount', $price - $net_price, $name, $rate, $price ); |
|
54 | - $taxes[ $name ] = $tax_amount; |
|
55 | - } |
|
56 | - |
|
57 | - // Round all taxes to precision (4DP) before passing them back. |
|
58 | - $taxes = array_map( array( __CLASS__, 'round' ), $taxes ); |
|
59 | - |
|
60 | - return $taxes; |
|
61 | - } |
|
62 | - |
|
63 | - /** |
|
64 | - * Calc tax from exclusive price. |
|
65 | - * |
|
66 | - * @param float $price Price to calculate tax for. |
|
67 | - * @param array $rates Array of tax rates. |
|
68 | - * @return array |
|
69 | - */ |
|
70 | - public static function calc_exclusive_tax( $price, $rates ) { |
|
71 | - $taxes = array(); |
|
72 | - $tax_rates = wp_list_pluck( $rates, 'rate', 'name' ); |
|
73 | - |
|
74 | - foreach ( $tax_rates as $name => $rate ) { |
|
75 | - |
|
76 | - $tax_amount = $price * ( $rate / 100 ); |
|
77 | - $taxes[ $name ] = apply_filters( 'getpaid_price_ex_tax_amount', $tax_amount, $name, $rate, $price ); |
|
78 | - |
|
79 | - } |
|
80 | - |
|
81 | - // Round all taxes to precision (4DP) before passing them back. |
|
82 | - $taxes = array_map( array( __CLASS__, 'round' ), $taxes ); |
|
83 | - |
|
84 | - return $taxes; |
|
85 | - } |
|
86 | - |
|
87 | - /** |
|
88 | - * Get's an array of all tax rates. |
|
89 | - * |
|
90 | - * @return array |
|
91 | - */ |
|
92 | - public static function get_all_tax_rates() { |
|
93 | - |
|
94 | - $rates = get_option( 'wpinv_tax_rates', array() ); |
|
95 | - |
|
96 | - return apply_filters( |
|
97 | - 'getpaid_get_all_tax_rates', |
|
98 | - array_filter( wpinv_parse_list( $rates ) ) |
|
99 | - ); |
|
100 | - |
|
101 | - } |
|
102 | - |
|
103 | - /** |
|
104 | - * Get's an array of default tax rates. |
|
105 | - * |
|
106 | - * @return array |
|
107 | - */ |
|
108 | - public static function get_default_tax_rates() { |
|
109 | - |
|
110 | - return apply_filters( |
|
111 | - 'getpaid_get_default_tax_rates', |
|
112 | - array( |
|
113 | - array( |
|
114 | - 'country' => wpinv_get_default_country(), |
|
115 | - 'state' => wpinv_get_default_state(), |
|
116 | - 'global' => true, |
|
117 | - 'rate' => wpinv_get_default_tax_rate(), |
|
118 | - 'name' => __( 'Tax', 'invoicing' ), |
|
119 | - ), |
|
120 | - ) |
|
121 | - ); |
|
122 | - |
|
123 | - } |
|
124 | - |
|
125 | - /** |
|
126 | - * Get's an array of all tax rules. |
|
127 | - * |
|
128 | - * @return array |
|
129 | - */ |
|
130 | - public static function get_all_tax_rules() { |
|
131 | - |
|
132 | - $rules = get_option( |
|
133 | - 'wpinv_tax_rules', |
|
134 | - array( |
|
135 | - array( |
|
136 | - 'key' => 'physical', |
|
137 | - 'label' => __( 'Physical Item', 'invoicing' ), |
|
138 | - 'tax_base' => wpinv_get_option( 'tax_base', 'billing' ), |
|
139 | - 'same_country_rule' => wpinv_get_option( 'vat_same_country_rule', 'vat_too' ), |
|
140 | - ), |
|
141 | - array( |
|
142 | - 'key' => 'digital', |
|
143 | - 'label' => __( 'Digital Item', 'invoicing' ), |
|
144 | - 'tax_base' => wpinv_get_option( 'tax_base', 'billing' ), |
|
145 | - 'same_country_rule' => wpinv_get_option( 'vat_same_country_rule', 'vat_too' ), |
|
146 | - ), |
|
147 | - ) |
|
148 | - ); |
|
149 | - |
|
150 | - return apply_filters( |
|
151 | - 'getpaid_tax_rules', |
|
152 | - array_filter( array_values( wpinv_parse_list( $rules ) ) ) |
|
153 | - ); |
|
154 | - |
|
155 | - } |
|
156 | - |
|
157 | - /** |
|
158 | - * Get's an array of tax rates for a given address. |
|
159 | - * |
|
160 | - * @param string $country |
|
161 | - * @param string $state |
|
162 | - * @return array |
|
163 | - */ |
|
164 | - public static function get_address_tax_rates( $country, $state ) { |
|
165 | - |
|
166 | - $all_tax_rates = self::get_all_tax_rates(); |
|
167 | - $matching_rates = array_merge( |
|
168 | - wp_list_filter( $all_tax_rates, array( 'country' => $country ) ), |
|
169 | - wp_list_filter( $all_tax_rates, array( 'country' => '' ) ) |
|
170 | - ); |
|
171 | - |
|
172 | - foreach ( $matching_rates as $i => $rate ) { |
|
173 | - |
|
174 | - $states = array_filter( wpinv_clean( explode( ',', strtolower( $rate['state'] ) ) ) ); |
|
175 | - if ( empty( $rate['global'] ) && ! in_array( strtolower( $state ), $states ) ) { |
|
176 | - unset( $matching_rates[ $i ] ); |
|
177 | - } |
|
16 | + /** |
|
17 | + * Calculates tax for a line item. |
|
18 | + * |
|
19 | + * @param float $price The price to calc tax on. |
|
20 | + * @param array $rates The rates to apply. |
|
21 | + * @param boolean $price_includes_tax Whether the passed price has taxes included. |
|
22 | + * @return array Array of tax name => tax amount. |
|
23 | + */ |
|
24 | + public static function calc_tax( $price, $rates, $price_includes_tax = false ) { |
|
25 | + |
|
26 | + if ( $price_includes_tax ) { |
|
27 | + $taxes = self::calc_inclusive_tax( $price, $rates ); |
|
28 | + } else { |
|
29 | + $taxes = self::calc_exclusive_tax( $price, $rates ); |
|
30 | + } |
|
31 | + |
|
32 | + return apply_filters( 'getpaid_calc_tax', $taxes, $price, $rates, $price_includes_tax ); |
|
33 | + |
|
34 | + } |
|
35 | + |
|
36 | + /** |
|
37 | + * Calc tax from inclusive price. |
|
38 | + * |
|
39 | + * @param float $price Price to calculate tax for. |
|
40 | + * @param array $rates Array of tax rates. |
|
41 | + * @return array |
|
42 | + */ |
|
43 | + public static function calc_inclusive_tax( $price, $rates ) { |
|
44 | + $taxes = array(); |
|
45 | + $tax_rates = wp_list_pluck( $rates, 'rate', 'name' ); |
|
46 | + |
|
47 | + // Add tax rates. |
|
48 | + $tax_rate = 1 + ( array_sum( $tax_rates ) / 100 ); |
|
49 | + |
|
50 | + foreach ( $tax_rates as $name => $rate ) { |
|
51 | + $the_rate = ( $rate / 100 ) / $tax_rate; |
|
52 | + $net_price = $price - ( $the_rate * $price ); |
|
53 | + $tax_amount = apply_filters( 'getpaid_price_inc_tax_amount', $price - $net_price, $name, $rate, $price ); |
|
54 | + $taxes[ $name ] = $tax_amount; |
|
55 | + } |
|
56 | + |
|
57 | + // Round all taxes to precision (4DP) before passing them back. |
|
58 | + $taxes = array_map( array( __CLASS__, 'round' ), $taxes ); |
|
59 | + |
|
60 | + return $taxes; |
|
61 | + } |
|
62 | + |
|
63 | + /** |
|
64 | + * Calc tax from exclusive price. |
|
65 | + * |
|
66 | + * @param float $price Price to calculate tax for. |
|
67 | + * @param array $rates Array of tax rates. |
|
68 | + * @return array |
|
69 | + */ |
|
70 | + public static function calc_exclusive_tax( $price, $rates ) { |
|
71 | + $taxes = array(); |
|
72 | + $tax_rates = wp_list_pluck( $rates, 'rate', 'name' ); |
|
73 | + |
|
74 | + foreach ( $tax_rates as $name => $rate ) { |
|
75 | + |
|
76 | + $tax_amount = $price * ( $rate / 100 ); |
|
77 | + $taxes[ $name ] = apply_filters( 'getpaid_price_ex_tax_amount', $tax_amount, $name, $rate, $price ); |
|
78 | + |
|
79 | + } |
|
80 | + |
|
81 | + // Round all taxes to precision (4DP) before passing them back. |
|
82 | + $taxes = array_map( array( __CLASS__, 'round' ), $taxes ); |
|
83 | + |
|
84 | + return $taxes; |
|
85 | + } |
|
86 | + |
|
87 | + /** |
|
88 | + * Get's an array of all tax rates. |
|
89 | + * |
|
90 | + * @return array |
|
91 | + */ |
|
92 | + public static function get_all_tax_rates() { |
|
93 | + |
|
94 | + $rates = get_option( 'wpinv_tax_rates', array() ); |
|
95 | + |
|
96 | + return apply_filters( |
|
97 | + 'getpaid_get_all_tax_rates', |
|
98 | + array_filter( wpinv_parse_list( $rates ) ) |
|
99 | + ); |
|
100 | + |
|
101 | + } |
|
102 | + |
|
103 | + /** |
|
104 | + * Get's an array of default tax rates. |
|
105 | + * |
|
106 | + * @return array |
|
107 | + */ |
|
108 | + public static function get_default_tax_rates() { |
|
109 | + |
|
110 | + return apply_filters( |
|
111 | + 'getpaid_get_default_tax_rates', |
|
112 | + array( |
|
113 | + array( |
|
114 | + 'country' => wpinv_get_default_country(), |
|
115 | + 'state' => wpinv_get_default_state(), |
|
116 | + 'global' => true, |
|
117 | + 'rate' => wpinv_get_default_tax_rate(), |
|
118 | + 'name' => __( 'Tax', 'invoicing' ), |
|
119 | + ), |
|
120 | + ) |
|
121 | + ); |
|
122 | + |
|
123 | + } |
|
124 | + |
|
125 | + /** |
|
126 | + * Get's an array of all tax rules. |
|
127 | + * |
|
128 | + * @return array |
|
129 | + */ |
|
130 | + public static function get_all_tax_rules() { |
|
131 | + |
|
132 | + $rules = get_option( |
|
133 | + 'wpinv_tax_rules', |
|
134 | + array( |
|
135 | + array( |
|
136 | + 'key' => 'physical', |
|
137 | + 'label' => __( 'Physical Item', 'invoicing' ), |
|
138 | + 'tax_base' => wpinv_get_option( 'tax_base', 'billing' ), |
|
139 | + 'same_country_rule' => wpinv_get_option( 'vat_same_country_rule', 'vat_too' ), |
|
140 | + ), |
|
141 | + array( |
|
142 | + 'key' => 'digital', |
|
143 | + 'label' => __( 'Digital Item', 'invoicing' ), |
|
144 | + 'tax_base' => wpinv_get_option( 'tax_base', 'billing' ), |
|
145 | + 'same_country_rule' => wpinv_get_option( 'vat_same_country_rule', 'vat_too' ), |
|
146 | + ), |
|
147 | + ) |
|
148 | + ); |
|
149 | + |
|
150 | + return apply_filters( |
|
151 | + 'getpaid_tax_rules', |
|
152 | + array_filter( array_values( wpinv_parse_list( $rules ) ) ) |
|
153 | + ); |
|
154 | + |
|
155 | + } |
|
156 | + |
|
157 | + /** |
|
158 | + * Get's an array of tax rates for a given address. |
|
159 | + * |
|
160 | + * @param string $country |
|
161 | + * @param string $state |
|
162 | + * @return array |
|
163 | + */ |
|
164 | + public static function get_address_tax_rates( $country, $state ) { |
|
165 | + |
|
166 | + $all_tax_rates = self::get_all_tax_rates(); |
|
167 | + $matching_rates = array_merge( |
|
168 | + wp_list_filter( $all_tax_rates, array( 'country' => $country ) ), |
|
169 | + wp_list_filter( $all_tax_rates, array( 'country' => '' ) ) |
|
170 | + ); |
|
171 | + |
|
172 | + foreach ( $matching_rates as $i => $rate ) { |
|
173 | + |
|
174 | + $states = array_filter( wpinv_clean( explode( ',', strtolower( $rate['state'] ) ) ) ); |
|
175 | + if ( empty( $rate['global'] ) && ! in_array( strtolower( $state ), $states ) ) { |
|
176 | + unset( $matching_rates[ $i ] ); |
|
177 | + } |
|
178 | 178 | } |
179 | 179 | |
180 | - return apply_filters( 'getpaid_get_address_tax_rates', $matching_rates, $country, $state ); |
|
181 | - |
|
182 | - } |
|
183 | - |
|
184 | - /** |
|
185 | - * Sums a set of taxes to form a single total. Result is rounded to precision. |
|
186 | - * |
|
187 | - * @param array $taxes Array of taxes. |
|
188 | - * @return float |
|
189 | - */ |
|
190 | - public static function get_tax_total( $taxes ) { |
|
191 | - return self::round( array_sum( $taxes ) ); |
|
192 | - } |
|
193 | - |
|
194 | - /** |
|
195 | - * Round to precision. |
|
196 | - * |
|
197 | - * Filter example: to return rounding to .5 cents you'd use: |
|
198 | - * |
|
199 | - * function euro_5cent_rounding( $in ) { |
|
200 | - * return round( $in / 5, 2 ) * 5; |
|
201 | - * } |
|
202 | - * add_filter( 'getpaid_tax_round', 'euro_5cent_rounding' ); |
|
203 | - * |
|
204 | - * @param float|int $in Value to round. |
|
205 | - * @return float |
|
206 | - */ |
|
207 | - public static function round( $in ) { |
|
208 | - return apply_filters( 'getpaid_tax_round', round( $in, 4 ), $in ); |
|
209 | - } |
|
180 | + return apply_filters( 'getpaid_get_address_tax_rates', $matching_rates, $country, $state ); |
|
181 | + |
|
182 | + } |
|
183 | + |
|
184 | + /** |
|
185 | + * Sums a set of taxes to form a single total. Result is rounded to precision. |
|
186 | + * |
|
187 | + * @param array $taxes Array of taxes. |
|
188 | + * @return float |
|
189 | + */ |
|
190 | + public static function get_tax_total( $taxes ) { |
|
191 | + return self::round( array_sum( $taxes ) ); |
|
192 | + } |
|
193 | + |
|
194 | + /** |
|
195 | + * Round to precision. |
|
196 | + * |
|
197 | + * Filter example: to return rounding to .5 cents you'd use: |
|
198 | + * |
|
199 | + * function euro_5cent_rounding( $in ) { |
|
200 | + * return round( $in / 5, 2 ) * 5; |
|
201 | + * } |
|
202 | + * add_filter( 'getpaid_tax_round', 'euro_5cent_rounding' ); |
|
203 | + * |
|
204 | + * @param float|int $in Value to round. |
|
205 | + * @return float |
|
206 | + */ |
|
207 | + public static function round( $in ) { |
|
208 | + return apply_filters( 'getpaid_tax_round', round( $in, 4 ), $in ); |
|
209 | + } |
|
210 | 210 | |
211 | 211 | } |
@@ -12,301 +12,301 @@ |
||
12 | 12 | */ |
13 | 13 | class GetPaid_Payment_Form_Submission_Refresh_Prices { |
14 | 14 | |
15 | - /** |
|
16 | - * Contains the response for refreshing prices. |
|
17 | - * @var array |
|
18 | - */ |
|
19 | - public $response = array(); |
|
15 | + /** |
|
16 | + * Contains the response for refreshing prices. |
|
17 | + * @var array |
|
18 | + */ |
|
19 | + public $response = array(); |
|
20 | 20 | |
21 | 21 | /** |
22 | - * Class constructor |
|
23 | - * |
|
24 | - * @param GetPaid_Payment_Form_Submission $submission |
|
25 | - */ |
|
26 | - public function __construct( $submission ) { |
|
27 | - |
|
28 | - $this->response = array( |
|
29 | - 'submission_id' => $submission->id, |
|
22 | + * Class constructor |
|
23 | + * |
|
24 | + * @param GetPaid_Payment_Form_Submission $submission |
|
25 | + */ |
|
26 | + public function __construct( $submission ) { |
|
27 | + |
|
28 | + $this->response = array( |
|
29 | + 'submission_id' => $submission->id, |
|
30 | 30 | 'has_recurring' => $submission->has_recurring, |
31 | - 'has_subscription_group' => $submission->has_subscription_group(), |
|
32 | - 'has_multiple_subscription_groups' => $submission->has_multiple_subscription_groups(), |
|
31 | + 'has_subscription_group' => $submission->has_subscription_group(), |
|
32 | + 'has_multiple_subscription_groups' => $submission->has_multiple_subscription_groups(), |
|
33 | 33 | 'is_free' => ! $submission->should_collect_payment_details(), |
34 | - ); |
|
35 | - |
|
36 | - $payment_form = $submission->get_payment_form(); |
|
37 | - if ( ! empty( $payment_form->invoice ) ) { |
|
38 | - $this->response['invoice'] = $payment_form->invoice->get_id(); |
|
39 | - } |
|
40 | - |
|
41 | - $this->add_totals( $submission ); |
|
42 | - $this->add_texts( $submission ); |
|
43 | - $this->add_items( $submission ); |
|
44 | - $this->add_fees( $submission ); |
|
45 | - $this->add_discounts( $submission ); |
|
46 | - $this->add_taxes( $submission ); |
|
47 | - $this->add_gateways( $submission ); |
|
48 | - $this->add_data( $submission ); |
|
49 | - |
|
50 | - } |
|
51 | - |
|
52 | - /** |
|
53 | - * Adds totals to a response for submission refresh prices. |
|
54 | - * |
|
55 | - * @param GetPaid_Payment_Form_Submission $submission |
|
56 | - */ |
|
57 | - public function add_totals( $submission ) { |
|
58 | - |
|
59 | - $this->response = array_merge( |
|
60 | - $this->response, |
|
61 | - array( |
|
62 | - |
|
63 | - 'totals' => array( |
|
64 | - 'subtotal' => $submission->format_amount( $submission->get_subtotal() ), |
|
65 | - 'discount' => $submission->format_amount( $submission->get_discount() ), |
|
66 | - 'fees' => $submission->format_amount( $submission->get_fee() ), |
|
67 | - 'tax' => $submission->format_amount( $submission->get_tax() ), |
|
68 | - 'total' => $submission->format_amount( $submission->get_total() ), |
|
69 | - 'raw_total' => html_entity_decode( sanitize_text_field( $submission->format_amount( $submission->get_total() ) ), ENT_QUOTES ), |
|
70 | - ), |
|
71 | - |
|
72 | - 'recurring' => array( |
|
73 | - 'subtotal' => $submission->format_amount( $submission->get_recurring_subtotal() ), |
|
74 | - 'discount' => $submission->format_amount( $submission->get_recurring_discount() ), |
|
75 | - 'fees' => $submission->format_amount( $submission->get_recurring_fee() ), |
|
76 | - 'tax' => $submission->format_amount( $submission->get_recurring_tax() ), |
|
77 | - 'total' => $submission->format_amount( $submission->get_recurring_total() ), |
|
78 | - ), |
|
79 | - |
|
80 | - 'initial_amt' => wpinv_round_amount( $submission->get_total(), null, true ), |
|
81 | - 'currency' => $submission->get_currency(), |
|
82 | - |
|
83 | - ) |
|
84 | - ); |
|
85 | - |
|
86 | - } |
|
87 | - |
|
88 | - /** |
|
89 | - * Adds texts to a response for submission refresh prices. |
|
90 | - * |
|
91 | - * @param GetPaid_Payment_Form_Submission $submission |
|
92 | - */ |
|
93 | - public function add_texts( $submission ) { |
|
94 | - |
|
95 | - $payable = $submission->format_amount( $submission->get_total() ); |
|
96 | - $groups = getpaid_get_subscription_groups( $submission ); |
|
97 | - |
|
98 | - if ( $submission->has_recurring && 2 > count( $groups ) ) { |
|
99 | - |
|
100 | - $recurring = new WPInv_Item( $submission->has_recurring ); |
|
101 | - $period = getpaid_get_subscription_period_label( $recurring->get_recurring_period( true ), $recurring->get_recurring_interval(), '' ); |
|
102 | - $main_item = reset( $groups ); |
|
103 | - |
|
104 | - if ( $submission->get_total() == $submission->get_recurring_total() ) { |
|
105 | - $payable = "$payable / $period"; |
|
106 | - } elseif ( $main_item ) { |
|
107 | - |
|
108 | - $main_item = reset( $main_item ); |
|
109 | - |
|
110 | - // Calculate the next renewal date. |
|
111 | - $_period = $main_item->get_recurring_period( true ); |
|
112 | - $_interval = $main_item->get_recurring_interval(); |
|
113 | - |
|
114 | - // If the subscription item has a trial period... |
|
115 | - if ( $main_item->has_free_trial() ) { |
|
116 | - $_period = $main_item->get_trial_period( true ); |
|
117 | - $_interval = $main_item->get_trial_interval(); |
|
118 | - } |
|
119 | - |
|
120 | - $payable = sprintf( |
|
121 | - __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
122 | - $submission->format_amount( $submission->get_total() ), |
|
123 | - $submission->format_amount( $submission->get_recurring_total() ), |
|
124 | - $period |
|
125 | - ); |
|
126 | - |
|
127 | - $payable .= sprintf( |
|
128 | - '<small class="text-muted form-text">%s</small>', |
|
129 | - sprintf( |
|
130 | - __( 'First renewal on %s', 'invoicing' ), |
|
131 | - getpaid_format_date( date( 'Y-m-d H:i:s', strtotime( "+$_interval $_period", current_time( 'timestamp' ) ) ) ) |
|
132 | - ) |
|
133 | - ); |
|
134 | - |
|
135 | - } else { |
|
136 | - $payable = sprintf( |
|
137 | - __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
138 | - $submission->format_amount( $submission->get_total() ), |
|
139 | - $submission->format_amount( $submission->get_recurring_total() ), |
|
140 | - $period |
|
141 | - ); |
|
142 | - } |
|
143 | -} |
|
34 | + ); |
|
35 | + |
|
36 | + $payment_form = $submission->get_payment_form(); |
|
37 | + if ( ! empty( $payment_form->invoice ) ) { |
|
38 | + $this->response['invoice'] = $payment_form->invoice->get_id(); |
|
39 | + } |
|
40 | + |
|
41 | + $this->add_totals( $submission ); |
|
42 | + $this->add_texts( $submission ); |
|
43 | + $this->add_items( $submission ); |
|
44 | + $this->add_fees( $submission ); |
|
45 | + $this->add_discounts( $submission ); |
|
46 | + $this->add_taxes( $submission ); |
|
47 | + $this->add_gateways( $submission ); |
|
48 | + $this->add_data( $submission ); |
|
49 | + |
|
50 | + } |
|
51 | + |
|
52 | + /** |
|
53 | + * Adds totals to a response for submission refresh prices. |
|
54 | + * |
|
55 | + * @param GetPaid_Payment_Form_Submission $submission |
|
56 | + */ |
|
57 | + public function add_totals( $submission ) { |
|
58 | + |
|
59 | + $this->response = array_merge( |
|
60 | + $this->response, |
|
61 | + array( |
|
62 | + |
|
63 | + 'totals' => array( |
|
64 | + 'subtotal' => $submission->format_amount( $submission->get_subtotal() ), |
|
65 | + 'discount' => $submission->format_amount( $submission->get_discount() ), |
|
66 | + 'fees' => $submission->format_amount( $submission->get_fee() ), |
|
67 | + 'tax' => $submission->format_amount( $submission->get_tax() ), |
|
68 | + 'total' => $submission->format_amount( $submission->get_total() ), |
|
69 | + 'raw_total' => html_entity_decode( sanitize_text_field( $submission->format_amount( $submission->get_total() ) ), ENT_QUOTES ), |
|
70 | + ), |
|
71 | + |
|
72 | + 'recurring' => array( |
|
73 | + 'subtotal' => $submission->format_amount( $submission->get_recurring_subtotal() ), |
|
74 | + 'discount' => $submission->format_amount( $submission->get_recurring_discount() ), |
|
75 | + 'fees' => $submission->format_amount( $submission->get_recurring_fee() ), |
|
76 | + 'tax' => $submission->format_amount( $submission->get_recurring_tax() ), |
|
77 | + 'total' => $submission->format_amount( $submission->get_recurring_total() ), |
|
78 | + ), |
|
79 | + |
|
80 | + 'initial_amt' => wpinv_round_amount( $submission->get_total(), null, true ), |
|
81 | + 'currency' => $submission->get_currency(), |
|
82 | + |
|
83 | + ) |
|
84 | + ); |
|
85 | + |
|
86 | + } |
|
144 | 87 | |
145 | - $texts = array( |
|
146 | - '.getpaid-checkout-total-payable' => $payable, |
|
147 | - ); |
|
88 | + /** |
|
89 | + * Adds texts to a response for submission refresh prices. |
|
90 | + * |
|
91 | + * @param GetPaid_Payment_Form_Submission $submission |
|
92 | + */ |
|
93 | + public function add_texts( $submission ) { |
|
94 | + |
|
95 | + $payable = $submission->format_amount( $submission->get_total() ); |
|
96 | + $groups = getpaid_get_subscription_groups( $submission ); |
|
97 | + |
|
98 | + if ( $submission->has_recurring && 2 > count( $groups ) ) { |
|
99 | + |
|
100 | + $recurring = new WPInv_Item( $submission->has_recurring ); |
|
101 | + $period = getpaid_get_subscription_period_label( $recurring->get_recurring_period( true ), $recurring->get_recurring_interval(), '' ); |
|
102 | + $main_item = reset( $groups ); |
|
103 | + |
|
104 | + if ( $submission->get_total() == $submission->get_recurring_total() ) { |
|
105 | + $payable = "$payable / $period"; |
|
106 | + } elseif ( $main_item ) { |
|
107 | + |
|
108 | + $main_item = reset( $main_item ); |
|
109 | + |
|
110 | + // Calculate the next renewal date. |
|
111 | + $_period = $main_item->get_recurring_period( true ); |
|
112 | + $_interval = $main_item->get_recurring_interval(); |
|
113 | + |
|
114 | + // If the subscription item has a trial period... |
|
115 | + if ( $main_item->has_free_trial() ) { |
|
116 | + $_period = $main_item->get_trial_period( true ); |
|
117 | + $_interval = $main_item->get_trial_interval(); |
|
118 | + } |
|
119 | + |
|
120 | + $payable = sprintf( |
|
121 | + __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
122 | + $submission->format_amount( $submission->get_total() ), |
|
123 | + $submission->format_amount( $submission->get_recurring_total() ), |
|
124 | + $period |
|
125 | + ); |
|
126 | + |
|
127 | + $payable .= sprintf( |
|
128 | + '<small class="text-muted form-text">%s</small>', |
|
129 | + sprintf( |
|
130 | + __( 'First renewal on %s', 'invoicing' ), |
|
131 | + getpaid_format_date( date( 'Y-m-d H:i:s', strtotime( "+$_interval $_period", current_time( 'timestamp' ) ) ) ) |
|
132 | + ) |
|
133 | + ); |
|
134 | + |
|
135 | + } else { |
|
136 | + $payable = sprintf( |
|
137 | + __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
138 | + $submission->format_amount( $submission->get_total() ), |
|
139 | + $submission->format_amount( $submission->get_recurring_total() ), |
|
140 | + $period |
|
141 | + ); |
|
142 | + } |
|
143 | +} |
|
148 | 144 | |
149 | - foreach ( $submission->get_items() as $item ) { |
|
150 | - $item_id = $item->get_id(); |
|
151 | - $initial_price = $submission->format_amount( $item->get_sub_total() - $item->item_discount ); |
|
152 | - $recurring_price = $submission->format_amount( $item->get_recurring_sub_total() - $item->recurring_item_discount ); |
|
153 | - $texts[ ".item-$item_id .getpaid-form-item-price-desc" ] = getpaid_item_recurring_price_help_text( $item, $submission->get_currency(), $initial_price, $recurring_price ); |
|
154 | - $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = sprintf( __( 'Subtotal: %s', 'invoicing' ), $submission->format_amount( $item->get_sub_total() ) ); |
|
145 | + $texts = array( |
|
146 | + '.getpaid-checkout-total-payable' => $payable, |
|
147 | + ); |
|
155 | 148 | |
156 | - if ( $item->get_quantity() == 1 ) { |
|
157 | - $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = ''; |
|
158 | - } |
|
149 | + foreach ( $submission->get_items() as $item ) { |
|
150 | + $item_id = $item->get_id(); |
|
151 | + $initial_price = $submission->format_amount( $item->get_sub_total() - $item->item_discount ); |
|
152 | + $recurring_price = $submission->format_amount( $item->get_recurring_sub_total() - $item->recurring_item_discount ); |
|
153 | + $texts[ ".item-$item_id .getpaid-form-item-price-desc" ] = getpaid_item_recurring_price_help_text( $item, $submission->get_currency(), $initial_price, $recurring_price ); |
|
154 | + $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = sprintf( __( 'Subtotal: %s', 'invoicing' ), $submission->format_amount( $item->get_sub_total() ) ); |
|
155 | + |
|
156 | + if ( $item->get_quantity() == 1 ) { |
|
157 | + $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = ''; |
|
158 | + } |
|
159 | 159 | } |
160 | 160 | |
161 | - $this->response = array_merge( $this->response, array( 'texts' => $texts ) ); |
|
161 | + $this->response = array_merge( $this->response, array( 'texts' => $texts ) ); |
|
162 | 162 | |
163 | - } |
|
163 | + } |
|
164 | 164 | |
165 | - /** |
|
166 | - * Adds items to a response for submission refresh prices. |
|
167 | - * |
|
168 | - * @param GetPaid_Payment_Form_Submission $submission |
|
169 | - */ |
|
170 | - public function add_items( $submission ) { |
|
165 | + /** |
|
166 | + * Adds items to a response for submission refresh prices. |
|
167 | + * |
|
168 | + * @param GetPaid_Payment_Form_Submission $submission |
|
169 | + */ |
|
170 | + public function add_items( $submission ) { |
|
171 | 171 | |
172 | - // Add items. |
|
173 | - $items = array(); |
|
174 | - $selected_items = array(); |
|
172 | + // Add items. |
|
173 | + $items = array(); |
|
174 | + $selected_items = array(); |
|
175 | 175 | |
176 | 176 | foreach ( $submission->get_items() as $item ) { |
177 | - $item_id = $item->get_id(); |
|
178 | - $items[ "$item_id" ] = $submission->format_amount( $item->get_sub_total() ); |
|
179 | - |
|
180 | - $selected_items[ "$item_id" ] = array( |
|
181 | - 'quantity' => $item->get_quantity(), |
|
182 | - 'price' => $item->get_price(), |
|
183 | - 'price_fmt' => $submission->format_amount( $item->get_price() ), |
|
184 | - ); |
|
185 | - } |
|
186 | - |
|
187 | - $this->response = array_merge( |
|
188 | - $this->response, |
|
189 | - array( |
|
190 | - 'items' => $items, |
|
191 | - 'selected_items' => $selected_items, |
|
192 | - ) |
|
193 | - ); |
|
194 | - |
|
195 | - } |
|
196 | - |
|
197 | - /** |
|
198 | - * Adds fees to a response for submission refresh prices. |
|
199 | - * |
|
200 | - * @param GetPaid_Payment_Form_Submission $submission |
|
201 | - */ |
|
202 | - public function add_fees( $submission ) { |
|
203 | - |
|
204 | - $fees = array(); |
|
177 | + $item_id = $item->get_id(); |
|
178 | + $items[ "$item_id" ] = $submission->format_amount( $item->get_sub_total() ); |
|
179 | + |
|
180 | + $selected_items[ "$item_id" ] = array( |
|
181 | + 'quantity' => $item->get_quantity(), |
|
182 | + 'price' => $item->get_price(), |
|
183 | + 'price_fmt' => $submission->format_amount( $item->get_price() ), |
|
184 | + ); |
|
185 | + } |
|
186 | + |
|
187 | + $this->response = array_merge( |
|
188 | + $this->response, |
|
189 | + array( |
|
190 | + 'items' => $items, |
|
191 | + 'selected_items' => $selected_items, |
|
192 | + ) |
|
193 | + ); |
|
194 | + |
|
195 | + } |
|
196 | + |
|
197 | + /** |
|
198 | + * Adds fees to a response for submission refresh prices. |
|
199 | + * |
|
200 | + * @param GetPaid_Payment_Form_Submission $submission |
|
201 | + */ |
|
202 | + public function add_fees( $submission ) { |
|
203 | + |
|
204 | + $fees = array(); |
|
205 | 205 | |
206 | 206 | foreach ( $submission->get_fees() as $name => $data ) { |
207 | - $fees[ $name ] = $submission->format_amount( $data['initial_fee'] ); |
|
208 | - } |
|
207 | + $fees[ $name ] = $submission->format_amount( $data['initial_fee'] ); |
|
208 | + } |
|
209 | 209 | |
210 | - $this->response = array_merge( |
|
211 | - $this->response, |
|
212 | - array( 'fees' => $fees ) |
|
213 | - ); |
|
210 | + $this->response = array_merge( |
|
211 | + $this->response, |
|
212 | + array( 'fees' => $fees ) |
|
213 | + ); |
|
214 | 214 | |
215 | - } |
|
215 | + } |
|
216 | 216 | |
217 | - /** |
|
218 | - * Adds discounts to a response for submission refresh prices. |
|
219 | - * |
|
220 | - * @param GetPaid_Payment_Form_Submission $submission |
|
221 | - */ |
|
222 | - public function add_discounts( $submission ) { |
|
217 | + /** |
|
218 | + * Adds discounts to a response for submission refresh prices. |
|
219 | + * |
|
220 | + * @param GetPaid_Payment_Form_Submission $submission |
|
221 | + */ |
|
222 | + public function add_discounts( $submission ) { |
|
223 | 223 | |
224 | - $discounts = array(); |
|
224 | + $discounts = array(); |
|
225 | 225 | |
226 | 226 | foreach ( $submission->get_discounts() as $name => $data ) { |
227 | - $discounts[ $name ] = $submission->format_amount( $data['initial_discount'] ); |
|
228 | - } |
|
229 | - |
|
230 | - $this->response = array_merge( |
|
231 | - $this->response, |
|
232 | - array( 'discounts' => $discounts ) |
|
233 | - ); |
|
227 | + $discounts[ $name ] = $submission->format_amount( $data['initial_discount'] ); |
|
228 | + } |
|
234 | 229 | |
235 | - } |
|
230 | + $this->response = array_merge( |
|
231 | + $this->response, |
|
232 | + array( 'discounts' => $discounts ) |
|
233 | + ); |
|
236 | 234 | |
237 | - /** |
|
238 | - * Adds taxes to a response for submission refresh prices. |
|
239 | - * |
|
240 | - * @param GetPaid_Payment_Form_Submission $submission |
|
241 | - */ |
|
242 | - public function add_taxes( $submission ) { |
|
235 | + } |
|
243 | 236 | |
244 | - $taxes = array(); |
|
245 | - $markup = ''; |
|
237 | + /** |
|
238 | + * Adds taxes to a response for submission refresh prices. |
|
239 | + * |
|
240 | + * @param GetPaid_Payment_Form_Submission $submission |
|
241 | + */ |
|
242 | + public function add_taxes( $submission ) { |
|
243 | + |
|
244 | + $taxes = array(); |
|
245 | + $markup = ''; |
|
246 | 246 | foreach ( $submission->get_taxes() as $name => $data ) { |
247 | - $name = sanitize_text_field( $name ); |
|
248 | - $amount = $submission->format_amount( $data['initial_tax'] ); |
|
249 | - $taxes[ $name ] = $amount; |
|
250 | - $markup .= "<small class='form-text'>$name : $amount</small>"; |
|
251 | - } |
|
252 | - |
|
253 | - $this->response = array_merge( |
|
254 | - $this->response, |
|
255 | - array( 'taxes' => $taxes ) |
|
256 | - ); |
|
257 | - |
|
258 | - } |
|
259 | - |
|
260 | - /** |
|
261 | - * Adds gateways to a response for submission refresh prices. |
|
262 | - * |
|
263 | - * @param GetPaid_Payment_Form_Submission $submission |
|
264 | - */ |
|
265 | - public function add_gateways( $submission ) { |
|
266 | - |
|
267 | - $gateways = array_keys( wpinv_get_enabled_payment_gateways() ); |
|
268 | - |
|
269 | - if ( $this->response['has_recurring'] ) { |
|
270 | - |
|
271 | - foreach ( $gateways as $i => $gateway ) { |
|
272 | - |
|
273 | - if ( |
|
274 | - ! getpaid_payment_gateway_supports( $gateway, 'subscription' ) |
|
275 | - || ( $this->response['has_subscription_group'] && ! getpaid_payment_gateway_supports( $gateway, 'single_subscription_group' ) ) |
|
276 | - || ( $this->response['has_multiple_subscription_groups'] && ! getpaid_payment_gateway_supports( $gateway, 'multiple_subscription_groups' ) ) ) { |
|
277 | - unset( $gateways[ $i ] ); |
|
278 | - } |
|
247 | + $name = sanitize_text_field( $name ); |
|
248 | + $amount = $submission->format_amount( $data['initial_tax'] ); |
|
249 | + $taxes[ $name ] = $amount; |
|
250 | + $markup .= "<small class='form-text'>$name : $amount</small>"; |
|
251 | + } |
|
252 | + |
|
253 | + $this->response = array_merge( |
|
254 | + $this->response, |
|
255 | + array( 'taxes' => $taxes ) |
|
256 | + ); |
|
257 | + |
|
258 | + } |
|
259 | + |
|
260 | + /** |
|
261 | + * Adds gateways to a response for submission refresh prices. |
|
262 | + * |
|
263 | + * @param GetPaid_Payment_Form_Submission $submission |
|
264 | + */ |
|
265 | + public function add_gateways( $submission ) { |
|
266 | + |
|
267 | + $gateways = array_keys( wpinv_get_enabled_payment_gateways() ); |
|
268 | + |
|
269 | + if ( $this->response['has_recurring'] ) { |
|
270 | + |
|
271 | + foreach ( $gateways as $i => $gateway ) { |
|
272 | + |
|
273 | + if ( |
|
274 | + ! getpaid_payment_gateway_supports( $gateway, 'subscription' ) |
|
275 | + || ( $this->response['has_subscription_group'] && ! getpaid_payment_gateway_supports( $gateway, 'single_subscription_group' ) ) |
|
276 | + || ( $this->response['has_multiple_subscription_groups'] && ! getpaid_payment_gateway_supports( $gateway, 'multiple_subscription_groups' ) ) ) { |
|
277 | + unset( $gateways[ $i ] ); |
|
278 | + } |
|
279 | 279 | } |
280 | 280 | } |
281 | 281 | |
282 | - $gateways = apply_filters( 'getpaid_submission_gateways', $gateways, $submission ); |
|
283 | - $this->response = array_merge( |
|
284 | - $this->response, |
|
285 | - array( 'gateways' => $gateways ) |
|
286 | - ); |
|
287 | - |
|
288 | - } |
|
289 | - |
|
290 | - /** |
|
291 | - * Adds data to a response for submission refresh prices. |
|
292 | - * |
|
293 | - * @param GetPaid_Payment_Form_Submission $submission |
|
294 | - */ |
|
295 | - public function add_data( $submission ) { |
|
296 | - |
|
297 | - $this->response = array_merge( |
|
298 | - $this->response, |
|
299 | - array( |
|
300 | - 'js_data' => apply_filters( |
|
301 | - 'getpaid_submission_js_data', |
|
302 | - array( |
|
303 | - 'is_recurring' => $this->response['has_recurring'], |
|
304 | - ), |
|
305 | - $submission |
|
306 | - ), |
|
307 | - ) |
|
308 | - ); |
|
309 | - |
|
310 | - } |
|
282 | + $gateways = apply_filters( 'getpaid_submission_gateways', $gateways, $submission ); |
|
283 | + $this->response = array_merge( |
|
284 | + $this->response, |
|
285 | + array( 'gateways' => $gateways ) |
|
286 | + ); |
|
287 | + |
|
288 | + } |
|
289 | + |
|
290 | + /** |
|
291 | + * Adds data to a response for submission refresh prices. |
|
292 | + * |
|
293 | + * @param GetPaid_Payment_Form_Submission $submission |
|
294 | + */ |
|
295 | + public function add_data( $submission ) { |
|
296 | + |
|
297 | + $this->response = array_merge( |
|
298 | + $this->response, |
|
299 | + array( |
|
300 | + 'js_data' => apply_filters( |
|
301 | + 'getpaid_submission_js_data', |
|
302 | + array( |
|
303 | + 'is_recurring' => $this->response['has_recurring'], |
|
304 | + ), |
|
305 | + $submission |
|
306 | + ), |
|
307 | + ) |
|
308 | + ); |
|
309 | + |
|
310 | + } |
|
311 | 311 | |
312 | 312 | } |
@@ -16,502 +16,502 @@ |
||
16 | 16 | */ |
17 | 17 | class GetPaid_Customers_Query { |
18 | 18 | |
19 | - /** |
|
20 | - * Query vars, after parsing |
|
21 | - * |
|
22 | - * @since 1.0.19 |
|
23 | - * @var array |
|
24 | - */ |
|
25 | - public $query_vars = array(); |
|
26 | - |
|
27 | - /** |
|
28 | - * List of found customers. |
|
29 | - * |
|
30 | - * @since 1.0.19 |
|
31 | - * @var array |
|
32 | - */ |
|
33 | - private $results; |
|
34 | - |
|
35 | - /** |
|
36 | - * Total number of found customers for the current query |
|
37 | - * |
|
38 | - * @since 1.0.19 |
|
39 | - * @var int |
|
40 | - */ |
|
41 | - private $total_customers = 0; |
|
42 | - |
|
43 | - /** |
|
44 | - * The SQL query used to fetch matching customers. |
|
45 | - * |
|
46 | - * @since 1.0.19 |
|
47 | - * @var string |
|
48 | - */ |
|
49 | - public $request; |
|
50 | - |
|
51 | - // SQL clauses |
|
52 | - |
|
53 | - /** |
|
54 | - * Contains the 'FIELDS' sql clause |
|
55 | - * |
|
56 | - * @since 1.0.19 |
|
57 | - * @var string |
|
58 | - */ |
|
59 | - public $query_fields; |
|
60 | - |
|
61 | - /** |
|
62 | - * Contains the 'FROM' sql clause |
|
63 | - * |
|
64 | - * @since 1.0.19 |
|
65 | - * @var string |
|
66 | - */ |
|
67 | - public $query_from; |
|
68 | - |
|
69 | - /** |
|
70 | - * Contains the 'WHERE' sql clause |
|
71 | - * |
|
72 | - * @since 1.0.19 |
|
73 | - * @var string |
|
74 | - */ |
|
75 | - public $query_where; |
|
76 | - |
|
77 | - /** |
|
78 | - * Contains the 'ORDER BY' sql clause |
|
79 | - * |
|
80 | - * @since 1.0.19 |
|
81 | - * @var string |
|
82 | - */ |
|
83 | - public $query_orderby; |
|
84 | - |
|
85 | - /** |
|
86 | - * Contains the 'LIMIT' sql clause |
|
87 | - * |
|
88 | - * @since 1.0.19 |
|
89 | - * @var string |
|
90 | - */ |
|
91 | - public $query_limit; |
|
92 | - |
|
93 | - /** |
|
94 | - * Class constructor. |
|
95 | - * |
|
96 | - * @since 1.0.19 |
|
97 | - * |
|
98 | - * @param null|string|array $query Optional. The query variables. |
|
99 | - */ |
|
100 | - public function __construct( $query = null ) { |
|
101 | - if ( ! is_null( $query ) ) { |
|
102 | - $this->prepare_query( $query ); |
|
103 | - $this->query(); |
|
104 | - } |
|
105 | - } |
|
106 | - |
|
107 | - /** |
|
108 | - * Fills in missing query variables with default values. |
|
109 | - * |
|
110 | - * @since 1.0.19 |
|
111 | - * |
|
112 | - * @param string|array $args Query vars, as passed to `GetPaid_Subscriptions_Query`. |
|
113 | - * @return array Complete query variables with undefined ones filled in with defaults. |
|
114 | - */ |
|
115 | - public static function fill_query_vars( $args ) { |
|
116 | - $defaults = array( |
|
117 | - 'include' => array(), |
|
118 | - 'exclude' => array(), |
|
119 | - 'orderby' => 'id', |
|
120 | - 'order' => 'DESC', |
|
121 | - 'offset' => '', |
|
122 | - 'number' => 10, |
|
123 | - 'paged' => 1, |
|
124 | - 'count_total' => true, |
|
125 | - 'fields' => 'all', |
|
126 | - 's' => '', |
|
127 | - ); |
|
128 | - |
|
129 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
130 | - $defaults[ $field ] = 'any'; |
|
131 | - |
|
132 | - if ( '%f' === $type || '%d' === $type ) { |
|
133 | - $defaults[ $field . '_min' ] = ''; |
|
134 | - $defaults[ $field . '_max' ] = ''; |
|
135 | - } |
|
136 | - } |
|
137 | - |
|
138 | - return wp_parse_args( $args, $defaults ); |
|
139 | - } |
|
140 | - |
|
141 | - /** |
|
142 | - * Prepare the query variables. |
|
143 | - * |
|
144 | - * @since 1.0.19 |
|
145 | - * |
|
146 | - * @see self::fill_query_vars() For allowede args and their defaults. |
|
147 | - */ |
|
148 | - public function prepare_query( $query = array() ) { |
|
149 | - global $wpdb; |
|
150 | - |
|
151 | - if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
152 | - $this->query_limit = null; |
|
153 | - $this->query_vars = $this->fill_query_vars( $query ); |
|
154 | - } |
|
155 | - |
|
156 | - if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
157 | - $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
158 | - } |
|
159 | - |
|
160 | - do_action( 'getpaid_pre_get_customers', array( &$this ) ); |
|
161 | - |
|
162 | - // Ensure that query vars are filled after 'getpaid_pre_get_customers'. |
|
163 | - $qv = & $this->query_vars; |
|
164 | - $qv = $this->fill_query_vars( $qv ); |
|
165 | - $table = $wpdb->prefix . 'getpaid_customers'; |
|
166 | - $this->query_from = "FROM $table"; |
|
167 | - |
|
168 | - // Prepare query fields. |
|
169 | - $this->prepare_query_fields( $qv, $table ); |
|
170 | - |
|
171 | - // Prepare query where. |
|
172 | - $this->prepare_query_where( $qv, $table ); |
|
173 | - |
|
174 | - // Prepare query order. |
|
175 | - $this->prepare_query_order( $qv, $table ); |
|
176 | - |
|
177 | - // limit |
|
178 | - if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
179 | - if ( $qv['offset'] ) { |
|
180 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
181 | - } else { |
|
182 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
183 | - } |
|
184 | - } |
|
185 | - |
|
186 | - do_action_ref_array( 'getpaid_after_customers_query', array( &$this ) ); |
|
187 | - } |
|
188 | - |
|
189 | - /** |
|
190 | - * Prepares the query fields. |
|
191 | - * |
|
192 | - * @since 1.0.19 |
|
193 | - * |
|
194 | - * @param array $qv Query vars. |
|
195 | - * @param string $table Table name. |
|
196 | - */ |
|
197 | - protected function prepare_query_fields( &$qv, $table ) { |
|
198 | - |
|
199 | - if ( is_array( $qv['fields'] ) ) { |
|
200 | - $qv['fields'] = array_unique( $qv['fields'] ); |
|
201 | - $allowed_fields = array_keys( GetPaid_Customer_Data_Store::get_database_fields() ); |
|
202 | - |
|
203 | - $query_fields = array(); |
|
204 | - foreach ( $qv['fields'] as $field ) { |
|
205 | - if ( ! in_array( $field, $allowed_fields ) ) { |
|
206 | - continue; |
|
207 | - } |
|
208 | - |
|
209 | - $field = sanitize_key( $field ); |
|
210 | - $query_fields[] = "$table.`$field`"; |
|
211 | - } |
|
212 | - $this->query_fields = implode( ',', $query_fields ); |
|
213 | - } else { |
|
214 | - $this->query_fields = "$table.*"; |
|
215 | - } |
|
216 | - |
|
217 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
218 | - $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
219 | - } |
|
220 | - |
|
221 | - } |
|
222 | - |
|
223 | - /** |
|
224 | - * Prepares the query where. |
|
225 | - * |
|
226 | - * @since 1.0.19 |
|
227 | - * |
|
228 | - * @param array $qv Query vars. |
|
229 | - * @param string $table Table name. |
|
230 | - */ |
|
231 | - protected function prepare_query_where( &$qv, $table ) { |
|
232 | - global $wpdb; |
|
233 | - $this->query_where = 'WHERE 1=1'; |
|
234 | - |
|
235 | - // Fields. |
|
236 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
237 | - if ( 'any' !== $qv[ $field ] ) { |
|
238 | - |
|
239 | - // In. |
|
240 | - if ( is_array( $qv[ $field ] ) ) { |
|
241 | - $in = join( ',', array_fill( 0, count( $qv[ $field ] ), $type ) ); |
|
242 | - $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $in )", $qv[ $field ] ); |
|
243 | - } elseif ( ! empty( $qv[ $field ] ) ) { |
|
244 | - $this->query_where .= $wpdb->prepare( " AND $table.`$field` = $type", $qv[ $field ] ); |
|
245 | - } |
|
246 | - } |
|
247 | - |
|
248 | - // Min/Max. |
|
249 | - if ( '%f' === $type || '%d' === $type ) { |
|
250 | - |
|
251 | - // Min. |
|
252 | - if ( is_numeric( $qv[ $field . '_min' ] ) ) { |
|
253 | - $this->query_where .= $wpdb->prepare( " AND $table.`$field` >= $type", $qv[ $field . '_min' ] ); |
|
254 | - } |
|
255 | - |
|
256 | - // Max. |
|
257 | - if ( is_numeric( $qv[ $field . '_max' ] ) ) { |
|
258 | - $this->query_where .= $wpdb->prepare( " AND $table.`$field` <= $type", $qv[ $field . '_max' ] ); |
|
259 | - } |
|
260 | - } |
|
261 | - } |
|
262 | - |
|
263 | - if ( ! empty( $qv['include'] ) ) { |
|
264 | - $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
265 | - $this->query_where .= " AND $table.`id` IN ($include)"; |
|
266 | - } elseif ( ! empty( $qv['exclude'] ) ) { |
|
267 | - $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
268 | - $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
269 | - } |
|
270 | - |
|
271 | - // Date queries are allowed for the customer creation date. |
|
272 | - if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
273 | - $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.date_created" ); |
|
274 | - $this->query_where .= $date_created_query->get_sql(); |
|
275 | - } |
|
276 | - |
|
277 | - // Search. |
|
278 | - if ( ! empty( $qv['s'] ) ) { |
|
279 | - $this->query_where .= $this->get_search_sql( $qv['s'] ); |
|
280 | - } |
|
281 | - } |
|
282 | - |
|
283 | - /** |
|
284 | - * Used internally to generate an SQL string for searching across multiple columns |
|
285 | - * |
|
286 | - * @since 1.2.7 |
|
287 | - * |
|
288 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
289 | - * |
|
290 | - * @param string $string The string to search for. |
|
291 | - * @return string |
|
292 | - */ |
|
293 | - protected function get_search_sql( $string ) { |
|
294 | - global $wpdb; |
|
295 | - |
|
296 | - $searches = array(); |
|
297 | - $string = trim( $string, '%' ); |
|
298 | - $like = '%' . $wpdb->esc_like( $string ) . '%'; |
|
299 | - |
|
300 | - foreach ( array_keys( GetPaid_Customer_Data_Store::get_database_fields() ) as $col ) { |
|
301 | - if ( 'id' === $col || 'user_id' === $col ) { |
|
302 | - $searches[] = $wpdb->prepare( "$col = %s", $string ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
303 | - } else { |
|
304 | - $searches[] = $wpdb->prepare( "$col LIKE %s", $like ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
305 | - } |
|
306 | - } |
|
307 | - |
|
308 | - return ' AND (' . implode( ' OR ', $searches ) . ')'; |
|
309 | - } |
|
310 | - |
|
311 | - /** |
|
312 | - * Prepares the query order. |
|
313 | - * |
|
314 | - * @since 1.0.19 |
|
315 | - * |
|
316 | - * @param array $qv Query vars. |
|
317 | - * @param string $table Table name. |
|
318 | - */ |
|
319 | - protected function prepare_query_order( &$qv, $table ) { |
|
320 | - |
|
321 | - // sorting. |
|
322 | - $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
323 | - $order = $this->parse_order( $qv['order'] ); |
|
324 | - |
|
325 | - // Default order is by 'id' (latest customers). |
|
326 | - if ( empty( $qv['orderby'] ) ) { |
|
327 | - $qv['orderby'] = array( 'id' ); |
|
328 | - } |
|
329 | - |
|
330 | - // 'orderby' values may be an array, comma- or space-separated list. |
|
331 | - $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
332 | - |
|
333 | - $orderby_array = array(); |
|
334 | - foreach ( $ordersby as $_key => $_value ) { |
|
335 | - |
|
336 | - if ( is_int( $_key ) ) { |
|
337 | - // Integer key means this is a flat array of 'orderby' fields. |
|
338 | - $_orderby = $_value; |
|
339 | - $_order = $order; |
|
340 | - } else { |
|
341 | - // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
342 | - $_orderby = $_key; |
|
343 | - $_order = $_value; |
|
344 | - } |
|
345 | - |
|
346 | - $parsed = $this->parse_orderby( $_orderby, $table ); |
|
347 | - |
|
348 | - if ( $parsed ) { |
|
349 | - $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
350 | - } |
|
351 | - } |
|
352 | - |
|
353 | - // If no valid clauses were found, order by id. |
|
354 | - if ( empty( $orderby_array ) ) { |
|
355 | - $orderby_array[] = "id $order"; |
|
356 | - } |
|
357 | - |
|
358 | - $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
359 | - |
|
360 | - } |
|
361 | - |
|
362 | - /** |
|
363 | - * Execute the query, with the current variables. |
|
364 | - * |
|
365 | - * @since 1.0.19 |
|
366 | - * |
|
367 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
368 | - */ |
|
369 | - public function query() { |
|
370 | - global $wpdb; |
|
371 | - |
|
372 | - $qv =& $this->query_vars; |
|
373 | - |
|
374 | - // Return a non-null value to bypass the default GetPaid customers query and remember to set the |
|
375 | - // total_customers property. |
|
376 | - $this->results = apply_filters_ref_array( 'getpaid_customers_pre_query', array( null, &$this ) ); |
|
377 | - |
|
378 | - if ( null === $this->results ) { |
|
379 | - $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
380 | - |
|
381 | - if ( ( is_array( $qv['fields'] ) && 1 !== count( $qv['fields'] ) ) || 'all' === $qv['fields'] ) { |
|
382 | - $this->results = $wpdb->get_results( $this->request ); |
|
383 | - } else { |
|
384 | - $this->results = $wpdb->get_col( $this->request ); |
|
385 | - } |
|
386 | - |
|
387 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
388 | - $found_customers_query = apply_filters( 'getpaid_found_customers_query', 'SELECT FOUND_ROWS()', $this ); |
|
389 | - $this->total_customers = (int) $wpdb->get_var( $found_customers_query ); |
|
390 | - } |
|
391 | - } |
|
392 | - |
|
393 | - if ( 'all' === $qv['fields'] ) { |
|
394 | - foreach ( $this->results as $key => $customer ) { |
|
395 | - $this->set_cache( $customer->id, $customer, 'getpaid_customers' ); |
|
396 | - $this->set_cache( $customer->user_id, $customer->id, 'getpaid_customer_ids_by_user_id' ); |
|
397 | - $this->set_cache( $customer->email, $customer->id, 'getpaid_customer_ids_by_email' ); |
|
398 | - $this->results[ $key ] = new GetPaid_Customer( $customer ); |
|
399 | - } |
|
400 | - } |
|
401 | - |
|
402 | - } |
|
403 | - |
|
404 | - /** |
|
405 | - * Set cache |
|
406 | - * |
|
407 | - * @param string $id |
|
408 | - * @param mixed $data |
|
409 | - * @param string $group |
|
410 | - * @param integer $expire |
|
411 | - * @return boolean |
|
412 | - */ |
|
413 | - public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
414 | - |
|
415 | - if ( empty( $key ) ) { |
|
416 | - return false; |
|
417 | - } |
|
418 | - |
|
419 | - wp_cache_set( $key, $data, $group, $expire ); |
|
420 | - } |
|
421 | - |
|
422 | - /** |
|
423 | - * Retrieve query variable. |
|
424 | - * |
|
425 | - * @since 1.0.19 |
|
426 | - * |
|
427 | - * @param string $query_var Query variable key. |
|
428 | - * @return mixed |
|
429 | - */ |
|
430 | - public function get( $query_var ) { |
|
431 | - if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
432 | - return $this->query_vars[ $query_var ]; |
|
433 | - } |
|
434 | - |
|
435 | - return null; |
|
436 | - } |
|
437 | - |
|
438 | - /** |
|
439 | - * Set query variable. |
|
440 | - * |
|
441 | - * @since 1.0.19 |
|
442 | - * |
|
443 | - * @param string $query_var Query variable key. |
|
444 | - * @param mixed $value Query variable value. |
|
445 | - */ |
|
446 | - public function set( $query_var, $value ) { |
|
447 | - $this->query_vars[ $query_var ] = $value; |
|
448 | - } |
|
449 | - |
|
450 | - /** |
|
451 | - * Return the list of customers. |
|
452 | - * |
|
453 | - * @since 1.0.19 |
|
454 | - * |
|
455 | - * @return GetPaid_Customer[]|array Found customers. |
|
456 | - */ |
|
457 | - public function get_results() { |
|
458 | - return $this->results; |
|
459 | - } |
|
460 | - |
|
461 | - /** |
|
462 | - * Return the total number of customers for the current query. |
|
463 | - * |
|
464 | - * @since 1.0.19 |
|
465 | - * |
|
466 | - * @return int Number of total customers. |
|
467 | - */ |
|
468 | - public function get_total() { |
|
469 | - return $this->total_customers; |
|
470 | - } |
|
471 | - |
|
472 | - /** |
|
473 | - * Parse and sanitize 'orderby' keys passed to the customers query. |
|
474 | - * |
|
475 | - * @since 1.0.19 |
|
476 | - * |
|
477 | - * @param string $orderby Alias for the field to order by. |
|
478 | - * @param string $table The current table. |
|
479 | - * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
480 | - */ |
|
481 | - protected function parse_orderby( $orderby, $table ) { |
|
482 | - |
|
483 | - $_orderby = ''; |
|
484 | - if ( in_array( $orderby, array_keys( GetPaid_Customer_Data_Store::get_database_fields() ), true ) ) { |
|
485 | - $_orderby = "$table.`$orderby`"; |
|
486 | - } elseif ( 'id' === strtolower( $orderby ) ) { |
|
487 | - $_orderby = "$table.id"; |
|
488 | - } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
489 | - $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
490 | - $include_sql = implode( ',', $include ); |
|
491 | - $_orderby = "FIELD( $table.id, $include_sql )"; |
|
492 | - } |
|
493 | - |
|
494 | - return $_orderby; |
|
495 | - } |
|
496 | - |
|
497 | - /** |
|
498 | - * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
499 | - * |
|
500 | - * @since 1.0.19 |
|
501 | - * |
|
502 | - * @param string $order The 'order' query variable. |
|
503 | - * @return string The sanitized 'order' query variable. |
|
504 | - */ |
|
505 | - protected function parse_order( $order ) { |
|
506 | - if ( ! is_string( $order ) || empty( $order ) ) { |
|
507 | - return 'DESC'; |
|
508 | - } |
|
509 | - |
|
510 | - if ( 'ASC' === strtoupper( $order ) ) { |
|
511 | - return 'ASC'; |
|
512 | - } else { |
|
513 | - return 'DESC'; |
|
514 | - } |
|
515 | - } |
|
19 | + /** |
|
20 | + * Query vars, after parsing |
|
21 | + * |
|
22 | + * @since 1.0.19 |
|
23 | + * @var array |
|
24 | + */ |
|
25 | + public $query_vars = array(); |
|
26 | + |
|
27 | + /** |
|
28 | + * List of found customers. |
|
29 | + * |
|
30 | + * @since 1.0.19 |
|
31 | + * @var array |
|
32 | + */ |
|
33 | + private $results; |
|
34 | + |
|
35 | + /** |
|
36 | + * Total number of found customers for the current query |
|
37 | + * |
|
38 | + * @since 1.0.19 |
|
39 | + * @var int |
|
40 | + */ |
|
41 | + private $total_customers = 0; |
|
42 | + |
|
43 | + /** |
|
44 | + * The SQL query used to fetch matching customers. |
|
45 | + * |
|
46 | + * @since 1.0.19 |
|
47 | + * @var string |
|
48 | + */ |
|
49 | + public $request; |
|
50 | + |
|
51 | + // SQL clauses |
|
52 | + |
|
53 | + /** |
|
54 | + * Contains the 'FIELDS' sql clause |
|
55 | + * |
|
56 | + * @since 1.0.19 |
|
57 | + * @var string |
|
58 | + */ |
|
59 | + public $query_fields; |
|
60 | + |
|
61 | + /** |
|
62 | + * Contains the 'FROM' sql clause |
|
63 | + * |
|
64 | + * @since 1.0.19 |
|
65 | + * @var string |
|
66 | + */ |
|
67 | + public $query_from; |
|
68 | + |
|
69 | + /** |
|
70 | + * Contains the 'WHERE' sql clause |
|
71 | + * |
|
72 | + * @since 1.0.19 |
|
73 | + * @var string |
|
74 | + */ |
|
75 | + public $query_where; |
|
76 | + |
|
77 | + /** |
|
78 | + * Contains the 'ORDER BY' sql clause |
|
79 | + * |
|
80 | + * @since 1.0.19 |
|
81 | + * @var string |
|
82 | + */ |
|
83 | + public $query_orderby; |
|
84 | + |
|
85 | + /** |
|
86 | + * Contains the 'LIMIT' sql clause |
|
87 | + * |
|
88 | + * @since 1.0.19 |
|
89 | + * @var string |
|
90 | + */ |
|
91 | + public $query_limit; |
|
92 | + |
|
93 | + /** |
|
94 | + * Class constructor. |
|
95 | + * |
|
96 | + * @since 1.0.19 |
|
97 | + * |
|
98 | + * @param null|string|array $query Optional. The query variables. |
|
99 | + */ |
|
100 | + public function __construct( $query = null ) { |
|
101 | + if ( ! is_null( $query ) ) { |
|
102 | + $this->prepare_query( $query ); |
|
103 | + $this->query(); |
|
104 | + } |
|
105 | + } |
|
106 | + |
|
107 | + /** |
|
108 | + * Fills in missing query variables with default values. |
|
109 | + * |
|
110 | + * @since 1.0.19 |
|
111 | + * |
|
112 | + * @param string|array $args Query vars, as passed to `GetPaid_Subscriptions_Query`. |
|
113 | + * @return array Complete query variables with undefined ones filled in with defaults. |
|
114 | + */ |
|
115 | + public static function fill_query_vars( $args ) { |
|
116 | + $defaults = array( |
|
117 | + 'include' => array(), |
|
118 | + 'exclude' => array(), |
|
119 | + 'orderby' => 'id', |
|
120 | + 'order' => 'DESC', |
|
121 | + 'offset' => '', |
|
122 | + 'number' => 10, |
|
123 | + 'paged' => 1, |
|
124 | + 'count_total' => true, |
|
125 | + 'fields' => 'all', |
|
126 | + 's' => '', |
|
127 | + ); |
|
128 | + |
|
129 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
130 | + $defaults[ $field ] = 'any'; |
|
131 | + |
|
132 | + if ( '%f' === $type || '%d' === $type ) { |
|
133 | + $defaults[ $field . '_min' ] = ''; |
|
134 | + $defaults[ $field . '_max' ] = ''; |
|
135 | + } |
|
136 | + } |
|
137 | + |
|
138 | + return wp_parse_args( $args, $defaults ); |
|
139 | + } |
|
140 | + |
|
141 | + /** |
|
142 | + * Prepare the query variables. |
|
143 | + * |
|
144 | + * @since 1.0.19 |
|
145 | + * |
|
146 | + * @see self::fill_query_vars() For allowede args and their defaults. |
|
147 | + */ |
|
148 | + public function prepare_query( $query = array() ) { |
|
149 | + global $wpdb; |
|
150 | + |
|
151 | + if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
152 | + $this->query_limit = null; |
|
153 | + $this->query_vars = $this->fill_query_vars( $query ); |
|
154 | + } |
|
155 | + |
|
156 | + if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
157 | + $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
158 | + } |
|
159 | + |
|
160 | + do_action( 'getpaid_pre_get_customers', array( &$this ) ); |
|
161 | + |
|
162 | + // Ensure that query vars are filled after 'getpaid_pre_get_customers'. |
|
163 | + $qv = & $this->query_vars; |
|
164 | + $qv = $this->fill_query_vars( $qv ); |
|
165 | + $table = $wpdb->prefix . 'getpaid_customers'; |
|
166 | + $this->query_from = "FROM $table"; |
|
167 | + |
|
168 | + // Prepare query fields. |
|
169 | + $this->prepare_query_fields( $qv, $table ); |
|
170 | + |
|
171 | + // Prepare query where. |
|
172 | + $this->prepare_query_where( $qv, $table ); |
|
173 | + |
|
174 | + // Prepare query order. |
|
175 | + $this->prepare_query_order( $qv, $table ); |
|
176 | + |
|
177 | + // limit |
|
178 | + if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
179 | + if ( $qv['offset'] ) { |
|
180 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
181 | + } else { |
|
182 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
183 | + } |
|
184 | + } |
|
185 | + |
|
186 | + do_action_ref_array( 'getpaid_after_customers_query', array( &$this ) ); |
|
187 | + } |
|
188 | + |
|
189 | + /** |
|
190 | + * Prepares the query fields. |
|
191 | + * |
|
192 | + * @since 1.0.19 |
|
193 | + * |
|
194 | + * @param array $qv Query vars. |
|
195 | + * @param string $table Table name. |
|
196 | + */ |
|
197 | + protected function prepare_query_fields( &$qv, $table ) { |
|
198 | + |
|
199 | + if ( is_array( $qv['fields'] ) ) { |
|
200 | + $qv['fields'] = array_unique( $qv['fields'] ); |
|
201 | + $allowed_fields = array_keys( GetPaid_Customer_Data_Store::get_database_fields() ); |
|
202 | + |
|
203 | + $query_fields = array(); |
|
204 | + foreach ( $qv['fields'] as $field ) { |
|
205 | + if ( ! in_array( $field, $allowed_fields ) ) { |
|
206 | + continue; |
|
207 | + } |
|
208 | + |
|
209 | + $field = sanitize_key( $field ); |
|
210 | + $query_fields[] = "$table.`$field`"; |
|
211 | + } |
|
212 | + $this->query_fields = implode( ',', $query_fields ); |
|
213 | + } else { |
|
214 | + $this->query_fields = "$table.*"; |
|
215 | + } |
|
216 | + |
|
217 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
218 | + $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
219 | + } |
|
220 | + |
|
221 | + } |
|
222 | + |
|
223 | + /** |
|
224 | + * Prepares the query where. |
|
225 | + * |
|
226 | + * @since 1.0.19 |
|
227 | + * |
|
228 | + * @param array $qv Query vars. |
|
229 | + * @param string $table Table name. |
|
230 | + */ |
|
231 | + protected function prepare_query_where( &$qv, $table ) { |
|
232 | + global $wpdb; |
|
233 | + $this->query_where = 'WHERE 1=1'; |
|
234 | + |
|
235 | + // Fields. |
|
236 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
237 | + if ( 'any' !== $qv[ $field ] ) { |
|
238 | + |
|
239 | + // In. |
|
240 | + if ( is_array( $qv[ $field ] ) ) { |
|
241 | + $in = join( ',', array_fill( 0, count( $qv[ $field ] ), $type ) ); |
|
242 | + $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $in )", $qv[ $field ] ); |
|
243 | + } elseif ( ! empty( $qv[ $field ] ) ) { |
|
244 | + $this->query_where .= $wpdb->prepare( " AND $table.`$field` = $type", $qv[ $field ] ); |
|
245 | + } |
|
246 | + } |
|
247 | + |
|
248 | + // Min/Max. |
|
249 | + if ( '%f' === $type || '%d' === $type ) { |
|
250 | + |
|
251 | + // Min. |
|
252 | + if ( is_numeric( $qv[ $field . '_min' ] ) ) { |
|
253 | + $this->query_where .= $wpdb->prepare( " AND $table.`$field` >= $type", $qv[ $field . '_min' ] ); |
|
254 | + } |
|
255 | + |
|
256 | + // Max. |
|
257 | + if ( is_numeric( $qv[ $field . '_max' ] ) ) { |
|
258 | + $this->query_where .= $wpdb->prepare( " AND $table.`$field` <= $type", $qv[ $field . '_max' ] ); |
|
259 | + } |
|
260 | + } |
|
261 | + } |
|
262 | + |
|
263 | + if ( ! empty( $qv['include'] ) ) { |
|
264 | + $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
265 | + $this->query_where .= " AND $table.`id` IN ($include)"; |
|
266 | + } elseif ( ! empty( $qv['exclude'] ) ) { |
|
267 | + $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
268 | + $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
269 | + } |
|
270 | + |
|
271 | + // Date queries are allowed for the customer creation date. |
|
272 | + if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
273 | + $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.date_created" ); |
|
274 | + $this->query_where .= $date_created_query->get_sql(); |
|
275 | + } |
|
276 | + |
|
277 | + // Search. |
|
278 | + if ( ! empty( $qv['s'] ) ) { |
|
279 | + $this->query_where .= $this->get_search_sql( $qv['s'] ); |
|
280 | + } |
|
281 | + } |
|
282 | + |
|
283 | + /** |
|
284 | + * Used internally to generate an SQL string for searching across multiple columns |
|
285 | + * |
|
286 | + * @since 1.2.7 |
|
287 | + * |
|
288 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
289 | + * |
|
290 | + * @param string $string The string to search for. |
|
291 | + * @return string |
|
292 | + */ |
|
293 | + protected function get_search_sql( $string ) { |
|
294 | + global $wpdb; |
|
295 | + |
|
296 | + $searches = array(); |
|
297 | + $string = trim( $string, '%' ); |
|
298 | + $like = '%' . $wpdb->esc_like( $string ) . '%'; |
|
299 | + |
|
300 | + foreach ( array_keys( GetPaid_Customer_Data_Store::get_database_fields() ) as $col ) { |
|
301 | + if ( 'id' === $col || 'user_id' === $col ) { |
|
302 | + $searches[] = $wpdb->prepare( "$col = %s", $string ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
303 | + } else { |
|
304 | + $searches[] = $wpdb->prepare( "$col LIKE %s", $like ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
305 | + } |
|
306 | + } |
|
307 | + |
|
308 | + return ' AND (' . implode( ' OR ', $searches ) . ')'; |
|
309 | + } |
|
310 | + |
|
311 | + /** |
|
312 | + * Prepares the query order. |
|
313 | + * |
|
314 | + * @since 1.0.19 |
|
315 | + * |
|
316 | + * @param array $qv Query vars. |
|
317 | + * @param string $table Table name. |
|
318 | + */ |
|
319 | + protected function prepare_query_order( &$qv, $table ) { |
|
320 | + |
|
321 | + // sorting. |
|
322 | + $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
323 | + $order = $this->parse_order( $qv['order'] ); |
|
324 | + |
|
325 | + // Default order is by 'id' (latest customers). |
|
326 | + if ( empty( $qv['orderby'] ) ) { |
|
327 | + $qv['orderby'] = array( 'id' ); |
|
328 | + } |
|
329 | + |
|
330 | + // 'orderby' values may be an array, comma- or space-separated list. |
|
331 | + $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
332 | + |
|
333 | + $orderby_array = array(); |
|
334 | + foreach ( $ordersby as $_key => $_value ) { |
|
335 | + |
|
336 | + if ( is_int( $_key ) ) { |
|
337 | + // Integer key means this is a flat array of 'orderby' fields. |
|
338 | + $_orderby = $_value; |
|
339 | + $_order = $order; |
|
340 | + } else { |
|
341 | + // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
342 | + $_orderby = $_key; |
|
343 | + $_order = $_value; |
|
344 | + } |
|
345 | + |
|
346 | + $parsed = $this->parse_orderby( $_orderby, $table ); |
|
347 | + |
|
348 | + if ( $parsed ) { |
|
349 | + $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
350 | + } |
|
351 | + } |
|
352 | + |
|
353 | + // If no valid clauses were found, order by id. |
|
354 | + if ( empty( $orderby_array ) ) { |
|
355 | + $orderby_array[] = "id $order"; |
|
356 | + } |
|
357 | + |
|
358 | + $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
359 | + |
|
360 | + } |
|
361 | + |
|
362 | + /** |
|
363 | + * Execute the query, with the current variables. |
|
364 | + * |
|
365 | + * @since 1.0.19 |
|
366 | + * |
|
367 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
368 | + */ |
|
369 | + public function query() { |
|
370 | + global $wpdb; |
|
371 | + |
|
372 | + $qv =& $this->query_vars; |
|
373 | + |
|
374 | + // Return a non-null value to bypass the default GetPaid customers query and remember to set the |
|
375 | + // total_customers property. |
|
376 | + $this->results = apply_filters_ref_array( 'getpaid_customers_pre_query', array( null, &$this ) ); |
|
377 | + |
|
378 | + if ( null === $this->results ) { |
|
379 | + $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
380 | + |
|
381 | + if ( ( is_array( $qv['fields'] ) && 1 !== count( $qv['fields'] ) ) || 'all' === $qv['fields'] ) { |
|
382 | + $this->results = $wpdb->get_results( $this->request ); |
|
383 | + } else { |
|
384 | + $this->results = $wpdb->get_col( $this->request ); |
|
385 | + } |
|
386 | + |
|
387 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
388 | + $found_customers_query = apply_filters( 'getpaid_found_customers_query', 'SELECT FOUND_ROWS()', $this ); |
|
389 | + $this->total_customers = (int) $wpdb->get_var( $found_customers_query ); |
|
390 | + } |
|
391 | + } |
|
392 | + |
|
393 | + if ( 'all' === $qv['fields'] ) { |
|
394 | + foreach ( $this->results as $key => $customer ) { |
|
395 | + $this->set_cache( $customer->id, $customer, 'getpaid_customers' ); |
|
396 | + $this->set_cache( $customer->user_id, $customer->id, 'getpaid_customer_ids_by_user_id' ); |
|
397 | + $this->set_cache( $customer->email, $customer->id, 'getpaid_customer_ids_by_email' ); |
|
398 | + $this->results[ $key ] = new GetPaid_Customer( $customer ); |
|
399 | + } |
|
400 | + } |
|
401 | + |
|
402 | + } |
|
403 | + |
|
404 | + /** |
|
405 | + * Set cache |
|
406 | + * |
|
407 | + * @param string $id |
|
408 | + * @param mixed $data |
|
409 | + * @param string $group |
|
410 | + * @param integer $expire |
|
411 | + * @return boolean |
|
412 | + */ |
|
413 | + public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
414 | + |
|
415 | + if ( empty( $key ) ) { |
|
416 | + return false; |
|
417 | + } |
|
418 | + |
|
419 | + wp_cache_set( $key, $data, $group, $expire ); |
|
420 | + } |
|
421 | + |
|
422 | + /** |
|
423 | + * Retrieve query variable. |
|
424 | + * |
|
425 | + * @since 1.0.19 |
|
426 | + * |
|
427 | + * @param string $query_var Query variable key. |
|
428 | + * @return mixed |
|
429 | + */ |
|
430 | + public function get( $query_var ) { |
|
431 | + if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
432 | + return $this->query_vars[ $query_var ]; |
|
433 | + } |
|
434 | + |
|
435 | + return null; |
|
436 | + } |
|
437 | + |
|
438 | + /** |
|
439 | + * Set query variable. |
|
440 | + * |
|
441 | + * @since 1.0.19 |
|
442 | + * |
|
443 | + * @param string $query_var Query variable key. |
|
444 | + * @param mixed $value Query variable value. |
|
445 | + */ |
|
446 | + public function set( $query_var, $value ) { |
|
447 | + $this->query_vars[ $query_var ] = $value; |
|
448 | + } |
|
449 | + |
|
450 | + /** |
|
451 | + * Return the list of customers. |
|
452 | + * |
|
453 | + * @since 1.0.19 |
|
454 | + * |
|
455 | + * @return GetPaid_Customer[]|array Found customers. |
|
456 | + */ |
|
457 | + public function get_results() { |
|
458 | + return $this->results; |
|
459 | + } |
|
460 | + |
|
461 | + /** |
|
462 | + * Return the total number of customers for the current query. |
|
463 | + * |
|
464 | + * @since 1.0.19 |
|
465 | + * |
|
466 | + * @return int Number of total customers. |
|
467 | + */ |
|
468 | + public function get_total() { |
|
469 | + return $this->total_customers; |
|
470 | + } |
|
471 | + |
|
472 | + /** |
|
473 | + * Parse and sanitize 'orderby' keys passed to the customers query. |
|
474 | + * |
|
475 | + * @since 1.0.19 |
|
476 | + * |
|
477 | + * @param string $orderby Alias for the field to order by. |
|
478 | + * @param string $table The current table. |
|
479 | + * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
480 | + */ |
|
481 | + protected function parse_orderby( $orderby, $table ) { |
|
482 | + |
|
483 | + $_orderby = ''; |
|
484 | + if ( in_array( $orderby, array_keys( GetPaid_Customer_Data_Store::get_database_fields() ), true ) ) { |
|
485 | + $_orderby = "$table.`$orderby`"; |
|
486 | + } elseif ( 'id' === strtolower( $orderby ) ) { |
|
487 | + $_orderby = "$table.id"; |
|
488 | + } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
489 | + $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
490 | + $include_sql = implode( ',', $include ); |
|
491 | + $_orderby = "FIELD( $table.id, $include_sql )"; |
|
492 | + } |
|
493 | + |
|
494 | + return $_orderby; |
|
495 | + } |
|
496 | + |
|
497 | + /** |
|
498 | + * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
499 | + * |
|
500 | + * @since 1.0.19 |
|
501 | + * |
|
502 | + * @param string $order The 'order' query variable. |
|
503 | + * @return string The sanitized 'order' query variable. |
|
504 | + */ |
|
505 | + protected function parse_order( $order ) { |
|
506 | + if ( ! is_string( $order ) || empty( $order ) ) { |
|
507 | + return 'DESC'; |
|
508 | + } |
|
509 | + |
|
510 | + if ( 'ASC' === strtoupper( $order ) ) { |
|
511 | + return 'ASC'; |
|
512 | + } else { |
|
513 | + return 'DESC'; |
|
514 | + } |
|
515 | + } |
|
516 | 516 | |
517 | 517 | } |
@@ -11,7 +11,7 @@ discard block |
||
11 | 11 | |
12 | 12 | // Load WP_List_Table if not loaded |
13 | 13 | if ( ! class_exists( 'WP_List_Table' ) ) { |
14 | - require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
14 | + require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
15 | 15 | } |
16 | 16 | |
17 | 17 | /** |
@@ -23,303 +23,303 @@ discard block |
||
23 | 23 | */ |
24 | 24 | class WPInv_Customers_Table extends WP_List_Table { |
25 | 25 | |
26 | - /** |
|
27 | - * @var int Number of items per page |
|
28 | - * @since 1.0.19 |
|
29 | - */ |
|
30 | - public $per_page = 25; |
|
31 | - |
|
32 | - /** |
|
33 | - * @var int Number of items |
|
34 | - * @since 1.0.19 |
|
35 | - */ |
|
36 | - public $total_count = 0; |
|
37 | - |
|
38 | - public $query; |
|
39 | - |
|
40 | - /** |
|
41 | - * Get things started |
|
42 | - * |
|
43 | - * @since 1.0.19 |
|
44 | - * @see WP_List_Table::__construct() |
|
45 | - */ |
|
46 | - public function __construct() { |
|
47 | - |
|
48 | - // Set parent defaults |
|
49 | - parent::__construct( |
|
26 | + /** |
|
27 | + * @var int Number of items per page |
|
28 | + * @since 1.0.19 |
|
29 | + */ |
|
30 | + public $per_page = 25; |
|
31 | + |
|
32 | + /** |
|
33 | + * @var int Number of items |
|
34 | + * @since 1.0.19 |
|
35 | + */ |
|
36 | + public $total_count = 0; |
|
37 | + |
|
38 | + public $query; |
|
39 | + |
|
40 | + /** |
|
41 | + * Get things started |
|
42 | + * |
|
43 | + * @since 1.0.19 |
|
44 | + * @see WP_List_Table::__construct() |
|
45 | + */ |
|
46 | + public function __construct() { |
|
47 | + |
|
48 | + // Set parent defaults |
|
49 | + parent::__construct( |
|
50 | 50 | array( |
51 | - 'singular' => 'id', |
|
52 | - 'plural' => 'ids', |
|
53 | - 'ajax' => false, |
|
51 | + 'singular' => 'id', |
|
52 | + 'plural' => 'ids', |
|
53 | + 'ajax' => false, |
|
54 | 54 | ) |
55 | 55 | ); |
56 | 56 | |
57 | - } |
|
58 | - |
|
59 | - /** |
|
60 | - * Gets the name of the primary column. |
|
61 | - * |
|
62 | - * @since 1.0.19 |
|
63 | - * @access protected |
|
64 | - * |
|
65 | - * @return string Name of the primary column. |
|
66 | - */ |
|
67 | - protected function get_primary_column_name() { |
|
68 | - return 'customer'; |
|
69 | - } |
|
70 | - |
|
71 | - /** |
|
72 | - * This function renders most of the columns in the list table. |
|
73 | - * |
|
74 | - * @since 1.0.19 |
|
75 | - * |
|
76 | - * @param GetPaid_Customer $customer |
|
77 | - * @param string $column_name The name of the column |
|
78 | - * |
|
79 | - * @return string Column Name |
|
80 | - */ |
|
81 | - public function column_default( $customer, $column_name ) { |
|
82 | - $value = esc_html( $customer->get( $column_name ) ); |
|
83 | - return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $customer ); |
|
84 | - } |
|
85 | - |
|
86 | - /** |
|
87 | - * Displays the country column. |
|
88 | - * |
|
89 | - * @since 1.0.19 |
|
90 | - * |
|
91 | - * @param GetPaid_Customer $customer |
|
92 | - * |
|
93 | - * @return string Column Name |
|
94 | - */ |
|
95 | - public function column_country( $customer ) { |
|
96 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
97 | - if ( $country ) { |
|
98 | - $country = wpinv_country_name( $country ); |
|
99 | - } |
|
100 | - return esc_html( $country ); |
|
101 | - } |
|
102 | - |
|
103 | - /** |
|
104 | - * Displays the state column. |
|
105 | - * |
|
106 | - * @since 1.0.19 |
|
107 | - * |
|
108 | - * @param GetPaid_Customer $customer |
|
109 | - * |
|
110 | - * @return string Column Name |
|
111 | - */ |
|
112 | - public function column_state( $customer ) { |
|
113 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
114 | - $state = $customer->get( 'state' ); |
|
115 | - if ( $state ) { |
|
116 | - $state = wpinv_state_name( $state, $country ); |
|
117 | - } |
|
118 | - |
|
119 | - return esc_html( $state ); |
|
120 | - } |
|
121 | - |
|
122 | - /** |
|
123 | - * Displays the signup column. |
|
124 | - * |
|
125 | - * @since 1.0.19 |
|
126 | - * |
|
127 | - * @param GetPaid_Customer $customer |
|
128 | - * |
|
129 | - * @return string Column Name |
|
130 | - */ |
|
131 | - public function column_date_created( $customer ) { |
|
132 | - return getpaid_format_date_value( $customer->get( 'date_created' ) ); |
|
133 | - } |
|
134 | - |
|
135 | - /** |
|
136 | - * Displays the total spent column. |
|
137 | - * |
|
138 | - * @since 1.0.19 |
|
139 | - * |
|
140 | - * @param GetPaid_Customer $customer |
|
141 | - * |
|
142 | - * @return string Column Name |
|
143 | - */ |
|
144 | - public function column_purchase_value( $customer ) { |
|
145 | - return wpinv_price( (float) $customer->get( 'purchase_value' ) ); |
|
146 | - } |
|
147 | - |
|
148 | - /** |
|
149 | - * Displays the total spent column. |
|
150 | - * |
|
151 | - * @since 1.0.19 |
|
152 | - * |
|
153 | - * @param GetPaid_Customer $customer |
|
154 | - * |
|
155 | - * @return string Column Name |
|
156 | - */ |
|
157 | - public function column_purchase_count( $customer ) { |
|
158 | - $value = $customer->get( 'purchase_count' ); |
|
159 | - $url = $customer->get( 'user_id' ) ? add_query_arg( array( 'post_type' => 'wpi_invoice', 'author' => $customer->get( 'user_id' ), ), admin_url( 'edit.php' ) ) : ''; |
|
160 | - |
|
161 | - return ( empty( $value ) || empty( $url ) ) ? (int) $value : '<a href="' . esc_url( $url ) . '">' . absint( $value ) . '</a>'; |
|
162 | - |
|
163 | - } |
|
164 | - |
|
165 | - /** |
|
166 | - * Displays the customers name |
|
167 | - * |
|
168 | - * @param GetPaid_Customer $customer customer. |
|
169 | - * @return string |
|
170 | - */ |
|
171 | - public function column_customer( $customer ) { |
|
172 | - |
|
173 | - $first_name = $customer->get( 'first_name' ); |
|
174 | - $last_name = $customer->get( 'last_name' ); |
|
175 | - $email = $customer->get( 'email' ); |
|
176 | - $avatar = get_avatar( $customer->get( 'user_id' ) ? $customer->get( 'user_id' ) : $email, 32 ); |
|
177 | - |
|
178 | - // Customer view URL. |
|
179 | - $view_url = $customer->get( 'user_id' ) ? esc_url( add_query_arg( 'user_id', $customer->get( 'user_id' ), admin_url( 'user-edit.php' ) ) ) : false; |
|
180 | - $row_actions = $view_url ? $this->row_actions( |
|
181 | - array( |
|
182 | - 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
183 | - ) |
|
184 | - ) : ''; |
|
185 | - |
|
186 | - // Customer's name. |
|
187 | - $name = esc_html( trim( "$first_name $last_name" ) ); |
|
188 | - |
|
189 | - if ( ! empty( $name ) ) { |
|
190 | - $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
191 | - } |
|
192 | - |
|
193 | - $email = "<div class='row-title'><a href='mailto:$email'>$email</a></div>"; |
|
194 | - |
|
195 | - return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
196 | - |
|
197 | - } |
|
198 | - |
|
199 | - /** |
|
200 | - * Retrieve the current page number |
|
201 | - * |
|
202 | - * @since 1.0.19 |
|
203 | - * @return int Current page number |
|
204 | - */ |
|
205 | - public function get_paged() { |
|
206 | - return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
207 | - } |
|
208 | - |
|
209 | - /** |
|
210 | - * Returns bulk actions. |
|
211 | - * |
|
212 | - * @since 1.0.19 |
|
213 | - * @return void |
|
214 | - */ |
|
215 | - public function bulk_actions( $which = '' ) { |
|
216 | - return array(); |
|
217 | - } |
|
218 | - |
|
219 | - /** |
|
220 | - * Prepares the display query |
|
221 | - */ |
|
222 | - public function prepare_query() { |
|
223 | - |
|
224 | - // Prepare query args. |
|
225 | - $query = array( |
|
226 | - 'number' => $this->per_page, |
|
227 | - 'paged' => $this->get_paged(), |
|
228 | - ); |
|
229 | - |
|
230 | - foreach ( array( 'orderby', 'order', 's' ) as $field ) { |
|
231 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
232 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
233 | - } |
|
234 | - } |
|
235 | - |
|
236 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
237 | - |
|
238 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
239 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
240 | - } |
|
241 | - |
|
242 | - // Min max. |
|
243 | - if ( '%f' === $type || '%d' === $type ) { |
|
244 | - |
|
245 | - if ( isset( $_GET[ $field . '_min' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
246 | - $query[ $field . '_min' ] = floatval( $_GET[ $field . '_min' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
247 | - } |
|
248 | - |
|
249 | - if ( isset( $_GET[ $field . '_max' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
250 | - $query[ $field . '_max' ] = floatval( $_GET[ $field . '_max' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
251 | - } |
|
252 | - } |
|
253 | - } |
|
254 | - |
|
255 | - // Prepare class properties. |
|
256 | - $this->query = getpaid_get_customers( $query, 'query' ); |
|
257 | - $this->total_count = $this->query->get_total(); |
|
258 | - $this->items = $this->query->get_results(); |
|
259 | - } |
|
260 | - |
|
261 | - /** |
|
262 | - * Setup the final data for the table |
|
263 | - * |
|
264 | - */ |
|
265 | - public function prepare_items() { |
|
266 | - |
|
267 | - $columns = $this->get_columns(); |
|
268 | - $hidden = array(); |
|
269 | - $sortable = $this->get_sortable_columns(); |
|
270 | - $this->prepare_query(); |
|
271 | - |
|
272 | - $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
273 | - |
|
274 | - $this->set_pagination_args( |
|
275 | - array( |
|
276 | - 'total_items' => $this->total_count, |
|
277 | - 'per_page' => $this->per_page, |
|
278 | - 'total_pages' => ceil( $this->total_count / $this->per_page ), |
|
279 | - ) |
|
280 | - ); |
|
281 | - } |
|
282 | - |
|
283 | - /** |
|
284 | - * Sortable table columns. |
|
285 | - * |
|
286 | - * @return array |
|
287 | - */ |
|
288 | - public function get_sortable_columns() { |
|
289 | - $sortable = array( |
|
290 | - 'customer' => array( 'first_name', true ), |
|
291 | - ); |
|
292 | - |
|
293 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
294 | - $sortable[ $field ] = array( $field, true ); |
|
295 | - } |
|
296 | - |
|
297 | - return apply_filters( 'manage_getpaid_customers_sortable_table_columns', $sortable ); |
|
298 | - } |
|
299 | - |
|
300 | - /** |
|
301 | - * Table columns |
|
302 | - * |
|
303 | - * @return array |
|
304 | - */ |
|
305 | - public function get_columns() { |
|
306 | - $columns = array( |
|
307 | - 'customer' => __( 'Customer', 'invoicing' ), |
|
308 | - ); |
|
309 | - |
|
310 | - // Add address fields. |
|
311 | - foreach ( getpaid_user_address_fields() as $key => $value ) { |
|
312 | - |
|
313 | - // Skip id, user_id and email. |
|
314 | - if ( ! in_array( $key, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name' ), true ) ) { |
|
315 | - $columns[ $key ] = $value; |
|
316 | - } |
|
317 | - } |
|
318 | - |
|
319 | - $columns['purchase_value'] = __( 'Total Spend', 'invoicing' ); |
|
320 | - $columns['purchase_count'] = __( 'Invoices', 'invoicing' ); |
|
321 | - $columns['date_created'] = __( 'Date created', 'invoicing' ); |
|
322 | - |
|
323 | - return apply_filters( 'manage_getpaid_customers_table_columns', $columns ); |
|
324 | - } |
|
57 | + } |
|
58 | + |
|
59 | + /** |
|
60 | + * Gets the name of the primary column. |
|
61 | + * |
|
62 | + * @since 1.0.19 |
|
63 | + * @access protected |
|
64 | + * |
|
65 | + * @return string Name of the primary column. |
|
66 | + */ |
|
67 | + protected function get_primary_column_name() { |
|
68 | + return 'customer'; |
|
69 | + } |
|
70 | + |
|
71 | + /** |
|
72 | + * This function renders most of the columns in the list table. |
|
73 | + * |
|
74 | + * @since 1.0.19 |
|
75 | + * |
|
76 | + * @param GetPaid_Customer $customer |
|
77 | + * @param string $column_name The name of the column |
|
78 | + * |
|
79 | + * @return string Column Name |
|
80 | + */ |
|
81 | + public function column_default( $customer, $column_name ) { |
|
82 | + $value = esc_html( $customer->get( $column_name ) ); |
|
83 | + return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $customer ); |
|
84 | + } |
|
85 | + |
|
86 | + /** |
|
87 | + * Displays the country column. |
|
88 | + * |
|
89 | + * @since 1.0.19 |
|
90 | + * |
|
91 | + * @param GetPaid_Customer $customer |
|
92 | + * |
|
93 | + * @return string Column Name |
|
94 | + */ |
|
95 | + public function column_country( $customer ) { |
|
96 | + $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
97 | + if ( $country ) { |
|
98 | + $country = wpinv_country_name( $country ); |
|
99 | + } |
|
100 | + return esc_html( $country ); |
|
101 | + } |
|
102 | + |
|
103 | + /** |
|
104 | + * Displays the state column. |
|
105 | + * |
|
106 | + * @since 1.0.19 |
|
107 | + * |
|
108 | + * @param GetPaid_Customer $customer |
|
109 | + * |
|
110 | + * @return string Column Name |
|
111 | + */ |
|
112 | + public function column_state( $customer ) { |
|
113 | + $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
114 | + $state = $customer->get( 'state' ); |
|
115 | + if ( $state ) { |
|
116 | + $state = wpinv_state_name( $state, $country ); |
|
117 | + } |
|
118 | + |
|
119 | + return esc_html( $state ); |
|
120 | + } |
|
121 | + |
|
122 | + /** |
|
123 | + * Displays the signup column. |
|
124 | + * |
|
125 | + * @since 1.0.19 |
|
126 | + * |
|
127 | + * @param GetPaid_Customer $customer |
|
128 | + * |
|
129 | + * @return string Column Name |
|
130 | + */ |
|
131 | + public function column_date_created( $customer ) { |
|
132 | + return getpaid_format_date_value( $customer->get( 'date_created' ) ); |
|
133 | + } |
|
134 | + |
|
135 | + /** |
|
136 | + * Displays the total spent column. |
|
137 | + * |
|
138 | + * @since 1.0.19 |
|
139 | + * |
|
140 | + * @param GetPaid_Customer $customer |
|
141 | + * |
|
142 | + * @return string Column Name |
|
143 | + */ |
|
144 | + public function column_purchase_value( $customer ) { |
|
145 | + return wpinv_price( (float) $customer->get( 'purchase_value' ) ); |
|
146 | + } |
|
147 | + |
|
148 | + /** |
|
149 | + * Displays the total spent column. |
|
150 | + * |
|
151 | + * @since 1.0.19 |
|
152 | + * |
|
153 | + * @param GetPaid_Customer $customer |
|
154 | + * |
|
155 | + * @return string Column Name |
|
156 | + */ |
|
157 | + public function column_purchase_count( $customer ) { |
|
158 | + $value = $customer->get( 'purchase_count' ); |
|
159 | + $url = $customer->get( 'user_id' ) ? add_query_arg( array( 'post_type' => 'wpi_invoice', 'author' => $customer->get( 'user_id' ), ), admin_url( 'edit.php' ) ) : ''; |
|
160 | + |
|
161 | + return ( empty( $value ) || empty( $url ) ) ? (int) $value : '<a href="' . esc_url( $url ) . '">' . absint( $value ) . '</a>'; |
|
162 | + |
|
163 | + } |
|
164 | + |
|
165 | + /** |
|
166 | + * Displays the customers name |
|
167 | + * |
|
168 | + * @param GetPaid_Customer $customer customer. |
|
169 | + * @return string |
|
170 | + */ |
|
171 | + public function column_customer( $customer ) { |
|
172 | + |
|
173 | + $first_name = $customer->get( 'first_name' ); |
|
174 | + $last_name = $customer->get( 'last_name' ); |
|
175 | + $email = $customer->get( 'email' ); |
|
176 | + $avatar = get_avatar( $customer->get( 'user_id' ) ? $customer->get( 'user_id' ) : $email, 32 ); |
|
177 | + |
|
178 | + // Customer view URL. |
|
179 | + $view_url = $customer->get( 'user_id' ) ? esc_url( add_query_arg( 'user_id', $customer->get( 'user_id' ), admin_url( 'user-edit.php' ) ) ) : false; |
|
180 | + $row_actions = $view_url ? $this->row_actions( |
|
181 | + array( |
|
182 | + 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
183 | + ) |
|
184 | + ) : ''; |
|
185 | + |
|
186 | + // Customer's name. |
|
187 | + $name = esc_html( trim( "$first_name $last_name" ) ); |
|
188 | + |
|
189 | + if ( ! empty( $name ) ) { |
|
190 | + $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
191 | + } |
|
192 | + |
|
193 | + $email = "<div class='row-title'><a href='mailto:$email'>$email</a></div>"; |
|
194 | + |
|
195 | + return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
196 | + |
|
197 | + } |
|
198 | + |
|
199 | + /** |
|
200 | + * Retrieve the current page number |
|
201 | + * |
|
202 | + * @since 1.0.19 |
|
203 | + * @return int Current page number |
|
204 | + */ |
|
205 | + public function get_paged() { |
|
206 | + return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
207 | + } |
|
208 | + |
|
209 | + /** |
|
210 | + * Returns bulk actions. |
|
211 | + * |
|
212 | + * @since 1.0.19 |
|
213 | + * @return void |
|
214 | + */ |
|
215 | + public function bulk_actions( $which = '' ) { |
|
216 | + return array(); |
|
217 | + } |
|
218 | + |
|
219 | + /** |
|
220 | + * Prepares the display query |
|
221 | + */ |
|
222 | + public function prepare_query() { |
|
223 | + |
|
224 | + // Prepare query args. |
|
225 | + $query = array( |
|
226 | + 'number' => $this->per_page, |
|
227 | + 'paged' => $this->get_paged(), |
|
228 | + ); |
|
229 | + |
|
230 | + foreach ( array( 'orderby', 'order', 's' ) as $field ) { |
|
231 | + if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
232 | + $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
233 | + } |
|
234 | + } |
|
235 | + |
|
236 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
237 | + |
|
238 | + if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
239 | + $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
240 | + } |
|
241 | + |
|
242 | + // Min max. |
|
243 | + if ( '%f' === $type || '%d' === $type ) { |
|
244 | + |
|
245 | + if ( isset( $_GET[ $field . '_min' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
246 | + $query[ $field . '_min' ] = floatval( $_GET[ $field . '_min' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
247 | + } |
|
248 | + |
|
249 | + if ( isset( $_GET[ $field . '_max' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
250 | + $query[ $field . '_max' ] = floatval( $_GET[ $field . '_max' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
251 | + } |
|
252 | + } |
|
253 | + } |
|
254 | + |
|
255 | + // Prepare class properties. |
|
256 | + $this->query = getpaid_get_customers( $query, 'query' ); |
|
257 | + $this->total_count = $this->query->get_total(); |
|
258 | + $this->items = $this->query->get_results(); |
|
259 | + } |
|
260 | + |
|
261 | + /** |
|
262 | + * Setup the final data for the table |
|
263 | + * |
|
264 | + */ |
|
265 | + public function prepare_items() { |
|
266 | + |
|
267 | + $columns = $this->get_columns(); |
|
268 | + $hidden = array(); |
|
269 | + $sortable = $this->get_sortable_columns(); |
|
270 | + $this->prepare_query(); |
|
271 | + |
|
272 | + $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
273 | + |
|
274 | + $this->set_pagination_args( |
|
275 | + array( |
|
276 | + 'total_items' => $this->total_count, |
|
277 | + 'per_page' => $this->per_page, |
|
278 | + 'total_pages' => ceil( $this->total_count / $this->per_page ), |
|
279 | + ) |
|
280 | + ); |
|
281 | + } |
|
282 | + |
|
283 | + /** |
|
284 | + * Sortable table columns. |
|
285 | + * |
|
286 | + * @return array |
|
287 | + */ |
|
288 | + public function get_sortable_columns() { |
|
289 | + $sortable = array( |
|
290 | + 'customer' => array( 'first_name', true ), |
|
291 | + ); |
|
292 | + |
|
293 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
294 | + $sortable[ $field ] = array( $field, true ); |
|
295 | + } |
|
296 | + |
|
297 | + return apply_filters( 'manage_getpaid_customers_sortable_table_columns', $sortable ); |
|
298 | + } |
|
299 | + |
|
300 | + /** |
|
301 | + * Table columns |
|
302 | + * |
|
303 | + * @return array |
|
304 | + */ |
|
305 | + public function get_columns() { |
|
306 | + $columns = array( |
|
307 | + 'customer' => __( 'Customer', 'invoicing' ), |
|
308 | + ); |
|
309 | + |
|
310 | + // Add address fields. |
|
311 | + foreach ( getpaid_user_address_fields() as $key => $value ) { |
|
312 | + |
|
313 | + // Skip id, user_id and email. |
|
314 | + if ( ! in_array( $key, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name' ), true ) ) { |
|
315 | + $columns[ $key ] = $value; |
|
316 | + } |
|
317 | + } |
|
318 | + |
|
319 | + $columns['purchase_value'] = __( 'Total Spend', 'invoicing' ); |
|
320 | + $columns['purchase_count'] = __( 'Invoices', 'invoicing' ); |
|
321 | + $columns['date_created'] = __( 'Date created', 'invoicing' ); |
|
322 | + |
|
323 | + return apply_filters( 'manage_getpaid_customers_table_columns', $columns ); |
|
324 | + } |
|
325 | 325 | } |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | * Checks if the current user cna view an invoice receipt. |
68 | 68 | */ |
69 | 69 | function wpinv_can_view_receipt( $invoice ) { |
70 | - return (bool) apply_filters( 'wpinv_can_view_receipt', wpinv_user_can_view_invoice( $invoice ), $invoice ); |
|
70 | + return (bool) apply_filters( 'wpinv_can_view_receipt', wpinv_user_can_view_invoice( $invoice ), $invoice ); |
|
71 | 71 | } |
72 | 72 | |
73 | 73 | /** |
@@ -556,37 +556,37 @@ discard block |
||
556 | 556 | $label = empty( $label ) ? __( 'Invoice', 'invoicing' ) : sanitize_text_field( $label ); |
557 | 557 | $columns = array( |
558 | 558 | |
559 | - 'invoice-number' => array( |
|
560 | - 'title' => $label, |
|
561 | - 'class' => 'text-left', |
|
562 | - ), |
|
559 | + 'invoice-number' => array( |
|
560 | + 'title' => $label, |
|
561 | + 'class' => 'text-left', |
|
562 | + ), |
|
563 | 563 | |
564 | - 'created-date' => array( |
|
565 | - 'title' => __( 'Created Date', 'invoicing' ), |
|
566 | - 'class' => 'text-left', |
|
567 | - ), |
|
564 | + 'created-date' => array( |
|
565 | + 'title' => __( 'Created Date', 'invoicing' ), |
|
566 | + 'class' => 'text-left', |
|
567 | + ), |
|
568 | 568 | |
569 | - 'payment-date' => array( |
|
570 | - 'title' => __( 'Payment Date', 'invoicing' ), |
|
571 | - 'class' => 'text-left', |
|
572 | - ), |
|
569 | + 'payment-date' => array( |
|
570 | + 'title' => __( 'Payment Date', 'invoicing' ), |
|
571 | + 'class' => 'text-left', |
|
572 | + ), |
|
573 | 573 | |
574 | - 'invoice-status' => array( |
|
575 | - 'title' => __( 'Status', 'invoicing' ), |
|
576 | - 'class' => 'text-center', |
|
577 | - ), |
|
574 | + 'invoice-status' => array( |
|
575 | + 'title' => __( 'Status', 'invoicing' ), |
|
576 | + 'class' => 'text-center', |
|
577 | + ), |
|
578 | 578 | |
579 | - 'invoice-total' => array( |
|
580 | - 'title' => __( 'Total', 'invoicing' ), |
|
581 | - 'class' => 'text-right', |
|
582 | - ), |
|
579 | + 'invoice-total' => array( |
|
580 | + 'title' => __( 'Total', 'invoicing' ), |
|
581 | + 'class' => 'text-right', |
|
582 | + ), |
|
583 | 583 | |
584 | - 'invoice-actions' => array( |
|
585 | - 'title' => ' ', |
|
586 | - 'class' => 'text-center', |
|
587 | - ), |
|
584 | + 'invoice-actions' => array( |
|
585 | + 'title' => ' ', |
|
586 | + 'class' => 'text-center', |
|
587 | + ), |
|
588 | 588 | |
589 | - ); |
|
589 | + ); |
|
590 | 590 | |
591 | 591 | return apply_filters( 'wpinv_user_invoices_columns', $columns, $post_type ); |
592 | 592 | } |
@@ -1297,22 +1297,22 @@ discard block |
||
1297 | 1297 | */ |
1298 | 1298 | function getpaid_get_invoice_status_classes() { |
1299 | 1299 | |
1300 | - return apply_filters( |
|
1301 | - 'getpaid_get_invoice_status_classes', |
|
1302 | - array( |
|
1300 | + return apply_filters( |
|
1301 | + 'getpaid_get_invoice_status_classes', |
|
1302 | + array( |
|
1303 | 1303 | 'wpi-quote-declined' => 'bg-danger', |
1304 | 1304 | 'wpi-failed' => 'bg-danger', |
1305 | - 'wpi-processing' => 'bg-info', |
|
1306 | - 'wpi-onhold' => 'bg-warning text-dark', |
|
1307 | - 'wpi-quote-accepted' => 'bg-success', |
|
1308 | - 'publish' => 'bg-success', |
|
1309 | - 'wpi-renewal' => 'bg-primary', |
|
1305 | + 'wpi-processing' => 'bg-info', |
|
1306 | + 'wpi-onhold' => 'bg-warning text-dark', |
|
1307 | + 'wpi-quote-accepted' => 'bg-success', |
|
1308 | + 'publish' => 'bg-success', |
|
1309 | + 'wpi-renewal' => 'bg-primary', |
|
1310 | 1310 | 'wpi-cancelled' => 'bg-secondary', |
1311 | 1311 | 'wpi-pending' => 'bg-dark text-white', |
1312 | 1312 | 'wpi-quote-pending' => 'bg-dark text-white', |
1313 | 1313 | 'wpi-refunded' => 'bg-secondary', |
1314 | - ) |
|
1315 | - ); |
|
1314 | + ) |
|
1315 | + ); |
|
1316 | 1316 | |
1317 | 1317 | } |
1318 | 1318 | |
@@ -1326,7 +1326,7 @@ discard block |
||
1326 | 1326 | function getpaid_get_invoice_tax_rate( $invoice, $item ) { |
1327 | 1327 | |
1328 | 1328 | $rates = getpaid_get_item_tax_rates( $item, $invoice->get_country(), $invoice->get_state() ); |
1329 | - $rates = getpaid_filter_item_tax_rates( $item, $rates ); |
|
1329 | + $rates = getpaid_filter_item_tax_rates( $item, $rates ); |
|
1330 | 1330 | $rates = wp_list_pluck( $rates, 'rate' ); |
1331 | 1331 | |
1332 | 1332 | return array_sum( $rates ); |
@@ -1,7 +1,7 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | 3 | if ( ! defined( 'ABSPATH' ) ) { |
4 | - exit; // Exit if accessed directly |
|
4 | + exit; // Exit if accessed directly |
|
5 | 5 | } |
6 | 6 | |
7 | 7 | /** |
@@ -11,112 +11,112 @@ discard block |
||
11 | 11 | */ |
12 | 12 | class AUI_Component_Pagination { |
13 | 13 | |
14 | - /** |
|
15 | - * Build the component. |
|
16 | - * |
|
17 | - * @param array $args |
|
18 | - * |
|
19 | - * @return string The rendered component. |
|
20 | - */ |
|
21 | - public static function get( $args = array() ) { |
|
22 | - global $wp_query, $aui_bs5; |
|
23 | - |
|
24 | - $defaults = array( |
|
25 | - 'class' => '', |
|
26 | - 'mid_size' => 2, |
|
27 | - 'prev_text' => '<i class="fas fa-chevron-left"></i>', |
|
28 | - 'next_text' => '<i class="fas fa-chevron-right"></i>', |
|
29 | - 'screen_reader_text' => __( 'Posts navigation', 'ayecode-connect' ), |
|
30 | - 'before_paging' => '', |
|
31 | - 'after_paging' => '', |
|
32 | - 'type' => 'array', |
|
33 | - 'total' => isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1, |
|
34 | - 'links' => array(), // an array of links if using custom links, this includes the a tag. |
|
35 | - 'rounded_style' => false, |
|
36 | - 'custom_next_text' => '', // Custom next page text |
|
37 | - 'custom_prev_text' => '', // Custom prev page text |
|
38 | - ); |
|
39 | - |
|
40 | - /** |
|
41 | - * Parse incoming $args into an array and merge it with $defaults |
|
42 | - */ |
|
43 | - $args = wp_parse_args( $args, $defaults ); |
|
44 | - |
|
45 | - $output = ''; |
|
46 | - |
|
47 | - // Don't print empty markup if there's only one page. |
|
48 | - if ( $args['total'] > 1 ) { |
|
49 | - // Set up paginated links. |
|
50 | - $links = !empty( $args['links'] ) ? $args['links'] : paginate_links( $args ); |
|
51 | - |
|
52 | - $class = !empty($args['class']) ? $args['class'] : ''; |
|
53 | - |
|
54 | - $custom_prev_link = ''; |
|
55 | - $custom_next_link = ''; |
|
56 | - |
|
57 | - // make the output bootstrap ready |
|
58 | - $links_html = "<ul class='pagination m-0 p-0 $class'>"; |
|
59 | - if ( ! empty( $links ) ) { |
|
60 | - foreach ( $links as $link ) { |
|
61 | - $_link = $link; |
|
62 | - |
|
63 | - if ( $aui_bs5 ) { |
|
64 | - $link_class = $args['rounded_style'] ? 'page-link badge rounded-pill border-0 mx-1 fs-base text-dark link-primary' : 'page-link'; |
|
65 | - $link_class_active = $args['rounded_style'] ? ' current active fw-bold badge rounded-pill' : ' current active'; |
|
66 | - $links_html .= "<li class='page-item mx-0'>"; |
|
67 | - $link = str_replace( array( "page-numbers", " current" ), array( $link_class, $link_class_active ), $link ); |
|
68 | - $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
69 | - $links_html .= $link; |
|
70 | - $links_html .= "</li>"; |
|
71 | - } else { |
|
72 | - $active = strpos( $link, 'current' ) !== false ? 'active' : ''; |
|
73 | - $links_html .= "<li class='page-item $active'>"; |
|
74 | - $links_html .= str_replace( "page-numbers", "page-link", $link ); |
|
75 | - $links_html .= "</li>"; |
|
76 | - } |
|
77 | - |
|
78 | - if ( strpos( $_link, 'next page-numbers' ) || strpos( $_link, 'prev page-numbers' ) ) { |
|
79 | - $link = str_replace( array( "page-numbers", " current" ), array( 'btn btn-outline-primary rounded' . ( $args['rounded_style'] ? '-pill' : '' ) . ' mx-1 fs-base text-dark link-primary', ' current active fw-bold badge rounded-pill' ), $_link ); |
|
80 | - $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
81 | - |
|
82 | - if ( strpos( $_link, 'next page-numbers' ) && ! empty( $args['custom_next_text'] ) ) { |
|
83 | - $custom_next_link = str_replace( $args['next_text'], $args['custom_next_text'], $link ); |
|
84 | - } else if ( strpos( $_link, 'prev page-numbers' ) && ! empty( $args['custom_prev_text'] ) ) { |
|
85 | - $custom_prev_link = str_replace( $args['prev_text'], $args['custom_prev_text'], $link ); |
|
86 | - } |
|
87 | - } |
|
88 | - } |
|
89 | - } |
|
90 | - $links_html .= "</ul>"; |
|
91 | - |
|
92 | - if ( $links ) { |
|
93 | - $output .= '<section class="px-0 py-2 w-100">'; |
|
94 | - $output .= _navigation_markup( $links_html, 'aui-pagination', $args['screen_reader_text'] ); |
|
95 | - $output .= '</section>'; |
|
96 | - } |
|
97 | - |
|
98 | - $output = str_replace( "screen-reader-text", "screen-reader-text sr-only", $output ); |
|
99 | - $output = str_replace( "nav-links", "aui-nav-links", $output ); |
|
100 | - } |
|
101 | - |
|
102 | - if ( $output ) { |
|
103 | - if ( $custom_next_link || $custom_prev_link ) { |
|
104 | - $total = isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1; |
|
105 | - $current = get_query_var( 'paged' ) ? (int) get_query_var( 'paged' ) : 1; |
|
106 | - |
|
107 | - $output = '<div class="row d-flex align-items-center justify-content-between"><div class="col text-start">' . $custom_prev_link . '</div><div class="col text-center d-none d-md-block">' . $output . '</div><div class="col text-center d-md-none">' . $current . '/' . $args['total'] . '</div><div class="col text-end">' . $custom_next_link . '</div></div>'; |
|
108 | - } |
|
109 | - |
|
110 | - if ( ! empty( $args['before_paging'] ) ) { |
|
111 | - $output = $args['before_paging'] . $output; |
|
112 | - } |
|
113 | - |
|
114 | - if ( ! empty( $args['after_paging'] ) ) { |
|
115 | - $output = $output . $args['after_paging']; |
|
116 | - } |
|
117 | - } |
|
118 | - |
|
119 | - return $output; |
|
120 | - } |
|
14 | + /** |
|
15 | + * Build the component. |
|
16 | + * |
|
17 | + * @param array $args |
|
18 | + * |
|
19 | + * @return string The rendered component. |
|
20 | + */ |
|
21 | + public static function get( $args = array() ) { |
|
22 | + global $wp_query, $aui_bs5; |
|
23 | + |
|
24 | + $defaults = array( |
|
25 | + 'class' => '', |
|
26 | + 'mid_size' => 2, |
|
27 | + 'prev_text' => '<i class="fas fa-chevron-left"></i>', |
|
28 | + 'next_text' => '<i class="fas fa-chevron-right"></i>', |
|
29 | + 'screen_reader_text' => __( 'Posts navigation', 'ayecode-connect' ), |
|
30 | + 'before_paging' => '', |
|
31 | + 'after_paging' => '', |
|
32 | + 'type' => 'array', |
|
33 | + 'total' => isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1, |
|
34 | + 'links' => array(), // an array of links if using custom links, this includes the a tag. |
|
35 | + 'rounded_style' => false, |
|
36 | + 'custom_next_text' => '', // Custom next page text |
|
37 | + 'custom_prev_text' => '', // Custom prev page text |
|
38 | + ); |
|
39 | + |
|
40 | + /** |
|
41 | + * Parse incoming $args into an array and merge it with $defaults |
|
42 | + */ |
|
43 | + $args = wp_parse_args( $args, $defaults ); |
|
44 | + |
|
45 | + $output = ''; |
|
46 | + |
|
47 | + // Don't print empty markup if there's only one page. |
|
48 | + if ( $args['total'] > 1 ) { |
|
49 | + // Set up paginated links. |
|
50 | + $links = !empty( $args['links'] ) ? $args['links'] : paginate_links( $args ); |
|
51 | + |
|
52 | + $class = !empty($args['class']) ? $args['class'] : ''; |
|
53 | + |
|
54 | + $custom_prev_link = ''; |
|
55 | + $custom_next_link = ''; |
|
56 | + |
|
57 | + // make the output bootstrap ready |
|
58 | + $links_html = "<ul class='pagination m-0 p-0 $class'>"; |
|
59 | + if ( ! empty( $links ) ) { |
|
60 | + foreach ( $links as $link ) { |
|
61 | + $_link = $link; |
|
62 | + |
|
63 | + if ( $aui_bs5 ) { |
|
64 | + $link_class = $args['rounded_style'] ? 'page-link badge rounded-pill border-0 mx-1 fs-base text-dark link-primary' : 'page-link'; |
|
65 | + $link_class_active = $args['rounded_style'] ? ' current active fw-bold badge rounded-pill' : ' current active'; |
|
66 | + $links_html .= "<li class='page-item mx-0'>"; |
|
67 | + $link = str_replace( array( "page-numbers", " current" ), array( $link_class, $link_class_active ), $link ); |
|
68 | + $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
69 | + $links_html .= $link; |
|
70 | + $links_html .= "</li>"; |
|
71 | + } else { |
|
72 | + $active = strpos( $link, 'current' ) !== false ? 'active' : ''; |
|
73 | + $links_html .= "<li class='page-item $active'>"; |
|
74 | + $links_html .= str_replace( "page-numbers", "page-link", $link ); |
|
75 | + $links_html .= "</li>"; |
|
76 | + } |
|
77 | + |
|
78 | + if ( strpos( $_link, 'next page-numbers' ) || strpos( $_link, 'prev page-numbers' ) ) { |
|
79 | + $link = str_replace( array( "page-numbers", " current" ), array( 'btn btn-outline-primary rounded' . ( $args['rounded_style'] ? '-pill' : '' ) . ' mx-1 fs-base text-dark link-primary', ' current active fw-bold badge rounded-pill' ), $_link ); |
|
80 | + $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
81 | + |
|
82 | + if ( strpos( $_link, 'next page-numbers' ) && ! empty( $args['custom_next_text'] ) ) { |
|
83 | + $custom_next_link = str_replace( $args['next_text'], $args['custom_next_text'], $link ); |
|
84 | + } else if ( strpos( $_link, 'prev page-numbers' ) && ! empty( $args['custom_prev_text'] ) ) { |
|
85 | + $custom_prev_link = str_replace( $args['prev_text'], $args['custom_prev_text'], $link ); |
|
86 | + } |
|
87 | + } |
|
88 | + } |
|
89 | + } |
|
90 | + $links_html .= "</ul>"; |
|
91 | + |
|
92 | + if ( $links ) { |
|
93 | + $output .= '<section class="px-0 py-2 w-100">'; |
|
94 | + $output .= _navigation_markup( $links_html, 'aui-pagination', $args['screen_reader_text'] ); |
|
95 | + $output .= '</section>'; |
|
96 | + } |
|
97 | + |
|
98 | + $output = str_replace( "screen-reader-text", "screen-reader-text sr-only", $output ); |
|
99 | + $output = str_replace( "nav-links", "aui-nav-links", $output ); |
|
100 | + } |
|
101 | + |
|
102 | + if ( $output ) { |
|
103 | + if ( $custom_next_link || $custom_prev_link ) { |
|
104 | + $total = isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1; |
|
105 | + $current = get_query_var( 'paged' ) ? (int) get_query_var( 'paged' ) : 1; |
|
106 | + |
|
107 | + $output = '<div class="row d-flex align-items-center justify-content-between"><div class="col text-start">' . $custom_prev_link . '</div><div class="col text-center d-none d-md-block">' . $output . '</div><div class="col text-center d-md-none">' . $current . '/' . $args['total'] . '</div><div class="col text-end">' . $custom_next_link . '</div></div>'; |
|
108 | + } |
|
109 | + |
|
110 | + if ( ! empty( $args['before_paging'] ) ) { |
|
111 | + $output = $args['before_paging'] . $output; |
|
112 | + } |
|
113 | + |
|
114 | + if ( ! empty( $args['after_paging'] ) ) { |
|
115 | + $output = $output . $args['after_paging']; |
|
116 | + } |
|
117 | + } |
|
118 | + |
|
119 | + return $output; |
|
120 | + } |
|
121 | 121 | |
122 | 122 | } |
123 | 123 | \ No newline at end of file |
@@ -1001,8 +1001,8 @@ |
||
1001 | 1001 | aui_flip_color_scheme_on_scroll(); |
1002 | 1002 | |
1003 | 1003 | <?php |
1004 | - // FSE tweaks. |
|
1005 | - if(!empty($_REQUEST['postType'])){ ?> |
|
1004 | + // FSE tweaks. |
|
1005 | + if(!empty($_REQUEST['postType'])){ ?> |
|
1006 | 1006 | function aui_fse_set_data_scroll() { |
1007 | 1007 | console.log('init scroll'); |
1008 | 1008 | let Iframe = document.getElementsByClassName("edit-site-visual-editor__editor-canvas"); |