Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/bakery/seller

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: foods.php

<?php
session_start();
require_once 'config/db_config.php'; // Include PDO database connection

$branch_id = $_SESSION['branch_id'];

// ---- CSRF Token ----
if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}
$csrf = $_SESSION['csrf_token'];

// ---- Helpers ----
function h(string $v): string {
    return htmlspecialchars($v, ENT_QUOTES, 'UTF-8');
}

// Initialize variables for form handling
$errors = [];
$success = '';
$food_name = $price = '';
$category_id = null;
$edit_food_id = null;

// Fetch categories for the branch
try {
    $stmt = $pdo->prepare("
        SELECT fc.category_id, fc.category_name
        FROM food_categories fc
        INNER JOIN branch_categories bc ON fc.category_id = bc.category_id
        WHERE bc.branch_id = :branch_id AND bc.status = 'active'
        ORDER BY fc.category_name
    ");
    $stmt->execute(['branch_id' => $branch_id]);
    $categories = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    $errors[] = "Error fetching categories: " . h($e->getMessage());
    file_put_contents('error.log', "Category fetch error: " . $e->getMessage() . "\n", FILE_APPEND);
    $categories = [];
}

// Fetch foods for the branch
try {
    $stmt = $pdo->prepare("
        SELECT f.food_id, f.food_name, f.price, f.image_url, bf.status AS is_available, c.category_name
        FROM foods f
        INNER JOIN branch_foods bf ON f.food_id = bf.food_id
        LEFT JOIN food_categories c ON f.category_id = c.category_id
        WHERE bf.branch_id = :branch_id
        ORDER BY f.food_name
    ");
    $stmt->execute(['branch_id' => $branch_id]);
    $foods = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Fetch branches for each food
    $food_branches = [];
    foreach ($foods as &$food) {
        $stmt = $pdo->prepare("
            SELECT b.branch_id, b.branch_name
            FROM branch_foods bf
            INNER JOIN branches b ON bf.branch_id = b.branch_id
            WHERE bf.food_id = :food_id AND bf.status = 'active'
            ORDER BY b.branch_name
        ");
        $stmt->execute(['food_id' => $food['food_id']]);
        $food_branches[$food['food_id']] = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $food['branch_count'] = count($food_branches[$food['food_id']]);
    }
    unset($food);
} catch (PDOException $e) {
    $errors[] = "Error fetching foods or branches: " . h($e->getMessage());
    file_put_contents('error.log', "Food fetch error: " . $e->getMessage() . "\n", FILE_APPEND);
    $foods = [];
    $food_branches = [];
}

// Handle form submission (add or edit)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && isset($_POST['csrf']) && $_POST['csrf'] === $_SESSION['csrf_token']) {
    $action = $_POST['action'];
    $food_name = trim($_POST['food_name'] ?? '');
    $category_id = $_POST['category_id'] ?? '';
    $price = $_POST['price'] ?? '';

// Validate inputs
    if (empty($food_name)) {
        $errors[] = "Food name is required.";
    } else {
        // Check for unique food name within the branch
        try {
            $stmt = $pdo->prepare("
                SELECT COUNT(*)
                FROM foods f
                INNER JOIN branch_foods bf ON f.food_id = bf.food_id
                WHERE f.food_name = :food_name
                AND bf.branch_id = :branch_id
                AND f.food_id != :food_id
            ");
            $stmt->execute([
                'food_name' => $food_name,
                'branch_id' => $branch_id,
                'food_id' => $action === 'edit' ? ($_POST['food_id'] ?? 0) : 0
            ]);
            if ($stmt->fetchColumn() > 0) {
                $errors[] = "Food name already exists for this branch.";
            }
        } catch (PDOException $e) {
            $errors[] = "Error checking food name: " . h($e->getMessage());
            file_put_contents('error.log', "Food name check error: " . $e->getMessage() . "\n", FILE_APPEND);
        }
    }

if (empty($category_id) || !array_key_exists($category_id, array_column($categories, 'category_id', 'category_id'))) {
        $errors[] = "Please select a valid category.";
    }

if (!is_numeric($price) || $price <= 0) {
        $errors[] = "Price must be a positive number.";
    }

// Handle image upload
    $image_url = '';
    if (isset($_FILES['food_image']) && $_FILES['food_image']['error'] !== UPLOAD_ERR_NO_FILE) {
        $file = $_FILES['food_image'];
        $allowed_types = ['image/jpeg', 'image/png', 'image/gif'];
        $max_size = 2 * 1024 * 1024; // 2MB
        if (!in_array($file['type'], $allowed_types)) {
            $errors[] = "Only JPEG, PNG, or GIF images are allowed.";
        } elseif ($file['size'] > $max_size) {
            $errors[] = "Image size must not exceed 2MB.";
        } else {
            $upload_dir = 'Uploads/foods/';
            if (!is_dir($upload_dir)) {
                mkdir($upload_dir, 0755, true);
            }
            $file_name = uniqid() . '-' . basename($file['name']);
            $file_path = $upload_dir . $file_name;
            if (move_uploaded_file($file['tmp_name'], $file_path)) {
                $image_url = $file_path;
            } else {
                $errors[] = "Failed to upload image.";
            }
        }
    } elseif ($action === 'edit') {
        // Retain existing image if no new image is uploaded
        try {
            $stmt = $pdo->prepare("SELECT image_url FROM foods WHERE food_id = :food_id");
            $stmt->execute(['food_id' => $_POST['food_id']]);
            $image_url = $stmt->fetchColumn();
        } catch (PDOException $e) {
            $errors[] = "Error fetching existing image: " . h($e->getMessage());
            file_put_contents('error.log', "Image fetch error: " . $e->getMessage() . "\n", FILE_APPEND);
        }
    }

// Perform add or edit
    if (empty($errors)) {
        try {
            if ($action === 'add') {
                $pdo->beginTransaction();
                $stmt = $pdo->prepare("
                    INSERT INTO foods (category_id, food_name, price, image_url, created_at)
                    VALUES (:category_id, :food_name, :price, :image_url, NOW())
                ");
                $stmt->execute([
                    'category_id' => $category_id,
                    'food_name' => $food_name,
                    'price' => $price,
                    'image_url' => $image_url
                ]);
                // Add to branch_foods
                $food_id = $pdo->lastInsertId();
                $stmt = $pdo->prepare("
                    INSERT INTO branch_foods (branch_id, food_id, status)
                    VALUES (:branch_id, :food_id, 'active')
                ");
                $stmt->execute(['branch_id' => $branch_id, 'food_id' => $food_id]);
                $pdo->commit();
                $success = "Food item added successfully!";
                header("Location: foods.php");
                exit();
            } elseif ($action === 'edit') {
                $food_id = $_POST['food_id'];
                // Verify food is associated with the branch
                $stmt = $pdo->prepare("
                    SELECT COUNT(*)
                    FROM branch_foods
                    WHERE food_id = :food_id AND branch_id = :branch_id
                ");
                $stmt->execute(['food_id' => $food_id, 'branch_id' => $branch_id]);
                if ($stmt->fetchColumn() == 0) {
                    $errors[] = "Food item not associated with this branch.";
                } else {
                    $pdo->beginTransaction();
                    $stmt = $pdo->prepare("
                        UPDATE foods
                        SET category_id = :category_id, food_name = :food_name, price = :price, image_url = :image_url
                        WHERE food_id = :food_id
                    ");
                    $stmt->execute([
                        'category_id' => $category_id,
                        'food_name' => $food_name,
                        'price' => $price,
                        'image_url' => $image_url,
                        'food_id' => $food_id
                    ]);
                    $pdo->commit();
                    $success = "Food item updated successfully!";
                    header("Location: foods.php");
                    exit();
                }
            }
        } catch (PDOException $e) {
            $pdo->rollBack();
            $errors[] = "Error saving food item: " . h($e->getMessage());
            file_put_contents('error.log', "Save error: " . $e->getMessage() . "\n", FILE_APPEND);
        }
    }
}

// Handle delete
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['delete_food_id']) && isset($_POST['csrf']) && $_POST['csrf'] === $_SESSION['csrf_token']) {
    $food_id = $_POST['delete_food_id'];
    try {
        $pdo->beginTransaction();
        // Check for dependent order items
        $stmt = $pdo->prepare("SELECT COUNT(*) FROM order_items WHERE food_id = :food_id");
        $stmt->execute(['food_id' => $food_id]);
        if ($stmt->fetchColumn() > 0) {
            $errors[] = "Cannot delete food item: It is included in existing orders.";
        } else {
            // Delete from branch_foods
            $stmt = $pdo->prepare("
                DELETE FROM branch_foods
                WHERE food_id = :food_id AND branch_id = :branch_id
            ");
            $stmt->execute(['food_id' => $food_id, 'branch_id' => $branch_id]);
            // Delete from foods if no other branches are associated
            $stmt = $pdo->prepare("
                SELECT COUNT(*)
                FROM branch_foods
                WHERE food_id = :food_id
            ");
            $stmt->execute(['food_id' => $food_id]);
            if ($stmt->fetchColumn() == 0) {
                $stmt = $pdo->prepare("DELETE FROM foods WHERE food_id = :food_id");
                $stmt->execute(['food_id' => $food_id]);
            }
            $pdo->commit();
            $success = "Food item deleted successfully!";
            header("Location: foods.php");
            exit();
        }
    } catch (PDOException $e) {
        $pdo->rollBack();
        $errors[] = "Error deleting food item: " . h($e->getMessage());
        file_put_contents('error.log', "Delete error: " . $e->getMessage() . "\n", FILE_APPEND);
    }
}

// Fetch food for editing
if (isset($_GET['edit'])) {
    $edit_food_id = $_GET['edit'];
    try {
        $stmt = $pdo->prepare("
            SELECT f.food_name, f.category_id, f.price, f.image_url
            FROM foods f
            INNER JOIN branch_foods bf ON f.food_id = bf.food_id
            WHERE f.food_id = :food_id AND bf.branch_id = :branch_id
        ");
        $stmt->execute(['food_id' => $edit_food_id, 'branch_id' => $branch_id]);
        $food = $stmt->fetch(PDO::FETCH_ASSOC);
        if ($food) {
            $food_name = $food['food_name'];
            $category_id = $food['category_id'];
            $price = $food['price'];
        } else {
            $errors[] = "Food item not found or not associated with this branch.";
            $edit_food_id = null;
        }
    } catch (PDOException $e) {
        $errors[] = "Error fetching food item: " . h($e->getMessage());
        file_put_contents('error.log', "Edit fetch error: " . $e->getMessage() . "\n", FILE_APPEND);
    }
}
?>

<?php include './partials/layouts/layoutTop.php' ?>

.toggle-switch {
        position: relative;
        display: inline-block;
        width: 40px;
        height: 20px;
    }

.toggle-switch input[type="checkbox"] {
        opacity: 0;
        width: 0;
        height: 0;
    }

.toggle-slider {
        position: absolute;
        cursor: pointer;
        top: 0;
        left: 0;
        right: 0;
        bottom: 0;
        background-color: #ccc;
        border-radius: 20px;
        transition: 0.3s;
    }

.toggle-slider:before {
        position: absolute;
        content: "";
        height: 16px;
        width: 16px;
        left: 2px;
        bottom: 2px;
        background-color: white;
        border-radius: 50%;
        transition: 0.3s;
    }

.toggle-switch input:checked + .toggle-slider {
        background-color: #28a745; /* Green for active */
    }

.toggle-switch input:checked + .toggle-slider:before {
        transform: translateX(20px);
    }

.toggle-label.available {
        color: #28a745;
        font-weight: 500;
    }

.toggle-label.unavailable {
        color: #dc3545;
        font-weight: 500;
    }
    
    .no-image {
        background-color: #f8f9fa;
        color: #6c757d;
        font-size: 0.75rem;
    }
</style>

<div class="dashboard-main-body">
    <div class="d-flex flex-wrap align-items-center justify-content-between gap-2 mb-16">
        <h6 class="fw-semibold mb-0 text-md">Food Items <span class="badge bg-secondary"><?php echo count($foods); ?></span></h6>
        <ul class="d-flex align-items-center gap-1">
            <li class="fw-medium text-sm">
                <a href="index.php" class="d-flex align-items-center gap-1 hover-text-primary">
                    <iconify-icon icon="solar:home-smile-angle-outline" class="icon text-md"></iconify-icon>
                    Dashboard
                </a>
            </li>
            <li>-</li>
            <li class="fw-medium text-sm">Food Items</li>
        </ul>
    </div>

<div class="card">
        <div class="card-body p-16">
            <h6 class="section-title text-md mb-12"><?php echo $edit_food_id ? 'Edit Food Item' : 'Add New Food Item'; ?></h6>
            
            
            <?php if ($success): ?>
                <div id="toast-container" class="position-fixed top-0 end-0 p-3" style="z-index: 1050;"></div>
                <script>
                    document.addEventListener('DOMContentLoaded', function() {
                        showToast('<?php echo h($success); ?>', 'success');
                    });
                </script>
            <?php endif; ?>
            
            <?php if (!empty($errors)): ?>
                <div id="toast-container" class="position-fixed top-0 end-0 p-3" style="z-index: 1050;"></div>
                <script>
                    document.addEventListener('DOMContentLoaded', function() {
                        showToast('<?php echo h(implode(', ', $errors)); ?>', 'danger');
                    });
                </script>
            <?php endif; ?>

<form action="foods.php" method="POST" enctype="multipart/form-data">
                <input type="hidden" name="action" value="<?php echo $edit_food_id ? 'edit' : 'add'; ?>">
                <input type="hidden" name="csrf" value="<?php echo h($csrf); ?>">
                <?php if ($edit_food_id): ?>
                    <input type="hidden" name="food_id" value="<?php echo h($edit_food_id); ?>">
                <?php endif; ?>
                <div class="row gy-3">
                    <div class="col-md-6">
                        <label for="food_name" class="form-label fw-medium text-sm">Food Name <span class="text-danger">*</span></label>
                        <input type="text" class="form-control form-control-sm bg-base" id="food_name" name="food_name" value="<?php echo h($food_name); ?>" required>
                    </div>
                    <div class="col-md-6">
                        <label for="category_id" class="form-label fw-medium text-sm">Category <span class="text-danger">*</span></label>
                        <select class="form-select form-control-sm bg-base" id="category_id" name="category_id" required>
                            <option value="">Select Category</option>
                            <?php foreach ($categories as $category): ?>
                                <option value="<?php echo h($category['category_id']); ?>" <?php echo $category_id == $category['category_id'] ? 'selected' : ''; ?>>
                                    <?php echo h($category['category_name']); ?>
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="col-md-6">
                        <label for="price" class="form-label fw-medium text-sm">Price (₹) <span class="text-danger">*</span></label>
                        <input type="number" step="0.01" min="0.01" class="form-control form-control-sm bg-base" id="price" name="price" value="<?php echo h($price); ?>" required>
                    </div>
                    <div class="col-md-6">
                        <label for="food_image" class="form-label fw-medium text-sm">Food Image (Optional)</label>
                        <input type="file" class="form-control form-control-sm bg-base" id="food_image" name="food_image" accept="image/jpeg,image/png,image/gif">
                        <small class="text-secondary-light text-xs">Allowed formats: JPEG, PNG, GIF. Max size: 2MB</small>
                    </div>
                    <div class="col-12 text-end">
                        <button type="submit" class="btn btn-primary btn-sm bg-primary-600 hover-bg-primary-700 text-white">
                            <?php echo $edit_food_id ? 'Update Food Item' : 'Add Food Item'; ?>
                        </button>
                        <?php if ($edit_food_id): ?>
                            <a href="foods.php" class="btn btn-outline-secondary btn-sm">Cancel</a>
                        <?php endif; ?>
                    </div>
                </div>
            </form>
        </div>
    </div>

<div class="card basic-data-table mt-16">
        <div class="card-header">
            <div class="d-flex flex-wrap align-items-center justify-content-between">
                <div class="d-flex"><h5 class="section-title card-title mb-0 text-md">All Food Items </h5><span class="badge bg-secondary"><?php echo count($foods); ?></span></div>
                <a href="foods.php" class="text-primary-600 hover-text-primary d-flex align-items-center gap-1 text-sm">
                    Create New Food Item
                    <iconify-icon icon="solar:alt-arrow-right-linear" class="icon"></iconify-icon>
                </a>
            </div>
        </div>
        <div class="card-body p-16">
            
            <div class="d-none d-md-block">
                <div class="table-responsive">
                    <table class="table bordered-table sm-table mb-0" id="dataTable" data-page-length="10">
                        <thead>
                            <tr>
                                <th scope="col">
                                    <div class="form-check style-check d-flex align-items-center">
                                        <input class="form-check-input" type="checkbox" id="selectAll">
                                        <label class="form-check-label text-sm">S.L</label>
                                    </div>
                                </th>
                                <th scope="col">Food Name</th>
                                <th scope="col">Category</th>
                                <th scope="col">Price (₹)</th>
                                <th scope="col">Availability</th>
                                <th scope="col">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php if (empty($foods)): ?>
                                <tr><td colspan="6" class="text-center text-sm">No food items found.</td></tr>
                            <?php else: ?>
                                <?php foreach ($foods as $index => $food): ?>
                                    <tr>
                                        <td>
                                            <div class="form-check style-check d-flex align-items-center">
                                                <input class="form-check-input" type="checkbox" name="food_ids[]" value="<?php echo h($food['food_id']); ?>">
                                                <label class="form-check-label text-sm"><?php echo sprintf('%02d', $index + 1); ?></label>
                                            </div>
                                        </td>
                                        <td>
                                            <div class="d-flex align-items-center">
                                                <?php if ($food['image_url']): ?>
                                                    <img src="../<?php echo h($food['image_url']); ?>" alt="Food Image" class="flex-shrink-0 me-12 w-32-px h-32-px rounded">
                                                <?php else: ?>
                                                    <span class="flex-shrink-0 me-12 w-32-px h-32-px rounded bg-secondary-light d-inline-flex align-items-center justify-content-center text-sm no-image">No Image</span>
                                                <?php endif; ?>
                                                <h6 class="text-sm mb-0 fw-medium flex-grow-1">
                                                    <a href="javascript:void(0)" class="text-primary-600" data-bs-toggle="modal" data-bs-target="#foodModal<?php echo h($food['food_id']); ?>">
                                                        <span class="badge bg-primary"><?php echo h($food['food_name']); ?></span>
                                                        
                                                    </a>
                                                </h6>
                                            </div>
                                        </td>
                                        <td class="text-sm"><?php echo h($food['category_name'] ?: 'Uncategorized'); ?></td>
                                        <td class="text-sm"><?php echo number_format($food['price'], 2); ?></td>
                                        <td>
                                            <div class="toggle-container">
                                                <label class="toggle-switch">
                                                    <input type="checkbox" class="availability-toggle"
                                                           data-food-id="<?php echo h($food['food_id']); ?>"
                                                           data-branch-id="<?php echo h($branch_id); ?>"
                                                           data-csrf="<?php echo h($csrf); ?>"
                                                           data-bs-toggle="tooltip"
                                                           data-bs-placement="top"
                                                           title="<?php echo $food['is_available'] === 'active' ? 'Available' : 'Unavailable'; ?>"
                                                           <?php echo $food['is_available'] === 'active' ? 'checked' : ''; ?>>
                                                    <span class="toggle-slider"></span>
                                                </label>
                                                <span class="toggle-label <?php echo $food['is_available'] === 'active' ? 'available' : 'unavailable'; ?>">
                                                    <?php echo $food['is_available'] === 'active' ? 'Available' : 'Unavailable'; ?>
                                                </span>
                                            </div>
                                        </td>
                                        <td class="action-buttons">
                                            <a href="javascript:void(0)" class="w-32-px h-32-px bg-primary-light text-primary-600 rounded-circle d-inline-flex align-items-center justify-content-center" data-bs-toggle="modal" data-bs-target="#foodModal<?php echo h($food['food_id']); ?>">
                                                <iconify-icon icon="iconamoon:eye-light"></iconify-icon>
                                            </a>
                                            <a href="foods.php?edit=<?php echo h($food['food_id']); ?>" class="w-32-px h-32-px bg-success-focus text-success-main rounded-circle d-inline-flex align-items-center justify-content-center">
                                                <iconify-icon icon="lucide:edit"></iconify-icon>
                                            </a>
                                            <form action="foods.php" method="POST" style="display:inline;" onsubmit="return confirm('Are you sure you want to delete this food item?');">
                                                <input type="hidden" name="delete_food_id" value="<?php echo h($food['food_id']); ?>">
                                                <input type="hidden" name="csrf" value="<?php echo h($csrf); ?>">
                                                <button type="submit" class="w-32-px h-32-px bg-danger-focus text-danger-main rounded-circle d-inline-flex align-items-center justify-content-center border-0 bg-none">
                                                    <iconify-icon icon="mingcute:delete-2-line"></iconify-icon>
                                                </button>
                                            </form>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>

<div class="d-md-none">
                <?php if (empty($foods)): ?>
                    <div class="text-center text-sm p-16">No food items found.</div>
                <?php else: ?>
                    <div class="row g-3">
                        <?php foreach ($foods as $index => $food): ?>
                            <div class="col-12">
                                <div class="card food-card">
                                    <div class="card-body p-16">
                                        <div class="d-flex align-items-center justify-content-between mb-12">
                                            <div class="d-flex align-items-center">
                                                <?php if ($food['image_url']): ?>
                                                    <img src="<?php echo h($food['image_url']); ?>" alt="Food Image" class="flex-shrink-0 me-12 w-48-px h-48-px rounded">
                                                <?php else: ?>
                                                    <span class="flex-shrink-0 me-12 w-48-px h-48-px rounded bg-secondary-light d-inline-flex align-items-center justify-content-center text-sm">No Image</span>
                                                <?php endif; ?>
                                                <div>
                                                    <h6 class="text-sm mb-2 fw-medium">
                                                        <a href="javascript:void(0)" class="text-primary-600" data-bs-toggle="modal" data-bs-target="#foodModal<?php echo h($food['food_id']); ?>">
                                                            <span class="badge bg-primary"><?php echo h($food['food_name']); ?></span>
                                                            <?php if ($food['branch_count'] > 0): ?>
                                                                <span class="badge bg-secondary ms-1"><?php echo $food['branch_count']; ?> Branch<?php echo $food['branch_count'] > 1 ? 'es' : ''; ?></span>
                                                            <?php endif; ?>
                                                        </a>
                                                    </h6>
                                                    <div class="d-flex align-items-center gap-3">
                                                        <span class="food-category"><?php echo h($food['category_name'] ?: 'Uncategorized'); ?></span>
                                                        <span class="food-price">₹<?php echo number_format($food['price'], 2); ?></span>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="form-check style-check">
                                                <input class="form-check-input" type="checkbox" name="food_ids[]" value="<?php echo h($food['food_id']); ?>">
                                            </div>
                                        </div>
                                        <div class="d-flex justify-content-between align-items-center">
                                            <div class="toggle-container">
                                                <label class="toggle-switch">
                                                    <input type="checkbox" class="availability-toggle"
                                                           data-food-id="<?php echo h($food['food_id']); ?>"
                                                           data-branch-id="<?php echo h($branch_id); ?>"
                                                           data-csrf="<?php echo h($csrf); ?>"
                                                           data-bs-toggle="tooltip"
                                                           data-bs-placement="top"
                                                           title="<?php echo $food['is_available'] === 'active' ? 'Available' : 'Unavailable'; ?>"
                                                           <?php echo $food['is_available'] === 'active' ? 'checked' : ''; ?>>
                                                    <span class="toggle-slider"></span>
                                                </label>
                                                <span class="toggle-label <?php echo $food['is_available'] === 'active' ? 'available' : 'unavailable'; ?>">
                                                    <?php echo $food['is_available'] === 'active' ? 'Available' : 'Unavailable'; ?>
                                                </span>
                                            </div>
                                            <div class="d-flex align-items-center gap-2">
                                                <a href="javascript:void(0)" class="w-32-px h-32-px bg-primary-light text-primary-600 rounded-circle d-inline-flex align-items-center justify-content-center" data-bs-toggle="modal" data-bs-target="#foodModal<?php echo h($food['food_id']); ?>">
                                                    <iconify-icon icon="iconamoon:eye-light"></iconify-icon>
                                                </a>
                                                <a href="foods.php?edit=<?php echo h($food['food_id']); ?>" class="w-32-px h-32-px bg-success-focus text-success-main rounded-circle d-inline-flex align-items-center justify-content-center">
                                                    <iconify-icon icon="lucide:edit"></iconify-icon>
                                                </a>
                                                <form action="foods.php" method="POST" style="display:inline;" onsubmit="return confirm('Are you sure you want to delete this food item?');">
                                                    <input type="hidden" name="delete_food_id" value="<?php echo h($food['food_id']); ?>">
                                                    <input type="hidden" name="csrf" value="<?php echo h($csrf); ?>">
                                                    <button type="submit" class="w-32-px h-32-px bg-danger-focus text-danger-main rounded-circle d-inline-flex align-items-center justify-content-center border-0 bg-none">
                                                        <iconify-icon icon="mingcute:delete-2-line"></iconify-icon>
                                                    </button>
                                                </form>
                                            </div>
                                        </div>
                                        <div class="mt-8 text-xs text-secondary-light">
                                            #<?php echo sprintf('%02d', $index + 1); ?>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    </div>
                <?php endif; ?>
            </div>
        </div>
    </div>

<?php foreach ($foods as $food): ?>
        <div class="modal fade" id="foodModal<?php echo h($food['food_id']); ?>" tabindex="-1" aria-labelledby="foodModalLabel<?php echo h($food['food_id']); ?>" aria-hidden="true">
            <div class="modal-dialog modal-lg">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title text-md" id="foodModalLabel<?php echo h($food['food_id']); ?>">
                            Food Item: <span class="badge bg-primary"><?php echo h($food['food_name']); ?></span>
                            <?php if ($food['branch_count'] > 0): ?>
                                <span class="badge bg-secondary ms-1"><?php echo $food['branch_count']; ?> Branch<?php echo $food['branch_count'] > 1 ? 'es' : ''; ?></span>
                            <?php endif; ?>
                        </h5>
                        <button type="button" class="btn-close btn-sm" data-bs-dismiss="modal" aria-label="Close"></button>
                    </div>
                    <div class="modal-body">
                        <div class="row">
                            <div class="col-md-4 mb-3 text-center">
                                <?php if ($food['image_url']): ?>
                                    <img src="<?php echo h($food['image_url']); ?>" alt="Food Image" class="img-fluid rounded-3 shadow-sm" style="max-height: 200px; width: auto;">
                                <?php else: ?>
                                    <p class="text-muted">No Image Available</p>
                                <?php endif; ?>
                            </div>
                            <div class="col-md-8">
                                <table class="table table-bordered table-sm">
                                    <tbody>
                                        <tr>
                                            <th scope="row" style="width: 30%;">Food Name</th>
                                            <td><?php echo h($food['food_name']); ?></td>
                                        </tr>
                                        <tr>
                                            <th scope="row">Category</th>
                                            <td><?php echo h($food['category_name'] ?: 'Uncategorized'); ?></td>
                                        </tr>
                                        <tr>
                                            <th scope="row">Price</th>
                                            <td>₹<?php echo number_format($food['price'], 2); ?></td>
                                        </tr>
                                        <tr>
                                            <th scope="row">Availability</th>
                                            <td><span class="badge bg-<?php echo $food['is_available'] === 'active' ? 'success' : 'danger'; ?>">
                                                <?php echo $food['is_available'] === 'active' ? 'Available' : 'Unavailable'; ?>
                                            </span></td>
                                        </tr>
                                        
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-outline-secondary btn-sm" data-bs-dismiss="modal">Close</button>
                    </div>
                </div>
            </div>
        </div>
    <?php endforeach; ?>
</div>

// Initialize select all checkbox
    const selectAllCheckbox = document.getElementById("selectAll");
    if (selectAllCheckbox) {
        selectAllCheckbox.addEventListener("change", function() {
            const checkboxes = document.querySelectorAll("input[name=\"food_ids[]\"]");
            checkboxes.forEach(checkbox => {
                checkbox.checked = selectAllCheckbox.checked;
            });
        });
    }

// Initialize tooltips for toggles and badges
    const tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    const tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
        return new bootstrap.Tooltip(tooltipTriggerEl);
    });

// Handle availability toggle with AJAX - FIXED VERSION
    document.querySelectorAll(".availability-toggle").forEach(toggle => {
        toggle.addEventListener("change", function() {
            const foodId = this.getAttribute("data-food-id");
            const branchId = this.getAttribute("data-branch-id");
            const isAvailable = this.checked ? 'active' : 'inactive';
            const csrfToken = this.getAttribute("data-csrf");
            const toggleLabel = this.closest(".toggle-container").querySelector(".toggle-label");
            const tooltip = bootstrap.Tooltip.getInstance(this);

console.log('Toggle changed:', {
                foodId: foodId,
                branchId: branchId,
                isAvailable: isAvailable,
                csrfToken: csrfToken
            });

// Create form data
            const formData = new FormData();
            formData.append('food_id', foodId);
            formData.append('branch_id', branchId);
            formData.append('status', isAvailable);
            formData.append('csrf', csrfToken);

// Send AJAX request - FIXED
            fetch("toggle_availability.php", {
                method: "POST",
                headers: {
                    "X-Requested-With": "XMLHttpRequest" // Add this header
                },
                body: formData // Use FormData instead of URL-encoded
            })
            .then(response => {
                if (!response.ok) {
                    throw new Error('Network response was not ok: ' + response.status);
                }
                return response.json();
            })
            .then(data => {
                console.log('Response data:', data);
                if (data.success) {
                    toggleLabel.textContent = isAvailable === 'active' ? "Available" : "Unavailable";
                    toggleLabel.classList.toggle("available", isAvailable === 'active');
                    toggleLabel.classList.toggle("unavailable", isAvailable !== 'active');
                    
                    // Update tooltip
                    if (tooltip) {
                        tooltip.setContent({ '.tooltip-inner': isAvailable === 'active' ? 'Available' : 'Unavailable' });
                    }
                    showToast(data.message, 'success');
                } else {
                    // Revert toggle on error
                    this.checked = !this.checked;
                    showToast(data.message || "Error updating availability", 'danger');
                }
            })
            .catch(error => {
                // Revert toggle on error
                this.checked = !this.checked;
                console.error('Error:', error);
                showToast("Error updating availability. Please try again.", 'danger');
            });
        });
    });

// Toast function
    function showToast(message, type = 'success') {
        // Remove existing toasts first
        const existingToasts = document.querySelectorAll('.toast');
        existingToasts.forEach(toast => toast.remove());
        
        let toastContainer = document.getElementById('toast-container');
        if (!toastContainer) {
            // Create toast container if it doesn't exist
            toastContainer = document.createElement('div');
            toastContainer.id = 'toast-container';
            toastContainer.className = 'position-fixed top-0 end-0 p-3';
            toastContainer.style.zIndex = '1050';
            document.body.appendChild(toastContainer);
        }
        
        const toast = document.createElement('div');
        toast.className = `toast align-items-center text-white bg-${type} border-0`;
        toast.setAttribute('role', 'alert');
        toast.setAttribute('aria-live', 'assertive');
        toast.setAttribute('aria-atomic', 'true');
        
        toast.innerHTML = `
            <div class="d-flex">
                <div class="toast-body">${message}</div>
                <button type="button" class="btn-close btn-close-white me-2 m-auto" data-bs-dismiss="toast" aria-label="Close"></button>
            </div>
        `;
        
        toastContainer.appendChild(toast);
        const bsToast = new bootstrap.Toast(toast);
        bsToast.show();
        
        // Remove toast after it hides
        toast.addEventListener('hidden.bs.toast', () => {
            toast.remove();
        });
    }

// Initialize any existing toasts from PHP
    <?php if ($success): ?>
        showToast('<?php echo h($success); ?>', 'success');
    <?php endif; ?>
    <?php if (!empty($errors)): ?>
        showToast('<?php echo h(implode(', ', $errors)); ?>', 'danger');
    <?php endif; ?>
});
</script>

<?php include './partials/layouts/layoutBottom.php' ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: foods.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation