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/auditor

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: view_branch.php

<?php
// view_branch.php
session_start();
require_once 'config/db_config.php'; // expects $pdo (PDO)

// ---------- Security ----------
if (!isset($_SESSION['user_id']) || !isset($_SESSION['role'])) {
    header("Location: login.php");
    exit();
}

// ---- 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');
}

// ---------- Fetch Branch ID ----------
$branch_id = $_GET['id'] ?? 0;
if (!is_numeric($branch_id) || $branch_id <= 0) {
    $_SESSION['error'] = "Invalid branch ID.";
    header("Location: branches.php");
    exit();
}

// ---------- Fetch Branch Details (including logo & third_party) ----------
try {
    $stmt = $pdo->prepare("
        SELECT branch_name, address, city, state, country, image_url, logo, third_party, created_at
        FROM branches
        WHERE branch_id = :branch_id
    ");
    $stmt->execute(['branch_id' => $branch_id]);
    $branch = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$branch) {
        $_SESSION['error'] = "Branch not found.";
        header("Location: branches.php");
        exit();
    }
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching branch: " . h($e->getMessage());
    header("Location: branches.php");
    exit();
}

// ---------- Associated Categories ----------
try {
    $stmt = $pdo->prepare("
        SELECT fc.category_id, fc.category_name, fc.description, fc.created_at
        FROM food_categories fc
        INNER JOIN branch_categories bc ON fc.category_id = bc.category_id
        WHERE bc.branch_id = :branch_id
        ORDER BY fc.created_at DESC
    ");
    $stmt->execute(['branch_id' => $branch_id]);
    $categories = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching categories: " . h($e->getMessage());
    $categories = [];
}

// ---------- Associated Foods ----------
try {
    $stmt = $pdo->prepare("
        SELECT f.food_id, f.food_name, f.description, f.price, f.offer, f.is_offer, f.image_url,
               bf.status AS branch_food_status,
               f.created_at, fc.category_name
        FROM foods f
        INNER JOIN branch_foods bf ON f.food_id = bf.food_id
        LEFT JOIN food_categories fc ON f.category_id = fc.category_id
        WHERE bf.branch_id = :branch_id
        ORDER BY f.created_at DESC
    ");
    $stmt->execute(['branch_id' => $branch_id]);
    $foods = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching foods: " . h($e->getMessage());
    $foods = [];
}

// ---------- DataTables + Toggle Script ----------
// Replace the $script variable with this updated version
$script = '
<script>
document.addEventListener("DOMContentLoaded", function () {
    try {
        // Helper: Initialize or retrieve DataTable
        function initDataTable(selector, options) {
            const table = document.querySelector(selector);
            if (!table) return;

if ($.fn.DataTable.isDataTable(selector)) {
                $(selector).DataTable().destroy(); // Safely destroy previous instance
            }
            $(selector).DataTable(options);
        }

// Categories Table
        initDataTable("#categoriesTable", {
            responsive: true,
            pageLength: 5,
            language: {
                search: "_INPUT_",
                searchPlaceholder: "Search categories..."
            },
            columnDefs: [{ orderable: false, targets: [] }]
        });

// Foods Table
        initDataTable("#foodsTable", {
            responsive: true,
            pageLength: 5,
            language: {
                search: "_INPUT_",
                searchPlaceholder: "Search foods..."
            },
            columnDefs: [{ orderable: false, targets: [4] }]
        });

// Style search inputs
        document.querySelectorAll(".dataTables_wrapper input[type=\"search\"]").forEach(input => {
            input.classList.add("form-control", "form-control-sm");
            input.style.borderRadius = "0.375rem";
        });

// Toggle food status (unchanged)
        document.querySelectorAll(".toggle-status").forEach(button => {
            button.addEventListener("click", function() {
                const foodId = this.dataset.foodId;
                const branchId = ' . (int)$branch_id . ';
                const isAvailable = this.checked ? 1 : 0;
                const csrfToken = "' . h($csrf) . '";

} catch (e) {
        console.error("DataTable init error:", e);
    }
});
</script>';
?>
<?php include './partials/layouts/layoutTop.php'; ?>

<div class="dashboard-main-body">
    <div class="d-flex flex-wrap align-items-center justify-content-between gap-3 mb-24">
        <h6 class="fw-semibold mb-0">
            Branch Details: <?= h($branch['branch_name']); ?>
            <span class="badge bg-secondary ms-1">
                <?= count($categories); ?> Categories, <?= count($foods); ?> Foods
            </span>
            <?php if ($branch['third_party']): ?>
                <span class="badge bg-warning text-dark ms-1">Third-Party</span>
            <?php endif; ?>
        </h6>
        <ul class="d-flex align-items-center gap-2">
            <li class="fw-medium">
                <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-lg"></iconify-icon>
                    Dashboard
                </a>
            </li>
            <li>-</li>
            <li class="fw-medium"><a href="branches.php" class="hover-text-primary">Branches</a></li>
            <li>-</li>
            <li class="fw-medium">View Branch</li>
        </ul>
    </div>

<?php if (!empty($_SESSION['error'])): ?>
        <div class="alert alert-danger alert-dismissible fade show mb-24">
            <?= h($_SESSION['error']); unset($_SESSION['error']); ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    <?php endif; ?>

<div class="card border">
        <div class="card-body p-24">
            <h6 class="section-title text-lg mb-16">Branch Information</h6>
            <div class="row gy-4">
                
                <div class="col-md-4 text-center">
                    <?php if (!empty($branch['image_url'])): ?>
                        <img src="<?= h($branch['image_url']); ?>"
                             alt="<?= h($branch['branch_name']); ?>"
                             class="img-fluid rounded-3 shadow-sm mb-3"
                             style="max-height: 200px; width: auto;">
                    <?php else: ?>
                        <p class="text-muted">No Branch Image</p>
                    <?php endif; ?>

<?php if ($branch['third_party'] && !empty($branch['logo'])): ?>
                        <div class="mt-3">
                            <div class="logo-display mx-auto">
                                <img src="<?= h($branch['logo']); ?>" alt="Branch Logo" class="img-fluid">
                            </div>
                            <small class="text-muted d-block mt-1">Third-Party Logo (16:9)</small>
                        </div>
                    <?php elseif ($branch['third_party']): ?>
                        <div class="mt-3 text-center">
                            <p class="text-warning small">
                                <iconify-icon icon="mdi:alert-circle-outline"></iconify-icon>
                                Logo missing (required for third-party)
                            </p>
                        </div>
                    <?php endif; ?>
                </div>

<div class="col-md-8">
                    <table class="table table-bordered table-sm">
                        <tbody>
                            <tr>
                                <th scope="row" style="width: 30%;">Name</th>
                                <td><span class="badge bg-primary"><?= h($branch['branch_name']); ?></span></td>
                            </tr>
                            <tr>
                                <th scope="row">Address</th>
                                <td><?= h($branch['address'] ?? 'N/A'); ?></td>
                            </tr>
                            <tr>
                                <th scope="row">City</th>
                                <td><?= h($branch['city'] ?? 'N/A'); ?></td>
                            </tr>
                            <tr>
                                <th scope="row">State</th>
                                <td><?= h($branch['state'] ?? 'N/A'); ?></td>
                            </tr>
                            <tr>
                                <th scope="row">Country</th>
                                <td><?= h($branch['country'] ?? 'N/A'); ?></td>
                            </tr>
                            <tr>
                                <th scope="row">Type</th>
                                <td>
                                    <?php if ($branch['third_party']): ?>
                                        <span class="badge bg-warning text-dark">Third-Party (Franchise/Partner)</span>
                                    <?php else: ?>
                                        <span class="badge bg-success">Own Branch</span>
                                    <?php endif; ?>
                                </td>
                            </tr>
                            <tr>
                                <th scope="row">Created</th>
                                <td><?= date('M j, Y, H:i', strtotime($branch['created_at'])); ?></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>

<div class="text-end mt-3">
                <a href="branches.php" class="btn btn-outline-secondary">Back to List</a>
                <a href="edit_branch.php?id=<?= (int)$branch_id; ?>" class="btn btn-primary ms-2">Edit Branch</a>
            </div>
        </div>
    </div>

<div class="card border mt-4">
        <div class="card-body p-24">
            <h6 class="section-title text-lg mb-16 d-inline">Associated Categories</h6>
            <span class="badge bg-secondary ms-2"><?= count($categories); ?></span>
            <div class="table-responsive mt-3">
                <table class="table table-bordered table-sm" id="categoriesTable">
                    <thead>
                        <tr>
                            <th>Name</th>
                            <th>Description</th>
                            <th>Created</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php if (empty($categories)): ?>
                            <tr><td colspan="3" class="text-center">No categories found.</td></tr>
                        <?php else: foreach ($categories as $c): ?>
                            <tr>
                                <td>
                                    <a href="view_category.php?id=<?= (int)$c['category_id']; ?>" class="text-primary-600">
                                        <span class="badge bg-primary"><?= h($c['category_name']); ?></span>
                                    </a>
                                </td>
                                <td><?= h($c['description'] ?? 'N/A'); ?></td>
                                <td><?= date('M j, Y', strtotime($c['created_at'])); ?></td>
                            </tr>
                        <?php endforeach; endif; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

<div class="card border mt-4">
        <div class="card-body p-24">
            <h6 class="section-title text-lg mb-16 d-inline">Associated Foods</h6>
            <span class="badge bg-secondary ms-2"><?= count($foods); ?></span>
            <div class="table-responsive mt-3">
                <table class="table table-bordered table-sm" id="foodsTable">
                    <thead>
                        <tr>
                            <th>Food</th>
                            <th>Category</th>
                            <th>Price</th>
                            <th>Availability</th>
                            <th>Created</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php if (empty($foods)): ?>
                            <tr><td colspan="5" class="text-center">No foods found.</td></tr>
                        <?php else: foreach ($foods as $f): ?>
                            <tr>
                                <td>
                                    <div class="d-flex align-items-center position-relative">
                                        <img src="<?= h(!empty($f['image_url']) ? '../' . $f['image_url'] : 'assets/images/food/default.png'); ?>"
                                             alt="" class="flex-shrink-0 me-12 radius-8" style="width:40px;height:40px;">
                                        <?php if ($f['is_offer'] && $f['offer']): ?>
                                            <span class="badge bg-success text-white position-absolute"
                                                  style="top:-10px;right:5px;font-size:0.65rem;">
                                                <?= (int)$f['offer']; ?>% OFF
                                            </span>
                                        <?php endif; ?>
                                        <div class="flex-grow-1">
                                            <h6 class="text-md mb-0 fw-medium">
                                                <a href="view_food.php?id=<?= (int)$f['food_id']; ?>" class="text-primary-600">
                                                    <span class="badge bg-primary"><?= h($f['food_name']); ?></span>
                                                </a>
                                            </h6>
                                            <span class="text-sm text-secondary fw-medium"><?= h($f['description'] ?? 'N/A'); ?></span>
                                        </div>
                                    </div>
                                </td>
                                <td><span class="badge bg-primary"><?= h($f['category_name'] ?? 'N/A'); ?></span></td>
                                <td>₹<?= number_format($f['price'], 2); ?></td>
                                <td>
                                    <div class="form-switch">
                                        <input class="form-check-input toggle-status" type="checkbox"
                                               data-food-id="<?= (int)$f['food_id']; ?>"
                                               <?= $f['branch_food_status'] === 'active' ? 'checked' : ''; ?>>
                                    </div>
                                </td>
                                <td><?= date('M j, Y', strtotime($f['created_at'])); ?></td>
                            </tr>
                        <?php endforeach; endif; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<?php include './partials/layouts/layoutBottom.php'; ?>
<?= $script; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view_branch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation