@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.EmployeeWeeklySalaryDetailReport') }}
            </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>

    @foreach ($employeeweeklypayment as $employeeweeklypayment)
        <div class="row table-row">
            <table class="table table-striped" style="margin:10px 0">
                <thead>
                    <tr>
                        <th class="text-end">{{ __('sitelabel.Employee') }}</th>
                        <th class="text-end">{{ __('sitelabel.PaymentDate') }}</th>
                        <th class="text-right">{{ __('sitelabel.PayableAmount') }}</th>
                        <th class="text-right">{{ __('sitelabel.Advance/Kharcha') }}</th>
                        <th class="text-right">{{ __('sitelabel.LoanDeduction') }}</th>
                        <th class="text-right">{{ __('sitelabel.ExtraPay') }}</th>
                        <th class="text-right">{{ __('sitelabel.NetPay') }}</th>
                    </tr>
                    <tr>
                        <td class="text-end">{{ $employeeweeklypayment->FullName }}</td>
                        <td class="text-end">
                            {{ \Carbon\Carbon::parse($employeeweeklypayment->PaymentDate)->format('d-F-Y') }}</td>
                        <td class="text-right">{{ number_format($employeeweeklypayment->PayableAmount, 4) }}</td>
                        <td class="text-right">{{ number_format($employeeweeklypayment->Advance, 4) }}</td>
                        <td class="text-right">{{ number_format($employeeweeklypayment->LoanDeduction, 4) }}</td>
                        <td class="text-right">{{ number_format($employeeweeklypayment->ExtraPay, 4) }}</td>
                        <td class="text-right">{{ number_format($employeeweeklypayment->PayAmount, 4) }}</td>
                    </tr>
                    <tr>
                        <th class="text-center" style="width:15%">{{ __('sitelabel.SerialNumber') }}</th>
                        <th class="text-end" colspan="2" style="width:30%">{{ __('sitelabel.Product') }}</th>
                        <th class="text-right" style="width:15%">{{ __('sitelabel.Bundle') }}</th>
                        <th class="text-right" style="width:15%">{{ __('sitelabel.Rate') }}</th>
                        <th class="text-right" style="width:15%">{{ __('sitelabel.Quantity') }}</th>
                        <th class="text-right" style="width:15%">{{ __('sitelabel.NetAmount') }}</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $index = 1;
                        $totalBundle = $totalRate = $totalQuantity = $totalNetAmount = 0;
                    @endphp

                    @php
                        $employeeDetails = $employeeweeklypaymentdetail->where(
                            'WeeklyPaymentId',
                            $employeeweeklypayment->WeeklyPaymentId,
                        );
                    @endphp

                    @if ($employeeDetails->count() > 0)
                        @foreach ($employeeDetails as $item)
                            <tr>
                                <td class="text-center">{{ $index++ }}</td>
                                <td colspan="2" class="text-end">{{ $item->ProductName }}</td>
                                <td class="text-right">{{ number_format($item->Bundle, 4) }}</td>
                                <td class="text-right">{{ number_format($item->Rate, 4) }}</td>
                                <td class="text-right">{{ number_format($item->Quantity, 4) }}</td>
                                <td class="text-right">{{ number_format($item->NetAmount, 4) }}</td>
                            </tr>
                            @php
                                $totalBundle += $item->Bundle;
                                $totalRate += $item->Rate;
                                $totalQuantity += $item->Quantity;
                                $totalNetAmount += $item->NetAmount;
                                $hasDetail = true;
                            @endphp
                        @endforeach

                        <tr>
                            <th colspan="3" class="text-right">{{ __('sitelabel.Total') }}</th>
                            <th class="text-right">{{ number_format($totalBundle, 4) }}</th>
                            <th class="text-right">{{ number_format($totalRate, 4) }}</th>
                            <th class="text-right">{{ number_format($totalQuantity, 4) }}</th>
                            <th class="text-right">{{ number_format($totalNetAmount, 4) }}</th>
                        </tr>
                        <tr>
                            <td colspan="7"></td>
                        </tr>
                        <tr>
                            <td colspan="7"></td>
                        </tr>
                    @endif
                </tbody>
            </table>
        </div>
    @endforeach

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