#!/bin/bash
# Progress Check Script - Daily Priority Determination

set -e
cd "$(dirname "$0")/.."

echo "=== StartupLX Daily Progress Check ==="
echo "Time: $(date '+%Y-%m-%d %H:%M:%S EAT')"

# Check pipeline from CSV tracking
PIPELINE_FILE="/home/cyprian/Vaults/cyprian-obsidian/cyprian/Development/Automation/2026-08-28-Outreach-Tracking.csv"
if [ -f "$PIPELINE_FILE" ]; then
    # Count potential pipeline value
    POTENTIAL_PIPELINE=$(grep ",No,No,No" "$PIPELINE_FILE" | wc -l)
    echo "Potential Pipeline Deals: $POTENTIAL_PIPELINE"
fi

# Check database for real revenue (if running)
if [ -f ".env" ]; then
    source .env
    if [ -n "$DB_HOST" ]; then
        REVENUE=$(psql -h "$DB_HOST" -U "$DB_USER" -d "$DB_NAME" -t -c "SELECT COALESCE(SUM(amount), 0) FROM stripe_transactions WHERE status='paid' AND created_at >= DATE_TRUNC('month', NOW())" 2>/dev/null || echo "0")
        echo "Current MRR: \$$REVENUE"
    fi
fi

# Check project count from database
if [ -n "$DB_HOST" ]; then
    ACTIVE_PROJECTS=$(psql -h "$DB_HOST" -U "$DB_USER" -d "$DB_NAME" -t -c "SELECT COUNT(*) FROM projects WHERE status NOT IN ('completed', 'cancelled')" 2>/dev/null || echo "0")
    echo "Active Projects: $ACTIVE_PROJECTS/2"
fi

echo ""
echo "=== Today's Priority ==="
echo "1. CLIENT OUTREACH - Generate \$200 pipeline"
echo "   - Send 5 outreach emails"
echo "   - Schedule 2 discovery calls"
echo "   - Prepare proposals"
echo ""
echo "2. WEBSITE DEPLOYMENT - Enable income capture"
echo "   - Launch contact page"
echo "   - Integrate booking system"
echo "   - Test lead capture"
echo ""
echo "3. DASHBOARD SETUP - Track revenue"
echo "   - Configure MRR KPI"
echo "   - Set up pipeline tracker"
echo "   - Enable alerts"

exit 0