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

Free Space:

10.19 TB

🔧 Quick Actions

✏️ Editing: payslips.php

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

// Fetch current user
$user_id = $_SESSION['user_id'];
$query = "SELECT * FROM users WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();

$current_user_id = $_SESSION['user_id'];
$is_admin_or_hr = isset($_SESSION['role']) && in_array($_SESSION['role'], ['admin', 'hr']);

// === Get and sanitize filter inputs ===
$month_filter = isset($_GET['month']) ? trim($_GET['month']) : '';
$employee_filter = isset($_GET['employee_id']) ? (int)$_GET['employee_id'] : 0;

// Validate and format month: must be YYYY-MM
if ($month_filter && preg_match('/^\d{4}-\d{2}$/', $month_filter)) {
    $month_filter = $month_filter;
} else {
    $month_filter = date('Y-m'); // fallback to current month
}

// === Build dynamic query based on role and filters ===
$params = [];
$types = '';
$conditions = [];

if ($is_admin_or_hr) {
    $query = "SELECT p.*, u.name, u.employee_id 
              FROM payroll p 
              JOIN users u ON p.employee_id = u.id";
    
    if ($month_filter) {
        $conditions[] = "p.month = ?";
        $params[] = $month_filter;
        $types .= 's';
    }
    
    if ($employee_filter > 0) {
        $conditions[] = "p.employee_id = ?";
        $params[] = $employee_filter;
        $types .= 'i';
    }
    
    if (!empty($conditions)) {
        $query .= " WHERE " . implode(" AND ", $conditions);
    }
    
    $query .= " ORDER BY p.month DESC, u.name ASC";
} else {
    // Regular employees: only their payslips + optional month filter
    $query = "SELECT p.*, u.name, u.employee_id 
              FROM payroll p 
              JOIN users u ON p.employee_id = u.id 
              WHERE p.employee_id = ?";
    $params[] = $current_user_id;
    $types .= 'i';
    
    if ($month_filter) {
        $query .= " AND p.month = ?";
        $params[] = $month_filter;
        $types .= 's';
    }
    
    $query .= " ORDER BY p.month DESC";
}

// Execute query
$stmt = $conn->prepare($query);
if ($params) {
    $stmt->bind_param($types, ...$params);
}
$stmt->execute();
$result = $stmt->get_result();
$payslips = $result->fetch_all(MYSQLI_ASSOC);

// === Fetch employees for dropdown (HR/Admin only) ===
$employees = [];
if ($is_admin_or_hr) {
    $emp_query = "SELECT id, name, employee_id FROM users WHERE role = 'employee' ORDER BY name";
    $emp_result = $conn->query($emp_query);
    $employees = $emp_result->fetch_all(MYSQLI_ASSOC);
}

// === Financial Summary (for current user) ===
$summary_query = "SELECT 
                    SUM(basic_salary) AS total_earnings, 
                    SUM(deductions) AS total_deductions, 
                    SUM(net_salary) AS total_net_pay, 
                    COUNT(*) AS payslip_count 
                  FROM payroll 
                  WHERE employee_id = ?";
$summary_stmt = $conn->prepare($summary_query);
$summary_stmt->bind_param("i", $current_user_id);
$summary_stmt->execute();
$summary_result = $summary_stmt->get_result();
$financial_summary = $summary_result->fetch_assoc();
$financial_summary = array_map(function($value) {
    return $value === null ? 0 : floatval($value);
}, $financial_summary);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Payslips & Financials | Decconz Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="A fully featured admin theme for HR and Payroll management" name="description">
    <meta content="Decconz IT Solutions" name="author">
    <link rel="shortcut icon" href="images/dec.jpeg">
    <script src="js/hyper-config.js"></script>
    <link href="css/vendor.min.css" rel="stylesheet" type="text/css">
    <link href="css/app.min.css" rel="stylesheet" type="text/css" id="app-style">
    <link href="css/unicons.css" rel="stylesheet" type="text/css">
    <link href="css/remixicon.css" rel="stylesheet" type="text/css">
    <link href="css/materialdesignicons.min.css" rel="stylesheet" type="text/css">
    <link href="css/dataTables.bootstrap5.min.css" rel="stylesheet">
    <style>
        .financial-summary {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 20px;
            margin-bottom: 30px;
        }
        .summary-item {
            background: #fff;
            padding: 20px;
            border-radius: 8px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.05);
            text-align: center;
        }
        .summary-item h5 {
            color: #6b7280;
            margin-bottom: 10px;
        }
        .summary-item h3 {
            font-size: 24px;
            font-weight: 600;
            margin-bottom: 5px;
        }
        .status-badge {
            padding: 6px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 500;
        }
        .status-processed {
            background-color: #d1fae5;
            color: #10b981;
        }
        .status-pending {
            background-color: #fef3c7;
            color: #f59e0b;
        }
        .action-icon {
            color: #6b7280;
            margin: 0 5px;
            transition: color 0.3s;
        }
        .action-icon:hover {
            color: #3b82f6;
        }
        .action-icon.text-danger:hover {
            color: #ef4444;
        }
        .filter-section {
            background: #ffffff;
            padding: 20px;
            border-radius: 8px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.05);
            margin-bottom: 30px;
        }
        #payslipDetails {
            padding: 20px;
        }
    </style>
</head>
<body>
<div class="wrapper">
    <?php include('includes/nav.php'); ?>
    <?php include('includes/sidebar.php'); ?>
    <div class="content-page">
        <div class="content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box">
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="javascript: void(0);">HR</a></li>
                                    <li class="breadcrumb-item active">Payslips & Financials</li>
                                </ol>
                            </div>
                            <h4 class="page-title">Payslips & Financials</h4>
                        </div>
                    </div>
                </div>
                
                <div class="row mb-3">
                    <div class="col-md-12">
                        <div class="filter-section">
                            <form id="filter-form" method="GET" action="payslips.php">
                                <div class="row">
                                    <?php if ($is_admin_or_hr): ?>
                                    <div class="col-md-4">
                                        <label for="employee-filter" class="form-label">Employee</label>
                                        <select class="form-select" id="employee-filter" name="employee_id">
                                            <option value="">All Employees</option>
                                            <?php foreach ($employees as $emp): ?>
                                            <option value="<?= $emp['id'] ?>" <?= ($employee_filter == $emp['id']) ? 'selected' : '' ?>>
                                                <?= htmlspecialchars($emp['name']) ?> (<?= htmlspecialchars($emp['employee_id']) ?>)
                                            </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                    <?php endif; ?>
                                    <div class="col-md-4">
                                        <label for="month-filter" class="form-label">Month</label>
                                        <input type="month" class="form-control" id="month-filter" name="month" value="<?= htmlspecialchars($month_filter) ?>">
                                    </div>
                                    <div class="col-md-4 d-flex align-items-end">
                                        <button type="submit" class="btn btn-primary" id="apply-filters">Apply Filters</button>
                                        <?php if ($is_admin_or_hr): ?>
                                        <button type="button" class="btn btn-success ms-2" id="export-payslips">
                                            <i class="ri-file-excel-2-line me-1"></i> Export
                                        </button>
                                        <?php endif; ?>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                
                <div class="financial-summary">
                    <div class="summary-item">
                        <h5>Total Earnings</h5>
                        <h3>₹<?= number_format($financial_summary['total_earnings'], 2) ?></h3>
                        <p>All time earnings</p>
                    </div>
                    <div class="summary-item">
                        <h5>Net Pay</h5>
                        <h3>₹<?= number_format($financial_summary['total_net_pay'], 2) ?></h3>
                        <p>After all deductions</p>
                    </div>
                    <div class="summary-item">
                        <h5>Total Deductions</h5>
                        <h3>₹<?= number_format($financial_summary['total_deductions'], 2) ?></h3>
                        <p>Taxes and other deductions</p>
                    </div>
                    <div class="summary-item">
                        <h5>Payslips</h5>
                        <h3><?= $financial_summary['payslip_count'] ?></h3>
                        <p>Total payslips received</p>
                    </div>
                </div>
                
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="payslips-table" class="table table-centered table-nowrap mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Payslip ID</th>
                                                <th>Employee</th>
                                                <th>Month</th>
                                                <th>Basic Salary</th>
                                                <th>Deductions</th>
                                                <th>Net Salary</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (empty($payslips)): ?>
                                            <tr>
                                                <td colspan="<?= $is_admin_or_hr ? 8 : 7 ?>" class="text-center">
                                                    No payslips found for the selected criteria.
                                                </td>
                                            </tr>
                                            <?php else: ?>
                                            <?php foreach ($payslips as $payslip): ?>
                                            <tr>
                                                <td>#<?= htmlspecialchars($payslip['id']) ?></td>
                                                <td>
                                                    <?= htmlspecialchars($payslip['name']) ?>
                                                    <small class="text-muted"><?= htmlspecialchars($payslip['employee_id']) ?></small>
                                                </td>
                                                <td><?= date('F Y', strtotime($payslip['month'] . '-01')) ?></td>
                                                <td>₹<?= number_format($payslip['basic_salary'], 2) ?></td>
                                                <td>₹<?= number_format($payslip['deductions'], 2) ?></td>
                                                <td>₹<?= number_format($payslip['net_salary'], 2) ?></td>
                                                <td>
                                                    <span class="status-badge status-<?= strtolower($payslip['status']) ?>">
                                                        <?= ucfirst(str_replace('_', ' ', $payslip['status'])) ?>
                                                    </span>
                                                </td>
                                                <td>
                                                    <a href="generate_payslip.php?id=<?= $payslip['id'] ?>" class="action-icon download-payslip" data-id="<?= $payslip['id'] ?>">
                                                        <i class="ri-download-line" title="Download"></i>
                                                    </a>
                                                    <?php if ($is_admin_or_hr): ?>
                                                    <a href="javascript:void(0);" class="action-icon text-danger delete-payslip" data-id="<?= $payslip['id'] ?>">
                                                        <i class="ri-delete-bin-line" title="Delete"></i>
                                                    </a>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                            <?php endforeach; ?>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                
                <div class="modal fade" id="payslipModal" tabindex="-1" aria-labelledby="payslipModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h4 class="modal-title" id="payslipModalLabel">Payslip Details</h4>
                                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                            </div>
                            <div class="modal-body" id="payslipDetails">
                                
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-light" data-bs-dismiss="modal">Close</button>
                                <button type="button" class="btn btn-primary" id="printPayslip">
                                    <i class="ri-printer-line me-1"></i> Print
                                </button>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <?php include('includes/footer.php'); ?>
    </div>
