:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/tdrbazaar.com/crm/**
:: Editing File: check.php
<?php include "header.php"; ?> <div class="page-wrapper"> <div class="content pb-0"> <?php $count_q = mysqli_query($conn, "SELECT COUNT(*) AS total FROM admin_tbl"); $count_r = mysqli_fetch_assoc($count_q); $total_admin = $count_r['total']; ?> <div class="d-flex align-items-center justify-content-between gap-2 mb-4 flex-wrap"> <div> <h4 class="mb-1">Admin Users<span class="badge badge-soft-primary ms-2"><?php echo $total_admin; ?></span></h4> <nav aria-label="breadcrumb"> <ol class="breadcrumb mb-0 p-0"> <li class="breadcrumb-item"><a href="index.php">Home</a></li> <li class="breadcrumb-item active" aria-current="page">Manage Users</li> </ol> </nav> </div> <div class="gap-2 d-flex align-items-center flex-wrap"> <div class="dropdown"> <a href="javascript:void(0);" class="dropdown-toggle btn btn-outline-light px-2 shadow" data-bs-toggle="dropdown"> <i class="ti ti-package-export me-2"></i>Export </a> <div class="dropdown-menu dropdown-menu-end"> <ul> <li><a href="#" id="exportPdf" class="dropdown-item"><i class="ti ti-file-type-pdf me-1"></i>Export as PDF</a></li> <li><a href="#" id="exportExcel" class="dropdown-item"><i class="ti ti-file-type-xls me-1"></i>Export as Excel</a></li> <li><a href="#" id="exportCsv" class="dropdown-item"><i class="ti ti-file-type-csv me-1"></i>Export as CSV</a></li> <li><a href="#" id="exportPrint" class="dropdown-item"><i class="ti ti-printer me-1"></i>Print Table</a></li> </ul> </div> </div> <a href="javascript:void(0);" class="btn btn-icon btn-outline-light shadow" data-bs-toggle="tooltip" title="Refresh" onclick="window.location.reload();"><i class="ti ti-refresh"></i></a> </div> </div> <div class="card border-0 rounded-0 shadow-sm"> <div class="card-header d-flex align-items-center justify-content-between gap-2 flex-wrap"> <div class="input-icon input-icon-start position-relative"> <span class="input-icon-addon text-dark"><i class="ti ti-search"></i></span> <input type="text" id="customSearchInput" class="form-control" placeholder="Search Admin..."> </div> <a href="javascript:void(0);" class="btn btn-primary" data-bs-toggle="offcanvas" data-bs-target="#offcanvas_add"> <i class="ti ti-square-rounded-plus-filled me-1"></i>Add User </a> </div> <div class="card-body"> <div class="table-responsive"> <table id="manage-users-list" class="table table-hover align-middle nowrap" style="width:100%"> <thead class="table-light"> <tr> <th style="width: 50px;">Photo</th> <th>Name</th> <th>Phone</th> <th>Email</th> <th>Created</th> <th>Status</th> <th class="text-center" style="width: 100px;">Action</th> </tr> </thead> <tbody> <?php $query = mysqli_query($conn, "SELECT * FROM admin_tbl ORDER BY id DESC"); if(mysqli_num_rows($query) > 0) { while($row = mysqli_fetch_assoc($query)) { $pic = !empty($row['pic']) ? "assets/img/users/".$row['pic'] : "assets/img/users/user-01.jpg"; $formatted_date = date("d M Y", strtotime($row['created_at'])); $status_class = (strtolower($row['status']) == 'active') ? 'badge bg-success' : 'badge bg-danger'; ?> <tr> <td> <span class="avatar avatar-md rounded-circle"> <img src="<?php echo $pic; ?>" class="rounded-circle" alt="img" width="40" height="40" style="object-fit:cover;"> </span> </td> <td><strong><?php echo htmlspecialchars($row['username']); ?></strong></td> <td><?php echo htmlspecialchars($row['mobile'] ?? 'N/A'); ?></td> <td><?php echo htmlspecialchars($row['email']); ?></td> <td><?php echo $formatted_date; ?></td> <td><span class="<?php echo $status_class; ?>"><?php echo ucfirst($row['status']); ?></span></td> <td class="text-center"> <div class="d-flex justify-content-center gap-2"> <a href="javascript:void(0);" class="btn btn-sm btn-icon btn-outline-primary" data-bs-toggle="offcanvas" data-bs-target="#offcanvas_edit"> <i class="ti ti-edit"></i> </a> <a href="javascript:void(0);" class="btn btn-sm btn-icon btn-outline-danger" data-bs-toggle="modal" data-bs-target="#delete_contact"> <i class="ti ti-trash"></i> </a> </div> </td> </tr> <?php } } else { echo "<tr><td colspan='7' class='text-center'>No records found.</td></tr>"; } ?> </tbody> </table> </div> </div> </div> <footer class="footer d-block d-md-flex justify-content-between text-md-start text-center mt-4"> <p class="mb-md-0 mb-1">Copyright © <script>document.write(new Date().getFullYear())</script> - <a href="dashboard.php" style="color:#1a568f">TDR BAZAAR CRM </a> | Designed & Developed By - <a href="https://kreativepixelz.com/" target="_blank" style="color:#1a568f">Kreative Pixelz</a> </p> <div class="d-flex align-items-center gap-2 footer-links justify-content-center justify-content-md-end"> <a href="http://tdrbazaar.com/about.php" target='_blank'>About</a> | <a href="http://tdrbazaar.com/contact.php" target='_blank'>Contact Us</a> </div> </footer> </div> </div> <div class="offcanvas offcanvas-end offcanvas-large" tabindex="-1" id="offcanvas_add"></div> <div class="offcanvas offcanvas-end offcanvas-large" tabindex="-1" id="offcanvas_edit"></div> <div class="modal fade" id="delete_contact"></div> <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.2/css/buttons.dataTables.min.css"> <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script> <script src="https://cdn.datatables.net/1.13.8/js/jquery.dataTables.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.4.2/js/dataTables.buttons.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script> <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.html5.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.print.min.js"></script> <script> $(document).ready(function() { // 1. Initialize the DataTable with custom hidden buttons var table = $('#manage-users-list').DataTable({ responsive: true, processing: true, pageLength: 10, order: [[4, 'desc']], dom: 'rtip', columnDefs: [ { targets: [0, 6], orderable: false } // Disable sorting for Photo and Action columns ], buttons: [ { extend: 'csv', className: 'btn-export-csv d-none', exportOptions: { columns: [1, 2, 3, 4, 5] } // Exports Name, Phone, Email, Created, Status }, { extend: 'excel', className: 'btn-export-excel d-none', exportOptions: { columns: [1, 2, 3, 4, 5] } }, { extend: 'pdf', className: 'btn-export-pdf d-none', orientation: 'portrait', pageSize: 'A4', exportOptions: { columns: [1, 2, 3, 4, 5] } }, { extend: 'print', className: 'btn-export-print d-none', exportOptions: { columns: [1, 2, 3, 4, 5] } } ] }); // 2. Custom Search Implementation $('#customSearchInput').on('keyup', function() { table.search(this.value).draw(); }); // 3. Clean routing triggers for UI Dropdown Items $('#exportCsv').on('click', function(e) { e.preventDefault(); table.button('.btn-export-csv').trigger(); }); $('#exportExcel').on('click', function(e) { e.preventDefault(); table.button('.btn-export-excel').trigger(); }); $('#exportPdf').on('click', function(e) { e.preventDefault(); table.button('.btn-export-pdf').trigger(); }); $('#exportPrint').on('click', function(e) { e.preventDefault(); table.button('.btn-export-print').trigger(); }); }); </script> <?php include "footer.php"; ?>