@extends('layouts.app')

@section('title', 'Payroll Reports')

@section('content')
<div class="min-h-screen bg-gray-50">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
        <div class="py-6">
            <div class="flex justify-between items-center mb-6">
                <h1 class="text-3xl font-bold text-gray-900">Payroll Reports</h1>
                <div class="flex space-x-3">
                    <button class="inline-flex items-center px-4 py-2 bg-green-600 text-white rounded-lg hover:bg-green-700 transition-colors" onclick="exportToExcel()">
                        <i class="fas fa-file-excel mr-2"></i> Export Excel
                    </button>
                    <button class="inline-flex items-center px-4 py-2 bg-red-600 text-white rounded-lg hover:bg-red-700 transition-colors" onclick="window.print()">
                        <i class="fas fa-print mr-2"></i> Print Report
                    </button>
                    <a href="{{ route('payroll.index') }}" class="inline-flex items-center px-4 py-2 bg-gray-600 text-white rounded-lg hover:bg-gray-700 transition-colors">
                        <i class="fas fa-arrow-left mr-2"></i> Back to Payroll
                    </a>
                </div>
            </div>

            <!-- Report Filters -->
            <div class="bg-white rounded-lg shadow-sm border border-gray-200 mb-6">
                <div class="px-6 py-4 border-b border-gray-200">
                    <h5 class="text-lg font-semibold mb-0">Report Filters</h5>
                </div>
                <div class="p-6">
                    <form method="GET" action="{{ route('payroll.reports') }}">
                        <div class="grid grid-cols-1 md:grid-cols-4 gap-4">
                            <div>
                                <label class="block text-sm font-medium text-gray-700 mb-2">Payroll Period</label>
                                <select name="period_id" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500">
                                    @foreach($periods as $period)
                                        <option value="{{ $period->id }}" {{ $selectedPeriod == $period->id ? 'selected' : '' }}>
                                            {{ $period->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div>
                                <label class="block text-sm font-medium text-gray-700 mb-2">Company</label>
                                <select name="company_id" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500">
                                    <option value="">All Companies</option>
                                    @foreach($companies as $company)
                                        <option value="{{ $company->name }}" {{ $selectedCompany == $company->name ? 'selected' : '' }}>
                                            {{ $company->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div>
                                <label class="block text-sm font-medium text-gray-700 mb-2">Report Type</label>
                                <select name="report_type" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500">
                                    <option value="summary" {{ $reportType == 'summary' ? 'selected' : '' }}>Summary</option>
                                    <option value="detailed" {{ $reportType == 'detailed' ? 'selected' : '' }}>Detailed</option>
                                    <option value="deductions" {{ $reportType == 'deductions' ? 'selected' : '' }}>Deductions Only</option>
                                </select>
                            </div>
                            <div>
                                <label class="block text-sm font-medium text-gray-700 mb-2">&nbsp;</label>
                                <button type="submit" class="w-full inline-flex items-center justify-center px-4 py-2 bg-indigo-600 text-white rounded-lg hover:bg-indigo-700 transition-colors">
                                    <i class="fas fa-filter mr-2"></i> Generate Report
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <!-- Summary Cards -->
            <div class="grid grid-cols-2 md:grid-cols-3 lg:grid-cols-6 gap-4 mb-6">
                <div class="bg-indigo-600 rounded-lg p-4 text-white text-center">
                    <h6 class="text-sm font-medium mb-1">Total Employees</h6>
                    <h4 class="text-lg font-bold">{{ number_format($totals['employees']) }}</h4>
                </div>
                <div class="bg-green-600 rounded-lg p-4 text-white text-center">
                    <h6 class="text-sm font-medium mb-1">Gross Wages</h6>
                    <h5 class="text-lg font-bold">₹{{ number_format($totals['gross_wages'], 0) }}</h5>
                </div>
                <div class="bg-amber-600 rounded-lg p-4 text-white text-center">
                    <h6 class="text-sm font-medium mb-1">Total Deductions</h6>
                    <h5 class="text-lg font-bold">₹{{ number_format($totals['total_deductions'], 0) }}</h5>
                </div>
                <div class="bg-blue-600 rounded-lg p-4 text-white text-center">
                    <h6 class="text-sm font-medium mb-1">Net Salary</h6>
                    <h5 class="text-lg font-bold">₹{{ number_format($totals['net_salary'], 0) }}</h5>
                </div>
                <div class="bg-gray-600 rounded-lg p-4 text-white text-center">
                    <h6 class="text-sm font-medium mb-1">ESI Employee</h6>
                    <h5 class="text-lg font-bold">₹{{ number_format($totals['esi_employee'], 0) }}</h5>
                </div>
                <div class="bg-gray-900 rounded-lg p-4 text-white text-center">
                    <h6 class="text-sm font-medium mb-1">PF Employee</h6>
                    <h5 class="text-lg font-bold">₹{{ number_format($totals['epf_employee'], 0) }}</h5>
                </div>
            </div>

            <!-- Report Table -->
            <div class="bg-white rounded-lg shadow-sm border border-gray-200">
                <div class="px-6 py-4 border-b border-gray-200">
                    <h5 class="text-lg font-semibold mb-0">
                        Payroll Report - {{ $periods->find($selectedPeriod)?->name ?? 'N/A' }}
                        @if($selectedCompany)
                            - {{ $selectedCompany }}
                        @endif
                    </h5>
                </div>
                <div class="overflow-x-auto">
                    <table class="min-w-full divide-y divide-gray-200" id="payrollReportTable">
                        <thead class="bg-gray-50">
                            @if($reportType == 'summary')
                                <tr>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Emp Code</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Employee Name</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Company</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Days Paid</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Gross Wages</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Total Deductions</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Net Salary</th>
                                </tr>
                            @elseif($reportType == 'detailed')
                                <tr>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Emp Code</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Name</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Basic</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">VDA</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">HRA</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Other Allowances</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Gross</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">ESI</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">PF</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">PT</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Net</th>
                                </tr>
                            @else
                                <tr>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Emp Code</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Employee Name</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Gross Wages</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">ESI Employee</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">ESI Employer</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">PF Employee</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">PF Employer</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Professional Tax</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Other Deductions</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Total Deductions</th>
                                </tr>
                            @endif
                        </thead>
                        <tbody class="bg-white divide-y divide-gray-200">
                            @foreach($salaries as $salary)
                                @if($reportType == 'summary')
                                    <tr class="hover:bg-gray-50">
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->employee_code }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->user->full_name }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->company_name }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->days_paid }}/{{ $salary->month_days }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->gross_wages, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->total_deduction, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm font-semibold text-gray-900">₹{{ number_format($salary->net_salary, 2) }}</td>
                                    </tr>
                                @elseif($reportType == 'detailed')
                                    <tr class="hover:bg-gray-50">
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->employee_code }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->user->full_name }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->basic, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->vda, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->hra, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->skill_allowances + $salary->performance_allowance + $salary->additional_4hrs, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->gross_wages, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->esi_employee_share, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->epf_employee_12_percent, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->professional_tax, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm font-semibold text-gray-900">₹{{ number_format($salary->net_salary, 2) }}</td>
                                    </tr>
                                @else
                                    <tr class="hover:bg-gray-50">
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->employee_code }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">{{ $salary->user->full_name }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->gross_wages, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->esi_employee_share, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->esi_employer_share, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->epf_employee_12_percent, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->epf_employer_13_percent, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->professional_tax, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">₹{{ number_format($salary->total_deduction - $salary->esi_employee_share - $salary->epf_employee_12_percent - $salary->professional_tax, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm font-semibold text-gray-900">₹{{ number_format($salary->total_deduction, 2) }}</td>
                                    </tr>
                                @endif
                            @endforeach
                        </tbody>
                        @if($reportType == 'summary')
                            <tfoot class="bg-gray-100">
                                <tr>
                                    <th colspan="4" class="px-6 py-3 text-right text-xs font-medium text-gray-900 uppercase tracking-wider">TOTALS:</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-900 uppercase tracking-wider">₹{{ number_format($totals['gross_wages'], 2) }}</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-900 uppercase tracking-wider">₹{{ number_format($totals['total_deductions'], 2) }}</th>
                                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-900 uppercase tracking-wider">₹{{ number_format($totals['net_salary'], 2) }}</th>
                                </tr>
                            </tfoot>
                        @endif
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script>
$(document).ready(function() {
    // Auto-submit filter on change
    $('select[name="period_id"], select[name="company_id"], select[name="report_type"]').on('change', function() {
        $(this).closest('form').submit();
    });
});

function exportToExcel() {
    const table = document.getElementById('payrollReportTable');
    const rows = table.getElementsByTagName('tr');
    let csv = [];
    
    for (let i = 0; i < rows.length; i++) {
        const row = [], cols = rows[i].querySelectorAll('td, th');
        
        for (let j = 0; j < cols.length; j++) {
            // Remove HTML tags and get clean text
            let text = cols[j].innerText || cols[j].textContent;
            text = text.replace(/₹/g, '').replace(/,/g, '').trim();
            row.push('"' + text + '"');
        }
        csv.push(row.join(','));
    }
    
    // Create download link
    const csvFile = new Blob([csv.join('\n')], {type: 'text/csv'});
    const downloadLink = document.createElement('a');
    downloadLink.download = 'payroll_report_{{ date('Y-m-d') }}.csv';
    downloadLink.href = window.URL.createObjectURL(csvFile);
    downloadLink.style.display = 'none';
    document.body.appendChild(downloadLink);
    downloadLink.click();
    document.body.removeChild(downloadLink);
}
</script>

<style>
@media print {
    .btn, form {
        display: none !important;
    }
    
    .bg-white {
        border: 1px solid #000 !important;
        page-break-inside: avoid;
    }
    
    .min-w-full {
        font-size: 10px;
    }
    
    .p-6 {
        padding: 0.5rem;
    }
}
</style>
@endsection