.-.-.-.-.-

<?php
session_start();
include('../connection.php');
include '../function_lib.php';
$uid = !empty($_REQUEST['give_uid']) ? $_REQUEST['give_uid'] : $_SESSION['userid'];

//$uid_is_commit_success = mysqli_fetch_object(mysqli_query($connection,"select is_commit_success from user where uid = '$uid' "))->is_commit_success;
//if(!isset($_POST['submit']) && !isset($_POST['total_amount'])){
//    redirect("./index.php");
//}
//elseif($_POST['total_amount']<5000 ){
//    setMessage('Help Request must be Minimum of 10000 INR.', 'alert-msg error');
//    redirect("./receive_help.php");
//}
//elseif($_POST['total_amount']%5000){
//    setMessage('Help Request Multiple of 10000 INR', 'alert-msg error');
//    redirect('./receive_help.php');
//}
//elseif($uid_is_commit_success == 0 && empty(tres($_POST['amount_4']))  ){
//    setMessage('You have not provided help completely yet. Please provide help first to get help', 'alert-msg error');
//    redirect("./receive_help.php");
//}
//else{
    $date = date('Y-m-d');
    
    $amount_1 = $_REQUEST['amount_1'];
    $amount_2 = $_REQUEST['amount_2'];
    $amount_3 = $_REQUEST['amount_3'];
    $amount_4 = $_REQUEST['amount_4'];
    $amount_5 = $_REQUEST['amount_5'];
    
//    $bank_id = $_POST['bank_id'];
    
    $total_amount = $amount_1+$amount_2+$amount_3+$amount_4+$amount_5;
//    echo $amount_3;
    $result = mysqli_query($connection,"SELECT amount FROM withdrawal_history WHERE uid='$uid' AND datetime LIKE '%$date%'");
    
    $request_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT SUM(balance) as amount FROM request_amount WHERE uid='".$uid."' AND lock_status=0 AND is_cancel='0'"))->amount;
    $result_help = mysqli_query($connection,"SELECT help_id FROM help WHERE receive_uid='$uid' AND confirm_status=0 AND lock_status=0");
    //$help = mysqli_num_rows($result_help)==0? FALSE : mysqli_fetch_object($result_help)->help_id;
    $bank_result = mysqli_query($connection,"SELECT recid FROM `bank_details` WHERE uid='$uid' ORDER BY recid DESC LIMIT 1");
    
    if(mysqli_num_rows($bank_result)==0){
        setMessage('Please add a bank account and Try again! <a href="./add_bank_account.php" >Add Account</a>', 'alert-msg error');
        redirect('./receive_help.php');
    }
    elseif(mysqli_num_rows($result)>0){
        setMessage('Your request not completed. You are already withdrawal in a day.', 'alert-msg error');
        redirect('./receive_help.php');
    }
    elseif($request_amount && $request_amount>0){
        setMessage('Multiple request problem. Some error occured!', 'alert-msg error');
        redirect('./receive_help.php');
    }
    elseif(mysqli_num_rows($result_help) >0){
        setMessage('Your last request is pending.', 'alert-msg error');
        redirect('./receive_help.php');
    }
    else{
        $amount2 = $total_amount;
        $bank_id = empty($_REQUEST['bank_id']) ? mysqli_fetch_object($bank_result)->recid : $_POST['bank_id'];
        
//        $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$uid' ORDER BY recid DESC LIMIT 1"))->balance;
//        if($balance){
//            $balance = $balance-$total_amount;
//        }       
        
        //mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$uid."','".$total_amount."','".date('Y-m-d H:i:s')."',1,'$balance')");
    
        mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet-'$amount_2', bonus_wallet= bonus_wallet-'$amount_3', fund_wallet= fund_wallet-'$amount_4', manager_wallet= manager_wallet-'$amount_5' WHERE uid='$uid'");
        
        $is_insert = mysqli_query($connection,"INSERT INTO `request_amount` (`uid`, `amount`, `balance`, `datetime`, `bank_id`) VALUES ('".$uid."','".$total_amount."','".$total_amount."','".date('Y-m-d H:i:s')."','".$bank_id."' )");
        $request_amount_id = $is_insert? mysqli_insert_id(): 0;
        
        if($amount_2!=0 || $amount_2!=''){
            $amount2 = $amount2-$amount_2;
            mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`,`request_amount_id`) VALUES ('" .$uid ."','".$amount_2."','".date('Y-m-d H:i:s')."',2, $request_amount_id)");
        }
        if($amount_3!=0 || $amount_3!=''){
            $amount2 = $amount2-$amount_3;
            mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`,`request_amount_id`) VALUES ('" .$uid ."','".$amount_3."','".date('Y-m-d H:i:s')."',3, $request_amount_id)");
        }
        if($amount_4!=0 || $amount_4!=''){
            $amount2 = $amount2-$amount_4;
            mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`,`request_amount_id`) VALUES ('" .$uid ."','".$amount_4."','".date('Y-m-d H:i:s')."',4, $request_amount_id)");
        }
        if($amount_5!=0 || $amount_5!=''){
            $amount2 = $amount2-$amount_5;
            mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`,`request_amount_id`) VALUES ('" .$uid ."','".$amount_5."','".date('Y-m-d H:i:s')."',5, $request_amount_id)");
        }
        
        if($amount_1!=0 || $amount_1!=''){                                                      
            $commit_result = mysqli_query($connection,"SELECT commit_id, balance_amount, remaining_amount FROM `commit` WHERE uid='".$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;
                        $remaining_amount=0;
                        //$remaining_amount_cancel = $commit_row->remaining_amount;
                        mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `commit_id`, `amount`, `datetime`, `type`,`request_amount_id`) VALUES ('" .$uid ."','".$commit_row->commit_id."','".$commit_row->balance_amount."','".date('Y-m-d H:i:s')."',1, $request_amount_id)");
                        mysqli_query($connection,"UPDATE commit SET balance_amount= balance_amount-'$commit_row->balance_amount', remaining_amount = '$remaining_amount', remaining_amount_cancel = '$commit_row->remaining_amount' WHERE commit_id='".$commit_row->commit_id."' AND assign_complite=0 AND uid='$uid'");
                    }
                    else{
                        $remaining_amount = $commit_row->balance_amount - $amount2;
                        mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `commit_id`, `amount`, `datetime`, `type`,`request_amount_id`) VALUES ('" .$uid ."','".$commit_row->commit_id."','".$amount2."','".date('Y-m-d H:i:s')."',1, $request_amount_id)");
                        mysqli_query($connection,"UPDATE commit SET balance_amount= balance_amount-'$amount2', remaining_amount = '$remaining_amount', remaining_amount_cancel = '$commit_row->remaining_amount' WHERE commit_id='".$commit_row->commit_id."' AND assign_complite=0 AND uid='$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;
                }
            }
        }
        setMessage('Your request submit successfully.', 'alert-msg success');
        redirect('./index.php');
    }
//}
?>

/home2/wtmwscom/public_html/member/receive_help_model.php