</div>

<?php include('includes/theme.php'); ?>
<script src="js/vendor.min.js"></script>
<script src="js/app.js"></script>
<script src="js/jquery.dataTables.min.js"></script>
<script src="js/dataTables.bootstrap5.min.js"></script>
<script src="js/sweetalert2.min.js"></script>
<script>
$(document).ready(function () {
    $('#payslips-table').DataTable({
        "order": [[2, "desc"]],
        "responsive": true,
        "language": {
            "paginate": {
                "previous": "<i class='ri-arrow-left-s-line'>",
                "next": "<i class='ri-arrow-right-s-line'>"
            }
        },
        "drawCallback": function () {
            $('.dataTables_paginate .pagination').addClass('pagination-rounded');
        }
    });

// === Print Payslip ===
    $('#printPayslip').click(function () {
        const printWindow = window.open('', '_blank');
        printWindow.document.write('<html><head><title>Payslip</title>');
        printWindow.document.write('<link href="css/app.min.css" rel="stylesheet">');
        printWindow.document.write('<style>body{padding:20px;} @page { margin: 20px; }</style>');
        printWindow.document.write('</head><body>');
        printWindow.document.write($('#payslipDetails').html());
        printWindow.document.write('</body></html>');
        printWindow.document.close();
        printWindow.onload = () => {
            printWindow.focus();
            printWindow.print();
            printWindow.close();
        };
    });

// === Export Payslips ===
    $('#export-payslips').click(function () {
        const month = $('#month-filter').val();
        const empId = $('#employee-filter').val();
        let url = 'export_payslips.php';
        const params = new URLSearchParams();
        if (month) params.append('month', month);
        if (empId) params.append('employee_id', empId);
        window.open(url + '?' + params.toString(), '_blank');
    });

// === Delete Payslip ===
    $(document).on('click', '.delete-payslip', function () {
        const id = $(this).data('id');
        Swal.fire({
            title: 'Confirm Delete',
            text: "Are you sure?",
            icon: 'warning',
            showCancelButton: true,
            confirmButtonText: 'Yes, delete!'
        }).then(result => {
            if (result.isConfirmed) {
                $.post('delete_payslip.php', { id: id }, res => {
                    if (res.success) {
                        Swal.fire('Deleted!', '', 'success').then(() => location.reload());
                    } else {
                        Swal.fire('Error!', res.message, 'error');
                    }
                }, 'json').fail(function() {
                    Swal.fire('Error!', 'Failed to delete payslip.', 'error');
                });
            }
        });
    });
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: payslips.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation