.-.-.-.-.-

<?php session_start();
include "../connection.php";
if(!isset($_SESSION['adminid'])) die('Unauthorized');
$commit_id = $_GET['commit_id'];

$row = mysqli_fetch_object(mysqli_query($connection,"SELECT uid, amount, first_commit, balance_amount FROM commit WHERE commit_id='$commit_id'"));

$user = mysqli_fetch_object(mysqli_query($connection,"SELECT referal_wallet, binary_wallet, fund_wallet FROM user WHERE uid='$row->uid'"));
$total = $user->referal_wallet+$user->binary_wallet+$user->fund_wallet+$row->balance_amount;

if($total>=$row->amount){
    mysqli_query($connection,"INSERT INTO `deduct` (`uid`, `amount`, `datetime`) VALUES ('".$row->uid."','".$row->amount."','".date('Y-m-d H:i:s')."')");
    
    $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$row->uid' ORDER BY recid DESC LIMIT 1"))->balance;
    if($balance){
        $balance = $balance-$row->amount;
    }
    else{
        $balance = -$row->amount;
    }
    mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$row->uid."','".$row->amount."','".date('Y-m-d H:i:s')."',11,'$balance')");
    
    $amount2 = $row->amount;
        
    if($user->referal_wallet>0 && $amount2>0){
        if($user->referal_wallet<=$amount2){
            $amount2 = $amount2-$user->referal_wallet;
            mysqli_query($connection,"UPDATE user SET referal_wallet=0 WHERE uid='".$row->uid."'");
        }
        else{
            mysqli_query($connection,"UPDATE user SET referal_wallet=referal_wallet-'$amount2' WHERE uid='".$row->uid."'");
            $amount2 = 0;
        }
    }
    if($user->binary_wallet>0 && $amount2>0){
        if($user->binary_wallet<=$amount2){
            $amount2 = $amount2-$user->binary_wallet;
            mysqli_query($connection,"UPDATE user SET binary_wallet=0 WHERE uid='".$row->uid."'");
        }
        else{
            mysqli_query($connection,"UPDATE user SET binary_wallet=binary_wallet-'$amount2' WHERE uid='".$row->uid."'");
            $amount2 = 0;
        }
    }
    if($user->fund_wallet>0 && $amount2>0){
        if($user->fund_wallet<=$amount2){
            $amount2 = $amount2-$user->fund_wallet;
            mysqli_query($connection,"UPDATE user SET fund_wallet=0 WHERE uid='".$row->uid."'");
        }
        else{
            mysqli_query($connection,"UPDATE user SET fund_wallet=fund_wallet-'$amount2' WHERE uid='".$row->uid."'");
            $amount2 = 0;
        }
    }
        
    $commit_result = mysqli_query($connection,"SELECT commit_id, balance_amount FROM `commit` WHERE uid='".$row->uid."' AND confirm_status=1 AND assign_complite=0 ORDER BY commit_id ASC");
    while ($commit_row = mysqli_fetch_object($commit_result)){
        if($commit_row->balance_amount>0 && $amount2>0){
            if($commit_row->balance_amount<=$amount2){
                $amount2 = $amount2-$commit_row->balance_amount;
                mysqli_query($connection,"UPDATE commit SET balance_amount= balance_amount-'$commit_row->balance_amount' WHERE commit_id='".$commit_row->commit_id."' AND assign_complite=0 AND uid='$row->uid'");
            }
            else{
                mysqli_query($connection,"UPDATE commit SET balance_amount= balance_amount-'$amount2' WHERE commit_id='".$commit_row->commit_id."' AND assign_complite=0 AND uid='$row->uid'");
                $amount2 = 0;
            }
        }

$check_assign = mysqli_query($connection,"SELECT commit_id FROM commit WHERE commit_id='$commit_row->commit_id' AND balance_amount<=0 AND status=1");
        if(mysqli_num_rows($check_assign)>0){
            //mysqli_query($connection,"UPDATE commit SET assign_complite=1, assign_complite_datetime='".date('Y-m-d H:i:s')."' WHERE commit_id='".$commit_row->commit_id."'");
        }

if($amount2==0){
            break;
        }
    }

/* direct referral */

if($row->first_commit==1){
        $refer = mysqli_fetch_object(mysqli_query($connection,"SELECT refer_id FROM user WHERE uid='".$row->uid."'"))->refer_id;
        $refer_type = mysqli_fetch_object(mysqli_query($connection,"SELECT type FROM user WHERE uid='".$refer."'"))->type;

$new_amount = $row->amount*0.2;

if($refer!=0){
            $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$refer' ORDER BY recid DESC LIMIT 1"))->balance;
            if($balance){
                $balance = $balance+$new_amount;
            }
            else{
                $balance = $new_amount;
            }

$transaction = mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$refer."','".$new_amount."','".date('Y-m-d H:i:s')."',5,'$balance')");

mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet+'$new_amount' WHERE uid='".$refer."'");

mysqli_query($connection,"INSERT INTO `referral_income` (`uid`, `from_uid`, `amount`, `commit_id`, `datetime`) VALUES ('" .$refer ."','".$row->uid."','".$new_amount."','".$commit_id."','".date('Y-m-d H:i:s')."')");
            
            if($transaction && $refer_type==1){
                $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$refer' ORDER BY recid DESC LIMIT 1"))->balance;
                if($balance){
                    $balance = $balance-$new_amount;
                }
                else{
                    $balance = -$new_amount;
                }

mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`) VALUES ('" .$refer."','".$new_amount."','".date('Y-m-d H:i:s')."',2)");

mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet-'$new_amount' WHERE uid='$refer'");

mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$refer."','".$new_amount."','".date('Y-m-d H:i:s')."',1,'$balance')");

mysqli_query($connection,"INSERT INTO `request_amount` (`uid`, `amount`, `balance`, `datetime`) VALUES ('".$refer."','".$new_amount."','".$new_amount."','".date('Y-m-d H:i:s')."')");
            }
        }
    }

/* end direct referral */

$isupdate = mysqli_query($connection,"UPDATE commit SET green=0 WHERE commit_id='$commit_id'");
    $msg = $isupdate ? "User Enable Successfully" : "Failed, Some error occured,Try again";
}
else{
    $msg = "E-wallet balance is less then amount.";
}
echo $msg;
?>

/home2/wtmwscom/public_html/js/../admin/process_enable.php