1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / promarketindex.site / admin /
Filename : pending-withdrawals.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';
$currentTime = date( 'd-m-Y h:i:s A', time () );


if(isset($_GET['confirm']))
{
    $tid=($_GET['trx']);
    $uid=($_GET['uid']);

    $sql = "SELECT * FROM `transactions` WHERE id='$tid' ";
    $res = mysqli_query($con, $sql);
    $row = mysqli_fetch_assoc($res);
    $amount=$row['amount'];

    $sql1 = "SELECT * FROM `users` WHERE `id`='$uid' ";
    $result = mysqli_query($con, $sql1);
    $r = mysqli_fetch_assoc($result);
    $oldbal=$r['balance'];
    $newbal=($oldbal-$amount);


    if($amount =""){ 
        $msg="Withdrawal Amount is invalid";
        $type = "warning";
    }else{
     $amount=$row['amount'];
    $sql1="UPDATE `transactions` SET `status`='Confirmed',`updationDate`='$currentTime' WHERE `id`='$tid'";
    $result1=mysqli_query($con,$sql1);
    if($result1){  
    $msg="Withdrawal Confirmed Successfully";
    $type = "success";
    }else{
    $msg="something went wrong,please try again";
    $type = "warning";
    }  
}
}
// Coin Withdrawal Begins
if(isset($_GET['confirmation']))
{
    $tid=($_GET['trx']);
    $uid=($_GET['uid']);


    $sql = "SELECT * FROM `transactions` WHERE id='$tid' ";
    $res = mysqli_query($con, $sql);
    $row = mysqli_fetch_assoc($res);
    $amount=$row['amount'];
    $coin=$row['coin'];

    $sql1 = "SELECT * FROM `users` WHERE `id`='$uid' ";
    $result = mysqli_query($con, $sql1);
    $r = mysqli_fetch_assoc($result);
    $oldbal=$r[$coin];
    $newbal=($oldbal-$amount);

    if($amount =""){ 
        $msg="Withdrawal Amount is invalid";
        $type = "warning";
    }else{
    $sql1="UPDATE `transactions` SET `status`='Confirmed',`updationDate`='$currentTime' WHERE `id`='$tid'";
    $result1=mysqli_query($con,$sql1);
    if($result1){  
    $msg="Withdrawal Confirmed Successfully";
    $type = "success";
    }else{
    $msg="something went wrong,please try again";
    $type = "warning";
    }  
}

}



 ?>   
     <div class="container-fluid py-4">
                <div class="card" style="padding:30px;">
                <h5 class="card-header">Pending Withdrawals</h5>
                <div class="table-responsive table-wrapper-top text-nowrap" >

                <?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>

           <div class="table-responsive">
               <?php 
                $query="SELECT `users`.`first_name`,`users`.`last_name`,`transactions`.`id`,`transactions`.`type`,`transactions`.`amount`,
                `transactions`.`status`,`transactions`.`coin`,`transactions`.`date`,`transactions`.`ref`,`transactions`.`user_id` 
                FROM `transactions` 
                LEFT JOIN users on users.id=transactions.user_id 
                WHERE  `transactions`.`status` ='Pending' AND  `transactions`.`type` ='Withdrawal' 
                ";
               
                $result=mysqli_query($con,$query);
                $cnt=1;
                if(mysqli_num_rows($result)>0){
                   ?>
             <table class="table">
               <thead>
                 <tr>
                 <th>SN</th>
                   <th>Type</th>
                   <th>Amount</th>
                   <th>Reference</th>
                   <th>Status</th>
                   <th>Time</th>
                   <th>Action</th>
                 </tr>
               </thead>
               <tbody>
               <?php 
           while($row=mysqli_fetch_array($result)){
             $date_string=$row['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 
                    $row['method'];
                     ?>
                   <?php echo $row['type']; ?>
                   </td>
                   <td class="uppercase-text">$<?php echo $row['amount']; ?><?php echo $row['coin']; ?></td>
                   <td>
                   <?php if($row['ref'] == ''){   
                   ?>
                    <label class="btn btn-danger">No Reference</label>
                    <?php }else{
                       ?>
                   <?php echo $row['ref']; ?>
                     
                    <?php }?>
                       </td>
                   <td>  <label class="btn btn-danger"><?php echo $row['status']; ?></label></td>
                   <td><?php echo $date; ?></td>
                   <td>
                   <a href="account-summary.php?uid=<?php echo $row['user_id'];?>" 
                    class="btn btn-primary">
                     User</a>
                  <?php 
                     if($row['coin'] == ''){   
                     ?>
                    <a href="?trx=<?php echo $row['id'];?>&confirm=true&uid=<?php echo $row['user_id'];?>" 
                  onClick="return confirm(`Are you sure you want to confirm deposit? Confirmation would add deposit to the user's investment`)" class="btn btn-success">
                  Confirm</a>

                     <?php }else{  ?>
                       <a href="?trx=<?php echo $row['id'];?>&confirmation=true&uid=<?php echo $row['user_id'];?>" 
                  onClick="return confirm(`Are you sure you want to confirm deposit? Confirmation would add deposit to the user's investment`)" class="btn btn-success">
                  Confirm</a>
                       <?php }  ?>

                   </td>
                    
                 
                 </tr>
                 <?php } 
           }else{
             echo"
             <div class='card-body'>
            <p style='text-align:left'> No Withdrawal yet!</p>
             </div>
             ";
           }
           ?>
               </tbody>
             </table>
           </div>
         </div>

           </div>
           </div>
         </div>

     </div>

                  </div>

   </div>
  


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