.-.-.-.-.-

<?php
session_start();
include('../connection.php');
include('../function_lib.php');

$uid = $_SESSION['userid'];

if (isset($_POST['submit'])) {
$datetime = date('Y-m-d H:i:s');
    $amount = mysqli_real_escape_string($connection,$_POST['commit_amount']);
//    echo $amount;
//    $count_refer_id = mysqli_fetch_object(mysqli_query($connection, "SELECT "))
    $is_insert = mysqli_query($connection,"INSERT INTO `commit` (`uid`, `amount`, `amount_2`, `balance_amount`, `datetime`, `first_commit`) VALUES "
            . "('" . $uid . "','" . $amount . "','" . $amount . "','" . $amount . "','" . $datetime . "',1)");
//    echo "INSERT INTO `commit` (`uid`, `amount`, `amount_2`, `balance_amount`, `datetime`, `first_commit`) VALUES "
//            . "('" . $uid . "','" . $amount . "','" . $amount . "','" . $amount . "','" . $datetime . "',1)";
    if ($is_insert) {
        $commit_id = mysqli_insert_id();
        // referral bonus
//        $referral_amount = 4000;
        $referral_amount = $amount*0.05; //referral 5%
                        $refer_id = mysqli_fetch_object(mysqli_query($connection,"SELECT refer_id FROM user WHERE uid='".$uid."'"))->refer_id;
                        if($refer_id !=0){
                            //$is_manager = mysqli_fetch_object(mysqli_query($connection,"SELECT is_manager FROM user WHERE uid='".$refer."'"))->is_manager;
                            //$member_count = mysqli_fetch_object(mysqli_query($connection,"SELECT count(refer_id) AS member_count FROM user WHERE refer_id = '$refer' "))->member_count;
                            //if($is_manager==1 || $member_count >=30 ){ //he is a manager
                                //mysqli_query($connection,"UPDATE user SET manager_wallet= manager_wallet+'$manager_amount' WHERE uid='".$manager_id."'");

mysqli_query($connection,"INSERT INTO `referral_income` (`uid`,`from_uid`, `amount`, `commit_id`, `datetime`) "
                                . " VALUES ('$refer_id', '$uid', '$referral_amount', '$commit_id', '".$datetime."') ");
             
                            //}
                        }
        // manager bonus
//        $level = get_commission_uid5($uid);
//        set_manager_level_income_on_commit($level, $amount, $commit_id, $datetime);
        
                        
        setMessage('Provide help done successfully.', 'alert-success');
    } else {
        setMessage('Some error Occured. Try again.', 'alert-error');
    }
} else {
    setMessage('Some error Occured. Try again.', 'alert-error');
}
redirect('./index.php');

function set_manager_level_income_on_commit($level, $amount, $commit_id, $datetime) {
    //$datetime = date('Y-m-d H:i:s');
    //mysqli_query($connection,"insert into invest_amount (amount, uid, date, payment_mode) values ('$amount', '$uid', '$date', '$pmode')");
    //$i = 1;
    //$iaid = mysql_insert_id();
    //foreach ($level as $key =>$level_arr) {
    foreach ($level as $key => $uid) {

//echo   "insert into referral_income ( uid, from_uid, amount, commit_id, datetime) values "
        //. "( '$uid', '$from_uid', '$commision_amount', '$commit_id', '$datetime' )";
        if ($uid != 0) { // if user id exist
            
            switch ($key) {
                case 0: $percentage = 0.05;
                    break;
                case 1: $percentage = 0.03;
                    break;
                case 2: $percentage = 0.01;
                    break;
                case 3: $percentage = 0.005;
                    break;
                case 4: $percentage = 0.001;
                    break;

default: $percentage = 0;
                    break;
            }
            //$commision_amount = $key == 0 ? ($amount * 0.05) : ($amount * 0.02); // 5% for 1st level and next 4 level 2%
            $commision_amount = $percentage * $amount;
            mysqli_query($connection,"insert into manager_income ( uid, amount, commit_id, datetime) values "
                    . "( '$uid', '$commision_amount', '$commit_id', '$datetime' )");
            //mysqli_query($connection,"UPDATE user SET referal_wallet = referal_wallet + '$commision_amount' WHERE uid='" . $uid . "'");
        }
    }

//}
}

/home2/wtmwscom/public_html/doc/../admin/../member/provide_help_model.php