php – How do i fix Stripe Payment for Connected Accounts

Question

Hello i am having a problem with Stripe Payment from buyer. I want the buyer to be able to buy digital content from my platform and we keep a fee from the buyer. I want the purchase to be done in the backend. I use stripe in another occasion and it is implemented ok.

The seller account is created just fine and seller is verified from Stripe platform.
The payment from buyer is succeed at first and then failed. As i show you from my stripe test dashboard in the photo i shared i think the payment intent returns incomplete.
[![enter image description here][1]][1]

THE CODE
FRONT END

async initializePaymentElement() {
    try {
      // Collect payment details
      const paymentDetails = {
        amount: this.fractionsToPurchase * this.pricePerFraction * 100, // Amount in smallest currency unit (e.g., cents)
        currency: 'eur',
        email: this.user.email, // User email
        seller_connected_account_id: this.seller_connected_account_id, // Seller's Stripe account ID
      };
  
      console.log('Payment details being sent to backend:', paymentDetails);
  
      // Call backend to create Payment Intent
      const response: any = await this.userData.createPaymentIntent(paymentDetails).toPromise();
  
      console.log('Response from backend (createPaymentIntent):', response);
  
      if (response && response.clientSecret) {
        this.clientSecret = response.clientSecret;
        this.buyer_customer_id = response.customerId;
  
        console.log('Client secret received:', this.clientSecret);
        console.log('Buyer customer ID:', this.buyer_customer_id);
  
        // Load Stripe.js and initialize payment element
        if (!this.stripe) {
          this.stripe = await loadStripe('your-publishable-key');
        }
  
        if (!this.stripe) {
          console.error('Stripe.js failed to load');
          return;
        }
  
        this.elements = this.stripe.elements({ clientSecret: this.clientSecret });
        this.paymentElement = this.elements.create('payment');
  
        // Mount Payment Element
        const paymentElementContainer = document.getElementById('payment-element');
        if (paymentElementContainer) {
          this.paymentElement.mount(paymentElementContainer);
        }
  
        // Handle changes in the Payment Element
        this.paymentElement.on('change', (event: any) => {
          this.isPaymentElementFilled = event.complete;
          this.paymentError = event.error ? event.error.message : null;
        });
      } else {
        console.error('Failed to retrieve client secret or initialize Stripe.');
        this.paymentError="Failed to retrieve payment details.";
      }
    } catch (error) {
      console.error('Error during initializePaymentElement:', error);
      this.paymentError="Failed to initialize payment. Please try again.";
    }
  }
  
  async purchaseMediaFractions() {
    console.log("Starting purchaseMediaFractions...");
  
    // Validate `fractionsToPurchase`
    if (
      this.fractionsToPurchase > this.priceDetails?.fractions ||
      this.fractionsToPurchase < 1
    ) {
      console.error("Invalid fractions:", this.fractionsToPurchase);
      const toast = await this.toastController.create({
        message: "Please enter a valid number of fractions to purchase.",
        duration: 2000,
        color: "danger",
      });
      await toast.present();
      return;
    }
  
    const totalPrice = this.fractionsToPurchase * this.pricePerFraction;
    const platformFee = totalPrice * 0.1; // 10% platform fee
    const sellerEarnings = totalPrice - platformFee;
  
    if (!this.stripe) {
      console.error("Stripe instance is not initialized.");
      return;
    }
  
    const elements = this.elements;
    if (!elements) {
      console.error("Stripe Elements are not initialized.");
      return;
    }
  
    const paymentElement = this.paymentElement;
    if (!paymentElement) {
      console.error("Payment element is not mounted.");
      return;
    }
  
    try {
      // Confirm the payment with Stripe
      const { error, paymentIntent } = await this.stripe.confirmPayment({
        elements: this.elements,
        confirmParams: {
          payment_method_data: {
            billing_details: {
              email: this.user?.email, // Provide the buyer's email
            },
          },
        },
        redirect: "if_required", // Handle the redirect manually
      });
  
      if (error) {
        console.error("Payment confirmation error:", error.message);
        const toast = await this.toastController.create({
          message: `Payment failed: ${error.message}`,
          duration: 3000,
          color: "danger",
        });
        await toast.present();
        return;
      }
  
      if (paymentIntent?.status === "succeeded") {
        console.log("Payment successful:", paymentIntent);
  
        const toast = await this.toastController.create({
          message: "Payment successful!",
          duration: 3000,
          color: "success",
        });
        await toast.present();
  
        // Prepare purchase details for backend
        const purchaseDetails = {
          userId: this.user?.uid,
          mediaId: this.media?.msg_id,
          fractionsToPurchase: this.fractionsToPurchase,
          pricePerFraction: this.pricePerFraction,
          totalPrice,
          platformFee,
          sellerEarnings,
          sellerAccountId: this.seller_connected_account_id,
          buyerCustomerId: this.buyer_customer_id,
        };
  
        console.log("Purchase details:", purchaseDetails);
  
        // Call the backend
        this.userData.purchaseMediaFractions(purchaseDetails).subscribe(
          async (response: any) => {
            console.log("Backend response for purchaseMediaFractions:", response);
  
            const toast = await this.toastController.create({
              message: response.success ? response.message : response.error,
              duration: 2000,
              color: response.success ? "success" : "danger",
            });
            await toast.present();
  
            if (response.success) {
              console.log("Purchase completed successfully.");
              this.router.navigate(["/success"]);
            } else {
              console.error("Purchase failed:", response.error);
            }
          },
          async (error) => {
            console.error("HTTP error in purchaseMediaFractions:", error);
            const toast = await this.toastController.create({
              message: "An error occurred. Please try again later.",
              duration: 2000,
              color: "danger",
            });
            await toast.present();
          }
        );
      } else {
        console.error("Payment not completed:", paymentIntent?.status);
        const toast = await this.toastController.create({
          message: "Payment not completed.",
          duration: 3000,
          color: "warning",
        });
        await toast.present();
      }
    } catch (error) {
      console.error("Error during payment process:", error);
      const toast = await this.toastController.create({
        message: "An error occurred during payment. Please try again later.",
        duration: 3000,
        color: "danger",
      });
      await toast.present();
    }
  }

Services userData

createPaymentIntent(paymentDetails: any) {
        const url = this.appData.getApiUrl() + 'createPaymentIntent';
        const data = this.jsonToURLEncoded({
          api_signature: this.api_signature,
          ...paymentDetails, // Spread payment details into the request body
        });
      
        console.log('Calling createPaymentIntent API:', url);
        console.log('Request data:', data);
      
        return this.http.post(url, data, { headers: this.options }).pipe(
          tap((response: any) => {
            console.log('createPaymentIntent API response:', response);
          }),
          catchError((error) => {
            console.error('Error calling createPaymentIntent API:', error);
            throw error;
          })
        );
      }
      

    purchaseMediaFractions(purchaseDetails: any) {
        const url = this.appData.getApiUrl() + 'insertMediaPurchaseDetails';
        const data = {
            api_signature: this.api_signature,
            purchaseDetails: purchaseDetails // Send as a plain object
        };
    
        return this.http.post(url, JSON.stringify(data), {
            headers: this.options.set('Content-Type', 'application/json'),
        });
    }

AND PHP FUNCTIONS

function createPaymentIntent() {
    $request = \Slim\Slim::getInstance()->request();
    $response = ['success' => false];
  
    // Extract parameters sent from the frontend
    $apiSignature = $request->post('api_signature');
    $amount = intval($request->post('amount')); // Ensure amount is an integer
    $currency = $request->post('currency');
    $email = $request->post('email');
    $sellerAccountId = $request->post('seller_connected_account_id'); // Seller's connected account ID

    error_log("Received API Signature: $apiSignature, Amount: $amount, Currency: $currency, Email: $email, Seller Account ID: $sellerAccountId");

    try {
        // Validate parameters
        if (!$amount || $amount <= 0) {
            throw new Exception("Invalid amount: Amount must be greater than 0.");
        }

        if (empty($email)) {
            throw new Exception("Invalid email: Email address is required.");
        }

        if (empty($sellerAccountId)) {
            throw new Exception("Invalid seller account ID: This is required.");
        }

        // Create a new Stripe Customer
        $customer = \Stripe\Customer::create([
            'email' => $email,
            'description' => 'One-time customer for purchase',
        ]);
        error_log("Stripe Customer Created: " . json_encode($customer));

        $buyerCustomerId = $customer->id;
        if (empty($buyerCustomerId)) {
            throw new Exception("Failed to create a Stripe customer.");
        }

        // Calculate Platform Fee (e.g., 10%)
        $applicationFeeAmount = intval($amount * 0.10); // Platform fee

        // Create the PaymentIntent
        $paymentIntentParams = [
            'amount' => $amount, // Amount in smallest currency unit (e.g., cents)
            'currency' => $currency,
            'customer' => $buyerCustomerId,
            'description' => 'Purchase',
            'transfer_data' => [
                'destination' => $sellerAccountId, // Connected seller account
            ],
            'application_fee_amount' => $applicationFeeAmount,
        ];
        error_log("PaymentIntent Parameters: " . json_encode($paymentIntentParams));

        $paymentIntent = \Stripe\PaymentIntent::create($paymentIntentParams);
        error_log("PaymentIntent Created: " . json_encode($paymentIntent));

        // Build the response with PaymentIntent details
        $response = [
            'success' => true,
            'paymentIntentId' => $paymentIntent->id,
            'clientSecret' => $paymentIntent->client_secret,
            'customerId' => $buyerCustomerId,
            'amount' => $amount,
            'currency' => $currency,
        ];
    } catch (\Stripe\Exception\ApiErrorException $e) {
        // Stripe-specific error
        error_log("Stripe API Error: " . $e->getMessage());
        $response = [
            'success' => false,
            'error' => $e->getMessage(),
        ];
    } catch (Exception $e) {
        // General error
        error_log("General Error: " . $e->getMessage());
        $response = [
            'success' => false,
            'error' => $e->getMessage(),
        ];
    }

    // Return response as JSON
    echo json_encode($response);
}

  
function insertMediaPurchaseDetails() {
    error_log('Function Called: insertMediaPurchaseDetails');

    $request = \Slim\Slim::getInstance()->request();
    $data = json_decode($request->getBody(), true);
    $purchaseDetails = $data['purchaseDetails'] ?? null;

    error_log('Request Body: ' . $request->getBody());

    // Validate purchase details
    if (!$purchaseDetails || !isset($purchaseDetails['userId'], $purchaseDetails['mediaId'], $purchaseDetails['fractionsToPurchase'], $purchaseDetails['pricePerFraction'], $purchaseDetails['totalPrice'], $purchaseDetails['platformFee'], $purchaseDetails['sellerEarnings'])) {
        error_log('Invalid Purchase Details: ' . print_r($purchaseDetails, true));
        echo json_encode(['error' => 'Invalid purchase details provided']);
        return;
    }

    // Log extracted values
    error_log('Extracted Purchase Details: ' . print_r($purchaseDetails, true));

    // Set Stripe API key
    Stripe::setApiKey('sk_test_51HiSUoGozbMWFnurBqY9URXX7pEVd0Rwnm9kyyyXuOr9pKNluCdpNp522HiGN65djoplcuJcCKjiXqtFBgZoM4f000XfvRgSgi');

    try {
        // Create the PaymentIntent
        $paymentIntent = \Stripe\PaymentIntent::create([
            'amount' => intval($purchaseDetails['totalPrice'] * 100), // Amount in cents
            'currency' => 'eur',
            'payment_method_types' => ['card'],
            'transfer_data' => [
                'destination' => $purchaseDetails['sellerAccountId'],
            ],
        ]);
        error_log('PaymentIntent Created: ' . json_encode($paymentIntent));

        // Log PaymentIntent status
        if ($paymentIntent->status !== 'succeeded') {
            error_log('PaymentIntent Status: ' . $paymentIntent->status);
            error_log('PaymentIntent Full Response: ' . print_r($paymentIntent, true));
            echo json_encode(['error' => 'Payment failed']);
            return;
        }

        // Proceed with database operations
        $db = getDB();
        $db->beginTransaction();
        error_log('Database Transaction Started');

        // Insert purchase details
        $insertSql = "INSERT INTO media_purchases (msg_id_fk, buyer_uid_fk, fraction_count, purchase_price, total_price, platform_fee, seller_earnings, purchase_date) 
                      VALUES (?, ?, ?, ?, ?, ?, ?, NOW())";
        $stmt = $db->prepare($insertSql);
        if (!$stmt->execute([$purchaseDetails['mediaId'], $purchaseDetails['userId'], $purchaseDetails['fractionsToPurchase'], $purchaseDetails['pricePerFraction'], $purchaseDetails['totalPrice'], $purchaseDetails['platformFee'], $purchaseDetails['sellerEarnings']])) {
            error_log('Failed to Insert Media Purchase: ' . json_encode($stmt->errorInfo()));
            throw new Exception('Failed to insert purchase details');
        }
        error_log('Media Purchase Inserted Successfully');

        // Commit transaction
        $db->commit();
        error_log('Database Transaction Committed Successfully');

        echo json_encode(['success' => true, 'message' => 'Purchase completed successfully']);
    } catch (\Stripe\Exception\ApiErrorException $e) {
        error_log('Stripe API Error: ' . $e->getMessage());
        echo json_encode(['error' => 'Transaction failed']);
    } catch (Exception $e) {
        error_log('General Error: ' . $e->getMessage());
        if (isset($db) && $db->inTransaction()) {
            $db->rollBack();
            error_log('Database Transaction Rolled Back');
        }
        echo json_encode(['error' => 'Transaction failed']);
    }
}

THE CONSOLE RETURNS THESE

Payment details being sent to backend: {amount: 300, currency: 'eur', email: '[email protected]', seller_connected_account_id: 'acct_1Qevz92eCjM0J1d3'}
user-data.ts:541 Calling createPaymentIntent API: https://project.com/api/api/createPaymentIntent
user-data.ts:542 Request data: api_signature=bcbf2fd292fa27b76d509742cdc007e2&amount=300&currency=eur&email=pellapost%40outlook.com&seller_connected_account_id=acct_1Qevz92eCjM0J1d3
user-data.ts:546 createPaymentIntent API response: {success: true, paymentIntentId: 'pi_3QgjzmGozbMWFnur0N7W0dLL', clientSecret: 'pi_3QgjzmGozbMWFnur0N7W0dLL_secret_j4J2sGD89jO3gjFgETtktYe4A', customerId: 'cus_RZtnd76eH7eIVl', amount: 300, …}
sell-details.page.ts:610 Response from backend (createPaymentIntent): {success: true, paymentIntentId: 'pi_3QgjzmGozbMWFnur0N7W0dLL', clientSecret: 'pi_3QgjzmGozbMWFnur0N7W0dLL_secret_j4J2sGD89jO3gjFgETtktYe4A', customerId: 'cus_RZtnd76eH7eIVl', amount: 300, …}
sell-details.page.ts:616 Client secret received: pi_3QgjzmGozbMWFnur0N7W0dLL_secret_j4J2sGD89jO3gjFgETtktYe4A
sell-details.page.ts:617 Buyer customer ID: cus_RZtnd76eH7eIVl

sell-details.page.ts:654 Starting purchaseMediaFractions...
sell-details.page.ts:718 Payment successful: {id: 'pi_3QgjzmGozbMWFnur0N7W0dLL', object: 'payment_intent', amount: 300, amount_details: {…}, automatic_payment_methods: {…}, …}

sell-details.page.ts:740 Purchase details: {userId: '1122', mediaId: '815', fractionsToPurchase: 3, pricePerFraction: '1.00', totalPrice: 3, …}
sell-details.page.ts:745 Backend response for purchaseMediaFractions: {error: 'Payment failed'}
sell-details.page.ts:758 Purchase failed: Payment failed

and the error logs from php functions are these

What am i doing wrong? Thanks in advance
[1]: https://i.sstatic.net/DdkrgZS4.png

What is Physics? Definition, History, Importance, Scope (Class 11)

The Living World – Introduction, Classification, Characteristics, FAQs (Class 11 ...

Explain - Biological Classification (Class 11 - Biology)

Sign Up

Sign In

Forgot Password

StackOverflow Latest Questions

php – How do i fix Stripe Payment for Connected Accounts

Leave an answerCancel reply

Leave an answer
Cancel reply