Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/admin

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: manage_accessories.php

<?php
include '../db.php';

$message = '';

// Pagination Setup
$limit = 10;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;

// Filter Inputs
$search = isset($_GET['search']) ? trim($_GET['search']) : '';
$category_filter = isset($_GET['category']) ? (int)$_GET['category'] : 0;
$brand_filter = isset($_GET['brand']) ? (int)$_GET['brand'] : 0;
$series_filter = isset($_GET['series']) ? (int)$_GET['series'] : 0;

// Build WHERE Clause
$where_clauses = [];
if ($search) {
    $search_safe = $conn->real_escape_string($search);
    $where_clauses[] = "p.name LIKE '%$search_safe%'";
}
if ($category_filter) {
    // Only apply the category filter if it's within the accessories branch, to avoid conflicts with Category 1 (Mobile Phone)
    $accessoires_cat_id = 4;
    $valid_cat_ids = [(int)$accessoires_cat_id];
    
    // We can define the function if not exists
    if (!function_exists('getAllChildCategories')) {
        function getAllChildCategories($conn, $parent_id) {
            $children = [];
            $sql = "SELECT id FROM categories WHERE parent_id = " . (int)$parent_id;
            $result = $conn->query($sql);
            if ($result && $result->num_rows > 0) {
                while($row = $result->fetch_assoc()) {
                    $children[] = $row['id'];
                    $children = array_merge($children, getAllChildCategories($conn, $row['id']));
                }
            }
            return $children;
        }
    }
    
    $child_ids = getAllChildCategories($conn, $accessoires_cat_id);
    $valid_cat_ids = array_merge($valid_cat_ids, $child_ids);
    
    // Check if the selected filter is an accessory category
    if (in_array($category_filter, $valid_cat_ids)) {
        $selected_cat_ids = [(int)$category_filter];
        $selected_child_ids = getAllChildCategories($conn, $category_filter);
        $selected_cat_ids = array_merge($selected_cat_ids, $selected_child_ids);
        
        $cat_ids_str = implode(',', $selected_cat_ids);
        $where_clauses[] = "p.category_id IN ($cat_ids_str)";
    }
}
if ($brand_filter) {
    $where_clauses[] = "p.brand_id = $brand_filter";
}
if ($series_filter) {
    $where_clauses[] = "p.series_id = $series_filter";
}

// Function to get all child category IDs (recursive)
if (!function_exists('getAllChildCategories')) {
    function getAllChildCategories($conn, $parent_id) {
        $children = [];
        $sql = "SELECT id FROM categories WHERE parent_id = " . (int)$parent_id;
        $result = $conn->query($sql);
        if ($result && $result->num_rows > 0) {
            while($row = $result->fetch_assoc()) {
                $children[] = $row['id'];
                // Merge grandchildren
                $children = array_merge($children, getAllChildCategories($conn, $row['id']));
            }
        }
        return $children;
    }
}

// FORCE FILTER: Only Category 4 and its children
$accessoires_cat_id = 4;
$valid_cat_ids = [(int)$accessoires_cat_id];
$child_ids = getAllChildCategories($conn, $accessoires_cat_id);
$valid_cat_ids = array_merge($valid_cat_ids, $child_ids);
$valid_cat_ids_str = implode(',', $valid_cat_ids);

// Append strict category filter
$where_clauses[] = "p.category_id IN ($valid_cat_ids_str)";

// If user selects a specific category filter, ensure it's within our valid list
if ($category_filter) {
    if (in_array($category_filter, $valid_cat_ids)) {
         // The user selected a valid subcategory, so we can be more specific
         // But wait, the standard logic above (lines 23-47) was essentially expanding the user selection.
         // We need to disable the standard logic if it conflicts or restructure it.
         // Actually, let's keep it simple: Intersection is safer, but "User Filter" overrides the "Global Filter" usually in UI 
         // but here Global Filter is a constraint.
         // So: "Where Category IN (GlobalSet) AND Category IN (UserSelectionExpanded)"
         // The existing logic at lines 23-47 adds "p.category_id IN (...)" to $where_clauses.
         // My new line above also adds "p.category_id IN (...)".
         // SQL will require BOTH to be true. 
         // If user selects a valid sub-cat, both are true. 
         // If user selects ID 99 (not valid), (ID IN (4,...) AND ID IN (99)) => Empty result. Correct.
         // So I can just leave the user filter logic as is, it simply adds another AND condition.
    } 
}

$where_sql = "";
if (count($where_clauses) > 0) {
    $where_sql = "WHERE " . implode(' AND ', $where_clauses);
}

// Fetch Total Count for Pagination
$count_sql = "SELECT COUNT(*) as total FROM products p LEFT JOIN brands b ON p.brand_id = b.id $where_sql";
$count_result = $conn->query($count_sql);
$total_rows = $count_result->fetch_assoc()['total'];
$total_pages = ceil($total_rows / $limit);

