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/hifi11.in/public_html/vsenthur/admin

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: table-qr.php

<?php
session_start();
date_default_timezone_set('Asia/Kolkata'); // 🕒 Indian Standard Time
require_once 'config/db_config.php';

// Validate session
// if (!isset($_SESSION['user_id']) || !isset($_SESSION['role']) || $_SESSION['role'] !== 'branch' || !isset($_SESSION['branch_id'])) {
//     header("Location: login.php");
//     exit();
// }

include './partials/layouts/layoutTop.php';
?>
<style>
    .fa-icon {font-size:16px;margin-right:4px;}
    @media (max-width:768px){.dashboard-main-body{padding-bottom:80px;}}
    .status-select{font-size:0.85rem;padding:0.25rem 0.5rem;border-radius:4px;border:1px solid #ced4da;cursor:pointer;}
    .status-select:focus{outline:none;border-color:#4361ee;box-shadow:0 0 0 .2rem rgba(67,97,238,.25);}
    .gst-badge{font-size:0.75rem;padding:.25em .5em;}
    .loading{display:inline-block;width:16px;height:16px;border:2px solid #fff;border-top-color:#4361ee;border-radius:50%;animation:spin 1s ease-in-out infinite;}
    @keyframes spin{to{transform:rotate(360deg);}}
    .tooltip-inner{font-size:0.9rem;padding:8px 12px;border-radius:4px;}
    .tooltip-success .tooltip-inner{background:#d4edda;color:#155724;border:1px solid #c3e6cb;}
    .tooltip-danger .tooltip-inner{background:#f8d7da;color:#721c24;border:1px solid #f5c6cb;}
    .delete-btn{cursor:pointer;}
</style>

<?php
// Build query with filters
$query = "
    SELECT o.order_id, o.customer_name, o.customer_contact, o.order_date,
           o.total_amount, o.status, o.payment_method, o.is_gst_active,
           COUNT(oi.item_id) as item_count
    FROM orders o
    LEFT JOIN order_items oi ON o.order_id = oi.order_id
    WHERE o.branch_id = :branch_id
";
$params = [':branch_id' => $branch_id];

if (!empty($date_filter)) {
    $query .= " AND DATE(o.order_date) = :order_date";
    $params[':order_date'] = $date_filter;
}
if (!empty($search_term)) {
    $query .= " AND (o.customer_name LIKE :search_name OR o.customer_contact LIKE :search_contact)";
    $params[':search_name'] = "%$search_term%";
    $params[':search_contact'] = "%$search_term%";
}

$query .= " GROUP BY o.order_id ORDER BY o.order_date DESC";

try {
    $stmt = $pdo->prepare($query);
    $stmt->execute($params);
    $orders = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    $errors[] = "Error fetching orders: " . htmlspecialchars($e->getMessage());
    error_log("SQL Error: " . $e->getMessage());
}
?>

<h5>Table QR Codes (100% Working)</h5>
    <div class="grid" id="grid"></div>
</div>
    <?php include './partials/layouts/layoutBottom.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: table-qr.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation