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

Free Space:

10.24 TB

🔧 Quick Actions

✏️ Editing: hr-recruitment.php

<?php include '../db.php';

include 'auth.php';

if (!isset($_SESSION['user_id']) || $_SESSION['user_role'] !== 'admin') {
    header("Location: /ems/superadmin/index.php");
    exit();
} ?>
<!DOCTYPE html><html lang="en"><head>
    <meta charset="utf-8">
    <title>CRM | Decconz 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">
        <link rel="shortcut icon" href="../images/dec.jpeg">

<?php include 'super-sidebar.php'; ?>
<?php include 'super-nav.php'; ?>

<h4 class="page-title mb-3">Recruitment Management</h4>

<div class="card mb-4">
                <div class="card-body">
                    <h5 class="card-title">Post a New Job</h5>
                    <form method="POST">
                        <div class="mb-2">
                            <label>Job Title</label>
                            <input type="text" name="job_title" class="form-control" required>
                        </div>
                        <div class="mb-2">
                            <label>Description</label>
                            <textarea name="description" class="form-control" rows="3" required></textarea>
                        </div>
                        <div class="mb-2">
                            <label>Start Date</label>
                            <input type="date" name="start_date" class="form-control" required>
                        </div>
                        <div class="mb-2">
                            <label>End Date</label>
                            <input type="date" name="end_date" class="form-control">
                        </div>
                        <div class="mb-2">
                            <label>Status</label>
                            <select name="status" class="form-control">
                                <option value="active">Active</option>
                                <option value="on_hold">On Hold</option>
                            </select>
                        </div>
                        <button type="submit" name="post_job" class="btn btn-primary">Post Job</button>
                    </form>

<?php
                    if (isset($_POST['post_job'])) {
                        $title = $_POST['job_title'];
                        $desc = $_POST['description'];
                        $start = $_POST['start_date'];
                        $end = $_POST['end_date'];
                        $status = $_POST['status'];

$stmt = $conn->prepare("INSERT INTO projects (name, description, start_date, end_date, status) VALUES (?, ?, ?, ?, ?)");
                        $stmt->bind_param("sssss", $title, $desc, $start, $end, $status);
                        if ($stmt->execute()) {
                            echo '<div class="alert alert-success mt-2">Job posted successfully.</div>';
                        } else {
                            echo '<div class="alert alert-danger mt-2">Error: ' . $conn->error . '</div>';
                        }
                    }
                    ?>
                </div>
            </div>

<div class="card">
                <div class="card-body">
                    <h5 class="card-title">Job Listings</h5>
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Job Title</th>
                                <th>Start</th>
                                <th>End</th>
                                <th>Status</th>
                                <th>Description</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $jobs = $conn->query("SELECT * FROM projects ORDER BY created_at DESC");
                            while ($row = $jobs->fetch_assoc()):
                            ?>
                            <tr>
                                <td><?= htmlspecialchars($row['name']) ?></td>
                                <td><?= $row['start_date'] ?></td>
                                <td><?= $row['end_date'] ?? '-' ?></td>
                                <td><?= ucfirst($row['status']) ?></td>
                                <td><?= substr($row['description'], 0, 100) ?>...</td>
                            </tr>
                            <?php endwhile; ?>
                        </tbody>
                    </table>
                </div>
            </div>

<div class="card mt-4">
                <div class="card-body">
                    <h5 class="card-title">Applicants</h5>
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Job Title</th>
                                <th>Applicant</th>
                                <th>CV</th>
                                <th>Status</th>
                                <th>Update Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $query = "
                                SELECT 
                                    d.id as doc_id,
                                    p.name as job_title,
                                    u.id as user_id,
                                    u.name as applicant_name,
                                    d.file_path
                                FROM documents d
                                JOIN users u ON d.uploaded_by = u.id
                                JOIN projects p ON d.project_id = p.id
                                WHERE d.file_type = 'cv'
                                ORDER BY d.uploaded_at DESC
                            ";

