<?php
require_once __DIR__ . '/partner-session.php';

// Require login
requirePartnerLogin();

// Get current partner
$partner = getCurrentPartner();
if (!$partner) {
    partnerLogout();
    header('Location: /partners/partner-login.php');
    exit;
}

$page_title = 'My Referrals - Detailed View';

// Helper function to mask email
function maskEmail($email) {
    if (empty($email)) return 'N/A';
    
    $parts = explode('@', $email);
    if (count($parts) !== 2) return $email;
    
    $username = $parts[0];
    $domain = $parts[1];
    
    $usernameLen = strlen($username);
    if ($usernameLen <= 3) {
        $maskedUsername = $username[0] . str_repeat('x', $usernameLen - 1);
    } else {
        $maskedUsername = substr($username, 0, 2) . str_repeat('x', $usernameLen - 2);
    }
    
    return $maskedUsername . '@' . $domain;
}

// Helper function to mask IP
function maskIP($ip) {
    if (empty($ip)) return 'N/A';
    
    $parts = explode('.', $ip);
    if (count($parts) === 4) {
        // IPv4
        return $parts[0] . '.' . $parts[1] . '.xxx.xxx';
    }
    
    // For IPv6 or other formats, mask last half
    $len = strlen($ip);
    return substr($ip, 0, ceil($len / 2)) . str_repeat('x', floor($len / 2));
}

// Get filter parameters
$statusFilter = $_GET['status'] ?? 'all';
$searchQuery = $_GET['search'] ?? '';
$dateFilter = $_GET['date'] ?? 'all';

