AyeCode /
invoicing
@@ -12,59 +12,59 @@ |
||
| 12 | 12 | $label = empty( $label ) ? '' : wp_kses_post( $label ); |
| 13 | 13 | $label_class = sanitize_key( preg_replace( '/[^A-Za-z0-9_-]/', '-', $label ) ); |
| 14 | 14 | if ( ! empty( $required ) ) { |
| 15 | - $label .= "<span class='text-danger'> *</span>"; |
|
| 15 | + $label .= "<span class='text-danger'> *</span>"; |
|
| 16 | 16 | } |
| 17 | 17 | |
| 18 | 18 | $disable_dates = array(); |
| 19 | 19 | |
| 20 | 20 | if ( ! empty( $disabled_dates ) ) { |
| 21 | - $disabled_dates = preg_replace( '/\s+/', '', $disabled_dates ); |
|
| 22 | - $disabled_dates = str_ireplace( 'today', current_time( 'Y-m-d' ), $disabled_dates ); |
|
| 23 | - $disabled_dates = array_filter( explode( ',', $disabled_dates ) ); |
|
| 21 | + $disabled_dates = preg_replace( '/\s+/', '', $disabled_dates ); |
|
| 22 | + $disabled_dates = str_ireplace( 'today', current_time( 'Y-m-d' ), $disabled_dates ); |
|
| 23 | + $disabled_dates = array_filter( explode( ',', $disabled_dates ) ); |
|
| 24 | 24 | |
| 25 | - foreach ( $disabled_dates as $disabled_date ) { |
|
| 25 | + foreach ( $disabled_dates as $disabled_date ) { |
|
| 26 | 26 | |
| 27 | - $disabled_date = trim( $disabled_date ); |
|
| 27 | + $disabled_date = trim( $disabled_date ); |
|
| 28 | 28 | |
| 29 | - if ( false === strpos( $disabled_date, '|' ) ) { |
|
| 30 | - $disable_dates[] = $disabled_date; |
|
| 31 | - continue; |
|
| 32 | - } |
|
| 29 | + if ( false === strpos( $disabled_date, '|' ) ) { |
|
| 30 | + $disable_dates[] = $disabled_date; |
|
| 31 | + continue; |
|
| 32 | + } |
|
| 33 | 33 | |
| 34 | - $disabled_date = explode( '|', $disabled_date ); |
|
| 35 | - $disable_dates[] = array( |
|
| 36 | - 'from' => trim( $disabled_date[0] ), |
|
| 37 | - 'to' => trim( $disabled_date[1] ), |
|
| 38 | - ); |
|
| 34 | + $disabled_date = explode( '|', $disabled_date ); |
|
| 35 | + $disable_dates[] = array( |
|
| 36 | + 'from' => trim( $disabled_date[0] ), |
|
| 37 | + 'to' => trim( $disabled_date[1] ), |
|
| 38 | + ); |
|
| 39 | 39 | |
| 40 | - } |
|
| 40 | + } |
|
| 41 | 41 | } |
| 42 | 42 | |
| 43 | 43 | $options = array( |
| 44 | - 'data-default-date' => empty( $default_date ) ? false : $default_date, |
|
| 45 | - 'data-min-date' => empty( $min_date ) ? false : $min_date, |
|
| 46 | - 'data-max-date' => empty( $max_date ) ? false : $max_date, |
|
| 47 | - 'data-mode' => empty( $mode ) ? 'single' : $mode, |
|
| 48 | - 'data-alt-format' => get_option( 'date_format', 'F j, Y' ), |
|
| 49 | - 'data-date-format' => 'Y-m-d', |
|
| 50 | - 'data-alt-input' => 'true', |
|
| 51 | - 'data-disable_alt' => empty( $disabled_dates ) ? false : wp_json_encode( $disable_dates ), |
|
| 52 | - 'data-disable_days_alt' => empty( $disable_days ) ? false : wp_json_encode( wp_parse_id_list( $disable_days ) ), |
|
| 44 | + 'data-default-date' => empty( $default_date ) ? false : $default_date, |
|
| 45 | + 'data-min-date' => empty( $min_date ) ? false : $min_date, |
|
| 46 | + 'data-max-date' => empty( $max_date ) ? false : $max_date, |
|
| 47 | + 'data-mode' => empty( $mode ) ? 'single' : $mode, |
|
| 48 | + 'data-alt-format' => get_option( 'date_format', 'F j, Y' ), |
|
| 49 | + 'data-date-format' => 'Y-m-d', |
|
| 50 | + 'data-alt-input' => 'true', |
|
| 51 | + 'data-disable_alt' => empty( $disabled_dates ) ? false : wp_json_encode( $disable_dates ), |
|
| 52 | + 'data-disable_days_alt' => empty( $disable_days ) ? false : wp_json_encode( wp_parse_id_list( $disable_days ) ), |
|
| 53 | 53 | ); |
| 54 | 54 | |
| 55 | 55 | aui()->input( |
| 56 | - array( |
|
| 57 | - 'name' => esc_attr( $id ), |
|
| 58 | - 'id' => esc_attr( $element_id ), |
|
| 59 | - 'placeholder' => empty( $placeholder ) ? '' : esc_attr( $placeholder ), |
|
| 60 | - 'required' => ! empty( $required ), |
|
| 61 | - 'label' => $label, |
|
| 62 | - 'label_type' => 'vertical', |
|
| 63 | - 'help_text' => empty( $description ) ? '' : wp_kses_post( $description ), |
|
| 64 | - 'type' => 'datepicker', |
|
| 65 | - 'class' => $label_class . ' getpaid-init-flatpickr flatpickr-input', |
|
| 66 | - 'extra_attributes' => array_filter( apply_filters( 'getpaid_date_field_attributes', $options ) ), |
|
| 67 | - 'value' => $query_value, |
|
| 68 | - ), |
|
| 69 | - true |
|
| 56 | + array( |
|
| 57 | + 'name' => esc_attr( $id ), |
|
| 58 | + 'id' => esc_attr( $element_id ), |
|
| 59 | + 'placeholder' => empty( $placeholder ) ? '' : esc_attr( $placeholder ), |
|
| 60 | + 'required' => ! empty( $required ), |
|
| 61 | + 'label' => $label, |
|
| 62 | + 'label_type' => 'vertical', |
|
| 63 | + 'help_text' => empty( $description ) ? '' : wp_kses_post( $description ), |
|
| 64 | + 'type' => 'datepicker', |
|
| 65 | + 'class' => $label_class . ' getpaid-init-flatpickr flatpickr-input', |
|
| 66 | + 'extra_attributes' => array_filter( apply_filters( 'getpaid_date_field_attributes', $options ) ), |
|
| 67 | + 'value' => $query_value, |
|
| 68 | + ), |
|
| 69 | + true |
|
| 70 | 70 | ); |
@@ -7,63 +7,63 @@ |
||
| 7 | 7 | * @version 1.0.19 |
| 8 | 8 | */ |
| 9 | 9 | |
| 10 | -defined( 'ABSPATH' ) || exit; |
|
| 10 | +defined('ABSPATH') || exit; |
|
| 11 | 11 | |
| 12 | -$label = empty( $label ) ? '' : wp_kses_post( $label ); |
|
| 13 | -$label_class = sanitize_key( preg_replace( '/[^A-Za-z0-9_-]/', '-', $label ) ); |
|
| 14 | -if ( ! empty( $required ) ) { |
|
| 12 | +$label = empty($label) ? '' : wp_kses_post($label); |
|
| 13 | +$label_class = sanitize_key(preg_replace('/[^A-Za-z0-9_-]/', '-', $label)); |
|
| 14 | +if (!empty($required)) { |
|
| 15 | 15 | $label .= "<span class='text-danger'> *</span>"; |
| 16 | 16 | } |
| 17 | 17 | |
| 18 | 18 | $disable_dates = array(); |
| 19 | 19 | |
| 20 | -if ( ! empty( $disabled_dates ) ) { |
|
| 21 | - $disabled_dates = preg_replace( '/\s+/', '', $disabled_dates ); |
|
| 22 | - $disabled_dates = str_ireplace( 'today', current_time( 'Y-m-d' ), $disabled_dates ); |
|
| 23 | - $disabled_dates = array_filter( explode( ',', $disabled_dates ) ); |
|
| 20 | +if (!empty($disabled_dates)) { |
|
| 21 | + $disabled_dates = preg_replace('/\s+/', '', $disabled_dates); |
|
| 22 | + $disabled_dates = str_ireplace('today', current_time('Y-m-d'), $disabled_dates); |
|
| 23 | + $disabled_dates = array_filter(explode(',', $disabled_dates)); |
|
| 24 | 24 | |
| 25 | - foreach ( $disabled_dates as $disabled_date ) { |
|
| 25 | + foreach ($disabled_dates as $disabled_date) { |
|
| 26 | 26 | |
| 27 | - $disabled_date = trim( $disabled_date ); |
|
| 27 | + $disabled_date = trim($disabled_date); |
|
| 28 | 28 | |
| 29 | - if ( false === strpos( $disabled_date, '|' ) ) { |
|
| 29 | + if (false === strpos($disabled_date, '|')) { |
|
| 30 | 30 | $disable_dates[] = $disabled_date; |
| 31 | 31 | continue; |
| 32 | 32 | } |
| 33 | 33 | |
| 34 | - $disabled_date = explode( '|', $disabled_date ); |
|
| 34 | + $disabled_date = explode('|', $disabled_date); |
|
| 35 | 35 | $disable_dates[] = array( |
| 36 | - 'from' => trim( $disabled_date[0] ), |
|
| 37 | - 'to' => trim( $disabled_date[1] ), |
|
| 36 | + 'from' => trim($disabled_date[0]), |
|
| 37 | + 'to' => trim($disabled_date[1]), |
|
| 38 | 38 | ); |
| 39 | 39 | |
| 40 | 40 | } |
| 41 | 41 | } |
| 42 | 42 | |
| 43 | 43 | $options = array( |
| 44 | - 'data-default-date' => empty( $default_date ) ? false : $default_date, |
|
| 45 | - 'data-min-date' => empty( $min_date ) ? false : $min_date, |
|
| 46 | - 'data-max-date' => empty( $max_date ) ? false : $max_date, |
|
| 47 | - 'data-mode' => empty( $mode ) ? 'single' : $mode, |
|
| 48 | - 'data-alt-format' => get_option( 'date_format', 'F j, Y' ), |
|
| 44 | + 'data-default-date' => empty($default_date) ? false : $default_date, |
|
| 45 | + 'data-min-date' => empty($min_date) ? false : $min_date, |
|
| 46 | + 'data-max-date' => empty($max_date) ? false : $max_date, |
|
| 47 | + 'data-mode' => empty($mode) ? 'single' : $mode, |
|
| 48 | + 'data-alt-format' => get_option('date_format', 'F j, Y'), |
|
| 49 | 49 | 'data-date-format' => 'Y-m-d', |
| 50 | 50 | 'data-alt-input' => 'true', |
| 51 | - 'data-disable_alt' => empty( $disabled_dates ) ? false : wp_json_encode( $disable_dates ), |
|
| 52 | - 'data-disable_days_alt' => empty( $disable_days ) ? false : wp_json_encode( wp_parse_id_list( $disable_days ) ), |
|
| 51 | + 'data-disable_alt' => empty($disabled_dates) ? false : wp_json_encode($disable_dates), |
|
| 52 | + 'data-disable_days_alt' => empty($disable_days) ? false : wp_json_encode(wp_parse_id_list($disable_days)), |
|
| 53 | 53 | ); |
| 54 | 54 | |
| 55 | 55 | aui()->input( |
| 56 | 56 | array( |
| 57 | - 'name' => esc_attr( $id ), |
|
| 58 | - 'id' => esc_attr( $element_id ), |
|
| 59 | - 'placeholder' => empty( $placeholder ) ? '' : esc_attr( $placeholder ), |
|
| 60 | - 'required' => ! empty( $required ), |
|
| 57 | + 'name' => esc_attr($id), |
|
| 58 | + 'id' => esc_attr($element_id), |
|
| 59 | + 'placeholder' => empty($placeholder) ? '' : esc_attr($placeholder), |
|
| 60 | + 'required' => !empty($required), |
|
| 61 | 61 | 'label' => $label, |
| 62 | 62 | 'label_type' => 'vertical', |
| 63 | - 'help_text' => empty( $description ) ? '' : wp_kses_post( $description ), |
|
| 63 | + 'help_text' => empty($description) ? '' : wp_kses_post($description), |
|
| 64 | 64 | 'type' => 'datepicker', |
| 65 | 65 | 'class' => $label_class . ' getpaid-init-flatpickr flatpickr-input', |
| 66 | - 'extra_attributes' => array_filter( apply_filters( 'getpaid_date_field_attributes', $options ) ), |
|
| 66 | + 'extra_attributes' => array_filter(apply_filters('getpaid_date_field_attributes', $options)), |
|
| 67 | 67 | 'value' => $query_value, |
| 68 | 68 | ), |
| 69 | 69 | true |
@@ -12,47 +12,47 @@ discard block |
||
| 12 | 12 | */ |
| 13 | 13 | class GetPaid_Reports_Export { |
| 14 | 14 | |
| 15 | - /** |
|
| 16 | - * Displays the reports tab. |
|
| 17 | - * |
|
| 18 | - */ |
|
| 19 | - public function display() { |
|
| 20 | - |
|
| 21 | - echo "<div class='row mt-4' style='max-width: 920px;' >"; |
|
| 22 | - foreach ( array_keys( getpaid_get_invoice_post_types() ) as $post_type ) { |
|
| 23 | - $this->display_post_type_export( $post_type ); |
|
| 24 | - } |
|
| 25 | - $this->display_subscription_export(); |
|
| 26 | - echo '</div>'; |
|
| 27 | - |
|
| 28 | - } |
|
| 29 | - |
|
| 30 | - /** |
|
| 31 | - * Retrieves the download url. |
|
| 32 | - * |
|
| 33 | - */ |
|
| 34 | - public function get_download_url( $post_type ) { |
|
| 35 | - |
|
| 36 | - return wp_nonce_url( |
|
| 37 | - add_query_arg( |
|
| 38 | - array( |
|
| 39 | - 'getpaid-admin-action' => 'export_invoices', |
|
| 40 | - 'post_type' => urlencode( $post_type ), |
|
| 41 | - ) |
|
| 42 | - ), |
|
| 43 | - 'getpaid-nonce', |
|
| 44 | - 'getpaid-nonce' |
|
| 45 | - ); |
|
| 46 | - |
|
| 47 | - } |
|
| 48 | - |
|
| 49 | - /** |
|
| 50 | - * Displays a single post type export card. |
|
| 51 | - * |
|
| 52 | - */ |
|
| 53 | - public function display_post_type_export( $post_type ) { |
|
| 54 | - |
|
| 55 | - ?> |
|
| 15 | + /** |
|
| 16 | + * Displays the reports tab. |
|
| 17 | + * |
|
| 18 | + */ |
|
| 19 | + public function display() { |
|
| 20 | + |
|
| 21 | + echo "<div class='row mt-4' style='max-width: 920px;' >"; |
|
| 22 | + foreach ( array_keys( getpaid_get_invoice_post_types() ) as $post_type ) { |
|
| 23 | + $this->display_post_type_export( $post_type ); |
|
| 24 | + } |
|
| 25 | + $this->display_subscription_export(); |
|
| 26 | + echo '</div>'; |
|
| 27 | + |
|
| 28 | + } |
|
| 29 | + |
|
| 30 | + /** |
|
| 31 | + * Retrieves the download url. |
|
| 32 | + * |
|
| 33 | + */ |
|
| 34 | + public function get_download_url( $post_type ) { |
|
| 35 | + |
|
| 36 | + return wp_nonce_url( |
|
| 37 | + add_query_arg( |
|
| 38 | + array( |
|
| 39 | + 'getpaid-admin-action' => 'export_invoices', |
|
| 40 | + 'post_type' => urlencode( $post_type ), |
|
| 41 | + ) |
|
| 42 | + ), |
|
| 43 | + 'getpaid-nonce', |
|
| 44 | + 'getpaid-nonce' |
|
| 45 | + ); |
|
| 46 | + |
|
| 47 | + } |
|
| 48 | + |
|
| 49 | + /** |
|
| 50 | + * Displays a single post type export card. |
|
| 51 | + * |
|
| 52 | + */ |
|
| 53 | + public function display_post_type_export( $post_type ) { |
|
| 54 | + |
|
| 55 | + ?> |
|
| 56 | 56 | |
| 57 | 57 | <div class="col-12 col-md-6"> |
| 58 | 58 | <div class="card m-0 p-0" style="max-width:100%"> |
@@ -60,11 +60,11 @@ discard block |
||
| 60 | 60 | <div class="card-header"> |
| 61 | 61 | <strong> |
| 62 | 62 | <?php |
| 63 | - printf( |
|
| 64 | - esc_html__( 'Export %s', 'invoicing' ), |
|
| 65 | - esc_html( getpaid_get_post_type_label( $post_type ) ) |
|
| 66 | - ); |
|
| 67 | - ?> |
|
| 63 | + printf( |
|
| 64 | + esc_html__( 'Export %s', 'invoicing' ), |
|
| 65 | + esc_html( getpaid_get_post_type_label( $post_type ) ) |
|
| 66 | + ); |
|
| 67 | + ?> |
|
| 68 | 68 | </strong> |
| 69 | 69 | </div> |
| 70 | 70 | |
@@ -73,12 +73,12 @@ discard block |
||
| 73 | 73 | <form method="post" action="<?php echo esc_url( $this->get_download_url( $post_type ) ); ?>"> |
| 74 | 74 | |
| 75 | 75 | <?php |
| 76 | - $this->generate_from_date( $post_type ); |
|
| 77 | - $this->generate_to_date( $post_type ); |
|
| 78 | - $this->generate_post_status_select( $post_type ); |
|
| 79 | - $this->generate_file_type_select( $post_type ); |
|
| 80 | - submit_button( __( 'Download', 'invoicing' ) ); |
|
| 81 | - ?> |
|
| 76 | + $this->generate_from_date( $post_type ); |
|
| 77 | + $this->generate_to_date( $post_type ); |
|
| 78 | + $this->generate_post_status_select( $post_type ); |
|
| 79 | + $this->generate_file_type_select( $post_type ); |
|
| 80 | + submit_button( __( 'Download', 'invoicing' ) ); |
|
| 81 | + ?> |
|
| 82 | 82 | |
| 83 | 83 | </form> |
| 84 | 84 | |
@@ -89,135 +89,135 @@ discard block |
||
| 89 | 89 | |
| 90 | 90 | <?php |
| 91 | 91 | |
| 92 | - } |
|
| 93 | - |
|
| 94 | - /** |
|
| 95 | - * Generates the from date input field. |
|
| 96 | - * |
|
| 97 | - */ |
|
| 98 | - public function generate_from_date( $post_type ) { |
|
| 99 | - |
|
| 100 | - aui()->input( |
|
| 101 | - array( |
|
| 102 | - 'type' => 'datepicker', |
|
| 103 | - 'id' => esc_attr( "$post_type-from_date" ), |
|
| 104 | - 'name' => 'from_date', |
|
| 105 | - 'label' => __( 'From Date', 'invoicing' ), |
|
| 106 | - 'label_type' => 'vertical', |
|
| 107 | - 'placeholder' => 'YYYY-MM-DD', |
|
| 108 | - 'extra_attributes' => array( |
|
| 109 | - 'data-enable-time' => 'false', |
|
| 110 | - 'data-allow-input' => 'true', |
|
| 111 | - ), |
|
| 112 | - ), |
|
| 113 | - true |
|
| 114 | - ); |
|
| 115 | - |
|
| 116 | - } |
|
| 117 | - |
|
| 118 | - /** |
|
| 119 | - * Generates the to date input field. |
|
| 120 | - * |
|
| 121 | - */ |
|
| 122 | - public function generate_to_date( $post_type ) { |
|
| 123 | - |
|
| 124 | - aui()->input( |
|
| 125 | - array( |
|
| 126 | - 'type' => 'datepicker', |
|
| 127 | - 'id' => esc_attr( "$post_type-to_date" ), |
|
| 128 | - 'name' => 'to_date', |
|
| 129 | - 'label' => __( 'To Date', 'invoicing' ), |
|
| 130 | - 'label_type' => 'vertical', |
|
| 131 | - 'placeholder' => 'YYYY-MM-DD', |
|
| 132 | - 'extra_attributes' => array( |
|
| 133 | - 'data-enable-time' => 'false', |
|
| 134 | - 'data-allow-input' => 'true', |
|
| 135 | - ), |
|
| 136 | - ), |
|
| 137 | - true |
|
| 138 | - ); |
|
| 139 | - } |
|
| 140 | - |
|
| 141 | - /** |
|
| 142 | - * Generates the to post status select field. |
|
| 143 | - * |
|
| 144 | - */ |
|
| 145 | - public function generate_post_status_select( $post_type ) { |
|
| 146 | - |
|
| 147 | - if ( 'subscriptions' === $post_type ) { |
|
| 148 | - $options = getpaid_get_subscription_statuses(); |
|
| 149 | - } else { |
|
| 150 | - $options = wpinv_get_invoice_statuses( true, false, $post_type ); |
|
| 151 | - } |
|
| 152 | - |
|
| 153 | - aui()->select( |
|
| 154 | - array( |
|
| 155 | - 'name' => 'status', |
|
| 156 | - 'id' => esc_attr( "$post_type-status" ), |
|
| 157 | - 'placeholder' => __( 'All Statuses', 'invoicing' ), |
|
| 158 | - 'label' => __( 'Status', 'invoicing' ), |
|
| 159 | - 'label_type' => 'vertical', |
|
| 160 | - 'label_class' => 'd-block', |
|
| 161 | - 'options' => $options, |
|
| 162 | - ), |
|
| 163 | - true |
|
| 164 | - ); |
|
| 165 | - |
|
| 166 | - } |
|
| 167 | - |
|
| 168 | - /** |
|
| 169 | - * Generates the to file type select field. |
|
| 170 | - * |
|
| 171 | - */ |
|
| 172 | - public function generate_file_type_select( $post_type ) { |
|
| 173 | - |
|
| 174 | - aui()->select( |
|
| 175 | - array( |
|
| 176 | - 'name' => 'file_type', |
|
| 177 | - 'id' => esc_attr( "$post_type-file_type" ), |
|
| 178 | - 'placeholder' => __( 'Select File Type', 'invoicing' ), |
|
| 179 | - 'label' => __( 'Export File', 'invoicing' ), |
|
| 180 | - 'label_type' => 'vertical', |
|
| 181 | - 'label_class' => 'd-block', |
|
| 182 | - 'value' => 'csv', |
|
| 183 | - 'options' => array( |
|
| 184 | - 'csv' => __( 'CSV', 'invoicing' ), |
|
| 185 | - 'xml' => __( 'XML', 'invoicing' ), |
|
| 186 | - 'json' => __( 'JSON', 'invoicing' ), |
|
| 187 | - ), |
|
| 188 | - ), |
|
| 189 | - true |
|
| 190 | - ); |
|
| 191 | - |
|
| 192 | - } |
|
| 193 | - |
|
| 194 | - /** |
|
| 195 | - * Displays a field's markup. |
|
| 196 | - * |
|
| 197 | - */ |
|
| 198 | - public function display_markup( $markup ) { |
|
| 199 | - |
|
| 200 | - echo wp_kses( |
|
| 201 | - str_replace( |
|
| 202 | - array( |
|
| 203 | - 'form-control', |
|
| 204 | - 'custom-select', |
|
| 205 | - ), |
|
| 206 | - 'regular-text', |
|
| 207 | - $markup |
|
| 208 | - ), |
|
| 209 | - getpaid_allowed_html() |
|
| 210 | - ); |
|
| 211 | - |
|
| 212 | - } |
|
| 213 | - |
|
| 214 | - /** |
|
| 215 | - * Displays a subscription export card. |
|
| 216 | - * |
|
| 217 | - */ |
|
| 218 | - public function display_subscription_export() { |
|
| 219 | - |
|
| 220 | - ?> |
|
| 92 | + } |
|
| 93 | + |
|
| 94 | + /** |
|
| 95 | + * Generates the from date input field. |
|
| 96 | + * |
|
| 97 | + */ |
|
| 98 | + public function generate_from_date( $post_type ) { |
|
| 99 | + |
|
| 100 | + aui()->input( |
|
| 101 | + array( |
|
| 102 | + 'type' => 'datepicker', |
|
| 103 | + 'id' => esc_attr( "$post_type-from_date" ), |
|
| 104 | + 'name' => 'from_date', |
|
| 105 | + 'label' => __( 'From Date', 'invoicing' ), |
|
| 106 | + 'label_type' => 'vertical', |
|
| 107 | + 'placeholder' => 'YYYY-MM-DD', |
|
| 108 | + 'extra_attributes' => array( |
|
| 109 | + 'data-enable-time' => 'false', |
|
| 110 | + 'data-allow-input' => 'true', |
|
| 111 | + ), |
|
| 112 | + ), |
|
| 113 | + true |
|
| 114 | + ); |
|
| 115 | + |
|
| 116 | + } |
|
| 117 | + |
|
| 118 | + /** |
|
| 119 | + * Generates the to date input field. |
|
| 120 | + * |
|
| 121 | + */ |
|
| 122 | + public function generate_to_date( $post_type ) { |
|
| 123 | + |
|
| 124 | + aui()->input( |
|
| 125 | + array( |
|
| 126 | + 'type' => 'datepicker', |
|
| 127 | + 'id' => esc_attr( "$post_type-to_date" ), |
|
| 128 | + 'name' => 'to_date', |
|
| 129 | + 'label' => __( 'To Date', 'invoicing' ), |
|
| 130 | + 'label_type' => 'vertical', |
|
| 131 | + 'placeholder' => 'YYYY-MM-DD', |
|
| 132 | + 'extra_attributes' => array( |
|
| 133 | + 'data-enable-time' => 'false', |
|
| 134 | + 'data-allow-input' => 'true', |
|
| 135 | + ), |
|
| 136 | + ), |
|
| 137 | + true |
|
| 138 | + ); |
|
| 139 | + } |
|
| 140 | + |
|
| 141 | + /** |
|
| 142 | + * Generates the to post status select field. |
|
| 143 | + * |
|
| 144 | + */ |
|
| 145 | + public function generate_post_status_select( $post_type ) { |
|
| 146 | + |
|
| 147 | + if ( 'subscriptions' === $post_type ) { |
|
| 148 | + $options = getpaid_get_subscription_statuses(); |
|
| 149 | + } else { |
|
| 150 | + $options = wpinv_get_invoice_statuses( true, false, $post_type ); |
|
| 151 | + } |
|
| 152 | + |
|
| 153 | + aui()->select( |
|
| 154 | + array( |
|
| 155 | + 'name' => 'status', |
|
| 156 | + 'id' => esc_attr( "$post_type-status" ), |
|
| 157 | + 'placeholder' => __( 'All Statuses', 'invoicing' ), |
|
| 158 | + 'label' => __( 'Status', 'invoicing' ), |
|
| 159 | + 'label_type' => 'vertical', |
|
| 160 | + 'label_class' => 'd-block', |
|
| 161 | + 'options' => $options, |
|
| 162 | + ), |
|
| 163 | + true |
|
| 164 | + ); |
|
| 165 | + |
|
| 166 | + } |
|
| 167 | + |
|
| 168 | + /** |
|
| 169 | + * Generates the to file type select field. |
|
| 170 | + * |
|
| 171 | + */ |
|
| 172 | + public function generate_file_type_select( $post_type ) { |
|
| 173 | + |
|
| 174 | + aui()->select( |
|
| 175 | + array( |
|
| 176 | + 'name' => 'file_type', |
|
| 177 | + 'id' => esc_attr( "$post_type-file_type" ), |
|
| 178 | + 'placeholder' => __( 'Select File Type', 'invoicing' ), |
|
| 179 | + 'label' => __( 'Export File', 'invoicing' ), |
|
| 180 | + 'label_type' => 'vertical', |
|
| 181 | + 'label_class' => 'd-block', |
|
| 182 | + 'value' => 'csv', |
|
| 183 | + 'options' => array( |
|
| 184 | + 'csv' => __( 'CSV', 'invoicing' ), |
|
| 185 | + 'xml' => __( 'XML', 'invoicing' ), |
|
| 186 | + 'json' => __( 'JSON', 'invoicing' ), |
|
| 187 | + ), |
|
| 188 | + ), |
|
| 189 | + true |
|
| 190 | + ); |
|
| 191 | + |
|
| 192 | + } |
|
| 193 | + |
|
| 194 | + /** |
|
| 195 | + * Displays a field's markup. |
|
| 196 | + * |
|
| 197 | + */ |
|
| 198 | + public function display_markup( $markup ) { |
|
| 199 | + |
|
| 200 | + echo wp_kses( |
|
| 201 | + str_replace( |
|
| 202 | + array( |
|
| 203 | + 'form-control', |
|
| 204 | + 'custom-select', |
|
| 205 | + ), |
|
| 206 | + 'regular-text', |
|
| 207 | + $markup |
|
| 208 | + ), |
|
| 209 | + getpaid_allowed_html() |
|
| 210 | + ); |
|
| 211 | + |
|
| 212 | + } |
|
| 213 | + |
|
| 214 | + /** |
|
| 215 | + * Displays a subscription export card. |
|
| 216 | + * |
|
| 217 | + */ |
|
| 218 | + public function display_subscription_export() { |
|
| 219 | + |
|
| 220 | + ?> |
|
| 221 | 221 | |
| 222 | 222 | <div class="col-12 col-md-6"> |
| 223 | 223 | <div class="card m-0 p-0" style="max-width:100%"> |
@@ -233,12 +233,12 @@ discard block |
||
| 233 | 233 | <form method="post" action="<?php echo esc_url( $this->get_download_url( 'subscriptions' ) ); ?>"> |
| 234 | 234 | |
| 235 | 235 | <?php |
| 236 | - $this->generate_from_date( 'subscriptions' ); |
|
| 237 | - $this->generate_to_date( 'subscriptions' ); |
|
| 238 | - $this->generate_post_status_select( 'subscriptions' ); |
|
| 239 | - $this->generate_file_type_select( 'subscriptions' ); |
|
| 240 | - submit_button( __( 'Download', 'invoicing' ) ); |
|
| 241 | - ?> |
|
| 236 | + $this->generate_from_date( 'subscriptions' ); |
|
| 237 | + $this->generate_to_date( 'subscriptions' ); |
|
| 238 | + $this->generate_post_status_select( 'subscriptions' ); |
|
| 239 | + $this->generate_file_type_select( 'subscriptions' ); |
|
| 240 | + submit_button( __( 'Download', 'invoicing' ) ); |
|
| 241 | + ?> |
|
| 242 | 242 | |
| 243 | 243 | </form> |
| 244 | 244 | |
@@ -249,6 +249,6 @@ discard block |
||
| 249 | 249 | |
| 250 | 250 | <?php |
| 251 | 251 | |
| 252 | - } |
|
| 252 | + } |
|
| 253 | 253 | |
| 254 | 254 | } |
@@ -5,7 +5,7 @@ discard block |
||
| 5 | 5 | * |
| 6 | 6 | */ |
| 7 | 7 | |
| 8 | -defined( 'ABSPATH' ) || exit; |
|
| 8 | +defined('ABSPATH') || exit; |
|
| 9 | 9 | |
| 10 | 10 | /** |
| 11 | 11 | * GetPaid_Reports_Export Class. |
@@ -19,8 +19,8 @@ discard block |
||
| 19 | 19 | public function display() { |
| 20 | 20 | |
| 21 | 21 | echo "<div class='row mt-4' style='max-width: 920px;' >"; |
| 22 | - foreach ( array_keys( getpaid_get_invoice_post_types() ) as $post_type ) { |
|
| 23 | - $this->display_post_type_export( $post_type ); |
|
| 22 | + foreach (array_keys(getpaid_get_invoice_post_types()) as $post_type) { |
|
| 23 | + $this->display_post_type_export($post_type); |
|
| 24 | 24 | } |
| 25 | 25 | $this->display_subscription_export(); |
| 26 | 26 | echo '</div>'; |
@@ -31,13 +31,13 @@ discard block |
||
| 31 | 31 | * Retrieves the download url. |
| 32 | 32 | * |
| 33 | 33 | */ |
| 34 | - public function get_download_url( $post_type ) { |
|
| 34 | + public function get_download_url($post_type) { |
|
| 35 | 35 | |
| 36 | 36 | return wp_nonce_url( |
| 37 | 37 | add_query_arg( |
| 38 | 38 | array( |
| 39 | 39 | 'getpaid-admin-action' => 'export_invoices', |
| 40 | - 'post_type' => urlencode( $post_type ), |
|
| 40 | + 'post_type' => urlencode($post_type), |
|
| 41 | 41 | ) |
| 42 | 42 | ), |
| 43 | 43 | 'getpaid-nonce', |
@@ -50,7 +50,7 @@ discard block |
||
| 50 | 50 | * Displays a single post type export card. |
| 51 | 51 | * |
| 52 | 52 | */ |
| 53 | - public function display_post_type_export( $post_type ) { |
|
| 53 | + public function display_post_type_export($post_type) { |
|
| 54 | 54 | |
| 55 | 55 | ?> |
| 56 | 56 | |
@@ -61,8 +61,8 @@ discard block |
||
| 61 | 61 | <strong> |
| 62 | 62 | <?php |
| 63 | 63 | printf( |
| 64 | - esc_html__( 'Export %s', 'invoicing' ), |
|
| 65 | - esc_html( getpaid_get_post_type_label( $post_type ) ) |
|
| 64 | + esc_html__('Export %s', 'invoicing'), |
|
| 65 | + esc_html(getpaid_get_post_type_label($post_type)) |
|
| 66 | 66 | ); |
| 67 | 67 | ?> |
| 68 | 68 | </strong> |
@@ -70,14 +70,14 @@ discard block |
||
| 70 | 70 | |
| 71 | 71 | <div class="card-body"> |
| 72 | 72 | |
| 73 | - <form method="post" action="<?php echo esc_url( $this->get_download_url( $post_type ) ); ?>"> |
|
| 73 | + <form method="post" action="<?php echo esc_url($this->get_download_url($post_type)); ?>"> |
|
| 74 | 74 | |
| 75 | 75 | <?php |
| 76 | - $this->generate_from_date( $post_type ); |
|
| 77 | - $this->generate_to_date( $post_type ); |
|
| 78 | - $this->generate_post_status_select( $post_type ); |
|
| 79 | - $this->generate_file_type_select( $post_type ); |
|
| 80 | - submit_button( __( 'Download', 'invoicing' ) ); |
|
| 76 | + $this->generate_from_date($post_type); |
|
| 77 | + $this->generate_to_date($post_type); |
|
| 78 | + $this->generate_post_status_select($post_type); |
|
| 79 | + $this->generate_file_type_select($post_type); |
|
| 80 | + submit_button(__('Download', 'invoicing')); |
|
| 81 | 81 | ?> |
| 82 | 82 | |
| 83 | 83 | </form> |
@@ -95,14 +95,14 @@ discard block |
||
| 95 | 95 | * Generates the from date input field. |
| 96 | 96 | * |
| 97 | 97 | */ |
| 98 | - public function generate_from_date( $post_type ) { |
|
| 98 | + public function generate_from_date($post_type) { |
|
| 99 | 99 | |
| 100 | 100 | aui()->input( |
| 101 | 101 | array( |
| 102 | 102 | 'type' => 'datepicker', |
| 103 | - 'id' => esc_attr( "$post_type-from_date" ), |
|
| 103 | + 'id' => esc_attr("$post_type-from_date"), |
|
| 104 | 104 | 'name' => 'from_date', |
| 105 | - 'label' => __( 'From Date', 'invoicing' ), |
|
| 105 | + 'label' => __('From Date', 'invoicing'), |
|
| 106 | 106 | 'label_type' => 'vertical', |
| 107 | 107 | 'placeholder' => 'YYYY-MM-DD', |
| 108 | 108 | 'extra_attributes' => array( |
@@ -119,14 +119,14 @@ discard block |
||
| 119 | 119 | * Generates the to date input field. |
| 120 | 120 | * |
| 121 | 121 | */ |
| 122 | - public function generate_to_date( $post_type ) { |
|
| 122 | + public function generate_to_date($post_type) { |
|
| 123 | 123 | |
| 124 | 124 | aui()->input( |
| 125 | 125 | array( |
| 126 | 126 | 'type' => 'datepicker', |
| 127 | - 'id' => esc_attr( "$post_type-to_date" ), |
|
| 127 | + 'id' => esc_attr("$post_type-to_date"), |
|
| 128 | 128 | 'name' => 'to_date', |
| 129 | - 'label' => __( 'To Date', 'invoicing' ), |
|
| 129 | + 'label' => __('To Date', 'invoicing'), |
|
| 130 | 130 | 'label_type' => 'vertical', |
| 131 | 131 | 'placeholder' => 'YYYY-MM-DD', |
| 132 | 132 | 'extra_attributes' => array( |
@@ -142,20 +142,20 @@ discard block |
||
| 142 | 142 | * Generates the to post status select field. |
| 143 | 143 | * |
| 144 | 144 | */ |
| 145 | - public function generate_post_status_select( $post_type ) { |
|
| 145 | + public function generate_post_status_select($post_type) { |
|
| 146 | 146 | |
| 147 | - if ( 'subscriptions' === $post_type ) { |
|
| 147 | + if ('subscriptions' === $post_type) { |
|
| 148 | 148 | $options = getpaid_get_subscription_statuses(); |
| 149 | 149 | } else { |
| 150 | - $options = wpinv_get_invoice_statuses( true, false, $post_type ); |
|
| 150 | + $options = wpinv_get_invoice_statuses(true, false, $post_type); |
|
| 151 | 151 | } |
| 152 | 152 | |
| 153 | 153 | aui()->select( |
| 154 | 154 | array( |
| 155 | 155 | 'name' => 'status', |
| 156 | - 'id' => esc_attr( "$post_type-status" ), |
|
| 157 | - 'placeholder' => __( 'All Statuses', 'invoicing' ), |
|
| 158 | - 'label' => __( 'Status', 'invoicing' ), |
|
| 156 | + 'id' => esc_attr("$post_type-status"), |
|
| 157 | + 'placeholder' => __('All Statuses', 'invoicing'), |
|
| 158 | + 'label' => __('Status', 'invoicing'), |
|
| 159 | 159 | 'label_type' => 'vertical', |
| 160 | 160 | 'label_class' => 'd-block', |
| 161 | 161 | 'options' => $options, |
@@ -169,21 +169,21 @@ discard block |
||
| 169 | 169 | * Generates the to file type select field. |
| 170 | 170 | * |
| 171 | 171 | */ |
| 172 | - public function generate_file_type_select( $post_type ) { |
|
| 172 | + public function generate_file_type_select($post_type) { |
|
| 173 | 173 | |
| 174 | 174 | aui()->select( |
| 175 | 175 | array( |
| 176 | 176 | 'name' => 'file_type', |
| 177 | - 'id' => esc_attr( "$post_type-file_type" ), |
|
| 178 | - 'placeholder' => __( 'Select File Type', 'invoicing' ), |
|
| 179 | - 'label' => __( 'Export File', 'invoicing' ), |
|
| 177 | + 'id' => esc_attr("$post_type-file_type"), |
|
| 178 | + 'placeholder' => __('Select File Type', 'invoicing'), |
|
| 179 | + 'label' => __('Export File', 'invoicing'), |
|
| 180 | 180 | 'label_type' => 'vertical', |
| 181 | 181 | 'label_class' => 'd-block', |
| 182 | 182 | 'value' => 'csv', |
| 183 | 183 | 'options' => array( |
| 184 | - 'csv' => __( 'CSV', 'invoicing' ), |
|
| 185 | - 'xml' => __( 'XML', 'invoicing' ), |
|
| 186 | - 'json' => __( 'JSON', 'invoicing' ), |
|
| 184 | + 'csv' => __('CSV', 'invoicing'), |
|
| 185 | + 'xml' => __('XML', 'invoicing'), |
|
| 186 | + 'json' => __('JSON', 'invoicing'), |
|
| 187 | 187 | ), |
| 188 | 188 | ), |
| 189 | 189 | true |
@@ -195,7 +195,7 @@ discard block |
||
| 195 | 195 | * Displays a field's markup. |
| 196 | 196 | * |
| 197 | 197 | */ |
| 198 | - public function display_markup( $markup ) { |
|
| 198 | + public function display_markup($markup) { |
|
| 199 | 199 | |
| 200 | 200 | echo wp_kses( |
| 201 | 201 | str_replace( |
@@ -224,20 +224,20 @@ discard block |
||
| 224 | 224 | |
| 225 | 225 | <div class="card-header"> |
| 226 | 226 | <strong> |
| 227 | - <?php esc_html_e( 'Export Subscriptions', 'invoicing' ); ?> |
|
| 227 | + <?php esc_html_e('Export Subscriptions', 'invoicing'); ?> |
|
| 228 | 228 | </strong> |
| 229 | 229 | </div> |
| 230 | 230 | |
| 231 | 231 | <div class="card-body"> |
| 232 | 232 | |
| 233 | - <form method="post" action="<?php echo esc_url( $this->get_download_url( 'subscriptions' ) ); ?>"> |
|
| 233 | + <form method="post" action="<?php echo esc_url($this->get_download_url('subscriptions')); ?>"> |
|
| 234 | 234 | |
| 235 | 235 | <?php |
| 236 | - $this->generate_from_date( 'subscriptions' ); |
|
| 237 | - $this->generate_to_date( 'subscriptions' ); |
|
| 238 | - $this->generate_post_status_select( 'subscriptions' ); |
|
| 239 | - $this->generate_file_type_select( 'subscriptions' ); |
|
| 240 | - submit_button( __( 'Download', 'invoicing' ) ); |
|
| 236 | + $this->generate_from_date('subscriptions'); |
|
| 237 | + $this->generate_to_date('subscriptions'); |
|
| 238 | + $this->generate_post_status_select('subscriptions'); |
|
| 239 | + $this->generate_file_type_select('subscriptions'); |
|
| 240 | + submit_button(__('Download', 'invoicing')); |
|
| 241 | 241 | ?> |
| 242 | 242 | |
| 243 | 243 | </form> |
@@ -16,512 +16,512 @@ |
||
| 16 | 16 | */ |
| 17 | 17 | class GetPaid_Subscriptions_Query { |
| 18 | 18 | |
| 19 | - /** |
|
| 20 | - * Query vars, after parsing |
|
| 21 | - * |
|
| 22 | - * @since 1.0.19 |
|
| 23 | - * @var array |
|
| 24 | - */ |
|
| 25 | - public $query_vars = array(); |
|
| 26 | - |
|
| 27 | - /** |
|
| 28 | - * List of found subscriptions. |
|
| 29 | - * |
|
| 30 | - * @since 1.0.19 |
|
| 31 | - * @var array |
|
| 32 | - */ |
|
| 33 | - private $results; |
|
| 34 | - |
|
| 35 | - /** |
|
| 36 | - * Total number of found subscriptions for the current query |
|
| 37 | - * |
|
| 38 | - * @since 1.0.19 |
|
| 39 | - * @var int |
|
| 40 | - */ |
|
| 41 | - private $total_subscriptions = 0; |
|
| 42 | - |
|
| 43 | - /** |
|
| 44 | - * The SQL query used to fetch matching subscriptions. |
|
| 45 | - * |
|
| 46 | - * @since 1.0.19 |
|
| 47 | - * @var string |
|
| 48 | - */ |
|
| 49 | - public $request; |
|
| 50 | - |
|
| 51 | - // SQL clauses |
|
| 52 | - |
|
| 53 | - /** |
|
| 54 | - * Contains the 'FIELDS' sql clause |
|
| 55 | - * |
|
| 56 | - * @since 1.0.19 |
|
| 57 | - * @var string |
|
| 58 | - */ |
|
| 59 | - public $query_fields; |
|
| 60 | - |
|
| 61 | - /** |
|
| 62 | - * Contains the 'FROM' sql clause |
|
| 63 | - * |
|
| 64 | - * @since 1.0.19 |
|
| 65 | - * @var string |
|
| 66 | - */ |
|
| 67 | - public $query_from; |
|
| 68 | - |
|
| 69 | - /** |
|
| 70 | - * Contains the 'WHERE' sql clause |
|
| 71 | - * |
|
| 72 | - * @since 1.0.19 |
|
| 73 | - * @var string |
|
| 74 | - */ |
|
| 75 | - public $query_where; |
|
| 76 | - |
|
| 77 | - /** |
|
| 78 | - * Contains the 'ORDER BY' sql clause |
|
| 79 | - * |
|
| 80 | - * @since 1.0.19 |
|
| 81 | - * @var string |
|
| 82 | - */ |
|
| 83 | - public $query_orderby; |
|
| 84 | - |
|
| 85 | - /** |
|
| 86 | - * Contains the 'LIMIT' sql clause |
|
| 87 | - * |
|
| 88 | - * @since 1.0.19 |
|
| 89 | - * @var string |
|
| 90 | - */ |
|
| 91 | - public $query_limit; |
|
| 92 | - |
|
| 93 | - /** |
|
| 94 | - * Class constructor. |
|
| 95 | - * |
|
| 96 | - * @since 1.0.19 |
|
| 97 | - * |
|
| 98 | - * @param null|string|array $query Optional. The query variables. |
|
| 99 | - */ |
|
| 100 | - public function __construct( $query = null ) { |
|
| 101 | - if ( ! is_null( $query ) ) { |
|
| 102 | - $this->prepare_query( $query ); |
|
| 103 | - $this->query(); |
|
| 104 | - } |
|
| 105 | - } |
|
| 106 | - |
|
| 107 | - /** |
|
| 108 | - * Fills in missing query variables with default values. |
|
| 109 | - * |
|
| 110 | - * @since 1.0.19 |
|
| 111 | - * |
|
| 112 | - * @param string|array $args Query vars, as passed to `GetPaid_Subscriptions_Query`. |
|
| 113 | - * @return array Complete query variables with undefined ones filled in with defaults. |
|
| 114 | - */ |
|
| 115 | - public static function fill_query_vars( $args ) { |
|
| 116 | - $defaults = array( |
|
| 117 | - 'status' => 'all', |
|
| 118 | - 'customer_in' => array(), |
|
| 119 | - 'customer_not_in' => array(), |
|
| 120 | - 'product_in' => array(), |
|
| 121 | - 'product_not_in' => array(), |
|
| 122 | - 'include' => array(), |
|
| 123 | - 'exclude' => array(), |
|
| 124 | - 'orderby' => 'id', |
|
| 125 | - 'order' => 'DESC', |
|
| 126 | - 'offset' => '', |
|
| 127 | - 'number' => 10, |
|
| 128 | - 'paged' => 1, |
|
| 129 | - 'count_total' => true, |
|
| 130 | - 'fields' => 'all', |
|
| 131 | - ); |
|
| 132 | - |
|
| 133 | - return wp_parse_args( $args, $defaults ); |
|
| 134 | - } |
|
| 135 | - |
|
| 136 | - /** |
|
| 137 | - * Prepare the query variables. |
|
| 138 | - * |
|
| 139 | - * @since 1.0.19 |
|
| 140 | - * |
|
| 141 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
| 142 | - * |
|
| 143 | - * @param string|array $query { |
|
| 144 | - * Optional. Array or string of Query parameters. |
|
| 145 | - * |
|
| 146 | - * @type string|array $status The subscription status to filter by. Can either be a single status or an array of statuses. |
|
| 147 | - * Default is all. |
|
| 148 | - * @type int[] $customer_in An array of customer ids to filter by. |
|
| 149 | - * @type int[] $customer_not_in An array of customer ids whose subscriptions should be excluded. |
|
| 150 | - * @type int[] $invoice_in An array of invoice ids to filter by. |
|
| 151 | - * @type int[] $invoice_not_in An array of invoice ids whose subscriptions should be excluded. |
|
| 152 | - * @type int[] $product_in An array of product ids to filter by. |
|
| 153 | - * @type int[] $product_not_in An array of product ids whose subscriptions should be excluded. |
|
| 154 | - * @type array $date_created_query A WP_Date_Query compatible array use to filter subscriptions by their date of creation. |
|
| 155 | - * @type array $date_expires_query A WP_Date_Query compatible array use to filter subscriptions by their expiration date. |
|
| 156 | - * @type array $include An array of subscription IDs to include. Default empty array. |
|
| 157 | - * @type array $exclude An array of subscription IDs to exclude. Default empty array. |
|
| 158 | - * @type string|array $orderby Field(s) to sort the retrieved subscription by. May be a single value, |
|
| 159 | - * an array of values, or a multi-dimensional array with fields as |
|
| 160 | - * keys and orders ('ASC' or 'DESC') as values. Accepted values are |
|
| 161 | - * 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
| 162 | - * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
| 163 | - * 'transaction_id', 'product_id', 'trial_period', 'include', 'status', 'profile_id'. Default array( 'id' ). |
|
| 164 | - * @type string $order Designates ascending or descending order of subscriptions. Order values |
|
| 165 | - * passed as part of an `$orderby` array take precedence over this |
|
| 166 | - * parameter. Accepts 'ASC', 'DESC'. Default 'DESC'. |
|
| 167 | - * @type int $offset Number of subscriptions to offset in retrieved results. Can be used in |
|
| 168 | - * conjunction with pagination. Default 0. |
|
| 169 | - * @type int $number Number of subscriptions to limit the query for. Can be used in |
|
| 170 | - * conjunction with pagination. Value -1 (all) is supported, but |
|
| 171 | - * should be used with caution on larger sites. |
|
| 172 | - * Default 10. |
|
| 173 | - * @type int $paged When used with number, defines the page of results to return. |
|
| 174 | - * Default 1. |
|
| 175 | - * @type bool $count_total Whether to count the total number of subscriptions found. If pagination |
|
| 176 | - * is not needed, setting this to false can improve performance. |
|
| 177 | - * Default true. |
|
| 178 | - * @type string|array $fields Which fields to return. Single or all fields (string), or array |
|
| 179 | - * of fields. Accepts 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
| 180 | - * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
| 181 | - * 'transaction_id', 'product_id', 'trial_period', 'status', 'profile_id'. |
|
| 182 | - * Use 'all' for all fields. Default 'all'. |
|
| 183 | - * } |
|
| 184 | - */ |
|
| 185 | - public function prepare_query( $query = array() ) { |
|
| 186 | - global $wpdb; |
|
| 187 | - |
|
| 188 | - if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
| 189 | - $this->query_limit = null; |
|
| 190 | - $this->query_vars = $this->fill_query_vars( $query ); |
|
| 191 | - } |
|
| 192 | - |
|
| 193 | - if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
| 194 | - $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
| 195 | - } |
|
| 196 | - |
|
| 197 | - do_action( 'getpaid_pre_get_subscriptions', array( &$this ) ); |
|
| 198 | - |
|
| 199 | - // Ensure that query vars are filled after 'getpaid_pre_get_subscriptions'. |
|
| 200 | - $qv =& $this->query_vars; |
|
| 201 | - $qv = $this->fill_query_vars( $qv ); |
|
| 202 | - $table = $wpdb->prefix . 'wpinv_subscriptions'; |
|
| 203 | - $this->query_from = "FROM $table"; |
|
| 204 | - |
|
| 205 | - // Prepare query fields. |
|
| 206 | - $this->prepare_query_fields( $qv, $table ); |
|
| 207 | - |
|
| 208 | - // Prepare query where. |
|
| 209 | - $this->prepare_query_where( $qv, $table ); |
|
| 210 | - |
|
| 211 | - // Prepare query order. |
|
| 212 | - $this->prepare_query_order( $qv, $table ); |
|
| 213 | - |
|
| 214 | - // limit |
|
| 215 | - if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
| 216 | - if ( $qv['offset'] ) { |
|
| 217 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
| 218 | - } else { |
|
| 219 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
| 220 | - } |
|
| 221 | - } |
|
| 222 | - |
|
| 223 | - do_action_ref_array( 'getpaid_after_subscriptions_query', array( &$this ) ); |
|
| 224 | - } |
|
| 225 | - |
|
| 226 | - /** |
|
| 227 | - * Prepares the query fields. |
|
| 228 | - * |
|
| 229 | - * @since 1.0.19 |
|
| 230 | - * |
|
| 231 | - * @param array $qv Query vars. |
|
| 232 | - * @param string $table Table name. |
|
| 233 | - */ |
|
| 234 | - protected function prepare_query_fields( &$qv, $table ) { |
|
| 235 | - |
|
| 236 | - if ( is_array( $qv['fields'] ) ) { |
|
| 237 | - $qv['fields'] = array_unique( $qv['fields'] ); |
|
| 238 | - |
|
| 239 | - $query_fields = array(); |
|
| 240 | - foreach ( $qv['fields'] as $field ) { |
|
| 241 | - $field = sanitize_key( $field ); |
|
| 242 | - $query_fields[] = "$table.`$field`"; |
|
| 243 | - } |
|
| 244 | - $this->query_fields = implode( ',', $query_fields ); |
|
| 245 | - } else { |
|
| 246 | - $this->query_fields = "$table.*"; |
|
| 247 | - } |
|
| 248 | - |
|
| 249 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 250 | - $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
| 251 | - } |
|
| 252 | - |
|
| 253 | - } |
|
| 254 | - |
|
| 255 | - /** |
|
| 256 | - * Prepares the query where. |
|
| 257 | - * |
|
| 258 | - * @since 1.0.19 |
|
| 259 | - * |
|
| 260 | - * @param array $qv Query vars. |
|
| 261 | - * @param string $table Table name. |
|
| 262 | - */ |
|
| 263 | - protected function prepare_query_where( &$qv, $table ) { |
|
| 264 | - global $wpdb; |
|
| 265 | - $this->query_where = 'WHERE 1=1'; |
|
| 266 | - |
|
| 267 | - // Status. |
|
| 268 | - if ( 'all' !== $qv['status'] ) { |
|
| 269 | - $statuses = wpinv_clean( wpinv_parse_list( $qv['status'] ) ); |
|
| 270 | - $prepared_statuses = join( ',', array_fill( 0, count( $statuses ), '%s' ) ); |
|
| 271 | - $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $prepared_statuses )", $statuses ); |
|
| 272 | - } |
|
| 273 | - |
|
| 274 | - if ( ! empty( $qv['customer_in'] ) ) { |
|
| 275 | - $customer_in = implode( ',', wp_parse_id_list( $qv['customer_in'] ) ); |
|
| 276 | - $this->query_where .= " AND $table.`customer_id` IN ($customer_in)"; |
|
| 277 | - } elseif ( ! empty( $qv['customer_not_in'] ) ) { |
|
| 278 | - $customer_not_in = implode( ',', wp_parse_id_list( $qv['customer_not_in'] ) ); |
|
| 279 | - $this->query_where .= " AND $table.`customer_id` NOT IN ($customer_not_in)"; |
|
| 280 | - } |
|
| 281 | - |
|
| 282 | - if ( ! empty( $qv['product_in'] ) ) { |
|
| 283 | - $product_in = implode( ',', wp_parse_id_list( $qv['product_in'] ) ); |
|
| 284 | - $this->query_where .= " AND $table.`product_id` IN ($product_in)"; |
|
| 285 | - } elseif ( ! empty( $qv['product_not_in'] ) ) { |
|
| 286 | - $product_not_in = implode( ',', wp_parse_id_list( $qv['product_not_in'] ) ); |
|
| 287 | - $this->query_where .= " AND $table.`product_id` NOT IN ($product_not_in)"; |
|
| 288 | - } |
|
| 289 | - |
|
| 290 | - if ( ! empty( $qv['invoice_in'] ) ) { |
|
| 291 | - $invoice_in = implode( ',', wp_parse_id_list( $qv['invoice_in'] ) ); |
|
| 292 | - $this->query_where .= " AND $table.`parent_payment_id` IN ($invoice_in)"; |
|
| 293 | - } elseif ( ! empty( $qv['invoice_not_in'] ) ) { |
|
| 294 | - $invoice_not_in = implode( ',', wp_parse_id_list( $qv['invoice_not_in'] ) ); |
|
| 295 | - $this->query_where .= " AND $table.`parent_payment_id` NOT IN ($invoice_not_in)"; |
|
| 296 | - } |
|
| 297 | - |
|
| 298 | - if ( ! empty( $qv['include'] ) ) { |
|
| 299 | - $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
| 300 | - $this->query_where .= " AND $table.`id` IN ($include)"; |
|
| 301 | - } elseif ( ! empty( $qv['exclude'] ) ) { |
|
| 302 | - $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
| 303 | - $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
| 304 | - } |
|
| 305 | - |
|
| 306 | - // Date queries are allowed for the subscription creation date. |
|
| 307 | - if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
| 308 | - $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.created" ); |
|
| 309 | - $this->query_where .= $date_created_query->get_sql(); |
|
| 310 | - } |
|
| 311 | - |
|
| 312 | - // Date queries are also allowed for the subscription expiration date. |
|
| 313 | - if ( ! empty( $qv['date_expires_query'] ) && is_array( $qv['date_expires_query'] ) ) { |
|
| 314 | - $date_expires_query = new WP_Date_Query( $qv['date_expires_query'], "$table.expiration" ); |
|
| 315 | - $this->query_where .= $date_expires_query->get_sql(); |
|
| 316 | - } |
|
| 317 | - |
|
| 318 | - } |
|
| 319 | - |
|
| 320 | - /** |
|
| 321 | - * Prepares the query order. |
|
| 322 | - * |
|
| 323 | - * @since 1.0.19 |
|
| 324 | - * |
|
| 325 | - * @param array $qv Query vars. |
|
| 326 | - * @param string $table Table name. |
|
| 327 | - */ |
|
| 328 | - protected function prepare_query_order( &$qv, $table ) { |
|
| 329 | - |
|
| 330 | - // sorting. |
|
| 331 | - $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
| 332 | - $order = $this->parse_order( $qv['order'] ); |
|
| 333 | - |
|
| 334 | - // Default order is by 'id' (latest subscriptions). |
|
| 335 | - if ( empty( $qv['orderby'] ) ) { |
|
| 336 | - $qv['orderby'] = array( 'id' ); |
|
| 337 | - } |
|
| 338 | - |
|
| 339 | - // 'orderby' values may be an array, comma- or space-separated list. |
|
| 340 | - $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
| 341 | - |
|
| 342 | - $orderby_array = array(); |
|
| 343 | - foreach ( $ordersby as $_key => $_value ) { |
|
| 344 | - |
|
| 345 | - if ( is_int( $_key ) ) { |
|
| 346 | - // Integer key means this is a flat array of 'orderby' fields. |
|
| 347 | - $_orderby = $_value; |
|
| 348 | - $_order = $order; |
|
| 349 | - } else { |
|
| 350 | - // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
| 351 | - $_orderby = $_key; |
|
| 352 | - $_order = $_value; |
|
| 353 | - } |
|
| 354 | - |
|
| 355 | - $parsed = $this->parse_orderby( $_orderby, $table ); |
|
| 356 | - |
|
| 357 | - if ( $parsed ) { |
|
| 358 | - $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
| 359 | - } |
|
| 19 | + /** |
|
| 20 | + * Query vars, after parsing |
|
| 21 | + * |
|
| 22 | + * @since 1.0.19 |
|
| 23 | + * @var array |
|
| 24 | + */ |
|
| 25 | + public $query_vars = array(); |
|
| 26 | + |
|
| 27 | + /** |
|
| 28 | + * List of found subscriptions. |
|
| 29 | + * |
|
| 30 | + * @since 1.0.19 |
|
| 31 | + * @var array |
|
| 32 | + */ |
|
| 33 | + private $results; |
|
| 34 | + |
|
| 35 | + /** |
|
| 36 | + * Total number of found subscriptions for the current query |
|
| 37 | + * |
|
| 38 | + * @since 1.0.19 |
|
| 39 | + * @var int |
|
| 40 | + */ |
|
| 41 | + private $total_subscriptions = 0; |
|
| 42 | + |
|
| 43 | + /** |
|
| 44 | + * The SQL query used to fetch matching subscriptions. |
|
| 45 | + * |
|
| 46 | + * @since 1.0.19 |
|
| 47 | + * @var string |
|
| 48 | + */ |
|
| 49 | + public $request; |
|
| 50 | + |
|
| 51 | + // SQL clauses |
|
| 52 | + |
|
| 53 | + /** |
|
| 54 | + * Contains the 'FIELDS' sql clause |
|
| 55 | + * |
|
| 56 | + * @since 1.0.19 |
|
| 57 | + * @var string |
|
| 58 | + */ |
|
| 59 | + public $query_fields; |
|
| 60 | + |
|
| 61 | + /** |
|
| 62 | + * Contains the 'FROM' sql clause |
|
| 63 | + * |
|
| 64 | + * @since 1.0.19 |
|
| 65 | + * @var string |
|
| 66 | + */ |
|
| 67 | + public $query_from; |
|
| 68 | + |
|
| 69 | + /** |
|
| 70 | + * Contains the 'WHERE' sql clause |
|
| 71 | + * |
|
| 72 | + * @since 1.0.19 |
|
| 73 | + * @var string |
|
| 74 | + */ |
|
| 75 | + public $query_where; |
|
| 76 | + |
|
| 77 | + /** |
|
| 78 | + * Contains the 'ORDER BY' sql clause |
|
| 79 | + * |
|
| 80 | + * @since 1.0.19 |
|
| 81 | + * @var string |
|
| 82 | + */ |
|
| 83 | + public $query_orderby; |
|
| 84 | + |
|
| 85 | + /** |
|
| 86 | + * Contains the 'LIMIT' sql clause |
|
| 87 | + * |
|
| 88 | + * @since 1.0.19 |
|
| 89 | + * @var string |
|
| 90 | + */ |
|
| 91 | + public $query_limit; |
|
| 92 | + |
|
| 93 | + /** |
|
| 94 | + * Class constructor. |
|
| 95 | + * |
|
| 96 | + * @since 1.0.19 |
|
| 97 | + * |
|
| 98 | + * @param null|string|array $query Optional. The query variables. |
|
| 99 | + */ |
|
| 100 | + public function __construct( $query = null ) { |
|
| 101 | + if ( ! is_null( $query ) ) { |
|
| 102 | + $this->prepare_query( $query ); |
|
| 103 | + $this->query(); |
|
| 104 | + } |
|
| 105 | + } |
|
| 106 | + |
|
| 107 | + /** |
|
| 108 | + * Fills in missing query variables with default values. |
|
| 109 | + * |
|
| 110 | + * @since 1.0.19 |
|
| 111 | + * |
|
| 112 | + * @param string|array $args Query vars, as passed to `GetPaid_Subscriptions_Query`. |
|
| 113 | + * @return array Complete query variables with undefined ones filled in with defaults. |
|
| 114 | + */ |
|
| 115 | + public static function fill_query_vars( $args ) { |
|
| 116 | + $defaults = array( |
|
| 117 | + 'status' => 'all', |
|
| 118 | + 'customer_in' => array(), |
|
| 119 | + 'customer_not_in' => array(), |
|
| 120 | + 'product_in' => array(), |
|
| 121 | + 'product_not_in' => array(), |
|
| 122 | + 'include' => array(), |
|
| 123 | + 'exclude' => array(), |
|
| 124 | + 'orderby' => 'id', |
|
| 125 | + 'order' => 'DESC', |
|
| 126 | + 'offset' => '', |
|
| 127 | + 'number' => 10, |
|
| 128 | + 'paged' => 1, |
|
| 129 | + 'count_total' => true, |
|
| 130 | + 'fields' => 'all', |
|
| 131 | + ); |
|
| 132 | + |
|
| 133 | + return wp_parse_args( $args, $defaults ); |
|
| 134 | + } |
|
| 135 | + |
|
| 136 | + /** |
|
| 137 | + * Prepare the query variables. |
|
| 138 | + * |
|
| 139 | + * @since 1.0.19 |
|
| 140 | + * |
|
| 141 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
| 142 | + * |
|
| 143 | + * @param string|array $query { |
|
| 144 | + * Optional. Array or string of Query parameters. |
|
| 145 | + * |
|
| 146 | + * @type string|array $status The subscription status to filter by. Can either be a single status or an array of statuses. |
|
| 147 | + * Default is all. |
|
| 148 | + * @type int[] $customer_in An array of customer ids to filter by. |
|
| 149 | + * @type int[] $customer_not_in An array of customer ids whose subscriptions should be excluded. |
|
| 150 | + * @type int[] $invoice_in An array of invoice ids to filter by. |
|
| 151 | + * @type int[] $invoice_not_in An array of invoice ids whose subscriptions should be excluded. |
|
| 152 | + * @type int[] $product_in An array of product ids to filter by. |
|
| 153 | + * @type int[] $product_not_in An array of product ids whose subscriptions should be excluded. |
|
| 154 | + * @type array $date_created_query A WP_Date_Query compatible array use to filter subscriptions by their date of creation. |
|
| 155 | + * @type array $date_expires_query A WP_Date_Query compatible array use to filter subscriptions by their expiration date. |
|
| 156 | + * @type array $include An array of subscription IDs to include. Default empty array. |
|
| 157 | + * @type array $exclude An array of subscription IDs to exclude. Default empty array. |
|
| 158 | + * @type string|array $orderby Field(s) to sort the retrieved subscription by. May be a single value, |
|
| 159 | + * an array of values, or a multi-dimensional array with fields as |
|
| 160 | + * keys and orders ('ASC' or 'DESC') as values. Accepted values are |
|
| 161 | + * 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
| 162 | + * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
| 163 | + * 'transaction_id', 'product_id', 'trial_period', 'include', 'status', 'profile_id'. Default array( 'id' ). |
|
| 164 | + * @type string $order Designates ascending or descending order of subscriptions. Order values |
|
| 165 | + * passed as part of an `$orderby` array take precedence over this |
|
| 166 | + * parameter. Accepts 'ASC', 'DESC'. Default 'DESC'. |
|
| 167 | + * @type int $offset Number of subscriptions to offset in retrieved results. Can be used in |
|
| 168 | + * conjunction with pagination. Default 0. |
|
| 169 | + * @type int $number Number of subscriptions to limit the query for. Can be used in |
|
| 170 | + * conjunction with pagination. Value -1 (all) is supported, but |
|
| 171 | + * should be used with caution on larger sites. |
|
| 172 | + * Default 10. |
|
| 173 | + * @type int $paged When used with number, defines the page of results to return. |
|
| 174 | + * Default 1. |
|
| 175 | + * @type bool $count_total Whether to count the total number of subscriptions found. If pagination |
|
| 176 | + * is not needed, setting this to false can improve performance. |
|
| 177 | + * Default true. |
|
| 178 | + * @type string|array $fields Which fields to return. Single or all fields (string), or array |
|
| 179 | + * of fields. Accepts 'id', 'customer_id', 'frequency', 'period', 'initial_amount, |
|
| 180 | + * 'recurring_amount', 'bill_times', 'parent_payment_id', 'created', 'expiration' |
|
| 181 | + * 'transaction_id', 'product_id', 'trial_period', 'status', 'profile_id'. |
|
| 182 | + * Use 'all' for all fields. Default 'all'. |
|
| 183 | + * } |
|
| 184 | + */ |
|
| 185 | + public function prepare_query( $query = array() ) { |
|
| 186 | + global $wpdb; |
|
| 187 | + |
|
| 188 | + if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
| 189 | + $this->query_limit = null; |
|
| 190 | + $this->query_vars = $this->fill_query_vars( $query ); |
|
| 191 | + } |
|
| 192 | + |
|
| 193 | + if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
| 194 | + $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
| 195 | + } |
|
| 196 | + |
|
| 197 | + do_action( 'getpaid_pre_get_subscriptions', array( &$this ) ); |
|
| 198 | + |
|
| 199 | + // Ensure that query vars are filled after 'getpaid_pre_get_subscriptions'. |
|
| 200 | + $qv =& $this->query_vars; |
|
| 201 | + $qv = $this->fill_query_vars( $qv ); |
|
| 202 | + $table = $wpdb->prefix . 'wpinv_subscriptions'; |
|
| 203 | + $this->query_from = "FROM $table"; |
|
| 204 | + |
|
| 205 | + // Prepare query fields. |
|
| 206 | + $this->prepare_query_fields( $qv, $table ); |
|
| 207 | + |
|
| 208 | + // Prepare query where. |
|
| 209 | + $this->prepare_query_where( $qv, $table ); |
|
| 210 | + |
|
| 211 | + // Prepare query order. |
|
| 212 | + $this->prepare_query_order( $qv, $table ); |
|
| 213 | + |
|
| 214 | + // limit |
|
| 215 | + if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
| 216 | + if ( $qv['offset'] ) { |
|
| 217 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
| 218 | + } else { |
|
| 219 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
| 220 | + } |
|
| 221 | + } |
|
| 222 | + |
|
| 223 | + do_action_ref_array( 'getpaid_after_subscriptions_query', array( &$this ) ); |
|
| 224 | + } |
|
| 225 | + |
|
| 226 | + /** |
|
| 227 | + * Prepares the query fields. |
|
| 228 | + * |
|
| 229 | + * @since 1.0.19 |
|
| 230 | + * |
|
| 231 | + * @param array $qv Query vars. |
|
| 232 | + * @param string $table Table name. |
|
| 233 | + */ |
|
| 234 | + protected function prepare_query_fields( &$qv, $table ) { |
|
| 235 | + |
|
| 236 | + if ( is_array( $qv['fields'] ) ) { |
|
| 237 | + $qv['fields'] = array_unique( $qv['fields'] ); |
|
| 238 | + |
|
| 239 | + $query_fields = array(); |
|
| 240 | + foreach ( $qv['fields'] as $field ) { |
|
| 241 | + $field = sanitize_key( $field ); |
|
| 242 | + $query_fields[] = "$table.`$field`"; |
|
| 243 | + } |
|
| 244 | + $this->query_fields = implode( ',', $query_fields ); |
|
| 245 | + } else { |
|
| 246 | + $this->query_fields = "$table.*"; |
|
| 247 | + } |
|
| 248 | + |
|
| 249 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 250 | + $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
| 251 | + } |
|
| 252 | + |
|
| 253 | + } |
|
| 254 | + |
|
| 255 | + /** |
|
| 256 | + * Prepares the query where. |
|
| 257 | + * |
|
| 258 | + * @since 1.0.19 |
|
| 259 | + * |
|
| 260 | + * @param array $qv Query vars. |
|
| 261 | + * @param string $table Table name. |
|
| 262 | + */ |
|
| 263 | + protected function prepare_query_where( &$qv, $table ) { |
|
| 264 | + global $wpdb; |
|
| 265 | + $this->query_where = 'WHERE 1=1'; |
|
| 266 | + |
|
| 267 | + // Status. |
|
| 268 | + if ( 'all' !== $qv['status'] ) { |
|
| 269 | + $statuses = wpinv_clean( wpinv_parse_list( $qv['status'] ) ); |
|
| 270 | + $prepared_statuses = join( ',', array_fill( 0, count( $statuses ), '%s' ) ); |
|
| 271 | + $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $prepared_statuses )", $statuses ); |
|
| 272 | + } |
|
| 273 | + |
|
| 274 | + if ( ! empty( $qv['customer_in'] ) ) { |
|
| 275 | + $customer_in = implode( ',', wp_parse_id_list( $qv['customer_in'] ) ); |
|
| 276 | + $this->query_where .= " AND $table.`customer_id` IN ($customer_in)"; |
|
| 277 | + } elseif ( ! empty( $qv['customer_not_in'] ) ) { |
|
| 278 | + $customer_not_in = implode( ',', wp_parse_id_list( $qv['customer_not_in'] ) ); |
|
| 279 | + $this->query_where .= " AND $table.`customer_id` NOT IN ($customer_not_in)"; |
|
| 280 | + } |
|
| 281 | + |
|
| 282 | + if ( ! empty( $qv['product_in'] ) ) { |
|
| 283 | + $product_in = implode( ',', wp_parse_id_list( $qv['product_in'] ) ); |
|
| 284 | + $this->query_where .= " AND $table.`product_id` IN ($product_in)"; |
|
| 285 | + } elseif ( ! empty( $qv['product_not_in'] ) ) { |
|
| 286 | + $product_not_in = implode( ',', wp_parse_id_list( $qv['product_not_in'] ) ); |
|
| 287 | + $this->query_where .= " AND $table.`product_id` NOT IN ($product_not_in)"; |
|
| 288 | + } |
|
| 289 | + |
|
| 290 | + if ( ! empty( $qv['invoice_in'] ) ) { |
|
| 291 | + $invoice_in = implode( ',', wp_parse_id_list( $qv['invoice_in'] ) ); |
|
| 292 | + $this->query_where .= " AND $table.`parent_payment_id` IN ($invoice_in)"; |
|
| 293 | + } elseif ( ! empty( $qv['invoice_not_in'] ) ) { |
|
| 294 | + $invoice_not_in = implode( ',', wp_parse_id_list( $qv['invoice_not_in'] ) ); |
|
| 295 | + $this->query_where .= " AND $table.`parent_payment_id` NOT IN ($invoice_not_in)"; |
|
| 296 | + } |
|
| 297 | + |
|
| 298 | + if ( ! empty( $qv['include'] ) ) { |
|
| 299 | + $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
| 300 | + $this->query_where .= " AND $table.`id` IN ($include)"; |
|
| 301 | + } elseif ( ! empty( $qv['exclude'] ) ) { |
|
| 302 | + $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
| 303 | + $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
| 304 | + } |
|
| 305 | + |
|
| 306 | + // Date queries are allowed for the subscription creation date. |
|
| 307 | + if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
| 308 | + $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.created" ); |
|
| 309 | + $this->query_where .= $date_created_query->get_sql(); |
|
| 310 | + } |
|
| 311 | + |
|
| 312 | + // Date queries are also allowed for the subscription expiration date. |
|
| 313 | + if ( ! empty( $qv['date_expires_query'] ) && is_array( $qv['date_expires_query'] ) ) { |
|
| 314 | + $date_expires_query = new WP_Date_Query( $qv['date_expires_query'], "$table.expiration" ); |
|
| 315 | + $this->query_where .= $date_expires_query->get_sql(); |
|
| 316 | + } |
|
| 317 | + |
|
| 318 | + } |
|
| 319 | + |
|
| 320 | + /** |
|
| 321 | + * Prepares the query order. |
|
| 322 | + * |
|
| 323 | + * @since 1.0.19 |
|
| 324 | + * |
|
| 325 | + * @param array $qv Query vars. |
|
| 326 | + * @param string $table Table name. |
|
| 327 | + */ |
|
| 328 | + protected function prepare_query_order( &$qv, $table ) { |
|
| 329 | + |
|
| 330 | + // sorting. |
|
| 331 | + $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
| 332 | + $order = $this->parse_order( $qv['order'] ); |
|
| 333 | + |
|
| 334 | + // Default order is by 'id' (latest subscriptions). |
|
| 335 | + if ( empty( $qv['orderby'] ) ) { |
|
| 336 | + $qv['orderby'] = array( 'id' ); |
|
| 337 | + } |
|
| 338 | + |
|
| 339 | + // 'orderby' values may be an array, comma- or space-separated list. |
|
| 340 | + $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
| 341 | + |
|
| 342 | + $orderby_array = array(); |
|
| 343 | + foreach ( $ordersby as $_key => $_value ) { |
|
| 344 | + |
|
| 345 | + if ( is_int( $_key ) ) { |
|
| 346 | + // Integer key means this is a flat array of 'orderby' fields. |
|
| 347 | + $_orderby = $_value; |
|
| 348 | + $_order = $order; |
|
| 349 | + } else { |
|
| 350 | + // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
| 351 | + $_orderby = $_key; |
|
| 352 | + $_order = $_value; |
|
| 353 | + } |
|
| 354 | + |
|
| 355 | + $parsed = $this->parse_orderby( $_orderby, $table ); |
|
| 356 | + |
|
| 357 | + if ( $parsed ) { |
|
| 358 | + $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
| 359 | + } |
|
| 360 | 360 | } |
| 361 | 361 | |
| 362 | - // If no valid clauses were found, order by id. |
|
| 363 | - if ( empty( $orderby_array ) ) { |
|
| 364 | - $orderby_array[] = "id $order"; |
|
| 365 | - } |
|
| 366 | - |
|
| 367 | - $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
| 368 | - |
|
| 369 | - } |
|
| 370 | - |
|
| 371 | - /** |
|
| 372 | - * Execute the query, with the current variables. |
|
| 373 | - * |
|
| 374 | - * @since 1.0.19 |
|
| 375 | - * |
|
| 376 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
| 377 | - */ |
|
| 378 | - public function query() { |
|
| 379 | - global $wpdb; |
|
| 380 | - |
|
| 381 | - $qv =& $this->query_vars; |
|
| 382 | - |
|
| 383 | - // Return a non-null value to bypass the default GetPaid subscriptions query and remember to set the |
|
| 384 | - // total_subscriptions property. |
|
| 385 | - $this->results = apply_filters_ref_array( 'getpaid_subscriptions_pre_query', array( null, &$this ) ); |
|
| 386 | - |
|
| 387 | - if ( null === $this->results ) { |
|
| 388 | - $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
| 389 | - |
|
| 390 | - if ( ( is_array( $qv['fields'] ) && 1 != count( $qv['fields'] ) ) || 'all' == $qv['fields'] ) { |
|
| 391 | - $this->results = $wpdb->get_results( $this->request ); |
|
| 392 | - } else { |
|
| 393 | - $this->results = $wpdb->get_col( $this->request ); |
|
| 394 | - } |
|
| 395 | - |
|
| 396 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 397 | - $found_subscriptions_query = apply_filters( 'getpaid_found_subscriptions_query', 'SELECT FOUND_ROWS()', $this ); |
|
| 398 | - $this->total_subscriptions = (int) $wpdb->get_var( $found_subscriptions_query ); |
|
| 399 | - } |
|
| 400 | - } |
|
| 401 | - |
|
| 402 | - if ( 'all' == $qv['fields'] ) { |
|
| 403 | - foreach ( $this->results as $key => $subscription ) { |
|
| 404 | - $this->set_cache( $subscription->id, $subscription, 'getpaid_subscriptions' ); |
|
| 405 | - $this->set_cache( $subscription->profile_id, $subscription->id, 'getpaid_subscription_profile_ids_to_subscription_ids' ); |
|
| 406 | - $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
| 407 | - $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
| 408 | - $this->results[ $key ] = new WPInv_Subscription( $subscription ); |
|
| 409 | - } |
|
| 410 | - } |
|
| 411 | - |
|
| 412 | - } |
|
| 413 | - |
|
| 414 | - /** |
|
| 415 | - * Set cache |
|
| 416 | - * |
|
| 417 | - * @param string $id |
|
| 418 | - * @param mixed $data |
|
| 419 | - * @param string $group |
|
| 420 | - * @param integer $expire |
|
| 421 | - * @return boolean |
|
| 422 | - */ |
|
| 423 | - public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
| 424 | - |
|
| 425 | - if ( empty( $key ) ) { |
|
| 426 | - return false; |
|
| 427 | - } |
|
| 428 | - |
|
| 429 | - wp_cache_set( $key, $data, $group, $expire ); |
|
| 430 | - } |
|
| 431 | - |
|
| 432 | - /** |
|
| 433 | - * Retrieve query variable. |
|
| 434 | - * |
|
| 435 | - * @since 1.0.19 |
|
| 436 | - * |
|
| 437 | - * @param string $query_var Query variable key. |
|
| 438 | - * @return mixed |
|
| 439 | - */ |
|
| 440 | - public function get( $query_var ) { |
|
| 441 | - if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
| 442 | - return $this->query_vars[ $query_var ]; |
|
| 443 | - } |
|
| 444 | - |
|
| 445 | - return null; |
|
| 446 | - } |
|
| 447 | - |
|
| 448 | - /** |
|
| 449 | - * Set query variable. |
|
| 450 | - * |
|
| 451 | - * @since 1.0.19 |
|
| 452 | - * |
|
| 453 | - * @param string $query_var Query variable key. |
|
| 454 | - * @param mixed $value Query variable value. |
|
| 455 | - */ |
|
| 456 | - public function set( $query_var, $value ) { |
|
| 457 | - $this->query_vars[ $query_var ] = $value; |
|
| 458 | - } |
|
| 459 | - |
|
| 460 | - /** |
|
| 461 | - * Return the list of subscriptions. |
|
| 462 | - * |
|
| 463 | - * @since 1.0.19 |
|
| 464 | - * |
|
| 465 | - * @return WPInv_Subscription[]|array Found subscriptions. |
|
| 466 | - */ |
|
| 467 | - public function get_results() { |
|
| 468 | - return $this->results; |
|
| 469 | - } |
|
| 470 | - |
|
| 471 | - /** |
|
| 472 | - * Return the total number of subscriptions for the current query. |
|
| 473 | - * |
|
| 474 | - * @since 1.0.19 |
|
| 475 | - * |
|
| 476 | - * @return int Number of total subscriptions. |
|
| 477 | - */ |
|
| 478 | - public function get_total() { |
|
| 479 | - return $this->total_subscriptions; |
|
| 480 | - } |
|
| 481 | - |
|
| 482 | - /** |
|
| 483 | - * Parse and sanitize 'orderby' keys passed to the subscriptions query. |
|
| 484 | - * |
|
| 485 | - * @since 1.0.19 |
|
| 486 | - * |
|
| 487 | - * @param string $orderby Alias for the field to order by. |
|
| 488 | - * @param string $table The current table. |
|
| 489 | - * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
| 490 | - */ |
|
| 491 | - protected function parse_orderby( $orderby, $table ) { |
|
| 492 | - |
|
| 493 | - $_orderby = ''; |
|
| 494 | - if ( in_array( $orderby, array( 'customer_id', 'frequency', 'period', 'initial_amount', 'recurring_amount', 'bill_times', 'transaction_id', 'parent_payment_id', 'product_id', 'created', 'expiration', 'trial_period', 'status', 'profile_id' ) ) ) { |
|
| 495 | - $_orderby = "$table.`$orderby`"; |
|
| 496 | - } elseif ( 'id' === strtolower( $orderby ) ) { |
|
| 497 | - $_orderby = "$table.id"; |
|
| 498 | - } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
| 499 | - $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
| 500 | - $include_sql = implode( ',', $include ); |
|
| 501 | - $_orderby = "FIELD( $table.id, $include_sql )"; |
|
| 502 | - } |
|
| 503 | - |
|
| 504 | - return $_orderby; |
|
| 505 | - } |
|
| 506 | - |
|
| 507 | - /** |
|
| 508 | - * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
| 509 | - * |
|
| 510 | - * @since 1.0.19 |
|
| 511 | - * |
|
| 512 | - * @param string $order The 'order' query variable. |
|
| 513 | - * @return string The sanitized 'order' query variable. |
|
| 514 | - */ |
|
| 515 | - protected function parse_order( $order ) { |
|
| 516 | - if ( ! is_string( $order ) || empty( $order ) ) { |
|
| 517 | - return 'DESC'; |
|
| 518 | - } |
|
| 519 | - |
|
| 520 | - if ( 'ASC' === strtoupper( $order ) ) { |
|
| 521 | - return 'ASC'; |
|
| 522 | - } else { |
|
| 523 | - return 'DESC'; |
|
| 524 | - } |
|
| 525 | - } |
|
| 362 | + // If no valid clauses were found, order by id. |
|
| 363 | + if ( empty( $orderby_array ) ) { |
|
| 364 | + $orderby_array[] = "id $order"; |
|
| 365 | + } |
|
| 366 | + |
|
| 367 | + $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
| 368 | + |
|
| 369 | + } |
|
| 370 | + |
|
| 371 | + /** |
|
| 372 | + * Execute the query, with the current variables. |
|
| 373 | + * |
|
| 374 | + * @since 1.0.19 |
|
| 375 | + * |
|
| 376 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
| 377 | + */ |
|
| 378 | + public function query() { |
|
| 379 | + global $wpdb; |
|
| 380 | + |
|
| 381 | + $qv =& $this->query_vars; |
|
| 382 | + |
|
| 383 | + // Return a non-null value to bypass the default GetPaid subscriptions query and remember to set the |
|
| 384 | + // total_subscriptions property. |
|
| 385 | + $this->results = apply_filters_ref_array( 'getpaid_subscriptions_pre_query', array( null, &$this ) ); |
|
| 386 | + |
|
| 387 | + if ( null === $this->results ) { |
|
| 388 | + $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
| 389 | + |
|
| 390 | + if ( ( is_array( $qv['fields'] ) && 1 != count( $qv['fields'] ) ) || 'all' == $qv['fields'] ) { |
|
| 391 | + $this->results = $wpdb->get_results( $this->request ); |
|
| 392 | + } else { |
|
| 393 | + $this->results = $wpdb->get_col( $this->request ); |
|
| 394 | + } |
|
| 395 | + |
|
| 396 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 397 | + $found_subscriptions_query = apply_filters( 'getpaid_found_subscriptions_query', 'SELECT FOUND_ROWS()', $this ); |
|
| 398 | + $this->total_subscriptions = (int) $wpdb->get_var( $found_subscriptions_query ); |
|
| 399 | + } |
|
| 400 | + } |
|
| 401 | + |
|
| 402 | + if ( 'all' == $qv['fields'] ) { |
|
| 403 | + foreach ( $this->results as $key => $subscription ) { |
|
| 404 | + $this->set_cache( $subscription->id, $subscription, 'getpaid_subscriptions' ); |
|
| 405 | + $this->set_cache( $subscription->profile_id, $subscription->id, 'getpaid_subscription_profile_ids_to_subscription_ids' ); |
|
| 406 | + $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
| 407 | + $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
| 408 | + $this->results[ $key ] = new WPInv_Subscription( $subscription ); |
|
| 409 | + } |
|
| 410 | + } |
|
| 411 | + |
|
| 412 | + } |
|
| 413 | + |
|
| 414 | + /** |
|
| 415 | + * Set cache |
|
| 416 | + * |
|
| 417 | + * @param string $id |
|
| 418 | + * @param mixed $data |
|
| 419 | + * @param string $group |
|
| 420 | + * @param integer $expire |
|
| 421 | + * @return boolean |
|
| 422 | + */ |
|
| 423 | + public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
| 424 | + |
|
| 425 | + if ( empty( $key ) ) { |
|
| 426 | + return false; |
|
| 427 | + } |
|
| 428 | + |
|
| 429 | + wp_cache_set( $key, $data, $group, $expire ); |
|
| 430 | + } |
|
| 431 | + |
|
| 432 | + /** |
|
| 433 | + * Retrieve query variable. |
|
| 434 | + * |
|
| 435 | + * @since 1.0.19 |
|
| 436 | + * |
|
| 437 | + * @param string $query_var Query variable key. |
|
| 438 | + * @return mixed |
|
| 439 | + */ |
|
| 440 | + public function get( $query_var ) { |
|
| 441 | + if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
| 442 | + return $this->query_vars[ $query_var ]; |
|
| 443 | + } |
|
| 444 | + |
|
| 445 | + return null; |
|
| 446 | + } |
|
| 447 | + |
|
| 448 | + /** |
|
| 449 | + * Set query variable. |
|
| 450 | + * |
|
| 451 | + * @since 1.0.19 |
|
| 452 | + * |
|
| 453 | + * @param string $query_var Query variable key. |
|
| 454 | + * @param mixed $value Query variable value. |
|
| 455 | + */ |
|
| 456 | + public function set( $query_var, $value ) { |
|
| 457 | + $this->query_vars[ $query_var ] = $value; |
|
| 458 | + } |
|
| 459 | + |
|
| 460 | + /** |
|
| 461 | + * Return the list of subscriptions. |
|
| 462 | + * |
|
| 463 | + * @since 1.0.19 |
|
| 464 | + * |
|
| 465 | + * @return WPInv_Subscription[]|array Found subscriptions. |
|
| 466 | + */ |
|
| 467 | + public function get_results() { |
|
| 468 | + return $this->results; |
|
| 469 | + } |
|
| 470 | + |
|
| 471 | + /** |
|
| 472 | + * Return the total number of subscriptions for the current query. |
|
| 473 | + * |
|
| 474 | + * @since 1.0.19 |
|
| 475 | + * |
|
| 476 | + * @return int Number of total subscriptions. |
|
| 477 | + */ |
|
| 478 | + public function get_total() { |
|
| 479 | + return $this->total_subscriptions; |
|
| 480 | + } |
|
| 481 | + |
|
| 482 | + /** |
|
| 483 | + * Parse and sanitize 'orderby' keys passed to the subscriptions query. |
|
| 484 | + * |
|
| 485 | + * @since 1.0.19 |
|
| 486 | + * |
|
| 487 | + * @param string $orderby Alias for the field to order by. |
|
| 488 | + * @param string $table The current table. |
|
| 489 | + * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
| 490 | + */ |
|
| 491 | + protected function parse_orderby( $orderby, $table ) { |
|
| 492 | + |
|
| 493 | + $_orderby = ''; |
|
| 494 | + if ( in_array( $orderby, array( 'customer_id', 'frequency', 'period', 'initial_amount', 'recurring_amount', 'bill_times', 'transaction_id', 'parent_payment_id', 'product_id', 'created', 'expiration', 'trial_period', 'status', 'profile_id' ) ) ) { |
|
| 495 | + $_orderby = "$table.`$orderby`"; |
|
| 496 | + } elseif ( 'id' === strtolower( $orderby ) ) { |
|
| 497 | + $_orderby = "$table.id"; |
|
| 498 | + } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
| 499 | + $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
| 500 | + $include_sql = implode( ',', $include ); |
|
| 501 | + $_orderby = "FIELD( $table.id, $include_sql )"; |
|
| 502 | + } |
|
| 503 | + |
|
| 504 | + return $_orderby; |
|
| 505 | + } |
|
| 506 | + |
|
| 507 | + /** |
|
| 508 | + * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
| 509 | + * |
|
| 510 | + * @since 1.0.19 |
|
| 511 | + * |
|
| 512 | + * @param string $order The 'order' query variable. |
|
| 513 | + * @return string The sanitized 'order' query variable. |
|
| 514 | + */ |
|
| 515 | + protected function parse_order( $order ) { |
|
| 516 | + if ( ! is_string( $order ) || empty( $order ) ) { |
|
| 517 | + return 'DESC'; |
|
| 518 | + } |
|
| 519 | + |
|
| 520 | + if ( 'ASC' === strtoupper( $order ) ) { |
|
| 521 | + return 'ASC'; |
|
| 522 | + } else { |
|
| 523 | + return 'DESC'; |
|
| 524 | + } |
|
| 525 | + } |
|
| 526 | 526 | |
| 527 | 527 | } |
@@ -97,9 +97,9 @@ discard block |
||
| 97 | 97 | * |
| 98 | 98 | * @param null|string|array $query Optional. The query variables. |
| 99 | 99 | */ |
| 100 | - public function __construct( $query = null ) { |
|
| 101 | - if ( ! is_null( $query ) ) { |
|
| 102 | - $this->prepare_query( $query ); |
|
| 100 | + public function __construct($query = null) { |
|
| 101 | + if (!is_null($query)) { |
|
| 102 | + $this->prepare_query($query); |
|
| 103 | 103 | $this->query(); |
| 104 | 104 | } |
| 105 | 105 | } |
@@ -112,7 +112,7 @@ discard block |
||
| 112 | 112 | * @param string|array $args Query vars, as passed to `GetPaid_Subscriptions_Query`. |
| 113 | 113 | * @return array Complete query variables with undefined ones filled in with defaults. |
| 114 | 114 | */ |
| 115 | - public static function fill_query_vars( $args ) { |
|
| 115 | + public static function fill_query_vars($args) { |
|
| 116 | 116 | $defaults = array( |
| 117 | 117 | 'status' => 'all', |
| 118 | 118 | 'customer_in' => array(), |
@@ -130,7 +130,7 @@ discard block |
||
| 130 | 130 | 'fields' => 'all', |
| 131 | 131 | ); |
| 132 | 132 | |
| 133 | - return wp_parse_args( $args, $defaults ); |
|
| 133 | + return wp_parse_args($args, $defaults); |
|
| 134 | 134 | } |
| 135 | 135 | |
| 136 | 136 | /** |
@@ -182,45 +182,45 @@ discard block |
||
| 182 | 182 | * Use 'all' for all fields. Default 'all'. |
| 183 | 183 | * } |
| 184 | 184 | */ |
| 185 | - public function prepare_query( $query = array() ) { |
|
| 185 | + public function prepare_query($query = array()) { |
|
| 186 | 186 | global $wpdb; |
| 187 | 187 | |
| 188 | - if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
| 188 | + if (empty($this->query_vars) || !empty($query)) { |
|
| 189 | 189 | $this->query_limit = null; |
| 190 | - $this->query_vars = $this->fill_query_vars( $query ); |
|
| 190 | + $this->query_vars = $this->fill_query_vars($query); |
|
| 191 | 191 | } |
| 192 | 192 | |
| 193 | - if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
| 194 | - $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
| 193 | + if (!empty($this->query_vars['fields']) && 'all' !== $this->query_vars['fields']) { |
|
| 194 | + $this->query_vars['fields'] = wpinv_parse_list($this->query_vars['fields']); |
|
| 195 | 195 | } |
| 196 | 196 | |
| 197 | - do_action( 'getpaid_pre_get_subscriptions', array( &$this ) ); |
|
| 197 | + do_action('getpaid_pre_get_subscriptions', array(&$this)); |
|
| 198 | 198 | |
| 199 | 199 | // Ensure that query vars are filled after 'getpaid_pre_get_subscriptions'. |
| 200 | - $qv =& $this->query_vars; |
|
| 201 | - $qv = $this->fill_query_vars( $qv ); |
|
| 200 | + $qv = & $this->query_vars; |
|
| 201 | + $qv = $this->fill_query_vars($qv); |
|
| 202 | 202 | $table = $wpdb->prefix . 'wpinv_subscriptions'; |
| 203 | 203 | $this->query_from = "FROM $table"; |
| 204 | 204 | |
| 205 | 205 | // Prepare query fields. |
| 206 | - $this->prepare_query_fields( $qv, $table ); |
|
| 206 | + $this->prepare_query_fields($qv, $table); |
|
| 207 | 207 | |
| 208 | 208 | // Prepare query where. |
| 209 | - $this->prepare_query_where( $qv, $table ); |
|
| 209 | + $this->prepare_query_where($qv, $table); |
|
| 210 | 210 | |
| 211 | 211 | // Prepare query order. |
| 212 | - $this->prepare_query_order( $qv, $table ); |
|
| 212 | + $this->prepare_query_order($qv, $table); |
|
| 213 | 213 | |
| 214 | 214 | // limit |
| 215 | - if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
| 216 | - if ( $qv['offset'] ) { |
|
| 217 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
| 215 | + if (isset($qv['number']) && $qv['number'] > 0) { |
|
| 216 | + if ($qv['offset']) { |
|
| 217 | + $this->query_limit = $wpdb->prepare('LIMIT %d, %d', $qv['offset'], $qv['number']); |
|
| 218 | 218 | } else { |
| 219 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
| 219 | + $this->query_limit = $wpdb->prepare('LIMIT %d, %d', $qv['number'] * ($qv['paged'] - 1), $qv['number']); |
|
| 220 | 220 | } |
| 221 | 221 | } |
| 222 | 222 | |
| 223 | - do_action_ref_array( 'getpaid_after_subscriptions_query', array( &$this ) ); |
|
| 223 | + do_action_ref_array('getpaid_after_subscriptions_query', array(&$this)); |
|
| 224 | 224 | } |
| 225 | 225 | |
| 226 | 226 | /** |
@@ -231,22 +231,22 @@ discard block |
||
| 231 | 231 | * @param array $qv Query vars. |
| 232 | 232 | * @param string $table Table name. |
| 233 | 233 | */ |
| 234 | - protected function prepare_query_fields( &$qv, $table ) { |
|
| 234 | + protected function prepare_query_fields(&$qv, $table) { |
|
| 235 | 235 | |
| 236 | - if ( is_array( $qv['fields'] ) ) { |
|
| 237 | - $qv['fields'] = array_unique( $qv['fields'] ); |
|
| 236 | + if (is_array($qv['fields'])) { |
|
| 237 | + $qv['fields'] = array_unique($qv['fields']); |
|
| 238 | 238 | |
| 239 | 239 | $query_fields = array(); |
| 240 | - foreach ( $qv['fields'] as $field ) { |
|
| 241 | - $field = sanitize_key( $field ); |
|
| 240 | + foreach ($qv['fields'] as $field) { |
|
| 241 | + $field = sanitize_key($field); |
|
| 242 | 242 | $query_fields[] = "$table.`$field`"; |
| 243 | 243 | } |
| 244 | - $this->query_fields = implode( ',', $query_fields ); |
|
| 244 | + $this->query_fields = implode(',', $query_fields); |
|
| 245 | 245 | } else { |
| 246 | 246 | $this->query_fields = "$table.*"; |
| 247 | 247 | } |
| 248 | 248 | |
| 249 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 249 | + if (isset($qv['count_total']) && $qv['count_total']) { |
|
| 250 | 250 | $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
| 251 | 251 | } |
| 252 | 252 | |
@@ -260,58 +260,58 @@ discard block |
||
| 260 | 260 | * @param array $qv Query vars. |
| 261 | 261 | * @param string $table Table name. |
| 262 | 262 | */ |
| 263 | - protected function prepare_query_where( &$qv, $table ) { |
|
| 263 | + protected function prepare_query_where(&$qv, $table) { |
|
| 264 | 264 | global $wpdb; |
| 265 | 265 | $this->query_where = 'WHERE 1=1'; |
| 266 | 266 | |
| 267 | 267 | // Status. |
| 268 | - if ( 'all' !== $qv['status'] ) { |
|
| 269 | - $statuses = wpinv_clean( wpinv_parse_list( $qv['status'] ) ); |
|
| 270 | - $prepared_statuses = join( ',', array_fill( 0, count( $statuses ), '%s' ) ); |
|
| 271 | - $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $prepared_statuses )", $statuses ); |
|
| 268 | + if ('all' !== $qv['status']) { |
|
| 269 | + $statuses = wpinv_clean(wpinv_parse_list($qv['status'])); |
|
| 270 | + $prepared_statuses = join(',', array_fill(0, count($statuses), '%s')); |
|
| 271 | + $this->query_where .= $wpdb->prepare(" AND $table.`status` IN ( $prepared_statuses )", $statuses); |
|
| 272 | 272 | } |
| 273 | 273 | |
| 274 | - if ( ! empty( $qv['customer_in'] ) ) { |
|
| 275 | - $customer_in = implode( ',', wp_parse_id_list( $qv['customer_in'] ) ); |
|
| 274 | + if (!empty($qv['customer_in'])) { |
|
| 275 | + $customer_in = implode(',', wp_parse_id_list($qv['customer_in'])); |
|
| 276 | 276 | $this->query_where .= " AND $table.`customer_id` IN ($customer_in)"; |
| 277 | - } elseif ( ! empty( $qv['customer_not_in'] ) ) { |
|
| 278 | - $customer_not_in = implode( ',', wp_parse_id_list( $qv['customer_not_in'] ) ); |
|
| 277 | + } elseif (!empty($qv['customer_not_in'])) { |
|
| 278 | + $customer_not_in = implode(',', wp_parse_id_list($qv['customer_not_in'])); |
|
| 279 | 279 | $this->query_where .= " AND $table.`customer_id` NOT IN ($customer_not_in)"; |
| 280 | 280 | } |
| 281 | 281 | |
| 282 | - if ( ! empty( $qv['product_in'] ) ) { |
|
| 283 | - $product_in = implode( ',', wp_parse_id_list( $qv['product_in'] ) ); |
|
| 282 | + if (!empty($qv['product_in'])) { |
|
| 283 | + $product_in = implode(',', wp_parse_id_list($qv['product_in'])); |
|
| 284 | 284 | $this->query_where .= " AND $table.`product_id` IN ($product_in)"; |
| 285 | - } elseif ( ! empty( $qv['product_not_in'] ) ) { |
|
| 286 | - $product_not_in = implode( ',', wp_parse_id_list( $qv['product_not_in'] ) ); |
|
| 285 | + } elseif (!empty($qv['product_not_in'])) { |
|
| 286 | + $product_not_in = implode(',', wp_parse_id_list($qv['product_not_in'])); |
|
| 287 | 287 | $this->query_where .= " AND $table.`product_id` NOT IN ($product_not_in)"; |
| 288 | 288 | } |
| 289 | 289 | |
| 290 | - if ( ! empty( $qv['invoice_in'] ) ) { |
|
| 291 | - $invoice_in = implode( ',', wp_parse_id_list( $qv['invoice_in'] ) ); |
|
| 290 | + if (!empty($qv['invoice_in'])) { |
|
| 291 | + $invoice_in = implode(',', wp_parse_id_list($qv['invoice_in'])); |
|
| 292 | 292 | $this->query_where .= " AND $table.`parent_payment_id` IN ($invoice_in)"; |
| 293 | - } elseif ( ! empty( $qv['invoice_not_in'] ) ) { |
|
| 294 | - $invoice_not_in = implode( ',', wp_parse_id_list( $qv['invoice_not_in'] ) ); |
|
| 293 | + } elseif (!empty($qv['invoice_not_in'])) { |
|
| 294 | + $invoice_not_in = implode(',', wp_parse_id_list($qv['invoice_not_in'])); |
|
| 295 | 295 | $this->query_where .= " AND $table.`parent_payment_id` NOT IN ($invoice_not_in)"; |
| 296 | 296 | } |
| 297 | 297 | |
| 298 | - if ( ! empty( $qv['include'] ) ) { |
|
| 299 | - $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
| 298 | + if (!empty($qv['include'])) { |
|
| 299 | + $include = implode(',', wp_parse_id_list($qv['include'])); |
|
| 300 | 300 | $this->query_where .= " AND $table.`id` IN ($include)"; |
| 301 | - } elseif ( ! empty( $qv['exclude'] ) ) { |
|
| 302 | - $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
| 301 | + } elseif (!empty($qv['exclude'])) { |
|
| 302 | + $exclude = implode(',', wp_parse_id_list($qv['exclude'])); |
|
| 303 | 303 | $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
| 304 | 304 | } |
| 305 | 305 | |
| 306 | 306 | // Date queries are allowed for the subscription creation date. |
| 307 | - if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
| 308 | - $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.created" ); |
|
| 307 | + if (!empty($qv['date_created_query']) && is_array($qv['date_created_query'])) { |
|
| 308 | + $date_created_query = new WP_Date_Query($qv['date_created_query'], "$table.created"); |
|
| 309 | 309 | $this->query_where .= $date_created_query->get_sql(); |
| 310 | 310 | } |
| 311 | 311 | |
| 312 | 312 | // Date queries are also allowed for the subscription expiration date. |
| 313 | - if ( ! empty( $qv['date_expires_query'] ) && is_array( $qv['date_expires_query'] ) ) { |
|
| 314 | - $date_expires_query = new WP_Date_Query( $qv['date_expires_query'], "$table.expiration" ); |
|
| 313 | + if (!empty($qv['date_expires_query']) && is_array($qv['date_expires_query'])) { |
|
| 314 | + $date_expires_query = new WP_Date_Query($qv['date_expires_query'], "$table.expiration"); |
|
| 315 | 315 | $this->query_where .= $date_expires_query->get_sql(); |
| 316 | 316 | } |
| 317 | 317 | |
@@ -325,24 +325,24 @@ discard block |
||
| 325 | 325 | * @param array $qv Query vars. |
| 326 | 326 | * @param string $table Table name. |
| 327 | 327 | */ |
| 328 | - protected function prepare_query_order( &$qv, $table ) { |
|
| 328 | + protected function prepare_query_order(&$qv, $table) { |
|
| 329 | 329 | |
| 330 | 330 | // sorting. |
| 331 | - $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
| 332 | - $order = $this->parse_order( $qv['order'] ); |
|
| 331 | + $qv['order'] = isset($qv['order']) ? strtoupper($qv['order']) : ''; |
|
| 332 | + $order = $this->parse_order($qv['order']); |
|
| 333 | 333 | |
| 334 | 334 | // Default order is by 'id' (latest subscriptions). |
| 335 | - if ( empty( $qv['orderby'] ) ) { |
|
| 336 | - $qv['orderby'] = array( 'id' ); |
|
| 335 | + if (empty($qv['orderby'])) { |
|
| 336 | + $qv['orderby'] = array('id'); |
|
| 337 | 337 | } |
| 338 | 338 | |
| 339 | 339 | // 'orderby' values may be an array, comma- or space-separated list. |
| 340 | - $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
| 340 | + $ordersby = array_filter(wpinv_parse_list($qv['orderby'])); |
|
| 341 | 341 | |
| 342 | 342 | $orderby_array = array(); |
| 343 | - foreach ( $ordersby as $_key => $_value ) { |
|
| 343 | + foreach ($ordersby as $_key => $_value) { |
|
| 344 | 344 | |
| 345 | - if ( is_int( $_key ) ) { |
|
| 345 | + if (is_int($_key)) { |
|
| 346 | 346 | // Integer key means this is a flat array of 'orderby' fields. |
| 347 | 347 | $_orderby = $_value; |
| 348 | 348 | $_order = $order; |
@@ -352,19 +352,19 @@ discard block |
||
| 352 | 352 | $_order = $_value; |
| 353 | 353 | } |
| 354 | 354 | |
| 355 | - $parsed = $this->parse_orderby( $_orderby, $table ); |
|
| 355 | + $parsed = $this->parse_orderby($_orderby, $table); |
|
| 356 | 356 | |
| 357 | - if ( $parsed ) { |
|
| 358 | - $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
| 357 | + if ($parsed) { |
|
| 358 | + $orderby_array[] = $parsed . ' ' . $this->parse_order($_order); |
|
| 359 | 359 | } |
| 360 | 360 | } |
| 361 | 361 | |
| 362 | 362 | // If no valid clauses were found, order by id. |
| 363 | - if ( empty( $orderby_array ) ) { |
|
| 363 | + if (empty($orderby_array)) { |
|
| 364 | 364 | $orderby_array[] = "id $order"; |
| 365 | 365 | } |
| 366 | 366 | |
| 367 | - $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
| 367 | + $this->query_orderby = 'ORDER BY ' . implode(', ', $orderby_array); |
|
| 368 | 368 | |
| 369 | 369 | } |
| 370 | 370 | |
@@ -378,34 +378,34 @@ discard block |
||
| 378 | 378 | public function query() { |
| 379 | 379 | global $wpdb; |
| 380 | 380 | |
| 381 | - $qv =& $this->query_vars; |
|
| 381 | + $qv = & $this->query_vars; |
|
| 382 | 382 | |
| 383 | 383 | // Return a non-null value to bypass the default GetPaid subscriptions query and remember to set the |
| 384 | 384 | // total_subscriptions property. |
| 385 | - $this->results = apply_filters_ref_array( 'getpaid_subscriptions_pre_query', array( null, &$this ) ); |
|
| 385 | + $this->results = apply_filters_ref_array('getpaid_subscriptions_pre_query', array(null, &$this)); |
|
| 386 | 386 | |
| 387 | - if ( null === $this->results ) { |
|
| 387 | + if (null === $this->results) { |
|
| 388 | 388 | $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
| 389 | 389 | |
| 390 | - if ( ( is_array( $qv['fields'] ) && 1 != count( $qv['fields'] ) ) || 'all' == $qv['fields'] ) { |
|
| 391 | - $this->results = $wpdb->get_results( $this->request ); |
|
| 390 | + if ((is_array($qv['fields']) && 1 != count($qv['fields'])) || 'all' == $qv['fields']) { |
|
| 391 | + $this->results = $wpdb->get_results($this->request); |
|
| 392 | 392 | } else { |
| 393 | - $this->results = $wpdb->get_col( $this->request ); |
|
| 393 | + $this->results = $wpdb->get_col($this->request); |
|
| 394 | 394 | } |
| 395 | 395 | |
| 396 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 397 | - $found_subscriptions_query = apply_filters( 'getpaid_found_subscriptions_query', 'SELECT FOUND_ROWS()', $this ); |
|
| 398 | - $this->total_subscriptions = (int) $wpdb->get_var( $found_subscriptions_query ); |
|
| 396 | + if (isset($qv['count_total']) && $qv['count_total']) { |
|
| 397 | + $found_subscriptions_query = apply_filters('getpaid_found_subscriptions_query', 'SELECT FOUND_ROWS()', $this); |
|
| 398 | + $this->total_subscriptions = (int) $wpdb->get_var($found_subscriptions_query); |
|
| 399 | 399 | } |
| 400 | 400 | } |
| 401 | 401 | |
| 402 | - if ( 'all' == $qv['fields'] ) { |
|
| 403 | - foreach ( $this->results as $key => $subscription ) { |
|
| 404 | - $this->set_cache( $subscription->id, $subscription, 'getpaid_subscriptions' ); |
|
| 405 | - $this->set_cache( $subscription->profile_id, $subscription->id, 'getpaid_subscription_profile_ids_to_subscription_ids' ); |
|
| 406 | - $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
| 407 | - $this->set_cache( $subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids' ); |
|
| 408 | - $this->results[ $key ] = new WPInv_Subscription( $subscription ); |
|
| 402 | + if ('all' == $qv['fields']) { |
|
| 403 | + foreach ($this->results as $key => $subscription) { |
|
| 404 | + $this->set_cache($subscription->id, $subscription, 'getpaid_subscriptions'); |
|
| 405 | + $this->set_cache($subscription->profile_id, $subscription->id, 'getpaid_subscription_profile_ids_to_subscription_ids'); |
|
| 406 | + $this->set_cache($subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids'); |
|
| 407 | + $this->set_cache($subscription->transaction_id, $subscription->id, 'getpaid_subscription_transaction_ids_to_subscription_ids'); |
|
| 408 | + $this->results[$key] = new WPInv_Subscription($subscription); |
|
| 409 | 409 | } |
| 410 | 410 | } |
| 411 | 411 | |
@@ -420,13 +420,13 @@ discard block |
||
| 420 | 420 | * @param integer $expire |
| 421 | 421 | * @return boolean |
| 422 | 422 | */ |
| 423 | - public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
| 423 | + public function set_cache($key, $data, $group = '', $expire = 0) { |
|
| 424 | 424 | |
| 425 | - if ( empty( $key ) ) { |
|
| 425 | + if (empty($key)) { |
|
| 426 | 426 | return false; |
| 427 | 427 | } |
| 428 | 428 | |
| 429 | - wp_cache_set( $key, $data, $group, $expire ); |
|
| 429 | + wp_cache_set($key, $data, $group, $expire); |
|
| 430 | 430 | } |
| 431 | 431 | |
| 432 | 432 | /** |
@@ -437,9 +437,9 @@ discard block |
||
| 437 | 437 | * @param string $query_var Query variable key. |
| 438 | 438 | * @return mixed |
| 439 | 439 | */ |
| 440 | - public function get( $query_var ) { |
|
| 441 | - if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
| 442 | - return $this->query_vars[ $query_var ]; |
|
| 440 | + public function get($query_var) { |
|
| 441 | + if (isset($this->query_vars[$query_var])) { |
|
| 442 | + return $this->query_vars[$query_var]; |
|
| 443 | 443 | } |
| 444 | 444 | |
| 445 | 445 | return null; |
@@ -453,8 +453,8 @@ discard block |
||
| 453 | 453 | * @param string $query_var Query variable key. |
| 454 | 454 | * @param mixed $value Query variable value. |
| 455 | 455 | */ |
| 456 | - public function set( $query_var, $value ) { |
|
| 457 | - $this->query_vars[ $query_var ] = $value; |
|
| 456 | + public function set($query_var, $value) { |
|
| 457 | + $this->query_vars[$query_var] = $value; |
|
| 458 | 458 | } |
| 459 | 459 | |
| 460 | 460 | /** |
@@ -488,16 +488,16 @@ discard block |
||
| 488 | 488 | * @param string $table The current table. |
| 489 | 489 | * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
| 490 | 490 | */ |
| 491 | - protected function parse_orderby( $orderby, $table ) { |
|
| 491 | + protected function parse_orderby($orderby, $table) { |
|
| 492 | 492 | |
| 493 | 493 | $_orderby = ''; |
| 494 | - if ( in_array( $orderby, array( 'customer_id', 'frequency', 'period', 'initial_amount', 'recurring_amount', 'bill_times', 'transaction_id', 'parent_payment_id', 'product_id', 'created', 'expiration', 'trial_period', 'status', 'profile_id' ) ) ) { |
|
| 494 | + if (in_array($orderby, array('customer_id', 'frequency', 'period', 'initial_amount', 'recurring_amount', 'bill_times', 'transaction_id', 'parent_payment_id', 'product_id', 'created', 'expiration', 'trial_period', 'status', 'profile_id'))) { |
|
| 495 | 495 | $_orderby = "$table.`$orderby`"; |
| 496 | - } elseif ( 'id' === strtolower( $orderby ) ) { |
|
| 496 | + } elseif ('id' === strtolower($orderby)) { |
|
| 497 | 497 | $_orderby = "$table.id"; |
| 498 | - } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
| 499 | - $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
| 500 | - $include_sql = implode( ',', $include ); |
|
| 498 | + } elseif ('include' === $orderby && !empty($this->query_vars['include'])) { |
|
| 499 | + $include = wp_parse_id_list($this->query_vars['include']); |
|
| 500 | + $include_sql = implode(',', $include); |
|
| 501 | 501 | $_orderby = "FIELD( $table.id, $include_sql )"; |
| 502 | 502 | } |
| 503 | 503 | |
@@ -512,12 +512,12 @@ discard block |
||
| 512 | 512 | * @param string $order The 'order' query variable. |
| 513 | 513 | * @return string The sanitized 'order' query variable. |
| 514 | 514 | */ |
| 515 | - protected function parse_order( $order ) { |
|
| 516 | - if ( ! is_string( $order ) || empty( $order ) ) { |
|
| 515 | + protected function parse_order($order) { |
|
| 516 | + if (!is_string($order) || empty($order)) { |
|
| 517 | 517 | return 'DESC'; |
| 518 | 518 | } |
| 519 | 519 | |
| 520 | - if ( 'ASC' === strtoupper( $order ) ) { |
|
| 520 | + if ('ASC' === strtoupper($order)) { |
|
| 521 | 521 | return 'ASC'; |
| 522 | 522 | } else { |
| 523 | 523 | return 'DESC'; |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | // MUST have WordPress. |
| 3 | -if ( ! defined( 'WPINC' ) ) { |
|
| 3 | +if (!defined('WPINC')) { |
|
| 4 | 4 | exit; |
| 5 | 5 | } |
| 6 | 6 | |
@@ -11,23 +11,23 @@ discard block |
||
| 11 | 11 | * |
| 12 | 12 | * @param WP_Post $post |
| 13 | 13 | */ |
| 14 | - public static function output_details( $post ) { |
|
| 15 | - $details = get_post_meta( $post->ID, 'payment_form_data', true ); |
|
| 14 | + public static function output_details($post) { |
|
| 15 | + $details = get_post_meta($post->ID, 'payment_form_data', true); |
|
| 16 | 16 | |
| 17 | - if ( ! is_array( $details ) ) { |
|
| 17 | + if (!is_array($details)) { |
|
| 18 | 18 | return; |
| 19 | 19 | } |
| 20 | 20 | |
| 21 | 21 | echo '<div class="bsui"> <div class="form-row row">'; |
| 22 | 22 | |
| 23 | - foreach ( $details as $key => $value ) { |
|
| 24 | - $key = esc_html( $key ); |
|
| 23 | + foreach ($details as $key => $value) { |
|
| 24 | + $key = esc_html($key); |
|
| 25 | 25 | |
| 26 | - if ( is_array( $value ) ) { |
|
| 27 | - $value = implode( ',', $value ); |
|
| 26 | + if (is_array($value)) { |
|
| 27 | + $value = implode(',', $value); |
|
| 28 | 28 | } |
| 29 | 29 | |
| 30 | - echo wp_kses_post( "<div class='col-12'><strong>$key:</strong></div><div class='col-12 form-group mb-3'>$value</div>" ); |
|
| 30 | + echo wp_kses_post("<div class='col-12'><strong>$key:</strong></div><div class='col-12 form-group mb-3'>$value</div>"); |
|
| 31 | 31 | } |
| 32 | 32 | |
| 33 | 33 | echo '</div></div>'; |
@@ -39,18 +39,18 @@ discard block |
||
| 39 | 39 | * |
| 40 | 40 | * @param WP_Post $post |
| 41 | 41 | */ |
| 42 | - public static function output_shortcode( $post ) { |
|
| 42 | + public static function output_shortcode($post) { |
|
| 43 | 43 | |
| 44 | - if ( ! is_numeric( $post ) ) { |
|
| 44 | + if (!is_numeric($post)) { |
|
| 45 | 45 | $post = $post->ID; |
| 46 | 46 | } |
| 47 | 47 | |
| 48 | - if ( $post == wpinv_get_default_payment_form() ) { |
|
| 48 | + if ($post == wpinv_get_default_payment_form()) { |
|
| 49 | 49 | echo '—'; |
| 50 | 50 | return; |
| 51 | 51 | } |
| 52 | 52 | |
| 53 | - echo "<input type='text' style='min-width: 220px;' value='[getpaid form=" . absint( $post ) . "]' disabled>"; |
|
| 53 | + echo "<input type='text' style='min-width: 220px;' value='[getpaid form=" . absint($post) . "]' disabled>"; |
|
| 54 | 54 | |
| 55 | 55 | } |
| 56 | 56 | |
@@ -7,14 +7,14 @@ |
||
| 7 | 7 | * @version 1.0.19 |
| 8 | 8 | */ |
| 9 | 9 | |
| 10 | -defined( 'ABSPATH' ) || exit; |
|
| 10 | +defined('ABSPATH') || exit; |
|
| 11 | 11 | |
| 12 | -if ( empty( $text ) ) { |
|
| 13 | - $text = __( 'Your IP address is:', 'invoicing' ); |
|
| 12 | +if (empty($text)) { |
|
| 13 | + $text = __('Your IP address is:', 'invoicing'); |
|
| 14 | 14 | } |
| 15 | 15 | |
| 16 | 16 | ?> |
| 17 | 17 | <div class="form-group mb-3 getpaid-ip-info"> |
| 18 | - <span><?php echo wp_kses_post( $text ); ?></span> |
|
| 19 | - <strong><?php echo esc_html( wpinv_get_ip() ); ?></strong> |
|
| 18 | + <span><?php echo wp_kses_post($text); ?></span> |
|
| 19 | + <strong><?php echo esc_html(wpinv_get_ip()); ?></strong> |
|
| 20 | 20 | </div> |
@@ -7,13 +7,13 @@ |
||
| 7 | 7 | * @version 1.0.19 |
| 8 | 8 | */ |
| 9 | 9 | |
| 10 | -defined( 'ABSPATH' ) || exit; |
|
| 10 | +defined('ABSPATH') || exit; |
|
| 11 | 11 | |
| 12 | -if ( empty( $text ) ) { |
|
| 13 | - $text = __( 'Total to pay:', 'invoicing' ); |
|
| 12 | +if (empty($text)) { |
|
| 13 | + $text = __('Total to pay:', 'invoicing'); |
|
| 14 | 14 | } |
| 15 | 15 | ?> |
| 16 | 16 | <div class="form-group mb-3 mt-4"> |
| 17 | - <strong><?php echo esc_html( $text ); ?></strong> |
|
| 17 | + <strong><?php echo esc_html($text); ?></strong> |
|
| 18 | 18 | <span class="getpaid-checkout-total-payable"></span> |
| 19 | 19 | </div> |
@@ -7,31 +7,31 @@ |
||
| 7 | 7 | * @version 1.0.19 |
| 8 | 8 | */ |
| 9 | 9 | |
| 10 | -defined( 'ABSPATH' ) || exit; |
|
| 10 | +defined('ABSPATH') || exit; |
|
| 11 | 11 | |
| 12 | 12 | // Prepare the selectable items. |
| 13 | 13 | $selectable = array(); |
| 14 | -foreach ( $form->get_items() as $item ) { |
|
| 15 | - if ( ! $item->is_required ) { |
|
| 16 | - $selectable[ $item->get_id() ] = $item->get_name() . ' — ' . wpinv_price( $item->get_initial_price() ); |
|
| 14 | +foreach ($form->get_items() as $item) { |
|
| 15 | + if (!$item->is_required) { |
|
| 16 | + $selectable[$item->get_id()] = $item->get_name() . ' — ' . wpinv_price($item->get_initial_price()); |
|
| 17 | 17 | } |
| 18 | 18 | } |
| 19 | 19 | |
| 20 | -if ( empty( $selectable ) ) { |
|
| 20 | +if (empty($selectable)) { |
|
| 21 | 21 | return; |
| 22 | 22 | } |
| 23 | 23 | |
| 24 | 24 | echo '<div class="getpaid-payment-form-items-checkbox form-group mb-3">'; |
| 25 | 25 | |
| 26 | -foreach ( $selectable as $item_id => $item_name ) { |
|
| 26 | +foreach ($selectable as $item_id => $item_name) { |
|
| 27 | 27 | |
| 28 | - $is_checked = get_post_meta( $item_id, 'selected_by_default', true ); |
|
| 28 | + $is_checked = get_post_meta($item_id, 'selected_by_default', true); |
|
| 29 | 29 | |
| 30 | 30 | aui()->input( |
| 31 | 31 | array( |
| 32 | 32 | 'type' => 'checkbox', |
| 33 | 33 | 'name' => 'getpaid-payment-form-selected-item', |
| 34 | - 'id' => 'getpaid-payment-form-selected-item' . uniqid( '_' ) . $item_id, |
|
| 34 | + 'id' => 'getpaid-payment-form-selected-item' . uniqid('_') . $item_id, |
|
| 35 | 35 | 'label' => $item_name, |
| 36 | 36 | 'value' => $item_id, |
| 37 | 37 | 'no_wrap' => true, |
@@ -7,11 +7,11 @@ |
||
| 7 | 7 | * @version 1.0.19 |
| 8 | 8 | */ |
| 9 | 9 | |
| 10 | -defined( 'ABSPATH' ) || exit; |
|
| 10 | +defined('ABSPATH') || exit; |
|
| 11 | 11 | |
| 12 | 12 | ?> |
| 13 | 13 | |
| 14 | 14 | <div class='form-group mb-3'> |
| 15 | - <label :for="active_form_element.id + '_edit'"><?php esc_html_e( 'The total payable text', 'invoicing' ); ?></label> |
|
| 15 | + <label :for="active_form_element.id + '_edit'"><?php esc_html_e('The total payable text', 'invoicing'); ?></label> |
|
| 16 | 16 | <textarea :id="active_form_element.id + '_edit'" v-model='active_form_element.text' class='form-control' rows='3'></textarea> |
| 17 | 17 | </div> |
@@ -7,17 +7,17 @@ discard block |
||
| 7 | 7 | * @version 1.0.19 |
| 8 | 8 | */ |
| 9 | 9 | |
| 10 | -defined( 'ABSPATH' ) || exit; |
|
| 10 | +defined('ABSPATH') || exit; |
|
| 11 | 11 | |
| 12 | 12 | // Prepare the company name. |
| 13 | -$company_name = wpinv_get_option( 'vat_company_name' ); |
|
| 13 | +$company_name = wpinv_get_option('vat_company_name'); |
|
| 14 | 14 | |
| 15 | -if ( empty( $company_name ) ) { |
|
| 15 | +if (empty($company_name)) { |
|
| 16 | 16 | $company_name = wpinv_get_business_name(); |
| 17 | 17 | } |
| 18 | 18 | |
| 19 | 19 | // Prepare the VAT number. |
| 20 | -$vat_number = wpinv_get_option( 'vat_number' ); |
|
| 20 | +$vat_number = wpinv_get_option('vat_number'); |
|
| 21 | 21 | |
| 22 | 22 | ?> |
| 23 | 23 | <div class="getpaid-company-address form-group mb-3"> |
@@ -25,36 +25,36 @@ discard block |
||
| 25 | 25 | <div class="row"> |
| 26 | 26 | |
| 27 | 27 | <div class="invoice-company-address-label col-2"> |
| 28 | - <strong><?php esc_html_e( 'From:', 'invoicing' ); ?></strong> |
|
| 28 | + <strong><?php esc_html_e('From:', 'invoicing'); ?></strong> |
|
| 29 | 29 | </div> |
| 30 | 30 | |
| 31 | 31 | <div class="invoice-company-address-value col-10"> |
| 32 | 32 | |
| 33 | - <?php do_action( 'getpaid_company_address_top' ); ?> |
|
| 33 | + <?php do_action('getpaid_company_address_top'); ?> |
|
| 34 | 34 | |
| 35 | 35 | <div class="name"> |
| 36 | - <a target="_blank" class="text-dark" href="<?php echo esc_url( wpinv_get_business_website() ); ?>"> |
|
| 37 | - <?php echo esc_html( $company_name ); ?> |
|
| 36 | + <a target="_blank" class="text-dark" href="<?php echo esc_url(wpinv_get_business_website()); ?>"> |
|
| 37 | + <?php echo esc_html($company_name); ?> |
|
| 38 | 38 | </a> |
| 39 | 39 | </div> |
| 40 | 40 | |
| 41 | - <?php if ( $address = wpinv_get_business_address() ) { ?> |
|
| 42 | - <?php echo wp_kses_post( $address ); ?> |
|
| 41 | + <?php if ($address = wpinv_get_business_address()) { ?> |
|
| 42 | + <?php echo wp_kses_post($address); ?> |
|
| 43 | 43 | <?php } ?> |
| 44 | 44 | |
| 45 | - <?php if ( $email_from = wpinv_mail_get_from_address() ) { ?> |
|
| 45 | + <?php if ($email_from = wpinv_mail_get_from_address()) { ?> |
|
| 46 | 46 | <div class="email_from"> |
| 47 | - <?php echo wp_sprintf( esc_html__( 'Email: %s', 'invoicing' ), esc_html( $email_from ) ); ?> |
|
| 47 | + <?php echo wp_sprintf(esc_html__('Email: %s', 'invoicing'), esc_html($email_from)); ?> |
|
| 48 | 48 | </div> |
| 49 | 49 | <?php } ?> |
| 50 | 50 | |
| 51 | - <?php if ( ! empty( $vat_number ) ) { ?> |
|
| 51 | + <?php if (!empty($vat_number)) { ?> |
|
| 52 | 52 | <div class="email_from"> |
| 53 | - <?php echo wp_sprintf( esc_html__( 'VAT Number: %s', 'invoicing' ), esc_html( $vat_number ) ); ?> |
|
| 53 | + <?php echo wp_sprintf(esc_html__('VAT Number: %s', 'invoicing'), esc_html($vat_number)); ?> |
|
| 54 | 54 | </div> |
| 55 | 55 | <?php } ?> |
| 56 | 56 | |
| 57 | - <?php do_action( 'getpaid_company_address_bottom' ); ?> |
|
| 57 | + <?php do_action('getpaid_company_address_bottom'); ?> |
|
| 58 | 58 | |
| 59 | 59 | </div> |
| 60 | 60 | |
@@ -1,4 +1,4 @@ discard block |
||
| 1 | -<?php |
|
| 1 | + <?php |
|
| 2 | 2 | /** |
| 3 | 3 | * Displays the company address. |
| 4 | 4 | * |
@@ -7,19 +7,19 @@ discard block |
||
| 7 | 7 | * @version 1.0.19 |
| 8 | 8 | */ |
| 9 | 9 | |
| 10 | -defined( 'ABSPATH' ) || exit; |
|
| 10 | + defined( 'ABSPATH' ) || exit; |
|
| 11 | 11 | |
| 12 | -// Prepare the company name. |
|
| 13 | -$company_name = wpinv_get_option( 'vat_company_name' ); |
|
| 12 | + // Prepare the company name. |
|
| 13 | + $company_name = wpinv_get_option( 'vat_company_name' ); |
|
| 14 | 14 | |
| 15 | -if ( empty( $company_name ) ) { |
|
| 16 | - $company_name = wpinv_get_business_name(); |
|
| 15 | + if ( empty( $company_name ) ) { |
|
| 16 | + $company_name = wpinv_get_business_name(); |
|
| 17 | 17 | } |
| 18 | 18 | |
| 19 | -// Prepare the VAT number. |
|
| 20 | -$vat_number = wpinv_get_option( 'vat_number' ); |
|
| 19 | + // Prepare the VAT number. |
|
| 20 | + $vat_number = wpinv_get_option( 'vat_number' ); |
|
| 21 | 21 | |
| 22 | -?> |
|
| 22 | + ?> |
|
| 23 | 23 | <div class="getpaid-company-address form-group mb-3"> |
| 24 | 24 | |
| 25 | 25 | <div class="row"> |
@@ -39,21 +39,21 @@ discard block |
||
| 39 | 39 | </div> |
| 40 | 40 | |
| 41 | 41 | <?php if ( $address = wpinv_get_business_address() ) { ?> |
| 42 | - <?php echo wp_kses_post( $address ); ?> |
|
| 43 | - <?php } ?> |
|
| 44 | - |
|
| 42 | + <?php echo wp_kses_post( $address ); ?> |
|
| 43 | + <?php } ?> |
|
| 44 | + |
|
| 45 | 45 | <?php if ( $email_from = wpinv_mail_get_from_address() ) { ?> |
| 46 | - <div class="email_from"> |
|
| 46 | + <div class="email_from"> |
|
| 47 | 47 | <?php echo wp_sprintf( esc_html__( 'Email: %s', 'invoicing' ), esc_html( $email_from ) ); ?> |
| 48 | - </div> |
|
| 48 | + </div> |
|
| 49 | 49 | <?php } ?> |
| 50 | - |
|
| 50 | + |
|
| 51 | 51 | <?php if ( ! empty( $vat_number ) ) { ?> |
| 52 | - <div class="email_from"> |
|
| 52 | + <div class="email_from"> |
|
| 53 | 53 | <?php echo wp_sprintf( esc_html__( 'VAT Number: %s', 'invoicing' ), esc_html( $vat_number ) ); ?> |
| 54 | - </div> |
|
| 54 | + </div> |
|
| 55 | 55 | <?php } ?> |
| 56 | - |
|
| 56 | + |
|
| 57 | 57 | <?php do_action( 'getpaid_company_address_bottom' ); ?> |
| 58 | 58 | |
| 59 | 59 | </div> |
