1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / manager /
Filename : withdrawal-history-user.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
$title="Pending Services";
$currentTime = date( 'd-m-Y h:i:s A', time ());

$uid=intval($_GET['uid']);// users's id

$sql = "SELECT * FROM `users` WHERE `id`=$uid";
$res = mysqli_query($con, $sql);
$user = mysqli_fetch_assoc($res);
$username=$user['username'];
$fullname=$user['fullname'];


if(isset($_GET['cancel']))
		  {
        $uid=$_GET['uid'];
        $account=$_GET['atype'];
        $amount=$_GET['amount'];
        $trans_id=$_GET['wid'];

        if ($account == 'Activity') {
          $account_table_name = 'earnings';
        } else {
          $account_table_name = 'ref_bonus';
        }
      
        $sql = "UPDATE `transactions` set `status`='Cancelled',updationDate='$currentTime'
        WHERE `id`='$trans_id' ";	
     $res = mysqli_query($con, $sql);
           if($res){

            $updateQuery = "UPDATE `users` SET `$account_table_name`=$account_table_name+$amount WHERE `id`='$uid'";
            $result2 = mysqli_query($con, $updateQuery);

               $msg="Withdrawal Cancelled Successfully!";
               $type = "success";
               echo "<script>window.location.href='pending-withdrawals.php';</script>";
           }else{
               $msg="Failed to Cancel Withdrawal";
               $type = "warning";
               echo "<script>window.location.href='pending-withdrawals.php';</script>";
           }


		  }

if ($_SERVER["REQUEST_METHOD"] == "POST") {
  if (isset($_POST["selectedRows"])) {
    $selectedRows = $_POST["selectedRows"];
    if (isset($_POST["updateButton"])) {
      // Update button was clicked
      foreach ($selectedRows as $rowId) {
        $sql = "UPDATE `transactions` set `status`='Confirmed',updationDate='$currentTime'
        WHERE `id`='$rowId' ";	
           $res = mysqli_query($con, $sql);
           if($res){
               $msg="Withdrawal Status Updated Successfully!";
               $type = "success";
           }else{
               $msg="Failed to Update Request Status";
               $type = "warning";
           }
      }
    } elseif (isset($_POST["deleteButton"])) {
      // Delete button was clicked
      foreach ($selectedRows as $rowId) {
        $sql = "DELETE FROM `transactions` WHERE `id`='$rowId' ";	
           $res = mysqli_query($con, $sql);
           if($res){
            $msg="Withdrawal Requests Deleted Successfully!";
            $type = "success";
        }else{
            $msg="Failed to Delete Items";
            $type = "warning";
        }
      }
    }
  }
}
?>
        <div class="container-fluid py-4">
                  <div class="card" style="padding:30px;">
                    <h5 class="card-header">Withdrawal History for <?php echo $fullname?></h5>  
                    <h5 class="card-header">Total Referrals-  <?php 
											$query3="SELECT * FROM `users` WHERE `referred_by`='$username'";
											$result3=mysqli_query($con,$query3);
											$num_rows3 = mysqli_num_rows($result3);
											{
												echo htmlentities($num_rows3); 
											} 
										
											?> </h5>  

                 <div>
                 <?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 }?>
            <form method="post" action="">
                <button type="submit" name="updateButton" id="updateButton" class="btn btn-primary mb-3" style="display: none;">Confirm Payment</button>
                <button type="submit" name="deleteButton" id="deleteButton" class="btn btn-danger mb-3" style="display: none;">Delete</button>
            </div>
                <div class="table-responsive table-wrapper-top text-nowrap" >
                  <table class="table table-bordered" id="dataTables-example" >
                    <thead>
                      <tr class="text-nowrap">
                        <th style="width:1px;"></th>
                        <th>SN</th>
                        <th>Amount</th>
                        <th>Date</th>
                        <th>Action</th>
                      </tr>
                    </thead>    
                  <tbody>
                  <?php 
                  $query="SELECT * FROM `transactions` WHERE `type`='Withdrawal' AND `user_id`='$uid' ";
                  $result=mysqli_query($con,$query);
                  $cnt=1;
                  if(mysqli_num_rows($result)>0){
                    while($row=mysqli_fetch_array($result)){
                        $amount=number_format($row['amount']);

                      ?>
                    <tr>
                    <td class="align-middle">
                      <input type="checkbox" name="selectedRows[]" value="<?php echo $row['id']; ?>">
                    </td>
                      <td><?php echo $cnt++;?></td>
                      <td>&#8358;<?php echo $amount;?></td>
                      <td><?php echo htmlentities($row['created_at']);?>  </td>
                      <td class="align-middle">
                      <a href="update-withdrawal-request.php?wid=<?php echo $row['id'];?>&&uid=<?php echo $row['user_id'];?>&&amount=<?php echo $row['amount'];?>" class="btn btn-primary me-1 add-to-cart-button" >Make Payment</a> 
                      <a href="?cancel=true&&wid=<?php echo $row['id'];?>&&uid=<?php echo $row['user_id'];?>&&amount=<?php echo $row['amount'];?>&&atype=<?php echo $row['account_type'];?>" 
                      onClick="return confirm('Are you sure you want cancel this withdrawal?')" class="btn btn-warning me-1 add-to-cart-button" >Cancel</a> 

                    </td>
                      
                    </tr>
                    
                    <?php } 
                    }else{

                      echo"No Record Found!";
                    }
                    ?>
                               
                  </tbody>
                </table>
                </form>
              </div>
            </div>
          </div>
        </div>
      </div>

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


<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <!-- Include jQuery library -->

<script>
$(document).ready(function() {
  $('input[name="selectedRows[]"]').change(function() {
    if ($('input[name="selectedRows[]"]:checked').length > 0) {
      $('#updateButton, #deleteButton').show(); // Show both buttons when checkboxes are selected
    } else {
      $('#updateButton, #deleteButton').hide(); // Hide both buttons when no checkboxes are selected
    }
  });
});
</script>


<?php include('include/footer.php');?>