// Fetch Products with Filters and Pagination
$sql = "SELECT p.id, p.name, p.image, p.price, p.created_at, p.stock_status, 
               b.name as brand_name, b.brand_type, c.name as category_name, s.name as series_name 
        FROM products p 
        LEFT JOIN brands b ON p.brand_id = b.id 
        LEFT JOIN categories c ON p.category_id = c.id 
        LEFT JOIN series s ON p.series_id = s.id 
        $where_sql 
        ORDER BY p.id DESC 
        LIMIT $limit OFFSET $offset";
       // echo $sql;
$result = $conn->query($sql);

// Fetch Brands and Categories for Filter Dropdowns
// Filter brands for dropdown
$brands_sql = "SELECT id, name FROM brands WHERE brand_type IN ('Accessories', 'All') ORDER BY name";
$brands_result = $conn->query($brands_sql);

$categories_sql = "SELECT id, name FROM categories WHERE id <> 1 ORDER BY name";

$categories_result = $conn->query($categories_sql);

$series_conditions = [];
if ($brand_filter) $series_conditions[] = "brand_id = " . (int)$brand_filter;
if ($category_filter) $series_conditions[] = "category_id = " . (int)$category_filter;
$series_sql = "SELECT id, name FROM series ";
if (!empty($series_conditions)) {
    $series_sql .= "WHERE " . implode(" AND ", $series_conditions) . " ";
}
$series_sql .= "ORDER BY name";
$series_result = $conn->query($series_sql);

include 'header.php';
?>

<div class="flex justify-between items-center mb-6">
    <h1 class="text-3xl font-bold text-gray-800">Manage Accessories</h1>
    <a href="add_accessories.php" class="bg-red-900 text-white px-4 py-2 rounded hover:bg-red-800 transition">
        <i class="fa-solid fa-plus mr-2"></i> Add New Accessory
    </a>
</div>

<?php if ($message): ?>
    <div class="mb-4 p-4 rounded <?php echo strpos($message, 'successfully') !== false ? 'bg-green-100 text-green-700' : 'bg-red-100 text-red-700'; ?>">
        <?php echo $message; ?>
    </div>
<?php endif; ?>

<div class="bg-white p-4 rounded-lg shadow mb-6">
    <form method="GET" class="grid grid-cols-1 md:grid-cols-5 gap-4 items-end">
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Search Name</label>
            <input type="text" name="search" value="<?php echo htmlspecialchars($search); ?>" placeholder="Product Name..." class="w-full border rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-red-900">
        </div>
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Brand</label>
            <select name="brand" class="w-full border rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-red-900">
                <option value="">All Brands</option>
                <?php while($brand = $brands_result->fetch_assoc()): ?>
                    <option value="<?php echo $brand['id']; ?>" <?php echo $brand_filter == $brand['id'] ? 'selected' : ''; ?>>
                        <?php echo $brand['name']; ?>
                    </option>
                <?php endwhile; ?>
            </select>
        </div>
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Category</label>
            <select name="category" class="w-full border rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-red-900">
                <option value="">All Categories</option>
                <?php while($cat = $categories_result->fetch_assoc()): ?>
                    <option value="<?php echo $cat['id']; ?>" <?php echo $category_filter == $cat['id'] ? 'selected' : ''; ?>>
                        <?php echo $cat['name']; ?>
                    </option>
                <?php endwhile; ?>
            </select>
        </div>
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Series</label>
            <select name="series" class="w-full border rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-red-900">
                <option value="">All Series</option>
                <?php while($ser = $series_result->fetch_assoc()): ?>
                    <option value="<?php echo $ser['id']; ?>" <?php echo $series_filter == $ser['id'] ? 'selected' : ''; ?>>
                        <?php echo $ser['name']; ?>
                    </option>
                <?php endwhile; ?>
            </select>
        </div>
        <div class="flex space-x-2">
            <button type="submit" class="bg-gray-800 text-white px-4 py-2 rounded hover:bg-gray-700 transition w-full">
                <i class="fa-solid fa-filter"></i> Filter
            </button>
            <a href="manage_accessories.php" class="bg-gray-300 text-gray-800 px-4 py-2 rounded hover:bg-gray-400 transition text-center w-full">
                <i class="fa-solid fa-rotate-left"></i> Reset
            </a>
        </div>
    </form>
</div>

<div class="bg-white rounded-lg shadow overflow-hidden">
    <table class="w-full text-left border-collapse">
        <thead class="bg-gray-50">
            <tr>
                <th class="py-3 px-4 border-b font-bold text-gray-600">S. No</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Image</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Name</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Brand</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Category</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Series</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Price</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Stock</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Created At</th>
                <th class="py-3 px-4 border-b font-bold text-gray-600">Actions</th>
            </tr>
        </thead>
        <tbody>
            <?php
            if ($result->num_rows > 0) {
                $serial_number = $offset + 1;
                while($row = $result->fetch_assoc()) {
                    $image = $row['image'] ? '../' . $row['image'] : 'https://placehold.co/50x50?text=No+Img';
                    echo "<tr class='hover:bg-gray-50 transition'>";
                    echo "<td class='py-3 px-4 border-b'>" . $serial_number++ . "</td>";
                    echo "<td class='py-3 px-4 border-b'><img src='$image' class='h-10 w-10 object-contain'></td>";
                    echo "<td class='py-3 px-4 border-b font-medium'>{$row['name']}</td>";
                    echo "<td class='py-3 px-4 border-b'>{$row['brand_name']}</td>";
                    echo "<td class='py-3 px-4 border-b'>{$row['category_name']}</td>";
                    echo "<td class='py-3 px-4 border-b'>{$row['series_name']}</td>";
                    echo "<td class='py-3 px-4 border-b'>₹{$row['price']}</td>";
                    
                    // Stock Status Toggle
                    $isChecked = $row['stock_status'] == 'in_stock' ? 'checked' : '';
                    $statusLabel = $row['stock_status'] == 'in_stock' ? 'In Stock' : 'Out of Stock';
                    $statusColor = $row['stock_status'] == 'in_stock' ? 'text-green-600' : 'text-red-600';
                    $sliderBg = $isChecked ? 'bg-red-900' : 'bg-gray-300';
                    $knobTransform = $isChecked ? 'translateX(20px)' : 'translateX(0)';

echo "<td class='py-3 px-4 border-b'>
                            <div class='flex items-center'>
                                <label class='relative inline-flex items-center cursor-pointer'>
                                    <input type='checkbox' class='sr-only stock-toggle' data-id='{$row['id']}' $isChecked>
                                    <div class='stock-toggle-slider w-11 h-6 {$sliderBg} rounded-full transition-colors duration-300'>
                                        <div class='stock-toggle-knob absolute top-0.5 left-0.5 w-5 h-5 bg-white border border-gray-300 rounded-full transition-transform duration-300' style='transform: {$knobTransform};'></div>
                                    </div>
                                    <span class='ml-3 text-sm font-medium {$statusColor} stock-label-{$row['id']}'>{$statusLabel}</span>
                                </label>
                            </div>
                          </td>";

echo "<td class='py-3 px-4 border-b text-sm text-gray-500'>{$row['created_at']}</td>";
                    echo "<td class='py-3 px-4 border-b space-x-2'>";
                    echo "<a href='edit_product.php?id={$row['id']}' class='text-blue-600 hover:text-blue-800'><i class='fa-solid fa-pen-to-square'></i></a>";
                    echo "<a href='add_product_images.php?id={$row['id']}' class='text-green-600 hover:text-green-800'><i class='fa-solid fa-images'></i></a>";
                    // Removed 'Add Parts' button as requested
                    echo "<a href='delete_product.php?id={$row['id']}' class='text-red-600 hover:text-red-800' onclick='return confirm(\"Are you sure you want to delete this product?\")'><i class='fa-solid fa-trash'></i></a>";
                    echo "</td>";
                    echo "</tr>";
                }
            } else {
                echo "<tr><td colspan='9' class='py-8 text-center text-gray-500'>No accessories found matching your criteria.</td></tr>";
            }
            ?>
        </tbody>
    </table>
    
    
    <?php if ($total_pages > 1): ?>
        <div class="px-4 py-3 border-t border-gray-200 flex items-center justify-between sm:px-6">
            <div class="hidden sm:flex-1 sm:flex sm:items-center sm:justify-between">
                <div>
                    <p class="text-sm text-gray-700">
                        Showing <span class="font-medium"><?php echo $offset + 1; ?></span> to <span class="font-medium"><?php echo min($offset + $limit, $total_rows); ?></span> of <span class="font-medium"><?php echo $total_rows; ?></span> results
                    </p>
                </div>
                <div>
                    <nav class="relative z-0 inline-flex rounded-md shadow-sm -space-x-px" aria-label="Pagination">
                        <?php
                        $query_params = $_GET;
                        // Previous Link
                        if ($page > 1) {
                            $query_params['page'] = $page - 1;
                            $prev_link = '?' . http_build_query($query_params);
                            echo "<a href='$prev_link' class='relative inline-flex items-center px-2 py-2 rounded-l-md border border-gray-300 bg-white text-sm font-medium text-gray-500 hover:bg-gray-50'><i class='fa-solid fa-chevron-left'></i></a>";
                        }
                        
                        // Page Numbers
                        for ($i = 1; $i <= $total_pages; $i++) {
                            $query_params['page'] = $i;
                            $link = '?' . http_build_query($query_params);
                            $active_class = $i == $page ? 'z-10 bg-red-50 border-red-500 text-red-600' : 'bg-white border-gray-300 text-gray-500 hover:bg-gray-50';
                            echo "<a href='$link' class='relative inline-flex items-center px-4 py-2 border text-sm font-medium $active_class'>$i</a>";
                        }
                        
                        // Next Link
                        if ($page < $total_pages) {
                            $query_params['page'] = $page + 1;
                            $next_link = '?' . http_build_query($query_params);
                            echo "<a href='$next_link' class='relative inline-flex items-center px-2 py-2 rounded-r-md border border-gray-300 bg-white text-sm font-medium text-gray-500 hover:bg-gray-50'><i class='fa-solid fa-chevron-right'></i></a>";
                        }
                        ?>
                    </nav>
                </div>
            </div>
        </div>
    <?php endif; ?>
</div>

function updateSeriesDropdown() {
        const brandId = brandSelect.value;
        const categoryId = categorySelect.value;
        
        seriesSelect.innerHTML = '<option value="">All Series</option>';

const params = new URLSearchParams();
        if (brandId) params.append('brand_id', brandId);
        if (categoryId) params.append('category_id', categoryId);

fetch('get_series.php?' + params.toString())
            .then(response => response.json())
            .then(data => {
                data.forEach(item => {
                    const option = document.createElement('option');
                    option.value = item.id;
                    option.textContent = item.name;
                    seriesSelect.appendChild(option);
                });
            })
            .catch(error => console.error('Error fetching series:', error));
    }

if (brandSelect && categorySelect) {
        brandSelect.addEventListener('change', updateSeriesDropdown);
        categorySelect.addEventListener('change', updateSeriesDropdown);
    }

const toggles = document.querySelectorAll('.stock-toggle');

toggles.forEach(toggle => {
        toggle.addEventListener('change', function() {
            const id = this.dataset.id;
            const status = this.checked ? 'in_stock' : 'out_of_stock';
            const label = document.querySelector('.stock-label-' + id);
            const slider = this.parentElement.querySelector('.stock-toggle-slider');
            const knob = slider.querySelector('.stock-toggle-knob');

// Optimistic UI update
            if (this.checked) {
                label.textContent = 'In Stock';
                label.classList.remove('text-red-600');
                label.classList.add('text-green-600');
                slider.classList.add('bg-red-900');
                slider.classList.remove('bg-gray-300');
                knob.style.transform = 'translateX(20px)';
            } else {
                label.textContent = 'Out of Stock';
                label.classList.remove('text-green-600');
                label.classList.add('text-red-600');
                slider.classList.remove('bg-red-900');
                slider.classList.add('bg-gray-300');
                knob.style.transform = 'translateX(0)';
            }

fetch('update_stock_status.php', {
                method: 'POST',
                headers: {
                    'Content-Type': 'application/json',
                },
                body: JSON.stringify({
                    id: id,
                    status: status
                })
            })
            .then(response => response.json())
            .then(data => {
                if (!data.success) {
                    alert('Error updating stock status: ' + data.message);
                    // Revert UI if error
                    this.checked = !this.checked;
                    // Revert label and slider
                    if (this.checked) {
                        label.textContent = 'In Stock';
                        label.classList.remove('text-red-600');
                        label.classList.add('text-green-600');
                        slider.classList.add('bg-red-900');
                        slider.classList.remove('bg-gray-300');
                        knob.style.transform = 'translateX(20px)';
                    } else {
                        label.textContent = 'Out of Stock';
                        label.classList.remove('text-green-600');
                        label.classList.add('text-red-600');
                        slider.classList.remove('bg-red-900');
                        slider.classList.add('bg-gray-300');
                        knob.style.transform = 'translateX(0)';
                    }
                }
            })
            .catch(error => {
                console.error('Error:', error);
                alert('An error occurred while updating stock status.');
                this.checked = !this.checked;
                // Revert slider and label on error
                if (this.checked) {
                    label.textContent = 'In Stock';
                    label.classList.remove('text-red-600');
                    label.classList.add('text-green-600');
                    slider.classList.add('bg-red-900');
                    slider.classList.remove('bg-gray-300');
                    knob.style.transform = 'translateX(20px)';
                } else {
                    label.textContent = 'Out of Stock';
                    label.classList.remove('text-green-600');
                    label.classList.add('text-red-600');
                    slider.classList.remove('bg-red-900');
                    slider.classList.add('bg-gray-300');
                    knob.style.transform = 'translateX(0)';
                }
            });
        });
    });
});
</script>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage_accessories.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation