@extends('layouts.master')
@section('content')
<div class="app-page-title">
    <div class="page-title-wrapper">
        <div class="page-title-heading">
           
            <div>
                {{ $title }}
                
            </div>

            @if(isset($error) || session('error'))
            <div class="alert alert-danger">
                {{ $error ?? session('error') }}
            </div>
            @endif
        </div>


    </div>
</div>
<div class="main-card mb-3 card">
    <div class="card-body">
        <a href="{{ route('pam-reports.index') }}"><i class="fa fa-arrow-left"></i></a>
        
        <div class="card-title text-center">{{ $title }}</div>
        <table style="width: 100%;" id="example1" class="table table-hover table-striped table-bordered">
            <thead>
                <tr>
                    <th>Year</th>
                    <th>Month</th>
                    <th>SSN</th>
                    <th>Man #</th>
                    <th>National ID</th>
                    <th>Nhima #</th>
                    <th>Surname</th>
                    <th>First Name</th>
                    <th>Other Name</th>
                    <th>DOB</th>
                    <th>Gross Pay/Salary</th>
                    <th>Basic Pay</th>
                    <th>Employer Share</th>
                    <th>Employee Share</th>
                </tr>
            </thead>
            <tbody>
                @foreach($data as $item)
                @php
                    $def = App\Models\PamPayslip::where('id', $item->payslip_id)->first();
                    $nhimaContribution = App\Models\PamPayslipCont::where('payslip_id', $item->payslip_id)->where('cont_def_code','098')->first();
                    $basicEarning = App\Models\PamPayslipEarn::where('payslip_id', $item->payslip_id)->where('earn_def_code','BASICPAY')->first();

                @endphp
                @if($def)
                <tr>                 
                <td>{{$def->pamPayRun->pamPayRunPeriod->calendar_year}}</td>
                <td>{{$def->pamPayRun->pamPayRunPeriod->calendar_month}}</td>
                <td>{{ $def->pamEmp->pamHRUser->social_security_number}} </td>
                <td>{{ $def->pamEmp->pamHRUser->man_number}} </td>
                <td>{{ $def->pamEmp->pamHRUser->nrc}} </td>
                <td>{{ $def->pamEmp->pamHRUser->nhima_no}} </td>
                <td>{{ $def->pamEmp->pamHRUser->last_name}} </td>
                <td>{{ $def->pamEmp->pamHRUser->first_name}} </td>
                <td>{{ $def->pamEmp->pamHRUser->middle_name}} </td>
                <td>{{ $def->pamEmp->pamHRUser->dob}} </td>
                <td style="text-align: right; width: 20%">
                    {{ number_format($def->gross_earnings ,2, '.', ',')}}              
                    </td>
                    <td style="text-align: right; width: 20%">
                       
                        {{ isset($basicEarning) && is_numeric($basicEarning->fixed_amount) 
                            ? number_format($basicEarning->fixed_amount, 2, '.', ',') 
                            : '0.00' }}

                    </td>
                    <td style="text-align: right; width: 15%">
                        {{ isset($nhimaContribution) && is_numeric($nhimaContribution->amount) 
                            ? number_format($nhimaContribution->amount, 2, '.', ',') 
                            : '0.00' }}
                    </td>
                    <td style="text-align: right; width: 15%">
                        {{ number_format($item->amount ,2, '.', ',')}}  
                    </td>
                </tr>
                @endif
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endsection