<?php

[0] Fix | Delete

[1] Fix | Delete

namespace WPForms\Tasks\Actions;

[2] Fix | Delete

[3] Fix | Delete

use WPForms\Integrations\Stripe\Api\PaymentIntents;

[4] Fix | Delete

use WPForms\Tasks\Task;

[5] Fix | Delete

use WPForms\Integrations\Stripe\Helpers;

[6] Fix | Delete

[7] Fix | Delete

/**

[8] Fix | Delete

* Class StripeLinkSubscriptionsTask.

[9] Fix | Delete

*

[10] Fix | Delete

* @since 1.8.7

[11] Fix | Delete

*/

[12] Fix | Delete

class StripeLinkSubscriptionsTask extends Task {

[13] Fix | Delete

[14] Fix | Delete

/**

[15] Fix | Delete

* Action name for this task.

[16] Fix | Delete

*

[17] Fix | Delete

* @since 1.8.7

[18] Fix | Delete

*/

[19] Fix | Delete

const ACTION = 'wpforms_process_stripe_link_subscriptions';

[20] Fix | Delete

[21] Fix | Delete

/**

[22] Fix | Delete

* Status option name.

[23] Fix | Delete

*

[24] Fix | Delete

* @since 1.8.7

[25] Fix | Delete

*/

[26] Fix | Delete

const STATUS = 'wpforms_process_stripe_link_subscriptions_status';

[27] Fix | Delete

[28] Fix | Delete

/**

[29] Fix | Delete

* Start status.

[30] Fix | Delete

*

[31] Fix | Delete

* @since 1.8.7

[32] Fix | Delete

*/

[33] Fix | Delete

const START = 'start';

[34] Fix | Delete

[35] Fix | Delete

/**

[36] Fix | Delete

* In progress status.

[37] Fix | Delete

*

[38] Fix | Delete

* @since 1.8.7

[39] Fix | Delete

*/

[40] Fix | Delete

const IN_PROGRESS = 'in_progress';

[41] Fix | Delete

[42] Fix | Delete

/**

[43] Fix | Delete

* Completed status.

[44] Fix | Delete

*

[45] Fix | Delete

* @since 1.8.7

[46] Fix | Delete

*/

[47] Fix | Delete

const COMPLETED = 'completed';

[48] Fix | Delete

[49] Fix | Delete

/**

[50] Fix | Delete

* Latest processed payment id.

[51] Fix | Delete

*

[52] Fix | Delete

* @since 1.8.7

[53] Fix | Delete

*/

[54] Fix | Delete

const LATEST_PROCESSED_OPTION = 'wpforms_stripe_link_subscriptions_latest_processed';

[55] Fix | Delete

[56] Fix | Delete

/**

[57] Fix | Delete

* Stripe PaymentIntents API.

[58] Fix | Delete

*

[59] Fix | Delete

* @since 1.8.7

[60] Fix | Delete

*

[61] Fix | Delete

* @var PaymentIntents

[62] Fix | Delete

*/

[63] Fix | Delete

private $api;

[64] Fix | Delete

[65] Fix | Delete

/**

[66] Fix | Delete

* Log title.

[67] Fix | Delete

*

[68] Fix | Delete

* @since 1.9.1

[69] Fix | Delete

*

[70] Fix | Delete

* @var string

[71] Fix | Delete

*/

[72] Fix | Delete

protected $log_title = 'Migration';

[73] Fix | Delete

[74] Fix | Delete

/**

[75] Fix | Delete

* Class constructor.

[76] Fix | Delete

*

[77] Fix | Delete

* @since 1.8.7

[78] Fix | Delete

*/

[79] Fix | Delete

public function __construct() {

[80] Fix | Delete

[81] Fix | Delete

parent::__construct( self::ACTION );

[82] Fix | Delete

}

[83] Fix | Delete

[84] Fix | Delete

/**

[85] Fix | Delete

* Initialize the task.

[86] Fix | Delete

*

[87] Fix | Delete

* @since 1.8.7

[88] Fix | Delete

*/

[89] Fix | Delete

public function init() {

[90] Fix | Delete

[91] Fix | Delete

// Get a task status.

[92] Fix | Delete

$status = get_option( self::STATUS );

[93] Fix | Delete

[94] Fix | Delete

// This task is run in \WPForms\Migrations\Upgrade187::run(),

[95] Fix | Delete

// and started in \WPForms\Migrations\UpgradeBase::run_async().

[96] Fix | Delete

// Bail out if a task is not started or completed.

[97] Fix | Delete

if ( ! $status || $status === self::COMPLETED ) {

[98] Fix | Delete

return;

[99] Fix | Delete

}

[100] Fix | Delete

[101] Fix | Delete

// Mark that the task is in progress.

[102] Fix | Delete

if ( $status === self::START ) {

[103] Fix | Delete

update_option( self::STATUS, self::IN_PROGRESS );

[104] Fix | Delete

}

[105] Fix | Delete

[106] Fix | Delete

// Register hooks.

[107] Fix | Delete

$this->hooks();

[108] Fix | Delete

[109] Fix | Delete

$tasks = wpforms()->obj( 'tasks' );

[110] Fix | Delete

[111] Fix | Delete

// Add new if none exists.

[112] Fix | Delete

if ( $tasks->is_scheduled( self::ACTION ) !== false ) {

[113] Fix | Delete

return;

[114] Fix | Delete

}

[115] Fix | Delete

[116] Fix | Delete

// Add a new task if none exists.

[117] Fix | Delete

$tasks->create( self::ACTION )

[118] Fix | Delete

->async()

[119] Fix | Delete

->register();

[120] Fix | Delete

}

[121] Fix | Delete

[122] Fix | Delete

/**

[123] Fix | Delete

* Register hooks.

[124] Fix | Delete

*

[125] Fix | Delete

* @since 1.8.7

[126] Fix | Delete

*/

[127] Fix | Delete

private function hooks() {

[128] Fix | Delete

[129] Fix | Delete

// Register the migrate action.

[130] Fix | Delete

add_action( self::ACTION, [ $this, 'run' ] );

[131] Fix | Delete

}

[132] Fix | Delete

[133] Fix | Delete

/**

[134] Fix | Delete

* Run a process task.

[135] Fix | Delete

*

[136] Fix | Delete

* @since 1.8.7

[137] Fix | Delete

*/

[138] Fix | Delete

public function run() {

[139] Fix | Delete

[140] Fix | Delete

// Bail if no Stripe account is connected.

[141] Fix | Delete

if ( ! Helpers::has_stripe_keys() ) {

[142] Fix | Delete

$this->complete();

[143] Fix | Delete

[144] Fix | Delete

return;

[145] Fix | Delete

}

[146] Fix | Delete

[147] Fix | Delete

$link_subscriptions = $this->get_link_subscriptions();

[148] Fix | Delete

[149] Fix | Delete

// Bail if all subscription were processed.

[150] Fix | Delete

if ( empty( $link_subscriptions ) ) {

[151] Fix | Delete

$this->complete();

[152] Fix | Delete

[153] Fix | Delete

return;

[154] Fix | Delete

}

[155] Fix | Delete

[156] Fix | Delete

$this->api = new PaymentIntents();

[157] Fix | Delete

[158] Fix | Delete

$this->process( $link_subscriptions );

[159] Fix | Delete

}

[160] Fix | Delete

[161] Fix | Delete

/**

[162] Fix | Delete

* Process subscriptions.

[163] Fix | Delete

*

[164] Fix | Delete

* @since 1.8.7

[165] Fix | Delete

*

[166] Fix | Delete

* @param array $subscriptions Array of subscriptions.

[167] Fix | Delete

*/

[168] Fix | Delete

private function process( array $subscriptions ) {

[169] Fix | Delete

[170] Fix | Delete

foreach ( $subscriptions as $subscription ) {

[171] Fix | Delete

[172] Fix | Delete

$this->update_latest_processed( $subscription->id );

[173] Fix | Delete

[174] Fix | Delete

// Use subscription mode to cover all cases (e.g. mode might be switched to test while upgrading).

[175] Fix | Delete

$payment = $this->api->retrieve_payment_intent( $subscription->transaction_id, [ 'mode' => $subscription->mode ] );

[176] Fix | Delete

[177] Fix | Delete

// Bail if original payment was unsuccessful.

[178] Fix | Delete

if ( is_null( $payment ) || empty( $payment->status ) || $payment->status !== 'succeeded' ) {

[179] Fix | Delete

continue;

[180] Fix | Delete

}

[181] Fix | Delete

[182] Fix | Delete

$setup_intent_data = $this->prepare_setup_intent_data( $payment, $subscription );

[183] Fix | Delete

[184] Fix | Delete

// Bail if subscription has already had correct mandate.

[185] Fix | Delete

if ( ! $setup_intent_data ) {

[186] Fix | Delete

continue;

[187] Fix | Delete

}

[188] Fix | Delete

[189] Fix | Delete

$intent = $this->api->create_setup_intent( $setup_intent_data, [ 'mode' => $subscription->mode ] );

[190] Fix | Delete

[191] Fix | Delete

// Log failed subscription payment id.

[192] Fix | Delete

if ( empty( $intent ) ) {

[193] Fix | Delete

$this->log( 'Stripe Link Subscriptions: Failed ' . $subscription->id );

[194] Fix | Delete

}

[195] Fix | Delete

}

[196] Fix | Delete

}

[197] Fix | Delete

[198] Fix | Delete

/**

[199] Fix | Delete

* Update latest processed id.

[200] Fix | Delete

*

[201] Fix | Delete

* @since 1.8.7

[202] Fix | Delete

*

[203] Fix | Delete

* @param int $id Subscription ID.

[204] Fix | Delete

*/

[205] Fix | Delete

private function update_latest_processed( int $id ) {

[206] Fix | Delete

[207] Fix | Delete

update_option( self::LATEST_PROCESSED_OPTION, $id );

[208] Fix | Delete

}

[209] Fix | Delete

[210] Fix | Delete

/**

[211] Fix | Delete

* Get all Stripe subscriptions charged through Link.

[212] Fix | Delete

*

[213] Fix | Delete

* @since 1.8.7

[214] Fix | Delete

*

[215] Fix | Delete

* @return array

[216] Fix | Delete

*/

[217] Fix | Delete

private function get_link_subscriptions(): array {

[218] Fix | Delete

[219] Fix | Delete

global $wpdb;

[220] Fix | Delete

[221] Fix | Delete

$latest_payment = (int) get_option( self::LATEST_PROCESSED_OPTION, 0 );

[222] Fix | Delete

$payments_table = wpforms()->obj( 'payment' )->table_name;

[223] Fix | Delete

$paymentmeta_table = wpforms()->obj( 'payment_meta' )->table_name;

[224] Fix | Delete

[225] Fix | Delete

$query[] = "SELECT p.* FROM {$payments_table} as p";

[226] Fix | Delete

$query[] = "INNER JOIN {$paymentmeta_table} as pm ON p.id = pm.payment_id";

[227] Fix | Delete

$query[] = "WHERE p.id > %d AND p.gateway = 'stripe' AND p.type = 'subscription' AND pm.meta_key = 'method_type' AND pm.meta_value = 'link'";

[228] Fix | Delete

[229] Fix | Delete

// Stripe API allows up to 100 read operations per second and 100 write operations per second in live mode,

[230] Fix | Delete

// and 25 operations per second for each in test mode.

[231] Fix | Delete

$query[] = 'ORDER BY p.id LIMIT 20';

[232] Fix | Delete

[233] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare

[234] Fix | Delete

return $wpdb->get_results( $wpdb->prepare( implode( ' ', $query ), $latest_payment ), OBJECT_K );

[235] Fix | Delete

}

[236] Fix | Delete

[237] Fix | Delete

/**

[238] Fix | Delete

* Prepare Setup Intent data.

[239] Fix | Delete

*

[240] Fix | Delete

* @since 1.8.7

[241] Fix | Delete

*

[242] Fix | Delete

* @param object $payment Stripe payment object.

[243] Fix | Delete

* @param object $subscription Subscription object.

[244] Fix | Delete

*

[245] Fix | Delete

* @return array

[246] Fix | Delete

*/

[247] Fix | Delete

private function prepare_setup_intent_data( $payment, $subscription ): array {

[248] Fix | Delete

[249] Fix | Delete

if ( ! empty( $payment->mandate ) ) {

[250] Fix | Delete

$mandate = $this->api->retrieve_mandate( $payment->mandate, [ 'mode' => $subscription->mode ] );

[251] Fix | Delete

}

[252] Fix | Delete

[253] Fix | Delete

$data = [

[254] Fix | Delete

'payment_method_types' => [ 'link' ],

[255] Fix | Delete

'customer' => $payment->customer,

[256] Fix | Delete

'payment_method' => $payment->payment_method,

[257] Fix | Delete

'usage' => 'off_session',

[258] Fix | Delete

'confirm' => true,

[259] Fix | Delete

];

[260] Fix | Delete

[261] Fix | Delete

// Prepare default data in case mandate is not available.

[262] Fix | Delete

if ( empty( $mandate ) ) {

[263] Fix | Delete

[264] Fix | Delete

$subscription_meta = wpforms()->obj( 'payment_meta' )->get_all( $subscription->id );

[265] Fix | Delete

[266] Fix | Delete

$data['mandate_data'] = [

[267] Fix | Delete

'customer_acceptance' => [

[268] Fix | Delete

'type' => 'online',

[269] Fix | Delete

'online' => [

[270] Fix | Delete

'ip_address' => $subscription_meta['ip_address']->value,

[271] Fix | Delete

'user_agent' => $subscription_meta['user_agent']->value,

[272] Fix | Delete

],

[273] Fix | Delete

],

[274] Fix | Delete

];

[275] Fix | Delete

[276] Fix | Delete

return $data;

[277] Fix | Delete

}

[278] Fix | Delete

[279] Fix | Delete

// Mandate is correct so no actions needed.

[280] Fix | Delete

if ( $mandate->type !== 'single_use' ) {

[281] Fix | Delete

return [];

[282] Fix | Delete

}

[283] Fix | Delete

[284] Fix | Delete

$data['mandate_data'] = [

[285] Fix | Delete

'customer_acceptance' => [

[286] Fix | Delete

'type' => 'online',

[287] Fix | Delete

'online' => [

[288] Fix | Delete

'ip_address' => $mandate->customer_acceptance->online->ip_address,

[289] Fix | Delete

'user_agent' => $mandate->customer_acceptance->online->user_agent,

[290] Fix | Delete

],

[291] Fix | Delete

],

[292] Fix | Delete

];

[293] Fix | Delete

[294] Fix | Delete

return $data;

[295] Fix | Delete

}

[296] Fix | Delete

[297] Fix | Delete

/**

[298] Fix | Delete

* Mark that the task is completed.

[299] Fix | Delete

*

[300] Fix | Delete

* @since 1.8.7

[301] Fix | Delete

*/

[302] Fix | Delete

public function complete() {

[303] Fix | Delete

[304] Fix | Delete

$this->log( 'Stripe Link Subscriptions: Completed' );

[305] Fix | Delete

[306] Fix | Delete

update_option( self::STATUS, self::COMPLETED );

[307] Fix | Delete

}

[308] Fix | Delete

}

[309] Fix | Delete

[310] Fix | Delete