| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/jeevikagaumaa.in/public_html/admin/ |
Upload File : |
<?php include '../action/check-login.php'; include '../action/config.php';
$userid = $_GET['userid'];
$amount = $_GET['amount'];
$qry = mysqli_query($con,"SELECT * FROM `users` WHERE userid='$userid'");
$r=mysqli_fetch_array($qry);
$name =$r['name'];
$email =$r['email'];
$phone =$r['phone'];
$pro_member =$r['pro_member'];
$KYC_qry = mysqli_query($con,"SELECT * FROM `user_kyc` WHERE userid='$userid'");
$kyc=mysqli_fetch_array($KYC_qry);
$aadhar_num =$kyc['aadhar_num'];
$aadhar_img =$kyc['aadhar_img'];
$pan_num =$kyc['pan_num'];
$pan_img =$kyc['pan_img'];
$message =$kyc['message'];
$wallet_qry = mysqli_query($con,"SELECT * FROM `user_wallet` WHERE userid='$userid'");
$wallet=mysqli_fetch_array($wallet_qry);
$wallet_bal =$wallet['wallet_bal'];
$widraw_amt =$wallet['widraw_amt'];
$total_income =$wallet['total_income'];
$tq = mysqli_query($con,"SELECT * FROM `transaction` WHERE userid = '$userid' AND remark = 'Withdraw request by user' AND status = 'Pending'");
$tr= mysqli_fetch_array($tq);
$tr_id = $tr['tr_id'];
$bank_qry = mysqli_query($con,"SELECT * FROM `user_bank` WHERE userid='$userid'");
$bnk = mysqli_fetch_array($bank_qry);
if($bnk['ac_name']==NULL || $bnk['ac_num']==NULL || $bnk['ifsc']==NULL || $bnk['bank_name']==NULL || $bnk['branch']==NULL){
$bnk['ac_name'] = 'Account Not Updated';
$bnk['ac_num'] = 'Account Not Updated';
$bnk['ifsc'] = 'Account Not Updated';
$bnk['bank_name'] = 'Account Not Updated';
$bnk['branch'] = 'Account Not Updated';
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<meta name="description" content="" />
<meta name="author" content="" />
<title>Admin</title>
<link href="css/styles.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css" rel="stylesheet" crossorigin="anonymous" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/js/all.min.js" crossorigin="anonymous"></script>
<link rel="shortcut icon" href="../images/logo3.png" />
<style>
#blink {
font-weight: bold;
color: #2d38be;
transition: 0.5s;
}
</style>
</head>
<body class="sb-nav-fixed">
<?php include 'sidebar_menu.php'; ?>
<main>
<div class="container-fluid">
<ol class="breadcrumb mb-4 mt-2">
<li class="breadcrumb-item font-weight-bold">Withdraw Request Details</li>
</ol>
<div class="card">
<div class="card-header d-block d-md-flex">
<h5 class="mb-0 text-primary">Withdraw Requested by User</h5>
</div>
<div class="card-body">
<div class="row">
<div class="col-md-6">
<p class="font-weight-bold">User KYC Details</p>
<hr>
<p id="blink"><?php echo $message; ?></p>
<p> Aadhar Number : <?php echo $aadhar_num; ?></p>
<p> Pan Number : <?php echo $pan_num; ?></p>
<p>Aadhar Image : <img height="300px" src="../users/assets/img/<?php echo $aadhar_img; ?>"></p>
<p>Pan Image : <img height="300px" src="../users/assets/img/<?php echo $pan_img; ?>"></p>
</div>
<div class="col-md-6">
<p class="font-weight-bold">User Bank Details</p>
<hr>
<p>A/C Name : <?php echo $bnk['ac_name']; ?></p>
<p>A/C Number : <?php echo $bnk['ac_num']; ?></p>
<p>IFSC : <?php echo $bnk['ifsc']; ?></p>
<p>Bank Name : <?php echo $bnk['bank_name']; ?></p>
<p>Branch : <?php echo $bnk['branch']; ?></p>
<br>
<hr>
<p class="font-weight-bold">User Wallet Details</p>
<hr>
<p>Available Balance : <?php echo $wallet_bal; ?></p>
<p>Request Balance : <?php echo $amount; ?></p>
<form action="" method="POST">
<div>
<lable>Request Amount : </lable><br>
<input type="text" name="amt" value="<?php echo $amount; ?>" class="form-control" readonly /><br>
<lable>Transaction Id : </lable><br>
<input type="text" name="tr_id" value="<?php echo $tr_id; ?>" class="form-control" readonly /><br>
<lable>Select Status : </lable><br>
<select name="status" class="form-control">
<option value="Success">Success</option>
<option value="Rejected">Rejected</option>
<option value="Pending">Pending</option>
</select><br>
<lable>Remarks : </lable><br>
<textarea type="text" name="remark" placeholder="Write Something about this payment and status" class="form-control" required ></textarea><br>
<button type="submit" name="send_money" class="btn btn-primary text-center form-control">Send Money</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</main>
<?php include 'footer.php'; ?>
<script type="text/javascript">
var blink = document.getElementById('blink');
setInterval(function() {
blink.style.opacity = (blink.style.opacity == 0 ? 1 : 0);
}, 700);
</script>
</body>
</html>
<?php
if(isset($_POST['send_money'])){
$status = $_POST['status'];
$amt = $_POST['amt'];
$remark = $_POST['remark'];
$date=date("d/m/Y");
if($status=='Success'){
$wid_amt = $widraw_amt+$amt;
$qry1 = mysqli_query($con,"UPDATE `user_wallet` SET widraw_req='0', widraw_amt='$wid_amt', date='$date' WHERE userid='$userid'");
$qry2 = mysqli_query($con,"UPDATE `transaction` SET status = '$status' WHERE tr_id='$tr_id'");
$to = $email; // password: workdham12345
$from = 'info@workdham.com'; //password: srijan1234
$fromName = 'WORKDHAM Ranchi';
$subject = ' Withdrawal Request Confirmation Mail ';
$htmlContent .= '
<html>
<body>
<h3> Dear '.$name.' </h3>
<p> Withdrawal Amount = '.$amt.' </p>
<p> TXN Id : '.$tr_id.' </p>
<p> date : '.$date.' </p>
<p> Status : '.$status.' </p>
<p> Remarks : '.$remark.' </p>
</body>
</html>
';
$headers = "From: $fromName"." <".$from.">";
$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
$headers .= "\nMIME-Version: 1.0\n" . "Content-Type: multipart/mixed;\n" . " boundary=\"{$mime_boundary}\"";
$message = "--{$mime_boundary}\n" . "Content-Type: text/html; charset=\"UTF-8\"\n" .
"Content-Transfer-Encoding: 7bit\n\n" . $htmlContent . "\n\n";
$message .= "--{$mime_boundary}--";
$returnpath = "-f" . $from;
$mail = @mail($to, $subject, $message, $headers, $returnpath);
echo ' <script> alert("Payment sent Success"); window.location.href="withdraw_request" </script> ';
}
}
?>