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/rocketstockcapital.com/public_html/admin/experts.php

<?php
include "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>Minimum</th>
                                            <th>Duration</th>
                                            <th>ROI</th>
                                            <th>Investors</th>
                                            <th>Active</th>
                                            <th>Risk</th>
                                            <th>Rate</th>
                                            <th>Edit</th>
                                            <th>Delete</th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                            <th>Name</th>
                                            <th>Minimum</th>
                                            <th>Duration</th>
                                            <th>ROI</th>
                                            <th>Investors</th>
                                            <th>Active</th>
                                            <th>Risk</th>
                                            <th>Rate</th>
                                            <th>Edit</th>
                                            <th>Delete</th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
                                    <?php
$accounts_query = mysqli_query($conn, "SELECT * FROM `experts` ORDER BY `id` DESC");

if (mysqli_num_rows($accounts_query) > 0) {
    while ($row = mysqli_fetch_assoc($accounts_query)) {
        // Retrieve columns from the experts table
        $user_id = $row['id']; // Get the user ID
        $name = $row['name'];
        $min = $row['min'];
        $duration = $row['duration'];
        $roi = $row['roi'];
        $investors = $row['investors'];
        $active = $row['active'];
        $risk = $row['risk'];
        $rate = $row['rate'];

        // Display the table row with the selected columns
        echo "
            <tr>
                <td>$name</td>
                <td>$min</td>
                <td>$duration</td>
                <td>$roi</td>
                <td>$investors</td>
                <td>$active</td>
                <td>$risk</td>
                <td>$rate</td>
                <td>
                    <button class='btn btn-primary' value='$user_id' data-toggle='modal' data-target='#edit-expert-$user_id'>
                        <i class=''>Edit</i>
                    </button>
                </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>
                
             <?php   
                $accounts_query = mysqli_query($conn, "SELECT * FROM `experts` ORDER BY `id` DESC");

if (mysqli_num_rows($accounts_query) > 0) {
    while ($row = mysqli_fetch_assoc($accounts_query)) {
        $user_id = $row['id']; // Get the user ID
        $name = $row['name'];
        $min = $row['min'];
        $duration = $row['duration'];
        $roi = $row['roi'];
        $investors = $row['investors'];
        $active = $row['active'];
        $risk = $row['risk'];
        $rate = $row['rate'];
        ?>
        
        <div class="modal fade" id="edit-expert-<?php echo $user_id; ?>">
            <div class="modal-dialog modal-dialog-centered">
                <div class="modal-content">
                    <div class="modal-header">
                        <h3>Edit Expert</h3>
                        <button class="btn btn-close" data-dismiss="modal">&times;</button>
                    </div>
                    <div class="modal-body">
                        <form method="post">
                            <div class="form-group my-2">
                                <label class="form-label">
                                    Name of Expert
                                </label>
                                <input type="hidden" name="id" id="id" value="<?php echo $user_id; ?>" class="form-control"/>
                                <input type="text" name="name" id="name" value="<?php echo $name; ?>" class="form-control"/>
                            </div>
                            
                            <div class="form-group my-2">
                                <label class="form-label">
                                    Min
                                </label>
                                
                                <input type="text" name="min" id="min" value="<?php echo $min; ?>" class="form-control"/>
                            </div>
                            
                            
                            <div class="form-group my-2">
                                <label class="form-label">
                                    Duration
                                </label>
                                
                                <input type="text" name="duration" id="duration" value="<?php echo $duration; ?>" class="form-control"/>
                            </div>
                            
                            <div class="form-group my-2">
                                <label class="form-label">
                                    ROI
                                </label>
                                
                                <input type="text" name="roi" id="roi" value="<?php echo $roi; ?>" class="form-control"/>
                            </div>
                            
                            
                            <div class="form-group my-2">
                                <label class="form-label">
                                    Investors
                                </label>
                                
                                <input type="text" name="investors" id="investors" value="<?php echo $investors; ?>" class="form-control"/>
                            </div>
                            
                            <div class="form-group my-2">
                                <label class="form-label">
                                    Active
                                </label>
                                
                                <input type="text" name="active" id="active" value="<?php echo $active; ?>" class="form-control"/>
                            </div>
                            
                            <div class="form-group my-2">
                                <label class="form-label">
                                    Risk
                                </label>
                                
                                <input type="text" name="risk" id="risk" value="<?php echo $risk; ?>" class="form-control"/>
                            </div>
                            
                            <div class="form-group my-2">
                                <label class="form-label">
                                    Rate
                                </label>
                                
                                <input type="text" name="rate" id="rate" value="<?php echo $rate; ?>" class="form-control"/>
                            </div>
                            
                            
                            <div class="form-group my-2">
                                <button class="btn btn-primary" name="edit-expert">
                                    Edit Expert
                                </button>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
        
        <?php
        
    }
}
        
        
        
        
        ?>
        
        <?php
        if(isset($_POST['edit-expert'])){
            $id = mysqli_real_escape_string($conn, $_POST['id']);
            $name = mysqli_real_escape_string($conn, $_POST['name']);
            $min = mysqli_real_escape_string($conn, $_POST['min']);
            $duration = mysqli_real_escape_string($conn, $_POST['duration']);
            $roi = mysqli_real_escape_string($conn, $_POST['roi']);
            $investors = mysqli_real_escape_string($conn, $_POST['investors']);
            $active = mysqli_real_escape_string($conn, $_POST['active']);
            $risk = mysqli_real_escape_string($conn, $_POST['risk']);
            $rate = mysqli_real_escape_string($conn, $_POST['rate']);
            
            
            $update = mysqli_query($conn, "UPDATE experts SET name='$name', min='$min', duration='$duration', roi='$roi', investors='$investors', active='$active', risk='$risk', rate='$rate' WHERE id='$id'");
            
            if($update){
                ?>
                <script>
                    swal('Great','Expert Updated','success')
                    .then(()=>{
                        location.replace('experts')
                    })
                </script>
                <?php
            }
            
        }
        
        ?>
                <!-- /.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="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){
            alertify.alert(data);
            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);
               
                
               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('experts.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`