# Sunbrite Commissions Integration

## Overview
This integration connects Sunbright's commission tracking software to the FP&A platform, providing installer commission data, payment history, and performance metrics.

## Implementation Guide

### 1. Authentication
Sunbrite uses API key authentication. Store in `.env`:
```
SUNBRITE_API_KEY=your-api-key
SUNBRITE_BASE_URL=https://api.sunbrite.com/v1
```

Update `SunbriteIntegration::isImplemented()` to return `true` when ready.

### 2. Data to sync
| Report ID | Endpoint | Description | DB Table |
|-----------|----------|-------------|----------|
| commissions | GET /commissions | Commission records by installer, project, period | `commissions` |
| payments | GET /payments | Payment history to installers | `commission_payments` |
| installer-performance | GET /installers/metrics | KPIs per installer (jobs, avg commission, revenue) | `installer_metrics` |

### 3. Database tables needed
Create migrations for:
- `commissions` (id, company_id, installer_name, installer_id, project_name, client_name, commission_amount, commission_type, txn_date)
- `commission_payments` (id, company_id, installer_id, payment_amount, payment_date, payment_method, status)
- `installer_metrics` (id, company_id, installer_id, installer_name, total_jobs, total_commission, avg_commission, period_start, period_end)

### 4. Integration steps
1. Edit `SunbriteIntegration.php`:
   - Implement `isConnected()` — check API key validity
   - Implement `sync()` — fetch commissions + payments, store in DB
2. Create `SunbriteSyncService.php` following `QboSyncService.php` pattern
3. Add migrations for new tables
4. Dashboard commission chart + KPI card will auto-populate from real data

### 5. Cross-source features
- Commission vs. Revenue: match commission records → QBO invoices
- Installer profitability: commission cost vs. project revenue
- Commission forecasting: trends by installer over time