Can I vibe code LeadDyno?

Build an internal affiliate marketing tracking and commission platform using Next.js (App Router), Supabase (PostgreSQL), and Tailwind CSS. The system must replace core functionality of LeadDyno.

1. DATA MODEL:
- Create `affiliates`: id, email, name, promo_code, custom_slug, commission_rate (percentage), payout_email, status (active/pending/suspended).
- Create `clicks`: id, affiliate_id, ip_address, user_agent, referrer_url, created_at.
- Create `commissions`: id, affiliate_id, order_id, order_total, commission_amount, status (pending, approved, paid, voided), created_at, approved_at.
- Create `payouts`: id, affiliate_id, amount, payout_method, transaction_reference, created_at.

2. TRACKING SCRIPT & ATTRIBUTION API:
- Build a lightweight JS embed script and API endpoint `/api/track` that captures incoming URL parameter `?ref=CODE` or `?afmc=CODE`.
- Store referral data in a server-side HTTP-only cookie valid for 30 days.
- Write logic to log a record into `clicks` table when a referral link is loaded.

3. WEBHOOK RECEPTION:
- Create `/api/webhooks/shopify` supporting `orders/paid` and `refunds/created`.
- Match incoming order to an affiliate via stored cookie attribution or matching `discount_codes` included in the Shopify order payload.
- Calculate `commission_amount = order_subtotal * commission_rate` and insert into `commissions` with status `pending`.
- Handle `refunds/created` by setting commission status to `voided` or adjusting commission proportional to refunded items.

4. AFFILIATE PORTAL & ADMIN PANEL:
- Provide affiliate auth via Supabase Magic Links. Affiliates view referral link generator, total clicks, total conversions, pending balance, and payout history.
- Provide admin view listing all pending commissions with bulk actions: 'Approve Selected' and 'Mark as Paid'.

5. EDGE CASES & ANTI-FRAUD:
- Block commission creation if buyer IP matches affiliate registered IP address (self-referral prevention).
- Implement idempotency checks on `order_id` in webhook logic to prevent duplicate commission creation on repeated webhook deliveries.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs