.-.-.-.-.-

<?php

session_start();
include('../connection.php');
include '../function_lib.php';
$uid = $_SESSION['userid'];

if (isset($_POST['submit'])) {
    $withdrawal_amount = 2500;
    $user = mysqli_fetch_object(mysqli_query($connection,"SELECT referal_wallet, fund_wallet FROM user WHERE uid='$uid'"));
    $fund_wallet = $user->fund_wallet;
    $referral_wallet = $user->referal_wallet;
    $total = $user->referal_wallet + $user->fund_wallet;
    if ($total >= $withdrawal_amount) {
        if ($fund_wallet >= $withdrawal_amount) {
            $new_fund_wallet = $fund_wallet - $withdrawal_amount;
            $new_referral_wallet = $referral_wallet;
            $actual_amount = $withdrawal_amount;
        } else {
            $new_fund_wallet = 0;

$required_amount = $withdrawal_amount - $fund_wallet;
            $actual_amount = $fund_wallet + $required_amount;

$new_referral_wallet = $referral_wallet - $required_amount;
        }

if ($actual_amount == $withdrawal_amount) {

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

mysqli_query($connection,"UPDATE user SET referal_wallet= '$new_referral_wallet', fund_wallet= '$new_fund_wallet' WHERE uid='$uid'");

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

mysqli_query($connection,"INSERT INTO `request_amount` (`uid`, `amount`, `balance`, `datetime`) VALUES ('" . $uid . "','" . $withdrawal_amount . "','" . $withdrawal_amount . "','" . date('Y-m-d H:i:s') . "')");
        }
    } else {
        setMessage('Insuffcient fund.', 'alert-msg error');
    }

setMessage('Fund transfer successfully.', 'alert-msg success');
} else {
    setMessage('Some error occured.', 'alert-msg error');
}
redirect('./account.php');

/*
  if(isset($_POST['amount']) && isset($_POST['total_amount']) && isset($_POST['uid'])){
  $to_login_id = $_POST['uid'];
  $amount = $_POST['amount'];
  $total_amount = $_POST['total_amount'];
  $result = mysqli_query($connection,"SELECT uid FROM user WHERE login_id='$to_login_id'");
  if(mysqli_num_rows($result)!=1){
  setMessage('Invalid user id.', 'alert-msg error');
  redirect('./account.php');
  die();
  }
  if($amount>$total_amount){
  setMessage('Your e-wallet balance is less then amount.', 'alert-msg error');
  redirect('./account.php');
  }
  else{
  $row = mysqli_fetch_object($result);
  mysqli_query($connection,"UPDATE user SET fund_wallet=fund_wallet+'$amount' WHERE uid='".$row->uid."'");
  mysqli_query($connection,"INSERT INTO `fund_transfer` (`uid`, `from_uid`, `amount`, `datetime`) VALUES ('" .$row->uid."','".$uid."','".$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+$amount;
  }
  else{
  $balance = $amount;
  }

$balance_2 = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$uid' ORDER BY recid DESC LIMIT 1"))->balance;
  if($balance_2){
  $balance_2 = $balance_2-$amount;
  }

mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$uid."','".$amount."','".date('Y-m-d H:i:s')."',2,'$balance_2')");
  mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$row->uid."','".$amount."','".date('Y-m-d H:i:s')."',4,'$balance')");

$user_row = mysqli_fetch_object(mysqli_query($connection,"SELECT referal_wallet, binary_wallet, fund_wallet FROM user WHERE uid='$uid'"));

$amount2 = $amount;

if($user_row->referal_wallet>0 && $amount2>0){
  if($user_row->referal_wallet<=$amount2){
  $amount2 = $amount2-$user_row->referal_wallet;
  mysqli_query($connection,"UPDATE user SET referal_wallet=0 WHERE uid='".$uid."'");
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$user_row->referal_wallet."','".date('Y-m-d H:i:s')."',2,1,'".$row->uid."')");
  }
  else{
  mysqli_query($connection,"UPDATE user SET referal_wallet=referal_wallet-'$amount2' WHERE uid='".$uid."'");
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$amount2."','".date('Y-m-d H:i:s')."',2,1,'".$row->uid."')");
  $amount2 = 0;
  }
  }
  if($user_row->binary_wallet>0 && $amount2>0){
  if($user_row->binary_wallet<=$amount2){
  $amount2 = $amount2-$user_row->binary_wallet;
  mysqli_query($connection,"UPDATE user SET binary_wallet=0 WHERE uid='".$uid."'");
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$user_row->binary_wallet."','".date('Y-m-d H:i:s')."',3,1,'".$row->uid."')");
  }
  else{
  mysqli_query($connection,"UPDATE user SET binary_wallet=binary_wallet-'$amount2' WHERE uid='".$uid."'");
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$amount2."','".date('Y-m-d H:i:s')."',3,1,'".$row->uid."')");
  $amount2 = 0;
  }
  }
  if($user_row->fund_wallet>0 && $amount2>0){
  if($user_row->fund_wallet<=$amount2){
  $amount2 = $amount2-$user_row->fund_wallet;
  mysqli_query($connection,"UPDATE user SET fund_wallet=0 WHERE uid='".$uid."'");
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$user_row->fund_wallet."','".date('Y-m-d H:i:s')."',4,1,'".$row->uid."')");
  }
  else{
  mysqli_query($connection,"UPDATE user SET fund_wallet=fund_wallet-'$amount2' WHERE uid='".$uid."'");
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$amount2."','".date('Y-m-d H:i:s')."',4,1,'".$row->uid."')");
  $amount2 = 0;
  }
  }

$commit_result = mysqli_query($connection,"SELECT commit_id, balance_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;
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `commit_id`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$commit_row->commit_id."','".$commit_row->balance_amount."','".date('Y-m-d H:i:s')."',1,1,'".$row->uid."')");
  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='$uid'");
  }
  else{
  mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `commit_id`, `amount`, `datetime`, `type`, `w_type`, `to_uid`) VALUES ('" .$uid ."','".$commit_row->commit_id."','".$amount2."','".date('Y-m-d H:i:s')."',1,1,'".$row->uid."')");
  mysqli_query($connection,"UPDATE commit SET balance_amount= balance_amount-'$amount2' 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('Fund transfer successfully.', 'alert-msg success');
  redirect('./account.php');
  }
  }
  else{
  redirect('./account.php');
  }
 */
?>

/home2/wtmwscom/public_html/member/scripts/../styles/../lib/../transfer_fund_model.php