try {
    $shopPdo = getPartnerDBConnection();
    $panelPdo = getPartnerPanelDBConnection();
    
    // Build the WHERE clause for filtering
    $whereConditions = ["asig.affiliate_id = ?"];
    $params = [$partner['id']];
    
    if ($statusFilter !== 'all') {
        switch ($statusFilter) {
            case 'clicked':
                $whereConditions[] = "asig.signup_completed = 0";
                break;
            case 'signed_up':
                $whereConditions[] = "asig.signup_completed = 1 AND asig.email_verified = 0";
                break;
            case 'verified':
                $whereConditions[] = "asig.email_verified = 1";
                break;
            case 'rewarded':
                $whereConditions[] = "asig.reward_paid = 1";
                break;
        }
    }
    
    if (!empty($searchQuery)) {
        $whereConditions[] = "(asig.email LIKE ? OR asig.ip_address LIKE ?)";
        $searchParam = '%' . $searchQuery . '%';
        $params[] = $searchParam;
        $params[] = $searchParam;
    }
    
    if ($dateFilter !== 'all') {
        switch ($dateFilter) {
            case 'today':
                $whereConditions[] = "DATE(asig.clicked_at) = CURDATE()";
                break;
            case 'yesterday':
                $whereConditions[] = "DATE(asig.clicked_at) = DATE_SUB(CURDATE(), INTERVAL 1 DAY)";
                break;
            case 'this_week':
                $whereConditions[] = "asig.clicked_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)";
                break;
            case 'this_month':
                $whereConditions[] = "asig.clicked_at >= DATE_SUB(NOW(), INTERVAL 30 DAY)";
                break;
        }
    }
    
    $whereClause = implode(' AND ', $whereConditions);
    
    // Fetch all signups with complete details
    $stmt = $shopPdo->prepare("
        SELECT 
            asig.*
        FROM affiliate_signups asig
        WHERE $whereClause
        ORDER BY asig.clicked_at DESC
    ");
    
    $stmt->execute($params);
    $signups = $stmt->fetchAll();
    
    // Get member details from panel database for verified signups
    $memberDetails = [];
    foreach ($signups as $signup) {
        if ($signup['panel_user_id']) {
            $stmt = $panelPdo->prepare("
                SELECT u.id, u.email, u.status, u.created_at,
                       up.points, up.total_earned, up.total_redeemed,
                       mv.mobile_number, mv.is_verified as mobile_verified
                FROM users u
                LEFT JOIN user_points up ON u.id = up.user_id
                LEFT JOIN mobile_verifications mv ON u.id = mv.user_id
                WHERE u.id = ?
            ");
            $stmt->execute([$signup['panel_user_id']]);
            $member = $stmt->fetch();
            if ($member) {
                $memberDetails[$signup['panel_user_id']] = $member;
            }
        }
    }
    
    // Calculate statistics
    $stats = [
        'total_clicks' => count($signups),
        'completed_signups' => 0,
        'verified_signups' => 0,
        'total_commission' => 0,
        'paid_commission' => 0
    ];
    
    foreach ($signups as $signup) {
        if ($signup['signup_completed']) $stats['completed_signups']++;
        if ($signup['email_verified']) $stats['verified_signups']++;
        $stats['total_commission'] += floatval($signup['commission_earned'] ?? 0);
        if ($signup['commission_paid']) $stats['paid_commission'] += floatval($signup['commission_earned'] ?? 0);
    }
    
} catch (Exception $e) {
    logPartnerActivity('Error fetching referrals: ' . $e->getMessage(), ['partner_id' => $partner['id']]);
    $signups = [];
    $memberDetails = [];
    $stats = ['total_clicks' => 0, 'completed_signups' => 0, 'verified_signups' => 0, 'total_commission' => 0, 'paid_commission' => 0];
}

$signup_url = SITE_URL . '/signup.php?ref=' . htmlspecialchars($partner['affiliate_code']);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo $page_title; ?> - <?php echo SITE_NAME; ?></title>
    
    <link rel="stylesheet" href="/assets/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    
    <style>
        :root {
            --primary-color: #59ab6e;
            --primary-hover: #4a9359;
            --secondary-color: #3e8e41;
            --danger-color: #dc3545;
            --warning-color: #ffc107;
            --info-color: #17a2b8;
            --light-bg: #f8f9fa;
            --border-color: #dee2e6;
        }
        
        body {
            font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif;
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            min-height: 100vh;
            padding-bottom: 50px;
        }
        
        .navbar {
            background: white;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
            margin-bottom: 30px;
        }
        
        .navbar-brand {
            font-weight: 700;
            color: var(--primary-color) !important;
            font-size: 1.5rem;
        }
        
        .nav-link {
            color: #333 !important;
            font-weight: 500;
            transition: color 0.3s;
        }
        
        .nav-link:hover {
            color: var(--primary-color) !important;
        }
        
        .main-container {
            max-width: 1400px;
            margin: 0 auto;
            padding: 0 20px;
        }
        
        .page-header {
            background: white;
            border-radius: 12px;
            padding: 25px 30px;
            margin-bottom: 25px;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
        }
        
        .page-header h2 {
            margin: 0 0 10px 0;
            color: #333;
            font-size: 28px;
            font-weight: 700;
        }
        
        .page-header p {
            margin: 0;
            color: #666;
            font-size: 15px;
        }
        
        .referral-link-box {
            background: white;
            border-radius: 12px;
            padding: 20px;
            margin-bottom: 25px;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
        }
        
        .referral-link-box h5 {
            margin: 0 0 15px 0;
            color: #333;
            font-size: 18px;
            font-weight: 600;
        }
        
        .link-display {
            display: flex;
            gap: 10px;
            align-items: center;
        }
        
        .link-display input {
            flex: 1;
            padding: 12px 15px;
            border: 2px solid var(--border-color);
            border-radius: 8px;
            font-size: 14px;
            background: #f8f9fa;
        }
        
        .btn-copy {
            padding: 12px 25px;
            background: var(--primary-color);
            color: white;
            border: none;
            border-radius: 8px;
            font-weight: 600;
            cursor: pointer;
            transition: background 0.3s;
        }
        
        .btn-copy:hover {
            background: var(--primary-hover);
        }
        
        .stats-row {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 20px;
            margin-bottom: 25px;
        }
        
        .stat-card {
            background: white;
            border-radius: 12px;
            padding: 20px;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
            text-align: center;
        }
        
        .stat-card .stat-value {
            font-size: 32px;
            font-weight: 700;
            color: var(--primary-color);
            margin: 10px 0;
        }
        
        .stat-card .stat-label {
            font-size: 14px;
            color: #666;
            font-weight: 500;
        }
        
        .filters-box {
            background: white;
            border-radius: 12px;
            padding: 20px;
            margin-bottom: 25px;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
        }
        
        .filters-row {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 15px;
            align-items: end;
        }
        
        .filter-group label {
            display: block;
            margin-bottom: 5px;
            font-weight: 600;
            color: #333;
            font-size: 14px;
        }
        
        .filter-group select,
        .filter-group input {
            width: 100%;
            padding: 10px;
            border: 2px solid var(--border-color);
            border-radius: 8px;
            font-size: 14px;
        }
        
        .btn-filter {
            padding: 10px 20px;
            background: var(--primary-color);
            color: white;
            border: none;
            border-radius: 8px;
            font-weight: 600;
            cursor: pointer;
            transition: background 0.3s;
        }
        
        .btn-filter:hover {
            background: var(--primary-hover);
        }
        
        .btn-reset {
            padding: 10px 20px;
            background: #6c757d;
            color: white;
            border: none;
            border-radius: 8px;
            font-weight: 600;
            cursor: pointer;
            transition: background 0.3s;
        }
        
        .btn-reset:hover {
            background: #5a6268;
        }
        
        .table-container {
            background: white;
            border-radius: 12px;
            padding: 0;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
            overflow: hidden;
        }
        
        .table {
            margin: 0;
        }
        
        .table thead {
            background: #f8f9fa;
        }
        
        .table thead th {
            padding: 15px 12px;
            font-weight: 600;
            color: #333;
            border: none;
            font-size: 13px;
            text-transform: uppercase;
            letter-spacing: 0.5px;
        }
        
        .table tbody td {
            padding: 12px;
            vertical-align: middle;
            border-top: 1px solid #f0f0f0;
            font-size: 14px;
        }
        
        .table tbody tr:hover {
            background: #f8f9fa;
        }
        
        .status-badge {
            display: inline-block;
            padding: 5px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
            text-transform: uppercase;
        }
        
        .status-clicked {
            background: #e3f2fd;
            color: #1976d2;
        }
        
        .status-signed-up {
            background: #fff3e0;
            color: #f57c00;
        }
        
        .status-verified {
            background: #e8f5e9;
            color: #388e3c;
        }
        
        .yes-badge {
            color: #28a745;
            font-weight: 600;
        }
        
        .no-badge {
            color: #dc3545;
            font-weight: 600;
        }
        
        .commission-amount {
            font-weight: 700;
            color: var(--primary-color);
            font-size: 15px;
        }
        
        .member-info {
            font-size: 13px;
            color: #666;
            margin-top: 5px;
        }
        
        .empty-state {
            text-align: center;
            padding: 60px 20px;
            color: #666;
        }
        
        .empty-state i {
            font-size: 64px;
            color: #ccc;
            margin-bottom: 20px;
        }
        
        .empty-state h4 {
            margin: 0 0 10px 0;
            color: #333;
        }
        
        .technical-info {
            font-size: 11px;
            color: #999;
            font-family: monospace;
        }
        
        .tooltip-info {
            cursor: help;
            border-bottom: 1px dotted #999;
        }
    </style>
</head>
<body>
    <!-- Navigation -->
    <nav class="navbar navbar-expand-lg navbar-light">
        <div class="container-fluid">
            <a class="navbar-brand" href="/partners/partner-dashboard.php">
                <i class="fas fa-handshake"></i> Partner Portal
            </a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ms-auto">
                    <li class="nav-item">
                        <a class="nav-link" href="/partners/partner-dashboard.php">
                            <i class="fas fa-home"></i> Dashboard
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link active" href="/partners/members.php">
                            <i class="fas fa-users"></i> My Referrals
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="/support?partner=<?php echo $partner['id']; ?>">
                            <i class="fas fa-headset"></i> Support
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="/partners/logout.php">
                            <i class="fas fa-sign-out-alt"></i> Logout
                        </a>
                    </li>
                </ul>
            </div>
        </div>
    </nav>
    
    <!-- Main Content -->
    <div class="main-container">
        <!-- Page Header -->
        <div class="page-header">
            <h2><i class="fas fa-users"></i> My Referrals - Complete Tracking</h2>
            <p>View all clicks, signups, and conversions from your referral link</p>
        </div>
        
        <!-- Referral Link Box -->
        <div class="referral-link-box">
            <h5><i class="fas fa-link"></i> Your Referral Link</h5>
            <div class="link-display">
                <input type="text" id="referral-link" value="<?php echo $signup_url; ?>" readonly>
                <button class="btn-copy" onclick="copyReferralLink()">
                    <i class="fas fa-copy"></i> Copy Link
                </button>
            </div>
        </div>
        
        <!-- Statistics -->
        <div class="stats-row">
            <div class="stat-card">
                <i class="fas fa-mouse-pointer" style="font-size: 24px; color: #17a2b8;"></i>
                <div class="stat-value"><?php echo number_format($stats['total_clicks']); ?></div>
                <div class="stat-label">Total Clicks</div>
            </div>
            <div class="stat-card">
                <i class="fas fa-user-plus" style="font-size: 24px; color: #ffc107;"></i>
                <div class="stat-value"><?php echo number_format($stats['completed_signups']); ?></div>
                <div class="stat-label">Completed Signups</div>
            </div>
            <div class="stat-card">
                <i class="fas fa-user-check" style="font-size: 24px; color: #28a745;"></i>
                <div class="stat-value"><?php echo number_format($stats['verified_signups']); ?></div>
                <div class="stat-label">Verified Members</div>
            </div>
            <div class="stat-card">
                <i class="fas fa-rupee-sign" style="font-size: 24px; color: #59ab6e;"></i>
                <div class="stat-value">₹<?php echo number_format($stats['total_commission'], 2); ?></div>
                <div class="stat-label">Total Commission</div>
            </div>
        </div>
        
        <!-- Filters -->
        <div class="filters-box">
            <form method="GET" action="">
                <div class="filters-row">
                    <div class="filter-group">
                        <label for="status">Status Filter</label>
                        <select name="status" id="status">
                            <option value="all" <?php echo $statusFilter === 'all' ? 'selected' : ''; ?>>All Status</option>
                            <option value="clicked" <?php echo $statusFilter === 'clicked' ? 'selected' : ''; ?>>Just Clicked</option>
                            <option value="signed_up" <?php echo $statusFilter === 'signed_up' ? 'selected' : ''; ?>>Signed Up</option>
                            <option value="verified" <?php echo $statusFilter === 'verified' ? 'selected' : ''; ?>>Verified</option>
                            <option value="rewarded" <?php echo $statusFilter === 'rewarded' ? 'selected' : ''; ?>>Rewarded</option>
                        </select>
                    </div>
                    <div class="filter-group">
                        <label for="date">Date Filter</label>
                        <select name="date" id="date">
                            <option value="all" <?php echo $dateFilter === 'all' ? 'selected' : ''; ?>>All Time</option>
                            <option value="today" <?php echo $dateFilter === 'today' ? 'selected' : ''; ?>>Today</option>
                            <option value="yesterday" <?php echo $dateFilter === 'yesterday' ? 'selected' : ''; ?>>Yesterday</option>
                            <option value="this_week" <?php echo $dateFilter === 'this_week' ? 'selected' : ''; ?>>Last 7 Days</option>
                            <option value="this_month" <?php echo $dateFilter === 'this_month' ? 'selected' : ''; ?>>Last 30 Days</option>
                        </select>
                    </div>
                    <div class="filter-group">
                        <label for="search">Search (Email/IP)</label>
                        <input type="text" name="search" id="search" value="<?php echo htmlspecialchars($searchQuery); ?>" placeholder="Search...">
                    </div>
                    <div class="filter-group">
                        <button type="submit" class="btn-filter">
                            <i class="fas fa-filter"></i> Apply Filters
                        </button>
                    </div>
                    <div class="filter-group">
                        <a href="/partners/members.php" class="btn-reset">
                            <i class="fas fa-redo"></i> Reset
                        </a>
                    </div>
                </div>
            </form>
        </div>
        
        <!-- Referrals Table -->
        <div class="table-container">
            <?php if (empty($signups)): ?>
                <div class="empty-state">
                    <i class="fas fa-users-slash"></i>
                    <h4>No Referrals Found</h4>
                    <p>Share your referral link to start tracking signups!</p>
                </div>
            <?php else: ?>
                <div class="table-responsive">
                    <table class="table">
                        <thead>
                            <tr>
                                <th>Date & Time</th>
                                <th>Email</th>
                                <th>Status</th>
                                <th>Verified</th>
                                <th>Reward Paid</th>
                                <th>Commission</th>
                                <th>Member Info</th>
                                <th>Technical Details</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($signups as $signup): ?>
                                <?php
                                $member = isset($signup['panel_user_id']) && isset($memberDetails[$signup['panel_user_id']]) 
                                    ? $memberDetails[$signup['panel_user_id']] : null;
                                
                                // Determine status
                                $status = 'Clicked Only';
                                $statusClass = 'status-clicked';
                                if ($signup['email_verified']) {
                                    $status = 'Verified';
                                    $statusClass = 'status-verified';
                                } elseif ($signup['signup_completed']) {
                                    $status = 'Signed Up';
                                    $statusClass = 'status-signed-up';
                                }
                                ?>
                                <tr>
                                    <td>
                                        <strong><?php echo date('M d, Y', strtotime($signup['clicked_at'])); ?></strong><br>
                                        <small style="color: #666;"><?php echo date('g:i A', strtotime($signup['clicked_at'])); ?></small>
                                        <?php if ($signup['signed_up_at']): ?>
                                            <br><small style="color: #999;">Signed: <?php echo date('M d, g:i A', strtotime($signup['signed_up_at'])); ?></small>
                                        <?php endif; ?>
                                        <?php if ($signup['verified_at']): ?>
                                            <br><small style="color: #28a745;">Verified: <?php echo date('M d, g:i A', strtotime($signup['verified_at'])); ?></small>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <?php if ($signup['email']): ?>
                                            <strong style="font-family: monospace; color: #666;"><?php echo maskEmail($signup['email']); ?></strong>
                                        <?php else: ?>
                                            <em style="color: #999;">Not completed</em>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <span class="status-badge <?php echo $statusClass; ?>">
                                            <?php echo $status; ?>
                                        </span>
                                    </td>
                                    <td>
                                        <?php if ($signup['email_verified']): ?>
                                            <span class="yes-badge"><i class="fas fa-check-circle"></i> Yes</span>
                                        <?php else: ?>
                                            <span class="no-badge"><i class="fas fa-times-circle"></i> No</span>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <?php if ($signup['reward_paid']): ?>
                                            <span class="yes-badge"><i class="fas fa-check-circle"></i> Yes</span>
                                        <?php else: ?>
                                            <span class="no-badge"><i class="fas fa-times-circle"></i> Pending</span>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <span class="commission-amount">
                                            ₹<?php echo number_format($signup['commission_earned'] ?? 0, 2); ?>
                                        </span>
                                        <?php if ($signup['commission_paid']): ?>
                                            <br><small style="color: #28a745;"><i class="fas fa-check"></i> Paid</small>
                                        <?php else: ?>
                                            <br><small style="color: #ffc107;"><i class="fas fa-clock"></i> Pending</small>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <?php if ($member): ?>
                                            <div class="member-info">
                                                <strong>Points:</strong> <?php echo number_format($member['points'] ?? 0, 0); ?> pts<br>
                                                <strong>Earned:</strong> ₹<?php echo number_format(($member['total_earned'] ?? 0) * 0.5, 2); ?><br>
                                                <strong>Status:</strong> <?php echo ucfirst($member['status']); ?>
                                                <?php if ($member['mobile_verified']): ?>
                                                    <br><i class="fas fa-mobile-alt" style="color: #28a745;"></i> Mobile Verified
                                                <?php endif; ?>
                                            </div>
                                        <?php else: ?>
                                            <em style="color: #999;">N/A</em>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <div class="technical-info">
                                            <strong>IP:</strong> <?php echo maskIP($signup['ip_address'] ?? ''); ?><br>
                                            <?php if ($signup['user_agent']): ?>
                                                <span class="tooltip-info" title="<?php echo htmlspecialchars($signup['user_agent']); ?>">
                                                    <strong>Browser:</strong> 
                                                    <?php
                                                    $ua = $signup['user_agent'];
                                                    if (strpos($ua, 'Chrome') !== false) echo 'Chrome';
                                                    elseif (strpos($ua, 'Firefox') !== false) echo 'Firefox';
                                                    elseif (strpos($ua, 'Safari') !== false) echo 'Safari';
                                                    elseif (strpos($ua, 'Edge') !== false) echo 'Edge';
                                                    else echo 'Other';
                                                    ?>
                                                </span>
                                            <?php endif; ?>
                                        </div>
                                    </td>
                                </tr>
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>
            <?php endif; ?>
        </div>
        
        <div style="text-align: center; margin-top: 30px; color: white;">
            <p>Total Results: <strong><?php echo count($signups); ?></strong></p>
        </div>
    </div>
    
    <script src="/assets/js/jquery-1.11.0.min.js"></script>
    <script src="/assets/js/bootstrap.bundle.min.js"></script>
    <script>
        function copyReferralLink() {
            const linkInput = document.getElementById('referral-link');
            linkInput.select();
            linkInput.setSelectionRange(0, 99999); // For mobile devices
            
            navigator.clipboard.writeText(linkInput.value).then(function() {
                alert('Referral link copied to clipboard!');
            }).catch(function(err) {
                console.error('Could not copy text: ', err);
                // Fallback for older browsers
                document.execCommand('copy');
                alert('Referral link copied to clipboard!');
            });
        }
    </script>
</body>
</html>