1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / .trash /
Filename : leadership-board.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.php');
include('includes/checklogin.php');
include('includes/functions.php');

check_login();
$title="Dashboard";
$uid=$_SESSION['id'];
$uip=$_SERVER['REMOTE_ADDR'];
include 'includes/header.php'; 

$currentTime = date( 'd-m-Y h:i:s A', time () );
$uid= $_SESSION['id'];

$sql = "SELECT * FROM `users` WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);


?>
  
  <div class="container-fluid main-content px-2 px-lg-4">
    <div class="row my-2 g-3 g-lg-4 promotion">
        <div class="col-12 d-flex justify-content-between align-items-center px-3 flex-wrap gap-3">
            <h5 class="text-white mb-0">Leadership Board</h5>
        </div>


                <div class="row my-2 g-3 g-lg-4">
                
                <?php 
                    //$query = "SELECT * FROM `users` WHERE `ref_bonus` >= 4500 ORDER BY `ref_bonus` DESC LIMIT 10";
                     
                    $query = "SELECT u.username, u.user_picture, SUM(e.amount) AS total_earning
                    FROM earning_history e
                    JOIN users u ON e.user_id = u.id
                    GROUP BY u.username, u.user_picture
                    HAVING total_earning >= 2
                    ORDER BY total_earning DESC
                    LIMIT 200";    
                    $result=mysqli_query($con,$query);
                    $cnt=1;
                    if(mysqli_num_rows($result)>0){
                    while($row=mysqli_fetch_array($result)){
                        $username = $row['username'];
                        $userPicture = $row['user_picture'];
                        $totalEarning = $row['total_earning'];

                        $formattedTotalEarning = number_format($totalEarning, 2);

                    ?>
                       <div class="col-md-6 col-xl-4 col-xxl-3">
                            <div class="price-box">
                            <div class="d-flex align-items-center justify-content-between">
                                <div>
                                <p class="text-white mb-0"><?php echo $username;?></p>
                                <h4 class="text-white mb-0" style="font-size:30px;margin-top:10px;">$<?php echo $formattedTotalEarning;?></h4>
                                </div>
                                <img src="../admin/profilepics/<?php echo $row['user_picture'];?>" 
                                style="height:50px;width:50px;"
                                  class="rounded-circle" alt="">
                            </div>
                           
                            </div>
                        </div>
                                
            <?php } 
                                }else{ ?>
                                    <div class="row my-2 g-3 g-lg-4 mt-5" >
                                            <p style="text-align:center;">No record found!</p>
                                </div>
                    <?php  } ?>

                      


                </div>

  
</div>

<div style="margin-top:30px;height:10px;"></div>

<?php include 'bottom-tabs.php' ?>      
<?php include 'includes/footer.php' ?>