#!/bin/bash
# run-job-fix.sh - Execute Phase 1 of job consolidation fix
# Run as ccuser

set -e

echo "=== JOB CONSOLIDATION FIX - PHASE 1 ==="
echo "Date: $(date)"
echo ""

# Step 1: Check current job status
echo "1. Checking current job status..."
cd /home/ccuser/rateright-growth

echo "   - sequenceProcessor.js: $(grep -c "processSequences" src/jobs/index.js) references"
echo "   - scheduledSms.js: $(grep -c "processScheduledMessages" src/jobs/index.js) references (should be 0 or commented)"
echo ""

# Step 2: Run migration if needed
echo "2. Checking for job_locks migration..."
if [ -f "supabase/migrations/20260202130000_create_job_locks_table.sql" ]; then
    echo "   ✅ Migration file exists"
    echo "   Note: Need to run via Supabase Dashboard SQL Editor:"
    echo "   https://supabase.com/dashboard/project/memscjotxrzqnhrvnnkc/sql"
    echo "   Or use: npx supabase db push --linked (if authenticated)"
else
    echo "   ❌ Migration file missing"
fi
echo ""

# Step 3: Verify code changes
echo "3. Verifying code changes..."
if grep -q "DISABLED: scheduledSms.js" src/jobs/index.js; then
    echo "   ✅ scheduledSms.js disabled in code"
else
    echo "   ❌ scheduledSms.js NOT disabled - need to fix"
fi

if grep -q "runJobWithLock.*sequence_processor" src/jobs/index.js; then
    echo "   ✅ sequenceProcessor.js using job locking"
else
    echo "   ❌ sequenceProcessor.js NOT using job locking"
fi
echo ""

# Step 4: Check if Growth Engine needs restart
echo "4. Checking Growth Engine status..."
if ps aux | grep -v grep | grep -q "node.*src/index.js"; then
    echo "   ⚠️ Growth Engine is running"
    echo "   Need to restart to apply SMS fix:"
    echo "   pm2 restart growth-engine (or systemctl restart growth-engine)"
else
    echo "   ❓ Growth Engine not running (or different process name)"
fi
echo ""

# Step 5: Next steps
echo "5. Next steps for CC:"
echo "   a) Run migration via Supabase Dashboard"
echo "   b) Restart Growth Engine"
echo "   c) Monitor sequence processing logs"
echo "   d) Begin Phase 2 (unified metrics job)"
echo ""

echo "=== FIX READY FOR EXECUTION ==="
echo "CC should now work on this task from INBOX.md"
echo "Task: TASK-20260202-131200 (P0 Job Duplication Fix)"