编辑文件 - index.php

✏️ 正在编辑: index.php

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

<?php
	include'session.php';
	include'connection.php';
	include'../Retailers/functions.php';
?>
<html>
<head>
	<title>Dashboard</title>
	
    <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">
	
	
	<link rel="stylesheet" href="css/style.css">
	
	
	<script type="text/javascript" src="js/script.js"></script>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
	
	<style>
		/* Content Style Coding*/
		.data-content{
			background:#f7f7f7;
			width:100%;
			min-height:500px;
			padding:10px;
		}
		.display{
			width:240px;
			height:130px;
			border-radius:5px;
			float:left;
			margin:10px;
			box-shadow:8px 8px 8px #aaaaaa;
		}
		.div1{
			background:;
			width:30%;
			height:90px;
			float:left;
			border-radius:5px 0 0 0;
			color:white;
		}
		.div1 i{
			font-size:60px;
			margin:10px;
		}
		.div2{
			background:;
			width:70%;
			height:90px;
			float:left;
			text-align:right;
			color:white;
			padding:10px 10px 0 0;
			border-radius:0 5px 0 0 ;
		}
		.div2 h3{
			padding:2px 0px;
			font-size:22px;
		}
		.div3{
			background:gray;
			width:100%;
			height:40px;
			float:left;
			border-radius:0 0 5px 5px;
			border-top:1px solid white;
			line-height:40px;
			color:white;
		}
		.div4{
			background:;
			float:left;
			height:39px;
			margin-left:15px;
		}
		.div5{
			background:;
			float:right;
			height:39px;
			margin-right:15px;
		}
		.div5 i{
			margin-top:10px;
			font-size:19px;
		}
		
		table{width:auto; margin:10px; border-collapse:collapse; background:white; float:left;}
		table th{background:gray; color:white; padding:5px 10px;text-align:center; border-left:white solid 1px;}
		table td{padding:5px 10px; border-collapse:collapse; text-align:center;}
	</style>
	
	<link rel="stylesheet" href="css/mediaStyle.css">
