#!/bin/bash
# Quick supply check — run any heartbeat
# Usage: bash /home/ccuser/susan/scripts/supply-check.sh

source /home/ccuser/the-50-dollar-app/.env.local
BASE="https://eciepjpcyfurbkfzekok.supabase.co/rest/v1"
H1="apikey: $NEXT_PUBLIC_SUPABASE_ANON_KEY"
H2="Authorization: Bearer $SUPABASE_SERVICE_ROLE_KEY"

echo "=== RateRight Supply Check $(date '+%H:%M %Z') ==="

W=$(curl -s "$BASE/profiles?select=id&type=eq.worker" -H "$H1" -H "$H2" | python3 -c "import sys,json; print(len(json.load(sys.stdin)))")
WO=$(curl -s "$BASE/profiles?select=id&type=eq.worker&onboarding_completed=eq.true" -H "$H1" -H "$H2" | python3 -c "import sys,json; print(len(json.load(sys.stdin)))")
C=$(curl -s "$BASE/profiles?select=id&type=eq.contractor" -H "$H1" -H "$H2" | python3 -c "import sys,json; print(len(json.load(sys.stdin)))")
J=$(curl -s "$BASE/jobs?select=id&status=eq.active" -H "$H1" -H "$H2" | python3 -c "import sys,json; print(len(json.load(sys.stdin)))")
M=$(curl -s "$BASE/matches?select=id&status=eq.hired" -H "$H1" -H "$H2" | python3 -c "import sys,json; print(len(json.load(sys.stdin)))")

echo "Workers: $W ($WO onboarded) | Contractors: $C | Jobs: $J active | Hires: $M"
echo "Sydney threshold: $WO/25 workers"
if [ "$WO" -ge 25 ]; then
  echo "✅ CONTRACTOR OUTREACH UNLOCKED"
else
  NEED=$((25 - WO))
  echo "🔴 Need $NEED more onboarded workers"
fi