Implement Renewal Flow

[guillermoscript]

Allow the user to renew their current plan with minimal changes required.

• Acceptance Criteria:
  • The system allows the user to renew their current plan with minimal changes required (e.g., payment information)
  • The renewal flow provides options for upgrading or downgrading plans

[guillermoscript]

Summary Workflow

1. Identify Subscriptions Due for Renewal: Daily checks using notify_users_for_renewal function scheduled by pg_cron.
2. Notify Users: Notify users within 15 days of expiry to renew.
3. User-Initiated Renewal: When the user clicks the renewal button, trigger create_transaction_for_renewal function.
4. Process New Transactions: Managed by trigger_manage_transactions, updating subscription details upon successful payment.

Using pg_cron, we maintain a timely reminder system, and by integrating the frontend button logic, users can manually trigger renewals, ensuring a robust and user-friendly renewal process.