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.3.30

User:

u231988116

Directory:

/home/u231988116/domains/ominteriorstudio.in/public_html/crm

Free Space:

7.42 TB

🔧 Quick Actions

✏️ Editing: projectlist.php

<?php
session_start();
require_once 'db.php';

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    header('Location: signin');
    exit();
}

// Verify role-based access
checkAccess();

$user_id = $_SESSION['user_id'];
$user_name = $_SESSION['user_name'] ?? 'User';

// Handle AJAX request for project details
if (isset($_GET['action']) && $_GET['action'] === 'get_project_details' && isset($_GET['id'])) {
    header('Content-Type: application/json');
    try {
        $project_id = intval($_GET['id']);
        
        $stmt = mysqli_prepare($conn, "
            SELECT p.*, c.client_name, u.name as manager_name
            FROM projects p
            JOIN clients c ON p.client_id = c.id
            JOIN users u ON p.created_by_user_id = u.id
            WHERE p.id = ?
        ");
        
        mysqli_stmt_bind_param($stmt, "i", $project_id);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        $project = mysqli_fetch_assoc($result);
        mysqli_stmt_close($stmt);

if ($project) {
            echo json_encode(['success' => true, 'data' => $project]);
        } else {
            throw new Exception("Project not found or access denied.");
        }
    } catch (Exception $e) {
        echo json_encode(['success' => false, 'message' => $e->getMessage()]);
    }
    exit();
}

// Fetch all projects for the table
$projects = [];
try {
    $stmt = mysqli_prepare($conn, "
        SELECT p.id, p.project_name, c.client_name, p.status, p.start_date, p.document_file
        FROM projects p
        JOIN clients c ON p.client_id = c.id
        ORDER BY p.created_at DESC
    ");
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $projects = mysqli_fetch_all($result, MYSQLI_ASSOC);
    mysqli_stmt_close($stmt);
} catch (Exception $e) {
    // Silently handle
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Project List - ConstructCRM</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.css">
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    <style>
        :root {
            --primary-color: #977C49;
            --primary-dark: #7a633a;
            --primary-light: #f8f5ef;
            --secondary-color: #343a40;
            --success-color: #28a745;
            --info-color: #17a2b8;
            --warning-color: #ffc107;
            --danger-color: #dc3545;
            --light-color: #f8f9fa;
            --dark-color: #343a40;
            --nav-width: 260px;
            --header-height: 70px;
            --border-radius: 12px;
            --box-shadow: 0 4px 12px rgba(0, 0, 0, 0.08);
            --transition: all 0.3s cubic-bezier(0.4, 0, 0.2, 1);
        }
body {
        font-family: 'Inter', sans-serif;
        background-color: #f5f7fa;
        color: #333;
        font-size: 14px;
        line-height: 1.4;
        overflow-x: hidden;
    }

/* Header */
    .header {
        background-color: #fff;
        box-shadow: 0 2px 10px rgba(0, 0, 0, 0.05);
        position: fixed;
        top: 0;
        left: 0;
        right: 0;
        height: var(--header-height);
        z-index: 1000;
        display: flex;
        align-items: center;
        padding: 0 20px;
    }

.logo {
        display: flex;
        align-items: center;
        font-weight: 700;
        font-size: 20px;
        color: var(--primary-color);
        text-decoration: none;
    }

.logo i {
        font-size: 24px;
        margin-right: 10px;
    }

.header-actions {
        margin-left: auto;
        display: flex;
        align-items: center;
    }

.mobile-menu-toggle {
        display: none;
        background: none;
        border: none;
        font-size: 24px;
        color: var(--primary-color);
        margin-right: 15px;
        cursor: pointer;
    }

/* User Dropdown */
    .user-dropdown {
        position: relative;
    }

.user-profile {
        display: flex;
        align-items: center;
        cursor: pointer;
        padding: 5px 10px;
        border-radius: var(--border-radius);
        transition: var(--transition);
    }

.user-profile:hover {
        background-color: #f8f9fa;
    }

.user-avatar {
        width: 36px;
        height: 36px;
        border-radius: 50%;
        background-color: var(--primary-color);
        color: white;
        display: flex;
        align-items: center;
        justify-content: center;
        font-weight: 600;
        margin-right: 10px;
    }

.user-name {
        font-weight: 500;
        margin-right: 5px;
    }

.dropdown-arrow {
        font-size: 12px;
        color: #666;
        transition: var(--transition);
    }

.user-dropdown.show .dropdown-arrow {
        transform: rotate(180deg);
    }

.user-dropdown-menu {
        position: absolute;
        top: 100%;
        right: 0;
        background-color: #fff;
        border-radius: var(--border-radius);
        box-shadow: 0 5px 15px rgba(0, 0, 0, 0.1);
        min-width: 180px;
        padding: 8px 0;
        margin-top: 5px;
        opacity: 0;
        visibility: hidden;
        transform: translateY(-10px);
        transition: var(--transition);
        z-index: 1001;
    }

.user-dropdown.show .user-dropdown-menu {
        opacity: 1;
        visibility: visible;
        transform: translateY(0);
    }

.dropdown-item {
        display: flex;
        align-items: center;
        padding: 10px 20px;
        color: #555;
        text-decoration: none;
        transition: var(--transition);
    }

.dropdown-item:hover {
        background-color: #f8f9fa;
        color: var(--primary-color);
    }

.dropdown-item i {
        margin-right: 10px;
        font-size: 16px;
    }

.dropdown-divider {
        height: 1px;
        background-color: #eee;
        margin: 8px 0;
    }

/* Main Layout */
    .main-container {
        display: flex;
        min-height: calc(100vh - var(--header-height));
        margin-top: var(--header-height);
    }

/* Sidebar Navigation */
    .sidebar-nav {
        width: var(--nav-width);
        background-color: #fff;
        box-shadow: 2px 0 10px rgba(0, 0, 0, 0.05);
        position: fixed;
        top: var(--header-height);
        left: 0;
        bottom: 0;
        z-index: 999;
        overflow-y: auto;
        transition: var(--transition);
    }

.nav-section {
        padding: 15px 0;
    }

.nav-section:last-child {
        padding-bottom: 20px;
    }

.nav-title {
        font-size: 11px;
        font-weight: 600;
        text-transform: uppercase;
        letter-spacing: 0.5px;
        color: #999;
        padding: 0 20px;
        margin-bottom: 10px;
    }

.nav-list {
        list-style: none;
    }

.nav-item {
        margin-bottom: 5px;
    }

.nav-link {
        display: flex;
        align-items: center;
        padding: 12px 20px;
        color: #555;
        text-decoration: none;
        font-weight: 500;
        transition: var(--transition);
        position: relative;
    }

.nav-link i {
        font-size: 18px;
        margin-right: 12px;
        width: 20px;
        text-align: center;
    }

.nav-link:hover {
        background-color: rgba(151, 124, 73, 0.05);
        color: var(--primary-color);
    }

.nav-link.active {
        background-color: rgba(151, 124, 73, 0.1);
        color: var(--primary-color);
    }

.nav-link.active::before {
        content: '';
        position: absolute;
        left: 0;
        top: 0;
        bottom: 0;
        width: 4px;
        background-color: var(--primary-color);
    }

.content-wrapper { flex: 1; margin-left: var(--nav-width); display: flex; flex-direction: column; transition: var(--transition); }
        .main-content { flex: 1; padding: 30px; overflow-y: auto; }
        .page-title { font-size: 24px; font-weight: 600; margin-bottom: 20px; }

/* Page Controls */
        .page-controls {
            background: #fff;
            border-radius: var(--border-radius);
            box-shadow: var(--box-shadow);
            padding: 20px;
            margin-bottom: 30px;
            display: flex;
            align-items: center;
            justify-content: space-between;
            flex-wrap: wrap;
            gap: 15px;
        }

.search-container { position: relative; flex: 1; max-width: 350px; }
        .search-input { width: 100%; padding: 10px 15px 10px 40px; border: 1px solid #ddd; border-radius: 50px; font-size: 13px; }
        .search-icon { position: absolute; left: 15px; top: 50%; transform: translateY(-50%); color: #999; }

.filter-container { display: flex; align-items: center; gap: 12px; }
        .filter-select { padding: 8px 12px; border: 1px solid #ddd; border-radius: 8px; font-size: 13px; background: #fff; min-width: 140px; }

/* View Toggle */
        .view-toggle { display: flex; background-color: #f1f1f1; border-radius: 10px; padding: 4px; }
        .view-option { 
            padding: 6px 12px; border: none; background: none; color: #666; font-size: 13px; 
            font-weight: 500; cursor: pointer; border-radius: 8px; transition: var(--transition);
            display: flex; align-items: center; gap: 5px;
        }
        .view-option.active { background-color: #fff; color: var(--primary-color); box-shadow: 0 2px 5px rgba(0,0,0,0.1); }

/* Grid View Cards */
        .projects-container { display: grid; grid-template-columns: repeat(auto-fill, minmax(320px, 1fr)); gap: 25px; }
        
        .project-card { 
            background: #fff; border-radius: var(--border-radius); box-shadow: var(--box-shadow); 
            overflow: hidden; transition: var(--transition); border-top: 4px solid var(--primary-color);
            display: flex; flex-direction: column;
        }
        .project-card:hover { transform: translateY(-5px); box-shadow: 0 8px 20px rgba(0,0,0,0.12); }
        
        .project-card-header { padding: 20px; border-bottom: 1px solid #f5f5f5; position: relative; }
        .project-card-id { font-size: 11px; font-weight: 700; color: #999; margin-bottom: 5px; text-transform: uppercase; }
        .project-card-title { font-size: 18px; font-weight: 600; color: var(--secondary-color); margin-bottom: 10px; }
        
        .project-card-body { padding: 20px; flex-grow: 1; }
        .info-item { display: flex; align-items: center; gap: 10px; margin-bottom: 12px; font-size: 13px; color: #555; }
        .info-item i { color: var(--primary-color); width: 16px; text-align: center; }
        
        .project-card-footer { padding: 15px 20px; background-color: #fafafa; border-top: 1px solid #f0f0f0; display: flex; gap: 10px; }
        .project-card-footer .btn { flex: 1; justify-content: center; }

/* List View Adjustment */
        .list-view-table { background: #fff; border-radius: var(--border-radius); overflow: hidden; box-shadow: var(--box-shadow); }

.card { border: none; border-radius: var(--border-radius); box-shadow: var(--box-shadow); }
        .table thead th { background-color: var(--primary-light); color: var(--primary-dark); border: none; padding: 15px; font-size: 13px; text-transform: uppercase; letter-spacing: 0.5px; }
        .table tbody td { padding: 15px; vertical-align: middle; border-bottom: 1px solid #eee; }
        
        .badge-status { padding: 6px 12px; border-radius: 20px; font-size: 12px; font-weight: 500; }
        .status-planning { background-color: #e3f2fd; color: #1976d2; }
        .status-active { background-color: #e8f5e9; color: #388e3c; }
        .status-completed { background-color: #f3e5f5; color: #7b1fa2; }
        .btn-primary {
            background-color: var(--primary-color);
            border-color: var(--primary-color);
            color: white;
            transition: 0.3s;
        }

.btn-primary:hover {
            background-color: var(--primary-dark);
            border-color: var(--primary-dark);
            color: white;
            transform: translateY(-2px);
            box-shadow: 0 4px 8px rgba(151, 124, 73, 0.3);
        }
        .btn-action { border-radius: 8px; font-size: 13px; font-weight: 500; margin-right: 5px; }
        .btn-view { background-color: var(--primary-color); color: white; }
        .btn-view:hover { background-color: var(--primary-dark); color: white; }
        .btn-doc { border: 1px solid var(--primary-color); color: var(--primary-color); }
        .btn-doc:hover { background-color: var(--primary-light); }

/* Modal Styling */
        .modal-header { background-color: var(--primary-color); color: white; border: none; }
        .modal-title { font-weight: 600; }
        .detail-row { display: flex; padding: 10px 0; border-bottom: 1px solid #f0f0f0; }
        .detail-label { font-weight: 600; width: 150px; color: #666; }
        .detail-value { flex: 1; }

/* Overlay for mobile menu */
        .overlay {
            display: none;
            position: fixed;
            top: 0;
            left: 0;
            right: 0;
            bottom: 0;
            background-color: rgba(0, 0, 0, 0.5);
            z-index: 998;
        }

.overlay.show {
            display: block;
        }

@media (max-width: 768px) {
            .mobile-menu-toggle { display: block; }
            .sidebar-nav { transform: translateX(-100%); width: 280px; z-index: 1001; }
            .sidebar-nav.show { transform: translateX(0); }
            .content-wrapper { margin-left: 0; padding: 20px; }
            .user-name { display: none; }
            .user-avatar { width: 32px; height: 32px; font-size: 14px; }
            .header { padding: 0 15px; }
            .logo { font-size: 18px; }
            .logo i { font-size: 20px; }

.page-controls { flex-direction: column; align-items: stretch; }
            .search-container { max-width: 100%; }
            .filter-container { flex-direction: column; align-items: stretch; }
            .view-toggle { justify-content: center; }
        }

/* Status Colors */
        .status-planning { background-color: #e3f2fd; color: #1976d2; }
        .status-active { background-color: #e8f5e9; color: #388e3c; }
        .status-completed { background-color: #f3e5f5; color: #7b1fa2; }
        .status-on-hold { background-color: #fff3e0; color: #f57c00; }
        .status-cancelled { background-color: #ffebee; color: #d32f2f; }

.empty-state { text-align: center; padding: 60px 20px; color: #999; }
        .empty-state i { font-size: 48px; margin-bottom: 15px; }
        .empty-state h3 { font-size: 18px; margin-bottom: 5px; color: #666; }

</style>
</head>
<body>
    
    <header class="header">
        <button class="mobile-menu-toggle" id="mobileMenuToggle">
            <i class="bi bi-list"></i>
        </button>
        <a href="crmdashboard" class="logo">
            <img src="./assets/logo.png" alt="ConstructCRM Logo" style="height: 60px; width: 85px;">
        </a>
        <div class="header-actions">
            
            <div class="user-dropdown" id="userDropdown">
                <div class="user-profile" id="userProfile">
                    <div class="user-avatar"><?php echo strtoupper(substr($user_name, 0, 1)); ?></div>
                    <span class="user-name"><?php echo htmlspecialchars($user_name); ?></span>
                    <i class="bi bi-chevron-down dropdown-arrow"></i>
                </div>
                <div class="user-dropdown-menu">
                    <a href="profile" class="dropdown-item">
                        <i class="bi bi-person"></i>
                        <span>Profile</span>
                    </a>
                    <a href="settings" class="dropdown-item">
                        <i class="bi bi-gear"></i>
                        <span>Settings</span>
                    </a>
                    <div class="dropdown-divider"></div>
                    <a href="signin?logout=true" class="dropdown-item">
                        <i class="bi bi-box-arrow-right"></i>
                        <span>Logout</span>
                    </a>
                </div>
            </div>
        </div>
    </header>

<nav class="sidebar-nav" id="sidebarNav">
            <div class="nav-section">
                <div class="nav-title">Main</div>
                <ul class="nav-list">
                    <?php if (($_SESSION['user_role'] ?? '') === 'Admin'): ?>
                    <li class="nav-item">
                        <a href="crmdashboard" class="nav-link">
                            <i class="bi bi-speedometer2"></i>
                            <span>Dashboard</span>
                        </a>
                    </li>
                    <?php endif; ?>
                    <li class="nav-item">
                        <a href="dashboard" class="nav-link">
                            <i class="bi bi-grid-1x2-fill"></i>
                            <span>Client</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="projectlist" class="nav-link active">
                            <i class="bi bi-list-ul"></i>
                            <span>Project List</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="designimages" class="nav-link">
                            <i class="bi bi-palette-fill"></i>
                            <span>Design images</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="assignmentcalendar" class="nav-link">
                            <i class="bi bi-calendar-event-fill"></i>
                            <span>Assignment Calendar</span>
                        </a>
                    </li>
                    <?php if (($_SESSION['user_role'] ?? '') === 'Admin'): ?>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>place_order" class="nav-link">
                            <i class="bi bi-cart-check"></i> 
                            <span>Place Order</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="financetracker" class="nav-link">
                            <i class="bi bi-cash-stack"></i>
                            <span>Finance Tracker</span>
                        </a>
                    </li>
                    <?php endif; ?>
                    <li class="nav-item">
                        <a href="imagepin" class="nav-link">
                            <i class="bi bi-pin-map-fill"></i>
                            <span>Image Pin & Comment</span>
                        </a>
                    </li>
                    <?php if (($_SESSION['user_role'] ?? '') === 'Admin'): ?>
                    <li class="nav-item">
                        <a href="designcost" class="nav-link">
                            <i class="bi bi-palette-fill"></i>
                            <span>Designs Cost</span>
                        </a>
                    </li>
                    <?php endif; ?>
                </ul>
            </div>
            
            <div class="nav-section">
                <div class="nav-title">Management</div>
                <ul class="nav-list">
                    <li class="nav-item">
                        <a href="taskmanager" class="nav-link">
                            <i class="bi bi-check2-square"></i>
                            <span>Task Manager</span>
                        </a>
                    </li>
                    <?php if (($_SESSION['user_role'] ?? '') === 'Admin'): ?>
                    <li class="nav-item">
                        <a href="users" class="nav-link">
                            <i class="bi bi-people-fill"></i>
                            <span>Users</span>
                        </a>
                    </li>
                    <?php endif; ?>
                </ul>
            </div>
            
            <?php if (($_SESSION['user_role'] ?? '') === 'Admin'): ?>
            <div class="nav-section">
                <div class="nav-title">Vendor Management</div>
                <ul class="nav-list">
                    <li class="nav-item">
                        <a href="addvendors" class="nav-link">
                            <i class="bi bi-person-plus-fill"></i>
                            <span>Add New Vendor</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="viewvendors" class="nav-link">
                            <i class="bi bi-card-list"></i>
                            <span>View All Vendors</span>
                        </a>
                    </li>
                </ul>
            </div>
            <?php endif; ?>
        </nav>

<div class="content-wrapper">
        <div class="main-content">
            <h1 class="page-title">Project Directory</h1>
            
            
            <div class="page-controls">
                <div class="search-container">
                    <i class="bi bi-search search-icon"></i>
                    <input type="text" class="search-input" id="projectSearch" placeholder="Search projects or clients...">
                </div>
                
                <div class="filter-container">
                    <div class="view-toggle">
                        <button class="view-option active" data-view="grid">
                            <i class="bi bi-grid-3x3-gap"></i> Grid
                        </button>
                        <button class="view-option" data-view="list">
                            <i class="bi bi-list-ul"></i> List
                        </button>
                    </div>
                    
                    <select class="filter-select" id="statusFilter">
                        <option value="">All Statuses</option>
                        <option value="Planning">Planning</option>
                        <option value="Active">Active</option>
                        <option value="Completed">Completed</option>
                        <option value="On Hold">On Hold</option>
                        <option value="Cancelled">Cancelled</option>
                    </select>
                    
                    <a href="dashboard" class="btn btn-primary">
                        <i class="bi bi-plus-lg"></i> Add New Project
                    </a>
                </div>
            </div>

<div id="projectsContainer">
                
            </div>
        </div>
    </div>
    </div>

<div class="modal fade" id="detailsModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title"><i class="bi bi-info-circle me-2"></i>Project Details</h5>
                    <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body p-4" id="modalContent">
                    <div class="text-center py-4">
                        <div class="spinner-border text-primary" role="status"></div>
                        <p class="mt-2 text-muted">Loading project data...</p>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary px-4" data-bs-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>

// Projects data from PHP
        const projectsData = <?php echo json_encode(array_map(function($p) {
            return [
                'id' => $p['id'],
                'name' => $p['project_name'],
                'client' => $p['client_name'],
                'status' => $p['status'],
                'start_date' => $p['start_date'],
                'document' => $p['document_file']
            ];
        }, $projects)); ?>;

let currentView = 'grid';

document.addEventListener('DOMContentLoaded', function () {
            // Mobile menu toggle
            const mobileMenuToggle = document.getElementById('mobileMenuToggle');
            const sidebarNav = document.getElementById('sidebarNav');
            const overlay = document.getElementById('overlay');

if (mobileMenuToggle && sidebarNav && overlay) {
                mobileMenuToggle.addEventListener('click', () => {
                    sidebarNav.classList.toggle('show');
                    overlay.classList.toggle('show');
                });

overlay.addEventListener('click', () => {
                    sidebarNav.classList.remove('show');
                    overlay.classList.remove('show');
                });

// Close sidebar when clicking a nav link on mobile
                document.querySelectorAll('.nav-link').forEach(link => {
                    link.addEventListener('click', () => {
                        if (window.innerWidth <= 768) {
                            sidebarNav.classList.remove('show');
                            overlay.classList.remove('show');
                        }
                    });
                });
            }

// User dropdown toggle
            const userDropdown = document.getElementById('userDropdown');
            const userProfile = document.getElementById('userProfile');

if (userDropdown && userProfile) {
                userProfile.addEventListener('click', (e) => {
                    e.stopPropagation();
                    userDropdown.classList.toggle('show');
                });

// Close dropdown when clicking outside
                document.addEventListener('click', () => {
                    userDropdown.classList.remove('show');
                });
            }

// View toggle and Filter listeners
            document.querySelectorAll('.view-option').forEach(btn => {
                btn.addEventListener('click', function() {
                    document.querySelectorAll('.view-option').forEach(b => b.classList.remove('active'));
                    this.classList.add('active');
                    currentView = this.dataset.view;
                    renderProjects();
                });
            });

document.getElementById('projectSearch').addEventListener('input', renderProjects);
            document.getElementById('statusFilter').addEventListener('change', renderProjects);

// Initial render
            renderProjects();
        });

function renderProjects() {
            const container = document.getElementById('projectsContainer');
            const searchTerm = document.getElementById('projectSearch').value.toLowerCase();
            const statusFilter = document.getElementById('statusFilter').value;

const filtered = projectsData.filter(p => {
                const matchesSearch = p.name.toLowerCase().includes(searchTerm) || p.client.toLowerCase().includes(searchTerm);
                const matchesStatus = statusFilter === "" || p.status === statusFilter;
                return matchesSearch && matchesStatus;
            });

if (filtered.length === 0) {
                container.innerHTML = `
                    <div class="empty-state">
                        <i class="bi bi-folder-x"></i>
                        <h3>No Projects Found</h3>
                        <p>Try adjusting your search or filters.</p>
                    </div>`;
                return;
            }

if (currentView === 'grid') {
                container.innerHTML = `<div class="projects-container">${filtered.map(p => createGridCard(p)).join('')}</div>`;
            } else {
                container.innerHTML = createListView(filtered);
            }
        }

function createGridCard(p) {
            const statusClass = p.status.toLowerCase().replace(/ /g, '-');
            const docBtn = p.document 
                ? `<a href="uploads/projectsuploads/${p.document}" target="_blank" class="btn btn-action btn-doc"><i class="bi bi-file-earmark-pdf"></i> Document</a>`
                : `<button class="btn btn-action btn-doc" disabled><i class="bi bi-file-earmark-x"></i> No Doc</button>`;

return `
                <div class="project-card">
                    <div class="project-card-header">
                        <div class="project-card-id">PRJ-${String(p.id).padStart(3, '0')}</div>
                        <div class="project-card-title">${escapeHtml(p.name)}</div>
                        <span class="badge-status status-${statusClass}">${p.status}</span>
                    </div>
                    <div class="project-card-body">
                        <div class="info-item">
                            <i class="bi bi-person-circle"></i>
                            <span>${escapeHtml(p.client)}</span>
                        </div>
                        <div class="info-item">
                            <i class="bi bi-calendar-event"></i>
                            <span>Starts: ${formatDate(p.start_date)}</span>
                        </div>
                    </div>
                    <div class="project-card-footer">
                        <button class="btn btn-action btn-view" onclick="viewDetails(${p.id})">
                            <i class="bi bi-eye"></i> Details
                        </button>
                        ${docBtn}
                    </div>
                </div>`;
        }

function createListView(projects) {
            return `
                <div class="list-view-table">
                    <div class="table-responsive">
                        <table class="table mb-0">
                            <thead>
                                <tr>
                                    <th>Project Name</th>
                                    <th>Client Name</th>
                                    <th>Status</th>
                                    <th>Start Date</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                ${projects.map(p => `
                                    <tr>
                                        <td class="fw-semibold">${escapeHtml(p.name)}</td>
                                        <td>${escapeHtml(p.client)}</td>
                                        <td>
                                            <span class="badge-status status-${p.status.toLowerCase().replace(/ /g, '-')}">
                                                ${p.status}
                                            </span>
                                        </td>
                                        <td>${formatDate(p.start_date)}</td>
                                        <td>
                                            <button class="btn btn-action btn-view" onclick="viewDetails(${p.id})">
                                                <i class="bi bi-eye"></i> Details
                                            </button>
                                            ${p.document 
                                                ? `<a href="uploads/projectsuploads/${p.document}" target="_blank" class="btn btn-action btn-doc"><i class="bi bi-file-earmark-pdf"></i> Doc</a>`
                                                : `<button class="btn btn-action btn-doc" disabled><i class="bi bi-file-earmark-x"></i> No Doc</button>`
                                            }
                                        </td>
                                    </tr>
                                `).join('')}
                            </tbody>
                        </table>
                    </div>
                </div>`;
        }

async function viewDetails(id) {
            detailsModal.show();
            modalContent.innerHTML = `
                <div class="text-center py-4">
                    <div class="spinner-border text-primary" role="status"></div>
                    <p class="mt-2 text-muted">Fetching project details...</p>
                </div>
            `;

try {
                const response = await fetch(`projectlist.php?action=get_project_details&id=${id}`);
                const result = await response.json();

if (result.success) {
                    const p = result.data;
                    modalContent.innerHTML = `
                        <div class="row g-4">
                            
                            <div class="col-md-6">
                                <h6 class="text-primary fw-bold mb-3"><i class="bi bi-info-square me-2"></i>Basic Information</h6>
                                <div class="detail-row">
                                    <div class="detail-label">Project Name</div>
                                    <div class="detail-value fw-bold">${escapeHtml(p.project_name)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Client Name</div>
                                    <div class="detail-value">${escapeHtml(p.client_name)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Project Type</div>
                                    <div class="detail-value">${escapeHtml(p.project_type)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Status</div>
                                    <div class="detail-value">
                                        <span class="badge-status status-${p.status.toLowerCase().replace(/ /g, '-')}">
                                            ${p.status}
                                        </span>
                                    </div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Project Area</div>
                                    <div class="detail-value">${new Intl.NumberFormat('en-IN').format(p.project_area)} SQFT</div>
                                </div>
                            </div>

<div class="col-md-6">
                                <h6 class="text-primary fw-bold mb-3"><i class="bi bi-currency-dollar me-2"></i>Finance & Management</h6>
                                <div class="detail-row">
                                    <div class="detail-label">Budget</div>
                                    <div class="detail-value fw-bold text-success">₹${new Intl.NumberFormat('en-IN').format(p.project_estimate)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Project Manager</div>
                                    <div class="detail-value">${escapeHtml(p.manager_name)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Record Created</div>
                                    <div class="detail-value text-muted small">${formatDate(p.created_at)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Last Modified</div>
                                    <div class="detail-value text-muted small">${formatDate(p.updated_at)}</div>
                                </div>
                            </div>

<div class="col-md-6">
                                <h6 class="text-primary fw-bold mb-3"><i class="bi bi-calendar-event me-2"></i>Project Timeline</h6>
                                <div class="detail-row">
                                    <div class="detail-label">Created Date</div>
                                    <div class="detail-value">${formatDate(p.created_date)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Recce Due Date</div>
                                    <div class="detail-value">${formatDate(p.recce_due_date)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Start Date</div>
                                    <div class="detail-value">${formatDate(p.start_date)}</div>
                                </div>
                                <div class="detail-row">
                                    <div class="detail-label">Execution Date</div>
                                    <div class="detail-value">${formatDate(p.execution_date)}</div>
                                </div>
                            </div>

<div class="col-md-6">
                                <h6 class="text-primary fw-bold mb-3"><i class="bi bi-geo-alt me-2"></i>Location</h6>
                                <div class="detail-row border-0">
                                    <div class="detail-label">Address</div>
                                    <div class="detail-value">${escapeHtml(p.project_address)}</div>
                                </div>
                                <div class="detail-row border-0">
                                    <div class="detail-label">City/State</div>
                                    <div class="detail-value">${escapeHtml(p.city)}, ${escapeHtml(p.state)}</div>
                                </div>
                            </div>

<div class="col-12">
                                <h6 class="text-primary fw-bold mb-2"><i class="bi bi-card-text me-2"></i>Project Description / Scope</h6>
                                <div class="p-3 bg-light rounded border" style="white-space: pre-wrap;">${escapeHtml(p.project_scope || 'No description provided.')}</div>
                            </div>
                        </div>
                    `;
                } else {
                    modalContent.innerHTML = `<div class="alert alert-danger">${result.message}</div>`;
                }
            } catch (error) {
                modalContent.innerHTML = `<div class="alert alert-danger">An error occurred while fetching details.</div>`;
            }
        }

function formatDate(dateStr) {
            if (!dateStr) return 'N/A';
            const d = new Date(dateStr);
            return d.toLocaleDateString('en-US', { month: 'short', day: 'numeric', year: 'numeric' });
        }

function escapeHtml(text) {
            const div = document.createElement('div');
            div.textContent = text;
            return div.innerHTML;
        }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: projectlist.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation