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/advisorye.com/public_html/admin/edit-users.php

<?php
require "header.php";
?>

        <!-- 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>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>Edit</th>
                                             <th>Login</th>
                                            <th>Block</th>
                                            <th>Delete</th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
                                        <?php
                                        $accounts_query=mysqli_query($conn,"SELECT * FROM `users` WHERE role!='admin' ORDER BY `id` DESC");
                                        if(mysqli_num_rows($accounts_query)>0){
                                            while($row=mysqli_fetch_assoc($accounts_query)){ 
                                                
                                                
                                                $user_id=$row['id'];
                                              

                                                   
                                                    $username=$row['username'];
                                                    $name=$row['name'];
                                                    $full_name=$name;
                                                    $email=$row['email'];
                                                    $phone=$row['phone'];
                                                    $status=$row['status'];
                                                    $position=$row['position'];
                                                    $salary=$row['salary'];
                                                    $balance=$row['balance'];
                                                    
                                                 
                                                
                                                 
                                              
                                                echo "
                                                <tr >
                                                
                                                <td>$full_name</td>
                                                <td>$email</td>
                                                <td>$$balance</td>
                                                <td>$position</td>
                                                <td>$salary</td>
                                                
                                                
                       
                                               
                                                <td>
                                                <button class='btn edit-btn' value='$user_id' data-toggle='modal' data-target='#editUserModal-$user_id'>
                                                <i class='fas fa-user-edit'></i>
                                                </button> 
                                                <button id='hiddenEditbtn' class='btn d-none' ></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($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>
                                                ";
                                            }
                                        }
                                        
                                        ?>
                                    </tbody>
                                </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
    -->


<?php
    
     $accounts_query=mysqli_query($conn,"SELECT * FROM `users` WHERE role!='admin' ORDER BY `id` DESC");
        if(mysqli_num_rows($accounts_query)>0){
            while($row=mysqli_fetch_assoc($accounts_query)){ 
                
                
                $user_id=$row['id'];
              

                   
                    $username=$row['username'];
                    $name=$row['name'];
                    $full_name=$name;
                    $email=$row['email'];
                    $phone=$row['phone'];
                    $status=$row['status'];
                    $position=$row['position'];
                    $salary=$row['salary'];
                       $balance=$row['balance'];                             
                                                 
                                                
    
?>
    <div class="modal fade" id="editUserModal-<?php echo $user_id; ?>" 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">
                                         <input type="text" class="form-control form-control-user" id="firstName"
                                            placeholder="First Name" name="id" value="<?php echo $user_id; ?>">
                                        <label>First name: </label>
                                        <input type="text" class="form-control form-control-user" id="firstName"
                                            placeholder="First Name" name="uname" value="<?php echo $username; ?>">
                                    </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" value="<?php echo $full_name; ?>">
                                    </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" value="<?php echo $email; ?>">
                                </div>
                                <div class="form-group">
                                <label>Phone: </label>
                                    <input type="tel" class="form-control form-control-user" id="inputNumber"
                                        placeholder="Phone" name="phone" value="<?php echo $phone; ?>">
                                </div>
                                 
                                <div class="form-group">
                                <label>Balance: </label>
                                    <input type="text" class="form-control form-control-user" id="inputBalance"
                                        placeholder="Balance Left" name="balance" value="<?php echo $balance; ?>" >
                                </div>
                                
                                

                                <button type="submit" name="submit" class="btn btn-primary btn-user btn-block" id="user-submit">
                                    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>


<?php

}
}
?>



<!-- 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>
    

<?php
if(isset($_POST['submit'])){
    $username=mysqli_real_escape_string($conn, $_POST['uname']);
    $name=mysqli_real_escape_string($conn, $_POST['lname']);
    $email=mysqli_real_escape_string($conn, $_POST['email']);
    $balance=mysqli_real_escape_string($conn, $_POST['balance']);
    $phone=mysqli_real_escape_string($conn, $_POST['phone']);
    $id=mysqli_real_escape_string($conn, $_POST['id']);
    
    $update=mysqli_query($conn, "UPDATE users SET username='$username', email='$email', balance='$balance', phone='$phone', name='$name' WHERE id='$id'");
    
    if($update){
        ?>
        <script>
            swal('great','Client updated','success')
            .then(()=>{
                location.replace('edit-users.php')
            })
        </script>
        <?php
    }
}
?>

    <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);
               
                
               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`