Appraisers Payroll Report

@if (session()->has('success')) @endif @if (session()->has('error')) @endif
Important: Appraiser fees appear on payroll based on when the fee was created, not when the file is marked completed. Files can be in any status and the appraiser fee will still show on the report.
@if ($hasSearched && count($report_data) > 0) @endif
@if ($hasSearched)
Active Filters: From: {{ $from_date ?? 'N/A' }} To: {{ $to_date ?? 'N/A' }} @if($appraiser_id) Appraiser Selected @endif @if($franchise_id) Office Selected @endif
@endif @if($hasSearched && count($report_data) > 0)
Total Records

{{ number_format($summary['total_records']) }}

Total Amount

${{ number_format($summary['total_amount'], 2) }}

Paid

{{ number_format($summary['paid_count']) }} / ${{ number_format($summary['paid_amount'], 2) }}

Unpaid

{{ number_format($summary['unpaid_count']) }} / ${{ number_format($summary['unpaid_amount'], 2) }}

@endif @if($hasSearched && count($report_data) > 0)
Payroll Details
@php $rowNumber = 0; $grandTotal = 0; $grandTotalUnits = 0; @endphp @foreach($grouped_data as $appraiser_id => $group) @foreach($group['items'] as $data) @php $rowNumber++; $total = $data->appraiser_unit * $data->appraiser_amount; $grandTotal += $total; $grandTotalUnits += $data->appraiser_unit; @endphp @endforeach @endforeach
# File # Claim # Insurance Company Date Completed Type Description Units Unit Price Total Amount Paid Status
Appraiser: {{ $group['appraiser_name'] }}
{{ $rowNumber }} {{ $data->assignment->file_no }} {{ $data->assignment->claim_number }} {{ $data->assignment->insuranceCompany->company_name ?? 'N/A' }} {{ $data->assignment->complete_date ? \Carbon\Carbon::parse($data->assignment->complete_date)->format('M d, Y') : 'N/A' }} {{ $data->type ?? 'N/A' }} {{ $data->description }} {{ number_format($data->appraiser_unit, 2) }} ${{ number_format($data->appraiser_amount, 2) }} ${{ number_format($total, 2) }} @if ($data->paid) Paid @else Unpaid @endif
Subtotal for {{ $group['appraiser_name'] }}: {{ number_format($group['subtotal_units'], 2) }} ${{ number_format($group['subtotal'], 2) }}
GRAND TOTAL: {{ number_format($grandTotalUnits, 2) }} ${{ number_format($grandTotal, 2) }}
@elseif($hasSearched && count($report_data) == 0)
No Records Found

No payroll records match your search criteria. Please adjust your filters and try again.

@endif
@if ($showMarkAsPaidModal) @endif
@script @endscript