<?php
	session_start();
	if($_SESSION['did'])
	{
		$userid= $_SESSION['did'];
	}
	else
	{
		header('location:../login.php');
	}
?>
<?php
	include'connection.php';
	    date_default_timezone_set("asia/kolkata");
		$date=date("Y-m-d");
		
		$query8="select * from wallet where Userid=$userid order by Id desc";
		$result8=mysqli_query($con,$query8);
		$data8=mysqli_fetch_array($result8);
		$currentbal= $data8['Balance'];
		
		$query2="select * from distributer where Userid=$userid";
		$result2=mysqli_query($con,$query2);
		$data=mysqli_fetch_array($result2);
		$username=$data['Name'];
		$parentid=$data['Parentid'];
		$validDate=$data['Validity'];
		$date1=date_create("$date");
        $date2=date_create("$validDate");
        $diff=date_diff($date1,$date2);
        $remain= $diff->format("%R%a days");
        if($remain<=0)
        {
           $remainDays="+0days";
           $quDeactive="update distributer set Active='0' where Userid='$userid'";
           if(mysqli_query($con,$quDeactive))
           {
               session_destroy();
           }
        }
        else
        {
            $remainDays=$remain;
        }
        if($remain<=1)
        {
            $Days="Day Left";
        }
        else
        {
            $Days="Days Left";
        }
		
?>
<html>
<title>LLP Recharge</title>
<head>
<style>
body{background:url('bg.jpg'); background-size:cover;
width:100%; height:700px; margin:0px;}

.head{background:; width:1350px; height:120px; 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;}
 

