1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / home / earnlouq / buildersmine.com / admin /
Filename : pending-deposits.php
back
<?php
session_start();
error_reporting(0);
include('../../config/bconfig.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="Deposit Amount is invalid";
        $type = "warning";
    }else{
     $amount=$row['amount'];
     $plan=$row['type'];

    $InvestQuery="INSERT INTO `investment` (`user_id`,`amount`,`plan`) VALUES  ('$uid','$amount','$plan')";
    $InvestResult=mysqli_query($con,$InvestQuery);
    $sql1="UPDATE `transactions` SET `status`='Confirmed',`updationDate`='$currentTime' WHERE `id`='$tid'";
    $result1=mysqli_query($con,$sql1);
    if($result1){  
    $updateQuery="UPDATE `users` SET `balance`='$newbal' WHERE `id`='$uid' ";   
    $result2=mysqli_query($con,$updateQuery);  
    $msg="Deposit Confirmed Successfully and User Account Updated.";
    $type = "success";
    echo '<script>
    setTimeout(function () {
      window.location ="pending-deposits.php";
  }, 3000);</script>';
    }else{
    $msg="something went wrong,please try again";
    $type = "warning";
    }  
}
}
// Coin Deposit Begins
if (isset($_GET['confirmation'])) {
  $tid = $_GET['trx'];
  $uid = $_GET['uid'];

  // Fetch transaction details
  $sql = "SELECT * FROM `transactions` WHERE id = ?";
  $stmt = mysqli_prepare($con, $sql);
  mysqli_stmt_bind_param($stmt, "s", $tid);
  mysqli_stmt_execute($stmt);
  $res = mysqli_stmt_get_result($stmt);
  $row = mysqli_fetch_assoc($res);
  $amount = $row['amount'];
  $coin = $row['coin'];

  // Fetch user's information
  $sql1 = "SELECT * FROM `users` WHERE `id` = ?";
  $stmt1 = mysqli_prepare($con, $sql1);
  mysqli_stmt_bind_param($stmt1, "s", $uid);
  mysqli_stmt_execute($stmt1);
  $result = mysqli_stmt_get_result($stmt1);
  $r = mysqli_fetch_assoc($result);

  $oldbal = floatval($r[$coin]);
  $amount = floatval($amount);
  $newbal = $oldbal + $amount;


  if ($amount == "") {
    $msg = "Deposit Amount is invalid";
    $type = "warning";
  } else {
    // Update transaction status
    $sql2 = "UPDATE `transactions` SET `status` = 'Confirmed', `updationDate` = ? WHERE `id` = ?";
    $stmt2 = mysqli_prepare($con, $sql2);
    $currentTime = date('Y-m-d H:i:s');
    mysqli_stmt_bind_param($stmt2, "ss", $currentTime, $tid);
    $result2 = mysqli_stmt_execute($stmt2);

    if ($result2) {
      // Update user's balance
      $updateQuery = "UPDATE `users` SET `balance` = ? WHERE `id` = ?";
      $stmt3 = mysqli_prepare($con, $updateQuery);
      mysqli_stmt_bind_param($stmt3, "ss", $newbal, $uid);
      $result3 = mysqli_stmt_execute($stmt3);

      if ($result3) {
        $msg = "Deposit Confirmed Successfully and User Account Updated.";
        $type = "success";
        echo '<script>
              setTimeout(function () {
                  window.location = "pending-deposits.php";
              }, 3000);
          </script>';
      } else {
        $msg = "Something went wrong. Please try again";
        $type = "warning";
      }
    } 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 Deposits</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` ='Deposit' 
                         ";
                        
                         $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>Cancel</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['coin'];
                     ?>
                   <?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="#" class="btn btn-warning deactivate-account" onclick="showCancelForm(<?php echo $row['id']; ?>)">Cancel</a>
                          <div id="cancelForm_<?php echo $row['id']; ?>" style="display: none;">
                              <form id="cancelReasonForm_<?php echo $row['id']; ?>" method="post" onsubmit="return submitCancelReason(<?php echo $row['id']; ?>)">
                                  <select name="cancel_reason" class="form-control">
                                      <option value="Duplicate payment">Duplicate payment</option>
                                      <option value="Incorrect amount">Incorrect amount</option>
                                      <option value="Invalid Reference">Invalid Transaction Hash/Reference</option>
                                      <option value="Violation of policy">Violation of policy</option>
                                  </select>
                                  <input type="submit" value="Submit" class="btn btn-primary">
                              </form>
                            </div>
                            </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 Deposit yet!</p>
                      </div>
                      ";
                    }
                    ?>
                        </tbody>
                      </table>
                    </div>
                  </div>

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

              </div>

                           </div>

            </div>
           
 <script>
    function showCancelForm(id) {
        var formId = 'cancelForm_' + id;
        document.getElementById(formId).style.display = 'block';
    }

    function submitCancelReason(id) {
        var formId = 'cancelReasonForm_' + id;
        var reason = document.forms[formId]['cancel_reason'].value;

        // Send the reason to the server using AJAX
        var xhr = new XMLHttpRequest();
        xhr.onreadystatechange = function() {
            if (xhr.readyState === XMLHttpRequest.DONE) {
                if (xhr.status === 200) {
                    // Parse response JSON
                    var response = JSON.parse(xhr.responseText);
                    if (response.status === 'success') {
                        // Email sent successfully, show a success message or redirect
                        alert('Cancellation reason sent to the user successfully.');
                        // You can redirect the user or perform any other action here
                        location.reload(); // Refresh the page
                    } else {
                        // Show error message if email sending fails
                        alert('Error: ' + response.message);
                    }
                } else {
                    // Show error message if server error occurs
                    alert('Error: Unable to send cancellation reason. Server error.');
                }
            }
        };
        xhr.open('POST', 'cancel-deposit.php', true);
        xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
        xhr.send('id=' + id + '&reason=' + encodeURIComponent(reason));

        // Prevent form submission
        return false;
    }
</script>



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