<?php
	session_start();
	if($_SESSION['rid'])
	{
		$userid=$_SESSION['rid'];
	}
	else
	{
		header('location:../login.php');
	}
?>
<?php
	include'connection.php';
		
		$query8="select * from wallet where Userid=$userid order by Id desc";
		$result8=mysqli_query($con,$query8);
		$data8=mysqli_fetch_array($result8);
		$currentbal= $data8['Balance'];
		
?>
<html>
<title>Change Profile</title>
<head>
<style>
body{background:url('bg.jpg'); background-size:cover;
width:100%; height:700px; margin:0px;}

.head{background:; width:1350px; height:100px; margin:0px;}
#p1{font-size:34px; float:left; Margin:10 0 0 45px; color:#996420; font-weight:bold;}
#p2{font-size:20px; float:left; margin:28 0 0 -8px; color:#eaa040; font-family:Courier;}
#p3{font-size:15px; font-family:Comic Sans MS; float:left; color:#996420; margin-top:48px; margin-left:-153px;}
.h2{background:white; width:400px; height:70px; margin:10 200px;}
#link1{float:right; margin:10 30 0 0px; font-size:20px; text-decoration:none;
 color:white; background:red; padding:5px; border-radius:4px;}
 #link2{float:right; margin:10 30 0 0px; font-size:20px; background:white;color:Green; padding:5px; border-radius:4px;}
#link1:hover{ padding:5px; border-radius:4px; color:black;}
	
.menu{background:#996420; height:40px; width:1300px; margin:0 0 0 20px; padding:0;}
.menu ul{padding:0; margin:0; position:relative; display:inline-block;}
.menu ul li{list-style:none; float:left; width:170px; line-height:40px;
	text-align:center; font-size:15px; margin:0; padding:0; color:white;}
.menu ul li ul {display:none;}
.menu ul li:hover{background:#d1994a; cursor:pointer;}
.menu ul li:hover ul {display:block; z-index:2;}
.menu ul li:hover ul li{background:#d1994a; border-top:solid white 0.1px;}
.menu ul li ul li:hover{background:#996420; color:white;}
.menu ul li ul li:hover a{ color:white;}
.menu ul li a{ text-decoration:none; color:white;}
 #a1{border:none; color:white;}
 .menu{letter-spacing:1px;}
 #bal:hover{background:#996420; cursor:text;}
 
 
 .heading{width:1250px; height:40px; margin:10 0 0 30px; line-height:40px;}
 .heading h3{margin:0 0 0 10px; font-size:22px; font-family:calibri;}
 .content{background:; margin:10 0 0 50px;}
 .content table{border-collapse:collapse; }
 #td1{background:#f6f0e8; padding:8px; text-align:right; font-size:18px;}
 #td2{background:#e9e7e5; padding:10px; font-size:18px;}
 #inp{border:1px solid black; width:250px; height:25px; padding:2px 5px; font-size:17px;}
 #selectdiv{border:1px solid black; width:250px; height:25px; font-size:17px;}
 #btn{margin:20 0 0 310px; width:100px; height:30px; background:#996420; border:1px solid white; border-radius:3px;
 color:white;}
 #btn:hover{background:#dab98c; cursor:pointer; border:1px solid black; color:black;}
.foot{background:#996420; width:100%; height:50px; float:left;text-align:center;
	margin-top:50px;}
</style>
</head>
<body>
	<div class="head">
		<p id="p1">LLP</p>
		<p id="p2">Recharge</p>
		<p id="p3">The Complete Solution</p>
		<a id="link1" href="logout.php">Log Out</a>
		<p id="link2"><?php echo"Balance : ". $currentbal;  ?></p>
	</div>
	<div class="menu">
		<ul>
			<li><a href="recharge_home.php" id="a1">Home</a></li>
			<li>Reports
				<ul>
					<li><a href="recharge_history.php">Recharge History</a></li>
					<li><a href="account_reports.php">Account Reports</a></li>
					<li><a href="check_status.php">Check Status</a></li>
				</ul>
			</li>
			<li>Documents
				<ul>
					<li><a href="my_commission.php">My Commission</a></li>
					<li><a href="commision.php">Get Commission</a></li>
					<li><a href="complain.php">Complain</a></li>
				</ul>
			</li>
			<li>Profile
				<ul>
					<li><a href="change_profile.php">Change Profile</a></li>
					<li><a href="change_pwd.php">Change Password</a></li>
				</ul>
			</li>
			<li>Payment Request
				<ul>
					<li><a href="payment_request.php">Update Payment</a></li>
					<li><a href="bank_list.php">Bank List</a></li>
				</ul>
			</li>
			<li id="bal">Balance : <?php echo $currentbal; ?></li>
		</ul>
	</div>
	<div class="heading">
		<h3>Change Profile</h3>
	</div><hr>
	<div class="content">
		<?php
			include'connection.php';
			if(isset($_POST['submit']))
			{
				$address=$_POST['addr'];
				$email=$_POST['email'];
				$bizname=$_POST['bizname'];
				$pan=$_POST['pan'];
				$state=$_POST['state'];
				$city=$_POST['city'];
				$pin=$_POST['pin'];
				$biztype=$_POST['biztype'];
				
				$queryupdate="update retailer set
				Address='$address',
				Email='$email',
				Businessname='$bizname',
				Pan='$pan',
				State='$state',
				City='$city',
				Pincode='$pin',
				Businesstype='$biztype' where Userid='$userid'
				";
				if(mysqli_query($con,$queryupdate))
				{
					echo "<h1 align='center'><font color='#008000'> &#x2714; Your Profile has been Update Successfully !</font></h1>";
				}
				else
				{
					echo "<h1 align='center'><font color='#ff0000'> &#x2716; Somthing Error !</font></h1>";
				}
			}
			$query="select * from retailer where Userid='$userid'";
			$result=mysqli_query($con,$query);
			$row=mysqli_fetch_array($result);
		?>
		<table border="1" cellpadding="5">
		<form method="post">
			<tr>
				<td id="td1">Name : </td>
				<td id="td2"><?php echo $row['Name']; ?></td>
			</tr>
			<tr>
				<td id="td1">Mobile No. : </td>
				<td id="td2"><?php echo $row['Mobile']; ?></td>
			</tr>
			<tr>
				<td id="td1">Email : </td>
				<td id="td2"><?php echo"<input type='text' value='".$row['Email']."' name='email' id='inp'>"; ?></td>
			</tr>
			<tr>
				<td id="td1">Business Name : </td>
				<td id="td2"><?php echo"<input type='text' value='".$row['Businessname']."' name='bizname' id='inp'>"; ?></td>
			</tr>
			<tr>
				<td id="td1">Business Type : </td>
				<td id="td2"><?php
				$query1="select * from retailertype";
				$result1=mysqli_query($con,$query1);
				echo "<select name='biztype' id='selectdiv'>";
				while($data1=mysqli_fetch_array($result1))
				{
					echo "<option >".$data1['Businessname']."</option>";
				}
				echo "</select>";
				?></td>
			</tr>
			<tr>
				<td id="td1">State : </td>
				<td id="td2"><?php echo "<input type='text' value='".$row['State']."' name='state' id='inp'>" ?></td>
			</tr>
			<tr>	
				<td id="td1">City : </td>
				<td id="td2"><?php echo "<input type='text' value='".$row['City']."' name='city' id='inp'>"  ?></td>
			</tr>
			<tr>
				<td id="td1">Pin Code : </td>
				<td id="td2"><?php echo"<input type='text' value='".$row['Pincode']."' name='pin' id='inp'>"; ?></td>
            </tr>
			<tr>
				<td id="td1">Address : </td>
				<td id="td2"><?php echo"<input type='text' value='".$row['Address']."' name='addr' id='inp'>"; ?></td>
			</tr>
			<tr>
				<td id="td1">Pan No. : </td>
				<td id="td2"><?php echo"<input type='text' value='".$row['Pan']."' name='pan' id='inp'>"; ?></td>
			</tr>
			
			
		</table>
		<input type="submit" name="submit" value="Update Profile" id="btn">
		</form>
	</div>

	<div class="foot">
		<p style="text-align:center;">Copyright &copy; 2018 -2019 Long Life Product Pvt. Ltd.</p>
	</div>
</body>
</html>