</head>
<body>
	
	<?php
		require'header.php';
	?>
	
	<div class="container">
		<?php 
		    include'menu.php';
		    $totalIncome=0;
	        $quIncome="SELECT * FROM commwallet WHERE Userid='300000' AND Date='$date' OR Userid='200010' AND Date='$date'";
	        $reIncome=mysqli_query($con,$quIncome);
	        while($dataIncome=mysqli_fetch_array($reIncome))
	        {
		        $totalIncome=$totalIncome+$dataIncome['Balance'];
	        }
	
	        $quDownline="SELECT * FROM retailer";
	        $reDownline=mysqli_query($con,$quDownline);
	        $countDownline=mysqli_num_rows($reDownline);
	
	        
	        $reqAmount=0;
	        $quReqToday="SELECT * FROM paymentreq WHERE Date='$date' AND Status='APPROVED'";
	        $reReqToday=mysqli_query($con,$quReqToday);
	        while($dataReqToday=mysqli_fetch_array($reReqToday))
	        {
	            $reqAmount=$reqAmount+$dataReqToday['Amount'];
	        }
		?>
		<div class="content">
			<div class="head">
				<div class="title"><p>Dashboard :-</p></div>
				<div class="msg"><marquee><?php include'msg.php'; ?></marquee></msg>
			</div><hr>
			<div class="data-content">
				<div class="display" style="background:orange;">
					<div class="div1"><i class="fa fa-inr"></i></div>
					<div class="div2">
						<h3>Income Of The Day</h3>
						<i class="fa fa-inr"></i> <?php echo floor($totalIncome); ?>
					</div>
					<a href="redeem_commission.php"><div class="div3">
						<div class="div4"><p>View List</p></div>
						<div class="div5"><i class="fa fa-arrow-circle-right"></i></div>
					</div></a>
				</div>
				<div class="display" style="background:green;">
					<div class="div1"><i class="fa fa-sitemap"></i></div>
					<div class="div2">
						<h3>Total Retailers</h3>
						<i class="fa fa-users"></i> <?php echo $countDownline; ?>
					</div>
					<a href="retailers_list.php"><div class="div3">
						<div class="div4"><p>View List</p></div>
						<div class="div5"><i class="fa fa-arrow-circle-right"></i></div>
					</div></a>
				</div>
				<div class="display" style="background:purple;">
					<div class="div1"><i class="fa fa-shopping-cart"></i></div>
					<div class="div2">
						<h3>Purchase Of The Day</h3>
						<i class="fa fa-shopping-cart"></i> <?php echo $reqAmount; ?>
					</div>
					<a href="topup_reports.php"><div class="div3">
						<div class="div4"><p>View List</p></div>
						<div class="div5"><i class="fa fa-arrow-circle-right"></i></div>
					</div></a>
				</div>
				<div class="data_rech">
				    <?php 
				        include'insertDiff.php'; 
				        include'diff.php';
				    ?>
				    <table border="1" cellpadding="10">
				        <tr>
				            <th style="border-left:solid black 1px">User</th>
				            <th>Bal</th>
				        </tr>
				        <tr>
				            <td>Admin</td>
				            <td><?php echo floor($AdminBal) ?></td>
				        </tr>
				        <tr>
				            <td>MD BAL</td>
				            <td><?php echo floor($totalMdBal) ?></td>
				        </tr>
				        <tr>
				            <td>DIS BAL</td>
				            <td><?php echo floor($DiswalletBal) ?></td>
				        </tr>
				        <tr>
				            <td>RET BAL</td>
				            <td><?php echo floor($RetWalletBal) ?></td>
				        </tr>
				        <tr>
				            <td>MLM User</td>
				            <td><?php echo floor($mlmWalletBal) ?></td>
				        </tr>
				        <tr>
				            <td>Commission</td>
				            <td><?php echo floor($Commission) ?></td>
				        </tr>
				        <tr>
				            <td>TOT USER</td>
				            <td><?php echo floor($totalUserWalletBal) ?></td>
				        </tr>
				        <tr>
				            <td>TOT BIZ</td>
				            <td><?php echo floor($TotalBizBal) ?></td>
				        </tr>
				        <tr>
				            <td>TOT BANK</td>
				            <td><?php echo floor($AllBankBal) ?></td>
				        </tr>
				        <tr>
				            <td>BIZ DIF</td>
				            <td><?php echo floor($BizDiff) ?></td>
				        </tr>
				        <tr>
				            <td>TOT DIF</td>
				            <td><?php echo floor($BenefitBal) ?></td>
				        </tr>
				    </table>
				    <table border="1" cellpadding="10">
				        <tr>
				            <th>Operator</th>
				            <th>Amount</th>
				            <th>RO</th>
				            <th>RO%</th>
				        </tr>
				<?php
				    $totalRech=0;
				    $totalRO=0;
				    
				    $quRechByOp = "SELECT Companyname, SUM(Amount), SUM(R_Offer) FROM `recharge` WHERE Rechargedate='$date' AND Status='SUCCESS' GROUP BY Companyname";
				    $reRechByOp = mysqli_query($con,$quRechByOp);
				    
				    while($dataByOp=mysqli_fetch_array($reRechByOp))
				    {
				        $r_offer=$dataByOp[2];
				        $r_offer_perc=$r_offer*100/$dataByOp[1];
				        $r_offer_perc=number_format((float)$r_offer_perc, 2, '.', '');
				        echo "<tr>";
				            echo "<td><a href='recharge_details.php?OP=".$dataByOp[0]."' target='_blank'>".$dataByOp[0]."</a></td>";
				            echo "<td>".$dataByOp[1]."</td>";
				            echo "<td>".floor($r_offer)."</td>";
				            echo "<td>".$r_offer_perc."</td>";
				        echo "</tr>";
				        $totalRech=$totalRech+$dataByOp[1];
				        $totalRO=$totalRO+$dataByOp[2];
				    }
				    echo "<tr>";
			            echo "<th>TOTAL</th>";
			            echo "<th>".$totalRech."</th>";
			            echo "<th>".floor($totalRO)."</th>";
			            echo "<th></th>";
				    echo "</tr>";
				    
				?>
				    </table><table border="1" cellpadding="10">
				        <tr>
				            <th>Operator</th>
				            <th>Amount</th>
				            <th>RO</th>
				            <th>RO%</th>
				            <th>Rech Id</th>
				        </tr>
				<?php
				    $totalRech=0;
				    $totalRO=0;
				    $date1=date_create($date);
		            date_sub($date1,date_interval_create_from_date_string("7 days"));
		            $resultdate=date_format($date1,"Y-m-d");
				    $quRoffer = "SELECT Companyname, Amount, R_Offer, Id FROM `recharge` WHERE Rechargedate>='$resultdate' GROUP BY FLOOR(R_Offer) ORDER BY FLOOR(R_Offer) DESC LIMIT 30";
				   //            SELECT Companyname, Amount, R_Offer, Id FROM `recharge` WHERE Rechargedate>='2025-06-20'  GROUP BY FLOOR(R_Offer) ORDER BY FLOOR(R_Offer) DESC LIMIT 20
				   //            SELECT Companyname, Amount, R_Offer, Id FROM `recharge` WHERE Rechargedate>='2025-06-20'  GROUP BY FLOOR(R_Offer) ORDER BY FLOOR(R_Offer) DESC LIMIT 20
				    $reRoffer = mysqli_query($con,$quRoffer);
				    
				    while($dataRoffer=mysqli_fetch_array($reRoffer))
				    {
				        $rofferPercent=$dataRoffer[2]*100/$dataRoffer[1];
				        $rofferPercent=number_format((float)$rofferPercent, 2, '.', '');
				        echo "<tr>";
				            echo "<td>".$dataRoffer[0]."</td>";
				            echo "<td>".$dataRoffer[1]."</td>";
				            echo "<td>".$dataRoffer[2]."</td>";
				            echo "<td>".$rofferPercent."</td>";
				            echo "<td>".$dataRoffer[3]."</td>";
				        echo "</tr>";
				    }
				    
				?>
				    </table>
				</div>
			</div>
		</div>
	</div>
	<?php
		require'footer.php';
	?>
	<script>
		function submenu(Arg)
    {
	
	var i;
	var d = document.getElementById("submenu"+Arg);
	var a = document.getElementById("angle"+Arg);
	var nol = d.getElementsByTagName('li').length;
	var dh = (35*nol)+8;
	
	d.style.transition = "all 1s";
	a.style.transition = "all .5s";
	if(d.style.height==dh+"px")
	{
		d.style.height = "0px";
		a.style.transform = "rotate(0deg)";
	}
	else
	{
		for(i=1; 1<=10; i++)
		{
			if(i==Arg)
			{	
				d.style.height = dh+"px";
				document.getElementById("angle"+i).style.transform = "rotate(90deg)";

}
			else
			{	
				var od = document.getElementById("submenu"+i);
				od.style.height = "0px";
				document.getElementById("angle"+i).style.transform = "rotate(0deg)";
			}
		}
	}
}
	</script>
</body>
</html>

← 返回文件管理器