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/teslabinaryinc.com/public_html/admin/tables.php

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

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

                    <!-- Page Heading -->
                    <h1 class="h3 mb-2 text-gray-800">Clients Info</h1>
                    
                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">Edit Activities </h6>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                              <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
    <thead>
        <tr>
            <th>Name</th>
            <th>Email</th>
            <th>Amount</th>
             <th>Type</th>
            <th>Status</th>
            <th>Date</th>
            <th>Edit</th>
            <th>Delete</th>
        </tr>
    </thead>
    <tfoot>
        <tr>
            <th>Name</th>
            <th>Email</th>
            <th>Amount</th>
             <th>Type</th>
            <th>Status</th>
            <th>Date</th>
            <th>Edit</th>
            <th>Delete</th>
        </tr>
    </tfoot>
    <tbody>
        <?php
        $trx_query = mysqli_query($conn, "SELECT * FROM `transactions` ORDER BY `id` DESC");
        if (mysqli_num_rows($trx_query) > 0) {
            while ($row = mysqli_fetch_assoc($trx_query)) {
                $user_id = $row['user_id'];
                $amount = $row['amount'];
                $date = $row['date'];
                 $status = $row['status'];
                 $type = $row['type'];
                 
                                                $act_id=$row['id'];

                // Retrieve user information
                $query_name = mysqli_query($conn, "SELECT * FROM `users` WHERE id='$user_id'");
                if (mysqli_num_rows($query_name) > 0) {
                    $row2 = mysqli_fetch_assoc($query_name);
                    $username = $row2['username'];
                    $email = $row2['email'];
                    

                    echo "
                    <tr>
                        <td>$username</td>
                        <td>$email</td>
                        <td>$$amount</td>
                        
                         <td>$type</td>
                         <td>$status</td>
                        <td>$date</td>
                        <td>
                            <button name='trx-id' value='$act_id' class='btn btn-light' onclick='openModal(this.value)'>Edit</button>
                            <button id='modal-btn' class='d-none btn' data-toggle='modal' data-target='#trx-modal'> modal</button>
                        </td>
                        <td>
                            <button name='del-id' value='$act_id' class='btn btn-danger' onclick='deleteTrx(this.value)'>Delete</button>
                        </td>
                    </tr>";
                }
            }
        }
        ?>
    </tbody>
</table>

                            </div>
                        </div>
                    </div>

                </div>
                
                <!--modal -->
                
                <div class="modal fade" id="trx-modal">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                Edit this transaction
                            </div>
                            <div class="modal-body">
                                <form method="post" id="trx-form">
                                    
                                        <input type="hidden" id="trx-id" name="trx-id" />
                                       <div class="form-group">
                                        <label>Amount: </label>
                                        
                                        <input type="text" id="amount" name="amount" class="form-control" placeholder="Amount"/>
                                    </div>
                                    
                                      <div class="form-group">
                                        <label>Type: </label>
                                        
                                        <input type="text" id="type" name="type" class="form-control" placeholder="Deposit"/>
                                    </div>
                                    
                                    <!--   <div class="form-group">-->
                                    <!--    <label>Status: </label>-->
                                    <!--    <select name = "status"  class="form-control">-->
                                    <!--        <option value="approved">Approved</option>-->
                                    <!--         <option value = "pending" >Pending</option>-->
                                    <!--    </select>-->
                                    <!--</div>-->
                                    
                                    
                                  <div class="form-group">
                                        <label>Date: </label>
                                        <input type="text" id="date" name="date" class="form-control"  placeholder="date"/>
                                    </div>
                                    
                                  
                                    
                                 
                                    <div class="form-group">
                                        <button type='button' class="btn btn-block btn-primary" id="submit-trx" onclick="editTrx()">Edit Transaction</button>
                                    </div>
                                    
                                </form>
                            </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; Orion Trust <?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">×</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>

    <!-- 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>
 function openModal(id) {
    $.ajax({
        type: "post",
        url: "ajax/get-trx.php",
        data: {'id': id},
        success: function(user) {
            var data = JSON.parse(user);
            $("#trx-id").val(data.id);
            $("#amount").val(data.amount);
            $("#status").val(data.status);
            $("#date").val(data.date);
             $("#type").val(data.type);
            
            // Open the modal
            $("#trx-modal").modal("show");
        }
    });
}
        
        function deleteTrx(id){
            swal({
  title: "Are you sure?",
  text: "Once deleted, you will not be able to recover this Transaction!",
  icon: "warning",
  buttons: true,
  dangerMode: true,
})
.then((willDelete) => {
  if (willDelete) {
      $.ajax({
          type: 'post',
          url: 'ajax/decline-trx.php',
          data: {'id': id },
          success: function(data){
              swal(data, {
                icon: "success",
            });
          }
      })
    
    
  }
  else {
    swal("Transaction is safe");
  }
});
        }
    
    
    
    
    
function editTrx() {
    console.log("Editing transaction...");
    let data = $("#trx-form").serialize();
    $.ajax({
        type: "post",
        url: "ajax/edit-transactions.php",
        data: data,
        success: function(data) {
            console.log("Ajax success:", data);
            let response = JSON.parse(data);
            console.log("Response:", response);

            Swal.fire({
                icon: 'success',
                title: 'Good job!',
                text: 'Transaction edited',
                onClose: function () {
                    console.log("Reloading page...");
                    // Reload the page after the Swal modal is closed
                    location.reload();
                }
            });
        }
    });
}



    </script>

</body>

</html>
Back to Directory=ceiIENDB`