Can I vibe code PostAffiliatePro?

Build an open-source affiliate tracking system using Next.js (App Router), Supabase (PostgreSQL), and Tailwind CSS.

1. DATA MODEL:
Create database tables for:
- `affiliates`: id, user_id, ref_code, payout_email, status, created_at.
- `tracking_clicks`: id, affiliate_id, ip_address, user_agent, landing_page, created_at.
- `orders`: id, store_order_id, affiliate_id, total_amount, commission_amount, status (pending, approved, refunded), created_at.
- `payouts`: id, affiliate_id, amount, status, payout_method, processed_at.

2. CLICK ATTRIBUTION ROUTE:
Implement an edge function or API route at GET `/r/[code]`:
- Lookup the `ref_code` in `affiliates` table.
- Log the click to `tracking_clicks` with IP and User-Agent.
- Set a first-party HTTP-only cookie `affiliate_ref` with value `ref_code`, expiring in 30 days, Domain matching the store root.
- Redirect the user to the destination URL or target product page.

3. WEBHOOK INTEGRATION:
Create POST `/api/webhooks/order-completed` endpoint (securing it with signature validation):
- Extract customer order ID, total order amount, and cookie/custom metadata containing `affiliate_ref`.
- Match `affiliate_ref` to an active affiliate.
- Calculate commission (e.g., 10% fixed rate).
- Insert a record into `orders` with status='pending'.

4. REFUND HANDLING & HOLDING PERIOD:
- Create webhook POST `/api/webhooks/order-refunded` to auto-cancel pending commissions associated with the refunded order ID.
- Add a nightly cron task to transition commissions from status='pending' to status='approved' if created_at > 30 days.

5. AFFILIATE DASHBOARD & PAYOUTS:
- Build an affiliate view showing referral link, total clicks, total conversions, pending balance, and payout history.
- Build an admin dashboard to review approved balances and export CSV batch payout files formatted for PayPal Mass Pay.

OUT OF SCOPE:
Multi-tier MLM tree parent/child calculations, manual voucher code matching, and external ad tracking pixels.

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