@@ -9,7 +9,7 @@ discard block |
||
9 | 9 | |
10 | 10 | // Load WP_List_Table if not loaded |
11 | 11 | if ( ! class_exists( 'WP_List_Table' ) ) { |
12 | - require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
12 | + require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
13 | 13 | } |
14 | 14 | |
15 | 15 | /** |
@@ -21,354 +21,354 @@ discard block |
||
21 | 21 | */ |
22 | 22 | class WPInv_Customers_Table extends WP_List_Table { |
23 | 23 | |
24 | - /** |
|
25 | - * @var int Number of items per page |
|
26 | - * @since 1.0.19 |
|
27 | - */ |
|
28 | - public $per_page = 10; |
|
29 | - |
|
30 | - /** |
|
31 | - * @var int Number of items |
|
32 | - * @since 1.0.19 |
|
33 | - */ |
|
34 | - public $total = 0; |
|
35 | - |
|
36 | - /** |
|
37 | - * Get things started |
|
38 | - * |
|
39 | - * @since 1.0.19 |
|
40 | - * @see WP_List_Table::__construct() |
|
41 | - */ |
|
42 | - public function __construct() { |
|
43 | - |
|
44 | - // Set parent defaults |
|
45 | - parent::__construct( array( |
|
46 | - 'singular' => 'id', |
|
47 | - 'plural' => 'ids', |
|
48 | - 'ajax' => false, |
|
49 | - ) ); |
|
50 | - |
|
51 | - } |
|
52 | - |
|
53 | - /** |
|
54 | - * Gets the name of the primary column. |
|
55 | - * |
|
56 | - * @since 1.0.19 |
|
57 | - * @access protected |
|
58 | - * |
|
59 | - * @return string Name of the primary column. |
|
60 | - */ |
|
61 | - protected function get_primary_column_name() { |
|
62 | - return 'name'; |
|
63 | - } |
|
64 | - |
|
65 | - /** |
|
66 | - * This function renders most of the columns in the list table. |
|
67 | - * |
|
68 | - * @since 1.0.19 |
|
69 | - * |
|
70 | - * @param WP_User $item |
|
71 | - * @param string $column_name The name of the column |
|
72 | - * |
|
73 | - * @return string Column Name |
|
74 | - */ |
|
75 | - public function column_default( $item, $column_name ) { |
|
76 | - $value = sanitize_text_field( get_user_meta( $item->ID, '_wpinv_' . $column_name, true ) ); |
|
77 | - return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $item ); |
|
78 | - } |
|
79 | - |
|
80 | - /** |
|
81 | - * Displays the country column. |
|
82 | - * |
|
83 | - * @since 1.0.19 |
|
84 | - * |
|
85 | - * @param WP_User $user |
|
86 | - * |
|
87 | - * @return string Column Name |
|
88 | - */ |
|
89 | - public function column_country( $user ) { |
|
90 | - $country = wpinv_sanitize_country( $user->_wpinv_country ); |
|
91 | - if ( $country ) { |
|
92 | - $country = wpinv_country_name( $country ); |
|
93 | - } |
|
94 | - return sanitize_text_field( $country ); |
|
95 | - } |
|
96 | - |
|
97 | - /** |
|
98 | - * Displays the state column. |
|
99 | - * |
|
100 | - * @since 1.0.19 |
|
101 | - * |
|
102 | - * @param WP_User $user |
|
103 | - * |
|
104 | - * @return string Column Name |
|
105 | - */ |
|
106 | - public function column_state( $user ) { |
|
107 | - $country = wpinv_sanitize_country( $user->_wpinv_country ); |
|
108 | - $state = $user->_wpinv_state; |
|
109 | - if ( $state ) { |
|
110 | - $state = wpinv_state_name( $state, $country ); |
|
111 | - } |
|
112 | - |
|
113 | - return sanitize_text_field( $state ); |
|
114 | - } |
|
115 | - |
|
116 | - /** |
|
117 | - * Displays the signup column. |
|
118 | - * |
|
119 | - * @since 1.0.19 |
|
120 | - * |
|
121 | - * @param WP_User $user |
|
122 | - * |
|
123 | - * @return string Column Name |
|
124 | - */ |
|
125 | - public function column_signup( $user ) { |
|
126 | - return getpaid_format_date_value( $user->user_registered ); |
|
127 | - } |
|
128 | - |
|
129 | - /** |
|
130 | - * Displays the total spent column. |
|
131 | - * |
|
132 | - * @since 1.0.19 |
|
133 | - * |
|
134 | - * @param WP_User $user |
|
135 | - * |
|
136 | - * @return string Column Name |
|
137 | - */ |
|
138 | - public function column_total( $user ) { |
|
139 | - |
|
140 | - $args = array( |
|
141 | - 'data' => array( |
|
142 | - |
|
143 | - 'total' => array( |
|
144 | - 'type' => 'invoice_data', |
|
145 | - 'function' => 'SUM', |
|
146 | - 'name' => 'total_sales', |
|
147 | - ) |
|
148 | - |
|
149 | - ), |
|
150 | - 'where' => array( |
|
151 | - |
|
152 | - 'author' => array( |
|
153 | - 'type' => 'post_data', |
|
154 | - 'value' => absint( $user->ID ), |
|
155 | - 'key' => 'posts.post_author', |
|
156 | - 'operator' => '=', |
|
157 | - ), |
|
158 | - |
|
159 | - ), |
|
160 | - 'query_type' => 'get_var', |
|
161 | - 'invoice_status' => array( 'wpi-renewal', 'wpi-processing', 'publish' ), |
|
162 | - ); |
|
163 | - |
|
164 | - return wpinv_price( (float) GetPaid_Reports_Helper::get_invoice_report_data( $args ) ); |
|
165 | - |
|
166 | - } |
|
167 | - |
|
168 | - /** |
|
169 | - * Displays the total spent column. |
|
170 | - * |
|
171 | - * @since 1.0.19 |
|
172 | - * |
|
173 | - * @param WP_User $user |
|
174 | - * |
|
175 | - * @return string Column Name |
|
176 | - */ |
|
177 | - public function column_invoices( $user ) { |
|
178 | - |
|
179 | - $args = array( |
|
180 | - 'data' => array( |
|
181 | - |
|
182 | - 'ID' => array( |
|
183 | - 'type' => 'post_data', |
|
184 | - 'function' => 'COUNT', |
|
185 | - 'name' => 'count', |
|
186 | - 'distinct' => true, |
|
187 | - ), |
|
188 | - |
|
189 | - ), |
|
190 | - 'where' => array( |
|
191 | - |
|
192 | - 'author' => array( |
|
193 | - 'type' => 'post_data', |
|
194 | - 'value' => absint( $user->ID ), |
|
195 | - 'key' => 'posts.post_author', |
|
196 | - 'operator' => '=', |
|
197 | - ), |
|
198 | - |
|
199 | - ), |
|
200 | - 'query_type' => 'get_var', |
|
201 | - 'invoice_status' => array_keys( wpinv_get_invoice_statuses() ), |
|
202 | - ); |
|
203 | - |
|
204 | - return absint( GetPaid_Reports_Helper::get_invoice_report_data( $args ) ); |
|
205 | - |
|
206 | - } |
|
207 | - |
|
208 | - /** |
|
209 | - * Generates content for a single row of the table |
|
210 | - * @since 1.0.19 |
|
211 | - * |
|
212 | - * @param int $item The user id. |
|
213 | - */ |
|
214 | - public function single_row( $item ) { |
|
215 | - $item = get_user_by( 'id', $item ); |
|
216 | - |
|
217 | - if ( empty( $item ) ) { |
|
218 | - return; |
|
219 | - } |
|
220 | - |
|
221 | - echo '<tr>'; |
|
222 | - $this->single_row_columns( $item ); |
|
223 | - echo '</tr>'; |
|
224 | - } |
|
225 | - |
|
226 | - /** |
|
227 | - * Displays the customers name |
|
228 | - * |
|
229 | - * @param WP_User $customer customer. |
|
230 | - * @return string |
|
231 | - */ |
|
232 | - public function column_name( $customer ) { |
|
233 | - |
|
234 | - // Customer view URL. |
|
235 | - $view_url = esc_url( add_query_arg( 'user_id', $customer->ID, admin_url( 'user-edit.php' ) ) ); |
|
236 | - $row_actions = $this->row_actions( |
|
237 | - array( |
|
238 | - 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
239 | - ) |
|
240 | - ); |
|
241 | - |
|
242 | - // Get user's address. |
|
243 | - $address = wpinv_get_user_address( $customer->ID ); |
|
244 | - |
|
245 | - // Customer email address. |
|
246 | - $email = sanitize_email( $customer->user_email ); |
|
247 | - |
|
248 | - // Customer's avatar. |
|
249 | - $avatar = esc_url( get_avatar_url( $email ) ); |
|
250 | - $avatar = "<img src='$avatar' height='32' width='32'/>"; |
|
251 | - |
|
252 | - // Customer's name. |
|
253 | - $name = sanitize_text_field( "{$address['first_name']} {$address['last_name']}" ); |
|
254 | - |
|
255 | - if ( ! empty( $name ) ) { |
|
256 | - $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
257 | - } |
|
258 | - |
|
259 | - $email = "<div class='row-title'><a href='$view_url'>$email</a></div>"; |
|
260 | - |
|
261 | - return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
262 | - |
|
263 | - } |
|
264 | - |
|
265 | - /** |
|
266 | - * Retrieve the table columns |
|
267 | - * |
|
268 | - * @since 1.0.19 |
|
269 | - * @return array $columns Array of all the list table columns |
|
270 | - */ |
|
271 | - public function get_columns() { |
|
272 | - |
|
273 | - $columns = array( |
|
274 | - 'name' => __( 'Name', 'invoicing' ), |
|
275 | - 'country' => __( 'Country', 'invoicing' ), |
|
276 | - 'state' => __( 'State', 'invoicing' ), |
|
277 | - 'city' => __( 'City', 'invoicing' ), |
|
278 | - 'zip' => __( 'ZIP', 'invoicing' ), |
|
279 | - 'address' => __( 'Address', 'invoicing' ), |
|
280 | - 'phone' => __( 'Phone', 'invoicing' ), |
|
281 | - 'company' => __( 'Company', 'invoicing' ), |
|
282 | - 'invoices' => __( 'Invoices', 'invoicing' ), |
|
283 | - 'total' => __( 'Total Spend', 'invoicing' ), |
|
284 | - 'signup' => __( 'Date created', 'invoicing' ), |
|
285 | - ); |
|
286 | - return apply_filters( 'wpinv_customers_table_columns', $columns ); |
|
287 | - |
|
288 | - } |
|
289 | - |
|
290 | - /** |
|
291 | - * Retrieve the current page number |
|
292 | - * |
|
293 | - * @since 1.0.19 |
|
294 | - * @return int Current page number |
|
295 | - */ |
|
296 | - public function get_paged() { |
|
297 | - return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
298 | - } |
|
299 | - |
|
300 | - /** |
|
301 | - * Returns bulk actions. |
|
302 | - * |
|
303 | - * @since 1.0.19 |
|
304 | - * @return void |
|
305 | - */ |
|
306 | - public function bulk_actions( $which = '' ) { |
|
307 | - return array(); |
|
308 | - } |
|
309 | - |
|
310 | - /** |
|
311 | - * Prepares the display query |
|
312 | - */ |
|
313 | - public function prepare_query() { |
|
314 | - global $wpdb; |
|
315 | - |
|
316 | - $post_types = ''; |
|
317 | - |
|
318 | - foreach ( array_keys( getpaid_get_invoice_post_types() ) as $post_type ) { |
|
319 | - $post_types .= $wpdb->prepare( "post_type=%s OR ", $post_type ); |
|
320 | - } |
|
321 | - |
|
322 | - $post_types = rtrim( $post_types, ' OR' ); |
|
323 | - |
|
324 | - // Maybe search. |
|
325 | - if ( ! empty( $_POST['s'] ) ) { |
|
326 | - $users = get_users( |
|
327 | - array( |
|
328 | - 'search' => '*' . sanitize_text_field( urldecode( $_POST['s'] ) ) . '*', |
|
329 | - 'search_columns' => array( 'user_login', 'user_email', 'display_name' ), |
|
330 | - 'fields' => 'ID', |
|
331 | - ) |
|
332 | - ); |
|
333 | - |
|
334 | - $users = implode( ', ', $users ); |
|
335 | - $post_types = "($post_types) AND ( post_author IN ( $users ) )"; |
|
336 | - } |
|
337 | - |
|
338 | - // Users with invoices. |
|
339 | - $customers = $wpdb->get_col( |
|
340 | - $wpdb->prepare( |
|
341 | - "SELECT DISTINCT( post_author ) FROM $wpdb->posts WHERE $post_types LIMIT %d,%d", |
|
342 | - $this->get_paged() * 10 - 10, |
|
343 | - $this->per_page |
|
344 | - ) |
|
345 | - ); |
|
346 | - |
|
347 | - $this->items = $customers; |
|
348 | - $this->total = (int) $wpdb->get_var( "SELECT COUNT( DISTINCT( post_author ) ) FROM $wpdb->posts WHERE $post_types" ); |
|
349 | - |
|
350 | - } |
|
351 | - |
|
352 | - /** |
|
353 | - * Setup the final data for the table |
|
354 | - * |
|
355 | - * @since 1.0.19 |
|
356 | - * @return void |
|
357 | - */ |
|
358 | - public function prepare_items() { |
|
359 | - $columns = $this->get_columns(); |
|
360 | - $hidden = array(); // No hidden columns |
|
361 | - $sortable = $this->get_sortable_columns(); |
|
362 | - $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
363 | - $this->prepare_query(); |
|
364 | - |
|
365 | - $this->set_pagination_args( |
|
366 | - array( |
|
367 | - 'total_items' => $this->total, |
|
368 | - 'per_page' => $this->per_page, |
|
369 | - 'total_pages' => ceil( $this->total / $this->per_page ) |
|
370 | - ) |
|
371 | - ); |
|
372 | - |
|
373 | - } |
|
24 | + /** |
|
25 | + * @var int Number of items per page |
|
26 | + * @since 1.0.19 |
|
27 | + */ |
|
28 | + public $per_page = 10; |
|
29 | + |
|
30 | + /** |
|
31 | + * @var int Number of items |
|
32 | + * @since 1.0.19 |
|
33 | + */ |
|
34 | + public $total = 0; |
|
35 | + |
|
36 | + /** |
|
37 | + * Get things started |
|
38 | + * |
|
39 | + * @since 1.0.19 |
|
40 | + * @see WP_List_Table::__construct() |
|
41 | + */ |
|
42 | + public function __construct() { |
|
43 | + |
|
44 | + // Set parent defaults |
|
45 | + parent::__construct( array( |
|
46 | + 'singular' => 'id', |
|
47 | + 'plural' => 'ids', |
|
48 | + 'ajax' => false, |
|
49 | + ) ); |
|
50 | + |
|
51 | + } |
|
52 | + |
|
53 | + /** |
|
54 | + * Gets the name of the primary column. |
|
55 | + * |
|
56 | + * @since 1.0.19 |
|
57 | + * @access protected |
|
58 | + * |
|
59 | + * @return string Name of the primary column. |
|
60 | + */ |
|
61 | + protected function get_primary_column_name() { |
|
62 | + return 'name'; |
|
63 | + } |
|
64 | + |
|
65 | + /** |
|
66 | + * This function renders most of the columns in the list table. |
|
67 | + * |
|
68 | + * @since 1.0.19 |
|
69 | + * |
|
70 | + * @param WP_User $item |
|
71 | + * @param string $column_name The name of the column |
|
72 | + * |
|
73 | + * @return string Column Name |
|
74 | + */ |
|
75 | + public function column_default( $item, $column_name ) { |
|
76 | + $value = sanitize_text_field( get_user_meta( $item->ID, '_wpinv_' . $column_name, true ) ); |
|
77 | + return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $item ); |
|
78 | + } |
|
79 | + |
|
80 | + /** |
|
81 | + * Displays the country column. |
|
82 | + * |
|
83 | + * @since 1.0.19 |
|
84 | + * |
|
85 | + * @param WP_User $user |
|
86 | + * |
|
87 | + * @return string Column Name |
|
88 | + */ |
|
89 | + public function column_country( $user ) { |
|
90 | + $country = wpinv_sanitize_country( $user->_wpinv_country ); |
|
91 | + if ( $country ) { |
|
92 | + $country = wpinv_country_name( $country ); |
|
93 | + } |
|
94 | + return sanitize_text_field( $country ); |
|
95 | + } |
|
96 | + |
|
97 | + /** |
|
98 | + * Displays the state column. |
|
99 | + * |
|
100 | + * @since 1.0.19 |
|
101 | + * |
|
102 | + * @param WP_User $user |
|
103 | + * |
|
104 | + * @return string Column Name |
|
105 | + */ |
|
106 | + public function column_state( $user ) { |
|
107 | + $country = wpinv_sanitize_country( $user->_wpinv_country ); |
|
108 | + $state = $user->_wpinv_state; |
|
109 | + if ( $state ) { |
|
110 | + $state = wpinv_state_name( $state, $country ); |
|
111 | + } |
|
112 | + |
|
113 | + return sanitize_text_field( $state ); |
|
114 | + } |
|
115 | + |
|
116 | + /** |
|
117 | + * Displays the signup column. |
|
118 | + * |
|
119 | + * @since 1.0.19 |
|
120 | + * |
|
121 | + * @param WP_User $user |
|
122 | + * |
|
123 | + * @return string Column Name |
|
124 | + */ |
|
125 | + public function column_signup( $user ) { |
|
126 | + return getpaid_format_date_value( $user->user_registered ); |
|
127 | + } |
|
128 | + |
|
129 | + /** |
|
130 | + * Displays the total spent column. |
|
131 | + * |
|
132 | + * @since 1.0.19 |
|
133 | + * |
|
134 | + * @param WP_User $user |
|
135 | + * |
|
136 | + * @return string Column Name |
|
137 | + */ |
|
138 | + public function column_total( $user ) { |
|
139 | + |
|
140 | + $args = array( |
|
141 | + 'data' => array( |
|
142 | + |
|
143 | + 'total' => array( |
|
144 | + 'type' => 'invoice_data', |
|
145 | + 'function' => 'SUM', |
|
146 | + 'name' => 'total_sales', |
|
147 | + ) |
|
148 | + |
|
149 | + ), |
|
150 | + 'where' => array( |
|
151 | + |
|
152 | + 'author' => array( |
|
153 | + 'type' => 'post_data', |
|
154 | + 'value' => absint( $user->ID ), |
|
155 | + 'key' => 'posts.post_author', |
|
156 | + 'operator' => '=', |
|
157 | + ), |
|
158 | + |
|
159 | + ), |
|
160 | + 'query_type' => 'get_var', |
|
161 | + 'invoice_status' => array( 'wpi-renewal', 'wpi-processing', 'publish' ), |
|
162 | + ); |
|
163 | + |
|
164 | + return wpinv_price( (float) GetPaid_Reports_Helper::get_invoice_report_data( $args ) ); |
|
165 | + |
|
166 | + } |
|
167 | + |
|
168 | + /** |
|
169 | + * Displays the total spent column. |
|
170 | + * |
|
171 | + * @since 1.0.19 |
|
172 | + * |
|
173 | + * @param WP_User $user |
|
174 | + * |
|
175 | + * @return string Column Name |
|
176 | + */ |
|
177 | + public function column_invoices( $user ) { |
|
178 | + |
|
179 | + $args = array( |
|
180 | + 'data' => array( |
|
181 | + |
|
182 | + 'ID' => array( |
|
183 | + 'type' => 'post_data', |
|
184 | + 'function' => 'COUNT', |
|
185 | + 'name' => 'count', |
|
186 | + 'distinct' => true, |
|
187 | + ), |
|
188 | + |
|
189 | + ), |
|
190 | + 'where' => array( |
|
191 | + |
|
192 | + 'author' => array( |
|
193 | + 'type' => 'post_data', |
|
194 | + 'value' => absint( $user->ID ), |
|
195 | + 'key' => 'posts.post_author', |
|
196 | + 'operator' => '=', |
|
197 | + ), |
|
198 | + |
|
199 | + ), |
|
200 | + 'query_type' => 'get_var', |
|
201 | + 'invoice_status' => array_keys( wpinv_get_invoice_statuses() ), |
|
202 | + ); |
|
203 | + |
|
204 | + return absint( GetPaid_Reports_Helper::get_invoice_report_data( $args ) ); |
|
205 | + |
|
206 | + } |
|
207 | + |
|
208 | + /** |
|
209 | + * Generates content for a single row of the table |
|
210 | + * @since 1.0.19 |
|
211 | + * |
|
212 | + * @param int $item The user id. |
|
213 | + */ |
|
214 | + public function single_row( $item ) { |
|
215 | + $item = get_user_by( 'id', $item ); |
|
216 | + |
|
217 | + if ( empty( $item ) ) { |
|
218 | + return; |
|
219 | + } |
|
220 | + |
|
221 | + echo '<tr>'; |
|
222 | + $this->single_row_columns( $item ); |
|
223 | + echo '</tr>'; |
|
224 | + } |
|
225 | + |
|
226 | + /** |
|
227 | + * Displays the customers name |
|
228 | + * |
|
229 | + * @param WP_User $customer customer. |
|
230 | + * @return string |
|
231 | + */ |
|
232 | + public function column_name( $customer ) { |
|
233 | + |
|
234 | + // Customer view URL. |
|
235 | + $view_url = esc_url( add_query_arg( 'user_id', $customer->ID, admin_url( 'user-edit.php' ) ) ); |
|
236 | + $row_actions = $this->row_actions( |
|
237 | + array( |
|
238 | + 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
239 | + ) |
|
240 | + ); |
|
241 | + |
|
242 | + // Get user's address. |
|
243 | + $address = wpinv_get_user_address( $customer->ID ); |
|
244 | + |
|
245 | + // Customer email address. |
|
246 | + $email = sanitize_email( $customer->user_email ); |
|
247 | + |
|
248 | + // Customer's avatar. |
|
249 | + $avatar = esc_url( get_avatar_url( $email ) ); |
|
250 | + $avatar = "<img src='$avatar' height='32' width='32'/>"; |
|
251 | + |
|
252 | + // Customer's name. |
|
253 | + $name = sanitize_text_field( "{$address['first_name']} {$address['last_name']}" ); |
|
254 | + |
|
255 | + if ( ! empty( $name ) ) { |
|
256 | + $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
257 | + } |
|
258 | + |
|
259 | + $email = "<div class='row-title'><a href='$view_url'>$email</a></div>"; |
|
260 | + |
|
261 | + return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
262 | + |
|
263 | + } |
|
264 | + |
|
265 | + /** |
|
266 | + * Retrieve the table columns |
|
267 | + * |
|
268 | + * @since 1.0.19 |
|
269 | + * @return array $columns Array of all the list table columns |
|
270 | + */ |
|
271 | + public function get_columns() { |
|
272 | + |
|
273 | + $columns = array( |
|
274 | + 'name' => __( 'Name', 'invoicing' ), |
|
275 | + 'country' => __( 'Country', 'invoicing' ), |
|
276 | + 'state' => __( 'State', 'invoicing' ), |
|
277 | + 'city' => __( 'City', 'invoicing' ), |
|
278 | + 'zip' => __( 'ZIP', 'invoicing' ), |
|
279 | + 'address' => __( 'Address', 'invoicing' ), |
|
280 | + 'phone' => __( 'Phone', 'invoicing' ), |
|
281 | + 'company' => __( 'Company', 'invoicing' ), |
|
282 | + 'invoices' => __( 'Invoices', 'invoicing' ), |
|
283 | + 'total' => __( 'Total Spend', 'invoicing' ), |
|
284 | + 'signup' => __( 'Date created', 'invoicing' ), |
|
285 | + ); |
|
286 | + return apply_filters( 'wpinv_customers_table_columns', $columns ); |
|
287 | + |
|
288 | + } |
|
289 | + |
|
290 | + /** |
|
291 | + * Retrieve the current page number |
|
292 | + * |
|
293 | + * @since 1.0.19 |
|
294 | + * @return int Current page number |
|
295 | + */ |
|
296 | + public function get_paged() { |
|
297 | + return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
298 | + } |
|
299 | + |
|
300 | + /** |
|
301 | + * Returns bulk actions. |
|
302 | + * |
|
303 | + * @since 1.0.19 |
|
304 | + * @return void |
|
305 | + */ |
|
306 | + public function bulk_actions( $which = '' ) { |
|
307 | + return array(); |
|
308 | + } |
|
309 | + |
|
310 | + /** |
|
311 | + * Prepares the display query |
|
312 | + */ |
|
313 | + public function prepare_query() { |
|
314 | + global $wpdb; |
|
315 | + |
|
316 | + $post_types = ''; |
|
317 | + |
|
318 | + foreach ( array_keys( getpaid_get_invoice_post_types() ) as $post_type ) { |
|
319 | + $post_types .= $wpdb->prepare( "post_type=%s OR ", $post_type ); |
|
320 | + } |
|
321 | + |
|
322 | + $post_types = rtrim( $post_types, ' OR' ); |
|
323 | + |
|
324 | + // Maybe search. |
|
325 | + if ( ! empty( $_POST['s'] ) ) { |
|
326 | + $users = get_users( |
|
327 | + array( |
|
328 | + 'search' => '*' . sanitize_text_field( urldecode( $_POST['s'] ) ) . '*', |
|
329 | + 'search_columns' => array( 'user_login', 'user_email', 'display_name' ), |
|
330 | + 'fields' => 'ID', |
|
331 | + ) |
|
332 | + ); |
|
333 | + |
|
334 | + $users = implode( ', ', $users ); |
|
335 | + $post_types = "($post_types) AND ( post_author IN ( $users ) )"; |
|
336 | + } |
|
337 | + |
|
338 | + // Users with invoices. |
|
339 | + $customers = $wpdb->get_col( |
|
340 | + $wpdb->prepare( |
|
341 | + "SELECT DISTINCT( post_author ) FROM $wpdb->posts WHERE $post_types LIMIT %d,%d", |
|
342 | + $this->get_paged() * 10 - 10, |
|
343 | + $this->per_page |
|
344 | + ) |
|
345 | + ); |
|
346 | + |
|
347 | + $this->items = $customers; |
|
348 | + $this->total = (int) $wpdb->get_var( "SELECT COUNT( DISTINCT( post_author ) ) FROM $wpdb->posts WHERE $post_types" ); |
|
349 | + |
|
350 | + } |
|
351 | + |
|
352 | + /** |
|
353 | + * Setup the final data for the table |
|
354 | + * |
|
355 | + * @since 1.0.19 |
|
356 | + * @return void |
|
357 | + */ |
|
358 | + public function prepare_items() { |
|
359 | + $columns = $this->get_columns(); |
|
360 | + $hidden = array(); // No hidden columns |
|
361 | + $sortable = $this->get_sortable_columns(); |
|
362 | + $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
363 | + $this->prepare_query(); |
|
364 | + |
|
365 | + $this->set_pagination_args( |
|
366 | + array( |
|
367 | + 'total_items' => $this->total, |
|
368 | + 'per_page' => $this->per_page, |
|
369 | + 'total_pages' => ceil( $this->total / $this->per_page ) |
|
370 | + ) |
|
371 | + ); |
|
372 | + |
|
373 | + } |
|
374 | 374 | } |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | if ( ! defined( 'ABSPATH' ) ) { |
3 | - exit; |
|
3 | + exit; |
|
4 | 4 | } |
5 | 5 | |
6 | 6 | /** |
@@ -20,29 +20,29 @@ discard block |
||
20 | 20 | public $templates_url; |
21 | 21 | |
22 | 22 | /** |
23 | - * Class constructor. |
|
24 | - * |
|
25 | - * @since 1.0.19 |
|
26 | - */ |
|
27 | - public function __construct() { |
|
23 | + * Class constructor. |
|
24 | + * |
|
25 | + * @since 1.0.19 |
|
26 | + */ |
|
27 | + public function __construct() { |
|
28 | 28 | |
29 | 29 | $this->templates_dir = apply_filters( 'getpaid_default_templates_dir', WPINV_PLUGIN_DIR . 'templates' ); |
30 | 30 | $this->templates_url = apply_filters( 'getpaid_default_templates_url', WPINV_PLUGIN_URL . 'templates' ); |
31 | 31 | |
32 | 32 | // Oxygen plugin |
33 | - if ( defined( 'CT_VERSION' ) ) { |
|
34 | - add_filter( 'wpinv_locate_template', array( $this, 'oxygen_override_template' ), 11, 4 ); |
|
35 | - } |
|
33 | + if ( defined( 'CT_VERSION' ) ) { |
|
34 | + add_filter( 'wpinv_locate_template', array( $this, 'oxygen_override_template' ), 11, 4 ); |
|
35 | + } |
|
36 | 36 | |
37 | 37 | } |
38 | 38 | |
39 | 39 | /** |
40 | - * Checks if this is a preview page |
|
41 | - * |
|
42 | - * @since 1.0.19 |
|
43 | - * @return bool |
|
44 | - */ |
|
45 | - public function is_preview() { |
|
40 | + * Checks if this is a preview page |
|
41 | + * |
|
42 | + * @since 1.0.19 |
|
43 | + * @return bool |
|
44 | + */ |
|
45 | + public function is_preview() { |
|
46 | 46 | return |
47 | 47 | $this->is_divi_preview() || |
48 | 48 | $this->is_elementor_preview() || |
@@ -54,73 +54,73 @@ discard block |
||
54 | 54 | } |
55 | 55 | |
56 | 56 | /** |
57 | - * Checks if this is an elementor preview page |
|
58 | - * |
|
59 | - * @since 1.0.19 |
|
60 | - * @return bool |
|
61 | - */ |
|
62 | - public function is_elementor_preview() { |
|
63 | - return isset( $_REQUEST['elementor-preview'] ) || ( is_admin() && isset( $_REQUEST['action'] ) && $_REQUEST['action'] == 'elementor' ) || ( isset( $_REQUEST['action'] ) && $_REQUEST['action'] == 'elementor_ajax' ); |
|
64 | - } |
|
65 | - |
|
66 | - /** |
|
67 | - * Checks if this is a DIVI preview page |
|
68 | - * |
|
69 | - * @since 1.0.19 |
|
70 | - * @return bool |
|
71 | - */ |
|
72 | - public function is_divi_preview() { |
|
73 | - return isset( $_REQUEST['et_fb'] ) || isset( $_REQUEST['et_pb_preview'] ) || ( is_admin() && isset( $_REQUEST['action'] ) && $_REQUEST['action'] == 'et_pb' ); |
|
74 | - } |
|
75 | - |
|
76 | - /** |
|
77 | - * Checks if this is a beaver builder preview page |
|
78 | - * |
|
79 | - * @since 1.0.19 |
|
80 | - * @return bool |
|
81 | - */ |
|
82 | - public function is_beaver_preview() { |
|
83 | - return isset( $_REQUEST['fl_builder'] ); |
|
84 | - } |
|
85 | - |
|
86 | - /** |
|
87 | - * Checks if this is a siteorigin builder preview page |
|
88 | - * |
|
89 | - * @since 1.0.19 |
|
90 | - * @return bool |
|
91 | - */ |
|
92 | - public function is_siteorigin_preview() { |
|
93 | - return ! empty( $_REQUEST['siteorigin_panels_live_editor'] ); |
|
94 | - } |
|
95 | - |
|
96 | - /** |
|
97 | - * Checks if this is a cornerstone builder preview page |
|
98 | - * |
|
99 | - * @since 1.0.19 |
|
100 | - * @return bool |
|
101 | - */ |
|
102 | - public function is_cornerstone_preview() { |
|
103 | - return ! empty( $_REQUEST['cornerstone_preview'] ) || basename( $_SERVER['REQUEST_URI'] ) == 'cornerstone-endpoint'; |
|
104 | - } |
|
105 | - |
|
106 | - /** |
|
107 | - * Checks if this is a fusion builder preview page |
|
108 | - * |
|
109 | - * @since 1.0.19 |
|
110 | - * @return bool |
|
111 | - */ |
|
112 | - public function is_fusion_preview() { |
|
113 | - return ! empty( $_REQUEST['fb-edit'] ) || ! empty( $_REQUEST['fusion_load_nonce'] ); |
|
114 | - } |
|
115 | - |
|
116 | - /** |
|
117 | - * Checks if this is an oxygen builder preview page |
|
118 | - * |
|
119 | - * @since 1.0.19 |
|
120 | - * @return bool |
|
121 | - */ |
|
122 | - public function is_oxygen_preview() { |
|
123 | - return ! empty( $_REQUEST['ct_builder'] ) || ( ! empty( $_REQUEST['action'] ) && ( substr( $_REQUEST['action'], 0, 11 ) === "oxy_render_" || substr( $_REQUEST['action'], 0, 10 ) === "ct_render_" ) ); |
|
57 | + * Checks if this is an elementor preview page |
|
58 | + * |
|
59 | + * @since 1.0.19 |
|
60 | + * @return bool |
|
61 | + */ |
|
62 | + public function is_elementor_preview() { |
|
63 | + return isset( $_REQUEST['elementor-preview'] ) || ( is_admin() && isset( $_REQUEST['action'] ) && $_REQUEST['action'] == 'elementor' ) || ( isset( $_REQUEST['action'] ) && $_REQUEST['action'] == 'elementor_ajax' ); |
|
64 | + } |
|
65 | + |
|
66 | + /** |
|
67 | + * Checks if this is a DIVI preview page |
|
68 | + * |
|
69 | + * @since 1.0.19 |
|
70 | + * @return bool |
|
71 | + */ |
|
72 | + public function is_divi_preview() { |
|
73 | + return isset( $_REQUEST['et_fb'] ) || isset( $_REQUEST['et_pb_preview'] ) || ( is_admin() && isset( $_REQUEST['action'] ) && $_REQUEST['action'] == 'et_pb' ); |
|
74 | + } |
|
75 | + |
|
76 | + /** |
|
77 | + * Checks if this is a beaver builder preview page |
|
78 | + * |
|
79 | + * @since 1.0.19 |
|
80 | + * @return bool |
|
81 | + */ |
|
82 | + public function is_beaver_preview() { |
|
83 | + return isset( $_REQUEST['fl_builder'] ); |
|
84 | + } |
|
85 | + |
|
86 | + /** |
|
87 | + * Checks if this is a siteorigin builder preview page |
|
88 | + * |
|
89 | + * @since 1.0.19 |
|
90 | + * @return bool |
|
91 | + */ |
|
92 | + public function is_siteorigin_preview() { |
|
93 | + return ! empty( $_REQUEST['siteorigin_panels_live_editor'] ); |
|
94 | + } |
|
95 | + |
|
96 | + /** |
|
97 | + * Checks if this is a cornerstone builder preview page |
|
98 | + * |
|
99 | + * @since 1.0.19 |
|
100 | + * @return bool |
|
101 | + */ |
|
102 | + public function is_cornerstone_preview() { |
|
103 | + return ! empty( $_REQUEST['cornerstone_preview'] ) || basename( $_SERVER['REQUEST_URI'] ) == 'cornerstone-endpoint'; |
|
104 | + } |
|
105 | + |
|
106 | + /** |
|
107 | + * Checks if this is a fusion builder preview page |
|
108 | + * |
|
109 | + * @since 1.0.19 |
|
110 | + * @return bool |
|
111 | + */ |
|
112 | + public function is_fusion_preview() { |
|
113 | + return ! empty( $_REQUEST['fb-edit'] ) || ! empty( $_REQUEST['fusion_load_nonce'] ); |
|
114 | + } |
|
115 | + |
|
116 | + /** |
|
117 | + * Checks if this is an oxygen builder preview page |
|
118 | + * |
|
119 | + * @since 1.0.19 |
|
120 | + * @return bool |
|
121 | + */ |
|
122 | + public function is_oxygen_preview() { |
|
123 | + return ! empty( $_REQUEST['ct_builder'] ) || ( ! empty( $_REQUEST['action'] ) && ( substr( $_REQUEST['action'], 0, 11 ) === "oxy_render_" || substr( $_REQUEST['action'], 0, 10 ) === "ct_render_" ) ); |
|
124 | 124 | } |
125 | 125 | |
126 | 126 | /** |
@@ -130,7 +130,7 @@ discard block |
||
130 | 130 | * @param string $template_path The template path relative to the theme's root dir. Defaults to 'invoicing'. |
131 | 131 | * @param string $default_path The root path to the default template. Defaults to invoicing/templates |
132 | 132 | */ |
133 | - public function locate_template( $template_name, $template_path = '', $default_path = '' ) { |
|
133 | + public function locate_template( $template_name, $template_path = '', $default_path = '' ) { |
|
134 | 134 | |
135 | 135 | // Load the defaults for the template path and default path. |
136 | 136 | $template_path = empty( $template_path ) ? 'invoicing' : $template_path; |
@@ -151,22 +151,22 @@ discard block |
||
151 | 151 | } |
152 | 152 | |
153 | 153 | /** |
154 | - * Loads a template |
|
155 | - * |
|
156 | - * @since 1.0.19 |
|
157 | - * @return bool |
|
158 | - */ |
|
159 | - protected function load_template( $template_name, $template_path, $args ) { |
|
154 | + * Loads a template |
|
155 | + * |
|
156 | + * @since 1.0.19 |
|
157 | + * @return bool |
|
158 | + */ |
|
159 | + protected function load_template( $template_name, $template_path, $args ) { |
|
160 | 160 | |
161 | 161 | if ( is_array( $args ) ){ |
162 | 162 | extract( $args ); |
163 | 163 | } |
164 | 164 | |
165 | 165 | // Fires before loading a template. |
166 | - do_action( 'wpinv_before_template_part', $template_name, $template_path, $args ); |
|
166 | + do_action( 'wpinv_before_template_part', $template_name, $template_path, $args ); |
|
167 | 167 | |
168 | 168 | // Load the template. |
169 | - include( $template_path ); |
|
169 | + include( $template_path ); |
|
170 | 170 | |
171 | 171 | // Fires after loading a template. |
172 | 172 | do_action( 'wpinv_after_template_part', $template_name, $template_path, $args ); |
@@ -183,7 +183,7 @@ discard block |
||
183 | 183 | * @param string $template_path The templates directory relative to the theme's root dir. Defaults to 'invoicing'. |
184 | 184 | * @param string $default_path The root path to the default template. Defaults to invoicing/templates |
185 | 185 | */ |
186 | - public function display_template( $template_name, $args = array(), $template_path = '', $default_path = '' ) { |
|
186 | + public function display_template( $template_name, $args = array(), $template_path = '', $default_path = '' ) { |
|
187 | 187 | |
188 | 188 | // Locate the template. |
189 | 189 | $located = $this->locate_template( $template_name, $template_path, $default_path ); |
@@ -208,74 +208,74 @@ discard block |
||
208 | 208 | * @param string $template_path The templates directory relative to the theme's root dir. Defaults to 'invoicing'. |
209 | 209 | * @param string $default_path The root path to the default template. Defaults to invoicing/templates |
210 | 210 | */ |
211 | - public function get_template( $template_name, $args = array(), $template_path = '', $default_path = '' ) { |
|
211 | + public function get_template( $template_name, $args = array(), $template_path = '', $default_path = '' ) { |
|
212 | 212 | ob_start(); |
213 | 213 | $this->display_template( $template_name, $args, $template_path, $default_path ); |
214 | 214 | return ob_get_clean(); |
215 | 215 | } |
216 | 216 | |
217 | 217 | /** |
218 | - * Get the geodirectory templates theme path. |
|
219 | - * |
|
220 | - * |
|
221 | - * @return string Template path. |
|
222 | - */ |
|
223 | - public static function get_theme_template_path() { |
|
224 | - $template = get_template(); |
|
225 | - $theme_root = get_theme_root( $template ); |
|
226 | - |
|
227 | - return $theme_root . '/' . $template . '/' . untrailingslashit( wpinv_get_theme_template_dir_name() ); |
|
228 | - |
|
229 | - } |
|
230 | - |
|
231 | - /** |
|
232 | - * Oxygen locate theme template. |
|
233 | - * |
|
234 | - * @param string $template The template. |
|
235 | - * @return string The theme template. |
|
236 | - */ |
|
237 | - public static function oxygen_locate_template( $template ) { |
|
238 | - |
|
239 | - if ( empty( $template ) ) { |
|
240 | - return ''; |
|
241 | - } |
|
242 | - |
|
243 | - $has_filter = has_filter( 'template', 'ct_oxygen_template_name' ); |
|
244 | - |
|
245 | - // Remove template filter |
|
246 | - if ( $has_filter ) { |
|
247 | - remove_filter( 'template', 'ct_oxygen_template_name' ); |
|
248 | - } |
|
249 | - |
|
250 | - $template = self::get_theme_template_path() . '/' . $template; |
|
251 | - |
|
252 | - if ( ! file_exists( $template ) ) { |
|
253 | - $template = ''; |
|
254 | - } |
|
255 | - |
|
256 | - // Add template filter |
|
257 | - if ( $has_filter ) { |
|
258 | - add_filter( 'template', 'ct_oxygen_template_name' ); |
|
259 | - } |
|
260 | - |
|
261 | - return $template; |
|
262 | - } |
|
263 | - |
|
264 | - /** |
|
265 | - * Oxygen override theme template. |
|
266 | - * |
|
267 | - * @param string $located Located template. |
|
268 | - * @param string $template_name Template name. |
|
269 | - * @return string Located template. |
|
270 | - */ |
|
271 | - public function oxygen_override_template( $located, $template_name ) { |
|
218 | + * Get the geodirectory templates theme path. |
|
219 | + * |
|
220 | + * |
|
221 | + * @return string Template path. |
|
222 | + */ |
|
223 | + public static function get_theme_template_path() { |
|
224 | + $template = get_template(); |
|
225 | + $theme_root = get_theme_root( $template ); |
|
226 | + |
|
227 | + return $theme_root . '/' . $template . '/' . untrailingslashit( wpinv_get_theme_template_dir_name() ); |
|
228 | + |
|
229 | + } |
|
230 | + |
|
231 | + /** |
|
232 | + * Oxygen locate theme template. |
|
233 | + * |
|
234 | + * @param string $template The template. |
|
235 | + * @return string The theme template. |
|
236 | + */ |
|
237 | + public static function oxygen_locate_template( $template ) { |
|
238 | + |
|
239 | + if ( empty( $template ) ) { |
|
240 | + return ''; |
|
241 | + } |
|
242 | + |
|
243 | + $has_filter = has_filter( 'template', 'ct_oxygen_template_name' ); |
|
244 | + |
|
245 | + // Remove template filter |
|
246 | + if ( $has_filter ) { |
|
247 | + remove_filter( 'template', 'ct_oxygen_template_name' ); |
|
248 | + } |
|
249 | + |
|
250 | + $template = self::get_theme_template_path() . '/' . $template; |
|
251 | + |
|
252 | + if ( ! file_exists( $template ) ) { |
|
253 | + $template = ''; |
|
254 | + } |
|
255 | + |
|
256 | + // Add template filter |
|
257 | + if ( $has_filter ) { |
|
258 | + add_filter( 'template', 'ct_oxygen_template_name' ); |
|
259 | + } |
|
260 | + |
|
261 | + return $template; |
|
262 | + } |
|
263 | + |
|
264 | + /** |
|
265 | + * Oxygen override theme template. |
|
266 | + * |
|
267 | + * @param string $located Located template. |
|
268 | + * @param string $template_name Template name. |
|
269 | + * @return string Located template. |
|
270 | + */ |
|
271 | + public function oxygen_override_template( $located, $template_name ) { |
|
272 | 272 | |
273 | 273 | $oxygen_overide = self::oxygen_locate_template( $template_name ); |
274 | - if ( ! empty( $oxygen_overide ) ) { |
|
275 | - return $oxygen_overide; |
|
276 | - } |
|
274 | + if ( ! empty( $oxygen_overide ) ) { |
|
275 | + return $oxygen_overide; |
|
276 | + } |
|
277 | 277 | |
278 | - return $located; |
|
279 | - } |
|
278 | + return $located; |
|
279 | + } |
|
280 | 280 | |
281 | 281 | } |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | if ( ! defined( 'ABSPATH' ) ) { |
3 | - exit; |
|
3 | + exit; |
|
4 | 4 | } |
5 | 5 | |
6 | 6 | /** |
@@ -10,67 +10,67 @@ discard block |
||
10 | 10 | class GetPaid_Form_Item extends WPInv_Item { |
11 | 11 | |
12 | 12 | /** |
13 | - * Stores a custom description for the item. |
|
14 | - * |
|
15 | - * @var string |
|
16 | - */ |
|
17 | - protected $custom_description = null; |
|
18 | - |
|
19 | - /** |
|
20 | - * Stores the item quantity. |
|
21 | - * |
|
22 | - * @var float |
|
23 | - */ |
|
24 | - protected $quantity = 1; |
|
25 | - |
|
26 | - /** |
|
27 | - * Stores the item meta. |
|
28 | - * |
|
29 | - * @var array |
|
30 | - */ |
|
31 | - protected $meta = array(); |
|
32 | - |
|
33 | - /** |
|
34 | - * Is this item required? |
|
35 | - * |
|
36 | - * @var int |
|
37 | - */ |
|
38 | - protected $is_required = true; |
|
39 | - |
|
40 | - /** |
|
41 | - * Are quantities allowed? |
|
42 | - * |
|
43 | - * @var int |
|
44 | - */ |
|
45 | - protected $allow_quantities = false; |
|
46 | - |
|
47 | - /** |
|
48 | - * Associated invoice. |
|
49 | - * |
|
50 | - * @var int |
|
51 | - */ |
|
52 | - public $invoice_id = 0; |
|
53 | - |
|
54 | - /** |
|
55 | - * Item discount. |
|
56 | - * |
|
57 | - * @var float |
|
58 | - */ |
|
59 | - public $item_discount = 0; |
|
60 | - |
|
61 | - /** |
|
62 | - * Recurring item discount. |
|
63 | - * |
|
64 | - * @var float |
|
65 | - */ |
|
66 | - public $recurring_item_discount = 0; |
|
67 | - |
|
68 | - /** |
|
69 | - * Item tax. |
|
70 | - * |
|
71 | - * @var float |
|
72 | - */ |
|
73 | - public $item_tax = 0; |
|
13 | + * Stores a custom description for the item. |
|
14 | + * |
|
15 | + * @var string |
|
16 | + */ |
|
17 | + protected $custom_description = null; |
|
18 | + |
|
19 | + /** |
|
20 | + * Stores the item quantity. |
|
21 | + * |
|
22 | + * @var float |
|
23 | + */ |
|
24 | + protected $quantity = 1; |
|
25 | + |
|
26 | + /** |
|
27 | + * Stores the item meta. |
|
28 | + * |
|
29 | + * @var array |
|
30 | + */ |
|
31 | + protected $meta = array(); |
|
32 | + |
|
33 | + /** |
|
34 | + * Is this item required? |
|
35 | + * |
|
36 | + * @var int |
|
37 | + */ |
|
38 | + protected $is_required = true; |
|
39 | + |
|
40 | + /** |
|
41 | + * Are quantities allowed? |
|
42 | + * |
|
43 | + * @var int |
|
44 | + */ |
|
45 | + protected $allow_quantities = false; |
|
46 | + |
|
47 | + /** |
|
48 | + * Associated invoice. |
|
49 | + * |
|
50 | + * @var int |
|
51 | + */ |
|
52 | + public $invoice_id = 0; |
|
53 | + |
|
54 | + /** |
|
55 | + * Item discount. |
|
56 | + * |
|
57 | + * @var float |
|
58 | + */ |
|
59 | + public $item_discount = 0; |
|
60 | + |
|
61 | + /** |
|
62 | + * Recurring item discount. |
|
63 | + * |
|
64 | + * @var float |
|
65 | + */ |
|
66 | + public $recurring_item_discount = 0; |
|
67 | + |
|
68 | + /** |
|
69 | + * Item tax. |
|
70 | + * |
|
71 | + * @var float |
|
72 | + */ |
|
73 | + public $item_tax = 0; |
|
74 | 74 | |
75 | 75 | /* |
76 | 76 | |-------------------------------------------------------------------------- |
@@ -88,234 +88,234 @@ discard block |
||
88 | 88 | */ |
89 | 89 | |
90 | 90 | /** |
91 | - * Get the item name. |
|
92 | - * |
|
93 | - * @since 1.0.19 |
|
94 | - * @param string $context View or edit context. |
|
95 | - * @return string |
|
96 | - */ |
|
97 | - public function get_name( $context = 'view' ) { |
|
98 | - $name = parent::get_name( $context ); |
|
99 | - return $name . wpinv_get_item_suffix( $this ); |
|
100 | - } |
|
101 | - |
|
102 | - /** |
|
103 | - * Get the item name without a suffix. |
|
104 | - * |
|
105 | - * @since 1.0.19 |
|
106 | - * @param string $context View or edit context. |
|
107 | - * @return string |
|
108 | - */ |
|
109 | - public function get_raw_name( $context = 'view' ) { |
|
110 | - return parent::get_name( $context ); |
|
111 | - } |
|
112 | - |
|
113 | - /** |
|
114 | - * Get the item description. |
|
115 | - * |
|
116 | - * @since 1.0.19 |
|
117 | - * @param string $context View or edit context. |
|
118 | - * @return string |
|
119 | - */ |
|
120 | - public function get_description( $context = 'view' ) { |
|
121 | - |
|
122 | - if ( isset( $this->custom_description ) ) { |
|
123 | - return $this->custom_description; |
|
124 | - } |
|
125 | - |
|
126 | - return parent::get_description( $context ); |
|
127 | - } |
|
128 | - |
|
129 | - /** |
|
130 | - * Returns the sub total. |
|
131 | - * |
|
132 | - * @since 1.0.19 |
|
133 | - * @param string $context View or edit context. |
|
134 | - * @return float |
|
135 | - */ |
|
136 | - public function get_sub_total( $context = 'view' ) { |
|
137 | - return $this->get_quantity( $context ) * $this->get_initial_price( $context ); |
|
138 | - } |
|
139 | - |
|
140 | - /** |
|
141 | - * Returns the recurring sub total. |
|
142 | - * |
|
143 | - * @since 1.0.19 |
|
144 | - * @param string $context View or edit context. |
|
145 | - * @return float |
|
146 | - */ |
|
147 | - public function get_recurring_sub_total( $context = 'view' ) { |
|
148 | - |
|
149 | - if ( $this->is_recurring() ) { |
|
150 | - return $this->get_quantity( $context ) * $this->get_price( $context ); |
|
151 | - } |
|
152 | - |
|
153 | - return 0; |
|
154 | - } |
|
155 | - |
|
156 | - /** |
|
157 | - * @deprecated |
|
158 | - */ |
|
159 | - public function get_qantity( $context = 'view' ) { |
|
160 | - return $this->get_quantity( $context ); |
|
161 | - } |
|
162 | - |
|
163 | - /** |
|
164 | - * Get the item quantity. |
|
165 | - * |
|
166 | - * @since 1.0.19 |
|
167 | - * @param string $context View or edit context. |
|
168 | - * @return float |
|
169 | - */ |
|
170 | - public function get_quantity( $context = 'view' ) { |
|
171 | - $quantity = (float) $this->quantity; |
|
172 | - |
|
173 | - if ( empty( $quantity ) || 1 > $quantity ) { |
|
174 | - $quantity = 1; |
|
175 | - } |
|
176 | - |
|
177 | - if ( 'view' == $context ) { |
|
178 | - return apply_filters( 'getpaid_payment_form_item_quantity', $quantity, $this ); |
|
179 | - } |
|
180 | - |
|
181 | - return $quantity; |
|
182 | - |
|
183 | - } |
|
184 | - |
|
185 | - /** |
|
186 | - * Get the item meta data. |
|
187 | - * |
|
188 | - * @since 1.0.19 |
|
189 | - * @param string $context View or edit context. |
|
190 | - * @return meta |
|
191 | - */ |
|
192 | - public function get_item_meta( $context = 'view' ) { |
|
193 | - $meta = $this->meta; |
|
194 | - |
|
195 | - if ( 'view' == $context ) { |
|
196 | - return apply_filters( 'getpaid_payment_form_item_meta', $meta, $this ); |
|
197 | - } |
|
198 | - |
|
199 | - return $meta; |
|
200 | - |
|
201 | - } |
|
202 | - |
|
203 | - /** |
|
204 | - * Returns whether or not customers can update the item quantity. |
|
205 | - * |
|
206 | - * @since 1.0.19 |
|
207 | - * @param string $context View or edit context. |
|
208 | - * @return bool |
|
209 | - */ |
|
210 | - public function get_allow_quantities( $context = 'view' ) { |
|
211 | - $allow_quantities = (bool) $this->allow_quantities; |
|
212 | - |
|
213 | - if ( 'view' == $context ) { |
|
214 | - return apply_filters( 'getpaid_payment_form_item_allow_quantities', $allow_quantities, $this ); |
|
215 | - } |
|
216 | - |
|
217 | - return $allow_quantities; |
|
218 | - |
|
219 | - } |
|
220 | - |
|
221 | - /** |
|
222 | - * Returns whether or not the item is required. |
|
223 | - * |
|
224 | - * @since 1.0.19 |
|
225 | - * @param string $context View or edit context. |
|
226 | - * @return bool |
|
227 | - */ |
|
228 | - public function get_is_required( $context = 'view' ) { |
|
229 | - $is_required = (bool) $this->is_required; |
|
230 | - |
|
231 | - if ( 'view' == $context ) { |
|
232 | - return apply_filters( 'getpaid_payment_form_item_is_required', $is_required, $this ); |
|
233 | - } |
|
234 | - |
|
235 | - return $is_required; |
|
236 | - |
|
237 | - } |
|
238 | - |
|
239 | - /** |
|
240 | - * Prepares form data for use. |
|
241 | - * |
|
242 | - * @since 1.0.19 |
|
243 | - * @return array |
|
244 | - */ |
|
245 | - public function prepare_data_for_use( $required = null ) { |
|
246 | - |
|
247 | - $required = is_null( $required ) ? $this->is_required() : $required; |
|
248 | - return array( |
|
249 | - 'title' => strip_tags( $this->get_name() ), |
|
250 | - 'id' => $this->get_id(), |
|
251 | - 'price' => $this->get_price(), |
|
252 | - 'recurring' => $this->is_recurring(), |
|
253 | - 'description' => $this->get_description(), |
|
254 | - 'allow_quantities' => $this->allows_quantities(), |
|
255 | - 'required' => $required, |
|
256 | - ); |
|
257 | - |
|
258 | - } |
|
259 | - |
|
260 | - /** |
|
261 | - * Prepares form data for ajax use. |
|
262 | - * |
|
263 | - * @since 1.0.19 |
|
264 | - * @return array |
|
265 | - */ |
|
266 | - public function prepare_data_for_invoice_edit_ajax( $currency = '', $is_renewal = false ) { |
|
267 | - |
|
268 | - $description = getpaid_item_recurring_price_help_text( $this, $currency ); |
|
269 | - |
|
270 | - if ( $description ) { |
|
271 | - $description = "<div class='getpaid-subscription-help-text'>$description</div>"; |
|
272 | - } |
|
273 | - |
|
274 | - $price = ! $is_renewal ? $this->get_price() : $this->get_recurring_price(); |
|
275 | - $subtotal = ! $is_renewal ? $this->get_sub_total() : $this->get_recurring_sub_total(); |
|
276 | - return array( |
|
277 | - 'id' => $this->get_id(), |
|
278 | - 'texts' => array( |
|
279 | - 'item-name' => sanitize_text_field( $this->get_name() ), |
|
280 | - 'item-description' => wp_kses_post( $this->get_description() ) . $description, |
|
281 | - 'item-quantity' => floatval( $this->get_quantity() ), |
|
282 | - 'item-price' => wpinv_price( $price, $currency ), |
|
283 | - 'item-total' => wpinv_price( $subtotal, $currency ), |
|
284 | - ), |
|
285 | - 'inputs' => array( |
|
286 | - 'item-id' => $this->get_id(), |
|
287 | - 'item-name' => sanitize_text_field( $this->get_name() ), |
|
288 | - 'item-description' => wp_kses_post( $this->get_description() ), |
|
289 | - 'item-quantity' => floatval( $this->get_quantity() ), |
|
290 | - 'item-price' => $price, |
|
291 | - ) |
|
292 | - ); |
|
293 | - |
|
294 | - } |
|
295 | - |
|
296 | - /** |
|
297 | - * Prepares form data for saving (cart_details). |
|
298 | - * |
|
299 | - * @since 1.0.19 |
|
300 | - * @return array |
|
301 | - */ |
|
302 | - public function prepare_data_for_saving() { |
|
303 | - |
|
304 | - return array( |
|
305 | - 'post_id' => $this->invoice_id, |
|
306 | - 'item_id' => $this->get_id(), |
|
307 | - 'item_name' => sanitize_text_field( $this->get_raw_name() ), |
|
308 | - 'item_description' => $this->get_description(), |
|
309 | - 'tax' => $this->item_tax, |
|
310 | - 'item_price' => $this->get_price(), |
|
311 | - 'quantity' => (float) $this->get_quantity(), |
|
312 | - 'discount' => $this->item_discount, |
|
313 | - 'subtotal' => $this->get_sub_total(), |
|
314 | - 'price' => $this->get_sub_total() + $this->item_tax - $this->item_discount, |
|
315 | - 'meta' => $this->get_item_meta(), |
|
316 | - ); |
|
317 | - |
|
318 | - } |
|
91 | + * Get the item name. |
|
92 | + * |
|
93 | + * @since 1.0.19 |
|
94 | + * @param string $context View or edit context. |
|
95 | + * @return string |
|
96 | + */ |
|
97 | + public function get_name( $context = 'view' ) { |
|
98 | + $name = parent::get_name( $context ); |
|
99 | + return $name . wpinv_get_item_suffix( $this ); |
|
100 | + } |
|
101 | + |
|
102 | + /** |
|
103 | + * Get the item name without a suffix. |
|
104 | + * |
|
105 | + * @since 1.0.19 |
|
106 | + * @param string $context View or edit context. |
|
107 | + * @return string |
|
108 | + */ |
|
109 | + public function get_raw_name( $context = 'view' ) { |
|
110 | + return parent::get_name( $context ); |
|
111 | + } |
|
112 | + |
|
113 | + /** |
|
114 | + * Get the item description. |
|
115 | + * |
|
116 | + * @since 1.0.19 |
|
117 | + * @param string $context View or edit context. |
|
118 | + * @return string |
|
119 | + */ |
|
120 | + public function get_description( $context = 'view' ) { |
|
121 | + |
|
122 | + if ( isset( $this->custom_description ) ) { |
|
123 | + return $this->custom_description; |
|
124 | + } |
|
125 | + |
|
126 | + return parent::get_description( $context ); |
|
127 | + } |
|
128 | + |
|
129 | + /** |
|
130 | + * Returns the sub total. |
|
131 | + * |
|
132 | + * @since 1.0.19 |
|
133 | + * @param string $context View or edit context. |
|
134 | + * @return float |
|
135 | + */ |
|
136 | + public function get_sub_total( $context = 'view' ) { |
|
137 | + return $this->get_quantity( $context ) * $this->get_initial_price( $context ); |
|
138 | + } |
|
139 | + |
|
140 | + /** |
|
141 | + * Returns the recurring sub total. |
|
142 | + * |
|
143 | + * @since 1.0.19 |
|
144 | + * @param string $context View or edit context. |
|
145 | + * @return float |
|
146 | + */ |
|
147 | + public function get_recurring_sub_total( $context = 'view' ) { |
|
148 | + |
|
149 | + if ( $this->is_recurring() ) { |
|
150 | + return $this->get_quantity( $context ) * $this->get_price( $context ); |
|
151 | + } |
|
152 | + |
|
153 | + return 0; |
|
154 | + } |
|
155 | + |
|
156 | + /** |
|
157 | + * @deprecated |
|
158 | + */ |
|
159 | + public function get_qantity( $context = 'view' ) { |
|
160 | + return $this->get_quantity( $context ); |
|
161 | + } |
|
162 | + |
|
163 | + /** |
|
164 | + * Get the item quantity. |
|
165 | + * |
|
166 | + * @since 1.0.19 |
|
167 | + * @param string $context View or edit context. |
|
168 | + * @return float |
|
169 | + */ |
|
170 | + public function get_quantity( $context = 'view' ) { |
|
171 | + $quantity = (float) $this->quantity; |
|
172 | + |
|
173 | + if ( empty( $quantity ) || 1 > $quantity ) { |
|
174 | + $quantity = 1; |
|
175 | + } |
|
176 | + |
|
177 | + if ( 'view' == $context ) { |
|
178 | + return apply_filters( 'getpaid_payment_form_item_quantity', $quantity, $this ); |
|
179 | + } |
|
180 | + |
|
181 | + return $quantity; |
|
182 | + |
|
183 | + } |
|
184 | + |
|
185 | + /** |
|
186 | + * Get the item meta data. |
|
187 | + * |
|
188 | + * @since 1.0.19 |
|
189 | + * @param string $context View or edit context. |
|
190 | + * @return meta |
|
191 | + */ |
|
192 | + public function get_item_meta( $context = 'view' ) { |
|
193 | + $meta = $this->meta; |
|
194 | + |
|
195 | + if ( 'view' == $context ) { |
|
196 | + return apply_filters( 'getpaid_payment_form_item_meta', $meta, $this ); |
|
197 | + } |
|
198 | + |
|
199 | + return $meta; |
|
200 | + |
|
201 | + } |
|
202 | + |
|
203 | + /** |
|
204 | + * Returns whether or not customers can update the item quantity. |
|
205 | + * |
|
206 | + * @since 1.0.19 |
|
207 | + * @param string $context View or edit context. |
|
208 | + * @return bool |
|
209 | + */ |
|
210 | + public function get_allow_quantities( $context = 'view' ) { |
|
211 | + $allow_quantities = (bool) $this->allow_quantities; |
|
212 | + |
|
213 | + if ( 'view' == $context ) { |
|
214 | + return apply_filters( 'getpaid_payment_form_item_allow_quantities', $allow_quantities, $this ); |
|
215 | + } |
|
216 | + |
|
217 | + return $allow_quantities; |
|
218 | + |
|
219 | + } |
|
220 | + |
|
221 | + /** |
|
222 | + * Returns whether or not the item is required. |
|
223 | + * |
|
224 | + * @since 1.0.19 |
|
225 | + * @param string $context View or edit context. |
|
226 | + * @return bool |
|
227 | + */ |
|
228 | + public function get_is_required( $context = 'view' ) { |
|
229 | + $is_required = (bool) $this->is_required; |
|
230 | + |
|
231 | + if ( 'view' == $context ) { |
|
232 | + return apply_filters( 'getpaid_payment_form_item_is_required', $is_required, $this ); |
|
233 | + } |
|
234 | + |
|
235 | + return $is_required; |
|
236 | + |
|
237 | + } |
|
238 | + |
|
239 | + /** |
|
240 | + * Prepares form data for use. |
|
241 | + * |
|
242 | + * @since 1.0.19 |
|
243 | + * @return array |
|
244 | + */ |
|
245 | + public function prepare_data_for_use( $required = null ) { |
|
246 | + |
|
247 | + $required = is_null( $required ) ? $this->is_required() : $required; |
|
248 | + return array( |
|
249 | + 'title' => strip_tags( $this->get_name() ), |
|
250 | + 'id' => $this->get_id(), |
|
251 | + 'price' => $this->get_price(), |
|
252 | + 'recurring' => $this->is_recurring(), |
|
253 | + 'description' => $this->get_description(), |
|
254 | + 'allow_quantities' => $this->allows_quantities(), |
|
255 | + 'required' => $required, |
|
256 | + ); |
|
257 | + |
|
258 | + } |
|
259 | + |
|
260 | + /** |
|
261 | + * Prepares form data for ajax use. |
|
262 | + * |
|
263 | + * @since 1.0.19 |
|
264 | + * @return array |
|
265 | + */ |
|
266 | + public function prepare_data_for_invoice_edit_ajax( $currency = '', $is_renewal = false ) { |
|
267 | + |
|
268 | + $description = getpaid_item_recurring_price_help_text( $this, $currency ); |
|
269 | + |
|
270 | + if ( $description ) { |
|
271 | + $description = "<div class='getpaid-subscription-help-text'>$description</div>"; |
|
272 | + } |
|
273 | + |
|
274 | + $price = ! $is_renewal ? $this->get_price() : $this->get_recurring_price(); |
|
275 | + $subtotal = ! $is_renewal ? $this->get_sub_total() : $this->get_recurring_sub_total(); |
|
276 | + return array( |
|
277 | + 'id' => $this->get_id(), |
|
278 | + 'texts' => array( |
|
279 | + 'item-name' => sanitize_text_field( $this->get_name() ), |
|
280 | + 'item-description' => wp_kses_post( $this->get_description() ) . $description, |
|
281 | + 'item-quantity' => floatval( $this->get_quantity() ), |
|
282 | + 'item-price' => wpinv_price( $price, $currency ), |
|
283 | + 'item-total' => wpinv_price( $subtotal, $currency ), |
|
284 | + ), |
|
285 | + 'inputs' => array( |
|
286 | + 'item-id' => $this->get_id(), |
|
287 | + 'item-name' => sanitize_text_field( $this->get_name() ), |
|
288 | + 'item-description' => wp_kses_post( $this->get_description() ), |
|
289 | + 'item-quantity' => floatval( $this->get_quantity() ), |
|
290 | + 'item-price' => $price, |
|
291 | + ) |
|
292 | + ); |
|
293 | + |
|
294 | + } |
|
295 | + |
|
296 | + /** |
|
297 | + * Prepares form data for saving (cart_details). |
|
298 | + * |
|
299 | + * @since 1.0.19 |
|
300 | + * @return array |
|
301 | + */ |
|
302 | + public function prepare_data_for_saving() { |
|
303 | + |
|
304 | + return array( |
|
305 | + 'post_id' => $this->invoice_id, |
|
306 | + 'item_id' => $this->get_id(), |
|
307 | + 'item_name' => sanitize_text_field( $this->get_raw_name() ), |
|
308 | + 'item_description' => $this->get_description(), |
|
309 | + 'tax' => $this->item_tax, |
|
310 | + 'item_price' => $this->get_price(), |
|
311 | + 'quantity' => (float) $this->get_quantity(), |
|
312 | + 'discount' => $this->item_discount, |
|
313 | + 'subtotal' => $this->get_sub_total(), |
|
314 | + 'price' => $this->get_sub_total() + $this->item_tax - $this->item_discount, |
|
315 | + 'meta' => $this->get_item_meta(), |
|
316 | + ); |
|
317 | + |
|
318 | + } |
|
319 | 319 | |
320 | 320 | /* |
321 | 321 | |-------------------------------------------------------------------------- |
@@ -327,70 +327,70 @@ discard block |
||
327 | 327 | | object. |
328 | 328 | */ |
329 | 329 | |
330 | - /** |
|
331 | - * Set the item qantity. |
|
332 | - * |
|
333 | - * @since 1.0.19 |
|
334 | - * @param float $quantity The item quantity. |
|
335 | - */ |
|
336 | - public function set_quantity( $quantity ) { |
|
337 | - |
|
338 | - if ( empty( $quantity ) || ! is_numeric( $quantity ) ) { |
|
339 | - $quantity = 1; |
|
340 | - } |
|
341 | - |
|
342 | - $this->quantity = (float) $quantity; |
|
343 | - |
|
344 | - } |
|
345 | - |
|
346 | - /** |
|
347 | - * Set the item meta data. |
|
348 | - * |
|
349 | - * @since 1.0.19 |
|
350 | - * @param array $meta The item meta data. |
|
351 | - */ |
|
352 | - public function set_item_meta( $meta ) { |
|
353 | - $this->meta = maybe_unserialize( $meta ); |
|
354 | - } |
|
355 | - |
|
356 | - /** |
|
357 | - * Set whether or not the quantities are allowed. |
|
358 | - * |
|
359 | - * @since 1.0.19 |
|
360 | - * @param bool $allow_quantities |
|
361 | - */ |
|
362 | - public function set_allow_quantities( $allow_quantities ) { |
|
363 | - $this->allow_quantities = (bool) $allow_quantities; |
|
364 | - } |
|
365 | - |
|
366 | - /** |
|
367 | - * Set whether or not the item is required. |
|
368 | - * |
|
369 | - * @since 1.0.19 |
|
370 | - * @param bool $is_required |
|
371 | - */ |
|
372 | - public function set_is_required( $is_required ) { |
|
373 | - $this->is_required = (bool) $is_required; |
|
374 | - } |
|
375 | - |
|
376 | - /** |
|
377 | - * Sets the custom item description. |
|
378 | - * |
|
379 | - * @since 1.0.19 |
|
380 | - * @param string $description |
|
381 | - */ |
|
382 | - public function set_custom_description( $description ) { |
|
383 | - $this->custom_description = $description; |
|
384 | - } |
|
330 | + /** |
|
331 | + * Set the item qantity. |
|
332 | + * |
|
333 | + * @since 1.0.19 |
|
334 | + * @param float $quantity The item quantity. |
|
335 | + */ |
|
336 | + public function set_quantity( $quantity ) { |
|
337 | + |
|
338 | + if ( empty( $quantity ) || ! is_numeric( $quantity ) ) { |
|
339 | + $quantity = 1; |
|
340 | + } |
|
341 | + |
|
342 | + $this->quantity = (float) $quantity; |
|
343 | + |
|
344 | + } |
|
345 | + |
|
346 | + /** |
|
347 | + * Set the item meta data. |
|
348 | + * |
|
349 | + * @since 1.0.19 |
|
350 | + * @param array $meta The item meta data. |
|
351 | + */ |
|
352 | + public function set_item_meta( $meta ) { |
|
353 | + $this->meta = maybe_unserialize( $meta ); |
|
354 | + } |
|
355 | + |
|
356 | + /** |
|
357 | + * Set whether or not the quantities are allowed. |
|
358 | + * |
|
359 | + * @since 1.0.19 |
|
360 | + * @param bool $allow_quantities |
|
361 | + */ |
|
362 | + public function set_allow_quantities( $allow_quantities ) { |
|
363 | + $this->allow_quantities = (bool) $allow_quantities; |
|
364 | + } |
|
365 | + |
|
366 | + /** |
|
367 | + * Set whether or not the item is required. |
|
368 | + * |
|
369 | + * @since 1.0.19 |
|
370 | + * @param bool $is_required |
|
371 | + */ |
|
372 | + public function set_is_required( $is_required ) { |
|
373 | + $this->is_required = (bool) $is_required; |
|
374 | + } |
|
375 | + |
|
376 | + /** |
|
377 | + * Sets the custom item description. |
|
378 | + * |
|
379 | + * @since 1.0.19 |
|
380 | + * @param string $description |
|
381 | + */ |
|
382 | + public function set_custom_description( $description ) { |
|
383 | + $this->custom_description = $description; |
|
384 | + } |
|
385 | 385 | |
386 | 386 | /** |
387 | 387 | * We do not want to save items to the database. |
388 | 388 | * |
389 | - * @return int item id |
|
389 | + * @return int item id |
|
390 | 390 | */ |
391 | 391 | public function save( $data = array() ) { |
392 | 392 | return $this->get_id(); |
393 | - } |
|
393 | + } |
|
394 | 394 | |
395 | 395 | /* |
396 | 396 | |-------------------------------------------------------------------------- |
@@ -402,23 +402,23 @@ discard block |
||
402 | 402 | */ |
403 | 403 | |
404 | 404 | /** |
405 | - * Checks whether the item has enabled dynamic pricing. |
|
406 | - * |
|
407 | - * @since 1.0.19 |
|
408 | - * @return bool |
|
409 | - */ |
|
410 | - public function is_required() { |
|
405 | + * Checks whether the item has enabled dynamic pricing. |
|
406 | + * |
|
407 | + * @since 1.0.19 |
|
408 | + * @return bool |
|
409 | + */ |
|
410 | + public function is_required() { |
|
411 | 411 | return (bool) $this->get_is_required(); |
412 | - } |
|
413 | - |
|
414 | - /** |
|
415 | - * Checks whether users can edit the quantities. |
|
416 | - * |
|
417 | - * @since 1.0.19 |
|
418 | - * @return bool |
|
419 | - */ |
|
420 | - public function allows_quantities() { |
|
412 | + } |
|
413 | + |
|
414 | + /** |
|
415 | + * Checks whether users can edit the quantities. |
|
416 | + * |
|
417 | + * @since 1.0.19 |
|
418 | + * @return bool |
|
419 | + */ |
|
420 | + public function allows_quantities() { |
|
421 | 421 | return (bool) $this->get_allow_quantities(); |
422 | - } |
|
422 | + } |
|
423 | 423 | |
424 | 424 | } |
@@ -411,9 +411,9 @@ |
||
411 | 411 | $bill_times = $item->get_recurring_limit(); |
412 | 412 | |
413 | 413 | if ( ! empty( $bill_times ) ) { |
414 | - $bill_times = $item->get_recurring_interval() * $bill_times; |
|
415 | - $bill_times = getpaid_get_subscription_period_label( $item->get_recurring_period(), $bill_times ); |
|
416 | - } |
|
414 | + $bill_times = $item->get_recurring_interval() * $bill_times; |
|
415 | + $bill_times = getpaid_get_subscription_period_label( $item->get_recurring_period(), $bill_times ); |
|
416 | + } |
|
417 | 417 | |
418 | 418 | if ( $item instanceof GetPaid_Form_Item && false === $_initial_price ) { |
419 | 419 | $initial_price = wpinv_price( $item->get_sub_total(), $currency ); |
@@ -14,51 +14,51 @@ |
||
14 | 14 | */ |
15 | 15 | class GetPaid_Payment_Exception extends Exception { |
16 | 16 | |
17 | - /** |
|
18 | - * Sanitized error code. |
|
19 | - * |
|
20 | - * @var string |
|
21 | - */ |
|
22 | - protected $error_code; |
|
17 | + /** |
|
18 | + * Sanitized error code. |
|
19 | + * |
|
20 | + * @var string |
|
21 | + */ |
|
22 | + protected $error_code; |
|
23 | 23 | |
24 | - /** |
|
25 | - * Error extra data. |
|
26 | - * |
|
27 | - * @var array |
|
28 | - */ |
|
29 | - protected $error_data; |
|
24 | + /** |
|
25 | + * Error extra data. |
|
26 | + * |
|
27 | + * @var array |
|
28 | + */ |
|
29 | + protected $error_data; |
|
30 | 30 | |
31 | - /** |
|
32 | - * Setup exception. |
|
33 | - * |
|
34 | - * @param string $code Machine-readable error code, e.g `getpaid-discount-error`. |
|
35 | - * @param string $message User-friendly translated error message, e.g. 'Discount is invalid'. |
|
36 | - * @param int $http_status_code Proper HTTP status code to respond with, e.g. 400. |
|
37 | - * @param array $data Extra error data. |
|
38 | - */ |
|
39 | - public function __construct( $code, $message, $http_status_code = 400, $data = array() ) { |
|
40 | - $this->error_code = $code; |
|
41 | - $this->error_data = array_merge( array( 'status' => $http_status_code ), $data ); |
|
31 | + /** |
|
32 | + * Setup exception. |
|
33 | + * |
|
34 | + * @param string $code Machine-readable error code, e.g `getpaid-discount-error`. |
|
35 | + * @param string $message User-friendly translated error message, e.g. 'Discount is invalid'. |
|
36 | + * @param int $http_status_code Proper HTTP status code to respond with, e.g. 400. |
|
37 | + * @param array $data Extra error data. |
|
38 | + */ |
|
39 | + public function __construct( $code, $message, $http_status_code = 400, $data = array() ) { |
|
40 | + $this->error_code = $code; |
|
41 | + $this->error_data = array_merge( array( 'status' => $http_status_code ), $data ); |
|
42 | 42 | |
43 | - parent::__construct( $message, $http_status_code ); |
|
44 | - } |
|
43 | + parent::__construct( $message, $http_status_code ); |
|
44 | + } |
|
45 | 45 | |
46 | - /** |
|
47 | - * Returns the error code. |
|
48 | - * |
|
49 | - * @return string |
|
50 | - */ |
|
51 | - public function getErrorCode() { |
|
52 | - return $this->error_code; |
|
53 | - } |
|
46 | + /** |
|
47 | + * Returns the error code. |
|
48 | + * |
|
49 | + * @return string |
|
50 | + */ |
|
51 | + public function getErrorCode() { |
|
52 | + return $this->error_code; |
|
53 | + } |
|
54 | 54 | |
55 | - /** |
|
56 | - * Returns error data. |
|
57 | - * |
|
58 | - * @return array |
|
59 | - */ |
|
60 | - public function getErrorData() { |
|
61 | - return $this->error_data; |
|
62 | - } |
|
55 | + /** |
|
56 | + * Returns error data. |
|
57 | + * |
|
58 | + * @return array |
|
59 | + */ |
|
60 | + public function getErrorData() { |
|
61 | + return $this->error_data; |
|
62 | + } |
|
63 | 63 | |
64 | 64 | } |
@@ -12,162 +12,162 @@ |
||
12 | 12 | */ |
13 | 13 | class GetPaid_Payment_Form_Submission_Discount { |
14 | 14 | |
15 | - /** |
|
16 | - * Submission discounts. |
|
17 | - * @var array |
|
18 | - */ |
|
19 | - public $discounts = array(); |
|
15 | + /** |
|
16 | + * Submission discounts. |
|
17 | + * @var array |
|
18 | + */ |
|
19 | + public $discounts = array(); |
|
20 | + |
|
21 | + /** |
|
22 | + * Class constructor |
|
23 | + * |
|
24 | + * @param GetPaid_Payment_Form_Submission $submission |
|
25 | + * @param float $initial_total |
|
26 | + * @param float $recurring_total |
|
27 | + */ |
|
28 | + public function __construct( $submission, $initial_total, $recurring_total ) { |
|
29 | + |
|
30 | + // Process any existing invoice discounts. |
|
31 | + if ( $submission->has_invoice() ) { |
|
32 | + $this->discounts = $submission->get_invoice()->get_discounts(); |
|
33 | + } |
|
34 | + |
|
35 | + // Do we have a discount? |
|
36 | + $discount = $submission->get_field( 'discount' ); |
|
37 | + |
|
38 | + if ( empty( $discount ) ) { |
|
39 | + |
|
40 | + if ( isset( $this->discounts['discount_code'] ) ) { |
|
41 | + unset( $this->discounts['discount_code'] ); |
|
42 | + } |
|
43 | + |
|
44 | + return; |
|
45 | + } |
|
46 | + |
|
47 | + // Processes the discount code. |
|
48 | + $amount = max( $initial_total, $recurring_total ); |
|
49 | + $this->process_discount( $submission, $discount, $amount ); |
|
50 | + |
|
51 | + } |
|
20 | 52 | |
21 | 53 | /** |
22 | - * Class constructor |
|
23 | - * |
|
24 | - * @param GetPaid_Payment_Form_Submission $submission |
|
25 | - * @param float $initial_total |
|
26 | - * @param float $recurring_total |
|
27 | - */ |
|
28 | - public function __construct( $submission, $initial_total, $recurring_total ) { |
|
29 | - |
|
30 | - // Process any existing invoice discounts. |
|
31 | - if ( $submission->has_invoice() ) { |
|
32 | - $this->discounts = $submission->get_invoice()->get_discounts(); |
|
33 | - } |
|
34 | - |
|
35 | - // Do we have a discount? |
|
36 | - $discount = $submission->get_field( 'discount' ); |
|
37 | - |
|
38 | - if ( empty( $discount ) ) { |
|
39 | - |
|
40 | - if ( isset( $this->discounts['discount_code'] ) ) { |
|
41 | - unset( $this->discounts['discount_code'] ); |
|
42 | - } |
|
43 | - |
|
44 | - return; |
|
45 | - } |
|
46 | - |
|
47 | - // Processes the discount code. |
|
48 | - $amount = max( $initial_total, $recurring_total ); |
|
49 | - $this->process_discount( $submission, $discount, $amount ); |
|
50 | - |
|
51 | - } |
|
52 | - |
|
53 | - /** |
|
54 | - * Processes a submission discount. |
|
55 | - * |
|
56 | - * @param GetPaid_Payment_Form_Submission $submission |
|
57 | - * @param string $discount |
|
58 | - * @param float $amount |
|
59 | - */ |
|
60 | - public function process_discount( $submission, $discount, $amount ) { |
|
61 | - |
|
62 | - // Fetch the discount. |
|
63 | - $discount = new WPInv_Discount( $discount ); |
|
64 | - |
|
65 | - // Ensure it is active. |
|
54 | + * Processes a submission discount. |
|
55 | + * |
|
56 | + * @param GetPaid_Payment_Form_Submission $submission |
|
57 | + * @param string $discount |
|
58 | + * @param float $amount |
|
59 | + */ |
|
60 | + public function process_discount( $submission, $discount, $amount ) { |
|
61 | + |
|
62 | + // Fetch the discount. |
|
63 | + $discount = new WPInv_Discount( $discount ); |
|
64 | + |
|
65 | + // Ensure it is active. |
|
66 | 66 | if ( ! $this->is_discount_active( $discount ) ) { |
67 | - throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'Invalid or expired discount code', 'invoicing' ) ); |
|
68 | - } |
|
69 | - |
|
70 | - // Exceeded limit. |
|
71 | - if ( $discount->has_exceeded_limit() ) { |
|
72 | - throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'This discount code has been used up', 'invoicing' ) ); |
|
73 | - } |
|
74 | - |
|
75 | - // Validate usages. |
|
76 | - $this->validate_single_use_discount( $submission, $discount ); |
|
77 | - |
|
78 | - // Validate amount. |
|
79 | - $this->validate_discount_amount( $submission, $discount, $amount ); |
|
80 | - |
|
81 | - // Save the discount. |
|
82 | - $this->discounts['discount_code'] = $this->calculate_discount( $submission, $discount ); |
|
83 | - } |
|
84 | - |
|
85 | - /** |
|
86 | - * Validates a single use discount. |
|
87 | - * |
|
88 | - * @param WPInv_Discount $discount |
|
89 | - * @return bool |
|
90 | - */ |
|
91 | - public function is_discount_active( $discount ) { |
|
92 | - return $discount->exists() && $discount->is_active() && $discount->has_started() && ! $discount->is_expired(); |
|
93 | - } |
|
94 | - |
|
95 | - /** |
|
96 | - * Returns a user's id or email. |
|
97 | - * |
|
98 | - * @param string $email |
|
99 | - * @return int|string|false |
|
100 | - */ |
|
101 | - public function get_user_id_or_email( $email ) { |
|
102 | - |
|
103 | - if ( is_user_logged_in() ) { |
|
104 | - return get_current_user_id(); |
|
105 | - } |
|
106 | - |
|
107 | - return empty( $email ) ? false : sanitize_email( $email ); |
|
108 | - } |
|
109 | - |
|
110 | - /** |
|
111 | - * Validates a single use discount. |
|
112 | - * |
|
113 | - * @param GetPaid_Payment_Form_Submission $submission |
|
114 | - * @param WPInv_Discount $discount |
|
115 | - */ |
|
116 | - public function validate_single_use_discount( $submission, $discount ) { |
|
117 | - |
|
118 | - // Abort if it is not a single use discount. |
|
119 | - if ( ! $discount->is_single_use() ) { |
|
120 | - return; |
|
121 | - } |
|
122 | - |
|
123 | - // Ensure there is a valid billing email. |
|
124 | - $user = $this->get_user_id_or_email( $submission->get_billing_email() ); |
|
125 | - |
|
126 | - if ( empty( $user ) ) { |
|
127 | - throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'You need to either log in or enter your billing email before applying this discount', 'invoicing' ) ); |
|
128 | - } |
|
129 | - |
|
130 | - // Has the user used this discount code before? |
|
131 | - if ( ! $discount->is_valid_for_user( $user ) ) { |
|
132 | - throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'You have already used this discount', 'invoicing' ) ); |
|
133 | - } |
|
134 | - |
|
135 | - } |
|
136 | - |
|
137 | - /** |
|
138 | - * Validates the discount's amount. |
|
139 | - * |
|
140 | - * @param GetPaid_Payment_Form_Submission $submission |
|
141 | - * @param WPInv_Discount $discount |
|
142 | - * @param float $amount |
|
143 | - */ |
|
144 | - public function validate_discount_amount( $submission, $discount, $amount ) { |
|
145 | - |
|
146 | - // Validate minimum amount. |
|
147 | - if ( ! $discount->is_minimum_amount_met( $amount ) ) { |
|
148 | - $min = wpinv_price( $discount->get_minimum_total(), $submission->get_currency() ); |
|
149 | - throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', sprintf( __( 'The minimum total for using this discount is %s', 'invoicing' ), $min ) ); |
|
150 | - } |
|
151 | - |
|
152 | - // Validate the maximum amount. |
|
153 | - if ( ! $discount->is_maximum_amount_met( $amount ) ) { |
|
154 | - $max = wpinv_price( $discount->get_maximum_total(), $submission->get_currency() ); |
|
155 | - throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', sprintf( __( 'The maximum total for using this discount is %s', 'invoicing' ), $max ) ); |
|
156 | - } |
|
157 | - |
|
158 | - } |
|
159 | - |
|
160 | - /** |
|
161 | - * Calculates the discount code's amount. |
|
162 | - * |
|
163 | - * Ensure that the discount exists and has been validated before calling this method. |
|
164 | - * |
|
165 | - * @param GetPaid_Payment_Form_Submission $submission |
|
166 | - * @param WPInv_Discount $discount |
|
167 | - * @return array |
|
168 | - */ |
|
169 | - public function calculate_discount( $submission, $discount ) { |
|
170 | - return getpaid_calculate_invoice_discount( $submission, $discount ); |
|
171 | - } |
|
67 | + throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'Invalid or expired discount code', 'invoicing' ) ); |
|
68 | + } |
|
69 | + |
|
70 | + // Exceeded limit. |
|
71 | + if ( $discount->has_exceeded_limit() ) { |
|
72 | + throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'This discount code has been used up', 'invoicing' ) ); |
|
73 | + } |
|
74 | + |
|
75 | + // Validate usages. |
|
76 | + $this->validate_single_use_discount( $submission, $discount ); |
|
77 | + |
|
78 | + // Validate amount. |
|
79 | + $this->validate_discount_amount( $submission, $discount, $amount ); |
|
80 | + |
|
81 | + // Save the discount. |
|
82 | + $this->discounts['discount_code'] = $this->calculate_discount( $submission, $discount ); |
|
83 | + } |
|
84 | + |
|
85 | + /** |
|
86 | + * Validates a single use discount. |
|
87 | + * |
|
88 | + * @param WPInv_Discount $discount |
|
89 | + * @return bool |
|
90 | + */ |
|
91 | + public function is_discount_active( $discount ) { |
|
92 | + return $discount->exists() && $discount->is_active() && $discount->has_started() && ! $discount->is_expired(); |
|
93 | + } |
|
94 | + |
|
95 | + /** |
|
96 | + * Returns a user's id or email. |
|
97 | + * |
|
98 | + * @param string $email |
|
99 | + * @return int|string|false |
|
100 | + */ |
|
101 | + public function get_user_id_or_email( $email ) { |
|
102 | + |
|
103 | + if ( is_user_logged_in() ) { |
|
104 | + return get_current_user_id(); |
|
105 | + } |
|
106 | + |
|
107 | + return empty( $email ) ? false : sanitize_email( $email ); |
|
108 | + } |
|
109 | + |
|
110 | + /** |
|
111 | + * Validates a single use discount. |
|
112 | + * |
|
113 | + * @param GetPaid_Payment_Form_Submission $submission |
|
114 | + * @param WPInv_Discount $discount |
|
115 | + */ |
|
116 | + public function validate_single_use_discount( $submission, $discount ) { |
|
117 | + |
|
118 | + // Abort if it is not a single use discount. |
|
119 | + if ( ! $discount->is_single_use() ) { |
|
120 | + return; |
|
121 | + } |
|
122 | + |
|
123 | + // Ensure there is a valid billing email. |
|
124 | + $user = $this->get_user_id_or_email( $submission->get_billing_email() ); |
|
125 | + |
|
126 | + if ( empty( $user ) ) { |
|
127 | + throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'You need to either log in or enter your billing email before applying this discount', 'invoicing' ) ); |
|
128 | + } |
|
129 | + |
|
130 | + // Has the user used this discount code before? |
|
131 | + if ( ! $discount->is_valid_for_user( $user ) ) { |
|
132 | + throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', __( 'You have already used this discount', 'invoicing' ) ); |
|
133 | + } |
|
134 | + |
|
135 | + } |
|
136 | + |
|
137 | + /** |
|
138 | + * Validates the discount's amount. |
|
139 | + * |
|
140 | + * @param GetPaid_Payment_Form_Submission $submission |
|
141 | + * @param WPInv_Discount $discount |
|
142 | + * @param float $amount |
|
143 | + */ |
|
144 | + public function validate_discount_amount( $submission, $discount, $amount ) { |
|
145 | + |
|
146 | + // Validate minimum amount. |
|
147 | + if ( ! $discount->is_minimum_amount_met( $amount ) ) { |
|
148 | + $min = wpinv_price( $discount->get_minimum_total(), $submission->get_currency() ); |
|
149 | + throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', sprintf( __( 'The minimum total for using this discount is %s', 'invoicing' ), $min ) ); |
|
150 | + } |
|
151 | + |
|
152 | + // Validate the maximum amount. |
|
153 | + if ( ! $discount->is_maximum_amount_met( $amount ) ) { |
|
154 | + $max = wpinv_price( $discount->get_maximum_total(), $submission->get_currency() ); |
|
155 | + throw new GetPaid_Payment_Exception( '.getpaid-discount-field .getpaid-custom-payment-form-errors', sprintf( __( 'The maximum total for using this discount is %s', 'invoicing' ), $max ) ); |
|
156 | + } |
|
157 | + |
|
158 | + } |
|
159 | + |
|
160 | + /** |
|
161 | + * Calculates the discount code's amount. |
|
162 | + * |
|
163 | + * Ensure that the discount exists and has been validated before calling this method. |
|
164 | + * |
|
165 | + * @param GetPaid_Payment_Form_Submission $submission |
|
166 | + * @param WPInv_Discount $discount |
|
167 | + * @return array |
|
168 | + */ |
|
169 | + public function calculate_discount( $submission, $discount ) { |
|
170 | + return getpaid_calculate_invoice_discount( $submission, $discount ); |
|
171 | + } |
|
172 | 172 | |
173 | 173 | } |
@@ -12,294 +12,294 @@ |
||
12 | 12 | */ |
13 | 13 | class GetPaid_Reports_Helper { |
14 | 14 | |
15 | - /** |
|
16 | - * Get report totals such as invoice totals and discount amounts. |
|
17 | - * |
|
18 | - * Data example: |
|
19 | - * |
|
20 | - * 'subtotal' => array( |
|
21 | - * 'type' => 'invoice_data', |
|
22 | - * 'function' => 'SUM', |
|
23 | - * 'name' => 'subtotal' |
|
24 | - * ) |
|
25 | - * |
|
26 | - * @param array $args |
|
27 | - * @return mixed depending on query_type |
|
28 | - */ |
|
29 | - public static function get_invoice_report_data( $args = array() ) { |
|
30 | - global $wpdb; |
|
31 | - |
|
32 | - $default_args = array( |
|
33 | - 'data' => array(), // The data to retrieve. |
|
34 | - 'where' => array(), // An array of where queries. |
|
35 | - 'query_type' => 'get_row', // wpdb query to run. |
|
36 | - 'group_by' => '', // What to group results by. |
|
37 | - 'order_by' => '', // What to order by. |
|
38 | - 'limit' => '', // Results limit. |
|
39 | - 'filter_range' => array(), // An array of before and after dates to limit results by. |
|
40 | - 'invoice_types' => array( 'wpi_invoice' ), // An array of post types to retrieve. |
|
41 | - 'invoice_status' => array( 'publish', 'wpi-processing', 'wpi-onhold' ), |
|
42 | - 'parent_invoice_status' => false, // Optionally filter by parent invoice status. |
|
43 | - ); |
|
44 | - |
|
45 | - $args = apply_filters( 'getpaid_reports_get_invoice_report_data_args', $args ); |
|
46 | - $args = wp_parse_args( $args, $default_args ); |
|
47 | - |
|
48 | - extract( $args ); |
|
49 | - |
|
50 | - if ( empty( $data ) ) { |
|
51 | - return ''; |
|
52 | - } |
|
53 | - |
|
54 | - $query = array(); |
|
55 | - $query['select'] = 'SELECT ' . implode( ',', self::prepare_invoice_data( $data ) ); |
|
56 | - $query['from'] = "FROM {$wpdb->posts} AS posts"; |
|
57 | - $query['join'] = implode( ' ', self::prepare_invoice_joins( $data + $where, ! empty( $parent_invoice_status ) ) ); |
|
58 | - |
|
59 | - $query['where'] = " |
|
15 | + /** |
|
16 | + * Get report totals such as invoice totals and discount amounts. |
|
17 | + * |
|
18 | + * Data example: |
|
19 | + * |
|
20 | + * 'subtotal' => array( |
|
21 | + * 'type' => 'invoice_data', |
|
22 | + * 'function' => 'SUM', |
|
23 | + * 'name' => 'subtotal' |
|
24 | + * ) |
|
25 | + * |
|
26 | + * @param array $args |
|
27 | + * @return mixed depending on query_type |
|
28 | + */ |
|
29 | + public static function get_invoice_report_data( $args = array() ) { |
|
30 | + global $wpdb; |
|
31 | + |
|
32 | + $default_args = array( |
|
33 | + 'data' => array(), // The data to retrieve. |
|
34 | + 'where' => array(), // An array of where queries. |
|
35 | + 'query_type' => 'get_row', // wpdb query to run. |
|
36 | + 'group_by' => '', // What to group results by. |
|
37 | + 'order_by' => '', // What to order by. |
|
38 | + 'limit' => '', // Results limit. |
|
39 | + 'filter_range' => array(), // An array of before and after dates to limit results by. |
|
40 | + 'invoice_types' => array( 'wpi_invoice' ), // An array of post types to retrieve. |
|
41 | + 'invoice_status' => array( 'publish', 'wpi-processing', 'wpi-onhold' ), |
|
42 | + 'parent_invoice_status' => false, // Optionally filter by parent invoice status. |
|
43 | + ); |
|
44 | + |
|
45 | + $args = apply_filters( 'getpaid_reports_get_invoice_report_data_args', $args ); |
|
46 | + $args = wp_parse_args( $args, $default_args ); |
|
47 | + |
|
48 | + extract( $args ); |
|
49 | + |
|
50 | + if ( empty( $data ) ) { |
|
51 | + return ''; |
|
52 | + } |
|
53 | + |
|
54 | + $query = array(); |
|
55 | + $query['select'] = 'SELECT ' . implode( ',', self::prepare_invoice_data( $data ) ); |
|
56 | + $query['from'] = "FROM {$wpdb->posts} AS posts"; |
|
57 | + $query['join'] = implode( ' ', self::prepare_invoice_joins( $data + $where, ! empty( $parent_invoice_status ) ) ); |
|
58 | + |
|
59 | + $query['where'] = " |
|
60 | 60 | WHERE posts.post_type IN ( '" . implode( "','", $invoice_types ) . "' ) |
61 | 61 | "; |
62 | 62 | |
63 | - if ( ! empty( $invoice_status ) ) { |
|
64 | - $query['where'] .= " |
|
63 | + if ( ! empty( $invoice_status ) ) { |
|
64 | + $query['where'] .= " |
|
65 | 65 | AND posts.post_status IN ( '" . implode( "','", $invoice_status ) . "' ) |
66 | 66 | "; |
67 | - } |
|
68 | - |
|
69 | - if ( ! empty( $parent_invoice_status ) ) { |
|
70 | - if ( ! empty( $invoice_status ) ) { |
|
71 | - $query['where'] .= " AND ( parent.post_status IN ( '" . implode( "','", $parent_invoice_status ) . "' ) OR parent.ID IS NULL ) "; |
|
72 | - } else { |
|
73 | - $query['where'] .= " AND parent.post_status IN ( '" . implode( "','", $parent_invoice_status ) . "' ) "; |
|
74 | - } |
|
75 | - } |
|
76 | - |
|
77 | - if ( ! empty( $filter_range['before'] ) ) { |
|
78 | - $query['where'] .= " |
|
67 | + } |
|
68 | + |
|
69 | + if ( ! empty( $parent_invoice_status ) ) { |
|
70 | + if ( ! empty( $invoice_status ) ) { |
|
71 | + $query['where'] .= " AND ( parent.post_status IN ( '" . implode( "','", $parent_invoice_status ) . "' ) OR parent.ID IS NULL ) "; |
|
72 | + } else { |
|
73 | + $query['where'] .= " AND parent.post_status IN ( '" . implode( "','", $parent_invoice_status ) . "' ) "; |
|
74 | + } |
|
75 | + } |
|
76 | + |
|
77 | + if ( ! empty( $filter_range['before'] ) ) { |
|
78 | + $query['where'] .= " |
|
79 | 79 | AND posts.post_date < '" . date( 'Y-m-d H:i:s', strtotime( $filter_range['before'] ) ) . "' |
80 | 80 | "; |
81 | - } |
|
81 | + } |
|
82 | 82 | |
83 | - if ( ! empty( $filter_range['after'] ) ) { |
|
84 | - $query['where'] .= " |
|
83 | + if ( ! empty( $filter_range['after'] ) ) { |
|
84 | + $query['where'] .= " |
|
85 | 85 | AND posts.post_date > '" . date( 'Y-m-d H:i:s', strtotime( $filter_range['after'] ) ) . "' |
86 | 86 | "; |
87 | - } |
|
87 | + } |
|
88 | 88 | |
89 | - if ( ! empty( $where ) ) { |
|
89 | + if ( ! empty( $where ) ) { |
|
90 | 90 | |
91 | - foreach ( $where as $value ) { |
|
91 | + foreach ( $where as $value ) { |
|
92 | 92 | |
93 | - if ( strtolower( $value['operator'] ) == 'in' || strtolower( $value['operator'] ) == 'not in' ) { |
|
94 | - |
|
95 | - if ( is_array( $value['value'] ) ) { |
|
96 | - $value['value'] = implode( "','", $value['value'] ); |
|
97 | - } |
|
98 | - |
|
99 | - if ( ! empty( $value['value'] ) ) { |
|
100 | - $where_value = "{$value['operator']} ('{$value['value']}')"; |
|
101 | - } |
|
102 | - } else { |
|
103 | - $where_value = "{$value['operator']} '{$value['value']}'"; |
|
104 | - } |
|
105 | - |
|
106 | - if ( ! empty( $where_value ) ) { |
|
107 | - $query['where'] .= " AND {$value['key']} {$where_value}"; |
|
108 | - } |
|
109 | - } |
|
110 | - } |
|
111 | - |
|
112 | - if ( $group_by ) { |
|
113 | - $query['group_by'] = "GROUP BY {$group_by}"; |
|
114 | - } |
|
115 | - |
|
116 | - if ( $order_by ) { |
|
117 | - $query['order_by'] = "ORDER BY {$order_by}"; |
|
118 | - } |
|
119 | - |
|
120 | - if ( $limit ) { |
|
121 | - $query['limit'] = "LIMIT {$limit}"; |
|
122 | - } |
|
123 | - |
|
124 | - $query = apply_filters( 'getpaid_reports_get_invoice_report_query', $query, $data ); |
|
125 | - $query = implode( ' ', $query ); |
|
126 | - |
|
127 | - return self::execute( $query_type, $query ); |
|
128 | - |
|
129 | - } |
|
130 | - |
|
131 | - /** |
|
132 | - * Prepares the data to select. |
|
133 | - * |
|
134 | - * |
|
135 | - * @param array $data |
|
136 | - * @return array |
|
137 | - */ |
|
138 | - public static function prepare_invoice_data( $data ) { |
|
139 | - |
|
140 | - $prepared = array(); |
|
141 | - |
|
142 | - foreach ( $data as $raw_key => $value ) { |
|
143 | - $key = sanitize_key( $raw_key ); |
|
144 | - $distinct = ''; |
|
145 | - |
|
146 | - if ( isset( $value['distinct'] ) ) { |
|
147 | - $distinct = 'DISTINCT'; |
|
148 | - } |
|
149 | - |
|
150 | - $get_key = self::get_invoice_table_key( $key, $value['type'] ); |
|
151 | - |
|
152 | - if ( false === $get_key ) { |
|
153 | - // Skip to the next foreach iteration else the query will be invalid. |
|
154 | - continue; |
|
155 | - } |
|
156 | - |
|
157 | - if ( ! empty( $value['function'] ) ) { |
|
158 | - $get = "{$value['function']}({$distinct} {$get_key})"; |
|
159 | - } else { |
|
160 | - $get = "{$distinct} {$get_key}"; |
|
161 | - } |
|
162 | - |
|
163 | - $prepared[] = "{$get} as {$value['name']}"; |
|
164 | - } |
|
165 | - |
|
166 | - return $prepared; |
|
167 | - |
|
168 | - } |
|
169 | - |
|
170 | - /** |
|
171 | - * Prepares the joins to use. |
|
172 | - * |
|
173 | - * |
|
174 | - * @param array $data |
|
175 | - * @param bool $with_parent |
|
176 | - * @return array |
|
177 | - */ |
|
178 | - public static function prepare_invoice_joins( $data, $with_parent ) { |
|
179 | - global $wpdb; |
|
180 | - |
|
181 | - $prepared = array(); |
|
182 | - |
|
183 | - foreach ( $data as $raw_key => $value ) { |
|
184 | - $join_type = isset( $value['join_type'] ) ? $value['join_type'] : 'INNER'; |
|
185 | - $type = isset( $value['type'] ) ? $value['type'] : false; |
|
186 | - $key = sanitize_key( $raw_key ); |
|
187 | - |
|
188 | - switch ( $type ) { |
|
189 | - case 'meta': |
|
190 | - $prepared[ "meta_{$key}" ] = "{$join_type} JOIN {$wpdb->postmeta} AS meta_{$key} ON ( posts.ID = meta_{$key}.post_id AND meta_{$key}.meta_key = '{$raw_key}' )"; |
|
191 | - break; |
|
192 | - case 'parent_meta': |
|
193 | - $prepared[ "parent_meta_{$key}" ] = "{$join_type} JOIN {$wpdb->postmeta} AS parent_meta_{$key} ON (posts.post_parent = parent_meta_{$key}.post_id) AND (parent_meta_{$key}.meta_key = '{$raw_key}')"; |
|
194 | - break; |
|
195 | - case 'invoice_data': |
|
196 | - $prepared['invoices'] = "{$join_type} JOIN {$wpdb->prefix}getpaid_invoices AS invoices ON posts.ID = invoices.post_id"; |
|
197 | - break; |
|
198 | - case 'invoice_item': |
|
199 | - $prepared['invoice_items'] = "{$join_type} JOIN {$wpdb->prefix}getpaid_invoice_items AS invoice_items ON posts.ID = invoice_items.post_id"; |
|
200 | - break; |
|
201 | - } |
|
202 | - } |
|
203 | - |
|
204 | - if ( $with_parent ) { |
|
205 | - $prepared['parent'] = "LEFT JOIN {$wpdb->posts} AS parent ON posts.post_parent = parent.ID"; |
|
206 | - } |
|
207 | - |
|
208 | - return $prepared; |
|
209 | - |
|
210 | - } |
|
211 | - |
|
212 | - /** |
|
213 | - * Retrieves the appropriate table key to use. |
|
214 | - * |
|
215 | - * |
|
216 | - * @param string $key |
|
217 | - * @param string $table |
|
218 | - * @return string|false |
|
219 | - */ |
|
220 | - public static function get_invoice_table_key( $key, $table ) { |
|
221 | - |
|
222 | - $keys = array( |
|
223 | - 'meta' => "meta_{$key}.meta_value", |
|
224 | - 'parent_meta' => "parent_meta_{$key}.meta_value", |
|
225 | - 'post_data' => "posts.{$key}", |
|
226 | - 'invoice_data' => "invoices.{$key}", |
|
227 | - 'invoice_item' => "invoice_items.{$key}", |
|
228 | - ); |
|
229 | - |
|
230 | - return isset( $keys[ $table ] ) ? $keys[ $table ] : false; |
|
231 | - |
|
232 | - } |
|
233 | - |
|
234 | - /** |
|
235 | - * Executes a query and caches the result for a minute. |
|
236 | - * |
|
237 | - * |
|
238 | - * @param string $query_type |
|
239 | - * @param string $query |
|
240 | - * @return mixed depending on query_type |
|
241 | - */ |
|
242 | - public static function execute( $query_type, $query ) { |
|
243 | - global $wpdb; |
|
244 | - |
|
245 | - $query_hash = md5( $query_type . $query ); |
|
246 | - $result = self::get_cached_query( $query_hash ); |
|
247 | - if ( $result === false ) { |
|
248 | - self::enable_big_selects(); |
|
249 | - |
|
250 | - $result = $wpdb->$query_type( $query ); |
|
251 | - self::set_cached_query( $query_hash, $result ); |
|
252 | - } |
|
253 | - |
|
254 | - return $result; |
|
255 | - |
|
256 | - } |
|
257 | - |
|
258 | - /** |
|
259 | - * Enables big mysql selects for reports, just once for this session. |
|
260 | - */ |
|
261 | - protected static function enable_big_selects() { |
|
262 | - static $big_selects = false; |
|
263 | - |
|
264 | - global $wpdb; |
|
265 | - |
|
266 | - if ( ! $big_selects ) { |
|
267 | - $wpdb->query( 'SET SESSION SQL_BIG_SELECTS=1' ); |
|
268 | - $big_selects = true; |
|
269 | - } |
|
270 | - } |
|
271 | - |
|
272 | - /** |
|
273 | - * Get the cached query result or null if it's not in the cache. |
|
274 | - * |
|
275 | - * @param string $query_hash The query hash. |
|
276 | - * |
|
277 | - * @return mixed|false The cache contents on success, false on failure to retrieve contents. |
|
278 | - */ |
|
279 | - protected static function get_cached_query( $query_hash ) { |
|
280 | - |
|
281 | - return wp_cache_get( |
|
282 | - $query_hash, |
|
283 | - strtolower( __CLASS__ ) |
|
284 | - ); |
|
285 | - |
|
286 | - } |
|
287 | - |
|
288 | - /** |
|
289 | - * Set the cached query result. |
|
290 | - * |
|
291 | - * @param string $query_hash The query hash. |
|
292 | - * @param mixed $data The data to cache. |
|
293 | - */ |
|
294 | - protected static function set_cached_query( $query_hash, $data ) { |
|
295 | - |
|
296 | - wp_cache_set( |
|
297 | - $query_hash, |
|
298 | - $data, |
|
299 | - strtolower( __CLASS__ ), |
|
300 | - MINUTE_IN_SECONDS |
|
301 | - ); |
|
302 | - |
|
303 | - } |
|
93 | + if ( strtolower( $value['operator'] ) == 'in' || strtolower( $value['operator'] ) == 'not in' ) { |
|
94 | + |
|
95 | + if ( is_array( $value['value'] ) ) { |
|
96 | + $value['value'] = implode( "','", $value['value'] ); |
|
97 | + } |
|
98 | + |
|
99 | + if ( ! empty( $value['value'] ) ) { |
|
100 | + $where_value = "{$value['operator']} ('{$value['value']}')"; |
|
101 | + } |
|
102 | + } else { |
|
103 | + $where_value = "{$value['operator']} '{$value['value']}'"; |
|
104 | + } |
|
105 | + |
|
106 | + if ( ! empty( $where_value ) ) { |
|
107 | + $query['where'] .= " AND {$value['key']} {$where_value}"; |
|
108 | + } |
|
109 | + } |
|
110 | + } |
|
111 | + |
|
112 | + if ( $group_by ) { |
|
113 | + $query['group_by'] = "GROUP BY {$group_by}"; |
|
114 | + } |
|
115 | + |
|
116 | + if ( $order_by ) { |
|
117 | + $query['order_by'] = "ORDER BY {$order_by}"; |
|
118 | + } |
|
119 | + |
|
120 | + if ( $limit ) { |
|
121 | + $query['limit'] = "LIMIT {$limit}"; |
|
122 | + } |
|
123 | + |
|
124 | + $query = apply_filters( 'getpaid_reports_get_invoice_report_query', $query, $data ); |
|
125 | + $query = implode( ' ', $query ); |
|
126 | + |
|
127 | + return self::execute( $query_type, $query ); |
|
128 | + |
|
129 | + } |
|
130 | + |
|
131 | + /** |
|
132 | + * Prepares the data to select. |
|
133 | + * |
|
134 | + * |
|
135 | + * @param array $data |
|
136 | + * @return array |
|
137 | + */ |
|
138 | + public static function prepare_invoice_data( $data ) { |
|
139 | + |
|
140 | + $prepared = array(); |
|
141 | + |
|
142 | + foreach ( $data as $raw_key => $value ) { |
|
143 | + $key = sanitize_key( $raw_key ); |
|
144 | + $distinct = ''; |
|
145 | + |
|
146 | + if ( isset( $value['distinct'] ) ) { |
|
147 | + $distinct = 'DISTINCT'; |
|
148 | + } |
|
149 | + |
|
150 | + $get_key = self::get_invoice_table_key( $key, $value['type'] ); |
|
151 | + |
|
152 | + if ( false === $get_key ) { |
|
153 | + // Skip to the next foreach iteration else the query will be invalid. |
|
154 | + continue; |
|
155 | + } |
|
156 | + |
|
157 | + if ( ! empty( $value['function'] ) ) { |
|
158 | + $get = "{$value['function']}({$distinct} {$get_key})"; |
|
159 | + } else { |
|
160 | + $get = "{$distinct} {$get_key}"; |
|
161 | + } |
|
162 | + |
|
163 | + $prepared[] = "{$get} as {$value['name']}"; |
|
164 | + } |
|
165 | + |
|
166 | + return $prepared; |
|
167 | + |
|
168 | + } |
|
169 | + |
|
170 | + /** |
|
171 | + * Prepares the joins to use. |
|
172 | + * |
|
173 | + * |
|
174 | + * @param array $data |
|
175 | + * @param bool $with_parent |
|
176 | + * @return array |
|
177 | + */ |
|
178 | + public static function prepare_invoice_joins( $data, $with_parent ) { |
|
179 | + global $wpdb; |
|
180 | + |
|
181 | + $prepared = array(); |
|
182 | + |
|
183 | + foreach ( $data as $raw_key => $value ) { |
|
184 | + $join_type = isset( $value['join_type'] ) ? $value['join_type'] : 'INNER'; |
|
185 | + $type = isset( $value['type'] ) ? $value['type'] : false; |
|
186 | + $key = sanitize_key( $raw_key ); |
|
187 | + |
|
188 | + switch ( $type ) { |
|
189 | + case 'meta': |
|
190 | + $prepared[ "meta_{$key}" ] = "{$join_type} JOIN {$wpdb->postmeta} AS meta_{$key} ON ( posts.ID = meta_{$key}.post_id AND meta_{$key}.meta_key = '{$raw_key}' )"; |
|
191 | + break; |
|
192 | + case 'parent_meta': |
|
193 | + $prepared[ "parent_meta_{$key}" ] = "{$join_type} JOIN {$wpdb->postmeta} AS parent_meta_{$key} ON (posts.post_parent = parent_meta_{$key}.post_id) AND (parent_meta_{$key}.meta_key = '{$raw_key}')"; |
|
194 | + break; |
|
195 | + case 'invoice_data': |
|
196 | + $prepared['invoices'] = "{$join_type} JOIN {$wpdb->prefix}getpaid_invoices AS invoices ON posts.ID = invoices.post_id"; |
|
197 | + break; |
|
198 | + case 'invoice_item': |
|
199 | + $prepared['invoice_items'] = "{$join_type} JOIN {$wpdb->prefix}getpaid_invoice_items AS invoice_items ON posts.ID = invoice_items.post_id"; |
|
200 | + break; |
|
201 | + } |
|
202 | + } |
|
203 | + |
|
204 | + if ( $with_parent ) { |
|
205 | + $prepared['parent'] = "LEFT JOIN {$wpdb->posts} AS parent ON posts.post_parent = parent.ID"; |
|
206 | + } |
|
207 | + |
|
208 | + return $prepared; |
|
209 | + |
|
210 | + } |
|
211 | + |
|
212 | + /** |
|
213 | + * Retrieves the appropriate table key to use. |
|
214 | + * |
|
215 | + * |
|
216 | + * @param string $key |
|
217 | + * @param string $table |
|
218 | + * @return string|false |
|
219 | + */ |
|
220 | + public static function get_invoice_table_key( $key, $table ) { |
|
221 | + |
|
222 | + $keys = array( |
|
223 | + 'meta' => "meta_{$key}.meta_value", |
|
224 | + 'parent_meta' => "parent_meta_{$key}.meta_value", |
|
225 | + 'post_data' => "posts.{$key}", |
|
226 | + 'invoice_data' => "invoices.{$key}", |
|
227 | + 'invoice_item' => "invoice_items.{$key}", |
|
228 | + ); |
|
229 | + |
|
230 | + return isset( $keys[ $table ] ) ? $keys[ $table ] : false; |
|
231 | + |
|
232 | + } |
|
233 | + |
|
234 | + /** |
|
235 | + * Executes a query and caches the result for a minute. |
|
236 | + * |
|
237 | + * |
|
238 | + * @param string $query_type |
|
239 | + * @param string $query |
|
240 | + * @return mixed depending on query_type |
|
241 | + */ |
|
242 | + public static function execute( $query_type, $query ) { |
|
243 | + global $wpdb; |
|
244 | + |
|
245 | + $query_hash = md5( $query_type . $query ); |
|
246 | + $result = self::get_cached_query( $query_hash ); |
|
247 | + if ( $result === false ) { |
|
248 | + self::enable_big_selects(); |
|
249 | + |
|
250 | + $result = $wpdb->$query_type( $query ); |
|
251 | + self::set_cached_query( $query_hash, $result ); |
|
252 | + } |
|
253 | + |
|
254 | + return $result; |
|
255 | + |
|
256 | + } |
|
257 | + |
|
258 | + /** |
|
259 | + * Enables big mysql selects for reports, just once for this session. |
|
260 | + */ |
|
261 | + protected static function enable_big_selects() { |
|
262 | + static $big_selects = false; |
|
263 | + |
|
264 | + global $wpdb; |
|
265 | + |
|
266 | + if ( ! $big_selects ) { |
|
267 | + $wpdb->query( 'SET SESSION SQL_BIG_SELECTS=1' ); |
|
268 | + $big_selects = true; |
|
269 | + } |
|
270 | + } |
|
271 | + |
|
272 | + /** |
|
273 | + * Get the cached query result or null if it's not in the cache. |
|
274 | + * |
|
275 | + * @param string $query_hash The query hash. |
|
276 | + * |
|
277 | + * @return mixed|false The cache contents on success, false on failure to retrieve contents. |
|
278 | + */ |
|
279 | + protected static function get_cached_query( $query_hash ) { |
|
280 | + |
|
281 | + return wp_cache_get( |
|
282 | + $query_hash, |
|
283 | + strtolower( __CLASS__ ) |
|
284 | + ); |
|
285 | + |
|
286 | + } |
|
287 | + |
|
288 | + /** |
|
289 | + * Set the cached query result. |
|
290 | + * |
|
291 | + * @param string $query_hash The query hash. |
|
292 | + * @param mixed $data The data to cache. |
|
293 | + */ |
|
294 | + protected static function set_cached_query( $query_hash, $data ) { |
|
295 | + |
|
296 | + wp_cache_set( |
|
297 | + $query_hash, |
|
298 | + $data, |
|
299 | + strtolower( __CLASS__ ), |
|
300 | + MINUTE_IN_SECONDS |
|
301 | + ); |
|
302 | + |
|
303 | + } |
|
304 | 304 | |
305 | 305 | } |
@@ -12,202 +12,202 @@ |
||
12 | 12 | */ |
13 | 13 | class WPInv_Notes { |
14 | 14 | |
15 | - /** |
|
16 | - * Class constructor. |
|
17 | - */ |
|
18 | - public function __construct() { |
|
19 | - |
|
20 | - // Filter inovice notes. |
|
21 | - add_action( 'pre_get_comments', array( $this, 'set_invoice_note_type' ), 11, 1 ); |
|
22 | - add_action( 'comment_feed_where', array( $this, 'wpinv_comment_feed_where' ), 10, 1 ); |
|
23 | - |
|
24 | - // Delete comments count cache whenever there is a new comment or a comment status changes. |
|
25 | - add_action( 'wp_insert_comment', array( $this, 'delete_comments_count_cache' ) ); |
|
26 | - add_action( 'wp_set_comment_status', array( $this, 'delete_comments_count_cache' ) ); |
|
27 | - |
|
28 | - // Count comments. |
|
29 | - add_filter( 'wp_count_comments', array( $this, 'wp_count_comments' ), 100, 2 ); |
|
30 | - |
|
31 | - // Fires after notes are loaded. |
|
32 | - do_action( 'wpinv_notes_init', $this ); |
|
33 | - } |
|
34 | - |
|
35 | - /** |
|
36 | - * Filters invoice notes query to only include our notes. |
|
37 | - * |
|
38 | - * @param WP_Comment_Query $query |
|
39 | - */ |
|
40 | - public function set_invoice_note_type( $query ) { |
|
41 | - $post_id = ! empty( $query->query_vars['post_ID'] ) ? $query->query_vars['post_ID'] : $query->query_vars['post_id']; |
|
42 | - |
|
43 | - if ( $post_id && getpaid_is_invoice_post_type( get_post_type( $post_id ) ) ) { |
|
44 | - $query->query_vars['type'] = 'wpinv_note'; |
|
45 | - } else { |
|
46 | - |
|
47 | - if ( empty( $query->query_vars['type__not_in'] ) ) { |
|
48 | - $query->query_vars['type__not_in'] = array(); |
|
49 | - } |
|
50 | - |
|
51 | - $query->query_vars['type__not_in'] = wpinv_parse_list( $query->query_vars['type__not_in'] ); |
|
52 | - $query->query_vars['type__not_in'] = array_merge( array( 'wpinv_note' ), $query->query_vars['type__not_in'] ); |
|
53 | - } |
|
54 | - |
|
55 | - return $query; |
|
56 | - } |
|
57 | - |
|
58 | - /** |
|
59 | - * Exclude notes from the comments feed. |
|
60 | - */ |
|
61 | - function wpinv_comment_feed_where( $where ){ |
|
62 | - return $where . ( $where ? ' AND ' : '' ) . " comment_type != 'wpinv_note' "; |
|
63 | - } |
|
64 | - |
|
65 | - /** |
|
66 | - * Delete comments count cache whenever there is |
|
67 | - * new comment or the status of a comment changes. Cache |
|
68 | - * will be regenerated next time WPInv_Notes::wp_count_comments() |
|
69 | - * is called. |
|
70 | - */ |
|
71 | - public function delete_comments_count_cache() { |
|
72 | - delete_transient( 'getpaid_count_comments' ); |
|
73 | - } |
|
74 | - |
|
75 | - /** |
|
76 | - * Remove invoice notes from wp_count_comments(). |
|
77 | - * |
|
78 | - * @since 2.2 |
|
79 | - * @param object $stats Comment stats. |
|
80 | - * @param int $post_id Post ID. |
|
81 | - * @return object |
|
82 | - */ |
|
83 | - public function wp_count_comments( $stats, $post_id ) { |
|
84 | - global $wpdb; |
|
85 | - |
|
86 | - if ( empty( $post_id ) ) { |
|
87 | - $stats = get_transient( 'getpaid_count_comments' ); |
|
88 | - |
|
89 | - if ( ! $stats ) { |
|
90 | - $stats = array( |
|
91 | - 'total_comments' => 0, |
|
92 | - 'all' => 0, |
|
93 | - ); |
|
94 | - |
|
95 | - $count = $wpdb->get_results( |
|
96 | - " |
|
15 | + /** |
|
16 | + * Class constructor. |
|
17 | + */ |
|
18 | + public function __construct() { |
|
19 | + |
|
20 | + // Filter inovice notes. |
|
21 | + add_action( 'pre_get_comments', array( $this, 'set_invoice_note_type' ), 11, 1 ); |
|
22 | + add_action( 'comment_feed_where', array( $this, 'wpinv_comment_feed_where' ), 10, 1 ); |
|
23 | + |
|
24 | + // Delete comments count cache whenever there is a new comment or a comment status changes. |
|
25 | + add_action( 'wp_insert_comment', array( $this, 'delete_comments_count_cache' ) ); |
|
26 | + add_action( 'wp_set_comment_status', array( $this, 'delete_comments_count_cache' ) ); |
|
27 | + |
|
28 | + // Count comments. |
|
29 | + add_filter( 'wp_count_comments', array( $this, 'wp_count_comments' ), 100, 2 ); |
|
30 | + |
|
31 | + // Fires after notes are loaded. |
|
32 | + do_action( 'wpinv_notes_init', $this ); |
|
33 | + } |
|
34 | + |
|
35 | + /** |
|
36 | + * Filters invoice notes query to only include our notes. |
|
37 | + * |
|
38 | + * @param WP_Comment_Query $query |
|
39 | + */ |
|
40 | + public function set_invoice_note_type( $query ) { |
|
41 | + $post_id = ! empty( $query->query_vars['post_ID'] ) ? $query->query_vars['post_ID'] : $query->query_vars['post_id']; |
|
42 | + |
|
43 | + if ( $post_id && getpaid_is_invoice_post_type( get_post_type( $post_id ) ) ) { |
|
44 | + $query->query_vars['type'] = 'wpinv_note'; |
|
45 | + } else { |
|
46 | + |
|
47 | + if ( empty( $query->query_vars['type__not_in'] ) ) { |
|
48 | + $query->query_vars['type__not_in'] = array(); |
|
49 | + } |
|
50 | + |
|
51 | + $query->query_vars['type__not_in'] = wpinv_parse_list( $query->query_vars['type__not_in'] ); |
|
52 | + $query->query_vars['type__not_in'] = array_merge( array( 'wpinv_note' ), $query->query_vars['type__not_in'] ); |
|
53 | + } |
|
54 | + |
|
55 | + return $query; |
|
56 | + } |
|
57 | + |
|
58 | + /** |
|
59 | + * Exclude notes from the comments feed. |
|
60 | + */ |
|
61 | + function wpinv_comment_feed_where( $where ){ |
|
62 | + return $where . ( $where ? ' AND ' : '' ) . " comment_type != 'wpinv_note' "; |
|
63 | + } |
|
64 | + |
|
65 | + /** |
|
66 | + * Delete comments count cache whenever there is |
|
67 | + * new comment or the status of a comment changes. Cache |
|
68 | + * will be regenerated next time WPInv_Notes::wp_count_comments() |
|
69 | + * is called. |
|
70 | + */ |
|
71 | + public function delete_comments_count_cache() { |
|
72 | + delete_transient( 'getpaid_count_comments' ); |
|
73 | + } |
|
74 | + |
|
75 | + /** |
|
76 | + * Remove invoice notes from wp_count_comments(). |
|
77 | + * |
|
78 | + * @since 2.2 |
|
79 | + * @param object $stats Comment stats. |
|
80 | + * @param int $post_id Post ID. |
|
81 | + * @return object |
|
82 | + */ |
|
83 | + public function wp_count_comments( $stats, $post_id ) { |
|
84 | + global $wpdb; |
|
85 | + |
|
86 | + if ( empty( $post_id ) ) { |
|
87 | + $stats = get_transient( 'getpaid_count_comments' ); |
|
88 | + |
|
89 | + if ( ! $stats ) { |
|
90 | + $stats = array( |
|
91 | + 'total_comments' => 0, |
|
92 | + 'all' => 0, |
|
93 | + ); |
|
94 | + |
|
95 | + $count = $wpdb->get_results( |
|
96 | + " |
|
97 | 97 | SELECT comment_approved, COUNT(*) AS num_comments |
98 | 98 | FROM {$wpdb->comments} |
99 | 99 | WHERE comment_type NOT IN ('action_log', 'order_note', 'webhook_delivery', 'wpinv_note') |
100 | 100 | GROUP BY comment_approved |
101 | 101 | ", |
102 | - ARRAY_A |
|
103 | - ); |
|
104 | - |
|
105 | - $approved = array( |
|
106 | - '0' => 'moderated', |
|
107 | - '1' => 'approved', |
|
108 | - 'spam' => 'spam', |
|
109 | - 'trash' => 'trash', |
|
110 | - 'post-trashed' => 'post-trashed', |
|
111 | - ); |
|
112 | - |
|
113 | - foreach ( (array) $count as $row ) { |
|
114 | - // Don't count post-trashed toward totals. |
|
115 | - if ( ! in_array( $row['comment_approved'], array( 'post-trashed', 'trash', 'spam' ), true ) ) { |
|
116 | - $stats['all'] += $row['num_comments']; |
|
117 | - $stats['total_comments'] += $row['num_comments']; |
|
118 | - } elseif ( ! in_array( $row['comment_approved'], array( 'post-trashed', 'trash' ), true ) ) { |
|
119 | - $stats['total_comments'] += $row['num_comments']; |
|
120 | - } |
|
121 | - if ( isset( $approved[ $row['comment_approved'] ] ) ) { |
|
122 | - $stats[ $approved[ $row['comment_approved'] ] ] = $row['num_comments']; |
|
123 | - } |
|
124 | - } |
|
125 | - |
|
126 | - foreach ( $approved as $key ) { |
|
127 | - if ( empty( $stats[ $key ] ) ) { |
|
128 | - $stats[ $key ] = 0; |
|
129 | - } |
|
130 | - } |
|
131 | - |
|
132 | - $stats = (object) $stats; |
|
133 | - set_transient( 'getpaid_count_comments', $stats ); |
|
134 | - } |
|
135 | - |
|
136 | - } |
|
137 | - |
|
138 | - return $stats; |
|
139 | - } |
|
140 | - |
|
141 | - /** |
|
142 | - * Returns an array of invoice notes. |
|
143 | - * |
|
144 | - * @param int $invoice_id The invoice ID whose notes to retrieve. |
|
145 | - * @param string $type Optional. Pass in customer to only return customer notes. |
|
146 | - * @return WP_Comment[] |
|
147 | - */ |
|
148 | - public function get_invoice_notes( $invoice_id = 0, $type = 'all' ) { |
|
149 | - |
|
150 | - // Default comment args. |
|
151 | - $args = array( |
|
152 | - 'post_id' => $invoice_id, |
|
153 | - 'orderby' => 'comment_ID', |
|
154 | - 'order' => 'ASC', |
|
155 | - ); |
|
156 | - |
|
157 | - // Maybe only show customer comments. |
|
158 | - if ( $type == 'customer' ) { |
|
159 | - $args['meta_key'] = '_wpi_customer_note'; |
|
160 | - $args['meta_value'] = 1; |
|
161 | - } |
|
162 | - |
|
163 | - $args = apply_filters( 'wpinv_invoice_notes_args', $args, $this, $invoice_id, $type ); |
|
164 | - |
|
165 | - return get_comments( $args ); |
|
166 | - } |
|
167 | - |
|
168 | - /** |
|
169 | - * Saves an invoice comment. |
|
170 | - * |
|
171 | - * @param WPInv_Invoice $invoice The invoice to add the comment to. |
|
172 | - * @param string $note The note content. |
|
173 | - * @param string $note_author The name of the author of the note. |
|
174 | - * @param bool $for_customer Whether or not this comment is meant to be sent to the customer. |
|
175 | - * @return int|false The new note's ID on success, false on failure. |
|
176 | - */ |
|
177 | - function add_invoice_note( $invoice, $note, $note_author, $author_email, $for_customer = false ){ |
|
178 | - |
|
179 | - do_action( 'wpinv_pre_insert_invoice_note', $invoice->get_id(), $note, $for_customer ); |
|
180 | - |
|
181 | - /** |
|
182 | - * Insert the comment. |
|
183 | - */ |
|
184 | - $note_id = wp_insert_comment( |
|
185 | - wp_filter_comment( |
|
186 | - array( |
|
187 | - 'comment_post_ID' => $invoice->get_id(), |
|
188 | - 'comment_content' => $note, |
|
189 | - 'comment_agent' => 'Invoicing', |
|
190 | - 'user_id' => get_current_user_id(), |
|
191 | - 'comment_author' => $note_author, |
|
192 | - 'comment_author_IP' => wpinv_get_ip(), |
|
193 | - 'comment_author_email' => $author_email, |
|
194 | - 'comment_author_url' => $invoice->get_view_url(), |
|
195 | - 'comment_type' => 'wpinv_note', |
|
196 | - ) |
|
197 | - ) |
|
198 | - ); |
|
199 | - |
|
200 | - do_action( 'wpinv_insert_payment_note', $note_id, $invoice->get_id(), $note, $for_customer ); |
|
201 | - |
|
202 | - // Are we notifying the customer? |
|
203 | - if ( empty( $note_id ) || empty( $for_customer ) ) { |
|
204 | - return $note_id; |
|
205 | - } |
|
206 | - |
|
207 | - add_comment_meta( $note_id, '_wpi_customer_note', 1 ); |
|
208 | - do_action( 'wpinv_new_customer_note', array( 'invoice_id' => $invoice->get_id(), 'user_note' => $note ) ); |
|
209 | - do_action( 'getpaid_new_customer_note', $invoice, $note ); |
|
210 | - return $note_id; |
|
211 | - } |
|
102 | + ARRAY_A |
|
103 | + ); |
|
104 | + |
|
105 | + $approved = array( |
|
106 | + '0' => 'moderated', |
|
107 | + '1' => 'approved', |
|
108 | + 'spam' => 'spam', |
|
109 | + 'trash' => 'trash', |
|
110 | + 'post-trashed' => 'post-trashed', |
|
111 | + ); |
|
112 | + |
|
113 | + foreach ( (array) $count as $row ) { |
|
114 | + // Don't count post-trashed toward totals. |
|
115 | + if ( ! in_array( $row['comment_approved'], array( 'post-trashed', 'trash', 'spam' ), true ) ) { |
|
116 | + $stats['all'] += $row['num_comments']; |
|
117 | + $stats['total_comments'] += $row['num_comments']; |
|
118 | + } elseif ( ! in_array( $row['comment_approved'], array( 'post-trashed', 'trash' ), true ) ) { |
|
119 | + $stats['total_comments'] += $row['num_comments']; |
|
120 | + } |
|
121 | + if ( isset( $approved[ $row['comment_approved'] ] ) ) { |
|
122 | + $stats[ $approved[ $row['comment_approved'] ] ] = $row['num_comments']; |
|
123 | + } |
|
124 | + } |
|
125 | + |
|
126 | + foreach ( $approved as $key ) { |
|
127 | + if ( empty( $stats[ $key ] ) ) { |
|
128 | + $stats[ $key ] = 0; |
|
129 | + } |
|
130 | + } |
|
131 | + |
|
132 | + $stats = (object) $stats; |
|
133 | + set_transient( 'getpaid_count_comments', $stats ); |
|
134 | + } |
|
135 | + |
|
136 | + } |
|
137 | + |
|
138 | + return $stats; |
|
139 | + } |
|
140 | + |
|
141 | + /** |
|
142 | + * Returns an array of invoice notes. |
|
143 | + * |
|
144 | + * @param int $invoice_id The invoice ID whose notes to retrieve. |
|
145 | + * @param string $type Optional. Pass in customer to only return customer notes. |
|
146 | + * @return WP_Comment[] |
|
147 | + */ |
|
148 | + public function get_invoice_notes( $invoice_id = 0, $type = 'all' ) { |
|
149 | + |
|
150 | + // Default comment args. |
|
151 | + $args = array( |
|
152 | + 'post_id' => $invoice_id, |
|
153 | + 'orderby' => 'comment_ID', |
|
154 | + 'order' => 'ASC', |
|
155 | + ); |
|
156 | + |
|
157 | + // Maybe only show customer comments. |
|
158 | + if ( $type == 'customer' ) { |
|
159 | + $args['meta_key'] = '_wpi_customer_note'; |
|
160 | + $args['meta_value'] = 1; |
|
161 | + } |
|
162 | + |
|
163 | + $args = apply_filters( 'wpinv_invoice_notes_args', $args, $this, $invoice_id, $type ); |
|
164 | + |
|
165 | + return get_comments( $args ); |
|
166 | + } |
|
167 | + |
|
168 | + /** |
|
169 | + * Saves an invoice comment. |
|
170 | + * |
|
171 | + * @param WPInv_Invoice $invoice The invoice to add the comment to. |
|
172 | + * @param string $note The note content. |
|
173 | + * @param string $note_author The name of the author of the note. |
|
174 | + * @param bool $for_customer Whether or not this comment is meant to be sent to the customer. |
|
175 | + * @return int|false The new note's ID on success, false on failure. |
|
176 | + */ |
|
177 | + function add_invoice_note( $invoice, $note, $note_author, $author_email, $for_customer = false ){ |
|
178 | + |
|
179 | + do_action( 'wpinv_pre_insert_invoice_note', $invoice->get_id(), $note, $for_customer ); |
|
180 | + |
|
181 | + /** |
|
182 | + * Insert the comment. |
|
183 | + */ |
|
184 | + $note_id = wp_insert_comment( |
|
185 | + wp_filter_comment( |
|
186 | + array( |
|
187 | + 'comment_post_ID' => $invoice->get_id(), |
|
188 | + 'comment_content' => $note, |
|
189 | + 'comment_agent' => 'Invoicing', |
|
190 | + 'user_id' => get_current_user_id(), |
|
191 | + 'comment_author' => $note_author, |
|
192 | + 'comment_author_IP' => wpinv_get_ip(), |
|
193 | + 'comment_author_email' => $author_email, |
|
194 | + 'comment_author_url' => $invoice->get_view_url(), |
|
195 | + 'comment_type' => 'wpinv_note', |
|
196 | + ) |
|
197 | + ) |
|
198 | + ); |
|
199 | + |
|
200 | + do_action( 'wpinv_insert_payment_note', $note_id, $invoice->get_id(), $note, $for_customer ); |
|
201 | + |
|
202 | + // Are we notifying the customer? |
|
203 | + if ( empty( $note_id ) || empty( $for_customer ) ) { |
|
204 | + return $note_id; |
|
205 | + } |
|
206 | + |
|
207 | + add_comment_meta( $note_id, '_wpi_customer_note', 1 ); |
|
208 | + do_action( 'wpinv_new_customer_note', array( 'invoice_id' => $invoice->get_id(), 'user_note' => $note ) ); |
|
209 | + do_action( 'getpaid_new_customer_note', $invoice, $note ); |
|
210 | + return $note_id; |
|
211 | + } |
|
212 | 212 | |
213 | 213 | } |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | * Checks if the current user cna view an invoice receipt. |
68 | 68 | */ |
69 | 69 | function wpinv_can_view_receipt( $invoice ) { |
70 | - return (bool) apply_filters( 'wpinv_can_view_receipt', wpinv_user_can_view_invoice( $invoice ), $invoice ); |
|
70 | + return (bool) apply_filters( 'wpinv_can_view_receipt', wpinv_user_can_view_invoice( $invoice ), $invoice ); |
|
71 | 71 | } |
72 | 72 | |
73 | 73 | /** |
@@ -1280,22 +1280,22 @@ discard block |
||
1280 | 1280 | */ |
1281 | 1281 | function getpaid_get_invoice_status_classes() { |
1282 | 1282 | |
1283 | - return apply_filters( |
|
1284 | - 'getpaid_get_invoice_status_classes', |
|
1285 | - array( |
|
1283 | + return apply_filters( |
|
1284 | + 'getpaid_get_invoice_status_classes', |
|
1285 | + array( |
|
1286 | 1286 | 'wpi-quote-declined' => 'badge-danger', |
1287 | 1287 | 'wpi-failed' => 'badge-danger', |
1288 | - 'wpi-processing' => 'badge-info', |
|
1289 | - 'wpi-onhold' => 'badge-warning', |
|
1290 | - 'wpi-quote-accepted' => 'badge-success', |
|
1291 | - 'publish' => 'badge-success', |
|
1292 | - 'wpi-renewal' => 'badge-primary', |
|
1288 | + 'wpi-processing' => 'badge-info', |
|
1289 | + 'wpi-onhold' => 'badge-warning', |
|
1290 | + 'wpi-quote-accepted' => 'badge-success', |
|
1291 | + 'publish' => 'badge-success', |
|
1292 | + 'wpi-renewal' => 'badge-primary', |
|
1293 | 1293 | 'wpi-cancelled' => 'badge-secondary', |
1294 | 1294 | 'wpi-pending' => 'badge-dark', |
1295 | 1295 | 'wpi-quote-pending' => 'badge-dark', |
1296 | 1296 | 'wpi-refunded' => 'badge-secondary', |
1297 | - ) |
|
1298 | - ); |
|
1297 | + ) |
|
1298 | + ); |
|
1299 | 1299 | |
1300 | 1300 | } |
1301 | 1301 | |
@@ -1309,7 +1309,7 @@ discard block |
||
1309 | 1309 | function getpaid_get_invoice_tax_rate( $invoice, $item ) { |
1310 | 1310 | |
1311 | 1311 | $rates = getpaid_get_item_tax_rates( $item, $invoice->get_country(), $invoice->get_state() ); |
1312 | - $rates = getpaid_filter_item_tax_rates( $item, $rates ); |
|
1312 | + $rates = getpaid_filter_item_tax_rates( $item, $rates ); |
|
1313 | 1313 | $rates = wp_list_pluck( $rates, 'rate' ); |
1314 | 1314 | |
1315 | 1315 | return array_sum( $rates ); |