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

🔧 Quick Actions

✏️ Editing: generate_payslip.php

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

if (!isset($_GET['id'])) {
    die('Invalid request');
}

$id = intval($_GET['id']);
$current_user_id = $_SESSION['user_id'];
$is_admin_or_hr = (isset($_SESSION['role']) && ($_SESSION['role'] == 'admin' || $_SESSION['role'] == 'hr'));

// Get payslip details
$query = "SELECT p.*, u.name, u.employee_id, u.designation 
          FROM payroll p 
          JOIN users u ON p.employee_id = u.id 
          WHERE p.id = ?";
          
if (!$is_admin_or_hr) {
    $query .= " AND p.employee_id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ii", $id, $current_user_id);
} else {
    $stmt = $conn->prepare($query);
    $stmt->bind_param("i", $id);
}

$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows === 0) {
    die('Payslip not found or you don\'t have permission to view it');
}

$payslip = $result->fetch_assoc();

// Calculate salary components
$basic = $payslip['basic_salary'];
$hra = $basic * 0.4;
$da = $basic * 0.1;
$pf = $basic * 0.12;
$tax = $basic * 0.05;
$total_earnings = $basic + $hra + $da;
$total_deductions = $pf + $tax + $payslip['deductions'];
$net_salary = $total_earnings - $total_deductions;

// Check if DomPDF is available
$use_dompdf = false;
if (file_exists('vendor/autoload.php')) {
    require_once 'vendor/autoload.php';
    if (class_exists('Dompdf\Dompdf')) {
        $use_dompdf = true;
    }
}

// Generate HTML content
$html = '<!DOCTYPE html>
<html>
<head>
    <title>Payslip - '.htmlspecialchars($payslip['name']).'</title>
    <style>
        body { font-family: Arial, sans-serif; }
        .header { text-align: center; margin-bottom: 20px; }
        .company-name { font-size: 24px; font-weight: bold; }
        .payslip-title { font-size: 18px; }
        .employee-info { margin-bottom: 20px; }
        .table { width: 100%; border-collapse: collapse; }
        .table th, .table td { border: 1px solid #ddd; padding: 8px; text-align: left; }
        .table th { background-color: #f2f2f2; }
        .text-right { text-align: right; }
        .total-row { font-weight: bold; }
        .footer { margin-top: 30px; text-align: center; font-size: 12px; }
    </style>
</head>
<body>
    <div class="header">
        <div class="company-name">Your Company Name</div>
        <div class="payslip-title">PAYSLIP</div>
        <div>For the month of '.htmlspecialchars(date('F Y', strtotime($payslip['month'].'-01'))).'</div>
    </div>
    
    <div class="employee-info">
        <p><strong>Employee ID:</strong> '.htmlspecialchars($payslip['employee_id']).'</p>
        <p><strong>Name:</strong> '.htmlspecialchars($payslip['name']).'</p>
        <p><strong>Designation:</strong> '.htmlspecialchars($payslip['designation']).'</p>
        <p><strong>Payslip ID:</strong> #'.htmlspecialchars($id).'</p>
    </div>
    
    <table class="table">
        <thead>
            <tr>
                <th>Earnings</th>
                <th class="text-right">Amount (₹)</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Basic Salary</td>
                <td class="text-right">'.number_format($basic, 2).'</td>
            </tr>
            <tr>
                <td>House Rent Allowance (HRA)</td>
                <td class="text-right">'.number_format($hra, 2).'</td>
            </tr>
            <tr>
                <td>Dearness Allowance (DA)</td>
                <td class="text-right">'.number_format($da, 2).'</td>
            </tr>
            <tr class="total-row">
                <td>Total Earnings</td>
                <td class="text-right">'.number_format($total_earnings, 2).'</td>
            </tr>
        </tbody>
    </table>
    
    <table class="table" style="margin-top: 20px;">
        <thead>
            <tr>
                <th>Deductions</th>
                <th class="text-right">Amount (₹)</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Provident Fund (PF)</td>
                <td class="text-right">'.number_format($pf, 2).'</td>
            </tr>
            <tr>
                <td>Professional Tax</td>
                <td class="text-right">'.number_format($tax, 2).'</td>
            </tr>
            <tr>
                <td>Other Deductions</td>
                <td class="text-right">'.number_format($payslip['deductions'], 2).'</td>
            </tr>
            <tr class="total-row">
                <td>Total Deductions</td>
                <td class="text-right">'.number_format($total_deductions, 2).'</td>
            </tr>
        </tbody>
    </table>
    
    <div style="margin-top: 30px; text-align: center; font-size: 24px; font-weight: bold;">
        Net Salary: ₹'.number_format($net_salary, 2).'
    </div>
    
    <div class="footer">
        <p>This is a computer generated payslip and does not require signature.</p>
        <p>Generated on '.htmlspecialchars(date('d/m/Y')).'</p>
    </div>
</body>
</html>';

if ($use_dompdf) {
    // Generate PDF using DomPDF
    $dompdf = new \Dompdf\Dompdf();
    $dompdf->loadHtml($html);
    $dompdf->setPaper('A4', 'portrait');
    $dompdf->render();
    
    // Output the generated PDF (force download)
    $dompdf->stream("payslip_".$payslip['employee_id']."_".$payslip['month'].".pdf", [
        "Attachment" => true
    ]);
} else {
    // Fallback: output as HTML with download headers
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename="payslip_'.$payslip['employee_id'].'_'.$payslip['month'].'.html"');
    echo $html;
    exit;
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_payslip.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation