<?php
	include'session.php';
	include'../connection.php';
	include'../functions.php';
?>
<html>
<head>
	<title>Redeem Commission</title>
	<!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    
	<link rel="icon" href="images/logo.png" type="image/gif" sizes="16x16">
	
	<!-- Admin CSS File Link -->
	<link rel="stylesheet" href="css/style.css">
	
	<!-- User JAVA SCRIPT File Link -->
	<script type="text/javascript" src="js/script.js"></script>

	
	<!-- Font Awesome Icone -->
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
	
	<style>
		.div1{
			background:;
			width:96%;
			margin:2%;
			padding:10px;
		}
		.div1 input, .div1 select{
			height:40px;
			width:180px;
			font-size:16px;
			padding:5px 10px;
			border-radius:5px;
			border:solid #6b5127 1px;
			overflow:hidden;
			margin:10px 10px 0 5px;
		}
		input[type=submit]{
			background:#6b5127;
			color:white;
			transition:1s;
			cursor:pointer;
		}
		input[type=submit]:hover{
			background:white;
			color:#6b5127;
			transition:1s;
		}
		.div2{
			background:#f7f7f7;
			width:100%;
			float:left;
			text-align:center;
			padding:0 10px 10px 10px;
			overflow-x:auto;
		}
		.div2 table{
			width:96%;
			text-align:center;
			font-size:15px;
			border-collapse:collapse;
			padding:2px 10px;
			margin:2%;
		}
		table th{
			background:#6b5127;
			color:white;
			height:40px;
			border:solid white 1px;
			padding:2px 5px;
		}
		table td{
			background:white;
			height:40px;
			border:solid black 1px;
			padding:2px 5px;
		}
		#redeemLink{background:#6b5127; color:white; padding:3px 7px;  transition:all 1s; border-radius:4px; font-size:17px;}
		#redeemLink:hover{background:white; color:#6b5127;}
		@media(max-width:768px)
		{
			.div1{
				background:;
				width:100%;
				height:auto;
				margin:10px 0 0 0;
				padding:0;
				text-align:center;
			}.div1 input{
				width:90%;
				margin:10px;
			}
			.div2{
				width:100%;
				margin:10px 0 0 0;
				padding:0px;
				text-align:center;
			}
		}
		

	</style>
	
	<link rel="stylesheet" href="css/mediaStyle.css">
</head>
<body>
	<!--Header Divison-->
	<?php
		require'header.php';
	?>
	
	<!--Container Division-->
	<div class="container">
		<?php
			include'menu.php';
		?>
		<div class="content">
			<div class="head">
				<div class="title"><p>Redeem Commission :-</p></div>
				<div class="msg"><marquee><?php include'../msg.php'; ?></marquee></msg>
			</div><hr>
			<div class="data-content">
				<form method="post">
					<div class="div1">
					    <center><h3 align='center' style='color:blue;'>Commission Will Be Redeemed Rs.100 or Above only !</h2></center><br>
					    <?php
					        $respMsg=$_GET['respMsg'];
					        
					        if($respMsg=="SUCCESS")
		                    {
		                        echo "<div class='msg-div'>
						                <form method='post'>
						                <h3>Commission Redeemed successfully !</h3><br>
						                <i class='fa fa-check-circle' aria-hidden='true' id='okIcon'></i><br><br>
						                <a type='submit' class='btnPopup' href='redeem_commission.php'>OK</a><br><br>
						                </form>
					                </div>";
		                    }
		                    elseif($respMsg=="FAILED")
		                    {
		                        echo "<div class='msg-div'>
			                            <form method='post'>
				                        <h3>Something Error !</h3><br>
				                        <i class='fa fa-ban' aria-hidden='true' id='NotokIcon'></i><br><br>
						                <a type='submit' class='btnPopup' href='redeem_commission.php'>OK</a><br><br>
			                        </form>
		                        </div>";
		                    }
					    
					        if(isset($_POST['submit']))
					        {
					            $date1Value=$_POST['fdate'];
					            $date2Value=$_POST['ldate'];		
					        }
					        else
					        {
					            $date1Value=$date;
					            $date2Value=$date;
					        }
					    
					    ?>
						<input type="date" name="fdate" value="<?php echo $date1Value; ?>">
						<input type="date" name="ldate" value="<?php echo $date2Value; ?>">
						<input type="submit" name="submit" value="Submit"  onclick='showLoader()'>
					</div>
				</form>
				<div class="div2">
				    <?php
	                	if(isset($_POST['submit']))
			            {
				            $fdate=$_POST['fdate'];
				            $ldate=$_POST['ldate'];
				            $query="SELECT SUM(TXN) FROM comm_wallet WHERE Userid='$userid' AND Redeem='NO' AND Date>='$fdate' AND Date<='$ldate'";
				            $result=mysqli_query($con,$query);
			            	while($row=mysqli_fetch_array($result))
				            {
					            $commision=$row[0];
				            }
				
				            echo "<table border='2' cellpadding='20'>";
				                echo "<tr>";
					                echo "<th>From Date</th>";
					                echo "<th>To Date</th>";
					                echo "<th>Total Commision</th>";
					                echo "<th>Action</th>";
				                echo "</tr>";
					                echo "<td>".$fdate."</td>";
					                echo "<td>".$ldate."</td>";
					                echo "<td>".$commision."</td>";
					                echo "<td>";
					                    if($commision<100)
					                    {
					                        echo "Commission Value Is Low";
					                    }
					                    else
					                    {
					                        echo "<a href='redeem.php' id='redeemLink'>Redeem Now</a>";
		                    	        }
		                            echo "</td>";
				                echo "</tr>";
				            echo "</table>";
				            $_SESSION['fd'] = $fdate;
				            $_SESSION['ld'] = $ldate;
				            $_SESSION['sm'] = $commision;
			            }
		            ?>
				</div>
			</div>
		</div>
	</div>
	<?php
		require'footer.php';
	?>
</body>
</html>