PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u403625155/domains/betawealthfx.com/public_html/admin/edit-users.php

<?php

session_start();
require "../config.php";
require "variables.php";
$unix_time=time();
if(!isset($_SESSION['id'])){
 // header("location:index.php");
}
else{
    $admin_name=$_SESSION['admin_name'];
}

?>
<!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><?php echo $sitename; ?> - Edit users</title>
<link rel="icon" type="image/x-icon" href="../css/images/favicon.png">
    <!-- Custom fonts for this template-->
    <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
    <link
        href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
        rel="stylesheet">

    <!-- Custom styles for this template-->
    <link href="css/sb-admin-2.min.css" rel="stylesheet">
    <!-- include the style -->
<link rel="stylesheet" href="../alertifyjs/css/alertify.min.css" />
<!-- include a theme -->
<link rel="stylesheet" href="../alertifyjs/css/themes/default.min.css" />

</head>

<body id="page-top">

    <!-- Page Wrapper -->
    <div id="wrapper">

        <!-- Sidebar -->
        <ul class="navbar-nav bg-gradient-primary sidebar sidebar-dark accordion" id="accordionSidebar">

            <!-- Sidebar - Brand -->
            <a class="sidebar-brand d-flex align-items-center justify-content-center" href="index.php">
                <div class="sidebar-brand-icon rotate-n-15">
                    <i class="fas fa-laugh-wink"></i>
                </div>
                <div class="sidebar-brand-text mx-3"><?php echo $sitename; ?> admin <sup></sup></div>
            </a>

            <!-- Divider -->
            <hr class="sidebar-divider my-0">

            <!-- Nav Item - Dashboard -->
            <li class="nav-item">
                <a class="nav-link" href="index.php">
                    <i class="fas fa-fw fa-tachometer-alt"></i>
                    <span>Dashboard</span></a>
            </li>

            <!-- Divider -->
            <hr class="sidebar-divider">

            <!-- Heading -->
            <div class="sidebar-heading">
                Interface
            </div>

            <!-- Nav Item - Pages Collapse Menu -->
            <li class="nav-item  active">
                <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapseTwo"
                    aria-expanded="true" aria-controls="collapseTwo">
                    <i class="fas fa-fw fa-cog"></i>
                    <span>User management</span>
                </a>
                <div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordionSidebar">
                    <div class="bg-white py-2 collapse-inner rounded">
                        <h6 class="collapse-header">Users:</h6>
                        <a class="collapse-item" href="register.php">Add users</a>
                         <a class="collapse-item" href="edit-users.php">Manage Clients</a>
                          <a class="collapse-item" href="kyc.php">Review KYC</a>
                         <a class="collapse-item" href="edit-portifolios.php">Manage Portfolios</a>
                        
						<a class="collapse-item" href="newsletter.php">Promotional emails</a>
						<a class="collapse-item" href="messages.php">Messages</a>
						
                    </div>
                </div>
            </li>

            <!-- Nav Item - Utilities Collapse Menu -->
            <li class="nav-item">
                <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapseUtilities"
                    aria-expanded="true" aria-controls="collapseUtilities">
                    <i class="fas fa-fw fa-wrench"></i>
                    <span>Settings</span>
                </a>
                <div id="collapseUtilities" class="collapse" aria-labelledby="headingUtilities"
                    data-parent="#accordionSidebar">
                    <div class="bg-white py-2 collapse-inner rounded">
                        <h6 class="collapse-header">Admin settings:</h6>
                        <a class="collapse-item" href="change-password.php">Change password</a>
                        <a class="collapse-item" href="change-username.php">Change username</a>
                        <a class="collapse-item" href="change-email.php">Login email</a>
                        <a class="collapse-item" href="site-info.php">Site info</a>
                        <a class="collapse-item" href="plans.php">Investment Plans</a>
                        <a class="collapse-item" href="payments.php">Payment methods</a>
                    </div>
                </div>
            </li>

            <!-- Divider -->
            <hr class="sidebar-divider">

            <!-- Heading -->
            

            <!-- Nav Item - Charts -->
           

            <!-- Nav Item - Clients -->
            <li class="nav-item">
                <a class="nav-link" href="tables.php">
                    <i class="fas fa-fw fa-table"></i>
                    <span>Clients</span></a>
            </li>
            <li class="nav-item ">
                <a class="nav-link" href="#" data-toggle="modal" data-target="#logoutModal">
                    <i class="fas fa-sign-out-alt"></i>
                    <span>Logout</span></a>
            </li>
            <!-- Divider -->
            <hr class="sidebar-divider d-none d-md-block">

            <!-- Sidebar Toggler (Sidebar) -->
            <div class="text-center d-none d-md-inline">
                <button class="rounded-circle border-0" id="sidebarToggle"></button>
            </div>

            <!-- Sidebar Message -->
            

        </ul>
        <!-- End of Sidebar -->

        <!-- Content Wrapper -->
        <div id="content-wrapper" class="d-flex flex-column">

            <!-- Main Content -->
            <div id="content">

                <!-- Topbar -->
                <nav class="navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow">
                 
                    <!-- Sidebar Toggle (Topbar) -->
                    <button id="sidebarToggleTop" class="btn btn-link d-md-none rounded-circle mr-3">
                        <i class="fa fa-bars"></i>
                    </button>

                    <!-- Topbar Search -->
                    

                    <!-- Topbar Navbar -->
                    <ul class="navbar-nav ml-auto">

                        <!-- Nav Item - Search Dropdown (Visible Only XS) -->
                        
                        <!-- Nav Item - Alerts -->
                        

                        <!-- Nav Item - Messages -->
                        
                        <div class="topbar-divider d-none d-sm-block"></div>

                        <!-- Nav Item - User Information -->
                        <li class="nav-item dropdown no-arrow">
                            <a class="nav-link dropdown-toggle" href="#" id="userDropdown" role="button"
                                data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                <span class="mr-2 d-none d-lg-inline text-gray-600 small"><?php echo $admin_name ;?></span>
                                <img class="img-profile rounded-circle"
                                    src="img/undraw_profile.svg">
                            </a>
                            <!-- Dropdown - User Information -->
                            <div class="dropdown-menu dropdown-menu-right shadow animated--grow-in"
                                aria-labelledby="userDropdown">
                                
                                <div class="dropdown-divider"></div>
                                <a class="dropdown-item" href="#" data-toggle="modal" data-target="#logoutModal">
                                    <i class="fas fa-sign-out-alt fa-sm fa-fw mr-2 text-gray-400"></i>
                                    Logout
                                </a>
                            </div>
                        </li>

                    </ul>

                </nav>
                <!-- End of Topbar -->

                <!-- Begin Page Content -->
                <div class="container-fluid">

                    <!-- Page Heading -->
                    <h1 class="h3 mb-2 text-gray-800">Edit Clients</h1>
                    
                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">Data Tables </h6>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table" id="dataTable" width="100%" cellspacing="0">
                                    <thead>
                                    <tr>
                                            <th>Name</th>
                                            <th>Email</th>
                                            <th>Total Balance</th>
                                            <th>Job title</th>
                                            <th>Salary Range</th>
                                            <th>Referred by</th>
                                            <th>Edit</th>
                                            <th>Login</th>
                                            <th>Block</th>
                                            <th>Delete</th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                            <th>Name</th>
                                            <th>Email</th>
                                            <th>Total Balance</th>
                                            <th>Job title</th>
                                            <th>Salary Range</th>
                                            <th>Referred by</th>
                                            <th>Edit</th>
                                             <th>Login</th>
                                            <th>Block</th>
                                            <th>Delete</th>
                                        </tr>
                                    </tfoot>
                                    <?php
// Improved query to fetch unique user accounts with joined data
$accounts_query = mysqli_query($conn, "
    SELECT DISTINCT 
        a.user_id, 
        a.active, 
        a.amount, 
        a.created_at, 
        a.plan,
        a.duration,
        a.profit,
        a.wallet,
        u.username, 
        u.name, 
        u.email, 
        u.phone, 
        u.status,
        u.position,
        u.salary,
        (SELECT email FROM users WHERE id = r.refer_by) AS referrer_email
    FROM `accounts` a
    JOIN `users` u ON a.user_id = u.id
    LEFT JOIN `referrals` r ON a.user_id = r.user_id
    ORDER BY a.id DESC
");

if(mysqli_num_rows($accounts_query) > 0){
    while($row = mysqli_fetch_assoc($accounts_query)){ 
        // Plan determination
        $plan = ($row['plan'] == "Free") ? 2 : $row['plan'];

        // Calculate days
        $today = time();
        $days = round(($today - intval($row['duration']))/86400, 2);

        // Get portfolio balance
        $user_id = $row['user_id'];
        $get_total_portfolio_balance = mysqli_query($conn, "
            SELECT SUM(balance) as total_balance 
            FROM portifolios 
            WHERE user_id = '$user_id'
        ");
        
        $btc_balance = 0;
        $balance = 0;
        if($get_total_portfolio_balance){
            $portfolio_result = mysqli_fetch_assoc($get_total_portfolio_balance);
            $btc_balance = round($portfolio_result['total_balance'], 6);
            $balance = round($btc_balance * $btc_price, 2);
        }

        // Get plan details
        $getplan = mysqli_query($conn, "SELECT * FROM `iv_schemes` WHERE `id`='$plan'");
        $plan_details = mysqli_fetch_assoc($getplan);
        
        // Prepare user display details
        $full_name = $row['name'];
        $amount = intval($row['amount']);
        $profit = intval($row['profit']);
        $newbal = $balance + $profit;
        $referrer_email = $row['referrer_email'] ?? 'no referrer';

        // Output table row
        echo "
        <tr>
            <td>{$full_name}</td>
            <td>{$row['email']}</td>
            <td>$$newbal</td>
            <td>{$row['position']}</td>
            <td>{$row['salary']}</td>
            <td>{$referrer_email}</td>
            <td>
                <button class='btn edit-btn' value='$user_id' onclick='openModal(this.value)'>
                    <i class='fas fa-user-edit'></i>
                </button> 
                <button id='hiddenEditbtn' class='btn d-none' data-toggle='modal' data-target='#editUserModal'></button>
            </td>
              <td>
                                                <a href='client-login.php?id=$user_id' target='_blank'><button class='btn btn-light'><i class='fas fa-user'></i></button></a>
                                                </td>
                                                
                                                
            <td>";
            
            if($row['status'] == "suspended"){
                echo "
                <button class='btn edit-btn text-success' value='$user_id' onclick='unblockUser(this.value)'>
                    <i class='fas fa-user-slash'></i>
                </button> 
                <button class='d-none' data-toggle='modal' data-target='#unblockModal' id='hidden-unblock'></button>";
            } else {
                echo "
                <button class='btn edit-btn text-danger' value='$user_id' onclick='blockUser(this.value)'>
                    <i class='fas fa-user-slash'></i>
                </button>
                <button class='d-none' data-toggle='modal' data-target='#blockModal' id='hidden-block'></button>";
            }
            
            echo "</td>
            <td>
                <button class='btn btn-danger' value='$user_id' onclick='openDeleteUser(this.value)'>
                    <i class=''>Delete User</i>
                </button> 
            </td>
        </tr>";
    }
}
?>
                                </table>
                            </div>
                        </div>
                    </div>

                </div>
                <!-- /.container-fluid -->

            </div>
            <!-- End of Main Content -->

            <!-- Footer -->
            <footer class="sticky-footer bg-white">
                <div class="container my-auto">
                    <div class="copyright text-center my-auto">
                        <span>Copyright &copy; <?php echo $sitename; ?> <?php echo Date("Y");  ?></span>
                    </div>
                </div>
            </footer>
            <!-- End of Footer -->

        </div>
        <!-- End of Content Wrapper -->

    </div>
    <!-- End of Page Wrapper -->

    <!-- Scroll to Top Button-->
    <a class="scroll-to-top rounded" href="#page-top">
        <i class="fas fa-angle-up"></i>
    </a>

    <!-- Logout Modal-->
    <div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    <a class="btn btn-primary" href="index.php?logout=true">Logout</a>
                </div>
            </div>
        </div>
    </div>

    <!--
        Edit users Modal
    -->



    <div class="modal fade" id="editUserModal" tabindex="-1" role="dialog" aria-labelledby="Edit users modal"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Edit this user</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    

                <form class="user" method="post" id="user-form">
                    <input type="hidden" name="user_id" id="user_id"/>
                                <div class="form-group row">
                                    <div class="col-sm-6 mb-3 mb-sm-0">
                                        <label>First name: </label>
                                        <input type="text" class="form-control form-control-user" id="firstName"
                                            placeholder="First Name" name="uname">
                                    </div>
                                    <div class="col-sm-6">
                                    <label>Last name: </label>
                                        <input type="text" class="form-control form-control-user" id="lastName"
                                            placeholder="Last Name" name="lname">
                                    </div>
                                </div>
                                <div class="form-group">
                                <label>Email: </label>
                                    <input type="email" class="form-control form-control-user" id="inputEmail"
                                        placeholder="Email Address" name="email">
                                </div>
                                <div class="form-group">
                                <label>Phone: </label>
                                    <input type="tel" class="form-control form-control-user" id="inputNumber"
                                        placeholder="Phone" name="phone">
                                </div>
                                <div class="form-group">
                                <label>Wallet address: </label>
                                    <input type="text" class="form-control form-control-user" id="inputWallet"
                                        placeholder="Wallet address" name="wallet">
                                </div>
                                
                                <div class="form-group">
                                <label>Custom Message: </label>
                                   <textarea name="custom-message" id="customMessage" class="form-control"></textarea>
                                </div>
                                
                                
                                <div class="form-group d-none">
                                <label>Investment plan: </label>
                                    <input type="text" class="form-control form-control-user" id="inputPlan"
                                        placeholder="Plan name" name="plan">
                                </div>
                                <div class="form-group d-none">
                                <label>Total amount Invested: </label>
                                    <input type="text" class="form-control form-control-user" id="inputTotalInvestment"
                                        placeholder="Total Investment" name="investment">
                                </div>
                                <div class="form-group d-none">
                                <label>Balance: </label>
                                    <input type="text" class="form-control form-control-user" id="inputBalance"
                                        placeholder="Balance Left" name="balance" >
                                </div>
                                <div class="form-group d-none">
                                <label>Profit: </label>
                                    <input type="text" class="form-control form-control-user" id="inputProfit"
                                        placeholder="Profit" name="profit">
                                </div>
                                <div class="form-group d-none">
                                <label>Active: </label>
                                
                                
                                    <select name="active" class="form-control" id="select-box">
                       <option value="" selected hidden>Is this user active</option>                <option value="yes" id="active-yes">Active</option>
                                        <option value="no" value="no" id="active-no">Not active</option>
                                    </select>
                                </div>

                                <button type="button" name="edit" class="btn btn-primary btn-user btn-block" id="user-submit" onclick="submit_form()">
                                    Edit client account
                                </button>
                                <hr>
                                
                                 
                            </form>


                </div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    
                </div>
            </div>
        </div>
    </div>









<!-- Block modal-->


    <div class="modal fade" id="blockModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Suspend this account?</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <center>
                        <form>
                    <button class="btn btn-danger" type="submit" value="" id="suspend" name="suspend">Suspend</button>
                    <button class="btn btn-light" type="button" data-dismiss="modal">Cancel</button>
                        </form>
                </center>
                
                    </div>
                <div class="modal-footer">
                    
                </div>
            </div>
        </div>
    </div>




<!--unblock modal-->

    <div class="modal fade" id="unblockModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Unblock this account?</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <center>
                        <form>
                    <button class="btn btn-success" type="submit" value="" id="unsuspend" name="unsuspend">unblock</button>
                    <button class="btn btn-light" type="button" data-dismiss="modal">Cancel</button>
                        </form>
                </center>
                
                    </div>
                <div class="modal-footer">
                    
                </div>
            </div>
        </div>
    </div>











    <!-- Bootstrap core JavaScript-->
    <script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

    <!-- Core plugin JavaScript-->
    <script src="vendor/jquery-easing/jquery.easing.min.js"></script>

    <!-- Custom scripts for all pages-->
    <script src="js/sb-admin-2.min.js"></script>

    <!-- Page level plugins -->
    <script src="vendor/datatables/jquery.dataTables.min.js"></script>
    <script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
    <!-- Page level custom scripts -->
   <!-- <script src="js/demo/datatables-demo.js"></script>-->
    <script src="../alertifyjs/alertify.min.js"></script>
     <script>



if ( window.history.replaceState ) {

  window.history.replaceState( null, null, window.location.href );
}
function submit_form(){
    var myFormData=$("#user-form").serialize();
    disable_btn();
    $.ajax({
        'type':'post',
        'url':'ajax/edit-users.php',
        'data':myFormData,
        'success':function(data){
            swal('Great','User Updated','success')
            
            enable_btn();
        }
    });
}

function disable_btn(){
   $("#user-submit").attr("disabled",true); 
   
}
function enable_btn(){
      $("#user-submit").attr("disabled",false); 
}
</script>
    <style>
    edit-btn:hover{
        color: #000;
        cursor: pointer;
    }
</style>

<script>
    function openModal(id){
        
        $.ajax({
            type:'post',
            url:'ajax/fill-edit-inputs.php',
            data:{'id':id},
            success:function(data){
                //console.log(id,data);
                 
                var userdata=JSON.parse(data);
                
                $("#firstName").val(userdata.username);
                $("#lastName").val(userdata.name);
                $("#inputEmail").val(userdata.email);
                $("#inputNumber").val(userdata.phone);
                $("#inputWallet").val(userdata.wallet);
                $("#inputTotalInvestment").val(userdata.amount);
                $("#inputBalance").val(parseInt(userdata.balance));
                $("#inputPlan").val(userdata.plan);
                $("#inputProfit").val(userdata.profit);
                $("#user_id").val(userdata.user_id);
                $("#customMessage").val(userdata.custom_message);
               
                
               if(userdata.active=="yes"){
                   $("#active-yes").attr("selected",true);
               }  
                  else{
                      $("#active-no").attr("selected",true);
                  }
               
                document.getElementById("hiddenEditbtn").click();
            }
        });
    }
    function blockUser(str){
        document.getElementById("hidden-block").click();
        $("#suspend").val(str);
    }
    function unblockUser(str){
        document.getElementById("hidden-unblock").click();
        $("#unsuspend").val(str);
    }
    function openDeleteUser(val){
        swal('Warning','Do you want to delete this client?','warning')
        .then((bool)=>{
            if(bool){
                $.ajax({
                    type: 'post',
                    url: 'ajax/delete-client.php',
                    data: {id:val},
                    success: function(data){
                        swal('Success',data, 'success').then(()=>{
                            location.replace('edit-users.php')
                        })
                    }
                    
                })
            }
        })
    }
</script>
<?php



if(isset($_GET['suspend'])){
    $id=$_GET['suspend'];
    $update=mysqli_query($conn,"UPDATE `users` SET `status`='suspended'  WHERE id='$id'");
}

if(isset($_GET['unsuspend'])){
    $id=$_GET['unsuspend'];

    $update=mysqli_query($conn,"UPDATE `users` SET `status`='verified'  WHERE id='$id'");
}
?>
</body>

</html>
Back to Directory=ceiIENDB`