AyeCode /
invoicing
@@ -12,301 +12,301 @@ |
||
| 12 | 12 | */ |
| 13 | 13 | class GetPaid_Payment_Form_Submission_Refresh_Prices { |
| 14 | 14 | |
| 15 | - /** |
|
| 16 | - * Contains the response for refreshing prices. |
|
| 17 | - * @var array |
|
| 18 | - */ |
|
| 19 | - public $response = array(); |
|
| 15 | + /** |
|
| 16 | + * Contains the response for refreshing prices. |
|
| 17 | + * @var array |
|
| 18 | + */ |
|
| 19 | + public $response = array(); |
|
| 20 | 20 | |
| 21 | 21 | /** |
| 22 | - * Class constructor |
|
| 23 | - * |
|
| 24 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 25 | - */ |
|
| 26 | - public function __construct( $submission ) { |
|
| 27 | - |
|
| 28 | - $this->response = array( |
|
| 29 | - 'submission_id' => $submission->id, |
|
| 22 | + * Class constructor |
|
| 23 | + * |
|
| 24 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 25 | + */ |
|
| 26 | + public function __construct( $submission ) { |
|
| 27 | + |
|
| 28 | + $this->response = array( |
|
| 29 | + 'submission_id' => $submission->id, |
|
| 30 | 30 | 'has_recurring' => $submission->has_recurring, |
| 31 | - 'has_subscription_group' => $submission->has_subscription_group(), |
|
| 32 | - 'has_multiple_subscription_groups' => $submission->has_multiple_subscription_groups(), |
|
| 31 | + 'has_subscription_group' => $submission->has_subscription_group(), |
|
| 32 | + 'has_multiple_subscription_groups' => $submission->has_multiple_subscription_groups(), |
|
| 33 | 33 | 'is_free' => ! $submission->should_collect_payment_details(), |
| 34 | - ); |
|
| 35 | - |
|
| 36 | - $payment_form = $submission->get_payment_form(); |
|
| 37 | - if ( ! empty( $payment_form->invoice ) ) { |
|
| 38 | - $this->response['invoice'] = $payment_form->invoice->get_id(); |
|
| 39 | - } |
|
| 40 | - |
|
| 41 | - $this->add_totals( $submission ); |
|
| 42 | - $this->add_texts( $submission ); |
|
| 43 | - $this->add_items( $submission ); |
|
| 44 | - $this->add_fees( $submission ); |
|
| 45 | - $this->add_discounts( $submission ); |
|
| 46 | - $this->add_taxes( $submission ); |
|
| 47 | - $this->add_gateways( $submission ); |
|
| 48 | - $this->add_data( $submission ); |
|
| 49 | - |
|
| 50 | - } |
|
| 51 | - |
|
| 52 | - /** |
|
| 53 | - * Adds totals to a response for submission refresh prices. |
|
| 54 | - * |
|
| 55 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 56 | - */ |
|
| 57 | - public function add_totals( $submission ) { |
|
| 58 | - |
|
| 59 | - $this->response = array_merge( |
|
| 60 | - $this->response, |
|
| 61 | - array( |
|
| 62 | - |
|
| 63 | - 'totals' => array( |
|
| 64 | - 'subtotal' => $submission->format_amount( $submission->get_subtotal() ), |
|
| 65 | - 'discount' => $submission->format_amount( $submission->get_discount() ), |
|
| 66 | - 'fees' => $submission->format_amount( $submission->get_fee() ), |
|
| 67 | - 'tax' => $submission->format_amount( $submission->get_tax() ), |
|
| 68 | - 'total' => $submission->format_amount( $submission->get_total() ), |
|
| 69 | - 'raw_total' => html_entity_decode( sanitize_text_field( $submission->format_amount( $submission->get_total() ) ), ENT_QUOTES ), |
|
| 70 | - ), |
|
| 71 | - |
|
| 72 | - 'recurring' => array( |
|
| 73 | - 'subtotal' => $submission->format_amount( $submission->get_recurring_subtotal() ), |
|
| 74 | - 'discount' => $submission->format_amount( $submission->get_recurring_discount() ), |
|
| 75 | - 'fees' => $submission->format_amount( $submission->get_recurring_fee() ), |
|
| 76 | - 'tax' => $submission->format_amount( $submission->get_recurring_tax() ), |
|
| 77 | - 'total' => $submission->format_amount( $submission->get_recurring_total() ), |
|
| 78 | - ), |
|
| 79 | - |
|
| 80 | - 'initial_amt' => wpinv_round_amount( $submission->get_total(), null, true ), |
|
| 81 | - 'currency' => $submission->get_currency(), |
|
| 82 | - |
|
| 83 | - ) |
|
| 84 | - ); |
|
| 85 | - |
|
| 86 | - } |
|
| 87 | - |
|
| 88 | - /** |
|
| 89 | - * Adds texts to a response for submission refresh prices. |
|
| 90 | - * |
|
| 91 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 92 | - */ |
|
| 93 | - public function add_texts( $submission ) { |
|
| 94 | - |
|
| 95 | - $payable = $submission->format_amount( $submission->get_total() ); |
|
| 96 | - $groups = getpaid_get_subscription_groups( $submission ); |
|
| 97 | - |
|
| 98 | - if ( $submission->has_recurring && 2 > count( $groups ) ) { |
|
| 99 | - |
|
| 100 | - $recurring = new WPInv_Item( $submission->has_recurring ); |
|
| 101 | - $period = getpaid_get_subscription_period_label( $recurring->get_recurring_period( true ), $recurring->get_recurring_interval(), '' ); |
|
| 102 | - $main_item = reset( $groups ); |
|
| 103 | - |
|
| 104 | - if ( $submission->get_total() == $submission->get_recurring_total() ) { |
|
| 105 | - $payable = "$payable / $period"; |
|
| 106 | - } elseif ( $main_item ) { |
|
| 107 | - |
|
| 108 | - $main_item = reset( $main_item ); |
|
| 109 | - |
|
| 110 | - // Calculate the next renewal date. |
|
| 111 | - $_period = $main_item->get_recurring_period( true ); |
|
| 112 | - $_interval = $main_item->get_recurring_interval(); |
|
| 113 | - |
|
| 114 | - // If the subscription item has a trial period... |
|
| 115 | - if ( $main_item->has_free_trial() ) { |
|
| 116 | - $_period = $main_item->get_trial_period( true ); |
|
| 117 | - $_interval = $main_item->get_trial_interval(); |
|
| 118 | - } |
|
| 119 | - |
|
| 120 | - $payable = sprintf( |
|
| 121 | - __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
| 122 | - $submission->format_amount( $submission->get_total() ), |
|
| 123 | - $submission->format_amount( $submission->get_recurring_total() ), |
|
| 124 | - $period |
|
| 125 | - ); |
|
| 126 | - |
|
| 127 | - $payable .= sprintf( |
|
| 128 | - '<small class="text-muted form-text">%s</small>', |
|
| 129 | - sprintf( |
|
| 130 | - __( 'First renewal on %s', 'invoicing' ), |
|
| 131 | - getpaid_format_date( date( 'Y-m-d H:i:s', strtotime( "+$_interval $_period", current_time( 'timestamp' ) ) ) ) |
|
| 132 | - ) |
|
| 133 | - ); |
|
| 134 | - |
|
| 135 | - } else { |
|
| 136 | - $payable = sprintf( |
|
| 137 | - __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
| 138 | - $submission->format_amount( $submission->get_total() ), |
|
| 139 | - $submission->format_amount( $submission->get_recurring_total() ), |
|
| 140 | - $period |
|
| 141 | - ); |
|
| 142 | - } |
|
| 143 | -} |
|
| 34 | + ); |
|
| 35 | + |
|
| 36 | + $payment_form = $submission->get_payment_form(); |
|
| 37 | + if ( ! empty( $payment_form->invoice ) ) { |
|
| 38 | + $this->response['invoice'] = $payment_form->invoice->get_id(); |
|
| 39 | + } |
|
| 40 | + |
|
| 41 | + $this->add_totals( $submission ); |
|
| 42 | + $this->add_texts( $submission ); |
|
| 43 | + $this->add_items( $submission ); |
|
| 44 | + $this->add_fees( $submission ); |
|
| 45 | + $this->add_discounts( $submission ); |
|
| 46 | + $this->add_taxes( $submission ); |
|
| 47 | + $this->add_gateways( $submission ); |
|
| 48 | + $this->add_data( $submission ); |
|
| 49 | + |
|
| 50 | + } |
|
| 51 | + |
|
| 52 | + /** |
|
| 53 | + * Adds totals to a response for submission refresh prices. |
|
| 54 | + * |
|
| 55 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 56 | + */ |
|
| 57 | + public function add_totals( $submission ) { |
|
| 58 | + |
|
| 59 | + $this->response = array_merge( |
|
| 60 | + $this->response, |
|
| 61 | + array( |
|
| 62 | + |
|
| 63 | + 'totals' => array( |
|
| 64 | + 'subtotal' => $submission->format_amount( $submission->get_subtotal() ), |
|
| 65 | + 'discount' => $submission->format_amount( $submission->get_discount() ), |
|
| 66 | + 'fees' => $submission->format_amount( $submission->get_fee() ), |
|
| 67 | + 'tax' => $submission->format_amount( $submission->get_tax() ), |
|
| 68 | + 'total' => $submission->format_amount( $submission->get_total() ), |
|
| 69 | + 'raw_total' => html_entity_decode( sanitize_text_field( $submission->format_amount( $submission->get_total() ) ), ENT_QUOTES ), |
|
| 70 | + ), |
|
| 71 | + |
|
| 72 | + 'recurring' => array( |
|
| 73 | + 'subtotal' => $submission->format_amount( $submission->get_recurring_subtotal() ), |
|
| 74 | + 'discount' => $submission->format_amount( $submission->get_recurring_discount() ), |
|
| 75 | + 'fees' => $submission->format_amount( $submission->get_recurring_fee() ), |
|
| 76 | + 'tax' => $submission->format_amount( $submission->get_recurring_tax() ), |
|
| 77 | + 'total' => $submission->format_amount( $submission->get_recurring_total() ), |
|
| 78 | + ), |
|
| 79 | + |
|
| 80 | + 'initial_amt' => wpinv_round_amount( $submission->get_total(), null, true ), |
|
| 81 | + 'currency' => $submission->get_currency(), |
|
| 82 | + |
|
| 83 | + ) |
|
| 84 | + ); |
|
| 85 | + |
|
| 86 | + } |
|
| 144 | 87 | |
| 145 | - $texts = array( |
|
| 146 | - '.getpaid-checkout-total-payable' => $payable, |
|
| 147 | - ); |
|
| 88 | + /** |
|
| 89 | + * Adds texts to a response for submission refresh prices. |
|
| 90 | + * |
|
| 91 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 92 | + */ |
|
| 93 | + public function add_texts( $submission ) { |
|
| 94 | + |
|
| 95 | + $payable = $submission->format_amount( $submission->get_total() ); |
|
| 96 | + $groups = getpaid_get_subscription_groups( $submission ); |
|
| 97 | + |
|
| 98 | + if ( $submission->has_recurring && 2 > count( $groups ) ) { |
|
| 99 | + |
|
| 100 | + $recurring = new WPInv_Item( $submission->has_recurring ); |
|
| 101 | + $period = getpaid_get_subscription_period_label( $recurring->get_recurring_period( true ), $recurring->get_recurring_interval(), '' ); |
|
| 102 | + $main_item = reset( $groups ); |
|
| 103 | + |
|
| 104 | + if ( $submission->get_total() == $submission->get_recurring_total() ) { |
|
| 105 | + $payable = "$payable / $period"; |
|
| 106 | + } elseif ( $main_item ) { |
|
| 107 | + |
|
| 108 | + $main_item = reset( $main_item ); |
|
| 109 | + |
|
| 110 | + // Calculate the next renewal date. |
|
| 111 | + $_period = $main_item->get_recurring_period( true ); |
|
| 112 | + $_interval = $main_item->get_recurring_interval(); |
|
| 113 | + |
|
| 114 | + // If the subscription item has a trial period... |
|
| 115 | + if ( $main_item->has_free_trial() ) { |
|
| 116 | + $_period = $main_item->get_trial_period( true ); |
|
| 117 | + $_interval = $main_item->get_trial_interval(); |
|
| 118 | + } |
|
| 119 | + |
|
| 120 | + $payable = sprintf( |
|
| 121 | + __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
| 122 | + $submission->format_amount( $submission->get_total() ), |
|
| 123 | + $submission->format_amount( $submission->get_recurring_total() ), |
|
| 124 | + $period |
|
| 125 | + ); |
|
| 126 | + |
|
| 127 | + $payable .= sprintf( |
|
| 128 | + '<small class="text-muted form-text">%s</small>', |
|
| 129 | + sprintf( |
|
| 130 | + __( 'First renewal on %s', 'invoicing' ), |
|
| 131 | + getpaid_format_date( date( 'Y-m-d H:i:s', strtotime( "+$_interval $_period", current_time( 'timestamp' ) ) ) ) |
|
| 132 | + ) |
|
| 133 | + ); |
|
| 134 | + |
|
| 135 | + } else { |
|
| 136 | + $payable = sprintf( |
|
| 137 | + __( '%1$s (renews at %2$s / %3$s)', 'invoicing' ), |
|
| 138 | + $submission->format_amount( $submission->get_total() ), |
|
| 139 | + $submission->format_amount( $submission->get_recurring_total() ), |
|
| 140 | + $period |
|
| 141 | + ); |
|
| 142 | + } |
|
| 143 | +} |
|
| 148 | 144 | |
| 149 | - foreach ( $submission->get_items() as $item ) { |
|
| 150 | - $item_id = $item->get_id(); |
|
| 151 | - $initial_price = $submission->format_amount( $item->get_sub_total() - $item->item_discount ); |
|
| 152 | - $recurring_price = $submission->format_amount( $item->get_recurring_sub_total() - $item->recurring_item_discount ); |
|
| 153 | - $texts[ ".item-$item_id .getpaid-form-item-price-desc" ] = getpaid_item_recurring_price_help_text( $item, $submission->get_currency(), $initial_price, $recurring_price ); |
|
| 154 | - $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = sprintf( __( 'Subtotal: %s', 'invoicing' ), $submission->format_amount( $item->get_sub_total() ) ); |
|
| 145 | + $texts = array( |
|
| 146 | + '.getpaid-checkout-total-payable' => $payable, |
|
| 147 | + ); |
|
| 155 | 148 | |
| 156 | - if ( $item->get_quantity() == 1 ) { |
|
| 157 | - $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = ''; |
|
| 158 | - } |
|
| 149 | + foreach ( $submission->get_items() as $item ) { |
|
| 150 | + $item_id = $item->get_id(); |
|
| 151 | + $initial_price = $submission->format_amount( $item->get_sub_total() - $item->item_discount ); |
|
| 152 | + $recurring_price = $submission->format_amount( $item->get_recurring_sub_total() - $item->recurring_item_discount ); |
|
| 153 | + $texts[ ".item-$item_id .getpaid-form-item-price-desc" ] = getpaid_item_recurring_price_help_text( $item, $submission->get_currency(), $initial_price, $recurring_price ); |
|
| 154 | + $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = sprintf( __( 'Subtotal: %s', 'invoicing' ), $submission->format_amount( $item->get_sub_total() ) ); |
|
| 155 | + |
|
| 156 | + if ( $item->get_quantity() == 1 ) { |
|
| 157 | + $texts[ ".item-$item_id .getpaid-mobile-item-subtotal" ] = ''; |
|
| 158 | + } |
|
| 159 | 159 | } |
| 160 | 160 | |
| 161 | - $this->response = array_merge( $this->response, array( 'texts' => $texts ) ); |
|
| 161 | + $this->response = array_merge( $this->response, array( 'texts' => $texts ) ); |
|
| 162 | 162 | |
| 163 | - } |
|
| 163 | + } |
|
| 164 | 164 | |
| 165 | - /** |
|
| 166 | - * Adds items to a response for submission refresh prices. |
|
| 167 | - * |
|
| 168 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 169 | - */ |
|
| 170 | - public function add_items( $submission ) { |
|
| 165 | + /** |
|
| 166 | + * Adds items to a response for submission refresh prices. |
|
| 167 | + * |
|
| 168 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 169 | + */ |
|
| 170 | + public function add_items( $submission ) { |
|
| 171 | 171 | |
| 172 | - // Add items. |
|
| 173 | - $items = array(); |
|
| 174 | - $selected_items = array(); |
|
| 172 | + // Add items. |
|
| 173 | + $items = array(); |
|
| 174 | + $selected_items = array(); |
|
| 175 | 175 | |
| 176 | 176 | foreach ( $submission->get_items() as $item ) { |
| 177 | - $item_id = $item->get_id(); |
|
| 178 | - $items[ "$item_id" ] = $submission->format_amount( $item->get_sub_total() ); |
|
| 179 | - |
|
| 180 | - $selected_items[ "$item_id" ] = array( |
|
| 181 | - 'quantity' => $item->get_quantity(), |
|
| 182 | - 'price' => $item->get_price(), |
|
| 183 | - 'price_fmt' => $submission->format_amount( $item->get_price() ), |
|
| 184 | - ); |
|
| 185 | - } |
|
| 186 | - |
|
| 187 | - $this->response = array_merge( |
|
| 188 | - $this->response, |
|
| 189 | - array( |
|
| 190 | - 'items' => $items, |
|
| 191 | - 'selected_items' => $selected_items, |
|
| 192 | - ) |
|
| 193 | - ); |
|
| 194 | - |
|
| 195 | - } |
|
| 196 | - |
|
| 197 | - /** |
|
| 198 | - * Adds fees to a response for submission refresh prices. |
|
| 199 | - * |
|
| 200 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 201 | - */ |
|
| 202 | - public function add_fees( $submission ) { |
|
| 203 | - |
|
| 204 | - $fees = array(); |
|
| 177 | + $item_id = $item->get_id(); |
|
| 178 | + $items[ "$item_id" ] = $submission->format_amount( $item->get_sub_total() ); |
|
| 179 | + |
|
| 180 | + $selected_items[ "$item_id" ] = array( |
|
| 181 | + 'quantity' => $item->get_quantity(), |
|
| 182 | + 'price' => $item->get_price(), |
|
| 183 | + 'price_fmt' => $submission->format_amount( $item->get_price() ), |
|
| 184 | + ); |
|
| 185 | + } |
|
| 186 | + |
|
| 187 | + $this->response = array_merge( |
|
| 188 | + $this->response, |
|
| 189 | + array( |
|
| 190 | + 'items' => $items, |
|
| 191 | + 'selected_items' => $selected_items, |
|
| 192 | + ) |
|
| 193 | + ); |
|
| 194 | + |
|
| 195 | + } |
|
| 196 | + |
|
| 197 | + /** |
|
| 198 | + * Adds fees to a response for submission refresh prices. |
|
| 199 | + * |
|
| 200 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 201 | + */ |
|
| 202 | + public function add_fees( $submission ) { |
|
| 203 | + |
|
| 204 | + $fees = array(); |
|
| 205 | 205 | |
| 206 | 206 | foreach ( $submission->get_fees() as $name => $data ) { |
| 207 | - $fees[ $name ] = $submission->format_amount( $data['initial_fee'] ); |
|
| 208 | - } |
|
| 207 | + $fees[ $name ] = $submission->format_amount( $data['initial_fee'] ); |
|
| 208 | + } |
|
| 209 | 209 | |
| 210 | - $this->response = array_merge( |
|
| 211 | - $this->response, |
|
| 212 | - array( 'fees' => $fees ) |
|
| 213 | - ); |
|
| 210 | + $this->response = array_merge( |
|
| 211 | + $this->response, |
|
| 212 | + array( 'fees' => $fees ) |
|
| 213 | + ); |
|
| 214 | 214 | |
| 215 | - } |
|
| 215 | + } |
|
| 216 | 216 | |
| 217 | - /** |
|
| 218 | - * Adds discounts to a response for submission refresh prices. |
|
| 219 | - * |
|
| 220 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 221 | - */ |
|
| 222 | - public function add_discounts( $submission ) { |
|
| 217 | + /** |
|
| 218 | + * Adds discounts to a response for submission refresh prices. |
|
| 219 | + * |
|
| 220 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 221 | + */ |
|
| 222 | + public function add_discounts( $submission ) { |
|
| 223 | 223 | |
| 224 | - $discounts = array(); |
|
| 224 | + $discounts = array(); |
|
| 225 | 225 | |
| 226 | 226 | foreach ( $submission->get_discounts() as $name => $data ) { |
| 227 | - $discounts[ $name ] = $submission->format_amount( $data['initial_discount'] ); |
|
| 228 | - } |
|
| 229 | - |
|
| 230 | - $this->response = array_merge( |
|
| 231 | - $this->response, |
|
| 232 | - array( 'discounts' => $discounts ) |
|
| 233 | - ); |
|
| 227 | + $discounts[ $name ] = $submission->format_amount( $data['initial_discount'] ); |
|
| 228 | + } |
|
| 234 | 229 | |
| 235 | - } |
|
| 230 | + $this->response = array_merge( |
|
| 231 | + $this->response, |
|
| 232 | + array( 'discounts' => $discounts ) |
|
| 233 | + ); |
|
| 236 | 234 | |
| 237 | - /** |
|
| 238 | - * Adds taxes to a response for submission refresh prices. |
|
| 239 | - * |
|
| 240 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 241 | - */ |
|
| 242 | - public function add_taxes( $submission ) { |
|
| 235 | + } |
|
| 243 | 236 | |
| 244 | - $taxes = array(); |
|
| 245 | - $markup = ''; |
|
| 237 | + /** |
|
| 238 | + * Adds taxes to a response for submission refresh prices. |
|
| 239 | + * |
|
| 240 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 241 | + */ |
|
| 242 | + public function add_taxes( $submission ) { |
|
| 243 | + |
|
| 244 | + $taxes = array(); |
|
| 245 | + $markup = ''; |
|
| 246 | 246 | foreach ( $submission->get_taxes() as $name => $data ) { |
| 247 | - $name = sanitize_text_field( $name ); |
|
| 248 | - $amount = $submission->format_amount( $data['initial_tax'] ); |
|
| 249 | - $taxes[ $name ] = $amount; |
|
| 250 | - $markup .= "<small class='form-text'>$name : $amount</small>"; |
|
| 251 | - } |
|
| 252 | - |
|
| 253 | - $this->response = array_merge( |
|
| 254 | - $this->response, |
|
| 255 | - array( 'taxes' => $taxes ) |
|
| 256 | - ); |
|
| 257 | - |
|
| 258 | - } |
|
| 259 | - |
|
| 260 | - /** |
|
| 261 | - * Adds gateways to a response for submission refresh prices. |
|
| 262 | - * |
|
| 263 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 264 | - */ |
|
| 265 | - public function add_gateways( $submission ) { |
|
| 266 | - |
|
| 267 | - $gateways = array_keys( wpinv_get_enabled_payment_gateways() ); |
|
| 268 | - |
|
| 269 | - if ( $this->response['has_recurring'] ) { |
|
| 270 | - |
|
| 271 | - foreach ( $gateways as $i => $gateway ) { |
|
| 272 | - |
|
| 273 | - if ( |
|
| 274 | - ! getpaid_payment_gateway_supports( $gateway, 'subscription' ) |
|
| 275 | - || ( $this->response['has_subscription_group'] && ! getpaid_payment_gateway_supports( $gateway, 'single_subscription_group' ) ) |
|
| 276 | - || ( $this->response['has_multiple_subscription_groups'] && ! getpaid_payment_gateway_supports( $gateway, 'multiple_subscription_groups' ) ) ) { |
|
| 277 | - unset( $gateways[ $i ] ); |
|
| 278 | - } |
|
| 247 | + $name = sanitize_text_field( $name ); |
|
| 248 | + $amount = $submission->format_amount( $data['initial_tax'] ); |
|
| 249 | + $taxes[ $name ] = $amount; |
|
| 250 | + $markup .= "<small class='form-text'>$name : $amount</small>"; |
|
| 251 | + } |
|
| 252 | + |
|
| 253 | + $this->response = array_merge( |
|
| 254 | + $this->response, |
|
| 255 | + array( 'taxes' => $taxes ) |
|
| 256 | + ); |
|
| 257 | + |
|
| 258 | + } |
|
| 259 | + |
|
| 260 | + /** |
|
| 261 | + * Adds gateways to a response for submission refresh prices. |
|
| 262 | + * |
|
| 263 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 264 | + */ |
|
| 265 | + public function add_gateways( $submission ) { |
|
| 266 | + |
|
| 267 | + $gateways = array_keys( wpinv_get_enabled_payment_gateways() ); |
|
| 268 | + |
|
| 269 | + if ( $this->response['has_recurring'] ) { |
|
| 270 | + |
|
| 271 | + foreach ( $gateways as $i => $gateway ) { |
|
| 272 | + |
|
| 273 | + if ( |
|
| 274 | + ! getpaid_payment_gateway_supports( $gateway, 'subscription' ) |
|
| 275 | + || ( $this->response['has_subscription_group'] && ! getpaid_payment_gateway_supports( $gateway, 'single_subscription_group' ) ) |
|
| 276 | + || ( $this->response['has_multiple_subscription_groups'] && ! getpaid_payment_gateway_supports( $gateway, 'multiple_subscription_groups' ) ) ) { |
|
| 277 | + unset( $gateways[ $i ] ); |
|
| 278 | + } |
|
| 279 | 279 | } |
| 280 | 280 | } |
| 281 | 281 | |
| 282 | - $gateways = apply_filters( 'getpaid_submission_gateways', $gateways, $submission ); |
|
| 283 | - $this->response = array_merge( |
|
| 284 | - $this->response, |
|
| 285 | - array( 'gateways' => $gateways ) |
|
| 286 | - ); |
|
| 287 | - |
|
| 288 | - } |
|
| 289 | - |
|
| 290 | - /** |
|
| 291 | - * Adds data to a response for submission refresh prices. |
|
| 292 | - * |
|
| 293 | - * @param GetPaid_Payment_Form_Submission $submission |
|
| 294 | - */ |
|
| 295 | - public function add_data( $submission ) { |
|
| 296 | - |
|
| 297 | - $this->response = array_merge( |
|
| 298 | - $this->response, |
|
| 299 | - array( |
|
| 300 | - 'js_data' => apply_filters( |
|
| 301 | - 'getpaid_submission_js_data', |
|
| 302 | - array( |
|
| 303 | - 'is_recurring' => $this->response['has_recurring'], |
|
| 304 | - ), |
|
| 305 | - $submission |
|
| 306 | - ), |
|
| 307 | - ) |
|
| 308 | - ); |
|
| 309 | - |
|
| 310 | - } |
|
| 282 | + $gateways = apply_filters( 'getpaid_submission_gateways', $gateways, $submission ); |
|
| 283 | + $this->response = array_merge( |
|
| 284 | + $this->response, |
|
| 285 | + array( 'gateways' => $gateways ) |
|
| 286 | + ); |
|
| 287 | + |
|
| 288 | + } |
|
| 289 | + |
|
| 290 | + /** |
|
| 291 | + * Adds data to a response for submission refresh prices. |
|
| 292 | + * |
|
| 293 | + * @param GetPaid_Payment_Form_Submission $submission |
|
| 294 | + */ |
|
| 295 | + public function add_data( $submission ) { |
|
| 296 | + |
|
| 297 | + $this->response = array_merge( |
|
| 298 | + $this->response, |
|
| 299 | + array( |
|
| 300 | + 'js_data' => apply_filters( |
|
| 301 | + 'getpaid_submission_js_data', |
|
| 302 | + array( |
|
| 303 | + 'is_recurring' => $this->response['has_recurring'], |
|
| 304 | + ), |
|
| 305 | + $submission |
|
| 306 | + ), |
|
| 307 | + ) |
|
| 308 | + ); |
|
| 309 | + |
|
| 310 | + } |
|
| 311 | 311 | |
| 312 | 312 | } |
@@ -16,502 +16,502 @@ |
||
| 16 | 16 | */ |
| 17 | 17 | class GetPaid_Customers_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 customers. |
|
| 29 | - * |
|
| 30 | - * @since 1.0.19 |
|
| 31 | - * @var array |
|
| 32 | - */ |
|
| 33 | - private $results; |
|
| 34 | - |
|
| 35 | - /** |
|
| 36 | - * Total number of found customers for the current query |
|
| 37 | - * |
|
| 38 | - * @since 1.0.19 |
|
| 39 | - * @var int |
|
| 40 | - */ |
|
| 41 | - private $total_customers = 0; |
|
| 42 | - |
|
| 43 | - /** |
|
| 44 | - * The SQL query used to fetch matching customers. |
|
| 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 | - 'include' => array(), |
|
| 118 | - 'exclude' => array(), |
|
| 119 | - 'orderby' => 'id', |
|
| 120 | - 'order' => 'DESC', |
|
| 121 | - 'offset' => '', |
|
| 122 | - 'number' => 10, |
|
| 123 | - 'paged' => 1, |
|
| 124 | - 'count_total' => true, |
|
| 125 | - 'fields' => 'all', |
|
| 126 | - 's' => '', |
|
| 127 | - ); |
|
| 128 | - |
|
| 129 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 130 | - $defaults[ $field ] = 'any'; |
|
| 131 | - |
|
| 132 | - if ( '%f' === $type || '%d' === $type ) { |
|
| 133 | - $defaults[ $field . '_min' ] = ''; |
|
| 134 | - $defaults[ $field . '_max' ] = ''; |
|
| 135 | - } |
|
| 136 | - } |
|
| 137 | - |
|
| 138 | - return wp_parse_args( $args, $defaults ); |
|
| 139 | - } |
|
| 140 | - |
|
| 141 | - /** |
|
| 142 | - * Prepare the query variables. |
|
| 143 | - * |
|
| 144 | - * @since 1.0.19 |
|
| 145 | - * |
|
| 146 | - * @see self::fill_query_vars() For allowede args and their defaults. |
|
| 147 | - */ |
|
| 148 | - public function prepare_query( $query = array() ) { |
|
| 149 | - global $wpdb; |
|
| 150 | - |
|
| 151 | - if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
| 152 | - $this->query_limit = null; |
|
| 153 | - $this->query_vars = $this->fill_query_vars( $query ); |
|
| 154 | - } |
|
| 155 | - |
|
| 156 | - if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
| 157 | - $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
| 158 | - } |
|
| 159 | - |
|
| 160 | - do_action( 'getpaid_pre_get_customers', array( &$this ) ); |
|
| 161 | - |
|
| 162 | - // Ensure that query vars are filled after 'getpaid_pre_get_customers'. |
|
| 163 | - $qv = & $this->query_vars; |
|
| 164 | - $qv = $this->fill_query_vars( $qv ); |
|
| 165 | - $table = $wpdb->prefix . 'getpaid_customers'; |
|
| 166 | - $this->query_from = "FROM $table"; |
|
| 167 | - |
|
| 168 | - // Prepare query fields. |
|
| 169 | - $this->prepare_query_fields( $qv, $table ); |
|
| 170 | - |
|
| 171 | - // Prepare query where. |
|
| 172 | - $this->prepare_query_where( $qv, $table ); |
|
| 173 | - |
|
| 174 | - // Prepare query order. |
|
| 175 | - $this->prepare_query_order( $qv, $table ); |
|
| 176 | - |
|
| 177 | - // limit |
|
| 178 | - if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
| 179 | - if ( $qv['offset'] ) { |
|
| 180 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
| 181 | - } else { |
|
| 182 | - $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
| 183 | - } |
|
| 184 | - } |
|
| 185 | - |
|
| 186 | - do_action_ref_array( 'getpaid_after_customers_query', array( &$this ) ); |
|
| 187 | - } |
|
| 188 | - |
|
| 189 | - /** |
|
| 190 | - * Prepares the query fields. |
|
| 191 | - * |
|
| 192 | - * @since 1.0.19 |
|
| 193 | - * |
|
| 194 | - * @param array $qv Query vars. |
|
| 195 | - * @param string $table Table name. |
|
| 196 | - */ |
|
| 197 | - protected function prepare_query_fields( &$qv, $table ) { |
|
| 198 | - |
|
| 199 | - if ( is_array( $qv['fields'] ) ) { |
|
| 200 | - $qv['fields'] = array_unique( $qv['fields'] ); |
|
| 201 | - $allowed_fields = array_keys( GetPaid_Customer_Data_Store::get_database_fields() ); |
|
| 202 | - |
|
| 203 | - $query_fields = array(); |
|
| 204 | - foreach ( $qv['fields'] as $field ) { |
|
| 205 | - if ( ! in_array( $field, $allowed_fields ) ) { |
|
| 206 | - continue; |
|
| 207 | - } |
|
| 208 | - |
|
| 209 | - $field = sanitize_key( $field ); |
|
| 210 | - $query_fields[] = "$table.`$field`"; |
|
| 211 | - } |
|
| 212 | - $this->query_fields = implode( ',', $query_fields ); |
|
| 213 | - } else { |
|
| 214 | - $this->query_fields = "$table.*"; |
|
| 215 | - } |
|
| 216 | - |
|
| 217 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 218 | - $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
| 219 | - } |
|
| 220 | - |
|
| 221 | - } |
|
| 222 | - |
|
| 223 | - /** |
|
| 224 | - * Prepares the query where. |
|
| 225 | - * |
|
| 226 | - * @since 1.0.19 |
|
| 227 | - * |
|
| 228 | - * @param array $qv Query vars. |
|
| 229 | - * @param string $table Table name. |
|
| 230 | - */ |
|
| 231 | - protected function prepare_query_where( &$qv, $table ) { |
|
| 232 | - global $wpdb; |
|
| 233 | - $this->query_where = 'WHERE 1=1'; |
|
| 234 | - |
|
| 235 | - // Fields. |
|
| 236 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 237 | - if ( 'any' !== $qv[ $field ] ) { |
|
| 238 | - |
|
| 239 | - // In. |
|
| 240 | - if ( is_array( $qv[ $field ] ) ) { |
|
| 241 | - $in = join( ',', array_fill( 0, count( $qv[ $field ] ), $type ) ); |
|
| 242 | - $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $in )", $qv[ $field ] ); |
|
| 243 | - } elseif ( ! empty( $qv[ $field ] ) ) { |
|
| 244 | - $this->query_where .= $wpdb->prepare( " AND $table.`$field` = $type", $qv[ $field ] ); |
|
| 245 | - } |
|
| 246 | - } |
|
| 247 | - |
|
| 248 | - // Min/Max. |
|
| 249 | - if ( '%f' === $type || '%d' === $type ) { |
|
| 250 | - |
|
| 251 | - // Min. |
|
| 252 | - if ( is_numeric( $qv[ $field . '_min' ] ) ) { |
|
| 253 | - $this->query_where .= $wpdb->prepare( " AND $table.`$field` >= $type", $qv[ $field . '_min' ] ); |
|
| 254 | - } |
|
| 255 | - |
|
| 256 | - // Max. |
|
| 257 | - if ( is_numeric( $qv[ $field . '_max' ] ) ) { |
|
| 258 | - $this->query_where .= $wpdb->prepare( " AND $table.`$field` <= $type", $qv[ $field . '_max' ] ); |
|
| 259 | - } |
|
| 260 | - } |
|
| 261 | - } |
|
| 262 | - |
|
| 263 | - if ( ! empty( $qv['include'] ) ) { |
|
| 264 | - $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
| 265 | - $this->query_where .= " AND $table.`id` IN ($include)"; |
|
| 266 | - } elseif ( ! empty( $qv['exclude'] ) ) { |
|
| 267 | - $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
| 268 | - $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
| 269 | - } |
|
| 270 | - |
|
| 271 | - // Date queries are allowed for the customer creation date. |
|
| 272 | - if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
| 273 | - $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.date_created" ); |
|
| 274 | - $this->query_where .= $date_created_query->get_sql(); |
|
| 275 | - } |
|
| 276 | - |
|
| 277 | - // Search. |
|
| 278 | - if ( ! empty( $qv['s'] ) ) { |
|
| 279 | - $this->query_where .= $this->get_search_sql( $qv['s'] ); |
|
| 280 | - } |
|
| 281 | - } |
|
| 282 | - |
|
| 283 | - /** |
|
| 284 | - * Used internally to generate an SQL string for searching across multiple columns |
|
| 285 | - * |
|
| 286 | - * @since 1.2.7 |
|
| 287 | - * |
|
| 288 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
| 289 | - * |
|
| 290 | - * @param string $string The string to search for. |
|
| 291 | - * @return string |
|
| 292 | - */ |
|
| 293 | - protected function get_search_sql( $string ) { |
|
| 294 | - global $wpdb; |
|
| 295 | - |
|
| 296 | - $searches = array(); |
|
| 297 | - $string = trim( $string, '%' ); |
|
| 298 | - $like = '%' . $wpdb->esc_like( $string ) . '%'; |
|
| 299 | - |
|
| 300 | - foreach ( array_keys( GetPaid_Customer_Data_Store::get_database_fields() ) as $col ) { |
|
| 301 | - if ( 'id' === $col || 'user_id' === $col ) { |
|
| 302 | - $searches[] = $wpdb->prepare( "$col = %s", $string ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
| 303 | - } else { |
|
| 304 | - $searches[] = $wpdb->prepare( "$col LIKE %s", $like ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
| 305 | - } |
|
| 306 | - } |
|
| 307 | - |
|
| 308 | - return ' AND (' . implode( ' OR ', $searches ) . ')'; |
|
| 309 | - } |
|
| 310 | - |
|
| 311 | - /** |
|
| 312 | - * Prepares the query order. |
|
| 313 | - * |
|
| 314 | - * @since 1.0.19 |
|
| 315 | - * |
|
| 316 | - * @param array $qv Query vars. |
|
| 317 | - * @param string $table Table name. |
|
| 318 | - */ |
|
| 319 | - protected function prepare_query_order( &$qv, $table ) { |
|
| 320 | - |
|
| 321 | - // sorting. |
|
| 322 | - $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
| 323 | - $order = $this->parse_order( $qv['order'] ); |
|
| 324 | - |
|
| 325 | - // Default order is by 'id' (latest customers). |
|
| 326 | - if ( empty( $qv['orderby'] ) ) { |
|
| 327 | - $qv['orderby'] = array( 'id' ); |
|
| 328 | - } |
|
| 329 | - |
|
| 330 | - // 'orderby' values may be an array, comma- or space-separated list. |
|
| 331 | - $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
| 332 | - |
|
| 333 | - $orderby_array = array(); |
|
| 334 | - foreach ( $ordersby as $_key => $_value ) { |
|
| 335 | - |
|
| 336 | - if ( is_int( $_key ) ) { |
|
| 337 | - // Integer key means this is a flat array of 'orderby' fields. |
|
| 338 | - $_orderby = $_value; |
|
| 339 | - $_order = $order; |
|
| 340 | - } else { |
|
| 341 | - // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
| 342 | - $_orderby = $_key; |
|
| 343 | - $_order = $_value; |
|
| 344 | - } |
|
| 345 | - |
|
| 346 | - $parsed = $this->parse_orderby( $_orderby, $table ); |
|
| 347 | - |
|
| 348 | - if ( $parsed ) { |
|
| 349 | - $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
| 350 | - } |
|
| 351 | - } |
|
| 352 | - |
|
| 353 | - // If no valid clauses were found, order by id. |
|
| 354 | - if ( empty( $orderby_array ) ) { |
|
| 355 | - $orderby_array[] = "id $order"; |
|
| 356 | - } |
|
| 357 | - |
|
| 358 | - $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
| 359 | - |
|
| 360 | - } |
|
| 361 | - |
|
| 362 | - /** |
|
| 363 | - * Execute the query, with the current variables. |
|
| 364 | - * |
|
| 365 | - * @since 1.0.19 |
|
| 366 | - * |
|
| 367 | - * @global wpdb $wpdb WordPress database abstraction object. |
|
| 368 | - */ |
|
| 369 | - public function query() { |
|
| 370 | - global $wpdb; |
|
| 371 | - |
|
| 372 | - $qv =& $this->query_vars; |
|
| 373 | - |
|
| 374 | - // Return a non-null value to bypass the default GetPaid customers query and remember to set the |
|
| 375 | - // total_customers property. |
|
| 376 | - $this->results = apply_filters_ref_array( 'getpaid_customers_pre_query', array( null, &$this ) ); |
|
| 377 | - |
|
| 378 | - if ( null === $this->results ) { |
|
| 379 | - $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
| 380 | - |
|
| 381 | - if ( ( is_array( $qv['fields'] ) && 1 !== count( $qv['fields'] ) ) || 'all' === $qv['fields'] ) { |
|
| 382 | - $this->results = $wpdb->get_results( $this->request ); |
|
| 383 | - } else { |
|
| 384 | - $this->results = $wpdb->get_col( $this->request ); |
|
| 385 | - } |
|
| 386 | - |
|
| 387 | - if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 388 | - $found_customers_query = apply_filters( 'getpaid_found_customers_query', 'SELECT FOUND_ROWS()', $this ); |
|
| 389 | - $this->total_customers = (int) $wpdb->get_var( $found_customers_query ); |
|
| 390 | - } |
|
| 391 | - } |
|
| 392 | - |
|
| 393 | - if ( 'all' === $qv['fields'] ) { |
|
| 394 | - foreach ( $this->results as $key => $customer ) { |
|
| 395 | - $this->set_cache( $customer->id, $customer, 'getpaid_customers' ); |
|
| 396 | - $this->set_cache( $customer->user_id, $customer->id, 'getpaid_customer_ids_by_user_id' ); |
|
| 397 | - $this->set_cache( $customer->email, $customer->id, 'getpaid_customer_ids_by_email' ); |
|
| 398 | - $this->results[ $key ] = new GetPaid_Customer( $customer ); |
|
| 399 | - } |
|
| 400 | - } |
|
| 401 | - |
|
| 402 | - } |
|
| 403 | - |
|
| 404 | - /** |
|
| 405 | - * Set cache |
|
| 406 | - * |
|
| 407 | - * @param string $id |
|
| 408 | - * @param mixed $data |
|
| 409 | - * @param string $group |
|
| 410 | - * @param integer $expire |
|
| 411 | - * @return boolean |
|
| 412 | - */ |
|
| 413 | - public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
| 414 | - |
|
| 415 | - if ( empty( $key ) ) { |
|
| 416 | - return false; |
|
| 417 | - } |
|
| 418 | - |
|
| 419 | - wp_cache_set( $key, $data, $group, $expire ); |
|
| 420 | - } |
|
| 421 | - |
|
| 422 | - /** |
|
| 423 | - * Retrieve query variable. |
|
| 424 | - * |
|
| 425 | - * @since 1.0.19 |
|
| 426 | - * |
|
| 427 | - * @param string $query_var Query variable key. |
|
| 428 | - * @return mixed |
|
| 429 | - */ |
|
| 430 | - public function get( $query_var ) { |
|
| 431 | - if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
| 432 | - return $this->query_vars[ $query_var ]; |
|
| 433 | - } |
|
| 434 | - |
|
| 435 | - return null; |
|
| 436 | - } |
|
| 437 | - |
|
| 438 | - /** |
|
| 439 | - * Set query variable. |
|
| 440 | - * |
|
| 441 | - * @since 1.0.19 |
|
| 442 | - * |
|
| 443 | - * @param string $query_var Query variable key. |
|
| 444 | - * @param mixed $value Query variable value. |
|
| 445 | - */ |
|
| 446 | - public function set( $query_var, $value ) { |
|
| 447 | - $this->query_vars[ $query_var ] = $value; |
|
| 448 | - } |
|
| 449 | - |
|
| 450 | - /** |
|
| 451 | - * Return the list of customers. |
|
| 452 | - * |
|
| 453 | - * @since 1.0.19 |
|
| 454 | - * |
|
| 455 | - * @return GetPaid_Customer[]|array Found customers. |
|
| 456 | - */ |
|
| 457 | - public function get_results() { |
|
| 458 | - return $this->results; |
|
| 459 | - } |
|
| 460 | - |
|
| 461 | - /** |
|
| 462 | - * Return the total number of customers for the current query. |
|
| 463 | - * |
|
| 464 | - * @since 1.0.19 |
|
| 465 | - * |
|
| 466 | - * @return int Number of total customers. |
|
| 467 | - */ |
|
| 468 | - public function get_total() { |
|
| 469 | - return $this->total_customers; |
|
| 470 | - } |
|
| 471 | - |
|
| 472 | - /** |
|
| 473 | - * Parse and sanitize 'orderby' keys passed to the customers query. |
|
| 474 | - * |
|
| 475 | - * @since 1.0.19 |
|
| 476 | - * |
|
| 477 | - * @param string $orderby Alias for the field to order by. |
|
| 478 | - * @param string $table The current table. |
|
| 479 | - * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
| 480 | - */ |
|
| 481 | - protected function parse_orderby( $orderby, $table ) { |
|
| 482 | - |
|
| 483 | - $_orderby = ''; |
|
| 484 | - if ( in_array( $orderby, array_keys( GetPaid_Customer_Data_Store::get_database_fields() ), true ) ) { |
|
| 485 | - $_orderby = "$table.`$orderby`"; |
|
| 486 | - } elseif ( 'id' === strtolower( $orderby ) ) { |
|
| 487 | - $_orderby = "$table.id"; |
|
| 488 | - } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
| 489 | - $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
| 490 | - $include_sql = implode( ',', $include ); |
|
| 491 | - $_orderby = "FIELD( $table.id, $include_sql )"; |
|
| 492 | - } |
|
| 493 | - |
|
| 494 | - return $_orderby; |
|
| 495 | - } |
|
| 496 | - |
|
| 497 | - /** |
|
| 498 | - * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
| 499 | - * |
|
| 500 | - * @since 1.0.19 |
|
| 501 | - * |
|
| 502 | - * @param string $order The 'order' query variable. |
|
| 503 | - * @return string The sanitized 'order' query variable. |
|
| 504 | - */ |
|
| 505 | - protected function parse_order( $order ) { |
|
| 506 | - if ( ! is_string( $order ) || empty( $order ) ) { |
|
| 507 | - return 'DESC'; |
|
| 508 | - } |
|
| 509 | - |
|
| 510 | - if ( 'ASC' === strtoupper( $order ) ) { |
|
| 511 | - return 'ASC'; |
|
| 512 | - } else { |
|
| 513 | - return 'DESC'; |
|
| 514 | - } |
|
| 515 | - } |
|
| 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 customers. |
|
| 29 | + * |
|
| 30 | + * @since 1.0.19 |
|
| 31 | + * @var array |
|
| 32 | + */ |
|
| 33 | + private $results; |
|
| 34 | + |
|
| 35 | + /** |
|
| 36 | + * Total number of found customers for the current query |
|
| 37 | + * |
|
| 38 | + * @since 1.0.19 |
|
| 39 | + * @var int |
|
| 40 | + */ |
|
| 41 | + private $total_customers = 0; |
|
| 42 | + |
|
| 43 | + /** |
|
| 44 | + * The SQL query used to fetch matching customers. |
|
| 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 | + 'include' => array(), |
|
| 118 | + 'exclude' => array(), |
|
| 119 | + 'orderby' => 'id', |
|
| 120 | + 'order' => 'DESC', |
|
| 121 | + 'offset' => '', |
|
| 122 | + 'number' => 10, |
|
| 123 | + 'paged' => 1, |
|
| 124 | + 'count_total' => true, |
|
| 125 | + 'fields' => 'all', |
|
| 126 | + 's' => '', |
|
| 127 | + ); |
|
| 128 | + |
|
| 129 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 130 | + $defaults[ $field ] = 'any'; |
|
| 131 | + |
|
| 132 | + if ( '%f' === $type || '%d' === $type ) { |
|
| 133 | + $defaults[ $field . '_min' ] = ''; |
|
| 134 | + $defaults[ $field . '_max' ] = ''; |
|
| 135 | + } |
|
| 136 | + } |
|
| 137 | + |
|
| 138 | + return wp_parse_args( $args, $defaults ); |
|
| 139 | + } |
|
| 140 | + |
|
| 141 | + /** |
|
| 142 | + * Prepare the query variables. |
|
| 143 | + * |
|
| 144 | + * @since 1.0.19 |
|
| 145 | + * |
|
| 146 | + * @see self::fill_query_vars() For allowede args and their defaults. |
|
| 147 | + */ |
|
| 148 | + public function prepare_query( $query = array() ) { |
|
| 149 | + global $wpdb; |
|
| 150 | + |
|
| 151 | + if ( empty( $this->query_vars ) || ! empty( $query ) ) { |
|
| 152 | + $this->query_limit = null; |
|
| 153 | + $this->query_vars = $this->fill_query_vars( $query ); |
|
| 154 | + } |
|
| 155 | + |
|
| 156 | + if ( ! empty( $this->query_vars['fields'] ) && 'all' !== $this->query_vars['fields'] ) { |
|
| 157 | + $this->query_vars['fields'] = wpinv_parse_list( $this->query_vars['fields'] ); |
|
| 158 | + } |
|
| 159 | + |
|
| 160 | + do_action( 'getpaid_pre_get_customers', array( &$this ) ); |
|
| 161 | + |
|
| 162 | + // Ensure that query vars are filled after 'getpaid_pre_get_customers'. |
|
| 163 | + $qv = & $this->query_vars; |
|
| 164 | + $qv = $this->fill_query_vars( $qv ); |
|
| 165 | + $table = $wpdb->prefix . 'getpaid_customers'; |
|
| 166 | + $this->query_from = "FROM $table"; |
|
| 167 | + |
|
| 168 | + // Prepare query fields. |
|
| 169 | + $this->prepare_query_fields( $qv, $table ); |
|
| 170 | + |
|
| 171 | + // Prepare query where. |
|
| 172 | + $this->prepare_query_where( $qv, $table ); |
|
| 173 | + |
|
| 174 | + // Prepare query order. |
|
| 175 | + $this->prepare_query_order( $qv, $table ); |
|
| 176 | + |
|
| 177 | + // limit |
|
| 178 | + if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { |
|
| 179 | + if ( $qv['offset'] ) { |
|
| 180 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); |
|
| 181 | + } else { |
|
| 182 | + $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); |
|
| 183 | + } |
|
| 184 | + } |
|
| 185 | + |
|
| 186 | + do_action_ref_array( 'getpaid_after_customers_query', array( &$this ) ); |
|
| 187 | + } |
|
| 188 | + |
|
| 189 | + /** |
|
| 190 | + * Prepares the query fields. |
|
| 191 | + * |
|
| 192 | + * @since 1.0.19 |
|
| 193 | + * |
|
| 194 | + * @param array $qv Query vars. |
|
| 195 | + * @param string $table Table name. |
|
| 196 | + */ |
|
| 197 | + protected function prepare_query_fields( &$qv, $table ) { |
|
| 198 | + |
|
| 199 | + if ( is_array( $qv['fields'] ) ) { |
|
| 200 | + $qv['fields'] = array_unique( $qv['fields'] ); |
|
| 201 | + $allowed_fields = array_keys( GetPaid_Customer_Data_Store::get_database_fields() ); |
|
| 202 | + |
|
| 203 | + $query_fields = array(); |
|
| 204 | + foreach ( $qv['fields'] as $field ) { |
|
| 205 | + if ( ! in_array( $field, $allowed_fields ) ) { |
|
| 206 | + continue; |
|
| 207 | + } |
|
| 208 | + |
|
| 209 | + $field = sanitize_key( $field ); |
|
| 210 | + $query_fields[] = "$table.`$field`"; |
|
| 211 | + } |
|
| 212 | + $this->query_fields = implode( ',', $query_fields ); |
|
| 213 | + } else { |
|
| 214 | + $this->query_fields = "$table.*"; |
|
| 215 | + } |
|
| 216 | + |
|
| 217 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 218 | + $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; |
|
| 219 | + } |
|
| 220 | + |
|
| 221 | + } |
|
| 222 | + |
|
| 223 | + /** |
|
| 224 | + * Prepares the query where. |
|
| 225 | + * |
|
| 226 | + * @since 1.0.19 |
|
| 227 | + * |
|
| 228 | + * @param array $qv Query vars. |
|
| 229 | + * @param string $table Table name. |
|
| 230 | + */ |
|
| 231 | + protected function prepare_query_where( &$qv, $table ) { |
|
| 232 | + global $wpdb; |
|
| 233 | + $this->query_where = 'WHERE 1=1'; |
|
| 234 | + |
|
| 235 | + // Fields. |
|
| 236 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 237 | + if ( 'any' !== $qv[ $field ] ) { |
|
| 238 | + |
|
| 239 | + // In. |
|
| 240 | + if ( is_array( $qv[ $field ] ) ) { |
|
| 241 | + $in = join( ',', array_fill( 0, count( $qv[ $field ] ), $type ) ); |
|
| 242 | + $this->query_where .= $wpdb->prepare( " AND $table.`status` IN ( $in )", $qv[ $field ] ); |
|
| 243 | + } elseif ( ! empty( $qv[ $field ] ) ) { |
|
| 244 | + $this->query_where .= $wpdb->prepare( " AND $table.`$field` = $type", $qv[ $field ] ); |
|
| 245 | + } |
|
| 246 | + } |
|
| 247 | + |
|
| 248 | + // Min/Max. |
|
| 249 | + if ( '%f' === $type || '%d' === $type ) { |
|
| 250 | + |
|
| 251 | + // Min. |
|
| 252 | + if ( is_numeric( $qv[ $field . '_min' ] ) ) { |
|
| 253 | + $this->query_where .= $wpdb->prepare( " AND $table.`$field` >= $type", $qv[ $field . '_min' ] ); |
|
| 254 | + } |
|
| 255 | + |
|
| 256 | + // Max. |
|
| 257 | + if ( is_numeric( $qv[ $field . '_max' ] ) ) { |
|
| 258 | + $this->query_where .= $wpdb->prepare( " AND $table.`$field` <= $type", $qv[ $field . '_max' ] ); |
|
| 259 | + } |
|
| 260 | + } |
|
| 261 | + } |
|
| 262 | + |
|
| 263 | + if ( ! empty( $qv['include'] ) ) { |
|
| 264 | + $include = implode( ',', wp_parse_id_list( $qv['include'] ) ); |
|
| 265 | + $this->query_where .= " AND $table.`id` IN ($include)"; |
|
| 266 | + } elseif ( ! empty( $qv['exclude'] ) ) { |
|
| 267 | + $exclude = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); |
|
| 268 | + $this->query_where .= " AND $table.`id` NOT IN ($exclude)"; |
|
| 269 | + } |
|
| 270 | + |
|
| 271 | + // Date queries are allowed for the customer creation date. |
|
| 272 | + if ( ! empty( $qv['date_created_query'] ) && is_array( $qv['date_created_query'] ) ) { |
|
| 273 | + $date_created_query = new WP_Date_Query( $qv['date_created_query'], "$table.date_created" ); |
|
| 274 | + $this->query_where .= $date_created_query->get_sql(); |
|
| 275 | + } |
|
| 276 | + |
|
| 277 | + // Search. |
|
| 278 | + if ( ! empty( $qv['s'] ) ) { |
|
| 279 | + $this->query_where .= $this->get_search_sql( $qv['s'] ); |
|
| 280 | + } |
|
| 281 | + } |
|
| 282 | + |
|
| 283 | + /** |
|
| 284 | + * Used internally to generate an SQL string for searching across multiple columns |
|
| 285 | + * |
|
| 286 | + * @since 1.2.7 |
|
| 287 | + * |
|
| 288 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
| 289 | + * |
|
| 290 | + * @param string $string The string to search for. |
|
| 291 | + * @return string |
|
| 292 | + */ |
|
| 293 | + protected function get_search_sql( $string ) { |
|
| 294 | + global $wpdb; |
|
| 295 | + |
|
| 296 | + $searches = array(); |
|
| 297 | + $string = trim( $string, '%' ); |
|
| 298 | + $like = '%' . $wpdb->esc_like( $string ) . '%'; |
|
| 299 | + |
|
| 300 | + foreach ( array_keys( GetPaid_Customer_Data_Store::get_database_fields() ) as $col ) { |
|
| 301 | + if ( 'id' === $col || 'user_id' === $col ) { |
|
| 302 | + $searches[] = $wpdb->prepare( "$col = %s", $string ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
| 303 | + } else { |
|
| 304 | + $searches[] = $wpdb->prepare( "$col LIKE %s", $like ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared |
|
| 305 | + } |
|
| 306 | + } |
|
| 307 | + |
|
| 308 | + return ' AND (' . implode( ' OR ', $searches ) . ')'; |
|
| 309 | + } |
|
| 310 | + |
|
| 311 | + /** |
|
| 312 | + * Prepares the query order. |
|
| 313 | + * |
|
| 314 | + * @since 1.0.19 |
|
| 315 | + * |
|
| 316 | + * @param array $qv Query vars. |
|
| 317 | + * @param string $table Table name. |
|
| 318 | + */ |
|
| 319 | + protected function prepare_query_order( &$qv, $table ) { |
|
| 320 | + |
|
| 321 | + // sorting. |
|
| 322 | + $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; |
|
| 323 | + $order = $this->parse_order( $qv['order'] ); |
|
| 324 | + |
|
| 325 | + // Default order is by 'id' (latest customers). |
|
| 326 | + if ( empty( $qv['orderby'] ) ) { |
|
| 327 | + $qv['orderby'] = array( 'id' ); |
|
| 328 | + } |
|
| 329 | + |
|
| 330 | + // 'orderby' values may be an array, comma- or space-separated list. |
|
| 331 | + $ordersby = array_filter( wpinv_parse_list( $qv['orderby'] ) ); |
|
| 332 | + |
|
| 333 | + $orderby_array = array(); |
|
| 334 | + foreach ( $ordersby as $_key => $_value ) { |
|
| 335 | + |
|
| 336 | + if ( is_int( $_key ) ) { |
|
| 337 | + // Integer key means this is a flat array of 'orderby' fields. |
|
| 338 | + $_orderby = $_value; |
|
| 339 | + $_order = $order; |
|
| 340 | + } else { |
|
| 341 | + // Non-integer key means that the key is the field and the value is ASC/DESC. |
|
| 342 | + $_orderby = $_key; |
|
| 343 | + $_order = $_value; |
|
| 344 | + } |
|
| 345 | + |
|
| 346 | + $parsed = $this->parse_orderby( $_orderby, $table ); |
|
| 347 | + |
|
| 348 | + if ( $parsed ) { |
|
| 349 | + $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); |
|
| 350 | + } |
|
| 351 | + } |
|
| 352 | + |
|
| 353 | + // If no valid clauses were found, order by id. |
|
| 354 | + if ( empty( $orderby_array ) ) { |
|
| 355 | + $orderby_array[] = "id $order"; |
|
| 356 | + } |
|
| 357 | + |
|
| 358 | + $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); |
|
| 359 | + |
|
| 360 | + } |
|
| 361 | + |
|
| 362 | + /** |
|
| 363 | + * Execute the query, with the current variables. |
|
| 364 | + * |
|
| 365 | + * @since 1.0.19 |
|
| 366 | + * |
|
| 367 | + * @global wpdb $wpdb WordPress database abstraction object. |
|
| 368 | + */ |
|
| 369 | + public function query() { |
|
| 370 | + global $wpdb; |
|
| 371 | + |
|
| 372 | + $qv =& $this->query_vars; |
|
| 373 | + |
|
| 374 | + // Return a non-null value to bypass the default GetPaid customers query and remember to set the |
|
| 375 | + // total_customers property. |
|
| 376 | + $this->results = apply_filters_ref_array( 'getpaid_customers_pre_query', array( null, &$this ) ); |
|
| 377 | + |
|
| 378 | + if ( null === $this->results ) { |
|
| 379 | + $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; |
|
| 380 | + |
|
| 381 | + if ( ( is_array( $qv['fields'] ) && 1 !== count( $qv['fields'] ) ) || 'all' === $qv['fields'] ) { |
|
| 382 | + $this->results = $wpdb->get_results( $this->request ); |
|
| 383 | + } else { |
|
| 384 | + $this->results = $wpdb->get_col( $this->request ); |
|
| 385 | + } |
|
| 386 | + |
|
| 387 | + if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { |
|
| 388 | + $found_customers_query = apply_filters( 'getpaid_found_customers_query', 'SELECT FOUND_ROWS()', $this ); |
|
| 389 | + $this->total_customers = (int) $wpdb->get_var( $found_customers_query ); |
|
| 390 | + } |
|
| 391 | + } |
|
| 392 | + |
|
| 393 | + if ( 'all' === $qv['fields'] ) { |
|
| 394 | + foreach ( $this->results as $key => $customer ) { |
|
| 395 | + $this->set_cache( $customer->id, $customer, 'getpaid_customers' ); |
|
| 396 | + $this->set_cache( $customer->user_id, $customer->id, 'getpaid_customer_ids_by_user_id' ); |
|
| 397 | + $this->set_cache( $customer->email, $customer->id, 'getpaid_customer_ids_by_email' ); |
|
| 398 | + $this->results[ $key ] = new GetPaid_Customer( $customer ); |
|
| 399 | + } |
|
| 400 | + } |
|
| 401 | + |
|
| 402 | + } |
|
| 403 | + |
|
| 404 | + /** |
|
| 405 | + * Set cache |
|
| 406 | + * |
|
| 407 | + * @param string $id |
|
| 408 | + * @param mixed $data |
|
| 409 | + * @param string $group |
|
| 410 | + * @param integer $expire |
|
| 411 | + * @return boolean |
|
| 412 | + */ |
|
| 413 | + public function set_cache( $key, $data, $group = '', $expire = 0 ) { |
|
| 414 | + |
|
| 415 | + if ( empty( $key ) ) { |
|
| 416 | + return false; |
|
| 417 | + } |
|
| 418 | + |
|
| 419 | + wp_cache_set( $key, $data, $group, $expire ); |
|
| 420 | + } |
|
| 421 | + |
|
| 422 | + /** |
|
| 423 | + * Retrieve query variable. |
|
| 424 | + * |
|
| 425 | + * @since 1.0.19 |
|
| 426 | + * |
|
| 427 | + * @param string $query_var Query variable key. |
|
| 428 | + * @return mixed |
|
| 429 | + */ |
|
| 430 | + public function get( $query_var ) { |
|
| 431 | + if ( isset( $this->query_vars[ $query_var ] ) ) { |
|
| 432 | + return $this->query_vars[ $query_var ]; |
|
| 433 | + } |
|
| 434 | + |
|
| 435 | + return null; |
|
| 436 | + } |
|
| 437 | + |
|
| 438 | + /** |
|
| 439 | + * Set query variable. |
|
| 440 | + * |
|
| 441 | + * @since 1.0.19 |
|
| 442 | + * |
|
| 443 | + * @param string $query_var Query variable key. |
|
| 444 | + * @param mixed $value Query variable value. |
|
| 445 | + */ |
|
| 446 | + public function set( $query_var, $value ) { |
|
| 447 | + $this->query_vars[ $query_var ] = $value; |
|
| 448 | + } |
|
| 449 | + |
|
| 450 | + /** |
|
| 451 | + * Return the list of customers. |
|
| 452 | + * |
|
| 453 | + * @since 1.0.19 |
|
| 454 | + * |
|
| 455 | + * @return GetPaid_Customer[]|array Found customers. |
|
| 456 | + */ |
|
| 457 | + public function get_results() { |
|
| 458 | + return $this->results; |
|
| 459 | + } |
|
| 460 | + |
|
| 461 | + /** |
|
| 462 | + * Return the total number of customers for the current query. |
|
| 463 | + * |
|
| 464 | + * @since 1.0.19 |
|
| 465 | + * |
|
| 466 | + * @return int Number of total customers. |
|
| 467 | + */ |
|
| 468 | + public function get_total() { |
|
| 469 | + return $this->total_customers; |
|
| 470 | + } |
|
| 471 | + |
|
| 472 | + /** |
|
| 473 | + * Parse and sanitize 'orderby' keys passed to the customers query. |
|
| 474 | + * |
|
| 475 | + * @since 1.0.19 |
|
| 476 | + * |
|
| 477 | + * @param string $orderby Alias for the field to order by. |
|
| 478 | + * @param string $table The current table. |
|
| 479 | + * @return string Value to use in the ORDER clause, if `$orderby` is valid. |
|
| 480 | + */ |
|
| 481 | + protected function parse_orderby( $orderby, $table ) { |
|
| 482 | + |
|
| 483 | + $_orderby = ''; |
|
| 484 | + if ( in_array( $orderby, array_keys( GetPaid_Customer_Data_Store::get_database_fields() ), true ) ) { |
|
| 485 | + $_orderby = "$table.`$orderby`"; |
|
| 486 | + } elseif ( 'id' === strtolower( $orderby ) ) { |
|
| 487 | + $_orderby = "$table.id"; |
|
| 488 | + } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { |
|
| 489 | + $include = wp_parse_id_list( $this->query_vars['include'] ); |
|
| 490 | + $include_sql = implode( ',', $include ); |
|
| 491 | + $_orderby = "FIELD( $table.id, $include_sql )"; |
|
| 492 | + } |
|
| 493 | + |
|
| 494 | + return $_orderby; |
|
| 495 | + } |
|
| 496 | + |
|
| 497 | + /** |
|
| 498 | + * Parse an 'order' query variable and cast it to ASC or DESC as necessary. |
|
| 499 | + * |
|
| 500 | + * @since 1.0.19 |
|
| 501 | + * |
|
| 502 | + * @param string $order The 'order' query variable. |
|
| 503 | + * @return string The sanitized 'order' query variable. |
|
| 504 | + */ |
|
| 505 | + protected function parse_order( $order ) { |
|
| 506 | + if ( ! is_string( $order ) || empty( $order ) ) { |
|
| 507 | + return 'DESC'; |
|
| 508 | + } |
|
| 509 | + |
|
| 510 | + if ( 'ASC' === strtoupper( $order ) ) { |
|
| 511 | + return 'ASC'; |
|
| 512 | + } else { |
|
| 513 | + return 'DESC'; |
|
| 514 | + } |
|
| 515 | + } |
|
| 516 | 516 | |
| 517 | 517 | } |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | // Load WP_List_Table if not loaded |
| 13 | 13 | if ( ! class_exists( 'WP_List_Table' ) ) { |
| 14 | - require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
| 14 | + require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; |
|
| 15 | 15 | } |
| 16 | 16 | |
| 17 | 17 | /** |
@@ -23,303 +23,303 @@ discard block |
||
| 23 | 23 | */ |
| 24 | 24 | class WPInv_Customers_Table extends WP_List_Table { |
| 25 | 25 | |
| 26 | - /** |
|
| 27 | - * @var int Number of items per page |
|
| 28 | - * @since 1.0.19 |
|
| 29 | - */ |
|
| 30 | - public $per_page = 25; |
|
| 31 | - |
|
| 32 | - /** |
|
| 33 | - * @var int Number of items |
|
| 34 | - * @since 1.0.19 |
|
| 35 | - */ |
|
| 36 | - public $total_count = 0; |
|
| 37 | - |
|
| 38 | - public $query; |
|
| 39 | - |
|
| 40 | - /** |
|
| 41 | - * Get things started |
|
| 42 | - * |
|
| 43 | - * @since 1.0.19 |
|
| 44 | - * @see WP_List_Table::__construct() |
|
| 45 | - */ |
|
| 46 | - public function __construct() { |
|
| 47 | - |
|
| 48 | - // Set parent defaults |
|
| 49 | - parent::__construct( |
|
| 26 | + /** |
|
| 27 | + * @var int Number of items per page |
|
| 28 | + * @since 1.0.19 |
|
| 29 | + */ |
|
| 30 | + public $per_page = 25; |
|
| 31 | + |
|
| 32 | + /** |
|
| 33 | + * @var int Number of items |
|
| 34 | + * @since 1.0.19 |
|
| 35 | + */ |
|
| 36 | + public $total_count = 0; |
|
| 37 | + |
|
| 38 | + public $query; |
|
| 39 | + |
|
| 40 | + /** |
|
| 41 | + * Get things started |
|
| 42 | + * |
|
| 43 | + * @since 1.0.19 |
|
| 44 | + * @see WP_List_Table::__construct() |
|
| 45 | + */ |
|
| 46 | + public function __construct() { |
|
| 47 | + |
|
| 48 | + // Set parent defaults |
|
| 49 | + parent::__construct( |
|
| 50 | 50 | array( |
| 51 | - 'singular' => 'id', |
|
| 52 | - 'plural' => 'ids', |
|
| 53 | - 'ajax' => false, |
|
| 51 | + 'singular' => 'id', |
|
| 52 | + 'plural' => 'ids', |
|
| 53 | + 'ajax' => false, |
|
| 54 | 54 | ) |
| 55 | 55 | ); |
| 56 | 56 | |
| 57 | - } |
|
| 58 | - |
|
| 59 | - /** |
|
| 60 | - * Gets the name of the primary column. |
|
| 61 | - * |
|
| 62 | - * @since 1.0.19 |
|
| 63 | - * @access protected |
|
| 64 | - * |
|
| 65 | - * @return string Name of the primary column. |
|
| 66 | - */ |
|
| 67 | - protected function get_primary_column_name() { |
|
| 68 | - return 'customer'; |
|
| 69 | - } |
|
| 70 | - |
|
| 71 | - /** |
|
| 72 | - * This function renders most of the columns in the list table. |
|
| 73 | - * |
|
| 74 | - * @since 1.0.19 |
|
| 75 | - * |
|
| 76 | - * @param GetPaid_Customer $customer |
|
| 77 | - * @param string $column_name The name of the column |
|
| 78 | - * |
|
| 79 | - * @return string Column Name |
|
| 80 | - */ |
|
| 81 | - public function column_default( $customer, $column_name ) { |
|
| 82 | - $value = esc_html( $customer->get( $column_name ) ); |
|
| 83 | - return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $customer ); |
|
| 84 | - } |
|
| 85 | - |
|
| 86 | - /** |
|
| 87 | - * Displays the country column. |
|
| 88 | - * |
|
| 89 | - * @since 1.0.19 |
|
| 90 | - * |
|
| 91 | - * @param GetPaid_Customer $customer |
|
| 92 | - * |
|
| 93 | - * @return string Column Name |
|
| 94 | - */ |
|
| 95 | - public function column_country( $customer ) { |
|
| 96 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
| 97 | - if ( $country ) { |
|
| 98 | - $country = wpinv_country_name( $country ); |
|
| 99 | - } |
|
| 100 | - return esc_html( $country ); |
|
| 101 | - } |
|
| 102 | - |
|
| 103 | - /** |
|
| 104 | - * Displays the state column. |
|
| 105 | - * |
|
| 106 | - * @since 1.0.19 |
|
| 107 | - * |
|
| 108 | - * @param GetPaid_Customer $customer |
|
| 109 | - * |
|
| 110 | - * @return string Column Name |
|
| 111 | - */ |
|
| 112 | - public function column_state( $customer ) { |
|
| 113 | - $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
| 114 | - $state = $customer->get( 'state' ); |
|
| 115 | - if ( $state ) { |
|
| 116 | - $state = wpinv_state_name( $state, $country ); |
|
| 117 | - } |
|
| 118 | - |
|
| 119 | - return esc_html( $state ); |
|
| 120 | - } |
|
| 121 | - |
|
| 122 | - /** |
|
| 123 | - * Displays the signup column. |
|
| 124 | - * |
|
| 125 | - * @since 1.0.19 |
|
| 126 | - * |
|
| 127 | - * @param GetPaid_Customer $customer |
|
| 128 | - * |
|
| 129 | - * @return string Column Name |
|
| 130 | - */ |
|
| 131 | - public function column_date_created( $customer ) { |
|
| 132 | - return getpaid_format_date_value( $customer->get( 'date_created' ) ); |
|
| 133 | - } |
|
| 134 | - |
|
| 135 | - /** |
|
| 136 | - * Displays the total spent column. |
|
| 137 | - * |
|
| 138 | - * @since 1.0.19 |
|
| 139 | - * |
|
| 140 | - * @param GetPaid_Customer $customer |
|
| 141 | - * |
|
| 142 | - * @return string Column Name |
|
| 143 | - */ |
|
| 144 | - public function column_purchase_value( $customer ) { |
|
| 145 | - return wpinv_price( (float) $customer->get( 'purchase_value' ) ); |
|
| 146 | - } |
|
| 147 | - |
|
| 148 | - /** |
|
| 149 | - * Displays the total spent column. |
|
| 150 | - * |
|
| 151 | - * @since 1.0.19 |
|
| 152 | - * |
|
| 153 | - * @param GetPaid_Customer $customer |
|
| 154 | - * |
|
| 155 | - * @return string Column Name |
|
| 156 | - */ |
|
| 157 | - public function column_purchase_count( $customer ) { |
|
| 158 | - $value = $customer->get( 'purchase_count' ); |
|
| 159 | - $url = $customer->get( 'user_id' ) ? add_query_arg( array( 'post_type' => 'wpi_invoice', 'author' => $customer->get( 'user_id' ), ), admin_url( 'edit.php' ) ) : ''; |
|
| 160 | - |
|
| 161 | - return ( empty( $value ) || empty( $url ) ) ? (int) $value : '<a href="' . esc_url( $url ) . '">' . absint( $value ) . '</a>'; |
|
| 162 | - |
|
| 163 | - } |
|
| 164 | - |
|
| 165 | - /** |
|
| 166 | - * Displays the customers name |
|
| 167 | - * |
|
| 168 | - * @param GetPaid_Customer $customer customer. |
|
| 169 | - * @return string |
|
| 170 | - */ |
|
| 171 | - public function column_customer( $customer ) { |
|
| 172 | - |
|
| 173 | - $first_name = $customer->get( 'first_name' ); |
|
| 174 | - $last_name = $customer->get( 'last_name' ); |
|
| 175 | - $email = $customer->get( 'email' ); |
|
| 176 | - $avatar = get_avatar( $customer->get( 'user_id' ) ? $customer->get( 'user_id' ) : $email, 32 ); |
|
| 177 | - |
|
| 178 | - // Customer view URL. |
|
| 179 | - $view_url = $customer->get( 'user_id' ) ? esc_url( add_query_arg( 'user_id', $customer->get( 'user_id' ), admin_url( 'user-edit.php' ) ) ) : false; |
|
| 180 | - $row_actions = $view_url ? $this->row_actions( |
|
| 181 | - array( |
|
| 182 | - 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
| 183 | - ) |
|
| 184 | - ) : ''; |
|
| 185 | - |
|
| 186 | - // Customer's name. |
|
| 187 | - $name = esc_html( trim( "$first_name $last_name" ) ); |
|
| 188 | - |
|
| 189 | - if ( ! empty( $name ) ) { |
|
| 190 | - $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
| 191 | - } |
|
| 192 | - |
|
| 193 | - $email = "<div class='row-title'><a href='mailto:$email'>$email</a></div>"; |
|
| 194 | - |
|
| 195 | - return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
| 196 | - |
|
| 197 | - } |
|
| 198 | - |
|
| 199 | - /** |
|
| 200 | - * Retrieve the current page number |
|
| 201 | - * |
|
| 202 | - * @since 1.0.19 |
|
| 203 | - * @return int Current page number |
|
| 204 | - */ |
|
| 205 | - public function get_paged() { |
|
| 206 | - return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
| 207 | - } |
|
| 208 | - |
|
| 209 | - /** |
|
| 210 | - * Returns bulk actions. |
|
| 211 | - * |
|
| 212 | - * @since 1.0.19 |
|
| 213 | - * @return void |
|
| 214 | - */ |
|
| 215 | - public function bulk_actions( $which = '' ) { |
|
| 216 | - return array(); |
|
| 217 | - } |
|
| 218 | - |
|
| 219 | - /** |
|
| 220 | - * Prepares the display query |
|
| 221 | - */ |
|
| 222 | - public function prepare_query() { |
|
| 223 | - |
|
| 224 | - // Prepare query args. |
|
| 225 | - $query = array( |
|
| 226 | - 'number' => $this->per_page, |
|
| 227 | - 'paged' => $this->get_paged(), |
|
| 228 | - ); |
|
| 229 | - |
|
| 230 | - foreach ( array( 'orderby', 'order', 's' ) as $field ) { |
|
| 231 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 232 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 233 | - } |
|
| 234 | - } |
|
| 235 | - |
|
| 236 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 237 | - |
|
| 238 | - if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 239 | - $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 240 | - } |
|
| 241 | - |
|
| 242 | - // Min max. |
|
| 243 | - if ( '%f' === $type || '%d' === $type ) { |
|
| 244 | - |
|
| 245 | - if ( isset( $_GET[ $field . '_min' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 246 | - $query[ $field . '_min' ] = floatval( $_GET[ $field . '_min' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 247 | - } |
|
| 248 | - |
|
| 249 | - if ( isset( $_GET[ $field . '_max' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 250 | - $query[ $field . '_max' ] = floatval( $_GET[ $field . '_max' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 251 | - } |
|
| 252 | - } |
|
| 253 | - } |
|
| 254 | - |
|
| 255 | - // Prepare class properties. |
|
| 256 | - $this->query = getpaid_get_customers( $query, 'query' ); |
|
| 257 | - $this->total_count = $this->query->get_total(); |
|
| 258 | - $this->items = $this->query->get_results(); |
|
| 259 | - } |
|
| 260 | - |
|
| 261 | - /** |
|
| 262 | - * Setup the final data for the table |
|
| 263 | - * |
|
| 264 | - */ |
|
| 265 | - public function prepare_items() { |
|
| 266 | - |
|
| 267 | - $columns = $this->get_columns(); |
|
| 268 | - $hidden = array(); |
|
| 269 | - $sortable = $this->get_sortable_columns(); |
|
| 270 | - $this->prepare_query(); |
|
| 271 | - |
|
| 272 | - $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
| 273 | - |
|
| 274 | - $this->set_pagination_args( |
|
| 275 | - array( |
|
| 276 | - 'total_items' => $this->total_count, |
|
| 277 | - 'per_page' => $this->per_page, |
|
| 278 | - 'total_pages' => ceil( $this->total_count / $this->per_page ), |
|
| 279 | - ) |
|
| 280 | - ); |
|
| 281 | - } |
|
| 282 | - |
|
| 283 | - /** |
|
| 284 | - * Sortable table columns. |
|
| 285 | - * |
|
| 286 | - * @return array |
|
| 287 | - */ |
|
| 288 | - public function get_sortable_columns() { |
|
| 289 | - $sortable = array( |
|
| 290 | - 'customer' => array( 'first_name', true ), |
|
| 291 | - ); |
|
| 292 | - |
|
| 293 | - foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 294 | - $sortable[ $field ] = array( $field, true ); |
|
| 295 | - } |
|
| 296 | - |
|
| 297 | - return apply_filters( 'manage_getpaid_customers_sortable_table_columns', $sortable ); |
|
| 298 | - } |
|
| 299 | - |
|
| 300 | - /** |
|
| 301 | - * Table columns |
|
| 302 | - * |
|
| 303 | - * @return array |
|
| 304 | - */ |
|
| 305 | - public function get_columns() { |
|
| 306 | - $columns = array( |
|
| 307 | - 'customer' => __( 'Customer', 'invoicing' ), |
|
| 308 | - ); |
|
| 309 | - |
|
| 310 | - // Add address fields. |
|
| 311 | - foreach ( getpaid_user_address_fields() as $key => $value ) { |
|
| 312 | - |
|
| 313 | - // Skip id, user_id and email. |
|
| 314 | - if ( ! in_array( $key, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name' ), true ) ) { |
|
| 315 | - $columns[ $key ] = $value; |
|
| 316 | - } |
|
| 317 | - } |
|
| 318 | - |
|
| 319 | - $columns['purchase_value'] = __( 'Total Spend', 'invoicing' ); |
|
| 320 | - $columns['purchase_count'] = __( 'Invoices', 'invoicing' ); |
|
| 321 | - $columns['date_created'] = __( 'Date created', 'invoicing' ); |
|
| 322 | - |
|
| 323 | - return apply_filters( 'manage_getpaid_customers_table_columns', $columns ); |
|
| 324 | - } |
|
| 57 | + } |
|
| 58 | + |
|
| 59 | + /** |
|
| 60 | + * Gets the name of the primary column. |
|
| 61 | + * |
|
| 62 | + * @since 1.0.19 |
|
| 63 | + * @access protected |
|
| 64 | + * |
|
| 65 | + * @return string Name of the primary column. |
|
| 66 | + */ |
|
| 67 | + protected function get_primary_column_name() { |
|
| 68 | + return 'customer'; |
|
| 69 | + } |
|
| 70 | + |
|
| 71 | + /** |
|
| 72 | + * This function renders most of the columns in the list table. |
|
| 73 | + * |
|
| 74 | + * @since 1.0.19 |
|
| 75 | + * |
|
| 76 | + * @param GetPaid_Customer $customer |
|
| 77 | + * @param string $column_name The name of the column |
|
| 78 | + * |
|
| 79 | + * @return string Column Name |
|
| 80 | + */ |
|
| 81 | + public function column_default( $customer, $column_name ) { |
|
| 82 | + $value = esc_html( $customer->get( $column_name ) ); |
|
| 83 | + return apply_filters( 'wpinv_customers_table_column' . $column_name, $value, $customer ); |
|
| 84 | + } |
|
| 85 | + |
|
| 86 | + /** |
|
| 87 | + * Displays the country column. |
|
| 88 | + * |
|
| 89 | + * @since 1.0.19 |
|
| 90 | + * |
|
| 91 | + * @param GetPaid_Customer $customer |
|
| 92 | + * |
|
| 93 | + * @return string Column Name |
|
| 94 | + */ |
|
| 95 | + public function column_country( $customer ) { |
|
| 96 | + $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
| 97 | + if ( $country ) { |
|
| 98 | + $country = wpinv_country_name( $country ); |
|
| 99 | + } |
|
| 100 | + return esc_html( $country ); |
|
| 101 | + } |
|
| 102 | + |
|
| 103 | + /** |
|
| 104 | + * Displays the state column. |
|
| 105 | + * |
|
| 106 | + * @since 1.0.19 |
|
| 107 | + * |
|
| 108 | + * @param GetPaid_Customer $customer |
|
| 109 | + * |
|
| 110 | + * @return string Column Name |
|
| 111 | + */ |
|
| 112 | + public function column_state( $customer ) { |
|
| 113 | + $country = wpinv_sanitize_country( $customer->get( 'country' ) ); |
|
| 114 | + $state = $customer->get( 'state' ); |
|
| 115 | + if ( $state ) { |
|
| 116 | + $state = wpinv_state_name( $state, $country ); |
|
| 117 | + } |
|
| 118 | + |
|
| 119 | + return esc_html( $state ); |
|
| 120 | + } |
|
| 121 | + |
|
| 122 | + /** |
|
| 123 | + * Displays the signup column. |
|
| 124 | + * |
|
| 125 | + * @since 1.0.19 |
|
| 126 | + * |
|
| 127 | + * @param GetPaid_Customer $customer |
|
| 128 | + * |
|
| 129 | + * @return string Column Name |
|
| 130 | + */ |
|
| 131 | + public function column_date_created( $customer ) { |
|
| 132 | + return getpaid_format_date_value( $customer->get( 'date_created' ) ); |
|
| 133 | + } |
|
| 134 | + |
|
| 135 | + /** |
|
| 136 | + * Displays the total spent column. |
|
| 137 | + * |
|
| 138 | + * @since 1.0.19 |
|
| 139 | + * |
|
| 140 | + * @param GetPaid_Customer $customer |
|
| 141 | + * |
|
| 142 | + * @return string Column Name |
|
| 143 | + */ |
|
| 144 | + public function column_purchase_value( $customer ) { |
|
| 145 | + return wpinv_price( (float) $customer->get( 'purchase_value' ) ); |
|
| 146 | + } |
|
| 147 | + |
|
| 148 | + /** |
|
| 149 | + * Displays the total spent column. |
|
| 150 | + * |
|
| 151 | + * @since 1.0.19 |
|
| 152 | + * |
|
| 153 | + * @param GetPaid_Customer $customer |
|
| 154 | + * |
|
| 155 | + * @return string Column Name |
|
| 156 | + */ |
|
| 157 | + public function column_purchase_count( $customer ) { |
|
| 158 | + $value = $customer->get( 'purchase_count' ); |
|
| 159 | + $url = $customer->get( 'user_id' ) ? add_query_arg( array( 'post_type' => 'wpi_invoice', 'author' => $customer->get( 'user_id' ), ), admin_url( 'edit.php' ) ) : ''; |
|
| 160 | + |
|
| 161 | + return ( empty( $value ) || empty( $url ) ) ? (int) $value : '<a href="' . esc_url( $url ) . '">' . absint( $value ) . '</a>'; |
|
| 162 | + |
|
| 163 | + } |
|
| 164 | + |
|
| 165 | + /** |
|
| 166 | + * Displays the customers name |
|
| 167 | + * |
|
| 168 | + * @param GetPaid_Customer $customer customer. |
|
| 169 | + * @return string |
|
| 170 | + */ |
|
| 171 | + public function column_customer( $customer ) { |
|
| 172 | + |
|
| 173 | + $first_name = $customer->get( 'first_name' ); |
|
| 174 | + $last_name = $customer->get( 'last_name' ); |
|
| 175 | + $email = $customer->get( 'email' ); |
|
| 176 | + $avatar = get_avatar( $customer->get( 'user_id' ) ? $customer->get( 'user_id' ) : $email, 32 ); |
|
| 177 | + |
|
| 178 | + // Customer view URL. |
|
| 179 | + $view_url = $customer->get( 'user_id' ) ? esc_url( add_query_arg( 'user_id', $customer->get( 'user_id' ), admin_url( 'user-edit.php' ) ) ) : false; |
|
| 180 | + $row_actions = $view_url ? $this->row_actions( |
|
| 181 | + array( |
|
| 182 | + 'view' => '<a href="' . $view_url . '#getpaid-fieldset-billing">' . __( 'Edit Details', 'invoicing' ) . '</a>', |
|
| 183 | + ) |
|
| 184 | + ) : ''; |
|
| 185 | + |
|
| 186 | + // Customer's name. |
|
| 187 | + $name = esc_html( trim( "$first_name $last_name" ) ); |
|
| 188 | + |
|
| 189 | + if ( ! empty( $name ) ) { |
|
| 190 | + $name = "<div style='overflow: hidden;height: 18px;'>$name</div>"; |
|
| 191 | + } |
|
| 192 | + |
|
| 193 | + $email = "<div class='row-title'><a href='mailto:$email'>$email</a></div>"; |
|
| 194 | + |
|
| 195 | + return "<div style='display: flex;'><div>$avatar</div><div style='margin-left: 10px;'>$name<strong>$email</strong>$row_actions</div></div>"; |
|
| 196 | + |
|
| 197 | + } |
|
| 198 | + |
|
| 199 | + /** |
|
| 200 | + * Retrieve the current page number |
|
| 201 | + * |
|
| 202 | + * @since 1.0.19 |
|
| 203 | + * @return int Current page number |
|
| 204 | + */ |
|
| 205 | + public function get_paged() { |
|
| 206 | + return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; |
|
| 207 | + } |
|
| 208 | + |
|
| 209 | + /** |
|
| 210 | + * Returns bulk actions. |
|
| 211 | + * |
|
| 212 | + * @since 1.0.19 |
|
| 213 | + * @return void |
|
| 214 | + */ |
|
| 215 | + public function bulk_actions( $which = '' ) { |
|
| 216 | + return array(); |
|
| 217 | + } |
|
| 218 | + |
|
| 219 | + /** |
|
| 220 | + * Prepares the display query |
|
| 221 | + */ |
|
| 222 | + public function prepare_query() { |
|
| 223 | + |
|
| 224 | + // Prepare query args. |
|
| 225 | + $query = array( |
|
| 226 | + 'number' => $this->per_page, |
|
| 227 | + 'paged' => $this->get_paged(), |
|
| 228 | + ); |
|
| 229 | + |
|
| 230 | + foreach ( array( 'orderby', 'order', 's' ) as $field ) { |
|
| 231 | + if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 232 | + $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 233 | + } |
|
| 234 | + } |
|
| 235 | + |
|
| 236 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 237 | + |
|
| 238 | + if ( isset( $_GET[ $field ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 239 | + $query[ $field ] = wpinv_clean( rawurlencode_deep( $_GET[ $field ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 240 | + } |
|
| 241 | + |
|
| 242 | + // Min max. |
|
| 243 | + if ( '%f' === $type || '%d' === $type ) { |
|
| 244 | + |
|
| 245 | + if ( isset( $_GET[ $field . '_min' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 246 | + $query[ $field . '_min' ] = floatval( $_GET[ $field . '_min' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 247 | + } |
|
| 248 | + |
|
| 249 | + if ( isset( $_GET[ $field . '_max' ] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 250 | + $query[ $field . '_max' ] = floatval( $_GET[ $field . '_max' ] ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended |
|
| 251 | + } |
|
| 252 | + } |
|
| 253 | + } |
|
| 254 | + |
|
| 255 | + // Prepare class properties. |
|
| 256 | + $this->query = getpaid_get_customers( $query, 'query' ); |
|
| 257 | + $this->total_count = $this->query->get_total(); |
|
| 258 | + $this->items = $this->query->get_results(); |
|
| 259 | + } |
|
| 260 | + |
|
| 261 | + /** |
|
| 262 | + * Setup the final data for the table |
|
| 263 | + * |
|
| 264 | + */ |
|
| 265 | + public function prepare_items() { |
|
| 266 | + |
|
| 267 | + $columns = $this->get_columns(); |
|
| 268 | + $hidden = array(); |
|
| 269 | + $sortable = $this->get_sortable_columns(); |
|
| 270 | + $this->prepare_query(); |
|
| 271 | + |
|
| 272 | + $this->_column_headers = array( $columns, $hidden, $sortable ); |
|
| 273 | + |
|
| 274 | + $this->set_pagination_args( |
|
| 275 | + array( |
|
| 276 | + 'total_items' => $this->total_count, |
|
| 277 | + 'per_page' => $this->per_page, |
|
| 278 | + 'total_pages' => ceil( $this->total_count / $this->per_page ), |
|
| 279 | + ) |
|
| 280 | + ); |
|
| 281 | + } |
|
| 282 | + |
|
| 283 | + /** |
|
| 284 | + * Sortable table columns. |
|
| 285 | + * |
|
| 286 | + * @return array |
|
| 287 | + */ |
|
| 288 | + public function get_sortable_columns() { |
|
| 289 | + $sortable = array( |
|
| 290 | + 'customer' => array( 'first_name', true ), |
|
| 291 | + ); |
|
| 292 | + |
|
| 293 | + foreach ( GetPaid_Customer_Data_Store::get_database_fields() as $field => $type ) { |
|
| 294 | + $sortable[ $field ] = array( $field, true ); |
|
| 295 | + } |
|
| 296 | + |
|
| 297 | + return apply_filters( 'manage_getpaid_customers_sortable_table_columns', $sortable ); |
|
| 298 | + } |
|
| 299 | + |
|
| 300 | + /** |
|
| 301 | + * Table columns |
|
| 302 | + * |
|
| 303 | + * @return array |
|
| 304 | + */ |
|
| 305 | + public function get_columns() { |
|
| 306 | + $columns = array( |
|
| 307 | + 'customer' => __( 'Customer', 'invoicing' ), |
|
| 308 | + ); |
|
| 309 | + |
|
| 310 | + // Add address fields. |
|
| 311 | + foreach ( getpaid_user_address_fields() as $key => $value ) { |
|
| 312 | + |
|
| 313 | + // Skip id, user_id and email. |
|
| 314 | + if ( ! in_array( $key, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid', 'first_name', 'last_name' ), true ) ) { |
|
| 315 | + $columns[ $key ] = $value; |
|
| 316 | + } |
|
| 317 | + } |
|
| 318 | + |
|
| 319 | + $columns['purchase_value'] = __( 'Total Spend', 'invoicing' ); |
|
| 320 | + $columns['purchase_count'] = __( 'Invoices', 'invoicing' ); |
|
| 321 | + $columns['date_created'] = __( 'Date created', 'invoicing' ); |
|
| 322 | + |
|
| 323 | + return apply_filters( 'manage_getpaid_customers_table_columns', $columns ); |
|
| 324 | + } |
|
| 325 | 325 | } |
@@ -67,7 +67,7 @@ discard block |
||
| 67 | 67 | * Checks if the current user cna view an invoice receipt. |
| 68 | 68 | */ |
| 69 | 69 | function wpinv_can_view_receipt( $invoice ) { |
| 70 | - return (bool) apply_filters( 'wpinv_can_view_receipt', wpinv_user_can_view_invoice( $invoice ), $invoice ); |
|
| 70 | + return (bool) apply_filters( 'wpinv_can_view_receipt', wpinv_user_can_view_invoice( $invoice ), $invoice ); |
|
| 71 | 71 | } |
| 72 | 72 | |
| 73 | 73 | /** |
@@ -556,37 +556,37 @@ discard block |
||
| 556 | 556 | $label = empty( $label ) ? __( 'Invoice', 'invoicing' ) : sanitize_text_field( $label ); |
| 557 | 557 | $columns = array( |
| 558 | 558 | |
| 559 | - 'invoice-number' => array( |
|
| 560 | - 'title' => $label, |
|
| 561 | - 'class' => 'text-left', |
|
| 562 | - ), |
|
| 559 | + 'invoice-number' => array( |
|
| 560 | + 'title' => $label, |
|
| 561 | + 'class' => 'text-left', |
|
| 562 | + ), |
|
| 563 | 563 | |
| 564 | - 'created-date' => array( |
|
| 565 | - 'title' => __( 'Created Date', 'invoicing' ), |
|
| 566 | - 'class' => 'text-left', |
|
| 567 | - ), |
|
| 564 | + 'created-date' => array( |
|
| 565 | + 'title' => __( 'Created Date', 'invoicing' ), |
|
| 566 | + 'class' => 'text-left', |
|
| 567 | + ), |
|
| 568 | 568 | |
| 569 | - 'payment-date' => array( |
|
| 570 | - 'title' => __( 'Payment Date', 'invoicing' ), |
|
| 571 | - 'class' => 'text-left', |
|
| 572 | - ), |
|
| 569 | + 'payment-date' => array( |
|
| 570 | + 'title' => __( 'Payment Date', 'invoicing' ), |
|
| 571 | + 'class' => 'text-left', |
|
| 572 | + ), |
|
| 573 | 573 | |
| 574 | - 'invoice-status' => array( |
|
| 575 | - 'title' => __( 'Status', 'invoicing' ), |
|
| 576 | - 'class' => 'text-center', |
|
| 577 | - ), |
|
| 574 | + 'invoice-status' => array( |
|
| 575 | + 'title' => __( 'Status', 'invoicing' ), |
|
| 576 | + 'class' => 'text-center', |
|
| 577 | + ), |
|
| 578 | 578 | |
| 579 | - 'invoice-total' => array( |
|
| 580 | - 'title' => __( 'Total', 'invoicing' ), |
|
| 581 | - 'class' => 'text-right', |
|
| 582 | - ), |
|
| 579 | + 'invoice-total' => array( |
|
| 580 | + 'title' => __( 'Total', 'invoicing' ), |
|
| 581 | + 'class' => 'text-right', |
|
| 582 | + ), |
|
| 583 | 583 | |
| 584 | - 'invoice-actions' => array( |
|
| 585 | - 'title' => ' ', |
|
| 586 | - 'class' => 'text-center', |
|
| 587 | - ), |
|
| 584 | + 'invoice-actions' => array( |
|
| 585 | + 'title' => ' ', |
|
| 586 | + 'class' => 'text-center', |
|
| 587 | + ), |
|
| 588 | 588 | |
| 589 | - ); |
|
| 589 | + ); |
|
| 590 | 590 | |
| 591 | 591 | return apply_filters( 'wpinv_user_invoices_columns', $columns, $post_type ); |
| 592 | 592 | } |
@@ -1297,22 +1297,22 @@ discard block |
||
| 1297 | 1297 | */ |
| 1298 | 1298 | function getpaid_get_invoice_status_classes() { |
| 1299 | 1299 | |
| 1300 | - return apply_filters( |
|
| 1301 | - 'getpaid_get_invoice_status_classes', |
|
| 1302 | - array( |
|
| 1300 | + return apply_filters( |
|
| 1301 | + 'getpaid_get_invoice_status_classes', |
|
| 1302 | + array( |
|
| 1303 | 1303 | 'wpi-quote-declined' => 'bg-danger', |
| 1304 | 1304 | 'wpi-failed' => 'bg-danger', |
| 1305 | - 'wpi-processing' => 'bg-info', |
|
| 1306 | - 'wpi-onhold' => 'bg-warning text-dark', |
|
| 1307 | - 'wpi-quote-accepted' => 'bg-success', |
|
| 1308 | - 'publish' => 'bg-success', |
|
| 1309 | - 'wpi-renewal' => 'bg-primary', |
|
| 1305 | + 'wpi-processing' => 'bg-info', |
|
| 1306 | + 'wpi-onhold' => 'bg-warning text-dark', |
|
| 1307 | + 'wpi-quote-accepted' => 'bg-success', |
|
| 1308 | + 'publish' => 'bg-success', |
|
| 1309 | + 'wpi-renewal' => 'bg-primary', |
|
| 1310 | 1310 | 'wpi-cancelled' => 'bg-secondary', |
| 1311 | 1311 | 'wpi-pending' => 'bg-dark text-white', |
| 1312 | 1312 | 'wpi-quote-pending' => 'bg-dark text-white', |
| 1313 | 1313 | 'wpi-refunded' => 'bg-secondary', |
| 1314 | - ) |
|
| 1315 | - ); |
|
| 1314 | + ) |
|
| 1315 | + ); |
|
| 1316 | 1316 | |
| 1317 | 1317 | } |
| 1318 | 1318 | |
@@ -1326,7 +1326,7 @@ discard block |
||
| 1326 | 1326 | function getpaid_get_invoice_tax_rate( $invoice, $item ) { |
| 1327 | 1327 | |
| 1328 | 1328 | $rates = getpaid_get_item_tax_rates( $item, $invoice->get_country(), $invoice->get_state() ); |
| 1329 | - $rates = getpaid_filter_item_tax_rates( $item, $rates ); |
|
| 1329 | + $rates = getpaid_filter_item_tax_rates( $item, $rates ); |
|
| 1330 | 1330 | $rates = wp_list_pluck( $rates, 'rate' ); |
| 1331 | 1331 | |
| 1332 | 1332 | return array_sum( $rates ); |
@@ -20,411 +20,411 @@ discard block |
||
| 20 | 20 | */ |
| 21 | 21 | class GetPaid_Installer { |
| 22 | 22 | |
| 23 | - private static $schema = null; |
|
| 24 | - private static $schema_version = null; |
|
| 25 | - |
|
| 26 | - /** |
|
| 27 | - * Upgrades the install. |
|
| 28 | - * |
|
| 29 | - * @param string $upgrade_from The current invoicing version. |
|
| 30 | - */ |
|
| 31 | - public function upgrade_db( $upgrade_from ) { |
|
| 32 | - |
|
| 33 | - // Save the current invoicing version. |
|
| 34 | - update_option( 'wpinv_version', WPINV_VERSION ); |
|
| 35 | - |
|
| 36 | - // Setup the invoice Custom Post Type. |
|
| 37 | - GetPaid_Post_Types::register_post_types(); |
|
| 38 | - |
|
| 39 | - // Clear the permalinks |
|
| 40 | - flush_rewrite_rules(); |
|
| 41 | - |
|
| 42 | - // Maybe create new/missing pages. |
|
| 43 | - $this->create_pages(); |
|
| 44 | - |
|
| 45 | - // Maybe re(add) admin capabilities. |
|
| 46 | - $this->add_capabilities(); |
|
| 47 | - |
|
| 48 | - // Maybe create the default payment form. |
|
| 49 | - wpinv_get_default_payment_form(); |
|
| 50 | - |
|
| 51 | - // Create any missing database tables. |
|
| 52 | - $method = "upgrade_from_$upgrade_from"; |
|
| 53 | - |
|
| 54 | - $installed = get_option( 'gepaid_installed_on' ); |
|
| 55 | - |
|
| 56 | - if ( empty( $installed ) ) { |
|
| 57 | - update_option( 'gepaid_installed_on', time() ); |
|
| 58 | - } |
|
| 59 | - |
|
| 60 | - if ( method_exists( $this, $method ) ) { |
|
| 61 | - $this->$method(); |
|
| 62 | - } |
|
| 63 | - |
|
| 64 | - } |
|
| 65 | - |
|
| 66 | - /** |
|
| 67 | - * Do a fresh install. |
|
| 68 | - * |
|
| 69 | - */ |
|
| 70 | - public function upgrade_from_0() { |
|
| 71 | - |
|
| 72 | - // Save default tax rates. |
|
| 73 | - update_option( 'wpinv_tax_rates', wpinv_get_data( 'tax-rates' ) ); |
|
| 74 | - } |
|
| 75 | - |
|
| 76 | - /** |
|
| 77 | - * Upgrade to 0.0.5 |
|
| 78 | - * |
|
| 79 | - */ |
|
| 80 | - public function upgrade_from_004() { |
|
| 81 | - global $wpdb; |
|
| 82 | - |
|
| 83 | - // Invoices. |
|
| 84 | - $results = $wpdb->get_results( "SELECT ID FROM {$wpdb->posts} WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
| 85 | - if ( ! empty( $results ) ) { |
|
| 86 | - $wpdb->query( "UPDATE {$wpdb->posts} SET post_status = CONCAT( 'wpi-', post_status ) WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
| 87 | - |
|
| 88 | - // Clean post cache |
|
| 89 | - foreach ( $results as $row ) { |
|
| 90 | - clean_post_cache( $row->ID ); |
|
| 91 | - } |
|
| 92 | - } |
|
| 93 | - |
|
| 94 | - // Item meta key changes |
|
| 95 | - $query = 'SELECT DISTINCT post_id FROM ' . $wpdb->postmeta . " WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id', '_wpinv_cpt_name', '_wpinv_cpt_singular_name' )"; |
|
| 96 | - $results = $wpdb->get_results( $query ); |
|
| 97 | - |
|
| 98 | - if ( ! empty( $results ) ) { |
|
| 99 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" ); |
|
| 100 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" ); |
|
| 101 | - $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" ); |
|
| 102 | - |
|
| 103 | - foreach ( $results as $row ) { |
|
| 104 | - clean_post_cache( $row->post_id ); |
|
| 105 | - } |
|
| 106 | - } |
|
| 107 | - |
|
| 108 | - $this->upgrade_from_118(); |
|
| 109 | - } |
|
| 110 | - |
|
| 111 | - /** |
|
| 112 | - * Upgrade to version 2.0.0. |
|
| 113 | - * |
|
| 114 | - */ |
|
| 115 | - public function upgrade_from_118() { |
|
| 116 | - $this->migrate_old_invoices(); |
|
| 117 | - $this->upgrade_from_279(); |
|
| 118 | - } |
|
| 119 | - |
|
| 120 | - /** |
|
| 121 | - * Upgrade to version 2.0.0. |
|
| 122 | - * |
|
| 123 | - */ |
|
| 124 | - public function upgrade_from_279() { |
|
| 125 | - self::migrate_old_customers(); |
|
| 126 | - } |
|
| 127 | - |
|
| 128 | - /** |
|
| 129 | - * Give administrators the capability to manage GetPaid. |
|
| 130 | - * |
|
| 131 | - */ |
|
| 132 | - public function add_capabilities() { |
|
| 133 | - $GLOBALS['wp_roles']->add_cap( 'administrator', 'manage_invoicing' ); |
|
| 134 | - } |
|
| 135 | - |
|
| 136 | - /** |
|
| 137 | - * Retreives GetPaid pages. |
|
| 138 | - * |
|
| 139 | - */ |
|
| 140 | - public static function get_pages() { |
|
| 141 | - |
|
| 142 | - return apply_filters( |
|
| 143 | - 'wpinv_create_pages', |
|
| 144 | - array( |
|
| 145 | - |
|
| 146 | - // Checkout page. |
|
| 147 | - 'checkout_page' => array( |
|
| 148 | - 'name' => _x( 'gp-checkout', 'Page slug', 'invoicing' ), |
|
| 149 | - 'title' => _x( 'Checkout', 'Page title', 'invoicing' ), |
|
| 150 | - 'content' => ' |
|
| 23 | + private static $schema = null; |
|
| 24 | + private static $schema_version = null; |
|
| 25 | + |
|
| 26 | + /** |
|
| 27 | + * Upgrades the install. |
|
| 28 | + * |
|
| 29 | + * @param string $upgrade_from The current invoicing version. |
|
| 30 | + */ |
|
| 31 | + public function upgrade_db( $upgrade_from ) { |
|
| 32 | + |
|
| 33 | + // Save the current invoicing version. |
|
| 34 | + update_option( 'wpinv_version', WPINV_VERSION ); |
|
| 35 | + |
|
| 36 | + // Setup the invoice Custom Post Type. |
|
| 37 | + GetPaid_Post_Types::register_post_types(); |
|
| 38 | + |
|
| 39 | + // Clear the permalinks |
|
| 40 | + flush_rewrite_rules(); |
|
| 41 | + |
|
| 42 | + // Maybe create new/missing pages. |
|
| 43 | + $this->create_pages(); |
|
| 44 | + |
|
| 45 | + // Maybe re(add) admin capabilities. |
|
| 46 | + $this->add_capabilities(); |
|
| 47 | + |
|
| 48 | + // Maybe create the default payment form. |
|
| 49 | + wpinv_get_default_payment_form(); |
|
| 50 | + |
|
| 51 | + // Create any missing database tables. |
|
| 52 | + $method = "upgrade_from_$upgrade_from"; |
|
| 53 | + |
|
| 54 | + $installed = get_option( 'gepaid_installed_on' ); |
|
| 55 | + |
|
| 56 | + if ( empty( $installed ) ) { |
|
| 57 | + update_option( 'gepaid_installed_on', time() ); |
|
| 58 | + } |
|
| 59 | + |
|
| 60 | + if ( method_exists( $this, $method ) ) { |
|
| 61 | + $this->$method(); |
|
| 62 | + } |
|
| 63 | + |
|
| 64 | + } |
|
| 65 | + |
|
| 66 | + /** |
|
| 67 | + * Do a fresh install. |
|
| 68 | + * |
|
| 69 | + */ |
|
| 70 | + public function upgrade_from_0() { |
|
| 71 | + |
|
| 72 | + // Save default tax rates. |
|
| 73 | + update_option( 'wpinv_tax_rates', wpinv_get_data( 'tax-rates' ) ); |
|
| 74 | + } |
|
| 75 | + |
|
| 76 | + /** |
|
| 77 | + * Upgrade to 0.0.5 |
|
| 78 | + * |
|
| 79 | + */ |
|
| 80 | + public function upgrade_from_004() { |
|
| 81 | + global $wpdb; |
|
| 82 | + |
|
| 83 | + // Invoices. |
|
| 84 | + $results = $wpdb->get_results( "SELECT ID FROM {$wpdb->posts} WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
| 85 | + if ( ! empty( $results ) ) { |
|
| 86 | + $wpdb->query( "UPDATE {$wpdb->posts} SET post_status = CONCAT( 'wpi-', post_status ) WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" ); |
|
| 87 | + |
|
| 88 | + // Clean post cache |
|
| 89 | + foreach ( $results as $row ) { |
|
| 90 | + clean_post_cache( $row->ID ); |
|
| 91 | + } |
|
| 92 | + } |
|
| 93 | + |
|
| 94 | + // Item meta key changes |
|
| 95 | + $query = 'SELECT DISTINCT post_id FROM ' . $wpdb->postmeta . " WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id', '_wpinv_cpt_name', '_wpinv_cpt_singular_name' )"; |
|
| 96 | + $results = $wpdb->get_results( $query ); |
|
| 97 | + |
|
| 98 | + if ( ! empty( $results ) ) { |
|
| 99 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" ); |
|
| 100 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" ); |
|
| 101 | + $wpdb->query( 'UPDATE ' . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" ); |
|
| 102 | + |
|
| 103 | + foreach ( $results as $row ) { |
|
| 104 | + clean_post_cache( $row->post_id ); |
|
| 105 | + } |
|
| 106 | + } |
|
| 107 | + |
|
| 108 | + $this->upgrade_from_118(); |
|
| 109 | + } |
|
| 110 | + |
|
| 111 | + /** |
|
| 112 | + * Upgrade to version 2.0.0. |
|
| 113 | + * |
|
| 114 | + */ |
|
| 115 | + public function upgrade_from_118() { |
|
| 116 | + $this->migrate_old_invoices(); |
|
| 117 | + $this->upgrade_from_279(); |
|
| 118 | + } |
|
| 119 | + |
|
| 120 | + /** |
|
| 121 | + * Upgrade to version 2.0.0. |
|
| 122 | + * |
|
| 123 | + */ |
|
| 124 | + public function upgrade_from_279() { |
|
| 125 | + self::migrate_old_customers(); |
|
| 126 | + } |
|
| 127 | + |
|
| 128 | + /** |
|
| 129 | + * Give administrators the capability to manage GetPaid. |
|
| 130 | + * |
|
| 131 | + */ |
|
| 132 | + public function add_capabilities() { |
|
| 133 | + $GLOBALS['wp_roles']->add_cap( 'administrator', 'manage_invoicing' ); |
|
| 134 | + } |
|
| 135 | + |
|
| 136 | + /** |
|
| 137 | + * Retreives GetPaid pages. |
|
| 138 | + * |
|
| 139 | + */ |
|
| 140 | + public static function get_pages() { |
|
| 141 | + |
|
| 142 | + return apply_filters( |
|
| 143 | + 'wpinv_create_pages', |
|
| 144 | + array( |
|
| 145 | + |
|
| 146 | + // Checkout page. |
|
| 147 | + 'checkout_page' => array( |
|
| 148 | + 'name' => _x( 'gp-checkout', 'Page slug', 'invoicing' ), |
|
| 149 | + 'title' => _x( 'Checkout', 'Page title', 'invoicing' ), |
|
| 150 | + 'content' => ' |
|
| 151 | 151 | <!-- wp:shortcode --> |
| 152 | 152 | [wpinv_checkout] |
| 153 | 153 | <!-- /wp:shortcode --> |
| 154 | 154 | ', |
| 155 | - 'parent' => '', |
|
| 156 | - ), |
|
| 157 | - |
|
| 158 | - // Invoice history page. |
|
| 159 | - 'invoice_history_page' => array( |
|
| 160 | - 'name' => _x( 'gp-invoices', 'Page slug', 'invoicing' ), |
|
| 161 | - 'title' => _x( 'My Invoices', 'Page title', 'invoicing' ), |
|
| 162 | - 'content' => ' |
|
| 155 | + 'parent' => '', |
|
| 156 | + ), |
|
| 157 | + |
|
| 158 | + // Invoice history page. |
|
| 159 | + 'invoice_history_page' => array( |
|
| 160 | + 'name' => _x( 'gp-invoices', 'Page slug', 'invoicing' ), |
|
| 161 | + 'title' => _x( 'My Invoices', 'Page title', 'invoicing' ), |
|
| 162 | + 'content' => ' |
|
| 163 | 163 | <!-- wp:shortcode --> |
| 164 | 164 | [wpinv_history] |
| 165 | 165 | <!-- /wp:shortcode --> |
| 166 | 166 | ', |
| 167 | - 'parent' => '', |
|
| 168 | - ), |
|
| 169 | - |
|
| 170 | - // Success page content. |
|
| 171 | - 'success_page' => array( |
|
| 172 | - 'name' => _x( 'gp-receipt', 'Page slug', 'invoicing' ), |
|
| 173 | - 'title' => _x( 'Payment Confirmation', 'Page title', 'invoicing' ), |
|
| 174 | - 'content' => ' |
|
| 167 | + 'parent' => '', |
|
| 168 | + ), |
|
| 169 | + |
|
| 170 | + // Success page content. |
|
| 171 | + 'success_page' => array( |
|
| 172 | + 'name' => _x( 'gp-receipt', 'Page slug', 'invoicing' ), |
|
| 173 | + 'title' => _x( 'Payment Confirmation', 'Page title', 'invoicing' ), |
|
| 174 | + 'content' => ' |
|
| 175 | 175 | <!-- wp:shortcode --> |
| 176 | 176 | [wpinv_receipt] |
| 177 | 177 | <!-- /wp:shortcode --> |
| 178 | 178 | ', |
| 179 | - 'parent' => 'gp-checkout', |
|
| 180 | - ), |
|
| 181 | - |
|
| 182 | - // Failure page content. |
|
| 183 | - 'failure_page' => array( |
|
| 184 | - 'name' => _x( 'gp-transaction-failed', 'Page slug', 'invoicing' ), |
|
| 185 | - 'title' => _x( 'Transaction Failed', 'Page title', 'invoicing' ), |
|
| 186 | - 'content' => __( 'Your transaction failed, please try again or contact site support.', 'invoicing' ), |
|
| 187 | - 'parent' => 'gp-checkout', |
|
| 188 | - ), |
|
| 189 | - |
|
| 190 | - // Subscriptions history page. |
|
| 191 | - 'invoice_subscription_page' => array( |
|
| 192 | - 'name' => _x( 'gp-subscriptions', 'Page slug', 'invoicing' ), |
|
| 193 | - 'title' => _x( 'My Subscriptions', 'Page title', 'invoicing' ), |
|
| 194 | - 'content' => ' |
|
| 179 | + 'parent' => 'gp-checkout', |
|
| 180 | + ), |
|
| 181 | + |
|
| 182 | + // Failure page content. |
|
| 183 | + 'failure_page' => array( |
|
| 184 | + 'name' => _x( 'gp-transaction-failed', 'Page slug', 'invoicing' ), |
|
| 185 | + 'title' => _x( 'Transaction Failed', 'Page title', 'invoicing' ), |
|
| 186 | + 'content' => __( 'Your transaction failed, please try again or contact site support.', 'invoicing' ), |
|
| 187 | + 'parent' => 'gp-checkout', |
|
| 188 | + ), |
|
| 189 | + |
|
| 190 | + // Subscriptions history page. |
|
| 191 | + 'invoice_subscription_page' => array( |
|
| 192 | + 'name' => _x( 'gp-subscriptions', 'Page slug', 'invoicing' ), |
|
| 193 | + 'title' => _x( 'My Subscriptions', 'Page title', 'invoicing' ), |
|
| 194 | + 'content' => ' |
|
| 195 | 195 | <!-- wp:shortcode --> |
| 196 | 196 | [wpinv_subscriptions] |
| 197 | 197 | <!-- /wp:shortcode --> |
| 198 | 198 | ', |
| 199 | - 'parent' => '', |
|
| 200 | - ), |
|
| 201 | - |
|
| 202 | - ) |
|
| 203 | - ); |
|
| 204 | - |
|
| 205 | - } |
|
| 206 | - |
|
| 207 | - /** |
|
| 208 | - * Re-create GetPaid pages. |
|
| 209 | - * |
|
| 210 | - */ |
|
| 211 | - public function create_pages() { |
|
| 212 | - |
|
| 213 | - foreach ( self::get_pages() as $key => $page ) { |
|
| 214 | - wpinv_create_page( esc_sql( $page['name'] ), $key, $page['title'], $page['content'], $page['parent'] ); |
|
| 215 | - } |
|
| 216 | - |
|
| 217 | - } |
|
| 218 | - |
|
| 219 | - /** |
|
| 220 | - * Migrates old invoices to new invoices. |
|
| 221 | - * |
|
| 222 | - */ |
|
| 223 | - public function migrate_old_invoices() { |
|
| 224 | - global $wpdb; |
|
| 225 | - |
|
| 226 | - $invoices_table = $wpdb->prefix . 'getpaid_invoices'; |
|
| 227 | - $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items'; |
|
| 228 | - $migrated = $wpdb->get_col( "SELECT post_id FROM $invoices_table" ); |
|
| 229 | - $invoices = array_unique( |
|
| 230 | - get_posts( |
|
| 231 | - array( |
|
| 232 | - 'post_type' => array( 'wpi_invoice', 'wpi_quote' ), |
|
| 233 | - 'posts_per_page' => -1, |
|
| 234 | - 'fields' => 'ids', |
|
| 235 | - 'post_status' => array_keys( get_post_stati() ), |
|
| 236 | - 'exclude' => (array) $migrated, |
|
| 237 | - ) |
|
| 238 | - ) |
|
| 239 | - ); |
|
| 240 | - |
|
| 241 | - // Abort if we do not have any invoices. |
|
| 242 | - if ( empty( $invoices ) ) { |
|
| 243 | - return; |
|
| 244 | - } |
|
| 245 | - |
|
| 246 | - require_once WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php'; |
|
| 247 | - |
|
| 248 | - $invoice_rows = array(); |
|
| 249 | - foreach ( $invoices as $invoice ) { |
|
| 250 | - |
|
| 251 | - $invoice = new WPInv_Legacy_Invoice( $invoice ); |
|
| 252 | - |
|
| 253 | - if ( empty( $invoice->ID ) ) { |
|
| 254 | - return; |
|
| 255 | - } |
|
| 256 | - |
|
| 257 | - $fields = array( |
|
| 258 | - 'post_id' => $invoice->ID, |
|
| 259 | - 'number' => $invoice->get_number(), |
|
| 260 | - 'key' => $invoice->get_key(), |
|
| 261 | - 'type' => str_replace( 'wpi_', '', $invoice->post_type ), |
|
| 262 | - 'mode' => $invoice->mode, |
|
| 263 | - 'user_ip' => $invoice->get_ip(), |
|
| 264 | - 'first_name' => $invoice->get_first_name(), |
|
| 265 | - 'last_name' => $invoice->get_last_name(), |
|
| 266 | - 'address' => $invoice->get_address(), |
|
| 267 | - 'city' => $invoice->city, |
|
| 268 | - 'state' => $invoice->state, |
|
| 269 | - 'country' => $invoice->country, |
|
| 270 | - 'zip' => $invoice->zip, |
|
| 271 | - 'adddress_confirmed' => (int) $invoice->adddress_confirmed, |
|
| 272 | - 'gateway' => $invoice->get_gateway(), |
|
| 273 | - 'transaction_id' => $invoice->get_transaction_id(), |
|
| 274 | - 'currency' => $invoice->get_currency(), |
|
| 275 | - 'subtotal' => $invoice->get_subtotal(), |
|
| 276 | - 'tax' => $invoice->get_tax(), |
|
| 277 | - 'fees_total' => $invoice->get_fees_total(), |
|
| 278 | - 'total' => $invoice->get_total(), |
|
| 279 | - 'discount' => $invoice->get_discount(), |
|
| 280 | - 'discount_code' => $invoice->get_discount_code(), |
|
| 281 | - 'disable_taxes' => $invoice->disable_taxes, |
|
| 282 | - 'due_date' => $invoice->get_due_date(), |
|
| 283 | - 'completed_date' => $invoice->get_completed_date(), |
|
| 284 | - 'company' => $invoice->company, |
|
| 285 | - 'vat_number' => $invoice->vat_number, |
|
| 286 | - 'vat_rate' => $invoice->vat_rate, |
|
| 287 | - 'custom_meta' => $invoice->payment_meta, |
|
| 288 | - ); |
|
| 289 | - |
|
| 290 | - foreach ( $fields as $key => $val ) { |
|
| 291 | - if ( is_null( $val ) ) { |
|
| 292 | - $val = ''; |
|
| 293 | - } |
|
| 294 | - $val = maybe_serialize( $val ); |
|
| 295 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
| 296 | - } |
|
| 297 | - |
|
| 298 | - $fields = implode( ', ', $fields ); |
|
| 299 | - $invoice_rows[] = "($fields)"; |
|
| 300 | - |
|
| 301 | - $item_rows = array(); |
|
| 302 | - $item_columns = array(); |
|
| 303 | - foreach ( $invoice->get_cart_details() as $details ) { |
|
| 304 | - $fields = array( |
|
| 305 | - 'post_id' => $invoice->ID, |
|
| 306 | - 'item_id' => $details['id'], |
|
| 307 | - 'item_name' => $details['name'], |
|
| 308 | - 'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'], |
|
| 309 | - 'vat_rate' => $details['vat_rate'], |
|
| 310 | - 'vat_class' => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'], |
|
| 311 | - 'tax' => $details['tax'], |
|
| 312 | - 'item_price' => $details['item_price'], |
|
| 313 | - 'custom_price' => $details['custom_price'], |
|
| 314 | - 'quantity' => $details['quantity'], |
|
| 315 | - 'discount' => $details['discount'], |
|
| 316 | - 'subtotal' => $details['subtotal'], |
|
| 317 | - 'price' => $details['price'], |
|
| 318 | - 'meta' => $details['meta'], |
|
| 319 | - 'fees' => $details['fees'], |
|
| 320 | - ); |
|
| 321 | - |
|
| 322 | - $item_columns = array_keys( $fields ); |
|
| 323 | - |
|
| 324 | - foreach ( $fields as $key => $val ) { |
|
| 325 | - if ( is_null( $val ) ) { |
|
| 326 | - $val = ''; |
|
| 327 | - } |
|
| 328 | - $val = maybe_serialize( $val ); |
|
| 329 | - $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
| 330 | - } |
|
| 331 | - |
|
| 332 | - $fields = implode( ', ', $fields ); |
|
| 333 | - $item_rows[] = "($fields)"; |
|
| 334 | - } |
|
| 335 | - |
|
| 336 | - $item_rows = implode( ', ', $item_rows ); |
|
| 337 | - $item_columns = implode( ', ', $item_columns ); |
|
| 338 | - $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" ); |
|
| 339 | - } |
|
| 340 | - |
|
| 341 | - if ( empty( $invoice_rows ) ) { |
|
| 342 | - return; |
|
| 343 | - } |
|
| 344 | - |
|
| 345 | - $invoice_rows = implode( ', ', $invoice_rows ); |
|
| 346 | - $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" ); |
|
| 347 | - |
|
| 348 | - } |
|
| 349 | - |
|
| 350 | - /** |
|
| 351 | - * Migrates old customers to new table. |
|
| 352 | - * |
|
| 353 | - */ |
|
| 354 | - public static function migrate_old_customers() { |
|
| 355 | - global $wpdb; |
|
| 356 | - |
|
| 357 | - // Fetch post_id from $wpdb->prefix . 'getpaid_invoices' where customer_id = 0 or null. |
|
| 358 | - $invoice_ids = $wpdb->get_col( "SELECT post_id FROM {$wpdb->prefix}getpaid_invoices WHERE customer_id = 0 OR customer_id IS NULL" ); |
|
| 359 | - |
|
| 360 | - foreach ( $invoice_ids as $invoice_id ) { |
|
| 361 | - $invoice = wpinv_get_invoice( $invoice_id ); |
|
| 362 | - |
|
| 363 | - if ( empty( $invoice ) ) { |
|
| 364 | - continue; |
|
| 365 | - } |
|
| 366 | - |
|
| 367 | - // Fetch customer from the user ID. |
|
| 368 | - $user_id = $invoice->get_user_id(); |
|
| 369 | - |
|
| 370 | - if ( empty( $user_id ) ) { |
|
| 371 | - continue; |
|
| 372 | - } |
|
| 373 | - |
|
| 374 | - $customer = getpaid_get_customer_by_user_id( $user_id ); |
|
| 375 | - |
|
| 376 | - // Create if not exists. |
|
| 377 | - if ( empty( $customer ) ) { |
|
| 378 | - $customer = new GetPaid_Customer( 0 ); |
|
| 379 | - $customer->clone_user( $user_id ); |
|
| 380 | - $customer->save(); |
|
| 381 | - } |
|
| 382 | - |
|
| 383 | - $invoice->set_customer_id( $customer->get_id() ); |
|
| 384 | - $invoice->save(); |
|
| 385 | - } |
|
| 386 | - |
|
| 387 | - } |
|
| 388 | - |
|
| 389 | - /** |
|
| 390 | - * Migrates old invoices to new invoices. |
|
| 391 | - * |
|
| 392 | - */ |
|
| 393 | - public static function rename_gateways_label() { |
|
| 394 | - global $wpdb; |
|
| 395 | - |
|
| 396 | - foreach ( array_keys( wpinv_get_payment_gateways() ) as $gateway ) { |
|
| 397 | - |
|
| 398 | - $wpdb->update( |
|
| 399 | - $wpdb->prefix . 'getpaid_invoices', |
|
| 400 | - array( 'gateway' => $gateway ), |
|
| 401 | - array( 'gateway' => wpinv_get_gateway_admin_label( $gateway ) ), |
|
| 402 | - '%s', |
|
| 403 | - '%s' |
|
| 404 | - ); |
|
| 405 | - |
|
| 406 | - } |
|
| 407 | - } |
|
| 408 | - |
|
| 409 | - /** |
|
| 410 | - * Returns the DB schema. |
|
| 411 | - * |
|
| 412 | - */ |
|
| 413 | - public static function get_db_schema() { |
|
| 414 | - global $wpdb; |
|
| 415 | - |
|
| 416 | - if ( ! empty( self::$schema ) ) { |
|
| 417 | - return self::$schema; |
|
| 418 | - } |
|
| 199 | + 'parent' => '', |
|
| 200 | + ), |
|
| 201 | + |
|
| 202 | + ) |
|
| 203 | + ); |
|
| 204 | + |
|
| 205 | + } |
|
| 206 | + |
|
| 207 | + /** |
|
| 208 | + * Re-create GetPaid pages. |
|
| 209 | + * |
|
| 210 | + */ |
|
| 211 | + public function create_pages() { |
|
| 212 | + |
|
| 213 | + foreach ( self::get_pages() as $key => $page ) { |
|
| 214 | + wpinv_create_page( esc_sql( $page['name'] ), $key, $page['title'], $page['content'], $page['parent'] ); |
|
| 215 | + } |
|
| 216 | + |
|
| 217 | + } |
|
| 218 | + |
|
| 219 | + /** |
|
| 220 | + * Migrates old invoices to new invoices. |
|
| 221 | + * |
|
| 222 | + */ |
|
| 223 | + public function migrate_old_invoices() { |
|
| 224 | + global $wpdb; |
|
| 225 | + |
|
| 226 | + $invoices_table = $wpdb->prefix . 'getpaid_invoices'; |
|
| 227 | + $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items'; |
|
| 228 | + $migrated = $wpdb->get_col( "SELECT post_id FROM $invoices_table" ); |
|
| 229 | + $invoices = array_unique( |
|
| 230 | + get_posts( |
|
| 231 | + array( |
|
| 232 | + 'post_type' => array( 'wpi_invoice', 'wpi_quote' ), |
|
| 233 | + 'posts_per_page' => -1, |
|
| 234 | + 'fields' => 'ids', |
|
| 235 | + 'post_status' => array_keys( get_post_stati() ), |
|
| 236 | + 'exclude' => (array) $migrated, |
|
| 237 | + ) |
|
| 238 | + ) |
|
| 239 | + ); |
|
| 240 | + |
|
| 241 | + // Abort if we do not have any invoices. |
|
| 242 | + if ( empty( $invoices ) ) { |
|
| 243 | + return; |
|
| 244 | + } |
|
| 245 | + |
|
| 246 | + require_once WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php'; |
|
| 247 | + |
|
| 248 | + $invoice_rows = array(); |
|
| 249 | + foreach ( $invoices as $invoice ) { |
|
| 250 | + |
|
| 251 | + $invoice = new WPInv_Legacy_Invoice( $invoice ); |
|
| 252 | + |
|
| 253 | + if ( empty( $invoice->ID ) ) { |
|
| 254 | + return; |
|
| 255 | + } |
|
| 256 | + |
|
| 257 | + $fields = array( |
|
| 258 | + 'post_id' => $invoice->ID, |
|
| 259 | + 'number' => $invoice->get_number(), |
|
| 260 | + 'key' => $invoice->get_key(), |
|
| 261 | + 'type' => str_replace( 'wpi_', '', $invoice->post_type ), |
|
| 262 | + 'mode' => $invoice->mode, |
|
| 263 | + 'user_ip' => $invoice->get_ip(), |
|
| 264 | + 'first_name' => $invoice->get_first_name(), |
|
| 265 | + 'last_name' => $invoice->get_last_name(), |
|
| 266 | + 'address' => $invoice->get_address(), |
|
| 267 | + 'city' => $invoice->city, |
|
| 268 | + 'state' => $invoice->state, |
|
| 269 | + 'country' => $invoice->country, |
|
| 270 | + 'zip' => $invoice->zip, |
|
| 271 | + 'adddress_confirmed' => (int) $invoice->adddress_confirmed, |
|
| 272 | + 'gateway' => $invoice->get_gateway(), |
|
| 273 | + 'transaction_id' => $invoice->get_transaction_id(), |
|
| 274 | + 'currency' => $invoice->get_currency(), |
|
| 275 | + 'subtotal' => $invoice->get_subtotal(), |
|
| 276 | + 'tax' => $invoice->get_tax(), |
|
| 277 | + 'fees_total' => $invoice->get_fees_total(), |
|
| 278 | + 'total' => $invoice->get_total(), |
|
| 279 | + 'discount' => $invoice->get_discount(), |
|
| 280 | + 'discount_code' => $invoice->get_discount_code(), |
|
| 281 | + 'disable_taxes' => $invoice->disable_taxes, |
|
| 282 | + 'due_date' => $invoice->get_due_date(), |
|
| 283 | + 'completed_date' => $invoice->get_completed_date(), |
|
| 284 | + 'company' => $invoice->company, |
|
| 285 | + 'vat_number' => $invoice->vat_number, |
|
| 286 | + 'vat_rate' => $invoice->vat_rate, |
|
| 287 | + 'custom_meta' => $invoice->payment_meta, |
|
| 288 | + ); |
|
| 289 | + |
|
| 290 | + foreach ( $fields as $key => $val ) { |
|
| 291 | + if ( is_null( $val ) ) { |
|
| 292 | + $val = ''; |
|
| 293 | + } |
|
| 294 | + $val = maybe_serialize( $val ); |
|
| 295 | + $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
| 296 | + } |
|
| 297 | + |
|
| 298 | + $fields = implode( ', ', $fields ); |
|
| 299 | + $invoice_rows[] = "($fields)"; |
|
| 300 | + |
|
| 301 | + $item_rows = array(); |
|
| 302 | + $item_columns = array(); |
|
| 303 | + foreach ( $invoice->get_cart_details() as $details ) { |
|
| 304 | + $fields = array( |
|
| 305 | + 'post_id' => $invoice->ID, |
|
| 306 | + 'item_id' => $details['id'], |
|
| 307 | + 'item_name' => $details['name'], |
|
| 308 | + 'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'], |
|
| 309 | + 'vat_rate' => $details['vat_rate'], |
|
| 310 | + 'vat_class' => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'], |
|
| 311 | + 'tax' => $details['tax'], |
|
| 312 | + 'item_price' => $details['item_price'], |
|
| 313 | + 'custom_price' => $details['custom_price'], |
|
| 314 | + 'quantity' => $details['quantity'], |
|
| 315 | + 'discount' => $details['discount'], |
|
| 316 | + 'subtotal' => $details['subtotal'], |
|
| 317 | + 'price' => $details['price'], |
|
| 318 | + 'meta' => $details['meta'], |
|
| 319 | + 'fees' => $details['fees'], |
|
| 320 | + ); |
|
| 321 | + |
|
| 322 | + $item_columns = array_keys( $fields ); |
|
| 323 | + |
|
| 324 | + foreach ( $fields as $key => $val ) { |
|
| 325 | + if ( is_null( $val ) ) { |
|
| 326 | + $val = ''; |
|
| 327 | + } |
|
| 328 | + $val = maybe_serialize( $val ); |
|
| 329 | + $fields[ $key ] = $wpdb->prepare( '%s', $val ); |
|
| 330 | + } |
|
| 331 | + |
|
| 332 | + $fields = implode( ', ', $fields ); |
|
| 333 | + $item_rows[] = "($fields)"; |
|
| 334 | + } |
|
| 335 | + |
|
| 336 | + $item_rows = implode( ', ', $item_rows ); |
|
| 337 | + $item_columns = implode( ', ', $item_columns ); |
|
| 338 | + $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" ); |
|
| 339 | + } |
|
| 340 | + |
|
| 341 | + if ( empty( $invoice_rows ) ) { |
|
| 342 | + return; |
|
| 343 | + } |
|
| 344 | + |
|
| 345 | + $invoice_rows = implode( ', ', $invoice_rows ); |
|
| 346 | + $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" ); |
|
| 347 | + |
|
| 348 | + } |
|
| 349 | + |
|
| 350 | + /** |
|
| 351 | + * Migrates old customers to new table. |
|
| 352 | + * |
|
| 353 | + */ |
|
| 354 | + public static function migrate_old_customers() { |
|
| 355 | + global $wpdb; |
|
| 356 | + |
|
| 357 | + // Fetch post_id from $wpdb->prefix . 'getpaid_invoices' where customer_id = 0 or null. |
|
| 358 | + $invoice_ids = $wpdb->get_col( "SELECT post_id FROM {$wpdb->prefix}getpaid_invoices WHERE customer_id = 0 OR customer_id IS NULL" ); |
|
| 359 | + |
|
| 360 | + foreach ( $invoice_ids as $invoice_id ) { |
|
| 361 | + $invoice = wpinv_get_invoice( $invoice_id ); |
|
| 362 | + |
|
| 363 | + if ( empty( $invoice ) ) { |
|
| 364 | + continue; |
|
| 365 | + } |
|
| 366 | + |
|
| 367 | + // Fetch customer from the user ID. |
|
| 368 | + $user_id = $invoice->get_user_id(); |
|
| 369 | + |
|
| 370 | + if ( empty( $user_id ) ) { |
|
| 371 | + continue; |
|
| 372 | + } |
|
| 373 | + |
|
| 374 | + $customer = getpaid_get_customer_by_user_id( $user_id ); |
|
| 375 | + |
|
| 376 | + // Create if not exists. |
|
| 377 | + if ( empty( $customer ) ) { |
|
| 378 | + $customer = new GetPaid_Customer( 0 ); |
|
| 379 | + $customer->clone_user( $user_id ); |
|
| 380 | + $customer->save(); |
|
| 381 | + } |
|
| 382 | + |
|
| 383 | + $invoice->set_customer_id( $customer->get_id() ); |
|
| 384 | + $invoice->save(); |
|
| 385 | + } |
|
| 386 | + |
|
| 387 | + } |
|
| 388 | + |
|
| 389 | + /** |
|
| 390 | + * Migrates old invoices to new invoices. |
|
| 391 | + * |
|
| 392 | + */ |
|
| 393 | + public static function rename_gateways_label() { |
|
| 394 | + global $wpdb; |
|
| 395 | + |
|
| 396 | + foreach ( array_keys( wpinv_get_payment_gateways() ) as $gateway ) { |
|
| 397 | + |
|
| 398 | + $wpdb->update( |
|
| 399 | + $wpdb->prefix . 'getpaid_invoices', |
|
| 400 | + array( 'gateway' => $gateway ), |
|
| 401 | + array( 'gateway' => wpinv_get_gateway_admin_label( $gateway ) ), |
|
| 402 | + '%s', |
|
| 403 | + '%s' |
|
| 404 | + ); |
|
| 405 | + |
|
| 406 | + } |
|
| 407 | + } |
|
| 408 | + |
|
| 409 | + /** |
|
| 410 | + * Returns the DB schema. |
|
| 411 | + * |
|
| 412 | + */ |
|
| 413 | + public static function get_db_schema() { |
|
| 414 | + global $wpdb; |
|
| 415 | + |
|
| 416 | + if ( ! empty( self::$schema ) ) { |
|
| 417 | + return self::$schema; |
|
| 418 | + } |
|
| 419 | 419 | |
| 420 | - require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
| 420 | + require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
| 421 | 421 | |
| 422 | - $charset_collate = $wpdb->get_charset_collate(); |
|
| 422 | + $charset_collate = $wpdb->get_charset_collate(); |
|
| 423 | 423 | |
| 424 | - $schema = array(); |
|
| 424 | + $schema = array(); |
|
| 425 | 425 | |
| 426 | - // Subscriptions. |
|
| 427 | - $schema['subscriptions'] = "CREATE TABLE {$wpdb->prefix}wpinv_subscriptions ( |
|
| 426 | + // Subscriptions. |
|
| 427 | + $schema['subscriptions'] = "CREATE TABLE {$wpdb->prefix}wpinv_subscriptions ( |
|
| 428 | 428 | id bigint(20) unsigned NOT NULL auto_increment, |
| 429 | 429 | customer_id bigint(20) NOT NULL, |
| 430 | 430 | frequency int(11) NOT NULL DEFAULT '1', |
@@ -447,8 +447,8 @@ discard block |
||
| 447 | 447 | KEY customer_and_status (customer_id, status) |
| 448 | 448 | ) $charset_collate;"; |
| 449 | 449 | |
| 450 | - // Invoices. |
|
| 451 | - $schema['invoices'] = "CREATE TABLE {$wpdb->prefix}getpaid_invoices ( |
|
| 450 | + // Invoices. |
|
| 451 | + $schema['invoices'] = "CREATE TABLE {$wpdb->prefix}getpaid_invoices ( |
|
| 452 | 452 | post_id BIGINT(20) NOT NULL, |
| 453 | 453 | customer_id BIGINT(20) NOT NULL DEFAULT 0, |
| 454 | 454 | `number` VARCHAR(100), |
@@ -485,8 +485,8 @@ discard block |
||
| 485 | 485 | KEY invoice_key (invoice_key) |
| 486 | 486 | ) $charset_collate;"; |
| 487 | 487 | |
| 488 | - // Invoice items. |
|
| 489 | - $schema['items'] = "CREATE TABLE {$wpdb->prefix}getpaid_invoice_items ( |
|
| 488 | + // Invoice items. |
|
| 489 | + $schema['items'] = "CREATE TABLE {$wpdb->prefix}getpaid_invoice_items ( |
|
| 490 | 490 | ID BIGINT(20) NOT NULL AUTO_INCREMENT, |
| 491 | 491 | post_id BIGINT(20) NOT NULL, |
| 492 | 492 | item_id BIGINT(20) NOT NULL, |
@@ -508,8 +508,8 @@ discard block |
||
| 508 | 508 | KEY post_id (post_id) |
| 509 | 509 | ) $charset_collate;"; |
| 510 | 510 | |
| 511 | - // Customers. |
|
| 512 | - $schema['customers'] = "CREATE TABLE {$wpdb->prefix}getpaid_customers ( |
|
| 511 | + // Customers. |
|
| 512 | + $schema['customers'] = "CREATE TABLE {$wpdb->prefix}getpaid_customers ( |
|
| 513 | 513 | id BIGINT(20) NOT NULL AUTO_INCREMENT, |
| 514 | 514 | user_id BIGINT(20) NOT NULL, |
| 515 | 515 | email VARCHAR(100) NOT NULL, |
@@ -519,38 +519,38 @@ discard block |
||
| 519 | 519 | purchase_count BIGINT(20) NOT NULL DEFAULT 0, |
| 520 | 520 | "; |
| 521 | 521 | |
| 522 | - // Add address fields. |
|
| 523 | - foreach ( array_keys( getpaid_user_address_fields( true ) ) as $field ) { |
|
| 524 | - // Skip id, user_id and email. |
|
| 525 | - if ( in_array( $field, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid' ), true ) ) { |
|
| 526 | - continue; |
|
| 527 | - } |
|
| 528 | - |
|
| 529 | - $field = sanitize_key( $field ); |
|
| 530 | - $length = 100; |
|
| 531 | - $default = ''; |
|
| 532 | - |
|
| 533 | - // Country. |
|
| 534 | - if ( 'country' === $field ) { |
|
| 535 | - $length = 2; |
|
| 536 | - $default = wpinv_get_default_country(); |
|
| 537 | - } |
|
| 538 | - |
|
| 539 | - // State. |
|
| 540 | - if ( 'state' === $field ) { |
|
| 541 | - $default = wpinv_get_default_state(); |
|
| 542 | - } |
|
| 543 | - |
|
| 544 | - // Phone, zip. |
|
| 545 | - if ( in_array( $field, array( 'phone', 'zip' ), true ) ) { |
|
| 546 | - $length = 20; |
|
| 547 | - } |
|
| 548 | - |
|
| 549 | - $schema['customers'] .= "`$field` VARCHAR($length) NOT NULL DEFAULT '$default', |
|
| 522 | + // Add address fields. |
|
| 523 | + foreach ( array_keys( getpaid_user_address_fields( true ) ) as $field ) { |
|
| 524 | + // Skip id, user_id and email. |
|
| 525 | + if ( in_array( $field, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid' ), true ) ) { |
|
| 526 | + continue; |
|
| 527 | + } |
|
| 528 | + |
|
| 529 | + $field = sanitize_key( $field ); |
|
| 530 | + $length = 100; |
|
| 531 | + $default = ''; |
|
| 532 | + |
|
| 533 | + // Country. |
|
| 534 | + if ( 'country' === $field ) { |
|
| 535 | + $length = 2; |
|
| 536 | + $default = wpinv_get_default_country(); |
|
| 537 | + } |
|
| 538 | + |
|
| 539 | + // State. |
|
| 540 | + if ( 'state' === $field ) { |
|
| 541 | + $default = wpinv_get_default_state(); |
|
| 542 | + } |
|
| 543 | + |
|
| 544 | + // Phone, zip. |
|
| 545 | + if ( in_array( $field, array( 'phone', 'zip' ), true ) ) { |
|
| 546 | + $length = 20; |
|
| 547 | + } |
|
| 548 | + |
|
| 549 | + $schema['customers'] .= "`$field` VARCHAR($length) NOT NULL DEFAULT '$default', |
|
| 550 | 550 | "; |
| 551 | - } |
|
| 551 | + } |
|
| 552 | 552 | |
| 553 | - $schema['customers'] .= "date_created DATETIME NOT NULL, |
|
| 553 | + $schema['customers'] .= "date_created DATETIME NOT NULL, |
|
| 554 | 554 | date_modified DATETIME NOT NULL, |
| 555 | 555 | uuid VARCHAR(100) NOT NULL, |
| 556 | 556 | PRIMARY KEY (id), |
@@ -558,8 +558,8 @@ discard block |
||
| 558 | 558 | KEY email (email) |
| 559 | 559 | ) $charset_collate;"; |
| 560 | 560 | |
| 561 | - // Customer meta. |
|
| 562 | - $schema['customer_meta'] = "CREATE TABLE {$wpdb->prefix}getpaid_customer_meta ( |
|
| 561 | + // Customer meta. |
|
| 562 | + $schema['customer_meta'] = "CREATE TABLE {$wpdb->prefix}getpaid_customer_meta ( |
|
| 563 | 563 | meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, |
| 564 | 564 | customer_id BIGINT(20) NOT NULL, |
| 565 | 565 | meta_key VARCHAR(255) NOT NULL, |
@@ -569,75 +569,75 @@ discard block |
||
| 569 | 569 | KEY meta_key (meta_key(191)) |
| 570 | 570 | ) $charset_collate;"; |
| 571 | 571 | |
| 572 | - // Filter. |
|
| 573 | - $schema = apply_filters( 'getpaid_db_schema', $schema ); |
|
| 574 | - |
|
| 575 | - self::$schema = implode( "\n", array_values( $schema ) ); |
|
| 576 | - self::$schema_version = md5( sanitize_key( self::$schema ) ); |
|
| 577 | - |
|
| 578 | - return self::$schema; |
|
| 579 | - } |
|
| 580 | - |
|
| 581 | - /** |
|
| 582 | - * Returns the DB schema version. |
|
| 583 | - * |
|
| 584 | - */ |
|
| 585 | - public static function get_db_schema_version() { |
|
| 586 | - if ( ! empty( self::$schema_version ) ) { |
|
| 587 | - return self::$schema_version; |
|
| 588 | - } |
|
| 589 | - |
|
| 590 | - self::get_db_schema(); |
|
| 591 | - |
|
| 592 | - return self::$schema_version; |
|
| 593 | - } |
|
| 594 | - |
|
| 595 | - /** |
|
| 596 | - * Checks if the db schema is up to date. |
|
| 597 | - * |
|
| 598 | - * @return bool |
|
| 599 | - */ |
|
| 600 | - public static function is_db_schema_up_to_date() { |
|
| 601 | - return self::get_db_schema_version() === get_option( 'getpaid_db_schema' ); |
|
| 602 | - } |
|
| 603 | - |
|
| 604 | - /** |
|
| 605 | - * Set up the database tables which the plugin needs to function. |
|
| 606 | - */ |
|
| 607 | - public static function create_db_tables() { |
|
| 608 | - global $wpdb; |
|
| 609 | - |
|
| 610 | - $wpdb->hide_errors(); |
|
| 611 | - |
|
| 612 | - require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
| 613 | - |
|
| 614 | - $schema = self::get_db_schema(); |
|
| 615 | - |
|
| 616 | - // If invoices table exists, rename key to invoice_key. |
|
| 617 | - $invoices_table = "{$wpdb->prefix}getpaid_invoices"; |
|
| 618 | - |
|
| 619 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}getpaid_invoices'" ) === $invoices_table ) { |
|
| 620 | - $fields = $wpdb->get_results( "SHOW COLUMNS FROM {$wpdb->prefix}getpaid_invoices" ); |
|
| 621 | - |
|
| 622 | - foreach ( $fields as $field ) { |
|
| 623 | - if ( 'key' === $field->Field ) { |
|
| 624 | - $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoices CHANGE `key` `invoice_key` VARCHAR(100)" ); |
|
| 625 | - break; |
|
| 626 | - } |
|
| 627 | - } |
|
| 628 | - } |
|
| 629 | - |
|
| 630 | - dbDelta( $schema ); |
|
| 631 | - wp_cache_flush(); |
|
| 632 | - update_option( 'getpaid_db_schema', self::get_db_schema_version() ); |
|
| 633 | - } |
|
| 634 | - |
|
| 635 | - /** |
|
| 636 | - * Creates tables if schema is not up to date. |
|
| 637 | - */ |
|
| 638 | - public static function maybe_create_db_tables() { |
|
| 639 | - if ( ! self::is_db_schema_up_to_date() ) { |
|
| 640 | - self::create_db_tables(); |
|
| 641 | - } |
|
| 642 | - } |
|
| 572 | + // Filter. |
|
| 573 | + $schema = apply_filters( 'getpaid_db_schema', $schema ); |
|
| 574 | + |
|
| 575 | + self::$schema = implode( "\n", array_values( $schema ) ); |
|
| 576 | + self::$schema_version = md5( sanitize_key( self::$schema ) ); |
|
| 577 | + |
|
| 578 | + return self::$schema; |
|
| 579 | + } |
|
| 580 | + |
|
| 581 | + /** |
|
| 582 | + * Returns the DB schema version. |
|
| 583 | + * |
|
| 584 | + */ |
|
| 585 | + public static function get_db_schema_version() { |
|
| 586 | + if ( ! empty( self::$schema_version ) ) { |
|
| 587 | + return self::$schema_version; |
|
| 588 | + } |
|
| 589 | + |
|
| 590 | + self::get_db_schema(); |
|
| 591 | + |
|
| 592 | + return self::$schema_version; |
|
| 593 | + } |
|
| 594 | + |
|
| 595 | + /** |
|
| 596 | + * Checks if the db schema is up to date. |
|
| 597 | + * |
|
| 598 | + * @return bool |
|
| 599 | + */ |
|
| 600 | + public static function is_db_schema_up_to_date() { |
|
| 601 | + return self::get_db_schema_version() === get_option( 'getpaid_db_schema' ); |
|
| 602 | + } |
|
| 603 | + |
|
| 604 | + /** |
|
| 605 | + * Set up the database tables which the plugin needs to function. |
|
| 606 | + */ |
|
| 607 | + public static function create_db_tables() { |
|
| 608 | + global $wpdb; |
|
| 609 | + |
|
| 610 | + $wpdb->hide_errors(); |
|
| 611 | + |
|
| 612 | + require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
|
| 613 | + |
|
| 614 | + $schema = self::get_db_schema(); |
|
| 615 | + |
|
| 616 | + // If invoices table exists, rename key to invoice_key. |
|
| 617 | + $invoices_table = "{$wpdb->prefix}getpaid_invoices"; |
|
| 618 | + |
|
| 619 | + if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}getpaid_invoices'" ) === $invoices_table ) { |
|
| 620 | + $fields = $wpdb->get_results( "SHOW COLUMNS FROM {$wpdb->prefix}getpaid_invoices" ); |
|
| 621 | + |
|
| 622 | + foreach ( $fields as $field ) { |
|
| 623 | + if ( 'key' === $field->Field ) { |
|
| 624 | + $wpdb->query( "ALTER TABLE {$wpdb->prefix}getpaid_invoices CHANGE `key` `invoice_key` VARCHAR(100)" ); |
|
| 625 | + break; |
|
| 626 | + } |
|
| 627 | + } |
|
| 628 | + } |
|
| 629 | + |
|
| 630 | + dbDelta( $schema ); |
|
| 631 | + wp_cache_flush(); |
|
| 632 | + update_option( 'getpaid_db_schema', self::get_db_schema_version() ); |
|
| 633 | + } |
|
| 634 | + |
|
| 635 | + /** |
|
| 636 | + * Creates tables if schema is not up to date. |
|
| 637 | + */ |
|
| 638 | + public static function maybe_create_db_tables() { |
|
| 639 | + if ( ! self::is_db_schema_up_to_date() ) { |
|
| 640 | + self::create_db_tables(); |
|
| 641 | + } |
|
| 642 | + } |
|
| 643 | 643 | } |
@@ -13,325 +13,325 @@ |
||
| 13 | 13 | class GetPaid_Subscription_Notification_Emails { |
| 14 | 14 | |
| 15 | 15 | /** |
| 16 | - * The array of subscription email actions. |
|
| 17 | - * |
|
| 18 | - * @param array |
|
| 19 | - */ |
|
| 20 | - public $subscription_actions; |
|
| 16 | + * The array of subscription email actions. |
|
| 17 | + * |
|
| 18 | + * @param array |
|
| 19 | + */ |
|
| 20 | + public $subscription_actions; |
|
| 21 | 21 | |
| 22 | 22 | /** |
| 23 | - * Class constructor |
|
| 23 | + * Class constructor |
|
| 24 | 24 | * |
| 25 | - */ |
|
| 26 | - public function __construct() { |
|
| 27 | - |
|
| 28 | - $this->subscription_actions = apply_filters( |
|
| 29 | - 'getpaid_notification_email_subscription_triggers', |
|
| 30 | - array( |
|
| 31 | - 'getpaid_subscription_active' => 'subscription_active', |
|
| 32 | - 'getpaid_subscription_trialling' => 'subscription_trial', |
|
| 33 | - 'getpaid_subscription_cancelled' => 'subscription_cancelled', |
|
| 34 | - 'getpaid_subscription_expired' => 'subscription_expired', |
|
| 35 | - 'getpaid_subscription_completed' => 'subscription_complete', |
|
| 36 | - 'getpaid_daily_maintenance' => 'renewal_reminder' |
|
| 37 | - ) |
|
| 38 | - ); |
|
| 39 | - |
|
| 40 | - $this->init_hooks(); |
|
| 25 | + */ |
|
| 26 | + public function __construct() { |
|
| 27 | + |
|
| 28 | + $this->subscription_actions = apply_filters( |
|
| 29 | + 'getpaid_notification_email_subscription_triggers', |
|
| 30 | + array( |
|
| 31 | + 'getpaid_subscription_active' => 'subscription_active', |
|
| 32 | + 'getpaid_subscription_trialling' => 'subscription_trial', |
|
| 33 | + 'getpaid_subscription_cancelled' => 'subscription_cancelled', |
|
| 34 | + 'getpaid_subscription_expired' => 'subscription_expired', |
|
| 35 | + 'getpaid_subscription_completed' => 'subscription_complete', |
|
| 36 | + 'getpaid_daily_maintenance' => 'renewal_reminder' |
|
| 37 | + ) |
|
| 38 | + ); |
|
| 39 | + |
|
| 40 | + $this->init_hooks(); |
|
| 41 | 41 | |
| 42 | 42 | } |
| 43 | 43 | |
| 44 | 44 | /** |
| 45 | - * Registers email hooks. |
|
| 46 | - */ |
|
| 47 | - public function init_hooks() { |
|
| 48 | - |
|
| 49 | - add_filter( 'getpaid_get_email_merge_tags', array( $this, 'subscription_merge_tags' ), 10, 2 ); |
|
| 50 | - foreach ( $this->subscription_actions as $hook => $email_type ) { |
|
| 51 | - |
|
| 52 | - $email = new GetPaid_Notification_Email( $email_type ); |
|
| 53 | - |
|
| 54 | - if ( ! $email->is_active() ) { |
|
| 55 | - continue; |
|
| 56 | - } |
|
| 57 | - |
|
| 58 | - if ( method_exists( $this, $email_type ) ) { |
|
| 59 | - add_action( $hook, array( $this, $email_type ), 100, 2 ); |
|
| 60 | - continue; |
|
| 61 | - } |
|
| 62 | - |
|
| 63 | - do_action( 'getpaid_subscription_notification_email_register_hook', $email_type, $hook ); |
|
| 64 | - |
|
| 65 | - } |
|
| 66 | - |
|
| 67 | - } |
|
| 68 | - |
|
| 69 | - /** |
|
| 70 | - * Filters subscription merge tags. |
|
| 71 | - * |
|
| 72 | - * @param array $merge_tags |
|
| 73 | - * @param mixed|WPInv_Invoice|WPInv_Subscription $object |
|
| 74 | - */ |
|
| 75 | - public function subscription_merge_tags( $merge_tags, $object ) { |
|
| 76 | - |
|
| 77 | - if ( is_a( $object, 'WPInv_Subscription' ) ) { |
|
| 78 | - $merge_tags = array_merge( |
|
| 79 | - $merge_tags, |
|
| 80 | - $this->get_subscription_merge_tags( $object ) |
|
| 81 | - ); |
|
| 82 | - } |
|
| 83 | - |
|
| 84 | - return $merge_tags; |
|
| 85 | - |
|
| 86 | - } |
|
| 87 | - |
|
| 88 | - /** |
|
| 89 | - * Generates subscription merge tags. |
|
| 90 | - * |
|
| 91 | - * @param WPInv_Subscription $subscription |
|
| 92 | - * @return array |
|
| 93 | - */ |
|
| 94 | - public function get_subscription_merge_tags( $subscription ) { |
|
| 95 | - |
|
| 96 | - // Abort if it does not exist. |
|
| 97 | - if ( ! $subscription->get_id() ) { |
|
| 98 | - return array(); |
|
| 99 | - } |
|
| 100 | - |
|
| 101 | - $invoice = $subscription->get_parent_invoice(); |
|
| 102 | - return array( |
|
| 103 | - '{subscription_renewal_date}' => getpaid_format_date_value( $subscription->get_next_renewal_date(), __( 'Never', 'invoicing' ) ), |
|
| 104 | - '{subscription_created}' => getpaid_format_date_value( $subscription->get_date_created() ), |
|
| 105 | - '{subscription_status}' => sanitize_text_field( $subscription->get_status_label() ), |
|
| 106 | - '{subscription_profile_id}' => sanitize_text_field( $subscription->get_profile_id() ), |
|
| 107 | - '{subscription_id}' => absint( $subscription->get_id() ), |
|
| 108 | - '{subscription_recurring_amount}' => sanitize_text_field( wpinv_price( $subscription->get_recurring_amount(), $invoice->get_currency() ) ), |
|
| 109 | - '{subscription_initial_amount}' => sanitize_text_field( wpinv_price( $subscription->get_initial_amount(), $invoice->get_currency() ) ), |
|
| 110 | - '{subscription_recurring_period}' => getpaid_get_subscription_period_label( $subscription->get_period(), $subscription->get_frequency(), '' ), |
|
| 111 | - '{subscription_bill_times}' => $subscription->get_bill_times(), |
|
| 112 | - '{subscription_url}' => esc_url( $subscription->get_view_url() ), |
|
| 113 | - ); |
|
| 114 | - |
|
| 115 | - } |
|
| 116 | - |
|
| 117 | - /** |
|
| 118 | - * Checks if we should send a notification for a subscription. |
|
| 119 | - * |
|
| 120 | - * @param WPInv_Invoice $invoice |
|
| 121 | - * @return bool |
|
| 122 | - */ |
|
| 123 | - public function should_send_notification( $invoice ) { |
|
| 124 | - return 0 != $invoice->get_id(); |
|
| 125 | - } |
|
| 126 | - |
|
| 127 | - /** |
|
| 128 | - * Returns notification recipients. |
|
| 129 | - * |
|
| 130 | - * @param WPInv_Invoice $invoice |
|
| 131 | - * @return array |
|
| 132 | - */ |
|
| 133 | - public function get_recipients( $invoice ) { |
|
| 134 | - $recipients = array( $invoice->get_email() ); |
|
| 135 | - |
|
| 136 | - $cc = $invoice->get_email_cc(); |
|
| 137 | - |
|
| 138 | - if ( ! empty( $cc ) ) { |
|
| 139 | - $cc = array_map( 'sanitize_email', wpinv_parse_list( $cc ) ); |
|
| 140 | - $recipients = array_filter( array_unique( array_merge( $recipients, $cc ) ) ); |
|
| 141 | - } |
|
| 142 | - |
|
| 143 | - return $recipients; |
|
| 144 | - } |
|
| 145 | - |
|
| 146 | - /** |
|
| 147 | - * Helper function to send an email. |
|
| 148 | - * |
|
| 149 | - * @param WPInv_Subscription $subscription |
|
| 150 | - * @param GetPaid_Notification_Email $email |
|
| 151 | - * @param string $type |
|
| 152 | - * @param array $extra_args Extra template args. |
|
| 153 | - */ |
|
| 154 | - public function send_email( $subscription, $email, $type, $extra_args = array() ) { |
|
| 155 | - |
|
| 156 | - if ( empty( $subscription ) ) { |
|
| 157 | - return; |
|
| 158 | - } |
|
| 159 | - |
|
| 160 | - if ( is_array( $subscription ) ) { |
|
| 161 | - $subscription = current( $subscription ); |
|
| 162 | - } |
|
| 163 | - |
|
| 164 | - if ( ! $subscription instanceof WPInv_Subscription ) { |
|
| 165 | - return; |
|
| 166 | - } |
|
| 167 | - |
|
| 168 | - // Abort in case the parent invoice does not exist. |
|
| 169 | - $invoice = $subscription->get_parent_invoice(); |
|
| 170 | - if ( ! $this->should_send_notification( $invoice ) ) { |
|
| 171 | - return; |
|
| 172 | - } |
|
| 173 | - |
|
| 174 | - if ( apply_filters( 'getpaid_skip_subscription_email', false, $type, $subscription ) ) { |
|
| 175 | - return; |
|
| 176 | - } |
|
| 177 | - |
|
| 178 | - do_action( 'getpaid_before_send_subscription_notification', $type, $subscription, $email ); |
|
| 179 | - |
|
| 180 | - $recipients = $this->get_recipients( $invoice ); |
|
| 181 | - $mailer = new GetPaid_Notification_Email_Sender(); |
|
| 182 | - $merge_tags = $email->get_merge_tags(); |
|
| 183 | - $content = $email->get_content( $merge_tags, $extra_args ); |
|
| 184 | - $subject = $email->add_merge_tags( $email->get_subject(), $merge_tags ); |
|
| 185 | - $attachments = $email->get_attachments(); |
|
| 186 | - |
|
| 187 | - $result = $mailer->send( |
|
| 188 | - apply_filters( 'getpaid_subscription_email_recipients', wpinv_parse_list( $recipients ), $email ), |
|
| 189 | - $subject, |
|
| 190 | - $content, |
|
| 191 | - $attachments |
|
| 192 | - ); |
|
| 193 | - |
|
| 194 | - // Maybe send a copy to the admin. |
|
| 195 | - if ( $email->include_admin_bcc() ) { |
|
| 196 | - $mailer->send( |
|
| 197 | - wpinv_get_admin_email(), |
|
| 198 | - $subject . __( ' - ADMIN BCC COPY', 'invoicing' ), |
|
| 199 | - $content, |
|
| 200 | - $attachments |
|
| 201 | - ); |
|
| 202 | - } |
|
| 203 | - |
|
| 204 | - if ( $result ) { |
|
| 205 | - $invoice->add_system_note( |
|
| 206 | - sprintf( |
|
| 207 | - __( 'Successfully sent %1$s notification email to %2$s.', 'invoicing' ), |
|
| 208 | - sanitize_key( $type ), |
|
| 209 | - $email->is_admin_email() ? __( 'admin' ) : __( 'the customer' ) |
|
| 210 | - ) |
|
| 211 | - ); |
|
| 212 | - } else { |
|
| 213 | - $invoice->add_system_note( |
|
| 214 | - sprintf( |
|
| 215 | - __( 'Failed sending %1$s notification email to %2$s.', 'invoicing' ), |
|
| 216 | - sanitize_key( $type ), |
|
| 217 | - $email->is_admin_email() ? __( 'admin' ) : __( 'the customer' ) |
|
| 218 | - ) |
|
| 219 | - ); |
|
| 220 | - } |
|
| 221 | - |
|
| 222 | - do_action( 'getpaid_after_send_subscription_notification', $type, $subscription, $email ); |
|
| 223 | - |
|
| 224 | - } |
|
| 225 | - |
|
| 226 | - /** |
|
| 227 | - * Sends a subscription active. |
|
| 228 | - * |
|
| 229 | - * @since 2.8.4 |
|
| 230 | - * |
|
| 231 | - * @param WPInv_Subscription $subscription |
|
| 232 | - */ |
|
| 233 | - public function subscription_active( $subscription ) { |
|
| 234 | - $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 235 | - |
|
| 236 | - $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 237 | - } |
|
| 45 | + * Registers email hooks. |
|
| 46 | + */ |
|
| 47 | + public function init_hooks() { |
|
| 48 | + |
|
| 49 | + add_filter( 'getpaid_get_email_merge_tags', array( $this, 'subscription_merge_tags' ), 10, 2 ); |
|
| 50 | + foreach ( $this->subscription_actions as $hook => $email_type ) { |
|
| 51 | + |
|
| 52 | + $email = new GetPaid_Notification_Email( $email_type ); |
|
| 53 | + |
|
| 54 | + if ( ! $email->is_active() ) { |
|
| 55 | + continue; |
|
| 56 | + } |
|
| 57 | + |
|
| 58 | + if ( method_exists( $this, $email_type ) ) { |
|
| 59 | + add_action( $hook, array( $this, $email_type ), 100, 2 ); |
|
| 60 | + continue; |
|
| 61 | + } |
|
| 62 | + |
|
| 63 | + do_action( 'getpaid_subscription_notification_email_register_hook', $email_type, $hook ); |
|
| 64 | + |
|
| 65 | + } |
|
| 66 | + |
|
| 67 | + } |
|
| 238 | 68 | |
| 239 | 69 | /** |
| 240 | - * Sends a new trial notification. |
|
| 241 | - * |
|
| 242 | - * @param WPInv_Subscription $subscription |
|
| 243 | - */ |
|
| 244 | - public function subscription_trial( $subscription ) { |
|
| 70 | + * Filters subscription merge tags. |
|
| 71 | + * |
|
| 72 | + * @param array $merge_tags |
|
| 73 | + * @param mixed|WPInv_Invoice|WPInv_Subscription $object |
|
| 74 | + */ |
|
| 75 | + public function subscription_merge_tags( $merge_tags, $object ) { |
|
| 245 | 76 | |
| 246 | - $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 247 | - $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 77 | + if ( is_a( $object, 'WPInv_Subscription' ) ) { |
|
| 78 | + $merge_tags = array_merge( |
|
| 79 | + $merge_tags, |
|
| 80 | + $this->get_subscription_merge_tags( $object ) |
|
| 81 | + ); |
|
| 82 | + } |
|
| 248 | 83 | |
| 249 | - } |
|
| 84 | + return $merge_tags; |
|
| 250 | 85 | |
| 251 | - /** |
|
| 252 | - * Sends a cancelled subscription notification. |
|
| 253 | - * |
|
| 254 | - * @param WPInv_Subscription $subscription |
|
| 255 | - */ |
|
| 256 | - public function subscription_cancelled( $subscription ) { |
|
| 86 | + } |
|
| 257 | 87 | |
| 258 | - $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 259 | - $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 88 | + /** |
|
| 89 | + * Generates subscription merge tags. |
|
| 90 | + * |
|
| 91 | + * @param WPInv_Subscription $subscription |
|
| 92 | + * @return array |
|
| 93 | + */ |
|
| 94 | + public function get_subscription_merge_tags( $subscription ) { |
|
| 95 | + |
|
| 96 | + // Abort if it does not exist. |
|
| 97 | + if ( ! $subscription->get_id() ) { |
|
| 98 | + return array(); |
|
| 99 | + } |
|
| 100 | + |
|
| 101 | + $invoice = $subscription->get_parent_invoice(); |
|
| 102 | + return array( |
|
| 103 | + '{subscription_renewal_date}' => getpaid_format_date_value( $subscription->get_next_renewal_date(), __( 'Never', 'invoicing' ) ), |
|
| 104 | + '{subscription_created}' => getpaid_format_date_value( $subscription->get_date_created() ), |
|
| 105 | + '{subscription_status}' => sanitize_text_field( $subscription->get_status_label() ), |
|
| 106 | + '{subscription_profile_id}' => sanitize_text_field( $subscription->get_profile_id() ), |
|
| 107 | + '{subscription_id}' => absint( $subscription->get_id() ), |
|
| 108 | + '{subscription_recurring_amount}' => sanitize_text_field( wpinv_price( $subscription->get_recurring_amount(), $invoice->get_currency() ) ), |
|
| 109 | + '{subscription_initial_amount}' => sanitize_text_field( wpinv_price( $subscription->get_initial_amount(), $invoice->get_currency() ) ), |
|
| 110 | + '{subscription_recurring_period}' => getpaid_get_subscription_period_label( $subscription->get_period(), $subscription->get_frequency(), '' ), |
|
| 111 | + '{subscription_bill_times}' => $subscription->get_bill_times(), |
|
| 112 | + '{subscription_url}' => esc_url( $subscription->get_view_url() ), |
|
| 113 | + ); |
|
| 260 | 114 | |
| 261 | - } |
|
| 115 | + } |
|
| 262 | 116 | |
| 263 | - /** |
|
| 264 | - * Sends a subscription expired notification. |
|
| 265 | - * |
|
| 266 | - * @param WPInv_Subscription $subscription |
|
| 267 | - */ |
|
| 268 | - public function subscription_expired( $subscription ) { |
|
| 117 | + /** |
|
| 118 | + * Checks if we should send a notification for a subscription. |
|
| 119 | + * |
|
| 120 | + * @param WPInv_Invoice $invoice |
|
| 121 | + * @return bool |
|
| 122 | + */ |
|
| 123 | + public function should_send_notification( $invoice ) { |
|
| 124 | + return 0 != $invoice->get_id(); |
|
| 125 | + } |
|
| 269 | 126 | |
| 270 | - $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 271 | - $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 127 | + /** |
|
| 128 | + * Returns notification recipients. |
|
| 129 | + * |
|
| 130 | + * @param WPInv_Invoice $invoice |
|
| 131 | + * @return array |
|
| 132 | + */ |
|
| 133 | + public function get_recipients( $invoice ) { |
|
| 134 | + $recipients = array( $invoice->get_email() ); |
|
| 272 | 135 | |
| 273 | - } |
|
| 136 | + $cc = $invoice->get_email_cc(); |
|
| 274 | 137 | |
| 275 | - /** |
|
| 276 | - * Sends a completed subscription notification. |
|
| 277 | - * |
|
| 278 | - * @param WPInv_Subscription $subscription |
|
| 279 | - */ |
|
| 280 | - public function subscription_complete( $subscription ) { |
|
| 138 | + if ( ! empty( $cc ) ) { |
|
| 139 | + $cc = array_map( 'sanitize_email', wpinv_parse_list( $cc ) ); |
|
| 140 | + $recipients = array_filter( array_unique( array_merge( $recipients, $cc ) ) ); |
|
| 141 | + } |
|
| 281 | 142 | |
| 282 | - $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 283 | - $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 143 | + return $recipients; |
|
| 144 | + } |
|
| 284 | 145 | |
| 285 | - } |
|
| 146 | + /** |
|
| 147 | + * Helper function to send an email. |
|
| 148 | + * |
|
| 149 | + * @param WPInv_Subscription $subscription |
|
| 150 | + * @param GetPaid_Notification_Email $email |
|
| 151 | + * @param string $type |
|
| 152 | + * @param array $extra_args Extra template args. |
|
| 153 | + */ |
|
| 154 | + public function send_email( $subscription, $email, $type, $extra_args = array() ) { |
|
| 155 | + |
|
| 156 | + if ( empty( $subscription ) ) { |
|
| 157 | + return; |
|
| 158 | + } |
|
| 159 | + |
|
| 160 | + if ( is_array( $subscription ) ) { |
|
| 161 | + $subscription = current( $subscription ); |
|
| 162 | + } |
|
| 163 | + |
|
| 164 | + if ( ! $subscription instanceof WPInv_Subscription ) { |
|
| 165 | + return; |
|
| 166 | + } |
|
| 167 | + |
|
| 168 | + // Abort in case the parent invoice does not exist. |
|
| 169 | + $invoice = $subscription->get_parent_invoice(); |
|
| 170 | + if ( ! $this->should_send_notification( $invoice ) ) { |
|
| 171 | + return; |
|
| 172 | + } |
|
| 173 | + |
|
| 174 | + if ( apply_filters( 'getpaid_skip_subscription_email', false, $type, $subscription ) ) { |
|
| 175 | + return; |
|
| 176 | + } |
|
| 177 | + |
|
| 178 | + do_action( 'getpaid_before_send_subscription_notification', $type, $subscription, $email ); |
|
| 179 | + |
|
| 180 | + $recipients = $this->get_recipients( $invoice ); |
|
| 181 | + $mailer = new GetPaid_Notification_Email_Sender(); |
|
| 182 | + $merge_tags = $email->get_merge_tags(); |
|
| 183 | + $content = $email->get_content( $merge_tags, $extra_args ); |
|
| 184 | + $subject = $email->add_merge_tags( $email->get_subject(), $merge_tags ); |
|
| 185 | + $attachments = $email->get_attachments(); |
|
| 186 | + |
|
| 187 | + $result = $mailer->send( |
|
| 188 | + apply_filters( 'getpaid_subscription_email_recipients', wpinv_parse_list( $recipients ), $email ), |
|
| 189 | + $subject, |
|
| 190 | + $content, |
|
| 191 | + $attachments |
|
| 192 | + ); |
|
| 193 | + |
|
| 194 | + // Maybe send a copy to the admin. |
|
| 195 | + if ( $email->include_admin_bcc() ) { |
|
| 196 | + $mailer->send( |
|
| 197 | + wpinv_get_admin_email(), |
|
| 198 | + $subject . __( ' - ADMIN BCC COPY', 'invoicing' ), |
|
| 199 | + $content, |
|
| 200 | + $attachments |
|
| 201 | + ); |
|
| 202 | + } |
|
| 203 | + |
|
| 204 | + if ( $result ) { |
|
| 205 | + $invoice->add_system_note( |
|
| 206 | + sprintf( |
|
| 207 | + __( 'Successfully sent %1$s notification email to %2$s.', 'invoicing' ), |
|
| 208 | + sanitize_key( $type ), |
|
| 209 | + $email->is_admin_email() ? __( 'admin' ) : __( 'the customer' ) |
|
| 210 | + ) |
|
| 211 | + ); |
|
| 212 | + } else { |
|
| 213 | + $invoice->add_system_note( |
|
| 214 | + sprintf( |
|
| 215 | + __( 'Failed sending %1$s notification email to %2$s.', 'invoicing' ), |
|
| 216 | + sanitize_key( $type ), |
|
| 217 | + $email->is_admin_email() ? __( 'admin' ) : __( 'the customer' ) |
|
| 218 | + ) |
|
| 219 | + ); |
|
| 220 | + } |
|
| 221 | + |
|
| 222 | + do_action( 'getpaid_after_send_subscription_notification', $type, $subscription, $email ); |
|
| 286 | 223 | |
| 287 | - /** |
|
| 288 | - * Sends a subscription renewal reminder notification. |
|
| 289 | - * |
|
| 290 | - */ |
|
| 291 | - public function renewal_reminder() { |
|
| 224 | + } |
|
| 292 | 225 | |
| 293 | - $email = new GetPaid_Notification_Email( __FUNCTION__ ); |
|
| 226 | + /** |
|
| 227 | + * Sends a subscription active. |
|
| 228 | + * |
|
| 229 | + * @since 2.8.4 |
|
| 230 | + * |
|
| 231 | + * @param WPInv_Subscription $subscription |
|
| 232 | + */ |
|
| 233 | + public function subscription_active( $subscription ) { |
|
| 234 | + $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 294 | 235 | |
| 295 | - // Fetch reminder days. |
|
| 296 | - $reminder_days = array_unique( wp_parse_id_list( $email->get_option( 'days' ) ) ); |
|
| 236 | + $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 237 | + } |
|
| 297 | 238 | |
| 298 | - // Abort if non is set. |
|
| 299 | - if ( empty( $reminder_days ) ) { |
|
| 300 | - return; |
|
| 301 | - } |
|
| 239 | + /** |
|
| 240 | + * Sends a new trial notification. |
|
| 241 | + * |
|
| 242 | + * @param WPInv_Subscription $subscription |
|
| 243 | + */ |
|
| 244 | + public function subscription_trial( $subscription ) { |
|
| 302 | 245 | |
| 303 | - // Fetch matching subscriptions. |
|
| 246 | + $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 247 | + $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 248 | + |
|
| 249 | + } |
|
| 250 | + |
|
| 251 | + /** |
|
| 252 | + * Sends a cancelled subscription notification. |
|
| 253 | + * |
|
| 254 | + * @param WPInv_Subscription $subscription |
|
| 255 | + */ |
|
| 256 | + public function subscription_cancelled( $subscription ) { |
|
| 257 | + |
|
| 258 | + $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 259 | + $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 260 | + |
|
| 261 | + } |
|
| 262 | + |
|
| 263 | + /** |
|
| 264 | + * Sends a subscription expired notification. |
|
| 265 | + * |
|
| 266 | + * @param WPInv_Subscription $subscription |
|
| 267 | + */ |
|
| 268 | + public function subscription_expired( $subscription ) { |
|
| 269 | + |
|
| 270 | + $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 271 | + $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 272 | + |
|
| 273 | + } |
|
| 274 | + |
|
| 275 | + /** |
|
| 276 | + * Sends a completed subscription notification. |
|
| 277 | + * |
|
| 278 | + * @param WPInv_Subscription $subscription |
|
| 279 | + */ |
|
| 280 | + public function subscription_complete( $subscription ) { |
|
| 281 | + |
|
| 282 | + $email = new GetPaid_Notification_Email( __FUNCTION__, $subscription ); |
|
| 283 | + $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 284 | + |
|
| 285 | + } |
|
| 286 | + |
|
| 287 | + /** |
|
| 288 | + * Sends a subscription renewal reminder notification. |
|
| 289 | + * |
|
| 290 | + */ |
|
| 291 | + public function renewal_reminder() { |
|
| 292 | + |
|
| 293 | + $email = new GetPaid_Notification_Email( __FUNCTION__ ); |
|
| 294 | + |
|
| 295 | + // Fetch reminder days. |
|
| 296 | + $reminder_days = array_unique( wp_parse_id_list( $email->get_option( 'days' ) ) ); |
|
| 297 | + |
|
| 298 | + // Abort if non is set. |
|
| 299 | + if ( empty( $reminder_days ) ) { |
|
| 300 | + return; |
|
| 301 | + } |
|
| 302 | + |
|
| 303 | + // Fetch matching subscriptions. |
|
| 304 | 304 | $args = array( |
| 305 | 305 | 'number' => -1, |
| 306 | - 'count_total' => false, |
|
| 307 | - 'status' => 'trialling active', |
|
| 306 | + 'count_total' => false, |
|
| 307 | + 'status' => 'trialling active', |
|
| 308 | 308 | 'date_expires_query' => array( |
| 309 | - 'relation' => 'OR', |
|
| 309 | + 'relation' => 'OR', |
|
| 310 | 310 | ), |
| 311 | - ); |
|
| 311 | + ); |
|
| 312 | 312 | |
| 313 | - foreach ( $reminder_days as $days ) { |
|
| 314 | - $date = date_parse( date( 'Y-m-d', strtotime( "+$days days", current_time( 'timestamp' ) ) ) ); |
|
| 313 | + foreach ( $reminder_days as $days ) { |
|
| 314 | + $date = date_parse( date( 'Y-m-d', strtotime( "+$days days", current_time( 'timestamp' ) ) ) ); |
|
| 315 | 315 | |
| 316 | - $args['date_expires_query'][] = array( |
|
| 317 | - 'year' => $date['year'], |
|
| 318 | - 'month' => $date['month'], |
|
| 319 | - 'day' => $date['day'], |
|
| 320 | - ); |
|
| 316 | + $args['date_expires_query'][] = array( |
|
| 317 | + 'year' => $date['year'], |
|
| 318 | + 'month' => $date['month'], |
|
| 319 | + 'day' => $date['day'], |
|
| 320 | + ); |
|
| 321 | 321 | |
| 322 | - } |
|
| 322 | + } |
|
| 323 | 323 | |
| 324 | - $subscriptions = new GetPaid_Subscriptions_Query( $args ); |
|
| 324 | + $subscriptions = new GetPaid_Subscriptions_Query( $args ); |
|
| 325 | 325 | |
| 326 | 326 | foreach ( $subscriptions->get_results() as $subscription ) { |
| 327 | 327 | |
| 328 | - // Skip packages. |
|
| 329 | - if ( apply_filters( 'getpaid_send_subscription_renewal_reminder_email', true ) ) { |
|
| 330 | - $email->object = $subscription; |
|
| 331 | - $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 332 | - } |
|
| 333 | - } |
|
| 328 | + // Skip packages. |
|
| 329 | + if ( apply_filters( 'getpaid_send_subscription_renewal_reminder_email', true ) ) { |
|
| 330 | + $email->object = $subscription; |
|
| 331 | + $this->send_email( $subscription, $email, __FUNCTION__ ); |
|
| 332 | + } |
|
| 333 | + } |
|
| 334 | 334 | |
| 335 | - } |
|
| 335 | + } |
|
| 336 | 336 | |
| 337 | 337 | } |
@@ -1,7 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | 3 | if ( ! defined( 'ABSPATH' ) ) { |
| 4 | - exit; // Exit if accessed directly |
|
| 4 | + exit; // Exit if accessed directly |
|
| 5 | 5 | } |
| 6 | 6 | |
| 7 | 7 | /** |
@@ -11,112 +11,112 @@ discard block |
||
| 11 | 11 | */ |
| 12 | 12 | class AUI_Component_Pagination { |
| 13 | 13 | |
| 14 | - /** |
|
| 15 | - * Build the component. |
|
| 16 | - * |
|
| 17 | - * @param array $args |
|
| 18 | - * |
|
| 19 | - * @return string The rendered component. |
|
| 20 | - */ |
|
| 21 | - public static function get( $args = array() ) { |
|
| 22 | - global $wp_query, $aui_bs5; |
|
| 23 | - |
|
| 24 | - $defaults = array( |
|
| 25 | - 'class' => '', |
|
| 26 | - 'mid_size' => 2, |
|
| 27 | - 'prev_text' => '<i class="fas fa-chevron-left"></i>', |
|
| 28 | - 'next_text' => '<i class="fas fa-chevron-right"></i>', |
|
| 29 | - 'screen_reader_text' => __( 'Posts navigation', 'ayecode-connect' ), |
|
| 30 | - 'before_paging' => '', |
|
| 31 | - 'after_paging' => '', |
|
| 32 | - 'type' => 'array', |
|
| 33 | - 'total' => isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1, |
|
| 34 | - 'links' => array(), // an array of links if using custom links, this includes the a tag. |
|
| 35 | - 'rounded_style' => false, |
|
| 36 | - 'custom_next_text' => '', // Custom next page text |
|
| 37 | - 'custom_prev_text' => '', // Custom prev page text |
|
| 38 | - ); |
|
| 39 | - |
|
| 40 | - /** |
|
| 41 | - * Parse incoming $args into an array and merge it with $defaults |
|
| 42 | - */ |
|
| 43 | - $args = wp_parse_args( $args, $defaults ); |
|
| 44 | - |
|
| 45 | - $output = ''; |
|
| 46 | - |
|
| 47 | - // Don't print empty markup if there's only one page. |
|
| 48 | - if ( $args['total'] > 1 ) { |
|
| 49 | - // Set up paginated links. |
|
| 50 | - $links = !empty( $args['links'] ) ? $args['links'] : paginate_links( $args ); |
|
| 51 | - |
|
| 52 | - $class = !empty($args['class']) ? $args['class'] : ''; |
|
| 53 | - |
|
| 54 | - $custom_prev_link = ''; |
|
| 55 | - $custom_next_link = ''; |
|
| 56 | - |
|
| 57 | - // make the output bootstrap ready |
|
| 58 | - $links_html = "<ul class='pagination m-0 p-0 $class'>"; |
|
| 59 | - if ( ! empty( $links ) ) { |
|
| 60 | - foreach ( $links as $link ) { |
|
| 61 | - $_link = $link; |
|
| 62 | - |
|
| 63 | - if ( $aui_bs5 ) { |
|
| 64 | - $link_class = $args['rounded_style'] ? 'page-link badge rounded-pill border-0 mx-1 fs-base text-dark link-primary' : 'page-link'; |
|
| 65 | - $link_class_active = $args['rounded_style'] ? ' current active fw-bold badge rounded-pill' : ' current active'; |
|
| 66 | - $links_html .= "<li class='page-item mx-0'>"; |
|
| 67 | - $link = str_replace( array( "page-numbers", " current" ), array( $link_class, $link_class_active ), $link ); |
|
| 68 | - $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
| 69 | - $links_html .= $link; |
|
| 70 | - $links_html .= "</li>"; |
|
| 71 | - } else { |
|
| 72 | - $active = strpos( $link, 'current' ) !== false ? 'active' : ''; |
|
| 73 | - $links_html .= "<li class='page-item $active'>"; |
|
| 74 | - $links_html .= str_replace( "page-numbers", "page-link", $link ); |
|
| 75 | - $links_html .= "</li>"; |
|
| 76 | - } |
|
| 77 | - |
|
| 78 | - if ( strpos( $_link, 'next page-numbers' ) || strpos( $_link, 'prev page-numbers' ) ) { |
|
| 79 | - $link = str_replace( array( "page-numbers", " current" ), array( 'btn btn-outline-primary rounded' . ( $args['rounded_style'] ? '-pill' : '' ) . ' mx-1 fs-base text-dark link-primary', ' current active fw-bold badge rounded-pill' ), $_link ); |
|
| 80 | - $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
| 81 | - |
|
| 82 | - if ( strpos( $_link, 'next page-numbers' ) && ! empty( $args['custom_next_text'] ) ) { |
|
| 83 | - $custom_next_link = str_replace( $args['next_text'], $args['custom_next_text'], $link ); |
|
| 84 | - } else if ( strpos( $_link, 'prev page-numbers' ) && ! empty( $args['custom_prev_text'] ) ) { |
|
| 85 | - $custom_prev_link = str_replace( $args['prev_text'], $args['custom_prev_text'], $link ); |
|
| 86 | - } |
|
| 87 | - } |
|
| 88 | - } |
|
| 89 | - } |
|
| 90 | - $links_html .= "</ul>"; |
|
| 91 | - |
|
| 92 | - if ( $links ) { |
|
| 93 | - $output .= '<section class="px-0 py-2 w-100">'; |
|
| 94 | - $output .= _navigation_markup( $links_html, 'aui-pagination', $args['screen_reader_text'] ); |
|
| 95 | - $output .= '</section>'; |
|
| 96 | - } |
|
| 97 | - |
|
| 98 | - $output = str_replace( "screen-reader-text", "screen-reader-text sr-only", $output ); |
|
| 99 | - $output = str_replace( "nav-links", "aui-nav-links", $output ); |
|
| 100 | - } |
|
| 101 | - |
|
| 102 | - if ( $output ) { |
|
| 103 | - if ( $custom_next_link || $custom_prev_link ) { |
|
| 104 | - $total = isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1; |
|
| 105 | - $current = get_query_var( 'paged' ) ? (int) get_query_var( 'paged' ) : 1; |
|
| 106 | - |
|
| 107 | - $output = '<div class="row d-flex align-items-center justify-content-between"><div class="col text-start">' . $custom_prev_link . '</div><div class="col text-center d-none d-md-block">' . $output . '</div><div class="col text-center d-md-none">' . $current . '/' . $args['total'] . '</div><div class="col text-end">' . $custom_next_link . '</div></div>'; |
|
| 108 | - } |
|
| 109 | - |
|
| 110 | - if ( ! empty( $args['before_paging'] ) ) { |
|
| 111 | - $output = $args['before_paging'] . $output; |
|
| 112 | - } |
|
| 113 | - |
|
| 114 | - if ( ! empty( $args['after_paging'] ) ) { |
|
| 115 | - $output = $output . $args['after_paging']; |
|
| 116 | - } |
|
| 117 | - } |
|
| 118 | - |
|
| 119 | - return $output; |
|
| 120 | - } |
|
| 14 | + /** |
|
| 15 | + * Build the component. |
|
| 16 | + * |
|
| 17 | + * @param array $args |
|
| 18 | + * |
|
| 19 | + * @return string The rendered component. |
|
| 20 | + */ |
|
| 21 | + public static function get( $args = array() ) { |
|
| 22 | + global $wp_query, $aui_bs5; |
|
| 23 | + |
|
| 24 | + $defaults = array( |
|
| 25 | + 'class' => '', |
|
| 26 | + 'mid_size' => 2, |
|
| 27 | + 'prev_text' => '<i class="fas fa-chevron-left"></i>', |
|
| 28 | + 'next_text' => '<i class="fas fa-chevron-right"></i>', |
|
| 29 | + 'screen_reader_text' => __( 'Posts navigation', 'ayecode-connect' ), |
|
| 30 | + 'before_paging' => '', |
|
| 31 | + 'after_paging' => '', |
|
| 32 | + 'type' => 'array', |
|
| 33 | + 'total' => isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1, |
|
| 34 | + 'links' => array(), // an array of links if using custom links, this includes the a tag. |
|
| 35 | + 'rounded_style' => false, |
|
| 36 | + 'custom_next_text' => '', // Custom next page text |
|
| 37 | + 'custom_prev_text' => '', // Custom prev page text |
|
| 38 | + ); |
|
| 39 | + |
|
| 40 | + /** |
|
| 41 | + * Parse incoming $args into an array and merge it with $defaults |
|
| 42 | + */ |
|
| 43 | + $args = wp_parse_args( $args, $defaults ); |
|
| 44 | + |
|
| 45 | + $output = ''; |
|
| 46 | + |
|
| 47 | + // Don't print empty markup if there's only one page. |
|
| 48 | + if ( $args['total'] > 1 ) { |
|
| 49 | + // Set up paginated links. |
|
| 50 | + $links = !empty( $args['links'] ) ? $args['links'] : paginate_links( $args ); |
|
| 51 | + |
|
| 52 | + $class = !empty($args['class']) ? $args['class'] : ''; |
|
| 53 | + |
|
| 54 | + $custom_prev_link = ''; |
|
| 55 | + $custom_next_link = ''; |
|
| 56 | + |
|
| 57 | + // make the output bootstrap ready |
|
| 58 | + $links_html = "<ul class='pagination m-0 p-0 $class'>"; |
|
| 59 | + if ( ! empty( $links ) ) { |
|
| 60 | + foreach ( $links as $link ) { |
|
| 61 | + $_link = $link; |
|
| 62 | + |
|
| 63 | + if ( $aui_bs5 ) { |
|
| 64 | + $link_class = $args['rounded_style'] ? 'page-link badge rounded-pill border-0 mx-1 fs-base text-dark link-primary' : 'page-link'; |
|
| 65 | + $link_class_active = $args['rounded_style'] ? ' current active fw-bold badge rounded-pill' : ' current active'; |
|
| 66 | + $links_html .= "<li class='page-item mx-0'>"; |
|
| 67 | + $link = str_replace( array( "page-numbers", " current" ), array( $link_class, $link_class_active ), $link ); |
|
| 68 | + $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
| 69 | + $links_html .= $link; |
|
| 70 | + $links_html .= "</li>"; |
|
| 71 | + } else { |
|
| 72 | + $active = strpos( $link, 'current' ) !== false ? 'active' : ''; |
|
| 73 | + $links_html .= "<li class='page-item $active'>"; |
|
| 74 | + $links_html .= str_replace( "page-numbers", "page-link", $link ); |
|
| 75 | + $links_html .= "</li>"; |
|
| 76 | + } |
|
| 77 | + |
|
| 78 | + if ( strpos( $_link, 'next page-numbers' ) || strpos( $_link, 'prev page-numbers' ) ) { |
|
| 79 | + $link = str_replace( array( "page-numbers", " current" ), array( 'btn btn-outline-primary rounded' . ( $args['rounded_style'] ? '-pill' : '' ) . ' mx-1 fs-base text-dark link-primary', ' current active fw-bold badge rounded-pill' ), $_link ); |
|
| 80 | + $link = str_replace( 'text-dark link-primary current', 'current', $link ); |
|
| 81 | + |
|
| 82 | + if ( strpos( $_link, 'next page-numbers' ) && ! empty( $args['custom_next_text'] ) ) { |
|
| 83 | + $custom_next_link = str_replace( $args['next_text'], $args['custom_next_text'], $link ); |
|
| 84 | + } else if ( strpos( $_link, 'prev page-numbers' ) && ! empty( $args['custom_prev_text'] ) ) { |
|
| 85 | + $custom_prev_link = str_replace( $args['prev_text'], $args['custom_prev_text'], $link ); |
|
| 86 | + } |
|
| 87 | + } |
|
| 88 | + } |
|
| 89 | + } |
|
| 90 | + $links_html .= "</ul>"; |
|
| 91 | + |
|
| 92 | + if ( $links ) { |
|
| 93 | + $output .= '<section class="px-0 py-2 w-100">'; |
|
| 94 | + $output .= _navigation_markup( $links_html, 'aui-pagination', $args['screen_reader_text'] ); |
|
| 95 | + $output .= '</section>'; |
|
| 96 | + } |
|
| 97 | + |
|
| 98 | + $output = str_replace( "screen-reader-text", "screen-reader-text sr-only", $output ); |
|
| 99 | + $output = str_replace( "nav-links", "aui-nav-links", $output ); |
|
| 100 | + } |
|
| 101 | + |
|
| 102 | + if ( $output ) { |
|
| 103 | + if ( $custom_next_link || $custom_prev_link ) { |
|
| 104 | + $total = isset( $wp_query->max_num_pages ) ? $wp_query->max_num_pages : 1; |
|
| 105 | + $current = get_query_var( 'paged' ) ? (int) get_query_var( 'paged' ) : 1; |
|
| 106 | + |
|
| 107 | + $output = '<div class="row d-flex align-items-center justify-content-between"><div class="col text-start">' . $custom_prev_link . '</div><div class="col text-center d-none d-md-block">' . $output . '</div><div class="col text-center d-md-none">' . $current . '/' . $args['total'] . '</div><div class="col text-end">' . $custom_next_link . '</div></div>'; |
|
| 108 | + } |
|
| 109 | + |
|
| 110 | + if ( ! empty( $args['before_paging'] ) ) { |
|
| 111 | + $output = $args['before_paging'] . $output; |
|
| 112 | + } |
|
| 113 | + |
|
| 114 | + if ( ! empty( $args['after_paging'] ) ) { |
|
| 115 | + $output = $output . $args['after_paging']; |
|
| 116 | + } |
|
| 117 | + } |
|
| 118 | + |
|
| 119 | + return $output; |
|
| 120 | + } |
|
| 121 | 121 | |
| 122 | 122 | } |
| 123 | 123 | \ No newline at end of file |
@@ -1001,8 +1001,8 @@ |
||
| 1001 | 1001 | aui_flip_color_scheme_on_scroll(); |
| 1002 | 1002 | |
| 1003 | 1003 | <?php |
| 1004 | - // FSE tweaks. |
|
| 1005 | - if(!empty($_REQUEST['postType'])){ ?> |
|
| 1004 | + // FSE tweaks. |
|
| 1005 | + if(!empty($_REQUEST['postType'])){ ?> |
|
| 1006 | 1006 | function aui_fse_set_data_scroll() { |
| 1007 | 1007 | console.log('init scroll'); |
| 1008 | 1008 | let Iframe = document.getElementsByClassName("edit-site-visual-editor__editor-canvas"); |
@@ -1,264 +1,264 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | if ( ! defined( 'ABSPATH' ) ) { |
| 3 | - exit; |
|
| 3 | + exit; |
|
| 4 | 4 | } |
| 5 | 5 | |
| 6 | 6 | if ( ! class_exists( "AyeCode_Connect_Helper" ) ) { |
| 7 | - /** |
|
| 8 | - * Allow the quick setup and connection of our AyeCode Connect plugin. |
|
| 9 | - * |
|
| 10 | - * Class AyeCode_Connect_Helper |
|
| 11 | - */ |
|
| 12 | - class AyeCode_Connect_Helper { |
|
| 13 | - |
|
| 14 | - // Hold the version number |
|
| 15 | - var $version = "1.0.4"; |
|
| 16 | - |
|
| 17 | - // Hold the default strings. |
|
| 18 | - var $strings = array(); |
|
| 19 | - |
|
| 20 | - // Hold the default pages. |
|
| 21 | - var $pages = array(); |
|
| 22 | - |
|
| 23 | - /** |
|
| 24 | - * The constructor. |
|
| 25 | - * |
|
| 26 | - * AyeCode_Connect_Helper constructor. |
|
| 27 | - * |
|
| 28 | - * @param array $strings |
|
| 29 | - * @param array $pages |
|
| 30 | - */ |
|
| 31 | - public function __construct( $strings = array(), $pages = array() ) { |
|
| 32 | - // Only fire if not localhost and the current user has the right permissions. |
|
| 33 | - if ( ! $this->is_localhost() && current_user_can( 'manage_options' ) ) { |
|
| 34 | - // set default strings |
|
| 35 | - $default_strings = array( |
|
| 36 | - 'connect_title' => __( "Thanks for choosing an AyeCode Product!", 'ayecode-connect' ), |
|
| 37 | - 'connect_external' => __( "Please confirm you wish to connect your site?", 'ayecode-connect' ), |
|
| 38 | - 'connect' => wp_sprintf( __( "<strong>Have a license?</strong> Forget about entering license keys or downloading zip files, connect your site for instant access. %slearn more%s", 'ayecode-connect' ), "<a href='https://ayecode.io/introducing-ayecode-connect/' target='_blank'>", "</a>" ), |
|
| 39 | - 'connect_button' => __( "Connect Site", 'ayecode-connect' ), |
|
| 40 | - 'connecting_button' => __( "Connecting...", 'ayecode-connect' ), |
|
| 41 | - 'error_localhost' => __( "This service will only work with a live domain, not a localhost.", 'ayecode-connect' ), |
|
| 42 | - 'error' => __( "Something went wrong, please refresh and try again.", 'ayecode-connect' ), |
|
| 43 | - ); |
|
| 44 | - $this->strings = array_merge( $default_strings, $strings ); |
|
| 45 | - |
|
| 46 | - // set default pages |
|
| 47 | - $default_pages = array(); |
|
| 48 | - $this->pages = array_merge( $default_pages, $pages ); |
|
| 49 | - |
|
| 50 | - // maybe show connect site notice |
|
| 51 | - add_action( 'admin_notices', array( $this, 'ayecode_connect_install_notice' ) ); |
|
| 52 | - |
|
| 53 | - // add ajax action if not already added |
|
| 54 | - if ( ! has_action( 'wp_ajax_ayecode_connect_helper' ) ) { |
|
| 55 | - add_action( 'wp_ajax_ayecode_connect_helper', array( $this, 'ayecode_connect_install' ) ); |
|
| 56 | - } |
|
| 57 | - } |
|
| 58 | - |
|
| 59 | - // add ajax action if not already added |
|
| 60 | - if ( ! has_action( 'wp_ajax_nopriv_ayecode_connect_helper_installed' ) ) { |
|
| 61 | - add_action( 'wp_ajax_nopriv_ayecode_connect_helper_installed', array( $this, 'ayecode_connect_helper_installed' ) ); |
|
| 62 | - } |
|
| 63 | - } |
|
| 64 | - |
|
| 65 | - /** |
|
| 66 | - * Give a way to check we can connect via a external redirect. |
|
| 67 | - */ |
|
| 68 | - public function ayecode_connect_helper_installed(){ |
|
| 69 | - $active = array( |
|
| 70 | - 'gd' => defined('GEODIRECTORY_VERSION') && version_compare(GEODIRECTORY_VERSION,'2.0.0.79','>') ? 1 : 0, |
|
| 71 | - 'uwp' => defined('USERSWP_VERSION') && version_compare(USERSWP_VERSION,'1.2.1.5','>') ? 1 : 0, |
|
| 72 | - 'wpi' => defined('WPINV_VERSION') && version_compare(WPINV_VERSION,'1.0.14','>') ? 1 : 0, |
|
| 73 | - ); |
|
| 74 | - wp_send_json_success( $active ); |
|
| 75 | - wp_die(); |
|
| 76 | - } |
|
| 77 | - |
|
| 78 | - /** |
|
| 79 | - * Get slug from path |
|
| 80 | - * |
|
| 81 | - * @param string $key |
|
| 82 | - * |
|
| 83 | - * @return string |
|
| 84 | - */ |
|
| 85 | - private function format_plugin_slug( $key ) { |
|
| 86 | - $slug = explode( '/', $key ); |
|
| 87 | - $slug = explode( '.', end( $slug ) ); |
|
| 88 | - |
|
| 89 | - return $slug[0]; |
|
| 90 | - } |
|
| 91 | - |
|
| 92 | - /** |
|
| 93 | - * Install and activate the AyeCode Connect Plugin |
|
| 94 | - */ |
|
| 95 | - public function ayecode_connect_install() { |
|
| 96 | - // bail if localhost |
|
| 97 | - if ( $this->is_localhost() ) { |
|
| 98 | - wp_send_json_error( $this->strings['error_localhost'] ); |
|
| 99 | - } |
|
| 100 | - |
|
| 101 | - // Explicitly clear the event. |
|
| 102 | - wp_clear_scheduled_hook( 'geodir_plugin_background_installer', func_get_args() ); |
|
| 103 | - |
|
| 104 | - $success = true; |
|
| 105 | - $plugin_slug = "ayecode-connect"; |
|
| 106 | - if ( ! empty( $plugin_slug ) ) { |
|
| 107 | - require_once( ABSPATH . 'wp-admin/includes/file.php' ); |
|
| 108 | - require_once( ABSPATH . 'wp-admin/includes/plugin-install.php' ); |
|
| 109 | - require_once( ABSPATH . 'wp-admin/includes/class-wp-upgrader.php' ); |
|
| 110 | - require_once( ABSPATH . 'wp-admin/includes/plugin.php' ); |
|
| 111 | - |
|
| 112 | - WP_Filesystem(); |
|
| 113 | - |
|
| 114 | - $skin = new Automatic_Upgrader_Skin; |
|
| 115 | - $upgrader = new WP_Upgrader( $skin ); |
|
| 116 | - $installed_plugins = array_map( array( $this, 'format_plugin_slug' ), array_keys( get_plugins() ) ); |
|
| 117 | - $plugin_slug = $plugin_slug; |
|
| 118 | - $plugin = $plugin_slug . '/' . $plugin_slug . '.php'; |
|
| 119 | - $installed = false; |
|
| 120 | - $activate = false; |
|
| 121 | - |
|
| 122 | - // See if the plugin is installed already |
|
| 123 | - if ( in_array( $plugin_slug, $installed_plugins ) ) { |
|
| 124 | - $installed = true; |
|
| 125 | - $activate = ! is_plugin_active( $plugin ); |
|
| 126 | - } |
|
| 127 | - |
|
| 128 | - // Install this thing! |
|
| 129 | - if ( ! $installed ) { |
|
| 130 | - |
|
| 131 | - // Suppress feedback |
|
| 132 | - ob_start(); |
|
| 133 | - |
|
| 134 | - try { |
|
| 135 | - $plugin_information = plugins_api( 'plugin_information', array( |
|
| 136 | - 'slug' => $plugin_slug, |
|
| 137 | - 'fields' => array( |
|
| 138 | - 'short_description' => false, |
|
| 139 | - 'sections' => false, |
|
| 140 | - 'requires' => false, |
|
| 141 | - 'rating' => false, |
|
| 142 | - 'ratings' => false, |
|
| 143 | - 'downloaded' => false, |
|
| 144 | - 'last_updated' => false, |
|
| 145 | - 'added' => false, |
|
| 146 | - 'tags' => false, |
|
| 147 | - 'homepage' => false, |
|
| 148 | - 'donate_link' => false, |
|
| 149 | - 'author_profile' => false, |
|
| 150 | - 'author' => false, |
|
| 151 | - ), |
|
| 152 | - ) ); |
|
| 153 | - |
|
| 154 | - if ( is_wp_error( $plugin_information ) ) { |
|
| 155 | - throw new Exception( $plugin_information->get_error_message() ); |
|
| 156 | - } |
|
| 157 | - |
|
| 158 | - $package = $plugin_information->download_link; |
|
| 159 | - $download = $upgrader->download_package( $package ); |
|
| 160 | - |
|
| 161 | - if ( is_wp_error( $download ) ) { |
|
| 162 | - throw new Exception( $download->get_error_message() ); |
|
| 163 | - } |
|
| 164 | - |
|
| 165 | - $working_dir = $upgrader->unpack_package( $download, true ); |
|
| 166 | - |
|
| 167 | - if ( is_wp_error( $working_dir ) ) { |
|
| 168 | - throw new Exception( $working_dir->get_error_message() ); |
|
| 169 | - } |
|
| 170 | - |
|
| 171 | - $result = $upgrader->install_package( array( |
|
| 172 | - 'source' => $working_dir, |
|
| 173 | - 'destination' => WP_PLUGIN_DIR, |
|
| 174 | - 'clear_destination' => false, |
|
| 175 | - 'abort_if_destination_exists' => false, |
|
| 176 | - 'clear_working' => true, |
|
| 177 | - 'hook_extra' => array( |
|
| 178 | - 'type' => 'plugin', |
|
| 179 | - 'action' => 'install', |
|
| 180 | - ), |
|
| 181 | - ) ); |
|
| 182 | - |
|
| 183 | - if ( is_wp_error( $result ) ) { |
|
| 184 | - throw new Exception( $result->get_error_message() ); |
|
| 185 | - } |
|
| 186 | - |
|
| 187 | - $activate = true; |
|
| 188 | - |
|
| 189 | - } catch ( Exception $e ) { |
|
| 190 | - $success = false; |
|
| 191 | - } |
|
| 192 | - |
|
| 193 | - // Discard feedback |
|
| 194 | - ob_end_clean(); |
|
| 195 | - } |
|
| 196 | - |
|
| 197 | - wp_clean_plugins_cache(); |
|
| 198 | - |
|
| 199 | - // Activate this thing |
|
| 200 | - if ( $activate ) { |
|
| 201 | - try { |
|
| 202 | - $result = activate_plugin( $plugin ); |
|
| 203 | - |
|
| 204 | - if ( is_wp_error( $result ) ) { |
|
| 205 | - $success = false; |
|
| 206 | - } else { |
|
| 207 | - $success = true; |
|
| 208 | - } |
|
| 209 | - } catch ( Exception $e ) { |
|
| 210 | - $success = false; |
|
| 211 | - } |
|
| 212 | - } |
|
| 213 | - } |
|
| 214 | - |
|
| 215 | - if ( $success && function_exists( 'ayecode_connect_args' ) ) { |
|
| 216 | - ayecode_connect();// init |
|
| 217 | - $args = ayecode_connect_args(); |
|
| 218 | - $client = new AyeCode_Connect( $args ); |
|
| 219 | - $redirect_to = ! empty( $_POST['redirect_to'] ) ? esc_url_raw( $_POST['redirect_to'] ) : ''; |
|
| 220 | - $redirect = $client->build_connect_url( $redirect_to ); |
|
| 221 | - wp_send_json_success( array( 'connect_url' => $redirect ) ); |
|
| 222 | - } else { |
|
| 223 | - wp_send_json_error( $this->strings['error_localhost'] ); |
|
| 224 | - } |
|
| 225 | - wp_die(); |
|
| 226 | - } |
|
| 227 | - |
|
| 228 | - /** |
|
| 229 | - * Check if maybe localhost. |
|
| 230 | - * |
|
| 231 | - * @return bool |
|
| 232 | - */ |
|
| 233 | - public function is_localhost() { |
|
| 234 | - $localhost = false; |
|
| 235 | - |
|
| 236 | - $host = isset( $_SERVER['HTTP_HOST'] ) ? $_SERVER['HTTP_HOST'] : ''; |
|
| 237 | - $localhost_domains = array( |
|
| 238 | - 'localhost', |
|
| 239 | - 'localhost.localdomain', |
|
| 240 | - '127.0.0.1', |
|
| 241 | - '::1' |
|
| 242 | - ); |
|
| 243 | - |
|
| 244 | - if ( in_array( $host, $localhost_domains ) ) { |
|
| 245 | - $localhost = true; |
|
| 246 | - } |
|
| 247 | - |
|
| 248 | - return $localhost; |
|
| 249 | - } |
|
| 250 | - |
|
| 251 | - /** |
|
| 252 | - * Show notice to connect site. |
|
| 253 | - */ |
|
| 254 | - public function ayecode_connect_install_notice() { |
|
| 255 | - if ( $this->maybe_show() ) { |
|
| 256 | - $connect_title_string = $this->strings['connect_title']; |
|
| 257 | - $connect_external_string = $this->strings['connect_external']; |
|
| 258 | - $connect_string = $this->strings['connect']; |
|
| 259 | - $connect_button_string = $this->strings['connect_button']; |
|
| 260 | - $connecting_button_string = $this->strings['connecting_button']; |
|
| 261 | - ?> |
|
| 7 | + /** |
|
| 8 | + * Allow the quick setup and connection of our AyeCode Connect plugin. |
|
| 9 | + * |
|
| 10 | + * Class AyeCode_Connect_Helper |
|
| 11 | + */ |
|
| 12 | + class AyeCode_Connect_Helper { |
|
| 13 | + |
|
| 14 | + // Hold the version number |
|
| 15 | + var $version = "1.0.4"; |
|
| 16 | + |
|
| 17 | + // Hold the default strings. |
|
| 18 | + var $strings = array(); |
|
| 19 | + |
|
| 20 | + // Hold the default pages. |
|
| 21 | + var $pages = array(); |
|
| 22 | + |
|
| 23 | + /** |
|
| 24 | + * The constructor. |
|
| 25 | + * |
|
| 26 | + * AyeCode_Connect_Helper constructor. |
|
| 27 | + * |
|
| 28 | + * @param array $strings |
|
| 29 | + * @param array $pages |
|
| 30 | + */ |
|
| 31 | + public function __construct( $strings = array(), $pages = array() ) { |
|
| 32 | + // Only fire if not localhost and the current user has the right permissions. |
|
| 33 | + if ( ! $this->is_localhost() && current_user_can( 'manage_options' ) ) { |
|
| 34 | + // set default strings |
|
| 35 | + $default_strings = array( |
|
| 36 | + 'connect_title' => __( "Thanks for choosing an AyeCode Product!", 'ayecode-connect' ), |
|
| 37 | + 'connect_external' => __( "Please confirm you wish to connect your site?", 'ayecode-connect' ), |
|
| 38 | + 'connect' => wp_sprintf( __( "<strong>Have a license?</strong> Forget about entering license keys or downloading zip files, connect your site for instant access. %slearn more%s", 'ayecode-connect' ), "<a href='https://ayecode.io/introducing-ayecode-connect/' target='_blank'>", "</a>" ), |
|
| 39 | + 'connect_button' => __( "Connect Site", 'ayecode-connect' ), |
|
| 40 | + 'connecting_button' => __( "Connecting...", 'ayecode-connect' ), |
|
| 41 | + 'error_localhost' => __( "This service will only work with a live domain, not a localhost.", 'ayecode-connect' ), |
|
| 42 | + 'error' => __( "Something went wrong, please refresh and try again.", 'ayecode-connect' ), |
|
| 43 | + ); |
|
| 44 | + $this->strings = array_merge( $default_strings, $strings ); |
|
| 45 | + |
|
| 46 | + // set default pages |
|
| 47 | + $default_pages = array(); |
|
| 48 | + $this->pages = array_merge( $default_pages, $pages ); |
|
| 49 | + |
|
| 50 | + // maybe show connect site notice |
|
| 51 | + add_action( 'admin_notices', array( $this, 'ayecode_connect_install_notice' ) ); |
|
| 52 | + |
|
| 53 | + // add ajax action if not already added |
|
| 54 | + if ( ! has_action( 'wp_ajax_ayecode_connect_helper' ) ) { |
|
| 55 | + add_action( 'wp_ajax_ayecode_connect_helper', array( $this, 'ayecode_connect_install' ) ); |
|
| 56 | + } |
|
| 57 | + } |
|
| 58 | + |
|
| 59 | + // add ajax action if not already added |
|
| 60 | + if ( ! has_action( 'wp_ajax_nopriv_ayecode_connect_helper_installed' ) ) { |
|
| 61 | + add_action( 'wp_ajax_nopriv_ayecode_connect_helper_installed', array( $this, 'ayecode_connect_helper_installed' ) ); |
|
| 62 | + } |
|
| 63 | + } |
|
| 64 | + |
|
| 65 | + /** |
|
| 66 | + * Give a way to check we can connect via a external redirect. |
|
| 67 | + */ |
|
| 68 | + public function ayecode_connect_helper_installed(){ |
|
| 69 | + $active = array( |
|
| 70 | + 'gd' => defined('GEODIRECTORY_VERSION') && version_compare(GEODIRECTORY_VERSION,'2.0.0.79','>') ? 1 : 0, |
|
| 71 | + 'uwp' => defined('USERSWP_VERSION') && version_compare(USERSWP_VERSION,'1.2.1.5','>') ? 1 : 0, |
|
| 72 | + 'wpi' => defined('WPINV_VERSION') && version_compare(WPINV_VERSION,'1.0.14','>') ? 1 : 0, |
|
| 73 | + ); |
|
| 74 | + wp_send_json_success( $active ); |
|
| 75 | + wp_die(); |
|
| 76 | + } |
|
| 77 | + |
|
| 78 | + /** |
|
| 79 | + * Get slug from path |
|
| 80 | + * |
|
| 81 | + * @param string $key |
|
| 82 | + * |
|
| 83 | + * @return string |
|
| 84 | + */ |
|
| 85 | + private function format_plugin_slug( $key ) { |
|
| 86 | + $slug = explode( '/', $key ); |
|
| 87 | + $slug = explode( '.', end( $slug ) ); |
|
| 88 | + |
|
| 89 | + return $slug[0]; |
|
| 90 | + } |
|
| 91 | + |
|
| 92 | + /** |
|
| 93 | + * Install and activate the AyeCode Connect Plugin |
|
| 94 | + */ |
|
| 95 | + public function ayecode_connect_install() { |
|
| 96 | + // bail if localhost |
|
| 97 | + if ( $this->is_localhost() ) { |
|
| 98 | + wp_send_json_error( $this->strings['error_localhost'] ); |
|
| 99 | + } |
|
| 100 | + |
|
| 101 | + // Explicitly clear the event. |
|
| 102 | + wp_clear_scheduled_hook( 'geodir_plugin_background_installer', func_get_args() ); |
|
| 103 | + |
|
| 104 | + $success = true; |
|
| 105 | + $plugin_slug = "ayecode-connect"; |
|
| 106 | + if ( ! empty( $plugin_slug ) ) { |
|
| 107 | + require_once( ABSPATH . 'wp-admin/includes/file.php' ); |
|
| 108 | + require_once( ABSPATH . 'wp-admin/includes/plugin-install.php' ); |
|
| 109 | + require_once( ABSPATH . 'wp-admin/includes/class-wp-upgrader.php' ); |
|
| 110 | + require_once( ABSPATH . 'wp-admin/includes/plugin.php' ); |
|
| 111 | + |
|
| 112 | + WP_Filesystem(); |
|
| 113 | + |
|
| 114 | + $skin = new Automatic_Upgrader_Skin; |
|
| 115 | + $upgrader = new WP_Upgrader( $skin ); |
|
| 116 | + $installed_plugins = array_map( array( $this, 'format_plugin_slug' ), array_keys( get_plugins() ) ); |
|
| 117 | + $plugin_slug = $plugin_slug; |
|
| 118 | + $plugin = $plugin_slug . '/' . $plugin_slug . '.php'; |
|
| 119 | + $installed = false; |
|
| 120 | + $activate = false; |
|
| 121 | + |
|
| 122 | + // See if the plugin is installed already |
|
| 123 | + if ( in_array( $plugin_slug, $installed_plugins ) ) { |
|
| 124 | + $installed = true; |
|
| 125 | + $activate = ! is_plugin_active( $plugin ); |
|
| 126 | + } |
|
| 127 | + |
|
| 128 | + // Install this thing! |
|
| 129 | + if ( ! $installed ) { |
|
| 130 | + |
|
| 131 | + // Suppress feedback |
|
| 132 | + ob_start(); |
|
| 133 | + |
|
| 134 | + try { |
|
| 135 | + $plugin_information = plugins_api( 'plugin_information', array( |
|
| 136 | + 'slug' => $plugin_slug, |
|
| 137 | + 'fields' => array( |
|
| 138 | + 'short_description' => false, |
|
| 139 | + 'sections' => false, |
|
| 140 | + 'requires' => false, |
|
| 141 | + 'rating' => false, |
|
| 142 | + 'ratings' => false, |
|
| 143 | + 'downloaded' => false, |
|
| 144 | + 'last_updated' => false, |
|
| 145 | + 'added' => false, |
|
| 146 | + 'tags' => false, |
|
| 147 | + 'homepage' => false, |
|
| 148 | + 'donate_link' => false, |
|
| 149 | + 'author_profile' => false, |
|
| 150 | + 'author' => false, |
|
| 151 | + ), |
|
| 152 | + ) ); |
|
| 153 | + |
|
| 154 | + if ( is_wp_error( $plugin_information ) ) { |
|
| 155 | + throw new Exception( $plugin_information->get_error_message() ); |
|
| 156 | + } |
|
| 157 | + |
|
| 158 | + $package = $plugin_information->download_link; |
|
| 159 | + $download = $upgrader->download_package( $package ); |
|
| 160 | + |
|
| 161 | + if ( is_wp_error( $download ) ) { |
|
| 162 | + throw new Exception( $download->get_error_message() ); |
|
| 163 | + } |
|
| 164 | + |
|
| 165 | + $working_dir = $upgrader->unpack_package( $download, true ); |
|
| 166 | + |
|
| 167 | + if ( is_wp_error( $working_dir ) ) { |
|
| 168 | + throw new Exception( $working_dir->get_error_message() ); |
|
| 169 | + } |
|
| 170 | + |
|
| 171 | + $result = $upgrader->install_package( array( |
|
| 172 | + 'source' => $working_dir, |
|
| 173 | + 'destination' => WP_PLUGIN_DIR, |
|
| 174 | + 'clear_destination' => false, |
|
| 175 | + 'abort_if_destination_exists' => false, |
|
| 176 | + 'clear_working' => true, |
|
| 177 | + 'hook_extra' => array( |
|
| 178 | + 'type' => 'plugin', |
|
| 179 | + 'action' => 'install', |
|
| 180 | + ), |
|
| 181 | + ) ); |
|
| 182 | + |
|
| 183 | + if ( is_wp_error( $result ) ) { |
|
| 184 | + throw new Exception( $result->get_error_message() ); |
|
| 185 | + } |
|
| 186 | + |
|
| 187 | + $activate = true; |
|
| 188 | + |
|
| 189 | + } catch ( Exception $e ) { |
|
| 190 | + $success = false; |
|
| 191 | + } |
|
| 192 | + |
|
| 193 | + // Discard feedback |
|
| 194 | + ob_end_clean(); |
|
| 195 | + } |
|
| 196 | + |
|
| 197 | + wp_clean_plugins_cache(); |
|
| 198 | + |
|
| 199 | + // Activate this thing |
|
| 200 | + if ( $activate ) { |
|
| 201 | + try { |
|
| 202 | + $result = activate_plugin( $plugin ); |
|
| 203 | + |
|
| 204 | + if ( is_wp_error( $result ) ) { |
|
| 205 | + $success = false; |
|
| 206 | + } else { |
|
| 207 | + $success = true; |
|
| 208 | + } |
|
| 209 | + } catch ( Exception $e ) { |
|
| 210 | + $success = false; |
|
| 211 | + } |
|
| 212 | + } |
|
| 213 | + } |
|
| 214 | + |
|
| 215 | + if ( $success && function_exists( 'ayecode_connect_args' ) ) { |
|
| 216 | + ayecode_connect();// init |
|
| 217 | + $args = ayecode_connect_args(); |
|
| 218 | + $client = new AyeCode_Connect( $args ); |
|
| 219 | + $redirect_to = ! empty( $_POST['redirect_to'] ) ? esc_url_raw( $_POST['redirect_to'] ) : ''; |
|
| 220 | + $redirect = $client->build_connect_url( $redirect_to ); |
|
| 221 | + wp_send_json_success( array( 'connect_url' => $redirect ) ); |
|
| 222 | + } else { |
|
| 223 | + wp_send_json_error( $this->strings['error_localhost'] ); |
|
| 224 | + } |
|
| 225 | + wp_die(); |
|
| 226 | + } |
|
| 227 | + |
|
| 228 | + /** |
|
| 229 | + * Check if maybe localhost. |
|
| 230 | + * |
|
| 231 | + * @return bool |
|
| 232 | + */ |
|
| 233 | + public function is_localhost() { |
|
| 234 | + $localhost = false; |
|
| 235 | + |
|
| 236 | + $host = isset( $_SERVER['HTTP_HOST'] ) ? $_SERVER['HTTP_HOST'] : ''; |
|
| 237 | + $localhost_domains = array( |
|
| 238 | + 'localhost', |
|
| 239 | + 'localhost.localdomain', |
|
| 240 | + '127.0.0.1', |
|
| 241 | + '::1' |
|
| 242 | + ); |
|
| 243 | + |
|
| 244 | + if ( in_array( $host, $localhost_domains ) ) { |
|
| 245 | + $localhost = true; |
|
| 246 | + } |
|
| 247 | + |
|
| 248 | + return $localhost; |
|
| 249 | + } |
|
| 250 | + |
|
| 251 | + /** |
|
| 252 | + * Show notice to connect site. |
|
| 253 | + */ |
|
| 254 | + public function ayecode_connect_install_notice() { |
|
| 255 | + if ( $this->maybe_show() ) { |
|
| 256 | + $connect_title_string = $this->strings['connect_title']; |
|
| 257 | + $connect_external_string = $this->strings['connect_external']; |
|
| 258 | + $connect_string = $this->strings['connect']; |
|
| 259 | + $connect_button_string = $this->strings['connect_button']; |
|
| 260 | + $connecting_button_string = $this->strings['connecting_button']; |
|
| 261 | + ?> |
|
| 262 | 262 | <div class="notice notice-info acch-notice"> |
| 263 | 263 | <span class="acch-float-left"> |
| 264 | 264 | <svg width="61px" height="61px" viewBox="0 0 61 61" version="1.1" |
@@ -305,9 +305,9 @@ discard block |
||
| 305 | 305 | </div> |
| 306 | 306 | |
| 307 | 307 | <?php |
| 308 | - // only include the popup HTML if needed. |
|
| 309 | - if ( ! empty( $_REQUEST['external-connect-request'] ) ) { |
|
| 310 | - ?> |
|
| 308 | + // only include the popup HTML if needed. |
|
| 309 | + if ( ! empty( $_REQUEST['external-connect-request'] ) ) { |
|
| 310 | + ?> |
|
| 311 | 311 | <div id="ayecode-connect-helper-external-confirm" style="display:none;"> |
| 312 | 312 | <div class="noticex notice-info acch-notice" style="border: none;"> |
| 313 | 313 | <span class="acch-float-left"> |
@@ -353,23 +353,23 @@ discard block |
||
| 353 | 353 | </div> |
| 354 | 354 | </div> |
| 355 | 355 | <?php |
| 356 | - } |
|
| 357 | - |
|
| 358 | - // add required scripts |
|
| 359 | - $this->script(); |
|
| 360 | - } |
|
| 361 | - } |
|
| 362 | - |
|
| 363 | - /** |
|
| 364 | - * Get the JS Script. |
|
| 365 | - */ |
|
| 366 | - public function script() { |
|
| 367 | - |
|
| 368 | - // add thickbox if external request is requested |
|
| 369 | - if ( ! empty( $_REQUEST['external-connect-request'] ) ) { |
|
| 370 | - add_thickbox(); |
|
| 371 | - } |
|
| 372 | - ?> |
|
| 356 | + } |
|
| 357 | + |
|
| 358 | + // add required scripts |
|
| 359 | + $this->script(); |
|
| 360 | + } |
|
| 361 | + } |
|
| 362 | + |
|
| 363 | + /** |
|
| 364 | + * Get the JS Script. |
|
| 365 | + */ |
|
| 366 | + public function script() { |
|
| 367 | + |
|
| 368 | + // add thickbox if external request is requested |
|
| 369 | + if ( ! empty( $_REQUEST['external-connect-request'] ) ) { |
|
| 370 | + add_thickbox(); |
|
| 371 | + } |
|
| 372 | + ?> |
|
| 373 | 373 | <style> |
| 374 | 374 | .acch-title { |
| 375 | 375 | margin: 0; |
@@ -435,38 +435,38 @@ discard block |
||
| 435 | 435 | }); |
| 436 | 436 | } |
| 437 | 437 | <?php |
| 438 | - // add thickbox if external request is requested |
|
| 439 | - if(! empty( $_REQUEST['external-connect-request'] )) { |
|
| 440 | - ?> |
|
| 438 | + // add thickbox if external request is requested |
|
| 439 | + if(! empty( $_REQUEST['external-connect-request'] )) { |
|
| 440 | + ?> |
|
| 441 | 441 | jQuery(function () { |
| 442 | 442 | setTimeout(function () { |
| 443 | 443 | tb_show("AyeCode Connect", "?TB_inline?width=300&height=80&inlineId=ayecode-connect-helper-external-confirm"); |
| 444 | 444 | }, 200); |
| 445 | 445 | }); |
| 446 | 446 | <?php |
| 447 | - } |
|
| 448 | - ?> |
|
| 447 | + } |
|
| 448 | + ?> |
|
| 449 | 449 | </script> |
| 450 | 450 | <?php |
| 451 | - } |
|
| 452 | - |
|
| 453 | - /** |
|
| 454 | - * Decide what pages to show on. |
|
| 455 | - * |
|
| 456 | - * @return bool |
|
| 457 | - */ |
|
| 458 | - public function maybe_show() { |
|
| 459 | - $show = false; |
|
| 460 | - |
|
| 461 | - // check if on a page set to show |
|
| 462 | - if ( isset( $_REQUEST['page'] ) && in_array( $_REQUEST['page'], $this->pages ) ) { |
|
| 463 | - // check if not active and connected |
|
| 464 | - if ( ! defined( 'AYECODE_CONNECT_VERSION' ) || ! get_option( 'ayecode_connect_blog_token' ) ) { |
|
| 465 | - $show = true; |
|
| 466 | - } |
|
| 467 | - } |
|
| 468 | - |
|
| 469 | - return $show; |
|
| 470 | - } |
|
| 471 | - } |
|
| 451 | + } |
|
| 452 | + |
|
| 453 | + /** |
|
| 454 | + * Decide what pages to show on. |
|
| 455 | + * |
|
| 456 | + * @return bool |
|
| 457 | + */ |
|
| 458 | + public function maybe_show() { |
|
| 459 | + $show = false; |
|
| 460 | + |
|
| 461 | + // check if on a page set to show |
|
| 462 | + if ( isset( $_REQUEST['page'] ) && in_array( $_REQUEST['page'], $this->pages ) ) { |
|
| 463 | + // check if not active and connected |
|
| 464 | + if ( ! defined( 'AYECODE_CONNECT_VERSION' ) || ! get_option( 'ayecode_connect_blog_token' ) ) { |
|
| 465 | + $show = true; |
|
| 466 | + } |
|
| 467 | + } |
|
| 468 | + |
|
| 469 | + return $show; |
|
| 470 | + } |
|
| 471 | + } |
|
| 472 | 472 | } |
