| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/jeevikagaumaa.in/public_html/admin/ |
Upload File : |
<?php include '../action/check-login.php';
include '../action/config.php'; ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<meta name="description" content="" />
<meta name="author" content="" />
<title>Level Income</title>
<link href="css/styles.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css" rel="stylesheet" crossorigin="anonymous" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/js/all.min.js" crossorigin="anonymous"></script>
<link rel="shortcut icon" href="../images/logo3.png" />
</head>
<body class="sb-nav-fixed">
<?php include 'sidebar_menu.php'; ?>
<main>
<div class="container-fluid">
<ol class="breadcrumb mb-4 mt-2">
<li class="breadcrumb-item font-weight-bold">Level Income</li>
</ol>
<div class="card mb-4" style="border: 1px solid #B3FBFF">
<div class="card-header" style="background-color: #B3FBFF">
<div class="row">
<div class="col-md-2">
<i class="fas fa-table mr-1"></i>Level Earning
</div>
<div class="col-md-10 text-right">
<?php
// $qry = mysqli_query($con, "SELECT SUM(amount)AS amount FROM `payment` WHERE payment_status='complete' AND purpose='Shopping'");
$qry = mysqli_query($con, "SELECT SUM(grand_total)AS amount, SUM(shipping) AS shipping FROM `orders` WHERE payment_status='success'");
$res = mysqli_fetch_array($qry);
echo $total_sale = '<b>Total Sale: ' . number_format($res['amount']-$res['shipping']).'</b>';
?>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered table-sm" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th width="5%">#</th>
<th>User-id</th>
<th>Name</th>
<th>Level</th>
<th>Income</th>
<th>Date</th>
<th>Remark</th>
</tr>
</thead>
<tbody>
<?php
$team_q = mysqli_query($con, "SELECT * FROM `level_earning` ");
$i = 0;
while ($tm = mysqli_fetch_array($team_q)) :
$i++;
?>
<tr>
<form method="POST">
<td><?php echo $i; ?></td>
<td><?php echo $tm['userid'] ?></td>
<td>
<?php
$q1 = mysqli_query($con, "SELECT * FROM `users` WHERE userid='$tm[userid]' ");
$t2 = mysqli_fetch_array($q1);
echo $t2['name'];
?>
</td>
<td><?php echo $tm['level'] ?></td>
<td><?php echo $tm['balance'] ?></td>
<td><?php echo $tm['date'] ?></td>
<td><?php echo $tm['remark'] ?></td>
</form>
</tr>
<?php
endwhile;
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</main>
<?php include 'footer.php'; ?>
<script>
$('#dataTable').dataTable({
"pageLength": 100
});
</script>
</body>
</html>