编辑文件 - lazy_retailer.php

✏️ 正在编辑: lazy_retailer.php

路径: /home/llpreacharge/public_html/Project/distributer/lazy_retailer.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php
	session_start();
	if($_SESSION['did'])
	{
		$userid= $_SESSION['did'];
	}
	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>Lazy Retailers</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;}
 
 .content{background:; width:100%; height:210px; margin:-19px 0 0 0; padding:0;}
 .content h3{padding:10 0 0 20px; font-size:20px;}
 .content table{margin:-10px 0 0 0;}
 #subbtn{float:right; margin:10 180 0 0px; padding:10 20px; background:#996420;
 color:white; border-radius:5px; border:1px solid white; font-size:17px;}
 #subbtn:hover{background:#d1994a; color:black; cursor:pointer;}
 
#t1{ width:1500px; text-align:center; border-collapse:collapse; border-color:black; margin-left:20px;}
#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; }
#t1 a{text-decoration:none; color:white; }
#act{width:230px;}

#baldiv{color:red; }
#anchor{margin-left:9px; float:left; background:#5c5b59; padding:2 10 2 10px; border-radius:4px;}
 .viewmd{width:1500px; height:40px; background:#996420; margin:10 0 0 20px;}
 .viewmd h3{margin-left:20px; line-height:40px; color:white;}
  background:#d1994a;}
 #td2 input{ padding:5px;}
 #green{color:#19dc42;}
 #red{color:red; }
 #red1{color:red; background:#dee0fe; font-size:20px;}
 
</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">
	    <?php include'menu.php'; ?>
	</div>
		
	<div class="viewmd">
		<h3>View Lazy Retailers</h3>
	</div>
	<table border="1" cellpadding="5" id="t1">
		<tr >
			<th>Sl No.</th>
			<th>Join Date</th>
			<th>Retailer Id</th>
			<th>Retailer Name</th>
			<th>Mobile</th>
			<th>State</th>
			<th>City</th>
			<th>Email Id</th>
			<th>Last Recharge Date</th>
			<th>Balance</th>
			<th>Action</th>
		</tr>
	<?php
		include'connection.php';
		
		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");
		
		$sl=0;
		
		$query1="select * from retailer where Parentid='$userid' and Lastrechdate<'$resultdate' order by Lastrechdate asc";
		$result1=mysqli_query($con,$query1);
		while($row=mysqli_fetch_array($result1))
		{
			$sl=$sl+1;
			if($row['Balance']<1000)
			{
				$color="red";
			}
			else
			{
				$color="green";
			}
			
			
		echo "<tr>";
			echo "<td>".$sl."</td>";
			echo "<td>".$row['JoinDate']."</td>";
			echo "<td>".$row['Userid']."</td>";
			echo "<td>".$row['Name']."</td>";
			echo "<td>".$row['Mobile']."</td>";
			echo "<td>".$row['State']."</td>";
			echo "<td>".$row['City']."</td>";
			echo "<td>".$row['Email']."</td>";
			echo "<td id='red1'>".$row['Lastrechdate']."</td>";
			
			$query2="select * from wallet where Userid=".$row['Userid']." order by Id desc";
			$result2=mysqli_query($con,$query2);
			$row1=mysqli_fetch_array($result2);
			echo "<td id='".$color."'>".$row1['Balance']."</td>";
			echo "<td id='act'>
					<div id='anchor'><a href='credit.php?id=".$row['Userid']."'>Credit</a></div>
					<div id='anchor'><a href='set_commission.php?id=".$row['Userid']."'>Set Commision</a></div>
				</td>";
		echo "</tr>";
		}
	?>
	</table>
<div class="footer">
		<p style="text-align:center;">Copyright &copy; 2018 -2019 Long Life Product Pvt. Ltd.</p>
</div>
	
</body>
</html>

← 返回文件管理器