@@ -11,166 +11,166 @@ |
||
11 | 11 | defined( 'ABSPATH' ) || exit; |
12 | 12 | |
13 | 13 | return array( |
14 | - 'AED' => 'د.إ', |
|
15 | - 'AFN' => '؋', |
|
16 | - 'ALL' => 'L', |
|
17 | - 'AMD' => 'AMD', |
|
18 | - 'ANG' => 'ƒ', |
|
19 | - 'AOA' => 'Kz', |
|
20 | - 'ARS' => '$', |
|
21 | - 'AUD' => '$', |
|
22 | - 'AWG' => 'ƒ', |
|
23 | - 'AZN' => 'AZN', |
|
24 | - 'BAM' => 'KM', |
|
25 | - 'BBD' => '$', |
|
26 | - 'BDT' => '৳', |
|
27 | - 'BGN' => 'лв.', |
|
28 | - 'BHD' => '.د.ب', |
|
29 | - 'BIF' => 'Fr', |
|
30 | - 'BMD' => '$', |
|
31 | - 'BND' => '$', |
|
32 | - 'BOB' => 'Bs.', |
|
33 | - 'BRL' => 'R$', |
|
34 | - 'BSD' => '$', |
|
35 | - 'BTC' => '฿', |
|
36 | - 'BTN' => 'Nu.', |
|
37 | - 'BWP' => 'P', |
|
38 | - 'BYN' => 'Br', |
|
39 | - 'BZD' => '$', |
|
40 | - 'CAD' => '$', |
|
41 | - 'CDF' => 'Fr', |
|
42 | - 'CHF' => 'CHF', |
|
43 | - 'CLP' => '$', |
|
44 | - 'CNY' => '¥', |
|
45 | - 'COP' => '$', |
|
46 | - 'CRC' => '₡', |
|
47 | - 'CUC' => '$', |
|
48 | - 'CUP' => '$', |
|
49 | - 'CVE' => '$', |
|
50 | - 'CZK' => 'Kč', |
|
51 | - 'DJF' => 'Fr', |
|
52 | - 'DKK' => 'DKK', |
|
53 | - 'DOP' => 'RD$', |
|
54 | - 'DZD' => 'د.ج', |
|
55 | - 'EGP' => 'EGP', |
|
56 | - 'ERN' => 'Nfk', |
|
57 | - 'ETB' => 'Br', |
|
58 | - 'EUR' => '€', |
|
59 | - 'FJD' => '$', |
|
60 | - 'FKP' => '£', |
|
61 | - 'GBP' => '£', |
|
62 | - 'GEL' => 'ლ', |
|
63 | - 'GGP' => '£', |
|
64 | - 'GHS' => '₵', |
|
65 | - 'GIP' => '£', |
|
66 | - 'GMD' => 'D', |
|
67 | - 'GNF' => 'Fr', |
|
68 | - 'GTQ' => 'Q', |
|
69 | - 'GYD' => '$', |
|
70 | - 'HKD' => '$', |
|
71 | - 'HNL' => 'L', |
|
72 | - 'HRK' => 'Kn', |
|
73 | - 'HTG' => 'G', |
|
74 | - 'HUF' => 'Ft', |
|
75 | - 'IDR' => 'Rp', |
|
76 | - 'ILS' => '₪', |
|
77 | - 'IMP' => '£', |
|
78 | - 'INR' => '₹', |
|
79 | - 'IQD' => 'ع.د', |
|
80 | - 'IRR' => '﷼', |
|
81 | - 'IRT' => 'تومان', |
|
82 | - 'ISK' => 'kr.', |
|
83 | - 'JEP' => '£', |
|
84 | - 'JMD' => '$', |
|
85 | - 'JOD' => 'د.ا', |
|
86 | - 'JPY' => '¥', |
|
87 | - 'KES' => 'KSh', |
|
88 | - 'KGS' => 'сом', |
|
89 | - 'KHR' => '៛', |
|
90 | - 'KMF' => 'Fr', |
|
91 | - 'KPW' => '₩', |
|
92 | - 'KRW' => '₩', |
|
93 | - 'KWD' => 'د.ك', |
|
94 | - 'KYD' => '$', |
|
95 | - 'KZT' => 'KZT', |
|
96 | - 'LAK' => '₭', |
|
97 | - 'LBP' => 'ل.ل', |
|
98 | - 'LKR' => 'රු', |
|
99 | - 'LRD' => '$', |
|
100 | - 'LSL' => 'L', |
|
101 | - 'LYD' => 'ل.د', |
|
102 | - 'MAD' => 'د.م.', |
|
103 | - 'MDL' => 'MDL', |
|
104 | - 'MGA' => 'Ar', |
|
105 | - 'MKD' => 'ден', |
|
106 | - 'MMK' => 'Ks', |
|
107 | - 'MNT' => '₮', |
|
108 | - 'MOP' => 'P', |
|
109 | - 'MRO' => 'UM', |
|
110 | - 'MUR' => '₨', |
|
111 | - 'MVR' => '.ރ', |
|
112 | - 'MWK' => 'MK', |
|
113 | - 'MXN' => '$', |
|
114 | - 'MYR' => 'RM', |
|
115 | - 'MZN' => 'MT', |
|
116 | - 'NAD' => 'N$', |
|
117 | - 'NGN' => '₦', |
|
118 | - 'NIO' => 'C$', |
|
119 | - 'NOK' => 'kr', |
|
120 | - 'NPR' => '₨', |
|
121 | - 'NZD' => '$', |
|
122 | - 'OMR' => 'ر.ع.', |
|
123 | - 'PAB' => 'B/.', |
|
124 | - 'PEN' => 'S/.', |
|
125 | - 'PGK' => 'K', |
|
126 | - 'PHP' => '₱', |
|
127 | - 'PKR' => '₨', |
|
128 | - 'PLN' => 'zł', |
|
129 | - 'PRB' => 'р.', |
|
130 | - 'PYG' => '₲', |
|
131 | - 'QAR' => 'ر.ق', |
|
132 | - 'RMB' => '¥', |
|
133 | - 'RON' => 'lei', |
|
134 | - 'RSD' => 'дин.', |
|
135 | - 'RUB' => '₽', |
|
136 | - 'RWF' => 'Fr', |
|
137 | - 'SAR' => 'ر.س', |
|
138 | - 'SBD' => '$', |
|
139 | - 'SCR' => '₨', |
|
140 | - 'SDG' => 'ج.س.', |
|
141 | - 'SEK' => 'kr', |
|
142 | - 'SGD' => '$', |
|
143 | - 'SHP' => '£', |
|
144 | - 'SLL' => 'Le', |
|
145 | - 'SOS' => 'Sh', |
|
146 | - 'SRD' => '$', |
|
147 | - 'SSP' => '£', |
|
148 | - 'STD' => 'Db', |
|
149 | - 'SYP' => 'ل.س', |
|
150 | - 'SZL' => 'L', |
|
151 | - 'THB' => '฿', |
|
152 | - 'TJS' => 'ЅМ', |
|
153 | - 'TMT' => 'm', |
|
154 | - 'TND' => 'د.ت', |
|
155 | - 'TOP' => 'T$', |
|
156 | - 'TRY' => '₺', |
|
157 | - 'TTD' => '$', |
|
158 | - 'TWD' => 'NT$', |
|
159 | - 'TZS' => 'Sh', |
|
160 | - 'UAH' => '₴', |
|
161 | - 'UGX' => 'UGX', |
|
162 | - 'USD' => '$', |
|
163 | - 'UYU' => '$', |
|
164 | - 'UZS' => 'UZS', |
|
165 | - 'VEF' => 'Bs.', |
|
166 | - 'VND' => '₫', |
|
167 | - 'VUV' => 'Vt', |
|
168 | - 'WST' => 'T', |
|
169 | - 'XAF' => 'Fr', |
|
170 | - 'XCD' => '$', |
|
171 | - 'XOF' => 'Fr', |
|
172 | - 'XPF' => 'Fr', |
|
173 | - 'YER' => '﷼', |
|
174 | - 'ZAR' => 'R', |
|
175 | - 'ZMW' => 'ZK', |
|
14 | + 'AED' => 'د.إ', |
|
15 | + 'AFN' => '؋', |
|
16 | + 'ALL' => 'L', |
|
17 | + 'AMD' => 'AMD', |
|
18 | + 'ANG' => 'ƒ', |
|
19 | + 'AOA' => 'Kz', |
|
20 | + 'ARS' => '$', |
|
21 | + 'AUD' => '$', |
|
22 | + 'AWG' => 'ƒ', |
|
23 | + 'AZN' => 'AZN', |
|
24 | + 'BAM' => 'KM', |
|
25 | + 'BBD' => '$', |
|
26 | + 'BDT' => '৳', |
|
27 | + 'BGN' => 'лв.', |
|
28 | + 'BHD' => '.د.ب', |
|
29 | + 'BIF' => 'Fr', |
|
30 | + 'BMD' => '$', |
|
31 | + 'BND' => '$', |
|
32 | + 'BOB' => 'Bs.', |
|
33 | + 'BRL' => 'R$', |
|
34 | + 'BSD' => '$', |
|
35 | + 'BTC' => '฿', |
|
36 | + 'BTN' => 'Nu.', |
|
37 | + 'BWP' => 'P', |
|
38 | + 'BYN' => 'Br', |
|
39 | + 'BZD' => '$', |
|
40 | + 'CAD' => '$', |
|
41 | + 'CDF' => 'Fr', |
|
42 | + 'CHF' => 'CHF', |
|
43 | + 'CLP' => '$', |
|
44 | + 'CNY' => '¥', |
|
45 | + 'COP' => '$', |
|
46 | + 'CRC' => '₡', |
|
47 | + 'CUC' => '$', |
|
48 | + 'CUP' => '$', |
|
49 | + 'CVE' => '$', |
|
50 | + 'CZK' => 'Kč', |
|
51 | + 'DJF' => 'Fr', |
|
52 | + 'DKK' => 'DKK', |
|
53 | + 'DOP' => 'RD$', |
|
54 | + 'DZD' => 'د.ج', |
|
55 | + 'EGP' => 'EGP', |
|
56 | + 'ERN' => 'Nfk', |
|
57 | + 'ETB' => 'Br', |
|
58 | + 'EUR' => '€', |
|
59 | + 'FJD' => '$', |
|
60 | + 'FKP' => '£', |
|
61 | + 'GBP' => '£', |
|
62 | + 'GEL' => 'ლ', |
|
63 | + 'GGP' => '£', |
|
64 | + 'GHS' => '₵', |
|
65 | + 'GIP' => '£', |
|
66 | + 'GMD' => 'D', |
|
67 | + 'GNF' => 'Fr', |
|
68 | + 'GTQ' => 'Q', |
|
69 | + 'GYD' => '$', |
|
70 | + 'HKD' => '$', |
|
71 | + 'HNL' => 'L', |
|
72 | + 'HRK' => 'Kn', |
|
73 | + 'HTG' => 'G', |
|
74 | + 'HUF' => 'Ft', |
|
75 | + 'IDR' => 'Rp', |
|
76 | + 'ILS' => '₪', |
|
77 | + 'IMP' => '£', |
|
78 | + 'INR' => '₹', |
|
79 | + 'IQD' => 'ع.د', |
|
80 | + 'IRR' => '﷼', |
|
81 | + 'IRT' => 'تومان', |
|
82 | + 'ISK' => 'kr.', |
|
83 | + 'JEP' => '£', |
|
84 | + 'JMD' => '$', |
|
85 | + 'JOD' => 'د.ا', |
|
86 | + 'JPY' => '¥', |
|
87 | + 'KES' => 'KSh', |
|
88 | + 'KGS' => 'сом', |
|
89 | + 'KHR' => '៛', |
|
90 | + 'KMF' => 'Fr', |
|
91 | + 'KPW' => '₩', |
|
92 | + 'KRW' => '₩', |
|
93 | + 'KWD' => 'د.ك', |
|
94 | + 'KYD' => '$', |
|
95 | + 'KZT' => 'KZT', |
|
96 | + 'LAK' => '₭', |
|
97 | + 'LBP' => 'ل.ل', |
|
98 | + 'LKR' => 'රු', |
|
99 | + 'LRD' => '$', |
|
100 | + 'LSL' => 'L', |
|
101 | + 'LYD' => 'ل.د', |
|
102 | + 'MAD' => 'د.م.', |
|
103 | + 'MDL' => 'MDL', |
|
104 | + 'MGA' => 'Ar', |
|
105 | + 'MKD' => 'ден', |
|
106 | + 'MMK' => 'Ks', |
|
107 | + 'MNT' => '₮', |
|
108 | + 'MOP' => 'P', |
|
109 | + 'MRO' => 'UM', |
|
110 | + 'MUR' => '₨', |
|
111 | + 'MVR' => '.ރ', |
|
112 | + 'MWK' => 'MK', |
|
113 | + 'MXN' => '$', |
|
114 | + 'MYR' => 'RM', |
|
115 | + 'MZN' => 'MT', |
|
116 | + 'NAD' => 'N$', |
|
117 | + 'NGN' => '₦', |
|
118 | + 'NIO' => 'C$', |
|
119 | + 'NOK' => 'kr', |
|
120 | + 'NPR' => '₨', |
|
121 | + 'NZD' => '$', |
|
122 | + 'OMR' => 'ر.ع.', |
|
123 | + 'PAB' => 'B/.', |
|
124 | + 'PEN' => 'S/.', |
|
125 | + 'PGK' => 'K', |
|
126 | + 'PHP' => '₱', |
|
127 | + 'PKR' => '₨', |
|
128 | + 'PLN' => 'zł', |
|
129 | + 'PRB' => 'р.', |
|
130 | + 'PYG' => '₲', |
|
131 | + 'QAR' => 'ر.ق', |
|
132 | + 'RMB' => '¥', |
|
133 | + 'RON' => 'lei', |
|
134 | + 'RSD' => 'дин.', |
|
135 | + 'RUB' => '₽', |
|
136 | + 'RWF' => 'Fr', |
|
137 | + 'SAR' => 'ر.س', |
|
138 | + 'SBD' => '$', |
|
139 | + 'SCR' => '₨', |
|
140 | + 'SDG' => 'ج.س.', |
|
141 | + 'SEK' => 'kr', |
|
142 | + 'SGD' => '$', |
|
143 | + 'SHP' => '£', |
|
144 | + 'SLL' => 'Le', |
|
145 | + 'SOS' => 'Sh', |
|
146 | + 'SRD' => '$', |
|
147 | + 'SSP' => '£', |
|
148 | + 'STD' => 'Db', |
|
149 | + 'SYP' => 'ل.س', |
|
150 | + 'SZL' => 'L', |
|
151 | + 'THB' => '฿', |
|
152 | + 'TJS' => 'ЅМ', |
|
153 | + 'TMT' => 'm', |
|
154 | + 'TND' => 'د.ت', |
|
155 | + 'TOP' => 'T$', |
|
156 | + 'TRY' => '₺', |
|
157 | + 'TTD' => '$', |
|
158 | + 'TWD' => 'NT$', |
|
159 | + 'TZS' => 'Sh', |
|
160 | + 'UAH' => '₴', |
|
161 | + 'UGX' => 'UGX', |
|
162 | + 'USD' => '$', |
|
163 | + 'UYU' => '$', |
|
164 | + 'UZS' => 'UZS', |
|
165 | + 'VEF' => 'Bs.', |
|
166 | + 'VND' => '₫', |
|
167 | + 'VUV' => 'Vt', |
|
168 | + 'WST' => 'T', |
|
169 | + 'XAF' => 'Fr', |
|
170 | + 'XCD' => '$', |
|
171 | + 'XOF' => 'Fr', |
|
172 | + 'XPF' => 'Fr', |
|
173 | + 'YER' => '﷼', |
|
174 | + 'ZAR' => 'R', |
|
175 | + 'ZMW' => 'ZK', |
|
176 | 176 | ); |
@@ -57,16 +57,16 @@ discard block |
||
57 | 57 | $args = wp_parse_args( |
58 | 58 | $args, |
59 | 59 | array( |
60 | - 'status' => array( 'publish' ), |
|
61 | - 'limit' => get_option( 'posts_per_page' ), |
|
62 | - 'page' => 1, |
|
63 | - 'exclude' => array(), |
|
64 | - 'orderby' => 'date', |
|
65 | - 'order' => 'DESC', |
|
66 | - 'type' => wpinv_item_types(), |
|
67 | - 'meta_query' => array(), |
|
68 | - 'return' => 'objects', |
|
69 | - 'paginate' => false, |
|
60 | + 'status' => array( 'publish' ), |
|
61 | + 'limit' => get_option( 'posts_per_page' ), |
|
62 | + 'page' => 1, |
|
63 | + 'exclude' => array(), |
|
64 | + 'orderby' => 'date', |
|
65 | + 'order' => 'DESC', |
|
66 | + 'type' => wpinv_item_types(), |
|
67 | + 'meta_query' => array(), |
|
68 | + 'return' => 'objects', |
|
69 | + 'paginate' => false, |
|
70 | 70 | ) |
71 | 71 | ); |
72 | 72 | |
@@ -206,9 +206,9 @@ discard block |
||
206 | 206 | |
207 | 207 | function wpinv_get_item_types() { |
208 | 208 | $item_types = array( |
209 | - 'custom' => __( 'Standard', 'invoicing' ), |
|
210 | - 'fee' => __( 'Fee', 'invoicing' ), |
|
211 | - ); |
|
209 | + 'custom' => __( 'Standard', 'invoicing' ), |
|
210 | + 'fee' => __( 'Fee', 'invoicing' ), |
|
211 | + ); |
|
212 | 212 | return apply_filters( 'wpinv_get_item_types', $item_types ); |
213 | 213 | } |
214 | 214 | |
@@ -249,17 +249,17 @@ discard block |
||
249 | 249 | function wpinv_get_random_items( $num = 3, $post_ids = true ) { |
250 | 250 | if ( $post_ids ) { |
251 | 251 | $args = array( |
252 | - 'post_type' => 'wpi_item', |
|
253 | - 'orderby' => 'rand', |
|
254 | - 'post_count' => $num, |
|
255 | - 'fields' => 'ids', |
|
256 | - ); |
|
252 | + 'post_type' => 'wpi_item', |
|
253 | + 'orderby' => 'rand', |
|
254 | + 'post_count' => $num, |
|
255 | + 'fields' => 'ids', |
|
256 | + ); |
|
257 | 257 | } else { |
258 | 258 | $args = array( |
259 | - 'post_type' => 'wpi_item', |
|
260 | - 'orderby' => 'rand', |
|
261 | - 'post_count' => $num, |
|
262 | - ); |
|
259 | + 'post_type' => 'wpi_item', |
|
260 | + 'orderby' => 'rand', |
|
261 | + 'post_count' => $num, |
|
262 | + ); |
|
263 | 263 | } |
264 | 264 | |
265 | 265 | $args = apply_filters( 'wpinv_get_random_items', $args ); |
@@ -427,10 +427,10 @@ discard block |
||
427 | 427 | $bill_times_less = $bill_times - 1; |
428 | 428 | |
429 | 429 | if ( ! empty( $bill_times ) ) { |
430 | - $bill_times = $item->get_recurring_interval() * $bill_times; |
|
430 | + $bill_times = $item->get_recurring_interval() * $bill_times; |
|
431 | 431 | $bill_times_less = getpaid_get_subscription_period_label( $item->get_recurring_period(), $bill_times - $item->get_recurring_interval() ); |
432 | - $bill_times = getpaid_get_subscription_period_label( $item->get_recurring_period(), $bill_times ); |
|
433 | - } |
|
432 | + $bill_times = getpaid_get_subscription_period_label( $item->get_recurring_period(), $bill_times ); |
|
433 | + } |
|
434 | 434 | |
435 | 435 | if ( $item instanceof GetPaid_Form_Item && false === $_initial_price ) { |
436 | 436 | $initial_price = wpinv_price( $item->get_sub_total(), $currency ); |
@@ -12,59 +12,59 @@ |
||
12 | 12 | $label = empty( $label ) ? '' : wp_kses_post( $label ); |
13 | 13 | $label_class = sanitize_key( preg_replace( '/[^A-Za-z0-9_-]/', '-', $label ) ); |
14 | 14 | if ( ! empty( $required ) ) { |
15 | - $label .= "<span class='text-danger'> *</span>"; |
|
15 | + $label .= "<span class='text-danger'> *</span>"; |
|
16 | 16 | } |
17 | 17 | |
18 | 18 | $disable_dates = array(); |
19 | 19 | |
20 | 20 | if ( ! empty( $disabled_dates ) ) { |
21 | - $disabled_dates = preg_replace( '/\s+/', '', $disabled_dates ); |
|
22 | - $disabled_dates = str_ireplace( 'today', current_time( 'Y-m-d' ), $disabled_dates ); |
|
23 | - $disabled_dates = array_filter( explode( ',', $disabled_dates ) ); |
|
21 | + $disabled_dates = preg_replace( '/\s+/', '', $disabled_dates ); |
|
22 | + $disabled_dates = str_ireplace( 'today', current_time( 'Y-m-d' ), $disabled_dates ); |
|
23 | + $disabled_dates = array_filter( explode( ',', $disabled_dates ) ); |
|
24 | 24 | |
25 | - foreach ( $disabled_dates as $disabled_date ) { |
|
25 | + foreach ( $disabled_dates as $disabled_date ) { |
|
26 | 26 | |
27 | - $disabled_date = trim( $disabled_date ); |
|
27 | + $disabled_date = trim( $disabled_date ); |
|
28 | 28 | |
29 | - if ( false === strpos( $disabled_date, '|' ) ) { |
|
30 | - $disable_dates[] = $disabled_date; |
|
31 | - continue; |
|
32 | - } |
|
29 | + if ( false === strpos( $disabled_date, '|' ) ) { |
|
30 | + $disable_dates[] = $disabled_date; |
|
31 | + continue; |
|
32 | + } |
|
33 | 33 | |
34 | - $disabled_date = explode( '|', $disabled_date ); |
|
35 | - $disable_dates[] = array( |
|
36 | - 'from' => trim( $disabled_date[0] ), |
|
37 | - 'to' => trim( $disabled_date[1] ), |
|
38 | - ); |
|
34 | + $disabled_date = explode( '|', $disabled_date ); |
|
35 | + $disable_dates[] = array( |
|
36 | + 'from' => trim( $disabled_date[0] ), |
|
37 | + 'to' => trim( $disabled_date[1] ), |
|
38 | + ); |
|
39 | 39 | |
40 | - } |
|
40 | + } |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | $options = array( |
44 | - 'data-default-date' => empty( $default_date ) ? false : $default_date, |
|
45 | - 'data-min-date' => empty( $min_date ) ? false : $min_date, |
|
46 | - 'data-max-date' => empty( $max_date ) ? false : $max_date, |
|
47 | - 'data-mode' => empty( $mode ) ? 'single' : $mode, |
|
48 | - 'data-alt-format' => get_option( 'date_format', 'F j, Y' ), |
|
49 | - 'data-date-format' => 'Y-m-d', |
|
50 | - 'data-alt-input' => 'true', |
|
51 | - 'data-disable_alt' => empty( $disabled_dates ) ? false : wp_json_encode( $disable_dates ), |
|
52 | - 'data-disable_days_alt' => empty( $disable_days ) ? false : wp_json_encode( wp_parse_id_list( $disable_days ) ), |
|
44 | + 'data-default-date' => empty( $default_date ) ? false : $default_date, |
|
45 | + 'data-min-date' => empty( $min_date ) ? false : $min_date, |
|
46 | + 'data-max-date' => empty( $max_date ) ? false : $max_date, |
|
47 | + 'data-mode' => empty( $mode ) ? 'single' : $mode, |
|
48 | + 'data-alt-format' => get_option( 'date_format', 'F j, Y' ), |
|
49 | + 'data-date-format' => 'Y-m-d', |
|
50 | + 'data-alt-input' => 'true', |
|
51 | + 'data-disable_alt' => empty( $disabled_dates ) ? false : wp_json_encode( $disable_dates ), |
|
52 | + 'data-disable_days_alt' => empty( $disable_days ) ? false : wp_json_encode( wp_parse_id_list( $disable_days ) ), |
|
53 | 53 | ); |
54 | 54 | |
55 | 55 | aui()->input( |
56 | - array( |
|
57 | - 'name' => esc_attr( $id ), |
|
58 | - 'id' => esc_attr( $element_id ), |
|
59 | - 'placeholder' => empty( $placeholder ) ? '' : esc_attr( $placeholder ), |
|
60 | - 'required' => ! empty( $required ), |
|
61 | - 'label' => $label, |
|
62 | - 'label_type' => 'vertical', |
|
63 | - 'help_text' => empty( $description ) ? '' : wp_kses_post( $description ), |
|
64 | - 'type' => 'datepicker', |
|
65 | - 'class' => $label_class . ' getpaid-init-flatpickr flatpickr-input', |
|
66 | - 'extra_attributes' => array_filter( apply_filters( 'getpaid_date_field_attributes', $options ) ), |
|
67 | - 'value' => $query_value, |
|
68 | - ), |
|
69 | - true |
|
56 | + array( |
|
57 | + 'name' => esc_attr( $id ), |
|
58 | + 'id' => esc_attr( $element_id ), |
|
59 | + 'placeholder' => empty( $placeholder ) ? '' : esc_attr( $placeholder ), |
|
60 | + 'required' => ! empty( $required ), |
|
61 | + 'label' => $label, |
|
62 | + 'label_type' => 'vertical', |
|
63 | + 'help_text' => empty( $description ) ? '' : wp_kses_post( $description ), |
|
64 | + 'type' => 'datepicker', |
|
65 | + 'class' => $label_class . ' getpaid-init-flatpickr flatpickr-input', |
|
66 | + 'extra_attributes' => array_filter( apply_filters( 'getpaid_date_field_attributes', $options ) ), |
|
67 | + 'value' => $query_value, |
|
68 | + ), |
|
69 | + true |
|
70 | 70 | ); |
@@ -20,237 +20,237 @@ discard block |
||
20 | 20 | */ |
21 | 21 | class GetPaid_Installer { |
22 | 22 | |
23 | - /** |
|
24 | - * Upgrades the install. |
|
25 | - * |
|
26 | - * @param string $upgrade_from The current invoicing version. |
|
27 | - */ |
|
28 | - public function upgrade_db( $upgrade_from ) { |
|
29 | - |
|
30 | - // Save the current invoicing version. |
|
31 | - update_option( 'wpinv_version', WPINV_VERSION ); |
|
32 | - |
|
33 | - // Setup the invoice Custom Post Type. |
|
34 | - GetPaid_Post_Types::register_post_types(); |
|
35 | - |
|
36 | - // Clear the permalinks |
|
37 | - flush_rewrite_rules(); |
|
38 | - |
|
39 | - // Maybe create new/missing pages. |
|
40 | - $this->create_pages(); |
|
41 | - |
|
42 | - // Maybe re(add) admin capabilities. |
|
43 | - $this->add_capabilities(); |
|
44 | - |
|
45 | - // Maybe create the default payment form. |
|
46 | - wpinv_get_default_payment_form(); |
|
47 | - |
|
48 | - // Create any missing database tables. |
|
49 | - $method = "upgrade_from_$upgrade_from"; |
|
50 | - |
|
51 | - $installed = get_option( 'gepaid_installed_on' ); |
|
52 | - |
|
53 | - if ( empty( $installed ) ) { |
|
54 | - update_option( 'gepaid_installed_on', time() ); |
|
55 | - } |
|
56 | - |
|
57 | - if ( method_exists( $this, $method ) ) { |
|
58 | - $this->$method(); |
|
59 | - } |
|
60 | - |
|
61 | - } |
|
62 | - |
|
63 | - /** |
|
64 | - * Do a fresh install. |
|
65 | - * |
|
66 | - */ |
|
67 | - public function upgrade_from_0() { |
|
68 | - $this->create_subscriptions_table(); |
|
69 | - $this->create_invoices_table(); |
|
70 | - $this->create_invoice_items_table(); |
|
71 | - |
|
72 | - // Save default tax rates. |
|
73 | - update_option( 'wpinv_tax_rates', wpinv_get_data( 'tax-rates' ) ); |
|
74 | - } |
|
75 | - |
|
76 | - /** |
|
77 | - * Upgrade to 0.0.5 |
|
78 | - * |
|
79 | - */ |
|
80 | - public function upgrade_from_004() { |
|
81 | - global $wpdb; |
|
82 | - |
|
83 | - // Invoices. |
|
84 | - $results = $wpdb->get_results( "SELECT ID FROM {$wpdb->posts} WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
85 | - if ( ! empty( $results ) ) { |
|
86 | - $wpdb->query( "UPDATE {$wpdb->posts} SET post_status = CONCAT( 'wpi-', post_status ) WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
87 | - |
|
88 | - // Clean post cache |
|
89 | - foreach ( $results as $row ) { |
|
90 | - clean_post_cache( $row->ID ); |
|
91 | - } |
|
92 | - } |
|
93 | - |
|
94 | - // Item meta key changes |
|
95 | - $query = 'SELECT DISTINCT post_id FROM ' . $wpdb->postmeta . " WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id', '_wpinv_cpt_name', '_wpinv_cpt_singular_name' )"; |
|
96 | - $results = $wpdb->get_results( $query ); |
|
97 | - |
|
98 | - if ( ! empty( $results ) ) { |
|
99 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" ); |
|
100 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" ); |
|
101 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" ); |
|
102 | - |
|
103 | - foreach ( $results as $row ) { |
|
104 | - clean_post_cache( $row->post_id ); |
|
105 | - } |
|
106 | - } |
|
107 | - |
|
108 | - $this->upgrade_from_102(); |
|
109 | - } |
|
110 | - |
|
111 | - /** |
|
112 | - * Upgrade to 1.0.3 |
|
113 | - * |
|
114 | - */ |
|
115 | - public function upgrade_from_102() { |
|
116 | - $this->create_subscriptions_table(); |
|
117 | - $this->upgrade_from_118(); |
|
118 | - } |
|
119 | - |
|
120 | - /** |
|
121 | - * Upgrade to version 2.0.0. |
|
122 | - * |
|
123 | - */ |
|
124 | - public function upgrade_from_118() { |
|
125 | - $this->create_invoices_table(); |
|
126 | - $this->create_invoice_items_table(); |
|
127 | - $this->migrate_old_invoices(); |
|
128 | - } |
|
129 | - |
|
130 | - /** |
|
131 | - * Upgrade to version 2.0.8. |
|
132 | - * |
|
133 | - */ |
|
134 | - public function upgrade_from_207() { |
|
135 | - global $wpdb; |
|
136 | - $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoice_items MODIFY COLUMN quantity FLOAT(20);" ); |
|
137 | - $this->upgrade_from_2615(); |
|
138 | - } |
|
139 | - |
|
140 | - /** |
|
141 | - * Upgrade to version 2.6.16. |
|
142 | - * |
|
143 | - */ |
|
144 | - public function upgrade_from_2615() { |
|
145 | - global $wpdb; |
|
146 | - $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoice_items MODIFY COLUMN item_price DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY custom_price DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY discount DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY subtotal DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY price DECIMAL(16,4) NOT NULL DEFAULT '0';" ); |
|
147 | - $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoices MODIFY COLUMN subtotal DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY tax DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY fees_total DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY total DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY discount DECIMAL(16,4) NOT NULL DEFAULT '0';" ); |
|
148 | - } |
|
149 | - |
|
150 | - /** |
|
151 | - * Give administrators the capability to manage GetPaid. |
|
152 | - * |
|
153 | - */ |
|
154 | - public function add_capabilities() { |
|
155 | - $GLOBALS['wp_roles']->add_cap( 'administrator', 'manage_invoicing' ); |
|
156 | - } |
|
157 | - |
|
158 | - /** |
|
159 | - * Retreives GetPaid pages. |
|
160 | - * |
|
161 | - */ |
|
162 | - public static function get_pages() { |
|
163 | - |
|
164 | - return apply_filters( |
|
165 | - 'wpinv_create_pages', |
|
166 | - array( |
|
167 | - |
|
168 | - // Checkout page. |
|
169 | - 'checkout_page' => array( |
|
170 | - 'name' => _x( 'gp-checkout', 'Page slug', 'invoicing' ), |
|
171 | - 'title' => _x( 'Checkout', 'Page title', 'invoicing' ), |
|
172 | - 'content' => ' |
|
23 | + /** |
|
24 | + * Upgrades the install. |
|
25 | + * |
|
26 | + * @param string $upgrade_from The current invoicing version. |
|
27 | + */ |
|
28 | + public function upgrade_db( $upgrade_from ) { |
|
29 | + |
|
30 | + // Save the current invoicing version. |
|
31 | + update_option( 'wpinv_version', WPINV_VERSION ); |
|
32 | + |
|
33 | + // Setup the invoice Custom Post Type. |
|
34 | + GetPaid_Post_Types::register_post_types(); |
|
35 | + |
|
36 | + // Clear the permalinks |
|
37 | + flush_rewrite_rules(); |
|
38 | + |
|
39 | + // Maybe create new/missing pages. |
|
40 | + $this->create_pages(); |
|
41 | + |
|
42 | + // Maybe re(add) admin capabilities. |
|
43 | + $this->add_capabilities(); |
|
44 | + |
|
45 | + // Maybe create the default payment form. |
|
46 | + wpinv_get_default_payment_form(); |
|
47 | + |
|
48 | + // Create any missing database tables. |
|
49 | + $method = "upgrade_from_$upgrade_from"; |
|
50 | + |
|
51 | + $installed = get_option( 'gepaid_installed_on' ); |
|
52 | + |
|
53 | + if ( empty( $installed ) ) { |
|
54 | + update_option( 'gepaid_installed_on', time() ); |
|
55 | + } |
|
56 | + |
|
57 | + if ( method_exists( $this, $method ) ) { |
|
58 | + $this->$method(); |
|
59 | + } |
|
60 | + |
|
61 | + } |
|
62 | + |
|
63 | + /** |
|
64 | + * Do a fresh install. |
|
65 | + * |
|
66 | + */ |
|
67 | + public function upgrade_from_0() { |
|
68 | + $this->create_subscriptions_table(); |
|
69 | + $this->create_invoices_table(); |
|
70 | + $this->create_invoice_items_table(); |
|
71 | + |
|
72 | + // Save default tax rates. |
|
73 | + update_option( 'wpinv_tax_rates', wpinv_get_data( 'tax-rates' ) ); |
|
74 | + } |
|
75 | + |
|
76 | + /** |
|
77 | + * Upgrade to 0.0.5 |
|
78 | + * |
|
79 | + */ |
|
80 | + public function upgrade_from_004() { |
|
81 | + global $wpdb; |
|
82 | + |
|
83 | + // Invoices. |
|
84 | + $results = $wpdb->get_results( "SELECT ID FROM {$wpdb->posts} WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
85 | + if ( ! empty( $results ) ) { |
|
86 | + $wpdb->query( "UPDATE {$wpdb->posts} SET post_status = CONCAT( 'wpi-', post_status ) WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
87 | + |
|
88 | + // Clean post cache |
|
89 | + foreach ( $results as $row ) { |
|
90 | + clean_post_cache( $row->ID ); |
|
91 | + } |
|
92 | + } |
|
93 | + |
|
94 | + // Item meta key changes |
|
95 | + $query = 'SELECT DISTINCT post_id FROM ' . $wpdb->postmeta . " WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id', '_wpinv_cpt_name', '_wpinv_cpt_singular_name' )"; |
|
96 | + $results = $wpdb->get_results( $query ); |
|
97 | + |
|
98 | + if ( ! empty( $results ) ) { |
|
99 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" ); |
|
100 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" ); |
|
101 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" ); |
|
102 | + |
|
103 | + foreach ( $results as $row ) { |
|
104 | + clean_post_cache( $row->post_id ); |
|
105 | + } |
|
106 | + } |
|
107 | + |
|
108 | + $this->upgrade_from_102(); |
|
109 | + } |
|
110 | + |
|
111 | + /** |
|
112 | + * Upgrade to 1.0.3 |
|
113 | + * |
|
114 | + */ |
|
115 | + public function upgrade_from_102() { |
|
116 | + $this->create_subscriptions_table(); |
|
117 | + $this->upgrade_from_118(); |
|
118 | + } |
|
119 | + |
|
120 | + /** |
|
121 | + * Upgrade to version 2.0.0. |
|
122 | + * |
|
123 | + */ |
|
124 | + public function upgrade_from_118() { |
|
125 | + $this->create_invoices_table(); |
|
126 | + $this->create_invoice_items_table(); |
|
127 | + $this->migrate_old_invoices(); |
|
128 | + } |
|
129 | + |
|
130 | + /** |
|
131 | + * Upgrade to version 2.0.8. |
|
132 | + * |
|
133 | + */ |
|
134 | + public function upgrade_from_207() { |
|
135 | + global $wpdb; |
|
136 | + $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoice_items MODIFY COLUMN quantity FLOAT(20);" ); |
|
137 | + $this->upgrade_from_2615(); |
|
138 | + } |
|
139 | + |
|
140 | + /** |
|
141 | + * Upgrade to version 2.6.16. |
|
142 | + * |
|
143 | + */ |
|
144 | + public function upgrade_from_2615() { |
|
145 | + global $wpdb; |
|
146 | + $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoice_items MODIFY COLUMN item_price DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY custom_price DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY discount DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY subtotal DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY price DECIMAL(16,4) NOT NULL DEFAULT '0';" ); |
|
147 | + $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoices MODIFY COLUMN subtotal DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY tax DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY fees_total DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY total DECIMAL(16,4) NOT NULL DEFAULT '0', MODIFY discount DECIMAL(16,4) NOT NULL DEFAULT '0';" ); |
|
148 | + } |
|
149 | + |
|
150 | + /** |
|
151 | + * Give administrators the capability to manage GetPaid. |
|
152 | + * |
|
153 | + */ |
|
154 | + public function add_capabilities() { |
|
155 | + $GLOBALS['wp_roles']->add_cap( 'administrator', 'manage_invoicing' ); |
|
156 | + } |
|
157 | + |
|
158 | + /** |
|
159 | + * Retreives GetPaid pages. |
|
160 | + * |
|
161 | + */ |
|
162 | + public static function get_pages() { |
|
163 | + |
|
164 | + return apply_filters( |
|
165 | + 'wpinv_create_pages', |
|
166 | + array( |
|
167 | + |
|
168 | + // Checkout page. |
|
169 | + 'checkout_page' => array( |
|
170 | + 'name' => _x( 'gp-checkout', 'Page slug', 'invoicing' ), |
|
171 | + 'title' => _x( 'Checkout', 'Page title', 'invoicing' ), |
|
172 | + 'content' => ' |
|
173 | 173 | <!-- wp:shortcode --> |
174 | 174 | [wpinv_checkout] |
175 | 175 | <!-- /wp:shortcode --> |
176 | 176 | ', |
177 | - 'parent' => '', |
|
178 | - ), |
|
179 | - |
|
180 | - // Invoice history page. |
|
181 | - 'invoice_history_page' => array( |
|
182 | - 'name' => _x( 'gp-invoices', 'Page slug', 'invoicing' ), |
|
183 | - 'title' => _x( 'My Invoices', 'Page title', 'invoicing' ), |
|
184 | - 'content' => ' |
|
177 | + 'parent' => '', |
|
178 | + ), |
|
179 | + |
|
180 | + // Invoice history page. |
|
181 | + 'invoice_history_page' => array( |
|
182 | + 'name' => _x( 'gp-invoices', 'Page slug', 'invoicing' ), |
|
183 | + 'title' => _x( 'My Invoices', 'Page title', 'invoicing' ), |
|
184 | + 'content' => ' |
|
185 | 185 | <!-- wp:shortcode --> |
186 | 186 | [wpinv_history] |
187 | 187 | <!-- /wp:shortcode --> |
188 | 188 | ', |
189 | - 'parent' => '', |
|
190 | - ), |
|
191 | - |
|
192 | - // Success page content. |
|
193 | - 'success_page' => array( |
|
194 | - 'name' => _x( 'gp-receipt', 'Page slug', 'invoicing' ), |
|
195 | - 'title' => _x( 'Payment Confirmation', 'Page title', 'invoicing' ), |
|
196 | - 'content' => ' |
|
189 | + 'parent' => '', |
|
190 | + ), |
|
191 | + |
|
192 | + // Success page content. |
|
193 | + 'success_page' => array( |
|
194 | + 'name' => _x( 'gp-receipt', 'Page slug', 'invoicing' ), |
|
195 | + 'title' => _x( 'Payment Confirmation', 'Page title', 'invoicing' ), |
|
196 | + 'content' => ' |
|
197 | 197 | <!-- wp:shortcode --> |
198 | 198 | [wpinv_receipt] |
199 | 199 | <!-- /wp:shortcode --> |
200 | 200 | ', |
201 | - 'parent' => 'gp-checkout', |
|
202 | - ), |
|
203 | - |
|
204 | - // Failure page content. |
|
205 | - 'failure_page' => array( |
|
206 | - 'name' => _x( 'gp-transaction-failed', 'Page slug', 'invoicing' ), |
|
207 | - 'title' => _x( 'Transaction Failed', 'Page title', 'invoicing' ), |
|
208 | - 'content' => __( 'Your transaction failed, please try again or contact site support.', 'invoicing' ), |
|
209 | - 'parent' => 'gp-checkout', |
|
210 | - ), |
|
211 | - |
|
212 | - // Subscriptions history page. |
|
213 | - 'invoice_subscription_page' => array( |
|
214 | - 'name' => _x( 'gp-subscriptions', 'Page slug', 'invoicing' ), |
|
215 | - 'title' => _x( 'My Subscriptions', 'Page title', 'invoicing' ), |
|
216 | - 'content' => ' |
|
201 | + 'parent' => 'gp-checkout', |
|
202 | + ), |
|
203 | + |
|
204 | + // Failure page content. |
|
205 | + 'failure_page' => array( |
|
206 | + 'name' => _x( 'gp-transaction-failed', 'Page slug', 'invoicing' ), |
|
207 | + 'title' => _x( 'Transaction Failed', 'Page title', 'invoicing' ), |
|
208 | + 'content' => __( 'Your transaction failed, please try again or contact site support.', 'invoicing' ), |
|
209 | + 'parent' => 'gp-checkout', |
|
210 | + ), |
|
211 | + |
|
212 | + // Subscriptions history page. |
|
213 | + 'invoice_subscription_page' => array( |
|
214 | + 'name' => _x( 'gp-subscriptions', 'Page slug', 'invoicing' ), |
|
215 | + 'title' => _x( 'My Subscriptions', 'Page title', 'invoicing' ), |
|
216 | + 'content' => ' |
|
217 | 217 | <!-- wp:shortcode --> |
218 | 218 | [wpinv_subscriptions] |
219 | 219 | <!-- /wp:shortcode --> |
220 | 220 | ', |
221 | - 'parent' => '', |
|
222 | - ), |
|
221 | + 'parent' => '', |
|
222 | + ), |
|
223 | 223 | |
224 | - ) |
|
225 | - ); |
|
224 | + ) |
|
225 | + ); |
|
226 | 226 | |
227 | - } |
|
227 | + } |
|
228 | 228 | |
229 | - /** |
|
230 | - * Re-create GetPaid pages. |
|
231 | - * |
|
232 | - */ |
|
233 | - public function create_pages() { |
|
229 | + /** |
|
230 | + * Re-create GetPaid pages. |
|
231 | + * |
|
232 | + */ |
|
233 | + public function create_pages() { |
|
234 | 234 | |
235 | - foreach ( self::get_pages() as $key => $page ) { |
|
236 | - wpinv_create_page( esc_sql( $page['name'] ), $key, $page['title'], $page['content'], $page['parent'] ); |
|
237 | - } |
|
235 | + foreach ( self::get_pages() as $key => $page ) { |
|
236 | + wpinv_create_page( esc_sql( $page['name'] ), $key, $page['title'], $page['content'], $page['parent'] ); |
|
237 | + } |
|
238 | 238 | |
239 | - } |
|
239 | + } |
|
240 | 240 | |
241 | - /** |
|
242 | - * Create subscriptions table. |
|
243 | - * |
|
244 | - */ |
|
245 | - public function create_subscriptions_table() { |
|
241 | + /** |
|
242 | + * Create subscriptions table. |
|
243 | + * |
|
244 | + */ |
|
245 | + public function create_subscriptions_table() { |
|
246 | 246 | |
247 | - global $wpdb; |
|
247 | + global $wpdb; |
|
248 | 248 | |
249 | - require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
249 | + require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
250 | 250 | |
251 | - // Create tables. |
|
252 | - $charset_collate = $wpdb->get_charset_collate(); |
|
253 | - $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}wpinv_subscriptions ( |
|
251 | + // Create tables. |
|
252 | + $charset_collate = $wpdb->get_charset_collate(); |
|
253 | + $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}wpinv_subscriptions ( |
|
254 | 254 | id bigint(20) unsigned NOT NULL auto_increment, |
255 | 255 | customer_id bigint(20) NOT NULL, |
256 | 256 | frequency int(11) NOT NULL DEFAULT '1', |
@@ -273,22 +273,22 @@ discard block |
||
273 | 273 | KEY customer_and_status (customer_id, status) |
274 | 274 | ) $charset_collate;"; |
275 | 275 | |
276 | - dbDelta( $sql ); |
|
276 | + dbDelta( $sql ); |
|
277 | 277 | |
278 | - } |
|
278 | + } |
|
279 | 279 | |
280 | - /** |
|
281 | - * Create invoices table. |
|
282 | - * |
|
283 | - */ |
|
284 | - public function create_invoices_table() { |
|
285 | - global $wpdb; |
|
280 | + /** |
|
281 | + * Create invoices table. |
|
282 | + * |
|
283 | + */ |
|
284 | + public function create_invoices_table() { |
|
285 | + global $wpdb; |
|
286 | 286 | |
287 | - require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
287 | + require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
288 | 288 | |
289 | - // Create tables. |
|
290 | - $charset_collate = $wpdb->get_charset_collate(); |
|
291 | - $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}getpaid_invoices ( |
|
289 | + // Create tables. |
|
290 | + $charset_collate = $wpdb->get_charset_collate(); |
|
291 | + $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}getpaid_invoices ( |
|
292 | 292 | post_id BIGINT(20) NOT NULL, |
293 | 293 | `number` VARCHAR(100), |
294 | 294 | `key` VARCHAR(100), |
@@ -324,22 +324,22 @@ discard block |
||
324 | 324 | KEY `key` (`key`) |
325 | 325 | ) $charset_collate;"; |
326 | 326 | |
327 | - dbDelta( $sql ); |
|
327 | + dbDelta( $sql ); |
|
328 | 328 | |
329 | - } |
|
329 | + } |
|
330 | 330 | |
331 | - /** |
|
332 | - * Create invoice items table. |
|
333 | - * |
|
334 | - */ |
|
335 | - public function create_invoice_items_table() { |
|
336 | - global $wpdb; |
|
331 | + /** |
|
332 | + * Create invoice items table. |
|
333 | + * |
|
334 | + */ |
|
335 | + public function create_invoice_items_table() { |
|
336 | + global $wpdb; |
|
337 | 337 | |
338 | - require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
338 | + require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
339 | 339 | |
340 | - // Create tables. |
|
341 | - $charset_collate = $wpdb->get_charset_collate(); |
|
342 | - $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}getpaid_invoice_items ( |
|
340 | + // Create tables. |
|
341 | + $charset_collate = $wpdb->get_charset_collate(); |
|
342 | + $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}getpaid_invoice_items ( |
|
343 | 343 | ID BIGINT(20) NOT NULL AUTO_INCREMENT, |
344 | 344 | post_id BIGINT(20) NOT NULL, |
345 | 345 | item_id BIGINT(20) NOT NULL, |
@@ -361,159 +361,159 @@ discard block |
||
361 | 361 | KEY post_id (post_id) |
362 | 362 | ) $charset_collate;"; |
363 | 363 | |
364 | - dbDelta( $sql ); |
|
365 | - |
|
366 | - } |
|
367 | - |
|
368 | - /** |
|
369 | - * Migrates old invoices to new invoices. |
|
370 | - * |
|
371 | - */ |
|
372 | - public function migrate_old_invoices() { |
|
373 | - global $wpdb; |
|
374 | - |
|
375 | - $invoices_table = $wpdb->prefix . 'getpaid_invoices'; |
|
376 | - $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items'; |
|
377 | - $migrated = $wpdb->get_col( "SELECT post_id FROM $invoices_table" ); |
|
378 | - $invoices = array_unique( |
|
379 | - get_posts( |
|
380 | - array( |
|
381 | - 'post_type' => array( 'wpi_invoice', 'wpi_quote' ), |
|
382 | - 'posts_per_page' => -1, |
|
383 | - 'fields' => 'ids', |
|
384 | - 'post_status' => array_keys( get_post_stati() ), |
|
385 | - 'exclude' => (array) $migrated, |
|
386 | - ) |
|
387 | - ) |
|
388 | - ); |
|
389 | - |
|
390 | - // Abort if we do not have any invoices. |
|
391 | - if ( empty( $invoices ) ) { |
|
392 | - return; |
|
393 | - } |
|
394 | - |
|
395 | - require_once WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php'; |
|
396 | - |
|
397 | - $invoice_rows = array(); |
|
398 | - foreach ( $invoices as $invoice ) { |
|
399 | - |
|
400 | - $invoice = new WPInv_Legacy_Invoice( $invoice ); |
|
401 | - |
|
402 | - if ( empty( $invoice->ID ) ) { |
|
403 | - return; |
|
404 | - } |
|
405 | - |
|
406 | - $fields = array( |
|
407 | - 'post_id' => $invoice->ID, |
|
408 | - 'number' => $invoice->get_number(), |
|
409 | - 'key' => $invoice->get_key(), |
|
410 | - 'type' => str_replace( 'wpi_', '', $invoice->post_type ), |
|
411 | - 'mode' => $invoice->mode, |
|
412 | - 'user_ip' => $invoice->get_ip(), |
|
413 | - 'first_name' => $invoice->get_first_name(), |
|
414 | - 'last_name' => $invoice->get_last_name(), |
|
415 | - 'address' => $invoice->get_address(), |
|
416 | - 'city' => $invoice->city, |
|
417 | - 'state' => $invoice->state, |
|
418 | - 'country' => $invoice->country, |
|
419 | - 'zip' => $invoice->zip, |
|
420 | - 'adddress_confirmed' => (int) $invoice->adddress_confirmed, |
|
421 | - 'gateway' => $invoice->get_gateway(), |
|
422 | - 'transaction_id' => $invoice->get_transaction_id(), |
|
423 | - 'currency' => $invoice->get_currency(), |
|
424 | - 'subtotal' => $invoice->get_subtotal(), |
|
425 | - 'tax' => $invoice->get_tax(), |
|
426 | - 'fees_total' => $invoice->get_fees_total(), |
|
427 | - 'total' => $invoice->get_total(), |
|
428 | - 'discount' => $invoice->get_discount(), |
|
429 | - 'discount_code' => $invoice->get_discount_code(), |
|
430 | - 'disable_taxes' => $invoice->disable_taxes, |
|
431 | - 'due_date' => $invoice->get_due_date(), |
|
432 | - 'completed_date' => $invoice->get_completed_date(), |
|
433 | - 'company' => $invoice->company, |
|
434 | - 'vat_number' => $invoice->vat_number, |
|
435 | - 'vat_rate' => $invoice->vat_rate, |
|
436 | - 'custom_meta' => $invoice->payment_meta, |
|
437 | - ); |
|
438 | - |
|
439 | - foreach ( $fields as $key => $val ) { |
|
440 | - if ( is_null( $val ) ) { |
|
441 | - $val = ''; |
|
442 | - } |
|
443 | - $val = maybe_serialize( $val ); |
|
444 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
445 | - } |
|
446 | - |
|
447 | - $fields = implode( ', ', $fields ); |
|
448 | - $invoice_rows[] = "($fields)"; |
|
449 | - |
|
450 | - $item_rows = array(); |
|
451 | - $item_columns = array(); |
|
452 | - foreach ( $invoice->get_cart_details() as $details ) { |
|
453 | - $fields = array( |
|
454 | - 'post_id' => $invoice->ID, |
|
455 | - 'item_id' => $details['id'], |
|
456 | - 'item_name' => $details['name'], |
|
457 | - 'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'], |
|
458 | - 'vat_rate' => $details['vat_rate'], |
|
459 | - 'vat_class' => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'], |
|
460 | - 'tax' => $details['tax'], |
|
461 | - 'item_price' => $details['item_price'], |
|
462 | - 'custom_price' => $details['custom_price'], |
|
463 | - 'quantity' => $details['quantity'], |
|
464 | - 'discount' => $details['discount'], |
|
465 | - 'subtotal' => $details['subtotal'], |
|
466 | - 'price' => $details['price'], |
|
467 | - 'meta' => $details['meta'], |
|
468 | - 'fees' => $details['fees'], |
|
469 | - ); |
|
470 | - |
|
471 | - $item_columns = array_keys( $fields ); |
|
472 | - |
|
473 | - foreach ( $fields as $key => $val ) { |
|
474 | - if ( is_null( $val ) ) { |
|
475 | - $val = ''; |
|
476 | - } |
|
477 | - $val = maybe_serialize( $val ); |
|
478 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
479 | - } |
|
480 | - |
|
481 | - $fields = implode( ', ', $fields ); |
|
482 | - $item_rows[] = "($fields)"; |
|
483 | - } |
|
484 | - |
|
485 | - $item_rows = implode( ', ', $item_rows ); |
|
486 | - $item_columns = implode( ', ', $item_columns ); |
|
487 | - $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" ); |
|
488 | - } |
|
489 | - |
|
490 | - if ( empty( $invoice_rows ) ) { |
|
491 | - return; |
|
492 | - } |
|
493 | - |
|
494 | - $invoice_rows = implode( ', ', $invoice_rows ); |
|
495 | - $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" ); |
|
496 | - |
|
497 | - } |
|
498 | - |
|
499 | - /** |
|
500 | - * Migrates old invoices to new invoices. |
|
501 | - * |
|
502 | - */ |
|
503 | - public static function rename_gateways_label() { |
|
504 | - global $wpdb; |
|
505 | - |
|
506 | - foreach ( array_keys( wpinv_get_payment_gateways() ) as $gateway ) { |
|
507 | - |
|
508 | - $wpdb->update( |
|
509 | - $wpdb->prefix . 'getpaid_invoices', |
|
510 | - array( 'gateway' => $gateway ), |
|
511 | - array( 'gateway' => wpinv_get_gateway_admin_label( $gateway ) ), |
|
512 | - '%s', |
|
513 | - '%s' |
|
514 | - ); |
|
515 | - |
|
516 | - } |
|
517 | - } |
|
364 | + dbDelta( $sql ); |
|
365 | + |
|
366 | + } |
|
367 | + |
|
368 | + /** |
|
369 | + * Migrates old invoices to new invoices. |
|
370 | + * |
|
371 | + */ |
|
372 | + public function migrate_old_invoices() { |
|
373 | + global $wpdb; |
|
374 | + |
|
375 | + $invoices_table = $wpdb->prefix . 'getpaid_invoices'; |
|
376 | + $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items'; |
|
377 | + $migrated = $wpdb->get_col( "SELECT post_id FROM $invoices_table" ); |
|
378 | + $invoices = array_unique( |
|
379 | + get_posts( |
|
380 | + array( |
|
381 | + 'post_type' => array( 'wpi_invoice', 'wpi_quote' ), |
|
382 | + 'posts_per_page' => -1, |
|
383 | + 'fields' => 'ids', |
|
384 | + 'post_status' => array_keys( get_post_stati() ), |
|
385 | + 'exclude' => (array) $migrated, |
|
386 | + ) |
|
387 | + ) |
|
388 | + ); |
|
389 | + |
|
390 | + // Abort if we do not have any invoices. |
|
391 | + if ( empty( $invoices ) ) { |
|
392 | + return; |
|
393 | + } |
|
394 | + |
|
395 | + require_once WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php'; |
|
396 | + |
|
397 | + $invoice_rows = array(); |
|
398 | + foreach ( $invoices as $invoice ) { |
|
399 | + |
|
400 | + $invoice = new WPInv_Legacy_Invoice( $invoice ); |
|
401 | + |
|
402 | + if ( empty( $invoice->ID ) ) { |
|
403 | + return; |
|
404 | + } |
|
405 | + |
|
406 | + $fields = array( |
|
407 | + 'post_id' => $invoice->ID, |
|
408 | + 'number' => $invoice->get_number(), |
|
409 | + 'key' => $invoice->get_key(), |
|
410 | + 'type' => str_replace( 'wpi_', '', $invoice->post_type ), |
|
411 | + 'mode' => $invoice->mode, |
|
412 | + 'user_ip' => $invoice->get_ip(), |
|
413 | + 'first_name' => $invoice->get_first_name(), |
|
414 | + 'last_name' => $invoice->get_last_name(), |
|
415 | + 'address' => $invoice->get_address(), |
|
416 | + 'city' => $invoice->city, |
|
417 | + 'state' => $invoice->state, |
|
418 | + 'country' => $invoice->country, |
|
419 | + 'zip' => $invoice->zip, |
|
420 | + 'adddress_confirmed' => (int) $invoice->adddress_confirmed, |
|
421 | + 'gateway' => $invoice->get_gateway(), |
|
422 | + 'transaction_id' => $invoice->get_transaction_id(), |
|
423 | + 'currency' => $invoice->get_currency(), |
|
424 | + 'subtotal' => $invoice->get_subtotal(), |
|
425 | + 'tax' => $invoice->get_tax(), |
|
426 | + 'fees_total' => $invoice->get_fees_total(), |
|
427 | + 'total' => $invoice->get_total(), |
|
428 | + 'discount' => $invoice->get_discount(), |
|
429 | + 'discount_code' => $invoice->get_discount_code(), |
|
430 | + 'disable_taxes' => $invoice->disable_taxes, |
|
431 | + 'due_date' => $invoice->get_due_date(), |
|
432 | + 'completed_date' => $invoice->get_completed_date(), |
|
433 | + 'company' => $invoice->company, |
|
434 | + 'vat_number' => $invoice->vat_number, |
|
435 | + 'vat_rate' => $invoice->vat_rate, |
|
436 | + 'custom_meta' => $invoice->payment_meta, |
|
437 | + ); |
|
438 | + |
|
439 | + foreach ( $fields as $key => $val ) { |
|
440 | + if ( is_null( $val ) ) { |
|
441 | + $val = ''; |
|
442 | + } |
|
443 | + $val = maybe_serialize( $val ); |
|
444 | + $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
445 | + } |
|
446 | + |
|
447 | + $fields = implode( ', ', $fields ); |
|
448 | + $invoice_rows[] = "($fields)"; |
|
449 | + |
|
450 | + $item_rows = array(); |
|
451 | + $item_columns = array(); |
|
452 | + foreach ( $invoice->get_cart_details() as $details ) { |
|
453 | + $fields = array( |
|
454 | + 'post_id' => $invoice->ID, |
|
455 | + 'item_id' => $details['id'], |
|
456 | + 'item_name' => $details['name'], |
|
457 | + 'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'], |
|
458 | + 'vat_rate' => $details['vat_rate'], |
|
459 | + 'vat_class' => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'], |
|
460 | + 'tax' => $details['tax'], |
|
461 | + 'item_price' => $details['item_price'], |
|
462 | + 'custom_price' => $details['custom_price'], |
|
463 | + 'quantity' => $details['quantity'], |
|
464 | + 'discount' => $details['discount'], |
|
465 | + 'subtotal' => $details['subtotal'], |
|
466 | + 'price' => $details['price'], |
|
467 | + 'meta' => $details['meta'], |
|
468 | + 'fees' => $details['fees'], |
|
469 | + ); |
|
470 | + |
|
471 | + $item_columns = array_keys( $fields ); |
|
472 | + |
|
473 | + foreach ( $fields as $key => $val ) { |
|
474 | + if ( is_null( $val ) ) { |
|
475 | + $val = ''; |
|
476 | + } |
|
477 | + $val = maybe_serialize( $val ); |
|
478 | + $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
479 | + } |
|
480 | + |
|
481 | + $fields = implode( ', ', $fields ); |
|
482 | + $item_rows[] = "($fields)"; |
|
483 | + } |
|
484 | + |
|
485 | + $item_rows = implode( ', ', $item_rows ); |
|
486 | + $item_columns = implode( ', ', $item_columns ); |
|
487 | + $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" ); |
|
488 | + } |
|
489 | + |
|
490 | + if ( empty( $invoice_rows ) ) { |
|
491 | + return; |
|
492 | + } |
|
493 | + |
|
494 | + $invoice_rows = implode( ', ', $invoice_rows ); |
|
495 | + $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" ); |
|
496 | + |
|
497 | + } |
|
498 | + |
|
499 | + /** |
|
500 | + * Migrates old invoices to new invoices. |
|
501 | + * |
|
502 | + */ |
|
503 | + public static function rename_gateways_label() { |
|
504 | + global $wpdb; |
|
505 | + |
|
506 | + foreach ( array_keys( wpinv_get_payment_gateways() ) as $gateway ) { |
|
507 | + |
|
508 | + $wpdb->update( |
|
509 | + $wpdb->prefix . 'getpaid_invoices', |
|
510 | + array( 'gateway' => $gateway ), |
|
511 | + array( 'gateway' => wpinv_get_gateway_admin_label( $gateway ) ), |
|
512 | + '%s', |
|
513 | + '%s' |
|
514 | + ); |
|
515 | + |
|
516 | + } |
|
517 | + } |
|
518 | 518 | |
519 | 519 | } |
@@ -12,47 +12,47 @@ discard block |
||
12 | 12 | */ |
13 | 13 | class GetPaid_Reports_Export { |
14 | 14 | |
15 | - /** |
|
16 | - * Displays the reports tab. |
|
17 | - * |
|
18 | - */ |
|
19 | - public function display() { |
|
20 | - |
|
21 | - echo "<div class='row mt-4' style='max-width: 920px;' >"; |
|
22 | - foreach ( array_keys( getpaid_get_invoice_post_types() ) as $post_type ) { |
|
23 | - $this->display_post_type_export( $post_type ); |
|
24 | - } |
|
25 | - $this->display_subscription_export(); |
|
26 | - echo '</div>'; |
|
27 | - |
|
28 | - } |
|
29 | - |
|
30 | - /** |
|
31 | - * Retrieves the download url. |
|
32 | - * |
|
33 | - */ |
|
34 | - public function get_download_url( $post_type ) { |
|
35 | - |
|
36 | - return wp_nonce_url( |
|
37 | - add_query_arg( |
|
38 | - array( |
|
39 | - 'getpaid-admin-action' => 'export_invoices', |
|
40 | - 'post_type' => urlencode( $post_type ), |
|
41 | - ) |
|
42 | - ), |
|
43 | - 'getpaid-nonce', |
|
44 | - 'getpaid-nonce' |
|
45 | - ); |
|
46 | - |
|
47 | - } |
|
48 | - |
|
49 | - /** |
|
50 | - * Displays a single post type export card. |
|
51 | - * |
|
52 | - */ |
|
53 | - public function display_post_type_export( $post_type ) { |
|
54 | - |
|
55 | - ?> |
|
15 | + /** |
|
16 | + * Displays the reports tab. |
|
17 | + * |
|
18 | + */ |
|
19 | + public function display() { |
|
20 | + |
|
21 | + echo "<div class='row mt-4' style='max-width: 920px;' >"; |
|
22 | + foreach ( array_keys( getpaid_get_invoice_post_types() ) as $post_type ) { |
|
23 | + $this->display_post_type_export( $post_type ); |
|
24 | + } |
|
25 | + $this->display_subscription_export(); |
|
26 | + echo '</div>'; |
|
27 | + |
|
28 | + } |
|
29 | + |
|
30 | + /** |
|
31 | + * Retrieves the download url. |
|
32 | + * |
|
33 | + */ |
|
34 | + public function get_download_url( $post_type ) { |
|
35 | + |
|
36 | + return wp_nonce_url( |
|
37 | + add_query_arg( |
|
38 | + array( |
|
39 | + 'getpaid-admin-action' => 'export_invoices', |
|
40 | + 'post_type' => urlencode( $post_type ), |
|
41 | + ) |
|
42 | + ), |
|
43 | + 'getpaid-nonce', |
|
44 | + 'getpaid-nonce' |
|
45 | + ); |
|
46 | + |
|
47 | + } |
|
48 | + |
|
49 | + /** |
|
50 | + * Displays a single post type export card. |
|
51 | + * |
|
52 | + */ |
|
53 | + public function display_post_type_export( $post_type ) { |
|
54 | + |
|
55 | + ?> |
|
56 | 56 | |
57 | 57 | <div class="col-12 col-md-6"> |
58 | 58 | <div class="card m-0 p-0" style="max-width:100%"> |
@@ -60,11 +60,11 @@ discard block |
||
60 | 60 | <div class="card-header"> |
61 | 61 | <strong> |
62 | 62 | <?php |
63 | - printf( |
|
64 | - esc_html__( 'Export %s', 'invoicing' ), |
|
65 | - esc_html( getpaid_get_post_type_label( $post_type ) ) |
|
66 | - ); |
|
67 | - ?> |
|
63 | + printf( |
|
64 | + esc_html__( 'Export %s', 'invoicing' ), |
|
65 | + esc_html( getpaid_get_post_type_label( $post_type ) ) |
|
66 | + ); |
|
67 | + ?> |
|
68 | 68 | </strong> |
69 | 69 | </div> |
70 | 70 | |
@@ -73,12 +73,12 @@ discard block |
||
73 | 73 | <form method="post" action="<?php echo esc_url( $this->get_download_url( $post_type ) ); ?>"> |
74 | 74 | |
75 | 75 | <?php |
76 | - $this->generate_from_date( $post_type ); |
|
77 | - $this->generate_to_date( $post_type ); |
|
78 | - $this->generate_post_status_select( $post_type ); |
|
79 | - $this->generate_file_type_select( $post_type ); |
|
80 | - submit_button( __( 'Download', 'invoicing' ) ); |
|
81 | - ?> |
|
76 | + $this->generate_from_date( $post_type ); |
|
77 | + $this->generate_to_date( $post_type ); |
|
78 | + $this->generate_post_status_select( $post_type ); |
|
79 | + $this->generate_file_type_select( $post_type ); |
|
80 | + submit_button( __( 'Download', 'invoicing' ) ); |
|
81 | + ?> |
|
82 | 82 | |
83 | 83 | </form> |
84 | 84 | |
@@ -89,135 +89,135 @@ discard block |
||
89 | 89 | |
90 | 90 | <?php |
91 | 91 | |
92 | - } |
|
93 | - |
|
94 | - /** |
|
95 | - * Generates the from date input field. |
|
96 | - * |
|
97 | - */ |
|
98 | - public function generate_from_date( $post_type ) { |
|
99 | - |
|
100 | - aui()->input( |
|
101 | - array( |
|
102 | - 'type' => 'datepicker', |
|
103 | - 'id' => esc_attr( "$post_type-from_date" ), |
|
104 | - 'name' => 'from_date', |
|
105 | - 'label' => __( 'From Date', 'invoicing' ), |
|
106 | - 'label_type' => 'vertical', |
|
107 | - 'placeholder' => 'YYYY-MM-DD', |
|
108 | - 'extra_attributes' => array( |
|
109 | - 'data-enable-time' => 'false', |
|
110 | - 'data-allow-input' => 'true', |
|
111 | - ), |
|
112 | - ), |
|
113 | - true |
|
114 | - ); |
|
115 | - |
|
116 | - } |
|
117 | - |
|
118 | - /** |
|
119 | - * Generates the to date input field. |
|
120 | - * |
|
121 | - */ |
|
122 | - public function generate_to_date( $post_type ) { |
|
123 | - |
|
124 | - aui()->input( |
|
125 | - array( |
|
126 | - 'type' => 'datepicker', |
|
127 | - 'id' => esc_attr( "$post_type-to_date" ), |
|
128 | - 'name' => 'to_date', |
|
129 | - 'label' => __( 'To Date', 'invoicing' ), |
|
130 | - 'label_type' => 'vertical', |
|
131 | - 'placeholder' => 'YYYY-MM-DD', |
|
132 | - 'extra_attributes' => array( |
|
133 | - 'data-enable-time' => 'false', |
|
134 | - 'data-allow-input' => 'true', |
|
135 | - ), |
|
136 | - ), |
|
137 | - true |
|
138 | - ); |
|
139 | - } |
|
140 | - |
|
141 | - /** |
|
142 | - * Generates the to post status select field. |
|
143 | - * |
|
144 | - */ |
|
145 | - public function generate_post_status_select( $post_type ) { |
|
146 | - |
|
147 | - if ( 'subscriptions' === $post_type ) { |
|
148 | - $options = getpaid_get_subscription_statuses(); |
|
149 | - } else { |
|
150 | - $options = wpinv_get_invoice_statuses( true, false, $post_type ); |
|
151 | - } |
|
152 | - |
|
153 | - aui()->select( |
|
154 | - array( |
|
155 | - 'name' => 'status', |
|
156 | - 'id' => esc_attr( "$post_type-status" ), |
|
157 | - 'placeholder' => __( 'All Statuses', 'invoicing' ), |
|
158 | - 'label' => __( 'Status', 'invoicing' ), |
|
159 | - 'label_type' => 'vertical', |
|
160 | - 'label_class' => 'd-block', |
|
161 | - 'options' => $options, |
|
162 | - ), |
|
163 | - true |
|
164 | - ); |
|
165 | - |
|
166 | - } |
|
167 | - |
|
168 | - /** |
|
169 | - * Generates the to file type select field. |
|
170 | - * |
|
171 | - */ |
|
172 | - public function generate_file_type_select( $post_type ) { |
|
173 | - |
|
174 | - aui()->select( |
|
175 | - array( |
|
176 | - 'name' => 'file_type', |
|
177 | - 'id' => esc_attr( "$post_type-file_type" ), |
|
178 | - 'placeholder' => __( 'Select File Type', 'invoicing' ), |
|
179 | - 'label' => __( 'Export File', 'invoicing' ), |
|
180 | - 'label_type' => 'vertical', |
|
181 | - 'label_class' => 'd-block', |
|
182 | - 'value' => 'csv', |
|
183 | - 'options' => array( |
|
184 | - 'csv' => __( 'CSV', 'invoicing' ), |
|
185 | - 'xml' => __( 'XML', 'invoicing' ), |
|
186 | - 'json' => __( 'JSON', 'invoicing' ), |
|
187 | - ), |
|
188 | - ), |
|
189 | - true |
|
190 | - ); |
|
191 | - |
|
192 | - } |
|
193 | - |
|
194 | - /** |
|
195 | - * Displays a field's markup. |
|
196 | - * |
|
197 | - */ |
|
198 | - public function display_markup( $markup ) { |
|
199 | - |
|
200 | - echo wp_kses( |
|
201 | - str_replace( |
|
202 | - array( |
|
203 | - 'form-control', |
|
204 | - 'custom-select', |
|
205 | - ), |
|
206 | - 'regular-text', |
|
207 | - $markup |
|
208 | - ), |
|
209 | - getpaid_allowed_html() |
|
210 | - ); |
|
211 | - |
|
212 | - } |
|
213 | - |
|
214 | - /** |
|
215 | - * Displays a subscription export card. |
|
216 | - * |
|
217 | - */ |
|
218 | - public function display_subscription_export() { |
|
219 | - |
|
220 | - ?> |
|
92 | + } |
|
93 | + |
|
94 | + /** |
|
95 | + * Generates the from date input field. |
|
96 | + * |
|
97 | + */ |
|
98 | + public function generate_from_date( $post_type ) { |
|
99 | + |
|
100 | + aui()->input( |
|
101 | + array( |
|
102 | + 'type' => 'datepicker', |
|
103 | + 'id' => esc_attr( "$post_type-from_date" ), |
|
104 | + 'name' => 'from_date', |
|
105 | + 'label' => __( 'From Date', 'invoicing' ), |
|
106 | + 'label_type' => 'vertical', |
|
107 | + 'placeholder' => 'YYYY-MM-DD', |
|
108 | + 'extra_attributes' => array( |
|
109 | + 'data-enable-time' => 'false', |
|
110 | + 'data-allow-input' => 'true', |
|
111 | + ), |
|
112 | + ), |
|
113 | + true |
|
114 | + ); |
|
115 | + |
|
116 | + } |
|
117 | + |
|
118 | + /** |
|
119 | + * Generates the to date input field. |
|
120 | + * |
|
121 | + */ |
|
122 | + public function generate_to_date( $post_type ) { |
|
123 | + |
|
124 | + aui()->input( |
|
125 | + array( |
|
126 | + 'type' => 'datepicker', |
|
127 | + 'id' => esc_attr( "$post_type-to_date" ), |
|
128 | + 'name' => 'to_date', |
|
129 | + 'label' => __( 'To Date', 'invoicing' ), |
|
130 | + 'label_type' => 'vertical', |
|
131 | + 'placeholder' => 'YYYY-MM-DD', |
|
132 | + 'extra_attributes' => array( |
|
133 | + 'data-enable-time' => 'false', |
|
134 | + 'data-allow-input' => 'true', |
|
135 | + ), |
|
136 | + ), |
|
137 | + true |
|
138 | + ); |
|
139 | + } |
|
140 | + |
|
141 | + /** |
|
142 | + * Generates the to post status select field. |
|
143 | + * |
|
144 | + */ |
|
145 | + public function generate_post_status_select( $post_type ) { |
|
146 | + |
|
147 | + if ( 'subscriptions' === $post_type ) { |
|
148 | + $options = getpaid_get_subscription_statuses(); |
|
149 | + } else { |
|
150 | + $options = wpinv_get_invoice_statuses( true, false, $post_type ); |
|
151 | + } |
|
152 | + |
|
153 | + aui()->select( |
|
154 | + array( |
|
155 | + 'name' => 'status', |
|
156 | + 'id' => esc_attr( "$post_type-status" ), |
|
157 | + 'placeholder' => __( 'All Statuses', 'invoicing' ), |
|
158 | + 'label' => __( 'Status', 'invoicing' ), |
|
159 | + 'label_type' => 'vertical', |
|
160 | + 'label_class' => 'd-block', |
|
161 | + 'options' => $options, |
|
162 | + ), |
|
163 | + true |
|
164 | + ); |
|
165 | + |
|
166 | + } |
|
167 | + |
|
168 | + /** |
|
169 | + * Generates the to file type select field. |
|
170 | + * |
|
171 | + */ |
|
172 | + public function generate_file_type_select( $post_type ) { |
|
173 | + |
|
174 | + aui()->select( |
|
175 | + array( |
|
176 | + 'name' => 'file_type', |
|
177 | + 'id' => esc_attr( "$post_type-file_type" ), |
|
178 | + 'placeholder' => __( 'Select File Type', 'invoicing' ), |
|
179 | + 'label' => __( 'Export File', 'invoicing' ), |
|
180 | + 'label_type' => 'vertical', |
|
181 | + 'label_class' => 'd-block', |
|
182 | + 'value' => 'csv', |
|
183 | + 'options' => array( |
|
184 | + 'csv' => __( 'CSV', 'invoicing' ), |
|
185 | + 'xml' => __( 'XML', 'invoicing' ), |
|
186 | + 'json' => __( 'JSON', 'invoicing' ), |
|
187 | + ), |
|
188 | + ), |
|
189 | + true |
|
190 | + ); |
|
191 | + |
|
192 | + } |
|
193 | + |
|
194 | + /** |
|
195 | + * Displays a field's markup. |
|
196 | + * |
|
197 | + */ |
|
198 | + public function display_markup( $markup ) { |
|
199 | + |
|
200 | + echo wp_kses( |
|
201 | + str_replace( |
|
202 | + array( |
|
203 | + 'form-control', |
|
204 | + 'custom-select', |
|
205 | + ), |
|
206 | + 'regular-text', |
|
207 | + $markup |
|
208 | + ), |
|
209 | + getpaid_allowed_html() |
|
210 | + ); |
|
211 | + |
|
212 | + } |
|
213 | + |
|
214 | + /** |
|
215 | + * Displays a subscription export card. |
|
216 | + * |
|
217 | + */ |
|
218 | + public function display_subscription_export() { |
|
219 | + |
|
220 | + ?> |
|
221 | 221 | |
222 | 222 | <div class="col-12 col-md-6"> |
223 | 223 | <div class="card m-0 p-0" style="max-width:100%"> |
@@ -233,12 +233,12 @@ discard block |
||
233 | 233 | <form method="post" action="<?php echo esc_url( $this->get_download_url( 'subscriptions' ) ); ?>"> |
234 | 234 | |
235 | 235 | <?php |
236 | - $this->generate_from_date( 'subscriptions' ); |
|
237 | - $this->generate_to_date( 'subscriptions' ); |
|
238 | - $this->generate_post_status_select( 'subscriptions' ); |
|
239 | - $this->generate_file_type_select( 'subscriptions' ); |
|
240 | - submit_button( __( 'Download', 'invoicing' ) ); |
|
241 | - ?> |
|
236 | + $this->generate_from_date( 'subscriptions' ); |
|
237 | + $this->generate_to_date( 'subscriptions' ); |
|
238 | + $this->generate_post_status_select( 'subscriptions' ); |
|
239 | + $this->generate_file_type_select( 'subscriptions' ); |
|
240 | + submit_button( __( 'Download', 'invoicing' ) ); |
|
241 | + ?> |
|
242 | 242 | |
243 | 243 | </form> |
244 | 244 | |
@@ -249,6 +249,6 @@ discard block |
||
249 | 249 | |
250 | 250 | <?php |
251 | 251 | |
252 | - } |
|
252 | + } |
|
253 | 253 | |
254 | 254 | } |
@@ -16,512 +16,512 @@ |
||
16 | 16 | */ |
17 | 17 | class GetPaid_Subscriptions_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 subscriptions. |
|
29 | - * |
|
30 | - * @since 1.0.19 |
|
31 | - * @var array |
|
32 | - */ |
|
33 | - private $results; |
|
34 | - |
|
35 | - /** |
|
36 | - * Total number of found subscriptions for the current query |
|
37 | - * |
|
38 | - * @since 1.0.19 |
|
39 | - * @var int |
|
40 | - */ |
|
41 | - private $total_subscriptions = 0; |
|
42 | - |
|
43 | - /** |
|
44 | - * The SQL query used to fetch matching subscriptions. |
|
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 | - 'status' => 'all', |
|
118 | - 'customer_in' => array(), |
|
119 | - 'customer_not_in' => array(), |
|
120 | - 'product_in' => array(), |
|
121 | - 'product_not_in' => array(), |
|
122 | - 'include' => array(), |
|
123 | - 'exclude' => array(), |
|
124 | - 'orderby' => 'id', |
|
125 | - 'order' => 'DESC', |
|
126 | - 'offset' => '', |
|
127 | - 'number' => 10, |
|
128 | - 'paged' => 1, |
|
129 | - 'count_total' => true, |
|
130 | - 'fields' => 'all', |
|
131 | - ); |
|
132 | - |
|
133 | - return wp_parse_args( $args, $defaults ); |
|
134 | - } |
|
135 | - |
|
136 | - /** |
|
137 | - * Prepare the query variables. |
|
138 | - * |
|
139 | - * @since 1.0.19 |
|
140 | - * |
|
141 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
142 | - * |
|
143 | - * @param string|array $query { |
|
144 | - * Optional. Array or string of Query parameters. |
|
145 | - * |
|
146 | - * @type string|array $status The subscription status to filter by. Can either be a single status or an array of statuses. |
|
147 | - * Default is all. |
|
148 | - * @type int[] $customer_in An array of customer ids to filter by. |
|
149 | - * @type int[] $customer_not_in An array of customer ids whose subscriptions should be excluded. |
|
150 | - * @type int[] $invoice_in An array of invoice ids to filter by. |
|
151 | - * @type int[] $invoice_not_in An array of invoice ids whose subscriptions should be excluded. |
|
152 | - * @type int[] $product_in An array of product ids to filter by. |
|
153 | - * @type int[] $product_not_in An array of product ids whose subscriptions should be excluded. |
|
154 | - * @type array $date_created_query A WP_Date_Query compatible array use to filter subscriptions by their date of creation. |
|
155 | - * @type array $date_expires_query A WP_Date_Query compatible array use to filter subscriptions by their expiration date. |
|
156 | - * @type array $include An array of subscription IDs to include. Default empty array. |
|
157 | - * @type array $exclude An array of subscription IDs to exclude. Default empty array. |
|
158 | - * @type string|array $orderby Field(s) to sort the retrieved subscription by. May be a single value, |
|
159 | - * an array of values, or a multi-dimensional array with fields as |
|
160 | - * keys and orders ('ASC' or 'DESC') as values. Accepted values are |
|
161 | - * 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
162 | - * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
163 | - * 'transaction_id', 'product_id', 'trial_period', 'include', 'status', 'profile_id'. Default array( 'id' ). |
|
164 | - * @type string $order Designates ascending or descending order of subscriptions. Order values |
|
165 | - * passed as part of an `$orderby` array take precedence over this |
|
166 | - * parameter. Accepts 'ASC', 'DESC'. Default 'DESC'. |
|
167 | - * @type int $offset Number of subscriptions to offset in retrieved results. Can be used in |
|
168 | - * conjunction with pagination. Default 0. |
|
169 | - * @type int $number Number of subscriptions to limit the query for. Can be used in |
|
170 | - * conjunction with pagination. Value -1 (all) is supported, but |
|
171 | - * should be used with caution on larger sites. |
|
172 | - * Default 10. |
|
173 | - * @type int $paged When used with number, defines the page of results to return. |
|
174 | - * Default 1. |
|
175 | - * @type bool $count_total Whether to count the total number of subscriptions found. If pagination |
|
176 | - * is not needed, setting this to false can improve performance. |
|
177 | - * Default true. |
|
178 | - * @type string|array $fields Which fields to return. Single or all fields (string), or array |
|
179 | - * of fields. Accepts 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
180 | - * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
181 | - * 'transaction_id', 'product_id', 'trial_period', 'status', 'profile_id'. |
|
182 | - * Use 'all' for all fields. Default 'all'. |
|
183 | - * } |
|
184 | - */ |
|
185 | - public function prepare_query( $query = array() ) { |
|
186 | - global $wpdb; |
|
187 | - |
|
188 | - if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
189 | - $this->query_limit = null; |
|
190 | - $this->query_vars = $this->fill_query_vars( $query ); |
|
191 | - } |
|
192 | - |
|
193 | - if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
194 | - $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
195 | - } |
|
196 | - |
|
197 | - do_action( 'getpaid_pre_get_subscriptions', array( &$this ) ); |
|
198 | - |
|
199 | - // Ensure that query vars are filled after 'getpaid_pre_get_subscriptions'. |
|
200 | - $qv =& $this->query_vars; |
|
201 | - $qv = $this->fill_query_vars( $qv ); |
|
202 | - $table = $wpdb->prefix . 'wpinv_subscriptions'; |
|
203 | - $this->query_from = "FROM $table"; |
|
204 | - |
|
205 | - // Prepare query fields. |
|
206 | - $this->prepare_query_fields( $qv, $table ); |
|
207 | - |
|
208 | - // Prepare query where. |
|
209 | - $this->prepare_query_where( $qv, $table ); |
|
210 | - |
|
211 | - // Prepare query order. |
|
212 | - $this->prepare_query_order( $qv, $table ); |
|
213 | - |
|
214 | - // limit |
|
215 | - if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
216 | - if ( $qv['offset'] ) { |
|
217 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
218 | - } else { |
|
219 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
220 | - } |
|
221 | - } |
|
222 | - |
|
223 | - do_action_ref_array( 'getpaid_after_subscriptions_query', array( &$this ) ); |
|
224 | - } |
|
225 | - |
|
226 | - /** |
|
227 | - * Prepares the query fields. |
|
228 | - * |
|
229 | - * @since 1.0.19 |
|
230 | - * |
|
231 | - * @param array $qv Query vars. |
|
232 | - * @param string $table Table name. |
|
233 | - */ |
|
234 | - protected function prepare_query_fields( &$qv, $table ) { |
|
235 | - |
|
236 | - if ( is_array( $qv['fields'] ) ) { |
|
237 | - $qv['fields'] = array_unique( $qv['fields'] ); |
|
238 | - |
|
239 | - $query_fields = array(); |
|
240 | - foreach ( $qv['fields'] as $field ) { |
|
241 | - $field = sanitize_key( $field ); |
|
242 | - $query_fields[] = "$table.`$field`"; |
|
243 | - } |
|
244 | - $this->query_fields = implode( ',', $query_fields ); |
|
245 | - } else { |
|
246 | - $this->query_fields = "$table.*"; |
|
247 | - } |
|
248 | - |
|
249 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
250 | - $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
251 | - } |
|
252 | - |
|
253 | - } |
|
254 | - |
|
255 | - /** |
|
256 | - * Prepares the query where. |
|
257 | - * |
|
258 | - * @since 1.0.19 |
|
259 | - * |
|
260 | - * @param array $qv Query vars. |
|
261 | - * @param string $table Table name. |
|
262 | - */ |
|
263 | - protected function prepare_query_where( &$qv, $table ) { |
|
264 | - global $wpdb; |
|
265 | - $this->query_where = 'WHERE 1=1'; |
|
266 | - |
|
267 | - // Status. |
|
268 | - if ( 'all' !== $qv['status'] ) { |
|
269 | - $statuses = wpinv_clean( wpinv_parse_list( $qv['status'] ) ); |
|
270 | - $prepared_statuses = join( ',', array_fill( 0, count( $statuses ), '%s' ) ); |
|
271 | - $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $prepared_statuses )", $statuses ); |
|
272 | - } |
|
273 | - |
|
274 | - if ( ! empty( $qv['customer_in'] ) ) { |
|
275 | - $customer_in = implode( ',', wp_parse_id_list( $qv['customer_in'] ) ); |
|
276 | - $this->query_where .= " AND $table.`customer_id` IN ($customer_in)"; |
|
277 | - } elseif ( ! empty( $qv['customer_not_in'] ) ) { |
|
278 | - $customer_not_in = implode( ',', wp_parse_id_list( $qv['customer_not_in'] ) ); |
|
279 | - $this->query_where .= " AND $table.`customer_id` NOT IN ($customer_not_in)"; |
|
280 | - } |
|
281 | - |
|
282 | - if ( ! empty( $qv['product_in'] ) ) { |
|
283 | - $product_in = implode( ',', wp_parse_id_list( $qv['product_in'] ) ); |
|
284 | - $this->query_where .= " AND $table.`product_id` IN ($product_in)"; |
|
285 | - } elseif ( ! empty( $qv['product_not_in'] ) ) { |
|
286 | - $product_not_in = implode( ',', wp_parse_id_list( $qv['product_not_in'] ) ); |
|
287 | - $this->query_where .= " AND $table.`product_id` NOT IN ($product_not_in)"; |
|
288 | - } |
|
289 | - |
|
290 | - if ( ! empty( $qv['invoice_in'] ) ) { |
|
291 | - $invoice_in = implode( ',', wp_parse_id_list( $qv['invoice_in'] ) ); |
|
292 | - $this->query_where .= " AND $table.`parent_payment_id` IN ($invoice_in)"; |
|
293 | - } elseif ( ! empty( $qv['invoice_not_in'] ) ) { |
|
294 | - $invoice_not_in = implode( ',', wp_parse_id_list( $qv['invoice_not_in'] ) ); |
|
295 | - $this->query_where .= " AND $table.`parent_payment_id` NOT IN ($invoice_not_in)"; |
|
296 | - } |
|
297 | - |
|
298 | - if ( ! empty( $qv['include'] ) ) { |
|
299 | - $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
300 | - $this->query_where .= " AND $table.`id` IN ($include)"; |
|
301 | - } elseif ( ! empty( $qv['exclude'] ) ) { |
|
302 | - $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
303 | - $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
304 | - } |
|
305 | - |
|
306 | - // Date queries are allowed for the subscription creation date. |
|
307 | - if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
308 | - $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.created" ); |
|
309 | - $this->query_where .= $date_created_query->get_sql(); |
|
310 | - } |
|
311 | - |
|
312 | - // Date queries are also allowed for the subscription expiration date. |
|
313 | - if ( ! empty( $qv['date_expires_query'] ) && is_array( $qv['date_expires_query'] ) ) { |
|
314 | - $date_expires_query = new WP_Date_Query( $qv['date_expires_query'], "$table.expiration" ); |
|
315 | - $this->query_where .= $date_expires_query->get_sql(); |
|
316 | - } |
|
317 | - |
|
318 | - } |
|
319 | - |
|
320 | - /** |
|
321 | - * Prepares the query order. |
|
322 | - * |
|
323 | - * @since 1.0.19 |
|
324 | - * |
|
325 | - * @param array $qv Query vars. |
|
326 | - * @param string $table Table name. |
|
327 | - */ |
|
328 | - protected function prepare_query_order( &$qv, $table ) { |
|
329 | - |
|
330 | - // sorting. |
|
331 | - $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
332 | - $order = $this->parse_order( $qv['order'] ); |
|
333 | - |
|
334 | - // Default order is by 'id' (latest subscriptions). |
|
335 | - if ( empty( $qv['orderby'] ) ) { |
|
336 | - $qv['orderby'] = array( 'id' ); |
|
337 | - } |
|
338 | - |
|
339 | - // 'orderby' values may be an array, comma- or space-separated list. |
|
340 | - $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
341 | - |
|
342 | - $orderby_array = array(); |
|
343 | - foreach ( $ordersby as $_key => $_value ) { |
|
344 | - |
|
345 | - if ( is_int( $_key ) ) { |
|
346 | - // Integer key means this is a flat array of 'orderby' fields. |
|
347 | - $_orderby = $_value; |
|
348 | - $_order = $order; |
|
349 | - } else { |
|
350 | - // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
351 | - $_orderby = $_key; |
|
352 | - $_order = $_value; |
|
353 | - } |
|
354 | - |
|
355 | - $parsed = $this->parse_orderby( $_orderby, $table ); |
|
356 | - |
|
357 | - if ( $parsed ) { |
|
358 | - $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
359 | - } |
|
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 subscriptions. |
|
29 | + * |
|
30 | + * @since 1.0.19 |
|
31 | + * @var array |
|
32 | + */ |
|
33 | + private $results; |
|
34 | + |
|
35 | + /** |
|
36 | + * Total number of found subscriptions for the current query |
|
37 | + * |
|
38 | + * @since 1.0.19 |
|
39 | + * @var int |
|
40 | + */ |
|
41 | + private $total_subscriptions = 0; |
|
42 | + |
|
43 | + /** |
|
44 | + * The SQL query used to fetch matching subscriptions. |
|
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 | + 'status' => 'all', |
|
118 | + 'customer_in' => array(), |
|
119 | + 'customer_not_in' => array(), |
|
120 | + 'product_in' => array(), |
|
121 | + 'product_not_in' => array(), |
|
122 | + 'include' => array(), |
|
123 | + 'exclude' => array(), |
|
124 | + 'orderby' => 'id', |
|
125 | + 'order' => 'DESC', |
|
126 | + 'offset' => '', |
|
127 | + 'number' => 10, |
|
128 | + 'paged' => 1, |
|
129 | + 'count_total' => true, |
|
130 | + 'fields' => 'all', |
|
131 | + ); |
|
132 | + |
|
133 | + return wp_parse_args( $args, $defaults ); |
|
134 | + } |
|
135 | + |
|
136 | + /** |
|
137 | + * Prepare the query variables. |
|
138 | + * |
|
139 | + * @since 1.0.19 |
|
140 | + * |
|
141 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
142 | + * |
|
143 | + * @param string|array $query { |
|
144 | + * Optional. Array or string of Query parameters. |
|
145 | + * |
|
146 | + * @type string|array $status The subscription status to filter by. Can either be a single status or an array of statuses. |
|
147 | + * Default is all. |
|
148 | + * @type int[] $customer_in An array of customer ids to filter by. |
|
149 | + * @type int[] $customer_not_in An array of customer ids whose subscriptions should be excluded. |
|
150 | + * @type int[] $invoice_in An array of invoice ids to filter by. |
|
151 | + * @type int[] $invoice_not_in An array of invoice ids whose subscriptions should be excluded. |
|
152 | + * @type int[] $product_in An array of product ids to filter by. |
|
153 | + * @type int[] $product_not_in An array of product ids whose subscriptions should be excluded. |
|
154 | + * @type array $date_created_query A WP_Date_Query compatible array use to filter subscriptions by their date of creation. |
|
155 | + * @type array $date_expires_query A WP_Date_Query compatible array use to filter subscriptions by their expiration date. |
|
156 | + * @type array $include An array of subscription IDs to include. Default empty array. |
|
157 | + * @type array $exclude An array of subscription IDs to exclude. Default empty array. |
|
158 | + * @type string|array $orderby Field(s) to sort the retrieved subscription by. May be a single value, |
|
159 | + * an array of values, or a multi-dimensional array with fields as |
|
160 | + * keys and orders ('ASC' or 'DESC') as values. Accepted values are |
|
161 | + * 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
162 | + * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
163 | + * 'transaction_id', 'product_id', 'trial_period', 'include', 'status', 'profile_id'. Default array( 'id' ). |
|
164 | + * @type string $order Designates ascending or descending order of subscriptions. Order values |
|
165 | + * passed as part of an `$orderby` array take precedence over this |
|
166 | + * parameter. Accepts 'ASC', 'DESC'. Default 'DESC'. |
|
167 | + * @type int $offset Number of subscriptions to offset in retrieved results. Can be used in |
|
168 | + * conjunction with pagination. Default 0. |
|
169 | + * @type int $number Number of subscriptions to limit the query for. Can be used in |
|
170 | + * conjunction with pagination. Value -1 (all) is supported, but |
|
171 | + * should be used with caution on larger sites. |
|
172 | + * Default 10. |
|
173 | + * @type int $paged When used with number, defines the page of results to return. |
|
174 | + * Default 1. |
|
175 | + * @type bool $count_total Whether to count the total number of subscriptions found. If pagination |
|
176 | + * is not needed, setting this to false can improve performance. |
|
177 | + * Default true. |
|
178 | + * @type string|array $fields Which fields to return. Single or all fields (string), or array |
|
179 | + * of fields. Accepts 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
180 | + * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
181 | + * 'transaction_id', 'product_id', 'trial_period', 'status', 'profile_id'. |
|
182 | + * Use 'all' for all fields. Default 'all'. |
|
183 | + * } |
|
184 | + */ |
|
185 | + public function prepare_query( $query = array() ) { |
|
186 | + global $wpdb; |
|
187 | + |
|
188 | + if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
189 | + $this->query_limit = null; |
|
190 | + $this->query_vars = $this->fill_query_vars( $query ); |
|
191 | + } |
|
192 | + |
|
193 | + if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
194 | + $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
195 | + } |
|
196 | + |
|
197 | + do_action( 'getpaid_pre_get_subscriptions', array( &$this ) ); |
|
198 | + |
|
199 | + // Ensure that query vars are filled after 'getpaid_pre_get_subscriptions'. |
|
200 | + $qv =& $this->query_vars; |
|
201 | + $qv = $this->fill_query_vars( $qv ); |
|
202 | + $table = $wpdb->prefix . 'wpinv_subscriptions'; |
|
203 | + $this->query_from = "FROM $table"; |
|
204 | + |
|
205 | + // Prepare query fields. |
|
206 | + $this->prepare_query_fields( $qv, $table ); |
|
207 | + |
|
208 | + // Prepare query where. |
|
209 | + $this->prepare_query_where( $qv, $table ); |
|
210 | + |
|
211 | + // Prepare query order. |
|
212 | + $this->prepare_query_order( $qv, $table ); |
|
213 | + |
|
214 | + // limit |
|
215 | + if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
216 | + if ( $qv['offset'] ) { |
|
217 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
218 | + } else { |
|
219 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
220 | + } |
|
221 | + } |
|
222 | + |
|
223 | + do_action_ref_array( 'getpaid_after_subscriptions_query', array( &$this ) ); |
|
224 | + } |
|
225 | + |
|
226 | + /** |
|
227 | + * Prepares the query fields. |
|
228 | + * |
|
229 | + * @since 1.0.19 |
|
230 | + * |
|
231 | + * @param array $qv Query vars. |
|
232 | + * @param string $table Table name. |
|
233 | + */ |
|
234 | + protected function prepare_query_fields( &$qv, $table ) { |
|
235 | + |
|
236 | + if ( is_array( $qv['fields'] ) ) { |
|
237 | + $qv['fields'] = array_unique( $qv['fields'] ); |
|
238 | + |
|
239 | + $query_fields = array(); |
|
240 | + foreach ( $qv['fields'] as $field ) { |
|
241 | + $field = sanitize_key( $field ); |
|
242 | + $query_fields[] = "$table.`$field`"; |
|
243 | + } |
|
244 | + $this->query_fields = implode( ',', $query_fields ); |
|
245 | + } else { |
|
246 | + $this->query_fields = "$table.*"; |
|
247 | + } |
|
248 | + |
|
249 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
250 | + $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
251 | + } |
|
252 | + |
|
253 | + } |
|
254 | + |
|
255 | + /** |
|
256 | + * Prepares the query where. |
|
257 | + * |
|
258 | + * @since 1.0.19 |
|
259 | + * |
|
260 | + * @param array $qv Query vars. |
|
261 | + * @param string $table Table name. |
|
262 | + */ |
|
263 | + protected function prepare_query_where( &$qv, $table ) { |
|
264 | + global $wpdb; |
|
265 | + $this->query_where = 'WHERE 1=1'; |
|
266 | + |
|
267 | + // Status. |
|
268 | + if ( 'all' !== $qv['status'] ) { |
|
269 | + $statuses = wpinv_clean( wpinv_parse_list( $qv['status'] ) ); |
|
270 | + $prepared_statuses = join( ',', array_fill( 0, count( $statuses ), '%s' ) ); |
|
271 | + $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $prepared_statuses )", $statuses ); |
|
272 | + } |
|
273 | + |
|
274 | + if ( ! empty( $qv['customer_in'] ) ) { |
|
275 | + $customer_in = implode( ',', wp_parse_id_list( $qv['customer_in'] ) ); |
|
276 | + $this->query_where .= " AND $table.`customer_id` IN ($customer_in)"; |
|
277 | + } elseif ( ! empty( $qv['customer_not_in'] ) ) { |
|
278 | + $customer_not_in = implode( ',', wp_parse_id_list( $qv['customer_not_in'] ) ); |
|
279 | + $this->query_where .= " AND $table.`customer_id` NOT IN ($customer_not_in)"; |
|
280 | + } |
|
281 | + |
|
282 | + if ( ! empty( $qv['product_in'] ) ) { |
|
283 | + $product_in = implode( ',', wp_parse_id_list( $qv['product_in'] ) ); |
|
284 | + $this->query_where .= " AND $table.`product_id` IN ($product_in)"; |
|
285 | + } elseif ( ! empty( $qv['product_not_in'] ) ) { |
|
286 | + $product_not_in = implode( ',', wp_parse_id_list( $qv['product_not_in'] ) ); |
|
287 | + $this->query_where .= " AND $table.`product_id` NOT IN ($product_not_in)"; |
|
288 | + } |
|
289 | + |
|
290 | + if ( ! empty( $qv['invoice_in'] ) ) { |
|
291 | + $invoice_in = implode( ',', wp_parse_id_list( $qv['invoice_in'] ) ); |
|
292 | + $this->query_where .= " AND $table.`parent_payment_id` IN ($invoice_in)"; |
|
293 | + } elseif ( ! empty( $qv['invoice_not_in'] ) ) { |
|
294 | + $invoice_not_in = implode( ',', wp_parse_id_list( $qv['invoice_not_in'] ) ); |
|
295 | + $this->query_where .= " AND $table.`parent_payment_id` NOT IN ($invoice_not_in)"; |
|
296 | + } |
|
297 | + |
|
298 | + if ( ! empty( $qv['include'] ) ) { |
|
299 | + $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
300 | + $this->query_where .= " AND $table.`id` IN ($include)"; |
|
301 | + } elseif ( ! empty( $qv['exclude'] ) ) { |
|
302 | + $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
303 | + $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
304 | + } |
|
305 | + |
|
306 | + // Date queries are allowed for the subscription creation date. |
|
307 | + if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
308 | + $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.created" ); |
|
309 | + $this->query_where .= $date_created_query->get_sql(); |
|
310 | + } |
|
311 | + |
|
312 | + // Date queries are also allowed for the subscription expiration date. |
|
313 | + if ( ! empty( $qv['date_expires_query'] ) && is_array( $qv['date_expires_query'] ) ) { |
|
314 | + $date_expires_query = new WP_Date_Query( $qv['date_expires_query'], "$table.expiration" ); |
|
315 | + $this->query_where .= $date_expires_query->get_sql(); |
|
316 | + } |
|
317 | + |
|
318 | + } |
|
319 | + |
|
320 | + /** |
|
321 | + * Prepares the query order. |
|
322 | + * |
|
323 | + * @since 1.0.19 |
|
324 | + * |
|
325 | + * @param array $qv Query vars. |
|
326 | + * @param string $table Table name. |
|
327 | + */ |
|
328 | + protected function prepare_query_order( &$qv, $table ) { |
|
329 | + |
|
330 | + // sorting. |
|
331 | + $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
332 | + $order = $this->parse_order( $qv['order'] ); |
|
333 | + |
|
334 | + // Default order is by 'id' (latest subscriptions). |
|
335 | + if ( empty( $qv['orderby'] ) ) { |
|
336 | + $qv['orderby'] = array( 'id' ); |
|
337 | + } |
|
338 | + |
|
339 | + // 'orderby' values may be an array, comma- or space-separated list. |
|
340 | + $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
341 | + |
|
342 | + $orderby_array = array(); |
|
343 | + foreach ( $ordersby as $_key => $_value ) { |
|
344 | + |
|
345 | + if ( is_int( $_key ) ) { |
|
346 | + // Integer key means this is a flat array of 'orderby' fields. |
|
347 | + $_orderby = $_value; |
|
348 | + $_order = $order; |
|
349 | + } else { |
|
350 | + // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
351 | + $_orderby = $_key; |
|
352 | + $_order = $_value; |
|
353 | + } |
|
354 | + |
|
355 | + $parsed = $this->parse_orderby( $_orderby, $table ); |
|
356 | + |
|
357 | + if ( $parsed ) { |
|
358 | + $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
359 | + } |
|
360 | 360 | } |
361 | 361 | |
362 | - // If no valid clauses were found, order by id. |
|
363 | - if ( empty( $orderby_array ) ) { |
|
364 | - $orderby_array[] = "id $order"; |
|
365 | - } |
|
366 | - |
|
367 | - $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
368 | - |
|
369 | - } |
|
370 | - |
|
371 | - /** |
|
372 | - * Execute the query, with the current variables. |
|
373 | - * |
|
374 | - * @since 1.0.19 |
|
375 | - * |
|
376 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
377 | - */ |
|
378 | - public function query() { |
|
379 | - global $wpdb; |
|
380 | - |
|
381 | - $qv =& $this->query_vars; |
|
382 | - |
|
383 | - // Return a non-null value to bypass the default GetPaid subscriptions query and remember to set the |
|
384 | - // total_subscriptions property. |
|
385 | - $this->results = apply_filters_ref_array( 'getpaid_subscriptions_pre_query', array( null, &$this ) ); |
|
386 | - |
|
387 | - if ( null === $this->results ) { |
|
388 | - $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
389 | - |
|
390 | - if ( ( is_array( $qv['fields'] ) && 1 != count( $qv['fields'] ) ) || 'all' == $qv['fields'] ) { |
|
391 | - $this->results = $wpdb->get_results( $this->request ); |
|
392 | - } else { |
|
393 | - $this->results = $wpdb->get_col( $this->request ); |
|
394 | - } |
|
395 | - |
|
396 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
397 | - $found_subscriptions_query = apply_filters( 'getpaid_found_subscriptions_query', 'SELECT FOUND_ROWS()', $this ); |
|
398 | - $this->total_subscriptions = (int) $wpdb->get_var( $found_subscriptions_query ); |
|
399 | - } |
|
400 | - } |
|
401 | - |
|
402 | - if ( 'all' == $qv['fields'] ) { |
|
403 | - foreach ( $this->results as $key => $subscription ) { |
|
404 | - $this->set_cache( $subscription->id, $subscription, 'getpaid_subscriptions' ); |
|
405 | - $this->set_cache( $subscription->profile_id, $subscription->id, 'getpaid_subscription_profile_ids_to_subscription_ids' ); |
|
406 | - $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
407 | - $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
408 | - $this->results[ $key ] = new WPInv_Subscription( $subscription ); |
|
409 | - } |
|
410 | - } |
|
411 | - |
|
412 | - } |
|
413 | - |
|
414 | - /** |
|
415 | - * Set cache |
|
416 | - * |
|
417 | - * @param string $id |
|
418 | - * @param mixed $data |
|
419 | - * @param string $group |
|
420 | - * @param integer $expire |
|
421 | - * @return boolean |
|
422 | - */ |
|
423 | - public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
424 | - |
|
425 | - if ( empty( $key ) ) { |
|
426 | - return false; |
|
427 | - } |
|
428 | - |
|
429 | - wp_cache_set( $key, $data, $group, $expire ); |
|
430 | - } |
|
431 | - |
|
432 | - /** |
|
433 | - * Retrieve query variable. |
|
434 | - * |
|
435 | - * @since 1.0.19 |
|
436 | - * |
|
437 | - * @param string $query_var Query variable key. |
|
438 | - * @return mixed |
|
439 | - */ |
|
440 | - public function get( $query_var ) { |
|
441 | - if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
442 | - return $this->query_vars[ $query_var ]; |
|
443 | - } |
|
444 | - |
|
445 | - return null; |
|
446 | - } |
|
447 | - |
|
448 | - /** |
|
449 | - * Set query variable. |
|
450 | - * |
|
451 | - * @since 1.0.19 |
|
452 | - * |
|
453 | - * @param string $query_var Query variable key. |
|
454 | - * @param mixed $value Query variable value. |
|
455 | - */ |
|
456 | - public function set( $query_var, $value ) { |
|
457 | - $this->query_vars[ $query_var ] = $value; |
|
458 | - } |
|
459 | - |
|
460 | - /** |
|
461 | - * Return the list of subscriptions. |
|
462 | - * |
|
463 | - * @since 1.0.19 |
|
464 | - * |
|
465 | - * @return WPInv_Subscription[]|array Found subscriptions. |
|
466 | - */ |
|
467 | - public function get_results() { |
|
468 | - return $this->results; |
|
469 | - } |
|
470 | - |
|
471 | - /** |
|
472 | - * Return the total number of subscriptions for the current query. |
|
473 | - * |
|
474 | - * @since 1.0.19 |
|
475 | - * |
|
476 | - * @return int Number of total subscriptions. |
|
477 | - */ |
|
478 | - public function get_total() { |
|
479 | - return $this->total_subscriptions; |
|
480 | - } |
|
481 | - |
|
482 | - /** |
|
483 | - * Parse and sanitize 'orderby' keys passed to the subscriptions query. |
|
484 | - * |
|
485 | - * @since 1.0.19 |
|
486 | - * |
|
487 | - * @param string $orderby Alias for the field to order by. |
|
488 | - * @param string $table The current table. |
|
489 | - * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
490 | - */ |
|
491 | - protected function parse_orderby( $orderby, $table ) { |
|
492 | - |
|
493 | - $_orderby = ''; |
|
494 | - if ( in_array( $orderby, array( 'customer_id', 'frequency', 'period', 'initial_amount', 'recurring_amount', 'bill_times', 'transaction_id', 'parent_payment_id', 'product_id', 'created', 'expiration', 'trial_period', 'status', 'profile_id' ) ) ) { |
|
495 | - $_orderby = "$table.`$orderby`"; |
|
496 | - } elseif ( 'id' === strtolower( $orderby ) ) { |
|
497 | - $_orderby = "$table.id"; |
|
498 | - } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
499 | - $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
500 | - $include_sql = implode( ',', $include ); |
|
501 | - $_orderby = "FIELD( $table.id, $include_sql )"; |
|
502 | - } |
|
503 | - |
|
504 | - return $_orderby; |
|
505 | - } |
|
506 | - |
|
507 | - /** |
|
508 | - * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
509 | - * |
|
510 | - * @since 1.0.19 |
|
511 | - * |
|
512 | - * @param string $order The 'order' query variable. |
|
513 | - * @return string The sanitized 'order' query variable. |
|
514 | - */ |
|
515 | - protected function parse_order( $order ) { |
|
516 | - if ( ! is_string( $order ) || empty( $order ) ) { |
|
517 | - return 'DESC'; |
|
518 | - } |
|
519 | - |
|
520 | - if ( 'ASC' === strtoupper( $order ) ) { |
|
521 | - return 'ASC'; |
|
522 | - } else { |
|
523 | - return 'DESC'; |
|
524 | - } |
|
525 | - } |
|
362 | + // If no valid clauses were found, order by id. |
|
363 | + if ( empty( $orderby_array ) ) { |
|
364 | + $orderby_array[] = "id $order"; |
|
365 | + } |
|
366 | + |
|
367 | + $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
368 | + |
|
369 | + } |
|
370 | + |
|
371 | + /** |
|
372 | + * Execute the query, with the current variables. |
|
373 | + * |
|
374 | + * @since 1.0.19 |
|
375 | + * |
|
376 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
377 | + */ |
|
378 | + public function query() { |
|
379 | + global $wpdb; |
|
380 | + |
|
381 | + $qv =& $this->query_vars; |
|
382 | + |
|
383 | + // Return a non-null value to bypass the default GetPaid subscriptions query and remember to set the |
|
384 | + // total_subscriptions property. |
|
385 | + $this->results = apply_filters_ref_array( 'getpaid_subscriptions_pre_query', array( null, &$this ) ); |
|
386 | + |
|
387 | + if ( null === $this->results ) { |
|
388 | + $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
389 | + |
|
390 | + if ( ( is_array( $qv['fields'] ) && 1 != count( $qv['fields'] ) ) || 'all' == $qv['fields'] ) { |
|
391 | + $this->results = $wpdb->get_results( $this->request ); |
|
392 | + } else { |
|
393 | + $this->results = $wpdb->get_col( $this->request ); |
|
394 | + } |
|
395 | + |
|
396 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
397 | + $found_subscriptions_query = apply_filters( 'getpaid_found_subscriptions_query', 'SELECT FOUND_ROWS()', $this ); |
|
398 | + $this->total_subscriptions = (int) $wpdb->get_var( $found_subscriptions_query ); |
|
399 | + } |
|
400 | + } |
|
401 | + |
|
402 | + if ( 'all' == $qv['fields'] ) { |
|
403 | + foreach ( $this->results as $key => $subscription ) { |
|
404 | + $this->set_cache( $subscription->id, $subscription, 'getpaid_subscriptions' ); |
|
405 | + $this->set_cache( $subscription->profile_id, $subscription->id, 'getpaid_subscription_profile_ids_to_subscription_ids' ); |
|
406 | + $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
407 | + $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
408 | + $this->results[ $key ] = new WPInv_Subscription( $subscription ); |
|
409 | + } |
|
410 | + } |
|
411 | + |
|
412 | + } |
|
413 | + |
|
414 | + /** |
|
415 | + * Set cache |
|
416 | + * |
|
417 | + * @param string $id |
|
418 | + * @param mixed $data |
|
419 | + * @param string $group |
|
420 | + * @param integer $expire |
|
421 | + * @return boolean |
|
422 | + */ |
|
423 | + public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
424 | + |
|
425 | + if ( empty( $key ) ) { |
|
426 | + return false; |
|
427 | + } |
|
428 | + |
|
429 | + wp_cache_set( $key, $data, $group, $expire ); |
|
430 | + } |
|
431 | + |
|
432 | + /** |
|
433 | + * Retrieve query variable. |
|
434 | + * |
|
435 | + * @since 1.0.19 |
|
436 | + * |
|
437 | + * @param string $query_var Query variable key. |
|
438 | + * @return mixed |
|
439 | + */ |
|
440 | + public function get( $query_var ) { |
|
441 | + if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
442 | + return $this->query_vars[ $query_var ]; |
|
443 | + } |
|
444 | + |
|
445 | + return null; |
|
446 | + } |
|
447 | + |
|
448 | + /** |
|
449 | + * Set query variable. |
|
450 | + * |
|
451 | + * @since 1.0.19 |
|
452 | + * |
|
453 | + * @param string $query_var Query variable key. |
|
454 | + * @param mixed $value Query variable value. |
|
455 | + */ |
|
456 | + public function set( $query_var, $value ) { |
|
457 | + $this->query_vars[ $query_var ] = $value; |
|
458 | + } |
|
459 | + |
|
460 | + /** |
|
461 | + * Return the list of subscriptions. |
|
462 | + * |
|
463 | + * @since 1.0.19 |
|
464 | + * |
|
465 | + * @return WPInv_Subscription[]|array Found subscriptions. |
|
466 | + */ |
|
467 | + public function get_results() { |
|
468 | + return $this->results; |
|
469 | + } |
|
470 | + |
|
471 | + /** |
|
472 | + * Return the total number of subscriptions for the current query. |
|
473 | + * |
|
474 | + * @since 1.0.19 |
|
475 | + * |
|
476 | + * @return int Number of total subscriptions. |
|
477 | + */ |
|
478 | + public function get_total() { |
|
479 | + return $this->total_subscriptions; |
|
480 | + } |
|
481 | + |
|
482 | + /** |
|
483 | + * Parse and sanitize 'orderby' keys passed to the subscriptions query. |
|
484 | + * |
|
485 | + * @since 1.0.19 |
|
486 | + * |
|
487 | + * @param string $orderby Alias for the field to order by. |
|
488 | + * @param string $table The current table. |
|
489 | + * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
490 | + */ |
|
491 | + protected function parse_orderby( $orderby, $table ) { |
|
492 | + |
|
493 | + $_orderby = ''; |
|
494 | + if ( in_array( $orderby, array( 'customer_id', 'frequency', 'period', 'initial_amount', 'recurring_amount', 'bill_times', 'transaction_id', 'parent_payment_id', 'product_id', 'created', 'expiration', 'trial_period', 'status', 'profile_id' ) ) ) { |
|
495 | + $_orderby = "$table.`$orderby`"; |
|
496 | + } elseif ( 'id' === strtolower( $orderby ) ) { |
|
497 | + $_orderby = "$table.id"; |
|
498 | + } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
499 | + $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
500 | + $include_sql = implode( ',', $include ); |
|
501 | + $_orderby = "FIELD( $table.id, $include_sql )"; |
|
502 | + } |
|
503 | + |
|
504 | + return $_orderby; |
|
505 | + } |
|
506 | + |
|
507 | + /** |
|
508 | + * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
509 | + * |
|
510 | + * @since 1.0.19 |
|
511 | + * |
|
512 | + * @param string $order The 'order' query variable. |
|
513 | + * @return string The sanitized 'order' query variable. |
|
514 | + */ |
|
515 | + protected function parse_order( $order ) { |
|
516 | + if ( ! is_string( $order ) || empty( $order ) ) { |
|
517 | + return 'DESC'; |
|
518 | + } |
|
519 | + |
|
520 | + if ( 'ASC' === strtoupper( $order ) ) { |
|
521 | + return 'ASC'; |
|
522 | + } else { |
|
523 | + return 'DESC'; |
|
524 | + } |
|
525 | + } |
|
526 | 526 | |
527 | 527 | } |
@@ -136,13 +136,13 @@ discard block |
||
136 | 136 | */ |
137 | 137 | function wpinv_get_invoice_statuses( $draft = false, $trashed = false, $invoice = false ) { |
138 | 138 | |
139 | - $invoice_statuses = array( |
|
140 | - 'wpi-pending' => _x( 'Pending payment', 'Invoice status', 'invoicing' ), |
|
139 | + $invoice_statuses = array( |
|
140 | + 'wpi-pending' => _x( 'Pending payment', 'Invoice status', 'invoicing' ), |
|
141 | 141 | 'publish' => _x( 'Paid', 'Invoice status', 'invoicing' ), |
142 | 142 | 'wpi-processing' => _x( 'Processing', 'Invoice status', 'invoicing' ), |
143 | - 'wpi-onhold' => _x( 'On hold', 'Invoice status', 'invoicing' ), |
|
144 | - 'wpi-cancelled' => _x( 'Cancelled', 'Invoice status', 'invoicing' ), |
|
145 | - 'wpi-refunded' => _x( 'Refunded', 'Invoice status', 'invoicing' ), |
|
143 | + 'wpi-onhold' => _x( 'On hold', 'Invoice status', 'invoicing' ), |
|
144 | + 'wpi-cancelled' => _x( 'Cancelled', 'Invoice status', 'invoicing' ), |
|
145 | + 'wpi-refunded' => _x( 'Refunded', 'Invoice status', 'invoicing' ), |
|
146 | 146 | 'wpi-failed' => _x( 'Failed', 'Invoice status', 'invoicing' ), |
147 | 147 | 'wpi-renewal' => _x( 'Renewal Payment', 'Invoice status', 'invoicing' ), |
148 | 148 | ); |
@@ -159,7 +159,7 @@ discard block |
||
159 | 159 | $invoice = $invoice->get_post_type(); |
160 | 160 | } |
161 | 161 | |
162 | - return apply_filters( 'wpinv_statuses', $invoice_statuses, $invoice ); |
|
162 | + return apply_filters( 'wpinv_statuses', $invoice_statuses, $invoice ); |
|
163 | 163 | } |
164 | 164 | |
165 | 165 | /** |
@@ -277,25 +277,25 @@ discard block |
||
277 | 277 | * @return string |
278 | 278 | */ |
279 | 279 | function getpaid_get_price_format() { |
280 | - $currency_pos = wpinv_currency_position(); |
|
281 | - $format = '%1$s%2$s'; |
|
282 | - |
|
283 | - switch ( $currency_pos ) { |
|
284 | - case 'left': |
|
285 | - $format = '%1$s%2$s'; |
|
286 | - break; |
|
287 | - case 'right': |
|
288 | - $format = '%2$s%1$s'; |
|
289 | - break; |
|
290 | - case 'left_space': |
|
291 | - $format = '%1$s %2$s'; |
|
292 | - break; |
|
293 | - case 'right_space': |
|
294 | - $format = '%2$s %1$s'; |
|
295 | - break; |
|
296 | - } |
|
297 | - |
|
298 | - return apply_filters( 'getpaid_price_format', $format, $currency_pos ); |
|
280 | + $currency_pos = wpinv_currency_position(); |
|
281 | + $format = '%1$s%2$s'; |
|
282 | + |
|
283 | + switch ( $currency_pos ) { |
|
284 | + case 'left': |
|
285 | + $format = '%1$s%2$s'; |
|
286 | + break; |
|
287 | + case 'right': |
|
288 | + $format = '%2$s%1$s'; |
|
289 | + break; |
|
290 | + case 'left_space': |
|
291 | + $format = '%1$s %2$s'; |
|
292 | + break; |
|
293 | + case 'right_space': |
|
294 | + $format = '%2$s %1$s'; |
|
295 | + break; |
|
296 | + } |
|
297 | + |
|
298 | + return apply_filters( 'getpaid_price_format', $format, $currency_pos ); |
|
299 | 299 | } |
300 | 300 | |
301 | 301 | /** |
@@ -401,13 +401,13 @@ discard block |
||
401 | 401 | * @param mixed $value Value. |
402 | 402 | */ |
403 | 403 | function getpaid_maybe_define_constant( $name, $value ) { |
404 | - if ( ! defined( $name ) ) { |
|
405 | - define( $name, $value ); |
|
406 | - } |
|
404 | + if ( ! defined( $name ) ) { |
|
405 | + define( $name, $value ); |
|
406 | + } |
|
407 | 407 | } |
408 | 408 | |
409 | 409 | function wpinv_get_php_arg_separator_output() { |
410 | - return ini_get( 'arg_separator.output' ); |
|
410 | + return ini_get( 'arg_separator.output' ); |
|
411 | 411 | } |
412 | 412 | |
413 | 413 | function wpinv_rgb_from_hex( $color ) { |
@@ -718,16 +718,16 @@ discard block |
||
718 | 718 | return wp_kses( |
719 | 719 | html_entity_decode( $var ), |
720 | 720 | array( |
721 | - 'br' => array(), |
|
722 | - 'em' => array(), |
|
723 | - 'strong' => array(), |
|
724 | - 'b' => array(), |
|
725 | - 'small' => array(), |
|
726 | - 'span' => array(), |
|
727 | - 'ul' => array(), |
|
728 | - 'li' => array(), |
|
729 | - 'ol' => array(), |
|
730 | - 'p' => array(), |
|
721 | + 'br' => array(), |
|
722 | + 'em' => array(), |
|
723 | + 'strong' => array(), |
|
724 | + 'b' => array(), |
|
725 | + 'small' => array(), |
|
726 | + 'span' => array(), |
|
727 | + 'ul' => array(), |
|
728 | + 'li' => array(), |
|
729 | + 'ol' => array(), |
|
730 | + 'p' => array(), |
|
731 | 731 | ) |
732 | 732 | ); |
733 | 733 | } |
@@ -778,11 +778,11 @@ discard block |
||
778 | 778 | $list = array(); |
779 | 779 | } |
780 | 780 | |
781 | - if ( ! is_array( $list ) ) { |
|
782 | - return preg_split( '/[\s,]+/', $list, -1, PREG_SPLIT_NO_EMPTY ); |
|
783 | - } |
|
781 | + if ( ! is_array( $list ) ) { |
|
782 | + return preg_split( '/[\s,]+/', $list, -1, PREG_SPLIT_NO_EMPTY ); |
|
783 | + } |
|
784 | 784 | |
785 | - return $list; |
|
785 | + return $list; |
|
786 | 786 | } |
787 | 787 | |
788 | 788 | /** |
@@ -823,17 +823,17 @@ discard block |
||
823 | 823 | */ |
824 | 824 | function wpinv_clean( $var ) { |
825 | 825 | |
826 | - if ( is_array( $var ) ) { |
|
827 | - return array_map( 'wpinv_clean', $var ); |
|
826 | + if ( is_array( $var ) ) { |
|
827 | + return array_map( 'wpinv_clean', $var ); |
|
828 | 828 | } |
829 | 829 | |
830 | 830 | if ( is_object( $var ) ) { |
831 | - $object_vars = get_object_vars( $var ); |
|
832 | - foreach ( $object_vars as $property_name => $property_value ) { |
|
833 | - $var->$property_name = wpinv_clean( $property_value ); |
|
831 | + $object_vars = get_object_vars( $var ); |
|
832 | + foreach ( $object_vars as $property_name => $property_value ) { |
|
833 | + $var->$property_name = wpinv_clean( $property_value ); |
|
834 | 834 | } |
835 | 835 | return $var; |
836 | - } |
|
836 | + } |
|
837 | 837 | |
838 | 838 | return is_string( $var ) ? sanitize_text_field( stripslashes( $var ) ) : $var; |
839 | 839 | } |
@@ -846,7 +846,7 @@ discard block |
||
846 | 846 | */ |
847 | 847 | function getpaid_convert_price_string_to_options( $str ) { |
848 | 848 | |
849 | - $raw_options = array_map( 'trim', explode( ',', $str ) ); |
|
849 | + $raw_options = array_map( 'trim', explode( ',', $str ) ); |
|
850 | 850 | $options = array(); |
851 | 851 | |
852 | 852 | foreach ( $raw_options as $option ) { |
@@ -935,7 +935,7 @@ discard block |
||
935 | 935 | * @return string |
936 | 936 | */ |
937 | 937 | function getpaid_date_format() { |
938 | - return apply_filters( 'getpaid_date_format', get_option( 'date_format' ) ); |
|
938 | + return apply_filters( 'getpaid_date_format', get_option( 'date_format' ) ); |
|
939 | 939 | } |
940 | 940 | |
941 | 941 | /** |
@@ -944,7 +944,7 @@ discard block |
||
944 | 944 | * @return string |
945 | 945 | */ |
946 | 946 | function getpaid_time_format() { |
947 | - return apply_filters( 'getpaid_time_format', get_option( 'time_format' ) ); |
|
947 | + return apply_filters( 'getpaid_time_format', get_option( 'time_format' ) ); |
|
948 | 948 | } |
949 | 949 | |
950 | 950 | /** |
@@ -957,15 +957,15 @@ discard block |
||
957 | 957 | function getpaid_limit_length( $string, $limit ) { |
958 | 958 | $str_limit = $limit - 3; |
959 | 959 | |
960 | - if ( function_exists( 'mb_strimwidth' ) ) { |
|
961 | - if ( mb_strlen( $string ) > $limit ) { |
|
962 | - $string = mb_strimwidth( $string, 0, $str_limit ) . '...'; |
|
963 | - } |
|
964 | - } else { |
|
965 | - if ( strlen( $string ) > $limit ) { |
|
966 | - $string = substr( $string, 0, $str_limit ) . '...'; |
|
967 | - } |
|
968 | - } |
|
960 | + if ( function_exists( 'mb_strimwidth' ) ) { |
|
961 | + if ( mb_strlen( $string ) > $limit ) { |
|
962 | + $string = mb_strimwidth( $string, 0, $str_limit ) . '...'; |
|
963 | + } |
|
964 | + } else { |
|
965 | + if ( strlen( $string ) > $limit ) { |
|
966 | + $string = substr( $string, 0, $str_limit ) . '...'; |
|
967 | + } |
|
968 | + } |
|
969 | 969 | return $string; |
970 | 970 | |
971 | 971 | } |
@@ -1095,12 +1095,12 @@ discard block |
||
1095 | 1095 | $types = get_allowed_mime_types(); |
1096 | 1096 | |
1097 | 1097 | if ( isset( $types['htm|html'] ) ) { |
1098 | - unset( $types['htm|html'] ); |
|
1099 | - } |
|
1098 | + unset( $types['htm|html'] ); |
|
1099 | + } |
|
1100 | 1100 | |
1101 | 1101 | if ( isset( $types['js'] ) ) { |
1102 | - unset( $types['js'] ); |
|
1103 | - } |
|
1102 | + unset( $types['js'] ); |
|
1103 | + } |
|
1104 | 1104 | |
1105 | 1105 | return $types; |
1106 | 1106 |
@@ -14,70 +14,70 @@ discard block |
||
14 | 14 | class WPInv_Ajax { |
15 | 15 | |
16 | 16 | /** |
17 | - * Hook in ajax handlers. |
|
18 | - */ |
|
19 | - public static function init() { |
|
20 | - add_action( 'init', array( __CLASS__, 'define_ajax' ), 0 ); |
|
21 | - add_action( 'template_redirect', array( __CLASS__, 'do_wpinv_ajax' ), 0 ); |
|
22 | - self::add_ajax_events(); |
|
17 | + * Hook in ajax handlers. |
|
18 | + */ |
|
19 | + public static function init() { |
|
20 | + add_action( 'init', array( __CLASS__, 'define_ajax' ), 0 ); |
|
21 | + add_action( 'template_redirect', array( __CLASS__, 'do_wpinv_ajax' ), 0 ); |
|
22 | + self::add_ajax_events(); |
|
23 | 23 | } |
24 | 24 | |
25 | 25 | /** |
26 | - * Set GetPaid AJAX constant and headers. |
|
27 | - */ |
|
28 | - public static function define_ajax() { |
|
29 | - |
|
30 | - if ( ! empty( $_GET['wpinv-ajax'] ) ) { |
|
31 | - getpaid_maybe_define_constant( 'DOING_AJAX', true ); |
|
32 | - getpaid_maybe_define_constant( 'WPInv_DOING_AJAX', true ); |
|
33 | - if ( ! WP_DEBUG || ( WP_DEBUG && ! WP_DEBUG_DISPLAY ) ) { |
|
34 | - /** @scrutinizer ignore-unhandled */ @ini_set( 'display_errors', 0 ); |
|
35 | - } |
|
36 | - $GLOBALS['wpdb']->hide_errors(); |
|
37 | - } |
|
26 | + * Set GetPaid AJAX constant and headers. |
|
27 | + */ |
|
28 | + public static function define_ajax() { |
|
29 | + |
|
30 | + if ( ! empty( $_GET['wpinv-ajax'] ) ) { |
|
31 | + getpaid_maybe_define_constant( 'DOING_AJAX', true ); |
|
32 | + getpaid_maybe_define_constant( 'WPInv_DOING_AJAX', true ); |
|
33 | + if ( ! WP_DEBUG || ( WP_DEBUG && ! WP_DEBUG_DISPLAY ) ) { |
|
34 | + /** @scrutinizer ignore-unhandled */ @ini_set( 'display_errors', 0 ); |
|
35 | + } |
|
36 | + $GLOBALS['wpdb']->hide_errors(); |
|
37 | + } |
|
38 | 38 | |
39 | 39 | } |
40 | 40 | |
41 | 41 | /** |
42 | - * Send headers for GetPaid Ajax Requests. |
|
43 | - * |
|
44 | - * @since 1.0.18 |
|
45 | - */ |
|
46 | - private static function wpinv_ajax_headers() { |
|
47 | - if ( ! headers_sent() ) { |
|
48 | - send_origin_headers(); |
|
49 | - send_nosniff_header(); |
|
50 | - nocache_headers(); |
|
51 | - header( 'Content-Type: text/html; charset=' . get_option( 'blog_charset' ) ); |
|
52 | - header( 'X-Robots-Tag: noindex' ); |
|
53 | - status_header( 200 ); |
|
54 | - } |
|
42 | + * Send headers for GetPaid Ajax Requests. |
|
43 | + * |
|
44 | + * @since 1.0.18 |
|
45 | + */ |
|
46 | + private static function wpinv_ajax_headers() { |
|
47 | + if ( ! headers_sent() ) { |
|
48 | + send_origin_headers(); |
|
49 | + send_nosniff_header(); |
|
50 | + nocache_headers(); |
|
51 | + header( 'Content-Type: text/html; charset=' . get_option( 'blog_charset' ) ); |
|
52 | + header( 'X-Robots-Tag: noindex' ); |
|
53 | + status_header( 200 ); |
|
54 | + } |
|
55 | 55 | } |
56 | 56 | |
57 | 57 | /** |
58 | - * Check for GetPaid Ajax request and fire action. |
|
59 | - */ |
|
60 | - public static function do_wpinv_ajax() { |
|
61 | - global $wp_query; |
|
58 | + * Check for GetPaid Ajax request and fire action. |
|
59 | + */ |
|
60 | + public static function do_wpinv_ajax() { |
|
61 | + global $wp_query; |
|
62 | 62 | |
63 | - if ( ! empty( $_GET['wpinv-ajax'] ) ) { |
|
64 | - $wp_query->set( 'wpinv-ajax', sanitize_text_field( wp_unslash( $_GET['wpinv-ajax'] ) ) ); |
|
65 | - } |
|
63 | + if ( ! empty( $_GET['wpinv-ajax'] ) ) { |
|
64 | + $wp_query->set( 'wpinv-ajax', sanitize_text_field( wp_unslash( $_GET['wpinv-ajax'] ) ) ); |
|
65 | + } |
|
66 | 66 | |
67 | - $action = $wp_query->get( 'wpinv-ajax' ); |
|
67 | + $action = $wp_query->get( 'wpinv-ajax' ); |
|
68 | 68 | |
69 | - if ( $action ) { |
|
70 | - self::wpinv_ajax_headers(); |
|
71 | - $action = sanitize_text_field( $action ); |
|
72 | - do_action( 'wpinv_ajax_' . $action ); |
|
73 | - wp_die(); |
|
74 | - } |
|
69 | + if ( $action ) { |
|
70 | + self::wpinv_ajax_headers(); |
|
71 | + $action = sanitize_text_field( $action ); |
|
72 | + do_action( 'wpinv_ajax_' . $action ); |
|
73 | + wp_die(); |
|
74 | + } |
|
75 | 75 | |
76 | 76 | } |
77 | 77 | |
78 | 78 | /** |
79 | - * Hook in ajax methods. |
|
80 | - */ |
|
79 | + * Hook in ajax methods. |
|
80 | + */ |
|
81 | 81 | public static function add_ajax_events() { |
82 | 82 | |
83 | 83 | // array( 'event' => is_frontend ) |
@@ -258,11 +258,11 @@ discard block |
||
258 | 258 | global $getpaid_force_checkbox; |
259 | 259 | |
260 | 260 | // Is the request set up correctly? |
261 | - if ( empty( $_GET['form'] ) && empty( $_GET['item'] ) && empty( $_GET['invoice'] ) ) { |
|
262 | - aui()->alert( |
|
263 | - array( |
|
264 | - 'type' => 'warning', |
|
265 | - 'content' => __( 'No payment form or item provided', 'invoicing' ), |
|
261 | + if ( empty( $_GET['form'] ) && empty( $_GET['item'] ) && empty( $_GET['invoice'] ) ) { |
|
262 | + aui()->alert( |
|
263 | + array( |
|
264 | + 'type' => 'warning', |
|
265 | + 'content' => __( 'No payment form or item provided', 'invoicing' ), |
|
266 | 266 | ), |
267 | 267 | true |
268 | 268 | ); |
@@ -270,7 +270,7 @@ discard block |
||
270 | 270 | } |
271 | 271 | |
272 | 272 | // Payment form or button? |
273 | - if ( ! empty( $_GET['form'] ) ) { |
|
273 | + if ( ! empty( $_GET['form'] ) ) { |
|
274 | 274 | $form = sanitize_text_field( urldecode( $_GET['form'] ) ); |
275 | 275 | |
276 | 276 | if ( false !== strpos( $form, '|' ) ) { |
@@ -323,10 +323,10 @@ discard block |
||
323 | 323 | getpaid_display_payment_form( $form ); |
324 | 324 | } |
325 | 325 | } elseif ( ! empty( $_GET['invoice'] ) ) { |
326 | - getpaid_display_invoice_payment_form( (int) urldecode( $_GET['invoice'] ) ); |
|
326 | + getpaid_display_invoice_payment_form( (int) urldecode( $_GET['invoice'] ) ); |
|
327 | 327 | } else { |
328 | - $items = getpaid_convert_items_to_array( sanitize_text_field( urldecode( $_GET['item'] ) ) ); |
|
329 | - getpaid_display_item_payment_form( $items ); |
|
328 | + $items = getpaid_convert_items_to_array( sanitize_text_field( urldecode( $_GET['item'] ) ) ); |
|
329 | + getpaid_display_item_payment_form( $items ); |
|
330 | 330 | } |
331 | 331 | |
332 | 332 | exit; |
@@ -643,7 +643,7 @@ discard block |
||
643 | 643 | if ( is_wp_error( $error ) ) { |
644 | 644 | $alert = $error->get_error_message(); |
645 | 645 | wp_send_json_success( compact( 'alert' ) ); |
646 | - } |
|
646 | + } |
|
647 | 647 | |
648 | 648 | // Update totals. |
649 | 649 | $invoice->recalculate_total(); |
@@ -1072,12 +1072,12 @@ discard block |
||
1072 | 1072 | } |
1073 | 1073 | |
1074 | 1074 | /** |
1075 | - * Handles file uploads. |
|
1076 | - * |
|
1077 | - * @since 1.0.0 |
|
1078 | - * @return void |
|
1079 | - */ |
|
1080 | - public static function file_upload() { |
|
1075 | + * Handles file uploads. |
|
1076 | + * |
|
1077 | + * @since 1.0.0 |
|
1078 | + * @return void |
|
1079 | + */ |
|
1080 | + public static function file_upload() { |
|
1081 | 1081 | |
1082 | 1082 | // Check nonce. |
1083 | 1083 | check_ajax_referer( 'getpaid_form_nonce' ); |
@@ -1138,7 +1138,7 @@ discard block |
||
1138 | 1138 | |
1139 | 1139 | wp_send_json_success( $response ); |
1140 | 1140 | |
1141 | - } |
|
1141 | + } |
|
1142 | 1142 | |
1143 | 1143 | } |
1144 | 1144 |
@@ -13,58 +13,58 @@ discard block |
||
13 | 13 | class GetPaid_Authorize_Net_Gateway extends GetPaid_Authorize_Net_Legacy_Gateway { |
14 | 14 | |
15 | 15 | /** |
16 | - * Payment method id. |
|
17 | - * |
|
18 | - * @var string |
|
19 | - */ |
|
16 | + * Payment method id. |
|
17 | + * |
|
18 | + * @var string |
|
19 | + */ |
|
20 | 20 | public $id = 'authorizenet'; |
21 | 21 | |
22 | 22 | /** |
23 | - * An array of features that this gateway supports. |
|
24 | - * |
|
25 | - * @var array |
|
26 | - */ |
|
23 | + * An array of features that this gateway supports. |
|
24 | + * |
|
25 | + * @var array |
|
26 | + */ |
|
27 | 27 | protected $supports = array( 'subscription', 'sandbox', 'tokens', 'addons', 'single_subscription_group', 'multiple_subscription_groups' ); |
28 | 28 | |
29 | 29 | /** |
30 | - * Payment method order. |
|
31 | - * |
|
32 | - * @var int |
|
33 | - */ |
|
30 | + * Payment method order. |
|
31 | + * |
|
32 | + * @var int |
|
33 | + */ |
|
34 | 34 | public $order = 4; |
35 | 35 | |
36 | 36 | /** |
37 | - * Endpoint for requests from Authorize.net. |
|
38 | - * |
|
39 | - * @var string |
|
40 | - */ |
|
41 | - protected $notify_url; |
|
42 | - |
|
43 | - /** |
|
44 | - * Endpoint for requests to Authorize.net. |
|
45 | - * |
|
46 | - * @var string |
|
47 | - */ |
|
37 | + * Endpoint for requests from Authorize.net. |
|
38 | + * |
|
39 | + * @var string |
|
40 | + */ |
|
41 | + protected $notify_url; |
|
42 | + |
|
43 | + /** |
|
44 | + * Endpoint for requests to Authorize.net. |
|
45 | + * |
|
46 | + * @var string |
|
47 | + */ |
|
48 | 48 | protected $endpoint; |
49 | 49 | |
50 | 50 | /** |
51 | - * Currencies this gateway is allowed for. |
|
52 | - * |
|
53 | - * @var array |
|
54 | - */ |
|
55 | - public $currencies = array( 'USD', 'CAD', 'GBP', 'DKK', 'NOK', 'PLN', 'SEK', 'AUD', 'EUR', 'NZD' ); |
|
51 | + * Currencies this gateway is allowed for. |
|
52 | + * |
|
53 | + * @var array |
|
54 | + */ |
|
55 | + public $currencies = array( 'USD', 'CAD', 'GBP', 'DKK', 'NOK', 'PLN', 'SEK', 'AUD', 'EUR', 'NZD' ); |
|
56 | 56 | |
57 | 57 | /** |
58 | - * URL to view a transaction. |
|
59 | - * |
|
60 | - * @var string |
|
61 | - */ |
|
58 | + * URL to view a transaction. |
|
59 | + * |
|
60 | + * @var string |
|
61 | + */ |
|
62 | 62 | public $view_transaction_url = 'https://{sandbox}authorize.net/ui/themes/sandbox/Transaction/TransactionReceipt.aspx?transid=%s'; |
63 | 63 | |
64 | 64 | /** |
65 | - * Class constructor. |
|
66 | - */ |
|
67 | - public function __construct() { |
|
65 | + * Class constructor. |
|
66 | + */ |
|
67 | + public function __construct() { |
|
68 | 68 | |
69 | 69 | $this->title = __( 'Credit Card / Debit Card', 'invoicing' ); |
70 | 70 | $this->method_title = __( 'Authorize.Net', 'invoicing' ); |
@@ -76,11 +76,11 @@ discard block |
||
76 | 76 | } |
77 | 77 | |
78 | 78 | /** |
79 | - * Displays the payment method select field. |
|
80 | - * |
|
81 | - * @param int $invoice_id 0 or invoice id. |
|
82 | - * @param GetPaid_Payment_Form $form Current payment form. |
|
83 | - */ |
|
79 | + * Displays the payment method select field. |
|
80 | + * |
|
81 | + * @param int $invoice_id 0 or invoice id. |
|
82 | + * @param GetPaid_Payment_Form $form Current payment form. |
|
83 | + */ |
|
84 | 84 | public function payment_fields( $invoice_id, $form ) { |
85 | 85 | |
86 | 86 | // Let the user select a payment method. |
@@ -91,16 +91,16 @@ discard block |
||
91 | 91 | } |
92 | 92 | |
93 | 93 | /** |
94 | - * Creates a customer profile. |
|
95 | - * |
|
96 | - * |
|
97 | - * @param WPInv_Invoice $invoice Invoice. |
|
94 | + * Creates a customer profile. |
|
95 | + * |
|
96 | + * |
|
97 | + * @param WPInv_Invoice $invoice Invoice. |
|
98 | 98 | * @param array $submission_data Posted checkout fields. |
99 | 99 | * @param bool $save Whether or not to save the payment as a token. |
100 | 100 | * @link https://developer.authorize.net/api/reference/index.html#customer-profiles-create-customer-profile |
101 | - * @return string|WP_Error Payment profile id. |
|
102 | - */ |
|
103 | - public function create_customer_profile( $invoice, $submission_data, $save = true ) { |
|
101 | + * @return string|WP_Error Payment profile id. |
|
102 | + */ |
|
103 | + public function create_customer_profile( $invoice, $submission_data, $save = true ) { |
|
104 | 104 | |
105 | 105 | // Remove non-digits from the number |
106 | 106 | $submission_data['authorizenet']['cc_number'] = preg_replace( '/\D/', '', $submission_data['authorizenet']['cc_number'] ); |
@@ -182,14 +182,14 @@ discard block |
||
182 | 182 | } |
183 | 183 | |
184 | 184 | /** |
185 | - * Retrieves a customer profile. |
|
186 | - * |
|
187 | - * |
|
188 | - * @param string $profile_id profile id. |
|
189 | - * @return string|WP_Error Profile id. |
|
185 | + * Retrieves a customer profile. |
|
186 | + * |
|
187 | + * |
|
188 | + * @param string $profile_id profile id. |
|
189 | + * @return string|WP_Error Profile id. |
|
190 | 190 | * @link https://developer.authorize.net/api/reference/index.html#customer-profiles-get-customer-profile |
191 | - */ |
|
192 | - public function get_customer_profile( $profile_id ) { |
|
191 | + */ |
|
192 | + public function get_customer_profile( $profile_id ) { |
|
193 | 193 | |
194 | 194 | // Generate args. |
195 | 195 | $args = array( |
@@ -204,17 +204,17 @@ discard block |
||
204 | 204 | } |
205 | 205 | |
206 | 206 | /** |
207 | - * Creates a customer profile. |
|
208 | - * |
|
209 | - * |
|
207 | + * Creates a customer profile. |
|
208 | + * |
|
209 | + * |
|
210 | 210 | * @param string $profile_id profile id. |
211 | - * @param WPInv_Invoice $invoice Invoice. |
|
211 | + * @param WPInv_Invoice $invoice Invoice. |
|
212 | 212 | * @param array $submission_data Posted checkout fields. |
213 | 213 | * @param bool $save Whether or not to save the payment as a token. |
214 | 214 | * @link https://developer.authorize.net/api/reference/index.html#customer-profiles-create-customer-profile |
215 | - * @return string|WP_Error Profile id. |
|
216 | - */ |
|
217 | - public function create_customer_payment_profile( $customer_profile, $invoice, $submission_data, $save ) { |
|
215 | + * @return string|WP_Error Profile id. |
|
216 | + */ |
|
217 | + public function create_customer_payment_profile( $customer_profile, $invoice, $submission_data, $save ) { |
|
218 | 218 | |
219 | 219 | // Remove non-digits from the number |
220 | 220 | $submission_data['authorizenet']['cc_number'] = preg_replace( '/\D/', '', $submission_data['authorizenet']['cc_number'] ); |
@@ -302,13 +302,13 @@ discard block |
||
302 | 302 | } |
303 | 303 | |
304 | 304 | /** |
305 | - * Retrieves payment details from cache. |
|
306 | - * |
|
307 | - * |
|
305 | + * Retrieves payment details from cache. |
|
306 | + * |
|
307 | + * |
|
308 | 308 | * @param array $payment_details. |
309 | - * @return array|false Profile id. |
|
310 | - */ |
|
311 | - public function retrieve_payment_profile_from_cache( $payment_details, $customer_profile, $invoice ) { |
|
309 | + * @return array|false Profile id. |
|
310 | + */ |
|
311 | + public function retrieve_payment_profile_from_cache( $payment_details, $customer_profile, $invoice ) { |
|
312 | 312 | |
313 | 313 | $cached_information = get_option( 'getpaid_authorize_net_cached_profiles', array() ); |
314 | 314 | $payment_details = hash_hmac( 'sha256', json_encode( $payment_details ), SECURE_AUTH_KEY ); |
@@ -333,13 +333,13 @@ discard block |
||
333 | 333 | } |
334 | 334 | |
335 | 335 | /** |
336 | - * Securely adds payment details to cache. |
|
337 | - * |
|
338 | - * |
|
336 | + * Securely adds payment details to cache. |
|
337 | + * |
|
338 | + * |
|
339 | 339 | * @param array $payment_details. |
340 | 340 | * @param string $payment_profile_id. |
341 | - */ |
|
342 | - public function add_payment_profile_to_cache( $payment_details, $payment_profile_id ) { |
|
341 | + */ |
|
342 | + public function add_payment_profile_to_cache( $payment_details, $payment_profile_id ) { |
|
343 | 343 | |
344 | 344 | $cached_information = get_option( 'getpaid_authorize_net_cached_profiles', array() ); |
345 | 345 | $cached_information = is_array( $cached_information ) ? $cached_information : array(); |
@@ -351,15 +351,15 @@ discard block |
||
351 | 351 | } |
352 | 352 | |
353 | 353 | /** |
354 | - * Retrieves a customer payment profile. |
|
355 | - * |
|
356 | - * |
|
357 | - * @param string $customer_profile_id customer profile id. |
|
354 | + * Retrieves a customer payment profile. |
|
355 | + * |
|
356 | + * |
|
357 | + * @param string $customer_profile_id customer profile id. |
|
358 | 358 | * @param string $payment_profile_id payment profile id. |
359 | - * @return string|WP_Error Profile id. |
|
359 | + * @return string|WP_Error Profile id. |
|
360 | 360 | * @link https://developer.authorize.net/api/reference/index.html#customer-profiles-get-customer-payment-profile |
361 | - */ |
|
362 | - public function get_customer_payment_profile( $customer_profile_id, $payment_profile_id ) { |
|
361 | + */ |
|
362 | + public function get_customer_payment_profile( $customer_profile_id, $payment_profile_id ) { |
|
363 | 363 | |
364 | 364 | // Generate args. |
365 | 365 | $args = array( |
@@ -375,15 +375,15 @@ discard block |
||
375 | 375 | } |
376 | 376 | |
377 | 377 | /** |
378 | - * Charges a customer payment profile. |
|
379 | - * |
|
378 | + * Charges a customer payment profile. |
|
379 | + * |
|
380 | 380 | * @param string $customer_profile_id customer profile id. |
381 | 381 | * @param string $payment_profile_id payment profile id. |
382 | - * @param WPInv_Invoice $invoice Invoice. |
|
382 | + * @param WPInv_Invoice $invoice Invoice. |
|
383 | 383 | * @link https://developer.authorize.net/api/reference/index.html#payment-transactions-charge-a-customer-profile |
384 | - * @return WP_Error|object |
|
385 | - */ |
|
386 | - public function charge_customer_payment_profile( $customer_profile_id, $payment_profile_id, $invoice ) { |
|
384 | + * @return WP_Error|object |
|
385 | + */ |
|
386 | + public function charge_customer_payment_profile( $customer_profile_id, $payment_profile_id, $invoice ) { |
|
387 | 387 | |
388 | 388 | // Generate args. |
389 | 389 | $args = array( |
@@ -429,41 +429,41 @@ discard block |
||
429 | 429 | } |
430 | 430 | |
431 | 431 | /** |
432 | - * Processes a customer charge. |
|
433 | - * |
|
432 | + * Processes a customer charge. |
|
433 | + * |
|
434 | 434 | * @param stdClass $result Api response. |
435 | - * @param WPInv_Invoice $invoice Invoice. |
|
436 | - */ |
|
437 | - public function process_charge_response( $result, $invoice ) { |
|
435 | + * @param WPInv_Invoice $invoice Invoice. |
|
436 | + */ |
|
437 | + public function process_charge_response( $result, $invoice ) { |
|
438 | 438 | |
439 | 439 | wpinv_clear_errors(); |
440 | - $response_code = (int) $result->transactionResponse->responseCode; |
|
440 | + $response_code = (int) $result->transactionResponse->responseCode; |
|
441 | 441 | |
442 | - // Succeeded. |
|
443 | - if ( 1 == $response_code || 4 == $response_code ) { |
|
442 | + // Succeeded. |
|
443 | + if ( 1 == $response_code || 4 == $response_code ) { |
|
444 | 444 | |
445 | - // Maybe set a transaction id. |
|
446 | - if ( ! empty( $result->transactionResponse->transId ) ) { |
|
447 | - $invoice->set_transaction_id( $result->transactionResponse->transId ); |
|
448 | - } |
|
445 | + // Maybe set a transaction id. |
|
446 | + if ( ! empty( $result->transactionResponse->transId ) ) { |
|
447 | + $invoice->set_transaction_id( $result->transactionResponse->transId ); |
|
448 | + } |
|
449 | 449 | |
450 | - $invoice->add_note( sprintf( __( 'Authentication code: %1$s (%2$s).', 'invoicing' ), $result->transactionResponse->authCode, $result->transactionResponse->accountNumber ), false, false, true ); |
|
450 | + $invoice->add_note( sprintf( __( 'Authentication code: %1$s (%2$s).', 'invoicing' ), $result->transactionResponse->authCode, $result->transactionResponse->accountNumber ), false, false, true ); |
|
451 | 451 | |
452 | - if ( 1 == $response_code ) { |
|
453 | - return $invoice->mark_paid(); |
|
454 | - } |
|
452 | + if ( 1 == $response_code ) { |
|
453 | + return $invoice->mark_paid(); |
|
454 | + } |
|
455 | 455 | |
456 | - $invoice->set_status( 'wpi-onhold' ); |
|
457 | - $invoice->add_note( |
|
456 | + $invoice->set_status( 'wpi-onhold' ); |
|
457 | + $invoice->add_note( |
|
458 | 458 | sprintf( |
459 | 459 | __( 'Held for review: %s', 'invoicing' ), |
460 | 460 | $result->transactionResponse->messages->message[0]->description |
461 | 461 | ) |
462 | - ); |
|
462 | + ); |
|
463 | 463 | |
464 | - return $invoice->save(); |
|
464 | + return $invoice->save(); |
|
465 | 465 | |
466 | - } |
|
466 | + } |
|
467 | 467 | |
468 | 468 | wpinv_set_error( 'card_declined' ); |
469 | 469 | |
@@ -475,13 +475,13 @@ discard block |
||
475 | 475 | } |
476 | 476 | |
477 | 477 | /** |
478 | - * Returns payment information. |
|
479 | - * |
|
480 | - * |
|
481 | - * @param array $card Card details. |
|
482 | - * @return array |
|
483 | - */ |
|
484 | - public function get_payment_information( $card ) { |
|
478 | + * Returns payment information. |
|
479 | + * |
|
480 | + * |
|
481 | + * @param array $card Card details. |
|
482 | + * @return array |
|
483 | + */ |
|
484 | + public function get_payment_information( $card ) { |
|
485 | 485 | return array( |
486 | 486 | |
487 | 487 | 'creditCard' => array( |
@@ -494,25 +494,25 @@ discard block |
||
494 | 494 | } |
495 | 495 | |
496 | 496 | /** |
497 | - * Returns the customer profile meta name. |
|
498 | - * |
|
499 | - * |
|
500 | - * @param WPInv_Invoice $invoice Invoice. |
|
501 | - * @return string |
|
502 | - */ |
|
503 | - public function get_customer_profile_meta_name( $invoice ) { |
|
497 | + * Returns the customer profile meta name. |
|
498 | + * |
|
499 | + * |
|
500 | + * @param WPInv_Invoice $invoice Invoice. |
|
501 | + * @return string |
|
502 | + */ |
|
503 | + public function get_customer_profile_meta_name( $invoice ) { |
|
504 | 504 | return $this->is_sandbox( $invoice ) ? 'getpaid_authorizenet_sandbox_customer_profile_id' : 'getpaid_authorizenet_customer_profile_id'; |
505 | 505 | } |
506 | 506 | |
507 | 507 | /** |
508 | - * Validates the submitted data. |
|
509 | - * |
|
510 | - * |
|
511 | - * @param array $submission_data Posted checkout fields. |
|
508 | + * Validates the submitted data. |
|
509 | + * |
|
510 | + * |
|
511 | + * @param array $submission_data Posted checkout fields. |
|
512 | 512 | * @param WPInv_Invoice $invoice |
513 | - * @return WP_Error|string The payment profile id |
|
514 | - */ |
|
515 | - public function validate_submission_data( $submission_data, $invoice ) { |
|
513 | + * @return WP_Error|string The payment profile id |
|
514 | + */ |
|
515 | + public function validate_submission_data( $submission_data, $invoice ) { |
|
516 | 516 | |
517 | 517 | // Validate authentication details. |
518 | 518 | $auth = $this->get_auth_params(); |
@@ -544,13 +544,13 @@ discard block |
||
544 | 544 | } |
545 | 545 | |
546 | 546 | /** |
547 | - * Returns invoice line items. |
|
548 | - * |
|
549 | - * |
|
550 | - * @param WPInv_Invoice $invoice Invoice. |
|
551 | - * @return array |
|
552 | - */ |
|
553 | - public function get_line_items( $invoice ) { |
|
547 | + * Returns invoice line items. |
|
548 | + * |
|
549 | + * |
|
550 | + * @param WPInv_Invoice $invoice Invoice. |
|
551 | + * @return array |
|
552 | + */ |
|
553 | + public function get_line_items( $invoice ) { |
|
554 | 554 | $items = array(); |
555 | 555 | |
556 | 556 | foreach ( $invoice->get_items() as $item ) { |
@@ -587,15 +587,15 @@ discard block |
||
587 | 587 | } |
588 | 588 | |
589 | 589 | /** |
590 | - * Process Payment. |
|
591 | - * |
|
592 | - * |
|
593 | - * @param WPInv_Invoice $invoice Invoice. |
|
594 | - * @param array $submission_data Posted checkout fields. |
|
595 | - * @param GetPaid_Payment_Form_Submission $submission Checkout submission. |
|
596 | - * @return array |
|
597 | - */ |
|
598 | - public function process_payment( $invoice, $submission_data, $submission ) { |
|
590 | + * Process Payment. |
|
591 | + * |
|
592 | + * |
|
593 | + * @param WPInv_Invoice $invoice Invoice. |
|
594 | + * @param array $submission_data Posted checkout fields. |
|
595 | + * @param GetPaid_Payment_Form_Submission $submission Checkout submission. |
|
596 | + * @return array |
|
597 | + */ |
|
598 | + public function process_payment( $invoice, $submission_data, $submission ) { |
|
599 | 599 | |
600 | 600 | // Validate the submitted data. |
601 | 601 | $payment_profile_id = $this->validate_submission_data( $submission_data, $invoice ); |
@@ -628,45 +628,45 @@ discard block |
||
628 | 628 | |
629 | 629 | exit; |
630 | 630 | |
631 | - } |
|
631 | + } |
|
632 | 632 | |
633 | - /** |
|
634 | - * Processes the initial payment. |
|
635 | - * |
|
633 | + /** |
|
634 | + * Processes the initial payment. |
|
635 | + * |
|
636 | 636 | * @param WPInv_Invoice $invoice Invoice. |
637 | - */ |
|
638 | - protected function process_initial_payment( $invoice ) { |
|
637 | + */ |
|
638 | + protected function process_initial_payment( $invoice ) { |
|
639 | 639 | |
640 | - $payment_profile_id = get_post_meta( $invoice->get_id(), 'getpaid_authorizenet_profile_id', true ); |
|
640 | + $payment_profile_id = get_post_meta( $invoice->get_id(), 'getpaid_authorizenet_profile_id', true ); |
|
641 | 641 | $customer_profile = get_user_meta( $invoice->get_user_id(), $this->get_customer_profile_meta_name( $invoice ), true ); |
642 | - $result = $this->charge_customer_payment_profile( $customer_profile, $payment_profile_id, $invoice ); |
|
642 | + $result = $this->charge_customer_payment_profile( $customer_profile, $payment_profile_id, $invoice ); |
|
643 | 643 | |
644 | - // Do we have an error? |
|
645 | - if ( is_wp_error( $result ) ) { |
|
646 | - wpinv_set_error( $result->get_error_code(), $result->get_error_message() ); |
|
647 | - wpinv_send_back_to_checkout( $invoice ); |
|
648 | - } |
|
644 | + // Do we have an error? |
|
645 | + if ( is_wp_error( $result ) ) { |
|
646 | + wpinv_set_error( $result->get_error_code(), $result->get_error_message() ); |
|
647 | + wpinv_send_back_to_checkout( $invoice ); |
|
648 | + } |
|
649 | 649 | |
650 | - // Process the response. |
|
651 | - $this->process_charge_response( $result, $invoice ); |
|
650 | + // Process the response. |
|
651 | + $this->process_charge_response( $result, $invoice ); |
|
652 | 652 | |
653 | - if ( wpinv_get_errors() ) { |
|
654 | - wpinv_send_back_to_checkout( $invoice ); |
|
655 | - } |
|
653 | + if ( wpinv_get_errors() ) { |
|
654 | + wpinv_send_back_to_checkout( $invoice ); |
|
655 | + } |
|
656 | 656 | |
657 | - } |
|
657 | + } |
|
658 | 658 | |
659 | 659 | /** |
660 | - * Processes recurring payments. |
|
661 | - * |
|
660 | + * Processes recurring payments. |
|
661 | + * |
|
662 | 662 | * @param WPInv_Invoice $invoice Invoice. |
663 | 663 | * @param WPInv_Subscription[]|WPInv_Subscription $subscriptions Subscriptions. |
664 | - */ |
|
665 | - public function process_subscription( $invoice, $subscriptions ) { |
|
664 | + */ |
|
665 | + public function process_subscription( $invoice, $subscriptions ) { |
|
666 | 666 | |
667 | 667 | // Check if there is an initial amount to charge. |
668 | 668 | if ( (float) $invoice->get_total() > 0 ) { |
669 | - $this->process_initial_payment( $invoice ); |
|
669 | + $this->process_initial_payment( $invoice ); |
|
670 | 670 | } |
671 | 671 | |
672 | 672 | // Activate the subscriptions. |
@@ -684,36 +684,36 @@ discard block |
||
684 | 684 | } |
685 | 685 | } |
686 | 686 | |
687 | - // Redirect to the success page. |
|
687 | + // Redirect to the success page. |
|
688 | 688 | wpinv_send_to_success_page( array( 'invoice_key' => $invoice->get_key() ) ); |
689 | 689 | |
690 | 690 | } |
691 | 691 | |
692 | - /** |
|
693 | - * (Maybe) renews an authorize.net subscription profile. |
|
694 | - * |
|
695 | - * |
|
692 | + /** |
|
693 | + * (Maybe) renews an authorize.net subscription profile. |
|
694 | + * |
|
695 | + * |
|
696 | 696 | * @param WPInv_Subscription $subscription |
697 | - */ |
|
698 | - public function maybe_renew_subscription( $subscription ) { |
|
697 | + */ |
|
698 | + public function maybe_renew_subscription( $subscription ) { |
|
699 | 699 | |
700 | 700 | // Ensure its our subscription && it's active. |
701 | 701 | if ( $this->id === $subscription->get_gateway() && $subscription->has_status( 'active trialling' ) ) { |
702 | 702 | $this->renew_subscription( $subscription ); |
703 | 703 | } |
704 | 704 | |
705 | - } |
|
705 | + } |
|
706 | 706 | |
707 | 707 | /** |
708 | - * Renews a subscription. |
|
709 | - * |
|
708 | + * Renews a subscription. |
|
709 | + * |
|
710 | 710 | * @param WPInv_Subscription $subscription |
711 | - */ |
|
712 | - public function renew_subscription( $subscription ) { |
|
711 | + */ |
|
712 | + public function renew_subscription( $subscription ) { |
|
713 | 713 | |
714 | - // Generate the renewal invoice. |
|
715 | - $new_invoice = $subscription->create_payment(); |
|
716 | - $old_invoice = $subscription->get_parent_payment(); |
|
714 | + // Generate the renewal invoice. |
|
715 | + $new_invoice = $subscription->create_payment(); |
|
716 | + $old_invoice = $subscription->get_parent_payment(); |
|
717 | 717 | |
718 | 718 | if ( empty( $new_invoice ) ) { |
719 | 719 | $old_invoice->add_note( __( 'Error generating a renewal invoice.', 'invoicing' ), false, false, false ); |
@@ -722,37 +722,37 @@ discard block |
||
722 | 722 | } |
723 | 723 | |
724 | 724 | // Charge the payment method. |
725 | - $payment_profile_id = get_post_meta( $old_invoice->get_id(), 'getpaid_authorizenet_profile_id', true ); |
|
726 | - $customer_profile = get_user_meta( $old_invoice->get_user_id(), $this->get_customer_profile_meta_name( $old_invoice ), true ); |
|
727 | - $result = $this->charge_customer_payment_profile( $customer_profile, $payment_profile_id, $new_invoice ); |
|
728 | - |
|
729 | - // Do we have an error? |
|
730 | - if ( is_wp_error( $result ) ) { |
|
731 | - |
|
732 | - $old_invoice->add_note( |
|
733 | - sprintf( __( 'Error renewing subscription : ( %s ).', 'invoicing' ), $result->get_error_message() ), |
|
734 | - true, |
|
735 | - false, |
|
736 | - true |
|
737 | - ); |
|
738 | - $subscription->failing(); |
|
739 | - return; |
|
740 | - |
|
741 | - } |
|
742 | - |
|
743 | - // Process the response. |
|
744 | - $this->process_charge_response( $result, $new_invoice ); |
|
745 | - |
|
746 | - if ( wpinv_get_errors() ) { |
|
747 | - |
|
748 | - $old_invoice->add_note( |
|
749 | - sprintf( __( 'Error renewing subscription : ( %s ).', 'invoicing' ), getpaid_get_errors_html() ), |
|
750 | - true, |
|
751 | - false, |
|
752 | - true |
|
753 | - ); |
|
754 | - $subscription->failing(); |
|
755 | - return; |
|
725 | + $payment_profile_id = get_post_meta( $old_invoice->get_id(), 'getpaid_authorizenet_profile_id', true ); |
|
726 | + $customer_profile = get_user_meta( $old_invoice->get_user_id(), $this->get_customer_profile_meta_name( $old_invoice ), true ); |
|
727 | + $result = $this->charge_customer_payment_profile( $customer_profile, $payment_profile_id, $new_invoice ); |
|
728 | + |
|
729 | + // Do we have an error? |
|
730 | + if ( is_wp_error( $result ) ) { |
|
731 | + |
|
732 | + $old_invoice->add_note( |
|
733 | + sprintf( __( 'Error renewing subscription : ( %s ).', 'invoicing' ), $result->get_error_message() ), |
|
734 | + true, |
|
735 | + false, |
|
736 | + true |
|
737 | + ); |
|
738 | + $subscription->failing(); |
|
739 | + return; |
|
740 | + |
|
741 | + } |
|
742 | + |
|
743 | + // Process the response. |
|
744 | + $this->process_charge_response( $result, $new_invoice ); |
|
745 | + |
|
746 | + if ( wpinv_get_errors() ) { |
|
747 | + |
|
748 | + $old_invoice->add_note( |
|
749 | + sprintf( __( 'Error renewing subscription : ( %s ).', 'invoicing' ), getpaid_get_errors_html() ), |
|
750 | + true, |
|
751 | + false, |
|
752 | + true |
|
753 | + ); |
|
754 | + $subscription->failing(); |
|
755 | + return; |
|
756 | 756 | |
757 | 757 | } |
758 | 758 | |
@@ -761,13 +761,13 @@ discard block |
||
761 | 761 | } |
762 | 762 | |
763 | 763 | /** |
764 | - * Processes invoice addons. |
|
765 | - * |
|
766 | - * @param WPInv_Invoice $invoice |
|
767 | - * @param GetPaid_Form_Item[] $items |
|
768 | - * @return WPInv_Invoice |
|
769 | - */ |
|
770 | - public function process_addons( $invoice, $items ) { |
|
764 | + * Processes invoice addons. |
|
765 | + * |
|
766 | + * @param WPInv_Invoice $invoice |
|
767 | + * @param GetPaid_Form_Item[] $items |
|
768 | + * @return WPInv_Invoice |
|
769 | + */ |
|
770 | + public function process_addons( $invoice, $items ) { |
|
771 | 771 | |
772 | 772 | global $getpaid_authorize_addons; |
773 | 773 | |
@@ -786,7 +786,7 @@ discard block |
||
786 | 786 | $invoice->recalculate_total(); |
787 | 787 | |
788 | 788 | $payment_profile_id = get_post_meta( $invoice->get_id(), 'getpaid_authorizenet_profile_id', true ); |
789 | - $customer_profile = get_user_meta( $invoice->get_user_id(), $this->get_customer_profile_meta_name( $invoice ), true ); |
|
789 | + $customer_profile = get_user_meta( $invoice->get_user_id(), $this->get_customer_profile_meta_name( $invoice ), true ); |
|
790 | 790 | |
791 | 791 | add_filter( 'getpaid_authorizenet_charge_customer_payment_profile_args', array( $this, 'filter_addons_request' ), 10, 2 ); |
792 | 792 | $result = $this->charge_customer_payment_profile( $customer_profile, $payment_profile_id, $invoice ); |
@@ -801,11 +801,11 @@ discard block |
||
801 | 801 | } |
802 | 802 | |
803 | 803 | /** |
804 | - * Processes invoice addons. |
|
805 | - * |
|
804 | + * Processes invoice addons. |
|
805 | + * |
|
806 | 806 | * @param array $args |
807 | - * @return array |
|
808 | - */ |
|
807 | + * @return array |
|
808 | + */ |
|
809 | 809 | public function filter_addons_request( $args ) { |
810 | 810 | |
811 | 811 | global $getpaid_authorize_addons; |
@@ -839,11 +839,11 @@ discard block |
||
839 | 839 | } |
840 | 840 | |
841 | 841 | /** |
842 | - * Filters the gateway settings. |
|
843 | - * |
|
844 | - * @param array $admin_settings |
|
845 | - */ |
|
846 | - public function admin_settings( $admin_settings ) { |
|
842 | + * Filters the gateway settings. |
|
843 | + * |
|
844 | + * @param array $admin_settings |
|
845 | + */ |
|
846 | + public function admin_settings( $admin_settings ) { |
|
847 | 847 | |
848 | 848 | $currencies = sprintf( |
849 | 849 | __( 'Supported Currencies: %s', 'invoicing' ), |
@@ -883,7 +883,7 @@ discard block |
||
883 | 883 | 'readonly' => true, |
884 | 884 | ); |
885 | 885 | |
886 | - return $admin_settings; |
|
887 | - } |
|
886 | + return $admin_settings; |
|
887 | + } |
|
888 | 888 | |
889 | 889 | } |