@@ -20,402 +20,402 @@ 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 | - |
|
69 | - // Save default tax rates. |
|
70 | - update_option( 'wpinv_tax_rates', wpinv_get_data( 'tax-rates' ) ); |
|
71 | - } |
|
72 | - |
|
73 | - /** |
|
74 | - * Upgrade to 0.0.5 |
|
75 | - * |
|
76 | - */ |
|
77 | - public function upgrade_from_004() { |
|
78 | - global $wpdb; |
|
79 | - |
|
80 | - // Invoices. |
|
81 | - $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' )" ); |
|
82 | - if ( ! empty( $results ) ) { |
|
83 | - $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' )" ); |
|
84 | - |
|
85 | - // Clean post cache |
|
86 | - foreach ( $results as $row ) { |
|
87 | - clean_post_cache( $row->ID ); |
|
88 | - } |
|
89 | - } |
|
90 | - |
|
91 | - // Item meta key changes |
|
92 | - $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' )"; |
|
93 | - $results = $wpdb->get_results( $query ); |
|
94 | - |
|
95 | - if ( ! empty( $results ) ) { |
|
96 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" ); |
|
97 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" ); |
|
98 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" ); |
|
99 | - |
|
100 | - foreach ( $results as $row ) { |
|
101 | - clean_post_cache( $row->post_id ); |
|
102 | - } |
|
103 | - } |
|
104 | - |
|
105 | - $this->upgrade_from_118(); |
|
106 | - } |
|
107 | - |
|
108 | - /** |
|
109 | - * Upgrade to version 2.0.0. |
|
110 | - * |
|
111 | - */ |
|
112 | - public function upgrade_from_118() { |
|
113 | - $this->migrate_old_invoices(); |
|
114 | - $this->upgrade_from_279(); |
|
115 | - } |
|
116 | - |
|
117 | - /** |
|
118 | - * Upgrade to version 2.0.0. |
|
119 | - * |
|
120 | - */ |
|
121 | - public function upgrade_from_279() { |
|
122 | - self::migrate_old_customers(); |
|
123 | - } |
|
124 | - |
|
125 | - /** |
|
126 | - * Give administrators the capability to manage GetPaid. |
|
127 | - * |
|
128 | - */ |
|
129 | - public function add_capabilities() { |
|
130 | - $GLOBALS['wp_roles']->add_cap( 'administrator', 'manage_invoicing' ); |
|
131 | - } |
|
132 | - |
|
133 | - /** |
|
134 | - * Retreives GetPaid pages. |
|
135 | - * |
|
136 | - */ |
|
137 | - public static function get_pages() { |
|
138 | - |
|
139 | - return apply_filters( |
|
140 | - 'wpinv_create_pages', |
|
141 | - array( |
|
142 | - |
|
143 | - // Checkout page. |
|
144 | - 'checkout_page' => array( |
|
145 | - 'name' => _x( 'gp-checkout', 'Page slug', 'invoicing' ), |
|
146 | - 'title' => _x( 'Checkout', 'Page title', 'invoicing' ), |
|
147 | - '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 | + |
|
69 | + // Save default tax rates. |
|
70 | + update_option( 'wpinv_tax_rates', wpinv_get_data( 'tax-rates' ) ); |
|
71 | + } |
|
72 | + |
|
73 | + /** |
|
74 | + * Upgrade to 0.0.5 |
|
75 | + * |
|
76 | + */ |
|
77 | + public function upgrade_from_004() { |
|
78 | + global $wpdb; |
|
79 | + |
|
80 | + // Invoices. |
|
81 | + $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' )" ); |
|
82 | + if ( ! empty( $results ) ) { |
|
83 | + $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' )" ); |
|
84 | + |
|
85 | + // Clean post cache |
|
86 | + foreach ( $results as $row ) { |
|
87 | + clean_post_cache( $row->ID ); |
|
88 | + } |
|
89 | + } |
|
90 | + |
|
91 | + // Item meta key changes |
|
92 | + $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' )"; |
|
93 | + $results = $wpdb->get_results( $query ); |
|
94 | + |
|
95 | + if ( ! empty( $results ) ) { |
|
96 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" ); |
|
97 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" ); |
|
98 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" ); |
|
99 | + |
|
100 | + foreach ( $results as $row ) { |
|
101 | + clean_post_cache( $row->post_id ); |
|
102 | + } |
|
103 | + } |
|
104 | + |
|
105 | + $this->upgrade_from_118(); |
|
106 | + } |
|
107 | + |
|
108 | + /** |
|
109 | + * Upgrade to version 2.0.0. |
|
110 | + * |
|
111 | + */ |
|
112 | + public function upgrade_from_118() { |
|
113 | + $this->migrate_old_invoices(); |
|
114 | + $this->upgrade_from_279(); |
|
115 | + } |
|
116 | + |
|
117 | + /** |
|
118 | + * Upgrade to version 2.0.0. |
|
119 | + * |
|
120 | + */ |
|
121 | + public function upgrade_from_279() { |
|
122 | + self::migrate_old_customers(); |
|
123 | + } |
|
124 | + |
|
125 | + /** |
|
126 | + * Give administrators the capability to manage GetPaid. |
|
127 | + * |
|
128 | + */ |
|
129 | + public function add_capabilities() { |
|
130 | + $GLOBALS['wp_roles']->add_cap( 'administrator', 'manage_invoicing' ); |
|
131 | + } |
|
132 | + |
|
133 | + /** |
|
134 | + * Retreives GetPaid pages. |
|
135 | + * |
|
136 | + */ |
|
137 | + public static function get_pages() { |
|
138 | + |
|
139 | + return apply_filters( |
|
140 | + 'wpinv_create_pages', |
|
141 | + array( |
|
142 | + |
|
143 | + // Checkout page. |
|
144 | + 'checkout_page' => array( |
|
145 | + 'name' => _x( 'gp-checkout', 'Page slug', 'invoicing' ), |
|
146 | + 'title' => _x( 'Checkout', 'Page title', 'invoicing' ), |
|
147 | + 'content' => ' |
|
148 | 148 | <!-- wp:shortcode --> |
149 | 149 | [wpinv_checkout] |
150 | 150 | <!-- /wp:shortcode --> |
151 | 151 | ', |
152 | - 'parent' => '', |
|
153 | - ), |
|
154 | - |
|
155 | - // Invoice history page. |
|
156 | - 'invoice_history_page' => array( |
|
157 | - 'name' => _x( 'gp-invoices', 'Page slug', 'invoicing' ), |
|
158 | - 'title' => _x( 'My Invoices', 'Page title', 'invoicing' ), |
|
159 | - 'content' => ' |
|
152 | + 'parent' => '', |
|
153 | + ), |
|
154 | + |
|
155 | + // Invoice history page. |
|
156 | + 'invoice_history_page' => array( |
|
157 | + 'name' => _x( 'gp-invoices', 'Page slug', 'invoicing' ), |
|
158 | + 'title' => _x( 'My Invoices', 'Page title', 'invoicing' ), |
|
159 | + 'content' => ' |
|
160 | 160 | <!-- wp:shortcode --> |
161 | 161 | [wpinv_history] |
162 | 162 | <!-- /wp:shortcode --> |
163 | 163 | ', |
164 | - 'parent' => '', |
|
165 | - ), |
|
166 | - |
|
167 | - // Success page content. |
|
168 | - 'success_page' => array( |
|
169 | - 'name' => _x( 'gp-receipt', 'Page slug', 'invoicing' ), |
|
170 | - 'title' => _x( 'Payment Confirmation', 'Page title', 'invoicing' ), |
|
171 | - 'content' => ' |
|
164 | + 'parent' => '', |
|
165 | + ), |
|
166 | + |
|
167 | + // Success page content. |
|
168 | + 'success_page' => array( |
|
169 | + 'name' => _x( 'gp-receipt', 'Page slug', 'invoicing' ), |
|
170 | + 'title' => _x( 'Payment Confirmation', 'Page title', 'invoicing' ), |
|
171 | + 'content' => ' |
|
172 | 172 | <!-- wp:shortcode --> |
173 | 173 | [wpinv_receipt] |
174 | 174 | <!-- /wp:shortcode --> |
175 | 175 | ', |
176 | - 'parent' => 'gp-checkout', |
|
177 | - ), |
|
178 | - |
|
179 | - // Failure page content. |
|
180 | - 'failure_page' => array( |
|
181 | - 'name' => _x( 'gp-transaction-failed', 'Page slug', 'invoicing' ), |
|
182 | - 'title' => _x( 'Transaction Failed', 'Page title', 'invoicing' ), |
|
183 | - 'content' => __( 'Your transaction failed, please try again or contact site support.', 'invoicing' ), |
|
184 | - 'parent' => 'gp-checkout', |
|
185 | - ), |
|
186 | - |
|
187 | - // Subscriptions history page. |
|
188 | - 'invoice_subscription_page' => array( |
|
189 | - 'name' => _x( 'gp-subscriptions', 'Page slug', 'invoicing' ), |
|
190 | - 'title' => _x( 'My Subscriptions', 'Page title', 'invoicing' ), |
|
191 | - 'content' => ' |
|
176 | + 'parent' => 'gp-checkout', |
|
177 | + ), |
|
178 | + |
|
179 | + // Failure page content. |
|
180 | + 'failure_page' => array( |
|
181 | + 'name' => _x( 'gp-transaction-failed', 'Page slug', 'invoicing' ), |
|
182 | + 'title' => _x( 'Transaction Failed', 'Page title', 'invoicing' ), |
|
183 | + 'content' => __( 'Your transaction failed, please try again or contact site support.', 'invoicing' ), |
|
184 | + 'parent' => 'gp-checkout', |
|
185 | + ), |
|
186 | + |
|
187 | + // Subscriptions history page. |
|
188 | + 'invoice_subscription_page' => array( |
|
189 | + 'name' => _x( 'gp-subscriptions', 'Page slug', 'invoicing' ), |
|
190 | + 'title' => _x( 'My Subscriptions', 'Page title', 'invoicing' ), |
|
191 | + 'content' => ' |
|
192 | 192 | <!-- wp:shortcode --> |
193 | 193 | [wpinv_subscriptions] |
194 | 194 | <!-- /wp:shortcode --> |
195 | 195 | ', |
196 | - 'parent' => '', |
|
197 | - ), |
|
198 | - |
|
199 | - ) |
|
200 | - ); |
|
201 | - |
|
202 | - } |
|
203 | - |
|
204 | - /** |
|
205 | - * Re-create GetPaid pages. |
|
206 | - * |
|
207 | - */ |
|
208 | - public function create_pages() { |
|
209 | - |
|
210 | - foreach ( self::get_pages() as $key => $page ) { |
|
211 | - wpinv_create_page( esc_sql( $page['name'] ), $key, $page['title'], $page['content'], $page['parent'] ); |
|
212 | - } |
|
213 | - |
|
214 | - } |
|
215 | - |
|
216 | - /** |
|
217 | - * Migrates old invoices to new invoices. |
|
218 | - * |
|
219 | - */ |
|
220 | - public function migrate_old_invoices() { |
|
221 | - global $wpdb; |
|
222 | - |
|
223 | - $invoices_table = $wpdb->prefix . 'getpaid_invoices'; |
|
224 | - $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items'; |
|
225 | - $migrated = $wpdb->get_col( "SELECT post_id FROM $invoices_table" ); |
|
226 | - $invoices = array_unique( |
|
227 | - get_posts( |
|
228 | - array( |
|
229 | - 'post_type' => array( 'wpi_invoice', 'wpi_quote' ), |
|
230 | - 'posts_per_page' => -1, |
|
231 | - 'fields' => 'ids', |
|
232 | - 'post_status' => array_keys( get_post_stati() ), |
|
233 | - 'exclude' => (array) $migrated, |
|
234 | - ) |
|
235 | - ) |
|
236 | - ); |
|
237 | - |
|
238 | - // Abort if we do not have any invoices. |
|
239 | - if ( empty( $invoices ) ) { |
|
240 | - return; |
|
241 | - } |
|
242 | - |
|
243 | - require_once WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php'; |
|
244 | - |
|
245 | - $invoice_rows = array(); |
|
246 | - foreach ( $invoices as $invoice ) { |
|
247 | - |
|
248 | - $invoice = new WPInv_Legacy_Invoice( $invoice ); |
|
249 | - |
|
250 | - if ( empty( $invoice->ID ) ) { |
|
251 | - return; |
|
252 | - } |
|
253 | - |
|
254 | - $fields = array( |
|
255 | - 'post_id' => $invoice->ID, |
|
256 | - 'number' => $invoice->get_number(), |
|
257 | - 'key' => $invoice->get_key(), |
|
258 | - 'type' => str_replace( 'wpi_', '', $invoice->post_type ), |
|
259 | - 'mode' => $invoice->mode, |
|
260 | - 'user_ip' => $invoice->get_ip(), |
|
261 | - 'first_name' => $invoice->get_first_name(), |
|
262 | - 'last_name' => $invoice->get_last_name(), |
|
263 | - 'address' => $invoice->get_address(), |
|
264 | - 'city' => $invoice->city, |
|
265 | - 'state' => $invoice->state, |
|
266 | - 'country' => $invoice->country, |
|
267 | - 'zip' => $invoice->zip, |
|
268 | - 'adddress_confirmed' => (int) $invoice->adddress_confirmed, |
|
269 | - 'gateway' => $invoice->get_gateway(), |
|
270 | - 'transaction_id' => $invoice->get_transaction_id(), |
|
271 | - 'currency' => $invoice->get_currency(), |
|
272 | - 'subtotal' => $invoice->get_subtotal(), |
|
273 | - 'tax' => $invoice->get_tax(), |
|
274 | - 'fees_total' => $invoice->get_fees_total(), |
|
275 | - 'total' => $invoice->get_total(), |
|
276 | - 'discount' => $invoice->get_discount(), |
|
277 | - 'discount_code' => $invoice->get_discount_code(), |
|
278 | - 'disable_taxes' => $invoice->disable_taxes, |
|
279 | - 'due_date' => $invoice->get_due_date(), |
|
280 | - 'completed_date' => $invoice->get_completed_date(), |
|
281 | - 'company' => $invoice->company, |
|
282 | - 'vat_number' => $invoice->vat_number, |
|
283 | - 'vat_rate' => $invoice->vat_rate, |
|
284 | - 'custom_meta' => $invoice->payment_meta, |
|
285 | - ); |
|
286 | - |
|
287 | - foreach ( $fields as $key => $val ) { |
|
288 | - if ( is_null( $val ) ) { |
|
289 | - $val = ''; |
|
290 | - } |
|
291 | - $val = maybe_serialize( $val ); |
|
292 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
293 | - } |
|
294 | - |
|
295 | - $fields = implode( ', ', $fields ); |
|
296 | - $invoice_rows[] = "($fields)"; |
|
297 | - |
|
298 | - $item_rows = array(); |
|
299 | - $item_columns = array(); |
|
300 | - foreach ( $invoice->get_cart_details() as $details ) { |
|
301 | - $fields = array( |
|
302 | - 'post_id' => $invoice->ID, |
|
303 | - 'item_id' => $details['id'], |
|
304 | - 'item_name' => $details['name'], |
|
305 | - 'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'], |
|
306 | - 'vat_rate' => $details['vat_rate'], |
|
307 | - 'vat_class' => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'], |
|
308 | - 'tax' => $details['tax'], |
|
309 | - 'item_price' => $details['item_price'], |
|
310 | - 'custom_price' => $details['custom_price'], |
|
311 | - 'quantity' => $details['quantity'], |
|
312 | - 'discount' => $details['discount'], |
|
313 | - 'subtotal' => $details['subtotal'], |
|
314 | - 'price' => $details['price'], |
|
315 | - 'meta' => $details['meta'], |
|
316 | - 'fees' => $details['fees'], |
|
317 | - ); |
|
318 | - |
|
319 | - $item_columns = array_keys( $fields ); |
|
320 | - |
|
321 | - foreach ( $fields as $key => $val ) { |
|
322 | - if ( is_null( $val ) ) { |
|
323 | - $val = ''; |
|
324 | - } |
|
325 | - $val = maybe_serialize( $val ); |
|
326 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
327 | - } |
|
328 | - |
|
329 | - $fields = implode( ', ', $fields ); |
|
330 | - $item_rows[] = "($fields)"; |
|
331 | - } |
|
332 | - |
|
333 | - $item_rows = implode( ', ', $item_rows ); |
|
334 | - $item_columns = implode( ', ', $item_columns ); |
|
335 | - $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" ); |
|
336 | - } |
|
337 | - |
|
338 | - if ( empty( $invoice_rows ) ) { |
|
339 | - return; |
|
340 | - } |
|
341 | - |
|
342 | - $invoice_rows = implode( ', ', $invoice_rows ); |
|
343 | - $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" ); |
|
344 | - |
|
345 | - } |
|
346 | - |
|
347 | - /** |
|
348 | - * Migrates old customers to new table. |
|
349 | - * |
|
350 | - */ |
|
351 | - public static function migrate_old_customers() { |
|
352 | - global $wpdb; |
|
353 | - |
|
354 | - // Fetch post_id from $wpdb->prefix . 'getpaid_invoices' where customer_id = 0 or null. |
|
355 | - $invoice_ids = $wpdb->get_col( "SELECT post_id FROM {$wpdb->prefix}getpaid_invoices WHERE customer_id = 0 OR customer_id IS NULL" ); |
|
356 | - |
|
357 | - foreach ( $invoice_ids as $invoice_id ) { |
|
358 | - $invoice = wpinv_get_invoice( $invoice_id ); |
|
359 | - |
|
360 | - if ( empty( $invoice ) ) { |
|
361 | - continue; |
|
362 | - } |
|
363 | - |
|
364 | - // Fetch customer from the user ID. |
|
365 | - $user_id = $invoice->get_user_id(); |
|
366 | - |
|
367 | - if ( empty( $user_id ) ) { |
|
368 | - continue; |
|
369 | - } |
|
370 | - |
|
371 | - $customer = getpaid_get_customer_by_user_id( $user_id ); |
|
372 | - |
|
373 | - // Create if not exists. |
|
374 | - if ( empty( $customer ) ) { |
|
375 | - $customer = new GetPaid_Customer( 0 ); |
|
376 | - $customer->clone_user( $user_id ); |
|
377 | - $customer->save(); |
|
378 | - } |
|
379 | - |
|
380 | - $invoice->set_customer_id( $customer->get_id() ); |
|
381 | - $invoice->save(); |
|
382 | - } |
|
383 | - |
|
384 | - } |
|
385 | - |
|
386 | - /** |
|
387 | - * Migrates old invoices to new invoices. |
|
388 | - * |
|
389 | - */ |
|
390 | - public static function rename_gateways_label() { |
|
391 | - global $wpdb; |
|
392 | - |
|
393 | - foreach ( array_keys( wpinv_get_payment_gateways() ) as $gateway ) { |
|
394 | - |
|
395 | - $wpdb->update( |
|
396 | - $wpdb->prefix . 'getpaid_invoices', |
|
397 | - array( 'gateway' => $gateway ), |
|
398 | - array( 'gateway' => wpinv_get_gateway_admin_label( $gateway ) ), |
|
399 | - '%s', |
|
400 | - '%s' |
|
401 | - ); |
|
402 | - |
|
403 | - } |
|
404 | - } |
|
405 | - |
|
406 | - /** |
|
407 | - * Returns the DB schema. |
|
408 | - * |
|
409 | - */ |
|
410 | - public static function get_db_schema() { |
|
411 | - global $wpdb; |
|
412 | - |
|
413 | - require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
414 | - |
|
415 | - $charset_collate = $wpdb->get_charset_collate(); |
|
196 | + 'parent' => '', |
|
197 | + ), |
|
198 | + |
|
199 | + ) |
|
200 | + ); |
|
201 | + |
|
202 | + } |
|
203 | + |
|
204 | + /** |
|
205 | + * Re-create GetPaid pages. |
|
206 | + * |
|
207 | + */ |
|
208 | + public function create_pages() { |
|
209 | + |
|
210 | + foreach ( self::get_pages() as $key => $page ) { |
|
211 | + wpinv_create_page( esc_sql( $page['name'] ), $key, $page['title'], $page['content'], $page['parent'] ); |
|
212 | + } |
|
213 | + |
|
214 | + } |
|
215 | + |
|
216 | + /** |
|
217 | + * Migrates old invoices to new invoices. |
|
218 | + * |
|
219 | + */ |
|
220 | + public function migrate_old_invoices() { |
|
221 | + global $wpdb; |
|
222 | + |
|
223 | + $invoices_table = $wpdb->prefix . 'getpaid_invoices'; |
|
224 | + $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items'; |
|
225 | + $migrated = $wpdb->get_col( "SELECT post_id FROM $invoices_table" ); |
|
226 | + $invoices = array_unique( |
|
227 | + get_posts( |
|
228 | + array( |
|
229 | + 'post_type' => array( 'wpi_invoice', 'wpi_quote' ), |
|
230 | + 'posts_per_page' => -1, |
|
231 | + 'fields' => 'ids', |
|
232 | + 'post_status' => array_keys( get_post_stati() ), |
|
233 | + 'exclude' => (array) $migrated, |
|
234 | + ) |
|
235 | + ) |
|
236 | + ); |
|
237 | + |
|
238 | + // Abort if we do not have any invoices. |
|
239 | + if ( empty( $invoices ) ) { |
|
240 | + return; |
|
241 | + } |
|
242 | + |
|
243 | + require_once WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php'; |
|
244 | + |
|
245 | + $invoice_rows = array(); |
|
246 | + foreach ( $invoices as $invoice ) { |
|
247 | + |
|
248 | + $invoice = new WPInv_Legacy_Invoice( $invoice ); |
|
249 | + |
|
250 | + if ( empty( $invoice->ID ) ) { |
|
251 | + return; |
|
252 | + } |
|
253 | + |
|
254 | + $fields = array( |
|
255 | + 'post_id' => $invoice->ID, |
|
256 | + 'number' => $invoice->get_number(), |
|
257 | + 'key' => $invoice->get_key(), |
|
258 | + 'type' => str_replace( 'wpi_', '', $invoice->post_type ), |
|
259 | + 'mode' => $invoice->mode, |
|
260 | + 'user_ip' => $invoice->get_ip(), |
|
261 | + 'first_name' => $invoice->get_first_name(), |
|
262 | + 'last_name' => $invoice->get_last_name(), |
|
263 | + 'address' => $invoice->get_address(), |
|
264 | + 'city' => $invoice->city, |
|
265 | + 'state' => $invoice->state, |
|
266 | + 'country' => $invoice->country, |
|
267 | + 'zip' => $invoice->zip, |
|
268 | + 'adddress_confirmed' => (int) $invoice->adddress_confirmed, |
|
269 | + 'gateway' => $invoice->get_gateway(), |
|
270 | + 'transaction_id' => $invoice->get_transaction_id(), |
|
271 | + 'currency' => $invoice->get_currency(), |
|
272 | + 'subtotal' => $invoice->get_subtotal(), |
|
273 | + 'tax' => $invoice->get_tax(), |
|
274 | + 'fees_total' => $invoice->get_fees_total(), |
|
275 | + 'total' => $invoice->get_total(), |
|
276 | + 'discount' => $invoice->get_discount(), |
|
277 | + 'discount_code' => $invoice->get_discount_code(), |
|
278 | + 'disable_taxes' => $invoice->disable_taxes, |
|
279 | + 'due_date' => $invoice->get_due_date(), |
|
280 | + 'completed_date' => $invoice->get_completed_date(), |
|
281 | + 'company' => $invoice->company, |
|
282 | + 'vat_number' => $invoice->vat_number, |
|
283 | + 'vat_rate' => $invoice->vat_rate, |
|
284 | + 'custom_meta' => $invoice->payment_meta, |
|
285 | + ); |
|
286 | + |
|
287 | + foreach ( $fields as $key => $val ) { |
|
288 | + if ( is_null( $val ) ) { |
|
289 | + $val = ''; |
|
290 | + } |
|
291 | + $val = maybe_serialize( $val ); |
|
292 | + $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
293 | + } |
|
294 | + |
|
295 | + $fields = implode( ', ', $fields ); |
|
296 | + $invoice_rows[] = "($fields)"; |
|
297 | + |
|
298 | + $item_rows = array(); |
|
299 | + $item_columns = array(); |
|
300 | + foreach ( $invoice->get_cart_details() as $details ) { |
|
301 | + $fields = array( |
|
302 | + 'post_id' => $invoice->ID, |
|
303 | + 'item_id' => $details['id'], |
|
304 | + 'item_name' => $details['name'], |
|
305 | + 'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'], |
|
306 | + 'vat_rate' => $details['vat_rate'], |
|
307 | + 'vat_class' => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'], |
|
308 | + 'tax' => $details['tax'], |
|
309 | + 'item_price' => $details['item_price'], |
|
310 | + 'custom_price' => $details['custom_price'], |
|
311 | + 'quantity' => $details['quantity'], |
|
312 | + 'discount' => $details['discount'], |
|
313 | + 'subtotal' => $details['subtotal'], |
|
314 | + 'price' => $details['price'], |
|
315 | + 'meta' => $details['meta'], |
|
316 | + 'fees' => $details['fees'], |
|
317 | + ); |
|
318 | + |
|
319 | + $item_columns = array_keys( $fields ); |
|
320 | + |
|
321 | + foreach ( $fields as $key => $val ) { |
|
322 | + if ( is_null( $val ) ) { |
|
323 | + $val = ''; |
|
324 | + } |
|
325 | + $val = maybe_serialize( $val ); |
|
326 | + $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
327 | + } |
|
328 | + |
|
329 | + $fields = implode( ', ', $fields ); |
|
330 | + $item_rows[] = "($fields)"; |
|
331 | + } |
|
332 | + |
|
333 | + $item_rows = implode( ', ', $item_rows ); |
|
334 | + $item_columns = implode( ', ', $item_columns ); |
|
335 | + $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" ); |
|
336 | + } |
|
337 | + |
|
338 | + if ( empty( $invoice_rows ) ) { |
|
339 | + return; |
|
340 | + } |
|
341 | + |
|
342 | + $invoice_rows = implode( ', ', $invoice_rows ); |
|
343 | + $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" ); |
|
344 | + |
|
345 | + } |
|
346 | + |
|
347 | + /** |
|
348 | + * Migrates old customers to new table. |
|
349 | + * |
|
350 | + */ |
|
351 | + public static function migrate_old_customers() { |
|
352 | + global $wpdb; |
|
353 | + |
|
354 | + // Fetch post_id from $wpdb->prefix . 'getpaid_invoices' where customer_id = 0 or null. |
|
355 | + $invoice_ids = $wpdb->get_col( "SELECT post_id FROM {$wpdb->prefix}getpaid_invoices WHERE customer_id = 0 OR customer_id IS NULL" ); |
|
356 | + |
|
357 | + foreach ( $invoice_ids as $invoice_id ) { |
|
358 | + $invoice = wpinv_get_invoice( $invoice_id ); |
|
359 | + |
|
360 | + if ( empty( $invoice ) ) { |
|
361 | + continue; |
|
362 | + } |
|
363 | + |
|
364 | + // Fetch customer from the user ID. |
|
365 | + $user_id = $invoice->get_user_id(); |
|
366 | + |
|
367 | + if ( empty( $user_id ) ) { |
|
368 | + continue; |
|
369 | + } |
|
370 | + |
|
371 | + $customer = getpaid_get_customer_by_user_id( $user_id ); |
|
372 | + |
|
373 | + // Create if not exists. |
|
374 | + if ( empty( $customer ) ) { |
|
375 | + $customer = new GetPaid_Customer( 0 ); |
|
376 | + $customer->clone_user( $user_id ); |
|
377 | + $customer->save(); |
|
378 | + } |
|
379 | + |
|
380 | + $invoice->set_customer_id( $customer->get_id() ); |
|
381 | + $invoice->save(); |
|
382 | + } |
|
383 | + |
|
384 | + } |
|
385 | + |
|
386 | + /** |
|
387 | + * Migrates old invoices to new invoices. |
|
388 | + * |
|
389 | + */ |
|
390 | + public static function rename_gateways_label() { |
|
391 | + global $wpdb; |
|
392 | + |
|
393 | + foreach ( array_keys( wpinv_get_payment_gateways() ) as $gateway ) { |
|
394 | + |
|
395 | + $wpdb->update( |
|
396 | + $wpdb->prefix . 'getpaid_invoices', |
|
397 | + array( 'gateway' => $gateway ), |
|
398 | + array( 'gateway' => wpinv_get_gateway_admin_label( $gateway ) ), |
|
399 | + '%s', |
|
400 | + '%s' |
|
401 | + ); |
|
402 | + |
|
403 | + } |
|
404 | + } |
|
405 | + |
|
406 | + /** |
|
407 | + * Returns the DB schema. |
|
408 | + * |
|
409 | + */ |
|
410 | + public static function get_db_schema() { |
|
411 | + global $wpdb; |
|
412 | + |
|
413 | + require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
414 | + |
|
415 | + $charset_collate = $wpdb->get_charset_collate(); |
|
416 | 416 | |
417 | - // Subscriptions. |
|
418 | - $schema = "CREATE TABLE {$wpdb->prefix}wpinv_subscriptions ( |
|
417 | + // Subscriptions. |
|
418 | + $schema = "CREATE TABLE {$wpdb->prefix}wpinv_subscriptions ( |
|
419 | 419 | id bigint(20) unsigned NOT NULL auto_increment, |
420 | 420 | customer_id bigint(20) NOT NULL, |
421 | 421 | frequency int(11) NOT NULL DEFAULT '1', |
@@ -438,8 +438,8 @@ discard block |
||
438 | 438 | KEY customer_and_status (customer_id, status) |
439 | 439 | ) $charset_collate;"; |
440 | 440 | |
441 | - // Invoices. |
|
442 | - $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_invoices ( |
|
441 | + // Invoices. |
|
442 | + $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_invoices ( |
|
443 | 443 | post_id BIGINT(20) NOT NULL, |
444 | 444 | customer_id BIGINT(20) NOT NULL DEFAULT 0, |
445 | 445 | `number` VARCHAR(100), |
@@ -476,8 +476,8 @@ discard block |
||
476 | 476 | KEY invoice_key (invoice_key) |
477 | 477 | ) $charset_collate;"; |
478 | 478 | |
479 | - // Invoice items. |
|
480 | - $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_invoice_items ( |
|
479 | + // Invoice items. |
|
480 | + $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_invoice_items ( |
|
481 | 481 | ID BIGINT(20) NOT NULL AUTO_INCREMENT, |
482 | 482 | post_id BIGINT(20) NOT NULL, |
483 | 483 | item_id BIGINT(20) NOT NULL, |
@@ -499,8 +499,8 @@ discard block |
||
499 | 499 | KEY post_id (post_id) |
500 | 500 | ) $charset_collate;"; |
501 | 501 | |
502 | - // Customers. |
|
503 | - $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_customers ( |
|
502 | + // Customers. |
|
503 | + $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_customers ( |
|
504 | 504 | id BIGINT(20) NOT NULL AUTO_INCREMENT, |
505 | 505 | user_id BIGINT(20) NOT NULL, |
506 | 506 | email VARCHAR(100) NOT NULL, |
@@ -510,38 +510,38 @@ discard block |
||
510 | 510 | purchase_count BIGINT(20) NOT NULL DEFAULT 0, |
511 | 511 | "; |
512 | 512 | |
513 | - // Add address fields. |
|
514 | - foreach ( array_keys( getpaid_user_address_fields() ) as $field ) { |
|
515 | - // Skip id, user_id and email. |
|
516 | - if ( in_array( $field, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid' ), true ) ) { |
|
517 | - continue; |
|
518 | - } |
|
519 | - |
|
520 | - $field = sanitize_key( $field ); |
|
521 | - $length = 100; |
|
522 | - $default = ''; |
|
523 | - |
|
524 | - // Country. |
|
525 | - if ( 'country' === $field ) { |
|
526 | - $length = 2; |
|
527 | - $default = wpinv_get_default_country(); |
|
528 | - } |
|
529 | - |
|
530 | - // State. |
|
531 | - if ( 'state' === $field ) { |
|
532 | - $default = wpinv_get_default_state(); |
|
533 | - } |
|
534 | - |
|
535 | - // Phone, zip. |
|
536 | - if ( in_array( $field, array( 'phone', 'zip' ), true ) ) { |
|
537 | - $length = 20; |
|
538 | - } |
|
539 | - |
|
540 | - $schema .= "`$field` VARCHAR($length) NOT NULL DEFAULT '$default', |
|
513 | + // Add address fields. |
|
514 | + foreach ( array_keys( getpaid_user_address_fields() ) as $field ) { |
|
515 | + // Skip id, user_id and email. |
|
516 | + if ( in_array( $field, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid' ), true ) ) { |
|
517 | + continue; |
|
518 | + } |
|
519 | + |
|
520 | + $field = sanitize_key( $field ); |
|
521 | + $length = 100; |
|
522 | + $default = ''; |
|
523 | + |
|
524 | + // Country. |
|
525 | + if ( 'country' === $field ) { |
|
526 | + $length = 2; |
|
527 | + $default = wpinv_get_default_country(); |
|
528 | + } |
|
529 | + |
|
530 | + // State. |
|
531 | + if ( 'state' === $field ) { |
|
532 | + $default = wpinv_get_default_state(); |
|
533 | + } |
|
534 | + |
|
535 | + // Phone, zip. |
|
536 | + if ( in_array( $field, array( 'phone', 'zip' ), true ) ) { |
|
537 | + $length = 20; |
|
538 | + } |
|
539 | + |
|
540 | + $schema .= "`$field` VARCHAR($length) NOT NULL DEFAULT '$default', |
|
541 | 541 | "; |
542 | - } |
|
542 | + } |
|
543 | 543 | |
544 | - $schema .= "date_created DATETIME NOT NULL, |
|
544 | + $schema .= "date_created DATETIME NOT NULL, |
|
545 | 545 | date_modified DATETIME NOT NULL, |
546 | 546 | uuid VARCHAR(100) NOT NULL, |
547 | 547 | PRIMARY KEY (id), |
@@ -549,8 +549,8 @@ discard block |
||
549 | 549 | KEY email (email) |
550 | 550 | ) $charset_collate;"; |
551 | 551 | |
552 | - // Customer meta. |
|
553 | - $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_customer_meta ( |
|
552 | + // Customer meta. |
|
553 | + $schema .= "CREATE TABLE {$wpdb->prefix}getpaid_customer_meta ( |
|
554 | 554 | meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, |
555 | 555 | customer_id BIGINT(20) NOT NULL, |
556 | 556 | meta_key VARCHAR(255) NOT NULL, |
@@ -560,55 +560,55 @@ discard block |
||
560 | 560 | KEY meta_key (meta_key(191)) |
561 | 561 | ) $charset_collate;"; |
562 | 562 | |
563 | - return $schema; |
|
564 | - } |
|
565 | - |
|
566 | - /** |
|
567 | - * Checks if the db schema is up to date. |
|
568 | - * |
|
569 | - * @return bool |
|
570 | - */ |
|
571 | - public static function is_db_schema_up_to_date() { |
|
572 | - return md5( self::get_db_schema() ) === get_option( 'getpaid_db_schema' ); |
|
573 | - } |
|
574 | - |
|
575 | - /** |
|
576 | - * Set up the database tables which the plugin needs to function. |
|
577 | - */ |
|
578 | - public static function create_db_tables() { |
|
579 | - global $wpdb; |
|
580 | - |
|
581 | - $wpdb->hide_errors(); |
|
582 | - |
|
583 | - require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
584 | - |
|
585 | - $schema = self::get_db_schema(); |
|
586 | - |
|
587 | - // If invoices table exists, rename key to invoice_key. |
|
588 | - $invoices_table = "{$wpdb->prefix}getpaid_invoices"; |
|
589 | - |
|
590 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}getpaid_invoices'" ) === $invoices_table ) { |
|
591 | - $fields = $wpdb->get_results( "SHOW COLUMNS FROM {$wpdb->prefix}getpaid_invoices" ); |
|
592 | - |
|
593 | - foreach ( $fields as $field ) { |
|
594 | - if ( 'key' === $field->Field ) { |
|
595 | - $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoices CHANGE `key` `invoice_key` VARCHAR(100)" ); |
|
596 | - break; |
|
597 | - } |
|
598 | - } |
|
599 | - } |
|
600 | - |
|
601 | - dbDelta( $schema ); |
|
602 | - wp_cache_flush(); |
|
603 | - update_option( 'getpaid_db_schema', md5( $schema ) ); |
|
604 | - } |
|
605 | - |
|
606 | - /** |
|
607 | - * Creates tables if schema is not up to date. |
|
608 | - */ |
|
609 | - public static function maybe_create_db_tables() { |
|
610 | - if ( ! self::is_db_schema_up_to_date() ) { |
|
611 | - self::create_db_tables(); |
|
612 | - } |
|
613 | - } |
|
563 | + return $schema; |
|
564 | + } |
|
565 | + |
|
566 | + /** |
|
567 | + * Checks if the db schema is up to date. |
|
568 | + * |
|
569 | + * @return bool |
|
570 | + */ |
|
571 | + public static function is_db_schema_up_to_date() { |
|
572 | + return md5( self::get_db_schema() ) === get_option( 'getpaid_db_schema' ); |
|
573 | + } |
|
574 | + |
|
575 | + /** |
|
576 | + * Set up the database tables which the plugin needs to function. |
|
577 | + */ |
|
578 | + public static function create_db_tables() { |
|
579 | + global $wpdb; |
|
580 | + |
|
581 | + $wpdb->hide_errors(); |
|
582 | + |
|
583 | + require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
584 | + |
|
585 | + $schema = self::get_db_schema(); |
|
586 | + |
|
587 | + // If invoices table exists, rename key to invoice_key. |
|
588 | + $invoices_table = "{$wpdb->prefix}getpaid_invoices"; |
|
589 | + |
|
590 | + if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}getpaid_invoices'" ) === $invoices_table ) { |
|
591 | + $fields = $wpdb->get_results( "SHOW COLUMNS FROM {$wpdb->prefix}getpaid_invoices" ); |
|
592 | + |
|
593 | + foreach ( $fields as $field ) { |
|
594 | + if ( 'key' === $field->Field ) { |
|
595 | + $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoices CHANGE `key` `invoice_key` VARCHAR(100)" ); |
|
596 | + break; |
|
597 | + } |
|
598 | + } |
|
599 | + } |
|
600 | + |
|
601 | + dbDelta( $schema ); |
|
602 | + wp_cache_flush(); |
|
603 | + update_option( 'getpaid_db_schema', md5( $schema ) ); |
|
604 | + } |
|
605 | + |
|
606 | + /** |
|
607 | + * Creates tables if schema is not up to date. |
|
608 | + */ |
|
609 | + public static function maybe_create_db_tables() { |
|
610 | + if ( ! self::is_db_schema_up_to_date() ) { |
|
611 | + self::create_db_tables(); |
|
612 | + } |
|
613 | + } |
|
614 | 614 | } |
@@ -8,7 +8,7 @@ discard block |
||
8 | 8 | * @since 2.0.2 |
9 | 9 | */ |
10 | 10 | |
11 | -defined( 'ABSPATH' ) || exit; |
|
11 | +defined('ABSPATH') || exit; |
|
12 | 12 | |
13 | 13 | /** |
14 | 14 | * The main installer/updater class. |
@@ -25,10 +25,10 @@ discard block |
||
25 | 25 | * |
26 | 26 | * @param string $upgrade_from The current invoicing version. |
27 | 27 | */ |
28 | - public function upgrade_db( $upgrade_from ) { |
|
28 | + public function upgrade_db($upgrade_from) { |
|
29 | 29 | |
30 | 30 | // Save the current invoicing version. |
31 | - update_option( 'wpinv_version', WPINV_VERSION ); |
|
31 | + update_option('wpinv_version', WPINV_VERSION); |
|
32 | 32 | |
33 | 33 | // Setup the invoice Custom Post Type. |
34 | 34 | GetPaid_Post_Types::register_post_types(); |
@@ -48,13 +48,13 @@ discard block |
||
48 | 48 | // Create any missing database tables. |
49 | 49 | $method = "upgrade_from_$upgrade_from"; |
50 | 50 | |
51 | - $installed = get_option( 'gepaid_installed_on' ); |
|
51 | + $installed = get_option('gepaid_installed_on'); |
|
52 | 52 | |
53 | - if ( empty( $installed ) ) { |
|
54 | - update_option( 'gepaid_installed_on', time() ); |
|
53 | + if (empty($installed)) { |
|
54 | + update_option('gepaid_installed_on', time()); |
|
55 | 55 | } |
56 | 56 | |
57 | - if ( method_exists( $this, $method ) ) { |
|
57 | + if (method_exists($this, $method)) { |
|
58 | 58 | $this->$method(); |
59 | 59 | } |
60 | 60 | |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | public function upgrade_from_0() { |
68 | 68 | |
69 | 69 | // Save default tax rates. |
70 | - update_option( 'wpinv_tax_rates', wpinv_get_data( 'tax-rates' ) ); |
|
70 | + update_option('wpinv_tax_rates', wpinv_get_data('tax-rates')); |
|
71 | 71 | } |
72 | 72 | |
73 | 73 | /** |
@@ -78,27 +78,27 @@ discard block |
||
78 | 78 | global $wpdb; |
79 | 79 | |
80 | 80 | // Invoices. |
81 | - $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' )" ); |
|
82 | - if ( ! empty( $results ) ) { |
|
83 | - $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' )" ); |
|
81 | + $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' )"); |
|
82 | + if (!empty($results)) { |
|
83 | + $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' )"); |
|
84 | 84 | |
85 | 85 | // Clean post cache |
86 | - foreach ( $results as $row ) { |
|
87 | - clean_post_cache( $row->ID ); |
|
86 | + foreach ($results as $row) { |
|
87 | + clean_post_cache($row->ID); |
|
88 | 88 | } |
89 | 89 | } |
90 | 90 | |
91 | 91 | // Item meta key changes |
92 | 92 | $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' )"; |
93 | - $results = $wpdb->get_results( $query ); |
|
93 | + $results = $wpdb->get_results($query); |
|
94 | 94 | |
95 | - if ( ! empty( $results ) ) { |
|
96 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" ); |
|
97 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" ); |
|
98 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" ); |
|
95 | + if (!empty($results)) { |
|
96 | + $wpdb->query('UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )"); |
|
97 | + $wpdb->query('UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'"); |
|
98 | + $wpdb->query('UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'"); |
|
99 | 99 | |
100 | - foreach ( $results as $row ) { |
|
101 | - clean_post_cache( $row->post_id ); |
|
100 | + foreach ($results as $row) { |
|
101 | + clean_post_cache($row->post_id); |
|
102 | 102 | } |
103 | 103 | } |
104 | 104 | |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | * |
128 | 128 | */ |
129 | 129 | public function add_capabilities() { |
130 | - $GLOBALS['wp_roles']->add_cap( 'administrator', 'manage_invoicing' ); |
|
130 | + $GLOBALS['wp_roles']->add_cap('administrator', 'manage_invoicing'); |
|
131 | 131 | } |
132 | 132 | |
133 | 133 | /** |
@@ -142,8 +142,8 @@ discard block |
||
142 | 142 | |
143 | 143 | // Checkout page. |
144 | 144 | 'checkout_page' => array( |
145 | - 'name' => _x( 'gp-checkout', 'Page slug', 'invoicing' ), |
|
146 | - 'title' => _x( 'Checkout', 'Page title', 'invoicing' ), |
|
145 | + 'name' => _x('gp-checkout', 'Page slug', 'invoicing'), |
|
146 | + 'title' => _x('Checkout', 'Page title', 'invoicing'), |
|
147 | 147 | 'content' => ' |
148 | 148 | <!-- wp:shortcode --> |
149 | 149 | [wpinv_checkout] |
@@ -154,8 +154,8 @@ discard block |
||
154 | 154 | |
155 | 155 | // Invoice history page. |
156 | 156 | 'invoice_history_page' => array( |
157 | - 'name' => _x( 'gp-invoices', 'Page slug', 'invoicing' ), |
|
158 | - 'title' => _x( 'My Invoices', 'Page title', 'invoicing' ), |
|
157 | + 'name' => _x('gp-invoices', 'Page slug', 'invoicing'), |
|
158 | + 'title' => _x('My Invoices', 'Page title', 'invoicing'), |
|
159 | 159 | 'content' => ' |
160 | 160 | <!-- wp:shortcode --> |
161 | 161 | [wpinv_history] |
@@ -166,8 +166,8 @@ discard block |
||
166 | 166 | |
167 | 167 | // Success page content. |
168 | 168 | 'success_page' => array( |
169 | - 'name' => _x( 'gp-receipt', 'Page slug', 'invoicing' ), |
|
170 | - 'title' => _x( 'Payment Confirmation', 'Page title', 'invoicing' ), |
|
169 | + 'name' => _x('gp-receipt', 'Page slug', 'invoicing'), |
|
170 | + 'title' => _x('Payment Confirmation', 'Page title', 'invoicing'), |
|
171 | 171 | 'content' => ' |
172 | 172 | <!-- wp:shortcode --> |
173 | 173 | [wpinv_receipt] |
@@ -178,16 +178,16 @@ discard block |
||
178 | 178 | |
179 | 179 | // Failure page content. |
180 | 180 | 'failure_page' => array( |
181 | - 'name' => _x( 'gp-transaction-failed', 'Page slug', 'invoicing' ), |
|
182 | - 'title' => _x( 'Transaction Failed', 'Page title', 'invoicing' ), |
|
183 | - 'content' => __( 'Your transaction failed, please try again or contact site support.', 'invoicing' ), |
|
181 | + 'name' => _x('gp-transaction-failed', 'Page slug', 'invoicing'), |
|
182 | + 'title' => _x('Transaction Failed', 'Page title', 'invoicing'), |
|
183 | + 'content' => __('Your transaction failed, please try again or contact site support.', 'invoicing'), |
|
184 | 184 | 'parent' => 'gp-checkout', |
185 | 185 | ), |
186 | 186 | |
187 | 187 | // Subscriptions history page. |
188 | 188 | 'invoice_subscription_page' => array( |
189 | - 'name' => _x( 'gp-subscriptions', 'Page slug', 'invoicing' ), |
|
190 | - 'title' => _x( 'My Subscriptions', 'Page title', 'invoicing' ), |
|
189 | + 'name' => _x('gp-subscriptions', 'Page slug', 'invoicing'), |
|
190 | + 'title' => _x('My Subscriptions', 'Page title', 'invoicing'), |
|
191 | 191 | 'content' => ' |
192 | 192 | <!-- wp:shortcode --> |
193 | 193 | [wpinv_subscriptions] |
@@ -207,8 +207,8 @@ discard block |
||
207 | 207 | */ |
208 | 208 | public function create_pages() { |
209 | 209 | |
210 | - foreach ( self::get_pages() as $key => $page ) { |
|
211 | - wpinv_create_page( esc_sql( $page['name'] ), $key, $page['title'], $page['content'], $page['parent'] ); |
|
210 | + foreach (self::get_pages() as $key => $page) { |
|
211 | + wpinv_create_page(esc_sql($page['name']), $key, $page['title'], $page['content'], $page['parent']); |
|
212 | 212 | } |
213 | 213 | |
214 | 214 | } |
@@ -222,32 +222,32 @@ discard block |
||
222 | 222 | |
223 | 223 | $invoices_table = $wpdb->prefix . 'getpaid_invoices'; |
224 | 224 | $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items'; |
225 | - $migrated = $wpdb->get_col( "SELECT post_id FROM $invoices_table" ); |
|
225 | + $migrated = $wpdb->get_col("SELECT post_id FROM $invoices_table"); |
|
226 | 226 | $invoices = array_unique( |
227 | 227 | get_posts( |
228 | 228 | array( |
229 | - 'post_type' => array( 'wpi_invoice', 'wpi_quote' ), |
|
229 | + 'post_type' => array('wpi_invoice', 'wpi_quote'), |
|
230 | 230 | 'posts_per_page' => -1, |
231 | 231 | 'fields' => 'ids', |
232 | - 'post_status' => array_keys( get_post_stati() ), |
|
232 | + 'post_status' => array_keys(get_post_stati()), |
|
233 | 233 | 'exclude' => (array) $migrated, |
234 | 234 | ) |
235 | 235 | ) |
236 | 236 | ); |
237 | 237 | |
238 | 238 | // Abort if we do not have any invoices. |
239 | - if ( empty( $invoices ) ) { |
|
239 | + if (empty($invoices)) { |
|
240 | 240 | return; |
241 | 241 | } |
242 | 242 | |
243 | 243 | require_once WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php'; |
244 | 244 | |
245 | 245 | $invoice_rows = array(); |
246 | - foreach ( $invoices as $invoice ) { |
|
246 | + foreach ($invoices as $invoice) { |
|
247 | 247 | |
248 | - $invoice = new WPInv_Legacy_Invoice( $invoice ); |
|
248 | + $invoice = new WPInv_Legacy_Invoice($invoice); |
|
249 | 249 | |
250 | - if ( empty( $invoice->ID ) ) { |
|
250 | + if (empty($invoice->ID)) { |
|
251 | 251 | return; |
252 | 252 | } |
253 | 253 | |
@@ -255,7 +255,7 @@ discard block |
||
255 | 255 | 'post_id' => $invoice->ID, |
256 | 256 | 'number' => $invoice->get_number(), |
257 | 257 | 'key' => $invoice->get_key(), |
258 | - 'type' => str_replace( 'wpi_', '', $invoice->post_type ), |
|
258 | + 'type' => str_replace('wpi_', '', $invoice->post_type), |
|
259 | 259 | 'mode' => $invoice->mode, |
260 | 260 | 'user_ip' => $invoice->get_ip(), |
261 | 261 | 'first_name' => $invoice->get_first_name(), |
@@ -284,27 +284,27 @@ discard block |
||
284 | 284 | 'custom_meta' => $invoice->payment_meta, |
285 | 285 | ); |
286 | 286 | |
287 | - foreach ( $fields as $key => $val ) { |
|
288 | - if ( is_null( $val ) ) { |
|
287 | + foreach ($fields as $key => $val) { |
|
288 | + if (is_null($val)) { |
|
289 | 289 | $val = ''; |
290 | 290 | } |
291 | - $val = maybe_serialize( $val ); |
|
292 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
291 | + $val = maybe_serialize($val); |
|
292 | + $fields[$key] = $wpdb->prepare('%s', $val); |
|
293 | 293 | } |
294 | 294 | |
295 | - $fields = implode( ', ', $fields ); |
|
295 | + $fields = implode(', ', $fields); |
|
296 | 296 | $invoice_rows[] = "($fields)"; |
297 | 297 | |
298 | 298 | $item_rows = array(); |
299 | 299 | $item_columns = array(); |
300 | - foreach ( $invoice->get_cart_details() as $details ) { |
|
300 | + foreach ($invoice->get_cart_details() as $details) { |
|
301 | 301 | $fields = array( |
302 | 302 | 'post_id' => $invoice->ID, |
303 | 303 | 'item_id' => $details['id'], |
304 | 304 | 'item_name' => $details['name'], |
305 | - 'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'], |
|
305 | + 'item_description' => empty($details['meta']['description']) ? '' : $details['meta']['description'], |
|
306 | 306 | 'vat_rate' => $details['vat_rate'], |
307 | - 'vat_class' => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'], |
|
307 | + 'vat_class' => empty($details['vat_class']) ? '_standard' : $details['vat_class'], |
|
308 | 308 | 'tax' => $details['tax'], |
309 | 309 | 'item_price' => $details['item_price'], |
310 | 310 | 'custom_price' => $details['custom_price'], |
@@ -316,31 +316,31 @@ discard block |
||
316 | 316 | 'fees' => $details['fees'], |
317 | 317 | ); |
318 | 318 | |
319 | - $item_columns = array_keys( $fields ); |
|
319 | + $item_columns = array_keys($fields); |
|
320 | 320 | |
321 | - foreach ( $fields as $key => $val ) { |
|
322 | - if ( is_null( $val ) ) { |
|
321 | + foreach ($fields as $key => $val) { |
|
322 | + if (is_null($val)) { |
|
323 | 323 | $val = ''; |
324 | 324 | } |
325 | - $val = maybe_serialize( $val ); |
|
326 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
325 | + $val = maybe_serialize($val); |
|
326 | + $fields[$key] = $wpdb->prepare('%s', $val); |
|
327 | 327 | } |
328 | 328 | |
329 | - $fields = implode( ', ', $fields ); |
|
329 | + $fields = implode(', ', $fields); |
|
330 | 330 | $item_rows[] = "($fields)"; |
331 | 331 | } |
332 | 332 | |
333 | - $item_rows = implode( ', ', $item_rows ); |
|
334 | - $item_columns = implode( ', ', $item_columns ); |
|
335 | - $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" ); |
|
333 | + $item_rows = implode(', ', $item_rows); |
|
334 | + $item_columns = implode(', ', $item_columns); |
|
335 | + $wpdb->query("INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows"); |
|
336 | 336 | } |
337 | 337 | |
338 | - if ( empty( $invoice_rows ) ) { |
|
338 | + if (empty($invoice_rows)) { |
|
339 | 339 | return; |
340 | 340 | } |
341 | 341 | |
342 | - $invoice_rows = implode( ', ', $invoice_rows ); |
|
343 | - $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" ); |
|
342 | + $invoice_rows = implode(', ', $invoice_rows); |
|
343 | + $wpdb->query("INSERT INTO $invoices_table VALUES $invoice_rows"); |
|
344 | 344 | |
345 | 345 | } |
346 | 346 | |
@@ -352,32 +352,32 @@ discard block |
||
352 | 352 | global $wpdb; |
353 | 353 | |
354 | 354 | // Fetch post_id from $wpdb->prefix . 'getpaid_invoices' where customer_id = 0 or null. |
355 | - $invoice_ids = $wpdb->get_col( "SELECT post_id FROM {$wpdb->prefix}getpaid_invoices WHERE customer_id = 0 OR customer_id IS NULL" ); |
|
355 | + $invoice_ids = $wpdb->get_col("SELECT post_id FROM {$wpdb->prefix}getpaid_invoices WHERE customer_id = 0 OR customer_id IS NULL"); |
|
356 | 356 | |
357 | - foreach ( $invoice_ids as $invoice_id ) { |
|
358 | - $invoice = wpinv_get_invoice( $invoice_id ); |
|
357 | + foreach ($invoice_ids as $invoice_id) { |
|
358 | + $invoice = wpinv_get_invoice($invoice_id); |
|
359 | 359 | |
360 | - if ( empty( $invoice ) ) { |
|
360 | + if (empty($invoice)) { |
|
361 | 361 | continue; |
362 | 362 | } |
363 | 363 | |
364 | 364 | // Fetch customer from the user ID. |
365 | 365 | $user_id = $invoice->get_user_id(); |
366 | 366 | |
367 | - if ( empty( $user_id ) ) { |
|
367 | + if (empty($user_id)) { |
|
368 | 368 | continue; |
369 | 369 | } |
370 | 370 | |
371 | - $customer = getpaid_get_customer_by_user_id( $user_id ); |
|
371 | + $customer = getpaid_get_customer_by_user_id($user_id); |
|
372 | 372 | |
373 | 373 | // Create if not exists. |
374 | - if ( empty( $customer ) ) { |
|
375 | - $customer = new GetPaid_Customer( 0 ); |
|
376 | - $customer->clone_user( $user_id ); |
|
374 | + if (empty($customer)) { |
|
375 | + $customer = new GetPaid_Customer(0); |
|
376 | + $customer->clone_user($user_id); |
|
377 | 377 | $customer->save(); |
378 | 378 | } |
379 | 379 | |
380 | - $invoice->set_customer_id( $customer->get_id() ); |
|
380 | + $invoice->set_customer_id($customer->get_id()); |
|
381 | 381 | $invoice->save(); |
382 | 382 | } |
383 | 383 | |
@@ -390,12 +390,12 @@ discard block |
||
390 | 390 | public static function rename_gateways_label() { |
391 | 391 | global $wpdb; |
392 | 392 | |
393 | - foreach ( array_keys( wpinv_get_payment_gateways() ) as $gateway ) { |
|
393 | + foreach (array_keys(wpinv_get_payment_gateways()) as $gateway) { |
|
394 | 394 | |
395 | 395 | $wpdb->update( |
396 | 396 | $wpdb->prefix . 'getpaid_invoices', |
397 | - array( 'gateway' => $gateway ), |
|
398 | - array( 'gateway' => wpinv_get_gateway_admin_label( $gateway ) ), |
|
397 | + array('gateway' => $gateway), |
|
398 | + array('gateway' => wpinv_get_gateway_admin_label($gateway)), |
|
399 | 399 | '%s', |
400 | 400 | '%s' |
401 | 401 | ); |
@@ -511,29 +511,29 @@ discard block |
||
511 | 511 | "; |
512 | 512 | |
513 | 513 | // Add address fields. |
514 | - foreach ( array_keys( getpaid_user_address_fields() ) as $field ) { |
|
514 | + foreach (array_keys(getpaid_user_address_fields()) as $field) { |
|
515 | 515 | // Skip id, user_id and email. |
516 | - if ( in_array( $field, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid' ), true ) ) { |
|
516 | + if (in_array($field, array('id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid'), true)) { |
|
517 | 517 | continue; |
518 | 518 | } |
519 | 519 | |
520 | - $field = sanitize_key( $field ); |
|
520 | + $field = sanitize_key($field); |
|
521 | 521 | $length = 100; |
522 | 522 | $default = ''; |
523 | 523 | |
524 | 524 | // Country. |
525 | - if ( 'country' === $field ) { |
|
525 | + if ('country' === $field) { |
|
526 | 526 | $length = 2; |
527 | 527 | $default = wpinv_get_default_country(); |
528 | 528 | } |
529 | 529 | |
530 | 530 | // State. |
531 | - if ( 'state' === $field ) { |
|
531 | + if ('state' === $field) { |
|
532 | 532 | $default = wpinv_get_default_state(); |
533 | 533 | } |
534 | 534 | |
535 | 535 | // Phone, zip. |
536 | - if ( in_array( $field, array( 'phone', 'zip' ), true ) ) { |
|
536 | + if (in_array($field, array('phone', 'zip'), true)) { |
|
537 | 537 | $length = 20; |
538 | 538 | } |
539 | 539 | |
@@ -569,7 +569,7 @@ discard block |
||
569 | 569 | * @return bool |
570 | 570 | */ |
571 | 571 | public static function is_db_schema_up_to_date() { |
572 | - return md5( self::get_db_schema() ) === get_option( 'getpaid_db_schema' ); |
|
572 | + return md5(self::get_db_schema()) === get_option('getpaid_db_schema'); |
|
573 | 573 | } |
574 | 574 | |
575 | 575 | /** |
@@ -587,27 +587,27 @@ discard block |
||
587 | 587 | // If invoices table exists, rename key to invoice_key. |
588 | 588 | $invoices_table = "{$wpdb->prefix}getpaid_invoices"; |
589 | 589 | |
590 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}getpaid_invoices'" ) === $invoices_table ) { |
|
591 | - $fields = $wpdb->get_results( "SHOW COLUMNS FROM {$wpdb->prefix}getpaid_invoices" ); |
|
590 | + if ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}getpaid_invoices'") === $invoices_table) { |
|
591 | + $fields = $wpdb->get_results("SHOW COLUMNS FROM {$wpdb->prefix}getpaid_invoices"); |
|
592 | 592 | |
593 | - foreach ( $fields as $field ) { |
|
594 | - if ( 'key' === $field->Field ) { |
|
595 | - $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoices CHANGE `key` `invoice_key` VARCHAR(100)" ); |
|
593 | + foreach ($fields as $field) { |
|
594 | + if ('key' === $field->Field) { |
|
595 | + $wpdb->query("ALTER TABLE {$wpdb->prefix}getpaid_invoices CHANGE `key` `invoice_key` VARCHAR(100)"); |
|
596 | 596 | break; |
597 | 597 | } |
598 | 598 | } |
599 | 599 | } |
600 | 600 | |
601 | - dbDelta( $schema ); |
|
601 | + dbDelta($schema); |
|
602 | 602 | wp_cache_flush(); |
603 | - update_option( 'getpaid_db_schema', md5( $schema ) ); |
|
603 | + update_option('getpaid_db_schema', md5($schema)); |
|
604 | 604 | } |
605 | 605 | |
606 | 606 | /** |
607 | 607 | * Creates tables if schema is not up to date. |
608 | 608 | */ |
609 | 609 | public static function maybe_create_db_tables() { |
610 | - if ( ! self::is_db_schema_up_to_date() ) { |
|
610 | + if (!self::is_db_schema_up_to_date()) { |
|
611 | 611 | self::create_db_tables(); |
612 | 612 | } |
613 | 613 | } |
@@ -11,7 +11,7 @@ discard block |
||
11 | 11 | |
12 | 12 | // Load WP_List_Table if not loaded |
13 | 13 | if ( ! class_exists( 'WP_List_Table' ) ) { |
14 | - require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
14 | + require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
15 | 15 | } |
16 | 16 | |
17 | 17 | /** |
@@ -23,303 +23,303 @@ discard block |
||
23 | 23 | */ |
24 | 24 | class WPInv_Customers_Table extends WP_List_Table { |
25 | 25 | |
26 | - /** |
|
27 | - * @var int Number of items per page |
|
28 | - * @since 1.0.19 |
|
29 | - */ |
|
30 | - public $per_page = 25; |
|
31 | - |
|
32 | - /** |
|
33 | - * @var int Number of items |
|
34 | - * @since 1.0.19 |
|
35 | - */ |
|
36 | - public $total_count = 0; |
|
37 | - |
|
38 | - public $query; |
|
39 | - |
|
40 | - /** |
|
41 | - * Get things started |
|
42 | - * |
|
43 | - * @since 1.0.19 |
|
44 | - * @see WP_List_Table::__construct() |
|
45 | - */ |
|
46 | - public function __construct() { |
|
47 | - |
|
48 | - // Set parent defaults |
|
49 | - parent::__construct( |
|
26 | + /** |
|
27 | + * @var int Number of items per page |
|
28 | + * @since 1.0.19 |
|
29 | + */ |
|
30 | + public $per_page = 25; |
|
31 | + |
|
32 | + /** |
|
33 | + * @var int Number of items |
|
34 | + * @since 1.0.19 |
|
35 | + */ |
|
36 | + public $total_count = 0; |
|
37 | + |
|
38 | + public $query; |
|
39 | + |
|
40 | + /** |
|
41 | + * Get things started |
|
42 | + * |
|
43 | + * @since 1.0.19 |
|
44 | + * @see WP_List_Table::__construct() |
|
45 | + */ |
|
46 | + public function __construct() { |
|
47 | + |
|
48 | + // Set parent defaults |
|
49 | + parent::__construct( |
|
50 | 50 | array( |
51 | - 'singular' => 'id', |
|
52 | - 'plural' => 'ids', |
|
53 | - 'ajax' => false, |
|
51 | + 'singular' => 'id', |
|
52 | + 'plural' => 'ids', |
|
53 | + 'ajax' => false, |
|
54 | 54 | ) |
55 | 55 | ); |
56 | 56 | |
57 | - } |
|
58 | - |
|
59 | - /** |
|
60 | - * Gets the name of the primary column. |
|
61 | - * |
|
62 | - * @since 1.0.19 |
|
63 | - * @access protected |
|
64 | - * |
|
65 | - * @return string Name of the primary column. |
|
66 | - */ |
|
67 | - protected function get_primary_column_name() { |
|
68 | - return 'customer'; |
|
69 | - } |
|
70 | - |
|
71 | - /** |
|
72 | - * This function renders most of the columns in the list table. |
|
73 | - * |
|
74 | - * @since 1.0.19 |
|
75 | - * |
|
76 | - * @param GetPaid_Customer $customer |
|
77 | - * @param string $column_name The name of the column |
|
78 | - * |
|
79 | - * @return string Column Name |
|
80 | - */ |
|
81 | - public function column_default( $customer, $column_name ) { |
|
82 | - $value = esc_html( $customer->get( $column_name ) ); |
|
83 | - return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $customer ); |
|
84 | - } |
|
85 | - |
|
86 | - /** |
|
87 | - * Displays the country column. |
|
88 | - * |
|
89 | - * @since 1.0.19 |
|
90 | - * |
|
91 | - * @param GetPaid_Customer $customer |
|
92 | - * |
|
93 | - * @return string Column Name |
|
94 | - */ |
|
95 | - public function column_country( $customer ) { |
|
96 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
97 | - if ( $country ) { |
|
98 | - $country = wpinv_country_name( $country ); |
|
99 | - } |
|
100 | - return esc_html( $country ); |
|
101 | - } |
|
102 | - |
|
103 | - /** |
|
104 | - * Displays the state column. |
|
105 | - * |
|
106 | - * @since 1.0.19 |
|
107 | - * |
|
108 | - * @param GetPaid_Customer $customer |
|
109 | - * |
|
110 | - * @return string Column Name |
|
111 | - */ |
|
112 | - public function column_state( $customer ) { |
|
113 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
114 | - $state = $customer->get( 'state' ); |
|
115 | - if ( $state ) { |
|
116 | - $state = wpinv_state_name( $state, $country ); |
|
117 | - } |
|
118 | - |
|
119 | - return esc_html( $state ); |
|
120 | - } |
|
121 | - |
|
122 | - /** |
|
123 | - * Displays the signup column. |
|
124 | - * |
|
125 | - * @since 1.0.19 |
|
126 | - * |
|
127 | - * @param GetPaid_Customer $customer |
|
128 | - * |
|
129 | - * @return string Column Name |
|
130 | - */ |
|
131 | - public function column_date_created( $customer ) { |
|
132 | - return getpaid_format_date_value( $customer->get( 'date_created' ) ); |
|
133 | - } |
|
134 | - |
|
135 | - /** |
|
136 | - * Displays the total spent column. |
|
137 | - * |
|
138 | - * @since 1.0.19 |
|
139 | - * |
|
140 | - * @param GetPaid_Customer $customer |
|
141 | - * |
|
142 | - * @return string Column Name |
|
143 | - */ |
|
144 | - public function column_purchase_value( $customer ) { |
|
145 | - return wpinv_price( (float) $customer->get( 'purchase_value' ) ); |
|
146 | - } |
|
147 | - |
|
148 | - /** |
|
149 | - * Displays the total spent column. |
|
150 | - * |
|
151 | - * @since 1.0.19 |
|
152 | - * |
|
153 | - * @param GetPaid_Customer $customer |
|
154 | - * |
|
155 | - * @return string Column Name |
|
156 | - */ |
|
157 | - public function column_purchase_count( $customer ) { |
|
158 | - $value = $customer->get( 'purchase_count' ); |
|
159 | - $url = $customer->get( 'user_id' ) ? add_query_arg( array( 'post_type' => 'wpi_invoice', 'author' => $customer->get( 'user_id' ), ), admin_url( 'edit.php' ) ) : ''; |
|
160 | - |
|
161 | - return ( empty( $value ) || empty( $url ) ) ? (int) $value : '<a href="' . esc_url( $url ) . '">' . absint( $value ) . '</a>'; |
|
162 | - |
|
163 | - } |
|
164 | - |
|
165 | - /** |
|
166 | - * Displays the customers name |
|
167 | - * |
|
168 | - * @param GetPaid_Customer $customer customer. |
|
169 | - * @return string |
|
170 | - */ |
|
171 | - public function column_customer( $customer ) { |
|
172 | - |
|
173 | - $first_name = $customer->get( 'first_name' ); |
|
174 | - $last_name = $customer->get( 'last_name' ); |
|
175 | - $email = $customer->get( 'email' ); |
|
176 | - $avatar = get_avatar( $customer->get( 'user_id' ) ? $customer->get( 'user_id' ) : $email, 32 ); |
|
177 | - |
|
178 | - // Customer view URL. |
|
179 | - $view_url = $customer->get( 'user_id' ) ? esc_url( add_query_arg( 'user_id', $customer->get( 'user_id' ), admin_url( 'user-edit.php' ) ) ) : false; |
|
180 | - $row_actions = $view_url ? $this->row_actions( |
|
181 | - array( |
|
182 | - 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
183 | - ) |
|
184 | - ) : ''; |
|
185 | - |
|
186 | - // Customer's name. |
|
187 | - $name = esc_html( trim( "$first_name $last_name" ) ); |
|
188 | - |
|
189 | - if ( ! empty( $name ) ) { |
|
190 | - $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
191 | - } |
|
192 | - |
|
193 | - $email = "<div class='row-title'><a href='mailto:$email'>$email</a></div>"; |
|
194 | - |
|
195 | - return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
196 | - |
|
197 | - } |
|
198 | - |
|
199 | - /** |
|
200 | - * Retrieve the current page number |
|
201 | - * |
|
202 | - * @since 1.0.19 |
|
203 | - * @return int Current page number |
|
204 | - */ |
|
205 | - public function get_paged() { |
|
206 | - return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
207 | - } |
|
208 | - |
|
209 | - /** |
|
210 | - * Returns bulk actions. |
|
211 | - * |
|
212 | - * @since 1.0.19 |
|
213 | - * @return void |
|
214 | - */ |
|
215 | - public function bulk_actions( $which = '' ) { |
|
216 | - return array(); |
|
217 | - } |
|
218 | - |
|
219 | - /** |
|
220 | - * Prepares the display query |
|
221 | - */ |
|
222 | - public function prepare_query() { |
|
223 | - |
|
224 | - // Prepare query args. |
|
225 | - $query = array( |
|
226 | - 'number' => $this->per_page, |
|
227 | - 'paged' => $this->get_paged(), |
|
228 | - ); |
|
229 | - |
|
230 | - foreach ( array( 'orderby', 'order', 's' ) as $field ) { |
|
231 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
232 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
233 | - } |
|
234 | - } |
|
235 | - |
|
236 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
237 | - |
|
238 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
239 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
240 | - } |
|
241 | - |
|
242 | - // Min max. |
|
243 | - if ( '%f' === $type || '%d' === $type ) { |
|
244 | - |
|
245 | - if ( isset( $_GET[ $field . '_min' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
246 | - $query[ $field . '_min' ] = floatval( $_GET[ $field . '_min' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
247 | - } |
|
248 | - |
|
249 | - if ( isset( $_GET[ $field . '_max' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
250 | - $query[ $field . '_max' ] = floatval( $_GET[ $field . '_max' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
251 | - } |
|
252 | - } |
|
253 | - } |
|
254 | - |
|
255 | - // Prepare class properties. |
|
256 | - $this->query = getpaid_get_customers( $query, 'query' ); |
|
257 | - $this->total_count = $this->query->get_total(); |
|
258 | - $this->items = $this->query->get_results(); |
|
259 | - } |
|
260 | - |
|
261 | - /** |
|
262 | - * Setup the final data for the table |
|
263 | - * |
|
264 | - */ |
|
265 | - public function prepare_items() { |
|
266 | - |
|
267 | - $columns = $this->get_columns(); |
|
268 | - $hidden = array(); |
|
269 | - $sortable = $this->get_sortable_columns(); |
|
270 | - $this->prepare_query(); |
|
271 | - |
|
272 | - $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
273 | - |
|
274 | - $this->set_pagination_args( |
|
275 | - array( |
|
276 | - 'total_items' => $this->total_count, |
|
277 | - 'per_page' => $this->per_page, |
|
278 | - 'total_pages' => ceil( $this->total_count / $this->per_page ), |
|
279 | - ) |
|
280 | - ); |
|
281 | - } |
|
282 | - |
|
283 | - /** |
|
284 | - * Sortable table columns. |
|
285 | - * |
|
286 | - * @return array |
|
287 | - */ |
|
288 | - public function get_sortable_columns() { |
|
289 | - $sortable = array( |
|
290 | - 'customer' => array( 'first_name', true ), |
|
291 | - ); |
|
292 | - |
|
293 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
294 | - $sortable[ $field ] = array( $field, true ); |
|
295 | - } |
|
296 | - |
|
297 | - return apply_filters( 'manage_getpaid_customers_sortable_table_columns', $sortable ); |
|
298 | - } |
|
299 | - |
|
300 | - /** |
|
301 | - * Table columns |
|
302 | - * |
|
303 | - * @return array |
|
304 | - */ |
|
305 | - public function get_columns() { |
|
306 | - $columns = array( |
|
307 | - 'customer' => __( 'Customer', 'invoicing' ), |
|
308 | - ); |
|
309 | - |
|
310 | - // Add address fields. |
|
311 | - foreach ( getpaid_user_address_fields() as $key => $value ) { |
|
312 | - |
|
313 | - // Skip id, user_id and email. |
|
314 | - if ( ! in_array( $key, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name' ), true ) ) { |
|
315 | - $columns[ $key ] = $value; |
|
316 | - } |
|
317 | - } |
|
318 | - |
|
319 | - $columns['purchase_value'] = __( 'Total Spend', 'invoicing' ); |
|
320 | - $columns['purchase_count'] = __( 'Invoices', 'invoicing' ); |
|
321 | - $columns['date_created'] = __( 'Date created', 'invoicing' ); |
|
322 | - |
|
323 | - return apply_filters( 'manage_getpaid_customers_table_columns', $columns ); |
|
324 | - } |
|
57 | + } |
|
58 | + |
|
59 | + /** |
|
60 | + * Gets the name of the primary column. |
|
61 | + * |
|
62 | + * @since 1.0.19 |
|
63 | + * @access protected |
|
64 | + * |
|
65 | + * @return string Name of the primary column. |
|
66 | + */ |
|
67 | + protected function get_primary_column_name() { |
|
68 | + return 'customer'; |
|
69 | + } |
|
70 | + |
|
71 | + /** |
|
72 | + * This function renders most of the columns in the list table. |
|
73 | + * |
|
74 | + * @since 1.0.19 |
|
75 | + * |
|
76 | + * @param GetPaid_Customer $customer |
|
77 | + * @param string $column_name The name of the column |
|
78 | + * |
|
79 | + * @return string Column Name |
|
80 | + */ |
|
81 | + public function column_default( $customer, $column_name ) { |
|
82 | + $value = esc_html( $customer->get( $column_name ) ); |
|
83 | + return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $customer ); |
|
84 | + } |
|
85 | + |
|
86 | + /** |
|
87 | + * Displays the country column. |
|
88 | + * |
|
89 | + * @since 1.0.19 |
|
90 | + * |
|
91 | + * @param GetPaid_Customer $customer |
|
92 | + * |
|
93 | + * @return string Column Name |
|
94 | + */ |
|
95 | + public function column_country( $customer ) { |
|
96 | + $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
97 | + if ( $country ) { |
|
98 | + $country = wpinv_country_name( $country ); |
|
99 | + } |
|
100 | + return esc_html( $country ); |
|
101 | + } |
|
102 | + |
|
103 | + /** |
|
104 | + * Displays the state column. |
|
105 | + * |
|
106 | + * @since 1.0.19 |
|
107 | + * |
|
108 | + * @param GetPaid_Customer $customer |
|
109 | + * |
|
110 | + * @return string Column Name |
|
111 | + */ |
|
112 | + public function column_state( $customer ) { |
|
113 | + $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
114 | + $state = $customer->get( 'state' ); |
|
115 | + if ( $state ) { |
|
116 | + $state = wpinv_state_name( $state, $country ); |
|
117 | + } |
|
118 | + |
|
119 | + return esc_html( $state ); |
|
120 | + } |
|
121 | + |
|
122 | + /** |
|
123 | + * Displays the signup column. |
|
124 | + * |
|
125 | + * @since 1.0.19 |
|
126 | + * |
|
127 | + * @param GetPaid_Customer $customer |
|
128 | + * |
|
129 | + * @return string Column Name |
|
130 | + */ |
|
131 | + public function column_date_created( $customer ) { |
|
132 | + return getpaid_format_date_value( $customer->get( 'date_created' ) ); |
|
133 | + } |
|
134 | + |
|
135 | + /** |
|
136 | + * Displays the total spent column. |
|
137 | + * |
|
138 | + * @since 1.0.19 |
|
139 | + * |
|
140 | + * @param GetPaid_Customer $customer |
|
141 | + * |
|
142 | + * @return string Column Name |
|
143 | + */ |
|
144 | + public function column_purchase_value( $customer ) { |
|
145 | + return wpinv_price( (float) $customer->get( 'purchase_value' ) ); |
|
146 | + } |
|
147 | + |
|
148 | + /** |
|
149 | + * Displays the total spent column. |
|
150 | + * |
|
151 | + * @since 1.0.19 |
|
152 | + * |
|
153 | + * @param GetPaid_Customer $customer |
|
154 | + * |
|
155 | + * @return string Column Name |
|
156 | + */ |
|
157 | + public function column_purchase_count( $customer ) { |
|
158 | + $value = $customer->get( 'purchase_count' ); |
|
159 | + $url = $customer->get( 'user_id' ) ? add_query_arg( array( 'post_type' => 'wpi_invoice', 'author' => $customer->get( 'user_id' ), ), admin_url( 'edit.php' ) ) : ''; |
|
160 | + |
|
161 | + return ( empty( $value ) || empty( $url ) ) ? (int) $value : '<a href="' . esc_url( $url ) . '">' . absint( $value ) . '</a>'; |
|
162 | + |
|
163 | + } |
|
164 | + |
|
165 | + /** |
|
166 | + * Displays the customers name |
|
167 | + * |
|
168 | + * @param GetPaid_Customer $customer customer. |
|
169 | + * @return string |
|
170 | + */ |
|
171 | + public function column_customer( $customer ) { |
|
172 | + |
|
173 | + $first_name = $customer->get( 'first_name' ); |
|
174 | + $last_name = $customer->get( 'last_name' ); |
|
175 | + $email = $customer->get( 'email' ); |
|
176 | + $avatar = get_avatar( $customer->get( 'user_id' ) ? $customer->get( 'user_id' ) : $email, 32 ); |
|
177 | + |
|
178 | + // Customer view URL. |
|
179 | + $view_url = $customer->get( 'user_id' ) ? esc_url( add_query_arg( 'user_id', $customer->get( 'user_id' ), admin_url( 'user-edit.php' ) ) ) : false; |
|
180 | + $row_actions = $view_url ? $this->row_actions( |
|
181 | + array( |
|
182 | + 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
183 | + ) |
|
184 | + ) : ''; |
|
185 | + |
|
186 | + // Customer's name. |
|
187 | + $name = esc_html( trim( "$first_name $last_name" ) ); |
|
188 | + |
|
189 | + if ( ! empty( $name ) ) { |
|
190 | + $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
191 | + } |
|
192 | + |
|
193 | + $email = "<div class='row-title'><a href='mailto:$email'>$email</a></div>"; |
|
194 | + |
|
195 | + return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
196 | + |
|
197 | + } |
|
198 | + |
|
199 | + /** |
|
200 | + * Retrieve the current page number |
|
201 | + * |
|
202 | + * @since 1.0.19 |
|
203 | + * @return int Current page number |
|
204 | + */ |
|
205 | + public function get_paged() { |
|
206 | + return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
207 | + } |
|
208 | + |
|
209 | + /** |
|
210 | + * Returns bulk actions. |
|
211 | + * |
|
212 | + * @since 1.0.19 |
|
213 | + * @return void |
|
214 | + */ |
|
215 | + public function bulk_actions( $which = '' ) { |
|
216 | + return array(); |
|
217 | + } |
|
218 | + |
|
219 | + /** |
|
220 | + * Prepares the display query |
|
221 | + */ |
|
222 | + public function prepare_query() { |
|
223 | + |
|
224 | + // Prepare query args. |
|
225 | + $query = array( |
|
226 | + 'number' => $this->per_page, |
|
227 | + 'paged' => $this->get_paged(), |
|
228 | + ); |
|
229 | + |
|
230 | + foreach ( array( 'orderby', 'order', 's' ) as $field ) { |
|
231 | + if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
232 | + $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
233 | + } |
|
234 | + } |
|
235 | + |
|
236 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
237 | + |
|
238 | + if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
239 | + $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
240 | + } |
|
241 | + |
|
242 | + // Min max. |
|
243 | + if ( '%f' === $type || '%d' === $type ) { |
|
244 | + |
|
245 | + if ( isset( $_GET[ $field . '_min' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
246 | + $query[ $field . '_min' ] = floatval( $_GET[ $field . '_min' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
247 | + } |
|
248 | + |
|
249 | + if ( isset( $_GET[ $field . '_max' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
250 | + $query[ $field . '_max' ] = floatval( $_GET[ $field . '_max' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
251 | + } |
|
252 | + } |
|
253 | + } |
|
254 | + |
|
255 | + // Prepare class properties. |
|
256 | + $this->query = getpaid_get_customers( $query, 'query' ); |
|
257 | + $this->total_count = $this->query->get_total(); |
|
258 | + $this->items = $this->query->get_results(); |
|
259 | + } |
|
260 | + |
|
261 | + /** |
|
262 | + * Setup the final data for the table |
|
263 | + * |
|
264 | + */ |
|
265 | + public function prepare_items() { |
|
266 | + |
|
267 | + $columns = $this->get_columns(); |
|
268 | + $hidden = array(); |
|
269 | + $sortable = $this->get_sortable_columns(); |
|
270 | + $this->prepare_query(); |
|
271 | + |
|
272 | + $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
273 | + |
|
274 | + $this->set_pagination_args( |
|
275 | + array( |
|
276 | + 'total_items' => $this->total_count, |
|
277 | + 'per_page' => $this->per_page, |
|
278 | + 'total_pages' => ceil( $this->total_count / $this->per_page ), |
|
279 | + ) |
|
280 | + ); |
|
281 | + } |
|
282 | + |
|
283 | + /** |
|
284 | + * Sortable table columns. |
|
285 | + * |
|
286 | + * @return array |
|
287 | + */ |
|
288 | + public function get_sortable_columns() { |
|
289 | + $sortable = array( |
|
290 | + 'customer' => array( 'first_name', true ), |
|
291 | + ); |
|
292 | + |
|
293 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
294 | + $sortable[ $field ] = array( $field, true ); |
|
295 | + } |
|
296 | + |
|
297 | + return apply_filters( 'manage_getpaid_customers_sortable_table_columns', $sortable ); |
|
298 | + } |
|
299 | + |
|
300 | + /** |
|
301 | + * Table columns |
|
302 | + * |
|
303 | + * @return array |
|
304 | + */ |
|
305 | + public function get_columns() { |
|
306 | + $columns = array( |
|
307 | + 'customer' => __( 'Customer', 'invoicing' ), |
|
308 | + ); |
|
309 | + |
|
310 | + // Add address fields. |
|
311 | + foreach ( getpaid_user_address_fields() as $key => $value ) { |
|
312 | + |
|
313 | + // Skip id, user_id and email. |
|
314 | + if ( ! in_array( $key, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name' ), true ) ) { |
|
315 | + $columns[ $key ] = $value; |
|
316 | + } |
|
317 | + } |
|
318 | + |
|
319 | + $columns['purchase_value'] = __( 'Total Spend', 'invoicing' ); |
|
320 | + $columns['purchase_count'] = __( 'Invoices', 'invoicing' ); |
|
321 | + $columns['date_created'] = __( 'Date created', 'invoicing' ); |
|
322 | + |
|
323 | + return apply_filters( 'manage_getpaid_customers_table_columns', $columns ); |
|
324 | + } |
|
325 | 325 | } |
@@ -5,12 +5,12 @@ discard block |
||
5 | 5 | */ |
6 | 6 | |
7 | 7 | // Exit if accessed directly |
8 | -if ( ! defined( 'ABSPATH' ) ) { |
|
8 | +if (!defined('ABSPATH')) { |
|
9 | 9 | exit; |
10 | 10 | } |
11 | 11 | |
12 | 12 | // Load WP_List_Table if not loaded |
13 | -if ( ! class_exists( 'WP_List_Table' ) ) { |
|
13 | +if (!class_exists('WP_List_Table')) { |
|
14 | 14 | require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
15 | 15 | } |
16 | 16 | |
@@ -78,9 +78,9 @@ discard block |
||
78 | 78 | * |
79 | 79 | * @return string Column Name |
80 | 80 | */ |
81 | - public function column_default( $customer, $column_name ) { |
|
82 | - $value = esc_html( $customer->get( $column_name ) ); |
|
83 | - return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $customer ); |
|
81 | + public function column_default($customer, $column_name) { |
|
82 | + $value = esc_html($customer->get($column_name)); |
|
83 | + return apply_filters('wpinv_customers_table_column' . $column_name, $value, $customer); |
|
84 | 84 | } |
85 | 85 | |
86 | 86 | /** |
@@ -92,12 +92,12 @@ discard block |
||
92 | 92 | * |
93 | 93 | * @return string Column Name |
94 | 94 | */ |
95 | - public function column_country( $customer ) { |
|
96 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
97 | - if ( $country ) { |
|
98 | - $country = wpinv_country_name( $country ); |
|
95 | + public function column_country($customer) { |
|
96 | + $country = wpinv_sanitize_country($customer->get('country')); |
|
97 | + if ($country) { |
|
98 | + $country = wpinv_country_name($country); |
|
99 | 99 | } |
100 | - return esc_html( $country ); |
|
100 | + return esc_html($country); |
|
101 | 101 | } |
102 | 102 | |
103 | 103 | /** |
@@ -109,14 +109,14 @@ discard block |
||
109 | 109 | * |
110 | 110 | * @return string Column Name |
111 | 111 | */ |
112 | - public function column_state( $customer ) { |
|
113 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
114 | - $state = $customer->get( 'state' ); |
|
115 | - if ( $state ) { |
|
116 | - $state = wpinv_state_name( $state, $country ); |
|
112 | + public function column_state($customer) { |
|
113 | + $country = wpinv_sanitize_country($customer->get('country')); |
|
114 | + $state = $customer->get('state'); |
|
115 | + if ($state) { |
|
116 | + $state = wpinv_state_name($state, $country); |
|
117 | 117 | } |
118 | 118 | |
119 | - return esc_html( $state ); |
|
119 | + return esc_html($state); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | /** |
@@ -128,8 +128,8 @@ discard block |
||
128 | 128 | * |
129 | 129 | * @return string Column Name |
130 | 130 | */ |
131 | - public function column_date_created( $customer ) { |
|
132 | - return getpaid_format_date_value( $customer->get( 'date_created' ) ); |
|
131 | + public function column_date_created($customer) { |
|
132 | + return getpaid_format_date_value($customer->get('date_created')); |
|
133 | 133 | } |
134 | 134 | |
135 | 135 | /** |
@@ -141,8 +141,8 @@ discard block |
||
141 | 141 | * |
142 | 142 | * @return string Column Name |
143 | 143 | */ |
144 | - public function column_purchase_value( $customer ) { |
|
145 | - return wpinv_price( (float) $customer->get( 'purchase_value' ) ); |
|
144 | + public function column_purchase_value($customer) { |
|
145 | + return wpinv_price((float) $customer->get('purchase_value')); |
|
146 | 146 | } |
147 | 147 | |
148 | 148 | /** |
@@ -154,11 +154,11 @@ discard block |
||
154 | 154 | * |
155 | 155 | * @return string Column Name |
156 | 156 | */ |
157 | - public function column_purchase_count( $customer ) { |
|
158 | - $value = $customer->get( 'purchase_count' ); |
|
159 | - $url = $customer->get( 'user_id' ) ? add_query_arg( array( 'post_type' => 'wpi_invoice', 'author' => $customer->get( 'user_id' ), ), admin_url( 'edit.php' ) ) : ''; |
|
157 | + public function column_purchase_count($customer) { |
|
158 | + $value = $customer->get('purchase_count'); |
|
159 | + $url = $customer->get('user_id') ? add_query_arg(array('post_type' => 'wpi_invoice', 'author' => $customer->get('user_id'),), admin_url('edit.php')) : ''; |
|
160 | 160 | |
161 | - return ( empty( $value ) || empty( $url ) ) ? (int) $value : '<a href="' . esc_url( $url ) . '">' . absint( $value ) . '</a>'; |
|
161 | + return (empty($value) || empty($url)) ? (int) $value : '<a href="' . esc_url($url) . '">' . absint($value) . '</a>'; |
|
162 | 162 | |
163 | 163 | } |
164 | 164 | |
@@ -168,25 +168,25 @@ discard block |
||
168 | 168 | * @param GetPaid_Customer $customer customer. |
169 | 169 | * @return string |
170 | 170 | */ |
171 | - public function column_customer( $customer ) { |
|
171 | + public function column_customer($customer) { |
|
172 | 172 | |
173 | - $first_name = $customer->get( 'first_name' ); |
|
174 | - $last_name = $customer->get( 'last_name' ); |
|
175 | - $email = $customer->get( 'email' ); |
|
176 | - $avatar = get_avatar( $customer->get( 'user_id' ) ? $customer->get( 'user_id' ) : $email, 32 ); |
|
173 | + $first_name = $customer->get('first_name'); |
|
174 | + $last_name = $customer->get('last_name'); |
|
175 | + $email = $customer->get('email'); |
|
176 | + $avatar = get_avatar($customer->get('user_id') ? $customer->get('user_id') : $email, 32); |
|
177 | 177 | |
178 | 178 | // Customer view URL. |
179 | - $view_url = $customer->get( 'user_id' ) ? esc_url( add_query_arg( 'user_id', $customer->get( 'user_id' ), admin_url( 'user-edit.php' ) ) ) : false; |
|
179 | + $view_url = $customer->get('user_id') ? esc_url(add_query_arg('user_id', $customer->get('user_id'), admin_url('user-edit.php'))) : false; |
|
180 | 180 | $row_actions = $view_url ? $this->row_actions( |
181 | 181 | array( |
182 | - 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
182 | + 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __('Edit Details', 'invoicing') . '</a>', |
|
183 | 183 | ) |
184 | 184 | ) : ''; |
185 | 185 | |
186 | 186 | // Customer's name. |
187 | - $name = esc_html( trim( "$first_name $last_name" ) ); |
|
187 | + $name = esc_html(trim("$first_name $last_name")); |
|
188 | 188 | |
189 | - if ( ! empty( $name ) ) { |
|
189 | + if (!empty($name)) { |
|
190 | 190 | $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
191 | 191 | } |
192 | 192 | |
@@ -203,7 +203,7 @@ discard block |
||
203 | 203 | * @return int Current page number |
204 | 204 | */ |
205 | 205 | public function get_paged() { |
206 | - return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
206 | + return isset($_GET['paged']) ? absint($_GET['paged']) : 1; |
|
207 | 207 | } |
208 | 208 | |
209 | 209 | /** |
@@ -212,7 +212,7 @@ discard block |
||
212 | 212 | * @since 1.0.19 |
213 | 213 | * @return void |
214 | 214 | */ |
215 | - public function bulk_actions( $which = '' ) { |
|
215 | + public function bulk_actions($which = '') { |
|
216 | 216 | return array(); |
217 | 217 | } |
218 | 218 | |
@@ -227,33 +227,33 @@ discard block |
||
227 | 227 | 'paged' => $this->get_paged(), |
228 | 228 | ); |
229 | 229 | |
230 | - foreach ( array( 'orderby', 'order', 's' ) as $field ) { |
|
231 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
232 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
230 | + foreach (array('orderby', 'order', 's') as $field) { |
|
231 | + if (isset($_GET[$field])) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
232 | + $query[$field] = wpinv_clean(rawurlencode_deep($_GET[$field])); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
233 | 233 | } |
234 | 234 | } |
235 | 235 | |
236 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
236 | + foreach (GetPaid_Customer_Data_Store::get_database_fields() as $field => $type) { |
|
237 | 237 | |
238 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
239 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
238 | + if (isset($_GET[$field])) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
239 | + $query[$field] = wpinv_clean(rawurlencode_deep($_GET[$field])); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
240 | 240 | } |
241 | 241 | |
242 | 242 | // Min max. |
243 | - if ( '%f' === $type || '%d' === $type ) { |
|
243 | + if ('%f' === $type || '%d' === $type) { |
|
244 | 244 | |
245 | - if ( isset( $_GET[ $field . '_min' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
246 | - $query[ $field . '_min' ] = floatval( $_GET[ $field . '_min' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
245 | + if (isset($_GET[$field . '_min'])) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
246 | + $query[$field . '_min'] = floatval($_GET[$field . '_min']); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
247 | 247 | } |
248 | 248 | |
249 | - if ( isset( $_GET[ $field . '_max' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
250 | - $query[ $field . '_max' ] = floatval( $_GET[ $field . '_max' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
249 | + if (isset($_GET[$field . '_max'])) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
250 | + $query[$field . '_max'] = floatval($_GET[$field . '_max']); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
251 | 251 | } |
252 | 252 | } |
253 | 253 | } |
254 | 254 | |
255 | 255 | // Prepare class properties. |
256 | - $this->query = getpaid_get_customers( $query, 'query' ); |
|
256 | + $this->query = getpaid_get_customers($query, 'query'); |
|
257 | 257 | $this->total_count = $this->query->get_total(); |
258 | 258 | $this->items = $this->query->get_results(); |
259 | 259 | } |
@@ -269,13 +269,13 @@ discard block |
||
269 | 269 | $sortable = $this->get_sortable_columns(); |
270 | 270 | $this->prepare_query(); |
271 | 271 | |
272 | - $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
272 | + $this->_column_headers = array($columns, $hidden, $sortable); |
|
273 | 273 | |
274 | 274 | $this->set_pagination_args( |
275 | 275 | array( |
276 | 276 | 'total_items' => $this->total_count, |
277 | 277 | 'per_page' => $this->per_page, |
278 | - 'total_pages' => ceil( $this->total_count / $this->per_page ), |
|
278 | + 'total_pages' => ceil($this->total_count / $this->per_page), |
|
279 | 279 | ) |
280 | 280 | ); |
281 | 281 | } |
@@ -287,14 +287,14 @@ discard block |
||
287 | 287 | */ |
288 | 288 | public function get_sortable_columns() { |
289 | 289 | $sortable = array( |
290 | - 'customer' => array( 'first_name', true ), |
|
290 | + 'customer' => array('first_name', true), |
|
291 | 291 | ); |
292 | 292 | |
293 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
294 | - $sortable[ $field ] = array( $field, true ); |
|
293 | + foreach (GetPaid_Customer_Data_Store::get_database_fields() as $field => $type) { |
|
294 | + $sortable[$field] = array($field, true); |
|
295 | 295 | } |
296 | 296 | |
297 | - return apply_filters( 'manage_getpaid_customers_sortable_table_columns', $sortable ); |
|
297 | + return apply_filters('manage_getpaid_customers_sortable_table_columns', $sortable); |
|
298 | 298 | } |
299 | 299 | |
300 | 300 | /** |
@@ -304,22 +304,22 @@ discard block |
||
304 | 304 | */ |
305 | 305 | public function get_columns() { |
306 | 306 | $columns = array( |
307 | - 'customer' => __( 'Customer', 'invoicing' ), |
|
307 | + 'customer' => __('Customer', 'invoicing'), |
|
308 | 308 | ); |
309 | 309 | |
310 | 310 | // Add address fields. |
311 | - foreach ( getpaid_user_address_fields() as $key => $value ) { |
|
311 | + foreach (getpaid_user_address_fields() as $key => $value) { |
|
312 | 312 | |
313 | 313 | // Skip id, user_id and email. |
314 | - if ( ! in_array( $key, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name' ), true ) ) { |
|
315 | - $columns[ $key ] = $value; |
|
314 | + if (!in_array($key, array('id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name'), true)) { |
|
315 | + $columns[$key] = $value; |
|
316 | 316 | } |
317 | 317 | } |
318 | 318 | |
319 | - $columns['purchase_value'] = __( 'Total Spend', 'invoicing' ); |
|
320 | - $columns['purchase_count'] = __( 'Invoices', 'invoicing' ); |
|
321 | - $columns['date_created'] = __( 'Date created', 'invoicing' ); |
|
319 | + $columns['purchase_value'] = __('Total Spend', 'invoicing'); |
|
320 | + $columns['purchase_count'] = __('Invoices', 'invoicing'); |
|
321 | + $columns['date_created'] = __('Date created', 'invoicing'); |
|
322 | 322 | |
323 | - return apply_filters( 'manage_getpaid_customers_table_columns', $columns ); |
|
323 | + return apply_filters('manage_getpaid_customers_table_columns', $columns); |
|
324 | 324 | } |
325 | 325 | } |
@@ -19,16 +19,16 @@ discard block |
||
19 | 19 | |
20 | 20 | // Define constants. |
21 | 21 | if ( ! defined( 'WPINV_PLUGIN_FILE' ) ) { |
22 | - define( 'WPINV_PLUGIN_FILE', __FILE__ ); |
|
22 | + define( 'WPINV_PLUGIN_FILE', __FILE__ ); |
|
23 | 23 | } |
24 | 24 | |
25 | 25 | if ( ! defined( 'WPINV_VERSION' ) ) { |
26 | - define( 'WPINV_VERSION', '2.8.2' ); |
|
26 | + define( 'WPINV_VERSION', '2.8.2' ); |
|
27 | 27 | } |
28 | 28 | |
29 | 29 | // Include the main Invoicing class. |
30 | 30 | if ( ! class_exists( 'WPInv_Plugin', false ) ) { |
31 | - require_once plugin_dir_path( WPINV_PLUGIN_FILE ) . 'includes/class-wpinv.php'; |
|
31 | + require_once plugin_dir_path( WPINV_PLUGIN_FILE ) . 'includes/class-wpinv.php'; |
|
32 | 32 | } |
33 | 33 | |
34 | 34 | /** |
@@ -43,7 +43,7 @@ discard block |
||
43 | 43 | $GLOBALS['invoicing'] = new WPInv_Plugin(); |
44 | 44 | } |
45 | 45 | |
46 | - return $GLOBALS['invoicing']; |
|
46 | + return $GLOBALS['invoicing']; |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | /** |
@@ -15,20 +15,20 @@ discard block |
||
15 | 15 | * @package GetPaid |
16 | 16 | */ |
17 | 17 | |
18 | -defined( 'ABSPATH' ) || exit; |
|
18 | +defined('ABSPATH') || exit; |
|
19 | 19 | |
20 | 20 | // Define constants. |
21 | -if ( ! defined( 'WPINV_PLUGIN_FILE' ) ) { |
|
22 | - define( 'WPINV_PLUGIN_FILE', __FILE__ ); |
|
21 | +if (!defined('WPINV_PLUGIN_FILE')) { |
|
22 | + define('WPINV_PLUGIN_FILE', __FILE__); |
|
23 | 23 | } |
24 | 24 | |
25 | -if ( ! defined( 'WPINV_VERSION' ) ) { |
|
26 | - define( 'WPINV_VERSION', '2.8.2' ); |
|
25 | +if (!defined('WPINV_VERSION')) { |
|
26 | + define('WPINV_VERSION', '2.8.2'); |
|
27 | 27 | } |
28 | 28 | |
29 | 29 | // Include the main Invoicing class. |
30 | -if ( ! class_exists( 'WPInv_Plugin', false ) ) { |
|
31 | - require_once plugin_dir_path( WPINV_PLUGIN_FILE ) . 'includes/class-wpinv.php'; |
|
30 | +if (!class_exists('WPInv_Plugin', false)) { |
|
31 | + require_once plugin_dir_path(WPINV_PLUGIN_FILE) . 'includes/class-wpinv.php'; |
|
32 | 32 | } |
33 | 33 | |
34 | 34 | /** |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | */ |
40 | 40 | function getpaid() { |
41 | 41 | |
42 | - if ( empty( $GLOBALS['invoicing'] ) ) { |
|
42 | + if (empty($GLOBALS['invoicing'])) { |
|
43 | 43 | $GLOBALS['invoicing'] = new WPInv_Plugin(); |
44 | 44 | } |
45 | 45 | |
@@ -52,9 +52,9 @@ discard block |
||
52 | 52 | * @since 2.0.8 |
53 | 53 | */ |
54 | 54 | function getpaid_deactivation_hook() { |
55 | - update_option( 'wpinv_flush_permalinks', 1 ); |
|
55 | + update_option('wpinv_flush_permalinks', 1); |
|
56 | 56 | } |
57 | -register_deactivation_hook( __FILE__, 'getpaid_deactivation_hook' ); |
|
57 | +register_deactivation_hook(__FILE__, 'getpaid_deactivation_hook'); |
|
58 | 58 | |
59 | 59 | /** |
60 | 60 | * @deprecated |
@@ -64,4 +64,4 @@ discard block |
||
64 | 64 | } |
65 | 65 | |
66 | 66 | // Kickstart the plugin. |
67 | -add_action( 'plugins_loaded', 'getpaid', -100 ); |
|
67 | +add_action('plugins_loaded', 'getpaid', -100); |