prepare(" SELECT COUNT(*) as total FROM affiliate_signups asig WHERE $whereClause "); $countStmt->execute($params); $totalRecords = $countStmt->fetch()['total']; $totalPages = ceil($totalRecords / $perPage); // Get paginated signups $stmt = $shopPdo->prepare(" SELECT * FROM affiliate_signups asig WHERE $whereClause ORDER BY asig.clicked_at DESC LIMIT $perPage OFFSET $offset "); $stmt->execute($params); $signups = $stmt->fetchAll(); // Get member details from panel database $memberDetails = []; if (!empty($signups)) { $memberIds = array_filter(array_column($signups, 'panel_user_id')); if (!empty($memberIds)) { $placeholders = str_repeat('?,', count($memberIds) - 1) . '?'; $stmt = $panelPdo->prepare(" SELECT u.id, u.email, u.gender, u.date_of_birth, u.postcode, u.status, u.email_verified, u.onboarding_completed, u.created_at, u.last_login, 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 IN ($placeholders) "); $stmt->execute($memberIds); $members = $stmt->fetchAll(); foreach ($members as $member) { $memberDetails[$member['id']] = $member; } } } } catch (Exception $e) { logPartnerActivity('Error fetching members list', [ 'partner_id' => $partner['id'], 'error' => $e->getMessage() ]); $signups = []; $totalRecords = 0; $totalPages = 0; } $page_title = 'My Members'; ?> <?php echo $page_title; ?> - Relevant Reflex Partners

My Referred Members

Track all members who signed up using your referral link

No members found.
Click Date Email Signup Status Verification Account Status Points Last Activity Commission

✓ Completed
Clicked Only
✓ Verified
Pending
Active Inactive - pts
Earned: -
Never
Paid 0): ?>
Pending
1): ?>