@extends('printlayout')
@section('content')
    <div class="row invoice-box">
        <div class="col-lg-12 col-md-12 col-xs-12 col-sm-12 text-center ">
            <h1 style="font-size:26px;">
                {{ __('sitelabel.EmployeeWeeklySalaryReport') }}
            </h1>
        </div>
        <div class="col-lg-12 col-md-12 col-xs-12 col-sm-12 text-center ">
            <span style="font-size:16px; padding:10px;"><strong>{{ __('sitelabel.StartDate') }}: </strong></span>
            <span style="padding:10px;">
                {{ \Carbon\Carbon::parse(request('txtStartDate'))->format('d-F-Y') }}
            </span>
            <span style="font-size:16px; padding:10px;"><strong>{{ __('sitelabel.EndDate') }}: </strong></span>
            <span style="padding:10px;">
                {{ \Carbon\Carbon::parse(request('txtEndDate'))->format('d-F-Y') }}
            </span>
        </div>
    </div>

    <div class="row table-row">
        <table class="table table-striped">
            <thead>
                <tr>
                    <th class="text-center" style="width:5%">{{ __('sitelabel.SerialNumber') }}</th>
                    <th class="text-end" style="width:15%">{{ __('sitelabel.PaymentDate') }}</th>
                    <th class="text-right" style="width:15%">{{ __('sitelabel.PayableAmount') }}</th>
                    <th class="text-right" style="width:15%">{{ __('sitelabel.Advance/Kharcha') }}</th>
                    <th class="text-right" style="width:15%">{{ __('sitelabel.LoanDeduction') }}</th>
                    <th class="text-right" style="width:15%">{{ __('sitelabel.ExtraPay') }}</th>
                    <th class="text-right" style="width:15%">{{ __('sitelabel.PayAmount') }}</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($employees as $employee)
                    <tr>
                        <td colspan="7"><strong>{{ __('sitelabel.Employee') }}: </strong>{{ $employee->FullName }}</td>
                    </tr>

                    @php
                        $index = 1;
                        $totalPayableAmount = 0;
                        $totalAdvance = 0;
                        $totalLoanDeduction = 0;
                        $totalExtraPay = 0;
                        $totalPayAmount = 0;
                        $hasData = false;
                    @endphp

                    @foreach ($employeeweeklypayment as $item)
                        @if ($item->EmployeeId == $employee->Id)
                            <tr>
                                <td class="text-center">{{ $index++ }}</td>
                                <td class="text-end">{{ \Carbon\Carbon::parse($item->PaymentDate)->format('d-F-Y') }}
                                </td>
                                <td class="text-right">{{ number_format($item->PayableAmount, 4) }}</td>
                                <td class="text-right">{{ number_format($item->Advance, 4) }}</td>
                                <td class="text-right">{{ number_format($item->LoanDeduction, 4) }}</td>
                                <td class="text-right">{{ number_format($item->ExtraPay, 4) }}</td>
                                <td class="text-right">{{ number_format($item->PayAmount, 4) }}</td>
                            </tr>

                            @php
                                $totalPayableAmount += $item->PayableAmount;
                                $totalAdvance += $item->Advance;
                                $totalLoanDeduction += $item->LoanDeduction;
                                $totalExtraPay += $item->ExtraPay;
                                $totalPayAmount += $item->PayAmount;
                                $hasData = true;
                            @endphp
                        @endif
                    @endforeach

                    <!-- If no payment data exists for this employee, show the no data available message -->
                    @if (!$hasData)
                        <tr>
                            <td colspan="7" class="text-center">{{ __('sitelabel.NoDataAvailableAgainstThisEmployee') }}
                            </td>
                        </tr>
                        <tr>
                            <td colspan="7"></td>
                        </tr>
                    @endif

                    <!-- If there's more than one row of data, show the totals -->
                    @if ($index > 2 && $hasData)
                        <tr>
                            <td colspan="2" class="text-right font-weight-bold">{{ __('sitelabel.Total') }}</td>
                            <td class="text-right font-weight-bold">{{ number_format($totalPayableAmount, 4) }}</td>
                            <td class="text-right font-weight-bold">{{ number_format($totalAdvance, 4) }}</td>
                            <td class="text-right font-weight-bold">{{ number_format($totalLoanDeduction, 4) }}</td>
                            <td class="text-right font-weight-bold">{{ number_format($totalExtraPay, 4) }}</td>
                            <td class="text-right font-weight-bold">{{ number_format($totalPayAmount, 4) }}</td>
                        </tr>
                        <tr>
                            <td colspan="7"></td>
                        </tr>
                    @endif
                @endforeach
            </tbody>
        </table>
    </div>

    @include('sign-subview.signandbuttons')
@endsection