@extends('layouts.master')

@section('title', 'Salary Sheet Report')

@section('content')
@include('partials.header')
@include('partials.sidebar')

<style>
@media print {
    @page {
        size: A4 landscape;
        margin: 10mm;
    }

    * {
        -webkit-print-color-adjust: exact !important;
        print-color-adjust: exact !important;
    }

    body, html {
        margin: 0 !important;
        padding: 0 !important;
        height: auto !important;
        overflow: hidden !important;
    }

    .app-header,
    .app-sidebar,
    .app-title,
    .btn,
    .d-flex {
        display: none !important;
    }

    .app-content {
        margin: 0 !important;
        padding: 0 !important;
    }

    .table-responsive {
        overflow: visible !important;
    }

    table {
        width: 100% !important;
        font-size: 11px;
        border-collapse: collapse !important;
        page-break-inside: auto;
    }

    thead {
        display: table-header-group;
    }

    tr, td, th {
        page-break-inside: avoid !important;
        page-break-after: auto;
    }

    html::after, body::after {
        content: none !important;
        display: none !important;
        height: 0 !important;
    }
}
</style>

<main class="app-content">

    {{-- Custom Heading --}}
    <div class="text-center mb-4">
        <h4 style="font-size: 14pt; font-weight: bold; margin-bottom: 5px;">Consilio Architectural & Designing Firm</h4>
        <h5 style="margin-bottom: 5px;">Salary Sheet Report</h5>
        <h6>
            From Date: {{ \Carbon\Carbon::parse($fromDate)->format('d-m-Y') }}
            To Date: {{ \Carbon\Carbon::parse($toDate)->format('d-m-Y') }}
        </h6>
    </div>

    <div class="mb-3 d-flex justify-content-between">
        <a href="{{ url('/') }}" class="btn btn-primary">
            <i class="fa fa-home"></i> Home
        </a>
        <button onclick="window.print()" class="btn btn-success">
            <i class="fa fa-print"></i> Print
        </button>
    </div>

    <div class="table-responsive">
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>Employee Name</th>
                    <th>Designation</th>
                    <th class="text-right">Basic Pay</th>
                    <th class="text-right">Days Worked</th>
                    <th class="text-right">OT Hours</th>
                    <th class="text-right">Advance</th>
                    <th class="text-right">Loan</th>
                    <th class="text-right">Conveyance</th>
                    <th class="text-right">Gross Salary</th>
                    <th class="text-right">Net Salary</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $totalPay = 0;
                    $totalAdvance = 0;
                    $totalLoan = 0;
                    $totalConveyance = 0;
                    $totalGross = 0;
                    $totalNet = 0;
                @endphp
                @foreach($salarySlips as $slip)
                    @php
                        $totalPay += $slip->pay;
                        $totalAdvance += $slip->advance;
                        $totalLoan += $slip->loan_ded;
                        $totalConveyance += $slip->conveyance;
                        $totalGross += $slip->gross_salary;
                        $totalNet += $slip->net_salary;
                    @endphp
                    <tr>
                        <td>{{ $slip->name }}</td>
                        <td>{{ $slip->desig }}</td>
                        <td class="text-right">{{ number_format($slip->pay, 0) }}</td>
                        <td class="text-right">{{ number_format($slip->days_worked, 0) }}</td>
                        <td class="text-right">{{ number_format($slip->ot_hours, 0) }}</td>
                        <td class="text-right">{{ number_format($slip->advance, 0) }}</td>
                        <td class="text-right">{{ number_format($slip->loan_ded, 0) }}</td>
                        <td class="text-right">{{ number_format($slip->conveyance, 0) }}</td>
                        <td class="text-right">{{ number_format($slip->gross_salary, 0) }}</td>
                        <td class="text-right">{{ number_format($slip->net_salary, 0) }}</td>
                    </tr>
                @endforeach
                <tr class="bg-light font-weight-bold">
                    <td colspan="2">Grand Total</td>
                    <td class="text-right">{{ number_format($totalPay, 0) }}</td>
                    <td></td>
                    <td></td>
                    <td class="text-right">{{ number_format($totalAdvance, 0) }}</td>
                    <td class="text-right">{{ number_format($totalLoan, 0) }}</td>
                    <td class="text-right">{{ number_format($totalConveyance, 0) }}</td>
                    <td class="text-right">{{ number_format($totalGross, 0) }}</td>
                    <td class="text-right">{{ number_format($totalNet, 0) }}</td>
                </tr>
            </tbody>
        </table>
    </div>
</main>
@endsection