Passed
Pull Request — master (#822)
by
unknown
09:10
created
includes/admin/meta-boxes/class-getpaid-meta-box-invoice-items.php 1 patch
Indentation   +150 added lines, -150 removed lines patch added patch discarded remove patch
@@ -8,7 +8,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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 '&nbsp;' . '<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 '&nbsp;' . '<button type="button" class="button button-primary" id="wpinv-new-item">' . esc_html__( 'Create new item', 'invoicing' ) . '</button>';
383
-						echo '&nbsp;' . '<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 '&nbsp;' . '<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 '&nbsp;' . '<button type="button" class="button button-primary" id="wpinv-new-item">' . esc_html__( 'Create new item', 'invoicing' ) . '</button>';
383
+                        echo '&nbsp;' . '<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
 block discarded – undo
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
 block discarded – undo
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.
Please login to merge, or discard this patch.
includes/gateways/class-getpaid-paypal-api.php 1 patch
Indentation   +197 added lines, -197 removed lines patch added patch discarded remove patch
@@ -10,211 +10,211 @@
 block discarded – undo
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
 }
Please login to merge, or discard this patch.
includes/class-getpaid-tax.php 1 patch
Indentation   +192 added lines, -192 removed lines patch added patch discarded remove patch
@@ -13,199 +13,199 @@
 block discarded – undo
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
 }
Please login to merge, or discard this patch.
includes/payments/class-getpaid-payment-form-submission-refresh-prices.php 1 patch
Indentation   +267 added lines, -267 removed lines patch added patch discarded remove patch
@@ -12,301 +12,301 @@
 block discarded – undo
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
 }
Please login to merge, or discard this patch.
includes/class-getpaid-customers-query.php 1 patch
Indentation   +497 added lines, -497 removed lines patch added patch discarded remove patch
@@ -16,502 +16,502 @@
 block discarded – undo
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
 }
Please login to merge, or discard this patch.
includes/admin/class-wpinv-customers-table.php 1 patch
Indentation   +296 added lines, -296 removed lines patch added patch discarded remove patch
@@ -11,7 +11,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 }
Please login to merge, or discard this patch.
includes/invoice-functions.php 1 patch
Indentation   +37 added lines, -37 removed lines patch added patch discarded remove patch
@@ -67,7 +67,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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' => '&nbsp;',
586
-			'class' => 'text-center',
587
-		),
584
+        'invoice-actions' => array(
585
+            'title' => '&nbsp;',
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
 block discarded – undo
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
 block discarded – undo
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 );
Please login to merge, or discard this patch.
wp-ayecode-ui/includes/components/class-aui-component-pagination.php 1 patch
Indentation   +108 added lines, -108 removed lines patch added patch discarded remove patch
@@ -1,7 +1,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.
vendor/ayecode/wp-ayecode-ui/includes/inc/bs5-js.php 1 patch
Indentation   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -1001,8 +1001,8 @@
 block discarded – undo
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");
Please login to merge, or discard this patch.