= 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); $stmt = $shopPdo->prepare("SELECT asig.* FROM affiliate_signups asig WHERE $whereClause ORDER BY asig.clicked_at DESC"); $stmt->execute($params); $signups = $stmt->fetchAll(); $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; } } $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 = (defined('SITE_URL') ? SITE_URL : 'https://relevantreflex.com') . '/signup.php?ref=' . htmlspecialchars($partner['affiliate_code']); ?> <?php echo $page_title; ?> - <?php echo defined('SITE_NAME') ? SITE_NAME : 'RelevantReflex'; ?>
RELEVANT REFLEXPARTNERS
Overview Referrals Rewards Account Members Support
Logout

My Referrals - Complete Tracking

View all clicks, signups, and conversions from your referral link

Your Referral Link
Total Clicks
Completed Signups
Verified Members
₹
Total Commission
Reset

No Referrals Found

Share your referral link to start tracking signups!

Date & TimeEmailStatusVerifiedReward PaidCommissionMember InfoTechnical


Signed:
Verified: 		Not completed Yes' : ' No'; ?> Yes' : ' Pending'; ?> ₹ Paid' : '
Pending'; ?>
Points: pts
Earned: ₹
Status:
Mobile Verified
N/A
IP:
Browser:

Total Results: