File Manager

✏️ Edit File: /home/samridhistore.com/public_html/franchise/process_bv_final.php

<?php
session_start();
if (!isset($_SESSION['franchise_logged_in']) || $_SESSION['franchise_logged_in'] !== true) {
    header('Location: login.php');
    exit;
}

include '../config.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $member_id = $_POST['member_id'];
    $amount = $_POST['amount'];
    $description = $_POST['description'];
    $franchise_id = $_SESSION['franchise_id'];
    
    // Validate member exists
    $stmt = $conn->prepare("SELECT id, name, status FROM members WHERE member_id = ?");
    $stmt->bind_param("s", $member_id);
    $stmt->execute();
    $member_result = $stmt->get_result();
    
    if ($member_result->num_rows === 0) {
        header('Location: dashboard.php?error=Member not found');
        exit;
    }
    
    $member = $member_result->fetch_assoc();
    if ($member['status'] !== 'active') {
        header('Location: dashboard.php?error=Member account is inactive');
        exit;
    }
    
    // Start transaction
    $conn->begin_transaction();
    
    try {
        // Record BV entry transaction
        $stmt = $conn->prepare("INSERT INTO transactions (user_id, user_type, transaction_type, amount, description, bv_amount, franchise_id) VALUES (?, 'member', 'bv_entry', ?, ?, ?, ?)");
        $stmt->bind_param("sdsss", $member_id, $amount, $description, $amount, $franchise_id);
        $stmt->execute();
        $transaction_id = $conn->insert_id;
        
        // Calculate commissions
        calculateCommissions($conn, $member_id, $amount, $transaction_id, $franchise_id);
        
        // Update member wallet for direct income (15%)
        $direct_income = $amount * 0.15;
        $stmt = $conn->prepare("UPDATE members SET wallet_balance = wallet_balance + ? WHERE member_id = ?");
        $stmt->bind_param("ds", $direct_income, $member_id);
        $stmt->execute();
        
        // Record direct commission
        $stmt = $conn->prepare("INSERT INTO commissions (member_id, from_member_id, commission_type, amount, description, transaction_id) VALUES (?, ?, 'direct', ?, 'Direct Income from purchase', ?)");
        $stmt->bind_param("ssdi", $member_id, $member_id, $direct_income, $transaction_id);
        $stmt->execute();
        
        // Update franchise wallet for franchise income (10%)
        $franchise_income = $amount * 0.10;
        $stmt = $conn->prepare("UPDATE franchises SET wallet_balance = wallet_balance + ?, total_earnings = total_earnings + ? WHERE franchise_id = ?");
        $stmt->bind_param("dds", $franchise_income, $franchise_income, $franchise_id);
        $stmt->execute();
        
        // Record franchise commission
        $stmt = $conn->prepare("INSERT INTO commissions (member_id, from_member_id, commission_type, amount, description, transaction_id) VALUES (?, ?, 'franchise', ?, 'Franchise Income', ?)");
        $stmt->bind_param("ssdi", $franchise_id, $member_id, $franchise_income, $transaction_id);
        $stmt->execute();
        
        // Update member status to green if BV >= 100
        if ($amount >= 100) {
            // In a real implementation, you would set a flag or update a field
            // For now, we'll just add a note to the description
        }
        
        $conn->commit();
        header('Location: dashboard.php?success=BV entry recorded successfully');
        exit;
    } catch (Exception $e) {
        $conn->rollback();
        header('Location: dashboard.php?error=Error recording BV entry: ' . $e->getMessage());
        exit;
    }
}

function calculateCommissions($conn, $member_id, $amount, $transaction_id, $franchise_id) {
    // Get level commission percentages from database
    $level_percentages = [];
    $max_level = 0;
    
    $level_result = $conn->query("SELECT level_number, percentage FROM level_settings ORDER BY level_number ASC");
    while ($row = $level_result->fetch_assoc()) {
        $level_percentages[$row['level_number']] = $row['percentage'] / 100;
        if ($row['level_number'] > $max_level) {
            $max_level = $row['level_number'];
        }
    }

// Get member's sponsor hierarchy
    $sponsor_chain = getSponsorChain($conn, $member_id, $max_level);
    
    // Calculate level income
    foreach ($sponsor_chain as $level => $sponsor) {
        if (isset($level_percentages[$level])) {
            $commission_amount = $amount * $level_percentages[$level];
            
            // Update sponsor wallet
            $stmt = $conn->prepare("UPDATE members SET wallet_balance = wallet_balance + ? WHERE member_id = ?");
            $stmt->bind_param("ds", $commission_amount, $sponsor['member_id']);
            $stmt->execute();
            
            // Record level commission
            // Fixed: The SQL has 5 placeholders and we need 5 variables in bind_param
            $stmt = $conn->prepare("INSERT INTO commissions (member_id, from_member_id, commission_type, level_number, amount, description, transaction_id) VALUES (?, ?, 'level', ?, ?, 'Level Income', ?)");
            $stmt->bind_param("ssidi", $sponsor['member_id'], $member_id, $level, $commission_amount, $transaction_id);
            $stmt->execute();
        }
    }
    
    // Calculate royalty income based on rank settings
    calculateRoyaltyIncome($conn, $member_id, $amount, $transaction_id, $sponsor_chain);
    
    // Calculate franchise team income
    calculateFranchiseTeamIncome($conn, $member_id, $amount, $transaction_id, $franchise_id);
}

function calculateFranchiseTeamIncome($conn, $member_id, $amount, $transaction_id, $franchise_id) {
    // In a real implementation, you would traverse the franchise hierarchy
    // For now, we'll just give team income to the current franchise
    $team_income = $amount * 0.04; // Level 1 franchise team income
    $level_number = 1; // Define as variable instead of literal to avoid bind_param error
    
    // Update franchise wallet
    $stmt = $conn->prepare("UPDATE franchises SET wallet_balance = wallet_balance + ?, total_earnings = total_earnings + ? WHERE franchise_id = ?");
    $stmt->bind_param("dds", $team_income, $team_income, $franchise_id);
    $stmt->execute();
    
    // Record franchise team commission
    $stmt = $conn->prepare("INSERT INTO commissions (member_id, from_member_id, commission_type, level_number, amount, description, transaction_id) VALUES (?, ?, 'franchise', ?, ?, 'Franchise Team Income', ?)");
    $stmt->bind_param("ssdis", $franchise_id, $member_id, $level_number, $team_income, $transaction_id);
    $stmt->execute();
}

// Function to count referrals at a specific level
function getReferralsAtLevel($conn, $member_id, $target_level) {
    if ($target_level == 1) {
        // Level 1: Direct referrals
        $stmt = $conn->prepare("SELECT COUNT(*) as referrals FROM members WHERE sponsor_id = ?");
        $stmt->bind_param("s", $member_id);
        $stmt->execute();
        $result = $stmt->get_result();
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            return $row['referrals'];
        }
    } else {
        // Level N: Referrals at level N
        // Build a dynamic query to get referrals at the specified level
        $join_clauses = "";
        $where_conditions = "";
        
        for ($i = 1; $i < $target_level; $i++) {
            $join_clauses .= " JOIN members m" . ($i + 1) . " ON m" . $i . ".member_id = m" . ($i + 1) . ".sponsor_id";
        }
        
        $where_conditions = "m1.sponsor_id = ?";
        
        $query = "SELECT COUNT(*) as referrals FROM members m1" . $join_clauses . " WHERE " . $where_conditions;
        
        $stmt = $conn->prepare($query);
        $stmt->bind_param("s", $member_id);
        $stmt->execute();
        $result = $stmt->get_result();
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            return $row['referrals'];
        }
    }
    
    return 0;
}

// Function to update member rank based on specific level referrals
function updateMemberRank($conn, $member_id) {
    // Get referrals at each level
    $level1_referrals = getReferralsAtLevel($conn, $member_id, 1);
    $level2_referrals = getReferralsAtLevel($conn, $member_id, 2);
    $level3_referrals = getReferralsAtLevel($conn, $member_id, 3);
    $level4_referrals = getReferralsAtLevel($conn, $member_id, 4);
    $level5_referrals = getReferralsAtLevel($conn, $member_id, 5);
    $level6_referrals = getReferralsAtLevel($conn, $member_id, 6);
    $level7_referrals = getReferralsAtLevel($conn, $member_id, 7);
    
    // Get all active rank settings ordered by team size
    $rank_result = $conn->query("SELECT * FROM rank_settings WHERE status = 'active' ORDER BY team_size ASC");
    $ranks = [];
    while ($row = $rank_result->fetch_assoc()) {
        $ranks[] = $row;
    }
    
    // Determine rank based on level-specific requirements
    $qualified_rank = 'Newbie'; // Default rank
    
    // Check each rank based on the database settings
    foreach ($ranks as $rank) {
        $required_referrals = $rank['team_size'];
        $target_level = $rank['max_level'];
        
        // Get referrals at the target level for this rank
        $referrals_at_target_level = 0;
        switch ($target_level) {
            case 1: $referrals_at_target_level = $level1_referrals; break;
            case 2: $referrals_at_target_level = $level2_referrals; break;
            case 3: $referrals_at_target_level = $level3_referrals; break;
            case 4: $referrals_at_target_level = $level4_referrals; break;
            case 5: $referrals_at_target_level = $level5_referrals; break;
            case 6: $referrals_at_target_level = $level6_referrals; break;
            case 7: $referrals_at_target_level = $level7_referrals; break;
        }
        
        // If member meets this rank's requirements, update their qualified rank
        // Since ranks are ordered by team_size, the last one that qualifies is the highest
        if ($referrals_at_target_level >= $required_referrals) {
            $qualified_rank = $rank['rank_name'];
        }
    }
    
    // Update member's rank
    $stmt = $conn->prepare("UPDATE members SET rank = ? WHERE member_id = ?");
    $stmt->bind_param("ss", $qualified_rank, $member_id);
    $stmt->execute();
}
?>

Batal

⬅ Naik ke public_html 25 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘1process_bv.php	php	20.7 KB	2026-01-19 14:39	✏️ Edit 👁️ View
🐘1process_bv_corrected.php	php	12.9 KB	2025-10-17 18:31	✏️ Edit 👁️ View
🐘1process_bv_final.php	php	13 KB	2025-10-17 18:31	✏️ Edit 👁️ View
🐘1register_process.php	php	2.6 KB	2025-10-10 00:26	✏️ Edit 👁️ View
🐘auth.php	php	1 KB	2025-10-09 22:03	✏️ Edit 👁️ View
🐘bv_entry.php	php	23.5 KB	2026-01-17 09:53	✏️ Edit 👁️ View
🐘check_member.php	php	698 B	2026-01-17 09:39	✏️ Edit 👁️ View
🐘dashboard.php	php	15.4 KB	2025-10-22 07:26	✏️ Edit 👁️ View
🐘forgot_password.php	php	8.4 KB	2025-10-17 23:00	✏️ Edit 👁️ View
🐘header.php	php	369 B	2025-10-09 23:34	✏️ Edit 👁️ View
🐘login.php	php	6.8 KB	2025-10-17 23:00	✏️ Edit 👁️ View
🐘logout.php	php	86 B	2025-10-09 22:03	✏️ Edit 👁️ View
🐘mobile_sidebar.php	php	2.8 KB	2025-10-09 23:37	✏️ Edit 👁️ View
🐘process_bv.php	php	20.7 KB	2026-02-18 07:52	✏️ Edit 👁️ View
🐘process_bv_corrected.php	php	13.1 KB	2026-02-18 07:52	✏️ Edit 👁️ View
🐘process_bv_final.php	php	13.2 KB	2026-02-18 07:50	✏️ Edit 👁️ View
🐘process_bv_fixed.php	php	13.8 KB	2025-10-17 18:31	✏️ Edit 👁️ View
🐘profile.php	php	13.5 KB	2025-10-09 23:39	✏️ Edit 👁️ View
🐘register.php	php	14.2 KB	2025-10-10 01:31	✏️ Edit 👁️ View
🐘register_process.php	php	2.7 KB	2026-01-25 12:30	✏️ Edit 👁️ View
🐘reset_password.php	php	8.7 KB	2025-10-17 23:00	✏️ Edit 👁️ View
🐘transactions.php	php	7.8 KB	2025-10-09 23:47	✏️ Edit 👁️ View
🐘wallet.php	php	10.7 KB	2025-10-17 19:14	✏️ Edit 👁️ View
🐘wallet_topup.php	php	15.6 KB	2025-10-22 07:25	✏️ Edit 👁️ View
🐘withdraw.php	php	14.2 KB	2025-10-17 22:05	✏️ Edit 👁️ View