<?php 
session_start();
$alert_msg = '';
$updatealert = '';
if($_SESSION['goodlogin'] != true){
  header('location:../index.php');}else{
  require('connect.php');
  if(!($_REQUEST['client_email'])){
		header('location:view_account.php');
  }
  if(isset($_POST['update_balance'])){
	//$wallet_id = trim($_POST['new_wallet_id']);
	 $new_balance = $_REQUEST['new_balance'];
	 $client_id = $_REQUEST['customer_email'];
$sendtoData = "UPDATE new_customer SET customer_wallet_balance = '$new_balance' WHERE customer_email = '$client_id'";
$querytoData = mysqli_query($cxn, $sendtoData);
if($querytoData){
	$updatealert = '<div class="alert alert-success">BALANCE UPDATED SUCCESSFULLY</div>';
}else{
	$updatealert = '<div class="alert alert-danger">BALANCE NOT UPDATED</div>';
}
}
$client_id = $_REQUEST['client_email'];
						$getDataone = "SELECT * FROM new_customer WHERE customer_email = '$client_id'";
						$retrieveData = mysqli_query($cxn, $getDataone);
						if($retrieveData){
							$countall = mysqli_num_rows($retrieveData);
							$sendDataone = mysqli_fetch_array($retrieveData);
							$investing_id = $sendDataone['investment_unique'];

							 $getData = "SELECT * FROM investment WHERE investment_unique = '$investing_id'";
						$retrieveData = mysqli_query($cxn, $getData);
						if($retrieveData){
							$sendData = mysqli_fetch_array($retrieveData);
						}
						}

					}			

  ?>
<!DOCTYPE html>
<html lang="en">

<head>
<title>DASHBOARD - CONTROL PANEL</title>
	<link rel="shortcut icon" href="images/bicon.png">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<script>
		addEventListener("load", function () {
			setTimeout(hideURLbar, 0);
		}, false);

		function hideURLbar() {
			window.scrollTo(0, 1);
		}
	</script>
	<!-- css files -->
	<link href="css/bootstrap.css" rel='stylesheet' type='text/css' /><!-- bootstrap css -->
	<link href="css/istyle.css" rel='stylesheet' type='text/css' /><!-- custom css -->
	<link href="css/style.css" rel='stylesheet' type='text/css' /><!-- custom css -->
	<link href="css/font-awesome.min.css" rel="stylesheet"><!-- fontawesome css -->
	<!-- //css files -->

	<!-- google fonts -->
	<link
		href="//fonts.googleapis.com/css?family=Poppins:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i&amp;subset=devanagari,latin-ext"
		rel="stylesheet">

	<!-- //google fonts -->

<script src="js/jquery-3.3.1.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/popper.min.js"></script>
</head>

<body>
	<!-- //header -->
	<header>
		<div class="container">
			<!-- nav -->
			<nav class="pt-3">
				<div id="logo">
					<h1> <a href="index.php" class="text-white">CONTROL PANEL</a></h1>
				</div>
				<label for="drop" class="toggle">Menu</label>
				<input type="checkbox" id="drop" />
				<ul class="menu mt-md-2 ml-auto">
					<li class="mr-lg-4 mr-2"><a href="index.php" class="text-white">Dashboard</a></li>
					<li class="mr-lg-4 mr-2"><a href="view_account.php" class="text-white"><div class="badge badge-dark p-2">View accounts</div></a></li>
					<li class="mr-lg-4 mr-2"><a href="view_messages.php" class="text-white">View Messages</a></li>
					<li class="mr-lg-4 mr-2"><a href="logout.php" class="text-white">Logout</a></li>
				</ul>
			</nav>
			<!-- //nav -->
		</div>
	</header>
	<!-- //header -->
	<!-- inner banner -->
	<div class="inner-banner2" id="home">
		<div class="container">
		</div>
	</div>
	<!-- inner banner -->

	<!-- TRACKING ORDER -->
	<section class="py-5" id="">
		<div class="container py-md-3">
			<h4 class="heading text-center text-white"> <span class="fa fa-book"></span> INVESTMENT RECORD</h4>
			<div class="row">
			<center><?php echo $alert_msg;?></center>
				<div class="col-lg-12 acct-wrapper">
						
					<table class="table">
						<thead>
							<td>Investment ID</td>
							<td>Investment Plan</td>
							<td>Current Balance</td>
							<td>Actions</td>
						</thead>
						<?php
						echo $updatealert;
						?>

							<td><form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>" method="POST">
					<div class="form-group">
						<input type="text" class="form-control" placeholder="Enter New Balance" name="new_balance">
						<input type="hidden" class="" placeholder="Enter New Balance" value="<?php echo $sendDataone['customer_email']; ?>" name="client_email">
					</div>
					<button type="submit" name="update_balance" class="btn btn-success">Update Balance</button>
					</form></td>
						</tr>
						<?php // }}	 ?>
					</table>

							
				</div>
			</div>
		</div>
		</div>
	</section>

</body>

</html>