1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / promarketindex.site / admin /
Filename : dashboard.php
back
<?php
session_start();
error_reporting(0);
include('../../config/pconfig.php');
include('includes/checklogin.php');
check_login();
$title="Dashboard";
include 'includes/header.php'; 
include 'includes/sidebar.php';

ini_set('display_errors', 1);
error_reporting(E_ALL);
?>



			
<div class="container-fluid py-4">
      <div class="row">
        <div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
                <div class="col-8">
                  <div class="numbers">
                    <p class="text-sm mb-0 text-capitalize font-weight-bold">Total Users 
                    <h5 class="font-weight-bolder mb-0 mt-2" style="font-weight:700">

                    <?php 
                      $query="SELECT * FROM `users` ";
                      $result=mysqli_query($con,$query);			
                      $num_rows = mysqli_num_rows($result);
                      {
                    ?>
										<?php echo $num_rows;  } ?>
                    </h5>
                  </div>
                </div>
                <div class="col-4 text-end">
                  <div class="icon icon-shape bg-gradient-primary shadow text-center border-radius-md">
                    <i class="ni ni-money-coins text-lg opacity-10" aria-hidden="true"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
        <div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
                <div class="col-8">
                  <div class="numbers" style="width:150% !important;">
                    <p class="text-sm mb-0 text-capitalize font-weight-bold">Total Investment</p>
				        	<h5 class="font-weight-bolder mb-0 mt-2" style="font-weight:700">
                  <?php 
              $query="SELECT * FROM `investment` ";
              $result=mysqli_query($con,$query);
              $sum = 0;
              while($row=mysqli_fetch_array($result)){ 
              $amount = $row['amount'];
              $sum += (int)$amount;          
              }  
              ?>
                      $<?php echo number_format($sum) ?>
                    </h5>
                  </div>
                </div>
                <div class="col-4 text-end">
                  <div class="icon icon-shape bg-gradient-primary shadow text-center border-radius-md">
                    <i class="ni ni-world text-lg opacity-10" aria-hidden="true"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
        
        <div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
                <div class="col-8">
                  <div class="numbers">
                    <p class="text-sm mb-0 text-capitalize font-weight-bold">Total Withdrawal</p>
                    <h5 class="font-weight-bolder mb-0 mt-2" style="font-weight:700">
                    <?php 
              $query="SELECT * FROM `transactions` WHERE `status`='Confirmed' AND 
              `type`='Withdrawal' ";
              $result=mysqli_query($con,$query);
    
              $sum = 0;
              while($row=mysqli_fetch_array($result)){ 
              $amount = $row['amount'];
              $sum += (int)$amount;          
              }  
              ?>
                      $<?php echo number_format($sum) ?>

                    </h5>
                  </div>
                </div>
                <div class="col-4 text-end">
                  <div class="icon icon-shape bg-gradient-primary shadow text-center border-radius-md">
                    <i class="ni ni-paper-diploma text-lg opacity-10" aria-hidden="true"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
        <div class="col-xl-3 col-sm-6 mb-xl-0 ">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
                <div class="col-8">
                  <div class="numbers">
                    <p class="text-sm mb-0 text-capitalize font-weight-bold">Total Wallets</p>
                    <h5 class="font-weight-bolder mb-0 mt-2" style="font-weight:700">
                    <?php 
                      $query="SELECT * FROM `coins` ";
                      $result=mysqli_query($con,$query);			
                      $num_rows = mysqli_num_rows($result);
                      {
                    ?>
										<?php echo $num_rows;  } ?>

                    </h5>
                  </div>
                </div>
                <div class="col-4 text-end">
                  <div class="icon icon-shape bg-gradient-primary shadow text-center border-radius-md">
                    <i class="ni ni-paper-diploma text-lg opacity-10" aria-hidden="true"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>

       
        
      </div>
      <div class="row mt-4">
        <div class="col-lg-12 mb-lg-0 mb-4">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
                <div class="col-lg-12">
                  <div class="d-flex flex-column h-100">
                    <p class="mb-1 pt-2 text-bold">Transaction History</p>
                    <?php 
                 $query="SELECT `users`.`id`,`users`.`first_name`,`users`.`last_name`,`transactions`.`type`,`transactions`.`amount`,
                 `transactions`.`status`,`transactions`.`coin`,`transactions`.`date` 
                 FROM `transactions` 
                 LEFT JOIN users on users.id=transactions.user_id  LIMIT 10 ";
                 $result=mysqli_query($con,$query);
                 $cnt=1;
                 if(mysqli_num_rows($result)>0){
               
                  ?>
                    <table class="table align-items-center mb-0">
                  <thead>
                    <tr>
                    <th>SN</th>
                    <th>Name</th>
                    <th>Type</th>
                    <th>Amount</th>
                    <th>Status</th>
                    <th>Date</th>
                    <th></th>
                    </tr>
                  </thead>
                  <tbody>
                  <?php 
            while($trx=mysqli_fetch_array($result)){
              $date_string=$trx['date'];// date retrieved from database
              $timestamp = strtotime($date_string); // convert date string to Unix timestamp
              $date = date(" jS \of F Y", $timestamp);// format timestamp into words
              ?>
                     <tr>
                   <td><?php echo $cnt++; ?></td>
                    <td><?php echo $trx['first_name']; ?> <?php echo $trx['last_name']; ?></td>
                    <td><?php echo $trx['type']; ?></td>
                    <td class="uppercase-text"><?php echo $trx['amount']; ?><?php echo $trx['coin']; ?></td>
                    <td>
                    <?php if($trx['status'] == 'Pending'){   
                    ?>
                     <label class="btn btn-warning"><?php echo $trx['status']; ?></label>
                     <?php }else{
                        ?>
                    <label class="btn btn-success"><?php echo $trx['status']; ?></label>
                      
                     <?php }?>
                        </td>
                        <td><?php echo $date ?></td>
                        <td>
                        <a href="account-summary.php?uid=<?php echo $trx['id'];?>" 
            class="badge badge-primary">
             User</a>
                     </td>
                  </tr>
                  <?php } 
            }else{
              echo"
              <div class='card-body'>
             <p style='text-align:left'> No Transaction yet!</p>
              </div>
              ";
            }
            ?>
                  </tbody>
                </table>
              
                  </div>
                </div>
                
              </div>
            </div>
          </div>
        </div>
        

      <div style="margin-left:10vw;height:30vh;"></div>



<?php include 'includes/footer.php' ?>