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/ems/admin

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: generate_reports.php

<?php
include('config/db.php');
include('includes/header.php');  // Include your header or navigation links

// Get form data
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';
$employee_id = isset($_GET['employee']) ? $_GET['employee'] : '';
$location = isset($_GET['location']) ? $_GET['location'] : '';

// Query to fetch data based on filter criteria
$attendance_query = "SELECT e.name, a.date, a.status, a.check_in, a.check_out, a.approval_status
                      FROM attendance a
                      JOIN employees e ON a.employee_id = e.id
                      WHERE a.date BETWEEN '$start_date' AND '$end_date'";

// Apply employee filter if provided
if ($employee_id) {
    $attendance_query .= " AND e.id = $employee_id";
}

// Apply location filter if provided
if ($location) {
    $attendance_query .= " AND e.address LIKE '%$location%'";
}

$attendance_result = mysqli_query($conn, $attendance_query);

// Leave Requests Report
$leave_requests_query = "SELECT e.name, lr.leave_type, lr.start_date, lr.end_date, lr.final_status, lr.reason
                          FROM leave_requests lr
                          JOIN employees e ON lr.employee_id = e.id
                          WHERE lr.start_date BETWEEN '$start_date' AND '$end_date'";

if ($employee_id) {
    $leave_requests_query .= " AND e.id = $employee_id";
}

$leave_requests_result = mysqli_query($conn, $leave_requests_query);

// Task Progress Report
$task_query = "SELECT t.task_name, t.assigned_by, t.assigned_to, t.status, t.priority, t.start_date, t.due_date
               FROM tasks t
               WHERE t.start_date BETWEEN '$start_date' AND '$end_date'";

if ($employee_id) {
    $task_query .= " AND t.assigned_to = $employee_id";
}

$task_result = mysqli_query($conn, $task_query);

// Enquiries Report
$enquiries_query = "SELECT e.project_name, e.client_name, e.contact, e.location, e.category, e.created_at
                    FROM enquiries e
                    WHERE e.created_at BETWEEN '$start_date' AND '$end_date'";

if ($location) {
    $enquiries_query .= " AND e.location LIKE '%$location%'";
}

$enquiries_result = mysqli_query($conn, $enquiries_query);

// Financial Requests Report
$financial_requests_query = "SELECT e.name, fr.request_type, fr.amount, fr.description, fr.status
                             FROM financial_requests fr
                             JOIN employees e ON fr.employee_id = e.id
                             WHERE fr.created_at BETWEEN '$start_date' AND '$end_date'";

if ($employee_id) {
    $financial_requests_query .= " AND e.id = $employee_id";
}

$financial_requests_result = mysqli_query($conn, $financial_requests_query);
?>

<!doctype html>
<html lang="en">

<head>
    <title>Admin | Generate Reports</title>
    <?php include('links/head.php'); ?>
</head>

<h4>Attendance Report</h4>
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr>
                                                <th>Employee Name</th>
                                                <th>Date</th>
                                                <th>Status</th>
                                                <th>Check-in</th>
                                                <th>Check-out</th>
                                                <th>Approval Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if ($attendance_result && mysqli_num_rows($attendance_result) > 0) {
                                                while ($row = mysqli_fetch_assoc($attendance_result)) {
                                                    echo "<tr>";
                                                    echo "<td>" . htmlspecialchars($row['name']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['date']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['status']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['check_in']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['check_out']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['approval_status']) . "</td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='6' class='text-center'>No data found for the selected filter.</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>

<hr>

<h4>Leave Requests Report</h4>
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr>
                                                <th>Employee Name</th>
                                                <th>Leave Type</th>
                                                <th>Start Date</th>
                                                <th>End Date</th>
                                                <th>Status</th>
                                                <th>Reason</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if ($leave_requests_result && mysqli_num_rows($leave_requests_result) > 0) {
                                                while ($row = mysqli_fetch_assoc($leave_requests_result)) {
                                                    echo "<tr>";
                                                    echo "<td>" . htmlspecialchars($row['name']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['leave_type']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['start_date']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['end_date']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['final_status']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['reason']) . "</td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='6' class='text-center'>No data found for the selected filter.</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>

<hr>

<h4>Task Progress Report</h4>
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr>
                                                <th>Task Name</th>
                                                <th>Assigned By</th>
                                                <th>Assigned To</th>
                                                <th>Status</th>
                                                <th>Priority</th>
                                                <th>Start Date</th>
                                                <th>Due Date</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if ($task_result && mysqli_num_rows($task_result) > 0) {
                                                while ($row = mysqli_fetch_assoc($task_result)) {
                                                    echo "<tr>";
                                                    echo "<td>" . htmlspecialchars($row['task_name']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['assigned_by']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['assigned_to']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['status']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['priority']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['start_date']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['due_date']) . "</td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='7' class='text-center'>No data found for the selected filter.</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>

<hr>

<h4>Enquiries Report</h4>
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr>
                                                <th>Project Name</th>
                                                <th>Client Name</th>
                                                <th>Contact</th>
                                                <th>Location</th>
                                                <th>Category</th>
                                                <th>Created At</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if ($enquiries_result && mysqli_num_rows($enquiries_result) > 0) {
                                                while ($row = mysqli_fetch_assoc($enquiries_result)) {
                                                    echo "<tr>";
                                                    echo "<td>" . htmlspecialchars($row['project_name']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['client_name']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['contact']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['location']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['category']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['created_at']) . "</td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='6' class='text-center'>No data found for the selected filter.</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>

<hr>

<h4>Financial Requests Report</h4>
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr>
                                                <th>Employee Name</th>
                                                <th>Request Type</th>
                                                <th>Amount</th>
                                                <th>Description</th>
                                                <th>Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if ($financial_requests_result && mysqli_num_rows($financial_requests_result) > 0) {
                                                while ($row = mysqli_fetch_assoc($financial_requests_result)) {
                                                    echo "<tr>";
                                                    echo "<td>" . htmlspecialchars($row['name']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['request_type']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['amount']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['description']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['status']) . "</td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='5' class='text-center'>No data found for the selected filter.</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>

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

</div> 
            </div>

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

<?php include('includes/rightbar.php'); ?>
    <div class="rightbar-overlay"></div>
    <?php include('links/scripts.php'); ?>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_reports.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation