<?php
require_once 'session.php';
require_once 'config.php';

// Require user to be logged in
requireLogin();

// Get current user
$user = getCurrentUser();
if (!$user) {
    logout();
    getSessionManager()->redirectToLogin('Session expired. Please log in again.');
}

// Initialize database
try {
    $db = new Database();
    $pdo = $db->getConnection();
} catch (Exception $e) {
    logError('Database connection failed in dashboard.php: ' . $e->getMessage());
    die('System error. Please try again later.');
}

// Award onboarding points if not already awarded
if (!$user['onboarding_points_awarded']) {
    try {
        $pdo->beginTransaction();
        
        // Add onboarding points
        $stmt = $pdo->prepare("INSERT INTO user_points (user_id, points, total_earned) VALUES (?, 10.00, 10.00) ON DUPLICATE KEY UPDATE points = points + 10.00, total_earned = total_earned + 10.00");
        $stmt->execute([$user['id']]);
        
        // Add transaction record
        $stmt = $pdo->prepare("INSERT INTO point_transactions (user_id, transaction_type, points, source, description) VALUES (?, 'earned', 10.00, 'onboarding', 'Welcome bonus for joining Relevant Reflex')");
        $stmt->execute([$user['id']]);
        
        // Mark as awarded
        $stmt = $pdo->prepare("UPDATE users SET onboarding_points_awarded = 1 WHERE id = ?");
        $stmt->execute([$user['id']]);
        
        $pdo->commit();
        
        logError('Onboarding points awarded', ['user_id' => $user['id'], 'points' => 10]);
        
        // Refresh user data to reflect changes
        $user = getCurrentUser();
    } catch (Exception $e) {
        $pdo->rollback();
        logError('Error awarding onboarding points', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
    }
}

// Get user points
$userPoints = ['points' => 0, 'total_earned' => 0, 'total_redeemed' => 0];
try {
    $stmt = $pdo->prepare("SELECT points, total_earned, total_redeemed FROM user_points WHERE user_id = ?");
    $stmt->execute([$user['id']]);
    $pointsData = $stmt->fetch();
    if ($pointsData) {
        $userPoints = $pointsData;
    }
} catch (Exception $e) {
    logError('Error fetching user points', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}

// Get profiler completion status
$profilerSections = [
    'personal_background' => 'Personal Background',
    'household_family' => 'Household & Family',
    'shopping_lifestyle' => 'Shopping & Lifestyle',
    'technology_digital' => 'Technology & Digital',
    'travel_transportation' => 'Travel & Transportation',
    'health_fitness' => 'Health & Fitness',
    'entertainment_media' => 'Entertainment & Media',
    'food_dining' => 'Food & Dining',
    'financial_services' => 'Financial Services',
    'communication_payments' => 'Communication & Payments'
];

$profilerCompletion = [];
try {
    $stmt = $pdo->prepare("SELECT section, completion_percentage, is_completed, points_awarded FROM profiler_completion WHERE user_id = ?");
    $stmt->execute([$user['id']]);
    while ($row = $stmt->fetch()) {
        $profilerCompletion[$row['section']] = $row;
    }
} catch (Exception $e) {
    logError('Error fetching profiler completion', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}

// Get mobile verification status
$mobileVerified = false;
$mobileNumber = '';
try {
    $stmt = $pdo->prepare("SELECT mobile_number, is_verified FROM mobile_verifications WHERE user_id = ?");
    $stmt->execute([$user['id']]);
    $mobileData = $stmt->fetch();
    if ($mobileData) {
        $mobileVerified = $mobileData['is_verified'];
        $mobileNumber = $mobileData['mobile_number'];
    }
} catch (Exception $e) {
    logError('Error fetching mobile verification', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}

// Get UPI ID from profiler
$upiId = '';
try {
    $stmt = $pdo->prepare("SELECT response FROM user_profiler WHERE user_id = ? AND section = 'profile' AND question_id = 'upi_id'");
    $stmt->execute([$user['id']]);
    $upiData = $stmt->fetch();
    if ($upiData) {
        $upiId = json_decode($upiData['response'], true);
    }
} catch (Exception $e) {
    logError('Error fetching UPI ID', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}

// Handle UPI ID update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'update_upi') {
    $newUpiId = isset($_POST['upi_id']) ? sanitize($_POST['upi_id']) : '';
    
    if (!empty($newUpiId) && preg_match('/^[\w\.-]+@[\w\.-]+$/', $newUpiId)) {
        try {
            $stmt = $pdo->prepare("INSERT INTO user_profiler (user_id, section, question_id, response) VALUES (?, 'profile', 'upi_id', ?) ON DUPLICATE KEY UPDATE response = ?, updated_at = NOW()");
            $upiJson = json_encode($newUpiId);
            $stmt->execute([$user['id'], $upiJson, $upiJson]);
            
            $upiId = $newUpiId;
            $success_message = "UPI ID updated successfully!";
        } catch (Exception $e) {
            logError('Error updating UPI ID', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
            $error_message = "Error updating UPI ID. Please try again.";
        }
    } else {
        $error_message = "Please enter a valid UPI ID (e.g., yourname@paytm).";
    }
}

// Get user's support tickets for the support section
$userTickets = [];
try {
    $stmt = $pdo->prepare("
        SELECT st.*, 
               (SELECT COUNT(*) FROM support_messages sm WHERE sm.ticket_id = st.id) as message_count,
               (SELECT sm.created_at FROM support_messages sm WHERE sm.ticket_id = st.id ORDER BY sm.created_at DESC LIMIT 1) as last_reply
        FROM support_tickets st 
        WHERE st.user_id = ? 
        ORDER BY st.created_at DESC 
        LIMIT 10
    ");
    $stmt->execute([$user['id']]);
    $userTickets = $stmt->fetchAll();
} catch (Exception $e) {
    logError('Error fetching user tickets', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}

// Get user's recent redemption requests
$userRedemptions = [];
try {
    $stmt = $pdo->prepare("
        SELECT * FROM redemption_requests 
        WHERE user_id = ? 
        ORDER BY created_at DESC 
        LIMIT 5
    ");
    $stmt->execute([$user['id']]);
    $userRedemptions = $stmt->fetchAll();
} catch (Exception $e) {
    logError('Error fetching user redemptions', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}

// Calculate account age
$joinDate = new DateTime($user['created_at']);
$now = new DateTime();
$accountAge = $now->diff($joinDate);
$joinDateFormatted = $joinDate->format('M Y');
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <title>Dashboard - Relevant Reflex</title>
    <meta content="width=device-width, initial-scale=1.0" name="viewport">
    <meta content="" name="keywords">
    <meta content="" name="description">

    <!-- Favicon -->
    <link href="assets/img/favicon.ico" rel="icon">

    <!-- Google Web Fonts -->
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Open+Sans:wght@400;500&family=Roboto:wght@500;700;900&display=swap" rel="stylesheet"> 

    <!-- Icon Font Stylesheet -->
    <link href="assets/css/fontawesome.min.css" rel="stylesheet">
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">

    <!-- Template Stylesheet -->
    <link href="assets/css/templatemo.css" rel="stylesheet">
    <link href="assets/css/custom.css" rel="stylesheet">

    <style>
        .dashboard-header {
            background: linear-gradient(135deg, #28a745 0%, #20c997 100%);
            color: white;
            padding: 3rem 0;
            margin-bottom: 2rem;
            backdrop-filter: blur(10px);
        }
        .profile-avatar {
            width: 80px;
            height: 80px;
            border-radius: 50%;
            background: rgba(255,255,255,0.2);
            display: flex;
            align-items: center;
            justify-content: center;
            font-size: 1.8rem;
            font-weight: bold;
        }
        .dashboard-section {
            display: none;
            animation: fadeIn 0.3s ease-in;
        }
        .dashboard-section.active {
            display: block;
        }
        @keyframes fadeIn {
            from { opacity: 0; transform: translateY(20px); }
            to { opacity: 1; transform: translateY(0); }
        }
        .stat-card {
            background: white;
            border-radius: 15px;
            padding: 2rem;
            box-shadow: 0 4px 20px rgba(0,0,0,0.1);
            transition: transform 0.3s ease;
            margin-bottom: 1.5rem;
        }
        .stat-card:hover {
            transform: translateY(-5px);
        }
        .stat-icon {
            width: 60px;
            height: 60px;
            border-radius: 15px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-size: 1.5rem;
            margin-bottom: 1rem;
        }
        .points-balance {
            background: linear-gradient(135deg, #ff6b6b, #ffa500);
            color: white;
        }
        .survey-available {
            background: linear-gradient(135deg, #4ecdc4, #20c997);
            color: white;
        }
        .completion-rate {
            background: linear-gradient(135deg, #667eea, #764ba2);
            color: white;
        }
        .quick-actions {
            background: linear-gradient(135deg, #f093fb, #f5576c);
            color: white;
        }
        .profiler-section {
            background: white;
            border-radius: 10px;
            padding: 1.5rem;
            margin-bottom: 1rem;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
            transition: all 0.3s ease;
        }
        .profiler-section:hover {
            transform: translateY(-3px);
            box-shadow: 0 4px 20px rgba(0,0,0,0.15);
        }
        .progress-circle {
            width: 60px;
            height: 60px;
            border-radius: 50%;
            display: flex;
            align-items: center;
            justify-content: center;
            font-weight: bold;
            font-size: 0.9rem;
        }
        .progress-circle.completed {
            background: linear-gradient(135deg, #28a745, #20c997);
            color: white;
        }
        .progress-circle.in-progress {
            background: linear-gradient(135deg, #ffa500, #ff6b6b);
            color: white;
        }
        .progress-circle.not-started {
            background: #e9ecef;
            color: #6c757d;
        }
        .points-badge {
            background: linear-gradient(135deg, #667eea, #764ba2);
            color: white;
            padding: 0.25rem 0.75rem;
            border-radius: 20px;
            font-size: 0.75rem;
            font-weight: bold;
        }
        .mobile-verification-card {
            background: linear-gradient(135deg, #e3f2fd, #f3e5f5);
            border: 2px solid #2196f3;
            border-radius: 15px;
            padding: 1.5rem;
            margin-bottom: 2rem;
        }
        .verification-success {
            background: linear-gradient(135deg, #e8f5e8, #f0f8f0);
            border-color: #28a745;
        }
        .ticket-item {
            background: white;
            border-radius: 10px;
            padding: 1.5rem;
            margin-bottom: 1rem;
            border: 1px solid #e9ecef;
            transition: all 0.3s ease;
        }
        .ticket-item:hover {
            border-color: #28a745;
            box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
        }
        .status-badge {
            padding: 0.25rem 0.75rem;
            border-radius: 20px;
            font-size: 0.875rem;
            font-weight: 500;
        }
        .status-open {
            background: #e3f2fd;
            color: #1976d2;
        }
        .status-pending {
            background: #fff3e0;
            color: #f57c00;
        }
        .status-resolved {
            background: #e8f5e8;
            color: #388e3c;
        }
        .status-closed {
            background: #fce4ec;
            color: #c2185b;
        }
        .redemption-item {
            background: white;
            border-radius: 10px;
            padding: 1.5rem;
            margin-bottom: 1rem;
            border: 1px solid #e9ecef;
        }
    </style>
</head>

<body>
    <!-- Top Navigation -->
    <nav class="navbar navbar-expand-lg bg-dark navbar-light d-none d-lg-block" id="templatemo_nav_top">
        <div class="container text-light">
            <div class="w-100 d-flex justify-content-between">
                <div>
                    <i class="fa fa-envelope mx-2"></i>
                    <a class="navbar-sm-brand text-light text-decoration-none" href="mailto:support@relevantreflex.com">support@relevantreflex.com</a>
                    <i class="fa fa-phone mx-2"></i>
                    <span class="navbar-sm-brand text-light">India's Premier Survey Platform</span>
                </div>
                <div>
                    <span class="text-light">Welcome, <?php echo htmlspecialchars(explode('@', $user['email'])[0]); ?>!</span>
                    <a class="text-light ms-3" href="logout.php"><u>Logout</u></a>
                </div>
            </div>
        </div>
    </nav>

    <!-- Header -->
    <nav class="navbar navbar-expand-lg navbar-light shadow">
        <div class="container d-flex justify-content-between align-items-center">
            <a class="navbar-brand text-success logo h1 align-self-center" href="index.php">
                Relevant Reflex
            </a>

            <button class="navbar-toggler border-0" type="button" data-bs-toggle="collapse" data-bs-target="#templatemo_main_nav" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>

            <div class="align-self-center collapse navbar-collapse flex-fill d-lg-flex justify-content-lg-between" id="templatemo_main_nav">
                <div class="flex-fill">
                    <ul class="nav navbar-nav d-flex justify-content-between mx-lg-auto">
                        <li class="nav-item">
                            <a class="nav-link" href="#overview" onclick="showSection('overview')">Dashboard</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="#surveys" onclick="showSection('surveys')">Surveys</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="#profiler" onclick="showSection('profiler')">Know Me Better</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="#rewards" onclick="showSection('rewards')">Rewards</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="#profile" onclick="showSection('profile')">Profile</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="#support" onclick="showSection('support')">Support</a>
                        </li>
                    </ul>
                </div>
                <div class="navbar align-self-center d-flex">
                    <i class="fa fa-coins text-success"></i>
                    <span class="text-dark ms-2"><?php echo number_format($userPoints['points'], 0); ?> Points</span>
                </div>
            </div>
        </div>
    </nav>

    <!-- Dashboard Header -->
    <div class="dashboard-header">
        <div class="container">
            <div class="row align-items-center">
                <div class="col-md-8">
                    <h1 class="mb-2">Welcome to Your Survey Dashboard!</h1>
                    <p class="mb-0">Complete your profile, earn points, and participate in paid surveys from trusted research companies.</p>
                </div>
                <div class="col-md-4 text-end">
                    <div class="profile-avatar">
                        <?php echo strtoupper(substr($user['email'], 0, 2)); ?>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="container">
        <!-- Overview Section -->
        <div id="overview" class="dashboard-section active">
            <div class="row">
                <div class="col-lg-3 col-md-6">
                    <div class="stat-card points-balance">
                        <div class="stat-icon">
                            <i class="fa fa-coins"></i>
                        </div>
                        <h3><?php echo number_format($userPoints['points'], 0); ?></h3>
                        <p class="mb-0">Available Points</p>
                        <small>₹<?php echo number_format($userPoints['points'] * 0.5, 2); ?> Value</small>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="stat-card survey-available">
                        <div class="stat-icon">
                            <i class="fa fa-chart-bar"></i>
                        </div>
                        <h3>0</h3>
                        <p class="mb-0">Available Surveys</p>
                        <small>Complete your profile to unlock</small>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="stat-card completion-rate">
                        <div class="stat-icon">
                            <i class="fa fa-user-check"></i>
                        </div>
                        <h3><?php 
                            $completedSections = 0;
                            foreach ($profilerSections as $key => $name) {
                                if (isset($profilerCompletion[$key]) && $profilerCompletion[$key]['is_completed']) {
                                    $completedSections++;
                                }
                            }
                            echo round(($completedSections / count($profilerSections)) * 100);
                        ?>%</h3>
                        <p class="mb-0">Profile Complete</p>
                        <small><?php echo $completedSections; ?>/<?php echo count($profilerSections); ?> sections</small>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="stat-card quick-actions">
                        <div class="stat-icon">
                            <i class="fa fa-bolt"></i>
                        </div>
                        <h3><?php echo number_format($userPoints['total_earned'], 0); ?></h3>
                        <p class="mb-0">Total Earned</p>
                        <small>Since <?php echo $joinDateFormatted; ?></small>
                    </div>
                </div>
            </div>

            <!-- Quick Actions -->
            <div class="row mt-4">
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <i class="fa fa-user-circle fa-3x text-primary mb-3"></i>
                        <h5>Complete Your Profile</h5>
                        <p class="text-muted">Earn up to 50 points by completing all profile sections</p>
                        <button class="btn btn-primary" onclick="showSection('profiler')">Start Profiling</button>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <i class="fa fa-gift fa-3x text-success mb-3"></i>
                        <h5>Redeem Rewards</h5>
                        <p class="text-muted">Convert your points to cash rewards via UPI</p>
                        <button class="btn btn-success" onclick="showSection('rewards')" <?php echo $userPoints['points'] < 200 ? 'disabled' : ''; ?>>
                            View Rewards
                        </button>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <i class="fa fa-headset fa-3x text-info mb-3"></i>
                        <h5>Need Help?</h5>
                        <p class="text-muted">Get support for any questions or issues</p>
                        <button class="btn btn-info" onclick="showSection('support')">Contact Support</button>
                    </div>
                </div>
            </div>
        </div>

        <!-- Surveys Section -->
        <div id="surveys" class="dashboard-section">
            <h3>Available Surveys</h3>
            <div class="alert alert-info">
                <h5><i class="fa fa-info-circle"></i> Complete Your Profile First!</h5>
                <p>To receive targeted survey invitations, please complete all sections in the "Know Me Better" profiler. This helps us match you with relevant surveys that fit your demographics and interests.</p>
                <p class="mb-0"><strong>Current Progress:</strong> <?php echo $completedSections; ?>/<?php echo count($profilerSections); ?> sections completed</p>
            </div>
        </div>

        <!-- Know Me Better Profiler Section -->
        <div id="profiler" class="dashboard-section">
            <div class="row">
                <div class="col-12">
                    <h3>Know Me Better <span class="badge bg-success">Complete All Sections to Earn 50 Points!</span></h3>
                    <p class="text-muted">Help us understand you better to send more relevant survey opportunities. Each completed section earns you 5 points!</p>
                </div>
            </div>

            <!-- Mobile Verification Section -->
            <div class="mobile-verification-card <?php echo $mobileVerified ? 'verification-success' : ''; ?>">
                <div class="row align-items-center">
                    <div class="col-md-8">
                        <h5>
                            <i class="fa fa-mobile-alt"></i> Mobile Verification 
                            <?php if ($mobileVerified): ?>
                                <i class="fa fa-check-circle ms-2"></i>
                            <?php endif; ?>
                        </h5>
                        <p class="mb-2">
                            <?php if ($mobileVerified): ?>
                                Your mobile number <?php echo $mobileNumber; ?> is verified!
                            <?php else: ?>
                                Verify your mobile number to receive survey notifications and earn 10 points.
                            <?php endif; ?>
                        </p>
                        <?php if (!$mobileVerified): ?>
                            <small>We'll send you an OTP to verify your number.</small>
                        <?php endif; ?>
                    </div>
                    <div class="col-md-4 text-end">
                        <?php if ($mobileVerified): ?>
                            <span class="points-badge">10 Points Earned!</span>
                        <?php else: ?>
                            <button class="btn btn-success" onclick="showMobileVerification()">
                                <i class="fa fa-plus"></i> Verify Mobile
                            </button>
                        <?php endif; ?>
                    </div>
                </div>
            </div>

            <!-- Profiler Sections -->
            <div class="row">
                <?php foreach ($profilerSections as $sectionKey => $sectionName): 
                    $completion = isset($profilerCompletion[$sectionKey]) ? $profilerCompletion[$sectionKey] : null;
                    $isCompleted = $completion && $completion['is_completed'];
                    $percentage = $completion ? $completion['completion_percentage'] : 0;
                    $pointsAwarded = $completion && $completion['points_awarded'];
                ?>
                <div class="col-md-6">
                    <div class="profiler-section">
                        <div class="row align-items-center">
                            <div class="col-2">
                                <div class="progress-circle <?php echo $isCompleted ? 'completed' : ($percentage > 0 ? 'in-progress' : 'not-started'); ?>">
                                    <?php if ($isCompleted): ?>
                                        <i class="fa fa-check"></i>
                                    <?php else: ?>
                                        <?php echo round($percentage); ?>%
                                    <?php endif; ?>
                                </div>
                            </div>
                            <div class="col-7">
                                <h6 class="mb-1"><?php echo $sectionName; ?></h6>
                                <small class="text-muted">
                                    <?php if ($isCompleted): ?>
                                        Completed
                                    <?php elseif ($percentage > 0): ?>
                                        In Progress
                                    <?php else: ?>
                                        Not Started
                                    <?php endif; ?>
                                </small>
                            </div>
                            <div class="col-3 text-end">
                                <?php if ($pointsAwarded): ?>
                                    <span class="points-badge">5 Points</span>
                                <?php else: ?>
                                    <button class="btn btn-outline-success btn-sm" onclick="window.location.href='profiler.php?section=<?php echo $sectionKey; ?>'">
                                        <?php echo $isCompleted ? 'Review' : ($percentage > 0 ? 'Continue' : 'Start'); ?>
                                    </button>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endforeach; ?>
            </div>
        </div>

        <!-- Rewards Section -->
        <div id="rewards" class="dashboard-section">
            <div class="row">
                <div class="col-12">
                    <h3>Rewards & Points</h3>
                </div>
            </div>

            <!-- Points Summary -->
            <div class="row mb-4">
                <div class="col-md-4">
                    <div class="stat-card points-balance text-center">
                        <h4><?php echo number_format($userPoints['points'], 0); ?></h4>
                        <p class="mb-1">Available Points</p>
                        <h5>₹<?php echo number_format($userPoints['points'] * 0.5, 2); ?></h5>
                        <small>Current Value</small>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <h4><?php echo number_format($userPoints['total_earned'], 0); ?></h4>
                        <p class="mb-1">Total Earned</p>
                        <h5>₹<?php echo number_format($userPoints['total_earned'] * 0.5, 2); ?></h5>
                        <small>Lifetime Earnings</small>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <h4><?php echo number_format($userPoints['total_redeemed'], 0); ?></h4>
                        <p class="mb-1">Total Redeemed</p>
                        <h5>₹<?php echo number_format($userPoints['total_redeemed'] * 0.5, 2); ?></h5>
                        <small>Total Withdrawn</small>
                    </div>
                </div>
            </div>

            <!-- Redemption Section -->
            <div class="row mb-4">
                <div class="col-12">
                    <div class="stat-card">
                        <h5><i class="fa fa-gift"></i> Redeem Points</h5>
                        <?php if ($userPoints['points'] >= 200): ?>
                            <p>You can redeem your points for cash via UPI transfer. Minimum redemption: 200 points (₹100)</p>
                            <a href="redemption.php" class="btn btn-success">
                                <i class="fa fa-money-bill-wave"></i> Redeem Now
                            </a>
                        <?php else: ?>
                            <div class="alert alert-warning">
                                <h6>Minimum Redemption Required</h6>
                                <p class="mb-2">You need at least 200 points (₹100) to redeem.</p>
                                <p class="mb-0">You currently have <?php echo number_format($userPoints['points'], 0); ?> points. Need <?php echo 200 - $userPoints['points']; ?> more points.</p>
                            </div>
                            <button class="btn btn-secondary" disabled>
                                <i class="fa fa-money-bill-wave"></i> Redeem (Need <?php echo 200 - $userPoints['points']; ?> more points)
                            </button>
                        <?php endif; ?>
                    </div>
                </div>
            </div>

            <!-- Recent Redemptions -->
            <?php if (!empty($userRedemptions)): ?>
                <div class="row">
                    <div class="col-12">
                        <h5>Recent Redemption Requests</h5>
                        <?php foreach ($userRedemptions as $redemption): ?>
                            <div class="redemption-item">
                                <div class="row align-items-center">
                                    <div class="col-md-8">
                                        <h6 class="mb-1">Request #<?php echo htmlspecialchars($redemption['request_id']); ?></h6>
                                        <p class="mb-1">
                                            <strong><?php echo number_format($redemption['points_redeemed'], 0); ?> points</strong> 
                                            → ₹<?php echo number_format($redemption['amount_inr'], 2); ?>
                                            to <?php echo htmlspecialchars($redemption['upi_id']); ?>
                                        </p>
                                        <small class="text-muted">
                                            Requested on <?php echo date('M j, Y g:i A', strtotime($redemption['created_at'])); ?>
                                        </small>
                                    </div>
                                    <div class="col-md-4 text-end">
                                        <span class="status-badge status-<?php echo $redemption['status']; ?>">
                                            <?php echo ucfirst($redemption['status']); ?>
                                        </span>
                                    </div>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    </div>
                </div>
            <?php endif; ?>
        </div>

        <!-- Profile Section -->
        <div id="profile" class="dashboard-section">
            <h3>Profile Settings</h3>
            
            <?php if (isset($success_message)): ?>
                <div class="alert alert-success">
                    <i class="fa fa-check-circle"></i> <?php echo $success_message; ?>
                </div>
            <?php endif; ?>
            
            <?php if (isset($error_message)): ?>
                <div class="alert alert-danger">
                    <i class="fa fa-exclamation-triangle"></i> <?php echo $error_message; ?>
                </div>
            <?php endif; ?>
            
            <div class="row">
                <div class="col-md-6">
                    <div class="stat-card">
                        <h5><i class="fa fa-user"></i> Account Information</h5>
                        <table class="table table-borderless">
                            <tr>
                                <td><strong>Email:</strong></td>
                                <td><?php echo htmlspecialchars($user['email']); ?></td>
                            </tr>
                            <tr>
                                <td><strong>Gender:</strong></td>
                                <td><?php echo htmlspecialchars($user['gender']); ?></td>
                            </tr>
                            <tr>
                                <td><strong>Date of Birth:</strong></td>
                                <td><?php echo date('M j, Y', strtotime($user['date_of_birth'])); ?></td>
                            </tr>
                            <tr>
                                <td><strong>Postcode:</strong></td>
                                <td><?php echo htmlspecialchars($user['postcode']); ?></td>
                            </tr>
                            <tr>
                                <td><strong>Account Status:</strong></td>
                                <td>
                                    <span class="badge bg-success">Active</span>
                                    <?php if ($user['email_verified']): ?>
                                        <span class="badge bg-info ms-1">Verified</span>
                                    <?php endif; ?>
                                </td>
                            </tr>
                        </table>
                    </div>
                </div>
                <div class="col-md-6">
                    <div class="stat-card">
                        <h5><i class="fa fa-mobile-alt"></i> Mobile Verification</h5>
                        <?php if ($mobileVerified): ?>
                            <div class="alert alert-success">
                                <i class="fa fa-check-circle"></i> 
                                Mobile number <strong>+91 <?php echo htmlspecialchars($mobileNumber); ?></strong> is verified!
                            </div>
                        <?php else: ?>
                            <div class="alert alert-warning">
                                <i class="fa fa-exclamation-triangle"></i> 
                                Mobile number not verified yet.
                            </div>
                            <a href="mobile-verification.php" class="btn btn-primary">
                                <i class="fa fa-mobile-alt"></i> Verify Mobile Number
                            </a>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
            
            <!-- UPI ID Section -->
            <div class="row mt-4">
                <div class="col-12">
                    <div class="stat-card">
                        <h5><i class="fa fa-money-bill-wave"></i> UPI Payment Details</h5>
                        <p class="text-muted">Add your UPI ID to receive reward payments directly to your account.</p>
                        
                        <form method="POST">
                            <input type="hidden" name="action" value="update_upi">
                            <div class="row">
                                <div class="col-md-8">
                                    <div class="mb-3">
                                        <label for="upi_id" class="form-label">UPI ID</label>
                                        <input type="text" class="form-control" id="upi_id" name="upi_id" 
                                               placeholder="yourname@paytm" 
                                               value="<?php echo htmlspecialchars($upiId); ?>">
                                        <small class="text-muted">Example: yourname@paytm, yourname@phonepe, yourname@googlepay</small>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <label class="form-label">&nbsp;</label>
                                    <div>
                                        <button type="submit" class="btn btn-success">
                                            <i class="fa fa-save"></i> Update UPI ID
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </form>
                        
                        <?php if (!empty($upiId)): ?>
                            <div class="alert alert-success mt-3">
                                <i class="fa fa-check-circle"></i> 
                                Your UPI ID <strong><?php echo htmlspecialchars($upiId); ?></strong> is saved and ready for payments!
                            </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>

        <!-- Support Section -->
        <div id="support" class="dashboard-section">
            <h3>Support Center</h3>
            
            <!-- Quick Support Actions -->
            <div class="row mb-4">
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <i class="fa fa-ticket-alt fa-3x text-primary mb-3"></i>
                        <h5>Create Ticket</h5>
                        <p class="text-muted">Get help with account, points, or technical issues</p>
                        <a href="user-support.php" class="btn btn-primary">Create New Ticket</a>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <i class="fa fa-question-circle fa-3x text-info mb-3"></i>
                        <h5>How It Works</h5>
                        <p class="text-muted">Learn about our survey panel and earning process</p>
                        <a href="doubts.php" class="btn btn-info">View Guide</a>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="stat-card text-center">
                        <i class="fa fa-envelope fa-3x text-success mb-3"></i>
                        <h5>Contact Us</h5>
                        <p class="text-muted">Direct email support for urgent matters</p>
                        <a href="contact.php" class="btn btn-success">Contact Form</a>
                    </div>
                </div>
            </div>

            <!-- Recent Support Tickets -->
            <div class="row">
                <div class="col-12">
                    <h5>Your Recent Support Tickets</h5>
                    <?php if (empty($userTickets)): ?>
                        <div class="alert alert-info">
                            <p class="mb-0">You haven't created any support tickets yet.</p>
                        </div>
                    <?php else: ?>
                        <?php foreach ($userTickets as $ticket): ?>
                            <div class="ticket-item">
                                <div class="row align-items-center">
                                    <div class="col-md-8">
                                        <h6 class="mb-1"><?php echo htmlspecialchars($ticket['subject']); ?></h6>
                                        <p class="mb-1">
                                            <strong>Ticket #<?php echo htmlspecialchars($ticket['ticket_number']); ?></strong>
                                            | <?php echo $ticket['message_count']; ?> messages
                                        </p>
                                        <small class="text-muted">
                                            Created: <?php echo date('M j, Y g:i A', strtotime($ticket['created_at'])); ?>
                                            <?php if ($ticket['last_reply']): ?>
                                                | Last reply: <?php echo date('M j, Y g:i A', strtotime($ticket['last_reply'])); ?>
                                            <?php endif; ?>
                                        </small>
                                    </div>
                                    <div class="col-md-4 text-end">
                                        <span class="status-badge status-<?php echo $ticket['status']; ?>">
                                            <?php echo ucfirst($ticket['status']); ?>
                                        </span>
                                        <br>
                                        <span class="badge bg-secondary mt-1">
                                            <?php echo ucfirst($ticket['priority']); ?>
                                        </span>
                                        <br>
                                        <a href="user-support.php?ticket=<?php echo urlencode($ticket['ticket_number']); ?>" 
                                           class="btn btn-sm btn-outline-primary mt-2">
                                            <i class="fa fa-eye"></i> View
                                        </a>
                                    </div>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>

    <!-- Scripts -->
    <script src="assets/js/jquery-1.11.0.min.js"></script>
    <script src="assets/js/bootstrap.bundle.min.js"></script>
    <script src="assets/js/custom.js"></script>

    <script>
        function showSection(sectionId) {
            // Hide all sections
            document.querySelectorAll('.dashboard-section').forEach(section => {
                section.classList.remove('active');
            });

            // Show target section
            document.getElementById(sectionId).classList.add('active');

            // Update nav links
            document.querySelectorAll('.nav-link').forEach(link => {
                link.classList.remove('active');
            });
            document.querySelector(`[href="#${sectionId}"]`).classList.add('active');

            // Update URL hash
            window.history.replaceState(null, null, `#${sectionId}`);
        }

        function showMobileVerification() {
            window.location.href = 'mobile-verification.php';
        }

        // Handle initial page load with hash
        document.addEventListener('DOMContentLoaded', function() {
            const hash = window.location.hash.replace('#', '');
            if (hash && document.getElementById(hash)) {
                showSection(hash);
            }
        });

        // Handle browser back/forward
        window.addEventListener('hashchange', function() {
            const hash = window.location.hash.replace('#', '');
            if (hash && document.getElementById(hash)) {
                showSection(hash);
            }
        });

        // UPI ID validation
        document.querySelector('input[name="upi_id"]')?.addEventListener('input', function(e) {
            const value = e.target.value;
            const isValid = /^[\w\.-]+@[\w\.-]+$/.test(value);
            
            if (value && !isValid) {
                e.target.style.borderColor = '#dc3545';
            } else {
                e.target.style.borderColor = '#ced4da';
            }
        });
    </script>
</body>

</html>