prepare(" SELECT COUNT(*) as total_signups, SUM(CASE WHEN signup_completed = 1 THEN 1 ELSE 0 END) as completed_signups, SUM(CASE WHEN email_verified = 1 THEN 1 ELSE 0 END) as verified_signups FROM affiliate_signups WHERE affiliate_id = ? "); $stmt->execute([$partner['id']]); $calculatedStats = $stmt->fetch(); // Calculate commission: Rs. 10 per verified, Rs. 5 per signup (not verified) $verifiedCommission = $calculatedStats['verified_signups'] * 10.00; $signupOnlyCommission = ($calculatedStats['completed_signups'] - $calculatedStats['verified_signups']) * 5.00; $totalCommission = $verifiedCommission + $signupOnlyCommission; // Update commission_earned in affiliate_signups table $stmt = $shopPdo->prepare(" UPDATE affiliate_signups SET commission_earned = CASE WHEN email_verified = 1 THEN 10.00 WHEN signup_completed = 1 THEN 5.00 ELSE 0 END WHERE affiliate_id = ? "); $stmt->execute([$partner['id']]); // Update the affiliate record with calculated values $stmt = $shopPdo->prepare(" UPDATE affiliates SET total_commission_earned = ?, commission_balance = ? - COALESCE(total_commission_redeemed, 0), total_signups = ?, total_verified_signups = ? WHERE id = ? "); $stmt->execute([ $totalCommission, $totalCommission, $calculatedStats['total_signups'], $calculatedStats['verified_signups'], $partner['id'] ]); // NOW fetch the updated partner data $stmt = $shopPdo->prepare(" SELECT * FROM affiliates WHERE id = ? "); $stmt->execute([$partner['id']]); $partner = $stmt->fetch(); // Refresh partner data with updated values // Get referred members stats $stmt = $shopPdo->prepare(" SELECT COUNT(*) as total_signups, SUM(CASE WHEN signup_completed = 1 THEN 1 ELSE 0 END) as completed_signups, SUM(CASE WHEN email_verified = 1 THEN 1 ELSE 0 END) as verified_signups, SUM(reward_amount) as total_rewards_distributed, SUM(commission_earned) as total_commission_earned FROM affiliate_signups WHERE affiliate_id = ? "); $stmt->execute([$partner['id']]); $signupStats = $stmt->fetch(); // Get recent signups (last 10) $stmt = $shopPdo->prepare(" SELECT * FROM affiliate_signups WHERE affiliate_id = ? ORDER BY clicked_at DESC LIMIT 10 "); $stmt->execute([$partner['id']]); $recentSignups = $stmt->fetchAll(); // Get member details from panel database for verified signups $memberDetails = []; foreach ($recentSignups as $signup) { if ($signup['panel_user_id']) { $stmt = $panelPdo->prepare(" SELECT u.id, u.email, u.status, up.points, up.total_earned, up.total_redeemed FROM users u LEFT JOIN user_points up ON u.id = up.user_id WHERE u.id = ? "); $stmt->execute([$signup['panel_user_id']]); $member = $stmt->fetch(); if ($member) { $memberDetails[$signup['panel_user_id']] = $member; } } } } catch (Exception $e) { logPartnerActivity('Error fetching dashboard stats: ' . $e->getMessage(), ['partner_id' => $partner['id']]); $signupStats = ['total_signups' => 0, 'completed_signups' => 0, 'verified_signups' => 0, 'total_rewards_distributed' => 0, 'total_commission_earned' => 0]; $recentSignups = []; $memberDetails = []; } ?> Partner Dashboard - <?php echo SITE_NAME; ?>

Welcome back, ! 👋

Affiliate Code:

Your Referral Link: /signup.php?ref=

Total Clicks/Signups

Verified Members

₹

Commission Balance

₹

Total Earned

Commission Structure

Base Signup Reward: ₹ per completed signup

Verified Signup Bonus: Additional commission when member verifies email

Current Balance: ₹

Total Earned: ₹

You need ₹ more to request a redemption. (Minimum: ₹)
You can now request a redemption! Your current balance is ₹

Recent Referrals (Last 10)

No signups yet. Share your referral link to start earning!
Date Email Status Verified Commission
Not completed Yes No ₹
View All Referrals (Detailed Tracking)

Need Help?

If you have any questions or need assistance, please don't hesitate to contact our support team.

Contact Support