$result = $conn->query($query);
                            while ($row = $result->fetch_assoc()):
                                $uid = $row['user_id'];
                                $statusRes = $conn->query("SELECT body FROM messages WHERE receiver_id = $uid AND subject = 'Status Update' ORDER BY created_at DESC LIMIT 1");
                                $statusRow = $statusRes->fetch_assoc();
                                $currentStatus = $statusRow['body'] ?? 'Applied';
                            ?>
                            <tr>
                                <td><?= htmlspecialchars($row['job_title']) ?></td>
                                <td><?= htmlspecialchars($row['applicant_name']) ?></td>
                                <td><a href="<?= $row['file_path'] ?>" target="_blank">View CV</a></td>
                                <td><?= htmlspecialchars($currentStatus) ?></td>
                                <td>
                                    <form method="POST" class="d-flex">
                                        <input type="hidden" name="user_id" value="<?= $uid ?>">
                                        <select name="new_status" class="form-control me-2">
                                            <?php
                                            $statuses = ['Applied', 'Shortlisted', 'Hired', 'Rejected'];
                                            foreach ($statuses as $status):
                                            ?>
                                                <option value="<?= $status ?>" <?= $currentStatus == $status ? 'selected' : '' ?>><?= $status ?></option>
                                            <?php endforeach; ?>
                                        </select>
                                        <button type="submit" name="update_status" class="btn btn-sm btn-primary ms-1">Update</button>
                                    </form>
                                </td>
                            </tr>
                            <?php endwhile; ?>
                        </tbody>
                    </table>

<?php
                    if (isset($_POST['update_status'])) {
                        $uid = $_POST['user_id'];
                        $new_status = $_POST['new_status'];
                        $sender_id = 1;
                        $subject = "Status Update";
                        $stmt = $conn->prepare("INSERT INTO messages (sender_id, receiver_id, subject, body, status) VALUES (?, ?, ?, ?, 'unread')");
                        $stmt->bind_param("iiss", $sender_id, $uid, $subject, $new_status);
                        $stmt->execute();
                        echo "<meta http-equiv='refresh' content='1'>";
                    }
                    ?>
                </div>
            </div>

<div class="card mt-4">
                <div class="card-body">
                    <h5 class="card-title">Interview Notes & Communication</h5>
                    <form method="POST">
                        <div class="mb-2">
                            <label>Select Applicant</label>
                            <select name="to_user_id" class="form-control" required>
                                <option value="">Select</option>
                                <?php
                                $users = $conn->query("SELECT id, name FROM users ORDER BY name ASC");
                                while ($u = $users->fetch_assoc()):
                                ?>
                                <option value="<?= $u['id'] ?>"><?= htmlspecialchars($u['name']) ?></option>
                                <?php endwhile; ?>
                            </select>
                        </div>
                        <div class="mb-2">
                            <label>Message / Note</label>
                            <textarea name="message_text" class="form-control" rows="3" required></textarea>
                        </div>
                        <button type="submit" name="send_message" class="btn btn-success">Add Note</button>
                    </form>

<?php
                    if (isset($_POST['send_message'])) {
                        $to = $_POST['to_user_id'];
                        $msg = $_POST['message_text'];
                        $from = 1;
                        $stmt = $conn->prepare("INSERT INTO messages (sender_id, receiver_id, subject, body) VALUES (?, ?, 'Interview Note', ?)");
                        $stmt->bind_param("iis", $from, $to, $msg);
                        $stmt->execute();
                        echo '<div class="alert alert-success mt-2">Note added.</div>';
                    }
                    ?>

<hr>
                    <h6 class="mt-3">Recent Notes</h6>
                    <ul class="list-group">
                        <?php
                        $msgs = $conn->query("
                            SELECT m.body, m.created_at, u.name as to_name
                            FROM messages m
                            JOIN users u ON m.receiver_id = u.id
                            WHERE m.subject = 'Interview Note'
                            ORDER BY m.created_at DESC
                            LIMIT 10
                        ");
                        while ($m = $msgs->fetch_assoc()):
                        ?>
                        <li class="list-group-item">
                            <strong><?= htmlspecialchars($m['to_name']) ?>:</strong>
                            <?= htmlspecialchars($m['body']) ?>
                            <small class="text-muted float-end"><?= $m['created_at'] ?></small>
                        </li>
                        <?php endwhile; ?>
                    </ul>
                </div>
            </div>

</div> 
    </div> 
</div> 
</div>

</body></html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: hr-recruitment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation