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

Reset
Total:
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): ?>