.dmorq{background:#565450; color:white; width:1200px; margin:10 0 0 50px; line-height:40px; z-index:0; border-radius:18px; font-size:25px; font-family:sans-serif;}

.content{ width:1100px; height:450px; margin-left:120px;}
.content1{background:white; width:250px; height:220px; margin:10px; float:left;}
.content1 table{width:250px; border-collapse:collapse; text-align:center;}
.content1 table th{height:70px; background:green; color:white; font-size:20px;}
.content1 table td{height:150px; font-size:50px; background:#eafaec;}

.foot{margin: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>
		<p id="link2"><?php echo "Name:- ".$username."<br>User Id:- [ ".$userid." ]<br>Rank:- Distributer<br>Validity:- ".substr($remainDays,1,-4)." ".$Days;  ?></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>
					<li><a href="reward.php">Reward Status</a></li>
					<li><a href="getReferalIncome.php">Referral Income</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="dmorq">
		<?php
			$querymsg="select * from messege";
			$resultmsg=mysqli_query($con,$querymsg);
			$datamsg=mysqli_fetch_array($resultmsg);
		?>
		<marquee scrollamount="3" onmouseover="stop()" onmouseout="start()">
		<?php
			echo $datamsg['Messege'];
		?>
		</marquee>
	</div>
	<?php
		include'connection.php';
		
		$query1="select * from retailer where Parentid='$userid'";
		$result1=mysqli_query($con,$query1);
		$row1=mysqli_num_rows($result1);
		
		$sum2=0;
		$query2="select * from recharge where Status='SUCCESS' and Parentid='$userid' and Rechargedate='$date'";
		$result2=mysqli_query($con,$query2);
		while($row2=mysqli_fetch_array($result2))
		{
			$rechbal=$row2['Amount'];
			$sum2=$sum2+$rechbal;
		}
		
		$query3="select * from commwallet where Userid='$userid'";
		$result3=mysqli_query($con,$query3);
		$sum3=0;
		while($row3=mysqli_fetch_array($result3))
		{
			$data3=$row3['Balance'];
			$sum3=$sum3+$data3;
		}
		
		$query4="select * from commwallet where Userid='$userid' and Active='0'";
		$result4=mysqli_query($con,$query4);
		$sum4=0;
		while($row4=mysqli_fetch_array($result4))
		{
			$data4=$row4['Balance'];
			$sum4=$sum4+$data4;
		}
		
		$query5="select * from commwallet where Userid='$userid' and Active='1'";
		$result5=mysqli_query($con,$query5);
		$sum5=0;
		while($row5=mysqli_fetch_array($result5))
		{
			$data5=$row5['Balance'];
			$sum5=$sum5+$data5;
		}
		
		$query6="select * from retailer where Parentid='$userid' and Balance<1000";
		$result6=mysqli_query($con,$query6);
		$row6=mysqli_num_rows($result6);
		
		$query7="select * from commwallet where Userid='$userid' and Date='$date'";
		$result7=mysqli_query($con,$query7);
		$sum7=0;
		while($row7=mysqli_fetch_array($result7))
		{
			$data7=$row7['Balance'];
			$sum7=$sum7+$data7;
		}
		
		date_default_timezone_set("asia/kolkata");
		$date1=date("Y-m-d");
		$date=date_create($date1);
		date_sub($date,date_interval_create_from_date_string("5 days"));
		$resultdate=date_format($date,"Y-m-d");
		$querydeac="select * from retailer where Parentid='$userid' and Lastrechdate<'$resultdate'";
		$resultdeac=mysqli_query($con,$querydeac);
		$rowdeac=mysqli_num_rows($resultdeac);
	?>
<div class="content">
	<a href="view_retailer.php">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Total Retailers</th></tr>
			<tr><td><?php echo $row1; ?></td></tr>
		</table>
	</div>
	</a>
	<a href="lazy_retailer.php"><div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Total Lazy Retailers</th></tr>
			<tr><td><?php echo $rowdeac; ?></td></tr>
		</table>
	</div></a>
	<a href="low_bal_retailer.php">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Total Low Balance Retailers</th></tr>
			<tr><td><?php echo $row6; ?></td></tr>
		</table>
	</div>
	</a>
	<a href="recharge_history.php"><div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Today's Recharge</th></tr>
			<tr><td><?php echo $sum2; ?></td></tr>
		</table>
	</div></a>
	<a href="withdraw_commision.php">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Total Redeem Commission</th></tr>
			<tr><td><?php echo floor($sum5); ?></td></tr>
		</table>
	</div>
	</a>
	<a href="withdraw_commision.php">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Total Pending Commission</th></tr>
			<tr><td><?php echo floor($sum4); ?></td></tr>
		</table>
	</div>
	</a>
	<a href="withdraw_commision.php">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Total Earn Commission</th></tr>
			<tr><td><?php echo floor($sum3); ?></td></tr>
		</table>
	</div>
	</a>
	<a href="withdraw_commision.php">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Today's Commission</th></tr>
			<tr><td><?php echo floor($sum7); ?></td></tr>
		</table>
	</div>
	</a>
	<a href="#">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Today's Referral Recharge</th></tr>
			<tr><td><?php
			$sumRefRech=0;
			$quGetRefRech="select * from recharge where ReferalId='$userid' and Rechargedate='$date1' and Status='SUCCESS'";
			$reGetRefRech=mysqli_query($con,$quGetRefRech);
			while($dataGetRefRech=mysqli_fetch_array($reGetRefRech))
			{
			    $RefRechAmount=$dataGetRefRech['Amount'];
			    $sumRefRech=$sumRefRech+$RefRechAmount;
			}
			$todayRefComm=$sumRefRech*.2/100;
			echo $sumRefRech; ?></td></tr>
		</table>
	</div>
	</a>
	<a href="getReferalIncome.php" target="_blank">
	<div class="content1">
		<table border="1" cellpadding="8">
			<tr><th>Today's Referral Commission</th></tr>
			<tr><td><?php echo floor($todayRefComm); ?></td></tr>
		</table>
	</div>
	</a>
</div>
	<div class="foot">
		<p>Copyright . © 2018 - 2019   |   All rights Reserved</p>
	</div>
</body>
</html>