Memory Wiki

Let me find the actual paths for the view files and main plugin directory.

Let me check the existing admin CSS for card styling patterns.

Now I have a complete picture. Let me implement all changes. I'll start with the modifications and new files. **1. MODIFY class-triggers.php** — Add 3 new subscription triggers:

**2. MODIFY class-actions.php** — Add `update_membership_level` action:

Now add the `update_membership_level` case to the execute switch:

Now add the `execute_update_membership_level` method before `get_contact`:

**3. CREATE billing-settings.php**:

**4. MODIFY class-admin.php** — Add billing submenu page:

Now add the `render_billing` method:

**5. MODIFY dashboard.php** — Add MRR/Revenue section and billing stats:

**6. MODIFY contact-detail.php** — Add Subscription tab:

Let me verify all changes are correctly applied by reviewing the modified files:

All changes verified successfully. Here's the summary: --- ## Summary of Changes ### Files Modified (4) 1. **`includes/class-triggers.php`** — Added 3 new subscription triggers to `register_defaults()`: - `subscription_created` — fires when a user subscribes to a paid plan - `subscription_cancelled` — fires when a user cancels their subscription - `subscription_renewed` — fires when a subscription is renewed (invoice paid) 2. **`includes/class-actions.php`** — Added `update_membership_level` action: - Registered with settings schema: `{level: int (required)}` - `execute_update_membership_level()` method creates/updates a `membership_level` row in `profe_main.profe_user_meta` via PDO upsert - Wired into the `execute()` switch statement 3. **`includes/class-admin.php`** — Added "Billing" submenu page: - Slug: `profe-crm-billing`, parent: `profe-crm`, capability: `manage_options` - New `render_billing()` method includes `billing-settings.php` 4. **`admin/views/dashboard.php`** — Added MRR & Revenue section: - New `profe_crm_get_billing_stats()` helper function with static PDO caching - **6 new cards** below the existing ones: MRR ($), Active Subscribers, Churn Rate (30d), Average LTV, Revenue This Month, Lite/Standard Sub counts - **Recent Transactions table** (last 10 from `profe_transactions`) - All data queried from `profe_main` via PDO (host=db) 5. **`admin/views/contact-detail.php`** — Added Subscription tab: - New "Subscription" tab appears only for contacts with a `user_id` - Queries `profe_subscriptions` + `profe_subscription_plans` via PDO - Shows: plan name badge, status badge, interval, amount, next billing date, cancel date (if cancelled) - Transaction history table for the user from `profe_transactions` - Falls back to "No subscription found" message if none exists - New `profe_crm_get_contact_subscription()` helper function with static PDO caching ### Files Created (1) 6. **`admin/views/billing-settings.php`** — Stripe configuration page: - Stripe Publishable Key input (stored as WP option `profe_stripe_publishable_key`) - Stripe Secret Key input (stored as `profe_stripe_secret_key`) - Webhook Signing Secret input (stored as `profe_stripe_webhook_secret`) - Save button with nonce verification via WordPress Settings API pattern - Webhook URL display: `https://staging.jaimisaunders.com/wp-json/profe/v1/billing/webhook/stripe` - Manual cohort calculation button triggering `profe_crm_calculate_retention_cohorts()` function - Full cohort engine that queries `profe_subscriptions` + `profe_subscription_plans`, calculates period-by-period retention, churn, MRR per cohort, and writes into `profe_retention_cohorts` ### Design Decisions - All PDO connections use static variable caching to avoid multiple connections per page load - Card styling matches existing `.profe-crm-card` CSS classes (color variants: primary, green, red, purple, blue, teal) - All text is properly escaped with `esc_html()`/`esc_attr()` for security - PDO errors are caught silently — dashboard falls back to zero/empty defaults if `profe_main` is unreachable