Notes

If the subscription renewal is not updating the subscription details in your database, the issue is likely with the webhook processing logic. Specifically, the webhook for `invoice.payment_succeeded` (triggered during renewals) is not updating the subscription status or payment history in your database.

Here’s how to fix it:

---

### **1. Common Reasons for Renewal Not Updating**
1. **Webhook Missing Logic**: Your `invoice.payment_succeeded` webhook handler might not update the subscription in the database during renewal.
2. **Incorrect Stripe Customer Mapping**: The `customer` field in the webhook payload is not being mapped to the correct user in your database.
3. **Subscription Status Not Updated**: The renewal logic does not update fields like `expire_date`, `days_left`, or `status`.

---

### **2. Updated Webhook Logic for Renewal**

Update the webhook handling code to process renewals correctly:

```php
public function handleInvoicePaymentSucceeded($event)
{
try {
// Extract data from the webhook payload
$stripeCustomerId = $event['data']['object']['customer']; // Stripe Customer ID
$invoice = $event['data']['object']; // Invoice object

// Find the user based on the Stripe customer ID
$user = User::where('stripe_customer_id', $stripeCustomerId)->first();

if (!$user) {
Log::warning('No user found for Stripe customer ID: ' . $stripeCustomerId);
return response('User not found', 404);
}

// Extract subscription details
$subscriptionId = $invoice['subscription'];
$amountPaid = $invoice['amount_paid'] / 100; // Convert from cents to dollars
$currentPeriodEnd = Carbon::createFromTimestamp($invoice['lines']['data'][0]['period']['end']);
$currentPeriodStart = Carbon::createFromTimestamp($invoice['lines']['data'][0]['period']['start']);

// Update the payment history or subscription details
$paymentHistory = PaymentHistory::where('transaction_id', $subscriptionId)->first();

if ($paymentHistory) {
// Renewal: Update the existing record
$paymentHistory->update([
'start_date' => $currentPeriodStart,
'expire_date' => $currentPeriodEnd,
'amount' => $amountPaid,
'status' => 1, // Mark as active
'days_left' => $currentPeriodEnd->diffInDays(now()),
]);
} else {
// First-time payment or missing record: Create a new record
PaymentHistory::create([
'user_id' => $user->id,
'plan_id' => $user->plan_id, // Assuming the plan is stored in the user table
'start_date' => $currentPeriodStart,
'expire_date' => $currentPeriodEnd,
'amount' => $amountPaid,
'transaction_id' => $subscriptionId,
'status' => 1,
'days_left' => $currentPeriodEnd->diffInDays(now()),
'mode' => 'card',
'payout_status' => 1,
]);
}

// Update the user's subscription details
$user->update([
'is_payment' => 1,
'plan_id' => $user->plan_id, // Update to the renewed plan if necessary
]);

Log::info('Subscription renewed successfully for user ID: ' . $user->id);
return response('Webhook handled successfully', 200);
} catch (Exception $e) {
Log::error('Error processing webhook: ' . $e->getMessage());
return response('Webhook handling failed', 500);
}
}
```

---

### **3. Key Changes in the Code**
1. **Find the User by `stripe_customer_id`:**
- Ensure the `stripe_customer_id` in the webhook payload matches a user in your database.

2. **Update Payment History:**
- Check if the payment record already exists for the `subscription_id` (from Stripe).
- Update the `start_date`, `expire_date`, `amount`, and `status` fields for renewals.

3. **Create Missing Records:**
- If no payment history exists for the subscription, create a new record.

4. **Update User Subscription:**
- Update the `is_payment` and `plan_id` fields for the user to reflect the renewed subscription.

---

### **4. Test the Changes**
1. **Trigger Renewal:**
- Use Stripe’s dashboard or CLI to simulate a subscription renewal (`invoice.payment_succeeded`).

2. **Verify Database Updates:**
- Check if the `PaymentHistory` table is updated with the new `start_date`, `expire_date`, and `amount`.
- Ensure the `users` table reflects the updated subscription.

3. **Log Validation:**
- Check the logs for success messages like `Subscription renewed successfully for user ID`.

---

### **5. Additional Recommendations**
- **Retry Logic:** Ensure your webhook endpoint is idempotent (doesn’t duplicate records if called multiple times).
- **Test Other Scenarios:**
- What happens if the user cancels a subscription?
- Does it handle multiple plans correctly?

This should fix the renewal issue and ensure the database is updated during subscription renewals. Let me know if you encounter any issues!