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.25 TB

🔧 Quick Actions

✏️ Editing: hr-payroll.php

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

if (!isset($_SESSION['user_id']) || $_SESSION['user_role'] !== 'admin') {
    header("Location: /ems/superadmin/index.php");
    exit();
}

// Calculate total hours for employee in the selected month
function calculateAttendanceHours($employee_id, $month) {
    global $conn;
    $start = $month . "-01";
    $end = date("Y-m-t", strtotime($start));
    $stmt = $conn->prepare("SELECT SUM(total_hours) AS total_hours FROM attendance WHERE employee_id = ? AND date BETWEEN ? AND ?");
    $stmt->bind_param("iss", $employee_id, $start, $end);
    $stmt->execute();
    $result = $stmt->get_result()->fetch_assoc();
    return $result['total_hours'] ?? 0;
}

// Generate payroll
function generatePayroll($month) {
    global $conn;
    $base_salary = 15000;
    $base_hours = 208;

$month = mysqli_real_escape_string($conn, $month);
    $users = mysqli_query($conn, "SELECT id FROM users WHERE role = 'employee' AND status = 'active'");

while ($user = mysqli_fetch_assoc($users)) {
        $emp_id = (int)$user['id'];

$exists = mysqli_query($conn, "SELECT id FROM payroll WHERE employee_id = $emp_id AND month = '$month'");
        if (mysqli_num_rows($exists) > 0) continue;

$worked_hours = calculateAttendanceHours($emp_id, $month);
        $net_salary = round(($worked_hours / $base_hours) * $base_salary, 2);

$stmt = $conn->prepare("INSERT INTO payroll (employee_id, month, basic_salary, deductions, net_salary, status) VALUES (?, ?, ?, ?, ?, 'pending')");
        $zero = 0;
        $stmt->bind_param("issdd", $emp_id, $month, $base_salary, $zero, $net_salary);
        $stmt->execute();
    }
}

// Mark as paid
function markPayrollPaid($payrollId) {
    global $conn;
    $payrollId = (int)$payrollId;
    mysqli_query($conn, "UPDATE payroll SET status = 'processed' WHERE id = $payrollId");
}

// Handle POST requests
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['generate_payroll']) && isset($_POST['month'])) {
        generatePayroll($_POST['month']);
        $success = "Payroll generated for " . htmlspecialchars($_POST['month'] ?? '');
    }

if (isset($_POST['mark_paid']) && isset($_POST['payroll_id'])) {
        markPayrollPaid($_POST['payroll_id']);
        $success = "Payroll marked as paid.";
    }
}

// Fetch all payroll records
$payrolls = mysqli_query($conn, "
    SELECT p.*, u.name, u.designation 
    FROM payroll p 
    JOIN users u ON u.id = p.employee_id 
    ORDER BY p.id DESC
");
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Payroll | Decconz Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link rel="shortcut icon" href="../images/dec.jpeg">

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

<?php if (isset($success)): ?>
                <div class="alert alert-success alert-dismissible fade show mt-2" role="alert">
                    <?= htmlspecialchars($success ?? '') ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
            <?php endif; ?>

<div class="row">
                <div class="col-12">
                    <div class="card mt-3">
                        <div class="card-body">
                            <h4 class="header-title mb-3">Payroll Management</h4>

<form method="POST" class="row g-3 mb-4">
                                <div class="col-md-3">
                                    <label for="month" class="form-label">Select Month</label>
                                    <input type="month" id="month" name="month" class="form-control" required>
                                </div>
                                <div class="col-md-2 align-self-end">
                                    <button type="submit" name="generate_payroll" class="btn btn-success">Generate</button>
                                </div>
                            </form>

<div class="table-responsive">
                                <table class="table table-bordered table-striped">
                                    <thead class="table-dark">
                                        <tr>
                                            <th>Employee</th>
                                            <th>Designation</th>
                                            <th>Month</th>
                                            <th>Base Salary</th>
                                            <th>Net Salary</th>
                                            <th>Status</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php while ($row = mysqli_fetch_assoc($payrolls)): ?>
                                        <tr>
                                            <td><?= htmlspecialchars($row['name'] ?? '') ?></td>
                                            <td><?= htmlspecialchars($row['designation'] ?? '') ?></td>
                                            <td><?= htmlspecialchars($row['month'] ?? '') ?></td>
                                            <td>₹<?= number_format((float)$row['basic_salary'], 2) ?></td>
                                            <td>₹<?= number_format((float)$row['net_salary'], 2) ?></td>
                                            <td>
                                                <span class="badge bg-<?= $row['status'] == 'processed' ? 'success' : 'warning' ?>">
                                                    <?= ucfirst($row['status'] ?? 'unknown') ?>
                                                </span>
                                            </td>
                                            <td>
                                                <?php if (($row['status'] ?? '') === 'pending'): ?>
                                                <form method="POST" class="d-inline">
                                                    <input type="hidden" name="payroll_id" value="<?= $row['id'] ?>">
                                                    <button name="mark_paid" class="btn btn-sm btn-primary">Mark Paid</button>
                                                </form>
                                                <?php else: ?>
                                                <span class="text-muted">Paid</span>
                                                <?php endif; ?>
                                            </td>
                                        </tr>
                                        <?php endwhile; ?>
                                        <?php if (mysqli_num_rows($payrolls) == 0): ?>
                                        <tr><td colspan="7" class="text-center text-muted">No payroll records found.</td></tr>
                                        <?php endif; ?>
                                    </tbody>
                                </table>
                            </div>

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

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: hr-payroll.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation