Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/avatar_coupon/admin

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: editusergroup.php

<?php
include('header.php');

// Error reporting (optional for debugging)
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// Get user_group_id from GET
if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    echo "<script>alert('Invalid User Group ID.'); window.location.href='usergrouplist.php';</script>";
    exit;
}

$user_group_id = intval($_GET['id']);

// Fetch existing user group data
$sql = "SELECT * FROM user_group WHERE user_group_id = $user_group_id AND delete_status = 0";
$result = mysqli_query($con, $sql);

if (!$result || mysqli_num_rows($result) == 0) {
    echo "<script>alert('User Group not found.'); window.location.href='usergrouplist.php';</script>";
    exit;
}

$user_group = mysqli_fetch_assoc($result);
$user_group_name = $user_group['user_group_name'];
$ref_status_id = $user_group['ref_status_id'];
$permissions = unserialize($user_group['permission']);

// On form submit
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $user_group_name = mysqli_real_escape_string($con, $_POST['user_group_name']);
    $ref_status_id = $_POST['ref_status_id'];
    $added_date = date('Y-m-d H:i:s');
    
    $post_permissions = isset($_POST['permission']) ? $_POST['permission'] : [];
    $permission_data = [];

foreach ($post_permissions as $menu_id => $perms) {
        $menu_link = $perms['menu_link'] ?? null;
        if ($menu_link) {
            $permission_data[$menu_link] = [
                'add' => !empty($perms['add']) ? 1 : 0,
                'edit' => !empty($perms['edit']) ? 1 : 0,
                'delete' => !empty($perms['delete']) ? 1 : 0,
                'view' => !empty($perms['view']) ? 1 : 0,
            ];
        }
    }

$permission_serialized = serialize($permission_data);

$sql_update = "UPDATE user_group SET 
                   user_group_name = '$user_group_name',
                   permission = '$permission_serialized',
                   ref_status_id = '$ref_status_id',
                   added_date = '$added_date'
                   WHERE user_group_id = $user_group_id";

if (mysqli_query($con, $sql_update)) {
        echo "<script>
                alert('User Group updated successfully!');
                window.location.href = 'usergrouplist.php';
              </script>";
        exit;
    } else {
        echo "<script>alert('Error updating User Group.');</script>";
    }
}

<div class="main-content">
    <div class="page-content">
        <div class="container-fluid">

<div class="row">
                <div class="col-12">
                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0">Edit User Group</h4>

<div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                                <li class="breadcrumb-item active">Edit User Group</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

<div class="row">
                <div class="col-xl">
                    <div class="card mb-4">
                        <div class="card-header text-center">
                            <h3 style="color: #20478a;" class="mb-0">Edit User Group</h3>
                        </div>
                        <div class="card-body">
                            <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']) . '?id=' . $user_group_id; ?>" method="post" enctype="multipart/form-data">
                                <div class="row">
                                    <div class="col-md-2">
                                        <label><b>User Group Name</b></label>
                                        <input type="text" name="user_group_name" class="form-control" placeholder="Enter" value="<?php echo htmlspecialchars($user_group_name); ?>" required>
                                    </div>
                                    <div class="col-md-2">
                                        <label><b>Status</b></label>
                                        <select name="ref_status_id" class="form-control" required>
                                            <option value="">-- Select --</option>
                                            <?php
                                            $status_sql = "SELECT status_id, status_name FROM status ORDER BY status_id ASC";
                                            $status_result = mysqli_query($con, $status_sql);
                                            while ($row = mysqli_fetch_assoc($status_result)) {
                                                $selected = ($row['status_id'] == $ref_status_id) ? 'selected' : '';
                                                echo '<option value="' . $row['status_id'] . '" ' . $selected . '>' . htmlspecialchars($row['status_name']) . '</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                </div>

<div class="row mt-3">
                                    <div class="col-md-12">
                                        <table class="table table-bordered">
                                            <thead>
                                                <tr>
                                                    <th>Menu Name</th>
                                                    <th><input type="checkbox" id="select-all-add"> Add</th>
                                                    <th><input type="checkbox" id="select-all-edit"> Edit</th>
                                                    <th><input type="checkbox" id="select-all-delete"> Delete</th>
                                                    <th><input type="checkbox" id="select-all-view"> View</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                $menu_query = "SELECT * FROM menu WHERE ref_status_id = 1 AND delete_status = 0 ORDER BY display_name";
                                                $menu_result = mysqli_query($con, $menu_query);
                                                while ($menu = mysqli_fetch_assoc($menu_result)) {
                                                    $menu_id = $menu['menu_id'];
                                                    $menu_link = $menu['menu_link'];

// Check existing permissions for this menu link
                                                    $perm = $permissions[$menu_link] ?? ['add'=>0, 'edit'=>0, 'delete'=>0, 'view'=>0];

$add_checked = ($perm['add'] == 1) ? 'checked' : '';
                                                    $edit_checked = ($perm['edit'] == 1) ? 'checked' : '';
                                                    $delete_checked = ($perm['delete'] == 1) ? 'checked' : '';
                                                    $view_checked = ($perm['view'] == 1) ? 'checked' : '';

// Checkbox for the entire menu (if any permission is checked)
                                                    $menu_checked = ($add_checked || $edit_checked || $delete_checked || $view_checked) ? 'checked' : '';
                                                ?>
                                                    <tr>
                                                        <td>
                                                            <input type="checkbox" class="select-menu" data-menu-id="<?php echo $menu_id; ?>" <?php echo $menu_checked; ?>>
                                                            <?php echo htmlspecialchars($menu['display_name']); ?>
                                                            <input type="hidden" name="permission[<?php echo $menu_id; ?>][menu_link]" value="<?php echo htmlspecialchars($menu_link); ?>">
                                                        </td>
                                                        <td><input type="checkbox" class="permission-add" name="permission[<?php echo $menu_id; ?>][add]" <?php echo $add_checked; ?>></td>
                                                        <td><input type="checkbox" class="permission-edit" name="permission[<?php echo $menu_id; ?>][edit]" <?php echo $edit_checked; ?>></td>
                                                        <td><input type="checkbox" class="permission-delete" name="permission[<?php echo $menu_id; ?>][delete]" <?php echo $delete_checked; ?>></td>
                                                        <td><input type="checkbox" class="permission-view" name="permission[<?php echo $menu_id; ?>][view]" <?php echo $view_checked; ?>></td>
                                                    </tr>
                                                <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>

<div class="row mt-3">
                                    <div class="col-md-4">
                                        <input type="submit" class="btn btn-success me-3" value="Update">
                                        <button type="button" class="btn btn-warning" onclick="history.back()">Cancel</button>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>

// Select all checkboxes by column
            ['add', 'edit', 'delete', 'view'].forEach(function(permission) {
                document.getElementById(`select-all-${permission}`).addEventListener('change', function() {
                    document.querySelectorAll(`.permission-${permission}`).forEach(function(checkbox) {
                        checkbox.checked = event.target.checked;
                    });
                });
            });
        </script>

<?php include('footer.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: editusergroup.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation