<?php
	session_start();
	if($_SESSION['mid'])
	{
		$userid= $_SESSION['mid'];
	}
	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>
<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:21px; float:left; margin:25 0 0 -10px; color:#eaa040;
	font-family:Courier;}
#p3{font-size:15px; font-family:Comic Sans MS; float:left; color:#996420;
	margin-top:41px; margin-left:-157px;}
#p4{font-family:100px;}
.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;}
  
 .content{ width:1350px; height:; margin:0; padding:0;}
 .content h3{padding-left:20px; }
 .content table{margin:0 0 0 200px; font-size:18px;}
 #m1{float:right; margin-right:10px; font-family:calibri;}
 #btn{width:83px; padding:3px;}
 .content input{margin:0 30 0 0px; width:200px;}
 .content select{margin:0 30 0 0px; width:200px;}
 .content textarea{margin:0 30 0 0px; width:200px;}
 
 .listhead{width:1250px; height:40px; background:#996420; margin:10 20 0 20px;}
 .listhead h3{margin-left:10px; line-height:40px; color:white;}
 .listview{width:1250px; margin:0 20 0 20px;}
 
#t1{width:1250px; text-align:center; border-collapse:collapse; border-color:black;}
#t1 th{ font-family:calibri; background:#94928f; color:white;}
#t1 td{ font-family:calibri;}
#t1 tr:nth-child(odd){background:#f6f0e8;}
#t1 tr:nth-child(even){background:white; }

.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>Retailer
				<ul>
					<li><a href="add_new_agent.php">Add New Retailer</a></li>
					<li><a href="view_retailer.php">View Total Retailers</a></li>
					<li><a href="low_bal_retailer.php">Low Bal. Retailers</a></li>
					<li><a href="lazy_retailer.php">Lazy Retailers</a></li>
				</ul>
			</li>
			<li>Commission
				<ul>
					<li><a href="earn_commision.php">Earn Commision</a></li>
					<li><a href="withdraw_commision.php">Withdraw Comm.</a></li>
				</ul>
			</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="sms_format.php">SMS Format</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>
		</ul>
	</div>
	<div class="content">
	<?php
		include'connection.php';
		if(isset($_POST['submit']))
		{
			$amount=$_POST['amount'];
			$pdate=$_POST['pdate'];
			$mode=$_POST['mode'];
			$bankname=$_POST['bankname'];
			$dtime=$_POST['dtime'];
			$ubank=$_POST['ubank'];
			$txnno=$_POST['txnno'];
			$txndate=$_POST['idate'];
			$remark=$_POST['remark'];
			
			if($amount>=1000)
			{
				$qinsert="insert into paymentreq(Userid,Paymentdate,Amount,Mode,Time,Yourbank,Txnnumber,Txndate,Bankname,Remarks)
				values('$userid','$pdate','$amount','$mode','$dtime','$ubank','$txnno','$txndate','$bankname','$remark')";
				if(mysqli_query($con,$qinsert))
				{
					echo "inserted";
				}
				else
				{
					echo "error";
				}
				mysqli_close($con);
				header('location:payment_request.php');
			}
			else
			{
				echo "The Amount Is Less Than 1000";
			}
		}
		
	?>
		<h3>Payment Request</h3><hr>
		<form method="post">
			<table border="0" cellpadding="7">
				<tr>
					<td id="m1">Request For Amount :</td>
					<td><input type="text" name="amount" required>
					Minimum Limit 1000</td>
				</tr>
				<tr>
					<td id="m1">Payment Date :</td>
					<td><input type="date" name="pdate" required></td>
				</tr>
				<tr>
					<td id="m1">Payment Mode :</td>
					<td><select name="mode" required>
					<option>--Select--</option>
					<option>Cash In bank</option>
					<option>Cheque/DD</option>
					<option>NEFT</option>
					<option>RTGS</option>
					<option>IMPS</option>
					</select></td>
				</tr>
				<tr>
					<td id="m1">Deposit Bank Name :</td>
					<td><select name="bankname">
					<option>--Select Bank--</option>
					<?php
					include'connection.php';
						$query="select * from bank";
						$result=mysqli_query($con,$query);
						while($row=mysqli_fetch_array($result))
						{
							echo "<option>".$row['Bankname']."</option>";
						}
					?>
					</select></td>
				</tr>
				<tr>
					<td id="m1">Deposit Time :</td>
					<td><select name="dtime">
					<option>--Select--</option>
					<option>10:00 Am</option>
					<option>11:00 Am</option>
					<option>12:00 pm</option>
					<option>1:00 pm</option>
					<option>2:00 pm</option>
					<option>3:00 pm</option>
					<option>4:00 pm</option>
					<option>5:00 pm</option>
					<option>6:00 pm To 9:00 Am</option>
					</select></td>
				</tr>
				<tr>
					<td id="m1">Your Bank Name :</td>
					<td><input type="text" name="ubank"></td>
				</tr>
				<tr>
					<td id="m1">Cheque/DD/IMPS No. :</td>
					<td><input type="text" name="txnno"></td>
				</tr>
				<tr>
					<td id="m1">Cheque/DD/IMPS Date :</td>
					<td><input type="date" name="idate"></td>
				</tr>
				<tr>
					<td id="m1">Remarks :</td>
					<td><textarea rows="5" cols="30" name="remark"></textarea></td>
				</tr>
				<tr>
					<td></td>
					<td>
					<input type="submit" name="submit" value="Submit" id="btn">
					<input type="submit" name="cancel" value="Cancel" id="btn">
					
					</td>
				</tr>
			</table>
		</form>
	</div>
	<div class="listhead">
	<h3>View Payment Request</h3>
	</div>
	<div class="listview">
		<table id="t1" border="1" cellpadding="5">
			<tr >
				<th>Payment Date</th>
				<th>Amount</th>
				<th>Mode</th>
				<th>Deposit Time</th>
				<th>Bank Name</th>
				<th>Bank Charge</th>
				<th>Remarks</th>
				<th>Response Messege</th>
				<th>Status</th>
			</tr>
		<?php
		include 'connection.php';
		$viewq="select * from paymentreq where Userid=$userid order by Id desc limit 10";
		$viewr=mysqli_query($con,$viewq);
		while($row=mysqli_fetch_array($viewr))
		{
			echo "<tr>";
				echo "<td>".$row['Paymentdate']."</td>";
				echo "<td>".$row['Amount']."</td>";
				echo "<td>".$row['Mode']."</td>";
				echo "<td>".$row['Time']."</td>";
				echo "<td>".$row['Bankname']."</td>";
				echo "<td>".$row['Bankcharge']."</td>";
				echo "<td>".$row['Remarks']."</td>";
				echo "<td>".$row['Responsemsg']."</td>";
				echo "<td>".$row['Status']."</td>";
			echo "<tr>";
		}
		?>
		
		</table>
	</div>
	<div class="foot">
		<p>Design By Sameer</p>
	</div>
</body>
</html>