| 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/config.php';
$q1 = mysqli_query($con, "SELECT * FROM `level_earning`");
$r1 = mysqli_fetch_array($q1);
$c1 = mysqli_num_rows($q1);
$date = date('d-m-Y');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Level</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.1/dist/css/bootstrap.min.css">
<script src="https://cdn.jsdelivr.net/npm/jquery@3.6.0/dist/jquery.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.1/dist/js/bootstrap.bundle.min.js"></script>
<style>
.sidenav {
height: 100%;
width: 160px;
position: fixed;
z-index: 1;
top: 0;
left: 10;
background-color: #fff;
overflow-x: hidden;
padding-top: 20px;
}
label {
margin: 0px;
padding: 0px;
font-weight: bold;
font-size: 12px;
}
</style>
</head>
<body>
<div class="container-fluid">
<div class="row">
<div class="col-md-2">
<div class="sidenav">
<form method="POST" class="">
<div class="my-2">
<label>Userid</label>
<select type="text" name="userid[]" multiple class="form-control form-control-sm" placeholder="Userid" required style="height:250px;">
<option value="">Select Userid</option>
<?php
$i = 0;
$q2 = mysqli_query($con, "SELECT * FROM `level_earning` ");
while ($r = mysqli_fetch_array($q2)) {
$i++;
echo '<option value="' . $r['userid'] . '">' . $i . '. ' . $r['userid'] . '</option>';
}
?>
</select>
</div>
<div class="my-2">
<label>Level</label>
<select type="number" name="level" id="level" class="form-control form-control-sm" required>
<option value="">Select Level</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
</select>
</div>
<div class="my-2">
<label>Amount</label>
<input type="number" name="amount" id="amount" value="" class="form-control form-control-sm" placeholder="Amount" readonly>
</div>
<div class="my-2">
<label>Date</label>
<input type="date" name="date" value="<?= date('Y-m-d') ?>" class="form-control form-control-sm" placeholder="Date" required>
</div>
<div class="mt-4">
<input type="submit" name="update_level" class="btn btn-sm btn-block btn-primary" value="Update">
</div>
</form>
</div>
</div>
<div class="col-md-10">
<div class="row">
<div class="col-md-6 m-0 p-0">
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered table-sm" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th width="5%">#</th>
<th>Userid</th>
<th>Name</th>
<th>Level</th>
<th>Income</th>
<th>Date</th>
<th>Wallet<br>Bal</th>
</tr>
</thead>
<tbody>
<?php
$team_q = mysqli_query($con, "SELECT * FROM `level_earning` ");
$i = 0;
while ($tm = mysqli_fetch_array($team_q)) :
$i++;
?>
<tr>
<form method="POST">
<td><?php echo $i; ?></td>
<td><?php echo $tm['userid'] ?></td>
<td>
<?php
$q1 = mysqli_query($con, "SELECT * FROM `users` WHERE userid='$tm[userid]' ");
$t2 = mysqli_fetch_array($q1);
echo $t2['name'];
?>
</td>
<td><?php echo $tm['level'] ?></td>
<td><?php echo $tm['balance'] ?></td>
<td><?php echo $tm['date'] ?></td>
<td>
<?php
$q11 = mysqli_query($con, "SELECT * FROM `user_wallet` WHERE userid='$tm[userid]' ");
$t21 = mysqli_fetch_array($q11);
echo $t21['wallet_bal'];
?>
</td>
</form>
</tr>
<?php
endwhile;
?>
</tbody>
</table>
</div>
</div>
</div>
<div class="col-md-6 m-0 p-0">
<?php
//$qry = mysqli_query($con, "SELECT SUM(amount)AS amount FROM `payment` WHERE payment_status='complete' AND purpose='Shopping' ");
$qry = mysqli_query($con, "SELECT SUM(grand_total)AS amount, SUM(shipping) AS shipping FROM `orders` WHERE payment_status='success'");
$res = mysqli_fetch_array($qry);
echo $total_sale = '<b>Total Sale: ' . number_format($res['amount']-$res['shipping']).'</b>';
echo '<br>';
$qry2 = mysqli_query($con, "SELECT * FROM `level_0`");
while ($r2 = mysqli_fetch_array($qry2)) :
echo 'Level-' . $r2['id'] . ', Amt: ' . $r2['income'] . '@ ';
endwhile;
for ($i = 1; $i <= $c1; $i++) {
$n2 = 3 * $i;
for ($j = 1; $j <= 7; $j++) {
echo '<span class="border border-dark m-1 px-1">' . number_format($n2 * 1000) . '</span>';
$n2 = (3 * $n2 + 3);
}
echo '<br>';
}
?>
</div>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function() {
$('#level').on('change', function() {
var level = $('#level').val();
if (level == 1) {
document.getElementById("amount").value = 210;
}
if (level == 2) {
document.getElementById("amount").value = 270;
}
if (level == 3) {
document.getElementById("amount").value = 540;
}
if (level == 4) {
document.getElementById("amount").value = 1620;
}
if (level == 5) {
document.getElementById("amount").value = 4860;
}
if (level == 6) {
document.getElementById("amount").value = 14580;
}
if (level == 7) {
document.getElementById("amount").value = 43740;
}
});
});
</script>
</body>
</html>
<?php
if (isset($_POST['update_level'])) {
$users = $_POST['userid'];
$level = $_POST['level'];
$amount = $_POST['amount'];
$date = $_POST['date'];
foreach($users as $userid){
$qry4 = mysqli_query($con, "UPDATE `level_earning` SET level='$level', balance=balance+'$amount', date='$date', remark='Level $level Achieved' WHERE userid='$userid' ");
$qry5 = mysqli_query($con, "UPDATE `user_wallet` SET wallet_bal=wallet_bal+'$amount', total_income=total_income+'$amount' WHERE userid='$userid' ");
mysqli_query($con, "INSERT INTO `transaction`(`userid`, `credit`, `tr_date`, `remark`, `status`) VALUES ('$userid','$amount','$date','Level $level Achieved','Success')");
}
echo '<script> window.location.href = "";</script>';
}
?>