@@ -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 ); |